ConfigurationRequestLogsProfilingDatabaseAsset BundlesMailTimeline
6897fab802331: GET https://beta.jinchangxiao.com/vue/supplier/get-edit at 2025-08-10 09:49:44 am by 114.119.152.128

Log Messages

总计29条数据
TimeLevelCategoryMessage
 
09:49:44.008traceyii\base\Application::bootstrapBootstrap with yii\log\Dispatcher
09:49:44.008traceyii\base\Module::getModuleLoading module: debug
09:49:44.008traceyii\base\Application::bootstrapBootstrap with yii\debug\Module::bootstrap()
09:49:44.009traceyii\redis\Connection::openOpening redis DB connection: redis.server.local:6379, database=1
09:49:44.009traceyii\redis\Connection::executeCommandExecuting Redis Command: SELECT
09:49:44.009traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
09:49:44.009traceyii\base\Module::getModuleLoading module: gii
09:49:44.009traceyii\base\Application::bootstrapBootstrap with yii\gii\Module::bootstrap()
09:49:44.009traceyii\web\UrlManager::parseRequestNo matching URL rules. Using default URL parsing logic.
09:49:44.009traceyii\web\Application::handleRequestRoute requested: 'vue/supplier/get-edit'
09:49:44.009traceyii\base\Module::getModuleLoading module: vue
09:49:44.010infoyii\web\Session::openSession started
09:49:44.011infoyii\db\Command::querySELECT * FROM "global"."vw_user_login" WHERE "id"=1001
09:49:44.011infoyii\db\Connection::openOpening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta
09:49:44.015traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
09:49:44.015traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
09:49:44.015traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
09:49:44.015traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
09:49:44.016infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
09:49:44.017traceyii\base\Controller::runActionRoute to run: vue/supplier/get-edit
09:49:44.018traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
09:49:44.018traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: Admin
09:49:44.018traceyii\base\InlineAction::runWithParamsRunning action: app\modules\vue\controllers\SupplierController::actionGetEdit()
09:49:44.038infoyii\db\Command::querySELECT DISTINCT "s".*, sum(pc.total_amount) as total_amount, sum(pc.collected) as collected, sum(pc.total_amount) - sum(pc.collected) as un_collected, sum(pc.invoiced) as invoiced, sum(pc.total_amount) - sum(pc.invoiced) as un_invoiced FROM "a57be577deb434"."tbl_suppliers" "s" LEFT JOIN (SELECT pc.supplier_id, sum(pc.amount) as total_amount, sum(case when pcp.collected is not null then pcp.collected else 0 end) as collected, sum(case when pci.invoiced is not null then pci.invoiced else 0 end) as invoiced FROM "a57be577deb434"."tbl_purchase_contracts" "pc" LEFT JOIN (SELECT "contract_id", sum(amount) as collected FROM ((SELECT '1' || r.id::varchar as id, 1 as ticket_type, r.purchase_contract_id as contract_id, r.amount as amount, t.created_at::timestamp without time zone as collected_date, t.created_at, t.created_by, t.abstract as description 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 "t"."status" IN (2, 5, 1)) UNION ALL ( SELECT '2' || r.id::varchar as id, 2 as ticket_type, r.purchase_contract_id as contract_id, r.amount as amount, t.created_at::timestamp without time zone as collected_date, t.created_at, t.created_by, t.abstract as description 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 "t"."status" IN (2, 5, 1) ) UNION ALL ( SELECT '3' || r.id::varchar as id, 3 as ticket_type, r.purchase_contract_id as contract_id, r.amount as amount, t.created_at::timestamp without time zone as collected_date, t.created_at, t.created_by, t.abstract as description 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 "t"."status" IN (2, 5, 1) ) UNION ALL ( SELECT '4' || r.id::varchar as id, 4 as ticket_type, r.purchase_contract_id as contract_id, 0 - r.amount as amount, t.created_at::timestamp without time zone as collected_date, t.created_at, t.created_by, t.abstract as description 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 "t"."status" IN (2, 5, 1) )) "sub" GROUP BY "contract_id") "pcp" ON pcp.contract_id = pc.id LEFT JOIN (SELECT "contract_id", sum(amount) as invoiced FROM "a57be577deb434"."tbl_purchase_contract_invoices" GROUP BY "contract_id") "pci" ON pci.contract_id = pc.id WHERE ("is_chargeback"=FALSE) AND (pc.is_draft = false) AND (pc.is_refuse = false) GROUP BY "pc"."supplier_id") "pc" ON pc.supplier_id = s.id WHERE "s"."id" IS NULL GROUP BY "s"."id"
09:49:44.056traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
09:49:44.056traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
09:49:44.057infoyii\db\Command::queryINSERT INTO "global"."tbl_api_log" ("code", "schema", "user_id", "device_type", "url", "request", "response", "php_error", "time") VALUES (200, 'a57be577deb434', 1001, 5, 'vue/supplier/get-edit', '[]', '{"code":500,"result":{},"status":0,"msg":[{"name":"error","success":"","error":"\u60a8\u8bbf\u95ee\u7684\u4f9b\u5e94\u5546\u5df2\u4e0d\u5b58\u5728"}],"mod":0}', FALSE, '2025-08-10 09:49:44') RETURNING "id"
09:49:44.058traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
09:49:44.058traceyii\redis\Connection::executeCommandExecuting Redis Command: SET