ConfigurationRequestLogsProfilingDatabaseAsset BundlesMailTimeline
6a222f2d75471: POST https://beta.jinchangxiao.com/vue/project/save-edit at 2026-06-05 10:06:37 am by 221.216.117.119

Performance Profiling

Total processing time: 1,273 ms; Peak memory: 8.742 MB. Show Profiling Timeline

总计288条数据
TimeDurationCategoryInfo
  
10:06:37.560963.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_client_am_change_logs" WHERE ("client_id"=3311) AND ("sales_rep" IS NULL) AND ("end_at" IS NULL) ORDER BY "id" DESC LIMIT 1
10:06:38.65136.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_client_am_change_logs" WHERE ("client_id"=3311) AND ("sales_rep" IS NULL) AND ("end_at" IS NULL) ORDER BY "id" DESC LIMIT 1
10:06:38.69329.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_client_am_change_logs" WHERE ("client_id"=3311) AND ("sales_rep" IS NULL) AND ("end_at" IS NULL) ORDER BY "id" DESC LIMIT 1
10:06:38.52816.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_client_am_change_logs" WHERE ("client_id"=3311) AND ("sales_rep" IS NULL) AND ("end_at" IS NULL) ORDER BY "id" DESC LIMIT 1
10:06:37.5054.2 msyii\db\Command::executeUPDATE "a57be577deb434"."tbl_projects" SET "client_id"=3311, "project_progress"=3, "budget"='88221', "profit_pct"='10', "updated_at"='now()', "status_updated_at"='now()', "contract_type"=1, "from_contact"=NULL, "project_product_version_id"=1375, "change_status_to"=3 WHERE "id"=4173
10:06:38.5903.6 msyii\db\Command::executeUPDATE "a57be577deb434"."tbl_erp_cash_cost_tickets" SET "sales_contract_id"=4490 WHERE "reimbursement_id" IN (SELECT "id" FROM "a57be577deb434"."tbl_reimbursements" WHERE "project_id"=4173)
10:06:37.5093.6 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_project_change_logs" WHERE ("project_id"=4173) AND ("end_at" IS NULL) ORDER BY "id" DESC LIMIT 1
10:06:37.5283.5 msyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_user_action_logs" ("act", "attribute", "object_id", "object_type", "created_by", "created_at", "new_value", "old_value", "users", "description") VALUES (2, 'projectUsedClientPayments', 4173, 1, 1001, 'now()', '[["700.00\u5143 \u6536\u6b3e\u65f6\u95f4:2026-06-02 00:00:00"]]', '[["700.00\u5143 \u6536\u6b3e\u65f6\u95f4:2026-06-02"]]', array[1001], '{"d1":"\u5218\u4eba\u8bda","d2":"\u66f4\u65b0\u4e86","d3":"\u7528\u6237\u6536\u6b3e\u4fe1\u606f","d4":["700.00\u5143 \u6536\u6b3e\u65f6\u95f4:2026-06-02; <b>\u53d8\u4e3a<\/b> 700.00\u5143 \u6536\u6b3e\u65f6\u95f4:2026-06-02 00:00:00;"]}')
10:06:37.5433.1 msyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_attachement_relationships" ("object_type", "object_id", "attachment_id") VALUES (113, 1, 32702)
10:06:38.5992.6 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_purchase_client_rels" WHERE "project_id"=4173
10:06:37.5242.4 msyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_object_change_logs" ("act", "attribute", "object_id", "object_type", "created_by", "created_at", "new_value", "old_value", "description") VALUES (2, 'projectUsedClientPayments', 4173, 1, 1001, 'now()', '[["700.00\u5143 \u6536\u6b3e\u65f6\u95f4:2026-06-02 00:00:00"]]', '[["700.00\u5143 \u6536\u6b3e\u65f6\u95f4:2026-06-02"]]', '{"d1":"\u5218\u4eba\u8bda","d2":"\u66f4\u65b0\u4e86","d3":"\u7528\u6237\u6536\u6b3e\u4fe1\u606f","d4":["700.00\u5143 \u6536\u6b3e\u65f6\u95f4:2026-06-02; <b>\u53d8\u4e3a<\/b> 700.00\u5143 \u6536\u6b3e\u65f6\u95f4:2026-06-02 00:00:00;"]}')
10:06:38.6352.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_project_change_logs" WHERE ("project_id"=4173) AND ("end_at" IS NULL) ORDER BY "id" DESC LIMIT 1
10:06:38.6432.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_project_change_logs" WHERE ("project_id"=4173) AND ("end_at" IS NULL) ORDER BY "id" DESC LIMIT 1
10:06:38.6182.1 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_project_change_logs" WHERE ("project_id"=4173) AND ("end_at" IS NULL) ORDER BY "id" DESC LIMIT 1
10:06:37.5382.0 msyii\db\Command::executeDELETE FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=112) AND ("object_id"=1)
10:06:37.5412.0 msyii\db\Command::executeDELETE FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=113) AND ("object_id"=1)
10:06:37.5522.0 msyii\db\Command::executeDELETE FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=114) AND ("object_id"=1)
10:06:37.5552.0 msyii\db\Command::executeDELETE FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=115) AND ("object_id"=1)
10:06:38.6482.0 msyii\db\Command::executeUPDATE "a57be577deb434"."tbl_clients" SET "updated_at"='now()' WHERE "id"=3311
10:06:38.6101.9 msyii\db\Command::queryINSERT INTO "a57be577deb434"."tbl_sales_contract_payment_collection_remind_receivers" ("contract_id", "user_id") VALUES (4490, 1001) RETURNING "id"
10:06:37.5161.9 msyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_term_taxonomy_relationships" ("term_id", "taxonomy_id", "object_id") VALUES (9, 165, 4173)
10:06:38.6151.5 msyii\db\Command::querySELECT 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"=4490) AND ("t"."status" IN (2, 5, 1))
10:06:38.5541.5 msyii\db\Command::executeUPDATE "a57be577deb434"."tbl_projects" SET "is_verify"=TRUE WHERE "id"=4173
10:06:38.5581.5 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_sales_orders" WHERE ("created_at" >= '2026-06-05 00:00:00') AND ("created_at" <= '2026-06-05 23:59:59') AND ("serial_no" ILIKE '%XSDD-20260605-%') AND (LENGTH(serial_no) = 19) ORDER BY "serial_no" DESC
10:06:38.5621.4 msyii\db\Command::queryINSERT INTO "a57be577deb434"."tbl_erp_sales_orders" ("serial_no", "handler", "created_by", "amount", "wrote_date", "created_at", "verify_type", "status", "client_id", "project_id", "description", "extra", "number", "outbound_status") VALUES ('XSDD-20260605-00003', 1001, 1001, '176442', '2026-06-01', 'now()', 2, 1, 3311, 4173, NULL, '{"payment_collection_remind_ahead":"1 day","salesContractPaymentCollectionRemindReceivers":["1001"],"salesContractPaymentCollectionRemindDates":null}', '1', FALSE) RETURNING "id"
10:06:38.7331.3 msyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_erp_ticket_change_log_handlers" ("erp_ticket_change_log_id", "user_id") VALUES (2928, 1001)
10:06:38.7431.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_sales_outbound_products" WHERE "erp_sales_order_product_id"=2250
10:06:38.5551.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_project_change_logs" WHERE ("project_id"=4173) AND ("end_at" IS NULL) ORDER BY "id" DESC LIMIT 1
10:06:38.5741.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_project_change_logs" WHERE ("project_id"=4173) AND ("end_at" IS NULL) ORDER BY "id" DESC LIMIT 1
10:06:37.4951.1 msyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_project_product_types" ("project_id", "product_type_id", "name", "budget", "pct", "profit") VALUES (4173, 5, '安全设备', '88221', 10, '8822.1')
10:06:38.5781.1 msyii\db\Command::executeUPDATE "a57be577deb434"."tbl_sources" SET "project_status"=3 WHERE "project_id"=4173
10:06:38.7501.0 msyii\db\Command::queryINSERT INTO "global"."tbl_api_log" ("code", "schema", "user_id", "device_type", "url", "request", "response", "php_error", "time", "duration") VALUES (200, 'a57be577deb434', 1001, 5, 'vue/project/save-edit', '{"Projects":{"id":"4173","client_name":"\u5317\u4eac\u534e\u8fb0\u60a6\u79d1\u6280\u6709\u9650\u516c\u53f8","client_id":"3311","project_status":"3","project_progress":"3","profit":"8822.1","profit_pct":"10","bargain_date":"2026-06-01","project_title":"\u6d4b\u8bd5\u5de5\u5355\u4eba\u5de5\u6210\u672c\u95ee\u9898","from_contact_name":"","from_contact":"","salesForecast":"181","purchaseType":"165","opportunityFrom":"","contract_type":"1","comment":"","payment_collection_remind_ahead":"1 day","project_product_version_id":"1375","projectProductRels":{"12131":{"product_id":"1558","amount":"88221","total_amount":"88221","number":"1","description":"","hardware_from":"","hardware_to":"","maintenance_from":"","maintenance_to":"","software_from":"","software_to":"","supplier_id":""}},"projectContactPoints":"","projectContactPointRels":"","projectUsedClient":{"used_client":"3432","budget":"7000","profit":"8960","profit_pct":"128","projectUsedClientPaymentCollectionRemindReceivers":["1001"],"projectUsedClientPaymentCollectionRemindDates":[{"remind_date":"2026-06-02","amount":"7000","pct":"100"}],"remind_ahead":"1 day","projectUsedClientPayments":{"1":{"amount":"700.00","collected_date":"2026-06-02 00:00:00","description":"\u6d4b\u8bd5\u623f\u8d37\u9996\u4ed8","files":["32702"]}},"projectUsedClientInvoices":{"1":{"amount":"7000","from_date":"2026-06-02","description":"","attachmentFiles":["32703"],"files":["32704"]}}},"projectProductTypes":{"5":{"budget":"88221","profit":"8822.1","pct":"10"}},"projectArchitects":"","projectRemindReceivers":"","salesContractPaymentCollectionRemindReceivers":["1001"],"salesContractPaymentCollectionRemindDates":""},"web_access_token":"l4p3M_87vSdo8QF-blMLH4iPaepKw7vp"}', '{"code":2000,"result":"","status":1,"msg":[{"name":"success","success":"\u5546\u673a\u5df2\u88ab\u6210\u529f\u4fee\u6539","error":""}],"mod":0,"ip":"221.216.117.119","ua":"Mozilla\/5.0 (Macintosh; Intel Mac OS X 10.15; rv:151.0) Gecko\/20100101 Firefox\/151.0"}', FALSE, '2026-06-05 10:06:38', 1269068032) RETURNING "id"
10:06:38.7301.0 msyii\db\Command::queryINSERT INTO "a57be577deb434"."tbl_erp_ticket_change_logs" ("status", "ticket_type", "serial_no", "wrote_date", "description", "abstract", "amount", "client_id", "supplier_id", "contact_id", "user_id", "created_by", "created_at", "updated_at", "object_id", "verify_at") VALUES (2, 20007, 'XSDD-20260605-00003', '2026-06-01', NULL, NULL, '88221', 3311, NULL, NULL, NULL, 1001, '2026-06-05 10:06:37', '2026-06-05 10:06:37', 1714, '2026-06-05 10:06:37.493298+08') RETURNING "id"
10:06:37.5331.0 msyii\db\Command::queryINSERT INTO "a57be577deb434"."tbl_project_used_client_payment_collection_remind_receivers" ("project_used_client_id", "user_id") VALUES (326, 1001) RETURNING "id"
10:06:37.5580.9 msyii\db\Command::executeUPDATE "a57be577deb434"."tbl_clients" SET "updated_at"='now()' WHERE "id"=3311
10:06:38.5860.9 msyii\db\Command::queryINSERT INTO "a57be577deb434"."tbl_sales_contracts" ("contract_type", "client_id", "project_id", "from_project", "amount", "signed_at", "handler", "created_by", "build_by_project", "need_analysis", "serial_no", "erp_un_settle_amount") VALUES (1, 3311, 4173, 4173, '88221', '2026-06-01', 1001, 1001, TRUE, TRUE, '2026-06-05-001', '88221') RETURNING "id"
10:06:38.6380.9 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_project_status_logs" WHERE "project_id"=4173 ORDER BY "created_at" DESC
10:06:38.5640.9 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_sales_order_verify_rels" WHERE ("status"=0) AND ("erp_sales_order_id"=1714) ORDER BY "id"
10:06:37.5340.9 msyii\db\Command::queryINSERT INTO "a57be577deb434"."tbl_project_used_client_payment_collection_remind_dates" ("project_used_client_id", "remind_date", "amount", "pct") VALUES (326, '2026-06-02', 7000, 100) RETURNING "id"
10:06:38.5870.8 msyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('INSERT', 'app\models\SalesContracts', 4490, 'a:45:{s:2:"id";i:4490;s:9:"client_id";i:3311;s:9:"signed_at";s:10:"2026-06-01";s:6:"amount";s:5:"88221";s:7:"handler";i:1001;s:11:"description";N;s:10:"created_by";i:1001;s:10:"created_at";N;s:10:"updated_at";N;s:13:"contract_scan";N;s:12:"receipt_scan";N;s:13:"contract_type";i:1;s:10:"project_id";i:4173;s:10:"valid_date";N;s:11:"expire_date";N;s:3:"sla";N;s:12:"remind_ahead";N;s:19:"expire_remind_ahead";N;s:15:"expire_reminded";N;s:9:"serial_no";s:14:"2026-06-05-001";s:31:"payment_collection_remind_ahead";N;s:12:"from_project";i:4173;s:12:"receipt_date";N;s:11:"verify_date";N;s:13:"including_tax";N;s:16:"build_by_project";b:1;s:13:"need_analysis";b:1;s:9:"is_settle";N;s:10:"is_deliver";N;s:11:"is_outbound";N;s:18:"is_save_collection";N;s:18:"save_collection_at";N;s:9:"is_verify";N;s:8:"is_draft";N;s:17:"erp_settle_amount";N;s:20:"erp_un_settle_amount";s:5:"88221";s:28:"erp_payment_ticket_is_verify";N;s:28:"erp_collect_ticket_is_verify";N;s:30:"erp_cash_cost_ticket_is_verify";N;s:21:"erp_all_settle_amount";N;s:21:"receipt_scan_uploaded";N;s:20:"verify_scan_uploaded";N;s:22:"contract_scan_uploaded";N;s:14:"is_edit_verify";N;s:20:"is_chargeback_verify";N;}', '', 1001, '221.216.117.119')
10:06:38.5750.8 msyii\db\Command::executeUPDATE "a57be577deb434"."tbl_project_change_logs" SET "end_at"='now()' WHERE "id"=17860
10:06:38.7370.8 msyii\db\Command::queryINSERT 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 (1714, 1558, '1', '88221', '88221', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL) RETURNING "id"
10:06:38.7450.8 msyii\db\Command::executeUPDATE "a57be577deb434"."tbl_project_product_rels" SET "cost"=NULL, "total_cost"=NULL WHERE "erp_sales_order_product_id"=2250
10:06:38.6920.8 msyii\db\Command::executeUPDATE "a57be577deb434"."tbl_clients" SET "cooperate_count"=1 WHERE "id"=3311
10:06:38.7270.7 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_sales_orders" WHERE ("status" IN (2, 5)) AND ("project_id"=4173)
10:06:38.5850.7 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_sales_contracts" WHERE ("created_at" >= '2026-06-05 00:00:00') AND ("created_at" <= '2026-06-05 23:59:59') AND ("serial_no" ILIKE '%2026-06-05-%') AND (LENGTH(serial_no) = 14) ORDER BY "serial_no" DESC
10:06:37.5200.7 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_sales_contracts" WHERE "from_project"=4173
10:06:38.6250.7 msyii\db\Command::querySELECT 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"=4490) AND ("t"."status" IN (2, 5)) AND ("t"."is_payment_settle"=TRUE)
10:06:37.5510.7 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_project_used_client_invoices" WHERE "id"=1
10:06:38.5240.7 msyii\db\Command::queryINSERT INTO "a57be577deb434"."tbl_client_am_change_logs" ("client_id", "sales_rep", "start_from", "end_at") VALUES (3311, 1001, 'now()', NULL) RETURNING "id"
10:06:38.6300.7 msyii\db\Command::executeUPDATE "a57be577deb434"."tbl_sales_contracts" SET "erp_settle_amount"='0', "erp_un_settle_amount"='88221', "erp_all_settle_amount"='0' WHERE "id"=4490
10:06:38.7400.7 msyii\db\Command::executeUPDATE "a57be577deb434"."tbl_erp_sales_orders" SET "amount"='88221', "number"='1' WHERE "id"=1714
10:06:38.6040.7 msyii\db\Command::executeUPDATE "a57be577deb434"."tbl_sales_contracts" SET "payment_collection_remind_ahead"='1 day', "is_save_collection"=TRUE, "save_collection_at"='now()' WHERE "id"=4490
10:06:38.7460.6 msyii\db\Command::executeUPDATE "a57be577deb434"."tbl_erp_sales_orders" SET "is_used"=FALSE WHERE "id"=1714
10:06:38.6290.6 msyii\db\Command::querySELECT 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"=4490) AND ("t"."status" IN (1, 2, 5))
10:06:38.6340.6 msyii\db\Command::executeUPDATE "a57be577deb434"."tbl_projects" SET "collected"='0' WHERE "id"=4173
10:06:38.6260.6 msyii\db\Command::querySELECT 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"=4490) AND ("t"."status"=1))
10:06:38.6410.6 msyii\db\Command::querySELECT 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"=4490) AND ("t"."status" IN (2, 5, 1))
10:06:38.6270.6 msyii\db\Command::querySELECT 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"=4490) AND ("t"."status"=1))
10:06:38.6280.6 msyii\db\Command::querySELECT 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"=4490) AND ("t"."status" IN (1, 2, 5))
10:06:38.7410.6 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_sales_order_products" WHERE "erp_sales_order_id"=1714
10:06:37.4820.6 msyii\db\Command::querySELECT * FROM "global"."vw_user_login" WHERE "id"=1001
10:06:38.7230.6 msyii\db\Command::queryINSERT INTO "a57be577deb434"."tbl_client_am_change_logs" ("client_id", "sales_rep", "start_from", "end_at") VALUES (3311, 1001, 'now()', NULL) RETURNING "id"
10:06:38.5720.6 msyii\db\Command::queryINSERT INTO "a57be577deb434"."tbl_project_status_logs" ("project_id", "old_status", "new_status", "created_by", "created_at") VALUES (4173, 2, 3, 1001, 'now()') RETURNING "id"
10:06:38.7380.6 msyii\db\Command::executeUPDATE "a57be577deb434"."tbl_project_product_rels" SET "erp_sales_order_product_id"=2250 WHERE "id"=12131
10:06:38.5580.6 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_sales_contracts" WHERE "from_project"=4173
10:06:38.5840.5 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_sales_contracts" WHERE "from_project"=4173
10:06:38.5890.5 msyii\db\Command::executeUPDATE "a57be577deb434"."tbl_erp_sales_orders" SET "sales_contract_id"=4490 WHERE "id"=1714
10:06:38.6240.5 msyii\db\Command::querySELECT 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"=4490) AND ("t"."status" IN (2, 5))
10:06:37.5000.5 msyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\ProjectProductRels', 12131, 'a:0:{}', '', 1001, '221.216.117.119')
10:06:38.6470.5 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_sales_contract_payment_collection_remind_dates" WHERE ("contract_id"=4490) AND (amount > paid_amount) ORDER BY "remind_date"
10:06:37.4920.5 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_sales_orders" WHERE ("status" IN (2, 5)) AND ("project_id"=4173)
10:06:38.5730.5 msyii\db\Command::executeUPDATE "a57be577deb434"."tbl_projects" SET "project_status"=3, "change_status_to"=NULL, "is_verify"=FALSE WHERE "id"=4173
10:06:38.5530.5 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_sales_orders" WHERE ("status" IN (2, 5)) AND ("project_id"=4173)
10:06:38.5650.5 msyii\db\Command::executeUPDATE "a57be577deb434"."tbl_erp_sales_orders" SET "amount"='0', "number"='0', "next_verify_user"=NULL WHERE "id"=1714
10:06:38.7350.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
10:06:38.6230.4 msyii\db\Command::querySELECT 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"=4490) AND ("t"."is_payment_settle"=TRUE) AND ("t"."status" IN (2, 5))
10:06:38.6210.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"=3311
10:06:38.5820.4 msyii\db\Command::queryINSERT INTO "a57be577deb434"."tbl_comments" ("created_by", "object_type", "object_id", "is_system", "description", "description2") VALUES (1001, '1', 4173, TRUE, '刘人诚更新了一条商机状态明确需求变为商机成交', '') RETURNING "id"
10:06:38.6140.4 msyii\db\Command::querySELECT 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"=4490) AND ("t"."status" IN (2, 5, 1))
10:06:38.6220.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_sales_contract_payment_collection_remind_dates" WHERE ("contract_id"=4490) AND (amount > paid_amount) ORDER BY "remind_date"
10:06:38.7260.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_projects" WHERE "id"=4173
10:06:38.6890.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
10:06:38.6870.4 msyii\db\Command::queryINSERT INTO "a57be577deb434"."tbl_client_am_change_logs" ("client_id", "sales_rep", "start_from", "end_at") VALUES (3311, 1001, 'now()', NULL) RETURNING "id"
10:06:38.6370.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"=3311
10:06:38.7440.4 msyii\db\Command::executeUPDATE "a57be577deb434"."tbl_erp_sales_order_products" SET "outbound"='0' WHERE "id"=2250
10:06:38.6260.4 msyii\db\Command::querySELECT 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"=4490) AND ("t"."status"=1))
10:06:38.6060.4 msyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_contract_default_remind_users" ("user_id", "remind_user", "type") VALUES (1001, 1001, 1)
10:06:38.5670.4 msyii\db\Command::executeUPDATE "a57be577deb434"."tbl_erp_sales_orders" SET "status"=2, "verify_at"='now()', "amount"='88221', "updated_at"='now()' WHERE "id"=1714
10:06:38.6310.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"=3311
10:06:38.6900.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"=3311
10:06:38.6280.4 msyii\db\Command::querySELECT 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"=4490) AND ("t"."is_payment_settle"=TRUE) AND ("t"."status" IN (1, 2, 5))
10:06:38.6230.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_sales_contracts" WHERE "id"=4490
10:06:38.6460.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"=3311
10:06:38.7350.4 msyii\db\Command::queryINSERT INTO "a57be577deb434"."tbl_object_change_logs" ("act", "attribute", "object_id", "object_type", "created_by", "created_at", "new_value", "old_value", "description") VALUES (1, 'create', 1714, 20007, 1001, '2026-06-05 10:06:37', '{"id":1714,"serial_no":"XSDD-20260605-00003","from_date":null,"wrote_date":"2026-06-01","handler":1001,"client_id":3311,"purchase_contract_id":null,"project_id":4173,"sales_contract_id":null,"erp_store_id":null,"status":2,"erp_send_type_id":null,"abstract":null,"description":null,"verify_type":2,"next_verify_user":null,"next_stop_verify_user":null,"next_cancel_verify_user":null,"verify_at":"now()","stop_at":null,"cancel_at":null,"refuse_description":null,"is_resubmitted":false,"is_done":false,"number":"0","amount":88221,"created_by":1001,"stop_description":null,"extra":"{\"payment_collection_remind_ahead\":\"1 day\",\"salesContractPaymentCollectionRemindReceivers\":[\"1001\"],\"salesContractPaymentCollectionRemindDates\":null}","outbound_status":false,"is_used":false,"is_cancel":false,"is_settle":false,"is_old":false,"created_at":"2026-06-05 10:06:37","updated_at":"1970-01-01 08:00:00","print_times":null}', '{"id":1714,"serial_no":"XSDD-20260605-00003","from_date":null,"wrote_date":"2026-06-01","handler":1001,"client_id":3311,"purchase_contract_id":null,"project_id":4173,"sales_contract_id":null,"erp_store_id":null,"status":2,"erp_send_type_id":null,"abstract":null,"description":null,"verify_type":2,"next_verify_user":null,"next_stop_verify_user":null,"next_cancel_verify_user":null,"verify_at":"now()","stop_at":null,"cancel_at":null,"refuse_description":null,"is_resubmitted":false,"is_done":false,"number":"0","amount":88221,"created_by":1001,"stop_description":null,"extra":"{\"payment_collection_remind_ahead\":\"1 day\",\"salesContractPaymentCollectionRemindReceivers\":[\"1001\"],\"salesContractPaymentCollectionRemindDates\":null}","outbound_status":false,"is_used":false,"is_cancel":false,"is_settle":false,"is_old":false,"created_at":"2026-06-05 10:06:37","updated_at":"1970-01-01 08:00:00","print_times":null}', '{"d1":"\u5218\u4eba\u8bda","d2":"\u521b\u5efa\u4e86","d3":"\u9500\u552e\u8ba2\u5355\u7533\u8bf7","d4":[]}') RETURNING "id"
10:06:38.6470.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"=3311
10:06:37.5490.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_project_used_client_payment_collection_remind_dates" WHERE ("project_used_client_id"=326) AND (amount > paid_amount) ORDER BY "remind_date"
10:06:38.5760.4 msyii\db\Command::queryINSERT INTO "a57be577deb434"."tbl_project_change_logs" ("project_id", "project_status", "budget", "profit_pct", "collected", "start_from", "end_at") VALUES (4173, 3, '88221', '10', '0', 'now()', NULL) RETURNING "id"
10:06:37.5480.4 msyii\db\Command::executeUPDATE "a57be577deb434"."tbl_project_used_clients" SET "collected_plan"='7000' WHERE "id"=326
10:06:38.7290.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_sales_contracts" WHERE 0=1
10:06:37.4830.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
10:06:38.6390.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_sales_contracts" WHERE "id"=4490
10:06:38.6330.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_projects" WHERE "id"=4173
10:06:38.6130.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_sales_contracts" WHERE "id"=4490
10:06:38.7290.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_sales_orders" WHERE "id"=1714
10:06:38.5680.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_sales_orders" WHERE "id"=1714
10:06:38.6400.3 msyii\db\Command::querySELECT 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"=4490) AND ("t"."status" IN (2, 5, 1))
10:06:37.4930.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_project_product_types" WHERE "project_id"=4173
10:06:38.5600.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_project_product_rels" WHERE "project_id"=4173 ORDER BY "id"
10:06:37.5270.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
10:06:37.4960.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_project_product_rels" WHERE "project_id"=4173 ORDER BY "id"
10:06:38.6910.3 msyii\db\Command::querySELECT COUNT(*) FROM "a57be577deb434"."tbl_projects" WHERE ("project_status"=3) AND ("bargain_date" >= '2026-01-01 00:00:00') AND ("bargain_date" <= '2026-12-31 23:59:59') AND ("client_id"=3311)
10:06:37.4940.3 msyii\db\Command::executeDELETE FROM "a57be577deb434"."tbl_project_product_types" WHERE "project_id"=4173
10:06:38.6140.3 msyii\db\Command::executeUPDATE "a57be577deb434"."tbl_sales_contract_payment_collection_remind_dates" SET "paid_amount"='0', "status"=0, "overdue_days"=NULL WHERE "contract_id"=4490
10:06:38.6170.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_projects" WHERE "id"=4173
10:06:38.7480.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_sales_contracts" WHERE 0=1
10:06:38.6070.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"='1001'
10:06:38.5790.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"=3311
10:06:37.5460.3 msyii\db\Command::executeUPDATE "a57be577deb434"."tbl_project_used_client_payments" SET "paid_amount"='0' WHERE "project_used_client_id"=326
10:06:38.6170.3 msyii\db\Command::querySELECT SUM(amount) FROM "a57be577deb434"."tbl_sales_contract_payment_collection_remind_dates" WHERE "contract_id"=4490
10:06:38.5270.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"='3311'
10:06:37.4890.3 msyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_projects" WHERE ("client_id"='3311') AND ("project_title"='测试工单人工成本问题') AND ("id" != 4173))
10:06:38.5610.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_verify_processes" WHERE "id"=6
10:06:38.6400.3 msyii\db\Command::executeUPDATE "a57be577deb434"."tbl_sales_contract_payment_collection_remind_dates" SET "paid_amount"='0', "status"=0, "overdue_days"=NULL WHERE "contract_id"=4490
10:06:38.6420.3 msyii\db\Command::querySELECT SUM(amount) FROM "a57be577deb434"."tbl_sales_contract_payment_collection_remind_dates" WHERE "contract_id"=4490
10:06:38.6080.3 msyii\db\Command::executeDELETE FROM "a57be577deb434"."tbl_sales_contract_payment_collection_remind_receivers" WHERE "contract_id"=4490
10:06:37.5130.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"='3311'
10:06:37.5270.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"='3311'
10:06:38.6320.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_projects" WHERE "id"=4173
10:06:37.5140.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
10:06:38.6050.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"=3311
10:06:37.4880.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_term_taxonomies" WHERE ("term_id"=13) AND ("id" IN (1, 165, 181, 184, 189, 349, 410)) ORDER BY "sort"
10:06:38.6020.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
10:06:38.5880.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"=3311
10:06:37.5570.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"='3311'
10:06:38.5260.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
10:06:37.5210.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"=3432
10:06:38.5450.3 msyii\db\Command::queryINSERT INTO "a57be577deb434"."tbl_client_am_change_logs" ("client_id", "sales_rep", "start_from", "end_at") VALUES (3311, 1001, 'now()', NULL) RETURNING "id"
10:06:38.5830.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
10:06:38.5970.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"=3311
10:06:37.4850.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_projects" WHERE "id"='4173'
10:06:38.5270.3 msyii\db\Command::querySELECT COUNT(*) FROM "a57be577deb434"."tbl_projects" WHERE ("project_status"=3) AND ("bargain_date" >= '2026-01-01 00:00:00') AND ("bargain_date" <= '2026-12-31 23:59:59') AND ("client_id"=3311)
10:06:38.5940.3 msyii\db\Command::queryINSERT INTO "a57be577deb434"."tbl_object_change_logs" ("act", "attribute", "object_id", "object_type", "created_by", "created_at", "new_value", "old_value", "description") VALUES (1, 'create', 4490, 7, 1001, '2026-06-05 10:06:37', '{"id":4490,"client_id":3311,"signed_at":"2026-06-01","amount":"88221","handler":1001,"description":null,"created_by":1001,"created_at":"2026-06-05 10:06:37","updated_at":"2026-06-05 10:06:37","contract_scan":null,"receipt_scan":null,"contract_type":1,"project_id":4173,"valid_date":null,"expire_date":null,"sla":null,"remind_ahead":null,"expire_remind_ahead":null,"expire_reminded":false,"serial_no":"2026-06-05-001","payment_collection_remind_ahead":"00:00:00","from_project":4173,"receipt_date":null,"verify_date":null,"including_tax":true,"build_by_project":true,"need_analysis":true,"is_settle":false,"is_deliver":false,"is_outbound":false,"is_save_collection":false,"save_collection_at":null,"is_verify":false,"is_draft":false,"erp_settle_amount":null,"erp_un_settle_amount":"88221","erp_payment_ticket_is_verify":false,"erp_collect_ticket_is_verify":false,"erp_cash_cost_ticket_is_verify":false,"erp_all_settle_amount":"0","receipt_scan_uploaded":false,"verify_scan_uploaded":false,"contract_scan_uploaded":false,"is_edit_verify":false,"is_chargeback_verify":false}', '{"id":4490,"client_id":3311,"signed_at":"2026-06-01","amount":"88221","handler":1001,"description":null,"created_by":1001,"created_at":"2026-06-05 10:06:37","updated_at":"2026-06-05 10:06:37","contract_scan":null,"receipt_scan":null,"contract_type":1,"project_id":4173,"valid_date":null,"expire_date":null,"sla":null,"remind_ahead":null,"expire_remind_ahead":null,"expire_reminded":false,"serial_no":"2026-06-05-001","payment_collection_remind_ahead":"00:00:00","from_project":4173,"receipt_date":null,"verify_date":null,"including_tax":true,"build_by_project":true,"need_analysis":true,"is_settle":false,"is_deliver":false,"is_outbound":false,"is_save_collection":false,"save_collection_at":null,"is_verify":false,"is_draft":false,"erp_settle_amount":null,"erp_un_settle_amount":"88221","erp_payment_ticket_is_verify":false,"erp_collect_ticket_is_verify":false,"erp_cash_cost_ticket_is_verify":false,"erp_all_settle_amount":"0","receipt_scan_uploaded":false,"verify_scan_uploaded":false,"contract_scan_uploaded":false,"is_edit_verify":false,"is_chargeback_verify":false}', '{"d1":"\u5218\u4eba\u8bda","d2":"\u521b\u5efa\u4e86","d3":"\u9500\u552e\u5408\u540c","d4":[]}') RETURNING "id"
10:06:38.5950.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
10:06:37.4930.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
10:06:38.6420.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_projects" WHERE "id"=4173
10:06:38.5570.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"=3311
10:06:37.5500.3 msyii\db\Command::executeUPDATE "a57be577deb434"."tbl_project_used_client_payments" SET "paid_amount"='700' WHERE "id"=1
10:06:38.5980.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
10:06:37.5240.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
10:06:38.5790.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
10:06:38.5710.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"=3311
10:06:38.5680.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
10:06:38.6030.3 msyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_project_product_rels" WHERE "project_id"=4173 ORDER BY "id")
10:06:38.7240.3 msyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('INSERT', 'app\models\ClientAmChangeLogs', 199893, 'a:5:{s:2:"id";i:199893;s:9:"client_id";i:3311;s:9:"sales_rep";i:1001;s:10:"start_from";s:5:"now()";s:6:"end_at";N;}', '', 1001, '221.216.117.119')
10:06:37.5220.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"='3432'
10:06:38.5660.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
10:06:38.5960.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
10:06:38.6210.3 msyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\Projects', 4173, 'a:0:{}', '', 1001, '221.216.117.119')
10:06:38.7320.3 msyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('INSERT', 'app\models\ErpTicketChangeLogs', 2928, 'a:17:{s:2:"id";i:2928;s:9:"serial_no";s:19:"XSDD-20260605-00003";s:11:"ticket_type";i:20007;s:10:"wrote_date";s:10:"2026-06-01";s:6:"status";i:2;s:11:"supplier_id";N;s:9:"client_id";i:3311;s:8:"abstract";N;s:11:"description";N;s:9:"verify_at";s:29:"2026-06-05 10:06:37.493298+08";s:10:"created_by";i:1001;s:10:"created_at";s:19:"2026-06-05 10:06:37";s:10:"updated_at";s:19:"2026-06-05 10:06:37";s:10:"contact_id";N;s:7:"user_id";N;s:6:"amount";s:5:"88221";s:9:"object_id";i:1714;}', '', 1001, '221.216.117.119')
10:06:38.5260.3 msyii\db\Command::queryINSERT 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', 3311, 10, 4173, 1, 1001, '[4173]', '[4173]', '{"d1":"\u5218\u4eba\u8bda","d2":"\u66f4\u65b0\u4e86","d3":"\u5546\u673a","d4":["\u6d4b\u8bd5\u5de5\u5355\u4eba\u5de5\u6210\u672c\u95ee\u9898"]}') RETURNING "id"
10:06:38.5900.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_sales_contracts" WHERE "id"=4490
10:06:38.7280.3 msyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\ErpSalesOrders', 1714, 'a:0:{}', '', 1001, '221.216.117.119')
10:06:38.6020.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
10:06:38.7360.3 msyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('INSERT', 'app\models\ObjectChangeLogs', 641260, 'a:13:{s:2:"id";i:641260;s:9:"object_id";i:1714;s:11:"object_type";i:20007;s:9:"target_id";N;s:18:"target_object_type";N;s:3:"act";i:1;s:9:"attribute";s:6:"create";s:9:"old_value";s:918:"{"id":1714,"serial_no":"XSDD-20260605-00003","from_date":null,"wrote_date":"2026-06-01","handler":1001,"client_id":3311,"purchase_contract_id":null,"project_id":4173,"sales_contract_id":null,"erp_store_id":null,"status":2,"erp_send_type_id":null,"abstract":null,"description":null,"verify_type":2,"next_verify_user":null,"next_stop_verify_user":null,"next_cancel_verify_user":null,"verify_at":"now()","stop_at":null,"cancel_at":null,"refuse_description":null,"is_resubmitted":false,"is_done":false,"number":"0","amount":88221,"created_by":1001,"stop_description":null,"extra":"{\"payment_collection_remind_ahead\":\"1 day\",\"salesContractPaymentCollectionRemindReceivers\":[\"1001\"],\"salesContractPaymentCollectionRemindDates\":null}","outbound_status":false,"is_used":false,"is_cancel":false,"is_settle":false,"is_old":false,"created_at":"2026-06-05 10:06:37","updated_at":"1970-01-01 08:00:00","print_times":null}";s:9:"new_value";s:918:"{"id":1714,"serial_no":"XSDD-20260605-00003","from_date":null,"wrote_date":"2026-06-01","handler":1001,"client_id":3311,"purchase_contract_id":null,"project_id":4173,"sales_contract_id":null,"erp_store_id":null,"status":2,"erp_send_type_id":null,"abstract":null,"description":null,"verify_type":2,"next_verify_user":null,"next_stop_verify_user":null,"next_cancel_verify_user":null,"verify_at":"now()","stop_at":null,"cancel_at":null,"refuse_description":null,"is_resubmitted":false,"is_done":false,"number":"0","amount":88221,"created_by":1001,"stop_description":null,"extra":"{\"payment_collection_remind_ahead\":\"1 day\",\"salesContractPaymentCollectionRemindReceivers\":[\"1001\"],\"salesContractPaymentCollectionRemindDates\":null}","outbound_status":false,"is_used":false,"is_cancel":false,"is_settle":false,"is_old":false,"created_at":"2026-06-05 10:06:37","updated_at":"1970-01-01 08:00:00","print_times":null}";s:11:"description";s:105:"{"d1":"\u5218\u4eba\u8bda","d2":"\u521b\u5efa\u4e86","d3":"\u9500\u552e\u8ba2\u5355\u7533\u8bf7","d4":[]}";s:10:"created_by";i:1001;s:10:"created_at";s:19:"2026-06-05 10:06:37";s:9:"is_delete";N;}', '', 1001, '221.216.117.119')
10:06:38.6070.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
10:06:37.4880.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_term_taxonomy_relationships" WHERE "object_id"=4173
10:06:38.6890.3 msyii\db\Command::queryINSERT 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', 3311, 10, 4173, 1, 1001, '[4173]', '[4173]', '{"d1":"\u5218\u4eba\u8bda","d2":"\u66f4\u65b0\u4e86","d3":"\u5546\u673a","d4":["\u6d4b\u8bd5\u5de5\u5355\u4eba\u5de5\u6210\u672c\u95ee\u9898"]}') RETURNING "id"
10:06:38.7380.3 msyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('INSERT', 'app\models\ErpSalesOrderProducts', 2250, 'a:21:{s:2:"id";i:2250;s:18:"erp_sales_order_id";i:1714;s:12:"erp_store_id";N;s:10:"product_id";i:1558;s:11:"description";s:0:"";s:6:"number";i:1;s:8:"outbound";N;s:6:"amount";s:5:"88221";s:12:"total_amount";s:5:"88221";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, '221.216.117.119')
10:06:37.5130.3 msyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\Projects', 4173, 'a:0:{}', '', 1001, '221.216.117.119')
10:06:37.4990.3 msyii\db\Command::querySELECT "id" FROM "a57be577deb434"."tbl_project_product_rels" WHERE "project_id"=4173
10:06:38.5980.3 msyii\db\Command::queryINSERT INTO "a57be577deb434"."tbl_user_action_logs" ("act", "attribute", "object_id", "object_type", "target_id", "target_object_type", "created_by", "new_value", "old_value", "users", "description") VALUES (1, 'create', 4173, 1, 4490, 7, 1001, '4490', '4490', array[1001], '{"d1":"\u5218\u4eba\u8bda","d2":"\u521b\u5efa\u4e86","d3":"\u9500\u552e\u5408\u540c","d4":["\u5408\u540c\u7f16\u53f7:2026-06-05-001"]}') RETURNING "id"
10:06:38.5520.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_projects" WHERE "id"=4173
10:06:38.5810.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_projects" WHERE "id"=4173
10:06:37.4910.2 msyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001)
10:06:38.6030.2 msyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_user_action_logs" ("act", "attribute", "object_id", "object_type", "created_by", "created_at", "new_value", "old_value", "users", "description") VALUES (2, 'payment_collection_remind_ahead', 4173, 1, 1001, 'now()', '["\u63d0\u524d1\u5929"]', '["\u4e0d\u63d0\u9192"]', array[1001], '{"d1":"\u5218\u4eba\u8bda","d2":"\u66f4\u65b0\u4e86","d3":"\u6536\u6b3e\u63d0\u9192\u65f6\u95f4","d4":["\u4e0d\u63d0\u9192 <b>\u53d8\u4e3a<\/b> \u63d0\u524d1\u5929"]}')
10:06:37.5140.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_project_architects" WHERE "project_id"=4173
10:06:38.6120.2 msyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('INSERT', 'app\models\SalesContractPaymentCollectionRemindReceivers', 10152, 'a:3:{s:2:"id";i:10152;s:11:"contract_id";i:4490;s:7:"user_id";s:4:"1001";}', '', 1001, '221.216.117.119')
10:06:38.5660.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_sales_orders" WHERE "id"=1714
10:06:38.5950.2 msyii\db\Command::queryINSERT 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', 3311, 10, 4490, 7, 1001, '[4490]', '[4490]', '{"d1":"\u5218\u4eba\u8bda","d2":"\u521b\u5efa\u4e86","d3":"\u9500\u552e\u5408\u540c","d4":["\u5408\u540c\u7f16\u53f7:2026-06-05-001"]}') RETURNING "id"
10:06:38.7390.2 msyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\ProjectProductRels', 12131, 'a:1:{s:26:"erp_sales_order_product_id";i:2250;}', '', 1001, '221.216.117.119')
10:06:38.7470.2 msyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\ErpSalesOrders', 1714, 'a:0:{}', '', 1001, '221.216.117.119')
10:06:37.4990.2 msyii\db\Command::executeUPDATE "a57be577deb434"."tbl_project_product_rels" SET "product_id"=1558, "amount"='88221', "number"=1, "supplier_id"=NULL, "hardware_from"=NULL, "software_from"=NULL, "maintenance_from"=NULL, "hardware_to"=NULL, "software_to"=NULL, "maintenance_to"=NULL WHERE "id"=12131
10:06:38.7450.2 msyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\ErpSalesOrderProducts', 2250, 'a:0:{}', '', 1001, '221.216.117.119')
10:06:38.7240.2 msyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\Clients', 3311, 'a:0:{}', '', 1001, '221.216.117.119')
10:06:38.7410.2 msyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\ErpSalesOrders', 1714, 'a:2:{s:6:"amount";d:88221;s:6:"number";i:0;}', '', 1001, '221.216.117.119')
10:06:38.5710.2 msyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_user_action_logs" ("act", "attribute", "object_id", "object_type", "created_by", "created_at", "new_value", "old_value", "users", "description") VALUES (2, 'project_status', 4173, 1, 1001, 'now()', '["\u5546\u673a\u6210\u4ea4"]', '["\u660e\u786e\u9700\u6c42"]', array[1001], '{"d1":"\u5218\u4eba\u8bda","d2":"\u66f4\u65b0\u4e86","d3":"\u5546\u673a\u72b6\u6001","d4":["\u660e\u786e\u9700\u6c42 <b>\u53d8\u4e3a<\/b> \u5546\u673a\u6210\u4ea4"]}')
10:06:37.4900.2 msyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"='3311')
10:06:37.5340.2 msyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('INSERT', 'app\models\ProjectUsedClientPaymentCollectionRemindReceivers', 5, 'a:3:{s:2:"id";i:5;s:22:"project_used_client_id";i:326;s:7:"user_id";s:4:"1001";}', '', 1001, '221.216.117.119')
10:06:38.6880.2 msyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('INSERT', 'app\models\ClientAmChangeLogs', 199892, 'a:5:{s:2:"id";i:199892;s:9:"client_id";i:3311;s:9:"sales_rep";i:1001;s:10:"start_from";s:5:"now()";s:6:"end_at";N;}', '', 1001, '221.216.117.119')
10:06:38.5970.2 msyii\db\Command::queryINSERT 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', 4173, 1, 4490, 7, 1001, '[4490]', '[4490]', '{"d1":"\u5218\u4eba\u8bda","d2":"\u521b\u5efa\u4e86","d3":"\u9500\u552e\u5408\u540c","d4":["\u5408\u540c\u7f16\u53f7:2026-06-05-001"]}') RETURNING "id"
10:06:37.5150.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_term_taxonomies" WHERE ("term_id"=9) AND ("id" IN (1, 165, 181, 184, 189, 349, 410)) ORDER BY "sort"
10:06:38.6900.2 msyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('INSERT', 'app\models\ObjectChangeLogs', 641259, 'a:13:{s:2:"id";i:641259;s:9:"object_id";i:3311;s:11:"object_type";i:10;s:9:"target_id";i:4173;s:18:"target_object_type";i:1;s:3:"act";i:2;s:9:"attribute";s:6:"update";s:9:"old_value";s:6:"[4173]";s:9:"new_value";s:6:"[4173]";s:11:"description";s:143:"{"d1":"\u5218\u4eba\u8bda","d2":"\u66f4\u65b0\u4e86","d3":"\u5546\u673a","d4":["\u6d4b\u8bd5\u5de5\u5355\u4eba\u5de5\u6210\u672c\u95ee\u9898"]}";s:10:"created_by";i:1001;s:10:"created_at";N;s:9:"is_delete";N;}', '', 1001, '221.216.117.119')
10:06:38.6310.2 msyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\SalesContracts', 4490, 'a:0:{}', '', 1001, '221.216.117.119')
10:06:38.6370.2 msyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\Projects', 4173, 'a:0:{}', '', 1001, '221.216.117.119')
10:06:38.6460.2 msyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\Projects', 4173, 'a:0:{}', '', 1001, '221.216.117.119')
10:06:37.5320.2 msyii\db\Command::executeUPDATE "a57be577deb434"."tbl_project_used_clients" SET "used_client"=3432 WHERE "id"=326
10:06:38.5890.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_projects" WHERE "id"=4173
10:06:38.5810.2 msyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001)
10:06:37.5190.2 msyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_term_taxonomy_relationships" ("term_id", "taxonomy_id", "object_id") VALUES (13, 181, 4173)
10:06:38.5680.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_projects" WHERE "id"=4173
10:06:38.5700.2 msyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_object_change_logs" ("act", "attribute", "object_id", "object_type", "created_by", "created_at", "new_value", "old_value", "description") VALUES (2, 'project_status', 4173, 1, 1001, 'now()', '["\u5546\u673a\u6210\u4ea4"]', '["\u660e\u786e\u9700\u6c42"]', '{"d1":"\u5218\u4eba\u8bda","d2":"\u66f4\u65b0\u4e86","d3":"\u5546\u673a\u72b6\u6001","d4":["\u660e\u786e\u9700\u6c42 <b>\u53d8\u4e3a<\/b> \u5546\u673a\u6210\u4ea4"]}')
10:06:38.6050.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_projects" WHERE "id"=4173
10:06:37.4990.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_project_product_rels" WHERE "id"=12131
10:06:38.6070.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_sales_contract_payment_collection_remind_receivers" WHERE "contract_id"=4490
10:06:38.6080.2 msyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_object_change_logs" ("act", "attribute", "object_id", "object_type", "created_by", "created_at", "new_value", "old_value", "description") VALUES (2, 'salesContractPaymentCollectionRemindReceivers', 4490, 7, 1001, 'now()', '[["\u5218\u4eba\u8bda"]]', '[[]]', '{"d1":"\u5218\u4eba\u8bda","d2":"\u66f4\u65b0\u4e86","d3":"\u6536\u6b3e\u63d0\u9192\u4eba","d4":["(\u672a\u8bbe\u7f6e) <b>\u53d8\u4e3a<\/b> \u5218\u4eba\u8bda;"]}')
10:06:37.5470.2 msyii\db\Command::executeUPDATE "a57be577deb434"."tbl_project_used_client_payment_collection_remind_dates" SET "paid_amount"='0', "status"=0, "overdue_days"=NULL WHERE "project_used_client_id"=326
10:06:37.5320.2 msyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\ProjectUsedClients', 326, 'a:0:{}', '', 1001, '221.216.117.119')
10:06:37.5380.2 msyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\ProjectUsedClientPayments', 1, 'a:1:{s:14:"collected_date";s:19:"2026-06-02 00:00:00";}', '', 1001, '221.216.117.119')
10:06:38.5250.2 msyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('INSERT', 'app\models\ClientAmChangeLogs', 199890, 'a:5:{s:2:"id";i:199890;s:9:"client_id";i:3311;s:9:"sales_rep";i:1001;s:10:"start_from";s:5:"now()";s:6:"end_at";N;}', '', 1001, '221.216.117.119')
10:06:37.5480.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_project_used_client_payments" WHERE ("project_used_client_id"=326) AND (amount > paid_amount) ORDER BY "collected_date", "created_at"
10:06:38.6880.2 msyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\Clients', 3311, 'a:0:{}', '', 1001, '221.216.117.119')
10:06:37.5490.2 msyii\db\Command::executeUPDATE "a57be577deb434"."tbl_project_used_client_payment_collection_remind_dates" SET "paid_amount"='700' WHERE "id"=12
10:06:38.5950.2 msyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('INSERT', 'app\models\ObjectChangeLogs', 641254, 'a:13:{s:2:"id";i:641254;s:9:"object_id";i:4490;s:11:"object_type";i:7;s:9:"target_id";N;s:18:"target_object_type";N;s:3:"act";i:1;s:9:"attribute";s:6:"create";s:9:"old_value";s:1071:"{"id":4490,"client_id":3311,"signed_at":"2026-06-01","amount":"88221","handler":1001,"description":null,"created_by":1001,"created_at":"2026-06-05 10:06:37","updated_at":"2026-06-05 10:06:37","contract_scan":null,"receipt_scan":null,"contract_type":1,"project_id":4173,"valid_date":null,"expire_date":null,"sla":null,"remind_ahead":null,"expire_remind_ahead":null,"expire_reminded":false,"serial_no":"2026-06-05-001","payment_collection_remind_ahead":"00:00:00","from_project":4173,"receipt_date":null,"verify_date":null,"including_tax":true,"build_by_project":true,"need_analysis":true,"is_settle":false,"is_deliver":false,"is_outbound":false,"is_save_collection":false,"save_collection_at":null,"is_verify":false,"is_draft":false,"erp_settle_amount":null,"erp_un_settle_amount":"88221","erp_payment_ticket_is_verify":false,"erp_collect_ticket_is_verify":false,"erp_cash_cost_ticket_is_verify":false,"erp_all_settle_amount":"0","receipt_scan_uploaded":false,"verify_scan_uploaded":false,"contract_scan_uploaded":false,"is_edit_verify":false,"is_chargeback_verify":false}";s:9:"new_value";s:1071:"{"id":4490,"client_id":3311,"signed_at":"2026-06-01","amount":"88221","handler":1001,"description":null,"created_by":1001,"created_at":"2026-06-05 10:06:37","updated_at":"2026-06-05 10:06:37","contract_scan":null,"receipt_scan":null,"contract_type":1,"project_id":4173,"valid_date":null,"expire_date":null,"sla":null,"remind_ahead":null,"expire_remind_ahead":null,"expire_reminded":false,"serial_no":"2026-06-05-001","payment_collection_remind_ahead":"00:00:00","from_project":4173,"receipt_date":null,"verify_date":null,"including_tax":true,"build_by_project":true,"need_analysis":true,"is_settle":false,"is_deliver":false,"is_outbound":false,"is_save_collection":false,"save_collection_at":null,"is_verify":false,"is_draft":false,"erp_settle_amount":null,"erp_un_settle_amount":"88221","erp_payment_ticket_is_verify":false,"erp_collect_ticket_is_verify":false,"erp_cash_cost_ticket_is_verify":false,"erp_all_settle_amount":"0","receipt_scan_uploaded":false,"verify_scan_uploaded":false,"contract_scan_uploaded":false,"is_edit_verify":false,"is_chargeback_verify":false}";s:11:"description";s:93:"{"d1":"\u5218\u4eba\u8bda","d2":"\u521b\u5efa\u4e86","d3":"\u9500\u552e\u5408\u540c","d4":[]}";s:10:"created_by";i:1001;s:10:"created_at";s:19:"2026-06-05 10:06:37";s:9:"is_delete";N;}', '', 1001, '221.216.117.119')
10:06:37.5350.2 msyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('INSERT', 'app\models\ProjectUsedClientPaymentCollectionRemindDates', 12, 'a:9:{s:2:"id";i:12;s:22:"project_used_client_id";i:326;s:11:"remind_date";s:10:"2026-06-02";s:8:"reminded";N;s:6:"amount";i:7000;s:11:"paid_amount";N;s:12:"overdue_days";N;s:6:"status";N;s:3:"pct";i:100;}', '', 1001, '221.216.117.119')
10:06:37.4950.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_product_types" WHERE "id"=5
10:06:37.4910.2 msyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001)
10:06:37.5570.2 msyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_attachement_relationships" ("object_type", "object_id", "attachment_id") VALUES (115, 1, 32704)
10:06:37.5380.2 msyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_project_used_clients" WHERE "id"=326)
10:06:37.5150.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_term_taxonomy_relationships" WHERE "object_id"=4173
10:06:37.4970.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_products" WHERE "id"=1558
10:06:38.5660.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_sales_order_verify_rels" WHERE ("status"=0) AND ("erp_sales_order_id"=1714) ORDER BY "id"
10:06:37.5380.2 msyii\db\Command::executeUPDATE "a57be577deb434"."tbl_project_used_client_payments" SET "collected_date"='2026-06-02 00:00:00' WHERE "id"=1
10:06:37.4820.2 msyii\db\Connection::openOpening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta
10:06:37.5550.2 msyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_attachement_relationships" ("object_type", "object_id", "attachment_id") VALUES (114, 1, 32703)
10:06:38.5570.2 msyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\Projects', 4173, 'a:0:{}', '', 1001, '221.216.117.119')
10:06:37.4980.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_product_units" WHERE "id"=1
10:06:38.5960.2 msyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('INSERT', 'app\models\ObjectChangeLogs', 641255, 'a:13:{s:2:"id";i:641255;s:9:"object_id";i:3311;s:11:"object_type";i:10;s:9:"target_id";i:4490;s:18:"target_object_type";i:7;s:3:"act";i:1;s:9:"attribute";s:6:"create";s:9:"old_value";s:6:"[4490]";s:9:"new_value";s:6:"[4490]";s:11:"description";s:134:"{"d1":"\u5218\u4eba\u8bda","d2":"\u521b\u5efa\u4e86","d3":"\u9500\u552e\u5408\u540c","d4":["\u5408\u540c\u7f16\u53f7:2026-06-05-001"]}";s:10:"created_by";i:1001;s:10:"created_at";N;s:9:"is_delete";N;}', '', 1001, '221.216.117.119')
10:06:37.5480.2 msyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\ProjectUsedClients', 326, 'a:0:{}', '', 1001, '221.216.117.119')
10:06:37.4900.2 msyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_contract_types" WHERE "id"='1')
10:06:38.5770.2 msyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('INSERT', 'app\models\ProjectChangeLogs', 17861, 'a:8:{s:2:"id";i:17861;s:10:"project_id";i:4173;s:14:"project_status";i:3;s:6:"budget";s:5:"88221";s:10:"profit_pct";s:2:"10";s:9:"collected";s:1:"0";s:10:"start_from";s:5:"now()";s:6:"end_at";N;}', '', 1001, '221.216.117.119')
10:06:37.4980.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_products" WHERE "id"='1558'
10:06:37.5150.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_term_taxonomies" WHERE "id"=165
10:06:38.5630.2 msyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('INSERT', 'app\models\ErpSalesOrders', 1714, 'a:37:{s:2:"id";i:1714;s:9:"serial_no";s:19:"XSDD-20260605-00003";s:9:"from_date";N;s:10:"wrote_date";s:10:"2026-06-01";s:7:"handler";i:1001;s:9:"client_id";i:3311;s:20:"purchase_contract_id";N;s:10:"project_id";i:4173;s:17:"sales_contract_id";N;s:12:"erp_store_id";N;s:6:"status";i:1;s:16:"erp_send_type_id";N;s:8:"abstract";N;s:11:"description";N;s:11:"verify_type";s:1:"2";s:16:"next_verify_user";N;s:21:"next_stop_verify_user";N;s:23:"next_cancel_verify_user";N;s:9:"verify_at";N;s:7:"stop_at";N;s:9:"cancel_at";N;s:18:"refuse_description";N;s:14:"is_resubmitted";N;s:7:"is_done";N;s:6:"number";d:1;s:6:"amount";d:176442;s:10:"created_by";i:1001;s:16:"stop_description";N;s:5:"extra";s:149:"{"payment_collection_remind_ahead":"1 day","salesContractPaymentCollectionRemindReceivers":["1001"],"salesContractPaymentCollectionRemindDates":null}";s:15:"outbound_status";b:0;s:7:"is_used";N;s:9:"is_cancel";N;s:9:"is_settle";N;s:6:"is_old";N;s:10:"created_at";s:19:"1970-01-01 08:00:00";s:10:"updated_at";N;s:11:"print_times";N;}', '', 1001, '221.216.117.119')
10:06:38.5690.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_project_statuses" WHERE "id"=3
10:06:37.5230.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_project_used_client_payments" WHERE "project_used_client_id"=326
10:06:37.5500.2 msyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\ProjectUsedClientPaymentCollectionRemindDates', 12, 'a:1:{s:11:"paid_amount";d:700;}', '', 1001, '221.216.117.119')
10:06:37.5190.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_project_remind_receivers" WHERE "project_id"=4173
10:06:37.5210.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_project_used_clients" WHERE "project_id"=4173
10:06:37.5500.2 msyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\ProjectUsedClientPayments', 1, 'a:1:{s:11:"paid_amount";d:700;}', '', 1001, '221.216.117.119')
10:06:37.5190.2 msyii\db\Command::executeDELETE FROM "a57be577deb434"."tbl_term_taxonomy_relationships" WHERE ("object_id"=4173) AND ("term_id"=13)
10:06:37.5230.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_project_used_client_payment_collection_remind_dates" WHERE "project_used_client_id"=326
10:06:38.5970.2 msyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('INSERT', 'app\models\ObjectChangeLogs', 641256, 'a:13:{s:2:"id";i:641256;s:9:"object_id";i:4173;s:11:"object_type";i:1;s:9:"target_id";i:4490;s:18:"target_object_type";i:7;s:3:"act";i:1;s:9:"attribute";s:6:"create";s:9:"old_value";s:6:"[4490]";s:9:"new_value";s:6:"[4490]";s:11:"description";s:134:"{"d1":"\u5218\u4eba\u8bda","d2":"\u521b\u5efa\u4e86","d3":"\u9500\u552e\u5408\u540c","d4":["\u5408\u540c\u7f16\u53f7:2026-06-05-001"]}";s:10:"created_by";i:1001;s:10:"created_at";N;s:9:"is_delete";N;}', '', 1001, '221.216.117.119')
10:06:37.5180.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_term_taxonomies" WHERE "id"=181
10:06:37.5520.2 msyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\ProjectUsedClientInvoices', 1, 'a:0:{}', '', 1001, '221.216.117.119')
10:06:37.5360.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_project_used_client_payments" WHERE "id"=1
10:06:38.5650.2 msyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\ErpSalesOrders', 1714, 'a:2:{s:6:"amount";i:0;s:6:"number";i:0;}', '', 1001, '221.216.117.119')
10:06:38.5800.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_project_remind_receivers" WHERE "project_id"=4173
10:06:38.5450.2 msyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('INSERT', 'app\models\ClientAmChangeLogs', 199891, 'a:5:{s:2:"id";i:199891;s:9:"client_id";i:3311;s:9:"sales_rep";i:1001;s:10:"start_from";s:5:"now()";s:6:"end_at";N;}', '', 1001, '221.216.117.119')
10:06:38.5820.2 msyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('INSERT', 'app\models\Comments', 220726, 'a:11:{s:2:"id";i:220726;s:9:"object_id";i:4173;s:11:"object_type";s:1:"1";s:6:"parent";N;s:11:"description";s:66:"刘人诚更新了一条商机状态明确需求变为商机成交";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:0:"";}', '', 1001, '221.216.117.119')
10:06:38.6020.2 msyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_object_change_logs" ("act", "attribute", "object_id", "object_type", "created_by", "created_at", "new_value", "old_value", "description") VALUES (2, 'payment_collection_remind_ahead', 4173, 1, 1001, 'now()', '["\u63d0\u524d1\u5929"]', '["\u4e0d\u63d0\u9192"]', '{"d1":"\u5218\u4eba\u8bda","d2":"\u66f4\u65b0\u4e86","d3":"\u6536\u6b3e\u63d0\u9192\u65f6\u95f4","d4":["\u4e0d\u63d0\u9192 <b>\u53d8\u4e3a<\/b> \u63d0\u524d1\u5929"]}')
10:06:38.6040.2 msyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\SalesContracts', 4490, 'a:29:{s:11:"description";N;s:13:"contract_scan";N;s:12:"receipt_scan";N;s:10:"valid_date";N;s:11:"expire_date";N;s:3:"sla";N;s:12:"remind_ahead";N;s:19:"expire_remind_ahead";N;s:15:"expire_reminded";N;s:31:"payment_collection_remind_ahead";s:5:"1 day";s:12:"receipt_date";N;s:11:"verify_date";N;s:13:"including_tax";N;s:9:"is_settle";N;s:10:"is_deliver";N;s:11:"is_outbound";N;s:18:"save_collection_at";s:5:"now()";s:9:"is_verify";N;s:8:"is_draft";N;s:17:"erp_settle_amount";N;s:28:"erp_payment_ticket_is_verify";N;s:28:"erp_collect_ticket_is_verify";N;s:30:"erp_cash_cost_ticket_is_verify";N;s:21:"erp_all_settle_amount";N;s:21:"receipt_scan_uploaded";N;s:20:"verify_scan_uploaded";N;s:22:"contract_scan_uploaded";N;s:14:"is_edit_verify";N;s:20:"is_chargeback_verify";N;}', '', 1001, '221.216.117.119')
10:06:37.5510.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_project_used_client_payments" WHERE ("project_used_client_id"=326) AND (amount > paid_amount) ORDER BY "collected_date", "created_at"
10:06:38.5990.2 msyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('INSERT', 'app\models\UserActionLogs', 171941, 'a:15:{s:2:"id";i:171941;s:9:"object_id";i:4173;s:11:"object_type";i:1;s:9:"target_id";i:4490;s:18:"target_object_type";i:7;s:3:"act";i:1;s:9:"attribute";s:6:"create";s:9:"old_value";s:4:"4490";s:9:"new_value";s:4:"4490";s:5:"users";O:17:"yii\db\Expression":2:{s:10:"expression";s:11:"array[1001]";s:6:"params";a:0:{}}s:11:"description";s:134:"{"d1":"\u5218\u4eba\u8bda","d2":"\u521b\u5efa\u4e86","d3":"\u9500\u552e\u5408\u540c","d4":["\u5408\u540c\u7f16\u53f7:2026-06-05-001"]}";s:10:"created_by";i:1001;s:10:"created_at";N;s:9:"is_delete";N;s:9:"parent_id";N;}', '', 1001, '221.216.117.119')
10:06:38.5260.2 msyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('INSERT', 'app\models\ObjectChangeLogs', 641252, 'a:13:{s:2:"id";i:641252;s:9:"object_id";s:4:"3311";s:11:"object_type";i:10;s:9:"target_id";i:4173;s:18:"target_object_type";i:1;s:3:"act";i:2;s:9:"attribute";s:6:"update";s:9:"old_value";s:6:"[4173]";s:9:"new_value";s:6:"[4173]";s:11:"description";s:143:"{"d1":"\u5218\u4eba\u8bda","d2":"\u66f4\u65b0\u4e86","d3":"\u5546\u673a","d4":["\u6d4b\u8bd5\u5de5\u5355\u4eba\u5de5\u6210\u672c\u95ee\u9898"]}";s:10:"created_by";i:1001;s:10:"created_at";N;s:9:"is_delete";N;}', '', 1001, '221.216.117.119')
10:06:38.5760.2 msyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\ProjectChangeLogs', 17860, 'a:1:{s:6:"end_at";s:19:"1970-01-01 08:00:00";}', '', 1001, '221.216.117.119')
10:06:37.5520.2 msyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_project_used_clients" WHERE "id"=326)
10:06:38.5460.2 msyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\Clients', 3311, 'a:0:{}', '', 1001, '221.216.117.119')
10:06:38.5720.2 msyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('INSERT', 'app\models\ProjectStatusLogs', 4365, 'a:6:{s:2:"id";i:4365;s:10:"project_id";i:4173;s:10:"new_status";i:3;s:10:"old_status";i:2;s:10:"created_by";i:1001;s:10:"created_at";s:19:"1970-01-01 08:00:00";}', '', 1001, '221.216.117.119')
10:06:37.5010.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_project_contact_point_rels" WHERE "project_id"=4173
10:06:38.5670.2 msyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\ErpSalesOrders', 1714, 'a:3:{s:6:"status";i:1;s:9:"verify_at";s:5:"now()";s:6:"amount";d:88221;}', '', 1001, '221.216.117.119')
10:06:37.5310.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_project_used_client_invoices" WHERE "project_used_client_id"=326
10:06:37.5010.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_project_contact_points" WHERE "project_id"=4173
10:06:38.5250.2 msyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\Clients', 3311, 'a:0:{}', '', 1001, '221.216.117.119')
10:06:37.4900.2 msyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_project_progresses" WHERE "id"='3')
10:06:37.5190.1 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_term_taxonomies" WHERE "id"='181'
10:06:37.5460.1 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_project_used_clients" WHERE "id"=326
10:06:37.5160.1 msyii\db\Command::executeDELETE FROM "a57be577deb434"."tbl_term_taxonomy_relationships" WHERE ("object_id"=4173) AND ("term_id"=9)
10:06:37.5220.1 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_project_used_client_payment_collection_remind_receivers" WHERE "project_used_client_id"=326
10:06:38.5770.1 msyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\Projects', 4173, 'a:1:{s:14:"project_status";i:2;}', '', 1001, '221.216.117.119')
10:06:38.6060.1 msyii\db\Command::executeDELETE FROM "a57be577deb434"."tbl_contract_default_remind_users" WHERE ("user_id"=1001) AND ("type"=1)
10:06:37.4910.1 msyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_project_statuses" WHERE "id"='3')
10:06:37.5160.1 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_term_taxonomies" WHERE "id"='165'
10:06:37.5470.1 msyii\db\Command::querySELECT SUM(amount) FROM "a57be577deb434"."tbl_project_used_client_payment_collection_remind_dates" WHERE "project_used_client_id"=326
10:06:38.5700.1 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_project_statuses" WHERE "id"=3
10:06:38.5800.1 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_project_statuses" WHERE "id"=2
10:06:38.5830.1 msyii\db\Command::querySELECT "channel_id" FROM "global"."tbl_logins" WHERE (0=1) AND ("id" != 1001) AND (channel_id IS NOT NULL)
10:06:38.5700.1 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_project_statuses" WHERE "id"=2
10:06:37.5510.1 msyii\db\Command::querySELECT "id" FROM "a57be577deb434"."tbl_project_used_client_invoices" WHERE "project_used_client_id"=326
10:06:37.4980.1 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_product_units" WHERE "id"=1
10:06:38.5800.1 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_project_statuses" WHERE "id"=3
10:06:37.5360.1 msyii\db\Command::querySELECT "id" FROM "a57be577deb434"."tbl_project_used_client_payments" WHERE "project_used_client_id"=326
10:06:38.5690.1 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_project_statuses" WHERE "id"=2
10:06:37.5320.1 msyii\db\Command::executeDELETE FROM "a57be577deb434"."tbl_project_used_client_payment_collection_remind_receivers" WHERE "project_used_client_id"=326
10:06:37.5340.1 msyii\db\Command::executeDELETE FROM "a57be577deb434"."tbl_project_used_client_payment_collection_remind_dates" WHERE "project_used_client_id"=326
10:06:37.5460.1 msyii\db\Command::executeDELETE FROM "a57be577deb434"."tbl_project_used_client_payments" WHERE 0=1
10:06:37.5000.1 msyii\db\Command::executeDELETE FROM "a57be577deb434"."tbl_project_product_rels" WHERE 0=1
10:06:37.5570.1 msyii\db\Command::executeDELETE FROM "a57be577deb434"."tbl_project_used_client_invoices" WHERE 0=1