Database Queries

总计38条数据
TimeDurationTypeQuery
  
16:45:06.9142.2 msSELECTSELECT * FROM "global"."vw_user_login" WHERE "id"=1001

16:45:06.9171.5 msSELECTSELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001

16:45:06.9215.4 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_erp_collect_tickets' and d.nspname = 'a57be577deb434' ORDER BY a.attnum;

16:45:06.92727.4 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_erp_collect_tickets' and ns.nspname='a57be577deb434' order by fns.nspname, fc.relname, a.attnum

16:45:06.9590.7 msSELECTSELECT "id" FROM "a57be577deb434"."tbl_users" WHERE "user_status"='1' ORDER BY "id"

16:45:06.9604.3 msSELECTSELECT COUNT(*) FROM (SELECT r.* FROM "a57be577deb434"."tbl_erp_collect_tickets" "r" LEFT JOIN "a57be577deb434"."tbl_erp_collect_ticket_verify_rels" "rvr" ON rvr.erp_collect_ticket_id = r.id WHERE ("r"."created_by"=1001) OR ("rvr"."user_id"=1001) OR ("r"."created_by" IN (1000, 1001, 1004, 1005, 1011, 1013, 1015, 1017, 1022, 1023, 5016, 5064, 5085, 5087, 5248, 5250, 5252, 5295, 5300, 5311, 5332, 5360, 5388, 5446, 5449)) GROUP BY "r"."id" ORDER BY "r"."updated_at" DESC) "c"

16:45:06.9641.9 msSELECTSELECT r.* FROM "a57be577deb434"."tbl_erp_collect_tickets" "r" LEFT JOIN "a57be577deb434"."tbl_erp_collect_ticket_verify_rels" "rvr" ON rvr.erp_collect_ticket_id = r.id WHERE ("r"."created_by"=1001) OR ("rvr"."user_id"=1001) OR ("r"."created_by" IN (1000, 1001, 1004, 1005, 1011, 1013, 1015, 1017, 1022, 1023, 5016, 5064, 5085, 5087, 5248, 5250, 5252, 5295, 5300, 5311, 5332, 5360, 5388, 5446, 5449)) GROUP BY "r"."id" ORDER BY "r"."updated_at" DESC LIMIT 20

16:45:06.9700.3 msSELECTSELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (5252, 1013)

16:45:06.9700.5 msSELECTSELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id" IN (5252, 1013))

16:45:06.9710.4 msSELECTSELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_departments" WHERE "id" IN (6, 7)

16:45:06.9720.2 msSELECTSELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (1005, 1011, 5300, 5295, 1004)

16:45:06.9720.2 msSELECTSELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id" IN (1011, 5295, 1005, 1004, 5300))

16:45:06.9720.1 msSELECTSELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_departments" WHERE "id" IN (3, 1)

16:45:06.9730.5 msSELECTSELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_clients" WHERE "id" IN (3387, 12, 2182, 3317, 2766, 2205, 1301, 1492, 3363, 3376)

16:45:06.9732.6 msSELECTSELECT "id", "id" AS "key", "serial_no" AS "name" FROM "a57be577deb434"."tbl_sales_contracts" WHERE "id" IN (4036, 4044, 4046, 4005, 4021, 4022, 3646, 3202, 3960, 4027, 4028, 3286, 3915, 3854, 4002, 4008, 3924)

16:45:06.9760.3 msSELECTSELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_suppliers" WHERE "id"=431

16:45:06.9770.8 msSELECTSELECT * FROM "a57be577deb434"."tbl_erp_collect_ticket_carbon_copy_rels" WHERE "erp_collect_ticket_id" IN (1989, 1987, 358, 366, 374, 389, 388, 386, 379, 378, 377, 376, 375, 373, 372, 360, 356, 328, 331, 321)

16:45:06.9780.2 msSELECTSELECT * FROM "a57be577deb434"."tbl_erp_collect_ticket_verify_rels" WHERE "erp_collect_ticket_id" IN (1989, 1987, 358, 366, 374, 389, 388, 386, 379, 378, 377, 376, 375, 373, 372, 360, 356, 328, 331, 321) ORDER BY "id"

16:45:06.9780.2 msSELECTSELECT * FROM "a57be577deb434"."tbl_erp_collect_ticket_verify_rels" WHERE ("status"=0) AND ("erp_collect_ticket_id" IN (1989, 1987, 358, 366, 374, 389, 388, 386, 379, 378, 377, 376, 375, 373, 372, 360, 356, 328, 331, 321)) ORDER BY "id"

16:45:06.9780.2 msSELECTSELECT * FROM "a57be577deb434"."tbl_erp_collect_ticket_verify_rels" WHERE ("status" != 0) AND ("erp_collect_ticket_id" IN (1989, 1987, 358, 366, 374, 389, 388, 386, 379, 378, 377, 376, 375, 373, 372, 360, 356, 328, 331, 321)) ORDER BY "id"

16:45:06.9790.2 msSELECTSELECT * FROM "a57be577deb434"."tbl_erp_collect_ticket_verify_rels" WHERE ("status" = 0) AND ("user_id"=1001) AND ("erp_collect_ticket_id" IN (1989, 1987, 358, 366, 374, 389, 388, 386, 379, 378, 377, 376, 375, 373, 372, 360, 356, 328, 331, 321))

16:45:06.9791.0 msSELECTSELECT * FROM "a57be577deb434"."tbl_erp_collect_ticket_stop_verify_rels" WHERE "erp_collect_ticket_id" IN (1989, 1987, 358, 366, 374, 389, 388, 386, 379, 378, 377, 376, 375, 373, 372, 360, 356, 328, 331, 321) ORDER BY "id"

16:45:06.9800.2 msSELECTSELECT * FROM "a57be577deb434"."tbl_erp_collect_ticket_stop_verify_rels" WHERE ("status"=0) AND ("erp_collect_ticket_id" IN (1989, 1987, 358, 366, 374, 389, 388, 386, 379, 378, 377, 376, 375, 373, 372, 360, 356, 328, 331, 321)) ORDER BY "id"

16:45:06.9800.2 msSELECTSELECT * FROM "a57be577deb434"."tbl_erp_collect_ticket_stop_verify_rels" WHERE ("status" != 0) AND ("erp_collect_ticket_id" IN (1989, 1987, 358, 366, 374, 389, 388, 386, 379, 378, 377, 376, 375, 373, 372, 360, 356, 328, 331, 321)) ORDER BY "id"

16:45:06.9810.2 msSELECTSELECT * FROM "a57be577deb434"."tbl_erp_collect_ticket_stop_verify_rels" WHERE ("status" = 0) AND ("user_id"=1001) AND ("erp_collect_ticket_id" IN (1989, 1987, 358, 366, 374, 389, 388, 386, 379, 378, 377, 376, 375, 373, 372, 360, 356, 328, 331, 321))

16:45:06.9810.3 msSELECTSELECT * FROM "a57be577deb434"."tbl_erp_collect_ticket_bank_ins" WHERE "erp_collect_ticket_id" IN (1989, 1987, 358, 366, 374, 389, 388, 386, 379, 378, 377, 376, 375, 373, 372, 360, 356, 328, 331, 321) ORDER BY "id"

16:45:06.9812.3 msSELECTSELECT * FROM "a57be577deb434"."tbl_erp_collect_ticket_payments" WHERE "erp_collect_ticket_id" IN (1989, 1987, 358, 366, 374, 389, 388, 386, 379, 378, 377, 376, 375, 373, 372, 360, 356, 328, 331, 321) ORDER BY "id"

16:45:06.9841.7 msSELECTSELECT * FROM "a57be577deb434"."tbl_erp_collect_ticket_settles" WHERE "erp_collect_ticket_id" IN (1989, 1987, 358, 366, 374, 389, 388, 386, 379, 378, 377, 376, 375, 373, 372, 360, 356, 328, 331, 321) ORDER BY "id"

16:45:06.9940.4 msSELECTSELECT "id", "id" AS "key", "serial_no", "created_at" FROM "a57be577deb434"."tbl_sales_contracts" WHERE "id" IN (3924, 4002, 4008, 3854, 3915, 3286, 4046, 4028, 4027, 3960, 3202, 3646, 4022, 4021, 4005, 4044, 4036, 4071)

16:45:06.9940.4 msSELECTSELECT "id", "id" AS "key", "serial_no", "created_at" FROM "a57be577deb434"."tbl_purchase_contracts" WHERE "id"=4072

16:45:06.9951.6 msSELECTSELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=20021) AND ("object_id" IN (1989, 1987, 358, 366, 374, 389, 388, 386, 379, 378, 377, 376, 375, 373, 372, 360, 356, 328, 331, 321))

16:45:06.9971.4 msSELECTSELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=20022) AND ("object_id" IN (1989, 1987, 358, 366, 374, 389, 388, 386, 379, 378, 377, 376, 375, 373, 372, 360, 356, 328, 331, 321))

16:45:06.9980.5 msSELECTSELECT "id", "id" AS "key", "name", "extension", "path", "orig_name" FROM "a57be577deb434"."tbl_attachments" WHERE "id" IN (26670, 26832, 26728, 26833, 26858, 26894, 27128, 26895, 26896, 26897, 26898, 26920, 27109, 27110, 27111, 27126, 27108)

16:45:06.99919.0 msSELECTSELECT "object_id", count(*) as comment FROM "a57be577deb434"."tbl_comments" WHERE ("object_type"=20013) AND ("object_id" IN (1989, 1987, 358, 366, 374, 389, 388, 386, 379, 378, 377, 376, 375, 373, 372, 360, 356, 328, 331, 321)) GROUP BY "object_id"

16:45:07.01823.0 msSELECTSELECT "object_id", count(*) AS unread FROM "a57be577deb434"."tbl_unread_comments" WHERE ("object_type"=20013) AND (remind_user_id = 1001 AND is_read = false) AND ("object_id" IN (1989, 1987, 358, 366, 374, 389, 388, 386, 379, 378, 377, 376, 375, 373, 372, 360, 356, 328, 331, 321)) GROUP BY "object_id"

16:45:07.0420.5 msSELECTSELECT "id" FROM "a57be577deb434"."tbl_users" WHERE "user_status"='1' ORDER BY "id"

16:45:07.0432.7 msSELECTSELECT count(*) as count, sum(amount) as sum, "status" FROM (SELECT r.amount,r.status FROM "a57be577deb434"."tbl_erp_collect_tickets" "r" LEFT JOIN "a57be577deb434"."tbl_erp_collect_ticket_verify_rels" "rvr" ON rvr.erp_collect_ticket_id = r.id WHERE ("r"."created_by"=1001) OR ("rvr"."user_id"=1001) OR ("r"."created_by" IN (1000, 1001, 1004, 1005, 1011, 1013, 1015, 1017, 1022, 1023, 5016, 5064, 5085, 5087, 5248, 5250, 5252, 5295, 5300, 5311, 5332, 5360, 5388, 5446, 5449)) GROUP BY "r"."id") "sub" GROUP BY "status"

16:45:07.0482.1 msINSERTINSERT INTO "global"."tbl_api_log" ("code", "schema", "user_id", "device_type", "url", "request", "response", "php_error", "time") VALUES (200, 'a57be577deb434', 1001, 5, 'vue/erp-collect-ticket/list', '{"Filter":{"name":"updated_at","sort":"DESC"},"ErpCollectTicketSearch":{"wrote_date_period":"","status":"","handler":"","created_by":""},"page":"1","web_access_token":"0Bjt7zsA4RpFpNhApjLlKpy587hFcKCO"}', '{"code":2000,"result":{"list":[{"id":1989,"serial_no":"FK-20250804-00002","wrote_date":"2025-08-04","from_date":"","handler":1005,"user_id":"","client_id":3387,"sales_contract_id":"","supplier_id":"","purchase_contract_id":"","status":2,"abstract":"\u6211\u70ed\u6c61\u67d3","description":"","verify_type":1,"next_verify_user":"","next_stop_verify_user":"","verify_at":"2025-08-04 12:34:58","stop_at":"","refuse_description":"","is_resubmitted":false,"amount":"3","settle_amount":"0","created_by":5252,"stop_description":"","is_settle":false,"is_old":true,"created_at":"2025-08-04 12:34:58","updated_at":"2025-08-04 12:34:58","paid_amount":"","createdBy":{"id":5252,"key":5252,"name":"\u738b\u7b11\u7b11","sex":"F","department_id":6,"avatar":{"id":101,"user_id":5252,"name":"\/files\/cdn\/a57be577deb434\/avatar\/f5529321-408e-3d11-aa95-9b0a384f2d9c.png"},"department":{"id":6,"key":6,"name":"\u8d22\u52a1\u90e8"}},"user":{},"handlerPerson":{"id":1005,"key":1005,"name":"\u8d75\u6657\u7131","sex":"F","department_id":1,"avatar":{"id":16,"user_id":1005,"name":"\/files\/cdn\/a57be577deb434\/avatar\/56876dde-37eb-39fc-853a-47eaef6510e5.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"client":{"id":3387,"key":3387,"name":"\u5317\u4eac\u4e45\u5b89\u667a\u8baf\u79d1\u6280\u6709\u9650\u516c\u53f8"},"salesContract":{},"supplier":{},"purchaseContract":"","erpCollectTicketCarbonCopyRels":[],"erpCollectTicketVerifyRels":[],"lastErpCollectTicketVerifyRel":{},"haveErpCollectTicketVerifyRel":{},"selfErpCollectTicketVerifyRel":{},"erpCollectTicketStopVerifyRels":[],"lastErpCollectTicketStopVerifyRel":{},"haveErpCollectTicketStopVerifyRel":{},"selfErpCollectTicketStopVerifyRel":{},"erpCollectTicketBankIns":[],"erpCollectTicketPayments":[],"erpCollectTicketSettles":[{"id":1994,"erp_collect_ticket_id":1989,"sales_contract_id":4071,"purchase_contract_id":"","erp_other_income_ticket_id":"","erp_other_collect_ticket_id":"","amount":"3","description":"","salesContract":{"id":4071,"key":4071,"serial_no":"","created_at":"2025-07-28 17:38:30"},"purchaseContract":"","erpOtherIncomeTicket":"","erpOtherCollectTicket":"","serial_no":"","created_at":"2025-07-28 17:38:30"}],"attachmentRelationships":[],"files":[],"commentCount":{},"unreadComments":{},"unread":0,"can_update":false,"can_delete":false,"can_resubmit":false,"can_verify":false,"can_refuse":false,"can_stop":false,"can_settle":true,"can_stop_verify":false,"can_stop_refuse":false,"bgcolor":"#4B7902","status_display":"\u5df2\u5b8c\u6210","paymentAmount":0,"unPaymentAmount":3,"bankAmount":0},{"id":1987,"serial_no":"FK-20250804-00001","wrote_date":"2025-08-04","from_date":"","handler":1011,"user_id":"","client_id":"","sales_contract_id":"","supplier_id":431,"purchase_contract_id":"","status":2,"abstract":"\u5c0f\u6d4b\u8bd5","description":"","verify_type":1,"next_verify_user":"","next_stop_verify_user":"","verify_at":"2025-08-04 11:48:26","stop_at":"","refuse_description":"","is_resubmitted":false,"amount":"1","settle_amount":"0","created_by":5252,"stop_description":"","is_settle":false,"is_old":true,"created_at":"2025-08-04 11:48:26","updated_at":"2025-08-04 11:48:26","paid_amount":"","createdBy":{"id":5252,"key":5252,"name":"\u738b\u7b11\u7b11","sex":"F","department_id":6,"avatar":{"id":101,"user_id":5252,"name":"\/files\/cdn\/a57be577deb434\/avatar\/f5529321-408e-3d11-aa95-9b0a384f2d9c.png"},"department":{"id":6,"key":6,"name":"\u8d22\u52a1\u90e8"}},"user":{},"handlerPerson":{"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"}},"client":{},"salesContract":{},"supplier":{"id":431,"key":431,"name":"\u5317\u4eac\u60e0\u8054\u8baf\u901a\u4fe1\u606f\u6280\u672f\u670d\u52a1\u6709\u9650\u516c\u53f8"},"purchaseContract":"","erpCollectTicketCarbonCopyRels":[],"erpCollectTicketVerifyRels":[],"lastErpCollectTicketVerifyRel":{},"haveErpCollectTicketVerifyRel":{},"selfErpCollectTicketVerifyRel":{},"erpCollectTicketStopVerifyRels":[],"lastErpCollectTicketStopVerifyRel":{},"haveErpCollectTicketStopVerifyRel":{},"selfErpCollectTicketStopVerifyRel":{},"erpCollectTicketBankIns":[],"erpCollectTicketPayments":[],"erpCollectTicketSettles":[{"id":1990,"erp_collect_ticket_id":1987,"sales_contract_id":"","purchase_contract_id":4072,"erp_other_income_ticket_id":"","erp_other_collect_ticket_id":"","amount":"1","description":"","salesContract":{},"purchaseContract":{"id":4072,"key":4072,"serial_no":"\u6d4b\u8bd5\u8c01\u662f\u8c01","created_at":"2025-08-04 11:00:32"},"erpOtherIncomeTicket":"","erpOtherCollectTicket":"","serial_no":"\u6d4b\u8bd5\u8c01\u662f\u8c01","created_at":"2025-08-04 11:00:32"}],"attachmentRelationships":[],"files":[],"commentCount":{},"unreadComments":{},"unread":0,"can_update":false,"can_delete":false,"can_resubmit":false,"can_verify":false,"can_refuse":false,"can_stop":false,"can_settle":true,"can_stop_verify":false,"can_stop_refuse":false,"bgcolor":"#4B7902","status_display":"\u5df2\u5b8c\u6210","paymentAmount":0,"unPaymentAmount":1,"bankAmount":0},{"id":358,"serial_no":"SKD-20250728-00001","wrote_date":"2025-07-28","from_date":"","handler":5300,"user_id":"","client_id":12,"sales_contract_id":4036,"supplier_id":"","purchase_contract_id":"","status":2,"abstract":"\u5272\u53d1\u4ee3\u9996\u98ce\u683c","description":"\u4e2a\u7a0e\u98ce\u683c\u7684","verify_type":1,"next_verify_user":"","next_stop_verify_user":"","verify_at":"2025-08-04 11:28:35","stop_at":"","refuse_description":"","is_resubmitted":false,"amount":"598","settle_amount":"598","created_by":1013,"stop_description":"","is_settle":false,"is_old":true,"created_at":"2025-07-28 10:12:28","updated_at":"2025-08-04 11:28:35","paid_amount":"","createdBy":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","department_id":7,"avatar":{"id":34,"user_id":1013,"name":"\/files\/cdn\/a57be577deb434\/avatar\/25ef1fe7-8dda-3daa-b8ea-9fabd0a47439.png"},"department":{"id":7,"key":7,"name":"\u5e93\u623f\u90e8"}},"user":{},"handlerPerson":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91","sex":"F","department_id":1,"avatar":{"id":141,"user_id":5300,"name":"\/files\/cdn\/a57be577deb434\/avatar\/14dfd1a0-6df5-354a-8afd-f0a76fa8e852.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"client":{"id":12,"key":12,"name":"smc(\u4e2d\u56fd)\u6709\u9650\u516c\u53f8\/SMC(\u5317\u4eac)\u5236\u9020\u6709\u9650\u516c\u53f8"},"salesContract":{"id":4036,"key":4036,"name":"SMC\u5929\u6d25\u8ba2\u5355POTJ25074907"},"supplier":{},"purchaseContract":"","erpCollectTicketCarbonCopyRels":[],"erpCollectTicketVerifyRels":[],"lastErpCollectTicketVerifyRel":{},"haveErpCollectTicketVerifyRel":{},"selfErpCollectTicketVerifyRel":{},"erpCollectTicketStopVerifyRels":[],"lastErpCollectTicketStopVerifyRel":{},"haveErpCollectTicketStopVerifyRel":{},"selfErpCollectTicketStopVerifyRel":{},"erpCollectTicketBankIns":[],"erpCollectTicketPayments":[],"erpCollectTicketSettles":[{"id":1989,"erp_collect_ticket_id":358,"sales_contract_id":4036,"purchase_contract_id":"","erp_other_income_ticket_id":"","erp_other_collect_ticket_id":"","amount":"598","description":"","salesContract":{"id":4036,"key":4036,"serial_no":"SMC\u5929\u6d25\u8ba2\u5355POTJ25074907","created_at":"2025-07-15 15:48:22"},"purchaseContract":"","erpOtherIncomeTicket":"","erpOtherCollectTicket":"","serial_no":"SMC\u5929\u6d25\u8ba2\u5355POTJ25074907","created_at":"2025-07-15 15:48:22"}],"attachmentRelationships":[],"files":[{"id":37351,"object_type":20022,"object_id":358,"attachment_id":27108,"attachment":{"id":27108,"key":27108,"name":"cc9f5541-0b9f-3cf4-886f-a7e980949eac","extension":"png","path":"\/vue\/attachment\/view\/cc9f5541-0b9f-3cf4-886f-a7e980949eac\/image.png","orig_name":"image.png"}}],"commentCount":{},"unreadComments":{},"unread":0,"can_update":false,"can_delete":false,"can_resubmit":false,"can_verify":false,"can_refuse":false,"can_stop":false,"can_settle":true,"can_stop_verify":false,"can_stop_refuse":false,"bgcolor":"#4B7902","status_display":"\u5df2\u5b8c\u6210","paymentAmount":0,"unPaymentAmount":598,"bankAmount":0},{"id":366,"serial_no":"SKD-20250728-00002","wrote_date":"2025-07-28","from_date":"","handler":5300,"user_id":"","client_id":2182,"sales_contract_id":4044,"supplier_id":"","purchase_contract_id":"","status":2,"abstract":"\u65b9\u5f0f\u5730\u65b9","description":"","verify_type":1,"next_verify_user":"","next_stop_verify_user":"","verify_at":"2025-08-04 11:23:15","stop_at":"","refuse_description":"","is_resubmitted":false,"amount":"15000","settle_amount":"15000","created_by":1013,"stop_description":"","is_settle":false,"is_old":true,"created_at":"2025-07-28 16:49:31","updated_at":"2025-08-04 11:23:15","paid_amount":"","createdBy":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","department_id":7,"avatar":{"id":34,"user_id":1013,"name":"\/files\/cdn\/a57be577deb434\/avatar\/25ef1fe7-8dda-3daa-b8ea-9fabd0a47439.png"},"department":{"id":7,"key":7,"name":"\u5e93\u623f\u90e8"}},"user":{},"handlerPerson":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91","sex":"F","department_id":1,"avatar":{"id":141,"user_id":5300,"name":"\/files\/cdn\/a57be577deb434\/avatar\/14dfd1a0-6df5-354a-8afd-f0a76fa8e852.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"client":{"id":2182,"key":2182,"name":"\u5317\u4eac\u5357\u65b9\u65af\u5948\u514b\u739b\u6da1\u8f6e\u6280\u672f\u6709\u9650\u516c\u53f8"},"salesContract":{"id":4044,"key":4044,"name":"PO-2025-07-0006"},"supplier":{},"purchaseContract":"","erpCollectTicketCarbonCopyRels":[],"erpCollectTicketVerifyRels":[],"lastErpCollectTicketVerifyRel":{},"haveErpCollectTicketVerifyRel":{},"selfErpCollectTicketVerifyRel":{},"erpCollectTicketStopVerifyRels":[],"lastErpCollectTicketStopVerifyRel":{},"haveErpCollectTicketStopVerifyRel":{},"selfErpCollectTicketStopVerifyRel":{},"erpCollectTicketBankIns":[],"erpCollectTicketPayments":[],"erpCollectTicketSettles":[{"id":1988,"erp_collect_ticket_id":366,"sales_contract_id":4044,"purchase_contract_id":"","erp_other_income_ticket_id":"","erp_other_collect_ticket_id":"","amount":"15000","description":"","salesContract":{"id":4044,"key":4044,"serial_no":"PO-2025-07-0006","created_at":"2025-07-17 11:46:31"},"purchaseContract":"","erpOtherIncomeTicket":"","erpOtherCollectTicket":"","serial_no":"PO-2025-07-0006","created_at":"2025-07-17 11:46:31"}],"attachmentRelationships":[],"files":[{"id":37342,"object_type":20022,"object_id":366,"attachment_id":27126,"attachment":{"id":27126,"key":27126,"name":"56f12877-2ba8-37cf-9648-b109b3d3f99c","extension":"png","path":"\/vue\/attachment\/view\/56f12877-2ba8-37cf-9648-b109b3d3f99c\/image.png","orig_name":"image.png"}}],"commentCount":{},"unreadComments":{},"unread":0,"can_update":false,"can_delete":false,"can_resubmit":false,"can_verify":false,"can_refuse":false,"can_stop":false,"can_settle":true,"can_stop_verify":false,"can_stop_refuse":false,"bgcolor":"#4B7902","status_display":"\u5df2\u5b8c\u6210","paymentAmount":0,"unPaymentAmount":15000,"bankAmount":0},{"id":374,"serial_no":"SKD-20250728-00003","wrote_date":"2025-07-28","from_date":"","handler":5300,"user_id":"","client_id":2182,"sales_contract_id":4046,"supplier_id":"","purchase_contract_id":"","status":2,"abstract":"","description":"","verify_type":1,"next_verify_user":"","next_stop_verify_user":"","verify_at":"2025-07-28 16:59:17","stop_at":"","refuse_description":"","is_resubmitted":false,"amount":"5900","settle_amount":"5900","created_by":1013,"stop_description":"","is_settle":false,"is_old":true,"created_at":"2025-07-28 16:59:17","updated_at":"2025-07-28 16:59:17","paid_amount":"","createdBy":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","department_id":7,"avatar":{"id":34,"user_id":1013,"name":"\/files\/cdn\/a57be577deb434\/avatar\/25ef1fe7-8dda-3daa-b8ea-9fabd0a47439.png"},"department":{"id":7,"key":7,"name":"\u5e93\u623f\u90e8"}},"user":{},"handlerPerson":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91","sex":"F","department_id":1,"avatar":{"id":141,"user_id":5300,"name":"\/files\/cdn\/a57be577deb434\/avatar\/14dfd1a0-6df5-354a-8afd-f0a76fa8e852.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"client":{"id":2182,"key":2182,"name":"\u5317\u4eac\u5357\u65b9\u65af\u5948\u514b\u739b\u6da1\u8f6e\u6280\u672f\u6709\u9650\u516c\u53f8"},"salesContract":{"id":4046,"key":4046,"name":"PO-2025-07-0007"},"supplier":{},"purchaseContract":"","erpCollectTicketCarbonCopyRels":[],"erpCollectTicketVerifyRels":[],"lastErpCollectTicketVerifyRel":{},"haveErpCollectTicketVerifyRel":{},"selfErpCollectTicketVerifyRel":{},"erpCollectTicketStopVerifyRels":[],"lastErpCollectTicketStopVerifyRel":{},"haveErpCollectTicketStopVerifyRel":{},"selfErpCollectTicketStopVerifyRel":{},"erpCollectTicketBankIns":[],"erpCollectTicketPayments":[],"erpCollectTicketSettles":[{"id":374,"erp_collect_ticket_id":374,"sales_contract_id":4046,"purchase_contract_id":"","erp_other_income_ticket_id":"","erp_other_collect_ticket_id":"","amount":"5900","description":"","salesContract":{"id":4046,"key":4046,"serial_no":"PO-2025-07-0007","created_at":"2025-07-17 13:18:27"},"purchaseContract":"","erpOtherIncomeTicket":"","erpOtherCollectTicket":"","serial_no":"PO-2025-07-0007","created_at":"2025-07-17 13:18:27"}],"attachmentRelationships":[],"files":[{"id":36481,"object_type":20022,"object_id":374,"attachment_id":27128,"attachment":{"id":27128,"key":27128,"name":"dcee5604-e161-3928-a1ae-6f1cbf29e913","extension":"png","path":"\/vue\/attachment\/view\/dcee5604-e161-3928-a1ae-6f1cbf29e913\/image.png","orig_name":"image.png"}}],"commentCount":{},"unreadComments":{},"unread":0,"can_update":false,"can_delete":false,"can_resubmit":false,"can_verify":false,"can_refuse":false,"can_stop":false,"can_settle":true,"can_stop_verify":false,"can_stop_refuse":false,"bgcolor":"#4B7902","status_display":"\u5df2\u5b8c\u6210","paymentAmount":0,"unPaymentAmount":5900,"bankAmount":0},{"id":389,"serial_no":"SKD-20250728-00006","wrote_date":"2025-07-28","from_date":"","handler":5300,"user_id":"","client_id":12,"sales_contract_id":4005,"supplier_id":"","purchase_contract_id":"","status":2,"abstract":"","description":"","verify_type":1,"next_verify_user":"","next_stop_verify_user":"","verify_at":"2025-07-28 10:13:00","stop_at":"","refuse_description":"","is_resubmitted":false,"amount":"299","settle_amount":"299","created_by":1013,"stop_description":"","is_settle":false,"is_old":true,"created_at":"2025-07-28 10:13:00","updated_at":"2025-07-28 10:13:00","paid_amount":"","createdBy":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","department_id":7,"avatar":{"id":34,"user_id":1013,"name":"\/files\/cdn\/a57be577deb434\/avatar\/25ef1fe7-8dda-3daa-b8ea-9fabd0a47439.png"},"department":{"id":7,"key":7,"name":"\u5e93\u623f\u90e8"}},"user":{},"handlerPerson":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91","sex":"F","department_id":1,"avatar":{"id":141,"user_id":5300,"name":"\/files\/cdn\/a57be577deb434\/avatar\/14dfd1a0-6df5-354a-8afd-f0a76fa8e852.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"client":{"id":12,"key":12,"name":"smc(\u4e2d\u56fd)\u6709\u9650\u516c\u53f8\/SMC(\u5317\u4eac)\u5236\u9020\u6709\u9650\u516c\u53f8"},"salesContract":{"id":4005,"key":4005,"name":"SMC\u5929\u6d25\u8ba2\u5355POTJ25068095"},"supplier":{},"purchaseContract":"","erpCollectTicketCarbonCopyRels":[],"erpCollectTicketVerifyRels":[],"lastErpCollectTicketVerifyRel":{},"haveErpCollectTicketVerifyRel":{},"selfErpCollectTicketVerifyRel":{},"erpCollectTicketStopVerifyRels":[],"lastErpCollectTicketStopVerifyRel":{},"haveErpCollectTicketStopVerifyRel":{},"selfErpCollectTicketStopVerifyRel":{},"erpCollectTicketBankIns":[],"erpCollectTicketPayments":[],"erpCollectTicketSettles":[{"id":389,"erp_collect_ticket_id":389,"sales_contract_id":4005,"purchase_contract_id":"","erp_other_income_ticket_id":"","erp_other_collect_ticket_id":"","amount":"299","description":"","salesContract":{"id":4005,"key":4005,"serial_no":"SMC\u5929\u6d25\u8ba2\u5355POTJ25068095","created_at":"2025-06-30 15:38:30"},"purchaseContract":"","erpOtherIncomeTicket":"","erpOtherCollectTicket":"","serial_no":"SMC\u5929\u6d25\u8ba2\u5355POTJ25068095","created_at":"2025-06-30 15:38:30"}],"attachmentRelationships":[],"files":[{"id":36494,"object_type":20022,"object_id":389,"attachment_id":27111,"attachment":{"id":27111,"key":27111,"name":"b28ce307-2a76-376a-86c2-7ad1dbf8196b","extension":"png","path":"\/vue\/attachment\/view\/b28ce307-2a76-376a-86c2-7ad1dbf8196b\/image.png","orig_name":"image.png"}}],"commentCount":{},"unreadComments":{},"unread":0,"can_update":false,"can_delete":false,"can_resubmit":false,"can_verify":false,"can_refuse":false,"can_stop":false,"can_settle":true,"can_stop_verify":false,"can_stop_refuse":false,"bgcolor":"#4B7902","status_display":"\u5df2\u5b8c\u6210","paymentAmount":0,"unPaymentAmount":299,"bankAmount":0},{"id":388,"serial_no":"SKD-20250728-00005","wrote_date":"2025-07-28","from_date":"","handler":5300,"user_id":"","client_id":12,"sales_contract_id":4021,"supplier_id":"","purchase_contract_id":"","status":2,"abstract":"","description":"","verify_type":1,"next_verify_user":"","next_stop_verify_user":"","verify_at":"2025-07-28 10:12:49","stop_at":"","refuse_description":"","is_resubmitted":false,"amount":"594","settle_amount":"594","created_by":1013,"stop_description":"","is_settle":false,"is_old":true,"created_at":"2025-07-28 10:12:49","updated_at":"2025-07-28 10:12:49","paid_amount":"","createdBy":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","department_id":7,"avatar":{"id":34,"user_id":1013,"name":"\/files\/cdn\/a57be577deb434\/avatar\/25ef1fe7-8dda-3daa-b8ea-9fabd0a47439.png"},"department":{"id":7,"key":7,"name":"\u5e93\u623f\u90e8"}},"user":{},"handlerPerson":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91","sex":"F","department_id":1,"avatar":{"id":141,"user_id":5300,"name":"\/files\/cdn\/a57be577deb434\/avatar\/14dfd1a0-6df5-354a-8afd-f0a76fa8e852.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"client":{"id":12,"key":12,"name":"smc(\u4e2d\u56fd)\u6709\u9650\u516c\u53f8\/SMC(\u5317\u4eac)\u5236\u9020\u6709\u9650\u516c\u53f8"},"salesContract":{"id":4021,"key":4021,"name":"SMC\u5929\u6d25\u8ba2\u5355POTJ25072858"},"supplier":{},"purchaseContract":"","erpCollectTicketCarbonCopyRels":[],"erpCollectTicketVerifyRels":[],"lastErpCollectTicketVerifyRel":{},"haveErpCollectTicketVerifyRel":{},"selfErpCollectTicketVerifyRel":{},"erpCollectTicketStopVerifyRels":[],"lastErpCollectTicketStopVerifyRel":{},"haveErpCollectTicketStopVerifyRel":{},"selfErpCollectTicketStopVerifyRel":{},"erpCollectTicketBankIns":[],"erpCollectTicketPayments":[],"erpCollectTicketSettles":[{"id":388,"erp_collect_ticket_id":388,"sales_contract_id":4021,"purchase_contract_id":"","erp_other_income_ticket_id":"","erp_other_collect_ticket_id":"","amount":"594","description":"","salesContract":{"id":4021,"key":4021,"serial_no":"SMC\u5929\u6d25\u8ba2\u5355POTJ25072858","created_at":"2025-07-10 21:01:12"},"purchaseContract":"","erpOtherIncomeTicket":"","erpOtherCollectTicket":"","serial_no":"SMC\u5929\u6d25\u8ba2\u5355POTJ25072858","created_at":"2025-07-10 21:01:12"}],"attachmentRelationships":[],"files":[{"id":36493,"object_type":20022,"object_id":388,"attachment_id":27110,"attachment":{"id":27110,"key":27110,"name":"f38d6bf2-5fc4-3655-aa93-1a9e00cdd18b","extension":"png","path":"\/vue\/attachment\/view\/f38d6bf2-5fc4-3655-aa93-1a9e00cdd18b\/image.png","orig_name":"image.png"}}],"commentCount":{},"unreadComments":{},"unread":0,"can_update":false,"can_delete":false,"can_resubmit":false,"can_verify":false,"can_refuse":false,"can_stop":false,"can_settle":true,"can_stop_verify":false,"can_stop_refuse":false,"bgcolor":"#4B7902","status_display":"\u5df2\u5b8c\u6210","paymentAmount":0,"unPaymentAmount":594,"bankAmount":0},{"id":386,"serial_no":"SKD-20250728-00004","wrote_date":"2025-07-28","from_date":"","handler":5300,"user_id":"","client_id":12,"sales_contract_id":4022,"supplier_id":"","purchase_contract_id":"","status":2,"abstract":"","description":"","verify_type":1,"next_verify_user":"","next_stop_verify_user":"","verify_at":"2025-07-28 10:12:39","stop_at":"","refuse_description":"","is_resubmitted":false,"amount":"299","settle_amount":"299","created_by":1013,"stop_description":"","is_settle":false,"is_old":true,"created_at":"2025-07-28 10:12:39","updated_at":"2025-07-28 10:12:39","paid_amount":"","createdBy":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","department_id":7,"avatar":{"id":34,"user_id":1013,"name":"\/files\/cdn\/a57be577deb434\/avatar\/25ef1fe7-8dda-3daa-b8ea-9fabd0a47439.png"},"department":{"id":7,"key":7,"name":"\u5e93\u623f\u90e8"}},"user":{},"handlerPerson":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91","sex":"F","department_id":1,"avatar":{"id":141,"user_id":5300,"name":"\/files\/cdn\/a57be577deb434\/avatar\/14dfd1a0-6df5-354a-8afd-f0a76fa8e852.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"client":{"id":12,"key":12,"name":"smc(\u4e2d\u56fd)\u6709\u9650\u516c\u53f8\/SMC(\u5317\u4eac)\u5236\u9020\u6709\u9650\u516c\u53f8"},"salesContract":{"id":4022,"key":4022,"name":"SMC\u5929\u6d25\u8ba2\u5355POTJ25073432"},"supplier":{},"purchaseContract":"","erpCollectTicketCarbonCopyRels":[],"erpCollectTicketVerifyRels":[],"lastErpCollectTicketVerifyRel":{},"haveErpCollectTicketVerifyRel":{},"selfErpCollectTicketVerifyRel":{},"erpCollectTicketStopVerifyRels":[],"lastErpCollectTicketStopVerifyRel":{},"haveErpCollectTicketStopVerifyRel":{},"selfErpCollectTicketStopVerifyRel":{},"erpCollectTicketBankIns":[],"erpCollectTicketPayments":[],"erpCollectTicketSettles":[{"id":386,"erp_collect_ticket_id":386,"sales_contract_id":4022,"purchase_contract_id":"","erp_other_income_ticket_id":"","erp_other_collect_ticket_id":"","amount":"299","description":"","salesContract":{"id":4022,"key":4022,"serial_no":"SMC\u5929\u6d25\u8ba2\u5355POTJ25073432","created_at":"2025-07-10 21:02:32"},"purchaseContract":"","erpOtherIncomeTicket":"","erpOtherCollectTicket":"","serial_no":"SMC\u5929\u6d25\u8ba2\u5355POTJ25073432","created_at":"2025-07-10 21:02:32"}],"attachmentRelationships":[],"files":[{"id":36491,"object_type":20022,"object_id":386,"attachment_id":27109,"attachment":{"id":27109,"key":27109,"name":"d8cd8d2a-afd9-382c-97ea-df7d6f1fe725","extension":"png","path":"\/vue\/attachment\/view\/d8cd8d2a-afd9-382c-97ea-df7d6f1fe725\/image.png","orig_name":"image.png"}}],"commentCount":{},"unreadComments":{},"unread":0,"can_update":false,"can_delete":false,"can_resubmit":false,"can_verify":false,"can_refuse":false,"can_stop":false,"can_settle":true,"can_stop_verify":false,"can_stop_refuse":false,"bgcolor":"#4B7902","status_display":"\u5df2\u5b8c\u6210","paymentAmount":0,"unPaymentAmount":299,"bankAmount":0},{"id":379,"serial_no":"SKD-20250721-00001","wrote_date":"2025-07-21","from_date":"","handler":5295,"user_id":"","client_id":3317,"sales_contract_id":3646,"supplier_id":"","purchase_contract_id":"","status":2,"abstract":"","description":"","verify_type":1,"next_verify_user":"","next_stop_verify_user":"","verify_at":"2025-07-21 09:26:45","stop_at":"","refuse_description":"","is_resubmitted":false,"amount":"159905","settle_amount":"159905","created_by":1013,"stop_description":"","is_settle":false,"is_old":true,"created_at":"2025-07-21 09:26:45","updated_at":"2025-07-21 09:26:45","paid_amount":"","createdBy":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","department_id":7,"avatar":{"id":34,"user_id":1013,"name":"\/files\/cdn\/a57be577deb434\/avatar\/25ef1fe7-8dda-3daa-b8ea-9fabd0a47439.png"},"department":{"id":7,"key":7,"name":"\u5e93\u623f\u90e8"}},"user":{},"handlerPerson":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F","department_id":1,"avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"client":{"id":3317,"key":3317,"name":"\u5317\u4eac\u98de\u9e4f\u6052\u4e1a\u79d1\u6280\u6709\u9650\u516c\u53f8\uff08\u8fc7\u5355\uff09"},"salesContract":{"id":3646,"key":3646,"name":"TS-WZW-2024110401"},"supplier":{},"purchaseContract":"","erpCollectTicketCarbonCopyRels":[],"erpCollectTicketVerifyRels":[],"lastErpCollectTicketVerifyRel":{},"haveErpCollectTicketVerifyRel":{},"selfErpCollectTicketVerifyRel":{},"erpCollectTicketStopVerifyRels":[],"lastErpCollectTicketStopVerifyRel":{},"haveErpCollectTicketStopVerifyRel":{},"selfErpCollectTicketStopVerifyRel":{},"erpCollectTicketBankIns":[],"erpCollectTicketPayments":[],"erpCollectTicketSettles":[{"id":379,"erp_collect_ticket_id":379,"sales_contract_id":3646,"purchase_contract_id":"","erp_other_income_ticket_id":"","erp_other_collect_ticket_id":"","amount":"159905","description":"","salesContract":{"id":3646,"key":3646,"serial_no":"TS-WZW-2024110401","created_at":"2024-11-04 17:31:48"},"purchaseContract":"","erpOtherIncomeTicket":"","erpOtherCollectTicket":"","serial_no":"TS-WZW-2024110401","created_at":"2024-11-04 17:31:48"}],"attachmentRelationships":[],"files":[{"id":36486,"object_type":20022,"object_id":379,"attachment_id":26920,"attachment":{"id":26920,"key":26920,"name":"532c47cd-bd53-3cf2-80d8-7963a1db7edd","extension":"png","path":"\/vue\/attachment\/view\/532c47cd-bd53-3cf2-80d8-7963a1db7edd\/image.png","orig_name":"image.png"}}],"commentCount":{},"unreadComments":{},"unread":0,"can_update":false,"can_delete":false,"can_resubmit":false,"can_verify":false,"can_refuse":false,"can_stop":false,"can_settle":true,"can_stop_verify":false,"can_stop_refuse":false,"bgcolor":"#4B7902","status_display":"\u5df2\u5b8c\u6210","paymentAmount":0,"unPaymentAmount":159905,"bankAmount":0},{"id":378,"serial_no":"SKD-20250717-00005","wrote_date":"2025-07-17","from_date":"","handler":1005,"user_id":"","client_id":2766,"sales_contract_id":3202,"supplier_id":"","purchase_contract_id":"","status":2,"abstract":"","description":"","verify_type":1,"next_verify_user":"","next_stop_verify_user":"","verify_at":"2025-07-17 17:26:45","stop_at":"","refuse_description":"","is_resubmitted":false,"amount":"389813.44","settle_amount":"389813.44","created_by":1013,"stop_description":"","is_settle":false,"is_old":true,"created_at":"2025-07-17 17:26:45","updated_at":"2025-07-17 17:26:45","paid_amount":"","createdBy":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","department_id":7,"avatar":{"id":34,"user_id":1013,"name":"\/files\/cdn\/a57be577deb434\/avatar\/25ef1fe7-8dda-3daa-b8ea-9fabd0a47439.png"},"department":{"id":7,"key":7,"name":"\u5e93\u623f\u90e8"}},"user":{},"handlerPerson":{"id":1005,"key":1005,"name":"\u8d75\u6657\u7131","sex":"F","department_id":1,"avatar":{"id":16,"user_id":1005,"name":"\/files\/cdn\/a57be577deb434\/avatar\/56876dde-37eb-39fc-853a-47eaef6510e5.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"client":{"id":2766,"key":2766,"name":"\u5409\u6797\u7701\u5a01\u58eb\u987f\u667a\u80fd\u79d1\u6280\u6709\u9650\u516c\u53f8\uff08\u8fc7\u5355\uff09"},"salesContract":{"id":3202,"key":3202,"name":"TS-ZHY-2024032601"},"supplier":{},"purchaseContract":"","erpCollectTicketCarbonCopyRels":[],"erpCollectTicketVerifyRels":[],"lastErpCollectTicketVerifyRel":{},"haveErpCollectTicketVerifyRel":{},"selfErpCollectTicketVerifyRel":{},"erpCollectTicketStopVerifyRels":[],"lastErpCollectTicketStopVerifyRel":{},"haveErpCollectTicketStopVerifyRel":{},"selfErpCollectTicketStopVerifyRel":{},"erpCollectTicketBankIns":[],"erpCollectTicketPayments":[],"erpCollectTicketSettles":[{"id":378,"erp_collect_ticket_id":378,"sales_contract_id":3202,"purchase_contract_id":"","erp_other_income_ticket_id":"","erp_other_collect_ticket_id":"","amount":"389813.44","description":"","salesContract":{"id":3202,"key":3202,"serial_no":"TS-ZHY-2024032601","created_at":"2024-03-26 10:53:36"},"purchaseContract":"","erpOtherIncomeTicket":"","erpOtherCollectTicket":"","serial_no":"TS-ZHY-2024032601","created_at":"2024-03-26 10:53:36"}],"attachmentRelationships":[],"files":[{"id":36485,"object_type":20022,"object_id":378,"attachment_id":26898,"attachment":{"id":26898,"key":26898,"name":"432919ca-3c99-3f48-b5af-d02283350db5","extension":"png","path":"\/vue\/attachment\/view\/432919ca-3c99-3f48-b5af-d02283350db5\/image.png","orig_name":"image.png"}}],"commentCount":{},"unreadComments":{},"unread":0,"can_update":false,"can_delete":false,"can_resubmit":false,"can_verify":false,"can_refuse":false,"can_stop":false,"can_settle":true,"can_stop_verify":false,"can_stop_refuse":false,"bgcolor":"#4B7902","status_display":"\u5df2\u5b8c\u6210","paymentAmount":0,"unPaymentAmount":389813.44,"bankAmount":0},{"id":377,"serial_no":"SKD-20250717-00004","wrote_date":"2025-07-17","from_date":"","handler":1005,"user_id":"","client_id":2205,"sales_contract_id":3960,"supplier_id":"","purchase_contract_id":"","status":2,"abstract":"","description":"","verify_type":1,"next_verify_user":"","next_stop_verify_user":"","verify_at":"2025-07-17 17:23:02","stop_at":"","refuse_description":"","is_resubmitted":false,"amount":"117000","settle_amount":"117000","created_by":1013,"stop_description":"","is_settle":false,"is_old":true,"created_at":"2025-07-17 17:23:02","updated_at":"2025-07-17 17:23:02","paid_amount":"","createdBy":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","department_id":7,"avatar":{"id":34,"user_id":1013,"name":"\/files\/cdn\/a57be577deb434\/avatar\/25ef1fe7-8dda-3daa-b8ea-9fabd0a47439.png"},"department":{"id":7,"key":7,"name":"\u5e93\u623f\u90e8"}},"user":{},"handlerPerson":{"id":1005,"key":1005,"name":"\u8d75\u6657\u7131","sex":"F","department_id":1,"avatar":{"id":16,"user_id":1005,"name":"\/files\/cdn\/a57be577deb434\/avatar\/56876dde-37eb-39fc-853a-47eaef6510e5.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"client":{"id":2205,"key":2205,"name":"\u5317\u4eac\u6613\u8f66\u4fe1\u606f\u79d1\u6280\u6709\u9650\u516c\u53f8"},"salesContract":{"id":3960,"key":3960,"name":"P00186867"},"supplier":{},"purchaseContract":"","erpCollectTicketCarbonCopyRels":[],"erpCollectTicketVerifyRels":[],"lastErpCollectTicketVerifyRel":{},"haveErpCollectTicketVerifyRel":{},"selfErpCollectTicketVerifyRel":{},"erpCollectTicketStopVerifyRels":[],"lastErpCollectTicketStopVerifyRel":{},"haveErpCollectTicketStopVerifyRel":{},"selfErpCollectTicketStopVerifyRel":{},"erpCollectTicketBankIns":[],"erpCollectTicketPayments":[],"erpCollectTicketSettles":[{"id":377,"erp_collect_ticket_id":377,"sales_contract_id":3960,"purchase_contract_id":"","erp_other_income_ticket_id":"","erp_other_collect_ticket_id":"","amount":"117000","description":"","salesContract":{"id":3960,"key":3960,"serial_no":"P00186867","created_at":"2025-06-06 11:12:00"},"purchaseContract":"","erpOtherIncomeTicket":"","erpOtherCollectTicket":"","serial_no":"P00186867","created_at":"2025-06-06 11:12:00"}],"attachmentRelationships":[],"files":[{"id":36484,"object_type":20022,"object_id":377,"attachment_id":26897,"attachment":{"id":26897,"key":26897,"name":"572fbf0d-750b-3d2a-b1ef-610ef9d7f069","extension":"png","path":"\/vue\/attachment\/view\/572fbf0d-750b-3d2a-b1ef-610ef9d7f069\/image.png","orig_name":"image.png"}}],"commentCount":{},"unreadComments":{},"unread":0,"can_update":false,"can_delete":false,"can_resubmit":false,"can_verify":false,"can_refuse":false,"can_stop":false,"can_settle":true,"can_stop_verify":false,"can_stop_refuse":false,"bgcolor":"#4B7902","status_display":"\u5df2\u5b8c\u6210","paymentAmount":0,"unPaymentAmount":117000,"bankAmount":0},{"id":376,"serial_no":"SKD-20250717-00003","wrote_date":"2025-07-17","from_date":"","handler":5295,"user_id":"","client_id":1301,"sales_contract_id":4027,"supplier_id":"","purchase_contract_id":"","status":2,"abstract":"","description":"","verify_type":1,"next_verify_user":"","next_stop_verify_user":"","verify_at":"2025-07-17 17:21:21","stop_at":"","refuse_description":"","is_resubmitted":false,"amount":"3270","settle_amount":"3270","created_by":1013,"stop_description":"","is_settle":false,"is_old":true,"created_at":"2025-07-17 17:21:21","updated_at":"2025-07-17 17:21:21","paid_amount":"","createdBy":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","department_id":7,"avatar":{"id":34,"user_id":1013,"name":"\/files\/cdn\/a57be577deb434\/avatar\/25ef1fe7-8dda-3daa-b8ea-9fabd0a47439.png"},"department":{"id":7,"key":7,"name":"\u5e93\u623f\u90e8"}},"user":{},"handlerPerson":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F","department_id":1,"avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"client":{"id":1301,"key":1301,"name":"\u591a\u7ef4\u8054\u5408\u96c6\u56e2\u80a1\u4efd\u6709\u9650\u516c\u53f8(\u591a\u7ef4\u7eff\u5efa\u79d1\u6280(\u5929\u6d25)\u6709\u9650\u516c\u53f8\u3001\u5317\u4eac\u591a\u7ef4\u827e\u65af\u7279\u56fd\u9645\u5de5\u7a0b\u6280\u672f\u6709\u9650\u516c\u53f8)"},"salesContract":{"id":4027,"key":4027,"name":"TS-WZW-20250709002"},"supplier":{},"purchaseContract":"","erpCollectTicketCarbonCopyRels":[],"erpCollectTicketVerifyRels":[],"lastErpCollectTicketVerifyRel":{},"haveErpCollectTicketVerifyRel":{},"selfErpCollectTicketVerifyRel":{},"erpCollectTicketStopVerifyRels":[],"lastErpCollectTicketStopVerifyRel":{},"haveErpCollectTicketStopVerifyRel":{},"selfErpCollectTicketStopVerifyRel":{},"erpCollectTicketBankIns":[],"erpCollectTicketPayments":[],"erpCollectTicketSettles":[{"id":376,"erp_collect_ticket_id":376,"sales_contract_id":4027,"purchase_contract_id":"","erp_other_income_ticket_id":"","erp_other_collect_ticket_id":"","amount":"3270","description":"","salesContract":{"id":4027,"key":4027,"serial_no":"TS-WZW-20250709002","created_at":"2025-07-14 09:59:46"},"purchaseContract":"","erpOtherIncomeTicket":"","erpOtherCollectTicket":"","serial_no":"TS-WZW-20250709002","created_at":"2025-07-14 09:59:46"}],"attachmentRelationships":[],"files":[{"id":36483,"object_type":20022,"object_id":376,"attachment_id":26896,"attachment":{"id":26896,"key":26896,"name":"2f2b634a-57e1-3f59-b5c9-71fa2a6ec8d7","extension":"png","path":"\/vue\/attachment\/view\/2f2b634a-57e1-3f59-b5c9-71fa2a6ec8d7\/image.png","orig_name":"image.png"}}],"commentCount":{},"unreadComments":{},"unread":0,"can_update":false,"can_delete":false,"can_resubmit":false,"can_verify":false,"can_refuse":false,"can_stop":false,"can_settle":true,"can_stop_verify":false,"can_stop_refuse":false,"bgcolor":"#4B7902","status_display":"\u5df2\u5b8c\u6210","paymentAmount":0,"unPaymentAmount":3270,"bankAmount":0},{"id":375,"serial_no":"SKD-20250717-00002","wrote_date":"2025-07-17","from_date":"","handler":5295,"user_id":"","client_id":1301,"sales_contract_id":4028,"supplier_id":"","purchase_contract_id":"","status":2,"abstract":"","description":"","verify_type":1,"next_verify_user":"","next_stop_verify_user":"","verify_at":"2025-07-17 17:19:20","stop_at":"","refuse_description":"","is_resubmitted":false,"amount":"26289.9","settle_amount":"26289.9","created_by":1013,"stop_description":"","is_settle":false,"is_old":true,"created_at":"2025-07-17 17:19:20","updated_at":"2025-07-17 17:19:20","paid_amount":"","createdBy":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","department_id":7,"avatar":{"id":34,"user_id":1013,"name":"\/files\/cdn\/a57be577deb434\/avatar\/25ef1fe7-8dda-3daa-b8ea-9fabd0a47439.png"},"department":{"id":7,"key":7,"name":"\u5e93\u623f\u90e8"}},"user":{},"handlerPerson":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F","department_id":1,"avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"client":{"id":1301,"key":1301,"name":"\u591a\u7ef4\u8054\u5408\u96c6\u56e2\u80a1\u4efd\u6709\u9650\u516c\u53f8(\u591a\u7ef4\u7eff\u5efa\u79d1\u6280(\u5929\u6d25)\u6709\u9650\u516c\u53f8\u3001\u5317\u4eac\u591a\u7ef4\u827e\u65af\u7279\u56fd\u9645\u5de5\u7a0b\u6280\u672f\u6709\u9650\u516c\u53f8)"},"salesContract":{"id":4028,"key":4028,"name":"TS-WZW-20250709001"},"supplier":{},"purchaseContract":"","erpCollectTicketCarbonCopyRels":[],"erpCollectTicketVerifyRels":[],"lastErpCollectTicketVerifyRel":{},"haveErpCollectTicketVerifyRel":{},"selfErpCollectTicketVerifyRel":{},"erpCollectTicketStopVerifyRels":[],"lastErpCollectTicketStopVerifyRel":{},"haveErpCollectTicketStopVerifyRel":{},"selfErpCollectTicketStopVerifyRel":{},"erpCollectTicketBankIns":[],"erpCollectTicketPayments":[],"erpCollectTicketSettles":[{"id":375,"erp_collect_ticket_id":375,"sales_contract_id":4028,"purchase_contract_id":"","erp_other_income_ticket_id":"","erp_other_collect_ticket_id":"","amount":"26289.9","description":"","salesContract":{"id":4028,"key":4028,"serial_no":"TS-WZW-20250709001","created_at":"2025-07-14 10:01:27"},"purchaseContract":"","erpOtherIncomeTicket":"","erpOtherCollectTicket":"","serial_no":"TS-WZW-20250709001","created_at":"2025-07-14 10:01:27"}],"attachmentRelationships":[],"files":[{"id":36482,"object_type":20022,"object_id":375,"attachment_id":26895,"attachment":{"id":26895,"key":26895,"name":"d059c370-08a3-3e49-960e-3e590252ed9a","extension":"png","path":"\/vue\/attachment\/view\/d059c370-08a3-3e49-960e-3e590252ed9a\/image.png","orig_name":"image.png"}}],"commentCount":{},"unreadComments":{},"unread":0,"can_update":false,"can_delete":false,"can_resubmit":false,"can_verify":false,"can_refuse":false,"can_stop":false,"can_settle":true,"can_stop_verify":false,"can_stop_refuse":false,"bgcolor":"#4B7902","status_display":"\u5df2\u5b8c\u6210","paymentAmount":0,"unPaymentAmount":26289.9,"bankAmount":0},{"id":373,"serial_no":"SKD-20250717-00001","wrote_date":"2025-07-17","from_date":"","handler":1005,"user_id":"","client_id":1492,"sales_contract_id":3286,"supplier_id":"","purchase_contract_id":"","status":2,"abstract":"","description":"","verify_type":1,"next_verify_user":"","next_stop_verify_user":"","verify_at":"2025-07-17 17:16:22","stop_at":"","refuse_description":"","is_resubmitted":false,"amount":"324640","settle_amount":"324640","created_by":1013,"stop_description":"","is_settle":false,"is_old":true,"created_at":"2025-07-17 17:16:22","updated_at":"2025-07-17 17:16:22","paid_amount":"","createdBy":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","department_id":7,"avatar":{"id":34,"user_id":1013,"name":"\/files\/cdn\/a57be577deb434\/avatar\/25ef1fe7-8dda-3daa-b8ea-9fabd0a47439.png"},"department":{"id":7,"key":7,"name":"\u5e93\u623f\u90e8"}},"user":{},"handlerPerson":{"id":1005,"key":1005,"name":"\u8d75\u6657\u7131","sex":"F","department_id":1,"avatar":{"id":16,"user_id":1005,"name":"\/files\/cdn\/a57be577deb434\/avatar\/56876dde-37eb-39fc-853a-47eaef6510e5.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"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)"},"salesContract":{"id":3286,"key":3286,"name":"24GBG015"},"supplier":{},"purchaseContract":"","erpCollectTicketCarbonCopyRels":[],"erpCollectTicketVerifyRels":[],"lastErpCollectTicketVerifyRel":{},"haveErpCollectTicketVerifyRel":{},"selfErpCollectTicketVerifyRel":{},"erpCollectTicketStopVerifyRels":[],"lastErpCollectTicketStopVerifyRel":{},"haveErpCollectTicketStopVerifyRel":{},"selfErpCollectTicketStopVerifyRel":{},"erpCollectTicketBankIns":[],"erpCollectTicketPayments":[],"erpCollectTicketSettles":[{"id":373,"erp_collect_ticket_id":373,"sales_contract_id":3286,"purchase_contract_id":"","erp_other_income_ticket_id":"","erp_other_collect_ticket_id":"","amount":"324640","description":"","salesContract":{"id":3286,"key":3286,"serial_no":"24GBG015","created_at":"2024-05-13 10:54:10"},"purchaseContract":"","erpOtherIncomeTicket":"","erpOtherCollectTicket":"","serial_no":"24GBG015","created_at":"2024-05-13 10:54:10"}],"attachmentRelationships":[],"files":[{"id":36480,"object_type":20022,"object_id":373,"attachment_id":26894,"attachment":{"id":26894,"key":26894,"name":"46836794-efa7-3949-8a14-34573ac72e1e","extension":"png","path":"\/vue\/attachment\/view\/46836794-efa7-3949-8a14-34573ac72e1e\/image.png","orig_name":"image.png"}}],"commentCount":{},"unreadComments":{},"unread":0,"can_update":false,"can_delete":false,"can_resubmit":false,"can_verify":false,"can_refuse":false,"can_stop":false,"can_settle":true,"can_stop_verify":false,"can_stop_refuse":false,"bgcolor":"#4B7902","status_display":"\u5df2\u5b8c\u6210","paymentAmount":0,"unPaymentAmount":324640,"bankAmount":0},{"id":372,"serial_no":"SKD-20250715-00002","wrote_date":"2025-07-15","from_date":"","handler":1005,"user_id":"","client_id":1492,"sales_contract_id":3286,"supplier_id":"","purchase_contract_id":"","status":2,"abstract":"","description":"","verify_type":1,"next_verify_user":"","next_stop_verify_user":"","verify_at":"2025-07-15 17:26:24","stop_at":"","refuse_description":"","is_resubmitted":false,"amount":"44500","settle_amount":"44500","created_by":1013,"stop_description":"","is_settle":false,"is_old":true,"created_at":"2025-07-15 17:26:24","updated_at":"2025-07-15 17:26:24","paid_amount":"","createdBy":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","department_id":7,"avatar":{"id":34,"user_id":1013,"name":"\/files\/cdn\/a57be577deb434\/avatar\/25ef1fe7-8dda-3daa-b8ea-9fabd0a47439.png"},"department":{"id":7,"key":7,"name":"\u5e93\u623f\u90e8"}},"user":{},"handlerPerson":{"id":1005,"key":1005,"name":"\u8d75\u6657\u7131","sex":"F","department_id":1,"avatar":{"id":16,"user_id":1005,"name":"\/files\/cdn\/a57be577deb434\/avatar\/56876dde-37eb-39fc-853a-47eaef6510e5.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"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)"},"salesContract":{"id":3286,"key":3286,"name":"24GBG015"},"supplier":{},"purchaseContract":"","erpCollectTicketCarbonCopyRels":[],"erpCollectTicketVerifyRels":[],"lastErpCollectTicketVerifyRel":{},"haveErpCollectTicketVerifyRel":{},"selfErpCollectTicketVerifyRel":{},"erpCollectTicketStopVerifyRels":[],"lastErpCollectTicketStopVerifyRel":{},"haveErpCollectTicketStopVerifyRel":{},"selfErpCollectTicketStopVerifyRel":{},"erpCollectTicketBankIns":[],"erpCollectTicketPayments":[],"erpCollectTicketSettles":[{"id":372,"erp_collect_ticket_id":372,"sales_contract_id":3286,"purchase_contract_id":"","erp_other_income_ticket_id":"","erp_other_collect_ticket_id":"","amount":"44500","description":"","salesContract":{"id":3286,"key":3286,"serial_no":"24GBG015","created_at":"2024-05-13 10:54:10"},"purchaseContract":"","erpOtherIncomeTicket":"","erpOtherCollectTicket":"","serial_no":"24GBG015","created_at":"2024-05-13 10:54:10"}],"attachmentRelationships":[],"files":[{"id":36479,"object_type":20022,"object_id":372,"attachment_id":26858,"attachment":{"id":26858,"key":26858,"name":"894b3d2d-8887-3d78-b2b6-cda682d286bc","extension":"png","path":"\/vue\/attachment\/view\/894b3d2d-8887-3d78-b2b6-cda682d286bc\/image.png","orig_name":"image.png"}}],"commentCount":{},"unreadComments":{},"unread":0,"can_update":false,"can_delete":false,"can_resubmit":false,"can_verify":false,"can_refuse":false,"can_stop":false,"can_settle":true,"can_stop_verify":false,"can_stop_refuse":false,"bgcolor":"#4B7902","status_display":"\u5df2\u5b8c\u6210","paymentAmount":0,"unPaymentAmount":44500,"bankAmount":0},{"id":360,"serial_no":"SKD-20250715-00001","wrote_date":"2025-07-15","from_date":"","handler":1004,"user_id":"","client_id":3363,"sales_contract_id":3915,"supplier_id":"","purchase_contract_id":"","status":2,"abstract":"","description":"","verify_type":1,"next_verify_user":"","next_stop_verify_user":"","verify_at":"2025-07-15 11:29:04","stop_at":"","refuse_description":"","is_resubmitted":false,"amount":"247365","settle_amount":"247365","created_by":1013,"stop_description":"","is_settle":false,"is_old":true,"created_at":"2025-07-15 11:29:04","updated_at":"2025-07-15 11:29:04","paid_amount":"","createdBy":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","department_id":7,"avatar":{"id":34,"user_id":1013,"name":"\/files\/cdn\/a57be577deb434\/avatar\/25ef1fe7-8dda-3daa-b8ea-9fabd0a47439.png"},"department":{"id":7,"key":7,"name":"\u5e93\u623f\u90e8"}},"user":{},"handlerPerson":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0","sex":"M","department_id":1,"avatar":{"id":10,"user_id":1004,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1004.jpg"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"client":{"id":3363,"key":3363,"name":"\u5317\u4eac\u91d1\u7545\u900d\u8f6f\u4ef6\u670d\u52a1\u6709\u9650\u516c\u53f8(\u8fc7\u5355)"},"salesContract":{"id":3915,"key":3915,"name":"TSC-X-20250509"},"supplier":{},"purchaseContract":"","erpCollectTicketCarbonCopyRels":[],"erpCollectTicketVerifyRels":[],"lastErpCollectTicketVerifyRel":{},"haveErpCollectTicketVerifyRel":{},"selfErpCollectTicketVerifyRel":{},"erpCollectTicketStopVerifyRels":[],"lastErpCollectTicketStopVerifyRel":{},"haveErpCollectTicketStopVerifyRel":{},"selfErpCollectTicketStopVerifyRel":{},"erpCollectTicketBankIns":[],"erpCollectTicketPayments":[],"erpCollectTicketSettles":[{"id":360,"erp_collect_ticket_id":360,"sales_contract_id":3915,"purchase_contract_id":"","erp_other_income_ticket_id":"","erp_other_collect_ticket_id":"","amount":"247365","description":"","salesContract":{"id":3915,"key":3915,"serial_no":"TSC-X-20250509","created_at":"2025-05-19 16:15:38"},"purchaseContract":"","erpOtherIncomeTicket":"","erpOtherCollectTicket":"","serial_no":"TSC-X-20250509","created_at":"2025-05-19 16:15:38"}],"attachmentRelationships":[],"files":[],"commentCount":{},"unreadComments":{},"unread":0,"can_update":false,"can_delete":false,"can_resubmit":false,"can_verify":false,"can_refuse":false,"can_stop":false,"can_settle":true,"can_stop_verify":false,"can_stop_refuse":false,"bgcolor":"#4B7902","status_display":"\u5df2\u5b8c\u6210","paymentAmount":0,"unPaymentAmount":247365,"bankAmount":0},{"id":356,"serial_no":"SKD-20250714-00002","wrote_date":"2025-07-14","from_date":"","handler":5300,"user_id":"","client_id":12,"sales_contract_id":3854,"supplier_id":"","purchase_contract_id":"","status":2,"abstract":"","description":"","verify_type":1,"next_verify_user":"","next_stop_verify_user":"","verify_at":"2025-07-14 17:06:28","stop_at":"","refuse_description":"","is_resubmitted":false,"amount":"75500","settle_amount":"75500","created_by":1013,"stop_description":"","is_settle":false,"is_old":true,"created_at":"2025-07-14 17:06:28","updated_at":"2025-07-14 17:06:28","paid_amount":"","createdBy":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","department_id":7,"avatar":{"id":34,"user_id":1013,"name":"\/files\/cdn\/a57be577deb434\/avatar\/25ef1fe7-8dda-3daa-b8ea-9fabd0a47439.png"},"department":{"id":7,"key":7,"name":"\u5e93\u623f\u90e8"}},"user":{},"handlerPerson":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91","sex":"F","department_id":1,"avatar":{"id":141,"user_id":5300,"name":"\/files\/cdn\/a57be577deb434\/avatar\/14dfd1a0-6df5-354a-8afd-f0a76fa8e852.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"client":{"id":12,"key":12,"name":"smc(\u4e2d\u56fd)\u6709\u9650\u516c\u53f8\/SMC(\u5317\u4eac)\u5236\u9020\u6709\u9650\u516c\u53f8"},"salesContract":{"id":3854,"key":3854,"name":"SMC\u4e2d\u56fd\u8ba2\u5355POCN25041073"},"supplier":{},"purchaseContract":"","erpCollectTicketCarbonCopyRels":[],"erpCollectTicketVerifyRels":[],"lastErpCollectTicketVerifyRel":{},"haveErpCollectTicketVerifyRel":{},"selfErpCollectTicketVerifyRel":{},"erpCollectTicketStopVerifyRels":[],"lastErpCollectTicketStopVerifyRel":{},"haveErpCollectTicketStopVerifyRel":{},"selfErpCollectTicketStopVerifyRel":{},"erpCollectTicketBankIns":[],"erpCollectTicketPayments":[],"erpCollectTicketSettles":[{"id":356,"erp_collect_ticket_id":356,"sales_contract_id":3854,"purchase_contract_id":"","erp_other_income_ticket_id":"","erp_other_collect_ticket_id":"","amount":"75500","description":"","salesContract":{"id":3854,"key":3854,"serial_no":"SMC\u4e2d\u56fd\u8ba2\u5355POCN25041073","created_at":"2025-04-03 14:08:35"},"purchaseContract":"","erpOtherIncomeTicket":"","erpOtherCollectTicket":"","serial_no":"SMC\u4e2d\u56fd\u8ba2\u5355POCN25041073","created_at":"2025-04-03 14:08:35"}],"attachmentRelationships":[],"files":[{"id":36464,"object_type":20022,"object_id":356,"attachment_id":26833,"attachment":{"id":26833,"key":26833,"name":"5e025672-ebe5-3a0e-aac8-94637032abc4","extension":"png","path":"\/vue\/attachment\/view\/5e025672-ebe5-3a0e-aac8-94637032abc4\/image.png","orig_name":"image.png"}}],"commentCount":{},"unreadComments":{},"unread":0,"can_update":false,"can_delete":false,"can_resubmit":false,"can_verify":false,"can_refuse":false,"can_stop":false,"can_settle":true,"can_stop_verify":false,"can_stop_refuse":false,"bgcolor":"#4B7902","status_display":"\u5df2\u5b8c\u6210","paymentAmount":0,"unPaymentAmount":75500,"bankAmount":0},{"id":328,"serial_no":"SKD-20250714-00001","wrote_date":"2025-07-14","from_date":"","handler":1005,"user_id":"","client_id":3376,"sales_contract_id":4002,"supplier_id":"","purchase_contract_id":"","status":2,"abstract":"","description":"","verify_type":1,"next_verify_user":"","next_stop_verify_user":"","verify_at":"2025-07-14 17:04:34","stop_at":"","refuse_description":"","is_resubmitted":false,"amount":"300000","settle_amount":"300000","created_by":1013,"stop_description":"","is_settle":false,"is_old":true,"created_at":"2025-07-14 17:04:34","updated_at":"2025-07-14 17:04:34","paid_amount":"","createdBy":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","department_id":7,"avatar":{"id":34,"user_id":1013,"name":"\/files\/cdn\/a57be577deb434\/avatar\/25ef1fe7-8dda-3daa-b8ea-9fabd0a47439.png"},"department":{"id":7,"key":7,"name":"\u5e93\u623f\u90e8"}},"user":{},"handlerPerson":{"id":1005,"key":1005,"name":"\u8d75\u6657\u7131","sex":"F","department_id":1,"avatar":{"id":16,"user_id":1005,"name":"\/files\/cdn\/a57be577deb434\/avatar\/56876dde-37eb-39fc-853a-47eaef6510e5.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"client":{"id":3376,"key":3376,"name":"\u8fb0\u5c79\u5bf0\u5b87\uff08\u4e0a\u6d77\uff09\u4fe1\u606f\u79d1\u6280\u6709\u9650\u516c\u53f8"},"salesContract":{"id":4002,"key":4002,"name":"TSKJ20250630-ZHY-001"},"supplier":{},"purchaseContract":"","erpCollectTicketCarbonCopyRels":[],"erpCollectTicketVerifyRels":[],"lastErpCollectTicketVerifyRel":{},"haveErpCollectTicketVerifyRel":{},"selfErpCollectTicketVerifyRel":{},"erpCollectTicketStopVerifyRels":[],"lastErpCollectTicketStopVerifyRel":{},"haveErpCollectTicketStopVerifyRel":{},"selfErpCollectTicketStopVerifyRel":{},"erpCollectTicketBankIns":[],"erpCollectTicketPayments":[],"erpCollectTicketSettles":[{"id":328,"erp_collect_ticket_id":328,"sales_contract_id":4002,"purchase_contract_id":"","erp_other_income_ticket_id":"","erp_other_collect_ticket_id":"","amount":"300000","description":"","salesContract":{"id":4002,"key":4002,"serial_no":"TSKJ20250630-ZHY-001","created_at":"2025-06-30 12:05:19"},"purchaseContract":"","erpOtherIncomeTicket":"","erpOtherCollectTicket":"","serial_no":"TSKJ20250630-ZHY-001","created_at":"2025-06-30 12:05:19"}],"attachmentRelationships":[],"files":[{"id":36435,"object_type":20022,"object_id":328,"attachment_id":26832,"attachment":{"id":26832,"key":26832,"name":"ae6ae127-5b7d-384b-8d10-06b208720588","extension":"png","path":"\/vue\/attachment\/view\/ae6ae127-5b7d-384b-8d10-06b208720588\/image.png","orig_name":"image.png"}}],"commentCount":{},"unreadComments":{},"unread":0,"can_update":false,"can_delete":false,"can_resubmit":false,"can_verify":false,"can_refuse":false,"can_stop":false,"can_settle":true,"can_stop_verify":false,"can_stop_refuse":false,"bgcolor":"#4B7902","status_display":"\u5df2\u5b8c\u6210","paymentAmount":0,"unPaymentAmount":300000,"bankAmount":0},{"id":331,"serial_no":"SKD-20250707-00001","wrote_date":"2025-07-07","from_date":"","handler":5300,"user_id":"","client_id":2182,"sales_contract_id":4008,"supplier_id":"","purchase_contract_id":"","status":2,"abstract":"","description":"","verify_type":1,"next_verify_user":"","next_stop_verify_user":"","verify_at":"2025-07-07 17:50:08","stop_at":"","refuse_description":"","is_resubmitted":false,"amount":"29701","settle_amount":"29701","created_by":1013,"stop_description":"","is_settle":false,"is_old":true,"created_at":"2025-07-07 17:50:08","updated_at":"2025-07-07 17:50:08","paid_amount":"","createdBy":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","department_id":7,"avatar":{"id":34,"user_id":1013,"name":"\/files\/cdn\/a57be577deb434\/avatar\/25ef1fe7-8dda-3daa-b8ea-9fabd0a47439.png"},"department":{"id":7,"key":7,"name":"\u5e93\u623f\u90e8"}},"user":{},"handlerPerson":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91","sex":"F","department_id":1,"avatar":{"id":141,"user_id":5300,"name":"\/files\/cdn\/a57be577deb434\/avatar\/14dfd1a0-6df5-354a-8afd-f0a76fa8e852.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"client":{"id":2182,"key":2182,"name":"\u5317\u4eac\u5357\u65b9\u65af\u5948\u514b\u739b\u6da1\u8f6e\u6280\u672f\u6709\u9650\u516c\u53f8"},"salesContract":{"id":4008,"key":4008,"name":"TSC-X-2025062701"},"supplier":{},"purchaseContract":"","erpCollectTicketCarbonCopyRels":[],"erpCollectTicketVerifyRels":[],"lastErpCollectTicketVerifyRel":{},"haveErpCollectTicketVerifyRel":{},"selfErpCollectTicketVerifyRel":{},"erpCollectTicketStopVerifyRels":[],"lastErpCollectTicketStopVerifyRel":{},"haveErpCollectTicketStopVerifyRel":{},"selfErpCollectTicketStopVerifyRel":{},"erpCollectTicketBankIns":[],"erpCollectTicketPayments":[],"erpCollectTicketSettles":[{"id":331,"erp_collect_ticket_id":331,"sales_contract_id":4008,"purchase_contract_id":"","erp_other_income_ticket_id":"","erp_other_collect_ticket_id":"","amount":"29701","description":"","salesContract":{"id":4008,"key":4008,"serial_no":"TSC-X-2025062701","created_at":"2025-07-01 12:03:17"},"purchaseContract":"","erpOtherIncomeTicket":"","erpOtherCollectTicket":"","serial_no":"TSC-X-2025062701","created_at":"2025-07-01 12:03:17"}],"attachmentRelationships":[],"files":[{"id":36438,"object_type":20022,"object_id":331,"attachment_id":26728,"attachment":{"id":26728,"key":26728,"name":"4594b08c-4c94-3cd5-83cf-69eb1a297abe","extension":"png","path":"\/vue\/attachment\/view\/4594b08c-4c94-3cd5-83cf-69eb1a297abe\/image.png","orig_name":"image.png"}}],"commentCount":{},"unreadComments":{},"unread":0,"can_update":false,"can_delete":false,"can_resubmit":false,"can_verify":false,"can_refuse":false,"can_stop":false,"can_settle":true,"can_stop_verify":false,"can_stop_refuse":false,"bgcolor":"#4B7902","status_display":"\u5df2\u5b8c\u6210","paymentAmount":0,"unPaymentAmount":29701,"bankAmount":0},{"id":321,"serial_no":"SKD-20250703-00001","wrote_date":"2025-07-03","from_date":"","handler":5295,"user_id":"","client_id":1301,"sales_contract_id":3924,"supplier_id":"","purchase_contract_id":"","status":2,"abstract":"","description":"","verify_type":1,"next_verify_user":"","next_stop_verify_user":"","verify_at":"2025-07-03 13:47:30","stop_at":"","refuse_description":"","is_resubmitted":false,"amount":"19860","settle_amount":"19860","created_by":1013,"stop_description":"","is_settle":false,"is_old":true,"created_at":"2025-07-03 13:47:30","updated_at":"2025-07-03 13:47:30","paid_amount":"","createdBy":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","department_id":7,"avatar":{"id":34,"user_id":1013,"name":"\/files\/cdn\/a57be577deb434\/avatar\/25ef1fe7-8dda-3daa-b8ea-9fabd0a47439.png"},"department":{"id":7,"key":7,"name":"\u5e93\u623f\u90e8"}},"user":{},"handlerPerson":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F","department_id":1,"avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"client":{"id":1301,"key":1301,"name":"\u591a\u7ef4\u8054\u5408\u96c6\u56e2\u80a1\u4efd\u6709\u9650\u516c\u53f8(\u591a\u7ef4\u7eff\u5efa\u79d1\u6280(\u5929\u6d25)\u6709\u9650\u516c\u53f8\u3001\u5317\u4eac\u591a\u7ef4\u827e\u65af\u7279\u56fd\u9645\u5de5\u7a0b\u6280\u672f\u6709\u9650\u516c\u53f8)"},"salesContract":{"id":3924,"key":3924,"name":"TS-WZW-20250521001"},"supplier":{},"purchaseContract":"","erpCollectTicketCarbonCopyRels":[],"erpCollectTicketVerifyRels":[],"lastErpCollectTicketVerifyRel":{},"haveErpCollectTicketVerifyRel":{},"selfErpCollectTicketVerifyRel":{},"erpCollectTicketStopVerifyRels":[],"lastErpCollectTicketStopVerifyRel":{},"haveErpCollectTicketStopVerifyRel":{},"selfErpCollectTicketStopVerifyRel":{},"erpCollectTicketBankIns":[],"erpCollectTicketPayments":[],"erpCollectTicketSettles":[{"id":321,"erp_collect_ticket_id":321,"sales_contract_id":3924,"purchase_contract_id":"","erp_other_income_ticket_id":"","erp_other_collect_ticket_id":"","amount":"19860","description":"","salesContract":{"id":3924,"key":3924,"serial_no":"TS-WZW-20250521001","created_at":"2025-05-23 15:41:55"},"purchaseContract":"","erpOtherIncomeTicket":"","erpOtherCollectTicket":"","serial_no":"TS-WZW-20250521001","created_at":"2025-05-23 15:41:55"}],"attachmentRelationships":[],"files":[{"id":36428,"object_type":20022,"object_id":321,"attachment_id":26670,"attachment":{"id":26670,"key":26670,"name":"d27b2191-cc89-3091-a2cc-88897704484a","extension":"png","path":"\/vue\/attachment\/view\/d27b2191-cc89-3091-a2cc-88897704484a\/image.png","orig_name":"image.png"}}],"commentCount":{},"unreadComments":{},"unread":0,"can_update":false,"can_delete":false,"can_resubmit":false,"can_verify":false,"can_refuse":false,"can_stop":false,"can_settle":true,"can_stop_verify":false,"can_stop_refuse":false,"bgcolor":"#4B7902","status_display":"\u5df2\u5b8c\u6210","paymentAmount":0,"unPaymentAmount":19860,"bankAmount":0}],"can_create":true,"pagenation":{"totalcount":494,"thispage":1,"pagesize":20},"count":{"statusCount":[{"count":0,"key":1,"name":"\u5ba1\u6838\u4e2d","color":"#FEF7EC","border":"#FACD91","sum":0},{"count":494,"key":2,"name":"\u5df2\u5b8c\u6210","color":"#E7F3D5","border":"#70B603","sum":"82542794.04"},{"count":0,"key":4,"name":"\u5df2\u62d2\u7edd","color":"#F9D4D9","border":"#D9001B","sum":0}]}},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}],"mod":0}', FALSE, '2025-08-08 16:45:07') RETURNING "id"