Database Queries

总计58条数据
TimeDurationTypeQuery
  
22:21:09.1713.2 msSELECTSELECT * FROM "global"."vw_user_login" WHERE "id"=1001

22:21:09.1762.2 msSELECTSELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001

22:21:09.1818.2 msSELECTSELECT 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;

22:21:09.1897.9 msSELECTselect 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

22:21:09.2119.9 msSELECTSELECT COUNT(*) FROM (SELECT c.* 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 "a57be577deb434"."tbl_attachement_relationships" "cs" ON cs.object_id = c.id AND cs.object_type = 108 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"=1) AND ("sgr"."group_id"='1') AND ("client"."sales_rep"='1001') AND ("client"."sales_rep"='1001') AND (("client"."sales_rep" IN (1001, 5049, 5301, 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, 5294, 5357, 5044, 1030, 5076, 5300, 5027, 5089, 5311, 5066, 5069, 5364, 1009, 5295, 1013, 5128, 5203, 1025, 5032, 5075, 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"

22:21:09.22111.5 msSELECTSELECT c.* 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 "a57be577deb434"."tbl_attachement_relationships" "cs" ON cs.object_id = c.id AND cs.object_type = 108 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"=1) AND ("sgr"."group_id"='1') AND ("client"."sales_rep"='1001') AND ("client"."sales_rep"='1001') AND (("client"."sales_rep" IN (1001, 5049, 5301, 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, 5294, 5357, 5044, 1030, 5076, 5300, 5027, 5089, 5311, 5066, 5069, 5364, 1009, 5295, 1013, 5128, 5203, 1025, 5032, 5075, 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 20

22:21:09.2563.3 msSELECTSELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_suppliers" WHERE "id" IN (431, 478, 262, 489, 90, 723, 123, 608, 721, 38, 676, 718, 717)

22:21:09.2600.4 msSELECTSELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (1001, 1011, 5360)

22:21:09.2620.8 msSELECTSELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id" IN (1011, 1001, 5360))

22:21:09.2630.5 msSELECTSELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_departments" WHERE "id" IN (3, 4)

22:21:09.2630.3 msSELECTSELECT "id", "id" AS "key", "name", "sex" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (1011, 1013, 5360)

22:21:09.2640.2 msSELECTSELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id" IN (1011, 1013, 5360))

22:21:09.26633.5 msSELECTSELECT "object_id", count(*) as comment FROM "a57be577deb434"."tbl_comments" WHERE ("object_type"=13) AND ("object_id" IN (4141, 4133, 4127, 4126, 4123, 4122, 4115, 4110, 4103, 4102, 4101, 4098, 4088, 4085, 4090, 4081, 4077, 4076, 4075, 4070)) GROUP BY "object_id"

22:21:09.3001.0 msSELECTSELECT * FROM "a57be577deb434"."tbl_purchase_client_rels" WHERE "contract_id" IN (4141, 4133, 4127, 4126, 4123, 4122, 4115, 4110, 4103, 4102, 4101, 4098, 4088, 4085, 4090, 4081, 4077, 4076, 4075, 4070) ORDER BY "id"

22:21:09.3010.5 msSELECTSELECT "id", "id" AS "key", "name", "sales_rep" FROM "a57be577deb434"."tbl_clients" WHERE "id" IN (2762, 2136, 2553, 2845, 1492, 3286, 3278, 1661)

22:21:09.3020.8 msSELECTSELECT "id", "id" AS "key", "project_title" AS "name", "project_status" FROM "a57be577deb434"."tbl_projects" WHERE "id" IN (3910, 3922, 3751, 3949, 3951, 3858, 3927, 3577, 1791)

22:21:09.3036.4 msSELECTSELECT "id", "id" AS "key", "contract_id", "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.created_at::timestamp without time zone 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"."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 (4141, 4133, 4127, 4126, 4123, 4122, 4115, 4110, 4103, 4102, 4101, 4098, 4088, 4085, 4090, 4081, 4077, 4076, 4075, 4070) ORDER BY "id" DESC

22:21:09.3100.3 msSELECTSELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (1001, 1013, 5388)

22:21:09.3101.9 msSELECTSELECT "id", "id" AS "key", "contract_id", "amount", "amount" AS "value", "attachment_id", "from_date", "description", "is_draft" FROM "a57be577deb434"."tbl_purchase_contract_invoices" WHERE "contract_id" IN (4141, 4133, 4127, 4126, 4123, 4122, 4115, 4110, 4103, 4102, 4101, 4098, 4088, 4085, 4090, 4081, 4077, 4076, 4075, 4070) ORDER BY "id"

22:21:09.3123.4 msSELECTSELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=21) AND ("object_id" IN (2383, 2388, 2400, 2402, 2403, 2408, 2413, 2415, 2416, 2417, 2420, 2421, 2433, 2434))

22:21:09.3163.6 msSELECTSELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=103) AND ("object_id" IN (2383, 2388, 2400, 2402, 2403, 2408, 2413, 2415, 2416, 2417, 2420, 2421, 2433, 2434))

22:21:09.3210.6 msSELECTSELECT "id", "id" AS "key", "name", "extension", "path", "orig_name" FROM "a57be577deb434"."tbl_attachments" WHERE "id" IN (27183, 27239, 27490, 27501, 27594, 27680, 27715, 27716, 27721, 27529, 27753, 27770, 27855, 27891)

22:21:09.3222.6 msSELECTSELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=108) AND ("object_id" IN (4141, 4133, 4127, 4126, 4123, 4122, 4115, 4110, 4103, 4102, 4101, 4098, 4088, 4085, 4090, 4081, 4077, 4076, 4075, 4070))

22:21:09.3250.4 msSELECTSELECT "id", "id" AS "key", "name", "extension", "path", "orig_name" FROM "a57be577deb434"."tbl_attachments" WHERE "id" IN (27107, 27226, 27289, 27421, 27466, 27474, 27489, 27614, 27616, 27639, 27711, 27718, 27769, 27849, 27885)

22:21:09.3263.8 msSELECTSELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=111) AND ("object_id" IN (4141, 4133, 4127, 4126, 4123, 4122, 4115, 4110, 4103, 4102, 4101, 4098, 4088, 4085, 4090, 4081, 4077, 4076, 4075, 4070))

22:21:09.3300.3 msSELECTSELECT "id", "id" AS "key", "name", "extension", "path", "orig_name" FROM "a57be577deb434"."tbl_attachments" WHERE "id" IN (27223, 27468, 27710, 27768, 27884)

22:21:09.3300.8 msSELECTSELECT "id", "user_id", "user_id" AS "key", "contract_id" FROM "a57be577deb434"."tbl_purchase_contract_payment_collection_remind_receivers" WHERE "contract_id" IN (4141, 4133, 4127, 4126, 4123, 4122, 4115, 4110, 4103, 4102, 4101, 4098, 4088, 4085, 4090, 4081, 4077, 4076, 4075, 4070)

22:21:09.3310.3 msSELECTSELECT "id", "id" AS "key", "name", "sex" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (1011, 5360)

22:21:09.3320.2 msSELECTSELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id" IN (1011, 5360))

22:21:09.3320.7 msSELECTSELECT "id", "id" AS "key", "contract_id", "remind_date" AS "name", "amount" AS "value", "overdue_days", "status" FROM "a57be577deb434"."tbl_purchase_contract_payment_collection_remind_dates" WHERE "contract_id" IN (4141, 4133, 4127, 4126, 4123, 4122, 4115, 4110, 4103, 4102, 4101, 4098, 4088, 4085, 4090, 4081, 4077, 4076, 4075, 4070) ORDER BY "remind_date"

22:21:09.3332.0 msSELECTSELECT "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 (4141, 4133, 4127, 4126, 4123, 4122, 4115, 4110, 4103, 4102, 4101, 4098, 4088, 4085, 4090, 4081, 4077, 4076, 4075, 4070)) GROUP BY "r"."id"

22:21:09.3365.7 msSELECTSELECT 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_approves' and d.nspname = 'a57be577deb434' ORDER BY a.attnum;

22:21:09.3427.9 msSELECTselect 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_approves' and ns.nspname='a57be577deb434' order by fns.nspname, fc.relname, a.attnum

22:21:09.3511.1 msSELECTSELECT "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 (4141, 4133, 4127, 4126, 4123, 4122, 4115, 4110, 4103, 4102, 4101, 4098, 4088, 4085, 4090, 4081, 4077, 4076, 4075, 4070)) ORDER BY "id"

22:21:09.35226.0 msSELECTSELECT "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 (4141, 4133, 4127, 4126, 4123, 4122, 4115, 4110, 4103, 4102, 4101, 4098, 4088, 4085, 4090, 4081, 4077, 4076, 4075, 4070)) GROUP BY "object_id"

22:21:09.3790.7 msSELECTSELECT * FROM "a57be577deb434"."tbl_purchase_contract_product_rels" WHERE "purchase_contract_id" IN (4141, 4133, 4127, 4126, 4123, 4122, 4115, 4110, 4103, 4102, 4101, 4098, 4088, 4085, 4090, 4081, 4077, 4076, 4075, 4070)

22:21:09.3820.9 msSELECTSELECT * FROM "a57be577deb434"."tbl_products" WHERE "id" IN (2089, 2092, 2094, 2112, 2010, 2109, 2110, 2108, 2113, 2114, 2115, 936, 2117, 1943, 1373, 1372, 1624, 1040)

22:21:09.3860.5 msSELECTSELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_types" WHERE "id" IN (18, 5, 20, 4, 11, 3, 7)

22:21:09.3870.4 msSELECTSELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_components" WHERE "id" IN (158, 198, 214, 201, 184, 43, 179, 15, 36, 32)

22:21:09.3870.4 msSELECTSELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_brands" WHERE "id" IN (134, 262, 8, 249, 173, 150, 250, 260, 191, 6, 137)

22:21:09.3880.5 msSELECTSELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_series" WHERE "id" IN (1695, 1696, 1694, 1641, 1697, 693, 1559, 716, 1642, 1690, 813, 75, 1047, 1048, 1382, 633)

22:21:09.3890.4 msSELECTSELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_units" WHERE "id" IN (3, 2, 6, 1, 4)

22:21:09.3890.6 msSELECTSELECT * FROM "a57be577deb434"."tbl_erp_purchase_order_products" WHERE "id" IN (3, 6, 13, 46, 30, 35, 36, 37, 50, 51, 52, 59, 61, 62, 63, 64, 58, 68, 67)

22:21:09.3901.5 msSELECTSELECT * FROM "a57be577deb434"."tbl_erp_purchase_orders" WHERE "purchase_contract_id" IN (4141, 4133, 4127, 4126, 4123, 4122, 4115, 4110, 4103, 4102, 4101, 4098, 4088, 4085, 4090, 4081, 4077, 4076, 4075, 4070)

22:21:09.3940.5 msSELECTSELECT * FROM "a57be577deb434"."tbl_erp_purchase_order_verify_rels" WHERE "erp_purchase_order_id" IN (2023, 2020, 2022, 2032, 2024, 2029, 2039, 2041, 2042, 2013, 2015, 2012, 2003, 2004, 2005, 2006, 2010, 2045, 2044, 2038) ORDER BY "id"

22:21:09.3950.4 msSELECTSELECT * FROM "a57be577deb434"."tbl_erp_purchase_order_stop_verify_rels" WHERE "erp_purchase_order_id" IN (2023, 2020, 2022, 2032, 2024, 2029, 2039, 2041, 2042, 2013, 2015, 2012, 2003, 2004, 2005, 2006, 2010, 2045, 2044, 2038) ORDER BY "id"

22:21:09.3950.4 msSELECTSELECT * FROM "a57be577deb434"."tbl_erp_purchase_order_cancel_verify_rels" WHERE "erp_purchase_order_id" IN (2023, 2020, 2022, 2032, 2024, 2029, 2039, 2041, 2042, 2013, 2015, 2012, 2003, 2004, 2005, 2006, 2010, 2045, 2044, 2038) ORDER BY "id"

22:21:09.3960.7 msSELECTSELECT * FROM "a57be577deb434"."tbl_erp_purchase_costs" WHERE "purchase_contract_id" IN (4141, 4133, 4127, 4126, 4123, 4122, 4115, 4110, 4103, 4102, 4101, 4098, 4088, 4085, 4090, 4081, 4077, 4076, 4075, 4070)

22:21:09.39810.2 msSELECTSELECT SUM(amount) FROM "a57be577deb434"."tbl_purchase_contracts" WHERE "id" IN (SELECT "c"."id" 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 "a57be577deb434"."tbl_attachement_relationships" "cs" ON cs.object_id = c.id AND cs.object_type = 108 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"=1) AND ("sgr"."group_id"='1') AND ("client"."sales_rep"='1001') AND ("client"."sales_rep"='1001') AND (("client"."sales_rep" IN (1001, 5049, 5301, 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, 5294, 5357, 5044, 1030, 5076, 5300, 5027, 5089, 5311, 5066, 5069, 5364, 1009, 5295, 1013, 5128, 5203, 1025, 5032, 5075, 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)) AND ("is_chargeback"=FALSE) AND (c.is_draft = false) AND (c.is_refuse = false) GROUP BY "c"."id" ORDER BY "c"."signed_at" DESC, "c"."created_at" DESC)

22:21:09.4098.1 msSELECTSELECT SUM(amount) FROM "a57be577deb434"."tbl_purchase_contracts" WHERE ("id" IN (SELECT "c"."id" 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 "a57be577deb434"."tbl_attachement_relationships" "cs" ON cs.object_id = c.id AND cs.object_type = 108 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"=1) AND ("sgr"."group_id"='1') AND ("client"."sales_rep"='1001') AND ("client"."sales_rep"='1001') AND (("client"."sales_rep" IN (1001, 5049, 5301, 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, 5294, 5357, 5044, 1030, 5076, 5300, 5027, 5089, 5311, 5066, 5069, 5364, 1009, 5295, 1013, 5128, 5203, 1025, 5032, 5075, 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)) AND ("is_chargeback"=FALSE) AND (c.is_draft = false) AND (c.is_refuse = false) GROUP BY "c"."id" ORDER BY "c"."signed_at" DESC, "c"."created_at" DESC)) AND ("including_tax"=TRUE)

22:21:09.41814.0 msSELECTSELECT SUM(amount) FROM ((SELECT '1' || r.id::varchar as id, 1 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_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"."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" WHERE "contract_id" IN (SELECT "c"."id" 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 "a57be577deb434"."tbl_attachement_relationships" "cs" ON cs.object_id = c.id AND cs.object_type = 108 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"=1) AND ("sgr"."group_id"='1') AND ("client"."sales_rep"='1001') AND ("client"."sales_rep"='1001') AND (("client"."sales_rep" IN (1001, 5049, 5301, 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, 5294, 5357, 5044, 1030, 5076, 5300, 5027, 5089, 5311, 5066, 5069, 5364, 1009, 5295, 1013, 5128, 5203, 1025, 5032, 5075, 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)) AND ("is_chargeback"=FALSE) AND (c.is_draft = false) AND (c.is_refuse = false) GROUP BY "c"."id" ORDER BY "c"."signed_at" DESC, "c"."created_at" DESC)

22:21:09.43210.6 msSELECTSELECT SUM(amount) FROM "a57be577deb434"."tbl_purchase_contract_invoices" WHERE "contract_id" IN (SELECT "c"."id" 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 "a57be577deb434"."tbl_attachement_relationships" "cs" ON cs.object_id = c.id AND cs.object_type = 108 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"=1) AND ("sgr"."group_id"='1') AND ("client"."sales_rep"='1001') AND ("client"."sales_rep"='1001') AND (("client"."sales_rep" IN (1001, 5049, 5301, 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, 5294, 5357, 5044, 1030, 5076, 5300, 5027, 5089, 5311, 5066, 5069, 5364, 1009, 5295, 1013, 5128, 5203, 1025, 5032, 5075, 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)) AND ("is_chargeback"=FALSE) AND (c.is_draft = false) AND (c.is_refuse = false) GROUP BY "c"."id" ORDER BY "c"."signed_at" DESC, "c"."created_at" DESC)

22:21:09.4438.6 msSELECTSELECT SUM(amount) FROM "a57be577deb434"."tbl_purchase_contract_invoices" WHERE "contract_id" IN (SELECT "id" FROM "a57be577deb434"."tbl_purchase_contracts" WHERE ("id" IN (SELECT "c"."id" 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 "a57be577deb434"."tbl_attachement_relationships" "cs" ON cs.object_id = c.id AND cs.object_type = 108 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"=1) AND ("sgr"."group_id"='1') AND ("client"."sales_rep"='1001') AND ("client"."sales_rep"='1001') AND (("client"."sales_rep" IN (1001, 5049, 5301, 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, 5294, 5357, 5044, 1030, 5076, 5300, 5027, 5089, 5311, 5066, 5069, 5364, 1009, 5295, 1013, 5128, 5203, 1025, 5032, 5075, 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)) AND ("is_chargeback"=FALSE) AND (c.is_draft = false) AND (c.is_refuse = false) GROUP BY "c"."id" ORDER BY "c"."signed_at" DESC, "c"."created_at" DESC)) AND ("including_tax"=TRUE))

22:21:09.4597.3 msSELECTSELECT * FROM "a57be577deb434"."tbl_visit_module_histories" WHERE ("user_id"=1001) AND ("object_type"=13) AND ("visit_date"='2025-09-19')

22:21:09.4664.1 msSELECTSELECT 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_visit_module_histories' and d.nspname = 'a57be577deb434' ORDER BY a.attnum;

22:21:09.4706.0 msSELECTselect 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_visit_module_histories' and ns.nspname='a57be577deb434' order by fns.nspname, fc.relname, a.attnum

22:21:09.4770.9 msUPDATEUPDATE "a57be577deb434"."tbl_visit_module_histories" SET "num"=5, "last_visit_at"='now()' WHERE "id"=56646

22:21:09.4795.7 msINSERTINSERT INTO "global"."tbl_api_log" ("code", "schema", "user_id", "device_type", "url", "request", "response", "php_error", "time") VALUES (200, 'a57be577deb434', 1001, 5, 'vue/purchase-contract/list', '{"PurchaseContractSearch":{"contract_type":"","handler":"","group":"1","invoice_status":"","payment_status":"","contract_scan":"","created_by":"","is_chargeback":"","collected_plan":"","is_draft":"","invoice_from_date_period":"","sales_rep":"1001"},"Filter":{"name":"signed_at","sort":"DESC"},"page":"1","from_project":"1","web_access_token":"sgI4qOfA9gwoazANDIjgG6SZXvcGye8K"}', '{"code":2000,"result":{"list":[{"id":4141,"supplier_id":431,"contract_type":1,"signed_at":"2025-09-12","amount":"103020","handler":1011,"description":"\u539f\u67653 \uff0c\u6539\u621030 \n\u62d2\u7edd\u540e\u9000\u56de3","contract_scan":"","created_by":1001,"created_at":"2025-09-12 15:57:14","updated_at":"2025-09-16 17:31:06","client_id":"","project_id":"","sales_rep":"","serial_no":"\u800c\u7279\u70ed\u821e","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":"45","erp_un_settle_amount":"102975","erp_payment_ticket_is_verify":false,"erp_collect_ticket_is_verify":"","erp_cash_cost_ticket_is_verify":false,"client":{},"project":{},"supplier":{"id":431,"key":431,"name":"\u5317\u4eac\u60e0\u8054\u8baf\u901a\u4fe1\u606f\u6280\u672f\u670d\u52a1\u6709\u9650\u516c\u53f8"},"contractScan":{},"createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4,"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.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":4141,"comment":4},"purchaseClientRels":[{"id":3813,"contract_id":4141,"client_id":1661,"project_id":1791,"client":{"id":1661,"key":1661,"name":"\u5317\u4eac\u7f51\u4fe1\u5143\u79d1\u6280\u6709\u9650\u516c\u53f8","sales_rep":1001},"project":{"id":1791,"key":1791,"name":"\u706b\u773c5500VX\u91c7\u8d2d\u9879\u76ee","project_status":3}}],"purchaseContractPayments":[{"id":"22","key":"22","contract_id":4141,"value":"44","collected_date":"2025-09-15 14:27:05","created_at":"2025-09-15 14:27:05","created_by":1001,"description":"","createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4},"pct":0.04},{"id":"12148","key":"12148","contract_id":4141,"value":"1","collected_date":"2025-09-15 16:38:10","created_at":"2025-09-15 16:38:10","created_by":1001,"description":"\u4fee\u6539\u9884\u8bbe\u5ba1\u6279\u6d41\u7684\u95ee\u9898","createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4},"pct":0}],"purchaseContractInvoices":[],"contractScans":[],"receiptScans":[],"purchaseContractPaymentCollectionRemindReceivers":[],"purchaseContractPaymentCollectionRemindDates":[],"paymentApproves":[],"costContractAmounts":[],"unreadComments":{},"purchaseContractProductRels":[{"id":102,"purchase_contract_id":4141,"erp_store_id":"","erp_purchase_order_product_id":67,"product_id":1040,"description":"","number":"30","amount":"3434","total_amount":"103020.00","erpStore":"","product":{"id":1040,"name":"\u5b81\u76fe\u4ee4\u724c\u8f6f\u4ef6V1.0","product_type":7,"product_component":32,"product_brand":137,"product_serie":633,"product_misc":"","product_qa":"","pn":"","description":"","created_by":1013,"created_at":"2023-09-25 16:31:25","updated_at":"2025-09-18 17:40:14","pinyin_shortcut":"ndlprjV10","product_unit":2,"is_renew":false,"productType":{"id":7,"key":7,"name":"\u8f6f\u4ef6"},"productComponent":{"id":32,"key":32,"name":"\u9632\u75c5\u6bd2\u8f6f\u4ef6"},"productBrand":{"id":137,"key":137,"name":"\u5b81\u76fe"},"productSerie":{"id":633,"key":633,"name":"\u4ee4\u724c"},"productUnit":{"id":2,"key":2,"name":"\u5957"}},"erpPurchaseOrderProduct":{"id":67,"erp_purchase_order_id":2044,"erp_store_id":"","product_id":1040,"description":"","number":"30","into_inventory":"1","amount":"3434","total_amount":"103020.00","last_number":"3","last_amount":"3434","last_total_amount":"10302.00"}}],"erpPurchaseOrder":{"id":2044,"serial_no":"CGDD-20250912-00001","from_date":"","wrote_date":"","handler":1011,"supplier_id":431,"purchase_contract_id":4141,"erp_store_id":"","status":2,"abstract":"","description":"","verify_type":2,"next_verify_user":"","next_stop_verify_user":"","next_cancel_verify_user":"","verify_at":"2025-09-12 15:57:23","stop_at":"2025-09-16 17:31:06.431824+08","cancel_at":"","refuse_description":"","is_resubmitted":false,"is_used":true,"is_done":false,"is_settle":false,"number":"30","amount":"103020","created_by":1001,"stop_description":"","inventory_status":false,"is_cancel":false,"is_old":false,"created_at":"2025-09-12 15:57:23","updated_at":"2025-09-16 17:31:15","erpPurchaseOrderVerifyRels":[],"erpPurchaseOrderStopVerifyRels":[{"id":11,"erp_purchase_order_id":2044,"user_id":1001,"status":1,"description":"","verify_at":"2025-09-16 17:31:15"}],"erpPurchaseOrderCancelVerifyRels":[]},"erpPurchaseCost":"","invoiced":0,"approve_amount":0,"un_approve_amount":103020,"un_invoiced":103020,"payment_collection_remind_ahead_display":"\u65e0","contract_type_display":"\u4ea7\u54c1\u5408\u540c","collected":"45","un_collected":102975,"collected_plan":0,"is_collected":false,"can_update":true,"can_update_cost":false,"can_update_file":true,"can_delete":true,"unread":0,"bgcolor":"#89c541","product_amount":103020,"product_number":30,"is_done":false,"cost_done_display":false,"cost_un_done_display":false,"un_done_display":true},{"id":4133,"supplier_id":431,"contract_type":1,"signed_at":"2025-09-05","amount":"6868","handler":1013,"description":"","contract_scan":"","created_by":1001,"created_at":"2025-09-05 11:14:06","updated_at":"2025-09-16 15:30:44","client_id":"","project_id":"","sales_rep":"","serial_no":"\u65b9\u5f0f\u5730\u65b9\u662f","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":true,"is_refuse":false,"erp_settle_amount":"0","erp_un_settle_amount":"6868","erp_payment_ticket_is_verify":false,"erp_collect_ticket_is_verify":"","erp_cash_cost_ticket_is_verify":false,"client":{},"project":{},"supplier":{"id":431,"key":431,"name":"\u5317\u4eac\u60e0\u8054\u8baf\u901a\u4fe1\u606f\u6280\u672f\u670d\u52a1\u6709\u9650\u516c\u53f8"},"contractScan":{},"createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4,"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"},"department":{"id":4,"key":4,"name":"\u603b\u7ecf\u7406"}},"handlerPerson":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","avatar":{"id":34,"user_id":1013,"name":"\/files\/cdn\/a57be577deb434\/avatar\/25ef1fe7-8dda-3daa-b8ea-9fabd0a47439.png"}},"commentCount":{"object_id":4133,"comment":1},"purchaseClientRels":[{"id":3810,"contract_id":4133,"client_id":3278,"project_id":3577,"client":{"id":3278,"key":3278,"name":"\u5317\u4eac\u521b\u5b89\u5149\u901a\u79d1\u6280\u53d1\u5c55\u6709\u9650\u516c\u53f8","sales_rep":1001},"project":{"id":3577,"key":3577,"name":"PA1410\u9632\u706b\u58992\u5957\u65b0\u8d2d\u9879\u76ee","project_status":3}}],"purchaseContractPayments":[],"purchaseContractInvoices":[],"contractScans":[],"receiptScans":[],"purchaseContractPaymentCollectionRemindReceivers":[],"purchaseContractPaymentCollectionRemindDates":[],"paymentApproves":[],"costContractAmounts":[],"unreadComments":{},"purchaseContractProductRels":[{"id":95,"purchase_contract_id":4133,"erp_store_id":"","erp_purchase_order_product_id":68,"product_id":1624,"description":"","number":"2","amount":"3434","total_amount":"6868.00","erpStore":"","product":{"id":1624,"name":"PAN-SOFTWARE-NGFW-CR","product_type":5,"product_component":36,"product_brand":8,"product_serie":1382,"product_misc":"","product_qa":"","pn":"","description":"","created_by":1013,"created_at":"2024-05-28 17:27:39","updated_at":"2025-09-04 11:42:10","pinyin_shortcut":"PANSOFTWARENGFWCR","product_unit":2,"is_renew":false,"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":68,"erp_purchase_order_id":2045,"erp_store_id":"","product_id":1624,"description":"","number":"2","into_inventory":"0","amount":"3434","total_amount":"6868.00","last_number":"","last_amount":"","last_total_amount":""}}],"erpPurchaseOrder":{"id":2045,"serial_no":"CGDD-20250916-00001","from_date":"","wrote_date":"","handler":1013,"supplier_id":431,"purchase_contract_id":4133,"erp_store_id":"","status":1,"abstract":"","description":"","verify_type":2,"next_verify_user":1011,"next_stop_verify_user":"","next_cancel_verify_user":"","verify_at":"","stop_at":"","cancel_at":"","refuse_description":"","is_resubmitted":false,"is_used":false,"is_done":false,"is_settle":false,"number":"2","amount":"6868","created_by":1001,"stop_description":"","inventory_status":false,"is_cancel":false,"is_old":false,"created_at":"2025-09-16 15:30:44","updated_at":"2025-09-16 15:30:44","erpPurchaseOrderVerifyRels":[{"id":50,"erp_purchase_order_id":2045,"user_id":1011,"status":0,"description":"","verify_at":""}],"erpPurchaseOrderStopVerifyRels":[],"erpPurchaseOrderCancelVerifyRels":[]},"erpPurchaseCost":"","invoiced":0,"approve_amount":0,"un_approve_amount":6868,"un_invoiced":6868,"payment_collection_remind_ahead_display":"\u65e0","contract_type_display":"\u4ea7\u54c1\u5408\u540c","collected":"0","un_collected":6868,"collected_plan":0,"is_collected":false,"can_update":true,"can_update_cost":false,"can_update_file":true,"can_delete":true,"unread":0,"bgcolor":"#89c541","product_amount":6868,"product_number":2,"is_done":false,"cost_done_display":false,"cost_un_done_display":false,"un_done_display":true},{"id":4127,"supplier_id":478,"contract_type":1,"signed_at":"2025-08-26","amount":"775","handler":1011,"description":"","contract_scan":"","created_by":1011,"created_at":"2025-08-27 09:19:44","updated_at":"2025-08-27 09:19:57","client_id":"","project_id":"","sales_rep":"","serial_no":"TSKJ20250826-HYF-002","payment_collection_remind_ahead":"1 day","including_tax":true,"is_save_collection":true,"save_collection_at":"2025-08-27 09:19:57","is_chargeback":false,"cost_type":1,"is_draft":false,"is_verify":false,"is_refuse":false,"erp_settle_amount":"0","erp_un_settle_amount":"775","erp_payment_ticket_is_verify":false,"erp_collect_ticket_is_verify":"","erp_cash_cost_ticket_is_verify":false,"client":{},"project":{},"supplier":{"id":478,"key":478,"name":"\u5317\u4eac\u957f\u987a\u7f51\u8054\u79d1\u6280\u6709\u9650\u516c\u53f8"},"contractScan":{},"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":4127,"comment":1},"purchaseClientRels":[{"id":3782,"contract_id":4127,"client_id":2762,"project_id":3910,"client":{"id":2762,"key":2762,"name":"\u4e0a\u6d77\u534e\u8baf\u7f51\u7edc\u7cfb\u7edf\u6709\u9650\u516c\u53f8\uff08\u8fc7\u5355\uff09","sales_rep":1001},"project":{"id":3910,"key":3910,"name":"33\u6240\u9ad8\u6027\u80fd\u9879\u76ee","project_status":3}}],"purchaseContractPayments":[],"purchaseContractInvoices":[],"contractScans":[],"receiptScans":[],"purchaseContractPaymentCollectionRemindReceivers":[{"id":1475,"user_id":1011,"key":1011,"contract_id":4127,"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":1476,"user_id":5360,"key":5360,"contract_id":4127,"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":866,"key":866,"contract_id":4127,"name":"2025-09-27","value":"775","overdue_days":"","status":0,"pct":100,"collect_status":""}],"paymentApproves":[],"costContractAmounts":[],"unreadComments":{},"purchaseContractProductRels":[{"id":88,"purchase_contract_id":4127,"erp_store_id":"","erp_purchase_order_product_id":62,"product_id":1943,"description":"","number":"10","amount":"15","total_amount":"150","erpStore":"","product":{"id":1943,"name":"\u8d85\u516d\u7c7b\u7f51\u7ebf 5M","product_type":4,"product_component":43,"product_brand":191,"product_serie":813,"product_misc":"","product_qa":"","pn":"","description":"","created_by":1013,"created_at":"2025-02-26 15:20:21","updated_at":"2025-08-27 13:24:36","pinyin_shortcut":"cllwx5M","product_unit":6,"is_renew":false,"productType":{"id":4,"key":4,"name":"\u7f51\u7edc\u8bbe\u5907 "},"productComponent":{"id":43,"key":43,"name":"\u7f51\u7edc\u8bbe\u5907\u914d\u4ef6"},"productBrand":{"id":191,"key":191,"name":"\u957f\u987a\u7f51\u8054"},"productSerie":{"id":813,"key":813,"name":"\u8d85\u516d\u7c7b\u7f51\u7edc\u7ebf\u7f06"},"productUnit":{"id":6,"key":6,"name":"\u6761"}},"erpPurchaseOrderProduct":{"id":62,"erp_purchase_order_id":2042,"erp_store_id":"","product_id":1943,"description":"","number":"10","into_inventory":"10","amount":"15","total_amount":"150","last_number":"","last_amount":"","last_total_amount":""}},{"id":89,"purchase_contract_id":4127,"erp_store_id":"","erp_purchase_order_product_id":63,"product_id":1373,"description":"","number":"10","amount":"37.5","total_amount":"375","erpStore":"","product":{"id":1373,"name":"LC-LC \u5149\u7ea4\u7ebf 10\u7c73","product_type":4,"product_component":43,"product_brand":134,"product_serie":1048,"product_misc":"","product_qa":"","pn":"","description":"","created_by":1013,"created_at":"2024-01-26 16:49:29","updated_at":"2025-08-27 13:24:36","pinyin_shortcut":"LCLCgxx10m","product_unit":6,"is_renew":false,"productType":{"id":4,"key":4,"name":"\u7f51\u7edc\u8bbe\u5907 "},"productComponent":{"id":43,"key":43,"name":"\u7f51\u7edc\u8bbe\u5907\u914d\u4ef6"},"productBrand":{"id":134,"key":134,"name":"\u7b2c\u4e09\u65b9"},"productSerie":{"id":1048,"key":1048,"name":"LC-LC \u5149\u7ea4\u7ebf 10\u7c73"},"productUnit":{"id":6,"key":6,"name":"\u6761"}},"erpPurchaseOrderProduct":{"id":63,"erp_purchase_order_id":2042,"erp_store_id":"","product_id":1373,"description":"","number":"10","into_inventory":"10","amount":"37.5","total_amount":"375","last_number":"","last_amount":"","last_total_amount":""}},{"id":90,"purchase_contract_id":4127,"erp_store_id":"","erp_purchase_order_product_id":64,"product_id":1372,"description":"","number":"10","amount":"25","total_amount":"250","erpStore":"","product":{"id":1372,"name":"LC-LC \u5149\u7ea4\u7ebf 5\u7c73","product_type":4,"product_component":43,"product_brand":134,"product_serie":1047,"product_misc":"","product_qa":"","pn":"","description":"","created_by":1013,"created_at":"2024-01-26 16:48:55","updated_at":"2025-08-27 13:24:36","pinyin_shortcut":"LCLCgxx5m","product_unit":6,"is_renew":false,"productType":{"id":4,"key":4,"name":"\u7f51\u7edc\u8bbe\u5907 "},"productComponent":{"id":43,"key":43,"name":"\u7f51\u7edc\u8bbe\u5907\u914d\u4ef6"},"productBrand":{"id":134,"key":134,"name":"\u7b2c\u4e09\u65b9"},"productSerie":{"id":1047,"key":1047,"name":"LC-LC \u5149\u7ea4\u7ebf 5\u7c73"},"productUnit":{"id":6,"key":6,"name":"\u6761"}},"erpPurchaseOrderProduct":{"id":64,"erp_purchase_order_id":2042,"erp_store_id":"","product_id":1372,"description":"","number":"10","into_inventory":"10","amount":"25","total_amount":"250","last_number":"","last_amount":"","last_total_amount":""}}],"erpPurchaseOrder":{"id":2042,"serial_no":"CGDD-20250827-00002","from_date":"","wrote_date":"2025-08-26","handler":1011,"supplier_id":478,"purchase_contract_id":4127,"erp_store_id":"","status":2,"abstract":"","description":"","verify_type":2,"next_verify_user":"","next_stop_verify_user":"","next_cancel_verify_user":"","verify_at":"2025-08-27 09:20:07","stop_at":"","cancel_at":"","refuse_description":"","is_resubmitted":false,"is_used":true,"is_done":false,"is_settle":false,"number":"30","amount":"775","created_by":1011,"stop_description":"","inventory_status":true,"is_cancel":false,"is_old":false,"created_at":"2025-08-27 09:19:44","updated_at":"2025-08-27 09:20:07","erpPurchaseOrderVerifyRels":[{"id":48,"erp_purchase_order_id":2042,"user_id":1011,"status":1,"description":"","verify_at":"2025-08-27 09:20:07"}],"erpPurchaseOrderStopVerifyRels":[],"erpPurchaseOrderCancelVerifyRels":[]},"erpPurchaseCost":"","invoiced":0,"approve_amount":0,"un_approve_amount":775,"un_invoiced":775,"payment_collection_remind_ahead_display":"\u63d0\u524d1\u5929","contract_type_display":"\u4ea7\u54c1\u5408\u540c","collected":"0","un_collected":775,"collected_plan":775,"is_collected":false,"can_update":true,"can_update_cost":false,"can_update_file":true,"can_delete":true,"unread":0,"bgcolor":"#89c541","product_amount":775,"product_number":30,"is_done":false,"cost_done_display":false,"cost_un_done_display":false,"un_done_display":true},{"id":4126,"supplier_id":262,"contract_type":1,"signed_at":"2025-08-26","amount":"228","handler":1011,"description":"","contract_scan":"","created_by":1011,"created_at":"2025-08-27 09:04:35","updated_at":"2025-08-27 09:04:48","client_id":"","project_id":"","sales_rep":"","serial_no":"\u8ba2\u5355\u53f7\uff1a321262742811","payment_collection_remind_ahead":"","including_tax":true,"is_save_collection":true,"save_collection_at":"2025-08-27 09:04:48","is_chargeback":false,"cost_type":1,"is_draft":false,"is_verify":false,"is_refuse":false,"erp_settle_amount":"0","erp_un_settle_amount":"228","erp_payment_ticket_is_verify":false,"erp_collect_ticket_is_verify":"","erp_cash_cost_ticket_is_verify":false,"client":{},"project":{},"supplier":{"id":262,"key":262,"name":"\u4eac\u4e1c\u5546\u57ce"},"contractScan":{},"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":4126,"comment":2},"purchaseClientRels":[{"id":3781,"contract_id":4126,"client_id":2762,"project_id":3910,"client":{"id":2762,"key":2762,"name":"\u4e0a\u6d77\u534e\u8baf\u7f51\u7edc\u7cfb\u7edf\u6709\u9650\u516c\u53f8\uff08\u8fc7\u5355\uff09","sales_rep":1001},"project":{"id":3910,"key":3910,"name":"33\u6240\u9ad8\u6027\u80fd\u9879\u76ee","project_status":3}}],"purchaseContractPayments":[],"purchaseContractInvoices":[{"id":2433,"key":2433,"contract_id":4126,"amount":"228","value":"228","attachment_id":"","from_date":"2025-08-27","description":"","is_draft":false,"attachment":{},"attachmentRelationships":[],"files":[{"id":48951,"object_type":103,"object_id":2433,"attachment_id":27855,"attachment":{"id":27855,"key":27855,"name":"6ce6703c-af42-3e17-af54-b6fde5434b38","extension":"pdf","path":"\/vue\/attachment\/view\/6ce6703c-af42-3e17-af54-b6fde5434b38\/228.pdf","orig_name":"228.pdf"}}]}],"contractScans":[{"id":48943,"object_type":108,"object_id":4126,"attachment_id":27849,"attachment":{"id":27849,"key":27849,"name":"a9a91796-5369-355d-9fa0-4159bb00314a","extension":"png","path":"\/vue\/attachment\/preview\/a9a91796-5369-355d-9fa0-4159bb00314a\/image.png","orig_name":"image.png"}}],"receiptScans":[],"purchaseContractPaymentCollectionRemindReceivers":[{"id":1473,"user_id":1011,"key":1011,"contract_id":4126,"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":1474,"user_id":5360,"key":5360,"contract_id":4126,"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":865,"key":865,"contract_id":4126,"name":"2025-08-29","value":"228","overdue_days":"","status":1,"pct":100,"collect_status":"\u903e\u671f21\u5929"}],"paymentApproves":[{"id":2208,"client_id":2762,"project_id":3910,"title":"\u4ed8\u6b3e\u7533\u8bf7-\u4eac\u4e1c\u5546\u57ce\uff08\u4e2a\u4eba\u5df2\u57ab\u4ed8\uff09","status":2,"next_verify_user":"","verify_at":"2025-08-27 10:11:04","description":"Tristen\uff0c\u7533\u8bf7\u652f\u4ed86\u676116A\u7535\u6e90\u7ebf\u91c7\u8d2d\u6b3e\uff0c\u91d1\u989d\uff1a\uffe5228\u5143\uff0c\u8bf7\u5ba1\u6279\uff01\n\n\u5907\u6ce8\uff1a\u7eb8\u8d28\u652f\u51fa\u51ed\u5355\u5df2\u7ecf\u63d0\u4ea4\u5ba1\u6838\u6d41\u7a0b\uff01","refuse_description":"","is_resubmited":false,"created_by":1011,"created_at":"2025-08-27 09:39:58","updated_at":"2025-08-27 10:11:04","supplier_id":262,"purchase_contract_id":4126,"amount":"228","borrow_amount":"","borrow_collect_day":"","borrow_collect_status":1,"borrow_collect_description":"","borrow_collect_at":"","erp_payment_settle_amount":"228","erp_payment_un_settle_amount":"0","erp_borrow_settle_amount":"0","erp_borrow_un_settle_amount":"0","next_cancel_verify_user":"","cancel_at":"","cancel_description":""}],"costContractAmounts":[],"unreadComments":{},"purchaseContractProductRels":[{"id":87,"purchase_contract_id":4126,"erp_store_id":"","erp_purchase_order_product_id":61,"product_id":2117,"description":"","number":"6","amount":"38","total_amount":"228","erpStore":"","product":{"id":2117,"name":"16A \u4e09\u63d2\u5934\u8f6cC19 1.5\u7c73\u7535\u6e90\u7ebf","product_type":18,"product_component":201,"product_brand":249,"product_serie":1641,"product_misc":"","product_qa":"","pn":"","description":"\u5e7f\u660c\u5174\uff08G.C.X\uff09PDU\u8fde\u63a5\u670d\u52a1\u5668\u7535\u6e90\u7ebf16a\u4e09\u63d2\u5934\u8f6cc19\u5b54 3*2.5\u5e73\u65b9 1.5\u7c73 \u5927\u529f\u7387\u4e3b\u673a\u901a\u7528 \u65e0\u6c27\u94dc\u56fd\u68073C\u8ba4\u8bc1","created_by":1013,"created_at":"2025-08-26 17:53:52","updated_at":"2025-08-27 13:24:36","pinyin_shortcut":"16AsctzC1915mdyx","product_unit":6,"is_renew":false,"productType":{"id":18,"key":18,"name":"\u673a\u623f\u8bbe\u5907"},"productComponent":{"id":201,"key":201,"name":"\u673a\u623f\u7406\u7ebf\u6750\u6599\u5de5\u5177"},"productBrand":{"id":249,"key":249,"name":"\u5e7f\u660c\u5174"},"productSerie":{"id":1641,"key":1641,"name":"\u7535\u6e90\u7ebf"},"productUnit":{"id":6,"key":6,"name":"\u6761"}},"erpPurchaseOrderProduct":{"id":61,"erp_purchase_order_id":2041,"erp_store_id":"","product_id":2117,"description":"","number":"6","into_inventory":"6","amount":"38","total_amount":"228","last_number":"","last_amount":"","last_total_amount":""}}],"erpPurchaseOrder":{"id":2041,"serial_no":"CGDD-20250827-00001","from_date":"","wrote_date":"2025-08-26","handler":1011,"supplier_id":262,"purchase_contract_id":4126,"erp_store_id":"","status":2,"abstract":"","description":"","verify_type":2,"next_verify_user":"","next_stop_verify_user":"","next_cancel_verify_user":"","verify_at":"2025-08-27 09:05:03","stop_at":"","cancel_at":"","refuse_description":"","is_resubmitted":false,"is_used":true,"is_done":false,"is_settle":false,"number":"6","amount":"228","created_by":1011,"stop_description":"","inventory_status":true,"is_cancel":false,"is_old":false,"created_at":"2025-08-27 09:04:37","updated_at":"2025-08-27 09:05:03","erpPurchaseOrderVerifyRels":[{"id":47,"erp_purchase_order_id":2041,"user_id":1011,"status":1,"description":"","verify_at":"2025-08-27 09:05:03"}],"erpPurchaseOrderStopVerifyRels":[],"erpPurchaseOrderCancelVerifyRels":[]},"erpPurchaseCost":"","invoiced":228,"approve_amount":228,"un_approve_amount":0,"un_invoiced":0,"payment_collection_remind_ahead_display":"\u65e0","contract_type_display":"\u4ea7\u54c1\u5408\u540c","collected":"0","un_collected":228,"collected_plan":228,"is_collected":false,"can_update":true,"can_update_cost":false,"can_update_file":true,"can_delete":true,"unread":0,"bgcolor":"#89c541","product_amount":228,"product_number":6,"is_done":false,"cost_done_display":false,"cost_un_done_display":false,"un_done_display":true},{"id":4123,"supplier_id":489,"contract_type":1,"signed_at":"2025-08-26","amount":"2900","handler":1011,"description":"","contract_scan":"","created_by":1011,"created_at":"2025-08-26 15:40:26","updated_at":"2025-08-26 15:40:39","client_id":"","project_id":"","sales_rep":"","serial_no":"TSKJ20250826-HYF-001","payment_collection_remind_ahead":"1 day","including_tax":true,"is_save_collection":true,"save_collection_at":"2025-08-26 15:40:39","is_chargeback":false,"cost_type":1,"is_draft":false,"is_verify":false,"is_refuse":false,"erp_settle_amount":"0","erp_un_settle_amount":"2900","erp_payment_ticket_is_verify":false,"erp_collect_ticket_is_verify":"","erp_cash_cost_ticket_is_verify":false,"client":{},"project":{},"supplier":{"id":489,"key":489,"name":"\u5317\u4eac\u6234\u68ee\u7279\u7cfb\u7edf\u79d1\u6280\u6709\u9650\u516c\u53f8"},"contractScan":{},"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":4123,"comment":1},"purchaseClientRels":[{"id":3778,"contract_id":4123,"client_id":1492,"project_id":3858,"client":{"id":1492,"key":1492,"name":"\u5317\u4eac\u8d1d\u745e\u548c\u5eb7\u751f\u7269\u6280\u672f\u6709\u9650\u516c\u53f8(\u5317\u4eac\u8d1d\u745e\u548c\u5eb7\u533b\u5b66\u68c0\u9a8c\u5b9e\u9a8c\u5ba4\u6709\u9650\u516c\u53f8)","sales_rep":1001},"project":{"id":3858,"key":3858,"name":"\u5b9e\u9a8c\u5ba4\u5b58\u50a8\u7eed\u4fdd","project_status":3}}],"purchaseContractPayments":[],"purchaseContractInvoices":[],"contractScans":[],"receiptScans":[],"purchaseContractPaymentCollectionRemindReceivers":[{"id":1469,"user_id":1011,"key":1011,"contract_id":4123,"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":1470,"user_id":5360,"key":5360,"contract_id":4123,"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":863,"key":863,"contract_id":4123,"name":"2026-08-26","value":"2900","overdue_days":"","status":0,"pct":100,"collect_status":""}],"paymentApproves":[],"costContractAmounts":[],"unreadComments":{},"purchaseContractProductRels":[{"id":85,"purchase_contract_id":4123,"erp_store_id":"","erp_purchase_order_product_id":59,"product_id":936,"description":"","number":"1","amount":"2900","total_amount":"2900","erpStore":"","product":{"id":936,"name":"X377A","product_type":3,"product_component":15,"product_brand":6,"product_serie":75,"product_misc":"","product_qa":"","pn":"","description":"","created_by":1013,"created_at":"2023-07-28 09:46:45","updated_at":"2025-08-27 13:27:43","pinyin_shortcut":"X377A","product_unit":4,"is_renew":false,"productType":{"id":3,"key":3,"name":"\u5b58\u50a8\u8bbe\u5907"},"productComponent":{"id":15,"key":15,"name":"\u5b58\u50a8\u786c\u76d8"},"productBrand":{"id":6,"key":6,"name":"NetAPP"},"productSerie":{"id":75,"key":75,"name":"10T 10K 3.5 SAS\u5b58\u50a8\u786c\u76d8"},"productUnit":{"id":4,"key":4,"name":"\u5757"}},"erpPurchaseOrderProduct":{"id":59,"erp_purchase_order_id":2039,"erp_store_id":"","product_id":936,"description":"","number":"1","into_inventory":"1","amount":"2900","total_amount":"2900","last_number":"","last_amount":"","last_total_amount":""}}],"erpPurchaseOrder":{"id":2039,"serial_no":"CGDD-20250826-00002","from_date":"","wrote_date":"2025-08-26","handler":1011,"supplier_id":489,"purchase_contract_id":4123,"erp_store_id":"","status":2,"abstract":"","description":"","verify_type":2,"next_verify_user":"","next_stop_verify_user":"","next_cancel_verify_user":"","verify_at":"2025-08-26 15:40:48","stop_at":"","cancel_at":"","refuse_description":"","is_resubmitted":false,"is_used":true,"is_done":false,"is_settle":false,"number":"1","amount":"2900","created_by":1011,"stop_description":"","inventory_status":true,"is_cancel":false,"is_old":false,"created_at":"2025-08-26 15:40:27","updated_at":"2025-08-26 15:40:48","erpPurchaseOrderVerifyRels":[{"id":45,"erp_purchase_order_id":2039,"user_id":1011,"status":1,"description":"","verify_at":"2025-08-26 15:40:48"}],"erpPurchaseOrderStopVerifyRels":[],"erpPurchaseOrderCancelVerifyRels":[]},"erpPurchaseCost":"","invoiced":0,"approve_amount":0,"un_approve_amount":2900,"un_invoiced":2900,"payment_collection_remind_ahead_display":"\u63d0\u524d1\u5929","contract_type_display":"\u4ea7\u54c1\u5408\u540c","collected":"0","un_collected":2900,"collected_plan":2900,"is_collected":false,"can_update":true,"can_update_cost":false,"can_update_file":true,"can_delete":true,"unread":0,"bgcolor":"#89c541","product_amount":2900,"product_number":1,"is_done":false,"cost_done_display":false,"cost_un_done_display":false,"un_done_display":true},{"id":4122,"supplier_id":90,"contract_type":3,"signed_at":"2025-08-26","amount":"1950200","handler":1011,"description":"\u7ef4\u4fdd\uff1aSN 7159165872 \u5468\u671f\uff1a2025\/9\/9\u81f32026\/9\/8","contract_scan":"","created_by":1011,"created_at":"2025-08-26 13:37:22","updated_at":"2025-09-16 14:25:49","client_id":"","project_id":"","sales_rep":"","serial_no":"X_2025SBQ23652","payment_collection_remind_ahead":"1 day","including_tax":true,"is_save_collection":true,"save_collection_at":"2025-08-26 13:37:59","is_chargeback":false,"cost_type":1,"is_draft":false,"is_verify":false,"is_refuse":false,"erp_settle_amount":"46","erp_un_settle_amount":"1950154","erp_payment_ticket_is_verify":false,"erp_collect_ticket_is_verify":"","erp_cash_cost_ticket_is_verify":false,"client":{},"project":{},"supplier":{"id":90,"key":90,"name":"\u7d2b\u5149\u6653\u901a\u79d1\u6280\u6709\u9650\u516c\u53f8"},"contractScan":{},"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":4122,"comment":5},"purchaseClientRels":[{"id":3806,"contract_id":4122,"client_id":3286,"project_id":3927,"client":{"id":3286,"key":3286,"name":"\u826f\u56fe\u79d1\u6280\uff08\u4e0a\u6d77\uff09\u6709\u9650\u516c\u53f8","sales_rep":1001},"project":{"id":3927,"key":3927,"name":"PA VM\u9632\u706b\u5899\u7ef4\u4fdd\u7eed\u7ea6","project_status":3}}],"purchaseContractPayments":[{"id":"12136","key":"12136","contract_id":4122,"value":"1","collected_date":"2025-09-12 15:45:16","created_at":"2025-09-12 15:45:16","created_by":1001,"description":"","createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4},"pct":0},{"id":"12135","key":"12135","contract_id":4122,"value":"44","collected_date":"2025-09-11 15:50:59","created_at":"2025-09-11 15:50:59","created_by":1001,"description":"\u5b98\u65b9","createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4},"pct":0},{"id":"12126","key":"12126","contract_id":4122,"value":"1","collected_date":"2025-09-04 10:33:10","created_at":"2025-09-04 10:33:10","created_by":1001,"description":"1","createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4},"pct":0}],"purchaseContractInvoices":[{"id":2434,"key":2434,"contract_id":4122,"amount":"19502","value":"19502","attachment_id":"","from_date":"2025-08-28","description":"","is_draft":false,"attachment":{},"attachmentRelationships":[],"files":[{"id":49191,"object_type":103,"object_id":2434,"attachment_id":27891,"attachment":{"id":27891,"key":27891,"name":"d0b581f6-1d02-39b9-a006-163d7df89c02","extension":"pdf","path":"\/vue\/attachment\/view\/d0b581f6-1d02-39b9-a006-163d7df89c02\/19502.pdf","orig_name":"19502.pdf"}}]}],"contractScans":[{"id":49559,"object_type":108,"object_id":4122,"attachment_id":27885,"attachment":{"id":27885,"key":27885,"name":"4b69a0e7-1929-371b-9c11-6b798a3b96a8","extension":"pdf","path":"\/vue\/attachment\/preview\/4b69a0e7-1929-371b-9c11-6b798a3b96a8\/19502.pdf","orig_name":"19502.pdf"}}],"receiptScans":[{"id":49560,"object_type":111,"object_id":4122,"attachment_id":27884,"attachment":{"id":27884,"key":27884,"name":"bc0ccc2e-afc0-32d1-b0cc-1eab468e60a6","extension":"pdf","path":"\/vue\/attachment\/preview\/bc0ccc2e-afc0-32d1-b0cc-1eab468e60a6\/19502.pdf","orig_name":"19502.pdf"}}],"purchaseContractPaymentCollectionRemindReceivers":[{"id":1465,"user_id":1011,"key":1011,"contract_id":4122,"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":1466,"user_id":5360,"key":5360,"contract_id":4122,"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":861,"key":861,"contract_id":4122,"name":"2026-10-28","value":"19502","overdue_days":"","status":0,"pct":1,"collect_status":""}],"paymentApproves":[{"id":2230,"client_id":"","project_id":"","title":"\u8ba2\u5355","status":2,"next_verify_user":"","verify_at":"2025-09-11 15:50:47","description":"\u5bf9\u65b9\u7684","refuse_description":"","is_resubmited":false,"created_by":1001,"created_at":"2025-09-11 15:50:43","updated_at":"2025-09-11 15:50:47","supplier_id":90,"purchase_contract_id":4122,"amount":"44","borrow_amount":"","borrow_collect_day":"","borrow_collect_status":1,"borrow_collect_description":"","borrow_collect_at":"","erp_payment_settle_amount":"44","erp_payment_un_settle_amount":"0","erp_borrow_settle_amount":"0","erp_borrow_un_settle_amount":"0","next_cancel_verify_user":"","cancel_at":"","cancel_description":""},{"id":2239,"client_id":"","project_id":"","title":"1","status":2,"next_verify_user":"","verify_at":"2025-09-12 15:46:03","description":"1","refuse_description":"","is_resubmited":false,"created_by":1001,"created_at":"2025-09-12 15:45:32","updated_at":"2025-09-12 15:46:03","supplier_id":90,"purchase_contract_id":4122,"amount":"11","borrow_amount":"","borrow_collect_day":"","borrow_collect_status":1,"borrow_collect_description":"","borrow_collect_at":"","erp_payment_settle_amount":"12","erp_payment_un_settle_amount":"-1","erp_borrow_settle_amount":"0","erp_borrow_un_settle_amount":"0","next_cancel_verify_user":"","cancel_at":"","cancel_description":""}],"costContractAmounts":[],"unreadComments":{},"purchaseContractProductRels":[{"id":98,"purchase_contract_id":4122,"erp_store_id":"","erp_purchase_order_product_id":58,"product_id":1624,"description":"","number":"1400","amount":"1393","total_amount":"1950200.00","erpStore":"","product":{"id":1624,"name":"PAN-SOFTWARE-NGFW-CR","product_type":5,"product_component":36,"product_brand":8,"product_serie":1382,"product_misc":"","product_qa":"","pn":"","description":"","created_by":1013,"created_at":"2024-05-28 17:27:39","updated_at":"2025-09-04 11:42:10","pinyin_shortcut":"PANSOFTWARENGFWCR","product_unit":2,"is_renew":false,"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":58,"erp_purchase_order_id":2038,"erp_store_id":"","product_id":1624,"description":"","number":"1400","into_inventory":"14","amount":"1393","total_amount":"1950200.00","last_number":"14","last_amount":"1393","last_total_amount":"19502"}}],"erpPurchaseOrder":{"id":2038,"serial_no":"CGDD-20250826-00001","from_date":"","wrote_date":"2025-08-26","handler":1011,"supplier_id":90,"purchase_contract_id":4122,"erp_store_id":"","status":2,"abstract":"","description":"\u7ef4\u4fdd\uff1aSN 7159165872 \u5468\u671f\uff1a2025\/9\/9\u81f32026\/9\/8","verify_type":2,"next_verify_user":"","next_stop_verify_user":"","next_cancel_verify_user":"","verify_at":"2025-08-26 13:54:26","stop_at":"2025-09-16 14:25:49.32011+08","cancel_at":"","refuse_description":"","is_resubmitted":false,"is_used":true,"is_done":false,"is_settle":false,"number":"1400","amount":"1950200","created_by":1011,"stop_description":"","inventory_status":false,"is_cancel":false,"is_old":false,"created_at":"2025-08-26 13:37:23","updated_at":"2025-09-16 14:29:24","erpPurchaseOrderVerifyRels":[{"id":44,"erp_purchase_order_id":2038,"user_id":1011,"status":1,"description":"","verify_at":"2025-08-26 13:54:26"}],"erpPurchaseOrderStopVerifyRels":[{"id":7,"erp_purchase_order_id":2038,"user_id":1011,"status":1,"description":"","verify_at":"2025-09-16 14:29:24"}],"erpPurchaseOrderCancelVerifyRels":[]},"erpPurchaseCost":"","invoiced":19502,"approve_amount":55,"un_approve_amount":1950145,"un_invoiced":1930698,"payment_collection_remind_ahead_display":"\u63d0\u524d1\u5929","contract_type_display":"\u670d\u52a1\u5408\u540c","collected":"46","un_collected":1950154,"collected_plan":19502,"is_collected":false,"can_update":true,"can_update_cost":false,"can_update_file":true,"can_delete":true,"unread":0,"bgcolor":"#89c541","product_amount":1950200,"product_number":1400,"is_done":false,"cost_done_display":false,"cost_un_done_display":false,"un_done_display":true},{"id":4115,"supplier_id":262,"contract_type":1,"signed_at":"2025-08-21","amount":"509.04","handler":1011,"description":"","contract_scan":"","created_by":1011,"created_at":"2025-08-22 14:53:04","updated_at":"2025-08-22 14:53:20","client_id":"","project_id":"","sales_rep":"","serial_no":"\u8ba2\u5355\u53f7\uff1a 320899347253","payment_collection_remind_ahead":"","including_tax":true,"is_save_collection":true,"save_collection_at":"2025-08-22 14:53:20","is_chargeback":false,"cost_type":1,"is_draft":false,"is_verify":false,"is_refuse":false,"erp_settle_amount":"0","erp_un_settle_amount":"509.04","erp_payment_ticket_is_verify":false,"erp_collect_ticket_is_verify":"","erp_cash_cost_ticket_is_verify":false,"client":{},"project":{},"supplier":{"id":262,"key":262,"name":"\u4eac\u4e1c\u5546\u57ce"},"contractScan":{},"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":4115,"comment":4},"purchaseClientRels":[{"id":3757,"contract_id":4115,"client_id":2762,"project_id":3910,"client":{"id":2762,"key":2762,"name":"\u4e0a\u6d77\u534e\u8baf\u7f51\u7edc\u7cfb\u7edf\u6709\u9650\u516c\u53f8\uff08\u8fc7\u5355\uff09","sales_rep":1001},"project":{"id":3910,"key":3910,"name":"33\u6240\u9ad8\u6027\u80fd\u9879\u76ee","project_status":3}}],"purchaseContractPayments":[],"purchaseContractInvoices":[{"id":2421,"key":2421,"contract_id":4115,"amount":"509.04","value":"509.04","attachment_id":"","from_date":"2025-08-22","description":"","is_draft":false,"attachment":{},"attachmentRelationships":[],"files":[{"id":48831,"object_type":103,"object_id":2421,"attachment_id":27770,"attachment":{"id":27770,"key":27770,"name":"d8b08504-f8a2-3978-9d51-1ac329741ff5","extension":"pdf","path":"\/vue\/attachment\/view\/d8b08504-f8a2-3978-9d51-1ac329741ff5\/digital_25117000001066984599.pdf","orig_name":"digital_25117000001066984599.pdf"}}]}],"contractScans":[{"id":48828,"object_type":108,"object_id":4115,"attachment_id":27769,"attachment":{"id":27769,"key":27769,"name":"2807abf0-637f-354d-9216-d6d058675bd8","extension":"png","path":"\/vue\/attachment\/preview\/2807abf0-637f-354d-9216-d6d058675bd8\/image.png","orig_name":"image.png"}}],"receiptScans":[{"id":48829,"object_type":111,"object_id":4115,"attachment_id":27768,"attachment":{"id":27768,"key":27768,"name":"eb38539c-79d1-394b-b4ab-f8faa2234889","extension":"png","path":"\/vue\/attachment\/preview\/eb38539c-79d1-394b-b4ab-f8faa2234889\/image.png","orig_name":"image.png"}}],"purchaseContractPaymentCollectionRemindReceivers":[{"id":1451,"user_id":1011,"key":1011,"contract_id":4115,"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":1452,"user_id":5360,"key":5360,"contract_id":4115,"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":854,"key":854,"contract_id":4115,"name":"2025-08-29","value":"509.04","overdue_days":3,"status":1,"pct":100,"collect_status":"\u903e\u671f21\u5929"}],"paymentApproves":[{"id":2204,"client_id":2762,"project_id":3910,"title":"\u4ed8\u6b3e\u7533\u8bf7-\u4eac\u4e1c\u5546\u57ce","status":2,"next_verify_user":"","verify_at":"2025-08-25 16:22:34","description":"Tristen\uff0c\u7533\u8bf7\u652f\u4ed8\u7f51\u7ebf\u53ca\u5149\u7ea4\u7ebf \u7ebf\u7f06\u91c7\u8d2d\u6b3e\uff0c\u91d1\u989d\uff1a\uffe5509.04\u5143\uff0c\u8bf7\u5ba1\u6279\uff01\n\n\u5907\u6ce8\uff1a\u7eb8\u8d28\u5355\u636e\u5df2\u63d0\u4ea4\u5ba1\u6838\uff01","refuse_description":"","is_resubmited":false,"created_by":1011,"created_at":"2025-08-25 15:08:32","updated_at":"2025-08-25 16:22:34","supplier_id":262,"purchase_contract_id":4115,"amount":"509.04","borrow_amount":"","borrow_collect_day":"","borrow_collect_status":1,"borrow_collect_description":"","borrow_collect_at":"","erp_payment_settle_amount":"509.04","erp_payment_un_settle_amount":"0","erp_borrow_settle_amount":"0","erp_borrow_un_settle_amount":"0","next_cancel_verify_user":"","cancel_at":"","cancel_description":""}],"costContractAmounts":[],"unreadComments":{"object_id":4115,"unread":1},"purchaseContractProductRels":[{"id":71,"purchase_contract_id":4115,"erp_store_id":"","erp_purchase_order_product_id":50,"product_id":2113,"description":"","number":"8","amount":"22.77","total_amount":"182.17","erpStore":"","product":{"id":2113,"name":"SF6050","product_type":4,"product_component":43,"product_brand":173,"product_serie":693,"product_misc":"","product_qa":"","pn":"","description":"\u5c71\u6cfd\u516d\u7c7b\u5c4f\u853d\u7f51\u7ebf 5\u7c73\u5343\u5146\u9ed1\u82728\u82af\u53cc\u7ede\u6297\u5e72\u6270\u6210\u54c1\u8df3\u7ebf \u9ed1\u8272","created_by":1013,"created_at":"2025-08-22 09:32:26","updated_at":"2025-08-25 15:32:17","pinyin_shortcut":"SF6050","product_unit":6,"is_renew":false,"productType":{"id":4,"key":4,"name":"\u7f51\u7edc\u8bbe\u5907 "},"productComponent":{"id":43,"key":43,"name":"\u7f51\u7edc\u8bbe\u5907\u914d\u4ef6"},"productBrand":{"id":173,"key":173,"name":"\u5c71\u6cfd"},"productSerie":{"id":693,"key":693,"name":"\u7f51\u7ebf"},"productUnit":{"id":6,"key":6,"name":"\u6761"}},"erpPurchaseOrderProduct":{"id":50,"erp_purchase_order_id":2032,"erp_store_id":"","product_id":2113,"description":"","number":"8","into_inventory":"8","amount":"22.77","total_amount":"182.17","last_number":"","last_amount":"","last_total_amount":""}},{"id":72,"purchase_contract_id":4115,"erp_store_id":"","erp_purchase_order_product_id":51,"product_id":2114,"description":"","number":"6","amount":"50.02","total_amount":"300.16","erpStore":"","product":{"id":2114,"name":"G3-LCLC05","product_type":4,"product_component":43,"product_brand":173,"product_serie":1559,"product_misc":"","product_qa":"","pn":"","description":"\u5c71\u6cfd \u5149\u7ea4\u8df3\u7ebf \u7535\u4fe1\u7ea7\u4e07\u5146LC-LC\u591a\u6a21\u53cc\u82afOM3-300 \u4f4e\u70df\u65e0\u5364 \u5149\u7ea4\u7ebf \u6536\u53d1\u5668\u5c3e\u7ea4 5\u7c73G3-LCLC05","created_by":1013,"created_at":"2025-08-22 09:34:27","updated_at":"2025-08-25 15:32:17","pinyin_shortcut":"G3LCLC05","product_unit":6,"is_renew":false,"productType":{"id":4,"key":4,"name":"\u7f51\u7edc\u8bbe\u5907 "},"productComponent":{"id":43,"key":43,"name":"\u7f51\u7edc\u8bbe\u5907\u914d\u4ef6"},"productBrand":{"id":173,"key":173,"name":"\u5c71\u6cfd"},"productSerie":{"id":1559,"key":1559,"name":"\u5149\u7ea4\u7ebf"},"productUnit":{"id":6,"key":6,"name":"\u6761"}},"erpPurchaseOrderProduct":{"id":51,"erp_purchase_order_id":2032,"erp_store_id":"","product_id":2114,"description":"","number":"6","into_inventory":"6","amount":"50.02","total_amount":"300.16","last_number":"","last_amount":"","last_total_amount":""}},{"id":73,"purchase_contract_id":4115,"erp_store_id":"","erp_purchase_order_product_id":52,"product_id":2115,"description":"","number":"4","amount":"6.67","total_amount":"26.71","erpStore":"","product":{"id":2115,"name":"WD6020","product_type":4,"product_component":43,"product_brand":173,"product_serie":693,"product_misc":"","product_qa":"","pn":"","description":" \u5c71\u6cfd \u516d\u7c7b\u7f51\u7ebf 2\u7c73\u5343\u5146\u9ad8\u901f\u5bbd\u5e26\u7ebf CAT6\u7c7b\u5bb6\u7528\u7535\u8111\u8def\u7531\u56685g\u7f51\u7edc\u5de5\u7a0b\u76d1\u63a7\u7ebf8\u82af\u6210\u54c1\u8df3\u7ebf2.5g\u9ed1\u8272 ","created_by":1013,"created_at":"2025-08-22 09:35:09","updated_at":"2025-08-25 15:32:17","pinyin_shortcut":"WD6020","product_unit":6,"is_renew":false,"productType":{"id":4,"key":4,"name":"\u7f51\u7edc\u8bbe\u5907 "},"productComponent":{"id":43,"key":43,"name":"\u7f51\u7edc\u8bbe\u5907\u914d\u4ef6"},"productBrand":{"id":173,"key":173,"name":"\u5c71\u6cfd"},"productSerie":{"id":693,"key":693,"name":"\u7f51\u7ebf"},"productUnit":{"id":6,"key":6,"name":"\u6761"}},"erpPurchaseOrderProduct":{"id":52,"erp_purchase_order_id":2032,"erp_store_id":"","product_id":2115,"description":"","number":"4","into_inventory":"4","amount":"6.67","total_amount":"26.71","last_number":"","last_amount":"","last_total_amount":""}}],"erpPurchaseOrder":{"id":2032,"serial_no":"CGDD-20250822-00003","from_date":"","wrote_date":"2025-08-21","handler":1011,"supplier_id":262,"purchase_contract_id":4115,"erp_store_id":"","status":2,"abstract":"","description":"","verify_type":2,"next_verify_user":"","next_stop_verify_user":"","next_cancel_verify_user":"","verify_at":"2025-08-22 14:53:36","stop_at":"","cancel_at":"","refuse_description":"","is_resubmitted":false,"is_used":true,"is_done":false,"is_settle":false,"number":"18","amount":"508.96","created_by":1011,"stop_description":"","inventory_status":true,"is_cancel":false,"is_old":false,"created_at":"2025-08-22 14:53:04","updated_at":"2025-08-22 14:53:36","erpPurchaseOrderVerifyRels":[{"id":38,"erp_purchase_order_id":2032,"user_id":1011,"status":1,"description":"","verify_at":"2025-08-22 14:53:36"}],"erpPurchaseOrderStopVerifyRels":[],"erpPurchaseOrderCancelVerifyRels":[]},"erpPurchaseCost":"","invoiced":509.04,"approve_amount":509.04,"un_approve_amount":0,"un_invoiced":0,"payment_collection_remind_ahead_display":"\u65e0","contract_type_display":"\u4ea7\u54c1\u5408\u540c","collected":"0","un_collected":509.04,"collected_plan":509.04,"is_collected":false,"can_update":true,"can_update_cost":false,"can_update_file":true,"can_delete":true,"unread":1,"bgcolor":"#89c541","product_amount":509.04,"product_number":18,"is_done":false,"cost_done_display":false,"cost_un_done_display":false,"un_done_display":true},{"id":4110,"supplier_id":723,"contract_type":1,"signed_at":"2025-08-21","amount":"2064","handler":1011,"description":"","contract_scan":"","created_by":1011,"created_at":"2025-08-21 15:57:42","updated_at":"2025-08-21 16:01:24","client_id":"","project_id":"","sales_rep":"","serial_no":"XRAT20250821-IC01","payment_collection_remind_ahead":"1 day","including_tax":true,"is_save_collection":true,"save_collection_at":"2025-08-21 15:57:54","is_chargeback":false,"cost_type":1,"is_draft":false,"is_verify":false,"is_refuse":false,"erp_settle_amount":"2064","erp_un_settle_amount":"0","erp_payment_ticket_is_verify":false,"erp_collect_ticket_is_verify":"","erp_cash_cost_ticket_is_verify":false,"client":{},"project":{},"supplier":{"id":723,"key":723,"name":"\u5317\u4eac\u65ed\u65e5\u5b89\u6cf0\u79d1\u6280\u6709\u9650\u516c\u53f8"},"contractScan":{},"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":4110,"comment":2},"purchaseClientRels":[{"id":3774,"contract_id":4110,"client_id":2136,"project_id":3951,"client":{"id":2136,"key":2136,"name":"\u5317\u4eac\u7279\u79cd\u673a\u68b0\u7814\u7a76\u6240 59\u6240","sales_rep":1001},"project":{"id":3951,"key":3951,"name":"\u8bfb\u5361\u5668\u91c7\u8d2d","project_status":3}}],"purchaseContractPayments":[{"id":"12108","key":"12108","contract_id":4110,"value":"2064","collected_date":"2025-08-21 17:33:06","created_at":"2025-08-21 17:33:06","created_by":5388,"description":"\u7f51\u94f6\u6c47\u6b3e \u65ed\u65e5\u5b89\u6cf0\n","createdBy":{"id":5388,"key":5388,"name":"\u6768\u71d5\u971e","sex":"F","department_id":6},"pct":100}],"purchaseContractInvoices":[{"id":2417,"key":2417,"contract_id":4110,"amount":"2064","value":"2064","attachment_id":"","from_date":"2025-08-21","description":"","is_draft":false,"attachment":{},"attachmentRelationships":[],"files":[{"id":48754,"object_type":103,"object_id":2417,"attachment_id":27721,"attachment":{"id":27721,"key":27721,"name":"ab792325-6d11-3efa-892d-d948648b0734","extension":"pdf","path":"\/vue\/attachment\/view\/ab792325-6d11-3efa-892d-d948648b0734\/dzfp_25112000000176321896_\u5317\u4eac\u62d3\u5b9e\u79d1\u6280\u6709\u9650\u516c\u53f8_20250821161542.pdf","orig_name":"dzfp_25112000000176321896_\u5317\u4eac\u62d3\u5b9e\u79d1\u6280\u6709\u9650\u516c\u53f8_20250821161542.pdf"}}]}],"contractScans":[{"id":48746,"object_type":108,"object_id":4110,"attachment_id":27718,"attachment":{"id":27718,"key":27718,"name":"f93918d8-0c63-3bc7-a3fe-1038f5770235","extension":"pdf","path":"\/vue\/attachment\/preview\/f93918d8-0c63-3bc7-a3fe-1038f5770235\/0821-IC01.pdf","orig_name":"0821-IC01.pdf"}}],"receiptScans":[],"purchaseContractPaymentCollectionRemindReceivers":[{"id":1439,"user_id":1011,"key":1011,"contract_id":4110,"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":1440,"user_id":5360,"key":5360,"contract_id":4110,"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":848,"key":848,"contract_id":4110,"name":"2025-08-21","value":"2064","overdue_days":0,"status":1,"pct":100,"collect_status":"\u5df2\u5b8c\u6210"}],"paymentApproves":[{"id":2186,"client_id":2136,"project_id":3951,"title":"\u4ed8\u6b3e\u7533\u8bf7-\u5317\u4eac\u65ed\u65e5\u5b89\u6cf0\u79d1\u6280\u6709\u9650\u516c\u53f8","status":2,"next_verify_user":"","verify_at":"2025-08-21 17:28:46","description":"Tristen\uff0c\u7533\u8bf7\u4eca\u65e5\u652f\u4ed8\u8bfb\u5361\u56688\u5757\u91c7\u8d2d\u6b3e\uff0c\u91d1\u989d\uff1a\uffe52064\u5143\u3002\u8bf7\u5ba1\u6279\uff01\n\n\u6c47\u6b3e\u4fe1\u606f\uff1a\n\u4f01\u4e1a\u540d\u79f0\uff1a\u5317\u4eac\u65ed\u65e5\u5b89\u6cf0\u79d1\u6280\u6709\u9650\u516c\u53f8 \n\u5f00\u6237\u94f6\u884c\uff1a\u5de5\u884c\u5317\u4eac\u589e\u5149\u652f\u884c \n\u94f6\u884c\u8d26\u6237\uff1a0200247209200020868\n\n\u5907\u6ce8\uff1a\u7eb8\u8d28\u652f\u51fa\u51ed\u5355\u5df2\u63d0\u4ea4\u5ba1\u6838\uff01","refuse_description":"","is_resubmited":false,"created_by":1011,"created_at":"2025-08-21 16:22:27","updated_at":"2025-08-21 17:28:46","supplier_id":723,"purchase_contract_id":4110,"amount":"2064","borrow_amount":"","borrow_collect_day":"","borrow_collect_status":1,"borrow_collect_description":"","borrow_collect_at":"","erp_payment_settle_amount":"2064","erp_payment_un_settle_amount":"0","erp_borrow_settle_amount":"0","erp_borrow_un_settle_amount":"0","next_cancel_verify_user":"","cancel_at":"","cancel_description":""}],"costContractAmounts":[],"unreadComments":{},"purchaseContractProductRels":[{"id":67,"purchase_contract_id":4110,"erp_store_id":"","erp_purchase_order_product_id":46,"product_id":2112,"description":"","number":"8","amount":"258","total_amount":"2064","erpStore":"","product":{"id":2112,"name":"\u975e\u63a5\u89e6\u8bfb\u5361\u5668","product_type":20,"product_component":184,"product_brand":134,"product_serie":1697,"product_misc":"","product_qa":"","pn":"","description":"","created_by":1013,"created_at":"2025-08-21 15:30:37","updated_at":"2025-08-25 13:23:02","pinyin_shortcut":"fjcdkq","product_unit":1,"is_renew":false,"productType":{"id":20,"key":20,"name":"\u529e\u516c\u8bbe\u5907"},"productComponent":{"id":184,"key":184,"name":"\u6742\u7269\u7c7b"},"productBrand":{"id":134,"key":134,"name":"\u7b2c\u4e09\u65b9"},"productSerie":{"id":1697,"key":1697,"name":"\u8bfb\u5361\u5668"},"productUnit":{"id":1,"key":1,"name":"\u53f0"}},"erpPurchaseOrderProduct":{"id":46,"erp_purchase_order_id":2029,"erp_store_id":"","product_id":2112,"description":"","number":"8","into_inventory":"8","amount":"258","total_amount":"2064","last_number":"","last_amount":"","last_total_amount":""}}],"erpPurchaseOrder":{"id":2029,"serial_no":"CGDD-20250821-00001","from_date":"","wrote_date":"2025-08-21","handler":1011,"supplier_id":723,"purchase_contract_id":4110,"erp_store_id":"","status":2,"abstract":"","description":"","verify_type":2,"next_verify_user":"","next_stop_verify_user":"","next_cancel_verify_user":"","verify_at":"2025-08-21 15:58:12","stop_at":"","cancel_at":"","refuse_description":"","is_resubmitted":false,"is_used":true,"is_done":false,"is_settle":false,"number":"8","amount":"2064","created_by":1011,"stop_description":"","inventory_status":true,"is_cancel":false,"is_old":false,"created_at":"2025-08-21 15:57:42","updated_at":"2025-08-21 15:58:12","erpPurchaseOrderVerifyRels":[{"id":35,"erp_purchase_order_id":2029,"user_id":1011,"status":1,"description":"","verify_at":"2025-08-21 15:58:12"}],"erpPurchaseOrderStopVerifyRels":[],"erpPurchaseOrderCancelVerifyRels":[]},"erpPurchaseCost":"","invoiced":2064,"approve_amount":2064,"un_approve_amount":0,"un_invoiced":0,"payment_collection_remind_ahead_display":"\u63d0\u524d1\u5929","contract_type_display":"\u4ea7\u54c1\u5408\u540c","collected":"2064","un_collected":0,"collected_plan":2064,"is_collected":true,"can_update":true,"can_update_cost":false,"can_update_file":true,"can_delete":true,"unread":0,"bgcolor":"#89c541","product_amount":2064,"product_number":8,"is_done":true,"cost_done_display":false,"cost_un_done_display":false,"done_display":true},{"id":4103,"supplier_id":90,"contract_type":3,"signed_at":"2025-08-19","amount":"14573","handler":1011,"description":"","contract_scan":"","created_by":1011,"created_at":"2025-08-19 18:08:55","updated_at":"2025-08-22 09:56:57","client_id":"","project_id":"","sales_rep":"","serial_no":"X_2025SBQ23003","payment_collection_remind_ahead":"1 day","including_tax":true,"is_save_collection":true,"save_collection_at":"2025-08-22 09:56:57","is_chargeback":false,"cost_type":1,"is_draft":false,"is_verify":false,"is_refuse":false,"erp_settle_amount":"0","erp_un_settle_amount":"14573","erp_payment_ticket_is_verify":false,"erp_collect_ticket_is_verify":"","erp_cash_cost_ticket_is_verify":false,"client":{},"project":{},"supplier":{"id":90,"key":90,"name":"\u7d2b\u5149\u6653\u901a\u79d1\u6280\u6709\u9650\u516c\u53f8"},"contractScan":{},"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":4103,"comment":1},"purchaseClientRels":[{"id":3765,"contract_id":4103,"client_id":2845,"project_id":3949,"client":{"id":2845,"key":2845,"name":"\u5317\u4eac\u6052\u6cf0\u901a\u529b\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8\uff08PA\u8fc7\u5355\uff09","sales_rep":1001},"project":{"id":3949,"key":3949,"name":"PA1410\u4e00\u5e74\u670d\u52a1","project_status":3}}],"purchaseContractPayments":[],"purchaseContractInvoices":[{"id":2420,"key":2420,"contract_id":4103,"amount":"14573","value":"14573","attachment_id":"","from_date":"2025-08-22","description":"","is_draft":false,"attachment":{},"attachmentRelationships":[],"files":[{"id":48808,"object_type":103,"object_id":2420,"attachment_id":27753,"attachment":{"id":27753,"key":27753,"name":"e7bcc1d5-d0c4-38e6-9b84-d59a73c847db","extension":"pdf","path":"\/vue\/attachment\/view\/e7bcc1d5-d0c4-38e6-9b84-d59a73c847db\/91120118MA06G1T23F_25082210223944315336.pdf","orig_name":"91120118MA06G1T23F_25082210223944315336.pdf"}}]}],"contractScans":[{"id":48736,"object_type":108,"object_id":4103,"attachment_id":27711,"attachment":{"id":27711,"key":27711,"name":"75308f1b-6234-3665-864a-eece2f379b79","extension":"pdf","path":"\/vue\/attachment\/preview\/75308f1b-6234-3665-864a-eece2f379b79\/document.pdf","orig_name":"document.pdf"}}],"receiptScans":[{"id":48735,"object_type":111,"object_id":4103,"attachment_id":27710,"attachment":{"id":27710,"key":27710,"name":"942140b4-102c-3971-9d6f-d3118eac6d76","extension":"pdf","path":"\/vue\/attachment\/preview\/942140b4-102c-3971-9d6f-d3118eac6d76\/14573.pdf","orig_name":"14573.pdf"}}],"purchaseContractPaymentCollectionRemindReceivers":[{"id":1443,"user_id":1011,"key":1011,"contract_id":4103,"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":1444,"user_id":5360,"key":5360,"contract_id":4103,"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":850,"key":850,"contract_id":4103,"name":"2025-10-16","value":"14573","overdue_days":"","status":0,"pct":100,"collect_status":""}],"paymentApproves":[],"costContractAmounts":[],"unreadComments":{},"purchaseContractProductRels":[{"id":63,"purchase_contract_id":4103,"erp_store_id":"","erp_purchase_order_product_id":37,"product_id":2108,"description":"","number":"1","amount":"14573","total_amount":"14573","erpStore":"","product":{"id":2108,"name":"PAN-SVC-BKLN-1410-R","product_type":5,"product_component":214,"product_brand":8,"product_serie":1694,"product_misc":"","product_qa":"","pn":"","description":"PA-1410, Partner enabled premium support, 1 year (12 months) term, renewal.","created_by":1013,"created_at":"2025-08-19 16:53:04","updated_at":"2025-08-21 16:46:27","pinyin_shortcut":"PANSVCBKLN1410R","product_unit":2,"is_renew":true,"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":1694,"key":1694,"name":"PA1410\u4e00\u5e74\u670d\u52a1"},"productUnit":{"id":2,"key":2,"name":"\u5957"}},"erpPurchaseOrderProduct":{"id":37,"erp_purchase_order_id":2024,"erp_store_id":"","product_id":2108,"description":"","number":"1","into_inventory":"1","amount":"14573","total_amount":"14573","last_number":"","last_amount":"","last_total_amount":""}}],"erpPurchaseOrder":{"id":2024,"serial_no":"CGDD-20250819-00006","from_date":"","wrote_date":"2025-08-19","handler":1011,"supplier_id":90,"purchase_contract_id":4103,"erp_store_id":"","status":2,"abstract":"","description":"","verify_type":2,"next_verify_user":"","next_stop_verify_user":"","next_cancel_verify_user":"","verify_at":"2025-08-20 14:58:45","stop_at":"","cancel_at":"","refuse_description":"","is_resubmitted":false,"is_used":true,"is_done":false,"is_settle":false,"number":"1","amount":"14573","created_by":1011,"stop_description":"","inventory_status":true,"is_cancel":false,"is_old":false,"created_at":"2025-08-19 18:08:55","updated_at":"2025-08-20 14:58:45","erpPurchaseOrderVerifyRels":[{"id":25,"erp_purchase_order_id":2024,"user_id":1011,"status":1,"description":"","verify_at":"2025-08-20 09:30:07"},{"id":26,"erp_purchase_order_id":2024,"user_id":1001,"status":1,"description":"","verify_at":"2025-08-20 14:58:45"}],"erpPurchaseOrderStopVerifyRels":[],"erpPurchaseOrderCancelVerifyRels":[]},"erpPurchaseCost":"","invoiced":14573,"approve_amount":0,"un_approve_amount":14573,"un_invoiced":0,"payment_collection_remind_ahead_display":"\u63d0\u524d1\u5929","contract_type_display":"\u670d\u52a1\u5408\u540c","collected":"0","un_collected":14573,"collected_plan":14573,"is_collected":false,"can_update":true,"can_update_cost":false,"can_update_file":true,"can_delete":true,"unread":0,"bgcolor":"#89c541","product_amount":14573,"product_number":1,"is_done":false,"cost_done_display":false,"cost_un_done_display":false,"un_done_display":true},{"id":4102,"supplier_id":123,"contract_type":1,"signed_at":"2025-08-19","amount":"8264","handler":1011,"description":"PDU","contract_scan":"","created_by":1011,"created_at":"2025-08-19 17:27:18","updated_at":"2025-08-20 13:25:03","client_id":"","project_id":"","sales_rep":"","serial_no":"TSKJ20250819-HYF-001","payment_collection_remind_ahead":"1 day","including_tax":true,"is_save_collection":true,"save_collection_at":"2025-08-19 17:27:31","is_chargeback":false,"cost_type":1,"is_draft":false,"is_verify":false,"is_refuse":false,"erp_settle_amount":"8264","erp_un_settle_amount":"0","erp_payment_ticket_is_verify":false,"erp_collect_ticket_is_verify":"","erp_cash_cost_ticket_is_verify":false,"client":{},"project":{},"supplier":{"id":123,"key":123,"name":"\u667a\u76df\u4e16\u7eaa(\u5317\u4eac)\u79d1\u6280\u6709\u9650\u516c\u53f8"},"contractScan":{},"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":4102,"comment":2},"purchaseClientRels":[{"id":3722,"contract_id":4102,"client_id":2762,"project_id":3910,"client":{"id":2762,"key":2762,"name":"\u4e0a\u6d77\u534e\u8baf\u7f51\u7edc\u7cfb\u7edf\u6709\u9650\u516c\u53f8\uff08\u8fc7\u5355\uff09","sales_rep":1001},"project":{"id":3910,"key":3910,"name":"33\u6240\u9ad8\u6027\u80fd\u9879\u76ee","project_status":3}}],"purchaseContractPayments":[{"id":"12105","key":"12105","contract_id":4102,"value":"8264","collected_date":"2025-08-21 15:53:53","created_at":"2025-08-21 15:53:53","created_by":5388,"description":"\u7f51\u94f6\u6c47\u6b3e \u667a\u76df\u4e16\u7eaa","createdBy":{"id":5388,"key":5388,"name":"\u6768\u71d5\u971e","sex":"F","department_id":6},"pct":100}],"purchaseContractInvoices":[{"id":2413,"key":2413,"contract_id":4102,"amount":"8264","value":"8264","attachment_id":"","from_date":"2025-08-21","description":"","is_draft":false,"attachment":{},"attachmentRelationships":[],"files":[{"id":48710,"object_type":103,"object_id":2413,"attachment_id":27680,"attachment":{"id":27680,"key":27680,"name":"3829cc93-b940-3c89-bf48-d01a6858fe90","extension":"pdf","path":"\/vue\/attachment\/view\/3829cc93-b940-3c89-bf48-d01a6858fe90\/dzfp_25112000000175843612_\u5317\u4eac\u62d3\u5b9e\u79d1\u6280\u6709\u9650\u516c\u53f8_20250821102709.pdf","orig_name":"dzfp_25112000000175843612_\u5317\u4eac\u62d3\u5b9e\u79d1\u6280\u6709\u9650\u516c\u53f8_20250821102709.pdf"}}]}],"contractScans":[{"id":48658,"object_type":108,"object_id":4102,"attachment_id":27639,"attachment":{"id":27639,"key":27639,"name":"46dcce05-91b8-3fbd-9334-4d7bbe7216e6","extension":"pdf","path":"\/vue\/attachment\/preview\/46dcce05-91b8-3fbd-9334-4d7bbe7216e6\/8264\u5408\u540c.pdf","orig_name":"8264\u5408\u540c.pdf"}}],"receiptScans":[],"purchaseContractPaymentCollectionRemindReceivers":[{"id":1425,"user_id":1011,"key":1011,"contract_id":4102,"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":1426,"user_id":5360,"key":5360,"contract_id":4102,"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":841,"key":841,"contract_id":4102,"name":"2025-08-23","value":"8264","overdue_days":"","status":1,"pct":100,"collect_status":"\u5df2\u5b8c\u6210"}],"paymentApproves":[{"id":2185,"client_id":2762,"project_id":3910,"title":"\u4ed8\u6b3e\u7533\u8bf7-\u667a\u76df\u4e16\u7eaa(\u5317\u4eac)\u79d1\u6280\u6709\u9650\u516c\u53f8","status":2,"next_verify_user":"","verify_at":"2025-08-21 15:46:24","description":"Tristen\uff0c\u7533\u8bf7\u652f\u4ed8PDU\u91c7\u8d2d\u6b3e\uff0c\u91d1\u989d\uff1a\uffe58264\u5143\uff0c\u8bf7\u5ba1\u6279\uff01\n\n\u5907\u6ce8\uff1a\u7eb8\u8d28\u652f\u51fa\u51ed\u5355\u5df2\u5ba1\u6838\uff01","refuse_description":"","is_resubmited":false,"created_by":1011,"created_at":"2025-08-21 14:47:38","updated_at":"2025-08-21 15:46:24","supplier_id":123,"purchase_contract_id":4102,"amount":"8264","borrow_amount":"","borrow_collect_day":"","borrow_collect_status":1,"borrow_collect_description":"","borrow_collect_at":"","erp_payment_settle_amount":"8264","erp_payment_un_settle_amount":"0","erp_borrow_settle_amount":"0","erp_borrow_un_settle_amount":"0","next_cancel_verify_user":"","cancel_at":"","cancel_description":""}],"costContractAmounts":[],"unreadComments":{},"purchaseContractProductRels":[{"id":62,"purchase_contract_id":4102,"erp_store_id":"","erp_purchase_order_product_id":36,"product_id":2110,"description":"","number":"8","amount":"1033","total_amount":"8264","erpStore":"","product":{"id":2110,"name":"32A 16\u53e3 PDU","product_type":18,"product_component":198,"product_brand":262,"product_serie":1696,"product_misc":"","product_qa":"","pn":"","description":"","created_by":1013,"created_at":"2025-08-19 17:26:24","updated_at":"2025-08-21 09:25:35","pinyin_shortcut":"32A16kPDU","product_unit":3,"is_renew":false,"productType":{"id":18,"key":18,"name":"\u673a\u623f\u8bbe\u5907"},"productComponent":{"id":198,"key":198,"name":"PDU\u63a5\u7ebf\u677f"},"productBrand":{"id":262,"key":262,"name":"\u516c\u725b"},"productSerie":{"id":1696,"key":1696,"name":"32A 16\u53e3 PDU"},"productUnit":{"id":3,"key":3,"name":"\u4e2a"}},"erpPurchaseOrderProduct":{"id":36,"erp_purchase_order_id":2023,"erp_store_id":"","product_id":2110,"description":"","number":"8","into_inventory":"8","amount":"1033","total_amount":"8264","last_number":"","last_amount":"","last_total_amount":""}}],"erpPurchaseOrder":{"id":2023,"serial_no":"CGDD-20250819-00005","from_date":"","wrote_date":"2025-08-19","handler":1011,"supplier_id":123,"purchase_contract_id":4102,"erp_store_id":"","status":2,"abstract":"","description":"PDU","verify_type":2,"next_verify_user":"","next_stop_verify_user":"","next_cancel_verify_user":"","verify_at":"2025-08-20 14:58:53","stop_at":"","cancel_at":"","refuse_description":"","is_resubmitted":false,"is_used":true,"is_done":false,"is_settle":false,"number":"8","amount":"8264","created_by":1011,"stop_description":"","inventory_status":true,"is_cancel":false,"is_old":false,"created_at":"2025-08-19 17:27:18","updated_at":"2025-08-20 14:58:53","erpPurchaseOrderVerifyRels":[{"id":23,"erp_purchase_order_id":2023,"user_id":1011,"status":1,"description":"","verify_at":"2025-08-19 17:40:19"},{"id":24,"erp_purchase_order_id":2023,"user_id":1001,"status":1,"description":"","verify_at":"2025-08-20 14:58:53"}],"erpPurchaseOrderStopVerifyRels":[],"erpPurchaseOrderCancelVerifyRels":[]},"erpPurchaseCost":"","invoiced":8264,"approve_amount":8264,"un_approve_amount":0,"un_invoiced":0,"payment_collection_remind_ahead_display":"\u63d0\u524d1\u5929","contract_type_display":"\u4ea7\u54c1\u5408\u540c","collected":"8264","un_collected":0,"collected_plan":8264,"is_collected":true,"can_update":true,"can_update_cost":false,"can_update_file":true,"can_delete":true,"unread":0,"bgcolor":"#89c541","product_amount":8264,"product_number":8,"is_done":true,"cost_done_display":false,"cost_un_done_display":false,"done_display":true},{"id":4101,"supplier_id":608,"contract_type":1,"signed_at":"2025-08-19","amount":"655","handler":1011,"description":"\u673a\u67dc\u6258\u76d8","contract_scan":"","created_by":1011,"created_at":"2025-08-19 17:19:46","updated_at":"2025-08-19 17:56:27","client_id":"","project_id":"","sales_rep":"","serial_no":"\u8ba2\u5355\u53f7: 4691922230281161702","payment_collection_remind_ahead":"","including_tax":true,"is_save_collection":true,"save_collection_at":"2025-08-19 17:19:55","is_chargeback":false,"cost_type":1,"is_draft":false,"is_verify":false,"is_refuse":false,"erp_settle_amount":"655","erp_un_settle_amount":"0","erp_payment_ticket_is_verify":false,"erp_collect_ticket_is_verify":"","erp_cash_cost_ticket_is_verify":false,"client":{},"project":{},"supplier":{"id":608,"key":608,"name":"\u6dd8\u5b9d\u7f51"},"contractScan":{},"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":4101,"comment":2},"purchaseClientRels":[{"id":3721,"contract_id":4101,"client_id":2762,"project_id":3910,"client":{"id":2762,"key":2762,"name":"\u4e0a\u6d77\u534e\u8baf\u7f51\u7edc\u7cfb\u7edf\u6709\u9650\u516c\u53f8\uff08\u8fc7\u5355\uff09","sales_rep":1001},"project":{"id":3910,"key":3910,"name":"33\u6240\u9ad8\u6027\u80fd\u9879\u76ee","project_status":3}}],"purchaseContractPayments":[{"id":"12102","key":"12102","contract_id":4101,"value":"655","collected_date":"2025-08-21 14:37:27","created_at":"2025-08-21 14:37:27","created_by":5388,"description":"\u7f51\u94f6\u6c47\u6b3e \u6dd8\u5b9d\u7f51\n","createdBy":{"id":5388,"key":5388,"name":"\u6768\u71d5\u971e","sex":"F","department_id":6},"pct":100}],"purchaseContractInvoices":[{"id":2416,"key":2416,"contract_id":4101,"amount":"655","value":"655","attachment_id":"","from_date":"2025-08-21","description":"","is_draft":false,"attachment":{},"attachmentRelationships":[],"files":[{"id":48744,"object_type":103,"object_id":2416,"attachment_id":27716,"attachment":{"id":27716,"key":27716,"name":"b01737b0-4eaf-34ae-bc5d-e632b1d96e03","extension":"pdf","path":"\/vue\/attachment\/view\/b01737b0-4eaf-34ae-bc5d-e632b1d96e03\/\u5317\u4eac\u62d3\u5b9e\u79d1\u6280\u6709\u9650\u516c\u53f8_4691922230281161702.pdf","orig_name":"\u5317\u4eac\u62d3\u5b9e\u79d1\u6280\u6709\u9650\u516c\u53f8_4691922230281161702.pdf"}}]}],"contractScans":[{"id":48630,"object_type":108,"object_id":4101,"attachment_id":27616,"attachment":{"id":27616,"key":27616,"name":"7831b30f-c451-3276-bd26-3721818e3ce7","extension":"png","path":"\/vue\/attachment\/preview\/7831b30f-c451-3276-bd26-3721818e3ce7\/image.png","orig_name":"image.png"}}],"receiptScans":[],"purchaseContractPaymentCollectionRemindReceivers":[{"id":1423,"user_id":1011,"key":1011,"contract_id":4101,"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":1424,"user_id":5360,"key":5360,"contract_id":4101,"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":840,"key":840,"contract_id":4101,"name":"2025-08-23","value":"655","overdue_days":"","status":1,"pct":100,"collect_status":"\u5df2\u5b8c\u6210"}],"paymentApproves":[{"id":2167,"client_id":2762,"project_id":3910,"title":"\u4ed8\u6b3e\u7533\u8bf7-\u6dd8\u5b9d\u7f51\uff08\u4e2a\u4eba\u5df2\u57ab\u4ed8\uff09","status":2,"next_verify_user":"","verify_at":"2025-08-20 13:11:59","description":"Tristen\uff0c\u7533\u8bf7\u652f\u4ed88\u5957\u6258\u76d8\u91c7\u8d2d\u6b3e\uff0c\u91d1\u989d\uff1a\uffe5655\u5143\uff0c\u8bf7\u5ba1\u6279\uff01\n\n\u5907\u6ce8\uff1a\u7eb8\u8d28\u652f\u51fa\u51ed\u5355\u5df2\u63d0\u4ea4\u5ba1\u6838\uff01","refuse_description":"","is_resubmited":false,"created_by":1011,"created_at":"2025-08-20 12:40:23","updated_at":"2025-08-20 13:11:59","supplier_id":608,"purchase_contract_id":4101,"amount":"655","borrow_amount":"","borrow_collect_day":"","borrow_collect_status":1,"borrow_collect_description":"","borrow_collect_at":"","erp_payment_settle_amount":"655","erp_payment_un_settle_amount":"0","erp_borrow_settle_amount":"0","erp_borrow_un_settle_amount":"0","next_cancel_verify_user":"","cancel_at":"","cancel_description":""}],"costContractAmounts":[],"unreadComments":{},"purchaseContractProductRels":[{"id":61,"purchase_contract_id":4101,"erp_store_id":"","erp_purchase_order_product_id":35,"product_id":2109,"description":"","number":"8","amount":"81.87","total_amount":"655","erpStore":"","product":{"id":2109,"name":"495*750*1.2mm\u673a\u67dc\u6258\u76d8","product_type":18,"product_component":158,"product_brand":134,"product_serie":1695,"product_misc":"","product_qa":"","pn":"","description":"","created_by":1013,"created_at":"2025-08-19 17:19:11","updated_at":"2025-08-21 09:25:35","pinyin_shortcut":"49575012mmjgtp","product_unit":3,"is_renew":false,"productType":{"id":18,"key":18,"name":"\u673a\u623f\u8bbe\u5907"},"productComponent":{"id":158,"key":158,"name":"\u673a\u67dc"},"productBrand":{"id":134,"key":134,"name":"\u7b2c\u4e09\u65b9"},"productSerie":{"id":1695,"key":1695,"name":"\u6258\u76d8"},"productUnit":{"id":3,"key":3,"name":"\u4e2a"}},"erpPurchaseOrderProduct":{"id":35,"erp_purchase_order_id":2022,"erp_store_id":"","product_id":2109,"description":"","number":"8","into_inventory":"8","amount":"81.87","total_amount":"655","last_number":"","last_amount":"","last_total_amount":""}}],"erpPurchaseOrder":{"id":2022,"serial_no":"CGDD-20250819-00004","from_date":"","wrote_date":"2025-08-19","handler":1011,"supplier_id":608,"purchase_contract_id":4101,"erp_store_id":"","status":2,"abstract":"","description":"\u673a\u67dc\u6258\u76d8","verify_type":2,"next_verify_user":"","next_stop_verify_user":"","next_cancel_verify_user":"","verify_at":"2025-08-20 14:59:03","stop_at":"","cancel_at":"","refuse_description":"","is_resubmitted":false,"is_used":true,"is_done":false,"is_settle":false,"number":"8","amount":"654.96","created_by":1011,"stop_description":"","inventory_status":true,"is_cancel":false,"is_old":false,"created_at":"2025-08-19 17:19:46","updated_at":"2025-08-20 14:59:03","erpPurchaseOrderVerifyRels":[{"id":21,"erp_purchase_order_id":2022,"user_id":1011,"status":1,"description":"","verify_at":"2025-08-19 17:40:22"},{"id":22,"erp_purchase_order_id":2022,"user_id":1001,"status":1,"description":"","verify_at":"2025-08-20 14:59:03"}],"erpPurchaseOrderStopVerifyRels":[],"erpPurchaseOrderCancelVerifyRels":[]},"erpPurchaseCost":"","invoiced":655,"approve_amount":655,"un_approve_amount":0,"un_invoiced":0,"payment_collection_remind_ahead_display":"\u65e0","contract_type_display":"\u4ea7\u54c1\u5408\u540c","collected":"655","un_collected":0,"collected_plan":655,"is_collected":true,"can_update":true,"can_update_cost":false,"can_update_file":true,"can_delete":true,"unread":0,"bgcolor":"#89c541","product_amount":655,"product_number":8,"is_done":true,"cost_done_display":false,"cost_un_done_display":false,"done_display":true},{"id":4098,"supplier_id":608,"contract_type":1,"signed_at":"2025-08-19","amount":"365","handler":1011,"description":"\u82f1\u6807\u63d2\u5934\uff0c10A\u7535\u6e90\u7ebf","contract_scan":"","created_by":1011,"created_at":"2025-08-19 15:53:43","updated_at":"2025-08-19 15:53:54","client_id":"","project_id":"","sales_rep":"","serial_no":"\u8ba2\u5355\u53f7: 4692052404660161702","payment_collection_remind_ahead":"","including_tax":true,"is_save_collection":true,"save_collection_at":"2025-08-19 15:53:54","is_chargeback":false,"cost_type":1,"is_draft":false,"is_verify":false,"is_refuse":false,"erp_settle_amount":"365","erp_un_settle_amount":"0","erp_payment_ticket_is_verify":false,"erp_collect_ticket_is_verify":"","erp_cash_cost_ticket_is_verify":false,"client":{},"project":{},"supplier":{"id":608,"key":608,"name":"\u6dd8\u5b9d\u7f51"},"contractScan":{},"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":4098,"comment":2},"purchaseClientRels":[{"id":3731,"contract_id":4098,"client_id":2553,"project_id":3751,"client":{"id":2553,"key":2553,"name":"\u9752\u5c9b\u9890\u6770\u9e3f\u5229\u79d1\u6280\u6709\u9650\u516c\u53f8","sales_rep":1001},"project":{"id":3751,"key":3751,"name":"10\u53f0 PA445 \u8bbe\u5907\u91c7\u8d2d\u9879\u76ee\uff08\u6c99\u7279\u9879\u76ee\uff09","project_status":3}}],"purchaseContractPayments":[{"id":"12101","key":"12101","contract_id":4098,"value":"365","collected_date":"2025-08-21 14:36:52","created_at":"2025-08-21 14:36:52","created_by":5388,"description":"\u7f51\u94f6\u6c47\u6b3e \u6dd8\u5b9d\u7f51","createdBy":{"id":5388,"key":5388,"name":"\u6768\u71d5\u971e","sex":"F","department_id":6},"pct":100}],"purchaseContractInvoices":[{"id":2415,"key":2415,"contract_id":4098,"amount":"365","value":"365","attachment_id":"","from_date":"2025-08-21","description":"","is_draft":false,"attachment":{},"attachmentRelationships":[],"files":[{"id":48742,"object_type":103,"object_id":2415,"attachment_id":27715,"attachment":{"id":27715,"key":27715,"name":"0f4026ad-a3f9-398a-a8cd-676626f3813e","extension":"pdf","path":"\/vue\/attachment\/view\/0f4026ad-a3f9-398a-a8cd-676626f3813e\/\u5317\u4eac\u62d3\u5b9e\u79d1\u6280\u6709\u9650\u516c\u53f8_4692052404660161702.pdf","orig_name":"\u5317\u4eac\u62d3\u5b9e\u79d1\u6280\u6709\u9650\u516c\u53f8_4692052404660161702.pdf"}}]}],"contractScans":[{"id":48628,"object_type":108,"object_id":4098,"attachment_id":27614,"attachment":{"id":27614,"key":27614,"name":"eec80693-f717-3681-bf24-86ebad5a5873","extension":"png","path":"\/vue\/attachment\/preview\/eec80693-f717-3681-bf24-86ebad5a5873\/image.png","orig_name":"image.png"}}],"receiptScans":[],"purchaseContractPaymentCollectionRemindReceivers":[{"id":1419,"user_id":1011,"key":1011,"contract_id":4098,"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":1420,"user_id":5360,"key":5360,"contract_id":4098,"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":838,"key":838,"contract_id":4098,"name":"2025-08-23","value":"365","overdue_days":"","status":1,"pct":100,"collect_status":"\u5df2\u5b8c\u6210"}],"paymentApproves":[{"id":2168,"client_id":2553,"project_id":3751,"title":"\u4ed8\u6b3e\u7533\u8bf7-\u6dd8\u5b9d\u7f51\uff08\u4e2a\u4eba\u5df2\u57ab\u4ed8\uff09","status":2,"next_verify_user":"","verify_at":"2025-08-20 13:11:53","description":"Tristen\uff0c\u7533\u8bf7\u652f\u4ed820\u6761\u7535\u6e90\u7ebf\u91c7\u8d2d\u6b3e\uff0c\u91d1\u989d\uff1a\uffe5365\u5143\uff0c\u8bf7\u5ba1\u6279\uff01\n\n\u5907\u6ce8\uff1a\u7eb8\u8d28\u652f\u51fa\u51ed\u5355\u5df2\u63d0\u4ea4\u5ba1\u6838\uff01","refuse_description":"","is_resubmited":false,"created_by":1011,"created_at":"2025-08-20 12:41:33","updated_at":"2025-08-20 13:11:53","supplier_id":608,"purchase_contract_id":4098,"amount":"365","borrow_amount":"","borrow_collect_day":"","borrow_collect_status":1,"borrow_collect_description":"","borrow_collect_at":"","erp_payment_settle_amount":"365","erp_payment_un_settle_amount":"0","erp_borrow_settle_amount":"0","erp_borrow_un_settle_amount":"0","next_cancel_verify_user":"","cancel_at":"","cancel_description":""}],"costContractAmounts":[],"unreadComments":{},"purchaseContractProductRels":[{"id":56,"purchase_contract_id":4098,"erp_store_id":"","erp_purchase_order_product_id":30,"product_id":2010,"description":"","number":"20","amount":"18.25","total_amount":"365","erpStore":"","product":{"id":2010,"name":"10A\u4e09\u63d2\u5934\u8f6c16A\u4e09\u5b54C19 \u670d\u52a1\u5668\u7535\u6e90\u7ebf","product_type":18,"product_component":201,"product_brand":249,"product_serie":1641,"product_misc":"","product_qa":"","pn":"","description":" 3*1.5\u5e73\u65b9 1.8\u7c73","created_by":1013,"created_at":"2025-06-19 14:23:37","updated_at":"2025-08-21 13:54:21","pinyin_shortcut":"10Asctz16AskC19fwqdyx","product_unit":6,"is_renew":false,"productType":{"id":18,"key":18,"name":"\u673a\u623f\u8bbe\u5907"},"productComponent":{"id":201,"key":201,"name":"\u673a\u623f\u7406\u7ebf\u6750\u6599\u5de5\u5177"},"productBrand":{"id":249,"key":249,"name":"\u5e7f\u660c\u5174"},"productSerie":{"id":1641,"key":1641,"name":"\u7535\u6e90\u7ebf"},"productUnit":{"id":6,"key":6,"name":"\u6761"}},"erpPurchaseOrderProduct":{"id":30,"erp_purchase_order_id":2020,"erp_store_id":"","product_id":2010,"description":"","number":"20","into_inventory":"20","amount":"18.25","total_amount":"365","last_number":"","last_amount":"","last_total_amount":""}}],"erpPurchaseOrder":{"id":2020,"serial_no":"CGDD-20250819-00002","from_date":"","wrote_date":"2025-08-19","handler":1011,"supplier_id":608,"purchase_contract_id":4098,"erp_store_id":"","status":2,"abstract":"","description":"\u82f1\u6807\u63d2\u5934\uff0c10A\u7535\u6e90\u7ebf","verify_type":2,"next_verify_user":"","next_stop_verify_user":"","next_cancel_verify_user":"","verify_at":"2025-08-20 14:59:46","stop_at":"","cancel_at":"","refuse_description":"","is_resubmitted":false,"is_used":true,"is_done":false,"is_settle":false,"number":"20","amount":"365","created_by":1011,"stop_description":"","inventory_status":true,"is_cancel":false,"is_old":false,"created_at":"2025-08-19 15:53:44","updated_at":"2025-08-20 14:59:46","erpPurchaseOrderVerifyRels":[{"id":17,"erp_purchase_order_id":2020,"user_id":1011,"status":1,"description":"","verify_at":"2025-08-19 15:54:13"},{"id":18,"erp_purchase_order_id":2020,"user_id":1001,"status":1,"description":"","verify_at":"2025-08-20 14:59:46"}],"erpPurchaseOrderStopVerifyRels":[],"erpPurchaseOrderCancelVerifyRels":[]},"erpPurchaseCost":"","invoiced":365,"approve_amount":365,"un_approve_amount":0,"un_invoiced":0,"payment_collection_remind_ahead_display":"\u65e0","contract_type_display":"\u4ea7\u54c1\u5408\u540c","collected":"365","un_collected":0,"collected_plan":365,"is_collected":true,"can_update":true,"can_update_cost":false,"can_update_file":true,"can_delete":true,"unread":0,"bgcolor":"#89c541","product_amount":365,"product_number":20,"is_done":true,"cost_done_display":false,"cost_un_done_display":false,"done_display":true},{"id":4088,"supplier_id":608,"contract_type":1,"signed_at":"2025-08-12","amount":"55","handler":1011,"description":"","contract_scan":"","created_by":1011,"created_at":"2025-08-12 10:11:28","updated_at":"2025-08-12 10:12:03","client_id":"","project_id":"","sales_rep":"","serial_no":"\u8ba2\u5355\u53f7: 4671680724983161702","payment_collection_remind_ahead":"","including_tax":false,"is_save_collection":true,"save_collection_at":"2025-08-12 10:11:37","is_chargeback":false,"cost_type":1,"is_draft":false,"is_verify":false,"is_refuse":false,"erp_settle_amount":"55","erp_un_settle_amount":"0","erp_payment_ticket_is_verify":false,"erp_collect_ticket_is_verify":"","erp_cash_cost_ticket_is_verify":false,"client":{},"project":{},"supplier":{"id":608,"key":608,"name":"\u6dd8\u5b9d\u7f51"},"contractScan":{},"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":4088,"comment":4},"purchaseClientRels":[{"id":3691,"contract_id":4088,"client_id":2762,"project_id":3910,"client":{"id":2762,"key":2762,"name":"\u4e0a\u6d77\u534e\u8baf\u7f51\u7edc\u7cfb\u7edf\u6709\u9650\u516c\u53f8\uff08\u8fc7\u5355\uff09","sales_rep":1001},"project":{"id":3910,"key":3910,"name":"33\u6240\u9ad8\u6027\u80fd\u9879\u76ee","project_status":3}}],"purchaseContractPayments":[{"id":"12082","key":"12082","contract_id":4088,"value":"55","collected_date":"2025-08-18 09:21:12","created_at":"2025-08-18 09:21:12","created_by":5388,"description":"\u7f51\u94f6\u6c47\u6b3e \u6dd8\u5b9d\u7f51","createdBy":{"id":5388,"key":5388,"name":"\u6768\u71d5\u971e","sex":"F","department_id":6},"pct":100}],"purchaseContractInvoices":[],"contractScans":[{"id":48384,"object_type":108,"object_id":4088,"attachment_id":27466,"attachment":{"id":27466,"key":27466,"name":"177a3804-d497-3a08-b11a-2565204b7431","extension":"png","path":"\/vue\/attachment\/preview\/177a3804-d497-3a08-b11a-2565204b7431\/image.png","orig_name":"image.png"}}],"receiptScans":[],"purchaseContractPaymentCollectionRemindReceivers":[{"id":1403,"user_id":1011,"key":1011,"contract_id":4088,"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"}}}],"purchaseContractPaymentCollectionRemindDates":[{"id":829,"key":829,"contract_id":4088,"name":"2025-08-15","value":"55","overdue_days":3,"status":1,"pct":100,"collect_status":"\u5df2\u5b8c\u6210"}],"paymentApproves":[{"id":2146,"client_id":2762,"project_id":3910,"title":"\u4ed8\u6b3e\u7533\u8bf7-\u6dd8\u5b9d\u7f51","status":2,"next_verify_user":"","verify_at":"2025-08-13 14:29:23","description":"Tristen\uff0c\u7533\u8bf7\u652f\u4ed8DVD\u53ea\u8bfb\u5149\u9a71\u91c7\u8d2d\u6b3e\uff0c\u91d1\u989d\uff1a\uffe555\u5143\uff0c\u8bf7\u5ba1\u6279\uff01\n\n\u5907\u6ce8\uff1a\u7eb8\u8d28\u652f\u51fa\u51ed\u5355\u5df2\u63d0\u4ea4\u5ba1\u6838\uff01","refuse_description":"","is_resubmited":false,"created_by":1011,"created_at":"2025-08-13 14:11:14","updated_at":"2025-08-13 14:29:23","supplier_id":608,"purchase_contract_id":4088,"amount":"55","borrow_amount":"","borrow_collect_day":"","borrow_collect_status":1,"borrow_collect_description":"","borrow_collect_at":"","erp_payment_settle_amount":"55","erp_payment_un_settle_amount":"0","erp_borrow_settle_amount":"0","erp_borrow_un_settle_amount":"0","next_cancel_verify_user":"","cancel_at":"","cancel_description":""}],"costContractAmounts":[],"unreadComments":{},"purchaseContractProductRels":[{"id":9,"purchase_contract_id":4088,"erp_store_id":"","erp_purchase_order_product_id":6,"product_id":2092,"description":"","number":"1","amount":"55","total_amount":"55","erpStore":"","product":{"id":2092,"name":"USB \u5916\u7f6e\u53ea\u8bfbDVD\u5149\u9a71","product_type":11,"product_component":179,"product_brand":250,"product_serie":1642,"product_misc":"","product_qa":"","pn":"","description":"","created_by":1013,"created_at":"2025-08-12 10:11:10","updated_at":"2025-08-15 11:06:34","pinyin_shortcut":"USBwzzdDVDgq","product_unit":3,"is_renew":false,"productType":{"id":11,"key":11,"name":"\u4e2a\u4eba\u8ba1\u7b97\u673a"},"productComponent":{"id":179,"key":179,"name":"\u914d\u4ef6"},"productBrand":{"id":250,"key":250,"name":"\u5148\u950b"},"productSerie":{"id":1642,"key":1642,"name":"\u5149\u9a71"},"productUnit":{"id":3,"key":3,"name":"\u4e2a"}},"erpPurchaseOrderProduct":{"id":6,"erp_purchase_order_id":2013,"erp_store_id":"","product_id":2092,"description":"","number":"1","into_inventory":"1","amount":"55","total_amount":"55","last_number":"","last_amount":"","last_total_amount":""}}],"erpPurchaseOrder":{"id":2013,"serial_no":"CGDD-20250812-00001","from_date":"","wrote_date":"2025-08-12","handler":1011,"supplier_id":608,"purchase_contract_id":4088,"erp_store_id":"","status":2,"abstract":"","description":"","verify_type":2,"next_verify_user":"","next_stop_verify_user":"","next_cancel_verify_user":"","verify_at":"2025-08-13 14:27:06","stop_at":"","cancel_at":"","refuse_description":"","is_resubmitted":false,"is_used":true,"is_done":false,"is_settle":false,"number":"1","amount":"55","created_by":1011,"stop_description":"","inventory_status":true,"is_cancel":false,"is_old":false,"created_at":"2025-08-12 10:11:28","updated_at":"2025-08-13 14:27:06","erpPurchaseOrderVerifyRels":[{"id":3,"erp_purchase_order_id":2013,"user_id":1011,"status":1,"description":"","verify_at":"2025-08-12 10:12:50"},{"id":4,"erp_purchase_order_id":2013,"user_id":1001,"status":1,"description":"","verify_at":"2025-08-13 14:27:06"}],"erpPurchaseOrderStopVerifyRels":[],"erpPurchaseOrderCancelVerifyRels":[]},"erpPurchaseCost":"","invoiced":0,"approve_amount":55,"un_approve_amount":0,"un_invoiced":0,"payment_collection_remind_ahead_display":"\u65e0","contract_type_display":"\u4ea7\u54c1\u5408\u540c","collected":"55","un_collected":0,"collected_plan":55,"is_collected":true,"can_update":true,"can_update_cost":false,"can_update_file":true,"can_delete":true,"unread":0,"bgcolor":"#89c541","product_amount":55,"product_number":1,"is_done":true,"cost_done_display":false,"cost_un_done_display":false,"done_display":true},{"id":4085,"supplier_id":721,"contract_type":1,"signed_at":"2025-08-11","amount":"18900.00","handler":1011,"description":"\u7ebf\u7f06","contract_scan":"","created_by":1011,"created_at":"2025-08-11 14:07:30","updated_at":"2025-08-12 11:04:50","client_id":"","project_id":"","sales_rep":"","serial_no":"SLZG20250811","payment_collection_remind_ahead":"","including_tax":true,"is_save_collection":true,"save_collection_at":"2025-08-11 14:07:41","is_chargeback":false,"cost_type":1,"is_draft":false,"is_verify":false,"is_refuse":false,"erp_settle_amount":"18900","erp_un_settle_amount":"0","erp_payment_ticket_is_verify":false,"erp_collect_ticket_is_verify":"","erp_cash_cost_ticket_is_verify":false,"client":{},"project":{},"supplier":{"id":721,"key":721,"name":"\u5317\u4eac\u7b97\u529b\u4e4b\u5149\u901a\u4fe1\u6280\u672f\u6709\u9650\u516c\u53f8"},"contractScan":{},"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":4085,"comment":2},"purchaseClientRels":[{"id":3690,"contract_id":4085,"client_id":2762,"project_id":3910,"client":{"id":2762,"key":2762,"name":"\u4e0a\u6d77\u534e\u8baf\u7f51\u7edc\u7cfb\u7edf\u6709\u9650\u516c\u53f8\uff08\u8fc7\u5355\uff09","sales_rep":1001},"project":{"id":3910,"key":3910,"name":"33\u6240\u9ad8\u6027\u80fd\u9879\u76ee","project_status":3}}],"purchaseContractPayments":[{"id":"12072","key":"12072","contract_id":4085,"value":"18900","collected_date":"2025-08-11 16:41:03","created_at":"2025-08-11 16:41:03","created_by":5388,"description":"\u7f51\u94f6\u6c47\u6b3e \u7b97\u529b\u4e4b\u5149","createdBy":{"id":5388,"key":5388,"name":"\u6768\u71d5\u971e","sex":"F","department_id":6},"pct":100}],"purchaseContractInvoices":[{"id":2408,"key":2408,"contract_id":4085,"amount":"18900","value":"18900","attachment_id":"","from_date":"2025-08-18","description":"","is_draft":false,"attachment":{},"attachmentRelationships":[],"files":[{"id":48580,"object_type":103,"object_id":2408,"attachment_id":27594,"attachment":{"id":27594,"key":27594,"name":"374d38d1-a70d-33d0-88f8-fc07b1e23a87","extension":"pdf","path":"\/vue\/attachment\/view\/374d38d1-a70d-33d0-88f8-fc07b1e23a87\/dzfp_25112000000173226193_\u5317\u4eac\u62d3\u5b9e\u79d1\u6280\u6709\u9650\u516c\u53f8_20250818141442.pdf","orig_name":"dzfp_25112000000173226193_\u5317\u4eac\u62d3\u5b9e\u79d1\u6280\u6709\u9650\u516c\u53f8_20250818141442.pdf"}}]}],"contractScans":[{"id":48295,"object_type":108,"object_id":4085,"attachment_id":27421,"attachment":{"id":27421,"key":27421,"name":"52752bc4-3ca5-34fc-bfdf-3137b0e99f31","extension":"pdf","path":"\/vue\/attachment\/preview\/52752bc4-3ca5-34fc-bfdf-3137b0e99f31\/\u5317\u4eac\u62d3\u5b9e\u79d1\u6280-\u5317\u4eac\u7b97\u529b\u4e4b\u514918900-20250811.pdf","orig_name":"\u5317\u4eac\u62d3\u5b9e\u79d1\u6280-\u5317\u4eac\u7b97\u529b\u4e4b\u514918900-20250811.pdf"}}],"receiptScans":[{"id":48387,"object_type":111,"object_id":4085,"attachment_id":27468,"attachment":{"id":27468,"key":27468,"name":"0ec9d29e-f644-39ef-9863-6eb438f17af6","extension":"pdf","path":"\/vue\/attachment\/preview\/0ec9d29e-f644-39ef-9863-6eb438f17af6\/2025_08_12_11_01_55.pdf","orig_name":"2025_08_12_11_01_55.pdf"}}],"purchaseContractPaymentCollectionRemindReceivers":[{"id":1396,"user_id":1011,"key":1011,"contract_id":4085,"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":1397,"user_id":5360,"key":5360,"contract_id":4085,"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":825,"key":825,"contract_id":4085,"name":"2025-08-11","value":"18900","overdue_days":0,"status":1,"pct":100,"collect_status":"\u5df2\u5b8c\u6210"}],"paymentApproves":[{"id":2141,"client_id":2762,"project_id":3910,"title":"\u4ed8\u6b3e\u7533\u8bf7-\u5317\u4eac\u7b97\u529b\u4e4b\u5149\u901a\u4fe1\u6280\u672f\u6709\u9650\u516c\u53f8","status":2,"next_verify_user":"","verify_at":"2025-08-11 15:45:57","description":"Tristen\uff0c\u7533\u8bf7\u652f\u4ed8200G 5M\u7ebf\u7f06 18\u6839*1050\u5408\u8ba118900\u5143\uff0c\u7ebf\u7f06\u5df2\u751f\u4ea7\u5b8c\u6bd5\u4eca\u65e5\u53d1\u51fa\u3002\u8bf7\u5ba1\u6279\uff01\n\n\u6c47\u6b3e\u4fe1\u606f\uff1a\n\u8d26\u6237\uff1a\t\u5317\u4eac\u7b97\u529b\u4e4b\u5149\u901a\u4fe1\u6280\u672f\u6709\u9650\u516c\u53f8\t\n\u8d26\u53f7\uff1a\t8110701013802619054\t\n\u5f00\u6237\u884c\uff1a\t\u4e2d\u4fe1\u94f6\u884c\u80a1\u4efd\u6709\u9650\u516c\u53f8\u5317\u4eac\u798f\u7801\u5927\u53a6\u652f\u884c\n\n\u5907\u6ce8\uff1a\u7eb8\u8d28\u652f\u51fa\u51ed\u5355\u5df2\u63d0\u4ea4\u5ba1\u6838\uff01","refuse_description":"","is_resubmited":false,"created_by":1011,"created_at":"2025-08-11 14:36:01","updated_at":"2025-08-11 15:45:57","supplier_id":721,"purchase_contract_id":4085,"amount":"18900","borrow_amount":"","borrow_collect_day":"","borrow_collect_status":1,"borrow_collect_description":"","borrow_collect_at":"","erp_payment_settle_amount":"0","erp_payment_un_settle_amount":"18900","erp_borrow_settle_amount":"0","erp_borrow_un_settle_amount":"0","next_cancel_verify_user":"","cancel_at":"","cancel_description":""}],"costContractAmounts":[],"unreadComments":{},"purchaseContractProductRels":[{"id":4,"purchase_contract_id":4085,"erp_store_id":"","erp_purchase_order_product_id":3,"product_id":2089,"description":"","number":"18","amount":"1050","total_amount":"18900","erpStore":"","product":{"id":2089,"name":"Q56-200G-A5H","product_type":4,"product_component":43,"product_brand":150,"product_serie":716,"product_misc":"","product_qa":"","pn":"","description":"QSFP56 AOC 200G 5M\uff0c\u9ad8\u6027\u80fd\u7ebf\u7f06","created_by":1013,"created_at":"2025-08-11 14:05:04","updated_at":"2025-08-15 11:06:34","pinyin_shortcut":"Q56200GA5H","product_unit":6,"is_renew":false,"productType":{"id":4,"key":4,"name":"\u7f51\u7edc\u8bbe\u5907 "},"productComponent":{"id":43,"key":43,"name":"\u7f51\u7edc\u8bbe\u5907\u914d\u4ef6"},"productBrand":{"id":150,"key":150,"name":"\u7eb3\u591a\u5fb7"},"productSerie":{"id":716,"key":716,"name":"\u7ebf\u7f06"},"productUnit":{"id":6,"key":6,"name":"\u6761"}},"erpPurchaseOrderProduct":{"id":3,"erp_purchase_order_id":2012,"erp_store_id":"","product_id":2089,"description":"","number":"18","into_inventory":"18","amount":"1050","total_amount":"18900","last_number":"","last_amount":"","last_total_amount":""}}],"erpPurchaseOrder":{"id":2012,"serial_no":"CGDD-20250811-00001","from_date":"","wrote_date":"2025-08-11","handler":1011,"supplier_id":721,"purchase_contract_id":4085,"erp_store_id":"","status":2,"abstract":"","description":"\u7ebf\u7f06","verify_type":2,"next_verify_user":"","next_stop_verify_user":"","next_cancel_verify_user":"","verify_at":"2025-08-11 16:26:47","stop_at":"","cancel_at":"","refuse_description":"","is_resubmitted":false,"is_used":true,"is_done":false,"is_settle":false,"number":"18","amount":"18900","created_by":1011,"stop_description":"","inventory_status":true,"is_cancel":false,"is_old":false,"created_at":"2025-08-11 14:07:30","updated_at":"2025-08-11 16:26:47","erpPurchaseOrderVerifyRels":[{"id":1,"erp_purchase_order_id":2012,"user_id":1011,"status":1,"description":"","verify_at":"2025-08-11 14:27:18"},{"id":2,"erp_purchase_order_id":2012,"user_id":1001,"status":1,"description":"","verify_at":"2025-08-11 16:26:47"}],"erpPurchaseOrderStopVerifyRels":[],"erpPurchaseOrderCancelVerifyRels":[]},"erpPurchaseCost":"","invoiced":18900,"approve_amount":18900,"un_approve_amount":0,"un_invoiced":0,"payment_collection_remind_ahead_display":"\u65e0","contract_type_display":"\u4ea7\u54c1\u5408\u540c","collected":"18900","un_collected":0,"collected_plan":18900,"is_collected":true,"can_update":true,"can_update_cost":false,"can_update_file":true,"can_delete":true,"unread":0,"bgcolor":"#89c541","product_amount":18900,"product_number":18,"is_done":true,"cost_done_display":false,"cost_un_done_display":false,"done_display":true},{"id":4090,"supplier_id":262,"contract_type":1,"signed_at":"2025-08-08","amount":"979.00","handler":5360,"description":"","contract_scan":"","created_by":5360,"created_at":"2025-08-13 11:20:57","updated_at":"2025-08-13 11:21:12","client_id":"","project_id":"","sales_rep":"","serial_no":"\u8ba2\u5355\u53f7\uff1a 320185123830","payment_collection_remind_ahead":"1 day","including_tax":true,"is_save_collection":true,"save_collection_at":"2025-08-13 11:21:12","is_chargeback":false,"cost_type":1,"is_draft":false,"is_verify":false,"is_refuse":false,"erp_settle_amount":"979","erp_un_settle_amount":"0","erp_payment_ticket_is_verify":false,"erp_collect_ticket_is_verify":"","erp_cash_cost_ticket_is_verify":false,"client":{},"project":{},"supplier":{"id":262,"key":262,"name":"\u4eac\u4e1c\u5546\u57ce"},"contractScan":{},"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":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"}},"commentCount":{"object_id":4090,"comment":2},"purchaseClientRels":[{"id":3698,"contract_id":4090,"client_id":2762,"project_id":3910,"client":{"id":2762,"key":2762,"name":"\u4e0a\u6d77\u534e\u8baf\u7f51\u7edc\u7cfb\u7edf\u6709\u9650\u516c\u53f8\uff08\u8fc7\u5355\uff09","sales_rep":1001},"project":{"id":3910,"key":3910,"name":"33\u6240\u9ad8\u6027\u80fd\u9879\u76ee","project_status":3}}],"purchaseContractPayments":[{"id":"12078","key":"12078","contract_id":4090,"value":"979","collected_date":"2025-08-18 09:16:57","created_at":"2025-08-18 09:16:57","created_by":5388,"description":"\u7f51\u94f6\u6c47\u6b3e \u4eac\u4e1c\u5546\u57ce\n","createdBy":{"id":5388,"key":5388,"name":"\u6768\u71d5\u971e","sex":"F","department_id":6},"pct":100}],"purchaseContractInvoices":[{"id":2400,"key":2400,"contract_id":4090,"amount":"979","value":"979","attachment_id":"","from_date":"2025-08-09","description":"","is_draft":false,"attachment":{},"attachmentRelationships":[],"files":[{"id":48413,"object_type":103,"object_id":2400,"attachment_id":27490,"attachment":{"id":27490,"key":27490,"name":"5226e182-8f33-3014-9028-b293c27dc6d5","extension":"pdf","path":"\/vue\/attachment\/view\/5226e182-8f33-3014-9028-b293c27dc6d5\/digital_25117000001024860230.pdf","orig_name":"digital_25117000001024860230.pdf"}}]}],"contractScans":[{"id":48411,"object_type":108,"object_id":4090,"attachment_id":27489,"attachment":{"id":27489,"key":27489,"name":"ab8c6c6a-630d-313c-bd98-d1312f3f2ec7","extension":"png","path":"\/vue\/attachment\/preview\/ab8c6c6a-630d-313c-bd98-d1312f3f2ec7\/WX20250813-111928@2x.png","orig_name":"WX20250813-111928@2x.png"}}],"receiptScans":[],"purchaseContractPaymentCollectionRemindReceivers":[{"id":1405,"user_id":1011,"key":1011,"contract_id":4090,"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":1406,"user_id":5360,"key":5360,"contract_id":4090,"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":831,"key":831,"contract_id":4090,"name":"2025-08-22","value":"979","overdue_days":"","status":1,"pct":100,"collect_status":"\u5df2\u5b8c\u6210"}],"paymentApproves":[{"id":2148,"client_id":2762,"project_id":3910,"title":"\u4ed8\u6b3e\u7533\u8bf7\u2014\u4eac\u4e1c\u5546\u57ce\uff08\u4e2a\u4eba\u5df2\u652f\u4ed8\uff09","status":2,"next_verify_user":"","verify_at":"2025-08-13 13:13:10","description":"\u8001\u5927\uff0c\u82b3\u59d0\uff1a\u7533\u8bf7\u652f\u4ed833\u6240\u5927\u6a21\u578b\u6240\u97002T\u79fb\u52a8\u786c\u76d8\u91c7\u8d2d\u6b3e\uff0c\u91d1\u989d979\u5143\uff0c\u8bf7\u5ba1\u6279\uff01\n\n\u5907\u6ce8\uff1a\u7eb8\u8d28\u5355\u636e\u5df2\u63d0\u4ea4","refuse_description":"","is_resubmited":false,"created_by":5360,"created_at":"2025-08-13 11:55:11","updated_at":"2025-08-13 13:13:10","supplier_id":262,"purchase_contract_id":4090,"amount":"979","borrow_amount":"","borrow_collect_day":"","borrow_collect_status":1,"borrow_collect_description":"","borrow_collect_at":"","erp_payment_settle_amount":"979","erp_payment_un_settle_amount":"0","erp_borrow_settle_amount":"0","erp_borrow_un_settle_amount":"0","next_cancel_verify_user":"","cancel_at":"","cancel_description":""}],"costContractAmounts":[],"unreadComments":{},"purchaseContractProductRels":[{"id":21,"purchase_contract_id":4090,"erp_store_id":"","erp_purchase_order_product_id":13,"product_id":2094,"description":"","number":"1","amount":"979","total_amount":"979","erpStore":"","product":{"id":2094,"name":"WDBAGF0020BGY","product_type":11,"product_component":179,"product_brand":260,"product_serie":1690,"product_misc":"","product_qa":"","pn":"","description":"\u897f\u90e8\u6570\u636e\uff08WD\uff092TB NVMe \u79fb\u52a8\u56fa\u6001\u786c\u76d8\uff08PSSD\uff09My Passport\u968f\u884cSSD type-c\u63a5\u53e3 1050MB\/s \u624b\u673a\u76f4\u8fde\u7b14\u8bb0\u672c\u4e24\u7528\u5916\u63a5","created_by":1013,"created_at":"2025-08-13 11:18:56","updated_at":"2025-08-15 11:06:34","pinyin_shortcut":"WDBAGF0020BGY","product_unit":3,"is_renew":false,"productType":{"id":11,"key":11,"name":"\u4e2a\u4eba\u8ba1\u7b97\u673a"},"productComponent":{"id":179,"key":179,"name":"\u914d\u4ef6"},"productBrand":{"id":260,"key":260,"name":"\u897f\u90e8\u6570\u636e"},"productSerie":{"id":1690,"key":1690,"name":"\u786c\u76d8"},"productUnit":{"id":3,"key":3,"name":"\u4e2a"}},"erpPurchaseOrderProduct":{"id":13,"erp_purchase_order_id":2015,"erp_store_id":"","product_id":2094,"description":"","number":"1","into_inventory":"1","amount":"979","total_amount":"979","last_number":"","last_amount":"","last_total_amount":""}}],"erpPurchaseOrder":{"id":2015,"serial_no":"CGDD-20250813-00001","from_date":"","wrote_date":"2025-08-08","handler":5360,"supplier_id":262,"purchase_contract_id":4090,"erp_store_id":"","status":2,"abstract":"","description":"","verify_type":2,"next_verify_user":"","next_stop_verify_user":"","next_cancel_verify_user":"","verify_at":"2025-08-13 14:28:45","stop_at":"","cancel_at":"","refuse_description":"","is_resubmitted":false,"is_used":true,"is_done":false,"is_settle":false,"number":"1","amount":"979","created_by":5360,"stop_description":"","inventory_status":true,"is_cancel":false,"is_old":false,"created_at":"2025-08-13 11:20:57","updated_at":"2025-08-13 14:28:45","erpPurchaseOrderVerifyRels":[{"id":7,"erp_purchase_order_id":2015,"user_id":1011,"status":1,"description":"","verify_at":"2025-08-13 11:21:37"},{"id":8,"erp_purchase_order_id":2015,"user_id":1001,"status":1,"description":"","verify_at":"2025-08-13 14:28:45"}],"erpPurchaseOrderStopVerifyRels":[],"erpPurchaseOrderCancelVerifyRels":[]},"erpPurchaseCost":"","invoiced":979,"approve_amount":979,"un_approve_amount":0,"un_invoiced":0,"payment_collection_remind_ahead_display":"\u63d0\u524d1\u5929","contract_type_display":"\u4ea7\u54c1\u5408\u540c","collected":"979","un_collected":0,"collected_plan":979,"is_collected":true,"can_update":true,"can_update_cost":false,"can_update_file":true,"can_delete":true,"unread":0,"bgcolor":"#89c541","product_amount":979,"product_number":1,"is_done":true,"cost_done_display":false,"cost_un_done_display":false,"done_display":true},{"id":4081,"supplier_id":478,"contract_type":1,"signed_at":"2025-08-07","amount":"783.00","handler":1011,"description":"","contract_scan":"","created_by":1011,"created_at":"2025-08-07 09:42:55","updated_at":"2025-08-07 09:43:07","client_id":"","project_id":"","sales_rep":"","serial_no":"TSKJ20250807-HYF-001","payment_collection_remind_ahead":"","including_tax":true,"is_save_collection":true,"save_collection_at":"2025-08-07 09:43:07","is_chargeback":false,"cost_type":1,"is_draft":false,"is_verify":false,"is_refuse":false,"erp_settle_amount":"0","erp_un_settle_amount":"783","erp_payment_ticket_is_verify":false,"erp_collect_ticket_is_verify":"","erp_cash_cost_ticket_is_verify":false,"client":{},"project":{},"supplier":{"id":478,"key":478,"name":"\u5317\u4eac\u957f\u987a\u7f51\u8054\u79d1\u6280\u6709\u9650\u516c\u53f8"},"contractScan":{},"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":4081,"comment":1},"purchaseClientRels":[{"id":3695,"contract_id":4081,"client_id":2762,"project_id":3910,"client":{"id":2762,"key":2762,"name":"\u4e0a\u6d77\u534e\u8baf\u7f51\u7edc\u7cfb\u7edf\u6709\u9650\u516c\u53f8\uff08\u8fc7\u5355\uff09","sales_rep":1001},"project":{"id":3910,"key":3910,"name":"33\u6240\u9ad8\u6027\u80fd\u9879\u76ee","project_status":3}}],"purchaseContractPayments":[],"purchaseContractInvoices":[],"contractScans":[],"receiptScans":[],"purchaseContractPaymentCollectionRemindReceivers":[{"id":1388,"user_id":1011,"key":1011,"contract_id":4081,"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":1389,"user_id":5360,"key":5360,"contract_id":4081,"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":820,"key":820,"contract_id":4081,"name":"2025-09-07","value":"783","overdue_days":"","status":0,"pct":100,"collect_status":"\u903e\u671f12\u5929"}],"paymentApproves":[],"costContractAmounts":[],"unreadComments":{},"purchaseContractProductRels":[],"erpPurchaseOrder":{"id":2010,"serial_no":"CGDD-20250807-00001","from_date":"","wrote_date":"2025-08-07","handler":1011,"supplier_id":478,"purchase_contract_id":4081,"erp_store_id":"","status":2,"abstract":"","description":"","verify_type":1,"next_verify_user":"","next_stop_verify_user":"","next_cancel_verify_user":"","verify_at":"2025-08-07 09:42:55","stop_at":"","cancel_at":"","refuse_description":"","is_resubmitted":false,"is_used":false,"is_done":false,"is_settle":false,"number":"0","amount":"783.00","created_by":1011,"stop_description":"","inventory_status":false,"is_cancel":false,"is_old":true,"created_at":"2025-08-07 09:42:55","updated_at":"2025-08-07 09:43:07","erpPurchaseOrderVerifyRels":[],"erpPurchaseOrderStopVerifyRels":[],"erpPurchaseOrderCancelVerifyRels":[]},"erpPurchaseCost":"","invoiced":0,"approve_amount":0,"un_approve_amount":783,"un_invoiced":783,"payment_collection_remind_ahead_display":"\u65e0","contract_type_display":"\u4ea7\u54c1\u5408\u540c","collected":"0","un_collected":783,"collected_plan":783,"is_collected":false,"can_update":true,"can_update_cost":false,"can_update_file":true,"can_delete":true,"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},{"id":4077,"supplier_id":38,"contract_type":1,"signed_at":"2025-08-06","amount":"63000.00","handler":1013,"description":"\u5185\u5b58 28\u683964GB DDR5 5600MHz ECC RDIMM ","contract_scan":"","created_by":1011,"created_at":"2025-08-01 13:30:47","updated_at":"2025-08-22 14:24:17","client_id":"","project_id":"","sales_rep":"","serial_no":"YJTS20250806","payment_collection_remind_ahead":"1 day","including_tax":true,"is_save_collection":true,"save_collection_at":"2025-08-22 14:24:17","is_chargeback":false,"cost_type":1,"is_draft":false,"is_verify":false,"is_refuse":false,"erp_settle_amount":"63000","erp_un_settle_amount":"0","erp_payment_ticket_is_verify":false,"erp_collect_ticket_is_verify":"","erp_cash_cost_ticket_is_verify":false,"client":{},"project":{},"supplier":{"id":38,"key":38,"name":"\u5317\u4eac\u4e91\u9526\u975e\u51e1\u79d1\u6280\u6709\u9650\u516c\u53f8 \/\u5317\u4eac\u5929\u52e4\u76ca\u8fbe\u79d1\u6280\u6709\u9650\u516c\u53f8\u3010\u5b89\u82af\u64ce\u5929(\u5929\u6d25)\u79d1\u6280\u6709\u9650\u516c\u53f8\u3011\/\u5317\u4eac\u5747\u4f18\u79d1\u6280\u6709\u9650\u516c\u53f8"},"contractScan":{},"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":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","avatar":{"id":34,"user_id":1013,"name":"\/files\/cdn\/a57be577deb434\/avatar\/25ef1fe7-8dda-3daa-b8ea-9fabd0a47439.png"}},"commentCount":{"object_id":4077,"comment":2},"purchaseClientRels":[{"id":3693,"contract_id":4077,"client_id":2762,"project_id":3910,"client":{"id":2762,"key":2762,"name":"\u4e0a\u6d77\u534e\u8baf\u7f51\u7edc\u7cfb\u7edf\u6709\u9650\u516c\u53f8\uff08\u8fc7\u5355\uff09","sales_rep":1001},"project":{"id":3910,"key":3910,"name":"33\u6240\u9ad8\u6027\u80fd\u9879\u76ee","project_status":3}}],"purchaseContractPayments":[{"id":"12113","key":"12113","contract_id":4077,"value":"63000","collected_date":"2025-08-22 14:35:44","created_at":"2025-08-22 14:35:44","created_by":5388,"description":"\u7f51\u94f6\u6c47\u6b3e \u4e91\u9526\u975e\u51e1","createdBy":{"id":5388,"key":5388,"name":"\u6768\u71d5\u971e","sex":"F","department_id":6},"pct":100}],"purchaseContractInvoices":[{"id":2403,"key":2403,"contract_id":4077,"amount":"63000","value":"63000","attachment_id":"","from_date":"2025-08-15","description":"","is_draft":false,"attachment":{},"attachmentRelationships":[],"files":[{"id":48794,"object_type":103,"object_id":2403,"attachment_id":27529,"attachment":{"id":27529,"key":27529,"name":"d9831624-fa1e-3be8-b588-fd29951da96e","extension":"pdf","path":"\/vue\/attachment\/view\/d9831624-fa1e-3be8-b588-fd29951da96e\/dzfp_25112000000171776960_\u5317\u4eac\u62d3\u5b9e\u79d1\u6280\u6709\u9650\u516c\u53f8_20250815171235.pdf","orig_name":"dzfp_25112000000171776960_\u5317\u4eac\u62d3\u5b9e\u79d1\u6280\u6709\u9650\u516c\u53f8_20250815171235.pdf"}}]}],"contractScans":[{"id":37553,"object_type":108,"object_id":4077,"attachment_id":27289,"attachment":{"id":27289,"key":27289,"name":"b6d0ff11-bb8b-3eba-8cd1-08e0386639b6","extension":"pdf","path":"\/vue\/attachment\/preview\/b6d0ff11-bb8b-3eba-8cd1-08e0386639b6\/YJTS20250806.pdf","orig_name":"YJTS20250806.pdf"}}],"receiptScans":[],"purchaseContractPaymentCollectionRemindReceivers":[{"id":1447,"user_id":1011,"key":1011,"contract_id":4077,"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":1448,"user_id":5360,"key":5360,"contract_id":4077,"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":852,"key":852,"contract_id":4077,"name":"2025-08-22","value":"63000","overdue_days":0,"status":1,"pct":100,"collect_status":"\u5df2\u5b8c\u6210"}],"paymentApproves":[{"id":2193,"client_id":2762,"project_id":3910,"title":"\u4ed8\u6b3e\u7533\u8bf7-\u5317\u4eac\u4e91\u9526\u975e\u51e1\u79d1\u6280\u6709\u9650\u516c\u53f8","status":2,"next_verify_user":"","verify_at":"2025-08-22 14:28:46","description":"Tristen\uff0c\u7533\u8bf7\u4eca\u65e5\u652f\u4ed8\u5185\u5b58\u91c7\u8d2d\u6b3e\u91d1\u989d\uff1a\uffe563000\u5143\uff0c\u8bf7\u5ba1\u6279\uff01\n\n\u5907\u6ce8\uff1a\u7eb8\u8d28\u652f\u51fa\u51ed\u5355\u5df2\u63d0\u4ea4\u5ba1\u6838\uff01","refuse_description":"","is_resubmited":false,"created_by":1011,"created_at":"2025-08-22 14:26:54","updated_at":"2025-08-22 14:28:46","supplier_id":38,"purchase_contract_id":4077,"amount":"63000","borrow_amount":"","borrow_collect_day":"","borrow_collect_status":1,"borrow_collect_description":"","borrow_collect_at":"","erp_payment_settle_amount":"63000","erp_payment_un_settle_amount":"0","erp_borrow_settle_amount":"0","erp_borrow_un_settle_amount":"0","next_cancel_verify_user":"","cancel_at":"","cancel_description":""}],"costContractAmounts":[],"unreadComments":{},"purchaseContractProductRels":[],"erpPurchaseOrder":{"id":2006,"serial_no":"CGDD-20250801-00003","from_date":"","wrote_date":"2025-08-06","handler":1013,"supplier_id":38,"purchase_contract_id":4077,"erp_store_id":"","status":2,"abstract":"","description":"\u5185\u5b58 28\u683964GB DDR5 5600MHz ECC RDIMM ","verify_type":1,"next_verify_user":"","next_stop_verify_user":"","next_cancel_verify_user":"","verify_at":"2025-08-01 13:30:47","stop_at":"","cancel_at":"","refuse_description":"","is_resubmitted":false,"is_used":false,"is_done":false,"is_settle":false,"number":"0","amount":"63000.00","created_by":1011,"stop_description":"","inventory_status":false,"is_cancel":false,"is_old":true,"created_at":"2025-08-01 13:30:47","updated_at":"2025-08-06 11:08:00","erpPurchaseOrderVerifyRels":[],"erpPurchaseOrderStopVerifyRels":[],"erpPurchaseOrderCancelVerifyRels":[]},"erpPurchaseCost":"","invoiced":63000,"approve_amount":63000,"un_approve_amount":0,"un_invoiced":0,"payment_collection_remind_ahead_display":"\u63d0\u524d1\u5929","contract_type_display":"\u4ea7\u54c1\u5408\u540c","collected":"63000","un_collected":0,"collected_plan":63000,"is_collected":true,"can_update":true,"can_update_cost":false,"can_update_file":true,"can_delete":true,"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},{"id":4076,"supplier_id":676,"contract_type":1,"signed_at":"2025-08-01","amount":"1888000.00","handler":1011,"description":"","contract_scan":"","created_by":1011,"created_at":"2025-08-01 13:27:49","updated_at":"2025-08-04 11:35:32","client_id":"","project_id":"","sales_rep":"","serial_no":"ALX-Q20250731-0529 ","payment_collection_remind_ahead":"1 day","including_tax":true,"is_save_collection":true,"save_collection_at":"2025-08-01 13:28:00","is_chargeback":false,"cost_type":1,"is_draft":false,"is_verify":false,"is_refuse":false,"erp_settle_amount":"1888000","erp_un_settle_amount":"0","erp_payment_ticket_is_verify":false,"erp_collect_ticket_is_verify":"","erp_cash_cost_ticket_is_verify":false,"client":{},"project":{},"supplier":{"id":676,"key":676,"name":"\u5317\u4eac\u5b89\u8054\u901a\u79d1\u6280\u6709\u9650\u516c\u53f8"},"contractScan":{},"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":4076,"comment":4},"purchaseClientRels":[{"id":3692,"contract_id":4076,"client_id":2762,"project_id":3910,"client":{"id":2762,"key":2762,"name":"\u4e0a\u6d77\u534e\u8baf\u7f51\u7edc\u7cfb\u7edf\u6709\u9650\u516c\u53f8\uff08\u8fc7\u5355\uff09","sales_rep":1001},"project":{"id":3910,"key":3910,"name":"33\u6240\u9ad8\u6027\u80fd\u9879\u76ee","project_status":3}}],"purchaseContractPayments":[{"id":"12066","key":"12066","contract_id":4076,"value":"1888000","collected_date":"2025-08-04 17:09:32","created_at":"2025-08-04 17:09:32","created_by":1013,"description":"","createdBy":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","department_id":7},"pct":100}],"purchaseContractInvoices":[{"id":2388,"key":2388,"contract_id":4076,"amount":"1888000","value":"1888000","attachment_id":"","from_date":"2025-08-04","description":"","is_draft":false,"attachment":{},"attachmentRelationships":[],"files":[{"id":37478,"object_type":103,"object_id":2388,"attachment_id":27239,"attachment":{"id":27239,"key":27239,"name":"7ec6be19-e1e7-3bb4-92f0-0aa785121ac4","extension":"pdf","path":"\/vue\/attachment\/view\/7ec6be19-e1e7-3bb4-92f0-0aa785121ac4\/dzfp_25112000000162647804_\u5317\u4eac\u5b89\u8054\u901a\u79d1\u6280\u6709\u9650\u516c\u53f8_20250804143748.pdf","orig_name":"dzfp_25112000000162647804_\u5317\u4eac\u5b89\u8054\u901a\u79d1\u6280\u6709\u9650\u516c\u53f8_20250804143748.pdf"}}]}],"contractScans":[{"id":37459,"object_type":108,"object_id":4076,"attachment_id":27226,"attachment":{"id":27226,"key":27226,"name":"81395d9b-7a22-3471-bfdf-fd2dd02b7ab6","extension":"pdf","path":"\/vue\/attachment\/preview\/81395d9b-7a22-3471-bfdf-fd2dd02b7ab6\/2025_08_04_11_25_10.pdf","orig_name":"2025_08_04_11_25_10.pdf"}}],"receiptScans":[],"purchaseContractPaymentCollectionRemindReceivers":[{"id":1370,"user_id":1011,"key":1011,"contract_id":4076,"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":1371,"user_id":5360,"key":5360,"contract_id":4076,"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":810,"key":810,"contract_id":4076,"name":"2025-08-04","value":"1888000","overdue_days":0,"status":1,"pct":100,"collect_status":"\u5df2\u5b8c\u6210"}],"paymentApproves":[{"id":2119,"client_id":2762,"project_id":3910,"title":"\u4ed8\u6b3e\u7533\u8bf7-\u5317\u4eac\u5b89\u8054\u901a\u79d1\u6280\u6709\u9650\u516c\u53f8","status":2,"next_verify_user":"","verify_at":"2025-08-04 11:59:11","description":"Tristen\uff0c\u7533\u8bf7\u652f\u4ed8H200*8GPU\u6a21\u7ec4\u91c7\u8d2d\u6b3e\uff0c\u91d1\u989d\uff1a\uffe51888000\u5143\uff1b\u8bf7\u5ba1\u6279\uff01\n\u660e\u5929\u4e0a\u5348\u4e3b\u673a\u62c9\u53bb\u5bf9\u65b9\u65e0\u5c18\u7ec4\u88c5\u7a7a\u95f4\u53bb\u5b89\u88c5\u8c03\u8bd5\uff0c\u77e5\u6089~\n\n\u6c47\u6b3e\u4fe1\u606f\uff1a\n\u540d\u79f0\uff1a\u5317\u4eac\u5b89\u8054\u901a\u79d1\u6280\u6709\u9650\u516c\u53f8 \n\u5f00\u6237\u884c\uff1a\u4e2d\u56fd\u5de5\u5546\u94f6\u884c\u82cf\u5dde\u6865\u652f\u884c \n\u5e10\u53f7\uff1a0200251809201060217\n\n\u5907\u6ce8\uff1a\u7eb8\u8d28\u5355\u636e\u5df2\u63d0\u4ea4\u5ba1\u6838\uff01","refuse_description":"","is_resubmited":false,"created_by":1011,"created_at":"2025-08-04 11:36:50","updated_at":"2025-08-04 11:59:11","supplier_id":676,"purchase_contract_id":4076,"amount":"1888000","borrow_amount":"","borrow_collect_day":"","borrow_collect_status":0,"borrow_collect_description":"","borrow_collect_at":"","erp_payment_settle_amount":"1888000","erp_payment_un_settle_amount":"0","erp_borrow_settle_amount":"0","erp_borrow_un_settle_amount":"0","next_cancel_verify_user":"","cancel_at":"","cancel_description":""}],"costContractAmounts":[],"unreadComments":{},"purchaseContractProductRels":[],"erpPurchaseOrder":{"id":2005,"serial_no":"CGDD-20250801-00002","from_date":"","wrote_date":"2025-08-01","handler":1011,"supplier_id":676,"purchase_contract_id":4076,"erp_store_id":"","status":2,"abstract":"","description":"","verify_type":1,"next_verify_user":"","next_stop_verify_user":"","next_cancel_verify_user":"","verify_at":"2025-08-01 13:27:49","stop_at":"","cancel_at":"","refuse_description":"","is_resubmitted":false,"is_used":false,"is_done":true,"is_settle":false,"number":"0","amount":"1888000.00","created_by":1011,"stop_description":"","inventory_status":false,"is_cancel":false,"is_old":true,"created_at":"2025-08-01 13:27:49","updated_at":"2025-08-04 11:35:32","erpPurchaseOrderVerifyRels":[],"erpPurchaseOrderStopVerifyRels":[],"erpPurchaseOrderCancelVerifyRels":[]},"erpPurchaseCost":"","invoiced":1888000,"approve_amount":1888000,"un_approve_amount":0,"un_invoiced":0,"payment_collection_remind_ahead_display":"\u63d0\u524d1\u5929","contract_type_display":"\u4ea7\u54c1\u5408\u540c","collected":"1888000","un_collected":0,"collected_plan":1888000,"is_collected":true,"can_update":true,"can_update_cost":false,"can_update_file":true,"can_delete":true,"unread":0,"bgcolor":"#89c541","product_amount":0,"product_number":0,"is_done":true,"cost_done_display":false,"cost_un_done_display":false,"done_display":true},{"id":4075,"supplier_id":718,"contract_type":1,"signed_at":"2025-08-01","amount":"145400.00","handler":1011,"description":"","contract_scan":"","created_by":1011,"created_at":"2025-08-01 13:25:18","updated_at":"2025-08-12 17:24:09","client_id":"","project_id":"","sales_rep":"","serial_no":"BJLXYT20250801","payment_collection_remind_ahead":"1 day","including_tax":true,"is_save_collection":true,"save_collection_at":"2025-08-06 10:53:10","is_chargeback":false,"cost_type":1,"is_draft":false,"is_verify":false,"is_refuse":false,"erp_settle_amount":"0","erp_un_settle_amount":"145400","erp_payment_ticket_is_verify":false,"erp_collect_ticket_is_verify":"","erp_cash_cost_ticket_is_verify":false,"client":{},"project":{},"supplier":{"id":718,"key":718,"name":"\u5317\u4eac\u7406\u60f3\u4e91\u5929\u79d1\u6280\u6709\u9650\u516c\u53f8"},"contractScan":{},"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":4075,"comment":1},"purchaseClientRels":[{"id":3694,"contract_id":4075,"client_id":2762,"project_id":3910,"client":{"id":2762,"key":2762,"name":"\u4e0a\u6d77\u534e\u8baf\u7f51\u7edc\u7cfb\u7edf\u6709\u9650\u516c\u53f8\uff08\u8fc7\u5355\uff09","sales_rep":1001},"project":{"id":3910,"key":3910,"name":"33\u6240\u9ad8\u6027\u80fd\u9879\u76ee","project_status":3}}],"purchaseContractPayments":[],"purchaseContractInvoices":[{"id":2402,"key":2402,"contract_id":4075,"amount":"145400","value":"145400","attachment_id":"","from_date":"2025-08-13","description":"","is_draft":false,"attachment":{},"attachmentRelationships":[],"files":[{"id":48442,"object_type":103,"object_id":2402,"attachment_id":27501,"attachment":{"id":27501,"key":27501,"name":"4289e6cc-3ec8-3c8d-b53f-87548f98bccf","extension":"pdf","path":"\/vue\/attachment\/view\/4289e6cc-3ec8-3c8d-b53f-87548f98bccf\/dzfp_25112000000170072878_\u5317\u4eac\u62d3\u5b9e\u79d1\u6280\u6709\u9650\u516c\u53f8_20250813185001.pdf","orig_name":"dzfp_25112000000170072878_\u5317\u4eac\u62d3\u5b9e\u79d1\u6280\u6709\u9650\u516c\u53f8_20250813185001.pdf"}}]}],"contractScans":[{"id":48395,"object_type":108,"object_id":4075,"attachment_id":27474,"attachment":{"id":27474,"key":27474,"name":"9b300358-3ce6-3486-a1d4-05add429b38f","extension":"pdf","path":"\/vue\/attachment\/preview\/9b300358-3ce6-3486-a1d4-05add429b38f\/\u7406\u60f3\u4e91\u5929.pdf","orig_name":"\u7406\u60f3\u4e91\u5929.pdf"}}],"receiptScans":[],"purchaseContractPaymentCollectionRemindReceivers":[{"id":1382,"user_id":1011,"key":1011,"contract_id":4075,"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":1383,"user_id":5360,"key":5360,"contract_id":4075,"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":817,"key":817,"contract_id":4075,"name":"2025-09-05","value":"145400","overdue_days":"","status":0,"pct":100,"collect_status":"\u903e\u671f14\u5929"}],"paymentApproves":[],"costContractAmounts":[],"unreadComments":{},"purchaseContractProductRels":[],"erpPurchaseOrder":{"id":2004,"serial_no":"CGDD-20250801-00001","from_date":"","wrote_date":"2025-08-01","handler":1011,"supplier_id":718,"purchase_contract_id":4075,"erp_store_id":"","status":2,"abstract":"","description":"","verify_type":1,"next_verify_user":"","next_stop_verify_user":"","next_cancel_verify_user":"","verify_at":"2025-08-01 13:25:18","stop_at":"","cancel_at":"","refuse_description":"","is_resubmitted":false,"is_used":false,"is_done":false,"is_settle":false,"number":"0","amount":"145400.00","created_by":1011,"stop_description":"","inventory_status":false,"is_cancel":false,"is_old":true,"created_at":"2025-08-01 13:25:18","updated_at":"2025-08-06 10:53:10","erpPurchaseOrderVerifyRels":[],"erpPurchaseOrderStopVerifyRels":[],"erpPurchaseOrderCancelVerifyRels":[]},"erpPurchaseCost":"","invoiced":145400,"approve_amount":0,"un_approve_amount":145400,"un_invoiced":0,"payment_collection_remind_ahead_display":"\u63d0\u524d1\u5929","contract_type_display":"\u4ea7\u54c1\u5408\u540c","collected":"0","un_collected":145400,"collected_plan":145400,"is_collected":false,"can_update":true,"can_update_cost":false,"can_update_file":true,"can_delete":true,"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},{"id":4070,"supplier_id":717,"contract_type":1,"signed_at":"2025-07-25","amount":"18000.00","handler":1011,"description":"","contract_scan":"","created_by":1011,"created_at":"2025-07-25 17:04:56","updated_at":"2025-08-01 17:55:46","client_id":"","project_id":"","sales_rep":"","serial_no":"H202507255159","payment_collection_remind_ahead":"","including_tax":true,"is_save_collection":true,"save_collection_at":"2025-07-25 17:05:06","is_chargeback":false,"cost_type":1,"is_draft":false,"is_verify":false,"is_refuse":false,"erp_settle_amount":"18000","erp_un_settle_amount":"0","erp_payment_ticket_is_verify":false,"erp_collect_ticket_is_verify":false,"erp_cash_cost_ticket_is_verify":false,"client":{},"project":{},"supplier":{"id":717,"key":717,"name":"\u6df1\u5733\u5e02\u6df1\u4fe1\u670d\u4fe1\u606f\u5b89\u5168\u6709\u9650\u516c\u53f8"},"contractScan":{},"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":4070,"comment":4},"purchaseClientRels":[{"id":3728,"contract_id":4070,"client_id":2136,"project_id":3922,"client":{"id":2136,"key":2136,"name":"\u5317\u4eac\u7279\u79cd\u673a\u68b0\u7814\u7a76\u6240 59\u6240","sales_rep":1001},"project":{"id":3922,"key":3922,"name":"\u4e92\u8054\u7f51\u5ba1\u8ba1\u9879\u76ee","project_status":3}}],"purchaseContractPayments":[{"id":"1436","key":"1436","contract_id":4070,"value":"18000","collected_date":"2025-07-29 11:07:13","created_at":"2025-07-29 11:07:13","created_by":1013,"description":"","createdBy":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","department_id":7},"pct":100}],"purchaseContractInvoices":[{"id":2383,"key":2383,"contract_id":4070,"amount":"18000","value":"18000","attachment_id":"","from_date":"2025-07-30","description":"","is_draft":false,"attachment":{},"attachmentRelationships":[],"files":[{"id":36181,"object_type":103,"object_id":2383,"attachment_id":27183,"attachment":{"id":27183,"key":27183,"name":"7107441c-3700-3fec-b8ad-55403583b88d","extension":"pdf","path":"\/vue\/attachment\/view\/7107441c-3700-3fec-b8ad-55403583b88d\/202507295083_25952000000156167857.pdf","orig_name":"202507295083_25952000000156167857.pdf"}}]}],"contractScans":[{"id":36133,"object_type":108,"object_id":4070,"attachment_id":27107,"attachment":{"id":27107,"key":27107,"name":"89946cfa-ebc3-33b5-a6ef-db1f1967a247","extension":"pdf","path":"\/vue\/attachment\/preview\/89946cfa-ebc3-33b5-a6ef-db1f1967a247\/(H202507255159-001)\u5317\u4eac\u7279\u79cd\u673a\u68b0\u7814\u7a76\u6240.pdf","orig_name":"(H202507255159-001)\u5317\u4eac\u7279\u79cd\u673a\u68b0\u7814\u7a76\u6240.pdf"}}],"receiptScans":[{"id":36229,"object_type":111,"object_id":4070,"attachment_id":27223,"attachment":{"id":27223,"key":27223,"name":"9bb1a317-5dbf-31a9-8f74-b79de336d87c","extension":"pdf","path":"\/vue\/attachment\/preview\/9bb1a317-5dbf-31a9-8f74-b79de336d87c\/7HKNxLAmmOKy_OUT_FILE_shouhuo_after.PDF","orig_name":"7HKNxLAmmOKy_OUT_FILE_shouhuo_after.PDF"}}],"purchaseContractPaymentCollectionRemindReceivers":[{"id":1364,"user_id":1011,"key":1011,"contract_id":4070,"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":1365,"user_id":5360,"key":5360,"contract_id":4070,"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":807,"key":807,"contract_id":4070,"name":"2025-07-28","value":"18000","overdue_days":1,"status":1,"pct":100,"collect_status":"\u5df2\u5b8c\u6210"}],"paymentApproves":[{"id":2101,"client_id":2136,"project_id":3922,"title":"\u4ed8\u6b3e\u7533\u8bf7-\u6df1\u4fe1\u670d\u79d1\u6280\u80a1\u4efd\u6709\u9650\u516c\u53f8","status":2,"next_verify_user":"","verify_at":"2025-07-28 11:40:00","description":"Tristen\uff0c\u7533\u8bf7\u652f\u4ed8\u6df1\u4fe1\u670d\u8bbe\u5907AC-1000-B1100-4D\u91c7\u8d2d\u6b3e\u7528\u4e8e\u8ba2\u8d27\uff0c\u91d1\u989d\uff1a\uffe518000\u5143\uff0c\u8bf7\u5ba1\u6279\uff01\n\n\u5907\u6ce8\uff1a\u7eb8\u8d28\u5355\u636e\u5df2\u63d0\u4ea4\u5ba1\u6838\uff01","refuse_description":"","is_resubmited":false,"created_by":1011,"created_at":"2025-07-28 10:36:44","updated_at":"2025-07-28 11:40:00","supplier_id":138,"purchase_contract_id":4070,"amount":"18000","borrow_amount":"","borrow_collect_day":"","borrow_collect_status":0,"borrow_collect_description":"","borrow_collect_at":"","erp_payment_settle_amount":"18000","erp_payment_un_settle_amount":"-18000","erp_borrow_settle_amount":"0","erp_borrow_un_settle_amount":"0","next_cancel_verify_user":"","cancel_at":"","cancel_description":""}],"costContractAmounts":[],"unreadComments":{},"purchaseContractProductRels":[],"erpPurchaseOrder":{"id":2003,"serial_no":"CGDD-20250725-00002","from_date":"","wrote_date":"2025-07-25","handler":1011,"supplier_id":717,"purchase_contract_id":4070,"erp_store_id":"","status":2,"abstract":"","description":"","verify_type":1,"next_verify_user":"","next_stop_verify_user":"","next_cancel_verify_user":"","verify_at":"2025-07-25 17:04:56","stop_at":"","cancel_at":"","refuse_description":"","is_resubmitted":false,"is_used":false,"is_done":true,"is_settle":false,"number":"0","amount":"18000.00","created_by":1011,"stop_description":"","inventory_status":false,"is_cancel":false,"is_old":true,"created_at":"2025-07-25 17:04:56","updated_at":"2025-08-01 17:55:46","erpPurchaseOrderVerifyRels":[],"erpPurchaseOrderStopVerifyRels":[],"erpPurchaseOrderCancelVerifyRels":[]},"erpPurchaseCost":"","invoiced":18000,"approve_amount":18000,"un_approve_amount":0,"un_invoiced":0,"payment_collection_remind_ahead_display":"\u65e0","contract_type_display":"\u4ea7\u54c1\u5408\u540c","collected":"18000","un_collected":0,"collected_plan":18000,"is_collected":true,"can_update":true,"can_update_cost":false,"can_update_file":true,"can_delete":true,"unread":0,"bgcolor":"#89c541","product_amount":0,"product_number":0,"is_done":true,"cost_done_display":false,"cost_un_done_display":false,"done_display":true}],"count":{"total":"141477610.44","collected":"135119410.30","un_collected":6358200.14,"invoiced":"136519440.12","un_invoiced":4877588.08},"can_create":true,"pagenation":{"totalcount":805,"thispage":1,"pagesize":20}},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}],"mod":0}', FALSE, '2025-09-19 22:21:09') RETURNING "id"