6a490ca0694ad: POST https://beta.jinchangxiao.com/vue/sales-contract/save-edit at 2026-07-04 09:37:36 pm by 111.194.208.14
Log Messages
总计445条数据
| Time | Level | Category | Message |
|---|---|---|---|
| 21:37:36.424 | trace | yii\base\Application::bootstrap | Bootstrap with yii\log\Dispatcher |
| 21:37:36.424 | trace | yii\base\Module::getModule | Loading module: debug |
| 21:37:36.424 | trace | yii\base\Application::bootstrap | Bootstrap with yii\debug\Module::bootstrap() |
| 21:37:36.431 | trace | yii\redis\Connection::open | Opening redis DB connection: redis.server.local:6379, database=1 |
| 21:37:36.432 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: SELECT |
| 21:37:36.432 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 21:37:36.433 | info | time tracing start | 1783172256433764864 |
| 21:37:36.434 | trace | yii\web\UrlManager::parseRequest | No matching URL rules. Using default URL parsing logic. |
| 21:37:36.434 | trace | yii\web\Application::handleRequest | Route requested: 'vue/sales-contract/save-edit' |
| 21:37:36.434 | trace | yii\base\Module::getModule | Loading module: vue |
| 21:37:36.435 | info | yii\web\Session::open | Session started |
| 21:37:36.436 | info | yii\db\Command::query | SELECT * FROM "global"."vw_user_login" WHERE "id"=5064 |
| 21:37:36.436 | info | yii\db\Connection::open | Opening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta |
| 21:37:36.438 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 21:37:36.439 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 21:37:36.440 | info | yii\db\Command::query | SELECT * FROM "global"."vw_user_login" WHERE "id"=1001 |
| 21:37:36.441 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 21:37:36.441 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 21:37:36.441 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001 |
| 21:37:36.442 | trace | yii\base\Controller::runAction | Route to run: vue/sales-contract/save-edit |
| 21:37:36.443 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 21:37:36.445 | trace | uranus\rbac\DbManager::checkAccessFromCache | Checking role: Admin |
| 21:37:36.445 | trace | yii\base\InlineAction::runWithParams | Running action: app\modules\vue\controllers\SalesContractController::actionSaveEdit() |
| 21:37:36.445 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_sales_contracts" WHERE "id"='4491' |
| 21:37:36.446 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 21:37:36.446 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 21:37:36.446 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 21:37:36.448 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 21:37:36.450 | trace | yii\base\Model::onUnsafeAttribute | Failed to set unsafe attribute 'id' in 'app\models\SalesContracts'. |
| 21:37:36.450 | trace | yii\base\Model::onUnsafeAttribute | Failed to set unsafe attribute 'project_name' in 'app\models\SalesContracts'. |
| 21:37:36.451 | trace | yii\base\Model::onUnsafeAttribute | Failed to set unsafe attribute 'budget' in 'app\models\SalesContracts'. |
| 21:37:36.451 | trace | yii\base\Model::onUnsafeAttribute | Failed to set unsafe attribute 'profit' in 'app\models\SalesContracts'. |
| 21:37:36.451 | trace | yii\base\Model::onUnsafeAttribute | Failed to set unsafe attribute 'profit_pct' in 'app\models\SalesContracts'. |
| 21:37:36.451 | trace | yii\base\Model::onUnsafeAttribute | Failed to set unsafe attribute 'project_product_version_id' in 'app\models\SalesContracts'. |
| 21:37:36.451 | trace | yii\base\Model::onUnsafeAttribute | Failed to set unsafe attribute 'salesContractPayments' in 'app\models\SalesContracts'. |
| 21:37:36.451 | trace | yii\base\Model::onUnsafeAttribute | Failed to set unsafe attribute 'salesContractPaymentCollectionRemindReceivers' in 'app\models\SalesContracts'. |
| 21:37:36.451 | trace | yii\base\Model::onUnsafeAttribute | Failed to set unsafe attribute 'client_name' in 'app\models\SalesContracts'. |
| 21:37:36.451 | trace | yii\base\Model::onUnsafeAttribute | Failed to set unsafe attribute 'projectContactPoints' in 'app\models\SalesContracts'. |
| 21:37:36.451 | trace | yii\base\Model::onUnsafeAttribute | Failed to set unsafe attribute 'projectContactPointRels' in 'app\models\SalesContracts'. |
| 21:37:36.451 | trace | yii\base\Model::onUnsafeAttribute | Failed to set unsafe attribute 'contractScans' in 'app\models\SalesContracts'. |
| 21:37:36.451 | trace | yii\base\Model::onUnsafeAttribute | Failed to set unsafe attribute 'serviceContractRemindDates' in 'app\models\SalesContracts'. |
| 21:37:36.451 | trace | yii\base\Model::onUnsafeAttribute | Failed to set unsafe attribute 'salesSupplierRels' in 'app\models\SalesContracts'. |
| 21:37:36.451 | trace | yii\base\Model::onUnsafeAttribute | Failed to set unsafe attribute 'projectProductRels' in 'app\models\SalesContracts'. |
| 21:37:36.451 | trace | yii\base\Model::onUnsafeAttribute | Failed to set unsafe attribute 'salesContractInvoices' in 'app\models\SalesContracts'. |
| 21:37:36.451 | trace | yii\base\Model::onUnsafeAttribute | Failed to set unsafe attribute 'projectProductTypes' in 'app\models\SalesContracts'. |
| 21:37:36.451 | trace | yii\base\Model::onUnsafeAttribute | Failed to set unsafe attribute 'salesContractRemindReceivers' in 'app\models\SalesContracts'. |
| 21:37:36.451 | trace | yii\base\Model::onUnsafeAttribute | Failed to set unsafe attribute 'serviceContractRemindReceivers' in 'app\models\SalesContracts'. |
| 21:37:36.451 | info | yii\db\Command::query | SELECT "id" FROM "a57be577deb434"."tbl_sales_contracts" WHERE "serial_no"='2026-06-05-001' LIMIT 2 |
| 21:37:36.452 | info | yii\db\Command::query | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"='2128') |
| 21:37:36.453 | info | yii\db\Command::query | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_contract_types" WHERE "id"='1') |
| 21:37:36.453 | info | yii\db\Command::query | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_projects" WHERE "id"='3854') |
| 21:37:36.454 | info | yii\db\Command::query | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=5087) |
| 21:37:36.454 | info | yii\db\Command::query | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=5087) |
| 21:37:36.455 | info | yii\db\Command::query | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_projects" WHERE "id"=3854) |
| 21:37:36.455 | trace | yii\db\Transaction::begin | Begin transaction |
| 21:37:36.457 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 21:37:36.457 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 21:37:36.457 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_projects" WHERE "id"=3854 |
| 21:37:36.459 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_project_product_types" WHERE "project_id"=3854 |
| 21:37:36.459 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 21:37:36.460 | info | yii\db\Command::query | SELECT 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; |
| 21:37:36.463 | info | yii\db\Command::query | select 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 |
| 21:37:36.472 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 21:37:36.472 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: SET |
| 21:37:36.478 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 21:37:36.478 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 21:37:36.478 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_product_types" WHERE "id"=4 |
| 21:37:36.479 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_product_types" WHERE "id"=23 |
| 21:37:36.479 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_product_types" WHERE "id"=21 |
| 21:37:36.480 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_product_types" WHERE "id"=23 |
| 21:37:36.480 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_product_types" WHERE "id"=21 |
| 21:37:36.481 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_product_types" WHERE "id"=4 |
| 21:37:36.481 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001 |
| 21:37:36.482 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 21:37:36.482 | info | yii\db\Command::query | SELECT 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_object_change_logs' and d.nspname = 'a57be577deb434' ORDER BY a.attnum; |
| 21:37:36.489 | info | yii\db\Command::query | select 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_object_change_logs' and ns.nspname='a57be577deb434' order by fns.nspname, fc.relname, a.attnum |
| 21:37:36.498 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 21:37:36.499 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: SET |
| 21:37:36.499 | info | yii\db\Command::execute | INSERT INTO "a57be577deb434"."tbl_object_change_logs" ("act", "attribute", "object_id", "object_type", "created_by", "created_at", "new_value", "old_value", "description") VALUES (2, 'projectProductTypes', 3854, 1, 1001, 'now()', '[["\u7f51\u7edc\u8bbe\u5907 :977589191\u5143 25%","\u793c\u54c1:53588\u5143 25%","\u6570\u7801\u8bbe\u5907:44\u5143 25%"]]', '[["\u793c\u54c1:53588\u5143 25%","\u6570\u7801\u8bbe\u5907:44\u5143 25%","\u7f51\u7edc\u8bbe\u5907 :44486888\u5143 25%"]]', '{"d1":"\u5218\u4eba\u8bda","d2":"\u66f4\u65b0\u4e86","d3":"\u5546\u673a\u91d1\u989d","d4":["\u793c\u54c1:53588\u5143 25%;\u6570\u7801\u8bbe\u5907:44\u5143 25%;\u7f51\u7edc\u8bbe\u5907 :44486888\u5143 25%; <b>\u53d8\u4e3a<\/b> \u7f51\u7edc\u8bbe\u5907 :977589191\u5143 25%;\u793c\u54c1:53588\u5143 25%;\u6570\u7801\u8bbe\u5907:44\u5143 25%;"]}') |
| 21:37:36.503 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"=2128 |
| 21:37:36.505 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 21:37:36.505 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 21:37:36.509 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001 |
| 21:37:36.510 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 21:37:36.510 | info | yii\db\Command::query | SELECT 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; |
| 21:37:36.514 | info | yii\db\Command::query | select 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 |
| 21:37:36.525 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 21:37:36.525 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: SET |
| 21:37:36.526 | info | yii\db\Command::execute | INSERT 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', 3854, 1, 1001, 'now()', '[["\u7f51\u7edc\u8bbe\u5907 :977589191\u5143 25%","\u793c\u54c1:53588\u5143 25%","\u6570\u7801\u8bbe\u5907:44\u5143 25%"]]', '[["\u793c\u54c1:53588\u5143 25%","\u6570\u7801\u8bbe\u5907:44\u5143 25%","\u7f51\u7edc\u8bbe\u5907 :44486888\u5143 25%"]]', array[5087], '{"d1":"\u5218\u4eba\u8bda","d2":"\u66f4\u65b0\u4e86","d3":"\u5546\u673a\u91d1\u989d","d4":["\u793c\u54c1:53588\u5143 25%;\u6570\u7801\u8bbe\u5907:44\u5143 25%;\u7f51\u7edc\u8bbe\u5907 :44486888\u5143 25%; <b>\u53d8\u4e3a<\/b> \u7f51\u7edc\u8bbe\u5907 :977589191\u5143 25%;\u793c\u54c1:53588\u5143 25%;\u6570\u7801\u8bbe\u5907:44\u5143 25%;"]}') |
| 21:37:36.533 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_sales_contracts" WHERE "from_project"=3854 |
| 21:37:36.534 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001 |
| 21:37:36.535 | info | yii\db\Command::execute | INSERT INTO "a57be577deb434"."tbl_object_change_logs" ("act", "attribute", "object_id", "object_type", "created_by", "created_at", "new_value", "old_value", "description") VALUES (2, 'projectProductTypes', 4491, 7, 1001, 'now()', '[["\u7f51\u7edc\u8bbe\u5907 :977589191\u5143 25%","\u793c\u54c1:53588\u5143 25%","\u6570\u7801\u8bbe\u5907:44\u5143 25%"]]', '[["\u793c\u54c1:53588\u5143 25%","\u6570\u7801\u8bbe\u5907:44\u5143 25%","\u7f51\u7edc\u8bbe\u5907 :44486888\u5143 25%"]]', '{"d1":"\u5218\u4eba\u8bda","d2":"\u66f4\u65b0\u4e86","d3":"\u5408\u540c\u91d1\u989d","d4":["\u793c\u54c1:53588\u5143 25%;\u6570\u7801\u8bbe\u5907:44\u5143 25%;\u7f51\u7edc\u8bbe\u5907 :44486888\u5143 25%; <b>\u53d8\u4e3a<\/b> \u7f51\u7edc\u8bbe\u5907 :977589191\u5143 25%;\u793c\u54c1:53588\u5143 25%;\u6570\u7801\u8bbe\u5907:44\u5143 25%;"]}') |
| 21:37:36.535 | info | yii\db\Command::execute | DELETE FROM "a57be577deb434"."tbl_project_product_types" WHERE "project_id"=3854 |
| 21:37:36.537 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_product_types" WHERE "id"=4 |
| 21:37:36.537 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_product_types" WHERE "id"=23 |
| 21:37:36.538 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_product_types" WHERE "id"=21 |
| 21:37:36.538 | info | yii\db\Command::execute | INSERT INTO "a57be577deb434"."tbl_project_product_types" ("project_id", "product_type_id", "name", "budget", "pct", "profit") VALUES (3854, 4, '网络设备 ', '977589191', 25, '244397297.75'), (3854, 23, '礼品', '53588', 25, '13397'), (3854, 21, '数码设备', '44', 25, '11') |
| 21:37:36.542 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_project_contact_points" WHERE "project_id"=3854 |
| 21:37:36.544 | info | yii\db\Command::execute | DELETE FROM "a57be577deb434"."tbl_project_contact_points" WHERE "project_id"=3854 |
| 21:37:36.545 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_project_contact_point_rels" WHERE "project_id"=3854 |
| 21:37:36.549 | info | yii\db\Command::query | SELECT "id" FROM "a57be577deb434"."tbl_project_contact_point_rels" WHERE "project_id"=3854 |
| 21:37:36.550 | info | yii\db\Command::execute | DELETE FROM "a57be577deb434"."tbl_project_contact_point_rels" WHERE 0=1 |
| 21:37:36.550 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_project_product_rels" WHERE "project_id"=3854 ORDER BY "id" |
| 21:37:36.551 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 21:37:36.551 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 21:37:36.552 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 21:37:36.552 | info | yii\db\Command::query | SELECT 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_products' and d.nspname = 'a57be577deb434' ORDER BY a.attnum; |
| 21:37:36.555 | info | yii\db\Command::query | select 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_products' and ns.nspname='a57be577deb434' order by fns.nspname, fc.relname, a.attnum |
| 21:37:36.567 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 21:37:36.567 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: SET |
| 21:37:36.567 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_products" WHERE "id"=2261 |
| 21:37:36.568 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_product_units" WHERE "id"=3 |
| 21:37:36.569 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 21:37:36.569 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 21:37:36.570 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_products" WHERE "id"=1372 |
| 21:37:36.571 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_product_units" WHERE "id"=6 |
| 21:37:36.571 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_products" WHERE "id"=2265 |
| 21:37:36.572 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_product_units" WHERE "id"=9 |
| 21:37:36.572 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_products" WHERE "id"=2263 |
| 21:37:36.573 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_product_units" WHERE "id"=3 |
| 21:37:36.573 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_products" WHERE "id"=2266 |
| 21:37:36.573 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_product_units" WHERE "id"=3 |
| 21:37:36.574 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_products" WHERE "id"='2261' |
| 21:37:36.575 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_product_units" WHERE "id"=3 |
| 21:37:36.575 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_products" WHERE "id"='1372' |
| 21:37:36.576 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_product_units" WHERE "id"=6 |
| 21:37:36.576 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_products" WHERE "id"='2265' |
| 21:37:36.577 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_product_units" WHERE "id"=9 |
| 21:37:36.578 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_products" WHERE "id"='2263' |
| 21:37:36.578 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_product_units" WHERE "id"=3 |
| 21:37:36.579 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_products" WHERE "id"='2266' |
| 21:37:36.579 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_product_units" WHERE "id"=3 |
| 21:37:36.580 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001 |
| 21:37:36.581 | info | yii\db\Command::execute | INSERT INTO "a57be577deb434"."tbl_object_change_logs" ("act", "attribute", "object_id", "object_type", "created_by", "created_at", "new_value", "old_value", "description") VALUES (2, 'projectProducts', 3854, 1, 1001, 'now()', '[["MK-MC300:\u5408\u540c\u5355\u4ef7 44433443\u5143 \u6570\u91cf 22\u4e2a\u5143 \u5907\u6ce8:- \u4f9b\u5e94\u5546 - \u786c\u4ef6\u8d28\u4fdd - \u8f6f\u4ef6\u8d28\u4fdd - \u8fd0\u7ef4\u670d\u52a1 -","LC-LC \u5149\u7ea4\u7ebf 5\u7c73:\u5408\u540c\u5355\u4ef7 53445\u5143 \u6570\u91cf 1\u6761\u5143 \u5907\u6ce8:- \u4f9b\u5e94\u5546 - \u786c\u4ef6\u8d28\u4fdd - \u8f6f\u4ef6\u8d28\u4fdd - \u8fd0\u7ef4\u670d\u52a1 -","\u6b27\u4e3d\u8587\u5170Olivoila \u6a44\u6984\u6cb9500MLx2 \u7cbe\u9009\u793c\u76d2:\u5408\u540c\u5355\u4ef7 53534\u5143 \u6570\u91cf 1\u76d2\u5143 \u5907\u6ce8:- \u4f9b\u5e94\u5546 - \u786c\u4ef6\u8d28\u4fdd - \u8f6f\u4ef6\u8d28\u4fdd - \u8fd0\u7ef4\u670d\u52a1 -","\u867e\u76ae\u6295\u5f71\u5e55\u5e03100\u5bf8:\u5408\u540c\u5355\u4ef7 44\u5143 \u6570\u91cf 1\u4e2a\u5143 \u5907\u6ce8:- \u4f9b\u5e94\u5546 - \u786c\u4ef6\u8d28\u4fdd - \u8f6f\u4ef6\u8d28\u4fdd - \u8fd0\u7ef4\u670d\u52a1 -","\u677e\u4e0b\u7535\u52a8\u5243\u987b\u5200\u5c0f\u65b9\u76d2mini\u4fbf\u643a\u6b3eCM20:\u5408\u540c\u5355\u4ef7 54\u5143 \u6570\u91cf 1\u4e2a\u5143 \u5907\u6ce8:- \u4f9b\u5e94\u5546 - \u786c\u4ef6\u8d28\u4fdd - \u8f6f\u4ef6\u8d28\u4fdd - \u8fd0\u7ef4\u670d\u52a1 -"]]', '[["MK-MC300:\u5408\u540c\u5355\u4ef7 44433443\u5143 \u6570\u91cf 1\u4e2a\u5143 \u5907\u6ce8:- \u4f9b\u5e94\u5546 - \u786c\u4ef6\u8d28\u4fdd - \u8f6f\u4ef6\u8d28\u4fdd - \u8fd0\u7ef4\u670d\u52a1 -","LC-LC \u5149\u7ea4\u7ebf 5\u7c73:\u5408\u540c\u5355\u4ef7 53445\u5143 \u6570\u91cf 1\u6761\u5143 \u5907\u6ce8:- \u4f9b\u5e94\u5546 - \u786c\u4ef6\u8d28\u4fdd - \u8f6f\u4ef6\u8d28\u4fdd - \u8fd0\u7ef4\u670d\u52a1 -","\u6b27\u4e3d\u8587\u5170Olivoila \u6a44\u6984\u6cb9500MLx2 \u7cbe\u9009\u793c\u76d2:\u5408\u540c\u5355\u4ef7 53534\u5143 \u6570\u91cf 1\u76d2\u5143 \u5907\u6ce8:- \u4f9b\u5e94\u5546 - \u786c\u4ef6\u8d28\u4fdd - \u8f6f\u4ef6\u8d28\u4fdd - \u8fd0\u7ef4\u670d\u52a1 -","\u867e\u76ae\u6295\u5f71\u5e55\u5e03100\u5bf8:\u5408\u540c\u5355\u4ef7 44\u5143 \u6570\u91cf 1\u4e2a\u5143 \u5907\u6ce8:- \u4f9b\u5e94\u5546 - \u786c\u4ef6\u8d28\u4fdd - \u8f6f\u4ef6\u8d28\u4fdd - \u8fd0\u7ef4\u670d\u52a1 -","\u677e\u4e0b\u7535\u52a8\u5243\u987b\u5200\u5c0f\u65b9\u76d2mini\u4fbf\u643a\u6b3eCM20:\u5408\u540c\u5355\u4ef7 54\u5143 \u6570\u91cf 1\u4e2a\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":["MK-MC300:\u5408\u540c\u5355\u4ef7 44433443\u5143 \u6570\u91cf 1\u4e2a\u5143 \u5907\u6ce8:- \u4f9b\u5e94\u5546 - \u786c\u4ef6\u8d28\u4fdd - \u8f6f\u4ef6\u8d28\u4fdd - \u8fd0\u7ef4\u670d\u52a1 -;LC-LC \u5149\u7ea4\u7ebf 5\u7c73:\u5408\u540c\u5355\u4ef7 53445\u5143 \u6570\u91cf 1\u6761\u5143 \u5907\u6ce8:- \u4f9b\u5e94\u5546 - \u786c\u4ef6\u8d28\u4fdd - \u8f6f\u4ef6\u8d28\u4fdd - \u8fd0\u7ef4\u670d\u52a1 -;\u6b27\u4e3d\u8587\u5170Olivoila \u6a44\u6984\u6cb9500MLx2 \u7cbe\u9009\u793c\u76d2:\u5408\u540c\u5355\u4ef7 53534\u5143 \u6570\u91cf 1\u76d2\u5143 \u5907\u6ce8:- \u4f9b\u5e94\u5546 - \u786c\u4ef6\u8d28\u4fdd - \u8f6f\u4ef6\u8d28\u4fdd - \u8fd0\u7ef4\u670d\u52a1 -;\u867e\u76ae\u6295\u5f71\u5e55\u5e03100\u5bf8:\u5408\u540c\u5355\u4ef7 44\u5143 \u6570\u91cf 1\u4e2a\u5143 \u5907\u6ce8:- \u4f9b\u5e94\u5546 - \u786c\u4ef6\u8d28\u4fdd - \u8f6f\u4ef6\u8d28\u4fdd - \u8fd0\u7ef4\u670d\u52a1 -;\u677e\u4e0b\u7535\u52a8\u5243\u987b\u5200\u5c0f\u65b9\u76d2mini\u4fbf\u643a\u6b3eCM20:\u5408\u540c\u5355\u4ef7 54\u5143 \u6570\u91cf 1\u4e2a\u5143 \u5907\u6ce8:- \u4f9b\u5e94\u5546 - \u786c\u4ef6\u8d28\u4fdd - \u8f6f\u4ef6\u8d28\u4fdd - \u8fd0\u7ef4\u670d\u52a1 -; <b>\u53d8\u4e3a<\/b> MK-MC300:\u5408\u540c\u5355\u4ef7 44433443\u5143 \u6570\u91cf 22\u4e2a\u5143 \u5907\u6ce8:- \u4f9b\u5e94\u5546 - \u786c\u4ef6\u8d28\u4fdd - \u8f6f\u4ef6\u8d28\u4fdd - \u8fd0\u7ef4\u670d\u52a1 -;LC-LC \u5149\u7ea4\u7ebf 5\u7c73:\u5408\u540c\u5355\u4ef7 53445\u5143 \u6570\u91cf 1\u6761\u5143 \u5907\u6ce8:- \u4f9b\u5e94\u5546 - \u786c\u4ef6\u8d28\u4fdd - \u8f6f\u4ef6\u8d28\u4fdd - \u8fd0\u7ef4\u670d\u52a1 -;\u6b27\u4e3d\u8587\u5170Olivoila \u6a44\u6984\u6cb9500MLx2 \u7cbe\u9009\u793c\u76d2:\u5408\u540c\u5355\u4ef7 53534\u5143 \u6570\u91cf 1\u76d2\u5143 \u5907\u6ce8:- \u4f9b\u5e94\u5546 - \u786c\u4ef6\u8d28\u4fdd - \u8f6f\u4ef6\u8d28\u4fdd - \u8fd0\u7ef4\u670d\u52a1 -;\u867e\u76ae\u6295\u5f71\u5e55\u5e03100\u5bf8:\u5408\u540c\u5355\u4ef7 44\u5143 \u6570\u91cf 1\u4e2a\u5143 \u5907\u6ce8:- \u4f9b\u5e94\u5546 - \u786c\u4ef6\u8d28\u4fdd - \u8f6f\u4ef6\u8d28\u4fdd - \u8fd0\u7ef4\u670d\u52a1 -;\u677e\u4e0b\u7535\u52a8\u5243\u987b\u5200\u5c0f\u65b9\u76d2mini\u4fbf\u643a\u6b3eCM20:\u5408\u540c\u5355\u4ef7 54\u5143 \u6570\u91cf 1\u4e2a\u5143 \u5907\u6ce8:- \u4f9b\u5e94\u5546 - \u786c\u4ef6\u8d28\u4fdd - \u8f6f\u4ef6\u8d28\u4fdd - \u8fd0\u7ef4\u670d\u52a1 -;"]}') |
| 21:37:36.582 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001 |
| 21:37:36.582 | info | yii\db\Command::execute | INSERT 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', 3854, 1, 1001, 'now()', '[["MK-MC300:\u5408\u540c\u5355\u4ef7 44433443\u5143 \u6570\u91cf 22\u4e2a\u5143 \u5907\u6ce8:- \u4f9b\u5e94\u5546 - \u786c\u4ef6\u8d28\u4fdd - \u8f6f\u4ef6\u8d28\u4fdd - \u8fd0\u7ef4\u670d\u52a1 -","LC-LC \u5149\u7ea4\u7ebf 5\u7c73:\u5408\u540c\u5355\u4ef7 53445\u5143 \u6570\u91cf 1\u6761\u5143 \u5907\u6ce8:- \u4f9b\u5e94\u5546 - \u786c\u4ef6\u8d28\u4fdd - \u8f6f\u4ef6\u8d28\u4fdd - \u8fd0\u7ef4\u670d\u52a1 -","\u6b27\u4e3d\u8587\u5170Olivoila \u6a44\u6984\u6cb9500MLx2 \u7cbe\u9009\u793c\u76d2:\u5408\u540c\u5355\u4ef7 53534\u5143 \u6570\u91cf 1\u76d2\u5143 \u5907\u6ce8:- \u4f9b\u5e94\u5546 - \u786c\u4ef6\u8d28\u4fdd - \u8f6f\u4ef6\u8d28\u4fdd - \u8fd0\u7ef4\u670d\u52a1 -","\u867e\u76ae\u6295\u5f71\u5e55\u5e03100\u5bf8:\u5408\u540c\u5355\u4ef7 44\u5143 \u6570\u91cf 1\u4e2a\u5143 \u5907\u6ce8:- \u4f9b\u5e94\u5546 - \u786c\u4ef6\u8d28\u4fdd - \u8f6f\u4ef6\u8d28\u4fdd - \u8fd0\u7ef4\u670d\u52a1 -","\u677e\u4e0b\u7535\u52a8\u5243\u987b\u5200\u5c0f\u65b9\u76d2mini\u4fbf\u643a\u6b3eCM20:\u5408\u540c\u5355\u4ef7 54\u5143 \u6570\u91cf 1\u4e2a\u5143 \u5907\u6ce8:- \u4f9b\u5e94\u5546 - \u786c\u4ef6\u8d28\u4fdd - \u8f6f\u4ef6\u8d28\u4fdd - \u8fd0\u7ef4\u670d\u52a1 -"]]', '[["MK-MC300:\u5408\u540c\u5355\u4ef7 44433443\u5143 \u6570\u91cf 1\u4e2a\u5143 \u5907\u6ce8:- \u4f9b\u5e94\u5546 - \u786c\u4ef6\u8d28\u4fdd - \u8f6f\u4ef6\u8d28\u4fdd - \u8fd0\u7ef4\u670d\u52a1 -","LC-LC \u5149\u7ea4\u7ebf 5\u7c73:\u5408\u540c\u5355\u4ef7 53445\u5143 \u6570\u91cf 1\u6761\u5143 \u5907\u6ce8:- \u4f9b\u5e94\u5546 - \u786c\u4ef6\u8d28\u4fdd - \u8f6f\u4ef6\u8d28\u4fdd - \u8fd0\u7ef4\u670d\u52a1 -","\u6b27\u4e3d\u8587\u5170Olivoila \u6a44\u6984\u6cb9500MLx2 \u7cbe\u9009\u793c\u76d2:\u5408\u540c\u5355\u4ef7 53534\u5143 \u6570\u91cf 1\u76d2\u5143 \u5907\u6ce8:- \u4f9b\u5e94\u5546 - \u786c\u4ef6\u8d28\u4fdd - \u8f6f\u4ef6\u8d28\u4fdd - \u8fd0\u7ef4\u670d\u52a1 -","\u867e\u76ae\u6295\u5f71\u5e55\u5e03100\u5bf8:\u5408\u540c\u5355\u4ef7 44\u5143 \u6570\u91cf 1\u4e2a\u5143 \u5907\u6ce8:- \u4f9b\u5e94\u5546 - \u786c\u4ef6\u8d28\u4fdd - \u8f6f\u4ef6\u8d28\u4fdd - \u8fd0\u7ef4\u670d\u52a1 -","\u677e\u4e0b\u7535\u52a8\u5243\u987b\u5200\u5c0f\u65b9\u76d2mini\u4fbf\u643a\u6b3eCM20:\u5408\u540c\u5355\u4ef7 54\u5143 \u6570\u91cf 1\u4e2a\u5143 \u5907\u6ce8:- \u4f9b\u5e94\u5546 - \u786c\u4ef6\u8d28\u4fdd - \u8f6f\u4ef6\u8d28\u4fdd - \u8fd0\u7ef4\u670d\u52a1 -"]]', array[5087], '{"d1":"\u5218\u4eba\u8bda","d2":"\u66f4\u65b0\u4e86","d3":"\u4ea7\u54c1\u6e05\u5355","d4":["MK-MC300:\u5408\u540c\u5355\u4ef7 44433443\u5143 \u6570\u91cf 1\u4e2a\u5143 \u5907\u6ce8:- \u4f9b\u5e94\u5546 - \u786c\u4ef6\u8d28\u4fdd - \u8f6f\u4ef6\u8d28\u4fdd - \u8fd0\u7ef4\u670d\u52a1 -;LC-LC \u5149\u7ea4\u7ebf 5\u7c73:\u5408\u540c\u5355\u4ef7 53445\u5143 \u6570\u91cf 1\u6761\u5143 \u5907\u6ce8:- \u4f9b\u5e94\u5546 - \u786c\u4ef6\u8d28\u4fdd - \u8f6f\u4ef6\u8d28\u4fdd - \u8fd0\u7ef4\u670d\u52a1 -;\u6b27\u4e3d\u8587\u5170Olivoila \u6a44\u6984\u6cb9500MLx2 \u7cbe\u9009\u793c\u76d2:\u5408\u540c\u5355\u4ef7 53534\u5143 \u6570\u91cf 1\u76d2\u5143 \u5907\u6ce8:- \u4f9b\u5e94\u5546 - \u786c\u4ef6\u8d28\u4fdd - \u8f6f\u4ef6\u8d28\u4fdd - \u8fd0\u7ef4\u670d\u52a1 -;\u867e\u76ae\u6295\u5f71\u5e55\u5e03100\u5bf8:\u5408\u540c\u5355\u4ef7 44\u5143 \u6570\u91cf 1\u4e2a\u5143 \u5907\u6ce8:- \u4f9b\u5e94\u5546 - \u786c\u4ef6\u8d28\u4fdd - \u8f6f\u4ef6\u8d28\u4fdd - \u8fd0\u7ef4\u670d\u52a1 -;\u677e\u4e0b\u7535\u52a8\u5243\u987b\u5200\u5c0f\u65b9\u76d2mini\u4fbf\u643a\u6b3eCM20:\u5408\u540c\u5355\u4ef7 54\u5143 \u6570\u91cf 1\u4e2a\u5143 \u5907\u6ce8:- \u4f9b\u5e94\u5546 - \u786c\u4ef6\u8d28\u4fdd - \u8f6f\u4ef6\u8d28\u4fdd - \u8fd0\u7ef4\u670d\u52a1 -; <b>\u53d8\u4e3a<\/b> MK-MC300:\u5408\u540c\u5355\u4ef7 44433443\u5143 \u6570\u91cf 22\u4e2a\u5143 \u5907\u6ce8:- \u4f9b\u5e94\u5546 - \u786c\u4ef6\u8d28\u4fdd - \u8f6f\u4ef6\u8d28\u4fdd - \u8fd0\u7ef4\u670d\u52a1 -;LC-LC \u5149\u7ea4\u7ebf 5\u7c73:\u5408\u540c\u5355\u4ef7 53445\u5143 \u6570\u91cf 1\u6761\u5143 \u5907\u6ce8:- \u4f9b\u5e94\u5546 - \u786c\u4ef6\u8d28\u4fdd - \u8f6f\u4ef6\u8d28\u4fdd - \u8fd0\u7ef4\u670d\u52a1 -;\u6b27\u4e3d\u8587\u5170Olivoila \u6a44\u6984\u6cb9500MLx2 \u7cbe\u9009\u793c\u76d2:\u5408\u540c\u5355\u4ef7 53534\u5143 \u6570\u91cf 1\u76d2\u5143 \u5907\u6ce8:- \u4f9b\u5e94\u5546 - \u786c\u4ef6\u8d28\u4fdd - \u8f6f\u4ef6\u8d28\u4fdd - \u8fd0\u7ef4\u670d\u52a1 -;\u867e\u76ae\u6295\u5f71\u5e55\u5e03100\u5bf8:\u5408\u540c\u5355\u4ef7 44\u5143 \u6570\u91cf 1\u4e2a\u5143 \u5907\u6ce8:- \u4f9b\u5e94\u5546 - \u786c\u4ef6\u8d28\u4fdd - \u8f6f\u4ef6\u8d28\u4fdd - \u8fd0\u7ef4\u670d\u52a1 -;\u677e\u4e0b\u7535\u52a8\u5243\u987b\u5200\u5c0f\u65b9\u76d2mini\u4fbf\u643a\u6b3eCM20:\u5408\u540c\u5355\u4ef7 54\u5143 \u6570\u91cf 1\u4e2a\u5143 \u5907\u6ce8:- \u4f9b\u5e94\u5546 - \u786c\u4ef6\u8d28\u4fdd - \u8f6f\u4ef6\u8d28\u4fdd - \u8fd0\u7ef4\u670d\u52a1 -;"]}') |
| 21:37:36.583 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_sales_contracts" WHERE "id"=4491 |
| 21:37:36.584 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_sales_orders" WHERE "sales_contract_id"=4491 ORDER BY "id" DESC |
| 21:37:36.584 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 21:37:36.585 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 21:37:36.585 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001 |
| 21:37:36.586 | info | yii\db\Command::execute | INSERT INTO "a57be577deb434"."tbl_object_change_logs" ("act", "attribute", "object_id", "object_type", "created_by", "created_at", "new_value", "old_value", "description") VALUES (2, 'erpSalesOrderProducts', 1715, 20007, 1001, 'now()', '[["MK-MC300:\u5408\u540c\u5355\u4ef7 44433443\u5143 \u6570\u91cf 22\u4e2a\u5143 \u5907\u6ce8:- \u4f9b\u5e94\u5546 - \u786c\u4ef6\u8d28\u4fdd - \u8f6f\u4ef6\u8d28\u4fdd - \u8fd0\u7ef4\u670d\u52a1 -","LC-LC \u5149\u7ea4\u7ebf 5\u7c73:\u5408\u540c\u5355\u4ef7 53445\u5143 \u6570\u91cf 1\u6761\u5143 \u5907\u6ce8:- \u4f9b\u5e94\u5546 - \u786c\u4ef6\u8d28\u4fdd - \u8f6f\u4ef6\u8d28\u4fdd - \u8fd0\u7ef4\u670d\u52a1 -","\u6b27\u4e3d\u8587\u5170Olivoila \u6a44\u6984\u6cb9500MLx2 \u7cbe\u9009\u793c\u76d2:\u5408\u540c\u5355\u4ef7 53534\u5143 \u6570\u91cf 1\u76d2\u5143 \u5907\u6ce8:- \u4f9b\u5e94\u5546 - \u786c\u4ef6\u8d28\u4fdd - \u8f6f\u4ef6\u8d28\u4fdd - \u8fd0\u7ef4\u670d\u52a1 -","\u867e\u76ae\u6295\u5f71\u5e55\u5e03100\u5bf8:\u5408\u540c\u5355\u4ef7 44\u5143 \u6570\u91cf 1\u4e2a\u5143 \u5907\u6ce8:- \u4f9b\u5e94\u5546 - \u786c\u4ef6\u8d28\u4fdd - \u8f6f\u4ef6\u8d28\u4fdd - \u8fd0\u7ef4\u670d\u52a1 -","\u677e\u4e0b\u7535\u52a8\u5243\u987b\u5200\u5c0f\u65b9\u76d2mini\u4fbf\u643a\u6b3eCM20:\u5408\u540c\u5355\u4ef7 54\u5143 \u6570\u91cf 1\u4e2a\u5143 \u5907\u6ce8:- \u4f9b\u5e94\u5546 - \u786c\u4ef6\u8d28\u4fdd - \u8f6f\u4ef6\u8d28\u4fdd - \u8fd0\u7ef4\u670d\u52a1 -"]]', '[["MK-MC300:\u5408\u540c\u5355\u4ef7 44433443\u5143 \u6570\u91cf 1\u4e2a\u5143 \u5907\u6ce8:- \u4f9b\u5e94\u5546 - \u786c\u4ef6\u8d28\u4fdd - \u8f6f\u4ef6\u8d28\u4fdd - \u8fd0\u7ef4\u670d\u52a1 -","LC-LC \u5149\u7ea4\u7ebf 5\u7c73:\u5408\u540c\u5355\u4ef7 53445\u5143 \u6570\u91cf 1\u6761\u5143 \u5907\u6ce8:- \u4f9b\u5e94\u5546 - \u786c\u4ef6\u8d28\u4fdd - \u8f6f\u4ef6\u8d28\u4fdd - \u8fd0\u7ef4\u670d\u52a1 -","\u6b27\u4e3d\u8587\u5170Olivoila \u6a44\u6984\u6cb9500MLx2 \u7cbe\u9009\u793c\u76d2:\u5408\u540c\u5355\u4ef7 53534\u5143 \u6570\u91cf 1\u76d2\u5143 \u5907\u6ce8:- \u4f9b\u5e94\u5546 - \u786c\u4ef6\u8d28\u4fdd - \u8f6f\u4ef6\u8d28\u4fdd - \u8fd0\u7ef4\u670d\u52a1 -","\u867e\u76ae\u6295\u5f71\u5e55\u5e03100\u5bf8:\u5408\u540c\u5355\u4ef7 44\u5143 \u6570\u91cf 1\u4e2a\u5143 \u5907\u6ce8:- \u4f9b\u5e94\u5546 - \u786c\u4ef6\u8d28\u4fdd - \u8f6f\u4ef6\u8d28\u4fdd - \u8fd0\u7ef4\u670d\u52a1 -","\u677e\u4e0b\u7535\u52a8\u5243\u987b\u5200\u5c0f\u65b9\u76d2mini\u4fbf\u643a\u6b3eCM20:\u5408\u540c\u5355\u4ef7 54\u5143 \u6570\u91cf 1\u4e2a\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":["MK-MC300:\u5408\u540c\u5355\u4ef7 44433443\u5143 \u6570\u91cf 1\u4e2a\u5143 \u5907\u6ce8:- \u4f9b\u5e94\u5546 - \u786c\u4ef6\u8d28\u4fdd - \u8f6f\u4ef6\u8d28\u4fdd - \u8fd0\u7ef4\u670d\u52a1 -;LC-LC \u5149\u7ea4\u7ebf 5\u7c73:\u5408\u540c\u5355\u4ef7 53445\u5143 \u6570\u91cf 1\u6761\u5143 \u5907\u6ce8:- \u4f9b\u5e94\u5546 - \u786c\u4ef6\u8d28\u4fdd - \u8f6f\u4ef6\u8d28\u4fdd - \u8fd0\u7ef4\u670d\u52a1 -;\u6b27\u4e3d\u8587\u5170Olivoila \u6a44\u6984\u6cb9500MLx2 \u7cbe\u9009\u793c\u76d2:\u5408\u540c\u5355\u4ef7 53534\u5143 \u6570\u91cf 1\u76d2\u5143 \u5907\u6ce8:- \u4f9b\u5e94\u5546 - \u786c\u4ef6\u8d28\u4fdd - \u8f6f\u4ef6\u8d28\u4fdd - \u8fd0\u7ef4\u670d\u52a1 -;\u867e\u76ae\u6295\u5f71\u5e55\u5e03100\u5bf8:\u5408\u540c\u5355\u4ef7 44\u5143 \u6570\u91cf 1\u4e2a\u5143 \u5907\u6ce8:- \u4f9b\u5e94\u5546 - \u786c\u4ef6\u8d28\u4fdd - \u8f6f\u4ef6\u8d28\u4fdd - \u8fd0\u7ef4\u670d\u52a1 -;\u677e\u4e0b\u7535\u52a8\u5243\u987b\u5200\u5c0f\u65b9\u76d2mini\u4fbf\u643a\u6b3eCM20:\u5408\u540c\u5355\u4ef7 54\u5143 \u6570\u91cf 1\u4e2a\u5143 \u5907\u6ce8:- \u4f9b\u5e94\u5546 - \u786c\u4ef6\u8d28\u4fdd - \u8f6f\u4ef6\u8d28\u4fdd - \u8fd0\u7ef4\u670d\u52a1 -; <b>\u53d8\u4e3a<\/b> MK-MC300:\u5408\u540c\u5355\u4ef7 44433443\u5143 \u6570\u91cf 22\u4e2a\u5143 \u5907\u6ce8:- \u4f9b\u5e94\u5546 - \u786c\u4ef6\u8d28\u4fdd - \u8f6f\u4ef6\u8d28\u4fdd - \u8fd0\u7ef4\u670d\u52a1 -;LC-LC \u5149\u7ea4\u7ebf 5\u7c73:\u5408\u540c\u5355\u4ef7 53445\u5143 \u6570\u91cf 1\u6761\u5143 \u5907\u6ce8:- \u4f9b\u5e94\u5546 - \u786c\u4ef6\u8d28\u4fdd - \u8f6f\u4ef6\u8d28\u4fdd - \u8fd0\u7ef4\u670d\u52a1 -;\u6b27\u4e3d\u8587\u5170Olivoila \u6a44\u6984\u6cb9500MLx2 \u7cbe\u9009\u793c\u76d2:\u5408\u540c\u5355\u4ef7 53534\u5143 \u6570\u91cf 1\u76d2\u5143 \u5907\u6ce8:- \u4f9b\u5e94\u5546 - \u786c\u4ef6\u8d28\u4fdd - \u8f6f\u4ef6\u8d28\u4fdd - \u8fd0\u7ef4\u670d\u52a1 -;\u867e\u76ae\u6295\u5f71\u5e55\u5e03100\u5bf8:\u5408\u540c\u5355\u4ef7 44\u5143 \u6570\u91cf 1\u4e2a\u5143 \u5907\u6ce8:- \u4f9b\u5e94\u5546 - \u786c\u4ef6\u8d28\u4fdd - \u8f6f\u4ef6\u8d28\u4fdd - \u8fd0\u7ef4\u670d\u52a1 -;\u677e\u4e0b\u7535\u52a8\u5243\u987b\u5200\u5c0f\u65b9\u76d2mini\u4fbf\u643a\u6b3eCM20:\u5408\u540c\u5355\u4ef7 54\u5143 \u6570\u91cf 1\u4e2a\u5143 \u5907\u6ce8:- \u4f9b\u5e94\u5546 - \u786c\u4ef6\u8d28\u4fdd - \u8f6f\u4ef6\u8d28\u4fdd - \u8fd0\u7ef4\u670d\u52a1 -;"]}') |
| 21:37:36.587 | info | yii\db\Command::query | SELECT "id" FROM "a57be577deb434"."tbl_project_product_rels" WHERE "project_id"=3854 |
| 21:37:36.588 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_project_product_rels" WHERE "id"=12044 |
| 21:37:36.588 | info | yii\db\Command::execute | UPDATE "a57be577deb434"."tbl_project_product_rels" SET "product_id"=2261, "amount"='44433443', "number"=22, "supplier_id"=NULL, "hardware_from"=NULL, "software_from"=NULL, "maintenance_from"=NULL, "hardware_to"=NULL, "software_to"=NULL, "maintenance_to"=NULL, "total_amount"='977535746' WHERE "id"=12044 |
| 21:37:36.589 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 21:37:36.589 | info | yii\db\Command::query | SELECT 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_action_logs' and d.nspname = 'a57be577deb434' ORDER BY a.attnum; |
| 21:37:36.593 | info | yii\db\Command::query | select 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_action_logs' and ns.nspname='a57be577deb434' order by fns.nspname, fc.relname, a.attnum |
| 21:37:36.602 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 21:37:36.602 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: SET |
| 21:37:36.602 | info | yii\db\Command::execute | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\ProjectProductRels', 12044, 'a:2:{s:6:"number";s:2:"22";s:12:"total_amount";s:9:"977535746";}', '', 1001, '111.194.208.14') |
| 21:37:36.604 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_project_product_rels" WHERE "id"=12045 |
| 21:37:36.605 | info | yii\db\Command::execute | UPDATE "a57be577deb434"."tbl_project_product_rels" SET "product_id"=1372, "amount"='53445', "number"=1, "supplier_id"=NULL, "hardware_from"=NULL, "software_from"=NULL, "maintenance_from"=NULL, "hardware_to"=NULL, "software_to"=NULL, "maintenance_to"=NULL WHERE "id"=12045 |
| 21:37:36.605 | info | yii\db\Command::execute | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\ProjectProductRels', 12045, 'a:0:{}', '', 1001, '111.194.208.14') |
| 21:37:36.606 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_project_product_rels" WHERE "id"=12046 |
| 21:37:36.606 | info | yii\db\Command::execute | UPDATE "a57be577deb434"."tbl_project_product_rels" SET "product_id"=2265, "amount"='53534', "number"=1, "supplier_id"=NULL, "hardware_from"=NULL, "software_from"=NULL, "maintenance_from"=NULL, "hardware_to"=NULL, "software_to"=NULL, "maintenance_to"=NULL WHERE "id"=12046 |
| 21:37:36.607 | info | yii\db\Command::execute | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\ProjectProductRels', 12046, 'a:0:{}', '', 1001, '111.194.208.14') |
| 21:37:36.607 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_project_product_rels" WHERE "id"=12047 |
| 21:37:36.608 | info | yii\db\Command::execute | UPDATE "a57be577deb434"."tbl_project_product_rels" SET "product_id"=2263, "amount"='44', "number"=1, "supplier_id"=NULL, "hardware_from"=NULL, "software_from"=NULL, "maintenance_from"=NULL, "hardware_to"=NULL, "software_to"=NULL, "maintenance_to"=NULL WHERE "id"=12047 |
| 21:37:36.608 | info | yii\db\Command::execute | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\ProjectProductRels', 12047, 'a:0:{}', '', 1001, '111.194.208.14') |
| 21:37:36.609 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_project_product_rels" WHERE "id"=12048 |
| 21:37:36.609 | info | yii\db\Command::execute | UPDATE "a57be577deb434"."tbl_project_product_rels" SET "product_id"=2266, "amount"='54', "number"=1, "supplier_id"=NULL, "hardware_from"=NULL, "software_from"=NULL, "maintenance_from"=NULL, "hardware_to"=NULL, "software_to"=NULL, "maintenance_to"=NULL WHERE "id"=12048 |
| 21:37:36.610 | info | yii\db\Command::execute | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\ProjectProductRels', 12048, 'a:0:{}', '', 1001, '111.194.208.14') |
| 21:37:36.610 | info | yii\db\Command::execute | DELETE FROM "a57be577deb434"."tbl_project_product_rels" WHERE 0=1 |
| 21:37:36.623 | info | yii\db\Command::execute | UPDATE "a57be577deb434"."tbl_projects" SET "budget"='977642823', "profit_pct"='25', "description"='', "project_product_version_id"=NULL WHERE "id"=3854 |
| 21:37:36.625 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_project_change_logs" WHERE ("project_id"=3854) AND ("end_at" IS NULL) ORDER BY "id" DESC LIMIT 1 |
| 21:37:36.631 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 21:37:36.631 | info | yii\db\Command::query | SELECT 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; |
| 21:37:36.635 | info | yii\db\Command::query | select 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 |
| 21:37:36.644 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 21:37:36.644 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: SET |
| 21:37:36.644 | info | yii\db\Command::execute | UPDATE "a57be577deb434"."tbl_project_change_logs" SET "end_at"='now()' WHERE "id"=17863 |
| 21:37:36.646 | info | yii\db\Command::execute | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\ProjectChangeLogs', 17863, 'a:1:{s:6:"end_at";s:19:"1970-01-01 08:00:00";}', '', 1001, '111.194.208.14') |
| 21:37:36.646 | info | yii\db\Command::query | INSERT INTO "a57be577deb434"."tbl_project_change_logs" ("project_id", "project_status", "budget", "profit_pct", "collected", "start_from", "end_at") VALUES (3854, 3, '977642823', '25', '0', 'now()', NULL) RETURNING "id" |
| 21:37:36.648 | info | yii\db\Command::execute | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('INSERT', 'app\models\ProjectChangeLogs', 17883, 'a:8:{s:2:"id";i:17883;s:10:"project_id";i:3854;s:14:"project_status";i:3;s:6:"budget";d:977642823;s:10:"profit_pct";d:25;s:9:"collected";s:1:"0";s:10:"start_from";s:5:"now()";s:6:"end_at";N;}', '', 1001, '111.194.208.14') |
| 21:37:36.649 | info | yii\db\Command::execute | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\Projects', 3854, 'a:2:{s:6:"budget";d:977642823;s:26:"project_product_version_id";i:1349;}', '', 1001, '111.194.208.14') |
| 21:37:36.650 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"=2128 |
| 21:37:36.651 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_projects" WHERE "id"=3854 |
| 21:37:36.652 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_project_product_rels" WHERE "project_id"=3854 ORDER BY "id" |
| 21:37:36.654 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 21:37:36.654 | info | yii\db\Command::query | SELECT 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; |
| 21:37:36.657 | info | yii\db\Command::query | select 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 |
| 21:37:36.667 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 21:37:36.667 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: SET |
| 21:37:36.667 | info | yii\db\Command::query | INSERT INTO "a57be577deb434"."tbl_project_product_versions" ("project_id", "created_by", "created_at") VALUES (3854, 1001, '2026-07-04 21:37:36') RETURNING "id" |
| 21:37:36.670 | info | yii\db\Command::execute | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('INSERT', 'app\models\ProjectProductVersions', 1381, 'a:4:{s:2:"id";i:1381;s:10:"project_id";i:3854;s:10:"created_by";i:1001;s:10:"created_at";s:19:"2026-07-04 21:37:36";}', '', 1001, '111.194.208.14') |
| 21:37:36.671 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001 |
| 21:37:36.672 | info | yii\db\Command::query | INSERT 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', 3854, 1, 1381, 112, 1001, '[1381]', '[1381]', '{"d1":"\u5218\u4eba\u8bda","d2":"\u521b\u5efa\u4e86","d3":"\u4ea7\u54c1\u5386\u53f2\u62a5\u4ef7\u6e05\u5355","d4":["2026-07-04 21:37\u4ea7\u54c1\u5386\u53f2\u62a5\u4ef7\u6e05\u5355"]}') RETURNING "id" |
| 21:37:36.672 | info | yii\db\Command::execute | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('INSERT', 'app\models\ObjectChangeLogs', 643179, 'a:13:{s:2:"id";i:643179;s:9:"object_id";i:3854;s:11:"object_type";i:1;s:9:"target_id";i:1381;s:18:"target_object_type";i:112;s:3:"act";i:1;s:9:"attribute";s:6:"create";s:9:"old_value";s:6:"[1381]";s:9:"new_value";s:6:"[1381]";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-04 21:37\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') |
| 21:37:36.673 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_sales_contracts" WHERE "from_project"=3854 |
| 21:37:36.674 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001 |
| 21:37:36.674 | info | yii\db\Command::query | INSERT 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', 4491, 7, 3854, 112, 1001, '[3854]', '[3854]', '{"d1":"\u5218\u4eba\u8bda","d2":"\u521b\u5efa\u4e86","d3":"\u4ea7\u54c1\u5386\u53f2\u62a5\u4ef7\u6e05\u5355","d4":["2026-07-04 21:37\u4ea7\u54c1\u5386\u53f2\u62a5\u4ef7\u6e05\u5355"]}') RETURNING "id" |
| 21:37:36.675 | info | yii\db\Command::execute | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('INSERT', 'app\models\ObjectChangeLogs', 643180, 'a:13:{s:2:"id";i:643180;s:9:"object_id";i:4491;s:11:"object_type";i:7;s:9:"target_id";i:3854;s:18:"target_object_type";i:112;s:3:"act";i:1;s:9:"attribute";s:6:"create";s:9:"old_value";s:6:"[3854]";s:9:"new_value";s:6:"[3854]";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-04 21:37\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') |
| 21:37:36.677 | info | yii\db\Command::execute | UPDATE "a57be577deb434"."tbl_projects" SET "project_product_version_id"=1381 WHERE "id"=3854 |
| 21:37:36.680 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_project_change_logs" WHERE ("project_id"=3854) AND ("end_at" IS NULL) ORDER BY "id" DESC LIMIT 1 |
| 21:37:36.682 | info | yii\db\Command::execute | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\Projects', 3854, 'a:1:{s:26:"project_product_version_id";i:1381;}', '', 1001, '111.194.208.14') |
| 21:37:36.683 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"=2128 |
| 21:37:36.685 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 21:37:36.685 | info | yii\db\Command::query | SELECT 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; |
| 21:37:36.689 | info | yii\db\Command::query | select 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 |
| 21:37:36.698 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 21:37:36.699 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: SET |
| 21:37:36.699 | info | yii\db\Command::execute | INSERT 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 (1381, 2261, '44433443', 22, '977535746', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL), (1381, 1372, '53445', 1, '53445', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL), (1381, 2265, '53534', 1, '53534', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL), (1381, 2263, '44', 1, '44', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL), (1381, 2266, '54', 1, '54', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL) |
| 21:37:36.704 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_projects" WHERE "id"=3854 |
| 21:37:36.704 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_project_product_rels" WHERE "project_id"=3854 ORDER BY "id" |
| 21:37:36.707 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_sales_order_items" WHERE "project_id"=3854 |
| 21:37:36.713 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_project_change_logs" WHERE ("project_id"=3854) AND ("end_at" IS NULL) ORDER BY "id" DESC LIMIT 1 |
| 21:37:36.716 | info | yii\db\Command::execute | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\Projects', 3854, 'a:0:{}', '', 1001, '111.194.208.14') |
| 21:37:36.716 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"=2128 |
| 21:37:36.717 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_sales_orders" WHERE "sales_contract_id"=4491 ORDER BY "id" DESC |
| 21:37:36.719 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001 |
| 21:37:36.719 | info | yii\db\Command::execute | INSERT INTO "a57be577deb434"."tbl_object_change_logs" ("act", "attribute", "object_id", "object_type", "created_by", "created_at", "new_value", "old_value", "description") VALUES (2, 'number', 1715, 20007, 1001, 'now()', '[26]', '["5"]', '{"d1":"\u5218\u4eba\u8bda","d2":"\u66f4\u65b0\u4e86","d3":"\u4ea7\u54c1\u6570\u91cf","d4":["5 <b>\u53d8\u4e3a<\/b> 26"]}'), (2, 'amount', 1715, 20007, 1001, 'now()', '[977642823]', '["44540520"]', '{"d1":"\u5218\u4eba\u8bda","d2":"\u66f4\u65b0\u4e86","d3":"\u4ea7\u54c1\u91d1\u989d","d4":["44540520 <b>\u53d8\u4e3a<\/b> 977642823"]}') |
| 21:37:36.720 | info | yii\db\Command::execute | UPDATE "a57be577deb434"."tbl_erp_sales_orders" SET "description"='', "number"='26', "amount"='977642823' WHERE "id"=1715 |
| 21:37:36.721 | info | yii\db\Command::execute | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\ErpSalesOrders', 1715, 'a:2:{s:6:"number";d:26;s:6:"amount";d:977642823;}', '', 1001, '111.194.208.14') |
| 21:37:36.721 | info | yii\db\Command::execute | UPDATE "a57be577deb434"."tbl_sales_contracts" SET "client_id"=2128, "amount"='977642823', "description"='', "updated_at"='now()', "contract_scan"=NULL, "receipt_scan"=NULL, "contract_type"=1, "project_id"=3854, "expire_date"=NULL, "sla"='', "remind_ahead"='0 day', "expire_remind_ahead"='0 day', "including_tax"=TRUE, "is_settle"=FALSE, "is_deliver"=FALSE, "is_outbound"=FALSE, "is_draft"=FALSE, "is_edit_verify"=TRUE WHERE "id"=4491 |
| 21:37:36.722 | info | yii\db\Command::execute | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\SalesContracts', 4491, 'a:3:{s:6:"amount";d:977642823;s:12:"remind_ahead";s:5:"0 day";s:19:"expire_remind_ahead";s:5:"0 day";}', '', 1001, '111.194.208.14') |
| 21:37:36.723 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"='2128' |
| 21:37:36.723 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_projects" WHERE "id"='3854' |
| 21:37:36.724 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_project_product_rels" WHERE "project_id"=3854 ORDER BY "id" |
| 21:37:36.726 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 21:37:36.726 | info | yii\db\Command::query | SELECT 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; |
| 21:37:36.729 | info | yii\db\Command::query | select 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 |
| 21:37:36.739 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 21:37:36.739 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: SET |
| 21:37:36.739 | info | yii\db\Command::execute | UPDATE "a57be577deb434"."tbl_erp_sales_order_verify_rels" SET "status"=3 WHERE ("erp_sales_order_id"=1715) AND ("status"=0) |
| 21:37:36.740 | info | yii\db\Command::execute | DELETE FROM "a57be577deb434"."tbl_erp_sales_order_stop_verify_rels" WHERE "erp_sales_order_id"=1715 |
| 21:37:36.741 | info | yii\db\Command::execute | DELETE FROM "a57be577deb434"."tbl_erp_sales_order_stop_products" WHERE "erp_sales_order_id"=1715 |
| 21:37:36.742 | info | yii\db\Command::execute | UPDATE "a57be577deb434"."tbl_erp_sales_orders" SET "stop_at"='now()' WHERE "id"=1715 |
| 21:37:36.743 | info | yii\db\Command::execute | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\ErpSalesOrders', 1715, 'a:1:{s:7:"stop_at";s:5:"now()";}', '', 1001, '111.194.208.14') |
| 21:37:36.743 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 21:37:36.744 | info | yii\db\Command::query | SELECT 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; |
| 21:37:36.747 | info | yii\db\Command::query | select 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 |
| 21:37:36.759 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 21:37:36.759 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: SET |
| 21:37:36.759 | info | yii\db\Command::execute | INSERT 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 (1715, 2251, 2261, '44433443', '977535746', '22', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL), (1715, 2252, 1372, '53445', '53445', '1', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL), (1715, 2253, 2265, '53534', '53534', '1', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL), (1715, 2254, 2263, '44', '44', '1', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL), (1715, 2255, 2266, '54', '54', '1', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL) |
| 21:37:36.763 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 21:37:36.763 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 21:37:36.763 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_verify_processes" WHERE "id"=6 |
| 21:37:36.764 | info | yii\db\Command::execute | |
| 21:37:36.764 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_sales_order_stop_verify_rels" WHERE ("erp_sales_order_id"=1715) AND ("status"=0) ORDER BY "id" |
| 21:37:36.765 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=5087 |
| 21:37:36.765 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_sales_order_stop_verify_rels" WHERE ("status"=0) AND ("erp_sales_order_id"=1715) ORDER BY "id" |
| 21:37:36.766 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_sales_order_carbon_copy_rels" WHERE "erp_sales_order_id"=1715 |
| 21:37:36.767 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_sales_order_verify_rels" WHERE "erp_sales_order_id"=1715 ORDER BY "id" |
| 21:37:36.767 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 21:37:36.767 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 21:37:36.768 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_sales_orders" WHERE "id"=1715 |
| 21:37:36.769 | info | yii\db\Command::query | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001) |
| 21:37:36.769 | info | yii\db\Command::query | INSERT INTO "a57be577deb434"."tbl_comments" ("created_by", "object_type", "object_id", "description", "is_system", "description2") VALUES (1001, '20007', 1715, '刘人诚通过了这个审批', TRUE, 'XSDD-20260605-00004') RETURNING "id" |
| 21:37:36.770 | info | yii\db\Command::execute | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('INSERT', 'app\models\Comments', 221021, 'a:11:{s:2:"id";i:221021;s:9:"object_id";i:1715;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-20260605-00004";}', '', 1001, '111.194.208.14') |
| 21:37:36.771 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 21:37:36.771 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 21:37:36.771 | info | yii\db\Command::execute | INSERT INTO "a57be577deb434"."tbl_unread_comments" ("object_id", "object_type", "comment_id", "remind_user_id") VALUES (1715, '20007', 221021, 5087) |
| 21:37:36.774 | info | yii\db\Command::query | SELECT "channel_id" FROM "global"."tbl_logins" WHERE ("id"=5087) AND ("id" != 1001) AND (channel_id IS NOT NULL) |
| 21:37:36.774 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"=2128 |
| 21:37:36.775 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_projects" WHERE "id"=3854 |
| 21:37:36.776 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: INCR |
| 21:37:36.776 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: HSET |
| 21:37:36.777 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: LPUSH |
| 21:37:36.777 | info | yii\db\Command::execute | UPDATE "a57be577deb434"."tbl_erp_sales_orders" SET "updated_at"='now()' WHERE "id"=1715 |
| 21:37:36.778 | info | yii\db\Command::execute | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\ErpSalesOrders', 1715, 'a:0:{}', '', 1001, '111.194.208.14') |
| 21:37:36.778 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_sales_order_stop_products" WHERE "erp_sales_order_id"=1715 |
| 21:37:36.779 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 21:37:36.779 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 21:37:36.779 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_sales_order_products" WHERE "id"=2251 |
| 21:37:36.780 | info | yii\db\Command::execute | UPDATE "a57be577deb434"."tbl_erp_sales_order_products" SET "number"='22', "total_amount"='977535746', "last_number"='22', "last_amount"='44433443', "last_total_amount"='977535746' WHERE "id"=2251 |
| 21:37:36.780 | info | yii\db\Command::execute | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\ErpSalesOrderProducts', 2251, 'a:4:{s:6:"number";s:2:"22";s:12:"total_amount";s:9:"977535746";s:11:"last_number";s:2:"22";s:17:"last_total_amount";s:9:"977535746";}', '', 1001, '111.194.208.14') |
| 21:37:36.781 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_sales_order_products" WHERE "id"=2252 |
| 21:37:36.782 | info | yii\db\Command::execute | UPDATE "a57be577deb434"."tbl_erp_sales_order_products" SET "last_number"='1', "last_amount"='53445', "last_total_amount"='53445' WHERE "id"=2252 |
| 21:37:36.782 | info | yii\db\Command::execute | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\ErpSalesOrderProducts', 2252, 'a:0:{}', '', 1001, '111.194.208.14') |
| 21:37:36.782 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_sales_order_products" WHERE "id"=2253 |
| 21:37:36.783 | info | yii\db\Command::execute | UPDATE "a57be577deb434"."tbl_erp_sales_order_products" SET "last_number"='1', "last_amount"='53534', "last_total_amount"='53534' WHERE "id"=2253 |
| 21:37:36.783 | info | yii\db\Command::execute | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\ErpSalesOrderProducts', 2253, 'a:0:{}', '', 1001, '111.194.208.14') |
| 21:37:36.784 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_sales_order_products" WHERE "id"=2254 |
| 21:37:36.784 | info | yii\db\Command::execute | UPDATE "a57be577deb434"."tbl_erp_sales_order_products" SET "last_number"='1', "last_amount"='44', "last_total_amount"='44' WHERE "id"=2254 |
| 21:37:36.785 | info | yii\db\Command::execute | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\ErpSalesOrderProducts', 2254, 'a:0:{}', '', 1001, '111.194.208.14') |
| 21:37:36.785 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_sales_order_products" WHERE "id"=2255 |
| 21:37:36.786 | info | yii\db\Command::execute | UPDATE "a57be577deb434"."tbl_erp_sales_order_products" SET "last_number"='1', "last_amount"='54', "last_total_amount"='54' WHERE "id"=2255 |
| 21:37:36.786 | info | yii\db\Command::execute | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\ErpSalesOrderProducts', 2255, 'a:0:{}', '', 1001, '111.194.208.14') |
| 21:37:36.787 | info | yii\db\Command::execute | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\ErpSalesOrders', 1715, 'a:0:{}', '', 1001, '111.194.208.14') |
| 21:37:36.787 | info | yii\db\Command::execute | DELETE FROM "a57be577deb434"."tbl_erp_sales_order_products" WHERE ("id" NOT IN (2251, 2252, 2253, 2254, 2255)) AND ("erp_sales_order_id"=1715) |
| 21:37:36.788 | info | yii\db\Command::execute | DELETE FROM "a57be577deb434"."tbl_erp_sales_order_stop_products" WHERE "erp_sales_order_id"=1715 |
| 21:37:36.788 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_sales_order_products" WHERE "erp_sales_order_id"=1715 |
| 21:37:36.789 | info | yii\db\Command::execute | DELETE FROM "a57be577deb434"."tbl_project_product_rels" WHERE "project_id"=3854 |
| 21:37:36.790 | info | yii\db\Command::execute | INSERT 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 (3854, 2251, 2261, '44433443', '977535746', 22, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL), (3854, 2252, 1372, '53445', '53445', 1, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL), (3854, 2253, 2265, '53534', '53534', 1, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL), (3854, 2254, 2263, '44', '44', 1, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL), (3854, 2255, 2266, '54', '54', 1, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL) |
| 21:37:36.793 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_project_change_logs" WHERE ("project_id"=3854) AND ("end_at" IS NULL) ORDER BY "id" DESC LIMIT 1 |
| 21:37:36.795 | info | yii\db\Command::execute | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\Projects', 3854, 'a:0:{}', '', 1001, '111.194.208.14') |
| 21:37:36.796 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"=2128 |
| 21:37:36.796 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_sales_contracts" WHERE "id"=4491 |
| 21:37:36.797 | info | yii\db\Command::execute | UPDATE "a57be577deb434"."tbl_sales_contracts" SET "is_edit_verify"=FALSE WHERE "id"=4491 |
| 21:37:36.798 | info | yii\db\Command::execute | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\SalesContracts', 4491, 'a:0:{}', '', 1001, '111.194.208.14') |
| 21:37:36.798 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"=2128 |
| 21:37:36.799 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_projects" WHERE "id"=3854 |
| 21:37:36.800 | info | yii\db\Command::query | SELECT 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"=4491) AND ("t"."is_payment_settle"=TRUE) AND ("t"."status" IN (2, 5)) |
| 21:37:36.801 | info | yii\db\Command::query | SELECT 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"=4491) AND ("t"."status" IN (2, 5)) |
| 21:37:36.802 | info | yii\db\Command::query | SELECT 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"=4491) AND ("t"."status" IN (2, 5)) AND ("t"."is_payment_settle"=TRUE) |
| 21:37:36.803 | info | yii\db\Command::query | SELECT 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"=4491) AND ("t"."status"=1)) |
| 21:37:36.803 | info | yii\db\Command::query | SELECT 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"=4491) AND ("t"."status"=1)) |
| 21:37:36.804 | info | yii\db\Command::query | SELECT 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"=4491) AND ("t"."status"=1)) |
| 21:37:36.805 | info | yii\db\Command::query | SELECT 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"=4491) AND ("t"."is_payment_settle"=TRUE) AND ("t"."status" IN (1, 2, 5)) |
| 21:37:36.806 | info | yii\db\Command::query | SELECT 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"=4491) AND ("t"."status" IN (1, 2, 5)) |
| 21:37:36.806 | info | yii\db\Command::query | SELECT 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"=4491) AND ("t"."status" IN (1, 2, 5)) |
| 21:37:36.807 | info | yii\db\Command::execute | UPDATE "a57be577deb434"."tbl_sales_contracts" SET "erp_settle_amount"='0', "erp_un_settle_amount"='977642823', "erp_all_settle_amount"='0' WHERE "id"=4491 |
| 21:37:36.808 | info | yii\db\Command::execute | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\SalesContracts', 4491, 'a:1:{s:20:"erp_un_settle_amount";s:8:"44540520";}', '', 1001, '111.194.208.14') |
| 21:37:36.808 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"=2128 |
| 21:37:36.809 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_projects" WHERE "id"=3854 |
| 21:37:36.810 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_projects" WHERE "id"=3854 |
| 21:37:36.812 | info | yii\db\Command::execute | UPDATE "a57be577deb434"."tbl_projects" SET "collected"='0' WHERE "id"=3854 |
| 21:37:36.813 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_project_change_logs" WHERE ("project_id"=3854) AND ("end_at" IS NULL) ORDER BY "id" DESC LIMIT 1 |
| 21:37:36.815 | info | yii\db\Command::execute | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\Projects', 3854, 'a:0:{}', '', 1001, '111.194.208.14') |
| 21:37:36.815 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"=2128 |
| 21:37:36.816 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_project_status_logs" WHERE "project_id"=3854 ORDER BY "created_at" DESC |
| 21:37:36.817 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 21:37:36.817 | info | yii\db\Command::query | SELECT 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; |
| 21:37:36.821 | info | yii\db\Command::query | select 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 |
| 21:37:36.831 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 21:37:36.831 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: SET |
| 21:37:36.832 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_sales_contracts" WHERE "id"=4491 |
| 21:37:36.832 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 21:37:36.833 | info | yii\db\Command::query | SELECT 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; |
| 21:37:36.836 | info | yii\db\Command::query | select 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 |
| 21:37:36.845 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 21:37:36.845 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: SET |
| 21:37:36.846 | info | yii\db\Command::execute | UPDATE "a57be577deb434"."tbl_sales_contract_payment_collection_remind_dates" SET "paid_amount"='0', "status"=0, "overdue_days"=NULL WHERE "contract_id"=4491 |
| 21:37:36.846 | info | yii\db\Command::query | SELECT 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"=4491) AND ("t"."status" IN (2, 5, 1)) |
| 21:37:36.847 | info | yii\db\Command::query | SELECT 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"=4491) AND ("t"."status" IN (2, 5, 1)) |
| 21:37:36.848 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_projects" WHERE "id"=3854 |
| 21:37:36.848 | info | yii\db\Command::query | SELECT SUM(amount) FROM "a57be577deb434"."tbl_sales_contract_payment_collection_remind_dates" WHERE "contract_id"=4491 |
| 21:37:36.850 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_project_change_logs" WHERE ("project_id"=3854) AND ("end_at" IS NULL) ORDER BY "id" DESC LIMIT 1 |
| 21:37:36.852 | info | yii\db\Command::execute | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\Projects', 3854, 'a:0:{}', '', 1001, '111.194.208.14') |
| 21:37:36.853 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"=2128 |
| 21:37:36.854 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_sales_contract_payment_collection_remind_dates" WHERE ("contract_id"=4491) AND (amount > paid_amount) ORDER BY "remind_date" |
| 21:37:36.855 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_sales_order_products" WHERE "erp_sales_order_id"=1715 |
| 21:37:36.856 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_sales_outbound_products" WHERE "erp_sales_order_product_id" IN (2251, 2252, 2253, 2254, 2255) |
| 21:37:36.856 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 21:37:36.856 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 21:37:36.857 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_sales_outbounds" WHERE "id"=159 |
| 21:37:36.857 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 21:37:36.857 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 21:37:36.858 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_sales_outbound_spent_products" WHERE "erp_sales_outbound_product_id"=459 |
| 21:37:36.858 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 21:37:36.858 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 21:37:36.859 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_sales_return_products" WHERE "erp_sales_outbound_spent_product_id"=548 |
| 21:37:36.860 | info | yii\db\Command::execute | UPDATE "a57be577deb434"."tbl_erp_sales_order_products" SET "outbound"='1' WHERE "id"=2251 |
| 21:37:36.860 | info | yii\db\Command::execute | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\ErpSalesOrderProducts', 2251, 'a:0:{}', '', 1001, '111.194.208.14') |
| 21:37:36.861 | info | yii\db\Command::execute | UPDATE "a57be577deb434"."tbl_project_product_rels" SET "cost"=NULL, "total_cost"=NULL WHERE "erp_sales_order_product_id"=2251 |
| 21:37:36.862 | info | yii\db\Command::execute | UPDATE "a57be577deb434"."tbl_erp_sales_order_products" SET "outbound"='0' WHERE "id"=2252 |
| 21:37:36.862 | info | yii\db\Command::execute | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\ErpSalesOrderProducts', 2252, 'a:0:{}', '', 1001, '111.194.208.14') |
| 21:37:36.863 | info | yii\db\Command::execute | UPDATE "a57be577deb434"."tbl_project_product_rels" SET "cost"=NULL, "total_cost"=NULL WHERE "erp_sales_order_product_id"=2252 |
| 21:37:36.864 | info | yii\db\Command::execute | UPDATE "a57be577deb434"."tbl_erp_sales_order_products" SET "outbound"='0' WHERE "id"=2253 |
| 21:37:36.864 | info | yii\db\Command::execute | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\ErpSalesOrderProducts', 2253, 'a:0:{}', '', 1001, '111.194.208.14') |
| 21:37:36.865 | info | yii\db\Command::execute | UPDATE "a57be577deb434"."tbl_project_product_rels" SET "cost"=NULL, "total_cost"=NULL WHERE "erp_sales_order_product_id"=2253 |
| 21:37:36.865 | info | yii\db\Command::execute | UPDATE "a57be577deb434"."tbl_erp_sales_order_products" SET "outbound"='0' WHERE "id"=2254 |
| 21:37:36.866 | info | yii\db\Command::execute | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\ErpSalesOrderProducts', 2254, 'a:0:{}', '', 1001, '111.194.208.14') |
| 21:37:36.866 | info | yii\db\Command::execute | UPDATE "a57be577deb434"."tbl_project_product_rels" SET "cost"=NULL, "total_cost"=NULL WHERE "erp_sales_order_product_id"=2254 |
| 21:37:36.867 | info | yii\db\Command::execute | UPDATE "a57be577deb434"."tbl_erp_sales_order_products" SET "outbound"='0' WHERE "id"=2255 |
| 21:37:36.868 | info | yii\db\Command::execute | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\ErpSalesOrderProducts', 2255, 'a:0:{}', '', 1001, '111.194.208.14') |
| 21:37:36.868 | info | yii\db\Command::execute | UPDATE "a57be577deb434"."tbl_project_product_rels" SET "cost"=NULL, "total_cost"=NULL WHERE "erp_sales_order_product_id"=2255 |
| 21:37:36.869 | info | yii\db\Command::execute | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\ErpSalesOrders', 1715, 'a:0:{}', '', 1001, '111.194.208.14') |
| 21:37:36.870 | info | yii\db\Command::execute | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\SalesContracts', 4491, 'a:0:{}', '', 1001, '111.194.208.14') |
| 21:37:36.870 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"=2128 |
| 21:37:36.871 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_projects" WHERE "id"=3854 |
| 21:37:36.871 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001 |
| 21:37:36.872 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001 |
| 21:37:36.872 | info | yii\db\Command::execute | INSERT INTO "a57be577deb434"."tbl_object_change_logs" ("act", "attribute", "object_id", "object_type", "created_by", "created_at", "new_value", "old_value", "description") VALUES (11, 'status', 1715, 20007, 1001, 'now()', '["\u5218\u4eba\u8bda"]', '[]', '{"d1":"\u5218\u4eba\u8bda","d2":"\u7f16\u8f91\u4e86","d3":"\u9500\u552e\u8ba2\u5355\u7533\u8bf7","d4":""}') |
| 21:37:36.874 | info | yii\db\Command::execute | UPDATE "a57be577deb434"."tbl_projects" SET "contract_type"=1 WHERE "id"=3854 |
| 21:37:36.875 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_project_change_logs" WHERE ("project_id"=3854) AND ("end_at" IS NULL) ORDER BY "id" DESC LIMIT 1 |
| 21:37:36.877 | info | yii\db\Command::execute | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\Projects', 3854, 'a:0:{}', '', 1001, '111.194.208.14') |
| 21:37:36.878 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"=2128 |
| 21:37:36.878 | info | yii\db\Command::query | SELECT "id" FROM "a57be577deb434"."tbl_sales_contract_invoices" WHERE "contract_id"=4491 |
| 21:37:36.880 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_sales_contract_invoices" WHERE 0=1 |
| 21:37:36.881 | info | yii\db\Command::execute | DELETE FROM "a57be577deb434"."tbl_sales_contract_invoices" WHERE 0=1 |
| 21:37:36.882 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_projects" WHERE "id"=3854 |
| 21:37:36.883 | info | yii\db\Command::execute | DELETE FROM "a57be577deb434"."tbl_invoices" WHERE "project_id"=3854 |
| 21:37:36.886 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_sales_contract_invoices" WHERE "contract_id"=4491 |
| 21:37:36.887 | info | yii\db\Command::execute | |
| 21:37:36.888 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_sales_orders" WHERE "sales_contract_id"=4491 ORDER BY "id" DESC |
| 21:37:36.889 | info | yii\db\Command::query | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_erp_sales_order_products" WHERE "erp_sales_order_id"=1715) |
| 21:37:36.889 | info | yii\db\Command::execute | |
| 21:37:36.889 | info | yii\db\Command::execute | UPDATE "a57be577deb434"."tbl_sales_contracts" SET "is_outbound"=FALSE WHERE "id"=4491 |
| 21:37:36.890 | info | yii\db\Command::execute | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\SalesContracts', 4491, 'a:0:{}', '', 1001, '111.194.208.14') |
| 21:37:36.891 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"='2128' |
| 21:37:36.891 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_projects" WHERE "id"='3854' |
| 21:37:36.892 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_sales_supplier_rels" WHERE "contract_id"=4491 |
| 21:37:36.893 | info | yii\db\Command::execute | DELETE FROM "a57be577deb434"."tbl_sales_supplier_rels" WHERE "contract_id"=4491 |
| 21:37:36.894 | info | yii\db\Command::execute | DELETE FROM "a57be577deb434"."tbl_purchase_client_rels" WHERE "project_id"=3854 |
| 21:37:36.898 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=105) AND ("object_id"=4491) |
| 21:37:36.902 | info | yii\db\Command::execute | DELETE FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=105) AND ("object_id"=4491) |
| 21:37:36.906 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_sales_contract_remind_receivers" WHERE "contract_id"=4491 |
| 21:37:36.906 | info | yii\db\Command::execute | DELETE FROM "a57be577deb434"."tbl_sales_contract_remind_receivers" WHERE "contract_id"=4491 |
| 21:37:36.907 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_sales_contract_payment_collection_remind_receivers" WHERE "contract_id"=4491 |
| 21:37:36.907 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 21:37:36.907 | info | yii\db\Command::query | SELECT 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; |
| 21:37:36.911 | info | yii\db\Command::query | select 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 |
| 21:37:36.920 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 21:37:36.921 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: SET |
| 21:37:36.921 | info | yii\db\Command::execute | DELETE FROM "a57be577deb434"."tbl_sales_contract_payment_collection_remind_receivers" WHERE "contract_id"=4491 |
| 21:37:36.922 | info | yii\db\Command::query | INSERT INTO "a57be577deb434"."tbl_sales_contract_payment_collection_remind_receivers" ("contract_id", "user_id") VALUES (4491, 5087) RETURNING "id" |
| 21:37:36.925 | info | yii\db\Command::execute | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('INSERT', 'app\models\SalesContractPaymentCollectionRemindReceivers', 10175, 'a:3:{s:2:"id";i:10175;s:11:"contract_id";i:4491;s:7:"user_id";s:4:"5087";}', '', 1001, '111.194.208.14') |
| 21:37:36.926 | info | yii\db\Command::query | SELECT "remind_date" FROM "a57be577deb434"."tbl_service_contract_remind_dates" WHERE "contract_id"=4491 |
| 21:37:36.927 | info | yii\db\Command::execute | DELETE FROM "a57be577deb434"."tbl_service_contract_remind_dates" WHERE ("contract_id"=4491) AND (0=1) |
| 21:37:36.927 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_service_contract_remind_receivers" WHERE "contract_id"=4491 |
| 21:37:36.927 | info | yii\db\Command::execute | DELETE FROM "a57be577deb434"."tbl_service_contract_remind_receivers" WHERE "contract_id"=4491 |
| 21:37:36.928 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_sales_contracts" WHERE "id"=4491 |
| 21:37:36.929 | info | yii\db\Command::query | SELECT 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"=4491) AND ("t"."is_payment_settle"=TRUE) AND ("t"."status" IN (2, 5)) |
| 21:37:36.932 | info | yii\db\Command::query | SELECT 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"=4491) AND ("t"."status" IN (2, 5)) |
| 21:37:36.932 | info | yii\db\Command::query | SELECT 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"=4491) AND ("t"."status" IN (2, 5)) AND ("t"."is_payment_settle"=TRUE) |
| 21:37:36.934 | info | yii\db\Command::query | SELECT 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"=4491) AND ("t"."status"=1)) |
| 21:37:36.934 | info | yii\db\Command::query | SELECT 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"=4491) AND ("t"."status"=1)) |
| 21:37:36.935 | info | yii\db\Command::query | SELECT 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"=4491) AND ("t"."status"=1)) |
| 21:37:36.937 | info | yii\db\Command::query | SELECT 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"=4491) AND ("t"."is_payment_settle"=TRUE) AND ("t"."status" IN (1, 2, 5)) |
| 21:37:36.937 | info | yii\db\Command::query | SELECT 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"=4491) AND ("t"."status" IN (1, 2, 5)) |
| 21:37:36.938 | info | yii\db\Command::query | SELECT 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"=4491) AND ("t"."status" IN (1, 2, 5)) |
| 21:37:36.939 | info | yii\db\Command::execute | UPDATE "a57be577deb434"."tbl_sales_contracts" SET "erp_settle_amount"='0', "erp_un_settle_amount"='977642823', "erp_all_settle_amount"='0' WHERE "id"=4491 |
| 21:37:36.940 | info | yii\db\Command::execute | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\SalesContracts', 4491, 'a:0:{}', '', 1001, '111.194.208.14') |
| 21:37:36.940 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"=2128 |
| 21:37:36.941 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_projects" WHERE "id"=3854 |
| 21:37:36.941 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_projects" WHERE "id"=3854 |
| 21:37:36.943 | info | yii\db\Command::execute | UPDATE "a57be577deb434"."tbl_projects" SET "collected"='0' WHERE "id"=3854 |
| 21:37:36.944 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_project_change_logs" WHERE ("project_id"=3854) AND ("end_at" IS NULL) ORDER BY "id" DESC LIMIT 1 |
| 21:37:36.946 | info | yii\db\Command::execute | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\Projects', 3854, 'a:0:{}', '', 1001, '111.194.208.14') |
| 21:37:36.947 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"=2128 |
| 21:37:36.947 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_project_status_logs" WHERE "project_id"=3854 ORDER BY "created_at" DESC |
| 21:37:36.948 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_sales_contracts" WHERE "id"=4491 |
| 21:37:36.949 | info | yii\db\Command::execute | UPDATE "a57be577deb434"."tbl_sales_contract_payment_collection_remind_dates" SET "paid_amount"='0', "status"=0, "overdue_days"=NULL WHERE "contract_id"=4491 |
| 21:37:36.949 | info | yii\db\Command::query | SELECT 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"=4491) AND ("t"."status" IN (2, 5, 1)) |
| 21:37:36.950 | info | yii\db\Command::query | SELECT 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"=4491) AND ("t"."status" IN (2, 5, 1)) |
| 21:37:36.951 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_projects" WHERE "id"=3854 |
| 21:37:36.951 | info | yii\db\Command::query | SELECT SUM(amount) FROM "a57be577deb434"."tbl_sales_contract_payment_collection_remind_dates" WHERE "contract_id"=4491 |
| 21:37:36.953 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_project_change_logs" WHERE ("project_id"=3854) AND ("end_at" IS NULL) ORDER BY "id" DESC LIMIT 1 |
| 21:37:36.955 | info | yii\db\Command::execute | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\Projects', 3854, 'a:0:{}', '', 1001, '111.194.208.14') |
| 21:37:36.956 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"=2128 |
| 21:37:36.956 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_sales_contract_payment_collection_remind_dates" WHERE ("contract_id"=4491) AND (amount > paid_amount) ORDER BY "remind_date" |
| 21:37:36.957 | info | yii\db\Command::query | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_id"=4491) AND ("object_type"=106)) |
| 21:37:36.961 | info | yii\db\Command::query | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_id"=4491) AND ("object_type"=107)) |
| 21:37:36.964 | info | yii\db\Command::query | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_id"=4491) AND ("object_type"=105)) |
| 21:37:36.967 | info | yii\db\Command::execute | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\SalesContracts', 4491, 'a:0:{}', '', 1001, '111.194.208.14') |
| 21:37:36.968 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"=2128 |
| 21:37:36.968 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_projects" WHERE "id"=3854 |
| 21:37:36.969 | trace | yii\db\Transaction::commit | Commit transaction |
| 21:37:36.971 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 21:37:36.971 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 21:37:36.971 | info | yii\db\Command::query | INSERT 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":"4491","client_id":"2128","project_id":"3854","project_name":"\u5907\u4efd\u9879\u76ee\u4e8c\u671f","amount":"44540520","contract_scan":"","receipt_scan":"","contract_type":"1","serial_no":"2026-06-05-001","signed_at":"2026-06-05","budget":"44540520","profit":"244410705.75","profit_pct":"25.00","description":"","expire_date":"","expire_remind_ahead":"","project_product_version_id":"","salesContractPayments":{"new":[""]},"payment_collection_remind_ahead":"1 day","salesContractPaymentCollectionRemindReceivers":["5087"],"sla":"","including_tax":"1","remind_ahead":"","is_draft":"0","is_settle":"0","is_deliver":"0","is_outbound":"0","client_name":"\u5317\u4eac\u79d1\u6280\u6709\u9650\u516c\u53f8","projectContactPoints":"","projectContactPointRels":"","contractScans":"","serviceContractRemindDates":"","salesSupplierRels":"","projectProductRels":{"12044":{"product_id":"2261","amount":"44433443","total_amount":"977535746","number":"22","description":"","hardware_from":"","hardware_to":"","maintenance_from":"","maintenance_to":"","software_from":"","software_to":"","supplier_id":""},"12045":{"product_id":"1372","amount":"53445","total_amount":"53445","number":"1","description":"","hardware_from":"","hardware_to":"","maintenance_from":"","maintenance_to":"","software_from":"","software_to":"","supplier_id":""},"12046":{"product_id":"2265","amount":"53534","total_amount":"53534","number":"1","description":"","hardware_from":"","hardware_to":"","maintenance_from":"","maintenance_to":"","software_from":"","software_to":"","supplier_id":""},"12047":{"product_id":"2263","amount":"44","total_amount":"44","number":"1","description":"","hardware_from":"","hardware_to":"","maintenance_from":"","maintenance_to":"","software_from":"","software_to":"","supplier_id":""},"12048":{"product_id":"2266","amount":"54","total_amount":"54","number":"1","description":"","hardware_from":"","hardware_to":"","maintenance_from":"","maintenance_to":"","software_from":"","software_to":"","supplier_id":""}},"salesContractInvoices":"","projectProductTypes":{"4":{"budget":"977589191","profit":"244397297.75","pct":"25"},"23":{"budget":"53588","profit":"13397","pct":"25"},"21":{"budget":"44","profit":"11","pct":"25"}},"salesContractRemindReceivers":"","serviceContractRemindReceivers":""},"web_access_token":"wx4hXh9V-DIrZeBjtGStxgwx5HvDWnxk"}', '{"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; rv:151.0) Gecko\/20100101 Firefox\/151.0"}', FALSE, '2026-07-04 21:37:36', 537995264) RETURNING "id" |
| 21:37:36.973 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 21:37:36.973 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: SET |