6868c1afb4e26: POST https://beta.jinchangxiao.com/vue/analysis/sales-contract-list at 2025-07-05 02:09:51 pm by 223.72.35.175
Log Messages
总计64条数据
| Time | Level | Category | Message |
|---|---|---|---|
| 14:09:51.740 | trace | yii\base\Application::bootstrap | Bootstrap with yii\log\Dispatcher |
| 14:09:51.740 | trace | yii\base\Module::getModule | Loading module: debug |
| 14:09:51.740 | trace | yii\base\Application::bootstrap | Bootstrap with yii\debug\Module::bootstrap() |
| 14:09:51.741 | trace | yii\redis\Connection::open | Opening redis DB connection: redis.server.local:6379, database=1 |
| 14:09:51.741 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: SELECT |
| 14:09:51.741 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 14:09:51.741 | trace | yii\base\Module::getModule | Loading module: gii |
| 14:09:51.741 | trace | yii\base\Application::bootstrap | Bootstrap with yii\gii\Module::bootstrap() |
| 14:09:51.741 | trace | yii\web\UrlManager::parseRequest | No matching URL rules. Using default URL parsing logic. |
| 14:09:51.741 | trace | yii\web\Application::handleRequest | Route requested: 'vue/analysis/sales-contract-list' |
| 14:09:51.741 | trace | yii\base\Module::getModule | Loading module: vue |
| 14:09:51.742 | info | yii\web\Session::open | Session started |
| 14:09:51.742 | info | yii\db\Command::query | SELECT * FROM "global"."vw_user_login" WHERE "id"=5250 |
| 14:09:51.742 | info | yii\db\Connection::open | Opening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta |
| 14:09:51.746 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 14:09:51.747 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 14:09:51.747 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 14:09:51.747 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 14:09:51.747 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=5250 |
| 14:09:51.749 | trace | yii\base\Controller::runAction | Route to run: vue/analysis/sales-contract-list |
| 14:09:51.749 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 14:09:51.749 | trace | uranus\rbac\DbManager::checkAccessFromCache | Checking role: Admin |
| 14:09:51.750 | trace | yii\base\InlineAction::runWithParams | Running action: app\modules\vue\controllers\AnalysisController::actionSalesContractList() |
| 14:09:51.750 | info | yii\db\Command::query | SELECT COUNT(*) FROM (SELECT c.*, abs(c.expire_date - current_date) AS b_date, CASE WHEN c.expire_date IS NULL THEN 1 ELSE 2 END AS passed FROM "a57be577deb434"."tbl_sales_contracts" "c" LEFT JOIN "a57be577deb434"."tbl_clients" "client" ON client.id = c.client_id LEFT JOIN "a57be577deb434"."tbl_projects" "p" ON p.id = c.project_id LEFT JOIN "a57be577deb434"."tbl_sales_group_relationships" "sgr" ON sgr.sales_id = client.sales_rep LEFT JOIN (SELECT sc.id, CASE WHEN sc.including_tax = true and (SUM ( sci.amount ) < sc.amount OR SUM ( sci.amount ) IS NULL) THEN 0 ELSE 1 END as invoice_status, CASE WHEN SUM ( sci.amount ) > 0 THEN 1 ELSE 0 END as invoice_collected FROM "a57be577deb434"."tbl_sales_contracts" "sc" LEFT JOIN "a57be577deb434"."tbl_sales_contract_invoices" "sci" ON sc.id = sci.contract_id LEFT JOIN "a57be577deb434"."tbl_projects" "p" ON sc.project_id = p.id WHERE "p"."created_by" IN ('1001', '1004', '1005', '1013', '5087', '5295', '5300', '5311', '5329', '5332', '5420') GROUP BY "sc"."id") "sub" ON c.id = sub.id WHERE (c.need_analysis = true) AND ("p"."created_by" IN ('1001', '1004', '1005', '1013', '5087', '5295', '5300', '5311', '5329', '5332', '5420')) AND (sub.invoice_collected = 1) ORDER BY "c"."signed_at" DESC, "c"."created_at" DESC) "c" |
| 14:09:51.758 | info | yii\db\Command::query | SELECT c.*, abs(c.expire_date - current_date) AS b_date, CASE WHEN c.expire_date IS NULL THEN 1 ELSE 2 END AS passed FROM "a57be577deb434"."tbl_sales_contracts" "c" LEFT JOIN "a57be577deb434"."tbl_clients" "client" ON client.id = c.client_id LEFT JOIN "a57be577deb434"."tbl_projects" "p" ON p.id = c.project_id LEFT JOIN "a57be577deb434"."tbl_sales_group_relationships" "sgr" ON sgr.sales_id = client.sales_rep LEFT JOIN (SELECT sc.id, CASE WHEN sc.including_tax = true and (SUM ( sci.amount ) < sc.amount OR SUM ( sci.amount ) IS NULL) THEN 0 ELSE 1 END as invoice_status, CASE WHEN SUM ( sci.amount ) > 0 THEN 1 ELSE 0 END as invoice_collected FROM "a57be577deb434"."tbl_sales_contracts" "sc" LEFT JOIN "a57be577deb434"."tbl_sales_contract_invoices" "sci" ON sc.id = sci.contract_id LEFT JOIN "a57be577deb434"."tbl_projects" "p" ON sc.project_id = p.id WHERE "p"."created_by" IN ('1001', '1004', '1005', '1013', '5087', '5295', '5300', '5311', '5329', '5332', '5420') GROUP BY "sc"."id") "sub" ON c.id = sub.id WHERE (c.need_analysis = true) AND ("p"."created_by" IN ('1001', '1004', '1005', '1013', '5087', '5295', '5300', '5311', '5329', '5332', '5420')) AND (sub.invoice_collected = 1) ORDER BY "c"."signed_at" DESC, "c"."created_at" DESC LIMIT 20 |
| 14:09:51.765 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 14:09:51.765 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 14:09:51.765 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "name", "logo", "sales_rep" FROM "a57be577deb434"."tbl_clients" WHERE "id" IN (2736, 20, 531, 3326, 4, 518, 107, 48, 97, 12, 1301, 3327, 2182, 2616, 2021) |
| 14:09:51.766 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (5300, 1005, 5295, 5087, 1001, 1004, 5311) |
| 14:09:51.766 | info | yii\db\Command::query | SELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id" IN (1001, 5311, 5295, 1005, 5087, 1004, 5300)) |
| 14:09:51.767 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "project_title" AS "name" FROM "a57be577deb434"."tbl_projects" WHERE "id" IN (3793, 3792, 3791, 3769, 3789, 3788, 3777, 3776, 3774, 3775, 3773, 3761, 3762, 3768, 3767, 3745, 3766, 3765, 3764, 3763) |
| 14:09:51.768 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "type" AS "name" FROM "a57be577deb434"."tbl_contract_types" WHERE "id" IN (2, 1) |
| 14:09:51.768 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (5300, 1005, 5087, 5295, 1004, 1001) |
| 14:09:51.768 | info | yii\db\Command::query | SELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id" IN (1001, 5295, 1005, 5087, 1004, 5300)) |
| 14:09:51.769 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_departments" WHERE "id" IN (4, 1) |
| 14:09:51.769 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (5300, 1005, 5087, 5295, 1004, 1001) |
| 14:09:51.770 | info | yii\db\Command::query | SELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id" IN (1001, 5295, 1005, 5087, 1004, 5300)) |
| 14:09:51.770 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "contract_id", "remind_date" FROM "a57be577deb434"."tbl_service_contract_remind_dates" WHERE ("reminded"=FALSE) AND ("contract_id" IN (3822, 3812, 3811, 3770, 3809, 3805, 3808, 3783, 3787, 3782, 3778, 3777, 3771, 3767, 3763, 3761, 3759, 3758, 3755, 3749)) ORDER BY "remind_date" |
| 14:09:51.770 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "contract_id", "remind_date" AS "name" FROM "a57be577deb434"."tbl_service_contract_remind_dates" WHERE "contract_id" IN (3822, 3812, 3811, 3770, 3809, 3805, 3808, 3783, 3787, 3782, 3778, 3777, 3771, 3767, 3763, 3761, 3759, 3758, 3755, 3749) |
| 14:09:51.771 | info | yii\db\Command::query | SELECT "id", "user_id", "user_id" AS "key", "contract_id" FROM "a57be577deb434"."tbl_sales_contract_remind_receivers" WHERE "contract_id" IN (3822, 3812, 3811, 3770, 3809, 3805, 3808, 3783, 3787, 3782, 3778, 3777, 3771, 3767, 3763, 3761, 3759, 3758, 3755, 3749) |
| 14:09:51.772 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "name", "sex" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (5311, 5300, 5295) |
| 14:09:51.772 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_service_contract_remind_receivers" WHERE "contract_id" IN (3822, 3812, 3811, 3770, 3809, 3805, 3808, 3783, 3787, 3782, 3778, 3777, 3771, 3767, 3763, 3761, 3759, 3758, 3755, 3749) |
| 14:09:51.772 | info | yii\db\Command::query | SELECT "id", "user_id", "user_id" AS "key", "contract_id" FROM "a57be577deb434"."tbl_sales_contract_payment_collection_remind_receivers" WHERE "contract_id" IN (3822, 3812, 3811, 3770, 3809, 3805, 3808, 3783, 3787, 3782, 3778, 3777, 3771, 3767, 3763, 3761, 3759, 3758, 3755, 3749) |
| 14:09:51.773 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "name", "sex" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (5295, 1001, 1011, 5388, 1004, 5300, 5087, 1005) |
| 14:09:51.773 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "contract_id", "remind_date" AS "name", "amount" AS "value", "overdue_days" FROM "a57be577deb434"."tbl_sales_contract_payment_collection_remind_dates" WHERE "contract_id" IN (3822, 3812, 3811, 3770, 3809, 3805, 3808, 3783, 3787, 3782, 3778, 3777, 3771, 3767, 3763, 3761, 3759, 3758, 3755, 3749) ORDER BY "remind_date" |
| 14:09:51.774 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "contract_id", "amount" AS "value", "created_by" FROM "a57be577deb434"."tbl_sales_contract_payments" WHERE "contract_id" IN (3822, 3812, 3811, 3770, 3809, 3805, 3808, 3783, 3787, 3782, 3778, 3777, 3771, 3767, 3763, 3761, 3759, 3758, 3755, 3749) ORDER BY "id" |
| 14:09:51.775 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id"=1013 |
| 14:09:51.775 | info | yii\db\Command::query | SELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=1013) |
| 14:09:51.775 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "contract_id", "amount" AS "value", "attachment_id", "from_date", "created_by" FROM "a57be577deb434"."tbl_sales_contract_invoices" WHERE "contract_id" IN (3822, 3812, 3811, 3770, 3809, 3805, 3808, 3783, 3787, 3782, 3778, 3777, 3771, 3767, 3763, 3761, 3759, 3758, 3755, 3749) ORDER BY "id" |
| 14:09:51.776 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (5252, 5388, 5250) |
| 14:09:51.776 | info | yii\db\Command::query | SELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id" IN (5252, 5250, 5388)) |
| 14:09:51.777 | info | yii\db\Command::query | SELECT "object_id", count(*) AS comment FROM "a57be577deb434"."tbl_comments" WHERE ("object_type"=7) AND ("object_id" IN (3822, 3812, 3811, 3770, 3809, 3805, 3808, 3783, 3787, 3782, 3778, 3777, 3771, 3767, 3763, 3761, 3759, 3758, 3755, 3749)) GROUP BY "object_id" |
| 14:09:51.795 | info | yii\db\Command::query | SELECT "object_id", count(*) AS unread FROM "a57be577deb434"."tbl_unread_comments" WHERE ("object_type"=7) AND (remind_user_id = 5250 AND is_read = false) AND ("object_id" IN (3822, 3812, 3811, 3770, 3809, 3805, 3808, 3783, 3787, 3782, 3778, 3777, 3771, 3767, 3763, 3761, 3759, 3758, 3755, 3749)) GROUP BY "object_id" |
| 14:09:51.811 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 14:09:51.812 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 14:09:51.814 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 14:09:51.814 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 14:09:51.814 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_visit_module_histories" WHERE ("user_id"=5250) AND ("object_type"=23) AND ("visit_date"='2025-07-05') |
| 14:09:51.817 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 14:09:51.818 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 14:09:51.818 | info | yii\db\Command::execute | UPDATE "a57be577deb434"."tbl_visit_module_histories" SET "num"=194, "last_visit_at"='now()' WHERE "id"=49799 |
| 14:09:51.819 | info | yii\db\Command::query | INSERT INTO "global"."tbl_api_log" ("code", "schema", "user_id", "device_type", "url", "request", "response", "php_error", "time") VALUES (200, 'a57be577deb434', 5250, 5, 'vue/analysis/sales-contract-list', '{"dataUserId":"1001,1004,1005,1013,5087,5295,5300,5311,5329,5332,5420","is_invoice":"1","page":"1","web_access_token":"lF6lDSiCl5CRIFfE8shlx2wSeme229Hs"}', '{"code":2000,"result":{"list":[{"id":3822,"client_id":2736,"signed_at":"2025-03-10","amount":"2500","handler":5300,"description":"","created_by":5300,"created_at":"2025-03-10 10:17:21","updated_at":"2025-03-12 17:05:47","contract_scan":"","receipt_scan":"","contract_type":2,"project_id":3793,"valid_date":"","expire_date":"","sla":"","remind_ahead":"","expire_remind_ahead":"","expire_reminded":false,"serial_no":"","payment_collection_remind_ahead":"7 days","from_project":3793,"receipt_date":"","verify_date":"","including_tax":true,"build_by_project":true,"need_analysis":true,"is_settle":true,"is_deliver":true,"is_outbound":true,"is_save_collection":true,"save_collection_at":"2025-03-10 10:17:21.573991+08","b_date":"","passed":1,"client":{"id":2736,"key":2736,"name":"\u5317\u4eac\u4e2d\u6570\u521b\u65b0\u79d1\u6280\u80a1\u4efd\u6709\u9650\u516c\u53f8(\u7f51\u6839\u79d1\u6280\uff08\u5317\u4eac\uff09\u6709\u9650\u516c\u53f8)","logo":"","sales_rep":5300,"salesRep":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91","avatar":{"id":141,"user_id":5300,"name":"\/files\/cdn\/a57be577deb434\/avatar\/14dfd1a0-6df5-354a-8afd-f0a76fa8e852.png"}}},"project":{"id":3793,"key":3793,"name":"\u9632\u706b\u5899\u6545\u969c\u5904\u7f6e\u548c\u79df\u8d41-G-2025"},"contractScan":"","receiptScan":"","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"}},"handleBy":{"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"}},"remindDate":"","serviceContractRemindDates":[],"salesContractRemindReceivers":[],"serviceContractRemindReceivers":[],"salesContractPaymentCollectionRemindReceivers":[{"id":8038,"user_id":5300,"key":5300,"contract_id":3822,"user":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91","sex":"F"}},{"id":8039,"user_id":5388,"key":5388,"contract_id":3822,"user":{"id":5388,"key":5388,"name":"\u6768\u71d5\u971e","sex":"F"}},{"id":8040,"user_id":1001,"key":1001,"contract_id":3822,"user":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M"}}],"salesContractPaymentCollectionRemindDates":[{"id":2357,"key":2357,"contract_id":3822,"name":"2025-04-21","value":"2500","overdue_days":""}],"salesContractPayments":[],"salesContractInvoices":[{"id":1973,"key":1973,"contract_id":3822,"value":"2500.00","attachment_id":"","from_date":"2025-03-10","created_by":5252,"createdBy":{"id":5252,"key":5252,"name":"\u738b\u7b11\u7b11","sex":"F","department_id":6,"avatar":{"id":101,"user_id":5252,"name":"\/files\/cdn\/a57be577deb434\/avatar\/f5529321-408e-3d11-aa95-9b0a384f2d9c.png"}},"attachment":{}},{"id":1987,"key":1987,"contract_id":3822,"value":"1.00","attachment_id":"","from_date":"2025-05-22","created_by":5250,"createdBy":{"id":5250,"key":5250,"name":"\u8463\u8363","sex":"M","department_id":10,"avatar":{"id":157,"user_id":5250,"name":"\/files\/cdn\/a57be577deb434\/avatar\/10f9a0d9-7ea7-3910-9465-6ece76a0dae4.png"}},"attachment":{}}],"commentCount":{"object_id":3822,"comment":7},"unreadComments":{},"remind_date":"","remind_ahead_display":"\u65e0","expire_remind_ahead_display":"\u65e0","unread":0,"bgcolor":"#89c541","can_update":true,"can_delete":false},{"id":3812,"client_id":20,"signed_at":"2025-03-06","amount":"500","handler":1005,"description":"","created_by":1005,"created_at":"2025-03-06 09:01:21","updated_at":"2025-03-14 15:15:11","contract_scan":"","receipt_scan":"","contract_type":1,"project_id":3792,"valid_date":"","expire_date":"2026-03-04","sla":"","remind_ahead":"","expire_remind_ahead":"","expire_reminded":false,"serial_no":"","payment_collection_remind_ahead":"00:00:00","from_project":3792,"receipt_date":"","verify_date":"","including_tax":true,"build_by_project":true,"need_analysis":true,"is_settle":true,"is_deliver":true,"is_outbound":true,"is_save_collection":false,"save_collection_at":"","b_date":242,"passed":2,"client":{"id":20,"key":20,"name":"\u4e2d\u56fd\u91cd\u578b\u673a\u68b0\u6709\u9650\u516c\u53f8\u3001\u56fd\u673a\u91cd\u578b\u88c5\u5907(\u67ec\u57d4\u5be8\u8fbe\u5cb1\u6c34\u7535\u6709\u9650\u516c\u53f8)","logo":"","sales_rep":1005,"salesRep":{"id":1005,"key":1005,"name":"\u8d75\u6657\u7131","avatar":{"id":16,"user_id":1005,"name":"\/files\/cdn\/a57be577deb434\/avatar\/56876dde-37eb-39fc-853a-47eaef6510e5.png"}}},"project":{"id":3792,"key":3792,"name":"IBM\u7535\u6e90\u66f4\u6362"},"contractScan":"","receiptScan":"","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"}},"handleBy":{"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"}},"remindDate":"","serviceContractRemindDates":[],"salesContractRemindReceivers":[],"serviceContractRemindReceivers":[],"salesContractPaymentCollectionRemindReceivers":[{"id":8008,"user_id":1005,"key":1005,"contract_id":3812,"user":{"id":1005,"key":1005,"name":"\u8d75\u6657\u7131","sex":"F"}}],"salesContractPaymentCollectionRemindDates":[{"id":2354,"key":2354,"contract_id":3812,"name":"2025-04-06","value":"500","overdue_days":""}],"salesContractPayments":[],"salesContractInvoices":[{"id":1965,"key":1965,"contract_id":3812,"value":"500.00","attachment_id":"","from_date":"2025-03-06","created_by":5388,"createdBy":{"id":5388,"key":5388,"name":"\u6768\u71d5\u971e","sex":"F","department_id":6,"avatar":{"id":156,"user_id":5388,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b8d4f68f-e736-3c38-9e2f-1ab47885b3d8.png"}},"attachment":{}}],"commentCount":{"object_id":3812,"comment":8},"unreadComments":{},"remind_date":"","remind_ahead_display":"\u65e0","expire_remind_ahead_display":"\u65e0","unread":0,"bgcolor":"#89c541","can_update":true,"can_delete":false},{"id":3811,"client_id":531,"signed_at":"2025-03-05","amount":"3150","handler":5300,"description":"","created_by":5300,"created_at":"2025-03-05 17:28:13","updated_at":"2025-03-12 13:59:08","contract_scan":"","receipt_scan":"","contract_type":1,"project_id":3791,"valid_date":"","expire_date":"","sla":"","remind_ahead":"","expire_remind_ahead":"","expire_reminded":false,"serial_no":"TS-SQY-20250305001","payment_collection_remind_ahead":"00:00:00","from_project":3791,"receipt_date":"","verify_date":"","including_tax":true,"build_by_project":true,"need_analysis":true,"is_settle":true,"is_deliver":true,"is_outbound":true,"is_save_collection":true,"save_collection_at":"2025-03-05 17:28:35.841072+08","b_date":"","passed":1,"client":{"id":531,"key":531,"name":"\u5317\u4eac\u9996\u4e1c\u7269\u4e1a\u7ba1\u7406\u6709\u9650\u516c\u53f8(\u9996\u4e1c\u56fd\u9645\u6295\u8d44\u6709\u9650\u516c\u53f8)","logo":"","sales_rep":5311,"salesRep":{"id":5311,"key":5311,"name":"\u62d3\u5c0f\u6587","avatar":{"id":149,"user_id":5311,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1a32eee2-9465-3c88-9077-5c6d1cc5e8b3.jpg"}}},"project":{"id":3791,"key":3791,"name":"\u786c\u76d81.8T1\u5757-K-2025"},"contractScan":"","receiptScan":"","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"}},"handleBy":{"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"}},"remindDate":"","serviceContractRemindDates":[],"salesContractRemindReceivers":[{"id":8353,"user_id":5311,"key":5311,"contract_id":3811,"user":{"id":5311,"key":5311,"name":"\u62d3\u5c0f\u6587","sex":"F"}}],"serviceContractRemindReceivers":[],"salesContractPaymentCollectionRemindReceivers":[{"id":8032,"user_id":5300,"key":5300,"contract_id":3811,"user":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91","sex":"F"}},{"id":8033,"user_id":5388,"key":5388,"contract_id":3811,"user":{"id":5388,"key":5388,"name":"\u6768\u71d5\u971e","sex":"F"}},{"id":8034,"user_id":1001,"key":1001,"contract_id":3811,"user":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M"}}],"salesContractPaymentCollectionRemindDates":[{"id":2353,"key":2353,"contract_id":3811,"name":"2025-03-21","value":"3150","overdue_days":""}],"salesContractPayments":[{"id":2131,"key":2131,"contract_id":3811,"value":"3150","created_by":1013,"createdBy":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","department_id":7,"avatar":{"id":34,"user_id":1013,"name":"\/files\/cdn\/a57be577deb434\/avatar\/25ef1fe7-8dda-3daa-b8ea-9fabd0a47439.png"}}}],"salesContractInvoices":[{"id":1971,"key":1971,"contract_id":3811,"value":"3150.00","attachment_id":"","from_date":"2025-03-07","created_by":5252,"createdBy":{"id":5252,"key":5252,"name":"\u738b\u7b11\u7b11","sex":"F","department_id":6,"avatar":{"id":101,"user_id":5252,"name":"\/files\/cdn\/a57be577deb434\/avatar\/f5529321-408e-3d11-aa95-9b0a384f2d9c.png"}},"attachment":{}},{"id":1978,"key":1978,"contract_id":3811,"value":"-3150.00","attachment_id":"","from_date":"2025-03-14","created_by":5252,"createdBy":{"id":5252,"key":5252,"name":"\u738b\u7b11\u7b11","sex":"F","department_id":6,"avatar":{"id":101,"user_id":5252,"name":"\/files\/cdn\/a57be577deb434\/avatar\/f5529321-408e-3d11-aa95-9b0a384f2d9c.png"}},"attachment":{}},{"id":1979,"key":1979,"contract_id":3811,"value":"3150.00","attachment_id":"","from_date":"2025-03-14","created_by":5252,"createdBy":{"id":5252,"key":5252,"name":"\u738b\u7b11\u7b11","sex":"F","department_id":6,"avatar":{"id":101,"user_id":5252,"name":"\/files\/cdn\/a57be577deb434\/avatar\/f5529321-408e-3d11-aa95-9b0a384f2d9c.png"}},"attachment":{}}],"commentCount":{"object_id":3811,"comment":8},"unreadComments":{},"remind_date":"","remind_ahead_display":"\u65e0","expire_remind_ahead_display":"\u65e0","unread":0,"bgcolor":"#89c541","can_update":true,"can_delete":false},{"id":3770,"client_id":3326,"signed_at":"2025-03-05","amount":"32000","handler":5087,"description":"","created_by":5087,"created_at":"2025-01-21 15:45:01","updated_at":"2025-03-06 09:23:53","contract_scan":"","receipt_scan":"","contract_type":1,"project_id":3769,"valid_date":"","expire_date":"","sla":"","remind_ahead":"","expire_remind_ahead":"","expire_reminded":false,"serial_no":"TS-LW-20250305001","payment_collection_remind_ahead":"1 day","from_project":3769,"receipt_date":"","verify_date":"","including_tax":true,"build_by_project":true,"need_analysis":true,"is_settle":true,"is_deliver":true,"is_outbound":true,"is_save_collection":true,"save_collection_at":"2025-01-21 16:22:12.892494+08","b_date":"","passed":1,"client":{"id":3326,"key":3326,"name":"\u4fdd\u5b9a\u6c90\u69ff\u7f51\u7edc\u79d1\u6280\u6709\u9650\u516c\u53f8\uff08304\u8fc7\u5355\uff09","logo":"","sales_rep":5087,"salesRep":{"id":5087,"key":5087,"name":"\u5218\u5fae","avatar":{"id":62,"user_id":5087,"name":"\/files\/cdn\/a57be577deb434\/avatar\/06f75b3a-7b6c-37a8-81c0-b2934104daa7.png"}}},"project":{"id":3769,"key":3769,"name":"\u897f\u660c\u7f51\u5173-\u589e\u52a0\u670d\u52a1\u8d39"},"contractScan":"","receiptScan":"","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"}},"handleBy":{"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"}},"remindDate":"","serviceContractRemindDates":[],"salesContractRemindReceivers":[],"serviceContractRemindReceivers":[],"salesContractPaymentCollectionRemindReceivers":[{"id":7982,"user_id":5087,"key":5087,"contract_id":3770,"user":{"id":5087,"key":5087,"name":"\u5218\u5fae","sex":"F"}},{"id":7983,"user_id":5388,"key":5388,"contract_id":3770,"user":{"id":5388,"key":5388,"name":"\u6768\u71d5\u971e","sex":"F"}},{"id":7984,"user_id":1001,"key":1001,"contract_id":3770,"user":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M"}}],"salesContractPaymentCollectionRemindDates":[{"id":2325,"key":2325,"contract_id":3770,"name":"2025-04-30","value":"32000","overdue_days":""}],"salesContractPayments":[{"id":2104,"key":2104,"contract_id":3770,"value":"32000","created_by":1013,"createdBy":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","department_id":7,"avatar":{"id":34,"user_id":1013,"name":"\/files\/cdn\/a57be577deb434\/avatar\/25ef1fe7-8dda-3daa-b8ea-9fabd0a47439.png"}}}],"salesContractInvoices":[{"id":1945,"key":1945,"contract_id":3770,"value":"32000.00","attachment_id":"","from_date":"2025-01-21","created_by":5252,"createdBy":{"id":5252,"key":5252,"name":"\u738b\u7b11\u7b11","sex":"F","department_id":6,"avatar":{"id":101,"user_id":5252,"name":"\/files\/cdn\/a57be577deb434\/avatar\/f5529321-408e-3d11-aa95-9b0a384f2d9c.png"}},"attachment":{}}],"commentCount":{"object_id":3770,"comment":8},"unreadComments":{},"remind_date":"","remind_ahead_display":"\u65e0","expire_remind_ahead_display":"\u65e0","unread":0,"bgcolor":"#89c541","can_update":true,"can_delete":false},{"id":3809,"client_id":4,"signed_at":"2025-03-04","amount":"1700","handler":5300,"description":"","created_by":5300,"created_at":"2025-03-05 14:27:35","updated_at":"2025-03-14 15:19:55","contract_scan":"","receipt_scan":"","contract_type":1,"project_id":3789,"valid_date":"","expire_date":"","sla":"","remind_ahead":"","expire_remind_ahead":"","expire_reminded":false,"serial_no":"TS-SQY-20250304002","payment_collection_remind_ahead":"1 day","from_project":3789,"receipt_date":"","verify_date":"","including_tax":true,"build_by_project":true,"need_analysis":true,"is_settle":true,"is_deliver":true,"is_outbound":true,"is_save_collection":true,"save_collection_at":"2025-06-11 11:23:01.426167+08","b_date":"","passed":1,"client":{"id":4,"key":4,"name":"\u6cb3\u5317\u9ad8\u7891\u5e97\u5e02\u5b9c\u4f73\u65fa\u5546\u8d38\u6709\u9650\u516c\u53f8\/\u6cb3\u5317\u5c1a\u548c\u5546\u8d38\u6709\u9650\u516c\u53f8","logo":"","sales_rep":5300,"salesRep":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91","avatar":{"id":141,"user_id":5300,"name":"\/files\/cdn\/a57be577deb434\/avatar\/14dfd1a0-6df5-354a-8afd-f0a76fa8e852.png"}}},"project":{"id":3789,"key":3789,"name":"\u7535\u6e90-netapp-FAS2240-2\u5757-G-2025"},"contractScan":"","receiptScan":"","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"}},"handleBy":{"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"}},"remindDate":"","serviceContractRemindDates":[],"salesContractRemindReceivers":[],"serviceContractRemindReceivers":[],"salesContractPaymentCollectionRemindReceivers":[{"id":8179,"user_id":5300,"key":5300,"contract_id":3809,"user":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91","sex":"F"}},{"id":8180,"user_id":5388,"key":5388,"contract_id":3809,"user":{"id":5388,"key":5388,"name":"\u6768\u71d5\u971e","sex":"F"}},{"id":8181,"user_id":1001,"key":1001,"contract_id":3809,"user":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M"}}],"salesContractPaymentCollectionRemindDates":[{"id":2395,"key":2395,"contract_id":3809,"name":"2025-04-05","value":"22","overdue_days":""}],"salesContractPayments":[{"id":2126,"key":2126,"contract_id":3809,"value":"1700","created_by":1013,"createdBy":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","department_id":7,"avatar":{"id":34,"user_id":1013,"name":"\/files\/cdn\/a57be577deb434\/avatar\/25ef1fe7-8dda-3daa-b8ea-9fabd0a47439.png"}}}],"salesContractInvoices":[{"id":1966,"key":1966,"contract_id":3809,"value":"1700.00","attachment_id":"","from_date":"2025-03-06","created_by":5388,"createdBy":{"id":5388,"key":5388,"name":"\u6768\u71d5\u971e","sex":"F","department_id":6,"avatar":{"id":156,"user_id":5388,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b8d4f68f-e736-3c38-9e2f-1ab47885b3d8.png"}},"attachment":{}},{"id":1967,"key":1967,"contract_id":3809,"value":"-1700.00","attachment_id":"","from_date":"2025-03-06","created_by":5388,"createdBy":{"id":5388,"key":5388,"name":"\u6768\u71d5\u971e","sex":"F","department_id":6,"avatar":{"id":156,"user_id":5388,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b8d4f68f-e736-3c38-9e2f-1ab47885b3d8.png"}},"attachment":{}},{"id":1970,"key":1970,"contract_id":3809,"value":"1700.00","attachment_id":"","from_date":"2025-03-06","created_by":5388,"createdBy":{"id":5388,"key":5388,"name":"\u6768\u71d5\u971e","sex":"F","department_id":6,"avatar":{"id":156,"user_id":5388,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b8d4f68f-e736-3c38-9e2f-1ab47885b3d8.png"}},"attachment":{}}],"commentCount":{"object_id":3809,"comment":13},"unreadComments":{},"remind_date":"","remind_ahead_display":"\u65e0","expire_remind_ahead_display":"\u65e0","unread":0,"bgcolor":"#89c541","can_update":true,"can_delete":false},{"id":3805,"client_id":518,"signed_at":"2025-03-03","amount":"1200","handler":5295,"description":"","created_by":5295,"created_at":"2025-03-03 17:13:54","updated_at":"2025-03-05 09:27:13","contract_scan":"","receipt_scan":"","contract_type":1,"project_id":3788,"valid_date":"","expire_date":"","sla":"","remind_ahead":"","expire_remind_ahead":"","expire_reminded":false,"serial_no":"","payment_collection_remind_ahead":"00:00:00","from_project":3788,"receipt_date":"","verify_date":"","including_tax":true,"build_by_project":true,"need_analysis":true,"is_settle":true,"is_deliver":true,"is_outbound":true,"is_save_collection":true,"save_collection_at":"2025-03-03 17:13:54.915446+08","b_date":"","passed":1,"client":{"id":518,"key":518,"name":"\u5317\u4eac\u56fd\u79d1\u73af\u5b87\u79d1\u6280\u80a1\u4efd\u6709\u9650\u516c\u53f8\uff08EDA)\/\u53a6\u95e8\u6cc9\u7f51\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8","logo":"","sales_rep":5295,"salesRep":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"}}},"project":{"id":3788,"key":3788,"name":"\u65b0\u8d2d\u670d\u52a1\u5668\u786c\u76d8"},"contractScan":"","receiptScan":"","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"}},"handleBy":{"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"}},"remindDate":"","serviceContractRemindDates":[],"salesContractRemindReceivers":[],"serviceContractRemindReceivers":[],"salesContractPaymentCollectionRemindReceivers":[],"salesContractPaymentCollectionRemindDates":[{"id":2348,"key":2348,"contract_id":3805,"name":"2025-04-30","value":"1200","overdue_days":""}],"salesContractPayments":[],"salesContractInvoices":[{"id":1977,"key":1977,"contract_id":3805,"value":"1200.00","attachment_id":"","from_date":"2025-03-11","created_by":5252,"createdBy":{"id":5252,"key":5252,"name":"\u738b\u7b11\u7b11","sex":"F","department_id":6,"avatar":{"id":101,"user_id":5252,"name":"\/files\/cdn\/a57be577deb434\/avatar\/f5529321-408e-3d11-aa95-9b0a384f2d9c.png"}},"attachment":{}}],"commentCount":{"object_id":3805,"comment":5},"unreadComments":{},"remind_date":"","remind_ahead_display":"\u65e0","expire_remind_ahead_display":"\u65e0","unread":0,"bgcolor":"#89c541","can_update":true,"can_delete":false},{"id":3808,"client_id":107,"signed_at":"2025-02-20","amount":"35100","handler":5295,"description":"","created_by":5295,"created_at":"2025-03-05 10:04:42","updated_at":"2025-03-14 17:31:54","contract_scan":"","receipt_scan":"","contract_type":1,"project_id":3777,"valid_date":"","expire_date":"","sla":"","remind_ahead":"","expire_remind_ahead":"","expire_reminded":false,"serial_no":"TS-WZW-20250220001","payment_collection_remind_ahead":"00:00:00","from_project":3777,"receipt_date":"","verify_date":"","including_tax":true,"build_by_project":true,"need_analysis":true,"is_settle":true,"is_deliver":true,"is_outbound":true,"is_save_collection":true,"save_collection_at":"2025-03-10 13:48:08.764799+08","b_date":"","passed":1,"client":{"id":107,"key":107,"name":"\u84dd\u661f\u4e1c\u4e3d\u819c\u79d1\u6280(\u5317\u4eac)\u6709\u9650\u516c\u53f8","logo":"","sales_rep":5295,"salesRep":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"}}},"project":{"id":3777,"key":3777,"name":"2025\u65b0\u8d2d\u6df1\u4fe1\u670dEDR-K"},"contractScan":"","receiptScan":"","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"}},"handleBy":{"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"}},"remindDate":"","serviceContractRemindDates":[],"salesContractRemindReceivers":[],"serviceContractRemindReceivers":[],"salesContractPaymentCollectionRemindReceivers":[{"id":8050,"user_id":5295,"key":5295,"contract_id":3808,"user":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F"}}],"salesContractPaymentCollectionRemindDates":[{"id":2358,"key":2358,"contract_id":3808,"name":"2025-04-15","value":"35100","overdue_days":""}],"salesContractPayments":[{"id":2125,"key":2125,"contract_id":3808,"value":"35100","created_by":1013,"createdBy":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","department_id":7,"avatar":{"id":34,"user_id":1013,"name":"\/files\/cdn\/a57be577deb434\/avatar\/25ef1fe7-8dda-3daa-b8ea-9fabd0a47439.png"}}}],"salesContractInvoices":[{"id":1982,"key":1982,"contract_id":3808,"value":"35100.00","attachment_id":"","from_date":"2025-03-17","created_by":5252,"createdBy":{"id":5252,"key":5252,"name":"\u738b\u7b11\u7b11","sex":"F","department_id":6,"avatar":{"id":101,"user_id":5252,"name":"\/files\/cdn\/a57be577deb434\/avatar\/f5529321-408e-3d11-aa95-9b0a384f2d9c.png"}},"attachment":{}}],"commentCount":{"object_id":3808,"comment":7},"unreadComments":{},"remind_date":"","remind_ahead_display":"\u65e0","expire_remind_ahead_display":"\u65e0","unread":0,"bgcolor":"#89c541","can_update":true,"can_delete":false},{"id":3783,"client_id":48,"signed_at":"2025-02-17","amount":"3200","handler":1004,"description":"","created_by":1004,"created_at":"2025-02-12 21:12:33","updated_at":"2025-02-26 11:10:55","contract_scan":"","receipt_scan":"","contract_type":1,"project_id":3776,"valid_date":"","expire_date":"","sla":"","remind_ahead":"","expire_remind_ahead":"","expire_reminded":false,"serial_no":"TS-YJC-20250217001","payment_collection_remind_ahead":"1 day","from_project":3776,"receipt_date":"","verify_date":"","including_tax":true,"build_by_project":true,"need_analysis":true,"is_settle":true,"is_deliver":true,"is_outbound":true,"is_save_collection":true,"save_collection_at":"2025-02-12 21:12:33.077668+08","b_date":"","passed":1,"client":{"id":48,"key":48,"name":"\u4e2d\u90fd\u7269\u6d41\u6709\u9650\u516c\u53f8","logo":"","sales_rep":1004,"salesRep":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0","avatar":{"id":10,"user_id":1004,"name":"\/files\/cdn\/a57be577deb434\/avatar\/fc8d836d-8085-35fc-8a48-54a276f664a6.png"}}},"project":{"id":3776,"key":3776,"name":"\u7ea2\u886b\u5b58\u50a8\u786c\u76d8"},"contractScan":"","receiptScan":"","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\/fc8d836d-8085-35fc-8a48-54a276f664a6.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"handleBy":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0","sex":"M","department_id":1,"avatar":{"id":10,"user_id":1004,"name":"\/files\/cdn\/a57be577deb434\/avatar\/fc8d836d-8085-35fc-8a48-54a276f664a6.png"}},"remindDate":"","serviceContractRemindDates":[],"salesContractRemindReceivers":[],"serviceContractRemindReceivers":[],"salesContractPaymentCollectionRemindReceivers":[{"id":7912,"user_id":1004,"key":1004,"contract_id":3783,"user":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0","sex":"M"}}],"salesContractPaymentCollectionRemindDates":[{"id":2334,"key":2334,"contract_id":3783,"name":"2025-03-31","value":"3200","overdue_days":""}],"salesContractPayments":[{"id":2116,"key":2116,"contract_id":3783,"value":"3200","created_by":1013,"createdBy":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","department_id":7,"avatar":{"id":34,"user_id":1013,"name":"\/files\/cdn\/a57be577deb434\/avatar\/25ef1fe7-8dda-3daa-b8ea-9fabd0a47439.png"}}}],"salesContractInvoices":[{"id":1952,"key":1952,"contract_id":3783,"value":"3200.00","attachment_id":"","from_date":"2025-02-18","created_by":5252,"createdBy":{"id":5252,"key":5252,"name":"\u738b\u7b11\u7b11","sex":"F","department_id":6,"avatar":{"id":101,"user_id":5252,"name":"\/files\/cdn\/a57be577deb434\/avatar\/f5529321-408e-3d11-aa95-9b0a384f2d9c.png"}},"attachment":{}}],"commentCount":{"object_id":3783,"comment":9},"unreadComments":{},"remind_date":"","remind_ahead_display":"\u65e0","expire_remind_ahead_display":"\u65e0","unread":0,"bgcolor":"#89c541","can_update":true,"can_delete":false},{"id":3787,"client_id":97,"signed_at":"2025-02-11","amount":"1000","handler":5300,"description":"","created_by":5300,"created_at":"2025-02-17 11:26:46","updated_at":"2025-03-06 09:21:26","contract_scan":"","receipt_scan":"","contract_type":2,"project_id":3774,"valid_date":"","expire_date":"","sla":"","remind_ahead":"","expire_remind_ahead":"","expire_reminded":false,"serial_no":"TS-SQY-20250211001","payment_collection_remind_ahead":"1 day","from_project":3774,"receipt_date":"","verify_date":"","including_tax":true,"build_by_project":true,"need_analysis":true,"is_settle":true,"is_deliver":true,"is_outbound":true,"is_save_collection":true,"save_collection_at":"2025-04-19 20:15:21.693887+08","b_date":"","passed":1,"client":{"id":97,"key":97,"name":"\u534e\u745e\u4e16\u7eaa\u63a7\u80a1\u96c6\u56e2\u6709\u9650\u516c\u53f8(\u5c71\u897f\u534e\u745e\u7164\u4e1a\u6709\u9650\u516c\u53f8)","logo":"","sales_rep":5300,"salesRep":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91","avatar":{"id":141,"user_id":5300,"name":"\/files\/cdn\/a57be577deb434\/avatar\/14dfd1a0-6df5-354a-8afd-f0a76fa8e852.png"}}},"project":{"id":3774,"key":3774,"name":"\u6280\u672f\u670d\u52a11\u6b21-G-2025-\u6d4b"},"contractScan":"","receiptScan":"","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"}},"handleBy":{"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"}},"remindDate":"","serviceContractRemindDates":[],"salesContractRemindReceivers":[],"serviceContractRemindReceivers":[],"salesContractPaymentCollectionRemindReceivers":[{"id":7976,"user_id":5300,"key":5300,"contract_id":3787,"user":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91","sex":"F"}},{"id":7977,"user_id":5388,"key":5388,"contract_id":3787,"user":{"id":5388,"key":5388,"name":"\u6768\u71d5\u971e","sex":"F"}},{"id":7978,"user_id":1001,"key":1001,"contract_id":3787,"user":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M"}}],"salesContractPaymentCollectionRemindDates":[{"id":2370,"key":2370,"contract_id":3787,"name":"2025-02-21","value":"1000","overdue_days":""}],"salesContractPayments":[{"id":2109,"key":2109,"contract_id":3787,"value":"1000","created_by":1013,"createdBy":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","department_id":7,"avatar":{"id":34,"user_id":1013,"name":"\/files\/cdn\/a57be577deb434\/avatar\/25ef1fe7-8dda-3daa-b8ea-9fabd0a47439.png"}}}],"salesContractInvoices":[{"id":1972,"key":1972,"contract_id":3787,"value":"1000.00","attachment_id":"","from_date":"2025-03-07","created_by":5252,"createdBy":{"id":5252,"key":5252,"name":"\u738b\u7b11\u7b11","sex":"F","department_id":6,"avatar":{"id":101,"user_id":5252,"name":"\/files\/cdn\/a57be577deb434\/avatar\/f5529321-408e-3d11-aa95-9b0a384f2d9c.png"}},"attachment":{}}],"commentCount":{"object_id":3787,"comment":6},"unreadComments":{},"remind_date":"","remind_ahead_display":"\u65e0","expire_remind_ahead_display":"\u65e0","unread":0,"bgcolor":"#89c541","can_update":true,"can_delete":false},{"id":3782,"client_id":12,"signed_at":"2025-02-11","amount":"556","handler":5300,"description":"","created_by":5300,"created_at":"2025-02-11 17:41:17","updated_at":"2025-02-17 09:24:55","contract_scan":"","receipt_scan":"","contract_type":1,"project_id":3775,"valid_date":"","expire_date":"2026-02-11","sla":"","remind_ahead":"","expire_remind_ahead":"","expire_reminded":false,"serial_no":"SMC\u5929\u6d25\u8ba2\u5355POTJ25021715","payment_collection_remind_ahead":"7 days","from_project":3775,"receipt_date":"","verify_date":"","including_tax":true,"build_by_project":true,"need_analysis":true,"is_settle":true,"is_deliver":true,"is_outbound":true,"is_save_collection":true,"save_collection_at":"2025-02-11 17:41:17.498824+08","b_date":221,"passed":2,"client":{"id":12,"key":12,"name":"smc(\u4e2d\u56fd)\u6709\u9650\u516c\u53f8\/SMC(\u5317\u4eac)\u5236\u9020\u6709\u9650\u516c\u53f8","logo":"","sales_rep":5300,"salesRep":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91","avatar":{"id":141,"user_id":5300,"name":"\/files\/cdn\/a57be577deb434\/avatar\/14dfd1a0-6df5-354a-8afd-f0a76fa8e852.png"}}},"project":{"id":3775,"key":3775,"name":"POTJ25021715-\u7535\u6e90\u9644\u4ef6-G-2025"},"contractScan":"","receiptScan":"","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"}},"handleBy":{"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"}},"remindDate":"","serviceContractRemindDates":[],"salesContractRemindReceivers":[],"serviceContractRemindReceivers":[],"salesContractPaymentCollectionRemindReceivers":[{"id":7865,"user_id":5300,"key":5300,"contract_id":3782,"user":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91","sex":"F"}},{"id":7866,"user_id":5388,"key":5388,"contract_id":3782,"user":{"id":5388,"key":5388,"name":"\u6768\u71d5\u971e","sex":"F"}},{"id":7867,"user_id":1001,"key":1001,"contract_id":3782,"user":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M"}}],"salesContractPaymentCollectionRemindDates":[{"id":2330,"key":2330,"contract_id":3782,"name":"2025-03-21","value":"556","overdue_days":""}],"salesContractPayments":[{"id":2122,"key":2122,"contract_id":3782,"value":"556","created_by":1013,"createdBy":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","department_id":7,"avatar":{"id":34,"user_id":1013,"name":"\/files\/cdn\/a57be577deb434\/avatar\/25ef1fe7-8dda-3daa-b8ea-9fabd0a47439.png"}}}],"salesContractInvoices":[{"id":1962,"key":1962,"contract_id":3782,"value":"556.00","attachment_id":"","from_date":"2025-02-24","created_by":5252,"createdBy":{"id":5252,"key":5252,"name":"\u738b\u7b11\u7b11","sex":"F","department_id":6,"avatar":{"id":101,"user_id":5252,"name":"\/files\/cdn\/a57be577deb434\/avatar\/f5529321-408e-3d11-aa95-9b0a384f2d9c.png"}},"attachment":{}}],"commentCount":{"object_id":3782,"comment":9},"unreadComments":{},"remind_date":"","remind_ahead_display":"\u65e0","expire_remind_ahead_display":"\u65e0","unread":0,"bgcolor":"#89c541","can_update":true,"can_delete":false},{"id":3778,"client_id":12,"signed_at":"2025-02-10","amount":"1533","handler":5300,"description":"","created_by":5300,"created_at":"2025-02-10 13:26:03","updated_at":"2025-02-14 09:23:33","contract_scan":"","receipt_scan":"","contract_type":1,"project_id":3773,"valid_date":"","expire_date":"","sla":"","remind_ahead":"","expire_remind_ahead":"","expire_reminded":false,"serial_no":"SMC\u5317\u4eac\u8ba2\u5355POBJ25020936","payment_collection_remind_ahead":"2 days","from_project":3773,"receipt_date":"","verify_date":"","including_tax":true,"build_by_project":true,"need_analysis":true,"is_settle":true,"is_deliver":true,"is_outbound":true,"is_save_collection":true,"save_collection_at":"2025-02-12 09:17:18.205821+08","b_date":"","passed":1,"client":{"id":12,"key":12,"name":"smc(\u4e2d\u56fd)\u6709\u9650\u516c\u53f8\/SMC(\u5317\u4eac)\u5236\u9020\u6709\u9650\u516c\u53f8","logo":"","sales_rep":5300,"salesRep":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91","avatar":{"id":141,"user_id":5300,"name":"\/files\/cdn\/a57be577deb434\/avatar\/14dfd1a0-6df5-354a-8afd-f0a76fa8e852.png"}}},"project":{"id":3773,"key":3773,"name":"POBJ25020936-\u56fa\u6001\u786c\u76d8-G-2025"},"contractScan":"","receiptScan":"","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"}},"handleBy":{"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"}},"remindDate":"","serviceContractRemindDates":[],"salesContractRemindReceivers":[],"serviceContractRemindReceivers":[],"salesContractPaymentCollectionRemindReceivers":[{"id":7868,"user_id":5300,"key":5300,"contract_id":3778,"user":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91","sex":"F"}},{"id":7869,"user_id":5388,"key":5388,"contract_id":3778,"user":{"id":5388,"key":5388,"name":"\u6768\u71d5\u971e","sex":"F"}},{"id":7870,"user_id":1001,"key":1001,"contract_id":3778,"user":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M"}}],"salesContractPaymentCollectionRemindDates":[{"id":2333,"key":2333,"contract_id":3778,"name":"2025-03-14","value":"1533","overdue_days":""}],"salesContractPayments":[{"id":2121,"key":2121,"contract_id":3778,"value":"1533","created_by":1013,"createdBy":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","department_id":7,"avatar":{"id":34,"user_id":1013,"name":"\/files\/cdn\/a57be577deb434\/avatar\/25ef1fe7-8dda-3daa-b8ea-9fabd0a47439.png"}}}],"salesContractInvoices":[{"id":1959,"key":1959,"contract_id":3778,"value":"1533.00","attachment_id":"","from_date":"2025-02-24","created_by":5252,"createdBy":{"id":5252,"key":5252,"name":"\u738b\u7b11\u7b11","sex":"F","department_id":6,"avatar":{"id":101,"user_id":5252,"name":"\/files\/cdn\/a57be577deb434\/avatar\/f5529321-408e-3d11-aa95-9b0a384f2d9c.png"}},"attachment":{}}],"commentCount":{"object_id":3778,"comment":8},"unreadComments":{},"remind_date":"","remind_ahead_display":"\u65e0","expire_remind_ahead_display":"\u65e0","unread":0,"bgcolor":"#89c541","can_update":true,"can_delete":false},{"id":3777,"client_id":107,"signed_at":"2025-02-10","amount":"30000","handler":5295,"description":"","created_by":5295,"created_at":"2025-02-10 10:38:28","updated_at":"2025-03-03 14:38:42","contract_scan":"","receipt_scan":"","contract_type":2,"project_id":3761,"valid_date":"","expire_date":"2026-02-28","sla":"","remind_ahead":"7 days","expire_remind_ahead":"15 days","expire_reminded":false,"serial_no":"TS-WZW-20250210001","payment_collection_remind_ahead":"00:00:00","from_project":3761,"receipt_date":"","verify_date":"","including_tax":true,"build_by_project":true,"need_analysis":true,"is_settle":true,"is_deliver":true,"is_outbound":true,"is_save_collection":true,"save_collection_at":"2025-02-10 10:38:28.09095+08","b_date":238,"passed":2,"client":{"id":107,"key":107,"name":"\u84dd\u661f\u4e1c\u4e3d\u819c\u79d1\u6280(\u5317\u4eac)\u6709\u9650\u516c\u53f8","logo":"","sales_rep":5295,"salesRep":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"}}},"project":{"id":3761,"key":3761,"name":"2025\u65b0\u8d2d\u6280\u672f\u670d\u52a1"},"contractScan":"","receiptScan":"","contractType":{"id":2,"key":2,"name":"\u8fd0\u7ef4\u670d\u52a1"},"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"}},"handleBy":{"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"}},"remindDate":"","serviceContractRemindDates":[],"salesContractRemindReceivers":[{"id":8314,"user_id":5295,"key":5295,"contract_id":3777,"user":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F"}}],"serviceContractRemindReceivers":[],"salesContractPaymentCollectionRemindReceivers":[{"id":7941,"user_id":5295,"key":5295,"contract_id":3777,"user":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F"}}],"salesContractPaymentCollectionRemindDates":[{"id":2328,"key":2328,"contract_id":3777,"name":"2025-03-31","value":"30000","overdue_days":""}],"salesContractPayments":[{"id":2115,"key":2115,"contract_id":3777,"value":"30000","created_by":1013,"createdBy":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","department_id":7,"avatar":{"id":34,"user_id":1013,"name":"\/files\/cdn\/a57be577deb434\/avatar\/25ef1fe7-8dda-3daa-b8ea-9fabd0a47439.png"}}}],"salesContractInvoices":[{"id":1947,"key":1947,"contract_id":3777,"value":"30000.00","attachment_id":"","from_date":"2025-02-10","created_by":5252,"createdBy":{"id":5252,"key":5252,"name":"\u738b\u7b11\u7b11","sex":"F","department_id":6,"avatar":{"id":101,"user_id":5252,"name":"\/files\/cdn\/a57be577deb434\/avatar\/f5529321-408e-3d11-aa95-9b0a384f2d9c.png"}},"attachment":{}}],"commentCount":{"object_id":3777,"comment":7},"unreadComments":{},"remind_date":"","remind_ahead_display":"1\u5468","expire_remind_ahead_display":"\u65e0","unread":0,"bgcolor":"#89c541","can_update":true,"can_delete":false},{"id":3771,"client_id":107,"signed_at":"2025-01-22","amount":"74738.2","handler":5295,"description":"","created_by":5295,"created_at":"2025-01-22 09:24:21","updated_at":"2025-03-03 14:39:02","contract_scan":"","receipt_scan":"","contract_type":1,"project_id":3762,"valid_date":"","expire_date":"","sla":"","remind_ahead":"","expire_remind_ahead":"","expire_reminded":false,"serial_no":"TS-WZW-2025011501","payment_collection_remind_ahead":"00:00:00","from_project":3762,"receipt_date":"","verify_date":"","including_tax":true,"build_by_project":true,"need_analysis":true,"is_settle":true,"is_deliver":true,"is_outbound":true,"is_save_collection":true,"save_collection_at":"2025-02-11 21:25:25.691293+08","b_date":"","passed":1,"client":{"id":107,"key":107,"name":"\u84dd\u661f\u4e1c\u4e3d\u819c\u79d1\u6280(\u5317\u4eac)\u6709\u9650\u516c\u53f8","logo":"","sales_rep":5295,"salesRep":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"}}},"project":{"id":3762,"key":3762,"name":"2025veeam\u8f6f\u4ef6\u7eed\u4fdd"},"contractScan":"","receiptScan":"","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"}},"handleBy":{"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"}},"remindDate":"","serviceContractRemindDates":[],"salesContractRemindReceivers":[],"serviceContractRemindReceivers":[],"salesContractPaymentCollectionRemindReceivers":[{"id":7942,"user_id":5295,"key":5295,"contract_id":3771,"user":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F"}}],"salesContractPaymentCollectionRemindDates":[{"id":2331,"key":2331,"contract_id":3771,"name":"2025-02-28","value":"74738.2","overdue_days":""}],"salesContractPayments":[{"id":2090,"key":2090,"contract_id":3771,"value":"74738.2","created_by":1013,"createdBy":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","department_id":7,"avatar":{"id":34,"user_id":1013,"name":"\/files\/cdn\/a57be577deb434\/avatar\/25ef1fe7-8dda-3daa-b8ea-9fabd0a47439.png"}}}],"salesContractInvoices":[{"id":1948,"key":1948,"contract_id":3771,"value":"74738.20","attachment_id":"","from_date":"2025-02-12","created_by":5252,"createdBy":{"id":5252,"key":5252,"name":"\u738b\u7b11\u7b11","sex":"F","department_id":6,"avatar":{"id":101,"user_id":5252,"name":"\/files\/cdn\/a57be577deb434\/avatar\/f5529321-408e-3d11-aa95-9b0a384f2d9c.png"}},"attachment":{}}],"commentCount":{"object_id":3771,"comment":8},"unreadComments":{},"remind_date":"","remind_ahead_display":"\u65e0","expire_remind_ahead_display":"\u65e0","unread":0,"bgcolor":"#89c541","can_update":true,"can_delete":false},{"id":3767,"client_id":1301,"signed_at":"2025-01-20","amount":"1320","handler":5295,"description":"","created_by":5295,"created_at":"2025-01-20 10:56:24","updated_at":"2025-01-24 16:16:18","contract_scan":"","receipt_scan":"","contract_type":1,"project_id":3768,"valid_date":"","expire_date":"2026-01-19","sla":"","remind_ahead":"","expire_remind_ahead":"","expire_reminded":false,"serial_no":"TS-WZW-20250117001","payment_collection_remind_ahead":"00:00:00","from_project":3768,"receipt_date":"","verify_date":"","including_tax":true,"build_by_project":true,"need_analysis":true,"is_settle":true,"is_deliver":true,"is_outbound":true,"is_save_collection":true,"save_collection_at":"2025-01-20 10:56:24.79422+08","b_date":198,"passed":2,"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":"","sales_rep":5295,"salesRep":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"}}},"project":{"id":3768,"key":3768,"name":"\u670d\u52a1\u5668\u66f4\u6362\u914d\u4ef6"},"contractScan":"","receiptScan":"","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"}},"handleBy":{"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"}},"remindDate":"","serviceContractRemindDates":[],"salesContractRemindReceivers":[],"serviceContractRemindReceivers":[],"salesContractPaymentCollectionRemindReceivers":[{"id":7816,"user_id":5295,"key":5295,"contract_id":3767,"user":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F"}},{"id":7817,"user_id":5388,"key":5388,"contract_id":3767,"user":{"id":5388,"key":5388,"name":"\u6768\u71d5\u971e","sex":"F"}},{"id":7818,"user_id":1001,"key":1001,"contract_id":3767,"user":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M"}}],"salesContractPaymentCollectionRemindDates":[{"id":2320,"key":2320,"contract_id":3767,"name":"2025-02-28","value":"1320","overdue_days":""}],"salesContractPayments":[{"id":2108,"key":2108,"contract_id":3767,"value":"1320","created_by":1013,"createdBy":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","department_id":7,"avatar":{"id":34,"user_id":1013,"name":"\/files\/cdn\/a57be577deb434\/avatar\/25ef1fe7-8dda-3daa-b8ea-9fabd0a47439.png"}}}],"salesContractInvoices":[{"id":1946,"key":1946,"contract_id":3767,"value":"1320.00","attachment_id":"","from_date":"2025-02-10","created_by":5252,"createdBy":{"id":5252,"key":5252,"name":"\u738b\u7b11\u7b11","sex":"F","department_id":6,"avatar":{"id":101,"user_id":5252,"name":"\/files\/cdn\/a57be577deb434\/avatar\/f5529321-408e-3d11-aa95-9b0a384f2d9c.png"}},"attachment":{}}],"commentCount":{"object_id":3767,"comment":8},"unreadComments":{},"remind_date":"","remind_ahead_display":"\u65e0","expire_remind_ahead_display":"\u65e0","unread":0,"bgcolor":"#89c541","can_update":true,"can_delete":false},{"id":3763,"client_id":3327,"signed_at":"2025-01-16","amount":"121361","handler":1001,"description":"","created_by":1001,"created_at":"2025-01-16 15:05:08","updated_at":"2025-03-17 16:45:08","contract_scan":"","receipt_scan":"","contract_type":1,"project_id":3767,"valid_date":"","expire_date":"2029-02-27","sla":"","remind_ahead":"","expire_remind_ahead":"","expire_reminded":false,"serial_no":"TS-LRC-2025011601","payment_collection_remind_ahead":"","from_project":3767,"receipt_date":"","verify_date":"","including_tax":true,"build_by_project":true,"need_analysis":true,"is_settle":true,"is_deliver":true,"is_outbound":true,"is_save_collection":true,"save_collection_at":"2025-04-19 17:01:38.881505+08","b_date":1333,"passed":2,"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","logo":"","sales_rep":1001,"salesRep":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}}},"project":{"id":3767,"key":3767,"name":"PA440 2\u53f0\u8bbe\u5907\u65b0\u8d2d\u9879\u76ee\u4e8c"},"contractScan":"","receiptScan":"","contractType":{"id":1,"key":1,"name":"\u4ea7\u54c1\u9500\u552e"},"createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4,"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"},"department":{"id":4,"key":4,"name":"\u603b\u7ecf\u7406"}},"handleBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4,"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}},"remindDate":"","serviceContractRemindDates":[],"salesContractRemindReceivers":[],"serviceContractRemindReceivers":[],"salesContractPaymentCollectionRemindReceivers":[{"id":8059,"user_id":1001,"key":1001,"contract_id":3763,"user":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M"}},{"id":8060,"user_id":1011,"key":1011,"contract_id":3763,"user":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F"}},{"id":8061,"user_id":5388,"key":5388,"contract_id":3763,"user":{"id":5388,"key":5388,"name":"\u6768\u71d5\u971e","sex":"F"}}],"salesContractPaymentCollectionRemindDates":[{"id":2365,"key":2365,"contract_id":3763,"name":"2025-01-24","value":"24272.2","overdue_days":""},{"id":2363,"key":2363,"contract_id":3763,"name":"2025-03-14","value":"84952.7","overdue_days":""},{"id":2364,"key":2364,"contract_id":3763,"name":"2025-03-28","value":"12136.1","overdue_days":""}],"salesContractPayments":[{"id":2079,"key":2079,"contract_id":3763,"value":"24272.2","created_by":1013,"createdBy":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","department_id":7,"avatar":{"id":34,"user_id":1013,"name":"\/files\/cdn\/a57be577deb434\/avatar\/25ef1fe7-8dda-3daa-b8ea-9fabd0a47439.png"}}},{"id":2120,"key":2120,"contract_id":3763,"value":"84952.7","created_by":1013,"createdBy":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","department_id":7,"avatar":{"id":34,"user_id":1013,"name":"\/files\/cdn\/a57be577deb434\/avatar\/25ef1fe7-8dda-3daa-b8ea-9fabd0a47439.png"}}},{"id":2134,"key":2134,"contract_id":3763,"value":"12136.1","created_by":1013,"createdBy":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","department_id":7,"avatar":{"id":34,"user_id":1013,"name":"\/files\/cdn\/a57be577deb434\/avatar\/25ef1fe7-8dda-3daa-b8ea-9fabd0a47439.png"}}}],"salesContractInvoices":[{"id":1976,"key":1976,"contract_id":3763,"value":"121361.00","attachment_id":"","from_date":"2025-03-11","created_by":5252,"createdBy":{"id":5252,"key":5252,"name":"\u738b\u7b11\u7b11","sex":"F","department_id":6,"avatar":{"id":101,"user_id":5252,"name":"\/files\/cdn\/a57be577deb434\/avatar\/f5529321-408e-3d11-aa95-9b0a384f2d9c.png"}},"attachment":{}}],"commentCount":{"object_id":3763,"comment":10},"unreadComments":{},"remind_date":"","remind_ahead_display":"\u65e0","expire_remind_ahead_display":"\u65e0","unread":0,"bgcolor":"#89c541","can_update":true,"can_delete":false},{"id":3761,"client_id":2182,"signed_at":"2025-01-16","amount":"76000","handler":5300,"description":"","created_by":5300,"created_at":"2025-01-16 09:40:49","updated_at":"2025-02-19 13:25:08","contract_scan":"","receipt_scan":"","contract_type":2,"project_id":3745,"valid_date":"","expire_date":"2026-01-14","sla":"","remind_ahead":"","expire_remind_ahead":"30 days","expire_reminded":false,"serial_no":"PO-2025-01-0003","payment_collection_remind_ahead":"7 days","from_project":3745,"receipt_date":"","verify_date":"","including_tax":true,"build_by_project":true,"need_analysis":true,"is_settle":true,"is_deliver":true,"is_outbound":true,"is_save_collection":true,"save_collection_at":"2025-01-17 13:57:32.712836+08","b_date":193,"passed":2,"client":{"id":2182,"key":2182,"name":"\u5317\u4eac\u5357\u65b9\u65af\u5948\u514b\u739b\u6da1\u8f6e\u6280\u672f\u6709\u9650\u516c\u53f8","logo":"","sales_rep":5300,"salesRep":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91","avatar":{"id":141,"user_id":5300,"name":"\/files\/cdn\/a57be577deb434\/avatar\/14dfd1a0-6df5-354a-8afd-f0a76fa8e852.png"}}},"project":{"id":3745,"key":3745,"name":"netapp\u5b58\u50a8\u7b2c\u4e09\u65b9\u7ef4\u4fdd1\u5e74-2024"},"contractScan":"","receiptScan":"","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"}},"handleBy":{"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"}},"remindDate":"","serviceContractRemindDates":[],"salesContractRemindReceivers":[{"id":8304,"user_id":5300,"key":5300,"contract_id":3761,"user":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91","sex":"F"}}],"serviceContractRemindReceivers":[],"salesContractPaymentCollectionRemindReceivers":[{"id":7880,"user_id":5300,"key":5300,"contract_id":3761,"user":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91","sex":"F"}},{"id":7881,"user_id":5388,"key":5388,"contract_id":3761,"user":{"id":5388,"key":5388,"name":"\u6768\u71d5\u971e","sex":"F"}},{"id":7882,"user_id":1001,"key":1001,"contract_id":3761,"user":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M"}}],"salesContractPaymentCollectionRemindDates":[{"id":2319,"key":2319,"contract_id":3761,"name":"2025-02-18","value":"76000","overdue_days":""}],"salesContractPayments":[{"id":2095,"key":2095,"contract_id":3761,"value":"76000","created_by":1013,"createdBy":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","department_id":7,"avatar":{"id":34,"user_id":1013,"name":"\/files\/cdn\/a57be577deb434\/avatar\/25ef1fe7-8dda-3daa-b8ea-9fabd0a47439.png"}}}],"salesContractInvoices":[{"id":1941,"key":1941,"contract_id":3761,"value":"76000.00","attachment_id":"","from_date":"2025-01-16","created_by":5252,"createdBy":{"id":5252,"key":5252,"name":"\u738b\u7b11\u7b11","sex":"F","department_id":6,"avatar":{"id":101,"user_id":5252,"name":"\/files\/cdn\/a57be577deb434\/avatar\/f5529321-408e-3d11-aa95-9b0a384f2d9c.png"}},"attachment":{}}],"commentCount":{"object_id":3761,"comment":7},"unreadComments":{},"remind_date":"","remind_ahead_display":"\u65e0","expire_remind_ahead_display":"\u65e0","unread":0,"bgcolor":"#89c541","can_update":true,"can_delete":false},{"id":3759,"client_id":12,"signed_at":"2025-01-14","amount":"20560","handler":5300,"description":"","created_by":5300,"created_at":"2025-01-14 18:09:11","updated_at":"2025-01-21 11:07:29","contract_scan":"","receipt_scan":"","contract_type":1,"project_id":3766,"valid_date":"","expire_date":"2026-01-16","sla":"","remind_ahead":"","expire_remind_ahead":"","expire_reminded":false,"serial_no":"SMC\u5929\u6d25\u8ba2\u5355POTJ25013202","payment_collection_remind_ahead":"7 days","from_project":3766,"receipt_date":"","verify_date":"","including_tax":true,"build_by_project":true,"need_analysis":true,"is_settle":true,"is_deliver":true,"is_outbound":true,"is_save_collection":true,"save_collection_at":"2025-01-14 19:38:36.862613+08","b_date":195,"passed":2,"client":{"id":12,"key":12,"name":"smc(\u4e2d\u56fd)\u6709\u9650\u516c\u53f8\/SMC(\u5317\u4eac)\u5236\u9020\u6709\u9650\u516c\u53f8","logo":"","sales_rep":5300,"salesRep":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91","avatar":{"id":141,"user_id":5300,"name":"\/files\/cdn\/a57be577deb434\/avatar\/14dfd1a0-6df5-354a-8afd-f0a76fa8e852.png"}}},"project":{"id":3766,"key":3766,"name":"POTJ25013202-\u534e\u4e09\u7f51\u7edc\u8bbe\u5907-G-2025"},"contractScan":"","receiptScan":"","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"}},"handleBy":{"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"}},"remindDate":"","serviceContractRemindDates":[],"salesContractRemindReceivers":[],"serviceContractRemindReceivers":[],"salesContractPaymentCollectionRemindReceivers":[{"id":7759,"user_id":5300,"key":5300,"contract_id":3759,"user":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91","sex":"F"}}],"salesContractPaymentCollectionRemindDates":[{"id":2309,"key":2309,"contract_id":3759,"name":"2025-03-14","value":"20560","overdue_days":""}],"salesContractPayments":[{"id":2123,"key":2123,"contract_id":3759,"value":"20560","created_by":1013,"createdBy":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","department_id":7,"avatar":{"id":34,"user_id":1013,"name":"\/files\/cdn\/a57be577deb434\/avatar\/25ef1fe7-8dda-3daa-b8ea-9fabd0a47439.png"}}}],"salesContractInvoices":[{"id":1960,"key":1960,"contract_id":3759,"value":"20560.00","attachment_id":"","from_date":"2025-02-24","created_by":5252,"createdBy":{"id":5252,"key":5252,"name":"\u738b\u7b11\u7b11","sex":"F","department_id":6,"avatar":{"id":101,"user_id":5252,"name":"\/files\/cdn\/a57be577deb434\/avatar\/f5529321-408e-3d11-aa95-9b0a384f2d9c.png"}},"attachment":{}}],"commentCount":{"object_id":3759,"comment":10},"unreadComments":{},"remind_date":"","remind_ahead_display":"\u65e0","expire_remind_ahead_display":"\u65e0","unread":0,"bgcolor":"#89c541","can_update":true,"can_delete":false},{"id":3758,"client_id":12,"signed_at":"2025-01-14","amount":"7156","handler":5300,"description":"","created_by":5300,"created_at":"2025-01-14 18:06:15","updated_at":"2025-01-21 11:08:06","contract_scan":"","receipt_scan":"","contract_type":1,"project_id":3765,"valid_date":"","expire_date":"2026-01-16","sla":"","remind_ahead":"","expire_remind_ahead":"","expire_reminded":false,"serial_no":"SMC\u5929\u6d25\u8ba2\u5355POTJ25013200","payment_collection_remind_ahead":"7 days","from_project":3765,"receipt_date":"","verify_date":"","including_tax":true,"build_by_project":true,"need_analysis":true,"is_settle":true,"is_deliver":true,"is_outbound":true,"is_save_collection":true,"save_collection_at":"2025-01-14 19:39:34.245708+08","b_date":195,"passed":2,"client":{"id":12,"key":12,"name":"smc(\u4e2d\u56fd)\u6709\u9650\u516c\u53f8\/SMC(\u5317\u4eac)\u5236\u9020\u6709\u9650\u516c\u53f8","logo":"","sales_rep":5300,"salesRep":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91","avatar":{"id":141,"user_id":5300,"name":"\/files\/cdn\/a57be577deb434\/avatar\/14dfd1a0-6df5-354a-8afd-f0a76fa8e852.png"}}},"project":{"id":3765,"key":3765,"name":"POTJ25013200-\u534e\u4e09\u7f51\u7edc\u8bbe\u59072-G-2025"},"contractScan":"","receiptScan":"","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"}},"handleBy":{"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"}},"remindDate":"","serviceContractRemindDates":[],"salesContractRemindReceivers":[],"serviceContractRemindReceivers":[],"salesContractPaymentCollectionRemindReceivers":[{"id":7760,"user_id":5300,"key":5300,"contract_id":3758,"user":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91","sex":"F"}}],"salesContractPaymentCollectionRemindDates":[{"id":2310,"key":2310,"contract_id":3758,"name":"2025-03-14","value":"7156","overdue_days":""}],"salesContractPayments":[{"id":2124,"key":2124,"contract_id":3758,"value":"7156","created_by":1013,"createdBy":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","department_id":7,"avatar":{"id":34,"user_id":1013,"name":"\/files\/cdn\/a57be577deb434\/avatar\/25ef1fe7-8dda-3daa-b8ea-9fabd0a47439.png"}}}],"salesContractInvoices":[{"id":1961,"key":1961,"contract_id":3758,"value":"7156.00","attachment_id":"","from_date":"2025-02-24","created_by":5252,"createdBy":{"id":5252,"key":5252,"name":"\u738b\u7b11\u7b11","sex":"F","department_id":6,"avatar":{"id":101,"user_id":5252,"name":"\/files\/cdn\/a57be577deb434\/avatar\/f5529321-408e-3d11-aa95-9b0a384f2d9c.png"}},"attachment":{}}],"commentCount":{"object_id":3758,"comment":9},"unreadComments":{},"remind_date":"","remind_ahead_display":"\u65e0","expire_remind_ahead_display":"\u65e0","unread":0,"bgcolor":"#89c541","can_update":true,"can_delete":false},{"id":3755,"client_id":2616,"signed_at":"2025-01-13","amount":"122000","handler":1001,"description":"","created_by":1001,"created_at":"2025-01-13 17:04:16","updated_at":"2025-02-20 14:28:52","contract_scan":"","receipt_scan":"","contract_type":1,"project_id":3764,"valid_date":"","expire_date":"","sla":"","remind_ahead":"","expire_remind_ahead":"","expire_reminded":false,"serial_no":"TS-ZHY-2025011301","payment_collection_remind_ahead":"2 days","from_project":3764,"receipt_date":"","verify_date":"","including_tax":true,"build_by_project":true,"need_analysis":true,"is_settle":true,"is_deliver":true,"is_outbound":true,"is_save_collection":true,"save_collection_at":"2025-01-13 17:04:16.695942+08","b_date":"","passed":1,"client":{"id":2616,"key":2616,"name":"\u5317\u4eac\u6e90\u70b9\u601d\u535a\u79d1\u6280\u6709\u9650\u516c\u53f8(\u8fc7\u5355)","logo":"","sales_rep":1001,"salesRep":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}}},"project":{"id":3764,"key":3764,"name":"PA1410 \u4e24\u53f0\u8bbe\u5907\u91c7\u8d2d\u9879\u76ee"},"contractScan":"","receiptScan":"","contractType":{"id":1,"key":1,"name":"\u4ea7\u54c1\u9500\u552e"},"createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4,"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"},"department":{"id":4,"key":4,"name":"\u603b\u7ecf\u7406"}},"handleBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4,"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}},"remindDate":"","serviceContractRemindDates":[],"salesContractRemindReceivers":[],"serviceContractRemindReceivers":[],"salesContractPaymentCollectionRemindReceivers":[{"id":7717,"user_id":1001,"key":1001,"contract_id":3755,"user":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M"}},{"id":7718,"user_id":1011,"key":1011,"contract_id":3755,"user":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F"}},{"id":7719,"user_id":5388,"key":5388,"contract_id":3755,"user":{"id":5388,"key":5388,"name":"\u6768\u71d5\u971e","sex":"F"}}],"salesContractPaymentCollectionRemindDates":[{"id":2306,"key":2306,"contract_id":3755,"name":"2025-01-24","value":"122000","overdue_days":0}],"salesContractPayments":[{"id":2092,"key":2092,"contract_id":3755,"value":"122000","created_by":1013,"createdBy":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","department_id":7,"avatar":{"id":34,"user_id":1013,"name":"\/files\/cdn\/a57be577deb434\/avatar\/25ef1fe7-8dda-3daa-b8ea-9fabd0a47439.png"}}}],"salesContractInvoices":[{"id":1933,"key":1933,"contract_id":3755,"value":"122000.00","attachment_id":"","from_date":"2025-01-14","created_by":5252,"createdBy":{"id":5252,"key":5252,"name":"\u738b\u7b11\u7b11","sex":"F","department_id":6,"avatar":{"id":101,"user_id":5252,"name":"\/files\/cdn\/a57be577deb434\/avatar\/f5529321-408e-3d11-aa95-9b0a384f2d9c.png"}},"attachment":{}}],"commentCount":{"object_id":3755,"comment":10},"unreadComments":{},"remind_date":"","remind_ahead_display":"\u65e0","expire_remind_ahead_display":"\u65e0","unread":0,"bgcolor":"#89c541","can_update":true,"can_delete":false},{"id":3749,"client_id":2021,"signed_at":"2025-01-09","amount":"600","handler":5300,"description":"","created_by":5300,"created_at":"2025-01-09 18:29:21","updated_at":"2025-01-17 16:02:39","contract_scan":"","receipt_scan":"","contract_type":1,"project_id":3763,"valid_date":"","expire_date":"","sla":"","remind_ahead":"","expire_remind_ahead":"","expire_reminded":false,"serial_no":"TS-SQY-2025010901","payment_collection_remind_ahead":"00:00:00","from_project":3763,"receipt_date":"","verify_date":"","including_tax":true,"build_by_project":true,"need_analysis":true,"is_settle":true,"is_deliver":true,"is_outbound":true,"is_save_collection":true,"save_collection_at":"2025-01-09 18:29:22.010601+08","b_date":"","passed":1,"client":{"id":2021,"key":2021,"name":"\u65b0\u7586\u535a\u4f17\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8","logo":"","sales_rep":5311,"salesRep":{"id":5311,"key":5311,"name":"\u62d3\u5c0f\u6587","avatar":{"id":149,"user_id":5311,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1a32eee2-9465-3c88-9077-5c6d1cc5e8b3.jpg"}}},"project":{"id":3763,"key":3763,"name":"\u786c\u76d8SAS300GB10K-G-2025"},"contractScan":"","receiptScan":"","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"}},"handleBy":{"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"}},"remindDate":"","serviceContractRemindDates":[],"salesContractRemindReceivers":[{"id":8290,"user_id":5311,"key":5311,"contract_id":3749,"user":{"id":5311,"key":5311,"name":"\u62d3\u5c0f\u6587","sex":"F"}}],"serviceContractRemindReceivers":[],"salesContractPaymentCollectionRemindReceivers":[],"salesContractPaymentCollectionRemindDates":[{"id":2305,"key":2305,"contract_id":3749,"name":"2025-01-09","value":"600","overdue_days":0}],"salesContractPayments":[{"id":2071,"key":2071,"contract_id":3749,"value":"600","created_by":1013,"createdBy":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","department_id":7,"avatar":{"id":34,"user_id":1013,"name":"\/files\/cdn\/a57be577deb434\/avatar\/25ef1fe7-8dda-3daa-b8ea-9fabd0a47439.png"}}}],"salesContractInvoices":[{"id":1944,"key":1944,"contract_id":3749,"value":"600.00","attachment_id":"","from_date":"2025-01-21","created_by":5252,"createdBy":{"id":5252,"key":5252,"name":"\u738b\u7b11\u7b11","sex":"F","department_id":6,"avatar":{"id":101,"user_id":5252,"name":"\/files\/cdn\/a57be577deb434\/avatar\/f5529321-408e-3d11-aa95-9b0a384f2d9c.png"}},"attachment":{}}],"commentCount":{"object_id":3749,"comment":9},"unreadComments":{},"remind_date":"","remind_ahead_display":"\u65e0","expire_remind_ahead_display":"\u65e0","unread":0,"bgcolor":"#89c541","can_update":true,"can_delete":false}],"can_create":true,"pagenation":{"totalcount":902,"thispage":1,"pagesize":20}},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}],"mod":0}', FALSE, '2025-07-05 14:09:51') RETURNING "id" |
| 14:09:51.822 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 14:09:51.822 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: SET |