ConfigurationRequestLogsProfilingDatabaseAsset BundlesMailTimeline
68a437cc86416: POST https://beta.jinchangxiao.com/vue/tax/inventory-product-list at 2025-08-19 04:37:32 pm by 223.104.44.8

Database Queries

总计26条数据
TimeDurationTypeQuery
  
16:37:32.5542.7 msSELECTSELECT * FROM "global"."vw_user_login" WHERE "id"=1001

[+] Explain
16:37:32.5582.2 msSELECTSELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001

[+] Explain
16:37:32.5647.1 msSELECTSELECT COUNT(*) FROM (SELECT ip.* FROM "a57be577deb434"."tbl_inventory_products" "ip" LEFT JOIN "a57be577deb434"."tbl_purchase_contract_invoices" "pci" ON ip.purchase_invoice_id = pci.id LEFT JOIN "a57be577deb434"."tbl_purchase_contracts" "pc" ON pc.id = pci.contract_id LEFT JOIN "a57be577deb434"."tbl_suppliers" "s" ON pc.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 ip.inventory > 0 GROUP BY "ip"."id", "pci"."id" ORDER BY pci.from_date DESC nulls last, "ip"."created_at" DESC) "c"

[+] Explain
16:37:32.5712.6 msSELECTSELECT ip.* FROM "a57be577deb434"."tbl_inventory_products" "ip" LEFT JOIN "a57be577deb434"."tbl_purchase_contract_invoices" "pci" ON ip.purchase_invoice_id = pci.id LEFT JOIN "a57be577deb434"."tbl_purchase_contracts" "pc" ON pc.id = pci.contract_id LEFT JOIN "a57be577deb434"."tbl_suppliers" "s" ON pc.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 ip.inventory > 0 GROUP BY "ip"."id", "pci"."id" ORDER BY pci.from_date DESC nulls last, "ip"."created_at" DESC LIMIT 20 OFFSET 100

[+] Explain
16:37:32.5741.1 msSELECTSELECT * FROM "a57be577deb434"."tbl_purchase_contract_invoices" WHERE "id" IN (2042, 2039, 2031, 2029, 2018, 2016, 2013, 1989, 1979, 1946, 1934, 1932, 1908, 1878, 1877, 1876, 1872)

[+] Explain
16:37:32.5760.4 msSELECTSELECT "id", "id" AS "key", "serial_no", "supplier_id" FROM "a57be577deb434"."tbl_purchase_contracts" WHERE "id" IN (3581, 3519, 3508, 3659, 3638, 3606, 3594, 3669, 3631, 3518, 3562, 3489, 3523, 3563, 3560, 3569)

[+] Explain
16:37:32.5760.3 msSELECTSELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_suppliers" WHERE "id" IN (262, 165, 647, 626, 236, 505, 583, 298, 608, 610, 634)

[+] Explain
16:37:32.5770.3 msSELECTSELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_suppliers" WHERE "id" IN (165, 262, 583, 298, 647, 505, 236, 634, 610, 608, 626)

[+] Explain
16:37:32.5770.4 msSELECTSELECT * FROM "a57be577deb434"."tbl_purchase_invoice_projects" WHERE "purchase_invoice_id" IN (1989, 1876, 1872, 2029, 2018, 2042, 2031, 2039, 2016, 2013, 1877, 1946, 1908, 1878, 1934, 1932, 1979)

[+] Explain
16:37:32.5780.3 msSELECTSELECT "id", "id" AS "key", "project_title" AS "name", "client_id" FROM "a57be577deb434"."tbl_projects" WHERE "id" IN (3641, 3636, 3637, 3249, 3669, 3431, 3676, 3697)

[+] Explain
16:37:32.5780.3 msSELECTSELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_clients" WHERE "id" IN (12, 1492, 89, 3309, 3281, 543, 2125)

[+] Explain
16:37:32.5780.3 msSELECTSELECT * FROM "a57be577deb434"."tbl_purchase_invoice_reminders" WHERE "purchase_invoice_id" IN (1989, 1876, 1872, 2029, 2018, 2042, 2031, 2039, 2016, 2013, 1877, 1946, 1908, 1878, 1934, 1932, 1979)

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

[+] Explain
16:37:32.5790.7 msSELECTSELECT * FROM "a57be577deb434"."tbl_purchase_invoice_products" WHERE "purchase_invoice_id" IN (1989, 1876, 1872, 2029, 2018, 2042, 2031, 2039, 2016, 2013, 1877, 1946, 1908, 1878, 1934, 1932, 1979)

[+] Explain
16:37:32.5802.2 msSELECTSELECT COUNT(*) FROM "a57be577deb434"."tbl_inventory_products" WHERE "id" IN (SELECT "ip"."id" FROM "a57be577deb434"."tbl_inventory_products" "ip" LEFT JOIN "a57be577deb434"."tbl_purchase_contract_invoices" "pci" ON ip.purchase_invoice_id = pci.id LEFT JOIN "a57be577deb434"."tbl_purchase_contracts" "pc" ON pc.id = pci.contract_id LEFT JOIN "a57be577deb434"."tbl_suppliers" "s" ON pc.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 ip.inventory > 0 GROUP BY "ip"."id", "pci"."id")

[+] Explain
16:37:32.5832.2 msSELECTSELECT SUM(amount) FROM "a57be577deb434"."tbl_inventory_products" WHERE "id" IN (SELECT "ip"."id" FROM "a57be577deb434"."tbl_inventory_products" "ip" LEFT JOIN "a57be577deb434"."tbl_purchase_contract_invoices" "pci" ON ip.purchase_invoice_id = pci.id LEFT JOIN "a57be577deb434"."tbl_purchase_contracts" "pc" ON pc.id = pci.contract_id LEFT JOIN "a57be577deb434"."tbl_suppliers" "s" ON pc.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 ip.inventory > 0 GROUP BY "ip"."id", "pci"."id")

[+] Explain
16:37:32.5852.1 msSELECTSELECT SUM(number) FROM "a57be577deb434"."tbl_inventory_products" WHERE "id" IN (SELECT "ip"."id" FROM "a57be577deb434"."tbl_inventory_products" "ip" LEFT JOIN "a57be577deb434"."tbl_purchase_contract_invoices" "pci" ON ip.purchase_invoice_id = pci.id LEFT JOIN "a57be577deb434"."tbl_purchase_contracts" "pc" ON pc.id = pci.contract_id LEFT JOIN "a57be577deb434"."tbl_suppliers" "s" ON pc.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 ip.inventory > 0 GROUP BY "ip"."id", "pci"."id")

[+] Explain
16:37:32.5872.2 msSELECTSELECT SUM(outbound) FROM "a57be577deb434"."tbl_inventory_products" WHERE ("id" IN (SELECT "ip"."id" FROM "a57be577deb434"."tbl_inventory_products" "ip" LEFT JOIN "a57be577deb434"."tbl_purchase_contract_invoices" "pci" ON ip.purchase_invoice_id = pci.id LEFT JOIN "a57be577deb434"."tbl_purchase_contracts" "pc" ON pc.id = pci.contract_id LEFT JOIN "a57be577deb434"."tbl_suppliers" "s" ON pc.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 ip.inventory > 0 GROUP BY "ip"."id", "pci"."id")) AND (outbound > 0)

[+] Explain
16:37:32.5902.3 msSELECTSELECT SUM(amount / number * outbound) FROM "a57be577deb434"."tbl_inventory_products" WHERE ("id" IN (SELECT "ip"."id" FROM "a57be577deb434"."tbl_inventory_products" "ip" LEFT JOIN "a57be577deb434"."tbl_purchase_contract_invoices" "pci" ON ip.purchase_invoice_id = pci.id LEFT JOIN "a57be577deb434"."tbl_purchase_contracts" "pc" ON pc.id = pci.contract_id LEFT JOIN "a57be577deb434"."tbl_suppliers" "s" ON pc.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 ip.inventory > 0 GROUP BY "ip"."id", "pci"."id")) AND (outbound > 0)

[+] Explain
16:37:32.5922.3 msSELECTSELECT SUM(inventory) FROM "a57be577deb434"."tbl_inventory_products" WHERE ("id" IN (SELECT "ip"."id" FROM "a57be577deb434"."tbl_inventory_products" "ip" LEFT JOIN "a57be577deb434"."tbl_purchase_contract_invoices" "pci" ON ip.purchase_invoice_id = pci.id LEFT JOIN "a57be577deb434"."tbl_purchase_contracts" "pc" ON pc.id = pci.contract_id LEFT JOIN "a57be577deb434"."tbl_suppliers" "s" ON pc.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 ip.inventory > 0 GROUP BY "ip"."id", "pci"."id")) AND (inventory > 0)

[+] Explain
16:37:32.5952.3 msSELECTSELECT SUM(amount / number * inventory) FROM "a57be577deb434"."tbl_inventory_products" WHERE ("id" IN (SELECT "ip"."id" FROM "a57be577deb434"."tbl_inventory_products" "ip" LEFT JOIN "a57be577deb434"."tbl_purchase_contract_invoices" "pci" ON ip.purchase_invoice_id = pci.id LEFT JOIN "a57be577deb434"."tbl_purchase_contracts" "pc" ON pc.id = pci.contract_id LEFT JOIN "a57be577deb434"."tbl_suppliers" "s" ON pc.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 ip.inventory > 0 GROUP BY "ip"."id", "pci"."id")) AND (inventory > 0)

[+] Explain
16:37:32.5972.1 msSELECTSELECT SUM(excluding_tax) FROM "a57be577deb434"."tbl_inventory_products" WHERE "id" IN (SELECT "ip"."id" FROM "a57be577deb434"."tbl_inventory_products" "ip" LEFT JOIN "a57be577deb434"."tbl_purchase_contract_invoices" "pci" ON ip.purchase_invoice_id = pci.id LEFT JOIN "a57be577deb434"."tbl_purchase_contracts" "pc" ON pc.id = pci.contract_id LEFT JOIN "a57be577deb434"."tbl_suppliers" "s" ON pc.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 ip.inventory > 0 GROUP BY "ip"."id", "pci"."id")

[+] Explain
16:37:32.5992.1 msSELECTSELECT SUM(tax_amount) FROM "a57be577deb434"."tbl_inventory_products" WHERE "id" IN (SELECT "ip"."id" FROM "a57be577deb434"."tbl_inventory_products" "ip" LEFT JOIN "a57be577deb434"."tbl_purchase_contract_invoices" "pci" ON ip.purchase_invoice_id = pci.id LEFT JOIN "a57be577deb434"."tbl_purchase_contracts" "pc" ON pc.id = pci.contract_id LEFT JOIN "a57be577deb434"."tbl_suppliers" "s" ON pc.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 ip.inventory > 0 GROUP BY "ip"."id", "pci"."id")

[+] Explain
16:37:32.6043.5 msSELECTSELECT * FROM "a57be577deb434"."tbl_visit_module_histories" WHERE ("user_id"=1001) AND ("object_type"=10004) AND ("visit_date"='2025-08-19')

[+] Explain
16:37:32.6080.8 msUPDATEUPDATE "a57be577deb434"."tbl_visit_module_histories" SET "num"=85, "last_visit_at"='now()' WHERE "id"=55336

[+] Explain
16:37:32.6092.0 msINSERTINSERT INTO "global"."tbl_api_log" ("code", "schema", "user_id", "device_type", "url", "request", "response", "php_error", "time") VALUES (200, 'a57be577deb434', 1001, 5, 'vue/tax/inventory-product-list', '{"Filter":{"name":"from_date","sort":"DESC"},"InventoryProductSearch":{"from_date_period":"","inventory":"1"},"page":"6","web_access_token":"239qcuu_ToIhJtTt60gp-9_fllLTtTgq"}', '{"code":2000,"result":{"list":[{"id":844,"purchase_invoice_id":2042,"purchase_product_id":817,"title":"TDY-6B","description":"*\u901a\u7528\u8bbe\u5907*\u7ea2\u9ed1\u9694\u79bb\u7535\u6e90\u63d2\u5ea7","number":"10","unit":"\u6761","outbound":"0","inventory":"10","amount":"2300","tax_rate":"13","including_tax":"0","excluding_tax":"2035.4","tax_amount":"264.6","is_build":false,"build_group_id":"","created_at":"2024-11-22 16:00:46","purchaseInvoice":{"id":2042,"contract_id":3606,"amount":"8600","attachment_id":"","from_date":"2024-11-22","created_by":1011,"created_at":"2024-11-22 15:57:37","description":"","invoice_num":"24112000000189081278","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":"0","tax_amount":989.38,"excluding_tax":7610.62,"verify_at":"2024-11-29 00:00:00","is_used":false,"updated_at":"2024-11-22 16:00:46","cancel_description":"","cover_invoice_id":"","red_invoice_id":"","new_invoice_id":"","need_new_invoice":false,"is_draft":false,"is_settle":true,"supplier_id":647,"is_contract_cancel":false,"contract":{"id":3606,"key":3606,"serial_no":"TSKJ20241017-HYF-001","supplier_id":647,"supplier":{"id":647,"key":647,"name":"\u5317\u4eac\u822a\u5929\u7231\u5a01\u7535\u5b50\u6280\u672f\u6709\u9650\u516c\u53f8"}},"supplier":{"id":647,"key":647,"name":"\u5317\u4eac\u822a\u5929\u7231\u5a01\u7535\u5b50\u6280\u672f\u6709\u9650\u516c\u53f8"},"purchaseInvoiceProjects":[{"id":1839,"purchase_invoice_id":2042,"project_id":3249,"project":{"id":3249,"key":3249,"name":"\u5b58\u50a8\u56fd\u4ea7\u5316-K","client_id":2125,"client":{"id":2125,"key":2125,"name":"\u5317\u4eac\u822a\u661f\u673a\u5668\u5236\u9020\u6709\u9650\u516c\u53f8239\u5382"}}}],"purchaseInvoiceReminders":[],"purchaseInvoiceProducts":[{"id":817,"purchase_invoice_id":2042,"title":"TDY-6B","description":"*\u901a\u7528\u8bbe\u5907*\u7ea2\u9ed1\u9694\u79bb\u7535\u6e90\u63d2\u5ea7","number":"10","outbound":"0","inventory":"10","unit":"\u6761","amount":"2300","tax_rate":"13","including_tax":"0","excluding_tax":"2035.4","tax_amount":"264.6","into_inventory":true},{"id":818,"purchase_invoice_id":2042,"title":"TDY-4B","description":"*\u901a\u7528\u8bbe\u5907*\u7ea2\u9ed1\u9694\u79bb\u7535\u6e90\u63d2\u5ea7","number":"30","outbound":"0","inventory":"30","unit":"\u6761","amount":"6300","tax_rate":"13","including_tax":"0","excluding_tax":"5575.22","tax_amount":"724.78","into_inventory":true}],"invoice_type_display":"\u6570\u7535\u4e13\u7968","including_tax":0,"number":40,"un_used_amount":8600,"tax_rate":["13"]}},{"id":846,"purchase_invoice_id":2039,"purchase_product_id":819,"title":"ZK-","description":"*\u7535\u7ebf\u7535\u7f06*\u4e2d\u79d1\u5149\u7535\u4e07\u5146\u591a\u6a21\u5149\u7ea4\u8df3\u7ebfLC-LC\u591a\u6a21\u53cc\u82af 5\u7c73 \u53cc\u5de5\u5149\u7f06\u5c3e\u7ea4OM3 50\/125\u03bcm\u7535\u4fe1\u7ea7\u5149\u7ea4\u7ebfZK-LC-LC\/OM","number":"4","unit":"\u6761","outbound":"0","inventory":"4","amount":"149.36","tax_rate":"13","including_tax":"0","excluding_tax":"132.17","tax_amount":"17.19","is_build":false,"build_group_id":"","created_at":"2024-11-22 17:30:59","purchaseInvoice":{"id":2039,"contract_id":3669,"amount":"149.36","attachment_id":"","from_date":"2024-11-21","created_by":1011,"created_at":"2024-11-21 10:40:37","description":"","invoice_num":"24117000000819333452","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":"0","tax_amount":17.19,"excluding_tax":132.17,"verify_at":"2024-11-29 00:00:00","is_used":false,"updated_at":"2024-11-22 17:30:59","cancel_description":"","cover_invoice_id":"","red_invoice_id":"","new_invoice_id":"","need_new_invoice":false,"is_draft":false,"is_settle":true,"supplier_id":262,"is_contract_cancel":false,"contract":{"id":3669,"key":3669,"serial_no":"300056520336","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":819,"purchase_invoice_id":2039,"title":"ZK-","description":"*\u7535\u7ebf\u7535\u7f06*\u4e2d\u79d1\u5149\u7535\u4e07\u5146\u591a\u6a21\u5149\u7ea4\u8df3\u7ebfLC-LC\u591a\u6a21\u53cc\u82af 5\u7c73 \u53cc\u5de5\u5149\u7f06\u5c3e\u7ea4OM3 50\/125\u03bcm\u7535\u4fe1\u7ea7\u5149\u7ea4\u7ebfZK-LC-LC\/OM","number":"4","outbound":"0","inventory":"4","unit":"\u6761","amount":"149.36","tax_rate":"13","including_tax":"0","excluding_tax":"132.17","tax_amount":"17.19","into_inventory":true}],"invoice_type_display":"\u6570\u7535\u4e13\u7968","including_tax":0,"number":4,"un_used_amount":149.36,"tax_rate":["13"]}},{"id":834,"purchase_invoice_id":2031,"purchase_product_id":802,"title":"16G","description":"*\u8ba1\u7b97\u673a\u914d\u5957\u4ea7\u54c1*\u5185\u5b58\u6761","number":"30","unit":"\u4e2a","outbound":"0","inventory":"30","amount":"5250","tax_rate":"13","including_tax":"0","excluding_tax":"4646.02","tax_amount":"603.98","is_build":false,"build_group_id":"","created_at":"2024-11-19 09:08:04","purchaseInvoice":{"id":2031,"contract_id":3594,"amount":"5250","attachment_id":"","from_date":"2024-11-18","created_by":5360,"created_at":"2024-11-19 09:04:10","description":"","invoice_num":"24112000000184883634","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":"0","tax_amount":603.98,"excluding_tax":4646.02,"verify_at":"2024-11-29 00:00:00","is_used":false,"updated_at":"2024-11-19 09:08:04","cancel_description":"","cover_invoice_id":"","red_invoice_id":"","new_invoice_id":"","need_new_invoice":false,"is_draft":false,"is_settle":true,"supplier_id":505,"is_contract_cancel":false,"contract":{"id":3594,"key":3594,"serial_no":"TSKJ20241015-ZHF-001","supplier_id":505,"supplier":{"id":505,"key":505,"name":"\u795e\u5dde\u6167\u667a\uff08\u5317\u4eac\uff09\u79d1\u6280\u6709\u9650\u516c\u53f8"}},"supplier":{"id":505,"key":505,"name":"\u795e\u5dde\u6167\u667a\uff08\u5317\u4eac\uff09\u79d1\u6280\u6709\u9650\u516c\u53f8"},"purchaseInvoiceProjects":[{"id":1828,"purchase_invoice_id":2031,"project_id":3249,"project":{"id":3249,"key":3249,"name":"\u5b58\u50a8\u56fd\u4ea7\u5316-K","client_id":2125,"client":{"id":2125,"key":2125,"name":"\u5317\u4eac\u822a\u661f\u673a\u5668\u5236\u9020\u6709\u9650\u516c\u53f8239\u5382"}}}],"purchaseInvoiceReminders":[],"purchaseInvoiceProducts":[{"id":802,"purchase_invoice_id":2031,"title":"16G","description":"*\u8ba1\u7b97\u673a\u914d\u5957\u4ea7\u54c1*\u5185\u5b58\u6761","number":"30","outbound":"0","inventory":"30","unit":"\u4e2a","amount":"5250","tax_rate":"13","including_tax":"0","excluding_tax":"4646.02","tax_amount":"603.98","into_inventory":true}],"invoice_type_display":"\u6570\u7535\u4e13\u7968","including_tax":0,"number":30,"un_used_amount":5250,"tax_rate":["13"]}},{"id":832,"purchase_invoice_id":2029,"purchase_product_id":801,"title":"LC-6100C","description":"*\u8ba1\u7b97\u673a\u7f51\u7edc\u8bbe\u5907*\u7f51\u7ebf","number":"1","unit":"\u6761","outbound":"0","inventory":"1","amount":"36","tax_rate":"13","including_tax":"0","excluding_tax":"31.86","tax_amount":"4.14","is_build":false,"build_group_id":"","created_at":"2024-11-18 15:12:47","purchaseInvoice":{"id":2029,"contract_id":3659,"amount":"112","attachment_id":"","from_date":"2024-11-18","created_by":1011,"created_at":"2024-11-18 15:11:30","description":"","invoice_num":"24112000000184258150","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":"0","tax_amount":12.88,"excluding_tax":99.12,"verify_at":"2024-11-29 00:00:00","is_used":false,"updated_at":"2024-11-18 15:12:47","cancel_description":"","cover_invoice_id":"","red_invoice_id":"","new_invoice_id":"","need_new_invoice":false,"is_draft":false,"is_settle":true,"supplier_id":298,"is_contract_cancel":false,"contract":{"id":3659,"key":3659,"serial_no":"TSKJ20241111-HYF-002","supplier_id":298,"supplier":{"id":298,"key":298,"name":"\u5317\u4eac\u777f\u521b\u80dc\u4e3a\u79d1\u6280\u6709\u9650\u516c\u53f8"}},"supplier":{"id":298,"key":298,"name":"\u5317\u4eac\u777f\u521b\u80dc\u4e3a\u79d1\u6280\u6709\u9650\u516c\u53f8"},"purchaseInvoiceProjects":[{"id":1822,"purchase_invoice_id":2029,"project_id":3697,"project":{"id":3697,"key":3697,"name":"\u7fa4\u6656\u5b58\u50a8-RS3618XS-G-2024","client_id":543,"client":{"id":543,"key":543,"name":"\u5317\u4eac\u534e\u7199\u4e2d\u73af\u7269\u4e1a\u7ba1\u7406\u6709\u9650\u516c\u53f8(\u534e\u7199\u56fd\u9645\u6295\u8d44\u96c6\u56e2\u6709\u9650\u516c\u53f8)"}}},{"id":1823,"purchase_invoice_id":2029,"project_id":3249,"project":{"id":3249,"key":3249,"name":"\u5b58\u50a8\u56fd\u4ea7\u5316-K","client_id":2125,"client":{"id":2125,"key":2125,"name":"\u5317\u4eac\u822a\u661f\u673a\u5668\u5236\u9020\u6709\u9650\u516c\u53f8239\u5382"}}}],"purchaseInvoiceReminders":[],"purchaseInvoiceProducts":[{"id":801,"purchase_invoice_id":2029,"title":"LC-6100C","description":"*\u8ba1\u7b97\u673a\u7f51\u7edc\u8bbe\u5907*\u7f51\u7ebf","number":"1","outbound":"0","inventory":"1","unit":"\u6761","amount":"36","tax_rate":"13","including_tax":"0","excluding_tax":"31.86","tax_amount":"4.14","into_inventory":true},{"id":799,"purchase_invoice_id":2029,"title":"LC-6020C","description":"*\u8ba1\u7b97\u673a\u7f51\u7edc\u8bbe\u5907*\u7f51\u7ebf","number":"2","outbound":"0","inventory":"2","unit":"\u6761","amount":"20","tax_rate":"13","including_tax":"0","excluding_tax":"17.7","tax_amount":"2.3","into_inventory":true},{"id":800,"purchase_invoice_id":2029,"title":"LC-6030C","description":"*\u8ba1\u7b97\u673a\u7f51\u7edc\u8bbe\u5907*\u7f51\u7ebf","number":"4","outbound":"0","inventory":"4","unit":"\u6761","amount":"56","tax_rate":"13","including_tax":"0","excluding_tax":"49.56","tax_amount":"6.44","into_inventory":true}],"invoice_type_display":"\u6570\u7535\u4e13\u7968","including_tax":0,"number":7,"un_used_amount":112,"tax_rate":["13"]}},{"id":831,"purchase_invoice_id":2029,"purchase_product_id":800,"title":"LC-6030C","description":"*\u8ba1\u7b97\u673a\u7f51\u7edc\u8bbe\u5907*\u7f51\u7ebf","number":"4","unit":"\u6761","outbound":"0","inventory":"4","amount":"56","tax_rate":"13","including_tax":"0","excluding_tax":"49.56","tax_amount":"6.44","is_build":false,"build_group_id":"","created_at":"2024-11-18 15:12:47","purchaseInvoice":{"id":2029,"contract_id":3659,"amount":"112","attachment_id":"","from_date":"2024-11-18","created_by":1011,"created_at":"2024-11-18 15:11:30","description":"","invoice_num":"24112000000184258150","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":"0","tax_amount":12.88,"excluding_tax":99.12,"verify_at":"2024-11-29 00:00:00","is_used":false,"updated_at":"2024-11-18 15:12:47","cancel_description":"","cover_invoice_id":"","red_invoice_id":"","new_invoice_id":"","need_new_invoice":false,"is_draft":false,"is_settle":true,"supplier_id":298,"is_contract_cancel":false,"contract":{"id":3659,"key":3659,"serial_no":"TSKJ20241111-HYF-002","supplier_id":298,"supplier":{"id":298,"key":298,"name":"\u5317\u4eac\u777f\u521b\u80dc\u4e3a\u79d1\u6280\u6709\u9650\u516c\u53f8"}},"supplier":{"id":298,"key":298,"name":"\u5317\u4eac\u777f\u521b\u80dc\u4e3a\u79d1\u6280\u6709\u9650\u516c\u53f8"},"purchaseInvoiceProjects":[{"id":1822,"purchase_invoice_id":2029,"project_id":3697,"project":{"id":3697,"key":3697,"name":"\u7fa4\u6656\u5b58\u50a8-RS3618XS-G-2024","client_id":543,"client":{"id":543,"key":543,"name":"\u5317\u4eac\u534e\u7199\u4e2d\u73af\u7269\u4e1a\u7ba1\u7406\u6709\u9650\u516c\u53f8(\u534e\u7199\u56fd\u9645\u6295\u8d44\u96c6\u56e2\u6709\u9650\u516c\u53f8)"}}},{"id":1823,"purchase_invoice_id":2029,"project_id":3249,"project":{"id":3249,"key":3249,"name":"\u5b58\u50a8\u56fd\u4ea7\u5316-K","client_id":2125,"client":{"id":2125,"key":2125,"name":"\u5317\u4eac\u822a\u661f\u673a\u5668\u5236\u9020\u6709\u9650\u516c\u53f8239\u5382"}}}],"purchaseInvoiceReminders":[],"purchaseInvoiceProducts":[{"id":801,"purchase_invoice_id":2029,"title":"LC-6100C","description":"*\u8ba1\u7b97\u673a\u7f51\u7edc\u8bbe\u5907*\u7f51\u7ebf","number":"1","outbound":"0","inventory":"1","unit":"\u6761","amount":"36","tax_rate":"13","including_tax":"0","excluding_tax":"31.86","tax_amount":"4.14","into_inventory":true},{"id":799,"purchase_invoice_id":2029,"title":"LC-6020C","description":"*\u8ba1\u7b97\u673a\u7f51\u7edc\u8bbe\u5907*\u7f51\u7ebf","number":"2","outbound":"0","inventory":"2","unit":"\u6761","amount":"20","tax_rate":"13","including_tax":"0","excluding_tax":"17.7","tax_amount":"2.3","into_inventory":true},{"id":800,"purchase_invoice_id":2029,"title":"LC-6030C","description":"*\u8ba1\u7b97\u673a\u7f51\u7edc\u8bbe\u5907*\u7f51\u7ebf","number":"4","outbound":"0","inventory":"4","unit":"\u6761","amount":"56","tax_rate":"13","including_tax":"0","excluding_tax":"49.56","tax_amount":"6.44","into_inventory":true}],"invoice_type_display":"\u6570\u7535\u4e13\u7968","including_tax":0,"number":7,"un_used_amount":112,"tax_rate":["13"]}},{"id":830,"purchase_invoice_id":2029,"purchase_product_id":799,"title":"LC-6020C","description":"*\u8ba1\u7b97\u673a\u7f51\u7edc\u8bbe\u5907*\u7f51\u7ebf","number":"2","unit":"\u6761","outbound":"0","inventory":"2","amount":"20","tax_rate":"13","including_tax":"0","excluding_tax":"17.7","tax_amount":"2.3","is_build":false,"build_group_id":"","created_at":"2024-11-18 15:12:47","purchaseInvoice":{"id":2029,"contract_id":3659,"amount":"112","attachment_id":"","from_date":"2024-11-18","created_by":1011,"created_at":"2024-11-18 15:11:30","description":"","invoice_num":"24112000000184258150","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":"0","tax_amount":12.88,"excluding_tax":99.12,"verify_at":"2024-11-29 00:00:00","is_used":false,"updated_at":"2024-11-18 15:12:47","cancel_description":"","cover_invoice_id":"","red_invoice_id":"","new_invoice_id":"","need_new_invoice":false,"is_draft":false,"is_settle":true,"supplier_id":298,"is_contract_cancel":false,"contract":{"id":3659,"key":3659,"serial_no":"TSKJ20241111-HYF-002","supplier_id":298,"supplier":{"id":298,"key":298,"name":"\u5317\u4eac\u777f\u521b\u80dc\u4e3a\u79d1\u6280\u6709\u9650\u516c\u53f8"}},"supplier":{"id":298,"key":298,"name":"\u5317\u4eac\u777f\u521b\u80dc\u4e3a\u79d1\u6280\u6709\u9650\u516c\u53f8"},"purchaseInvoiceProjects":[{"id":1822,"purchase_invoice_id":2029,"project_id":3697,"project":{"id":3697,"key":3697,"name":"\u7fa4\u6656\u5b58\u50a8-RS3618XS-G-2024","client_id":543,"client":{"id":543,"key":543,"name":"\u5317\u4eac\u534e\u7199\u4e2d\u73af\u7269\u4e1a\u7ba1\u7406\u6709\u9650\u516c\u53f8(\u534e\u7199\u56fd\u9645\u6295\u8d44\u96c6\u56e2\u6709\u9650\u516c\u53f8)"}}},{"id":1823,"purchase_invoice_id":2029,"project_id":3249,"project":{"id":3249,"key":3249,"name":"\u5b58\u50a8\u56fd\u4ea7\u5316-K","client_id":2125,"client":{"id":2125,"key":2125,"name":"\u5317\u4eac\u822a\u661f\u673a\u5668\u5236\u9020\u6709\u9650\u516c\u53f8239\u5382"}}}],"purchaseInvoiceReminders":[],"purchaseInvoiceProducts":[{"id":801,"purchase_invoice_id":2029,"title":"LC-6100C","description":"*\u8ba1\u7b97\u673a\u7f51\u7edc\u8bbe\u5907*\u7f51\u7ebf","number":"1","outbound":"0","inventory":"1","unit":"\u6761","amount":"36","tax_rate":"13","including_tax":"0","excluding_tax":"31.86","tax_amount":"4.14","into_inventory":true},{"id":799,"purchase_invoice_id":2029,"title":"LC-6020C","description":"*\u8ba1\u7b97\u673a\u7f51\u7edc\u8bbe\u5907*\u7f51\u7ebf","number":"2","outbound":"0","inventory":"2","unit":"\u6761","amount":"20","tax_rate":"13","including_tax":"0","excluding_tax":"17.7","tax_amount":"2.3","into_inventory":true},{"id":800,"purchase_invoice_id":2029,"title":"LC-6030C","description":"*\u8ba1\u7b97\u673a\u7f51\u7edc\u8bbe\u5907*\u7f51\u7ebf","number":"4","outbound":"0","inventory":"4","unit":"\u6761","amount":"56","tax_rate":"13","including_tax":"0","excluding_tax":"49.56","tax_amount":"6.44","into_inventory":true}],"invoice_type_display":"\u6570\u7535\u4e13\u7968","including_tax":0,"number":7,"un_used_amount":112,"tax_rate":["13"]}},{"id":800,"purchase_invoice_id":2018,"purchase_product_id":772,"title":"GD6A100","description":"*\u8ba1\u7b97\u673a\u914d\u5957\u4ea7\u54c1*\u5c71\u6cfd \u8d85\u516d\u7c7b\u4e07\u5146\u7eaf\u94dc\u7f51\u7ebf CAT6A\u7c7b\u6210\u54c1\u7ebf \u5bb6 \u7528\u7535\u8111\u7f51\u7edc\u5bbd\u5e26\u5de5\u7a0b\u8df3\u7ebf\u517c\u5bb9\u5343\u51468\u82af2.5g\u8fde\u63a5\u7ebf10\u7c73GD6","number":"4","unit":"\u6839","outbound":"0","inventory":"4","amount":"214.44","tax_rate":"13","including_tax":"0","excluding_tax":"189.77","tax_amount":"24.67","is_build":false,"build_group_id":"","created_at":"2024-11-08 17:04:46","purchaseInvoice":{"id":2018,"contract_id":3638,"amount":"1029.6","attachment_id":"","from_date":"2024-10-31","created_by":1011,"created_at":"2024-11-08 17:01:27","description":"","invoice_num":"24117000000723856033","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":"0","tax_amount":118.45,"excluding_tax":911.15,"verify_at":"2024-11-29 00:00:00","is_used":false,"updated_at":"2024-11-08 17:04:46","cancel_description":"","cover_invoice_id":"","red_invoice_id":"","new_invoice_id":"","need_new_invoice":false,"is_draft":false,"is_settle":true,"supplier_id":262,"is_contract_cancel":false,"contract":{"id":3638,"key":3638,"serial_no":"304576349352","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":1799,"purchase_invoice_id":2018,"project_id":3249,"project":{"id":3249,"key":3249,"name":"\u5b58\u50a8\u56fd\u4ea7\u5316-K","client_id":2125,"client":{"id":2125,"key":2125,"name":"\u5317\u4eac\u822a\u661f\u673a\u5668\u5236\u9020\u6709\u9650\u516c\u53f8239\u5382"}}}],"purchaseInvoiceReminders":[],"purchaseInvoiceProducts":[{"id":771,"purchase_invoice_id":2018,"title":"G3-LCLC10","description":"*\u8ba1\u7b97\u673a\u914d\u5957\u4ea7\u54c1*\u5c71\u6cfd(SAMZHE)\u7535\u4fe1\u7ea7\u4e07\u5146\u5149\u7ea4\u8df3\u7ebf LC- LC\u591a\u6a21\u53cc\u82afOM3-300 \u4f4e\u70df\u65e0\u5364 \u5149\u7ea4\u7ebf 10\u7c73G3-LCLC10","number":"12","outbound":"0","inventory":"12","unit":"\u6761","amount":"815.16","tax_rate":"13","including_tax":"0","excluding_tax":"721.38","tax_amount":"93.78","into_inventory":true},{"id":772,"purchase_invoice_id":2018,"title":"GD6A100","description":"*\u8ba1\u7b97\u673a\u914d\u5957\u4ea7\u54c1*\u5c71\u6cfd \u8d85\u516d\u7c7b\u4e07\u5146\u7eaf\u94dc\u7f51\u7ebf CAT6A\u7c7b\u6210\u54c1\u7ebf \u5bb6 \u7528\u7535\u8111\u7f51\u7edc\u5bbd\u5e26\u5de5\u7a0b\u8df3\u7ebf\u517c\u5bb9\u5343\u51468\u82af2.5g\u8fde\u63a5\u7ebf10\u7c73GD6","number":"4","outbound":"0","inventory":"4","unit":"\u6839","amount":"214.44","tax_rate":"13","including_tax":"0","excluding_tax":"189.77","tax_amount":"24.67","into_inventory":true}],"invoice_type_display":"\u6570\u7535\u4e13\u7968","including_tax":0,"number":16,"un_used_amount":1029.6,"tax_rate":["13"]}},{"id":799,"purchase_invoice_id":2018,"purchase_product_id":771,"title":"G3-LCLC10","description":"*\u8ba1\u7b97\u673a\u914d\u5957\u4ea7\u54c1*\u5c71\u6cfd(SAMZHE)\u7535\u4fe1\u7ea7\u4e07\u5146\u5149\u7ea4\u8df3\u7ebf LC- LC\u591a\u6a21\u53cc\u82afOM3-300 \u4f4e\u70df\u65e0\u5364 \u5149\u7ea4\u7ebf 10\u7c73G3-LCLC10","number":"12","unit":"\u6761","outbound":"0","inventory":"12","amount":"815.16","tax_rate":"13","including_tax":"0","excluding_tax":"721.38","tax_amount":"93.78","is_build":false,"build_group_id":"","created_at":"2024-11-08 17:04:46","purchaseInvoice":{"id":2018,"contract_id":3638,"amount":"1029.6","attachment_id":"","from_date":"2024-10-31","created_by":1011,"created_at":"2024-11-08 17:01:27","description":"","invoice_num":"24117000000723856033","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":"0","tax_amount":118.45,"excluding_tax":911.15,"verify_at":"2024-11-29 00:00:00","is_used":false,"updated_at":"2024-11-08 17:04:46","cancel_description":"","cover_invoice_id":"","red_invoice_id":"","new_invoice_id":"","need_new_invoice":false,"is_draft":false,"is_settle":true,"supplier_id":262,"is_contract_cancel":false,"contract":{"id":3638,"key":3638,"serial_no":"304576349352","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":1799,"purchase_invoice_id":2018,"project_id":3249,"project":{"id":3249,"key":3249,"name":"\u5b58\u50a8\u56fd\u4ea7\u5316-K","client_id":2125,"client":{"id":2125,"key":2125,"name":"\u5317\u4eac\u822a\u661f\u673a\u5668\u5236\u9020\u6709\u9650\u516c\u53f8239\u5382"}}}],"purchaseInvoiceReminders":[],"purchaseInvoiceProducts":[{"id":771,"purchase_invoice_id":2018,"title":"G3-LCLC10","description":"*\u8ba1\u7b97\u673a\u914d\u5957\u4ea7\u54c1*\u5c71\u6cfd(SAMZHE)\u7535\u4fe1\u7ea7\u4e07\u5146\u5149\u7ea4\u8df3\u7ebf LC- LC\u591a\u6a21\u53cc\u82afOM3-300 \u4f4e\u70df\u65e0\u5364 \u5149\u7ea4\u7ebf 10\u7c73G3-LCLC10","number":"12","outbound":"0","inventory":"12","unit":"\u6761","amount":"815.16","tax_rate":"13","including_tax":"0","excluding_tax":"721.38","tax_amount":"93.78","into_inventory":true},{"id":772,"purchase_invoice_id":2018,"title":"GD6A100","description":"*\u8ba1\u7b97\u673a\u914d\u5957\u4ea7\u54c1*\u5c71\u6cfd \u8d85\u516d\u7c7b\u4e07\u5146\u7eaf\u94dc\u7f51\u7ebf CAT6A\u7c7b\u6210\u54c1\u7ebf \u5bb6 \u7528\u7535\u8111\u7f51\u7edc\u5bbd\u5e26\u5de5\u7a0b\u8df3\u7ebf\u517c\u5bb9\u5343\u51468\u82af2.5g\u8fde\u63a5\u7ebf10\u7c73GD6","number":"4","outbound":"0","inventory":"4","unit":"\u6839","amount":"214.44","tax_rate":"13","including_tax":"0","excluding_tax":"189.77","tax_amount":"24.67","into_inventory":true}],"invoice_type_display":"\u6570\u7535\u4e13\u7968","including_tax":0,"number":16,"un_used_amount":1029.6,"tax_rate":["13"]}},{"id":802,"purchase_invoice_id":2016,"purchase_product_id":774,"title":"GD6A050","description":"*\u8ba1\u7b97\u673a\u914d\u5957\u4ea7\u54c1*\u5c71\u6cfd\u8d85\u516d\u7c7b\u4e07\u5146\u7eaf\u94dc\u7f51\u7ebf CAT6A\u7c7b\u6210\u54c1\u7ebf \u5bb6\u7528 \u7535\u8111\u7f51\u7edc\u5bbd\u5e26\u5de5\u7a0b\u8df3\u7ebf\u517c\u5bb9\u5343\u51468\u82af2.5g\u8fde\u63a5\u7ebf 5\u7c73GD6A","number":"2","unit":"\u6839","outbound":"0","inventory":"2","amount":"58.88","tax_rate":"13","including_tax":"0","excluding_tax":"52.11","tax_amount":"6.77","is_build":false,"build_group_id":"","created_at":"2024-11-08 17:06:19","purchaseInvoice":{"id":2016,"contract_id":3638,"amount":"58.88","attachment_id":"","from_date":"2024-10-30","created_by":1011,"created_at":"2024-11-08 17:00:29","description":"","invoice_num":"24117000000722331254","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":"0","tax_amount":6.77,"excluding_tax":52.11,"verify_at":"2024-11-29 00:00:00","is_used":false,"updated_at":"2024-11-08 17:06:19","cancel_description":"","cover_invoice_id":"","red_invoice_id":"","new_invoice_id":"","need_new_invoice":false,"is_draft":false,"is_settle":true,"supplier_id":262,"is_contract_cancel":false,"contract":{"id":3638,"key":3638,"serial_no":"304576349352","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":1801,"purchase_invoice_id":2016,"project_id":3249,"project":{"id":3249,"key":3249,"name":"\u5b58\u50a8\u56fd\u4ea7\u5316-K","client_id":2125,"client":{"id":2125,"key":2125,"name":"\u5317\u4eac\u822a\u661f\u673a\u5668\u5236\u9020\u6709\u9650\u516c\u53f8239\u5382"}}}],"purchaseInvoiceReminders":[],"purchaseInvoiceProducts":[{"id":774,"purchase_invoice_id":2016,"title":"GD6A050","description":"*\u8ba1\u7b97\u673a\u914d\u5957\u4ea7\u54c1*\u5c71\u6cfd\u8d85\u516d\u7c7b\u4e07\u5146\u7eaf\u94dc\u7f51\u7ebf CAT6A\u7c7b\u6210\u54c1\u7ebf \u5bb6\u7528 \u7535\u8111\u7f51\u7edc\u5bbd\u5e26\u5de5\u7a0b\u8df3\u7ebf\u517c\u5bb9\u5343\u51468\u82af2.5g\u8fde\u63a5\u7ebf 5\u7c73GD6A","number":"2","outbound":"0","inventory":"2","unit":"\u6839","amount":"58.88","tax_rate":"13","including_tax":"0","excluding_tax":"52.11","tax_amount":"6.77","into_inventory":true}],"invoice_type_display":"\u6570\u7535\u4e13\u7968","including_tax":0,"number":2,"un_used_amount":58.88,"tax_rate":["13"]}},{"id":798,"purchase_invoice_id":2013,"purchase_product_id":768,"title":"","description":"*\u4fe1\u606f\u6280\u672f\u670d\u52a1*\u7edf\u4e00\u7aef\u70b9 \u5b89\u5168\u7ba1\u7406\u7cfb\u7edf\u670d\u52a1\u8d39","number":"200","unit":"\u6b21","outbound":"0","inventory":"200","amount":"10850","tax_rate":"6","including_tax":"0","excluding_tax":"10235.85","tax_amount":"614.15","is_build":false,"build_group_id":"","created_at":"2024-11-08 09:47:41","purchaseInvoice":{"id":2013,"contract_id":3631,"amount":"10850","attachment_id":"","from_date":"2024-10-30","created_by":1011,"created_at":"2024-11-08 09:46:36","description":"","invoice_num":"24112000000166771660","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":"0","tax_amount":614.15,"excluding_tax":10235.85,"verify_at":"2024-11-29 00:00:00","is_used":false,"updated_at":"2024-11-08 09:47:41","cancel_description":"","cover_invoice_id":"","red_invoice_id":"","new_invoice_id":"","need_new_invoice":false,"is_draft":false,"is_settle":true,"supplier_id":236,"is_contract_cancel":false,"contract":{"id":3631,"key":3631,"serial_no":"TSKJ20241029-HYF-002","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":1795,"purchase_invoice_id":2013,"project_id":3676,"project":{"id":3676,"key":3676,"name":"\u6df1\u4fe1\u670dEDR","client_id":3309,"client":{"id":3309,"key":3309,"name":"\u4e2d\u90fd\uff08\u682a\u6d32\uff09\u7269\u6d41\u6709\u9650\u516c\u53f8"}}}],"purchaseInvoiceReminders":[],"purchaseInvoiceProducts":[{"id":768,"purchase_invoice_id":2013,"title":"","description":"*\u4fe1\u606f\u6280\u672f\u670d\u52a1*\u7edf\u4e00\u7aef\u70b9 \u5b89\u5168\u7ba1\u7406\u7cfb\u7edf\u670d\u52a1\u8d39","number":"200","outbound":"0","inventory":"200","unit":"\u6b21","amount":"10850","tax_rate":"6","including_tax":"0","excluding_tax":"10235.85","tax_amount":"614.15","into_inventory":true}],"invoice_type_display":"\u6570\u7535\u4e13\u7968","including_tax":0,"number":200,"un_used_amount":10850,"tax_rate":["6"]}},{"id":623,"purchase_invoice_id":1989,"purchase_product_id":593,"title":"16TB","description":"*\u8ba1\u7b97\u673a\u5916\u90e8\u8bbe\u5907*\u786c\u76d8","number":"2","unit":"\u5757","outbound":"0","inventory":"2","amount":"6000","tax_rate":"13","including_tax":"0","excluding_tax":"5309.73","tax_amount":"690.27","is_build":false,"build_group_id":"","created_at":"2024-10-28 16:31:27","purchaseInvoice":{"id":1989,"contract_id":3581,"amount":"6000","attachment_id":"","from_date":"2024-10-25","created_by":5360,"created_at":"2024-10-28 16:30:14","description":"","invoice_num":"24112000000162606387\uff08\u8d1d\u745e\uff09","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":"0","tax_amount":690.27,"excluding_tax":5309.73,"verify_at":"2024-10-31 00:00:00","is_used":false,"updated_at":"2024-10-28 16:31:27","cancel_description":"","cover_invoice_id":"","red_invoice_id":"","new_invoice_id":"","need_new_invoice":false,"is_draft":false,"is_settle":true,"supplier_id":165,"is_contract_cancel":false,"contract":{"id":3581,"key":3581,"serial_no":"20240929","supplier_id":165,"supplier":{"id":165,"key":165,"name":"\u5317\u4eac\u7eb3\u6069\u6052\u6cf0\u79d1\u6280\u6709\u9650\u516c\u53f8"}},"supplier":{"id":165,"key":165,"name":"\u5317\u4eac\u7eb3\u6069\u6052\u6cf0\u79d1\u6280\u6709\u9650\u516c\u53f8"},"purchaseInvoiceProjects":[{"id":1753,"purchase_invoice_id":1989,"project_id":3431,"project":{"id":3431,"key":3431,"name":"2024\u5e74\u5b58\u50a8\u7ef4\u4fdd\u670d\u52a1","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":593,"purchase_invoice_id":1989,"title":"16TB","description":"*\u8ba1\u7b97\u673a\u5916\u90e8\u8bbe\u5907*\u786c\u76d8","number":"2","outbound":"0","inventory":"2","unit":"\u5757","amount":"6000","tax_rate":"13","including_tax":"0","excluding_tax":"5309.73","tax_amount":"690.27","into_inventory":true}],"invoice_type_display":"\u6570\u7535\u4e13\u7968","including_tax":0,"number":2,"un_used_amount":6000,"tax_rate":["13"]}},{"id":602,"purchase_invoice_id":1979,"purchase_product_id":577,"title":"SFP-GE-LX-SM1310-D","description":"*\u8ba1\u7b97\u673a\u7f51\u7edc\u8bbe\u5907*\u6a21\u5757","number":"2","unit":"\u4e2a","outbound":"0","inventory":"2","amount":"220","tax_rate":"13","including_tax":"0","excluding_tax":"194.69","tax_amount":"25.31","is_build":false,"build_group_id":"","created_at":"2024-10-23 15:16:58","purchaseInvoice":{"id":1979,"contract_id":3569,"amount":"220","attachment_id":"","from_date":"2024-10-23","created_by":5360,"created_at":"2024-10-23 15:15:48","description":"","invoice_num":"24112000000160399622","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":"0","tax_amount":25.31,"excluding_tax":194.69,"verify_at":"2024-10-31 00:00:00","is_used":false,"updated_at":"2024-10-23 15:16:58","cancel_description":"","cover_invoice_id":"","red_invoice_id":"","new_invoice_id":"","need_new_invoice":false,"is_draft":false,"is_settle":true,"supplier_id":626,"is_contract_cancel":false,"contract":{"id":3569,"key":3569,"serial_no":"TSKJ20240925-ZHF-001","supplier_id":626,"supplier":{"id":626,"key":626,"name":"\u5317\u4eac\u6167\u79d1\u5929\u6b63\u79d1\u6280\u6709\u9650\u516c\u53f8"}},"supplier":{"id":626,"key":626,"name":"\u5317\u4eac\u6167\u79d1\u5929\u6b63\u79d1\u6280\u6709\u9650\u516c\u53f8"},"purchaseInvoiceProjects":[{"id":1730,"purchase_invoice_id":1979,"project_id":3669,"project":{"id":3669,"key":3669,"name":"POTJ24094705-\u6a21\u5757-SFP-GE-LX-SM1310-D-G-2024","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":577,"purchase_invoice_id":1979,"title":"SFP-GE-LX-SM1310-D","description":"*\u8ba1\u7b97\u673a\u7f51\u7edc\u8bbe\u5907*\u6a21\u5757","number":"2","outbound":"0","inventory":"2","unit":"\u4e2a","amount":"220","tax_rate":"13","including_tax":"0","excluding_tax":"194.69","tax_amount":"25.31","into_inventory":true}],"invoice_type_display":"\u6570\u7535\u4e13\u7968","including_tax":0,"number":2,"un_used_amount":220,"tax_rate":["13"]}},{"id":570,"purchase_invoice_id":1946,"purchase_product_id":294,"title":"53604","description":"*\u8ba1\u7b97\u673a\u914d\u5957\u4ea7\u54c1*\u58a8\u76d2","number":"25","unit":"\u652f","outbound":"0","inventory":"25","amount":"8250","tax_rate":"13","including_tax":"0","excluding_tax":"7300.88","tax_amount":"949.12","is_build":false,"build_group_id":"","created_at":"2024-10-12 16:00:20","purchaseInvoice":{"id":1946,"contract_id":3562,"amount":"8250","attachment_id":"","from_date":"2024-10-02","created_by":1011,"created_at":"2024-10-09 14:21:41","description":"","invoice_num":"24112000000144282267","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":"0","tax_amount":949.12,"excluding_tax":7300.88,"verify_at":"2024-10-31 00:00:00","is_used":false,"updated_at":"2024-10-12 16:00:20","cancel_description":"","cover_invoice_id":"","red_invoice_id":"","new_invoice_id":"","need_new_invoice":false,"is_draft":false,"is_settle":true,"supplier_id":262,"is_contract_cancel":false,"contract":{"id":3562,"key":3562,"serial_no":" 297192932787","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":1696,"purchase_invoice_id":1946,"project_id":3249,"project":{"id":3249,"key":3249,"name":"\u5b58\u50a8\u56fd\u4ea7\u5316-K","client_id":2125,"client":{"id":2125,"key":2125,"name":"\u5317\u4eac\u822a\u661f\u673a\u5668\u5236\u9020\u6709\u9650\u516c\u53f8239\u5382"}}}],"purchaseInvoiceReminders":[],"purchaseInvoiceProducts":[{"id":294,"purchase_invoice_id":1946,"title":"53604","description":"*\u8ba1\u7b97\u673a\u914d\u5957\u4ea7\u54c1*\u58a8\u76d2","number":"25","outbound":"0","inventory":"25","unit":"\u652f","amount":"8250","tax_rate":"13","including_tax":"0","excluding_tax":"7300.88","tax_amount":"949.12","into_inventory":true}],"invoice_type_display":"\u6570\u7535\u4e13\u7968","including_tax":0,"number":25,"un_used_amount":8250,"tax_rate":["13"]}},{"id":256,"purchase_invoice_id":1934,"purchase_product_id":253,"title":"CD-R","description":"*\u4fe1\u606f\u5316\u5b66\u54c1*\u7d2b\u5149(UNIS) CD-R\u76d8\u9762\u53ef\u6253\u5370\/\u7a7a \u767d\u5149\u76d8\/\u523b\u5f55\u76d8 52\u901f700M \u771f\u5f69\u53ef\u6253\u5370 \u6876\u88c550\u7247 \u6570 \u91cf 8 \u5355 \u4ef7 51.3275 \u91d1 \u989d \u7a0e\u7387\/\u5f81\u6536\u7387 \u7a0e \u989d 53.38 -0.27","number":"8","unit":"\u6876","outbound":"0","inventory":"8","amount":"461.66","tax_rate":"13","including_tax":"0","excluding_tax":"408.55","tax_amount":"53.11","is_build":false,"build_group_id":"","created_at":"2024-09-26 16:36:24","purchaseInvoice":{"id":1934,"contract_id":3563,"amount":"461.66","attachment_id":"","from_date":"2024-09-26","created_by":1011,"created_at":"2024-09-26 16:35:04","description":"","invoice_num":"24127000000097746545","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":"0","tax_amount":53.11,"excluding_tax":408.55,"verify_at":"2024-09-30 00:00:00","is_used":false,"updated_at":"2024-09-26 16:36:24","cancel_description":"","cover_invoice_id":"","red_invoice_id":"","new_invoice_id":"","need_new_invoice":false,"is_draft":false,"is_settle":true,"supplier_id":262,"is_contract_cancel":false,"contract":{"id":3563,"key":3563,"serial_no":"297088938071","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":1661,"purchase_invoice_id":1934,"project_id":3249,"project":{"id":3249,"key":3249,"name":"\u5b58\u50a8\u56fd\u4ea7\u5316-K","client_id":2125,"client":{"id":2125,"key":2125,"name":"\u5317\u4eac\u822a\u661f\u673a\u5668\u5236\u9020\u6709\u9650\u516c\u53f8239\u5382"}}}],"purchaseInvoiceReminders":[],"purchaseInvoiceProducts":[{"id":253,"purchase_invoice_id":1934,"title":"CD-R","description":"*\u4fe1\u606f\u5316\u5b66\u54c1*\u7d2b\u5149(UNIS) CD-R\u76d8\u9762\u53ef\u6253\u5370\/\u7a7a \u767d\u5149\u76d8\/\u523b\u5f55\u76d8 52\u901f700M \u771f\u5f69\u53ef\u6253\u5370 \u6876\u88c550\u7247 \u6570 \u91cf 8 \u5355 \u4ef7 51.3275 \u91d1 \u989d \u7a0e\u7387\/\u5f81\u6536\u7387 \u7a0e \u989d 53.38 -0.27","number":"8","outbound":"0","inventory":"8","unit":"\u6876","amount":"461.66","tax_rate":"13","including_tax":"0","excluding_tax":"408.55","tax_amount":"53.11","into_inventory":true}],"invoice_type_display":"\u6570\u7535\u4e13\u7968","including_tax":0,"number":8,"un_used_amount":461.66,"tax_rate":["13"]}},{"id":253,"purchase_invoice_id":1932,"purchase_product_id":250,"title":"CD-R","description":"*\u4fe1\u606f\u5316\u5b66\u54c1*\u7d2b\u5149(UNIS) CD-R\u76d8\u9762\u53ef\u6253\u5370\/\u7a7a \u767d\u5149\u76d8\/\u523b\u5f55\u76d852\u901f700M\u771f\u5f69\u53ef\u6253\u5370\u6876\u88c550\u7247","number":"52","unit":"\u6876","outbound":"48","inventory":"4","amount":"3000.9","tax_rate":"13","including_tax":"0","excluding_tax":"2655.67","tax_amount":"345.23","is_build":false,"build_group_id":"","created_at":"2024-09-26 09:47:48","purchaseInvoice":{"id":1932,"contract_id":3560,"amount":"3000.9","attachment_id":"","from_date":"2024-09-26","created_by":1011,"created_at":"2024-09-26 09:45:08","description":"","invoice_num":"24127000000097179955","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":"2770.08","tax_amount":345.23,"excluding_tax":2655.67,"verify_at":"2024-09-30 00:00:00","is_used":true,"updated_at":"2024-09-26 17:13:01","cancel_description":"","cover_invoice_id":"","red_invoice_id":"","new_invoice_id":"","need_new_invoice":false,"is_draft":false,"is_settle":true,"supplier_id":262,"is_contract_cancel":false,"contract":{"id":3560,"key":3560,"serial_no":"301497451115","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":1662,"purchase_invoice_id":1932,"project_id":3249,"project":{"id":3249,"key":3249,"name":"\u5b58\u50a8\u56fd\u4ea7\u5316-K","client_id":2125,"client":{"id":2125,"key":2125,"name":"\u5317\u4eac\u822a\u661f\u673a\u5668\u5236\u9020\u6709\u9650\u516c\u53f8239\u5382"}}}],"purchaseInvoiceReminders":[],"purchaseInvoiceProducts":[{"id":250,"purchase_invoice_id":1932,"title":"CD-R","description":"*\u4fe1\u606f\u5316\u5b66\u54c1*\u7d2b\u5149(UNIS) CD-R\u76d8\u9762\u53ef\u6253\u5370\/\u7a7a \u767d\u5149\u76d8\/\u523b\u5f55\u76d852\u901f700M\u771f\u5f69\u53ef\u6253\u5370\u6876\u88c550\u7247","number":"52","outbound":"48","inventory":"4","unit":"\u6876","amount":"3000.9","tax_rate":"13","including_tax":"0","excluding_tax":"2655.67","tax_amount":"345.23","into_inventory":true}],"invoice_type_display":"\u6570\u7535\u4e13\u7968","including_tax":0,"number":52,"un_used_amount":230.82,"tax_rate":["13"]}},{"id":220,"purchase_invoice_id":1908,"purchase_product_id":217,"title":"FC-10-0400F-928-02-36","description":"*\u8f6f\u4ef6*\u8f6f\u4ef6\u8ba2\u9605\u670d\u52a1","number":"2","unit":"\u4e2a","outbound":"0","inventory":"2","amount":"142000","tax_rate":"13","including_tax":"0","excluding_tax":"125663.72","tax_amount":"16336.28","is_build":false,"build_group_id":"","created_at":"2024-09-14 17:15:49","purchaseInvoice":{"id":1908,"contract_id":3489,"amount":"247000","attachment_id":"","from_date":"2024-09-14","created_by":1011,"created_at":"2024-09-14 17:14:24","description":"","invoice_num":"24112000000130701316","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":"105000","tax_amount":28415.93,"excluding_tax":218584.07,"verify_at":"2024-09-30 00:00:00","is_used":true,"updated_at":"2024-09-14 17:17:04","cancel_description":"","cover_invoice_id":"","red_invoice_id":"","new_invoice_id":"","need_new_invoice":false,"is_draft":false,"is_settle":true,"supplier_id":610,"is_contract_cancel":false,"contract":{"id":3489,"key":3489,"serial_no":"MST20240812-HRB-ZW-01","supplier_id":610,"supplier":{"id":610,"key":610,"name":"\u5317\u4eac\u9ea6\u5f17\u745e\u79d1\u6280\u6709\u9650\u516c\u53f8"}},"supplier":{"id":610,"key":610,"name":"\u5317\u4eac\u9ea6\u5f17\u745e\u79d1\u6280\u6709\u9650\u516c\u53f8"},"purchaseInvoiceProjects":[{"id":1639,"purchase_invoice_id":1908,"project_id":3636,"project":{"id":3636,"key":3636,"name":"DMZ\u533a\u98de\u5854\u9632\u706b\u5899","client_id":89,"client":{"id":89,"key":89,"name":"\u5c71\u4e1c\u91d1\u8f6f\u79d1\u6280\u80a1\u4efd\u6709\u9650\u516c\u53f8(\u62db\u91d1\u77ff\u4e1a\u80a1\u4efd\u6709\u9650\u516c\u53f8)"}}}],"purchaseInvoiceReminders":[],"purchaseInvoiceProducts":[{"id":216,"purchase_invoice_id":1908,"title":"FG-400F","description":"*\u4fe1\u606f\u5b89\u5168\u4ea7\u54c1*\u9632\u706b\u5899","number":"2","outbound":"2","inventory":"0","unit":"\u4e2a","amount":"105000","tax_rate":"13","including_tax":"0","excluding_tax":"92920.35","tax_amount":"12079.65","into_inventory":true},{"id":217,"purchase_invoice_id":1908,"title":"FC-10-0400F-928-02-36","description":"*\u8f6f\u4ef6*\u8f6f\u4ef6\u8ba2\u9605\u670d\u52a1","number":"2","outbound":"0","inventory":"2","unit":"\u4e2a","amount":"142000","tax_rate":"13","including_tax":"0","excluding_tax":"125663.72","tax_amount":"16336.28","into_inventory":true}],"invoice_type_display":"\u6570\u7535\u4e13\u7968","including_tax":0,"number":4,"un_used_amount":142000,"tax_rate":["13"]}},{"id":156,"purchase_invoice_id":1878,"purchase_product_id":156,"title":"xdywlh8","description":"*\u5176\u4ed6\u98df\u54c1*\u3010\u6d3b\u52a8\u4ef7\u3011\u3010\u4e2d\u79cb\u793c\u76d2\u3011\u71d5\u4e4b\u5c4b\u9c9c\u7096 \u71d5\u7a9d\u7e41\u82b1\u793c\u76d240g8\u74f6\u6b63\u54c1 \u5373\u98df\u6ecb\u8865\u9001\u793c\u54c1","number":"80","unit":"","outbound":"0","inventory":"80","amount":"30400","tax_rate":"13","including_tax":"0","excluding_tax":"26902.65","tax_amount":"3497.35","is_build":false,"build_group_id":"","created_at":"2024-09-05 15:16:45","purchaseInvoice":{"id":1878,"contract_id":3523,"amount":"30400","attachment_id":"","from_date":"2024-09-05","created_by":1011,"created_at":"2024-09-05 15:08:30","description":"","invoice_num":"24942000000038325482","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":3497.35,"excluding_tax":26902.65,"verify_at":"","is_used":false,"updated_at":"2024-09-09 09:11:54","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,"contract":{"id":3523,"key":3523,"serial_no":"4029508008222161702","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":156,"purchase_invoice_id":1878,"title":"xdywlh8","description":"*\u5176\u4ed6\u98df\u54c1*\u3010\u6d3b\u52a8\u4ef7\u3011\u3010\u4e2d\u79cb\u793c\u76d2\u3011\u71d5\u4e4b\u5c4b\u9c9c\u7096 \u71d5\u7a9d\u7e41\u82b1\u793c\u76d240g8\u74f6\u6b63\u54c1 \u5373\u98df\u6ecb\u8865\u9001\u793c\u54c1","number":"80","outbound":"0","inventory":"80","unit":"","amount":"30400","tax_rate":"13","including_tax":"0","excluding_tax":"26902.65","tax_amount":"3497.35","into_inventory":true}],"invoice_type_display":"\u6570\u7535\u666e\u7968","including_tax":0,"number":80,"un_used_amount":30400,"tax_rate":["13"]}},{"id":155,"purchase_invoice_id":1877,"purchase_product_id":155,"title":"","description":"*\u9274\u8bc1\u54a8\u8be2\u670d\u52a1*\u8ba4\u8bc1\u670d\u52a1\u8d39","number":"1","unit":"","outbound":"0","inventory":"1","amount":"4500","tax_rate":"6","including_tax":"0","excluding_tax":"4245.28","tax_amount":"254.72","is_build":false,"build_group_id":"","created_at":"2024-09-05 11:18:14","purchaseInvoice":{"id":1877,"contract_id":3518,"amount":"4500","attachment_id":"","from_date":"2024-09-05","created_by":1011,"created_at":"2024-09-05 11:09:35","description":"","invoice_num":"24112000000122594900","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":"0","tax_amount":254.72,"excluding_tax":4245.28,"verify_at":"2024-09-30 00:00:00","is_used":false,"updated_at":"2024-09-05 11:18:14","cancel_description":"","cover_invoice_id":"","red_invoice_id":"","new_invoice_id":"","need_new_invoice":false,"is_draft":false,"is_settle":true,"supplier_id":634,"is_contract_cancel":false,"contract":{"id":3518,"key":3518,"serial_no":"QP0901R02-1","supplier_id":634,"supplier":{"id":634,"key":634,"name":"\u5317\u4eac\u65b0\u7eaa\u6e90\u8ba4\u8bc1\u6709\u9650\u516c\u53f8"}},"supplier":{"id":634,"key":634,"name":"\u5317\u4eac\u65b0\u7eaa\u6e90\u8ba4\u8bc1\u6709\u9650\u516c\u53f8"},"purchaseInvoiceProjects":[],"purchaseInvoiceReminders":[],"purchaseInvoiceProducts":[{"id":155,"purchase_invoice_id":1877,"title":"","description":"*\u9274\u8bc1\u54a8\u8be2\u670d\u52a1*\u8ba4\u8bc1\u670d\u52a1\u8d39","number":"1","outbound":"0","inventory":"1","unit":"","amount":"4500","tax_rate":"6","including_tax":"0","excluding_tax":"4245.28","tax_amount":"254.72","into_inventory":true}],"invoice_type_display":"\u6570\u7535\u4e13\u7968","including_tax":0,"number":1,"un_used_amount":4500,"tax_rate":["6"]}},{"id":246,"purchase_invoice_id":1876,"purchase_product_id":230,"title":"BY-W1552M","description":"*\u8ba1\u7b97\u673a\u914d\u5957\u4ea7\u54c1*\u535a\u626c \u4e07\u5146\u591a\u6a21\u5149\u7ea4\u8df3\u7ebflc-lc 1\u7c73 OM3-300\u53cc \u82af\u5c3e\u7ea4 \u03a62.0\u963b\u71c3\u4f4e\u70df\u65e0\u5364\u5149\u6a21\u5757\u4e13\u7528\u8df3\u7ea4\u5149\u7ea4\u7ebfBY-W15","number":"5","unit":"\u6761","outbound":"0","inventory":"5","amount":"168.2","tax_rate":"13","including_tax":"0","excluding_tax":"148.85","tax_amount":"19.35","is_build":false,"build_group_id":"","created_at":"2024-09-24 13:54:20","purchaseInvoice":{"id":1876,"contract_id":3519,"amount":"1119.25","attachment_id":"","from_date":"2024-09-04","created_by":1011,"created_at":"2024-09-04 13:19:48","description":"","invoice_num":" 24117000000529329531","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":"951.04","tax_amount":128.76,"excluding_tax":990.49,"verify_at":"2024-09-30 00:00:00","is_used":true,"updated_at":"2024-09-24 13:54:20","cancel_description":"","cover_invoice_id":"","red_invoice_id":"","new_invoice_id":"","need_new_invoice":false,"is_draft":false,"is_settle":true,"supplier_id":262,"is_contract_cancel":false,"contract":{"id":3519,"key":3519,"serial_no":" 300400509989","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":1653,"purchase_invoice_id":1876,"project_id":3637,"project":{"id":3637,"key":3637,"name":"netapp\u5b58\u50a8\u6269\u5bb9","client_id":89,"client":{"id":89,"key":89,"name":"\u5c71\u4e1c\u91d1\u8f6f\u79d1\u6280\u80a1\u4efd\u6709\u9650\u516c\u53f8(\u62db\u91d1\u77ff\u4e1a\u80a1\u4efd\u6709\u9650\u516c\u53f8)"}}}],"purchaseInvoiceReminders":[],"purchaseInvoiceProducts":[{"id":231,"purchase_invoice_id":1876,"title":"BY-W5552MM","description":"*\u8ba1\u7b97\u673a\u914d\u5957\u4ea7\u54c1*\u535a\u626c \u4e07\u5146\u591a\u6a21\u5149\u7ea4\u8df3\u7ebflc-lc 5\u7c73 OM3-300\u53cc \u82af\u5c3e\u7ea4 \u03a62.0\u963b\u71c3\u4f4e\u70df\u65e0\u5364LSZH\u6297\u5f2f\u66f2\u8df3\u7ea4\u5149\u7ea4\u7ebfBY-W55","number":"16","outbound":"16","inventory":"0","unit":"\u6761","amount":"951.05","tax_rate":"13","including_tax":"0","excluding_tax":"841.64","tax_amount":"109.41","into_inventory":true},{"id":230,"purchase_invoice_id":1876,"title":"BY-W1552M","description":"*\u8ba1\u7b97\u673a\u914d\u5957\u4ea7\u54c1*\u535a\u626c \u4e07\u5146\u591a\u6a21\u5149\u7ea4\u8df3\u7ebflc-lc 1\u7c73 OM3-300\u53cc \u82af\u5c3e\u7ea4 \u03a62.0\u963b\u71c3\u4f4e\u70df\u65e0\u5364\u5149\u6a21\u5757\u4e13\u7528\u8df3\u7ea4\u5149\u7ea4\u7ebfBY-W15","number":"5","outbound":"0","inventory":"5","unit":"\u6761","amount":"168.2","tax_rate":"13","including_tax":"0","excluding_tax":"148.85","tax_amount":"19.35","into_inventory":true}],"invoice_type_display":"\u6570\u7535\u4e13\u7968","including_tax":0,"number":21,"un_used_amount":168.21,"tax_rate":["13"]}},{"id":154,"purchase_invoice_id":1872,"purchase_product_id":154,"title":"","description":"*\u4fe1\u606f\u6280\u672f\u670d\u52a1*\u4e91\u670d\u52a1\u8d39","number":"1","unit":"\u6b21","outbound":"0","inventory":"1","amount":"62055.29","tax_rate":"6","including_tax":"0","excluding_tax":"58542.73","tax_amount":"3512.56","is_build":false,"build_group_id":"","created_at":"2024-09-03 09:13:59","purchaseInvoice":{"id":1872,"contract_id":3508,"amount":"62055.29","attachment_id":"","from_date":"2024-09-02","created_by":1011,"created_at":"2024-09-03 09:12:55","description":"","invoice_num":"24312000000267855141","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":"0","tax_amount":3512.56,"excluding_tax":58542.73,"verify_at":"2024-09-30 00:00:00","is_used":false,"updated_at":"2024-09-03 09:13:58","cancel_description":"","cover_invoice_id":"","red_invoice_id":"","new_invoice_id":"","need_new_invoice":false,"is_draft":false,"is_settle":true,"supplier_id":583,"is_contract_cancel":false,"contract":{"id":3508,"key":3508,"serial_no":"TS-ZHY-2024080501","supplier_id":583,"supplier":{"id":583,"key":583,"name":"\u4e0a\u6d77\u901f\u77f3\u4fe1\u606f\u79d1\u6280\u6709\u9650\u516c\u53f8"}},"supplier":{"id":583,"key":583,"name":"\u4e0a\u6d77\u901f\u77f3\u4fe1\u606f\u79d1\u6280\u6709\u9650\u516c\u53f8"},"purchaseInvoiceProjects":[{"id":1569,"purchase_invoice_id":1872,"project_id":3641,"project":{"id":3641,"key":3641,"name":"\u901f\u77f3\u9ad8\u6027\u80fd\u5e73\u53f0\u65b0\u8d2d","client_id":3281,"client":{"id":3281,"key":3281,"name":"\u5bd2\u5e8f\u79d1\u6280\uff08\u5317\u4eac\uff09\u6709\u9650\u516c\u53f8\uff08EDA\uff09"}}}],"purchaseInvoiceReminders":[],"purchaseInvoiceProducts":[{"id":154,"purchase_invoice_id":1872,"title":"","description":"*\u4fe1\u606f\u6280\u672f\u670d\u52a1*\u4e91\u670d\u52a1\u8d39","number":"1","outbound":"0","inventory":"1","unit":"\u6b21","amount":"62055.29","tax_rate":"6","including_tax":"0","excluding_tax":"58542.73","tax_amount":"3512.56","into_inventory":true}],"invoice_type_display":"\u6570\u7535\u4e13\u7968","including_tax":0,"number":1,"un_used_amount":62055.29,"tax_rate":["6"]}}],"can_create":true,"count":{"count":258,"amount":5179551.81,"number_count":"5124.6","outbound_count":"244.1","outbound_amount":1118179.17,"inventory_count":"4880.5","inventory_amount":4061372.64,"excluding_tax":"4604001.74","tax_amount":575550.07},"pagenation":{"totalcount":258,"thispage":6,"pagesize":20}},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}],"mod":0}', FALSE, '2025-08-19 16:37:32') RETURNING "id"

[+] Explain