ConfigurationRequestLogsProfilingDatabaseAsset BundlesMailTimeline
All Latest
6a1e7def06362: POST https://beta.jinchangxiao.com/vue/tax/purchase-invoice-list at 2026-06-02 02:53:35 pm by 221.216.117.119

Performance Profiling

Total processing time: 80 ms; Peak memory: 5.596 MB. Show Profiling Timeline

总计30条数据
TimeDurationCategoryInfo
  
14:53:35.0467.8 msyii\db\Command::querySELECT pci.* FROM "a57be577deb434"."tbl_purchase_contract_invoices" "pci" LEFT JOIN "a57be577deb434"."tbl_purchase_contracts" "pc" ON pc.id = pci.contract_id LEFT JOIN "a57be577deb434"."tbl_purchase_invoice_products" "pcpp" ON pci.id = pcpp.purchase_invoice_id LEFT JOIN "a57be577deb434"."tbl_suppliers" "s" ON pci.supplier_id = s.id LEFT JOIN "a57be577deb434"."tbl_purchase_invoice_projects" "pip" ON pci.id = pip.purchase_invoice_id LEFT JOIN "a57be577deb434"."tbl_projects" "p" ON p.id = pip.project_id LEFT JOIN "a57be577deb434"."tbl_clients" "c" ON p.client_id = c.id WHERE (pci.cover_invoice_id is null) AND (("pci"."from_date" >= '2024-08-01 00:00') OR ("pci"."is_draft"=FALSE)) GROUP BY "pci"."id" ORDER BY pci.from_date DESC nulls last, pci.created_at DESC nulls last LIMIT 20
14:53:35.0387.4 msyii\db\Command::querySELECT COUNT(*) FROM (SELECT pci.* FROM "a57be577deb434"."tbl_purchase_contract_invoices" "pci" LEFT JOIN "a57be577deb434"."tbl_purchase_contracts" "pc" ON pc.id = pci.contract_id LEFT JOIN "a57be577deb434"."tbl_purchase_invoice_products" "pcpp" ON pci.id = pcpp.purchase_invoice_id LEFT JOIN "a57be577deb434"."tbl_suppliers" "s" ON pci.supplier_id = s.id LEFT JOIN "a57be577deb434"."tbl_purchase_invoice_projects" "pip" ON pci.id = pip.purchase_invoice_id LEFT JOIN "a57be577deb434"."tbl_projects" "p" ON p.id = pip.project_id LEFT JOIN "a57be577deb434"."tbl_clients" "c" ON p.client_id = c.id WHERE (pci.cover_invoice_id is null) AND (("pci"."from_date" >= '2024-08-01 00:00') OR ("pci"."is_draft"=FALSE)) GROUP BY "pci"."id" ORDER BY pci.from_date DESC nulls last, pci.created_at DESC nulls last) "c"
14:53:35.0574.1 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=21) AND ("object_id" IN (2756, 2754, 2753, 2752, 2751, 2750, 2749, 2748, 2747, 2746, 2745, 2744, 2742, 2743, 2740, 2741, 2739, 2738, 2737, 2736))
14:53:35.0783.4 msyii\db\Command::querySELECT COUNT(*) FROM "a57be577deb434"."tbl_purchase_contract_invoices" WHERE "id" IN (SELECT "pci"."id" FROM "a57be577deb434"."tbl_purchase_contract_invoices" "pci" LEFT JOIN "a57be577deb434"."tbl_purchase_contracts" "pc" ON pc.id = pci.contract_id LEFT JOIN "a57be577deb434"."tbl_purchase_invoice_products" "pcpp" ON pci.id = pcpp.purchase_invoice_id LEFT JOIN "a57be577deb434"."tbl_suppliers" "s" ON pci.supplier_id = s.id LEFT JOIN "a57be577deb434"."tbl_purchase_invoice_projects" "pip" ON pci.id = pip.purchase_invoice_id LEFT JOIN "a57be577deb434"."tbl_projects" "p" ON p.id = pip.project_id LEFT JOIN "a57be577deb434"."tbl_clients" "c" ON p.client_id = c.id WHERE ("pci"."from_date" >= '2024-08-01 00:00') OR ("pci"."is_draft"=FALSE) GROUP BY "pci"."id")
14:53:35.0853.4 msyii\db\Command::querySELECT SUM(excluding_tax) FROM "a57be577deb434"."tbl_purchase_contract_invoices" WHERE "id" IN (SELECT "pci"."id" FROM "a57be577deb434"."tbl_purchase_contract_invoices" "pci" LEFT JOIN "a57be577deb434"."tbl_purchase_contracts" "pc" ON pc.id = pci.contract_id LEFT JOIN "a57be577deb434"."tbl_purchase_invoice_products" "pcpp" ON pci.id = pcpp.purchase_invoice_id LEFT JOIN "a57be577deb434"."tbl_suppliers" "s" ON pci.supplier_id = s.id LEFT JOIN "a57be577deb434"."tbl_purchase_invoice_projects" "pip" ON pci.id = pip.purchase_invoice_id LEFT JOIN "a57be577deb434"."tbl_projects" "p" ON p.id = pip.project_id LEFT JOIN "a57be577deb434"."tbl_clients" "c" ON p.client_id = c.id WHERE ("pci"."from_date" >= '2024-08-01 00:00') OR ("pci"."is_draft"=FALSE) GROUP BY "pci"."id")
14:53:35.0893.3 msyii\db\Command::querySELECT SUM(tax_amount) FROM "a57be577deb434"."tbl_purchase_contract_invoices" WHERE "id" IN (SELECT "pci"."id" FROM "a57be577deb434"."tbl_purchase_contract_invoices" "pci" LEFT JOIN "a57be577deb434"."tbl_purchase_contracts" "pc" ON pc.id = pci.contract_id LEFT JOIN "a57be577deb434"."tbl_purchase_invoice_products" "pcpp" ON pci.id = pcpp.purchase_invoice_id LEFT JOIN "a57be577deb434"."tbl_suppliers" "s" ON pci.supplier_id = s.id LEFT JOIN "a57be577deb434"."tbl_purchase_invoice_projects" "pip" ON pci.id = pip.purchase_invoice_id LEFT JOIN "a57be577deb434"."tbl_projects" "p" ON p.id = pip.project_id LEFT JOIN "a57be577deb434"."tbl_clients" "c" ON p.client_id = c.id WHERE ("pci"."from_date" >= '2024-08-01 00:00') OR ("pci"."is_draft"=FALSE) GROUP BY "pci"."id")
14:53:35.0823.3 msyii\db\Command::querySELECT SUM(amount) FROM "a57be577deb434"."tbl_purchase_contract_invoices" WHERE "id" IN (SELECT "pci"."id" FROM "a57be577deb434"."tbl_purchase_contract_invoices" "pci" LEFT JOIN "a57be577deb434"."tbl_purchase_contracts" "pc" ON pc.id = pci.contract_id LEFT JOIN "a57be577deb434"."tbl_purchase_invoice_products" "pcpp" ON pci.id = pcpp.purchase_invoice_id LEFT JOIN "a57be577deb434"."tbl_suppliers" "s" ON pci.supplier_id = s.id LEFT JOIN "a57be577deb434"."tbl_purchase_invoice_projects" "pip" ON pci.id = pip.purchase_invoice_id LEFT JOIN "a57be577deb434"."tbl_projects" "p" ON p.id = pip.project_id LEFT JOIN "a57be577deb434"."tbl_clients" "c" ON p.client_id = c.id WHERE ("pci"."from_date" >= '2024-08-01 00:00') OR ("pci"."is_draft"=FALSE) GROUP BY "pci"."id")
14:53:35.0923.2 msyii\db\Command::querySELECT sum(amount) as sum, count(id) as count, "verify" FROM (SELECT pci.id, pci.amount, CASE WHEN pci.is_verify = true THEN 1 ELSE 0 END as verify FROM "a57be577deb434"."tbl_purchase_contract_invoices" "pci" LEFT JOIN "a57be577deb434"."tbl_purchase_contracts" "pc" ON pc.id = pci.contract_id LEFT JOIN "a57be577deb434"."tbl_purchase_invoice_products" "pcpp" ON pci.id = pcpp.purchase_invoice_id LEFT JOIN "a57be577deb434"."tbl_suppliers" "s" ON pci.supplier_id = s.id LEFT JOIN "a57be577deb434"."tbl_purchase_invoice_projects" "pip" ON pci.id = pip.purchase_invoice_id LEFT JOIN "a57be577deb434"."tbl_projects" "p" ON p.id = pip.project_id LEFT JOIN "a57be577deb434"."tbl_clients" "c" ON p.client_id = c.id WHERE (("pci"."from_date" >= '2024-08-01 00:00') OR ("pci"."is_draft"=FALSE)) AND ("pci"."invoice_type" != '-1') GROUP BY "pci"."id") "sub" GROUP BY "verify"
14:53:35.0622.7 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=103) AND ("object_id" IN (2756, 2754, 2753, 2752, 2751, 2750, 2749, 2748, 2747, 2746, 2745, 2744, 2742, 2743, 2740, 2741, 2739, 2738, 2737, 2736))
14:53:35.0992.5 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/tax/purchase-invoice-list', '{"Filter":{"name":"from_date","sort":"DESC"},"PurchaseContractInvoiceSearch":{"from_date_period":"","created_at_period":"","verify_at_period":"","is_verify":"","outbound":"","is_cancel":"","is_draft":"","is_contract_cancel":"","keyword":""},"page":"1","web_access_token":"eLSqRe8hqEgPBX_zWO9QINJWKjv2Vvg4"}', '{"code":2000,"result":{"list":[{"id":2756,"contract_id":4466,"amount":"100","attachment_id":"","from_date":"2026-05-15","created_by":1001,"created_at":"2026-05-15 15:29:38","description":"","invoice_num":"","invoice_type":"","handler":{},"is_verify":false,"is_cancel":false,"paid_amount":"0","tax_amount":"","excluding_tax":"","verify_at":"","is_used":false,"updated_at":"","cancel_description":"","cover_invoice_id":"","red_invoice_id":"","new_invoice_id":"","need_new_invoice":false,"is_draft":true,"is_settle":false,"supplier_id":431,"is_contract_cancel":false,"verify_time":"","createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4,"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/\/avatar\/e868e40f-1256-329e-9b1c-74e095049622.png"},"department":{"id":4,"key":4,"name":"\u603b\u7ecf\u7406"}},"attachment":{},"attachmentRelationships":[],"files":[],"contract":{"id":4466,"key":4466,"serial_no":"\u623f\u79df","supplier_id":431,"supplier":{"id":431,"key":431,"name":"\u5317\u4eac\u60e0\u8054\u8baf\u901a\u4fe1\u606f\u6280\u672f\u670d\u52a1\u6709\u9650\u516c\u53f8"}},"supplier":{"id":431,"key":431,"name":"\u5317\u4eac\u60e0\u8054\u8baf\u901a\u4fe1\u606f\u6280\u672f\u670d\u52a1\u6709\u9650\u516c\u53f8"},"purchaseInvoiceProjects":[],"purchaseInvoiceReminders":[],"purchaseInvoiceProducts":[],"coverInvoices":[],"cancelInvoice":{},"redInvoice":{},"invoice_type_display":"","including_tax":0,"number":0,"outbound":0,"un_used_amount":100,"tax_rate":[],"purchaseInvoiceProductList":[],"can_update":true,"can_delete":true,"can_cancel":false,"can_re_cancel":false,"can_red_cancel":false,"can_new_invoice":false,"can_verify":false,"can_re_verify":false,"is_new":false},{"id":2754,"contract_id":"","amount":"113","attachment_id":"","from_date":"2026-05-12","created_by":1001,"created_at":"2026-05-12 15:10:55","description":"","invoice_num":"\u65b0\u5efa","invoice_type":1,"handler":{},"is_verify":true,"is_cancel":false,"paid_amount":"113","tax_amount":"13","excluding_tax":"100","verify_at":"2026-05-12 00:00:00","is_used":true,"updated_at":"2026-05-12 15:10:55","cancel_description":"","cover_invoice_id":"","red_invoice_id":"","new_invoice_id":"","need_new_invoice":false,"is_draft":false,"is_settle":false,"supplier_id":"","is_contract_cancel":false,"verify_time":"","createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4,"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/\/avatar\/e868e40f-1256-329e-9b1c-74e095049622.png"},"department":{"id":4,"key":4,"name":"\u603b\u7ecf\u7406"}},"attachment":{},"attachmentRelationships":[],"files":[],"contract":{},"supplier":{},"purchaseInvoiceProjects":[],"purchaseInvoiceReminders":[],"purchaseInvoiceProducts":[{"id":3109,"purchase_invoice_id":2754,"title":"","description":"1","number":"2","outbound":"2","inventory":"0","unit":"1","amount":"113","tax_rate":"13","including_tax":"0","excluding_tax":"100","tax_amount":"13","into_inventory":true,"newProduct":[],"matchSalesInvoice":[]}],"coverInvoices":[],"cancelInvoice":{},"redInvoice":{},"invoice_type_display":"\u6570\u7535\u4e13\u7968","including_tax":0,"number":2,"outbound":2,"un_used_amount":0,"tax_rate":["13"],"purchaseInvoiceProductList":[{"tax_rate":13,"amount":113,"excluding_tax":100,"tax_amount":13,"list":[{"id":3109,"purchase_invoice_id":2754,"title":"","description":"1","number":"2","outbound":"2","inventory":"0","unit":"1","amount":"113","tax_rate":"13","including_tax":"0","excluding_tax":"100","tax_amount":"13","into_inventory":true,"newProduct":[],"matchSalesInvoice":[]}]}],"can_update":true,"can_delete":true,"can_cancel":true,"can_re_cancel":false,"can_red_cancel":true,"can_new_invoice":false,"can_verify":false,"can_re_verify":true,"is_new":false},{"id":2753,"contract_id":4437,"amount":"119538.18","attachment_id":"","from_date":"2026-05-09","created_by":1001,"created_at":"2026-05-09 09:31:58","description":"","invoice_num":"\u6d4b\u8bd5","invoice_type":1,"handler":{},"is_verify":true,"is_cancel":false,"paid_amount":"26299.667083333","tax_amount":"13752.18","excluding_tax":"105786","verify_at":"2026-05-12 00:00:00","is_used":true,"updated_at":"2026-05-09 16:12:25","cancel_description":"","cover_invoice_id":"","red_invoice_id":"","new_invoice_id":"","need_new_invoice":false,"is_draft":false,"is_settle":false,"supplier_id":762,"is_contract_cancel":false,"verify_time":"","createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4,"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/\/avatar\/e868e40f-1256-329e-9b1c-74e095049622.png"},"department":{"id":4,"key":4,"name":"\u603b\u7ecf\u7406"}},"attachment":{},"attachmentRelationships":[],"files":[],"contract":{"id":4437,"key":4437,"serial_no":"TSKJ20260309-HYF-01","supplier_id":762,"supplier":{"id":762,"key":762,"name":"\u5357\u4eac\u9ec4\u89d2\u6811\u4fe1\u606f\u79d1\u6280\u6709\u9650\u516c\u53f8"}},"supplier":{"id":762,"key":762,"name":"\u5357\u4eac\u9ec4\u89d2\u6811\u4fe1\u606f\u79d1\u6280\u6709\u9650\u516c\u53f8"},"purchaseInvoiceProjects":[],"purchaseInvoiceReminders":[],"purchaseInvoiceProducts":[{"id":3104,"purchase_invoice_id":2753,"title":"44","description":"545","number":"6","outbound":"1","inventory":"5","unit":"4","amount":"8913.44","tax_rate":"13","including_tax":"0","excluding_tax":"7888","tax_amount":"1025.44","into_inventory":true,"newProduct":[],"matchSalesInvoice":[]},{"id":3105,"purchase_invoice_id":2753,"title":"8","description":"8","number":"8","outbound":"1","inventory":"7","unit":"8","amount":"98069.31","tax_rate":"13","including_tax":"0","excluding_tax":"86787","tax_amount":"11282.31","into_inventory":true,"newProduct":[],"matchSalesInvoice":[]},{"id":3108,"purchase_invoice_id":2753,"title":"","description":"\u8d39\u7528-98162980","number":"1","outbound":"1","inventory":"0","unit":"","amount":"12555.43","tax_rate":"13","including_tax":"0","excluding_tax":"11111","tax_amount":"1444.43","into_inventory":true,"newProduct":[],"matchSalesInvoice":[]}],"coverInvoices":[],"cancelInvoice":{},"redInvoice":{},"invoice_type_display":"\u6570\u7535\u4e13\u7968","including_tax":0,"number":15,"outbound":3,"un_used_amount":93238.512916667,"tax_rate":["13"],"purchaseInvoiceProductList":[{"tax_rate":13,"amount":119538.18,"excluding_tax":105786,"tax_amount":13752.18,"list":[{"id":3104,"purchase_invoice_id":2753,"title":"44","description":"545","number":"6","outbound":"1","inventory":"5","unit":"4","amount":"8913.44","tax_rate":"13","including_tax":"0","excluding_tax":"7888","tax_amount":"1025.44","into_inventory":true,"newProduct":[],"matchSalesInvoice":[]},{"id":3105,"purchase_invoice_id":2753,"title":"8","description":"8","number":"8","outbound":"1","inventory":"7","unit":"8","amount":"98069.31","tax_rate":"13","including_tax":"0","excluding_tax":"86787","tax_amount":"11282.31","into_inventory":true,"newProduct":[],"matchSalesInvoice":[]},{"id":3108,"purchase_invoice_id":2753,"title":"","description":"\u8d39\u7528-98162980","number":"1","outbound":"1","inventory":"0","unit":"","amount":"12555.43","tax_rate":"13","including_tax":"0","excluding_tax":"11111","tax_amount":"1444.43","into_inventory":true,"newProduct":[],"matchSalesInvoice":[]}]}],"can_update":true,"can_delete":true,"can_cancel":true,"can_re_cancel":false,"can_red_cancel":true,"can_new_invoice":false,"can_verify":false,"can_re_verify":true,"is_new":false},{"id":2752,"contract_id":4447,"amount":"533","attachment_id":"","from_date":"2026-05-09","created_by":1001,"created_at":"2026-05-09 09:30:28","description":"","invoice_num":"\u539f\u6765\u7a0e\u738713%\u30021%\uff0c\u4fee\u6539\u4e3a6% 5%","invoice_type":1,"handler":{},"is_verify":true,"is_cancel":false,"paid_amount":"533","tax_amount":"33","excluding_tax":"500","verify_at":"2026-05-09 00:00:00","is_used":true,"updated_at":"2026-05-09 09:40:44","cancel_description":"","cover_invoice_id":"","red_invoice_id":"","new_invoice_id":"","need_new_invoice":false,"is_draft":false,"is_settle":false,"supplier_id":46,"is_contract_cancel":false,"verify_time":"2026-05-09 09:41:00","createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4,"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/\/avatar\/e868e40f-1256-329e-9b1c-74e095049622.png"},"department":{"id":4,"key":4,"name":"\u603b\u7ecf\u7406"}},"attachment":{},"attachmentRelationships":[{"id":57623,"object_type":21,"object_id":2752,"attachment_id":32668,"attachment":{"id":32668,"key":32668,"name":"986ec0a2-520f-36c9-9961-ef15da9d9eb8","extension":"png","path":"\/vue\/attachment\/view\/986ec0a2-520f-36c9-9961-ef15da9d9eb8\/2a99ddb8496a1906cffaf35dd570cb92.png","orig_name":"2a99ddb8496a1906cffaf35dd570cb92.png"}}],"files":[],"contract":{"id":4447,"key":4447,"serial_no":"DZ202603233147774","supplier_id":46,"supplier":{"id":46,"key":46,"name":"\u795e\u5dde\u6570\u7801(\u4e2d\u56fd)\u6709\u9650\u516c\u53f8"}},"supplier":{"id":46,"key":46,"name":"\u795e\u5dde\u6570\u7801(\u4e2d\u56fd)\u6709\u9650\u516c\u53f8"},"purchaseInvoiceProjects":[{"id":2903,"purchase_invoice_id":2752,"project_id":4142,"project":{"id":4142,"key":4142,"name":"PA1420 \u4e24\u53f0\u65b0\u8d2d\u9879\u76ee","client_id":3286,"client":{"id":3286,"key":3286,"name":"\u826f\u56fe\u79d1\u6280(\u4e0a\u6d77)\u6709\u9650\u516c\u53f8"}}}],"purchaseInvoiceReminders":[],"purchaseInvoiceProducts":[{"id":3106,"purchase_invoice_id":2752,"title":"V10","description":"6%","number":"1","outbound":"1","inventory":"0","unit":"","amount":"113","tax_rate":"6","including_tax":"0","excluding_tax":"100","tax_amount":"13","into_inventory":true,"newProduct":[],"matchSalesInvoice":[]},{"id":3107,"purchase_invoice_id":2752,"title":"1","description":"5","number":"1","outbound":"1","inventory":"0","unit":"","amount":"420","tax_rate":"5","including_tax":"0","excluding_tax":"400","tax_amount":"20","into_inventory":true,"newProduct":[],"matchSalesInvoice":[]}],"coverInvoices":[],"cancelInvoice":{},"redInvoice":{},"invoice_type_display":"\u6570\u7535\u4e13\u7968","including_tax":0,"number":2,"outbound":2,"un_used_amount":0,"tax_rate":["6","5"],"purchaseInvoiceProductList":[{"tax_rate":6,"amount":113,"excluding_tax":100,"tax_amount":13,"list":[{"id":3106,"purchase_invoice_id":2752,"title":"V10","description":"6%","number":"1","outbound":"1","inventory":"0","unit":"","amount":"113","tax_rate":"6","including_tax":"0","excluding_tax":"100","tax_amount":"13","into_inventory":true,"newProduct":[],"matchSalesInvoice":[]}]},{"tax_rate":5,"amount":420,"excluding_tax":400,"tax_amount":20,"list":[{"id":3107,"purchase_invoice_id":2752,"title":"1","description":"5","number":"1","outbound":"1","inventory":"0","unit":"","amount":"420","tax_rate":"5","including_tax":"0","excluding_tax":"400","tax_amount":"20","into_inventory":true,"newProduct":[],"matchSalesInvoice":[]}]}],"can_update":true,"can_delete":true,"can_cancel":true,"can_re_cancel":false,"can_red_cancel":true,"can_new_invoice":false,"can_verify":false,"can_re_verify":true,"is_new":false},{"id":2751,"contract_id":4439,"amount":"23510.64","attachment_id":"","from_date":"2026-03-25","created_by":1011,"created_at":"2026-03-25 17:24:55","description":"","invoice_num":"26122000000364572616","invoice_type":1,"handler":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","department_id":3},"is_verify":false,"is_cancel":false,"paid_amount":"0","tax_amount":"2677.26","excluding_tax":"20833.38","verify_at":"","is_used":false,"updated_at":"2026-04-30 09:38:16","cancel_description":"","cover_invoice_id":"","red_invoice_id":"","new_invoice_id":"","need_new_invoice":false,"is_draft":false,"is_settle":false,"supplier_id":701,"is_contract_cancel":false,"verify_time":"","createdBy":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","department_id":3,"avatar":{"id":17,"user_id":1011,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b54747f4-248d-380e-93bc-0f62f769e70d.png"},"department":{"id":3,"key":3,"name":"\u5546\u52a1\u90e8"}},"attachment":{},"attachmentRelationships":[],"files":[{"id":57595,"object_type":103,"object_id":2751,"attachment_id":32557,"attachment":{"id":32557,"key":32557,"name":"7ca68e8f-d206-3224-ad6c-d312b58aec77","extension":"pdf","path":"\/vue\/attachment\/view\/7ca68e8f-d206-3224-ad6c-d312b58aec77\/\u5317\u4eac\u62d3\u5b9e\u79d1\u6280\u6709\u9650\u516c\u53f8.pdf","orig_name":"\u5317\u4eac\u62d3\u5b9e\u79d1\u6280\u6709\u9650\u516c\u53f8.pdf"}}],"contract":{"id":4439,"key":4439,"serial_no":"TSKJ20260318-HYF-01","supplier_id":701,"supplier":{"id":701,"key":701,"name":"\u6570\u529b\uff08\u5929\u6d25\uff09\u79d1\u6280\u6709\u9650\u516c\u53f8"}},"supplier":{"id":701,"key":701,"name":"\u6570\u529b\uff08\u5929\u6d25\uff09\u79d1\u6280\u6709\u9650\u516c\u53f8"},"purchaseInvoiceProjects":[{"id":2899,"purchase_invoice_id":2751,"project_id":4077,"project":{"id":4077,"key":4077,"name":"\u91cd\u673a\u4fe1\u521b\u8f6f\u4ef6\u4e09\u671f","client_id":3359,"client":{"id":3359,"key":3359,"name":"\u5317\u4eac\u601d\u8054\u79d1\u8baf\u79d1\u6280\u6709\u9650\u516c\u53f8"}}}],"purchaseInvoiceReminders":[],"purchaseInvoiceProducts":[{"id":3102,"purchase_invoice_id":2751,"title":"V10","description":"*\u8f6f\u4ef6*\u94f6\u6cb3\u9e92\u9e9f\u9ad8\u7ea7\u670d\u52a1\u5668\u64cd\u4f5c\u7cfb\u7edfV10","number":"6","outbound":"0","inventory":"6","unit":"\u5957","amount":"23040","tax_rate":"13","including_tax":"0","excluding_tax":"20389.38","tax_amount":"2650.62","into_inventory":true,"newProduct":[],"matchSalesInvoice":[]},{"id":3103,"purchase_invoice_id":2751,"title":"444","description":"3333","number":"1","outbound":"0","inventory":"1","unit":"5","amount":"470.64","tax_rate":"6","including_tax":"0","excluding_tax":"444","tax_amount":"26.64","into_inventory":true,"newProduct":[],"matchSalesInvoice":[]}],"coverInvoices":[],"cancelInvoice":{},"redInvoice":{},"invoice_type_display":"\u6570\u7535\u4e13\u7968","including_tax":0,"number":7,"outbound":0,"un_used_amount":23510.64,"tax_rate":["13","6"],"purchaseInvoiceProductList":[{"tax_rate":13,"amount":23040,"excluding_tax":20389.38,"tax_amount":2650.62,"list":[{"id":3102,"purchase_invoice_id":2751,"title":"V10","description":"*\u8f6f\u4ef6*\u94f6\u6cb3\u9e92\u9e9f\u9ad8\u7ea7\u670d\u52a1\u5668\u64cd\u4f5c\u7cfb\u7edfV10","number":"6","outbound":"0","inventory":"6","unit":"\u5957","amount":"23040","tax_rate":"13","including_tax":"0","excluding_tax":"20389.38","tax_amount":"2650.62","into_inventory":true,"newProduct":[],"matchSalesInvoice":[]}]},{"tax_rate":6,"amount":470.64,"excluding_tax":444,"tax_amount":26.64,"list":[{"id":3103,"purchase_invoice_id":2751,"title":"444","description":"3333","number":"1","outbound":"0","inventory":"1","unit":"5","amount":"470.64","tax_rate":"6","including_tax":"0","excluding_tax":"444","tax_amount":"26.64","into_inventory":true,"newProduct":[],"matchSalesInvoice":[]}]}],"can_update":true,"can_delete":true,"can_cancel":true,"can_re_cancel":false,"can_red_cancel":true,"can_new_invoice":false,"can_verify":true,"can_re_verify":false,"is_new":false},{"id":2750,"contract_id":4435,"amount":"2364","attachment_id":"","from_date":"2026-03-25","created_by":5360,"created_at":"2026-03-25 15:13:20","description":"","invoice_num":"26112000001159478506","invoice_type":1,"handler":{"id":5360,"key":5360,"name":"\u5f20\u7ea2\u82b3","sex":"F","department_id":3},"is_verify":true,"is_cancel":false,"paid_amount":"2364","tax_amount":"271.97","excluding_tax":"2092.03","verify_at":"2026-05-12 00:00:00","is_used":true,"updated_at":"2026-03-25 15:14:47","cancel_description":"","cover_invoice_id":"","red_invoice_id":"","new_invoice_id":"","need_new_invoice":false,"is_draft":false,"is_settle":false,"supplier_id":686,"is_contract_cancel":false,"verify_time":"","createdBy":{"id":5360,"key":5360,"name":"\u5f20\u7ea2\u82b3","sex":"F","department_id":3,"avatar":{"id":153,"user_id":5360,"name":"\/files\/cdn\/a57be577deb434\/avatar\/612c2410-e800-3507-aa05-3f1fbeb408a7.png"},"department":{"id":3,"key":3,"name":"\u5546\u52a1\u90e8"}},"attachment":{},"attachmentRelationships":[],"files":[{"id":57482,"object_type":103,"object_id":2750,"attachment_id":32555,"attachment":{"id":32555,"key":32555,"name":"bd2a659d-7dce-327c-88c9-c8122ee157a7","extension":"pdf","path":"\/vue\/attachment\/view\/bd2a659d-7dce-327c-88c9-c8122ee157a7\/dzfp_26112000001159478506_\u5317\u4eac\u62d3\u5b9e\u79d1\u6280\u6709\u9650\u516c\u53f8_20260325150332.pdf","orig_name":"dzfp_26112000001159478506_\u5317\u4eac\u62d3\u5b9e\u79d1\u6280\u6709\u9650\u516c\u53f8_20260325150332.pdf"}}],"contract":{"id":4435,"key":4435,"serial_no":"TSKJ20260309-ZHF-001","supplier_id":686,"supplier":{"id":686,"key":686,"name":"\u5317\u4eac\u4e07\u7f51\u878d\u901a\u4fe1\u606f\u7cfb\u7edf\u6709\u9650\u516c\u53f8"}},"supplier":{"id":686,"key":686,"name":"\u5317\u4eac\u4e07\u7f51\u878d\u901a\u4fe1\u606f\u7cfb\u7edf\u6709\u9650\u516c\u53f8"},"purchaseInvoiceProjects":[{"id":2896,"purchase_invoice_id":2750,"project_id":4130,"project":{"id":4130,"key":4130,"name":"2026\u9632\u706b\u5899\u7eed\u4fdd","client_id":2032,"client":{"id":2032,"key":2032,"name":"\u91cd\u5e86\u7075\u72d0\u79d1\u6280\u80a1\u4efd\u6709\u9650\u516c\u53f8\u5317\u4eac\u5206\u516c\u53f8(\u9752\u5c9b\u7075\u72d0\u7535\u5b50\u5546\u52a1\u6709\u9650\u516c\u53f8\/\u5317\u4eac\u4f18\u54c1\u6548\u9500\u79d1\u6280\u6709\u9650\u516c\u53f8)"}}}],"purchaseInvoiceReminders":[],"purchaseInvoiceProducts":[{"id":3099,"purchase_invoice_id":2750,"title":"LIS-F1000-AK-AV-1Y","description":"*\u8f6f\u4ef6*\u8f6f\u4ef6","number":"1","outbound":"1","inventory":"0","unit":"\u4e2a","amount":"874","tax_rate":"13","including_tax":"0","excluding_tax":"773.45","tax_amount":"100.55","into_inventory":true,"newProduct":[],"matchSalesInvoice":[]},{"id":3100,"purchase_invoice_id":2750,"title":"LIS-F1000-AK-IPS-1Y","description":"*\u8f6f\u4ef6*\u8f6f\u4ef6","number":"1","outbound":"1","inventory":"0","unit":"\u4e2a","amount":"777","tax_rate":"13","including_tax":"0","excluding_tax":"687.61","tax_amount":"89.39","into_inventory":true,"newProduct":[],"matchSalesInvoice":[]},{"id":3101,"purchase_invoice_id":2750,"title":"LIS-F1000-AK-URL-1Y","description":"*\u8f6f\u4ef6*\u8f6f\u4ef6","number":"1","outbound":"1","inventory":"0","unit":"\u4e2a","amount":"713","tax_rate":"13","including_tax":"0","excluding_tax":"630.97","tax_amount":"82.03","into_inventory":true,"newProduct":[],"matchSalesInvoice":[]}],"coverInvoices":[],"cancelInvoice":{},"redInvoice":{},"invoice_type_display":"\u6570\u7535\u4e13\u7968","including_tax":0,"number":3,"outbound":3,"un_used_amount":0,"tax_rate":["13"],"purchaseInvoiceProductList":[{"tax_rate":13,"amount":2364,"excluding_tax":2092.03,"tax_amount":271.97,"list":[{"id":3099,"purchase_invoice_id":2750,"title":"LIS-F1000-AK-AV-1Y","description":"*\u8f6f\u4ef6*\u8f6f\u4ef6","number":"1","outbound":"1","inventory":"0","unit":"\u4e2a","amount":"874","tax_rate":"13","including_tax":"0","excluding_tax":"773.45","tax_amount":"100.55","into_inventory":true,"newProduct":[],"matchSalesInvoice":[]},{"id":3100,"purchase_invoice_id":2750,"title":"LIS-F1000-AK-IPS-1Y","description":"*\u8f6f\u4ef6*\u8f6f\u4ef6","number":"1","outbound":"1","inventory":"0","unit":"\u4e2a","amount":"777","tax_rate":"13","including_tax":"0","excluding_tax":"687.61","tax_amount":"89.39","into_inventory":true,"newProduct":[],"matchSalesInvoice":[]},{"id":3101,"purchase_invoice_id":2750,"title":"LIS-F1000-AK-URL-1Y","description":"*\u8f6f\u4ef6*\u8f6f\u4ef6","number":"1","outbound":"1","inventory":"0","unit":"\u4e2a","amount":"713","tax_rate":"13","including_tax":"0","excluding_tax":"630.97","tax_amount":"82.03","into_inventory":true,"newProduct":[],"matchSalesInvoice":[]}]}],"can_update":true,"can_delete":true,"can_cancel":true,"can_re_cancel":false,"can_red_cancel":true,"can_new_invoice":false,"can_verify":false,"can_re_verify":true,"is_new":false},{"id":2749,"contract_id":4442,"amount":"1980","attachment_id":"","from_date":"2026-03-24","created_by":1011,"created_at":"2026-03-25 11:14:42","description":"","invoice_num":"26112000001146975211","invoice_type":1,"handler":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","department_id":3},"is_verify":false,"is_cancel":false,"paid_amount":"1980","tax_amount":"112.08","excluding_tax":"1867.92","verify_at":"","is_used":false,"updated_at":"2026-03-25 11:15:16","cancel_description":"","cover_invoice_id":"","red_invoice_id":"","new_invoice_id":"","need_new_invoice":false,"is_draft":false,"is_settle":false,"supplier_id":763,"is_contract_cancel":false,"verify_time":"","createdBy":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","department_id":3,"avatar":{"id":17,"user_id":1011,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b54747f4-248d-380e-93bc-0f62f769e70d.png"},"department":{"id":3,"key":3,"name":"\u5546\u52a1\u90e8"}},"attachment":{},"attachmentRelationships":[],"files":[{"id":57478,"object_type":103,"object_id":2749,"attachment_id":32551,"attachment":{"id":32551,"key":32551,"name":"251d0441-d59c-3c96-9137-d7c3eb6ff22e","extension":"pdf","path":"\/vue\/attachment\/view\/251d0441-d59c-3c96-9137-d7c3eb6ff22e\/dzfp_26112000001146975211_\u521b\u4e1a\u9ed1\u9a6c\u79d1\u6280\u96c6\u56e2\u80a1\u4efd\u6709\u9650\u516c\u53f8_20260324181241.pdf","orig_name":"dzfp_26112000001146975211_\u521b\u4e1a\u9ed1\u9a6c\u79d1\u6280\u96c6\u56e2\u80a1\u4efd\u6709\u9650\u516c\u53f8_20260324181241.pdf"}}],"contract":{"id":4442,"key":4442,"serial_no":"TSKJ20260320-WH-01","supplier_id":763,"supplier":{"id":763,"key":763,"name":"\u521b\u4e1a\u9ed1\u9a6c\u79d1\u6280\u96c6\u56e2\u80a1\u4efd\u6709\u9650\u516c\u53f8"}},"supplier":{"id":763,"key":763,"name":"\u521b\u4e1a\u9ed1\u9a6c\u79d1\u6280\u96c6\u56e2\u80a1\u4efd\u6709\u9650\u516c\u53f8"},"purchaseInvoiceProjects":[],"purchaseInvoiceReminders":[],"purchaseInvoiceProducts":[{"id":3098,"purchase_invoice_id":2749,"title":"","description":"*\u73b0\u4ee3\u670d\u52a1*\u6d3b\u52a8\u670d\u52a1","number":"1","outbound":"0","inventory":"0","unit":"","amount":"1980","tax_rate":"6","including_tax":"0","excluding_tax":"1867.92","tax_amount":"112.08","into_inventory":false,"newProduct":[],"matchSalesInvoice":[]}],"coverInvoices":[],"cancelInvoice":{},"redInvoice":{},"invoice_type_display":"\u6570\u7535\u4e13\u7968","including_tax":0,"number":1,"outbound":0,"un_used_amount":0,"tax_rate":["6"],"purchaseInvoiceProductList":[{"tax_rate":6,"amount":1980,"excluding_tax":1867.92,"tax_amount":112.08,"list":[{"id":3098,"purchase_invoice_id":2749,"title":"","description":"*\u73b0\u4ee3\u670d\u52a1*\u6d3b\u52a8\u670d\u52a1","number":"1","outbound":"0","inventory":"0","unit":"","amount":"1980","tax_rate":"6","including_tax":"0","excluding_tax":"1867.92","tax_amount":"112.08","into_inventory":false,"newProduct":[],"matchSalesInvoice":[]}]}],"can_update":true,"can_delete":true,"can_cancel":true,"can_re_cancel":false,"can_red_cancel":true,"can_new_invoice":false,"can_verify":true,"can_re_verify":false,"is_new":false},{"id":2748,"contract_id":4441,"amount":"4995","attachment_id":"","from_date":"2026-03-23","created_by":1011,"created_at":"2026-03-23 16:56:50","description":"","invoice_num":"26327000000584148166","invoice_type":2,"handler":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","department_id":3},"is_verify":false,"is_cancel":false,"paid_amount":"4995","tax_amount":"412.43","excluding_tax":"4582.57","verify_at":"","is_used":false,"updated_at":"2026-03-23 16:57:38","cancel_description":"","cover_invoice_id":"","red_invoice_id":"","new_invoice_id":"","need_new_invoice":false,"is_draft":false,"is_settle":false,"supplier_id":262,"is_contract_cancel":false,"verify_time":"","createdBy":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","department_id":3,"avatar":{"id":17,"user_id":1011,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b54747f4-248d-380e-93bc-0f62f769e70d.png"},"department":{"id":3,"key":3,"name":"\u5546\u52a1\u90e8"}},"attachment":{},"attachmentRelationships":[],"files":[{"id":57347,"object_type":103,"object_id":2748,"attachment_id":32497,"attachment":{"id":32497,"key":32497,"name":"a16ace65-fa24-3fcc-b196-91cd1c9ee947","extension":"pdf","path":"\/vue\/attachment\/view\/a16ace65-fa24-3fcc-b196-91cd1c9ee947\/4995.pdf","orig_name":"4995.pdf"}}],"contract":{"id":4441,"key":4441,"serial_no":"\u8ba2\u5355\u53f7\uff1a 3443475017227610","supplier_id":262,"supplier":{"id":262,"key":262,"name":"\u4eac\u4e1c\u5546\u57ce"}},"supplier":{"id":262,"key":262,"name":"\u4eac\u4e1c\u5546\u57ce"},"purchaseInvoiceProjects":[],"purchaseInvoiceReminders":[],"purchaseInvoiceProducts":[{"id":3097,"purchase_invoice_id":2748,"title":"","description":"*\u5176\u4ed6\u98df\u54c1*\u98df\u54c1","number":"1","outbound":"0","inventory":"0","unit":"\u76d2","amount":"4995","tax_rate":"9","including_tax":"0","excluding_tax":"4582.57","tax_amount":"412.43","into_inventory":false,"newProduct":[],"matchSalesInvoice":[]}],"coverInvoices":[],"cancelInvoice":{},"redInvoice":{},"invoice_type_display":"\u6570\u7535\u666e\u7968","including_tax":0,"number":1,"outbound":0,"un_used_amount":0,"tax_rate":["9"],"purchaseInvoiceProductList":[{"tax_rate":9,"amount":4995,"excluding_tax":4582.57,"tax_amount":412.43,"list":[{"id":3097,"purchase_invoice_id":2748,"title":"","description":"*\u5176\u4ed6\u98df\u54c1*\u98df\u54c1","number":"1","outbound":"0","inventory":"0","unit":"\u76d2","amount":"4995","tax_rate":"9","including_tax":"0","excluding_tax":"4582.57","tax_amount":"412.43","into_inventory":false,"newProduct":[],"matchSalesInvoice":[]}]}],"can_update":true,"can_delete":true,"can_cancel":true,"can_re_cancel":false,"can_red_cancel":true,"can_new_invoice":false,"can_verify":false,"can_re_verify":false,"is_new":false},{"id":2747,"contract_id":4440,"amount":"153","attachment_id":"","from_date":"2026-03-23","created_by":1011,"created_at":"2026-03-23 10:47:59","description":"","invoice_num":"26952000001169656486","invoice_type":2,"handler":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","department_id":3},"is_verify":false,"is_cancel":false,"paid_amount":"153","tax_amount":"17.6","excluding_tax":"135.4","verify_at":"","is_used":false,"updated_at":"2026-03-23 10:48:41","cancel_description":"","cover_invoice_id":"","red_invoice_id":"","new_invoice_id":"","need_new_invoice":false,"is_draft":false,"is_settle":false,"supplier_id":262,"is_contract_cancel":false,"verify_time":"","createdBy":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","department_id":3,"avatar":{"id":17,"user_id":1011,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b54747f4-248d-380e-93bc-0f62f769e70d.png"},"department":{"id":3,"key":3,"name":"\u5546\u52a1\u90e8"}},"attachment":{},"attachmentRelationships":[],"files":[{"id":57333,"object_type":103,"object_id":2747,"attachment_id":32487,"attachment":{"id":32487,"key":32487,"name":"d5c4bf91-9987-33e1-b151-e9e6ee0fd307","extension":"pdf","path":"\/vue\/attachment\/view\/d5c4bf91-9987-33e1-b151-e9e6ee0fd307\/153.pdf","orig_name":"153.pdf"}}],"contract":{"id":4440,"key":4440,"serial_no":"\u8ba2\u5355\u53f7\uff1a 3442475016987410","supplier_id":262,"supplier":{"id":262,"key":262,"name":"\u4eac\u4e1c\u5546\u57ce"}},"supplier":{"id":262,"key":262,"name":"\u4eac\u4e1c\u5546\u57ce"},"purchaseInvoiceProjects":[{"id":2891,"purchase_invoice_id":2747,"project_id":4113,"project":{"id":4113,"key":4113,"name":"\u4f1a\u8bae\u5ba4\u7cfb\u7edf-K","client_id":2125,"client":{"id":2125,"key":2125,"name":"\u5317\u4eac\u673a\u5668\u5236\u9020\u6709\u9650\u516c\u53f8"}}}],"purchaseInvoiceReminders":[],"purchaseInvoiceProducts":[{"id":3093,"purchase_invoice_id":2747,"title":"","description":"*\u7535\u5f71\u673a\u68b0*\u6295\u5f71\u5e55\u5e03","number":"1","outbound":"0","inventory":"0","unit":"\u5e45","amount":"153","tax_rate":"13","including_tax":"0","excluding_tax":"135.4","tax_amount":"17.6","into_inventory":false,"newProduct":[],"matchSalesInvoice":[]}],"coverInvoices":[],"cancelInvoice":{},"redInvoice":{},"invoice_type_display":"\u6570\u7535\u666e\u7968","including_tax":0,"number":1,"outbound":0,"un_used_amount":0,"tax_rate":["13"],"purchaseInvoiceProductList":[{"tax_rate":13,"amount":153,"excluding_tax":135.4,"tax_amount":17.6,"list":[{"id":3093,"purchase_invoice_id":2747,"title":"","description":"*\u7535\u5f71\u673a\u68b0*\u6295\u5f71\u5e55\u5e03","number":"1","outbound":"0","inventory":"0","unit":"\u5e45","amount":"153","tax_rate":"13","including_tax":"0","excluding_tax":"135.4","tax_amount":"17.6","into_inventory":false,"newProduct":[],"matchSalesInvoice":[]}]}],"can_update":true,"can_delete":true,"can_cancel":true,"can_re_cancel":false,"can_red_cancel":true,"can_new_invoice":false,"can_verify":false,"can_re_verify":false,"is_new":false},{"id":2746,"contract_id":4440,"amount":"164","attachment_id":"","from_date":"2026-03-23","created_by":1011,"created_at":"2026-03-23 10:47:33","description":"","invoice_num":"26952000001169766406","invoice_type":2,"handler":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","department_id":3},"is_verify":false,"is_cancel":false,"paid_amount":"164","tax_amount":"18.87","excluding_tax":"145.13","verify_at":"","is_used":false,"updated_at":"2026-03-23 10:49:15","cancel_description":"","cover_invoice_id":"","red_invoice_id":"","new_invoice_id":"","need_new_invoice":false,"is_draft":false,"is_settle":false,"supplier_id":262,"is_contract_cancel":false,"verify_time":"","createdBy":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","department_id":3,"avatar":{"id":17,"user_id":1011,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b54747f4-248d-380e-93bc-0f62f769e70d.png"},"department":{"id":3,"key":3,"name":"\u5546\u52a1\u90e8"}},"attachment":{},"attachmentRelationships":[],"files":[{"id":57334,"object_type":103,"object_id":2746,"attachment_id":32485,"attachment":{"id":32485,"key":32485,"name":"725fd25e-71c3-3d6a-aa3f-880016c0ad37","extension":"pdf","path":"\/vue\/attachment\/view\/725fd25e-71c3-3d6a-aa3f-880016c0ad37\/164-2.pdf","orig_name":"164-2.pdf"}}],"contract":{"id":4440,"key":4440,"serial_no":"\u8ba2\u5355\u53f7\uff1a 3442475016987410","supplier_id":262,"supplier":{"id":262,"key":262,"name":"\u4eac\u4e1c\u5546\u57ce"}},"supplier":{"id":262,"key":262,"name":"\u4eac\u4e1c\u5546\u57ce"},"purchaseInvoiceProjects":[{"id":2892,"purchase_invoice_id":2746,"project_id":4113,"project":{"id":4113,"key":4113,"name":"\u4f1a\u8bae\u5ba4\u7cfb\u7edf-K","client_id":2125,"client":{"id":2125,"key":2125,"name":"\u5317\u4eac\u673a\u5668\u5236\u9020\u6709\u9650\u516c\u53f8"}}}],"purchaseInvoiceReminders":[],"purchaseInvoiceProducts":[{"id":3094,"purchase_invoice_id":2746,"title":"","description":"*\u7535\u5f71\u673a\u68b0*\u6295\u5f71\u5e55\u5e03","number":"1","outbound":"0","inventory":"0","unit":"\u798f","amount":"164","tax_rate":"13","including_tax":"0","excluding_tax":"145.13","tax_amount":"18.87","into_inventory":false,"newProduct":[],"matchSalesInvoice":[]}],"coverInvoices":[],"cancelInvoice":{},"redInvoice":{},"invoice_type_display":"\u6570\u7535\u666e\u7968","including_tax":0,"number":1,"outbound":0,"un_used_amount":0,"tax_rate":["13"],"purchaseInvoiceProductList":[{"tax_rate":13,"amount":164,"excluding_tax":145.13,"tax_amount":18.87,"list":[{"id":3094,"purchase_invoice_id":2746,"title":"","description":"*\u7535\u5f71\u673a\u68b0*\u6295\u5f71\u5e55\u5e03","number":"1","outbound":"0","inventory":"0","unit":"\u798f","amount":"164","tax_rate":"13","including_tax":"0","excluding_tax":"145.13","tax_amount":"18.87","into_inventory":false,"newProduct":[],"matchSalesInvoice":[]}]}],"can_update":true,"can_delete":true,"can_cancel":true,"can_re_cancel":false,"can_red_cancel":true,"can_new_invoice":false,"can_verify":false,"can_re_verify":false,"is_new":false},{"id":2745,"contract_id":4440,"amount":"164","attachment_id":"","from_date":"2026-03-23","created_by":1011,"created_at":"2026-03-23 10:47:23","description":"","invoice_num":"269520001170301951","invoice_type":2,"handler":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","department_id":3},"is_verify":false,"is_cancel":false,"paid_amount":"164","tax_amount":"18.87","excluding_tax":"145.13","verify_at":"","is_used":false,"updated_at":"2026-03-23 10:49:55","cancel_description":"","cover_invoice_id":"","red_invoice_id":"","new_invoice_id":"","need_new_invoice":false,"is_draft":false,"is_settle":false,"supplier_id":262,"is_contract_cancel":false,"verify_time":"","createdBy":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","department_id":3,"avatar":{"id":17,"user_id":1011,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b54747f4-248d-380e-93bc-0f62f769e70d.png"},"department":{"id":3,"key":3,"name":"\u5546\u52a1\u90e8"}},"attachment":{},"attachmentRelationships":[],"files":[{"id":57335,"object_type":103,"object_id":2745,"attachment_id":32484,"attachment":{"id":32484,"key":32484,"name":"0f366857-bf1c-3e7a-b324-6a778af5cc3b","extension":"pdf","path":"\/vue\/attachment\/view\/0f366857-bf1c-3e7a-b324-6a778af5cc3b\/164-1.pdf","orig_name":"164-1.pdf"}}],"contract":{"id":4440,"key":4440,"serial_no":"\u8ba2\u5355\u53f7\uff1a 3442475016987410","supplier_id":262,"supplier":{"id":262,"key":262,"name":"\u4eac\u4e1c\u5546\u57ce"}},"supplier":{"id":262,"key":262,"name":"\u4eac\u4e1c\u5546\u57ce"},"purchaseInvoiceProjects":[{"id":2893,"purchase_invoice_id":2745,"project_id":4113,"project":{"id":4113,"key":4113,"name":"\u4f1a\u8bae\u5ba4\u7cfb\u7edf-K","client_id":2125,"client":{"id":2125,"key":2125,"name":"\u5317\u4eac\u673a\u5668\u5236\u9020\u6709\u9650\u516c\u53f8"}}}],"purchaseInvoiceReminders":[],"purchaseInvoiceProducts":[{"id":3095,"purchase_invoice_id":2745,"title":"","description":"*\u7535\u5f71\u673a\u68b0*\u6295\u5f71\u5e55\u5e03","number":"1","outbound":"0","inventory":"0","unit":"\u5e45","amount":"164","tax_rate":"13","including_tax":"0","excluding_tax":"145.13","tax_amount":"18.87","into_inventory":false,"newProduct":[],"matchSalesInvoice":[]}],"coverInvoices":[],"cancelInvoice":{},"redInvoice":{},"invoice_type_display":"\u6570\u7535\u666e\u7968","including_tax":0,"number":1,"outbound":0,"un_used_amount":0,"tax_rate":["13"],"purchaseInvoiceProductList":[{"tax_rate":13,"amount":164,"excluding_tax":145.13,"tax_amount":18.87,"list":[{"id":3095,"purchase_invoice_id":2745,"title":"","description":"*\u7535\u5f71\u673a\u68b0*\u6295\u5f71\u5e55\u5e03","number":"1","outbound":"0","inventory":"0","unit":"\u5e45","amount":"164","tax_rate":"13","including_tax":"0","excluding_tax":"145.13","tax_amount":"18.87","into_inventory":false,"newProduct":[],"matchSalesInvoice":[]}]}],"can_update":true,"can_delete":true,"can_cancel":true,"can_re_cancel":false,"can_red_cancel":true,"can_new_invoice":false,"can_verify":false,"can_re_verify":false,"is_new":false},{"id":2744,"contract_id":4440,"amount":"164","attachment_id":"","from_date":"2026-03-23","created_by":1011,"created_at":"2026-03-23 10:47:12","description":"","invoice_num":"26952000001170041131","invoice_type":2,"handler":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","department_id":3},"is_verify":false,"is_cancel":false,"paid_amount":"164","tax_amount":"18.87","excluding_tax":"145.13","verify_at":"","is_used":false,"updated_at":"2026-03-23 10:50:33","cancel_description":"","cover_invoice_id":"","red_invoice_id":"","new_invoice_id":"","need_new_invoice":false,"is_draft":false,"is_settle":false,"supplier_id":262,"is_contract_cancel":false,"verify_time":"","createdBy":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","department_id":3,"avatar":{"id":17,"user_id":1011,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b54747f4-248d-380e-93bc-0f62f769e70d.png"},"department":{"id":3,"key":3,"name":"\u5546\u52a1\u90e8"}},"attachment":{},"attachmentRelationships":[],"files":[{"id":57336,"object_type":103,"object_id":2744,"attachment_id":32483,"attachment":{"id":32483,"key":32483,"name":"1db37924-2e3d-3fdf-91ed-96a9e1cc9471","extension":"pdf","path":"\/vue\/attachment\/view\/1db37924-2e3d-3fdf-91ed-96a9e1cc9471\/164.pdf","orig_name":"164.pdf"}}],"contract":{"id":4440,"key":4440,"serial_no":"\u8ba2\u5355\u53f7\uff1a 3442475016987410","supplier_id":262,"supplier":{"id":262,"key":262,"name":"\u4eac\u4e1c\u5546\u57ce"}},"supplier":{"id":262,"key":262,"name":"\u4eac\u4e1c\u5546\u57ce"},"purchaseInvoiceProjects":[{"id":2894,"purchase_invoice_id":2744,"project_id":4113,"project":{"id":4113,"key":4113,"name":"\u4f1a\u8bae\u5ba4\u7cfb\u7edf-K","client_id":2125,"client":{"id":2125,"key":2125,"name":"\u5317\u4eac\u673a\u5668\u5236\u9020\u6709\u9650\u516c\u53f8"}}}],"purchaseInvoiceReminders":[],"purchaseInvoiceProducts":[{"id":3096,"purchase_invoice_id":2744,"title":"","description":"*\u7535\u5f71\u673a\u68b0*\u6295\u5f71\u5e55\u5e03","number":"1","outbound":"0","inventory":"0","unit":"\u5e45","amount":"164","tax_rate":"13","including_tax":"0","excluding_tax":"145.13","tax_amount":"18.87","into_inventory":false,"newProduct":[],"matchSalesInvoice":[]}],"coverInvoices":[],"cancelInvoice":{},"redInvoice":{},"invoice_type_display":"\u6570\u7535\u666e\u7968","including_tax":0,"number":1,"outbound":0,"un_used_amount":0,"tax_rate":["13"],"purchaseInvoiceProductList":[{"tax_rate":13,"amount":164,"excluding_tax":145.13,"tax_amount":18.87,"list":[{"id":3096,"purchase_invoice_id":2744,"title":"","description":"*\u7535\u5f71\u673a\u68b0*\u6295\u5f71\u5e55\u5e03","number":"1","outbound":"0","inventory":"0","unit":"\u5e45","amount":"164","tax_rate":"13","including_tax":"0","excluding_tax":"145.13","tax_amount":"18.87","into_inventory":false,"newProduct":[],"matchSalesInvoice":[]}]}],"can_update":true,"can_delete":true,"can_cancel":true,"can_re_cancel":false,"can_red_cancel":true,"can_new_invoice":false,"can_verify":false,"can_re_verify":false,"is_new":false},{"id":2742,"contract_id":4441,"amount":"5560.88","attachment_id":"","from_date":"2026-03-22","created_by":1011,"created_at":"2026-03-23 09:47:19","description":"","invoice_num":"26327000000570812237","invoice_type":2,"handler":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","department_id":3},"is_verify":false,"is_cancel":false,"paid_amount":"5560.88","tax_amount":"639.74","excluding_tax":"4921.14","verify_at":"","is_used":false,"updated_at":"2026-03-23 09:48:27","cancel_description":"","cover_invoice_id":"","red_invoice_id":"","new_invoice_id":"","need_new_invoice":false,"is_draft":false,"is_settle":false,"supplier_id":262,"is_contract_cancel":false,"verify_time":"","createdBy":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","department_id":3,"avatar":{"id":17,"user_id":1011,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b54747f4-248d-380e-93bc-0f62f769e70d.png"},"department":{"id":3,"key":3,"name":"\u5546\u52a1\u90e8"}},"attachment":{},"attachmentRelationships":[],"files":[{"id":57308,"object_type":103,"object_id":2742,"attachment_id":32459,"attachment":{"id":32459,"key":32459,"name":"c6b4c816-5f8a-3364-8e55-dad4a582cef2","extension":"pdf","path":"\/vue\/attachment\/view\/c6b4c816-5f8a-3364-8e55-dad4a582cef2\/5560.88.pdf","orig_name":"5560.88.pdf"}}],"contract":{"id":4441,"key":4441,"serial_no":"\u8ba2\u5355\u53f7\uff1a 3443475017227610","supplier_id":262,"supplier":{"id":262,"key":262,"name":"\u4eac\u4e1c\u5546\u57ce"}},"supplier":{"id":262,"key":262,"name":"\u4eac\u4e1c\u5546\u57ce"},"purchaseInvoiceProjects":[],"purchaseInvoiceReminders":[],"purchaseInvoiceProducts":[{"id":3091,"purchase_invoice_id":2742,"title":"","description":"*\u5176\u4ed6\u673a\u68b0\u8bbe\u5907*\u7535\u5668\u7535\u5b50\u4ea7\u54c1\u53ca\u914d\u4ef6","number":"1","outbound":"0","inventory":"0","unit":"\u4e2a","amount":"5560.88","tax_rate":"13","including_tax":"0","excluding_tax":"4921.14","tax_amount":"639.74","into_inventory":false,"newProduct":[],"matchSalesInvoice":[]}],"coverInvoices":[],"cancelInvoice":{},"redInvoice":{},"invoice_type_display":"\u6570\u7535\u666e\u7968","including_tax":0,"number":1,"outbound":0,"un_used_amount":0,"tax_rate":["13"],"purchaseInvoiceProductList":[{"tax_rate":13,"amount":5560.88,"excluding_tax":4921.14,"tax_amount":639.74,"list":[{"id":3091,"purchase_invoice_id":2742,"title":"","description":"*\u5176\u4ed6\u673a\u68b0\u8bbe\u5907*\u7535\u5668\u7535\u5b50\u4ea7\u54c1\u53ca\u914d\u4ef6","number":"1","outbound":"0","inventory":"0","unit":"\u4e2a","amount":"5560.88","tax_rate":"13","including_tax":"0","excluding_tax":"4921.14","tax_amount":"639.74","into_inventory":false,"newProduct":[],"matchSalesInvoice":[]}]}],"can_update":true,"can_delete":true,"can_cancel":true,"can_re_cancel":false,"can_red_cancel":true,"can_new_invoice":false,"can_verify":false,"can_re_verify":false,"is_new":false},{"id":2743,"contract_id":4441,"amount":"4776.83","attachment_id":"","from_date":"2026-03-21","created_by":1011,"created_at":"2026-03-23 09:47:38","description":"","invoice_num":"26117000000446289343","invoice_type":2,"handler":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","department_id":3},"is_verify":false,"is_cancel":false,"paid_amount":"4776.83","tax_amount":"549.54","excluding_tax":"4227.29","verify_at":"","is_used":false,"updated_at":"2026-03-23 09:49:12","cancel_description":"","cover_invoice_id":"","red_invoice_id":"","new_invoice_id":"","need_new_invoice":false,"is_draft":false,"is_settle":false,"supplier_id":262,"is_contract_cancel":false,"verify_time":"","createdBy":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","department_id":3,"avatar":{"id":17,"user_id":1011,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b54747f4-248d-380e-93bc-0f62f769e70d.png"},"department":{"id":3,"key":3,"name":"\u5546\u52a1\u90e8"}},"attachment":{},"attachmentRelationships":[],"files":[{"id":57309,"object_type":103,"object_id":2743,"attachment_id":32460,"attachment":{"id":32460,"key":32460,"name":"dacebf00-a620-357b-b28f-e9213e43053c","extension":"pdf","path":"\/vue\/attachment\/view\/dacebf00-a620-357b-b28f-e9213e43053c\/4776.83.pdf","orig_name":"4776.83.pdf"}}],"contract":{"id":4441,"key":4441,"serial_no":"\u8ba2\u5355\u53f7\uff1a 3443475017227610","supplier_id":262,"supplier":{"id":262,"key":262,"name":"\u4eac\u4e1c\u5546\u57ce"}},"supplier":{"id":262,"key":262,"name":"\u4eac\u4e1c\u5546\u57ce"},"purchaseInvoiceProjects":[],"purchaseInvoiceReminders":[],"purchaseInvoiceProducts":[{"id":3092,"purchase_invoice_id":2743,"title":"","description":"*\u5bb6\u7528\u7535\u70ed\u7535\u529b\u5668*\u7535\u5668","number":"1","outbound":"0","inventory":"0","unit":"\u53f0","amount":"4776.83","tax_rate":"13","including_tax":"0","excluding_tax":"4227.29","tax_amount":"549.54","into_inventory":false,"newProduct":[],"matchSalesInvoice":[]}],"coverInvoices":[],"cancelInvoice":{},"redInvoice":{},"invoice_type_display":"\u6570\u7535\u666e\u7968","including_tax":0,"number":1,"outbound":0,"un_used_amount":0,"tax_rate":["13"],"purchaseInvoiceProductList":[{"tax_rate":13,"amount":4776.83,"excluding_tax":4227.29,"tax_amount":549.54,"list":[{"id":3092,"purchase_invoice_id":2743,"title":"","description":"*\u5bb6\u7528\u7535\u70ed\u7535\u529b\u5668*\u7535\u5668","number":"1","outbound":"0","inventory":"0","unit":"\u53f0","amount":"4776.83","tax_rate":"13","including_tax":"0","excluding_tax":"4227.29","tax_amount":"549.54","into_inventory":false,"newProduct":[],"matchSalesInvoice":[]}]}],"can_update":true,"can_delete":true,"can_cancel":true,"can_re_cancel":false,"can_red_cancel":true,"can_new_invoice":false,"can_verify":false,"can_re_verify":false,"is_new":false},{"id":2740,"contract_id":4434,"amount":"12000","attachment_id":"","from_date":"2026-03-19","created_by":5360,"created_at":"2026-03-19 14:40:31","description":"","invoice_num":"26112000001066499986","invoice_type":1,"handler":{"id":5360,"key":5360,"name":"\u5f20\u7ea2\u82b3","sex":"F","department_id":3},"is_verify":false,"is_cancel":false,"paid_amount":"12000","tax_amount":"349.51","excluding_tax":"11650.49","verify_at":"","is_used":false,"updated_at":"2026-03-19 14:41:51","cancel_description":"","cover_invoice_id":"","red_invoice_id":"","new_invoice_id":"","need_new_invoice":false,"is_draft":false,"is_settle":false,"supplier_id":761,"is_contract_cancel":false,"verify_time":"","createdBy":{"id":5360,"key":5360,"name":"\u5f20\u7ea2\u82b3","sex":"F","department_id":3,"avatar":{"id":153,"user_id":5360,"name":"\/files\/cdn\/a57be577deb434\/avatar\/612c2410-e800-3507-aa05-3f1fbeb408a7.png"},"department":{"id":3,"key":3,"name":"\u5546\u52a1\u90e8"}},"attachment":{},"attachmentRelationships":[],"files":[{"id":57229,"object_type":103,"object_id":2740,"attachment_id":32420,"attachment":{"id":32420,"key":32420,"name":"1dac9cf2-7905-3e84-941b-f55a67614174","extension":"pdf","path":"\/vue\/attachment\/view\/1dac9cf2-7905-3e84-941b-f55a67614174\/dzfp_26112000001066499986_\u4e2d\u56fd\u7f51\u7edc\u5b89\u5168\u5ba1\u67e5\u8ba4\u8bc1\u548c\u5e02\u573a\u76d1\u7ba1\u5927\u6570\u636e\u4e2d\u5fc3_20260319143911.pdf","orig_name":"dzfp_26112000001066499986_\u4e2d\u56fd\u7f51\u7edc\u5b89\u5168\u5ba1\u67e5\u8ba4\u8bc1\u548c\u5e02\u573a\u76d1\u7ba1\u5927\u6570\u636e\u4e2d\u5fc3_20260319143911.pdf"}}],"contract":{"id":4434,"key":4434,"serial_no":"100202539818","supplier_id":761,"supplier":{"id":761,"key":761,"name":"\u4e2d\u56fd\u7f51\u7edc\u5b89\u5168\u5ba1\u6838\u8ba4\u8bc1\u548c\u5e02\u573a\u76d1\u7ba1\u5927\u6570\u636e\u4e2d\u5fc3"}},"supplier":{"id":761,"key":761,"name":"\u4e2d\u56fd\u7f51\u7edc\u5b89\u5168\u5ba1\u6838\u8ba4\u8bc1\u548c\u5e02\u573a\u76d1\u7ba1\u5927\u6570\u636e\u4e2d\u5fc3"},"purchaseInvoiceProjects":[],"purchaseInvoiceReminders":[],"purchaseInvoiceProducts":[{"id":3089,"purchase_invoice_id":2740,"title":"\u65e0","description":"*\u9274\u8bc1\u54a8\u8be2\u670d\u52a1*\u8ba4\u8bc1\u8d39","number":"1","outbound":"0","inventory":"0","unit":"\u4e2a","amount":"12000","tax_rate":"3","including_tax":"0","excluding_tax":"11650.49","tax_amount":"349.51","into_inventory":false,"newProduct":[],"matchSalesInvoice":[]}],"coverInvoices":[],"cancelInvoice":{},"redInvoice":{},"invoice_type_display":"\u6570\u7535\u4e13\u7968","including_tax":0,"number":1,"outbound":0,"un_used_amount":0,"tax_rate":["3"],"purchaseInvoiceProductList":[{"tax_rate":3,"amount":12000,"excluding_tax":11650.49,"tax_amount":349.51,"list":[{"id":3089,"purchase_invoice_id":2740,"title":"\u65e0","description":"*\u9274\u8bc1\u54a8\u8be2\u670d\u52a1*\u8ba4\u8bc1\u8d39","number":"1","outbound":"0","inventory":"0","unit":"\u4e2a","amount":"12000","tax_rate":"3","including_tax":"0","excluding_tax":"11650.49","tax_amount":"349.51","into_inventory":false,"newProduct":[],"matchSalesInvoice":[]}]}],"can_update":true,"can_delete":true,"can_cancel":true,"can_re_cancel":false,"can_red_cancel":true,"can_new_invoice":false,"can_verify":true,"can_re_verify":false,"is_new":false},{"id":2741,"contract_id":4431,"amount":"500","attachment_id":"","from_date":"2026-03-18","created_by":5360,"created_at":"2026-03-19 16:14:29","description":"","invoice_num":"26112000001048274071","invoice_type":1,"handler":{"id":5360,"key":5360,"name":"\u5f20\u7ea2\u82b3","sex":"F","department_id":3},"is_verify":true,"is_cancel":false,"paid_amount":"500","tax_amount":"57.52","excluding_tax":"442.48","verify_at":"2026-05-12 00:00:00","is_used":true,"updated_at":"2026-03-19 16:15:51","cancel_description":"","cover_invoice_id":"","red_invoice_id":"","new_invoice_id":"","need_new_invoice":false,"is_draft":false,"is_settle":false,"supplier_id":59,"is_contract_cancel":false,"verify_time":"","createdBy":{"id":5360,"key":5360,"name":"\u5f20\u7ea2\u82b3","sex":"F","department_id":3,"avatar":{"id":153,"user_id":5360,"name":"\/files\/cdn\/a57be577deb434\/avatar\/612c2410-e800-3507-aa05-3f1fbeb408a7.png"},"department":{"id":3,"key":3,"name":"\u5546\u52a1\u90e8"}},"attachment":{},"attachmentRelationships":[],"files":[{"id":57233,"object_type":103,"object_id":2741,"attachment_id":32422,"attachment":{"id":32422,"key":32422,"name":"de14ad33-a2bb-394f-b29e-10c81eff644b","extension":"pdf","path":"\/vue\/attachment\/view\/de14ad33-a2bb-394f-b29e-10c81eff644b\/\u53d1\u7968-\u5317\u4eac\u62d3\u5b9e\u79d1\u6280\u6709\u9650\u516c\u53f83.18\uff08500\u5143\uff09.pdf","orig_name":"\u53d1\u7968-\u5317\u4eac\u62d3\u5b9e\u79d1\u6280\u6709\u9650\u516c\u53f83.18\uff08500\u5143\uff09.pdf"}}],"contract":{"id":4431,"key":4431,"serial_no":"TSKJ20260228-HYF-03","supplier_id":59,"supplier":{"id":59,"key":59,"name":"\u5317\u4eac\u592a\u8c37\u8baf\u8bda\u79d1\u6280\u53d1\u5c55\u6709\u9650\u516c\u53f8"}},"supplier":{"id":59,"key":59,"name":"\u5317\u4eac\u592a\u8c37\u8baf\u8bda\u79d1\u6280\u53d1\u5c55\u6709\u9650\u516c\u53f8"},"purchaseInvoiceProjects":[{"id":2886,"purchase_invoice_id":2741,"project_id":4121,"project":{"id":4121,"key":4121,"name":"\u786c\u76d8\u786c\u76d8-HP P2000-SAS 450GB-20260227","client_id":2021,"client":{"id":2021,"key":2021,"name":"\u65b0\u7586\u535a\u4f17\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8"}}}],"purchaseInvoiceReminders":[],"purchaseInvoiceProducts":[{"id":3090,"purchase_invoice_id":2741,"title":"450G","description":"*\u8ba1\u7b97\u673a\u5916\u90e8\u8bbe\u5907*\u786c\u76d8","number":"1","outbound":"1","inventory":"0","unit":"\u5757","amount":"500","tax_rate":"13","including_tax":"0","excluding_tax":"442.48","tax_amount":"57.52","into_inventory":true,"newProduct":[],"matchSalesInvoice":[]}],"coverInvoices":[],"cancelInvoice":{},"redInvoice":{},"invoice_type_display":"\u6570\u7535\u4e13\u7968","including_tax":0,"number":1,"outbound":1,"un_used_amount":0,"tax_rate":["13"],"purchaseInvoiceProductList":[{"tax_rate":13,"amount":500,"excluding_tax":442.48,"tax_amount":57.52,"list":[{"id":3090,"purchase_invoice_id":2741,"title":"450G","description":"*\u8ba1\u7b97\u673a\u5916\u90e8\u8bbe\u5907*\u786c\u76d8","number":"1","outbound":"1","inventory":"0","unit":"\u5757","amount":"500","tax_rate":"13","including_tax":"0","excluding_tax":"442.48","tax_amount":"57.52","into_inventory":true,"newProduct":[],"matchSalesInvoice":[]}]}],"can_update":true,"can_delete":true,"can_cancel":true,"can_re_cancel":false,"can_red_cancel":true,"can_new_invoice":false,"can_verify":false,"can_re_verify":true,"is_new":false},{"id":2739,"contract_id":4420,"amount":"2110.34","attachment_id":"","from_date":"2026-03-16","created_by":5360,"created_at":"2026-03-17 09:29:16","description":"","invoice_num":"26112000001017670621","invoice_type":1,"handler":{"id":5360,"key":5360,"name":"\u5f20\u7ea2\u82b3","sex":"F","department_id":3},"is_verify":false,"is_cancel":false,"paid_amount":"0","tax_amount":"242.78","excluding_tax":"1867.56","verify_at":"","is_used":false,"updated_at":"2026-03-17 09:32:46","cancel_description":"","cover_invoice_id":"","red_invoice_id":"","new_invoice_id":"","need_new_invoice":false,"is_draft":false,"is_settle":false,"supplier_id":757,"is_contract_cancel":false,"verify_time":"","createdBy":{"id":5360,"key":5360,"name":"\u5f20\u7ea2\u82b3","sex":"F","department_id":3,"avatar":{"id":153,"user_id":5360,"name":"\/files\/cdn\/a57be577deb434\/avatar\/612c2410-e800-3507-aa05-3f1fbeb408a7.png"},"department":{"id":3,"key":3,"name":"\u5546\u52a1\u90e8"}},"attachment":{},"attachmentRelationships":[],"files":[{"id":57206,"object_type":103,"object_id":2739,"attachment_id":32390,"attachment":{"id":32390,"key":32390,"name":"925effca-d85f-3d8e-9aa8-e0f3e37d36e3","extension":"pdf","path":"\/vue\/attachment\/view\/925effca-d85f-3d8e-9aa8-e0f3e37d36e3\/20260316_\u5317\u4eac\u62d3\u5b9e\u79d1\u6280\u6709\u9650\u516c\u53f8_26112000001017670621_2110.34.pdf","orig_name":"20260316_\u5317\u4eac\u62d3\u5b9e\u79d1\u6280\u6709\u9650\u516c\u53f8_26112000001017670621_2110.34.pdf"}}],"contract":{"id":4420,"key":4420,"serial_no":"20260226","supplier_id":757,"supplier":{"id":757,"key":757,"name":"\u5317\u4eac\u4eac\u4fe1\u670d\u79d1\u6280\u6709\u9650\u516c\u53f8"}},"supplier":{"id":757,"key":757,"name":"\u5317\u4eac\u4eac\u4fe1\u670d\u79d1\u6280\u6709\u9650\u516c\u53f8"},"purchaseInvoiceProjects":[{"id":2884,"purchase_invoice_id":2739,"project_id":4103,"project":{"id":4103,"key":4103,"name":"2026\u6df1\u4fe1\u670d\u9632\u706b\u5899\u7eed\u4fdd","client_id":79,"client":{"id":79,"key":79,"name":"\u5317\u4eac\u79c0\u6c34\u8857\u7535\u5b50\u5546\u52a1\u6709\u9650\u516c\u53f8(\u5317\u4eac\u79c0\u6c34\u8857\u5e02\u573a\u6709\u9650\u516c\u53f8)"}}}],"purchaseInvoiceReminders":[],"purchaseInvoiceProducts":[{"id":3087,"purchase_invoice_id":2739,"title":"\u9002\u7528\u4e8eAF-1000-B1180","description":"*\u8f6f\u4ef6*\u6df1\u4fe1\u670d\u7f51\u5173\u6740\u6bd2\u8f6f\u4ef6V6.0","number":"1","outbound":"0","inventory":"1","unit":"\u5957","amount":"1055.17","tax_rate":"13","including_tax":"0","excluding_tax":"933.78","tax_amount":"121.39","into_inventory":true,"newProduct":[],"matchSalesInvoice":[]},{"id":3088,"purchase_invoice_id":2739,"title":"\u9002\u7528\u4e8eAF-1000-B1180","description":"*\u8f6f\u4ef6*\u6df1\u4fe1\u670d\u5b89\u5168\u4e91\u8111-\u4e91\u667a\u8ba2\u9605\u8f6f\u4ef6V8.0","number":"1","outbound":"0","inventory":"1","unit":"\u5957","amount":"1055.17","tax_rate":"13","including_tax":"0","excluding_tax":"933.78","tax_amount":"121.39","into_inventory":true,"newProduct":[],"matchSalesInvoice":[]}],"coverInvoices":[],"cancelInvoice":{},"redInvoice":{},"invoice_type_display":"\u6570\u7535\u4e13\u7968","including_tax":0,"number":2,"outbound":0,"un_used_amount":2110.34,"tax_rate":["13"],"purchaseInvoiceProductList":[{"tax_rate":13,"amount":2110.34,"excluding_tax":1867.56,"tax_amount":242.78,"list":[{"id":3087,"purchase_invoice_id":2739,"title":"\u9002\u7528\u4e8eAF-1000-B1180","description":"*\u8f6f\u4ef6*\u6df1\u4fe1\u670d\u7f51\u5173\u6740\u6bd2\u8f6f\u4ef6V6.0","number":"1","outbound":"0","inventory":"1","unit":"\u5957","amount":"1055.17","tax_rate":"13","including_tax":"0","excluding_tax":"933.78","tax_amount":"121.39","into_inventory":true,"newProduct":[],"matchSalesInvoice":[]},{"id":3088,"purchase_invoice_id":2739,"title":"\u9002\u7528\u4e8eAF-1000-B1180","description":"*\u8f6f\u4ef6*\u6df1\u4fe1\u670d\u5b89\u5168\u4e91\u8111-\u4e91\u667a\u8ba2\u9605\u8f6f\u4ef6V8.0","number":"1","outbound":"0","inventory":"1","unit":"\u5957","amount":"1055.17","tax_rate":"13","including_tax":"0","excluding_tax":"933.78","tax_amount":"121.39","into_inventory":true,"newProduct":[],"matchSalesInvoice":[]}]}],"can_update":true,"can_delete":true,"can_cancel":true,"can_re_cancel":false,"can_red_cancel":true,"can_new_invoice":false,"can_verify":true,"can_re_verify":false,"is_new":false},{"id":2738,"contract_id":4420,"amount":"1318.96","attachment_id":"","from_date":"2026-03-16","created_by":5360,"created_at":"2026-03-17 09:28:53","description":"","invoice_num":"26112000001018068811","invoice_type":1,"handler":{"id":5360,"key":5360,"name":"\u5f20\u7ea2\u82b3","sex":"F","department_id":3},"is_verify":false,"is_cancel":false,"paid_amount":"0","tax_amount":"74.66","excluding_tax":"1244.3","verify_at":"","is_used":false,"updated_at":"2026-03-17 09:31:26","cancel_description":"","cover_invoice_id":"","red_invoice_id":"","new_invoice_id":"","need_new_invoice":false,"is_draft":false,"is_settle":false,"supplier_id":757,"is_contract_cancel":false,"verify_time":"","createdBy":{"id":5360,"key":5360,"name":"\u5f20\u7ea2\u82b3","sex":"F","department_id":3,"avatar":{"id":153,"user_id":5360,"name":"\/files\/cdn\/a57be577deb434\/avatar\/612c2410-e800-3507-aa05-3f1fbeb408a7.png"},"department":{"id":3,"key":3,"name":"\u5546\u52a1\u90e8"}},"attachment":{},"attachmentRelationships":[],"files":[{"id":57205,"object_type":103,"object_id":2738,"attachment_id":32389,"attachment":{"id":32389,"key":32389,"name":"be4078ab-1db4-3e6c-a024-da6eec8e7073","extension":"pdf","path":"\/vue\/attachment\/view\/be4078ab-1db4-3e6c-a024-da6eec8e7073\/20260316_\u5317\u4eac\u62d3\u5b9e\u79d1\u6280\u6709\u9650\u516c\u53f8_26112000001018068811_1318.96.pdf","orig_name":"20260316_\u5317\u4eac\u62d3\u5b9e\u79d1\u6280\u6709\u9650\u516c\u53f8_26112000001018068811_1318.96.pdf"}}],"contract":{"id":4420,"key":4420,"serial_no":"20260226","supplier_id":757,"supplier":{"id":757,"key":757,"name":"\u5317\u4eac\u4eac\u4fe1\u670d\u79d1\u6280\u6709\u9650\u516c\u53f8"}},"supplier":{"id":757,"key":757,"name":"\u5317\u4eac\u4eac\u4fe1\u670d\u79d1\u6280\u6709\u9650\u516c\u53f8"},"purchaseInvoiceProjects":[{"id":2883,"purchase_invoice_id":2738,"project_id":4103,"project":{"id":4103,"key":4103,"name":"2026\u6df1\u4fe1\u670d\u9632\u706b\u5899\u7eed\u4fdd","client_id":79,"client":{"id":79,"key":79,"name":"\u5317\u4eac\u79c0\u6c34\u8857\u7535\u5b50\u5546\u52a1\u6709\u9650\u516c\u53f8(\u5317\u4eac\u79c0\u6c34\u8857\u5e02\u573a\u6709\u9650\u516c\u53f8)"}}}],"purchaseInvoiceReminders":[],"purchaseInvoiceProducts":[{"id":3086,"purchase_invoice_id":2738,"title":"","description":"*\u8f6f\u4ef6\u7ef4\u62a4\u670d\u52a1*\u7f51\u7edc\u670d\u52a1\u8d39","number":"1","outbound":"0","inventory":"1","unit":"\u6b21","amount":"1318.96","tax_rate":"6","including_tax":"0","excluding_tax":"1244.3","tax_amount":"74.66","into_inventory":true,"newProduct":[],"matchSalesInvoice":[]}],"coverInvoices":[],"cancelInvoice":{},"redInvoice":{},"invoice_type_display":"\u6570\u7535\u4e13\u7968","including_tax":0,"number":1,"outbound":0,"un_used_amount":1318.96,"tax_rate":["6"],"purchaseInvoiceProductList":[{"tax_rate":6,"amount":1318.96,"excluding_tax":1244.3,"tax_amount":74.66,"list":[{"id":3086,"purchase_invoice_id":2738,"title":"","description":"*\u8f6f\u4ef6\u7ef4\u62a4\u670d\u52a1*\u7f51\u7edc\u670d\u52a1\u8d39","number":"1","outbound":"0","inventory":"1","unit":"\u6b21","amount":"1318.96","tax_rate":"6","including_tax":"0","excluding_tax":"1244.3","tax_amount":"74.66","into_inventory":true,"newProduct":[],"matchSalesInvoice":[]}]}],"can_update":true,"can_delete":true,"can_cancel":true,"can_re_cancel":false,"can_red_cancel":true,"can_new_invoice":false,"can_verify":true,"can_re_verify":false,"is_new":false},{"id":2737,"contract_id":4421,"amount":"3532","attachment_id":"","from_date":"2026-03-16","created_by":5360,"created_at":"2026-03-17 09:28:27","description":"","invoice_num":"26112000001017937876","invoice_type":1,"handler":{"id":5360,"key":5360,"name":"\u5f20\u7ea2\u82b3","sex":"F","department_id":3},"is_verify":false,"is_cancel":false,"paid_amount":"0","tax_amount":"199.92","excluding_tax":"3332.08","verify_at":"","is_used":false,"updated_at":"2026-03-17 09:30:19","cancel_description":"","cover_invoice_id":"","red_invoice_id":"","new_invoice_id":"","need_new_invoice":false,"is_draft":false,"is_settle":false,"supplier_id":757,"is_contract_cancel":false,"verify_time":"","createdBy":{"id":5360,"key":5360,"name":"\u5f20\u7ea2\u82b3","sex":"F","department_id":3,"avatar":{"id":153,"user_id":5360,"name":"\/files\/cdn\/a57be577deb434\/avatar\/612c2410-e800-3507-aa05-3f1fbeb408a7.png"},"department":{"id":3,"key":3,"name":"\u5546\u52a1\u90e8"}},"attachment":{},"attachmentRelationships":[],"files":[{"id":57204,"object_type":103,"object_id":2737,"attachment_id":32388,"attachment":{"id":32388,"key":32388,"name":"87278e3c-362e-318a-8a84-ed29c368e6b4","extension":"pdf","path":"\/vue\/attachment\/view\/87278e3c-362e-318a-8a84-ed29c368e6b4\/20260316_\u5317\u4eac\u62d3\u5b9e\u79d1\u6280\u6709\u9650\u516c\u53f8_26112000001017937876_3532.00.pdf","orig_name":"20260316_\u5317\u4eac\u62d3\u5b9e\u79d1\u6280\u6709\u9650\u516c\u53f8_26112000001017937876_3532.00.pdf"}}],"contract":{"id":4421,"key":4421,"serial_no":"BJ20260226","supplier_id":757,"supplier":{"id":757,"key":757,"name":"\u5317\u4eac\u4eac\u4fe1\u670d\u79d1\u6280\u6709\u9650\u516c\u53f8"}},"supplier":{"id":757,"key":757,"name":"\u5317\u4eac\u4eac\u4fe1\u670d\u79d1\u6280\u6709\u9650\u516c\u53f8"},"purchaseInvoiceProjects":[{"id":2882,"purchase_invoice_id":2737,"project_id":4103,"project":{"id":4103,"key":4103,"name":"2026\u6df1\u4fe1\u670d\u9632\u706b\u5899\u7eed\u4fdd","client_id":79,"client":{"id":79,"key":79,"name":"\u5317\u4eac\u79c0\u6c34\u8857\u7535\u5b50\u5546\u52a1\u6709\u9650\u516c\u53f8(\u5317\u4eac\u79c0\u6c34\u8857\u5e02\u573a\u6709\u9650\u516c\u53f8)"}}}],"purchaseInvoiceReminders":[],"purchaseInvoiceProducts":[{"id":3085,"purchase_invoice_id":2737,"title":"","description":"*\u4fe1\u606f\u7cfb\u7edf\u670d\u52a1*\u4e92\u8054\u7f51\u5b89\u5168\u8bbf\u95ee\u670d\u52a1\u8d39","number":"1","outbound":"0","inventory":"1","unit":"\u9879","amount":"3532","tax_rate":"6","including_tax":"0","excluding_tax":"3332.08","tax_amount":"199.92","into_inventory":true,"newProduct":[],"matchSalesInvoice":[]}],"coverInvoices":[],"cancelInvoice":{},"redInvoice":{},"invoice_type_display":"\u6570\u7535\u4e13\u7968","including_tax":0,"number":1,"outbound":0,"un_used_amount":3532,"tax_rate":["6"],"purchaseInvoiceProductList":[{"tax_rate":6,"amount":3532,"excluding_tax":3332.08,"tax_amount":199.92,"list":[{"id":3085,"purchase_invoice_id":2737,"title":"","description":"*\u4fe1\u606f\u7cfb\u7edf\u670d\u52a1*\u4e92\u8054\u7f51\u5b89\u5168\u8bbf\u95ee\u670d\u52a1\u8d39","number":"1","outbound":"0","inventory":"1","unit":"\u9879","amount":"3532","tax_rate":"6","including_tax":"0","excluding_tax":"3332.08","tax_amount":"199.92","into_inventory":true,"newProduct":[],"matchSalesInvoice":[]}]}],"can_update":true,"can_delete":true,"can_cancel":true,"can_re_cancel":false,"can_red_cancel":true,"can_new_invoice":false,"can_verify":true,"can_re_verify":false,"is_new":false},{"id":2736,"contract_id":4436,"amount":"2500","attachment_id":"","from_date":"2026-03-16","created_by":1011,"created_at":"2026-03-16 17:27:39","description":"","invoice_num":"26112000001016483596","invoice_type":2,"handler":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","department_id":3},"is_verify":false,"is_cancel":false,"paid_amount":"2500","tax_amount":"24.75","excluding_tax":"2475.25","verify_at":"","is_used":false,"updated_at":"2026-03-16 17:30:18","cancel_description":"","cover_invoice_id":"","red_invoice_id":"","new_invoice_id":"","need_new_invoice":false,"is_draft":false,"is_settle":false,"supplier_id":487,"is_contract_cancel":false,"verify_time":"","createdBy":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","department_id":3,"avatar":{"id":17,"user_id":1011,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b54747f4-248d-380e-93bc-0f62f769e70d.png"},"department":{"id":3,"key":3,"name":"\u5546\u52a1\u90e8"}},"attachment":{},"attachmentRelationships":[],"files":[{"id":57196,"object_type":103,"object_id":2736,"attachment_id":32385,"attachment":{"id":32385,"key":32385,"name":"450cac0a-f870-35af-84c1-20c8b144fd6c","extension":"pdf","path":"\/vue\/attachment\/view\/450cac0a-f870-35af-84c1-20c8b144fd6c\/dzfp_26112000001016483596_\u5317\u4eac\u6613\u540c\u4fe1\u548c\u4fe1\u606f\u670d\u52a1\u6709\u9650\u516c\u53f8_20260316165709.pdf","orig_name":"dzfp_26112000001016483596_\u5317\u4eac\u6613\u540c\u4fe1\u548c\u4fe1\u606f\u670d\u52a1\u6709\u9650\u516c\u53f8_20260316165709.pdf"}}],"contract":{"id":4436,"key":4436,"serial_no":"TSKJ20260310-HYF-01","supplier_id":487,"supplier":{"id":487,"key":487,"name":"\u5317\u4eac\u6613\u540c\u4fe1\u548c\u4fe1\u606f\u670d\u52a1\u6709\u9650\u516c\u53f8"}},"supplier":{"id":487,"key":487,"name":"\u5317\u4eac\u6613\u540c\u4fe1\u548c\u4fe1\u606f\u670d\u52a1\u6709\u9650\u516c\u53f8"},"purchaseInvoiceProjects":[],"purchaseInvoiceReminders":[],"purchaseInvoiceProducts":[{"id":3084,"purchase_invoice_id":2736,"title":"","description":"*\u77e5\u8bc6\u4ea7\u6743\u670d\u52a1*\u77e5\u8bc6\u4ea7\u6743\u670d\u52a1","number":"1","outbound":"0","inventory":"0","unit":"","amount":"2500","tax_rate":"1","including_tax":"0","excluding_tax":"2475.25","tax_amount":"24.75","into_inventory":false,"newProduct":[],"matchSalesInvoice":[]}],"coverInvoices":[],"cancelInvoice":{},"redInvoice":{},"invoice_type_display":"\u6570\u7535\u666e\u7968","including_tax":0,"number":1,"outbound":0,"un_used_amount":0,"tax_rate":["1"],"purchaseInvoiceProductList":[{"tax_rate":1,"amount":2500,"excluding_tax":2475.25,"tax_amount":24.75,"list":[{"id":3084,"purchase_invoice_id":2736,"title":"","description":"*\u77e5\u8bc6\u4ea7\u6743\u670d\u52a1*\u77e5\u8bc6\u4ea7\u6743\u670d\u52a1","number":"1","outbound":"0","inventory":"0","unit":"","amount":"2500","tax_rate":"1","including_tax":"0","excluding_tax":"2475.25","tax_amount":"24.75","into_inventory":false,"newProduct":[],"matchSalesInvoice":[]}]}],"can_update":true,"can_delete":true,"can_cancel":true,"can_re_cancel":false,"can_red_cancel":true,"can_new_invoice":false,"can_verify":false,"can_re_verify":false,"is_new":false}],"can_create":true,"count":{"count":933,"amount":"97736773.15","excluding_tax":"86881812.89","tax_amount":"10565780.15","verify_amount":"96119189.02","un_verify_amount":"1328404.02","un_verify_count":185,"verify_count":670},"pagenation":{"totalcount":933,"thispage":1,"pagesize":20}},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","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-02 14:53:35', 72817152) RETURNING "id"
14:53:35.0681.7 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_purchase_invoice_projects" WHERE "purchase_invoice_id" IN (2756, 2754, 2753, 2752, 2751, 2750, 2749, 2748, 2747, 2746, 2745, 2744, 2742, 2743, 2740, 2741, 2739, 2738, 2737, 2736)
14:53:35.0721.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_purchase_invoice_products" WHERE "purchase_invoice_id" IN (2756, 2754, 2753, 2752, 2751, 2750, 2749, 2748, 2747, 2746, 2745, 2744, 2742, 2743, 2740, 2741, 2739, 2738, 2737, 2736)
14:53:35.0541.1 msyii\db\Command::querySELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (1001, 1011, 5360)
14:53:35.0281.0 msyii\db\Command::querySELECT * FROM "global"."vw_user_login" WHERE "id"=1001
14:53:35.0750.9 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_purchase_contract_invoices" WHERE "red_invoice_id" IN (2756, 2754, 2753, 2752, 2751, 2750, 2749, 2748, 2747, 2746, 2745, 2744, 2742, 2743, 2740, 2741, 2739, 2738, 2737, 2736)
14:53:35.0760.8 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_purchase_contract_invoices" WHERE "new_invoice_id" IN (2756, 2754, 2753, 2752, 2751, 2750, 2749, 2748, 2747, 2746, 2745, 2744, 2742, 2743, 2740, 2741, 2739, 2738, 2737, 2736)
14:53:35.0740.8 msyii\db\Command::querySELECT "id", "cover_invoice_id" FROM "a57be577deb434"."tbl_purchase_contract_invoices" WHERE "cover_invoice_id" IN (2756, 2754, 2753, 2752, 2751, 2750, 2749, 2748, 2747, 2746, 2745, 2744, 2742, 2743, 2740, 2741, 2739, 2738, 2737, 2736) ORDER BY "id" DESC
14:53:35.0560.8 msyii\db\Command::querySELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id" IN (1001, 1011, 5360))
14:53:35.0620.6 msyii\db\Command::querySELECT "id", "id" AS "key", "name", "extension", "path", "orig_name" FROM "a57be577deb434"."tbl_attachments" WHERE "id"=32668
14:53:35.0570.5 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_departments" WHERE "id" IN (4, 3)
14:53:35.0320.5 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
14:53:35.0670.4 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_suppliers" WHERE "id" IN (761, 701, 59, 686, 757, 762, 262, 46, 763, 487, 431)
14:53:35.0660.4 msyii\db\Command::querySELECT "id", "id" AS "key", "name", "extension", "path", "orig_name" FROM "a57be577deb434"."tbl_attachments" WHERE "id" IN (32385, 32388, 32389, 32390, 32420, 32422, 32459, 32460, 32487, 32485, 32484, 32483, 32497, 32551, 32555, 32557)
14:53:35.0710.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_purchase_invoice_reminders" WHERE "purchase_invoice_id" IN (2756, 2754, 2753, 2752, 2751, 2750, 2749, 2748, 2747, 2746, 2745, 2744, 2742, 2743, 2740, 2741, 2739, 2738, 2737, 2736)
14:53:35.0660.4 msyii\db\Command::querySELECT "id", "id" AS "key", "serial_no", "supplier_id" FROM "a57be577deb434"."tbl_purchase_contracts" WHERE "id" IN (4466, 4437, 4447, 4439, 4435, 4442, 4441, 4440, 4434, 4431, 4420, 4421, 4436)
14:53:35.0700.3 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_clients" WHERE "id" IN (79, 2032, 2021, 3286, 3359, 2125)
14:53:35.0700.3 msyii\db\Command::querySELECT "id", "id" AS "key", "project_title" AS "name", "client_id" FROM "a57be577deb434"."tbl_projects" WHERE "id" IN (4103, 4121, 4113, 4130, 4077, 4142)
14:53:35.0670.3 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_suppliers" WHERE "id" IN (431, 762, 46, 701, 686, 763, 262, 761, 59, 757, 487)
14:53:35.0730.3 msyii\db\Command::querySELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (1011, 5360)
14:53:35.0270.2 msyii\db\Connection::openOpening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta