68838eb8a8903: POST https://beta.jinchangxiao.com/v2/sales-contract/list at 2025-07-25 10:03:36 pm by 39.157.26.18
Log Messages
总计119条数据
| Time | Level | Category | Message |
|---|---|---|---|
| 22:03:36.689 | trace | yii\base\Application::bootstrap | Bootstrap with yii\log\Dispatcher |
| 22:03:36.689 | trace | yii\base\Module::getModule | Loading module: debug |
| 22:03:36.690 | trace | yii\base\Application::bootstrap | Bootstrap with yii\debug\Module::bootstrap() |
| 22:03:36.690 | trace | yii\redis\Connection::open | Opening redis DB connection: redis.server.local:6379, database=1 |
| 22:03:36.690 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: SELECT |
| 22:03:36.691 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 22:03:36.691 | trace | yii\base\Module::getModule | Loading module: gii |
| 22:03:36.691 | trace | yii\base\Application::bootstrap | Bootstrap with yii\gii\Module::bootstrap() |
| 22:03:36.692 | trace | yii\web\UrlManager::parseRequest | No matching URL rules. Using default URL parsing logic. |
| 22:03:36.692 | trace | yii\web\Application::handleRequest | Route requested: 'v2/sales-contract/list' |
| 22:03:36.692 | trace | yii\base\Module::getModule | Loading module: v2 |
| 22:03:37.144 | info | yii\web\Session::open | Session started |
| 22:03:37.145 | info | yii\db\Connection::open | Opening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta |
| 22:03:37.149 | info | yii\db\Command::query | SELECT * FROM "global"."vw_user_login" WHERE "access_token"='GWtUzjYcC0dtywXjcMjkzgu5CXqDQ6je' |
| 22:03:37.153 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 22:03:37.153 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 22:03:37.154 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 22:03:37.154 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 22:03:37.154 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=5300 |
| 22:03:37.156 | trace | yii\base\Controller::runAction | Route to run: v2/sales-contract/list |
| 22:03:37.162 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 22:03:37.165 | trace | uranus\rbac\DbManager::checkAccessFromCache | Checking role: Admin |
| 22:03:37.165 | trace | uranus\rbac\DbManager::checkAccessFromCache | Checking permission: viewSalesContract |
| 22:03:37.165 | trace | uranus\rbac\DbManager::checkAccessFromCache | Checking role: Accountant |
| 22:03:37.165 | trace | uranus\rbac\DbManager::checkAccessFromCache | Checking role: Admin |
| 22:03:37.165 | trace | uranus\rbac\DbManager::checkAccessFromCache | Checking role: TechDirector |
| 22:03:37.165 | trace | uranus\rbac\DbManager::checkAccessFromCache | Checking role: ProjectManager |
| 22:03:37.165 | trace | uranus\rbac\DbManager::checkAccessFromCache | Checking role: SalesDirector |
| 22:03:37.165 | trace | uranus\rbac\DbManager::checkAccessFromCache | Checking role: SalesManager |
| 22:03:37.165 | trace | uranus\rbac\DbManager::checkAccessFromCache | Checking role: AccountManager |
| 22:03:37.165 | trace | yii\base\InlineAction::runWithParams | Running action: app\modules\v2\controllers\SalesContractController::actionList() |
| 22:03:37.165 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 22:03:37.165 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 22:03:37.166 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 22:03:37.171 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 22:03:37.173 | info | yii\db\Command::query | SELECT COUNT(*) FROM (SELECT c.*, abs(c.expire_date - current_date) AS b_date, CASE WHEN c.expire_date IS NULL THEN 1 ELSE 2 END AS passed FROM "a57be577deb434"."tbl_sales_contracts" "c" LEFT JOIN "a57be577deb434"."tbl_clients" "client" ON client.id = c.client_id LEFT JOIN "a57be577deb434"."tbl_projects" "p" ON p.id = c.from_project LEFT JOIN "a57be577deb434"."tbl_sales_group_relationships" "sgr" ON sgr.sales_id = client.sales_rep LEFT JOIN "a57be577deb434"."tbl_attachement_relationships" "cs" ON cs.object_id = c.id AND cs.object_type = 105 LEFT JOIN "a57be577deb434"."tbl_attachement_relationships" "rs" ON rs.object_id = c.id AND rs.object_type = 106 LEFT JOIN "a57be577deb434"."tbl_attachement_relationships" "vs" ON vs.object_id = c.id AND vs.object_type = 107 WHERE (true) AND (("client"."sales_rep" IN (5300, 5309, 5311)) OR ("client"."sales_rep" IS NULL) OR ("client"."id" IN (SELECT "client_id" FROM "a57be577deb434"."tbl_user_visit_clients" WHERE "user_id"=5300))) GROUP BY "c"."id" ORDER BY "c"."signed_at" DESC, "c"."created_at" DESC) "c" |
| 22:03:37.184 | info | yii\db\Command::query | SELECT c.*, abs(c.expire_date - current_date) AS b_date, CASE WHEN c.expire_date IS NULL THEN 1 ELSE 2 END AS passed FROM "a57be577deb434"."tbl_sales_contracts" "c" LEFT JOIN "a57be577deb434"."tbl_clients" "client" ON client.id = c.client_id LEFT JOIN "a57be577deb434"."tbl_projects" "p" ON p.id = c.from_project LEFT JOIN "a57be577deb434"."tbl_sales_group_relationships" "sgr" ON sgr.sales_id = client.sales_rep LEFT JOIN "a57be577deb434"."tbl_attachement_relationships" "cs" ON cs.object_id = c.id AND cs.object_type = 105 LEFT JOIN "a57be577deb434"."tbl_attachement_relationships" "rs" ON rs.object_id = c.id AND rs.object_type = 106 LEFT JOIN "a57be577deb434"."tbl_attachement_relationships" "vs" ON vs.object_id = c.id AND vs.object_type = 107 WHERE (true) AND (("client"."sales_rep" IN (5300, 5309, 5311)) OR ("client"."sales_rep" IS NULL) OR ("client"."id" IN (SELECT "client_id" FROM "a57be577deb434"."tbl_user_visit_clients" WHERE "user_id"=5300))) GROUP BY "c"."id" ORDER BY "c"."signed_at" DESC, "c"."created_at" DESC LIMIT 10 |
| 22:03:37.196 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "name", "logo", "sales_rep" FROM "a57be577deb434"."tbl_clients" WHERE "id" IN (2736, 12, 531, 4, 3333, 97, 2182) |
| 22:03:37.199 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (5300, 5311) |
| 22:03:37.200 | 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 (5311, 5300)) |
| 22:03:37.201 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (5300, 1005) |
| 22:03:37.202 | 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 (1005, 5300)) |
| 22:03:37.202 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_departments" WHERE "id"=1 |
| 22:03:37.203 | info | yii\db\Command::query | SELECT "object_id", count(*) AS comment FROM "a57be577deb434"."tbl_comments" WHERE ("object_type"=7) AND ("object_id" IN (3822, 3816, 3811, 3809, 3792, 3795, 3787, 3782, 3778, 3761)) GROUP BY "object_id" |
| 22:03:37.226 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "project_title" AS "name" FROM "a57be577deb434"."tbl_projects" WHERE "id" IN (3793, 3794, 3791, 3789, 3782, 3783, 3774, 3775, 3773, 3745) |
| 22:03:37.227 | 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 (3793, 3794, 3791, 3789, 3782, 3783, 3774, 3775, 3773, 3745) |
| 22:03:37.228 | 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 (3745, 3775, 3773, 3774, 3782, 3789, 3793, 3791, 3794, 3783) |
| 22:03:37.230 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_project_product_rels" WHERE "project_id" IN (3745, 3775, 3773, 3774, 3782, 3789, 3793, 3791, 3794, 3783) |
| 22:03:37.231 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_suppliers" WHERE "id" IN (137, 608, 505, 489, 678) |
| 22:03:37.234 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_products" WHERE "id" IN (1936, 1770, 941, 1689, 1941, 1942, 1954, 542) |
| 22:03:37.238 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_types" WHERE "id" IN (11, 19, 2, 4, 7, 3) |
| 22:03:37.238 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_components" WHERE "id" IN (179, 151, 5, 43, 2, 30, 39) |
| 22:03:37.239 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_brands" WHERE "id" IN (10, 133, 43, 4, 20, 227, 6) |
| 22:03:37.240 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_series" WHERE "id" IN (1437, 592, 1495, 1198, 1596, 1599, 1600, 1608) |
| 22:03:37.243 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_units" WHERE "id" IN (3, 7, 4, 1, 2) |
| 22:03:37.243 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_project_contact_points" WHERE "project_id" IN (3745, 3775, 3773, 3774, 3782, 3789, 3793, 3791, 3794, 3783) |
| 22:03:37.245 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "name", "client_id", "supplier_id" FROM "a57be577deb434"."tbl_contacts" WHERE "id" IN (3988, 1188) |
| 22:03:37.246 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_clients" WHERE "id" IN (531, 2182) |
| 22:03:37.247 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_project_contact_point_rels" WHERE ("contact_id", "project_id") IN ((3988, 3745), (1188, 3791)) |
| 22:03:37.249 | info | yii\db\Command::query | SELECT "id", "project_id" FROM "a57be577deb434"."tbl_sales_order_items" WHERE ("is_system"=TRUE) AND ("project_id" IN (3745, 3775, 3773, 3774, 3782, 3789, 3793, 3791, 3794, 3783)) |
| 22:03:37.253 | info | yii\db\Command::query | SELECT "project_id", sum(amount) AS sum FROM "a57be577deb434"."tbl_reimbursements" WHERE ("status" IN (3, 2)) AND ("project_id" IN (3745, 3775, 3773, 3774, 3782, 3789, 3793, 3791, 3794, 3783)) GROUP BY "project_id" |
| 22:03:37.256 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_sales_supplier_rels" WHERE "contract_id" IN (3822, 3816, 3811, 3809, 3792, 3795, 3787, 3782, 3778, 3761) |
| 22:03:37.258 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_suppliers" WHERE "id" IN (608, 137, 505, 685, 489, 678) |
| 22:03:37.262 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "serial_no" FROM "a57be577deb434"."tbl_purchase_contracts" WHERE "id" IN (3779, 3760, 3793, 3821, 3810, 3814, 3819) |
| 22:03:37.263 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "type" AS "name" FROM "a57be577deb434"."tbl_contract_types" WHERE "id" IN (2, 1) |
| 22:03:37.263 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (5300, 1005) |
| 22:03:37.264 | 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 (1005, 5300)) |
| 22:03:37.264 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "contract_id", "remind_date" FROM "a57be577deb434"."tbl_service_contract_remind_dates" WHERE ("reminded"=FALSE) AND ("contract_id" IN (3822, 3816, 3811, 3809, 3792, 3795, 3787, 3782, 3778, 3761)) ORDER BY "remind_date" |
| 22:03:37.265 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "contract_id", "remind_date" AS "name" FROM "a57be577deb434"."tbl_service_contract_remind_dates" WHERE "contract_id" IN (3822, 3816, 3811, 3809, 3792, 3795, 3787, 3782, 3778, 3761) |
| 22:03:37.266 | info | yii\db\Command::query | SELECT "id", "user_id", "user_id" AS "key", "contract_id" FROM "a57be577deb434"."tbl_sales_contract_remind_receivers" WHERE "contract_id" IN (3822, 3816, 3811, 3809, 3792, 3795, 3787, 3782, 3778, 3761) |
| 22:03:37.266 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "name", "sex" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (5311, 5300) |
| 22:03:37.267 | 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 (5311, 5300)) |
| 22:03:37.267 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_service_contract_remind_receivers" WHERE "contract_id" IN (3822, 3816, 3811, 3809, 3792, 3795, 3787, 3782, 3778, 3761) |
| 22:03:37.268 | info | yii\db\Command::query | SELECT "id", "user_id", "user_id" AS "key", "contract_id" FROM "a57be577deb434"."tbl_sales_contract_payment_collection_remind_receivers" WHERE "contract_id" IN (3822, 3816, 3811, 3809, 3792, 3795, 3787, 3782, 3778, 3761) |
| 22:03:37.269 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "name", "sex" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (5300, 5388, 1001, 1005) |
| 22:03:37.269 | info | yii\db\Command::query | SELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id" IN (1001, 5388, 1005, 5300)) |
| 22:03:37.270 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "contract_id", "remind_date" AS "name", "amount" AS "value", "overdue_days" FROM "a57be577deb434"."tbl_sales_contract_payment_collection_remind_dates" WHERE "contract_id" IN (3822, 3816, 3811, 3809, 3792, 3795, 3787, 3782, 3778, 3761) ORDER BY "remind_date" |
| 22:03:37.271 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "contract_id", "amount" AS "value", "created_by", "created_at", "description", "collected_date", "amount" FROM "a57be577deb434"."tbl_sales_contract_payments" WHERE "contract_id" IN (3822, 3816, 3811, 3809, 3792, 3795, 3787, 3782, 3778, 3761) ORDER BY "id" |
| 22:03:37.272 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id"=1013 |
| 22:03:37.272 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=109) AND ("object_id" IN (2095, 2109, 2121, 2122, 2126, 2131)) |
| 22:03:37.275 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "name", "extension", "path", "orig_name" FROM "a57be577deb434"."tbl_attachments" WHERE "id" IN (23958, 24166, 24391, 24392, 24423, 24457) |
| 22:03:37.278 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "contract_id", "amount" AS "value", "attachment_id", "from_date" FROM "a57be577deb434"."tbl_sales_contract_invoices" WHERE "contract_id" IN (3822, 3816, 3811, 3809, 3792, 3795, 3787, 3782, 3778, 3761) ORDER BY "id" |
| 22:03:37.279 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=20) AND ("object_id" IN (1941, 1959, 1962, 1966, 1967, 1970, 1971, 1972, 1973, 1978, 1979, 1987)) |
| 22:03:37.282 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "name", "extension", "path", "orig_name" FROM "a57be577deb434"."tbl_attachments" WHERE "id"=24734 |
| 22:03:37.284 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=102) AND ("object_id" IN (1941, 1959, 1962, 1966, 1967, 1970, 1971, 1972, 1973, 1978, 1979, 1987)) |
| 22:03:37.286 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "name", "extension", "path", "orig_name" FROM "a57be577deb434"."tbl_attachments" WHERE "id" IN (23775, 24274, 24277, 24410, 24414, 24425, 24432, 24442, 24459, 24541, 24542, 24735, 24736) |
| 22:03:37.289 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=105) AND ("object_id" IN (3822, 3816, 3811, 3809, 3792, 3795, 3787, 3782, 3778, 3761)) |
| 22:03:37.291 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "name", "extension", "path", "orig_name" FROM "a57be577deb434"."tbl_attachments" WHERE "id" IN (24023, 24020, 23774, 24293, 24289, 24404, 24403, 24524, 24558, 24526) |
| 22:03:37.293 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=106) AND ("object_id" IN (3822, 3816, 3811, 3809, 3792, 3795, 3787, 3782, 3778, 3761)) |
| 22:03:37.295 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "name", "extension", "path", "orig_name" FROM "a57be577deb434"."tbl_attachments" WHERE "id" IN (24052, 24079, 24488, 24560) |
| 22:03:37.296 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=107) AND ("object_id" IN (3822, 3816, 3811, 3809, 3792, 3795, 3787, 3782, 3778, 3761)) |
| 22:03:37.298 | info | yii\db\Command::query | SELECT "object_id", count(*) AS unread FROM "a57be577deb434"."tbl_unread_comments" WHERE ("object_type"=7) AND (remind_user_id = 5300 AND is_read = false) AND ("object_id" IN (3822, 3816, 3811, 3809, 3792, 3795, 3787, 3782, 3778, 3761)) GROUP BY "object_id" |
| 22:03:37.321 | trace | uranus\rbac\DbManager::checkAccessFromCache | Checking permission: updateSalesContract |
| 22:03:37.321 | trace | uranus\rbac\DbManager::checkAccessFromCache | Checking role: Accountant |
| 22:03:37.321 | trace | uranus\rbac\DbManager::checkAccessFromCache | Checking role: Admin |
| 22:03:37.321 | trace | uranus\rbac\DbManager::checkAccessFromCache | Checking role: ProjectManager |
| 22:03:37.321 | trace | uranus\rbac\DbManager::checkAccessFromCache | Checking role: 电话销售 |
| 22:03:37.321 | trace | uranus\rbac\DbManager::checkAccessFromCache | Checking role: CommercialAttache |
| 22:03:37.321 | trace | uranus\rbac\DbManager::checkAccessFromCache | Checking role: GM |
| 22:03:37.321 | trace | uranus\rbac\DbManager::checkAccessFromCache | Checking role: StoreKeeper |
| 22:03:37.321 | trace | uranus\rbac\DbManager::checkAccessFromCache | Checking role: Treasurer |
| 22:03:37.321 | trace | uranus\rbac\DbManager::checkAccessFromCache | Checking permission: viewProduct |
| 22:03:37.321 | trace | uranus\rbac\DbManager::checkAccessFromCache | Checking role: Accountant |
| 22:03:37.321 | trace | uranus\rbac\DbManager::checkAccessFromCache | Checking role: Admin |
| 22:03:37.321 | trace | uranus\rbac\DbManager::checkAccessFromCache | Checking role: TechDirector |
| 22:03:37.321 | trace | uranus\rbac\DbManager::checkAccessFromCache | Checking role: StoreKeeper |
| 22:03:37.321 | trace | uranus\rbac\DbManager::checkAccessFromCache | Checking role: ProjectManager |
| 22:03:37.321 | trace | uranus\rbac\DbManager::checkAccessFromCache | Checking role: AccountManager |
| 22:03:37.321 | trace | uranus\rbac\DbManager::checkAccessFromCache | Checking permission: serviceProgress |
| 22:03:37.321 | trace | uranus\rbac\DbManager::checkAccessFromCache | Checking role: Accountant |
| 22:03:37.321 | trace | uranus\rbac\DbManager::checkAccessFromCache | Checking role: Admin |
| 22:03:37.321 | trace | uranus\rbac\DbManager::checkAccessFromCache | Checking role: ProjectManager |
| 22:03:37.321 | trace | uranus\rbac\DbManager::checkAccessFromCache | Checking role: Dispatcher |
| 22:03:37.321 | trace | uranus\rbac\DbManager::checkAccessFromCache | Checking role: GM |
| 22:03:37.321 | trace | uranus\rbac\DbManager::checkAccessFromCache | Checking role: TechDirector |
| 22:03:37.321 | trace | uranus\rbac\DbManager::checkAccessFromCache | Checking role: Operator |
| 22:03:37.323 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 22:03:37.323 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 22:03:37.327 | info | yii\db\Command::query | INSERT INTO "global"."tbl_api_log" ("code", "schema", "user_id", "device_type", "version_code", "url", "request", "response", "php_error", "time") VALUES (200, 'a57be577deb434', 5300, 2, 1144, 'v2/sales-contract/list', '{"access_token":"GWtUzjYcC0dtywXjcMjkzgu5CXqDQ6je","device_type":"2","posttime":"1753452160","token":"ceb348e81fe3b87f199a0a5d73f1434e","version_code":"1144"}', '{"code":200,"data":{"list":[{"id":3822,"client_id":2736,"signed_at":"2025-03-10","amount":"2500","handler":5300,"description":"","created_by":5300,"created_at":"2025-03-10 10:17:21","updated_at":"2025-03-12 17:05:47","contract_scan":null,"receipt_scan":null,"contract_type":2,"project_id":3793,"valid_date":null,"expire_date":null,"sla":"","remind_ahead":"","expire_remind_ahead":"","expire_reminded":false,"serial_no":"","payment_collection_remind_ahead":"7 days","from_project":3793,"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-03-10 10:17:21.573991+08","b_date":null,"passed":1,"client":{"id":2736,"key":2736,"name":"\u5317\u4eac\u4e2d\u6570\u521b\u65b0\u79d1\u6280\u80a1\u4efd\u6709\u9650\u516c\u53f8(\u7f51\u6839\u79d1\u6280\uff08\u5317\u4eac\uff09\u6709\u9650\u516c\u53f8)","logo":null,"sales_rep":5300,"salesRep":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91","avatar":{"id":141,"user_id":5300,"name":"\/files\/cdn\/a57be577deb434\/avatar\/14dfd1a0-6df5-354a-8afd-f0a76fa8e852.png"}}},"contractScan":null,"receiptScan":null,"createdBy":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91","sex":"F","department_id":1,"avatar":{"id":141,"user_id":5300,"name":"\/files\/cdn\/a57be577deb434\/avatar\/14dfd1a0-6df5-354a-8afd-f0a76fa8e852.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"commentCount":{"object_id":3822,"comment":7},"project":{"id":3793,"key":3793,"name":"\u9632\u706b\u5899\u6545\u969c\u5904\u7f6e\u548c\u79df\u8d41-G-2025"},"fromProject":{"id":3793,"key":3793,"name":"\u9632\u706b\u5899\u6545\u969c\u5904\u7f6e\u548c\u79df\u8d41-G-2025","description":"","total_contact_point":null,"paid_contact_point":null,"is_sales_order_ready":true,"project_product_version_id":805,"bargain_date":"2025-03-10","collected":"0","profit_pct":"93","budget":"2500","projectProductTypes":[{"id":6099,"product_type_id":16,"key":16,"name":"\u8fd0\u7ef4\u670d\u52a1","budget":"2500.00","pct":"93","project_id":3793,"profit":"2325"}],"projectProductRels":[{"id":8990,"project_id":3793,"product_id":941,"amount":"2500.00","number":1,"cost":"0","description":"","supplier_id":null,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null,"total_amount":"2500","total_cost":"0","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":"2023-08-11 16:02:47","pinyin_shortcut":"tsrgjsfw","product_unit":7,"is_renew":false,"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"}}}],"projectContactPoints":[],"buildSalesOrderItems":[{"id":12705,"project_id":3793}],"reimbursementAmountSum":null,"profit":2325,"contact_points_status_display":"\u672a\u8bbe\u7f6e"},"salesSupplierRels":[],"contractType":{"id":2,"key":2,"name":"\u8fd0\u7ef4\u670d\u52a1"},"handleBy":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91","sex":"F","department_id":1,"avatar":{"id":141,"user_id":5300,"name":"\/files\/cdn\/a57be577deb434\/avatar\/14dfd1a0-6df5-354a-8afd-f0a76fa8e852.png"}},"remindDate":null,"serviceContractRemindDates":[],"salesContractRemindReceivers":[],"serviceContractRemindReceivers":[],"salesContractPaymentCollectionRemindReceivers":[{"id":8038,"user_id":5300,"key":5300,"contract_id":3822,"user":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91","sex":"F","avatar":{"id":141,"user_id":5300,"name":"\/files\/cdn\/a57be577deb434\/avatar\/14dfd1a0-6df5-354a-8afd-f0a76fa8e852.png"}}},{"id":8039,"user_id":5388,"key":5388,"contract_id":3822,"user":{"id":5388,"key":5388,"name":"\u6768\u71d5\u971e","sex":"F","avatar":{"id":156,"user_id":5388,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b8d4f68f-e736-3c38-9e2f-1ab47885b3d8.png"}}},{"id":8040,"user_id":1001,"key":1001,"contract_id":3822,"user":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}}}],"salesContractPaymentCollectionRemindDates":[{"id":2357,"key":2357,"contract_id":3822,"name":"2025-04-21","value":"2500","overdue_days":null,"pct":100,"collect_status":"\u903e\u671f95\u5929"}],"salesContractPayments":[],"salesContractInvoices":[{"id":1973,"key":1973,"contract_id":3822,"value":"2500.00","attachment_id":null,"from_date":"2025-03-10","attachment":null,"attachmentRelationships":[],"files":[{"id":32765,"object_type":102,"object_id":1973,"attachment_id":24459,"attachment":{"id":24459,"key":24459,"name":"71d5dda2-3a17-3984-80e1-bac7620b7349","extension":"pdf","path":"\/v2\/attachment\/view\/GWtUzjYcC0dtywXjcMjkzgu5CXqDQ6je\/71d5dda2-3a17-3984-80e1-bac7620b7349\/dzfp_25112000000047178002_\u7f51\u6839\u79d1\u6280\uff08\u5317\u4eac\uff09\u6709\u9650\u516c\u53f8_20250310111046.pdf","orig_name":"dzfp_25112000000047178002_\u7f51\u6839\u79d1\u6280\uff08\u5317\u4eac\uff09\u6709\u9650\u516c\u53f8_20250310111046.pdf"}}]},{"id":1987,"key":1987,"contract_id":3822,"value":"1.00","attachment_id":null,"from_date":"2025-05-22","attachment":null,"attachmentRelationships":[{"id":33106,"object_type":20,"object_id":1987,"attachment_id":24734,"attachment":{"id":24734,"key":24734,"name":"f9f5d3ee-b455-3882-9eae-4e57242934f6","extension":"jpg","path":"\/v2\/attachment\/view\/GWtUzjYcC0dtywXjcMjkzgu5CXqDQ6je\/f9f5d3ee-b455-3882-9eae-4e57242934f6\/WechatIMG61.jpg","orig_name":"WechatIMG61.jpg"}}],"files":[{"id":33107,"object_type":102,"object_id":1987,"attachment_id":24735,"attachment":{"id":24735,"key":24735,"name":"350f1ee5-3bf7-3443-abed-86f41880aa83","extension":"docx","path":"\/v2\/attachment\/view\/GWtUzjYcC0dtywXjcMjkzgu5CXqDQ6je\/350f1ee5-3bf7-3443-abed-86f41880aa83\/05-22\u5f85\u5f00\u53d1.docx","orig_name":"05-22\u5f85\u5f00\u53d1.docx"}},{"id":33108,"object_type":102,"object_id":1987,"attachment_id":24736,"attachment":{"id":24736,"key":24736,"name":"bab6e6e1-0ef9-3778-89fb-8d755557756d","extension":"docx","path":"\/v2\/attachment\/view\/GWtUzjYcC0dtywXjcMjkzgu5CXqDQ6je\/bab6e6e1-0ef9-3778-89fb-8d755557756d\/05-09\u5f85\u5f00\u53d1.docx","orig_name":"05-09\u5f85\u5f00\u53d1.docx"}}]}],"contractScans":[{"id":32865,"object_type":105,"object_id":3822,"attachment_id":24524,"attachment":{"id":24524,"key":24524,"name":"37854557-1bde-3e35-9929-0b57b7857c3f","extension":"pdf","path":"\/v2\/attachment\/preview\/GWtUzjYcC0dtywXjcMjkzgu5CXqDQ6je\/37854557-1bde-3e35-9929-0b57b7857c3f\/2025_03_12_13_58_48.pdf","orig_name":"2025_03_12_13_58_48.pdf"}}],"receiptScans":[],"verifyScans":[],"unreadComments":null,"collected_plan":2500,"projectProductTotalAmount":2500,"projectProductAllAmount":true,"projectProductTotalCost":0,"projectProductAllCost":true,"projectProductTotalCount":1,"invoiced":2501,"un_invoiced":-1,"collected":0,"un_collected":2500,"is_collected":false,"handlerPerson":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91","avatar":{"id":141,"user_id":5300,"name":"\/files\/cdn\/a57be577deb434\/avatar\/14dfd1a0-6df5-354a-8afd-f0a76fa8e852.png"}},"remind_date":"","remind_ahead_display":"\u65e0","expire_remind_ahead_display":"\u65e0","payment_collection_remind_ahead_display":"\u63d0\u524d7\u5929","can_update":false,"can_delete":false,"unread":0,"bgcolor":"#89c541","can_view_product":true,"can_progress":true},{"id":3816,"client_id":12,"signed_at":"2025-03-06","amount":"511","handler":5300,"description":"","created_by":5300,"created_at":"2025-03-06 19:44:56","updated_at":"2025-03-14 17:29:50","contract_scan":null,"receipt_scan":null,"contract_type":1,"project_id":3794,"valid_date":null,"expire_date":"2026-03-05","sla":"","remind_ahead":"","expire_remind_ahead":"","expire_reminded":false,"serial_no":"SMC\u5317\u4eac\u8ba2\u5355POBJ25031110","payment_collection_remind_ahead":"1 day","from_project":3794,"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-03-06 19:45:22.44096+08","b_date":223,"passed":2,"client":{"id":12,"key":12,"name":"smc(\u4e2d\u56fd)\u6709\u9650\u516c\u53f8\/SMC(\u5317\u4eac)\u5236\u9020\u6709\u9650\u516c\u53f8","logo":null,"sales_rep":5300,"salesRep":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91","avatar":{"id":141,"user_id":5300,"name":"\/files\/cdn\/a57be577deb434\/avatar\/14dfd1a0-6df5-354a-8afd-f0a76fa8e852.png"}}},"contractScan":null,"receiptScan":null,"createdBy":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91","sex":"F","department_id":1,"avatar":{"id":141,"user_id":5300,"name":"\/files\/cdn\/a57be577deb434\/avatar\/14dfd1a0-6df5-354a-8afd-f0a76fa8e852.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"commentCount":{"object_id":3816,"comment":6},"project":{"id":3794,"key":3794,"name":"POBJ25031110-\u56fa\u6001\u786c\u76d8-G-2025"},"fromProject":{"id":3794,"key":3794,"name":"POBJ25031110-\u56fa\u6001\u786c\u76d8-G-2025","description":"","total_contact_point":null,"paid_contact_point":null,"is_sales_order_ready":true,"project_product_version_id":800,"bargain_date":"2025-03-06","collected":"0","profit_pct":"41.41","budget":"511","projectProductTypes":[{"id":6105,"product_type_id":2,"key":2,"name":"\u670d\u52a1\u5668","budget":"511.00","pct":"41.41","project_id":3794,"profit":"211.6051"}],"projectProductRels":[{"id":8996,"project_id":3794,"product_id":1770,"amount":"511.00","number":1,"cost":"256.00","description":"","supplier_id":608,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null,"total_amount":"511","total_cost":"256","supplier":{"id":608,"key":608,"name":"\u6dd8\u5b9d\u7f51"},"product":{"id":1770,"name":"BG5 512G 2230 PCIE4.0NVME\u56fa\u6001\u786c\u76d8","product_type":11,"product_component":179,"product_brand":43,"product_serie":1495,"product_misc":null,"product_qa":null,"pn":"","description":"","created_by":1013,"created_at":"2024-08-29 14:10:56","updated_at":"2024-08-29 14:10:56","pinyin_shortcut":"BG5512G2230PCIE40NVMEgtyp","product_unit":3,"is_renew":false,"productType":{"id":11,"key":11,"name":"\u4e2a\u4eba\u8ba1\u7b97\u673a"},"productComponent":{"id":179,"key":179,"name":"\u914d\u4ef6"},"productBrand":{"id":43,"key":43,"name":"\u4e1c\u829d"},"productSerie":{"id":1495,"key":1495,"name":"\u4e1c\u829d BG5 512G 2230 PCIE4.0NVME\u56fa\u6001\u786c\u76d8"},"productUnit":{"id":3,"key":3,"name":"\u4e2a"}}}],"projectContactPoints":[],"buildSalesOrderItems":[{"id":12709,"project_id":3794}],"reimbursementAmountSum":null,"profit":211.6051,"contact_points_status_display":"\u672a\u8bbe\u7f6e"},"salesSupplierRels":[{"id":2505,"contract_id":3816,"supplier_id":608,"purchase_id":3819,"supplier":{"id":608,"key":608,"name":"\u6dd8\u5b9d\u7f51"},"purchase":{"id":3819,"key":3819,"serial_no":"\u8ba2\u5355\u53f7: 4256424362229592710"}}],"contractType":{"id":1,"key":1,"name":"\u4ea7\u54c1\u9500\u552e"},"handleBy":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91","sex":"F","department_id":1,"avatar":{"id":141,"user_id":5300,"name":"\/files\/cdn\/a57be577deb434\/avatar\/14dfd1a0-6df5-354a-8afd-f0a76fa8e852.png"}},"remindDate":null,"serviceContractRemindDates":[],"salesContractRemindReceivers":[],"serviceContractRemindReceivers":[],"salesContractPaymentCollectionRemindReceivers":[{"id":8047,"user_id":5300,"key":5300,"contract_id":3816,"user":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91","sex":"F","avatar":{"id":141,"user_id":5300,"name":"\/files\/cdn\/a57be577deb434\/avatar\/14dfd1a0-6df5-354a-8afd-f0a76fa8e852.png"}}},{"id":8048,"user_id":5388,"key":5388,"contract_id":3816,"user":{"id":5388,"key":5388,"name":"\u6768\u71d5\u971e","sex":"F","avatar":{"id":156,"user_id":5388,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b8d4f68f-e736-3c38-9e2f-1ab47885b3d8.png"}}},{"id":8049,"user_id":1001,"key":1001,"contract_id":3816,"user":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}}}],"salesContractPaymentCollectionRemindDates":[{"id":2356,"key":2356,"contract_id":3816,"name":"2025-04-18","value":"511","overdue_days":null,"pct":100,"collect_status":"\u903e\u671f98\u5929"}],"salesContractPayments":[],"salesContractInvoices":[],"contractScans":[{"id":32908,"object_type":105,"object_id":3816,"attachment_id":24526,"attachment":{"id":24526,"key":24526,"name":"9748514a-8585-353f-bfcf-d5f7c3e95cdf","extension":"pdf","path":"\/v2\/attachment\/preview\/GWtUzjYcC0dtywXjcMjkzgu5CXqDQ6je\/9748514a-8585-353f-bfcf-d5f7c3e95cdf\/POBJ25031110.pdf","orig_name":"POBJ25031110.pdf"}}],"receiptScans":[{"id":32906,"object_type":106,"object_id":3816,"attachment_id":24560,"attachment":{"id":24560,"key":24560,"name":"58432bf9-3e54-36b5-8fe6-fdec985e30f6","extension":"pdf","path":"\/v2\/attachment\/preview\/GWtUzjYcC0dtywXjcMjkzgu5CXqDQ6je\/58432bf9-3e54-36b5-8fe6-fdec985e30f6\/2025_03_14_15_33_53.pdf","orig_name":"2025_03_14_15_33_53.pdf"}}],"verifyScans":[],"unreadComments":null,"collected_plan":511,"projectProductTotalAmount":511,"projectProductAllAmount":true,"projectProductTotalCost":256,"projectProductAllCost":true,"projectProductTotalCount":1,"invoiced":0,"un_invoiced":511,"collected":0,"un_collected":511,"is_collected":false,"handlerPerson":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91","avatar":{"id":141,"user_id":5300,"name":"\/files\/cdn\/a57be577deb434\/avatar\/14dfd1a0-6df5-354a-8afd-f0a76fa8e852.png"}},"remind_date":"","remind_ahead_display":"\u65e0","expire_remind_ahead_display":"\u65e0","payment_collection_remind_ahead_display":"\u63d0\u524d1\u5929","can_update":false,"can_delete":false,"unread":0,"bgcolor":"#89c541","can_view_product":true,"can_progress":true},{"id":3811,"client_id":531,"signed_at":"2025-03-05","amount":"3150","handler":5300,"description":"","created_by":5300,"created_at":"2025-03-05 17:28:13","updated_at":"2025-03-12 13:59:08","contract_scan":null,"receipt_scan":null,"contract_type":1,"project_id":3791,"valid_date":null,"expire_date":null,"sla":"","remind_ahead":"","expire_remind_ahead":"","expire_reminded":false,"serial_no":"TS-SQY-20250305001","payment_collection_remind_ahead":"","from_project":3791,"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-03-05 17:28:35.841072+08","b_date":null,"passed":1,"client":{"id":531,"key":531,"name":"\u5317\u4eac\u9996\u4e1c\u7269\u4e1a\u7ba1\u7406\u6709\u9650\u516c\u53f8(\u9996\u4e1c\u56fd\u9645\u6295\u8d44\u6709\u9650\u516c\u53f8)","logo":null,"sales_rep":5311,"salesRep":{"id":5311,"key":5311,"name":"\u62d3\u5c0f\u6587","avatar":{"id":149,"user_id":5311,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1a32eee2-9465-3c88-9077-5c6d1cc5e8b3.jpg"}}},"contractScan":null,"receiptScan":null,"createdBy":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91","sex":"F","department_id":1,"avatar":{"id":141,"user_id":5300,"name":"\/files\/cdn\/a57be577deb434\/avatar\/14dfd1a0-6df5-354a-8afd-f0a76fa8e852.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"commentCount":{"object_id":3811,"comment":8},"project":{"id":3791,"key":3791,"name":"\u786c\u76d81.8T1\u5757-K-2025"},"fromProject":{"id":3791,"key":3791,"name":"\u786c\u76d81.8T1\u5757-K-2025","description":"","total_contact_point":"880","paid_contact_point":"880","is_sales_order_ready":true,"project_product_version_id":797,"bargain_date":"2025-03-05","collected":"3150","profit_pct":"16.97","budget":"3150","projectProductTypes":[{"id":6097,"product_type_id":2,"key":2,"name":"\u670d\u52a1\u5668","budget":"3150.00","pct":"16.97","project_id":3791,"profit":"534.555"}],"projectProductRels":[{"id":8988,"project_id":3791,"product_id":542,"amount":"3150.00","number":1,"cost":"1300.00","description":"","supplier_id":678,"hardware_from":"2025-03-05","software_from":null,"maintenance_from":null,"hardware_to":"2025-03-06","software_to":null,"maintenance_to":null,"total_amount":"3150","total_cost":"1300","supplier":{"id":678,"key":678,"name":"\u5317\u4eac\u667a\u9886\u8d8b\u52bf\u79d1\u6280\u6709\u9650\u516c\u53f8"},"product":{"id":542,"name":"00YK017","product_type":2,"product_component":5,"product_brand":4,"product_serie":1198,"product_misc":8,"product_qa":null,"pn":"","description":"","created_by":1013,"created_at":"2019-01-04 15:33:52","updated_at":"2024-11-20 14:45:21","pinyin_shortcut":"00YK017","product_unit":4,"is_renew":false,"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":1198,"key":1198,"name":"1.8T 10K 2.5 SAS \u786c\u76d8"},"productUnit":{"id":4,"key":4,"name":"\u5757"}}}],"projectContactPoints":[{"id":910,"project_id":3791,"contact_id":1188,"point":"880.00","paid_point":"880","contact":{"id":1188,"key":1188,"name":"\u5f20\u9a70","client_id":531,"supplier_id":null,"client":{"id":531,"key":531,"name":"\u5317\u4eac\u9996\u4e1c\u7269\u4e1a\u7ba1\u7406\u6709\u9650\u516c\u53f8(\u9996\u4e1c\u56fd\u9645\u6295\u8d44\u6709\u9650\u516c\u53f8)"},"supplier":null},"projectContactPointRels":[{"id":172,"project_id":3791,"contact_id":1188,"point":"880.00","day_at":"2025-03-12","description":"","created_at":"2025-03-12 13:59:08"}],"status_display":"\u5df2\u6838\u9500"}],"buildSalesOrderItems":[{"id":12702,"project_id":3791}],"reimbursementAmountSum":null,"profit":534.555,"contact_points_status_display":"\u5df2\u6838\u9500"},"salesSupplierRels":[{"id":2499,"contract_id":3811,"supplier_id":678,"purchase_id":3814,"supplier":{"id":678,"key":678,"name":"\u5317\u4eac\u667a\u9886\u8d8b\u52bf\u79d1\u6280\u6709\u9650\u516c\u53f8"},"purchase":{"id":3814,"key":3814,"serial_no":"YTYG20250306"}}],"contractType":{"id":1,"key":1,"name":"\u4ea7\u54c1\u9500\u552e"},"handleBy":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91","sex":"F","department_id":1,"avatar":{"id":141,"user_id":5300,"name":"\/files\/cdn\/a57be577deb434\/avatar\/14dfd1a0-6df5-354a-8afd-f0a76fa8e852.png"}},"remindDate":null,"serviceContractRemindDates":[],"salesContractRemindReceivers":[{"id":8353,"user_id":5311,"key":5311,"contract_id":3811,"user":{"id":5311,"key":5311,"name":"\u62d3\u5c0f\u6587","sex":"F","avatar":{"id":149,"user_id":5311,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1a32eee2-9465-3c88-9077-5c6d1cc5e8b3.jpg"}}}],"serviceContractRemindReceivers":[],"salesContractPaymentCollectionRemindReceivers":[{"id":8032,"user_id":5300,"key":5300,"contract_id":3811,"user":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91","sex":"F","avatar":{"id":141,"user_id":5300,"name":"\/files\/cdn\/a57be577deb434\/avatar\/14dfd1a0-6df5-354a-8afd-f0a76fa8e852.png"}}},{"id":8033,"user_id":5388,"key":5388,"contract_id":3811,"user":{"id":5388,"key":5388,"name":"\u6768\u71d5\u971e","sex":"F","avatar":{"id":156,"user_id":5388,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b8d4f68f-e736-3c38-9e2f-1ab47885b3d8.png"}}},{"id":8034,"user_id":1001,"key":1001,"contract_id":3811,"user":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}}}],"salesContractPaymentCollectionRemindDates":[{"id":2353,"key":2353,"contract_id":3811,"name":"2025-03-21","value":"3150","overdue_days":null,"pct":100,"collect_status":"\u5df2\u5b8c\u6210"}],"salesContractPayments":[{"id":2131,"key":2131,"contract_id":3811,"value":"3150","created_by":1013,"created_at":"2025-03-10 11:16:35","description":"","collected_date":"2025-03-10","amount":"3150","createdBy":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","department_id":7},"files":[{"id":32762,"object_type":109,"object_id":2131,"attachment_id":24457,"attachment":{"id":24457,"key":24457,"name":"ebc27b61-a8f1-3743-a4db-9d0eb0fd512c","extension":"png","path":"\/v2\/attachment\/view\/GWtUzjYcC0dtywXjcMjkzgu5CXqDQ6je\/ebc27b61-a8f1-3743-a4db-9d0eb0fd512c\/image.png","orig_name":"image.png"}}],"pct":100}],"salesContractInvoices":[{"id":1971,"key":1971,"contract_id":3811,"value":"3150.00","attachment_id":null,"from_date":"2025-03-07","attachment":null,"attachmentRelationships":[],"files":[{"id":32726,"object_type":102,"object_id":1971,"attachment_id":24432,"attachment":{"id":24432,"key":24432,"name":"dff9deda-3114-397c-95f4-432d3284169a","extension":"pdf","path":"\/v2\/attachment\/view\/GWtUzjYcC0dtywXjcMjkzgu5CXqDQ6je\/dff9deda-3114-397c-95f4-432d3284169a\/dzfp_25112000000045420958_\u5317\u4eac\u9996\u4e1c\u56fd\u9645\u6295\u8d44\u6709\u9650\u516c\u53f8_20250307094835.pdf","orig_name":"dzfp_25112000000045420958_\u5317\u4eac\u9996\u4e1c\u56fd\u9645\u6295\u8d44\u6709\u9650\u516c\u53f8_20250307094835.pdf"}}]},{"id":1978,"key":1978,"contract_id":3811,"value":"-3150.00","attachment_id":null,"from_date":"2025-03-14","attachment":null,"attachmentRelationships":[],"files":[{"id":32884,"object_type":102,"object_id":1978,"attachment_id":24541,"attachment":{"id":24541,"key":24541,"name":"38801acf-9469-312a-8a19-cb4c57246891","extension":"pdf","path":"\/v2\/attachment\/view\/GWtUzjYcC0dtywXjcMjkzgu5CXqDQ6je\/38801acf-9469-312a-8a19-cb4c57246891\/dzfp_25112000000049433908_\u5317\u4eac\u9996\u4e1c\u56fd\u9645\u6295\u8d44\u6709\u9650\u516c\u53f8_20250314101729.pdf","orig_name":"dzfp_25112000000049433908_\u5317\u4eac\u9996\u4e1c\u56fd\u9645\u6295\u8d44\u6709\u9650\u516c\u53f8_20250314101729.pdf"}}]},{"id":1979,"key":1979,"contract_id":3811,"value":"3150.00","attachment_id":null,"from_date":"2025-03-14","attachment":null,"attachmentRelationships":[],"files":[{"id":32899,"object_type":102,"object_id":1979,"attachment_id":24542,"attachment":{"id":24542,"key":24542,"name":"4974f2a1-62b1-32e9-ac1c-15fc300eb35c","extension":"pdf","path":"\/v2\/attachment\/view\/GWtUzjYcC0dtywXjcMjkzgu5CXqDQ6je\/4974f2a1-62b1-32e9-ac1c-15fc300eb35c\/dzfp_25112000000050933384_\u5317\u4eac\u9996\u4e1c\u56fd\u9645\u6295\u8d44\u6709\u9650\u516c\u53f8_20250314101355.pdf","orig_name":"dzfp_25112000000050933384_\u5317\u4eac\u9996\u4e1c\u56fd\u9645\u6295\u8d44\u6709\u9650\u516c\u53f8_20250314101355.pdf"}}]}],"contractScans":[{"id":32858,"object_type":105,"object_id":3811,"attachment_id":24403,"attachment":{"id":24403,"key":24403,"name":"6cc3b4ca-81f0-31e8-acd4-7f33b1c59fe9","extension":"pdf","path":"\/v2\/attachment\/preview\/GWtUzjYcC0dtywXjcMjkzgu5CXqDQ6je\/6cc3b4ca-81f0-31e8-acd4-7f33b1c59fe9\/2025.3.5\u62d3\u5b9e\u79d1\u6280\u786c\u76d8.pdf","orig_name":"2025.3.5\u62d3\u5b9e\u79d1\u6280\u786c\u76d8.pdf"}}],"receiptScans":[],"verifyScans":[],"unreadComments":null,"collected_plan":3150,"projectProductTotalAmount":3150,"projectProductAllAmount":true,"projectProductTotalCost":1300,"projectProductAllCost":true,"projectProductTotalCount":1,"invoiced":3150,"un_invoiced":0,"collected":3150,"un_collected":0,"is_collected":true,"handlerPerson":{"id":5311,"key":5311,"name":"\u62d3\u5c0f\u6587","avatar":{"id":149,"user_id":5311,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1a32eee2-9465-3c88-9077-5c6d1cc5e8b3.jpg"}},"remind_date":"","remind_ahead_display":"\u65e0","expire_remind_ahead_display":"\u65e0","payment_collection_remind_ahead_display":"\u65e0","can_update":false,"can_delete":false,"unread":0,"bgcolor":"#89c541","can_view_product":true,"can_progress":true},{"id":3809,"client_id":4,"signed_at":"2025-03-04","amount":"1700","handler":5300,"description":"","created_by":5300,"created_at":"2025-03-05 14:27:35","updated_at":"2025-03-14 15:19:55","contract_scan":null,"receipt_scan":null,"contract_type":1,"project_id":3789,"valid_date":null,"expire_date":null,"sla":"","remind_ahead":"","expire_remind_ahead":"","expire_reminded":false,"serial_no":"TS-SQY-20250304002","payment_collection_remind_ahead":"1 day","from_project":3789,"receipt_date":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-11 11:23:01.426167+08","b_date":null,"passed":1,"client":{"id":4,"key":4,"name":"\u6cb3\u5317\u9ad8\u7891\u5e97\u5e02\u5b9c\u4f73\u65fa\u5546\u8d38\u6709\u9650\u516c\u53f8\/\u6cb3\u5317\u5c1a\u548c\u5546\u8d38\u6709\u9650\u516c\u53f8","logo":null,"sales_rep":5300,"salesRep":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91","avatar":{"id":141,"user_id":5300,"name":"\/files\/cdn\/a57be577deb434\/avatar\/14dfd1a0-6df5-354a-8afd-f0a76fa8e852.png"}}},"contractScan":null,"receiptScan":null,"createdBy":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91","sex":"F","department_id":1,"avatar":{"id":141,"user_id":5300,"name":"\/files\/cdn\/a57be577deb434\/avatar\/14dfd1a0-6df5-354a-8afd-f0a76fa8e852.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"commentCount":{"object_id":3809,"comment":13},"project":{"id":3789,"key":3789,"name":"\u7535\u6e90-netapp-FAS2240-2\u5757-G-2025"},"fromProject":{"id":3789,"key":3789,"name":"\u7535\u6e90-netapp-FAS2240-2\u5757-G-2025","description":"","total_contact_point":null,"paid_contact_point":null,"is_sales_order_ready":true,"project_product_version_id":796,"bargain_date":"2025-03-04","collected":"1700","profit_pct":"33.82","budget":"1700","projectProductTypes":[{"id":6083,"product_type_id":3,"key":3,"name":"\u5b58\u50a8\u8bbe\u5907","budget":"1700.00","pct":"33.82","project_id":3789,"profit":"574.94"}],"projectProductRels":[{"id":8959,"project_id":3789,"product_id":1954,"amount":"850.00","number":2,"cost":"500.00","description":"","supplier_id":489,"hardware_from":"2025-03-06","software_from":null,"maintenance_from":null,"hardware_to":"2026-03-05","software_to":null,"maintenance_to":null,"total_amount":"1700","total_cost":"1000","supplier":{"id":489,"key":489,"name":"\u5317\u4eac\u6234\u68ee\u7279\u7cfb\u7edf\u79d1\u6280\u6709\u9650\u516c\u53f8"},"product":{"id":1954,"name":"114-00087+C0","product_type":3,"product_component":39,"product_brand":6,"product_serie":1608,"product_misc":null,"product_qa":null,"pn":"","description":"NetApp FAS2XXX 750W\u7535\u6e90","created_by":1013,"created_at":"2025-03-06 10:01:07","updated_at":"2025-03-07 17:56:13","pinyin_shortcut":"11400087C0","product_unit":3,"is_renew":false,"productType":{"id":3,"key":3,"name":"\u5b58\u50a8\u8bbe\u5907"},"productComponent":{"id":39,"key":39,"name":"\u5b58\u50a8\u914d\u4ef6"},"productBrand":{"id":6,"key":6,"name":"NetAPP"},"productSerie":{"id":1608,"key":1608,"name":"NetApp FAS\u7cfb\u5217\u7535\u6e90"},"productUnit":{"id":3,"key":3,"name":"\u4e2a"}}}],"projectContactPoints":[],"buildSalesOrderItems":[{"id":12701,"project_id":3789},{"id":12700,"project_id":3789}],"reimbursementAmountSum":null,"profit":574.94,"contact_points_status_display":"\u672a\u8bbe\u7f6e"},"salesSupplierRels":[{"id":2483,"contract_id":3809,"supplier_id":489,"purchase_id":3810,"supplier":{"id":489,"key":489,"name":"\u5317\u4eac\u6234\u68ee\u7279\u7cfb\u7edf\u79d1\u6280\u6709\u9650\u516c\u53f8"},"purchase":{"id":3810,"key":3810,"serial_no":"TSKJ20250305-HYF-001"}}],"contractType":{"id":1,"key":1,"name":"\u4ea7\u54c1\u9500\u552e"},"handleBy":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91","sex":"F","department_id":1,"avatar":{"id":141,"user_id":5300,"name":"\/files\/cdn\/a57be577deb434\/avatar\/14dfd1a0-6df5-354a-8afd-f0a76fa8e852.png"}},"remindDate":null,"serviceContractRemindDates":[],"salesContractRemindReceivers":[],"serviceContractRemindReceivers":[],"salesContractPaymentCollectionRemindReceivers":[{"id":8179,"user_id":5300,"key":5300,"contract_id":3809,"user":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91","sex":"F","avatar":{"id":141,"user_id":5300,"name":"\/files\/cdn\/a57be577deb434\/avatar\/14dfd1a0-6df5-354a-8afd-f0a76fa8e852.png"}}},{"id":8180,"user_id":5388,"key":5388,"contract_id":3809,"user":{"id":5388,"key":5388,"name":"\u6768\u71d5\u971e","sex":"F","avatar":{"id":156,"user_id":5388,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b8d4f68f-e736-3c38-9e2f-1ab47885b3d8.png"}}},{"id":8181,"user_id":1001,"key":1001,"contract_id":3809,"user":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}}}],"salesContractPaymentCollectionRemindDates":[{"id":2395,"key":2395,"contract_id":3809,"name":"2025-04-05","value":"22","overdue_days":null,"pct":1.29,"collect_status":"\u5df2\u5b8c\u6210"}],"salesContractPayments":[{"id":2126,"key":2126,"contract_id":3809,"value":"1700","created_by":1013,"created_at":"2025-03-06 17:01:07","description":"","collected_date":"2025-03-06","amount":"1700","createdBy":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","department_id":7},"files":[{"id":32710,"object_type":109,"object_id":2126,"attachment_id":24423,"attachment":{"id":24423,"key":24423,"name":"0c22f727-6df7-34c6-bfd0-59d1f045e855","extension":"png","path":"\/v2\/attachment\/view\/GWtUzjYcC0dtywXjcMjkzgu5CXqDQ6je\/0c22f727-6df7-34c6-bfd0-59d1f045e855\/image.png","orig_name":"image.png"}}],"pct":100}],"salesContractInvoices":[{"id":1966,"key":1966,"contract_id":3809,"value":"1700.00","attachment_id":null,"from_date":"2025-03-06","attachment":null,"attachmentRelationships":[],"files":[{"id":32694,"object_type":102,"object_id":1966,"attachment_id":24410,"attachment":{"id":24410,"key":24410,"name":"a4330a1f-28f4-38a3-bfbe-bbc2098216d0","extension":"pdf","path":"\/v2\/attachment\/view\/GWtUzjYcC0dtywXjcMjkzgu5CXqDQ6je\/a4330a1f-28f4-38a3-bfbe-bbc2098216d0\/dzfp_25112000000044491568_\u9ad8\u7891\u5e97\u5e02\u5b9c\u4f73\u65fa\u5546\u8d38\u6709\u9650\u516c\u53f8_20250306094839.pdf","orig_name":"dzfp_25112000000044491568_\u9ad8\u7891\u5e97\u5e02\u5b9c\u4f73\u65fa\u5546\u8d38\u6709\u9650\u516c\u53f8_20250306094839.pdf"}}]},{"id":1967,"key":1967,"contract_id":3809,"value":"-1700.00","attachment_id":null,"from_date":"2025-03-06","attachment":null,"attachmentRelationships":[],"files":[{"id":32703,"object_type":102,"object_id":1967,"attachment_id":24414,"attachment":{"id":24414,"key":24414,"name":"be19ac71-09f3-3e33-90d2-308672c89ce8","extension":"pdf","path":"\/v2\/attachment\/view\/GWtUzjYcC0dtywXjcMjkzgu5CXqDQ6je\/be19ac71-09f3-3e33-90d2-308672c89ce8\/dzfp_25112000000041307165_\u9ad8\u7891\u5e97\u5e02\u5b9c\u4f73\u65fa\u5546\u8d38\u6709\u9650\u516c\u53f8_20250306103155.pdf","orig_name":"dzfp_25112000000041307165_\u9ad8\u7891\u5e97\u5e02\u5b9c\u4f73\u65fa\u5546\u8d38\u6709\u9650\u516c\u53f8_20250306103155.pdf"}}]},{"id":1970,"key":1970,"contract_id":3809,"value":"1700.00","attachment_id":null,"from_date":"2025-03-06","attachment":null,"attachmentRelationships":[],"files":[{"id":32712,"object_type":102,"object_id":1970,"attachment_id":24425,"attachment":{"id":24425,"key":24425,"name":"0e2c262e-35c3-3878-855c-67cbe745a6a4","extension":"pdf","path":"\/v2\/attachment\/view\/GWtUzjYcC0dtywXjcMjkzgu5CXqDQ6je\/0e2c262e-35c3-3878-855c-67cbe745a6a4\/dzfp_25112000000044479475_\u9ad8\u7891\u5e97\u5e02\u5b9c\u4f73\u65fa\u5546\u8d38\u6709\u9650\u516c\u53f8_20250306102849.pdf","orig_name":"dzfp_25112000000044479475_\u9ad8\u7891\u5e97\u5e02\u5b9c\u4f73\u65fa\u5546\u8d38\u6709\u9650\u516c\u53f8_20250306102849.pdf"}}]}],"contractScans":[{"id":32904,"object_type":105,"object_id":3809,"attachment_id":24558,"attachment":{"id":24558,"key":24558,"name":"ae0ec17f-0550-3439-8e8e-b4cf2f6a51e9","extension":"pdf","path":"\/v2\/attachment\/preview\/GWtUzjYcC0dtywXjcMjkzgu5CXqDQ6je\/ae0ec17f-0550-3439-8e8e-b4cf2f6a51e9\/\u9ad8\u7891\u5e97.pdf","orig_name":"\u9ad8\u7891\u5e97.pdf"}}],"receiptScans":[],"verifyScans":[],"unreadComments":null,"collected_plan":22,"projectProductTotalAmount":1700,"projectProductAllAmount":true,"projectProductTotalCost":1000,"projectProductAllCost":true,"projectProductTotalCount":2,"invoiced":1700,"un_invoiced":0,"collected":1700,"un_collected":0,"is_collected":true,"handlerPerson":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91","avatar":{"id":141,"user_id":5300,"name":"\/files\/cdn\/a57be577deb434\/avatar\/14dfd1a0-6df5-354a-8afd-f0a76fa8e852.png"}},"remind_date":"","remind_ahead_display":"\u65e0","expire_remind_ahead_display":"\u65e0","payment_collection_remind_ahead_display":"\u63d0\u524d1\u5929","can_update":false,"can_delete":false,"unread":0,"bgcolor":"#89c541","can_view_product":true,"can_progress":true},{"id":3792,"client_id":12,"signed_at":"2025-02-24","amount":"629","handler":5300,"description":"","created_by":5300,"created_at":"2025-02-24 11:47:14","updated_at":"2025-03-11 10:58:26","contract_scan":null,"receipt_scan":null,"contract_type":1,"project_id":3782,"valid_date":null,"expire_date":null,"sla":"","remind_ahead":"","expire_remind_ahead":"","expire_reminded":false,"serial_no":"SMC\u5317\u4eac\u8ba2\u5355POBJ25024486","payment_collection_remind_ahead":"7 days","from_project":3782,"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-24 11:47:14.087116+08","b_date":null,"passed":1,"client":{"id":12,"key":12,"name":"smc(\u4e2d\u56fd)\u6709\u9650\u516c\u53f8\/SMC(\u5317\u4eac)\u5236\u9020\u6709\u9650\u516c\u53f8","logo":null,"sales_rep":5300,"salesRep":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91","avatar":{"id":141,"user_id":5300,"name":"\/files\/cdn\/a57be577deb434\/avatar\/14dfd1a0-6df5-354a-8afd-f0a76fa8e852.png"}}},"contractScan":null,"receiptScan":null,"createdBy":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91","sex":"F","department_id":1,"avatar":{"id":141,"user_id":5300,"name":"\/files\/cdn\/a57be577deb434\/avatar\/14dfd1a0-6df5-354a-8afd-f0a76fa8e852.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"commentCount":{"object_id":3792,"comment":5},"project":{"id":3782,"key":3782,"name":"POBJ25024486-\u56fa\u6001\u786c\u76d8-G-2025"},"fromProject":{"id":3782,"key":3782,"name":"POBJ25024486-\u56fa\u6001\u786c\u76d8-G-2025","description":"","total_contact_point":null,"paid_contact_point":null,"is_sales_order_ready":true,"project_product_version_id":782,"bargain_date":"2025-02-24","collected":"0","profit_pct":"11.69","budget":"629","projectProductTypes":[{"id":6029,"product_type_id":2,"key":2,"name":"\u670d\u52a1\u5668","budget":"629.00","pct":"11.69","project_id":3782,"profit":"73.5301"}],"projectProductRels":[{"id":8863,"project_id":3782,"product_id":1689,"amount":"629.00","number":1,"cost":"530.00","description":"","supplier_id":505,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null,"total_amount":"629","total_cost":"530","supplier":{"id":505,"key":505,"name":"\u795e\u5dde\u6167\u667a\uff08\u5317\u4eac\uff09\u79d1\u6280\u6709\u9650\u516c\u53f8\/\u5317\u4eac\u795e\u5dde\u540c\u6b63\u8ba1\u7b97\u673a\u8bbe\u5907\u6709\u9650\u516c\u53f8"},"product":{"id":1689,"name":"PM991A 1TB M.2 2230 NVMe","product_type":11,"product_component":179,"product_brand":10,"product_serie":1437,"product_misc":null,"product_qa":null,"pn":"","description":"","created_by":1013,"created_at":"2024-07-25 17:42:48","updated_at":"2024-07-25 17:42:48","pinyin_shortcut":"PM991A1TBM22230NVMe","product_unit":3,"is_renew":false,"productType":{"id":11,"key":11,"name":"\u4e2a\u4eba\u8ba1\u7b97\u673a"},"productComponent":{"id":179,"key":179,"name":"\u914d\u4ef6"},"productBrand":{"id":10,"key":10,"name":"\u4e09\u661f"},"productSerie":{"id":1437,"key":1437,"name":"\u4e09\u661f M.2 NVME 2230 SSD 1T\u56fa\u6001\u786c\u76d8"},"productUnit":{"id":3,"key":3,"name":"\u4e2a"}}}],"projectContactPoints":[],"buildSalesOrderItems":[{"id":12671,"project_id":3782}],"reimbursementAmountSum":null,"profit":73.5301,"contact_points_status_display":"\u672a\u8bbe\u7f6e"},"salesSupplierRels":[{"id":2444,"contract_id":3792,"supplier_id":505,"purchase_id":3793,"supplier":{"id":505,"key":505,"name":"\u795e\u5dde\u6167\u667a\uff08\u5317\u4eac\uff09\u79d1\u6280\u6709\u9650\u516c\u53f8\/\u5317\u4eac\u795e\u5dde\u540c\u6b63\u8ba1\u7b97\u673a\u8bbe\u5907\u6709\u9650\u516c\u53f8"},"purchase":{"id":3793,"key":3793,"serial_no":""}}],"contractType":{"id":1,"key":1,"name":"\u4ea7\u54c1\u9500\u552e"},"handleBy":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91","sex":"F","department_id":1,"avatar":{"id":141,"user_id":5300,"name":"\/files\/cdn\/a57be577deb434\/avatar\/14dfd1a0-6df5-354a-8afd-f0a76fa8e852.png"}},"remindDate":null,"serviceContractRemindDates":[],"salesContractRemindReceivers":[],"serviceContractRemindReceivers":[],"salesContractPaymentCollectionRemindReceivers":[{"id":7930,"user_id":5300,"key":5300,"contract_id":3792,"user":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91","sex":"F","avatar":{"id":141,"user_id":5300,"name":"\/files\/cdn\/a57be577deb434\/avatar\/14dfd1a0-6df5-354a-8afd-f0a76fa8e852.png"}}},{"id":7931,"user_id":5388,"key":5388,"contract_id":3792,"user":{"id":5388,"key":5388,"name":"\u6768\u71d5\u971e","sex":"F","avatar":{"id":156,"user_id":5388,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b8d4f68f-e736-3c38-9e2f-1ab47885b3d8.png"}}},{"id":7932,"user_id":1001,"key":1001,"contract_id":3792,"user":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}}}],"salesContractPaymentCollectionRemindDates":[{"id":2339,"key":2339,"contract_id":3792,"name":"2025-04-11","value":"629","overdue_days":null,"pct":100,"collect_status":"\u903e\u671f105\u5929"}],"salesContractPayments":[],"salesContractInvoices":[],"contractScans":[{"id":32562,"object_type":105,"object_id":3792,"attachment_id":24289,"attachment":{"id":24289,"key":24289,"name":"76c3b687-819a-3e06-96cc-2e36a3034c32","extension":"pdf","path":"\/v2\/attachment\/preview\/GWtUzjYcC0dtywXjcMjkzgu5CXqDQ6je\/76c3b687-819a-3e06-96cc-2e36a3034c32\/POBJ25024486.pdf","orig_name":"POBJ25024486.pdf"}}],"receiptScans":[{"id":32810,"object_type":106,"object_id":3792,"attachment_id":24488,"attachment":{"id":24488,"key":24488,"name":"04eb1aee-ed22-31c0-acc8-a13438cab861","extension":"pdf","path":"\/v2\/attachment\/preview\/GWtUzjYcC0dtywXjcMjkzgu5CXqDQ6je\/04eb1aee-ed22-31c0-acc8-a13438cab861\/2025_03_11_10_57_47.pdf","orig_name":"2025_03_11_10_57_47.pdf"}}],"verifyScans":[],"unreadComments":null,"collected_plan":629,"projectProductTotalAmount":629,"projectProductAllAmount":true,"projectProductTotalCost":530,"projectProductAllCost":true,"projectProductTotalCount":1,"invoiced":0,"un_invoiced":629,"collected":0,"un_collected":629,"is_collected":false,"handlerPerson":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91","avatar":{"id":141,"user_id":5300,"name":"\/files\/cdn\/a57be577deb434\/avatar\/14dfd1a0-6df5-354a-8afd-f0a76fa8e852.png"}},"remind_date":"","remind_ahead_display":"\u65e0","expire_remind_ahead_display":"\u65e0","payment_collection_remind_ahead_display":"\u63d0\u524d7\u5929","can_update":false,"can_delete":false,"unread":0,"bgcolor":"#89c541","can_view_product":true,"can_progress":true},{"id":3795,"client_id":3333,"signed_at":"2025-02-21","amount":"2310000","handler":1005,"description":"","created_by":1005,"created_at":"2025-02-26 10:24:57","updated_at":"2025-02-26 11:58:32","contract_scan":null,"receipt_scan":null,"contract_type":1,"project_id":3783,"valid_date":null,"expire_date":"2028-02-21","sla":"","remind_ahead":"","expire_remind_ahead":"","expire_reminded":false,"serial_no":"TSKJ20250221-ZHY-001","payment_collection_remind_ahead":"1 day","from_project":3783,"receipt_date":null,"verify_date":null,"including_tax":true,"build_by_project":true,"need_analysis":true,"is_settle":false,"is_deliver":false,"is_outbound":false,"is_save_collection":true,"save_collection_at":"2025-02-26 10:24:57.496964+08","b_date":941,"passed":2,"client":{"id":3333,"key":3333,"name":"\u822a\u5929\u56db\u521b\u79d1\u6280\u6709\u9650\u8d23\u4efb\u516c\u53f8\uff08\u8fc7\u5355\uff09","logo":null,"sales_rep":null,"salesRep":null},"contractScan":null,"receiptScan":null,"createdBy":{"id":1005,"key":1005,"name":"\u8d75\u6657\u7131","sex":"F","department_id":1,"avatar":{"id":16,"user_id":1005,"name":"\/files\/cdn\/a57be577deb434\/avatar\/56876dde-37eb-39fc-853a-47eaef6510e5.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"commentCount":{"object_id":3795,"comment":1},"project":{"id":3783,"key":3783,"name":"\u58f9\u8fdb\u5236\u8f6f\u4ef6\u8fc7\u5355"},"fromProject":{"id":3783,"key":3783,"name":"\u58f9\u8fdb\u5236\u8f6f\u4ef6\u8fc7\u5355","description":"","total_contact_point":null,"paid_contact_point":null,"is_sales_order_ready":false,"project_product_version_id":795,"bargain_date":"2025-02-21","collected":"0","profit_pct":"2","budget":"2310000","projectProductTypes":[{"id":6018,"product_type_id":69,"key":69,"name":"\u5907\u4efd","budget":"2310000.00","pct":"2","project_id":3783,"profit":"46200"}],"projectProductRels":[{"id":8916,"project_id":3783,"product_id":1941,"amount":"96000.00","number":3,"cost":"76286.00","description":"","supplier_id":null,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null,"total_amount":"288000","total_cost":"228858","supplier":null,"product":{"id":1941,"name":"UnaDPM3036","product_type":2,"product_component":2,"product_brand":227,"product_serie":1599,"product_misc":null,"product_qa":null,"pn":"","description":"\u786c\u4ef6\u57fa\u7840\u5e73\u53f0\uff1a\n1.\u89c4\u683c\uff1a4U36\u76d8\u4f4d\u673a\u7bb1,\u542b\u5bfc\u8f68 \n2.CPU\uff1a32\u6838\u9cb2\u9e4f920 2.6GHz*2\uff1b \n3.\u5185\u5b58\uff1a128G DDR4 \n4.\u786c\u76d8\uff1aSSD\uff1a960G SSD*2\uff1bSAS\uff1a3.5\u5bf8 7200RPM\/\u8fd1\u7ebf SAS(NL-SAS)*30\uff08\u542b\u786c\u76d8\u67b6\uff09\n5.RAID\u5361\uff1a1G\u7f13\u5b58\u7684\u786cRAID\u5361*1.\u652f\u6301raid0,1,5, 6, 10, 50, 60\uff1b \n6.\u6389\u7535\u4fdd\u62a4\uff1a1G\u9635\u5217\u5361\u5bf9\u5e94\u6389\u7535\u4fdd\u62a4 \n7.\u5197\u4f59\u7535\u6e90\uff1b \n8.\u7f51\u7edc\u63a5\u53e3\uff1a2\u4e2a\u5343\u5146\u7535\u53e3\uff1b\n9.\u786c\u76d8\u4e0d\u8fd4\u8fd8\u670d\u52a1","created_by":1013,"created_at":"2025-02-26 10:58:31","updated_at":"2025-02-26 10:58:31","pinyin_shortcut":"UnaDPM3036","product_unit":1,"is_renew":false,"productType":{"id":2,"key":2,"name":"\u670d\u52a1\u5668"},"productComponent":{"id":2,"key":2,"name":"\u670d\u52a1\u5668\u4e3b\u673a"},"productBrand":{"id":227,"key":227,"name":"\u58f9\u8fdb\u5236"},"productSerie":{"id":1599,"key":1599,"name":"\u58f9\u8fdb\u5236\u670d\u52a1\u5668\u4e3b\u673a"},"productUnit":{"id":1,"key":1,"name":"\u53f0"}}},{"id":8917,"project_id":3783,"product_id":1942,"amount":"2022000.00","number":1,"cost":"1606742.00","description":"","supplier_id":null,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null,"total_amount":"2022000","total_cost":"1606742","supplier":null,"product":{"id":1942,"name":"\u58f9\u8fdb\u5236\u9ed1\u65b9\u5bb9\u707e\u5907\u4efd\u4e0e\u6062\u590d\u7cfb\u7edf\u8f6f\u4ef6 V6","product_type":7,"product_component":30,"product_brand":227,"product_serie":1600,"product_misc":null,"product_qa":null,"pn":"","description":"\"\u8f6f\u4ef6\u57fa\u7840\u5e73\u53f0\uff1a\n64bit \u4f01\u4e1a\u7ea7 Linux \u5185\u6838\uff0c\u57fa\u4e8eWEB \u754c\u9762\u7684\u6570\u636e\u5907\u4efd\u4e0e\u6062\u590d\u7cfb\u7edf \u8f6f\u4ef6\uff0c\u6807\u914d\u6587\u4ef6\/\u6570\u636e\u5e93\n\/Windows\/Linux\/\u865a\u62df\u5316\u5b9a\u65f6\u5907\u4efd\u529f\u80fd\u3002\n\u5bb9\u91cf\u6388\u6743\uff1a\nUnaRDP-1P\uff1a1P \u5b9a\u65f6\u5907\u4efd\u5bb9\u91cf\u6388\u6743\u3002\n\u9ad8\u7ea7\u529f\u80fd\u6388\u6743\uff1a\nUnaDedupe-LIC*3\uff1a3\u4e2a\u91cd\u5220\u529f\u80fd \u6388\u6743\uff0c\u542b\u6e90\u7aef\u548c\u76ee\u6807\u7aef\u91cd\u5220\uff1b\u5b9e \u65f6\u5907\u4efd\u5bb9\u91cf\u4e0d\u652f\u6301\u91cd\u5220\u529f\u80fd\uff1bCDM \u529f\u80fd\u6253\u5f00\u65f6\u4ec5\u652f\u6301\u76ee\u6807\u7aef\u91cd\u5220\u3002\n(\u6ce8\uff1a\u5982\u679c\u9009\u62e9\u91cd\u5220\u529f\u80fd\uff0c\u5fc5\u987b\u589e \u914d RAID \u5361\u6389\u7535\u4fdd\u62a4)\u3002\nUnaD2D2R-LIC*3\uff1a3\u4e2a\u4e24\u53f0\u9ed1\u65b9\u670d \u52a1\u5668\u4e4b\u95f4\u7684\u6570\u636e\u5f02\u5730\u540c\u6b65\u901a\u9053\u6388 \u6743\uff0c\u652f\u6301\u5c06\u672c\u5730\u9ed1\u65b9\u670d\u52a1\u5668\u4e2d\u5907 \u4efd\u6216\u5bb9\u707e\u6570\u636e\u96c6\u540c\u6b65\u81f3\u5f02\u5730\u9ed1\u65b9 \u670d\u52a1\u5668\u3002\u76ee\u7684\u7aef\u53ea\u9700\u786e\u4fdd\u914d\u7f6e\u57fa \u672c\u4ef6\uff0c\u65e0\u9700\u914d\u7f6e\u8fdc\u7a0b\u590d\u5236\u4ee3\u7406\u3002\u8fdc\u7a0b\u590d\u5236\u4ee3\u7406\u6570\u91cf\u7531\u6e90\u7aef\u7ba1\u7406\u63a7 \u5236\u53f0\u7684\u6570\u91cf\u51b3\u5b9a\u3002\"\n","created_by":1013,"created_at":"2025-02-26 11:00:56","updated_at":"2025-02-26 11:00:56","pinyin_shortcut":"yjzhfrzbfyhfxtrjV6","product_unit":2,"is_renew":false,"productType":{"id":7,"key":7,"name":"\u8f6f\u4ef6"},"productComponent":{"id":30,"key":30,"name":"\u5907\u4efd\u8f6f\u4ef6"},"productBrand":{"id":227,"key":227,"name":"\u58f9\u8fdb\u5236"},"productSerie":{"id":1600,"key":1600,"name":"\u58f9\u8fdb\u5236\u9ed1\u65b9\u5bb9\u707e\u5907\u4efd\u4e0e\u6062\u590d\u7cfb\u7edf\u8f6f\u4ef6"},"productUnit":{"id":2,"key":2,"name":"\u5957"}}}],"projectContactPoints":[],"buildSalesOrderItems":[],"reimbursementAmountSum":{"project_id":3783,"sum":"123"},"profit":46200,"contact_points_status_display":"\u672a\u8bbe\u7f6e"},"salesSupplierRels":[{"id":2480,"contract_id":3795,"supplier_id":685,"purchase_id":3821,"supplier":{"id":685,"key":685,"name":"\u5317\u4eac\u4e2d\u73af\u4e00\u94ed\u667a\u80fd\u79d1\u6280\u6709\u9650\u516c\u53f8"},"purchase":{"id":3821,"key":3821,"serial_no":"TSKJ20250305-ZHY-001"}}],"contractType":{"id":1,"key":1,"name":"\u4ea7\u54c1\u9500\u552e"},"handleBy":{"id":1005,"key":1005,"name":"\u8d75\u6657\u7131","sex":"F","department_id":1,"avatar":{"id":16,"user_id":1005,"name":"\/files\/cdn\/a57be577deb434\/avatar\/56876dde-37eb-39fc-853a-47eaef6510e5.png"}},"remindDate":null,"serviceContractRemindDates":[],"salesContractRemindReceivers":[],"serviceContractRemindReceivers":[],"salesContractPaymentCollectionRemindReceivers":[{"id":7914,"user_id":1005,"key":1005,"contract_id":3795,"user":{"id":1005,"key":1005,"name":"\u8d75\u6657\u7131","sex":"F","avatar":{"id":16,"user_id":1005,"name":"\/files\/cdn\/a57be577deb434\/avatar\/56876dde-37eb-39fc-853a-47eaef6510e5.png"}}}],"salesContractPaymentCollectionRemindDates":[{"id":2342,"key":2342,"contract_id":3795,"name":"2025-03-26","value":"693000","overdue_days":null,"pct":30,"collect_status":"\u903e\u671f121\u5929"},{"id":2343,"key":2343,"contract_id":3795,"name":"2025-04-30","value":"1501500","overdue_days":null,"pct":65,"collect_status":"\u903e\u671f86\u5929"},{"id":2344,"key":2344,"contract_id":3795,"name":"2028-02-29","value":"115500","overdue_days":null,"pct":5,"collect_status":""}],"salesContractPayments":[],"salesContractInvoices":[],"contractScans":[{"id":32531,"object_type":105,"object_id":3795,"attachment_id":24293,"attachment":{"id":24293,"key":24293,"name":"98c9d421-1520-342e-92b2-c664cbb76842","extension":"pdf","path":"\/v2\/attachment\/preview\/GWtUzjYcC0dtywXjcMjkzgu5CXqDQ6je\/98c9d421-1520-342e-92b2-c664cbb76842\/\u8d75\u6657\u7131-\u822a\u5929\u56db\u521b-2310000.pdf","orig_name":"\u8d75\u6657\u7131-\u822a\u5929\u56db\u521b-2310000.pdf"}}],"receiptScans":[],"verifyScans":[],"unreadComments":null,"collected_plan":2310000,"projectProductTotalAmount":2310000,"projectProductAllAmount":true,"projectProductTotalCost":1835600,"projectProductAllCost":true,"projectProductTotalCount":4,"invoiced":0,"un_invoiced":2310000,"collected":0,"un_collected":2310000,"is_collected":false,"handlerPerson":null,"remind_date":"","remind_ahead_display":"\u65e0","expire_remind_ahead_display":"\u65e0","payment_collection_remind_ahead_display":"\u63d0\u524d1\u5929","can_update":false,"can_delete":false,"unread":0,"bgcolor":"#89c541","can_view_product":true,"can_progress":true},{"id":3787,"client_id":97,"signed_at":"2025-02-11","amount":"1000","handler":5300,"description":"","created_by":5300,"created_at":"2025-02-17 11:26:46","updated_at":"2025-03-06 09:21:26","contract_scan":null,"receipt_scan":null,"contract_type":2,"project_id":3774,"valid_date":null,"expire_date":null,"sla":"","remind_ahead":"","expire_remind_ahead":"","expire_reminded":false,"serial_no":"TS-SQY-20250211001","payment_collection_remind_ahead":"1 day","from_project":3774,"receipt_date":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-04-19 20:15:21.693887+08","b_date":null,"passed":1,"client":{"id":97,"key":97,"name":"\u534e\u745e\u4e16\u7eaa\u63a7\u80a1\u96c6\u56e2\u6709\u9650\u516c\u53f8(\u5c71\u897f\u534e\u745e\u7164\u4e1a\u6709\u9650\u516c\u53f8)","logo":null,"sales_rep":5300,"salesRep":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91","avatar":{"id":141,"user_id":5300,"name":"\/files\/cdn\/a57be577deb434\/avatar\/14dfd1a0-6df5-354a-8afd-f0a76fa8e852.png"}}},"contractScan":null,"receiptScan":null,"createdBy":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91","sex":"F","department_id":1,"avatar":{"id":141,"user_id":5300,"name":"\/files\/cdn\/a57be577deb434\/avatar\/14dfd1a0-6df5-354a-8afd-f0a76fa8e852.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"commentCount":{"object_id":3787,"comment":6},"project":{"id":3774,"key":3774,"name":"\u6280\u672f\u670d\u52a11\u6b21-G-2025-\u6d4b"},"fromProject":{"id":3774,"key":3774,"name":"\u6280\u672f\u670d\u52a11\u6b21-G-2025-\u6d4b","description":"","total_contact_point":null,"paid_contact_point":null,"is_sales_order_ready":true,"project_product_version_id":780,"bargain_date":"2025-02-11","collected":"1000","profit_pct":"93","budget":"1000","projectProductTypes":[{"id":6134,"product_type_id":2,"key":2,"name":"\u670d\u52a1\u5668","budget":"1000.00","pct":"93","project_id":3774,"profit":"930"}],"projectProductRels":[{"id":8914,"project_id":3774,"product_id":941,"amount":"1000.00","number":1,"cost":"0","description":"","supplier_id":null,"hardware_from":null,"software_from":null,"maintenance_from":"2025-02-11","hardware_to":null,"software_to":null,"maintenance_to":"2025-02-15","total_amount":"1000","total_cost":"0","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":"2023-08-11 16:02:47","pinyin_shortcut":"tsrgjsfw","product_unit":7,"is_renew":false,"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"}}}],"projectContactPoints":[],"buildSalesOrderItems":[{"id":12648,"project_id":3774}],"reimbursementAmountSum":null,"profit":930,"contact_points_status_display":"\u672a\u8bbe\u7f6e"},"salesSupplierRels":[],"contractType":{"id":2,"key":2,"name":"\u8fd0\u7ef4\u670d\u52a1"},"handleBy":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91","sex":"F","department_id":1,"avatar":{"id":141,"user_id":5300,"name":"\/files\/cdn\/a57be577deb434\/avatar\/14dfd1a0-6df5-354a-8afd-f0a76fa8e852.png"}},"remindDate":null,"serviceContractRemindDates":[],"salesContractRemindReceivers":[],"serviceContractRemindReceivers":[],"salesContractPaymentCollectionRemindReceivers":[{"id":7976,"user_id":5300,"key":5300,"contract_id":3787,"user":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91","sex":"F","avatar":{"id":141,"user_id":5300,"name":"\/files\/cdn\/a57be577deb434\/avatar\/14dfd1a0-6df5-354a-8afd-f0a76fa8e852.png"}}},{"id":7977,"user_id":5388,"key":5388,"contract_id":3787,"user":{"id":5388,"key":5388,"name":"\u6768\u71d5\u971e","sex":"F","avatar":{"id":156,"user_id":5388,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b8d4f68f-e736-3c38-9e2f-1ab47885b3d8.png"}}},{"id":7978,"user_id":1001,"key":1001,"contract_id":3787,"user":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}}}],"salesContractPaymentCollectionRemindDates":[{"id":2370,"key":2370,"contract_id":3787,"name":"2025-02-21","value":"1000","overdue_days":null,"pct":100,"collect_status":"\u5df2\u5b8c\u6210"}],"salesContractPayments":[{"id":2109,"key":2109,"contract_id":3787,"value":"1000","created_by":1013,"created_at":"2025-02-17 16:47:04","description":"","collected_date":"2025-02-17","amount":"1000","createdBy":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","department_id":7},"files":[{"id":32347,"object_type":109,"object_id":2109,"attachment_id":24166,"attachment":{"id":24166,"key":24166,"name":"fc835641-8de0-3449-b460-a663b5b519f1","extension":"png","path":"\/v2\/attachment\/view\/GWtUzjYcC0dtywXjcMjkzgu5CXqDQ6je\/fc835641-8de0-3449-b460-a663b5b519f1\/image.png","orig_name":"image.png"}}],"pct":100}],"salesContractInvoices":[{"id":1972,"key":1972,"contract_id":3787,"value":"1000.00","attachment_id":null,"from_date":"2025-03-07","attachment":null,"attachmentRelationships":[],"files":[{"id":32736,"object_type":102,"object_id":1972,"attachment_id":24442,"attachment":{"id":24442,"key":24442,"name":"98d95e6b-f492-3dc2-9aea-d374ce6af1ba","extension":"pdf","path":"\/v2\/attachment\/view\/GWtUzjYcC0dtywXjcMjkzgu5CXqDQ6je\/98d95e6b-f492-3dc2-9aea-d374ce6af1ba\/dzfp_25112000000045847164_\u534e\u745e\u4e16\u7eaa\u63a7\u80a1\u96c6\u56e2\u6709\u9650\u516c\u53f8_20250307145911.pdf","orig_name":"dzfp_25112000000045847164_\u534e\u745e\u4e16\u7eaa\u63a7\u80a1\u96c6\u56e2\u6709\u9650\u516c\u53f8_20250307145911.pdf"}}]}],"contractScans":[{"id":32684,"object_type":105,"object_id":3787,"attachment_id":24404,"attachment":{"id":24404,"key":24404,"name":"678dfa4f-d765-3008-920e-caed91e50418","extension":"pdf","path":"\/v2\/attachment\/preview\/GWtUzjYcC0dtywXjcMjkzgu5CXqDQ6je\/678dfa4f-d765-3008-920e-caed91e50418\/2025_03_06_09_14_40.pdf","orig_name":"2025_03_06_09_14_40.pdf"}}],"receiptScans":[],"verifyScans":[],"unreadComments":null,"collected_plan":1000,"projectProductTotalAmount":1000,"projectProductAllAmount":true,"projectProductTotalCost":0,"projectProductAllCost":true,"projectProductTotalCount":1,"invoiced":1000,"un_invoiced":0,"collected":1000,"un_collected":0,"is_collected":true,"handlerPerson":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91","avatar":{"id":141,"user_id":5300,"name":"\/files\/cdn\/a57be577deb434\/avatar\/14dfd1a0-6df5-354a-8afd-f0a76fa8e852.png"}},"remind_date":"","remind_ahead_display":"\u65e0","expire_remind_ahead_display":"\u65e0","payment_collection_remind_ahead_display":"\u63d0\u524d1\u5929","can_update":false,"can_delete":false,"unread":0,"bgcolor":"#89c541","can_view_product":true,"can_progress":true},{"id":3782,"client_id":12,"signed_at":"2025-02-11","amount":"556","handler":5300,"description":"","created_by":5300,"created_at":"2025-02-11 17:41:17","updated_at":"2025-02-17 09:24:55","contract_scan":null,"receipt_scan":null,"contract_type":1,"project_id":3775,"valid_date":null,"expire_date":"2026-02-11","sla":"","remind_ahead":"","expire_remind_ahead":"","expire_reminded":false,"serial_no":"SMC\u5929\u6d25\u8ba2\u5355POTJ25021715","payment_collection_remind_ahead":"7 days","from_project":3775,"receipt_date":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-11 17:41:17.498824+08","b_date":201,"passed":2,"client":{"id":12,"key":12,"name":"smc(\u4e2d\u56fd)\u6709\u9650\u516c\u53f8\/SMC(\u5317\u4eac)\u5236\u9020\u6709\u9650\u516c\u53f8","logo":null,"sales_rep":5300,"salesRep":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91","avatar":{"id":141,"user_id":5300,"name":"\/files\/cdn\/a57be577deb434\/avatar\/14dfd1a0-6df5-354a-8afd-f0a76fa8e852.png"}}},"contractScan":null,"receiptScan":null,"createdBy":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91","sex":"F","department_id":1,"avatar":{"id":141,"user_id":5300,"name":"\/files\/cdn\/a57be577deb434\/avatar\/14dfd1a0-6df5-354a-8afd-f0a76fa8e852.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"commentCount":{"object_id":3782,"comment":9},"project":{"id":3775,"key":3775,"name":"POTJ25021715-\u7535\u6e90\u9644\u4ef6-G-2025"},"fromProject":{"id":3775,"key":3775,"name":"POTJ25021715-\u7535\u6e90\u9644\u4ef6-G-2025","description":"","total_contact_point":null,"paid_contact_point":null,"is_sales_order_ready":true,"project_product_version_id":776,"bargain_date":"2025-02-11","collected":"556","profit_pct":"14.59","budget":"556","projectProductTypes":[{"id":5979,"product_type_id":4,"key":4,"name":"\u7f51\u7edc\u8bbe\u5907 ","budget":"556.00","pct":"14.59","project_id":3775,"profit":"81.1204"}],"projectProductRels":[{"id":8813,"project_id":3775,"product_id":1936,"amount":"556.00","number":1,"cost":"450.00","description":"","supplier_id":137,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null,"total_amount":"556","total_cost":"450","supplier":{"id":137,"key":137,"name":"\u5317\u4eac\u79e6\u8fbe\u5609\u5174\u79d1\u6280\u6709\u9650\u516c\u53f8"},"product":{"id":1936,"name":"DG-240-5501","product_type":4,"product_component":43,"product_brand":20,"product_serie":1596,"product_misc":null,"product_qa":null,"pn":"","description":"","created_by":1013,"created_at":"2025-01-16 09:47:14","updated_at":"2025-01-16 09:47:14","pinyin_shortcut":"DG2405501","product_unit":3,"is_renew":false,"productType":{"id":4,"key":4,"name":"\u7f51\u7edc\u8bbe\u5907 "},"productComponent":{"id":43,"key":43,"name":"\u7f51\u7edc\u8bbe\u5907\u914d\u4ef6"},"productBrand":{"id":20,"key":20,"name":"H3C"},"productSerie":{"id":1596,"key":1596,"name":"\u5de5\u4e1a\u4ea4\u6362\u673a\u5361\u8f68\u5f0fPoE\u4ea4\u6d41\u7535\u6e90\u6a21\u5757"},"productUnit":{"id":3,"key":3,"name":"\u4e2a"}}}],"projectContactPoints":[],"buildSalesOrderItems":[{"id":12647,"project_id":3775}],"reimbursementAmountSum":null,"profit":81.1204,"contact_points_status_display":"\u672a\u8bbe\u7f6e"},"salesSupplierRels":[{"id":2431,"contract_id":3782,"supplier_id":137,"purchase_id":3760,"supplier":{"id":137,"key":137,"name":"\u5317\u4eac\u79e6\u8fbe\u5609\u5174\u79d1\u6280\u6709\u9650\u516c\u53f8"},"purchase":{"id":3760,"key":3760,"serial_no":"A202501-15"}}],"contractType":{"id":1,"key":1,"name":"\u4ea7\u54c1\u9500\u552e"},"handleBy":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91","sex":"F","department_id":1,"avatar":{"id":141,"user_id":5300,"name":"\/files\/cdn\/a57be577deb434\/avatar\/14dfd1a0-6df5-354a-8afd-f0a76fa8e852.png"}},"remindDate":null,"serviceContractRemindDates":[],"salesContractRemindReceivers":[],"serviceContractRemindReceivers":[],"salesContractPaymentCollectionRemindReceivers":[{"id":7865,"user_id":5300,"key":5300,"contract_id":3782,"user":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91","sex":"F","avatar":{"id":141,"user_id":5300,"name":"\/files\/cdn\/a57be577deb434\/avatar\/14dfd1a0-6df5-354a-8afd-f0a76fa8e852.png"}}},{"id":7866,"user_id":5388,"key":5388,"contract_id":3782,"user":{"id":5388,"key":5388,"name":"\u6768\u71d5\u971e","sex":"F","avatar":{"id":156,"user_id":5388,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b8d4f68f-e736-3c38-9e2f-1ab47885b3d8.png"}}},{"id":7867,"user_id":1001,"key":1001,"contract_id":3782,"user":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}}}],"salesContractPaymentCollectionRemindDates":[{"id":2330,"key":2330,"contract_id":3782,"name":"2025-03-21","value":"556","overdue_days":null,"pct":100,"collect_status":"\u5df2\u5b8c\u6210"}],"salesContractPayments":[{"id":2122,"key":2122,"contract_id":3782,"value":"556","created_by":1013,"created_at":"2025-03-05 11:54:11","description":"","collected_date":"2025-03-05","amount":"556","createdBy":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","department_id":7},"files":[{"id":32672,"object_type":109,"object_id":2122,"attachment_id":24392,"attachment":{"id":24392,"key":24392,"name":"54e9c87e-7c67-3443-a407-4c175291b2c3","extension":"png","path":"\/v2\/attachment\/view\/GWtUzjYcC0dtywXjcMjkzgu5CXqDQ6je\/54e9c87e-7c67-3443-a407-4c175291b2c3\/image.png","orig_name":"image.png"}}],"pct":100}],"salesContractInvoices":[{"id":1962,"key":1962,"contract_id":3782,"value":"556.00","attachment_id":null,"from_date":"2025-02-24","attachment":null,"attachmentRelationships":[],"files":[{"id":32557,"object_type":102,"object_id":1962,"attachment_id":24277,"attachment":{"id":24277,"key":24277,"name":"bd2089fe-fb14-3142-9db3-465f75cea3c1","extension":"pdf","path":"\/v2\/attachment\/view\/GWtUzjYcC0dtywXjcMjkzgu5CXqDQ6je\/bd2089fe-fb14-3142-9db3-465f75cea3c1\/dzfp_25112000000036004144_SMC\uff08\u5929\u6d25\uff09\u5236\u9020\u6709\u9650\u516c\u53f8_20250224153805.pdf","orig_name":"dzfp_25112000000036004144_SMC\uff08\u5929\u6d25\uff09\u5236\u9020\u6709\u9650\u516c\u53f8_20250224153805.pdf"}}]}],"contractScans":[{"id":32253,"object_type":105,"object_id":3782,"attachment_id":24023,"attachment":{"id":24023,"key":24023,"name":"da9e97d5-744f-3137-ac55-12d390dace48","extension":"pdf","path":"\/v2\/attachment\/preview\/GWtUzjYcC0dtywXjcMjkzgu5CXqDQ6je\/da9e97d5-744f-3137-ac55-12d390dace48\/POTJ25021715.pdf","orig_name":"POTJ25021715.pdf"}}],"receiptScans":[{"id":32263,"object_type":106,"object_id":3782,"attachment_id":24079,"attachment":{"id":24079,"key":24079,"name":"6ab90912-00b9-316d-8198-4b4f3dfb7f50","extension":"pdf","path":"\/v2\/attachment\/preview\/GWtUzjYcC0dtywXjcMjkzgu5CXqDQ6je\/6ab90912-00b9-316d-8198-4b4f3dfb7f50\/2025_02_17_09_22_53.pdf","orig_name":"2025_02_17_09_22_53.pdf"}}],"verifyScans":[],"unreadComments":null,"collected_plan":556,"projectProductTotalAmount":556,"projectProductAllAmount":true,"projectProductTotalCost":450,"projectProductAllCost":true,"projectProductTotalCount":1,"invoiced":556,"un_invoiced":0,"collected":556,"un_collected":0,"is_collected":true,"handlerPerson":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91","avatar":{"id":141,"user_id":5300,"name":"\/files\/cdn\/a57be577deb434\/avatar\/14dfd1a0-6df5-354a-8afd-f0a76fa8e852.png"}},"remind_date":"","remind_ahead_display":"\u65e0","expire_remind_ahead_display":"\u65e0","payment_collection_remind_ahead_display":"\u63d0\u524d7\u5929","can_update":false,"can_delete":false,"unread":0,"bgcolor":"#89c541","can_view_product":true,"can_progress":true},{"id":3778,"client_id":12,"signed_at":"2025-02-10","amount":"1533","handler":5300,"description":"","created_by":5300,"created_at":"2025-02-10 13:26:03","updated_at":"2025-02-14 09:23:33","contract_scan":null,"receipt_scan":null,"contract_type":1,"project_id":3773,"valid_date":null,"expire_date":null,"sla":"","remind_ahead":"","expire_remind_ahead":"","expire_reminded":false,"serial_no":"SMC\u5317\u4eac\u8ba2\u5355POBJ25020936","payment_collection_remind_ahead":"2 days","from_project":3773,"receipt_date":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 09:17:18.205821+08","b_date":null,"passed":1,"client":{"id":12,"key":12,"name":"smc(\u4e2d\u56fd)\u6709\u9650\u516c\u53f8\/SMC(\u5317\u4eac)\u5236\u9020\u6709\u9650\u516c\u53f8","logo":null,"sales_rep":5300,"salesRep":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91","avatar":{"id":141,"user_id":5300,"name":"\/files\/cdn\/a57be577deb434\/avatar\/14dfd1a0-6df5-354a-8afd-f0a76fa8e852.png"}}},"contractScan":null,"receiptScan":null,"createdBy":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91","sex":"F","department_id":1,"avatar":{"id":141,"user_id":5300,"name":"\/files\/cdn\/a57be577deb434\/avatar\/14dfd1a0-6df5-354a-8afd-f0a76fa8e852.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"commentCount":{"object_id":3778,"comment":8},"project":{"id":3773,"key":3773,"name":"POBJ25020936-\u56fa\u6001\u786c\u76d8-G-2025"},"fromProject":{"id":3773,"key":3773,"name":"POBJ25020936-\u56fa\u6001\u786c\u76d8-G-2025","description":"","total_contact_point":null,"paid_contact_point":null,"is_sales_order_ready":true,"project_product_version_id":771,"bargain_date":"2025-02-10","collected":"1533","profit_pct":"41.41","budget":"1533","projectProductTypes":[{"id":5980,"product_type_id":2,"key":2,"name":"\u670d\u52a1\u5668","budget":"1533.00","pct":"41.41","project_id":3773,"profit":"634.8153"}],"projectProductRels":[{"id":8814,"project_id":3773,"product_id":1770,"amount":"511.00","number":3,"cost":"256.00","description":"","supplier_id":608,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null,"total_amount":"1533","total_cost":"768","supplier":{"id":608,"key":608,"name":"\u6dd8\u5b9d\u7f51"},"product":{"id":1770,"name":"BG5 512G 2230 PCIE4.0NVME\u56fa\u6001\u786c\u76d8","product_type":11,"product_component":179,"product_brand":43,"product_serie":1495,"product_misc":null,"product_qa":null,"pn":"","description":"","created_by":1013,"created_at":"2024-08-29 14:10:56","updated_at":"2024-08-29 14:10:56","pinyin_shortcut":"BG5512G2230PCIE40NVMEgtyp","product_unit":3,"is_renew":false,"productType":{"id":11,"key":11,"name":"\u4e2a\u4eba\u8ba1\u7b97\u673a"},"productComponent":{"id":179,"key":179,"name":"\u914d\u4ef6"},"productBrand":{"id":43,"key":43,"name":"\u4e1c\u829d"},"productSerie":{"id":1495,"key":1495,"name":"\u4e1c\u829d BG5 512G 2230 PCIE4.0NVME\u56fa\u6001\u786c\u76d8"},"productUnit":{"id":3,"key":3,"name":"\u4e2a"}}}],"projectContactPoints":[],"buildSalesOrderItems":[{"id":12625,"project_id":3773},{"id":12627,"project_id":3773},{"id":12626,"project_id":3773}],"reimbursementAmountSum":null,"profit":634.8153,"contact_points_status_display":"\u672a\u8bbe\u7f6e"},"salesSupplierRels":[{"id":2420,"contract_id":3778,"supplier_id":608,"purchase_id":3779,"supplier":{"id":608,"key":608,"name":"\u6dd8\u5b9d\u7f51"},"purchase":{"id":3779,"key":3779,"serial_no":"\u8ba2\u5355\u53f7: 4227032052866592710"}}],"contractType":{"id":1,"key":1,"name":"\u4ea7\u54c1\u9500\u552e"},"handleBy":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91","sex":"F","department_id":1,"avatar":{"id":141,"user_id":5300,"name":"\/files\/cdn\/a57be577deb434\/avatar\/14dfd1a0-6df5-354a-8afd-f0a76fa8e852.png"}},"remindDate":null,"serviceContractRemindDates":[],"salesContractRemindReceivers":[],"serviceContractRemindReceivers":[],"salesContractPaymentCollectionRemindReceivers":[{"id":7868,"user_id":5300,"key":5300,"contract_id":3778,"user":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91","sex":"F","avatar":{"id":141,"user_id":5300,"name":"\/files\/cdn\/a57be577deb434\/avatar\/14dfd1a0-6df5-354a-8afd-f0a76fa8e852.png"}}},{"id":7869,"user_id":5388,"key":5388,"contract_id":3778,"user":{"id":5388,"key":5388,"name":"\u6768\u71d5\u971e","sex":"F","avatar":{"id":156,"user_id":5388,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b8d4f68f-e736-3c38-9e2f-1ab47885b3d8.png"}}},{"id":7870,"user_id":1001,"key":1001,"contract_id":3778,"user":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}}}],"salesContractPaymentCollectionRemindDates":[{"id":2333,"key":2333,"contract_id":3778,"name":"2025-03-14","value":"1533","overdue_days":null,"pct":100,"collect_status":"\u5df2\u5b8c\u6210"}],"salesContractPayments":[{"id":2121,"key":2121,"contract_id":3778,"value":"1533","created_by":1013,"created_at":"2025-03-05 11:53:03","description":"","collected_date":"2025-03-05","amount":"1533","createdBy":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","department_id":7},"files":[{"id":32671,"object_type":109,"object_id":2121,"attachment_id":24391,"attachment":{"id":24391,"key":24391,"name":"e0069f16-5fad-30c5-800d-8fb2bbecd759","extension":"png","path":"\/v2\/attachment\/view\/GWtUzjYcC0dtywXjcMjkzgu5CXqDQ6je\/e0069f16-5fad-30c5-800d-8fb2bbecd759\/image.png","orig_name":"image.png"}}],"pct":100}],"salesContractInvoices":[{"id":1959,"key":1959,"contract_id":3778,"value":"1533.00","attachment_id":null,"from_date":"2025-02-24","attachment":null,"attachmentRelationships":[],"files":[{"id":32499,"object_type":102,"object_id":1959,"attachment_id":24274,"attachment":{"id":24274,"key":24274,"name":"7446572e-2a94-3b37-91ec-807c60d61ff9","extension":"pdf","path":"\/v2\/attachment\/view\/GWtUzjYcC0dtywXjcMjkzgu5CXqDQ6je\/7446572e-2a94-3b37-91ec-807c60d61ff9\/dzfp_25112000000036053657_SMC\uff08\u5317\u4eac\uff09\u5236\u9020\u6709\u9650\u516c\u53f8_20250224154010.pdf","orig_name":"dzfp_25112000000036053657_SMC\uff08\u5317\u4eac\uff09\u5236\u9020\u6709\u9650\u516c\u53f8_20250224154010.pdf"}}]}],"contractScans":[{"id":32254,"object_type":105,"object_id":3778,"attachment_id":24020,"attachment":{"id":24020,"key":24020,"name":"a1998eaf-d7b0-3090-bf7a-610aac9363f4","extension":"pdf","path":"\/v2\/attachment\/preview\/GWtUzjYcC0dtywXjcMjkzgu5CXqDQ6je\/a1998eaf-d7b0-3090-bf7a-610aac9363f4\/POBJ25020936.pdf","orig_name":"POBJ25020936.pdf"}}],"receiptScans":[{"id":32226,"object_type":106,"object_id":3778,"attachment_id":24052,"attachment":{"id":24052,"key":24052,"name":"732b9a85-2343-3f29-9bfa-6cae31e8a0e9","extension":"pdf","path":"\/v2\/attachment\/preview\/GWtUzjYcC0dtywXjcMjkzgu5CXqDQ6je\/732b9a85-2343-3f29-9bfa-6cae31e8a0e9\/2025_02_13_10_51_19.pdf","orig_name":"2025_02_13_10_51_19.pdf"}}],"verifyScans":[],"unreadComments":null,"collected_plan":1533,"projectProductTotalAmount":1533,"projectProductAllAmount":true,"projectProductTotalCost":768,"projectProductAllCost":true,"projectProductTotalCount":3,"invoiced":1533,"un_invoiced":0,"collected":1533,"un_collected":0,"is_collected":true,"handlerPerson":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91","avatar":{"id":141,"user_id":5300,"name":"\/files\/cdn\/a57be577deb434\/avatar\/14dfd1a0-6df5-354a-8afd-f0a76fa8e852.png"}},"remind_date":"","remind_ahead_display":"\u65e0","expire_remind_ahead_display":"\u65e0","payment_collection_remind_ahead_display":"\u63d0\u524d2\u5929","can_update":false,"can_delete":false,"unread":0,"bgcolor":"#89c541","can_view_product":true,"can_progress":true},{"id":3761,"client_id":2182,"signed_at":"2025-01-16","amount":"76000","handler":5300,"description":"","created_by":5300,"created_at":"2025-01-16 09:40:49","updated_at":"2025-02-19 13:25:08","contract_scan":null,"receipt_scan":null,"contract_type":2,"project_id":3745,"valid_date":null,"expire_date":"2026-01-14","sla":"","remind_ahead":"","expire_remind_ahead":"30 days","expire_reminded":false,"serial_no":"PO-2025-01-0003","payment_collection_remind_ahead":"7 days","from_project":3745,"receipt_date":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-01-17 13:57:32.712836+08","b_date":173,"passed":2,"client":{"id":2182,"key":2182,"name":"\u5317\u4eac\u5357\u65b9\u65af\u5948\u514b\u739b\u6da1\u8f6e\u6280\u672f\u6709\u9650\u516c\u53f8","logo":null,"sales_rep":5300,"salesRep":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91","avatar":{"id":141,"user_id":5300,"name":"\/files\/cdn\/a57be577deb434\/avatar\/14dfd1a0-6df5-354a-8afd-f0a76fa8e852.png"}}},"contractScan":null,"receiptScan":null,"createdBy":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91","sex":"F","department_id":1,"avatar":{"id":141,"user_id":5300,"name":"\/files\/cdn\/a57be577deb434\/avatar\/14dfd1a0-6df5-354a-8afd-f0a76fa8e852.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"commentCount":{"object_id":3761,"comment":7},"project":{"id":3745,"key":3745,"name":"netapp\u5b58\u50a8\u7b2c\u4e09\u65b9\u7ef4\u4fdd1\u5e74-2024"},"fromProject":{"id":3745,"key":3745,"name":"netapp\u5b58\u50a8\u7b2c\u4e09\u65b9\u7ef4\u4fdd1\u5e74-2024","description":"","total_contact_point":"13600","paid_contact_point":"13600","is_sales_order_ready":true,"project_product_version_id":759,"bargain_date":"2025-01-16","collected":"76000","profit_pct":"72.42","budget":"76000","projectProductTypes":[{"id":5991,"product_type_id":3,"key":3,"name":"\u5b58\u50a8\u8bbe\u5907","budget":"76000","pct":"72.42","project_id":3745,"profit":"55039.2"}],"projectProductRels":[{"id":8823,"project_id":3745,"product_id":941,"amount":"15000.00","number":1,"cost":"0","description":"","supplier_id":null,"hardware_from":"2025-01-15","software_from":null,"maintenance_from":null,"hardware_to":"2026-01-14","software_to":null,"maintenance_to":null,"total_amount":"15000","total_cost":"0","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":"2023-08-11 16:02:47","pinyin_shortcut":"tsrgjsfw","product_unit":7,"is_renew":false,"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"}}},{"id":8824,"project_id":3745,"product_id":941,"amount":"15000.00","number":1,"cost":"0","description":"","supplier_id":null,"hardware_from":"2025-01-15","software_from":null,"maintenance_from":null,"hardware_to":"2026-01-14","software_to":null,"maintenance_to":null,"total_amount":"15000","total_cost":"0","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":"2023-08-11 16:02:47","pinyin_shortcut":"tsrgjsfw","product_unit":7,"is_renew":false,"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"}}},{"id":8825,"project_id":3745,"product_id":941,"amount":"3833.33","number":12,"cost":"0","description":"","supplier_id":null,"hardware_from":null,"software_from":null,"maintenance_from":"2025-01-15","hardware_to":null,"software_to":null,"maintenance_to":"2026-01-14","total_amount":"46000.00","total_cost":"0","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":"2023-08-11 16:02:47","pinyin_shortcut":"tsrgjsfw","product_unit":7,"is_renew":false,"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"}}}],"projectContactPoints":[{"id":877,"project_id":3745,"contact_id":3988,"point":"13600.00","paid_point":"13600","contact":{"id":3988,"key":3988,"name":"\u5218\u6625","client_id":2182,"supplier_id":null,"client":{"id":2182,"key":2182,"name":"\u5317\u4eac\u5357\u65b9\u65af\u5948\u514b\u739b\u6da1\u8f6e\u6280\u672f\u6709\u9650\u516c\u53f8"},"supplier":null},"projectContactPointRels":[{"id":163,"project_id":3745,"contact_id":3988,"point":"13600.00","day_at":"2025-02-19","description":"","created_at":"2025-02-19 13:25:08"}],"status_display":"\u5df2\u6838\u9500"}],"buildSalesOrderItems":[{"id":12494,"project_id":3745},{"id":12493,"project_id":3745},{"id":12492,"project_id":3745}],"reimbursementAmountSum":null,"profit":55039.2,"contact_points_status_display":"\u5df2\u6838\u9500"},"salesSupplierRels":[],"contractType":{"id":2,"key":2,"name":"\u8fd0\u7ef4\u670d\u52a1"},"handleBy":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91","sex":"F","department_id":1,"avatar":{"id":141,"user_id":5300,"name":"\/files\/cdn\/a57be577deb434\/avatar\/14dfd1a0-6df5-354a-8afd-f0a76fa8e852.png"}},"remindDate":null,"serviceContractRemindDates":[],"salesContractRemindReceivers":[{"id":8304,"user_id":5300,"key":5300,"contract_id":3761,"user":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91","sex":"F","avatar":{"id":141,"user_id":5300,"name":"\/files\/cdn\/a57be577deb434\/avatar\/14dfd1a0-6df5-354a-8afd-f0a76fa8e852.png"}}}],"serviceContractRemindReceivers":[],"salesContractPaymentCollectionRemindReceivers":[{"id":7880,"user_id":5300,"key":5300,"contract_id":3761,"user":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91","sex":"F","avatar":{"id":141,"user_id":5300,"name":"\/files\/cdn\/a57be577deb434\/avatar\/14dfd1a0-6df5-354a-8afd-f0a76fa8e852.png"}}},{"id":7881,"user_id":5388,"key":5388,"contract_id":3761,"user":{"id":5388,"key":5388,"name":"\u6768\u71d5\u971e","sex":"F","avatar":{"id":156,"user_id":5388,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b8d4f68f-e736-3c38-9e2f-1ab47885b3d8.png"}}},{"id":7882,"user_id":1001,"key":1001,"contract_id":3761,"user":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}}}],"salesContractPaymentCollectionRemindDates":[{"id":2319,"key":2319,"contract_id":3761,"name":"2025-02-18","value":"76000","overdue_days":null,"pct":100,"collect_status":"\u5df2\u5b8c\u6210"}],"salesContractPayments":[{"id":2095,"key":2095,"contract_id":3761,"value":"76000","created_by":1013,"created_at":"2025-02-10 13:07:08","description":"","collected_date":"2025-02-10","amount":"76000","createdBy":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","department_id":7},"files":[{"id":32109,"object_type":109,"object_id":2095,"attachment_id":23958,"attachment":{"id":23958,"key":23958,"name":"e79ed4ec-4eba-3287-bf25-c71b676acebf","extension":"png","path":"\/v2\/attachment\/view\/GWtUzjYcC0dtywXjcMjkzgu5CXqDQ6je\/e79ed4ec-4eba-3287-bf25-c71b676acebf\/image.png","orig_name":"image.png"}}],"pct":100}],"salesContractInvoices":[{"id":1941,"key":1941,"contract_id":3761,"value":"76000.00","attachment_id":null,"from_date":"2025-01-16","attachment":null,"attachmentRelationships":[],"files":[{"id":31875,"object_type":102,"object_id":1941,"attachment_id":23775,"attachment":{"id":23775,"key":23775,"name":"dd3b420f-8a4f-3be1-9a5c-5d5d3b3368f9","extension":"pdf","path":"\/v2\/attachment\/view\/GWtUzjYcC0dtywXjcMjkzgu5CXqDQ6je\/dd3b420f-8a4f-3be1-9a5c-5d5d3b3368f9\/dzfp_25112000000012604357_\u5317\u4eac\u5357\u65b9\u65af\u5948\u514b\u739b\u6da1\u8f6e\u6280\u672f\u6709\u9650\u516c\u53f8_20250116100342.pdf","orig_name":"dzfp_25112000000012604357_\u5317\u4eac\u5357\u65b9\u65af\u5948\u514b\u739b\u6da1\u8f6e\u6280\u672f\u6709\u9650\u516c\u53f8_20250116100342.pdf"}}]}],"contractScans":[{"id":32409,"object_type":105,"object_id":3761,"attachment_id":23774,"attachment":{"id":23774,"key":23774,"name":"ec5cea7d-2630-3394-9088-52bc57cb37da","extension":"pdf","path":"\/v2\/attachment\/preview\/GWtUzjYcC0dtywXjcMjkzgu5CXqDQ6je\/ec5cea7d-2630-3394-9088-52bc57cb37da\/PO-2025-01-0003_signed.pdf","orig_name":"PO-2025-01-0003_signed.pdf"}}],"receiptScans":[],"verifyScans":[],"unreadComments":null,"collected_plan":76000,"projectProductTotalAmount":76000,"projectProductAllAmount":true,"projectProductTotalCost":0,"projectProductAllCost":true,"projectProductTotalCount":14,"invoiced":76000,"un_invoiced":0,"collected":76000,"un_collected":0,"is_collected":true,"handlerPerson":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91","avatar":{"id":141,"user_id":5300,"name":"\/files\/cdn\/a57be577deb434\/avatar\/14dfd1a0-6df5-354a-8afd-f0a76fa8e852.png"}},"remind_date":"","remind_ahead_display":"\u65e0","expire_remind_ahead_display":"\u63d0\u524d30\u5929","payment_collection_remind_ahead_display":"\u63d0\u524d7\u5929","can_update":false,"can_delete":false,"unread":0,"bgcolor":"#89c541","can_view_product":true,"can_progress":true}],"pagenation":{"totalcount":610,"thispage":1,"pagesize":10}},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}]}', FALSE, '2025-07-25 22:03:37') RETURNING "id" |