11:18:24.102 | trace | yii\base\Application::bootstrap | Bootstrap with yii\log\Dispatcher |
11:18:24.102 | trace | yii\base\Module::getModule | Loading module: debug |
11:18:24.103 | trace | yii\base\Application::bootstrap | Bootstrap with yii\debug\Module::bootstrap() |
11:18:24.103 | trace | yii\redis\Connection::open | Opening redis DB connection: redis.server.local:6379, database=1 |
11:18:24.103 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: SELECT |
11:18:24.103 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
11:18:24.103 | trace | yii\base\Module::getModule | Loading module: gii |
11:18:24.103 | trace | yii\base\Application::bootstrap | Bootstrap with yii\gii\Module::bootstrap() |
11:18:24.103 | trace | yii\web\UrlManager::parseRequest | No matching URL rules. Using default URL parsing logic. |
11:18:24.103 | trace | yii\web\Application::handleRequest | Route requested: 'vue/purchase-contract/save-remind-date' |
11:18:24.103 | trace | yii\base\Module::getModule | Loading module: vue |
11:18:24.104 | info | yii\web\Session::open | Session started |
11:18:24.104 | info | yii\db\Command::query | SELECT * FROM "global"."vw_user_login" WHERE "id"=1001 |
11:18:24.104 | info | yii\db\Connection::open | Opening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta |
11:18:24.109 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
11:18:24.109 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
11:18:24.109 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
11:18:24.109 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
11:18:24.109 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001 |
11:18:24.111 | trace | yii\base\Controller::runAction | Route to run: vue/purchase-contract/save-remind-date |
11:18:24.111 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
11:18:24.112 | trace | uranus\rbac\DbManager::checkAccessFromCache | Checking role: Admin |
11:18:24.112 | trace | yii\base\InlineAction::runWithParams | Running action: app\modules\vue\controllers\PurchaseContractController::actionSaveRemindDate() |
11:18:24.112 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_purchase_contracts" WHERE "id"='3851' |
11:18:24.113 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
11:18:24.113 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
11:18:24.113 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
11:18:24.113 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
11:18:24.114 | trace | yii\base\Model::onUnsafeAttribute | Failed to set unsafe attribute 'id' in 'app\models\PurchaseContracts'. |
11:18:24.114 | trace | yii\base\Model::onUnsafeAttribute | Failed to set unsafe attribute 'budget' in 'app\models\PurchaseContracts'. |
11:18:24.114 | trace | yii\base\Model::onUnsafeAttribute | Failed to set unsafe attribute 'purchaseContractPaymentCollectionRemindDates' in 'app\models\PurchaseContracts'. |
11:18:24.114 | trace | yii\base\Model::onUnsafeAttribute | Failed to set unsafe attribute 'purchaseContractPaymentCollectionRemindReceivers' in 'app\models\PurchaseContracts'. |
11:18:24.115 | info | yii\db\Command::query | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_suppliers" WHERE "id"=689) |
11:18:24.115 | info | yii\db\Command::query | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1011) |
11:18:24.115 | info | yii\db\Command::query | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001) |
11:18:24.116 | info | yii\db\Command::execute | |
11:18:24.116 | info | yii\db\Command::query | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_suppliers" WHERE "id"=689) |
11:18:24.116 | info | yii\db\Command::query | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1011) |
11:18:24.117 | info | yii\db\Command::query | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001) |
11:18:24.117 | info | yii\db\Command::execute | UPDATE "a57be577deb434"."tbl_purchase_contracts" SET "updated_at"='now()', "payment_collection_remind_ahead"='0 day', "save_collection_at"='now()' WHERE "id"=3851 |
11:18:24.118 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
11:18:24.118 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
11:18:24.118 | 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', 3851, 'a:2:{s:31:"payment_collection_remind_ahead";s:5:"0 day";s:18:"save_collection_at";s:5:"now()";}', '', 1001, '114.254.1.137') |
11:18:24.120 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_suppliers" WHERE "id"=689 |
11:18:24.120 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
11:18:24.120 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
11:18:24.120 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_purchase_contract_payment_collection_remind_dates" WHERE "contract_id"=3851 |
11:18:24.121 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
11:18:24.121 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
11:18:24.121 | info | yii\db\Command::execute | DELETE FROM "a57be577deb434"."tbl_purchase_contract_payment_collection_remind_dates" WHERE "contract_id"=3851 |
11:18:24.123 | info | yii\db\Command::query | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_purchase_contracts" WHERE "id"=3851) |
11:18:24.123 | info | yii\db\Command::query | INSERT INTO "a57be577deb434"."tbl_purchase_contract_payment_collection_remind_dates" ("contract_id", "remind_date", "amount", "reminded") VALUES (3851, '2025-07-04', '800', FALSE) RETURNING "id" |
11:18:24.125 | 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\PurchaseContractPaymentCollectionRemindDates', 628, 'a:8:{s:2:"id";i:628;s:11:"contract_id";i:3851;s:11:"remind_date";s:10:"2025-07-04";s:8:"reminded";b:0;s:6:"amount";i:800;s:11:"paid_amount";N;s:12:"overdue_days";N;s:6:"status";N;}', '', 1001, '114.254.1.137') |
11:18:24.126 | info | yii\db\Command::execute | DELETE FROM "a57be577deb434"."tbl_contract_default_remind_users" WHERE ("user_id"=1001) AND ("type"=2) |
11:18:24.127 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
11:18:24.127 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
11:18:24.127 | info | yii\db\Command::execute | INSERT INTO "a57be577deb434"."tbl_contract_default_remind_users" ("user_id", "remind_user", "type") VALUES (1001, 1001, 2) |
11:18:24.131 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_purchase_contract_payment_collection_remind_receivers" WHERE "contract_id"=3851 |
11:18:24.131 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
11:18:24.131 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
11:18:24.131 | info | yii\db\Command::execute | DELETE FROM "a57be577deb434"."tbl_purchase_contract_payment_collection_remind_receivers" WHERE "contract_id"=3851 |
11:18:24.132 | info | yii\db\Command::query | INSERT INTO "a57be577deb434"."tbl_purchase_contract_payment_collection_remind_receivers" ("contract_id", "user_id") VALUES (3851, 1001) RETURNING "id" |
11:18:24.135 | 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\PurchaseContractPaymentCollectionRemindReceivers', 1027, 'a:3:{s:2:"id";i:1027;s:11:"contract_id";i:3851;s:7:"user_id";s:4:"1001";}', '', 1001, '114.254.1.137') |
11:18:24.136 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_purchase_contracts" WHERE "id"=3851 |
11:18:24.137 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
11:18:24.137 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
11:18:24.137 | info | yii\db\Command::execute | UPDATE "a57be577deb434"."tbl_purchase_contract_payments" SET "paid_amount"='0' WHERE "contract_id"=3851 |
11:18:24.138 | 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"=3851 |
11:18:24.139 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_purchase_contract_payments" WHERE ("contract_id"=3851) AND (amount > 0) AND (amount > paid_amount) ORDER BY "collected_date", "created_at" |
11:18:24.140 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_purchase_contract_payment_collection_remind_dates" WHERE ("contract_id"=3851) AND (amount > paid_amount) ORDER BY "remind_date" |
11:18:24.140 | info | yii\db\Command::execute | UPDATE "a57be577deb434"."tbl_purchase_contract_payment_collection_remind_dates" SET "paid_amount"='1' WHERE "id"=628 |
11:18:24.141 | 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', 628, 'a:1:{s:11:"paid_amount";i:1;}', '', 1001, '114.254.1.137') |
11:18:24.142 | info | yii\db\Command::execute | UPDATE "a57be577deb434"."tbl_purchase_contract_payments" SET "paid_amount"='1' WHERE "id"=2101 |
11:18:24.143 | 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\PurchaseContractPayments', 2101, 'a:1:{s:11:"paid_amount";s:1:"0";}', '', 1001, '114.254.1.137') |
11:18:24.144 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_purchase_contract_payments" WHERE ("contract_id"=3851) AND (amount > 0) AND (amount > paid_amount) ORDER BY "collected_date", "created_at" |
11:18:24.144 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_purchase_contract_payment_collection_remind_dates" WHERE ("contract_id"=3851) AND (amount > paid_amount) ORDER BY "remind_date" |
11:18:24.145 | info | yii\db\Command::execute | UPDATE "a57be577deb434"."tbl_purchase_contract_payment_collection_remind_dates" SET "paid_amount"='800', "overdue_days"=0, "status"=1 WHERE "id"=628 |
11:18:24.145 | 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', 628, 'a:0:{}', '', 1001, '114.254.1.137') |
11:18:24.146 | info | yii\db\Command::execute | UPDATE "a57be577deb434"."tbl_purchase_contract_payments" SET "paid_amount"='799' WHERE "id"=2102 |
11:18:24.147 | 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\PurchaseContractPayments', 2102, 'a:1:{s:11:"paid_amount";i:799;}', '', 1001, '114.254.1.137') |
11:18:24.148 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_purchase_contract_payment_collection_remind_dates" WHERE ("contract_id"=3851) AND (amount > paid_amount) ORDER BY "remind_date" |
11:18:24.148 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
11:18:24.148 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
11:18:24.148 | info | yii\db\Command::query | INSERT INTO "global"."tbl_api_log" ("code", "schema", "user_id", "device_type", "url", "request", "response", "php_error", "time") VALUES (200, 'a57be577deb434', 1001, 5, 'vue/purchase-contract/save-remind-date', '{"PurchaseContracts":{"id":"3851","budget":"867867","purchaseContractPaymentCollectionRemindDates":{"2025-07-04":"800"},"purchaseContractPaymentCollectionRemindReceivers":["1001"],"payment_collection_remind_ahead":""},"web_access_token":"er_liQPTz011rRwTshQzixBLTwcD6PCJ"}', '{"code":2000,"result":"","status":1,"msg":[{"name":"success","success":"\u91c7\u8d2d\u5408\u540c\u5df2\u88ab\u6210\u529f\u4fee\u6539","error":""}],"mod":0}', FALSE, '2025-07-04 11:18:24') RETURNING "id" |
11:18:24.150 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
11:18:24.150 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: SET |