ConfigurationRequestLogsProfilingDatabaseAsset BundlesMailTimeline
6948adf1de9c5: POST https://beta.jinchangxiao.com/vue/analysis/pre-sales-project-list at 2025-12-22 10:33:21 am by 223.72.15.105

Performance Profiling

Total processing time: 283 ms; Peak memory: 7.166 MB. Show Profiling Timeline

总计47条数据
TimeDurationCategoryInfo
  
10:33:22.08743.0 msyii\db\Command::querySELECT "object_id", count(*) as comment FROM "a57be577deb434"."tbl_comments" WHERE ("object_type"=1) AND ("object_id" IN (3960, 4006, 4003, 3969, 3888, 3956, 3922, 3883, 3917, 3841, 3910, 3911, 3900, 3898, 3875, 3834, 3866, 3869, 3852, 3863)) GROUP BY "object_id"
10:33:22.13332.8 msyii\db\Command::querySELECT "object_id", count(*) AS unread FROM "a57be577deb434"."tbl_unread_comments" WHERE ("object_type"=1) AND (remind_user_id = 1001 AND is_read = false) AND ("object_id" IN (3960, 4006, 4003, 3969, 3888, 3956, 3922, 3883, 3917, 3841, 3910, 3911, 3900, 3898, 3875, 3834, 3866, 3869, 3852, 3863)) GROUP BY "object_id"
10:33:21.97227.1 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_term_taxonomy_relationships" WHERE "object_id" IN (3960, 4006, 4003, 3969, 3888, 3956, 3922, 3883, 3917, 3841, 3910, 3911, 3900, 3898, 3875, 3834, 3866, 3869, 3852, 3863)
10:33:22.03417.5 msyii\db\Command::queryselect 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_cases' and ns.nspname='a57be577deb434' order by fns.nspname, fc.relname, a.attnum
10:33:22.01412.3 msyii\db\Command::querySELECT "c"."project_id", sum(hours), sum(times) as times FROM "a57be577deb434"."tbl_cases" "c" LEFT JOIN (SELECT "case_id", EXTRACT(epoch FROM sum(left_at - arrived_at)) /3600 AS hours, count(id) as times FROM "a57be577deb434"."tbl_implement_records" WHERE "is_draft"=FALSE GROUP BY "case_id") "i" ON i.case_id = c.id WHERE ("case_type"=2) AND ("c"."project_id" IN (3960, 4006, 4003, 3969, 3888, 3956, 3922, 3883, 3917, 3841, 3910, 3911, 3900, 3898, 3875, 3834, 3866, 3869, 3852, 3863)) GROUP BY "c"."project_id"
10:33:21.9608.7 msyii\db\Command::queryselect 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_project_architects' and ns.nspname='a57be577deb434' order by fns.nspname, fc.relname, a.attnum
10:33:22.1707.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_visit_module_histories" WHERE ("user_id"=1001) AND ("object_type"=23) AND ("visit_date"='2025-12-22')
10:33:22.0736.6 msyii\db\Command::querySELECT "id", "id" AS "key", "contract_id", "amount" AS "value" FROM (SELECT * FROM ((SELECT '1' || r.id::varchar as id, 1 as ticket_type, r.sales_contract_id as contract_id, r.amount as amount, t.created_at 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 (r.sales_contract_id is not null) AND ("t"."status" IN (2, 5))) UNION ALL ( SELECT '2' || r.id::varchar as id, 2 as ticket_type, r.sales_contract_id as contract_id, r.amount as amount, t.created_at as collected_date, t.created_at, t.created_by, t.abstract as description FROM "a57be577deb434"."tbl_erp_cash_cost_ticket_sales_contract_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_cash_cost_tickets" "t" ON r.erp_cash_cost_ticket_id = t.id WHERE (r.sales_contract_id is not null) AND ("t"."is_payment_settle"=TRUE) AND ("t"."status" IN (2, 5)) ) UNION ALL ( SELECT '3' || r.id::varchar as id, 3 as ticket_type, r.sales_contract_id as contract_id, 0 - r.amount as amount, t.created_at 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 (r.sales_contract_id is not null) AND ("t"."is_payment_settle"=TRUE) AND ("t"."status" IN (2, 5)) )) "sub") "r" WHERE "contract_id" IN (4024, 4046, 4147, 4044, 4035, 4129, 4168, 4198, 4197, 4226, 3941, 3931, 3924, 3952, 3958, 4020, 4027, 4008, 4061, 3953) ORDER BY "id" DESC
10:33:21.9336.1 msyii\db\Command::querySELECT p.*, (p.budget / 100 * p.profit_pct) as profit, now() - status_updated_at as remain, now() - progress_updated_at as progress_remain, now() - forecast_updated_at as forecast_remain, case when p.end_at IS NOT NULL THEN p.end_at - p.created_at ELSE now() - p.created_at END as duration, (SELECT sum(amount) FROM a57be577deb434.tbl_invoices i WHERE i.project_id = p.id) as issued_invoices FROM "a57be577deb434"."tbl_projects" "p" LEFT JOIN "a57be577deb434"."tbl_clients" "c" ON p.client_id = c.id LEFT JOIN "a57be577deb434"."tbl_project_architects" "pa" ON "pa"."project_id" = "p"."id" WHERE ("p"."created_by" 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, 5409, 5412, 5229, 1005, 5304, 5449, 5358, 1006, 5093)) AND ("project_status"=3) AND ("pa"."engineer_id" IN (1017, 5085, 1001, 5248, 1015, 1022, 5296, 1023)) AND ("p"."bargain_date" >= '2025-01-01 00:00:00') AND (p.bargain_date < TIMESTAMP '2025-12-31 23:59:59' + INTERVAL '1 second') GROUP BY "p"."id" ORDER BY "p"."bargain_date" DESC LIMIT 20
10:33:22.0575.4 msyii\db\Command::querySELECT "project_id", sum(amount) AS sum FROM "a57be577deb434"."tbl_reimbursements" WHERE ("status" IN (2, 3)) AND ("project_id" IN (3960, 4006, 4003, 3969, 3888, 3956, 3922, 3883, 3917, 3841, 3910, 3911, 3900, 3898, 3875, 3834, 3866, 3869, 3852, 3863)) GROUP BY "project_id"
10:33:22.0285.0 msyii\db\Command::querySELECT 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_cases' and d.nspname = 'a57be577deb434' ORDER BY a.attnum;
10:33:21.9284.8 msyii\db\Command::querySELECT COUNT(*) FROM (SELECT p.*, (p.budget / 100 * p.profit_pct) as profit, now() - status_updated_at as remain, now() - progress_updated_at as progress_remain, now() - forecast_updated_at as forecast_remain, case when p.end_at IS NOT NULL THEN p.end_at - p.created_at ELSE now() - p.created_at END as duration, (SELECT sum(amount) FROM a57be577deb434.tbl_invoices i WHERE i.project_id = p.id) as issued_invoices FROM "a57be577deb434"."tbl_projects" "p" LEFT JOIN "a57be577deb434"."tbl_clients" "c" ON p.client_id = c.id LEFT JOIN "a57be577deb434"."tbl_project_architects" "pa" ON "pa"."project_id" = "p"."id" WHERE ("p"."created_by" 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, 5409, 5412, 5229, 1005, 5304, 5449, 5358, 1006, 5093)) AND ("project_status"=3) AND ("pa"."engineer_id" IN (1017, 5085, 1001, 5248, 1015, 1022, 5296, 1023)) AND ("p"."bargain_date" >= '2025-01-01 00:00:00') AND (p.bargain_date < TIMESTAMP '2025-12-31 23:59:59' + INTERVAL '1 second') GROUP BY "p"."id" ORDER BY "p"."bargain_date" DESC) "c"
10:33:22.1814.8 msyii\db\Command::queryINSERT INTO "global"."tbl_api_log" ("code", "schema", "user_id", "device_type", "url", "request", "response", "php_error", "time") VALUES (200, 'a57be577deb434', 1001, 5, 'vue/analysis/pre-sales-project-list', '{"period":"currentfascalyear","alert":"false","page":"1","web_access_token":"lJec5OoLODuCvm6gBWbjtNJVDT-F6hci"}', '{"code":2000,"result":{"list":[{"id":3960,"client_id":57,"project_status":3,"project_progress":6,"budget":"13750","profit_pct":"19.83","bargain_date":"2025-10-30","description":"","created_by":1005,"created_at":"2025-09-02 11:15:53","updated_at":"2025-11-07 17:50:40","engineer_id":"","project_title":"veeam\u7eed\u4fdd-2025\u5e74","collected":"0","status_updated_at":"2025-10-30 10:57:05.143242+08","success_rate":"","comment":"","contract_type":1,"progress_updated_at":"2025-09-07 20:56:19.319411+08","forecast_updated_at":"2025-09-07 20:56:19.319411+08","end_at":"","pinyin_shortcut":"veeamxb2025n","creator":1005,"used_client":"","from_contact":"","total_contact_point":"","paid_contact_point":"","project_product_version_id":1058,"is_sales_order_ready":false,"collected_plan":"13750","change_status_to":"","is_verify":false,"profit":"2726.625000000000000000","remain":"52 days 23:36:16.790906","progress_remain":"105 days 13:37:02.614737","forecast_remain":"105 days 13:37:02.614737","duration":"110 days 23:17:28.677375","issued_invoices":"13750.00","client":{"id":57,"key":57,"name":"\u4fdd\u8bfa\u79d1\u6280(\u5317\u4eac)\u6709\u9650\u516c\u53f8\u3001\u4e0a\u6d77\u6da6\u8bfa\u3001\u4e2d\u56fd\u7535\u5b50\u7cfb\u7edf\u5de5\u7a0b\u7b2c\u4e8c\u5efa\u8bbe\u6709\u9650\u516c\u53f8,\u6851\u8fea\u4e9a\u533b\u836f\u6280\u672f(\u4e0a\u6d77)\u6709\u9650\u8d23\u4efb\u516c\u53f8","logo":"","client_type":5,"client_class":47,"client_industry":5,"clientType":{"id":5,"key":5,"name":"\u5546\u4e1a"},"clientClass":{"id":47,"key":47,"name":"\u76ee\u6807\u5ba2\u6237","notice_days":30,"color":"#EB13C3"},"clientIndustry":{"id":5,"key":5,"name":"\u5236\u9020"}},"projectArchitects":[{"project_id":3960,"value":"1","key":1015,"name":"\u5434\u660a"}],"projectStatus":{"id":3,"key":3,"name":"\u5546\u673a\u6210\u4ea4","color":"#53cd02"},"projectProgress":{"id":6,"key":6,"name":"\u63a8\u52a8\u6210\u4ea4"},"projectProductTypes":[{"id":7,"product_type_id":7,"key":7,"name":"\u8f6f\u4ef6","budget":"13750","pct":"19.83","profit":"2726.62","project_id":3960}],"salesForecast":{"id":172,"key":172,"name":"\u6211\u4e0e\u5382\u5546\u8054\u624b"},"opportunityFrom":{},"purchaseType":{"id":130,"key":130,"name":"\u7ade\u4e89\u8c08\u5224"},"contractType":{"id":1,"key":1,"name":"\u4ea7\u54c1\u9500\u552e"},"createdBy":{"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"}},"salesRep":{"id":1005,"key":1005,"name":"\u8d75\u6657\u7131","sex":"F","avatar":{"id":16,"user_id":1005,"name":"\/files\/cdn\/a57be577deb434\/avatar\/56876dde-37eb-39fc-853a-47eaef6510e5.png"}},"salesTimeCount":{},"implementTimeCount":{"project_id":3960,"sum":"0.75","times":"1"},"presalesTimeCount":{},"engineerTimeCount":{},"reimbursementAmountSum":{},"buildContract":{"id":4226,"from_project":3960,"payment_collection_remind_ahead":"00:00:00","serial_no":"\u4fdd\u8bfa\u5317\u4eacCD2025103000010161","salesContractPayments":[],"salesContractInvoices":[{"id":2194,"key":2194,"contract_id":4226,"value":"13750.00","attachment_id":"","from_date":"2025-11-05","attachment":{}}],"salesContractPaymentCollectionRemindDates":[{"id":2612,"key":2612,"contract_id":4226,"name":"2025-12-15","value":"13750","overdue_days":"","status":0,"remind_date":"2025-12-15"}]},"commentCount":{"object_id":3960,"comment":2},"unreadComments":{},"unissued_invoice":0,"is_exceeded":false,"unread":0,"project_status_display":"\u5546\u673a\u6210\u4ea4","is_collected":false,"bgcolor":"#53cd02","remain_display":52,"progress_remain_display":105,"forecast_remain_display":105,"contract_type_display":"\u4ea7\u54c1\u9500\u552e"},{"id":4006,"client_id":42,"project_status":3,"project_progress":9,"budget":"3500","profit_pct":"93","bargain_date":"2025-10-17","description":"","created_by":5295,"created_at":"2025-10-17 11:28:43","updated_at":"2025-11-13 11:54:31","engineer_id":"","project_title":"\u62d3\u5b9e\u6280\u672f\u670d\u52a1","collected":"3500","status_updated_at":"2025-10-17 11:28:43.976703+08","success_rate":"","comment":"","contract_type":1,"progress_updated_at":"2025-10-17 11:28:43.976703+08","forecast_updated_at":"2025-10-17 11:28:43.976703+08","end_at":"2025-10-30 16:41:47","pinyin_shortcut":"tsjsfw","creator":5295,"used_client":"","from_contact":"","total_contact_point":"","paid_contact_point":"","project_product_version_id":1040,"is_sales_order_ready":true,"collected_plan":"3500","change_status_to":"","is_verify":false,"profit":"3255.0000000000000000","remain":"65 days 23:04:37.957445","progress_remain":"65 days 23:04:37.957445","forecast_remain":"65 days 23:04:37.957445","duration":"13 days 05:13:03.392626","issued_invoices":"3500.00","client":{"id":42,"key":42,"name":"\u5317\u4eac\u4e50\u5065\u4e1c\u5916\u95e8\u8bca\u90e8\u6709\u9650\u516c\u53f8","logo":"","client_type":1,"client_class":43,"client_industry":3,"clientType":{"id":1,"key":1,"name":"\u653f\u5e9c"},"clientClass":{"id":43,"key":43,"name":"\u6f5c\u529b\u5ba2\u6237","notice_days":60,"color":"#1EE6DC"},"clientIndustry":{"id":3,"key":3,"name":"\u533b\u7597"}},"projectArchitects":[{"project_id":4006,"value":"1","key":1023,"name":"\u5468\u5b50\u5065"}],"projectStatus":{"id":3,"key":3,"name":"\u5546\u673a\u6210\u4ea4","color":"#53cd02"},"projectProgress":{"id":9,"key":9,"name":"\u7b7e\u8ba2\u5408\u540c"},"projectProductTypes":[{"id":19,"product_type_id":19,"key":19,"name":"\u6280\u672f\u670d\u52a1","budget":"3500","pct":"93","profit":"3255","project_id":4006}],"salesForecast":{"id":142,"key":142,"name":"\u6211\u4e0e\u5ba2\u6237\u8054\u624b"},"opportunityFrom":{},"purchaseType":{"id":164,"key":164,"name":"\u591a\u5bb6\u6bd4\u4ef7"},"contractType":{"id":1,"key":1,"name":"\u4ea7\u54c1\u9500\u552e"},"createdBy":{"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"}},"salesRep":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F","avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"}},"salesTimeCount":{},"implementTimeCount":{"project_id":4006,"sum":"8.68333333333333","times":"2"},"presalesTimeCount":{},"engineerTimeCount":{},"reimbursementAmountSum":{},"buildContract":{"id":4197,"from_project":4006,"payment_collection_remind_ahead":"00:00:00","serial_no":"2025-10-17-001","salesContractPayments":[{"id":"12069","key":"12069","contract_id":4197,"value":"3500"}],"salesContractInvoices":[{"id":2172,"key":2172,"contract_id":4197,"value":"3500.00","attachment_id":"","from_date":"2025-10-17","attachment":{}},{"id":2184,"key":2184,"contract_id":4197,"value":"3500.00","attachment_id":"","from_date":"2025-10-17","attachment":{}},{"id":2185,"key":2185,"contract_id":4197,"value":"-3500.00","attachment_id":"","from_date":"2025-10-28","attachment":{}},{"id":2186,"key":2186,"contract_id":4197,"value":"3500.00","attachment_id":"","from_date":"2025-10-28","attachment":{}},{"id":2188,"key":2188,"contract_id":4197,"value":"-3500.00","attachment_id":"","from_date":"2025-10-28","attachment":{}}],"salesContractPaymentCollectionRemindDates":[{"id":2594,"key":2594,"contract_id":4197,"name":"2025-11-21","value":"3500","overdue_days":"","status":1,"remind_date":"2025-11-21"}]},"commentCount":{"object_id":4006,"comment":3},"unreadComments":{},"unissued_invoice":0,"is_exceeded":false,"unread":0,"project_status_display":"\u6536\u6b3e\u5b8c\u6210","is_collected":true,"bgcolor":"#6200fe","remain_display":65,"progress_remain_display":65,"forecast_remain_display":65,"contract_type_display":"\u4ea7\u54c1\u9500\u552e"},{"id":4003,"client_id":1301,"project_status":3,"project_progress":9,"budget":"19584","profit_pct":"13.03","bargain_date":"2025-10-17","description":"","created_by":5295,"created_at":"2025-10-16 14:36:19","updated_at":"2025-11-04 17:34:54","engineer_id":"","project_title":"\u65b0\u8d2d\u63a5\u5165\u4ea4\u6362\u673a","collected":"19584","status_updated_at":"2025-10-17 14:20:20.869055+08","success_rate":"","comment":"","contract_type":1,"progress_updated_at":"2025-10-16 14:36:19.243473+08","forecast_updated_at":"2025-10-16 14:36:19.243473+08","end_at":"2025-11-13 16:03:22","pinyin_shortcut":"xgjrjhj","creator":5295,"used_client":"","from_contact":"","total_contact_point":"","paid_contact_point":"","project_product_version_id":1042,"is_sales_order_ready":true,"collected_plan":"19584.0","change_status_to":"","is_verify":false,"profit":"2551.795200000000000000","remain":"65 days 20:13:01.065093","progress_remain":"66 days 19:57:02.690675","forecast_remain":"66 days 19:57:02.690675","duration":"28 days 01:27:03.064264","issued_invoices":"19584.00","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)","logo":"","client_type":1,"client_class":43,"client_industry":5,"clientType":{"id":1,"key":1,"name":"\u653f\u5e9c"},"clientClass":{"id":43,"key":43,"name":"\u6f5c\u529b\u5ba2\u6237","notice_days":60,"color":"#1EE6DC"},"clientIndustry":{"id":5,"key":5,"name":"\u5236\u9020"}},"projectArchitects":[{"project_id":4003,"value":"1","key":5248,"name":"\u6587\u4f73\u9f99"}],"projectStatus":{"id":3,"key":3,"name":"\u5546\u673a\u6210\u4ea4","color":"#53cd02"},"projectProgress":{"id":9,"key":9,"name":"\u7b7e\u8ba2\u5408\u540c"},"projectProductTypes":[{"id":4,"product_type_id":4,"key":4,"name":"\u7f51\u7edc\u8bbe\u5907 ","budget":"19584","pct":"13.03","profit":"2551.79","project_id":4003}],"salesForecast":{"id":142,"key":142,"name":"\u6211\u4e0e\u5ba2\u6237\u8054\u624b"},"opportunityFrom":{},"purchaseType":{"id":164,"key":164,"name":"\u591a\u5bb6\u6bd4\u4ef7"},"contractType":{"id":1,"key":1,"name":"\u4ea7\u54c1\u9500\u552e"},"createdBy":{"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"}},"salesRep":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F","avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"}},"salesTimeCount":{},"implementTimeCount":{"project_id":4003,"sum":"30.9166666666667","times":"6"},"presalesTimeCount":{"project_id":4003,"sum":"7.01666666666667","times":"1"},"engineerTimeCount":{},"reimbursementAmountSum":{},"buildContract":{"id":4198,"from_project":4003,"payment_collection_remind_ahead":"00:00:00","serial_no":"TS-WZW-20251016001","salesContractPayments":[{"id":"12083","key":"12083","contract_id":4198,"value":"13708.8"},{"id":"12059","key":"12059","contract_id":4198,"value":"5875.2"}],"salesContractInvoices":[{"id":2175,"key":2175,"contract_id":4198,"value":"5875.20","attachment_id":"","from_date":"2025-10-22","attachment":{}},{"id":2192,"key":2192,"contract_id":4198,"value":"13708.80","attachment_id":"","from_date":"2025-11-04","attachment":{}}],"salesContractPaymentCollectionRemindDates":[{"id":2595,"key":2595,"contract_id":4198,"name":"2025-11-07","value":"5875.2","overdue_days":"","status":1,"remind_date":"2025-11-07"},{"id":2596,"key":2596,"contract_id":4198,"name":"2025-11-30","value":"13708.8","overdue_days":"","status":1,"remind_date":"2025-11-30"}]},"commentCount":{"object_id":4003,"comment":3},"unreadComments":{},"unissued_invoice":0,"is_exceeded":false,"unread":0,"project_status_display":"\u6536\u6b3e\u5b8c\u6210","is_collected":true,"bgcolor":"#6200fe","remain_display":65,"progress_remain_display":66,"forecast_remain_display":66,"contract_type_display":"\u4ea7\u54c1\u9500\u552e"},{"id":3969,"client_id":48,"project_status":3,"project_progress":9,"budget":"2000","profit_pct":"62.38","bargain_date":"2025-09-17","description":"","created_by":1004,"created_at":"2025-09-18 09:35:38","updated_at":"2025-10-23 17:14:00","engineer_id":"","project_title":"\u5b58\u50a8\u786c\u76d8\u914d\u4ef6","collected":"2000","status_updated_at":"2025-09-18 09:36:36.186218+08","success_rate":"","comment":"","contract_type":1,"progress_updated_at":"2025-09-18 09:35:38.644814+08","forecast_updated_at":"2025-09-18 09:35:38.644814+08","end_at":"2025-10-13 17:32:56","pinyin_shortcut":"ccyppj","creator":1004,"used_client":"","from_contact":"","total_contact_point":"","paid_contact_point":"","project_product_version_id":1029,"is_sales_order_ready":true,"collected_plan":"2000","change_status_to":"","is_verify":false,"profit":"1247.600000000000000000","remain":"95 days 00:56:45.74793","progress_remain":"95 days 00:57:43.289334","forecast_remain":"95 days 00:57:43.289334","duration":"25 days 07:57:18.245883","issued_invoices":"2000.00","client":{"id":48,"key":48,"name":"\u4e2d\u90fd\u6570\u79d1\u4f9b\u5e94\u94fe\u7ba1\u7406\u6709\u9650\u516c\u53f8","logo":"","client_type":5,"client_class":47,"client_industry":8,"clientType":{"id":5,"key":5,"name":"\u5546\u4e1a"},"clientClass":{"id":47,"key":47,"name":"\u76ee\u6807\u5ba2\u6237","notice_days":30,"color":"#EB13C3"},"clientIndustry":{"id":8,"key":8,"name":"\u7269\u6d41"}},"projectArchitects":[{"project_id":3969,"value":"1","key":1023,"name":"\u5468\u5b50\u5065"}],"projectStatus":{"id":3,"key":3,"name":"\u5546\u673a\u6210\u4ea4","color":"#53cd02"},"projectProgress":{"id":9,"key":9,"name":"\u7b7e\u8ba2\u5408\u540c"},"projectProductTypes":[{"id":3,"product_type_id":3,"key":3,"name":"\u5b58\u50a8\u8bbe\u5907","budget":"2000","pct":"62.38","profit":"1247.6","project_id":3969}],"salesForecast":{"id":181,"key":181,"name":"\u6211\u81ea\u5df1\u505a\u5e84"},"opportunityFrom":{},"purchaseType":{"id":165,"key":165,"name":"\u534f\u8bae\u4f9b\u8d27"},"contractType":{"id":1,"key":1,"name":"\u4ea7\u54c1\u9500\u552e"},"createdBy":{"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"}},"salesRep":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0","sex":"M","avatar":{"id":10,"user_id":1004,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1004.jpg"}},"salesTimeCount":{},"implementTimeCount":{},"presalesTimeCount":{},"engineerTimeCount":{},"reimbursementAmountSum":{},"buildContract":{"id":4168,"from_project":3969,"payment_collection_remind_ahead":"00:00:00","serial_no":"TS-YJC-20250917-01","salesContractPayments":[{"id":"12049","key":"12049","contract_id":4168,"value":"2000"}],"salesContractInvoices":[{"id":2163,"key":2163,"contract_id":4168,"value":"2000.00","attachment_id":"","from_date":"2025-09-26","attachment":{}}],"salesContractPaymentCollectionRemindDates":[{"id":2585,"key":2585,"contract_id":4168,"name":"2025-09-30","value":"2000","overdue_days":13,"status":1,"remind_date":"2025-09-30"}]},"commentCount":{"object_id":3969,"comment":4},"unreadComments":{},"unissued_invoice":0,"is_exceeded":false,"unread":0,"project_status_display":"\u6536\u6b3e\u5b8c\u6210","is_collected":true,"bgcolor":"#6200fe","remain_display":95,"progress_remain_display":95,"forecast_remain_display":95,"contract_type_display":"\u4ea7\u54c1\u9500\u552e"},{"id":3888,"client_id":3370,"project_status":3,"project_progress":9,"budget":"215700","profit_pct":"2.56","bargain_date":"2025-08-27","description":"","created_by":5300,"created_at":"2025-06-10 13:43:05","updated_at":"2025-11-11 15:59:01","engineer_id":"","project_title":"\u8054\u60f3\u670d\u52a1\u5668\u65b0\u8d2d-K-2025","collected":"107850","status_updated_at":"2025-09-04 10:49:30.799979+08","success_rate":"","comment":"","contract_type":1,"progress_updated_at":"2025-09-01 09:50:14.405276+08","forecast_updated_at":"2025-10-24 18:30:26.85348+08","end_at":"","pinyin_shortcut":"lxfwqxgK2025","creator":5300,"used_client":"","from_contact":"","total_contact_point":"","paid_contact_point":"","project_product_version_id":1051,"is_sales_order_ready":false,"collected_plan":"215700","change_status_to":"","is_verify":false,"profit":"5521.920000000000000000","remain":"108 days 23:43:51.134169","progress_remain":"112 days 00:43:07.528872","forecast_remain":"58 days 16:02:55.080668","duration":"194 days 20:50:16.282665","issued_invoices":"100107.00","client":{"id":3370,"key":3370,"name":"\u77e5\u884c\u89c2\u590d\uff08\u6210\u90fd\uff09\u6587\u5316\u79d1\u6280\u6709\u9650\u516c\u53f8","logo":"","client_type":5,"client_class":43,"client_industry":13,"clientType":{"id":5,"key":5,"name":"\u5546\u4e1a"},"clientClass":{"id":43,"key":43,"name":"\u6f5c\u529b\u5ba2\u6237","notice_days":60,"color":"#1EE6DC"},"clientIndustry":{"id":13,"key":13,"name":"SI\/ISV"}},"projectArchitects":[{"project_id":3888,"value":"1","key":1015,"name":"\u5434\u660a"}],"projectStatus":{"id":3,"key":3,"name":"\u5546\u673a\u6210\u4ea4","color":"#53cd02"},"projectProgress":{"id":9,"key":9,"name":"\u7b7e\u8ba2\u5408\u540c"},"projectProductTypes":[{"id":2,"product_type_id":2,"key":2,"name":"\u670d\u52a1\u5668","budget":"215700","pct":"2.56","profit":"5521.92","project_id":3888}],"salesForecast":{"id":142,"key":142,"name":"\u6211\u4e0e\u5ba2\u6237\u8054\u624b"},"opportunityFrom":{},"purchaseType":{"id":164,"key":164,"name":"\u591a\u5bb6\u6bd4\u4ef7"},"contractType":{"id":1,"key":1,"name":"\u4ea7\u54c1\u9500\u552e"},"createdBy":{"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"}},"salesRep":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91","sex":"F","avatar":{"id":141,"user_id":5300,"name":"\/files\/cdn\/a57be577deb434\/avatar\/14dfd1a0-6df5-354a-8afd-f0a76fa8e852.png"}},"salesTimeCount":{"project_id":3888,"hours":"0.716666666666667","times":1},"implementTimeCount":{},"presalesTimeCount":{},"engineerTimeCount":{},"reimbursementAmountSum":{},"buildContract":{"id":4147,"from_project":3888,"payment_collection_remind_ahead":"1 day","serial_no":"TSJ-2025082701-SQY","salesContractPayments":[{"id":"12064","key":"12064","contract_id":4147,"value":"7743"},{"id":"12055","key":"12055","contract_id":4147,"value":"100107"}],"salesContractInvoices":[{"id":2164,"key":2164,"contract_id":4147,"value":"100107.00","attachment_id":"","from_date":"2025-09-29","attachment":{}}],"salesContractPaymentCollectionRemindDates":[{"id":2606,"key":2606,"contract_id":4147,"name":"2025-09-27","value":"107850","overdue_days":30,"status":1,"remind_date":"2025-09-27"},{"id":2607,"key":2607,"contract_id":4147,"name":"2025-11-30","value":"107850","overdue_days":"","status":0,"remind_date":"2025-11-30"}]},"commentCount":{"object_id":3888,"comment":5},"unreadComments":{},"unissued_invoice":115593,"is_exceeded":false,"unread":0,"project_status_display":"\u5546\u673a\u6210\u4ea4","is_collected":false,"bgcolor":"#53cd02","remain_display":108,"progress_remain_display":112,"forecast_remain_display":58,"contract_type_display":"\u4ea7\u54c1\u9500\u552e"},{"id":3956,"client_id":2182,"project_status":3,"project_progress":4,"budget":"1360","profit_pct":"35.1","bargain_date":"2025-08-26","description":"","created_by":5300,"created_at":"2025-08-26 13:53:37","updated_at":"2025-09-24 13:41:12","engineer_id":"","project_title":"\u534e\u4e09\u9762\u677fAP\u65b0\u8d2d-2025","collected":"1360","status_updated_at":"2025-08-27 13:35:36.075805+08","success_rate":"","comment":"","contract_type":1,"progress_updated_at":"2025-08-26 13:53:37.769647+08","forecast_updated_at":"2025-08-27 13:32:57.462933+08","end_at":"2025-09-12 09:58:31","pinyin_shortcut":"hsmbAPxg2025","creator":5300,"used_client":"","from_contact":"","total_contact_point":"","paid_contact_point":"","project_product_version_id":1005,"is_sales_order_ready":true,"collected_plan":"1360","change_status_to":"","is_verify":false,"profit":"477.36000000000000000","remain":"116 days 20:57:45.858343","progress_remain":"117 days 20:39:44.164501","forecast_remain":"116 days 21:00:24.471215","duration":"16 days 20:04:53.572944","issued_invoices":"1360.00","client":{"id":2182,"key":2182,"name":"\u5317\u4eac\u5357\u65b9\u65af\u5948\u514b\u739b\u6da1\u8f6e\u6280\u672f\u6709\u9650\u516c\u53f8","logo":"","client_type":5,"client_class":80,"client_industry":20,"clientType":{"id":5,"key":5,"name":"\u5546\u4e1a"},"clientClass":{"id":80,"key":80,"name":"\u7a33\u5b9a\u5ba2\u6237","notice_days":30,"color":"#0EE315"},"clientIndustry":{"id":20,"key":20,"name":"\u5176\u4ed6"}},"projectArchitects":[{"project_id":3956,"value":"1","key":1022,"name":"\u5f90\u7855"}],"projectStatus":{"id":3,"key":3,"name":"\u5546\u673a\u6210\u4ea4","color":"#53cd02"},"projectProgress":{"id":4,"key":4,"name":"\u786e\u8ba4\u65b9\u6848"},"projectProductTypes":[{"id":4,"product_type_id":4,"key":4,"name":"\u7f51\u7edc\u8bbe\u5907 ","budget":"1360","pct":"35.1","profit":"477.36","project_id":3956}],"salesForecast":{"id":181,"key":181,"name":"\u6211\u81ea\u5df1\u505a\u5e84"},"opportunityFrom":{},"purchaseType":{"id":164,"key":164,"name":"\u591a\u5bb6\u6bd4\u4ef7"},"contractType":{"id":1,"key":1,"name":"\u4ea7\u54c1\u9500\u552e"},"createdBy":{"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"}},"salesRep":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91","sex":"F","avatar":{"id":141,"user_id":5300,"name":"\/files\/cdn\/a57be577deb434\/avatar\/14dfd1a0-6df5-354a-8afd-f0a76fa8e852.png"}},"salesTimeCount":{},"implementTimeCount":{},"presalesTimeCount":{},"engineerTimeCount":{},"reimbursementAmountSum":{},"buildContract":{"id":4129,"from_project":3956,"payment_collection_remind_ahead":"1 day","serial_no":"TS-SQY-2025082701","salesContractPayments":[{"id":"12020","key":"12020","contract_id":4129,"value":"1360"}],"salesContractInvoices":[{"id":2138,"key":2138,"contract_id":4129,"value":"1360.00","attachment_id":"","from_date":"2025-08-28","attachment":{}}],"salesContractPaymentCollectionRemindDates":[{"id":2559,"key":2559,"contract_id":4129,"name":"2025-09-26","value":"1360","overdue_days":"","status":1,"remind_date":"2025-09-26"}]},"commentCount":{"object_id":3956,"comment":5},"unreadComments":{},"unissued_invoice":0,"is_exceeded":false,"unread":0,"project_status_display":"\u6536\u6b3e\u5b8c\u6210","is_collected":true,"bgcolor":"#6200fe","remain_display":116,"progress_remain_display":117,"forecast_remain_display":116,"contract_type_display":"\u4ea7\u54c1\u9500\u552e"},{"id":3922,"client_id":2136,"project_status":3,"project_progress":49,"budget":"45500","profit_pct":"28.38","bargain_date":"2025-07-20","description":"","created_by":5087,"created_at":"2025-07-20 14:44:13","updated_at":"2025-11-10 01:09:16","engineer_id":"","project_title":"\u4e92\u8054\u7f51\u5ba1\u8ba1\u9879\u76ee","collected":"0","status_updated_at":"2025-11-02 23:38:40.226093+08","success_rate":"","comment":"","contract_type":1,"progress_updated_at":"2025-11-02 23:38:40.226093+08","forecast_updated_at":"2025-11-02 23:38:40.226093+08","end_at":"","pinyin_shortcut":"hlwsjxm","creator":5087,"used_client":"","from_contact":"","total_contact_point":"5000","paid_contact_point":"","project_product_version_id":987,"is_sales_order_ready":true,"collected_plan":"45500","change_status_to":"","is_verify":false,"profit":"12912.900000000000000000","remain":"49 days 10:54:41.708055","progress_remain":"49 days 10:54:41.708055","forecast_remain":"49 days 10:54:41.708055","duration":"154 days 19:49:08.448276","issued_invoices":"45500.00","client":{"id":2136,"key":2136,"name":"\u5317\u4eac\u7279\u79cd\u673a\u68b0\u7814\u7a76\u6240 59\u6240","logo":"","client_type":6,"client_class":47,"client_industry":5,"clientType":{"id":6,"key":6,"name":"\u592e\u4f01"},"clientClass":{"id":47,"key":47,"name":"\u76ee\u6807\u5ba2\u6237","notice_days":30,"color":"#EB13C3"},"clientIndustry":{"id":5,"key":5,"name":"\u5236\u9020"}},"projectArchitects":[{"project_id":3922,"value":"1","key":1017,"name":"\u8f66\u660e\u98de"}],"projectStatus":{"id":3,"key":3,"name":"\u5546\u673a\u6210\u4ea4","color":"#53cd02"},"projectProgress":{"id":49,"key":49,"name":"\u6536\u6b3e\u4e2d"},"projectProductTypes":[{"id":4,"product_type_id":4,"key":4,"name":"\u7f51\u7edc\u8bbe\u5907 ","budget":"36000","pct":"28.38","profit":"10216.8","project_id":3922},{"id":7,"product_type_id":7,"key":7,"name":"\u8f6f\u4ef6","budget":"4000","pct":"28.38","profit":"1135.2","project_id":3922},{"id":19,"product_type_id":19,"key":19,"name":"\u6280\u672f\u670d\u52a1","budget":"5500","pct":"28.38","profit":"1560.9","project_id":3922}],"salesForecast":{"id":142,"key":142,"name":"\u6211\u4e0e\u5ba2\u6237\u8054\u624b"},"opportunityFrom":{},"purchaseType":{"id":164,"key":164,"name":"\u591a\u5bb6\u6bd4\u4ef7"},"contractType":{"id":1,"key":1,"name":"\u4ea7\u54c1\u9500\u552e"},"createdBy":{"id":5087,"key":5087,"name":"\u5218\u5fae","sex":"F","department_id":1,"avatar":{"id":62,"user_id":5087,"name":"\/files\/cdn\/a57be577deb434\/avatar\/06f75b3a-7b6c-37a8-81c0-b2934104daa7.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"salesRep":{"id":5087,"key":5087,"name":"\u5218\u5fae","sex":"F","avatar":{"id":62,"user_id":5087,"name":"\/files\/cdn\/a57be577deb434\/avatar\/06f75b3a-7b6c-37a8-81c0-b2934104daa7.png"}},"salesTimeCount":{},"implementTimeCount":{"project_id":3922,"sum":"3.41666666666667","times":"1"},"presalesTimeCount":{},"engineerTimeCount":{},"reimbursementAmountSum":{"project_id":3922,"sum":"129.05"},"buildContract":{"id":4061,"from_project":3922,"payment_collection_remind_ahead":"15 days","serial_no":"0129KB2025F0645","salesContractPayments":[],"salesContractInvoices":[{"id":2160,"key":2160,"contract_id":4061,"value":"45500.00","attachment_id":"","from_date":"2025-09-24","attachment":{}}],"salesContractPaymentCollectionRemindDates":[{"id":2521,"key":2521,"contract_id":4061,"name":"2025-09-29","value":"4550","overdue_days":"","status":0,"remind_date":"2025-09-29"},{"id":2519,"key":2519,"contract_id":4061,"name":"2025-09-30","value":"13650","overdue_days":"","status":0,"remind_date":"2025-09-30"},{"id":2520,"key":2520,"contract_id":4061,"name":"2025-11-30","value":"27300","overdue_days":"","status":0,"remind_date":"2025-11-30"}]},"commentCount":{"object_id":3922,"comment":12},"unreadComments":{},"unissued_invoice":0,"is_exceeded":false,"unread":0,"project_status_display":"\u5546\u673a\u6210\u4ea4","is_collected":false,"bgcolor":"#53cd02","remain_display":49,"progress_remain_display":49,"forecast_remain_display":49,"contract_type_display":"\u4ea7\u54c1\u9500\u552e"},{"id":3883,"client_id":2182,"project_status":3,"project_progress":10,"budget":"50000","profit_pct":"85.5","bargain_date":"2025-07-17","description":"","created_by":5300,"created_at":"2025-06-06 16:59:28","updated_at":"2025-10-31 10:07:39","engineer_id":"","project_title":"\u673a\u623f\u642c\u8fc1-K-2025","collected":"50000","status_updated_at":"2025-07-17 11:46:30.969133+08","success_rate":"","comment":"","contract_type":2,"progress_updated_at":"2025-07-17 11:42:35.37025+08","forecast_updated_at":"2025-07-14 16:44:03.253398+08","end_at":"2025-09-16 09:51:48","pinyin_shortcut":"jfbqK2025","creator":5300,"used_client":"","from_contact":"","total_contact_point":"3000","paid_contact_point":"3000","project_product_version_id":945,"is_sales_order_ready":true,"collected_plan":"50000","change_status_to":"","is_verify":false,"profit":"42750.00000000000000000","remain":"157 days 22:46:50.965015","progress_remain":"157 days 22:50:46.563898","forecast_remain":"160 days 17:49:18.68075","duration":"101 days 16:52:20.536808","issued_invoices":"50000.00","client":{"id":2182,"key":2182,"name":"\u5317\u4eac\u5357\u65b9\u65af\u5948\u514b\u739b\u6da1\u8f6e\u6280\u672f\u6709\u9650\u516c\u53f8","logo":"","client_type":5,"client_class":80,"client_industry":20,"clientType":{"id":5,"key":5,"name":"\u5546\u4e1a"},"clientClass":{"id":80,"key":80,"name":"\u7a33\u5b9a\u5ba2\u6237","notice_days":30,"color":"#0EE315"},"clientIndustry":{"id":20,"key":20,"name":"\u5176\u4ed6"}},"projectArchitects":[{"project_id":3883,"value":"1","key":1022,"name":"\u5f90\u7855"}],"projectStatus":{"id":3,"key":3,"name":"\u5546\u673a\u6210\u4ea4","color":"#53cd02"},"projectProgress":{"id":10,"key":10,"name":"\u4ea4\u8d27\u4e2d"},"projectProductTypes":[{"id":19,"product_type_id":19,"key":19,"name":"\u6280\u672f\u670d\u52a1","budget":"50000","pct":"85.5","profit":"42750","project_id":3883}],"salesForecast":{"id":142,"key":142,"name":"\u6211\u4e0e\u5ba2\u6237\u8054\u624b"},"opportunityFrom":{},"purchaseType":{"id":164,"key":164,"name":"\u591a\u5bb6\u6bd4\u4ef7"},"contractType":{"id":2,"key":2,"name":"\u8fd0\u7ef4\u670d\u52a1"},"createdBy":{"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"}},"salesRep":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91","sex":"F","avatar":{"id":141,"user_id":5300,"name":"\/files\/cdn\/a57be577deb434\/avatar\/14dfd1a0-6df5-354a-8afd-f0a76fa8e852.png"}},"salesTimeCount":{"project_id":3883,"hours":"3.1","times":4},"implementTimeCount":{"project_id":3883,"sum":"93.7666666666667","times":"11"},"presalesTimeCount":{"project_id":3883,"sum":"4.4","times":"4"},"engineerTimeCount":{},"reimbursementAmountSum":{"project_id":3883,"sum":"2506.35"},"buildContract":{"id":4044,"from_project":3883,"payment_collection_remind_ahead":"2 days","serial_no":"PO-2025-07-0006","salesContractPayments":[{"id":"1365","key":"1365","contract_id":4044,"value":"15000"},{"id":"12026","key":"12026","contract_id":4044,"value":"35000"}],"salesContractInvoices":[{"id":2136,"key":2136,"contract_id":4044,"value":"50000.00","attachment_id":"","from_date":"2025-08-25","attachment":{}}],"salesContractPaymentCollectionRemindDates":[{"id":2505,"key":2505,"contract_id":4044,"name":"2025-08-15","value":"15000","overdue_days":"","status":1,"remind_date":"2025-08-15"},{"id":2506,"key":2506,"contract_id":4044,"name":"2025-09-26","value":"35000","overdue_days":"","status":1,"remind_date":"2025-09-26"}]},"commentCount":{"object_id":3883,"comment":3},"unreadComments":{},"unissued_invoice":0,"is_exceeded":false,"unread":0,"project_status_display":"\u6536\u6b3e\u5b8c\u6210","is_collected":true,"bgcolor":"#6200fe","remain_display":157,"progress_remain_display":157,"forecast_remain_display":160,"contract_type_display":"\u8fd0\u7ef4\u670d\u52a1"},{"id":3917,"client_id":2182,"project_status":3,"project_progress":9,"budget":"5900","profit_pct":"15.69","bargain_date":"2025-07-17","description":"","created_by":5300,"created_at":"2025-07-14 16:50:51","updated_at":"2025-08-27 09:41:57","engineer_id":"","project_title":"\u5927\u534e\u76d1\u63a7\u8bbe\u5907\u65b0\u8d2d-K-2025","collected":"5900","status_updated_at":"2025-07-17 13:18:27.050361+08","success_rate":"","comment":"","contract_type":1,"progress_updated_at":"2025-07-14 16:50:51.37712+08","forecast_updated_at":"2025-07-14 16:50:51.37712+08","end_at":"2025-09-03 18:26:50","pinyin_shortcut":"dhjksbxgK2025","creator":5300,"used_client":"","from_contact":"","total_contact_point":"","paid_contact_point":"","project_product_version_id":968,"is_sales_order_ready":true,"collected_plan":"5900","change_status_to":"","is_verify":false,"profit":"925.710000000000000000","remain":"157 days 21:14:54.883787","progress_remain":"160 days 17:42:30.557028","forecast_remain":"160 days 17:42:30.557028","duration":"51 days 01:35:59.594606","issued_invoices":"5900.00","client":{"id":2182,"key":2182,"name":"\u5317\u4eac\u5357\u65b9\u65af\u5948\u514b\u739b\u6da1\u8f6e\u6280\u672f\u6709\u9650\u516c\u53f8","logo":"","client_type":5,"client_class":80,"client_industry":20,"clientType":{"id":5,"key":5,"name":"\u5546\u4e1a"},"clientClass":{"id":80,"key":80,"name":"\u7a33\u5b9a\u5ba2\u6237","notice_days":30,"color":"#0EE315"},"clientIndustry":{"id":20,"key":20,"name":"\u5176\u4ed6"}},"projectArchitects":[{"project_id":3917,"value":"1","key":1022,"name":"\u5f90\u7855"}],"projectStatus":{"id":3,"key":3,"name":"\u5546\u673a\u6210\u4ea4","color":"#53cd02"},"projectProgress":{"id":9,"key":9,"name":"\u7b7e\u8ba2\u5408\u540c"},"projectProductTypes":[{"id":4,"product_type_id":4,"key":4,"name":"\u7f51\u7edc\u8bbe\u5907 ","budget":"1839","pct":"15.69","profit":"288.53","project_id":3917},{"id":3,"product_type_id":3,"key":3,"name":"\u5b58\u50a8\u8bbe\u5907","budget":"786","pct":"15.69","profit":"123.32","project_id":3917},{"id":11,"product_type_id":11,"key":11,"name":"\u4e2a\u4eba\u8ba1\u7b97\u673a","budget":"1775","pct":"15.69","profit":"278.49","project_id":3917},{"id":19,"product_type_id":19,"key":19,"name":"\u6280\u672f\u670d\u52a1","budget":"1500","pct":"15.69","profit":"235.35","project_id":3917}],"salesForecast":{"id":142,"key":142,"name":"\u6211\u4e0e\u5ba2\u6237\u8054\u624b"},"opportunityFrom":{},"purchaseType":{"id":164,"key":164,"name":"\u591a\u5bb6\u6bd4\u4ef7"},"contractType":{"id":1,"key":1,"name":"\u4ea7\u54c1\u9500\u552e"},"createdBy":{"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"}},"salesRep":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91","sex":"F","avatar":{"id":141,"user_id":5300,"name":"\/files\/cdn\/a57be577deb434\/avatar\/14dfd1a0-6df5-354a-8afd-f0a76fa8e852.png"}},"salesTimeCount":{},"implementTimeCount":{},"presalesTimeCount":{},"engineerTimeCount":{},"reimbursementAmountSum":{},"buildContract":{"id":4046,"from_project":3917,"payment_collection_remind_ahead":"2 days","serial_no":"PO-2025-07-0007","salesContractPayments":[{"id":"1373","key":"1373","contract_id":4046,"value":"5900"}],"salesContractInvoices":[{"id":2133,"key":2133,"contract_id":4046,"value":"5900.00","attachment_id":"","from_date":"2025-08-25","attachment":{}}],"salesContractPaymentCollectionRemindDates":[{"id":2507,"key":2507,"contract_id":4046,"name":"2025-08-22","value":"5900","overdue_days":"","status":1,"remind_date":"2025-08-22"}]},"commentCount":{"object_id":3917,"comment":3},"unreadComments":{},"unissued_invoice":0,"is_exceeded":false,"unread":0,"project_status_display":"\u6536\u6b3e\u5b8c\u6210","is_collected":true,"bgcolor":"#6200fe","remain_display":157,"progress_remain_display":160,"forecast_remain_display":160,"contract_type_display":"\u4ea7\u54c1\u9500\u552e"},{"id":3841,"client_id":3343,"project_status":3,"project_progress":9,"budget":"183000","profit_pct":"14.62","bargain_date":"2025-07-12","description":"","created_by":1004,"created_at":"2025-04-29 09:07:50","updated_at":"2025-11-10 00:01:18","engineer_id":"","project_title":"2025PA\u9632\u706b\u5899\u66ff\u6362","collected":"183000","status_updated_at":"2025-09-07 21:52:23.894649+08","success_rate":"","comment":"","contract_type":1,"progress_updated_at":"2025-09-07 21:52:23.894649+08","forecast_updated_at":"2025-09-07 21:52:23.894649+08","end_at":"2025-11-10 14:18:01","pinyin_shortcut":"2025PAfhqth","creator":1004,"used_client":"","from_contact":"","total_contact_point":"","paid_contact_point":"","project_product_version_id":974,"is_sales_order_ready":true,"collected_plan":"183000","change_status_to":"","is_verify":false,"profit":"26754.600000000000000000","remain":"105 days 12:40:58.039499","progress_remain":"105 days 12:40:58.039499","forecast_remain":"105 days 12:40:58.039499","duration":"195 days 05:10:11.240782","issued_invoices":"183000.00","client":{"id":3343,"key":3343,"name":"\u5317\u4eac\u5317\u6c7d\u79d1\u6280\u670d\u52a1\u6709\u9650\u516c\u53f8(\u4e2d\u90fd\u4e09\u4ea7\uff09","logo":"","client_type":5,"client_class":43,"client_industry":5,"clientType":{"id":5,"key":5,"name":"\u5546\u4e1a"},"clientClass":{"id":43,"key":43,"name":"\u6f5c\u529b\u5ba2\u6237","notice_days":60,"color":"#1EE6DC"},"clientIndustry":{"id":5,"key":5,"name":"\u5236\u9020"}},"projectArchitects":[{"project_id":3841,"value":"1","key":1023,"name":"\u5468\u5b50\u5065"}],"projectStatus":{"id":3,"key":3,"name":"\u5546\u673a\u6210\u4ea4","color":"#53cd02"},"projectProgress":{"id":9,"key":9,"name":"\u7b7e\u8ba2\u5408\u540c"},"projectProductTypes":[{"id":5,"product_type_id":5,"key":5,"name":"\u5b89\u5168\u8bbe\u5907","budget":"183000","pct":"14.62","profit":"26754.6","project_id":3841}],"salesForecast":{"id":181,"key":181,"name":"\u6211\u81ea\u5df1\u505a\u5e84"},"opportunityFrom":{},"purchaseType":{"id":130,"key":130,"name":"\u7ade\u4e89\u8c08\u5224"},"contractType":{"id":1,"key":1,"name":"\u4ea7\u54c1\u9500\u552e"},"createdBy":{"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"}},"salesRep":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0","sex":"M","avatar":{"id":10,"user_id":1004,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1004.jpg"}},"salesTimeCount":{},"implementTimeCount":{"project_id":3841,"sum":"16.2","times":"4"},"presalesTimeCount":{},"engineerTimeCount":{},"reimbursementAmountSum":{"project_id":3841,"sum":"193.75"},"buildContract":{"id":4035,"from_project":3841,"payment_collection_remind_ahead":"1 day","serial_no":"TS-YJC-20250904-01","salesContractPayments":[{"id":"12080","key":"12080","contract_id":4035,"value":"73200"},{"id":"12043","key":"12043","contract_id":4035,"value":"109800"}],"salesContractInvoices":[{"id":2149,"key":2149,"contract_id":4035,"value":"109800.00","attachment_id":"","from_date":"2025-09-11","attachment":{}},{"id":2181,"key":2181,"contract_id":4035,"value":"73200.00","attachment_id":"","from_date":"2025-10-27","attachment":{}}],"salesContractPaymentCollectionRemindDates":[{"id":2544,"key":2544,"contract_id":4035,"name":"2025-09-30","value":"183000","overdue_days":41,"status":1,"remind_date":"2025-09-30"}]},"commentCount":{"object_id":3841,"comment":5},"unreadComments":{},"unissued_invoice":0,"is_exceeded":false,"unread":0,"project_status_display":"\u6536\u6b3e\u5b8c\u6210","is_collected":true,"bgcolor":"#6200fe","remain_display":105,"progress_remain_display":105,"forecast_remain_display":105,"contract_type_display":"\u4ea7\u54c1\u9500\u552e"},{"id":3910,"client_id":2762,"project_status":3,"project_progress":10,"budget":"3003980","profit_pct":"20.72","bargain_date":"2025-07-11","description":"","created_by":5087,"created_at":"2025-07-09 21:28:44","updated_at":"2025-11-13 13:40:05","engineer_id":"","project_title":"33\u6240\u9ad8\u6027\u80fd\u9879\u76ee","collected":"2102786","status_updated_at":"2025-07-13 23:45:04.905541+08","success_rate":"","comment":"","contract_type":1,"progress_updated_at":"2025-07-13 23:45:04.905541+08","forecast_updated_at":"2025-07-13 23:45:04.905541+08","end_at":"","pinyin_shortcut":"33sgxnxm","creator":5087,"used_client":"","from_contact":"","total_contact_point":"","paid_contact_point":"","project_product_version_id":977,"is_sales_order_ready":true,"collected_plan":"3003980","change_status_to":"","is_verify":false,"profit":"622424.65600000000000","remain":"161 days 10:48:17.028607","progress_remain":"161 days 10:48:17.028607","forecast_remain":"161 days 10:48:17.028607","duration":"165 days 13:04:37.805686","issued_invoices":"3003980.00","client":{"id":2762,"key":2762,"name":"\u4e0a\u6d77\u534e\u8baf\u7f51\u7edc\u7cfb\u7edf\u6709\u9650\u516c\u53f8\uff08\u8fc7\u5355\uff09","logo":"","client_type":5,"client_class":43,"client_industry":13,"clientType":{"id":5,"key":5,"name":"\u5546\u4e1a"},"clientClass":{"id":43,"key":43,"name":"\u6f5c\u529b\u5ba2\u6237","notice_days":60,"color":"#1EE6DC"},"clientIndustry":{"id":13,"key":13,"name":"SI\/ISV"}},"projectArchitects":[{"project_id":3910,"value":"1","key":1015,"name":"\u5434\u660a"}],"projectStatus":{"id":3,"key":3,"name":"\u5546\u673a\u6210\u4ea4","color":"#53cd02"},"projectProgress":{"id":10,"key":10,"name":"\u4ea4\u8d27\u4e2d"},"projectProductTypes":[{"id":10,"product_type_id":10,"key":10,"name":"\u56fe\u5f62\u5de5\u4f5c\u7ad9","budget":"2516000","pct":"20.72","profit":"521315.2","project_id":3910},{"id":7,"product_type_id":7,"key":7,"name":"\u8f6f\u4ef6","budget":"200000","pct":"20.72","profit":"41440","project_id":3910},{"id":2,"product_type_id":2,"key":2,"name":"\u670d\u52a1\u5668","budget":"287980","pct":"20.72","profit":"59669.45","project_id":3910}],"salesForecast":{"id":142,"key":142,"name":"\u6211\u4e0e\u5ba2\u6237\u8054\u624b"},"opportunityFrom":{},"purchaseType":{"id":165,"key":165,"name":"\u534f\u8bae\u4f9b\u8d27"},"contractType":{"id":1,"key":1,"name":"\u4ea7\u54c1\u9500\u552e"},"createdBy":{"id":5087,"key":5087,"name":"\u5218\u5fae","sex":"F","department_id":1,"avatar":{"id":62,"user_id":5087,"name":"\/files\/cdn\/a57be577deb434\/avatar\/06f75b3a-7b6c-37a8-81c0-b2934104daa7.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"salesRep":{"id":5087,"key":5087,"name":"\u5218\u5fae","sex":"F","avatar":{"id":62,"user_id":5087,"name":"\/files\/cdn\/a57be577deb434\/avatar\/06f75b3a-7b6c-37a8-81c0-b2934104daa7.png"}},"salesTimeCount":{},"implementTimeCount":{"project_id":3910,"sum":"147.35","times":"27"},"presalesTimeCount":{},"engineerTimeCount":{},"reimbursementAmountSum":{"project_id":3910,"sum":"5308.26"},"buildContract":{"id":4024,"from_project":3910,"payment_collection_remind_ahead":"15 days","serial_no":"2025EC-BJ-74-0530","salesContractPayments":[{"id":"1377","key":"1377","contract_id":4024,"value":"2102786"}],"salesContractInvoices":[{"id":2093,"key":2093,"contract_id":4024,"value":"2102786.00","attachment_id":"","from_date":"2025-07-11","attachment":{}},{"id":2150,"key":2150,"contract_id":4024,"value":"901194.00","attachment_id":"","from_date":"2025-09-15","attachment":{}}],"salesContractPaymentCollectionRemindDates":[{"id":2492,"key":2492,"contract_id":4024,"name":"2025-07-25","value":"2102786","overdue_days":4,"status":1,"remind_date":"2025-07-25"},{"id":2493,"key":2493,"contract_id":4024,"name":"2025-10-31","value":"901194","overdue_days":"","status":0,"remind_date":"2025-10-31"}]},"commentCount":{"object_id":3910,"comment":5},"unreadComments":{},"unissued_invoice":0,"is_exceeded":false,"unread":0,"project_status_display":"\u5546\u673a\u6210\u4ea4","is_collected":false,"bgcolor":"#53cd02","remain_display":161,"progress_remain_display":161,"forecast_remain_display":161,"contract_type_display":"\u4ea7\u54c1\u9500\u552e"},{"id":3911,"client_id":2526,"project_status":3,"project_progress":9,"budget":"25000","profit_pct":"32.8","bargain_date":"2025-07-10","description":"","created_by":5087,"created_at":"2025-07-10 16:23:12","updated_at":"2025-11-10 00:59:03","engineer_id":"","project_title":"\u8d22\u52a1\u7528\u9632\u706b\u5899","collected":"0","status_updated_at":"2025-07-10 16:33:24.311689+08","success_rate":"","comment":"","contract_type":1,"progress_updated_at":"2025-07-10 16:23:12.323907+08","forecast_updated_at":"2025-07-10 16:23:12.323907+08","end_at":"","pinyin_shortcut":"cwyfhq","creator":5087,"used_client":"","from_contact":"","total_contact_point":"","paid_contact_point":"","project_product_version_id":940,"is_sales_order_ready":true,"collected_plan":"25000","change_status_to":"","is_verify":false,"profit":"8200.00000000000000000","remain":"164 days 17:59:57.622459","progress_remain":"164 days 18:10:09.610241","forecast_remain":"164 days 18:10:09.610241","duration":"164 days 18:10:09.610241","issued_invoices":"","client":{"id":2526,"key":2526,"name":"\u5317\u4eac\u822a\u5929\u6d4b\u63a7\u6280\u672f\u6709\u9650\u516c\u53f8","logo":"","client_type":6,"client_class":43,"client_industry":5,"clientType":{"id":6,"key":6,"name":"\u592e\u4f01"},"clientClass":{"id":43,"key":43,"name":"\u6f5c\u529b\u5ba2\u6237","notice_days":60,"color":"#1EE6DC"},"clientIndustry":{"id":5,"key":5,"name":"\u5236\u9020"}},"projectArchitects":[{"project_id":3911,"value":"1","key":1022,"name":"\u5f90\u7855"}],"projectStatus":{"id":3,"key":3,"name":"\u5546\u673a\u6210\u4ea4","color":"#53cd02"},"projectProgress":{"id":9,"key":9,"name":"\u7b7e\u8ba2\u5408\u540c"},"projectProductTypes":[{"id":5,"product_type_id":5,"key":5,"name":"\u5b89\u5168\u8bbe\u5907","budget":"25000","pct":"32.8","profit":"8200","project_id":3911}],"salesForecast":{"id":142,"key":142,"name":"\u6211\u4e0e\u5ba2\u6237\u8054\u624b"},"opportunityFrom":{},"purchaseType":{"id":165,"key":165,"name":"\u534f\u8bae\u4f9b\u8d27"},"contractType":{"id":1,"key":1,"name":"\u4ea7\u54c1\u9500\u552e"},"createdBy":{"id":5087,"key":5087,"name":"\u5218\u5fae","sex":"F","department_id":1,"avatar":{"id":62,"user_id":5087,"name":"\/files\/cdn\/a57be577deb434\/avatar\/06f75b3a-7b6c-37a8-81c0-b2934104daa7.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"salesRep":{"id":5087,"key":5087,"name":"\u5218\u5fae","sex":"F","avatar":{"id":62,"user_id":5087,"name":"\/files\/cdn\/a57be577deb434\/avatar\/06f75b3a-7b6c-37a8-81c0-b2934104daa7.png"}},"salesTimeCount":{},"implementTimeCount":{"project_id":3911,"sum":"11.0833333333333","times":"3"},"presalesTimeCount":{},"engineerTimeCount":{},"reimbursementAmountSum":{"project_id":3911,"sum":"478.58"},"buildContract":{"id":4020,"from_project":3911,"payment_collection_remind_ahead":"30 days","serial_no":"","salesContractPayments":[],"salesContractInvoices":[],"salesContractPaymentCollectionRemindDates":[{"id":2488,"key":2488,"contract_id":4020,"name":"2025-12-31","value":"22500","overdue_days":"","status":0,"remind_date":"2025-12-31"},{"id":2489,"key":2489,"contract_id":4020,"name":"2026-08-31","value":"2500","overdue_days":"","status":0,"remind_date":"2026-08-31"}]},"commentCount":{"object_id":3911,"comment":8},"unreadComments":{},"unissued_invoice":25000,"is_exceeded":false,"unread":0,"project_status_display":"\u5546\u673a\u6210\u4ea4","is_collected":false,"bgcolor":"#53cd02","remain_display":164,"progress_remain_display":164,"forecast_remain_display":164,"contract_type_display":"\u4ea7\u54c1\u9500\u552e"},{"id":3900,"client_id":1301,"project_status":3,"project_progress":5,"budget":"10900","profit_pct":"53.63","bargain_date":"2025-07-09","description":"","created_by":5295,"created_at":"2025-06-26 17:21:50","updated_at":"2025-08-29 12:17:24","engineer_id":"","project_title":"2025\u5e74\u670d\u52a1\u5668\u7f51\u5361","collected":"10900","status_updated_at":"2025-07-14 09:59:46.149348+08","success_rate":"","comment":"","contract_type":1,"progress_updated_at":"2025-06-26 17:21:50.528078+08","forecast_updated_at":"2025-06-26 17:21:50.528078+08","end_at":"2025-08-11 17:01:02","pinyin_shortcut":"2025nfwqwk","creator":5295,"used_client":"","from_contact":"","total_contact_point":"","paid_contact_point":"","project_product_version_id":941,"is_sales_order_ready":true,"collected_plan":"10900","change_status_to":"","is_verify":false,"profit":"5845.670000000000000000","remain":"161 days 00:33:35.7848","progress_remain":"178 days 17:11:31.40607","forecast_remain":"178 days 17:11:31.40607","duration":"45 days 23:39:12.195639","issued_invoices":"10900.00","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)","logo":"","client_type":1,"client_class":43,"client_industry":5,"clientType":{"id":1,"key":1,"name":"\u653f\u5e9c"},"clientClass":{"id":43,"key":43,"name":"\u6f5c\u529b\u5ba2\u6237","notice_days":60,"color":"#1EE6DC"},"clientIndustry":{"id":5,"key":5,"name":"\u5236\u9020"}},"projectArchitects":[{"project_id":3900,"value":"1","key":5085,"name":"\u970d\u4e1c\u9633"}],"projectStatus":{"id":3,"key":3,"name":"\u5546\u673a\u6210\u4ea4","color":"#53cd02"},"projectProgress":{"id":5,"key":5,"name":"\u5546\u52a1\u62a5\u4ef7"},"projectProductTypes":[{"id":2,"product_type_id":2,"key":2,"name":"\u670d\u52a1\u5668","budget":"10900","pct":"53.63","profit":"5845.67","project_id":3900}],"salesForecast":{"id":142,"key":142,"name":"\u6211\u4e0e\u5ba2\u6237\u8054\u624b"},"opportunityFrom":{},"purchaseType":{"id":164,"key":164,"name":"\u591a\u5bb6\u6bd4\u4ef7"},"contractType":{"id":1,"key":1,"name":"\u4ea7\u54c1\u9500\u552e"},"createdBy":{"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"}},"salesRep":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F","avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"}},"salesTimeCount":{},"implementTimeCount":{"project_id":3900,"sum":"22.7166666666667","times":"5"},"presalesTimeCount":{},"engineerTimeCount":{},"reimbursementAmountSum":{"project_id":3900,"sum":"103.54"},"buildContract":{"id":4027,"from_project":3900,"payment_collection_remind_ahead":"1 day","serial_no":"TS-WZW-20250709002","salesContractPayments":[{"id":"1375","key":"1375","contract_id":4027,"value":"3270"},{"id":"11994","key":"11994","contract_id":4027,"value":"7630"}],"salesContractInvoices":[{"id":2096,"key":2096,"contract_id":4027,"value":"3270.00","attachment_id":"","from_date":"2025-07-15","attachment":{}},{"id":2108,"key":2108,"contract_id":4027,"value":"7630.00","attachment_id":"","from_date":"2025-08-01","attachment":{}}],"salesContractPaymentCollectionRemindDates":[{"id":2501,"key":2501,"contract_id":4027,"name":"2025-08-31","value":"10900","overdue_days":"","status":1,"remind_date":"2025-08-31"}]},"commentCount":{"object_id":3900,"comment":3},"unreadComments":{},"unissued_invoice":0,"is_exceeded":false,"unread":0,"project_status_display":"\u6536\u6b3e\u5b8c\u6210","is_collected":true,"bgcolor":"#6200fe","remain_display":161,"progress_remain_display":178,"forecast_remain_display":178,"contract_type_display":"\u4ea7\u54c1\u9500\u552e"},{"id":3898,"client_id":2182,"project_status":3,"project_progress":9,"budget":"29701","profit_pct":"21.51","bargain_date":"2025-06-27","description":"","created_by":5300,"created_at":"2025-06-24 12:42:14","updated_at":"2025-09-12 14:57:59","engineer_id":"","project_title":"\u6df1\u4fe1\u670dEDR\u65b0\u8d2d-K-2025","collected":"29701","status_updated_at":"2025-07-01 12:03:17.506283+08","success_rate":"","comment":"","contract_type":1,"progress_updated_at":"2025-06-30 10:08:48.916666+08","forecast_updated_at":"2025-06-30 10:08:48.916666+08","end_at":"2025-10-20 17:47:40","pinyin_shortcut":"sxfEDRxgK2025","creator":5300,"used_client":"","from_contact":"","total_contact_point":"7320","paid_contact_point":"7320","project_product_version_id":928,"is_sales_order_ready":true,"collected_plan":"29701","change_status_to":"","is_verify":false,"profit":"6388.685100000000000000","remain":"173 days 22:30:04.427865","progress_remain":"175 days 00:24:33.017482","forecast_remain":"175 days 00:24:33.017482","duration":"118 days 05:05:26.609458","issued_invoices":"29701.00","client":{"id":2182,"key":2182,"name":"\u5317\u4eac\u5357\u65b9\u65af\u5948\u514b\u739b\u6da1\u8f6e\u6280\u672f\u6709\u9650\u516c\u53f8","logo":"","client_type":5,"client_class":80,"client_industry":20,"clientType":{"id":5,"key":5,"name":"\u5546\u4e1a"},"clientClass":{"id":80,"key":80,"name":"\u7a33\u5b9a\u5ba2\u6237","notice_days":30,"color":"#0EE315"},"clientIndustry":{"id":20,"key":20,"name":"\u5176\u4ed6"}},"projectArchitects":[{"project_id":3898,"value":"1","key":5248,"name":"\u6587\u4f73\u9f99"}],"projectStatus":{"id":3,"key":3,"name":"\u5546\u673a\u6210\u4ea4","color":"#53cd02"},"projectProgress":{"id":9,"key":9,"name":"\u7b7e\u8ba2\u5408\u540c"},"projectProductTypes":[{"id":7,"product_type_id":7,"key":7,"name":"\u8f6f\u4ef6","budget":"29701","pct":"21.51","profit":"6388.68","project_id":3898}],"salesForecast":{"id":142,"key":142,"name":"\u6211\u4e0e\u5ba2\u6237\u8054\u624b"},"opportunityFrom":{},"purchaseType":{"id":164,"key":164,"name":"\u591a\u5bb6\u6bd4\u4ef7"},"contractType":{"id":1,"key":1,"name":"\u4ea7\u54c1\u9500\u552e"},"createdBy":{"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"}},"salesRep":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91","sex":"F","avatar":{"id":141,"user_id":5300,"name":"\/files\/cdn\/a57be577deb434\/avatar\/14dfd1a0-6df5-354a-8afd-f0a76fa8e852.png"}},"salesTimeCount":{},"implementTimeCount":{"project_id":3898,"sum":"1","times":"1"},"presalesTimeCount":{},"engineerTimeCount":{},"reimbursementAmountSum":{},"buildContract":{"id":4008,"from_project":3898,"payment_collection_remind_ahead":"7 days","serial_no":"TSC-X-2025062701","salesContractPayments":[{"id":"1330","key":"1330","contract_id":4008,"value":"29701"}],"salesContractInvoices":[{"id":2105,"key":2105,"contract_id":4008,"value":"29701.00","attachment_id":"","from_date":"2025-07-25","attachment":{}}],"salesContractPaymentCollectionRemindDates":[{"id":2482,"key":2482,"contract_id":4008,"name":"2025-08-31","value":"29701","overdue_days":"","status":1,"remind_date":"2025-08-31"}]},"commentCount":{"object_id":3898,"comment":3},"unreadComments":{},"unissued_invoice":0,"is_exceeded":false,"unread":0,"project_status_display":"\u6536\u6b3e\u5b8c\u6210","is_collected":true,"bgcolor":"#6200fe","remain_display":173,"progress_remain_display":175,"forecast_remain_display":175,"contract_type_display":"\u4ea7\u54c1\u9500\u552e"},{"id":3875,"client_id":1301,"project_status":3,"project_progress":9,"budget":"5100","profit_pct":"54.16","bargain_date":"2025-06-04","description":"","created_by":5295,"created_at":"2025-05-29 15:59:32","updated_at":"2025-08-20 15:08:59","engineer_id":"","project_title":"25\u5e74\u65b0\u8d2d\u670d\u52a1\u5668\u4e3b\u677f\u548c\u786c\u76d8","collected":"5100","status_updated_at":"2025-05-29 16:00:50.020586+08","success_rate":"","comment":"","contract_type":1,"progress_updated_at":"2025-05-29 15:59:32.075813+08","forecast_updated_at":"2025-05-29 15:59:32.075813+08","end_at":"2025-06-13 16:57:59","pinyin_shortcut":"25nxgfwqzbhyp","creator":5295,"used_client":"","from_contact":"","total_contact_point":"","paid_contact_point":"","project_product_version_id":879,"is_sales_order_ready":true,"collected_plan":"5100","change_status_to":"","is_verify":false,"profit":"2762.160000000000000000","remain":"206 days 18:32:31.913562","progress_remain":"206 days 18:33:49.858335","forecast_remain":"206 days 18:33:49.858335","duration":"15 days 00:58:27.829542","issued_invoices":"5100.00","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)","logo":"","client_type":1,"client_class":43,"client_industry":5,"clientType":{"id":1,"key":1,"name":"\u653f\u5e9c"},"clientClass":{"id":43,"key":43,"name":"\u6f5c\u529b\u5ba2\u6237","notice_days":60,"color":"#1EE6DC"},"clientIndustry":{"id":5,"key":5,"name":"\u5236\u9020"}},"projectArchitects":[{"project_id":3875,"value":"1","key":5085,"name":"\u970d\u4e1c\u9633"}],"projectStatus":{"id":3,"key":3,"name":"\u5546\u673a\u6210\u4ea4","color":"#53cd02"},"projectProgress":{"id":9,"key":9,"name":"\u7b7e\u8ba2\u5408\u540c"},"projectProductTypes":[{"id":2,"product_type_id":2,"key":2,"name":"\u670d\u52a1\u5668","budget":"5100.00","pct":"54.16","profit":"2762.16","project_id":3875}],"salesForecast":{"id":142,"key":142,"name":"\u6211\u4e0e\u5ba2\u6237\u8054\u624b"},"opportunityFrom":{},"purchaseType":{"id":164,"key":164,"name":"\u591a\u5bb6\u6bd4\u4ef7"},"contractType":{"id":1,"key":1,"name":"\u4ea7\u54c1\u9500\u552e"},"createdBy":{"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"}},"salesRep":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F","avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"}},"salesTimeCount":{},"implementTimeCount":{"project_id":3875,"sum":"9.71666666666667","times":"3"},"presalesTimeCount":{},"engineerTimeCount":{},"reimbursementAmountSum":{},"buildContract":{"id":3941,"from_project":3875,"payment_collection_remind_ahead":"00:00:00","serial_no":"TS-WZW-20250604001","salesContractPayments":[{"id":"1353","key":"1353","contract_id":3941,"value":"5100"}],"salesContractInvoices":[{"id":2069,"key":2069,"contract_id":3941,"value":"5100.00","attachment_id":"","from_date":"2025-06-09","attachment":{}}],"salesContractPaymentCollectionRemindDates":[{"id":2447,"key":2447,"contract_id":3941,"name":"2025-06-30","value":"5100","overdue_days":"","status":1,"remind_date":"2025-06-30"}]},"commentCount":{"object_id":3875,"comment":4},"unreadComments":{},"unissued_invoice":0,"is_exceeded":false,"unread":0,"project_status_display":"\u6536\u6b3e\u5b8c\u6210","is_collected":true,"bgcolor":"#6200fe","remain_display":206,"progress_remain_display":206,"forecast_remain_display":206,"contract_type_display":"\u4ea7\u54c1\u9500\u552e"},{"id":3834,"client_id":1301,"project_status":3,"project_progress":9,"budget":"15300","profit_pct":"26.43","bargain_date":"2025-05-30","description":"","created_by":5295,"created_at":"2025-04-28 19:10:41","updated_at":"2025-07-30 10:19:27","engineer_id":"","project_title":"2025veeam\u7eed\u4fdd","collected":"15300","status_updated_at":"2025-06-04 15:13:42.970236+08","success_rate":"","comment":"","contract_type":1,"progress_updated_at":"2025-06-03 09:58:59.322444+08","forecast_updated_at":"2025-06-03 09:58:59.322444+08","end_at":"2025-06-13 16:58:32","pinyin_shortcut":"2025veeamxb","creator":5295,"used_client":"","from_contact":"","total_contact_point":"","paid_contact_point":"","project_product_version_id":884,"is_sales_order_ready":true,"collected_plan":"15300","change_status_to":"","is_verify":false,"profit":"4043.790000000000000000","remain":"200 days 19:19:38.963912","progress_remain":"202 days 00:34:22.611704","forecast_remain":"202 days 00:34:22.611704","duration":"45 days 21:47:50.526014","issued_invoices":"15300.00","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)","logo":"","client_type":1,"client_class":43,"client_industry":5,"clientType":{"id":1,"key":1,"name":"\u653f\u5e9c"},"clientClass":{"id":43,"key":43,"name":"\u6f5c\u529b\u5ba2\u6237","notice_days":60,"color":"#1EE6DC"},"clientIndustry":{"id":5,"key":5,"name":"\u5236\u9020"}},"projectArchitects":[{"project_id":3834,"value":"1","key":1015,"name":"\u5434\u660a"}],"projectStatus":{"id":3,"key":3,"name":"\u5546\u673a\u6210\u4ea4","color":"#53cd02"},"projectProgress":{"id":9,"key":9,"name":"\u7b7e\u8ba2\u5408\u540c"},"projectProductTypes":[{"id":69,"product_type_id":69,"key":69,"name":"\u5907\u4efd","budget":"15300.00","pct":"26.43","profit":"4043.79","project_id":3834}],"salesForecast":{"id":181,"key":181,"name":"\u6211\u81ea\u5df1\u505a\u5e84"},"opportunityFrom":{},"purchaseType":{"id":164,"key":164,"name":"\u591a\u5bb6\u6bd4\u4ef7"},"contractType":{"id":1,"key":1,"name":"\u4ea7\u54c1\u9500\u552e"},"createdBy":{"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"}},"salesRep":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F","avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"}},"salesTimeCount":{},"implementTimeCount":{"project_id":3834,"sum":"1.83333333333333","times":"2"},"presalesTimeCount":{},"engineerTimeCount":{},"reimbursementAmountSum":{"project_id":3834,"sum":"41.10"},"buildContract":{"id":3953,"from_project":3834,"payment_collection_remind_ahead":"00:00:00","serial_no":"TS-WZW-20250530001","salesContractPayments":[{"id":"1354","key":"1354","contract_id":3953,"value":"15300"}],"salesContractInvoices":[{"id":2068,"key":2068,"contract_id":3953,"value":"15300.00","attachment_id":"","from_date":"2025-06-09","attachment":{}}],"salesContractPaymentCollectionRemindDates":[{"id":2449,"key":2449,"contract_id":3953,"name":"2025-07-31","value":"15300","overdue_days":"","status":1,"remind_date":"2025-07-31"}]},"commentCount":{"object_id":3834,"comment":4},"unreadComments":{},"unissued_invoice":0,"is_exceeded":false,"unread":0,"project_status_display":"\u6536\u6b3e\u5b8c\u6210","is_collected":true,"bgcolor":"#6200fe","remain_display":200,"progress_remain_display":202,"forecast_remain_display":202,"contract_type_display":"\u4ea7\u54c1\u9500\u552e"},{"id":3866,"client_id":3367,"project_status":3,"project_progress":9,"budget":"8200","profit_pct":"93","bargain_date":"2025-05-28","description":"","created_by":5300,"created_at":"2025-05-22 11:53:30","updated_at":"2025-07-03 15:06:45","engineer_id":"","project_title":"\u6280\u672f\u670d\u52a1-2025","collected":"8200","status_updated_at":"2025-06-04 15:02:20.192712+08","success_rate":"","comment":"","contract_type":2,"progress_updated_at":"2025-05-26 10:16:14.079616+08","forecast_updated_at":"2025-05-26 10:16:14.079616+08","end_at":"2025-06-13 16:56:58","pinyin_shortcut":"jsfw2025","creator":5300,"used_client":3339,"from_contact":"","total_contact_point":"","paid_contact_point":"","project_product_version_id":882,"is_sales_order_ready":true,"collected_plan":"8200","change_status_to":"","is_verify":false,"profit":"7626.0000000000000000","remain":"200 days 19:31:01.741436","progress_remain":"210 days 00:17:07.854532","forecast_remain":"210 days 00:17:07.854532","duration":"22 days 05:03:28.414689","issued_invoices":"8200.00","client":{"id":3367,"key":3367,"name":"\u5317\u4eac\u7f51\u667a\u7396\u5b89\u79d1\u6280\u6709\u9650\u516c\u53f8","logo":"","client_type":5,"client_class":43,"client_industry":13,"clientType":{"id":5,"key":5,"name":"\u5546\u4e1a"},"clientClass":{"id":43,"key":43,"name":"\u6f5c\u529b\u5ba2\u6237","notice_days":60,"color":"#1EE6DC"},"clientIndustry":{"id":13,"key":13,"name":"SI\/ISV"}},"projectArchitects":[{"project_id":3866,"value":"0.6","key":1023,"name":"\u5468\u5b50\u5065"},{"project_id":3866,"value":"0.4","key":5085,"name":"\u970d\u4e1c\u9633"}],"projectStatus":{"id":3,"key":3,"name":"\u5546\u673a\u6210\u4ea4","color":"#53cd02"},"projectProgress":{"id":9,"key":9,"name":"\u7b7e\u8ba2\u5408\u540c"},"projectProductTypes":[{"id":16,"product_type_id":16,"key":16,"name":"\u8fd0\u7ef4\u670d\u52a1","budget":"8200.00","pct":"93","profit":"7626","project_id":3866}],"salesForecast":{"id":181,"key":181,"name":"\u6211\u81ea\u5df1\u505a\u5e84"},"opportunityFrom":{},"purchaseType":{"id":164,"key":164,"name":"\u591a\u5bb6\u6bd4\u4ef7"},"contractType":{"id":2,"key":2,"name":"\u8fd0\u7ef4\u670d\u52a1"},"createdBy":{"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"}},"salesRep":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91","sex":"F","avatar":{"id":141,"user_id":5300,"name":"\/files\/cdn\/a57be577deb434\/avatar\/14dfd1a0-6df5-354a-8afd-f0a76fa8e852.png"}},"salesTimeCount":{},"implementTimeCount":{},"presalesTimeCount":{},"engineerTimeCount":{},"reimbursementAmountSum":{},"buildContract":{"id":3952,"from_project":3866,"payment_collection_remind_ahead":"7 days","serial_no":"TS-SQY-20250528001","salesContractPayments":[{"id":"1351","key":"1351","contract_id":3952,"value":"8200"}],"salesContractInvoices":[{"id":2063,"key":2063,"contract_id":3952,"value":"8200.00","attachment_id":"","from_date":"2025-06-04","attachment":{}}],"salesContractPaymentCollectionRemindDates":[{"id":2448,"key":2448,"contract_id":3952,"name":"2025-07-04","value":"8200","overdue_days":"","status":1,"remind_date":"2025-07-04"}]},"commentCount":{"object_id":3866,"comment":3},"unreadComments":{},"unissued_invoice":0,"is_exceeded":false,"unread":0,"project_status_display":"\u6536\u6b3e\u5b8c\u6210","is_collected":true,"bgcolor":"#6200fe","remain_display":200,"progress_remain_display":210,"forecast_remain_display":210,"contract_type_display":"\u8fd0\u7ef4\u670d\u52a1"},{"id":3869,"client_id":2186,"project_status":3,"project_progress":9,"budget":"93000","profit_pct":"8.92","bargain_date":"2025-05-28","description":"","created_by":5295,"created_at":"2025-05-27 11:30:07","updated_at":"2025-08-15 15:24:52","engineer_id":"","project_title":"2025\u65b0\u8d2dnetapp\u5b58\u50a8","collected":"93000","status_updated_at":"2025-05-27 15:15:08.025158+08","success_rate":"","comment":"","contract_type":1,"progress_updated_at":"2025-05-27 11:30:07.702446+08","forecast_updated_at":"2025-05-27 11:30:07.702446+08","end_at":"2025-07-31 09:13:04","pinyin_shortcut":"2025xgnetappcc","creator":5295,"used_client":"","from_contact":"","total_contact_point":"1000","paid_contact_point":"","project_product_version_id":872,"is_sales_order_ready":true,"collected_plan":"93000","change_status_to":"","is_verify":false,"profit":"8295.600000000000000000","remain":"208 days 19:18:13.90899","progress_remain":"208 days 23:03:14.231702","forecast_remain":"208 days 23:03:14.231702","duration":"64 days 21:42:57.019368","issued_invoices":"93000.00","client":{"id":2186,"key":2186,"name":"\u6210\u90fd\u6d77\u5149\u96c6\u6210\u7535\u8def\u8bbe\u8ba1\u6709\u9650\u516c\u53f8\uff08EDA)\/\u6d77\u5149\u4fe1\u606f\u6280\u672f\uff08\u6210\u90fd\uff09\u6709\u9650\u516c\u53f8","logo":"","client_type":5,"client_class":43,"client_industry":57,"clientType":{"id":5,"key":5,"name":"\u5546\u4e1a"},"clientClass":{"id":43,"key":43,"name":"\u6f5c\u529b\u5ba2\u6237","notice_days":60,"color":"#1EE6DC"},"clientIndustry":{"id":57,"key":57,"name":"EDA\/CAE"}},"projectArchitects":[{"project_id":3869,"value":"1","key":1015,"name":"\u5434\u660a"}],"projectStatus":{"id":3,"key":3,"name":"\u5546\u673a\u6210\u4ea4","color":"#53cd02"},"projectProgress":{"id":9,"key":9,"name":"\u7b7e\u8ba2\u5408\u540c"},"projectProductTypes":[{"id":3,"product_type_id":3,"key":3,"name":"\u5b58\u50a8\u8bbe\u5907","budget":"93000.00","pct":"8.92","profit":"8295.6","project_id":3869}],"salesForecast":{"id":142,"key":142,"name":"\u6211\u4e0e\u5ba2\u6237\u8054\u624b"},"opportunityFrom":{},"purchaseType":{"id":164,"key":164,"name":"\u591a\u5bb6\u6bd4\u4ef7"},"contractType":{"id":1,"key":1,"name":"\u4ea7\u54c1\u9500\u552e"},"createdBy":{"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"}},"salesRep":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F","avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"}},"salesTimeCount":{},"implementTimeCount":{"project_id":3869,"sum":"13.5","times":"3"},"presalesTimeCount":{},"engineerTimeCount":{},"reimbursementAmountSum":{},"buildContract":{"id":3931,"from_project":3869,"payment_collection_remind_ahead":"00:00:00","serial_no":"Hygon Agreement No.H82025050175","salesContractPayments":[{"id":"1381","key":"1381","contract_id":3931,"value":"93000"}],"salesContractInvoices":[{"id":2077,"key":2077,"contract_id":3931,"value":"93000.00","attachment_id":"","from_date":"2025-06-16","attachment":{}},{"id":2103,"key":2103,"contract_id":3931,"value":"-93000.00","attachment_id":"","from_date":"2025-07-24","attachment":{}},{"id":2104,"key":2104,"contract_id":3931,"value":"93000.00","attachment_id":"","from_date":"2025-07-24","attachment":{}}],"salesContractPaymentCollectionRemindDates":[{"id":2440,"key":2440,"contract_id":3931,"name":"2025-07-20","value":"93000","overdue_days":11,"status":1,"remind_date":"2025-07-20"}]},"commentCount":{"object_id":3869,"comment":6},"unreadComments":{},"unissued_invoice":0,"is_exceeded":false,"unread":0,"project_status_display":"\u6536\u6b3e\u5b8c\u6210","is_collected":true,"bgcolor":"#6200fe","remain_display":208,"progress_remain_display":208,"forecast_remain_display":208,"contract_type_display":"\u4ea7\u54c1\u9500\u552e"},{"id":3852,"client_id":189,"project_status":3,"project_progress":9,"budget":"221180","profit_pct":"28.85","bargain_date":"2025-05-26","description":"","created_by":5295,"created_at":"2025-05-08 17:24:05","updated_at":"2025-09-05 14:27:23","engineer_id":"","project_title":"2025XDR\u3001\u63a2\u9488\u7eed\u4fdd\u548c\u4e0a\u7f51\u884c\u4e3a\u7ba1\u7406\u65b0\u8d2d","collected":"221180","status_updated_at":"2025-06-06 10:47:54.068361+08","success_rate":"","comment":"","contract_type":1,"progress_updated_at":"2025-06-03 09:58:05.864278+08","forecast_updated_at":"2025-06-03 09:58:05.864278+08","end_at":"2025-06-12 14:04:02","pinyin_shortcut":"2025XDRtzxbhswxwglxg","creator":5295,"used_client":"","from_contact":"","total_contact_point":"12000","paid_contact_point":"12000","project_product_version_id":888,"is_sales_order_ready":true,"collected_plan":"221180","change_status_to":"","is_verify":false,"profit":"63810.430000000000000000","remain":"198 days 23:45:27.865787","progress_remain":"202 days 00:35:16.06987","forecast_remain":"202 days 00:35:16.06987","duration":"34 days 20:39:57.421969","issued_invoices":"221180.00","client":{"id":189,"key":189,"name":"\u5317\u4eac\u4eac\u897f\u5b66\u6821","logo":"","client_type":1,"client_class":80,"client_industry":24,"clientType":{"id":1,"key":1,"name":"\u653f\u5e9c"},"clientClass":{"id":80,"key":80,"name":"\u7a33\u5b9a\u5ba2\u6237","notice_days":30,"color":"#0EE315"},"clientIndustry":{"id":24,"key":24,"name":"\u6559\u80b2\uff08\u666e\u6559\uff09"}},"projectArchitects":[{"project_id":3852,"value":"0.5","key":1017,"name":"\u8f66\u660e\u98de"},{"project_id":3852,"value":"0.5","key":5248,"name":"\u6587\u4f73\u9f99"}],"projectStatus":{"id":3,"key":3,"name":"\u5546\u673a\u6210\u4ea4","color":"#53cd02"},"projectProgress":{"id":9,"key":9,"name":"\u7b7e\u8ba2\u5408\u540c"},"projectProductTypes":[{"id":5,"product_type_id":5,"key":5,"name":"\u5b89\u5168\u8bbe\u5907","budget":"221180.00","pct":"28.85","profit":"63810.43","project_id":3852}],"salesForecast":{"id":142,"key":142,"name":"\u6211\u4e0e\u5ba2\u6237\u8054\u624b"},"opportunityFrom":{},"purchaseType":{"id":164,"key":164,"name":"\u591a\u5bb6\u6bd4\u4ef7"},"contractType":{"id":1,"key":1,"name":"\u4ea7\u54c1\u9500\u552e"},"createdBy":{"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"}},"salesRep":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F","avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"}},"salesTimeCount":{},"implementTimeCount":{"project_id":3852,"sum":"2.16666666666667","times":"1"},"presalesTimeCount":{},"engineerTimeCount":{},"reimbursementAmountSum":{},"buildContract":{"id":3958,"from_project":3852,"payment_collection_remind_ahead":"00:00:00","serial_no":"TS-WZW-20250526001","salesContractPayments":[{"id":"1350","key":"1350","contract_id":3958,"value":"221180"}],"salesContractInvoices":[{"id":2143,"key":2143,"contract_id":3958,"value":"221180.00","attachment_id":"","from_date":"2025-09-05","attachment":{}}],"salesContractPaymentCollectionRemindDates":[{"id":2459,"key":2459,"contract_id":3958,"name":"2025-06-30","value":"221180","overdue_days":"","status":1,"remind_date":"2025-06-30"}]},"commentCount":{"object_id":3852,"comment":4},"unreadComments":{},"unissued_invoice":0,"is_exceeded":false,"unread":0,"project_status_display":"\u6536\u6b3e\u5b8c\u6210","is_collected":true,"bgcolor":"#6200fe","remain_display":198,"progress_remain_display":202,"forecast_remain_display":202,"contract_type_display":"\u4ea7\u54c1\u9500\u552e"},{"id":3863,"client_id":1301,"project_status":3,"project_progress":5,"budget":"19860","profit_pct":"13.06","bargain_date":"2025-05-21","description":"","created_by":5295,"created_at":"2025-05-20 16:30:28","updated_at":"2025-06-19 17:05:42","engineer_id":"","project_title":"2025UPS\u7535\u6c60\u65b0\u8d2d","collected":"19860","status_updated_at":"2025-05-23 15:41:55.600374+08","success_rate":"","comment":"","contract_type":1,"progress_updated_at":"2025-05-20 16:30:28.843297+08","forecast_updated_at":"2025-05-20 16:30:28.843297+08","end_at":"2025-07-03 13:47:30","pinyin_shortcut":"2025UPSdcxg","creator":5295,"used_client":"","from_contact":"","total_contact_point":"","paid_contact_point":"","project_product_version_id":906,"is_sales_order_ready":true,"collected_plan":"19860","change_status_to":"","is_verify":false,"profit":"2593.716000000000000000","remain":"212 days 18:51:26.333774","progress_remain":"215 days 18:02:53.090851","forecast_remain":"215 days 18:02:53.090851","duration":"43 days 21:17:01.366957","issued_invoices":"19860.00","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)","logo":"","client_type":1,"client_class":43,"client_industry":5,"clientType":{"id":1,"key":1,"name":"\u653f\u5e9c"},"clientClass":{"id":43,"key":43,"name":"\u6f5c\u529b\u5ba2\u6237","notice_days":60,"color":"#1EE6DC"},"clientIndustry":{"id":5,"key":5,"name":"\u5236\u9020"}},"projectArchitects":[{"project_id":3863,"value":"1","key":5296,"name":"\u8d75\u5b87"}],"projectStatus":{"id":3,"key":3,"name":"\u5546\u673a\u6210\u4ea4","color":"#53cd02"},"projectProgress":{"id":5,"key":5,"name":"\u5546\u52a1\u62a5\u4ef7"},"projectProductTypes":[{"id":14,"product_type_id":14,"key":14,"name":"UPS","budget":"19860.00","pct":"13.06","profit":"2593.71","project_id":3863}],"salesForecast":{"id":142,"key":142,"name":"\u6211\u4e0e\u5ba2\u6237\u8054\u624b"},"opportunityFrom":{},"purchaseType":{"id":164,"key":164,"name":"\u591a\u5bb6\u6bd4\u4ef7"},"contractType":{"id":1,"key":1,"name":"\u4ea7\u54c1\u9500\u552e"},"createdBy":{"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"}},"salesRep":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F","avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"}},"salesTimeCount":{},"implementTimeCount":{},"presalesTimeCount":{},"engineerTimeCount":{},"reimbursementAmountSum":{},"buildContract":{"id":3924,"from_project":3863,"payment_collection_remind_ahead":"00:00:00","serial_no":"TS-WZW-20250521001","salesContractPayments":[{"id":"1320","key":"1320","contract_id":3924,"value":"19860"}],"salesContractInvoices":[{"id":2056,"key":2056,"contract_id":3924,"value":"19860.00","attachment_id":"","from_date":"2025-05-28","attachment":{}}],"salesContractPaymentCollectionRemindDates":[{"id":2433,"key":2433,"contract_id":3924,"name":"2025-06-30","value":"19860","overdue_days":3,"status":1,"remind_date":"2025-06-30"}]},"commentCount":{"object_id":3863,"comment":4},"unreadComments":{},"unissued_invoice":0,"is_exceeded":false,"unread":0,"project_status_display":"\u6536\u6b3e\u5b8c\u6210","is_collected":true,"bgcolor":"#6200fe","remain_display":212,"progress_remain_display":215,"forecast_remain_display":215,"contract_type_display":"\u4ea7\u54c1\u9500\u552e"}],"pagenation":{"totalcount":31,"thispage":1,"pagesize":20}},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}],"mod":0,"ip":"223.72.15.105","ua":"Mozilla\/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit\/537.36 (KHTML, like Gecko) Chrome\/143.0.0.0 Safari\/537.36"}', FALSE, '2025-12-22 10:33:22') RETURNING "id"
10:33:21.9554.2 msyii\db\Command::querySELECT 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_project_architects' and d.nspname = 'a57be577deb434' ORDER BY a.attnum;
10:33:22.0524.2 msyii\db\Command::querySELECT "c"."project_id", sum(hours), sum(times) as times FROM "a57be577deb434"."tbl_cases" "c" LEFT JOIN (SELECT "case_id", EXTRACT(epoch FROM sum(end_at - start_at)) /3600 AS hours, count(id) as times FROM "a57be577deb434"."tbl_pre_sales" WHERE "is_draft"=FALSE GROUP BY "case_id") "i" ON i.case_id = c.id WHERE ("case_type"=1) AND ("c"."project_id" IN (3960, 4006, 4003, 3969, 3888, 3956, 3922, 3883, 3917, 3841, 3910, 3911, 3900, 3898, 3875, 3834, 3866, 3869, 3852, 3863)) GROUP BY "c"."project_id"
10:33:22.0842.5 msyii\db\Command::querySELECT "id", "id" AS "key", "contract_id", "remind_date" AS "name", "amount" AS "value", "overdue_days", "status", "remind_date" FROM "a57be577deb434"."tbl_sales_contract_payment_collection_remind_dates" WHERE "contract_id" IN (4024, 4046, 4147, 4044, 4035, 4129, 4168, 4198, 4197, 4226, 3941, 3931, 3924, 3952, 3958, 4020, 4027, 4008, 4061, 3953) ORDER BY "remind_date"
10:33:21.9152.2 msyii\db\Command::querySELECT * FROM "global"."vw_user_login" WHERE "id"=1000
10:33:22.0002.0 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_term_taxonomies" WHERE ("term_id"=13) AND ("id" IN (5, 2, 1, 164, 142, 140, 226, 215, 135, 181, 184, 189, 185, 191, 307, 203, 205, 309, 197, 199, 349, 356, 360, 369, 377, 165, 130, 364, 355, 340, 350, 374, 172)) ORDER BY "sort"
10:33:22.1781.9 msyii\db\Command::executeUPDATE "a57be577deb434"."tbl_visit_module_histories" SET "num"=13, "last_visit_at"='now()' WHERE "id"=59614
10:33:21.9141.8 msyii\db\Connection::openOpening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta
10:33:22.0061.8 msyii\db\Command::querySELECT "id", "id" AS "key", "type" AS "name" FROM "a57be577deb434"."tbl_contract_types" WHERE "id" IN (1, 2)
10:33:21.9241.6 msyii\db\Command::querySELECT "user_id" FROM "a57be577deb434"."tbl_user_role_change_logs" "urcl" LEFT JOIN "a57be577deb434"."tbl_users" "u" ON urcl.user_id = u.id WHERE ("role_name"='Engineer') AND (((start_from < end_at) or end_at is null)) AND (tsrange(start_from::TIMESTAMP, end_at::TIMESTAMP, '[)') && '[2025-01-01 00:00:00, 2025-12-31 23:59:59]'::tsrange) GROUP BY "user_id", "pinyin1", "namecut1", "pinyin2", "namecut2", "pinyin3", "namecut3", "pinyin4", "namecut4" ORDER BY pinyin1 nulls first, namecut1 nulls first, pinyin2 nulls first, namecut2 nulls first, pinyin3 nulls first, namecut3 nulls first, pinyin4 nulls first, namecut4 nulls first
10:33:21.9201.6 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
10:33:22.0631.3 msyii\db\Command::querySELECT "id", "from_project", "payment_collection_remind_ahead", "serial_no" FROM "a57be577deb434"."tbl_sales_contracts" WHERE "from_project" IN (3960, 4006, 4003, 3969, 3888, 3956, 3922, 3883, 3917, 3841, 3910, 3911, 3900, 3898, 3875, 3834, 3866, 3869, 3852, 3863)
10:33:22.0121.2 msyii\db\Command::querySELECT "project_id", EXTRACT(epoch FROM sum(end_at - start_at)) /3600 AS hours, count(id) as times FROM "a57be577deb434"."tbl_work_logs" WHERE ("is_draft"=FALSE) AND ("scenario_id"=1) AND (("location_in_id" IS NOT NULL) AND ("location_out_id" IS NOT NULL) AND ("client_id" IS NOT NULL)) AND ("project_id" IN (3960, 4006, 4003, 3969, 3888, 3956, 3922, 3883, 3917, 3841, 3910, 3911, 3900, 3898, 3875, 3834, 3866, 3869, 3852, 3863)) GROUP BY "project_id"
10:33:22.0101.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id" IN (57, 42, 1301, 48, 3370, 2182, 2136, 3343, 2762, 2526, 3367, 2186, 189)
10:33:22.0801.1 msyii\db\Command::querySELECT "id", "id" AS "key", "contract_id", "amount" AS "value", "attachment_id", "from_date" FROM "a57be577deb434"."tbl_sales_contract_invoices" WHERE "contract_id" IN (4024, 4046, 4147, 4044, 4035, 4129, 4168, 4198, 4197, 4226, 3941, 3931, 3924, 3952, 3958, 4020, 4027, 4008, 4061, 3953) ORDER BY "id"
10:33:21.9711.0 msyii\db\Command::querySELECT id, product_type_id, product_type_id as key, name, coalesce(budget, 0) as budget, coalesce(pct, 0) as pct, coalesce(profit, 0) as profit, project_id FROM "a57be577deb434"."tbl_project_product_types" WHERE "project_id" IN (3960, 4006, 4003, 3969, 3888, 3956, 3922, 3883, 3917, 3841, 3910, 3911, 3900, 3898, 3875, 3834, 3866, 3869, 3852, 3863)
10:33:22.0020.9 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_term_taxonomy_relationships" WHERE "object_id" IN (3960, 4006, 4003, 3969, 3888, 3956, 3922, 3883, 3917, 3841, 3910, 3911, 3900, 3898, 3875, 3834, 3866, 3869, 3852, 3863)
10:33:21.9690.9 msyii\db\Command::querySELECT "id", "id" AS "key", "project_status" AS "name", "color" FROM "a57be577deb434"."tbl_project_statuses" WHERE "id"=3
10:33:21.9530.9 msyii\db\Command::querySELECT "id", "id" AS "key", "name", "notice_days", "color" FROM "a57be577deb434"."tbl_client_classes" WHERE "id" IN (80, 43, 47)
10:33:21.9700.9 msyii\db\Command::querySELECT "id", "id" AS "key", "project_progress" AS "name" FROM "a57be577deb434"."tbl_project_progresses" WHERE "id" IN (6, 9, 4, 49, 10, 5)
10:33:22.0040.8 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_term_taxonomy_relationships" WHERE "object_id" IN (3960, 4006, 4003, 3969, 3888, 3956, 3922, 3883, 3917, 3841, 3910, 3911, 3900, 3898, 3875, 3834, 3866, 3869, 3852, 3863)
10:33:21.9180.7 msyii\db\Command::querySELECT * FROM "global"."vw_user_login" WHERE "id"=1001
10:33:21.9540.6 msyii\db\Command::querySELECT "project_id", "contribution" AS "value", "engineer_id" AS "key", "u"."name" FROM "a57be577deb434"."tbl_project_architects" LEFT JOIN "a57be577deb434"."tbl_users" "u" ON engineer_id = u.id WHERE "a57be577deb434"."tbl_project_architects"."project_id" IN (3960, 4006, 4003, 3969, 3888, 3956, 3922, 3883, 3917, 3841, 3910, 3911, 3900, 3898, 3875, 3834, 3866, 3869, 3852, 3863)
10:33:21.9500.6 msyii\db\Command::querySELECT "id", "id" AS "key", "name", "logo", "client_type", "client_class", "client_industry" FROM "a57be577deb434"."tbl_clients" WHERE "id" IN (57, 42, 1301, 48, 3370, 2182, 2136, 3343, 2762, 2526, 3367, 2186, 189)
10:33:22.0560.6 msyii\db\Command::querySELECT "project_id", EXTRACT(epoch FROM sum(end_at - start_at)) /3600 AS hours, count(id) as times FROM "a57be577deb434"."tbl_work_logs" WHERE ("is_draft"=FALSE) AND ("scenario_id"=2) AND ("project_id" IN (3960, 4006, 4003, 3969, 3888, 3956, 3922, 3883, 3917, 3841, 3910, 3911, 3900, 3898, 3875, 3834, 3866, 3869, 3852, 3863)) GROUP BY "project_id"
10:33:22.0090.5 msyii\db\Command::querySELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id" IN (5295, 1005, 5087, 1004, 5300))
10:33:22.0050.4 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_term_taxonomies" WHERE ("term_id"=9) AND ("id" IN (5, 2, 1, 164, 142, 140, 226, 215, 135, 181, 184, 189, 185, 191, 307, 203, 205, 309, 197, 199, 349, 356, 360, 369, 377, 165, 130, 364, 355, 340, 350, 374, 172)) ORDER BY "sort"
10:33:22.0030.4 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_term_taxonomies" WHERE ("term_id"=10) AND ("id" IN (5, 2, 1, 164, 142, 140, 226, 215, 135, 181, 184, 189, 185, 191, 307, 203, 205, 309, 197, 199, 349, 356, 360, 369, 377, 165, 130, 364, 355, 340, 350, 374, 172)) ORDER BY "sort"
10:33:22.0090.4 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_departments" WHERE "id"=1
10:33:21.9520.3 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_client_types" WHERE "id" IN (5, 1, 6)
10:33:21.9260.3 msyii\db\Command::querySELECT "id" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (1017, 5085, 1001, 5248, 1015, 1022, 5296, 1023) ORDER BY pinyin1 nulls first, namecut1 nulls first, pinyin2 nulls first, namecut2 nulls first, pinyin3 nulls first, namecut3 nulls first, pinyin4 nulls first, namecut4 nulls first
10:33:22.0080.3 msyii\db\Command::querySELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (1005, 5295, 1004, 5300, 5087)
10:33:21.9540.3 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_client_industries" WHERE "id" IN (20, 13, 5, 57, 24, 3, 8)
10:33:22.0110.3 msyii\db\Command::querySELECT "id", "id" AS "key", "name", "sex" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (5300, 5295, 1004, 5087, 1005)
10:33:22.0120.3 msyii\db\Command::querySELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id" IN (5295, 1005, 5087, 1004, 5300))