68c90d897df49: POST https://beta.jinchangxiao.com/vue/purchase-contract/save-edit at 2025-09-16 03:11:05 pm by 114.244.128.96
Log Messages
总计116条数据
| Time | Level | Category | Message |
|---|---|---|---|
| 15:11:05.515 | trace | yii\base\Application::bootstrap | Bootstrap with yii\log\Dispatcher |
| 15:11:05.515 | trace | yii\base\Module::getModule | Loading module: debug |
| 15:11:05.515 | trace | yii\base\Application::bootstrap | Bootstrap with yii\debug\Module::bootstrap() |
| 15:11:05.516 | trace | yii\redis\Connection::open | Opening redis DB connection: redis.server.local:6379, database=1 |
| 15:11:05.516 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: SELECT |
| 15:11:05.516 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 15:11:05.516 | trace | yii\base\Module::getModule | Loading module: gii |
| 15:11:05.516 | trace | yii\base\Application::bootstrap | Bootstrap with yii\gii\Module::bootstrap() |
| 15:11:05.516 | trace | yii\web\UrlManager::parseRequest | No matching URL rules. Using default URL parsing logic. |
| 15:11:05.516 | trace | yii\web\Application::handleRequest | Route requested: 'vue/purchase-contract/save-edit' |
| 15:11:05.516 | trace | yii\base\Module::getModule | Loading module: vue |
| 15:11:05.517 | info | yii\web\Session::open | Session started |
| 15:11:05.517 | info | yii\db\Command::query | SELECT * FROM "global"."vw_user_login" WHERE "id"=1011 |
| 15:11:05.517 | info | yii\db\Connection::open | Opening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta |
| 15:11:05.521 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 15:11:05.522 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 15:11:05.522 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 15:11:05.522 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 15:11:05.522 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1011 |
| 15:11:05.524 | trace | yii\base\Controller::runAction | Route to run: vue/purchase-contract/save-edit |
| 15:11:05.524 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 15:11:05.525 | trace | uranus\rbac\DbManager::checkAccessFromCache | Checking role: Admin |
| 15:11:05.525 | trace | uranus\rbac\DbManager::checkAccessFromCache | Checking permission: updatePurchaseContract |
| 15:11:05.525 | trace | uranus\rbac\DbManager::checkAccessFromCache | Checking role: Admin |
| 15:11:05.525 | trace | uranus\rbac\DbManager::checkAccessFromCache | Checking role: ProjectManager |
| 15:11:05.525 | trace | uranus\rbac\DbManager::checkAccessFromCache | Checking role: 电话销售 |
| 15:11:05.525 | trace | uranus\rbac\DbManager::checkAccessFromCache | Checking role: CommercialAttache |
| 15:11:05.525 | trace | yii\base\InlineAction::runWithParams | Running action: app\modules\vue\controllers\PurchaseContractController::actionSaveEdit() |
| 15:11:05.525 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_purchase_contracts" WHERE "id"='4141' |
| 15:11:05.526 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 15:11:05.526 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 15:11:05.526 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 15:11:05.527 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 15:11:05.529 | trace | yii\base\Model::onUnsafeAttribute | Failed to set unsafe attribute 'id' in 'app\models\PurchaseContracts'. |
| 15:11:05.529 | trace | yii\base\Model::onUnsafeAttribute | Failed to set unsafe attribute 'product_number' in 'app\models\PurchaseContracts'. |
| 15:11:05.529 | trace | yii\base\Model::onUnsafeAttribute | Failed to set unsafe attribute 'product_amount' in 'app\models\PurchaseContracts'. |
| 15:11:05.529 | trace | yii\base\Model::onUnsafeAttribute | Failed to set unsafe attribute 'purchaseContractProductRels' in 'app\models\PurchaseContracts'. |
| 15:11:05.529 | trace | yii\base\Model::onUnsafeAttribute | Failed to set unsafe attribute 'contractScans' in 'app\models\PurchaseContracts'. |
| 15:11:05.529 | trace | yii\base\Model::onUnsafeAttribute | Failed to set unsafe attribute 'receiptScans' in 'app\models\PurchaseContracts'. |
| 15:11:05.529 | trace | yii\base\Model::onUnsafeAttribute | Failed to set unsafe attribute 'purchaseClientRels' in 'app\models\PurchaseContracts'. |
| 15:11:05.529 | trace | yii\base\Model::onUnsafeAttribute | Failed to set unsafe attribute 'PurchaseContractInvoices' in 'app\models\PurchaseContracts'. |
| 15:11:05.530 | info | yii\db\Command::query | SELECT "id" FROM "a57be577deb434"."tbl_purchase_contracts" WHERE "serial_no"='而特热舞' LIMIT 2 |
| 15:11:05.531 | info | yii\db\Command::query | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_suppliers" WHERE "id"='431') |
| 15:11:05.532 | info | yii\db\Command::query | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"='1011') |
| 15:11:05.533 | info | yii\db\Command::query | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001) |
| 15:11:05.533 | info | yii\db\Command::execute | |
| 15:11:05.533 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=108) AND ("object_id"=4141) |
| 15:11:05.538 | info | yii\db\Command::execute | DELETE FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=108) AND ("object_id"=4141) |
| 15:11:05.540 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=111) AND ("object_id"=4141) |
| 15:11:05.543 | info | yii\db\Command::execute | DELETE FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=111) AND ("object_id"=4141) |
| 15:11:05.547 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_purchase_client_rels" WHERE "contract_id"=4141 |
| 15:11:05.548 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 15:11:05.548 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 15:11:05.548 | info | yii\db\Command::execute | DELETE FROM "a57be577deb434"."tbl_purchase_client_rels" WHERE "contract_id"=4141 |
| 15:11:05.549 | info | yii\db\Command::execute | DELETE FROM "a57be577deb434"."tbl_sales_supplier_rels" WHERE "purchase_id"=4141 |
| 15:11:05.550 | info | yii\db\Command::query | INSERT INTO "a57be577deb434"."tbl_purchase_client_rels" ("contract_id", "client_id", "project_id") VALUES (4141, 1661, 1791) RETURNING "id" |
| 15:11:05.553 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 15:11:05.553 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 15:11:05.553 | 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', 3808, 'a:4:{s:2:"id";i:3808;s:11:"contract_id";i:4141;s:9:"client_id";s:4:"1661";s:10:"project_id";s:4:"1791";}', '', 1011, '114.244.128.96') |
| 15:11:05.555 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_sales_contracts" WHERE "from_project"='1791' |
| 15:11:05.556 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 15:11:05.556 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 15:11:05.556 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 15:11:05.556 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 15:11:05.556 | info | yii\db\Command::query | INSERT INTO "a57be577deb434"."tbl_sales_supplier_rels" ("contract_id", "supplier_id", "purchase_id") VALUES (1558, 431, 4141) RETURNING "id" |
| 15:11:05.557 | 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', 3212, 'a:4:{s:2:"id";i:3212;s:11:"contract_id";i:1558;s:11:"supplier_id";s:3:"431";s:11:"purchase_id";i:4141;}', '', 1011, '114.244.128.96') |
| 15:11:05.558 | info | yii\db\Command::query | SELECT "id" FROM "a57be577deb434"."tbl_purchase_contract_invoices" WHERE "contract_id"=4141 |
| 15:11:05.559 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_purchase_client_rels" WHERE "contract_id"=4141 |
| 15:11:05.559 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_purchase_contract_invoices" WHERE 0=1 |
| 15:11:05.559 | info | yii\db\Command::execute | DELETE FROM "a57be577deb434"."tbl_purchase_contract_invoices" WHERE 0=1 |
| 15:11:05.560 | info | yii\db\Command::execute | UPDATE "a57be577deb434"."tbl_purchase_contracts" SET "supplier_id"=431, "contract_type"=1, "handler"=1011, "updated_at"='now()', "including_tax"=TRUE, "is_draft"=FALSE WHERE "id"=4141 |
| 15:11:05.561 | 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', 4141, 'a:1:{s:8:"is_draft";s:1:"0";}', '', 1011, '114.244.128.96') |
| 15:11:05.562 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_suppliers" WHERE "id"='431' |
| 15:11:05.562 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 15:11:05.562 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 15:11:05.562 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_purchase_contract_product_rels" WHERE "purchase_contract_id"=4141 |
| 15:11:05.563 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 15:11:05.563 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 15:11:05.563 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 15:11:05.563 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 15:11:05.563 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_products" WHERE "id"=1040 |
| 15:11:05.564 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_products" WHERE "id"='1040' |
| 15:11:05.564 | info | yii\db\Command::query | SELECT "id" FROM "a57be577deb434"."tbl_purchase_contract_product_rels" WHERE "purchase_contract_id"=4141 |
| 15:11:05.564 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_purchase_contract_product_rels" WHERE "id"=99 |
| 15:11:05.565 | info | yii\db\Command::execute | UPDATE "a57be577deb434"."tbl_purchase_contract_product_rels" SET "product_id"=1040 WHERE "id"=99 |
| 15:11:05.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\PurchaseContractProductRels', 99, 'a:0:{}', '', 1011, '114.244.128.96') |
| 15:11:05.567 | info | yii\db\Command::execute | DELETE FROM "a57be577deb434"."tbl_purchase_contract_product_rels" WHERE 0=1 |
| 15:11:05.567 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_purchase_contracts" WHERE "id"=4141 |
| 15:11:05.567 | 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"=4141) AND ("t"."status" IN (2, 5)) |
| 15:11:05.568 | 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"=4141) AND ("t"."status" IN (2, 5)) AND ("is_payment_settle"=TRUE) |
| 15:11:05.569 | 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"=4141) AND ("t"."status" IN (2, 5)) AND ("t"."is_payment_settle"=TRUE) |
| 15:11:05.570 | 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"=4141) AND ("t"."status" IN (2, 5)) |
| 15:11:05.571 | 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"=4141) AND ("t"."status"=1)) |
| 15:11:05.572 | 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"=4141) AND ("t"."status"=1)) |
| 15:11:05.572 | 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"=4141) AND ("t"."status"=1) |
| 15:11:05.573 | info | yii\db\Command::execute | UPDATE "a57be577deb434"."tbl_purchase_contracts" SET "erp_settle_amount"='45', "erp_un_settle_amount"='10257' WHERE "id"=4141 |
| 15:11:05.574 | 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', 4141, 'a:0:{}', '', 1011, '114.244.128.96') |
| 15:11:05.575 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_suppliers" WHERE "id"=431 |
| 15:11:05.575 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_purchase_costs" WHERE "purchase_contract_id"=4141 |
| 15:11:05.576 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_purchase_contracts" WHERE "id"=4141 |
| 15:11:05.576 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 15:11:05.577 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 15:11:05.577 | 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"=4141 |
| 15:11:05.577 | 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"=4141) AND ("t"."status" IN (2, 5, 1)) |
| 15:11:05.578 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 15:11:05.578 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 15:11:05.578 | info | yii\db\Command::query | SELECT r.amount, t.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"=4141) AND ("t"."status" IN (2, 5, 1)) |
| 15:11:05.578 | info | yii\db\Command::query | SELECT r.amount, t.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"=4141) AND ("t"."status" IN (2, 5, 1)) |
| 15:11:05.579 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 15:11:05.579 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 15:11:05.579 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_purchase_contract_payment_collection_remind_dates" WHERE ("contract_id"=4141) AND (amount > paid_amount) ORDER BY "remind_date" |
| 15:11:05.580 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 15:11:05.580 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 15:11:05.580 | 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', 1011, 5, 'vue/purchase-contract/save-edit', '{"PurchaseContracts":{"id":"4141","supplier_id":"431","is_draft":"0","amount":"10302","handler":"1011","contract_type":"1","serial_no":"\u800c\u7279\u70ed\u821e","signed_at":"2025-09-12","description":"","including_tax":"1","product_number":"3","product_amount":"10302","purchaseContractProductRels":{"99":{"product_id":"1040","number":"3","amount":"3434","total_amount":"10302.00","erp_store_id":"","description":""}},"contractScans":"","receiptScans":"","purchaseClientRels":[{"client_id":"1661","project_id":"1791"}],"PurchaseContractInvoices":""},"web_access_token":"18_8RvXePAHKXb4kC8IN2O6XIdrtwTnd"}', '{"code":2000,"result":"","status":1,"msg":[{"name":"success","success":"\u91c7\u8d2d\u5408\u540c\u5df2\u88ab\u6210\u529f\u4fee\u6539","error":""}],"mod":0}', FALSE, '2025-09-16 15:11:05') RETURNING "id" |
| 15:11:05.581 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 15:11:05.581 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: SET |