| 17:01:35.115 | trace | yii\base\Application::bootstrap | Bootstrap with yii\log\Dispatcher |
| 17:01:35.116 | trace | yii\base\Module::getModule | Loading module: debug |
| 17:01:35.116 | trace | yii\base\Application::bootstrap | Bootstrap with yii\debug\Module::bootstrap() |
| 17:01:35.117 | trace | yii\redis\Connection::open | Opening redis DB connection: redis.server.local:6379, database=1 |
| 17:01:35.117 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: SELECT |
| 17:01:35.117 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 17:01:35.117 | info | time tracing start | 1784192495117974016 |
| 17:01:35.118 | trace | yii\web\UrlManager::parseRequest | No matching URL rules. Using default URL parsing logic. |
| 17:01:35.118 | trace | yii\web\Application::handleRequest | Route requested: 'vue/sales-contract/save-product' |
| 17:01:35.118 | trace | yii\base\Module::getModule | Loading module: vue |
| 17:01:35.119 | info | yii\web\Session::open | Session started |
| 17:01:35.121 | info | yii\db\Command::query | SELECT * FROM "global"."vw_user_login" WHERE "id"=5461 |
| 17:01:35.121 | info | yii\db\Connection::open | Opening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta |
| 17:01:35.122 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 17:01:35.123 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 17:01:35.124 | info | yii\db\Command::query | SELECT * FROM "global"."vw_user_login" WHERE "id"=1001 |
| 17:01:35.125 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 17:01:35.125 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 17:01:35.126 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001 |
| 17:01:35.127 | trace | yii\base\Controller::runAction | Route to run: vue/sales-contract/save-product |
| 17:01:35.127 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 17:01:35.131 | trace | uranus\rbac\DbManager::checkAccessFromCache | Checking role: Admin |
| 17:01:35.131 | trace | yii\base\InlineAction::runWithParams | Running action: app\modules\vue\controllers\SalesContractController::actionSaveProduct() |
| 17:01:35.131 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_sales_contracts" WHERE "id"='4476' |
| 17:01:35.132 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 17:01:35.133 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 17:01:35.133 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 17:01:35.135 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 17:01:35.137 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_projects" WHERE "id"=4167 |
| 17:01:35.137 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 17:01:35.138 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 17:01:35.138 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_project_product_types" WHERE "project_id"=4167 |
| 17:01:35.139 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 17:01:35.139 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 17:01:35.140 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 17:01:35.140 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 17:01:35.140 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_product_types" WHERE "id"=7 |
| 17:01:35.141 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_product_types" WHERE "id"=5 |
| 17:01:35.141 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_product_types" WHERE "id"=4 |
| 17:01:35.142 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_product_types" WHERE "id"=3 |
| 17:01:35.142 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_product_types" WHERE "id"=7 |
| 17:01:35.143 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_product_types" WHERE "id"=5 |
| 17:01:35.143 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_product_types" WHERE "id"=4 |
| 17:01:35.144 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 17:01:35.144 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 17:01:35.144 | info | yii\db\Command::execute | INSERT INTO "a57be577deb434"."tbl_object_change_logs" ("act", "attribute", "object_id", "object_type", "created_by", "created_at", "new_value", "old_value", "description") VALUES (2, 'projectProductTypes', 4167, 1, 1001, 'now()', '[["\u8f6f\u4ef6:48363\u5143 10%","\u5b89\u5168\u8bbe\u5907:305947.34\u5143 10%","\u7f51\u7edc\u8bbe\u5907 :800\u5143 10%","\u5b58\u50a8\u8bbe\u5907:83962.26\u5143 10%"]]', '[["\u8f6f\u4ef6:48363\u5143 10%","\u5b89\u5168\u8bbe\u5907:2323\u5143 10%","\u7f51\u7edc\u8bbe\u5907 :800\u5143 10%"]]', '{"d1":"\u5218\u4eba\u8bda","d2":"\u66f4\u65b0\u4e86","d3":"\u5546\u673a\u91d1\u989d","d4":["\u8f6f\u4ef6:48363\u5143 10%;\u5b89\u5168\u8bbe\u5907:2323\u5143 10%;\u7f51\u7edc\u8bbe\u5907 :800\u5143 10%; <b>\u53d8\u4e3a<\/b> \u8f6f\u4ef6:48363\u5143 10%;\u5b89\u5168\u8bbe\u5907:305947.34\u5143 10%;\u7f51\u7edc\u8bbe\u5907 :800\u5143 10%;\u5b58\u50a8\u8bbe\u5907:83962.26\u5143 10%;"]}') |
| 17:01:35.147 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"=982 |
| 17:01:35.148 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 17:01:35.149 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 17:01:35.149 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 17:01:35.149 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 17:01:35.149 | info | yii\db\Command::execute | INSERT INTO "a57be577deb434"."tbl_user_action_logs" ("act", "attribute", "object_id", "object_type", "created_by", "created_at", "new_value", "old_value", "users", "description") VALUES (2, 'projectProductTypes', 4167, 1, 1001, 'now()', '[["\u8f6f\u4ef6:48363\u5143 10%","\u5b89\u5168\u8bbe\u5907:305947.34\u5143 10%","\u7f51\u7edc\u8bbe\u5907 :800\u5143 10%","\u5b58\u50a8\u8bbe\u5907:83962.26\u5143 10%"]]', '[["\u8f6f\u4ef6:48363\u5143 10%","\u5b89\u5168\u8bbe\u5907:2323\u5143 10%","\u7f51\u7edc\u8bbe\u5907 :800\u5143 10%"]]', array[1001], '{"d1":"\u5218\u4eba\u8bda","d2":"\u66f4\u65b0\u4e86","d3":"\u5546\u673a\u91d1\u989d","d4":["\u8f6f\u4ef6:48363\u5143 10%;\u5b89\u5168\u8bbe\u5907:2323\u5143 10%;\u7f51\u7edc\u8bbe\u5907 :800\u5143 10%; <b>\u53d8\u4e3a<\/b> \u8f6f\u4ef6:48363\u5143 10%;\u5b89\u5168\u8bbe\u5907:305947.34\u5143 10%;\u7f51\u7edc\u8bbe\u5907 :800\u5143 10%;\u5b58\u50a8\u8bbe\u5907:83962.26\u5143 10%;"]}') |
| 17:01:35.151 | info | yii\db\Command::execute | INSERT INTO "a57be577deb434"."tbl_object_change_logs" ("act", "attribute", "object_id", "object_type", "created_by", "created_at", "new_value", "old_value", "description") VALUES (2, 'projectProductTypes', 4476, 7, 1001, 'now()', '[["\u8f6f\u4ef6:48363\u5143 10%","\u5b89\u5168\u8bbe\u5907:305947.34\u5143 10%","\u7f51\u7edc\u8bbe\u5907 :800\u5143 10%","\u5b58\u50a8\u8bbe\u5907:83962.26\u5143 10%"]]', '[["\u8f6f\u4ef6:48363\u5143 10%","\u5b89\u5168\u8bbe\u5907:2323\u5143 10%","\u7f51\u7edc\u8bbe\u5907 :800\u5143 10%"]]', '{"d1":"\u5218\u4eba\u8bda","d2":"\u66f4\u65b0\u4e86","d3":"\u5408\u540c\u91d1\u989d","d4":["\u8f6f\u4ef6:48363\u5143 10%;\u5b89\u5168\u8bbe\u5907:2323\u5143 10%;\u7f51\u7edc\u8bbe\u5907 :800\u5143 10%; <b>\u53d8\u4e3a<\/b> \u8f6f\u4ef6:48363\u5143 10%;\u5b89\u5168\u8bbe\u5907:305947.34\u5143 10%;\u7f51\u7edc\u8bbe\u5907 :800\u5143 10%;\u5b58\u50a8\u8bbe\u5907:83962.26\u5143 10%;"]}') |
| 17:01:35.152 | info | yii\db\Command::execute | DELETE FROM "a57be577deb434"."tbl_project_product_types" WHERE "project_id"=4167 |
| 17:01:35.153 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_product_types" WHERE "id"=7 |
| 17:01:35.154 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_product_types" WHERE "id"=5 |
| 17:01:35.154 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_product_types" WHERE "id"=4 |
| 17:01:35.155 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_product_types" WHERE "id"=3 |
| 17:01:35.155 | info | yii\db\Command::execute | INSERT INTO "a57be577deb434"."tbl_project_product_types" ("project_id", "product_type_id", "name", "budget", "pct", "profit") VALUES (4167, 7, '软件', '48363', 10, '4836.3'), (4167, 5, '安全设备', '305947.34', 10, '30594.73'), (4167, 4, '网络设备 ', '800', 10, '80'), (4167, 3, '存储设备', '83962.26', 10, '8396.22') |
| 17:01:35.157 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_project_product_rels" WHERE "project_id"=4167 ORDER BY "id" |
| 17:01:35.158 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 17:01:35.159 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 17:01:35.159 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 17:01:35.159 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 17:01:35.159 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_products" WHERE "id"=2177 |
| 17:01:35.160 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_product_units" WHERE "id"=2 |
| 17:01:35.161 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 17:01:35.161 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 17:01:35.161 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_products" WHERE "id"=1562 |
| 17:01:35.161 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_product_units" WHERE "id"=2 |
| 17:01:35.162 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_products" WHERE "id"=2261 |
| 17:01:35.163 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_product_units" WHERE "id"=3 |
| 17:01:35.163 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_products" WHERE "id"=2171 |
| 17:01:35.164 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_product_units" WHERE "id"=2 |
| 17:01:35.164 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_products" WHERE "id"=2177 |
| 17:01:35.164 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_product_units" WHERE "id"=2 |
| 17:01:35.165 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_products" WHERE "id"='2177' |
| 17:01:35.165 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_product_units" WHERE "id"=2 |
| 17:01:35.166 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_products" WHERE "id"='1562' |
| 17:01:35.166 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_product_units" WHERE "id"=2 |
| 17:01:35.167 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_products" WHERE "id"='2261' |
| 17:01:35.167 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_product_units" WHERE "id"=3 |
| 17:01:35.168 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_products" WHERE "id"='2171' |
| 17:01:35.168 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_product_units" WHERE "id"=2 |
| 17:01:35.168 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_products" WHERE "id"='2177' |
| 17:01:35.169 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_product_units" WHERE "id"=2 |
| 17:01:35.169 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_products" WHERE "id"='969' |
| 17:01:35.170 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_product_units" WHERE "id"=1 |
| 17:01:35.171 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_products" WHERE "id"='969' |
| 17:01:35.171 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_product_units" WHERE "id"=1 |
| 17:01:35.172 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_products" WHERE "id"='1558' |
| 17:01:35.172 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_product_units" WHERE "id"=1 |
| 17:01:35.173 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_products" WHERE "id"='2231' |
| 17:01:35.173 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_product_units" WHERE "id"=2 |
| 17:01:35.173 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_products" WHERE "id"='2269' |
| 17:01:35.174 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_product_units" WHERE "id"=4 |
| 17:01:35.174 | info | yii\db\Command::execute | INSERT INTO "a57be577deb434"."tbl_object_change_logs" ("act", "attribute", "object_id", "object_type", "created_by", "created_at", "new_value", "old_value", "description") VALUES (2, 'projectProducts', 4167, 1, 1001, 'now()', '[["\u6df1\u4fe1\u670dSDDC\u57fa\u7840\u8fd0\u7ef4\u8f6f\u4ef6V1.0:\u5408\u540c\u5355\u4ef7 4234.00\u5143 \u6570\u91cf 1\u5957\u5143 \u5907\u6ce8:- \u4f9b\u5e94\u5546 - \u786c\u4ef6\u8d28\u4fdd - \u8f6f\u4ef6\u8d28\u4fdd - \u8fd0\u7ef4\u670d\u52a1 -","PAN-PWR-450W-AC:\u5408\u540c\u5355\u4ef7 2323.00\u5143 \u6570\u91cf 1\u5957\u5143 \u5907\u6ce8:- \u4f9b\u5e94\u5546 - \u786c\u4ef6\u8d28\u4fdd - \u8f6f\u4ef6\u8d28\u4fdd - \u8fd0\u7ef4\u670d\u52a1 -","MK-MC300:\u5408\u540c\u5355\u4ef7 400.00\u5143 \u6570\u91cf 2\u4e2a\u5143 \u5907\u6ce8:- \u4f9b\u5e94\u5546 - \u786c\u4ef6\u8d28\u4fdd - \u8f6f\u4ef6\u8d28\u4fdd - \u8fd0\u7ef4\u670d\u52a1 -","\u91d1\u7545\u900dCRM\u8f6f\u4ef6\u670d\u52a1:\u5408\u540c\u5355\u4ef7 5345.00\u5143 \u6570\u91cf 1\u5957\u5143 \u5907\u6ce8:- \u4f9b\u5e94\u5546 - \u786c\u4ef6\u8d28\u4fdd - \u8f6f\u4ef6\u8d28\u4fdd - \u8fd0\u7ef4\u670d\u52a1 -","\u6df1\u4fe1\u670dSDDC\u57fa\u7840\u8fd0\u7ef4\u8f6f\u4ef6V1.0:\u5408\u540c\u5355\u4ef7 3232.00\u5143 \u6570\u91cf 12\u5957\u5143 \u5907\u6ce8:- \u4f9b\u5e94\u5546 - \u786c\u4ef6\u8d28\u4fdd - \u8f6f\u4ef6\u8d28\u4fdd - \u8fd0\u7ef4\u670d\u52a1 -","PAN-PA-1410:\u5408\u540c\u5355\u4ef7 9247.78\u5143 \u6570\u91cf 10\u53f0\u5143 \u5907\u6ce8:- \u4f9b\u5e94\u5546 - \u786c\u4ef6\u8d28\u4fdd - \u8f6f\u4ef6\u8d28\u4fdd - \u8fd0\u7ef4\u670d\u52a1 -","PAN-PA-1410:\u5408\u540c\u5355\u4ef7 2654.87\u5143 \u6570\u91cf 10\u53f0\u5143 \u5907\u6ce8:- \u4f9b\u5e94\u5546 - \u786c\u4ef6\u8d28\u4fdd - \u8f6f\u4ef6\u8d28\u4fdd - \u8fd0\u7ef4\u670d\u52a1 -","PAN-PA-1420:\u5408\u540c\u5355\u4ef7 13792.04\u5143 \u6570\u91cf 10\u53f0\u5143 \u5907\u6ce8:- \u4f9b\u5e94\u5546 - \u786c\u4ef6\u8d28\u4fdd - \u8f6f\u4ef6\u8d28\u4fdd - \u8fd0\u7ef4\u670d\u52a1 -","PAN-PA-3440-ATP-3YR:\u5408\u540c\u5355\u4ef7 13274.34\u5143 \u6570\u91cf 1\u5957\u5143 \u5907\u6ce8:- \u4f9b\u5e94\u5546 - \u786c\u4ef6\u8d28\u4fdd - \u8f6f\u4ef6\u8d28\u4fdd - \u8fd0\u7ef4\u670d\u52a1 -","HAT5320-24T:\u5408\u540c\u5355\u4ef7 83962.26\u5143 \u6570\u91cf 1\u5757\u5143 \u5907\u6ce8:- \u4f9b\u5e94\u5546 - \u786c\u4ef6\u8d28\u4fdd - \u8f6f\u4ef6\u8d28\u4fdd - \u8fd0\u7ef4\u670d\u52a1 -"]]', '[["\u6df1\u4fe1\u670dSDDC\u57fa\u7840\u8fd0\u7ef4\u8f6f\u4ef6V1.0:\u5408\u540c\u5355\u4ef7 4234\u5143 \u6570\u91cf 1\u5957\u5143 \u5907\u6ce8:- \u4f9b\u5e94\u5546 - \u786c\u4ef6\u8d28\u4fdd - \u8f6f\u4ef6\u8d28\u4fdd - \u8fd0\u7ef4\u670d\u52a1 -","PAN-PWR-450W-AC:\u5408\u540c\u5355\u4ef7 2323\u5143 \u6570\u91cf 1\u5957\u5143 \u5907\u6ce8:- \u4f9b\u5e94\u5546 - \u786c\u4ef6\u8d28\u4fdd - \u8f6f\u4ef6\u8d28\u4fdd - \u8fd0\u7ef4\u670d\u52a1 -","MK-MC300:\u5408\u540c\u5355\u4ef7 400\u5143 \u6570\u91cf 2\u4e2a\u5143 \u5907\u6ce8:- \u4f9b\u5e94\u5546 - \u786c\u4ef6\u8d28\u4fdd - \u8f6f\u4ef6\u8d28\u4fdd - \u8fd0\u7ef4\u670d\u52a1 -","\u91d1\u7545\u900dCRM\u8f6f\u4ef6\u670d\u52a1:\u5408\u540c\u5355\u4ef7 5345\u5143 \u6570\u91cf 1\u5957\u5143 \u5907\u6ce8:- \u4f9b\u5e94\u5546 - \u786c\u4ef6\u8d28\u4fdd - \u8f6f\u4ef6\u8d28\u4fdd - \u8fd0\u7ef4\u670d\u52a1 -","\u6df1\u4fe1\u670dSDDC\u57fa\u7840\u8fd0\u7ef4\u8f6f\u4ef6V1.0:\u5408\u540c\u5355\u4ef7 3232\u5143 \u6570\u91cf 12\u5957\u5143 \u5907\u6ce8:- \u4f9b\u5e94\u5546 - \u786c\u4ef6\u8d28\u4fdd - \u8f6f\u4ef6\u8d28\u4fdd - \u8fd0\u7ef4\u670d\u52a1 -"]]', '{"d1":"\u5218\u4eba\u8bda","d2":"\u66f4\u65b0\u4e86","d3":"\u4ea7\u54c1\u6e05\u5355","d4":["\u6df1\u4fe1\u670dSDDC\u57fa\u7840\u8fd0\u7ef4\u8f6f\u4ef6V1.0:\u5408\u540c\u5355\u4ef7 4234\u5143 \u6570\u91cf 1\u5957\u5143 \u5907\u6ce8:- \u4f9b\u5e94\u5546 - \u786c\u4ef6\u8d28\u4fdd - \u8f6f\u4ef6\u8d28\u4fdd - \u8fd0\u7ef4\u670d\u52a1 -;PAN-PWR-450W-AC:\u5408\u540c\u5355\u4ef7 2323\u5143 \u6570\u91cf 1\u5957\u5143 \u5907\u6ce8:- \u4f9b\u5e94\u5546 - \u786c\u4ef6\u8d28\u4fdd - \u8f6f\u4ef6\u8d28\u4fdd - \u8fd0\u7ef4\u670d\u52a1 -;MK-MC300:\u5408\u540c\u5355\u4ef7 400\u5143 \u6570\u91cf 2\u4e2a\u5143 \u5907\u6ce8:- \u4f9b\u5e94\u5546 - \u786c\u4ef6\u8d28\u4fdd - \u8f6f\u4ef6\u8d28\u4fdd - \u8fd0\u7ef4\u670d\u52a1 -;\u91d1\u7545\u900dCRM\u8f6f\u4ef6\u670d\u52a1:\u5408\u540c\u5355\u4ef7 5345\u5143 \u6570\u91cf 1\u5957\u5143 \u5907\u6ce8:- \u4f9b\u5e94\u5546 - \u786c\u4ef6\u8d28\u4fdd - \u8f6f\u4ef6\u8d28\u4fdd - \u8fd0\u7ef4\u670d\u52a1 -;\u6df1\u4fe1\u670dSDDC\u57fa\u7840\u8fd0\u7ef4\u8f6f\u4ef6V1.0:\u5408\u540c\u5355\u4ef7 3232\u5143 \u6570\u91cf 12\u5957\u5143 \u5907\u6ce8:- \u4f9b\u5e94\u5546 - \u786c\u4ef6\u8d28\u4fdd - \u8f6f\u4ef6\u8d28\u4fdd - \u8fd0\u7ef4\u670d\u52a1 -; <b>\u53d8\u4e3a<\/b> \u6df1\u4fe1\u670dSDDC\u57fa\u7840\u8fd0\u7ef4\u8f6f\u4ef6V1.0:\u5408\u540c\u5355\u4ef7 4234.00\u5143 \u6570\u91cf 1\u5957\u5143 \u5907\u6ce8:- \u4f9b\u5e94\u5546 - \u786c\u4ef6\u8d28\u4fdd - \u8f6f\u4ef6\u8d28\u4fdd - \u8fd0\u7ef4\u670d\u52a1 -;PAN-PWR-450W-AC:\u5408\u540c\u5355\u4ef7 2323.00\u5143 \u6570\u91cf 1\u5957\u5143 \u5907\u6ce8:- \u4f9b\u5e94\u5546 - \u786c\u4ef6\u8d28\u4fdd - \u8f6f\u4ef6\u8d28\u4fdd - \u8fd0\u7ef4\u670d\u52a1 -;MK-MC300:\u5408\u540c\u5355\u4ef7 400.00\u5143 \u6570\u91cf 2\u4e2a\u5143 \u5907\u6ce8:- \u4f9b\u5e94\u5546 - \u786c\u4ef6\u8d28\u4fdd - \u8f6f\u4ef6\u8d28\u4fdd - \u8fd0\u7ef4\u670d\u52a1 -;\u91d1\u7545\u900dCRM\u8f6f\u4ef6\u670d\u52a1:\u5408\u540c\u5355\u4ef7 5345.00\u5143 \u6570\u91cf 1\u5957\u5143 \u5907\u6ce8:- \u4f9b\u5e94\u5546 - \u786c\u4ef6\u8d28\u4fdd - \u8f6f\u4ef6\u8d28\u4fdd - \u8fd0\u7ef4\u670d\u52a1 -;\u6df1\u4fe1\u670dSDDC\u57fa\u7840\u8fd0\u7ef4\u8f6f\u4ef6V1.0:\u5408\u540c\u5355\u4ef7 3232.00\u5143 \u6570\u91cf 12\u5957\u5143 \u5907\u6ce8:- \u4f9b\u5e94\u5546 - \u786c\u4ef6\u8d28\u4fdd - \u8f6f\u4ef6\u8d28\u4fdd - \u8fd0\u7ef4\u670d\u52a1 -;PAN-PA-1410:\u5408\u540c\u5355\u4ef7 9247.78\u5143 \u6570\u91cf 10\u53f0\u5143 \u5907\u6ce8:- \u4f9b\u5e94\u5546 - \u786c\u4ef6\u8d28\u4fdd - \u8f6f\u4ef6\u8d28\u4fdd - \u8fd0\u7ef4\u670d\u52a1 -;PAN-PA-1410:\u5408\u540c\u5355\u4ef7 2654.87\u5143 \u6570\u91cf 10\u53f0\u5143 \u5907\u6ce8:- \u4f9b\u5e94\u5546 - \u786c\u4ef6\u8d28\u4fdd - \u8f6f\u4ef6\u8d28\u4fdd - \u8fd0\u7ef4\u670d\u52a1 -;PAN-PA-1420:\u5408\u540c\u5355\u4ef7 13792.04\u5143 \u6570\u91cf 10\u53f0\u5143 \u5907\u6ce8:- \u4f9b\u5e94\u5546 - \u786c\u4ef6\u8d28\u4fdd - \u8f6f\u4ef6\u8d28\u4fdd - \u8fd0\u7ef4\u670d\u52a1 -;PAN-PA-3440-ATP-3YR:\u5408\u540c\u5355\u4ef7 13274.34\u5143 \u6570\u91cf 1\u5957\u5143 \u5907\u6ce8:- \u4f9b\u5e94\u5546 - \u786c\u4ef6\u8d28\u4fdd - \u8f6f\u4ef6\u8d28\u4fdd - \u8fd0\u7ef4\u670d\u52a1 -;HAT5320-24T:\u5408\u540c\u5355\u4ef7 83962.26\u5143 \u6570\u91cf 1\u5757\u5143 \u5907\u6ce8:- \u4f9b\u5e94\u5546 - \u786c\u4ef6\u8d28\u4fdd - \u8f6f\u4ef6\u8d28\u4fdd - \u8fd0\u7ef4\u670d\u52a1 -;"]}') |
| 17:01:35.176 | info | yii\db\Command::execute | INSERT INTO "a57be577deb434"."tbl_user_action_logs" ("act", "attribute", "object_id", "object_type", "created_by", "created_at", "new_value", "old_value", "users", "description") VALUES (2, 'projectProducts', 4167, 1, 1001, 'now()', '[["\u6df1\u4fe1\u670dSDDC\u57fa\u7840\u8fd0\u7ef4\u8f6f\u4ef6V1.0:\u5408\u540c\u5355\u4ef7 4234.00\u5143 \u6570\u91cf 1\u5957\u5143 \u5907\u6ce8:- \u4f9b\u5e94\u5546 - \u786c\u4ef6\u8d28\u4fdd - \u8f6f\u4ef6\u8d28\u4fdd - \u8fd0\u7ef4\u670d\u52a1 -","PAN-PWR-450W-AC:\u5408\u540c\u5355\u4ef7 2323.00\u5143 \u6570\u91cf 1\u5957\u5143 \u5907\u6ce8:- \u4f9b\u5e94\u5546 - \u786c\u4ef6\u8d28\u4fdd - \u8f6f\u4ef6\u8d28\u4fdd - \u8fd0\u7ef4\u670d\u52a1 -","MK-MC300:\u5408\u540c\u5355\u4ef7 400.00\u5143 \u6570\u91cf 2\u4e2a\u5143 \u5907\u6ce8:- \u4f9b\u5e94\u5546 - \u786c\u4ef6\u8d28\u4fdd - \u8f6f\u4ef6\u8d28\u4fdd - \u8fd0\u7ef4\u670d\u52a1 -","\u91d1\u7545\u900dCRM\u8f6f\u4ef6\u670d\u52a1:\u5408\u540c\u5355\u4ef7 5345.00\u5143 \u6570\u91cf 1\u5957\u5143 \u5907\u6ce8:- \u4f9b\u5e94\u5546 - \u786c\u4ef6\u8d28\u4fdd - \u8f6f\u4ef6\u8d28\u4fdd - \u8fd0\u7ef4\u670d\u52a1 -","\u6df1\u4fe1\u670dSDDC\u57fa\u7840\u8fd0\u7ef4\u8f6f\u4ef6V1.0:\u5408\u540c\u5355\u4ef7 3232.00\u5143 \u6570\u91cf 12\u5957\u5143 \u5907\u6ce8:- \u4f9b\u5e94\u5546 - \u786c\u4ef6\u8d28\u4fdd - \u8f6f\u4ef6\u8d28\u4fdd - \u8fd0\u7ef4\u670d\u52a1 -","PAN-PA-1410:\u5408\u540c\u5355\u4ef7 9247.78\u5143 \u6570\u91cf 10\u53f0\u5143 \u5907\u6ce8:- \u4f9b\u5e94\u5546 - \u786c\u4ef6\u8d28\u4fdd - \u8f6f\u4ef6\u8d28\u4fdd - \u8fd0\u7ef4\u670d\u52a1 -","PAN-PA-1410:\u5408\u540c\u5355\u4ef7 2654.87\u5143 \u6570\u91cf 10\u53f0\u5143 \u5907\u6ce8:- \u4f9b\u5e94\u5546 - \u786c\u4ef6\u8d28\u4fdd - \u8f6f\u4ef6\u8d28\u4fdd - \u8fd0\u7ef4\u670d\u52a1 -","PAN-PA-1420:\u5408\u540c\u5355\u4ef7 13792.04\u5143 \u6570\u91cf 10\u53f0\u5143 \u5907\u6ce8:- \u4f9b\u5e94\u5546 - \u786c\u4ef6\u8d28\u4fdd - \u8f6f\u4ef6\u8d28\u4fdd - \u8fd0\u7ef4\u670d\u52a1 -","PAN-PA-3440-ATP-3YR:\u5408\u540c\u5355\u4ef7 13274.34\u5143 \u6570\u91cf 1\u5957\u5143 \u5907\u6ce8:- \u4f9b\u5e94\u5546 - \u786c\u4ef6\u8d28\u4fdd - \u8f6f\u4ef6\u8d28\u4fdd - \u8fd0\u7ef4\u670d\u52a1 -","HAT5320-24T:\u5408\u540c\u5355\u4ef7 83962.26\u5143 \u6570\u91cf 1\u5757\u5143 \u5907\u6ce8:- \u4f9b\u5e94\u5546 - \u786c\u4ef6\u8d28\u4fdd - \u8f6f\u4ef6\u8d28\u4fdd - \u8fd0\u7ef4\u670d\u52a1 -"]]', '[["\u6df1\u4fe1\u670dSDDC\u57fa\u7840\u8fd0\u7ef4\u8f6f\u4ef6V1.0:\u5408\u540c\u5355\u4ef7 4234\u5143 \u6570\u91cf 1\u5957\u5143 \u5907\u6ce8:- \u4f9b\u5e94\u5546 - \u786c\u4ef6\u8d28\u4fdd - \u8f6f\u4ef6\u8d28\u4fdd - \u8fd0\u7ef4\u670d\u52a1 -","PAN-PWR-450W-AC:\u5408\u540c\u5355\u4ef7 2323\u5143 \u6570\u91cf 1\u5957\u5143 \u5907\u6ce8:- \u4f9b\u5e94\u5546 - \u786c\u4ef6\u8d28\u4fdd - \u8f6f\u4ef6\u8d28\u4fdd - \u8fd0\u7ef4\u670d\u52a1 -","MK-MC300:\u5408\u540c\u5355\u4ef7 400\u5143 \u6570\u91cf 2\u4e2a\u5143 \u5907\u6ce8:- \u4f9b\u5e94\u5546 - \u786c\u4ef6\u8d28\u4fdd - \u8f6f\u4ef6\u8d28\u4fdd - \u8fd0\u7ef4\u670d\u52a1 -","\u91d1\u7545\u900dCRM\u8f6f\u4ef6\u670d\u52a1:\u5408\u540c\u5355\u4ef7 5345\u5143 \u6570\u91cf 1\u5957\u5143 \u5907\u6ce8:- \u4f9b\u5e94\u5546 - \u786c\u4ef6\u8d28\u4fdd - \u8f6f\u4ef6\u8d28\u4fdd - \u8fd0\u7ef4\u670d\u52a1 -","\u6df1\u4fe1\u670dSDDC\u57fa\u7840\u8fd0\u7ef4\u8f6f\u4ef6V1.0:\u5408\u540c\u5355\u4ef7 3232\u5143 \u6570\u91cf 12\u5957\u5143 \u5907\u6ce8:- \u4f9b\u5e94\u5546 - \u786c\u4ef6\u8d28\u4fdd - \u8f6f\u4ef6\u8d28\u4fdd - \u8fd0\u7ef4\u670d\u52a1 -"]]', array[1001], '{"d1":"\u5218\u4eba\u8bda","d2":"\u66f4\u65b0\u4e86","d3":"\u4ea7\u54c1\u6e05\u5355","d4":["\u6df1\u4fe1\u670dSDDC\u57fa\u7840\u8fd0\u7ef4\u8f6f\u4ef6V1.0:\u5408\u540c\u5355\u4ef7 4234\u5143 \u6570\u91cf 1\u5957\u5143 \u5907\u6ce8:- \u4f9b\u5e94\u5546 - \u786c\u4ef6\u8d28\u4fdd - \u8f6f\u4ef6\u8d28\u4fdd - \u8fd0\u7ef4\u670d\u52a1 -;PAN-PWR-450W-AC:\u5408\u540c\u5355\u4ef7 2323\u5143 \u6570\u91cf 1\u5957\u5143 \u5907\u6ce8:- \u4f9b\u5e94\u5546 - \u786c\u4ef6\u8d28\u4fdd - \u8f6f\u4ef6\u8d28\u4fdd - \u8fd0\u7ef4\u670d\u52a1 -;MK-MC300:\u5408\u540c\u5355\u4ef7 400\u5143 \u6570\u91cf 2\u4e2a\u5143 \u5907\u6ce8:- \u4f9b\u5e94\u5546 - \u786c\u4ef6\u8d28\u4fdd - \u8f6f\u4ef6\u8d28\u4fdd - \u8fd0\u7ef4\u670d\u52a1 -;\u91d1\u7545\u900dCRM\u8f6f\u4ef6\u670d\u52a1:\u5408\u540c\u5355\u4ef7 5345\u5143 \u6570\u91cf 1\u5957\u5143 \u5907\u6ce8:- \u4f9b\u5e94\u5546 - \u786c\u4ef6\u8d28\u4fdd - \u8f6f\u4ef6\u8d28\u4fdd - \u8fd0\u7ef4\u670d\u52a1 -;\u6df1\u4fe1\u670dSDDC\u57fa\u7840\u8fd0\u7ef4\u8f6f\u4ef6V1.0:\u5408\u540c\u5355\u4ef7 3232\u5143 \u6570\u91cf 12\u5957\u5143 \u5907\u6ce8:- \u4f9b\u5e94\u5546 - \u786c\u4ef6\u8d28\u4fdd - \u8f6f\u4ef6\u8d28\u4fdd - \u8fd0\u7ef4\u670d\u52a1 -; <b>\u53d8\u4e3a<\/b> \u6df1\u4fe1\u670dSDDC\u57fa\u7840\u8fd0\u7ef4\u8f6f\u4ef6V1.0:\u5408\u540c\u5355\u4ef7 4234.00\u5143 \u6570\u91cf 1\u5957\u5143 \u5907\u6ce8:- \u4f9b\u5e94\u5546 - \u786c\u4ef6\u8d28\u4fdd - \u8f6f\u4ef6\u8d28\u4fdd - \u8fd0\u7ef4\u670d\u52a1 -;PAN-PWR-450W-AC:\u5408\u540c\u5355\u4ef7 2323.00\u5143 \u6570\u91cf 1\u5957\u5143 \u5907\u6ce8:- \u4f9b\u5e94\u5546 - \u786c\u4ef6\u8d28\u4fdd - \u8f6f\u4ef6\u8d28\u4fdd - \u8fd0\u7ef4\u670d\u52a1 -;MK-MC300:\u5408\u540c\u5355\u4ef7 400.00\u5143 \u6570\u91cf 2\u4e2a\u5143 \u5907\u6ce8:- \u4f9b\u5e94\u5546 - \u786c\u4ef6\u8d28\u4fdd - \u8f6f\u4ef6\u8d28\u4fdd - \u8fd0\u7ef4\u670d\u52a1 -;\u91d1\u7545\u900dCRM\u8f6f\u4ef6\u670d\u52a1:\u5408\u540c\u5355\u4ef7 5345.00\u5143 \u6570\u91cf 1\u5957\u5143 \u5907\u6ce8:- \u4f9b\u5e94\u5546 - \u786c\u4ef6\u8d28\u4fdd - \u8f6f\u4ef6\u8d28\u4fdd - \u8fd0\u7ef4\u670d\u52a1 -;\u6df1\u4fe1\u670dSDDC\u57fa\u7840\u8fd0\u7ef4\u8f6f\u4ef6V1.0:\u5408\u540c\u5355\u4ef7 3232.00\u5143 \u6570\u91cf 12\u5957\u5143 \u5907\u6ce8:- \u4f9b\u5e94\u5546 - \u786c\u4ef6\u8d28\u4fdd - \u8f6f\u4ef6\u8d28\u4fdd - \u8fd0\u7ef4\u670d\u52a1 -;PAN-PA-1410:\u5408\u540c\u5355\u4ef7 9247.78\u5143 \u6570\u91cf 10\u53f0\u5143 \u5907\u6ce8:- \u4f9b\u5e94\u5546 - \u786c\u4ef6\u8d28\u4fdd - \u8f6f\u4ef6\u8d28\u4fdd - \u8fd0\u7ef4\u670d\u52a1 -;PAN-PA-1410:\u5408\u540c\u5355\u4ef7 2654.87\u5143 \u6570\u91cf 10\u53f0\u5143 \u5907\u6ce8:- \u4f9b\u5e94\u5546 - \u786c\u4ef6\u8d28\u4fdd - \u8f6f\u4ef6\u8d28\u4fdd - \u8fd0\u7ef4\u670d\u52a1 -;PAN-PA-1420:\u5408\u540c\u5355\u4ef7 13792.04\u5143 \u6570\u91cf 10\u53f0\u5143 \u5907\u6ce8:- \u4f9b\u5e94\u5546 - \u786c\u4ef6\u8d28\u4fdd - \u8f6f\u4ef6\u8d28\u4fdd - \u8fd0\u7ef4\u670d\u52a1 -;PAN-PA-3440-ATP-3YR:\u5408\u540c\u5355\u4ef7 13274.34\u5143 \u6570\u91cf 1\u5957\u5143 \u5907\u6ce8:- \u4f9b\u5e94\u5546 - \u786c\u4ef6\u8d28\u4fdd - \u8f6f\u4ef6\u8d28\u4fdd - \u8fd0\u7ef4\u670d\u52a1 -;HAT5320-24T:\u5408\u540c\u5355\u4ef7 83962.26\u5143 \u6570\u91cf 1\u5757\u5143 \u5907\u6ce8:- \u4f9b\u5e94\u5546 - \u786c\u4ef6\u8d28\u4fdd - \u8f6f\u4ef6\u8d28\u4fdd - \u8fd0\u7ef4\u670d\u52a1 -;"]}') |
| 17:01:35.178 | info | yii\db\Command::query | SELECT "id" FROM "a57be577deb434"."tbl_project_product_rels" WHERE "project_id"=4167 |
| 17:01:35.178 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_project_product_rels" WHERE "id"=12120 |
| 17:01:35.179 | info | yii\db\Command::execute | UPDATE "a57be577deb434"."tbl_project_product_rels" SET "product_id"=2177, "amount"='4234', "number"=1, "supplier_id"=NULL, "hardware_from"=NULL, "software_from"=NULL, "maintenance_from"=NULL, "hardware_to"=NULL, "software_to"=NULL, "maintenance_to"=NULL, "total_amount"='4234.00' WHERE "id"=12120 |
| 17:01:35.181 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 17:01:35.181 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 17:01:35.181 | info | yii\db\Command::execute | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\ProjectProductRels', 12120, 'a:1:{s:12:"total_amount";s:7:"4234.00";}', '', 1001, '114.244.130.25') |
| 17:01:35.183 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_project_product_rels" WHERE "id"=12121 |
| 17:01:35.183 | info | yii\db\Command::execute | UPDATE "a57be577deb434"."tbl_project_product_rels" SET "product_id"=1562, "amount"='2323', "number"=1, "supplier_id"=NULL, "hardware_from"=NULL, "software_from"=NULL, "maintenance_from"=NULL, "hardware_to"=NULL, "software_to"=NULL, "maintenance_to"=NULL, "total_amount"='2323.00' WHERE "id"=12121 |
| 17:01:35.184 | info | yii\db\Command::execute | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\ProjectProductRels', 12121, 'a:1:{s:12:"total_amount";s:7:"2323.00";}', '', 1001, '114.244.130.25') |
| 17:01:35.185 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_project_product_rels" WHERE "id"=12122 |
| 17:01:35.186 | info | yii\db\Command::execute | UPDATE "a57be577deb434"."tbl_project_product_rels" SET "product_id"=2261, "amount"='400', "number"=2, "supplier_id"=NULL, "hardware_from"=NULL, "software_from"=NULL, "maintenance_from"=NULL, "hardware_to"=NULL, "software_to"=NULL, "maintenance_to"=NULL, "total_amount"='800.00' WHERE "id"=12122 |
| 17:01:35.187 | info | yii\db\Command::execute | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\ProjectProductRels', 12122, 'a:1:{s:12:"total_amount";s:6:"800.00";}', '', 1001, '114.244.130.25') |
| 17:01:35.189 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_project_product_rels" WHERE "id"=12123 |
| 17:01:35.189 | info | yii\db\Command::execute | UPDATE "a57be577deb434"."tbl_project_product_rels" SET "product_id"=2171, "amount"='5345', "number"=1, "supplier_id"=NULL, "hardware_from"=NULL, "software_from"=NULL, "maintenance_from"=NULL, "hardware_to"=NULL, "software_to"=NULL, "maintenance_to"=NULL, "total_amount"='5345.00' WHERE "id"=12123 |
| 17:01:35.190 | info | yii\db\Command::execute | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\ProjectProductRels', 12123, 'a:1:{s:12:"total_amount";s:7:"5345.00";}', '', 1001, '114.244.130.25') |
| 17:01:35.192 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_project_product_rels" WHERE "id"=12124 |
| 17:01:35.192 | info | yii\db\Command::execute | UPDATE "a57be577deb434"."tbl_project_product_rels" SET "product_id"=2177, "amount"='3232', "number"=12, "supplier_id"=NULL, "hardware_from"=NULL, "software_from"=NULL, "maintenance_from"=NULL, "hardware_to"=NULL, "software_to"=NULL, "maintenance_to"=NULL, "total_amount"='38784.00' WHERE "id"=12124 |
| 17:01:35.193 | info | yii\db\Command::execute | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\ProjectProductRels', 12124, 'a:1:{s:12:"total_amount";s:8:"38784.00";}', '', 1001, '114.244.130.25') |
| 17:01:35.195 | info | yii\db\Command::execute | INSERT INTO "a57be577deb434"."tbl_project_product_rels" ("project_id", "product_id", "amount", "number", "total_amount", "description", "supplier_id", "hardware_from", "software_from", "maintenance_from", "hardware_to", "software_to", "maintenance_to") VALUES (4167, 969, '9247.78', 10, '104500.00', '-', NULL, NULL, NULL, NULL, NULL, NULL, NULL), (4167, 969, '2654.87', 10, '30000.00', '-', NULL, NULL, NULL, NULL, NULL, NULL, NULL), (4167, 1558, '13792.04', 10, '155850.00', '-', NULL, NULL, NULL, NULL, NULL, NULL, NULL), (4167, 2231, '13274.34', 1, '13274.34', '-', NULL, NULL, NULL, NULL, NULL, NULL, NULL), (4167, 2269, '83962.26', 1, '83962.26', '-', NULL, NULL, NULL, NULL, NULL, NULL, NULL) |
| 17:01:35.198 | info | yii\db\Command::execute | DELETE FROM "a57be577deb434"."tbl_project_product_rels" WHERE 0=1 |
| 17:01:35.200 | info | yii\db\Command::execute | UPDATE "a57be577deb434"."tbl_projects" SET "budget"='439072.6', "profit_pct"='10', "updated_at"='now()', "project_product_version_id"=1368 WHERE "id"=4167 |
| 17:01:35.202 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_project_change_logs" WHERE ("project_id"=4167) AND ("end_at" IS NULL) ORDER BY "id" DESC LIMIT 1 |
| 17:01:35.205 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 17:01:35.205 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 17:01:35.206 | info | yii\db\Command::execute | UPDATE "a57be577deb434"."tbl_project_change_logs" SET "end_at"='now()' WHERE "id"=17821 |
| 17:01:35.207 | info | yii\db\Command::execute | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\ProjectChangeLogs', 17821, 'a:1:{s:6:"end_at";s:19:"1970-01-01 08:00:00";}', '', 1001, '114.244.130.25') |
| 17:01:35.208 | info | yii\db\Command::query | INSERT INTO "a57be577deb434"."tbl_project_change_logs" ("project_id", "project_status", "budget", "profit_pct", "collected", "start_from", "end_at") VALUES (4167, 3, '439072.6', '10', '100', 'now()', NULL) RETURNING "id" |
| 17:01:35.210 | info | yii\db\Command::execute | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('INSERT', 'app\models\ProjectChangeLogs', 17900, 'a:8:{s:2:"id";i:17900;s:10:"project_id";i:4167;s:14:"project_status";i:3;s:6:"budget";d:439072.59999999998;s:10:"profit_pct";d:10;s:9:"collected";s:3:"100";s:10:"start_from";s:5:"now()";s:6:"end_at";N;}', '', 1001, '114.244.130.25') |
| 17:01:35.211 | info | yii\db\Command::execute | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\Projects', 4167, 'a:1:{s:6:"budget";d:439072.59999999998;}', '', 1001, '114.244.130.25') |
| 17:01:35.212 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"=982 |
| 17:01:35.213 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_projects" WHERE "id"=4167 |
| 17:01:35.214 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_project_product_rels" WHERE "project_id"=4167 ORDER BY "id" |
| 17:01:35.215 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 17:01:35.215 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 17:01:35.215 | info | yii\db\Command::query | INSERT INTO "a57be577deb434"."tbl_project_product_versions" ("project_id", "created_by", "created_at") VALUES (4167, 1001, '2026-07-16 17:01:35') RETURNING "id" |
| 17:01:35.218 | info | yii\db\Command::execute | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('INSERT', 'app\models\ProjectProductVersions', 1393, 'a:4:{s:2:"id";i:1393;s:10:"project_id";i:4167;s:10:"created_by";i:1001;s:10:"created_at";s:19:"2026-07-16 17:01:35";}', '', 1001, '114.244.130.25') |
| 17:01:35.219 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001 |
| 17:01:35.220 | info | yii\db\Command::query | INSERT INTO "a57be577deb434"."tbl_object_change_logs" ("act", "attribute", "object_id", "object_type", "target_id", "target_object_type", "created_by", "new_value", "old_value", "description") VALUES (1, 'create', 4167, 1, 1393, 112, 1001, '[1393]', '[1393]', '{"d1":"\u5218\u4eba\u8bda","d2":"\u521b\u5efa\u4e86","d3":"\u4ea7\u54c1\u5386\u53f2\u62a5\u4ef7\u6e05\u5355","d4":["2026-07-16 17:01\u4ea7\u54c1\u5386\u53f2\u62a5\u4ef7\u6e05\u5355"]}') RETURNING "id" |
| 17:01:35.221 | info | yii\db\Command::execute | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('INSERT', 'app\models\ObjectChangeLogs', 643562, 'a:13:{s:2:"id";i:643562;s:9:"object_id";i:4167;s:11:"object_type";i:1;s:9:"target_id";i:1393;s:18:"target_object_type";i:112;s:3:"act";i:1;s:9:"attribute";s:6:"create";s:9:"old_value";s:6:"[1393]";s:9:"new_value";s:6:"[1393]";s:11:"description";s:183:"{"d1":"\u5218\u4eba\u8bda","d2":"\u521b\u5efa\u4e86","d3":"\u4ea7\u54c1\u5386\u53f2\u62a5\u4ef7\u6e05\u5355","d4":["2026-07-16 17:01\u4ea7\u54c1\u5386\u53f2\u62a5\u4ef7\u6e05\u5355"]}";s:10:"created_by";i:1001;s:10:"created_at";N;s:9:"is_delete";N;}', '', 1001, '114.244.130.25') |
| 17:01:35.222 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_sales_contracts" WHERE "from_project"=4167 |
| 17:01:35.223 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001 |
| 17:01:35.224 | info | yii\db\Command::query | INSERT INTO "a57be577deb434"."tbl_object_change_logs" ("act", "attribute", "object_id", "object_type", "target_id", "target_object_type", "created_by", "new_value", "old_value", "description") VALUES (1, 'create', 4476, 7, 4167, 112, 1001, '[4167]', '[4167]', '{"d1":"\u5218\u4eba\u8bda","d2":"\u521b\u5efa\u4e86","d3":"\u4ea7\u54c1\u5386\u53f2\u62a5\u4ef7\u6e05\u5355","d4":["2026-07-16 17:01\u4ea7\u54c1\u5386\u53f2\u62a5\u4ef7\u6e05\u5355"]}') RETURNING "id" |
| 17:01:35.225 | info | yii\db\Command::execute | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('INSERT', 'app\models\ObjectChangeLogs', 643563, 'a:13:{s:2:"id";i:643563;s:9:"object_id";i:4476;s:11:"object_type";i:7;s:9:"target_id";i:4167;s:18:"target_object_type";i:112;s:3:"act";i:1;s:9:"attribute";s:6:"create";s:9:"old_value";s:6:"[4167]";s:9:"new_value";s:6:"[4167]";s:11:"description";s:183:"{"d1":"\u5218\u4eba\u8bda","d2":"\u521b\u5efa\u4e86","d3":"\u4ea7\u54c1\u5386\u53f2\u62a5\u4ef7\u6e05\u5355","d4":["2026-07-16 17:01\u4ea7\u54c1\u5386\u53f2\u62a5\u4ef7\u6e05\u5355"]}";s:10:"created_by";i:1001;s:10:"created_at";N;s:9:"is_delete";N;}', '', 1001, '114.244.130.25') |
| 17:01:35.227 | info | yii\db\Command::execute | UPDATE "a57be577deb434"."tbl_projects" SET "project_product_version_id"=1393 WHERE "id"=4167 |
| 17:01:35.229 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_project_change_logs" WHERE ("project_id"=4167) AND ("end_at" IS NULL) ORDER BY "id" DESC LIMIT 1 |
| 17:01:35.231 | info | yii\db\Command::execute | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\Projects', 4167, 'a:1:{s:26:"project_product_version_id";i:1393;}', '', 1001, '114.244.130.25') |
| 17:01:35.232 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"=982 |
| 17:01:35.233 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 17:01:35.234 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 17:01:35.234 | info | yii\db\Command::execute | INSERT INTO "a57be577deb434"."tbl_project_product_version_rels" ("project_product_version_id", "product_id", "amount", "number", "total_amount", "description", "supplier_id", "hardware_from", "software_from", "maintenance_from", "hardware_to", "software_to", "maintenance_to") VALUES (1393, 2177, '4234', 1, '4234.00', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL), (1393, 1562, '2323', 1, '2323.00', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL), (1393, 2261, '400', 2, '800.00', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL), (1393, 2171, '5345', 1, '5345.00', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL), (1393, 2177, '3232', 12, '38784.00', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL), (1393, 969, '9247.78', 10, '104500.00', '-', NULL, NULL, NULL, NULL, NULL, NULL, NULL), (1393, 969, '2654.87', 10, '30000.00', '-', NULL, NULL, NULL, NULL, NULL, NULL, NULL), (1393, 1558, '13792.04', 10, '155850.00', '-', NULL, NULL, NULL, NULL, NULL, NULL, NULL), (1393, 2231, '13274.34', 1, '13274.34', '-', NULL, NULL, NULL, NULL, NULL, NULL, NULL), (1393, 2269, '83962.26', 1, '83962.26', '-', NULL, NULL, NULL, NULL, NULL, NULL, NULL) |
| 17:01:35.236 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_projects" WHERE "id"=4167 |
| 17:01:35.237 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_project_product_rels" WHERE "project_id"=4167 ORDER BY "id" |
| 17:01:35.239 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_sales_order_items" WHERE ("project_id"=4167) AND (erp_sales_outbound_id is not null) |
| 17:01:35.244 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_project_change_logs" WHERE ("project_id"=4167) AND ("end_at" IS NULL) ORDER BY "id" DESC LIMIT 1 |
| 17:01:35.246 | info | yii\db\Command::execute | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\Projects', 4167, 'a:0:{}', '', 1001, '114.244.130.25') |
| 17:01:35.249 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"=982 |
| 17:01:35.250 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_project_change_logs" WHERE ("project_id"=4167) AND ("end_at" IS NULL) ORDER BY "id" DESC LIMIT 1 |
| 17:01:35.252 | info | yii\db\Command::execute | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\Projects', 4167, 'a:0:{}', '', 1001, '114.244.130.25') |
| 17:01:35.254 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"=982 |
| 17:01:35.255 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_sales_orders" WHERE "sales_contract_id"=4476 ORDER BY "id" DESC |
| 17:01:35.256 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 17:01:35.256 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 17:01:35.257 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_projects" WHERE "id"=4167 |
| 17:01:35.257 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_project_product_rels" WHERE "project_id"=4167 ORDER BY "id" |
| 17:01:35.258 | info | yii\db\Command::execute | UPDATE "a57be577deb434"."tbl_erp_sales_orders" SET "number"='49', "amount"='439072.6' WHERE "id"=1701 |
| 17:01:35.260 | info | yii\db\Command::execute | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\ErpSalesOrders', 1701, 'a:2:{s:6:"number";d:49;s:6:"amount";d:439072.59999999998;}', '', 1001, '114.244.130.25') |
| 17:01:35.261 | info | yii\db\Command::execute | DELETE FROM "a57be577deb434"."tbl_erp_sales_order_stop_products" WHERE "erp_sales_order_id"=1701 |
| 17:01:35.262 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 17:01:35.262 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 17:01:35.263 | info | yii\db\Command::execute | INSERT INTO "a57be577deb434"."tbl_erp_sales_order_stop_products" ("erp_sales_order_id", "erp_sales_order_product_id", "product_id", "amount", "total_amount", "number", "description", "supplier_id", "hardware_from", "software_from", "maintenance_from", "hardware_to", "software_to", "maintenance_to") VALUES (1701, 2236, 2177, '4234', '4234.00', '1', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL), (1701, 2237, 1562, '2323', '2323.00', '1', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL), (1701, 2233, 2261, '400', '800.00', '2', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL), (1701, 2238, 2171, '5345', '5345.00', '1', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL), (1701, 2235, 2177, '3232', '38784.00', '12', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL), (1701, NULL, 969, '9247.78', '104500.00', '10', '-', NULL, NULL, NULL, NULL, NULL, NULL, NULL), (1701, NULL, 969, '2654.87', '30000.00', '10', '-', NULL, NULL, NULL, NULL, NULL, NULL, NULL), (1701, NULL, 1558, '13792.04', '155850.00', '10', '-', NULL, NULL, NULL, NULL, NULL, NULL, NULL), (1701, NULL, 2231, '13274.34', '13274.34', '1', '-', NULL, NULL, NULL, NULL, NULL, NULL, NULL), (1701, NULL, 2269, '83962.26', '83962.26', '1', '-', NULL, NULL, NULL, NULL, NULL, NULL, NULL) |
| 17:01:35.267 | info | yii\db\Command::execute | UPDATE "a57be577deb434"."tbl_sales_contracts" SET "amount"='439072.6', "updated_at"='now()', "is_edit_verify"=TRUE WHERE "id"=4476 |
| 17:01:35.276 | info | yii\db\Command::execute | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\SalesContracts', 4476, 'a:1:{s:6:"amount";d:439072.59999999998;}', '', 1001, '114.244.130.25') |
| 17:01:35.278 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"=982 |
| 17:01:35.278 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_projects" WHERE "id"=4167 |
| 17:01:35.279 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 17:01:35.280 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 17:01:35.280 | info | yii\db\Command::execute | UPDATE "a57be577deb434"."tbl_erp_sales_order_verify_rels" SET "status"=3 WHERE ("erp_sales_order_id"=1701) AND ("status"=0) |
| 17:01:35.281 | info | yii\db\Command::execute | DELETE FROM "a57be577deb434"."tbl_erp_sales_order_stop_verify_rels" WHERE "erp_sales_order_id"=1701 |
| 17:01:35.282 | info | yii\db\Command::execute | DELETE FROM "a57be577deb434"."tbl_erp_sales_order_stop_products" WHERE "erp_sales_order_id"=1701 |
| 17:01:35.284 | info | yii\db\Command::execute | UPDATE "a57be577deb434"."tbl_erp_sales_orders" SET "stop_at"='now()' WHERE "id"=1701 |
| 17:01:35.285 | info | yii\db\Command::execute | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\ErpSalesOrders', 1701, 'a:1:{s:7:"stop_at";s:5:"now()";}', '', 1001, '114.244.130.25') |
| 17:01:35.286 | info | yii\db\Command::execute | INSERT INTO "a57be577deb434"."tbl_erp_sales_order_stop_products" ("erp_sales_order_id", "erp_sales_order_product_id", "product_id", "amount", "total_amount", "number", "description", "supplier_id", "hardware_from", "software_from", "maintenance_from", "hardware_to", "software_to", "maintenance_to") VALUES (1701, 2236, 2177, '4234', '4234.00', '1', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL), (1701, 2237, 1562, '2323', '2323.00', '1', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL), (1701, 2233, 2261, '400', '800.00', '2', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL), (1701, 2238, 2171, '5345', '5345.00', '1', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL), (1701, 2235, 2177, '3232', '38784.00', '12', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL), (1701, NULL, 969, '9247.78', '104500.00', '10', '-', NULL, NULL, NULL, NULL, NULL, NULL, NULL), (1701, NULL, 969, '2654.87', '30000.00', '10', '-', NULL, NULL, NULL, NULL, NULL, NULL, NULL), (1701, NULL, 1558, '13792.04', '155850.00', '10', '-', NULL, NULL, NULL, NULL, NULL, NULL, NULL), (1701, NULL, 2231, '13274.34', '13274.34', '1', '-', NULL, NULL, NULL, NULL, NULL, NULL, NULL), (1701, NULL, 2269, '83962.26', '83962.26', '1', '-', NULL, NULL, NULL, NULL, NULL, NULL, NULL) |
| 17:01:35.288 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 17:01:35.289 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 17:01:35.289 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_verify_processes" WHERE "id"=6 |
| 17:01:35.291 | info | yii\db\Command::execute | |
| 17:01:35.291 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_sales_order_stop_verify_rels" WHERE ("erp_sales_order_id"=1701) AND ("status"=0) ORDER BY "id" |
| 17:01:35.292 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001 |
| 17:01:35.293 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_sales_order_stop_verify_rels" WHERE ("status"=0) AND ("erp_sales_order_id"=1701) ORDER BY "id" |
| 17:01:35.294 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_sales_order_carbon_copy_rels" WHERE "erp_sales_order_id"=1701 |
| 17:01:35.294 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_sales_order_verify_rels" WHERE "erp_sales_order_id"=1701 ORDER BY "id" |
| 17:01:35.295 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 17:01:35.295 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 17:01:35.295 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_sales_orders" WHERE "id"=1701 |
| 17:01:35.297 | info | yii\db\Command::query | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001) |
| 17:01:35.297 | info | yii\db\Command::query | INSERT INTO "a57be577deb434"."tbl_comments" ("created_by", "object_type", "object_id", "description", "is_system", "description2") VALUES (1001, '20007', 1701, '刘人诚通过了这个审批', TRUE, 'XSDD-20260520-00001') RETURNING "id" |
| 17:01:35.299 | info | yii\db\Command::execute | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('INSERT', 'app\models\Comments', 221108, 'a:11:{s:2:"id";i:221108;s:9:"object_id";i:1701;s:11:"object_type";s:5:"20007";s:6:"parent";N;s:11:"description";s:30:"刘人诚通过了这个审批";s:10:"created_by";i:1001;s:10:"created_at";N;s:8:"reply_to";N;s:9:"is_system";b:1;s:8:"for_user";N;s:12:"description2";s:19:"XSDD-20260520-00001";}', '', 1001, '114.244.130.25') |
| 17:01:35.301 | info | yii\db\Command::query | SELECT "channel_id" FROM "global"."tbl_logins" WHERE (0=1) AND ("id" != 1001) AND (channel_id IS NOT NULL) |
| 17:01:35.301 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"=982 |
| 17:01:35.302 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_projects" WHERE "id"=4167 |
| 17:01:35.303 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: INCR |
| 17:01:35.303 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: HSET |
| 17:01:35.303 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: LPUSH |
| 17:01:35.303 | info | yii\db\Command::execute | UPDATE "a57be577deb434"."tbl_erp_sales_orders" SET "updated_at"='now()' WHERE "id"=1701 |
| 17:01:35.305 | info | yii\db\Command::execute | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\ErpSalesOrders', 1701, 'a:0:{}', '', 1001, '114.244.130.25') |
| 17:01:35.306 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_sales_order_stop_products" WHERE "erp_sales_order_id"=1701 |
| 17:01:35.307 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 17:01:35.307 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 17:01:35.307 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_sales_order_products" WHERE "id"=2236 |
| 17:01:35.308 | info | yii\db\Command::execute | UPDATE "a57be577deb434"."tbl_erp_sales_order_products" SET "total_amount"='4234.00', "last_total_amount"='4234.00' WHERE "id"=2236 |
| 17:01:35.314 | info | yii\db\Command::execute | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\ErpSalesOrderProducts', 2236, 'a:2:{s:12:"total_amount";s:7:"4234.00";s:17:"last_total_amount";s:7:"4234.00";}', '', 1001, '114.244.130.25') |
| 17:01:35.316 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_sales_order_products" WHERE "id"=2237 |
| 17:01:35.317 | info | yii\db\Command::execute | UPDATE "a57be577deb434"."tbl_erp_sales_order_products" SET "total_amount"='2323.00', "last_total_amount"='2323.00' WHERE "id"=2237 |
| 17:01:35.319 | info | yii\db\Command::execute | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\ErpSalesOrderProducts', 2237, 'a:2:{s:12:"total_amount";s:7:"2323.00";s:17:"last_total_amount";s:7:"2323.00";}', '', 1001, '114.244.130.25') |
| 17:01:35.320 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_sales_order_products" WHERE "id"=2233 |
| 17:01:35.321 | info | yii\db\Command::execute | UPDATE "a57be577deb434"."tbl_erp_sales_order_products" SET "total_amount"='800.00', "last_total_amount"='800.00' WHERE "id"=2233 |
| 17:01:35.322 | info | yii\db\Command::execute | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\ErpSalesOrderProducts', 2233, 'a:2:{s:12:"total_amount";s:6:"800.00";s:17:"last_total_amount";s:6:"800.00";}', '', 1001, '114.244.130.25') |
| 17:01:35.324 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_sales_order_products" WHERE "id"=2238 |
| 17:01:35.324 | info | yii\db\Command::execute | UPDATE "a57be577deb434"."tbl_erp_sales_order_products" SET "total_amount"='5345.00', "last_total_amount"='5345.00' WHERE "id"=2238 |
| 17:01:35.327 | info | yii\db\Command::execute | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\ErpSalesOrderProducts', 2238, 'a:2:{s:12:"total_amount";s:7:"5345.00";s:17:"last_total_amount";s:7:"5345.00";}', '', 1001, '114.244.130.25') |
| 17:01:35.329 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_sales_order_products" WHERE "id"=2235 |
| 17:01:35.330 | info | yii\db\Command::execute | UPDATE "a57be577deb434"."tbl_erp_sales_order_products" SET "total_amount"='38784.00', "last_total_amount"='38784.00' WHERE "id"=2235 |
| 17:01:35.331 | info | yii\db\Command::execute | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\ErpSalesOrderProducts', 2235, 'a:2:{s:12:"total_amount";s:8:"38784.00";s:17:"last_total_amount";s:8:"38784.00";}', '', 1001, '114.244.130.25') |
| 17:01:35.333 | info | yii\db\Command::query | INSERT INTO "a57be577deb434"."tbl_erp_sales_order_products" ("erp_sales_order_id", "product_id", "number", "amount", "total_amount", "description", "supplier_id", "hardware_from", "software_from", "maintenance_from", "hardware_to", "software_to", "maintenance_to") VALUES (1701, 969, '10', '9247.78', '104500.00', '-', NULL, NULL, NULL, NULL, NULL, NULL, NULL) RETURNING "id" |
| 17:01:35.335 | info | yii\db\Command::execute | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('INSERT', 'app\models\ErpSalesOrderProducts', 2293, 'a:21:{s:2:"id";i:2293;s:18:"erp_sales_order_id";i:1701;s:12:"erp_store_id";N;s:10:"product_id";i:969;s:11:"description";s:1:"-";s:6:"number";s:2:"10";s:8:"outbound";N;s:6:"amount";s:7:"9247.78";s:12:"total_amount";s:9:"104500.00";s:11:"last_number";N;s:11:"last_amount";N;s:17:"last_total_amount";N;s:4:"cost";N;s:10:"total_cost";N;s:11:"supplier_id";N;s:13:"hardware_from";N;s:13:"software_from";N;s:16:"maintenance_from";N;s:11:"hardware_to";N;s:11:"software_to";N;s:14:"maintenance_to";N;}', '', 1001, '114.244.130.25') |
| 17:01:35.336 | info | yii\db\Command::query | INSERT INTO "a57be577deb434"."tbl_erp_sales_order_products" ("erp_sales_order_id", "product_id", "number", "amount", "total_amount", "description", "supplier_id", "hardware_from", "software_from", "maintenance_from", "hardware_to", "software_to", "maintenance_to") VALUES (1701, 969, '10', '2654.87', '30000.00', '-', NULL, NULL, NULL, NULL, NULL, NULL, NULL) RETURNING "id" |
| 17:01:35.337 | info | yii\db\Command::execute | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('INSERT', 'app\models\ErpSalesOrderProducts', 2294, 'a:21:{s:2:"id";i:2294;s:18:"erp_sales_order_id";i:1701;s:12:"erp_store_id";N;s:10:"product_id";i:969;s:11:"description";s:1:"-";s:6:"number";s:2:"10";s:8:"outbound";N;s:6:"amount";s:7:"2654.87";s:12:"total_amount";s:8:"30000.00";s:11:"last_number";N;s:11:"last_amount";N;s:17:"last_total_amount";N;s:4:"cost";N;s:10:"total_cost";N;s:11:"supplier_id";N;s:13:"hardware_from";N;s:13:"software_from";N;s:16:"maintenance_from";N;s:11:"hardware_to";N;s:11:"software_to";N;s:14:"maintenance_to";N;}', '', 1001, '114.244.130.25') |
| 17:01:35.339 | info | yii\db\Command::query | INSERT INTO "a57be577deb434"."tbl_erp_sales_order_products" ("erp_sales_order_id", "product_id", "number", "amount", "total_amount", "description", "supplier_id", "hardware_from", "software_from", "maintenance_from", "hardware_to", "software_to", "maintenance_to") VALUES (1701, 1558, '10', '13792.04', '155850.00', '-', NULL, NULL, NULL, NULL, NULL, NULL, NULL) RETURNING "id" |
| 17:01:35.340 | info | yii\db\Command::execute | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('INSERT', 'app\models\ErpSalesOrderProducts', 2295, 'a:21:{s:2:"id";i:2295;s:18:"erp_sales_order_id";i:1701;s:12:"erp_store_id";N;s:10:"product_id";i:1558;s:11:"description";s:1:"-";s:6:"number";s:2:"10";s:8:"outbound";N;s:6:"amount";s:8:"13792.04";s:12:"total_amount";s:9:"155850.00";s:11:"last_number";N;s:11:"last_amount";N;s:17:"last_total_amount";N;s:4:"cost";N;s:10:"total_cost";N;s:11:"supplier_id";N;s:13:"hardware_from";N;s:13:"software_from";N;s:16:"maintenance_from";N;s:11:"hardware_to";N;s:11:"software_to";N;s:14:"maintenance_to";N;}', '', 1001, '114.244.130.25') |
| 17:01:35.342 | info | yii\db\Command::query | INSERT INTO "a57be577deb434"."tbl_erp_sales_order_products" ("erp_sales_order_id", "product_id", "number", "amount", "total_amount", "description", "supplier_id", "hardware_from", "software_from", "maintenance_from", "hardware_to", "software_to", "maintenance_to") VALUES (1701, 2231, '1', '13274.34', '13274.34', '-', NULL, NULL, NULL, NULL, NULL, NULL, NULL) RETURNING "id" |
| 17:01:35.343 | info | yii\db\Command::execute | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('INSERT', 'app\models\ErpSalesOrderProducts', 2296, 'a:21:{s:2:"id";i:2296;s:18:"erp_sales_order_id";i:1701;s:12:"erp_store_id";N;s:10:"product_id";i:2231;s:11:"description";s:1:"-";s:6:"number";s:1:"1";s:8:"outbound";N;s:6:"amount";s:8:"13274.34";s:12:"total_amount";s:8:"13274.34";s:11:"last_number";N;s:11:"last_amount";N;s:17:"last_total_amount";N;s:4:"cost";N;s:10:"total_cost";N;s:11:"supplier_id";N;s:13:"hardware_from";N;s:13:"software_from";N;s:16:"maintenance_from";N;s:11:"hardware_to";N;s:11:"software_to";N;s:14:"maintenance_to";N;}', '', 1001, '114.244.130.25') |
| 17:01:35.344 | info | yii\db\Command::query | INSERT INTO "a57be577deb434"."tbl_erp_sales_order_products" ("erp_sales_order_id", "product_id", "number", "amount", "total_amount", "description", "supplier_id", "hardware_from", "software_from", "maintenance_from", "hardware_to", "software_to", "maintenance_to") VALUES (1701, 2269, '1', '83962.26', '83962.26', '-', NULL, NULL, NULL, NULL, NULL, NULL, NULL) RETURNING "id" |
| 17:01:35.346 | info | yii\db\Command::execute | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('INSERT', 'app\models\ErpSalesOrderProducts', 2297, 'a:21:{s:2:"id";i:2297;s:18:"erp_sales_order_id";i:1701;s:12:"erp_store_id";N;s:10:"product_id";i:2269;s:11:"description";s:1:"-";s:6:"number";s:1:"1";s:8:"outbound";N;s:6:"amount";s:8:"83962.26";s:12:"total_amount";s:8:"83962.26";s:11:"last_number";N;s:11:"last_amount";N;s:17:"last_total_amount";N;s:4:"cost";N;s:10:"total_cost";N;s:11:"supplier_id";N;s:13:"hardware_from";N;s:13:"software_from";N;s:16:"maintenance_from";N;s:11:"hardware_to";N;s:11:"software_to";N;s:14:"maintenance_to";N;}', '', 1001, '114.244.130.25') |
| 17:01:35.348 | info | yii\db\Command::execute | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\ErpSalesOrders', 1701, 'a:0:{}', '', 1001, '114.244.130.25') |
| 17:01:35.349 | info | yii\db\Command::execute | DELETE FROM "a57be577deb434"."tbl_erp_sales_order_products" WHERE ("id" NOT IN (2236, 2237, 2233, 2238, 2235, 2293, 2294, 2295, 2296, 2297)) AND ("erp_sales_order_id"=1701) |
| 17:01:35.350 | info | yii\db\Command::execute | DELETE FROM "a57be577deb434"."tbl_erp_sales_order_stop_products" WHERE "erp_sales_order_id"=1701 |
| 17:01:35.351 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_sales_order_products" WHERE "erp_sales_order_id"=1701 |
| 17:01:35.351 | info | yii\db\Command::execute | DELETE FROM "a57be577deb434"."tbl_project_product_rels" WHERE "project_id"=4167 |
| 17:01:35.353 | info | yii\db\Command::execute | INSERT INTO "a57be577deb434"."tbl_project_product_rels" ("project_id", "erp_sales_order_product_id", "product_id", "amount", "total_amount", "number", "description", "supplier_id", "hardware_from", "software_from", "maintenance_from", "hardware_to", "software_to", "maintenance_to") VALUES (4167, 2236, 2177, '4234', '4234.00', 1, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL), (4167, 2237, 1562, '2323', '2323.00', 1, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL), (4167, 2233, 2261, '400', '800.00', 2, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL), (4167, 2238, 2171, '5345', '5345.00', 1, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL), (4167, 2235, 2177, '3232', '38784.00', 12, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL), (4167, 2293, 969, '9247.78', '104500.00', 10, '-', NULL, NULL, NULL, NULL, NULL, NULL, NULL), (4167, 2294, 969, '2654.87', '30000.00', 10, '-', NULL, NULL, NULL, NULL, NULL, NULL, NULL), (4167, 2295, 1558, '13792.04', '155850.00', 10, '-', NULL, NULL, NULL, NULL, NULL, NULL, NULL), (4167, 2296, 2231, '13274.34', '13274.34', 1, '-', NULL, NULL, NULL, NULL, NULL, NULL, NULL), (4167, 2297, 2269, '83962.26', '83962.26', 1, '-', NULL, NULL, NULL, NULL, NULL, NULL, NULL) |
| 17:01:35.356 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_project_change_logs" WHERE ("project_id"=4167) AND ("end_at" IS NULL) ORDER BY "id" DESC LIMIT 1 |
| 17:01:35.359 | info | yii\db\Command::execute | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\Projects', 4167, 'a:0:{}', '', 1001, '114.244.130.25') |
| 17:01:35.360 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"=982 |
| 17:01:35.361 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_sales_contracts" WHERE "id"=4476 |
| 17:01:35.361 | info | yii\db\Command::execute | UPDATE "a57be577deb434"."tbl_sales_contracts" SET "is_edit_verify"=FALSE WHERE "id"=4476 |
| 17:01:35.363 | info | yii\db\Command::execute | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\SalesContracts', 4476, 'a:0:{}', '', 1001, '114.244.130.25') |
| 17:01:35.364 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"=982 |
| 17:01:35.365 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_projects" WHERE "id"=4167 |
| 17:01:35.365 | info | yii\db\Command::query | SELECT SUM(r.amount) FROM "a57be577deb434"."tbl_erp_cash_cost_ticket_sales_contract_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_cash_cost_tickets" "t" ON r.erp_cash_cost_ticket_id = t.id WHERE ("r"."sales_contract_id"=4476) AND ("t"."is_payment_settle"=TRUE) AND ("t"."status" IN (2, 5)) |
| 17:01:35.367 | info | yii\db\Command::query | SELECT SUM(r.amount) FROM "a57be577deb434"."tbl_erp_collect_ticket_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_collect_tickets" "t" ON r.erp_collect_ticket_id = t.id WHERE ("r"."sales_contract_id"=4476) AND ("t"."status" IN (2, 5)) |
| 17:01:35.368 | info | yii\db\Command::query | SELECT SUM(r.amount) FROM "a57be577deb434"."tbl_erp_payment_ticket_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_payment_tickets" "t" ON r.erp_payment_ticket_id = t.id WHERE ("r"."sales_contract_id"=4476) AND ("t"."status" IN (2, 5)) AND ("t"."is_payment_settle"=TRUE) |
| 17:01:35.369 | info | yii\db\Command::query | SELECT EXISTS(SELECT "r".* FROM "a57be577deb434"."tbl_erp_cash_cost_ticket_sales_contract_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_cash_cost_tickets" "t" ON r.erp_cash_cost_ticket_id = t.id WHERE ("r"."sales_contract_id"=4476) AND ("t"."status"=1)) |
| 17:01:35.370 | info | yii\db\Command::query | SELECT EXISTS(SELECT "r".* FROM "a57be577deb434"."tbl_erp_collect_ticket_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_collect_tickets" "t" ON r.erp_collect_ticket_id = t.id WHERE ("r"."sales_contract_id"=4476) AND ("t"."status"=1)) |
| 17:01:35.371 | info | yii\db\Command::query | SELECT EXISTS(SELECT "r".* FROM "a57be577deb434"."tbl_erp_payment_ticket_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_payment_tickets" "t" ON r.erp_payment_ticket_id = t.id WHERE ("r"."sales_contract_id"=4476) AND ("t"."status"=1)) |
| 17:01:35.371 | info | yii\db\Command::query | SELECT SUM(r.amount) FROM "a57be577deb434"."tbl_erp_cash_cost_ticket_sales_contract_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_cash_cost_tickets" "t" ON r.erp_cash_cost_ticket_id = t.id WHERE ("r"."sales_contract_id"=4476) AND ("t"."is_payment_settle"=TRUE) AND ("t"."status" IN (1, 2, 5)) |
| 17:01:35.372 | info | yii\db\Command::query | SELECT SUM(r.amount) FROM "a57be577deb434"."tbl_erp_collect_ticket_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_collect_tickets" "t" ON r.erp_collect_ticket_id = t.id WHERE ("r"."sales_contract_id"=4476) AND ("t"."status" IN (1, 2, 5)) |
| 17:01:35.373 | info | yii\db\Command::query | SELECT SUM(r.amount) FROM "a57be577deb434"."tbl_erp_payment_ticket_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_payment_tickets" "t" ON r.erp_payment_ticket_id = t.id WHERE ("r"."sales_contract_id"=4476) AND ("t"."status" IN (1, 2, 5)) |
| 17:01:35.374 | info | yii\db\Command::execute | UPDATE "a57be577deb434"."tbl_sales_contracts" SET "erp_settle_amount"='100', "erp_un_settle_amount"='438972.6', "erp_all_settle_amount"='100' WHERE "id"=4476 |
| 17:01:35.375 | info | yii\db\Command::execute | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\SalesContracts', 4476, 'a:1:{s:20:"erp_un_settle_amount";d:438972.59999999998;}', '', 1001, '114.244.130.25') |
| 17:01:35.376 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"=982 |
| 17:01:35.377 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_projects" WHERE "id"=4167 |
| 17:01:35.378 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_projects" WHERE "id"=4167 |
| 17:01:35.379 | info | yii\db\Command::execute | UPDATE "a57be577deb434"."tbl_projects" SET "collected"='100' WHERE "id"=4167 |
| 17:01:35.380 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_project_change_logs" WHERE ("project_id"=4167) AND ("end_at" IS NULL) ORDER BY "id" DESC LIMIT 1 |
| 17:01:35.383 | info | yii\db\Command::execute | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\Projects', 4167, 'a:0:{}', '', 1001, '114.244.130.25') |
| 17:01:35.384 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"=982 |
| 17:01:35.384 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_project_status_logs" WHERE "project_id"=4167 ORDER BY "created_at" DESC |
| 17:01:35.386 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 17:01:35.386 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 17:01:35.386 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_sales_contracts" WHERE "id"=4476 |
| 17:01:35.387 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 17:01:35.387 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 17:01:35.387 | info | yii\db\Command::execute | UPDATE "a57be577deb434"."tbl_sales_contract_payment_collection_remind_dates" SET "paid_amount"='0', "status"=0, "overdue_days"=NULL WHERE "contract_id"=4476 |
| 17:01:35.388 | info | yii\db\Command::query | SELECT r.amount, t.created_at FROM "a57be577deb434"."tbl_erp_cash_cost_ticket_sales_contract_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_cash_cost_tickets" "t" ON r.erp_cash_cost_ticket_id = t.id WHERE ("r"."sales_contract_id"=4476) AND ("t"."status" IN (2, 5, 1)) |
| 17:01:35.389 | info | yii\db\Command::query | SELECT r.amount, t.wrote_date as created_at FROM "a57be577deb434"."tbl_erp_collect_ticket_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_collect_tickets" "t" ON r.erp_collect_ticket_id = t.id WHERE ("r"."sales_contract_id"=4476) AND ("t"."status" IN (2, 5, 1)) |
| 17:01:35.390 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 17:01:35.390 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 17:01:35.390 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_projects" WHERE "id"=4167 |
| 17:01:35.391 | info | yii\db\Command::query | SELECT SUM(amount) FROM "a57be577deb434"."tbl_sales_contract_payment_collection_remind_dates" WHERE "contract_id"=4476 |
| 17:01:35.392 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_project_change_logs" WHERE ("project_id"=4167) AND ("end_at" IS NULL) ORDER BY "id" DESC LIMIT 1 |
| 17:01:35.395 | info | yii\db\Command::execute | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\Projects', 4167, 'a:0:{}', '', 1001, '114.244.130.25') |
| 17:01:35.396 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"=982 |
| 17:01:35.397 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_sales_contract_payment_collection_remind_dates" WHERE ("contract_id"=4476) AND (amount > paid_amount) ORDER BY "remind_date" |
| 17:01:35.398 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_sales_order_products" WHERE "erp_sales_order_id"=1701 |
| 17:01:35.399 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_sales_outbound_products" WHERE "erp_sales_order_product_id" IN (2236, 2237, 2233, 2238, 2235, 2293, 2294, 2295, 2296, 2297) |
| 17:01:35.400 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 17:01:35.400 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 17:01:35.400 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_sales_outbounds" WHERE "id"=154 |
| 17:01:35.401 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 17:01:35.401 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 17:01:35.402 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_sales_outbound_spent_products" WHERE "erp_sales_outbound_product_id"=450 |
| 17:01:35.402 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 17:01:35.402 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 17:01:35.403 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_sales_return_products" WHERE "erp_sales_outbound_spent_product_id"=539 |
| 17:01:35.404 | info | yii\db\Command::execute | UPDATE "a57be577deb434"."tbl_erp_sales_order_products" SET "outbound"='0' WHERE "id"=2236 |
| 17:01:35.405 | info | yii\db\Command::execute | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\ErpSalesOrderProducts', 2236, 'a:0:{}', '', 1001, '114.244.130.25') |
| 17:01:35.406 | info | yii\db\Command::execute | UPDATE "a57be577deb434"."tbl_project_product_rels" SET "cost"=NULL, "total_cost"=NULL WHERE "erp_sales_order_product_id"=2236 |
| 17:01:35.408 | info | yii\db\Command::execute | UPDATE "a57be577deb434"."tbl_erp_sales_order_products" SET "outbound"='0' WHERE "id"=2237 |
| 17:01:35.409 | info | yii\db\Command::execute | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\ErpSalesOrderProducts', 2237, 'a:0:{}', '', 1001, '114.244.130.25') |
| 17:01:35.410 | info | yii\db\Command::execute | UPDATE "a57be577deb434"."tbl_project_product_rels" SET "cost"=NULL, "total_cost"=NULL WHERE "erp_sales_order_product_id"=2237 |
| 17:01:35.411 | info | yii\db\Command::execute | UPDATE "a57be577deb434"."tbl_erp_sales_order_products" SET "outbound"='1' WHERE "id"=2233 |
| 17:01:35.413 | info | yii\db\Command::execute | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\ErpSalesOrderProducts', 2233, 'a:0:{}', '', 1001, '114.244.130.25') |
| 17:01:35.414 | info | yii\db\Command::execute | UPDATE "a57be577deb434"."tbl_project_product_rels" SET "cost"=NULL, "total_cost"=NULL WHERE "erp_sales_order_product_id"=2233 |
| 17:01:35.416 | info | yii\db\Command::execute | UPDATE "a57be577deb434"."tbl_erp_sales_order_products" SET "outbound"='0' WHERE "id"=2238 |
| 17:01:35.417 | info | yii\db\Command::execute | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\ErpSalesOrderProducts', 2238, 'a:0:{}', '', 1001, '114.244.130.25') |
| 17:01:35.418 | info | yii\db\Command::execute | UPDATE "a57be577deb434"."tbl_project_product_rels" SET "cost"=NULL, "total_cost"=NULL WHERE "erp_sales_order_product_id"=2238 |
| 17:01:35.419 | info | yii\db\Command::execute | UPDATE "a57be577deb434"."tbl_erp_sales_order_products" SET "outbound"='0' WHERE "id"=2235 |
| 17:01:35.421 | info | yii\db\Command::execute | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\ErpSalesOrderProducts', 2235, 'a:0:{}', '', 1001, '114.244.130.25') |
| 17:01:35.422 | info | yii\db\Command::execute | UPDATE "a57be577deb434"."tbl_project_product_rels" SET "cost"=NULL, "total_cost"=NULL WHERE "erp_sales_order_product_id"=2235 |
| 17:01:35.424 | info | yii\db\Command::execute | UPDATE "a57be577deb434"."tbl_erp_sales_order_products" SET "outbound"='0' WHERE "id"=2293 |
| 17:01:35.425 | info | yii\db\Command::execute | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\ErpSalesOrderProducts', 2293, 'a:0:{}', '', 1001, '114.244.130.25') |
| 17:01:35.426 | info | yii\db\Command::execute | UPDATE "a57be577deb434"."tbl_project_product_rels" SET "cost"=NULL, "total_cost"=NULL WHERE "erp_sales_order_product_id"=2293 |
| 17:01:35.428 | info | yii\db\Command::execute | UPDATE "a57be577deb434"."tbl_erp_sales_order_products" SET "outbound"='0' WHERE "id"=2294 |
| 17:01:35.429 | info | yii\db\Command::execute | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\ErpSalesOrderProducts', 2294, 'a:0:{}', '', 1001, '114.244.130.25') |
| 17:01:35.430 | info | yii\db\Command::execute | UPDATE "a57be577deb434"."tbl_project_product_rels" SET "cost"=NULL, "total_cost"=NULL WHERE "erp_sales_order_product_id"=2294 |
| 17:01:35.432 | info | yii\db\Command::execute | UPDATE "a57be577deb434"."tbl_erp_sales_order_products" SET "outbound"='0' WHERE "id"=2295 |
| 17:01:35.433 | info | yii\db\Command::execute | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\ErpSalesOrderProducts', 2295, 'a:0:{}', '', 1001, '114.244.130.25') |
| 17:01:35.434 | info | yii\db\Command::execute | UPDATE "a57be577deb434"."tbl_project_product_rels" SET "cost"=NULL, "total_cost"=NULL WHERE "erp_sales_order_product_id"=2295 |
| 17:01:35.435 | info | yii\db\Command::execute | UPDATE "a57be577deb434"."tbl_erp_sales_order_products" SET "outbound"='0' WHERE "id"=2296 |
| 17:01:35.438 | info | yii\db\Command::execute | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\ErpSalesOrderProducts', 2296, 'a:0:{}', '', 1001, '114.244.130.25') |
| 17:01:35.439 | info | yii\db\Command::execute | UPDATE "a57be577deb434"."tbl_project_product_rels" SET "cost"=NULL, "total_cost"=NULL WHERE "erp_sales_order_product_id"=2296 |
| 17:01:35.441 | info | yii\db\Command::execute | UPDATE "a57be577deb434"."tbl_erp_sales_order_products" SET "outbound"='0' WHERE "id"=2297 |
| 17:01:35.442 | info | yii\db\Command::execute | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\ErpSalesOrderProducts', 2297, 'a:0:{}', '', 1001, '114.244.130.25') |
| 17:01:35.443 | info | yii\db\Command::execute | UPDATE "a57be577deb434"."tbl_project_product_rels" SET "cost"=NULL, "total_cost"=NULL WHERE "erp_sales_order_product_id"=2297 |
| 17:01:35.445 | info | yii\db\Command::execute | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\ErpSalesOrders', 1701, 'a:0:{}', '', 1001, '114.244.130.25') |
| 17:01:35.446 | info | yii\db\Command::execute | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\SalesContracts', 4476, 'a:0:{}', '', 1001, '114.244.130.25') |
| 17:01:35.447 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"=982 |
| 17:01:35.448 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_projects" WHERE "id"=4167 |
| 17:01:35.448 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001 |
| 17:01:35.449 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001 |
| 17:01:35.449 | info | yii\db\Command::execute | INSERT INTO "a57be577deb434"."tbl_object_change_logs" ("act", "attribute", "object_id", "object_type", "created_by", "created_at", "new_value", "old_value", "description") VALUES (11, 'status', 1701, 20007, 1001, 'now()', '["\u5218\u4eba\u8bda"]', '[]', '{"d1":"\u5218\u4eba\u8bda","d2":"\u7f16\u8f91\u4e86","d3":"\u9500\u552e\u8ba2\u5355\u7533\u8bf7","d4":""}') |
| 17:01:35.451 | info | yii\db\Command::execute | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\SalesContracts', 4476, 'a:0:{}', '', 1001, '114.244.130.25') |
| 17:01:35.452 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"=982 |
| 17:01:35.452 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_projects" WHERE "id"=4167 |
| 17:01:35.453 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"=982 |
| 17:01:35.455 | info | yii\db\Command::execute | UPDATE "a57be577deb434"."tbl_clients" SET "updated_at"='now()' WHERE "id"=982 |
| 17:01:35.456 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_client_am_change_logs" WHERE ("client_id"=982) AND ("sales_rep" IS NULL) AND ("end_at" IS NULL) ORDER BY "id" DESC LIMIT 1 |
| 17:01:35.491 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 17:01:35.491 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 17:01:35.491 | info | yii\db\Command::query | INSERT INTO "a57be577deb434"."tbl_client_am_change_logs" ("client_id", "sales_rep", "start_from", "end_at") VALUES (982, 1001, 'now()', NULL) RETURNING "id" |
| 17:01:35.493 | info | yii\db\Command::execute | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('INSERT', 'app\models\ClientAmChangeLogs', 200064, 'a:5:{s:2:"id";i:200064;s:9:"client_id";i:982;s:9:"sales_rep";i:1001;s:10:"start_from";s:5:"now()";s:6:"end_at";N;}', '', 1001, '114.244.130.25') |
| 17:01:35.495 | info | yii\db\Command::execute | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\Clients', 982, 'a:0:{}', '', 1001, '114.244.130.25') |
| 17:01:35.496 | info | yii\db\Command::query | INSERT INTO "a57be577deb434"."tbl_object_change_logs" ("act", "attribute", "object_id", "object_type", "target_id", "target_object_type", "created_by", "new_value", "old_value", "description") VALUES (2, 'update', 982, 10, 4167, 1, 1001, '[4167]', '[4167]', '{"d1":"\u5218\u4eba\u8bda","d2":"\u66f4\u65b0\u4e86","d3":"\u5546\u673a","d4":["\u65b0\u5efa\u9879\u76ee"]}') RETURNING "id" |
| 17:01:35.497 | info | yii\db\Command::execute | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('INSERT', 'app\models\ObjectChangeLogs', 643565, 'a:13:{s:2:"id";i:643565;s:9:"object_id";i:982;s:11:"object_type";i:10;s:9:"target_id";i:4167;s:18:"target_object_type";i:1;s:3:"act";i:2;s:9:"attribute";s:6:"update";s:9:"old_value";s:6:"[4167]";s:9:"new_value";s:6:"[4167]";s:11:"description";s:107:"{"d1":"\u5218\u4eba\u8bda","d2":"\u66f4\u65b0\u4e86","d3":"\u5546\u673a","d4":["\u65b0\u5efa\u9879\u76ee"]}";s:10:"created_by";i:1001;s:10:"created_at";N;s:9:"is_delete";N;}', '', 1001, '114.244.130.25') |
| 17:01:35.499 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 17:01:35.499 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 17:01:35.500 | info | yii\db\Command::query | INSERT INTO "global"."tbl_api_log" ("code", "schema", "user_id", "device_type", "url", "request", "response", "php_error", "time", "duration") VALUES (200, 'a57be577deb434', 1001, 5, 'vue/sales-contract/save-product', '{"SalesContracts":{"id":"4476","budget":"51486","profit":"43907.25","profit_pct":"10.00","project_product_version_id":"1368","project_id":"4167","projectProductRels":{"12120":{"product_id":"2177","amount":"4234.00","total_amount":"4234.00","number":"1","description":"","hardware_from":"","hardware_to":"","maintenance_from":"","maintenance_to":"","software_from":"","software_to":"","supplier_id":""},"12121":{"product_id":"1562","amount":"2323.00","total_amount":"2323.00","number":"1","description":"","hardware_from":"","hardware_to":"","maintenance_from":"","maintenance_to":"","software_from":"","software_to":"","supplier_id":""},"12122":{"product_id":"2261","amount":"400.00","total_amount":"800.00","number":"2","description":"","hardware_from":"","hardware_to":"","maintenance_from":"","maintenance_to":"","software_from":"","software_to":"","supplier_id":""},"12123":{"product_id":"2171","amount":"5345.00","total_amount":"5345.00","number":"1","description":"","hardware_from":"","hardware_to":"","maintenance_from":"","maintenance_to":"","software_from":"","software_to":"","supplier_id":""},"12124":{"product_id":"2177","amount":"3232.00","total_amount":"38784.00","number":"12","description":"","hardware_from":"","hardware_to":"","maintenance_from":"","maintenance_to":"","software_from":"","software_to":"","supplier_id":""},"new":{"5":{"product_id":"969","amount":"9247.78","total_amount":"104500.00","number":"10","description":"-","hardware_from":"","hardware_to":"","maintenance_from":"","maintenance_to":"","software_from":"","software_to":"","supplier_id":""},"6":{"product_id":"969","amount":"2654.87","total_amount":"30000.00","number":"10","description":"-","hardware_from":"","hardware_to":"","maintenance_from":"","maintenance_to":"","software_from":"","software_to":"","supplier_id":""},"7":{"product_id":"1558","amount":"13792.04","total_amount":"155850.00","number":"10","description":"-","hardware_from":"","hardware_to":"","maintenance_from":"","maintenance_to":"","software_from":"","software_to":"","supplier_id":""},"8":{"product_id":"2231","amount":"13274.34","total_amount":"13274.34","number":"1","description":"-","hardware_from":"","hardware_to":"","maintenance_from":"","maintenance_to":"","software_from":"","software_to":"","supplier_id":""},"9":{"product_id":"2269","amount":"83962.26","total_amount":"83962.26","number":"1","description":"-","hardware_from":"","hardware_to":"","maintenance_from":"","maintenance_to":"","software_from":"","software_to":"","supplier_id":""}}},"projectProductTypes":{"7":{"budget":"48363","profit":"4836.3","pct":"10"},"5":{"budget":"305947.34","profit":"30594.73","pct":"10"},"4":{"budget":"800","profit":"80","pct":"10"},"3":{"budget":"83962.26","profit":"8396.22","pct":"10"}}},"web_access_token":"--xxX6Gmp9PXF1XHWWwlXiYIP9-yVx7F"}', '{"code":2000,"result":"","status":1,"msg":[{"name":"success","success":"\u5546\u673a\u5df2\u88ab\u6210\u529f\u4fee\u6539","error":""}],"mod":0,"ip":"114.244.130.25","ua":"Mozilla\/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit\/537.36 (KHTML, like Gecko) Chrome\/150.0.0.0 Safari\/537.36"}', FALSE, '2026-07-16 17:01:35', 382008064) RETURNING "id" |
| 17:01:35.504 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 17:01:35.504 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: SET |