ConfigurationRequestLogsProfilingDatabaseAsset BundlesMailTimeline
68a439a6e9288: POST https://beta.jinchangxiao.com/vue/tax/sales-invoice-cancel-match at 2025-08-19 04:45:26 pm by 223.104.44.8

Log Messages

总计94条数据
TimeLevelCategoryMessage
 
16:45:26.954traceyii\base\Application::bootstrapBootstrap with yii\log\Dispatcher
16:45:26.954traceyii\base\Module::getModuleLoading module: debug
16:45:26.954traceyii\base\Application::bootstrapBootstrap with yii\debug\Module::bootstrap()
16:45:26.955traceyii\redis\Connection::openOpening redis DB connection: redis.server.local:6379, database=1
16:45:26.955traceyii\redis\Connection::executeCommandExecuting Redis Command: SELECT
16:45:26.955traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
16:45:26.955traceyii\base\Module::getModuleLoading module: gii
16:45:26.955traceyii\base\Application::bootstrapBootstrap with yii\gii\Module::bootstrap()
16:45:26.955traceyii\web\UrlManager::parseRequestNo matching URL rules. Using default URL parsing logic.
16:45:26.955traceyii\web\Application::handleRequestRoute requested: 'vue/tax/sales-invoice-cancel-match'
16:45:26.955traceyii\base\Module::getModuleLoading module: vue
16:45:26.956infoyii\web\Session::openSession started
16:45:26.956infoyii\db\Command::querySELECT * FROM "global"."vw_user_login" WHERE "id"=1001
16:45:26.956infoyii\db\Connection::openOpening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta
16:45:26.961traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
16:45:26.961traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
16:45:26.961traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
16:45:26.961traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
16:45:26.961infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
16:45:26.963traceyii\base\Controller::runActionRoute to run: vue/tax/sales-invoice-cancel-match
16:45:26.963traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
16:45:26.964traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: Admin
16:45:26.964traceyii\base\InlineAction::runWithParamsRunning action: app\modules\vue\controllers\TaxController::actionSalesInvoiceCancelMatch()
16:45:26.965infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_sales_contract_invoices" WHERE "id"='2115'
16:45:26.965traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
16:45:26.965traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
16:45:26.966infoyii\db\Command::querySELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id"=5252
16:45:26.966infoyii\db\Command::querySELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=5252)
16:45:26.967traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
16:45:26.967traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
16:45:26.967infoyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_departments" WHERE "id"=6
16:45:26.968traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
16:45:26.968traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
16:45:26.968infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_sales_invoice_reminders" WHERE "sales_invoice_id"=2115
16:45:26.968infoyii\db\Command::querySELECT "sip".*, sum(inventory) as inventory_count FROM "a57be577deb434"."tbl_sales_invoice_products" "sip" LEFT JOIN "a57be577deb434"."tbl_inventory_products" "ip" ON lower(ip.title) = lower(sip.title) AND lower(ip.description) = lower(sip.description) WHERE "sip"."sales_invoice_id"=2115 GROUP BY "sip"."id"
16:45:26.971traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
16:45:26.971traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
16:45:26.971infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_inventory_product_spents" WHERE "sales_product_id"=812
16:45:26.972traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
16:45:26.972traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
16:45:26.972infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_inventory_products" WHERE "id"=63
16:45:26.972traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
16:45:26.973traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
16:45:26.973infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_purchase_contract_invoices" WHERE "id"=1828
16:45:26.973traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
16:45:26.973traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
16:45:26.974infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_inventory_product_spents" WHERE "sales_invoice_id"=2115
16:45:26.974infoyii\db\Command::executeUPDATE "a57be577deb434"."tbl_sales_invoice_products" SET "outbound"='0' WHERE "id"=812
16:45:26.975traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
16:45:26.975traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
16:45:26.975infoyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\SalesInvoiceProducts', 812, 'a:0:{}', '', 1001, '223.104.44.8')
16:45:26.977infoyii\db\Command::executeDELETE FROM "a57be577deb434"."tbl_inventory_product_spents" WHERE "sales_product_id"=812
16:45:26.977infoyii\db\Command::executeDELETE FROM "a57be577deb434"."tbl_inventory_product_spents" WHERE "sales_invoice_id"=2115
16:45:26.978infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_inventory_products" WHERE "id"=63
16:45:26.978infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_purchase_contract_invoices" WHERE "id"=1828
16:45:26.978infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_purchase_contract_invoices" WHERE "id"=1828
16:45:26.979infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_purchase_invoice_products" WHERE "purchase_invoice_id"=1828
16:45:26.979traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
16:45:26.979traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
16:45:26.980infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_inventory_products" WHERE "purchase_product_id"=63
16:45:26.980infoyii\db\Command::executeUPDATE "a57be577deb434"."tbl_inventory_products" SET "inventory"='16' WHERE "id"=63
16:45:26.981infoyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\InventoryProducts', 63, 'a:1:{s:9:"inventory";s:2:"11";}', '', 1001, '223.104.44.8')
16:45:26.982infoyii\db\Command::querySELECT SUM(outbound) FROM "a57be577deb434"."tbl_inventory_product_spents" WHERE "inventory_product_id"=63
16:45:26.982infoyii\db\Command::executeUPDATE "a57be577deb434"."tbl_inventory_products" SET "outbound"='3', "inventory"='13' WHERE "id"=63
16:45:26.983infoyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\InventoryProducts', 63, 'a:2:{s:8:"outbound";s:1:"3";s:9:"inventory";i:13;}', '', 1001, '223.104.44.8')
16:45:26.984infoyii\db\Command::executeUPDATE "a57be577deb434"."tbl_purchase_invoice_products" SET "outbound"='3', "inventory"='13' WHERE "id"=63
16:45:26.986infoyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\PurchaseInvoiceProducts', 63, 'a:2:{s:8:"outbound";s:1:"3";s:9:"inventory";i:13;}', '', 1001, '223.104.44.8')
16:45:26.986infoyii\db\Command::executeUPDATE "a57be577deb434"."tbl_purchase_contract_invoices" SET "paid_amount"='35.43' WHERE "id"=1828
16:45:26.987infoyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\PurchaseContractInvoices', 1828, 'a:1:{s:11:"paid_amount";d:35.43;}', '', 1001, '223.104.44.8')
16:45:26.988infoyii\db\Command::executeDELETE FROM "a57be577deb434"."tbl_inventory_products" WHERE ("purchase_invoice_id"=1828) AND ("purchase_product_id"<>63)
16:45:26.989infoyii\db\Command::executeUPDATE "a57be577deb434"."tbl_sales_contract_invoices" SET "is_match"=FALSE, "is_used"=FALSE WHERE "id"=2115
16:45:26.989infoyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\SalesContractInvoices', 2115, 'a:0:{}', '', 1001, '223.104.44.8')
16:45:26.990infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_sales_contract_invoices" WHERE "id"=2115
16:45:26.991infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_sales_invoice_products" WHERE "sales_invoice_id"=2115
16:45:26.991infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_inventory_product_spents" WHERE "sales_product_id"=812
16:45:26.991infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_inventory_product_spents" WHERE "sales_invoice_id"=2115
16:45:26.992infoyii\db\Command::querySELECT SUM(outbound) FROM "a57be577deb434"."tbl_inventory_product_spents" WHERE "sales_product_id"=812
16:45:26.992infoyii\db\Command::executeUPDATE "a57be577deb434"."tbl_sales_invoice_products" SET "outbound"='0' WHERE "id"=812
16:45:26.993infoyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\SalesInvoiceProducts', 812, 'a:0:{}', '', 1001, '223.104.44.8')
16:45:26.994infoyii\db\Command::executeUPDATE "a57be577deb434"."tbl_sales_contract_invoices" SET "match_tax_amount"='0', "simple_match_tax_amount"='0' WHERE "id"=2115
16:45:26.994infoyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\SalesContractInvoices', 2115, 'a:1:{s:16:"match_tax_amount";s:4:"0.23";}', '', 1001, '223.104.44.8')
16:45:26.995infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
16:45:26.996traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
16:45:26.996traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
16:45:26.996infoyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_object_change_logs" ("act", "attribute", "object_id", "object_type", "created_by", "created_at", "new_value", "old_value", "description") VALUES (23, 'status', 2115, 107, 1001, 'now()', '["\u5218\u4eba\u8bda"]', '[]', '{"d1":"\u5218\u4eba\u8bda","d2":"\u53d6\u6d88\u6838\u9500\u4e86","d3":"\u9500\u552e\u53d1\u7968","d4":[""]}')
16:45:26.997traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
16:45:26.997traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
16:45:26.997infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_visit_module_histories" WHERE ("user_id"=1001) AND ("object_type"=10004) AND ("visit_date"='2025-08-19')
16:45:27.001traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
16:45:27.001traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
16:45:27.001infoyii\db\Command::executeUPDATE "a57be577deb434"."tbl_visit_module_histories" SET "num"=110, "last_visit_at"='now()' WHERE "id"=55336
16:45:27.002infoyii\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/tax/sales-invoice-cancel-match', '{"id":"2115","web_access_token":"239qcuu_ToIhJtTt60gp-9_fllLTtTgq"}', '{"code":2000,"result":"","status":1,"msg":[{"name":"success","success":"\u64cd\u4f5c\u6210\u529f","error":""}],"mod":0}', FALSE, '2025-08-19 16:45:27') RETURNING "id"
16:45:27.003traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
16:45:27.003traceyii\redis\Connection::executeCommandExecuting Redis Command: SET