ConfigurationRequestLogsProfilingDatabaseAsset BundlesMailTimeline
6868c13377690: POST https://beta.jinchangxiao.com/vue/analysis/used-client-payment-collection at 2025-07-05 02:07:47 pm by 223.72.35.175

Log Messages

总计43条数据
TimeLevelCategoryMessage
 
14:07:47.488traceyii\base\Application::bootstrapBootstrap with yii\log\Dispatcher
14:07:47.488traceyii\base\Module::getModuleLoading module: debug
14:07:47.489traceyii\base\Application::bootstrapBootstrap with yii\debug\Module::bootstrap()
14:07:47.489traceyii\redis\Connection::openOpening redis DB connection: redis.server.local:6379, database=1
14:07:47.489traceyii\redis\Connection::executeCommandExecuting Redis Command: SELECT
14:07:47.489traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
14:07:47.489traceyii\base\Module::getModuleLoading module: gii
14:07:47.489traceyii\base\Application::bootstrapBootstrap with yii\gii\Module::bootstrap()
14:07:47.490traceyii\web\UrlManager::parseRequestNo matching URL rules. Using default URL parsing logic.
14:07:47.490traceyii\web\Application::handleRequestRoute requested: 'vue/analysis/used-client-payment-collection'
14:07:47.490traceyii\base\Module::getModuleLoading module: vue
14:07:47.491infoyii\web\Session::openSession started
14:07:47.491infoyii\db\Command::querySELECT * FROM "global"."vw_user_login" WHERE "id"=5250
14:07:47.491infoyii\db\Connection::openOpening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta
14:07:47.497traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
14:07:47.498traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
14:07:47.498traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
14:07:47.498traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
14:07:47.499infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=5250
14:07:47.501traceyii\base\Controller::runActionRoute to run: vue/analysis/used-client-payment-collection
14:07:47.501traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
14:07:47.502traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: Admin
14:07:47.502traceyii\base\InlineAction::runWithParamsRunning action: app\modules\vue\controllers\AnalysisController::actionUsedClientPaymentCollection()
14:07:47.503traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
14:07:47.503traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
14:07:47.505infoyii\db\Command::querySELECT COUNT(*) FROM (SELECT sc.*, u.budget as used_client_budget, scp.collected, sci.invoiced, (sum(COALESCE(u.budget, 0)) - scp.collected) as uncollected, (sum(COALESCE(u.budget, 0)) - sci.invoiced) as uninvoiced, (overdue_paid_amount - overdue_collected) as overdue, CASE WHEN od.remind_date IS NOT NULL THEN 0 WHEN (u.budget - scp.collected) > 0 THEN 1 ELSE 2 END AS status, CASE WHEN u.budget - scp.collected > 0 THEN ( CASE WHEN overdue_paid_amount - overdue_collected > 0 THEN max_date ELSE min_date END ) ELSE null END AS sort_date, bargain_date FROM "a57be577deb434"."tbl_projects" "sc" LEFT JOIN "a57be577deb434"."tbl_project_used_clients" "u" ON u.project_id = sc.id LEFT JOIN "a57be577deb434"."tbl_clients" "c" ON sc.client_id = c.id LEFT JOIN "a57be577deb434"."tbl_sales_group_relationships" "sgr" ON sgr.sales_id = c.sales_rep LEFT JOIN (SELECT t0.project_id AS project_id, COALESCE(sum(t1.amount), 0) AS collected FROM "a57be577deb434"."tbl_project_used_clients" "t0" LEFT JOIN "a57be577deb434"."tbl_project_used_client_payments" "t1" ON t0.id = t1.project_used_client_id GROUP BY "t0"."id") "scp" ON scp.project_id = sc.id LEFT JOIN (SELECT t0.project_id AS project_id, COALESCE(sum(t1.amount), 0) AS invoiced FROM "a57be577deb434"."tbl_project_used_clients" "t0" LEFT JOIN "a57be577deb434"."tbl_project_used_client_invoices" "t1" ON t0.id = t1.project_used_client_id GROUP BY "t0"."id") "sci" ON sci.project_id = sc.id LEFT JOIN (SELECT sum(sub.amount) as overdue_paid_amount, sum(sub.paid_amount) as overdue_collected, max(sub.remind_date) as remind_date, max(sub.remind_date) as max_date, sub.id FROM (SELECT scpcrd.amount, COALESCE(scpcrd.paid_amount, 0) as paid_amount, scpcrd.remind_date, t0.project_id as id FROM "a57be577deb434"."tbl_project_used_client_payment_collection_remind_dates" "scpcrd" LEFT JOIN "a57be577deb434"."tbl_project_used_clients" "t0" ON t0.id = scpcrd.project_used_client_id WHERE ("remind_date" <= '2025-07-05') AND (COALESCE(scpcrd.paid_amount, 0) < amount)) "sub" GROUP BY "sub"."id") "od" ON od.id = sc.id LEFT JOIN (SELECT sub.id, min(sub.remind_date) min_date FROM (SELECT scpcrd.amount, COALESCE(scpcrd.paid_amount, 0) as paid_amount, scpcrd.remind_date, t0.project_id as id FROM "a57be577deb434"."tbl_project_used_client_payment_collection_remind_dates" "scpcrd" LEFT JOIN "a57be577deb434"."tbl_project_used_clients" "t0" ON t0.id = scpcrd.project_used_client_id WHERE ("remind_date" > '2025-07-05') AND (COALESCE(scpcrd.paid_amount, 0) >= amount)) "sub" GROUP BY "sub"."id") "mind" ON mind.id = sc.id WHERE (("sales_rep" IN (5049, 5301, 5022, 5209, 5026, 5293, 5309, 5356, 5329, 5299, 5303, 5302, 5332, 5047, 1026, 5096, 5070, 5420, 1029, 1001, 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, 5358, 1006, 5093)) OR ("sales_rep" IS NULL)) AND ("sc"."project_status"=3) AND (u.id is not null) AND (u.used_client is not null) GROUP BY "u"."id", "sc"."id", "scp"."collected", "sci"."invoiced", "od"."overdue_paid_amount", "od"."overdue_collected", "od"."remind_date", "sort_date" ORDER BY "sc"."bargain_date" DESC, "sc"."created_at" DESC) "c"
14:07:47.516infoyii\db\Command::querySELECT sc.*, u.budget as used_client_budget, scp.collected, sci.invoiced, (sum(COALESCE(u.budget, 0)) - scp.collected) as uncollected, (sum(COALESCE(u.budget, 0)) - sci.invoiced) as uninvoiced, (overdue_paid_amount - overdue_collected) as overdue, CASE WHEN od.remind_date IS NOT NULL THEN 0 WHEN (u.budget - scp.collected) > 0 THEN 1 ELSE 2 END AS status, CASE WHEN u.budget - scp.collected > 0 THEN ( CASE WHEN overdue_paid_amount - overdue_collected > 0 THEN max_date ELSE min_date END ) ELSE null END AS sort_date, bargain_date FROM "a57be577deb434"."tbl_projects" "sc" LEFT JOIN "a57be577deb434"."tbl_project_used_clients" "u" ON u.project_id = sc.id LEFT JOIN "a57be577deb434"."tbl_clients" "c" ON sc.client_id = c.id LEFT JOIN "a57be577deb434"."tbl_sales_group_relationships" "sgr" ON sgr.sales_id = c.sales_rep LEFT JOIN (SELECT t0.project_id AS project_id, COALESCE(sum(t1.amount), 0) AS collected FROM "a57be577deb434"."tbl_project_used_clients" "t0" LEFT JOIN "a57be577deb434"."tbl_project_used_client_payments" "t1" ON t0.id = t1.project_used_client_id GROUP BY "t0"."id") "scp" ON scp.project_id = sc.id LEFT JOIN (SELECT t0.project_id AS project_id, COALESCE(sum(t1.amount), 0) AS invoiced FROM "a57be577deb434"."tbl_project_used_clients" "t0" LEFT JOIN "a57be577deb434"."tbl_project_used_client_invoices" "t1" ON t0.id = t1.project_used_client_id GROUP BY "t0"."id") "sci" ON sci.project_id = sc.id LEFT JOIN (SELECT sum(sub.amount) as overdue_paid_amount, sum(sub.paid_amount) as overdue_collected, max(sub.remind_date) as remind_date, max(sub.remind_date) as max_date, sub.id FROM (SELECT scpcrd.amount, COALESCE(scpcrd.paid_amount, 0) as paid_amount, scpcrd.remind_date, t0.project_id as id FROM "a57be577deb434"."tbl_project_used_client_payment_collection_remind_dates" "scpcrd" LEFT JOIN "a57be577deb434"."tbl_project_used_clients" "t0" ON t0.id = scpcrd.project_used_client_id WHERE ("remind_date" <= '2025-07-05') AND (COALESCE(scpcrd.paid_amount, 0) < amount)) "sub" GROUP BY "sub"."id") "od" ON od.id = sc.id LEFT JOIN (SELECT sub.id, min(sub.remind_date) min_date FROM (SELECT scpcrd.amount, COALESCE(scpcrd.paid_amount, 0) as paid_amount, scpcrd.remind_date, t0.project_id as id FROM "a57be577deb434"."tbl_project_used_client_payment_collection_remind_dates" "scpcrd" LEFT JOIN "a57be577deb434"."tbl_project_used_clients" "t0" ON t0.id = scpcrd.project_used_client_id WHERE ("remind_date" > '2025-07-05') AND (COALESCE(scpcrd.paid_amount, 0) >= amount)) "sub" GROUP BY "sub"."id") "mind" ON mind.id = sc.id WHERE (("sales_rep" IN (5049, 5301, 5022, 5209, 5026, 5293, 5309, 5356, 5329, 5299, 5303, 5302, 5332, 5047, 1026, 5096, 5070, 5420, 1029, 1001, 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, 5358, 1006, 5093)) OR ("sales_rep" IS NULL)) AND ("sc"."project_status"=3) AND (u.id is not null) AND (u.used_client is not null) GROUP BY "u"."id", "sc"."id", "scp"."collected", "sci"."invoiced", "od"."overdue_paid_amount", "od"."overdue_collected", "od"."remind_date", "sort_date" ORDER BY "sc"."bargain_date" DESC, "sc"."created_at" DESC LIMIT 20
14:07:47.527traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
14:07:47.527traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
14:07:47.528infoyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_clients" WHERE "id" IN (3278, 3326, 3334, 3333, 3329, 3327, 3328, 3317, 3303, 2526, 3299, 2091, 3270, 3287, 2714, 3265, 2842)
14:07:47.528infoyii\db\Command::querySELECT "id", "from_project", "serial_no" FROM "a57be577deb434"."tbl_sales_contracts" WHERE "from_project" IN (3801, 3769, 3786, 3783, 3780, 3767, 3755, 3710, 3736, 3709, 3655, 3651, 3638, 3609, 3583, 3597, 3555, 3546, 3487, 3512)
14:07:47.529infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_project_used_clients" WHERE "project_id" IN (3801, 3769, 3786, 3783, 3780, 3767, 3755, 3710, 3736, 3709, 3655, 3651, 3638, 3609, 3583, 3597, 3555, 3546, 3487, 3512)
14:07:47.530infoyii\db\Command::querySELECT "id", "id" AS "key", "project_used_client_id", "remind_date", "amount", "remind_date" AS "name", "amount" AS "value", "overdue_days" FROM "a57be577deb434"."tbl_project_used_client_payment_collection_remind_dates" WHERE "project_used_client_id" IN (1, 2, 4, 13, 21, 22, 31, 36, 38, 40, 41, 42, 44, 48, 49, 53, 54, 92, 93, 95)
14:07:47.531infoyii\db\Command::querySELECT sum(used_client_budget) as amount, sum(uncollected) as uncollected, sum(overdue) as overdue FROM (SELECT sc.*, u.budget as used_client_budget, scp.collected, sci.invoiced, (sum(COALESCE(u.budget, 0)) - scp.collected) as uncollected, (sum(COALESCE(u.budget, 0)) - sci.invoiced) as uninvoiced, (overdue_paid_amount - overdue_collected) as overdue, CASE WHEN od.remind_date IS NOT NULL THEN 0 WHEN (u.budget - scp.collected) > 0 THEN 1 ELSE 2 END AS status, CASE WHEN u.budget - scp.collected > 0 THEN ( CASE WHEN overdue_paid_amount - overdue_collected > 0 THEN max_date ELSE min_date END ) ELSE null END AS sort_date, bargain_date FROM "a57be577deb434"."tbl_projects" "sc" LEFT JOIN "a57be577deb434"."tbl_project_used_clients" "u" ON u.project_id = sc.id LEFT JOIN "a57be577deb434"."tbl_clients" "c" ON sc.client_id = c.id LEFT JOIN "a57be577deb434"."tbl_sales_group_relationships" "sgr" ON sgr.sales_id = c.sales_rep LEFT JOIN (SELECT t0.project_id AS project_id, COALESCE(sum(t1.amount), 0) AS collected FROM "a57be577deb434"."tbl_project_used_clients" "t0" LEFT JOIN "a57be577deb434"."tbl_project_used_client_payments" "t1" ON t0.id = t1.project_used_client_id GROUP BY "t0"."id") "scp" ON scp.project_id = sc.id LEFT JOIN (SELECT t0.project_id AS project_id, COALESCE(sum(t1.amount), 0) AS invoiced FROM "a57be577deb434"."tbl_project_used_clients" "t0" LEFT JOIN "a57be577deb434"."tbl_project_used_client_invoices" "t1" ON t0.id = t1.project_used_client_id GROUP BY "t0"."id") "sci" ON sci.project_id = sc.id LEFT JOIN (SELECT sum(sub.amount) as overdue_paid_amount, sum(sub.paid_amount) as overdue_collected, max(sub.remind_date) as remind_date, max(sub.remind_date) as max_date, sub.id FROM (SELECT scpcrd.amount, COALESCE(scpcrd.paid_amount, 0) as paid_amount, scpcrd.remind_date, t0.project_id as id FROM "a57be577deb434"."tbl_project_used_client_payment_collection_remind_dates" "scpcrd" LEFT JOIN "a57be577deb434"."tbl_project_used_clients" "t0" ON t0.id = scpcrd.project_used_client_id WHERE ("remind_date" <= '2025-07-05') AND (COALESCE(scpcrd.paid_amount, 0) < amount)) "sub" GROUP BY "sub"."id") "od" ON od.id = sc.id LEFT JOIN (SELECT sub.id, min(sub.remind_date) min_date FROM (SELECT scpcrd.amount, COALESCE(scpcrd.paid_amount, 0) as paid_amount, scpcrd.remind_date, t0.project_id as id FROM "a57be577deb434"."tbl_project_used_client_payment_collection_remind_dates" "scpcrd" LEFT JOIN "a57be577deb434"."tbl_project_used_clients" "t0" ON t0.id = scpcrd.project_used_client_id WHERE ("remind_date" > '2025-07-05') AND (COALESCE(scpcrd.paid_amount, 0) >= amount)) "sub" GROUP BY "sub"."id") "mind" ON mind.id = sc.id WHERE (("sales_rep" IN (5049, 5301, 5022, 5209, 5026, 5293, 5309, 5356, 5329, 5299, 5303, 5302, 5332, 5047, 1026, 5096, 5070, 5420, 1029, 1001, 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, 5358, 1006, 5093)) OR ("sales_rep" IS NULL)) AND ("sc"."project_status"=3) AND (u.id is not null) AND (u.used_client is not null) GROUP BY "u"."id", "sc"."id", "scp"."collected", "sci"."invoiced", "od"."overdue_paid_amount", "od"."overdue_collected", "od"."remind_date", "sort_date" ORDER BY "sc"."bargain_date" DESC) "sub"
14:07:47.540traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
14:07:47.540traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
14:07:47.540infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_visit_module_histories" WHERE ("user_id"=5250) AND ("object_type"=23) AND ("visit_date"='2025-07-05')
14:07:47.546traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
14:07:47.546traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
14:07:47.546infoyii\db\Command::executeUPDATE "a57be577deb434"."tbl_visit_module_histories" SET "num"=145, "last_visit_at"='now()' WHERE "id"=49799
14:07:47.547infoyii\db\Command::queryINSERT INTO "global"."tbl_api_log" ("code", "schema", "user_id", "device_type", "url", "request", "response", "php_error", "time") VALUES (200, 'a57be577deb434', 5250, 5, 'vue/analysis/used-client-payment-collection', '{"status":"","period":"","to":"","from":"","dataUserId":"","group":"","page":"1","web_access_token":"lF6lDSiCl5CRIFfE8shlx2wSeme229Hs"}', '{"code":2000,"result":{"list":[{"id":3801,"client_id":3278,"project_status":3,"project_progress":9,"budget":"8000","profit_pct":"93.75","bargain_date":"2025-04-09","description":"\u6d4b\u8bd5","created_by":1001,"created_at":"2025-04-09 16:16:54","updated_at":"2025-06-11 15:29:06","engineer_id":"","project_title":"\u8d1f\u6570\u95ee\u9898","collected":"1.00","status_updated_at":"2025-06-11 11:14:46.224284+08","success_rate":"","comment":"","contract_type":1,"progress_updated_at":"2025-04-09 16:16:54.248165+08","forecast_updated_at":"2025-06-11 15:25:07.922296+08","end_at":"","pinyin_shortcut":"fswt","creator":1001,"used_client":"","from_contact":5934,"total_contact_point":"","paid_contact_point":"","project_product_version_id":808,"is_sales_order_ready":false,"collected_plan":"8000","used_client_budget":"598000","invoiced":"1","uncollected":"597999.00","uninvoiced":"597999","overdue":"109999","status":0,"sort_date":"2025-06-11","client":{"id":3278,"key":3278,"name":"\u5317\u4eac\u521b\u5b89\u5149\u901a\u79d1\u6280\u53d1\u5c55\u6709\u9650\u516c\u53f8"},"buildContract":{"id":3844,"from_project":3801,"serial_no":""},"projectUsedClient":{"id":95,"project_id":3801,"used_client":3334,"budget":"598000","profit":"478400","profit_pct":"80","collected_plan":"110000","remind_ahead":"","projectUsedClientPaymentCollectionRemindDates":[{"id":13,"key":13,"project_used_client_id":95,"remind_date":"2025-06-11","amount":110000,"name":"2025-06-11","value":110000,"overdue_days":""}]},"collect_status_display":"\u672a\u5b8c\u6210","overdue_display":"\u903e\u671f24\u5929","overdue_amount":"109999","remind_date":"2025-06-11"},{"id":3769,"client_id":3326,"project_status":3,"project_progress":10,"budget":"32000","profit_pct":"93","bargain_date":"2025-03-05","description":"","created_by":5087,"created_at":"2025-01-21 13:13:23","updated_at":"2025-03-05 10:15:34","engineer_id":"","project_title":"\u897f\u660c\u7f51\u5173-\u589e\u52a0\u670d\u52a1\u8d39","collected":"0","status_updated_at":"2025-01-21 15:45:00.954677+08","success_rate":"","comment":"","contract_type":1,"progress_updated_at":"2025-01-21 13:13:23.709966+08","forecast_updated_at":"2025-01-21 13:13:23.709966+08","end_at":"2025-02-10 13:25:13","pinyin_shortcut":"xcwgzjfwf","creator":5087,"used_client":2130,"from_contact":"","total_contact_point":"","paid_contact_point":"","project_product_version_id":769,"is_sales_order_ready":true,"collected_plan":"32000","used_client_budget":"","invoiced":"0","uncollected":"0","uninvoiced":"0","overdue":"","status":2,"sort_date":"","client":{"id":3326,"key":3326,"name":"\u4fdd\u5b9a\u6c90\u69ff\u7f51\u7edc\u79d1\u6280\u6709\u9650\u516c\u53f8\uff08304\u8fc7\u5355\uff09"},"buildContract":{"id":3770,"from_project":3769,"serial_no":"TS-LW-20250305001"},"projectUsedClient":{"id":40,"project_id":3769,"used_client":2130,"budget":"","profit":"","profit_pct":"","collected_plan":"","remind_ahead":"","projectUsedClientPaymentCollectionRemindDates":[]},"collect_status_display":"\u672a\u5b8c\u6210","overdue_display":"","overdue_amount":"","remind_date":""},{"id":3786,"client_id":3334,"project_status":3,"project_progress":9,"budget":"3593747","profit_pct":"1.7","bargain_date":"2025-02-28","description":"","created_by":1001,"created_at":"2025-02-28 16:22:00","updated_at":"2025-07-04 14:19:12","engineer_id":"","project_title":"\u8fdc\u9274\u8f6f\u4ef6-\u8fc7\u7a0b\u76d1\u63a7\u4ea7\u54c1","collected":"0","status_updated_at":"2025-02-28 16:22:00.848979+08","success_rate":"","comment":"\u7d2b\u5149\u6768\u534e\u63a8\u8350","contract_type":1,"progress_updated_at":"2025-02-28 16:22:00.848979+08","forecast_updated_at":"2025-04-08 14:42:27.53319+08","end_at":"","pinyin_shortcut":"yjrjgcjkcp","creator":1001,"used_client":"","from_contact":"","total_contact_point":"","paid_contact_point":"","project_product_version_id":788,"is_sales_order_ready":true,"collected_plan":"3048205","used_client_budget":"20000","invoiced":"0","uncollected":"20000","uninvoiced":"20000","overdue":"8000","status":0,"sort_date":"2025-04-08","client":{"id":3334,"key":3334,"name":"\u5317\u4eac\u878d\u9890\u5149\u7535\u79d1\u6280\u6709\u9650\u516c\u53f8(\u8fc7\u5355)"},"buildContract":{"id":3803,"from_project":3786,"serial_no":"TSKJ20250228-LRC-001"},"projectUsedClient":{"id":92,"project_id":3786,"used_client":982,"budget":"20000","profit":"16000","profit_pct":"80","collected_plan":"8000","remind_ahead":"1 day","projectUsedClientPaymentCollectionRemindDates":[{"id":1,"key":1,"project_used_client_id":92,"remind_date":"2025-04-08","amount":8000,"name":"2025-04-08","value":8000,"overdue_days":""}]},"collect_status_display":"\u672a\u5b8c\u6210","overdue_display":"\u903e\u671f88\u5929","overdue_amount":"8000","remind_date":"2025-04-08"},{"id":3783,"client_id":3333,"project_status":3,"project_progress":10,"budget":"2310000","profit_pct":"2","bargain_date":"2025-02-21","description":"","created_by":1005,"created_at":"2025-02-26 10:18:25","updated_at":"2025-05-20 00:39:25","engineer_id":"","project_title":"\u58f9\u8fdb\u5236\u8f6f\u4ef6\u8fc7\u5355","collected":"0","status_updated_at":"2025-02-26 10:24:57.415623+08","success_rate":"","comment":"\u58f9\u8fdb\u5236\u6768\u7ea2\u6885\u8fc7\u5355\u9879\u76ee\u300223\u5e74\u5df2\u7ecf\u4ea4\u4ed8\u4e86\uff0c\u73b0\u5728\u8865\u624b\u7eed\u3002","contract_type":1,"progress_updated_at":"2025-02-26 10:18:25.304188+08","forecast_updated_at":"2025-02-26 10:18:25.304188+08","end_at":"","pinyin_shortcut":"yjzrjgd","creator":1005,"used_client":1457,"from_contact":"","total_contact_point":"","paid_contact_point":"","project_product_version_id":795,"is_sales_order_ready":false,"collected_plan":"2310000","used_client_budget":"","invoiced":"0","uncollected":"0","uninvoiced":"0","overdue":"","status":2,"sort_date":"","client":{"id":3333,"key":3333,"name":"\u822a\u5929\u56db\u521b\u79d1\u6280\u6709\u9650\u8d23\u4efb\u516c\u53f8\uff08\u8fc7\u5355\uff09"},"buildContract":{"id":3795,"from_project":3783,"serial_no":"TSKJ20250221-ZHY-001"},"projectUsedClient":{"id":44,"project_id":3783,"used_client":1457,"budget":"","profit":"","profit_pct":"","collected_plan":"","remind_ahead":"","projectUsedClientPaymentCollectionRemindDates":[]},"collect_status_display":"\u672a\u5b8c\u6210","overdue_display":"","overdue_amount":"","remind_date":""},{"id":3780,"client_id":3329,"project_status":3,"project_progress":49,"budget":"277500","profit_pct":"12.91","bargain_date":"2025-02-10","description":"\u7528\u6237\uff1a\u7279\u79cd\u673a\u68b0\u7814\u7a76\u6240\uff0c\u4e0b\u5355\u91d1\u989d\uff1a5\u4e07*6=30\u4e07\n\u9f50\u5fc3\u6263\u9664\u5e73\u53f0\u70b97.5\u70b9\u540e\uff0c\u7ed3\u7b97277500","created_by":5087,"created_at":"2025-02-23 08:25:28","updated_at":"2025-03-16 08:37:35","engineer_id":"","project_title":"59\u6240\u56fd\u4ea7\u670d\u52a1\u5668\u91c7\u8d2d -k","collected":"0","status_updated_at":"2025-03-09 08:53:40.745171+08","success_rate":"","comment":"","contract_type":1,"progress_updated_at":"2025-03-09 08:53:40.745171+08","forecast_updated_at":"2025-03-09 08:53:40.745171+08","end_at":"","pinyin_shortcut":"59sgcfwqcgk","creator":5087,"used_client":2136,"from_contact":"","total_contact_point":"6000","paid_contact_point":"","project_product_version_id":793,"is_sales_order_ready":true,"collected_plan":"277500","used_client_budget":"","invoiced":"0","uncollected":"0","uninvoiced":"0","overdue":"","status":2,"sort_date":"","client":{"id":3329,"key":3329,"name":"\u6df1\u5733\u9f50\u5fc3\u96c6\u56e2\u80a1\u4efd\u6709\u9650\u516c\u53f8 (\u8fc7\u5355\uff09"},"buildContract":{"id":3789,"from_project":3780,"serial_no":"LINK20250210340000693"},"projectUsedClient":{"id":42,"project_id":3780,"used_client":2136,"budget":"","profit":"","profit_pct":"","collected_plan":"","remind_ahead":"","projectUsedClientPaymentCollectionRemindDates":[]},"collect_status_display":"\u672a\u5b8c\u6210","overdue_display":"","overdue_amount":"","remind_date":""},{"id":3767,"client_id":3327,"project_status":3,"project_progress":6,"budget":"121361","profit_pct":"0.65","bargain_date":"2025-01-16","description":"","created_by":1001,"created_at":"2025-01-16 10:05:08","updated_at":"2025-04-19 17:01:38","engineer_id":"","project_title":"PA440 2\u53f0\u8bbe\u5907\u65b0\u8d2d\u9879\u76ee\u4e8c","collected":"0","status_updated_at":"2025-01-16 15:05:08.316552+08","success_rate":"","comment":"\u5566\u5566\u5566","contract_type":1,"progress_updated_at":"2025-01-16 10:05:08.667191+08","forecast_updated_at":"2025-04-08 14:45:55.867721+08","end_at":"2025-04-19 17:01:38","pinyin_shortcut":"PA4402tsbxgxme","creator":1001,"used_client":"","from_contact":1262,"total_contact_point":"40095","paid_contact_point":"40095","project_product_version_id":763,"is_sales_order_ready":true,"collected_plan":"121361.0","used_client_budget":"20000","invoiced":"0","uncollected":"20000","uninvoiced":"20000","overdue":"2398","status":0,"sort_date":"2025-04-10","client":{"id":3327,"key":3327,"name":"\u4fe1\u8054\u6cfd\u90a6\uff08\u9752\u5c9b\uff09\u5de5\u7a0b\u6280\u672f\u6709\u9650\u516c\u53f8\uff08\u8fc7\u5355\uff09"},"buildContract":{"id":3763,"from_project":3767,"serial_no":"TS-LRC-2025011601"},"projectUsedClient":{"id":93,"project_id":3767,"used_client":3300,"budget":"20000","profit":"18000","profit_pct":"90","collected_plan":"2398","remind_ahead":"2 days","projectUsedClientPaymentCollectionRemindDates":[{"id":3,"key":3,"project_used_client_id":93,"remind_date":"2025-04-10","amount":55,"name":"2025-04-10","value":55,"overdue_days":""},{"id":4,"key":4,"project_used_client_id":93,"remind_date":"2025-04-07","amount":2343,"name":"2025-04-07","value":2343,"overdue_days":""}]},"collect_status_display":"\u672a\u5b8c\u6210","overdue_display":"\u903e\u671f86\u5929","overdue_amount":"2398","remind_date":"2025-04-07"},{"id":3755,"client_id":3328,"project_status":3,"project_progress":5,"budget":"537370","profit_pct":"19.37","bargain_date":"2024-12-31","description":"","created_by":5300,"created_at":"2024-12-30 10:19:49","updated_at":"2025-01-02 14:26:22","engineer_id":"","project_title":"\u9f50\u6cbb\u5821\u5792\u673a\u65b0\u8d2d-K-224","collected":"0","status_updated_at":"2024-12-30 16:17:03.198647+08","success_rate":"","comment":"","contract_type":1,"progress_updated_at":"2024-12-30 10:19:49.65271+08","forecast_updated_at":"2024-12-30 10:19:49.65271+08","end_at":"","pinyin_shortcut":"qzbljxgK224","creator":5300,"used_client":287,"from_contact":"","total_contact_point":"80000","paid_contact_point":"","project_product_version_id":741,"is_sales_order_ready":false,"collected_plan":"537370","used_client_budget":"","invoiced":"0","uncollected":"0","uninvoiced":"0","overdue":"","status":2,"sort_date":"","client":{"id":3328,"key":3328,"name":"\u8fc7\u5355-\u795e\u5dde\u6570\u7801\u7cfb\u7edf\u96c6\u6210\u670d\u52a1\u6709\u9650\u516c\u53f8\u4e0a\u6d77\u5206\u516c\u53f8-\u5317\u4eac\u5954\u9a70"},"buildContract":{"id":3740,"from_project":3755,"serial_no":"DCA2024120211"},"projectUsedClient":{"id":38,"project_id":3755,"used_client":287,"budget":"","profit":"","profit_pct":"","collected_plan":"","remind_ahead":"","projectUsedClientPaymentCollectionRemindDates":[]},"collect_status_display":"\u672a\u5b8c\u6210","overdue_display":"","overdue_amount":"","remind_date":""},{"id":3710,"client_id":3317,"project_status":3,"project_progress":5,"budget":"228435","profit_pct":"33.65","bargain_date":"2024-11-04","description":"","created_by":5295,"created_at":"2024-11-04 17:20:36","updated_at":"2025-01-20 09:43:59","engineer_id":"","project_title":"\u65b0\u8d2d\u6570\u636e\u5907\u4efd\u548c\u65e5\u5fd7\u5ba1\u8ba1\u7cfb\u7edf","collected":"0","status_updated_at":"2024-11-04 17:31:48.75799+08","success_rate":"","comment":"","contract_type":1,"progress_updated_at":"2024-11-04 17:20:36.836582+08","forecast_updated_at":"2024-11-04 17:20:36.836582+08","end_at":"","pinyin_shortcut":"xgsjbfhrzsjxt","creator":5295,"used_client":1121,"from_contact":"","total_contact_point":"15000","paid_contact_point":"","project_product_version_id":685,"is_sales_order_ready":true,"collected_plan":"228435.0","used_client_budget":"","invoiced":"0","uncollected":"0","uninvoiced":"0","overdue":"","status":2,"sort_date":"","client":{"id":3317,"key":3317,"name":"\u5317\u4eac\u98de\u9e4f\u6052\u4e1a\u79d1\u6280\u6709\u9650\u516c\u53f8\uff08\u8fc7\u5355\uff09"},"buildContract":{"id":3646,"from_project":3710,"serial_no":"TS-WZW-2024110401"},"projectUsedClient":{"id":21,"project_id":3710,"used_client":1121,"budget":"","profit":"","profit_pct":"","collected_plan":"","remind_ahead":"","projectUsedClientPaymentCollectionRemindDates":[]},"collect_status_display":"\u672a\u5b8c\u6210","overdue_display":"","overdue_amount":"","remind_date":""},{"id":3736,"client_id":3326,"project_status":3,"project_progress":49,"budget":"293040","profit_pct":"28","bargain_date":"2024-10-30","description":"","created_by":5087,"created_at":"2024-12-09 11:00:55","updated_at":"2025-02-11 09:39:52","engineer_id":"","project_title":"\u897f\u660c\u7f51\u5173\u9879\u76ee-K","collected":"0","status_updated_at":"2024-12-16 00:50:00.086311+08","success_rate":"","comment":"\u5408\u540c\u91d1\u989d330000-\u6210\u672c180000-6600\u5408\u540c\u989d2%-19500\u5229\u6da6\u768413%=123900\u5229\u6da6\uff0c\u7ed3\u8d26\u5468\u671f\u4e3a2025\u5e744\u6708\u5e95\u524d\u5168\u6b3e\u7ed3\u56de\u3002","contract_type":1,"progress_updated_at":"2024-12-16 00:50:00.086311+08","forecast_updated_at":"2024-12-16 00:50:00.086311+08","end_at":"2025-02-11 09:13:42","pinyin_shortcut":"xcwgxmK","creator":1001,"used_client":2130,"from_contact":"","total_contact_point":"","paid_contact_point":"","project_product_version_id":702,"is_sales_order_ready":true,"collected_plan":"293040","used_client_budget":"","invoiced":"0","uncollected":"0","uninvoiced":"0","overdue":"","status":2,"sort_date":"","client":{"id":3326,"key":3326,"name":"\u4fdd\u5b9a\u6c90\u69ff\u7f51\u7edc\u79d1\u6280\u6709\u9650\u516c\u53f8\uff08304\u8fc7\u5355\uff09"},"buildContract":{"id":3697,"from_project":3736,"serial_no":"TS-LW-2024103001"},"projectUsedClient":{"id":31,"project_id":3736,"used_client":2130,"budget":"","profit":"","profit_pct":"","collected_plan":"","remind_ahead":"","projectUsedClientPaymentCollectionRemindDates":[]},"collect_status_display":"\u672a\u5b8c\u6210","overdue_display":"","overdue_amount":"","remind_date":""},{"id":3709,"client_id":3303,"project_status":3,"project_progress":9,"budget":"305280","profit_pct":"38.01","bargain_date":"2024-10-29","description":"","created_by":1004,"created_at":"2024-11-04 11:00:28","updated_at":"2024-11-11 17:44:35","engineer_id":"","project_title":"\u7535\u79d1\u592a\u529b\u4fe1\u606f\u4e2d\u5fc3\u673a\u623f\u642c\u8fc1","collected":"0","status_updated_at":"2024-11-04 16:58:53.110493+08","success_rate":"","comment":"","contract_type":1,"progress_updated_at":"2024-11-04 16:58:53.110493+08","forecast_updated_at":"2024-11-04 11:00:28.698944+08","end_at":"2024-11-11 17:15:45","pinyin_shortcut":"dktlxxzxjfbq","creator":1004,"used_client":5,"from_contact":"","total_contact_point":"","paid_contact_point":"","project_product_version_id":648,"is_sales_order_ready":true,"collected_plan":"305280","used_client_budget":"","invoiced":"0","uncollected":"0","uninvoiced":"0","overdue":"","status":2,"sort_date":"","client":{"id":3303,"key":3303,"name":"\u5317\u4eac\u795e\u5dde\u90a6\u90a6\u6280\u672f\u670d\u52a1\u6709\u9650\u516c\u53f8\uff08\u8fc7\u5355\uff09"},"buildContract":{"id":3645,"from_project":3709,"serial_no":"XSZYO68316"},"projectUsedClient":{"id":22,"project_id":3709,"used_client":5,"budget":"","profit":"","profit_pct":"","collected_plan":"","remind_ahead":"","projectUsedClientPaymentCollectionRemindDates":[]},"collect_status_display":"\u672a\u5b8c\u6210","overdue_display":"","overdue_amount":"","remind_date":""},{"id":3655,"client_id":3303,"project_status":3,"project_progress":49,"budget":"169600","profit_pct":"93","bargain_date":"2024-09-12","description":"","created_by":1004,"created_at":"2024-09-12 18:12:19","updated_at":"2024-09-20 09:48:35","engineer_id":"","project_title":"\u963f\u91cc\u4e91\u8fc1\u79fb\u670d\u52a1","collected":"0","status_updated_at":"2024-09-17 17:16:01.418785+08","success_rate":"","comment":"","contract_type":1,"progress_updated_at":"2024-09-17 17:16:01.418785+08","forecast_updated_at":"2024-09-17 17:16:01.418785+08","end_at":"2024-09-24 11:36:35","pinyin_shortcut":"alyqyfw","creator":1004,"used_client":5,"from_contact":"","total_contact_point":"","paid_contact_point":"","project_product_version_id":580,"is_sales_order_ready":true,"collected_plan":"169600","used_client_budget":"","invoiced":"0","uncollected":"0","uninvoiced":"0","overdue":"","status":2,"sort_date":"","client":{"id":3303,"key":3303,"name":"\u5317\u4eac\u795e\u5dde\u90a6\u90a6\u6280\u672f\u670d\u52a1\u6709\u9650\u516c\u53f8\uff08\u8fc7\u5355\uff09"},"buildContract":{"id":3542,"from_project":3655,"serial_no":"XSZY067245"},"projectUsedClient":{"id":2,"project_id":3655,"used_client":5,"budget":"","profit":"","profit_pct":"","collected_plan":"","remind_ahead":"","projectUsedClientPaymentCollectionRemindDates":[]},"collect_status_display":"\u672a\u5b8c\u6210","overdue_display":"","overdue_amount":"","remind_date":""},{"id":3651,"client_id":2526,"project_status":3,"project_progress":49,"budget":"4000","profit_pct":"93","bargain_date":"2024-09-04","description":"","created_by":5087,"created_at":"2024-09-04 16:09:28","updated_at":"2024-12-16 00:49:37","engineer_id":"","project_title":"\u7cfb\u7edf\u516c\u53f8\u7f51\u7edc\u7ef4\u62a4\u2014K","collected":"0","status_updated_at":"2024-09-04 16:12:30.603228+08","success_rate":"","comment":"3\u67081\u65e5\t\"\u5b9e\u65bd\u76ee\u6807\uff1a\u89e3\u51b3\u7b49\u4fdd\u8981\u6c42\u7684\u82e5\u5e72\u95ee\u9898\uff1b\n\u5b8c\u6210\u60c5\u51b5\uff1a\u5df2\u5b8c\u6210\uff0c\u6309\u7b49\u4fdd\u8981\u6c42\u4fee\u6539\u6838\u5fc3\u4ea4\u6362\u673a\u914d\u7f6e\uff0c\u4fee\u6539\u63a5\u5165\u4ea4\u6362\u673a\u914d\u7f6e\"\n8\u67082\u65e5\t\"\u5b9e\u65bd\u76ee\u6807\uff1a\u89e3\u51b34\u5c42\u4ea4\u6362\u673a\u548c\u6838\u5fc3\u4ea4\u6362\u673a\u4e4b\u95f4\u94fe\u8def\u805a\u5408\u4e0d\u901a\u95ee\u9898\uff1b\n\u95ee\u9898\u63cf\u8ff0\uff1a\u901a\u8fc7\u6392\u67e5\uff0c\u53d1\u73b0\u6838\u5fc3\u4ea4\u6362\u673aten1\/3\/0\/3\u63a5\u53e3\u7684\u94fe\u8def\u805a\u5408\u7ec4\u914d\u7f6e\u9519\u8bef\uff0c\u4fee\u6539\u540e\u6b63\u5e38\u3002\"","contract_type":2,"progress_updated_at":"2024-09-04 16:09:28.498178+08","forecast_updated_at":"2024-09-04 16:09:28.498178+08","end_at":"2024-12-16 16:35:51","pinyin_shortcut":"xtgswlwhK","creator":5087,"used_client":3300,"from_contact":"","total_contact_point":"","paid_contact_point":"","project_product_version_id":566,"is_sales_order_ready":true,"collected_plan":"4000","used_client_budget":"","invoiced":"0","uncollected":"0","uninvoiced":"0","overdue":"","status":2,"sort_date":"","client":{"id":2526,"key":2526,"name":"\u5317\u4eac\u822a\u5929\u6d4b\u63a7\u6280\u672f\u6709\u9650\u516c\u53f8"},"buildContract":{"id":3522,"from_project":3651,"serial_no":"TS-LW-2024090401"},"projectUsedClient":{"id":1,"project_id":3651,"used_client":3300,"budget":"","profit":"","profit_pct":"","collected_plan":"","remind_ahead":"","projectUsedClientPaymentCollectionRemindDates":[]},"collect_status_display":"\u672a\u5b8c\u6210","overdue_display":"","overdue_amount":"","remind_date":""},{"id":3638,"client_id":3299,"project_status":3,"project_progress":6,"budget":"36950","profit_pct":"67.4","bargain_date":"2024-08-19","description":"","created_by":1004,"created_at":"2024-08-25 16:33:25","updated_at":"2024-10-17 15:47:03","engineer_id":"","project_title":"\u534e\u4e3a\u65e0\u7ebfAP","collected":"0","status_updated_at":"2024-08-27 09:19:50.372876+08","success_rate":"","comment":"","contract_type":1,"progress_updated_at":"2024-08-25 16:33:25.812285+08","forecast_updated_at":"2024-08-25 16:33:25.812285+08","end_at":"2024-09-23 11:04:37","pinyin_shortcut":"hwwxAP","creator":1004,"used_client":3174,"from_contact":"","total_contact_point":"","paid_contact_point":"","project_product_version_id":544,"is_sales_order_ready":true,"collected_plan":"36950","used_client_budget":"","invoiced":"0","uncollected":"0","uninvoiced":"0","overdue":"","status":2,"sort_date":"","client":{"id":3299,"key":3299,"name":"\u6c5f\u897f\u6a1f\u6f9c\u79d1\u6280\u6709\u9650\u516c\u53f8\uff08\u8fc7\u5355\uff09"},"buildContract":{"id":3495,"from_project":3638,"serial_no":"TS-YJC-2024081901"},"projectUsedClient":{"id":49,"project_id":3638,"used_client":3174,"budget":"","profit":"","profit_pct":"","collected_plan":"","remind_ahead":"","projectUsedClientPaymentCollectionRemindDates":[]},"collect_status_display":"\u672a\u5b8c\u6210","overdue_display":"","overdue_amount":"","remind_date":""},{"id":3609,"client_id":2091,"project_status":3,"project_progress":49,"budget":"300000","profit_pct":"20.64","bargain_date":"2024-08-05","description":"","created_by":1004,"created_at":"2024-07-28 17:56:10","updated_at":"2024-12-22 16:20:40","engineer_id":"","project_title":"\u601d\u79d1N9K\u7b49\u7eed\u4fdd\u9879\u76ee","collected":"0","status_updated_at":"2024-09-17 17:14:57.789718+08","success_rate":"","comment":"","contract_type":1,"progress_updated_at":"2024-09-17 17:14:57.789718+08","forecast_updated_at":"2024-09-17 17:14:57.789718+08","end_at":"","pinyin_shortcut":"skN9Kdxbxm","creator":1004,"used_client":5,"from_contact":"","total_contact_point":"42800","paid_contact_point":"","project_product_version_id":541,"is_sales_order_ready":true,"collected_plan":"300000","used_client_budget":"","invoiced":"0","uncollected":"0","uninvoiced":"0","overdue":"","status":2,"sort_date":"","client":{"id":2091,"key":2091,"name":"\u795e\u5dde\u6570\u7801\u7cfb\u7edf\u96c6\u6210\u670d\u52a1\u6709\u9650\u516c\u53f8"},"buildContract":{"id":3477,"from_project":3609,"serial_no":"\u601d\u8054\u79d1\u8baf\u7b7e\u7ea6YJC-2024080501"},"projectUsedClient":{"id":53,"project_id":3609,"used_client":5,"budget":"","profit":"","profit_pct":"","collected_plan":"","remind_ahead":"","projectUsedClientPaymentCollectionRemindDates":[]},"collect_status_display":"\u672a\u5b8c\u6210","overdue_display":"","overdue_amount":"","remind_date":""},{"id":3583,"client_id":3270,"project_status":3,"project_progress":49,"budget":"110000","profit_pct":"91.23","bargain_date":"2024-07-22","description":"","created_by":5087,"created_at":"2024-07-01 11:42:26","updated_at":"2025-03-03 15:33:07","engineer_id":"","project_title":"\u670d\u52a1\u8d39-K","collected":"0","status_updated_at":"2024-07-22 10:51:36.679315+08","success_rate":"","comment":"\u6d4b\u63a7\u96f6\u6563\u670d\u52a1\u53ca\u914d\u4ef6","contract_type":2,"progress_updated_at":"2024-07-22 10:27:11.575437+08","forecast_updated_at":"2024-07-22 10:27:11.575437+08","end_at":"2024-11-01 15:55:29","pinyin_shortcut":"fwfK","creator":5087,"used_client":2526,"from_contact":"","total_contact_point":"","paid_contact_point":"","project_product_version_id":720,"is_sales_order_ready":true,"collected_plan":"110000","used_client_budget":"","invoiced":"0","uncollected":"0","uninvoiced":"0","overdue":"","status":2,"sort_date":"","client":{"id":3270,"key":3270,"name":"\u5317\u4eac\u51ef\u9510\u8fdc\u666f\u79d1\u6280\u6709\u9650\u516c\u53f8\uff08\u8fc7\u5355\uff09"},"buildContract":{"id":3420,"from_project":3583,"serial_no":"TS-LW-2024072201"},"projectUsedClient":{"id":36,"project_id":3583,"used_client":2526,"budget":"","profit":"","profit_pct":"","collected_plan":"","remind_ahead":"","projectUsedClientPaymentCollectionRemindDates":[]},"collect_status_display":"\u672a\u5b8c\u6210","overdue_display":"","overdue_amount":"","remind_date":""},{"id":3597,"client_id":3287,"project_status":3,"project_progress":10,"budget":"170600","profit_pct":"2.85","bargain_date":"2024-07-12","description":"","created_by":5412,"created_at":"2024-07-15 14:11:50","updated_at":"2025-01-14 11:02:51","engineer_id":"","project_title":"\u4ea4\u6362\u673a\u9879\u76ee","collected":"0","status_updated_at":"2024-07-15 14:11:50.331988+08","success_rate":"","comment":"\u65e0\u9700\u4ea4\u4ed8\u3001\u62d3\u5b9e\u6536\u53d6\uff1a\u8fc7\u5355\u603b\u91d1\u989d\u76845%+\u5dee\u989d\u768425%\uff0c\u4f59\u4e0b\u7684\u4e3a\u5546\u673a\u79ef\u5206","contract_type":1,"progress_updated_at":"2024-07-15 14:11:50.331988+08","forecast_updated_at":"2024-07-15 14:11:50.331988+08","end_at":"2024-09-13 14:51:12","pinyin_shortcut":"jhjxm","creator":5412,"used_client":3287,"from_contact":"","total_contact_point":"37259","paid_contact_point":"37259","project_product_version_id":510,"is_sales_order_ready":false,"collected_plan":"170600","used_client_budget":"","invoiced":"0","uncollected":"0","uninvoiced":"0","overdue":"","status":2,"sort_date":"","client":{"id":3287,"key":3287,"name":"\u4e0a\u6d77\u7533\u94f6\u4e07\u56fd\u8bc1\u5238\u7814\u7a76\u6240\u6709\u9650\u516c\u53f8"},"buildContract":{"id":3410,"from_project":3597,"serial_no":"TS-ZL-2024062603"},"projectUsedClient":{"id":41,"project_id":3597,"used_client":3287,"budget":"","profit":"","profit_pct":"","collected_plan":"","remind_ahead":"","projectUsedClientPaymentCollectionRemindDates":[]},"collect_status_display":"\u672a\u5b8c\u6210","overdue_display":"","overdue_amount":"","remind_date":""},{"id":3555,"client_id":2714,"project_status":3,"project_progress":9,"budget":"257296","profit_pct":"80.54","bargain_date":"2024-06-27","description":"","created_by":1004,"created_at":"2024-06-03 16:23:43","updated_at":"2024-11-17 18:08:07","engineer_id":"","project_title":"\u601d\u79d1\u7aef\u53e3\u6388\u6743\u9879\u76ee","collected":"0","status_updated_at":"2024-06-30 17:23:20.441335+08","success_rate":"","comment":"","contract_type":1,"progress_updated_at":"2024-06-30 17:22:24.028792+08","forecast_updated_at":"2024-06-17 14:13:06.517933+08","end_at":"2024-11-20 16:32:36","pinyin_shortcut":"skdksqxm","creator":1004,"used_client":5,"from_contact":"","total_contact_point":"","paid_contact_point":"","project_product_version_id":464,"is_sales_order_ready":true,"collected_plan":"257296","used_client_budget":"","invoiced":"0","uncollected":"0","uninvoiced":"0","overdue":"","status":2,"sort_date":"","client":{"id":2714,"key":2714,"name":"\u5317\u4eac\u534e\u590f\u51ef\u777f\u79d1\u6280\u6709\u9650\u516c\u53f8\uff08\u8fc7\u5355\uff09"},"buildContract":{"id":3373,"from_project":3555,"serial_no":"TS-YJC-20240627"},"projectUsedClient":{"id":48,"project_id":3555,"used_client":5,"budget":"","profit":"","profit_pct":"","collected_plan":"","remind_ahead":"","projectUsedClientPaymentCollectionRemindDates":[]},"collect_status_display":"\u672a\u5b8c\u6210","overdue_display":"","overdue_amount":"","remind_date":""},{"id":3546,"client_id":3265,"project_status":3,"project_progress":9,"budget":"87917","profit_pct":"5.94","bargain_date":"2024-05-24","description":"","created_by":1005,"created_at":"2024-05-21 11:56:32","updated_at":"2024-07-03 13:55:08","engineer_id":"","project_title":"\u665f\u6e90\u81ea\u52a8\u5316\u8bbe\u5907\u5907\u4ef6","collected":"0","status_updated_at":"2024-05-24 11:31:04.80731+08","success_rate":"","comment":"","contract_type":1,"progress_updated_at":"2024-05-21 11:56:32.593908+08","forecast_updated_at":"2024-05-21 11:56:32.593908+08","end_at":"2024-06-19 16:57:27","pinyin_shortcut":"cyzdhsbbj","creator":1005,"used_client":149,"from_contact":"","total_contact_point":"","paid_contact_point":"","project_product_version_id":414,"is_sales_order_ready":true,"collected_plan":"87917.0","used_client_budget":"","invoiced":"0","uncollected":"0","uninvoiced":"0","overdue":"","status":2,"sort_date":"","client":{"id":3265,"key":3265,"name":"\u5317\u4eac\u91d1\u6e90\u5229\u76db\u79d1\u6280\u6709\u9650\u516c\u53f8\uff08\u8fc7\u5355\uff09"},"buildContract":{"id":3311,"from_project":3546,"serial_no":"TS-ZHY-2024052408"},"projectUsedClient":{"id":13,"project_id":3546,"used_client":149,"budget":"","profit":"","profit_pct":"","collected_plan":"","remind_ahead":"","projectUsedClientPaymentCollectionRemindDates":[]},"collect_status_display":"\u672a\u5b8c\u6210","overdue_display":"","overdue_amount":"","remind_date":""},{"id":3487,"client_id":2091,"project_status":3,"project_progress":9,"budget":"2322000","profit_pct":"42.23","bargain_date":"2024-04-28","description":"\u5317\u4eac\u601d\u8054\u79d1\u8baf\u79d1\u6280\u6709\u9650\u516c\u53f8 \u7b7e\u7ea6\u5408\u540c\uff1b","created_by":1004,"created_at":"2024-03-31 15:11:58","updated_at":"2025-01-09 10:22:22","engineer_id":"","project_title":"2024\u865a\u62df\u5316\u5e73\u53f0\u786c\u4ef6\u7eed\u4fdd\u9879\u76ee","collected":"0","status_updated_at":"2024-04-29 13:48:59.955033+08","success_rate":"","comment":"","contract_type":2,"progress_updated_at":"2024-04-28 18:20:08.886092+08","forecast_updated_at":"2024-04-28 18:20:08.886092+08","end_at":"2024-11-26 17:22:39","pinyin_shortcut":"2024xnhptyjxbxm","creator":1004,"used_client":5,"from_contact":"","total_contact_point":"200000","paid_contact_point":"200000","project_product_version_id":374,"is_sales_order_ready":true,"collected_plan":"2322000","used_client_budget":"","invoiced":"0","uncollected":"0","uninvoiced":"0","overdue":"","status":2,"sort_date":"","client":{"id":2091,"key":2091,"name":"\u795e\u5dde\u6570\u7801\u7cfb\u7edf\u96c6\u6210\u670d\u52a1\u6709\u9650\u516c\u53f8"},"buildContract":{"id":3261,"from_project":3487,"serial_no":"\u601d\u8054\u79d1\u8bafDCS2024040186"},"projectUsedClient":{"id":4,"project_id":3487,"used_client":5,"budget":"","profit":"","profit_pct":"","collected_plan":"","remind_ahead":"","projectUsedClientPaymentCollectionRemindDates":[]},"collect_status_display":"\u672a\u5b8c\u6210","overdue_display":"","overdue_amount":"","remind_date":""},{"id":3512,"client_id":2842,"project_status":3,"project_progress":10,"budget":"120000","profit_pct":"25.58","bargain_date":"2024-04-23","description":"","created_by":1005,"created_at":"2024-04-23 16:49:42","updated_at":"2025-05-12 14:01:50","engineer_id":"","project_title":"\u4e00\u6c7d\u9752\u85e4\u7ef4\u4fdd\u670d\u52a1","collected":"0","status_updated_at":"2024-04-23 17:12:58.765678+08","success_rate":"","comment":"\u8303\u946b\u660a\u9879\u76ee\n\u6263\u5b8c\u7a0e\u70b9\u8fd4\u6b3e25632\u3002\u57ab\u8d44\u7684\u70b9\u94b1\u672a\u7b97\u3002\n\u6b64\u7b14\u6682\u65f6\u4e0d\u7b97\uff0c\u7b97\u5230\u5176\u4ed6\u9879\u76ee\u91cc\u3002","contract_type":2,"progress_updated_at":"2024-04-23 16:49:42.045576+08","forecast_updated_at":"2024-06-03 18:36:05.751511+08","end_at":"","pinyin_shortcut":"yqqtwbfw","creator":1005,"used_client":2724,"from_contact":"","total_contact_point":"","paid_contact_point":"","project_product_version_id":352,"is_sales_order_ready":true,"collected_plan":"120000","used_client_budget":"","invoiced":"0","uncollected":"0","uninvoiced":"0","overdue":"","status":2,"sort_date":"","client":{"id":2842,"key":2842,"name":"\u5317\u4eac\u79b9\u5b8f\u4fe1\u5b89\u79d1\u6280\u6709\u9650\u516c\u53f8\uff08\u8fc7\u5355\uff09"},"buildContract":{"id":3243,"from_project":3512,"serial_no":"TS-ZHY-2024041895"},"projectUsedClient":{"id":54,"project_id":3512,"used_client":2724,"budget":"","profit":"","profit_pct":"","collected_plan":"","remind_ahead":"","projectUsedClientPaymentCollectionRemindDates":[]},"collect_status_display":"\u672a\u5b8c\u6210","overdue_display":"","overdue_amount":"","remind_date":""}],"count":{"amount":"45984345","uncollected":"45984344.00","overdue":"120397"},"pagenation":{"totalcount":52,"thispage":1,"pagesize":20}},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}],"mod":0}', FALSE, '2025-07-05 14:07:47') RETURNING "id"
14:07:47.550traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
14:07:47.550traceyii\redis\Connection::executeCommandExecuting Redis Command: SET