Performance Profiling

Total processing time: 224 ms; Peak memory: 7.274 MB. Show Profiling Timeline

总计75条数据

Time	Duration	Category	Info

23:35:27.948	34.2 ms	yii\db\Command::query	SELECT "object_id", count(*) as comment FROM "a57be577deb434"."tbl_comments" WHERE ("object_type"=13) AND ("object_id" IN (4475, 4463, 4447, 4376, 4374, 4350, 4293, 4295, 4250, 4240)) GROUP BY "object_id"
23:35:28.024	22.3 ms	yii\db\Command::query	SELECT "object_id", count(*) AS unread FROM "a57be577deb434"."tbl_unread_comments" WHERE ("object_type"=13) AND (remind_user_id = 1001 AND is_read = false) AND ("object_id" IN (4475, 4463, 4447, 4376, 4374, 4350, 4293, 4295, 4250, 4240)) GROUP BY "object_id"
23:35:27.901	18.8 ms	yii\db\Command::query	select ct.conname as constraint_name, a.attname as column_name, fc.relname as foreign_table_name, fns.nspname as foreign_table_schema, fa.attname as foreign_column_name from (SELECT ct.conname, ct.conrelid, ct.confrelid, ct.conkey, ct.contype, ct.confkey, generate_subscripts(ct.conkey, 1) AS s FROM pg_constraint ct ) AS ct inner join pg_class c on c.oid=ct.conrelid inner join pg_namespace ns on c.relnamespace=ns.oid inner join pg_attribute a on a.attrelid=ct.conrelid and a.attnum = ct.conkey[ct.s] left join pg_class fc on fc.oid=ct.confrelid left join pg_namespace fns on fc.relnamespace=fns.oid left join pg_attribute fa on fa.attrelid=ct.confrelid and fa.attnum = ct.confkey[ct.s] where ct.contype='f' and c.relname='tbl_purchase_contracts' and ns.nspname='a57be577deb434' order by fns.nspname, fc.relname, a.attnum
23:35:27.894	7.2 ms	yii\db\Command::query	SELECT d.nspname AS table_schema, c.relname AS table_name, a.attname AS column_name, t.typname AS data_type, a.attlen AS character_maximum_length, pg_catalog.col_description(c.oid, a.attnum) AS column_comment, a.atttypmod AS modifier, a.attnotnull = false AS is_nullable, CAST(pg_get_expr(ad.adbin, ad.adrelid) AS varchar) AS column_default, coalesce(pg_get_expr(ad.adbin, ad.adrelid) ~ 'nextval',false) AS is_autoinc, array_to_string((select array_agg(enumlabel) from pg_enum where enumtypid=a.atttypid)::varchar[],',') as enum_values, CASE atttypid WHEN 21 /int2/ THEN 16 WHEN 23 /int4/ THEN 32 WHEN 20 /int8/ THEN 64 WHEN 1700 /numeric/ THEN CASE WHEN atttypmod = -1 THEN null ELSE ((atttypmod - 4) >> 16) & 65535 END WHEN 700 /float4/ THEN 24 /FLT_MANT_DIG/ WHEN 701 /float8/ THEN 53 /DBL_MANT_DIG/ ELSE null END AS numeric_precision, CASE WHEN atttypid IN (21, 23, 20) THEN 0 WHEN atttypid IN (1700) THEN CASE WHEN atttypmod = -1 THEN null ELSE (atttypmod - 4) & 65535 END ELSE null END AS numeric_scale, CAST( information_schema._pg_char_max_length(information_schema._pg_truetypid(a, t), information_schema._pg_truetypmod(a, t)) AS numeric ) AS size, a.attnum = any (ct.conkey) as is_pkey FROM pg_class c LEFT JOIN pg_attribute a ON a.attrelid = c.oid LEFT JOIN pg_attrdef ad ON a.attrelid = ad.adrelid AND a.attnum = ad.adnum LEFT JOIN pg_type t ON a.atttypid = t.oid LEFT JOIN pg_namespace d ON d.oid = c.relnamespace LEFT join pg_constraint ct on ct.conrelid=c.oid and ct.contype='p' WHERE a.attnum > 0 and t.typname != '' and c.relname = 'tbl_purchase_contracts' and d.nspname = 'a57be577deb434' ORDER BY a.attnum;
23:35:28.097	5.1 ms	yii\db\Command::query	INSERT INTO "global"."tbl_api_log" ("code", "schema", "user_id", "device_type", "version_code", "url", "request", "response", "php_error", "time", "duration") VALUES (200, 'a57be577deb434', 1001, 7, 179, 'v2/purchase-contract/list', '{"PurchaseContractSearch":{"keyword":"","contract_type":"","handler":"","sales_rep":"1001"},"page":"1","posttime":"1783870527","access_token":"lLLCHpZSQkMu0_ceemp9PVo8_3HEKkFC","device_type":"7","version_code":"179","token":"5af91af4f506e0e024956470b408ff6c"}', '{"code":200,"data":{"list":[{"id":4475,"supplier_id":431,"contract_type":4,"signed_at":"2026-05-20","amount":"888","handler":1011,"description":"","contract_scan":null,"created_by":5250,"created_at":"2026-05-20 17:19:24","updated_at":"2026-05-20 17:19:24","client_id":null,"project_id":null,"sales_rep":null,"serial_no":"\u7ecf\u624b\u4eba\u5173\u8054\u5ba2\u6237\u5546\u673a","payment_collection_remind_ahead":"","including_tax":true,"is_save_collection":false,"save_collection_at":"","is_chargeback":false,"cost_type":2,"is_draft":false,"is_verify":false,"is_refuse":false,"erp_settle_amount":"604","erp_un_settle_amount":"284","erp_payment_ticket_is_verify":false,"erp_collect_ticket_is_verify":null,"erp_cash_cost_ticket_is_verify":false,"erp_all_settle_amount":"604","total_contact_point":null,"paid_contact_point":null,"is_edit_verify":false,"is_chargeback_verify":false,"un_paid_contact_point":null,"client":null,"project":null,"supplier":{"id":431,"key":431,"name":"\u5317\u4eac\u60e0\u8054\u8baf\u901a\u4fe1\u606f\u6280\u672f\u670d\u52a1\u6709\u9650\u516c\u53f8","account_number":""},"contractScan":null,"createdBy":{"id":5250,"key":5250,"name":"\u8463\u8363","sex":"M","department_id":10,"avatar":{"id":157,"user_id":5250,"name":"\/files\/cdn\/a57be577deb434\/avatar\/10f9a0d9-7ea7-3910-9465-6ece76a0dae4.png"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"handlerPerson":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","avatar":{"id":17,"user_id":1011,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b54747f4-248d-380e-93bc-0f62f769e70d.png"}},"commentCount":{"object_id":4475,"comment":6},"purchaseClientRels":[{"id":4810,"contract_id":4475,"client_id":982,"project_id":4167,"client":{"id":982,"key":982,"name":"\u4e2d\u56fd\u4fe1\u606f\u5b89\u5168\u7814\u7a76\u6240","sales_rep":1001,"clickable":1},"project":{"id":4167,"key":4167,"name":"\u65b0\u5efa\u9879\u76ee","project_status":3,"budget":"51486","buildContract":{"id":4476,"from_project":4167,"serial_no":"2026-05-20-001"},"clickable":1}}],"purchaseContractPayments":[{"id":"362","key":"362","contract_id":4475,"amount":"1","value":"1","collected_date":"2026-05-27 17:21:52","created_at":"2026-05-27 17:21:52","created_by":1001,"description":"\u662f\u5426\u6536\u5230","createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4},"pct":0.11},{"id":"361","key":"361","contract_id":4475,"amount":"1","value":"1","collected_date":"2026-05-27 16:46:42","created_at":"2026-05-27 16:46:42","created_by":1001,"description":"111","createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4},"pct":0.11},{"id":"360","key":"360","contract_id":4475,"amount":"1","value":"1","collected_date":"2026-05-26 17:44:01","created_at":"2026-05-26 17:44:01","created_by":1001,"description":"43234","createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4},"pct":0.11},{"id":"359","key":"359","contract_id":4475,"amount":"1","value":"1","collected_date":"2026-05-26 17:40:41","created_at":"2026-05-26 17:40:41","created_by":1001,"description":"13234","createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4},"pct":0.11},{"id":"356","key":"356","contract_id":4475,"amount":"600","value":"600","collected_date":"2026-05-20 17:21:02","created_at":"2026-05-20 17:21:02","created_by":5250,"description":"400400400","createdBy":{"id":5250,"key":5250,"name":"\u8463\u8363","sex":"M","department_id":10},"pct":67.57}],"purchaseContractInvoices":[],"contractScans":[],"receiptScans":[],"purchaseContractPaymentCollectionRemindReceivers":[],"purchaseContractPaymentCollectionRemindDates":[],"paymentApproves":[],"costContractAmounts":[{"id":135641,"object_id":4475,"taxonomy_id":386,"term_id":18,"value":"","object_type":8,"extra_int":"385","in_amount":null,"out_amount":"888","key":386,"name":"\u8d44\u4ea7\u5904\u7f6e\u635f\u76ca","amount":"888","description":"","parent_id":"385","serial_no":"6115","taxonomy":{"id":386,"name":"\u8d44\u4ea7\u5904\u7f6e\u635f\u76ca","parent_id":385,"parent":{"id":385,"name":"\u8d22\u52a1\u79d1\u76ee","parent_id":null}}}],"unreadComments":null,"purchaseContractProductRels":[],"erpPurchaseOrder":null,"erpPurchaseCost":{"id":49,"serial_no":"FYDD-20260520-00002","from_date":null,"wrote_date":"2026-05-20","handler":1011,"supplier_id":431,"purchase_contract_id":4475,"erp_store_id":null,"status":2,"abstract":null,"description":"","verify_type":2,"next_verify_user":null,"next_stop_verify_user":null,"next_cancel_verify_user":null,"verify_at":"2026-05-20 17:19:24","stop_at":null,"cancel_at":null,"refuse_description":null,"is_resubmitted":false,"is_used":false,"is_done":false,"is_settle":false,"number":null,"amount":"888","settle_amount":null,"created_by":5250,"stop_description":null,"inventory_status":null,"is_cancel":false,"is_old":false,"created_at":"2026-05-20 17:19:24","updated_at":"2026-05-20 17:19:24","print_times":null,"erpPurchaseCostVerifyRels":[],"erpPurchaseCostStopVerifyRels":[]},"purchaseContractContactPoints":[],"invoiced":null,"approve_amount":0,"un_approve_amount":888,"un_invoiced":888,"payment_collection_remind_ahead_display":"\u65e0","contract_type_display":"\u8d39\u7528\u5408\u540c","collected":"604","un_collected":284,"collected_plan":0,"is_collected":false,"can_update":false,"can_update_cost":true,"can_update_file":true,"can_delete":true,"can_resubmit":false,"unread":0,"bgcolor":"#89c541","product_amount":0,"product_number":0,"is_done":false,"cost_done_display":false,"cost_un_done_display":false,"un_done_display":true,"contact_points_status_display":"\u672a\u8bbe\u7f6e","total_contact_paid_point":0,"total_contact_un_paid_point":0,"erp_all_un_settle_amount":284,"advance_purchase":false,"verifyList":[]},{"id":4463,"supplier_id":307,"contract_type":1,"signed_at":"2026-04-27","amount":"34545","handler":1011,"description":"","contract_scan":null,"created_by":1001,"created_at":"2026-04-27 10:34:08","updated_at":"2026-04-30 13:54:00","client_id":null,"project_id":null,"sales_rep":null,"serial_no":"\u53d1\u987a\u4e30","payment_collection_remind_ahead":"","including_tax":true,"is_save_collection":false,"save_collection_at":"","is_chargeback":false,"cost_type":1,"is_draft":false,"is_verify":false,"is_refuse":false,"erp_settle_amount":"0","erp_un_settle_amount":"34545","erp_payment_ticket_is_verify":false,"erp_collect_ticket_is_verify":null,"erp_cash_cost_ticket_is_verify":false,"erp_all_settle_amount":"200","total_contact_point":null,"paid_contact_point":null,"is_edit_verify":false,"is_chargeback_verify":true,"un_paid_contact_point":null,"client":null,"project":null,"supplier":{"id":307,"key":307,"name":"\u5317\u4eac\u4e5d\u5dde\u5b89\u548c\u673a\u7535\u8bbe\u5907\u5b89\u88c5\u5de5\u7a0b\u6709\u9650\u516c\u53f8","account_number":"115 0501 0300 0001 531"},"contractScan":null,"createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4,"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/\/avatar\/e868e40f-1256-329e-9b1c-74e095049622.png"},"department":{"id":4,"key":4,"name":"\u603b\u7ecf\u7406"}},"handlerPerson":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","avatar":{"id":17,"user_id":1011,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b54747f4-248d-380e-93bc-0f62f769e70d.png"}},"commentCount":{"object_id":4463,"comment":2},"purchaseClientRels":[{"id":4804,"contract_id":4463,"client_id":982,"project_id":4166,"client":{"id":982,"key":982,"name":"\u4e2d\u56fd\u4fe1\u606f\u5b89\u5168\u7814\u7a76\u6240","sales_rep":1001,"clickable":1},"project":{"id":4166,"key":4166,"name":"9999","project_status":3,"budget":"4000","buildContract":{"id":4467,"from_project":4166,"serial_no":"2026-05-12-001"},"clickable":1}}],"purchaseContractPayments":[],"purchaseContractInvoices":[],"contractScans":[],"receiptScans":[],"purchaseContractPaymentCollectionRemindReceivers":[],"purchaseContractPaymentCollectionRemindDates":[],"paymentApproves":[{"id":2777,"client_id":null,"project_id":null,"title":"\u6d4b\u8bd5","status":2,"next_verify_user":null,"verify_at":"2026-06-18 09:35:00","description":"\u6d4b\u8bd5","refuse_description":null,"is_resubmited":false,"created_by":1001,"created_at":"2026-06-18 09:34:57","updated_at":"2026-06-18 09:35:00","supplier_id":307,"purchase_contract_id":4463,"amount":"1","borrow_amount":null,"borrow_collect_day":null,"borrow_collect_status":1,"borrow_collect_description":null,"borrow_collect_at":null,"erp_payment_settle_amount":"0","erp_payment_un_settle_amount":"1","erp_borrow_settle_amount":"0","erp_borrow_un_settle_amount":"0","next_cancel_verify_user":null,"cancel_at":null,"cancel_description":null,"erp_payment_all_settle_amount":"1"}],"costContractAmounts":[],"unreadComments":null,"purchaseContractProductRels":[{"id":502,"purchase_contract_id":4463,"erp_store_id":null,"erp_purchase_order_product_id":433,"product_id":2261,"description":"","number":"1","amount":"34545","total_amount":"34545.00","erpStore":null,"product":{"id":2261,"name":"MK-MC300","product_type":4,"product_component":52,"product_brand":4,"product_serie":1769,"product_misc":null,"product_qa":null,"pn":"","description":"MK-MC300\u62fe\u97f3\u9ea6\u514b\u98ce\uff0c\u542b5\u7c73\u7ebf","created_by":1013,"created_at":"2026-03-16 10:07:43","updated_at":"2026-07-10 11:35:44","pinyin_shortcut":"MKMC300","product_unit":3,"is_renew":false,"in_out_at":"2026-07-10 11:35:44.60456+08","productType":{"id":4,"key":4,"name":"\u7f51\u7edc\u8bbe\u5907 "},"productComponent":{"id":52,"key":52,"name":"\u534f\u4f5c"},"productBrand":{"id":4,"key":4,"name":"\u8054\u60f3"},"productSerie":{"id":1769,"key":1769,"name":"\u5168\u5411\u9ea6\u514b\u98ce"},"productUnit":{"id":3,"key":3,"name":"\u4e2a"}},"erpPurchaseOrderProduct":{"id":433,"erp_purchase_order_id":2213,"erp_store_id":null,"product_id":2261,"description":"","number":"1","into_inventory":"1","amount":"34545","total_amount":"34545.00","last_number":null,"last_amount":null,"last_total_amount":null}}],"erpPurchaseOrder":{"id":2213,"serial_no":"CGDD-20260427-00001","from_date":null,"wrote_date":"2026-04-27","handler":1011,"supplier_id":307,"purchase_contract_id":4463,"erp_store_id":null,"status":7,"abstract":null,"description":"","verify_type":2,"next_verify_user":null,"next_stop_verify_user":null,"next_cancel_verify_user":1001,"verify_at":"2026-04-29 15:38:45","stop_at":null,"cancel_at":null,"refuse_description":null,"is_resubmitted":false,"is_used":true,"is_done":false,"is_settle":false,"number":"1","amount":"34545","created_by":1001,"stop_description":null,"inventory_status":true,"is_cancel":false,"is_old":false,"created_at":"2026-04-27 10:34:08","updated_at":"2026-04-30 13:54:00","print_times":null,"erpPurchaseOrderVerifyRels":[{"id":259,"erp_purchase_order_id":2213,"user_id":1001,"status":1,"description":"\u7a81\u7136\u4e00\u5929\u592a\u9633","verify_at":"2026-04-29 15:38:45","user":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/\/avatar\/e868e40f-1256-329e-9b1c-74e095049622.png"}}}],"erpPurchaseOrderStopVerifyRels":[],"erpPurchaseOrderCancelVerifyRels":[{"id":6,"erp_purchase_order_id":2213,"user_id":1001,"status":0,"description":null,"verify_at":"","user":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/\/avatar\/e868e40f-1256-329e-9b1c-74e095049622.png"}}}]},"erpPurchaseCost":null,"purchaseContractContactPoints":[],"invoiced":null,"approve_amount":1,"un_approve_amount":34544,"un_invoiced":34545,"payment_collection_remind_ahead_display":"\u65e0","contract_type_display":"\u4ea7\u54c1\u5408\u540c","collected":"0","un_collected":34545,"collected_plan":0,"is_collected":false,"can_update":false,"can_update_cost":false,"can_update_file":true,"can_delete":true,"can_resubmit":false,"unread":0,"bgcolor":"#89c541","product_amount":34545,"product_number":1,"is_done":false,"cost_done_display":false,"cost_un_done_display":false,"un_done_display":true,"contact_points_status_display":"\u672a\u8bbe\u7f6e","total_contact_paid_point":0,"total_contact_un_paid_point":0,"erp_all_un_settle_amount":34345,"advance_purchase":false,"verifyList":[{"id":6,"erp_purchase_order_id":2213,"user_id":1001,"status":0,"description":null,"verify_at":"","user":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/\/avatar\/e868e40f-1256-329e-9b1c-74e095049622.png"}}}]},{"id":4447,"supplier_id":46,"contract_type":1,"signed_at":"2026-03-24","amount":"278488.32","handler":1011,"description":"","contract_scan":null,"created_by":1011,"created_at":"2026-03-24 14:33:18","updated_at":"2026-06-26 14:39:51","client_id":null,"project_id":null,"sales_rep":null,"serial_no":"DZ202603233147774","payment_collection_remind_ahead":"1 day","including_tax":true,"is_save_collection":true,"save_collection_at":"2026-03-24 14:33:47","is_chargeback":false,"cost_type":1,"is_draft":false,"is_verify":false,"is_refuse":false,"erp_settle_amount":"0","erp_un_settle_amount":"278488.32","erp_payment_ticket_is_verify":true,"erp_collect_ticket_is_verify":null,"erp_cash_cost_ticket_is_verify":false,"erp_all_settle_amount":"278488.32","total_contact_point":"899","paid_contact_point":null,"is_edit_verify":false,"is_chargeback_verify":true,"un_paid_contact_point":null,"client":null,"project":null,"supplier":{"id":46,"key":46,"name":"\u795e\u5dde\u6570\u7801(\u4e2d\u56fd)\u6709\u9650\u516c\u53f8","account_number":""},"contractScan":null,"createdBy":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","department_id":3,"avatar":{"id":17,"user_id":1011,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b54747f4-248d-380e-93bc-0f62f769e70d.png"},"department":{"id":3,"key":3,"name":"\u5546\u52a1\u90e8"}},"handlerPerson":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","avatar":{"id":17,"user_id":1011,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b54747f4-248d-380e-93bc-0f62f769e70d.png"}},"commentCount":{"object_id":4447,"comment":3},"purchaseClientRels":[{"id":4801,"contract_id":4447,"client_id":3286,"project_id":4142,"client":{"id":3286,"key":3286,"name":"\u826f\u56fe\u79d1\u6280(\u4e0a\u6d77)\u6709\u9650\u516c\u53f8","sales_rep":1001,"clickable":1},"project":{"id":4142,"key":4142,"name":"PA1420 \u4e24\u53f0\u65b0\u8d2d\u9879\u76ee","project_status":3,"budget":"309425.78","buildContract":{"id":4446,"from_project":4142,"serial_no":"2026-03-24-001"},"clickable":1}}],"purchaseContractPayments":[],"purchaseContractInvoices":[{"id":2752,"key":2752,"contract_id":4447,"amount":"533","value":"533","attachment_id":null,"from_date":"2026-05-09","description":"","is_draft":false,"is_cancel":false,"purchaseInvoiceAmounts":[{"id":4904,"purchase_invoice_id":2752,"amount":"113","tax_rate":"6"},{"id":4905,"purchase_invoice_id":2752,"amount":"420","tax_rate":"5"}],"attachment":null,"attachmentRelationships":[{"id":57623,"object_type":21,"object_id":2752,"attachment_id":32668,"attachment":{"id":32668,"key":32668,"name":"986ec0a2-520f-36c9-9961-ef15da9d9eb8","extension":"png","path":"\/v2\/attachment\/view\/lLLCHpZSQkMu0_ceemp9PVo8_3HEKkFC\/986ec0a2-520f-36c9-9961-ef15da9d9eb8\/2a99ddb8496a1906cffaf35dd570cb92.png","orig_name":"2a99ddb8496a1906cffaf35dd570cb92.png"}}],"files":[]}],"contractScans":[{"id":57700,"object_type":108,"object_id":4447,"attachment_id":32534,"attachment":{"id":32534,"key":32534,"name":"b96454e0-e494-3ae7-9c72-c49eb0df963e","extension":"pdf","path":"\/v2\/attachment\/preview\/lLLCHpZSQkMu0_ceemp9PVo8_3HEKkFC\/b96454e0-e494-3ae7-9c72-c49eb0df963e\/DZ202603233147774.pdf","orig_name":"DZ202603233147774.pdf"}}],"receiptScans":[],"purchaseContractPaymentCollectionRemindReceivers":[{"id":1931,"user_id":1011,"key":1011,"contract_id":4447,"user":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","avatar":{"id":17,"user_id":1011,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b54747f4-248d-380e-93bc-0f62f769e70d.png"}}},{"id":1932,"user_id":5360,"key":5360,"contract_id":4447,"user":{"id":5360,"key":5360,"name":"\u5f20\u7ea2\u82b3","sex":"F","avatar":{"id":153,"user_id":5360,"name":"\/files\/cdn\/a57be577deb434\/avatar\/612c2410-e800-3507-aa05-3f1fbeb408a7.png"}}}],"purchaseContractPaymentCollectionRemindDates":[{"id":1125,"key":1125,"contract_id":4447,"name":"2026-06-30","value":"278488.32","overdue_days":null,"status":1,"remind_date":"2026-06-30","pct":100,"overdue_display":""}],"paymentApproves":[],"costContractAmounts":[],"unreadComments":null,"purchaseContractProductRels":[{"id":489,"purchase_contract_id":4447,"erp_store_id":null,"erp_purchase_order_product_id":422,"product_id":1584,"description":"","number":"2","amount":"21681.66","total_amount":"43363.32","erpStore":null,"product":{"id":1584,"name":"PAN-SVC-BKLN-1420","product_type":5,"product_component":35,"product_brand":8,"product_serie":1358,"product_misc":null,"product_qa":null,"pn":"","description":"PA-1420, Partner enabled premium support, 1 year (12 months) term.","created_by":1013,"created_at":"2024-04-26 09:33:52","updated_at":"2026-06-26 14:39:52","pinyin_shortcut":"PANSVCBKLN1420","product_unit":2,"is_renew":false,"in_out_at":"2026-06-26 14:39:52.094142+08","productType":{"id":5,"key":5,"name":"\u5b89\u5168\u8bbe\u5907"},"productComponent":{"id":35,"key":35,"name":"\u9632\u706b\u5899\u8f6f\u4ef6"},"productBrand":{"id":8,"key":8,"name":"PaloAlto"},"productSerie":{"id":1358,"key":1358,"name":"PA-1420\u4e00\u5e74\u670d\u52a1"},"productUnit":{"id":2,"key":2,"name":"\u5957"}},"erpPurchaseOrderProduct":{"id":422,"erp_purchase_order_id":2204,"erp_store_id":null,"product_id":1584,"description":"","number":"2","into_inventory":"2","amount":"21681.66","total_amount":"43363.32","last_number":null,"last_amount":null,"last_total_amount":null}},{"id":487,"purchase_contract_id":4447,"erp_store_id":null,"erp_purchase_order_product_id":420,"product_id":2262,"description":"","number":"6","amount":"9540.85","total_amount":"57245.10","erpStore":null,"product":{"id":2262,"name":"PAN-SFP-PLUS-SR","product_type":5,"product_component":157,"product_brand":8,"product_serie":1781,"product_misc":null,"product_qa":null,"pn":"","description":"SFP+ form factor, SR 10Gb optical transceiver, short reach 300m, OM3 MMF, duplex LC, IEEE 802.3ae 10GBASE-SR compliant","created_by":1013,"created_at":"2026-03-17 14:26:23","updated_at":"2026-06-26 14:39:52","pinyin_shortcut":"PANSFPPLUSSR","product_unit":3,"is_renew":false,"in_out_at":"2026-06-26 14:39:52.094142+08","productType":{"id":5,"key":5,"name":"\u5b89\u5168\u8bbe\u5907"},"productComponent":{"id":157,"key":157,"name":"\u9632\u706b\u5899\u914d\u4ef6"},"productBrand":{"id":8,"key":8,"name":"PaloAlto"},"productSerie":{"id":1781,"key":1781,"name":"\u6a21\u5757"},"productUnit":{"id":3,"key":3,"name":"\u4e2a"}},"erpPurchaseOrderProduct":{"id":420,"erp_purchase_order_id":2204,"erp_store_id":null,"product_id":2262,"description":"","number":"6","into_inventory":"3","amount":"9540.85","total_amount":"57245.10","last_number":null,"last_amount":null,"last_total_amount":null}},{"id":488,"purchase_contract_id":4447,"erp_store_id":null,"erp_purchase_order_product_id":421,"product_id":1562,"description":"","number":"2","amount":"9540.85","total_amount":"19081.70","erpStore":null,"product":{"id":1562,"name":"PAN-PWR-450W-AC","product_type":5,"product_component":36,"product_brand":8,"product_serie":1244,"product_misc":null,"product_qa":null,"pn":"","description":"PA-3400,PA-1400, ION 5200 and ION 9200 450W spare power supply","created_by":1013,"created_at":"2024-04-15 15:40:42","updated_at":"2026-06-26 17:28:49","pinyin_shortcut":"PANPWR450WAC","product_unit":2,"is_renew":false,"in_out_at":"2026-06-26 17:28:49.689912+08","productType":{"id":5,"key":5,"name":"\u5b89\u5168\u8bbe\u5907"},"productComponent":{"id":36,"key":36,"name":"PA\u8bb8\u53ef\u8bc1"},"productBrand":{"id":8,"key":8,"name":"PaloAlto"},"productSerie":{"id":1244,"key":1244,"name":"PA1420\u8f6f\u4ef6\u6388\u6743"},"productUnit":{"id":2,"key":2,"name":"\u5957"}},"erpPurchaseOrderProduct":{"id":421,"erp_purchase_order_id":2204,"erp_store_id":null,"product_id":1562,"description":"","number":"2","into_inventory":"2","amount":"9540.85","total_amount":"19081.70","last_number":null,"last_amount":null,"last_total_amount":null}},{"id":490,"purchase_contract_id":4447,"erp_store_id":null,"erp_purchase_order_product_id":423,"product_id":1558,"description":"","number":"2","amount":"79399.1","total_amount":"158798.20","erpStore":null,"product":{"id":1558,"name":"PAN-PA-1420","product_type":5,"product_component":26,"product_brand":8,"product_serie":1344,"product_misc":null,"product_qa":null,"pn":"","description":"Palo Alto Networks PA-1420","created_by":1013,"created_at":"2024-04-15 15:38:17","updated_at":"2026-07-04 23:56:28","pinyin_shortcut":"PANPA1420","product_unit":1,"is_renew":false,"in_out_at":"2026-07-04 23:56:28.995218+08","productType":{"id":5,"key":5,"name":"\u5b89\u5168\u8bbe\u5907"},"productComponent":{"id":26,"key":26,"name":"\u9632\u706b\u5899\u4e3b\u673a"},"productBrand":{"id":8,"key":8,"name":"PaloAlto"},"productSerie":{"id":1344,"key":1344,"name":"PA-1420\u9632\u706b\u5899\u4e3b\u673a"},"productUnit":{"id":1,"key":1,"name":"\u53f0"}},"erpPurchaseOrderProduct":{"id":423,"erp_purchase_order_id":2204,"erp_store_id":null,"product_id":1558,"description":"","number":"2","into_inventory":"2","amount":"79399.1","total_amount":"158798.20","last_number":null,"last_amount":null,"last_total_amount":null}}],"erpPurchaseOrder":{"id":2204,"serial_no":"CGDD-20260324-00001","from_date":null,"wrote_date":"2026-03-24","handler":1011,"supplier_id":46,"purchase_contract_id":4447,"erp_store_id":null,"status":2,"abstract":null,"description":"","verify_type":2,"next_verify_user":null,"next_stop_verify_user":null,"next_cancel_verify_user":null,"verify_at":"2026-03-24 14:46:39","stop_at":null,"cancel_at":null,"refuse_description":null,"is_resubmitted":false,"is_used":true,"is_done":false,"is_settle":false,"number":"12","amount":"278488.32","created_by":1011,"stop_description":null,"inventory_status":false,"is_cancel":false,"is_old":false,"created_at":"2026-03-24 14:33:18","updated_at":"2026-03-24 14:46:39","print_times":null,"erpPurchaseOrderVerifyRels":[{"id":249,"erp_purchase_order_id":2204,"user_id":1011,"status":1,"description":"","verify_at":"2026-03-24 14:33:58","user":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","avatar":{"id":17,"user_id":1011,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b54747f4-248d-380e-93bc-0f62f769e70d.png"}}},{"id":250,"erp_purchase_order_id":2204,"user_id":1001,"status":1,"description":"","verify_at":"2026-03-24 14:46:39","user":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/\/avatar\/e868e40f-1256-329e-9b1c-74e095049622.png"}}}],"erpPurchaseOrderStopVerifyRels":[],"erpPurchaseOrderCancelVerifyRels":[]},"erpPurchaseCost":null,"purchaseContractContactPoints":[{"id":2,"purchase_contract_id":4447,"contact_id":6253,"point":"899.00","paid_point":null,"contact":{"id":6253,"key":6253,"name":"\u5218\u82f1\u6960","client_id":3372,"supplier_id":null,"client":{"id":3372,"key":3372,"name":"\u6d77\u5357\u65f6\u4ee3\u5171\u8d62\u79c1\u52df\u57fa\u91d1\u7ba1\u7406\u5408\u4f19\u4f01\u4e1a\uff08\u6709\u9650\u5408\u4f19\uff09"},"supplier":null},"purchaseContractContactPointRels":[],"status_display":"\u672a\u6838\u9500"}],"invoiced":"533","approve_amount":0,"un_approve_amount":278488.32,"un_invoiced":277955.32,"payment_collection_remind_ahead_display":"\u63d0\u524d1\u5929","contract_type_display":"\u4ea7\u54c1\u5408\u540c","collected":"0","un_collected":278488.32,"collected_plan":278488.32,"is_collected":false,"can_update":true,"can_update_cost":false,"can_update_file":true,"can_delete":true,"can_resubmit":false,"unread":0,"bgcolor":"#89c541","product_amount":278488.32,"product_number":12,"is_done":false,"cost_done_display":false,"cost_un_done_display":false,"un_done_display":true,"contact_points_status_display":"\u672a\u6838\u9500","total_contact_paid_point":0,"total_contact_un_paid_point":899,"erp_all_un_settle_amount":0,"advance_purchase":false,"verifyList":[{"id":249,"erp_purchase_order_id":2204,"user_id":1011,"status":1,"description":"","verify_at":"2026-03-24 14:33:58","user":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","avatar":{"id":17,"user_id":1011,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b54747f4-248d-380e-93bc-0f62f769e70d.png"}}},{"id":250,"erp_purchase_order_id":2204,"user_id":1001,"status":1,"description":"","verify_at":"2026-03-24 14:46:39","user":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/\/avatar\/e868e40f-1256-329e-9b1c-74e095049622.png"}}}]},{"id":4376,"supplier_id":756,"contract_type":1,"signed_at":"2026-01-12","amount":"380","handler":1011,"description":"","contract_scan":null,"created_by":1011,"created_at":"2026-01-12 16:20:20","updated_at":"2026-01-12 16:24:10","client_id":null,"project_id":null,"sales_rep":null,"serial_no":"TSKJ20260112-HYF-001","payment_collection_remind_ahead":"","including_tax":true,"is_save_collection":true,"save_collection_at":"2026-01-12 16:24:10","is_chargeback":false,"cost_type":1,"is_draft":false,"is_verify":false,"is_refuse":false,"erp_settle_amount":"1","erp_un_settle_amount":"379","erp_payment_ticket_is_verify":false,"erp_collect_ticket_is_verify":null,"erp_cash_cost_ticket_is_verify":false,"erp_all_settle_amount":"2","total_contact_point":null,"paid_contact_point":null,"is_edit_verify":false,"is_chargeback_verify":false,"un_paid_contact_point":null,"client":null,"project":null,"supplier":{"id":756,"key":756,"name":"\u5317\u4eac\u667a\u5fb7\u5929\u8bda\u79d1\u6280\u6709\u9650\u516c\u53f8","account_number":""},"contractScan":null,"createdBy":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","department_id":3,"avatar":{"id":17,"user_id":1011,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b54747f4-248d-380e-93bc-0f62f769e70d.png"},"department":{"id":3,"key":3,"name":"\u5546\u52a1\u90e8"}},"handlerPerson":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","avatar":{"id":17,"user_id":1011,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b54747f4-248d-380e-93bc-0f62f769e70d.png"}},"commentCount":{"object_id":4376,"comment":6},"purchaseClientRels":[{"id":4648,"contract_id":4376,"client_id":2553,"project_id":4096,"client":{"id":2553,"key":2553,"name":"\u9752\u5c9b\u9890\u6770\u9e3f\u5229\u79d1\u6280\u6709\u9650\u516c\u53f8","sales_rep":1001,"clickable":1},"project":{"id":4096,"key":4096,"name":"\u6a21\u5757\u91c7\u8d2d","project_status":3,"budget":"1400","buildContract":{"id":4373,"from_project":4096,"serial_no":"2026-01-12-001"},"clickable":1}}],"purchaseContractPayments":[{"id":"12387","key":"12387","contract_id":4376,"amount":"1","value":"1","collected_date":"2026-05-12 00:00:00","created_at":"2026-05-12 13:05:02","created_by":1001,"description":"\u6d4b\u8bd5","createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4},"pct":0.26}],"purchaseContractInvoices":[],"contractScans":[],"receiptScans":[],"purchaseContractPaymentCollectionRemindReceivers":[{"id":1822,"user_id":1011,"key":1011,"contract_id":4376,"user":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","avatar":{"id":17,"user_id":1011,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b54747f4-248d-380e-93bc-0f62f769e70d.png"}}},{"id":1823,"user_id":5360,"key":5360,"contract_id":4376,"user":{"id":5360,"key":5360,"name":"\u5f20\u7ea2\u82b3","sex":"F","avatar":{"id":153,"user_id":5360,"name":"\/files\/cdn\/a57be577deb434\/avatar\/612c2410-e800-3507-aa05-3f1fbeb408a7.png"}}}],"purchaseContractPaymentCollectionRemindDates":[{"id":1066,"key":1066,"contract_id":4376,"name":"2026-02-12","value":"380","overdue_days":150,"status":0,"remind_date":"2026-02-12","pct":100,"overdue_display":"\u903e\u671f150\u5929"}],"paymentApproves":[{"id":2778,"client_id":null,"project_id":null,"title":"\u6d4b\u8bd5","status":2,"next_verify_user":null,"verify_at":"2026-06-18 09:36:56","description":"\u6d4b\u8bd5","refuse_description":null,"is_resubmited":false,"created_by":1001,"created_at":"2026-06-18 09:36:52","updated_at":"2026-06-18 09:36:56","supplier_id":756,"purchase_contract_id":4376,"amount":"1","borrow_amount":null,"borrow_collect_day":null,"borrow_collect_status":1,"borrow_collect_description":null,"borrow_collect_at":null,"erp_payment_settle_amount":"0","erp_payment_un_settle_amount":"1","erp_borrow_settle_amount":"0","erp_borrow_un_settle_amount":"0","next_cancel_verify_user":null,"cancel_at":null,"cancel_description":null,"erp_payment_all_settle_amount":"0"}],"costContractAmounts":[],"unreadComments":null,"purchaseContractProductRels":[{"id":400,"purchase_contract_id":4376,"erp_store_id":null,"erp_purchase_order_product_id":337,"product_id":984,"description":"","number":"2","amount":"190","total_amount":"380.00","erpStore":null,"product":{"id":984,"name":"PAN-SFP-LX\u7b2c\u4e09\u65b9\u6a21\u5757","product_type":4,"product_component":43,"product_brand":8,"product_serie":612,"product_misc":null,"product_qa":null,"pn":"","description":"SFP form factor, LX 1Gb optical transceiver, 10Km reach, SMF, duplex LC, IEEE 802.3ab 1000BASE-LX compliant","created_by":1013,"created_at":"2023-08-09 15:26:41","updated_at":"2026-01-12 16:41:06","pinyin_shortcut":"PANSFPLXdsfmk","product_unit":3,"is_renew":false,"in_out_at":"2026-01-12 16:41:06.766587+08","productType":{"id":4,"key":4,"name":"\u7f51\u7edc\u8bbe\u5907 "},"productComponent":{"id":43,"key":43,"name":"\u7f51\u7edc\u8bbe\u5907\u914d\u4ef6"},"productBrand":{"id":8,"key":8,"name":"PaloAlto"},"productSerie":{"id":612,"key":612,"name":"PAN-SFP-LX"},"productUnit":{"id":3,"key":3,"name":"\u4e2a"}},"erpPurchaseOrderProduct":{"id":337,"erp_purchase_order_id":2164,"erp_store_id":null,"product_id":984,"description":"","number":"2","into_inventory":"2","amount":"190","total_amount":"380.00","last_number":null,"last_amount":null,"last_total_amount":null}}],"erpPurchaseOrder":{"id":2164,"serial_no":"CGDD-20260112-00003","from_date":null,"wrote_date":null,"handler":1011,"supplier_id":756,"purchase_contract_id":4376,"erp_store_id":null,"status":2,"abstract":null,"description":"","verify_type":2,"next_verify_user":null,"next_stop_verify_user":null,"next_cancel_verify_user":null,"verify_at":"2026-01-12 16:24:16","stop_at":null,"cancel_at":null,"refuse_description":null,"is_resubmitted":false,"is_used":true,"is_done":false,"is_settle":false,"number":"2","amount":"380","created_by":1011,"stop_description":null,"inventory_status":true,"is_cancel":false,"is_old":false,"created_at":"2026-01-12 16:23:59","updated_at":"2026-01-12 16:24:16","print_times":null,"erpPurchaseOrderVerifyRels":[{"id":170,"erp_purchase_order_id":2164,"user_id":1011,"status":1,"description":"","verify_at":"2026-01-12 16:24:16","user":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","avatar":{"id":17,"user_id":1011,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b54747f4-248d-380e-93bc-0f62f769e70d.png"}}}],"erpPurchaseOrderStopVerifyRels":[],"erpPurchaseOrderCancelVerifyRels":[]},"erpPurchaseCost":null,"purchaseContractContactPoints":[],"invoiced":null,"approve_amount":1,"un_approve_amount":379,"un_invoiced":380,"payment_collection_remind_ahead_display":"\u65e0","contract_type_display":"\u4ea7\u54c1\u5408\u540c","collected":"1","un_collected":379,"collected_plan":380,"is_collected":false,"can_update":true,"can_update_cost":false,"can_update_file":true,"can_delete":true,"can_resubmit":false,"unread":0,"bgcolor":"#89c541","product_amount":380,"product_number":2,"is_done":false,"cost_done_display":false,"cost_un_done_display":false,"un_done_display":true,"contact_points_status_display":"\u672a\u8bbe\u7f6e","total_contact_paid_point":0,"total_contact_un_paid_point":0,"erp_all_un_settle_amount":378,"advance_purchase":false,"verifyList":[{"id":170,"erp_purchase_order_id":2164,"user_id":1011,"status":1,"description":"","verify_at":"2026-01-12 16:24:16","user":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","avatar":{"id":17,"user_id":1011,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b54747f4-248d-380e-93bc-0f62f769e70d.png"}}}]},{"id":4374,"supplier_id":163,"contract_type":1,"signed_at":"2025-12-30","amount":"1046515","handler":1011,"description":"","contract_scan":null,"created_by":1011,"created_at":"2026-01-12 10:40:41","updated_at":"2026-03-23 13:58:53","client_id":null,"project_id":null,"sales_rep":null,"serial_no":"2025WSCN-E-020-C1310-PAN","payment_collection_remind_ahead":"1 day","including_tax":true,"is_save_collection":true,"save_collection_at":"2026-03-23 13:58:53","is_chargeback":false,"cost_type":1,"is_draft":false,"is_verify":false,"is_refuse":false,"erp_settle_amount":"0","erp_un_settle_amount":"1046515","erp_payment_ticket_is_verify":false,"erp_collect_ticket_is_verify":null,"erp_cash_cost_ticket_is_verify":false,"erp_all_settle_amount":"0","total_contact_point":null,"paid_contact_point":null,"is_edit_verify":false,"is_chargeback_verify":false,"un_paid_contact_point":null,"client":null,"project":null,"supplier":{"id":163,"key":163,"name":"\u536b\u5b9e\u5eb7\u79d1\u8d38(\u4e0a\u6d77)\u6709\u9650\u516c\u53f8","account_number":""},"contractScan":null,"createdBy":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","department_id":3,"avatar":{"id":17,"user_id":1011,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b54747f4-248d-380e-93bc-0f62f769e70d.png"},"department":{"id":3,"key":3,"name":"\u5546\u52a1\u90e8"}},"handlerPerson":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","avatar":{"id":17,"user_id":1011,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b54747f4-248d-380e-93bc-0f62f769e70d.png"}},"commentCount":{"object_id":4374,"comment":1},"purchaseClientRels":[{"id":4812,"contract_id":4374,"client_id":3377,"project_id":4098,"client":{"id":3377,"key":3377,"name":"\u5317\u4eac\u5a01\u53d1\u65b0\u4e16\u7eaa\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8(\u8fc7\u5355)","sales_rep":1001,"clickable":1},"project":{"id":4098,"key":4098,"name":"PA460\u8bbe\u5907\u7b49\u91c7\u8d2d\u9879\u76ee","project_status":3,"budget":"1630000","buildContract":{"id":4399,"from_project":4098,"serial_no":"2026\/BJ040\/BJBJ2026-1028"},"clickable":1}}],"purchaseContractPayments":[],"purchaseContractInvoices":[{"id":2672,"key":2672,"contract_id":4374,"amount":"1046515","value":"1046515","attachment_id":null,"from_date":"2026-01-29","description":"","is_draft":false,"is_cancel":false,"purchaseInvoiceAmounts":[{"id":4977,"purchase_invoice_id":2672,"amount":"1046515","tax_rate":"13"}],"attachment":null,"attachmentRelationships":[],"files":[{"id":56066,"object_type":103,"object_id":2672,"attachment_id":31666,"attachment":{"id":31666,"key":31666,"name":"7dbaaace-ef95-38df-b945-0f03bc47b8b0","extension":"pdf","path":"\/v2\/attachment\/view\/lLLCHpZSQkMu0_ceemp9PVo8_3HEKkFC\/7dbaaace-ef95-38df-b945-0f03bc47b8b0\/10761446_20260129_26312000000577887616_\u5317\u4eac\u62d3\u5b9e\u79d1\u6280\u6709\u9650\u516c\u53f8_(1046515.00).pdf","orig_name":"10761446_20260129_26312000000577887616_\u5317\u4eac\u62d3\u5b9e\u79d1\u6280\u6709\u9650\u516c\u53f8_(1046515.00).pdf"}}]}],"contractScans":[{"id":55248,"object_type":108,"object_id":4374,"attachment_id":31325,"attachment":{"id":31325,"key":31325,"name":"720782cb-a1ae-3e93-8b5a-54a96e186890","extension":"pdf","path":"\/v2\/attachment\/preview\/lLLCHpZSQkMu0_ceemp9PVo8_3HEKkFC\/720782cb-a1ae-3e93-8b5a-54a96e186890\/2026_01_12_09_36_05.pdf","orig_name":"2026_01_12_09_36_05.pdf"}}],"receiptScans":[{"id":56381,"object_type":111,"object_id":4374,"attachment_id":31870,"attachment":{"id":31870,"key":31870,"name":"e8792f1f-e872-3245-ae4a-c2ba7cec1191","extension":"pdf","path":"\/v2\/attachment\/preview\/lLLCHpZSQkMu0_ceemp9PVo8_3HEKkFC\/e8792f1f-e872-3245-ae4a-c2ba7cec1191\/\u7b7e\u6536\u5355.pdf","orig_name":"\u7b7e\u6536\u5355.pdf"}}],"purchaseContractPaymentCollectionRemindReceivers":[{"id":1929,"user_id":1011,"key":1011,"contract_id":4374,"user":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","avatar":{"id":17,"user_id":1011,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b54747f4-248d-380e-93bc-0f62f769e70d.png"}}},{"id":1930,"user_id":5360,"key":5360,"contract_id":4374,"user":{"id":5360,"key":5360,"name":"\u5f20\u7ea2\u82b3","sex":"F","avatar":{"id":153,"user_id":5360,"name":"\/files\/cdn\/a57be577deb434\/avatar\/612c2410-e800-3507-aa05-3f1fbeb408a7.png"}}}],"purchaseContractPaymentCollectionRemindDates":[{"id":1123,"key":1123,"contract_id":4374,"name":"2026-03-27","value":"371865.99","overdue_days":107,"status":0,"remind_date":"2026-03-27","pct":35.53,"overdue_display":"\u903e\u671f107\u5929"},{"id":1124,"key":1124,"contract_id":4374,"name":"2026-03-29","value":"674649.01","overdue_days":105,"status":0,"remind_date":"2026-03-29","pct":64.47,"overdue_display":"\u903e\u671f105\u5929"}],"paymentApproves":[],"costContractAmounts":[],"unreadComments":null,"purchaseContractProductRels":[{"id":401,"purchase_contract_id":4374,"erp_store_id":null,"erp_purchase_order_product_id":338,"product_id":1562,"description":"","number":"2","amount":"9673","total_amount":"19346.00","erpStore":null,"product":{"id":1562,"name":"PAN-PWR-450W-AC","product_type":5,"product_component":36,"product_brand":8,"product_serie":1244,"product_misc":null,"product_qa":null,"pn":"","description":"PA-3400,PA-1400, ION 5200 and ION 9200 450W spare power supply","created_by":1013,"created_at":"2024-04-15 15:40:42","updated_at":"2026-06-26 17:28:49","pinyin_shortcut":"PANPWR450WAC","product_unit":2,"is_renew":false,"in_out_at":"2026-06-26 17:28:49.689912+08","productType":{"id":5,"key":5,"name":"\u5b89\u5168\u8bbe\u5907"},"productComponent":{"id":36,"key":36,"name":"PA\u8bb8\u53ef\u8bc1"},"productBrand":{"id":8,"key":8,"name":"PaloAlto"},"productSerie":{"id":1244,"key":1244,"name":"PA1420\u8f6f\u4ef6\u6388\u6743"},"productUnit":{"id":2,"key":2,"name":"\u5957"}},"erpPurchaseOrderProduct":{"id":338,"erp_purchase_order_id":2165,"erp_store_id":null,"product_id":1562,"description":"","number":"2","into_inventory":"2","amount":"9673","total_amount":"19346.00","last_number":null,"last_amount":null,"last_total_amount":null}},{"id":402,"purchase_contract_id":4374,"erp_store_id":null,"erp_purchase_order_product_id":339,"product_id":1973,"description":"","number":"2","amount":"89068","total_amount":"178136.00","erpStore":null,"product":{"id":1973,"name":"PAN-PA-1410-BND-CORESEC-3YR","product_type":5,"product_component":35,"product_brand":8,"product_serie":803,"product_misc":null,"product_qa":null,"pn":"","description":"PAN-PA-1410-BND-CORESEC-3YR PA-1410\uff0cPrecision AI Network Security Subscription Bundle (Advanced Threat Prevention, Advanced URL Filtering,Advanced Wildfire, Advanced DNS Security and SD-WAN ), 3 years (36 months) term\n\u7cbe\u51c6AI\u7f51\u7edc\u5b89\u5168\u8ba2\u9605\u5305\uff08\u9ad8\u7ea7\u5a01\u80c1\u9632\u5fa1\u3001\u9ad8\u7ea7URL\u8fc7\u6ee4\u3001\u9ad8\u7ea7\u91ce\u706b\u3001\u9ad8\u7ea7DNS\u5b89\u5168\u548cSD-WAN\uff09\uff0c3\u5e74\uff0836\u4e2a\u6708\uff09\u671f\u9650","created_by":1013,"created_at":"2025-05-20 09:22:36","updated_at":"2026-06-26 17:28:49","pinyin_shortcut":"PANPA1410BNDCORESEC3YR","product_unit":2,"is_renew":false,"in_out_at":"2026-06-26 17:28:49.689912+08","productType":{"id":5,"key":5,"name":"\u5b89\u5168\u8bbe\u5907"},"productComponent":{"id":35,"key":35,"name":"\u9632\u706b\u5899\u8f6f\u4ef6"},"productBrand":{"id":8,"key":8,"name":"PaloAlto"},"productSerie":{"id":803,"key":803,"name":"PA-1410\u4e09\u5e74\u670d\u52a1"},"productUnit":{"id":2,"key":2,"name":"\u5957"}},"erpPurchaseOrderProduct":{"id":339,"erp_purchase_order_id":2165,"erp_store_id":null,"product_id":1973,"description":"","number":"2","into_inventory":"2","amount":"89068","total_amount":"178136.00","last_number":null,"last_amount":null,"last_total_amount":null}},{"id":403,"purchase_contract_id":4374,"erp_store_id":null,"erp_purchase_order_product_id":340,"product_id":994,"description":"","number":"2","amount":"34350","total_amount":"68700.00","erpStore":null,"product":{"id":994,"name":"PAN-SVC-BKLN-1410-3YR","product_type":5,"product_component":35,"product_brand":8,"product_serie":803,"product_misc":null,"product_qa":null,"pn":"","description":"PA-1410, Partner enabled premium support, 1 year (12 months) term.","created_by":1013,"created_at":"2023-08-09 17:40:22","updated_at":"2026-06-26 17:28:49","pinyin_shortcut":"PANSVCBKLN14103YR","product_unit":2,"is_renew":false,"in_out_at":"2026-06-26 17:28:49.689912+08","productType":{"id":5,"key":5,"name":"\u5b89\u5168\u8bbe\u5907"},"productComponent":{"id":35,"key":35,"name":"\u9632\u706b\u5899\u8f6f\u4ef6"},"productBrand":{"id":8,"key":8,"name":"PaloAlto"},"productSerie":{"id":803,"key":803,"name":"PA-1410\u4e09\u5e74\u670d\u52a1"},"productUnit":{"id":2,"key":2,"name":"\u5957"}},"erpPurchaseOrderProduct":{"id":340,"erp_purchase_order_id":2165,"erp_store_id":null,"product_id":994,"description":"","number":"2","into_inventory":"2","amount":"34350","total_amount":"68700.00","last_number":null,"last_amount":null,"last_total_amount":null}},{"id":404,"purchase_contract_id":4374,"erp_store_id":null,"erp_purchase_order_product_id":341,"product_id":969,"description":"","number":"2","amount":"36680","total_amount":"73360.00","erpStore":null,"product":{"id":969,"name":"PAN-PA-1410","product_type":5,"product_component":26,"product_brand":8,"product_serie":607,"product_misc":null,"product_qa":null,"pn":"","description":"Palo Alto Networks PA-1410","created_by":1013,"created_at":"2023-08-04 15:49:28","updated_at":"2026-07-04 23:56:28","pinyin_shortcut":"PANPA1410","product_unit":1,"is_renew":false,"in_out_at":"2026-07-04 23:56:28.995218+08","productType":{"id":5,"key":5,"name":"\u5b89\u5168\u8bbe\u5907"},"productComponent":{"id":26,"key":26,"name":"\u9632\u706b\u5899\u4e3b\u673a"},"productBrand":{"id":8,"key":8,"name":"PaloAlto"},"productSerie":{"id":607,"key":607,"name":"PA-1410\u9632\u706b\u5899\u4e3b\u673a"},"productUnit":{"id":1,"key":1,"name":"\u53f0"}},"erpPurchaseOrderProduct":{"id":341,"erp_purchase_order_id":2165,"erp_store_id":null,"product_id":969,"description":"","number":"2","into_inventory":"2","amount":"36680","total_amount":"73360.00","last_number":null,"last_amount":null,"last_total_amount":null}},{"id":405,"purchase_contract_id":4374,"erp_store_id":null,"erp_purchase_order_product_id":342,"product_id":1339,"description":"","number":"2","amount":"18156","total_amount":"36312.00","erpStore":null,"product":{"id":1339,"name":"PAN-SVC-BKLN-460-3YR","product_type":5,"product_component":35,"product_brand":8,"product_serie":1011,"product_misc":null,"product_qa":null,"pn":"","description":"PA-460, Partner enabled premium support, 3 years (36months), term. ","created_by":1013,"created_at":"2024-01-25 09:25:01","updated_at":"2026-06-26 17:28:49","pinyin_shortcut":"PANSVCBKLN4603YR","product_unit":8,"is_renew":false,"in_out_at":"2026-06-26 17:28:49.689912+08","productType":{"id":5,"key":5,"name":"\u5b89\u5168\u8bbe\u5907"},"productComponent":{"id":35,"key":35,"name":"\u9632\u706b\u5899\u8f6f\u4ef6"},"productBrand":{"id":8,"key":8,"name":"PaloAlto"},"productSerie":{"id":1011,"key":1011,"name":"PA-460\u4e09\u5e74\u670d\u52a1"},"productUnit":{"id":8,"key":8,"name":"\u5e74"}},"erpPurchaseOrderProduct":{"id":342,"erp_purchase_order_id":2165,"erp_store_id":null,"product_id":1339,"description":"","number":"2","into_inventory":"2","amount":"18156","total_amount":"36312.00","last_number":null,"last_amount":null,"last_total_amount":null}},{"id":406,"purchase_contract_id":4374,"erp_store_id":null,"erp_purchase_order_product_id":343,"product_id":989,"description":"","number":"1","amount":"1731","total_amount":"1731.00","erpStore":null,"product":{"id":989,"name":"PAN-PA-400-RACKTRAY","product_type":5,"product_component":157,"product_brand":8,"product_serie":615,"product_misc":null,"product_qa":null,"pn":"","description":"Rack mountable tray for up to two PA-400s and 4 power adapters for a 4 post rack mount (PA-440\/450\/460 models only)","created_by":1013,"created_at":"2023-08-09 16:14:38","updated_at":"2026-07-04 23:56:28","pinyin_shortcut":"PANPA400RACKTRAY","product_unit":2,"is_renew":false,"in_out_at":"2026-07-04 23:56:28.995218+08","productType":{"id":5,"key":5,"name":"\u5b89\u5168\u8bbe\u5907"},"productComponent":{"id":157,"key":157,"name":"\u9632\u706b\u5899\u914d\u4ef6"},"productBrand":{"id":8,"key":8,"name":"PaloAlto"},"productSerie":{"id":615,"key":615,"name":"PA-440\/450\/460\u5bfc\u8f68"},"productUnit":{"id":2,"key":2,"name":"\u5957"}},"erpPurchaseOrderProduct":{"id":343,"erp_purchase_order_id":2165,"erp_store_id":null,"product_id":989,"description":"","number":"1","into_inventory":"1","amount":"1731","total_amount":"1731.00","last_number":null,"last_amount":null,"last_total_amount":null}},{"id":407,"purchase_contract_id":4374,"erp_store_id":null,"erp_purchase_order_product_id":344,"product_id":1340,"description":"","number":"2","amount":"923","total_amount":"1846.00","erpStore":null,"product":{"id":1340,"name":"PAN-PWR-50W-AC","product_type":5,"product_component":157,"product_brand":8,"product_serie":1012,"product_misc":null,"product_qa":null,"pn":"","description":"50W AC power adapter for PA-440 PA-450 and PA-460","created_by":1013,"created_at":"2024-01-25 09:26:04","updated_at":"2026-06-26 17:28:49","pinyin_shortcut":"PANPWR50WAC","product_unit":3,"is_renew":false,"in_out_at":"2026-06-26 17:28:49.689912+08","productType":{"id":5,"key":5,"name":"\u5b89\u5168\u8bbe\u5907"},"productComponent":{"id":157,"key":157,"name":"\u9632\u706b\u5899\u914d\u4ef6"},"productBrand":{"id":8,"key":8,"name":"PaloAlto"},"productSerie":{"id":1012,"key":1012,"name":"PA-440\/450\/460\u7535\u6e90"},"productUnit":{"id":3,"key":3,"name":"\u4e2a"}},"erpPurchaseOrderProduct":{"id":344,"erp_purchase_order_id":2165,"erp_store_id":null,"product_id":1340,"description":"","number":"2","into_inventory":"2","amount":"923","total_amount":"1846.00","last_number":null,"last_amount":null,"last_total_amount":null}},{"id":408,"purchase_contract_id":4374,"erp_store_id":null,"erp_purchase_order_product_id":345,"product_id":2233,"description":"","number":"2","amount":"41797","total_amount":"83594.00","erpStore":null,"product":{"id":2233,"name":"PAN-PA-460-BND-CORESEC-3YR","product_type":5,"product_component":36,"product_brand":8,"product_serie":1004,"product_misc":null,"product_qa":null,"pn":"","description":"PA-460, Precision AI Network Security Subscription Bundle (Advanced Threat Prevention, Advanced URL Filtering, Advanced Wildfire, Advanced DNS Security and Advanced SD-WAN ), 3 years (36 months) term","created_by":1013,"created_at":"2026-01-12 11:22:00","updated_at":"2026-06-26 17:28:49","pinyin_shortcut":"PANPA460BNDCORESEC3YR","product_unit":2,"is_renew":false,"in_out_at":"2026-06-26 17:28:49.689912+08","productType":{"id":5,"key":5,"name":"\u5b89\u5168\u8bbe\u5907"},"productComponent":{"id":36,"key":36,"name":"PA\u8bb8\u53ef\u8bc1"},"productBrand":{"id":8,"key":8,"name":"PaloAlto"},"productSerie":{"id":1004,"key":1004,"name":"PA460\u8f6f\u4ef6\u6388\u6743"},"productUnit":{"id":2,"key":2,"name":"\u5957"}},"erpPurchaseOrderProduct":{"id":345,"erp_purchase_order_id":2165,"erp_store_id":null,"product_id":2233,"description":"","number":"2","into_inventory":"2","amount":"41797","total_amount":"83594.00","last_number":null,"last_amount":null,"last_total_amount":null}},{"id":409,"purchase_contract_id":4374,"erp_store_id":null,"erp_purchase_order_product_id":346,"product_id":851,"description":"","number":"2","amount":"21038","total_amount":"42076.00","erpStore":null,"product":{"id":851,"name":"PAN-PA-460","product_type":5,"product_component":26,"product_brand":8,"product_serie":802,"product_misc":null,"product_qa":null,"pn":"","description":"Palo Alto Networks PA-460","created_by":1013,"created_at":"2022-07-25 15:56:10","updated_at":"2026-06-26 17:28:49","pinyin_shortcut":"PANPA460","product_unit":1,"is_renew":false,"in_out_at":"2026-06-26 17:28:49.689912+08","productType":{"id":5,"key":5,"name":"\u5b89\u5168\u8bbe\u5907"},"productComponent":{"id":26,"key":26,"name":"\u9632\u706b\u5899\u4e3b\u673a"},"productBrand":{"id":8,"key":8,"name":"PaloAlto"},"productSerie":{"id":802,"key":802,"name":"PA-460\u9632\u706b\u5899\u4e3b\u673a"},"productUnit":{"id":1,"key":1,"name":"\u53f0"}},"erpPurchaseOrderProduct":{"id":346,"erp_purchase_order_id":2165,"erp_store_id":null,"product_id":851,"description":"","number":"2","into_inventory":"2","amount":"21038","total_amount":"42076.00","last_number":null,"last_amount":null,"last_total_amount":null}},{"id":410,"purchase_contract_id":4374,"erp_store_id":null,"erp_purchase_order_product_id":347,"product_id":2230,"description":"","number":"1","amount":"169548","total_amount":"169548.00","erpStore":null,"product":{"id":2230,"name":"PAN-PA-3440","product_type":5,"product_component":26,"product_brand":8,"product_serie":1758,"product_misc":null,"product_qa":null,"pn":"","description":"","created_by":1013,"created_at":"2026-01-12 10:51:34","updated_at":"2026-06-26 17:28:49","pinyin_shortcut":"PANPA3440","product_unit":1,"is_renew":false,"in_out_at":"2026-06-26 17:28:49.689912+08","productType":{"id":5,"key":5,"name":"\u5b89\u5168\u8bbe\u5907"},"productComponent":{"id":26,"key":26,"name":"\u9632\u706b\u5899\u4e3b\u673a"},"productBrand":{"id":8,"key":8,"name":"PaloAlto"},"productSerie":{"id":1758,"key":1758,"name":"PA-3440\u9632\u706b\u5899\u4e3b\u673a"},"productUnit":{"id":1,"key":1,"name":"\u53f0"}},"erpPurchaseOrderProduct":{"id":347,"erp_purchase_order_id":2165,"erp_store_id":null,"product_id":2230,"description":"","number":"1","into_inventory":"1","amount":"169548","total_amount":"169548.00","last_number":null,"last_amount":null,"last_total_amount":null}},{"id":411,"purchase_contract_id":4374,"erp_store_id":null,"erp_purchase_order_product_id":348,"product_id":2231,"description":"","number":"1","amount":"243588","total_amount":"243588.00","erpStore":null,"product":{"id":2231,"name":"PAN-PA-3440-ATP-3YR","product_type":5,"product_component":36,"product_brand":8,"product_serie":1759,"product_misc":null,"product_qa":null,"pn":"","description":"dvanced Threat Prevention subscription 3-year term, PA-3440","created_by":1013,"created_at":"2026-01-12 11:13:10","updated_at":"2026-07-04 23:56:28","pinyin_shortcut":"PANPA3440ATP3YR","product_unit":2,"is_renew":false,"in_out_at":"2026-07-04 23:56:28.995218+08","productType":{"id":5,"key":5,"name":"\u5b89\u5168\u8bbe\u5907"},"productComponent":{"id":36,"key":36,"name":"PA\u8bb8\u53ef\u8bc1"},"productBrand":{"id":8,"key":8,"name":"PaloAlto"},"productSerie":{"id":1759,"key":1759,"name":"PA3440\u8f6f\u4ef6\u6388\u6743"},"productUnit":{"id":2,"key":2,"name":"\u5957"}},"erpPurchaseOrderProduct":{"id":348,"erp_purchase_order_id":2165,"erp_store_id":null,"product_id":2231,"description":"","number":"1","into_inventory":"1","amount":"243588","total_amount":"243588.00","last_number":null,"last_amount":null,"last_total_amount":null}},{"id":412,"purchase_contract_id":4374,"erp_store_id":null,"erp_purchase_order_product_id":349,"product_id":2232,"description":"","number":"1","amount":"128278","total_amount":"128278.00","erpStore":null,"product":{"id":2232,"name":"PAN-SVC-BKLN-3440-3YR","product_type":5,"product_component":214,"product_brand":8,"product_serie":1760,"product_misc":null,"product_qa":null,"pn":"","description":"Partner enabled premium support 3-year term, PA-3440","created_by":1013,"created_at":"2026-01-12 11:15:06","updated_at":"2026-07-04 23:56:28","pinyin_shortcut":"PANSVCBKLN34403YR","product_unit":2,"is_renew":false,"in_out_at":"2026-07-04 23:56:28.995218+08","productType":{"id":5,"key":5,"name":"\u5b89\u5168\u8bbe\u5907"},"productComponent":{"id":214,"key":214,"name":"\u9632\u706b\u5899\u670d\u52a1"},"productBrand":{"id":8,"key":8,"name":"PaloAlto"},"productSerie":{"id":1760,"key":1760,"name":"\u4e09\u5e74\u670d\u52a1"},"productUnit":{"id":2,"key":2,"name":"\u5957"}},"erpPurchaseOrderProduct":{"id":349,"erp_purchase_order_id":2165,"erp_store_id":null,"product_id":2232,"description":"","number":"1","into_inventory":"1","amount":"128278","total_amount":"128278.00","last_number":null,"last_amount":null,"last_total_amount":null}}],"erpPurchaseOrder":{"id":2165,"serial_no":"CGDD-20260112-00004","from_date":null,"wrote_date":null,"handler":1011,"supplier_id":163,"purchase_contract_id":4374,"erp_store_id":null,"status":2,"abstract":null,"description":"","verify_type":2,"next_verify_user":null,"next_stop_verify_user":null,"next_cancel_verify_user":null,"verify_at":"2026-01-12 18:20:01","stop_at":null,"cancel_at":null,"refuse_description":null,"is_resubmitted":false,"is_used":true,"is_done":false,"is_settle":false,"number":"20","amount":"1046515","created_by":1011,"stop_description":null,"inventory_status":true,"is_cancel":false,"is_old":false,"created_at":"2026-01-12 16:55:18","updated_at":"2026-01-12 18:20:01","print_times":null,"erpPurchaseOrderVerifyRels":[{"id":171,"erp_purchase_order_id":2165,"user_id":1011,"status":1,"description":"","verify_at":"2026-01-12 16:56:21","user":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","avatar":{"id":17,"user_id":1011,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b54747f4-248d-380e-93bc-0f62f769e70d.png"}}},{"id":172,"erp_purchase_order_id":2165,"user_id":1001,"status":1,"description":null,"verify_at":"2026-01-12 18:20:01","user":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/\/avatar\/e868e40f-1256-329e-9b1c-74e095049622.png"}}}],"erpPurchaseOrderStopVerifyRels":[],"erpPurchaseOrderCancelVerifyRels":[]},"erpPurchaseCost":null,"purchaseContractContactPoints":[],"invoiced":"1046515","approve_amount":0,"un_approve_amount":1046515,"un_invoiced":0,"payment_collection_remind_ahead_display":"\u63d0\u524d1\u5929","contract_type_display":"\u4ea7\u54c1\u5408\u540c","collected":"0","un_collected":1046515,"collected_plan":1046515,"is_collected":false,"can_update":true,"can_update_cost":false,"can_update_file":true,"can_delete":true,"can_resubmit":false,"unread":0,"bgcolor":"#89c541","product_amount":1046515,"product_number":20,"is_done":false,"cost_done_display":false,"cost_un_done_display":false,"un_done_display":true,"contact_points_status_display":"\u672a\u8bbe\u7f6e","total_contact_paid_point":0,"total_contact_un_paid_point":0,"erp_all_un_settle_amount":1046515,"advance_purchase":false,"verifyList":[{"id":171,"erp_purchase_order_id":2165,"user_id":1011,"status":1,"description":"","verify_at":"2026-01-12 16:56:21","user":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","avatar":{"id":17,"user_id":1011,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b54747f4-248d-380e-93bc-0f62f769e70d.png"}}},{"id":172,"erp_purchase_order_id":2165,"user_id":1001,"status":1,"description":null,"verify_at":"2026-01-12 18:20:01","user":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/\/avatar\/e868e40f-1256-329e-9b1c-74e095049622.png"}}}]},{"id":4350,"supplier_id":511,"contract_type":3,"signed_at":"2025-12-26","amount":"36375","handler":1011,"description":"","contract_scan":null,"created_by":1011,"created_at":"2025-12-26 14:10:48","updated_at":"2025-12-30 15:46:41","client_id":null,"project_id":null,"sales_rep":null,"serial_no":"TSKJ20251226-HYF-01","payment_collection_remind_ahead":"","including_tax":true,"is_save_collection":true,"save_collection_at":"2025-12-26 14:10:57","is_chargeback":false,"cost_type":1,"is_draft":false,"is_verify":false,"is_refuse":false,"erp_settle_amount":"36375","erp_un_settle_amount":"0","erp_payment_ticket_is_verify":false,"erp_collect_ticket_is_verify":null,"erp_cash_cost_ticket_is_verify":false,"erp_all_settle_amount":"36375","total_contact_point":null,"paid_contact_point":null,"is_edit_verify":false,"is_chargeback_verify":false,"un_paid_contact_point":null,"client":null,"project":null,"supplier":{"id":511,"key":511,"name":"\u5317\u4eac\u610f\u7545\u79d1\u6280\u80a1\u4efd\u6709\u9650\u516c\u53f8","account_number":"\u4e2d\u56fd\u5efa\u8bbe\u94f6\u884c\u80a1\u4efd\u6709\u9650\u516c\u53f8\u5317\u4eac\u8fdc\u5927\u652f\u884c11050163580000000226"},"contractScan":null,"createdBy":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","department_id":3,"avatar":{"id":17,"user_id":1011,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b54747f4-248d-380e-93bc-0f62f769e70d.png"},"department":{"id":3,"key":3,"name":"\u5546\u52a1\u90e8"}},"handlerPerson":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","avatar":{"id":17,"user_id":1011,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b54747f4-248d-380e-93bc-0f62f769e70d.png"}},"commentCount":{"object_id":4350,"comment":3},"purchaseClientRels":[{"id":4334,"contract_id":4350,"client_id":3301,"project_id":4086,"client":{"id":3301,"key":3301,"name":"\u91d1\u878d\u65f6\u62a5\u793e","sales_rep":1001,"clickable":1},"project":{"id":4086,"key":4086,"name":"\u5b89\u5168\u68c0\u6d4b\u4e0e\u54cd\u5e94\u5e73\u53f0\u53ca\u670d\u52a1\u9879\u76ee","project_status":3,"budget":"37500","buildContract":{"id":4349,"from_project":4086,"serial_no":"Jrsbht2025169"},"clickable":1}}],"purchaseContractPayments":[{"id":"12312","key":"12312","contract_id":4350,"amount":"36375","value":"36375","collected_date":"2026-01-22 00:00:00","created_at":"2026-01-22 13:22:42","created_by":5252,"description":"\u7f51\u94f6\u6c47\u6b3e \u610f\u7545\u79d1\u6280","createdBy":{"id":5252,"key":5252,"name":"\u738b\u7b11\u7b11","sex":"F","department_id":6},"pct":100}],"purchaseContractInvoices":[{"id":2615,"key":2615,"contract_id":4350,"amount":"36375","value":"36375","attachment_id":null,"from_date":"2025-12-26","description":"","is_draft":false,"is_cancel":false,"purchaseInvoiceAmounts":[{"id":2377,"purchase_invoice_id":2615,"amount":"36375","tax_rate":"6"}],"attachment":null,"attachmentRelationships":[],"files":[{"id":54276,"object_type":103,"object_id":2615,"attachment_id":30874,"attachment":{"id":30874,"key":30874,"name":"d34d8a5d-5cf2-3812-a3eb-03541e725315","extension":"pdf","path":"\/v2\/attachment\/view\/lLLCHpZSQkMu0_ceemp9PVo8_3HEKkFC\/d34d8a5d-5cf2-3812-a3eb-03541e725315\/dzfp_25112000000295866959_\u5317\u4eac\u62d3\u5b9e\u79d1\u6280\u6709\u9650\u516c\u53f8_20251226131534.pdf","orig_name":"dzfp_25112000000295866959_\u5317\u4eac\u62d3\u5b9e\u79d1\u6280\u6709\u9650\u516c\u53f8_20251226131534.pdf"}}]}],"contractScans":[{"id":54607,"object_type":108,"object_id":4350,"attachment_id":30964,"attachment":{"id":30964,"key":30964,"name":"08003822-96c6-3947-b05d-03ab039d0b4d","extension":"pdf","path":"\/v2\/attachment\/preview\/lLLCHpZSQkMu0_ceemp9PVo8_3HEKkFC\/08003822-96c6-3947-b05d-03ab039d0b4d\/2025_12_30_09_09_52.pdf","orig_name":"2025_12_30_09_09_52.pdf"}}],"receiptScans":[],"purchaseContractPaymentCollectionRemindReceivers":[{"id":1782,"user_id":1011,"key":1011,"contract_id":4350,"user":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","avatar":{"id":17,"user_id":1011,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b54747f4-248d-380e-93bc-0f62f769e70d.png"}}},{"id":1783,"user_id":5360,"key":5360,"contract_id":4350,"user":{"id":5360,"key":5360,"name":"\u5f20\u7ea2\u82b3","sex":"F","avatar":{"id":153,"user_id":5360,"name":"\/files\/cdn\/a57be577deb434\/avatar\/612c2410-e800-3507-aa05-3f1fbeb408a7.png"}}}],"purchaseContractPaymentCollectionRemindDates":[{"id":1042,"key":1042,"contract_id":4350,"name":"2025-12-31","value":"36375","overdue_days":22,"status":1,"remind_date":"2025-12-31","pct":100,"overdue_display":"\u903e\u671f22\u5929"}],"paymentApproves":[{"id":2631,"client_id":20,"project_id":4026,"title":"\u4ed8\u6b3e\u7533\u8bf7-\u5317\u4eac\u610f\u7545\u79d1\u6280\u80a1\u4efd\u6709\u9650\u516c\u53f8","status":2,"next_verify_user":null,"verify_at":"2026-01-22 10:09:24","description":"Tristen\uff0c\u7533\u8bf7\u652f\u4ed8\u6df1\u4fe1\u670d\u4ea7\u54c1\u7684\u91c7\u8d2d\u6b3e\uff0c\u91d1\u989d\uff1a\uffe536375\u5143\u3002\u8bf7\u5ba1\u6279~\n\n\u5907\u6ce8\uff1a\u4ea7\u54c1\u5df2\u5165\u5e93\uff0c\u5df2\u51fa\u5e93\uff0c\u7528\u6237\u5df2\u56de\u5168\u6b3e\u3002\n\u7eb8\u8d28\u652f\u51fa\u51ed\u5355\u5df2\u63d0\u4ea4\u5ba1\u6838\uff01","refuse_description":null,"is_resubmited":false,"created_by":1011,"created_at":"2026-01-22 10:09:00","updated_at":"2026-01-22 10:09:24","supplier_id":511,"purchase_contract_id":4350,"amount":"36375","borrow_amount":null,"borrow_collect_day":null,"borrow_collect_status":1,"borrow_collect_description":null,"borrow_collect_at":null,"erp_payment_settle_amount":"36375","erp_payment_un_settle_amount":"0","erp_borrow_settle_amount":"0","erp_borrow_un_settle_amount":"0","next_cancel_verify_user":null,"cancel_at":null,"cancel_description":null,"erp_payment_all_settle_amount":"36375"}],"costContractAmounts":[],"unreadComments":null,"purchaseContractProductRels":[{"id":374,"purchase_contract_id":4350,"erp_store_id":null,"erp_purchase_order_product_id":315,"product_id":1650,"description":"","number":"1","amount":"36375","total_amount":"36375.00","erpStore":null,"product":{"id":1650,"name":"SAAS XDR\u5e73\u53f0 \u53ef\u6269\u5c55\u68c0\u6d4b\u4e0e\u54cd\u5e94\u5e73\u53f0\u8ba2\u9605\u670d\u52a1\u8d39","product_type":7,"product_component":188,"product_brand":12,"product_serie":1404,"product_misc":null,"product_qa":null,"pn":"","description":"\u57fa\u7840\u5e73\u53f0\u670d\u52a1\uff1a\u53ef\u5bb9\u7eb3180\u5929\u5ba1\u8ba1\u6570\u636e\u3001\u544a\u8b66\u65e5\u5fd7\u3001\u9065\u6d4b\u6570\u636e\u7684\u5b58\u50a8\uff0c\u4e8b\u4ef6\u3001\u6f0f\u6d1e\u3001\u8d44\u4ea7\u3001\u914d\u7f6e\u7c7b\u6570\u636e\u5168\u5e74\u5b58\u50a8\uff0c\n\u5305\u542b\u4e00\u5e74\u670d\u52a1\u5e73\u53f0\u5347\u7ea7\u8d39\u7528\u3001\u7279\u5f81\u5e93\u5347\u7ea7\u8d39\u7528\u3001\u68c0\u6d4b\u5f15\u64ce\u5347\u7ea7\u8d39\u7528\uff0c\n\u5305\u542b\u4e00\u5e74\u7684\u5b89\u5168\u4e8b\u4ef6\u6df1\u5ea6\u6316\u6398\u670d\u52a1-XTH\u8d39\u7528\uff0c\u5177\u4f53\u529f\u80fd\u5982\u4e0b\uff1a\n1.\u6d77\u91cf\u7070\u5ea6\u89c4\u5219+\u591a\u5f15\u64ce\u5206\u6790\uff1a\u57fa\u4e8e\u4e91\u7aef\u6570\u636e\u6e56\uff0c\u5bf9\u6d77\u91cf\u7ebf\u7d22\u548c\u6570\u636e\u8fdb\u884c\u7070\u5ea6\u89c4\u5219\u548c\u79c1\u6709\u5f15\u64ce\u4e8c\u6b21\u5206\u6790\uff0c\u72e9\u730e\u5e08\u7814\u5224\u540e\u751f\u6210\u62a5\u544a\uff1b \n2.\u57fa\u4e8e\u5b89\u5168\u544a\u8b66\u7684\u9690\u85cf\u5a01\u80c1\u68c0\u6d4b\uff1a\u57fa\u4e8e\u72e9\u730e\u5206\u6790\u5e08\u7684\u7ecf\u9a8c\u56fa\u5316\u6210\u68c0\u6d4b\u6a21\u578b\uff0c\u5bf9\u4e8e\u672a\u77e5\u4e0d\u786e\u4fe1\u7684\u544a\u8b66\u8fdb\u884c\u6df1\u5ea6\u8c03\u67e5\u5173\u8054\uff0c\u81ea\u52a8\u5316\u751f\u6210\u5b89\u5168\u4e8b\u4ef6\u5e76\u63a8\u9001\uff1b\n3.\u4e91\u7aef\u4e13\u5bb6\u4e8b\u4ef6\u7814\u5224\n\u9488\u5bf9XDR\u5e73\u53f0\u4ea7\u751f\u7684\u5b89\u5168\u4e8b\u4ef6\uff0c\u4e91\u7aef\u4e13\u5bb6\u4ecb\u5165\u505a\u7814\u5224\uff0c\u8fdb\u4e00\u6b65\u4fdd\u969c\u4e8b\u4ef6\u68c0\u51fa\u7684\u51c6\u786e\u6027\nSAAS XDR\u5e73\u53f0\u670d\u52a1\u7684\u7f51\u7edc\u4fa7\u4fa7\u9065\u6d4b\u6e90\uff0c\u9700\u8981\u91c7\u96c6\u7684\u7f51\u7edc\u6d41\u91cf\u68c0\u6d4b\u8bbe\u5907\u7684\u6d41\u91cf 2000\nSAAS XDR\u5e73\u53f0\u670d\u52a1\u7684\u7aef\u70b9\u4fa7\u9065\u6d4b\u6e90\uff0c\u9700\u8981\u91c7\u96c6\u7684\u7aef\u70b9\u884c\u4e3a\u6570\u636e\u7684\u670d\u52a1\u5668\u6570\u91cf 25\n","created_by":1013,"created_at":"2024-06-06 16:17:46","updated_at":"2025-12-26 15:43:29","pinyin_shortcut":"SAASXDRptkkzjcyxyptdyfwf","product_unit":2,"is_renew":false,"in_out_at":"2025-12-26 15:43:29.515469+08","productType":{"id":7,"key":7,"name":"\u8f6f\u4ef6"},"productComponent":{"id":188,"key":188,"name":"\u7cfb\u7edf\u8ba2\u9605\u8f6f\u4ef6"},"productBrand":{"id":12,"key":12,"name":"\u6df1\u4fe1\u670d"},"productSerie":{"id":1404,"key":1404,"name":"\u6df1\u4fe1\u670d SAAS XDR\u5e73\u53f0 \u53ef\u6269\u5c55\u68c0\u6d4b\u4e0e\u54cd\u5e94\u5e73\u53f0\u8ba2\u9605\u670d\u52a1\u8d39"},"productUnit":{"id":2,"key":2,"name":"\u5957"}},"erpPurchaseOrderProduct":{"id":315,"erp_purchase_order_id":2149,"erp_store_id":null,"product_id":1650,"description":"","number":"1","into_inventory":"1","amount":"36375","total_amount":"36375.00","last_number":null,"last_amount":null,"last_total_amount":null}}],"erpPurchaseOrder":{"id":2149,"serial_no":"CGDD-20251226-00001","from_date":null,"wrote_date":"2025-12-26","handler":1011,"supplier_id":511,"purchase_contract_id":4350,"erp_store_id":null,"status":2,"abstract":null,"description":"","verify_type":2,"next_verify_user":null,"next_stop_verify_user":null,"next_cancel_verify_user":null,"verify_at":"2025-12-26 14:11:05","stop_at":null,"cancel_at":null,"refuse_description":null,"is_resubmitted":false,"is_used":true,"is_done":false,"is_settle":false,"number":"1","amount":"36375","created_by":1011,"stop_description":null,"inventory_status":true,"is_cancel":false,"is_old":false,"created_at":"2025-12-26 14:10:49","updated_at":"2025-12-26 14:11:05","print_times":null,"erpPurchaseOrderVerifyRels":[{"id":155,"erp_purchase_order_id":2149,"user_id":1011,"status":1,"description":"","verify_at":"2025-12-26 14:11:05","user":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","avatar":{"id":17,"user_id":1011,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b54747f4-248d-380e-93bc-0f62f769e70d.png"}}}],"erpPurchaseOrderStopVerifyRels":[],"erpPurchaseOrderCancelVerifyRels":[]},"erpPurchaseCost":null,"purchaseContractContactPoints":[],"invoiced":"36375","approve_amount":36375,"un_approve_amount":0,"un_invoiced":0,"payment_collection_remind_ahead_display":"\u65e0","contract_type_display":"\u670d\u52a1\u5408\u540c","collected":"36375","un_collected":0,"collected_plan":36375,"is_collected":true,"can_update":true,"can_update_cost":false,"can_update_file":true,"can_delete":true,"can_resubmit":false,"unread":0,"bgcolor":"#89c541","product_amount":36375,"product_number":1,"is_done":true,"cost_done_display":false,"cost_un_done_display":false,"done_display":true,"contact_points_status_display":"\u672a\u8bbe\u7f6e","total_contact_paid_point":0,"total_contact_un_paid_point":0,"erp_all_un_settle_amount":0,"advance_purchase":false,"verifyList":[{"id":155,"erp_purchase_order_id":2149,"user_id":1011,"status":1,"description":"","verify_at":"2025-12-26 14:11:05","user":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","avatar":{"id":17,"user_id":1011,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b54747f4-248d-380e-93bc-0f62f769e70d.png"}}}]},{"id":4293,"supplier_id":511,"contract_type":1,"signed_at":"2025-12-08","amount":"27218","handler":1011,"description":"","contract_scan":null,"created_by":1011,"created_at":"2025-12-08 14:34:35","updated_at":"2025-12-09 09:56:16","client_id":null,"project_id":null,"sales_rep":null,"serial_no":"KJSLS25222","payment_collection_remind_ahead":"1 day","including_tax":true,"is_save_collection":true,"save_collection_at":"2025-12-08 14:35:55","is_chargeback":false,"cost_type":1,"is_draft":false,"is_verify":false,"is_refuse":false,"erp_settle_amount":"27218","erp_un_settle_amount":"0","erp_payment_ticket_is_verify":false,"erp_collect_ticket_is_verify":null,"erp_cash_cost_ticket_is_verify":false,"erp_all_settle_amount":"27218","total_contact_point":null,"paid_contact_point":null,"is_edit_verify":false,"is_chargeback_verify":false,"un_paid_contact_point":null,"client":null,"project":null,"supplier":{"id":511,"key":511,"name":"\u5317\u4eac\u610f\u7545\u79d1\u6280\u80a1\u4efd\u6709\u9650\u516c\u53f8","account_number":"\u4e2d\u56fd\u5efa\u8bbe\u94f6\u884c\u80a1\u4efd\u6709\u9650\u516c\u53f8\u5317\u4eac\u8fdc\u5927\u652f\u884c11050163580000000226"},"contractScan":null,"createdBy":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","department_id":3,"avatar":{"id":17,"user_id":1011,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b54747f4-248d-380e-93bc-0f62f769e70d.png"},"department":{"id":3,"key":3,"name":"\u5546\u52a1\u90e8"}},"handlerPerson":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","avatar":{"id":17,"user_id":1011,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b54747f4-248d-380e-93bc-0f62f769e70d.png"}},"commentCount":{"object_id":4293,"comment":2},"purchaseClientRels":[{"id":4374,"contract_id":4293,"client_id":3427,"project_id":4057,"client":{"id":3427,"key":3427,"name":"\u4e2d\u592e\u5ba3\u4f20\u90e8\u7535\u5f71\u6570\u5b57\u8282\u76ee\u7ba1\u7406\u4e2d\u5fc3","sales_rep":1001,"clickable":1},"project":{"id":4057,"key":4057,"name":"\u9632\u706b\u5899AF-2020\u4ea7\u54c1\u4e91\u667a\u8ba2\u9605\u8f6f\u4ef6\u91c7\u8d2d\u9879\u76ee","project_status":3,"budget":"28060.4","buildContract":{"id":4285,"from_project":4057,"serial_no":"DM0020255590473"},"clickable":1}}],"purchaseContractPayments":[{"id":"12248","key":"12248","contract_id":4293,"amount":"27218","value":"27218","collected_date":"2025-12-15 00:00:00","created_at":"2025-12-15 15:41:38","created_by":5388,"description":"\u7f51\u94f6\u6c47\u6b3e \u5317\u4eac\u610f\u7545","createdBy":{"id":5388,"key":5388,"name":"\u6768\u71d5\u971e","sex":"F","department_id":6},"pct":100}],"purchaseContractInvoices":[{"id":2567,"key":2567,"contract_id":4293,"amount":"27218","value":"27218","attachment_id":null,"from_date":"2025-12-08","description":"","is_draft":false,"is_cancel":false,"purchaseInvoiceAmounts":[{"id":4916,"purchase_invoice_id":2567,"amount":"27218","tax_rate":"13"}],"attachment":null,"attachmentRelationships":[],"files":[{"id":53346,"object_type":103,"object_id":2567,"attachment_id":30242,"attachment":{"id":30242,"key":30242,"name":"f45c1ef3-4639-3c96-9ad8-fe421777b1c4","extension":"pdf","path":"\/v2\/attachment\/view\/lLLCHpZSQkMu0_ceemp9PVo8_3HEKkFC\/f45c1ef3-4639-3c96-9ad8-fe421777b1c4\/dzfp_25112000000274834192_\u5317\u4eac\u610f\u7545\u79d1\u6280\u80a1\u4efd\u6709\u9650\u516c\u53f8_20251208113046.pdf","orig_name":"dzfp_25112000000274834192_\u5317\u4eac\u610f\u7545\u79d1\u6280\u80a1\u4efd\u6709\u9650\u516c\u53f8_20251208113046.pdf"}}]}],"contractScans":[{"id":53374,"object_type":108,"object_id":4293,"attachment_id":30262,"attachment":{"id":30262,"key":30262,"name":"ec6e9058-41d4-390d-8877-f8adc75bd966","extension":"pdf","path":"\/v2\/attachment\/preview\/lLLCHpZSQkMu0_ceemp9PVo8_3HEKkFC\/ec6e9058-41d4-390d-8877-f8adc75bd966\/\uff08\u4e2d\u5ba3\uff09\u62d3\u5b9e-\u610f\u7545\u5408\u540c27218\u5143.pdf","orig_name":"\uff08\u4e2d\u5ba3\uff09\u62d3\u5b9e-\u610f\u7545\u5408\u540c27218\u5143.pdf"}}],"receiptScans":[],"purchaseContractPaymentCollectionRemindReceivers":[{"id":1706,"user_id":1011,"key":1011,"contract_id":4293,"user":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","avatar":{"id":17,"user_id":1011,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b54747f4-248d-380e-93bc-0f62f769e70d.png"}}},{"id":1707,"user_id":5360,"key":5360,"contract_id":4293,"user":{"id":5360,"key":5360,"name":"\u5f20\u7ea2\u82b3","sex":"F","avatar":{"id":153,"user_id":5360,"name":"\/files\/cdn\/a57be577deb434\/avatar\/612c2410-e800-3507-aa05-3f1fbeb408a7.png"}}}],"purchaseContractPaymentCollectionRemindDates":[{"id":1001,"key":1001,"contract_id":4293,"name":"2025-12-20","value":"27218","overdue_days":null,"status":1,"remind_date":"2025-12-20","pct":100,"overdue_display":""}],"paymentApproves":[{"id":2514,"client_id":3427,"project_id":4057,"title":"\u4ed8\u6b3e\u7533\u8bf7-\u5317\u4eac\u610f\u7545\u79d1\u6280\u80a1\u4efd\u6709\u9650\u516c\u53f8","status":2,"next_verify_user":null,"verify_at":"2025-12-15 15:04:14","description":"Tristen\uff0c\u7533\u8bf7\u652f\u4ed8\u6df1\u4fe1\u670d\u8f6f\u4ef6\u7684\u91c7\u8d2d\u6b3e\uff0c\u91d1\u989d\uff1a\uffe527218\u5143\uff0c\u8bf7\u5ba1\u6279\uff01\n\n\u5907\u6ce8\uff1a\u4ea7\u54c1\u5df2\u5165\u5e93\uff0c\u5df2\u4ea4\u4ed8\uff0c\u7528\u6237\u5df2\u56de\u6b3e\u3002\n\u7eb8\u8d28\u652f\u51fa\u51ed\u5355\u5df2\u63d0\u4ea4\u5ba1\u6838\uff01","refuse_description":null,"is_resubmited":false,"created_by":1011,"created_at":"2025-12-15 15:00:47","updated_at":"2025-12-15 15:04:14","supplier_id":511,"purchase_contract_id":4293,"amount":"27218","borrow_amount":null,"borrow_collect_day":null,"borrow_collect_status":1,"borrow_collect_description":null,"borrow_collect_at":null,"erp_payment_settle_amount":"27218","erp_payment_un_settle_amount":"0","erp_borrow_settle_amount":"0","erp_borrow_un_settle_amount":"0","next_cancel_verify_user":null,"cancel_at":null,"cancel_description":null,"erp_payment_all_settle_amount":"27218"}],"costContractAmounts":[],"unreadComments":null,"purchaseContractProductRels":[{"id":280,"purchase_contract_id":4293,"erp_store_id":null,"erp_purchase_order_product_id":239,"product_id":1148,"description":"","number":"2","amount":"13609","total_amount":"27218","erpStore":null,"product":{"id":1148,"name":"\u6df1\u4fe1\u670d\u5b89\u5168\u4e91\u8111\u4e91\u667a\u8ba2\u9605\u8f6f\u4ef6 V8.0","product_type":5,"product_component":35,"product_brand":12,"product_serie":103,"product_misc":null,"product_qa":null,"pn":"","description":"","created_by":1013,"created_at":"2023-12-13 14:20:48","updated_at":"2026-01-28 10:32:39","pinyin_shortcut":"sxfaqynyzdyrjV80","product_unit":2,"is_renew":false,"in_out_at":"2026-01-28 10:32:39.333577+08","productType":{"id":5,"key":5,"name":"\u5b89\u5168\u8bbe\u5907"},"productComponent":{"id":35,"key":35,"name":"\u9632\u706b\u5899\u8f6f\u4ef6"},"productBrand":{"id":12,"key":12,"name":"\u6df1\u4fe1\u670d"},"productSerie":{"id":103,"key":103,"name":"\u6df1\u4fe1\u670d\u9632\u706b\u5899\u8f6f\u4ef6"},"productUnit":{"id":2,"key":2,"name":"\u5957"}},"erpPurchaseOrderProduct":{"id":239,"erp_purchase_order_id":2119,"erp_store_id":null,"product_id":1148,"description":"","number":"2","into_inventory":"2","amount":"13609","total_amount":"27218","last_number":"2","last_amount":"13609","last_total_amount":"27218"}}],"erpPurchaseOrder":{"id":2119,"serial_no":"CGDD-20251208-00003","from_date":null,"wrote_date":null,"handler":1011,"supplier_id":511,"purchase_contract_id":4293,"erp_store_id":null,"status":2,"abstract":null,"description":"","verify_type":2,"next_verify_user":null,"next_stop_verify_user":null,"next_cancel_verify_user":null,"verify_at":"2025-12-08 14:36:07","stop_at":"2025-12-09 09:56:16.998992+08","cancel_at":null,"refuse_description":null,"is_resubmitted":false,"is_used":true,"is_done":false,"is_settle":false,"number":"2","amount":"27218","created_by":1011,"stop_description":null,"inventory_status":true,"is_cancel":false,"is_old":false,"created_at":"2025-12-08 14:35:31","updated_at":"2025-12-09 09:57:28","print_times":null,"erpPurchaseOrderVerifyRels":[{"id":125,"erp_purchase_order_id":2119,"user_id":1011,"status":1,"description":"","verify_at":"2025-12-08 14:36:07","user":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","avatar":{"id":17,"user_id":1011,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b54747f4-248d-380e-93bc-0f62f769e70d.png"}}}],"erpPurchaseOrderStopVerifyRels":[{"id":8,"erp_purchase_order_id":2119,"user_id":1011,"status":1,"description":"","verify_at":"2025-12-09 09:57:28","user":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","avatar":{"id":17,"user_id":1011,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b54747f4-248d-380e-93bc-0f62f769e70d.png"}}}],"erpPurchaseOrderCancelVerifyRels":[]},"erpPurchaseCost":null,"purchaseContractContactPoints":[],"invoiced":"27218","approve_amount":27218,"un_approve_amount":0,"un_invoiced":0,"payment_collection_remind_ahead_display":"\u63d0\u524d1\u5929","contract_type_display":"\u4ea7\u54c1\u5408\u540c","collected":"27218","un_collected":0,"collected_plan":27218,"is_collected":true,"can_update":true,"can_update_cost":false,"can_update_file":true,"can_delete":true,"can_resubmit":false,"unread":0,"bgcolor":"#89c541","product_amount":27218,"product_number":2,"is_done":true,"cost_done_display":false,"cost_un_done_display":false,"done_display":true,"contact_points_status_display":"\u672a\u8bbe\u7f6e","total_contact_paid_point":0,"total_contact_un_paid_point":0,"erp_all_un_settle_amount":0,"advance_purchase":false,"verifyList":[{"id":125,"erp_purchase_order_id":2119,"user_id":1011,"status":1,"description":"","verify_at":"2025-12-08 14:36:07","user":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","avatar":{"id":17,"user_id":1011,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b54747f4-248d-380e-93bc-0f62f769e70d.png"}}}]},{"id":4295,"supplier_id":90,"contract_type":1,"signed_at":"2025-11-28","amount":"3516028","handler":1011,"description":"","contract_scan":null,"created_by":1011,"created_at":"2025-12-09 13:30:49","updated_at":"2025-12-10 16:42:50","client_id":null,"project_id":null,"sales_rep":null,"serial_no":"X_2025SBQ35338","payment_collection_remind_ahead":"1 day","including_tax":true,"is_save_collection":true,"save_collection_at":"2025-12-09 13:31:38","is_chargeback":false,"cost_type":1,"is_draft":false,"is_verify":false,"is_refuse":false,"erp_settle_amount":"3516028","erp_un_settle_amount":"0","erp_payment_ticket_is_verify":false,"erp_collect_ticket_is_verify":null,"erp_cash_cost_ticket_is_verify":false,"erp_all_settle_amount":"3516028","total_contact_point":null,"paid_contact_point":null,"is_edit_verify":false,"is_chargeback_verify":false,"un_paid_contact_point":null,"client":null,"project":null,"supplier":{"id":90,"key":90,"name":"\u7d2b\u5149\u6653\u901a\u79d1\u6280\u6709\u9650\u516c\u53f8","account_number":""},"contractScan":null,"createdBy":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","department_id":3,"avatar":{"id":17,"user_id":1011,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b54747f4-248d-380e-93bc-0f62f769e70d.png"},"department":{"id":3,"key":3,"name":"\u5546\u52a1\u90e8"}},"handlerPerson":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","avatar":{"id":17,"user_id":1011,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b54747f4-248d-380e-93bc-0f62f769e70d.png"}},"commentCount":{"object_id":4295,"comment":4},"purchaseClientRels":[{"id":4370,"contract_id":4295,"client_id":3429,"project_id":4063,"client":{"id":3429,"key":3429,"name":"\u5e7f\u5dde\u4e16\u5b89\u4fe1\u606f\u6280\u672f\u80a1\u4efd\u6709\u9650\u516c\u53f8","sales_rep":1001,"clickable":1},"project":{"id":4063,"key":4063,"name":"\u8fdc\u9274 \u667a\u80fd\u8bed\u97f3\u5173\u952e\u8bcd\u8bc6\u522b\u7cfb\u7edf\u91c7\u4e70\u9879\u76ee","project_status":3,"budget":"3587784","buildContract":{"id":4291,"from_project":4063,"serial_no":"2025-12-08-001"},"clickable":1}}],"purchaseContractPayments":[{"id":"12298","key":"12298","contract_id":4295,"amount":"3516028","value":"3516028","collected_date":"2026-01-08 00:00:00","created_at":"2026-01-08 10:44:52","created_by":5388,"description":"\u7f51\u94f6\u6c47\u6b3e \u7d2b\u5149\u6653\u901a","createdBy":{"id":5388,"key":5388,"name":"\u6768\u71d5\u971e","sex":"F","department_id":6},"pct":100}],"purchaseContractInvoices":[{"id":2570,"key":2570,"contract_id":4295,"amount":"3516028","value":"3516028","attachment_id":null,"from_date":"2025-11-28","description":"","is_draft":false,"is_cancel":false,"purchaseInvoiceAmounts":[{"id":2247,"purchase_invoice_id":2570,"amount":"3516028","tax_rate":"13"}],"attachment":null,"attachmentRelationships":[],"files":[{"id":53395,"object_type":103,"object_id":2570,"attachment_id":30282,"attachment":{"id":30282,"key":30282,"name":"06d5caca-ad64-35d6-a694-5ecb074121ce","extension":"pdf","path":"\/v2\/attachment\/view\/lLLCHpZSQkMu0_ceemp9PVo8_3HEKkFC\/06d5caca-ad64-35d6-a694-5ecb074121ce\/\u7d2b\u5149\u53d1\u7968.pdf","orig_name":"\u7d2b\u5149\u53d1\u7968.pdf"}}]}],"contractScans":[{"id":53399,"object_type":108,"object_id":4295,"attachment_id":30281,"attachment":{"id":30281,"key":30281,"name":"6b7dc680-860e-3007-967c-0c41f68f8857","extension":"pdf","path":"\/v2\/attachment\/preview\/lLLCHpZSQkMu0_ceemp9PVo8_3HEKkFC\/6b7dc680-860e-3007-967c-0c41f68f8857\/document.pdf","orig_name":"document.pdf"}}],"receiptScans":[{"id":53498,"object_type":111,"object_id":4295,"attachment_id":30354,"attachment":{"id":30354,"key":30354,"name":"448b0f0a-8f2f-37a0-b998-e0ab370b8416","extension":"pdf","path":"\/v2\/attachment\/preview\/lLLCHpZSQkMu0_ceemp9PVo8_3HEKkFC\/448b0f0a-8f2f-37a0-b998-e0ab370b8416\/document (1).pdf","orig_name":"document (1).pdf"}}],"purchaseContractPaymentCollectionRemindReceivers":[{"id":1710,"user_id":1011,"key":1011,"contract_id":4295,"user":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","avatar":{"id":17,"user_id":1011,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b54747f4-248d-380e-93bc-0f62f769e70d.png"}}},{"id":1711,"user_id":5360,"key":5360,"contract_id":4295,"user":{"id":5360,"key":5360,"name":"\u5f20\u7ea2\u82b3","sex":"F","avatar":{"id":153,"user_id":5360,"name":"\/files\/cdn\/a57be577deb434\/avatar\/612c2410-e800-3507-aa05-3f1fbeb408a7.png"}}}],"purchaseContractPaymentCollectionRemindDates":[{"id":1003,"key":1003,"contract_id":4295,"name":"2025-12-26","value":"3516028","overdue_days":13,"status":1,"remind_date":"2025-12-26","pct":100,"overdue_display":"\u903e\u671f13\u5929"}],"paymentApproves":[{"id":2601,"client_id":3429,"project_id":4063,"title":"\u4ed8\u6b3e\u7533\u8bf7-\u7d2b\u5149\u6653\u901a\u79d1\u6280\u6709\u9650\u516c\u53f8","status":2,"next_verify_user":null,"verify_at":"2026-01-08 10:41:55","description":"Tristen\uff0c\u7533\u8bf7\u652f\u4ed8\u8fdc\u9274\u4ea7\u54c1\u7684\u91c7\u8d2d\u6b3e\uff0c\u91d1\u989d\uff1a\uffe53516028\u5143\uff0c\u8bf7\u5ba1\u6279\uff01\n\n\u5907\u6ce8\uff1a\u4ea7\u54c1\u5df2\u5165\u5e93\uff0c\u5df2\u51fa\u5e93\uff0c\u7528\u6237\u8d27\u6b3e\u5df2\u5168\u989d\u56de\u6b3e\u3002\n\u7eb8\u8d28\u652f\u51fa\u51ed\u5355\u5df2\u63d0\u4ea4\u5ba1\u6838\uff01","refuse_description":null,"is_resubmited":false,"created_by":1011,"created_at":"2026-01-08 09:22:36","updated_at":"2026-01-08 10:41:55","supplier_id":90,"purchase_contract_id":4295,"amount":"3516028","borrow_amount":null,"borrow_collect_day":null,"borrow_collect_status":1,"borrow_collect_description":null,"borrow_collect_at":null,"erp_payment_settle_amount":"3516028","erp_payment_un_settle_amount":"0","erp_borrow_settle_amount":"0","erp_borrow_un_settle_amount":"0","next_cancel_verify_user":null,"cancel_at":null,"cancel_description":null,"erp_payment_all_settle_amount":"3516028"}],"costContractAmounts":[],"unreadComments":null,"purchaseContractProductRels":[{"id":288,"purchase_contract_id":4295,"erp_store_id":null,"erp_purchase_order_product_id":247,"product_id":1757,"description":"","number":"4","amount":"879007","total_amount":"3516028.00","erpStore":null,"product":{"id":1757,"name":"\u8bed\u97f3\u5408\u6210\u7cfb\u7edfV1.0","product_type":7,"product_component":64,"product_brand":230,"product_serie":1486,"product_misc":null,"product_qa":null,"pn":"","description":"\u8fdc\u9274\u8bed\u97f3\u5408\u6210\u7cfb\u7edfV1.0","created_by":1013,"created_at":"2024-08-22 15:38:09","updated_at":"2025-12-10 11:15:37","pinyin_shortcut":"yyhcxtV10","product_unit":2,"is_renew":false,"in_out_at":"2025-12-10 11:15:37.895385+08","productType":{"id":7,"key":7,"name":"\u8f6f\u4ef6"},"productComponent":{"id":64,"key":64,"name":"\u89c6\u9891\u76d1\u63a7\u5e73\u53f0\u8f6f\u4ef6"},"productBrand":{"id":230,"key":230,"name":"\u8fdc\u9274"},"productSerie":{"id":1486,"key":1486,"name":"\u8bed\u97f3\u5408\u6210\u7cfb\u7edfV1.0"},"productUnit":{"id":2,"key":2,"name":"\u5957"}},"erpPurchaseOrderProduct":{"id":247,"erp_purchase_order_id":2121,"erp_store_id":null,"product_id":1757,"description":"","number":"4","into_inventory":"4","amount":"879007","total_amount":"3516028.00","last_number":null,"last_amount":null,"last_total_amount":null}}],"erpPurchaseOrder":{"id":2121,"serial_no":"CGDD-20251209-00002","from_date":null,"wrote_date":"2025-11-28","handler":1011,"supplier_id":90,"purchase_contract_id":4295,"erp_store_id":null,"status":2,"abstract":null,"description":"","verify_type":2,"next_verify_user":null,"next_stop_verify_user":null,"next_cancel_verify_user":null,"verify_at":"2025-12-09 13:31:48","stop_at":"2025-12-09 14:03:37.305253+08","cancel_at":null,"refuse_description":null,"is_resubmitted":false,"is_used":true,"is_done":false,"is_settle":false,"number":"4","amount":"3516028","created_by":1011,"stop_description":null,"inventory_status":true,"is_cancel":false,"is_old":false,"created_at":"2025-12-09 13:30:49","updated_at":"2025-12-09 14:03:48","print_times":null,"erpPurchaseOrderVerifyRels":[{"id":127,"erp_purchase_order_id":2121,"user_id":1011,"status":1,"description":"","verify_at":"2025-12-09 13:31:48","user":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","avatar":{"id":17,"user_id":1011,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b54747f4-248d-380e-93bc-0f62f769e70d.png"}}}],"erpPurchaseOrderStopVerifyRels":[{"id":9,"erp_purchase_order_id":2121,"user_id":1011,"status":1,"description":"","verify_at":"2025-12-09 14:03:48","user":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","avatar":{"id":17,"user_id":1011,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b54747f4-248d-380e-93bc-0f62f769e70d.png"}}}],"erpPurchaseOrderCancelVerifyRels":[]},"erpPurchaseCost":null,"purchaseContractContactPoints":[],"invoiced":"3516028","approve_amount":3516028,"un_approve_amount":0,"un_invoiced":0,"payment_collection_remind_ahead_display":"\u63d0\u524d1\u5929","contract_type_display":"\u4ea7\u54c1\u5408\u540c","collected":"3516028","un_collected":0,"collected_plan":3516028,"is_collected":true,"can_update":true,"can_update_cost":false,"can_update_file":true,"can_delete":true,"can_resubmit":false,"unread":0,"bgcolor":"#89c541","product_amount":3516028,"product_number":4,"is_done":true,"cost_done_display":false,"cost_un_done_display":false,"done_display":true,"contact_points_status_display":"\u672a\u8bbe\u7f6e","total_contact_paid_point":0,"total_contact_un_paid_point":0,"erp_all_un_settle_amount":0,"advance_purchase":false,"verifyList":[{"id":127,"erp_purchase_order_id":2121,"user_id":1011,"status":1,"description":"","verify_at":"2025-12-09 13:31:48","user":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","avatar":{"id":17,"user_id":1011,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b54747f4-248d-380e-93bc-0f62f769e70d.png"}}}]},{"id":4250,"supplier_id":511,"contract_type":3,"signed_at":"2025-11-20","amount":"13095","handler":1011,"description":"","contract_scan":null,"created_by":5360,"created_at":"2025-11-20 16:40:08","updated_at":"2025-11-21 09:16:30","client_id":null,"project_id":null,"sales_rep":null,"serial_no":"KJS1XS25209","payment_collection_remind_ahead":"1 day","including_tax":true,"is_save_collection":true,"save_collection_at":"2025-11-20 16:40:25","is_chargeback":false,"cost_type":1,"is_draft":false,"is_verify":false,"is_refuse":false,"erp_settle_amount":"13095","erp_un_settle_amount":"0","erp_payment_ticket_is_verify":false,"erp_collect_ticket_is_verify":null,"erp_cash_cost_ticket_is_verify":false,"erp_all_settle_amount":"13095","total_contact_point":null,"paid_contact_point":null,"is_edit_verify":false,"is_chargeback_verify":false,"un_paid_contact_point":null,"client":null,"project":null,"supplier":{"id":511,"key":511,"name":"\u5317\u4eac\u610f\u7545\u79d1\u6280\u80a1\u4efd\u6709\u9650\u516c\u53f8","account_number":"\u4e2d\u56fd\u5efa\u8bbe\u94f6\u884c\u80a1\u4efd\u6709\u9650\u516c\u53f8\u5317\u4eac\u8fdc\u5927\u652f\u884c11050163580000000226"},"contractScan":null,"createdBy":{"id":5360,"key":5360,"name":"\u5f20\u7ea2\u82b3","sex":"F","department_id":3,"avatar":{"id":153,"user_id":5360,"name":"\/files\/cdn\/a57be577deb434\/avatar\/612c2410-e800-3507-aa05-3f1fbeb408a7.png"},"department":{"id":3,"key":3,"name":"\u5546\u52a1\u90e8"}},"handlerPerson":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","avatar":{"id":17,"user_id":1011,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b54747f4-248d-380e-93bc-0f62f769e70d.png"}},"commentCount":{"object_id":4250,"comment":2},"purchaseClientRels":[{"id":4384,"contract_id":4250,"client_id":3301,"project_id":3991,"client":{"id":3301,"key":3301,"name":"\u91d1\u878d\u65f6\u62a5\u793e","sales_rep":1001,"clickable":1},"project":{"id":3991,"key":3991,"name":"AC-1000 D600\u8bbe\u5907\u7ef4\u4fdd","project_status":3,"budget":"13500","buildContract":{"id":4248,"from_project":3991,"serial_no":"Jrsbht2025126"},"clickable":1}}],"purchaseContractPayments":[{"id":"12229","key":"12229","contract_id":4250,"amount":"13095","value":"13095","collected_date":"2025-12-05 00:00:00","created_at":"2025-12-05 09:26:33","created_by":5388,"description":"\u7f51\u94f6\u6c47\u6b3e \u610f\u7545\u79d1\u6280","createdBy":{"id":5388,"key":5388,"name":"\u6768\u71d5\u971e","sex":"F","department_id":6},"pct":100}],"purchaseContractInvoices":[{"id":2550,"key":2550,"contract_id":4250,"amount":"13095","value":"13095","attachment_id":null,"from_date":"2025-11-20","description":"","is_draft":false,"is_cancel":false,"purchaseInvoiceAmounts":[{"id":2209,"purchase_invoice_id":2550,"amount":"13095","tax_rate":"6"}],"attachment":null,"attachmentRelationships":[],"files":[{"id":52802,"object_type":103,"object_id":2550,"attachment_id":29897,"attachment":{"id":29897,"key":29897,"name":"10cccec6-7a55-3ebb-ae4e-198b744e964e","extension":"pdf","path":"\/v2\/attachment\/view\/lLLCHpZSQkMu0_ceemp9PVo8_3HEKkFC\/10cccec6-7a55-3ebb-ae4e-198b744e964e\/dzfp_25112000000256119515_\u5317\u4eac\u610f\u7545\u79d1\u6280\u80a1\u4efd\u6709\u9650\u516c\u53f8_20251120160607.pdf","orig_name":"dzfp_25112000000256119515_\u5317\u4eac\u610f\u7545\u79d1\u6280\u80a1\u4efd\u6709\u9650\u516c\u53f8_20251120160607.pdf"}}]}],"contractScans":[{"id":52817,"object_type":108,"object_id":4250,"attachment_id":29905,"attachment":{"id":29905,"key":29905,"name":"e0cb700b-9cf6-3d34-9a29-d863aff16d41","extension":"pdf","path":"\/v2\/attachment\/preview\/lLLCHpZSQkMu0_ceemp9PVo8_3HEKkFC\/e0cb700b-9cf6-3d34-9a29-d863aff16d41\/2025_11_21_09_15_02.pdf","orig_name":"2025_11_21_09_15_02.pdf"}}],"receiptScans":[],"purchaseContractPaymentCollectionRemindReceivers":[{"id":1656,"user_id":1011,"key":1011,"contract_id":4250,"user":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","avatar":{"id":17,"user_id":1011,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b54747f4-248d-380e-93bc-0f62f769e70d.png"}}},{"id":1657,"user_id":5360,"key":5360,"contract_id":4250,"user":{"id":5360,"key":5360,"name":"\u5f20\u7ea2\u82b3","sex":"F","avatar":{"id":153,"user_id":5360,"name":"\/files\/cdn\/a57be577deb434\/avatar\/612c2410-e800-3507-aa05-3f1fbeb408a7.png"}}}],"purchaseContractPaymentCollectionRemindDates":[{"id":975,"key":975,"contract_id":4250,"name":"2025-12-20","value":"13095","overdue_days":null,"status":1,"remind_date":"2025-12-20","pct":100,"overdue_display":""}],"paymentApproves":[{"id":2473,"client_id":3301,"project_id":3991,"title":"\u4ed8\u6b3e\u7533\u8bf7\u2014\u5317\u4eac\u610f\u7545\u79d1\u6280\u80a1\u4efd\u6709\u9650\u516c\u53f8","status":2,"next_verify_user":null,"verify_at":"2025-12-04 20:16:29","description":"\u8001\u5927\uff0c\u82b3\u59d0\uff1a\u7533\u8bf7\u652f\u4ed8\u91d1\u878d\u65f6\u62a5\u793e\u2014\u6df1\u4fe1\u670d\u7ef4\u4fdd\u91c7\u8d2d\u6b3e\uff0c\u91d1\u989d13095\u5143\uff0c\u8bf7\u5ba1\u6279\uff01\n\n\u5907\u6ce8\uff1a\u7eb8\u8d28\u5355\u636e\u5df2\u63d0\u4ea4","refuse_description":null,"is_resubmited":false,"created_by":5360,"created_at":"2025-12-04 17:16:48","updated_at":"2025-12-04 20:16:29","supplier_id":511,"purchase_contract_id":4250,"amount":"13095","borrow_amount":null,"borrow_collect_day":null,"borrow_collect_status":1,"borrow_collect_description":null,"borrow_collect_at":null,"erp_payment_settle_amount":"13095","erp_payment_un_settle_amount":"0","erp_borrow_settle_amount":"0","erp_borrow_un_settle_amount":"0","next_cancel_verify_user":null,"cancel_at":null,"cancel_description":null,"erp_payment_all_settle_amount":"13095"}],"costContractAmounts":[],"unreadComments":null,"purchaseContractProductRels":[{"id":232,"purchase_contract_id":4250,"erp_store_id":null,"erp_purchase_order_product_id":193,"product_id":734,"description":"","number":"1","amount":"13095","total_amount":"13095.00","erpStore":null,"product":{"id":734,"name":"\u6df1\u4fe1\u670d AC-1000 \u7eed\u4fdd\u670d\u52a1","product_type":22,"product_component":200,"product_brand":12,"product_serie":1020,"product_misc":5,"product_qa":null,"pn":"","description":"","created_by":1013,"created_at":"2020-10-13 11:12:39","updated_at":"2025-11-21 15:46:18","pinyin_shortcut":"sxfAC1000xbfw","product_unit":8,"is_renew":false,"in_out_at":"2025-11-21 15:46:18.087915+08","productType":{"id":22,"key":22,"name":"\u670d\u52a1"},"productComponent":{"id":200,"key":200,"name":"\u7eed\u4fdd\u670d\u52a1"},"productBrand":{"id":12,"key":12,"name":"\u6df1\u4fe1\u670d"},"productSerie":{"id":1020,"key":1020,"name":"\u6df1\u4fe1\u670d AC-1000 \u7eed\u4fdd\u670d\u52a1"},"productUnit":{"id":8,"key":8,"name":"\u5e74"}},"erpPurchaseOrderProduct":{"id":193,"erp_purchase_order_id":2099,"erp_store_id":null,"product_id":734,"description":"","number":"1","into_inventory":"1","amount":"13095","total_amount":"13095.00","last_number":"1","last_amount":"13095","last_total_amount":"13095.00"}}],"erpPurchaseOrder":{"id":2099,"serial_no":"CGDD-20251120-00001","from_date":null,"wrote_date":"2025-11-20","handler":1011,"supplier_id":511,"purchase_contract_id":4250,"erp_store_id":null,"status":2,"abstract":null,"description":"","verify_type":2,"next_verify_user":null,"next_stop_verify_user":null,"next_cancel_verify_user":null,"verify_at":"2025-11-20 16:40:39","stop_at":"2025-11-21 09:16:32.208577+08","cancel_at":null,"refuse_description":null,"is_resubmitted":false,"is_used":true,"is_done":false,"is_settle":false,"number":"1","amount":"13095","created_by":5360,"stop_description":null,"inventory_status":true,"is_cancel":false,"is_old":false,"created_at":"2025-11-20 16:40:09","updated_at":"2025-11-21 09:22:15","print_times":null,"erpPurchaseOrderVerifyRels":[{"id":105,"erp_purchase_order_id":2099,"user_id":1011,"status":1,"description":"","verify_at":"2025-11-20 16:40:39","user":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","avatar":{"id":17,"user_id":1011,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b54747f4-248d-380e-93bc-0f62f769e70d.png"}}}],"erpPurchaseOrderStopVerifyRels":[{"id":7,"erp_purchase_order_id":2099,"user_id":1011,"status":1,"description":"","verify_at":"2025-11-21 09:22:15","user":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","avatar":{"id":17,"user_id":1011,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b54747f4-248d-380e-93bc-0f62f769e70d.png"}}}],"erpPurchaseOrderCancelVerifyRels":[]},"erpPurchaseCost":null,"purchaseContractContactPoints":[],"invoiced":"13095","approve_amount":13095,"un_approve_amount":0,"un_invoiced":0,"payment_collection_remind_ahead_display":"\u63d0\u524d1\u5929","contract_type_display":"\u670d\u52a1\u5408\u540c","collected":"13095","un_collected":0,"collected_plan":13095,"is_collected":true,"can_update":true,"can_update_cost":false,"can_update_file":true,"can_delete":true,"can_resubmit":false,"unread":0,"bgcolor":"#89c541","product_amount":13095,"product_number":1,"is_done":true,"cost_done_display":false,"cost_un_done_display":false,"done_display":true,"contact_points_status_display":"\u672a\u8bbe\u7f6e","total_contact_paid_point":0,"total_contact_un_paid_point":0,"erp_all_un_settle_amount":0,"advance_purchase":false,"verifyList":[{"id":105,"erp_purchase_order_id":2099,"user_id":1011,"status":1,"description":"","verify_at":"2025-11-20 16:40:39","user":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","avatar":{"id":17,"user_id":1011,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b54747f4-248d-380e-93bc-0f62f769e70d.png"}}}]},{"id":4240,"supplier_id":90,"contract_type":3,"signed_at":"2025-11-07","amount":"143704","handler":1011,"description":"","contract_scan":null,"created_by":5360,"created_at":"2025-11-10 15:48:20","updated_at":"2025-11-10 15:48:37","client_id":null,"project_id":null,"sales_rep":null,"serial_no":"X_2025SBQ32400","payment_collection_remind_ahead":"1 day","including_tax":true,"is_save_collection":true,"save_collection_at":"2025-11-10 15:48:37","is_chargeback":false,"cost_type":1,"is_draft":false,"is_verify":false,"is_refuse":false,"erp_settle_amount":"143704","erp_un_settle_amount":"0","erp_payment_ticket_is_verify":false,"erp_collect_ticket_is_verify":null,"erp_cash_cost_ticket_is_verify":false,"erp_all_settle_amount":"143704","total_contact_point":null,"paid_contact_point":null,"is_edit_verify":false,"is_chargeback_verify":false,"un_paid_contact_point":null,"client":null,"project":null,"supplier":{"id":90,"key":90,"name":"\u7d2b\u5149\u6653\u901a\u79d1\u6280\u6709\u9650\u516c\u53f8","account_number":""},"contractScan":null,"createdBy":{"id":5360,"key":5360,"name":"\u5f20\u7ea2\u82b3","sex":"F","department_id":3,"avatar":{"id":153,"user_id":5360,"name":"\/files\/cdn\/a57be577deb434\/avatar\/612c2410-e800-3507-aa05-3f1fbeb408a7.png"},"department":{"id":3,"key":3,"name":"\u5546\u52a1\u90e8"}},"handlerPerson":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","avatar":{"id":17,"user_id":1011,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b54747f4-248d-380e-93bc-0f62f769e70d.png"}},"commentCount":{"object_id":4240,"comment":4},"purchaseClientRels":[{"id":4066,"contract_id":4240,"client_id":3286,"project_id":4014,"client":{"id":3286,"key":3286,"name":"\u826f\u56fe\u79d1\u6280(\u4e0a\u6d77)\u6709\u9650\u516c\u53f8","sales_rep":1001,"clickable":1},"project":{"id":4014,"key":4014,"name":"\uff08\u897f\u4e91\u6570\u636e\uff09PA VM\u8f6f\u4ef6\u4ea7\u54c1\u7eed\u4fdd\u9879\u76ee","project_status":3,"budget":"183179.99","buildContract":{"id":4235,"from_project":4014,"serial_no":"PO2501256"},"clickable":1}}],"purchaseContractPayments":[{"id":"12278","key":"12278","contract_id":4240,"amount":"143704","value":"143704","collected_date":"2025-12-30 00:00:00","created_at":"2025-12-30 11:56:03","created_by":5388,"description":"\u7f51\u94f6\u6c47\u6b3e \u7d2b\u5149\u6653\u901a","createdBy":{"id":5388,"key":5388,"name":"\u6768\u71d5\u971e","sex":"F","department_id":6},"pct":100}],"purchaseContractInvoices":[{"id":2544,"key":2544,"contract_id":4240,"amount":"143704","value":"143704","attachment_id":null,"from_date":"2025-11-14","description":"","is_draft":false,"is_cancel":false,"purchaseInvoiceAmounts":[{"id":2199,"purchase_invoice_id":2544,"amount":"143704","tax_rate":"13"}],"attachment":null,"attachmentRelationships":[],"files":[{"id":52631,"object_type":103,"object_id":2544,"attachment_id":29786,"attachment":{"id":29786,"key":29786,"name":"b154e225-1dd1-340c-b992-17bcd2f23fcf","extension":"pdf","path":"\/v2\/attachment\/view\/lLLCHpZSQkMu0_ceemp9PVo8_3HEKkFC\/b154e225-1dd1-340c-b992-17bcd2f23fcf\/91120118MA06G1T23F_25111411120845827942.pdf","orig_name":"91120118MA06G1T23F_25111411120845827942.pdf"}}]}],"contractScans":[{"id":52469,"object_type":108,"object_id":4240,"attachment_id":29664,"attachment":{"id":29664,"key":29664,"name":"0714e9ee-c25f-3b13-93ab-79b6e032cd79","extension":"pdf","path":"\/v2\/attachment\/preview\/lLLCHpZSQkMu0_ceemp9PVo8_3HEKkFC\/0714e9ee-c25f-3b13-93ab-79b6e032cd79\/document.pdf","orig_name":"document.pdf"}}],"receiptScans":[],"purchaseContractPaymentCollectionRemindReceivers":[{"id":1644,"user_id":1011,"key":1011,"contract_id":4240,"user":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","avatar":{"id":17,"user_id":1011,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b54747f4-248d-380e-93bc-0f62f769e70d.png"}}},{"id":1645,"user_id":5360,"key":5360,"contract_id":4240,"user":{"id":5360,"key":5360,"name":"\u5f20\u7ea2\u82b3","sex":"F","avatar":{"id":153,"user_id":5360,"name":"\/files\/cdn\/a57be577deb434\/avatar\/612c2410-e800-3507-aa05-3f1fbeb408a7.png"}}}],"purchaseContractPaymentCollectionRemindDates":[{"id":968,"key":968,"contract_id":4240,"name":"2025-12-30","value":"143704","overdue_days":0,"status":1,"remind_date":"2025-12-30","pct":100,"overdue_display":"\u903e\u671f0\u5929"}],"paymentApproves":[{"id":2571,"client_id":3286,"project_id":4014,"title":"\u4ed8\u6b3e\u7533\u8bf7\u2014\u7d2b\u5149\u6653\u901a\u79d1\u6280\u6709\u9650\u516c\u53f8","status":2,"next_verify_user":null,"verify_at":"2025-12-30 11:37:49","description":"\u8001\u5927\uff0c\u82b3\u59d0\uff1a\u826f\u56fe\u2014\uff08\u897f\u4e91\u6570\u636e\uff09PA\u4ea7\u54c1\u91c7\u8d2d\u8d27\u6b3e\uff0c\u91d1\u989d143704\u5143\uff0c\u4e0e\u603b\u4ee3\u8d26\u671f\u5df2\u5230\uff0c\u7533\u8bf7\u652f\u4ed8\uff0c\u8bf7\u5ba1\u6279\uff01\n\n\u5907\u6ce8\uff1a\u5df2\u5165\u5e93\uff0c\u5df2\u4ea4\u4ed8\uff0c\u7eb8\u8d28\u5355\u636e\u5df2\u63d0\u4ea4\u5ba1\u6838","refuse_description":null,"is_resubmited":false,"created_by":5360,"created_at":"2025-12-30 10:31:11","updated_at":"2025-12-30 11:37:49","supplier_id":90,"purchase_contract_id":4240,"amount":"143704","borrow_amount":null,"borrow_collect_day":null,"borrow_collect_status":1,"borrow_collect_description":null,"borrow_collect_at":null,"erp_payment_settle_amount":"143704","erp_payment_un_settle_amount":"0","erp_borrow_settle_amount":"0","erp_borrow_un_settle_amount":"0","next_cancel_verify_user":null,"cancel_at":null,"cancel_description":null,"erp_payment_all_settle_amount":"143704"}],"costContractAmounts":[],"unreadComments":null,"purchaseContractProductRels":[{"id":223,"purchase_contract_id":4240,"erp_store_id":null,"erp_purchase_order_product_id":185,"product_id":1624,"description":"","number":"142","amount":"1012","total_amount":"143704.00","erpStore":null,"product":{"id":1624,"name":"PAN-SOFTWARE-NGFW-CR","product_type":5,"product_component":36,"product_brand":8,"product_serie":1382,"product_misc":null,"product_qa":null,"pn":"","description":"","created_by":1013,"created_at":"2024-05-28 17:27:39","updated_at":"2025-12-12 10:32:22","pinyin_shortcut":"PANSOFTWARENGFWCR","product_unit":2,"is_renew":false,"in_out_at":"2025-12-12 10:32:22.251174+08","productType":{"id":5,"key":5,"name":"\u5b89\u5168\u8bbe\u5907"},"productComponent":{"id":36,"key":36,"name":"PA\u8bb8\u53ef\u8bc1"},"productBrand":{"id":8,"key":8,"name":"PaloAlto"},"productSerie":{"id":1382,"key":1382,"name":"PA\u865a\u62df\u9632\u706b\u5899\u8f6f\u4ef6\u6388\u6743"},"productUnit":{"id":2,"key":2,"name":"\u5957"}},"erpPurchaseOrderProduct":{"id":185,"erp_purchase_order_id":2094,"erp_store_id":null,"product_id":1624,"description":"","number":"142","into_inventory":"142","amount":"1012","total_amount":"143704.00","last_number":null,"last_amount":null,"last_total_amount":null}}],"erpPurchaseOrder":{"id":2094,"serial_no":"CGDD-20251110-00001","from_date":null,"wrote_date":"2025-11-07","handler":1011,"supplier_id":90,"purchase_contract_id":4240,"erp_store_id":null,"status":2,"abstract":null,"description":"","verify_type":2,"next_verify_user":null,"next_stop_verify_user":null,"next_cancel_verify_user":null,"verify_at":"2025-11-10 15:49:22","stop_at":null,"cancel_at":null,"refuse_description":null,"is_resubmitted":false,"is_used":true,"is_done":false,"is_settle":false,"number":"142","amount":"143704","created_by":5360,"stop_description":null,"inventory_status":true,"is_cancel":false,"is_old":false,"created_at":"2025-11-10 15:48:21","updated_at":"2025-11-10 15:49:22","print_times":null,"erpPurchaseOrderVerifyRels":[{"id":100,"erp_purchase_order_id":2094,"user_id":1011,"status":1,"description":"","verify_at":"2025-11-10 15:49:22","user":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","avatar":{"id":17,"user_id":1011,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b54747f4-248d-380e-93bc-0f62f769e70d.png"}}}],"erpPurchaseOrderStopVerifyRels":[],"erpPurchaseOrderCancelVerifyRels":[]},"erpPurchaseCost":null,"purchaseContractContactPoints":[],"invoiced":"143704","approve_amount":143704,"un_approve_amount":0,"un_invoiced":0,"payment_collection_remind_ahead_display":"\u63d0\u524d1\u5929","contract_type_display":"\u670d\u52a1\u5408\u540c","collected":"143704","un_collected":0,"collected_plan":143704,"is_collected":true,"can_update":true,"can_update_cost":false,"can_update_file":true,"can_delete":true,"can_resubmit":false,"unread":0,"bgcolor":"#89c541","product_amount":143704,"product_number":142,"is_done":true,"cost_done_display":false,"cost_un_done_display":false,"done_display":true,"contact_points_status_display":"\u672a\u8bbe\u7f6e","total_contact_paid_point":0,"total_contact_un_paid_point":0,"erp_all_un_settle_amount":0,"advance_purchase":false,"verifyList":[{"id":100,"erp_purchase_order_id":2094,"user_id":1011,"status":1,"description":"","verify_at":"2025-11-10 15:49:22","user":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","avatar":{"id":17,"user_id":1011,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b54747f4-248d-380e-93bc-0f62f769e70d.png"}}}]}],"pagenation":{"totalcount":107,"thispage":1,"pagesize":10}},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}],"ip":"223.74.191.180","ua":"jinchangxiao\/1.0.43 (HUAWEI Mate 60 Pro ALN-AL00; HarmonyOS 6.1.0)"}', FALSE, '2026-07-12 23:35:28', 213179136) RETURNING "id"
23:35:27.930	4.5 ms	yii\db\Command::query	SELECT COUNT() FROM (SELECT c., c.total_contact_point - c.paid_contact_point as un_paid_contact_point FROM "a57be577deb434"."tbl_purchase_contracts" "c" LEFT JOIN "a57be577deb434"."tbl_suppliers" "supplier" ON supplier.id = c.supplier_id LEFT JOIN "a57be577deb434"."tbl_purchase_client_rels" "pcr" ON pcr.contract_id = c.id LEFT JOIN "a57be577deb434"."tbl_clients" "client" ON pcr.client_id = client.id LEFT JOIN "a57be577deb434"."tbl_sales_group_relationships" "sgr" ON sgr.sales_id = client.sales_rep LEFT JOIN (SELECT "contract_id", sum(amount) as collected_plan FROM "a57be577deb434"."tbl_purchase_contract_payment_collection_remind_dates" GROUP BY "contract_id") "pcpcrd" ON pcpcrd.contract_id = c.id WHERE ("c"."cost_type" IN (1, 2)) AND ("client"."sales_rep"='1001') AND ("client"."sales_rep"='1001') AND (("client"."sales_rep" IN (1001, 5049, 5500, 5301, 5499, 5022, 5209, 5026, 5293, 5309, 5356, 5329, 5299, 5303, 5302, 5332, 5047, 1026, 5096, 5070, 5448, 5420, 1029, 5037, 5087, 1008, 5048, 5043, 5045, 5230, 5031, 5088, 5208, 1003, 5467, 5294, 5357, 5044, 1030, 5076, 5300, 5027, 5089, 5311, 5066, 5069, 5364, 1009, 5295, 1013, 5128, 5203, 1025, 5032, 5075, 5476, 1004, 5072, 5033, 5359, 5412, 5409, 5229, 1005, 5304, 5449, 5358, 1006, 5093)) OR ("client"."sales_rep" IS NULL) OR ("client"."id" IN (SELECT "client_id" FROM "a57be577deb434"."tbl_user_visit_clients" WHERE "user_id"=1001)) OR ("pcr"."id" IS NULL)) GROUP BY "c"."id" ORDER BY "c"."signed_at" DESC, "c"."created_at" DESC) "c"
23:35:27.988	3.8 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "contract_id", "amount", "amount" AS "value", "collected_date", "created_at", "created_by", "description" FROM (SELECT * FROM ((SELECT '1' \|\| r.id::varchar as id, 1 as ticket_type, r.purchase_contract_id as contract_id, r.amount as amount, t.wrote_date as collected_date, t.created_at, t.created_by, t.abstract as description FROM "a57be577deb434"."tbl_erp_payment_ticket_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_payment_tickets" "t" ON r.erp_payment_ticket_id = t.id WHERE ("t"."is_payment_settle"=TRUE) AND ("t"."status" IN (2, 5))) UNION ALL ( SELECT '2' \|\| r.id::varchar as id, 2 as ticket_type, r.purchase_contract_id as contract_id, r.amount as amount, t.created_at::timestamp without time zone as collected_date, t.created_at, t.created_by, t.abstract as description FROM "a57be577deb434"."tbl_erp_other_income_ticket_purchase_contract_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_other_income_tickets" "t" ON r.erp_other_income_ticket_id = t.id WHERE "t"."status" IN (2, 5) ) UNION ALL ( SELECT '3' \|\| r.id::varchar as id, 3 as ticket_type, r.purchase_contract_id as contract_id, r.amount as amount, t.created_at::timestamp without time zone as collected_date, t.created_at, t.created_by, t.abstract as description FROM "a57be577deb434"."tbl_erp_cash_cost_ticket_purchase_contract_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_cash_cost_tickets" "t" ON r.erp_cash_cost_ticket_id = t.id WHERE ("t"."is_payment_settle"=TRUE) AND ("t"."status" IN (2, 5)) ) UNION ALL ( SELECT '4' \|\| r.id::varchar as id, 4 as ticket_type, r.purchase_contract_id as contract_id, 0 - r.amount as amount, t.created_at::timestamp without time zone as collected_date, t.created_at, t.created_by, t.abstract as description FROM "a57be577deb434"."tbl_erp_collect_ticket_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_collect_tickets" "t" ON r.erp_collect_ticket_id = t.id WHERE "t"."status" IN (2, 5) )) "sub") "r" WHERE "contract_id" IN (4475, 4463, 4447, 4376, 4374, 4350, 4293, 4295, 4250, 4240) ORDER BY "id" DESC
23:35:28.001	3.5 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=103) AND ("object_id" IN (2544, 2550, 2567, 2570, 2615, 2672, 2752))
23:35:28.010	3.4 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=111) AND ("object_id" IN (4475, 4463, 4447, 4376, 4374, 4350, 4293, 4295, 4250, 4240))
23:35:28.005	3.3 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=108) AND ("object_id" IN (4475, 4463, 4447, 4376, 4374, 4350, 4293, 4295, 4250, 4240))
23:35:27.996	3.3 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=21) AND ("object_id" IN (2544, 2550, 2567, 2570, 2615, 2672, 2752))
23:35:27.936	3.2 ms	yii\db\Command::query	SELECT c.*, c.total_contact_point - c.paid_contact_point as un_paid_contact_point FROM "a57be577deb434"."tbl_purchase_contracts" "c" LEFT JOIN "a57be577deb434"."tbl_suppliers" "supplier" ON supplier.id = c.supplier_id LEFT JOIN "a57be577deb434"."tbl_purchase_client_rels" "pcr" ON pcr.contract_id = c.id LEFT JOIN "a57be577deb434"."tbl_clients" "client" ON pcr.client_id = client.id LEFT JOIN "a57be577deb434"."tbl_sales_group_relationships" "sgr" ON sgr.sales_id = client.sales_rep LEFT JOIN (SELECT "contract_id", sum(amount) as collected_plan FROM "a57be577deb434"."tbl_purchase_contract_payment_collection_remind_dates" GROUP BY "contract_id") "pcpcrd" ON pcpcrd.contract_id = c.id WHERE ("c"."cost_type" IN (1, 2)) AND ("client"."sales_rep"='1001') AND ("client"."sales_rep"='1001') AND (("client"."sales_rep" IN (1001, 5049, 5500, 5301, 5499, 5022, 5209, 5026, 5293, 5309, 5356, 5329, 5299, 5303, 5302, 5332, 5047, 1026, 5096, 5070, 5448, 5420, 1029, 5037, 5087, 1008, 5048, 5043, 5045, 5230, 5031, 5088, 5208, 1003, 5467, 5294, 5357, 5044, 1030, 5076, 5300, 5027, 5089, 5311, 5066, 5069, 5364, 1009, 5295, 1013, 5128, 5203, 1025, 5032, 5075, 5476, 1004, 5072, 5033, 5359, 5412, 5409, 5229, 1005, 5304, 5449, 5358, 1006, 5093)) OR ("client"."sales_rep" IS NULL) OR ("client"."id" IN (SELECT "client_id" FROM "a57be577deb434"."tbl_user_visit_clients" WHERE "user_id"=1001)) OR ("pcr"."id" IS NULL)) GROUP BY "c"."id" ORDER BY "c"."signed_at" DESC, "c"."created_at" DESC LIMIT 10
23:35:28.017	2.8 ms	yii\db\Command::query	SELECT "r".* FROM "a57be577deb434"."tbl_approves" "r" LEFT JOIN "a57be577deb434"."tbl_term_taxonomy_relationships" "dt1" ON dt1.object_id = r.id AND dt1.term_id = 17 WHERE (dt1.taxonomy_id = 2100000000) AND ("r"."status"=2) AND ("r"."purchase_contract_id" IN (4475, 4463, 4447, 4376, 4374, 4350, 4293, 4295, 4250, 4240)) GROUP BY "r"."id"
23:35:28.055	2.3 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_erp_purchase_orders" WHERE "purchase_contract_id" IN (4475, 4463, 4447, 4376, 4374, 4350, 4293, 4295, 4250, 4240)
23:35:27.993	1.4 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "contract_id", "amount", "amount" AS "value", "attachment_id", "from_date", "description", "is_draft", "is_cancel" FROM "a57be577deb434"."tbl_purchase_contract_invoices" WHERE "contract_id" IN (4475, 4463, 4447, 4376, 4374, 4350, 4293, 4295, 4250, 4240) ORDER BY "id"
23:35:27.983	1.4 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_purchase_client_rels" WHERE "contract_id" IN (4475, 4463, 4447, 4376, 4374, 4350, 4293, 4295, 4250, 4240) ORDER BY "id"
23:35:28.074	1.3 ms	yii\db\Command::query	SELECT SUM(amount) FROM "a57be577deb434"."tbl_purchase_contract_invoices" WHERE ("contract_id"=4475) AND ((red_invoice_id is not null) OR ("is_cancel"=FALSE))
23:35:28.076	1.3 ms	yii\db\Command::query	SELECT SUM(amount) FROM "a57be577deb434"."tbl_purchase_contract_invoices" WHERE ("contract_id"=4463) AND ((red_invoice_id is not null) OR ("is_cancel"=FALSE))
23:35:28.054	1.2 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_erp_purchase_order_products" WHERE "id" IN (185, 193, 239, 247, 315, 337, 338, 339, 340, 341, 342, 343, 344, 345, 346, 347, 348, 349, 422, 433, 420, 421, 423)
23:35:28.066	1.2 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_erp_purchase_costs" WHERE "purchase_contract_id" IN (4475, 4463, 4447, 4376, 4374, 4350, 4293, 4295, 4250, 4240)
23:35:28.082	1.2 ms	yii\db\Command::query	SELECT SUM(amount) FROM "a57be577deb434"."tbl_purchase_contract_invoices" WHERE ("contract_id"=4350) AND ((red_invoice_id is not null) OR ("is_cancel"=FALSE))
23:35:27.995	1.2 ms	yii\db\Command::query	SELECT "id", "purchase_invoice_id", "amount", "tax_rate" FROM "a57be577deb434"."tbl_purchase_invoice_amounts" WHERE "purchase_invoice_id" IN (2544, 2550, 2567, 2570, 2615, 2672, 2752) ORDER BY "id"
23:35:28.077	1.1 ms	yii\db\Command::query	SELECT SUM(amount) FROM "a57be577deb434"."tbl_purchase_contract_invoices" WHERE ("contract_id"=4447) AND ((red_invoice_id is not null) OR ("is_cancel"=FALSE))
23:35:28.084	1.1 ms	yii\db\Command::query	SELECT SUM(amount) FROM "a57be577deb434"."tbl_purchase_contract_invoices" WHERE ("contract_id"=4293) AND ((red_invoice_id is not null) OR ("is_cancel"=FALSE))
23:35:28.081	1.1 ms	yii\db\Command::query	SELECT SUM(amount) FROM "a57be577deb434"."tbl_purchase_contract_invoices" WHERE ("contract_id"=4374) AND ((red_invoice_id is not null) OR ("is_cancel"=FALSE))
23:35:28.087	1.1 ms	yii\db\Command::query	SELECT SUM(amount) FROM "a57be577deb434"."tbl_purchase_contract_invoices" WHERE ("contract_id"=4250) AND ((red_invoice_id is not null) OR ("is_cancel"=FALSE))
23:35:28.048	1.1 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_products" WHERE "id" IN (1624, 734, 1148, 1757, 1650, 984, 1562, 1973, 994, 969, 1339, 989, 1340, 2233, 851, 2230, 2231, 2232, 1584, 2261, 2262, 1558)
23:35:28.046	1.1 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_purchase_contract_product_rels" WHERE "purchase_contract_id" IN (4475, 4463, 4447, 4376, 4374, 4350, 4293, 4295, 4250, 4240)
23:35:28.079	1.1 ms	yii\db\Command::query	SELECT SUM(amount) FROM "a57be577deb434"."tbl_purchase_contract_invoices" WHERE ("contract_id"=4376) AND ((red_invoice_id is not null) OR ("is_cancel"=FALSE))
23:35:28.085	1.1 ms	yii\db\Command::query	SELECT SUM(amount) FROM "a57be577deb434"."tbl_purchase_contract_invoices" WHERE ("contract_id"=4295) AND ((red_invoice_id is not null) OR ("is_cancel"=FALSE))
23:35:28.088	1.1 ms	yii\db\Command::query	SELECT SUM(amount) FROM "a57be577deb434"."tbl_purchase_contract_invoices" WHERE ("contract_id"=4240) AND ((red_invoice_id is not null) OR ("is_cancel"=FALSE))
23:35:27.887	1.0 ms	yii\db\Command::query	SELECT * FROM "global"."vw_user_login" WHERE "access_token"='lLLCHpZSQkMu0_ceemp9PVo8_3HEKkFC'
23:35:28.058	0.9 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_erp_purchase_order_verify_rels" WHERE "erp_purchase_order_id" IN (2213, 2119, 2121, 2204, 2164, 2165, 2149, 2099, 2094) ORDER BY "id"
23:35:28.014	0.8 ms	yii\db\Command::query	SELECT "id", "user_id", "user_id" AS "key", "contract_id" FROM "a57be577deb434"."tbl_purchase_contract_payment_collection_remind_receivers" WHERE "contract_id" IN (4475, 4463, 4447, 4376, 4374, 4350, 4293, 4295, 4250, 4240)
23:35:28.016	0.8 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "contract_id", "remind_date" AS "name", "amount" AS "value", "overdue_days", "status", "remind_date" FROM "a57be577deb434"."tbl_purchase_contract_payment_collection_remind_dates" WHERE "contract_id" IN (4475, 4463, 4447, 4376, 4374, 4350, 4293, 4295, 4250, 4240) ORDER BY "remind_date"
23:35:28.021	0.8 ms	yii\db\Command::query	SELECT "pt".*, "taxonomy_id" AS "key", "tt"."name" AS "name", "out_amount" AS "amount", "value" AS "description", "extra_int" AS "parent_id", "tt"."serial_no" FROM "a57be577deb434"."tbl_term_taxonomy_relationships" "pt" LEFT JOIN "a57be577deb434"."tbl_term_taxonomies" "tt" ON taxonomy_id = tt.id WHERE ("pt"."term_id"=18) AND ("pt"."object_type"=8) AND ("pt"."object_id" IN (4475, 4463, 4447, 4376, 4374, 4350, 4293, 4295, 4250, 4240)) ORDER BY "id"
23:35:27.943	0.8 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "name", "account_number" FROM "a57be577deb434"."tbl_suppliers" WHERE "id" IN (431, 307, 46, 756, 163, 511, 90)
23:35:28.064	0.7 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_erp_purchase_order_cancel_verify_rels" WHERE "erp_purchase_order_id" IN (2213, 2119, 2121, 2204, 2164, 2165, 2149, 2099, 2094) ORDER BY "id"
23:35:28.061	0.7 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_erp_purchase_order_stop_verify_rels" WHERE "erp_purchase_order_id" IN (2213, 2119, 2121, 2204, 2164, 2165, 2149, 2099, 2094) ORDER BY "id"
23:35:28.068	0.7 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_erp_purchase_cost_verify_rels" WHERE "erp_purchase_cost_id"=49 ORDER BY "id"
23:35:27.890	0.6 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
23:35:28.069	0.6 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_erp_purchase_cost_stop_verify_rels" WHERE "erp_purchase_cost_id"=49 ORDER BY "id"
23:35:27.986	0.6 ms	yii\db\Command::query	SELECT "id", "from_project", "serial_no" FROM "a57be577deb434"."tbl_sales_contracts" WHERE "from_project" IN (3991, 4014, 4057, 4063, 4086, 4096, 4142, 4098, 4166, 4167)
23:35:28.070	0.6 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_purchase_contract_contact_points" WHERE "purchase_contract_id" IN (4475, 4463, 4447, 4376, 4374, 4350, 4293, 4295, 4250, 4240)
23:35:28.052	0.6 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_series" WHERE "id" IN (1486, 1382, 1020, 103, 1012, 1404, 612, 1759, 1760, 1004, 1011, 1769, 1781, 1358, 1344, 1244, 1758, 607, 802, 615, 803)
23:35:28.073	0.6 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_purchase_contract_contact_point_rels" WHERE ("contact_id", "purchase_contract_id") IN ((6253, 4447))
23:35:27.984	0.5 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "name", "sales_rep" FROM "a57be577deb434"."tbl_clients" WHERE "id" IN (3286, 3301, 3429, 3427, 2553, 982, 3377)
23:35:28.004	0.5 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "name", "extension", "path", "orig_name" FROM "a57be577deb434"."tbl_attachments" WHERE "id" IN (29786, 29897, 30242, 30282, 30874, 31666)
23:35:27.985	0.5 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "project_title" AS "name", "project_status", "budget" FROM "a57be577deb434"."tbl_projects" WHERE "id" IN (4014, 4086, 4063, 4057, 3991, 4096, 4142, 4166, 4167, 4098)
23:35:28.060	0.5 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "name", "sex" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (1011, 1001)
23:35:27.944	0.5 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (5250, 1001, 1011, 5360)
23:35:27.992	0.5 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (1001, 5250, 5252, 5388)
23:35:28.060	0.4 ms	yii\db\Command::query	SELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id" IN (1011, 1001))
23:35:28.065	0.4 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "name", "sex" FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
23:35:28.009	0.4 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "name", "extension", "path", "orig_name" FROM "a57be577deb434"."tbl_attachments" WHERE "id" IN (29664, 29905, 30262, 30281, 30964, 31325, 32534)
23:35:28.071	0.4 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "name", "client_id", "supplier_id" FROM "a57be577deb434"."tbl_contacts" WHERE "id"=6253
23:35:28.062	0.4 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "name", "sex" FROM "a57be577deb434"."tbl_users" WHERE "id"=1011
23:35:27.886	0.4 ms	yii\db\Connection::open	Opening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta
23:35:28.063	0.4 ms	yii\db\Command::query	SELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=1011)
23:35:27.945	0.4 ms	yii\db\Command::query	SELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id" IN (5250, 5360, 1011, 1001))
23:35:28.000	0.4 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "name", "extension", "path", "orig_name" FROM "a57be577deb434"."tbl_attachments" WHERE "id"=32668
23:35:28.050	0.4 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_types" WHERE "id" IN (7, 5, 22, 4)
23:35:28.051	0.4 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_components" WHERE "id" IN (64, 36, 200, 35, 157, 188, 43, 214, 52, 26)
23:35:28.072	0.4 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_clients" WHERE "id"=3372
23:35:28.016	0.4 ms	yii\db\Command::query	SELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id" IN (5360, 1011))
23:35:28.065	0.4 ms	yii\db\Command::query	SELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=1001)
23:35:27.947	0.4 ms	yii\db\Command::query	SELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=1011)
23:35:27.946	0.4 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "name", "sex" FROM "a57be577deb434"."tbl_users" WHERE "id"=1011
23:35:28.052	0.4 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_brands" WHERE "id" IN (230, 8, 12, 4)
23:35:27.946	0.4 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_departments" WHERE "id" IN (10, 3, 4)
23:35:28.015	0.4 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "name", "sex" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (1011, 5360)
23:35:28.013	0.3 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "name", "extension", "path", "orig_name" FROM "a57be577deb434"."tbl_attachments" WHERE "id" IN (30354, 31870)
23:35:28.023	0.3 ms	yii\db\Command::query	SELECT "id", "name", "parent_id" FROM "a57be577deb434"."tbl_term_taxonomies" WHERE "id"=386
23:35:28.053	0.3 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_units" WHERE "id" IN (2, 8, 3, 1)
23:35:28.023	0.3 ms	yii\db\Command::query	SELECT "id", "name", "parent_id" FROM "a57be577deb434"."tbl_term_taxonomies" WHERE "id"=385