ConfigurationRequestLogsProfilingDatabaseAsset BundlesMailTimeline
68ccb0082755d: POST https://beta.jinchangxiao.com/vue/sales-contract/of-project at 2025-09-19 09:21:12 am by 114.244.128.96

Log Messages

总计91条数据
TimeLevelCategoryMessage
 
09:21:12.160traceyii\base\Application::bootstrapBootstrap with yii\log\Dispatcher
09:21:12.160traceyii\base\Module::getModuleLoading module: debug
09:21:12.161traceyii\base\Application::bootstrapBootstrap with yii\debug\Module::bootstrap()
09:21:12.161traceyii\redis\Connection::openOpening redis DB connection: redis.server.local:6379, database=1
09:21:12.161traceyii\redis\Connection::executeCommandExecuting Redis Command: SELECT
09:21:12.161traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
09:21:12.161traceyii\base\Module::getModuleLoading module: gii
09:21:12.161traceyii\base\Application::bootstrapBootstrap with yii\gii\Module::bootstrap()
09:21:12.161traceyii\web\UrlManager::parseRequestNo matching URL rules. Using default URL parsing logic.
09:21:12.161traceyii\web\Application::handleRequestRoute requested: 'vue/sales-contract/of-project'
09:21:12.161traceyii\base\Module::getModuleLoading module: vue
09:21:12.178infoyii\web\Session::openSession started
09:21:12.178infoyii\db\Command::querySELECT * FROM "global"."vw_user_login" WHERE "id"=1001
09:21:12.178infoyii\db\Connection::openOpening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta
09:21:12.184traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
09:21:12.185traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
09:21:12.186traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
09:21:12.187traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
09:21:12.188infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
09:21:12.190traceyii\base\Controller::runActionRoute to run: vue/sales-contract/of-project
09:21:12.191traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
09:21:12.193traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: Admin
09:21:12.193traceyii\base\InlineAction::runWithParamsRunning action: app\modules\vue\controllers\SalesContractController::actionOfProject()
09:21:12.193infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_projects" WHERE "id"='3953'
09:21:12.194traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
09:21:12.194traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
09:21:12.196traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
09:21:12.196infoyii\db\Command::querySELECT d.nspname AS table_schema, c.relname AS table_name, a.attname AS column_name, t.typname AS data_type, a.attlen AS character_maximum_length, pg_catalog.col_description(c.oid, a.attnum) AS column_comment, a.atttypmod AS modifier, a.attnotnull = false AS is_nullable, CAST(pg_get_expr(ad.adbin, ad.adrelid) AS varchar) AS column_default, coalesce(pg_get_expr(ad.adbin, ad.adrelid) ~ 'nextval',false) AS is_autoinc, array_to_string((select array_agg(enumlabel) from pg_enum where enumtypid=a.atttypid)::varchar[],',') as enum_values, CASE atttypid WHEN 21 /*int2*/ THEN 16 WHEN 23 /*int4*/ THEN 32 WHEN 20 /*int8*/ THEN 64 WHEN 1700 /*numeric*/ THEN CASE WHEN atttypmod = -1 THEN null ELSE ((atttypmod - 4) >> 16) & 65535 END WHEN 700 /*float4*/ THEN 24 /*FLT_MANT_DIG*/ WHEN 701 /*float8*/ THEN 53 /*DBL_MANT_DIG*/ ELSE null END AS numeric_precision, CASE WHEN atttypid IN (21, 23, 20) THEN 0 WHEN atttypid IN (1700) THEN CASE WHEN atttypmod = -1 THEN null ELSE (atttypmod - 4) & 65535 END ELSE null END AS numeric_scale, CAST( information_schema._pg_char_max_length(information_schema._pg_truetypid(a, t), information_schema._pg_truetypmod(a, t)) AS numeric ) AS size, a.attnum = any (ct.conkey) as is_pkey FROM pg_class c LEFT JOIN pg_attribute a ON a.attrelid = c.oid LEFT JOIN pg_attrdef ad ON a.attrelid = ad.adrelid AND a.attnum = ad.adnum LEFT JOIN pg_type t ON a.atttypid = t.oid LEFT JOIN pg_namespace d ON d.oid = c.relnamespace LEFT join pg_constraint ct on ct.conrelid=c.oid and ct.contype='p' WHERE a.attnum > 0 and t.typname != '' and c.relname = 'tbl_sales_contracts' and d.nspname = 'a57be577deb434' ORDER BY a.attnum;
09:21:12.206infoyii\db\Command::queryselect ct.conname as constraint_name, a.attname as column_name, fc.relname as foreign_table_name, fns.nspname as foreign_table_schema, fa.attname as foreign_column_name from (SELECT ct.conname, ct.conrelid, ct.confrelid, ct.conkey, ct.contype, ct.confkey, generate_subscripts(ct.conkey, 1) AS s FROM pg_constraint ct ) AS ct inner join pg_class c on c.oid=ct.conrelid inner join pg_namespace ns on c.relnamespace=ns.oid inner join pg_attribute a on a.attrelid=ct.conrelid and a.attnum = ct.conkey[ct.s] left join pg_class fc on fc.oid=ct.confrelid left join pg_namespace fns on fc.relnamespace=fns.oid left join pg_attribute fa on fa.attrelid=ct.confrelid and fa.attnum = ct.confkey[ct.s] where ct.contype='f' and c.relname='tbl_sales_contracts' and ns.nspname='a57be577deb434' order by fns.nspname, fc.relname, a.attnum
09:21:12.215traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
09:21:12.215traceyii\redis\Connection::executeCommandExecuting Redis Command: SET
09:21:12.216traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
09:21:12.217traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
09:21:12.219infoyii\db\Command::querySELECT 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 (1001, 5049, 5301, 5022, 5209, 5026, 5293, 5309, 5356, 5329, 5299, 5303, 5302, 5332, 5047, 1026, 5096, 5070, 5448, 5420, 1029, 5037, 5087, 1008, 5048, 5043, 5045, 5230, 5031, 5088, 5208, 1003, 5294, 5357, 5044, 1030, 5076, 5300, 5027, 5089, 5311, 5066, 5069, 5364, 1009, 5295, 1013, 5128, 5203, 1025, 5032, 5075, 1004, 5072, 5033, 5359, 5412, 5409, 5229, 1005, 5304, 5449, 5358, 1006, 5093)) OR ("client"."sales_rep" IS NULL) OR ("client"."id" IN (SELECT "client_id" FROM "a57be577deb434"."tbl_user_visit_clients" WHERE "user_id"=1001))) AND ("c"."project_id"=3953) GROUP BY "c"."id" ORDER BY "c"."signed_at" DESC, "c"."created_at" DESC) "c"
09:21:12.235infoyii\db\Command::querySELECT 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 (1001, 5049, 5301, 5022, 5209, 5026, 5293, 5309, 5356, 5329, 5299, 5303, 5302, 5332, 5047, 1026, 5096, 5070, 5448, 5420, 1029, 5037, 5087, 1008, 5048, 5043, 5045, 5230, 5031, 5088, 5208, 1003, 5294, 5357, 5044, 1030, 5076, 5300, 5027, 5089, 5311, 5066, 5069, 5364, 1009, 5295, 1013, 5128, 5203, 1025, 5032, 5075, 1004, 5072, 5033, 5359, 5412, 5409, 5229, 1005, 5304, 5449, 5358, 1006, 5093)) OR ("client"."sales_rep" IS NULL) OR ("client"."id" IN (SELECT "client_id" FROM "a57be577deb434"."tbl_user_visit_clients" WHERE "user_id"=1001))) AND ("c"."project_id"=3953) GROUP BY "c"."id" ORDER BY "c"."signed_at" DESC, "c"."created_at" DESC LIMIT 20
09:21:12.248infoyii\db\Command::querySELECT "id", "id" AS "key", "name", "logo", "sales_rep" FROM "a57be577deb434"."tbl_clients" WHERE "id"=12
09:21:12.248infoyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_users" WHERE "id"=5300
09:21:12.249infoyii\db\Command::querySELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=5300)
09:21:12.249infoyii\db\Command::querySELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id"=5300
09:21:12.250infoyii\db\Command::querySELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=5300)
09:21:12.250infoyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_departments" WHERE "id"=1
09:21:12.250infoyii\db\Command::querySELECT "object_id", count(*) AS comment FROM "a57be577deb434"."tbl_comments" WHERE ("object_type"=7) AND ("object_id"=4120) GROUP BY "object_id"
09:21:12.270infoyii\db\Command::querySELECT "id", "id" AS "key", "project_title" AS "name" FROM "a57be577deb434"."tbl_projects" WHERE "id"=3953
09:21:12.271infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_sales_orders" WHERE ("status" IN (2, 5)) AND ("project_id"=3953)
09:21:12.272infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_sales_order_verify_rels" WHERE "erp_sales_order_id"=1572 ORDER BY "id"
09:21:12.274infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_sales_order_stop_verify_rels" WHERE "erp_sales_order_id"=1572 ORDER BY "id"
09:21:12.275infoyii\db\Command::querySELECT "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"=3953
09:21:12.277infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_sales_orders" WHERE ("status" IN (2, 5)) AND ("project_id"=3953)
09:21:12.277infoyii\db\Command::querySELECT "id", "product_type_id", "product_type_id" AS "key", "name", "budget", "pct", "project_id", "profit" FROM "a57be577deb434"."tbl_project_product_types" WHERE "project_id"=3953
09:21:12.278infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_project_product_rels" WHERE "project_id"=3953
09:21:12.279infoyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_suppliers" WHERE "id"=649
09:21:12.279infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_products" WHERE "id"=1613
09:21:12.280infoyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_types" WHERE "id"=4
09:21:12.280infoyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_components" WHERE "id"=19
09:21:12.281infoyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_brands" WHERE "id"=20
09:21:12.281infoyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_series" WHERE "id"=1374
09:21:12.281infoyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_units" WHERE "id"=1
09:21:12.282infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_sales_order_products" WHERE "id"=1862
09:21:12.282infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_project_contact_points" WHERE "project_id"=3953
09:21:12.283infoyii\db\Command::querySELECT "id", "project_id" FROM "a57be577deb434"."tbl_sales_order_items" WHERE ("is_system"=TRUE) AND ("project_id"=3953)
09:21:12.293infoyii\db\Command::querySELECT "project_id", sum(amount) AS sum FROM "a57be577deb434"."tbl_reimbursements" WHERE ("status" IN (2, 3)) AND ("project_id"=3953) GROUP BY "project_id"
09:21:12.295infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_sales_supplier_rels" WHERE "contract_id"=4120
09:21:12.295infoyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_suppliers" WHERE "id"=649
09:21:12.296infoyii\db\Command::querySELECT "id", "id" AS "key", "serial_no" FROM "a57be577deb434"."tbl_purchase_contracts" WHERE "id"=4121
09:21:12.296infoyii\db\Command::querySELECT "id", "id" AS "key", "type" AS "name" FROM "a57be577deb434"."tbl_contract_types" WHERE "id"=1
09:21:12.296infoyii\db\Command::querySELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id"=5300
09:21:12.297infoyii\db\Command::querySELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=5300)
09:21:12.297infoyii\db\Command::querySELECT "id", "id" AS "key", "contract_id", "remind_date" FROM "a57be577deb434"."tbl_service_contract_remind_dates" WHERE ("reminded"=FALSE) AND ("contract_id"=4120) ORDER BY "remind_date"
09:21:12.300infoyii\db\Command::querySELECT "id", "id" AS "key", "contract_id", "remind_date" AS "name" FROM "a57be577deb434"."tbl_service_contract_remind_dates" WHERE "contract_id"=4120
09:21:12.300infoyii\db\Command::querySELECT "id", "user_id", "user_id" AS "key", "contract_id" FROM "a57be577deb434"."tbl_sales_contract_remind_receivers" WHERE "contract_id"=4120
09:21:12.302infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_service_contract_remind_receivers" WHERE "contract_id"=4120
09:21:12.304infoyii\db\Command::querySELECT "id", "user_id", "user_id" AS "key", "contract_id" FROM "a57be577deb434"."tbl_sales_contract_payment_collection_remind_receivers" WHERE "contract_id"=4120
09:21:12.304infoyii\db\Command::querySELECT "id", "id" AS "key", "name", "sex" FROM "a57be577deb434"."tbl_users" WHERE "id"=5300
09:21:12.305infoyii\db\Command::querySELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=5300)
09:21:12.305infoyii\db\Command::querySELECT "id", "id" AS "key", "contract_id", "remind_date" AS "name", "amount" AS "value", "overdue_days", "status" FROM "a57be577deb434"."tbl_sales_contract_payment_collection_remind_dates" WHERE "contract_id"=4120 ORDER BY "remind_date"
09:21:12.306infoyii\db\Command::querySELECT "id", "id" AS "key", "contract_id", "amount" AS "value", "created_by", "created_at", "description", "collected_date", "amount" FROM (SELECT * FROM ((SELECT '1' || r.id::varchar as id, 1 as ticket_type, r.sales_contract_id as contract_id, r.amount as amount, t.created_at as collected_date, t.created_at, t.created_by, t.abstract as description FROM "a57be577deb434"."tbl_erp_collect_ticket_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_collect_tickets" "t" ON r.erp_collect_ticket_id = t.id WHERE (r.sales_contract_id is not null) AND ("t"."status" IN (2, 5, 1))) UNION ALL ( SELECT '2' || r.id::varchar as id, 2 as ticket_type, r.sales_contract_id as contract_id, r.amount as amount, t.created_at as collected_date, t.created_at, t.created_by, t.abstract as description FROM "a57be577deb434"."tbl_erp_cash_cost_ticket_sales_contract_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_cash_cost_tickets" "t" ON r.erp_cash_cost_ticket_id = t.id WHERE (r.sales_contract_id is not null) AND ("t"."status" IN (2, 5, 1)) ) UNION ALL ( SELECT '3' || r.id::varchar as id, 3 as ticket_type, r.sales_contract_id as contract_id, 0 - r.amount as amount, t.created_at as collected_date, t.created_at, t.created_by, t.abstract as description FROM "a57be577deb434"."tbl_erp_payment_ticket_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_payment_tickets" "t" ON r.erp_payment_ticket_id = t.id WHERE (r.sales_contract_id is not null) AND ("t"."status" IN (2, 5, 1)) )) "sub") "r" WHERE "contract_id"=4120 ORDER BY "id" DESC
09:21:12.309infoyii\db\Command::querySELECT "id", "id" AS "key", "contract_id", "amount" AS "value", "attachment_id", "from_date", "description", "is_draft" FROM "a57be577deb434"."tbl_sales_contract_invoices" WHERE "contract_id"=4120 ORDER BY "id"
09:21:12.310infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=105) AND ("object_id"=4120)
09:21:12.312infoyii\db\Command::querySELECT "id", "id" AS "key", "name", "extension", "path", "orig_name" FROM "a57be577deb434"."tbl_attachments" WHERE "id"=27814
09:21:12.312infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=106) AND ("object_id"=4120)
09:21:12.314infoyii\db\Command::querySELECT "id", "id" AS "key", "name", "extension", "path", "orig_name" FROM "a57be577deb434"."tbl_attachments" WHERE "id"=27850
09:21:12.314infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=107) AND ("object_id"=4120)
09:21:12.316infoyii\db\Command::querySELECT "object_id", count(*) AS unread FROM "a57be577deb434"."tbl_unread_comments" WHERE ("object_type"=7) AND (remind_user_id = 1001 AND is_read = false) AND ("object_id"=4120) GROUP BY "object_id"
09:21:12.333traceuranus\rbac\DbManager::checkAccessFromCacheChecking permission: viewProduct
09:21:12.333traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: StoreKeeper
09:21:12.333traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: Admin
09:21:12.334traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
09:21:12.334traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
09:21:12.334infoyii\db\Command::queryINSERT INTO "global"."tbl_api_log" ("code", "schema", "user_id", "device_type", "url", "request", "response", "php_error", "time") VALUES (200, 'a57be577deb434', 1001, 5, 'vue/sales-contract/of-project', '{"page":"1","id":"3953","web_access_token":"Hlt1ZmLXNhK2kSIyrIUGksUdIH0iseH7"}', '{"code":2000,"result":{"list":[{"id":4120,"client_id":12,"signed_at":"2025-08-22","amount":"4942","handler":5300,"description":"","created_by":5300,"created_at":"2025-08-22 17:37:28","updated_at":"2025-08-27 09:32:46","contract_scan":"","receipt_scan":"","contract_type":1,"project_id":3953,"valid_date":"","expire_date":"2026-08-25","sla":"","remind_ahead":"","expire_remind_ahead":"","expire_reminded":false,"serial_no":"SMC\u4e2d\u56fd\u8ba2\u5355POCN25085613","payment_collection_remind_ahead":"1 day","from_project":3953,"receipt_date":"","verify_date":"","including_tax":true,"build_by_project":true,"need_analysis":true,"is_settle":true,"is_deliver":true,"is_outbound":true,"is_save_collection":true,"save_collection_at":"2025-08-22 17:37:29","is_verify":false,"is_draft":false,"erp_settle_amount":"0","erp_un_settle_amount":"4942","erp_payment_ticket_is_verify":false,"erp_collect_ticket_is_verify":false,"erp_cash_cost_ticket_is_verify":false,"b_date":340,"passed":2,"client":{"id":12,"key":12,"name":"smc(\u4e2d\u56fd)\u6709\u9650\u516c\u53f8\/SMC(\u5317\u4eac)\u5236\u9020\u6709\u9650\u516c\u53f8","logo":"","sales_rep":5300,"salesRep":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91","avatar":{"id":141,"user_id":5300,"name":"\/files\/cdn\/a57be577deb434\/avatar\/14dfd1a0-6df5-354a-8afd-f0a76fa8e852.png"}}},"contractScan":{},"receiptScan":{},"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":4120,"comment":4},"project":{"id":3953,"key":3953,"name":"POCN25085613-8\u53e3POE\u4ea4\u6362\u673a","erpSalesOrder":{"id":1572,"serial_no":"XSDD-20250822-00002","from_date":"","wrote_date":"2025-08-22","handler":5300,"client_id":12,"purchase_contract_id":"","project_id":3953,"sales_contract_id":4120,"erp_store_id":"","status":2,"erp_send_type_id":"","abstract":"","description":"","verify_type":2,"next_verify_user":"","next_stop_verify_user":"","next_cancel_verify_user":"","verify_at":"2025-08-22 17:37:28","stop_at":"2025-08-22 17:46:01.161475+08","cancel_at":"","refuse_description":"","is_resubmitted":false,"is_done":false,"number":"7","amount":"4942","created_by":5300,"stop_description":"","extra":"{\"payment_collection_remind_ahead\":\"1 day\",\"salesContractPaymentCollectionRemindReceivers\":[\"5300\"],\"salesContractPaymentCollectionRemindDates\":[{\"remind_date\":\"2025-09-30\",\"amount\":\"4942\",\"pct\":\"100\"}]}","outbound_status":true,"is_used":true,"is_cancel":false,"is_settle":false,"is_old":false,"created_at":"2025-08-22 16:43:27","updated_at":"2025-08-22 17:49:20","erpSalesOrderVerifyRels":[{"id":10,"erp_sales_order_id":1572,"user_id":1001,"status":1,"description":"","verify_at":"2025-08-22 17:37:28"}],"erpSalesOrderStopVerifyRels":[{"id":12,"erp_sales_order_id":1572,"user_id":1001,"status":1,"description":"","verify_at":"2025-08-22 17:49:20"}]}},"fromProject":{"id":3953,"key":3953,"name":"POCN25085613-8\u53e3POE\u4ea4\u6362\u673a","description":"","total_contact_point":"","paid_contact_point":"","is_sales_order_ready":true,"project_product_version_id":1001,"bargain_date":"2025-08-22","collected":"0","profit_pct":"23.39","budget":"4942","erpSalesOrder":{"id":1572,"serial_no":"XSDD-20250822-00002","from_date":"","wrote_date":"2025-08-22","handler":5300,"client_id":12,"purchase_contract_id":"","project_id":3953,"sales_contract_id":4120,"erp_store_id":"","status":2,"erp_send_type_id":"","abstract":"","description":"","verify_type":2,"next_verify_user":"","next_stop_verify_user":"","next_cancel_verify_user":"","verify_at":"2025-08-22 17:37:28","stop_at":"2025-08-22 17:46:01.161475+08","cancel_at":"","refuse_description":"","is_resubmitted":false,"is_done":false,"number":"7","amount":"4942","created_by":5300,"stop_description":"","extra":"{\"payment_collection_remind_ahead\":\"1 day\",\"salesContractPaymentCollectionRemindReceivers\":[\"5300\"],\"salesContractPaymentCollectionRemindDates\":[{\"remind_date\":\"2025-09-30\",\"amount\":\"4942\",\"pct\":\"100\"}]}","outbound_status":true,"is_used":true,"is_cancel":false,"is_settle":false,"is_old":false,"created_at":"2025-08-22 16:43:27","updated_at":"2025-08-22 17:49:20"},"projectProductTypes":[{"id":6967,"product_type_id":4,"key":4,"name":"\u7f51\u7edc\u8bbe\u5907 ","budget":"4942","pct":"23.39","project_id":3953,"profit":"1155.93"}],"projectProductRels":[{"id":10685,"project_id":3953,"product_id":1613,"amount":"706.00","number":7,"cost":"500.00","description":"","supplier_id":649,"hardware_from":"","software_from":"","maintenance_from":"","hardware_to":"","software_to":"","maintenance_to":"","total_amount":"4942","total_cost":"3500","erp_sales_order_product_id":1862,"supplier":{"id":649,"key":649,"name":"\u5317\u4eac\u4e2d\u6c47\u521b\u4ebf\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8"},"product":{"id":1613,"name":"H3C 1208V-HPWR","product_type":4,"product_component":19,"product_brand":20,"product_serie":1374,"product_misc":"","product_qa":"","pn":"","description":"","created_by":1013,"created_at":"2024-05-11 15:48:33","updated_at":"2025-08-25 16:46:33","pinyin_shortcut":"H3C1208VHPWR","product_unit":1,"is_renew":false,"productType":{"id":4,"key":4,"name":"\u7f51\u7edc\u8bbe\u5907 "},"productComponent":{"id":19,"key":19,"name":"\u4ea4\u6362\u673a"},"productBrand":{"id":20,"key":20,"name":"H3C"},"productSerie":{"id":1374,"key":1374,"name":"H3C 1208V-HPWR \u4ea4\u6362\u673a"},"productUnit":{"id":1,"key":1,"name":"\u53f0"}},"erpSalesOrderProduct":{"id":1862,"erp_sales_order_id":1572,"erp_store_id":"","product_id":1613,"description":"","number":"7","outbound":"7","amount":"706.00","total_amount":"4942","last_number":"7","last_amount":"706.00","last_total_amount":"4942","cost":"500.00","total_cost":"3500","supplier_id":649,"hardware_from":"","software_from":"","maintenance_from":"","hardware_to":"","software_to":"","maintenance_to":""}}],"projectContactPoints":[],"buildSalesOrderItems":[{"id":13290,"project_id":3953},{"id":13289,"project_id":3953},{"id":13288,"project_id":3953},{"id":13287,"project_id":3953},{"id":13286,"project_id":3953},{"id":13285,"project_id":3953},{"id":13284,"project_id":3953}],"reimbursementAmountSum":{},"profit":1155.9338,"contact_points_status_display":"\u672a\u8bbe\u7f6e"},"salesSupplierRels":[{"id":3186,"contract_id":4120,"supplier_id":649,"purchase_id":4121,"supplier":{"id":649,"key":649,"name":"\u5317\u4eac\u4e2d\u6c47\u521b\u4ebf\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8"},"purchase":{"id":4121,"key":4121,"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":{},"serviceContractRemindDates":[],"salesContractRemindReceivers":[],"serviceContractRemindReceivers":[],"salesContractPaymentCollectionRemindReceivers":[{"id":8864,"user_id":5300,"key":5300,"contract_id":4120,"user":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91","sex":"F","avatar":{"id":141,"user_id":5300,"name":"\/files\/cdn\/a57be577deb434\/avatar\/14dfd1a0-6df5-354a-8afd-f0a76fa8e852.png"}}}],"salesContractPaymentCollectionRemindDates":[{"id":2556,"key":2556,"contract_id":4120,"name":"2025-09-30","value":"4942","overdue_days":"","status":0,"pct":100,"collect_status":""}],"salesContractPayments":[],"salesContractInvoices":[],"contractScans":[{"id":48946,"object_type":105,"object_id":4120,"attachment_id":27814,"attachment":{"id":27814,"key":27814,"name":"ddfe4e73-81a9-387e-ab27-f753c1b5f067","extension":"pdf","path":"\/vue\/attachment\/preview\/ddfe4e73-81a9-387e-ab27-f753c1b5f067\/POCN25085613.pdf","orig_name":"POCN25085613.pdf"}}],"receiptScans":[{"id":48942,"object_type":106,"object_id":4120,"attachment_id":27850,"attachment":{"id":27850,"key":27850,"name":"e364b6c5-65fb-3924-b796-ed183aead7c3","extension":"pdf","path":"\/vue\/attachment\/preview\/e364b6c5-65fb-3924-b796-ed183aead7c3\/2025_08_27_08_51_53.pdf","orig_name":"2025_08_27_08_51_53.pdf"}}],"verifyScans":[],"unreadComments":{},"collected_plan":4942,"projectProductTotalAmount":4942,"projectProductAllAmount":true,"projectProductTotalCost":3500,"projectProductAllCost":true,"projectProductTotalCount":7,"invoiced":0,"un_invoiced":4942,"collected":"0","un_collected":4942,"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":true,"can_delete":false,"unread":0,"bgcolor":"#89c541","can_view_product":true,"can_progress":true,"is_chargeback":false,"is_done":false}],"can_create":true,"can_progress":true,"pagenation":{"totalcount":1,"thispage":1,"pagesize":20}},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}],"mod":0}', FALSE, '2025-09-19 09:21:12') RETURNING "id"
09:21:12.336traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
09:21:12.336traceyii\redis\Connection::executeCommandExecuting Redis Command: SET