6a58a4fc78377: POST https://beta.jinchangxiao.com/vue/purchase-contract/save-edit at 2026-07-16 05:31:40 pm by 114.244.130.25
Log Messages
总计335条数据
| Time | Level | Category | Message |
|---|---|---|---|
| 17:31:40.491 | trace | yii\base\Application::bootstrap | Bootstrap with yii\log\Dispatcher |
| 17:31:40.491 | trace | yii\base\Module::getModule | Loading module: debug |
| 17:31:40.492 | trace | yii\base\Application::bootstrap | Bootstrap with yii\debug\Module::bootstrap() |
| 17:31:40.492 | trace | yii\redis\Connection::open | Opening redis DB connection: redis.server.local:6379, database=1 |
| 17:31:40.492 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: SELECT |
| 17:31:40.493 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 17:31:40.493 | info | time tracing start | 1784194300493431040 |
| 17:31:40.493 | trace | yii\web\UrlManager::parseRequest | No matching URL rules. Using default URL parsing logic. |
| 17:31:40.493 | trace | yii\web\Application::handleRequest | Route requested: 'vue/purchase-contract/save-edit' |
| 17:31:40.493 | trace | yii\base\Module::getModule | Loading module: vue |
| 17:31:40.494 | info | yii\web\Session::open | Session started |
| 17:31:40.495 | info | yii\db\Command::query | SELECT * FROM "global"."vw_user_login" WHERE "id"=1001 |
| 17:31:40.495 | info | yii\db\Connection::open | Opening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta |
| 17:31:40.497 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 17:31:40.497 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 17:31:40.497 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 17:31:40.498 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 17:31:40.498 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001 |
| 17:31:40.499 | trace | yii\base\Controller::runAction | Route to run: vue/purchase-contract/save-edit |
| 17:31:40.499 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 17:31:40.501 | trace | uranus\rbac\DbManager::checkAccessFromCache | Checking role: Admin |
| 17:31:40.501 | trace | yii\base\InlineAction::runWithParams | Running action: app\modules\vue\controllers\PurchaseContractController::actionSaveEdit() |
| 17:31:40.501 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_purchase_contracts" WHERE "id"='4376' |
| 17:31:40.502 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 17:31:40.503 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 17:31:40.503 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 17:31:40.504 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 17:31:40.506 | trace | yii\base\Model::onUnsafeAttribute | Failed to set unsafe attribute 'id' in 'app\models\PurchaseContracts'. |
| 17:31:40.506 | trace | yii\base\Model::onUnsafeAttribute | Failed to set unsafe attribute 'contractScans' in 'app\models\PurchaseContracts'. |
| 17:31:40.506 | trace | yii\base\Model::onUnsafeAttribute | Failed to set unsafe attribute 'product_number' in 'app\models\PurchaseContracts'. |
| 17:31:40.506 | trace | yii\base\Model::onUnsafeAttribute | Failed to set unsafe attribute 'product_amount' in 'app\models\PurchaseContracts'. |
| 17:31:40.506 | trace | yii\base\Model::onUnsafeAttribute | Failed to set unsafe attribute 'purchaseContractProductRels' in 'app\models\PurchaseContracts'. |
| 17:31:40.506 | trace | yii\base\Model::onUnsafeAttribute | Failed to set unsafe attribute 'receiptScans' in 'app\models\PurchaseContracts'. |
| 17:31:40.506 | trace | yii\base\Model::onUnsafeAttribute | Failed to set unsafe attribute 'purchaseClientRels' in 'app\models\PurchaseContracts'. |
| 17:31:40.506 | trace | yii\base\Model::onUnsafeAttribute | Failed to set unsafe attribute 'PurchaseContractInvoices' in 'app\models\PurchaseContracts'. |
| 17:31:40.506 | trace | yii\base\Model::onUnsafeAttribute | Failed to set unsafe attribute 'purchaseContractContactPoints' in 'app\models\PurchaseContracts'. |
| 17:31:40.506 | trace | yii\base\Model::onUnsafeAttribute | Failed to set unsafe attribute 'purchaseContractContactPointRels' in 'app\models\PurchaseContracts'. |
| 17:31:40.506 | info | yii\db\Command::query | SELECT "id" FROM "a57be577deb434"."tbl_purchase_contracts" WHERE "serial_no"='TSKJ20260112-HYF-001' LIMIT 2 |
| 17:31:40.507 | info | yii\db\Command::query | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_suppliers" WHERE "id"='756') |
| 17:31:40.508 | info | yii\db\Command::query | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"='1011') |
| 17:31:40.508 | info | yii\db\Command::query | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1011) |
| 17:31:40.509 | trace | yii\db\Transaction::begin | Begin transaction |
| 17:31:40.509 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001 |
| 17:31:40.510 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001 |
| 17:31:40.511 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 17:31:40.511 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 17:31:40.511 | 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, 'signed_at', 4376, 13, 1001, 'now()', '["2026-07-14"]', '["2026-01-12"]', '{"d1":"\u5218\u4eba\u8bda","d2":"\u66f4\u65b0\u4e86","d3":"\u7b7e\u8ba2\u65e5\u671f","d4":["2026-01-12 <b>\u53d8\u4e3a<\/b> 2026-07-14"]}'), (2, 'amount', 4376, 13, 1001, 'now()', '["332380\u5143"]', '["380\u5143"]', '{"d1":"\u5218\u4eba\u8bda","d2":"\u66f4\u65b0\u4e86","d3":"\u5408\u540c\u603b\u989d","d4":["380\u5143 <b>\u53d8\u4e3a<\/b> 332380\u5143"]}') |
| 17:31:40.512 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=108) AND ("object_id"=4376) |
| 17:31:40.516 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001 |
| 17:31:40.516 | 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, 'contractScans', 4376, 13, 1001, 'now()', '[["32848","32849"]]', '[[]]', '{"d1":"\u5218\u4eba\u8bda","d2":"\u66f4\u65b0\u4e86","d3":"\u5408\u540c","d4":[""]}') |
| 17:31:40.517 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_purchase_contracts" WHERE "id"=4376 |
| 17:31:40.517 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_purchase_orders" WHERE "purchase_contract_id"=4376 |
| 17:31:40.519 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 17:31:40.519 | 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_purchase_orders' and d.nspname = 'a57be577deb434' ORDER BY a.attnum; |
| 17:31:40.525 | 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_purchase_orders' and ns.nspname='a57be577deb434' order by fns.nspname, fc.relname, a.attnum |
| 17:31:40.542 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 17:31:40.542 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: SET |
| 17:31:40.543 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001 |
| 17:31:40.543 | 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, 'contractScans', 2164, 20001, 1001, 'now()', '[["32848","32849"]]', '[[]]', '{"d1":"\u5218\u4eba\u8bda","d2":"\u66f4\u65b0\u4e86","d3":"\u5408\u540c","d4":[""]}') |
| 17:31:40.544 | info | yii\db\Command::execute | DELETE FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=108) AND ("object_id"=4376) |
| 17:31:40.547 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 17:31:40.547 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 17:31:40.547 | info | yii\db\Command::execute | INSERT INTO "a57be577deb434"."tbl_attachement_relationships" ("object_type", "object_id", "attachment_id") VALUES (108, 4376, 32848), (108, 4376, 32849) |
| 17:31:40.548 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=111) AND ("object_id"=4376) |
| 17:31:40.551 | info | yii\db\Command::execute | DELETE FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=111) AND ("object_id"=4376) |
| 17:31:40.555 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_purchase_client_rels" WHERE "contract_id"=4376 |
| 17:31:40.555 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 17:31:40.556 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 17:31:40.556 | info | yii\db\Command::execute | DELETE FROM "a57be577deb434"."tbl_purchase_client_rels" WHERE "contract_id"=4376 |
| 17:31:40.556 | info | yii\db\Command::execute | DELETE FROM "a57be577deb434"."tbl_sales_supplier_rels" WHERE "purchase_id"=4376 |
| 17:31:40.557 | info | yii\db\Command::query | INSERT INTO "a57be577deb434"."tbl_purchase_client_rels" ("contract_id", "client_id", "project_id") VALUES (4376, 2553, 4096) RETURNING "id" |
| 17:31:40.559 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 17:31:40.559 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 17:31:40.559 | 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\PurchaseClientRels', 4820, 'a:4:{s:2:"id";i:4820;s:11:"contract_id";i:4376;s:9:"client_id";s:4:"2553";s:10:"project_id";s:4:"4096";}', '', 1001, '114.244.130.25') |
| 17:31:40.560 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_sales_contracts" WHERE "from_project"='4096' |
| 17:31:40.561 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 17:31:40.561 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 17:31:40.561 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 17:31:40.561 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 17:31:40.562 | info | yii\db\Command::query | INSERT INTO "a57be577deb434"."tbl_sales_supplier_rels" ("contract_id", "supplier_id", "purchase_id") VALUES (4373, 756, 4376) RETURNING "id" |
| 17:31:40.562 | 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\SalesSupplierRels', 4222, 'a:4:{s:2:"id";i:4222;s:11:"contract_id";i:4373;s:11:"supplier_id";s:3:"756";s:11:"purchase_id";i:4376;}', '', 1001, '114.244.130.25') |
| 17:31:40.563 | info | yii\db\Command::query | SELECT "id" FROM "a57be577deb434"."tbl_purchase_contract_invoices" WHERE "contract_id"=4376 |
| 17:31:40.564 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_purchase_client_rels" WHERE "contract_id"=4376 |
| 17:31:40.564 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_purchase_contract_invoices" WHERE 0=1 |
| 17:31:40.565 | info | yii\db\Command::execute | DELETE FROM "a57be577deb434"."tbl_purchase_contract_invoices" WHERE 0=1 |
| 17:31:40.565 | info | yii\db\Command::execute | UPDATE "a57be577deb434"."tbl_purchase_contracts" SET "supplier_id"=756, "contract_type"=1, "signed_at"='2026-07-14', "amount"='332380', "handler"=1011, "updated_at"='now()', "including_tax"=TRUE, "is_draft"=FALSE WHERE "id"=4376 |
| 17:31:40.566 | 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\PurchaseContracts', 4376, 'a:3:{s:9:"signed_at";s:10:"2026-07-14";s:6:"amount";s:6:"332380";s:8:"is_draft";s:1:"0";}', '', 1001, '114.244.130.25') |
| 17:31:40.566 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_suppliers" WHERE "id"='756' |
| 17:31:40.567 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 17:31:40.568 | 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_suppliers' and d.nspname = 'a57be577deb434' ORDER BY a.attnum; |
| 17:31:40.571 | 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_suppliers' and ns.nspname='a57be577deb434' order by fns.nspname, fc.relname, a.attnum |
| 17:31:40.586 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 17:31:40.587 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: SET |
| 17:31:40.588 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_purchase_contract_product_rels" WHERE "purchase_contract_id"=4376 |
| 17:31:40.589 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 17:31:40.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_purchase_contract_product_rels' and d.nspname = 'a57be577deb434' ORDER BY a.attnum; |
| 17:31:40.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_purchase_contract_product_rels' and ns.nspname='a57be577deb434' order by fns.nspname, fc.relname, a.attnum |
| 17:31:40.606 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 17:31:40.606 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: SET |
| 17:31:40.607 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 17:31:40.607 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 17:31:40.607 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_products" WHERE "id"=984 |
| 17:31:40.608 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_products" WHERE "id"='984' |
| 17:31:40.608 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_products" WHERE "id"='2195' |
| 17:31:40.609 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001 |
| 17:31:40.609 | 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, 'purchaseContractProductRels', 4376, 13, 1001, 'now()', '[["PAN-SFP-LX\u7b2c\u4e09\u65b9\u6a21\u5757:\u6570\u91cf 2 \u91d1\u989d 190\u5143","CS5280H3:\u6570\u91cf 1 \u91d1\u989d 332000.00\u5143"]]', '[["PAN-SFP-LX\u7b2c\u4e09\u65b9\u6a21\u5757:\u6570\u91cf 2 \u91d1\u989d 190\u5143"]]', '{"d1":"\u5218\u4eba\u8bda","d2":"\u66f4\u65b0\u4e86","d3":"\u4ea7\u54c1\u660e\u7ec6","d4":["PAN-SFP-LX\u7b2c\u4e09\u65b9\u6a21\u5757:\u6570\u91cf 2 \u91d1\u989d 190\u5143; <b>\u53d8\u4e3a<\/b> PAN-SFP-LX\u7b2c\u4e09\u65b9\u6a21\u5757:\u6570\u91cf 2 \u91d1\u989d 190\u5143;CS5280H3:\u6570\u91cf 1 \u91d1\u989d 332000.00\u5143;"]}') |
| 17:31:40.610 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_purchase_contracts" WHERE "id"=4376 |
| 17:31:40.610 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_purchase_orders" WHERE "purchase_contract_id"=4376 |
| 17:31:40.611 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001 |
| 17:31:40.612 | 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, 'erpPurchaseOrderProducts', 2164, 20001, 1001, 'now()', '[["PAN-SFP-LX\u7b2c\u4e09\u65b9\u6a21\u5757:\u6570\u91cf 2 \u91d1\u989d 190\u5143","CS5280H3:\u6570\u91cf 1 \u91d1\u989d 332000.00\u5143"]]', '[["PAN-SFP-LX\u7b2c\u4e09\u65b9\u6a21\u5757:\u6570\u91cf 2 \u91d1\u989d 190\u5143"]]', '{"d1":"\u5218\u4eba\u8bda","d2":"\u66f4\u65b0\u4e86","d3":"\u4ea7\u54c1\u660e\u7ec6","d4":["PAN-SFP-LX\u7b2c\u4e09\u65b9\u6a21\u5757:\u6570\u91cf 2 \u91d1\u989d 190\u5143; <b>\u53d8\u4e3a<\/b> PAN-SFP-LX\u7b2c\u4e09\u65b9\u6a21\u5757:\u6570\u91cf 2 \u91d1\u989d 190\u5143;CS5280H3:\u6570\u91cf 1 \u91d1\u989d 332000.00\u5143;"]}') |
| 17:31:40.612 | info | yii\db\Command::query | SELECT "id" FROM "a57be577deb434"."tbl_purchase_contract_product_rels" WHERE "purchase_contract_id"=4376 |
| 17:31:40.613 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_purchase_contract_product_rels" WHERE "id"=400 |
| 17:31:40.614 | info | yii\db\Command::execute | UPDATE "a57be577deb434"."tbl_purchase_contract_product_rels" SET "product_id"=984, "amount"='190' WHERE "id"=400 |
| 17:31:40.614 | 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\PurchaseContractProductRels', 400, 'a:0:{}', '', 1001, '114.244.130.25') |
| 17:31:40.615 | info | yii\db\Command::execute | INSERT INTO "a57be577deb434"."tbl_purchase_contract_product_rels" ("purchase_contract_id", "product_id", "amount", "total_amount", "number", "description") VALUES (4376, 2195, '332000', '332000.00', '1', '配置包括2*海光7490(64c, 2.7GHz)/8*32G/1*4TSATA/1*1.92TNVME/8204-2G/4口千兆/4*3000W电源/导轨/409024G涡轮显卡4张。') |
| 17:31:40.617 | info | yii\db\Command::execute | DELETE FROM "a57be577deb434"."tbl_purchase_contract_product_rels" WHERE 0=1 |
| 17:31:40.617 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_purchase_contract_contact_points" WHERE "purchase_contract_id"=4376 |
| 17:31:40.618 | info | yii\db\Command::execute | DELETE FROM "a57be577deb434"."tbl_purchase_contract_contact_points" WHERE "purchase_contract_id"=4376 |
| 17:31:40.618 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_purchase_contract_contact_point_rels" WHERE "purchase_contract_id"=4376 |
| 17:31:40.619 | info | yii\db\Command::query | SELECT "id" FROM "a57be577deb434"."tbl_purchase_contract_contact_point_rels" WHERE "purchase_contract_id"=4376 |
| 17:31:40.619 | info | yii\db\Command::execute | DELETE FROM "a57be577deb434"."tbl_purchase_contract_contact_point_rels" WHERE 0=1 |
| 17:31:40.620 | 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\PurchaseContracts', 4376, 'a:0:{}', '', 1001, '114.244.130.25') |
| 17:31:40.621 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_suppliers" WHERE "id"='756' |
| 17:31:40.621 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_purchase_contracts" WHERE "id"=4376 |
| 17:31:40.622 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_purchase_client_rels" WHERE "contract_id"=4376 ORDER BY "id" |
| 17:31:40.623 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 17:31:40.624 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 17:31:40.624 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"=2553 |
| 17:31:40.628 | info | yii\db\Command::execute | UPDATE "a57be577deb434"."tbl_clients" SET "updated_at"='now()' WHERE "id"=2553 |
| 17:31:40.630 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_client_am_change_logs" WHERE ("client_id"=2553) AND ("sales_rep" IS NULL) AND ("end_at" IS NULL) ORDER BY "id" DESC LIMIT 1 |
| 17:31:40.657 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 17:31:40.657 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 17:31:40.658 | info | yii\db\Command::query | INSERT INTO "a57be577deb434"."tbl_client_am_change_logs" ("client_id", "sales_rep", "start_from", "end_at") VALUES (2553, 1001, 'now()', NULL) RETURNING "id" |
| 17:31:40.659 | 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\ClientAmChangeLogs', 200067, 'a:5:{s:2:"id";i:200067;s:9:"client_id";i:2553;s:9:"sales_rep";i:1001;s:10:"start_from";s:5:"now()";s:6:"end_at";N;}', '', 1001, '114.244.130.25') |
| 17:31:40.660 | 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\Clients', 2553, 'a:0:{}', '', 1001, '114.244.130.25') |
| 17:31:40.660 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001 |
| 17:31:40.661 | 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 (2, 'update', 2553, 10, 4376, 13, 1001, '[4376]', '[4376]', '{"d1":"\u5218\u4eba\u8bda","d2":"\u66f4\u65b0\u4e86","d3":"\u91c7\u8d2d\u5408\u540c","d4":["\u5408\u540c\u7f16\u53f7:TSKJ20260112-HYF-001"]}') RETURNING "id" |
| 17:31:40.661 | 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', 643587, 'a:13:{s:2:"id";i:643587;s:9:"object_id";i:2553;s:11:"object_type";i:10;s:9:"target_id";i:4376;s:18:"target_object_type";i:13;s:3:"act";i:2;s:9:"attribute";s:6:"update";s:9:"old_value";s:6:"[4376]";s:9:"new_value";s:6:"[4376]";s:11:"description";s:140:"{"d1":"\u5218\u4eba\u8bda","d2":"\u66f4\u65b0\u4e86","d3":"\u91c7\u8d2d\u5408\u540c","d4":["\u5408\u540c\u7f16\u53f7:TSKJ20260112-HYF-001"]}";s:10:"created_by";i:1001;s:10:"created_at";N;s:9:"is_delete";N;}', '', 1001, '114.244.130.25') |
| 17:31:40.662 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 17:31:40.663 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 17:31:40.663 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_projects" WHERE "id"=4096 |
| 17:31:40.665 | info | yii\db\Command::execute | UPDATE "a57be577deb434"."tbl_projects" SET "updated_at"='now()' WHERE "id"=4096 |
| 17:31:40.667 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_project_change_logs" WHERE ("project_id"=4096) AND ("end_at" IS NULL) ORDER BY "id" DESC LIMIT 1 |
| 17:31:40.671 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 17:31:40.671 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 17:31:40.671 | 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', 4096, 'a:0:{}', '', 1001, '114.244.130.25') |
| 17:31:40.672 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"=2553 |
| 17:31:40.673 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001 |
| 17:31:40.673 | 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 (2, 'update', 4096, 1, 4376, 13, 1001, '[4376]', '[4376]', '{"d1":"\u5218\u4eba\u8bda","d2":"\u66f4\u65b0\u4e86","d3":"\u91c7\u8d2d\u5408\u540c","d4":["\u5408\u540c\u7f16\u53f7:TSKJ20260112-HYF-001"]}') RETURNING "id" |
| 17:31:40.674 | 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', 643588, 'a:13:{s:2:"id";i:643588;s:9:"object_id";i:4096;s:11:"object_type";i:1;s:9:"target_id";i:4376;s:18:"target_object_type";i:13;s:3:"act";i:2;s:9:"attribute";s:6:"update";s:9:"old_value";s:6:"[4376]";s:9:"new_value";s:6:"[4376]";s:11:"description";s:140:"{"d1":"\u5218\u4eba\u8bda","d2":"\u66f4\u65b0\u4e86","d3":"\u91c7\u8d2d\u5408\u540c","d4":["\u5408\u540c\u7f16\u53f7:TSKJ20260112-HYF-001"]}";s:10:"created_by";i:1001;s:10:"created_at";N;s:9:"is_delete";N;}', '', 1001, '114.244.130.25') |
| 17:31:40.675 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001 |
| 17:31:40.675 | 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 (2, 'update', 756, 12, 4376, 13, 1001, '[4376]', '[4376]', '{"d1":"\u5218\u4eba\u8bda","d2":"\u66f4\u65b0\u4e86","d3":"\u91c7\u8d2d\u5408\u540c","d4":["\u5408\u540c\u7f16\u53f7:TSKJ20260112-HYF-001"]}') RETURNING "id" |
| 17:31:40.676 | 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', 643589, 'a:13:{s:2:"id";i:643589;s:9:"object_id";i:756;s:11:"object_type";i:12;s:9:"target_id";i:4376;s:18:"target_object_type";i:13;s:3:"act";i:2;s:9:"attribute";s:6:"update";s:9:"old_value";s:6:"[4376]";s:9:"new_value";s:6:"[4376]";s:11:"description";s:140:"{"d1":"\u5218\u4eba\u8bda","d2":"\u66f4\u65b0\u4e86","d3":"\u91c7\u8d2d\u5408\u540c","d4":["\u5408\u540c\u7f16\u53f7:TSKJ20260112-HYF-001"]}";s:10:"created_by";i:1001;s:10:"created_at";N;s:9:"is_delete";N;}', '', 1001, '114.244.130.25') |
| 17:31:40.676 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_purchase_orders" WHERE "purchase_contract_id"=4376 |
| 17:31:40.677 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001 |
| 17:31:40.678 | info | yii\db\Command::execute | |
| 17:31:40.678 | 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\ErpPurchaseOrders', 2164, 'a:0:{}', '', 1001, '114.244.130.25') |
| 17:31:40.680 | info | yii\db\Command::execute | DELETE FROM "a57be577deb434"."tbl_erp_purchase_order_projects" WHERE "erp_purchase_order_id"=2164 |
| 17:31:40.683 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 17:31:40.684 | 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_purchase_order_projects' and d.nspname = 'a57be577deb434' ORDER BY a.attnum; |
| 17:31:40.687 | 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_purchase_order_projects' and ns.nspname='a57be577deb434' order by fns.nspname, fc.relname, a.attnum |
| 17:31:40.701 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 17:31:40.701 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: SET |
| 17:31:40.701 | info | yii\db\Command::execute | INSERT INTO "a57be577deb434"."tbl_erp_purchase_order_projects" ("client_id", "project_id", "erp_purchase_order_id") VALUES (2553, 4096, 2164) |
| 17:31:40.705 | info | yii\db\Command::execute | UPDATE "a57be577deb434"."tbl_purchase_contracts" SET "is_edit_verify"=TRUE WHERE "id"=4376 |
| 17:31:40.706 | 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\PurchaseContracts', 4376, 'a:0:{}', '', 1001, '114.244.130.25') |
| 17:31:40.707 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_suppliers" WHERE "id"='756' |
| 17:31:40.707 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_purchase_contract_product_rels" WHERE "purchase_contract_id"=4376 |
| 17:31:40.708 | info | yii\db\Command::execute | UPDATE "a57be577deb434"."tbl_erp_purchase_orders" SET "number"='3', "amount"='332380' WHERE "id"=2164 |
| 17:31:40.708 | 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\ErpPurchaseOrders', 2164, 'a:2:{s:6:"amount";d:332380;s:6:"number";d:3;}', '', 1001, '114.244.130.25') |
| 17:31:40.709 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 17:31:40.709 | 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_purchase_order_verify_rels' and d.nspname = 'a57be577deb434' ORDER BY a.attnum; |
| 17:31:40.713 | 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_purchase_order_verify_rels' and ns.nspname='a57be577deb434' order by fns.nspname, fc.relname, a.attnum |
| 17:31:40.727 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 17:31:40.727 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: SET |
| 17:31:40.727 | info | yii\db\Command::execute | UPDATE "a57be577deb434"."tbl_erp_purchase_order_verify_rels" SET "status"=3 WHERE ("erp_purchase_order_id"=2164) AND ("status"=0) |
| 17:31:40.728 | info | yii\db\Command::execute | DELETE FROM "a57be577deb434"."tbl_erp_purchase_order_stop_verify_rels" WHERE "erp_purchase_order_id"=2164 |
| 17:31:40.730 | info | yii\db\Command::execute | DELETE FROM "a57be577deb434"."tbl_erp_purchase_order_stop_products" WHERE "erp_purchase_order_id"=2164 |
| 17:31:40.730 | info | yii\db\Command::execute | UPDATE "a57be577deb434"."tbl_erp_purchase_orders" SET "stop_at"='now()' WHERE "id"=2164 |
| 17:31:40.731 | 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\ErpPurchaseOrders', 2164, 'a:1:{s:7:"stop_at";s:5:"now()";}', '', 1001, '114.244.130.25') |
| 17:31:40.732 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 17:31:40.732 | 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_purchase_order_stop_products' and d.nspname = 'a57be577deb434' ORDER BY a.attnum; |
| 17:31:40.735 | 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_purchase_order_stop_products' and ns.nspname='a57be577deb434' order by fns.nspname, fc.relname, a.attnum |
| 17:31:40.749 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 17:31:40.749 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: SET |
| 17:31:40.750 | info | yii\db\Command::execute | INSERT INTO "a57be577deb434"."tbl_erp_purchase_order_stop_products" ("erp_purchase_order_id", "erp_purchase_order_product_id", "product_id", "erp_store_id", "amount", "total_amount", "number", "description") VALUES (2164, 337, 984, NULL, '190', '380.00', '2', ''), (2164, NULL, 2195, NULL, '332000', '332000.00', '1', '配置包括2*海光7490(64c, 2.7GHz)/8*32G/1*4TSATA/1*1.92TNVME/8204-2G/4口千兆/4*3000W电源/导轨/409024G涡轮显卡4张。') |
| 17:31:40.752 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 17:31:40.752 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 17:31:40.753 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_verify_processes" WHERE "id"=1 |
| 17:31:40.753 | info | yii\db\Command::execute | |
| 17:31:40.753 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_purchase_order_stop_verify_rels" WHERE ("erp_purchase_order_id"=2164) AND ("status"=0) ORDER BY "id" |
| 17:31:40.754 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1011 |
| 17:31:40.754 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_purchase_order_stop_verify_rels" WHERE ("status"=0) AND ("erp_purchase_order_id"=2164) ORDER BY "id" |
| 17:31:40.756 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_purchase_order_carbon_copy_rels" WHERE "erp_purchase_order_id"=2164 |
| 17:31:40.757 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_purchase_order_verify_rels" WHERE "erp_purchase_order_id"=2164 ORDER BY "id" |
| 17:31:40.758 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 17:31:40.758 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 17:31:40.758 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_purchase_orders" WHERE "id"=2164 |
| 17:31:40.759 | info | yii\db\Command::query | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001) |
| 17:31:40.759 | info | yii\db\Command::query | INSERT INTO "a57be577deb434"."tbl_comments" ("created_by", "object_type", "object_id", "description", "is_system", "description2") VALUES (1001, '20001', 2164, '刘人诚通过了这个审批', TRUE, 'CGDD-20260112-00003') RETURNING "id" |
| 17:31:40.760 | 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', 221112, 'a:11:{s:2:"id";i:221112;s:9:"object_id";i:2164;s:11:"object_type";s:5:"20001";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:"CGDD-20260112-00003";}', '', 1001, '114.244.130.25') |
| 17:31:40.761 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 17:31:40.761 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 17:31:40.761 | info | yii\db\Command::execute | INSERT INTO "a57be577deb434"."tbl_unread_comments" ("object_id", "object_type", "comment_id", "remind_user_id") VALUES (2164, '20001', 221112, 1011) |
| 17:31:40.765 | info | yii\db\Command::query | SELECT "channel_id" FROM "global"."tbl_logins" WHERE ("id"=1011) AND ("id" != 1001) AND (channel_id IS NOT NULL) |
| 17:31:40.765 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_suppliers" WHERE "id"=756 |
| 17:31:40.766 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_purchase_contracts" WHERE "id"=4376 |
| 17:31:40.767 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: INCR |
| 17:31:40.767 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: HSET |
| 17:31:40.767 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: LPUSH |
| 17:31:40.768 | info | yii\db\Command::execute | UPDATE "a57be577deb434"."tbl_erp_purchase_orders" SET "updated_at"='now()' WHERE "id"=2164 |
| 17:31:40.768 | 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\ErpPurchaseOrders', 2164, 'a:0:{}', '', 1001, '114.244.130.25') |
| 17:31:40.769 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_purchase_order_stop_products" WHERE "erp_purchase_order_id"=2164 |
| 17:31:40.769 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 17:31:40.770 | 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_purchase_order_products' and d.nspname = 'a57be577deb434' ORDER BY a.attnum; |
| 17:31:40.773 | 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_purchase_order_products' and ns.nspname='a57be577deb434' order by fns.nspname, fc.relname, a.attnum |
| 17:31:40.787 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 17:31:40.787 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: SET |
| 17:31:40.787 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_purchase_order_products" WHERE "id"=337 |
| 17:31:40.788 | info | yii\db\Command::execute | UPDATE "a57be577deb434"."tbl_erp_purchase_order_products" SET "last_number"='2', "last_amount"='190', "last_total_amount"='380.00' WHERE "id"=337 |
| 17:31:40.789 | 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\ErpPurchaseOrderProducts', 337, 'a:0:{}', '', 1001, '114.244.130.25') |
| 17:31:40.789 | info | yii\db\Command::query | INSERT INTO "a57be577deb434"."tbl_erp_purchase_order_products" ("erp_purchase_order_id", "erp_store_id", "product_id", "number", "amount", "total_amount", "description") VALUES (2164, NULL, 2195, '1', '332000', '332000.00', '配置包括2*海光7490(64c, 2.7GHz)/8*32G/1*4TSATA/1*1.92TNVME/8204-2G/4口千兆/4*3000W电源/导轨/409024G涡轮显卡4张。') RETURNING "id" |
| 17:31:40.791 | 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\ErpPurchaseOrderProducts', 452, 'a:12:{s:2:"id";i:452;s:21:"erp_purchase_order_id";i:2164;s:12:"erp_store_id";N;s:10:"product_id";i:2195;s:11:"description";s:131:"配置包括2*海光7490(64c, 2.7GHz)/8*32G/1*4TSATA/1*1.92TNVME/8204-2G/4口千兆/4*3000W电源/导轨/409024G涡轮显卡4张。";s:6:"number";s:1:"1";s:14:"into_inventory";N;s:6:"amount";s:6:"332000";s:12:"total_amount";s:9:"332000.00";s:11:"last_number";N;s:11:"last_amount";N;s:17:"last_total_amount";N;}', '', 1001, '114.244.130.25') |
| 17:31:40.791 | 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\ErpPurchaseOrders', 2164, 'a:0:{}', '', 1001, '114.244.130.25') |
| 17:31:40.792 | info | yii\db\Command::execute | DELETE FROM "a57be577deb434"."tbl_erp_purchase_order_products" WHERE ("id" NOT IN (337, 452)) AND ("erp_purchase_order_id"=2164) |
| 17:31:40.792 | info | yii\db\Command::execute | DELETE FROM "a57be577deb434"."tbl_erp_purchase_order_stop_products" WHERE "erp_purchase_order_id"=2164 |
| 17:31:40.793 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_purchase_order_products" WHERE "erp_purchase_order_id"=2164 |
| 17:31:40.793 | info | yii\db\Command::execute | DELETE FROM "a57be577deb434"."tbl_purchase_contract_product_rels" WHERE "purchase_contract_id"=4376 |
| 17:31:40.793 | info | yii\db\Command::execute | INSERT INTO "a57be577deb434"."tbl_purchase_contract_product_rels" ("purchase_contract_id", "erp_purchase_order_product_id", "erp_store_id", "product_id", "amount", "total_amount", "number", "description") VALUES (4376, 337, NULL, 984, '190', '380.00', '2', ''), (4376, 452, NULL, 2195, '332000', '332000.00', '1', '配置包括2*海光7490(64c, 2.7GHz)/8*32G/1*4TSATA/1*1.92TNVME/8204-2G/4口千兆/4*3000W电源/导轨/409024G涡轮显卡4张。') |
| 17:31:40.794 | info | yii\db\Command::execute | UPDATE "a57be577deb434"."tbl_purchase_contracts" SET "amount"='332380', "is_edit_verify"=FALSE WHERE "id"=4376 |
| 17:31:40.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\PurchaseContracts', 4376, 'a:0:{}', '', 1001, '114.244.130.25') |
| 17:31:40.795 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_suppliers" WHERE "id"=756 |
| 17:31:40.796 | info | yii\db\Command::query | SELECT SUM(r.amount) FROM "a57be577deb434"."tbl_erp_other_income_ticket_purchase_contract_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_other_income_tickets" "t" ON r.erp_other_income_ticket_id = t.id WHERE ("r"."purchase_contract_id"=4376) AND ("t"."status" IN (2, 5)) |
| 17:31:40.797 | info | yii\db\Command::query | SELECT SUM(r.amount) FROM "a57be577deb434"."tbl_erp_cash_cost_ticket_purchase_contract_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_cash_cost_tickets" "t" ON r.erp_cash_cost_ticket_id = t.id WHERE ("r"."purchase_contract_id"=4376) AND ("t"."status" IN (2, 5)) AND ("is_payment_settle"=TRUE) |
| 17:31:40.799 | 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"."purchase_contract_id"=4376) AND ("t"."status" IN (2, 5)) AND ("t"."is_payment_settle"=TRUE) |
| 17:31:40.800 | 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"."purchase_contract_id"=4376) AND ("t"."status" IN (2, 5)) |
| 17:31:40.801 | info | yii\db\Command::query | SELECT EXISTS(SELECT "r".* FROM "a57be577deb434"."tbl_erp_cash_cost_ticket_purchase_contract_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_cash_cost_tickets" "t" ON r.erp_cash_cost_ticket_id = t.id WHERE ("r"."purchase_contract_id"=4376) AND ("t"."status"=1)) |
| 17:31:40.802 | 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"."purchase_contract_id"=4376) AND ("t"."status"=1)) |
| 17:31:40.802 | 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"."purchase_contract_id"=4376) AND ("t"."status"=1) |
| 17:31:40.803 | info | yii\db\Command::query | SELECT SUM(r.amount) FROM "a57be577deb434"."tbl_erp_other_income_ticket_purchase_contract_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_other_income_tickets" "t" ON r.erp_other_income_ticket_id = t.id WHERE ("r"."purchase_contract_id"=4376) AND ("t"."status" IN (1, 2, 5)) |
| 17:31:40.804 | info | yii\db\Command::query | SELECT SUM(r.amount) FROM "a57be577deb434"."tbl_erp_cash_cost_ticket_purchase_contract_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_cash_cost_tickets" "t" ON r.erp_cash_cost_ticket_id = t.id WHERE ("r"."purchase_contract_id"=4376) AND ("t"."status" IN (1, 2, 5)) |
| 17:31:40.804 | 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"."purchase_contract_id"=4376) AND ("t"."status" IN (1, 2, 5)) |
| 17:31:40.805 | 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"."purchase_contract_id"=4376) AND ("t"."status" IN (1, 2, 5)) |
| 17:31:40.806 | info | yii\db\Command::execute | UPDATE "a57be577deb434"."tbl_purchase_contracts" SET "erp_settle_amount"='1', "erp_un_settle_amount"='332379', "erp_all_settle_amount"='2' WHERE "id"=4376 |
| 17:31:40.807 | 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\PurchaseContracts', 4376, 'a:1:{s:20:"erp_un_settle_amount";d:332379;}', '', 1001, '114.244.130.25') |
| 17:31:40.807 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_suppliers" WHERE "id"=756 |
| 17:31:40.808 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_purchase_costs" WHERE "purchase_contract_id"=4376 |
| 17:31:40.809 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_purchase_contracts" WHERE "id"=4376 |
| 17:31:40.809 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 17:31:40.809 | 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_purchase_contract_payment_collection_remind_dates' and d.nspname = 'a57be577deb434' ORDER BY a.attnum; |
| 17:31:40.813 | 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_purchase_contract_payment_collection_remind_dates' and ns.nspname='a57be577deb434' order by fns.nspname, fc.relname, a.attnum |
| 17:31:40.824 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 17:31:40.825 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: SET |
| 17:31:40.825 | info | yii\db\Command::execute | UPDATE "a57be577deb434"."tbl_purchase_contract_payment_collection_remind_dates" SET "paid_amount"='0', "status"=0, "overdue_days"=NULL WHERE "contract_id"=4376 |
| 17:31:40.826 | info | yii\db\Command::query | SELECT r.amount, t.created_at FROM "a57be577deb434"."tbl_erp_other_income_ticket_purchase_contract_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_other_income_tickets" "t" ON r.erp_other_income_ticket_id = t.id WHERE ("r"."purchase_contract_id"=4376) AND ("t"."status" IN (2, 5, 1)) |
| 17:31:40.826 | info | yii\db\Command::query | SELECT r.amount, t.wrote_date as created_at FROM "a57be577deb434"."tbl_erp_cash_cost_ticket_purchase_contract_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_cash_cost_tickets" "t" ON r.erp_cash_cost_ticket_id = t.id WHERE ("r"."purchase_contract_id"=4376) AND ("t"."status" IN (2, 5, 1)) |
| 17:31:40.827 | info | yii\db\Command::query | SELECT r.amount, t.wrote_date as created_at 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"."purchase_contract_id"=4376) AND ("t"."status" IN (2, 5, 1)) |
| 17:31:40.828 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 17:31:40.828 | 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_payment_ticket_settles' and d.nspname = 'a57be577deb434' ORDER BY a.attnum; |
| 17:31:40.831 | 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_payment_ticket_settles' and ns.nspname='a57be577deb434' order by fns.nspname, fc.relname, a.attnum |
| 17:31:40.844 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 17:31:40.844 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: SET |
| 17:31:40.844 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_purchase_contract_payment_collection_remind_dates" WHERE ("contract_id"=4376) AND (amount > paid_amount) ORDER BY "remind_date" |
| 17:31:40.845 | info | yii\db\Command::execute | UPDATE "a57be577deb434"."tbl_purchase_contract_payment_collection_remind_dates" SET "paid_amount"='1' WHERE "id"=1066 |
| 17:31:40.847 | 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\PurchaseContractPaymentCollectionRemindDates', 1066, 'a:0:{}', '', 1001, '114.244.130.25') |
| 17:31:40.848 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_purchase_contract_payment_collection_remind_dates" WHERE ("contract_id"=4376) AND (amount > paid_amount) ORDER BY "remind_date" |
| 17:31:40.849 | info | yii\db\Command::execute | UPDATE "a57be577deb434"."tbl_purchase_contract_payment_collection_remind_dates" SET "paid_amount"='2' WHERE "id"=1066 |
| 17:31:40.850 | 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\PurchaseContractPaymentCollectionRemindDates', 1066, 'a:1:{s:11:"paid_amount";d:2;}', '', 1001, '114.244.130.25') |
| 17:31:40.850 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_purchase_order_products" WHERE "erp_purchase_order_id"=2164 |
| 17:31:40.852 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_purchase_inbound_products" WHERE "erp_purchase_order_product_id" IN (337, 452) |
| 17:31:40.854 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 17:31:40.854 | 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_purchase_inbound_products' and d.nspname = 'a57be577deb434' ORDER BY a.attnum; |
| 17:31:40.858 | 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_purchase_inbound_products' and ns.nspname='a57be577deb434' order by fns.nspname, fc.relname, a.attnum |
| 17:31:40.872 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 17:31:40.872 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: SET |
| 17:31:40.882 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_purchase_inbounds" WHERE "id"=158 |
| 17:31:40.883 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 17:31:40.883 | 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_purchase_inbounds' and d.nspname = 'a57be577deb434' ORDER BY a.attnum; |
| 17:31:40.887 | 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_purchase_inbounds' and ns.nspname='a57be577deb434' order by fns.nspname, fc.relname, a.attnum |
| 17:31:40.903 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 17:31:40.904 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: SET |
| 17:31:40.904 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_purchase_return_products" WHERE "erp_purchase_inbound_product_id"=325 |
| 17:31:40.905 | info | yii\db\Command::execute | UPDATE "a57be577deb434"."tbl_erp_purchase_order_products" SET "into_inventory"='2' WHERE "id"=337 |
| 17:31:40.905 | 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\ErpPurchaseOrderProducts', 337, 'a:0:{}', '', 1001, '114.244.130.25') |
| 17:31:40.906 | info | yii\db\Command::execute | UPDATE "a57be577deb434"."tbl_erp_purchase_orders" SET "inventory_status"=FALSE WHERE "id"=2164 |
| 17:31:40.907 | 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\ErpPurchaseOrders', 2164, 'a:0:{}', '', 1001, '114.244.130.25') |
| 17:31:40.907 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001 |
| 17:31:40.908 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001 |
| 17:31:40.909 | 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', 2164, 20001, 1001, 'now()', '["\u5218\u4eba\u8bda"]', '[]', '{"d1":"\u5218\u4eba\u8bda","d2":"\u7f16\u8f91\u4e86","d3":"\u91c7\u8d2d\u8ba2\u5355\u7533\u8bf7","d4":""}') |
| 17:31:40.909 | 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\ErpPurchaseOrders', 2164, 'a:0:{}', '', 1001, '114.244.130.25') |
| 17:31:40.910 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_purchase_order_products" WHERE "erp_purchase_order_id"=2164 |
| 17:31:40.910 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_purchase_inbound_products" WHERE "erp_purchase_order_product_id" IN (452, 337) |
| 17:31:40.911 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_purchase_inbounds" WHERE "id"=158 |
| 17:31:40.911 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_purchase_return_products" WHERE "erp_purchase_inbound_product_id"=325 |
| 17:31:40.913 | info | yii\db\Command::execute | UPDATE "a57be577deb434"."tbl_erp_purchase_order_products" SET "into_inventory"='2' WHERE "id"=337 |
| 17:31:40.913 | 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\ErpPurchaseOrderProducts', 337, 'a:0:{}', '', 1001, '114.244.130.25') |
| 17:31:40.914 | 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\ErpPurchaseOrders', 2164, 'a:0:{}', '', 1001, '114.244.130.25') |
| 17:31:40.914 | info | yii\db\Command::query | SELECT SUM(r.amount) FROM "a57be577deb434"."tbl_erp_other_income_ticket_purchase_contract_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_other_income_tickets" "t" ON r.erp_other_income_ticket_id = t.id WHERE ("r"."purchase_contract_id"=4376) AND ("t"."status" IN (2, 5)) |
| 17:31:40.915 | info | yii\db\Command::query | SELECT SUM(r.amount) FROM "a57be577deb434"."tbl_erp_cash_cost_ticket_purchase_contract_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_cash_cost_tickets" "t" ON r.erp_cash_cost_ticket_id = t.id WHERE ("r"."purchase_contract_id"=4376) AND ("t"."status" IN (2, 5)) AND ("is_payment_settle"=TRUE) |
| 17:31:40.915 | 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"."purchase_contract_id"=4376) AND ("t"."status" IN (2, 5)) AND ("t"."is_payment_settle"=TRUE) |
| 17:31:40.916 | 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"."purchase_contract_id"=4376) AND ("t"."status" IN (2, 5)) |
| 17:31:40.917 | info | yii\db\Command::query | SELECT EXISTS(SELECT "r".* FROM "a57be577deb434"."tbl_erp_cash_cost_ticket_purchase_contract_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_cash_cost_tickets" "t" ON r.erp_cash_cost_ticket_id = t.id WHERE ("r"."purchase_contract_id"=4376) AND ("t"."status"=1)) |
| 17:31:40.917 | 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"."purchase_contract_id"=4376) AND ("t"."status"=1)) |
| 17:31:40.918 | 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"."purchase_contract_id"=4376) AND ("t"."status"=1) |
| 17:31:40.919 | info | yii\db\Command::query | SELECT SUM(r.amount) FROM "a57be577deb434"."tbl_erp_other_income_ticket_purchase_contract_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_other_income_tickets" "t" ON r.erp_other_income_ticket_id = t.id WHERE ("r"."purchase_contract_id"=4376) AND ("t"."status" IN (1, 2, 5)) |
| 17:31:40.919 | info | yii\db\Command::query | SELECT SUM(r.amount) FROM "a57be577deb434"."tbl_erp_cash_cost_ticket_purchase_contract_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_cash_cost_tickets" "t" ON r.erp_cash_cost_ticket_id = t.id WHERE ("r"."purchase_contract_id"=4376) AND ("t"."status" IN (1, 2, 5)) |
| 17:31:40.920 | 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"."purchase_contract_id"=4376) AND ("t"."status" IN (1, 2, 5)) |
| 17:31:40.921 | 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"."purchase_contract_id"=4376) AND ("t"."status" IN (1, 2, 5)) |
| 17:31:40.922 | info | yii\db\Command::execute | UPDATE "a57be577deb434"."tbl_purchase_contracts" SET "erp_settle_amount"='1', "erp_un_settle_amount"='332379', "erp_all_settle_amount"='2' WHERE "id"=4376 |
| 17:31:40.922 | 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\PurchaseContracts', 4376, 'a:1:{s:20:"erp_un_settle_amount";d:332379;}', '', 1001, '114.244.130.25') |
| 17:31:40.923 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_suppliers" WHERE "id"=756 |
| 17:31:40.923 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_purchase_costs" WHERE "purchase_contract_id"=4376 |
| 17:31:40.924 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_purchase_contracts" WHERE "id"=4376 |
| 17:31:40.924 | info | yii\db\Command::execute | UPDATE "a57be577deb434"."tbl_purchase_contract_payment_collection_remind_dates" SET "paid_amount"='0', "status"=0, "overdue_days"=NULL WHERE "contract_id"=4376 |
| 17:31:40.925 | info | yii\db\Command::query | SELECT r.amount, t.created_at FROM "a57be577deb434"."tbl_erp_other_income_ticket_purchase_contract_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_other_income_tickets" "t" ON r.erp_other_income_ticket_id = t.id WHERE ("r"."purchase_contract_id"=4376) AND ("t"."status" IN (2, 5, 1)) |
| 17:31:40.925 | info | yii\db\Command::query | SELECT r.amount, t.wrote_date as created_at FROM "a57be577deb434"."tbl_erp_cash_cost_ticket_purchase_contract_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_cash_cost_tickets" "t" ON r.erp_cash_cost_ticket_id = t.id WHERE ("r"."purchase_contract_id"=4376) AND ("t"."status" IN (2, 5, 1)) |
| 17:31:40.926 | info | yii\db\Command::query | SELECT r.amount, t.wrote_date as created_at 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"."purchase_contract_id"=4376) AND ("t"."status" IN (2, 5, 1)) |
| 17:31:40.927 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_purchase_contract_payment_collection_remind_dates" WHERE ("contract_id"=4376) AND (amount > paid_amount) ORDER BY "remind_date" |
| 17:31:40.927 | info | yii\db\Command::execute | UPDATE "a57be577deb434"."tbl_purchase_contract_payment_collection_remind_dates" SET "paid_amount"='1' WHERE "id"=1066 |
| 17:31:40.928 | 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\PurchaseContractPaymentCollectionRemindDates', 1066, 'a:0:{}', '', 1001, '114.244.130.25') |
| 17:31:40.928 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_purchase_contract_payment_collection_remind_dates" WHERE ("contract_id"=4376) AND (amount > paid_amount) ORDER BY "remind_date" |
| 17:31:40.929 | info | yii\db\Command::execute | UPDATE "a57be577deb434"."tbl_purchase_contract_payment_collection_remind_dates" SET "paid_amount"='2' WHERE "id"=1066 |
| 17:31:40.930 | 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\PurchaseContractPaymentCollectionRemindDates', 1066, 'a:1:{s:11:"paid_amount";d:2;}', '', 1001, '114.244.130.25') |
| 17:31:40.930 | trace | yii\db\Transaction::commit | Commit transaction |
| 17:31:40.931 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 17:31:40.932 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 17:31:40.932 | 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/purchase-contract/save-edit', '{"PurchaseContracts":{"id":"4376","supplier_id":"756","is_draft":"0","amount":"332380","handler":"1011","contract_type":"1","serial_no":"TSKJ20260112-HYF-001","signed_at":"2026-07-14","description":"","including_tax":"1","contractScans":["32848","32849"],"product_number":"3","product_amount":"332380","purchaseContractProductRels":{"400":{"product_id":"984","number":"2","amount":"190","total_amount":"380.00","erp_store_id":"","description":""},"new":{"1":{"product_id":"2195","number":"1","amount":"332000.00","total_amount":"332000.00","erp_store_id":"","description":"\u914d\u7f6e\u5305\u62ec2*\u6d77\u51497490(64c, 2.7GHz)\/8*32G\/1*4TSATA\/1*1.92TNVME\/8204-2G\/4\u53e3\u5343\u5146\/4*3000W\u7535\u6e90\/\u5bfc\u8f68\/409024G\u6da1\u8f6e\u663e\u53614\u5f20\u3002"}}},"receiptScans":"","purchaseClientRels":[{"client_id":"2553","project_id":"4096"}],"PurchaseContractInvoices":"","purchaseContractContactPoints":"","purchaseContractContactPointRels":""}}', '{"code":2000,"result":"","status":1,"msg":[{"name":"success","success":"\u91c7\u8d2d\u5408\u540c\u5df2\u88ab\u6210\u529f\u4fee\u6539","error":""}],"mod":0,"ip":"114.244.130.25","ua":"Mozilla\/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit\/537.36 (KHTML, like Gecko) Chrome\/150.0.0.0 Safari\/537.36"}', FALSE, '2026-07-16 17:31:40', 438988032) RETURNING "id" |
| 17:31:40.934 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 17:31:40.934 | trace | yii\db\Transaction::begin | Begin transaction |
| 17:31:40.934 | info | yii\db\Command::query | SELECT * FROM "global"."tbl_browser_ua_statistics" "b" WHERE "user_agent"='Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/150.0.0.0 Safari/537.36' |
| 17:31:40.935 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 17:31:40.935 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 17:31:40.935 | info | yii\db\Command::execute | UPDATE "global"."tbl_browser_ua_statistics" SET "counter"=2500 WHERE "id"=305 |
| 17:31:40.936 | trace | yii\db\Transaction::commit | Commit transaction |
| 17:31:40.936 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: SET |