ConfigurationRequestLogsProfilingDatabaseAsset BundlesMailTimeline
All Latest
6a47ca4222eb8: POST https://beta.jinchangxiao.com/vue/sales-contract/save-edit at 2026-07-03 10:42:10 pm by 111.194.208.14

Log Messages

总计411条数据
TimeLevelCategoryMessage
 
22:42:10.142traceyii\base\Application::bootstrapBootstrap with yii\log\Dispatcher
22:42:10.142traceyii\base\Module::getModuleLoading module: debug
22:42:10.142traceyii\base\Application::bootstrapBootstrap with yii\debug\Module::bootstrap()
22:42:10.143traceyii\redis\Connection::openOpening redis DB connection: redis.server.local:6379, database=1
22:42:10.143traceyii\redis\Connection::executeCommandExecuting Redis Command: SELECT
22:42:10.143traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
22:42:10.144infotime tracing start1783089730144218880
22:42:10.144traceyii\web\UrlManager::parseRequestNo matching URL rules. Using default URL parsing logic.
22:42:10.144traceyii\web\Application::handleRequestRoute requested: 'vue/sales-contract/save-edit'
22:42:10.144traceyii\base\Module::getModuleLoading module: vue
22:42:10.146infoyii\web\Session::openSession started
22:42:10.147infoyii\db\Command::querySELECT * FROM "global"."vw_user_login" WHERE "id"=1001
22:42:10.147infoyii\db\Connection::openOpening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta
22:42:10.149traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
22:42:10.149traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
22:42:10.150traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
22:42:10.150traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
22:42:10.150infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
22:42:10.151traceyii\base\Controller::runActionRoute to run: vue/sales-contract/save-edit
22:42:10.152traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
22:42:10.154traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: Admin
22:42:10.154traceyii\base\InlineAction::runWithParamsRunning action: app\modules\vue\controllers\SalesContractController::actionSaveEdit()
22:42:10.154infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_sales_contracts" WHERE "id"='4486'
22:42:10.155traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
22:42:10.156traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
22:42:10.156traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
22:42:10.157traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
22:42:10.159traceyii\base\Model::onUnsafeAttributeFailed to set unsafe attribute 'id' in 'app\models\SalesContracts'.
22:42:10.159traceyii\base\Model::onUnsafeAttributeFailed to set unsafe attribute 'project_name' in 'app\models\SalesContracts'.
22:42:10.159traceyii\base\Model::onUnsafeAttributeFailed to set unsafe attribute 'budget' in 'app\models\SalesContracts'.
22:42:10.159traceyii\base\Model::onUnsafeAttributeFailed to set unsafe attribute 'profit' in 'app\models\SalesContracts'.
22:42:10.159traceyii\base\Model::onUnsafeAttributeFailed to set unsafe attribute 'profit_pct' in 'app\models\SalesContracts'.
22:42:10.159traceyii\base\Model::onUnsafeAttributeFailed to set unsafe attribute 'project_product_version_id' in 'app\models\SalesContracts'.
22:42:10.159traceyii\base\Model::onUnsafeAttributeFailed to set unsafe attribute 'salesContractPayments' in 'app\models\SalesContracts'.
22:42:10.159traceyii\base\Model::onUnsafeAttributeFailed to set unsafe attribute 'salesContractPaymentCollectionRemindReceivers' in 'app\models\SalesContracts'.
22:42:10.159traceyii\base\Model::onUnsafeAttributeFailed to set unsafe attribute 'client_name' in 'app\models\SalesContracts'.
22:42:10.159traceyii\base\Model::onUnsafeAttributeFailed to set unsafe attribute 'projectContactPoints' in 'app\models\SalesContracts'.
22:42:10.159traceyii\base\Model::onUnsafeAttributeFailed to set unsafe attribute 'projectContactPointRels' in 'app\models\SalesContracts'.
22:42:10.159traceyii\base\Model::onUnsafeAttributeFailed to set unsafe attribute 'contractScans' in 'app\models\SalesContracts'.
22:42:10.159traceyii\base\Model::onUnsafeAttributeFailed to set unsafe attribute 'serviceContractRemindDates' in 'app\models\SalesContracts'.
22:42:10.159traceyii\base\Model::onUnsafeAttributeFailed to set unsafe attribute 'salesSupplierRels' in 'app\models\SalesContracts'.
22:42:10.159traceyii\base\Model::onUnsafeAttributeFailed to set unsafe attribute 'projectProductRels' in 'app\models\SalesContracts'.
22:42:10.159traceyii\base\Model::onUnsafeAttributeFailed to set unsafe attribute 'salesContractInvoices' in 'app\models\SalesContracts'.
22:42:10.159traceyii\base\Model::onUnsafeAttributeFailed to set unsafe attribute 'projectProductTypes' in 'app\models\SalesContracts'.
22:42:10.159traceyii\base\Model::onUnsafeAttributeFailed to set unsafe attribute 'salesContractRemindReceivers' in 'app\models\SalesContracts'.
22:42:10.159traceyii\base\Model::onUnsafeAttributeFailed to set unsafe attribute 'serviceContractRemindReceivers' in 'app\models\SalesContracts'.
22:42:10.160infoyii\db\Command::querySELECT "id" FROM "a57be577deb434"."tbl_sales_contracts" WHERE "serial_no"='2026-06-02-001' LIMIT 2
22:42:10.161infoyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"='3462')
22:42:10.162infoyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_contract_types" WHERE "id"='1')
22:42:10.162infoyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_projects" WHERE "id"='4174')
22:42:10.166infoyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001)
22:42:10.166infoyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001)
22:42:10.167infoyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_projects" WHERE "id"=4174)
22:42:10.167traceyii\db\Transaction::beginBegin transaction
22:42:10.168traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
22:42:10.169traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
22:42:10.169infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_projects" WHERE "id"=4174
22:42:10.170infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_project_product_types" WHERE "project_id"=4174
22:42:10.171traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
22:42:10.171infoyii\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_project_product_types' and d.nspname = 'a57be577deb434' ORDER BY a.attnum;
22:42:10.177infoyii\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_project_product_types' and ns.nspname='a57be577deb434' order by fns.nspname, fc.relname, a.attnum
22:42:10.186traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
22:42:10.186traceyii\redis\Connection::executeCommandExecuting Redis Command: SET
22:42:10.187traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
22:42:10.187infoyii\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_product_types' and d.nspname = 'a57be577deb434' ORDER BY a.attnum;
22:42:10.190infoyii\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_product_types' and ns.nspname='a57be577deb434' order by fns.nspname, fc.relname, a.attnum
22:42:10.199traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
22:42:10.199traceyii\redis\Connection::executeCommandExecuting Redis Command: SET
22:42:10.199infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_product_types" WHERE "id"=5
22:42:10.200infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_product_types" WHERE "id"=7
22:42:10.200infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_product_types" WHERE "id"=7
22:42:10.201infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
22:42:10.202traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
22:42:10.202traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
22:42:10.202infoyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_object_change_logs" ("act", "attribute", "object_id", "object_type", "created_by", "created_at", "new_value", "old_value", "description") VALUES (2, 'projectProductTypes', 4174, 1, 1001, 'now()', '[["\u5b89\u5168\u8bbe\u5907:3399000\u5143 10%","\u8f6f\u4ef6:162000\u5143 10%"]]', '[["\u8f6f\u4ef6:18000\u5143 10%"]]', '{"d1":"\u5218\u4eba\u8bda","d2":"\u66f4\u65b0\u4e86","d3":"\u5546\u673a\u91d1\u989d","d4":["\u8f6f\u4ef6:18000\u5143 10%; <b>\u53d8\u4e3a<\/b> \u5b89\u5168\u8bbe\u5907:3399000\u5143 10%;\u8f6f\u4ef6:162000\u5143 10%;"]}')
22:42:10.216infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"=3462
22:42:10.216traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
22:42:10.217traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
22:42:10.222infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
22:42:10.223traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
22:42:10.223infoyii\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_user_action_logs' and d.nspname = 'a57be577deb434' ORDER BY a.attnum;
22:42:10.228infoyii\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_user_action_logs' and ns.nspname='a57be577deb434' order by fns.nspname, fc.relname, a.attnum
22:42:10.237traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
22:42:10.238traceyii\redis\Connection::executeCommandExecuting Redis Command: SET
22:42:10.238infoyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_user_action_logs" ("act", "attribute", "object_id", "object_type", "created_by", "created_at", "new_value", "old_value", "users", "description") VALUES (2, 'projectProductTypes', 4174, 1, 1001, 'now()', '[["\u5b89\u5168\u8bbe\u5907:3399000\u5143 10%","\u8f6f\u4ef6:162000\u5143 10%"]]', '[["\u8f6f\u4ef6:18000\u5143 10%"]]', array[1001], '{"d1":"\u5218\u4eba\u8bda","d2":"\u66f4\u65b0\u4e86","d3":"\u5546\u673a\u91d1\u989d","d4":["\u8f6f\u4ef6:18000\u5143 10%; <b>\u53d8\u4e3a<\/b> \u5b89\u5168\u8bbe\u5907:3399000\u5143 10%;\u8f6f\u4ef6:162000\u5143 10%;"]}')
22:42:10.252infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_sales_contracts" WHERE "from_project"=4174
22:42:10.254infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
22:42:10.254infoyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_object_change_logs" ("act", "attribute", "object_id", "object_type", "created_by", "created_at", "new_value", "old_value", "description") VALUES (2, 'projectProductTypes', 4486, 7, 1001, 'now()', '[["\u5b89\u5168\u8bbe\u5907:3399000\u5143 10%","\u8f6f\u4ef6:162000\u5143 10%"]]', '[["\u8f6f\u4ef6:18000\u5143 10%"]]', '{"d1":"\u5218\u4eba\u8bda","d2":"\u66f4\u65b0\u4e86","d3":"\u5408\u540c\u91d1\u989d","d4":["\u8f6f\u4ef6:18000\u5143 10%; <b>\u53d8\u4e3a<\/b> \u5b89\u5168\u8bbe\u5907:3399000\u5143 10%;\u8f6f\u4ef6:162000\u5143 10%;"]}')
22:42:10.255infoyii\db\Command::executeDELETE FROM "a57be577deb434"."tbl_project_product_types" WHERE "project_id"=4174
22:42:10.256infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_product_types" WHERE "id"=5
22:42:10.257infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_product_types" WHERE "id"=7
22:42:10.257infoyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_project_product_types" ("project_id", "product_type_id", "name", "budget", "pct", "profit") VALUES (4174, 5, '安全设备', '3399000', 10, '339900'), (4174, 7, '软件', '162000', 10, '16200')
22:42:10.262infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_project_contact_points" WHERE "project_id"=4174
22:42:10.263infoyii\db\Command::executeDELETE FROM "a57be577deb434"."tbl_project_contact_points" WHERE "project_id"=4174
22:42:10.264infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_project_contact_point_rels" WHERE "project_id"=4174
22:42:10.265infoyii\db\Command::querySELECT "id" FROM "a57be577deb434"."tbl_project_contact_point_rels" WHERE "project_id"=4174
22:42:10.265infoyii\db\Command::executeDELETE FROM "a57be577deb434"."tbl_project_contact_point_rels" WHERE 0=1
22:42:10.265infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_project_product_rels" WHERE "project_id"=4174 ORDER BY "id"
22:42:10.266traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
22:42:10.266infoyii\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_project_product_rels' and d.nspname = 'a57be577deb434' ORDER BY a.attnum;
22:42:10.271infoyii\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_project_product_rels' and ns.nspname='a57be577deb434' order by fns.nspname, fc.relname, a.attnum
22:42:10.280traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
22:42:10.280traceyii\redis\Connection::executeCommandExecuting Redis Command: SET
22:42:10.280traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
22:42:10.281traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
22:42:10.281infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_products" WHERE "id"=2171
22:42:10.282infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_product_units" WHERE "id"=2
22:42:10.282traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
22:42:10.282infoyii\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_product_units' and d.nspname = 'a57be577deb434' ORDER BY a.attnum;
22:42:10.286infoyii\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_product_units' and ns.nspname='a57be577deb434' order by fns.nspname, fc.relname, a.attnum
22:42:10.294traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
22:42:10.294traceyii\redis\Connection::executeCommandExecuting Redis Command: SET
22:42:10.294infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_products" WHERE "id"='2171'
22:42:10.295infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_product_units" WHERE "id"=2
22:42:10.296infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_products" WHERE "id"='870'
22:42:10.296infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_product_units" WHERE "id"=8
22:42:10.296infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_products" WHERE "id"='2232'
22:42:10.297infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_product_units" WHERE "id"=2
22:42:10.297infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_products" WHERE "id"='868'
22:42:10.298infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_product_units" WHERE "id"=8
22:42:10.298infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_products" WHERE "id"='2232'
22:42:10.299infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_product_units" WHERE "id"=2
22:42:10.299infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_products" WHERE "id"='870'
22:42:10.300infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_product_units" WHERE "id"=8
22:42:10.300infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
22:42:10.301infoyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_object_change_logs" ("act", "attribute", "object_id", "object_type", "created_by", "created_at", "new_value", "old_value", "description") VALUES (2, 'projectProducts', 4174, 1, 1001, 'now()', '[["\u91d1\u7545\u900dCRM\u8f6f\u4ef6\u670d\u52a1:\u5408\u540c\u5355\u4ef7 18000\u5143 \u6570\u91cf 9\u5957\u5143 \u5907\u6ce8:- \u4f9b\u5e94\u5546 - \u786c\u4ef6\u8d28\u4fdd - \u8f6f\u4ef6\u8d28\u4fdd - \u8fd0\u7ef4\u670d\u52a1 -","LIS-F1000-AK-AV-1Y:\u5408\u540c\u5355\u4ef7 1200\u5143 \u6570\u91cf 9\u5e74\u5143 \u5907\u6ce8:- \u4f9b\u5e94\u5546 - \u786c\u4ef6\u8d28\u4fdd - \u8f6f\u4ef6\u8d28\u4fdd - \u8fd0\u7ef4\u670d\u52a1 -","PAN-SVC-BKLN-3440-3YR:\u5408\u540c\u5355\u4ef7 210375\u5143 \u6570\u91cf 9\u5957\u5143 \u5907\u6ce8:- \u4f9b\u5e94\u5546 - \u786c\u4ef6\u8d28\u4fdd - \u8f6f\u4ef6\u8d28\u4fdd - \u8fd0\u7ef4\u670d\u52a1 -","LIS-F1000-AK-URL-1Y:\u5408\u540c\u5355\u4ef7 1400\u5143 \u6570\u91cf 9\u5e74\u5143 \u5907\u6ce8:- \u4f9b\u5e94\u5546 - \u786c\u4ef6\u8d28\u4fdd - \u8f6f\u4ef6\u8d28\u4fdd - \u8fd0\u7ef4\u670d\u52a1 -","PAN-SVC-BKLN-3440-3YR:\u5408\u540c\u5355\u4ef7 210375\u5143 \u6570\u91cf 7\u5957\u5143 \u5907\u6ce8:- \u4f9b\u5e94\u5546 - \u786c\u4ef6\u8d28\u4fdd - \u8f6f\u4ef6\u8d28\u4fdd - \u8fd0\u7ef4\u670d\u52a1 -","LIS-F1000-AK-AV-1Y:\u5408\u540c\u5355\u4ef7 1200\u5143 \u6570\u91cf 8\u5e74\u5143 \u5907\u6ce8:- \u4f9b\u5e94\u5546 - \u786c\u4ef6\u8d28\u4fdd - \u8f6f\u4ef6\u8d28\u4fdd - \u8fd0\u7ef4\u670d\u52a1 -"]]', '[["\u91d1\u7545\u900dCRM\u8f6f\u4ef6\u670d\u52a1:\u5408\u540c\u5355\u4ef7 18000\u5143 \u6570\u91cf 1\u5957\u5143 \u5907\u6ce8:- \u4f9b\u5e94\u5546 - \u786c\u4ef6\u8d28\u4fdd - \u8f6f\u4ef6\u8d28\u4fdd - \u8fd0\u7ef4\u670d\u52a1 -"]]', '{"d1":"\u5218\u4eba\u8bda","d2":"\u66f4\u65b0\u4e86","d3":"\u4ea7\u54c1\u6e05\u5355","d4":["\u91d1\u7545\u900dCRM\u8f6f\u4ef6\u670d\u52a1:\u5408\u540c\u5355\u4ef7 18000\u5143 \u6570\u91cf 1\u5957\u5143 \u5907\u6ce8:- \u4f9b\u5e94\u5546 - \u786c\u4ef6\u8d28\u4fdd - \u8f6f\u4ef6\u8d28\u4fdd - \u8fd0\u7ef4\u670d\u52a1 -; <b>\u53d8\u4e3a<\/b> \u91d1\u7545\u900dCRM\u8f6f\u4ef6\u670d\u52a1:\u5408\u540c\u5355\u4ef7 18000\u5143 \u6570\u91cf 9\u5957\u5143 \u5907\u6ce8:- \u4f9b\u5e94\u5546 - \u786c\u4ef6\u8d28\u4fdd - \u8f6f\u4ef6\u8d28\u4fdd - \u8fd0\u7ef4\u670d\u52a1 -;LIS-F1000-AK-AV-1Y:\u5408\u540c\u5355\u4ef7 1200\u5143 \u6570\u91cf 9\u5e74\u5143 \u5907\u6ce8:- \u4f9b\u5e94\u5546 - \u786c\u4ef6\u8d28\u4fdd - \u8f6f\u4ef6\u8d28\u4fdd - \u8fd0\u7ef4\u670d\u52a1 -;PAN-SVC-BKLN-3440-3YR:\u5408\u540c\u5355\u4ef7 210375\u5143 \u6570\u91cf 9\u5957\u5143 \u5907\u6ce8:- \u4f9b\u5e94\u5546 - \u786c\u4ef6\u8d28\u4fdd - \u8f6f\u4ef6\u8d28\u4fdd - \u8fd0\u7ef4\u670d\u52a1 -;LIS-F1000-AK-URL-1Y:\u5408\u540c\u5355\u4ef7 1400\u5143 \u6570\u91cf 9\u5e74\u5143 \u5907\u6ce8:- \u4f9b\u5e94\u5546 - \u786c\u4ef6\u8d28\u4fdd - \u8f6f\u4ef6\u8d28\u4fdd - \u8fd0\u7ef4\u670d\u52a1 -;PAN-SVC-BKLN-3440-3YR:\u5408\u540c\u5355\u4ef7 210375\u5143 \u6570\u91cf 7\u5957\u5143 \u5907\u6ce8:- \u4f9b\u5e94\u5546 - \u786c\u4ef6\u8d28\u4fdd - \u8f6f\u4ef6\u8d28\u4fdd - \u8fd0\u7ef4\u670d\u52a1 -;LIS-F1000-AK-AV-1Y:\u5408\u540c\u5355\u4ef7 1200\u5143 \u6570\u91cf 8\u5e74\u5143 \u5907\u6ce8:- \u4f9b\u5e94\u5546 - \u786c\u4ef6\u8d28\u4fdd - \u8f6f\u4ef6\u8d28\u4fdd - \u8fd0\u7ef4\u670d\u52a1 -;"]}')
22:42:10.301infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
22:42:10.302infoyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_user_action_logs" ("act", "attribute", "object_id", "object_type", "created_by", "created_at", "new_value", "old_value", "users", "description") VALUES (2, 'projectProducts', 4174, 1, 1001, 'now()', '[["\u91d1\u7545\u900dCRM\u8f6f\u4ef6\u670d\u52a1:\u5408\u540c\u5355\u4ef7 18000\u5143 \u6570\u91cf 9\u5957\u5143 \u5907\u6ce8:- \u4f9b\u5e94\u5546 - \u786c\u4ef6\u8d28\u4fdd - \u8f6f\u4ef6\u8d28\u4fdd - \u8fd0\u7ef4\u670d\u52a1 -","LIS-F1000-AK-AV-1Y:\u5408\u540c\u5355\u4ef7 1200\u5143 \u6570\u91cf 9\u5e74\u5143 \u5907\u6ce8:- \u4f9b\u5e94\u5546 - \u786c\u4ef6\u8d28\u4fdd - \u8f6f\u4ef6\u8d28\u4fdd - \u8fd0\u7ef4\u670d\u52a1 -","PAN-SVC-BKLN-3440-3YR:\u5408\u540c\u5355\u4ef7 210375\u5143 \u6570\u91cf 9\u5957\u5143 \u5907\u6ce8:- \u4f9b\u5e94\u5546 - \u786c\u4ef6\u8d28\u4fdd - \u8f6f\u4ef6\u8d28\u4fdd - \u8fd0\u7ef4\u670d\u52a1 -","LIS-F1000-AK-URL-1Y:\u5408\u540c\u5355\u4ef7 1400\u5143 \u6570\u91cf 9\u5e74\u5143 \u5907\u6ce8:- \u4f9b\u5e94\u5546 - \u786c\u4ef6\u8d28\u4fdd - \u8f6f\u4ef6\u8d28\u4fdd - \u8fd0\u7ef4\u670d\u52a1 -","PAN-SVC-BKLN-3440-3YR:\u5408\u540c\u5355\u4ef7 210375\u5143 \u6570\u91cf 7\u5957\u5143 \u5907\u6ce8:- \u4f9b\u5e94\u5546 - \u786c\u4ef6\u8d28\u4fdd - \u8f6f\u4ef6\u8d28\u4fdd - \u8fd0\u7ef4\u670d\u52a1 -","LIS-F1000-AK-AV-1Y:\u5408\u540c\u5355\u4ef7 1200\u5143 \u6570\u91cf 8\u5e74\u5143 \u5907\u6ce8:- \u4f9b\u5e94\u5546 - \u786c\u4ef6\u8d28\u4fdd - \u8f6f\u4ef6\u8d28\u4fdd - \u8fd0\u7ef4\u670d\u52a1 -"]]', '[["\u91d1\u7545\u900dCRM\u8f6f\u4ef6\u670d\u52a1:\u5408\u540c\u5355\u4ef7 18000\u5143 \u6570\u91cf 1\u5957\u5143 \u5907\u6ce8:- \u4f9b\u5e94\u5546 - \u786c\u4ef6\u8d28\u4fdd - \u8f6f\u4ef6\u8d28\u4fdd - \u8fd0\u7ef4\u670d\u52a1 -"]]', array[1001], '{"d1":"\u5218\u4eba\u8bda","d2":"\u66f4\u65b0\u4e86","d3":"\u4ea7\u54c1\u6e05\u5355","d4":["\u91d1\u7545\u900dCRM\u8f6f\u4ef6\u670d\u52a1:\u5408\u540c\u5355\u4ef7 18000\u5143 \u6570\u91cf 1\u5957\u5143 \u5907\u6ce8:- \u4f9b\u5e94\u5546 - \u786c\u4ef6\u8d28\u4fdd - \u8f6f\u4ef6\u8d28\u4fdd - \u8fd0\u7ef4\u670d\u52a1 -; <b>\u53d8\u4e3a<\/b> \u91d1\u7545\u900dCRM\u8f6f\u4ef6\u670d\u52a1:\u5408\u540c\u5355\u4ef7 18000\u5143 \u6570\u91cf 9\u5957\u5143 \u5907\u6ce8:- \u4f9b\u5e94\u5546 - \u786c\u4ef6\u8d28\u4fdd - \u8f6f\u4ef6\u8d28\u4fdd - \u8fd0\u7ef4\u670d\u52a1 -;LIS-F1000-AK-AV-1Y:\u5408\u540c\u5355\u4ef7 1200\u5143 \u6570\u91cf 9\u5e74\u5143 \u5907\u6ce8:- \u4f9b\u5e94\u5546 - \u786c\u4ef6\u8d28\u4fdd - \u8f6f\u4ef6\u8d28\u4fdd - \u8fd0\u7ef4\u670d\u52a1 -;PAN-SVC-BKLN-3440-3YR:\u5408\u540c\u5355\u4ef7 210375\u5143 \u6570\u91cf 9\u5957\u5143 \u5907\u6ce8:- \u4f9b\u5e94\u5546 - \u786c\u4ef6\u8d28\u4fdd - \u8f6f\u4ef6\u8d28\u4fdd - \u8fd0\u7ef4\u670d\u52a1 -;LIS-F1000-AK-URL-1Y:\u5408\u540c\u5355\u4ef7 1400\u5143 \u6570\u91cf 9\u5e74\u5143 \u5907\u6ce8:- \u4f9b\u5e94\u5546 - \u786c\u4ef6\u8d28\u4fdd - \u8f6f\u4ef6\u8d28\u4fdd - \u8fd0\u7ef4\u670d\u52a1 -;PAN-SVC-BKLN-3440-3YR:\u5408\u540c\u5355\u4ef7 210375\u5143 \u6570\u91cf 7\u5957\u5143 \u5907\u6ce8:- \u4f9b\u5e94\u5546 - \u786c\u4ef6\u8d28\u4fdd - \u8f6f\u4ef6\u8d28\u4fdd - \u8fd0\u7ef4\u670d\u52a1 -;LIS-F1000-AK-AV-1Y:\u5408\u540c\u5355\u4ef7 1200\u5143 \u6570\u91cf 8\u5e74\u5143 \u5907\u6ce8:- \u4f9b\u5e94\u5546 - \u786c\u4ef6\u8d28\u4fdd - \u8f6f\u4ef6\u8d28\u4fdd - \u8fd0\u7ef4\u670d\u52a1 -;"]}')
22:42:10.303infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_sales_contracts" WHERE "id"=4486
22:42:10.303infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_sales_orders" WHERE "sales_contract_id"=4486 ORDER BY "id" DESC
22:42:10.305traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
22:42:10.305traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
22:42:10.305infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
22:42:10.306infoyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_object_change_logs" ("act", "attribute", "object_id", "object_type", "created_by", "created_at", "new_value", "old_value", "description") VALUES (2, 'erpSalesOrderProducts', 1711, 20007, 1001, 'now()', '[["\u91d1\u7545\u900dCRM\u8f6f\u4ef6\u670d\u52a1:\u5408\u540c\u5355\u4ef7 18000\u5143 \u6570\u91cf 9\u5957\u5143 \u5907\u6ce8:- \u4f9b\u5e94\u5546 - \u786c\u4ef6\u8d28\u4fdd - \u8f6f\u4ef6\u8d28\u4fdd - \u8fd0\u7ef4\u670d\u52a1 -","LIS-F1000-AK-AV-1Y:\u5408\u540c\u5355\u4ef7 1200\u5143 \u6570\u91cf 9\u5e74\u5143 \u5907\u6ce8:- \u4f9b\u5e94\u5546 - \u786c\u4ef6\u8d28\u4fdd - \u8f6f\u4ef6\u8d28\u4fdd - \u8fd0\u7ef4\u670d\u52a1 -","PAN-SVC-BKLN-3440-3YR:\u5408\u540c\u5355\u4ef7 210375\u5143 \u6570\u91cf 9\u5957\u5143 \u5907\u6ce8:- \u4f9b\u5e94\u5546 - \u786c\u4ef6\u8d28\u4fdd - \u8f6f\u4ef6\u8d28\u4fdd - \u8fd0\u7ef4\u670d\u52a1 -","LIS-F1000-AK-URL-1Y:\u5408\u540c\u5355\u4ef7 1400\u5143 \u6570\u91cf 9\u5e74\u5143 \u5907\u6ce8:- \u4f9b\u5e94\u5546 - \u786c\u4ef6\u8d28\u4fdd - \u8f6f\u4ef6\u8d28\u4fdd - \u8fd0\u7ef4\u670d\u52a1 -","PAN-SVC-BKLN-3440-3YR:\u5408\u540c\u5355\u4ef7 210375\u5143 \u6570\u91cf 7\u5957\u5143 \u5907\u6ce8:- \u4f9b\u5e94\u5546 - \u786c\u4ef6\u8d28\u4fdd - \u8f6f\u4ef6\u8d28\u4fdd - \u8fd0\u7ef4\u670d\u52a1 -","LIS-F1000-AK-AV-1Y:\u5408\u540c\u5355\u4ef7 1200\u5143 \u6570\u91cf 8\u5e74\u5143 \u5907\u6ce8:- \u4f9b\u5e94\u5546 - \u786c\u4ef6\u8d28\u4fdd - \u8f6f\u4ef6\u8d28\u4fdd - \u8fd0\u7ef4\u670d\u52a1 -"]]', '[["\u91d1\u7545\u900dCRM\u8f6f\u4ef6\u670d\u52a1:\u5408\u540c\u5355\u4ef7 18000\u5143 \u6570\u91cf 1\u5957\u5143 \u5907\u6ce8:- \u4f9b\u5e94\u5546 - \u786c\u4ef6\u8d28\u4fdd - \u8f6f\u4ef6\u8d28\u4fdd - \u8fd0\u7ef4\u670d\u52a1 -"]]', '{"d1":"\u5218\u4eba\u8bda","d2":"\u66f4\u65b0\u4e86","d3":"\u4ea7\u54c1\u6e05\u5355","d4":["\u91d1\u7545\u900dCRM\u8f6f\u4ef6\u670d\u52a1:\u5408\u540c\u5355\u4ef7 18000\u5143 \u6570\u91cf 1\u5957\u5143 \u5907\u6ce8:- \u4f9b\u5e94\u5546 - \u786c\u4ef6\u8d28\u4fdd - \u8f6f\u4ef6\u8d28\u4fdd - \u8fd0\u7ef4\u670d\u52a1 -; <b>\u53d8\u4e3a<\/b> \u91d1\u7545\u900dCRM\u8f6f\u4ef6\u670d\u52a1:\u5408\u540c\u5355\u4ef7 18000\u5143 \u6570\u91cf 9\u5957\u5143 \u5907\u6ce8:- \u4f9b\u5e94\u5546 - \u786c\u4ef6\u8d28\u4fdd - \u8f6f\u4ef6\u8d28\u4fdd - \u8fd0\u7ef4\u670d\u52a1 -;LIS-F1000-AK-AV-1Y:\u5408\u540c\u5355\u4ef7 1200\u5143 \u6570\u91cf 9\u5e74\u5143 \u5907\u6ce8:- \u4f9b\u5e94\u5546 - \u786c\u4ef6\u8d28\u4fdd - \u8f6f\u4ef6\u8d28\u4fdd - \u8fd0\u7ef4\u670d\u52a1 -;PAN-SVC-BKLN-3440-3YR:\u5408\u540c\u5355\u4ef7 210375\u5143 \u6570\u91cf 9\u5957\u5143 \u5907\u6ce8:- \u4f9b\u5e94\u5546 - \u786c\u4ef6\u8d28\u4fdd - \u8f6f\u4ef6\u8d28\u4fdd - \u8fd0\u7ef4\u670d\u52a1 -;LIS-F1000-AK-URL-1Y:\u5408\u540c\u5355\u4ef7 1400\u5143 \u6570\u91cf 9\u5e74\u5143 \u5907\u6ce8:- \u4f9b\u5e94\u5546 - \u786c\u4ef6\u8d28\u4fdd - \u8f6f\u4ef6\u8d28\u4fdd - \u8fd0\u7ef4\u670d\u52a1 -;PAN-SVC-BKLN-3440-3YR:\u5408\u540c\u5355\u4ef7 210375\u5143 \u6570\u91cf 7\u5957\u5143 \u5907\u6ce8:- \u4f9b\u5e94\u5546 - \u786c\u4ef6\u8d28\u4fdd - \u8f6f\u4ef6\u8d28\u4fdd - \u8fd0\u7ef4\u670d\u52a1 -;LIS-F1000-AK-AV-1Y:\u5408\u540c\u5355\u4ef7 1200\u5143 \u6570\u91cf 8\u5e74\u5143 \u5907\u6ce8:- \u4f9b\u5e94\u5546 - \u786c\u4ef6\u8d28\u4fdd - \u8f6f\u4ef6\u8d28\u4fdd - \u8fd0\u7ef4\u670d\u52a1 -;"]}')
22:42:10.308infoyii\db\Command::querySELECT "id" FROM "a57be577deb434"."tbl_project_product_rels" WHERE "project_id"=4174
22:42:10.308infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_project_product_rels" WHERE "id"=12138
22:42:10.310infoyii\db\Command::executeUPDATE "a57be577deb434"."tbl_project_product_rels" SET "product_id"=2171, "amount"='18000', "number"=9, "supplier_id"=NULL, "hardware_from"=NULL, "software_from"=NULL, "maintenance_from"=NULL, "hardware_to"=NULL, "software_to"=NULL, "maintenance_to"=NULL, "total_amount"='162000' WHERE "id"=12138
22:42:10.311traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
22:42:10.312traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
22:42:10.312infoyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\ProjectProductRels', 12138, 'a:2:{s:6:"number";s:1:"9";s:12:"total_amount";s:6:"162000";}', '', 1001, '111.194.208.14')
22:42:10.329infoyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_project_product_rels" ("project_id", "product_id", "amount", "number", "total_amount", "description", "supplier_id", "hardware_from", "software_from", "maintenance_from", "hardware_to", "software_to", "maintenance_to") VALUES (4174, 870, '1200', 9, '10800', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL), (4174, 2232, '210375', 9, '1893375', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL), (4174, 868, '1400', 9, '12600', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL), (4174, 2232, '210375', 7, '1472625', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL), (4174, 870, '1200', 8, '9600', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL)
22:42:10.333infoyii\db\Command::executeDELETE FROM "a57be577deb434"."tbl_project_product_rels" WHERE 0=1
22:42:10.944infoyii\db\Command::executeUPDATE "a57be577deb434"."tbl_projects" SET "budget"='3561000', "profit_pct"='10', "project_product_version_id"=NULL WHERE "id"=4174
22:42:10.950infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_project_change_logs" WHERE ("project_id"=4174) AND ("end_at" IS NULL) ORDER BY "id" DESC LIMIT 1
22:42:10.965traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
22:42:10.965infoyii\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_project_change_logs' and d.nspname = 'a57be577deb434' ORDER BY a.attnum;
22:42:10.969infoyii\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_project_change_logs' and ns.nspname='a57be577deb434' order by fns.nspname, fc.relname, a.attnum
22:42:10.978traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
22:42:10.978traceyii\redis\Connection::executeCommandExecuting Redis Command: SET
22:42:10.979infoyii\db\Command::executeUPDATE "a57be577deb434"."tbl_project_change_logs" SET "end_at"='now()' WHERE "id"=17878
22:42:10.983infoyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\ProjectChangeLogs', 17878, 'a:1:{s:6:"end_at";s:19:"1970-01-01 08:00:00";}', '', 1001, '111.194.208.14')
22:42:10.984infoyii\db\Command::queryINSERT INTO "a57be577deb434"."tbl_project_change_logs" ("project_id", "project_status", "budget", "profit_pct", "collected", "start_from", "end_at") VALUES (4174, 3, '3561000', '10', '0', 'now()', NULL) RETURNING "id"
22:42:10.991infoyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('INSERT', 'app\models\ProjectChangeLogs', 17882, 'a:8:{s:2:"id";i:17882;s:10:"project_id";i:4174;s:14:"project_status";i:3;s:6:"budget";d:3561000;s:10:"profit_pct";d:10;s:9:"collected";s:1:"0";s:10:"start_from";s:5:"now()";s:6:"end_at";N;}', '', 1001, '111.194.208.14')
22:42:10.992infoyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\Projects', 4174, 'a:2:{s:6:"budget";d:3561000;s:26:"project_product_version_id";i:1379;}', '', 1001, '111.194.208.14')
22:42:10.992infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"=3462
22:42:10.993infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_projects" WHERE "id"=4174
22:42:10.994infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_project_product_rels" WHERE "project_id"=4174 ORDER BY "id"
22:42:10.997traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
22:42:10.997infoyii\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_project_product_versions' and d.nspname = 'a57be577deb434' ORDER BY a.attnum;
22:42:11.001infoyii\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_project_product_versions' and ns.nspname='a57be577deb434' order by fns.nspname, fc.relname, a.attnum
22:42:11.009traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
22:42:11.009traceyii\redis\Connection::executeCommandExecuting Redis Command: SET
22:42:11.009infoyii\db\Command::queryINSERT INTO "a57be577deb434"."tbl_project_product_versions" ("project_id", "created_by", "created_at") VALUES (4174, 1001, '2026-07-03 22:42:10') RETURNING "id"
22:42:11.013infoyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('INSERT', 'app\models\ProjectProductVersions', 1380, 'a:4:{s:2:"id";i:1380;s:10:"project_id";i:4174;s:10:"created_by";i:1001;s:10:"created_at";s:19:"2026-07-03 22:42:10";}', '', 1001, '111.194.208.14')
22:42:11.014infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
22:42:11.015infoyii\db\Command::queryINSERT INTO "a57be577deb434"."tbl_object_change_logs" ("act", "attribute", "object_id", "object_type", "target_id", "target_object_type", "created_by", "new_value", "old_value", "description") VALUES (1, 'create', 4174, 1, 1380, 112, 1001, '[1380]', '[1380]', '{"d1":"\u5218\u4eba\u8bda","d2":"\u521b\u5efa\u4e86","d3":"\u4ea7\u54c1\u5386\u53f2\u62a5\u4ef7\u6e05\u5355","d4":["2026-07-03 22:42\u4ea7\u54c1\u5386\u53f2\u62a5\u4ef7\u6e05\u5355"]}') RETURNING "id"
22:42:11.015infoyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('INSERT', 'app\models\ObjectChangeLogs', 643153, 'a:13:{s:2:"id";i:643153;s:9:"object_id";i:4174;s:11:"object_type";i:1;s:9:"target_id";i:1380;s:18:"target_object_type";i:112;s:3:"act";i:1;s:9:"attribute";s:6:"create";s:9:"old_value";s:6:"[1380]";s:9:"new_value";s:6:"[1380]";s:11:"description";s:183:"{"d1":"\u5218\u4eba\u8bda","d2":"\u521b\u5efa\u4e86","d3":"\u4ea7\u54c1\u5386\u53f2\u62a5\u4ef7\u6e05\u5355","d4":["2026-07-03 22:42\u4ea7\u54c1\u5386\u53f2\u62a5\u4ef7\u6e05\u5355"]}";s:10:"created_by";i:1001;s:10:"created_at";N;s:9:"is_delete";N;}', '', 1001, '111.194.208.14')
22:42:11.016infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_sales_contracts" WHERE "from_project"=4174
22:42:11.017infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
22:42:11.018infoyii\db\Command::queryINSERT INTO "a57be577deb434"."tbl_object_change_logs" ("act", "attribute", "object_id", "object_type", "target_id", "target_object_type", "created_by", "new_value", "old_value", "description") VALUES (1, 'create', 4486, 7, 4174, 112, 1001, '[4174]', '[4174]', '{"d1":"\u5218\u4eba\u8bda","d2":"\u521b\u5efa\u4e86","d3":"\u4ea7\u54c1\u5386\u53f2\u62a5\u4ef7\u6e05\u5355","d4":["2026-07-03 22:42\u4ea7\u54c1\u5386\u53f2\u62a5\u4ef7\u6e05\u5355"]}') RETURNING "id"
22:42:11.018infoyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('INSERT', 'app\models\ObjectChangeLogs', 643154, 'a:13:{s:2:"id";i:643154;s:9:"object_id";i:4486;s:11:"object_type";i:7;s:9:"target_id";i:4174;s:18:"target_object_type";i:112;s:3:"act";i:1;s:9:"attribute";s:6:"create";s:9:"old_value";s:6:"[4174]";s:9:"new_value";s:6:"[4174]";s:11:"description";s:183:"{"d1":"\u5218\u4eba\u8bda","d2":"\u521b\u5efa\u4e86","d3":"\u4ea7\u54c1\u5386\u53f2\u62a5\u4ef7\u6e05\u5355","d4":["2026-07-03 22:42\u4ea7\u54c1\u5386\u53f2\u62a5\u4ef7\u6e05\u5355"]}";s:10:"created_by";i:1001;s:10:"created_at";N;s:9:"is_delete";N;}', '', 1001, '111.194.208.14')
22:42:11.020infoyii\db\Command::executeUPDATE "a57be577deb434"."tbl_projects" SET "project_product_version_id"=1380 WHERE "id"=4174
22:42:11.022infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_project_change_logs" WHERE ("project_id"=4174) AND ("end_at" IS NULL) ORDER BY "id" DESC LIMIT 1
22:42:11.024infoyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\Projects', 4174, 'a:1:{s:26:"project_product_version_id";i:1380;}', '', 1001, '111.194.208.14')
22:42:11.024infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"=3462
22:42:11.026traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
22:42:11.027infoyii\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_project_product_version_rels' and d.nspname = 'a57be577deb434' ORDER BY a.attnum;
22:42:11.031infoyii\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_project_product_version_rels' and ns.nspname='a57be577deb434' order by fns.nspname, fc.relname, a.attnum
22:42:11.039traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
22:42:11.040traceyii\redis\Connection::executeCommandExecuting Redis Command: SET
22:42:11.040infoyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_project_product_version_rels" ("project_product_version_id", "product_id", "amount", "number", "total_amount", "description", "supplier_id", "hardware_from", "software_from", "maintenance_from", "hardware_to", "software_to", "maintenance_to") VALUES (1380, 2171, '18000', 9, '162000', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL), (1380, 870, '1200', 9, '10800', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL), (1380, 2232, '210375', 9, '1893375', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL), (1380, 868, '1400', 9, '12600', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL), (1380, 2232, '210375', 7, '1472625', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL), (1380, 870, '1200', 8, '9600', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL)
22:42:11.049infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_projects" WHERE "id"=4174
22:42:11.050infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_project_product_rels" WHERE "project_id"=4174 ORDER BY "id"
22:42:11.051infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_sales_order_items" WHERE ("project_id"=4174) AND (erp_sales_outbound_id is not null)
22:42:11.060infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_project_change_logs" WHERE ("project_id"=4174) AND ("end_at" IS NULL) ORDER BY "id" DESC LIMIT 1
22:42:11.063infoyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\Projects', 4174, 'a:0:{}', '', 1001, '111.194.208.14')
22:42:11.063infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"=3462
22:42:11.064infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_sales_orders" WHERE "sales_contract_id"=4486 ORDER BY "id" DESC
22:42:11.065infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
22:42:11.066infoyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_object_change_logs" ("act", "attribute", "object_id", "object_type", "created_by", "created_at", "new_value", "old_value", "description") VALUES (2, 'number', 1711, 20007, 1001, 'now()', '[51]', '["1"]', '{"d1":"\u5218\u4eba\u8bda","d2":"\u66f4\u65b0\u4e86","d3":"\u4ea7\u54c1\u6570\u91cf","d4":["1 <b>\u53d8\u4e3a<\/b> 51"]}'), (2, 'amount', 1711, 20007, 1001, 'now()', '[3561000]', '["18000"]', '{"d1":"\u5218\u4eba\u8bda","d2":"\u66f4\u65b0\u4e86","d3":"\u4ea7\u54c1\u91d1\u989d","d4":["18000 <b>\u53d8\u4e3a<\/b> 3561000"]}')
22:42:11.067infoyii\db\Command::executeUPDATE "a57be577deb434"."tbl_erp_sales_orders" SET "number"='51', "amount"='3561000' WHERE "id"=1711
22:42:11.068infoyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\ErpSalesOrders', 1711, 'a:2:{s:6:"number";d:51;s:6:"amount";d:3561000;}', '', 1001, '111.194.208.14')
22:42:11.068infoyii\db\Command::executeUPDATE "a57be577deb434"."tbl_sales_contracts" SET "client_id"=3462, "amount"='3561000', "updated_at"='now()', "contract_scan"=NULL, "receipt_scan"=NULL, "contract_type"=1, "project_id"=4174, "expire_date"=NULL, "remind_ahead"='0 day', "expire_remind_ahead"='0 day', "including_tax"=TRUE, "is_settle"=FALSE, "is_deliver"=FALSE, "is_outbound"=FALSE, "is_draft"=TRUE WHERE "id"=4486
22:42:11.069infoyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\SalesContracts', 4486, 'a:3:{s:12:"remind_ahead";s:5:"0 day";s:19:"expire_remind_ahead";s:5:"0 day";s:6:"amount";d:3561000;}', '', 1001, '111.194.208.14')
22:42:11.070infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"='3462'
22:42:11.070infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_projects" WHERE "id"='4174'
22:42:11.071infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_project_product_rels" WHERE "project_id"=4174 ORDER BY "id"
22:42:11.072traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
22:42:11.072infoyii\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_erp_sales_order_verify_rels' and d.nspname = 'a57be577deb434' ORDER BY a.attnum;
22:42:11.076infoyii\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_erp_sales_order_verify_rels' and ns.nspname='a57be577deb434' order by fns.nspname, fc.relname, a.attnum
22:42:11.084traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
22:42:11.085traceyii\redis\Connection::executeCommandExecuting Redis Command: SET
22:42:11.085infoyii\db\Command::executeUPDATE "a57be577deb434"."tbl_erp_sales_order_verify_rels" SET "status"=3 WHERE ("erp_sales_order_id"=1711) AND ("status"=0)
22:42:11.086infoyii\db\Command::executeDELETE FROM "a57be577deb434"."tbl_erp_sales_order_stop_verify_rels" WHERE "erp_sales_order_id"=1711
22:42:11.086infoyii\db\Command::executeDELETE FROM "a57be577deb434"."tbl_erp_sales_order_stop_products" WHERE "erp_sales_order_id"=1711
22:42:11.087infoyii\db\Command::executeUPDATE "a57be577deb434"."tbl_erp_sales_orders" SET "stop_at"='now()' WHERE "id"=1711
22:42:11.088infoyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\ErpSalesOrders', 1711, 'a:1:{s:7:"stop_at";s:5:"now()";}', '', 1001, '111.194.208.14')
22:42:11.088traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
22:42:11.089infoyii\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_erp_sales_order_stop_products' and d.nspname = 'a57be577deb434' ORDER BY a.attnum;
22:42:11.092infoyii\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_erp_sales_order_stop_products' and ns.nspname='a57be577deb434' order by fns.nspname, fc.relname, a.attnum
22:42:11.101traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
22:42:11.101traceyii\redis\Connection::executeCommandExecuting Redis Command: SET
22:42:11.101infoyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_erp_sales_order_stop_products" ("erp_sales_order_id", "erp_sales_order_product_id", "product_id", "amount", "total_amount", "number", "description", "supplier_id", "hardware_from", "software_from", "maintenance_from", "hardware_to", "software_to", "maintenance_to") VALUES (1711, NULL, 2171, '18000', '162000', '9', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL), (1711, NULL, 870, '1200', '10800', '9', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL), (1711, NULL, 2232, '210375', '1893375', '9', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL), (1711, NULL, 868, '1400', '12600', '9', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL), (1711, NULL, 2232, '210375', '1472625', '7', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL), (1711, NULL, 870, '1200', '9600', '8', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL)
22:42:11.124traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
22:42:11.124traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
22:42:11.124infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_verify_processes" WHERE "id"=6
22:42:11.125infoyii\db\Command::execute
22:42:11.126infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_sales_order_stop_verify_rels" WHERE ("erp_sales_order_id"=1711) AND ("status"=0) ORDER BY "id"
22:42:11.126infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
22:42:11.127infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_sales_order_stop_verify_rels" WHERE ("status"=0) AND ("erp_sales_order_id"=1711) ORDER BY "id"
22:42:11.128infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_sales_order_carbon_copy_rels" WHERE "erp_sales_order_id"=1711
22:42:11.128infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_sales_order_verify_rels" WHERE "erp_sales_order_id"=1711 ORDER BY "id"
22:42:11.129traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
22:42:11.129traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
22:42:11.129infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_sales_orders" WHERE "id"=1711
22:42:11.130infoyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001)
22:42:11.131infoyii\db\Command::queryINSERT INTO "a57be577deb434"."tbl_comments" ("created_by", "object_type", "object_id", "description", "is_system", "description2") VALUES (1001, '20007', 1711, '刘人诚通过了这个审批', TRUE, 'XSDD-20260602-00001') RETURNING "id"
22:42:11.132infoyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('INSERT', 'app\models\Comments', 221016, 'a:11:{s:2:"id";i:221016;s:9:"object_id";i:1711;s:11:"object_type";s:5:"20007";s:6:"parent";N;s:11:"description";s:30:"刘人诚通过了这个审批";s:10:"created_by";i:1001;s:10:"created_at";N;s:8:"reply_to";N;s:9:"is_system";b:1;s:8:"for_user";N;s:12:"description2";s:19:"XSDD-20260602-00001";}', '', 1001, '111.194.208.14')
22:42:11.132infoyii\db\Command::querySELECT "channel_id" FROM "global"."tbl_logins" WHERE (0=1) AND ("id" != 1001) AND (channel_id IS NOT NULL)
22:42:11.133infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"=3462
22:42:11.134infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_projects" WHERE "id"=4174
22:42:11.135traceyii\redis\Connection::executeCommandExecuting Redis Command: INCR
22:42:11.135traceyii\redis\Connection::executeCommandExecuting Redis Command: HSET
22:42:11.135traceyii\redis\Connection::executeCommandExecuting Redis Command: LPUSH
22:42:11.135infoyii\db\Command::executeUPDATE "a57be577deb434"."tbl_erp_sales_orders" SET "status"=2, "next_stop_verify_user"=NULL, "updated_at"='now()' WHERE "id"=1711
22:42:11.136infoyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\ErpSalesOrders', 1711, 'a:1:{s:6:"status";i:5;}', '', 1001, '111.194.208.14')
22:42:11.137infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_sales_order_stop_products" WHERE "erp_sales_order_id"=1711
22:42:11.138traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
22:42:11.138traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
22:42:11.138infoyii\db\Command::queryINSERT INTO "a57be577deb434"."tbl_erp_sales_order_products" ("erp_sales_order_id", "product_id", "number", "amount", "total_amount", "description", "supplier_id", "hardware_from", "software_from", "maintenance_from", "hardware_to", "software_to", "maintenance_to") VALUES (1711, 2171, '9', '18000', '162000', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL) RETURNING "id"
22:42:11.144infoyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('INSERT', 'app\models\ErpSalesOrderProducts', 2260, 'a:21:{s:2:"id";i:2260;s:18:"erp_sales_order_id";i:1711;s:12:"erp_store_id";N;s:10:"product_id";i:2171;s:11:"description";s:0:"";s:6:"number";s:1:"9";s:8:"outbound";N;s:6:"amount";s:5:"18000";s:12:"total_amount";s:6:"162000";s:11:"last_number";N;s:11:"last_amount";N;s:17:"last_total_amount";N;s:4:"cost";N;s:10:"total_cost";N;s:11:"supplier_id";N;s:13:"hardware_from";N;s:13:"software_from";N;s:16:"maintenance_from";N;s:11:"hardware_to";N;s:11:"software_to";N;s:14:"maintenance_to";N;}', '', 1001, '111.194.208.14')
22:42:11.144infoyii\db\Command::queryINSERT INTO "a57be577deb434"."tbl_erp_sales_order_products" ("erp_sales_order_id", "product_id", "number", "amount", "total_amount", "description", "supplier_id", "hardware_from", "software_from", "maintenance_from", "hardware_to", "software_to", "maintenance_to") VALUES (1711, 870, '9', '1200', '10800', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL) RETURNING "id"
22:42:11.145infoyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('INSERT', 'app\models\ErpSalesOrderProducts', 2261, 'a:21:{s:2:"id";i:2261;s:18:"erp_sales_order_id";i:1711;s:12:"erp_store_id";N;s:10:"product_id";i:870;s:11:"description";s:0:"";s:6:"number";s:1:"9";s:8:"outbound";N;s:6:"amount";s:4:"1200";s:12:"total_amount";s:5:"10800";s:11:"last_number";N;s:11:"last_amount";N;s:17:"last_total_amount";N;s:4:"cost";N;s:10:"total_cost";N;s:11:"supplier_id";N;s:13:"hardware_from";N;s:13:"software_from";N;s:16:"maintenance_from";N;s:11:"hardware_to";N;s:11:"software_to";N;s:14:"maintenance_to";N;}', '', 1001, '111.194.208.14')
22:42:11.146infoyii\db\Command::queryINSERT INTO "a57be577deb434"."tbl_erp_sales_order_products" ("erp_sales_order_id", "product_id", "number", "amount", "total_amount", "description", "supplier_id", "hardware_from", "software_from", "maintenance_from", "hardware_to", "software_to", "maintenance_to") VALUES (1711, 2232, '9', '210375', '1893375', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL) RETURNING "id"
22:42:11.146infoyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('INSERT', 'app\models\ErpSalesOrderProducts', 2262, 'a:21:{s:2:"id";i:2262;s:18:"erp_sales_order_id";i:1711;s:12:"erp_store_id";N;s:10:"product_id";i:2232;s:11:"description";s:0:"";s:6:"number";s:1:"9";s:8:"outbound";N;s:6:"amount";s:6:"210375";s:12:"total_amount";s:7:"1893375";s:11:"last_number";N;s:11:"last_amount";N;s:17:"last_total_amount";N;s:4:"cost";N;s:10:"total_cost";N;s:11:"supplier_id";N;s:13:"hardware_from";N;s:13:"software_from";N;s:16:"maintenance_from";N;s:11:"hardware_to";N;s:11:"software_to";N;s:14:"maintenance_to";N;}', '', 1001, '111.194.208.14')
22:42:11.147infoyii\db\Command::queryINSERT INTO "a57be577deb434"."tbl_erp_sales_order_products" ("erp_sales_order_id", "product_id", "number", "amount", "total_amount", "description", "supplier_id", "hardware_from", "software_from", "maintenance_from", "hardware_to", "software_to", "maintenance_to") VALUES (1711, 868, '9', '1400', '12600', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL) RETURNING "id"
22:42:11.147infoyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('INSERT', 'app\models\ErpSalesOrderProducts', 2263, 'a:21:{s:2:"id";i:2263;s:18:"erp_sales_order_id";i:1711;s:12:"erp_store_id";N;s:10:"product_id";i:868;s:11:"description";s:0:"";s:6:"number";s:1:"9";s:8:"outbound";N;s:6:"amount";s:4:"1400";s:12:"total_amount";s:5:"12600";s:11:"last_number";N;s:11:"last_amount";N;s:17:"last_total_amount";N;s:4:"cost";N;s:10:"total_cost";N;s:11:"supplier_id";N;s:13:"hardware_from";N;s:13:"software_from";N;s:16:"maintenance_from";N;s:11:"hardware_to";N;s:11:"software_to";N;s:14:"maintenance_to";N;}', '', 1001, '111.194.208.14')
22:42:11.148infoyii\db\Command::queryINSERT INTO "a57be577deb434"."tbl_erp_sales_order_products" ("erp_sales_order_id", "product_id", "number", "amount", "total_amount", "description", "supplier_id", "hardware_from", "software_from", "maintenance_from", "hardware_to", "software_to", "maintenance_to") VALUES (1711, 2232, '7', '210375', '1472625', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL) RETURNING "id"
22:42:11.149infoyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('INSERT', 'app\models\ErpSalesOrderProducts', 2264, 'a:21:{s:2:"id";i:2264;s:18:"erp_sales_order_id";i:1711;s:12:"erp_store_id";N;s:10:"product_id";i:2232;s:11:"description";s:0:"";s:6:"number";s:1:"7";s:8:"outbound";N;s:6:"amount";s:6:"210375";s:12:"total_amount";s:7:"1472625";s:11:"last_number";N;s:11:"last_amount";N;s:17:"last_total_amount";N;s:4:"cost";N;s:10:"total_cost";N;s:11:"supplier_id";N;s:13:"hardware_from";N;s:13:"software_from";N;s:16:"maintenance_from";N;s:11:"hardware_to";N;s:11:"software_to";N;s:14:"maintenance_to";N;}', '', 1001, '111.194.208.14')
22:42:11.149infoyii\db\Command::queryINSERT INTO "a57be577deb434"."tbl_erp_sales_order_products" ("erp_sales_order_id", "product_id", "number", "amount", "total_amount", "description", "supplier_id", "hardware_from", "software_from", "maintenance_from", "hardware_to", "software_to", "maintenance_to") VALUES (1711, 870, '8', '1200', '9600', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL) RETURNING "id"
22:42:11.150infoyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('INSERT', 'app\models\ErpSalesOrderProducts', 2265, 'a:21:{s:2:"id";i:2265;s:18:"erp_sales_order_id";i:1711;s:12:"erp_store_id";N;s:10:"product_id";i:870;s:11:"description";s:0:"";s:6:"number";s:1:"8";s:8:"outbound";N;s:6:"amount";s:4:"1200";s:12:"total_amount";s:4:"9600";s:11:"last_number";N;s:11:"last_amount";N;s:17:"last_total_amount";N;s:4:"cost";N;s:10:"total_cost";N;s:11:"supplier_id";N;s:13:"hardware_from";N;s:13:"software_from";N;s:16:"maintenance_from";N;s:11:"hardware_to";N;s:11:"software_to";N;s:14:"maintenance_to";N;}', '', 1001, '111.194.208.14')
22:42:11.150infoyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\ErpSalesOrders', 1711, 'a:0:{}', '', 1001, '111.194.208.14')
22:42:11.151infoyii\db\Command::executeDELETE FROM "a57be577deb434"."tbl_erp_sales_order_products" WHERE ("id" NOT IN (2260, 2261, 2262, 2263, 2264, 2265)) AND ("erp_sales_order_id"=1711)
22:42:11.152infoyii\db\Command::executeDELETE FROM "a57be577deb434"."tbl_erp_sales_order_stop_products" WHERE "erp_sales_order_id"=1711
22:42:11.152infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_sales_order_products" WHERE "erp_sales_order_id"=1711
22:42:11.153infoyii\db\Command::executeDELETE FROM "a57be577deb434"."tbl_project_product_rels" WHERE "project_id"=4174
22:42:11.153infoyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_project_product_rels" ("project_id", "erp_sales_order_product_id", "product_id", "amount", "total_amount", "number", "description", "supplier_id", "hardware_from", "software_from", "maintenance_from", "hardware_to", "software_to", "maintenance_to") VALUES (4174, 2260, 2171, '18000', '162000', 9, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL), (4174, 2261, 870, '1200', '10800', 9, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL), (4174, 2262, 2232, '210375', '1893375', 9, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL), (4174, 2263, 868, '1400', '12600', 9, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL), (4174, 2264, 2232, '210375', '1472625', 7, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL), (4174, 2265, 870, '1200', '9600', 8, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL)
22:42:11.156infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_project_change_logs" WHERE ("project_id"=4174) AND ("end_at" IS NULL) ORDER BY "id" DESC LIMIT 1
22:42:11.158infoyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\Projects', 4174, 'a:0:{}', '', 1001, '111.194.208.14')
22:42:11.158infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"=3462
22:42:11.159infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_sales_contracts" WHERE "id"=4486
22:42:11.160infoyii\db\Command::executeUPDATE "a57be577deb434"."tbl_sales_contracts" SET "is_edit_verify"=FALSE WHERE "id"=4486
22:42:11.161infoyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\SalesContracts', 4486, 'a:0:{}', '', 1001, '111.194.208.14')
22:42:11.161infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"=3462
22:42:11.162infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_projects" WHERE "id"=4174
22:42:11.163infoyii\db\Command::querySELECT SUM(r.amount) 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"=4486) AND ("t"."is_payment_settle"=TRUE) AND ("t"."status" IN (2, 5))
22:42:11.164infoyii\db\Command::querySELECT SUM(r.amount) 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"=4486) AND ("t"."status" IN (2, 5))
22:42:11.166infoyii\db\Command::querySELECT SUM(r.amount) 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"=4486) AND ("t"."status" IN (2, 5)) AND ("t"."is_payment_settle"=TRUE)
22:42:11.167infoyii\db\Command::querySELECT EXISTS(SELECT "r".* 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"=4486) AND ("t"."status"=1))
22:42:11.168infoyii\db\Command::querySELECT EXISTS(SELECT "r".* 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"=4486) AND ("t"."status"=1))
22:42:11.168infoyii\db\Command::querySELECT EXISTS(SELECT "r".* 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"=4486) AND ("t"."status"=1))
22:42:11.169infoyii\db\Command::querySELECT SUM(r.amount) 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"=4486) AND ("t"."is_payment_settle"=TRUE) AND ("t"."status" IN (1, 2, 5))
22:42:11.170infoyii\db\Command::querySELECT SUM(r.amount) 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"=4486) AND ("t"."status" IN (1, 2, 5))
22:42:11.170infoyii\db\Command::querySELECT SUM(r.amount) 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"=4486) AND ("t"."status" IN (1, 2, 5))
22:42:11.171infoyii\db\Command::executeUPDATE "a57be577deb434"."tbl_sales_contracts" SET "erp_settle_amount"='0', "erp_un_settle_amount"='3561000', "erp_all_settle_amount"='0' WHERE "id"=4486
22:42:11.172infoyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\SalesContracts', 4486, 'a:1:{s:20:"erp_un_settle_amount";s:5:"18000";}', '', 1001, '111.194.208.14')
22:42:11.173infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"=3462
22:42:11.174infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_projects" WHERE "id"=4174
22:42:11.174infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_projects" WHERE "id"=4174
22:42:11.176infoyii\db\Command::executeUPDATE "a57be577deb434"."tbl_projects" SET "collected"='0' WHERE "id"=4174
22:42:11.177infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_project_change_logs" WHERE ("project_id"=4174) AND ("end_at" IS NULL) ORDER BY "id" DESC LIMIT 1
22:42:11.179infoyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\Projects', 4174, 'a:0:{}', '', 1001, '111.194.208.14')
22:42:11.180infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"=3462
22:42:11.182infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_project_status_logs" WHERE "project_id"=4174 ORDER BY "created_at" DESC
22:42:11.186traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
22:42:11.186infoyii\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_project_status_logs' and d.nspname = 'a57be577deb434' ORDER BY a.attnum;
22:42:11.189infoyii\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_project_status_logs' and ns.nspname='a57be577deb434' order by fns.nspname, fc.relname, a.attnum
22:42:11.198traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
22:42:11.198traceyii\redis\Connection::executeCommandExecuting Redis Command: SET
22:42:11.198infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_sales_contracts" WHERE "id"=4486
22:42:11.199traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
22:42:11.199infoyii\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_contract_payment_collection_remind_dates' and d.nspname = 'a57be577deb434' ORDER BY a.attnum;
22:42:11.202infoyii\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_contract_payment_collection_remind_dates' and ns.nspname='a57be577deb434' order by fns.nspname, fc.relname, a.attnum
22:42:11.209traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
22:42:11.209traceyii\redis\Connection::executeCommandExecuting Redis Command: SET
22:42:11.210infoyii\db\Command::executeUPDATE "a57be577deb434"."tbl_sales_contract_payment_collection_remind_dates" SET "paid_amount"='0', "status"=0, "overdue_days"=NULL WHERE "contract_id"=4486
22:42:11.210infoyii\db\Command::querySELECT r.amount, t.created_at 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"=4486) AND ("t"."status" IN (2, 5, 1))
22:42:11.211infoyii\db\Command::querySELECT r.amount, t.wrote_date as created_at 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"=4486) AND ("t"."status" IN (2, 5, 1))
22:42:11.212infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_projects" WHERE "id"=4174
22:42:11.212infoyii\db\Command::querySELECT SUM(amount) FROM "a57be577deb434"."tbl_sales_contract_payment_collection_remind_dates" WHERE "contract_id"=4486
22:42:11.215infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_project_change_logs" WHERE ("project_id"=4174) AND ("end_at" IS NULL) ORDER BY "id" DESC LIMIT 1
22:42:11.217infoyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\Projects', 4174, 'a:0:{}', '', 1001, '111.194.208.14')
22:42:11.217infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"=3462
22:42:11.218infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_sales_contract_payment_collection_remind_dates" WHERE ("contract_id"=4486) AND (amount > paid_amount) ORDER BY "remind_date"
22:42:11.219infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_sales_order_products" WHERE "erp_sales_order_id"=1711
22:42:11.220infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_sales_outbound_products" WHERE "erp_sales_order_product_id" IN (2260, 2261, 2262, 2263, 2264, 2265)
22:42:11.221infoyii\db\Command::executeUPDATE "a57be577deb434"."tbl_erp_sales_order_products" SET "outbound"='0' WHERE "id"=2260
22:42:11.222infoyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\ErpSalesOrderProducts', 2260, 'a:0:{}', '', 1001, '111.194.208.14')
22:42:11.222infoyii\db\Command::executeUPDATE "a57be577deb434"."tbl_project_product_rels" SET "cost"=NULL, "total_cost"=NULL WHERE "erp_sales_order_product_id"=2260
22:42:11.223infoyii\db\Command::executeUPDATE "a57be577deb434"."tbl_erp_sales_order_products" SET "outbound"='0' WHERE "id"=2261
22:42:11.223infoyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\ErpSalesOrderProducts', 2261, 'a:0:{}', '', 1001, '111.194.208.14')
22:42:11.224infoyii\db\Command::executeUPDATE "a57be577deb434"."tbl_project_product_rels" SET "cost"=NULL, "total_cost"=NULL WHERE "erp_sales_order_product_id"=2261
22:42:11.225infoyii\db\Command::executeUPDATE "a57be577deb434"."tbl_erp_sales_order_products" SET "outbound"='0' WHERE "id"=2262
22:42:11.225infoyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\ErpSalesOrderProducts', 2262, 'a:0:{}', '', 1001, '111.194.208.14')
22:42:11.226infoyii\db\Command::executeUPDATE "a57be577deb434"."tbl_project_product_rels" SET "cost"=NULL, "total_cost"=NULL WHERE "erp_sales_order_product_id"=2262
22:42:11.226infoyii\db\Command::executeUPDATE "a57be577deb434"."tbl_erp_sales_order_products" SET "outbound"='0' WHERE "id"=2263
22:42:11.227infoyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\ErpSalesOrderProducts', 2263, 'a:0:{}', '', 1001, '111.194.208.14')
22:42:11.227infoyii\db\Command::executeUPDATE "a57be577deb434"."tbl_project_product_rels" SET "cost"=NULL, "total_cost"=NULL WHERE "erp_sales_order_product_id"=2263
22:42:11.228infoyii\db\Command::executeUPDATE "a57be577deb434"."tbl_erp_sales_order_products" SET "outbound"='0' WHERE "id"=2264
22:42:11.228infoyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\ErpSalesOrderProducts', 2264, 'a:0:{}', '', 1001, '111.194.208.14')
22:42:11.229infoyii\db\Command::executeUPDATE "a57be577deb434"."tbl_project_product_rels" SET "cost"=NULL, "total_cost"=NULL WHERE "erp_sales_order_product_id"=2264
22:42:11.230infoyii\db\Command::executeUPDATE "a57be577deb434"."tbl_erp_sales_order_products" SET "outbound"='0' WHERE "id"=2265
22:42:11.230infoyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\ErpSalesOrderProducts', 2265, 'a:0:{}', '', 1001, '111.194.208.14')
22:42:11.230infoyii\db\Command::executeUPDATE "a57be577deb434"."tbl_project_product_rels" SET "cost"=NULL, "total_cost"=NULL WHERE "erp_sales_order_product_id"=2265
22:42:11.231infoyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\ErpSalesOrders', 1711, 'a:0:{}', '', 1001, '111.194.208.14')
22:42:11.232infoyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\SalesContracts', 4486, 'a:0:{}', '', 1001, '111.194.208.14')
22:42:11.232infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"=3462
22:42:11.233infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_projects" WHERE "id"=4174
22:42:11.234infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
22:42:11.234infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
22:42:11.235infoyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_object_change_logs" ("act", "attribute", "object_id", "object_type", "created_by", "created_at", "new_value", "old_value", "description") VALUES (11, 'status', 1711, 20007, 1001, 'now()', '["\u5218\u4eba\u8bda"]', '[]', '{"d1":"\u5218\u4eba\u8bda","d2":"\u7f16\u8f91\u4e86","d3":"\u9500\u552e\u8ba2\u5355\u7533\u8bf7","d4":""}')
22:42:11.237infoyii\db\Command::executeUPDATE "a57be577deb434"."tbl_projects" SET "contract_type"=1 WHERE "id"=4174
22:42:11.237infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_project_change_logs" WHERE ("project_id"=4174) AND ("end_at" IS NULL) ORDER BY "id" DESC LIMIT 1
22:42:11.240infoyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\Projects', 4174, 'a:0:{}', '', 1001, '111.194.208.14')
22:42:11.240infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"=3462
22:42:11.241infoyii\db\Command::querySELECT "id" FROM "a57be577deb434"."tbl_sales_contract_invoices" WHERE "contract_id"=4486
22:42:11.242infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_sales_contract_invoices" WHERE 0=1
22:42:11.242infoyii\db\Command::executeDELETE FROM "a57be577deb434"."tbl_sales_contract_invoices" WHERE 0=1
22:42:11.243infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_projects" WHERE "id"=4174
22:42:11.243infoyii\db\Command::executeDELETE FROM "a57be577deb434"."tbl_invoices" WHERE "project_id"=4174
22:42:11.244infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_sales_contract_invoices" WHERE "contract_id"=4486
22:42:11.245infoyii\db\Command::execute
22:42:11.245infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_sales_orders" WHERE "sales_contract_id"=4486 ORDER BY "id" DESC
22:42:11.246infoyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_erp_sales_order_products" WHERE "erp_sales_order_id"=1711)
22:42:11.246infoyii\db\Command::execute
22:42:11.247infoyii\db\Command::executeUPDATE "a57be577deb434"."tbl_sales_contracts" SET "is_outbound"=FALSE WHERE "id"=4486
22:42:11.247infoyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\SalesContracts', 4486, 'a:0:{}', '', 1001, '111.194.208.14')
22:42:11.248infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"='3462'
22:42:11.248infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_projects" WHERE "id"='4174'
22:42:11.249infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_sales_supplier_rels" WHERE "contract_id"=4486
22:42:11.250infoyii\db\Command::executeDELETE FROM "a57be577deb434"."tbl_sales_supplier_rels" WHERE "contract_id"=4486
22:42:11.251infoyii\db\Command::executeDELETE FROM "a57be577deb434"."tbl_purchase_client_rels" WHERE "project_id"=4174
22:42:11.260infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=105) AND ("object_id"=4486)
22:42:11.263infoyii\db\Command::executeDELETE FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=105) AND ("object_id"=4486)
22:42:11.267infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_sales_contract_remind_receivers" WHERE "contract_id"=4486
22:42:11.268infoyii\db\Command::executeDELETE FROM "a57be577deb434"."tbl_sales_contract_remind_receivers" WHERE "contract_id"=4486
22:42:11.268infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_sales_contract_payment_collection_remind_receivers" WHERE "contract_id"=4486
22:42:11.269traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
22:42:11.269infoyii\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_contract_payment_collection_remind_receivers' and d.nspname = 'a57be577deb434' ORDER BY a.attnum;
22:42:11.272infoyii\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_contract_payment_collection_remind_receivers' and ns.nspname='a57be577deb434' order by fns.nspname, fc.relname, a.attnum
22:42:11.281traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
22:42:11.282traceyii\redis\Connection::executeCommandExecuting Redis Command: SET
22:42:11.282infoyii\db\Command::executeDELETE FROM "a57be577deb434"."tbl_sales_contract_payment_collection_remind_receivers" WHERE "contract_id"=4486
22:42:11.282infoyii\db\Command::queryINSERT INTO "a57be577deb434"."tbl_sales_contract_payment_collection_remind_receivers" ("contract_id", "user_id") VALUES (4486, 1001) RETURNING "id"
22:42:11.289infoyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('INSERT', 'app\models\SalesContractPaymentCollectionRemindReceivers', 10174, 'a:3:{s:2:"id";i:10174;s:11:"contract_id";i:4486;s:7:"user_id";s:4:"1001";}', '', 1001, '111.194.208.14')
22:42:11.290infoyii\db\Command::querySELECT "remind_date" FROM "a57be577deb434"."tbl_service_contract_remind_dates" WHERE "contract_id"=4486
22:42:11.290infoyii\db\Command::executeDELETE FROM "a57be577deb434"."tbl_service_contract_remind_dates" WHERE ("contract_id"=4486) AND (0=1)
22:42:11.291infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_service_contract_remind_receivers" WHERE "contract_id"=4486
22:42:11.291infoyii\db\Command::executeDELETE FROM "a57be577deb434"."tbl_service_contract_remind_receivers" WHERE "contract_id"=4486
22:42:11.292infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_sales_contracts" WHERE "id"=4486
22:42:11.292infoyii\db\Command::querySELECT SUM(r.amount) 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"=4486) AND ("t"."is_payment_settle"=TRUE) AND ("t"."status" IN (2, 5))
22:42:11.293infoyii\db\Command::querySELECT SUM(r.amount) 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"=4486) AND ("t"."status" IN (2, 5))
22:42:11.294infoyii\db\Command::querySELECT SUM(r.amount) 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"=4486) AND ("t"."status" IN (2, 5)) AND ("t"."is_payment_settle"=TRUE)
22:42:11.295infoyii\db\Command::querySELECT EXISTS(SELECT "r".* 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"=4486) AND ("t"."status"=1))
22:42:11.295infoyii\db\Command::querySELECT EXISTS(SELECT "r".* 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"=4486) AND ("t"."status"=1))
22:42:11.296infoyii\db\Command::querySELECT EXISTS(SELECT "r".* 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"=4486) AND ("t"."status"=1))
22:42:11.297infoyii\db\Command::querySELECT SUM(r.amount) 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"=4486) AND ("t"."is_payment_settle"=TRUE) AND ("t"."status" IN (1, 2, 5))
22:42:11.298infoyii\db\Command::querySELECT SUM(r.amount) 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"=4486) AND ("t"."status" IN (1, 2, 5))
22:42:11.298infoyii\db\Command::querySELECT SUM(r.amount) 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"=4486) AND ("t"."status" IN (1, 2, 5))
22:42:11.299infoyii\db\Command::executeUPDATE "a57be577deb434"."tbl_sales_contracts" SET "erp_settle_amount"='0', "erp_un_settle_amount"='3561000', "erp_all_settle_amount"='0' WHERE "id"=4486
22:42:11.300infoyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\SalesContracts', 4486, 'a:0:{}', '', 1001, '111.194.208.14')
22:42:11.301infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"=3462
22:42:11.301infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_projects" WHERE "id"=4174
22:42:11.302infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_projects" WHERE "id"=4174
22:42:11.304infoyii\db\Command::executeUPDATE "a57be577deb434"."tbl_projects" SET "collected"='0' WHERE "id"=4174
22:42:11.305infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_project_change_logs" WHERE ("project_id"=4174) AND ("end_at" IS NULL) ORDER BY "id" DESC LIMIT 1
22:42:11.307infoyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\Projects', 4174, 'a:0:{}', '', 1001, '111.194.208.14')
22:42:11.308infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"=3462
22:42:11.308infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_project_status_logs" WHERE "project_id"=4174 ORDER BY "created_at" DESC
22:42:11.309infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_sales_contracts" WHERE "id"=4486
22:42:11.310infoyii\db\Command::executeUPDATE "a57be577deb434"."tbl_sales_contract_payment_collection_remind_dates" SET "paid_amount"='0', "status"=0, "overdue_days"=NULL WHERE "contract_id"=4486
22:42:11.310infoyii\db\Command::querySELECT r.amount, t.created_at 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"=4486) AND ("t"."status" IN (2, 5, 1))
22:42:11.311infoyii\db\Command::querySELECT r.amount, t.wrote_date as created_at 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"=4486) AND ("t"."status" IN (2, 5, 1))
22:42:11.312infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_projects" WHERE "id"=4174
22:42:11.312infoyii\db\Command::querySELECT SUM(amount) FROM "a57be577deb434"."tbl_sales_contract_payment_collection_remind_dates" WHERE "contract_id"=4486
22:42:11.314infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_project_change_logs" WHERE ("project_id"=4174) AND ("end_at" IS NULL) ORDER BY "id" DESC LIMIT 1
22:42:11.317infoyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\Projects', 4174, 'a:0:{}', '', 1001, '111.194.208.14')
22:42:11.317infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"=3462
22:42:11.318infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_sales_contract_payment_collection_remind_dates" WHERE ("contract_id"=4486) AND (amount > paid_amount) ORDER BY "remind_date"
22:42:11.318infoyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_id"=4486) AND ("object_type"=106))
22:42:11.322infoyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_id"=4486) AND ("object_type"=107))
22:42:11.325infoyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_id"=4486) AND ("object_type"=105))
22:42:11.328infoyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\SalesContracts', 4486, 'a:0:{}', '', 1001, '111.194.208.14')
22:42:11.329infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"=3462
22:42:11.330infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_projects" WHERE "id"=4174
22:42:11.331traceyii\db\Transaction::commitCommit transaction
22:42:11.337traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
22:42:11.338traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
22:42:11.338infoyii\db\Command::queryINSERT INTO "global"."tbl_api_log" ("code", "schema", "user_id", "device_type", "url", "request", "response", "php_error", "time", "duration") VALUES (200, 'a57be577deb434', 1001, 5, 'vue/sales-contract/save-edit', '{"SalesContracts":{"id":"4486","client_id":"3462","project_id":"4174","project_name":"\u9500\u552e\u7ebf\u7d22\u751f\u621020260602001","amount":"18000","contract_scan":"","receipt_scan":"","contract_type":"1","serial_no":"2026-06-02-001","signed_at":"2026-06-02","budget":"18000","profit":"356100","profit_pct":"10.00","description":"","expire_date":"","expire_remind_ahead":"","project_product_version_id":"","salesContractPayments":{"new":[""]},"payment_collection_remind_ahead":"1 day","salesContractPaymentCollectionRemindReceivers":["1001"],"sla":"","including_tax":"1","remind_ahead":"","is_draft":"1","is_settle":"0","is_deliver":"0","is_outbound":"0","client_name":"\u5927\u59d1\u8bf4\u7684\u98ce\u683c","projectContactPoints":"","projectContactPointRels":"","contractScans":"","serviceContractRemindDates":"","salesSupplierRels":"","projectProductRels":{"12138":{"product_id":"2171","amount":"18000","total_amount":"162000","number":"9","description":"","hardware_from":"","hardware_to":"","maintenance_from":"","maintenance_to":"","software_from":"","software_to":"","supplier_id":""},"new":{"4":{"product_id":"870","amount":"1200","total_amount":"10800","number":"9","description":"","hardware_from":"","hardware_to":"","maintenance_from":"","maintenance_to":"","software_from":"","software_to":"","supplier_id":""},"3":{"product_id":"2232","amount":"210375","total_amount":"1893375","number":"9","description":"","hardware_from":"","hardware_to":"","maintenance_from":"","maintenance_to":"","software_from":"","software_to":"","supplier_id":""},"2":{"product_id":"868","amount":"1400","total_amount":"12600","number":"9","description":"","hardware_from":"","hardware_to":"","maintenance_from":"","maintenance_to":"","software_from":"","software_to":"","supplier_id":""},"1":{"product_id":"2232","amount":"210375","total_amount":"1472625","number":"7","description":"","hardware_from":"","hardware_to":"","maintenance_from":"","maintenance_to":"","software_from":"","software_to":"","supplier_id":""},"0":{"product_id":"870","amount":"1200","total_amount":"9600","number":"8","description":"","hardware_from":"","hardware_to":"","maintenance_from":"","maintenance_to":"","software_from":"","software_to":"","supplier_id":""}}},"salesContractInvoices":"","projectProductTypes":{"5":{"budget":"3399000","profit":"339900","pct":"10"},"7":{"budget":"162000","profit":"16200","pct":"10"}},"salesContractRemindReceivers":"","serviceContractRemindReceivers":""}}', '{"code":2000,"result":"","status":1,"msg":[{"name":"success","success":"\u9500\u552e\u5408\u540c\u5df2\u88ab\u6210\u529f\u4fee\u6539","error":""}],"mod":0,"ip":"111.194.208.14","ua":"Mozilla\/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit\/537.36 (KHTML, like Gecko) Chrome\/149.0.0.0 Safari\/537.36"}', FALSE, '2026-07-03 22:42:11', 1194481152) RETURNING "id"
22:42:11.344traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
22:42:11.344traceyii\redis\Connection::executeCommandExecuting Redis Command: SET