ConfigurationRequestLogsProfilingDatabaseAsset BundlesMailTimeline
689b044aa4947: POST https://beta.jinchangxiao.com/vue/setting/list-erp-account-caption at 2025-08-12 05:07:22 pm by 114.254.2.139

Performance Profiling

Total processing time: 85 ms; Peak memory: 5.417 MB. Show Profiling Timeline

总计41条数据
TimeDurationCategoryInfo
  
17:07:22.7374.3 msyii\db\Command::querySELECT sum(sci.amount) as amount, sum(CASE WHEN sci.is_match = true AND sci.need_match = true THEN sci.amount ELSE 0 END) as match_amount, sum(sci.excluding_tax) as excluding_tax, sum(sci.tax_amount) as tax_amount, sum(sub.un_match_number) as un_match_number FROM "a57be577deb434"."tbl_sales_contract_invoices" "sci" LEFT JOIN (SELECT sales_invoice_id, sum(sip.number - sip.outbound) as un_match_number FROM "a57be577deb434"."tbl_sales_invoice_products" "sip" LEFT JOIN "a57be577deb434"."tbl_sales_contract_invoices" "sci" ON sip.sales_invoice_id = sci.id WHERE ("sip"."need_match"=TRUE) AND (sci.cover_invoice_id IS NULL) GROUP BY "sales_invoice_id") "sub" ON sub.sales_invoice_id = sci.id WHERE ("sci"."is_draft"=FALSE) AND (("sci"."from_date" >= '2025-08-01 00:00:00') AND ("sci"."from_date" <= '2025-08-31 23:59:59'))
17:07:22.6963.9 msyii\db\Command::querySELECT SUM(t.amount) FROM "a57be577deb434"."tbl_purchase_contracts" "t" WHERE ("t"."created_at" < '2025-08-11 19:05:28') AND (t.is_draft = false) AND (t.is_refuse = false) AND (t.is_chargeback = false)
17:07:22.7013.1 msyii\db\Command::querySELECT SUM(t.amount) FROM "a57be577deb434"."tbl_erp_payment_tickets" "t" WHERE ("t"."status"=2) AND ("purchase_contract_id" IN (SELECT "t"."id" FROM "a57be577deb434"."tbl_purchase_contracts" "t" WHERE ("t"."created_at" < '2025-08-11 19:05:28') AND (t.is_draft = false) AND (t.is_refuse = false) AND (t.is_chargeback = false))) AND ("t"."created_at" < '2025-08-11 19:05:28')
17:07:22.7332.6 msyii\db\Command::querySELECT SUM(dt1.out_amount) FROM "a57be577deb434"."tbl_erp_cash_cost_tickets" "t" LEFT JOIN "a57be577deb434"."tbl_term_taxonomy_relationships" "dt1" ON dt1.object_id = t.id AND dt1.term_id = 18 AND dt1.object_type = 11 LEFT JOIN "a57be577deb434"."tbl_term_taxonomies" "tt" ON dt1.taxonomy_id = tt.id WHERE ("t"."status" IN (2, 5)) AND (t.settle_amount < t.amount) AND (tt.serial_no = '221106') AND ("t"."created_at" >= '2025-08-01 00:00:00') AND ("t"."created_at" <= '2025-08-31 23:59:59')
17:07:22.6772.5 msyii\db\Command::querySELECT * FROM "global"."vw_user_login" WHERE "id"=1001
17:07:22.7312.0 msyii\db\Command::querySELECT SUM(dt1.out_amount) FROM "a57be577deb434"."tbl_erp_cost_tickets" "t" LEFT JOIN "a57be577deb434"."tbl_term_taxonomy_relationships" "dt1" ON dt1.object_id = t.id AND dt1.term_id = 18 AND dt1.object_type = 9 LEFT JOIN "a57be577deb434"."tbl_term_taxonomies" "tt" ON dt1.taxonomy_id = tt.id WHERE ("t"."status" IN (2, 5)) AND (t.settle_amount < t.amount) AND (tt.serial_no = '221106') AND ("t"."created_at" >= '2025-08-01 00:00:00') AND ("t"."created_at" <= '2025-08-31 23:59:59')
17:07:22.6751.9 msyii\db\Connection::openOpening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta
17:07:22.7081.9 msyii\db\Command::querySELECT SUM(t.amount) FROM "a57be577deb434"."tbl_erp_purchase_orders" "t" WHERE ("t"."status"=2) AND ("t"."created_at" >= '2025-08-11 19:05:28')
17:07:22.7551.7 msyii\db\Command::queryINSERT INTO "global"."tbl_api_log" ("code", "schema", "user_id", "device_type", "url", "request", "response", "php_error", "time") VALUES (200, 'a57be577deb434', 1001, 5, 'vue/setting/list-erp-account-caption', '{"is_delete":"","type":"2","keyword":"","page":"1","web_access_token":"Hc6bcOPECvJmn-MxoPjAzgccBe0xyT-M"}', '{"code":2000,"result":{"list":[{"id":31,"parent_id":"","title":"\u77ed\u671f\u501f\u6b3e","serial_no":"2001","amount":"0","balance_amount":"0","actual_amount":0,"description":"","type":2,"sort":1,"can_create_child":true,"can_change_amount":false,"is_system":true,"is_delete":false,"is_current":true,"created_by":5016,"created_at":"2025-08-11 19:05:28","updated_at":"2025-08-11 19:05:28","child":[],"createdBy":{"id":5016,"key":5016,"name":"\u9ad8\u90e1\u9633","sex":"M","department_id":10,"avatar":{"id":35,"user_id":5016,"name":"\/files\/cdn\/a57be577deb434\/avatar\/404e0bcf-6382-3f63-b93b-4d936f35a4b2.png"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"can_update":false,"can_delete":false,"can_stop":true,"can_start":false,"bgcolor":"#89c541"},{"id":32,"parent_id":"","title":"\u4ee5\u516c\u5141\u4ef7\u503c\u8ba1\u91cf\u4e14\u5176\u53d8\u52a8\u8ba1\u5165\u5f53\u671f\u635f\u76ca\u7684\u91d1\u878d\u8d1f\u503a","serial_no":"2101","amount":"0","balance_amount":"0","actual_amount":"0","description":"","type":2,"sort":1,"can_create_child":true,"can_change_amount":false,"is_system":true,"is_delete":false,"is_current":true,"created_by":5016,"created_at":"2025-08-11 19:05:28","updated_at":"2025-08-11 19:05:28","child":[],"createdBy":{"id":5016,"key":5016,"name":"\u9ad8\u90e1\u9633","sex":"M","department_id":10,"avatar":{"id":35,"user_id":5016,"name":"\/files\/cdn\/a57be577deb434\/avatar\/404e0bcf-6382-3f63-b93b-4d936f35a4b2.png"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"can_update":false,"can_delete":false,"can_stop":true,"can_start":false,"bgcolor":"#89c541"},{"id":33,"parent_id":"","title":"\u884d\u751f\u91d1\u878d\u8d1f\u503a","serial_no":"2001","amount":"0","balance_amount":"0","actual_amount":0,"description":"","type":2,"sort":3,"can_create_child":true,"can_change_amount":false,"is_system":true,"is_delete":false,"is_current":true,"created_by":5016,"created_at":"2025-08-11 19:05:28","updated_at":"2025-08-11 19:05:28","child":[],"createdBy":{"id":5016,"key":5016,"name":"\u9ad8\u90e1\u9633","sex":"M","department_id":10,"avatar":{"id":35,"user_id":5016,"name":"\/files\/cdn\/a57be577deb434\/avatar\/404e0bcf-6382-3f63-b93b-4d936f35a4b2.png"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"can_update":false,"can_delete":false,"can_stop":true,"can_start":false,"bgcolor":"#89c541"},{"id":34,"parent_id":"","title":"\u5e94\u4ed8\u7968\u636e","serial_no":"2201","amount":"0","balance_amount":"0","actual_amount":"0","description":"","type":2,"sort":4,"can_create_child":true,"can_change_amount":false,"is_system":true,"is_delete":false,"is_current":true,"created_by":5016,"created_at":"2025-08-11 19:05:28","updated_at":"2025-08-11 19:05:28","child":[],"createdBy":{"id":5016,"key":5016,"name":"\u9ad8\u90e1\u9633","sex":"M","department_id":10,"avatar":{"id":35,"user_id":5016,"name":"\/files\/cdn\/a57be577deb434\/avatar\/404e0bcf-6382-3f63-b93b-4d936f35a4b2.png"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"can_update":false,"can_delete":false,"can_stop":true,"can_start":false,"bgcolor":"#89c541"},{"id":35,"parent_id":"","title":"\u5e94\u4ed8\u8d26\u6b3e","serial_no":"2202","amount":"0","balance_amount":"0","actual_amount":358557017.54,"description":"","type":2,"sort":5,"can_create_child":true,"can_change_amount":false,"is_system":true,"is_delete":false,"is_current":true,"created_by":5016,"created_at":"2025-08-11 19:05:28","updated_at":"2025-08-11 19:05:28","child":[],"createdBy":{"id":5016,"key":5016,"name":"\u9ad8\u90e1\u9633","sex":"M","department_id":10,"avatar":{"id":35,"user_id":5016,"name":"\/files\/cdn\/a57be577deb434\/avatar\/404e0bcf-6382-3f63-b93b-4d936f35a4b2.png"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"can_update":false,"can_delete":false,"can_stop":false,"can_start":false,"bgcolor":"#89c541"},{"id":36,"parent_id":"","title":"\u9884\u6536\u6b3e\u9879","serial_no":"2203","amount":"0","balance_amount":"0","actual_amount":"0","description":"","type":2,"sort":6,"can_create_child":true,"can_change_amount":false,"is_system":true,"is_delete":false,"is_current":true,"created_by":5016,"created_at":"2025-08-11 19:05:28","updated_at":"2025-08-11 19:05:28","child":[],"createdBy":{"id":5016,"key":5016,"name":"\u9ad8\u90e1\u9633","sex":"M","department_id":10,"avatar":{"id":35,"user_id":5016,"name":"\/files\/cdn\/a57be577deb434\/avatar\/404e0bcf-6382-3f63-b93b-4d936f35a4b2.png"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"can_update":false,"can_delete":false,"can_stop":true,"can_start":false,"bgcolor":"#89c541"},{"id":37,"parent_id":"","title":"\u5e94\u4ed8\u804c\u5de5\u85aa\u916c","serial_no":"2211","amount":"0","balance_amount":"0","actual_amount":0,"description":"","type":2,"sort":7,"can_create_child":true,"can_change_amount":false,"is_system":true,"is_delete":false,"is_current":true,"created_by":5016,"created_at":"2025-08-11 19:05:28","updated_at":"2025-08-11 19:05:28","child":[{"id":57,"parent_id":37,"title":"\u5e94\u4ed8\u804c\u5de5\u5de5\u8d44","serial_no":"221101","amount":"0","balance_amount":"0","actual_amount":0,"description":"","type":2,"sort":1,"can_create_child":false,"can_change_amount":false,"is_system":true,"is_delete":false,"is_current":true,"created_by":5016,"created_at":"2025-08-11 19:05:28","updated_at":"2025-08-11 19:05:28","createdBy":{"id":5016,"key":5016,"name":"\u9ad8\u90e1\u9633","sex":"M","department_id":10,"avatar":{"id":35,"user_id":5016,"name":"\/files\/cdn\/a57be577deb434\/avatar\/404e0bcf-6382-3f63-b93b-4d936f35a4b2.png"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"parent":{"id":37,"parent_id":"","title":"\u5e94\u4ed8\u804c\u5de5\u85aa\u916c","serial_no":"2211","amount":"0","balance_amount":"0","actual_amount":"0","description":"","type":2,"sort":7,"can_create_child":true,"can_change_amount":false,"is_system":true,"is_delete":false,"is_current":true,"created_by":5016,"created_at":"2025-08-11 19:05:28","updated_at":"2025-08-11 19:05:28"},"can_update":true,"can_delete":false,"can_stop":true,"can_start":false},{"id":58,"parent_id":37,"title":"\u5e94\u4ed8\u5956\u91d1","serial_no":"221102","amount":"0","balance_amount":"0","actual_amount":0,"description":"","type":2,"sort":2,"can_create_child":false,"can_change_amount":false,"is_system":true,"is_delete":false,"is_current":true,"created_by":5016,"created_at":"2025-08-11 19:05:28","updated_at":"2025-08-11 19:05:28","createdBy":{"id":5016,"key":5016,"name":"\u9ad8\u90e1\u9633","sex":"M","department_id":10,"avatar":{"id":35,"user_id":5016,"name":"\/files\/cdn\/a57be577deb434\/avatar\/404e0bcf-6382-3f63-b93b-4d936f35a4b2.png"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"parent":{"id":37,"parent_id":"","title":"\u5e94\u4ed8\u804c\u5de5\u85aa\u916c","serial_no":"2211","amount":"0","balance_amount":"0","actual_amount":"0","description":"","type":2,"sort":7,"can_create_child":true,"can_change_amount":false,"is_system":true,"is_delete":false,"is_current":true,"created_by":5016,"created_at":"2025-08-11 19:05:28","updated_at":"2025-08-11 19:05:28"},"can_update":true,"can_delete":false,"can_stop":true,"can_start":false},{"id":59,"parent_id":37,"title":"\u5e94\u4ed8\u793e\u4f1a\u4fdd\u9669\u8d39","serial_no":"221104","amount":"0","balance_amount":"0","actual_amount":0,"description":"","type":2,"sort":4,"can_create_child":false,"can_change_amount":false,"is_system":true,"is_delete":false,"is_current":true,"created_by":5016,"created_at":"2025-08-11 19:05:28","updated_at":"2025-08-11 19:05:28","createdBy":{"id":5016,"key":5016,"name":"\u9ad8\u90e1\u9633","sex":"M","department_id":10,"avatar":{"id":35,"user_id":5016,"name":"\/files\/cdn\/a57be577deb434\/avatar\/404e0bcf-6382-3f63-b93b-4d936f35a4b2.png"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"parent":{"id":37,"parent_id":"","title":"\u5e94\u4ed8\u804c\u5de5\u85aa\u916c","serial_no":"2211","amount":"0","balance_amount":"0","actual_amount":"0","description":"","type":2,"sort":7,"can_create_child":true,"can_change_amount":false,"is_system":true,"is_delete":false,"is_current":true,"created_by":5016,"created_at":"2025-08-11 19:05:28","updated_at":"2025-08-11 19:05:28"},"can_update":true,"can_delete":false,"can_stop":true,"can_start":false},{"id":60,"parent_id":37,"title":"\u5e94\u4ed8\u4f4f\u623f\u516c\u79ef\u91d1","serial_no":"221105","amount":"0","balance_amount":"0","actual_amount":0,"description":"","type":2,"sort":5,"can_create_child":false,"can_change_amount":false,"is_system":true,"is_delete":false,"is_current":true,"created_by":5016,"created_at":"2025-08-11 19:05:28","updated_at":"2025-08-11 19:05:28","createdBy":{"id":5016,"key":5016,"name":"\u9ad8\u90e1\u9633","sex":"M","department_id":10,"avatar":{"id":35,"user_id":5016,"name":"\/files\/cdn\/a57be577deb434\/avatar\/404e0bcf-6382-3f63-b93b-4d936f35a4b2.png"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"parent":{"id":37,"parent_id":"","title":"\u5e94\u4ed8\u804c\u5de5\u85aa\u916c","serial_no":"2211","amount":"0","balance_amount":"0","actual_amount":"0","description":"","type":2,"sort":7,"can_create_child":true,"can_change_amount":false,"is_system":true,"is_delete":false,"is_current":true,"created_by":5016,"created_at":"2025-08-11 19:05:28","updated_at":"2025-08-11 19:05:28"},"can_update":true,"can_delete":false,"can_stop":true,"can_start":false},{"id":61,"parent_id":37,"title":"\u5de5\u4f1a\u7ecf\u8d39","serial_no":"221106","amount":"0","balance_amount":"0","actual_amount":0,"description":"","type":2,"sort":6,"can_create_child":false,"can_change_amount":false,"is_system":true,"is_delete":false,"is_current":true,"created_by":5016,"created_at":"2025-08-11 19:05:28","updated_at":"2025-08-11 19:05:28","createdBy":{"id":5016,"key":5016,"name":"\u9ad8\u90e1\u9633","sex":"M","department_id":10,"avatar":{"id":35,"user_id":5016,"name":"\/files\/cdn\/a57be577deb434\/avatar\/404e0bcf-6382-3f63-b93b-4d936f35a4b2.png"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"parent":{"id":37,"parent_id":"","title":"\u5e94\u4ed8\u804c\u5de5\u85aa\u916c","serial_no":"2211","amount":"0","balance_amount":"0","actual_amount":"0","description":"","type":2,"sort":7,"can_create_child":true,"can_change_amount":false,"is_system":true,"is_delete":false,"is_current":true,"created_by":5016,"created_at":"2025-08-11 19:05:28","updated_at":"2025-08-11 19:05:28"},"can_update":true,"can_delete":false,"can_stop":true,"can_start":false}],"createdBy":{"id":5016,"key":5016,"name":"\u9ad8\u90e1\u9633","sex":"M","department_id":10,"avatar":{"id":35,"user_id":5016,"name":"\/files\/cdn\/a57be577deb434\/avatar\/404e0bcf-6382-3f63-b93b-4d936f35a4b2.png"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"can_update":false,"can_delete":false,"can_stop":true,"can_start":false,"bgcolor":"#89c541"},{"id":38,"parent_id":"","title":"\u5e94\u4ea4\u7a0e\u8d39","serial_no":"2221","amount":"0","balance_amount":"0","actual_amount":8774.61,"description":"","type":2,"sort":8,"can_create_child":true,"can_change_amount":false,"is_system":true,"is_delete":false,"is_current":true,"created_by":5016,"created_at":"2025-08-11 19:05:28","updated_at":"2025-08-11 19:05:28","child":[{"id":62,"parent_id":38,"title":"\u5e94\u4ea4\u589e\u503c\u7a0e","serial_no":"222101","amount":"0","balance_amount":"0","actual_amount":8774.61,"description":"","type":2,"sort":1,"can_create_child":false,"can_change_amount":false,"is_system":true,"is_delete":false,"is_current":true,"created_by":5016,"created_at":"2025-08-11 19:05:28","updated_at":"2025-08-11 19:05:28","createdBy":{"id":5016,"key":5016,"name":"\u9ad8\u90e1\u9633","sex":"M","department_id":10,"avatar":{"id":35,"user_id":5016,"name":"\/files\/cdn\/a57be577deb434\/avatar\/404e0bcf-6382-3f63-b93b-4d936f35a4b2.png"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"parent":{"id":38,"parent_id":"","title":"\u5e94\u4ea4\u7a0e\u8d39","serial_no":"2221","amount":"0","balance_amount":"0","actual_amount":"0","description":"","type":2,"sort":8,"can_create_child":true,"can_change_amount":false,"is_system":true,"is_delete":false,"is_current":true,"created_by":5016,"created_at":"2025-08-11 19:05:28","updated_at":"2025-08-11 19:05:28"},"can_update":true,"can_delete":false,"can_stop":false,"can_start":false},{"id":63,"parent_id":38,"title":"\u5e94\u4ea4\u4e2a\u7a0e","serial_no":"222102","amount":"0","balance_amount":"0","actual_amount":0,"description":"","type":2,"sort":1,"can_create_child":false,"can_change_amount":false,"is_system":true,"is_delete":false,"is_current":true,"created_by":5016,"created_at":"2025-08-11 19:05:28","updated_at":"2025-08-11 19:05:28","createdBy":{"id":5016,"key":5016,"name":"\u9ad8\u90e1\u9633","sex":"M","department_id":10,"avatar":{"id":35,"user_id":5016,"name":"\/files\/cdn\/a57be577deb434\/avatar\/404e0bcf-6382-3f63-b93b-4d936f35a4b2.png"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"parent":{"id":38,"parent_id":"","title":"\u5e94\u4ea4\u7a0e\u8d39","serial_no":"2221","amount":"0","balance_amount":"0","actual_amount":"0","description":"","type":2,"sort":8,"can_create_child":true,"can_change_amount":false,"is_system":true,"is_delete":false,"is_current":true,"created_by":5016,"created_at":"2025-08-11 19:05:28","updated_at":"2025-08-11 19:05:28"},"can_update":true,"can_delete":false,"can_stop":true,"can_start":false}],"createdBy":{"id":5016,"key":5016,"name":"\u9ad8\u90e1\u9633","sex":"M","department_id":10,"avatar":{"id":35,"user_id":5016,"name":"\/files\/cdn\/a57be577deb434\/avatar\/404e0bcf-6382-3f63-b93b-4d936f35a4b2.png"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"can_update":false,"can_delete":false,"can_stop":false,"can_start":false,"bgcolor":"#89c541"},{"id":39,"parent_id":"","title":"\u5176\u4ed6\u5e94\u4ed8\u6b3e","serial_no":"2241","amount":"0","balance_amount":"0","actual_amount":0,"description":"","type":2,"sort":9,"can_create_child":true,"can_change_amount":false,"is_system":true,"is_delete":false,"is_current":true,"created_by":5016,"created_at":"2025-08-11 19:05:28","updated_at":"2025-08-11 19:05:28","child":[],"createdBy":{"id":5016,"key":5016,"name":"\u9ad8\u90e1\u9633","sex":"M","department_id":10,"avatar":{"id":35,"user_id":5016,"name":"\/files\/cdn\/a57be577deb434\/avatar\/404e0bcf-6382-3f63-b93b-4d936f35a4b2.png"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"can_update":false,"can_delete":false,"can_stop":true,"can_start":false,"bgcolor":"#89c541"},{"id":40,"parent_id":"","title":"\u6301\u6709\u5f85\u552e\u8d1f\u503a","serial_no":"2245","amount":"0","balance_amount":"0","actual_amount":"0","description":"","type":2,"sort":10,"can_create_child":true,"can_change_amount":false,"is_system":true,"is_delete":false,"is_current":true,"created_by":5016,"created_at":"2025-08-11 19:05:28","updated_at":"2025-08-11 19:05:28","child":[],"createdBy":{"id":5016,"key":5016,"name":"\u9ad8\u90e1\u9633","sex":"M","department_id":10,"avatar":{"id":35,"user_id":5016,"name":"\/files\/cdn\/a57be577deb434\/avatar\/404e0bcf-6382-3f63-b93b-4d936f35a4b2.png"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"can_update":false,"can_delete":false,"can_stop":true,"can_start":false,"bgcolor":"#89c541"},{"id":41,"parent_id":"","title":"\u4e00\u5e74\u5185\u5230\u671f\u975e\u6d41\u52a8\u8d1f\u503a","serial_no":"2231","amount":"0","balance_amount":"0","actual_amount":"0","description":"","type":2,"sort":11,"can_create_child":true,"can_change_amount":false,"is_system":true,"is_delete":false,"is_current":true,"created_by":5016,"created_at":"2025-08-11 19:05:28","updated_at":"2025-08-11 19:05:28","child":[],"createdBy":{"id":5016,"key":5016,"name":"\u9ad8\u90e1\u9633","sex":"M","department_id":10,"avatar":{"id":35,"user_id":5016,"name":"\/files\/cdn\/a57be577deb434\/avatar\/404e0bcf-6382-3f63-b93b-4d936f35a4b2.png"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"can_update":false,"can_delete":false,"can_stop":true,"can_start":false,"bgcolor":"#89c541"},{"id":42,"parent_id":"","title":"\u5176\u4ed6\u6d41\u52a8\u8d1f\u503a","serial_no":"2242","amount":"0","balance_amount":"0","actual_amount":"0","description":"","type":2,"sort":12,"can_create_child":true,"can_change_amount":false,"is_system":true,"is_delete":false,"is_current":true,"created_by":5016,"created_at":"2025-08-11 19:05:28","updated_at":"2025-08-11 19:05:28","child":[],"createdBy":{"id":5016,"key":5016,"name":"\u9ad8\u90e1\u9633","sex":"M","department_id":10,"avatar":{"id":35,"user_id":5016,"name":"\/files\/cdn\/a57be577deb434\/avatar\/404e0bcf-6382-3f63-b93b-4d936f35a4b2.png"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"can_update":false,"can_delete":false,"can_stop":true,"can_start":false,"bgcolor":"#89c541"},{"id":43,"parent_id":"","title":"\u957f\u671f\u501f\u6b3e","serial_no":"2501","amount":"0","balance_amount":"0","actual_amount":0,"description":"","type":2,"sort":13,"can_create_child":true,"can_change_amount":false,"is_system":true,"is_delete":false,"is_current":false,"created_by":5016,"created_at":"2025-08-11 19:05:28","updated_at":"2025-08-11 19:05:28","child":[],"createdBy":{"id":5016,"key":5016,"name":"\u9ad8\u90e1\u9633","sex":"M","department_id":10,"avatar":{"id":35,"user_id":5016,"name":"\/files\/cdn\/a57be577deb434\/avatar\/404e0bcf-6382-3f63-b93b-4d936f35a4b2.png"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"can_update":false,"can_delete":false,"can_stop":true,"can_start":false,"bgcolor":"#89c541"},{"id":44,"parent_id":"","title":"\u5e94\u4ed8\u503a\u5238","serial_no":"2502","amount":"0","balance_amount":"0","actual_amount":0,"description":"","type":2,"sort":14,"can_create_child":true,"can_change_amount":false,"is_system":true,"is_delete":false,"is_current":false,"created_by":5016,"created_at":"2025-08-11 19:05:28","updated_at":"2025-08-11 19:05:28","child":[{"id":64,"parent_id":44,"title":"\u4f18\u5148\u80a1","serial_no":"250201","amount":"0","balance_amount":"0","actual_amount":"0","description":"","type":2,"sort":1,"can_create_child":false,"can_change_amount":false,"is_system":true,"is_delete":false,"is_current":false,"created_by":5016,"created_at":"2025-08-11 19:05:28","updated_at":"2025-08-11 19:05:28","createdBy":{"id":5016,"key":5016,"name":"\u9ad8\u90e1\u9633","sex":"M","department_id":10,"avatar":{"id":35,"user_id":5016,"name":"\/files\/cdn\/a57be577deb434\/avatar\/404e0bcf-6382-3f63-b93b-4d936f35a4b2.png"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"parent":{"id":44,"parent_id":"","title":"\u5e94\u4ed8\u503a\u5238","serial_no":"2502","amount":"0","balance_amount":"0","actual_amount":"0","description":"","type":2,"sort":14,"can_create_child":true,"can_change_amount":false,"is_system":true,"is_delete":false,"is_current":false,"created_by":5016,"created_at":"2025-08-11 19:05:28","updated_at":"2025-08-11 19:05:28"},"can_update":true,"can_delete":false,"can_stop":true,"can_start":false},{"id":65,"parent_id":44,"title":"\u6c38\u7eed\u503a","serial_no":"250202","amount":"0","balance_amount":"0","actual_amount":"0","description":"","type":2,"sort":2,"can_create_child":false,"can_change_amount":false,"is_system":true,"is_delete":false,"is_current":false,"created_by":5016,"created_at":"2025-08-11 19:05:28","updated_at":"2025-08-11 19:05:28","createdBy":{"id":5016,"key":5016,"name":"\u9ad8\u90e1\u9633","sex":"M","department_id":10,"avatar":{"id":35,"user_id":5016,"name":"\/files\/cdn\/a57be577deb434\/avatar\/404e0bcf-6382-3f63-b93b-4d936f35a4b2.png"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"parent":{"id":44,"parent_id":"","title":"\u5e94\u4ed8\u503a\u5238","serial_no":"2502","amount":"0","balance_amount":"0","actual_amount":"0","description":"","type":2,"sort":14,"can_create_child":true,"can_change_amount":false,"is_system":true,"is_delete":false,"is_current":false,"created_by":5016,"created_at":"2025-08-11 19:05:28","updated_at":"2025-08-11 19:05:28"},"can_update":true,"can_delete":false,"can_stop":true,"can_start":false}],"createdBy":{"id":5016,"key":5016,"name":"\u9ad8\u90e1\u9633","sex":"M","department_id":10,"avatar":{"id":35,"user_id":5016,"name":"\/files\/cdn\/a57be577deb434\/avatar\/404e0bcf-6382-3f63-b93b-4d936f35a4b2.png"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"can_update":false,"can_delete":false,"can_stop":true,"can_start":false,"bgcolor":"#89c541"},{"id":45,"parent_id":"","title":"\u957f\u671f\u5e94\u4ed8\u6b3e","serial_no":"2701","amount":"0","balance_amount":"0","actual_amount":"0","description":"","type":2,"sort":15,"can_create_child":true,"can_change_amount":false,"is_system":true,"is_delete":false,"is_current":false,"created_by":5016,"created_at":"2025-08-11 19:05:28","updated_at":"2025-08-11 19:05:28","child":[],"createdBy":{"id":5016,"key":5016,"name":"\u9ad8\u90e1\u9633","sex":"M","department_id":10,"avatar":{"id":35,"user_id":5016,"name":"\/files\/cdn\/a57be577deb434\/avatar\/404e0bcf-6382-3f63-b93b-4d936f35a4b2.png"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"can_update":false,"can_delete":false,"can_stop":true,"can_start":false,"bgcolor":"#89c541"},{"id":46,"parent_id":"","title":"\u9884\u8ba1\u8d1f\u503a","serial_no":"2801","amount":"0","balance_amount":"0","actual_amount":"0","description":"","type":2,"sort":16,"can_create_child":true,"can_change_amount":false,"is_system":true,"is_delete":false,"is_current":false,"created_by":5016,"created_at":"2025-08-11 19:05:28","updated_at":"2025-08-11 19:05:28","child":[],"createdBy":{"id":5016,"key":5016,"name":"\u9ad8\u90e1\u9633","sex":"M","department_id":10,"avatar":{"id":35,"user_id":5016,"name":"\/files\/cdn\/a57be577deb434\/avatar\/404e0bcf-6382-3f63-b93b-4d936f35a4b2.png"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"can_update":false,"can_delete":false,"can_stop":true,"can_start":false,"bgcolor":"#89c541"},{"id":47,"parent_id":"","title":"\u9012\u5ef6\u6536\u76ca","serial_no":"2401","amount":"0","balance_amount":"0","actual_amount":"0","description":"","type":2,"sort":17,"can_create_child":true,"can_change_amount":false,"is_system":true,"is_delete":false,"is_current":false,"created_by":5016,"created_at":"2025-08-11 19:05:28","updated_at":"2025-08-11 19:05:28","child":[],"createdBy":{"id":5016,"key":5016,"name":"\u9ad8\u90e1\u9633","sex":"M","department_id":10,"avatar":{"id":35,"user_id":5016,"name":"\/files\/cdn\/a57be577deb434\/avatar\/404e0bcf-6382-3f63-b93b-4d936f35a4b2.png"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"can_update":false,"can_delete":false,"can_stop":true,"can_start":false,"bgcolor":"#89c541"},{"id":48,"parent_id":"","title":"\u9012\u5ef6\u6240\u5f97\u7a0e\u8d1f\u503a","serial_no":"2401","amount":"0","balance_amount":"0","actual_amount":"0","description":"","type":2,"sort":18,"can_create_child":true,"can_change_amount":false,"is_system":true,"is_delete":false,"is_current":false,"created_by":5016,"created_at":"2025-08-11 19:05:28","updated_at":"2025-08-11 19:05:28","child":[],"createdBy":{"id":5016,"key":5016,"name":"\u9ad8\u90e1\u9633","sex":"M","department_id":10,"avatar":{"id":35,"user_id":5016,"name":"\/files\/cdn\/a57be577deb434\/avatar\/404e0bcf-6382-3f63-b93b-4d936f35a4b2.png"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"can_update":false,"can_delete":false,"can_stop":true,"can_start":false,"bgcolor":"#89c541"},{"id":49,"parent_id":"","title":"\u5176\u4ed6\u975e\u6d41\u52a8\u8d1f\u503a","serial_no":"2503","amount":"0","balance_amount":"0","actual_amount":"0","description":"","type":2,"sort":19,"can_create_child":true,"can_change_amount":false,"is_system":true,"is_delete":false,"is_current":false,"created_by":5016,"created_at":"2025-08-11 19:05:28","updated_at":"2025-08-11 19:05:28","child":[],"createdBy":{"id":5016,"key":5016,"name":"\u9ad8\u90e1\u9633","sex":"M","department_id":10,"avatar":{"id":35,"user_id":5016,"name":"\/files\/cdn\/a57be577deb434\/avatar\/404e0bcf-6382-3f63-b93b-4d936f35a4b2.png"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"can_update":false,"can_delete":false,"can_stop":true,"can_start":false,"bgcolor":"#89c541"}],"can_create":true,"pagenation":{"totalcount":19,"thispage":1,"pagesize":-1}},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}],"mod":0}', FALSE, '2025-08-12 17:07:22') RETURNING "id"
17:07:22.7231.6 msyii\db\Command::querySELECT SUM(t.amount - t.settle_amount) FROM "a57be577deb434"."tbl_erp_social_insurances" "t" WHERE ("t"."status"=2) AND ("t"."settle_month" >= '2025-08-01 00:00:00') AND ("t"."settle_month" <= '2025-08-31 23:59:59')
17:07:22.6811.6 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
17:07:22.6931.6 msyii\db\Command::querySELECT SUM(t.amount - t.settle_amount) FROM "a57be577deb434"."tbl_erp_other_payment_tickets" "t" WHERE ("t"."status"=2) AND ("t"."ticket_type"=3) AND ("t"."created_at" >= '2025-08-01 00:00:00') AND ("t"."created_at" <= '2025-08-31 23:59:59')
17:07:22.7441.6 msyii\db\Command::querySELECT count(pci.id) as count, sum(pci.amount) as amount, sum(pci.excluding_tax) as excluding_tax, sum(pci.tax_amount) as tax_amount FROM "a57be577deb434"."tbl_purchase_contract_invoices" "pci" WHERE ("pci"."is_verify"=TRUE) AND ("pci"."is_draft"=FALSE) AND (("pci"."verify_at" >= '2025-08-01 00:00:00') AND ("pci"."verify_at" <= '2025-08-31 23:59:59'))
17:07:22.7491.6 msyii\db\Command::querySELECT sum(sci.amount) as amount, sum(CASE WHEN sci.is_match = true AND sci.need_match = true THEN sci.amount ELSE 0 END) as match_amount, sum(sci.excluding_tax) as excluding_tax, sum(sci.tax_amount) as tax_amount, sum(sub.un_match_number) as un_match_number FROM "a57be577deb434"."tbl_sales_contract_invoices" "sci" LEFT JOIN (SELECT sales_invoice_id, sum(sip.number - sip.outbound) as un_match_number FROM "a57be577deb434"."tbl_sales_invoice_products" "sip" LEFT JOIN "a57be577deb434"."tbl_sales_contract_invoices" "sci" ON sip.sales_invoice_id = sci.id WHERE ("sip"."need_match"=TRUE) AND (sci.cover_invoice_id IS NULL) GROUP BY "sales_invoice_id") "sub" ON sub.sales_invoice_id = sci.id WHERE ("sci"."is_draft"=FALSE) AND (("sci"."from_date" >= '2025-08-01 00:00:00') AND ("sci"."from_date" <= '2025-08-31 23:59:59'))
17:07:22.7141.2 msyii\db\Command::querySELECT SUM(t.amount) FROM "a57be577deb434"."tbl_erp_purchase_returns" "t" WHERE "t"."status"=2
17:07:22.6841.0 msyii\db\Command::querySELECT COUNT(*) FROM (SELECT * FROM "a57be577deb434"."tbl_erp_account_captions" WHERE ("type"='2') AND (parent_id is null) ORDER BY "is_delete", "sort", "id") "c"
17:07:22.6870.7 msyii\db\Command::querySELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=5016)
17:07:22.7100.7 msyii\db\Command::querySELECT SUM(t.amount) FROM "a57be577deb434"."tbl_erp_purchase_inbounds" "t" WHERE "t"."status"=2
17:07:22.7200.7 msyii\db\Command::querySELECT SUM(t.amount - t.settle_amount) FROM "a57be577deb434"."tbl_erp_wage_prizes" "t" WHERE ("t"."status"=2) AND ("t"."settle_month" >= '2025-08-01 00:00:00') AND ("t"."settle_month" <= '2025-08-31 23:59:59')
17:07:22.7160.6 msyii\db\Command::querySELECT SUM(t.amount - t.settle_amount) FROM "a57be577deb434"."tbl_erp_wage_tickets" "t" WHERE ("t"."status"=2) AND ("t"."settle_month" >= '2025-08-01 00:00:00') AND ("t"."settle_month" <= '2025-08-31 23:59:59')
17:07:22.7480.6 msyii\db\Command::querySELECT SUM(t.amount) FROM "a57be577deb434"."tbl_erp_personal_taxs" "t" WHERE ("t"."status"=2) AND ("t"."created_at" <= '2025-08-11')
17:07:22.7270.5 msyii\db\Command::querySELECT SUM(t.amount - t.settle_amount) FROM "a57be577deb434"."tbl_erp_provident_funds" "t" WHERE ("t"."status"=2) AND ("t"."settle_month" >= '2025-08-01 00:00:00') AND ("t"."settle_month" <= '2025-08-31 23:59:59')
17:07:22.7150.5 msyii\db\Command::querySELECT SUM(t.amount) FROM "a57be577deb434"."tbl_erp_payment_tickets" "t" WHERE ("t"."status"=2) AND ("t"."created_at" >= '2025-08-11 19:05:28')
17:07:22.7510.5 msyii\db\Command::querySELECT count(pci.id) as count, sum(pci.amount) as amount, sum(pci.excluding_tax) as excluding_tax, sum(pci.tax_amount) as tax_amount FROM "a57be577deb434"."tbl_purchase_contract_invoices" "pci" WHERE ("pci"."is_verify"=TRUE) AND ("pci"."is_draft"=FALSE) AND (("pci"."verify_at" >= '2025-08-01 00:00:00') AND ("pci"."verify_at" <= '2025-08-31 23:59:59'))
17:07:22.7420.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_tax_datas" "td" WHERE ("td"."date" >= '2025-08-01 00:00:00') AND ("td"."date" <= '2025-08-31 23:59:59')
17:07:22.6850.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_account_captions" WHERE ("type"='2') AND (parent_id is null) ORDER BY "is_delete", "sort", "id"
17:07:22.6880.4 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_departments" WHERE "id"=10
17:07:22.6860.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_account_captions" WHERE "parent_id" IN (31, 32, 33, 34, 35, 36, 37, 38, 39, 40, 41, 42, 43, 44, 45, 46, 47, 48, 49)
17:07:22.7520.3 msyii\db\Command::querySELECT SUM(t.amount - t.settle_amount) FROM "a57be577deb434"."tbl_erp_other_payment_tickets" "t" WHERE ("t"."status" IN (2, 5)) AND ("ticket_type"=2) AND ("t"."created_at" >= '2025-08-01 00:00:00') AND ("t"."created_at" <= '2025-08-31 23:59:59')
17:07:22.7510.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_tax_datas" "td" WHERE ("td"."date" >= '2025-08-01 00:00:00') AND ("td"."date" <= '2025-08-31 23:59:59')
17:07:22.6880.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_account_captions" WHERE "id" IN (37, 38, 44)
17:07:22.6940.3 msyii\db\Command::querySELECT SUM(t.amount - t.settle_amount) FROM "a57be577deb434"."tbl_erp_other_payment_tickets" "t" WHERE ("t"."status"=2) AND ("t"."ticket_type"=3) AND ("t"."created_at" >= '2025-08-01 00:00:00') AND ("t"."created_at" <= '2025-08-31 23:59:59')
17:07:22.7530.2 msyii\db\Command::querySELECT SUM(t.amount - t.settle_amount) FROM "a57be577deb434"."tbl_erp_other_payment_tickets" "t" WHERE ("t"."status" IN (2, 5)) AND ("ticket_type"=3) AND ("t"."created_at" >= '2025-08-01 00:00:00') AND ("t"."created_at" <= '2025-08-31 23:59:59')
17:07:22.6860.2 msyii\db\Command::querySELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id"=5016
17:07:22.7530.2 msyii\db\Command::querySELECT SUM(t.amount) FROM "a57be577deb434"."tbl_erp_cost_tickets" "t" WHERE ("t"."status"=6) AND ("t"."stop_at" >= '2025-08-01 00:00:00') AND ("t"."stop_at" <= '2025-08-31 23:59:59')
17:07:22.7520.2 msyii\db\Command::querySELECT SUM(t.amount) FROM "a57be577deb434"."tbl_erp_other_payment_tickets" "t" WHERE ("t"."status"=6) AND ("t"."stop_at" >= '2025-08-01 00:00:00') AND ("t"."stop_at" <= '2025-08-31 23:59:59') AND ("ticket_type"=2)
17:07:22.7530.2 msyii\db\Command::querySELECT SUM(t.amount - t.settle_amount) FROM "a57be577deb434"."tbl_erp_cost_tickets" "t" WHERE ("t"."status" IN (2, 5)) AND ("t"."created_at" >= '2025-08-01 00:00:00') AND ("t"."created_at" <= '2025-08-31 23:59:59')
17:07:22.7540.2 msyii\db\Command::querySELECT SUM(t.amount) FROM "a57be577deb434"."tbl_erp_other_payment_tickets" "t" WHERE ("t"."status"=6) AND ("t"."stop_at" >= '2025-08-01 00:00:00') AND ("t"."stop_at" <= '2025-08-31 23:59:59') AND ("ticket_type"=3)
17:07:22.6890.2 msyii\db\Command::querySELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=5016)
17:07:22.6890.2 msyii\db\Command::querySELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id"=5016
17:07:22.6890.1 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_departments" WHERE "id"=10