Performance Profiling

Total processing time: 78 ms; Peak memory: 5.690 MB. Show Profiling Timeline

总计32条数据

Time	Duration	Category	Info

12:08:55.173	4.5 ms	yii\db\Command::query	SELECT 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"
12:08:55.217	3.7 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_visit_module_histories" WHERE ("user_id"=5252) AND ("object_type"=10004) AND ("visit_date"='2025-08-04')
12:08:55.178	3.4 ms	yii\db\Command::query	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 LIMIT 20
12:08:55.205	2.5 ms	yii\db\Command::query	SELECT 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")
12:08:55.202	2.5 ms	yii\db\Command::query	SELECT 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")
12:08:55.151	2.4 ms	yii\db\Connection::open	Opening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta
12:08:55.222	2.4 ms	yii\db\Command::query	INSERT INTO "global"."tbl_api_log" ("code", "schema", "user_id", "device_type", "url", "request", "response", "php_error", "time") VALUES (200, 'a57be577deb434', 5252, 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":""},"page":"1","web_access_token":"zd4K9tC1F9pL73eX9UTaEjjdfA981F9e"}', '{"code":2000,"result":{"list":[{"id":2382,"contract_id":4073,"amount":"1.00","attachment_id":"","from_date":"2025-08-04","created_by":5252,"created_at":"2025-08-04 11:58:22","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,"createdBy":{"id":5252,"key":5252,"name":"\u738b\u7b11\u7b11","sex":"F","department_id":6,"avatar":{"id":101,"user_id":5252,"name":"\/files\/cdn\/a57be577deb434\/avatar\/f5529321-408e-3d11-aa95-9b0a384f2d9c.png"},"department":{"id":6,"key":6,"name":"\u8d22\u52a1\u90e8"}},"attachment":{},"attachmentRelationships":[],"files":[],"contract":{"id":4073,"key":4073,"serial_no":"\u6d4b\u8bd5","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":1,"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":2380,"contract_id":4072,"amount":"1.00","attachment_id":"","from_date":"2025-08-04","created_by":5252,"created_at":"2025-08-04 11:06:55","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,"createdBy":{"id":5252,"key":5252,"name":"\u738b\u7b11\u7b11","sex":"F","department_id":6,"avatar":{"id":101,"user_id":5252,"name":"\/files\/cdn\/a57be577deb434\/avatar\/f5529321-408e-3d11-aa95-9b0a384f2d9c.png"},"department":{"id":6,"key":6,"name":"\u8d22\u52a1\u90e8"}},"attachment":{},"attachmentRelationships":[],"files":[],"contract":{"id":4072,"key":4072,"serial_no":"","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":[{"id":2406,"purchase_invoice_id":2380,"project_id":3934,"project":{"id":3934,"key":3934,"name":"\u6d77\u6dc0\u8fdb\u4fee\u5b66\u6821\u5b89\u5168\u7eed\u4fdd\u9879\u76ee-2025\u5e74","client_id":3387,"client":{"id":3387,"key":3387,"name":"\u5317\u4eac\u4e45\u5b89\u667a\u8baf\u79d1\u6280\u6709\u9650\u516c\u53f8"}}}],"purchaseInvoiceReminders":[],"purchaseInvoiceProducts":[],"coverInvoices":[],"cancelInvoice":{},"redInvoice":{},"invoice_type_display":"","including_tax":0,"number":0,"outbound":0,"un_used_amount":1,"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":2379,"contract_id":4072,"amount":"3.00","attachment_id":"","from_date":"2025-08-04","created_by":5252,"created_at":"2025-08-04 11:04:34","description":"3","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,"createdBy":{"id":5252,"key":5252,"name":"\u738b\u7b11\u7b11","sex":"F","department_id":6,"avatar":{"id":101,"user_id":5252,"name":"\/files\/cdn\/a57be577deb434\/avatar\/f5529321-408e-3d11-aa95-9b0a384f2d9c.png"},"department":{"id":6,"key":6,"name":"\u8d22\u52a1\u90e8"}},"attachment":{},"attachmentRelationships":[{"id":37327,"object_type":21,"object_id":2379,"attachment_id":27144,"attachment":{"id":27144,"key":27144,"name":"3577ee26-80ae-3b63-a82c-cd21dca7813f","extension":"png","path":"\/vue\/attachment\/view\/3577ee26-80ae-3b63-a82c-cd21dca7813f\/\u622a\u5c4f2025-08-04 10.34.45.png","orig_name":"\u622a\u5c4f2025-08-04 10.34.45.png"}}],"files":[{"id":37328,"object_type":103,"object_id":2379,"attachment_id":27145,"attachment":{"id":27145,"key":27145,"name":"7e14b400-bba0-36e3-a958-0d9bcda02929","extension":"png","path":"\/vue\/attachment\/view\/7e14b400-bba0-36e3-a958-0d9bcda02929\/\u622a\u5c4f2025-07-28 09.00.49.png","orig_name":"\u622a\u5c4f2025-07-28 09.00.49.png"}}],"contract":{"id":4072,"key":4072,"serial_no":"","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":[{"id":2405,"purchase_invoice_id":2379,"project_id":3934,"project":{"id":3934,"key":3934,"name":"\u6d77\u6dc0\u8fdb\u4fee\u5b66\u6821\u5b89\u5168\u7eed\u4fdd\u9879\u76ee-2025\u5e74","client_id":3387,"client":{"id":3387,"key":3387,"name":"\u5317\u4eac\u4e45\u5b89\u667a\u8baf\u79d1\u6280\u6709\u9650\u516c\u53f8"}}}],"purchaseInvoiceReminders":[],"purchaseInvoiceProducts":[],"coverInvoices":[],"cancelInvoice":{},"redInvoice":{},"invoice_type_display":"","including_tax":0,"number":0,"outbound":0,"un_used_amount":3,"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":2377,"contract_id":4069,"amount":"130","attachment_id":"","from_date":"2025-07-28","created_by":1011,"created_at":"2025-07-28 17:00:15","description":"","invoice_num":"25124000000001390299","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":"0","tax_amount":"1.29","excluding_tax":"128.71","verify_at":"","is_used":false,"updated_at":"2025-07-28 17:01:15","cancel_description":"","cover_invoice_id":"","red_invoice_id":"","new_invoice_id":"","need_new_invoice":false,"is_draft":false,"is_settle":false,"supplier_id":608,"is_contract_cancel":false,"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":36095,"object_type":103,"object_id":2377,"attachment_id":27129,"attachment":{"id":27129,"key":27129,"name":"6954d457-1be4-3ae8-9044-9df87e4fb5c7","extension":"pdf","path":"\/vue\/attachment\/view\/6954d457-1be4-3ae8-9044-9df87e4fb5c7\/dzfp_25124000000001390299_\u5929\u6d25\u5e02\u5357\u5f00\u533a\u9e3f\u817e\u6570\u7801\u4ea7\u54c1\u7ecf\u8425\u90e8\uff08\u4e2a\u4f53\u5de5\u5546\u6237\uff09_20250728165907.pdf","orig_name":"dzfp_25124000000001390299_\u5929\u6d25\u5e02\u5357\u5f00\u533a\u9e3f\u817e\u6570\u7801\u4ea7\u54c1\u7ecf\u8425\u90e8\uff08\u4e2a\u4f53\u5de5\u5546\u6237\uff09_20250728165907.pdf"}}],"contract":{"id":4069,"key":4069,"serial_no":"\u8ba2\u5355\u53f7: 4651203278745161702\t","supplier_id":608,"supplier":{"id":608,"key":608,"name":"\u6dd8\u5b9d\u7f51"}},"supplier":{"id":608,"key":608,"name":"\u6dd8\u5b9d\u7f51"},"purchaseInvoiceProjects":[{"id":2403,"purchase_invoice_id":2377,"project_id":3930,"project":{"id":3930,"key":3930,"name":"POTJ25078337-\u56fa\u6001\u786c\u76d8-2025","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":1897,"purchase_invoice_id":2377,"title":"256G","description":"\u8ba1\u7b97\u673a\u5916\u90e8\u8bbe\u5907\u56fa\u6001\u786c\u76d8","number":"1","outbound":"0","inventory":"1","unit":"\u4e2a","amount":"130","tax_rate":"1","including_tax":"0","excluding_tax":"128.71","tax_amount":"1.29","into_inventory":true,"newProduct":[],"matchSalesInvoice":[]}],"coverInvoices":[],"cancelInvoice":{},"redInvoice":{},"invoice_type_display":"\u6570\u7535\u666e\u7968","including_tax":0,"number":1,"outbound":0,"un_used_amount":130,"tax_rate":["1"],"purchaseInvoiceProductList":[{"tax_rate":1,"amount":130,"excluding_tax":128.71,"tax_amount":1.29,"list":[{"id":1897,"purchase_invoice_id":2377,"title":"256G","description":"\u8ba1\u7b97\u673a\u5916\u90e8\u8bbe\u5907\u56fa\u6001\u786c\u76d8","number":"1","outbound":"0","inventory":"1","unit":"\u4e2a","amount":"130","tax_rate":"1","including_tax":"0","excluding_tax":"128.71","tax_amount":"1.29","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":false,"is_new":false},{"id":2376,"contract_id":4066,"amount":"520","attachment_id":"","from_date":"2025-07-25","created_by":5360,"created_at":"2025-07-25 13:45:29","description":"","invoice_num":"25124000000001378160","invoice_type":2,"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":"5.15","excluding_tax":"514.85","verify_at":"","is_used":false,"updated_at":"2025-07-25 13:46:33","cancel_description":"","cover_invoice_id":"","red_invoice_id":"","new_invoice_id":"","need_new_invoice":false,"is_draft":false,"is_settle":false,"supplier_id":608,"is_contract_cancel":false,"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":36046,"object_type":103,"object_id":2376,"attachment_id":27095,"attachment":{"id":27095,"key":27095,"name":"1cac0db2-1a48-3d1e-8527-efe25c5d455a","extension":"pdf","path":"\/vue\/attachment\/view\/1cac0db2-1a48-3d1e-8527-efe25c5d455a\/dzfp_25124000000001378160_\u5929\u6d25\u5e02\u5357\u5f00\u533a\u9e3f\u817e\u6570\u7801\u4ea7\u54c1\u7ecf\u8425\u90e8\uff08\u4e2a\u4f53\u5de5\u5546\u6237\uff09_20250725134445.pdf","orig_name":"dzfp_25124000000001378160_\u5929\u6d25\u5e02\u5357\u5f00\u533a\u9e3f\u817e\u6570\u7801\u4ea7\u54c1\u7ecf\u8425\u90e8\uff08\u4e2a\u4f53\u5de5\u5546\u6237\uff09_20250725134445.pdf"}}],"contract":{"id":4066,"key":4066,"serial_no":"\u8ba2\u5355\u53f7: 4649415087350592710","supplier_id":608,"supplier":{"id":608,"key":608,"name":"\u6dd8\u5b9d\u7f51"}},"supplier":{"id":608,"key":608,"name":"\u6dd8\u5b9d\u7f51"},"purchaseInvoiceProjects":[{"id":2400,"purchase_invoice_id":2376,"project_id":3929,"project":{"id":3929,"key":3929,"name":"OTJ25077468-\u56fa\u6001\u786c\u76d8-G-2025","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"}}},{"id":2401,"purchase_invoice_id":2376,"project_id":3928,"project":{"id":3928,"key":3928,"name":"OTJ25077428-\u56fa\u6001\u786c\u76d8-G-2025","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":1896,"purchase_invoice_id":2376,"title":"256G","description":"\u8ba1\u7b97\u673a\u5916\u90e8\u8bbe\u5907\u56fa\u6001\u786c\u76d8","number":"4","outbound":"0","inventory":"4","unit":"\u4e2a","amount":"520","tax_rate":"1","including_tax":"0","excluding_tax":"514.85","tax_amount":"5.15","into_inventory":true,"newProduct":[],"matchSalesInvoice":[]}],"coverInvoices":[],"cancelInvoice":{},"redInvoice":{},"invoice_type_display":"\u6570\u7535\u666e\u7968","including_tax":0,"number":4,"outbound":0,"un_used_amount":520,"tax_rate":["1"],"purchaseInvoiceProductList":[{"tax_rate":1,"amount":520,"excluding_tax":514.85,"tax_amount":5.15,"list":[{"id":1896,"purchase_invoice_id":2376,"title":"256G","description":"\u8ba1\u7b97\u673a\u5916\u90e8\u8bbe\u5907\u56fa\u6001\u786c\u76d8","number":"4","outbound":"0","inventory":"4","unit":"\u4e2a","amount":"520","tax_rate":"1","including_tax":"0","excluding_tax":"514.85","tax_amount":"5.15","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":false,"is_new":false},{"id":2375,"contract_id":4051,"amount":"900","attachment_id":"","from_date":"2025-07-24","created_by":1011,"created_at":"2025-07-25 09:03:06","description":"","invoice_num":"25952000000150599805","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":"103.54","excluding_tax":"796.46","verify_at":"","is_used":false,"updated_at":"2025-07-25 09:03:54","cancel_description":"","cover_invoice_id":"","red_invoice_id":"","new_invoice_id":"","need_new_invoice":false,"is_draft":false,"is_settle":false,"supplier_id":138,"is_contract_cancel":false,"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":36041,"object_type":103,"object_id":2375,"attachment_id":27091,"attachment":{"id":27091,"key":27091,"name":"c28e6341-aa60-3de5-b71b-e307da93978b","extension":"pdf","path":"\/vue\/attachment\/view\/c28e6341-aa60-3de5-b71b-e307da93978b\/202507225114_25952000000150599805.pdf","orig_name":"202507225114_25952000000150599805.pdf"}}],"contract":{"id":4051,"key":4051,"serial_no":"TSKJ20250721-HYF-001","supplier_id":138,"supplier":{"id":138,"key":138,"name":"\u6df1\u4fe1\u670d\u79d1\u6280\u80a1\u4efd\u6709\u9650\u516c\u53f8"}},"supplier":{"id":138,"key":138,"name":"\u6df1\u4fe1\u670d\u79d1\u6280\u80a1\u4efd\u6709\u9650\u516c\u53f8"},"purchaseInvoiceProjects":[{"id":2397,"purchase_invoice_id":2375,"project_id":3704,"project":{"id":3704,"key":3704,"name":"\u5ba2\u6237\u81ea\u7528-\u6df1\u4fe1\u670d\u9632\u706b\u5899\uff0c\u8d1f\u8f7d\uff0c\u4ea4\u6362\u673a","client_id":2094,"client":{"id":2094,"key":2094,"name":"\u516c\u5b89\u90e8\u7b2c\u4e00\u7814\u7a76\u6240(\u5317\u4eac\u4e2d\u5929\u950b\u5b89\u5168\u9632\u62a4\u6280\u672f\u6709\u9650\u516c\u53f8)"}}}],"purchaseInvoiceReminders":[],"purchaseInvoiceProducts":[{"id":1895,"purchase_invoice_id":2375,"title":"","description":"\u8ba1\u7b97\u673a\u7f51\u7edc\u8bbe\u5907\u786c\u4ef6\u8bbe\u5907\u635f\u8017\u8d39","number":"3","outbound":"0","inventory":"3","unit":"\u6b21","amount":"900","tax_rate":"13","including_tax":"0","excluding_tax":"796.46","tax_amount":"103.54","into_inventory":true,"newProduct":[],"matchSalesInvoice":[]}],"coverInvoices":[],"cancelInvoice":{},"redInvoice":{},"invoice_type_display":"\u6570\u7535\u4e13\u7968","including_tax":0,"number":3,"outbound":0,"un_used_amount":900,"tax_rate":["13"],"purchaseInvoiceProductList":[{"tax_rate":13,"amount":900,"excluding_tax":796.46,"tax_amount":103.54,"list":[{"id":1895,"purchase_invoice_id":2375,"title":"","description":"\u8ba1\u7b97\u673a\u7f51\u7edc\u8bbe\u5907\u786c\u4ef6\u8bbe\u5907\u635f\u8017\u8d39","number":"3","outbound":"0","inventory":"3","unit":"\u6b21","amount":"900","tax_rate":"13","including_tax":"0","excluding_tax":"796.46","tax_amount":"103.54","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":2374,"contract_id":4067,"amount":"397.01","attachment_id":"","from_date":"2025-07-23","created_by":1011,"created_at":"2025-07-24 14:55:49","description":"","invoice_num":"25447000000804086634","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":"397.01","tax_amount":"45.67","excluding_tax":"351.34","verify_at":"","is_used":false,"updated_at":"2025-07-24 14:56:34","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,"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":36033,"object_type":103,"object_id":2374,"attachment_id":27083,"attachment":{"id":27083,"key":27083,"name":"2feed15b-c073-3b8c-bf15-220ff392985c","extension":"pdf","path":"\/vue\/attachment\/view\/2feed15b-c073-3b8c-bf15-220ff392985c\/digital_25447000000804086634.pdf","orig_name":"digital_25447000000804086634.pdf"}}],"contract":{"id":4067,"key":4067,"serial_no":"\u8ba2\u5355\u53f7\uff1a327559652672","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":2395,"purchase_invoice_id":2374,"project_id":3810,"project":{"id":3810,"key":3810,"name":"NETAPP\u5b58\u50a8\u7eed\u4fdd\u670d\u52a1-2025\u5e74","client_id":1492,"client":{"id":1492,"key":1492,"name":"\u5317\u4eac\u8d1d\u745e\u548c\u5eb7\u751f\u7269\u6280\u672f\u6709\u9650\u516c\u53f8(\u5317\u4eac\u8d1d\u745e\u548c\u5eb7\u533b\u5b66\u68c0\u9a8c\u5b9e\u9a8c\u5ba4\u6709\u9650\u516c\u53f8)"}}}],"purchaseInvoiceReminders":[],"purchaseInvoiceProducts":[{"id":1894,"purchase_invoice_id":2374,"title":"","description":"\u5176\u4ed6\u673a\u68b0\u8bbe\u5907\u7535\u5668\u7535\u5b50\u4ea7\u54c1\u53ca\u914d\u4ef6","number":"1","outbound":"0","inventory":"0","unit":"\u652f","amount":"397.01","tax_rate":"13","including_tax":"0","excluding_tax":"351.34","tax_amount":"45.67","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":397.01,"excluding_tax":351.34,"tax_amount":45.67,"list":[{"id":1894,"purchase_invoice_id":2374,"title":"","description":"\u5176\u4ed6\u673a\u68b0\u8bbe\u5907\u7535\u5668\u7535\u5b50\u4ea7\u54c1\u53ca\u914d\u4ef6","number":"1","outbound":"0","inventory":"0","unit":"\u652f","amount":"397.01","tax_rate":"13","including_tax":"0","excluding_tax":"351.34","tax_amount":"45.67","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":2373,"contract_id":4062,"amount":"2000","attachment_id":"","from_date":"2025-07-23","created_by":1011,"created_at":"2025-07-23 11:08:41","description":"","invoice_num":"25117000000966860889","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":"2000","tax_amount":"0","excluding_tax":"2000","verify_at":"","is_used":false,"updated_at":"2025-07-23 11:26:42","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,"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":35984,"object_type":103,"object_id":2373,"attachment_id":27039,"attachment":{"id":27039,"key":27039,"name":"89eebafd-e35b-35e8-9f09-2af61a820b74","extension":"pdf","path":"\/vue\/attachment\/view\/89eebafd-e35b-35e8-9f09-2af61a820b74\/2000.pdf","orig_name":"2000.pdf"}}],"contract":{"id":4062,"key":4062,"serial_no":"\u8ba2\u5355\u53f7\uff1a 327609705325","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":2393,"purchase_invoice_id":2373,"project_id":3865,"project":{"id":3865,"key":3865,"name":"2025\u5353\u8c6a\u8fd0\u7ef4\u8f6f\u4ef6\u65b0\u8d2d\u548c\u7eed\u4fdd","client_id":2177,"client":{"id":2177,"key":2177,"name":"\u4e2d\u79cd\u56fd\u9645\u79cd\u5b50\u6709\u9650\u516c\u53f8"}}}],"purchaseInvoiceReminders":[],"purchaseInvoiceProducts":[{"id":1893,"purchase_invoice_id":2373,"title":"","description":"\u9884\u4ed8\u5361\u9500\u552e\u8d2d\u7269\u5361","number":"1","outbound":"0","inventory":"0","unit":"\u5f20","amount":"2000","tax_rate":"0","including_tax":"0","excluding_tax":"2000","tax_amount":"0","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":["0"],"purchaseInvoiceProductList":[{"tax_rate":0,"amount":2000,"excluding_tax":2000,"tax_amount":0,"list":[{"id":1893,"purchase_invoice_id":2373,"title":"","description":"\u9884\u4ed8\u5361\u9500\u552e\u8d2d\u7269\u5361","number":"1","outbound":"0","inventory":"0","unit":"\u5f20","amount":"2000","tax_rate":"0","including_tax":"0","excluding_tax":"2000","tax_amount":"0","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":2372,"contract_id":4052,"amount":"260","attachment_id":"","from_date":"2025-07-23","created_by":5360,"created_at":"2025-07-23 11:01:21","description":"","invoice_num":"25124000000001306529","invoice_type":2,"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":"2.57","excluding_tax":"257.43","verify_at":"","is_used":false,"updated_at":"2025-07-23 11:02:09","cancel_description":"","cover_invoice_id":"","red_invoice_id":"","new_invoice_id":"","need_new_invoice":false,"is_draft":false,"is_settle":false,"supplier_id":608,"is_contract_cancel":false,"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":35977,"object_type":103,"object_id":2372,"attachment_id":27036,"attachment":{"id":27036,"key":27036,"name":"08f251c0-fa8e-30f1-a53b-9b03b261603a","extension":"pdf","path":"\/vue\/attachment\/view\/08f251c0-fa8e-30f1-a53b-9b03b261603a\/dzfp_25124000000001306529_\u5929\u6d25\u5e02\u5357\u5f00\u533a\u9e3f\u817e\u6570\u7801\u4ea7\u54c1\u7ecf\u8425\u90e8\uff08\u4e2a\u4f53\u5de5\u5546\u6237\uff09_20250723110049.pdf","orig_name":"dzfp_25124000000001306529_\u5929\u6d25\u5e02\u5357\u5f00\u533a\u9e3f\u817e\u6570\u7801\u4ea7\u54c1\u7ecf\u8425\u90e8\uff08\u4e2a\u4f53\u5de5\u5546\u6237\uff09_20250723110049.pdf"}}],"contract":{"id":4052,"key":4052,"serial_no":"\u8ba2\u5355\u53f7: 4643512058994592710\/4643515981688592710","supplier_id":608,"supplier":{"id":608,"key":608,"name":"\u6dd8\u5b9d\u7f51"}},"supplier":{"id":608,"key":608,"name":"\u6dd8\u5b9d\u7f51"},"purchaseInvoiceProjects":[{"id":2389,"purchase_invoice_id":2372,"project_id":3925,"project":{"id":3925,"key":3925,"name":"OTJ25076289-\u5185\u5b58\u6761-G-2025","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"}}},{"id":2390,"purchase_invoice_id":2372,"project_id":3924,"project":{"id":3924,"key":3924,"name":"OTJ25076163-\u56fa\u6001\u786c\u76d8-G-2025","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":1892,"purchase_invoice_id":2372,"title":"256G","description":"\u8ba1\u7b97\u673a\u5916\u90e8\u8bbe\u5907\u56fa\u6001\u786c\u76d8","number":"2","outbound":"0","inventory":"2","unit":"\u4e2a","amount":"260","tax_rate":"1","including_tax":"0","excluding_tax":"257.43","tax_amount":"2.57","into_inventory":true,"newProduct":[],"matchSalesInvoice":[]}],"coverInvoices":[],"cancelInvoice":{},"redInvoice":{},"invoice_type_display":"\u6570\u7535\u666e\u7968","including_tax":0,"number":2,"outbound":0,"un_used_amount":260,"tax_rate":["1"],"purchaseInvoiceProductList":[{"tax_rate":1,"amount":260,"excluding_tax":257.43,"tax_amount":2.57,"list":[{"id":1892,"purchase_invoice_id":2372,"title":"256G","description":"\u8ba1\u7b97\u673a\u5916\u90e8\u8bbe\u5907\u56fa\u6001\u786c\u76d8","number":"2","outbound":"0","inventory":"2","unit":"\u4e2a","amount":"260","tax_rate":"1","including_tax":"0","excluding_tax":"257.43","tax_amount":"2.57","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":false,"is_new":false},{"id":2371,"contract_id":3929,"amount":"30539","attachment_id":"","from_date":"2025-07-22","created_by":1011,"created_at":"2025-07-22 13:47:47","description":"","invoice_num":"25112000000152630096","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":"3513.34","excluding_tax":"27025.66","verify_at":"","is_used":false,"updated_at":"2025-07-22 13:48:28","cancel_description":"","cover_invoice_id":"","red_invoice_id":"","new_invoice_id":"","need_new_invoice":false,"is_draft":false,"is_settle":false,"supplier_id":365,"is_contract_cancel":false,"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":35960,"object_type":103,"object_id":2371,"attachment_id":27026,"attachment":{"id":27026,"key":27026,"name":"e23cbebc-e249-3411-80b1-673998f08432","extension":"pdf","path":"\/vue\/attachment\/view\/e23cbebc-e249-3411-80b1-673998f08432\/dzfp_25112000000152630096_\u5317\u4eac\u62d3\u5b9e\u79d1\u6280\u6709\u9650\u516c\u53f8_10539.pdf","orig_name":"dzfp_25112000000152630096_\u5317\u4eac\u62d3\u5b9e\u79d1\u6280\u6709\u9650\u516c\u53f8_10539.pdf"}}],"contract":{"id":3929,"key":3929,"serial_no":"TSKJ20250527-HYF-001","supplier_id":365,"supplier":{"id":365,"key":365,"name":"\u5317\u4eac\u767e\u8fbe\u4fe1\u901a\u79d1\u6280\u6709\u9650\u516c\u53f8"}},"supplier":{"id":365,"key":365,"name":"\u5317\u4eac\u767e\u8fbe\u4fe1\u901a\u79d1\u6280\u6709\u9650\u516c\u53f8"},"purchaseInvoiceProjects":[{"id":2386,"purchase_invoice_id":2371,"project_id":3827,"project":{"id":3827,"key":3827,"name":"PA\u7eed\u4fdd1\u5e74-C-2025","client_id":1663,"client":{"id":1663,"key":1663,"name":"\u5317\u4eac\u8f66\u4e4b\u5bb6\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8\u3010\u6c7d\u8f66\u4e4b\u5bb6-\u5317\u4eac\u76ae\u5c14\u5e03\u83b1\u5c3c\u8f6f\u4ef6\u6709\u9650\u516c\u53f8-\u5317\u4eac\u9f50\u5c14\u5e03\u83b1\u7279\u79d1\u6280\u6709\u9650\u516c\u53f8-\u5317\u4eac\u8f66\u667a\u8d62\u79d1\u6280\u6709\u9650\u516c\u53f8\u3011"}}}],"purchaseInvoiceReminders":[],"purchaseInvoiceProducts":[{"id":1891,"purchase_invoice_id":2371,"title":"PAN-PA-3220-WF","description":"\u8f6f\u4ef6PALOALTO\u8bb8\u53ef","number":"1","outbound":"0","inventory":"1","unit":"\u4e2a","amount":"30539","tax_rate":"13","including_tax":"0","excluding_tax":"27025.66","tax_amount":"3513.34","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":30539,"tax_rate":["13"],"purchaseInvoiceProductList":[{"tax_rate":13,"amount":30539,"excluding_tax":27025.66,"tax_amount":3513.34,"list":[{"id":1891,"purchase_invoice_id":2371,"title":"PAN-PA-3220-WF","description":"\u8f6f\u4ef6PALOALTO\u8bb8\u53ef","number":"1","outbound":"0","inventory":"1","unit":"\u4e2a","amount":"30539","tax_rate":"13","including_tax":"0","excluding_tax":"27025.66","tax_amount":"3513.34","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":2367,"contract_id":4042,"amount":"260.52","attachment_id":"","from_date":"2025-07-21","created_by":5252,"created_at":"2025-08-04 11:55:23","description":"","invoice_num":"25502000000077361554","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":"260.52","tax_amount":"2.58","excluding_tax":"257.94","verify_at":"","is_used":false,"updated_at":"2025-07-21 11:40:56","cancel_description":"","cover_invoice_id":"","red_invoice_id":"","new_invoice_id":"","need_new_invoice":false,"is_draft":false,"is_settle":false,"supplier_id":608,"is_contract_cancel":false,"createdBy":{"id":5252,"key":5252,"name":"\u738b\u7b11\u7b11","sex":"F","department_id":6,"avatar":{"id":101,"user_id":5252,"name":"\/files\/cdn\/a57be577deb434\/avatar\/f5529321-408e-3d11-aa95-9b0a384f2d9c.png"},"department":{"id":6,"key":6,"name":"\u8d22\u52a1\u90e8"}},"attachment":{},"attachmentRelationships":[{"id":37358,"object_type":21,"object_id":2367,"attachment_id":27154,"attachment":{"id":27154,"key":27154,"name":"39d017bd-e528-3c9b-8000-48d516cb73a3","extension":"png","path":"\/vue\/attachment\/view\/39d017bd-e528-3c9b-8000-48d516cb73a3\/\u622a\u5c4f2025-08-04 10.34.45.png","orig_name":"\u622a\u5c4f2025-08-04 10.34.45.png"}}],"files":[{"id":37359,"object_type":103,"object_id":2367,"attachment_id":26984,"attachment":{"id":26984,"key":26984,"name":"9bd2bf2b-c2c9-3d23-8cf2-ab5170530c40","extension":"pdf","path":"\/vue\/attachment\/view\/9bd2bf2b-c2c9-3d23-8cf2-ab5170530c40\/20250721_\u5317\u4eac\u62d3\u5b9e\u79d1\u6280\u6709\u9650\u516c\u53f8_25502000000077361554_260.52(1).pdf","orig_name":"20250721_\u5317\u4eac\u62d3\u5b9e\u79d1\u6280\u6709\u9650\u516c\u53f8_25502000000077361554_260.52(1).pdf"}},{"id":37360,"object_type":103,"object_id":2367,"attachment_id":27155,"attachment":{"id":27155,"key":27155,"name":"6aa2f8ef-acaf-33d5-9751-40ad68f8aa03","extension":"png","path":"\/vue\/attachment\/view\/6aa2f8ef-acaf-33d5-9751-40ad68f8aa03\/\u622a\u5c4f2025-08-04 10.34.45.png","orig_name":"\u622a\u5c4f2025-08-04 10.34.45.png"}}],"contract":{"id":4042,"key":4042,"serial_no":"\u8ba2\u5355\u53f7: 4634557275452161702","supplier_id":608,"supplier":{"id":608,"key":608,"name":"\u6dd8\u5b9d\u7f51"}},"supplier":{"id":608,"key":608,"name":"\u6dd8\u5b9d\u7f51"},"purchaseInvoiceProjects":[],"purchaseInvoiceReminders":[],"purchaseInvoiceProducts":[{"id":1878,"purchase_invoice_id":2367,"title":"","description":"\u8ba1\u7b97\u673a\u914d\u5957\u4ea7\u54c1\u5148\u950b\u84dd\u5149\u523b\u5f55\u673a","number":"1","outbound":"0","inventory":"0","unit":"\u53f0","amount":"260.52","tax_rate":"1","including_tax":"0","excluding_tax":"257.94","tax_amount":"2.58","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":260.52,"excluding_tax":257.94,"tax_amount":2.58,"list":[{"id":1878,"purchase_invoice_id":2367,"title":"","description":"\u8ba1\u7b97\u673a\u914d\u5957\u4ea7\u54c1\u5148\u950b\u84dd\u5149\u523b\u5f55\u673a","number":"1","outbound":"0","inventory":"0","unit":"\u53f0","amount":"260.52","tax_rate":"1","including_tax":"0","excluding_tax":"257.94","tax_amount":"2.58","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":2370,"contract_id":4017,"amount":"140270","attachment_id":"","from_date":"2025-07-21","created_by":1011,"created_at":"2025-07-22 09:07:19","description":"","invoice_num":"25312000000227965417","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":"140270","tax_amount":"16137.26","excluding_tax":"124132.74","verify_at":"","is_used":true,"updated_at":"2025-07-22 09:11:41","cancel_description":"","cover_invoice_id":"","red_invoice_id":"","new_invoice_id":"","need_new_invoice":false,"is_draft":false,"is_settle":false,"supplier_id":68,"is_contract_cancel":false,"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":35942,"object_type":103,"object_id":2370,"attachment_id":27006,"attachment":{"id":27006,"key":27006,"name":"a3d6e609-c691-3476-a7b7-3410c0206f11","extension":"pdf","path":"\/vue\/attachment\/view\/a3d6e609-c691-3476-a7b7-3410c0206f11\/20250721-25312000000227965417.pdf","orig_name":"20250721-25312000000227965417.pdf"}}],"contract":{"id":4017,"key":4017,"serial_no":"Zstack-BJ7067-20250528","supplier_id":68,"supplier":{"id":68,"key":68,"name":"\u82f1\u8fc8\u7535\u5b50\u5546\u8d38(\u4e0a\u6d77)\u6709\u9650\u516c\u53f8"}},"supplier":{"id":68,"key":68,"name":"\u82f1\u8fc8\u7535\u5b50\u5546\u8d38(\u4e0a\u6d77)\u6709\u9650\u516c\u53f8"},"purchaseInvoiceProjects":[{"id":2383,"purchase_invoice_id":2370,"project_id":3874,"project":{"id":3874,"key":3874,"name":"ZStack\u4e91\u4ea7\u54c1\uff08\u7518\u674e\u836f\u4e1a\uff09\u91c7\u8d2d\u9879\u76ee","client_id":3377,"client":{"id":3377,"key":3377,"name":"\u5317\u4eac\u5a01\u53d1\u65b0\u4e16\u7eaa\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8\uff08\u8fc7\u5355\uff09"}}}],"purchaseInvoiceReminders":[],"purchaseInvoiceProducts":[{"id":1886,"purchase_invoice_id":2370,"title":"ZSTACK CEPHV3.0","description":"\u8ba1\u7b97\u673a\u5916\u90e8\u8bbe\u5907ZStack\u5206\u5e03\u5f0f\u5b58\u50a8V3.0","number":"192","outbound":"192","inventory":"0","unit":"\u4e2a","amount":"57024","tax_rate":"13","including_tax":"0","excluding_tax":"50463.72","tax_amount":"6560.28","into_inventory":true,"newProduct":[],"matchSalesInvoice":[]},{"id":1887,"purchase_invoice_id":2370,"title":"ZSTACK CMPV4.0","description":"\u8f6f\u4ef6ZStack CMP\u591a\u4e91\u7ba1\u7406\u5e73\u53f0V4.0","number":"1","outbound":"1","inventory":"0","unit":"\u4e2a","amount":"40000","tax_rate":"13","including_tax":"0","excluding_tax":"35398.23","tax_amount":"4601.77","into_inventory":true,"newProduct":[],"matchSalesInvoice":[]},{"id":1888,"purchase_invoice_id":2370,"title":"ZSTACK CLOUDV4.0","description":"\u8f6f\u4ef6ZStack Cloud\u4e91\u5e73\u53f0V4.0","number":"8","outbound":"8","inventory":"0","unit":"\u4e2a","amount":"30000","tax_rate":"13","including_tax":"0","excluding_tax":"26548.67","tax_amount":"3451.33","into_inventory":true,"newProduct":[],"matchSalesInvoice":[]},{"id":1889,"purchase_invoice_id":2370,"title":"ZSTACK CLOUDV4.0","description":"\u8f6f\u4ef6ZStack Cloud\u4e91\u5e73\u53f0V4.0","number":"1","outbound":"1","inventory":"0","unit":"\u4e2a","amount":"13246","tax_rate":"13","including_tax":"0","excluding_tax":"11722.12","tax_amount":"1523.88","into_inventory":true,"newProduct":[],"matchSalesInvoice":[]}],"coverInvoices":[],"cancelInvoice":{},"redInvoice":{},"invoice_type_display":"\u6570\u7535\u4e13\u7968","including_tax":0,"number":202,"outbound":202,"un_used_amount":0,"tax_rate":["13"],"purchaseInvoiceProductList":[{"tax_rate":13,"amount":140270,"excluding_tax":124132.74,"tax_amount":16137.26,"list":[{"id":1886,"purchase_invoice_id":2370,"title":"ZSTACK CEPHV3.0","description":"\u8ba1\u7b97\u673a\u5916\u90e8\u8bbe\u5907ZStack\u5206\u5e03\u5f0f\u5b58\u50a8V3.0","number":"192","outbound":"192","inventory":"0","unit":"\u4e2a","amount":"57024","tax_rate":"13","including_tax":"0","excluding_tax":"50463.72","tax_amount":"6560.28","into_inventory":true,"newProduct":[],"matchSalesInvoice":[]},{"id":1887,"purchase_invoice_id":2370,"title":"ZSTACK CMPV4.0","description":"\u8f6f\u4ef6ZStack CMP\u591a\u4e91\u7ba1\u7406\u5e73\u53f0V4.0","number":"1","outbound":"1","inventory":"0","unit":"\u4e2a","amount":"40000","tax_rate":"13","including_tax":"0","excluding_tax":"35398.23","tax_amount":"4601.77","into_inventory":true,"newProduct":[],"matchSalesInvoice":[]},{"id":1888,"purchase_invoice_id":2370,"title":"ZSTACK CLOUDV4.0","description":"\u8f6f\u4ef6ZStack Cloud\u4e91\u5e73\u53f0V4.0","number":"8","outbound":"8","inventory":"0","unit":"\u4e2a","amount":"30000","tax_rate":"13","including_tax":"0","excluding_tax":"26548.67","tax_amount":"3451.33","into_inventory":true,"newProduct":[],"matchSalesInvoice":[]},{"id":1889,"purchase_invoice_id":2370,"title":"ZSTACK CLOUDV4.0","description":"\u8f6f\u4ef6ZStack Cloud\u4e91\u5e73\u53f0V4.0","number":"1","outbound":"1","inventory":"0","unit":"\u4e2a","amount":"13246","tax_rate":"13","including_tax":"0","excluding_tax":"11722.12","tax_amount":"1523.88","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":2369,"contract_id":4017,"amount":"10000","attachment_id":"","from_date":"2025-07-21","created_by":1011,"created_at":"2025-07-22 09:07:05","description":"","invoice_num":"25312000000227965319","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":"10000","tax_amount":"566.04","excluding_tax":"9433.96","verify_at":"","is_used":true,"updated_at":"2025-07-22 09:13:22","cancel_description":"","cover_invoice_id":"","red_invoice_id":"","new_invoice_id":"","need_new_invoice":false,"is_draft":false,"is_settle":false,"supplier_id":68,"is_contract_cancel":false,"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":35943,"object_type":103,"object_id":2369,"attachment_id":27005,"attachment":{"id":27005,"key":27005,"name":"0336dce1-a785-33f2-84ac-36340523c549","extension":"pdf","path":"\/vue\/attachment\/view\/0336dce1-a785-33f2-84ac-36340523c549\/20250721-25312000000227965319.pdf","orig_name":"20250721-25312000000227965319.pdf"}}],"contract":{"id":4017,"key":4017,"serial_no":"Zstack-BJ7067-20250528","supplier_id":68,"supplier":{"id":68,"key":68,"name":"\u82f1\u8fc8\u7535\u5b50\u5546\u8d38(\u4e0a\u6d77)\u6709\u9650\u516c\u53f8"}},"supplier":{"id":68,"key":68,"name":"\u82f1\u8fc8\u7535\u5b50\u5546\u8d38(\u4e0a\u6d77)\u6709\u9650\u516c\u53f8"},"purchaseInvoiceProjects":[{"id":2384,"purchase_invoice_id":2369,"project_id":3874,"project":{"id":3874,"key":3874,"name":"ZStack\u4e91\u4ea7\u54c1\uff08\u7518\u674e\u836f\u4e1a\uff09\u91c7\u8d2d\u9879\u76ee","client_id":3377,"client":{"id":3377,"key":3377,"name":"\u5317\u4eac\u5a01\u53d1\u65b0\u4e16\u7eaa\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8\uff08\u8fc7\u5355\uff09"}}}],"purchaseInvoiceReminders":[],"purchaseInvoiceProducts":[{"id":1890,"purchase_invoice_id":2369,"title":"ZSTACK CLOUDDS","description":"\u4fe1\u606f\u7cfb\u7edf\u670d\u52a1\u9879\u76ee\u5b9e\u65bd\u670d\u52a1","number":"2","outbound":"2","inventory":"0","unit":"\u4e2a","amount":"10000","tax_rate":"6","including_tax":"0","excluding_tax":"9433.96","tax_amount":"566.04","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"],"purchaseInvoiceProductList":[{"tax_rate":6,"amount":10000,"excluding_tax":9433.96,"tax_amount":566.04,"list":[{"id":1890,"purchase_invoice_id":2369,"title":"ZSTACK CLOUDDS","description":"\u4fe1\u606f\u7cfb\u7edf\u670d\u52a1\u9879\u76ee\u5b9e\u65bd\u670d\u52a1","number":"2","outbound":"2","inventory":"0","unit":"\u4e2a","amount":"10000","tax_rate":"6","including_tax":"0","excluding_tax":"9433.96","tax_amount":"566.04","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":2368,"contract_id":4038,"amount":"145000","attachment_id":"","from_date":"2025-07-21","created_by":1011,"created_at":"2025-07-21 17:23:20","description":"","invoice_num":"25112000000151444555","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":"16681.41","excluding_tax":"128318.59","verify_at":"","is_used":false,"updated_at":"2025-07-21 17:28:01","cancel_description":"","cover_invoice_id":"","red_invoice_id":"","new_invoice_id":"","need_new_invoice":false,"is_draft":false,"is_settle":false,"supplier_id":236,"is_contract_cancel":false,"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":35938,"object_type":103,"object_id":2368,"attachment_id":27003,"attachment":{"id":27003,"key":27003,"name":"ef7869a6-e47c-3cf1-95fd-b920e7e091e5","extension":"pdf","path":"\/vue\/attachment\/view\/ef7869a6-e47c-3cf1-95fd-b920e7e091e5\/dzfp_25112000000151444555_\u5317\u4eac\u62d3\u5b9e\u79d1\u6280\u6709\u9650\u516c\u53f8_20250721155737.pdf","orig_name":"dzfp_25112000000151444555_\u5317\u4eac\u62d3\u5b9e\u79d1\u6280\u6709\u9650\u516c\u53f8_20250721155737.pdf"}}],"contract":{"id":4038,"key":4038,"serial_no":"TSKJ20250716-HYF-001","supplier_id":236,"supplier":{"id":236,"key":236,"name":"\u5317\u4eac\u5929\u4fe1\u5b8f\u8fbe\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8"}},"supplier":{"id":236,"key":236,"name":"\u5317\u4eac\u5929\u4fe1\u5b8f\u8fbe\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8"},"purchaseInvoiceProjects":[{"id":2380,"purchase_invoice_id":2368,"project_id":3841,"project":{"id":3841,"key":3841,"name":"2025PA\u9632\u706b\u5899\u66ff\u6362","client_id":3343,"client":{"id":3343,"key":3343,"name":"\u5317\u4eac\u5317\u6c7d\u79d1\u6280\u670d\u52a1\u6709\u9650\u516c\u53f8(\u4e2d\u90fd\u4e09\u4ea7\uff09"}}}],"purchaseInvoiceReminders":[],"purchaseInvoiceProducts":[{"id":1879,"purchase_invoice_id":2368,"title":"AF-1000-FH2300B","description":"\u8ba1\u7b97\u673a\u7f51\u7edc\u8bbe\u5907\u6df1\u4fe1\u670d\u9632\u706b\u5899","number":"2","outbound":"0","inventory":"2","unit":"\u53f0","amount":"9846","tax_rate":"13","including_tax":"0","excluding_tax":"8713.27","tax_amount":"1132.73","into_inventory":true,"newProduct":[],"matchSalesInvoice":[]},{"id":1880,"purchase_invoice_id":2368,"title":"\u9002\u7528\u4e8eAF-1000-FH2300B","description":"\u8f6f\u4ef6\u6df1\u4fe1\u670d\u9632\u706b\u5899\u8f6f\u4ef6V8.0","number":"2","outbound":"0","inventory":"2","unit":"\u5957","amount":"81073.22","tax_rate":"13","including_tax":"0","excluding_tax":"71746.21","tax_amount":"9327.01","into_inventory":true,"newProduct":[],"matchSalesInvoice":[]},{"id":1881,"purchase_invoice_id":2368,"title":"\u9002\u7528\u4e8eAF-1000-FH2300B","description":"\u8f6f\u4ef6\u6df1\u4fe1\u670d\u9632\u706b\u5899\u589e\u5f3a\u7ea7\u8f6f\u4ef6V6.0","number":"2","outbound":"0","inventory":"2","unit":"\u5957","amount":"9112.08","tax_rate":"13","including_tax":"0","excluding_tax":"8063.79","tax_amount":"1048.29","into_inventory":true,"newProduct":[],"matchSalesInvoice":[]},{"id":1882,"purchase_invoice_id":2368,"title":"\u79fb\u52a8\u63a5\u5165\u6388\u6743\u6a21\u5757","description":"\u8f6f\u4ef6\u6df1\u4fe1\u670dSSL VPN\u8f6f\u4ef6V6.0","number":"2","outbound":"0","inventory":"2","unit":"\u5957","amount":"5821.76","tax_rate":"13","including_tax":"0","excluding_tax":"5152","tax_amount":"669.76","into_inventory":true,"newProduct":[],"matchSalesInvoice":[]},{"id":1883,"purchase_invoice_id":2368,"title":"\u79fb\u52a8\u63a5\u5165\u6388\u6743","description":"\u8f6f\u4ef6\u6df1\u4fe1\u670dSSL VPN\u6388\u6743\u8f6f\u4ef6V6.0","number":"90","outbound":"0","inventory":"90","unit":"\u5957","amount":"11810.7","tax_rate":"13","including_tax":"0","excluding_tax":"10451.95","tax_amount":"1358.75","into_inventory":true,"newProduct":[],"matchSalesInvoice":[]},{"id":1884,"purchase_invoice_id":2368,"title":"\u9002\u7528\u4e8eAF-1000-FH2300B","description":"\u8f6f\u4ef6\u6df1\u4fe1\u670d\u5b89\u5168\u4e91\u8111-\u4e91\u667a\u8ba2\u9605\u8f6f\u4ef6V8.0","number":"2","outbound":"0","inventory":"2","unit":"\u5957","amount":"9112.08","tax_rate":"13","including_tax":"0","excluding_tax":"8063.79","tax_amount":"1048.29","into_inventory":true,"newProduct":[],"matchSalesInvoice":[]},{"id":1885,"purchase_invoice_id":2368,"title":"\u9002\u7528\u4e8eAF-1000-FH2300B","description":"\u8f6f\u4ef6\u6df1\u4fe1\u670d\u4e91\u5a01\u80c1\u60c5\u62a5\u7f51\u5173\u8f6f\u4ef6V8.0","number":"2","outbound":"0","inventory":"2","unit":"\u5957","amount":"18224.16","tax_rate":"13","including_tax":"0","excluding_tax":"16127.58","tax_amount":"2096.58","into_inventory":true,"newProduct":[],"matchSalesInvoice":[]}],"coverInvoices":[],"cancelInvoice":{},"redInvoice":{},"invoice_type_display":"\u6570\u7535\u4e13\u7968","including_tax":0,"number":102,"outbound":0,"un_used_amount":145000,"tax_rate":["13"],"purchaseInvoiceProductList":[{"tax_rate":13,"amount":145000,"excluding_tax":128318.59,"tax_amount":16681.41,"list":[{"id":1879,"purchase_invoice_id":2368,"title":"AF-1000-FH2300B","description":"\u8ba1\u7b97\u673a\u7f51\u7edc\u8bbe\u5907\u6df1\u4fe1\u670d\u9632\u706b\u5899","number":"2","outbound":"0","inventory":"2","unit":"\u53f0","amount":"9846","tax_rate":"13","including_tax":"0","excluding_tax":"8713.27","tax_amount":"1132.73","into_inventory":true,"newProduct":[],"matchSalesInvoice":[]},{"id":1880,"purchase_invoice_id":2368,"title":"\u9002\u7528\u4e8eAF-1000-FH2300B","description":"\u8f6f\u4ef6\u6df1\u4fe1\u670d\u9632\u706b\u5899\u8f6f\u4ef6V8.0","number":"2","outbound":"0","inventory":"2","unit":"\u5957","amount":"81073.22","tax_rate":"13","including_tax":"0","excluding_tax":"71746.21","tax_amount":"9327.01","into_inventory":true,"newProduct":[],"matchSalesInvoice":[]},{"id":1881,"purchase_invoice_id":2368,"title":"\u9002\u7528\u4e8eAF-1000-FH2300B","description":"\u8f6f\u4ef6\u6df1\u4fe1\u670d\u9632\u706b\u5899\u589e\u5f3a\u7ea7\u8f6f\u4ef6V6.0","number":"2","outbound":"0","inventory":"2","unit":"\u5957","amount":"9112.08","tax_rate":"13","including_tax":"0","excluding_tax":"8063.79","tax_amount":"1048.29","into_inventory":true,"newProduct":[],"matchSalesInvoice":[]},{"id":1882,"purchase_invoice_id":2368,"title":"\u79fb\u52a8\u63a5\u5165\u6388\u6743\u6a21\u5757","description":"\u8f6f\u4ef6\u6df1\u4fe1\u670dSSL VPN\u8f6f\u4ef6V6.0","number":"2","outbound":"0","inventory":"2","unit":"\u5957","amount":"5821.76","tax_rate":"13","including_tax":"0","excluding_tax":"5152","tax_amount":"669.76","into_inventory":true,"newProduct":[],"matchSalesInvoice":[]},{"id":1883,"purchase_invoice_id":2368,"title":"\u79fb\u52a8\u63a5\u5165\u6388\u6743","description":"\u8f6f\u4ef6\u6df1\u4fe1\u670dSSL VPN\u6388\u6743\u8f6f\u4ef6V6.0","number":"90","outbound":"0","inventory":"90","unit":"\u5957","amount":"11810.7","tax_rate":"13","including_tax":"0","excluding_tax":"10451.95","tax_amount":"1358.75","into_inventory":true,"newProduct":[],"matchSalesInvoice":[]},{"id":1884,"purchase_invoice_id":2368,"title":"\u9002\u7528\u4e8eAF-1000-FH2300B","description":"\u8f6f\u4ef6\u6df1\u4fe1\u670d\u5b89\u5168\u4e91\u8111-\u4e91\u667a\u8ba2\u9605\u8f6f\u4ef6V8.0","number":"2","outbound":"0","inventory":"2","unit":"\u5957","amount":"9112.08","tax_rate":"13","including_tax":"0","excluding_tax":"8063.79","tax_amount":"1048.29","into_inventory":true,"newProduct":[],"matchSalesInvoice":[]},{"id":1885,"purchase_invoice_id":2368,"title":"\u9002\u7528\u4e8eAF-1000-FH2300B","description":"\u8f6f\u4ef6\u6df1\u4fe1\u670d\u4e91\u5a01\u80c1\u60c5\u62a5\u7f51\u5173\u8f6f\u4ef6V8.0","number":"2","outbound":"0","inventory":"2","unit":"\u5957","amount":"18224.16","tax_rate":"13","including_tax":"0","excluding_tax":"16127.58","tax_amount":"2096.58","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":2365,"contract_id":"","amount":"4428.16","attachment_id":"","from_date":"2025-07-18","created_by":5388,"created_at":"2025-07-18 18:01:28","description":"","invoice_num":"\u8d39\u7528-49873429","invoice_type":1,"handler":{},"is_verify":false,"is_cancel":false,"paid_amount":"4428.16","tax_amount":"509.43","excluding_tax":"3918.73","verify_at":"","is_used":false,"updated_at":"2025-07-18 18:01:28","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,"createdBy":{"id":5388,"key":5388,"name":"\u6768\u71d5\u971e","sex":"F","department_id":6,"avatar":{"id":156,"user_id":5388,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b8d4f68f-e736-3c38-9e2f-1ab47885b3d8.png"},"department":{"id":6,"key":6,"name":"\u8d22\u52a1\u90e8"}},"attachment":{},"attachmentRelationships":[],"files":[],"contract":{},"supplier":{},"purchaseInvoiceProjects":[],"purchaseInvoiceReminders":[],"purchaseInvoiceProducts":[{"id":1876,"purchase_invoice_id":2365,"title":"","description":"\u8d39\u7528-\u7535\u8d39","number":"1","outbound":"0","inventory":"0","unit":"","amount":"4428.16","tax_rate":"13","including_tax":"0","excluding_tax":"3918.73","tax_amount":"509.43","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":["13"],"purchaseInvoiceProductList":[{"tax_rate":13,"amount":4428.16,"excluding_tax":3918.73,"tax_amount":509.43,"list":[{"id":1876,"purchase_invoice_id":2365,"title":"","description":"\u8d39\u7528-\u7535\u8d39","number":"1","outbound":"0","inventory":"0","unit":"","amount":"4428.16","tax_rate":"13","including_tax":"0","excluding_tax":"3918.73","tax_amount":"509.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":true,"can_re_verify":false,"is_new":false},{"id":2364,"contract_id":4041,"amount":"107.46","attachment_id":"","from_date":"2025-07-18","created_by":1011,"created_at":"2025-07-18 14:52:31","description":"","invoice_num":"25117000000950252341","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":"107.46","tax_amount":"12.36","excluding_tax":"95.1","verify_at":"","is_used":false,"updated_at":"2025-07-18 14:53:40","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,"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":35844,"object_type":103,"object_id":2364,"attachment_id":26912,"attachment":{"id":26912,"key":26912,"name":"0f42f13a-88c0-36a7-8a65-92a55b989b82","extension":"pdf","path":"\/vue\/attachment\/view\/0f42f13a-88c0-36a7-8a65-92a55b989b82\/digital_25117000000950252341.pdf","orig_name":"digital_25117000000950252341.pdf"}}],"contract":{"id":4041,"key":4041,"serial_no":"\u8ba2\u5355\u53f7\uff1a 326492438280","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":1875,"purchase_invoice_id":2364,"title":"\u84dd\u5149 BD-R 25G 10X","description":"\u4fe1\u606f\u5316\u5b66\u54c1\u94fc\u5fb7(RITEK)\u84dd\u5149 BD-R 25G10X 50\u6876\u88c5 \u7a7a\u767d\u523b\u5f55\u5149\u76d8","number":"1","outbound":"0","inventory":"0","unit":"\u5957","amount":"107.46","tax_rate":"13","including_tax":"0","excluding_tax":"95.1","tax_amount":"12.36","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":107.46,"excluding_tax":95.1,"tax_amount":12.36,"list":[{"id":1875,"purchase_invoice_id":2364,"title":"\u84dd\u5149 BD-R 25G 10X","description":"\u4fe1\u606f\u5316\u5b66\u54c1\u94fc\u5fb7(RITEK)\u84dd\u5149 BD-R 25G10X 50\u6876\u88c5 \u7a7a\u767d\u523b\u5f55\u5149\u76d8","number":"1","outbound":"0","inventory":"0","unit":"\u5957","amount":"107.46","tax_rate":"13","including_tax":"0","excluding_tax":"95.1","tax_amount":"12.36","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":2363,"contract_id":4037,"amount":"260","attachment_id":"","from_date":"2025-07-17","created_by":5360,"created_at":"2025-07-17 14:40:50","description":"","invoice_num":"25124000000001342354","invoice_type":2,"handler":{"id":5360,"key":5360,"name":"\u5f20\u7ea2\u82b3","sex":"F","department_id":3},"is_verify":false,"is_cancel":false,"paid_amount":"260","tax_amount":"2.57","excluding_tax":"257.43","verify_at":"","is_used":true,"updated_at":"2025-07-17 14:41:44","cancel_description":"","cover_invoice_id":"","red_invoice_id":"","new_invoice_id":"","need_new_invoice":false,"is_draft":false,"is_settle":false,"supplier_id":608,"is_contract_cancel":false,"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":35821,"object_type":103,"object_id":2363,"attachment_id":26892,"attachment":{"id":26892,"key":26892,"name":"d0797a4d-df43-374d-a694-13e7b97f63c0","extension":"pdf","path":"\/vue\/attachment\/view\/d0797a4d-df43-374d-a694-13e7b97f63c0\/dzfp_25124000000001342354_\u5929\u6d25\u5e02\u5357\u5f00\u533a\u9e3f\u817e\u6570\u7801\u4ea7\u54c1\u7ecf\u8425\u90e8\uff08\u4e2a\u4f53\u5de5\u5546\u6237\uff09_20250717143802.pdf","orig_name":"dzfp_25124000000001342354_\u5929\u6d25\u5e02\u5357\u5f00\u533a\u9e3f\u817e\u6570\u7801\u4ea7\u54c1\u7ecf\u8425\u90e8\uff08\u4e2a\u4f53\u5de5\u5546\u6237\uff09_20250717143802.pdf"}}],"contract":{"id":4037,"key":4037,"serial_no":"\u8ba2\u5355\u53f7: 4632992211529592710","supplier_id":608,"supplier":{"id":608,"key":608,"name":"\u6dd8\u5b9d\u7f51"}},"supplier":{"id":608,"key":608,"name":"\u6dd8\u5b9d\u7f51"},"purchaseInvoiceProjects":[{"id":2376,"purchase_invoice_id":2363,"project_id":3918,"project":{"id":3918,"key":3918,"name":"POTJ25074907-\u56fa\u6001\u786c\u76d8-2025","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":1873,"purchase_invoice_id":2363,"title":"256G","description":"\u8ba1\u7b97\u673a\u5916\u90e8\u8bbe\u5907\u56fa\u6001\u786c\u76d8","number":"2","outbound":"2","inventory":"0","unit":"\u4e2a","amount":"260","tax_rate":"1","including_tax":"0","excluding_tax":"257.43","tax_amount":"2.57","into_inventory":true,"newProduct":[],"matchSalesInvoice":[]}],"coverInvoices":[],"cancelInvoice":{},"redInvoice":{},"invoice_type_display":"\u6570\u7535\u666e\u7968","including_tax":0,"number":2,"outbound":2,"un_used_amount":0,"tax_rate":["1"],"purchaseInvoiceProductList":[{"tax_rate":1,"amount":260,"excluding_tax":257.43,"tax_amount":2.57,"list":[{"id":1873,"purchase_invoice_id":2363,"title":"256G","description":"\u8ba1\u7b97\u673a\u5916\u90e8\u8bbe\u5907\u56fa\u6001\u786c\u76d8","number":"2","outbound":"2","inventory":"0","unit":"\u4e2a","amount":"260","tax_rate":"1","including_tax":"0","excluding_tax":"257.43","tax_amount":"2.57","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":false,"is_new":false},{"id":2362,"contract_id":4023,"amount":"197.75","attachment_id":"","from_date":"2025-07-17","created_by":5360,"created_at":"2025-07-17 14:40:08","description":"","invoice_num":"25342000000122431979","invoice_type":2,"handler":{"id":5360,"key":5360,"name":"\u5f20\u7ea2\u82b3","sex":"F","department_id":3},"is_verify":false,"is_cancel":false,"paid_amount":"197.75","tax_amount":"1.96","excluding_tax":"195.79","verify_at":"","is_used":true,"updated_at":"2025-07-17 14:42:26","cancel_description":"","cover_invoice_id":"","red_invoice_id":"","new_invoice_id":"","need_new_invoice":false,"is_draft":false,"is_settle":false,"supplier_id":608,"is_contract_cancel":false,"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":35822,"object_type":103,"object_id":2362,"attachment_id":26891,"attachment":{"id":26891,"key":26891,"name":"502b8cf1-6468-3791-8c37-ff06646a406e","extension":"pdf","path":"\/vue\/attachment\/view\/502b8cf1-6468-3791-8c37-ff06646a406e\/_25342000000122431979.pdf","orig_name":"_25342000000122431979.pdf"}}],"contract":{"id":4023,"key":4023,"serial_no":"\u8ba2\u5355\u53f7: 4625229891877592710\/4625146693309592710","supplier_id":608,"supplier":{"id":608,"key":608,"name":"\u6dd8\u5b9d\u7f51"}},"supplier":{"id":608,"key":608,"name":"\u6dd8\u5b9d\u7f51"},"purchaseInvoiceProjects":[{"id":2377,"purchase_invoice_id":2362,"project_id":3913,"project":{"id":3913,"key":3913,"name":"POTJ25073432-\u56fa\u6001\u786c\u76d8-2025","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"}}},{"id":2378,"purchase_invoice_id":2362,"project_id":3912,"project":{"id":3912,"key":3912,"name":"OTJ25072858-\u56fa\u6001\u786c\u76d8+\u5185\u5b58\u6761-2025","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":1874,"purchase_invoice_id":2362,"title":"16g","description":"\u8ba1\u7b97\u673a\u914d\u5957\u4ea7\u54c1\u5185\u5b58","number":"1","outbound":"1","inventory":"0","unit":"\u6761","amount":"197.75","tax_rate":"1","including_tax":"0","excluding_tax":"195.79","tax_amount":"1.96","into_inventory":true,"newProduct":[],"matchSalesInvoice":[]}],"coverInvoices":[],"cancelInvoice":{},"redInvoice":{},"invoice_type_display":"\u6570\u7535\u666e\u7968","including_tax":0,"number":1,"outbound":1,"un_used_amount":0,"tax_rate":["1"],"purchaseInvoiceProductList":[{"tax_rate":1,"amount":197.75,"excluding_tax":195.79,"tax_amount":1.96,"list":[{"id":1874,"purchase_invoice_id":2362,"title":"16g","description":"\u8ba1\u7b97\u673a\u914d\u5957\u4ea7\u54c1\u5185\u5b58","number":"1","outbound":"1","inventory":"0","unit":"\u6761","amount":"197.75","tax_rate":"1","including_tax":"0","excluding_tax":"195.79","tax_amount":"1.96","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":false,"is_new":false},{"id":2361,"contract_id":4033,"amount":"730","attachment_id":"","from_date":"2025-07-16","created_by":1011,"created_at":"2025-07-17 08:52:55","description":"","invoice_num":"25112000000148042134","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":"83.98","excluding_tax":"646.02","verify_at":"","is_used":false,"updated_at":"2025-07-17 08:53:42","cancel_description":"","cover_invoice_id":"","red_invoice_id":"","new_invoice_id":"","need_new_invoice":false,"is_draft":false,"is_settle":false,"supplier_id":608,"is_contract_cancel":false,"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":35802,"object_type":103,"object_id":2361,"attachment_id":26874,"attachment":{"id":26874,"key":26874,"name":"b4d20bf9-9fcb-3cfd-b411-63a2803d6c76","extension":"pdf","path":"\/vue\/attachment\/view\/b4d20bf9-9fcb-3cfd-b411-63a2803d6c76\/3042402858dzfp_25112000000148042134_\u5317\u4eac\u62d3\u5b9e\u79d1\u6280\u6709\u9650\u516c\u53f8_20250716134240.pdf","orig_name":"3042402858dzfp_25112000000148042134_\u5317\u4eac\u62d3\u5b9e\u79d1\u6280\u6709\u9650\u516c\u53f8_20250716134240.pdf"}}],"contract":{"id":4033,"key":4033,"serial_no":"\u8ba2\u5355\u53f7: 4632399036474161702","supplier_id":608,"supplier":{"id":608,"key":608,"name":"\u6dd8\u5b9d\u7f51"}},"supplier":{"id":608,"key":608,"name":"\u6dd8\u5b9d\u7f51"},"purchaseInvoiceProjects":[{"id":2372,"purchase_invoice_id":2361,"project_id":3900,"project":{"id":3900,"key":3900,"name":"2025\u5e74\u670d\u52a1\u5668\u7f51\u5361","client_id":1301,"client":{"id":1301,"key":1301,"name":"\u591a\u7ef4\u8054\u5408\u96c6\u56e2\u80a1\u4efd\u6709\u9650\u516c\u53f8(\u591a\u7ef4\u7eff\u5efa\u79d1\u6280(\u5929\u6d25)\u6709\u9650\u516c\u53f8\u3001\u5317\u4eac\u591a\u7ef4\u827e\u65af\u7279\u56fd\u9645\u5de5\u7a0b\u6280\u672f\u6709\u9650\u516c\u53f8)"}}}],"purchaseInvoiceReminders":[],"purchaseInvoiceProducts":[{"id":1872,"purchase_invoice_id":2361,"title":"X710","description":"\u8ba1\u7b97\u673a\u914d\u5957\u4ea7\u54c1\u7f51\u5361","number":"1","outbound":"0","inventory":"1","unit":"\u7247","amount":"730","tax_rate":"13","including_tax":"0","excluding_tax":"646.02","tax_amount":"83.98","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":730,"tax_rate":["13"],"purchaseInvoiceProductList":[{"tax_rate":13,"amount":730,"excluding_tax":646.02,"tax_amount":83.98,"list":[{"id":1872,"purchase_invoice_id":2361,"title":"X710","description":"\u8ba1\u7b97\u673a\u914d\u5957\u4ea7\u54c1\u7f51\u5361","number":"1","outbound":"0","inventory":"1","unit":"\u7247","amount":"730","tax_rate":"13","including_tax":"0","excluding_tax":"646.02","tax_amount":"83.98","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":2360,"contract_id":4040,"amount":"9000","attachment_id":"","from_date":"2025-07-15","created_by":1011,"created_at":"2025-07-16 10:19:58","description":"","invoice_num":"25112000000147428991","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":"9000","tax_amount":"1035.4","excluding_tax":"7964.6","verify_at":"","is_used":false,"updated_at":"2025-07-16 10:31:32","cancel_description":"","cover_invoice_id":"","red_invoice_id":"","new_invoice_id":"","need_new_invoice":false,"is_draft":false,"is_settle":false,"supplier_id":715,"is_contract_cancel":false,"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":35791,"object_type":103,"object_id":2360,"attachment_id":26863,"attachment":{"id":26863,"key":26863,"name":"de6211aa-f0f3-32b1-8e2d-3dc2318456af","extension":"pdf","path":"\/vue\/attachment\/view\/de6211aa-f0f3-32b1-8e2d-3dc2318456af\/dzfp_25112000000147428991_\u5317\u4eac\u62d3\u5b9e\u79d1\u6280\u6709\u9650\u516c\u53f8_20250715181252(1).pdf","orig_name":"dzfp_25112000000147428991_\u5317\u4eac\u62d3\u5b9e\u79d1\u6280\u6709\u9650\u516c\u53f8_20250715181252(1).pdf"}}],"contract":{"id":4040,"key":4040,"serial_no":"TSKJ20250716-HYF-002","supplier_id":715,"supplier":{"id":715,"key":715,"name":"\u5317\u4eac\u81fb\u7d2b\u8f69\u7535\u5b50\u5546\u52a1\u6709\u9650\u516c\u53f8"}},"supplier":{"id":715,"key":715,"name":"\u5317\u4eac\u81fb\u7d2b\u8f69\u7535\u5b50\u5546\u52a1\u6709\u9650\u516c\u53f8"},"purchaseInvoiceProjects":[],"purchaseInvoiceReminders":[],"purchaseInvoiceProducts":[{"id":1871,"purchase_invoice_id":2360,"title":"750ml","description":"\u9152\u4e50\u4e8b\u5370\u52a0\u971e\u591a\u4e3d\u767d\u8461\u8404\u9152","number":"60","outbound":"0","inventory":"0","unit":"\u74f6","amount":"9000","tax_rate":"13","including_tax":"0","excluding_tax":"7964.6","tax_amount":"1035.4","into_inventory":false,"newProduct":[],"matchSalesInvoice":[]}],"coverInvoices":[],"cancelInvoice":{},"redInvoice":{},"invoice_type_display":"\u6570\u7535\u666e\u7968","including_tax":0,"number":60,"outbound":0,"un_used_amount":0,"tax_rate":["13"],"purchaseInvoiceProductList":[{"tax_rate":13,"amount":9000,"excluding_tax":7964.6,"tax_amount":1035.4,"list":[{"id":1871,"purchase_invoice_id":2360,"title":"750ml","description":"\u9152\u4e50\u4e8b\u5370\u52a0\u971e\u591a\u4e3d\u767d\u8461\u8404\u9152","number":"60","outbound":"0","inventory":"0","unit":"\u74f6","amount":"9000","tax_rate":"13","including_tax":"0","excluding_tax":"7964.6","tax_amount":"1035.4","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":567,"amount":"72151646.94","excluding_tax":"63994032.92","tax_amount":"7916949.23","verify_amount":"67475556.98","un_verify_amount":"4496835.03","un_verify_count":185,"verify_count":359},"pagenation":{"totalcount":566,"thispage":1,"pagesize":20}},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}],"mod":0}', FALSE, '2025-08-04 12:08:55') RETURNING "id"
12:08:55.207	2.4 ms	yii\db\Command::query	SELECT 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")
12:08:55.210	2.4 ms	yii\db\Command::query	SELECT 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")
12:08:55.213	2.4 ms	yii\db\Command::query	SELECT 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"
12:08:55.154	2.3 ms	yii\db\Command::query	SELECT * FROM "global"."vw_user_login" WHERE "id"=5252
12:08:55.157	1.5 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=5252
12:08:55.187	1.5 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=21) AND ("object_id" IN (2382, 2380, 2379, 2377, 2376, 2375, 2374, 2373, 2372, 2371, 2367, 2370, 2369, 2368, 2365, 2364, 2363, 2362, 2361, 2360))
12:08:55.189	1.4 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=103) AND ("object_id" IN (2382, 2380, 2379, 2377, 2376, 2375, 2374, 2373, 2372, 2371, 2367, 2370, 2369, 2368, 2365, 2364, 2363, 2362, 2361, 2360))
12:08:55.195	1.4 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_purchase_invoice_reminders" WHERE "purchase_invoice_id" IN (2382, 2380, 2379, 2377, 2376, 2375, 2374, 2373, 2372, 2371, 2367, 2370, 2369, 2368, 2365, 2364, 2363, 2362, 2361, 2360)
12:08:55.193	1.1 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_purchase_invoice_projects" WHERE "purchase_invoice_id" IN (2382, 2380, 2379, 2377, 2376, 2375, 2374, 2373, 2372, 2371, 2367, 2370, 2369, 2368, 2365, 2364, 2363, 2362, 2361, 2360)
12:08:55.192	0.9 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_suppliers" WHERE "id" IN (431, 236, 608, 715, 262, 68, 138, 365)
12:08:55.221	0.9 ms	yii\db\Command::execute	UPDATE "a57be577deb434"."tbl_visit_module_histories" SET "num"=29, "last_visit_at"='now()' WHERE "id"=54918
12:08:55.186	0.7 ms	yii\db\Command::query	SELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id" IN (1011, 5252, 5388, 5360))
12:08:55.197	0.7 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_purchase_invoice_products" WHERE "purchase_invoice_id" IN (2382, 2380, 2379, 2377, 2376, 2375, 2374, 2373, 2372, 2371, 2367, 2370, 2369, 2368, 2365, 2364, 2363, 2362, 2361, 2360)
12:08:55.199	0.5 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_purchase_contract_invoices" WHERE "red_invoice_id" IN (2382, 2380, 2379, 2377, 2376, 2375, 2374, 2373, 2372, 2371, 2367, 2370, 2369, 2368, 2365, 2364, 2363, 2362, 2361, 2360)
12:08:55.199	0.5 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_purchase_contract_invoices" WHERE "new_invoice_id" IN (2382, 2380, 2379, 2377, 2376, 2375, 2374, 2373, 2372, 2371, 2367, 2370, 2369, 2368, 2365, 2364, 2363, 2362, 2361, 2360)
12:08:55.198	0.4 ms	yii\db\Command::query	SELECT "id", "cover_invoice_id" FROM "a57be577deb434"."tbl_purchase_contract_invoices" WHERE "cover_invoice_id" IN (2382, 2380, 2379, 2377, 2376, 2375, 2374, 2373, 2372, 2371, 2367, 2370, 2369, 2368, 2365, 2364, 2363, 2362, 2361, 2360) ORDER BY "id" DESC
12:08:55.189	0.4 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "name", "extension", "path", "orig_name" FROM "a57be577deb434"."tbl_attachments" WHERE "id" IN (27144, 27154)
12:08:55.186	0.3 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_departments" WHERE "id" IN (3, 6)
12:08:55.183	0.3 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (5252, 1011, 5360, 5388)
12:08:55.194	0.3 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "project_title" AS "name", "client_id" FROM "a57be577deb434"."tbl_projects" WHERE "id" IN (3900, 3827, 3865, 3704, 3918, 3913, 3912, 3841, 3874, 3925, 3924, 3810, 3929, 3928, 3930, 3934)
12:08:55.191	0.3 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "serial_no", "supplier_id" FROM "a57be577deb434"."tbl_purchase_contracts" WHERE "id" IN (4073, 4072, 4069, 4066, 4051, 4067, 4062, 4052, 3929, 4042, 4017, 4038, 4041, 4037, 4023, 4033, 4040)
12:08:55.195	0.3 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_clients" WHERE "id" IN (3387, 12, 2094, 2177, 1663, 1492, 1301, 3343, 3377)
12:08:55.191	0.3 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "name", "extension", "path", "orig_name" FROM "a57be577deb434"."tbl_attachments" WHERE "id" IN (26863, 26874, 26892, 26891, 26912, 27003, 27006, 27005, 27026, 27036, 27039, 27083, 27091, 27095, 27129, 27145, 26984, 27155)
12:08:55.198	0.2 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (1011, 5360)
12:08:55.193	0.2 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_suppliers" WHERE "id" IN (431, 608, 138, 262, 365, 68, 236, 715)