689b13f1603c8: POST https://beta.jinchangxiao.com/vue/purchase-contract/save-new at 2025-08-12 06:14:09 pm by 114.254.2.139
Database Queries
总计32条数据
| Time | Duration | Type | Query |
|---|---|---|---|
| 18:14:09.397 | 2.5 ms | SELECT | SELECT * FROM "global"."vw_user_login" WHERE "id"=1004 |
| 18:14:09.401 | 1.6 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1004 |
| 18:14:09.405 | 0.3 ms | SELECT | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1004) |
| 18:14:09.405 | 1.9 ms | INSERT | INSERT INTO "a57be577deb434"."tbl_purchase_contracts" ("amount", "created_by", "signed_at", "cost_type", "supplier_id", "is_draft", "handler", "contract_type", "serial_no", "description", "including_tax", "payment_collection_remind_ahead") VALUES ('0', 1004, '2025-08-12', 1, NULL, TRUE, NULL, NULL, '', '', TRUE, '0 day') RETURNING "id" |
| 18:14:09.408 | 1.0 ms | INSERT | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('INSERT', 'app\models\PurchaseContracts', 4085, 'a:29:{s:2:"id";i:4085;s:11:"supplier_id";s:0:"";s:13:"contract_type";s:0:"";s:9:"signed_at";s:10:"2025-08-12";s:6:"amount";s:1:"0";s:7:"handler";s:0:"";s:11:"description";s:0:"";s:13:"contract_scan";N;s:10:"created_by";i:1004;s:10:"created_at";N;s:10:"updated_at";N;s:9:"client_id";N;s:10:"project_id";N;s:9:"sales_rep";N;s:9:"serial_no";s:0:"";s:31:"payment_collection_remind_ahead";s:5:"0 day";s:13:"including_tax";s:1:"1";s:18:"is_save_collection";N;s:18:"save_collection_at";N;s:13:"is_chargeback";N;s:9:"cost_type";i:1;s:8:"is_draft";s:1:"1";s:9:"is_verify";N;s:9:"is_refuse";N;s:17:"erp_settle_amount";N;s:20:"erp_un_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;}', '', 1004, '114.254.2.139') |
| 18:14:09.409 | 2.0 ms | DELETE | DELETE FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=108) AND ("object_id"=4085) |
| 18:14:09.411 | 1.7 ms | DELETE | DELETE FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=111) AND ("object_id"=4085) |
| 18:14:09.413 | 0.3 ms | DELETE | DELETE FROM "a57be577deb434"."tbl_purchase_client_rels" WHERE "contract_id"=4085 |
| 18:14:09.413 | 0.3 ms | DELETE | DELETE FROM "a57be577deb434"."tbl_sales_supplier_rels" WHERE "purchase_id"=4085 |
| 18:14:09.414 | 0.4 ms | SELECT | SELECT "id" FROM "a57be577deb434"."tbl_purchase_contract_invoices" WHERE "contract_id"=4085 |
| 18:14:09.414 | 0.2 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_purchase_client_rels" WHERE "contract_id"=4085 |
| 18:14:09.414 | 0.1 ms | DELETE | DELETE FROM "a57be577deb434"."tbl_purchase_contract_invoices" WHERE 0=1 |
| 18:14:09.415 | 0.4 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_purchase_contracts" WHERE "id"=4085 |
| 18:14:09.415 | 0.9 ms | SELECT | SELECT SUM(r.amount) FROM "a57be577deb434"."tbl_erp_other_income_ticket_purchase_contract_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_other_income_tickets" "t" ON r.erp_other_income_ticket_id = t.id WHERE ("r"."purchase_contract_id"=4085) AND ("t"."status" IN (2, 5, 1)) |
| 18:14:09.416 | 0.6 ms | SELECT | SELECT SUM(r.amount) FROM "a57be577deb434"."tbl_erp_cash_cost_ticket_purchase_contract_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_cash_cost_tickets" "t" ON r.erp_cash_cost_ticket_id = t.id WHERE ("r"."purchase_contract_id"=4085) AND ("t"."status" IN (2, 5, 1)) |
| 18:14:09.417 | 0.8 ms | SELECT | 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"."purchase_contract_id"=4085) AND ("t"."status" IN (2, 5, 1)) |
| 18:14:09.418 | 0.7 ms | SELECT | 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"."purchase_contract_id"=4085) AND ("t"."status" IN (2, 5, 1)) |
| 18:14:09.419 | 0.3 ms | SELECT | SELECT EXISTS(SELECT "r".* FROM "a57be577deb434"."tbl_erp_cash_cost_ticket_purchase_contract_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_cash_cost_tickets" "t" ON r.erp_cash_cost_ticket_id = t.id WHERE ("r"."purchase_contract_id"=4085) AND ("t"."status"=1)) |
| 18:14:09.420 | 0.4 ms | SELECT | 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"."purchase_contract_id"=4085) AND ("t"."status"=1)) |
| 18:14:09.420 | 0.4 ms | SELECT | 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"."purchase_contract_id"=4085) AND ("t"."status"=1) |
| 18:14:09.421 | 0.9 ms | UPDATE | UPDATE "a57be577deb434"."tbl_purchase_contracts" SET "erp_settle_amount"='0', "erp_un_settle_amount"='0', "erp_collect_ticket_is_verify"=NULL WHERE "id"=4085 |
| 18:14:09.422 | 0.8 ms | INSERT | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\PurchaseContracts', 4085, 'a:0:{}', '', 1004, '114.254.2.139') |
| 18:14:09.423 | 0.4 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_erp_purchase_costs" WHERE "purchase_contract_id"=4085 |
| 18:14:09.423 | 0.2 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_purchase_contracts" WHERE "id"=4085 |
| 18:14:09.424 | 0.4 ms | UPDATE | UPDATE "a57be577deb434"."tbl_purchase_contract_payment_collection_remind_dates" SET "paid_amount"='0', "status"=0, "overdue_days"=NULL WHERE "contract_id"=4085 |
| 18:14:09.424 | 0.3 ms | SELECT | SELECT r.amount, t.created_at FROM "a57be577deb434"."tbl_erp_other_income_ticket_purchase_contract_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_other_income_tickets" "t" ON r.erp_other_income_ticket_id = t.id WHERE ("r"."purchase_contract_id"=4085) AND ("t"."status" IN (2, 5, 1)) |
| 18:14:09.425 | 0.3 ms | SELECT | SELECT r.amount, t.created_at FROM "a57be577deb434"."tbl_erp_cash_cost_ticket_purchase_contract_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_cash_cost_tickets" "t" ON r.erp_cash_cost_ticket_id = t.id WHERE ("r"."purchase_contract_id"=4085) AND ("t"."status" IN (2, 5, 1)) |
| 18:14:09.425 | 0.4 ms | SELECT | SELECT r.amount, t.created_at 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"."purchase_contract_id"=4085) AND ("t"."status" IN (2, 5, 1)) |
| 18:14:09.426 | 1.0 ms | INSERT | INSERT INTO "a57be577deb434"."tbl_object_change_logs" ("act", "attribute", "object_id", "object_type", "created_by", "created_at", "new_value", "old_value", "description") VALUES (1, 'create', 4085, 13, 1004, '2025-08-12 18:14:09', '{"id":4085,"supplier_id":null,"contract_type":null,"signed_at":"2025-08-12","amount":"0","handler":null,"description":"","contract_scan":null,"created_by":1004,"created_at":"2025-08-12 18:14:09","updated_at":"2025-08-12 18:14:09","client_id":null,"project_id":null,"sales_rep":null,"serial_no":"","payment_collection_remind_ahead":"00:00:00","including_tax":true,"is_save_collection":false,"save_collection_at":null,"is_chargeback":false,"cost_type":1,"is_draft":true,"is_verify":false,"is_refuse":false,"erp_settle_amount":0,"erp_un_settle_amount":0,"erp_payment_ticket_is_verify":false,"erp_collect_ticket_is_verify":null,"erp_cash_cost_ticket_is_verify":false}', '{"id":4085,"supplier_id":null,"contract_type":null,"signed_at":"2025-08-12","amount":"0","handler":null,"description":"","contract_scan":null,"created_by":1004,"created_at":"2025-08-12 18:14:09","updated_at":"2025-08-12 18:14:09","client_id":null,"project_id":null,"sales_rep":null,"serial_no":"","payment_collection_remind_ahead":"00:00:00","including_tax":true,"is_save_collection":false,"save_collection_at":null,"is_chargeback":false,"cost_type":1,"is_draft":true,"is_verify":false,"is_refuse":false,"erp_settle_amount":0,"erp_un_settle_amount":0,"erp_payment_ticket_is_verify":false,"erp_collect_ticket_is_verify":null,"erp_cash_cost_ticket_is_verify":false}', '{"d1":"\u4f0a\u5cfb\u8fb0","d2":"\u521b\u5efa\u4e86","d3":"\u91c7\u8d2d\u5408\u540c","d4":[]}') RETURNING "id" |
| 18:14:09.427 | 0.9 ms | INSERT | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('INSERT', 'app\models\ObjectChangeLogs', 553464, 'a:13:{s:2:"id";i:553464;s:9:"object_id";i:4085;s:11:"object_type";i:13;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:663:"{"id":4085,"supplier_id":null,"contract_type":null,"signed_at":"2025-08-12","amount":"0","handler":null,"description":"","contract_scan":null,"created_by":1004,"created_at":"2025-08-12 18:14:09","updated_at":"2025-08-12 18:14:09","client_id":null,"project_id":null,"sales_rep":null,"serial_no":"","payment_collection_remind_ahead":"00:00:00","including_tax":true,"is_save_collection":false,"save_collection_at":null,"is_chargeback":false,"cost_type":1,"is_draft":true,"is_verify":false,"is_refuse":false,"erp_settle_amount":0,"erp_un_settle_amount":0,"erp_payment_ticket_is_verify":false,"erp_collect_ticket_is_verify":null,"erp_cash_cost_ticket_is_verify":false}";s:9:"new_value";s:663:"{"id":4085,"supplier_id":null,"contract_type":null,"signed_at":"2025-08-12","amount":"0","handler":null,"description":"","contract_scan":null,"created_by":1004,"created_at":"2025-08-12 18:14:09","updated_at":"2025-08-12 18:14:09","client_id":null,"project_id":null,"sales_rep":null,"serial_no":"","payment_collection_remind_ahead":"00:00:00","including_tax":true,"is_save_collection":false,"save_collection_at":null,"is_chargeback":false,"cost_type":1,"is_draft":true,"is_verify":false,"is_refuse":false,"erp_settle_amount":0,"erp_un_settle_amount":0,"erp_payment_ticket_is_verify":false,"erp_collect_ticket_is_verify":null,"erp_cash_cost_ticket_is_verify":false}";s:11:"description";s:93:"{"d1":"\u4f0a\u5cfb\u8fb0","d2":"\u521b\u5efa\u4e86","d3":"\u91c7\u8d2d\u5408\u540c","d4":[]}";s:10:"created_by";i:1004;s:10:"created_at";s:19:"2025-08-12 18:14:09";s:9:"is_delete";N;}', '', 1004, '114.254.2.139') |
| 18:14:09.428 | 0.4 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_purchase_client_rels" WHERE "contract_id"=4085 ORDER BY "id" |
| 18:14:09.429 | 1.0 ms | INSERT | INSERT INTO "global"."tbl_api_log" ("code", "schema", "user_id", "device_type", "url", "request", "response", "php_error", "time") VALUES (200, 'a57be577deb434', 1004, 5, 'vue/purchase-contract/save-new', '{"PurchaseContracts":{"id":"","supplier_id":"","is_draft":"1","amount":"0","handler":"","contract_type":"","serial_no":"","signed_at":"2025-08-12","description":"","including_tax":"1","product_number":"0","product_amount":"0","purchaseContractProductRels":"","contractScans":"","receiptScans":"","purchaseClientRels":"","PurchaseContractInvoices":""},"web_access_token":"AidVpXYAKod5aJIX_4OSuCNwf6tmaemp"}', '{"code":2000,"result":{"id":4085},"status":1,"msg":[{"name":"success","success":"\u65b0\u91c7\u8d2d\u5408\u540c\u5df2\u521b\u5efa\u6210\u529f","error":""}],"mod":0}', FALSE, '2025-08-12 18:14:09') RETURNING "id" |