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

Log Messages

总计57条数据
TimeLevelCategoryMessage
 
16:45:08.975traceyii\base\Application::bootstrapBootstrap with yii\log\Dispatcher
16:45:08.975traceyii\base\Module::getModuleLoading module: debug
16:45:08.975traceyii\base\Application::bootstrapBootstrap with yii\debug\Module::bootstrap()
16:45:08.975traceyii\redis\Connection::openOpening redis DB connection: redis.server.local:6379, database=1
16:45:08.975traceyii\redis\Connection::executeCommandExecuting Redis Command: SELECT
16:45:08.975traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
16:45:08.975traceyii\base\Module::getModuleLoading module: gii
16:45:08.975traceyii\base\Application::bootstrapBootstrap with yii\gii\Module::bootstrap()
16:45:08.976traceyii\web\UrlManager::parseRequestNo matching URL rules. Using default URL parsing logic.
16:45:08.976traceyii\web\Application::handleRequestRoute requested: 'vue/tax/sales-invoice-list-match'
16:45:08.976traceyii\base\Module::getModuleLoading module: vue
16:45:08.976infoyii\web\Session::openSession started
16:45:08.976infoyii\db\Command::querySELECT * FROM "global"."vw_user_login" WHERE "id"=1001
16:45:08.976infoyii\db\Connection::openOpening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta
16:45:08.981traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
16:45:08.981traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
16:45:08.981traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
16:45:08.981traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
16:45:08.982infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
16:45:08.983traceyii\base\Controller::runActionRoute to run: vue/tax/sales-invoice-list-match
16:45:08.983traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
16:45:08.984traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: Admin
16:45:08.984traceyii\base\InlineAction::runWithParamsRunning action: app\modules\vue\controllers\TaxController::actionSalesInvoiceListMatch()
16:45:08.984traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
16:45:08.985traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
16:45:08.985traceyii\base\Model::onUnsafeAttributeFailed to set unsafe attribute 'id' in 'app\models\search\InventoryProductSearch'.
16:45:08.985infoyii\db\Command::querySELECT COUNT(*) FROM (SELECT ip.* FROM "a57be577deb434"."tbl_inventory_products" "ip" LEFT JOIN "a57be577deb434"."tbl_purchase_contract_invoices" "pci" ON ip.purchase_invoice_id = pci.id LEFT JOIN "a57be577deb434"."tbl_purchase_contracts" "pc" ON pc.id = pci.contract_id LEFT JOIN "a57be577deb434"."tbl_suppliers" "s" ON pc.supplier_id = s.id LEFT JOIN "a57be577deb434"."tbl_purchase_invoice_projects" "pip" ON pci.id = pip.purchase_invoice_id LEFT JOIN "a57be577deb434"."tbl_projects" "p" ON p.id = pip.project_id LEFT JOIN "a57be577deb434"."tbl_clients" "c" ON p.client_id = c.id WHERE (LOWER(ip.description) = LOWER('*计算机配套产品*内存')) AND (LOWER(ip.title) = LOWER('16g')) AND ("ip"."inventory" > 0) GROUP BY "ip"."id", "pci"."id" ORDER BY "ip"."created_at" DESC) "c"
16:45:08.989infoyii\db\Command::querySELECT ip.* FROM "a57be577deb434"."tbl_inventory_products" "ip" LEFT JOIN "a57be577deb434"."tbl_purchase_contract_invoices" "pci" ON ip.purchase_invoice_id = pci.id LEFT JOIN "a57be577deb434"."tbl_purchase_contracts" "pc" ON pc.id = pci.contract_id LEFT JOIN "a57be577deb434"."tbl_suppliers" "s" ON pc.supplier_id = s.id LEFT JOIN "a57be577deb434"."tbl_purchase_invoice_projects" "pip" ON pci.id = pip.purchase_invoice_id LEFT JOIN "a57be577deb434"."tbl_projects" "p" ON p.id = pip.project_id LEFT JOIN "a57be577deb434"."tbl_clients" "c" ON p.client_id = c.id WHERE (LOWER(ip.description) = LOWER('*计算机配套产品*内存')) AND (LOWER(ip.title) = LOWER('16g')) AND ("ip"."inventory" > 0) GROUP BY "ip"."id", "pci"."id" ORDER BY "ip"."created_at" DESC LIMIT 20
16:45:08.991infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_purchase_contract_invoices" WHERE "id" IN (2387, 2386)
16:45:08.992infoyii\db\Command::querySELECT "id", "id" AS "key", "serial_no", "supplier_id" FROM "a57be577deb434"."tbl_purchase_contracts" WHERE "id" IN (4045, 4052)
16:45:08.992infoyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_suppliers" WHERE "id"=608
16:45:08.993infoyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_suppliers" WHERE "id"=608
16:45:08.993infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_purchase_invoice_projects" WHERE "purchase_invoice_id" IN (2386, 2387)
16:45:08.993infoyii\db\Command::querySELECT "id", "id" AS "key", "project_title" AS "name", "client_id" FROM "a57be577deb434"."tbl_projects" WHERE "id" IN (3920, 3925, 3924)
16:45:08.994infoyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_clients" WHERE "id"=12
16:45:08.994infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_purchase_invoice_reminders" WHERE "purchase_invoice_id" IN (2386, 2387)
16:45:08.994infoyii\db\Command::querySELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id"=5360
16:45:08.995infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_purchase_invoice_products" WHERE "purchase_invoice_id" IN (2386, 2387)
16:45:08.995infoyii\db\Command::querySELECT COUNT(*) FROM "a57be577deb434"."tbl_inventory_products" WHERE "id" IN (SELECT "ip"."id" FROM "a57be577deb434"."tbl_inventory_products" "ip" LEFT JOIN "a57be577deb434"."tbl_purchase_contract_invoices" "pci" ON ip.purchase_invoice_id = pci.id LEFT JOIN "a57be577deb434"."tbl_purchase_contracts" "pc" ON pc.id = pci.contract_id LEFT JOIN "a57be577deb434"."tbl_suppliers" "s" ON pc.supplier_id = s.id LEFT JOIN "a57be577deb434"."tbl_purchase_invoice_projects" "pip" ON pci.id = pip.purchase_invoice_id LEFT JOIN "a57be577deb434"."tbl_projects" "p" ON p.id = pip.project_id LEFT JOIN "a57be577deb434"."tbl_clients" "c" ON p.client_id = c.id WHERE (LOWER(ip.description) = LOWER('*计算机配套产品*内存')) AND (LOWER(ip.title) = LOWER('16g')) AND ("ip"."inventory" > 0) GROUP BY "ip"."id", "pci"."id")
16:45:08.997infoyii\db\Command::querySELECT SUM(amount) FROM "a57be577deb434"."tbl_inventory_products" WHERE "id" IN (SELECT "ip"."id" FROM "a57be577deb434"."tbl_inventory_products" "ip" LEFT JOIN "a57be577deb434"."tbl_purchase_contract_invoices" "pci" ON ip.purchase_invoice_id = pci.id LEFT JOIN "a57be577deb434"."tbl_purchase_contracts" "pc" ON pc.id = pci.contract_id LEFT JOIN "a57be577deb434"."tbl_suppliers" "s" ON pc.supplier_id = s.id LEFT JOIN "a57be577deb434"."tbl_purchase_invoice_projects" "pip" ON pci.id = pip.purchase_invoice_id LEFT JOIN "a57be577deb434"."tbl_projects" "p" ON p.id = pip.project_id LEFT JOIN "a57be577deb434"."tbl_clients" "c" ON p.client_id = c.id WHERE (LOWER(ip.description) = LOWER('*计算机配套产品*内存')) AND (LOWER(ip.title) = LOWER('16g')) AND ("ip"."inventory" > 0) GROUP BY "ip"."id", "pci"."id")
16:45:08.999infoyii\db\Command::querySELECT COUNT(*) FROM "a57be577deb434"."tbl_inventory_products" WHERE ("id" IN (SELECT "ip"."id" FROM "a57be577deb434"."tbl_inventory_products" "ip" LEFT JOIN "a57be577deb434"."tbl_purchase_contract_invoices" "pci" ON ip.purchase_invoice_id = pci.id LEFT JOIN "a57be577deb434"."tbl_purchase_contracts" "pc" ON pc.id = pci.contract_id LEFT JOIN "a57be577deb434"."tbl_suppliers" "s" ON pc.supplier_id = s.id LEFT JOIN "a57be577deb434"."tbl_purchase_invoice_projects" "pip" ON pci.id = pip.purchase_invoice_id LEFT JOIN "a57be577deb434"."tbl_projects" "p" ON p.id = pip.project_id LEFT JOIN "a57be577deb434"."tbl_clients" "c" ON p.client_id = c.id WHERE (LOWER(ip.description) = LOWER('*计算机配套产品*内存')) AND (LOWER(ip.title) = LOWER('16g')) AND ("ip"."inventory" > 0) GROUP BY "ip"."id", "pci"."id")) AND (outbound > 0)
16:45:09.002infoyii\db\Command::querySELECT SUM(amount / number * outbound) FROM "a57be577deb434"."tbl_inventory_products" WHERE ("id" IN (SELECT "ip"."id" FROM "a57be577deb434"."tbl_inventory_products" "ip" LEFT JOIN "a57be577deb434"."tbl_purchase_contract_invoices" "pci" ON ip.purchase_invoice_id = pci.id LEFT JOIN "a57be577deb434"."tbl_purchase_contracts" "pc" ON pc.id = pci.contract_id LEFT JOIN "a57be577deb434"."tbl_suppliers" "s" ON pc.supplier_id = s.id LEFT JOIN "a57be577deb434"."tbl_purchase_invoice_projects" "pip" ON pci.id = pip.purchase_invoice_id LEFT JOIN "a57be577deb434"."tbl_projects" "p" ON p.id = pip.project_id LEFT JOIN "a57be577deb434"."tbl_clients" "c" ON p.client_id = c.id WHERE (LOWER(ip.description) = LOWER('*计算机配套产品*内存')) AND (LOWER(ip.title) = LOWER('16g')) AND ("ip"."inventory" > 0) GROUP BY "ip"."id", "pci"."id")) AND (outbound > 0)
16:45:09.004infoyii\db\Command::querySELECT COUNT(*) FROM "a57be577deb434"."tbl_inventory_products" WHERE ("id" IN (SELECT "ip"."id" FROM "a57be577deb434"."tbl_inventory_products" "ip" LEFT JOIN "a57be577deb434"."tbl_purchase_contract_invoices" "pci" ON ip.purchase_invoice_id = pci.id LEFT JOIN "a57be577deb434"."tbl_purchase_contracts" "pc" ON pc.id = pci.contract_id LEFT JOIN "a57be577deb434"."tbl_suppliers" "s" ON pc.supplier_id = s.id LEFT JOIN "a57be577deb434"."tbl_purchase_invoice_projects" "pip" ON pci.id = pip.purchase_invoice_id LEFT JOIN "a57be577deb434"."tbl_projects" "p" ON p.id = pip.project_id LEFT JOIN "a57be577deb434"."tbl_clients" "c" ON p.client_id = c.id WHERE (LOWER(ip.description) = LOWER('*计算机配套产品*内存')) AND (LOWER(ip.title) = LOWER('16g')) AND ("ip"."inventory" > 0) GROUP BY "ip"."id", "pci"."id")) AND (inventory > 0)
16:45:09.005infoyii\db\Command::querySELECT SUM(amount / number * inventory) FROM "a57be577deb434"."tbl_inventory_products" WHERE ("id" IN (SELECT "ip"."id" FROM "a57be577deb434"."tbl_inventory_products" "ip" LEFT JOIN "a57be577deb434"."tbl_purchase_contract_invoices" "pci" ON ip.purchase_invoice_id = pci.id LEFT JOIN "a57be577deb434"."tbl_purchase_contracts" "pc" ON pc.id = pci.contract_id LEFT JOIN "a57be577deb434"."tbl_suppliers" "s" ON pc.supplier_id = s.id LEFT JOIN "a57be577deb434"."tbl_purchase_invoice_projects" "pip" ON pci.id = pip.purchase_invoice_id LEFT JOIN "a57be577deb434"."tbl_projects" "p" ON p.id = pip.project_id LEFT JOIN "a57be577deb434"."tbl_clients" "c" ON p.client_id = c.id WHERE (LOWER(ip.description) = LOWER('*计算机配套产品*内存')) AND (LOWER(ip.title) = LOWER('16g')) AND ("ip"."inventory" > 0) GROUP BY "ip"."id", "pci"."id")) AND (inventory > 0)
16:45:09.007infoyii\db\Command::querySELECT SUM(excluding_tax) FROM "a57be577deb434"."tbl_inventory_products" WHERE "id" IN (SELECT "ip"."id" FROM "a57be577deb434"."tbl_inventory_products" "ip" LEFT JOIN "a57be577deb434"."tbl_purchase_contract_invoices" "pci" ON ip.purchase_invoice_id = pci.id LEFT JOIN "a57be577deb434"."tbl_purchase_contracts" "pc" ON pc.id = pci.contract_id LEFT JOIN "a57be577deb434"."tbl_suppliers" "s" ON pc.supplier_id = s.id LEFT JOIN "a57be577deb434"."tbl_purchase_invoice_projects" "pip" ON pci.id = pip.purchase_invoice_id LEFT JOIN "a57be577deb434"."tbl_projects" "p" ON p.id = pip.project_id LEFT JOIN "a57be577deb434"."tbl_clients" "c" ON p.client_id = c.id WHERE (LOWER(ip.description) = LOWER('*计算机配套产品*内存')) AND (LOWER(ip.title) = LOWER('16g')) AND ("ip"."inventory" > 0) GROUP BY "ip"."id", "pci"."id")
16:45:09.009infoyii\db\Command::querySELECT SUM(tax_amount) FROM "a57be577deb434"."tbl_inventory_products" WHERE "id" IN (SELECT "ip"."id" FROM "a57be577deb434"."tbl_inventory_products" "ip" LEFT JOIN "a57be577deb434"."tbl_purchase_contract_invoices" "pci" ON ip.purchase_invoice_id = pci.id LEFT JOIN "a57be577deb434"."tbl_purchase_contracts" "pc" ON pc.id = pci.contract_id LEFT JOIN "a57be577deb434"."tbl_suppliers" "s" ON pc.supplier_id = s.id LEFT JOIN "a57be577deb434"."tbl_purchase_invoice_projects" "pip" ON pci.id = pip.purchase_invoice_id LEFT JOIN "a57be577deb434"."tbl_projects" "p" ON p.id = pip.project_id LEFT JOIN "a57be577deb434"."tbl_clients" "c" ON p.client_id = c.id WHERE (LOWER(ip.description) = LOWER('*计算机配套产品*内存')) AND (LOWER(ip.title) = LOWER('16g')) AND ("ip"."inventory" > 0) GROUP BY "ip"."id", "pci"."id")
16:45:09.011traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
16:45:09.012traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
16:45:09.013traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
16:45:09.013traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
16:45:09.013infoyii\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:09.017traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
16:45:09.017traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
16:45:09.017infoyii\db\Command::executeUPDATE "a57be577deb434"."tbl_visit_module_histories" SET "num"=109, "last_visit_at"='now()' WHERE "id"=55336
16:45:09.018infoyii\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-list-match', '{"InventoryProductSearch":{"is_verify":"","is_build":"","description":"*\u8ba1\u7b97\u673a\u914d\u5957\u4ea7\u54c1*\u5185\u5b58","title":"16G","id":"2116"},"page":"1","web_access_token":"239qcuu_ToIhJtTt60gp-9_fllLTtTgq"}', '{"code":2000,"result":{"list":[{"id":1830,"purchase_invoice_id":2387,"purchase_product_id":1914,"title":"16g","description":"*\u8ba1\u7b97\u673a\u914d\u5957\u4ea7\u54c1*\u5185\u5b58","number":"2","unit":"\u6761","outbound":"0","inventory":"2","amount":"398.63","tax_rate":"1","including_tax":"0","excluding_tax":"394.68","tax_amount":"3.95","is_build":false,"build_group_id":"","created_at":"2025-08-04 11:52:07","purchaseInvoice":{"id":2387,"contract_id":4052,"amount":"398.63","attachment_id":"","from_date":"2025-08-01","created_by":5360,"created_at":"2025-08-04 11:50:15","description":"","invoice_num":"25342000000131931366","invoice_type":2,"handler":{"id":5360,"key":5360,"name":"\u5f20\u7ea2\u82b3","sex":"F","department_id":3},"is_verify":false,"is_cancel":false,"paid_amount":"0","tax_amount":3.95,"excluding_tax":394.68,"verify_at":"","is_used":false,"updated_at":"2025-08-04 11:52:07","cancel_description":"","cover_invoice_id":"","red_invoice_id":"","new_invoice_id":"","need_new_invoice":false,"is_draft":false,"is_settle":false,"supplier_id":608,"is_contract_cancel":false,"contract":{"id":4052,"key":4052,"serial_no":"\u8ba2\u5355\u53f7: 4643512058994592710\/4643515981688592710","supplier_id":608,"supplier":{"id":608,"key":608,"name":"\u6dd8\u5b9d\u7f51"}},"supplier":{"id":608,"key":608,"name":"\u6dd8\u5b9d\u7f51"},"purchaseInvoiceProjects":[{"id":2416,"purchase_invoice_id":2387,"project_id":3925,"project":{"id":3925,"key":3925,"name":"OTJ25076289-\u5185\u5b58\u6761-G-2025","client_id":12,"client":{"id":12,"key":12,"name":"smc(\u4e2d\u56fd)\u6709\u9650\u516c\u53f8\/SMC(\u5317\u4eac)\u5236\u9020\u6709\u9650\u516c\u53f8"}}},{"id":2417,"purchase_invoice_id":2387,"project_id":3924,"project":{"id":3924,"key":3924,"name":"OTJ25076163-\u56fa\u6001\u786c\u76d8-G-2025","client_id":12,"client":{"id":12,"key":12,"name":"smc(\u4e2d\u56fd)\u6709\u9650\u516c\u53f8\/SMC(\u5317\u4eac)\u5236\u9020\u6709\u9650\u516c\u53f8"}}}],"purchaseInvoiceReminders":[],"purchaseInvoiceProducts":[{"id":1914,"purchase_invoice_id":2387,"title":"16g","description":"*\u8ba1\u7b97\u673a\u914d\u5957\u4ea7\u54c1*\u5185\u5b58","number":"2","outbound":"0","inventory":"2","unit":"\u6761","amount":"398.63","tax_rate":"1","including_tax":"0","excluding_tax":"394.68","tax_amount":"3.95","into_inventory":true}],"invoice_type_display":"\u6570\u7535\u666e\u7968","including_tax":0,"number":2,"un_used_amount":398.63,"tax_rate":["1"]}},{"id":1829,"purchase_invoice_id":2386,"purchase_product_id":1913,"title":"16g","description":"*\u8ba1\u7b97\u673a\u914d\u5957\u4ea7\u54c1*\u5185\u5b58","number":"1","unit":"\u6761","outbound":"0","inventory":"1","amount":"197.75","tax_rate":"1","including_tax":"0","excluding_tax":"195.79","tax_amount":"1.96","is_build":false,"build_group_id":"","created_at":"2025-08-04 11:51:20","purchaseInvoice":{"id":2386,"contract_id":4045,"amount":"197.75","attachment_id":"","from_date":"2025-08-01","created_by":5360,"created_at":"2025-08-04 11:49:56","description":"","invoice_num":"25342000000131894984","invoice_type":2,"handler":{"id":5360,"key":5360,"name":"\u5f20\u7ea2\u82b3","sex":"F","department_id":3},"is_verify":false,"is_cancel":false,"paid_amount":"0","tax_amount":1.96,"excluding_tax":195.79,"verify_at":"","is_used":false,"updated_at":"2025-08-04 11:51:20","cancel_description":"","cover_invoice_id":"","red_invoice_id":"","new_invoice_id":"","need_new_invoice":false,"is_draft":false,"is_settle":false,"supplier_id":608,"is_contract_cancel":false,"contract":{"id":4045,"key":4045,"serial_no":"\u8ba2\u5355\u53f7: 4635961815999592710","supplier_id":608,"supplier":{"id":608,"key":608,"name":"\u6dd8\u5b9d\u7f51"}},"supplier":{"id":608,"key":608,"name":"\u6dd8\u5b9d\u7f51"},"purchaseInvoiceProjects":[{"id":2415,"purchase_invoice_id":2386,"project_id":3920,"project":{"id":3920,"key":3920,"name":"OTJ25075740-\u5185\u5b58-2025","client_id":12,"client":{"id":12,"key":12,"name":"smc(\u4e2d\u56fd)\u6709\u9650\u516c\u53f8\/SMC(\u5317\u4eac)\u5236\u9020\u6709\u9650\u516c\u53f8"}}}],"purchaseInvoiceReminders":[],"purchaseInvoiceProducts":[{"id":1913,"purchase_invoice_id":2386,"title":"16g","description":"*\u8ba1\u7b97\u673a\u914d\u5957\u4ea7\u54c1*\u5185\u5b58","number":"1","outbound":"0","inventory":"1","unit":"\u6761","amount":"197.75","tax_rate":"1","including_tax":"0","excluding_tax":"195.79","tax_amount":"1.96","into_inventory":true}],"invoice_type_display":"\u6570\u7535\u666e\u7968","including_tax":0,"number":1,"un_used_amount":197.75,"tax_rate":["1"]}}],"can_create":true,"count":{"count":2,"amount":"596.38","outbound_count":0,"outbound_amount":0,"inventory_count":2,"inventory_amount":"596.3800000000000000","excluding_tax":"590.47","tax_amount":"5.91"},"pagenation":{"totalcount":2,"thispage":1,"pagesize":20}},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}],"mod":0}', FALSE, '2025-08-19 16:45:09') RETURNING "id"
16:45:09.020traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
16:45:09.020traceyii\redis\Connection::executeCommandExecuting Redis Command: SET