ConfigurationRequestLogsProfilingDatabaseAsset BundlesMailTimeline
6a424252a7cb8: POST https://beta.jinchangxiao.com/vue/tax/purchase-invoice-list at 2026-06-29 06:00:50 pm by 221.216.117.25

Database Queries

总计30条数据
TimeDurationTypeQuery
  
18:00:50.70013.4 msSELECTSELECT * FROM "global"."vw_user_login" WHERE "id"=1001

[+] Explain
18:00:50.7232.0 msSELECTSELECT * FROM "global"."vw_user_login" WHERE "id"=1001

[+] Explain
18:00:50.7270.6 msSELECTSELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001

[+] Explain
18:00:50.81823.6 msSELECTSELECT 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"."is_verify"=TRUE) AND (("pci"."verify_at" >= '2026-05-01 00:00:00') AND ("pci"."verify_at" <= '2026-05-31 23:59:59')) 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"

[+] Explain
18:00:50.8422.8 msSELECTSELECT 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"."is_verify"=TRUE) AND (("pci"."verify_at" >= '2026-05-01 00:00:00') AND ("pci"."verify_at" <= '2026-05-31 23:59:59')) 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

[+] Explain
18:00:50.8480.6 msSELECTSELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (1001, 5360, 1011)

[+] Explain
18:00:50.8520.4 msSELECTSELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id" IN (1001, 5360, 1011))

[+] Explain
18:00:50.8520.6 msSELECTSELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_departments" WHERE "id" IN (4, 3)

[+] Explain
18:00:50.8533.7 msSELECTSELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=21) AND ("object_id" IN (2754, 2753, 2752, 2750, 2741, 2734, 2727))

[+] Explain
18:00:50.8571.4 msSELECTSELECT "id", "id" AS "key", "name", "extension", "path", "orig_name" FROM "a57be577deb434"."tbl_attachments" WHERE "id"=32668

[+] Explain
18:00:50.8593.5 msSELECTSELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=103) AND ("object_id" IN (2754, 2753, 2752, 2750, 2741, 2734, 2727))

[+] Explain
18:00:50.8638.3 msSELECTSELECT "id", "id" AS "key", "name", "extension", "path", "orig_name" FROM "a57be577deb434"."tbl_attachments" WHERE "id" IN (31861, 32276, 32422, 32555)

[+] Explain
18:00:50.8720.4 msSELECTSELECT "id", "id" AS "key", "serial_no", "supplier_id" FROM "a57be577deb434"."tbl_purchase_contracts" WHERE "id" IN (4437, 4447, 4435, 4431, 4432, 4406)

[+] Explain
18:00:50.8720.4 msSELECTSELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_suppliers" WHERE "id" IN (757, 59, 686, 762, 46)

[+] Explain
18:00:50.8730.3 msSELECTSELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_suppliers" WHERE "id" IN (762, 46, 686, 59, 757)

[+] Explain
18:00:50.8740.5 msSELECTSELECT * FROM "a57be577deb434"."tbl_purchase_invoice_projects" WHERE "purchase_invoice_id" IN (2754, 2753, 2752, 2750, 2741, 2734, 2727)

[+] Explain
18:00:50.8740.3 msSELECTSELECT "id", "id" AS "key", "project_title" AS "name", "client_id" FROM "a57be577deb434"."tbl_projects" WHERE "id" IN (4094, 4124, 4121, 4130, 4142)

[+] Explain
18:00:50.8752.5 msSELECTSELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_clients" WHERE "id" IN (12, 3448, 2021, 3286, 2032)

[+] Explain
18:00:50.8784.8 msSELECTSELECT * FROM "a57be577deb434"."tbl_purchase_invoice_reminders" WHERE "purchase_invoice_id" IN (2754, 2753, 2752, 2750, 2741, 2734, 2727)

[+] Explain
18:00:50.8833.1 msSELECTSELECT * FROM "a57be577deb434"."tbl_purchase_invoice_products" WHERE "purchase_invoice_id" IN (2754, 2753, 2752, 2750, 2741, 2734, 2727)

[+] Explain
18:00:50.8860.3 msSELECTSELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (5360, 1011)

[+] Explain
18:00:50.8870.8 msSELECTSELECT "id", "cover_invoice_id" FROM "a57be577deb434"."tbl_purchase_contract_invoices" WHERE "cover_invoice_id" IN (2754, 2753, 2752, 2750, 2741, 2734, 2727) ORDER BY "id" DESC

[+] Explain
18:00:50.8870.8 msSELECTSELECT * FROM "a57be577deb434"."tbl_purchase_contract_invoices" WHERE "red_invoice_id" IN (2754, 2753, 2752, 2750, 2741, 2734, 2727)

[+] Explain
18:00:50.8880.7 msSELECTSELECT * FROM "a57be577deb434"."tbl_purchase_contract_invoices" WHERE "new_invoice_id" IN (2754, 2753, 2752, 2750, 2741, 2734, 2727)

[+] Explain
18:00:50.8962.7 msSELECTSELECT 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"."is_verify"=TRUE) AND (("pci"."verify_at" >= '2026-05-01 00:00:00') AND ("pci"."verify_at" <= '2026-05-31 23:59:59')) AND (("pci"."from_date" >= '2024-08-01 00:00') OR ("pci"."is_draft"=FALSE)) GROUP BY "pci"."id")

[+] Explain
18:00:50.8992.5 msSELECTSELECT 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"."is_verify"=TRUE) AND (("pci"."verify_at" >= '2026-05-01 00:00:00') AND ("pci"."verify_at" <= '2026-05-31 23:59:59')) AND (("pci"."from_date" >= '2024-08-01 00:00') OR ("pci"."is_draft"=FALSE)) GROUP BY "pci"."id")

[+] Explain
18:00:50.9022.3 msSELECTSELECT 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"."is_verify"=TRUE) AND (("pci"."verify_at" >= '2026-05-01 00:00:00') AND ("pci"."verify_at" <= '2026-05-31 23:59:59')) AND (("pci"."from_date" >= '2024-08-01 00:00') OR ("pci"."is_draft"=FALSE)) GROUP BY "pci"."id")

[+] Explain
18:00:50.9042.2 msSELECTSELECT 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"."is_verify"=TRUE) AND (("pci"."verify_at" >= '2026-05-01 00:00:00') AND ("pci"."verify_at" <= '2026-05-31 23:59:59')) AND (("pci"."from_date" >= '2024-08-01 00:00') OR ("pci"."is_draft"=FALSE)) GROUP BY "pci"."id")

[+] Explain
18:00:50.9072.5 msSELECTSELECT 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"."is_verify"=TRUE) AND (("pci"."verify_at" >= '2026-05-01 00:00:00') AND ("pci"."verify_at" <= '2026-05-31 23:59:59')) AND (("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"

[+] Explain
18:00:50.9122.8 msINSERTINSERT 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":"lastmonth","is_verify":"1","outbound":"","is_cancel":"","is_draft":"","is_contract_cancel":"","keyword":""},"page":"1","web_access_token":"G2-mdsiVx4ajd063Zd6C9RL7pLl9o1cd"}', '{"code":2000,"result":{"list":[{"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":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":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":2734,"contract_id":4432,"amount":"1661.92","attachment_id":"","from_date":"2026-03-10","created_by":1011,"created_at":"2026-03-10 17:25:13","description":"","invoice_num":"26112000000926436031","invoice_type":1,"handler":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","department_id":3},"is_verify":true,"is_cancel":false,"paid_amount":"1661.92","tax_amount":"94.07","excluding_tax":"1567.85","verify_at":"2026-05-12 00:00:00","is_used":true,"updated_at":"2026-03-10 17:26:09","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":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":56919,"object_type":103,"object_id":2734,"attachment_id":32276,"attachment":{"id":32276,"key":32276,"name":"72568700-02c6-3e91-ae75-8ce557cf8dae","extension":"pdf","path":"\/vue\/attachment\/view\/72568700-02c6-3e91-ae75-8ce557cf8dae\/20260310_\u5317\u4eac\u62d3\u5b9e\u79d1\u6280\u6709\u9650\u516c\u53f8_26112000000926436031_1661.92.pdf","orig_name":"20260310_\u5317\u4eac\u62d3\u5b9e\u79d1\u6280\u6709\u9650\u516c\u53f8_26112000000926436031_1661.92.pdf"}}],"contract":{"id":4432,"key":4432,"serial_no":"JXFKJ-20260304\/TSKJ","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":2876,"purchase_invoice_id":2734,"project_id":4124,"project":{"id":4124,"key":4124,"name":"\u6df1\u4fe1\u670d\u6258\u7ba1\u4e91\u65b0\u8d2d","client_id":3448,"client":{"id":3448,"key":3448,"name":"\u5317\u4eac\u5723\u5609\u5965\u5bb6\u5177\u6709\u9650\u516c\u53f8-\u91d1\u7545\u900d"}}}],"purchaseInvoiceReminders":[],"purchaseInvoiceProducts":[{"id":3082,"purchase_invoice_id":2734,"title":"","description":"*\u8f6f\u4ef6\u7ef4\u62a4\u670d\u52a1*\u7f51\u7edc\u670d\u52a1\u8d39","number":"1","outbound":"1","inventory":"0","unit":"\u6b21","amount":"1661.92","tax_rate":"6","including_tax":"0","excluding_tax":"1567.85","tax_amount":"94.07","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":["6"],"purchaseInvoiceProductList":[{"tax_rate":6,"amount":1661.92,"excluding_tax":1567.85,"tax_amount":94.07,"list":[{"id":3082,"purchase_invoice_id":2734,"title":"","description":"*\u8f6f\u4ef6\u7ef4\u62a4\u670d\u52a1*\u7f51\u7edc\u670d\u52a1\u8d39","number":"1","outbound":"1","inventory":"0","unit":"\u6b21","amount":"1661.92","tax_rate":"6","including_tax":"0","excluding_tax":"1567.85","tax_amount":"94.07","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":2727,"contract_id":4406,"amount":"37122","attachment_id":"","from_date":"2026-02-06","created_by":1011,"created_at":"2026-02-06 17:20:06","description":"","invoice_num":"26112000000503177311","invoice_type":1,"handler":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","department_id":3},"is_verify":true,"is_cancel":false,"paid_amount":"37122","tax_amount":"4270.67","excluding_tax":"32851.33","verify_at":"2026-05-12 00:00:00","is_used":true,"updated_at":"2026-02-06 17:21: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":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":56369,"object_type":103,"object_id":2727,"attachment_id":31861,"attachment":{"id":31861,"key":31861,"name":"146c3e3b-457a-30e8-b2dd-c60ba85fb320","extension":"pdf","path":"\/vue\/attachment\/view\/146c3e3b-457a-30e8-b2dd-c60ba85fb320\/20260206_\u5317\u4eac\u62d3\u5b9e\u79d1\u6280\u6709\u9650\u516c\u53f8_26112000000503177311_37122.00.pdf","orig_name":"20260206_\u5317\u4eac\u62d3\u5b9e\u79d1\u6280\u6709\u9650\u516c\u53f8_26112000000503177311_37122.00.pdf"}}],"contract":{"id":4406,"key":4406,"serial_no":"JXFKJ-20260202\/TSKJ","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":2866,"purchase_invoice_id":2727,"project_id":4094,"project":{"id":4094,"key":4094,"name":"\u6df1\u4fe1\u670d\u865a\u62df\u5316\u6388\u6743\u65b0\u8d2dPOCN26018145-2026","client_id":12,"client":{"id":12,"key":12,"name":"smc(\u4e2d\u56fd)\u6709\u9650\u516c\u53f8\/SMC(\u5317\u4eac)\u5236\u9020\u6709\u9650\u516c\u53f8"}}}],"purchaseInvoiceReminders":[],"purchaseInvoiceProducts":[{"id":3076,"purchase_invoice_id":2727,"title":"Base","description":"*\u8f6f\u4ef6*\u6df1\u4fe1\u670d\u8ba1\u7b97\u670d\u52a1\u5668\u865a\u62df\u5316\u8f6f\u4ef6V6.0","number":"6","outbound":"6","inventory":"0","unit":"\u5957","amount":"33747.18","tax_rate":"13","including_tax":"0","excluding_tax":"29864.76","tax_amount":"3882.42","into_inventory":true,"newProduct":[],"matchSalesInvoice":[]},{"id":3075,"purchase_invoice_id":2727,"title":"\/","description":"*\u8f6f\u4ef6*\u6df1\u4fe1\u670dSDDC\u57fa\u7840\u8fd0\u7ef4\u8f6f\u4ef6V1.0","number":"1","outbound":"1","inventory":"0","unit":"\u5957","amount":"3374.82","tax_rate":"13","including_tax":"0","excluding_tax":"2986.57","tax_amount":"388.25","into_inventory":true,"newProduct":[],"matchSalesInvoice":[]}],"coverInvoices":[],"cancelInvoice":{},"redInvoice":{},"invoice_type_display":"\u6570\u7535\u4e13\u7968","including_tax":0,"number":7,"outbound":7,"un_used_amount":0,"tax_rate":["13"],"purchaseInvoiceProductList":[{"tax_rate":13,"amount":37122,"excluding_tax":32851.33,"tax_amount":4270.67,"list":[{"id":3076,"purchase_invoice_id":2727,"title":"Base","description":"*\u8f6f\u4ef6*\u6df1\u4fe1\u670d\u8ba1\u7b97\u670d\u52a1\u5668\u865a\u62df\u5316\u8f6f\u4ef6V6.0","number":"6","outbound":"6","inventory":"0","unit":"\u5957","amount":"33747.18","tax_rate":"13","including_tax":"0","excluding_tax":"29864.76","tax_amount":"3882.42","into_inventory":true,"newProduct":[],"matchSalesInvoice":[]},{"id":3075,"purchase_invoice_id":2727,"title":"\/","description":"*\u8f6f\u4ef6*\u6df1\u4fe1\u670dSDDC\u57fa\u7840\u8fd0\u7ef4\u8f6f\u4ef6V1.0","number":"1","outbound":"1","inventory":"0","unit":"\u5957","amount":"3374.82","tax_rate":"13","including_tax":"0","excluding_tax":"2986.57","tax_amount":"388.25","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}],"can_create":true,"count":{"count":7,"amount":"161832.10","excluding_tax":"143339.69","tax_amount":"18492.41","verify_amount":"161832.10","un_verify_amount":0,"verify_count":7},"pagenation":{"totalcount":7,"thispage":1,"pagesize":20}},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}],"mod":0,"ip":"221.216.117.25","ua":"Mozilla\/5.0 (Macintosh; Intel Mac OS X 10.15; rv:152.0) Gecko\/20100101 Firefox\/152.0"}', FALSE, '2026-06-29 18:00:50', 217054976) RETURNING "id"

[+] Explain