AuditEntry::record() - Code Metrics - Inspection of "show whole request url" - bedezign/yii2-audit - Measure and Improve Code Quality continuously with Scrutinizer

Completed

Pull Request — master (#264)

by Brett

created 2019-06-19 06:16 UTC

AuditEntry::record() A

↳ Parent: AuditEntry

Complexity

Conditions	4
Paths	6

Size

Total Lines

Duplication

Lines	0
Ratio	0 %

Code Coverage

Tests	12
CRAP Score	4.0466

Importance

Changes

Metric	Value
cc	4
nc	6
nop	0
dl	0
loc	17
ccs	12
cts	14
cp	0.8571
crap	4.0466
rs	9.7
c	0
b	0
f	0

<?php

namespace bedezign\yii2\audit\models;

use bedezign\yii2\audit\Audit;
use bedezign\yii2\audit\components\db\ActiveRecord;
use bedezign\yii2\audit\components\Helper;
use Yii;
use yii\db\ActiveQuery;
use yii\db\Expression;

/**
 * AuditEntry
 * @package bedezign\yii2\audit\models
 *
 * @property int               $id
 * @property string            $created
 * @property float             $duration
 * @property int               $user_id        0 means anonymous
 * @property string            $ip
 * @property string            $route
 * @property int               $memory_max
 * @property string            $request_method
 * @property string            $ajax
 *
 * @property AuditError[]      $linkedErrors
 * @property AuditJavascript[] $javascripts
 * @property AuditTrail[]      $trails
 * @property AuditMail[]       $mails
 * @property AuditData[]       $data
 */
class AuditEntry extends ActiveRecord
{
    /**
     * @var bool
     */
    protected $autoSerialize = false;

    /**
     * @inheritdoc
     */
    public static function tableName()
    {
        return '{{%audit_entry}}';
    }

    /**
     * @param bool $initialise
     * @return static
     */
    public static function create($initialise = true)
    {
        $entry = new static;
        if ($initialise)
            $entry->record();

        return $entry;
    }

    /**
     * Returns all linked AuditError instances
     * (Called `linkedErrors()` to avoid confusion with the `getErrors()` method)
     * @return ActiveQuery
     */
    public function getLinkedErrors()
    {
        return static::hasMany(AuditError::className(), ['entry_id' => 'id']);
    }

    /**
     * Returns all linked AuditTrail instances
     * @return ActiveQuery
     */
    public function getTrails()
    {
        return static::hasMany(AuditTrail::className(), ['entry_id' => 'id']);
    }

    /**
     * Returns all linked AuditMail instances
     * @return ActiveQuery
     */
    public function getMails()
    {
        return static::hasMany(AuditMail::className(), ['entry_id' => 'id']);
    }

    /**
     * Returns all linked AuditJavascript instances
     * @return ActiveQuery
     */
    public function getJavascripts()
    {
        return static::hasMany(AuditJavascript::className(), ['entry_id' => 'id']);
    }

    /**
     * Returns all linked data records
     * @return ActiveQuery
     */
    public function getData()
    {
        return static::hasMany(AuditData::className(), ['entry_id' => 'id'])->indexBy('type');
    }

    /**
     * Writes a number of associated data records in one go.
     * @param      $batchData
     * @param bool $compact
     * @throws \yii\db\Exception
     */
    public function addBatchData($batchData, $compact = true)
    {
        $columns = ['entry_id', 'type', 'created', 'data'];
        $rows = [];
        $params = [];
        $date = date('Y-m-d H:i:s');
        // Some database like postgres depend on the data being escaped correctly.
        // PDO can take care of this if you define the field as a LOB (Large OBject), but unfortunately Yii does threat values
        // for batch inserts the same way. This code adds a number of literals instead of the actual values
        // so that they can be bound right before insert and still get escaped correctly
        foreach ($batchData as $type => $data) {
            $param = ':data_' . str_replace('/', '_', $type);
            $rows[] = [$this->id, $type, $date, new Expression($param)];
            $params[$param] = [Helper::serialize($data, $compact), \PDO::PARAM_LOB];
        }
        static::getDb()->createCommand()->batchInsert(AuditData::tableName(), $columns, $rows)->bindValues($params)->execute();
    }

    /**
     * @param $type
     * @param $data
     * @param bool|true $compact
     * @throws \yii\db\Exception
     */
    public function addData($type, $data, $compact = true)
    {
        // Make sure to mark data as a large object so it gets escaped
        $record = [
            'entry_id' => $this->id,
            'type' => $type,
            'created' => date('Y-m-d H:i:s'),
            'data' => [Helper::serialize($data, $compact), \PDO::PARAM_LOB],
        ];
        static::getDb()->createCommand()->insert(AuditData::tableName(), $record)->execute();
    }

    /**
     * Records the current application state into the instance.
     */
    public function record()
    {
        $app = Yii::$app;
        $request = $app->request;

        $this->route = $app->requestedAction ? $app->requestedAction->uniqueId : null;
        if ($request instanceof \yii\web\Request) {
            $this->user_id        = Audit::getInstance()->getUserId();
            $this->ip             = $this->getUserIP();
            $this->ajax           = $request->isAjax;
            $this->request_method = $request->method;
        } else if ($request instanceof \yii\console\Request) {
            $this->request_method = 'CLI';
        }

        $this->save(false);
    }

    /**
     * @return bool
     */
    public function finalize()
    {
        $app = Yii::$app;
        $request = $app->request;

        if (!$this->user_id && $request instanceof \yii\web\Request) {
            $this->user_id = Audit::getInstance()->getUserId();
        }

        $this->duration = microtime(true) - YII_BEGIN_TIME;
        $this->memory_max = memory_get_peak_usage();
        return $this->save(false, ['duration', 'memory_max', 'user_id']);
    }

    /**
     * @return array
     */
    public function attributeLabels()
    {
        return [
            'id'             => Yii::t('audit', 'Entry ID'),
            'created'        => Yii::t('audit', 'Created'),
            'ip'             => Yii::t('audit', 'IP'),
            'duration'       => Yii::t('audit', 'Duration'),
            'user_id'        => Yii::t('audit', 'User'),
            'memory_max'     => Yii::t('audit', 'Memory'),
            'request_method' => Yii::t('audit', 'Request Method'),
        ];
    }

    /**
     * @return bool
     */
    public function hasRelatedData()
    {
        if ($this->getLinkedErrors()->count()) {
            return true;
        }
        if ($this->getJavascripts()->count()) {
            return true;
        }
        if ($this->getMails()->count()) {
            return true;
        }
        if ($this->getTrails()->count()) {
            return true;
        }
        return false;
    }

    /**
     * @return string
     */
    public function getUserIP()
    {
        if (!empty($_SERVER['HTTP_X_FORWARDED_FOR'])) {
            return current(array_values(array_filter(explode(',', $_SERVER['HTTP_X_FORWARDED_FOR']))));
        }
        return isset($_SERVER['REMOTE_ADDR']) ? $_SERVER['REMOTE_ADDR'] : null;
    }

    /**
     * @param AuditEntry $auditEntry
/**
 * @param array $germany
 * @param array $island
 * @param array $italy
 */
function finale($germany, $island) {
    return "2:1";
}
     * @return bool|string
     */
    public static function getRequestUrl()
    {
        $data = ArrayHelper::getColumn($this->data, 'data');

        if (!isset($data['audit/request']) || !is_array($data['audit/request'])) {
            return Url::to([$this->route ?: '/'], 'https');
        }
        $request = $data['audit/request'];
        $route = $this->route ?: (!empty($request['route']) ? $request['route'] : '/');
        return Url::to(ArrayHelper::merge([$route], $request['GET']), 'https');
    }

}


1		<?php
2
3		namespace bedezign\yii2\audit\models;
4
5		use bedezign\yii2\audit\Audit;
6		use bedezign\yii2\audit\components\db\ActiveRecord;
7		use bedezign\yii2\audit\components\Helper;
8		use Yii;
9		use yii\db\ActiveQuery;
10		use yii\db\Expression;
11
12		/**
13		* AuditEntry
14		* @package bedezign\yii2\audit\models
15		*
16		* @property int $id
17		* @property string $created
18		* @property float $duration
19		* @property int $user_id 0 means anonymous
20		* @property string $ip
21		* @property string $route
22		* @property int $memory_max
23		* @property string $request_method
24		* @property string $ajax
25		*
26		* @property AuditError[] $linkedErrors
27		* @property AuditJavascript[] $javascripts
28		* @property AuditTrail[] $trails
29		* @property AuditMail[] $mails
30		* @property AuditData[] $data
31		*/
32		class AuditEntry extends ActiveRecord
33		{
34		/**
35		* @var bool
36		*/
37		protected $autoSerialize = false;
38
39		/**
40		* @inheritdoc
41		*/
42	195	public static function tableName()
43		{
44	195	return '{{%audit_entry}}';
45		}
46
47		/**
48		* @param bool $initialise
49		* @return static
50		*/
51	117	public static function create($initialise = true)
52		{
53	117	$entry = new static;
54		if ($initialise)
55	117	$entry->record();
56
57	117	return $entry;
58		}
59
60		/**
61		* Returns all linked AuditError instances
62		* (Called `linkedErrors()` to avoid confusion with the `getErrors()` method)
63		* @return ActiveQuery
64		*/
65	9	public function getLinkedErrors()
66		{
67	9	return static::hasMany(AuditError::className(), ['entry_id' => 'id']);
68		}
69
70		/**
71		* Returns all linked AuditTrail instances
72		* @return ActiveQuery
73		*/
74	9	public function getTrails()
75		{
76	9	return static::hasMany(AuditTrail::className(), ['entry_id' => 'id']);
77		}
78
79		/**
80		* Returns all linked AuditMail instances
81		* @return ActiveQuery
82		*/
83	9	public function getMails()
84		{
85	9	return static::hasMany(AuditMail::className(), ['entry_id' => 'id']);
86		}
87
88		/**
89		* Returns all linked AuditJavascript instances
90		* @return ActiveQuery
91		*/
92	9	public function getJavascripts()
93		{
94	9	return static::hasMany(AuditJavascript::className(), ['entry_id' => 'id']);
95		}
96
97		/**
98		* Returns all linked data records
99		* @return ActiveQuery
100		*/
101	3	public function getData()
102		{
103	3	return static::hasMany(AuditData::className(), ['entry_id' => 'id'])->indexBy('type');
104		}
105
106		/**
107		* Writes a number of associated data records in one go.
108		* @param $batchData
109		* @param bool $compact
110		* @throws \yii\db\Exception
111		*/
112	45	public function addBatchData($batchData, $compact = true)
113		{
114	45	$columns = ['entry_id', 'type', 'created', 'data'];
115	45	$rows = [];
116	45	$params = [];
117	45	$date = date('Y-m-d H:i:s');
118		// Some database like postgres depend on the data being escaped correctly.
119		// PDO can take care of this if you define the field as a LOB (Large OBject), but unfortunately Yii does threat values
120		// for batch inserts the same way. This code adds a number of literals instead of the actual values
121		// so that they can be bound right before insert and still get escaped correctly
122	45	foreach ($batchData as $type => $data) {
123	45	$param = ':data_' . str_replace('/', '_', $type);
124	45	$rows[] = [$this->id, $type, $date, new Expression($param)];
125	45	$params[$param] = [Helper::serialize($data, $compact), \PDO::PARAM_LOB];
126	45	}
127	45	static::getDb()->createCommand()->batchInsert(AuditData::tableName(), $columns, $rows)->bindValues($params)->execute();
128	45	}
129
130		/**
131		* @param $type
132		* @param $data
133		* @param bool\|true $compact
134		* @throws \yii\db\Exception
135		*/
136	6	public function addData($type, $data, $compact = true)
137		{
138		// Make sure to mark data as a large object so it gets escaped
139		$record = [
140	6	'entry_id' => $this->id,
141	6	'type' => $type,
142	6	'created' => date('Y-m-d H:i:s'),
143	6	'data' => [Helper::serialize($data, $compact), \PDO::PARAM_LOB],
144	6	];
145	6	static::getDb()->createCommand()->insert(AuditData::tableName(), $record)->execute();
146	6	}
147
148		/**
149		* Records the current application state into the instance.
150		*/
151	117	public function record()
152		{
153	117	$app = Yii::$app;
154	117	$request = $app->request;
155
156	117	$this->route = $app->requestedAction ? $app->requestedAction->uniqueId : null;
157	117	if ($request instanceof \yii\web\Request) {
158	117	$this->user_id = Audit::getInstance()->getUserId();
159	117	$this->ip = $this->getUserIP();
160	117	$this->ajax = $request->isAjax;
161	117	$this->request_method = $request->method;
162	117	} else if ($request instanceof \yii\console\Request) {
163		$this->request_method = 'CLI';
164		}
165
166	117	$this->save(false);
167	117	}
168
169		/**
170		* @return bool
171		*/
172	75	public function finalize()
173		{
174	75	$app = Yii::$app;
175	75	$request = $app->request;
176
177	75	if (!$this->user_id && $request instanceof \yii\web\Request) {
178	75	$this->user_id = Audit::getInstance()->getUserId();
179	75	}
180
181	75	$this->duration = microtime(true) - YII_BEGIN_TIME;
182	75	$this->memory_max = memory_get_peak_usage();
183	75	return $this->save(false, ['duration', 'memory_max', 'user_id']);
184		}
185
186		/**
187		* @return array
188		*/
189	15	public function attributeLabels()
190		{
191		return [
192	15	'id' => Yii::t('audit', 'Entry ID'),
193	15	'created' => Yii::t('audit', 'Created'),
194	15	'ip' => Yii::t('audit', 'IP'),
195	15	'duration' => Yii::t('audit', 'Duration'),
196	15	'user_id' => Yii::t('audit', 'User'),
197	15	'memory_max' => Yii::t('audit', 'Memory'),
198	15	'request_method' => Yii::t('audit', 'Request Method'),
199	15	];
200		}
201
202		/**
203		* @return bool
204		*/
205		public function hasRelatedData()
206		{
207		if ($this->getLinkedErrors()->count()) {
208		return true;
209		}
210		if ($this->getJavascripts()->count()) {
211		return true;
212		}
213		if ($this->getMails()->count()) {
214		return true;
215		}
216		if ($this->getTrails()->count()) {
217		return true;
218		}
219		return false;
220		}
221
222		/**
223		* @return string
224		*/
225		public function getUserIP()
226		{
227		if (!empty($_SERVER['HTTP_X_FORWARDED_FOR'])) {
228		return current(array_values(array_filter(explode(',', $_SERVER['HTTP_X_FORWARDED_FOR']))));
229		}
230		return isset($_SERVER['REMOTE_ADDR']) ? $_SERVER['REMOTE_ADDR'] : null;
231		}
232
233		/**
234		* @param AuditEntry $auditEntry
		0 ignored issues – show Bug introduced 2019-06-19 06:27 UTC by Report Bug Copy Issue Report There is no parameter named `$auditEntry`. Was it maybe removed? This check looks for PHPDoc comments describing methods or function parameters that do not exist on the corresponding method or function. Consider the following example. The parameter `$italy` is not defined by the method `finale(...)`. /** * @param array $germany * @param array $island * @param array $italy */ function finale($germany, $island) { return "2:1"; } The most likely cause is that the parameter was removed, but the annotation was not. Loading history...
235		* @return bool\|string
236		*/
237		public static function getRequestUrl()
238		{
239		$data = ArrayHelper::getColumn($this->data, 'data');
		0 ignored issues – show Bug introduced 2019-06-19 06:27 UTC by Report Bug Copy Issue Report The variable `$this` does not exist. Did you forget to declare it? This check marks access to variables or properties that have not been declared yet. While PHP has no explicit notion of declaring a variable, accessing it before a value is assigned to it is most likely a bug. Loading history...
240		if (!isset($data['audit/request']) \|\| !is_array($data['audit/request'])) {
241		return Url::to([$this->route ?: '/'], 'https');
242		}
243		$request = $data['audit/request'];
244		$route = $this->route ?: (!empty($request['route']) ? $request['route'] : '/');
245		return Url::to(ArrayHelper::merge([$route], $request['GET']), 'https');
246		}
247
248		}
249

bedezign / yii2-audit

GitHub Access Token became invalid

Pull Request — master (#264)

AuditEntry::record() A

Complexity

Size

Duplication

Code Coverage

Importance

Duplication Side-by-Side

Filter issues like