From: Dmitry Dobryshin Date: Tue, 12 Jan 2021 05:21:57 +0000 (+0300) Subject: Изменён тип хранения информации о проинвентаризированных, учтённых, и непроверенных... X-Git-Url: http://git.osdn.net/view?p=invent%2Finvent.git;a=commitdiff_plain;h=6a4e0c86e4e59436b1e52efd10fdf0cfdf345712 Изменён тип хранения информации о проинвентаризированных, учтённых, и непроверенных предметах/оборудовании --- diff --git a/controllers/ItemsController.php b/controllers/ItemsController.php index 89b8910..40d6016 100644 --- a/controllers/ItemsController.php +++ b/controllers/ItemsController.php @@ -101,7 +101,7 @@ class ItemsController extends Controller $item->os = isset($options[ 'os' ]) ? $options[ 'os' ] : NULL; // Операционная система $item->mac = isset($options[ 'mac' ]) ? $options[ 'mac' ] : NULL; // MAC-адрес $item->serial = isset($options[ 'serial' ]) ? $options[ 'serial' ] : NULL; // Серийный номер - $item->checked = false; // Не инвентризирован (требует внимания после импорта) + $item->checked = 2; // Не инвентризирован (требует внимания после импорта) // Сохраняем запись if ($item->validate() && $item->save()) { @@ -180,7 +180,8 @@ class ItemsController extends Controller $modelS = Moving::find() ->select('item_id') ->joinWith('status') - ->Where([ 'ilike', Status::tableName() . '.name', 'Списано' ]); + ->Where([ 'ilike', Status::tableName() . '.name', 'Списано' ]) + ->orWhere( [ 'checked' => 2 ] ); // Получаем список всех предметов/оборудования, кроме списанного $model = Items::find() @@ -189,7 +190,7 @@ class ItemsController extends Controller ->all(); // Устанавливаем флаг непроинвентаризированных для всех предметов/оборудования из полученного списка. - Items::updateAll([ 'checked' => false ], [ 'in', 'id', $model ]); + Items::updateAll([ 'checked' => 0 ], [ 'in', 'id', $model ]); // Переход к списку предметов/оборудования. return $this->redirect([ 'index' ]); @@ -222,7 +223,7 @@ class ItemsController extends Controller { foreach ($items as $row) { - if ($row->checked) + if ( $row->checked == 1 ) { // Этот инвентарный номер был учтён $color = ' color="#FF0000"'; @@ -241,7 +242,7 @@ class ItemsController extends Controller $message .= Yii::t('items', 'Not found!') . ' ' . Yii::t('items', 'Inventory number') . ': ' . trim($keys[ 0 ]); } // Отмечаем проинвентаризированными все найденные предметы/оборудование - Items::updateAll([ 'checked' => TRUE ], [ 'invent' => trim($keys[ 0 ]), 'serial' => trim($keys[ 1 ]) ]); + Items::updateAll([ 'checked' => 1 ], [ 'invent' => trim($keys[ 0 ]), 'serial' => trim($keys[ 1 ]) ]); if ($message != '') if ( $color == ' color = "#FF8830"') @@ -362,7 +363,7 @@ class ItemsController extends Controller { // Проверка, что предмет/оборудование уже были в базе $item = Items::find()->where([ 'id' => $item[ 'id' ]])->one(); - if ($item->checked === TRUE) + if ($item->checked < 2) { $arrayReturn[ 'countExists' ]++; } @@ -415,7 +416,7 @@ class ItemsController extends Controller else { // Запись не удалась, пробуем удалить предмет/оборудование - Items::find()->where([ 'id' => $item[ 'id' ], 'checked' => FALSE ])->one()->delete(); + Items::find()->where([ 'id' => $item[ 'id' ], 'checked' => 2 ])->one()->delete(); // Сообщим об ошибке $arrayReturn[ 'countErrors' ]++; $arrayReturn[ 'errors' ] .= '
' . Yii::t('import', 'Moving: {date} (') . $moving->errors['date'][0]. Yii::t('import', '), Inventory number:{invent}, model: {model}, location: {location} ( {region} )' , $row); @@ -649,7 +650,7 @@ class ItemsController extends Controller return $this->redirect([ 'site/index' ]); } $model = new Items(); // Новый предмет/оборудование - $model->checked = TRUE; + $model->checked = 1; $modelm = new Moving(); if ($model->load(Yii::$app->request->post()) && $model->save()) { @@ -705,7 +706,7 @@ class ItemsController extends Controller } $origin = Items::find()->where([ 'id' => $is ])->one(); $model = new Items(); - $model->checked = TRUE; + $model->checked = 1; $modelm = new Moving(); if ($model->load(Yii::$app->request->post()) && $model->save()) { diff --git a/migrations/m210111_120758_modify_items_table.php b/migrations/m210111_120758_modify_items_table.php new file mode 100644 index 0000000..f74d2f0 --- /dev/null +++ b/migrations/m210111_120758_modify_items_table.php @@ -0,0 +1,69 @@ +createTable($templateTable, [ + 'id' => $this->primaryKey(), + 'checked' => $this->boolean(), + ]); + $list = (new \yii\db\Query()) + ->select([ 'id', 'checked' ]) + ->from($table) + ->all(); + $this->batchInsert($templateTable, [ 'id', 'checked' ], $list); + $this->dropColumn($table, 'checked'); + $this->addColumn($table, 'checked', $this->integer()); + $list = (new \yii\db\Query()) + ->select('id') + ->from($templateTable) + ->where(['checked' => TRUE ]) + ->all(); + $this->update($table, [ 'checked' => 1 ], [ 'in', 'id', $list ]); + $list = (new \yii\db\Query()) + ->select('id') + ->from($templateTable) + ->where([ 'checked' => FALSE ]) + ->all(); + $this->update($table, [ 'checked' => 2 ], [ 'in', 'id', $list ]); + $this->dropTable($templateTable); + } + + /** + * {@inheritdoc} + */ + public function safeDown() + { + echo "m210111_120758_modify_items_table cannot be reverted.\n"; + + return false; + } + + /* + // Use up()/down() to run migration code without a transaction. + public function up() + { + + } + + public function down() + { + echo "m210111_120758_modify_items_table cannot be reverted.\n"; + + return false; + } + */ +} diff --git a/models/Items.php b/models/Items.php index 0fca5b3..ea231a2 100644 --- a/models/Items.php +++ b/models/Items.php @@ -51,7 +51,7 @@ class Items extends \yii\db\ActiveRecord [[ 'mac' ], 'string', 'max' => 20 ], [[ 'invent' ], 'string', 'max' => 50 ], [[ 'model_id' ], 'integer' ], - [[ 'checked' ], 'boolean' ], + [[ 'checked' ], 'integer' ], ]; } diff --git a/models/ItemsSearch.php b/models/ItemsSearch.php index 9175645..b3dbe9a 100644 --- a/models/ItemsSearch.php +++ b/models/ItemsSearch.php @@ -68,7 +68,7 @@ class ItemsSearch extends Items Status::tableName() . '.name AS statusName ') ->joinWith([ 'types', 'moving', 'status', 'locations', 'regions', 'models', ]) ->where([ 'in', Moving::tableName() . '.id', $query ]) - ->andWhere([ 'checked' => false ]); + ->andWhere([ 'checked' => 0 ]); $dataProvider = new ActiveDataProvider([ 'query' => $query, diff --git a/models/LocationsSearch.php b/models/LocationsSearch.php index 838688b..79a12b3 100644 --- a/models/LocationsSearch.php +++ b/models/LocationsSearch.php @@ -46,7 +46,7 @@ class LocationsSearch extends Locations ->innerJoin([ 'm' => Moving::find() ->select('MAX(' . Moving::tableName() . '.id) AS mid') ->joinWith([ 'items' ]) - ->where([ Items::tableName() . '.checked' => false ]) + ->where([ Items::tableName() . '.checked' => 0 ]) ->groupBy([ 'item_id' ]) ], 'id = m.mid') ], Locations::tableName() . '.id = m.location_id'); diff --git a/models/Site.php b/models/Site.php index 34c891f..f5870f3 100644 --- a/models/Site.php +++ b/models/Site.php @@ -31,7 +31,7 @@ class Site extends \yii\data\ActiveDataProvider ->select(Regions::tableName() . '.id, ' . Items::tableName() . '.id AS tid') ->joinWith(['locations', 'moving', 'items']) ->where(['in', Moving::tableName() . '.id', $subQuery]) - ->andWhere(Items::tableName() . '.checked = true') + ->andWhere(Items::tableName() . '.checked = 1') ], Regions::tableName() . '.id = c.id AND ' . Items::tableName() . '.id = c.tid') ->groupBy(Regions::tableName() . '.id') ->where(['in', Moving::tableName() . '.id', $subQuery]); @@ -56,7 +56,7 @@ class Site extends \yii\data\ActiveDataProvider ->joinWith([ 'items', 'models' ]) ->leftJoin(['c' => Items::find() ->select('id AS tid') - ->where(['checked' => true ]) + ->where(['checked' => 1 ]) ], Items::tableName() . '.id = c.tid') ->groupBy(Types::tableName() . '.id'); diff --git a/runtime/debug/index.data b/runtime/debug/index.data index be8905f..1896bff 100644 --- a/runtime/debug/index.data +++ b/runtime/debug/index.data @@ -1 +1 @@ -a:58:{s:13:"5fec469aef2ce";a:12:{s:3:"tag";s:13:"5fec469aef2ce";s:3:"url";s:61:"https://192.168.0.32/invent/index.php?r=items%2Fupdate&id=638";s:4:"ajax";i:0;s:6:"method";s:3:"GET";s:2:"ip";s:12:"192.168.0.80";s:4:"time";d:1609320090.956787;s:10:"statusCode";i:200;s:8:"sqlCount";i:39;s:9:"mailCount";i:0;s:9:"mailFiles";a:0:{}s:10:"peakMemory";i:8717672;s:14:"processingTime";d:0.12865304946899414;}s:13:"5fec469eea372";a:12:{s:3:"tag";s:13:"5fec469eea372";s:3:"url";s:60:"http://192.168.0.32/invent/index.php?r=items%2Fupdate&id=645";s:4:"ajax";i:0;s:6:"method";s:4:"POST";s:2:"ip";s:12:"192.168.0.68";s:4:"time";d:1609320094.940789;s:10:"statusCode";i:302;s:8:"sqlCount";i:11;s:9:"mailCount";i:0;s:9:"mailFiles";a:0:{}s:10:"peakMemory";i:1915888;s:14:"processingTime";d:0.05831193923950195;}s:13:"5fec469f10744";a:12:{s:3:"tag";s:13:"5fec469f10744";s:3:"url";s:59:"http://192.168.0.32/invent/index.php?r=items%2Findex&id=645";s:4:"ajax";i:0;s:6:"method";s:3:"GET";s:2:"ip";s:12:"192.168.0.68";s:4:"time";d:1609320095.023083;s:10:"statusCode";i:302;s:8:"sqlCount";i:20;s:9:"mailCount";i:0;s:9:"mailFiles";a:0:{}s:10:"peakMemory";i:62387416;s:14:"processingTime";d:0.7984311580657959;}s:13:"5fec46a007383";a:12:{s:3:"tag";s:13:"5fec46a007383";s:3:"url";s:60:"http://192.168.0.32/invent/index.php?r=items%2Findex&page=13";s:4:"ajax";i:0;s:6:"method";s:3:"GET";s:2:"ip";s:12:"192.168.0.68";s:4:"time";d:1609320096.00887;s:10:"statusCode";i:200;s:8:"sqlCount";i:56;s:9:"mailCount";i:0;s:9:"mailFiles";a:0:{}s:10:"peakMemory";i:3113248;s:14:"processingTime";d:0.08694911003112793;}s:13:"5fec46a49a8aa";a:12:{s:3:"tag";s:13:"5fec46a49a8aa";s:3:"url";s:65:"http://192.168.0.32/invent/index.php?r=items%2Fprint&id%5B%5D=645";s:4:"ajax";i:0;s:6:"method";s:3:"GET";s:2:"ip";s:12:"192.168.0.68";s:4:"time";d:1609320100.603137;s:10:"statusCode";i:200;s:8:"sqlCount";i:17;s:9:"mailCount";i:0;s:9:"mailFiles";a:0:{}s:10:"peakMemory";i:9042192;s:14:"processingTime";d:0.08386993408203125;}s:13:"5fec46b0042dc";a:12:{s:3:"tag";s:13:"5fec46b0042dc";s:3:"url";s:61:"https://192.168.0.32/invent/index.php?r=items%2Fupdate&id=638";s:4:"ajax";i:0;s:6:"method";s:3:"GET";s:2:"ip";s:12:"192.168.0.80";s:4:"time";d:1609320111.996439;s:10:"statusCode";i:200;s:8:"sqlCount";i:39;s:9:"mailCount";i:0;s:9:"mailFiles";a:0:{}s:10:"peakMemory";i:8717336;s:14:"processingTime";d:0.14737701416015625;}s:13:"5fec46b7221ee";a:12:{s:3:"tag";s:13:"5fec46b7221ee";s:3:"url";s:54:"https://192.168.0.32/invent/index.php?r=site%2Fcontact";s:4:"ajax";i:0;s:6:"method";s:3:"GET";s:2:"ip";s:12:"192.168.0.80";s:4:"time";d:1609320119.093628;s:10:"statusCode";i:200;s:8:"sqlCount";i:11;s:9:"mailCount";i:0;s:9:"mailFiles";a:0:{}s:10:"peakMemory";i:2185608;s:14:"processingTime";d:0.07182812690734863;}s:13:"5fec46b73f06d";a:12:{s:3:"tag";s:13:"5fec46b73f06d";s:3:"url";s:80:"https://192.168.0.32/invent/index.php?r=site%2Fcaptcha&v=5fec46b7250831.27755520";s:4:"ajax";i:0;s:6:"method";s:3:"GET";s:2:"ip";s:12:"192.168.0.80";s:4:"time";d:1609320119.21544;s:10:"statusCode";i:200;s:8:"sqlCount";i:3;s:9:"mailCount";i:0;s:9:"mailFiles";a:0:{}s:10:"peakMemory";i:1760336;s:14:"processingTime";d:0.045684099197387695;}s:13:"5fec46b885686";a:12:{s:3:"tag";s:13:"5fec46b885686";s:3:"url";s:53:"https://192.168.0.32/invent/index.php?r=items%2Findex";s:4:"ajax";i:0;s:6:"method";s:3:"GET";s:2:"ip";s:12:"192.168.0.80";s:4:"time";d:1609320120.531623;s:10:"statusCode";i:200;s:8:"sqlCount";i:56;s:9:"mailCount";i:0;s:9:"mailFiles";a:0:{}s:10:"peakMemory";i:3025640;s:14:"processingTime";d:0.07856583595275879;}s:13:"5fec46c37a793";a:12:{s:3:"tag";s:13:"5fec46c37a793";s:3:"url";s:208:"https://192.168.0.32/invent/index.php?ItemsSearch%5Binvent%5D=1360167&ItemsSearch%5Bserial%5D=&ItemsSearch%5BmodelName%5D=&ItemsSearch%5BregionName%5D=&ItemsSearch%5BstatusName%5D=&r=items%2Findex&_pjax=%23p0";s:4:"ajax";i:1;s:6:"method";s:3:"GET";s:2:"ip";s:12:"192.168.0.80";s:4:"time";d:1609320131.4791;s:10:"statusCode";i:200;s:8:"sqlCount";i:48;s:9:"mailCount";i:0;s:9:"mailFiles";a:0:{}s:10:"peakMemory";i:2619112;s:14:"processingTime";d:0.07698988914489746;}s:13:"5fec46c94f405";a:12:{s:3:"tag";s:13:"5fec46c94f405";s:3:"url";s:73:"https://192.168.0.32/invent/index.php?r=items%2Fupdate&id=761&_pjax=%23p0";s:4:"ajax";i:1;s:6:"method";s:3:"GET";s:2:"ip";s:12:"192.168.0.80";s:4:"time";d:1609320137.30655;s:10:"statusCode";i:200;s:8:"sqlCount";i:39;s:9:"mailCount";i:0;s:9:"mailFiles";a:0:{}s:10:"peakMemory";i:8719920;s:14:"processingTime";d:0.12591195106506348;}s:13:"5fec46c97d789";a:12:{s:3:"tag";s:13:"5fec46c97d789";s:3:"url";s:61:"https://192.168.0.32/invent/index.php?r=items%2Fupdate&id=761";s:4:"ajax";i:0;s:6:"method";s:3:"GET";s:2:"ip";s:12:"192.168.0.80";s:4:"time";d:1609320137.494564;s:10:"statusCode";i:200;s:8:"sqlCount";i:39;s:9:"mailCount";i:0;s:9:"mailFiles";a:0:{}s:10:"peakMemory";i:8718000;s:14:"processingTime";d:0.12287616729736328;}s:13:"5fec46f477826";a:12:{s:3:"tag";s:13:"5fec46f477826";s:3:"url";s:73:"http://192.168.0.32/invent/index.php?r=items%2Findex&page=262&_pjax=%23p0";s:4:"ajax";i:1;s:6:"method";s:3:"GET";s:2:"ip";s:12:"192.168.0.68";s:4:"time";d:1609320180.460278;s:10:"statusCode";i:200;s:8:"sqlCount";i:48;s:9:"mailCount";i:0;s:9:"mailFiles";a:0:{}s:10:"peakMemory";i:2798056;s:14:"processingTime";d:0.09598898887634277;}s:13:"5fec46feb32c1";a:12:{s:3:"tag";s:13:"5fec46feb32c1";s:3:"url";s:97:"http://192.168.0.32/invent/index.php?r=items%2Findex&page=262&_pjax=%23p0&sort=serial&_pjax=%23p0";s:4:"ajax";i:1;s:6:"method";s:3:"GET";s:2:"ip";s:12:"192.168.0.68";s:4:"time";d:1609320190.704096;s:10:"statusCode";i:200;s:8:"sqlCount";i:48;s:9:"mailCount";i:0;s:9:"mailFiles";a:0:{}s:10:"peakMemory";i:2880680;s:14:"processingTime";d:0.10034298896789551;}s:13:"5fec4706b5ea6";a:12:{s:3:"tag";s:13:"5fec4706b5ea6";s:3:"url";s:224:"http://192.168.0.32/invent/index.php?ItemsSearch%5Binvent%5D=&ItemsSearch%5Bserial%5D=&ItemsSearch%5BmodelName%5D=bmq&ItemsSearch%5BregionName%5D=&ItemsSearch%5BstatusName%5D=&r=items%2Findex&page=262&sort=serial&_pjax=%23p0";s:4:"ajax";i:1;s:6:"method";s:3:"GET";s:2:"ip";s:12:"192.168.0.68";s:4:"time";d:1609320198.726046;s:10:"statusCode";i:200;s:8:"sqlCount";i:37;s:9:"mailCount";i:0;s:9:"mailFiles";a:0:{}s:10:"peakMemory";i:2515864;s:14:"processingTime";d:0.05924797058105469;}s:13:"5fec470c45a6d";a:12:{s:3:"tag";s:13:"5fec470c45a6d";s:3:"url";s:225:"http://192.168.0.32/invent/index.php?ItemsSearch%5Binvent%5D=&ItemsSearch%5Bserial%5D=&ItemsSearch%5BmodelName%5D=benq&ItemsSearch%5BregionName%5D=&ItemsSearch%5BstatusName%5D=&r=items%2Findex&page=262&sort=serial&_pjax=%23p0";s:4:"ajax";i:1;s:6:"method";s:3:"GET";s:2:"ip";s:12:"192.168.0.68";s:4:"time";d:1609320204.241036;s:10:"statusCode";i:200;s:8:"sqlCount";i:48;s:9:"mailCount";i:0;s:9:"mailFiles";a:0:{}s:10:"peakMemory";i:2609408;s:14:"processingTime";d:0.12128996849060059;}s:13:"5fec47303a0ef";a:12:{s:3:"tag";s:13:"5fec47303a0ef";s:3:"url";s:225:"http://192.168.0.32/invent/index.php?ItemsSearch%5Binvent%5D=&ItemsSearch%5Bserial%5D=&ItemsSearch%5BmodelName%5D=acer&ItemsSearch%5BregionName%5D=&ItemsSearch%5BstatusName%5D=&r=items%2Findex&page=262&sort=serial&_pjax=%23p0";s:4:"ajax";i:1;s:6:"method";s:3:"GET";s:2:"ip";s:12:"192.168.0.68";s:4:"time";d:1609320240.222478;s:10:"statusCode";i:200;s:8:"sqlCount";i:48;s:9:"mailCount";i:0;s:9:"mailFiles";a:0:{}s:10:"peakMemory";i:2817528;s:14:"processingTime";d:0.08430600166320801;}s:13:"5fec475260487";a:12:{s:3:"tag";s:13:"5fec475260487";s:3:"url";s:223:"http://192.168.0.32/invent/index.php?ItemsSearch%5Binvent%5D=&ItemsSearch%5Bserial%5D=&ItemsSearch%5BmodelName%5D=19&ItemsSearch%5BregionName%5D=&ItemsSearch%5BstatusName%5D=&r=items%2Findex&page=262&sort=serial&_pjax=%23p0";s:4:"ajax";i:1;s:6:"method";s:3:"GET";s:2:"ip";s:12:"192.168.0.68";s:4:"time";d:1609320274.37523;s:10:"statusCode";i:200;s:8:"sqlCount";i:48;s:9:"mailCount";i:0;s:9:"mailFiles";a:0:{}s:10:"peakMemory";i:2645840;s:14:"processingTime";d:0.0940399169921875;}s:13:"5fec475708a12";a:12:{s:3:"tag";s:13:"5fec475708a12";s:3:"url";s:233:"http://192.168.0.32/invent/index.php?r=items%2Findex&ItemsSearch%5Binvent%5D=&ItemsSearch%5Bserial%5D=&ItemsSearch%5BmodelName%5D=19&ItemsSearch%5BregionName%5D=&ItemsSearch%5BstatusName%5D=&page=1&sort=serial&_pjax=%23p0&_pjax=%23p0";s:4:"ajax";i:1;s:6:"method";s:3:"GET";s:2:"ip";s:12:"192.168.0.68";s:4:"time";d:1609320278.991229;s:10:"statusCode";i:200;s:8:"sqlCount";i:48;s:9:"mailCount";i:0;s:9:"mailFiles";a:0:{}s:10:"peakMemory";i:2909312;s:14:"processingTime";d:0.12742114067077637;}s:13:"5fec47d42e6cc";a:12:{s:3:"tag";s:13:"5fec47d42e6cc";s:3:"url";s:61:"http://192.168.0.32/invent/index.php?r=items%2Fupdate&id=1768";s:4:"ajax";i:0;s:6:"method";s:3:"GET";s:2:"ip";s:12:"192.168.0.68";s:4:"time";d:1609320404.171299;s:10:"statusCode";i:200;s:8:"sqlCount";i:39;s:9:"mailCount";i:0;s:9:"mailFiles";a:0:{}s:10:"peakMemory";i:8696872;s:14:"processingTime";d:0.13210701942443848;}s:13:"5fec47d5976b8";a:12:{s:3:"tag";s:13:"5fec47d5976b8";s:3:"url";s:61:"http://192.168.0.32/invent/index.php?r=items%2Fupdate&id=1764";s:4:"ajax";i:0;s:6:"method";s:3:"GET";s:2:"ip";s:12:"192.168.0.68";s:4:"time";d:1609320405.591608;s:10:"statusCode";i:200;s:8:"sqlCount";i:39;s:9:"mailCount";i:0;s:9:"mailFiles";a:0:{}s:10:"peakMemory";i:8696880;s:14:"processingTime";d:0.1325829029083252;}s:13:"5fec47dc02677";a:12:{s:3:"tag";s:13:"5fec47dc02677";s:3:"url";s:53:"https://192.168.0.32/invent/index.php?r=items%2Findex";s:4:"ajax";i:0;s:6:"method";s:3:"GET";s:2:"ip";s:12:"192.168.0.80";s:4:"time";d:1609320411.991827;s:10:"statusCode";i:200;s:8:"sqlCount";i:56;s:9:"mailCount";i:0;s:9:"mailFiles";a:0:{}s:10:"peakMemory";i:3025416;s:14:"processingTime";d:0.08461594581604004;}s:13:"5fec47e7d27ea";a:12:{s:3:"tag";s:13:"5fec47e7d27ea";s:3:"url";s:62:"http://192.168.0.32/invent/index.php?r=moving%2Fupdate&id=5678";s:4:"ajax";i:0;s:6:"method";s:3:"GET";s:2:"ip";s:12:"192.168.0.68";s:4:"time";d:1609320423.819762;s:10:"statusCode";i:200;s:8:"sqlCount";i:114;s:9:"mailCount";i:0;s:9:"mailFiles";a:0:{}s:10:"peakMemory";i:3309920;s:14:"processingTime";d:0.12138199806213379;}s:13:"5fec47ee17c86";a:12:{s:3:"tag";s:13:"5fec47ee17c86";s:3:"url";s:208:"https://192.168.0.32/invent/index.php?ItemsSearch%5Binvent%5D=1630638&ItemsSearch%5Bserial%5D=&ItemsSearch%5BmodelName%5D=&ItemsSearch%5BregionName%5D=&ItemsSearch%5BstatusName%5D=&r=items%2Findex&_pjax=%23p0";s:4:"ajax";i:1;s:6:"method";s:3:"GET";s:2:"ip";s:12:"192.168.0.80";s:4:"time";d:1609320430.046359;s:10:"statusCode";i:200;s:8:"sqlCount";i:48;s:9:"mailCount";i:0;s:9:"mailFiles";a:0:{}s:10:"peakMemory";i:2620224;s:14:"processingTime";d:0.11816191673278809;}s:13:"5fec47f2368cc";a:12:{s:3:"tag";s:13:"5fec47f2368cc";s:3:"url";s:74:"https://192.168.0.32/invent/index.php?r=items%2Fupdate&id=1628&_pjax=%23p0";s:4:"ajax";i:1;s:6:"method";s:3:"GET";s:2:"ip";s:12:"192.168.0.80";s:4:"time";d:1609320434.200479;s:10:"statusCode";i:200;s:8:"sqlCount";i:39;s:9:"mailCount";i:0;s:9:"mailFiles";a:0:{}s:10:"peakMemory";i:8736224;s:14:"processingTime";d:0.13946795463562012;}s:13:"5fec47f26d2f9";a:12:{s:3:"tag";s:13:"5fec47f26d2f9";s:3:"url";s:62:"https://192.168.0.32/invent/index.php?r=items%2Fupdate&id=1628";s:4:"ajax";i:0;s:6:"method";s:3:"GET";s:2:"ip";s:12:"192.168.0.80";s:4:"time";d:1609320434.402485;s:10:"statusCode";i:200;s:8:"sqlCount";i:39;s:9:"mailCount";i:0;s:9:"mailFiles";a:0:{}s:10:"peakMemory";i:8718096;s:14:"processingTime";d:0.19543790817260742;}s:13:"5fec4816d9c63";a:12:{s:3:"tag";s:13:"5fec4816d9c63";s:3:"url";s:53:"https://192.168.0.32/invent/index.php?r=items%2Findex";s:4:"ajax";i:0;s:6:"method";s:3:"GET";s:2:"ip";s:12:"192.168.0.80";s:4:"time";d:1609320470.87332;s:10:"statusCode";i:200;s:8:"sqlCount";i:56;s:9:"mailCount";i:0;s:9:"mailFiles";a:0:{}s:10:"peakMemory";i:3025688;s:14:"processingTime";d:0.08948206901550293;}s:13:"5fec481f3530f";a:12:{s:3:"tag";s:13:"5fec481f3530f";s:3:"url";s:62:"http://192.168.0.32/invent/index.php?r=moving%2Fupdate&id=5678";s:4:"ajax";i:0;s:6:"method";s:4:"POST";s:2:"ip";s:12:"192.168.0.68";s:4:"time";d:1609320479.186582;s:10:"statusCode";i:302;s:8:"sqlCount";i:16;s:9:"mailCount";i:0;s:9:"mailFiles";a:0:{}s:10:"peakMemory";i:2004208;s:14:"processingTime";d:0.11221194267272949;}s:13:"5fec481f55a30";a:12:{s:3:"tag";s:13:"5fec481f55a30";s:3:"url";s:61:"http://192.168.0.32/invent/index.php?r=items%2Fupdate&id=1768";s:4:"ajax";i:0;s:6:"method";s:3:"GET";s:2:"ip";s:12:"192.168.0.68";s:4:"time";d:1609320479.336689;s:10:"statusCode";i:200;s:8:"sqlCount";i:39;s:9:"mailCount";i:0;s:9:"mailFiles";a:0:{}s:10:"peakMemory";i:8696392;s:14:"processingTime";d:0.12682294845581055;}s:13:"5fec482376e74";a:12:{s:3:"tag";s:13:"5fec482376e74";s:3:"url";s:204:"https://192.168.0.32/invent/index.php?ItemsSearch%5Binvent%5D=635&ItemsSearch%5Bserial%5D=&ItemsSearch%5BmodelName%5D=&ItemsSearch%5BregionName%5D=&ItemsSearch%5BstatusName%5D=&r=items%2Findex&_pjax=%23p0";s:4:"ajax";i:1;s:6:"method";s:3:"GET";s:2:"ip";s:12:"192.168.0.80";s:4:"time";d:1609320483.468278;s:10:"statusCode";i:200;s:8:"sqlCount";i:48;s:9:"mailCount";i:0;s:9:"mailFiles";a:0:{}s:10:"peakMemory";i:2629256;s:14:"processingTime";d:0.08139610290527344;}s:13:"5fec4829493b6";a:12:{s:3:"tag";s:13:"5fec4829493b6";s:3:"url";s:74:"https://192.168.0.32/invent/index.php?r=items%2Fupdate&id=1631&_pjax=%23p0";s:4:"ajax";i:1;s:6:"method";s:3:"GET";s:2:"ip";s:12:"192.168.0.80";s:4:"time";d:1609320489.281511;s:10:"statusCode";i:200;s:8:"sqlCount";i:39;s:9:"mailCount";i:0;s:9:"mailFiles";a:0:{}s:10:"peakMemory";i:8736136;s:14:"processingTime";d:0.1311790943145752;}s:13:"5fec482978c59";a:12:{s:3:"tag";s:13:"5fec482978c59";s:3:"url";s:62:"https://192.168.0.32/invent/index.php?r=items%2Fupdate&id=1631";s:4:"ajax";i:0;s:6:"method";s:3:"GET";s:2:"ip";s:12:"192.168.0.80";s:4:"time";d:1609320489.475277;s:10:"statusCode";i:200;s:8:"sqlCount";i:39;s:9:"mailCount";i:0;s:9:"mailFiles";a:0:{}s:10:"peakMemory";i:8718008;s:14:"processingTime";d:0.12418985366821289;}s:13:"5fec482aaa962";a:12:{s:3:"tag";s:13:"5fec482aaa962";s:3:"url";s:62:"http://192.168.0.32/invent/index.php?r=moving%2Fupdate&id=5674";s:4:"ajax";i:0;s:6:"method";s:3:"GET";s:2:"ip";s:12:"192.168.0.68";s:4:"time";d:1609320490.670023;s:10:"statusCode";i:200;s:8:"sqlCount";i:114;s:9:"mailCount";i:0;s:9:"mailFiles";a:0:{}s:10:"peakMemory";i:3309968;s:14:"processingTime";d:0.09694099426269531;}s:13:"5fec483e49b74";a:12:{s:3:"tag";s:13:"5fec483e49b74";s:3:"url";s:62:"http://192.168.0.32/invent/index.php?r=moving%2Fupdate&id=5674";s:4:"ajax";i:0;s:6:"method";s:4:"POST";s:2:"ip";s:12:"192.168.0.68";s:4:"time";d:1609320510.255738;s:10:"statusCode";i:302;s:8:"sqlCount";i:16;s:9:"mailCount";i:0;s:9:"mailFiles";a:0:{}s:10:"peakMemory";i:2004208;s:14:"processingTime";d:0.09920716285705566;}s:13:"5fec483e611cb";a:12:{s:3:"tag";s:13:"5fec483e611cb";s:3:"url";s:61:"http://192.168.0.32/invent/index.php?r=items%2Fupdate&id=1764";s:4:"ajax";i:0;s:6:"method";s:3:"GET";s:2:"ip";s:12:"192.168.0.68";s:4:"time";d:1609320510.375364;s:10:"statusCode";i:200;s:8:"sqlCount";i:39;s:9:"mailCount";i:0;s:9:"mailFiles";a:0:{}s:10:"peakMemory";i:8712624;s:14:"processingTime";d:0.13288116455078125;}s:13:"5fec4845b90fb";a:12:{s:3:"tag";s:13:"5fec4845b90fb";s:3:"url";s:52:"http://192.168.0.32/invent/index.php?r=items%2Findex";s:4:"ajax";i:0;s:6:"method";s:3:"GET";s:2:"ip";s:12:"192.168.0.68";s:4:"time";d:1609320517.735393;s:10:"statusCode";i:200;s:8:"sqlCount";i:56;s:9:"mailCount";i:0;s:9:"mailFiles";a:0:{}s:10:"peakMemory";i:3080504;s:14:"processingTime";d:0.08897185325622559;}s:13:"5fec4874c3f59";a:12:{s:3:"tag";s:13:"5fec4874c3f59";s:3:"url";s:209:"http://192.168.0.32/invent/index.php?r=items%2Findex&ItemsSearch%5Binvent%5D=&ItemsSearch%5Bserial%5D=&ItemsSearch%5BmodelName%5D=19&ItemsSearch%5BregionName%5D=&ItemsSearch%5BstatusName%5D=&page=1&sort=serial";s:4:"ajax";i:0;s:6:"method";s:3:"GET";s:2:"ip";s:12:"192.168.0.68";s:4:"time";d:1609320564.773766;s:10:"statusCode";i:200;s:8:"sqlCount";i:56;s:9:"mailCount";i:0;s:9:"mailFiles";a:0:{}s:10:"peakMemory";i:3158872;s:14:"processingTime";d:0.10094499588012695;}s:13:"5fec48d80443e";a:12:{s:3:"tag";s:13:"5fec48d80443e";s:3:"url";s:53:"https://192.168.0.32/invent/index.php?r=items%2Findex";s:4:"ajax";i:0;s:6:"method";s:3:"GET";s:2:"ip";s:12:"192.168.0.80";s:4:"time";d:1609320663.986727;s:10:"statusCode";i:200;s:8:"sqlCount";i:56;s:9:"mailCount";i:0;s:9:"mailFiles";a:0:{}s:10:"peakMemory";i:3025688;s:14:"processingTime";d:0.09457707405090332;}s:13:"5fec48e06720e";a:12:{s:3:"tag";s:13:"5fec48e06720e";s:3:"url";s:205:"https://192.168.0.32/invent/index.php?ItemsSearch%5Binvent%5D=1235&ItemsSearch%5Bserial%5D=&ItemsSearch%5BmodelName%5D=&ItemsSearch%5BregionName%5D=&ItemsSearch%5BstatusName%5D=&r=items%2Findex&_pjax=%23p0";s:4:"ajax";i:1;s:6:"method";s:3:"GET";s:2:"ip";s:12:"192.168.0.80";s:4:"time";d:1609320672.40483;s:10:"statusCode";i:200;s:8:"sqlCount";i:48;s:9:"mailCount";i:0;s:9:"mailFiles";a:0:{}s:10:"peakMemory";i:2618936;s:14:"processingTime";d:0.07418489456176758;}s:13:"5fec48e64b839";a:12:{s:3:"tag";s:13:"5fec48e64b839";s:3:"url";s:74:"https://192.168.0.32/invent/index.php?r=items%2Fupdate&id=1444&_pjax=%23p0";s:4:"ajax";i:1;s:6:"method";s:3:"GET";s:2:"ip";s:12:"192.168.0.80";s:4:"time";d:1609320678.290371;s:10:"statusCode";i:200;s:8:"sqlCount";i:39;s:9:"mailCount";i:0;s:9:"mailFiles";a:0:{}s:10:"peakMemory";i:8719920;s:14:"processingTime";d:0.1814260482788086;}s:13:"5fec48e676a3f";a:12:{s:3:"tag";s:13:"5fec48e676a3f";s:3:"url";s:74:"https://192.168.0.32/invent/index.php?r=items%2Fupdate&id=1444&_pjax=%23p0";s:4:"ajax";i:1;s:6:"method";s:3:"GET";s:2:"ip";s:12:"192.168.0.80";s:4:"time";d:1609320678.334216;s:10:"statusCode";i:200;s:8:"sqlCount";i:39;s:9:"mailCount";i:0;s:9:"mailFiles";a:0:{}s:10:"peakMemory";i:8719536;s:14:"processingTime";d:0.2621028423309326;}s:13:"5fec48e6a978c";a:12:{s:3:"tag";s:13:"5fec48e6a978c";s:3:"url";s:62:"https://192.168.0.32/invent/index.php?r=items%2Fupdate&id=1444";s:4:"ajax";i:0;s:6:"method";s:3:"GET";s:2:"ip";s:12:"192.168.0.80";s:4:"time";d:1609320678.660983;s:10:"statusCode";i:200;s:8:"sqlCount";i:39;s:9:"mailCount";i:0;s:9:"mailFiles";a:0:{}s:10:"peakMemory";i:8718016;s:14:"processingTime";d:0.15928888320922852;}s:13:"5fec49df7582d";a:12:{s:3:"tag";s:13:"5fec49df7582d";s:3:"url";s:53:"https://192.168.0.32/invent/index.php?r=items%2Findex";s:4:"ajax";i:0;s:6:"method";s:3:"GET";s:2:"ip";s:12:"192.168.0.80";s:4:"time";d:1609320927.462607;s:10:"statusCode";i:200;s:8:"sqlCount";i:56;s:9:"mailCount";i:0;s:9:"mailFiles";a:0:{}s:10:"peakMemory";i:3025416;s:14:"processingTime";d:0.08509302139282227;}s:13:"5fec4f101efaa";a:12:{s:3:"tag";s:13:"5fec4f101efaa";s:3:"url";s:209:"http://192.168.0.32/invent/index.php?r=items%2Findex&ItemsSearch%5Binvent%5D=&ItemsSearch%5Bserial%5D=&ItemsSearch%5BmodelName%5D=19&ItemsSearch%5BregionName%5D=&ItemsSearch%5BstatusName%5D=&page=1&sort=serial";s:4:"ajax";i:0;s:6:"method";s:3:"GET";s:2:"ip";s:12:"192.168.0.68";s:4:"time";d:1609322256.096537;s:10:"statusCode";i:500;s:8:"sqlCount";i:48;s:9:"mailCount";i:0;s:9:"mailFiles";a:0:{}s:10:"peakMemory";i:2906320;s:14:"processingTime";d:0.09985613822937012;}s:13:"5fec5053030e4";a:12:{s:3:"tag";s:13:"5fec5053030e4";s:3:"url";s:209:"http://192.168.0.32/invent/index.php?r=items%2Findex&ItemsSearch%5Binvent%5D=&ItemsSearch%5Bserial%5D=&ItemsSearch%5BmodelName%5D=19&ItemsSearch%5BregionName%5D=&ItemsSearch%5BstatusName%5D=&page=1&sort=serial";s:4:"ajax";i:0;s:6:"method";s:3:"GET";s:2:"ip";s:12:"192.168.0.68";s:4:"time";d:1609322578.99384;s:10:"statusCode";i:500;s:8:"sqlCount";i:48;s:9:"mailCount";i:0;s:9:"mailFiles";a:0:{}s:10:"peakMemory";i:2906456;s:14:"processingTime";d:0.0939779281616211;}s:13:"5fec51878fc66";a:12:{s:3:"tag";s:13:"5fec51878fc66";s:3:"url";s:209:"http://192.168.0.32/invent/index.php?r=items%2Findex&ItemsSearch%5Binvent%5D=&ItemsSearch%5Bserial%5D=&ItemsSearch%5BmodelName%5D=19&ItemsSearch%5BregionName%5D=&ItemsSearch%5BstatusName%5D=&page=1&sort=serial";s:4:"ajax";i:0;s:6:"method";s:3:"GET";s:2:"ip";s:12:"192.168.0.68";s:4:"time";d:1609322887.543605;s:10:"statusCode";i:500;s:8:"sqlCount";i:53;s:9:"mailCount";i:0;s:9:"mailFiles";a:0:{}s:10:"peakMemory";i:3688536;s:14:"processingTime";d:0.13422799110412598;}s:13:"5fec51addf012";a:12:{s:3:"tag";s:13:"5fec51addf012";s:3:"url";s:209:"http://192.168.0.32/invent/index.php?r=items%2Findex&ItemsSearch%5Binvent%5D=&ItemsSearch%5Bserial%5D=&ItemsSearch%5BmodelName%5D=19&ItemsSearch%5BregionName%5D=&ItemsSearch%5BstatusName%5D=&page=1&sort=serial";s:4:"ajax";i:0;s:6:"method";s:3:"GET";s:2:"ip";s:12:"192.168.0.68";s:4:"time";d:1609322925.889324;s:10:"statusCode";i:500;s:8:"sqlCount";i:53;s:9:"mailCount";i:0;s:9:"mailFiles";a:0:{}s:10:"peakMemory";i:3689152;s:14:"processingTime";d:0.13730192184448242;}s:13:"5fec51ce7fb9f";a:12:{s:3:"tag";s:13:"5fec51ce7fb9f";s:3:"url";s:209:"http://192.168.0.32/invent/index.php?r=items%2Findex&ItemsSearch%5Binvent%5D=&ItemsSearch%5Bserial%5D=&ItemsSearch%5BmodelName%5D=19&ItemsSearch%5BregionName%5D=&ItemsSearch%5BstatusName%5D=&page=1&sort=serial";s:4:"ajax";i:0;s:6:"method";s:3:"GET";s:2:"ip";s:12:"192.168.0.68";s:4:"time";d:1609322958.504574;s:10:"statusCode";i:500;s:8:"sqlCount";i:53;s:9:"mailCount";i:0;s:9:"mailFiles";a:0:{}s:10:"peakMemory";i:3706072;s:14:"processingTime";d:0.10092592239379883;}s:13:"5fec51ee1ae31";a:12:{s:3:"tag";s:13:"5fec51ee1ae31";s:3:"url";s:209:"http://192.168.0.32/invent/index.php?r=items%2Findex&ItemsSearch%5Binvent%5D=&ItemsSearch%5Bserial%5D=&ItemsSearch%5BmodelName%5D=19&ItemsSearch%5BregionName%5D=&ItemsSearch%5BstatusName%5D=&page=1&sort=serial";s:4:"ajax";i:0;s:6:"method";s:3:"GET";s:2:"ip";s:12:"192.168.0.68";s:4:"time";d:1609322990.087786;s:10:"statusCode";i:500;s:8:"sqlCount";i:53;s:9:"mailCount";i:0;s:9:"mailFiles";a:0:{}s:10:"peakMemory";i:3706072;s:14:"processingTime";d:0.12332296371459961;}s:13:"5fec51fc02f26";a:12:{s:3:"tag";s:13:"5fec51fc02f26";s:3:"url";s:209:"http://192.168.0.32/invent/index.php?r=items%2Findex&ItemsSearch%5Binvent%5D=&ItemsSearch%5Bserial%5D=&ItemsSearch%5BmodelName%5D=19&ItemsSearch%5BregionName%5D=&ItemsSearch%5BstatusName%5D=&page=1&sort=serial";s:4:"ajax";i:0;s:6:"method";s:3:"GET";s:2:"ip";s:12:"192.168.0.68";s:4:"time";d:1609323003.993249;s:10:"statusCode";i:500;s:8:"sqlCount";i:53;s:9:"mailCount";i:0;s:9:"mailFiles";a:0:{}s:10:"peakMemory";i:3618928;s:14:"processingTime";d:0.10410094261169434;}s:13:"5fec524e0cda9";a:12:{s:3:"tag";s:13:"5fec524e0cda9";s:3:"url";s:209:"http://192.168.0.32/invent/index.php?r=items%2Findex&ItemsSearch%5Binvent%5D=&ItemsSearch%5Bserial%5D=&ItemsSearch%5BmodelName%5D=19&ItemsSearch%5BregionName%5D=&ItemsSearch%5BstatusName%5D=&page=1&sort=serial";s:4:"ajax";i:0;s:6:"method";s:3:"GET";s:2:"ip";s:12:"192.168.0.68";s:4:"time";d:1609323086.006806;s:10:"statusCode";i:200;s:8:"sqlCount";i:56;s:9:"mailCount";i:0;s:9:"mailFiles";a:0:{}s:10:"peakMemory";i:3165808;s:14:"processingTime";d:0.14249300956726074;}s:13:"5fec527686ae4";a:12:{s:3:"tag";s:13:"5fec527686ae4";s:3:"url";s:209:"http://192.168.0.32/invent/index.php?r=items%2Findex&ItemsSearch%5Binvent%5D=&ItemsSearch%5Bserial%5D=&ItemsSearch%5BmodelName%5D=19&ItemsSearch%5BregionName%5D=&ItemsSearch%5BstatusName%5D=&page=1&sort=serial";s:4:"ajax";i:0;s:6:"method";s:3:"GET";s:2:"ip";s:12:"192.168.0.68";s:4:"time";d:1609323126.536634;s:10:"statusCode";i:200;s:8:"sqlCount";i:56;s:9:"mailCount";i:0;s:9:"mailFiles";a:0:{}s:10:"peakMemory";i:3165808;s:14:"processingTime";d:0.09307718276977539;}s:13:"5fec57980fd82";a:12:{s:3:"tag";s:13:"5fec57980fd82";s:3:"url";s:209:"http://192.168.0.32/invent/index.php?r=items%2Findex&ItemsSearch%5Binvent%5D=&ItemsSearch%5Bserial%5D=&ItemsSearch%5BmodelName%5D=19&ItemsSearch%5BregionName%5D=&ItemsSearch%5BstatusName%5D=&page=1&sort=serial";s:4:"ajax";i:0;s:6:"method";s:3:"GET";s:2:"ip";s:12:"192.168.0.68";s:4:"time";d:1609324440.044859;s:10:"statusCode";i:200;s:8:"sqlCount";i:56;s:9:"mailCount";i:0;s:9:"mailFiles";a:0:{}s:10:"peakMemory";i:3164704;s:14:"processingTime";d:0.10410618782043457;}s:13:"5fec57a03b8fd";a:12:{s:3:"tag";s:13:"5fec57a03b8fd";s:3:"url";s:36:"http://192.168.0.32/invent/index.php";s:4:"ajax";i:0;s:6:"method";s:3:"GET";s:2:"ip";s:12:"192.168.0.68";s:4:"time";d:1609324448.220805;s:10:"statusCode";i:200;s:8:"sqlCount";i:23;s:9:"mailCount";i:0;s:9:"mailFiles";a:0:{}s:10:"peakMemory";i:2503328;s:14:"processingTime";d:0.0908818244934082;}s:13:"5fec596827e39";a:12:{s:3:"tag";s:13:"5fec596827e39";s:3:"url";s:36:"http://192.168.0.32/invent/index.php";s:4:"ajax";i:0;s:6:"method";s:3:"GET";s:2:"ip";s:12:"192.168.0.68";s:4:"time";d:1609324904.140018;s:10:"statusCode";i:200;s:8:"sqlCount";i:23;s:9:"mailCount";i:0;s:9:"mailFiles";a:0:{}s:10:"peakMemory";i:2503960;s:14:"processingTime";d:0.0912938117980957;}s:13:"5fec5d17a04e7";a:12:{s:3:"tag";s:13:"5fec5d17a04e7";s:3:"url";s:36:"http://192.168.0.32/invent/index.php";s:4:"ajax";i:0;s:6:"method";s:3:"GET";s:2:"ip";s:12:"192.168.0.68";s:4:"time";d:1609325847.610076;s:10:"statusCode";i:200;s:8:"sqlCount";i:23;s:9:"mailCount";i:0;s:9:"mailFiles";a:0:{}s:10:"peakMemory";i:2507032;s:14:"processingTime";d:0.12527799606323242;}s:13:"5fec5df770130";a:12:{s:3:"tag";s:13:"5fec5df770130";s:3:"url";s:36:"http://192.168.0.32/invent/index.php";s:4:"ajax";i:0;s:6:"method";s:3:"GET";s:2:"ip";s:12:"192.168.0.68";s:4:"time";d:1609326071.421151;s:10:"statusCode";i:200;s:8:"sqlCount";i:23;s:9:"mailCount";i:0;s:9:"mailFiles";a:0:{}s:10:"peakMemory";i:2505864;s:14:"processingTime";d:0.10657882690429688;}s:13:"5fec5dfaa1c56";a:12:{s:3:"tag";s:13:"5fec5dfaa1c56";s:3:"url";s:52:"http://192.168.0.32/invent/index.php?r=items%2Findex";s:4:"ajax";i:0;s:6:"method";s:3:"GET";s:2:"ip";s:12:"192.168.0.68";s:4:"time";d:1609326074.632451;s:10:"statusCode";i:200;s:8:"sqlCount";i:56;s:9:"mailCount";i:0;s:9:"mailFiles";a:0:{}s:10:"peakMemory";i:3083792;s:14:"processingTime";d:0.09494900703430176;}} \ No newline at end of file +a:59:{s:13:"5fec5d17a04e7";a:12:{s:3:"tag";s:13:"5fec5d17a04e7";s:3:"url";s:36:"http://192.168.0.32/invent/index.php";s:4:"ajax";i:0;s:6:"method";s:3:"GET";s:2:"ip";s:12:"192.168.0.68";s:4:"time";d:1609325847.610076;s:10:"statusCode";i:200;s:8:"sqlCount";i:23;s:9:"mailCount";i:0;s:9:"mailFiles";a:0:{}s:10:"peakMemory";i:2507032;s:14:"processingTime";d:0.12527799606323242;}s:13:"5fec5df770130";a:12:{s:3:"tag";s:13:"5fec5df770130";s:3:"url";s:36:"http://192.168.0.32/invent/index.php";s:4:"ajax";i:0;s:6:"method";s:3:"GET";s:2:"ip";s:12:"192.168.0.68";s:4:"time";d:1609326071.421151;s:10:"statusCode";i:200;s:8:"sqlCount";i:23;s:9:"mailCount";i:0;s:9:"mailFiles";a:0:{}s:10:"peakMemory";i:2505864;s:14:"processingTime";d:0.10657882690429688;}s:13:"5fec5dfaa1c56";a:12:{s:3:"tag";s:13:"5fec5dfaa1c56";s:3:"url";s:52:"http://192.168.0.32/invent/index.php?r=items%2Findex";s:4:"ajax";i:0;s:6:"method";s:3:"GET";s:2:"ip";s:12:"192.168.0.68";s:4:"time";d:1609326074.632451;s:10:"statusCode";i:200;s:8:"sqlCount";i:56;s:9:"mailCount";i:0;s:9:"mailFiles";a:0:{}s:10:"peakMemory";i:3083792;s:14:"processingTime";d:0.09494900703430176;}s:13:"5fec603950ef0";a:12:{s:3:"tag";s:13:"5fec603950ef0";s:3:"url";s:52:"http://192.168.0.32/invent/index.php?r=items%2Findex";s:4:"ajax";i:0;s:6:"method";s:3:"GET";s:2:"ip";s:12:"192.168.0.68";s:4:"time";d:1609326649.301263;s:10:"statusCode";i:200;s:8:"sqlCount";i:56;s:9:"mailCount";i:0;s:9:"mailFiles";a:0:{}s:10:"peakMemory";i:3083320;s:14:"processingTime";d:0.10323691368103027;}s:13:"5ffbee765dff3";a:12:{s:3:"tag";s:13:"5ffbee765dff3";s:3:"url";s:195:"http://192.168.0.32/invent/index.php?ItemsSearch%5Binvent%5D=1630639&ItemsSearch%5Bserial%5D=&ItemsSearch%5BmodelName%5D=&ItemsSearch%5BregionName%5D=&ItemsSearch%5BstatusName%5D=&r=items%2Findex";s:4:"ajax";i:0;s:6:"method";s:3:"GET";s:2:"ip";s:12:"192.168.0.68";s:4:"time";d:1610346100.77241;s:10:"statusCode";i:200;s:8:"sqlCount";i:56;s:9:"mailCount";i:0;s:9:"mailFiles";a:0:{}s:10:"peakMemory";i:4527304;s:14:"processingTime";d:3.985821008682251;}s:13:"5ffbee765dfb0";a:12:{s:3:"tag";s:13:"5ffbee765dfb0";s:3:"url";s:207:"http://192.168.0.32/invent/index.php?ItemsSearch%5Binvent%5D=1630639&ItemsSearch%5Bserial%5D=&ItemsSearch%5BmodelName%5D=&ItemsSearch%5BregionName%5D=&ItemsSearch%5BstatusName%5D=&r=items%2Findex&_pjax=%23p0";s:4:"ajax";i:1;s:6:"method";s:3:"GET";s:2:"ip";s:12:"192.168.0.68";s:4:"time";d:1610346099.705357;s:10:"statusCode";i:200;s:8:"sqlCount";i:48;s:9:"mailCount";i:0;s:9:"mailFiles";a:0:{}s:10:"peakMemory";i:4992680;s:14:"processingTime";d:4.137142181396484;}s:13:"5ffbee7c66775";a:12:{s:3:"tag";s:13:"5ffbee7c66775";s:3:"url";s:73:"http://192.168.0.32/invent/index.php?r=items%2Fupdate&id=1627&_pjax=%23p0";s:4:"ajax";i:1;s:6:"method";s:3:"GET";s:2:"ip";s:12:"192.168.0.68";s:4:"time";d:1610346108.400711;s:10:"statusCode";i:200;s:8:"sqlCount";i:39;s:9:"mailCount";i:0;s:9:"mailFiles";a:0:{}s:10:"peakMemory";i:8716944;s:14:"processingTime";d:0.7677288055419922;}s:13:"5ffbee7d4dec4";a:12:{s:3:"tag";s:13:"5ffbee7d4dec4";s:3:"url";s:61:"http://192.168.0.32/invent/index.php?r=items%2Fupdate&id=1627";s:4:"ajax";i:0;s:6:"method";s:3:"GET";s:2:"ip";s:12:"192.168.0.68";s:4:"time";d:1610346109.290643;s:10:"statusCode";i:200;s:8:"sqlCount";i:39;s:9:"mailCount";i:0;s:9:"mailFiles";a:0:{}s:10:"peakMemory";i:8695152;s:14:"processingTime";d:0.13329100608825684;}s:13:"5ffbefee8b7e1";a:12:{s:3:"tag";s:13:"5ffbefee8b7e1";s:3:"url";s:61:"http://192.168.0.32/invent/index.php?r=items%2Fupdate&id=1627";s:4:"ajax";i:0;s:6:"method";s:4:"POST";s:2:"ip";s:12:"192.168.0.68";s:4:"time";d:1610346478.524171;s:10:"statusCode";i:302;s:8:"sqlCount";i:11;s:9:"mailCount";i:0;s:9:"mailFiles";a:0:{}s:10:"peakMemory";i:1960392;s:14:"processingTime";d:0.09994912147521973;}s:13:"5ffbefeea624a";a:12:{s:3:"tag";s:13:"5ffbefeea624a";s:3:"url";s:60:"http://192.168.0.32/invent/index.php?r=items%2Findex&id=1627";s:4:"ajax";i:0;s:6:"method";s:3:"GET";s:2:"ip";s:12:"192.168.0.68";s:4:"time";d:1610346478.652077;s:10:"statusCode";i:302;s:8:"sqlCount";i:20;s:9:"mailCount";i:0;s:9:"mailFiles";a:0:{}s:10:"peakMemory";i:62377304;s:14:"processingTime";d:0.8382120132446289;}s:13:"5ffbefefafaf6";a:12:{s:3:"tag";s:13:"5ffbefefafaf6";s:3:"url";s:60:"http://192.168.0.32/invent/index.php?r=items%2Findex&page=62";s:4:"ajax";i:0;s:6:"method";s:3:"GET";s:2:"ip";s:12:"192.168.0.68";s:4:"time";d:1610346479.688216;s:10:"statusCode";i:200;s:8:"sqlCount";i:56;s:9:"mailCount";i:0;s:9:"mailFiles";a:0:{}s:10:"peakMemory";i:3133872;s:14:"processingTime";d:0.1308729648590088;}s:13:"5ffbeff240aa1";a:12:{s:3:"tag";s:13:"5ffbeff240aa1";s:3:"url";s:73:"http://192.168.0.32/invent/index.php?r=items%2Fupdate&id=1627&_pjax=%23p0";s:4:"ajax";i:1;s:6:"method";s:3:"GET";s:2:"ip";s:12:"192.168.0.68";s:4:"time";d:1610346482.236288;s:10:"statusCode";i:200;s:8:"sqlCount";i:39;s:9:"mailCount";i:0;s:9:"mailFiles";a:0:{}s:10:"peakMemory";i:8698888;s:14:"processingTime";d:0.3309600353240967;}s:13:"5ffbeff2a8c02";a:12:{s:3:"tag";s:13:"5ffbeff2a8c02";s:3:"url";s:61:"http://192.168.0.32/invent/index.php?r=items%2Fupdate&id=1627";s:4:"ajax";i:0;s:6:"method";s:3:"GET";s:2:"ip";s:12:"192.168.0.68";s:4:"time";d:1610346482.651041;s:10:"statusCode";i:200;s:8:"sqlCount";i:39;s:9:"mailCount";i:0;s:9:"mailFiles";a:0:{}s:10:"peakMemory";i:8694904;s:14:"processingTime";d:0.16117000579833984;}s:13:"5ffbf0005d3fc";a:12:{s:3:"tag";s:13:"5ffbf0005d3fc";s:3:"url";s:61:"http://192.168.0.32/invent/index.php?r=items%2Fupdate&id=1627";s:4:"ajax";i:0;s:6:"method";s:4:"POST";s:2:"ip";s:12:"192.168.0.68";s:4:"time";d:1610346496.351793;s:10:"statusCode";i:302;s:8:"sqlCount";i:11;s:9:"mailCount";i:0;s:9:"mailFiles";a:0:{}s:10:"peakMemory";i:1905696;s:14:"processingTime";d:0.06427001953125;}s:13:"5ffbf000737d8";a:12:{s:3:"tag";s:13:"5ffbf000737d8";s:3:"url";s:60:"http://192.168.0.32/invent/index.php?r=items%2Findex&id=1627";s:4:"ajax";i:0;s:6:"method";s:3:"GET";s:2:"ip";s:12:"192.168.0.68";s:4:"time";d:1610346496.435902;s:10:"statusCode";i:302;s:8:"sqlCount";i:20;s:9:"mailCount";i:0;s:9:"mailFiles";a:0:{}s:10:"peakMemory";i:62377304;s:14:"processingTime";d:0.792849063873291;}s:13:"5ffbf0016b21c";a:12:{s:3:"tag";s:13:"5ffbf0016b21c";s:3:"url";s:60:"http://192.168.0.32/invent/index.php?r=items%2Findex&page=62";s:4:"ajax";i:0;s:6:"method";s:3:"GET";s:2:"ip";s:12:"192.168.0.68";s:4:"time";d:1610346497.413188;s:10:"statusCode";i:200;s:8:"sqlCount";i:56;s:9:"mailCount";i:0;s:9:"mailFiles";a:0:{}s:10:"peakMemory";i:3133872;s:14:"processingTime";d:0.12362909317016602;}s:13:"5ffbf00b44bc7";a:12:{s:3:"tag";s:13:"5ffbf00b44bc7";s:3:"url";s:73:"http://192.168.0.32/invent/index.php?r=items%2Fupdate&id=1627&_pjax=%23p0";s:4:"ajax";i:1;s:6:"method";s:3:"GET";s:2:"ip";s:12:"192.168.0.68";s:4:"time";d:1610346507.236552;s:10:"statusCode";i:200;s:8:"sqlCount";i:39;s:9:"mailCount";i:0;s:9:"mailFiles";a:0:{}s:10:"peakMemory";i:8698888;s:14:"processingTime";d:0.29139089584350586;}s:13:"5ffbf00baa15f";a:12:{s:3:"tag";s:13:"5ffbf00baa15f";s:3:"url";s:61:"http://192.168.0.32/invent/index.php?r=items%2Fupdate&id=1627";s:4:"ajax";i:0;s:6:"method";s:3:"GET";s:2:"ip";s:12:"192.168.0.68";s:4:"time";d:1610346507.652716;s:10:"statusCode";i:200;s:8:"sqlCount";i:39;s:9:"mailCount";i:0;s:9:"mailFiles";a:0:{}s:10:"peakMemory";i:8694904;s:14:"processingTime";d:0.16691207885742188;}s:13:"5ffbf01430232";a:12:{s:3:"tag";s:13:"5ffbf01430232";s:3:"url";s:61:"http://192.168.0.32/invent/index.php?r=items%2Fupdate&id=1627";s:4:"ajax";i:0;s:6:"method";s:4:"POST";s:2:"ip";s:12:"192.168.0.68";s:4:"time";d:1610346516.167937;s:10:"statusCode";i:302;s:8:"sqlCount";i:11;s:9:"mailCount";i:0;s:9:"mailFiles";a:0:{}s:10:"peakMemory";i:1905624;s:14:"processingTime";d:0.05041217803955078;}s:13:"5ffbf014417a9";a:12:{s:3:"tag";s:13:"5ffbf014417a9";s:3:"url";s:60:"http://192.168.0.32/invent/index.php?r=items%2Findex&id=1627";s:4:"ajax";i:0;s:6:"method";s:3:"GET";s:2:"ip";s:12:"192.168.0.68";s:4:"time";d:1610346516.250276;s:10:"statusCode";i:302;s:8:"sqlCount";i:20;s:9:"mailCount";i:0;s:9:"mailFiles";a:0:{}s:10:"peakMemory";i:62377304;s:14:"processingTime";d:0.7415449619293213;}s:13:"5ffbf01539eb7";a:12:{s:3:"tag";s:13:"5ffbf01539eb7";s:3:"url";s:60:"http://192.168.0.32/invent/index.php?r=items%2Findex&page=62";s:4:"ajax";i:0;s:6:"method";s:3:"GET";s:2:"ip";s:12:"192.168.0.68";s:4:"time";d:1610346517.198133;s:10:"statusCode";i:200;s:8:"sqlCount";i:56;s:9:"mailCount";i:0;s:9:"mailFiles";a:0:{}s:10:"peakMemory";i:3133872;s:14:"processingTime";d:0.11698603630065918;}s:13:"5ffbf0206b2c9";a:12:{s:3:"tag";s:13:"5ffbf0206b2c9";s:3:"url";s:73:"http://192.168.0.32/invent/index.php?r=items%2Fupdate&id=1627&_pjax=%23p0";s:4:"ajax";i:1;s:6:"method";s:3:"GET";s:2:"ip";s:12:"192.168.0.68";s:4:"time";d:1610346528.420435;s:10:"statusCode";i:200;s:8:"sqlCount";i:39;s:9:"mailCount";i:0;s:9:"mailFiles";a:0:{}s:10:"peakMemory";i:8715112;s:14:"processingTime";d:0.13436102867126465;}s:13:"5ffbf020a9e20";a:12:{s:3:"tag";s:13:"5ffbf020a9e20";s:3:"url";s:61:"http://192.168.0.32/invent/index.php?r=items%2Fupdate&id=1627";s:4:"ajax";i:0;s:6:"method";s:3:"GET";s:2:"ip";s:12:"192.168.0.68";s:4:"time";d:1610346528.651603;s:10:"statusCode";i:200;s:8:"sqlCount";i:39;s:9:"mailCount";i:0;s:9:"mailFiles";a:0:{}s:10:"peakMemory";i:8694904;s:14:"processingTime";d:0.1692969799041748;}s:13:"5ffbf022d84e4";a:12:{s:3:"tag";s:13:"5ffbf022d84e4";s:3:"url";s:53:"http://192.168.0.32/invent/index.php?r=models%2Findex";s:4:"ajax";i:0;s:6:"method";s:3:"GET";s:2:"ip";s:12:"192.168.0.68";s:4:"time";d:1610346530.856622;s:10:"statusCode";i:200;s:8:"sqlCount";i:27;s:9:"mailCount";i:0;s:9:"mailFiles";a:0:{}s:10:"peakMemory";i:2552128;s:14:"processingTime";d:0.2620389461517334;}s:13:"5ffbf0297a0e5";a:12:{s:3:"tag";s:13:"5ffbf0297a0e5";s:3:"url";s:286:"http://192.168.0.32/invent/index.php?ModelsSearch%5Bname%5D=%D0%98%D0%91%D0%9F%20APC%20by%20Schneider%20Electric%20Power-Saving%20Back-UPS%20ES%208%20Outlet%20700VA%20230V&ModelsSearch%5BtypeName%5D=&ModelsSearch%5Bmodelnumber%5D=&ModelsSearch%5Bproduct%5D=&r=models%2Findex&_pjax=%23p0";s:4:"ajax";i:1;s:6:"method";s:3:"GET";s:2:"ip";s:12:"192.168.0.68";s:4:"time";d:1610346537.456605;s:10:"statusCode";i:200;s:8:"sqlCount";i:19;s:9:"mailCount";i:0;s:9:"mailFiles";a:0:{}s:10:"peakMemory";i:2298064;s:14:"processingTime";d:0.08726000785827637;}s:13:"5ffbf02b445ec";a:12:{s:3:"tag";s:13:"5ffbf02b445ec";s:3:"url";s:73:"http://192.168.0.32/invent/index.php?r=models%2Fupdate&id=856&_pjax=%23p0";s:4:"ajax";i:1;s:6:"method";s:3:"GET";s:2:"ip";s:12:"192.168.0.68";s:4:"time";d:1610346539.251589;s:10:"statusCode";i:200;s:8:"sqlCount";i:21;s:9:"mailCount";i:0;s:9:"mailFiles";a:0:{}s:10:"peakMemory";i:2272344;s:14:"processingTime";d:0.1436140537261963;}s:13:"5ffbf02b71b30";a:12:{s:3:"tag";s:13:"5ffbf02b71b30";s:3:"url";s:61:"http://192.168.0.32/invent/index.php?r=models%2Fupdate&id=856";s:4:"ajax";i:0;s:6:"method";s:3:"GET";s:2:"ip";s:12:"192.168.0.68";s:4:"time";d:1610346539.450815;s:10:"statusCode";i:200;s:8:"sqlCount";i:21;s:9:"mailCount";i:0;s:9:"mailFiles";a:0:{}s:10:"peakMemory";i:2342944;s:14:"processingTime";d:0.0356450080871582;}s:13:"5ffbf03744b4a";a:12:{s:3:"tag";s:13:"5ffbf03744b4a";s:3:"url";s:61:"http://192.168.0.32/invent/index.php?r=models%2Fupdate&id=856";s:4:"ajax";i:0;s:6:"method";s:4:"POST";s:2:"ip";s:12:"192.168.0.68";s:4:"time";d:1610346551.251933;s:10:"statusCode";i:302;s:8:"sqlCount";i:13;s:9:"mailCount";i:0;s:9:"mailFiles";a:0:{}s:10:"peakMemory";i:1932440;s:14:"processingTime";d:0.10325217247009277;}s:13:"5ffbf03765db5";a:12:{s:3:"tag";s:13:"5ffbf03765db5";s:3:"url";s:60:"http://192.168.0.32/invent/index.php?r=models%2Findex&id=856";s:4:"ajax";i:0;s:6:"method";s:3:"GET";s:2:"ip";s:12:"192.168.0.68";s:4:"time";d:1610346551.388531;s:10:"statusCode";i:302;s:8:"sqlCount";i:13;s:9:"mailCount";i:0;s:9:"mailFiles";a:0:{}s:10:"peakMemory";i:10221816;s:14:"processingTime";d:0.09271693229675293;}s:13:"5ffbf03791bf6";a:12:{s:3:"tag";s:13:"5ffbf03791bf6";s:3:"url";s:61:"http://192.168.0.32/invent/index.php?r=models%2Findex&page=37";s:4:"ajax";i:0;s:6:"method";s:3:"GET";s:2:"ip";s:12:"192.168.0.68";s:4:"time";d:1610346551.55664;s:10:"statusCode";i:200;s:8:"sqlCount";i:27;s:9:"mailCount";i:0;s:9:"mailFiles";a:0:{}s:10:"peakMemory";i:2542032;s:14:"processingTime";d:0.12666797637939453;}s:13:"5ffbf03e29e0e";a:12:{s:3:"tag";s:13:"5ffbf03e29e0e";s:3:"url";s:294:"http://192.168.0.32/invent/index.php?ModelsSearch%5Bname%5D=%D0%98%D0%91%D0%9F%20APC%20by%20Schneider%20Electric%20Power-Saving%20Back-UPS%20ES%208%20Outlet%20700VA%20230V&ModelsSearch%5BtypeName%5D=&ModelsSearch%5Bmodelnumber%5D=&ModelsSearch%5Bproduct%5D=&r=models%2Findex&page=37&_pjax=%23p0";s:4:"ajax";i:1;s:6:"method";s:3:"GET";s:2:"ip";s:12:"192.168.0.68";s:4:"time";d:1610346558.13982;s:10:"statusCode";i:200;s:8:"sqlCount";i:19;s:9:"mailCount";i:0;s:9:"mailFiles";a:0:{}s:10:"peakMemory";i:2298232;s:14:"processingTime";d:0.06396794319152832;}s:13:"5ffbf03fbb948";a:12:{s:3:"tag";s:13:"5ffbf03fbb948";s:3:"url";s:73:"http://192.168.0.32/invent/index.php?r=models%2Fupdate&id=856&_pjax=%23p0";s:4:"ajax";i:1;s:6:"method";s:3:"GET";s:2:"ip";s:12:"192.168.0.68";s:4:"time";d:1610346559.739787;s:10:"statusCode";i:200;s:8:"sqlCount";i:21;s:9:"mailCount";i:0;s:9:"mailFiles";a:0:{}s:10:"peakMemory";i:2271040;s:14:"processingTime";d:0.04796791076660156;}s:13:"5ffbf03fd0997";a:12:{s:3:"tag";s:13:"5ffbf03fd0997";s:3:"url";s:61:"http://192.168.0.32/invent/index.php?r=models%2Fupdate&id=856";s:4:"ajax";i:0;s:6:"method";s:3:"GET";s:2:"ip";s:12:"192.168.0.68";s:4:"time";d:1610346559.839004;s:10:"statusCode";i:200;s:8:"sqlCount";i:21;s:9:"mailCount";i:0;s:9:"mailFiles";a:0:{}s:10:"peakMemory";i:2338840;s:14:"processingTime";d:0.038178205490112305;}s:13:"5ffbf14baf52d";a:12:{s:3:"tag";s:13:"5ffbf14baf52d";s:3:"url";s:61:"http://192.168.0.32/invent/index.php?r=models%2Fupdate&id=856";s:4:"ajax";i:0;s:6:"method";s:4:"POST";s:2:"ip";s:12:"192.168.0.68";s:4:"time";d:1610346827.698884;s:10:"statusCode";i:302;s:8:"sqlCount";i:13;s:9:"mailCount";i:0;s:9:"mailFiles";a:0:{}s:10:"peakMemory";i:1932096;s:14:"processingTime";d:0.060461997985839844;}s:13:"5ffbf14bcc853";a:12:{s:3:"tag";s:13:"5ffbf14bcc853";s:3:"url";s:60:"http://192.168.0.32/invent/index.php?r=models%2Findex&id=856";s:4:"ajax";i:0;s:6:"method";s:3:"GET";s:2:"ip";s:12:"192.168.0.68";s:4:"time";d:1610346827.797686;s:10:"statusCode";i:302;s:8:"sqlCount";i:13;s:9:"mailCount";i:0;s:9:"mailFiles";a:0:{}s:10:"peakMemory";i:10238360;s:14:"processingTime";d:0.11215090751647949;}s:13:"5ffbf14bef545";a:12:{s:3:"tag";s:13:"5ffbf14bef545";s:3:"url";s:60:"http://192.168.0.32/invent/index.php?r=models%2Findex&page=1";s:4:"ajax";i:0;s:6:"method";s:3:"GET";s:2:"ip";s:12:"192.168.0.68";s:4:"time";d:1610346827.94604;s:10:"statusCode";i:200;s:8:"sqlCount";i:27;s:9:"mailCount";i:0;s:9:"mailFiles";a:0:{}s:10:"peakMemory";i:2549488;s:14:"processingTime";d:0.08280801773071289;}s:13:"5ffbf15333ed0";a:12:{s:3:"tag";s:13:"5ffbf15333ed0";s:3:"url";s:61:"http://192.168.0.32/invent/index.php?r=models%2Fupdate&id=856";s:4:"ajax";i:0;s:6:"method";s:3:"GET";s:2:"ip";s:12:"192.168.0.68";s:4:"time";d:1610346835.165697;s:10:"statusCode";i:200;s:8:"sqlCount";i:21;s:9:"mailCount";i:0;s:9:"mailFiles";a:0:{}s:10:"peakMemory";i:2334624;s:14:"processingTime";d:0.0881350040435791;}s:13:"5ffbf15ea260d";a:12:{s:3:"tag";s:13:"5ffbf15ea260d";s:3:"url";s:61:"http://192.168.0.32/invent/index.php?r=items%2Fupdate&id=1627";s:4:"ajax";i:0;s:6:"method";s:3:"GET";s:2:"ip";s:12:"192.168.0.68";s:4:"time";d:1610346846.646167;s:10:"statusCode";i:200;s:8:"sqlCount";i:39;s:9:"mailCount";i:0;s:9:"mailFiles";a:0:{}s:10:"peakMemory";i:8711064;s:14:"processingTime";d:0.13569307327270508;}s:13:"5ffbf16b2fdbb";a:12:{s:3:"tag";s:13:"5ffbf16b2fdbb";s:3:"url";s:62:"http://192.168.0.32/invent/index.php?r=moving%2Fdelete&id=5537";s:4:"ajax";i:0;s:6:"method";s:4:"POST";s:2:"ip";s:12:"192.168.0.68";s:4:"time";d:1610346859.150222;s:10:"statusCode";i:302;s:8:"sqlCount";i:11;s:9:"mailCount";i:0;s:9:"mailFiles";a:0:{}s:10:"peakMemory";i:1880560;s:14:"processingTime";d:0.15766096115112305;}s:13:"5ffbf16b5f57a";a:12:{s:3:"tag";s:13:"5ffbf16b5f57a";s:3:"url";s:61:"http://192.168.0.32/invent/index.php?r=items%2Fupdate&id=1627";s:4:"ajax";i:0;s:6:"method";s:3:"GET";s:2:"ip";s:12:"192.168.0.68";s:4:"time";d:1610346859.346539;s:10:"statusCode";i:200;s:8:"sqlCount";i:39;s:9:"mailCount";i:0;s:9:"mailFiles";a:0:{}s:10:"peakMemory";i:8694840;s:14:"processingTime";d:0.16938018798828125;}s:13:"5ffbf17440c38";a:12:{s:3:"tag";s:13:"5ffbf17440c38";s:3:"url";s:62:"http://192.168.0.32/invent/index.php?r=moving%2Fupdate&id=1774";s:4:"ajax";i:0;s:6:"method";s:3:"GET";s:2:"ip";s:12:"192.168.0.68";s:4:"time";d:1610346868.235186;s:10:"statusCode";i:200;s:8:"sqlCount";i:114;s:9:"mailCount";i:0;s:9:"mailFiles";a:0:{}s:10:"peakMemory";i:3375800;s:14:"processingTime";d:0.2919611930847168;}s:13:"5ffbf18d25cc8";a:12:{s:3:"tag";s:13:"5ffbf18d25cc8";s:3:"url";s:62:"http://192.168.0.32/invent/index.php?r=moving%2Fupdate&id=1774";s:4:"ajax";i:0;s:6:"method";s:4:"POST";s:2:"ip";s:12:"192.168.0.68";s:4:"time";d:1610346893.135497;s:10:"statusCode";i:302;s:8:"sqlCount";i:16;s:9:"mailCount";i:0;s:9:"mailFiles";a:0:{}s:10:"peakMemory";i:2030288;s:14:"processingTime";d:0.11212491989135742;}s:13:"5ffbf18d50f78";a:12:{s:3:"tag";s:13:"5ffbf18d50f78";s:3:"url";s:61:"http://192.168.0.32/invent/index.php?r=items%2Fupdate&id=1627";s:4:"ajax";i:0;s:6:"method";s:3:"GET";s:2:"ip";s:12:"192.168.0.68";s:4:"time";d:1610346893.287082;s:10:"statusCode";i:200;s:8:"sqlCount";i:39;s:9:"mailCount";i:0;s:9:"mailFiles";a:0:{}s:10:"peakMemory";i:8711064;s:14:"processingTime";d:0.1723499298095703;}s:13:"5ffbf197ce35d";a:12:{s:3:"tag";s:13:"5ffbf197ce35d";s:3:"url";s:61:"http://192.168.0.32/invent/index.php?r=items%2Fupdate&id=1627";s:4:"ajax";i:0;s:6:"method";s:4:"POST";s:2:"ip";s:12:"192.168.0.68";s:4:"time";d:1610346903.815122;s:10:"statusCode";i:302;s:8:"sqlCount";i:11;s:9:"mailCount";i:0;s:9:"mailFiles";a:0:{}s:10:"peakMemory";i:1905624;s:14:"processingTime";d:0.06562399864196777;}s:13:"5ffbf197e1a87";a:12:{s:3:"tag";s:13:"5ffbf197e1a87";s:3:"url";s:60:"http://192.168.0.32/invent/index.php?r=items%2Findex&id=1627";s:4:"ajax";i:0;s:6:"method";s:3:"GET";s:2:"ip";s:12:"192.168.0.68";s:4:"time";d:1610346903.900771;s:10:"statusCode";i:302;s:8:"sqlCount";i:20;s:9:"mailCount";i:0;s:9:"mailFiles";a:0:{}s:10:"peakMemory";i:62372728;s:14:"processingTime";d:0.7667179107666016;}s:13:"5ffbf198d98e1";a:12:{s:3:"tag";s:13:"5ffbf198d98e1";s:3:"url";s:60:"http://192.168.0.32/invent/index.php?r=items%2Findex&page=62";s:4:"ajax";i:0;s:6:"method";s:3:"GET";s:2:"ip";s:12:"192.168.0.68";s:4:"time";d:1610346904.864353;s:10:"statusCode";i:200;s:8:"sqlCount";i:56;s:9:"mailCount";i:0;s:9:"mailFiles";a:0:{}s:10:"peakMemory";i:3130624;s:14:"processingTime";d:0.0970301628112793;}s:13:"5ffbf1a0ced6d";a:12:{s:3:"tag";s:13:"5ffbf1a0ced6d";s:3:"url";s:66:"http://192.168.0.32/invent/index.php?r=items%2Fprint&id%5B%5D=1627";s:4:"ajax";i:0;s:6:"method";s:3:"GET";s:2:"ip";s:12:"192.168.0.68";s:4:"time";d:1610346912.80194;s:10:"statusCode";i:200;s:8:"sqlCount";i:17;s:9:"mailCount";i:0;s:9:"mailFiles";a:0:{}s:10:"peakMemory";i:22298584;s:14:"processingTime";d:1.3447551727294922;}s:13:"5ffbf20203ad4";a:12:{s:3:"tag";s:13:"5ffbf20203ad4";s:3:"url";s:60:"http://192.168.0.32/invent/index.php?r=items%2Findex&page=62";s:4:"ajax";i:0;s:6:"method";s:3:"GET";s:2:"ip";s:12:"192.168.0.68";s:4:"time";d:1610347009.993326;s:10:"statusCode";i:200;s:8:"sqlCount";i:56;s:9:"mailCount";i:0;s:9:"mailFiles";a:0:{}s:10:"peakMemory";i:3130464;s:14:"processingTime";d:0.1101369857788086;}s:13:"5ffbf3108ed4a";a:12:{s:3:"tag";s:13:"5ffbf3108ed4a";s:3:"url";s:53:"https://192.168.0.32/invent/index.php?r=items%2Fcheck";s:4:"ajax";i:0;s:6:"method";s:3:"GET";s:2:"ip";s:12:"192.168.0.13";s:4:"time";d:1610347280.566368;s:10:"statusCode";i:200;s:8:"sqlCount";i:103;s:9:"mailCount";i:0;s:9:"mailFiles";a:0:{}s:10:"peakMemory";i:3478840;s:14:"processingTime";d:0.2083148956298828;}s:13:"5ffbf32c15032";a:12:{s:3:"tag";s:13:"5ffbf32c15032";s:3:"url";s:53:"https://192.168.0.32/invent/index.php?r=items%2Fcheck";s:4:"ajax";i:1;s:6:"method";s:4:"POST";s:2:"ip";s:12:"192.168.0.13";s:4:"time";d:1610347308.05505;s:10:"statusCode";i:200;s:8:"sqlCount";i:102;s:9:"mailCount";i:0;s:9:"mailFiles";a:0:{}s:10:"peakMemory";i:3295088;s:14:"processingTime";d:0.16417908668518066;}s:13:"5ffc06f489964";a:12:{s:3:"tag";s:13:"5ffc06f489964";s:3:"url";s:72:"http://192.168.0.32/invent/index.php?r=items%2Findex&page=62&_pjax=%23p0";s:4:"ajax";i:1;s:6:"method";s:3:"GET";s:2:"ip";s:12:"192.168.0.68";s:4:"time";d:1610352372.536682;s:10:"statusCode";i:200;s:8:"sqlCount";i:48;s:9:"mailCount";i:0;s:9:"mailFiles";a:0:{}s:10:"peakMemory";i:2935384;s:14:"processingTime";d:0.09482789039611816;}s:13:"5ffd2e60d6b43";a:12:{s:3:"tag";s:13:"5ffd2e60d6b43";s:3:"url";s:60:"http://192.168.0.32/invent/index.php?r=items%2Findex&page=62";s:4:"ajax";i:0;s:6:"method";s:3:"GET";s:2:"ip";s:12:"192.168.0.68";s:4:"time";d:1610428000.796797;s:10:"statusCode";i:200;s:8:"sqlCount";i:56;s:9:"mailCount";i:0;s:9:"mailFiles";a:0:{}s:10:"peakMemory";i:3822440;s:14:"processingTime";d:0.18025708198547363;}s:13:"5ffd2e722db56";a:12:{s:3:"tag";s:13:"5ffd2e722db56";s:3:"url";s:72:"http://192.168.0.32/invent/index.php?r=items%2Findex&page=63&_pjax=%23p0";s:4:"ajax";i:1;s:6:"method";s:3:"GET";s:2:"ip";s:12:"192.168.0.68";s:4:"time";d:1610428018.135985;s:10:"statusCode";i:200;s:8:"sqlCount";i:48;s:9:"mailCount";i:0;s:9:"mailFiles";a:0:{}s:10:"peakMemory";i:2901808;s:14:"processingTime";d:0.11944699287414551;}s:13:"5ffd2e7504c68";a:12:{s:3:"tag";s:13:"5ffd2e7504c68";s:3:"url";s:84:"http://192.168.0.32/invent/index.php?r=items%2Findex&page=64&_pjax=%23p0&_pjax=%23p0";s:4:"ajax";i:1;s:6:"method";s:3:"GET";s:2:"ip";s:12:"192.168.0.68";s:4:"time";d:1610428020.992026;s:10:"statusCode";i:200;s:8:"sqlCount";i:48;s:9:"mailCount";i:0;s:9:"mailFiles";a:0:{}s:10:"peakMemory";i:2884928;s:14:"processingTime";d:0.09467196464538574;}s:13:"5ffd2e79c177d";a:12:{s:3:"tag";s:13:"5ffd2e79c177d";s:3:"url";s:84:"http://192.168.0.32/invent/index.php?r=items%2Findex&page=63&_pjax=%23p0&_pjax=%23p0";s:4:"ajax";i:1;s:6:"method";s:3:"GET";s:2:"ip";s:12:"192.168.0.68";s:4:"time";d:1610428025.746777;s:10:"statusCode";i:200;s:8:"sqlCount";i:48;s:9:"mailCount";i:0;s:9:"mailFiles";a:0:{}s:10:"peakMemory";i:2901872;s:14:"processingTime";d:0.13567900657653809;}s:13:"5ffd2e7c3688c";a:12:{s:3:"tag";s:13:"5ffd2e7c3688c";s:3:"url";s:36:"http://192.168.0.32/invent/index.php";s:4:"ajax";i:0;s:6:"method";s:3:"GET";s:2:"ip";s:12:"192.168.0.68";s:4:"time";d:1610428028.193528;s:10:"statusCode";i:500;s:8:"sqlCount";i:13;s:9:"mailCount";i:0;s:9:"mailFiles";a:0:{}s:10:"peakMemory";i:2760000;s:14:"processingTime";d:0.20721006393432617;}s:13:"5ffd2f26c2d74";a:12:{s:3:"tag";s:13:"5ffd2f26c2d74";s:3:"url";s:36:"http://192.168.0.32/invent/index.php";s:4:"ajax";i:0;s:6:"method";s:3:"GET";s:2:"ip";s:12:"192.168.0.68";s:4:"time";d:1610428198.779072;s:10:"statusCode";i:500;s:8:"sqlCount";i:13;s:9:"mailCount";i:0;s:9:"mailFiles";a:0:{}s:10:"peakMemory";i:2761888;s:14:"processingTime";d:0.04434609413146973;}s:13:"5ffd2fbf3bec2";a:12:{s:3:"tag";s:13:"5ffd2fbf3bec2";s:3:"url";s:36:"http://192.168.0.32/invent/index.php";s:4:"ajax";i:0;s:6:"method";s:3:"GET";s:2:"ip";s:12:"192.168.0.68";s:4:"time";d:1610428351.215204;s:10:"statusCode";i:200;s:8:"sqlCount";i:23;s:9:"mailCount";i:0;s:9:"mailFiles";a:0:{}s:10:"peakMemory";i:2506224;s:14:"processingTime";d:0.10228204727172852;}s:13:"5ffd2fce4c292";a:12:{s:3:"tag";s:13:"5ffd2fce4c292";s:3:"url";s:63:"http://192.168.0.32/invent/index.php?r=site%2Findex&dp-1-page=2";s:4:"ajax";i:0;s:6:"method";s:3:"GET";s:2:"ip";s:12:"192.168.0.68";s:4:"time";d:1610428366.293839;s:10:"statusCode";i:200;s:8:"sqlCount";i:23;s:9:"mailCount";i:0;s:9:"mailFiles";a:0:{}s:10:"peakMemory";i:2481424;s:14:"processingTime";d:0.08567595481872559;}} \ No newline at end of file diff --git a/runtime/logs/app.log b/runtime/logs/app.log index da5da51..cf234d1 100644 --- a/runtime/logs/app.log +++ b/runtime/logs/app.log @@ -80095,3 +80095,498 @@ $_SERVER = [ 'REQUEST_TIME_FLOAT' => 1609323003.9932 'REQUEST_TIME' => 1609323003 ] +2021-01-11 09:41:20 [192.168.0.13][2][-][warning][yii\debug\Module::checkAccess] Access to debugger is denied due to IP address restriction. The requesting IP address is 192.168.0.13 + in /var/www/invent/basic/views/layouts/main.php:104 + in /var/www/invent/basic/controllers/ItemsController.php:266 +2021-01-11 09:41:20 [192.168.0.13][2][-][warning][yii\debug\Module::checkAccess] Access to debugger is denied due to IP address restriction. The requesting IP address is 192.168.0.13 +2021-01-11 09:41:20 [192.168.0.13][2][-][info][application] $_GET = [ + 'r' => 'items/check' +] + +$_POST = [] + +$_FILES = [] + +$_COOKIE = [ + '_identity' => '0424a460104d24d440c97883d4a4b8af1b2fec1e80a4baf6c66247cbc223f9f7a:2:{i:0;s:9:\"_identity\";i:1;s:16:\"[2,null,2592000]\";}' +] + +$_SESSION = [ + '__flash' => [] + '__id' => 2 +] + +$_SERVER = [ + 'HTTPS' => 'on' + 'SSL_SERVER_S_DN_C' => 'RU' + 'SSL_SERVER_S_DN_ST' => 'MSK' + 'SSL_SERVER_S_DN_L' => 'Moscow' + 'SSL_SERVER_S_DN_O' => 'GBUV MO TERVETUPRAVLENIE N1' + 'SSL_SERVER_S_DN_OU' => 'IT' + 'SSL_SERVER_S_DN_CN' => '192.168.0.32' + 'SSL_SERVER_S_DN_Email' => 'tervet1@inbox.ru' + 'SSL_SERVER_I_DN_C' => 'RU' + 'SSL_SERVER_I_DN_ST' => 'MSK' + 'SSL_SERVER_I_DN_L' => 'Moscow' + 'SSL_SERVER_I_DN_O' => 'GBUV MO TERVETUPRAVLENIE N1' + 'SSL_SERVER_I_DN_OU' => 'IT' + 'SSL_SERVER_I_DN_CN' => '192.168.0.32' + 'SSL_SERVER_I_DN_Email' => 'tervet1@inbox.ru' + 'SSL_VERSION_INTERFACE' => 'mod_ssl/2.4.25' + 'SSL_VERSION_LIBRARY' => 'OpenSSL/1.0.2u' + 'SSL_PROTOCOL' => 'TLSv1.2' + 'SSL_SECURE_RENEG' => 'true' + 'SSL_COMPRESS_METHOD' => 'NULL' + 'SSL_CIPHER' => 'ECDHE-RSA-AES128-GCM-SHA256' + 'SSL_CIPHER_EXPORT' => 'false' + 'SSL_CIPHER_USEKEYSIZE' => '128' + 'SSL_CIPHER_ALGKEYSIZE' => '128' + 'SSL_CLIENT_VERIFY' => 'NONE' + 'SSL_SERVER_M_VERSION' => '1' + 'SSL_SERVER_M_SERIAL' => 'A339F5E73AD6C129' + 'SSL_SERVER_V_START' => 'Sep 19 06:04:13 2020 GMT' + 'SSL_SERVER_V_END' => 'May 29 06:04:13 2034 GMT' + 'SSL_SERVER_S_DN' => 'emailAddress=tervet1@inbox.ru,CN=192.168.0.32,OU=IT,O=GBUV MO TERVETUPRAVLENIE N1,L=Moscow,ST=MSK,C=RU' + 'SSL_SERVER_I_DN' => 'emailAddress=tervet1@inbox.ru,CN=192.168.0.32,OU=IT,O=GBUV MO TERVETUPRAVLENIE N1,L=Moscow,ST=MSK,C=RU' + 'SSL_SERVER_A_KEY' => 'rsaEncryption' + 'SSL_SERVER_A_SIG' => 'sha256WithRSAEncryption' + 'SSL_SESSION_RESUMED' => 'Initial' + 'HTTP_HOST' => '192.168.0.32' + 'HTTP_CONNECTION' => 'keep-alive' + 'HTTP_CACHE_CONTROL' => 'max-age=0' + 'HTTP_UPGRADE_INSECURE_REQUESTS' => '1' + 'HTTP_USER_AGENT' => 'Mozilla/5.0 (Linux; Android 6.0.1; Le X527) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/85.0.4183.101 Mobile Safari/537.36' + 'HTTP_ACCEPT' => 'text/html,application/xhtml+xml,application/xml;q=0.9,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3;q=0.9' + 'HTTP_SEC_FETCH_SITE' => 'same-origin' + 'HTTP_SEC_FETCH_MODE' => 'navigate' + 'HTTP_SEC_FETCH_USER' => '?1' + 'HTTP_SEC_FETCH_DEST' => 'document' + 'HTTP_REFERER' => 'https://192.168.0.32/invent/index.php?r=items%2Fcheck' + 'HTTP_ACCEPT_ENCODING' => 'gzip, deflate, br' + 'HTTP_ACCEPT_LANGUAGE' => 'ru-RU,ru;q=0.9,en-US;q=0.8,en;q=0.7' + 'HTTP_COOKIE' => '_identity=0424a460104d24d440c97883d4a4b8af1b2fec1e80a4baf6c66247cbc223f9f7a%3A2%3A%7Bi%3A0%3Bs%3A9%3A%22_identity%22%3Bi%3A1%3Bs%3A16%3A%22%5B2%2Cnull%2C2592000%5D%22%3B%7D' + 'PATH' => '/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin' + 'SERVER_SIGNATURE' => '
Apache/2.4.25 (Debian) Server at 192.168.0.32 Port 443
+' + 'SERVER_SOFTWARE' => 'Apache/2.4.25 (Debian)' + 'SERVER_NAME' => '192.168.0.32' + 'SERVER_ADDR' => '192.168.0.32' + 'SERVER_PORT' => '443' + 'REMOTE_ADDR' => '192.168.0.13' + 'DOCUMENT_ROOT' => '/var/www/html' + 'REQUEST_SCHEME' => 'https' + 'CONTEXT_PREFIX' => '/invent' + 'CONTEXT_DOCUMENT_ROOT' => '/var/www/invent/basic/web' + 'SERVER_ADMIN' => 'webmaster@localhost' + 'SCRIPT_FILENAME' => '/var/www/invent/basic/web/index.php' + 'REMOTE_PORT' => '47605' + 'GATEWAY_INTERFACE' => 'CGI/1.1' + 'SERVER_PROTOCOL' => 'HTTP/1.1' + 'REQUEST_METHOD' => 'GET' + 'QUERY_STRING' => 'r=items%2Fcheck' + 'REQUEST_URI' => '/invent/index.php?r=items%2Fcheck' + 'SCRIPT_NAME' => '/invent/index.php' + 'PHP_SELF' => '/invent/index.php' + 'REQUEST_TIME_FLOAT' => 1610347280.5664 + 'REQUEST_TIME' => 1610347280 +] +2021-01-11 09:41:48 [192.168.0.13][2][-][warning][yii\debug\Module::checkAccess] Access to debugger is denied due to IP address restriction. The requesting IP address is 192.168.0.13 + in /var/www/invent/basic/views/items/check.php:192 + in /var/www/invent/basic/controllers/ItemsController.php:266 +2021-01-11 09:41:48 [192.168.0.13][2][-][warning][yii\debug\Module::checkAccess] Access to debugger is denied due to IP address restriction. The requesting IP address is 192.168.0.13 + in /var/www/invent/basic/views/items/check.php:192 + in /var/www/invent/basic/controllers/ItemsController.php:266 +2021-01-11 09:41:48 [192.168.0.13][2][-][info][application] $_GET = [ + 'r' => 'items/check' +] + +$_POST = [ + '_csrf' => 'Z8Dr0awl1xcyzT8yyukraS2rpw7zu43zvPYpTdyIx5IqqJjhgXHhQGC-SFmro2M_eJPQWLzB_bHRr2Uv7rihwQ==' + 'Check' => [ + 'qrcheck' => '1630639, 3B1726X06799' + 'region' => '' + 'location' => '' + ] +] + +$_FILES = [] + +$_COOKIE = [ + '_identity' => '0424a460104d24d440c97883d4a4b8af1b2fec1e80a4baf6c66247cbc223f9f7a:2:{i:0;s:9:\"_identity\";i:1;s:16:\"[2,null,2592000]\";}' + 'PHPSESSID' => '9gbboi99p1fi3om5mgi7dr2m33' + '_csrf' => '0f500860b54cdb818156f8911cc63dd6598fc7948399fc149efdf6d535cb95ada:2:{i:0;s:5:\"_csrf\";i:1;s:32:\"Mhs0-T6WRswkaJHVU8wVOzpBmYLb20fS\";}' +] + +$_SESSION = [ + '__flash' => [] + '__id' => 2 +] + +$_SERVER = [ + 'HTTPS' => 'on' + 'SSL_SERVER_S_DN_C' => 'RU' + 'SSL_SERVER_S_DN_ST' => 'MSK' + 'SSL_SERVER_S_DN_L' => 'Moscow' + 'SSL_SERVER_S_DN_O' => 'GBUV MO TERVETUPRAVLENIE N1' + 'SSL_SERVER_S_DN_OU' => 'IT' + 'SSL_SERVER_S_DN_CN' => '192.168.0.32' + 'SSL_SERVER_S_DN_Email' => 'tervet1@inbox.ru' + 'SSL_SERVER_I_DN_C' => 'RU' + 'SSL_SERVER_I_DN_ST' => 'MSK' + 'SSL_SERVER_I_DN_L' => 'Moscow' + 'SSL_SERVER_I_DN_O' => 'GBUV MO TERVETUPRAVLENIE N1' + 'SSL_SERVER_I_DN_OU' => 'IT' + 'SSL_SERVER_I_DN_CN' => '192.168.0.32' + 'SSL_SERVER_I_DN_Email' => 'tervet1@inbox.ru' + 'SSL_VERSION_INTERFACE' => 'mod_ssl/2.4.25' + 'SSL_VERSION_LIBRARY' => 'OpenSSL/1.0.2u' + 'SSL_PROTOCOL' => 'TLSv1.2' + 'SSL_SECURE_RENEG' => 'true' + 'SSL_COMPRESS_METHOD' => 'NULL' + 'SSL_CIPHER' => 'ECDHE-RSA-AES128-GCM-SHA256' + 'SSL_CIPHER_EXPORT' => 'false' + 'SSL_CIPHER_USEKEYSIZE' => '128' + 'SSL_CIPHER_ALGKEYSIZE' => '128' + 'SSL_CLIENT_VERIFY' => 'NONE' + 'SSL_SERVER_M_VERSION' => '1' + 'SSL_SERVER_M_SERIAL' => 'A339F5E73AD6C129' + 'SSL_SERVER_V_START' => 'Sep 19 06:04:13 2020 GMT' + 'SSL_SERVER_V_END' => 'May 29 06:04:13 2034 GMT' + 'SSL_SERVER_S_DN' => 'emailAddress=tervet1@inbox.ru,CN=192.168.0.32,OU=IT,O=GBUV MO TERVETUPRAVLENIE N1,L=Moscow,ST=MSK,C=RU' + 'SSL_SERVER_I_DN' => 'emailAddress=tervet1@inbox.ru,CN=192.168.0.32,OU=IT,O=GBUV MO TERVETUPRAVLENIE N1,L=Moscow,ST=MSK,C=RU' + 'SSL_SERVER_A_KEY' => 'rsaEncryption' + 'SSL_SERVER_A_SIG' => 'sha256WithRSAEncryption' + 'SSL_SESSION_ID' => 'a55f55fda6367926679498aa77880a624ddecaa475782a556f67403b32b05166' + 'SSL_SESSION_RESUMED' => 'Resumed' + 'HTTP_HOST' => '192.168.0.32' + 'HTTP_CONNECTION' => 'keep-alive' + 'CONTENT_LENGTH' => '548' + 'HTTP_ACCEPT' => 'text/html, */*; q=0.01' + 'HTTP_X_CSRF_TOKEN' => 'Z8Dr0awl1xcyzT8yyukraS2rpw7zu43zvPYpTdyIx5IqqJjhgXHhQGC-SFmro2M_eJPQWLzB_bHRr2Uv7rihwQ==' + 'HTTP_X_REQUESTED_WITH' => 'XMLHttpRequest' + 'HTTP_X_PJAX' => 'true' + 'HTTP_X_PJAX_CONTAINER' => '#p0' + 'HTTP_USER_AGENT' => 'Mozilla/5.0 (Linux; Android 6.0.1; Le X527) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/85.0.4183.101 Mobile Safari/537.36' + 'CONTENT_TYPE' => 'multipart/form-data; boundary=----WebKitFormBoundaryCOTvs1nq1m2lmOy5' + 'HTTP_ORIGIN' => 'https://192.168.0.32' + 'HTTP_SEC_FETCH_SITE' => 'same-origin' + 'HTTP_SEC_FETCH_MODE' => 'cors' + 'HTTP_SEC_FETCH_DEST' => 'empty' + 'HTTP_REFERER' => 'https://192.168.0.32/invent/index.php?r=items%2Fcheck' + 'HTTP_ACCEPT_ENCODING' => 'gzip, deflate, br' + 'HTTP_ACCEPT_LANGUAGE' => 'ru-RU,ru;q=0.9,en-US;q=0.8,en;q=0.7' + 'HTTP_COOKIE' => '_identity=0424a460104d24d440c97883d4a4b8af1b2fec1e80a4baf6c66247cbc223f9f7a%3A2%3A%7Bi%3A0%3Bs%3A9%3A%22_identity%22%3Bi%3A1%3Bs%3A16%3A%22%5B2%2Cnull%2C2592000%5D%22%3B%7D; PHPSESSID=9gbboi99p1fi3om5mgi7dr2m33; _csrf=0f500860b54cdb818156f8911cc63dd6598fc7948399fc149efdf6d535cb95ada%3A2%3A%7Bi%3A0%3Bs%3A5%3A%22_csrf%22%3Bi%3A1%3Bs%3A32%3A%22Mhs0-T6WRswkaJHVU8wVOzpBmYLb20fS%22%3B%7D' + 'PATH' => '/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin' + 'SERVER_SIGNATURE' => '
Apache/2.4.25 (Debian) Server at 192.168.0.32 Port 443
+' + 'SERVER_SOFTWARE' => 'Apache/2.4.25 (Debian)' + 'SERVER_NAME' => '192.168.0.32' + 'SERVER_ADDR' => '192.168.0.32' + 'SERVER_PORT' => '443' + 'REMOTE_ADDR' => '192.168.0.13' + 'DOCUMENT_ROOT' => '/var/www/html' + 'REQUEST_SCHEME' => 'https' + 'CONTEXT_PREFIX' => '/invent' + 'CONTEXT_DOCUMENT_ROOT' => '/var/www/invent/basic/web' + 'SERVER_ADMIN' => 'webmaster@localhost' + 'SCRIPT_FILENAME' => '/var/www/invent/basic/web/index.php' + 'REMOTE_PORT' => '47634' + 'GATEWAY_INTERFACE' => 'CGI/1.1' + 'SERVER_PROTOCOL' => 'HTTP/1.1' + 'REQUEST_METHOD' => 'POST' + 'QUERY_STRING' => 'r=items%2Fcheck' + 'REQUEST_URI' => '/invent/index.php?r=items%2Fcheck' + 'SCRIPT_NAME' => '/invent/index.php' + 'PHP_SELF' => '/invent/index.php' + 'REQUEST_TIME_FLOAT' => 1610347308.055 + 'REQUEST_TIME' => 1610347308 +] +2021-01-12 08:07:08 [192.168.0.68][1][v8ljrlq46s8u2tc1i37hav314q][error][yii\db\Exception] PDOException: SQLSTATE[42883]: Undefined function: 7 ОШИБКА: оператор не существует: integer = boolean +LINE 1: ...moving" GROUP BY "item_id")) AND ("items".checked = true)) "... + ^ +HINT: Оператор с данными именем и типами аргументов не найден. Возможно, вам следует добавить явные приведения типов. in /var/www/invent/basic/vendor/yiisoft/yii2/db/Command.php:1299 +Stack trace: +#0 /var/www/invent/basic/vendor/yiisoft/yii2/db/Command.php(1299): PDOStatement->execute() +#1 /var/www/invent/basic/vendor/yiisoft/yii2/db/Command.php(1165): yii\db\Command->internalExecute() +#2 /var/www/invent/basic/vendor/yiisoft/yii2/db/Command.php(433): yii\db\Command->queryInternal() +#3 /var/www/invent/basic/vendor/yiisoft/yii2/db/Query.php(503): yii\db\Command->queryScalar() +#4 /var/www/invent/basic/vendor/yiisoft/yii2/db/ActiveQuery.php(352): yii\db\Query->queryScalar() +#5 /var/www/invent/basic/vendor/yiisoft/yii2/db/Query.php(366): yii\db\ActiveQuery->queryScalar() +#6 /var/www/invent/basic/vendor/yiisoft/yii2/data/ActiveDataProvider.php(169): yii\db\Query->count() +#7 /var/www/invent/basic/vendor/yiisoft/yii2/data/BaseDataProvider.php(169): yii\data\ActiveDataProvider->prepareTotalCount() +#8 /var/www/invent/basic/vendor/yiisoft/yii2/data/ActiveDataProvider.php(106): yii\data\BaseDataProvider->getTotalCount() +#9 /var/www/invent/basic/vendor/yiisoft/yii2/data/BaseDataProvider.php(101): yii\data\ActiveDataProvider->prepareModels() +#10 /var/www/invent/basic/vendor/yiisoft/yii2/data/BaseDataProvider.php(114): yii\data\BaseDataProvider->prepare() +#11 /var/www/invent/basic/vendor/yiisoft/yii2/data/BaseDataProvider.php(155): yii\data\BaseDataProvider->getModels() +#12 /var/www/invent/basic/vendor/yiisoft/yii2/widgets/BaseListView.php(190): yii\data\BaseDataProvider->getCount() +#13 /var/www/invent/basic/vendor/yiisoft/yii2/widgets/BaseListView.php(158): yii\widgets\BaseListView->renderSummary() +#14 /var/www/invent/basic/vendor/yiisoft/yii2/grid/GridView.php(326): yii\widgets\BaseListView->renderSection() +#15 /var/www/invent/basic/vendor/yiisoft/yii2/widgets/BaseListView.php(135): yii\grid\GridView->renderSection() +#16 [internal function]: yii\widgets\BaseListView->yii\widgets\{closure}() +#17 /var/www/invent/basic/vendor/yiisoft/yii2/widgets/BaseListView.php(138): preg_replace_callback() +#18 /var/www/invent/basic/vendor/yiisoft/yii2/grid/GridView.php(301): yii\widgets\BaseListView->run() +#19 /var/www/invent/basic/vendor/yiisoft/yii2/base/Widget.php(141): yii\grid\GridView->run() +#20 /var/www/invent/basic/views/site/index.php(23): yii\base\Widget::widget() +#21 /var/www/invent/basic/vendor/yiisoft/yii2/base/View.php(348): require('/var/www/invent...') +#22 /var/www/invent/basic/vendor/yiisoft/yii2/base/View.php(257): yii\base\View->renderPhpFile() +#23 /var/www/invent/basic/vendor/yiisoft/yii2/base/View.php(156): yii\base\View->renderFile() +#24 /var/www/invent/basic/vendor/yiisoft/yii2/base/Controller.php(410): yii\base\View->render() +#25 /var/www/invent/basic/controllers/SiteController.php(71): yii\base\Controller->render() +#26 [internal function]: app\controllers\SiteController->actionIndex() +#27 /var/www/invent/basic/vendor/yiisoft/yii2/base/InlineAction.php(57): call_user_func_array() +#28 /var/www/invent/basic/vendor/yiisoft/yii2/base/Controller.php(181): yii\base\InlineAction->runWithParams() +#29 /var/www/invent/basic/vendor/yiisoft/yii2/base/Module.php(534): yii\base\Controller->runAction() +#30 /var/www/invent/basic/vendor/yiisoft/yii2/web/Application.php(104): yii\base\Module->runAction() +#31 /var/www/invent/basic/vendor/yiisoft/yii2/base/Application.php(392): yii\web\Application->handleRequest() +#32 /var/www/invent/basic/web/index.php(12): yii\base\Application->run() +#33 {main} + +Next yii\db\Exception: SQLSTATE[42883]: Undefined function: 7 ОШИБКА: оператор не существует: integer = boolean +LINE 1: ...moving" GROUP BY "item_id")) AND ("items".checked = true)) "... + ^ +HINT: Оператор с данными именем и типами аргументов не найден. Возможно, вам следует добавить явные приведения типов. +The SQL being executed was: SELECT COUNT(*) FROM (SELECT "regions"."name", count("items".id) AS "icount", count(c.tid) AS "ccount" FROM "regions" LEFT JOIN "locations" ON "regions"."id" = "locations"."region_id" LEFT JOIN "moving" ON "locations"."id" = "moving"."location_id" LEFT JOIN "items" ON "moving"."item_id" = "items"."id" LEFT JOIN (SELECT "regions"."id", "items"."id" AS "tid" FROM "regions" LEFT JOIN "locations" ON "regions"."id" = "locations"."region_id" LEFT JOIN "moving" ON "locations"."id" = "moving"."location_id" LEFT JOIN "items" ON "moving"."item_id" = "items"."id" WHERE ("moving"."id" IN (SELECT DISTINCT MAX(id) AS "id" FROM "moving" GROUP BY "item_id")) AND ("items".checked = true)) "c" ON "regions".id = c.id AND "items".id = c.tid WHERE "moving"."id" IN (SELECT DISTINCT MAX(id) AS "id" FROM "moving" GROUP BY "item_id") GROUP BY "regions"."id") "c" in /var/www/invent/basic/vendor/yiisoft/yii2/db/Schema.php:678 +Stack trace: +#0 /var/www/invent/basic/vendor/yiisoft/yii2/db/Command.php(1304): yii\db\Schema->convertException() +#1 /var/www/invent/basic/vendor/yiisoft/yii2/db/Command.php(1165): yii\db\Command->internalExecute() +#2 /var/www/invent/basic/vendor/yiisoft/yii2/db/Command.php(433): yii\db\Command->queryInternal() +#3 /var/www/invent/basic/vendor/yiisoft/yii2/db/Query.php(503): yii\db\Command->queryScalar() +#4 /var/www/invent/basic/vendor/yiisoft/yii2/db/ActiveQuery.php(352): yii\db\Query->queryScalar() +#5 /var/www/invent/basic/vendor/yiisoft/yii2/db/Query.php(366): yii\db\ActiveQuery->queryScalar() +#6 /var/www/invent/basic/vendor/yiisoft/yii2/data/ActiveDataProvider.php(169): yii\db\Query->count() +#7 /var/www/invent/basic/vendor/yiisoft/yii2/data/BaseDataProvider.php(169): yii\data\ActiveDataProvider->prepareTotalCount() +#8 /var/www/invent/basic/vendor/yiisoft/yii2/data/ActiveDataProvider.php(106): yii\data\BaseDataProvider->getTotalCount() +#9 /var/www/invent/basic/vendor/yiisoft/yii2/data/BaseDataProvider.php(101): yii\data\ActiveDataProvider->prepareModels() +#10 /var/www/invent/basic/vendor/yiisoft/yii2/data/BaseDataProvider.php(114): yii\data\BaseDataProvider->prepare() +#11 /var/www/invent/basic/vendor/yiisoft/yii2/data/BaseDataProvider.php(155): yii\data\BaseDataProvider->getModels() +#12 /var/www/invent/basic/vendor/yiisoft/yii2/widgets/BaseListView.php(190): yii\data\BaseDataProvider->getCount() +#13 /var/www/invent/basic/vendor/yiisoft/yii2/widgets/BaseListView.php(158): yii\widgets\BaseListView->renderSummary() +#14 /var/www/invent/basic/vendor/yiisoft/yii2/grid/GridView.php(326): yii\widgets\BaseListView->renderSection() +#15 /var/www/invent/basic/vendor/yiisoft/yii2/widgets/BaseListView.php(135): yii\grid\GridView->renderSection() +#16 [internal function]: yii\widgets\BaseListView->yii\widgets\{closure}() +#17 /var/www/invent/basic/vendor/yiisoft/yii2/widgets/BaseListView.php(138): preg_replace_callback() +#18 /var/www/invent/basic/vendor/yiisoft/yii2/grid/GridView.php(301): yii\widgets\BaseListView->run() +#19 /var/www/invent/basic/vendor/yiisoft/yii2/base/Widget.php(141): yii\grid\GridView->run() +#20 /var/www/invent/basic/views/site/index.php(23): yii\base\Widget::widget() +#21 /var/www/invent/basic/vendor/yiisoft/yii2/base/View.php(348): require('/var/www/invent...') +#22 /var/www/invent/basic/vendor/yiisoft/yii2/base/View.php(257): yii\base\View->renderPhpFile() +#23 /var/www/invent/basic/vendor/yiisoft/yii2/base/View.php(156): yii\base\View->renderFile() +#24 /var/www/invent/basic/vendor/yiisoft/yii2/base/Controller.php(410): yii\base\View->render() +#25 /var/www/invent/basic/controllers/SiteController.php(71): yii\base\Controller->render() +#26 [internal function]: app\controllers\SiteController->actionIndex() +#27 /var/www/invent/basic/vendor/yiisoft/yii2/base/InlineAction.php(57): call_user_func_array() +#28 /var/www/invent/basic/vendor/yiisoft/yii2/base/Controller.php(181): yii\base\InlineAction->runWithParams() +#29 /var/www/invent/basic/vendor/yiisoft/yii2/base/Module.php(534): yii\base\Controller->runAction() +#30 /var/www/invent/basic/vendor/yiisoft/yii2/web/Application.php(104): yii\base\Module->runAction() +#31 /var/www/invent/basic/vendor/yiisoft/yii2/base/Application.php(392): yii\web\Application->handleRequest() +#32 /var/www/invent/basic/web/index.php(12): yii\base\Application->run() +#33 {main} +Additional Information: +Array +( + [0] => 42883 + [1] => 7 + [2] => ОШИБКА: оператор не существует: integer = boolean +LINE 1: ...moving" GROUP BY "item_id")) AND ("items".checked = true)) "... + ^ +HINT: Оператор с данными именем и типами аргументов не найден. Возможно, вам следует добавить явные приведения типов. +) + +2021-01-12 08:07:08 [192.168.0.68][1][v8ljrlq46s8u2tc1i37hav314q][info][application] $_GET = [] + +$_POST = [] + +$_FILES = [] + +$_COOKIE = [ + '_identity' => '992cc680fcb56a39cf1a309dc6073fe21f1604f6f2a8c4dc514ba5f1d621968aa:2:{i:0;s:9:\"_identity\";i:1;s:16:\"[1,null,2592000]\";}' + '_csrf' => '188c1070b85264bfb7009e402414232b666a9bdda02a89a464df5a7ba83aeb95a:2:{i:0;s:5:\"_csrf\";i:1;s:32:\"3qwp9kFdsMrtfwkRmqxA48QwY5wZFHP5\";}' + 'PHPSESSID' => 'v8ljrlq46s8u2tc1i37hav314q' +] + +$_SESSION = [ + '__flash' => [] + '__id' => 1 +] + +$_SERVER = [ + 'HTTP_HOST' => '192.168.0.32' + 'HTTP_USER_AGENT' => 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:84.0) Gecko/20100101 Firefox/84.0' + 'HTTP_ACCEPT' => 'text/html,application/xhtml+xml,application/xml;q=0.9,image/webp,*/*;q=0.8' + 'HTTP_ACCEPT_LANGUAGE' => 'ru-RU,ru;q=0.8,en-US;q=0.5,en;q=0.3' + 'HTTP_ACCEPT_ENCODING' => 'gzip, deflate' + 'HTTP_DNT' => '1' + 'HTTP_CONNECTION' => 'keep-alive' + 'HTTP_REFERER' => 'http://192.168.0.32/invent/index.php?r=items%2Findex&page=63' + 'HTTP_COOKIE' => '_identity=992cc680fcb56a39cf1a309dc6073fe21f1604f6f2a8c4dc514ba5f1d621968aa%3A2%3A%7Bi%3A0%3Bs%3A9%3A%22_identity%22%3Bi%3A1%3Bs%3A16%3A%22%5B1%2Cnull%2C2592000%5D%22%3B%7D; _csrf=188c1070b85264bfb7009e402414232b666a9bdda02a89a464df5a7ba83aeb95a%3A2%3A%7Bi%3A0%3Bs%3A5%3A%22_csrf%22%3Bi%3A1%3Bs%3A32%3A%223qwp9kFdsMrtfwkRmqxA48QwY5wZFHP5%22%3B%7D; PHPSESSID=v8ljrlq46s8u2tc1i37hav314q' + 'HTTP_UPGRADE_INSECURE_REQUESTS' => '1' + 'PATH' => '/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin' + 'SERVER_SIGNATURE' => '
Apache/2.4.25 (Debian) Server at 192.168.0.32 Port 80
+' + 'SERVER_SOFTWARE' => 'Apache/2.4.25 (Debian)' + 'SERVER_NAME' => '192.168.0.32' + 'SERVER_ADDR' => '192.168.0.32' + 'SERVER_PORT' => '80' + 'REMOTE_ADDR' => '192.168.0.68' + 'DOCUMENT_ROOT' => '/var/www/html' + 'REQUEST_SCHEME' => 'http' + 'CONTEXT_PREFIX' => '/invent' + 'CONTEXT_DOCUMENT_ROOT' => '/var/www/invent/basic/web' + 'SERVER_ADMIN' => 'webmaster@localhost' + 'SCRIPT_FILENAME' => '/var/www/invent/basic/web/index.php' + 'REMOTE_PORT' => '57762' + 'GATEWAY_INTERFACE' => 'CGI/1.1' + 'SERVER_PROTOCOL' => 'HTTP/1.1' + 'REQUEST_METHOD' => 'GET' + 'QUERY_STRING' => '' + 'REQUEST_URI' => '/invent/index.php' + 'SCRIPT_NAME' => '/invent/index.php' + 'PHP_SELF' => '/invent/index.php' + 'REQUEST_TIME_FLOAT' => 1610428028.1935 + 'REQUEST_TIME' => 1610428028 +] +2021-01-12 08:09:58 [192.168.0.68][1][v8ljrlq46s8u2tc1i37hav314q][error][yii\db\Exception] PDOException: SQLSTATE[42883]: Undefined function: 7 ОШИБКА: оператор не существует: integer = boolean +LINE 1: ...moving" GROUP BY "item_id")) AND ("items".checked = true)) "... + ^ +HINT: Оператор с данными именем и типами аргументов не найден. Возможно, вам следует добавить явные приведения типов. in /var/www/invent/basic/vendor/yiisoft/yii2/db/Command.php:1299 +Stack trace: +#0 /var/www/invent/basic/vendor/yiisoft/yii2/db/Command.php(1299): PDOStatement->execute() +#1 /var/www/invent/basic/vendor/yiisoft/yii2/db/Command.php(1165): yii\db\Command->internalExecute() +#2 /var/www/invent/basic/vendor/yiisoft/yii2/db/Command.php(433): yii\db\Command->queryInternal() +#3 /var/www/invent/basic/vendor/yiisoft/yii2/db/Query.php(503): yii\db\Command->queryScalar() +#4 /var/www/invent/basic/vendor/yiisoft/yii2/db/ActiveQuery.php(352): yii\db\Query->queryScalar() +#5 /var/www/invent/basic/vendor/yiisoft/yii2/db/Query.php(366): yii\db\ActiveQuery->queryScalar() +#6 /var/www/invent/basic/vendor/yiisoft/yii2/data/ActiveDataProvider.php(169): yii\db\Query->count() +#7 /var/www/invent/basic/vendor/yiisoft/yii2/data/BaseDataProvider.php(169): yii\data\ActiveDataProvider->prepareTotalCount() +#8 /var/www/invent/basic/vendor/yiisoft/yii2/data/ActiveDataProvider.php(106): yii\data\BaseDataProvider->getTotalCount() +#9 /var/www/invent/basic/vendor/yiisoft/yii2/data/BaseDataProvider.php(101): yii\data\ActiveDataProvider->prepareModels() +#10 /var/www/invent/basic/vendor/yiisoft/yii2/data/BaseDataProvider.php(114): yii\data\BaseDataProvider->prepare() +#11 /var/www/invent/basic/vendor/yiisoft/yii2/data/BaseDataProvider.php(155): yii\data\BaseDataProvider->getModels() +#12 /var/www/invent/basic/vendor/yiisoft/yii2/widgets/BaseListView.php(190): yii\data\BaseDataProvider->getCount() +#13 /var/www/invent/basic/vendor/yiisoft/yii2/widgets/BaseListView.php(158): yii\widgets\BaseListView->renderSummary() +#14 /var/www/invent/basic/vendor/yiisoft/yii2/grid/GridView.php(326): yii\widgets\BaseListView->renderSection() +#15 /var/www/invent/basic/vendor/yiisoft/yii2/widgets/BaseListView.php(135): yii\grid\GridView->renderSection() +#16 [internal function]: yii\widgets\BaseListView->yii\widgets\{closure}() +#17 /var/www/invent/basic/vendor/yiisoft/yii2/widgets/BaseListView.php(138): preg_replace_callback() +#18 /var/www/invent/basic/vendor/yiisoft/yii2/grid/GridView.php(301): yii\widgets\BaseListView->run() +#19 /var/www/invent/basic/vendor/yiisoft/yii2/base/Widget.php(141): yii\grid\GridView->run() +#20 /var/www/invent/basic/views/site/index.php(23): yii\base\Widget::widget() +#21 /var/www/invent/basic/vendor/yiisoft/yii2/base/View.php(348): require('/var/www/invent...') +#22 /var/www/invent/basic/vendor/yiisoft/yii2/base/View.php(257): yii\base\View->renderPhpFile() +#23 /var/www/invent/basic/vendor/yiisoft/yii2/base/View.php(156): yii\base\View->renderFile() +#24 /var/www/invent/basic/vendor/yiisoft/yii2/base/Controller.php(410): yii\base\View->render() +#25 /var/www/invent/basic/controllers/SiteController.php(71): yii\base\Controller->render() +#26 [internal function]: app\controllers\SiteController->actionIndex() +#27 /var/www/invent/basic/vendor/yiisoft/yii2/base/InlineAction.php(57): call_user_func_array() +#28 /var/www/invent/basic/vendor/yiisoft/yii2/base/Controller.php(181): yii\base\InlineAction->runWithParams() +#29 /var/www/invent/basic/vendor/yiisoft/yii2/base/Module.php(534): yii\base\Controller->runAction() +#30 /var/www/invent/basic/vendor/yiisoft/yii2/web/Application.php(104): yii\base\Module->runAction() +#31 /var/www/invent/basic/vendor/yiisoft/yii2/base/Application.php(392): yii\web\Application->handleRequest() +#32 /var/www/invent/basic/web/index.php(12): yii\base\Application->run() +#33 {main} + +Next yii\db\Exception: SQLSTATE[42883]: Undefined function: 7 ОШИБКА: оператор не существует: integer = boolean +LINE 1: ...moving" GROUP BY "item_id")) AND ("items".checked = true)) "... + ^ +HINT: Оператор с данными именем и типами аргументов не найден. Возможно, вам следует добавить явные приведения типов. +The SQL being executed was: SELECT COUNT(*) FROM (SELECT "regions"."name", count("items".id) AS "icount", count(c.tid) AS "ccount" FROM "regions" LEFT JOIN "locations" ON "regions"."id" = "locations"."region_id" LEFT JOIN "moving" ON "locations"."id" = "moving"."location_id" LEFT JOIN "items" ON "moving"."item_id" = "items"."id" LEFT JOIN (SELECT "regions"."id", "items"."id" AS "tid" FROM "regions" LEFT JOIN "locations" ON "regions"."id" = "locations"."region_id" LEFT JOIN "moving" ON "locations"."id" = "moving"."location_id" LEFT JOIN "items" ON "moving"."item_id" = "items"."id" WHERE ("moving"."id" IN (SELECT DISTINCT MAX(id) AS "id" FROM "moving" GROUP BY "item_id")) AND ("items".checked = true)) "c" ON "regions".id = c.id AND "items".id = c.tid WHERE "moving"."id" IN (SELECT DISTINCT MAX(id) AS "id" FROM "moving" GROUP BY "item_id") GROUP BY "regions"."id") "c" in /var/www/invent/basic/vendor/yiisoft/yii2/db/Schema.php:678 +Stack trace: +#0 /var/www/invent/basic/vendor/yiisoft/yii2/db/Command.php(1304): yii\db\Schema->convertException() +#1 /var/www/invent/basic/vendor/yiisoft/yii2/db/Command.php(1165): yii\db\Command->internalExecute() +#2 /var/www/invent/basic/vendor/yiisoft/yii2/db/Command.php(433): yii\db\Command->queryInternal() +#3 /var/www/invent/basic/vendor/yiisoft/yii2/db/Query.php(503): yii\db\Command->queryScalar() +#4 /var/www/invent/basic/vendor/yiisoft/yii2/db/ActiveQuery.php(352): yii\db\Query->queryScalar() +#5 /var/www/invent/basic/vendor/yiisoft/yii2/db/Query.php(366): yii\db\ActiveQuery->queryScalar() +#6 /var/www/invent/basic/vendor/yiisoft/yii2/data/ActiveDataProvider.php(169): yii\db\Query->count() +#7 /var/www/invent/basic/vendor/yiisoft/yii2/data/BaseDataProvider.php(169): yii\data\ActiveDataProvider->prepareTotalCount() +#8 /var/www/invent/basic/vendor/yiisoft/yii2/data/ActiveDataProvider.php(106): yii\data\BaseDataProvider->getTotalCount() +#9 /var/www/invent/basic/vendor/yiisoft/yii2/data/BaseDataProvider.php(101): yii\data\ActiveDataProvider->prepareModels() +#10 /var/www/invent/basic/vendor/yiisoft/yii2/data/BaseDataProvider.php(114): yii\data\BaseDataProvider->prepare() +#11 /var/www/invent/basic/vendor/yiisoft/yii2/data/BaseDataProvider.php(155): yii\data\BaseDataProvider->getModels() +#12 /var/www/invent/basic/vendor/yiisoft/yii2/widgets/BaseListView.php(190): yii\data\BaseDataProvider->getCount() +#13 /var/www/invent/basic/vendor/yiisoft/yii2/widgets/BaseListView.php(158): yii\widgets\BaseListView->renderSummary() +#14 /var/www/invent/basic/vendor/yiisoft/yii2/grid/GridView.php(326): yii\widgets\BaseListView->renderSection() +#15 /var/www/invent/basic/vendor/yiisoft/yii2/widgets/BaseListView.php(135): yii\grid\GridView->renderSection() +#16 [internal function]: yii\widgets\BaseListView->yii\widgets\{closure}() +#17 /var/www/invent/basic/vendor/yiisoft/yii2/widgets/BaseListView.php(138): preg_replace_callback() +#18 /var/www/invent/basic/vendor/yiisoft/yii2/grid/GridView.php(301): yii\widgets\BaseListView->run() +#19 /var/www/invent/basic/vendor/yiisoft/yii2/base/Widget.php(141): yii\grid\GridView->run() +#20 /var/www/invent/basic/views/site/index.php(23): yii\base\Widget::widget() +#21 /var/www/invent/basic/vendor/yiisoft/yii2/base/View.php(348): require('/var/www/invent...') +#22 /var/www/invent/basic/vendor/yiisoft/yii2/base/View.php(257): yii\base\View->renderPhpFile() +#23 /var/www/invent/basic/vendor/yiisoft/yii2/base/View.php(156): yii\base\View->renderFile() +#24 /var/www/invent/basic/vendor/yiisoft/yii2/base/Controller.php(410): yii\base\View->render() +#25 /var/www/invent/basic/controllers/SiteController.php(71): yii\base\Controller->render() +#26 [internal function]: app\controllers\SiteController->actionIndex() +#27 /var/www/invent/basic/vendor/yiisoft/yii2/base/InlineAction.php(57): call_user_func_array() +#28 /var/www/invent/basic/vendor/yiisoft/yii2/base/Controller.php(181): yii\base\InlineAction->runWithParams() +#29 /var/www/invent/basic/vendor/yiisoft/yii2/base/Module.php(534): yii\base\Controller->runAction() +#30 /var/www/invent/basic/vendor/yiisoft/yii2/web/Application.php(104): yii\base\Module->runAction() +#31 /var/www/invent/basic/vendor/yiisoft/yii2/base/Application.php(392): yii\web\Application->handleRequest() +#32 /var/www/invent/basic/web/index.php(12): yii\base\Application->run() +#33 {main} +Additional Information: +Array +( + [0] => 42883 + [1] => 7 + [2] => ОШИБКА: оператор не существует: integer = boolean +LINE 1: ...moving" GROUP BY "item_id")) AND ("items".checked = true)) "... + ^ +HINT: Оператор с данными именем и типами аргументов не найден. Возможно, вам следует добавить явные приведения типов. +) + +2021-01-12 08:09:58 [192.168.0.68][1][v8ljrlq46s8u2tc1i37hav314q][info][application] $_GET = [] + +$_POST = [] + +$_FILES = [] + +$_COOKIE = [ + '_identity' => '992cc680fcb56a39cf1a309dc6073fe21f1604f6f2a8c4dc514ba5f1d621968aa:2:{i:0;s:9:\"_identity\";i:1;s:16:\"[1,null,2592000]\";}' + '_csrf' => '188c1070b85264bfb7009e402414232b666a9bdda02a89a464df5a7ba83aeb95a:2:{i:0;s:5:\"_csrf\";i:1;s:32:\"3qwp9kFdsMrtfwkRmqxA48QwY5wZFHP5\";}' + 'PHPSESSID' => 'v8ljrlq46s8u2tc1i37hav314q' +] + +$_SESSION = [ + '__flash' => [] + '__id' => 1 +] + +$_SERVER = [ + 'HTTP_HOST' => '192.168.0.32' + 'HTTP_USER_AGENT' => 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:84.0) Gecko/20100101 Firefox/84.0' + 'HTTP_ACCEPT' => 'text/html,application/xhtml+xml,application/xml;q=0.9,image/webp,*/*;q=0.8' + 'HTTP_ACCEPT_LANGUAGE' => 'ru-RU,ru;q=0.8,en-US;q=0.5,en;q=0.3' + 'HTTP_ACCEPT_ENCODING' => 'gzip, deflate' + 'HTTP_REFERER' => 'http://192.168.0.32/invent/index.php?r=items%2Findex&page=63' + 'HTTP_DNT' => '1' + 'HTTP_CONNECTION' => 'keep-alive' + 'HTTP_COOKIE' => '_identity=992cc680fcb56a39cf1a309dc6073fe21f1604f6f2a8c4dc514ba5f1d621968aa%3A2%3A%7Bi%3A0%3Bs%3A9%3A%22_identity%22%3Bi%3A1%3Bs%3A16%3A%22%5B1%2Cnull%2C2592000%5D%22%3B%7D; _csrf=188c1070b85264bfb7009e402414232b666a9bdda02a89a464df5a7ba83aeb95a%3A2%3A%7Bi%3A0%3Bs%3A5%3A%22_csrf%22%3Bi%3A1%3Bs%3A32%3A%223qwp9kFdsMrtfwkRmqxA48QwY5wZFHP5%22%3B%7D; PHPSESSID=v8ljrlq46s8u2tc1i37hav314q' + 'HTTP_UPGRADE_INSECURE_REQUESTS' => '1' + 'HTTP_CACHE_CONTROL' => 'max-age=0' + 'PATH' => '/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin' + 'SERVER_SIGNATURE' => '
Apache/2.4.25 (Debian) Server at 192.168.0.32 Port 80
+' + 'SERVER_SOFTWARE' => 'Apache/2.4.25 (Debian)' + 'SERVER_NAME' => '192.168.0.32' + 'SERVER_ADDR' => '192.168.0.32' + 'SERVER_PORT' => '80' + 'REMOTE_ADDR' => '192.168.0.68' + 'DOCUMENT_ROOT' => '/var/www/html' + 'REQUEST_SCHEME' => 'http' + 'CONTEXT_PREFIX' => '/invent' + 'CONTEXT_DOCUMENT_ROOT' => '/var/www/invent/basic/web' + 'SERVER_ADMIN' => 'webmaster@localhost' + 'SCRIPT_FILENAME' => '/var/www/invent/basic/web/index.php' + 'REMOTE_PORT' => '57910' + 'GATEWAY_INTERFACE' => 'CGI/1.1' + 'SERVER_PROTOCOL' => 'HTTP/1.1' + 'REQUEST_METHOD' => 'GET' + 'QUERY_STRING' => '' + 'REQUEST_URI' => '/invent/index.php' + 'SCRIPT_NAME' => '/invent/index.php' + 'PHP_SELF' => '/invent/index.php' + 'REQUEST_TIME_FLOAT' => 1610428198.7791 + 'REQUEST_TIME' => 1610428198 +] diff --git a/views/items/index.php b/views/items/index.php index ece6444..12e33de 100644 --- a/views/items/index.php +++ b/views/items/index.php @@ -233,7 +233,7 @@ array_push($columns, [ var res = ''; for ( var i = 0; i < ids.length; i++) { - if (ids[ i ][ "checked" ] == true) + if (ids[ i ][ "checked" ] == 1) { res += "&id[]=" + ids[ i ][ "value" ]; } @@ -288,10 +288,14 @@ array_push($columns, [ 'filterModel' => $searchModel, // Модель поиска 'rowOptions' => function($model) // Функция окраски неинвентаризированных предметов/оборудования { - if ($model->checked == false) // Критерий проверки планируется + if ($model->checked == 0) // Критерий проверки планируется { return [ 'class' => 'danger' ]; // Отметка неинвентаризированной строки } else + if ($model->checked == 2) + { + return [ 'class' => 'warning' ]; // Отметка непроверенной строки + } else if ($model->statusName == 'Списано') { return [ 'class' => 'info' ]; diff --git a/widgets/ILinkPager.php b/widgets/ILinkPager.php new file mode 100644 index 0000000..c94d7c6 --- /dev/null +++ b/widgets/ILinkPager.php @@ -0,0 +1,18 @@ +firstPageLabel = Html::tag('span', '', [ 'class' => 'glyphicon glyphicon-fast-backward', 'title' => Yii::t('app', 'First page'), ]); + $this->prevPageLabel = Html::tag('span', '', [ 'class' => 'glyphicon glyphicon-backward', 'title' => Yii::t('app', 'Previous page'), ]); + $this->nextPageLabel = Html::tag('span', '', [ 'class' => 'glyphicon glyphicon-forward', 'title' => Yii::t('app', 'Next page'), ]); + $this->lastPageLabel = Html::tag('span', '', [ 'class' => 'glyphicon glyphicon-fast-forward', 'title' => Yii::t('app', 'Last page'), ]); + } +} +