ConfigurationRequestLogsProfilingDatabaseAsset BundlesMailTimeline
68c7ba410e6a5: POST https://beta.jinchangxiao.com/vue/erp-inventory-product/product-view-list at 2025-09-15 03:03:29 pm by 115.171.251.67

Log Messages

总计52条数据
TimeLevelCategoryMessage
 
15:03:29.058traceyii\base\Application::bootstrapBootstrap with yii\log\Dispatcher
15:03:29.058traceyii\base\Module::getModuleLoading module: debug
15:03:29.058traceyii\base\Application::bootstrapBootstrap with yii\debug\Module::bootstrap()
15:03:29.059traceyii\redis\Connection::openOpening redis DB connection: redis.server.local:6379, database=1
15:03:29.059traceyii\redis\Connection::executeCommandExecuting Redis Command: SELECT
15:03:29.059traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
15:03:29.059traceyii\base\Module::getModuleLoading module: gii
15:03:29.059traceyii\base\Application::bootstrapBootstrap with yii\gii\Module::bootstrap()
15:03:29.059traceyii\web\UrlManager::parseRequestNo matching URL rules. Using default URL parsing logic.
15:03:29.059traceyii\web\Application::handleRequestRoute requested: 'vue/erp-inventory-product/product-view-list'
15:03:29.059traceyii\base\Module::getModuleLoading module: vue
15:03:29.060infoyii\web\Session::openSession started
15:03:29.060infoyii\db\Command::querySELECT * FROM "global"."vw_user_login" WHERE "id"=5016
15:03:29.060infoyii\db\Connection::openOpening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta
15:03:29.064traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
15:03:29.065traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
15:03:29.065traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
15:03:29.065traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
15:03:29.065infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=5016
15:03:29.067traceyii\base\Controller::runActionRoute to run: vue/erp-inventory-product/product-view-list
15:03:29.067traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
15:03:29.068traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: Admin
15:03:29.068traceyii\base\InlineAction::runWithParamsRunning action: app\modules\vue\controllers\ErpInventoryProductController::actionProductViewList()
15:03:29.068traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
15:03:29.068traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
15:03:29.069infoyii\db\Command::querySELECT COUNT(*) FROM (SELECT * FROM ((SELECT * FROM (SELECT (r.id::varchar || 1::varchar) as id, r.id as id2, r.id as erp_purchase_inbound_id, r.supplier_id, null::integer as project_id, null::integer as client_id, r.wrote_date, r.serial_no, r.erp_store_id, 1 as ticket_type, '采购入库单' as ticket_type_display, r.abstract, r.description, r.created_by, r.amount, sum(eip.inventory) as inventory, sum(rp.number) as in_number, null::numeric as out_number, sum(rp.amount) as purchase_amount, sum(rp.total_amount) as purchase_total_amount, null::numeric as sales_amount, null::numeric as sales_total_amount, handler, string_agg(distinct s.title, ',') as store_title FROM "a57be577deb434"."tbl_erp_purchase_inbounds" "r" LEFT JOIN "a57be577deb434"."tbl_erp_purchase_inbound_products" "rp" ON rp.erp_purchase_inbound_id = r.id and rp.product_id = 1624 LEFT JOIN "a57be577deb434"."tbl_erp_inventory_products" "eip" ON eip.erp_purchase_inbound_product_id = rp.id LEFT JOIN "a57be577deb434"."tbl_erp_stores" "s" ON eip.erp_store_id = s.id WHERE ("rp"."product_id"='1624') AND ("status" IN (2, 5)) GROUP BY "r"."id") "sub") UNION ALL ( SELECT (r.id::varchar || 2::varchar) as id, r.id as id2, null::integer as erp_purchase_inbound_id, r.supplier_id, null::integer as project_id, null::integer as client_id, r.wrote_date, r.serial_no, r.erp_store_id, 2 as ticket_type, '采购退货单' as ticket_type_display, r.abstract, r.description, r.created_by, r.amount, null::numeric as inventory, null::numeric as in_number, sum(rp.number) as out_number, null::numeric as purchase_amount, null::numeric as purchase_total_amount, null::numeric as sales_amount, sum(rp.total_amount) as sales_total_amount, handler, string_agg(distinct s.title, ',') as store_title FROM "a57be577deb434"."tbl_erp_purchase_returns" "r" LEFT JOIN "a57be577deb434"."tbl_erp_purchase_return_products" "rp" ON rp.erp_purchase_return_id = r.id and rp.product_id = 1624 LEFT JOIN "a57be577deb434"."tbl_erp_purchase_inbound_products" "epip" ON epip.id = rp.erp_purchase_inbound_product_id LEFT JOIN "a57be577deb434"."tbl_erp_inventory_products" "eip" ON eip.erp_purchase_inbound_product_id = epip.id LEFT JOIN "a57be577deb434"."tbl_erp_stores" "s" ON eip.erp_store_id = s.id WHERE ("rp"."product_id"='1624') AND ("status" IN (2, 5)) GROUP BY "r"."id" ) UNION ALL ( SELECT (r.id::varchar || 4::varchar) as id, r.id as id2, null::integer as erp_purchase_inbound_id, null::integer as supplier_id, null::integer as project_id, null::integer as client_id, r.wrote_date, r.serial_no, r.erp_store_id, 4 as ticket_type, '报损单' as ticket_type_display, r.abstract, r.description, r.created_by, r.amount, null::numeric as inventory, null::numeric as in_number, sum(rp.number) as out_number, null::numeric as purchase_amount, null::numeric as purchase_total_amount, null::numeric as sales_amount, null::numeric as sales_total_amount, handler, string_agg(distinct s.title, ',') as store_title FROM "a57be577deb434"."tbl_erp_inventory_losts" "r" LEFT JOIN "a57be577deb434"."tbl_erp_inventory_lost_products" "rp" ON rp.erp_inventory_lost_id = r.id and rp.product_id = 1624 LEFT JOIN "a57be577deb434"."tbl_erp_inventory_products" "eip" ON eip.id = rp.erp_inventory_product_id LEFT JOIN "a57be577deb434"."tbl_erp_stores" "s" ON eip.erp_store_id = s.id WHERE ("rp"."product_id"='1624') AND ("status" IN (2, 5)) GROUP BY "r"."id" ) UNION ALL ( SELECT (r.id::varchar || 5::varchar) as id, r.id as id2, null::integer as erp_purchase_inbound_id, null::integer as supplier_id, null::integer as project_id, null::integer as client_id, r.wrote_date, r.serial_no, r.erp_store_id, 5 as ticket_type, '拆装单' as ticket_type_display, r.abstract, r.description, r.created_by, r.amount, sum(eip.inventory) as inventory, sum(eip.number) as in_number, sum(rp2.number) as out_number, sum(eip.amount) as purchase_amount, sum(eip.total_amount) as purchase_total_amount, null::numeric as sales_amount, sum(rp2.total_amount) as sales_total_amount, handler, string_agg(distinct s.title, ',') as store_title FROM "a57be577deb434"."tbl_erp_inventory_builds" "r" LEFT JOIN "a57be577deb434"."tbl_erp_inventory_build_products" "rp" ON rp.erp_inventory_build_id = r.id and rp.product_id = 1624 LEFT JOIN "a57be577deb434"."tbl_erp_inventory_build_spent_products" "rp2" ON rp2.erp_inventory_build_id = r.id and rp2.product_id = 1624 LEFT JOIN "a57be577deb434"."tbl_erp_inventory_products" "eip" ON eip.erp_inventory_build_product_id = rp.id LEFT JOIN "a57be577deb434"."tbl_erp_stores" "s" ON eip.erp_store_id = s.id WHERE (("rp"."product_id"='1624') OR ("rp2"."product_id"='1624')) AND ("status" IN (2, 5)) GROUP BY "r"."id" ) UNION ALL ( SELECT (r.id::varchar || 6::varchar) as id, r.id as id2, null::integer as erp_purchase_inbound_id, r.supplier_id, null::integer as project_id, null::integer as client_id, r.wrote_date, r.serial_no, r.erp_store_id, 6 as ticket_type, '期初库存' as ticket_type_display, r.abstract, r.description, r.created_by, r.amount, sum(eip.inventory) as inventory, sum(rp.number) as in_number, null::numeric as out_number, sum(rp.amount) as purchase_amount, sum(rp.total_amount) as purchase_total_amount, null::numeric as sales_amount, null::numeric as sales_total_amount, handler, string_agg(distinct s.title, ',') as store_title FROM "a57be577deb434"."tbl_erp_inventory_starts" "r" LEFT JOIN "a57be577deb434"."tbl_erp_inventory_start_products" "rp" ON rp.erp_inventory_start_id = r.id and rp.product_id = 1624 LEFT JOIN "a57be577deb434"."tbl_erp_inventory_products" "eip" ON eip.erp_inventory_start_product_id = rp.id LEFT JOIN "a57be577deb434"."tbl_erp_stores" "s" ON eip.erp_store_id = s.id WHERE "rp"."product_id"='1624' GROUP BY "r"."id" ) UNION ALL ( SELECT (r.id::varchar || 8::varchar) as id, r.id as id2, null::integer as erp_purchase_inbound_id, null::integer as supplier_id, r.project_id, r.client_id, r.wrote_date, r.serial_no, r.erp_store_id, 8 as ticket_type, '销售出库单' as ticket_type_display, r.abstract, r.description, r.created_by, r.amount, null::numeric as inventory, sum(rp.cancel_number) as in_number, sum(rp.number) as out_number, sum(rp.cancel_number * rp.amount) as purchase_amount, sum(rp.cancel_number * rp.amount) as purchase_total_amount, null::numeric as sales_amount, sum(rp.total_amount) as sales_total_amount, handler, string_agg(distinct s.title, ',') as store_title FROM "a57be577deb434"."tbl_erp_sales_outbounds" "r" LEFT JOIN "a57be577deb434"."tbl_erp_sales_outbound_spent_products" "rp" ON rp.erp_sales_outbound_id = r.id and rp.product_id = 1624 LEFT JOIN "a57be577deb434"."tbl_erp_inventory_products" "eip" ON eip.id = rp.erp_inventory_product_id LEFT JOIN "a57be577deb434"."tbl_erp_stores" "s" ON eip.erp_store_id = s.id WHERE ("rp"."product_id"='1624') AND ("status" IN (2, 5)) GROUP BY "r"."id" ) UNION ALL ( SELECT (r.id::varchar || 9::varchar) as id, r.id as id2, null::integer as erp_purchase_inbound_id, null::integer as supplier_id, r.project_id, r.client_id, r.wrote_date, r.serial_no, r.erp_store_id, 9 as ticket_type, '销售退货单' as ticket_type_display, r.abstract, r.description, r.created_by, r.amount, null::numeric as inventory, sum(rp.number) as in_number, null::numeric as out_number, sum(rp.total_amount) as purchase_amount, sum(rp.total_amount) as purchase_total_amount, null::numeric as sales_amount, null::numeric as sales_total_amount, handler, string_agg(distinct s.title, ',') as store_title FROM "a57be577deb434"."tbl_erp_sales_returns" "r" LEFT JOIN "a57be577deb434"."tbl_erp_sales_return_products" "rp" ON rp.erp_sales_return_id = r.id and rp.product_id = 1624 LEFT JOIN "a57be577deb434"."tbl_erp_sales_outbound_spent_products" "rp2" ON rp.erp_sales_outbound_spent_product_id = rp2.id LEFT JOIN "a57be577deb434"."tbl_erp_inventory_products" "eip" ON eip.id = rp2.erp_inventory_product_id LEFT JOIN "a57be577deb434"."tbl_erp_stores" "s" ON eip.erp_store_id = s.id WHERE ("rp"."product_id"='1624') AND ("status" IN (2, 5)) GROUP BY "r"."id" ) UNION ALL ( SELECT (r.id::varchar || 10::varchar) as id, r.id as id2, r.id as erp_purchase_gift_id, r.supplier_id, null::integer as project_id, null::integer as client_id, r.wrote_date, r.serial_no, r.erp_store_id, 10 as ticket_type, '获赠单' as ticket_type_display, r.abstract, r.description, r.created_by, r.amount, sum(eip.inventory) as inventory, sum(eip.number) as in_number, null::numeric as out_number, sum(eip.amount) as purchase_amount, sum(eip.total_amount) as purchase_total_amount, null::numeric as sales_amount, null::numeric as sales_total_amount, handler, string_agg(distinct s.title, ',') as store_title FROM "a57be577deb434"."tbl_erp_purchase_gifts" "r" LEFT JOIN "a57be577deb434"."tbl_erp_purchase_gift_products" "rp" ON rp.erp_purchase_gift_id = r.id and rp.product_id = 1624 LEFT JOIN "a57be577deb434"."tbl_erp_inventory_products" "eip" ON eip.erp_purchase_gift_product_id = rp.id LEFT JOIN "a57be577deb434"."tbl_erp_stores" "s" ON eip.erp_store_id = s.id WHERE ("rp"."product_id"='1624') AND ("status" IN (2, 5)) GROUP BY "r"."id" ) UNION ALL ( SELECT (r.id::varchar || 11::varchar) as id, r.id as id2, null::integer as erp_purchase_inbound_id, null::integer as supplier_id, r.project_id, r.client_id, r.wrote_date, r.serial_no, r.erp_store_id, 11 as ticket_type, '赠送单' as ticket_type_display, r.abstract, r.description, r.created_by, r.amount, null::numeric as inventory, null::numeric as in_number, sum(rp.number) as out_number, null::numeric as purchase_amount, null::numeric as purchase_total_amount, null::numeric as sales_amount, null::numeric as sales_total_amount, handler, string_agg(distinct s.title, ',') as store_title FROM "a57be577deb434"."tbl_erp_sales_gifts" "r" LEFT JOIN "a57be577deb434"."tbl_erp_sales_gift_spent_products" "rp" ON rp.erp_sales_gift_id = r.id and rp.product_id = 1624 LEFT JOIN "a57be577deb434"."tbl_erp_inventory_products" "eip" ON eip.id = rp.erp_inventory_product_id LEFT JOIN "a57be577deb434"."tbl_erp_stores" "s" ON eip.erp_store_id = s.id WHERE ("rp"."product_id"='1624') AND ("status" IN (2, 5)) GROUP BY "r"."id" )) "sub" ORDER BY wrote_date DESC) "c"
15:03:29.081infoyii\db\Command::querySELECT * FROM ((SELECT * FROM (SELECT (r.id::varchar || 1::varchar) as id, r.id as id2, r.id as erp_purchase_inbound_id, r.supplier_id, null::integer as project_id, null::integer as client_id, r.wrote_date, r.serial_no, r.erp_store_id, 1 as ticket_type, '采购入库单' as ticket_type_display, r.abstract, r.description, r.created_by, r.amount, sum(eip.inventory) as inventory, sum(rp.number) as in_number, null::numeric as out_number, sum(rp.amount) as purchase_amount, sum(rp.total_amount) as purchase_total_amount, null::numeric as sales_amount, null::numeric as sales_total_amount, handler, string_agg(distinct s.title, ',') as store_title FROM "a57be577deb434"."tbl_erp_purchase_inbounds" "r" LEFT JOIN "a57be577deb434"."tbl_erp_purchase_inbound_products" "rp" ON rp.erp_purchase_inbound_id = r.id and rp.product_id = 1624 LEFT JOIN "a57be577deb434"."tbl_erp_inventory_products" "eip" ON eip.erp_purchase_inbound_product_id = rp.id LEFT JOIN "a57be577deb434"."tbl_erp_stores" "s" ON eip.erp_store_id = s.id WHERE ("rp"."product_id"='1624') AND ("status" IN (2, 5)) GROUP BY "r"."id") "sub") UNION ALL ( SELECT (r.id::varchar || 2::varchar) as id, r.id as id2, null::integer as erp_purchase_inbound_id, r.supplier_id, null::integer as project_id, null::integer as client_id, r.wrote_date, r.serial_no, r.erp_store_id, 2 as ticket_type, '采购退货单' as ticket_type_display, r.abstract, r.description, r.created_by, r.amount, null::numeric as inventory, null::numeric as in_number, sum(rp.number) as out_number, null::numeric as purchase_amount, null::numeric as purchase_total_amount, null::numeric as sales_amount, sum(rp.total_amount) as sales_total_amount, handler, string_agg(distinct s.title, ',') as store_title FROM "a57be577deb434"."tbl_erp_purchase_returns" "r" LEFT JOIN "a57be577deb434"."tbl_erp_purchase_return_products" "rp" ON rp.erp_purchase_return_id = r.id and rp.product_id = 1624 LEFT JOIN "a57be577deb434"."tbl_erp_purchase_inbound_products" "epip" ON epip.id = rp.erp_purchase_inbound_product_id LEFT JOIN "a57be577deb434"."tbl_erp_inventory_products" "eip" ON eip.erp_purchase_inbound_product_id = epip.id LEFT JOIN "a57be577deb434"."tbl_erp_stores" "s" ON eip.erp_store_id = s.id WHERE ("rp"."product_id"='1624') AND ("status" IN (2, 5)) GROUP BY "r"."id" ) UNION ALL ( SELECT (r.id::varchar || 4::varchar) as id, r.id as id2, null::integer as erp_purchase_inbound_id, null::integer as supplier_id, null::integer as project_id, null::integer as client_id, r.wrote_date, r.serial_no, r.erp_store_id, 4 as ticket_type, '报损单' as ticket_type_display, r.abstract, r.description, r.created_by, r.amount, null::numeric as inventory, null::numeric as in_number, sum(rp.number) as out_number, null::numeric as purchase_amount, null::numeric as purchase_total_amount, null::numeric as sales_amount, null::numeric as sales_total_amount, handler, string_agg(distinct s.title, ',') as store_title FROM "a57be577deb434"."tbl_erp_inventory_losts" "r" LEFT JOIN "a57be577deb434"."tbl_erp_inventory_lost_products" "rp" ON rp.erp_inventory_lost_id = r.id and rp.product_id = 1624 LEFT JOIN "a57be577deb434"."tbl_erp_inventory_products" "eip" ON eip.id = rp.erp_inventory_product_id LEFT JOIN "a57be577deb434"."tbl_erp_stores" "s" ON eip.erp_store_id = s.id WHERE ("rp"."product_id"='1624') AND ("status" IN (2, 5)) GROUP BY "r"."id" ) UNION ALL ( SELECT (r.id::varchar || 5::varchar) as id, r.id as id2, null::integer as erp_purchase_inbound_id, null::integer as supplier_id, null::integer as project_id, null::integer as client_id, r.wrote_date, r.serial_no, r.erp_store_id, 5 as ticket_type, '拆装单' as ticket_type_display, r.abstract, r.description, r.created_by, r.amount, sum(eip.inventory) as inventory, sum(eip.number) as in_number, sum(rp2.number) as out_number, sum(eip.amount) as purchase_amount, sum(eip.total_amount) as purchase_total_amount, null::numeric as sales_amount, sum(rp2.total_amount) as sales_total_amount, handler, string_agg(distinct s.title, ',') as store_title FROM "a57be577deb434"."tbl_erp_inventory_builds" "r" LEFT JOIN "a57be577deb434"."tbl_erp_inventory_build_products" "rp" ON rp.erp_inventory_build_id = r.id and rp.product_id = 1624 LEFT JOIN "a57be577deb434"."tbl_erp_inventory_build_spent_products" "rp2" ON rp2.erp_inventory_build_id = r.id and rp2.product_id = 1624 LEFT JOIN "a57be577deb434"."tbl_erp_inventory_products" "eip" ON eip.erp_inventory_build_product_id = rp.id LEFT JOIN "a57be577deb434"."tbl_erp_stores" "s" ON eip.erp_store_id = s.id WHERE (("rp"."product_id"='1624') OR ("rp2"."product_id"='1624')) AND ("status" IN (2, 5)) GROUP BY "r"."id" ) UNION ALL ( SELECT (r.id::varchar || 6::varchar) as id, r.id as id2, null::integer as erp_purchase_inbound_id, r.supplier_id, null::integer as project_id, null::integer as client_id, r.wrote_date, r.serial_no, r.erp_store_id, 6 as ticket_type, '期初库存' as ticket_type_display, r.abstract, r.description, r.created_by, r.amount, sum(eip.inventory) as inventory, sum(rp.number) as in_number, null::numeric as out_number, sum(rp.amount) as purchase_amount, sum(rp.total_amount) as purchase_total_amount, null::numeric as sales_amount, null::numeric as sales_total_amount, handler, string_agg(distinct s.title, ',') as store_title FROM "a57be577deb434"."tbl_erp_inventory_starts" "r" LEFT JOIN "a57be577deb434"."tbl_erp_inventory_start_products" "rp" ON rp.erp_inventory_start_id = r.id and rp.product_id = 1624 LEFT JOIN "a57be577deb434"."tbl_erp_inventory_products" "eip" ON eip.erp_inventory_start_product_id = rp.id LEFT JOIN "a57be577deb434"."tbl_erp_stores" "s" ON eip.erp_store_id = s.id WHERE "rp"."product_id"='1624' GROUP BY "r"."id" ) UNION ALL ( SELECT (r.id::varchar || 8::varchar) as id, r.id as id2, null::integer as erp_purchase_inbound_id, null::integer as supplier_id, r.project_id, r.client_id, r.wrote_date, r.serial_no, r.erp_store_id, 8 as ticket_type, '销售出库单' as ticket_type_display, r.abstract, r.description, r.created_by, r.amount, null::numeric as inventory, sum(rp.cancel_number) as in_number, sum(rp.number) as out_number, sum(rp.cancel_number * rp.amount) as purchase_amount, sum(rp.cancel_number * rp.amount) as purchase_total_amount, null::numeric as sales_amount, sum(rp.total_amount) as sales_total_amount, handler, string_agg(distinct s.title, ',') as store_title FROM "a57be577deb434"."tbl_erp_sales_outbounds" "r" LEFT JOIN "a57be577deb434"."tbl_erp_sales_outbound_spent_products" "rp" ON rp.erp_sales_outbound_id = r.id and rp.product_id = 1624 LEFT JOIN "a57be577deb434"."tbl_erp_inventory_products" "eip" ON eip.id = rp.erp_inventory_product_id LEFT JOIN "a57be577deb434"."tbl_erp_stores" "s" ON eip.erp_store_id = s.id WHERE ("rp"."product_id"='1624') AND ("status" IN (2, 5)) GROUP BY "r"."id" ) UNION ALL ( SELECT (r.id::varchar || 9::varchar) as id, r.id as id2, null::integer as erp_purchase_inbound_id, null::integer as supplier_id, r.project_id, r.client_id, r.wrote_date, r.serial_no, r.erp_store_id, 9 as ticket_type, '销售退货单' as ticket_type_display, r.abstract, r.description, r.created_by, r.amount, null::numeric as inventory, sum(rp.number) as in_number, null::numeric as out_number, sum(rp.total_amount) as purchase_amount, sum(rp.total_amount) as purchase_total_amount, null::numeric as sales_amount, null::numeric as sales_total_amount, handler, string_agg(distinct s.title, ',') as store_title FROM "a57be577deb434"."tbl_erp_sales_returns" "r" LEFT JOIN "a57be577deb434"."tbl_erp_sales_return_products" "rp" ON rp.erp_sales_return_id = r.id and rp.product_id = 1624 LEFT JOIN "a57be577deb434"."tbl_erp_sales_outbound_spent_products" "rp2" ON rp.erp_sales_outbound_spent_product_id = rp2.id LEFT JOIN "a57be577deb434"."tbl_erp_inventory_products" "eip" ON eip.id = rp2.erp_inventory_product_id LEFT JOIN "a57be577deb434"."tbl_erp_stores" "s" ON eip.erp_store_id = s.id WHERE ("rp"."product_id"='1624') AND ("status" IN (2, 5)) GROUP BY "r"."id" ) UNION ALL ( SELECT (r.id::varchar || 10::varchar) as id, r.id as id2, r.id as erp_purchase_gift_id, r.supplier_id, null::integer as project_id, null::integer as client_id, r.wrote_date, r.serial_no, r.erp_store_id, 10 as ticket_type, '获赠单' as ticket_type_display, r.abstract, r.description, r.created_by, r.amount, sum(eip.inventory) as inventory, sum(eip.number) as in_number, null::numeric as out_number, sum(eip.amount) as purchase_amount, sum(eip.total_amount) as purchase_total_amount, null::numeric as sales_amount, null::numeric as sales_total_amount, handler, string_agg(distinct s.title, ',') as store_title FROM "a57be577deb434"."tbl_erp_purchase_gifts" "r" LEFT JOIN "a57be577deb434"."tbl_erp_purchase_gift_products" "rp" ON rp.erp_purchase_gift_id = r.id and rp.product_id = 1624 LEFT JOIN "a57be577deb434"."tbl_erp_inventory_products" "eip" ON eip.erp_purchase_gift_product_id = rp.id LEFT JOIN "a57be577deb434"."tbl_erp_stores" "s" ON eip.erp_store_id = s.id WHERE ("rp"."product_id"='1624') AND ("status" IN (2, 5)) GROUP BY "r"."id" ) UNION ALL ( SELECT (r.id::varchar || 11::varchar) as id, r.id as id2, null::integer as erp_purchase_inbound_id, null::integer as supplier_id, r.project_id, r.client_id, r.wrote_date, r.serial_no, r.erp_store_id, 11 as ticket_type, '赠送单' as ticket_type_display, r.abstract, r.description, r.created_by, r.amount, null::numeric as inventory, null::numeric as in_number, sum(rp.number) as out_number, null::numeric as purchase_amount, null::numeric as purchase_total_amount, null::numeric as sales_amount, null::numeric as sales_total_amount, handler, string_agg(distinct s.title, ',') as store_title FROM "a57be577deb434"."tbl_erp_sales_gifts" "r" LEFT JOIN "a57be577deb434"."tbl_erp_sales_gift_spent_products" "rp" ON rp.erp_sales_gift_id = r.id and rp.product_id = 1624 LEFT JOIN "a57be577deb434"."tbl_erp_inventory_products" "eip" ON eip.id = rp.erp_inventory_product_id LEFT JOIN "a57be577deb434"."tbl_erp_stores" "s" ON eip.erp_store_id = s.id WHERE ("rp"."product_id"='1624') AND ("status" IN (2, 5)) GROUP BY "r"."id" )) "sub" ORDER BY wrote_date DESC LIMIT 20
15:03:29.090infoyii\db\Command::querySELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (1001, 1011)
15:03:29.090infoyii\db\Command::querySELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id" IN (1011, 1001))
15:03:29.091infoyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_departments" WHERE "id" IN (3, 4)
15:03:29.091infoyii\db\Command::querySELECT "id", "id" AS "key", "title" AS "name" FROM "a57be577deb434"."tbl_erp_stores" WHERE "id"=1
15:03:29.092infoyii\db\Command::querySELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (1001, 1011)
15:03:29.092infoyii\db\Command::querySELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id" IN (1011, 1001))
15:03:29.092infoyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_departments" WHERE "id" IN (3, 4)
15:03:29.092infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_purchase_inbound_projects" WHERE "erp_purchase_inbound_id"=31
15:03:29.093infoyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_clients" WHERE "id"=3286
15:03:29.093infoyii\db\Command::querySELECT "id", "id" AS "key", "project_title" AS "name", "project_status", "created_by" FROM "a57be577deb434"."tbl_projects" WHERE "id"=3927
15:03:29.094infoyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_suppliers" WHERE "id"=90
15:03:29.095infoyii\db\Command::querySELECT "id", "id" AS "key", "name", "sales_rep" FROM "a57be577deb434"."tbl_clients" WHERE "id"=3286
15:03:29.095infoyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
15:03:29.096infoyii\db\Command::querySELECT "id", "id" AS "key", "project_title" AS "name", "bargain_date" FROM "a57be577deb434"."tbl_projects" WHERE "id"=3927
15:03:29.096traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
15:03:29.097traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
15:03:29.098traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
15:03:29.098traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
15:03:29.098infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_visit_module_histories" WHERE ("user_id"=5016) AND ("object_type"=20000) AND ("visit_date"='2025-09-15')
15:03:29.102traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
15:03:29.102traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
15:03:29.102infoyii\db\Command::executeUPDATE "a57be577deb434"."tbl_visit_module_histories" SET "num"=105, "last_visit_at"='now()' WHERE "id"=56565
15:03:29.103infoyii\db\Command::queryINSERT INTO "global"."tbl_api_log" ("code", "schema", "user_id", "device_type", "url", "request", "response", "php_error", "time") VALUES (200, 'a57be577deb434', 5016, 5, 'vue/erp-inventory-product/product-view-list', '{"id":"1624","page":"1","Filter":{"sort":"","name":""},"web_access_token":"zACaxwY58DCRigSw1MlM3KllVvnv2n5E"}', '{"code":2000,"result":{"list":[{"id":"29","id2":2,"erp_purchase_inbound_id":"","supplier_id":"","project_id":3927,"client_id":3286,"wrote_date":"2025-09-04","serial_no":"XSTHD-20250904-00001","erp_store_id":"","ticket_type":9,"ticket_type_display":"\u9500\u552e\u9000\u8d27\u5355","abstract":"","description":"","created_by":1001,"amount":"1516","inventory":"","in_number":"1","out_number":"","purchase_amount":1516,"purchase_total_amount":"1516","sales_amount":"","sales_total_amount":"","handler":1001,"store_title":"\u62d3\u5b9e\u4ed3\u5e93","createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4,"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"},"department":{"id":4,"key":4,"name":"\u603b\u7ecf\u7406"}},"erpStore":"","handlerPerson":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4,"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"},"department":{"id":4,"key":4,"name":"\u603b\u7ecf\u7406"}},"erpPurchaseInboundProjects":[],"supplier":{},"client":{"id":3286,"key":3286,"name":"\u826f\u56fe\u79d1\u6280\uff08\u4e0a\u6d77\uff09\u6709\u9650\u516c\u53f8","sales_rep":1001,"salesRep":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda"}},"project":{"id":3927,"key":3927,"name":"PA VM\u9632\u706b\u5899\u7ef4\u4fdd\u7eed\u7ea6","bargain_date":"2025-08-22"},"in_time":""},{"id":"311","id2":31,"erp_purchase_inbound_id":31,"supplier_id":90,"project_id":"","client_id":"","wrote_date":"2025-08-28","serial_no":"CGRK-20250828-00001","erp_store_id":1,"ticket_type":1,"ticket_type_display":"\u91c7\u8d2d\u5165\u5e93\u5355","abstract":"\u542b\u7a0e13%","description":"","created_by":1011,"amount":"19502","inventory":"1","in_number":"14","out_number":"","purchase_amount":1393,"purchase_total_amount":"19502","sales_amount":"","sales_total_amount":"","handler":1011,"store_title":"\u62d3\u5b9e\u4ed3\u5e93","createdBy":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","department_id":3,"avatar":{"id":17,"user_id":1011,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b54747f4-248d-380e-93bc-0f62f769e70d.png"},"department":{"id":3,"key":3,"name":"\u5546\u52a1\u90e8"}},"erpStore":{"id":1,"key":1,"name":"\u62d3\u5b9e\u4ed3\u5e93"},"handlerPerson":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","department_id":3,"avatar":{"id":17,"user_id":1011,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b54747f4-248d-380e-93bc-0f62f769e70d.png"},"department":{"id":3,"key":3,"name":"\u5546\u52a1\u90e8"}},"erpPurchaseInboundProjects":[{"id":33,"erp_purchase_inbound_id":31,"client_id":3286,"project_id":3927,"client":{"id":3286,"key":3286,"name":"\u826f\u56fe\u79d1\u6280\uff08\u4e0a\u6d77\uff09\u6709\u9650\u516c\u53f8"},"project":{"id":3927,"key":3927,"name":"PA VM\u9632\u706b\u5899\u7ef4\u4fdd\u7eed\u7ea6","project_status":3,"created_by":1001}}],"supplier":{"id":90,"key":90,"name":"\u7d2b\u5149\u6653\u901a\u79d1\u6280\u6709\u9650\u516c\u53f8"},"client":{},"project":{},"in_time":19},{"id":"178","id2":17,"erp_purchase_inbound_id":"","supplier_id":"","project_id":3927,"client_id":3286,"wrote_date":"2025-08-28","serial_no":"XSCKD-20250828-00001","erp_store_id":1,"ticket_type":8,"ticket_type_display":"\u9500\u552e\u51fa\u5e93\u5355","abstract":"\u542b\u7a0e","description":"","created_by":1011,"amount":"21224","inventory":"","in_number":"1","out_number":"14","purchase_amount":1516,"purchase_total_amount":"1516","sales_amount":"","sales_total_amount":"21224","handler":1001,"store_title":"\u62d3\u5b9e\u4ed3\u5e93","createdBy":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","department_id":3,"avatar":{"id":17,"user_id":1011,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b54747f4-248d-380e-93bc-0f62f769e70d.png"},"department":{"id":3,"key":3,"name":"\u5546\u52a1\u90e8"}},"erpStore":{"id":1,"key":1,"name":"\u62d3\u5b9e\u4ed3\u5e93"},"handlerPerson":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4,"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"},"department":{"id":4,"key":4,"name":"\u603b\u7ecf\u7406"}},"erpPurchaseInboundProjects":[],"supplier":{},"client":{"id":3286,"key":3286,"name":"\u826f\u56fe\u79d1\u6280\uff08\u4e0a\u6d77\uff09\u6709\u9650\u516c\u53f8","sales_rep":1001,"salesRep":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda"}},"project":{"id":3927,"key":3927,"name":"PA VM\u9632\u706b\u5899\u7ef4\u4fdd\u7eed\u7ea6","bargain_date":"2025-08-22"},"in_time":""}],"pagenation":{"totalcount":3,"thispage":1,"pagesize":20}},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}],"mod":0}', FALSE, '2025-09-15 15:03:29') RETURNING "id"
15:03:29.105traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
15:03:29.105traceyii\redis\Connection::executeCommandExecuting Redis Command: SET