ConfigurationRequestLogsProfilingDatabaseAsset BundlesMailTimeline
68a433ccc322d: POST https://beta.jinchangxiao.com/vue/tax/sales-invoice-list-simple-match at 2025-08-19 04:20:28 pm by 223.104.44.8

Performance Profiling

Total processing time: 46 ms; Peak memory: 4.780 MB. Show Profiling Timeline

总计17条数据
TimeDurationCategoryInfo
  
16:20:28.8197.0 msyii\db\Command::querySELECT pci.* FROM "a57be577deb434"."tbl_purchase_contract_invoices" "pci" LEFT JOIN "a57be577deb434"."tbl_purchase_contracts" "pc" ON pc.id = pci.contract_id LEFT JOIN "a57be577deb434"."tbl_purchase_invoice_products" "pcpp" ON pci.id = pcpp.purchase_invoice_id LEFT JOIN "a57be577deb434"."tbl_suppliers" "s" ON pci.supplier_id = s.id LEFT JOIN "a57be577deb434"."tbl_purchase_invoice_projects" "pip" ON pci.id = pip.purchase_invoice_id LEFT JOIN "a57be577deb434"."tbl_projects" "p" ON p.id = pip.project_id LEFT JOIN "a57be577deb434"."tbl_clients" "c" ON p.client_id = c.id LEFT JOIN "a57be577deb434"."tbl_inventory_products" "ip" ON pci.id = ip.purchase_invoice_id WHERE (pci.cover_invoice_id is null) AND ((ip.inventory > 0) OR (0=1)) GROUP BY "pci"."id" ORDER BY pci.from_date DESC nulls last, "pci"."created_at" DESC LIMIT 20
16:20:28.8126.8 msyii\db\Command::querySELECT COUNT(*) FROM (SELECT pci.* FROM "a57be577deb434"."tbl_purchase_contract_invoices" "pci" LEFT JOIN "a57be577deb434"."tbl_purchase_contracts" "pc" ON pc.id = pci.contract_id LEFT JOIN "a57be577deb434"."tbl_purchase_invoice_products" "pcpp" ON pci.id = pcpp.purchase_invoice_id LEFT JOIN "a57be577deb434"."tbl_suppliers" "s" ON pci.supplier_id = s.id LEFT JOIN "a57be577deb434"."tbl_purchase_invoice_projects" "pip" ON pci.id = pip.purchase_invoice_id LEFT JOIN "a57be577deb434"."tbl_projects" "p" ON p.id = pip.project_id LEFT JOIN "a57be577deb434"."tbl_clients" "c" ON p.client_id = c.id LEFT JOIN "a57be577deb434"."tbl_inventory_products" "ip" ON pci.id = ip.purchase_invoice_id WHERE (pci.cover_invoice_id is null) AND ((ip.inventory > 0) OR (0=1)) GROUP BY "pci"."id" ORDER BY pci.from_date DESC nulls last, "pci"."created_at" DESC) "c"
16:20:28.8353.5 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_visit_module_histories" WHERE ("user_id"=1001) AND ("object_type"=10004) AND ("visit_date"='2025-08-19')
16:20:28.8402.6 msyii\db\Command::queryINSERT INTO "global"."tbl_api_log" ("code", "schema", "user_id", "device_type", "url", "request", "response", "php_error", "time") VALUES (200, 'a57be577deb434', 1001, 5, 'vue/tax/sales-invoice-list-simple-match', '{"PurchaseContractInvoiceSearch":{"is_verify":""},"page":"1","id":"2116","web_access_token":"239qcuu_ToIhJtTt60gp-9_fllLTtTgq"}', '{"code":2000,"result":{"list":[{"id":2389,"contract_id":4078,"amount":"10800","attachment_id":"","from_date":"2025-08-04","created_by":1011,"created_at":"2025-08-04 17:00:16","description":"","invoice_num":"25112000000162694288","invoice_type":1,"handler":1011,"is_verify":false,"is_cancel":false,"paid_amount":"0","tax_amount":"1242.48","excluding_tax":"9557.52","verify_at":"","is_used":false,"updated_at":"2025-08-04 17:01:03","cancel_description":"","cover_invoice_id":"","red_invoice_id":"","new_invoice_id":"","need_new_invoice":false,"is_draft":false,"is_settle":false,"supplier_id":678,"is_contract_cancel":false,"contract":{"id":4078,"key":4078,"serial_no":"YTYG20250623","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":678,"key":678,"name":"\u5317\u4eac\u667a\u9886\u8d8b\u52bf\u79d1\u6280\u6709\u9650\u516c\u53f8"},"inventoryProducts":[{"id":1831,"purchase_invoice_id":2389,"purchase_product_id":1915,"title":"64G","description":"*\u8ba1\u7b97\u673a\u914d\u5957\u4ea7\u54c1*\u5185\u5b58","number":"4","unit":"\u6761","outbound":"0","inventory":"4","amount":"10800","tax_rate":"13","including_tax":"0","excluding_tax":"9557.52","tax_amount":"1242.48","is_build":false,"build_group_id":"","created_at":"2025-08-04 17:01:04","purchaseInvoice":{"id":2389,"key":2389,"name":"25112000000162694288"}}]},{"id":2388,"contract_id":4076,"amount":"1888000","attachment_id":"","from_date":"2025-08-04","created_by":1011,"created_at":"2025-08-04 16:59:54","description":"","invoice_num":"25112000000162647804","invoice_type":1,"handler":1011,"is_verify":false,"is_cancel":false,"paid_amount":"0","tax_amount":"217203.54","excluding_tax":"1670796.46","verify_at":"","is_used":false,"updated_at":"2025-08-04 17:04:52","cancel_description":"","cover_invoice_id":"","red_invoice_id":"","new_invoice_id":"","need_new_invoice":false,"is_draft":false,"is_settle":false,"supplier_id":676,"is_contract_cancel":false,"contract":{"id":4076,"key":4076,"serial_no":"ALX-Q20250731-0529 ","supplier_id":676,"supplier":{"id":676,"key":676,"name":"\u5317\u4eac\u5b89\u8054\u901a\u79d1\u6280\u6709\u9650\u516c\u53f8"}},"supplier":{"id":676,"key":676,"name":"\u5317\u4eac\u5b89\u8054\u901a\u79d1\u6280\u6709\u9650\u516c\u53f8"},"inventoryProducts":[{"id":1832,"purchase_invoice_id":2388,"purchase_product_id":1916,"title":"HGX 8*GPU","description":"*\u8ba1\u7b97\u673a\u914d\u5957\u4ea7\u54c1*\u663e\u5361\u6a21\u7ec4","number":"1","unit":"\u5957","outbound":"0","inventory":"1","amount":"1888000","tax_rate":"13","including_tax":"0","excluding_tax":"1670796.46","tax_amount":"217203.54","is_build":false,"build_group_id":"","created_at":"2025-08-04 17:04:52","purchaseInvoice":{"id":2388,"key":2388,"name":"25112000000162647804"}}]},{"id":2387,"contract_id":4052,"amount":"398.63","attachment_id":"","from_date":"2025-08-01","created_by":5360,"created_at":"2025-08-04 11:50:15","description":"","invoice_num":"25342000000131931366","invoice_type":2,"handler":5360,"is_verify":false,"is_cancel":false,"paid_amount":"0","tax_amount":"3.95","excluding_tax":"394.68","verify_at":"","is_used":false,"updated_at":"2025-08-04 11:52:07","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":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"},"inventoryProducts":[{"id":1830,"purchase_invoice_id":2387,"purchase_product_id":1914,"title":"16g","description":"*\u8ba1\u7b97\u673a\u914d\u5957\u4ea7\u54c1*\u5185\u5b58","number":"2","unit":"\u6761","outbound":"0","inventory":"2","amount":"398.63","tax_rate":"1","including_tax":"0","excluding_tax":"394.68","tax_amount":"3.95","is_build":false,"build_group_id":"","created_at":"2025-08-04 11:52:07","purchaseInvoice":{"id":2387,"key":2387,"name":"25342000000131931366"}}]},{"id":2386,"contract_id":4045,"amount":"197.75","attachment_id":"","from_date":"2025-08-01","created_by":5360,"created_at":"2025-08-04 11:49:56","description":"","invoice_num":"25342000000131894984","invoice_type":2,"handler":5360,"is_verify":false,"is_cancel":false,"paid_amount":"0","tax_amount":"1.96","excluding_tax":"195.79","verify_at":"","is_used":false,"updated_at":"2025-08-04 11:51:20","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":4045,"key":4045,"serial_no":"\u8ba2\u5355\u53f7: 4635961815999592710","supplier_id":608,"supplier":{"id":608,"key":608,"name":"\u6dd8\u5b9d\u7f51"}},"supplier":{"id":608,"key":608,"name":"\u6dd8\u5b9d\u7f51"},"inventoryProducts":[{"id":1829,"purchase_invoice_id":2386,"purchase_product_id":1913,"title":"16g","description":"*\u8ba1\u7b97\u673a\u914d\u5957\u4ea7\u54c1*\u5185\u5b58","number":"1","unit":"\u6761","outbound":"0","inventory":"1","amount":"197.75","tax_rate":"1","including_tax":"0","excluding_tax":"195.79","tax_amount":"1.96","is_build":false,"build_group_id":"","created_at":"2025-08-04 11:51:20","purchaseInvoice":{"id":2386,"key":2386,"name":"25342000000131894984"}}]},{"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":1011,"is_verify":true,"is_cancel":false,"paid_amount":"0","tax_amount":"103.54","excluding_tax":"796.46","verify_at":"2025-07-31 00:00:00","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,"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"},"inventoryProducts":[{"id":1816,"purchase_invoice_id":2375,"purchase_product_id":1895,"title":"","description":"*\u8ba1\u7b97\u673a\u7f51\u7edc\u8bbe\u5907*\u786c\u4ef6\u8bbe\u5907\u635f\u8017\u8d39","number":"3","unit":"\u6b21","outbound":"0","inventory":"3","amount":"900","tax_rate":"13","including_tax":"0","excluding_tax":"796.46","tax_amount":"103.54","is_build":false,"build_group_id":"","created_at":"2025-07-25 09:03:54","purchaseInvoice":{"id":2375,"key":2375,"name":"25952000000150599805"}}]},{"id":2333,"contract_id":3973,"amount":"77320","attachment_id":"","from_date":"2025-06-25","created_by":1011,"created_at":"2025-06-26 10:30:04","description":"","invoice_num":"25952000000127744660","invoice_type":1,"handler":1011,"is_verify":true,"is_cancel":false,"paid_amount":"59148.63","tax_amount":"8895.22","excluding_tax":"68424.78","verify_at":"2025-06-30 00:00:00","is_used":true,"updated_at":"2025-06-26 10:30:37","cancel_description":"","cover_invoice_id":"","red_invoice_id":"","new_invoice_id":"","need_new_invoice":false,"is_draft":false,"is_settle":true,"supplier_id":138,"is_contract_cancel":false,"contract":{"id":3973,"key":3973,"serial_no":"H202506120096","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"},"inventoryProducts":[{"id":1765,"purchase_invoice_id":2333,"purchase_product_id":1829,"title":"\u9002\u7528\u4e8eAF-1000-L2100","description":"*\u8f6f\u4ef6*\u6df1\u4fe1\u670d\u9632\u706b\u5899\u8f6f\u4ef6V8.0","number":"2","unit":"\u5957","outbound":"1","inventory":"1","amount":"36342.74","tax_rate":"13","including_tax":"0","excluding_tax":"32161.72","tax_amount":"4181.02","is_build":false,"build_group_id":"","created_at":"2025-06-26 10:30:37","purchaseInvoice":{"id":2333,"key":2333,"name":"25952000000127744660"}}]},{"id":2332,"contract_id":3973,"amount":"16980","attachment_id":"","from_date":"2025-06-25","created_by":1011,"created_at":"2025-06-26 10:29:51","description":"","invoice_num":"25952000000127734703","invoice_type":1,"handler":1011,"is_verify":true,"is_cancel":false,"paid_amount":"10091.2","tax_amount":"1953.44","excluding_tax":"15026.56","verify_at":"2025-06-30 00:00:00","is_used":true,"updated_at":"2025-06-26 10:30:46","cancel_description":"","cover_invoice_id":"","red_invoice_id":"","new_invoice_id":"","need_new_invoice":false,"is_draft":false,"is_settle":true,"supplier_id":138,"is_contract_cancel":false,"contract":{"id":3973,"key":3973,"serial_no":"H202506120096","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"},"inventoryProducts":[{"id":1769,"purchase_invoice_id":2332,"purchase_product_id":1833,"title":"aTrust-1000-LS1050M","description":"*\u8ba1\u7b97\u673a\u7f51\u7edc\u8bbe\u5907*\u6df1\u4fe1\u670dSDP\u5b89\u5168\u7f51\u5173","number":"1","unit":"\u53f0","outbound":"0.8","inventory":"0.2","amount":"4614","tax_rate":"13","including_tax":"0","excluding_tax":"4083.19","tax_amount":"530.81","is_build":false,"build_group_id":"","created_at":"2025-06-26 10:30:46","purchaseInvoice":{"id":2332,"key":2332,"name":"25952000000127734703"}},{"id":1768,"purchase_invoice_id":2332,"purchase_product_id":1832,"title":"AF-1000-L2100","description":"*\u8ba1\u7b97\u673a\u7f51\u7edc\u8bbe\u5907*\u6df1\u4fe1\u670d\u9632\u706b\u5899","number":"2","unit":"\u53f0","outbound":"0","inventory":"2","amount":"5966","tax_rate":"13","including_tax":"0","excluding_tax":"5279.65","tax_amount":"686.35","is_build":false,"build_group_id":"","created_at":"2025-06-26 10:30:46","purchaseInvoice":{"id":2332,"key":2332,"name":"25952000000127734703"}}]},{"id":2314,"contract_id":3975,"amount":"10000","attachment_id":"","from_date":"2025-06-16","created_by":1011,"created_at":"2025-06-19 17:27:19","description":"\u8b66\u52a1\u5b89\u5168\u6d4f\u89c8\u5668","invoice_num":"25112000000123503177","invoice_type":1,"handler":1011,"is_verify":true,"is_cancel":false,"paid_amount":"100","tax_amount":"1150.44","excluding_tax":"8849.56","verify_at":"2025-06-30 00:00:00","is_used":true,"updated_at":"2025-06-19 17:31:08","cancel_description":"","cover_invoice_id":"","red_invoice_id":"","new_invoice_id":"","need_new_invoice":false,"is_draft":false,"is_settle":true,"supplier_id":707,"is_contract_cancel":false,"contract":{"id":3975,"key":3975,"serial_no":"TSKJ20250612-HYF-001","supplier_id":707,"supplier":{"id":707,"key":707,"name":"\u5bcc\u901a\u4e5d\u5dde\uff08\u5317\u4eac\uff09\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8"}},"supplier":{"id":707,"key":707,"name":"\u5bcc\u901a\u4e5d\u5dde\uff08\u5317\u4eac\uff09\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8"},"inventoryProducts":[{"id":1745,"purchase_invoice_id":2314,"purchase_product_id":1809,"title":"SuloongBrowser","description":"*\u8f6f\u4ef6*\u5546\u5bc6\u6d4f\u89c8\u5668","number":"100","unit":"\u5957","outbound":"1","inventory":"99","amount":"10000","tax_rate":"13","including_tax":"0","excluding_tax":"8849.56","tax_amount":"1150.44","is_build":false,"build_group_id":"","created_at":"2025-06-19 17:31:08","purchaseInvoice":{"id":2314,"key":2314,"name":"25112000000123503177"}}]},{"id":2293,"contract_id":3932,"amount":"130","attachment_id":"","from_date":"2025-06-06","created_by":5360,"created_at":"2025-06-06 17:10:23","description":"","invoice_num":"25122000000038692431","invoice_type":2,"handler":5360,"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-06-06 17:12:38","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":3932,"key":3932,"serial_no":"\u8ba2\u5355\u53f7: 4358089730127592710","supplier_id":608,"supplier":{"id":608,"key":608,"name":"\u6dd8\u5b9d\u7f51"}},"supplier":{"id":608,"key":608,"name":"\u6dd8\u5b9d\u7f51"},"inventoryProducts":[{"id":1706,"purchase_invoice_id":2293,"purchase_product_id":1768,"title":"","description":"*\u8ba1\u7b97\u673a\u914d\u5957\u4ea7\u54c1*\u7535\u8111\u914d\u4ef6","number":"1","unit":"","outbound":"0","inventory":"1","amount":"130","tax_rate":"1","including_tax":"0","excluding_tax":"128.71","tax_amount":"1.29","is_build":false,"build_group_id":"","created_at":"2025-06-06 17:12:38","purchaseInvoice":{"id":2293,"key":2293,"name":"25122000000038692431"}}]},{"id":2276,"contract_id":"","amount":"90215","attachment_id":"","from_date":"2025-05-22","created_by":1011,"created_at":"2025-05-30 15:51:51","description":"","invoice_num":"25442000000295945447","invoice_type":1,"handler":1013,"is_verify":true,"is_cancel":false,"paid_amount":"1676.8","tax_amount":"10378.71","excluding_tax":"79836.29","verify_at":"2025-06-30 00:00:00","is_used":true,"updated_at":"2025-05-30 15:51:51","cancel_description":"","cover_invoice_id":"","red_invoice_id":"","new_invoice_id":"","need_new_invoice":false,"is_draft":false,"is_settle":true,"supplier_id":642,"is_contract_cancel":false,"contract":{},"supplier":{"id":642,"key":642,"name":"\u5e7f\u5dde\u5e02\u4f73\u65fa\u7f51\u7edc\u79d1\u6280\u6709\u9650\u516c\u53f8"},"inventoryProducts":[{"id":1686,"purchase_invoice_id":2276,"purchase_product_id":1738,"title":"SG116DM","description":"*\u8ba1\u7b97\u673a\u7f51\u7edc\u8bbe\u5907*MERCURY\u6c34\u661f_\u57fa\u672c\u578b\u4ea4\u6362\u673a","number":"1","unit":"\u53f0","outbound":"0","inventory":"1","amount":"165","tax_rate":"13","including_tax":"0","excluding_tax":"146.02","tax_amount":"18.98","is_build":false,"build_group_id":"","created_at":"2025-05-30 15:51:52","purchaseInvoice":{"id":2276,"key":2276,"name":"25442000000295945447"}},{"id":1684,"purchase_invoice_id":2276,"purchase_product_id":1736,"title":"SG105D","description":"*\u8ba1\u7b97\u673a\u7f51\u7edc\u8bbe\u5907*MERCURY\u6c34\u661f_\u57fa\u672c\u578b\u4ea4\u6362\u673a","number":"7","unit":"\u53f0","outbound":"0","inventory":"7","amount":"308","tax_rate":"13","including_tax":"0","excluding_tax":"272.57","tax_amount":"35.43","is_build":false,"build_group_id":"","created_at":"2025-05-30 15:51:52","purchaseInvoice":{"id":2276,"key":2276,"name":"25442000000295945447"}},{"id":1683,"purchase_invoice_id":2276,"purchase_product_id":1735,"title":"MIPC852W","description":"*\u516c\u5171\u5b89\u5168\u8bbe\u5907*MERCURY\u6c34\u661f_\u7f51\u7edc\u6444\u50cf\u673a","number":"2","unit":"\u53f0","outbound":"0","inventory":"2","amount":"328","tax_rate":"13","including_tax":"0","excluding_tax":"290.27","tax_amount":"37.73","is_build":false,"build_group_id":"","created_at":"2025-05-30 15:51:52","purchaseInvoice":{"id":2276,"key":2276,"name":"25442000000295945447"}},{"id":1682,"purchase_invoice_id":2276,"purchase_product_id":1734,"title":"S110D","description":"*\u8ba1\u7b97\u673a\u7f51\u7edc\u8bbe\u5907*MERCURY\u6c34\u661f_\u57fa\u672c\u578b\u4ea4\u6362\u673a","number":"6","unit":"\u53f0","outbound":"0","inventory":"6","amount":"450","tax_rate":"13","including_tax":"0","excluding_tax":"398.23","tax_amount":"51.77","is_build":false,"build_group_id":"","created_at":"2025-05-30 15:51:52","purchaseInvoice":{"id":2276,"key":2276,"name":"25442000000295945447"}},{"id":1681,"purchase_invoice_id":2276,"purchase_product_id":1733,"title":"SG108D","description":"*\u8ba1\u7b97\u673a\u7f51\u7edc\u8bbe\u5907*MERCURY\u6c34\u661f_\u57fa\u672c\u578b\u4ea4\u6362\u673a","number":"7","unit":"\u53f0","outbound":"0","inventory":"7","amount":"518","tax_rate":"13","including_tax":"0","excluding_tax":"458.41","tax_amount":"59.59","is_build":false,"build_group_id":"","created_at":"2025-05-30 15:51:52","purchaseInvoice":{"id":2276,"key":2276,"name":"25442000000295945447"}},{"id":1680,"purchase_invoice_id":2276,"purchase_product_id":1732,"title":"SL110D","description":"*\u8ba1\u7b97\u673a\u7f51\u7edc\u8bbe\u5907*MERCURY\u6c34\u661f_\u57fa\u672c\u578b\u4ea4\u6362\u673a","number":"7","unit":"\u53f0","outbound":"0","inventory":"7","amount":"644","tax_rate":"13","including_tax":"0","excluding_tax":"569.91","tax_amount":"74.09","is_build":false,"build_group_id":"","created_at":"2025-05-30 15:51:52","purchaseInvoice":{"id":2276,"key":2276,"name":"25442000000295945447"}},{"id":1679,"purchase_invoice_id":2276,"purchase_product_id":1731,"title":"MSG16CP","description":"*\u8ba1\u7b97\u673a\u7f51\u7edc\u8bbe\u5907*MERCURY\u6c34\u661f_POE\u4ea4\u6362\u673a","number":"1","unit":"\u53f0","outbound":"0","inventory":"1","amount":"284","tax_rate":"13","including_tax":"0","excluding_tax":"251.33","tax_amount":"32.67","is_build":false,"build_group_id":"","created_at":"2025-05-30 15:51:52","purchaseInvoice":{"id":2276,"key":2276,"name":"25442000000295945447"}},{"id":1678,"purchase_invoice_id":2276,"purchase_product_id":1730,"title":"SG124D","description":"*\u8ba1\u7b97\u673a\u7f51\u7edc\u8bbe\u5907*MERCURY\u6c34\u661f_\u57fa\u672c\u578b\u4ea4\u6362\u673a","number":"4","unit":"\u53f0","outbound":"0","inventory":"4","amount":"880","tax_rate":"13","including_tax":"0","excluding_tax":"778.76","tax_amount":"101.24","is_build":false,"build_group_id":"","created_at":"2025-05-30 15:51:52","purchaseInvoice":{"id":2276,"key":2276,"name":"25442000000295945447"}},{"id":1677,"purchase_invoice_id":2276,"purchase_product_id":1729,"title":"MSG18CP","description":"*\u8ba1\u7b97\u673a\u7f51\u7edc\u8bbe\u5907*MERCURY\u6c34\u661f_POE\u4ea4\u6362\u673a","number":"3","unit":"\u53f0","outbound":"0","inventory":"3","amount":"1212","tax_rate":"13","including_tax":"0","excluding_tax":"1072.57","tax_amount":"139.43","is_build":false,"build_group_id":"","created_at":"2025-05-30 15:51:52","purchaseInvoice":{"id":2276,"key":2276,"name":"25442000000295945447"}},{"id":1676,"purchase_invoice_id":2276,"purchase_product_id":1728,"title":"SG116D","description":"*\u8ba1\u7b97\u673a\u7f51\u7edc\u8bbe\u5907*MERCURY\u6c34\u661f_\u57fa\u672c\u578b\u4ea4\u6362\u673a","number":"7","unit":"\u53f0","outbound":"0","inventory":"7","amount":"1274","tax_rate":"13","including_tax":"0","excluding_tax":"1127.43","tax_amount":"146.57","is_build":false,"build_group_id":"","created_at":"2025-05-30 15:51:52","purchaseInvoice":{"id":2276,"key":2276,"name":"25442000000295945447"}},{"id":1675,"purchase_invoice_id":2276,"purchase_product_id":1727,"title":"S105C","description":"*\u8ba1\u7b97\u673a\u7f51\u7edc\u8bbe\u5907*MERCURY\u6c34\u661f_\u4ea4\u6362\u673a","number":"81","unit":"\u53f0","outbound":"0","inventory":"81","amount":"1296","tax_rate":"13","including_tax":"0","excluding_tax":"1146.9","tax_amount":"149.1","is_build":false,"build_group_id":"","created_at":"2025-05-30 15:51:52","purchaseInvoice":{"id":2276,"key":2276,"name":"25442000000295945447"}},{"id":1674,"purchase_invoice_id":2276,"purchase_product_id":1726,"title":"S108C","description":"*\u8ba1\u7b97\u673a\u7f51\u7edc\u8bbe\u5907*MERCURY\u6c34\u661f_\u4ea4\u6362\u673a","number":"60","unit":"\u53f0","outbound":"0","inventory":"60","amount":"1320","tax_rate":"13","including_tax":"0","excluding_tax":"1168.14","tax_amount":"151.86","is_build":false,"build_group_id":"","created_at":"2025-05-30 15:51:51","purchaseInvoice":{"id":2276,"key":2276,"name":"25442000000295945447"}},{"id":1673,"purchase_invoice_id":2276,"purchase_product_id":1725,"title":"SG105C","description":"*\u8ba1\u7b97\u673a\u7f51\u7edc\u8bbe\u5907*MERCURY\u6c34\u661f_\u57fa\u672c\u578b\u4ea4\u6362\u673a","number":"61","unit":"\u53f0","outbound":"11.4","inventory":"49.6","amount":"1647","tax_rate":"13","including_tax":"0","excluding_tax":"1457.52","tax_amount":"189.48","is_build":false,"build_group_id":"","created_at":"2025-05-30 15:51:51","purchaseInvoice":{"id":2276,"key":2276,"name":"25442000000295945447"}},{"id":1672,"purchase_invoice_id":2276,"purchase_product_id":1724,"title":"SG108C","description":"*\u8ba1\u7b97\u673a\u7f51\u7edc\u8bbe\u5907*MERCURY\u6c34\u661f_\u57fa\u672c\u578b\u4ea4\u6362\u673a","number":"81","unit":"\u53f0","outbound":"2.4","inventory":"78.6","amount":"4455","tax_rate":"13","including_tax":"0","excluding_tax":"3942.48","tax_amount":"512.52","is_build":false,"build_group_id":"","created_at":"2025-05-30 15:51:51","purchaseInvoice":{"id":2276,"key":2276,"name":"25442000000295945447"}},{"id":1671,"purchase_invoice_id":2276,"purchase_product_id":1723,"title":"TL-WDA6332RE","description":"*\u8ba1\u7b97\u673a\u7f51\u7edc\u8bbe\u5907*TP-LINK_\u65e0\u7ebf\u6269\u5c55\u5668","number":"10","unit":"\u53f0","outbound":"0","inventory":"10","amount":"1150","tax_rate":"13","including_tax":"0","excluding_tax":"1017.7","tax_amount":"132.3","is_build":false,"build_group_id":"","created_at":"2025-05-30 15:51:51","purchaseInvoice":{"id":2276,"key":2276,"name":"25442000000295945447"}},{"id":1670,"purchase_invoice_id":2276,"purchase_product_id":1722,"title":"TL-WA832RE","description":"*\u8ba1\u7b97\u673a\u7f51\u7edc\u8bbe\u5907*TP-LINK_\u65e0\u7ebf\u6269\u5c55\u5668","number":"20","unit":"\u53f0","outbound":"0","inventory":"20","amount":"1360","tax_rate":"13","including_tax":"0","excluding_tax":"1203.54","tax_amount":"156.46","is_build":false,"build_group_id":"","created_at":"2025-05-30 15:51:51","purchaseInvoice":{"id":2276,"key":2276,"name":"25442000000295945447"}},{"id":1669,"purchase_invoice_id":2276,"purchase_product_id":1721,"title":"TL-SG2005P","description":"*\u8ba1\u7b97\u673a\u7f51\u7edc\u8bbe\u5907*TP-LINK_\u7b80\u5355\u7f51\u7ba1\u4ea4\u6362\u673a","number":"1","unit":"\u53f0","outbound":"0","inventory":"1","amount":"216","tax_rate":"13","including_tax":"0","excluding_tax":"191.15","tax_amount":"24.85","is_build":false,"build_group_id":"","created_at":"2025-05-30 15:51:51","purchaseInvoice":{"id":2276,"key":2276,"name":"25442000000295945447"}},{"id":1668,"purchase_invoice_id":2276,"purchase_product_id":1720,"title":"TL-SG2005\u5de5\u4e1a\u7ea7","description":"*\u8ba1\u7b97\u673a\u7f51\u7edc\u8bbe\u5907*TP-LINK_\u7b80\u5355\u7f51\u7ba1\u4ea4\u6362\u673a","number":"1","unit":"\u53f0","outbound":"0","inventory":"1","amount":"227","tax_rate":"13","including_tax":"0","excluding_tax":"200.88","tax_amount":"26.12","is_build":false,"build_group_id":"","created_at":"2025-05-30 15:51:51","purchaseInvoice":{"id":2276,"key":2276,"name":"25442000000295945447"}},{"id":1667,"purchase_invoice_id":2276,"purchase_product_id":1719,"title":"TL-SG2048","description":"*\u8ba1\u7b97\u673a\u7f51\u7edc\u8bbe\u5907*TP-LINK_\u7b80\u5355\u7f51\u7ba1\u4ea4\u6362\u673a","number":"1","unit":"\u53f0","outbound":"0","inventory":"1","amount":"994","tax_rate":"13","including_tax":"0","excluding_tax":"879.65","tax_amount":"114.35","is_build":false,"build_group_id":"","created_at":"2025-05-30 15:51:51","purchaseInvoice":{"id":2276,"key":2276,"name":"25442000000295945447"}},{"id":1666,"purchase_invoice_id":2276,"purchase_product_id":1718,"title":"TL-SG2008D","description":"*\u8ba1\u7b97\u673a\u7f51\u7edc\u8bbe\u5907*TP-LINK_\u7b80\u5355\u7f51\u7ba1\u4ea4\u6362\u673a","number":"64","unit":"\u53f0","outbound":"0","inventory":"64","amount":"7360","tax_rate":"13","including_tax":"0","excluding_tax":"6513.27","tax_amount":"846.73","is_build":false,"build_group_id":"","created_at":"2025-05-30 15:51:51","purchaseInvoice":{"id":2276,"key":2276,"name":"25442000000295945447"}},{"id":1665,"purchase_invoice_id":2276,"purchase_product_id":1717,"title":"TL-SG2016K","description":"*\u8ba1\u7b97\u673a\u7f51\u7edc\u8bbe\u5907*TP-LINK_\u7b80\u5355\u7f51\u7ba1\u4ea4\u6362\u673a","number":"40","unit":"\u53f0","outbound":"0","inventory":"40","amount":"11520","tax_rate":"13","including_tax":"0","excluding_tax":"10194.69","tax_amount":"1325.31","is_build":false,"build_group_id":"","created_at":"2025-05-30 15:51:51","purchaseInvoice":{"id":2276,"key":2276,"name":"25442000000295945447"}},{"id":1664,"purchase_invoice_id":2276,"purchase_product_id":1716,"title":"TL-SG2016D","description":"*\u8ba1\u7b97\u673a\u7f51\u7edc\u8bbe\u5907*TP-LINK_\u7b80\u5355\u7f51\u7ba1\u4ea4\u6362\u673a","number":"16","unit":"\u53f0","outbound":"0","inventory":"16","amount":"4832","tax_rate":"13","including_tax":"0","excluding_tax":"4276.11","tax_amount":"555.89","is_build":false,"build_group_id":"","created_at":"2025-05-30 15:51:51","purchaseInvoice":{"id":2276,"key":2276,"name":"25442000000295945447"}},{"id":1663,"purchase_invoice_id":2276,"purchase_product_id":1715,"title":"TL-SG2024D","description":"*\u8ba1\u7b97\u673a\u7f51\u7edc\u8bbe\u5907*TP-LINK_\u7b80\u5355\u7f51\u7ba1\u4ea4\u6362\u673a","number":"1","unit":"\u53f0","outbound":"0","inventory":"1","amount":"343","tax_rate":"13","including_tax":"0","excluding_tax":"303.54","tax_amount":"39.46","is_build":false,"build_group_id":"","created_at":"2025-05-30 15:51:51","purchaseInvoice":{"id":2276,"key":2276,"name":"25442000000295945447"}},{"id":1662,"purchase_invoice_id":2276,"purchase_product_id":1714,"title":"TL-AP456C-PoE","description":"*\u8ba1\u7b97\u673a\u7f51\u7edc\u8bbe\u5907*TP-LINK_\u65e0\u7ebf\u63a5\u5165\u5668","number":"1","unit":"\u53f0","outbound":"0","inventory":"1","amount":"173","tax_rate":"13","including_tax":"0","excluding_tax":"153.1","tax_amount":"19.9","is_build":false,"build_group_id":"","created_at":"2025-05-30 15:51:51","purchaseInvoice":{"id":2276,"key":2276,"name":"25442000000295945447"}},{"id":1661,"purchase_invoice_id":2276,"purchase_product_id":1713,"title":"TL-AP302P","description":"*\u8ba1\u7b97\u673a\u7f51\u7edc\u8bbe\u5907*TP-LINK_\u65e0\u7ebf\u63a5\u5165\u5668","number":"2","unit":"\u53f0","outbound":"0","inventory":"2","amount":"410","tax_rate":"13","including_tax":"0","excluding_tax":"362.83","tax_amount":"47.17","is_build":false,"build_group_id":"","created_at":"2025-05-30 15:51:51","purchaseInvoice":{"id":2276,"key":2276,"name":"25442000000295945447"}},{"id":1660,"purchase_invoice_id":2276,"purchase_product_id":1712,"title":"TL-AP450I-PoE\u8584\u6b3e(\u65b9)","description":"*\u8ba1\u7b97\u673a\u7f51\u7edc\u8bbe\u5907*TP-LINK_\u65e0\u7ebf\u63a5\u5165\u5668","number":"14","unit":"\u53f0","outbound":"0","inventory":"14","amount":"1302","tax_rate":"13","including_tax":"0","excluding_tax":"1152.21","tax_amount":"149.79","is_build":false,"build_group_id":"","created_at":"2025-05-30 15:51:51","purchaseInvoice":{"id":2276,"key":2276,"name":"25442000000295945447"}},{"id":1659,"purchase_invoice_id":2276,"purchase_product_id":1711,"title":"TL-AP450I-PoE\u8584\u6b3e\u6df1\u7a7a\u94f6(\u65b9)","description":"*\u8ba1\u7b97\u673a\u7f51\u7edc\u8bbe\u5907*TP-LINK_\u65e0\u7ebf\u63a5\u5165\u5668","number":"14","unit":"\u53f0","outbound":"0","inventory":"14","amount":"1386","tax_rate":"13","including_tax":"0","excluding_tax":"1226.55","tax_amount":"159.45","is_build":false,"build_group_id":"","created_at":"2025-05-30 15:51:51","purchaseInvoice":{"id":2276,"key":2276,"name":"25442000000295945447"}},{"id":1658,"purchase_invoice_id":2276,"purchase_product_id":1710,"title":"TL-WDN6280","description":"*\u8ba1\u7b97\u673a\u7f51\u7edc\u8bbe\u5907*TP-LINK_\u9ad8\u901f\u65e0\u7ebf\u7f51\u5361","number":"1","unit":"\u53f0","outbound":"0","inventory":"1","amount":"101","tax_rate":"13","including_tax":"0","excluding_tax":"89.38","tax_amount":"11.62","is_build":false,"build_group_id":"","created_at":"2025-05-30 15:51:51","purchaseInvoice":{"id":2276,"key":2276,"name":"25442000000295945447"}},{"id":1657,"purchase_invoice_id":2276,"purchase_product_id":1709,"title":"TL-XDN6000\u514d\u9a71\u7248","description":"*\u8ba1\u7b97\u673a\u7f51\u7edc\u8bbe\u5907*TP-LINK_\u9ad8\u901f\u65e0\u7ebf\u7f51\u5361","number":"20","unit":"\u53f0","outbound":"0","inventory":"20","amount":"840","tax_rate":"13","including_tax":"0","excluding_tax":"743.36","tax_amount":"96.64","is_build":false,"build_group_id":"","created_at":"2025-05-30 15:51:51","purchaseInvoice":{"id":2276,"key":2276,"name":"25442000000295945447"}},{"id":1656,"purchase_invoice_id":2276,"purchase_product_id":1708,"title":"TL-R406","description":"*\u8ba1\u7b97\u673a\u7f51\u7edc\u8bbe\u5907*TP-LINK_\u9ad8\u6027\u80fd\u5bbd\u5e26\u8def\u7531\u5668","number":"1","unit":"\u53f0","outbound":"0","inventory":"1","amount":"68","tax_rate":"13","including_tax":"0","excluding_tax":"60.18","tax_amount":"7.82","is_build":false,"build_group_id":"","created_at":"2025-05-30 15:51:51","purchaseInvoice":{"id":2276,"key":2276,"name":"25442000000295945447"}},{"id":1655,"purchase_invoice_id":2276,"purchase_product_id":1707,"title":"TL-R860+","description":"*\u8ba1\u7b97\u673a\u7f51\u7edc\u8bbe\u5907*TP-LINK_\u9ad8\u6027\u80fd\u5bbd\u5e26\u8def\u7531\u5668","number":"8","unit":"\u53f0","outbound":"0","inventory":"8","amount":"1344","tax_rate":"13","including_tax":"0","excluding_tax":"1189.38","tax_amount":"154.62","is_build":false,"build_group_id":"","created_at":"2025-05-30 15:51:51","purchaseInvoice":{"id":2276,"key":2276,"name":"25442000000295945447"}},{"id":1654,"purchase_invoice_id":2276,"purchase_product_id":1706,"title":"TL-XAP1506GC-PoE\/DC\u6613\u5c55\u7248","description":"*\u8ba1\u7b97\u673a\u7f51\u7edc\u8bbe\u5907*TP-LINK_\u53cc\u9891\u65e0\u7ebf\u63a5\u5165\u5668","number":"1","unit":"\u53f0","outbound":"0.4","inventory":"0.6","amount":"230","tax_rate":"13","including_tax":"0","excluding_tax":"203.54","tax_amount":"26.46","is_build":false,"build_group_id":"","created_at":"2025-05-30 15:51:51","purchaseInvoice":{"id":2276,"key":2276,"name":"25442000000295945447"}},{"id":1653,"purchase_invoice_id":2276,"purchase_product_id":1705,"title":"TL-XAP3002GI-PoE\u8584\u6b3e\u9999\u69df\u91d1(\u65b9)\u6613\u5c55\u7248","description":"*\u8ba1\u7b97\u673a\u7f51\u7edc\u8bbe\u5907*TP-LINK_\u53cc\u9891\u65e0\u7ebf\u63a5\u5165\u5668","number":"1","unit":"\u53f0","outbound":"0","inventory":"1","amount":"247","tax_rate":"13","including_tax":"0","excluding_tax":"218.58","tax_amount":"28.42","is_build":false,"build_group_id":"","created_at":"2025-05-30 15:51:51","purchaseInvoice":{"id":2276,"key":2276,"name":"25442000000295945447"}},{"id":1652,"purchase_invoice_id":2276,"purchase_product_id":1704,"title":"TL-AP1202I-PoE\u8584\u6b3e\u9999\u69df\u91d1(\u65b9)","description":"*\u8ba1\u7b97\u673a\u7f51\u7edc\u8bbe\u5907*TP-LINK_\u53cc\u9891\u65e0\u7ebf\u63a5\u5165\u5668","number":"3","unit":"\u53f0","outbound":"0","inventory":"3","amount":"444","tax_rate":"13","including_tax":"0","excluding_tax":"392.92","tax_amount":"51.08","is_build":false,"build_group_id":"","created_at":"2025-05-30 15:51:51","purchaseInvoice":{"id":2276,"key":2276,"name":"25442000000295945447"}},{"id":1651,"purchase_invoice_id":2276,"purchase_product_id":1703,"title":"TL-7AP3602HI-PoE\u8584\u6b3e\u78b3\u7d20\u9ed1(\u65b9)\u6613\u5c55\u7248","description":"*\u8ba1\u7b97\u673a\u7f51\u7edc\u8bbe\u5907*TP-LINK_\u53cc\u9891\u65e0\u7ebf\u63a5\u5165\u5668","number":"3","unit":"\u53f0","outbound":"0","inventory":"3","amount":"1083","tax_rate":"13","including_tax":"0","excluding_tax":"958.41","tax_amount":"124.59","is_build":false,"build_group_id":"","created_at":"2025-05-30 15:51:51","purchaseInvoice":{"id":2276,"key":2276,"name":"25442000000295945447"}},{"id":1650,"purchase_invoice_id":2276,"purchase_product_id":1702,"title":"TL-AP1202I-PoE\u8584\u6b3e(\u65b9)","description":"*\u8ba1\u7b97\u673a\u7f51\u7edc\u8bbe\u5907*TP-LINK_\u53cc\u9891\u65e0\u7ebf\u63a5\u5165\u5668","number":"21","unit":"\u53f0","outbound":"0","inventory":"21","amount":"2919","tax_rate":"13","including_tax":"0","excluding_tax":"2583.19","tax_amount":"335.81","is_build":false,"build_group_id":"","created_at":"2025-05-30 15:51:51","purchaseInvoice":{"id":2276,"key":2276,"name":"25442000000295945447"}},{"id":1649,"purchase_invoice_id":2276,"purchase_product_id":1701,"title":"TL-SG3210","description":"*\u8ba1\u7b97\u673a\u7f51\u7edc\u8bbe\u5907*TP-LINK_\u4e8c\u5c42\u7f51\u7ba1\u4ea4\u6362\u673a","number":"1","unit":"\u53f0","outbound":"0","inventory":"1","amount":"366","tax_rate":"13","including_tax":"0","excluding_tax":"323.89","tax_amount":"42.11","is_build":false,"build_group_id":"","created_at":"2025-05-30 15:51:51","purchaseInvoice":{"id":2276,"key":2276,"name":"25442000000295945447"}},{"id":1648,"purchase_invoice_id":2276,"purchase_product_id":1700,"title":"TL-WDR7660\u5343\u5146\u6613\u5c55\u7248","description":"*\u8ba1\u7b97\u673a\u7f51\u7edc\u8bbe\u5907*TP-LINK_\u53cc\u9891\u65e0\u7ebf\u8def\u7531\u5668","number":"3","unit":"\u53f0","outbound":"0","inventory":"3","amount":"519","tax_rate":"13","including_tax":"0","excluding_tax":"459.29","tax_amount":"59.71","is_build":false,"build_group_id":"","created_at":"2025-05-30 15:51:51","purchaseInvoice":{"id":2276,"key":2276,"name":"25442000000295945447"}},{"id":1647,"purchase_invoice_id":2276,"purchase_product_id":1699,"title":"TL-7DR7260\u6613\u5c55\u7248","description":"*\u8ba1\u7b97\u673a\u7f51\u7edc\u8bbe\u5907*TP-LINK_\u53cc\u9891\u65e0\u7ebf\u8def\u7531\u5668","number":"1","unit":"\u53f0","outbound":"0","inventory":"1","amount":"567","tax_rate":"13","including_tax":"0","excluding_tax":"501.77","tax_amount":"65.23","is_build":false,"build_group_id":"","created_at":"2025-05-30 15:51:51","purchaseInvoice":{"id":2276,"key":2276,"name":"25442000000295945447"}},{"id":1646,"purchase_invoice_id":2276,"purchase_product_id":1698,"title":"TL-7DR5132\u6613\u5c55\u7248","description":"*\u8ba1\u7b97\u673a\u7f51\u7edc\u8bbe\u5907*TP-LINK_\u53cc\u9891\u65e0\u7ebf\u8def\u7531\u5668","number":"4","unit":"\u53f0","outbound":"0","inventory":"4","amount":"1196","tax_rate":"13","including_tax":"0","excluding_tax":"1058.41","tax_amount":"137.59","is_build":false,"build_group_id":"","created_at":"2025-05-30 15:51:51","purchaseInvoice":{"id":2276,"key":2276,"name":"25442000000295945447"}},{"id":1645,"purchase_invoice_id":2276,"purchase_product_id":1697,"title":"K75","description":"*\u8ba1\u7b97\u673a\u7f51\u7edc\u8bbe\u5907*TP-LINK_\u53cc\u9891\u65e0\u7ebf\u8def\u7531\u5668","number":"2","unit":"\u53f0","outbound":"0","inventory":"2","amount":"1410","tax_rate":"13","including_tax":"0","excluding_tax":"1247.79","tax_amount":"162.21","is_build":false,"build_group_id":"","created_at":"2025-05-30 15:51:51","purchaseInvoice":{"id":2276,"key":2276,"name":"25442000000295945447"}},{"id":1644,"purchase_invoice_id":2276,"purchase_product_id":1696,"title":"K76","description":"*\u8ba1\u7b97\u673a\u7f51\u7edc\u8bbe\u5907*TP-LINK_\u53cc\u9891\u65e0\u7ebf\u8def\u7531\u5668","number":"2","unit":"\u53f0","outbound":"0","inventory":"2","amount":"1570","tax_rate":"13","including_tax":"0","excluding_tax":"1389.38","tax_amount":"180.62","is_build":false,"build_group_id":"","created_at":"2025-05-30 15:51:51","purchaseInvoice":{"id":2276,"key":2276,"name":"25442000000295945447"}},{"id":1643,"purchase_invoice_id":2276,"purchase_product_id":1695,"title":"K30","description":"*\u8ba1\u7b97\u673a\u7f51\u7edc\u8bbe\u5907*TP-LINK_\u53cc\u9891\u65e0\u7ebf\u8def\u7531\u5668","number":"4","unit":"\u53f0","outbound":"0","inventory":"4","amount":"2228","tax_rate":"13","including_tax":"0","excluding_tax":"1971.68","tax_amount":"256.32","is_build":false,"build_group_id":"","created_at":"2025-05-30 15:51:51","purchaseInvoice":{"id":2276,"key":2276,"name":"25442000000295945447"}},{"id":1642,"purchase_invoice_id":2276,"purchase_product_id":1694,"title":"TL-7DR5150\u6613\u5c55\u7248","description":"*\u8ba1\u7b97\u673a\u7f51\u7edc\u8bbe\u5907*TP-LINK_\u53cc\u9891\u65e0\u7ebf\u8def\u7531\u5668","number":"10","unit":"\u53f0","outbound":"0","inventory":"10","amount":"2620","tax_rate":"13","including_tax":"0","excluding_tax":"2318.58","tax_amount":"301.42","is_build":false,"build_group_id":"","created_at":"2025-05-30 15:51:51","purchaseInvoice":{"id":2276,"key":2276,"name":"25442000000295945447"}},{"id":1641,"purchase_invoice_id":2276,"purchase_product_id":1693,"title":"TL-7DR3650\u6613\u5c55\u7248","description":"*\u8ba1\u7b97\u673a\u7f51\u7edc\u8bbe\u5907*TP-LINK_\u53cc\u9891\u65e0\u7ebf\u8def\u7531\u5668","number":"12","unit":"\u53f0","outbound":"0","inventory":"12","amount":"2820","tax_rate":"13","including_tax":"0","excluding_tax":"2495.58","tax_amount":"324.42","is_build":false,"build_group_id":"","created_at":"2025-05-30 15:51:51","purchaseInvoice":{"id":2276,"key":2276,"name":"25442000000295945447"}},{"id":1640,"purchase_invoice_id":2276,"purchase_product_id":1692,"title":"K72","description":"*\u8ba1\u7b97\u673a\u7f51\u7edc\u8bbe\u5907*TP-LINK_\u53cc\u9891\u65e0\u7ebf\u8def\u7531\u5668","number":"9","unit":"\u53f0","outbound":"0","inventory":"9","amount":"4230","tax_rate":"13","including_tax":"0","excluding_tax":"3743.36","tax_amount":"486.64","is_build":false,"build_group_id":"","created_at":"2025-05-30 15:51:51","purchaseInvoice":{"id":2276,"key":2276,"name":"25442000000295945447"}},{"id":1639,"purchase_invoice_id":2276,"purchase_product_id":1691,"title":"K73","description":"*\u8ba1\u7b97\u673a\u7f51\u7edc\u8bbe\u5907*TP-LINK_\u53cc\u9891\u65e0\u7ebf\u8def\u7531\u5668","number":"9","unit":"\u53f0","outbound":"0","inventory":"9","amount":"4707","tax_rate":"13","including_tax":"0","excluding_tax":"4165.49","tax_amount":"541.51","is_build":false,"build_group_id":"","created_at":"2025-05-30 15:51:51","purchaseInvoice":{"id":2276,"key":2276,"name":"25442000000295945447"}},{"id":1638,"purchase_invoice_id":2276,"purchase_product_id":1690,"title":"K20","description":"*\u8ba1\u7b97\u673a\u7f51\u7edc\u8bbe\u5907*TP-LINK_\u53cc\u9891\u65e0\u7ebf\u8def\u7531\u5668","number":"20","unit":"\u53f0","outbound":"0","inventory":"20","amount":"7440","tax_rate":"13","including_tax":"0","excluding_tax":"6584.07","tax_amount":"855.93","is_build":false,"build_group_id":"","created_at":"2025-05-30 15:51:51","purchaseInvoice":{"id":2276,"key":2276,"name":"25442000000295945447"}},{"id":1637,"purchase_invoice_id":2276,"purchase_product_id":1689,"title":"TL-FC324AB-3","description":"*\u8ba1\u7b97\u673a\u7f51\u7edc\u8bbe\u5907*TP-LINK_\u4e91\u7ba1\u7406\u5149\u7ea4\u6536\u53d1\u5668","number":"1","unit":"\u53f0","outbound":"0","inventory":"1","amount":"144","tax_rate":"13","including_tax":"0","excluding_tax":"127.43","tax_amount":"16.57","is_build":false,"build_group_id":"","created_at":"2025-05-30 15:51:51","purchaseInvoice":{"id":2276,"key":2276,"name":"25442000000295945447"}},{"id":1636,"purchase_invoice_id":2276,"purchase_product_id":1688,"title":"TL-SD32L","description":"*\u8ba1\u7b97\u673a\u5916\u90e8\u8bbe\u5907*\u5b89\u9632\u76d1\u63a7\u4e13\u7528SD\u5361","number":"12","unit":"\u4e2a","outbound":"0","inventory":"12","amount":"240","tax_rate":"13","including_tax":"0","excluding_tax":"212.39","tax_amount":"27.61","is_build":false,"build_group_id":"","created_at":"2025-05-30 15:51:51","purchaseInvoice":{"id":2276,"key":2276,"name":"25442000000295945447"}},{"id":1635,"purchase_invoice_id":2276,"purchase_product_id":1687,"title":"TL-SD64L","description":"*\u8ba1\u7b97\u673a\u5916\u90e8\u8bbe\u5907*\u5b89\u9632\u76d1\u63a7\u4e13\u7528SD\u5361","number":"10","unit":"\u4e2a","outbound":"0","inventory":"10","amount":"290","tax_rate":"13","including_tax":"0","excluding_tax":"256.64","tax_amount":"33.36","is_build":false,"build_group_id":"","created_at":"2025-05-30 15:51:51","purchaseInvoice":{"id":2276,"key":2276,"name":"25442000000295945447"}},{"id":1634,"purchase_invoice_id":2276,"purchase_product_id":1686,"title":"TL-SD128L","description":"*\u8ba1\u7b97\u673a\u5916\u90e8\u8bbe\u5907*\u5b89\u9632\u76d1\u63a7\u4e13\u7528SD\u5361","number":"5","unit":"\u4e2a","outbound":"0","inventory":"5","amount":"310","tax_rate":"13","including_tax":"0","excluding_tax":"274.34","tax_amount":"35.66","is_build":false,"build_group_id":"","created_at":"2025-05-30 15:51:51","purchaseInvoice":{"id":2276,"key":2276,"name":"25442000000295945447"}},{"id":1633,"purchase_invoice_id":2276,"purchase_product_id":1685,"title":"TL-SD256","description":"*\u8ba1\u7b97\u673a\u5916\u90e8\u8bbe\u5907*\u5b89\u9632\u76d1\u63a7\u4e13\u7528SD\u5361","number":"5","unit":"\u4e2a","outbound":"0","inventory":"5","amount":"620","tax_rate":"13","including_tax":"0","excluding_tax":"548.67","tax_amount":"71.33","is_build":false,"build_group_id":"","created_at":"2025-05-30 15:51:51","purchaseInvoice":{"id":2276,"key":2276,"name":"25442000000295945447"}},{"id":1632,"purchase_invoice_id":2276,"purchase_product_id":1684,"title":"TL-SG1005P","description":"*\u8ba1\u7b97\u673a\u7f51\u7edc\u8bbe\u5907*TP-LINK_POE\u4ea4\u6362\u673a","number":"1","unit":"\u53f0","outbound":"0","inventory":"1","amount":"209","tax_rate":"13","including_tax":"0","excluding_tax":"184.96","tax_amount":"24.04","is_build":false,"build_group_id":"","created_at":"2025-05-30 15:51:51","purchaseInvoice":{"id":2276,"key":2276,"name":"25442000000295945447"}},{"id":1631,"purchase_invoice_id":2276,"purchase_product_id":1683,"title":"TL-SF1005P-PoE","description":"*\u8ba1\u7b97\u673a\u7f51\u7edc\u8bbe\u5907*TP-LINK_POE\u4ea4\u6362\u673a","number":"6","unit":"\u53f0","outbound":"0","inventory":"6","amount":"462","tax_rate":"13","including_tax":"0","excluding_tax":"408.85","tax_amount":"53.15","is_build":false,"build_group_id":"","created_at":"2025-05-30 15:51:51","purchaseInvoice":{"id":2276,"key":2276,"name":"25442000000295945447"}},{"id":1630,"purchase_invoice_id":2276,"purchase_product_id":1682,"title":"TL-SF1005P","description":"*\u8ba1\u7b97\u673a\u7f51\u7edc\u8bbe\u5907*TP-LINK_POE\u4ea4\u6362\u673a","number":"7","unit":"\u53f0","outbound":"0","inventory":"7","amount":"938","tax_rate":"13","including_tax":"0","excluding_tax":"830.09","tax_amount":"107.91","is_build":false,"build_group_id":"","created_at":"2025-05-30 15:51:51","purchaseInvoice":{"id":2276,"key":2276,"name":"25442000000295945447"}},{"id":1629,"purchase_invoice_id":2276,"purchase_product_id":1681,"title":"TL-SL1218MP","description":"*\u8ba1\u7b97\u673a\u7f51\u7edc\u8bbe\u5907*TP-LINK_POE\u4ea4\u6362\u673a","number":"2","unit":"\u53f0","outbound":"0","inventory":"2","amount":"1030","tax_rate":"13","including_tax":"0","excluding_tax":"911.5","tax_amount":"118.5","is_build":false,"build_group_id":"","created_at":"2025-05-30 15:51:51","purchaseInvoice":{"id":2276,"key":2276,"name":"25442000000295945447"}},{"id":1628,"purchase_invoice_id":2276,"purchase_product_id":1680,"title":"TL-SF1006LP","description":"*\u8ba1\u7b97\u673a\u7f51\u7edc\u8bbe\u5907*TP-LINK_POE\u4ea4\u6362\u673a","number":"24","unit":"\u53f0","outbound":"0","inventory":"24","amount":"1824","tax_rate":"13","including_tax":"0","excluding_tax":"1614.16","tax_amount":"209.84","is_build":false,"build_group_id":"","created_at":"2025-05-30 15:51:51","purchaseInvoice":{"id":2276,"key":2276,"name":"25442000000295945447"}}]},{"id":2272,"contract_id":"","amount":"104986","attachment_id":"","from_date":"2025-05-22","created_by":1011,"created_at":"2025-05-30 15:23:07","description":"","invoice_num":"25442000000295880478","invoice_type":1,"handler":1013,"is_verify":true,"is_cancel":false,"paid_amount":"0","tax_amount":"12078.03","excluding_tax":"92907.97","verify_at":"2025-05-30 00:00:00","is_used":false,"updated_at":"2025-05-30 15:51:15","cancel_description":"","cover_invoice_id":"","red_invoice_id":"","new_invoice_id":"","need_new_invoice":false,"is_draft":false,"is_settle":true,"supplier_id":642,"is_contract_cancel":false,"contract":{},"supplier":{"id":642,"key":642,"name":"\u5e7f\u5dde\u5e02\u4f73\u65fa\u7f51\u7edc\u79d1\u6280\u6709\u9650\u516c\u53f8"},"inventoryProducts":[{"id":1567,"purchase_invoice_id":2272,"purchase_product_id":1619,"title":"TL-IPC689XD-A4","description":"*\u516c\u5171\u5b89\u5168\u8bbe\u5907*TP-LINK_\u7f51\u7edc\u6444\u50cf\u673a","number":"54","unit":"\u53f0","outbound":"0","inventory":"54","amount":"13068","tax_rate":"13","including_tax":"0","excluding_tax":"11564.6","tax_amount":"1503.4","is_build":false,"build_group_id":"","created_at":"2025-05-30 15:23:07","purchaseInvoice":{"id":2272,"key":2272,"name":"25442000000295880478"}},{"id":1566,"purchase_invoice_id":2272,"purchase_product_id":1618,"title":"TL-IPC45AW\u5168\u5f69","description":"*\u516c\u5171\u5b89\u5168\u8bbe\u5907*TP-LINK_\u7f51\u7edc\u6444\u50cf\u673a","number":"80","unit":"\u53f0","outbound":"0","inventory":"80","amount":"10720","tax_rate":"13","including_tax":"0","excluding_tax":"9486.73","tax_amount":"1233.27","is_build":false,"build_group_id":"","created_at":"2025-05-30 15:23:07","purchaseInvoice":{"id":2272,"key":2272,"name":"25442000000295880478"}},{"id":1565,"purchase_invoice_id":2272,"purchase_product_id":1617,"title":"TL-SG1005D","description":"*\u8ba1\u7b97\u673a\u7f51\u7edc\u8bbe\u5907*TP-LINK_\u57fa\u672c\u578b\u4ea4\u6362\u673a","number":"192","unit":"\u53f0","outbound":"0","inventory":"192","amount":"14208","tax_rate":"13","including_tax":"0","excluding_tax":"12573.45","tax_amount":"1634.55","is_build":false,"build_group_id":"","created_at":"2025-05-30 15:23:07","purchaseInvoice":{"id":2272,"key":2272,"name":"25442000000295880478"}},{"id":1564,"purchase_invoice_id":2272,"purchase_product_id":1616,"title":"TL-SG1008+","description":"*\u8ba1\u7b97\u673a\u7f51\u7edc\u8bbe\u5907*TP-LINK_\u57fa\u672c\u578b\u4ea4\u6362\u673a","number":"870","unit":"\u53f0","outbound":"0","inventory":"870","amount":"66990","tax_rate":"13","including_tax":"0","excluding_tax":"59283.19","tax_amount":"7706.81","is_build":false,"build_group_id":"","created_at":"2025-05-30 15:23:07","purchaseInvoice":{"id":2272,"key":2272,"name":"25442000000295880478"}}]},{"id":2233,"contract_id":3918,"amount":"2300","attachment_id":"","from_date":"2025-05-21","created_by":1011,"created_at":"2025-05-21 10:37:42","description":"","invoice_num":"25112000000102880265","invoice_type":1,"handler":1011,"is_verify":true,"is_cancel":false,"paid_amount":"300","tax_amount":"264.6","excluding_tax":"2035.4","verify_at":"2025-05-30 00:00:00","is_used":true,"updated_at":"2025-05-21 10:39:45","cancel_description":"","cover_invoice_id":"","red_invoice_id":"","new_invoice_id":"","need_new_invoice":false,"is_draft":false,"is_settle":true,"supplier_id":81,"is_contract_cancel":false,"contract":{"id":3918,"key":3918,"serial_no":"TSKJ20250519-HYF-001","supplier_id":81,"supplier":{"id":81,"key":81,"name":"\u5317\u4eac\u4ebf\u901a\u65b0\u6708\u79d1\u6280\u53d1\u5c55\u6709\u9650\u516c\u53f8\/\u4ebf\u901a\u9633\u5149"}},"supplier":{"id":81,"key":81,"name":"\u5317\u4eac\u4ebf\u901a\u65b0\u6708\u79d1\u6280\u53d1\u5c55\u6709\u9650\u516c\u53f8\/\u4ebf\u901a\u9633\u5149"},"inventoryProducts":[{"id":1546,"purchase_invoice_id":2233,"purchase_product_id":1573,"title":"750W","description":"*\u8ba1\u7b97\u673a\u914d\u5957\u4ea7\u54c1*\u7535\u6e90","number":"2","unit":"\u4e2a","outbound":"0","inventory":"2","amount":"600","tax_rate":"13","including_tax":"0","excluding_tax":"530.97","tax_amount":"69.03","is_build":false,"build_group_id":"","created_at":"2025-05-21 10:39:45","purchaseInvoice":{"id":2233,"key":2233,"name":"25112000000102880265"}},{"id":1544,"purchase_invoice_id":2233,"purchase_product_id":1571,"title":"960G","description":"*\u8ba1\u7b97\u673a\u5916\u90e8\u8bbe\u5907*\u786c\u76d8","number":"1","unit":"\u5757","outbound":"0","inventory":"1","amount":"1100","tax_rate":"13","including_tax":"0","excluding_tax":"973.45","tax_amount":"126.55","is_build":false,"build_group_id":"","created_at":"2025-05-21 10:39:45","purchaseInvoice":{"id":2233,"key":2233,"name":"25112000000102880265"}},{"id":1543,"purchase_invoice_id":2233,"purchase_product_id":1570,"title":"32G","description":"*\u8ba1\u7b97\u673a\u914d\u5957\u4ea7\u54c1*\u5185\u5b58","number":"1","unit":"\u6761","outbound":"0","inventory":"1","amount":"300","tax_rate":"13","including_tax":"0","excluding_tax":"265.49","tax_amount":"34.51","is_build":false,"build_group_id":"","created_at":"2025-05-21 10:39:45","purchaseInvoice":{"id":2233,"key":2233,"name":"25112000000102880265"}}]},{"id":2201,"contract_id":3706,"amount":"370500","attachment_id":"","from_date":"2025-04-02","created_by":1011,"created_at":"2025-04-02 17:16:43","description":"","invoice_num":"25122000000021320016","invoice_type":1,"handler":1011,"is_verify":true,"is_cancel":false,"paid_amount":"123500","tax_amount":"42623.9","excluding_tax":"327876.1","verify_at":"2025-04-30 00:00:00","is_used":true,"updated_at":"2025-04-02 17:18:05","cancel_description":"","cover_invoice_id":"","red_invoice_id":"","new_invoice_id":"","need_new_invoice":false,"is_draft":false,"is_settle":true,"supplier_id":516,"is_contract_cancel":false,"contract":{"id":3706,"key":3706,"serial_no":"TSKJ20241212-ZHY-001","supplier_id":516,"supplier":{"id":516,"key":516,"name":"\u5929\u6d25\u665f\u6e90\u79d1\u6280\u53d1\u5c55\u6709\u9650\u516c\u53f8"}},"supplier":{"id":516,"key":516,"name":"\u5929\u6d25\u665f\u6e90\u79d1\u6280\u53d1\u5c55\u6709\u9650\u516c\u53f8"},"inventoryProducts":[{"id":1507,"purchase_invoice_id":2201,"purchase_product_id":1526,"title":"SY-BL09","description":"*\u901a\u7528\u8bbe\u5907*\u4e0a\u6599\u89c6\u89c9\u8bc6\u522b\u6a21\u5757","number":"1.5","unit":"\u5957","outbound":"0.5","inventory":"1","amount":"17100","tax_rate":"13","including_tax":"0","excluding_tax":"15132.74","tax_amount":"1967.26","is_build":false,"build_group_id":"","created_at":"2025-04-02 17:18:05","purchaseInvoice":{"id":2201,"key":2201,"name":"25122000000021320016"}},{"id":1506,"purchase_invoice_id":2201,"purchase_product_id":1525,"title":"SY-BL08","description":"*\u901a\u7528\u8bbe\u5907*\u4e0d\u5408\u683c\u54c1\u6807\u8bb0\u673a\u6784","number":"1.5","unit":"\u5957","outbound":"0.5","inventory":"1","amount":"19950","tax_rate":"13","including_tax":"0","excluding_tax":"17654.87","tax_amount":"2295.13","is_build":false,"build_group_id":"","created_at":"2025-04-02 17:18:05","purchaseInvoice":{"id":2201,"key":2201,"name":"25122000000021320016"}},{"id":1505,"purchase_invoice_id":2201,"purchase_product_id":1524,"title":"SY-BL07","description":"*\u901a\u7528\u8bbe\u5907*\u8ba1\u6570\u7ffb\u8f6c\u673a\u6784","number":"1.5","unit":"\u5957","outbound":"0.5","inventory":"1","amount":"17100","tax_rate":"13","including_tax":"0","excluding_tax":"15132.74","tax_amount":"1967.26","is_build":false,"build_group_id":"","created_at":"2025-04-02 17:18:05","purchaseInvoice":{"id":2201,"key":2201,"name":"25122000000021320016"}},{"id":1504,"purchase_invoice_id":2201,"purchase_product_id":1523,"title":"SY-BL06","description":"*\u901a\u7528\u8bbe\u5907*\u516b\u8054\u5361\u5438\u9644\u5438\u76d8","number":"4.5","unit":"\u4ef6","outbound":"1.5","inventory":"3","amount":"21375","tax_rate":"13","including_tax":"0","excluding_tax":"18915.93","tax_amount":"2459.07","is_build":false,"build_group_id":"","created_at":"2025-04-02 17:18:05","purchaseInvoice":{"id":2201,"key":2201,"name":"25122000000021320016"}},{"id":1503,"purchase_invoice_id":2201,"purchase_product_id":1522,"title":"SY-BL05","description":"*\u901a\u7528\u8bbe\u5907*\u6574\u4f53\u5b89\u5168\u9632\u62a4\u62a4\u7f69","number":"0.3","unit":"\u4ef6","outbound":"0.1","inventory":"0.2","amount":"5700","tax_rate":"13","including_tax":"0","excluding_tax":"5044.25","tax_amount":"655.75","is_build":false,"build_group_id":"","created_at":"2025-04-02 17:18:05","purchaseInvoice":{"id":2201,"key":2201,"name":"25122000000021320016"}},{"id":1502,"purchase_invoice_id":2201,"purchase_product_id":1521,"title":"SY-BL04","description":"*\u901a\u7528\u8bbe\u5907*\u5b89\u88c5\u652f\u67b6","number":"1.5","unit":"\u4ef6","outbound":"0.5","inventory":"1","amount":"25650","tax_rate":"13","including_tax":"0","excluding_tax":"22699.12","tax_amount":"2950.88","is_build":false,"build_group_id":"","created_at":"2025-04-02 17:18:05","purchaseInvoice":{"id":2201,"key":2201,"name":"25122000000021320016"}},{"id":1501,"purchase_invoice_id":2201,"purchase_product_id":1520,"title":"SY-BL03","description":"*\u901a\u7528\u8bbe\u5907*\u7535\u52a8\u4e0b\u6599\u7bb1","number":"3","unit":"\u5957","outbound":"1","inventory":"2","amount":"19950","tax_rate":"13","including_tax":"0","excluding_tax":"17654.87","tax_amount":"2295.13","is_build":false,"build_group_id":"","created_at":"2025-04-02 17:18:05","purchaseInvoice":{"id":2201,"key":2201,"name":"25122000000021320016"}},{"id":1500,"purchase_invoice_id":2201,"purchase_product_id":1519,"title":"SY-BL02","description":"*\u901a\u7528\u8bbe\u5907*\u7535\u52a8\u4e0a\u6599\u7bb1","number":"3","unit":"\u5957","outbound":"1","inventory":"2","amount":"38475","tax_rate":"13","including_tax":"0","excluding_tax":"34048.67","tax_amount":"4426.33","is_build":false,"build_group_id":"","created_at":"2025-04-02 17:18:05","purchaseInvoice":{"id":2201,"key":2201,"name":"25122000000021320016"}},{"id":1499,"purchase_invoice_id":2201,"purchase_product_id":1518,"title":"SY-BL01","description":"*\u901a\u7528\u8bbe\u5907*\u4f20\u9001\u5e26","number":"0.3","unit":"\u4ef6","outbound":"0.1","inventory":"0.2","amount":"7125","tax_rate":"13","including_tax":"0","excluding_tax":"6305.31","tax_amount":"819.69","is_build":false,"build_group_id":"","created_at":"2025-04-02 17:18:05","purchaseInvoice":{"id":2201,"key":2201,"name":"25122000000021320016"}},{"id":1498,"purchase_invoice_id":2201,"purchase_product_id":1517,"title":"SY-BL14","description":"*\u901a\u7528\u8bbe\u5907*\u4e0d\u5408\u683c\u54c1\u89c6\u89c9\u8bc6\u522b\u6a21\u5757","number":"1.5","unit":"\u5957","outbound":"0.5","inventory":"1","amount":"9975","tax_rate":"13","including_tax":"0","excluding_tax":"8827.43","tax_amount":"1147.57","is_build":false,"build_group_id":"","created_at":"2025-04-02 17:18:05","purchaseInvoice":{"id":2201,"key":2201,"name":"25122000000021320016"}},{"id":1497,"purchase_invoice_id":2201,"purchase_product_id":1516,"title":"SY-BL13","description":"*\u901a\u7528\u8bbe\u5907*\u5361\u4f53\u521d\u59cb\u5316\u72b6\u6001\u89c6\u89c9\u8bc6\u522b\u6a21\u5757","number":"3","unit":"\u5957","outbound":"1","inventory":"2","amount":"8550","tax_rate":"13","including_tax":"0","excluding_tax":"7566.37","tax_amount":"983.63","is_build":false,"build_group_id":"","created_at":"2025-04-02 17:18:05","purchaseInvoice":{"id":2201,"key":2201,"name":"25122000000021320016"}},{"id":1496,"purchase_invoice_id":2201,"purchase_product_id":1515,"title":"SY-BL12","description":"*\u901a\u7528\u8bbe\u5907*\u673a\u5668\u624b\u6a21\u5757\u63a7\u5236\u7cfb\u7edf","number":"1.5","unit":"\u5957","outbound":"0.5","inventory":"1","amount":"39900","tax_rate":"13","including_tax":"0","excluding_tax":"35309.73","tax_amount":"4590.27","is_build":false,"build_group_id":"","created_at":"2025-04-02 17:18:05","purchaseInvoice":{"id":2201,"key":2201,"name":"25122000000021320016"}},{"id":1495,"purchase_invoice_id":2201,"purchase_product_id":1514,"title":"SY-BL11","description":"*\u901a\u7528\u8bbe\u5907*\u52a0\u957f\u673a\u5668\u624b\u6a21\u5757","number":"1.5","unit":"\u5957","outbound":"0.5","inventory":"1","amount":"39900","tax_rate":"13","including_tax":"0","excluding_tax":"35309.73","tax_amount":"4590.27","is_build":false,"build_group_id":"","created_at":"2025-04-02 17:18:05","purchaseInvoice":{"id":2201,"key":2201,"name":"25122000000021320016"}},{"id":1494,"purchase_invoice_id":2201,"purchase_product_id":1513,"title":"SY-BL10","description":"*\u901a\u7528\u8bbe\u5907*\u673a\u5668\u624b\u6a21\u5757","number":"3","unit":"\u5957","outbound":"1","inventory":"2","amount":"99750","tax_rate":"13","including_tax":"0","excluding_tax":"88274.34","tax_amount":"11475.66","is_build":false,"build_group_id":"","created_at":"2025-04-02 17:18:05","purchaseInvoice":{"id":2201,"key":2201,"name":"25122000000021320016"}}]},{"id":2183,"contract_id":3817,"amount":"31000","attachment_id":"","from_date":"2025-03-21","created_by":1011,"created_at":"2025-03-21 13:33:50","description":"","invoice_num":"25112000000056531134","invoice_type":1,"handler":1011,"is_verify":true,"is_cancel":false,"paid_amount":"0","tax_amount":"1754.72","excluding_tax":"29245.28","verify_at":"2025-04-30 00:00:00","is_used":false,"updated_at":"2025-03-21 13:34:36","cancel_description":"","cover_invoice_id":"","red_invoice_id":"","new_invoice_id":"","need_new_invoice":false,"is_draft":false,"is_settle":true,"supplier_id":534,"is_contract_cancel":false,"contract":{"id":3817,"key":3817,"serial_no":"2025022801-TSZHY5","supplier_id":534,"supplier":{"id":534,"key":534,"name":"\u5317\u4eac\u6e90\u70b9\u601d\u535a\u79d1\u6280\u6709\u9650\u516c\u53f8"}},"supplier":{"id":534,"key":534,"name":"\u5317\u4eac\u6e90\u70b9\u601d\u535a\u79d1\u6280\u6709\u9650\u516c\u53f8"},"inventoryProducts":[{"id":1352,"purchase_invoice_id":2183,"purchase_product_id":1359,"title":"","description":"*\u4fe1\u606f\u6280\u672f\u670d\u52a1*\u6280\u672f\u670d\u52a1\u8d39","number":"1","unit":"\u5957","outbound":"0","inventory":"1","amount":"31000","tax_rate":"6","including_tax":"0","excluding_tax":"29245.28","tax_amount":"1754.72","is_build":false,"build_group_id":"","created_at":"2025-03-21 13:34:36","purchaseInvoice":{"id":2183,"key":2183,"name":"25112000000056531134"}}]},{"id":2175,"contract_id":3821,"amount":"611866.7","attachment_id":"","from_date":"2025-03-17","created_by":1011,"created_at":"2025-03-18 09:10:56","description":"","invoice_num":"25112000000053225046","invoice_type":1,"handler":1011,"is_verify":true,"is_cancel":false,"paid_amount":"550680.03","tax_amount":"70391.75","excluding_tax":"541474.95","verify_at":"2025-03-31 00:00:00","is_used":true,"updated_at":"2025-03-18 09:15:28","cancel_description":"","cover_invoice_id":"","red_invoice_id":"","new_invoice_id":"","need_new_invoice":false,"is_draft":false,"is_settle":true,"supplier_id":685,"is_contract_cancel":false,"contract":{"id":3821,"key":3821,"serial_no":"TSKJ20250305-ZHY-001","supplier_id":685,"supplier":{"id":685,"key":685,"name":"\u5317\u4eac\u4e2d\u73af\u4e00\u94ed\u667a\u80fd\u79d1\u6280\u6709\u9650\u516c\u53f8"}},"supplier":{"id":685,"key":685,"name":"\u5317\u4eac\u4e2d\u73af\u4e00\u94ed\u667a\u80fd\u79d1\u6280\u6709\u9650\u516c\u53f8"},"inventoryProducts":[{"id":1348,"purchase_invoice_id":2175,"purchase_product_id":1351,"title":"UnaDPM3036","description":"*\u8ba1\u7b97\u673a\u5916\u90e8\u8bbe\u5907*\u58f9\u8fdb\u5236\u670d\u52a1\u5668","number":"1","unit":"\u5957","outbound":"0.9","inventory":"0.1","amount":"76286","tax_rate":"13","including_tax":"0","excluding_tax":"67509.73","tax_amount":"8776.27","is_build":false,"build_group_id":"","created_at":"2025-03-18 09:15:28","purchaseInvoice":{"id":2175,"key":2175,"name":"25112000000053225046"}},{"id":1347,"purchase_invoice_id":2175,"purchase_product_id":1350,"title":"","description":"*\u8f6f\u4ef6*\u9ed1\u65b9\u5bb9\u707e\u5907\u4efd\u4e0e\u6062\u590d\u7cfb\u7edf\u8f6f\u4ef6V6","number":"1","unit":"\u5957","outbound":"0.9","inventory":"0.1","amount":"535580.7","tax_rate":"13","including_tax":"0","excluding_tax":"473965.22","tax_amount":"61615.48","is_build":false,"build_group_id":"","created_at":"2025-03-18 09:15:28","purchaseInvoice":{"id":2175,"key":2175,"name":"25112000000053225046"}}]},{"id":2132,"contract_id":3721,"amount":"1550","attachment_id":"","from_date":"2025-02-13","created_by":5360,"created_at":"2025-02-14 10:33:14","description":"","invoice_num":"25112000000028139145","invoice_type":1,"handler":5360,"is_verify":true,"is_cancel":false,"paid_amount":"450","tax_amount":"178.32","excluding_tax":"1371.68","verify_at":"2025-02-28 00:00:00","is_used":true,"updated_at":"2025-02-14 10:45:14","cancel_description":"","cover_invoice_id":"","red_invoice_id":"","new_invoice_id":"","need_new_invoice":false,"is_draft":false,"is_settle":true,"supplier_id":59,"is_contract_cancel":false,"contract":{"id":3721,"key":3721,"serial_no":"TSKJ20250110-HYF-001","supplier_id":59,"supplier":{"id":59,"key":59,"name":"\u5317\u4eac\u592a\u8c37\u8baf\u8bda\u79d1\u6280\u53d1\u5c55\u6709\u9650\u516c\u53f8"}},"supplier":{"id":59,"key":59,"name":"\u5317\u4eac\u592a\u8c37\u8baf\u8bda\u79d1\u6280\u53d1\u5c55\u6709\u9650\u516c\u53f8"},"inventoryProducts":[{"id":1279,"purchase_invoice_id":2132,"purchase_product_id":1267,"title":"600G SAS 3.5","description":"*\u8ba1\u7b97\u673a\u5916\u90e8\u8bbe\u5907*\u786c\u76d8","number":"1","unit":"\u5757","outbound":"0","inventory":"1","amount":"350","tax_rate":"13","including_tax":"0","excluding_tax":"309.73","tax_amount":"40.27","is_build":false,"build_group_id":"","created_at":"2025-02-14 10:36:03","purchaseInvoice":{"id":2132,"key":2132,"name":"25112000000028139145"}},{"id":1278,"purchase_invoice_id":2132,"purchase_product_id":1266,"title":"1T","description":"*\u8ba1\u7b97\u673a\u5916\u90e8\u8bbe\u5907*\u786c\u76d8","number":"1","unit":"\u5757","outbound":"0","inventory":"1","amount":"450","tax_rate":"13","including_tax":"0","excluding_tax":"398.23","tax_amount":"51.77","is_build":false,"build_group_id":"","created_at":"2025-02-14 10:36:03","purchaseInvoice":{"id":2132,"key":2132,"name":"25112000000028139145"}},{"id":1277,"purchase_invoice_id":2132,"purchase_product_id":1265,"title":"300G","description":"*\u8ba1\u7b97\u673a\u5916\u90e8\u8bbe\u5907*\u786c\u76d8","number":"2","unit":"\u5757","outbound":"0","inventory":"2","amount":"300","tax_rate":"13","including_tax":"0","excluding_tax":"265.49","tax_amount":"34.51","is_build":false,"build_group_id":"","created_at":"2025-02-14 10:36:02","purchaseInvoice":{"id":2132,"key":2132,"name":"25112000000028139145"}}]},{"id":2106,"contract_id":3757,"amount":"15.59","attachment_id":"","from_date":"2025-01-14","created_by":1011,"created_at":"2025-01-15 09:09:28","description":"","invoice_num":"25117000000081017574","invoice_type":1,"handler":1011,"is_verify":true,"is_cancel":false,"paid_amount":"0","tax_amount":"1.79","excluding_tax":"13.8","verify_at":"2025-01-23 00:00:00","is_used":false,"updated_at":"2025-01-15 09:10: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":3757,"key":3757,"serial_no":"308798164676","supplier_id":262,"supplier":{"id":262,"key":262,"name":"\u4eac\u4e1c\u5546\u57ce"}},"supplier":{"id":262,"key":262,"name":"\u4eac\u4e1c\u5546\u57ce"},"inventoryProducts":[{"id":1241,"purchase_invoice_id":2106,"purchase_product_id":1221,"title":"MP-2100","description":"*\u7535\u7ebf\u7535\u7f06*\u80dc\u4e3a(shengwei)\u7535\u8111\u7406\u7ebf\u5668\u9b54\u672f\u8d34\u684c\u9762\u6570\u636e \u7ebf\u6536\u7eb3\u56fa\u5b9a\u6574\u7406\u514d\u6253\u5b54 \u7ed5\u7ebf\u5668\u7535\u7ebf\u7f51\u7ebf\u7535\u6e90\u7ebf\u624e\u5e26\u81ea\u7c98","number":"1","unit":"\u5377","outbound":"0","inventory":"1","amount":"15.59","tax_rate":"13","including_tax":"0","excluding_tax":"13.8","tax_amount":"1.79","is_build":false,"build_group_id":"","created_at":"2025-01-15 09:10:24","purchaseInvoice":{"id":2106,"key":2106,"name":"25117000000081017574"}}]},{"id":2094,"contract_id":3690,"amount":"20000","attachment_id":"","from_date":"2025-01-06","created_by":1011,"created_at":"2025-01-06 15:00:53","description":"","invoice_num":"25312000000005846236","invoice_type":1,"handler":1011,"is_verify":true,"is_cancel":false,"paid_amount":"0","tax_amount":"1132.08","excluding_tax":"18867.92","verify_at":"2025-03-31 00:00:00","is_used":false,"updated_at":"2025-01-06 15:02:49","cancel_description":"","cover_invoice_id":"","red_invoice_id":"","new_invoice_id":"","need_new_invoice":false,"is_draft":false,"is_settle":true,"supplier_id":67,"is_contract_cancel":false,"contract":{"id":3690,"key":3690,"serial_no":"XM20241205000219","supplier_id":67,"supplier":{"id":67,"key":67,"name":"\u4f73\u6770\u79d1\u6280(\u4e0a\u6d77)\u6709\u9650\u516c\u53f8"}},"supplier":{"id":67,"key":67,"name":"\u4f73\u6770\u79d1\u6280(\u4e0a\u6d77)\u6709\u9650\u516c\u53f8"},"inventoryProducts":[{"id":1227,"purchase_invoice_id":2094,"purchase_product_id":1207,"title":"7*24","description":"*\u4fe1\u606f\u6280\u672f\u670d\u52a1*\u6280\u672f\u652f\u6301\u670d\u52a1","number":"2","unit":"\u5e74","outbound":"0","inventory":"2","amount":"20000","tax_rate":"6","including_tax":"0","excluding_tax":"18867.92","tax_amount":"1132.08","is_build":false,"build_group_id":"","created_at":"2025-01-06 15:02:49","purchaseInvoice":{"id":2094,"key":2094,"name":"25312000000005846236"}}]},{"id":2067,"contract_id":3707,"amount":"292.91","attachment_id":"","from_date":"2024-12-16","created_by":1011,"created_at":"2024-12-17 09:25:11","description":"","invoice_num":"24952000000222261375","invoice_type":1,"handler":1011,"is_verify":true,"is_cancel":false,"paid_amount":"0","tax_amount":"33.7","excluding_tax":"259.21","verify_at":"2024-12-31 00:00:00","is_used":false,"updated_at":"2024-12-17 09:25:47","cancel_description":"","cover_invoice_id":"","red_invoice_id":"","new_invoice_id":"","need_new_invoice":false,"is_draft":false,"is_settle":true,"supplier_id":138,"is_contract_cancel":false,"contract":{"id":3707,"key":3707,"serial_no":"SXF-LX-20241212994","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"},"inventoryProducts":[{"id":866,"purchase_invoice_id":2067,"purchase_product_id":845,"title":"","description":"*\u8ba1\u7b97\u673a\u7f51\u7edc\u8bbe\u5907*\u4ef7\u5916\u8d39\u7528","number":"1","unit":"\u6279","outbound":"0","inventory":"1","amount":"292.91","tax_rate":"13","including_tax":"0","excluding_tax":"259.21","tax_amount":"33.7","is_build":false,"build_group_id":"","created_at":"2024-12-17 09:25:48","purchaseInvoice":{"id":2067,"key":2067,"name":"24952000000222261375"}}]},{"id":2050,"contract_id":3671,"amount":"1747","attachment_id":"","from_date":"2024-11-25","created_by":5360,"created_at":"2024-11-28 11:12:17","description":"","invoice_num":"24112000000190495528","invoice_type":1,"handler":5360,"is_verify":true,"is_cancel":false,"paid_amount":"713","tax_amount":"140.56","excluding_tax":"1606.44","verify_at":"2024-11-29 00:00:00","is_used":true,"updated_at":"2024-11-28 11:14:10","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":3671,"key":3671,"serial_no":"TSKJ20241120-ZHF-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"},"inventoryProducts":[{"id":851,"purchase_invoice_id":2050,"purchase_product_id":827,"title":"","description":"*\u4fe1\u606f\u6280\u672f\u670d\u52a1*\u670d\u52a1\u8d39","number":"1","unit":"\u5e74","outbound":"0","inventory":"1","amount":"1034","tax_rate":"6","including_tax":"0","excluding_tax":"975.47","tax_amount":"58.53","is_build":false,"build_group_id":"","created_at":"2024-11-28 11:14:11","purchaseInvoice":{"id":2050,"key":2050,"name":"24112000000190495528"}}]}],"checkList":[],"pagenation":{"totalcount":63,"thispage":1,"pagesize":20}},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}],"mod":0}', FALSE, '2025-08-19 16:20:28') RETURNING "id"
16:20:28.8022.3 msyii\db\Command::querySELECT * FROM "global"."vw_user_login" WHERE "id"=1001
16:20:28.8302.2 msyii\db\Command::querySELECT pci.* FROM "a57be577deb434"."tbl_purchase_contract_invoices" "pci" LEFT JOIN "a57be577deb434"."tbl_purchase_contracts" "pc" ON pc.id = pci.contract_id LEFT JOIN "a57be577deb434"."tbl_purchase_invoice_products" "pcpp" ON pci.id = pcpp.purchase_invoice_id LEFT JOIN "a57be577deb434"."tbl_suppliers" "s" ON pci.supplier_id = s.id LEFT JOIN "a57be577deb434"."tbl_purchase_invoice_projects" "pip" ON pci.id = pip.purchase_invoice_id LEFT JOIN "a57be577deb434"."tbl_projects" "p" ON p.id = pip.project_id LEFT JOIN "a57be577deb434"."tbl_clients" "c" ON p.client_id = c.id LEFT JOIN "a57be577deb434"."tbl_inventory_products" "ip" ON pci.id = ip.purchase_invoice_id WHERE (pci.cover_invoice_id is null) AND ((ip.inventory > 0) OR (0=1)) AND (0=1) GROUP BY "pci"."id" ORDER BY pci.from_date DESC nulls last, "pci"."created_at" DESC
16:20:28.8001.9 msyii\db\Connection::openOpening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta
16:20:28.8061.5 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
16:20:28.8281.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_inventory_products" WHERE "purchase_invoice_id" IN (2389, 2388, 2387, 2386, 2375, 2333, 2332, 2314, 2293, 2276, 2272, 2233, 2201, 2183, 2175, 2132, 2106, 2094, 2067, 2050) ORDER BY "id" DESC
16:20:28.8100.9 msyii\db\Command::querySELECT "ip"."purchase_invoice_id" FROM "a57be577deb434"."tbl_inventory_products" "ip" LEFT JOIN "a57be577deb434"."tbl_inventory_product_spents" "ips" ON ip.id = ips.inventory_product_id WHERE "ips"."sales_invoice_id"=2116 GROUP BY "ip"."purchase_invoice_id"
16:20:28.8380.8 msyii\db\Command::executeUPDATE "a57be577deb434"."tbl_visit_module_histories" SET "num"=63, "last_visit_at"='now()' WHERE "id"=55336
16:20:28.8110.6 msyii\db\Command::querySELECT "ip"."id", sum(ips.outbound) as used_number FROM "a57be577deb434"."tbl_inventory_products" "ip" LEFT JOIN "a57be577deb434"."tbl_inventory_product_spents" "ips" ON ip.id = ips.inventory_product_id WHERE "ips"."sales_invoice_id"=2116 GROUP BY "ip"."id"
16:20:28.8090.6 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_sales_contract_invoices" WHERE "id"='2116'
16:20:28.8270.4 msyii\db\Command::querySELECT "id", "id" AS "key", "serial_no", "supplier_id" FROM "a57be577deb434"."tbl_purchase_contracts" WHERE "id" IN (4078, 4076, 4052, 4045, 4051, 3973, 3975, 3932, 3918, 3706, 3817, 3821, 3721, 3757, 3690, 3707, 3671)
16:20:28.8270.3 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_suppliers" WHERE "id" IN (676, 608, 138, 236, 67, 516, 59, 262, 534, 685, 81, 707, 431)
16:20:28.8280.3 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_suppliers" WHERE "id" IN (678, 676, 608, 138, 707, 642, 81, 516, 534, 685, 59, 262, 67, 236)
16:20:28.8300.3 msyii\db\Command::querySELECT "id", "id" AS "key", "invoice_num" AS "name" FROM "a57be577deb434"."tbl_purchase_contract_invoices" WHERE "id" IN (2388, 2389, 2387, 2386, 2375, 2332, 2333, 2314, 2293, 2276, 2272, 2233, 2201, 2183, 2175, 2132, 2106, 2094, 2067, 2050)