6a548120e689f: POST https://beta.jinchangxiao.com/v2/sales-contract/of-client at 2026-07-13 02:09:36 pm by 39.156.194.178
Log Messages
总计110条数据
| Time | Level | Category | Message |
|---|---|---|---|
| 14:09:36.943 | trace | yii\base\Application::bootstrap | Bootstrap with yii\log\Dispatcher |
| 14:09:36.943 | trace | yii\base\Module::getModule | Loading module: debug |
| 14:09:36.943 | trace | yii\base\Application::bootstrap | Bootstrap with yii\debug\Module::bootstrap() |
| 14:09:36.944 | trace | yii\redis\Connection::open | Opening redis DB connection: redis.server.local:6379, database=1 |
| 14:09:36.944 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: SELECT |
| 14:09:36.953 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 14:09:36.962 | info | time tracing start | 1783922976962658048 |
| 14:09:36.962 | trace | yii\web\UrlManager::parseRequest | No matching URL rules. Using default URL parsing logic. |
| 14:09:36.962 | trace | yii\web\Application::handleRequest | Route requested: 'v2/sales-contract/of-client' |
| 14:09:36.962 | trace | yii\base\Module::getModule | Loading module: v2 |
| 14:09:36.964 | info | yii\web\Session::open | Session started |
| 14:09:36.965 | info | yii\db\Connection::open | Opening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta |
| 14:09:36.969 | info | yii\db\Command::query | SELECT * FROM "global"."vw_user_login" WHERE "access_token"='wXfR6UQn7fW_MTEa9o-7H8Ixg0fJU0Zm' |
| 14:09:36.994 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 14:09:36.998 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 14:09:37.005 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 14:09:37.012 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 14:09:37.019 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1000 |
| 14:09:37.023 | trace | yii\base\Controller::runAction | Route to run: v2/sales-contract/of-client |
| 14:09:37.024 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 14:09:37.026 | trace | uranus\rbac\DbManager::checkAccessFromCache | Checking role: Admin |
| 14:09:37.026 | trace | yii\base\InlineAction::runWithParams | Running action: app\modules\v2\controllers\SalesContractController::actionOfClient() |
| 14:09:37.027 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_clients" WHERE ("id"='48') AND ("deleted"=FALSE) |
| 14:09:37.027 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 14:09:37.028 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 14:09:37.028 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 14:09:37.029 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 14:09:37.029 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 14:09:37.031 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 14:09:37.032 | 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 "client"."id"='48' GROUP BY "c"."id" ORDER BY "c"."signed_at" DESC, "c"."created_at" DESC) "c" |
| 14:09:37.043 | 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 "client"."id"='48' GROUP BY "c"."id" ORDER BY "c"."signed_at" DESC, "c"."created_at" DESC LIMIT 10 |
| 14:09:37.058 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "name", "logo", "sales_rep" FROM "a57be577deb434"."tbl_clients" WHERE "id"=48 |
| 14:09:37.069 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_users" WHERE "id"=1004 |
| 14:09:37.070 | 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"=1004) |
| 14:09:37.071 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id"=1004 |
| 14:09:37.071 | 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"=1004) |
| 14:09:37.072 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_departments" WHERE "id"=1 |
| 14:09:37.072 | info | yii\db\Command::query | SELECT "object_id", count(*) AS comment FROM "a57be577deb434"."tbl_comments" WHERE ("object_type"=7) AND ("object_id" IN (4360, 4168, 3998, 3783, 3547, 3385, 3395, 3366, 3299, 3228)) GROUP BY "object_id" |
| 14:09:37.122 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "project_title" AS "name" FROM "a57be577deb434"."tbl_projects" WHERE "id" IN (4090, 3969, 3873, 3776, 3658, 3582, 3581, 3556, 3543, 3498) |
| 14:09:37.123 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_sales_orders" WHERE ("status" IN (2, 5)) AND ("project_id" IN (3543, 3498, 3582, 3658, 3969, 3581, 3776, 4090, 3556, 3873)) |
| 14:09:37.125 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_sales_order_verify_rels" WHERE "erp_sales_order_id" IN (1589, 1219, 1272, 1282, 1286, 1443, 1529, 1664, 1246, 1351) ORDER BY "id" |
| 14:09:37.125 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_sales_order_stop_verify_rels" WHERE "erp_sales_order_id" IN (1589, 1219, 1272, 1282, 1286, 1443, 1529, 1664, 1246, 1351) ORDER BY "id" |
| 14:09:37.126 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_sales_orders" WHERE "sales_contract_id" IN (4360, 4168, 3998, 3783, 3547, 3385, 3395, 3366, 3299, 3228) ORDER BY "id" DESC |
| 14:09:37.127 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_sales_order_verify_rels" WHERE "erp_sales_order_id" IN (1664, 1589, 1529, 1443, 1351, 1286, 1282, 1272, 1246, 1219) ORDER BY "id" |
| 14:09:37.128 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "name", "sex" FROM "a57be577deb434"."tbl_users" WHERE "id"=1001 |
| 14:09:37.128 | 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"=1001) |
| 14:09:37.129 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_sales_order_stop_verify_rels" WHERE "erp_sales_order_id" IN (1664, 1589, 1529, 1443, 1351, 1286, 1282, 1272, 1246, 1219) ORDER BY "id" |
| 14:09:37.129 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_sales_order_cancel_verify_rels" WHERE "erp_sales_order_id" IN (1664, 1589, 1529, 1443, 1351, 1286, 1282, 1272, 1246, 1219) ORDER BY "id" |
| 14:09:37.130 | 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 (4090, 3969, 3873, 3776, 3658, 3582, 3581, 3556, 3543, 3498) |
| 14:09:37.131 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_sales_orders" WHERE ("status" IN (2, 5)) AND ("project_id" IN (3543, 3498, 3582, 3658, 3969, 3581, 3776, 4090, 3556, 3873)) |
| 14:09:37.132 | 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 (3543, 3498, 3582, 3658, 3969, 3581, 3776, 4090, 3556, 3873) |
| 14:09:37.133 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_project_product_rels" WHERE "project_id" IN (3543, 3498, 3582, 3658, 3969, 3581, 3776, 4090, 3556, 3873) ORDER BY "id" |
| 14:09:37.135 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_suppliers" WHERE "id" IN (81, 598, 236, 90, 165, 116) |
| 14:09:37.135 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_products" WHERE "id" IN (1557, 1620, 1663, 1664, 1665, 922, 1354, 1669, 1670, 1780, 941, 1376, 41, 1939) |
| 14:09:37.136 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_types" WHERE "id" IN (3, 2, 22, 5, 19) |
| 14:09:37.137 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_components" WHERE "id" IN (15, 5, 17, 208, 36, 189, 35, 200, 151, 13) |
| 14:09:37.138 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_brands" WHERE "id" IN (6, 4, 12, 8, 133, 50) |
| 14:09:37.138 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_series" WHERE "id" IN (1015, 1191, 1147, 1414, 1026, 1415, 210, 1416, 1024, 592, 1149, 1598, 1052) |
| 14:09:37.139 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_units" WHERE "id" IN (4, 2, 7, 3, 8) |
| 14:09:37.140 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_sales_order_products" WHERE "id" IN (788, 896, 989, 990, 991, 992, 998, 999, 1000, 1227, 972, 973, 2121, 1896, 1734, 1732, 1733, 1730, 1731, 1525) |
| 14:09:37.140 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_project_contact_points" WHERE "project_id" IN (3543, 3498, 3582, 3658, 3969, 3581, 3776, 4090, 3556, 3873) |
| 14:09:37.141 | info | yii\db\Command::query | SELECT "id", "project_id" FROM "a57be577deb434"."tbl_sales_order_items" WHERE ("is_system"=TRUE) AND ("project_id" IN (3543, 3498, 3582, 3658, 3969, 3581, 3776, 4090, 3556, 3873)) |
| 14:09:37.145 | 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 (3543, 3498, 3582, 3658, 3969, 3581, 3776, 4090, 3556, 3873)) GROUP BY "project_id" |
| 14:09:37.148 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_sales_supplier_rels" WHERE "contract_id" IN (4360, 4168, 3998, 3783, 3547, 3385, 3395, 3366, 3299, 3228) |
| 14:09:37.149 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_suppliers" WHERE "id" IN (489, 165, 598, 81, 236, 90, 116, 174) |
| 14:09:37.149 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "serial_no" FROM "a57be577deb434"."tbl_purchase_contracts" WHERE "id" IN (4361, 3561, 3292, 3267, 3411, 3424, 4167, 3722, 4004, 4220, 3784) |
| 14:09:37.150 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "type" AS "name" FROM "a57be577deb434"."tbl_contract_types" WHERE "id" IN (1, 2) |
| 14:09:37.150 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id"=1004 |
| 14:09:37.151 | 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"=1004) |
| 14:09:37.151 | 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 (4360, 4168, 3998, 3783, 3547, 3385, 3395, 3366, 3299, 3228)) ORDER BY "remind_date" |
| 14:09:37.152 | 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 (4360, 4168, 3998, 3783, 3547, 3385, 3395, 3366, 3299, 3228) |
| 14:09:37.152 | 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 (4360, 4168, 3998, 3783, 3547, 3385, 3395, 3366, 3299, 3228) |
| 14:09:37.153 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "name", "sex" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (1004, 1011) |
| 14:09:37.154 | 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 (1004, 1011)) |
| 14:09:37.154 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_service_contract_remind_receivers" WHERE "contract_id" IN (4360, 4168, 3998, 3783, 3547, 3385, 3395, 3366, 3299, 3228) |
| 14:09:37.155 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "name", "sex" FROM "a57be577deb434"."tbl_users" WHERE "id"=1004 |
| 14:09:37.155 | 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"=1004) |
| 14:09:37.156 | 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 (4360, 4168, 3998, 3783, 3547, 3385, 3395, 3366, 3299, 3228) |
| 14:09:37.156 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "name", "sex" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (1004, 1001) |
| 14:09:37.157 | 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 (1004, 1001)) |
| 14:09:37.157 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "contract_id", "remind_date" AS "name", "amount" AS "value", "overdue_days", "status", "remind_date" FROM "a57be577deb434"."tbl_sales_contract_payment_collection_remind_dates" WHERE "contract_id" IN (4360, 4168, 3998, 3783, 3547, 3385, 3395, 3366, 3299, 3228) ORDER BY "remind_date" |
| 14:09:37.158 | 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.wrote_date as collected_date, t.created_at, t.created_by, t.abstract as description FROM "a57be577deb434"."tbl_erp_collect_ticket_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_collect_tickets" "t" ON r.erp_collect_ticket_id = t.id WHERE (r.sales_contract_id is not null) AND ("t"."status" IN (2, 5))) UNION ALL ( SELECT '2' || r.id::varchar as id, 2 as ticket_type, r.sales_contract_id as contract_id, r.amount as amount, t.created_at as collected_date, t.created_at, t.created_by, t.abstract as description FROM "a57be577deb434"."tbl_erp_cash_cost_ticket_sales_contract_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_cash_cost_tickets" "t" ON r.erp_cash_cost_ticket_id = t.id WHERE (r.sales_contract_id is not null) AND ("t"."is_payment_settle"=TRUE) AND ("t"."status" IN (2, 5)) ) UNION ALL ( SELECT '3' || r.id::varchar as id, 3 as ticket_type, r.sales_contract_id as contract_id, 0 - r.amount as amount, t.created_at as collected_date, t.created_at, t.created_by, t.abstract as description FROM "a57be577deb434"."tbl_erp_payment_ticket_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_payment_tickets" "t" ON r.erp_payment_ticket_id = t.id WHERE (r.sales_contract_id is not null) AND ("t"."is_payment_settle"=TRUE) AND ("t"."status" IN (2, 5)) )) "sub") "r" WHERE "contract_id" IN (4360, 4168, 3998, 3783, 3547, 3385, 3395, 3366, 3299, 3228) ORDER BY "id" DESC |
| 14:09:37.160 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (5388, 1013) |
| 14:09:37.161 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "contract_id", "amount" AS "value", "attachment_id", "from_date", "description", "is_draft", "is_cancel" FROM "a57be577deb434"."tbl_sales_contract_invoices" WHERE "contract_id" IN (4360, 4168, 3998, 3783, 3547, 3385, 3395, 3366, 3299, 3228) ORDER BY "id" |
| 14:09:37.162 | info | yii\db\Command::query | SELECT "id", "sales_invoice_id", "amount", "tax_rate" FROM "a57be577deb434"."tbl_sales_invoice_amounts" WHERE "sales_invoice_id" IN (1632, 1677, 1698, 1706, 1710, 1810, 1952, 2084, 2163, 2280) ORDER BY "id" |
| 14:09:37.163 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=20) AND ("object_id" IN (1632, 1677, 1698, 1706, 1710, 1810, 1952, 2084, 2163, 2280)) |
| 14:09:37.166 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=102) AND ("object_id" IN (1632, 1677, 1698, 1706, 1710, 1810, 1952, 2084, 2163, 2280)) |
| 14:09:37.169 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "name", "extension", "path", "orig_name" FROM "a57be577deb434"."tbl_attachments" WHERE "id" IN (21716, 18564, 19596, 20015, 20064, 20176, 24179, 26542, 28714, 31331) |
| 14:09:37.170 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=105) AND ("object_id" IN (4360, 4168, 3998, 3783, 3547, 3385, 3395, 3366, 3299, 3228)) |
| 14:09:37.173 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "name", "extension", "path", "orig_name" FROM "a57be577deb434"."tbl_attachments" WHERE "id" IN (18637, 19258, 20172, 20173, 19979, 22367, 23608, 31336, 28417, 26540, 24294) |
| 14:09:37.177 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=106) AND ("object_id" IN (4360, 4168, 3998, 3783, 3547, 3385, 3395, 3366, 3299, 3228)) |
| 14:09:37.180 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "name", "extension", "path", "orig_name" FROM "a57be577deb434"."tbl_attachments" WHERE "id" IN (18638, 19377, 21603, 24182, 28388, 31327) |
| 14:09:37.180 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=107) AND ("object_id" IN (4360, 4168, 3998, 3783, 3547, 3385, 3395, 3366, 3299, 3228)) |
| 14:09:37.185 | 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 (4360, 4168, 3998, 3783, 3547, 3385, 3395, 3366, 3299, 3228)) GROUP BY "object_id" |
| 14:09:37.223 | info | yii\db\Command::query | SELECT SUM(amount) FROM "a57be577deb434"."tbl_sales_contract_invoices" WHERE "contract_id"=4360 |
| 14:09:37.225 | trace | uranus\rbac\DbManager::checkAccessFromCache | Checking permission: viewProduct |
| 14:09:37.225 | trace | uranus\rbac\DbManager::checkAccessFromCache | Checking role: StoreKeeper |
| 14:09:37.225 | trace | uranus\rbac\DbManager::checkAccessFromCache | Checking role: Admin |
| 14:09:37.225 | info | yii\db\Command::query | SELECT SUM(amount) FROM "a57be577deb434"."tbl_sales_contract_invoices" WHERE "contract_id"=4168 |
| 14:09:37.226 | info | yii\db\Command::query | SELECT SUM(amount) FROM "a57be577deb434"."tbl_sales_contract_invoices" WHERE "contract_id"=3998 |
| 14:09:37.226 | info | yii\db\Command::query | SELECT SUM(amount) FROM "a57be577deb434"."tbl_sales_contract_invoices" WHERE "contract_id"=3783 |
| 14:09:37.227 | info | yii\db\Command::query | SELECT SUM(amount) FROM "a57be577deb434"."tbl_sales_contract_invoices" WHERE "contract_id"=3547 |
| 14:09:37.227 | info | yii\db\Command::query | SELECT SUM(amount) FROM "a57be577deb434"."tbl_sales_contract_invoices" WHERE "contract_id"=3385 |
| 14:09:37.228 | info | yii\db\Command::query | SELECT SUM(amount) FROM "a57be577deb434"."tbl_sales_contract_invoices" WHERE "contract_id"=3395 |
| 14:09:37.229 | info | yii\db\Command::query | SELECT SUM(amount) FROM "a57be577deb434"."tbl_sales_contract_invoices" WHERE "contract_id"=3366 |
| 14:09:37.229 | info | yii\db\Command::query | SELECT SUM(amount) FROM "a57be577deb434"."tbl_sales_contract_invoices" WHERE "contract_id"=3299 |
| 14:09:37.230 | info | yii\db\Command::query | SELECT SUM(amount) FROM "a57be577deb434"."tbl_sales_contract_invoices" WHERE "contract_id"=3228 |
| 14:09:37.235 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 14:09:37.237 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 14:09:37.238 | 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", "duration") VALUES (200, 'a57be577deb434', 1000, 0, 276, 'v2/sales-contract/of-client', '{"access_token":"wXfR6UQn7fW_MTEa9o-7H8Ixg0fJU0Zm","device_type":"0","version_code":"276","id":"48","page":"1","token":"d75793f59bec3c46c92fd9ccaab1f5c8","posttime":"1783922977"}', '{"code":200,"data":{"list":[{"id":4360,"client_id":48,"signed_at":"2026-01-05","amount":"2000","handler":1004,"description":"","created_by":1004,"created_at":"2026-01-05 15:32:18","updated_at":"2026-01-12 17:59:32","contract_scan":null,"receipt_scan":null,"contract_type":1,"project_id":4090,"valid_date":null,"expire_date":"2027-01-05","sla":"","remind_ahead":"","expire_remind_ahead":"30 days","expire_reminded":false,"serial_no":"TS-YJC-202601","payment_collection_remind_ahead":"1 day","from_project":4090,"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":"2026-01-05 15:32:18","is_verify":false,"is_draft":true,"erp_settle_amount":"2000","erp_un_settle_amount":"0","erp_payment_ticket_is_verify":false,"erp_collect_ticket_is_verify":false,"erp_cash_cost_ticket_is_verify":false,"erp_all_settle_amount":"2000","receipt_scan_uploaded":true,"verify_scan_uploaded":false,"contract_scan_uploaded":true,"is_edit_verify":false,"is_chargeback_verify":false,"b_date":176,"passed":2,"client":{"id":48,"key":48,"name":"\u4e2d\u90fd\u6570\u79d1\u4f9b\u5e94\u94fe\u7ba1\u7406\u6709\u9650\u516c\u53f8","logo":null,"sales_rep":1004,"salesRep":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0","avatar":{"id":10,"user_id":1004,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1004.jpg"}}},"contractScan":null,"receiptScan":null,"createdBy":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0","sex":"M","department_id":1,"avatar":{"id":10,"user_id":1004,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1004.jpg"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"commentCount":{"object_id":4360,"comment":7},"project":{"id":4090,"key":4090,"name":"2016\u5b58\u50a8\u786c\u76d8","erpSalesOrder":{"id":1664,"serial_no":"XSDD-20260105-00002","from_date":null,"wrote_date":"2026-01-05","handler":1004,"client_id":48,"purchase_contract_id":null,"project_id":4090,"sales_contract_id":4360,"erp_store_id":null,"status":2,"erp_send_type_id":null,"abstract":null,"description":null,"verify_type":2,"next_verify_user":null,"next_stop_verify_user":null,"next_cancel_verify_user":null,"verify_at":"2026-01-05 15:32:18","stop_at":null,"cancel_at":null,"refuse_description":null,"is_resubmitted":false,"is_done":false,"number":"2","amount":"2000","created_by":1004,"stop_description":null,"extra":"{\"payment_collection_remind_ahead\":\"1 day\",\"salesContractPaymentCollectionRemindReceivers\":[\"5388\",\"1001\",\"1004\"],\"salesContractPaymentCollectionRemindDates\":[{\"remind_date\":\"2026-01-31\",\"amount\":\"2000\",\"pct\":\"100\"}]}","outbound_status":true,"is_used":true,"is_cancel":false,"is_settle":false,"is_old":false,"created_at":"2026-01-05 15:32:06","updated_at":"2026-01-05 15:32:18","print_times":null,"erpSalesOrderVerifyRels":[{"id":102,"erp_sales_order_id":1664,"user_id":1001,"status":1,"description":null,"verify_at":"2026-01-05 15:32:18"}],"erpSalesOrderStopVerifyRels":[]}},"erpSalesOrder":{"id":1664,"serial_no":"XSDD-20260105-00002","from_date":null,"wrote_date":"2026-01-05","handler":1004,"client_id":48,"purchase_contract_id":null,"project_id":4090,"sales_contract_id":4360,"erp_store_id":null,"status":2,"erp_send_type_id":null,"abstract":null,"description":null,"verify_type":2,"next_verify_user":null,"next_stop_verify_user":null,"next_cancel_verify_user":null,"verify_at":"2026-01-05 15:32:18","stop_at":null,"cancel_at":null,"refuse_description":null,"is_resubmitted":false,"is_done":false,"number":"2","amount":"2000","created_by":1004,"stop_description":null,"extra":"{\"payment_collection_remind_ahead\":\"1 day\",\"salesContractPaymentCollectionRemindReceivers\":[\"5388\",\"1001\",\"1004\"],\"salesContractPaymentCollectionRemindDates\":[{\"remind_date\":\"2026-01-31\",\"amount\":\"2000\",\"pct\":\"100\"}]}","outbound_status":true,"is_used":true,"is_cancel":false,"is_settle":false,"is_old":false,"created_at":"2026-01-05 15:32:06","updated_at":"2026-01-05 15:32:18","print_times":null,"erpSalesOrderVerifyRels":[{"id":102,"erp_sales_order_id":1664,"user_id":1001,"status":1,"description":null,"verify_at":"2026-01-05 15:32:18","user":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/\/avatar\/e868e40f-1256-329e-9b1c-74e095049622.png"}}}],"erpSalesOrderStopVerifyRels":[],"erpSalesOrderCancelVerifyRels":[]},"fromProject":{"id":4090,"key":4090,"name":"2016\u5b58\u50a8\u786c\u76d8","description":"","total_contact_point":null,"paid_contact_point":null,"is_sales_order_ready":true,"project_product_version_id":1152,"bargain_date":"2026-01-05","collected":"2000","profit_pct":"62.38","budget":"2000","erpSalesOrder":{"id":1664,"serial_no":"XSDD-20260105-00002","from_date":null,"wrote_date":"2026-01-05","handler":1004,"client_id":48,"purchase_contract_id":null,"project_id":4090,"sales_contract_id":4360,"erp_store_id":null,"status":2,"erp_send_type_id":null,"abstract":null,"description":null,"verify_type":2,"next_verify_user":null,"next_stop_verify_user":null,"next_cancel_verify_user":null,"verify_at":"2026-01-05 15:32:18","stop_at":null,"cancel_at":null,"refuse_description":null,"is_resubmitted":false,"is_done":false,"number":"2","amount":"2000","created_by":1004,"stop_description":null,"extra":"{\"payment_collection_remind_ahead\":\"1 day\",\"salesContractPaymentCollectionRemindReceivers\":[\"5388\",\"1001\",\"1004\"],\"salesContractPaymentCollectionRemindDates\":[{\"remind_date\":\"2026-01-31\",\"amount\":\"2000\",\"pct\":\"100\"}]}","outbound_status":true,"is_used":true,"is_cancel":false,"is_settle":false,"is_old":false,"created_at":"2026-01-05 15:32:06","updated_at":"2026-01-05 15:32:18","print_times":null},"projectProductTypes":[{"id":8060,"product_type_id":3,"key":3,"name":"\u5b58\u50a8\u8bbe\u5907","budget":"2000","pct":"62.38","project_id":4090,"profit":"1247.6"}],"projectProductRels":[{"id":11452,"project_id":4090,"product_id":41,"amount":"1000","number":2,"cost":"260","description":"","supplier_id":null,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null,"total_amount":"2000","total_cost":"520","erp_sales_order_product_id":2121,"supplier":null,"product":{"id":41,"name":"X423A-R5","product_type":3,"product_component":15,"product_brand":6,"product_serie":1015,"product_misc":4,"product_qa":4,"pn":"","description":"","created_by":1013,"created_at":"2017-02-16 12:06:10","updated_at":"2026-01-06 11:47:31","pinyin_shortcut":"X423AR5","product_unit":4,"is_renew":false,"in_out_at":"2026-01-06 11:47:31.374476+08","productType":{"id":3,"key":3,"name":"\u5b58\u50a8\u8bbe\u5907"},"productComponent":{"id":15,"key":15,"name":"\u5b58\u50a8\u786c\u76d8"},"productBrand":{"id":6,"key":6,"name":"NetApp"},"productSerie":{"id":1015,"key":1015,"name":"900G 10K 2.5 SAS\u5b58\u50a8\u786c\u76d8"},"productUnit":{"id":4,"key":4,"name":"\u5757"}},"erpSalesOrderProduct":{"id":2121,"erp_sales_order_id":1664,"erp_store_id":null,"product_id":41,"description":"","number":"2","outbound":"2","amount":"1000","total_amount":"2000","last_number":null,"last_amount":null,"last_total_amount":null,"cost":"260","total_cost":"520","supplier_id":null,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null}}],"projectContactPoints":[],"buildSalesOrderItems":[{"id":13831,"project_id":4090},{"id":13830,"project_id":4090}],"reimbursementAmountSum":null,"profit":1247.6,"contact_points_status_display":"\u672a\u8bbe\u7f6e","total_contact_paid_point":0,"total_contact_un_paid_point":0},"salesSupplierRels":[{"id":3828,"contract_id":4360,"supplier_id":489,"purchase_id":4361,"supplier":{"id":489,"key":489,"name":"\u5317\u4eac\u6234\u68ee\u7279\u7cfb\u7edf\u79d1\u6280\u6709\u9650\u516c\u53f8"},"purchase":{"id":4361,"key":4361,"serial_no":"TSKJ20260104-HYF-002"}}],"contractType":{"id":1,"key":1,"name":"\u4ea7\u54c1\u9500\u552e"},"handleBy":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0","sex":"M","department_id":1,"avatar":{"id":10,"user_id":1004,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1004.jpg"}},"remindDate":null,"serviceContractRemindDates":[],"salesContractRemindReceivers":[{"id":8636,"user_id":1004,"key":1004,"contract_id":4360,"user":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0","sex":"M","avatar":{"id":10,"user_id":1004,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1004.jpg"}}}],"serviceContractRemindReceivers":[],"salesContractPaymentCollectionRemindReceivers":[{"id":9689,"user_id":1001,"key":1001,"contract_id":4360,"user":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/\/avatar\/e868e40f-1256-329e-9b1c-74e095049622.png"}}},{"id":9690,"user_id":1004,"key":1004,"contract_id":4360,"user":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0","sex":"M","avatar":{"id":10,"user_id":1004,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1004.jpg"}}}],"salesContractPaymentCollectionRemindDates":[{"id":2707,"key":2707,"contract_id":4360,"name":"2026-01-31","value":"2000","overdue_days":null,"status":1,"remind_date":"2026-01-31","pct":100,"overdue_display":""}],"salesContractPayments":[{"id":"12160","key":"12160","contract_id":4360,"value":"2000","created_by":1013,"created_at":"2026-01-22 14:28:55","description":null,"collected_date":"2026-01-22 00:00:00","amount":"2000","createdBy":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","department_id":7},"pct":100}],"salesContractInvoices":[{"id":2280,"key":2280,"contract_id":4360,"value":"2000.00","attachment_id":null,"from_date":"2026-01-12","description":"","is_draft":false,"is_cancel":false,"salesInvoiceAmounts":[{"id":1155,"sales_invoice_id":2280,"amount":"2000","tax_rate":"13"}],"attachment":null,"attachmentRelationships":[],"files":[{"id":55263,"object_type":102,"object_id":2280,"attachment_id":31331,"attachment":{"id":31331,"key":31331,"name":"35deb20e-be5e-3ca3-b8a3-8cbbc0601bea","extension":"pdf","path":"\/v2\/attachment\/view\/wXfR6UQn7fW_MTEa9o-7H8Ixg0fJU0Zm\/35deb20e-be5e-3ca3-b8a3-8cbbc0601bea\/dzfp_26112000000140516566_\u4e2d\u90fd\u6570\u79d1\u4f9b\u5e94\u94fe\u7ba1\u7406\u6709\u9650\u516c\u53f8_20260112145858.pdf","orig_name":"dzfp_26112000000140516566_\u4e2d\u90fd\u6570\u79d1\u4f9b\u5e94\u94fe\u7ba1\u7406\u6709\u9650\u516c\u53f8_20260112145858.pdf"}}]}],"contractScans":[{"id":55250,"object_type":105,"object_id":4360,"attachment_id":31336,"attachment":{"id":31336,"key":31336,"name":"71c02d3c-a56f-395e-be25-f5e576433a74","extension":"pdf","path":"\/v2\/attachment\/preview\/wXfR6UQn7fW_MTEa9o-7H8Ixg0fJU0Zm\/71c02d3c-a56f-395e-be25-f5e576433a74\/2026_01_12_17_57_51_1.pdf","orig_name":"2026_01_12_17_57_51_1.pdf"}}],"receiptScans":[{"id":55236,"object_type":106,"object_id":4360,"attachment_id":31327,"attachment":{"id":31327,"key":31327,"name":"d177aa3c-4f71-313b-8f4a-428f99c6d645","extension":"jpg","path":"\/v2\/attachment\/preview\/wXfR6UQn7fW_MTEa9o-7H8Ixg0fJU0Zm\/d177aa3c-4f71-313b-8f4a-428f99c6d645\/68931768199723_.pic_hd.jpg","orig_name":"68931768199723_.pic_hd.jpg"}}],"verifyScans":[],"unreadComments":null,"collected_plan":2000,"projectProductTotalAmount":2000,"projectProductAllAmount":true,"projectProductTotalCost":520,"projectProductAllCost":true,"projectProductTotalCount":2,"invoiced":"2000.00","un_invoiced":0,"collected":"2000","un_collected":0,"is_collected":true,"handlerPerson":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0","avatar":{"id":10,"user_id":1004,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1004.jpg"}},"remind_date":"","remind_ahead_display":"\u65e0","expire_remind_ahead_display":"\u63d0\u524d30\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":true,"can_view_product_cost":true,"erp_all_un_settle_amount":0,"verifyList":[{"id":102,"erp_sales_order_id":1664,"user_id":1001,"status":1,"description":null,"verify_at":"2026-01-05 15:32:18","user":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/\/avatar\/e868e40f-1256-329e-9b1c-74e095049622.png"}}}]},{"id":4168,"client_id":48,"signed_at":"2025-09-17","amount":"2000","handler":1004,"description":"","created_by":1004,"created_at":"2025-09-18 09:49:20","updated_at":"2026-01-14 09:14:06","contract_scan":null,"receipt_scan":null,"contract_type":1,"project_id":3969,"valid_date":null,"expire_date":"2026-09-17","sla":"","remind_ahead":"","expire_remind_ahead":"30 days","expire_reminded":false,"serial_no":"TS-YJC-20250917-01","payment_collection_remind_ahead":"","from_project":3969,"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-09-18 11:37:41","is_verify":false,"is_draft":true,"erp_settle_amount":"2000","erp_un_settle_amount":"0","erp_payment_ticket_is_verify":false,"erp_collect_ticket_is_verify":false,"erp_cash_cost_ticket_is_verify":false,"erp_all_settle_amount":"2000","receipt_scan_uploaded":true,"verify_scan_uploaded":false,"contract_scan_uploaded":true,"is_edit_verify":false,"is_chargeback_verify":false,"b_date":66,"passed":2,"client":{"id":48,"key":48,"name":"\u4e2d\u90fd\u6570\u79d1\u4f9b\u5e94\u94fe\u7ba1\u7406\u6709\u9650\u516c\u53f8","logo":null,"sales_rep":1004,"salesRep":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0","avatar":{"id":10,"user_id":1004,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1004.jpg"}}},"contractScan":null,"receiptScan":null,"createdBy":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0","sex":"M","department_id":1,"avatar":{"id":10,"user_id":1004,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1004.jpg"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"commentCount":{"object_id":4168,"comment":8},"project":{"id":3969,"key":3969,"name":"\u5b58\u50a8\u786c\u76d8\u914d\u4ef6","erpSalesOrder":{"id":1589,"serial_no":"XSDD-20250918-00001","from_date":null,"wrote_date":"2025-09-18","handler":1004,"client_id":48,"purchase_contract_id":null,"project_id":3969,"sales_contract_id":4168,"erp_store_id":null,"status":2,"erp_send_type_id":null,"abstract":null,"description":"","verify_type":2,"next_verify_user":null,"next_stop_verify_user":null,"next_cancel_verify_user":null,"verify_at":"2025-09-18 09:49:20","stop_at":null,"cancel_at":null,"refuse_description":null,"is_resubmitted":false,"is_done":false,"number":"2","amount":"2000","created_by":1004,"stop_description":null,"extra":"{\"payment_collection_remind_ahead\":null,\"salesContractPaymentCollectionRemindReceivers\":[\"1004\"],\"salesContractPaymentCollectionRemindDates\":null}","outbound_status":true,"is_used":true,"is_cancel":false,"is_settle":false,"is_old":false,"created_at":"2025-09-18 09:36:36","updated_at":"2025-09-18 09:49:20","print_times":null,"erpSalesOrderVerifyRels":[{"id":27,"erp_sales_order_id":1589,"user_id":1001,"status":1,"description":"","verify_at":"2025-09-18 09:49:20"}],"erpSalesOrderStopVerifyRels":[]}},"erpSalesOrder":{"id":1589,"serial_no":"XSDD-20250918-00001","from_date":null,"wrote_date":"2025-09-18","handler":1004,"client_id":48,"purchase_contract_id":null,"project_id":3969,"sales_contract_id":4168,"erp_store_id":null,"status":2,"erp_send_type_id":null,"abstract":null,"description":"","verify_type":2,"next_verify_user":null,"next_stop_verify_user":null,"next_cancel_verify_user":null,"verify_at":"2025-09-18 09:49:20","stop_at":null,"cancel_at":null,"refuse_description":null,"is_resubmitted":false,"is_done":false,"number":"2","amount":"2000","created_by":1004,"stop_description":null,"extra":"{\"payment_collection_remind_ahead\":null,\"salesContractPaymentCollectionRemindReceivers\":[\"1004\"],\"salesContractPaymentCollectionRemindDates\":null}","outbound_status":true,"is_used":true,"is_cancel":false,"is_settle":false,"is_old":false,"created_at":"2025-09-18 09:36:36","updated_at":"2025-09-18 09:49:20","print_times":null,"erpSalesOrderVerifyRels":[{"id":27,"erp_sales_order_id":1589,"user_id":1001,"status":1,"description":"","verify_at":"2025-09-18 09:49:20","user":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/\/avatar\/e868e40f-1256-329e-9b1c-74e095049622.png"}}}],"erpSalesOrderStopVerifyRels":[],"erpSalesOrderCancelVerifyRels":[]},"fromProject":{"id":3969,"key":3969,"name":"\u5b58\u50a8\u786c\u76d8\u914d\u4ef6","description":"","total_contact_point":null,"paid_contact_point":null,"is_sales_order_ready":true,"project_product_version_id":1187,"bargain_date":"2025-09-17","collected":"2000","profit_pct":"62.38","budget":"2000","erpSalesOrder":{"id":1589,"serial_no":"XSDD-20250918-00001","from_date":null,"wrote_date":"2025-09-18","handler":1004,"client_id":48,"purchase_contract_id":null,"project_id":3969,"sales_contract_id":4168,"erp_store_id":null,"status":2,"erp_send_type_id":null,"abstract":null,"description":"","verify_type":2,"next_verify_user":null,"next_stop_verify_user":null,"next_cancel_verify_user":null,"verify_at":"2025-09-18 09:49:20","stop_at":null,"cancel_at":null,"refuse_description":null,"is_resubmitted":false,"is_done":false,"number":"2","amount":"2000","created_by":1004,"stop_description":null,"extra":"{\"payment_collection_remind_ahead\":null,\"salesContractPaymentCollectionRemindReceivers\":[\"1004\"],\"salesContractPaymentCollectionRemindDates\":null}","outbound_status":true,"is_used":true,"is_cancel":false,"is_settle":false,"is_old":false,"created_at":"2025-09-18 09:36:36","updated_at":"2025-09-18 09:49:20","print_times":null},"projectProductTypes":[{"id":8078,"product_type_id":3,"key":3,"name":"\u5b58\u50a8\u8bbe\u5907","budget":"2000","pct":"62.38","project_id":3969,"profit":"1247.6"}],"projectProductRels":[{"id":11574,"project_id":3969,"product_id":41,"amount":"1000","number":2,"cost":"260","description":"","supplier_id":null,"hardware_from":"2025-09-18","software_from":null,"maintenance_from":null,"hardware_to":"2026-09-18","software_to":null,"maintenance_to":null,"total_amount":"2000","total_cost":"520","erp_sales_order_product_id":1896,"supplier":null,"product":{"id":41,"name":"X423A-R5","product_type":3,"product_component":15,"product_brand":6,"product_serie":1015,"product_misc":4,"product_qa":4,"pn":"","description":"","created_by":1013,"created_at":"2017-02-16 12:06:10","updated_at":"2026-01-06 11:47:31","pinyin_shortcut":"X423AR5","product_unit":4,"is_renew":false,"in_out_at":"2026-01-06 11:47:31.374476+08","productType":{"id":3,"key":3,"name":"\u5b58\u50a8\u8bbe\u5907"},"productComponent":{"id":15,"key":15,"name":"\u5b58\u50a8\u786c\u76d8"},"productBrand":{"id":6,"key":6,"name":"NetApp"},"productSerie":{"id":1015,"key":1015,"name":"900G 10K 2.5 SAS\u5b58\u50a8\u786c\u76d8"},"productUnit":{"id":4,"key":4,"name":"\u5757"}},"erpSalesOrderProduct":{"id":1896,"erp_sales_order_id":1589,"erp_store_id":null,"product_id":41,"description":"","number":"2","outbound":"2","amount":"1000","total_amount":"2000","last_number":"2","last_amount":"1000","last_total_amount":"2000","cost":"260","total_cost":"520","supplier_id":null,"hardware_from":"2025-09-18","software_from":null,"maintenance_from":null,"hardware_to":"2026-09-18","software_to":null,"maintenance_to":null}}],"projectContactPoints":[],"buildSalesOrderItems":[{"id":13379,"project_id":3969},{"id":13378,"project_id":3969}],"reimbursementAmountSum":null,"profit":1247.6,"contact_points_status_display":"\u672a\u8bbe\u7f6e","total_contact_paid_point":0,"total_contact_un_paid_point":0},"salesSupplierRels":[{"id":3852,"contract_id":4168,"supplier_id":489,"purchase_id":4167,"supplier":{"id":489,"key":489,"name":"\u5317\u4eac\u6234\u68ee\u7279\u7cfb\u7edf\u79d1\u6280\u6709\u9650\u516c\u53f8"},"purchase":{"id":4167,"key":4167,"serial_no":"TSKJ20250918-HYF-01"}}],"contractType":{"id":1,"key":1,"name":"\u4ea7\u54c1\u9500\u552e"},"handleBy":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0","sex":"M","department_id":1,"avatar":{"id":10,"user_id":1004,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1004.jpg"}},"remindDate":null,"serviceContractRemindDates":[],"salesContractRemindReceivers":[{"id":8641,"user_id":1004,"key":1004,"contract_id":4168,"user":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0","sex":"M","avatar":{"id":10,"user_id":1004,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1004.jpg"}}}],"serviceContractRemindReceivers":[],"salesContractPaymentCollectionRemindReceivers":[{"id":9710,"user_id":1004,"key":1004,"contract_id":4168,"user":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0","sex":"M","avatar":{"id":10,"user_id":1004,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1004.jpg"}}},{"id":9711,"user_id":1001,"key":1001,"contract_id":4168,"user":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/\/avatar\/e868e40f-1256-329e-9b1c-74e095049622.png"}}}],"salesContractPaymentCollectionRemindDates":[{"id":2585,"key":2585,"contract_id":4168,"name":"2025-09-30","value":"2000","overdue_days":13,"status":1,"remind_date":"2025-09-30","pct":100,"overdue_display":"\u903e\u671f13\u5929"}],"salesContractPayments":[{"id":"12049","key":"12049","contract_id":4168,"value":"2000","created_by":1013,"created_at":"2025-10-13 17:27:34","description":"","collected_date":"2025-10-13 00:00:00","amount":"2000","createdBy":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","department_id":7},"pct":100}],"salesContractInvoices":[{"id":2163,"key":2163,"contract_id":4168,"value":"2000.00","attachment_id":null,"from_date":"2025-09-26","description":"","is_draft":false,"is_cancel":false,"salesInvoiceAmounts":[{"id":890,"sales_invoice_id":2163,"amount":"2000","tax_rate":"13"}],"attachment":null,"attachmentRelationships":[],"files":[{"id":50657,"object_type":102,"object_id":2163,"attachment_id":28714,"attachment":{"id":28714,"key":28714,"name":"020d3fb4-7071-32d8-a42b-e41e255f879a","extension":"pdf","path":"\/v2\/attachment\/view\/wXfR6UQn7fW_MTEa9o-7H8Ixg0fJU0Zm\/020d3fb4-7071-32d8-a42b-e41e255f879a\/dzfp_25112000000206248720_\u4e2d\u90fd\u6570\u79d1\u4f9b\u5e94\u94fe\u7ba1\u7406\u6709\u9650\u516c\u53f8_20250926100635.pdf","orig_name":"dzfp_25112000000206248720_\u4e2d\u90fd\u6570\u79d1\u4f9b\u5e94\u94fe\u7ba1\u7406\u6709\u9650\u516c\u53f8_20250926100635.pdf"}}]}],"contractScans":[{"id":55277,"object_type":105,"object_id":4168,"attachment_id":28417,"attachment":{"id":28417,"key":28417,"name":"6974d662-bd61-3e50-8d68-0bd1d1b637ad","extension":"pdf","path":"\/v2\/attachment\/preview\/wXfR6UQn7fW_MTEa9o-7H8Ixg0fJU0Zm\/6974d662-bd61-3e50-8d68-0bd1d1b637ad\/2025_09_19_15_45_58.pdf","orig_name":"2025_09_19_15_45_58.pdf"}}],"receiptScans":[{"id":50281,"object_type":106,"object_id":4168,"attachment_id":28388,"attachment":{"id":28388,"key":28388,"name":"93809ae5-25b7-3ecc-b0d6-62a432e7cafb","extension":"jpg","path":"\/v2\/attachment\/preview\/wXfR6UQn7fW_MTEa9o-7H8Ixg0fJU0Zm\/93809ae5-25b7-3ecc-b0d6-62a432e7cafb\/66231758183049_.pic.jpg","orig_name":"66231758183049_.pic.jpg"}}],"verifyScans":[],"unreadComments":null,"collected_plan":2000,"projectProductTotalAmount":2000,"projectProductAllAmount":true,"projectProductTotalCost":520,"projectProductAllCost":true,"projectProductTotalCount":2,"invoiced":"2000.00","un_invoiced":0,"collected":"2000","un_collected":0,"is_collected":true,"handlerPerson":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0","avatar":{"id":10,"user_id":1004,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1004.jpg"}},"remind_date":"","remind_ahead_display":"\u65e0","expire_remind_ahead_display":"\u63d0\u524d30\u5929","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":true,"can_view_product_cost":true,"erp_all_un_settle_amount":0,"verifyList":[{"id":27,"erp_sales_order_id":1589,"user_id":1001,"status":1,"description":"","verify_at":"2025-09-18 09:49:20","user":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/\/avatar\/e868e40f-1256-329e-9b1c-74e095049622.png"}}}]},{"id":3998,"client_id":48,"signed_at":"2025-06-24","amount":"62075.1","handler":1004,"description":"","created_by":1004,"created_at":"2025-06-24 17:49:25","updated_at":"2026-01-14 09:54:04","contract_scan":null,"receipt_scan":null,"contract_type":2,"project_id":3873,"valid_date":null,"expire_date":"2026-08-07","sla":"","remind_ahead":"","expire_remind_ahead":"30 days","expire_reminded":false,"serial_no":"TS-YJC-20250526-001","payment_collection_remind_ahead":"1 day","from_project":3873,"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-06-24 17:49:25","is_verify":false,"is_draft":false,"erp_settle_amount":"62075.1","erp_un_settle_amount":"0","erp_payment_ticket_is_verify":false,"erp_collect_ticket_is_verify":false,"erp_cash_cost_ticket_is_verify":false,"erp_all_settle_amount":"62075.1","receipt_scan_uploaded":false,"verify_scan_uploaded":false,"contract_scan_uploaded":true,"is_edit_verify":false,"is_chargeback_verify":false,"b_date":25,"passed":2,"client":{"id":48,"key":48,"name":"\u4e2d\u90fd\u6570\u79d1\u4f9b\u5e94\u94fe\u7ba1\u7406\u6709\u9650\u516c\u53f8","logo":null,"sales_rep":1004,"salesRep":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0","avatar":{"id":10,"user_id":1004,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1004.jpg"}}},"contractScan":null,"receiptScan":null,"createdBy":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0","sex":"M","department_id":1,"avatar":{"id":10,"user_id":1004,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1004.jpg"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"commentCount":{"object_id":3998,"comment":7},"project":{"id":3873,"key":3873,"name":"2025\u5e74\u6570\u636e\u4e2d\u5fc3\u7ef4\u4fdd","erpSalesOrder":{"id":1529,"serial_no":"XSDD-20250624-00002","from_date":null,"wrote_date":"2025-06-24","handler":1004,"client_id":48,"purchase_contract_id":null,"project_id":3873,"sales_contract_id":3998,"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-06-30 09:50:54","stop_at":null,"cancel_at":null,"refuse_description":null,"is_resubmitted":false,"is_done":true,"number":"9","amount":"62075.1","created_by":1004,"stop_description":null,"extra":null,"outbound_status":false,"is_used":true,"is_cancel":false,"is_settle":true,"is_old":true,"created_at":"2025-06-24 17:49:25","updated_at":"2025-06-30 09:50:54","print_times":null,"erpSalesOrderVerifyRels":[],"erpSalesOrderStopVerifyRels":[]}},"erpSalesOrder":{"id":1529,"serial_no":"XSDD-20250624-00002","from_date":null,"wrote_date":"2025-06-24","handler":1004,"client_id":48,"purchase_contract_id":null,"project_id":3873,"sales_contract_id":3998,"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-06-30 09:50:54","stop_at":null,"cancel_at":null,"refuse_description":null,"is_resubmitted":false,"is_done":true,"number":"9","amount":"62075.1","created_by":1004,"stop_description":null,"extra":null,"outbound_status":false,"is_used":true,"is_cancel":false,"is_settle":true,"is_old":true,"created_at":"2025-06-24 17:49:25","updated_at":"2025-06-30 09:50:54","print_times":null,"erpSalesOrderVerifyRels":[],"erpSalesOrderStopVerifyRels":[],"erpSalesOrderCancelVerifyRels":[]},"fromProject":{"id":3873,"key":3873,"name":"2025\u5e74\u6570\u636e\u4e2d\u5fc3\u7ef4\u4fdd","description":"","total_contact_point":null,"paid_contact_point":null,"is_sales_order_ready":true,"project_product_version_id":1234,"bargain_date":"2025-06-24","collected":"62075.1","profit_pct":"76.05","budget":"62075.1","erpSalesOrder":{"id":1529,"serial_no":"XSDD-20250624-00002","from_date":null,"wrote_date":"2025-06-24","handler":1004,"client_id":48,"purchase_contract_id":null,"project_id":3873,"sales_contract_id":3998,"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-06-30 09:50:54","stop_at":null,"cancel_at":null,"refuse_description":null,"is_resubmitted":false,"is_done":true,"number":"9","amount":"62075.1","created_by":1004,"stop_description":null,"extra":null,"outbound_status":false,"is_used":true,"is_cancel":false,"is_settle":true,"is_old":true,"created_at":"2025-06-24 17:49:25","updated_at":"2025-06-30 09:50:54","print_times":null},"projectProductTypes":[{"id":8157,"product_type_id":19,"key":19,"name":"\u6280\u672f\u670d\u52a1","budget":"21157.6","pct":"76.05","project_id":3873,"profit":"16090.35"},{"id":8158,"product_type_id":2,"key":2,"name":"\u670d\u52a1\u5668","budget":"26046.5","pct":"76.05","project_id":3873,"profit":"19808.36"},{"id":8159,"product_type_id":22,"key":22,"name":"\u670d\u52a1","budget":"14871","pct":"76.05","project_id":3873,"profit":"11309.39"}],"projectProductRels":[{"id":11706,"project_id":3873,"product_id":922,"amount":"7800","number":1,"cost":null,"description":"","supplier_id":null,"hardware_from":null,"software_from":"2025-07-25","maintenance_from":null,"hardware_to":null,"software_to":"2026-07-25","maintenance_to":null,"total_amount":"7800","total_cost":null,"erp_sales_order_product_id":1734,"supplier":null,"product":{"id":922,"name":"\u6df1\u4fe1\u670d\u7ec8\u7aef\u68c0\u6d4b\u54cd\u5e94\u5e73\u53f0EDR\u7eed\u4fdd\u670d\u52a1","product_type":22,"product_component":200,"product_brand":12,"product_serie":1024,"product_misc":null,"product_qa":null,"pn":"","description":"","created_by":1013,"created_at":"2023-05-08 12:11:04","updated_at":"2026-01-28 10:32:39","pinyin_shortcut":"sxfzdjcxyptEDRxbfw","product_unit":2,"is_renew":false,"in_out_at":"2026-01-28 10:32:39.333577+08","productType":{"id":22,"key":22,"name":"\u670d\u52a1"},"productComponent":{"id":200,"key":200,"name":"\u7eed\u4fdd\u670d\u52a1"},"productBrand":{"id":12,"key":12,"name":"\u6df1\u4fe1\u670d"},"productSerie":{"id":1024,"key":1024,"name":"\u6df1\u4fe1\u670d\u7ec8\u7aef\u68c0\u6d4b\u54cd\u5e94\u5e73\u53f0EDR\u7eed\u4fdd\u670d\u52a1"},"productUnit":{"id":2,"key":2,"name":"\u5957"}},"erpSalesOrderProduct":{"id":1734,"erp_sales_order_id":1529,"erp_store_id":null,"product_id":922,"description":"","number":"1","outbound":"0","amount":"7800","total_amount":"7800","last_number":"1","last_amount":"7800","last_total_amount":"7800","cost":"5000.00","total_cost":"5000","supplier_id":null,"hardware_from":null,"software_from":"2025-07-25","maintenance_from":null,"hardware_to":null,"software_to":"2026-07-25","maintenance_to":null}},{"id":11707,"project_id":3873,"product_id":1663,"amount":"3960","number":1,"cost":null,"description":"","supplier_id":null,"hardware_from":null,"software_from":"2025-07-25","maintenance_from":null,"hardware_to":null,"software_to":"2026-07-25","maintenance_to":null,"total_amount":"3960","total_cost":null,"erp_sales_order_product_id":1732,"supplier":null,"product":{"id":1663,"name":"URL&\u5e94\u7528\u8bc6\u522b\u89c4\u5219\u5e93\u5347\u7ea7\uff08\u9002\u7528\u4e8eAC-1000-B1250\uff09","product_type":22,"product_component":208,"product_brand":12,"product_serie":1414,"product_misc":null,"product_qa":null,"pn":"","description":"","created_by":1013,"created_at":"2024-07-04 15:30:00","updated_at":"2024-07-04 15:30:00","pinyin_shortcut":"URLampyysbgzksjsyyAC1000B1250","product_unit":2,"is_renew":true,"in_out_at":null,"productType":{"id":22,"key":22,"name":"\u670d\u52a1"},"productComponent":{"id":208,"key":208,"name":"\u4ea7\u54c1\u5347\u7ea7"},"productBrand":{"id":12,"key":12,"name":"\u6df1\u4fe1\u670d"},"productSerie":{"id":1414,"key":1414,"name":"URL&\u5e94\u7528\u8bc6\u522b\u89c4\u5219\u5e93\u5347\u7ea7\uff08\u9002\u7528\u4e8eAC-1000-B1250\uff09"},"productUnit":{"id":2,"key":2,"name":"\u5957"}},"erpSalesOrderProduct":{"id":1732,"erp_sales_order_id":1529,"erp_store_id":null,"product_id":1663,"description":"","number":"1","outbound":"0","amount":"3960","total_amount":"3960","last_number":"1","last_amount":"3960","last_total_amount":"3960","cost":"2714.00","total_cost":"2714","supplier_id":null,"hardware_from":null,"software_from":"2025-07-25","maintenance_from":null,"hardware_to":null,"software_to":"2026-07-25","maintenance_to":null}},{"id":11708,"project_id":3873,"product_id":1664,"amount":"3111","number":1,"cost":null,"description":"","supplier_id":null,"hardware_from":"2025-07-25","software_from":null,"maintenance_from":null,"hardware_to":"2026-07-25","software_to":null,"maintenance_to":null,"total_amount":"3111","total_cost":null,"erp_sales_order_product_id":1733,"supplier":null,"product":{"id":1664,"name":"\u6df1\u4fe1\u670d\u4ea7\u54c1\u8d28\u4fdd+\u8f6f\u4ef6\u5347\u7ea7\u670d\u52a1\uff08\u9002\u7528\u4e8eAC-1000-B1250\uff09","product_type":22,"product_component":189,"product_brand":12,"product_serie":1415,"product_misc":null,"product_qa":null,"pn":"","description":"","created_by":1013,"created_at":"2024-07-04 15:31:49","updated_at":"2024-07-04 15:31:49","pinyin_shortcut":"sxfcpzbrjsjfwsyyAC1000B1250","product_unit":2,"is_renew":true,"in_out_at":null,"productType":{"id":22,"key":22,"name":"\u670d\u52a1"},"productComponent":{"id":189,"key":189,"name":"\u8f6f\u4ef6\u5347\u7ea7\u786c\u4ef6\u8d28\u4fdd"},"productBrand":{"id":12,"key":12,"name":"\u6df1\u4fe1\u670d"},"productSerie":{"id":1415,"key":1415,"name":"\u6df1\u4fe1\u670d\u4ea7\u54c1\u8d28\u4fdd+\u8f6f\u4ef6\u5347\u7ea7\u670d\u52a1\uff08\u9002\u7528\u4e8eAC-1000-B1250\uff09"},"productUnit":{"id":2,"key":2,"name":"\u5957"}},"erpSalesOrderProduct":{"id":1733,"erp_sales_order_id":1529,"erp_store_id":null,"product_id":1664,"description":"","number":"1","outbound":"0","amount":"3111","total_amount":"3111","last_number":"1","last_amount":"3111","last_total_amount":"3111","cost":"2261.00","total_cost":"2261","supplier_id":null,"hardware_from":"2025-07-25","software_from":null,"maintenance_from":null,"hardware_to":"2026-07-25","software_to":null,"maintenance_to":null}},{"id":11709,"project_id":3873,"product_id":941,"amount":"21157.6","number":1,"cost":null,"description":"","supplier_id":null,"hardware_from":null,"software_from":null,"maintenance_from":"2025-07-14","hardware_to":null,"software_to":null,"maintenance_to":"2026-07-13","total_amount":"21157.6","total_cost":null,"erp_sales_order_product_id":1730,"supplier":null,"product":{"id":941,"name":"\u62d3\u5b9e\u4eba\u5de5\u6280\u672f\u670d\u52a1","product_type":19,"product_component":151,"product_brand":133,"product_serie":592,"product_misc":null,"product_qa":null,"pn":"","description":"","created_by":1013,"created_at":"2023-08-03 09:29:24","updated_at":"2026-02-05 16:37:56","pinyin_shortcut":"tsrgjsfw","product_unit":7,"is_renew":false,"in_out_at":"2026-02-05 16:37:56.557723+08","productType":{"id":19,"key":19,"name":"\u6280\u672f\u670d\u52a1"},"productComponent":{"id":151,"key":151,"name":"\u4eba\u5de5\u670d\u52a1"},"productBrand":{"id":133,"key":133,"name":"\u62d3\u5b9e"},"productSerie":{"id":592,"key":592,"name":"\u5b89\u88c5\u8c03\u8bd5\u670d\u52a1"},"productUnit":{"id":7,"key":7,"name":"\u6b21"}},"erpSalesOrderProduct":{"id":1730,"erp_sales_order_id":1529,"erp_store_id":null,"product_id":941,"description":"","number":"1","outbound":"0","amount":"21157.6","total_amount":"21157.6","last_number":"1","last_amount":"21157.6","last_total_amount":"21157.6","cost":"0","total_cost":"0","supplier_id":null,"hardware_from":null,"software_from":null,"maintenance_from":"2025-07-14","hardware_to":null,"software_to":null,"maintenance_to":"2026-07-13"}},{"id":11710,"project_id":3873,"product_id":1376,"amount":"5209.3","number":5,"cost":"1500","description":"","supplier_id":null,"hardware_from":"2025-08-08","software_from":null,"maintenance_from":null,"hardware_to":"2026-08-07","software_to":null,"maintenance_to":null,"total_amount":"26046.50","total_cost":"7500","erp_sales_order_product_id":1731,"supplier":null,"product":{"id":1376,"name":"CBSOMA11M","product_type":2,"product_component":13,"product_brand":4,"product_serie":1052,"product_misc":null,"product_qa":null,"pn":"","description":"\u8054\u60f3\u539f\u5382\u4e00\u5e745*9\u670d\u52a1","created_by":1001,"created_at":"2024-01-26 17:55:26","updated_at":"2025-10-29 17:37:40","pinyin_shortcut":"CBSOMA11M","product_unit":8,"is_renew":false,"in_out_at":"2025-10-29 17:37:40.337224+08","productType":{"id":2,"key":2,"name":"\u670d\u52a1\u5668"},"productComponent":{"id":13,"key":13,"name":"\u670d\u52a1\u5668\u91d1\u724c\u670d\u52a1"},"productBrand":{"id":4,"key":4,"name":"\u8054\u60f3"},"productSerie":{"id":1052,"key":1052,"name":"SR650\u670d\u52a1\u5668\u4e00\u5e745*9\u539f\u5382\u670d\u52a1"},"productUnit":{"id":8,"key":8,"name":"\u5e74"}},"erpSalesOrderProduct":{"id":1731,"erp_sales_order_id":1529,"erp_store_id":null,"product_id":1376,"description":"","number":"5","outbound":"5","amount":"5209.3","total_amount":"26046.50","last_number":"5","last_amount":"5209.3","last_total_amount":"26046.50","cost":"1500","total_cost":"7500","supplier_id":null,"hardware_from":"2025-08-08","software_from":null,"maintenance_from":null,"hardware_to":"2026-08-07","software_to":null,"maintenance_to":null}}],"projectContactPoints":[],"buildSalesOrderItems":[{"id":13057,"project_id":3873},{"id":13056,"project_id":3873},{"id":13064,"project_id":3873},{"id":13063,"project_id":3873},{"id":13062,"project_id":3873},{"id":13061,"project_id":3873},{"id":13060,"project_id":3873},{"id":13059,"project_id":3873},{"id":13058,"project_id":3873}],"reimbursementAmountSum":{"project_id":3873,"sum":"1044.63"},"profit":47208.11355,"contact_points_status_display":"\u672a\u8bbe\u7f6e","total_contact_paid_point":0,"total_contact_un_paid_point":0},"salesSupplierRels":[{"id":3949,"contract_id":3998,"supplier_id":236,"purchase_id":4004,"supplier":{"id":236,"key":236,"name":"\u5317\u4eac\u5929\u4fe1\u5b8f\u8fbe\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8"},"purchase":{"id":4004,"key":4004,"serial_no":"TSKJ20250630-HYF-002"}},{"id":3950,"contract_id":3998,"supplier_id":116,"purchase_id":4220,"supplier":{"id":116,"key":116,"name":"\u56db\u5ddd\u957f\u8679\u4f73\u534e\u4fe1\u606f\u4ea7\u54c1\u6709\u9650\u8d23\u4efb\u516c\u53f8"},"purchase":{"id":4220,"key":4220,"serial_no":"20251028001"}}],"contractType":{"id":2,"key":2,"name":"\u8fd0\u7ef4\u670d\u52a1"},"handleBy":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0","sex":"M","department_id":1,"avatar":{"id":10,"user_id":1004,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1004.jpg"}},"remindDate":null,"serviceContractRemindDates":[],"salesContractRemindReceivers":[{"id":8700,"user_id":1004,"key":1004,"contract_id":3998,"user":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0","sex":"M","avatar":{"id":10,"user_id":1004,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1004.jpg"}}}],"serviceContractRemindReceivers":[],"salesContractPaymentCollectionRemindReceivers":[{"id":9790,"user_id":1004,"key":1004,"contract_id":3998,"user":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0","sex":"M","avatar":{"id":10,"user_id":1004,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1004.jpg"}}}],"salesContractPaymentCollectionRemindDates":[{"id":2475,"key":2475,"contract_id":3998,"name":"2025-07-31","value":"62075.1","overdue_days":null,"status":1,"remind_date":"2025-07-31","pct":100,"overdue_display":""}],"salesContractPayments":[{"id":"1361","key":"1361","contract_id":3998,"value":"62075.1","created_by":1013,"created_at":"2025-06-30 09:50:54","description":null,"collected_date":"2025-06-30 00:00:00","amount":"62075.1","createdBy":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","department_id":7},"pct":100}],"salesContractInvoices":[{"id":2084,"key":2084,"contract_id":3998,"value":"62075.10","attachment_id":null,"from_date":"2025-06-25","description":"","is_draft":false,"is_cancel":false,"salesInvoiceAmounts":[{"id":3106,"sales_invoice_id":2084,"amount":"3960","tax_rate":"13"},{"id":3107,"sales_invoice_id":2084,"amount":"58115.1","tax_rate":"6"}],"attachment":null,"attachmentRelationships":[],"files":[{"id":35368,"object_type":102,"object_id":2084,"attachment_id":26542,"attachment":{"id":26542,"key":26542,"name":"b824f4f8-9cb0-3bb8-9043-eabcefca78aa","extension":"pdf","path":"\/v2\/attachment\/view\/wXfR6UQn7fW_MTEa9o-7H8Ixg0fJU0Zm\/b824f4f8-9cb0-3bb8-9043-eabcefca78aa\/dzfp_25112000000130827455_\u4e2d\u90fd\u6570\u79d1\u4f9b\u5e94\u94fe\u7ba1\u7406\u6709\u9650\u516c\u53f8_20250625093247.pdf","orig_name":"dzfp_25112000000130827455_\u4e2d\u90fd\u6570\u79d1\u4f9b\u5e94\u94fe\u7ba1\u7406\u6709\u9650\u516c\u53f8_20250625093247.pdf"}}]}],"contractScans":[{"id":55337,"object_type":105,"object_id":3998,"attachment_id":26540,"attachment":{"id":26540,"key":26540,"name":"f60f6e42-f01c-31e2-9913-9b08f0b63f0a","extension":"pdf","path":"\/v2\/attachment\/preview\/wXfR6UQn7fW_MTEa9o-7H8Ixg0fJU0Zm\/f60f6e42-f01c-31e2-9913-9b08f0b63f0a\/\u4e2d\u90fd\u6570\u79d1\u5408\u540c.pdf","orig_name":"\u4e2d\u90fd\u6570\u79d1\u5408\u540c.pdf"}}],"receiptScans":[],"verifyScans":[],"unreadComments":null,"collected_plan":62075.1,"projectProductTotalAmount":62075.1,"projectProductAllAmount":true,"projectProductTotalCost":7500,"projectProductAllCost":false,"projectProductTotalCount":9,"invoiced":"62075.10","un_invoiced":0,"collected":"62075.1","un_collected":0,"is_collected":true,"handlerPerson":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0","avatar":{"id":10,"user_id":1004,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1004.jpg"}},"remind_date":"","remind_ahead_display":"\u65e0","expire_remind_ahead_display":"\u63d0\u524d30\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,"can_view_product_cost":true,"erp_all_un_settle_amount":0,"verifyList":[]},{"id":3783,"client_id":48,"signed_at":"2025-02-17","amount":"3200","handler":1004,"description":"","created_by":1004,"created_at":"2025-02-12 21:12:33","updated_at":"2026-01-14 10:58:46","contract_scan":null,"receipt_scan":null,"contract_type":1,"project_id":3776,"valid_date":null,"expire_date":"2026-02-17","sla":"","remind_ahead":"","expire_remind_ahead":"30 days","expire_reminded":true,"serial_no":"TS-YJC-20250217001","payment_collection_remind_ahead":"1 day","from_project":3776,"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-02-12 21:12:33","is_verify":false,"is_draft":false,"erp_settle_amount":"3200","erp_un_settle_amount":"0","erp_payment_ticket_is_verify":false,"erp_collect_ticket_is_verify":false,"erp_cash_cost_ticket_is_verify":false,"erp_all_settle_amount":"3200","receipt_scan_uploaded":true,"verify_scan_uploaded":false,"contract_scan_uploaded":true,"is_edit_verify":false,"is_chargeback_verify":false,"b_date":146,"passed":2,"client":{"id":48,"key":48,"name":"\u4e2d\u90fd\u6570\u79d1\u4f9b\u5e94\u94fe\u7ba1\u7406\u6709\u9650\u516c\u53f8","logo":null,"sales_rep":1004,"salesRep":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0","avatar":{"id":10,"user_id":1004,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1004.jpg"}}},"contractScan":null,"receiptScan":null,"createdBy":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0","sex":"M","department_id":1,"avatar":{"id":10,"user_id":1004,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1004.jpg"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"commentCount":{"object_id":3783,"comment":9},"project":{"id":3776,"key":3776,"name":"\u7ea2\u886b\u5b58\u50a8\u786c\u76d8","erpSalesOrder":{"id":1443,"serial_no":"XSDD-20250212-00001","from_date":null,"wrote_date":"2025-02-17","handler":1004,"client_id":48,"purchase_contract_id":null,"project_id":3776,"sales_contract_id":3783,"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-25 17:11:38","stop_at":null,"cancel_at":null,"refuse_description":null,"is_resubmitted":false,"is_done":true,"number":"1","amount":"3200","created_by":1004,"stop_description":null,"extra":null,"outbound_status":false,"is_used":false,"is_cancel":false,"is_settle":true,"is_old":true,"created_at":"2025-02-12 21:12:33","updated_at":"2025-02-25 17:11:38","print_times":null,"erpSalesOrderVerifyRels":[],"erpSalesOrderStopVerifyRels":[]}},"erpSalesOrder":{"id":1443,"serial_no":"XSDD-20250212-00001","from_date":null,"wrote_date":"2025-02-17","handler":1004,"client_id":48,"purchase_contract_id":null,"project_id":3776,"sales_contract_id":3783,"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-25 17:11:38","stop_at":null,"cancel_at":null,"refuse_description":null,"is_resubmitted":false,"is_done":true,"number":"1","amount":"3200","created_by":1004,"stop_description":null,"extra":null,"outbound_status":false,"is_used":false,"is_cancel":false,"is_settle":true,"is_old":true,"created_at":"2025-02-12 21:12:33","updated_at":"2025-02-25 17:11:38","print_times":null,"erpSalesOrderVerifyRels":[],"erpSalesOrderStopVerifyRels":[],"erpSalesOrderCancelVerifyRels":[]},"fromProject":{"id":3776,"key":3776,"name":"\u7ea2\u886b\u5b58\u50a8\u786c\u76d8","description":"","total_contact_point":null,"paid_contact_point":null,"is_sales_order_ready":true,"project_product_version_id":1302,"bargain_date":"2025-02-17","collected":"3200","profit_pct":"30.63","budget":"3200","erpSalesOrder":{"id":1443,"serial_no":"XSDD-20250212-00001","from_date":null,"wrote_date":"2025-02-17","handler":1004,"client_id":48,"purchase_contract_id":null,"project_id":3776,"sales_contract_id":3783,"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-25 17:11:38","stop_at":null,"cancel_at":null,"refuse_description":null,"is_resubmitted":false,"is_done":true,"number":"1","amount":"3200","created_by":1004,"stop_description":null,"extra":null,"outbound_status":false,"is_used":false,"is_cancel":false,"is_settle":true,"is_old":true,"created_at":"2025-02-12 21:12:33","updated_at":"2025-02-25 17:11:38","print_times":null},"projectProductTypes":[{"id":8262,"product_type_id":3,"key":3,"name":"\u5b58\u50a8\u8bbe\u5907","budget":"3200","pct":"30.63","project_id":3776,"profit":"980.16"}],"projectProductRels":[{"id":11863,"project_id":3776,"product_id":1939,"amount":"3200","number":1,"cost":null,"description":"","supplier_id":null,"hardware_from":"2025-02-13","software_from":null,"maintenance_from":null,"hardware_to":"2026-02-12","software_to":null,"maintenance_to":null,"total_amount":"3200","total_cost":null,"erp_sales_order_product_id":1525,"supplier":null,"product":{"id":1939,"name":"MS3M2HD002T0A3AEE","product_type":3,"product_component":15,"product_brand":50,"product_serie":1598,"product_misc":null,"product_qa":null,"pn":"","description":"\u5b8f\u6749\u5b58\u50a8MS2500G2-12C 2T 3.5\u82f1\u5bf8 7.2K HDD\u786c\u76d8","created_by":1013,"created_at":"2025-02-13 09:42:30","updated_at":"2025-02-13 10:32:57","pinyin_shortcut":"MS3M2HD002T0A3AEE","product_unit":4,"is_renew":false,"in_out_at":null,"productType":{"id":3,"key":3,"name":"\u5b58\u50a8\u8bbe\u5907"},"productComponent":{"id":15,"key":15,"name":"\u5b58\u50a8\u786c\u76d8"},"productBrand":{"id":50,"key":50,"name":"\u5b8f\u6749"},"productSerie":{"id":1598,"key":1598,"name":"2T 3.5\u82f1\u5bf8 7.2K HDD"},"productUnit":{"id":4,"key":4,"name":"\u5757"}},"erpSalesOrderProduct":{"id":1525,"erp_sales_order_id":1443,"erp_store_id":null,"product_id":1939,"description":"","number":"1","outbound":"0","amount":"3200","total_amount":"3200","last_number":"1","last_amount":"3200","last_total_amount":"3200","cost":"2000.00","total_cost":"2000","supplier_id":null,"hardware_from":"2025-02-13","software_from":null,"maintenance_from":null,"hardware_to":"2026-02-12","software_to":null,"maintenance_to":null}}],"projectContactPoints":[],"buildSalesOrderItems":[{"id":12646,"project_id":3776}],"reimbursementAmountSum":{"project_id":3776,"sum":"365.39"},"profit":980.16,"contact_points_status_display":"\u672a\u8bbe\u7f6e","total_contact_paid_point":0,"total_contact_un_paid_point":0},"salesSupplierRels":[{"id":4051,"contract_id":3783,"supplier_id":174,"purchase_id":3784,"supplier":{"id":174,"key":174,"name":"\u5317\u4eac\u79d1\u534e\u5609\u4e1a\u79d1\u8d38\u6709\u9650\u516c\u53f8"},"purchase":{"id":3784,"key":3784,"serial_no":"TSKJ20250212-HYF-001"}}],"contractType":{"id":1,"key":1,"name":"\u4ea7\u54c1\u9500\u552e"},"handleBy":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0","sex":"M","department_id":1,"avatar":{"id":10,"user_id":1004,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1004.jpg"}},"remindDate":null,"serviceContractRemindDates":[],"salesContractRemindReceivers":[{"id":8781,"user_id":1004,"key":1004,"contract_id":3783,"user":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0","sex":"M","avatar":{"id":10,"user_id":1004,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1004.jpg"}}}],"serviceContractRemindReceivers":[],"salesContractPaymentCollectionRemindReceivers":[{"id":9920,"user_id":1004,"key":1004,"contract_id":3783,"user":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0","sex":"M","avatar":{"id":10,"user_id":1004,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1004.jpg"}}}],"salesContractPaymentCollectionRemindDates":[{"id":2334,"key":2334,"contract_id":3783,"name":"2025-03-31","value":"3200","overdue_days":null,"status":1,"remind_date":"2025-03-31","pct":100,"overdue_display":""}],"salesContractPayments":[{"id":"1228","key":"1228","contract_id":3783,"value":"3200","created_by":1013,"created_at":"2025-02-25 17:11:38","description":null,"collected_date":"2025-02-25 00:00:00","amount":"3200","createdBy":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","department_id":7},"pct":100}],"salesContractInvoices":[{"id":1952,"key":1952,"contract_id":3783,"value":"3200.00","attachment_id":null,"from_date":"2025-02-18","description":"","is_draft":false,"is_cancel":false,"salesInvoiceAmounts":[{"id":103,"sales_invoice_id":1952,"amount":"3200","tax_rate":"13"}],"attachment":null,"attachmentRelationships":[],"files":[{"id":32367,"object_type":102,"object_id":1952,"attachment_id":24179,"attachment":{"id":24179,"key":24179,"name":"8283bf9f-3883-3f82-a1fb-c1e63ef5eed9","extension":"pdf","path":"\/v2\/attachment\/view\/wXfR6UQn7fW_MTEa9o-7H8Ixg0fJU0Zm\/8283bf9f-3883-3f82-a1fb-c1e63ef5eed9\/dzfp_25112000000031275603_\u4e2d\u90fd\u6570\u79d1\u4f9b\u5e94\u94fe\u7ba1\u7406\u6709\u9650\u516c\u53f8_20250218133845.pdf","orig_name":"dzfp_25112000000031275603_\u4e2d\u90fd\u6570\u79d1\u4f9b\u5e94\u94fe\u7ba1\u7406\u6709\u9650\u516c\u53f8_20250218133845.pdf"}}]}],"contractScans":[{"id":55425,"object_type":105,"object_id":3783,"attachment_id":24294,"attachment":{"id":24294,"key":24294,"name":"35d7e69c-6922-340d-98d1-9dc08c8647fb","extension":"pdf","path":"\/v2\/attachment\/preview\/wXfR6UQn7fW_MTEa9o-7H8Ixg0fJU0Zm\/35d7e69c-6922-340d-98d1-9dc08c8647fb\/2025_02_26_11_08_56.pdf","orig_name":"2025_02_26_11_08_56.pdf"}}],"receiptScans":[{"id":32368,"object_type":106,"object_id":3783,"attachment_id":24182,"attachment":{"id":24182,"key":24182,"name":"9b5931a8-b7d1-34db-801d-d3600dc40150","extension":"pdf","path":"\/v2\/attachment\/preview\/wXfR6UQn7fW_MTEa9o-7H8Ixg0fJU0Zm\/9b5931a8-b7d1-34db-801d-d3600dc40150\/DOC021825-02182025141505.pdf","orig_name":"DOC021825-02182025141505.pdf"}}],"verifyScans":[],"unreadComments":null,"collected_plan":3200,"projectProductTotalAmount":3200,"projectProductAllAmount":true,"projectProductTotalCost":0,"projectProductAllCost":false,"projectProductTotalCount":1,"invoiced":"3200.00","un_invoiced":0,"collected":"3200","un_collected":0,"is_collected":true,"handlerPerson":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0","avatar":{"id":10,"user_id":1004,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1004.jpg"}},"remind_date":"","remind_ahead_display":"\u65e0","expire_remind_ahead_display":"\u63d0\u524d30\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,"can_view_product_cost":true,"erp_all_un_settle_amount":0,"verifyList":[]},{"id":3547,"client_id":48,"signed_at":"2024-09-23","amount":"7600","handler":1004,"description":"","created_by":1004,"created_at":"2024-09-18 09:31:24","updated_at":"2025-01-09 14:48:00","contract_scan":null,"receipt_scan":null,"contract_type":1,"project_id":3658,"valid_date":null,"expire_date":null,"sla":"","remind_ahead":"","expire_remind_ahead":"","expire_reminded":false,"serial_no":"TS-YJC-2024092301","payment_collection_remind_ahead":"7 days","from_project":3658,"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-18 13:26:43","is_verify":false,"is_draft":false,"erp_settle_amount":"7600","erp_un_settle_amount":"0","erp_payment_ticket_is_verify":false,"erp_collect_ticket_is_verify":false,"erp_cash_cost_ticket_is_verify":false,"erp_all_settle_amount":"7600","receipt_scan_uploaded":true,"verify_scan_uploaded":false,"contract_scan_uploaded":true,"is_edit_verify":false,"is_chargeback_verify":false,"b_date":null,"passed":1,"client":{"id":48,"key":48,"name":"\u4e2d\u90fd\u6570\u79d1\u4f9b\u5e94\u94fe\u7ba1\u7406\u6709\u9650\u516c\u53f8","logo":null,"sales_rep":1004,"salesRep":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0","avatar":{"id":10,"user_id":1004,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1004.jpg"}}},"contractScan":null,"receiptScan":null,"createdBy":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0","sex":"M","department_id":1,"avatar":{"id":10,"user_id":1004,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1004.jpg"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"commentCount":{"object_id":3547,"comment":10},"project":{"id":3658,"key":3658,"name":"Netapp\u5b58\u50a8\u786c\u76d8","erpSalesOrder":{"id":1351,"serial_no":"XSDD-20241023-00001","from_date":null,"wrote_date":"2024-09-23","handler":1004,"client_id":48,"purchase_contract_id":null,"project_id":3658,"sales_contract_id":3547,"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-23 17:15:47","stop_at":null,"cancel_at":null,"refuse_description":null,"is_resubmitted":false,"is_done":true,"number":"2","amount":"7600","created_by":1004,"stop_description":null,"extra":null,"outbound_status":false,"is_used":false,"is_cancel":false,"is_settle":true,"is_old":true,"created_at":"2024-09-18 09:31:24","updated_at":"2024-10-23 17:15:47","print_times":null,"erpSalesOrderVerifyRels":[],"erpSalesOrderStopVerifyRels":[]}},"erpSalesOrder":{"id":1351,"serial_no":"XSDD-20241023-00001","from_date":null,"wrote_date":"2024-09-23","handler":1004,"client_id":48,"purchase_contract_id":null,"project_id":3658,"sales_contract_id":3547,"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-23 17:15:47","stop_at":null,"cancel_at":null,"refuse_description":null,"is_resubmitted":false,"is_done":true,"number":"2","amount":"7600","created_by":1004,"stop_description":null,"extra":null,"outbound_status":false,"is_used":false,"is_cancel":false,"is_settle":true,"is_old":true,"created_at":"2024-09-18 09:31:24","updated_at":"2024-10-23 17:15:47","print_times":null,"erpSalesOrderVerifyRels":[],"erpSalesOrderStopVerifyRels":[],"erpSalesOrderCancelVerifyRels":[]},"fromProject":{"id":3658,"key":3658,"name":"Netapp\u5b58\u50a8\u786c\u76d8","description":"","total_contact_point":null,"paid_contact_point":null,"is_sales_order_ready":true,"project_product_version_id":584,"bargain_date":"2024-09-23","collected":"7600","profit_pct":"66.68","budget":"7600","erpSalesOrder":{"id":1351,"serial_no":"XSDD-20241023-00001","from_date":null,"wrote_date":"2024-09-23","handler":1004,"client_id":48,"purchase_contract_id":null,"project_id":3658,"sales_contract_id":3547,"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-23 17:15:47","stop_at":null,"cancel_at":null,"refuse_description":null,"is_resubmitted":false,"is_done":true,"number":"2","amount":"7600","created_by":1004,"stop_description":null,"extra":null,"outbound_status":false,"is_used":false,"is_cancel":false,"is_settle":true,"is_old":true,"created_at":"2024-09-18 09:31:24","updated_at":"2024-10-23 17:15:47","print_times":null},"projectProductTypes":[{"id":5487,"product_type_id":3,"key":3,"name":"\u5b58\u50a8\u8bbe\u5907","budget":"7600.00","pct":"66.68","project_id":3658,"profit":"5067.68"}],"projectProductRels":[{"id":7167,"project_id":3658,"product_id":1780,"amount":"3800","number":2,"cost":"800","description":"\u4e8c\u624b\u914d\u4ef6,9.5\u6210\u65b0","supplier_id":165,"hardware_from":"2024-09-18","software_from":null,"maintenance_from":null,"hardware_to":"2025-09-17","software_to":null,"maintenance_to":null,"total_amount":"7600","total_cost":"1600","erp_sales_order_product_id":1227,"supplier":{"id":165,"key":165,"name":"\u5317\u4eac\u7eb3\u6069\u6052\u6cf0\u79d1\u6280\u6709\u9650\u516c\u53f8"},"product":{"id":1780,"name":"X343A-R6","product_type":3,"product_component":15,"product_brand":6,"product_serie":1149,"product_misc":null,"product_qa":null,"pn":"","description":"","created_by":1013,"created_at":"2024-09-18 10:38:23","updated_at":"2026-03-03 09:37:09","pinyin_shortcut":"X343AR6","product_unit":3,"is_renew":false,"in_out_at":"2026-03-03 09:37:09.013419+08","productType":{"id":3,"key":3,"name":"\u5b58\u50a8\u8bbe\u5907"},"productComponent":{"id":15,"key":15,"name":"\u5b58\u50a8\u786c\u76d8"},"productBrand":{"id":6,"key":6,"name":"NetApp"},"productSerie":{"id":1149,"key":1149,"name":"1.8T 10K 2.5 SAS\u5b58\u50a8\u786c\u76d8"},"productUnit":{"id":3,"key":3,"name":"\u4e2a"}},"erpSalesOrderProduct":{"id":1227,"erp_sales_order_id":1351,"erp_store_id":null,"product_id":1780,"description":"\u4e8c\u624b\u914d\u4ef6,9.5\u6210\u65b0","number":"2","outbound":"0","amount":"3800","total_amount":"7600","last_number":null,"last_amount":null,"last_total_amount":null,"cost":"800","total_cost":"1600","supplier_id":165,"hardware_from":"2024-09-18","software_from":null,"maintenance_from":null,"hardware_to":"2025-09-17","software_to":null,"maintenance_to":null}}],"projectContactPoints":[],"buildSalesOrderItems":[{"id":9756,"project_id":3658},{"id":9757,"project_id":3658}],"reimbursementAmountSum":null,"profit":5067.68,"contact_points_status_display":"\u672a\u8bbe\u7f6e","total_contact_paid_point":0,"total_contact_un_paid_point":0},"salesSupplierRels":[{"id":1957,"contract_id":3547,"supplier_id":165,"purchase_id":3561,"supplier":{"id":165,"key":165,"name":"\u5317\u4eac\u7eb3\u6069\u6052\u6cf0\u79d1\u6280\u6709\u9650\u516c\u53f8"},"purchase":{"id":3561,"key":3561,"serial_no":"20240918"}}],"contractType":{"id":1,"key":1,"name":"\u4ea7\u54c1\u9500\u552e"},"handleBy":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0","sex":"M","department_id":1,"avatar":{"id":10,"user_id":1004,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1004.jpg"}},"remindDate":null,"serviceContractRemindDates":[],"salesContractRemindReceivers":[],"serviceContractRemindReceivers":[],"salesContractPaymentCollectionRemindReceivers":[{"id":6953,"user_id":1004,"key":1004,"contract_id":3547,"user":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0","sex":"M","avatar":{"id":10,"user_id":1004,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1004.jpg"}}},{"id":6955,"user_id":1001,"key":1001,"contract_id":3547,"user":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/\/avatar\/e868e40f-1256-329e-9b1c-74e095049622.png"}}}],"salesContractPaymentCollectionRemindDates":[{"id":2041,"key":2041,"contract_id":3547,"name":"2024-10-31","value":"7600","overdue_days":null,"status":1,"remind_date":"2024-10-31","pct":100,"overdue_display":""}],"salesContractPayments":[{"id":"1146","key":"1146","contract_id":3547,"value":"7600","created_by":1013,"created_at":"2024-10-23 17:15:46","description":null,"collected_date":"2024-10-23 00:00:00","amount":"7600","createdBy":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","department_id":7},"pct":100}],"salesContractInvoices":[{"id":1810,"key":1810,"contract_id":3547,"value":"7600.00","attachment_id":null,"from_date":"2024-09-26","description":"","is_draft":false,"is_cancel":false,"salesInvoiceAmounts":[{"id":418,"sales_invoice_id":1810,"amount":"7600","tax_rate":"13"}],"attachment":null,"attachmentRelationships":[],"files":[{"id":28972,"object_type":102,"object_id":1810,"attachment_id":21716,"attachment":{"id":21716,"key":21716,"name":"43577711-7507-3c18-8b22-8bfa74d1dfce","extension":"pdf","path":"\/v2\/attachment\/view\/wXfR6UQn7fW_MTEa9o-7H8Ixg0fJU0Zm\/43577711-7507-3c18-8b22-8bfa74d1dfce\/dzfp_24112000000139576756_\u4e2d\u90fd\u7269\u6d41\u6709\u9650\u516c\u53f8_20240926103256.pdf","orig_name":"dzfp_24112000000139576756_\u4e2d\u90fd\u7269\u6d41\u6709\u9650\u516c\u53f8_20240926103256.pdf"}}]}],"contractScans":[{"id":31656,"object_type":105,"object_id":3547,"attachment_id":22367,"attachment":{"id":22367,"key":22367,"name":"724ba639-c78f-3d75-bf3a-5d4466247466","extension":"pdf","path":"\/v2\/attachment\/preview\/wXfR6UQn7fW_MTEa9o-7H8Ixg0fJU0Zm\/724ba639-c78f-3d75-bf3a-5d4466247466\/DOC103124-10312024091010 1.pdf","orig_name":"DOC103124-10312024091010 1.pdf"}},{"id":31657,"object_type":105,"object_id":3547,"attachment_id":23608,"attachment":{"id":23608,"key":23608,"name":"5d46879e-08b6-3d6f-b093-c89883f8ea45","extension":"pdf","path":"\/v2\/attachment\/preview\/wXfR6UQn7fW_MTEa9o-7H8Ixg0fJU0Zm\/5d46879e-08b6-3d6f-b093-c89883f8ea45\/\u4e2d\u90fd\u7269\u6d41.pdf","orig_name":"\u4e2d\u90fd\u7269\u6d41.pdf"}}],"receiptScans":[{"id":28836,"object_type":106,"object_id":3547,"attachment_id":21603,"attachment":{"id":21603,"key":21603,"name":"207c6494-1b11-3577-aa1f-7aefbc13848b","extension":"jpeg","path":"\/v2\/attachment\/preview\/wXfR6UQn7fW_MTEa9o-7H8Ixg0fJU0Zm\/207c6494-1b11-3577-aa1f-7aefbc13848b\/WechatIMG280.jpeg","orig_name":"WechatIMG280.jpeg"}}],"verifyScans":[],"unreadComments":null,"collected_plan":7600,"projectProductTotalAmount":7600,"projectProductAllAmount":true,"projectProductTotalCost":1600,"projectProductAllCost":true,"projectProductTotalCount":2,"invoiced":"7600.00","un_invoiced":0,"collected":"7600","un_collected":0,"is_collected":true,"handlerPerson":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0","avatar":{"id":10,"user_id":1004,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1004.jpg"}},"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,"can_view_product_cost":true,"erp_all_un_settle_amount":0,"verifyList":[]},{"id":3385,"client_id":48,"signed_at":"2024-07-08","amount":"23951","handler":1004,"description":"","created_by":1004,"created_at":"2024-07-04 11:03:26","updated_at":"2024-08-02 16:48:35","contract_scan":null,"receipt_scan":null,"contract_type":1,"project_id":3582,"valid_date":null,"expire_date":"2024-07-07","sla":"","remind_ahead":"","expire_remind_ahead":"30 days","expire_reminded":true,"serial_no":"TS-YJC-2024062602","payment_collection_remind_ahead":"1 day","from_project":3582,"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-07-05 15:00:32","is_verify":false,"is_draft":false,"erp_settle_amount":"23951","erp_un_settle_amount":"0","erp_payment_ticket_is_verify":false,"erp_collect_ticket_is_verify":false,"erp_cash_cost_ticket_is_verify":false,"erp_all_settle_amount":"23951","receipt_scan_uploaded":false,"verify_scan_uploaded":false,"contract_scan_uploaded":true,"is_edit_verify":false,"is_chargeback_verify":false,"b_date":736,"passed":2,"client":{"id":48,"key":48,"name":"\u4e2d\u90fd\u6570\u79d1\u4f9b\u5e94\u94fe\u7ba1\u7406\u6709\u9650\u516c\u53f8","logo":null,"sales_rep":1004,"salesRep":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0","avatar":{"id":10,"user_id":1004,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1004.jpg"}}},"contractScan":null,"receiptScan":null,"createdBy":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0","sex":"M","department_id":1,"avatar":{"id":10,"user_id":1004,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1004.jpg"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"commentCount":{"object_id":3385,"comment":7},"project":{"id":3582,"key":3582,"name":"2024\u6df1\u4fe1\u670d\u4ea7\u54c1\u7eed\u4fdd","erpSalesOrder":{"id":1282,"serial_no":"XSDD-20240704-00001","from_date":null,"wrote_date":"2024-07-08","handler":1004,"client_id":48,"purchase_contract_id":null,"project_id":3582,"sales_contract_id":3385,"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-07-15 10:23:01","stop_at":null,"cancel_at":null,"refuse_description":null,"is_resubmitted":false,"is_done":true,"number":"5","amount":"23951","created_by":1004,"stop_description":null,"extra":null,"outbound_status":false,"is_used":false,"is_cancel":false,"is_settle":true,"is_old":true,"created_at":"2024-07-04 11:03:26","updated_at":"2024-07-15 10:23:01","print_times":null,"erpSalesOrderVerifyRels":[],"erpSalesOrderStopVerifyRels":[]}},"erpSalesOrder":{"id":1282,"serial_no":"XSDD-20240704-00001","from_date":null,"wrote_date":"2024-07-08","handler":1004,"client_id":48,"purchase_contract_id":null,"project_id":3582,"sales_contract_id":3385,"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-07-15 10:23:01","stop_at":null,"cancel_at":null,"refuse_description":null,"is_resubmitted":false,"is_done":true,"number":"5","amount":"23951","created_by":1004,"stop_description":null,"extra":null,"outbound_status":false,"is_used":false,"is_cancel":false,"is_settle":true,"is_old":true,"created_at":"2024-07-04 11:03:26","updated_at":"2024-07-15 10:23:01","print_times":null,"erpSalesOrderVerifyRels":[],"erpSalesOrderStopVerifyRels":[],"erpSalesOrderCancelVerifyRels":[]},"fromProject":{"id":3582,"key":3582,"name":"2024\u6df1\u4fe1\u670d\u4ea7\u54c1\u7eed\u4fdd","description":"","total_contact_point":null,"paid_contact_point":null,"is_sales_order_ready":true,"project_product_version_id":472,"bargain_date":"2024-07-08","collected":"23951","profit_pct":"31.43","budget":"23951","erpSalesOrder":{"id":1282,"serial_no":"XSDD-20240704-00001","from_date":null,"wrote_date":"2024-07-08","handler":1004,"client_id":48,"purchase_contract_id":null,"project_id":3582,"sales_contract_id":3385,"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-07-15 10:23:01","stop_at":null,"cancel_at":null,"refuse_description":null,"is_resubmitted":false,"is_done":true,"number":"5","amount":"23951","created_by":1004,"stop_description":null,"extra":null,"outbound_status":false,"is_used":false,"is_cancel":false,"is_settle":true,"is_old":true,"created_at":"2024-07-04 11:03:26","updated_at":"2024-07-15 10:23:01","print_times":null},"projectProductTypes":[{"id":4982,"product_type_id":87,"key":87,"name":"\u5b89\u5168","budget":"23951","pct":"31.43","project_id":3582,"profit":"7527.7993"}],"projectProductRels":[{"id":5744,"project_id":3582,"product_id":1663,"amount":"3960","number":1,"cost":"2714","description":"","supplier_id":236,"hardware_from":null,"software_from":"2024-07-25","maintenance_from":null,"hardware_to":null,"software_to":"2025-07-24","maintenance_to":null,"total_amount":"3960","total_cost":"2714","erp_sales_order_product_id":989,"supplier":{"id":236,"key":236,"name":"\u5317\u4eac\u5929\u4fe1\u5b8f\u8fbe\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8"},"product":{"id":1663,"name":"URL&\u5e94\u7528\u8bc6\u522b\u89c4\u5219\u5e93\u5347\u7ea7\uff08\u9002\u7528\u4e8eAC-1000-B1250\uff09","product_type":22,"product_component":208,"product_brand":12,"product_serie":1414,"product_misc":null,"product_qa":null,"pn":"","description":"","created_by":1013,"created_at":"2024-07-04 15:30:00","updated_at":"2024-07-04 15:30:00","pinyin_shortcut":"URLampyysbgzksjsyyAC1000B1250","product_unit":2,"is_renew":true,"in_out_at":null,"productType":{"id":22,"key":22,"name":"\u670d\u52a1"},"productComponent":{"id":208,"key":208,"name":"\u4ea7\u54c1\u5347\u7ea7"},"productBrand":{"id":12,"key":12,"name":"\u6df1\u4fe1\u670d"},"productSerie":{"id":1414,"key":1414,"name":"URL&\u5e94\u7528\u8bc6\u522b\u89c4\u5219\u5e93\u5347\u7ea7\uff08\u9002\u7528\u4e8eAC-1000-B1250\uff09"},"productUnit":{"id":2,"key":2,"name":"\u5957"}},"erpSalesOrderProduct":{"id":989,"erp_sales_order_id":1282,"erp_store_id":null,"product_id":1663,"description":"","number":"1","outbound":"0","amount":"3960","total_amount":"3960","last_number":null,"last_amount":null,"last_total_amount":null,"cost":"2714","total_cost":"2714","supplier_id":236,"hardware_from":null,"software_from":"2024-07-25","maintenance_from":null,"hardware_to":null,"software_to":"2025-07-24","maintenance_to":null}},{"id":5745,"project_id":3582,"product_id":1664,"amount":"3111","number":1,"cost":"2171","description":"","supplier_id":236,"hardware_from":"2024-07-25","software_from":null,"maintenance_from":null,"hardware_to":"2025-07-24","software_to":null,"maintenance_to":null,"total_amount":"3111","total_cost":"2171","erp_sales_order_product_id":990,"supplier":{"id":236,"key":236,"name":"\u5317\u4eac\u5929\u4fe1\u5b8f\u8fbe\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8"},"product":{"id":1664,"name":"\u6df1\u4fe1\u670d\u4ea7\u54c1\u8d28\u4fdd+\u8f6f\u4ef6\u5347\u7ea7\u670d\u52a1\uff08\u9002\u7528\u4e8eAC-1000-B1250\uff09","product_type":22,"product_component":189,"product_brand":12,"product_serie":1415,"product_misc":null,"product_qa":null,"pn":"","description":"","created_by":1013,"created_at":"2024-07-04 15:31:49","updated_at":"2024-07-04 15:31:49","pinyin_shortcut":"sxfcpzbrjsjfwsyyAC1000B1250","product_unit":2,"is_renew":true,"in_out_at":null,"productType":{"id":22,"key":22,"name":"\u670d\u52a1"},"productComponent":{"id":189,"key":189,"name":"\u8f6f\u4ef6\u5347\u7ea7\u786c\u4ef6\u8d28\u4fdd"},"productBrand":{"id":12,"key":12,"name":"\u6df1\u4fe1\u670d"},"productSerie":{"id":1415,"key":1415,"name":"\u6df1\u4fe1\u670d\u4ea7\u54c1\u8d28\u4fdd+\u8f6f\u4ef6\u5347\u7ea7\u670d\u52a1\uff08\u9002\u7528\u4e8eAC-1000-B1250\uff09"},"productUnit":{"id":2,"key":2,"name":"\u5957"}},"erpSalesOrderProduct":{"id":990,"erp_sales_order_id":1282,"erp_store_id":null,"product_id":1664,"description":"","number":"1","outbound":"0","amount":"3111","total_amount":"3111","last_number":null,"last_amount":null,"last_total_amount":null,"cost":"2171","total_cost":"2171","supplier_id":236,"hardware_from":"2024-07-25","software_from":null,"maintenance_from":null,"hardware_to":"2025-07-24","software_to":null,"maintenance_to":null}},{"id":5746,"project_id":3582,"product_id":1665,"amount":"4540","number":2,"cost":"2931","description":"","supplier_id":236,"hardware_from":"2024-07-25","software_from":null,"maintenance_from":null,"hardware_to":"2025-07-24","software_to":null,"maintenance_to":null,"total_amount":"9080","total_cost":"5862","erp_sales_order_product_id":991,"supplier":{"id":236,"key":236,"name":"\u5317\u4eac\u5929\u4fe1\u5b8f\u8fbe\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8"},"product":{"id":1665,"name":"\u6df1\u4fe1\u670d\u4ea7\u54c1\u8d28\u4fdd+\u8f6f\u4ef6\u5347\u7ea7\u670d\u52a1\uff08\u9002\u7528\u4e8eVPN-1000-B1100\uff09","product_type":22,"product_component":200,"product_brand":12,"product_serie":1416,"product_misc":null,"product_qa":null,"pn":"","description":"","created_by":1013,"created_at":"2024-07-04 15:34:24","updated_at":"2024-07-04 15:34:24","pinyin_shortcut":"sxfcpzbrjsjfwsyyVPN1000B1100","product_unit":2,"is_renew":true,"in_out_at":null,"productType":{"id":22,"key":22,"name":"\u670d\u52a1"},"productComponent":{"id":200,"key":200,"name":"\u7eed\u4fdd\u670d\u52a1"},"productBrand":{"id":12,"key":12,"name":"\u6df1\u4fe1\u670d"},"productSerie":{"id":1416,"key":1416,"name":"\u6df1\u4fe1\u670d\u4ea7\u54c1\u8d28\u4fdd+\u8f6f\u4ef6\u5347\u7ea7 \u9002\u7528\u4e8e\uff08VPN-1000-B1100\uff09"},"productUnit":{"id":2,"key":2,"name":"\u5957"}},"erpSalesOrderProduct":{"id":991,"erp_sales_order_id":1282,"erp_store_id":null,"product_id":1665,"description":"","number":"2","outbound":"0","amount":"4540","total_amount":"9080","last_number":null,"last_amount":null,"last_total_amount":null,"cost":"2931","total_cost":"5862","supplier_id":236,"hardware_from":"2024-07-25","software_from":null,"maintenance_from":null,"hardware_to":"2025-07-24","software_to":null,"maintenance_to":null}},{"id":5747,"project_id":3582,"product_id":922,"amount":"7800","number":1,"cost":"4000","description":"","supplier_id":236,"hardware_from":null,"software_from":"2024-07-25","maintenance_from":null,"hardware_to":null,"software_to":"2025-07-24","maintenance_to":null,"total_amount":"7800","total_cost":"4000","erp_sales_order_product_id":992,"supplier":{"id":236,"key":236,"name":"\u5317\u4eac\u5929\u4fe1\u5b8f\u8fbe\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8"},"product":{"id":922,"name":"\u6df1\u4fe1\u670d\u7ec8\u7aef\u68c0\u6d4b\u54cd\u5e94\u5e73\u53f0EDR\u7eed\u4fdd\u670d\u52a1","product_type":22,"product_component":200,"product_brand":12,"product_serie":1024,"product_misc":null,"product_qa":null,"pn":"","description":"","created_by":1013,"created_at":"2023-05-08 12:11:04","updated_at":"2026-01-28 10:32:39","pinyin_shortcut":"sxfzdjcxyptEDRxbfw","product_unit":2,"is_renew":false,"in_out_at":"2026-01-28 10:32:39.333577+08","productType":{"id":22,"key":22,"name":"\u670d\u52a1"},"productComponent":{"id":200,"key":200,"name":"\u7eed\u4fdd\u670d\u52a1"},"productBrand":{"id":12,"key":12,"name":"\u6df1\u4fe1\u670d"},"productSerie":{"id":1024,"key":1024,"name":"\u6df1\u4fe1\u670d\u7ec8\u7aef\u68c0\u6d4b\u54cd\u5e94\u5e73\u53f0EDR\u7eed\u4fdd\u670d\u52a1"},"productUnit":{"id":2,"key":2,"name":"\u5957"}},"erpSalesOrderProduct":{"id":992,"erp_sales_order_id":1282,"erp_store_id":null,"product_id":922,"description":"","number":"1","outbound":"0","amount":"7800","total_amount":"7800","last_number":null,"last_amount":null,"last_total_amount":null,"cost":"4000","total_cost":"4000","supplier_id":236,"hardware_from":null,"software_from":"2024-07-25","maintenance_from":null,"hardware_to":null,"software_to":"2025-07-24","maintenance_to":null}}],"projectContactPoints":[],"buildSalesOrderItems":[{"id":9479,"project_id":3582},{"id":9478,"project_id":3582},{"id":9476,"project_id":3582},{"id":9475,"project_id":3582},{"id":9477,"project_id":3582}],"reimbursementAmountSum":null,"profit":7527.7993,"contact_points_status_display":"\u672a\u8bbe\u7f6e","total_contact_paid_point":0,"total_contact_un_paid_point":0},"salesSupplierRels":[{"id":1607,"contract_id":3385,"supplier_id":236,"purchase_id":3411,"supplier":{"id":236,"key":236,"name":"\u5317\u4eac\u5929\u4fe1\u5b8f\u8fbe\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8"},"purchase":{"id":3411,"key":3411,"serial_no":"TSKJ20240715-HYF-002"}}],"contractType":{"id":1,"key":1,"name":"\u4ea7\u54c1\u9500\u552e"},"handleBy":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0","sex":"M","department_id":1,"avatar":{"id":10,"user_id":1004,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1004.jpg"}},"remindDate":null,"serviceContractRemindDates":[],"salesContractRemindReceivers":[{"id":8119,"user_id":1004,"key":1004,"contract_id":3385,"user":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0","sex":"M","avatar":{"id":10,"user_id":1004,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1004.jpg"}}},{"id":8120,"user_id":1011,"key":1011,"contract_id":3385,"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"}}}],"serviceContractRemindReceivers":[],"salesContractPaymentCollectionRemindReceivers":[{"id":6084,"user_id":1004,"key":1004,"contract_id":3385,"user":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0","sex":"M","avatar":{"id":10,"user_id":1004,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1004.jpg"}}}],"salesContractPaymentCollectionRemindDates":[{"id":1820,"key":1820,"contract_id":3385,"name":"2024-07-26","value":"23951","overdue_days":null,"status":1,"remind_date":"2024-07-26","pct":100,"overdue_display":""}],"salesContractPayments":[{"id":"135","key":"135","contract_id":3385,"value":"23951","created_by":1013,"created_at":"2024-07-15 10:23:01","description":null,"collected_date":"2024-07-15 00:00:00","amount":"23951","createdBy":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","department_id":7},"pct":100}],"salesContractInvoices":[{"id":1706,"key":1706,"contract_id":3385,"value":"23951.00","attachment_id":null,"from_date":"2024-07-04","description":"","is_draft":true,"is_cancel":false,"salesInvoiceAmounts":[{"id":2697,"sales_invoice_id":1706,"amount":"23951.00","tax_rate":"13"}],"attachment":null,"attachmentRelationships":[],"files":[{"id":26825,"object_type":102,"object_id":1706,"attachment_id":20064,"attachment":{"id":20064,"key":20064,"name":"aad5cf6f-2941-3514-9842-78beae1d7e2b","extension":"pdf","path":"\/v2\/attachment\/view\/wXfR6UQn7fW_MTEa9o-7H8Ixg0fJU0Zm\/aad5cf6f-2941-3514-9842-78beae1d7e2b\/dzfp_24112000000075571558_\u4e2d\u90fd\u7269\u6d41\u6709\u9650\u516c\u53f8_20240703152133.pdf","orig_name":"dzfp_24112000000075571558_\u4e2d\u90fd\u7269\u6d41\u6709\u9650\u516c\u53f8_20240703152133.pdf"}}]}],"contractScans":[{"id":27553,"object_type":105,"object_id":3385,"attachment_id":20172,"attachment":{"id":20172,"key":20172,"name":"f065893f-bf54-3e13-8e09-3d7804b14607","extension":"pdf","path":"\/v2\/attachment\/preview\/wXfR6UQn7fW_MTEa9o-7H8Ixg0fJU0Zm\/f065893f-bf54-3e13-8e09-3d7804b14607\/2024_07_09_16_20_31.pdf","orig_name":"2024_07_09_16_20_31.pdf"}}],"receiptScans":[],"verifyScans":[],"unreadComments":null,"collected_plan":23951,"projectProductTotalAmount":23951,"projectProductAllAmount":true,"projectProductTotalCost":14747,"projectProductAllCost":true,"projectProductTotalCount":5,"invoiced":"23951.00","un_invoiced":0,"collected":"23951","un_collected":0,"is_collected":true,"handlerPerson":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0","avatar":{"id":10,"user_id":1004,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1004.jpg"}},"remind_date":"","remind_ahead_display":"\u65e0","expire_remind_ahead_display":"\u63d0\u524d30\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,"can_view_product_cost":true,"erp_all_un_settle_amount":0,"verifyList":[]},{"id":3395,"client_id":48,"signed_at":"2024-06-26","amount":"110000","handler":1004,"description":"","created_by":1004,"created_at":"2024-07-09 16:20:09","updated_at":"2024-08-02 16:49:32","contract_scan":null,"receipt_scan":null,"contract_type":1,"project_id":3581,"valid_date":null,"expire_date":"2024-06-25","sla":"","remind_ahead":"","expire_remind_ahead":"30 days","expire_reminded":true,"serial_no":"TS-YJC-2024062601","payment_collection_remind_ahead":"","from_project":3581,"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":false,"save_collection_at":"","is_verify":false,"is_draft":false,"erp_settle_amount":"110000","erp_un_settle_amount":"0","erp_payment_ticket_is_verify":false,"erp_collect_ticket_is_verify":false,"erp_cash_cost_ticket_is_verify":false,"erp_all_settle_amount":"110000","receipt_scan_uploaded":false,"verify_scan_uploaded":false,"contract_scan_uploaded":true,"is_edit_verify":false,"is_chargeback_verify":false,"b_date":748,"passed":2,"client":{"id":48,"key":48,"name":"\u4e2d\u90fd\u6570\u79d1\u4f9b\u5e94\u94fe\u7ba1\u7406\u6709\u9650\u516c\u53f8","logo":null,"sales_rep":1004,"salesRep":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0","avatar":{"id":10,"user_id":1004,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1004.jpg"}}},"contractScan":null,"receiptScan":null,"createdBy":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0","sex":"M","department_id":1,"avatar":{"id":10,"user_id":1004,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1004.jpg"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"commentCount":{"object_id":3395,"comment":6},"project":{"id":3581,"key":3581,"name":"2024PA\u4ea7\u54c1\u7eed\u4fdd","erpSalesOrder":{"id":1286,"serial_no":"XSDD-20240709-00002","from_date":null,"wrote_date":"2024-06-26","handler":1004,"client_id":48,"purchase_contract_id":null,"project_id":3581,"sales_contract_id":3395,"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-07-19 14:33:20","stop_at":null,"cancel_at":null,"refuse_description":null,"is_resubmitted":false,"is_done":true,"number":"6","amount":"110000","created_by":1004,"stop_description":null,"extra":null,"outbound_status":false,"is_used":false,"is_cancel":false,"is_settle":true,"is_old":true,"created_at":"2024-07-09 16:20:09","updated_at":"2024-07-19 14:33:20","print_times":null,"erpSalesOrderVerifyRels":[],"erpSalesOrderStopVerifyRels":[]}},"erpSalesOrder":{"id":1286,"serial_no":"XSDD-20240709-00002","from_date":null,"wrote_date":"2024-06-26","handler":1004,"client_id":48,"purchase_contract_id":null,"project_id":3581,"sales_contract_id":3395,"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-07-19 14:33:20","stop_at":null,"cancel_at":null,"refuse_description":null,"is_resubmitted":false,"is_done":true,"number":"6","amount":"110000","created_by":1004,"stop_description":null,"extra":null,"outbound_status":false,"is_used":false,"is_cancel":false,"is_settle":true,"is_old":true,"created_at":"2024-07-09 16:20:09","updated_at":"2024-07-19 14:33:20","print_times":null,"erpSalesOrderVerifyRels":[],"erpSalesOrderStopVerifyRels":[],"erpSalesOrderCancelVerifyRels":[]},"fromProject":{"id":3581,"key":3581,"name":"2024PA\u4ea7\u54c1\u7eed\u4fdd","description":"","total_contact_point":null,"paid_contact_point":null,"is_sales_order_ready":true,"project_product_version_id":491,"bargain_date":"2024-06-26","collected":"110000","profit_pct":"23.54","budget":"110000","erpSalesOrder":{"id":1286,"serial_no":"XSDD-20240709-00002","from_date":null,"wrote_date":"2024-06-26","handler":1004,"client_id":48,"purchase_contract_id":null,"project_id":3581,"sales_contract_id":3395,"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-07-19 14:33:20","stop_at":null,"cancel_at":null,"refuse_description":null,"is_resubmitted":false,"is_done":true,"number":"6","amount":"110000","created_by":1004,"stop_description":null,"extra":null,"outbound_status":false,"is_used":false,"is_cancel":false,"is_settle":true,"is_old":true,"created_at":"2024-07-09 16:20:09","updated_at":"2024-07-19 14:33:20","print_times":null},"projectProductTypes":[{"id":4983,"product_type_id":87,"key":87,"name":"\u5b89\u5168","budget":"110000","pct":"23.54","project_id":3581,"profit":"25894"}],"projectProductRels":[{"id":5748,"project_id":3581,"product_id":1354,"amount":"20000","number":2,"cost":"11555.2","description":"","supplier_id":90,"hardware_from":null,"software_from":"2024-08-01","maintenance_from":null,"hardware_to":null,"software_to":"2025-07-31","maintenance_to":null,"total_amount":"40000","total_cost":"23110.4","erp_sales_order_product_id":998,"supplier":{"id":90,"key":90,"name":"\u7d2b\u5149\u6653\u901a\u79d1\u6280\u6709\u9650\u516c\u53f8"},"product":{"id":1354,"name":"PAN-PA-850-TP-HA2-R","product_type":5,"product_component":36,"product_brand":8,"product_serie":1026,"product_misc":null,"product_qa":null,"pn":"","description":"Threat prevention subscription for device in an HA pair year 1, PA-850\n","created_by":1013,"created_at":"2024-01-26 13:48:15","updated_at":"2024-01-26 13:52:20","pinyin_shortcut":"PANPA850TPHA2R","product_unit":2,"is_renew":false,"in_out_at":null,"productType":{"id":5,"key":5,"name":"\u5b89\u5168\u8bbe\u5907"},"productComponent":{"id":36,"key":36,"name":"PA\u8bb8\u53ef\u8bc1"},"productBrand":{"id":8,"key":8,"name":"PaloAlto"},"productSerie":{"id":1026,"key":1026,"name":"PA850\u8f6f\u4ef6\u6388\u6743"},"productUnit":{"id":2,"key":2,"name":"\u5957"}},"erpSalesOrderProduct":{"id":998,"erp_sales_order_id":1286,"erp_store_id":null,"product_id":1354,"description":"","number":"2","outbound":"0","amount":"20000","total_amount":"40000","last_number":null,"last_amount":null,"last_total_amount":null,"cost":"11555.2","total_cost":"23110.4","supplier_id":90,"hardware_from":null,"software_from":"2024-08-01","maintenance_from":null,"hardware_to":null,"software_to":"2025-07-31","maintenance_to":null}},{"id":5749,"project_id":3581,"product_id":1669,"amount":"20000","number":2,"cost":"17333","description":"","supplier_id":90,"hardware_from":null,"software_from":"2024-08-01","maintenance_from":null,"hardware_to":null,"software_to":"2025-07-31","maintenance_to":null,"total_amount":"40000","total_cost":"34666","erp_sales_order_product_id":999,"supplier":{"id":90,"key":90,"name":"\u7d2b\u5149\u6653\u901a\u79d1\u6280\u6709\u9650\u516c\u53f8"},"product":{"id":1669,"name":"PAN-PA-850-AWF-HA2-R","product_type":5,"product_component":36,"product_brand":8,"product_serie":1026,"product_misc":null,"product_qa":null,"pn":"","description":"Advanced WildFire subscription renewal for device in HA pair, PA-850 ","created_by":1013,"created_at":"2024-07-09 16:50:47","updated_at":"2024-07-09 16:50:47","pinyin_shortcut":"PANPA850AWFHA2R","product_unit":2,"is_renew":true,"in_out_at":null,"productType":{"id":5,"key":5,"name":"\u5b89\u5168\u8bbe\u5907"},"productComponent":{"id":36,"key":36,"name":"PA\u8bb8\u53ef\u8bc1"},"productBrand":{"id":8,"key":8,"name":"PaloAlto"},"productSerie":{"id":1026,"key":1026,"name":"PA850\u8f6f\u4ef6\u6388\u6743"},"productUnit":{"id":2,"key":2,"name":"\u5957"}},"erpSalesOrderProduct":{"id":999,"erp_sales_order_id":1286,"erp_store_id":null,"product_id":1669,"description":"","number":"2","outbound":"0","amount":"20000","total_amount":"40000","last_number":null,"last_amount":null,"last_total_amount":null,"cost":"17333","total_cost":"34666","supplier_id":90,"hardware_from":null,"software_from":"2024-08-01","maintenance_from":null,"hardware_to":null,"software_to":"2025-07-31","maintenance_to":null}},{"id":5750,"project_id":3581,"product_id":1670,"amount":"15000","number":2,"cost":"9965","description":"","supplier_id":90,"hardware_from":"2024-08-01","software_from":null,"maintenance_from":null,"hardware_to":"2025-07-31","software_to":null,"maintenance_to":null,"total_amount":"30000","total_cost":"19930","erp_sales_order_product_id":1000,"supplier":{"id":90,"key":90,"name":"\u7d2b\u5149\u6653\u901a\u79d1\u6280\u6709\u9650\u516c\u53f8"},"product":{"id":1670,"name":"PAN-SVC-BKLN-850-R","product_type":5,"product_component":35,"product_brand":8,"product_serie":210,"product_misc":null,"product_qa":null,"pn":"","description":"Partner enabled premium support renewal, PA-850 ","created_by":1013,"created_at":"2024-07-09 16:51:27","updated_at":"2024-07-09 16:51:27","pinyin_shortcut":"PANSVCBKLN850R","product_unit":2,"is_renew":true,"in_out_at":null,"productType":{"id":5,"key":5,"name":"\u5b89\u5168\u8bbe\u5907"},"productComponent":{"id":35,"key":35,"name":"\u9632\u706b\u5899\u8f6f\u4ef6"},"productBrand":{"id":8,"key":8,"name":"PaloAlto"},"productSerie":{"id":210,"key":210,"name":"PA850\u4e00\u5e74\u670d\u52a1"},"productUnit":{"id":2,"key":2,"name":"\u5957"}},"erpSalesOrderProduct":{"id":1000,"erp_sales_order_id":1286,"erp_store_id":null,"product_id":1670,"description":"","number":"2","outbound":"0","amount":"15000","total_amount":"30000","last_number":null,"last_amount":null,"last_total_amount":null,"cost":"9965","total_cost":"19930","supplier_id":90,"hardware_from":"2024-08-01","software_from":null,"maintenance_from":null,"hardware_to":"2025-07-31","software_to":null,"maintenance_to":null}}],"projectContactPoints":[],"buildSalesOrderItems":[{"id":11238,"project_id":3581},{"id":11235,"project_id":3581},{"id":11233,"project_id":3581},{"id":11234,"project_id":3581},{"id":11236,"project_id":3581},{"id":11237,"project_id":3581}],"reimbursementAmountSum":null,"profit":25894,"contact_points_status_display":"\u672a\u8bbe\u7f6e","total_contact_paid_point":0,"total_contact_un_paid_point":0},"salesSupplierRels":[{"id":1608,"contract_id":3395,"supplier_id":90,"purchase_id":3424,"supplier":{"id":90,"key":90,"name":"\u7d2b\u5149\u6653\u901a\u79d1\u6280\u6709\u9650\u516c\u53f8"},"purchase":{"id":3424,"key":3424,"serial_no":"X_2024SBQ18387"}}],"contractType":{"id":1,"key":1,"name":"\u4ea7\u54c1\u9500\u552e"},"handleBy":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0","sex":"M","department_id":1,"avatar":{"id":10,"user_id":1004,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1004.jpg"}},"remindDate":null,"serviceContractRemindDates":[],"salesContractRemindReceivers":[{"id":8121,"user_id":1004,"key":1004,"contract_id":3395,"user":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0","sex":"M","avatar":{"id":10,"user_id":1004,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1004.jpg"}}},{"id":8122,"user_id":1011,"key":1011,"contract_id":3395,"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"}}}],"serviceContractRemindReceivers":[],"salesContractPaymentCollectionRemindReceivers":[{"id":6085,"user_id":1004,"key":1004,"contract_id":3395,"user":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0","sex":"M","avatar":{"id":10,"user_id":1004,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1004.jpg"}}}],"salesContractPaymentCollectionRemindDates":[{"id":1825,"key":1825,"contract_id":3395,"name":"2024-08-20","value":"110000","overdue_days":null,"status":1,"remind_date":"2024-08-20","pct":100,"overdue_display":""}],"salesContractPayments":[{"id":"153","key":"153","contract_id":3395,"value":"110000","created_by":1013,"created_at":"2024-07-19 14:33:20","description":null,"collected_date":"2024-07-19 00:00:00","amount":"110000","createdBy":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","department_id":7},"pct":100}],"salesContractInvoices":[{"id":1710,"key":1710,"contract_id":3395,"value":"110000.00","attachment_id":null,"from_date":"2024-07-09","description":"","is_draft":true,"is_cancel":false,"salesInvoiceAmounts":[{"id":1274,"sales_invoice_id":1710,"amount":"110000.00","tax_rate":"13"}],"attachment":null,"attachmentRelationships":[],"files":[{"id":26963,"object_type":102,"object_id":1710,"attachment_id":20176,"attachment":{"id":20176,"key":20176,"name":"5a9f167e-44ca-368e-b3d7-3517df254cdf","extension":"pdf","path":"\/v2\/attachment\/view\/wXfR6UQn7fW_MTEa9o-7H8Ixg0fJU0Zm\/5a9f167e-44ca-368e-b3d7-3517df254cdf\/dzfp_24112000000079955787_\u4e2d\u90fd\u7269\u6d41\u6709\u9650\u516c\u53f8_20240709172034.pdf","orig_name":"dzfp_24112000000079955787_\u4e2d\u90fd\u7269\u6d41\u6709\u9650\u516c\u53f8_20240709172034.pdf"}}]}],"contractScans":[{"id":27554,"object_type":105,"object_id":3395,"attachment_id":20173,"attachment":{"id":20173,"key":20173,"name":"2699cca0-8676-3196-94b5-e7c1a01d059f","extension":"pdf","path":"\/v2\/attachment\/preview\/wXfR6UQn7fW_MTEa9o-7H8Ixg0fJU0Zm\/2699cca0-8676-3196-94b5-e7c1a01d059f\/2024_07_09_16_19_42.pdf","orig_name":"2024_07_09_16_19_42.pdf"}}],"receiptScans":[],"verifyScans":[],"unreadComments":null,"collected_plan":110000,"projectProductTotalAmount":110000,"projectProductAllAmount":true,"projectProductTotalCost":77706.4,"projectProductAllCost":true,"projectProductTotalCount":6,"invoiced":"110000.00","un_invoiced":0,"collected":"110000","un_collected":0,"is_collected":true,"handlerPerson":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0","avatar":{"id":10,"user_id":1004,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1004.jpg"}},"remind_date":"","remind_ahead_display":"\u65e0","expire_remind_ahead_display":"\u63d0\u524d30\u5929","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,"can_view_product_cost":true,"erp_all_un_settle_amount":0,"verifyList":[]},{"id":3366,"client_id":48,"signed_at":"2024-06-25","amount":"47204.1","handler":1004,"description":"","created_by":1004,"created_at":"2024-06-26 15:25:34","updated_at":"2024-12-27 11:20:14","contract_scan":null,"receipt_scan":null,"contract_type":2,"project_id":3556,"valid_date":null,"expire_date":"2025-07-13","sla":"","remind_ahead":"7 days","expire_remind_ahead":"30 days","expire_reminded":true,"serial_no":"TS-YJC-2024061301","payment_collection_remind_ahead":"7 days","from_project":3556,"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-25 10:49:29","is_verify":false,"is_draft":false,"erp_settle_amount":"47204.1","erp_un_settle_amount":"0","erp_payment_ticket_is_verify":false,"erp_collect_ticket_is_verify":false,"erp_cash_cost_ticket_is_verify":false,"erp_all_settle_amount":"47204.1","receipt_scan_uploaded":false,"verify_scan_uploaded":false,"contract_scan_uploaded":true,"is_edit_verify":false,"is_chargeback_verify":false,"b_date":365,"passed":2,"client":{"id":48,"key":48,"name":"\u4e2d\u90fd\u6570\u79d1\u4f9b\u5e94\u94fe\u7ba1\u7406\u6709\u9650\u516c\u53f8","logo":null,"sales_rep":1004,"salesRep":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0","avatar":{"id":10,"user_id":1004,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1004.jpg"}}},"contractScan":null,"receiptScan":null,"createdBy":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0","sex":"M","department_id":1,"avatar":{"id":10,"user_id":1004,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1004.jpg"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"commentCount":{"object_id":3366,"comment":11},"project":{"id":3556,"key":3556,"name":"2024\u5e74\u670d\u52a1\u5668\u53ca\u5b58\u50a8\u8fd0\u7ef4\u670d\u52a1","erpSalesOrder":{"id":1272,"serial_no":"XSDD-20240626-00003","from_date":null,"wrote_date":"2024-06-25","handler":1004,"client_id":48,"purchase_contract_id":null,"project_id":3556,"sales_contract_id":3366,"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-07-19 15:53:28","stop_at":null,"cancel_at":null,"refuse_description":null,"is_resubmitted":false,"is_done":true,"number":"6","amount":"47204.1","created_by":1004,"stop_description":null,"extra":null,"outbound_status":false,"is_used":false,"is_cancel":false,"is_settle":true,"is_old":true,"created_at":"2024-06-26 15:25:34","updated_at":"2024-07-19 15:53:28","print_times":null,"erpSalesOrderVerifyRels":[],"erpSalesOrderStopVerifyRels":[]}},"erpSalesOrder":{"id":1272,"serial_no":"XSDD-20240626-00003","from_date":null,"wrote_date":"2024-06-25","handler":1004,"client_id":48,"purchase_contract_id":null,"project_id":3556,"sales_contract_id":3366,"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-07-19 15:53:28","stop_at":null,"cancel_at":null,"refuse_description":null,"is_resubmitted":false,"is_done":true,"number":"6","amount":"47204.1","created_by":1004,"stop_description":null,"extra":null,"outbound_status":false,"is_used":false,"is_cancel":false,"is_settle":true,"is_old":true,"created_at":"2024-06-26 15:25:34","updated_at":"2024-07-19 15:53:28","print_times":null,"erpSalesOrderVerifyRels":[],"erpSalesOrderStopVerifyRels":[],"erpSalesOrderCancelVerifyRels":[]},"fromProject":{"id":3556,"key":3556,"name":"2024\u5e74\u670d\u52a1\u5668\u53ca\u5b58\u50a8\u8fd0\u7ef4\u670d\u52a1","description":"","total_contact_point":null,"paid_contact_point":null,"is_sales_order_ready":true,"project_product_version_id":458,"bargain_date":"2024-06-25","collected":"47204.1","profit_pct":"74.42","budget":"47204.1","erpSalesOrder":{"id":1272,"serial_no":"XSDD-20240626-00003","from_date":null,"wrote_date":"2024-06-25","handler":1004,"client_id":48,"purchase_contract_id":null,"project_id":3556,"sales_contract_id":3366,"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-07-19 15:53:28","stop_at":null,"cancel_at":null,"refuse_description":null,"is_resubmitted":false,"is_done":true,"number":"6","amount":"47204.1","created_by":1004,"stop_description":null,"extra":null,"outbound_status":false,"is_used":false,"is_cancel":false,"is_settle":true,"is_old":true,"created_at":"2024-06-26 15:25:34","updated_at":"2024-07-19 15:53:28","print_times":null},"projectProductTypes":[{"id":5788,"product_type_id":22,"key":22,"name":"\u670d\u52a1","budget":"47204.10","pct":"74.42","project_id":3556,"profit":"35129.29122"}],"projectProductRels":[{"id":8242,"project_id":3556,"product_id":941,"amount":"21157.6","number":1,"cost":"0","description":"","supplier_id":null,"hardware_from":null,"software_from":null,"maintenance_from":"2024-07-14","hardware_to":null,"software_to":null,"maintenance_to":"2025-07-13","total_amount":"21157.6","total_cost":"0","erp_sales_order_product_id":972,"supplier":null,"product":{"id":941,"name":"\u62d3\u5b9e\u4eba\u5de5\u6280\u672f\u670d\u52a1","product_type":19,"product_component":151,"product_brand":133,"product_serie":592,"product_misc":null,"product_qa":null,"pn":"","description":"","created_by":1013,"created_at":"2023-08-03 09:29:24","updated_at":"2026-02-05 16:37:56","pinyin_shortcut":"tsrgjsfw","product_unit":7,"is_renew":false,"in_out_at":"2026-02-05 16:37:56.557723+08","productType":{"id":19,"key":19,"name":"\u6280\u672f\u670d\u52a1"},"productComponent":{"id":151,"key":151,"name":"\u4eba\u5de5\u670d\u52a1"},"productBrand":{"id":133,"key":133,"name":"\u62d3\u5b9e"},"productSerie":{"id":592,"key":592,"name":"\u5b89\u88c5\u8c03\u8bd5\u670d\u52a1"},"productUnit":{"id":7,"key":7,"name":"\u6b21"}},"erpSalesOrderProduct":{"id":972,"erp_sales_order_id":1272,"erp_store_id":null,"product_id":941,"description":"","number":"1","outbound":"0","amount":"21157.6","total_amount":"21157.6","last_number":null,"last_amount":null,"last_total_amount":null,"cost":"0","total_cost":"0","supplier_id":null,"hardware_from":null,"software_from":null,"maintenance_from":"2024-07-14","hardware_to":null,"software_to":null,"maintenance_to":"2025-07-13"}},{"id":8243,"project_id":3556,"product_id":1376,"amount":"5209.3","number":5,"cost":"1500","description":"","supplier_id":116,"hardware_from":"2024-08-08","software_from":null,"maintenance_from":null,"hardware_to":"2025-08-07","software_to":null,"maintenance_to":null,"total_amount":"26046.5","total_cost":"7500","erp_sales_order_product_id":973,"supplier":{"id":116,"key":116,"name":"\u56db\u5ddd\u957f\u8679\u4f73\u534e\u4fe1\u606f\u4ea7\u54c1\u6709\u9650\u8d23\u4efb\u516c\u53f8"},"product":{"id":1376,"name":"CBSOMA11M","product_type":2,"product_component":13,"product_brand":4,"product_serie":1052,"product_misc":null,"product_qa":null,"pn":"","description":"\u8054\u60f3\u539f\u5382\u4e00\u5e745*9\u670d\u52a1","created_by":1001,"created_at":"2024-01-26 17:55:26","updated_at":"2025-10-29 17:37:40","pinyin_shortcut":"CBSOMA11M","product_unit":8,"is_renew":false,"in_out_at":"2025-10-29 17:37:40.337224+08","productType":{"id":2,"key":2,"name":"\u670d\u52a1\u5668"},"productComponent":{"id":13,"key":13,"name":"\u670d\u52a1\u5668\u91d1\u724c\u670d\u52a1"},"productBrand":{"id":4,"key":4,"name":"\u8054\u60f3"},"productSerie":{"id":1052,"key":1052,"name":"SR650\u670d\u52a1\u5668\u4e00\u5e745*9\u539f\u5382\u670d\u52a1"},"productUnit":{"id":8,"key":8,"name":"\u5e74"}},"erpSalesOrderProduct":{"id":973,"erp_sales_order_id":1272,"erp_store_id":null,"product_id":1376,"description":"","number":"5","outbound":"0","amount":"5209.3","total_amount":"26046.5","last_number":null,"last_amount":null,"last_total_amount":null,"cost":"1500","total_cost":"7500","supplier_id":116,"hardware_from":"2024-08-08","software_from":null,"maintenance_from":null,"hardware_to":"2025-08-07","software_to":null,"maintenance_to":null}}],"projectContactPoints":[],"buildSalesOrderItems":[{"id":11239,"project_id":3556},{"id":11240,"project_id":3556},{"id":11241,"project_id":3556},{"id":11242,"project_id":3556},{"id":11243,"project_id":3556},{"id":11244,"project_id":3556}],"reimbursementAmountSum":{"project_id":3556,"sum":"312.77"},"profit":35129.29122,"contact_points_status_display":"\u672a\u8bbe\u7f6e","total_contact_paid_point":0,"total_contact_un_paid_point":0},"salesSupplierRels":[{"id":2269,"contract_id":3366,"supplier_id":116,"purchase_id":3722,"supplier":{"id":116,"key":116,"name":"\u56db\u5ddd\u957f\u8679\u4f73\u534e\u4fe1\u606f\u4ea7\u54c1\u6709\u9650\u8d23\u4efb\u516c\u53f8"},"purchase":{"id":3722,"key":3722,"serial_no":"20241224001"}}],"contractType":{"id":2,"key":2,"name":"\u8fd0\u7ef4\u670d\u52a1"},"handleBy":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0","sex":"M","department_id":1,"avatar":{"id":10,"user_id":1004,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1004.jpg"}},"remindDate":null,"serviceContractRemindDates":[{"id":488,"key":488,"contract_id":3366,"name":"2024-09-27"},{"id":489,"key":489,"contract_id":3366,"name":"2024-12-27"},{"id":490,"key":490,"contract_id":3366,"name":"2025-03-27"},{"id":491,"key":491,"contract_id":3366,"name":"2025-06-26"}],"salesContractRemindReceivers":[{"id":8254,"user_id":1011,"key":1011,"contract_id":3366,"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":8255,"user_id":1004,"key":1004,"contract_id":3366,"user":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0","sex":"M","avatar":{"id":10,"user_id":1004,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1004.jpg"}}}],"serviceContractRemindReceivers":[{"id":466,"contract_id":3366,"user_id":1004,"user":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0","sex":"M","avatar":{"id":10,"user_id":1004,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1004.jpg"}}}],"salesContractPaymentCollectionRemindReceivers":[{"id":7493,"user_id":1004,"key":1004,"contract_id":3366,"user":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0","sex":"M","avatar":{"id":10,"user_id":1004,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1004.jpg"}}},{"id":7495,"user_id":1001,"key":1001,"contract_id":3366,"user":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/\/avatar\/e868e40f-1256-329e-9b1c-74e095049622.png"}}}],"salesContractPaymentCollectionRemindDates":[{"id":2225,"key":2225,"contract_id":3366,"name":"2024-12-26","value":"47204.1","overdue_days":null,"status":1,"remind_date":"2024-12-26","pct":100,"overdue_display":""}],"salesContractPayments":[{"id":"157","key":"157","contract_id":3366,"value":"47204.1","created_by":1013,"created_at":"2024-07-19 15:53:28","description":null,"collected_date":"2024-07-19 00:00:00","amount":"47204.1","createdBy":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","department_id":7},"pct":100}],"salesContractInvoices":[{"id":1698,"key":1698,"contract_id":3366,"value":"47204.10","attachment_id":null,"from_date":"2024-07-01","description":"","is_draft":true,"is_cancel":false,"salesInvoiceAmounts":[{"id":2331,"sales_invoice_id":1698,"amount":"47204.10","tax_rate":"13"}],"attachment":null,"attachmentRelationships":[],"files":[{"id":26768,"object_type":102,"object_id":1698,"attachment_id":20015,"attachment":{"id":20015,"key":20015,"name":"850d4657-d199-3d4b-9250-3d2224930df6","extension":"pdf","path":"\/v2\/attachment\/view\/wXfR6UQn7fW_MTEa9o-7H8Ixg0fJU0Zm\/850d4657-d199-3d4b-9250-3d2224930df6\/dzfp_24112000000073404958_\u4e2d\u90fd\u7269\u6d41\u6709\u9650\u516c\u53f8_20240701105523.pdf","orig_name":"dzfp_24112000000073404958_\u4e2d\u90fd\u7269\u6d41\u6709\u9650\u516c\u53f8_20240701105523.pdf"}}]}],"contractScans":[{"id":31371,"object_type":105,"object_id":3366,"attachment_id":19979,"attachment":{"id":19979,"key":19979,"name":"f9a5630f-1384-37d7-a265-de60fa0fdea9","extension":"pdf","path":"\/v2\/attachment\/preview\/wXfR6UQn7fW_MTEa9o-7H8Ixg0fJU0Zm\/f9a5630f-1384-37d7-a265-de60fa0fdea9\/\u4e2d\u90fd.pdf","orig_name":"\u4e2d\u90fd.pdf"}}],"receiptScans":[],"verifyScans":[],"unreadComments":null,"collected_plan":47204.1,"projectProductTotalAmount":47204.1,"projectProductAllAmount":true,"projectProductTotalCost":7500,"projectProductAllCost":true,"projectProductTotalCount":6,"invoiced":"47204.10","un_invoiced":0,"collected":"47204.1","un_collected":0,"is_collected":true,"handlerPerson":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0","avatar":{"id":10,"user_id":1004,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1004.jpg"}},"remind_date":"","remind_ahead_display":"\u63d0\u524d7\u5929","expire_remind_ahead_display":"\u63d0\u524d30\u5929","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,"can_view_product_cost":true,"erp_all_un_settle_amount":0,"verifyList":[]},{"id":3299,"client_id":48,"signed_at":"2024-04-30","amount":"92000","handler":1004,"description":"","created_by":1004,"created_at":"2024-05-20 14:44:52","updated_at":"2024-06-04 10:14:26","contract_scan":null,"receipt_scan":null,"contract_type":1,"project_id":3543,"valid_date":null,"expire_date":null,"sla":"","remind_ahead":"","expire_remind_ahead":"","expire_reminded":false,"serial_no":"TS-YJC-2024043019","payment_collection_remind_ahead":"7 days","from_project":3543,"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-05-20 14:48:15","is_verify":false,"is_draft":false,"erp_settle_amount":"92000","erp_un_settle_amount":"0","erp_payment_ticket_is_verify":false,"erp_collect_ticket_is_verify":false,"erp_cash_cost_ticket_is_verify":false,"erp_all_settle_amount":"92000","receipt_scan_uploaded":true,"verify_scan_uploaded":false,"contract_scan_uploaded":true,"is_edit_verify":false,"is_chargeback_verify":false,"b_date":null,"passed":1,"client":{"id":48,"key":48,"name":"\u4e2d\u90fd\u6570\u79d1\u4f9b\u5e94\u94fe\u7ba1\u7406\u6709\u9650\u516c\u53f8","logo":null,"sales_rep":1004,"salesRep":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0","avatar":{"id":10,"user_id":1004,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1004.jpg"}}},"contractScan":null,"receiptScan":null,"createdBy":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0","sex":"M","department_id":1,"avatar":{"id":10,"user_id":1004,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1004.jpg"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"commentCount":{"object_id":3299,"comment":6},"project":{"id":3543,"key":3543,"name":"\u5b58\u50a8\u6269\u5bb9","erpSalesOrder":{"id":1246,"serial_no":"XSDD-20240926-00001","from_date":null,"wrote_date":"2024-04-30","handler":1004,"client_id":48,"purchase_contract_id":null,"project_id":3543,"sales_contract_id":3299,"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-09-26 18:06:52","stop_at":null,"cancel_at":null,"refuse_description":null,"is_resubmitted":false,"is_done":true,"number":"1","amount":"92000","created_by":1004,"stop_description":null,"extra":null,"outbound_status":false,"is_used":false,"is_cancel":false,"is_settle":true,"is_old":true,"created_at":"2024-05-20 14:44:52","updated_at":"2024-09-26 18:06:52","print_times":null,"erpSalesOrderVerifyRels":[],"erpSalesOrderStopVerifyRels":[]}},"erpSalesOrder":{"id":1246,"serial_no":"XSDD-20240926-00001","from_date":null,"wrote_date":"2024-04-30","handler":1004,"client_id":48,"purchase_contract_id":null,"project_id":3543,"sales_contract_id":3299,"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-09-26 18:06:52","stop_at":null,"cancel_at":null,"refuse_description":null,"is_resubmitted":false,"is_done":true,"number":"1","amount":"92000","created_by":1004,"stop_description":null,"extra":null,"outbound_status":false,"is_used":false,"is_cancel":false,"is_settle":true,"is_old":true,"created_at":"2024-05-20 14:44:52","updated_at":"2024-09-26 18:06:52","print_times":null,"erpSalesOrderVerifyRels":[],"erpSalesOrderStopVerifyRels":[],"erpSalesOrderCancelVerifyRels":[]},"fromProject":{"id":3543,"key":3543,"name":"\u5b58\u50a8\u6269\u5bb9","description":"","total_contact_point":null,"paid_contact_point":null,"is_sales_order_ready":true,"project_product_version_id":403,"bargain_date":"2024-04-30","collected":"92000","profit_pct":"14.08","budget":"92000","erpSalesOrder":{"id":1246,"serial_no":"XSDD-20240926-00001","from_date":null,"wrote_date":"2024-04-30","handler":1004,"client_id":48,"purchase_contract_id":null,"project_id":3543,"sales_contract_id":3299,"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-09-26 18:06:52","stop_at":null,"cancel_at":null,"refuse_description":null,"is_resubmitted":false,"is_done":true,"number":"1","amount":"92000","created_by":1004,"stop_description":null,"extra":null,"outbound_status":false,"is_used":false,"is_cancel":false,"is_settle":true,"is_old":true,"created_at":"2024-05-20 14:44:52","updated_at":"2024-09-26 18:06:52","print_times":null},"projectProductTypes":[{"id":2743,"product_type_id":3,"key":3,"name":"\u5b58\u50a8\u8bbe\u5907","budget":"92000.00","pct":"14.08","project_id":3543,"profit":"12953.6"}],"projectProductRels":[{"id":5028,"project_id":3543,"product_id":1620,"amount":"92000","number":1,"cost":"75000","description":"","supplier_id":598,"hardware_from":"2024-05-20","software_from":null,"maintenance_from":null,"hardware_to":"2025-05-19","software_to":null,"maintenance_to":null,"total_amount":"92000","total_cost":"75000","erp_sales_order_product_id":896,"supplier":{"id":598,"key":598,"name":"\u5317\u4eac\u94f6\u65af\u6cf0\u7ecf\u8d38\u6709\u9650\u8d23\u4efb\u516c\u53f8"},"product":{"id":1620,"name":"DS224C(1.8TB*20\u5757\u786c\u76d8)","product_type":3,"product_component":17,"product_brand":6,"product_serie":1147,"product_misc":null,"product_qa":null,"pn":"","description":"FAS2750\u6269\u5c55\u67dcDS224C+20\u57571.8TB\uff0c\u542b5M SAS\u8fde\u63a5\u7ebf\u7f06","created_by":1013,"created_at":"2024-05-20 14:49:53","updated_at":"2024-05-20 14:50:18","pinyin_shortcut":"DS224C18TB20kyp","product_unit":2,"is_renew":false,"in_out_at":null,"productType":{"id":3,"key":3,"name":"\u5b58\u50a8\u8bbe\u5907"},"productComponent":{"id":17,"key":17,"name":"\u5b58\u50a8\u6269\u5c55\u67dc"},"productBrand":{"id":6,"key":6,"name":"NetApp"},"productSerie":{"id":1147,"key":1147,"name":"Netapp DS224C\u6269\u5c55\u67dc"},"productUnit":{"id":2,"key":2,"name":"\u5957"}},"erpSalesOrderProduct":{"id":896,"erp_sales_order_id":1246,"erp_store_id":null,"product_id":1620,"description":"","number":"1","outbound":"0","amount":"92000","total_amount":"92000","last_number":null,"last_amount":null,"last_total_amount":null,"cost":"75000","total_cost":"75000","supplier_id":598,"hardware_from":"2024-05-20","software_from":null,"maintenance_from":null,"hardware_to":"2025-05-19","software_to":null,"maintenance_to":null}}],"projectContactPoints":[],"buildSalesOrderItems":[{"id":9377,"project_id":3543}],"reimbursementAmountSum":null,"profit":12953.6,"contact_points_status_display":"\u672a\u8bbe\u7f6e","total_contact_paid_point":0,"total_contact_un_paid_point":0},"salesSupplierRels":[{"id":1427,"contract_id":3299,"supplier_id":598,"purchase_id":3292,"supplier":{"id":598,"key":598,"name":"\u5317\u4eac\u94f6\u65af\u6cf0\u7ecf\u8d38\u6709\u9650\u8d23\u4efb\u516c\u53f8"},"purchase":{"id":3292,"key":3292,"serial_no":"2024051401"}}],"contractType":{"id":1,"key":1,"name":"\u4ea7\u54c1\u9500\u552e"},"handleBy":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0","sex":"M","department_id":1,"avatar":{"id":10,"user_id":1004,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1004.jpg"}},"remindDate":null,"serviceContractRemindDates":[],"salesContractRemindReceivers":[],"serviceContractRemindReceivers":[],"salesContractPaymentCollectionRemindReceivers":[{"id":5290,"user_id":1004,"key":1004,"contract_id":3299,"user":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0","sex":"M","avatar":{"id":10,"user_id":1004,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1004.jpg"}}},{"id":5292,"user_id":1001,"key":1001,"contract_id":3299,"user":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/\/avatar\/e868e40f-1256-329e-9b1c-74e095049622.png"}}}],"salesContractPaymentCollectionRemindDates":[{"id":1663,"key":1663,"contract_id":3299,"name":"2024-07-19","value":"92000","overdue_days":69,"status":1,"remind_date":"2024-07-19","pct":100,"overdue_display":"\u903e\u671f69\u5929"}],"salesContractPayments":[{"id":"176","key":"176","contract_id":3299,"value":"92000","created_by":5388,"created_at":"2024-09-26 18:06:52","description":null,"collected_date":"2024-09-26 00:00:00","amount":"92000","createdBy":{"id":5388,"key":5388,"name":"\u6768\u71d5\u971e","sex":"F","department_id":6},"pct":100}],"salesContractInvoices":[{"id":1677,"key":1677,"contract_id":3299,"value":"92000.00","attachment_id":null,"from_date":"2024-06-05","description":"","is_draft":true,"is_cancel":false,"salesInvoiceAmounts":[{"id":2677,"sales_invoice_id":1677,"amount":"92000.00","tax_rate":"13"}],"attachment":null,"attachmentRelationships":[],"files":[{"id":26322,"object_type":102,"object_id":1677,"attachment_id":19596,"attachment":{"id":19596,"key":19596,"name":"f074abc2-3342-3b96-aeaa-8d6063754d77","extension":"pdf","path":"\/v2\/attachment\/view\/wXfR6UQn7fW_MTEa9o-7H8Ixg0fJU0Zm\/f074abc2-3342-3b96-aeaa-8d6063754d77\/dzfp_24112000000054739800_\u4e2d\u90fd\u7269\u6d41\u6709\u9650\u516c\u53f8_20240605150132.pdf","orig_name":"dzfp_24112000000054739800_\u4e2d\u90fd\u7269\u6d41\u6709\u9650\u516c\u53f8_20240605150132.pdf"}}]}],"contractScans":[{"id":26284,"object_type":105,"object_id":3299,"attachment_id":19258,"attachment":{"id":19258,"key":19258,"name":"37cd5dc2-81d3-3a71-ac3d-57866cb76207","extension":"pdf","path":"\/v2\/attachment\/preview\/wXfR6UQn7fW_MTEa9o-7H8Ixg0fJU0Zm\/37cd5dc2-81d3-3a71-ac3d-57866cb76207\/\u4e2d\u90fd\u5408\u540c.pdf","orig_name":"\u4e2d\u90fd\u5408\u540c.pdf"}}],"receiptScans":[{"id":26041,"object_type":106,"object_id":3299,"attachment_id":19377,"attachment":{"id":19377,"key":19377,"name":"7ea061a1-ac1a-3875-9733-c96ca8557d50","extension":"pdf","path":"\/v2\/attachment\/preview\/wXfR6UQn7fW_MTEa9o-7H8Ixg0fJU0Zm\/7ea061a1-ac1a-3875-9733-c96ca8557d50\/2024_05_22_11_18_36.pdf","orig_name":"2024_05_22_11_18_36.pdf"}}],"verifyScans":[],"unreadComments":null,"collected_plan":92000,"projectProductTotalAmount":92000,"projectProductAllAmount":true,"projectProductTotalCost":75000,"projectProductAllCost":true,"projectProductTotalCount":1,"invoiced":"92000.00","un_invoiced":0,"collected":"92000","un_collected":0,"is_collected":true,"handlerPerson":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0","avatar":{"id":10,"user_id":1004,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1004.jpg"}},"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,"can_view_product_cost":true,"erp_all_un_settle_amount":0,"verifyList":[]},{"id":3228,"client_id":48,"signed_at":"2024-04-15","amount":"950","handler":1004,"description":"","created_by":1004,"created_at":"2024-04-15 09:55:16","updated_at":"2024-05-08 10:17:39","contract_scan":null,"receipt_scan":null,"contract_type":1,"project_id":3498,"valid_date":null,"expire_date":null,"sla":"","remind_ahead":"","expire_remind_ahead":"","expire_reminded":false,"serial_no":"TS-YJC-2024041501","payment_collection_remind_ahead":null,"from_project":3498,"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-11-20 16:38:31","is_verify":false,"is_draft":false,"erp_settle_amount":"950","erp_un_settle_amount":"0","erp_payment_ticket_is_verify":false,"erp_collect_ticket_is_verify":false,"erp_cash_cost_ticket_is_verify":false,"erp_all_settle_amount":"950","receipt_scan_uploaded":true,"verify_scan_uploaded":false,"contract_scan_uploaded":true,"is_edit_verify":false,"is_chargeback_verify":false,"b_date":null,"passed":1,"client":{"id":48,"key":48,"name":"\u4e2d\u90fd\u6570\u79d1\u4f9b\u5e94\u94fe\u7ba1\u7406\u6709\u9650\u516c\u53f8","logo":null,"sales_rep":1004,"salesRep":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0","avatar":{"id":10,"user_id":1004,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1004.jpg"}}},"contractScan":null,"receiptScan":null,"createdBy":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0","sex":"M","department_id":1,"avatar":{"id":10,"user_id":1004,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1004.jpg"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"commentCount":{"object_id":3228,"comment":5},"project":{"id":3498,"key":3498,"name":"\u670d\u52a1\u5668\u786c\u76d8300GB","erpSalesOrder":{"id":1219,"serial_no":"XSDD-20240415-00001","from_date":null,"wrote_date":"2024-04-15","handler":1004,"client_id":48,"purchase_contract_id":null,"project_id":3498,"sales_contract_id":3228,"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-05-20 17:33:21","stop_at":null,"cancel_at":null,"refuse_description":null,"is_resubmitted":false,"is_done":true,"number":"1","amount":"950","created_by":1004,"stop_description":null,"extra":null,"outbound_status":false,"is_used":false,"is_cancel":false,"is_settle":true,"is_old":true,"created_at":"2024-04-15 09:55:16","updated_at":"2024-05-20 17:33:21","print_times":null,"erpSalesOrderVerifyRels":[],"erpSalesOrderStopVerifyRels":[]}},"erpSalesOrder":{"id":1219,"serial_no":"XSDD-20240415-00001","from_date":null,"wrote_date":"2024-04-15","handler":1004,"client_id":48,"purchase_contract_id":null,"project_id":3498,"sales_contract_id":3228,"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-05-20 17:33:21","stop_at":null,"cancel_at":null,"refuse_description":null,"is_resubmitted":false,"is_done":true,"number":"1","amount":"950","created_by":1004,"stop_description":null,"extra":null,"outbound_status":false,"is_used":false,"is_cancel":false,"is_settle":true,"is_old":true,"created_at":"2024-04-15 09:55:16","updated_at":"2024-05-20 17:33:21","print_times":null,"erpSalesOrderVerifyRels":[],"erpSalesOrderStopVerifyRels":[],"erpSalesOrderCancelVerifyRels":[]},"fromProject":{"id":3498,"key":3498,"name":"\u670d\u52a1\u5668\u786c\u76d8300GB","description":"","total_contact_point":null,"paid_contact_point":null,"is_sales_order_ready":true,"project_product_version_id":334,"bargain_date":"2024-04-15","collected":"950","profit_pct":"57.53","budget":"950","erpSalesOrder":{"id":1219,"serial_no":"XSDD-20240415-00001","from_date":null,"wrote_date":"2024-04-15","handler":1004,"client_id":48,"purchase_contract_id":null,"project_id":3498,"sales_contract_id":3228,"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-05-20 17:33:21","stop_at":null,"cancel_at":null,"refuse_description":null,"is_resubmitted":false,"is_done":true,"number":"1","amount":"950","created_by":1004,"stop_description":null,"extra":null,"outbound_status":false,"is_used":false,"is_cancel":false,"is_settle":true,"is_old":true,"created_at":"2024-04-15 09:55:16","updated_at":"2024-05-20 17:33:21","print_times":null},"projectProductTypes":[{"id":2738,"product_type_id":3,"key":3,"name":"\u5b58\u50a8\u8bbe\u5907","budget":"950.00","pct":"57.53","project_id":3498,"profit":"546.535"}],"projectProductRels":[{"id":4534,"project_id":3498,"product_id":1557,"amount":"950","number":1,"cost":"300","description":"","supplier_id":81,"hardware_from":"2024-04-15","software_from":null,"maintenance_from":null,"hardware_to":"2025-04-14","software_to":null,"maintenance_to":null,"total_amount":"950","total_cost":"300","erp_sales_order_product_id":788,"supplier":{"id":81,"key":81,"name":"\u5317\u4eac\u4ebf\u901a\u65b0\u6708\u79d1\u6280\u53d1\u5c55\u6709\u9650\u516c\u53f8\/\u4ebf\u901a\u9633\u5149"},"product":{"id":1557,"name":"42D0613","product_type":2,"product_component":5,"product_brand":4,"product_serie":1191,"product_misc":null,"product_qa":null,"pn":"","description":"300GB 10K 6Gb SAS ","created_by":1013,"created_at":"2024-04-15 09:14:51","updated_at":"2024-04-15 09:14:51","pinyin_shortcut":"42D0613","product_unit":4,"is_renew":false,"in_out_at":null,"productType":{"id":2,"key":2,"name":"\u670d\u52a1\u5668"},"productComponent":{"id":5,"key":5,"name":"\u670d\u52a1\u5668\u786c\u76d8"},"productBrand":{"id":4,"key":4,"name":"\u8054\u60f3"},"productSerie":{"id":1191,"key":1191,"name":"300G 10K 2.5 SAS \u786c\u76d8"},"productUnit":{"id":4,"key":4,"name":"\u5757"}},"erpSalesOrderProduct":{"id":788,"erp_sales_order_id":1219,"erp_store_id":null,"product_id":1557,"description":"","number":"1","outbound":"0","amount":"950","total_amount":"950","last_number":null,"last_amount":null,"last_total_amount":null,"cost":"300","total_cost":"300","supplier_id":81,"hardware_from":"2024-04-15","software_from":null,"maintenance_from":null,"hardware_to":"2025-04-14","software_to":null,"maintenance_to":null}}],"projectContactPoints":[],"buildSalesOrderItems":[{"id":9068,"project_id":3498}],"reimbursementAmountSum":{"project_id":3498,"sum":"376.77"},"profit":546.535,"contact_points_status_display":"\u672a\u8bbe\u7f6e","total_contact_paid_point":0,"total_contact_un_paid_point":0},"salesSupplierRels":[{"id":1458,"contract_id":3228,"supplier_id":81,"purchase_id":3267,"supplier":{"id":81,"key":81,"name":"\u5317\u4eac\u4ebf\u901a\u65b0\u6708\u79d1\u6280\u53d1\u5c55\u6709\u9650\u516c\u53f8\/\u4ebf\u901a\u9633\u5149"},"purchase":{"id":3267,"key":3267,"serial_no":"20240411"}}],"contractType":{"id":1,"key":1,"name":"\u4ea7\u54c1\u9500\u552e"},"handleBy":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0","sex":"M","department_id":1,"avatar":{"id":10,"user_id":1004,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1004.jpg"}},"remindDate":null,"serviceContractRemindDates":[],"salesContractRemindReceivers":[],"serviceContractRemindReceivers":[],"salesContractPaymentCollectionRemindReceivers":[{"id":7116,"user_id":1004,"key":1004,"contract_id":3228,"user":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0","sex":"M","avatar":{"id":10,"user_id":1004,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1004.jpg"}}}],"salesContractPaymentCollectionRemindDates":[{"id":2159,"key":2159,"contract_id":3228,"name":"2024-05-20","value":"950","overdue_days":0,"status":1,"remind_date":"2024-05-20","pct":100,"overdue_display":"\u903e\u671f0\u5929"}],"salesContractPayments":[{"id":"11833","key":"11833","contract_id":3228,"value":"950","created_by":1013,"created_at":"2024-05-20 17:33:21","description":null,"collected_date":"2024-05-20 00:00:00","amount":"950","createdBy":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","department_id":7},"pct":100}],"salesContractInvoices":[{"id":1632,"key":1632,"contract_id":3228,"value":"950.00","attachment_id":null,"from_date":"2024-04-15","description":"","is_draft":true,"is_cancel":false,"salesInvoiceAmounts":[{"id":2645,"sales_invoice_id":1632,"amount":"950.00","tax_rate":"13"}],"attachment":null,"attachmentRelationships":[],"files":[{"id":25068,"object_type":102,"object_id":1632,"attachment_id":18564,"attachment":{"id":18564,"key":18564,"name":"20790f46-ba0a-31b8-a13d-4b96a52a5901","extension":"pdf","path":"\/v2\/attachment\/view\/wXfR6UQn7fW_MTEa9o-7H8Ixg0fJU0Zm\/20790f46-ba0a-31b8-a13d-4b96a52a5901\/dzfp_24112000000023078763_\u4e2d\u90fd\u7269\u6d41\u6709\u9650\u516c\u53f8_20240415113552.pdf","orig_name":"dzfp_24112000000023078763_\u4e2d\u90fd\u7269\u6d41\u6709\u9650\u516c\u53f8_20240415113552.pdf"}}]}],"contractScans":[{"id":25538,"object_type":105,"object_id":3228,"attachment_id":18637,"attachment":{"id":18637,"key":18637,"name":"fac0252f-40a8-3030-af01-f6eb514109ed","extension":"pdf","path":"\/v2\/attachment\/preview\/wXfR6UQn7fW_MTEa9o-7H8Ixg0fJU0Zm\/fac0252f-40a8-3030-af01-f6eb514109ed\/2024_04_16_09_42_11.pdf","orig_name":"2024_04_16_09_42_11.pdf"}}],"receiptScans":[{"id":25148,"object_type":106,"object_id":3228,"attachment_id":18638,"attachment":{"id":18638,"key":18638,"name":"2c97374d-aea4-352d-9065-248babaa4967","extension":"pdf","path":"\/v2\/attachment\/preview\/wXfR6UQn7fW_MTEa9o-7H8Ixg0fJU0Zm\/2c97374d-aea4-352d-9065-248babaa4967\/2024_04_16_09_42_20.pdf","orig_name":"2024_04_16_09_42_20.pdf"}}],"verifyScans":[],"unreadComments":null,"collected_plan":950,"projectProductTotalAmount":950,"projectProductAllAmount":true,"projectProductTotalCost":300,"projectProductAllCost":true,"projectProductTotalCount":1,"invoiced":"950.00","un_invoiced":0,"collected":"950","un_collected":0,"is_collected":true,"handlerPerson":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0","avatar":{"id":10,"user_id":1004,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1004.jpg"}},"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,"can_view_product_cost":true,"erp_all_un_settle_amount":0,"verifyList":[]}],"pagenation":{"totalcount":42,"thispage":1,"pagesize":10}},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}],"ip":"39.156.194.178","ua":"jinchangxiao\/2.3.176 (HUAWEIVOG-AL00; Android 10)"}', FALSE, '2026-07-13 14:09:37', 275720960) RETURNING "id" |