| 16:05:03.920 | trace | yii\base\Application::bootstrap | Bootstrap with yii\log\Dispatcher |
| 16:05:03.920 | trace | yii\base\Module::getModule | Loading module: debug |
| 16:05:03.921 | trace | yii\base\Application::bootstrap | Bootstrap with yii\debug\Module::bootstrap() |
| 16:05:03.921 | trace | yii\redis\Connection::open | Opening redis DB connection: redis.server.local:6379, database=1 |
| 16:05:03.921 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: SELECT |
| 16:05:03.922 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 16:05:03.922 | info | time tracing start | 1783411503922519040 |
| 16:05:03.922 | trace | yii\web\UrlManager::parseRequest | No matching URL rules. Using default URL parsing logic. |
| 16:05:03.922 | trace | yii\web\Application::handleRequest | Route requested: 'vue/erp-payment-ticket/save-settle' |
| 16:05:03.922 | trace | yii\base\Module::getModule | Loading module: vue |
| 16:05:03.923 | info | yii\web\Session::open | Session started |
| 16:05:03.925 | info | yii\db\Command::query | SELECT * FROM "global"."vw_user_login" WHERE "id"=1001 |
| 16:05:03.925 | info | yii\db\Connection::open | Opening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta |
| 16:05:03.926 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 16:05:03.927 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 16:05:03.927 | info | yii\db\Command::query | SELECT * FROM "global"."vw_user_login" WHERE "id"=1001 |
| 16:05:03.929 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 16:05:03.929 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 16:05:03.929 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001 |
| 16:05:03.930 | trace | yii\base\Controller::runAction | Route to run: vue/erp-payment-ticket/save-settle |
| 16:05:03.931 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 16:05:03.932 | trace | uranus\rbac\DbManager::checkAccessFromCache | Checking role: Admin |
| 16:05:03.933 | trace | yii\base\InlineAction::runWithParams | Running action: app\modules\vue\controllers\ErpPaymentTicketController::actionSaveSettle() |
| 16:05:03.933 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_payment_tickets" WHERE "id"='2364' |
| 16:05:03.934 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 16:05:03.934 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 16:05:03.934 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 16:05:03.935 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 16:05:03.937 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 16:05:03.937 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 16:05:03.937 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_banks" WHERE "id"=1 |
| 16:05:03.938 | trace | yii\db\Transaction::begin | Begin transaction |
| 16:05:03.938 | info | yii\db\Command::execute | UPDATE "a57be577deb434"."tbl_erp_payment_tickets" SET "is_payment_settle"=TRUE WHERE "id"=2364 |
| 16:05:03.939 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 16:05:03.939 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 16:05:03.939 | 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\ErpPaymentTickets', 2364, 'a:1:{s:17:"is_payment_settle";b:1;}', '', 1001, '39.156.194.178') |
| 16:05:03.941 | info | yii\db\Command::execute | UPDATE "a57be577deb434"."tbl_erp_payment_tickets" SET "bank_settle_at"='now()' WHERE "id"=2364 |
| 16:05:03.942 | 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\ErpPaymentTickets', 2364, 'a:1:{s:14:"bank_settle_at";s:5:"now()";}', '', 1001, '39.156.194.178') |
| 16:05:03.942 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_payment_ticket_bank_outs" WHERE "erp_payment_ticket_id"=2364 |
| 16:05:03.943 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 16:05:03.943 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 16:05:03.943 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_banks" WHERE "id"=1 |
| 16:05:03.944 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_payment_ticket_payments" WHERE ("erp_payment_ticket_id"=2364) AND (erp_advance_payment_ticket_id is not null) |
| 16:05:03.944 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_payment_ticket_payments" WHERE ("erp_payment_ticket_id"=2364) AND (erp_other_collect_ticket_id is not null) |
| 16:05:03.945 | info | yii\db\Command::execute | DELETE FROM "a57be577deb434"."tbl_erp_payment_ticket_bank_outs" WHERE "erp_payment_ticket_id"=2364 |
| 16:05:03.945 | info | yii\db\Command::execute | INSERT INTO "a57be577deb434"."tbl_erp_payment_ticket_bank_outs" ("erp_payment_ticket_id", "erp_bank_id", "amount", "description", "settle_at", "settle_by") VALUES (2364, 1, '0', '', 'now()', 1001) |
| 16:05:03.946 | info | yii\db\Command::execute | DELETE FROM "a57be577deb434"."tbl_erp_payment_ticket_payments" WHERE "erp_payment_ticket_id"=2364 |
| 16:05:03.946 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=20020) AND ("object_id"=2364) |
| 16:05:03.950 | info | yii\db\Command::execute | DELETE FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=20020) AND ("object_id"=2364) |
| 16:05:03.956 | info | yii\db\Command::query | SELECT * FROM ((SELECT * FROM (SELECT
(r.id::varchar || 20013::varchar) as id,
r.id as id2,
r.supplier_id as supplier_id,
r.client_id as client_id,
r.user_id as user_id,
r.contact_id as contact_id,
null::integer as project_id,
r.wrote_date,
r.serial_no,
20013 as ticket_type,
r.abstract,
r.description,
r.created_by,
r.amount,
r.status,
r.settle_amount,
false as is_payment_settle,
r.created_at,
t.erp_bank_id,
t.amount as in_amount,
null::numeric as out_amount,
bank_settle_at,
t.settle_at
FROM "a57be577deb434"."tbl_erp_collect_tickets" "r" LEFT JOIN "a57be577deb434"."tbl_erp_collect_ticket_bank_ins" "t" ON t.erp_collect_ticket_id = r.id WHERE ("r"."status" IN (2, 6)) AND (t.id is not null)) "sub") UNION ALL ( SELECT
(r.id::varchar || 20012::varchar) as id,
r.id as id2,
r.supplier_id as supplier_id,
r.client_id as client_id,
r.user_id as user_id,
r.contact_id as contact_id,
null::integer as project_id,
r.wrote_date,
r.serial_no,
20012 as ticket_type,
r.abstract,
r.description,
r.created_by,
r.amount,
r.status,
r.settle_amount,
r.is_payment_settle,
r.created_at,
t.erp_bank_id,
null::numeric as in_amount,
t.amount as out_amount,
bank_settle_at,
t.settle_at
FROM "a57be577deb434"."tbl_erp_payment_tickets" "r" LEFT JOIN "a57be577deb434"."tbl_erp_payment_ticket_bank_outs" "t" ON t.erp_payment_ticket_id = r.id WHERE ("r"."status" IN (2, 6)) AND ("r"."is_payment_settle"=TRUE) AND (t.id is not null) ) UNION ALL ( SELECT
(r.id::varchar || 20015::varchar) as id,
r.id as id2,
r.supplier_id as supplier_id,
r.client_id as client_id,
r.user_id as user_id,
r.contact_id as contact_id,
null::integer as project_id,
r.wrote_date,
r.serial_no,
20015 as ticket_type,
r.abstract,
r.description,
r.created_by,
r.amount,
r.status,
r.settle_amount,
false as is_payment_settle,
r.created_at,
t.erp_bank_id,
t.amount as in_amount,
null::numeric as out_amount,
bank_settle_at,
t.settle_at
FROM "a57be577deb434"."tbl_erp_other_income_tickets" "r" LEFT JOIN "a57be577deb434"."tbl_erp_other_income_ticket_bank_ins" "t" ON t.erp_other_income_ticket_id = r.id WHERE ("r"."status" IN (2, 6)) AND (t.id is not null) ) UNION ALL ( SELECT
(r.id::varchar || 20017::varchar || 1::varchar) as id,
r.id as id2,
null::integer as supplier_id,
null::integer as client_id,
null::integer as user_id,
null::integer as contact_id,
null::integer as project_id,
r.wrote_date,
r.serial_no,
20017 as ticket_type,
r.abstract,
r.description,
r.created_by,
r.amount,
r.status,
null::numeric as settle_amount,
false as is_payment_settle,
r.created_at,
t.erp_bank_id,
t.amount as in_amount,
null::numeric as out_amount,
bank_settle_at,
t.settle_at
FROM "a57be577deb434"."tbl_erp_bank_transfer_tickets" "r" LEFT JOIN "a57be577deb434"."tbl_erp_bank_transfer_ticket_bank_ins" "t" ON t.erp_bank_transfer_ticket_id = r.id WHERE ("r"."status" IN (2, 6)) AND (t.id is not null) ) UNION ALL ( SELECT
(r.id::varchar || 20017::varchar || 2::varchar) as id,
r.id as id2,
null::integer as supplier_id,
null::integer as client_id,
null::integer as user_id,
null::integer as contact_id,
null::integer as project_id,
r.wrote_date,
r.serial_no,
20017 as ticket_type,
r.abstract,
r.description,
r.created_by,
r.amount,
r.status,
null::numeric as settle_amount,
false as is_payment_settle,
r.created_at,
t.erp_bank_id,
null::numeric as in_amount,
t.amount as out_amount,
bank_settle_at,
t.settle_at
FROM "a57be577deb434"."tbl_erp_bank_transfer_tickets" "r" LEFT JOIN "a57be577deb434"."tbl_erp_bank_transfer_ticket_bank_outs" "t" ON t.erp_bank_transfer_ticket_id = r.id WHERE ("r"."status" IN (2, 6)) AND (t.id is not null) ) UNION ALL ( SELECT
(r.id::varchar || 20018::varchar) as id,
r.id as id2,
r.supplier_id as supplier_id,
r.client_id as client_id,
null::integer as user_id,
null::integer as contact_id,
null::integer as project_id,
r.wrote_date,
r.serial_no,
20018 as ticket_type,
r.abstract,
r.description,
r.created_by,
r.amount,
r.status,
r.settle_amount,
r.is_payment_settle,
r.created_at,
t.erp_bank_id,
null::numeric as in_amount,
t.amount as out_amount,
bank_settle_at,
t.settle_at
FROM "a57be577deb434"."tbl_erp_cash_cost_tickets" "r" LEFT JOIN "a57be577deb434"."tbl_erp_cash_cost_ticket_bank_outs" "t" ON t.erp_cash_cost_ticket_id = r.id WHERE ("r"."status" IN (2, 6)) AND ("r"."is_payment_settle"=TRUE) AND (t.id is not null) ) UNION ALL ( SELECT
(r.id::varchar || 20019::varchar) as id,
r.id as id2,
r.supplier_id as supplier_id,
r.client_id as client_id,
null::integer as user_id,
null::integer as contact_id,
null::integer as project_id,
r.wrote_date,
r.serial_no,
20019 as ticket_type,
r.abstract,
r.description,
r.created_by,
r.amount,
r.status,
r.settle_amount,
r.is_payment_settle,
r.created_at,
t.erp_bank_id,
null::numeric as in_amount,
t.amount as out_amount,
bank_settle_at,
t.settle_at
FROM "a57be577deb434"."tbl_erp_advance_payment_tickets" "r" LEFT JOIN "a57be577deb434"."tbl_erp_advance_payment_ticket_bank_outs" "t" ON t.erp_advance_payment_ticket_id = r.id WHERE ("r"."status" IN (2, 6)) AND ("r"."is_payment_settle"=TRUE) AND (t.id is not null) ) UNION ALL ( SELECT
(r.id::varchar || 20020::varchar) as id,
r.id as id2,
r.supplier_id as supplier_id,
r.client_id as client_id,
r.user_id as user_id,
r.contact_id as contact_id,
null::integer as project_id,
r.wrote_date,
r.serial_no,
20020 as ticket_type,
r.abstract,
r.description,
r.created_by,
r.amount,
r.status,
r.settle_amount,
false as is_payment_settle,
r.created_at,
t.erp_bank_id,
t.amount as in_amount,
null::numeric as out_amount,
bank_settle_at,
t.settle_at
FROM "a57be577deb434"."tbl_erp_other_payment_tickets" "r" LEFT JOIN "a57be577deb434"."tbl_erp_other_payment_ticket_bank_ins" "t" ON t.erp_other_payment_ticket_id = r.id WHERE ("r"."status" IN (2, 6)) AND (t.id is not null) ) UNION ALL ( SELECT
(r.id::varchar || 20021::varchar) as id,
r.id as id2,
r.supplier_id as supplier_id,
r.client_id as client_id,
r.user_id as user_id,
r.contact_id as contact_id,
null::integer as project_id,
r.wrote_date,
r.serial_no,
20021 as ticket_type,
r.abstract,
r.description,
r.created_by,
r.amount,
r.status,
r.settle_amount,
false as is_payment_settle,
r.created_at,
t.erp_bank_id,
null::numeric as in_amount,
t.amount as out_amount,
bank_settle_at,
t.settle_at
FROM "a57be577deb434"."tbl_erp_other_collect_tickets" "r" LEFT JOIN "a57be577deb434"."tbl_erp_other_collect_ticket_bank_outs" "t" ON t.erp_other_collect_ticket_id = r.id WHERE ("r"."status" IN (2, 6)) AND (r.bank_settle_at IS NOT NULL) AND (t.id is not null) ) UNION ALL ( SELECT
(r.id::varchar || 20023::varchar) as id,
r.id as id2,
null::integer as supplier_id,
null::integer as client_id,
null::integer as user_id,
null::integer as contact_id,
null::integer as project_id,
r.wrote_date,
r.serial_no,
20023 as ticket_type,
r.abstract,
r.description,
r.created_by,
r.amount,
r.status,
r.settle_amount,
r.is_payment_settle,
r.created_at,
t.erp_bank_id,
null::numeric as in_amount,
t.amount as out_amount,
bank_settle_at,
t.settle_at
FROM "a57be577deb434"."tbl_erp_wage_tickets" "r" LEFT JOIN "a57be577deb434"."tbl_erp_wage_ticket_bank_outs" "t" ON t.erp_wage_ticket_id = r.id WHERE ("r"."status" IN (2, 6)) AND (t.id is not null) ) UNION ALL ( SELECT
(r.id::varchar || 20024::varchar) as id,
r.id as id2,
null::integer as supplier_id,
null::integer as client_id,
null::integer as user_id,
null::integer as contact_id,
null::integer as project_id,
r.wrote_date,
r.serial_no,
20024 as ticket_type,
r.abstract,
r.description,
r.created_by,
r.amount,
r.status,
r.settle_amount,
r.is_payment_settle,
r.created_at,
t.erp_bank_id,
null::numeric as in_amount,
t.amount as out_amount,
bank_settle_at,
t.settle_at
FROM "a57be577deb434"."tbl_erp_social_insurances" "r" LEFT JOIN "a57be577deb434"."tbl_erp_social_insurance_bank_outs" "t" ON t.erp_social_insurance_id = r.id WHERE ("r"."status" IN (2, 6)) AND ("r"."is_payment_settle"=TRUE) AND (t.id is not null) ) UNION ALL ( SELECT
(r.id::varchar || 20025::varchar) as id,
r.id as id2,
null::integer as supplier_id,
null::integer as client_id,
null::integer as user_id,
null::integer as contact_id,
null::integer as project_id,
r.wrote_date,
r.serial_no,
20025 as ticket_type,
r.abstract,
r.description,
r.created_by,
r.amount,
r.status,
r.settle_amount,
r.is_payment_settle,
r.created_at,
t.erp_bank_id,
null::numeric as in_amount,
t.amount as out_amount,
bank_settle_at,
t.settle_at
FROM "a57be577deb434"."tbl_erp_provident_funds" "r" LEFT JOIN "a57be577deb434"."tbl_erp_provident_fund_bank_outs" "t" ON t.erp_provident_fund_id = r.id WHERE ("r"."status" IN (2, 6)) AND ("r"."is_payment_settle"=TRUE) AND (t.id is not null) ) UNION ALL ( SELECT
(r.id::varchar || 20026::varchar) as id,
r.id as id2,
null::integer as supplier_id,
null::integer as client_id,
null::integer as user_id,
null::integer as contact_id,
null::integer as project_id,
r.wrote_date,
r.serial_no,
20026 as ticket_type,
r.abstract,
r.description,
r.created_by,
r.amount,
r.status,
r.settle_amount,
r.is_payment_settle,
r.created_at,
t.erp_bank_id,
null::numeric as in_amount,
t.amount as out_amount,
bank_settle_at,
t.settle_at
FROM "a57be577deb434"."tbl_erp_personal_taxs" "r" LEFT JOIN "a57be577deb434"."tbl_erp_personal_tax_bank_outs" "t" ON t.erp_personal_tax_id = r.id WHERE ("r"."status" IN (2, 6)) AND ("r"."is_payment_settle"=TRUE) AND (t.id is not null) ) UNION ALL ( SELECT
(r.id::varchar || 20027::varchar) as id,
r.id as id2,
null::integer as supplier_id,
null::integer as client_id,
null::integer as user_id,
null::integer as contact_id,
null::integer as project_id,
r.wrote_date,
r.serial_no,
20027 as ticket_type,
r.abstract,
r.description,
r.created_by,
r.amount,
r.status,
r.settle_amount,
r.is_payment_settle,
r.created_at,
t.erp_bank_id,
null::numeric as in_amount,
t.amount as out_amount,
bank_settle_at,
t.settle_at
FROM "a57be577deb434"."tbl_erp_wage_prizes" "r" LEFT JOIN "a57be577deb434"."tbl_erp_wage_prize_bank_outs" "t" ON t.erp_wage_prize_id = r.id WHERE ("r"."status" IN (2, 6)) AND ("r"."is_payment_settle"=TRUE) AND (t.id is not null) )) "sub" WHERE ("sub"."id2"=2364) AND ("sub"."ticket_type"=20012) ORDER BY "settle_at" |
| 16:05:03.968 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_banks" |
| 16:05:03.969 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_payment_tickets" WHERE "id"=2364 |
| 16:05:03.970 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 16:05:03.970 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 16:05:03.971 | info | yii\db\Command::query | INSERT INTO "a57be577deb434"."tbl_erp_bank_amount_change_logs" ("status", "ticket_type", "serial_no", "wrote_date", "description", "abstract", "amount", "client_id", "supplier_id", "contact_id", "user_id", "created_by", "created_at", "updated_at", "object_id", "verify_at", "settle_at", "in_amount", "out_amount", "erp_bank_id", "balance_amount") VALUES (2, 20012, 'FKD-20260707-00003', '2026-07-07', NULL, NULL, '0', NULL, 431, NULL, NULL, 1001, '2026-07-07 16:04:11', '2026-07-07 16:04:11', 2364, '2026-07-07 16:04:11.641061+08', '2026-07-07 16:05:03.938212+08', NULL, '0', 1, '1476232.71') RETURNING "id" |
| 16:05:03.972 | 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\ErpBankAmountChangeLogs', 1761, 'a:22:{s:2:"id";i:1761;s:9:"object_id";i:2364;s:11:"ticket_type";i:20012;s:9:"serial_no";s:18:"FKD-20260707-00003";s:11:"erp_bank_id";i:1;s:10:"wrote_date";s:10:"2026-07-07";s:6:"status";i:2;s:6:"amount";s:1:"0";s:9:"in_amount";N;s:10:"out_amount";s:1:"0";s:14:"balance_amount";d:1476232.71;s:11:"supplier_id";i:431;s:9:"client_id";N;s:10:"contact_id";N;s:7:"user_id";N;s:8:"abstract";N;s:11:"description";N;s:9:"settle_at";s:29:"2026-07-07 16:05:03.938212+08";s:9:"verify_at";s:29:"2026-07-07 16:04:11.641061+08";s:10:"created_by";i:1001;s:10:"created_at";s:19:"2026-07-07 16:04:11";s:10:"updated_at";s:19:"2026-07-07 16:04:11";}', '', 1001, '39.156.194.178') |
| 16:05:03.973 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 16:05:03.973 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 16:05:03.973 | info | yii\db\Command::execute | INSERT INTO "a57be577deb434"."tbl_erp_bank_amount_change_log_handlers" ("erp_bank_amount_change_log_id", "user_id") VALUES (1761, 1001) |
| 16:05:03.975 | info | yii\db\Command::query | SELECT SUM(r.amount) FROM "a57be577deb434"."tbl_erp_other_income_ticket_bank_ins" "r" LEFT JOIN "a57be577deb434"."tbl_erp_other_income_tickets" "t" ON r.erp_other_income_ticket_id = t.id WHERE ("r"."erp_bank_id"=1) AND ("t"."status" IN (2, 5)) |
| 16:05:03.976 | info | yii\db\Command::query | SELECT SUM(r.amount) FROM "a57be577deb434"."tbl_erp_bank_transfer_ticket_bank_ins" "r" LEFT JOIN "a57be577deb434"."tbl_erp_bank_transfer_tickets" "t" ON r.erp_bank_transfer_ticket_id = t.id WHERE ("r"."erp_bank_id"=1) AND ("t"."status" IN (2, 5)) |
| 16:05:03.976 | info | yii\db\Command::query | SELECT SUM(r.amount) FROM "a57be577deb434"."tbl_erp_bank_transfer_ticket_bank_outs" "r" LEFT JOIN "a57be577deb434"."tbl_erp_bank_transfer_tickets" "t" ON r.erp_bank_transfer_ticket_id = t.id WHERE ("r"."erp_bank_id"=1) AND ("t"."status" IN (2, 5)) |
| 16:05:03.977 | info | yii\db\Command::query | SELECT SUM(r.amount) FROM "a57be577deb434"."tbl_erp_cash_cost_ticket_bank_outs" "r" LEFT JOIN "a57be577deb434"."tbl_erp_cash_cost_tickets" "t" ON r.erp_cash_cost_ticket_id = t.id WHERE ("r"."erp_bank_id"=1) AND ("t"."status" IN (2, 5)) AND ("t"."is_payment_settle"=TRUE) |
| 16:05:03.983 | info | yii\db\Command::query | SELECT SUM(r.amount) FROM "a57be577deb434"."tbl_erp_advance_payment_ticket_bank_outs" "r" LEFT JOIN "a57be577deb434"."tbl_erp_advance_payment_tickets" "t" ON r.erp_advance_payment_ticket_id = t.id WHERE ("r"."erp_bank_id"=1) AND ("t"."status" IN (2, 5)) AND ("t"."is_payment_settle"=TRUE) |
| 16:05:03.984 | info | yii\db\Command::query | SELECT SUM(r.amount) FROM "a57be577deb434"."tbl_erp_other_payment_ticket_bank_ins" "r" LEFT JOIN "a57be577deb434"."tbl_erp_other_payment_tickets" "t" ON r.erp_other_payment_ticket_id = t.id WHERE ("r"."erp_bank_id"=1) AND ("t"."status" IN (2, 5)) |
| 16:05:03.985 | info | yii\db\Command::query | SELECT SUM(r.amount) FROM "a57be577deb434"."tbl_erp_other_collect_ticket_bank_outs" "r" LEFT JOIN "a57be577deb434"."tbl_erp_other_collect_tickets" "t" ON r.erp_other_collect_ticket_id = t.id WHERE ("r"."erp_bank_id"=1) AND ("t"."status" IN (2, 5)) AND (t.bank_settle_at IS NOT NULL) |
| 16:05:03.985 | info | yii\db\Command::query | SELECT SUM(r.amount) FROM "a57be577deb434"."tbl_erp_payment_ticket_bank_outs" "r" LEFT JOIN "a57be577deb434"."tbl_erp_payment_tickets" "t" ON r.erp_payment_ticket_id = t.id WHERE ("r"."erp_bank_id"=1) AND ("t"."status" IN (2, 5)) AND ("t"."is_payment_settle"=TRUE) |
| 16:05:03.987 | info | yii\db\Command::query | SELECT SUM(r.amount) FROM "a57be577deb434"."tbl_erp_collect_ticket_bank_ins" "r" LEFT JOIN "a57be577deb434"."tbl_erp_collect_tickets" "t" ON r.erp_collect_ticket_id = t.id WHERE ("r"."erp_bank_id"=1) AND ("t"."status" IN (2, 5)) |
| 16:05:03.988 | info | yii\db\Command::query | SELECT SUM(r.amount) FROM "a57be577deb434"."tbl_erp_social_insurance_bank_outs" "r" LEFT JOIN "a57be577deb434"."tbl_erp_social_insurances" "t" ON r.erp_social_insurance_id = t.id WHERE ("r"."erp_bank_id"=1) AND ("t"."status" IN (2, 5)) AND ("t"."is_payment_settle"=TRUE) |
| 16:05:03.989 | info | yii\db\Command::query | SELECT SUM(r.amount) FROM "a57be577deb434"."tbl_erp_provident_fund_bank_outs" "r" LEFT JOIN "a57be577deb434"."tbl_erp_provident_funds" "t" ON r.erp_provident_fund_id = t.id WHERE ("r"."erp_bank_id"=1) AND ("t"."status" IN (2, 5)) AND ("t"."is_payment_settle"=TRUE) |
| 16:05:03.990 | info | yii\db\Command::query | SELECT SUM(r.amount) FROM "a57be577deb434"."tbl_erp_personal_tax_bank_outs" "r" LEFT JOIN "a57be577deb434"."tbl_erp_personal_taxs" "t" ON r.erp_personal_tax_id = t.id WHERE ("r"."erp_bank_id"=1) AND ("t"."status" IN (2, 5)) AND ("t"."is_payment_settle"=TRUE) |
| 16:05:03.990 | info | yii\db\Command::query | SELECT SUM(r.amount) FROM "a57be577deb434"."tbl_erp_wage_prize_bank_outs" "r" LEFT JOIN "a57be577deb434"."tbl_erp_wage_prizes" "t" ON r.erp_wage_prize_id = t.id WHERE ("r"."erp_bank_id"=1) AND ("t"."status" IN (2, 5)) AND ("t"."is_payment_settle"=TRUE) |
| 16:05:03.991 | info | yii\db\Command::query | SELECT SUM(r.amount) FROM "a57be577deb434"."tbl_erp_wage_ticket_bank_outs" "r" LEFT JOIN "a57be577deb434"."tbl_erp_wage_tickets" "t" ON r.erp_wage_ticket_id = t.id WHERE ("r"."erp_bank_id"=1) AND ("t"."status" IN (2, 5)) |
| 16:05:03.992 | info | yii\db\Command::execute | UPDATE "a57be577deb434"."tbl_erp_banks" SET "balance_amount"='1476232.71' WHERE "id"=1 |
| 16:05:03.993 | 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\ErpBanks', 1, 'a:0:{}', '', 1001, '39.156.194.178') |
| 16:05:03.993 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_banks" WHERE "id"=1 |
| 16:05:03.994 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_account_captions" WHERE "id"=71 |
| 16:05:03.995 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 16:05:03.995 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 16:05:03.996 | info | yii\db\Command::execute | UPDATE "a57be577deb434"."tbl_erp_account_captions" SET "created_at"='2025-08-01 23:14:45', "updated_at"='2025-08-08 18:50:15' WHERE "id"=71 |
| 16:05:03.996 | 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\ErpAccountCaptions', 71, 'a:0:{}', '', 1001, '39.156.194.178') |
| 16:05:03.997 | 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\ErpBanks', 1, 'a:0:{}', '', 1001, '39.156.194.178') |
| 16:05:03.998 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_payment_ticket_bank_outs" WHERE "erp_payment_ticket_id"=2364 ORDER BY "id" |
| 16:05:03.998 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_banks" WHERE "id"=1 |
| 16:05:03.999 | info | yii\db\Command::query | SELECT SUM(r.amount) FROM "a57be577deb434"."tbl_erp_other_income_ticket_bank_ins" "r" LEFT JOIN "a57be577deb434"."tbl_erp_other_income_tickets" "t" ON r.erp_other_income_ticket_id = t.id WHERE ("r"."erp_bank_id"=1) AND ("t"."status" IN (2, 5)) |
| 16:05:03.999 | info | yii\db\Command::query | SELECT SUM(r.amount) FROM "a57be577deb434"."tbl_erp_bank_transfer_ticket_bank_ins" "r" LEFT JOIN "a57be577deb434"."tbl_erp_bank_transfer_tickets" "t" ON r.erp_bank_transfer_ticket_id = t.id WHERE ("r"."erp_bank_id"=1) AND ("t"."status" IN (2, 5)) |
| 16:05:04.000 | info | yii\db\Command::query | SELECT SUM(r.amount) FROM "a57be577deb434"."tbl_erp_bank_transfer_ticket_bank_outs" "r" LEFT JOIN "a57be577deb434"."tbl_erp_bank_transfer_tickets" "t" ON r.erp_bank_transfer_ticket_id = t.id WHERE ("r"."erp_bank_id"=1) AND ("t"."status" IN (2, 5)) |
| 16:05:04.001 | info | yii\db\Command::query | SELECT SUM(r.amount) FROM "a57be577deb434"."tbl_erp_cash_cost_ticket_bank_outs" "r" LEFT JOIN "a57be577deb434"."tbl_erp_cash_cost_tickets" "t" ON r.erp_cash_cost_ticket_id = t.id WHERE ("r"."erp_bank_id"=1) AND ("t"."status" IN (2, 5)) AND ("t"."is_payment_settle"=TRUE) |
| 16:05:04.006 | info | yii\db\Command::query | SELECT SUM(r.amount) FROM "a57be577deb434"."tbl_erp_advance_payment_ticket_bank_outs" "r" LEFT JOIN "a57be577deb434"."tbl_erp_advance_payment_tickets" "t" ON r.erp_advance_payment_ticket_id = t.id WHERE ("r"."erp_bank_id"=1) AND ("t"."status" IN (2, 5)) AND ("t"."is_payment_settle"=TRUE) |
| 16:05:04.006 | info | yii\db\Command::query | SELECT SUM(r.amount) FROM "a57be577deb434"."tbl_erp_other_payment_ticket_bank_ins" "r" LEFT JOIN "a57be577deb434"."tbl_erp_other_payment_tickets" "t" ON r.erp_other_payment_ticket_id = t.id WHERE ("r"."erp_bank_id"=1) AND ("t"."status" IN (2, 5)) |
| 16:05:04.007 | info | yii\db\Command::query | SELECT SUM(r.amount) FROM "a57be577deb434"."tbl_erp_other_collect_ticket_bank_outs" "r" LEFT JOIN "a57be577deb434"."tbl_erp_other_collect_tickets" "t" ON r.erp_other_collect_ticket_id = t.id WHERE ("r"."erp_bank_id"=1) AND ("t"."status" IN (2, 5)) AND (t.bank_settle_at IS NOT NULL) |
| 16:05:04.008 | info | yii\db\Command::query | SELECT SUM(r.amount) FROM "a57be577deb434"."tbl_erp_payment_ticket_bank_outs" "r" LEFT JOIN "a57be577deb434"."tbl_erp_payment_tickets" "t" ON r.erp_payment_ticket_id = t.id WHERE ("r"."erp_bank_id"=1) AND ("t"."status" IN (2, 5)) AND ("t"."is_payment_settle"=TRUE) |
| 16:05:04.009 | info | yii\db\Command::query | SELECT SUM(r.amount) FROM "a57be577deb434"."tbl_erp_collect_ticket_bank_ins" "r" LEFT JOIN "a57be577deb434"."tbl_erp_collect_tickets" "t" ON r.erp_collect_ticket_id = t.id WHERE ("r"."erp_bank_id"=1) AND ("t"."status" IN (2, 5)) |
| 16:05:04.011 | info | yii\db\Command::query | SELECT SUM(r.amount) FROM "a57be577deb434"."tbl_erp_social_insurance_bank_outs" "r" LEFT JOIN "a57be577deb434"."tbl_erp_social_insurances" "t" ON r.erp_social_insurance_id = t.id WHERE ("r"."erp_bank_id"=1) AND ("t"."status" IN (2, 5)) AND ("t"."is_payment_settle"=TRUE) |
| 16:05:04.011 | info | yii\db\Command::query | SELECT SUM(r.amount) FROM "a57be577deb434"."tbl_erp_provident_fund_bank_outs" "r" LEFT JOIN "a57be577deb434"."tbl_erp_provident_funds" "t" ON r.erp_provident_fund_id = t.id WHERE ("r"."erp_bank_id"=1) AND ("t"."status" IN (2, 5)) AND ("t"."is_payment_settle"=TRUE) |
| 16:05:04.013 | info | yii\db\Command::query | SELECT SUM(r.amount) FROM "a57be577deb434"."tbl_erp_personal_tax_bank_outs" "r" LEFT JOIN "a57be577deb434"."tbl_erp_personal_taxs" "t" ON r.erp_personal_tax_id = t.id WHERE ("r"."erp_bank_id"=1) AND ("t"."status" IN (2, 5)) AND ("t"."is_payment_settle"=TRUE) |
| 16:05:04.013 | info | yii\db\Command::query | SELECT SUM(r.amount) FROM "a57be577deb434"."tbl_erp_wage_prize_bank_outs" "r" LEFT JOIN "a57be577deb434"."tbl_erp_wage_prizes" "t" ON r.erp_wage_prize_id = t.id WHERE ("r"."erp_bank_id"=1) AND ("t"."status" IN (2, 5)) AND ("t"."is_payment_settle"=TRUE) |
| 16:05:04.014 | info | yii\db\Command::query | SELECT SUM(r.amount) FROM "a57be577deb434"."tbl_erp_wage_ticket_bank_outs" "r" LEFT JOIN "a57be577deb434"."tbl_erp_wage_tickets" "t" ON r.erp_wage_ticket_id = t.id WHERE ("r"."erp_bank_id"=1) AND ("t"."status" IN (2, 5)) |
| 16:05:04.015 | info | yii\db\Command::execute | UPDATE "a57be577deb434"."tbl_erp_banks" SET "balance_amount"='1476232.71' WHERE "id"=1 |
| 16:05:04.016 | 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\ErpBanks', 1, 'a:0:{}', '', 1001, '39.156.194.178') |
| 16:05:04.016 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_banks" WHERE "id"=1 |
| 16:05:04.017 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_account_captions" WHERE "id"=71 |
| 16:05:04.018 | info | yii\db\Command::execute | UPDATE "a57be577deb434"."tbl_erp_account_captions" SET "created_at"='2025-08-01 23:14:45', "updated_at"='2025-08-08 18:50:15' WHERE "id"=71 |
| 16:05:04.018 | 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\ErpAccountCaptions', 71, 'a:0:{}', '', 1001, '39.156.194.178') |
| 16:05:04.019 | 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\ErpBanks', 1, 'a:0:{}', '', 1001, '39.156.194.178') |
| 16:05:04.020 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_payment_ticket_approve_payment_settles" WHERE "erp_payment_ticket_id"=2364 ORDER BY "id" |
| 16:05:04.021 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_payment_ticket_settles" WHERE (purchase_contract_id is not null) AND ("erp_payment_ticket_id"=2364) ORDER BY "id" |
| 16:05:04.021 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 16:05:04.022 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 16:05:04.022 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_purchase_contracts" WHERE "id"=4451 |
| 16:05:04.023 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 16:05:04.023 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 16:05:04.023 | 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"=4451) AND ("t"."status" IN (2, 5)) |
| 16:05:04.025 | 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"=4451) AND ("t"."status" IN (2, 5)) AND ("is_payment_settle"=TRUE) |
| 16:05:04.026 | 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"=4451) AND ("t"."status" IN (2, 5)) AND ("t"."is_payment_settle"=TRUE) |
| 16:05:04.027 | 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"=4451) AND ("t"."status" IN (2, 5)) |
| 16:05:04.028 | 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"=4451) AND ("t"."status"=1)) |
| 16:05:04.029 | 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"=4451) AND ("t"."status"=1)) |
| 16:05:04.030 | 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"=4451) AND ("t"."status"=1) |
| 16:05:04.030 | 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"=4451) AND ("t"."status" IN (1, 2, 5)) |
| 16:05:04.031 | 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"=4451) AND ("t"."status" IN (1, 2, 5)) |
| 16:05:04.032 | 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"=4451) AND ("t"."status" IN (1, 2, 5)) |
| 16:05:04.033 | 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"=4451) AND ("t"."status" IN (1, 2, 5)) |
| 16:05:04.034 | info | yii\db\Command::execute | UPDATE "a57be577deb434"."tbl_purchase_contracts" SET "erp_settle_amount"='0', "erp_un_settle_amount"='1', "erp_all_settle_amount"='0' WHERE "id"=4451 |
| 16:05:04.035 | 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', 4451, 'a:0:{}', '', 1001, '39.156.194.178') |
| 16:05:04.035 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_suppliers" WHERE "id"=431 |
| 16:05:04.036 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 16:05:04.036 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 16:05:04.037 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_purchase_costs" WHERE "purchase_contract_id"=4451 |
| 16:05:04.038 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_purchase_contracts" WHERE "id"=4451 |
| 16:05:04.038 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 16:05:04.039 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 16:05:04.039 | 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"=4451 |
| 16:05:04.040 | 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"=4451) AND ("t"."status" IN (2, 5, 1)) |
| 16:05:04.041 | 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"=4451) AND ("t"."status" IN (2, 5, 1)) |
| 16:05:04.041 | 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"=4451) AND ("t"."status" IN (2, 5, 1)) |
| 16:05:04.042 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_payment_ticket_settles" WHERE (sales_contract_id is not null) AND ("erp_payment_ticket_id"=2364) ORDER BY "id" |
| 16:05:04.043 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_payment_ticket_settles" WHERE (erp_cost_ticket_id is not null) AND ("erp_payment_ticket_id"=2364) ORDER BY "id" |
| 16:05:04.044 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_payment_ticket_settles" WHERE (erp_other_payment_ticket_id is not null) AND ("erp_payment_ticket_id"=2364) ORDER BY "id" |
| 16:05:04.045 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_payment_ticket_payments" WHERE (erp_advance_payment_ticket_id is not null) AND ("erp_payment_ticket_id"=2364) ORDER BY "id" |
| 16:05:04.045 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_payment_ticket_payments" WHERE (erp_other_collect_ticket_id is not null) AND ("erp_payment_ticket_id"=2364) ORDER BY "id" |
| 16:05:04.046 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_payment_tickets" WHERE "id"=2364 |
| 16:05:04.046 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_payment_ticket_bank_outs" WHERE "erp_payment_ticket_id"=2364 ORDER BY "id" |
| 16:05:04.047 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_banks" WHERE "id"=1 |
| 16:05:04.047 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001 |
| 16:05:04.048 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 16:05:04.049 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 16:05:04.049 | 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 (9, 'status', 2364, 20012, 1001, 'now()', '["\u534e\u590f\u94f6\u884c\u5317\u4eac\u4e16\u7eaa\u57ce\u652f\u884c4065200001801900009530:\uffe50;"]', '[]', '{"d1":"\u5218\u4eba\u8bda","d2":"\u66f4\u65b0\u4e86","d3":"\u7ed3\u7b97\u4fe1\u606f","d4":["\u534e\u590f\u94f6\u884c\u5317\u4eac\u4e16\u7eaa\u57ce\u652f\u884c4065200001801900009530:\uffe50;"]}') |
| 16:05:04.050 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001 |
| 16:05:04.051 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_payment_ticket_carbon_copy_rels" WHERE "erp_payment_ticket_id"=2364 |
| 16:05:04.051 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_payment_ticket_settles" WHERE "erp_payment_ticket_id"=2364 ORDER BY "id" |
| 16:05:04.052 | info | yii\db\Command::query | SELECT "user_id" FROM "a57be577deb434"."tbl_auth_assignments" WHERE "item_name"='CommercialAttache' |
| 16:05:04.053 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 16:05:04.053 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 16:05:04.053 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 16:05:04.053 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 16:05:04.054 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_payment_tickets" WHERE "id"=2364 |
| 16:05:04.055 | info | yii\db\Command::query | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001) |
| 16:05:04.057 | info | yii\db\Command::query | INSERT INTO "a57be577deb434"."tbl_comments" ("created_by", "object_type", "object_id", "description", "is_system", "description2") VALUES (1001, '20012', 2364, '刘人诚结算了这个审批', TRUE, 'FKD-20260707-00003') RETURNING "id" |
| 16:05:04.058 | 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', 221036, 'a:11:{s:2:"id";i:221036;s:9:"object_id";i:2364;s:11:"object_type";s:5:"20012";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:18:"FKD-20260707-00003";}', '', 1001, '39.156.194.178') |
| 16:05:04.058 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 16:05:04.059 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 16:05:04.059 | info | yii\db\Command::execute | INSERT INTO "a57be577deb434"."tbl_unread_comments" ("object_id", "object_type", "comment_id", "remind_user_id") VALUES (2364, '20012', 221036, 1011), (2364, '20012', 221036, 1012), (2364, '20012', 221036, 5023), (2364, '20012', 221036, 5298), (2364, '20012', 221036, 1013), (2364, '20012', 221036, 5015), (2364, '20012', 221036, 5360), (2364, '20012', 221036, 5411) |
| 16:05:04.060 | info | yii\db\Command::query | SELECT "channel_id" FROM "global"."tbl_logins" WHERE ("id" IN (1011, 1012, 5023, 5298, 1013, 5015, 5360, 5411)) AND ("id" != 1001) AND (channel_id IS NOT NULL) |
| 16:05:04.061 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_suppliers" WHERE "id"=431 |
| 16:05:04.063 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: INCR |
| 16:05:04.063 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: HSET |
| 16:05:04.063 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: LPUSH |
| 16:05:04.063 | trace | yii\db\Transaction::commit | Commit transaction |
| 16:05:04.065 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 16:05:04.065 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 16:05:04.065 | 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/erp-payment-ticket/save-settle', '{"id":"2364","files":"","erpPaymentTicketBankOuts":[{"amount":"0","id":"1","description":""}],"erpPaymentTicketPayments":"","web_access_token":"ukNwOz-BjUcQL9I3n8iWo2JcLwCMuHVk"}', '{"code":2000,"result":"","status":1,"msg":[{"name":"success","success":"\u7ed3\u7b97\u6210\u529f","error":""}],"mod":0,"ip":"39.156.194.178","ua":"Mozilla\/5.0 (Macintosh; Intel Mac OS X 10.15; rv:152.0) Gecko\/20100101 Firefox\/152.0"}', FALSE, '2026-07-07 16:05:04', 142953984) RETURNING "id" |
| 16:05:04.067 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 16:05:04.067 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: SET |