68cccee43f377: POST https://beta.jinchangxiao.com/v2/sales-contract/list at 2025-09-19 11:32:52 am by 218.94.149.220
Log Messages
总计92条数据
| Time | Level | Category | Message |
|---|---|---|---|
| 11:32:52.258 | trace | yii\base\Application::bootstrap | Bootstrap with yii\log\Dispatcher |
| 11:32:52.258 | trace | yii\base\Module::getModule | Loading module: debug |
| 11:32:52.258 | trace | yii\base\Application::bootstrap | Bootstrap with yii\debug\Module::bootstrap() |
| 11:32:52.259 | trace | yii\redis\Connection::open | Opening redis DB connection: redis.server.local:6379, database=1 |
| 11:32:52.259 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: SELECT |
| 11:32:52.259 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 11:32:52.259 | trace | yii\base\Module::getModule | Loading module: gii |
| 11:32:52.259 | trace | yii\base\Application::bootstrap | Bootstrap with yii\gii\Module::bootstrap() |
| 11:32:52.259 | trace | yii\web\UrlManager::parseRequest | No matching URL rules. Using default URL parsing logic. |
| 11:32:52.259 | trace | yii\web\Application::handleRequest | Route requested: 'v2/sales-contract/list' |
| 11:32:52.259 | trace | yii\base\Module::getModule | Loading module: v2 |
| 11:32:52.260 | info | yii\web\Session::open | Session started |
| 11:32:52.260 | info | yii\db\Connection::open | Opening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta |
| 11:32:52.262 | info | yii\db\Command::query | SELECT * FROM "global"."vw_user_login" WHERE "access_token"='hLtdglndkreOmfJjmOe7Mve0kQO2lAQu' |
| 11:32:52.265 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 11:32:52.265 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 11:32:52.265 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 11:32:52.265 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 11:32:52.265 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1000 |
| 11:32:52.267 | trace | yii\base\Controller::runAction | Route to run: v2/sales-contract/list |
| 11:32:52.267 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 11:32:52.268 | trace | uranus\rbac\DbManager::checkAccessFromCache | Checking role: Admin |
| 11:32:52.268 | trace | yii\base\InlineAction::runWithParams | Running action: app\modules\v2\controllers\SalesContractController::actionList() |
| 11:32:52.268 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 11:32:52.268 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 11:32:52.269 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 11:32:52.270 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 11:32:52.271 | 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.from_project LEFT JOIN "a57be577deb434"."tbl_sales_group_relationships" "sgr" ON sgr.sales_id = client.sales_rep LEFT JOIN "a57be577deb434"."tbl_attachement_relationships" "cs" ON cs.object_id = c.id AND cs.object_type = 105 LEFT JOIN "a57be577deb434"."tbl_attachement_relationships" "rs" ON rs.object_id = c.id AND rs.object_type = 106 LEFT JOIN "a57be577deb434"."tbl_attachement_relationships" "vs" ON vs.object_id = c.id AND vs.object_type = 107 WHERE (true) AND (("client"."sales_rep" IN (5049, 5301, 5022, 5209, 5026, 5293, 5309, 5356, 5329, 5299, 5303, 5302, 5332, 5047, 1026, 5096, 5070, 5448, 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, 5412, 5409, 5229, 1005, 5304, 5449, 5358, 1006, 5093)) OR ("client"."sales_rep" IS NULL) OR ("client"."id" IN (SELECT "client_id" FROM "a57be577deb434"."tbl_user_visit_clients" WHERE "user_id"=1000))) GROUP BY "c"."id" ORDER BY "c"."amount") "c" |
| 11:32:52.286 | 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.from_project LEFT JOIN "a57be577deb434"."tbl_sales_group_relationships" "sgr" ON sgr.sales_id = client.sales_rep LEFT JOIN "a57be577deb434"."tbl_attachement_relationships" "cs" ON cs.object_id = c.id AND cs.object_type = 105 LEFT JOIN "a57be577deb434"."tbl_attachement_relationships" "rs" ON rs.object_id = c.id AND rs.object_type = 106 LEFT JOIN "a57be577deb434"."tbl_attachement_relationships" "vs" ON vs.object_id = c.id AND vs.object_type = 107 WHERE (true) AND (("client"."sales_rep" IN (5049, 5301, 5022, 5209, 5026, 5293, 5309, 5356, 5329, 5299, 5303, 5302, 5332, 5047, 1026, 5096, 5070, 5448, 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, 5412, 5409, 5229, 1005, 5304, 5449, 5358, 1006, 5093)) OR ("client"."sales_rep" IS NULL) OR ("client"."id" IN (SELECT "client_id" FROM "a57be577deb434"."tbl_user_visit_clients" WHERE "user_id"=1000))) GROUP BY "c"."id" ORDER BY "c"."amount" LIMIT 10 |
| 11:32:52.301 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "name", "logo", "sales_rep" FROM "a57be577deb434"."tbl_clients" WHERE "id" IN (1312, 12, 57) |
| 11:32:52.301 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (5300, 5332, 1001) |
| 11:32:52.302 | 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, 5332, 5300)) |
| 11:32:52.302 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "name", "orig_name", "extension", "path" FROM "a57be577deb434"."tbl_attachments" WHERE "id" IN (3095, 1532, 4159, 833) |
| 11:32:52.307 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "name", "orig_name", "extension", "path" FROM "a57be577deb434"."tbl_attachments" WHERE "id" IN (3096, 1533, 4160) |
| 11:32:52.307 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (5015, 5300) |
| 11:32:52.308 | 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 (5015, 5300)) |
| 11:32:52.308 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_departments" WHERE "id" IN (9, 1) |
| 11:32:52.309 | info | yii\db\Command::query | SELECT "object_id", count(*) AS comment FROM "a57be577deb434"."tbl_comments" WHERE ("object_type"=7) AND ("object_id" IN (1076, 658, 1313, 192, 3553, 4043, 3710, 3711, 4022, 4083)) GROUP BY "object_id" |
| 11:32:52.330 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "project_title" AS "name" FROM "a57be577deb434"."tbl_projects" WHERE "id" IN (1205, 888, 1613, 271, 3669, 3920, 3741, 3742, 3913, 3941) |
| 11:32:52.336 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_sales_orders" WHERE ("status" IN (2, 5)) AND ("project_id" IN (1613, 3669, 3741, 3742, 888, 271, 1205, 3913, 3920, 3941)) |
| 11:32:52.338 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_sales_order_verify_rels" WHERE "erp_sales_order_id" IN (1562, 1537, 1545, 72, 253, 414, 522, 1356, 1409, 1410) ORDER BY "id" |
| 11:32:52.338 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_sales_order_stop_verify_rels" WHERE "erp_sales_order_id" IN (1562, 1537, 1545, 72, 253, 414, 522, 1356, 1409, 1410) ORDER BY "id" |
| 11:32:52.339 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "project_title" AS "name", "description", "total_contact_point", "paid_contact_point", "is_sales_order_ready", "project_product_version_id", "bargain_date", "collected", "profit_pct", "budget" FROM "a57be577deb434"."tbl_projects" WHERE "id" IN (1205, 888, 1613, 271, 3669, 3920, 3741, 3742, 3913, 3941) |
| 11:32:52.340 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_sales_orders" WHERE ("status" IN (2, 5)) AND ("project_id" IN (1613, 3669, 3741, 3742, 888, 271, 1205, 3913, 3920, 3941)) |
| 11:32:52.340 | info | yii\db\Command::query | SELECT "id", "product_type_id", "product_type_id" AS "key", "name", "budget", "pct", "project_id", "profit" FROM "a57be577deb434"."tbl_project_product_types" WHERE "project_id" IN (1613, 3669, 3741, 3742, 888, 271, 1205, 3913, 3920, 3941) |
| 11:32:52.341 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_project_product_rels" WHERE "project_id" IN (1613, 3669, 3741, 3742, 888, 271, 1205, 3913, 3920, 3941) |
| 11:32:52.342 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_suppliers" WHERE "id" IN (608, 626) |
| 11:32:52.342 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_products" WHERE "id" IN (1690, 1691, 1677) |
| 11:32:52.344 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_types" WHERE "id" IN (4, 11) |
| 11:32:52.345 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_components" WHERE "id" IN (43, 179) |
| 11:32:52.345 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_brands" WHERE "id" IN (20, 10, 43) |
| 11:32:52.346 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_series" WHERE "id" IN (1425, 1438, 1439) |
| 11:32:52.347 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_units" WHERE "id" IN (3, 6) |
| 11:32:52.347 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_sales_order_products" WHERE "id" IN (1791, 1756, 1439, 1440, 1829, 1247) |
| 11:32:52.351 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_project_contact_points" WHERE "project_id" IN (1613, 3669, 3741, 3742, 888, 271, 1205, 3913, 3920, 3941) |
| 11:32:52.352 | info | yii\db\Command::query | SELECT "id", "project_id" FROM "a57be577deb434"."tbl_sales_order_items" WHERE ("is_system"=TRUE) AND ("project_id" IN (1613, 3669, 3741, 3742, 888, 271, 1205, 3913, 3920, 3941)) |
| 11:32:52.354 | info | yii\db\Command::query | SELECT "project_id", sum(amount) AS sum FROM "a57be577deb434"."tbl_reimbursements" WHERE ("status" IN (2, 3)) AND ("project_id" IN (1613, 3669, 3741, 3742, 888, 271, 1205, 3913, 3920, 3941)) GROUP BY "project_id" |
| 11:32:52.356 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_sales_supplier_rels" WHERE "contract_id" IN (1076, 658, 1313, 192, 3553, 4043, 3710, 3711, 4022, 4083) |
| 11:32:52.356 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_suppliers" WHERE "id" IN (608, 626) |
| 11:32:52.357 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "serial_no" FROM "a57be577deb434"."tbl_purchase_contracts" WHERE "id" IN (4084, 3569, 3712, 4023, 4045) |
| 11:32:52.359 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "type" AS "name" FROM "a57be577deb434"."tbl_contract_types" WHERE "id" IN (1, 2) |
| 11:32:52.360 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (5089, 1003, 1006, 5300) |
| 11:32:52.360 | 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 (5089, 1006, 5300, 1003)) |
| 11:32:52.360 | 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 (1076, 658, 1313, 192, 3553, 4043, 3710, 3711, 4022, 4083)) ORDER BY "remind_date" |
| 11:32:52.361 | 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 (1076, 658, 1313, 192, 3553, 4043, 3710, 3711, 4022, 4083) |
| 11:32:52.362 | 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 (1076, 658, 1313, 192, 3553, 4043, 3710, 3711, 4022, 4083) |
| 11:32:52.363 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "name", "sex" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (1011, 5332, 1013, 5300, 1001) |
| 11:32:52.364 | 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 (1011, 1001, 5332, 1013, 5300)) |
| 11:32:52.364 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_service_contract_remind_receivers" WHERE "contract_id" IN (1076, 658, 1313, 192, 3553, 4043, 3710, 3711, 4022, 4083) |
| 11:32:52.365 | 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 (1076, 658, 1313, 192, 3553, 4043, 3710, 3711, 4022, 4083) |
| 11:32:52.366 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "name", "sex" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (1001, 5089, 5300, 1003, 5388) |
| 11:32:52.366 | 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 (5089, 1001, 5300, 1003, 5388)) |
| 11:32:52.367 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "contract_id", "remind_date" AS "name", "amount" AS "value", "overdue_days", "status" FROM "a57be577deb434"."tbl_sales_contract_payment_collection_remind_dates" WHERE "contract_id" IN (1076, 658, 1313, 192, 3553, 4043, 3710, 3711, 4022, 4083) ORDER BY "remind_date" |
| 11:32:52.368 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "contract_id", "amount" AS "value", "created_by", "created_at", "description", "collected_date", "amount" FROM (SELECT * FROM ((SELECT '1' || r.id::varchar as id, 1 as ticket_type, r.sales_contract_id as contract_id, r.amount as amount, t.created_at as collected_date, t.created_at, t.created_by, t.abstract as description FROM "a57be577deb434"."tbl_erp_collect_ticket_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_collect_tickets" "t" ON r.erp_collect_ticket_id = t.id WHERE (r.sales_contract_id is not null) AND ("t"."status" IN (2, 5, 1))) UNION ALL ( SELECT '2' || r.id::varchar as id, 2 as ticket_type, r.sales_contract_id as contract_id, r.amount as amount, t.created_at as collected_date, t.created_at, t.created_by, t.abstract as description FROM "a57be577deb434"."tbl_erp_cash_cost_ticket_sales_contract_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_cash_cost_tickets" "t" ON r.erp_cash_cost_ticket_id = t.id WHERE (r.sales_contract_id is not null) AND ("t"."status" IN (2, 5, 1)) ) UNION ALL ( SELECT '3' || r.id::varchar as id, 3 as ticket_type, r.sales_contract_id as contract_id, 0 - r.amount as amount, t.created_at as collected_date, t.created_at, t.created_by, t.abstract as description FROM "a57be577deb434"."tbl_erp_payment_ticket_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_payment_tickets" "t" ON r.erp_payment_ticket_id = t.id WHERE (r.sales_contract_id is not null) AND ("t"."status" IN (2, 5, 1)) )) "sub") "r" WHERE "contract_id" IN (1076, 658, 1313, 192, 3553, 4043, 3710, 3711, 4022, 4083) ORDER BY "id" DESC |
| 11:32:52.373 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (1013, 5388) |
| 11:32:52.374 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "contract_id", "amount" AS "value", "attachment_id", "from_date" FROM "a57be577deb434"."tbl_sales_contract_invoices" WHERE "contract_id" IN (1076, 658, 1313, 192, 3553, 4043, 3710, 3711, 4022, 4083) ORDER BY "id" |
| 11:32:52.375 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "name", "extension", "path", "orig_name" FROM "a57be577deb434"."tbl_attachments" WHERE "id"=5241 |
| 11:32:52.377 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=20) AND ("object_id" IN (485, 546, 559, 819, 1817, 1937, 1938, 2098, 2116, 2120)) |
| 11:32:52.381 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=102) AND ("object_id" IN (485, 546, 559, 819, 1817, 1937, 1938, 2098, 2116, 2120)) |
| 11:32:52.385 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "name", "extension", "path", "orig_name" FROM "a57be577deb434"."tbl_attachments" WHERE "id" IN (5241, 21744, 23734, 23733, 26962, 27217, 27596) |
| 11:32:52.391 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=105) AND ("object_id" IN (1076, 658, 1313, 192, 3553, 4043, 3710, 3711, 4022, 4083)) |
| 11:32:52.394 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "name", "extension", "path", "orig_name" FROM "a57be577deb434"."tbl_attachments" WHERE "id" IN (833, 1532, 3095, 4159, 21668, 23239, 23240, 26768, 26882, 27312) |
| 11:32:52.400 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=106) AND ("object_id" IN (1076, 658, 1313, 192, 3553, 4043, 3710, 3711, 4022, 4083)) |
| 11:32:52.403 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "name", "extension", "path", "orig_name" FROM "a57be577deb434"."tbl_attachments" WHERE "id" IN (1533, 3096, 4160, 22857, 23339, 23340, 26856, 27044, 27417) |
| 11:32:52.408 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=107) AND ("object_id" IN (1076, 658, 1313, 192, 3553, 4043, 3710, 3711, 4022, 4083)) |
| 11:32:52.411 | info | yii\db\Command::query | SELECT "object_id", count(*) AS unread FROM "a57be577deb434"."tbl_unread_comments" WHERE ("object_type"=7) AND (remind_user_id = 1000 AND is_read = false) AND ("object_id" IN (1076, 658, 1313, 192, 3553, 4043, 3710, 3711, 4022, 4083)) GROUP BY "object_id" |
| 11:32:52.428 | trace | uranus\rbac\DbManager::checkAccessFromCache | Checking permission: viewProduct |
| 11:32:52.428 | trace | uranus\rbac\DbManager::checkAccessFromCache | Checking role: StoreKeeper |
| 11:32:52.428 | trace | uranus\rbac\DbManager::checkAccessFromCache | Checking role: Admin |
| 11:32:52.429 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 11:32:52.429 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 11:32:52.430 | info | yii\db\Command::query | INSERT INTO "global"."tbl_api_log" ("code", "schema", "user_id", "device_type", "version_code", "url", "request", "response", "php_error", "time") VALUES (200, 'a57be577deb434', 1000, 6, 170, 'v2/sales-contract/list', '{"SalesContractSearch":{"keyword":"","contract_type":"","handler":"","contract_scan":"","receipt_scan":""},"Filter":{"name":"amount","sort":"ASC"},"page":"1","posttime":"1758252772","access_token":"hLtdglndkreOmfJjmOe7Mve0kQO2lAQu","device_type":"6","version_code":"170","token":"7a1e93b1adfde9aa6273e95c3ca3d6b0"}', '{"code":200,"data":{"list":[{"id":1076,"client_id":1312,"signed_at":"2019-06-18","amount":"49","handler":5089,"description":"TP-LINK\u5c0f\u4ea4\u6362\u673a","created_by":5015,"created_at":"2019-06-18 10:14:34","updated_at":"2021-06-28 17:16:46","contract_scan":3095,"receipt_scan":3096,"contract_type":1,"project_id":1205,"valid_date":null,"expire_date":"2020-06-17","sla":"","remind_ahead":"","expire_remind_ahead":"15 days","expire_reminded":true,"serial_no":"DGC-20190606101612269","payment_collection_remind_ahead":"1 day","from_project":1205,"receipt_date":null,"verify_date":null,"including_tax":true,"build_by_project":true,"need_analysis":true,"is_settle":false,"is_deliver":false,"is_outbound":false,"is_save_collection":true,"save_collection_at":"","is_verify":false,"is_draft":false,"erp_settle_amount":"49","erp_un_settle_amount":"0","erp_payment_ticket_is_verify":false,"erp_collect_ticket_is_verify":false,"erp_cash_cost_ticket_is_verify":false,"b_date":1920,"passed":2,"client":{"id":1312,"key":1312,"name":"(\u592e\u91c7\u7f51)\u4e2d\u56fd\u827a\u672f\u7814\u7a76\u9662","logo":null,"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"}}},"contractScan":{"id":3095,"key":3095,"name":"3f851a8f-9183-37cc-a81a-a95de3b5f8f5","orig_name":"\u4e2d\u56fd\u827a\u672f\u7814\u7a76\u9662.pdf","extension":"pdf","path":"\/v2\/attachment\/preview\/hLtdglndkreOmfJjmOe7Mve0kQO2lAQu\/3f851a8f-9183-37cc-a81a-a95de3b5f8f5\/\u4e2d\u56fd\u827a\u672f\u7814\u7a76\u9662.pdf","download":"\/vue\/attachment\/download?name=3f851a8f-9183-37cc-a81a-a95de3b5f8f5"},"receiptScan":{"id":3096,"key":3096,"name":"330adeda-a275-3b64-a181-26859f06a49e","orig_name":"\u4e2d\u56fd\u827a\u672f\u7814\u7a76\u9662.pdf","extension":"pdf","path":"\/v2\/attachment\/preview\/hLtdglndkreOmfJjmOe7Mve0kQO2lAQu\/330adeda-a275-3b64-a181-26859f06a49e\/\u4e2d\u56fd\u827a\u672f\u7814\u7a76\u9662.pdf","download":"\/vue\/attachment\/download?name=330adeda-a275-3b64-a181-26859f06a49e"},"createdBy":{"id":5015,"key":5015,"name":"\u5f20\u96ea\u677e","sex":"F","department_id":9,"avatar":{"id":5,"user_id":5015,"name":"\/files\/cdn\/a57be577deb434\/avatar\/7a105eb6-13c4-3990-9428-b163f97fe449.png"},"department":{"id":9,"key":9,"name":"\u9879\u76ee\u90e8"}},"commentCount":null,"project":{"id":1205,"key":1205,"name":"\u7f51\u7edc\u8bbe\u5907\u53ca\u914d\u4ef6\u91c7\u8d2d","erpSalesOrder":{"id":414,"serial_no":"XSDD-20190724-00001","from_date":null,"wrote_date":"2019-06-18","handler":5015,"client_id":1312,"purchase_contract_id":null,"project_id":1205,"sales_contract_id":1076,"erp_store_id":null,"status":2,"erp_send_type_id":null,"abstract":null,"description":"\u7f51\u7edc","verify_type":1,"next_verify_user":null,"next_stop_verify_user":null,"next_cancel_verify_user":null,"verify_at":"2019-07-24 15:14:59","stop_at":null,"cancel_at":null,"refuse_description":null,"is_resubmitted":false,"is_done":false,"number":"0","amount":"49","created_by":5015,"stop_description":null,"extra":null,"outbound_status":false,"is_used":false,"is_cancel":false,"is_settle":false,"is_old":true,"created_at":"2019-06-18 10:14:34","updated_at":"2019-07-24 15:14:59","erpSalesOrderVerifyRels":[],"erpSalesOrderStopVerifyRels":[]}},"fromProject":{"id":1205,"key":1205,"name":"\u7f51\u7edc\u8bbe\u5907\u53ca\u914d\u4ef6\u91c7\u8d2d","description":"TP-LINK\u5c0f\u4ea4\u6362\u673a","total_contact_point":null,"paid_contact_point":null,"is_sales_order_ready":false,"project_product_version_id":null,"bargain_date":"2019-06-18","collected":"49","profit_pct":"0","budget":"49","erpSalesOrder":{"id":414,"serial_no":"XSDD-20190724-00001","from_date":null,"wrote_date":"2019-06-18","handler":5015,"client_id":1312,"purchase_contract_id":null,"project_id":1205,"sales_contract_id":1076,"erp_store_id":null,"status":2,"erp_send_type_id":null,"abstract":null,"description":"\u7f51\u7edc","verify_type":1,"next_verify_user":null,"next_stop_verify_user":null,"next_cancel_verify_user":null,"verify_at":"2019-07-24 15:14:59","stop_at":null,"cancel_at":null,"refuse_description":null,"is_resubmitted":false,"is_done":false,"number":"0","amount":"49","created_by":5015,"stop_description":null,"extra":null,"outbound_status":false,"is_used":false,"is_cancel":false,"is_settle":false,"is_old":true,"created_at":"2019-06-18 10:14:34","updated_at":"2019-07-24 15:14:59"},"projectProductTypes":[{"id":3705,"product_type_id":85,"key":85,"name":"\u7f51\u7edc","budget":"49","pct":"0","project_id":1205,"profit":"0"}],"projectProductRels":[],"projectContactPoints":[],"buildSalesOrderItems":[],"reimbursementAmountSum":null,"profit":0,"contact_points_status_display":"\u672a\u8bbe\u7f6e"},"salesSupplierRels":[],"contractType":{"id":1,"key":1,"name":"\u4ea7\u54c1\u9500\u552e"},"handleBy":{"id":5089,"key":5089,"name":"\u5b59\u5a77\u5a77","sex":"F","department_id":1,"avatar":{"id":52,"user_id":5089,"name":"\/files\/cdn\/a57be577deb434\/avatar\/e3f43e80-a7e2-33bb-b317-0185418330b4.jpg"}},"remindDate":null,"serviceContractRemindDates":[],"salesContractRemindReceivers":[{"id":5841,"user_id":1011,"key":1011,"contract_id":1076,"user":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","avatar":{"id":17,"user_id":1011,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b54747f4-248d-380e-93bc-0f62f769e70d.png"}}},{"id":5842,"user_id":1013,"key":1013,"contract_id":1076,"user":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","avatar":{"id":34,"user_id":1013,"name":"\/files\/cdn\/a57be577deb434\/avatar\/25ef1fe7-8dda-3daa-b8ea-9fabd0a47439.png"}}},{"id":10776,"user_id":1001,"key":1001,"contract_id":1076,"user":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}}}],"serviceContractRemindReceivers":[],"salesContractPaymentCollectionRemindReceivers":[{"id":2722,"user_id":1001,"key":1001,"contract_id":1076,"user":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}}},{"id":2723,"user_id":5089,"key":5089,"contract_id":1076,"user":{"id":5089,"key":5089,"name":"\u5b59\u5a77\u5a77","sex":"F","avatar":{"id":52,"user_id":5089,"name":"\/files\/cdn\/a57be577deb434\/avatar\/e3f43e80-a7e2-33bb-b317-0185418330b4.jpg"}}}],"salesContractPaymentCollectionRemindDates":[{"id":51,"key":51,"contract_id":1076,"name":"2019-07-18","value":"49.00","overdue_days":null,"status":1,"pct":100,"collect_status":"\u5df2\u5b8c\u6210"}],"salesContractPayments":[{"id":"11946","key":"11946","contract_id":1076,"value":"49.00","created_by":null,"created_at":"2019-06-18 10:14:34","description":null,"collected_date":"2019-06-18 10:14:34","amount":"49.00","createdBy":null,"pct":100}],"salesContractInvoices":[{"id":546,"key":546,"contract_id":1076,"value":"49.00","attachment_id":null,"from_date":null,"attachment":null,"attachmentRelationships":[],"files":[]}],"contractScans":[{"id":12862,"object_type":105,"object_id":1076,"attachment_id":3095,"attachment":{"id":3095,"key":3095,"name":"3f851a8f-9183-37cc-a81a-a95de3b5f8f5","extension":"pdf","path":"\/v2\/attachment\/preview\/hLtdglndkreOmfJjmOe7Mve0kQO2lAQu\/3f851a8f-9183-37cc-a81a-a95de3b5f8f5\/\u4e2d\u56fd\u827a\u672f\u7814\u7a76\u9662.pdf","orig_name":"\u4e2d\u56fd\u827a\u672f\u7814\u7a76\u9662.pdf"}}],"receiptScans":[{"id":13535,"object_type":106,"object_id":1076,"attachment_id":3096,"attachment":{"id":3096,"key":3096,"name":"330adeda-a275-3b64-a181-26859f06a49e","extension":"pdf","path":"\/v2\/attachment\/preview\/hLtdglndkreOmfJjmOe7Mve0kQO2lAQu\/330adeda-a275-3b64-a181-26859f06a49e\/\u4e2d\u56fd\u827a\u672f\u7814\u7a76\u9662.pdf","orig_name":"\u4e2d\u56fd\u827a\u672f\u7814\u7a76\u9662.pdf"}}],"verifyScans":[],"unreadComments":null,"collected_plan":49,"projectProductTotalAmount":0,"projectProductAllAmount":true,"projectProductTotalCost":0,"projectProductAllCost":true,"projectProductTotalCount":0,"invoiced":49,"un_invoiced":0,"collected":"49","un_collected":0,"is_collected":true,"handlerPerson":{"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"}},"remind_date":"","remind_ahead_display":"\u65e0","expire_remind_ahead_display":"\u63d0\u524d15\u5929","payment_collection_remind_ahead_display":"\u63d0\u524d1\u5929","can_update":true,"can_delete":false,"unread":0,"bgcolor":"#89c541","can_view_product":true,"can_progress":true,"is_chargeback":false,"is_done":false},{"id":658,"client_id":12,"signed_at":"2018-08-20","amount":"145","handler":1003,"description":"1.\u5149\u76d8\u76d2 100\u4e2a","created_by":5015,"created_at":"2018-08-20 15:16:55","updated_at":"2021-06-25 17:18:13","contract_scan":1532,"receipt_scan":1533,"contract_type":1,"project_id":888,"valid_date":null,"expire_date":null,"sla":"","remind_ahead":"","expire_remind_ahead":"","expire_reminded":false,"serial_no":"-","payment_collection_remind_ahead":"","from_project":888,"receipt_date":null,"verify_date":null,"including_tax":true,"build_by_project":true,"need_analysis":true,"is_settle":false,"is_deliver":false,"is_outbound":false,"is_save_collection":true,"save_collection_at":"","is_verify":false,"is_draft":false,"erp_settle_amount":"145","erp_un_settle_amount":"0","erp_payment_ticket_is_verify":false,"erp_collect_ticket_is_verify":false,"erp_cash_cost_ticket_is_verify":false,"b_date":null,"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":null,"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"}}},"contractScan":{"id":1532,"key":1532,"name":"dc5c8933-434e-3bc7-8ae5-3f2d6a7d0c4a","orig_name":"smc.pdf","extension":"pdf","path":"\/v2\/attachment\/preview\/hLtdglndkreOmfJjmOe7Mve0kQO2lAQu\/dc5c8933-434e-3bc7-8ae5-3f2d6a7d0c4a\/smc.pdf","download":"\/vue\/attachment\/download?name=dc5c8933-434e-3bc7-8ae5-3f2d6a7d0c4a"},"receiptScan":{"id":1533,"key":1533,"name":"cd76cf35-c85f-3d1f-91ff-fdec77662288","orig_name":"smc.pdf","extension":"pdf","path":"\/v2\/attachment\/preview\/hLtdglndkreOmfJjmOe7Mve0kQO2lAQu\/cd76cf35-c85f-3d1f-91ff-fdec77662288\/smc.pdf","download":"\/vue\/attachment\/download?name=cd76cf35-c85f-3d1f-91ff-fdec77662288"},"createdBy":{"id":5015,"key":5015,"name":"\u5f20\u96ea\u677e","sex":"F","department_id":9,"avatar":{"id":5,"user_id":5015,"name":"\/files\/cdn\/a57be577deb434\/avatar\/7a105eb6-13c4-3990-9428-b163f97fe449.png"},"department":{"id":9,"key":9,"name":"\u9879\u76ee\u90e8"}},"commentCount":null,"project":{"id":888,"key":888,"name":"\u5e38\u89c4\u529e\u516c\u8bbe\u5907\u8017\u6750\u914d\u4ef6\u65b0\u589e\u9879\u76ee","erpSalesOrder":{"id":253,"serial_no":"XSDD-20190505-00001","from_date":null,"wrote_date":"2018-08-20","handler":5015,"client_id":12,"purchase_contract_id":null,"project_id":888,"sales_contract_id":658,"erp_store_id":null,"status":2,"erp_send_type_id":null,"abstract":null,"description":"\u914d\u4ef6","verify_type":1,"next_verify_user":null,"next_stop_verify_user":null,"next_cancel_verify_user":null,"verify_at":"2019-05-05 17:03:34","stop_at":null,"cancel_at":null,"refuse_description":null,"is_resubmitted":false,"is_done":false,"number":"0","amount":"145","created_by":5015,"stop_description":null,"extra":null,"outbound_status":false,"is_used":false,"is_cancel":false,"is_settle":false,"is_old":true,"created_at":"2018-08-20 15:16:55","updated_at":"2019-05-05 17:03:34","erpSalesOrderVerifyRels":[],"erpSalesOrderStopVerifyRels":[]}},"fromProject":{"id":888,"key":888,"name":"\u5e38\u89c4\u529e\u516c\u8bbe\u5907\u8017\u6750\u914d\u4ef6\u65b0\u589e\u9879\u76ee","description":"1.\u5149\u76d8\u76d2 100\u4e2a","total_contact_point":null,"paid_contact_point":null,"is_sales_order_ready":false,"project_product_version_id":null,"bargain_date":"2018-08-20","collected":"145","profit_pct":"36","budget":"145","erpSalesOrder":{"id":253,"serial_no":"XSDD-20190505-00001","from_date":null,"wrote_date":"2018-08-20","handler":5015,"client_id":12,"purchase_contract_id":null,"project_id":888,"sales_contract_id":658,"erp_store_id":null,"status":2,"erp_send_type_id":null,"abstract":null,"description":"\u914d\u4ef6","verify_type":1,"next_verify_user":null,"next_stop_verify_user":null,"next_cancel_verify_user":null,"verify_at":"2019-05-05 17:03:34","stop_at":null,"cancel_at":null,"refuse_description":null,"is_resubmitted":false,"is_done":false,"number":"0","amount":"145","created_by":5015,"stop_description":null,"extra":null,"outbound_status":false,"is_used":false,"is_cancel":false,"is_settle":false,"is_old":true,"created_at":"2018-08-20 15:16:55","updated_at":"2019-05-05 17:03:34"},"projectProductTypes":[{"id":4172,"product_type_id":86,"key":86,"name":"\u8ba1\u7b97","budget":"145","pct":"36","project_id":888,"profit":"52.2"}],"projectProductRels":[],"projectContactPoints":[],"buildSalesOrderItems":[],"reimbursementAmountSum":null,"profit":52.2,"contact_points_status_display":"\u672a\u8bbe\u7f6e"},"salesSupplierRels":[],"contractType":{"id":1,"key":1,"name":"\u4ea7\u54c1\u9500\u552e"},"handleBy":{"id":1003,"key":1003,"name":"\u5415\u5174\u5143","sex":"M","department_id":1,"avatar":{"id":11,"user_id":1003,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1003.png"}},"remindDate":null,"serviceContractRemindDates":[],"salesContractRemindReceivers":[{"id":7505,"user_id":5300,"key":5300,"contract_id":658,"user":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91","sex":"F","avatar":{"id":141,"user_id":5300,"name":"\/files\/cdn\/a57be577deb434\/avatar\/14dfd1a0-6df5-354a-8afd-f0a76fa8e852.png"}}}],"serviceContractRemindReceivers":[],"salesContractPaymentCollectionRemindReceivers":[],"salesContractPaymentCollectionRemindDates":[],"salesContractPayments":[{"id":"1450","key":"1450","contract_id":658,"value":"145.00","created_by":null,"created_at":"2018-08-20 15:16:55","description":null,"collected_date":"2018-08-20 15:16:55","amount":"145.00","createdBy":null,"pct":100}],"salesContractInvoices":[{"id":819,"key":819,"contract_id":658,"value":"145.00","attachment_id":null,"from_date":null,"attachment":null,"attachmentRelationships":[],"files":[]}],"contractScans":[{"id":12735,"object_type":105,"object_id":658,"attachment_id":1532,"attachment":{"id":1532,"key":1532,"name":"dc5c8933-434e-3bc7-8ae5-3f2d6a7d0c4a","extension":"pdf","path":"\/v2\/attachment\/preview\/hLtdglndkreOmfJjmOe7Mve0kQO2lAQu\/dc5c8933-434e-3bc7-8ae5-3f2d6a7d0c4a\/smc.pdf","orig_name":"smc.pdf"}}],"receiptScans":[{"id":13422,"object_type":106,"object_id":658,"attachment_id":1533,"attachment":{"id":1533,"key":1533,"name":"cd76cf35-c85f-3d1f-91ff-fdec77662288","extension":"pdf","path":"\/v2\/attachment\/preview\/hLtdglndkreOmfJjmOe7Mve0kQO2lAQu\/cd76cf35-c85f-3d1f-91ff-fdec77662288\/smc.pdf","orig_name":"smc.pdf"}}],"verifyScans":[],"unreadComments":null,"collected_plan":0,"projectProductTotalAmount":0,"projectProductAllAmount":true,"projectProductTotalCost":0,"projectProductAllCost":true,"projectProductTotalCount":0,"invoiced":145,"un_invoiced":0,"collected":"145","un_collected":0,"is_collected":true,"handlerPerson":{"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"}},"remind_date":"","remind_ahead_display":"\u65e0","expire_remind_ahead_display":"\u65e0","payment_collection_remind_ahead_display":"\u65e0","can_update":true,"can_delete":false,"unread":0,"bgcolor":"#89c541","can_view_product":true,"can_progress":true,"is_chargeback":false,"is_done":false},{"id":1313,"client_id":12,"signed_at":"2019-12-27","amount":"168.54","handler":1003,"description":"1.\u534e\u7855\u7b14\u8bb0\u672cA42-UL50 \u7535\u6c60 1\u5757","created_by":5015,"created_at":"2020-01-01 20:08:34","updated_at":"2021-06-24 16:11:03","contract_scan":4159,"receipt_scan":4160,"contract_type":1,"project_id":1613,"valid_date":null,"expire_date":"2020-12-25","sla":"","remind_ahead":"","expire_remind_ahead":"15 days","expire_reminded":true,"serial_no":"POC-19121545","payment_collection_remind_ahead":"1 day","from_project":1613,"receipt_date":null,"verify_date":null,"including_tax":true,"build_by_project":true,"need_analysis":true,"is_settle":false,"is_deliver":false,"is_outbound":false,"is_save_collection":true,"save_collection_at":"","is_verify":false,"is_draft":false,"erp_settle_amount":"168.54","erp_un_settle_amount":"0","erp_payment_ticket_is_verify":false,"erp_collect_ticket_is_verify":false,"erp_cash_cost_ticket_is_verify":false,"b_date":1729,"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":null,"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"}}},"contractScan":{"id":4159,"key":4159,"name":"332170e3-d42a-3950-8e7d-70cf01e773db","orig_name":"smc.pdf","extension":"pdf","path":"\/v2\/attachment\/preview\/hLtdglndkreOmfJjmOe7Mve0kQO2lAQu\/332170e3-d42a-3950-8e7d-70cf01e773db\/smc.pdf","download":"\/vue\/attachment\/download?name=332170e3-d42a-3950-8e7d-70cf01e773db"},"receiptScan":{"id":4160,"key":4160,"name":"01297cee-2c9b-394f-a719-30d762bc6bee","orig_name":"smc.pdf","extension":"pdf","path":"\/v2\/attachment\/preview\/hLtdglndkreOmfJjmOe7Mve0kQO2lAQu\/01297cee-2c9b-394f-a719-30d762bc6bee\/smc.pdf","download":"\/vue\/attachment\/download?name=01297cee-2c9b-394f-a719-30d762bc6bee"},"createdBy":{"id":5015,"key":5015,"name":"\u5f20\u96ea\u677e","sex":"F","department_id":9,"avatar":{"id":5,"user_id":5015,"name":"\/files\/cdn\/a57be577deb434\/avatar\/7a105eb6-13c4-3990-9428-b163f97fe449.png"},"department":{"id":9,"key":9,"name":"\u9879\u76ee\u90e8"}},"commentCount":null,"project":{"id":1613,"key":1613,"name":"\u529e\u516c\u8bbe\u5907\u65b0\u589e 20200101","erpSalesOrder":{"id":522,"serial_no":"XSDD-20210316-00001","from_date":null,"wrote_date":"2019-12-27","handler":5015,"client_id":12,"purchase_contract_id":null,"project_id":1613,"sales_contract_id":1313,"erp_store_id":null,"status":2,"erp_send_type_id":null,"abstract":null,"description":"\u529e\u516c","verify_type":1,"next_verify_user":null,"next_stop_verify_user":null,"next_cancel_verify_user":null,"verify_at":"2021-03-16 15:52:15","stop_at":null,"cancel_at":null,"refuse_description":null,"is_resubmitted":false,"is_done":false,"number":"0","amount":"168.54","created_by":5015,"stop_description":null,"extra":null,"outbound_status":false,"is_used":false,"is_cancel":false,"is_settle":false,"is_old":true,"created_at":"2020-01-01 20:08:34","updated_at":"2021-03-16 15:52:15","erpSalesOrderVerifyRels":[],"erpSalesOrderStopVerifyRels":[]}},"fromProject":{"id":1613,"key":1613,"name":"\u529e\u516c\u8bbe\u5907\u65b0\u589e 20200101","description":"1.\u534e\u7855\u7b14\u8bb0\u672cA42-UL50 \u7535\u6c60 1\u5757","total_contact_point":null,"paid_contact_point":null,"is_sales_order_ready":false,"project_product_version_id":null,"bargain_date":"2019-12-27","collected":"168.54","profit_pct":"3","budget":"168.54","erpSalesOrder":{"id":522,"serial_no":"XSDD-20210316-00001","from_date":null,"wrote_date":"2019-12-27","handler":5015,"client_id":12,"purchase_contract_id":null,"project_id":1613,"sales_contract_id":1313,"erp_store_id":null,"status":2,"erp_send_type_id":null,"abstract":null,"description":"\u529e\u516c","verify_type":1,"next_verify_user":null,"next_stop_verify_user":null,"next_cancel_verify_user":null,"verify_at":"2021-03-16 15:52:15","stop_at":null,"cancel_at":null,"refuse_description":null,"is_resubmitted":false,"is_done":false,"number":"0","amount":"168.54","created_by":5015,"stop_description":null,"extra":null,"outbound_status":false,"is_used":false,"is_cancel":false,"is_settle":false,"is_old":true,"created_at":"2020-01-01 20:08:34","updated_at":"2021-03-16 15:52:15"},"projectProductTypes":[{"id":4022,"product_type_id":86,"key":86,"name":"\u8ba1\u7b97","budget":"168.54","pct":"3","project_id":1613,"profit":"5.0562"}],"projectProductRels":[],"projectContactPoints":[],"buildSalesOrderItems":[],"reimbursementAmountSum":{"project_id":1613,"sum":"548.03"},"profit":5.0562,"contact_points_status_display":"\u672a\u8bbe\u7f6e"},"salesSupplierRels":[],"contractType":{"id":1,"key":1,"name":"\u4ea7\u54c1\u9500\u552e"},"handleBy":{"id":1003,"key":1003,"name":"\u5415\u5174\u5143","sex":"M","department_id":1,"avatar":{"id":11,"user_id":1003,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1003.png"}},"remindDate":null,"serviceContractRemindDates":[],"salesContractRemindReceivers":[{"id":5524,"user_id":1011,"key":1011,"contract_id":1313,"user":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","avatar":{"id":17,"user_id":1011,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b54747f4-248d-380e-93bc-0f62f769e70d.png"}}},{"id":7547,"user_id":5300,"key":5300,"contract_id":1313,"user":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91","sex":"F","avatar":{"id":141,"user_id":5300,"name":"\/files\/cdn\/a57be577deb434\/avatar\/14dfd1a0-6df5-354a-8afd-f0a76fa8e852.png"}}}],"serviceContractRemindReceivers":[],"salesContractPaymentCollectionRemindReceivers":[{"id":2581,"user_id":1001,"key":1001,"contract_id":1313,"user":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}}},{"id":2582,"user_id":1003,"key":1003,"contract_id":1313,"user":{"id":1003,"key":1003,"name":"\u5415\u5174\u5143","sex":"M","avatar":{"id":11,"user_id":1003,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1003.png"}}}],"salesContractPaymentCollectionRemindDates":[],"salesContractPayments":[{"id":"1461","key":"1461","contract_id":1313,"value":"168.54","created_by":null,"created_at":"2020-01-01 20:08:34","description":null,"collected_date":"2020-01-01 20:08:34","amount":"168.54","createdBy":null,"pct":100}],"salesContractInvoices":[{"id":559,"key":559,"contract_id":1313,"value":"168.54","attachment_id":5241,"from_date":"2020-04-07","attachment":{"id":5241,"key":5241,"name":"03435c2f-4d8f-3cd1-94a9-7830aeced501","extension":"pdf","path":"\/v2\/attachment\/preview\/hLtdglndkreOmfJjmOe7Mve0kQO2lAQu\/03435c2f-4d8f-3cd1-94a9-7830aeced501\/smc4\u6708.pdf","orig_name":"smc4\u6708.pdf"},"attachmentRelationships":[],"files":[{"id":6329,"object_type":102,"object_id":559,"attachment_id":5241,"attachment":{"id":5241,"key":5241,"name":"03435c2f-4d8f-3cd1-94a9-7830aeced501","extension":"pdf","path":"\/v2\/attachment\/view\/hLtdglndkreOmfJjmOe7Mve0kQO2lAQu\/03435c2f-4d8f-3cd1-94a9-7830aeced501\/smc4\u6708.pdf","orig_name":"smc4\u6708.pdf"}}]}],"contractScans":[{"id":12984,"object_type":105,"object_id":1313,"attachment_id":4159,"attachment":{"id":4159,"key":4159,"name":"332170e3-d42a-3950-8e7d-70cf01e773db","extension":"pdf","path":"\/v2\/attachment\/preview\/hLtdglndkreOmfJjmOe7Mve0kQO2lAQu\/332170e3-d42a-3950-8e7d-70cf01e773db\/smc.pdf","orig_name":"smc.pdf"}}],"receiptScans":[{"id":13625,"object_type":106,"object_id":1313,"attachment_id":4160,"attachment":{"id":4160,"key":4160,"name":"01297cee-2c9b-394f-a719-30d762bc6bee","extension":"pdf","path":"\/v2\/attachment\/preview\/hLtdglndkreOmfJjmOe7Mve0kQO2lAQu\/01297cee-2c9b-394f-a719-30d762bc6bee\/smc.pdf","orig_name":"smc.pdf"}}],"verifyScans":[],"unreadComments":null,"collected_plan":0,"projectProductTotalAmount":0,"projectProductAllAmount":true,"projectProductTotalCost":0,"projectProductAllCost":true,"projectProductTotalCount":0,"invoiced":168.54,"un_invoiced":0,"collected":"168.54","un_collected":0,"is_collected":true,"handlerPerson":{"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"}},"remind_date":"","remind_ahead_display":"\u65e0","expire_remind_ahead_display":"\u63d0\u524d15\u5929","payment_collection_remind_ahead_display":"\u63d0\u524d1\u5929","can_update":true,"can_delete":false,"unread":0,"bgcolor":"#89c541","can_view_product":true,"can_progress":true,"is_chargeback":false,"is_done":false},{"id":192,"client_id":57,"signed_at":"2017-07-19","amount":"200","handler":1006,"description":"ASA\u6392\u9519\u670d\u52a1","created_by":5015,"created_at":"2017-07-20 17:21:45","updated_at":"2021-06-23 17:02:34","contract_scan":833,"receipt_scan":null,"contract_type":2,"project_id":271,"valid_date":null,"expire_date":"2017-07-12","sla":"","remind_ahead":"","expire_remind_ahead":"","expire_reminded":true,"serial_no":"-","payment_collection_remind_ahead":"","from_project":271,"receipt_date":null,"verify_date":null,"including_tax":true,"build_by_project":true,"need_analysis":true,"is_settle":false,"is_deliver":false,"is_outbound":false,"is_save_collection":true,"save_collection_at":"","is_verify":false,"is_draft":false,"erp_settle_amount":"200","erp_un_settle_amount":"0","erp_payment_ticket_is_verify":false,"erp_collect_ticket_is_verify":false,"erp_cash_cost_ticket_is_verify":false,"b_date":2991,"passed":2,"client":{"id":57,"key":57,"name":"\u4fdd\u8bfa\u79d1\u6280(\u5317\u4eac)\u6709\u9650\u516c\u53f8\u3001\u4e0a\u6d77\u6da6\u8bfa\u3001\u4e2d\u56fd\u7535\u5b50\u7cfb\u7edf\u5de5\u7a0b\u7b2c\u4e8c\u5efa\u8bbe\u6709\u9650\u516c\u53f8,\u6851\u8fea\u4e9a\u533b\u836f\u6280\u672f(\u4e0a\u6d77)\u6709\u9650\u8d23\u4efb\u516c\u53f8","logo":null,"sales_rep":5332,"salesRep":{"id":5332,"key":5332,"name":"\u970d\u536b\u8d85","avatar":{"id":148,"user_id":5332,"name":"\/files\/cdn\/a57be577deb434\/avatar\/3a3eda91-ddc9-3633-8071-70a4c3d7180c.png"}}},"contractScan":{"id":833,"key":833,"name":"6f6de126-3241-3480-8dc7-4a82dabecced","orig_name":"\u4fdd\u8bfa\u79d1\u6280\uff08\u5317\u4eac\uff09\u6709\u9650\u516c\u53f8\u201420170711\u2014200.pdf","extension":"pdf","path":"\/v2\/attachment\/preview\/hLtdglndkreOmfJjmOe7Mve0kQO2lAQu\/6f6de126-3241-3480-8dc7-4a82dabecced\/\u4fdd\u8bfa\u79d1\u6280\uff08\u5317\u4eac\uff09\u6709\u9650\u516c\u53f8\u201420170711\u2014200.pdf","download":"\/vue\/attachment\/download?name=6f6de126-3241-3480-8dc7-4a82dabecced"},"receiptScan":null,"createdBy":{"id":5015,"key":5015,"name":"\u5f20\u96ea\u677e","sex":"F","department_id":9,"avatar":{"id":5,"user_id":5015,"name":"\/files\/cdn\/a57be577deb434\/avatar\/7a105eb6-13c4-3990-9428-b163f97fe449.png"},"department":{"id":9,"key":9,"name":"\u9879\u76ee\u90e8"}},"commentCount":{"object_id":192,"comment":5},"project":{"id":271,"key":271,"name":"ASA\u6280\u672f\u652f\u6301\u670d\u52a1","erpSalesOrder":{"id":72,"serial_no":"XSDD-20190505-00001","from_date":null,"wrote_date":"2017-07-20","handler":5015,"client_id":57,"purchase_contract_id":null,"project_id":271,"sales_contract_id":192,"erp_store_id":null,"status":2,"erp_send_type_id":null,"abstract":null,"description":"\u6545\u969c\u8bca\u65ad\uff0c\u4e00\u6b21\u6027","verify_type":1,"next_verify_user":null,"next_stop_verify_user":null,"next_cancel_verify_user":null,"verify_at":"2019-05-05 21:35:00","stop_at":null,"cancel_at":null,"refuse_description":null,"is_resubmitted":false,"is_done":false,"number":"0","amount":"200","created_by":5015,"stop_description":null,"extra":null,"outbound_status":false,"is_used":false,"is_cancel":false,"is_settle":false,"is_old":true,"created_at":"2017-07-20 17:21:45","updated_at":"2019-05-05 21:35:00","erpSalesOrderVerifyRels":[],"erpSalesOrderStopVerifyRels":[]}},"fromProject":{"id":271,"key":271,"name":"ASA\u6280\u672f\u652f\u6301\u670d\u52a1","description":"ASA\u6392\u9519\u670d\u52a1","total_contact_point":null,"paid_contact_point":null,"is_sales_order_ready":false,"project_product_version_id":null,"bargain_date":"2017-07-20","collected":"200","profit_pct":"100","budget":"200","erpSalesOrder":{"id":72,"serial_no":"XSDD-20190505-00001","from_date":null,"wrote_date":"2017-07-20","handler":5015,"client_id":57,"purchase_contract_id":null,"project_id":271,"sales_contract_id":192,"erp_store_id":null,"status":2,"erp_send_type_id":null,"abstract":null,"description":"\u6545\u969c\u8bca\u65ad\uff0c\u4e00\u6b21\u6027","verify_type":1,"next_verify_user":null,"next_stop_verify_user":null,"next_cancel_verify_user":null,"verify_at":"2019-05-05 21:35:00","stop_at":null,"cancel_at":null,"refuse_description":null,"is_resubmitted":false,"is_done":false,"number":"0","amount":"200","created_by":5015,"stop_description":null,"extra":null,"outbound_status":false,"is_used":false,"is_cancel":false,"is_settle":false,"is_old":true,"created_at":"2017-07-20 17:21:45","updated_at":"2019-05-05 21:35:00"},"projectProductTypes":[{"id":2084,"product_type_id":22,"key":22,"name":"\u670d\u52a1","budget":"200","pct":"100","project_id":271,"profit":"200"}],"projectProductRels":[],"projectContactPoints":[],"buildSalesOrderItems":[],"reimbursementAmountSum":null,"profit":200,"contact_points_status_display":"\u672a\u8bbe\u7f6e"},"salesSupplierRels":[],"contractType":{"id":2,"key":2,"name":"\u8fd0\u7ef4\u670d\u52a1"},"handleBy":{"id":1006,"key":1006,"name":"\u6731\u5bb8\u96e8","sex":"F","department_id":1,"avatar":{"id":3,"user_id":1006,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1006.jpg"}},"remindDate":null,"serviceContractRemindDates":[],"salesContractRemindReceivers":[{"id":10233,"user_id":5332,"key":5332,"contract_id":192,"user":{"id":5332,"key":5332,"name":"\u970d\u536b\u8d85","sex":"M","avatar":{"id":148,"user_id":5332,"name":"\/files\/cdn\/a57be577deb434\/avatar\/3a3eda91-ddc9-3633-8071-70a4c3d7180c.png"}}}],"serviceContractRemindReceivers":[],"salesContractPaymentCollectionRemindReceivers":[],"salesContractPaymentCollectionRemindDates":[],"salesContractPayments":[{"id":"11394","key":"11394","contract_id":192,"value":"200.00","created_by":null,"created_at":"2017-07-20 17:21:45","description":null,"collected_date":"2017-07-20 17:21:45","amount":"200.00","createdBy":null,"pct":100}],"salesContractInvoices":[{"id":485,"key":485,"contract_id":192,"value":"200.00","attachment_id":null,"from_date":null,"attachment":null,"attachmentRelationships":[],"files":[]}],"contractScans":[{"id":12666,"object_type":105,"object_id":192,"attachment_id":833,"attachment":{"id":833,"key":833,"name":"6f6de126-3241-3480-8dc7-4a82dabecced","extension":"pdf","path":"\/v2\/attachment\/preview\/hLtdglndkreOmfJjmOe7Mve0kQO2lAQu\/6f6de126-3241-3480-8dc7-4a82dabecced\/\u4fdd\u8bfa\u79d1\u6280\uff08\u5317\u4eac\uff09\u6709\u9650\u516c\u53f8\u201420170711\u2014200.pdf","orig_name":"\u4fdd\u8bfa\u79d1\u6280\uff08\u5317\u4eac\uff09\u6709\u9650\u516c\u53f8\u201420170711\u2014200.pdf"}}],"receiptScans":[],"verifyScans":[],"unreadComments":null,"collected_plan":0,"projectProductTotalAmount":0,"projectProductAllAmount":true,"projectProductTotalCost":0,"projectProductAllCost":true,"projectProductTotalCount":0,"invoiced":200,"un_invoiced":0,"collected":"200","un_collected":0,"is_collected":true,"handlerPerson":{"id":5332,"key":5332,"name":"\u970d\u536b\u8d85","avatar":{"id":148,"user_id":5332,"name":"\/files\/cdn\/a57be577deb434\/avatar\/3a3eda91-ddc9-3633-8071-70a4c3d7180c.png"}},"remind_date":"","remind_ahead_display":"\u65e0","expire_remind_ahead_display":"\u65e0","payment_collection_remind_ahead_display":"\u65e0","can_update":true,"can_delete":false,"unread":0,"bgcolor":"#89c541","can_view_product":true,"can_progress":true,"is_chargeback":false,"is_done":false},{"id":3553,"client_id":12,"signed_at":"2024-09-23","amount":"292","handler":5300,"description":"","created_by":5300,"created_at":"2024-09-23 16:19:50","updated_at":"2024-11-21 17:38:06","contract_scan":null,"receipt_scan":null,"contract_type":1,"project_id":3669,"valid_date":null,"expire_date":null,"sla":"","remind_ahead":"","expire_remind_ahead":"","expire_reminded":false,"serial_no":"SMC\u5929\u6d25\u8ba2\u5355POTJ24094705","payment_collection_remind_ahead":"7 days","from_project":3669,"receipt_date":null,"verify_date":null,"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":"2024-09-25 11:10:08","is_verify":false,"is_draft":false,"erp_settle_amount":"292","erp_un_settle_amount":"0","erp_payment_ticket_is_verify":false,"erp_collect_ticket_is_verify":false,"erp_cash_cost_ticket_is_verify":false,"b_date":null,"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":null,"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"}}},"contractScan":null,"receiptScan":null,"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"}},"commentCount":{"object_id":3553,"comment":8},"project":{"id":3669,"key":3669,"name":"POTJ24094705-\u6a21\u5757-SFP-GE-LX-SM1310-D-G-2024","erpSalesOrder":{"id":1356,"serial_no":"XSDD-20241015-00001","from_date":null,"wrote_date":"2024-09-23","handler":5300,"client_id":12,"purchase_contract_id":null,"project_id":3669,"sales_contract_id":3553,"erp_store_id":null,"status":2,"erp_send_type_id":null,"abstract":null,"description":"","verify_type":1,"next_verify_user":null,"next_stop_verify_user":null,"next_cancel_verify_user":null,"verify_at":"2024-10-15 10:08:30","stop_at":null,"cancel_at":null,"refuse_description":null,"is_resubmitted":false,"is_done":true,"number":"2","amount":"292","created_by":5300,"stop_description":null,"extra":null,"outbound_status":false,"is_used":false,"is_cancel":false,"is_settle":false,"is_old":true,"created_at":"2024-09-23 16:19:50","updated_at":"2024-10-15 10:08:30","erpSalesOrderVerifyRels":[],"erpSalesOrderStopVerifyRels":[]}},"fromProject":{"id":3669,"key":3669,"name":"POTJ24094705-\u6a21\u5757-SFP-GE-LX-SM1310-D-G-2024","description":"","total_contact_point":null,"paid_contact_point":null,"is_sales_order_ready":true,"project_product_version_id":593,"bargain_date":"2024-09-23","collected":"292","profit_pct":"19.45","budget":"292","erpSalesOrder":{"id":1356,"serial_no":"XSDD-20241015-00001","from_date":null,"wrote_date":"2024-09-23","handler":5300,"client_id":12,"purchase_contract_id":null,"project_id":3669,"sales_contract_id":3553,"erp_store_id":null,"status":2,"erp_send_type_id":null,"abstract":null,"description":"","verify_type":1,"next_verify_user":null,"next_stop_verify_user":null,"next_cancel_verify_user":null,"verify_at":"2024-10-15 10:08:30","stop_at":null,"cancel_at":null,"refuse_description":null,"is_resubmitted":false,"is_done":true,"number":"2","amount":"292","created_by":5300,"stop_description":null,"extra":null,"outbound_status":false,"is_used":false,"is_cancel":false,"is_settle":false,"is_old":true,"created_at":"2024-09-23 16:19:50","updated_at":"2024-10-15 10:08:30"},"projectProductTypes":[{"id":4428,"product_type_id":86,"key":86,"name":"\u8ba1\u7b97","budget":"292.00","pct":"19.45","project_id":3669,"profit":"56.794"}],"projectProductRels":[{"id":6475,"project_id":3669,"product_id":1677,"amount":"146","number":2,"cost":"110","description":"","supplier_id":626,"hardware_from":"2024-09-11","software_from":null,"maintenance_from":null,"hardware_to":"2027-12-10","software_to":null,"maintenance_to":null,"total_amount":"292","total_cost":"220","erp_sales_order_product_id":1247,"supplier":{"id":626,"key":626,"name":"\u5317\u4eac\u6167\u79d1\u5929\u6b63\u79d1\u6280\u6709\u9650\u516c\u53f8"},"product":{"id":1677,"name":"SFP-GE-LX-SM1310-D","product_type":4,"product_component":43,"product_brand":20,"product_serie":1425,"product_misc":null,"product_qa":null,"pn":"","description":"","created_by":1013,"created_at":"2024-07-15 13:57:05","updated_at":"2024-07-15 13:57:05","pinyin_shortcut":"SFPGELXSM1310D","product_unit":3,"is_renew":false,"productType":{"id":4,"key":4,"name":"\u7f51\u7edc\u8bbe\u5907 "},"productComponent":{"id":43,"key":43,"name":"\u7f51\u7edc\u8bbe\u5907\u914d\u4ef6"},"productBrand":{"id":20,"key":20,"name":"H3C"},"productSerie":{"id":1425,"key":1425,"name":"H3C SFP-GE-LX-SM1310-D \u5355\u6a21\u6a21\u5757"},"productUnit":{"id":3,"key":3,"name":"\u4e2a"}},"erpSalesOrderProduct":{"id":1247,"erp_sales_order_id":1356,"erp_store_id":null,"product_id":1677,"description":"","number":"2","outbound":"0","amount":"146","total_amount":"292","last_number":null,"last_amount":null,"last_total_amount":null,"cost":"110","total_cost":"220","supplier_id":626,"hardware_from":"2024-09-11","software_from":null,"maintenance_from":null,"hardware_to":"2027-12-10","software_to":null,"maintenance_to":null}}],"projectContactPoints":[],"buildSalesOrderItems":[{"id":9760,"project_id":3669},{"id":9761,"project_id":3669}],"reimbursementAmountSum":null,"profit":56.794,"contact_points_status_display":"\u672a\u8bbe\u7f6e"},"salesSupplierRels":[{"id":1927,"contract_id":3553,"supplier_id":626,"purchase_id":3569,"supplier":{"id":626,"key":626,"name":"\u5317\u4eac\u6167\u79d1\u5929\u6b63\u79d1\u6280\u6709\u9650\u516c\u53f8"},"purchase":{"id":3569,"key":3569,"serial_no":"TSKJ20240925-ZHF-001"}}],"contractType":{"id":1,"key":1,"name":"\u4ea7\u54c1\u9500\u552e"},"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":null,"serviceContractRemindDates":[],"salesContractRemindReceivers":[],"serviceContractRemindReceivers":[],"salesContractPaymentCollectionRemindReceivers":[{"id":6695,"user_id":5300,"key":5300,"contract_id":3553,"user":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91","sex":"F","avatar":{"id":141,"user_id":5300,"name":"\/files\/cdn\/a57be577deb434\/avatar\/14dfd1a0-6df5-354a-8afd-f0a76fa8e852.png"}}},{"id":6696,"user_id":5388,"key":5388,"contract_id":3553,"user":{"id":5388,"key":5388,"name":"\u6768\u71d5\u971e","sex":"F","avatar":{"id":156,"user_id":5388,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b8d4f68f-e736-3c38-9e2f-1ab47885b3d8.png"}}},{"id":6697,"user_id":1001,"key":1001,"contract_id":3553,"user":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}}}],"salesContractPaymentCollectionRemindDates":[{"id":2056,"key":2056,"contract_id":3553,"name":"2024-10-31","value":"292","overdue_days":null,"status":1,"pct":100,"collect_status":"\u5df2\u5b8c\u6210"}],"salesContractPayments":[{"id":"1130","key":"1130","contract_id":3553,"value":"292","created_by":1013,"created_at":"2024-10-15 10:08:29","description":null,"collected_date":"2024-10-15 10:08:29","amount":"292","createdBy":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","department_id":7},"pct":100}],"salesContractInvoices":[{"id":1817,"key":1817,"contract_id":3553,"value":"292.00","attachment_id":null,"from_date":"2024-09-29","attachment":null,"attachmentRelationships":[],"files":[{"id":29013,"object_type":102,"object_id":1817,"attachment_id":21744,"attachment":{"id":21744,"key":21744,"name":"d01707f5-ce60-3c35-9ba5-22e03b96113b","extension":"pdf","path":"\/v2\/attachment\/view\/hLtdglndkreOmfJjmOe7Mve0kQO2lAQu\/d01707f5-ce60-3c35-9ba5-22e03b96113b\/dzfp_24112000000142537878_SMC(\u5929\u6d25)\u5236\u9020\u6709\u9650\u516c\u53f8_20240929135946.pdf","orig_name":"dzfp_24112000000142537878_SMC(\u5929\u6d25)\u5236\u9020\u6709\u9650\u516c\u53f8_20240929135946.pdf"}}]}],"contractScans":[{"id":28993,"object_type":105,"object_id":3553,"attachment_id":21668,"attachment":{"id":21668,"key":21668,"name":"2b79748b-70f5-3f98-a09c-fc0eea32fbd5","extension":"png","path":"\/v2\/attachment\/preview\/hLtdglndkreOmfJjmOe7Mve0kQO2lAQu\/2b79748b-70f5-3f98-a09c-fc0eea32fbd5\/WechatIMG1176.png","orig_name":"WechatIMG1176.png"}}],"receiptScans":[{"id":30592,"object_type":106,"object_id":3553,"attachment_id":22857,"attachment":{"id":22857,"key":22857,"name":"07beef08-f4c3-3b86-a02d-6bc403065c63","extension":"pdf","path":"\/v2\/attachment\/preview\/hLtdglndkreOmfJjmOe7Mve0kQO2lAQu\/07beef08-f4c3-3b86-a02d-6bc403065c63\/WechatIMG1176_.pdf","orig_name":"WechatIMG1176_.pdf"}}],"verifyScans":[],"unreadComments":null,"collected_plan":292,"projectProductTotalAmount":292,"projectProductAllAmount":true,"projectProductTotalCost":220,"projectProductAllCost":true,"projectProductTotalCount":2,"invoiced":292,"un_invoiced":0,"collected":"292","un_collected":0,"is_collected":true,"handlerPerson":{"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"}},"remind_date":"","remind_ahead_display":"\u65e0","expire_remind_ahead_display":"\u65e0","payment_collection_remind_ahead_display":"\u63d0\u524d7\u5929","can_update":true,"can_delete":false,"unread":0,"bgcolor":"#89c541","can_view_product":true,"can_progress":true,"is_chargeback":false,"is_done":false},{"id":4043,"client_id":12,"signed_at":"2025-07-17","amount":"295","handler":5300,"description":"","created_by":5300,"created_at":"2025-07-17 11:24:36","updated_at":"2025-07-28 10:22:58","contract_scan":null,"receipt_scan":null,"contract_type":1,"project_id":3920,"valid_date":null,"expire_date":null,"sla":"","remind_ahead":"","expire_remind_ahead":"","expire_reminded":false,"serial_no":"SMC\u5929\u6d25\u8ba2\u5355POTJ25075740","payment_collection_remind_ahead":"1 day","from_project":3920,"receipt_date":null,"verify_date":null,"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-07-17 11:24:36","is_verify":false,"is_draft":false,"erp_settle_amount":"295","erp_un_settle_amount":"0","erp_payment_ticket_is_verify":false,"erp_collect_ticket_is_verify":false,"erp_cash_cost_ticket_is_verify":false,"b_date":null,"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":null,"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"}}},"contractScan":null,"receiptScan":null,"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"}},"commentCount":{"object_id":4043,"comment":7},"project":{"id":3920,"key":3920,"name":"OTJ25075740-\u5185\u5b58-2025","erpSalesOrder":{"id":1545,"serial_no":"XSDD-20250731-00001","from_date":null,"wrote_date":"2025-07-17","handler":5300,"client_id":12,"purchase_contract_id":null,"project_id":3920,"sales_contract_id":4043,"erp_store_id":null,"status":2,"erp_send_type_id":null,"abstract":null,"description":"","verify_type":1,"next_verify_user":null,"next_stop_verify_user":null,"next_cancel_verify_user":null,"verify_at":"","stop_at":null,"cancel_at":null,"refuse_description":null,"is_resubmitted":false,"is_done":true,"number":"1","amount":"295","created_by":5300,"stop_description":null,"extra":null,"outbound_status":false,"is_used":false,"is_cancel":false,"is_settle":false,"is_old":true,"created_at":"2025-07-17 11:24:36","updated_at":"2025-07-17 11:24:36","erpSalesOrderVerifyRels":[],"erpSalesOrderStopVerifyRels":[]}},"fromProject":{"id":3920,"key":3920,"name":"OTJ25075740-\u5185\u5b58-2025","description":"","total_contact_point":null,"paid_contact_point":null,"is_sales_order_ready":true,"project_product_version_id":946,"bargain_date":"2025-07-17","collected":"295","profit_pct":"26.68","budget":"295","erpSalesOrder":{"id":1545,"serial_no":"XSDD-20250731-00001","from_date":null,"wrote_date":"2025-07-17","handler":5300,"client_id":12,"purchase_contract_id":null,"project_id":3920,"sales_contract_id":4043,"erp_store_id":null,"status":2,"erp_send_type_id":null,"abstract":null,"description":"","verify_type":1,"next_verify_user":null,"next_stop_verify_user":null,"next_cancel_verify_user":null,"verify_at":"","stop_at":null,"cancel_at":null,"refuse_description":null,"is_resubmitted":false,"is_done":true,"number":"1","amount":"295","created_by":5300,"stop_description":null,"extra":null,"outbound_status":false,"is_used":false,"is_cancel":false,"is_settle":false,"is_old":true,"created_at":"2025-07-17 11:24:36","updated_at":"2025-07-17 11:24:36"},"projectProductTypes":[{"id":6810,"product_type_id":2,"key":2,"name":"\u670d\u52a1\u5668","budget":"295","pct":"26.68","project_id":3920,"profit":"78.70"}],"projectProductRels":[{"id":10518,"project_id":3920,"product_id":1690,"amount":"295.00","number":1,"cost":"197.75","description":"","supplier_id":608,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null,"total_amount":"295","total_cost":"197.75","erp_sales_order_product_id":1791,"supplier":{"id":608,"key":608,"name":"\u6dd8\u5b9d\u7f51"},"product":{"id":1690,"name":"16GB DDR4-3200\u5185\u5b58","product_type":11,"product_component":179,"product_brand":10,"product_serie":1438,"product_misc":null,"product_qa":null,"pn":"","description":"","created_by":1013,"created_at":"2024-07-25 17:45:24","updated_at":"2024-07-25 17:45:24","pinyin_shortcut":"16GBDDR43200nc","product_unit":6,"is_renew":false,"productType":{"id":11,"key":11,"name":"\u4e2a\u4eba\u8ba1\u7b97\u673a"},"productComponent":{"id":179,"key":179,"name":"\u914d\u4ef6"},"productBrand":{"id":10,"key":10,"name":"\u4e09\u661f"},"productSerie":{"id":1438,"key":1438,"name":"\u4e09\u661f 16G DDR4 3200 \u5185\u5b58"},"productUnit":{"id":6,"key":6,"name":"\u6761"}},"erpSalesOrderProduct":{"id":1791,"erp_sales_order_id":1545,"erp_store_id":null,"product_id":1690,"description":"","number":"1","outbound":"0","amount":"295.00","total_amount":"295","last_number":null,"last_amount":null,"last_total_amount":null,"cost":"197.75","total_cost":"197.75","supplier_id":608,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null}}],"projectContactPoints":[],"buildSalesOrderItems":[{"id":13165,"project_id":3920}],"reimbursementAmountSum":null,"profit":78.706,"contact_points_status_display":"\u672a\u8bbe\u7f6e"},"salesSupplierRels":[{"id":3036,"contract_id":4043,"supplier_id":608,"purchase_id":4045,"supplier":{"id":608,"key":608,"name":"\u6dd8\u5b9d\u7f51"},"purchase":{"id":4045,"key":4045,"serial_no":"\u8ba2\u5355\u53f7: 4635961815999592710"}}],"contractType":{"id":1,"key":1,"name":"\u4ea7\u54c1\u9500\u552e"},"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":null,"serviceContractRemindDates":[],"salesContractRemindReceivers":[],"serviceContractRemindReceivers":[],"salesContractPaymentCollectionRemindReceivers":[{"id":8757,"user_id":5300,"key":5300,"contract_id":4043,"user":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91","sex":"F","avatar":{"id":141,"user_id":5300,"name":"\/files\/cdn\/a57be577deb434\/avatar\/14dfd1a0-6df5-354a-8afd-f0a76fa8e852.png"}}}],"salesContractPaymentCollectionRemindDates":[{"id":2504,"key":2504,"contract_id":4043,"name":"2025-08-22","value":"295","overdue_days":null,"status":1,"pct":100,"collect_status":"\u5df2\u5b8c\u6210"}],"salesContractPayments":[{"id":"11999","key":"11999","contract_id":4043,"value":"295","created_by":5388,"created_at":"2025-08-11 11:00:29","description":"\u6536\u6c47\u6b3e SMC\uff08\u5929\u6d25\uff09","collected_date":"2025-08-11 11:00:29","amount":"295","createdBy":{"id":5388,"key":5388,"name":"\u6768\u71d5\u971e","sex":"F","department_id":6},"pct":100}],"salesContractInvoices":[{"id":2116,"key":2116,"contract_id":4043,"value":"295.00","attachment_id":null,"from_date":"2025-08-01","attachment":null,"attachmentRelationships":[],"files":[{"id":36216,"object_type":102,"object_id":2116,"attachment_id":27217,"attachment":{"id":27217,"key":27217,"name":"4b05d295-b57c-3012-ab4b-c7813791dc95","extension":"pdf","path":"\/v2\/attachment\/view\/hLtdglndkreOmfJjmOe7Mve0kQO2lAQu\/4b05d295-b57c-3012-ab4b-c7813791dc95\/dzfp_25112000000160738872_SMC(\u5929\u6d25)\u5236\u9020\u6709\u9650\u516c\u53f8_20250801100050.pdf","orig_name":"dzfp_25112000000160738872_SMC(\u5929\u6d25)\u5236\u9020\u6709\u9650\u516c\u53f8_20250801100050.pdf"}}]}],"contractScans":[{"id":36078,"object_type":105,"object_id":4043,"attachment_id":26882,"attachment":{"id":26882,"key":26882,"name":"815df5b4-9d78-347e-a340-930553be61ca","extension":"pdf","path":"\/v2\/attachment\/preview\/hLtdglndkreOmfJjmOe7Mve0kQO2lAQu\/815df5b4-9d78-347e-a340-930553be61ca\/POTJ25075740.pdf","orig_name":"POTJ25075740.pdf"}}],"receiptScans":[{"id":35985,"object_type":106,"object_id":4043,"attachment_id":27044,"attachment":{"id":27044,"key":27044,"name":"206a557e-6e0e-30a9-b772-ec5b4960faa3","extension":"jpg","path":"\/v2\/attachment\/preview\/hLtdglndkreOmfJjmOe7Mve0kQO2lAQu\/206a557e-6e0e-30a9-b772-ec5b4960faa3\/17511753242028_.pic.jpg","orig_name":"17511753242028_.pic.jpg"}}],"verifyScans":[],"unreadComments":null,"collected_plan":295,"projectProductTotalAmount":295,"projectProductAllAmount":true,"projectProductTotalCost":197.75,"projectProductAllCost":true,"projectProductTotalCount":1,"invoiced":295,"un_invoiced":0,"collected":"295","un_collected":0,"is_collected":true,"handlerPerson":{"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"}},"remind_date":"","remind_ahead_display":"\u65e0","expire_remind_ahead_display":"\u65e0","payment_collection_remind_ahead_display":"\u63d0\u524d1\u5929","can_update":true,"can_delete":false,"unread":0,"bgcolor":"#89c541","can_view_product":true,"can_progress":true,"is_chargeback":false,"is_done":false},{"id":3710,"client_id":12,"signed_at":"2024-12-16","amount":"295","handler":5300,"description":"","created_by":5300,"created_at":"2024-12-16 17:20:57","updated_at":"2024-12-23 09:08:39","contract_scan":null,"receipt_scan":null,"contract_type":1,"project_id":3741,"valid_date":null,"expire_date":null,"sla":"","remind_ahead":"","expire_remind_ahead":"","expire_reminded":false,"serial_no":"SMC\u5317\u4eac\u8ba2\u5355POBJ24122976","payment_collection_remind_ahead":"7 days","from_project":3741,"receipt_date":null,"verify_date":null,"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":"2024-12-19 15:15:42","is_verify":false,"is_draft":false,"erp_settle_amount":"295","erp_un_settle_amount":"0","erp_payment_ticket_is_verify":false,"erp_collect_ticket_is_verify":false,"erp_cash_cost_ticket_is_verify":false,"b_date":null,"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":null,"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"}}},"contractScan":null,"receiptScan":null,"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"}},"commentCount":{"object_id":3710,"comment":10},"project":{"id":3741,"key":3741,"name":"POBJ24122976-\u5185\u5b58\u6761-G-2024","erpSalesOrder":{"id":1409,"serial_no":"XSDD-20250210-00001","from_date":null,"wrote_date":"2024-12-16","handler":5300,"client_id":12,"purchase_contract_id":null,"project_id":3741,"sales_contract_id":3710,"erp_store_id":null,"status":2,"erp_send_type_id":null,"abstract":null,"description":"","verify_type":1,"next_verify_user":null,"next_stop_verify_user":null,"next_cancel_verify_user":null,"verify_at":"2025-02-10 13:11:26","stop_at":null,"cancel_at":null,"refuse_description":null,"is_resubmitted":false,"is_done":true,"number":"1","amount":"295","created_by":5300,"stop_description":null,"extra":null,"outbound_status":false,"is_used":false,"is_cancel":false,"is_settle":false,"is_old":true,"created_at":"2024-12-16 17:20:57","updated_at":"2025-02-10 13:11:26","erpSalesOrderVerifyRels":[],"erpSalesOrderStopVerifyRels":[]}},"fromProject":{"id":3741,"key":3741,"name":"POBJ24122976-\u5185\u5b58\u6761-G-2024","description":"","total_contact_point":null,"paid_contact_point":null,"is_sales_order_ready":true,"project_product_version_id":714,"bargain_date":"2024-12-16","collected":"295","profit_pct":"27.79","budget":"295","erpSalesOrder":{"id":1409,"serial_no":"XSDD-20250210-00001","from_date":null,"wrote_date":"2024-12-16","handler":5300,"client_id":12,"purchase_contract_id":null,"project_id":3741,"sales_contract_id":3710,"erp_store_id":null,"status":2,"erp_send_type_id":null,"abstract":null,"description":"","verify_type":1,"next_verify_user":null,"next_stop_verify_user":null,"next_cancel_verify_user":null,"verify_at":"2025-02-10 13:11:26","stop_at":null,"cancel_at":null,"refuse_description":null,"is_resubmitted":false,"is_done":true,"number":"1","amount":"295","created_by":5300,"stop_description":null,"extra":null,"outbound_status":false,"is_used":false,"is_cancel":false,"is_settle":false,"is_old":true,"created_at":"2024-12-16 17:20:57","updated_at":"2025-02-10 13:11:26"},"projectProductTypes":[{"id":5737,"product_type_id":2,"key":2,"name":"\u670d\u52a1\u5668","budget":"295.00","pct":"27.79","project_id":3741,"profit":"81.9805"}],"projectProductRels":[{"id":8057,"project_id":3741,"product_id":1690,"amount":"295.00","number":1,"cost":"194.00","description":"","supplier_id":608,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null,"total_amount":"295","total_cost":"194","erp_sales_order_product_id":1439,"supplier":{"id":608,"key":608,"name":"\u6dd8\u5b9d\u7f51"},"product":{"id":1690,"name":"16GB DDR4-3200\u5185\u5b58","product_type":11,"product_component":179,"product_brand":10,"product_serie":1438,"product_misc":null,"product_qa":null,"pn":"","description":"","created_by":1013,"created_at":"2024-07-25 17:45:24","updated_at":"2024-07-25 17:45:24","pinyin_shortcut":"16GBDDR43200nc","product_unit":6,"is_renew":false,"productType":{"id":11,"key":11,"name":"\u4e2a\u4eba\u8ba1\u7b97\u673a"},"productComponent":{"id":179,"key":179,"name":"\u914d\u4ef6"},"productBrand":{"id":10,"key":10,"name":"\u4e09\u661f"},"productSerie":{"id":1438,"key":1438,"name":"\u4e09\u661f 16G DDR4 3200 \u5185\u5b58"},"productUnit":{"id":6,"key":6,"name":"\u6761"}},"erpSalesOrderProduct":{"id":1439,"erp_sales_order_id":1409,"erp_store_id":null,"product_id":1690,"description":"","number":"1","outbound":"0","amount":"295.00","total_amount":"295","last_number":null,"last_amount":null,"last_total_amount":null,"cost":"194.00","total_cost":"194","supplier_id":608,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null}}],"projectContactPoints":[],"buildSalesOrderItems":[{"id":12372,"project_id":3741}],"reimbursementAmountSum":null,"profit":81.9805,"contact_points_status_display":"\u672a\u8bbe\u7f6e"},"salesSupplierRels":[{"id":2219,"contract_id":3710,"supplier_id":608,"purchase_id":3712,"supplier":{"id":608,"key":608,"name":"\u6dd8\u5b9d\u7f51"},"purchase":{"id":3712,"key":3712,"serial_no":"WX20241216-174142@2x"}}],"contractType":{"id":1,"key":1,"name":"\u4ea7\u54c1\u9500\u552e"},"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":null,"serviceContractRemindDates":[],"salesContractRemindReceivers":[],"serviceContractRemindReceivers":[],"salesContractPaymentCollectionRemindReceivers":[{"id":7393,"user_id":5300,"key":5300,"contract_id":3710,"user":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91","sex":"F","avatar":{"id":141,"user_id":5300,"name":"\/files\/cdn\/a57be577deb434\/avatar\/14dfd1a0-6df5-354a-8afd-f0a76fa8e852.png"}}},{"id":7394,"user_id":5388,"key":5388,"contract_id":3710,"user":{"id":5388,"key":5388,"name":"\u6768\u71d5\u971e","sex":"F","avatar":{"id":156,"user_id":5388,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b8d4f68f-e736-3c38-9e2f-1ab47885b3d8.png"}}},{"id":7395,"user_id":1001,"key":1001,"contract_id":3710,"user":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}}}],"salesContractPaymentCollectionRemindDates":[{"id":2214,"key":2214,"contract_id":3710,"name":"2025-01-31","value":"295","overdue_days":10,"status":1,"pct":100,"collect_status":"\u5df2\u5b8c\u6210"}],"salesContractPayments":[{"id":"1205","key":"1205","contract_id":3710,"value":"295","created_by":1013,"created_at":"2025-02-10 13:11:26","description":null,"collected_date":"2025-02-10 13:11:26","amount":"295","createdBy":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","department_id":7},"pct":100}],"salesContractInvoices":[{"id":1937,"key":1937,"contract_id":3710,"value":"295.00","attachment_id":null,"from_date":"2025-01-14","attachment":null,"attachmentRelationships":[],"files":[{"id":31962,"object_type":102,"object_id":1937,"attachment_id":23733,"attachment":{"id":23733,"key":23733,"name":"69c9454e-b4c9-3355-8bde-9d7eb5e0e09b","extension":"pdf","path":"\/v2\/attachment\/view\/hLtdglndkreOmfJjmOe7Mve0kQO2lAQu\/69c9454e-b4c9-3355-8bde-9d7eb5e0e09b\/dzfp_25112000000010662300_SMC\uff08\u5317\u4eac\uff09\u5236\u9020\u6709\u9650\u516c\u53f8_20250114112036.pdf","orig_name":"dzfp_25112000000010662300_SMC\uff08\u5317\u4eac\uff09\u5236\u9020\u6709\u9650\u516c\u53f8_20250114112036.pdf"}}]}],"contractScans":[{"id":31229,"object_type":105,"object_id":3710,"attachment_id":23240,"attachment":{"id":23240,"key":23240,"name":"e69f7898-b51b-3f4b-b615-36f886ca964c","extension":"pdf","path":"\/v2\/attachment\/preview\/hLtdglndkreOmfJjmOe7Mve0kQO2lAQu\/e69f7898-b51b-3f4b-b615-36f886ca964c\/POBJ24122976.pdf","orig_name":"POBJ24122976.pdf"}}],"receiptScans":[{"id":31255,"object_type":106,"object_id":3710,"attachment_id":23339,"attachment":{"id":23339,"key":23339,"name":"bfbd297a-a2be-3c0d-89fa-0384befd2c79","extension":"pdf","path":"\/v2\/attachment\/preview\/hLtdglndkreOmfJjmOe7Mve0kQO2lAQu\/bfbd297a-a2be-3c0d-89fa-0384befd2c79\/\u7b7e\u6536\u5355.pdf","orig_name":"\u7b7e\u6536\u5355.pdf"}}],"verifyScans":[],"unreadComments":null,"collected_plan":295,"projectProductTotalAmount":295,"projectProductAllAmount":true,"projectProductTotalCost":194,"projectProductAllCost":true,"projectProductTotalCount":1,"invoiced":295,"un_invoiced":0,"collected":"295","un_collected":0,"is_collected":true,"handlerPerson":{"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"}},"remind_date":"","remind_ahead_display":"\u65e0","expire_remind_ahead_display":"\u65e0","payment_collection_remind_ahead_display":"\u63d0\u524d7\u5929","can_update":true,"can_delete":false,"unread":0,"bgcolor":"#89c541","can_view_product":true,"can_progress":true,"is_chargeback":false,"is_done":false},{"id":3711,"client_id":12,"signed_at":"2024-12-16","amount":"295","handler":5300,"description":"","created_by":5300,"created_at":"2024-12-16 17:22:26","updated_at":"2024-12-23 09:09:12","contract_scan":null,"receipt_scan":null,"contract_type":1,"project_id":3742,"valid_date":null,"expire_date":null,"sla":"","remind_ahead":"","expire_remind_ahead":"","expire_reminded":false,"serial_no":"SMC\u5317\u4eac\u8ba2\u5355POBJ24123906","payment_collection_remind_ahead":"7 days","from_project":3742,"receipt_date":null,"verify_date":null,"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":"2024-12-19 15:16:21","is_verify":false,"is_draft":false,"erp_settle_amount":"295","erp_un_settle_amount":"0","erp_payment_ticket_is_verify":false,"erp_collect_ticket_is_verify":false,"erp_cash_cost_ticket_is_verify":false,"b_date":null,"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":null,"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"}}},"contractScan":null,"receiptScan":null,"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"}},"commentCount":{"object_id":3711,"comment":10},"project":{"id":3742,"key":3742,"name":"POBJ24123906-\u5185\u5b58\u6761-G-2024","erpSalesOrder":{"id":1410,"serial_no":"XSDD-20250210-00001","from_date":null,"wrote_date":"2024-12-16","handler":5300,"client_id":12,"purchase_contract_id":null,"project_id":3742,"sales_contract_id":3711,"erp_store_id":null,"status":2,"erp_send_type_id":null,"abstract":null,"description":"","verify_type":1,"next_verify_user":null,"next_stop_verify_user":null,"next_cancel_verify_user":null,"verify_at":"2025-02-10 13:10:54","stop_at":null,"cancel_at":null,"refuse_description":null,"is_resubmitted":false,"is_done":true,"number":"1","amount":"295","created_by":5300,"stop_description":null,"extra":null,"outbound_status":false,"is_used":false,"is_cancel":false,"is_settle":false,"is_old":true,"created_at":"2024-12-16 17:22:26","updated_at":"2025-02-10 13:10:54","erpSalesOrderVerifyRels":[],"erpSalesOrderStopVerifyRels":[]}},"fromProject":{"id":3742,"key":3742,"name":"POBJ24123906-\u5185\u5b58\u6761-G-2024","description":"","total_contact_point":null,"paid_contact_point":null,"is_sales_order_ready":true,"project_product_version_id":713,"bargain_date":"2024-12-16","collected":"295","profit_pct":"27.79","budget":"295","erpSalesOrder":{"id":1410,"serial_no":"XSDD-20250210-00001","from_date":null,"wrote_date":"2024-12-16","handler":5300,"client_id":12,"purchase_contract_id":null,"project_id":3742,"sales_contract_id":3711,"erp_store_id":null,"status":2,"erp_send_type_id":null,"abstract":null,"description":"","verify_type":1,"next_verify_user":null,"next_stop_verify_user":null,"next_cancel_verify_user":null,"verify_at":"2025-02-10 13:10:54","stop_at":null,"cancel_at":null,"refuse_description":null,"is_resubmitted":false,"is_done":true,"number":"1","amount":"295","created_by":5300,"stop_description":null,"extra":null,"outbound_status":false,"is_used":false,"is_cancel":false,"is_settle":false,"is_old":true,"created_at":"2024-12-16 17:22:26","updated_at":"2025-02-10 13:10:54"},"projectProductTypes":[{"id":5736,"product_type_id":2,"key":2,"name":"\u670d\u52a1\u5668","budget":"295.00","pct":"27.79","project_id":3742,"profit":"81.9805"}],"projectProductRels":[{"id":8056,"project_id":3742,"product_id":1690,"amount":"295","number":1,"cost":"194.00","description":"","supplier_id":608,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null,"total_amount":"295.00","total_cost":"194","erp_sales_order_product_id":1440,"supplier":{"id":608,"key":608,"name":"\u6dd8\u5b9d\u7f51"},"product":{"id":1690,"name":"16GB DDR4-3200\u5185\u5b58","product_type":11,"product_component":179,"product_brand":10,"product_serie":1438,"product_misc":null,"product_qa":null,"pn":"","description":"","created_by":1013,"created_at":"2024-07-25 17:45:24","updated_at":"2024-07-25 17:45:24","pinyin_shortcut":"16GBDDR43200nc","product_unit":6,"is_renew":false,"productType":{"id":11,"key":11,"name":"\u4e2a\u4eba\u8ba1\u7b97\u673a"},"productComponent":{"id":179,"key":179,"name":"\u914d\u4ef6"},"productBrand":{"id":10,"key":10,"name":"\u4e09\u661f"},"productSerie":{"id":1438,"key":1438,"name":"\u4e09\u661f 16G DDR4 3200 \u5185\u5b58"},"productUnit":{"id":6,"key":6,"name":"\u6761"}},"erpSalesOrderProduct":{"id":1440,"erp_sales_order_id":1410,"erp_store_id":null,"product_id":1690,"description":"","number":"1","outbound":"0","amount":"295","total_amount":"295.00","last_number":null,"last_amount":null,"last_total_amount":null,"cost":"194.00","total_cost":"194","supplier_id":608,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null}}],"projectContactPoints":[],"buildSalesOrderItems":[{"id":12371,"project_id":3742}],"reimbursementAmountSum":null,"profit":81.9805,"contact_points_status_display":"\u672a\u8bbe\u7f6e"},"salesSupplierRels":[{"id":2218,"contract_id":3711,"supplier_id":608,"purchase_id":3712,"supplier":{"id":608,"key":608,"name":"\u6dd8\u5b9d\u7f51"},"purchase":{"id":3712,"key":3712,"serial_no":"WX20241216-174142@2x"}}],"contractType":{"id":1,"key":1,"name":"\u4ea7\u54c1\u9500\u552e"},"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":null,"serviceContractRemindDates":[],"salesContractRemindReceivers":[],"serviceContractRemindReceivers":[],"salesContractPaymentCollectionRemindReceivers":[{"id":7390,"user_id":5300,"key":5300,"contract_id":3711,"user":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91","sex":"F","avatar":{"id":141,"user_id":5300,"name":"\/files\/cdn\/a57be577deb434\/avatar\/14dfd1a0-6df5-354a-8afd-f0a76fa8e852.png"}}},{"id":7391,"user_id":5388,"key":5388,"contract_id":3711,"user":{"id":5388,"key":5388,"name":"\u6768\u71d5\u971e","sex":"F","avatar":{"id":156,"user_id":5388,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b8d4f68f-e736-3c38-9e2f-1ab47885b3d8.png"}}},{"id":7392,"user_id":1001,"key":1001,"contract_id":3711,"user":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}}}],"salesContractPaymentCollectionRemindDates":[{"id":2215,"key":2215,"contract_id":3711,"name":"2025-01-31","value":"295","overdue_days":10,"status":1,"pct":100,"collect_status":"\u5df2\u5b8c\u6210"}],"salesContractPayments":[{"id":"1251","key":"1251","contract_id":3711,"value":"295","created_by":1013,"created_at":"2025-02-10 13:10:54","description":null,"collected_date":"2025-02-10 13:10:54","amount":"295","createdBy":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","department_id":7},"pct":100}],"salesContractInvoices":[{"id":1938,"key":1938,"contract_id":3711,"value":"295.00","attachment_id":null,"from_date":"2025-01-14","attachment":null,"attachmentRelationships":[],"files":[{"id":31832,"object_type":102,"object_id":1938,"attachment_id":23734,"attachment":{"id":23734,"key":23734,"name":"621f17d5-3d63-3be6-bb12-23abd3907e73","extension":"pdf","path":"\/v2\/attachment\/view\/hLtdglndkreOmfJjmOe7Mve0kQO2lAQu\/621f17d5-3d63-3be6-bb12-23abd3907e73\/dzfp_25112000000010820499_SMC\uff08\u5317\u4eac\uff09\u5236\u9020\u6709\u9650\u516c\u53f8_20250114112222.pdf","orig_name":"dzfp_25112000000010820499_SMC\uff08\u5317\u4eac\uff09\u5236\u9020\u6709\u9650\u516c\u53f8_20250114112222.pdf"}}]}],"contractScans":[{"id":31228,"object_type":105,"object_id":3711,"attachment_id":23239,"attachment":{"id":23239,"key":23239,"name":"5cb2edcd-8eb8-35a3-aa1a-e347df0b7d3e","extension":"pdf","path":"\/v2\/attachment\/preview\/hLtdglndkreOmfJjmOe7Mve0kQO2lAQu\/5cb2edcd-8eb8-35a3-aa1a-e347df0b7d3e\/POBJ24123906.pdf","orig_name":"POBJ24123906.pdf"}}],"receiptScans":[{"id":31256,"object_type":106,"object_id":3711,"attachment_id":23340,"attachment":{"id":23340,"key":23340,"name":"bae53c5e-937e-39df-bd5f-3500ac224b23","extension":"pdf","path":"\/v2\/attachment\/preview\/hLtdglndkreOmfJjmOe7Mve0kQO2lAQu\/bae53c5e-937e-39df-bd5f-3500ac224b23\/2024_12_23_09_07_22.pdf","orig_name":"2024_12_23_09_07_22.pdf"}}],"verifyScans":[],"unreadComments":null,"collected_plan":295,"projectProductTotalAmount":295,"projectProductAllAmount":true,"projectProductTotalCost":194,"projectProductAllCost":true,"projectProductTotalCount":1,"invoiced":295,"un_invoiced":0,"collected":"295","un_collected":0,"is_collected":true,"handlerPerson":{"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"}},"remind_date":"","remind_ahead_display":"\u65e0","expire_remind_ahead_display":"\u65e0","payment_collection_remind_ahead_display":"\u63d0\u524d7\u5929","can_update":true,"can_delete":false,"unread":0,"bgcolor":"#89c541","can_view_product":true,"can_progress":true,"is_chargeback":false,"is_done":false},{"id":4022,"client_id":12,"signed_at":"2025-07-10","amount":"299","handler":5300,"description":"","created_by":5300,"created_at":"2025-07-10 21:02:32","updated_at":"2025-07-16 09:36:55","contract_scan":null,"receipt_scan":null,"contract_type":1,"project_id":3913,"valid_date":null,"expire_date":null,"sla":"","remind_ahead":"","expire_remind_ahead":"","expire_reminded":false,"serial_no":"SMC\u5929\u6d25\u8ba2\u5355POTJ25073432","payment_collection_remind_ahead":"1 day","from_project":3913,"receipt_date":null,"verify_date":null,"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-07-10 21:02:32","is_verify":false,"is_draft":false,"erp_settle_amount":"299","erp_un_settle_amount":"0","erp_payment_ticket_is_verify":false,"erp_collect_ticket_is_verify":false,"erp_cash_cost_ticket_is_verify":false,"b_date":null,"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":null,"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"}}},"contractScan":null,"receiptScan":null,"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"}},"commentCount":{"object_id":4022,"comment":8},"project":{"id":3913,"key":3913,"name":"POTJ25073432-\u56fa\u6001\u786c\u76d8-2025","erpSalesOrder":{"id":1537,"serial_no":"XSDD-20250728-00001","from_date":null,"wrote_date":"2025-07-10","handler":5300,"client_id":12,"purchase_contract_id":null,"project_id":3913,"sales_contract_id":4022,"erp_store_id":null,"status":2,"erp_send_type_id":null,"abstract":null,"description":"","verify_type":1,"next_verify_user":null,"next_stop_verify_user":null,"next_cancel_verify_user":null,"verify_at":"2025-07-28 10:12:39","stop_at":null,"cancel_at":null,"refuse_description":null,"is_resubmitted":false,"is_done":true,"number":"1","amount":"299","created_by":5300,"stop_description":null,"extra":null,"outbound_status":false,"is_used":false,"is_cancel":false,"is_settle":false,"is_old":true,"created_at":"2025-07-10 21:02:32","updated_at":"2025-07-28 10:12:39","erpSalesOrderVerifyRels":[],"erpSalesOrderStopVerifyRels":[]}},"fromProject":{"id":3913,"key":3913,"name":"POTJ25073432-\u56fa\u6001\u786c\u76d8-2025","description":"","total_contact_point":null,"paid_contact_point":null,"is_sales_order_ready":true,"project_product_version_id":934,"bargain_date":"2025-07-10","collected":"299","profit_pct":"47.17","budget":"299","erpSalesOrder":{"id":1537,"serial_no":"XSDD-20250728-00001","from_date":null,"wrote_date":"2025-07-10","handler":5300,"client_id":12,"purchase_contract_id":null,"project_id":3913,"sales_contract_id":4022,"erp_store_id":null,"status":2,"erp_send_type_id":null,"abstract":null,"description":"","verify_type":1,"next_verify_user":null,"next_stop_verify_user":null,"next_cancel_verify_user":null,"verify_at":"2025-07-28 10:12:39","stop_at":null,"cancel_at":null,"refuse_description":null,"is_resubmitted":false,"is_done":true,"number":"1","amount":"299","created_by":5300,"stop_description":null,"extra":null,"outbound_status":false,"is_used":false,"is_cancel":false,"is_settle":false,"is_old":true,"created_at":"2025-07-10 21:02:32","updated_at":"2025-07-28 10:12:39"},"projectProductTypes":[{"id":6727,"product_type_id":2,"key":2,"name":"\u670d\u52a1\u5668","budget":"299","pct":"47.17","project_id":3913,"profit":"141.03"}],"projectProductRels":[{"id":10289,"project_id":3913,"product_id":1691,"amount":"299.00","number":1,"cost":"130.00","description":"","supplier_id":608,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null,"total_amount":"299","total_cost":"130","erp_sales_order_product_id":1756,"supplier":{"id":608,"key":608,"name":"\u6dd8\u5b9d\u7f51"},"product":{"id":1691,"name":"BG5 256G 2230 PCIE4.0NVME\u56fa\u6001\u786c\u76d8","product_type":11,"product_component":179,"product_brand":43,"product_serie":1439,"product_misc":null,"product_qa":null,"pn":"","description":"","created_by":1013,"created_at":"2024-07-25 17:51:53","updated_at":"2025-08-19 16:22:57","pinyin_shortcut":"BG5256G2230PCIE40NVMEgtyp","product_unit":3,"is_renew":false,"productType":{"id":11,"key":11,"name":"\u4e2a\u4eba\u8ba1\u7b97\u673a"},"productComponent":{"id":179,"key":179,"name":"\u914d\u4ef6"},"productBrand":{"id":43,"key":43,"name":"\u4e1c\u829d"},"productSerie":{"id":1439,"key":1439,"name":"\u4e1c\u829d BG5 256G 2230 PCIE4.0NVME\u56fa\u6001\u786c\u76d8"},"productUnit":{"id":3,"key":3,"name":"\u4e2a"}},"erpSalesOrderProduct":{"id":1756,"erp_sales_order_id":1537,"erp_store_id":null,"product_id":1691,"description":"","number":"1","outbound":"0","amount":"299.00","total_amount":"299","last_number":null,"last_amount":null,"last_total_amount":null,"cost":"130.00","total_cost":"130","supplier_id":608,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null}}],"projectContactPoints":[],"buildSalesOrderItems":[{"id":13123,"project_id":3913}],"reimbursementAmountSum":null,"profit":141.0383,"contact_points_status_display":"\u672a\u8bbe\u7f6e"},"salesSupplierRels":[{"id":2959,"contract_id":4022,"supplier_id":608,"purchase_id":4023,"supplier":{"id":608,"key":608,"name":"\u6dd8\u5b9d\u7f51"},"purchase":{"id":4023,"key":4023,"serial_no":"\u8ba2\u5355\u53f7: 4625229891877592710\/4625146693309592710"}}],"contractType":{"id":1,"key":1,"name":"\u4ea7\u54c1\u9500\u552e"},"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":null,"serviceContractRemindDates":[],"salesContractRemindReceivers":[],"serviceContractRemindReceivers":[],"salesContractPaymentCollectionRemindReceivers":[{"id":8669,"user_id":5300,"key":5300,"contract_id":4022,"user":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91","sex":"F","avatar":{"id":141,"user_id":5300,"name":"\/files\/cdn\/a57be577deb434\/avatar\/14dfd1a0-6df5-354a-8afd-f0a76fa8e852.png"}}}],"salesContractPaymentCollectionRemindDates":[{"id":2491,"key":2491,"contract_id":4022,"name":"2025-08-21","value":"299","overdue_days":null,"status":1,"pct":100,"collect_status":"\u5df2\u5b8c\u6210"}],"salesContractPayments":[{"id":"1388","key":"1388","contract_id":4022,"value":"299","created_by":1013,"created_at":"2025-07-28 10:12:39","description":null,"collected_date":"2025-07-28 10:12:39","amount":"299","createdBy":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","department_id":7},"pct":100}],"salesContractInvoices":[{"id":2098,"key":2098,"contract_id":4022,"value":"299.00","attachment_id":null,"from_date":"2025-07-21","attachment":null,"attachmentRelationships":[],"files":[{"id":35917,"object_type":102,"object_id":2098,"attachment_id":26962,"attachment":{"id":26962,"key":26962,"name":"1d33f57b-8329-3f5b-bee3-b0ee0cdff9b1","extension":"pdf","path":"\/v2\/attachment\/view\/hLtdglndkreOmfJjmOe7Mve0kQO2lAQu\/1d33f57b-8329-3f5b-bee3-b0ee0cdff9b1\/dzfp_25112000000151336011_SMC(\u5929\u6d25)\u5236\u9020\u6709\u9650\u516c\u53f8_20250721110952.pdf","orig_name":"dzfp_25112000000151336011_SMC(\u5929\u6d25)\u5236\u9020\u6709\u9650\u516c\u53f8_20250721110952.pdf"}}]}],"contractScans":[{"id":35783,"object_type":105,"object_id":4022,"attachment_id":26768,"attachment":{"id":26768,"key":26768,"name":"7bb7e2d8-9c65-3ac5-83a0-c0a7f8bf91e2","extension":"pdf","path":"\/v2\/attachment\/preview\/hLtdglndkreOmfJjmOe7Mve0kQO2lAQu\/7bb7e2d8-9c65-3ac5-83a0-c0a7f8bf91e2\/POTJ25073432.pdf","orig_name":"POTJ25073432.pdf"}}],"receiptScans":[{"id":35779,"object_type":106,"object_id":4022,"attachment_id":26856,"attachment":{"id":26856,"key":26856,"name":"4307615c-3da8-36c1-8430-eca22eb9da7c","extension":"jpg","path":"\/v2\/attachment\/preview\/hLtdglndkreOmfJjmOe7Mve0kQO2lAQu\/4307615c-3da8-36c1-8430-eca22eb9da7c\/66141752568098_.pic.jpg","orig_name":"66141752568098_.pic.jpg"}}],"verifyScans":[],"unreadComments":null,"collected_plan":299,"projectProductTotalAmount":299,"projectProductAllAmount":true,"projectProductTotalCost":130,"projectProductAllCost":true,"projectProductTotalCount":1,"invoiced":299,"un_invoiced":0,"collected":"299","un_collected":0,"is_collected":true,"handlerPerson":{"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"}},"remind_date":"","remind_ahead_display":"\u65e0","expire_remind_ahead_display":"\u65e0","payment_collection_remind_ahead_display":"\u63d0\u524d1\u5929","can_update":true,"can_delete":false,"unread":0,"bgcolor":"#89c541","can_view_product":true,"can_progress":true,"is_chargeback":false,"is_done":false},{"id":4083,"client_id":12,"signed_at":"2025-08-07","amount":"299","handler":5300,"description":"","created_by":5300,"created_at":"2025-08-07 10:23:59","updated_at":"2025-08-18 10:21:49","contract_scan":null,"receipt_scan":null,"contract_type":1,"project_id":3941,"valid_date":null,"expire_date":"2026-08-07","sla":"","remind_ahead":"","expire_remind_ahead":"","expire_reminded":false,"serial_no":"SMC\u5929\u6d25\u8ba2\u5355POTJ25081871","payment_collection_remind_ahead":"1 day","from_project":3941,"receipt_date":null,"verify_date":null,"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-08-07 10:24:29","is_verify":false,"is_draft":true,"erp_settle_amount":"299","erp_un_settle_amount":"0","erp_payment_ticket_is_verify":false,"erp_collect_ticket_is_verify":false,"erp_cash_cost_ticket_is_verify":false,"b_date":322,"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":null,"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"}}},"contractScan":null,"receiptScan":null,"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"}},"commentCount":{"object_id":4083,"comment":8},"project":{"id":3941,"key":3941,"name":"POTJ25081871-\u56fa\u6001\u786c\u76d8-2025","erpSalesOrder":{"id":1562,"serial_no":"XSDD-20250808-00001","from_date":null,"wrote_date":"2025-08-07","handler":5300,"client_id":12,"purchase_contract_id":null,"project_id":3941,"sales_contract_id":4083,"erp_store_id":null,"status":2,"erp_send_type_id":null,"abstract":null,"description":"","verify_type":1,"next_verify_user":null,"next_stop_verify_user":null,"next_cancel_verify_user":null,"verify_at":"","stop_at":null,"cancel_at":null,"refuse_description":null,"is_resubmitted":false,"is_done":false,"number":"1","amount":"299","created_by":5300,"stop_description":null,"extra":null,"outbound_status":true,"is_used":true,"is_cancel":false,"is_settle":false,"is_old":true,"created_at":"2025-08-07 10:23:59","updated_at":"2025-08-07 10:23:59","erpSalesOrderVerifyRels":[],"erpSalesOrderStopVerifyRels":[]}},"fromProject":{"id":3941,"key":3941,"name":"POTJ25081871-\u56fa\u6001\u786c\u76d8-2025","description":"","total_contact_point":null,"paid_contact_point":null,"is_sales_order_ready":true,"project_product_version_id":971,"bargain_date":"2025-08-07","collected":"299","profit_pct":"47.17","budget":"299","erpSalesOrder":{"id":1562,"serial_no":"XSDD-20250808-00001","from_date":null,"wrote_date":"2025-08-07","handler":5300,"client_id":12,"purchase_contract_id":null,"project_id":3941,"sales_contract_id":4083,"erp_store_id":null,"status":2,"erp_send_type_id":null,"abstract":null,"description":"","verify_type":1,"next_verify_user":null,"next_stop_verify_user":null,"next_cancel_verify_user":null,"verify_at":"","stop_at":null,"cancel_at":null,"refuse_description":null,"is_resubmitted":false,"is_done":false,"number":"1","amount":"299","created_by":5300,"stop_description":null,"extra":null,"outbound_status":true,"is_used":true,"is_cancel":false,"is_settle":false,"is_old":true,"created_at":"2025-08-07 10:23:59","updated_at":"2025-08-07 10:23:59"},"projectProductTypes":[{"id":6897,"product_type_id":11,"key":11,"name":"\u4e2a\u4eba\u8ba1\u7b97\u673a","budget":"299","pct":"47.17","project_id":3941,"profit":"141.03"}],"projectProductRels":[{"id":10593,"project_id":3941,"product_id":1691,"amount":"299.00","number":1,"cost":"130.00","description":"","supplier_id":608,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null,"total_amount":"299","total_cost":"130","erp_sales_order_product_id":1829,"supplier":{"id":608,"key":608,"name":"\u6dd8\u5b9d\u7f51"},"product":{"id":1691,"name":"BG5 256G 2230 PCIE4.0NVME\u56fa\u6001\u786c\u76d8","product_type":11,"product_component":179,"product_brand":43,"product_serie":1439,"product_misc":null,"product_qa":null,"pn":"","description":"","created_by":1013,"created_at":"2024-07-25 17:51:53","updated_at":"2025-08-19 16:22:57","pinyin_shortcut":"BG5256G2230PCIE40NVMEgtyp","product_unit":3,"is_renew":false,"productType":{"id":11,"key":11,"name":"\u4e2a\u4eba\u8ba1\u7b97\u673a"},"productComponent":{"id":179,"key":179,"name":"\u914d\u4ef6"},"productBrand":{"id":43,"key":43,"name":"\u4e1c\u829d"},"productSerie":{"id":1439,"key":1439,"name":"\u4e1c\u829d BG5 256G 2230 PCIE4.0NVME\u56fa\u6001\u786c\u76d8"},"productUnit":{"id":3,"key":3,"name":"\u4e2a"}},"erpSalesOrderProduct":{"id":1829,"erp_sales_order_id":1562,"erp_store_id":null,"product_id":1691,"description":"","number":"1","outbound":"1","amount":"299.00","total_amount":"299","last_number":null,"last_amount":null,"last_total_amount":null,"cost":"130.00","total_cost":"130","supplier_id":608,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null}}],"projectContactPoints":[],"buildSalesOrderItems":[{"id":13251,"project_id":3941}],"reimbursementAmountSum":null,"profit":141.0383,"contact_points_status_display":"\u672a\u8bbe\u7f6e"},"salesSupplierRels":[{"id":3113,"contract_id":4083,"supplier_id":608,"purchase_id":4084,"supplier":{"id":608,"key":608,"name":"\u6dd8\u5b9d\u7f51"},"purchase":{"id":4084,"key":4084,"serial_no":"\u8ba2\u5355\u53f7: 4671124634201592710"}}],"contractType":{"id":1,"key":1,"name":"\u4ea7\u54c1\u9500\u552e"},"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":null,"serviceContractRemindDates":[],"salesContractRemindReceivers":[],"serviceContractRemindReceivers":[],"salesContractPaymentCollectionRemindReceivers":[{"id":8813,"user_id":5300,"key":5300,"contract_id":4083,"user":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91","sex":"F","avatar":{"id":141,"user_id":5300,"name":"\/files\/cdn\/a57be577deb434\/avatar\/14dfd1a0-6df5-354a-8afd-f0a76fa8e852.png"}}}],"salesContractPaymentCollectionRemindDates":[{"id":2541,"key":2541,"contract_id":4083,"name":"2025-09-19","value":"299","overdue_days":null,"status":1,"pct":100,"collect_status":"\u5df2\u5b8c\u6210"}],"salesContractPayments":[{"id":"12015","key":"12015","contract_id":4083,"value":"299","created_by":1013,"created_at":"2025-08-25 15:15:05","description":"","collected_date":"2025-08-25 15:15:05","amount":"299","createdBy":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","department_id":7},"pct":100}],"salesContractInvoices":[{"id":2120,"key":2120,"contract_id":4083,"value":"299.00","attachment_id":null,"from_date":"2025-08-18","attachment":null,"attachmentRelationships":[],"files":[{"id":48587,"object_type":102,"object_id":2120,"attachment_id":27596,"attachment":{"id":27596,"key":27596,"name":"6950207e-72bd-3e16-832b-a68bc0c71c43","extension":"pdf","path":"\/v2\/attachment\/view\/hLtdglndkreOmfJjmOe7Mve0kQO2lAQu\/6950207e-72bd-3e16-832b-a68bc0c71c43\/dzfp_25112000000173249923_SMC(\u5929\u6d25)\u5236\u9020\u6709\u9650\u516c\u53f8_20250818151310.pdf","orig_name":"dzfp_25112000000173249923_SMC(\u5929\u6d25)\u5236\u9020\u6709\u9650\u516c\u53f8_20250818151310.pdf"}}]}],"contractScans":[{"id":48529,"object_type":105,"object_id":4083,"attachment_id":27312,"attachment":{"id":27312,"key":27312,"name":"6686c29c-0790-304d-bce1-cdf4b643940b","extension":"pdf","path":"\/v2\/attachment\/preview\/hLtdglndkreOmfJjmOe7Mve0kQO2lAQu\/6686c29c-0790-304d-bce1-cdf4b643940b\/POTJ25081871.pdf","orig_name":"POTJ25081871.pdf"}}],"receiptScans":[{"id":48292,"object_type":106,"object_id":4083,"attachment_id":27417,"attachment":{"id":27417,"key":27417,"name":"b168284b-073f-3707-a3dd-96b4a9d87328","extension":"jpg","path":"\/v2\/attachment\/preview\/hLtdglndkreOmfJjmOe7Mve0kQO2lAQu\/b168284b-073f-3707-a3dd-96b4a9d87328\/17921754890448_.pic.jpg","orig_name":"17921754890448_.pic.jpg"}}],"verifyScans":[],"unreadComments":null,"collected_plan":299,"projectProductTotalAmount":299,"projectProductAllAmount":true,"projectProductTotalCost":130,"projectProductAllCost":true,"projectProductTotalCount":1,"invoiced":299,"un_invoiced":0,"collected":"299","un_collected":0,"is_collected":true,"handlerPerson":{"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"}},"remind_date":"","remind_ahead_display":"\u65e0","expire_remind_ahead_display":"\u65e0","payment_collection_remind_ahead_display":"\u63d0\u524d1\u5929","can_update":true,"can_delete":false,"unread":0,"bgcolor":"#89c541","can_view_product":true,"can_progress":true,"is_chargeback":false,"is_done":false}],"pagenation":{"totalcount":1609,"thispage":1,"pagesize":10}},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}]}', FALSE, '2025-09-19 11:32:52') RETURNING "id" |