ConfigurationRequestLogsProfilingDatabaseAsset BundlesMailTimeline
68d3bf1e88ce0: POST https://beta.jinchangxiao.com/vue/erp-wage-analysis/in-out-view-out-list at 2025-09-24 05:51:26 pm by 221.216.117.180

Log Messages

总计41条数据
TimeLevelCategoryMessage
 
17:51:26.559traceyii\base\Application::bootstrapBootstrap with yii\log\Dispatcher
17:51:26.559traceyii\base\Module::getModuleLoading module: debug
17:51:26.560traceyii\base\Application::bootstrapBootstrap with yii\debug\Module::bootstrap()
17:51:26.560traceyii\redis\Connection::openOpening redis DB connection: redis.server.local:6379, database=1
17:51:26.560traceyii\redis\Connection::executeCommandExecuting Redis Command: SELECT
17:51:26.560traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
17:51:26.560traceyii\base\Module::getModuleLoading module: gii
17:51:26.560traceyii\base\Application::bootstrapBootstrap with yii\gii\Module::bootstrap()
17:51:26.561traceyii\web\UrlManager::parseRequestNo matching URL rules. Using default URL parsing logic.
17:51:26.561traceyii\web\Application::handleRequestRoute requested: 'vue/erp-wage-analysis/in-out-view-out-list'
17:51:26.561traceyii\base\Module::getModuleLoading module: vue
17:51:26.561infoyii\web\Session::openSession started
17:51:26.561infoyii\db\Command::querySELECT * FROM "global"."vw_user_login" WHERE "id"=5064
17:51:26.561infoyii\db\Connection::openOpening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta
17:51:26.566traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
17:51:26.566traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
17:51:26.566traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
17:51:26.567traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
17:51:26.567infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=5064
17:51:26.568traceyii\base\Controller::runActionRoute to run: vue/erp-wage-analysis/in-out-view-out-list
17:51:26.569traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
17:51:26.569traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: Admin
17:51:26.569traceyii\base\InlineAction::runWithParamsRunning action: app\modules\vue\controllers\ErpWageAnalysisController::actionInOutViewOutList()
17:51:26.571infoyii\db\Command::querySELECT COUNT(*) FROM (SELECT * FROM ((SELECT (r.id::varchar || 20018::varchar) as id, r.id as id2, r.supplier_id as supplier_id, r.client_id as client_id, null::integer as user_id, null::integer as contact_id, null::integer as project_id, r.sales_contract_id as sales_contract_id, r.purchase_contract_id as purchase_contract_id, r.wrote_date, r.serial_no, 20018 as ticket_type, r.abstract, r.description, r.created_by, am.user_id as handler, am.amount, r.status, r.settle_amount, r.is_payment_settle, r.created_at FROM "a57be577deb434"."tbl_erp_cash_cost_tickets" "r" LEFT JOIN "a57be577deb434"."tbl_erp_cash_cost_ticket_handlers" "am" ON am.erp_cash_cost_ticket_id = r.id LEFT JOIN "a57be577deb434"."tbl_sales_contracts" "sc" ON sc.id = r.sales_contract_id WHERE ("r"."status"=2) AND ("am"."user_id"='1001') AND (am.user_id is not null) AND (("sc"."from_project" NOT IN (SELECT t.project_id FROM "a57be577deb434"."tbl_erp_profit_distributes" "t" WHERE ("t"."status"=2) AND (t.project_id IS NOT NULL) GROUP BY "t"."project_id")) OR (sales_contract_id is null))) UNION ALL ( SELECT (r.id::varchar || 20018::varchar) as id, r.id as id2, r.supplier_id as supplier_id, r.client_id as client_id, null::integer as user_id, null::integer as contact_id, null::integer as project_id, r.sales_contract_id as sales_contract_id, r.purchase_contract_id as purchase_contract_id, r.wrote_date, r.serial_no, 20018 as ticket_type, r.abstract, r.description, r.created_by, am.user_id as handler, r.amount * am.pct as amount, r.status, r.settle_amount, r.is_payment_settle, r.created_at FROM "a57be577deb434"."tbl_erp_cash_cost_tickets" "r" LEFT JOIN "a57be577deb434"."tbl_sales_contracts" "sc" ON sc.id = r.sales_contract_id LEFT JOIN "a57be577deb434"."tbl_erp_profit_distributes" "pd" ON pd.project_id = sc.from_project LEFT JOIN "a57be577deb434"."tbl_erp_profit_distribute_pcts" "am" ON am.erp_profit_distribute_id = pd.id WHERE ("r"."status"=2) AND ("am"."user_id"='1001') AND (am.user_id is not null) AND ("sc"."from_project" IN (SELECT t.project_id FROM "a57be577deb434"."tbl_erp_profit_distributes" "t" WHERE ("t"."status"=2) AND (t.project_id IS NOT NULL) GROUP BY "t"."project_id")) ) UNION ALL ( SELECT (r.id::varchar || 20014::varchar) as id, r.id as id2, r.supplier_id as supplier_id, r.client_id as client_id, null::integer as user_id, null::integer as contact_id, r.project_id as project_id, r.sales_contract_id as sales_contract_id, r.purchase_contract_id as purchase_contract_id, r.wrote_date, r.serial_no, 20014 as ticket_type, r.abstract, r.description, r.created_by, am.user_id as handler, am.amount, r.status, r.settle_amount, false as is_payment_settle, r.created_at FROM "a57be577deb434"."tbl_erp_cost_tickets" "r" LEFT JOIN "a57be577deb434"."tbl_erp_cost_ticket_handlers" "am" ON am.erp_cost_ticket_id = r.id LEFT JOIN "a57be577deb434"."tbl_sales_contracts" "sc" ON sc.id = r.sales_contract_id WHERE ("r"."status"=2) AND ("am"."user_id"='1001') AND (am.user_id is not null) AND (("sc"."from_project" NOT IN (SELECT t.project_id FROM "a57be577deb434"."tbl_erp_profit_distributes" "t" WHERE ("t"."status"=2) AND (t.project_id IS NOT NULL) GROUP BY "t"."project_id")) OR (sales_contract_id is null)) ) UNION ALL ( SELECT (r.id::varchar || 20014::varchar) as id, r.id as id2, r.supplier_id as supplier_id, r.client_id as client_id, null::integer as user_id, null::integer as contact_id, r.project_id as project_id, r.sales_contract_id as sales_contract_id, r.purchase_contract_id as purchase_contract_id, r.wrote_date, r.serial_no, 20014 as ticket_type, r.abstract, r.description, r.created_by, am.user_id as handler, r.amount * am.pct as amount, r.status, r.settle_amount, false as is_payment_settle, r.created_at FROM "a57be577deb434"."tbl_erp_cost_tickets" "r" LEFT JOIN "a57be577deb434"."tbl_sales_contracts" "sc" ON sc.id = r.sales_contract_id LEFT JOIN "a57be577deb434"."tbl_erp_profit_distributes" "pd" ON pd.project_id = sc.from_project LEFT JOIN "a57be577deb434"."tbl_erp_profit_distribute_pcts" "am" ON am.erp_profit_distribute_id = pd.id WHERE ("r"."status"=2) AND ("am"."user_id"='1001') AND (am.user_id is not null) AND ("sc"."from_project" IN (SELECT t.project_id FROM "a57be577deb434"."tbl_erp_profit_distributes" "t" WHERE ("t"."status"=2) AND (t.project_id IS NOT NULL) GROUP BY "t"."project_id")) ) UNION ALL ( SELECT (r.id::varchar || 20016::varchar) as id, r.id as id2, null::integer as supplier_id, null::integer as client_id, null::integer as user_id, null::integer as contact_id, null::integer as project_id, r.sales_contract_id as sales_contract_id, r.purchase_contract_id as purchase_contract_id, r.wrote_date, r.serial_no, 20016 as ticket_type, r.abstract, r.description, r.created_by, am.user_id as handler, am.amount, r.status, null::numeric as settle_amount, false as is_payment_settle, r.created_at FROM "a57be577deb434"."tbl_erp_cost_convert_tickets" "r" LEFT JOIN "a57be577deb434"."tbl_erp_cost_convert_ticket_handlers" "am" ON am.erp_cost_convert_ticket_id = r.id LEFT JOIN "a57be577deb434"."tbl_sales_contracts" "sc" ON sc.id = r.sales_contract_id WHERE ("r"."status"=2) AND ("am"."user_id"='1001') AND (am.user_id is not null) AND (("sc"."from_project" NOT IN (SELECT t.project_id FROM "a57be577deb434"."tbl_erp_profit_distributes" "t" WHERE ("t"."status"=2) AND (t.project_id IS NOT NULL) GROUP BY "t"."project_id")) OR (sales_contract_id is null)) ) UNION ALL ( SELECT (r.id::varchar || 20016::varchar) as id, r.id as id2, null::integer as supplier_id, null::integer as client_id, null::integer as user_id, null::integer as contact_id, null::integer as project_id, r.sales_contract_id as sales_contract_id, r.purchase_contract_id as purchase_contract_id, r.wrote_date, r.serial_no, 20016 as ticket_type, r.abstract, r.description, r.created_by, am.user_id as handler, r.amount * am.pct as amount, r.status, null::numeric as settle_amount, false as is_payment_settle, r.created_at FROM "a57be577deb434"."tbl_erp_cost_convert_tickets" "r" LEFT JOIN "a57be577deb434"."tbl_sales_contracts" "sc" ON sc.id = r.sales_contract_id LEFT JOIN "a57be577deb434"."tbl_erp_profit_distributes" "pd" ON pd.project_id = sc.from_project LEFT JOIN "a57be577deb434"."tbl_erp_profit_distribute_pcts" "am" ON am.erp_profit_distribute_id = pd.id WHERE ("r"."status"=2) AND ("am"."user_id"='1001') AND (am.user_id is not null) AND ("sc"."from_project" IN (SELECT t.project_id FROM "a57be577deb434"."tbl_erp_profit_distributes" "t" WHERE ("t"."status"=2) AND (t.project_id IS NOT NULL) GROUP BY "t"."project_id")) ) UNION ALL ( SELECT (r.id::varchar || 20011::varchar) as id, r.id as id2, null::integer as supplier_id, r.client_id as client_id, null::integer as user_id, null::integer as contact_id, r.project_id as project_id, null::integer as sales_contract_id, null::integer as purchase_contract_id, r.wrote_date, r.serial_no, 20011 as ticket_type, r.abstract, r.description, r.created_by, r.handler as handler, COALESCE(sum(eipss.actual_total_amount), 0) - COALESCE(sum(eipss.total_amount), 0) as amount, r.status, null::numeric as settle_amount, false as is_payment_settle, r.created_at FROM "a57be577deb434"."tbl_erp_sales_gifts" "r" LEFT JOIN "a57be577deb434"."tbl_erp_inventory_product_spents" "eipss" ON eipss.erp_sales_gift_id = r.id WHERE ("r"."status"=2) AND ("r"."handler"='1001') AND (("r"."project_id" NOT IN (SELECT t.project_id FROM "a57be577deb434"."tbl_erp_profit_distributes" "t" WHERE ("t"."status"=2) AND (t.project_id IS NOT NULL) GROUP BY "t"."project_id")) OR (r.project_id is null)) GROUP BY "r"."id" ) UNION ALL ( SELECT (r.id::varchar || 20011::varchar) as id, r.id as id2, null::integer as supplier_id, r.client_id as client_id, null::integer as user_id, null::integer as contact_id, r.project_id as project_id, null::integer as sales_contract_id, null::integer as purchase_contract_id, r.wrote_date, r.serial_no, 20011 as ticket_type, r.abstract, r.description, r.created_by, am.user_id as handler, (COALESCE(sum(eipss.actual_total_amount), 0) - COALESCE(sum(eipss.total_amount), 0)) * sum(am.pct) as amount, r.status, null::numeric as settle_amount, false as is_payment_settle, r.created_at FROM "a57be577deb434"."tbl_erp_sales_gifts" "r" LEFT JOIN "a57be577deb434"."tbl_erp_inventory_product_spents" "eipss" ON eipss.erp_sales_gift_id = r.id LEFT JOIN "a57be577deb434"."tbl_erp_profit_distributes" "pd" ON pd.project_id = r.project_id LEFT JOIN "a57be577deb434"."tbl_erp_profit_distribute_pcts" "am" ON am.erp_profit_distribute_id = pd.id WHERE ("r"."status"=2) AND ("am"."user_id"='1001') AND (am.user_id is not null) AND (("r"."project_id" IN (SELECT t.project_id FROM "a57be577deb434"."tbl_erp_profit_distributes" "t" WHERE ("t"."status"=2) AND (t.project_id IS NOT NULL) GROUP BY "t"."project_id")) OR (r.project_id is null)) GROUP BY "r"."id", "am"."user_id" ) UNION ALL ( SELECT (r.id::varchar || 20023::varchar) as id, r.id as id2, null::integer as supplier_id, null::integer as client_id, null::integer as user_id, null::integer as contact_id, null::integer as project_id, null::integer as sales_contract_id, null::integer as purchase_contract_id, r.wrote_date, r.serial_no, 20023 as ticket_type, r.abstract, r.description, r.created_by, am.user_id as handler, am.amount, r.status, null::numeric as settle_amount, false as is_payment_settle, r.created_at FROM "a57be577deb434"."tbl_erp_wage_tickets" "r" LEFT JOIN "a57be577deb434"."tbl_erp_wage_ticket_amounts" "am" ON am.erp_wage_ticket_id = r.id WHERE ("r"."status"=2) AND ("am"."user_id"='1001') AND (am.user_id is not null) ) UNION ALL ( SELECT (r.id::varchar || 20024::varchar) as id, r.id as id2, null::integer as supplier_id, null::integer as client_id, null::integer as user_id, null::integer as contact_id, null::integer as project_id, null::integer as sales_contract_id, null::integer as purchase_contract_id, r.wrote_date, r.serial_no, 20024 as ticket_type, r.abstract, r.description, r.created_by, am.user_id as handler, am.amount, r.status, null::numeric as settle_amount, false as is_payment_settle, r.created_at FROM "a57be577deb434"."tbl_erp_social_insurances" "r" LEFT JOIN "a57be577deb434"."tbl_erp_social_insurance_amounts" "am" ON am.erp_social_insurance_id = r.id WHERE ("r"."status"=2) AND ("am"."user_id"='1001') AND (am.user_id is not null) ) UNION ALL ( SELECT (r.id::varchar || 20025::varchar) as id, r.id as id2, null::integer as supplier_id, null::integer as client_id, null::integer as user_id, null::integer as contact_id, null::integer as project_id, null::integer as sales_contract_id, null::integer as purchase_contract_id, r.wrote_date, r.serial_no, 20025 as ticket_type, r.abstract, r.description, r.created_by, am.user_id as handler, am.amount, r.status, null::numeric as settle_amount, false as is_payment_settle, r.created_at FROM "a57be577deb434"."tbl_erp_provident_funds" "r" LEFT JOIN "a57be577deb434"."tbl_erp_provident_fund_amounts" "am" ON am.erp_provident_fund_id = r.id WHERE ("r"."status"=2) AND ("am"."user_id"='1001') AND (am.user_id is not null) ) UNION ALL ( SELECT (r.id::varchar || 20026::varchar) as id, r.id as id2, null::integer as supplier_id, null::integer as client_id, null::integer as user_id, null::integer as contact_id, null::integer as project_id, null::integer as sales_contract_id, null::integer as purchase_contract_id, r.wrote_date, r.serial_no, 20026 as ticket_type, r.abstract, r.description, r.created_by, am.user_id as handler, am.amount, r.status, null::numeric as settle_amount, false as is_payment_settle, r.created_at FROM "a57be577deb434"."tbl_erp_personal_taxs" "r" LEFT JOIN "a57be577deb434"."tbl_erp_personal_tax_amounts" "am" ON am.erp_personal_tax_id = r.id WHERE ("r"."status"=2) AND ("am"."user_id"='1001') AND (am.user_id is not null) ) UNION ALL ( SELECT (r.id::varchar || 20027::varchar) as id, r.id as id2, null::integer as supplier_id, null::integer as client_id, null::integer as user_id, null::integer as contact_id, null::integer as project_id, null::integer as sales_contract_id, null::integer as purchase_contract_id, r.wrote_date, r.serial_no, 20027 as ticket_type, r.abstract, r.description, r.created_by, am.user_id as handler, am.amount, r.status, null::numeric as settle_amount, false as is_payment_settle, r.created_at FROM "a57be577deb434"."tbl_erp_wage_prizes" "r" LEFT JOIN "a57be577deb434"."tbl_erp_wage_prize_amounts" "am" ON am.erp_wage_prize_id = r.id WHERE ("r"."status"=2) AND ("am"."user_id"='1001') AND (am.user_id is not null) )) "sub" ORDER BY created_at DESC) "c"
17:51:26.584infoyii\db\Command::querySELECT * FROM ((SELECT (r.id::varchar || 20018::varchar) as id, r.id as id2, r.supplier_id as supplier_id, r.client_id as client_id, null::integer as user_id, null::integer as contact_id, null::integer as project_id, r.sales_contract_id as sales_contract_id, r.purchase_contract_id as purchase_contract_id, r.wrote_date, r.serial_no, 20018 as ticket_type, r.abstract, r.description, r.created_by, am.user_id as handler, am.amount, r.status, r.settle_amount, r.is_payment_settle, r.created_at FROM "a57be577deb434"."tbl_erp_cash_cost_tickets" "r" LEFT JOIN "a57be577deb434"."tbl_erp_cash_cost_ticket_handlers" "am" ON am.erp_cash_cost_ticket_id = r.id LEFT JOIN "a57be577deb434"."tbl_sales_contracts" "sc" ON sc.id = r.sales_contract_id WHERE ("r"."status"=2) AND ("am"."user_id"='1001') AND (am.user_id is not null) AND (("sc"."from_project" NOT IN (SELECT t.project_id FROM "a57be577deb434"."tbl_erp_profit_distributes" "t" WHERE ("t"."status"=2) AND (t.project_id IS NOT NULL) GROUP BY "t"."project_id")) OR (sales_contract_id is null))) UNION ALL ( SELECT (r.id::varchar || 20018::varchar) as id, r.id as id2, r.supplier_id as supplier_id, r.client_id as client_id, null::integer as user_id, null::integer as contact_id, null::integer as project_id, r.sales_contract_id as sales_contract_id, r.purchase_contract_id as purchase_contract_id, r.wrote_date, r.serial_no, 20018 as ticket_type, r.abstract, r.description, r.created_by, am.user_id as handler, r.amount * am.pct as amount, r.status, r.settle_amount, r.is_payment_settle, r.created_at FROM "a57be577deb434"."tbl_erp_cash_cost_tickets" "r" LEFT JOIN "a57be577deb434"."tbl_sales_contracts" "sc" ON sc.id = r.sales_contract_id LEFT JOIN "a57be577deb434"."tbl_erp_profit_distributes" "pd" ON pd.project_id = sc.from_project LEFT JOIN "a57be577deb434"."tbl_erp_profit_distribute_pcts" "am" ON am.erp_profit_distribute_id = pd.id WHERE ("r"."status"=2) AND ("am"."user_id"='1001') AND (am.user_id is not null) AND ("sc"."from_project" IN (SELECT t.project_id FROM "a57be577deb434"."tbl_erp_profit_distributes" "t" WHERE ("t"."status"=2) AND (t.project_id IS NOT NULL) GROUP BY "t"."project_id")) ) UNION ALL ( SELECT (r.id::varchar || 20014::varchar) as id, r.id as id2, r.supplier_id as supplier_id, r.client_id as client_id, null::integer as user_id, null::integer as contact_id, r.project_id as project_id, r.sales_contract_id as sales_contract_id, r.purchase_contract_id as purchase_contract_id, r.wrote_date, r.serial_no, 20014 as ticket_type, r.abstract, r.description, r.created_by, am.user_id as handler, am.amount, r.status, r.settle_amount, false as is_payment_settle, r.created_at FROM "a57be577deb434"."tbl_erp_cost_tickets" "r" LEFT JOIN "a57be577deb434"."tbl_erp_cost_ticket_handlers" "am" ON am.erp_cost_ticket_id = r.id LEFT JOIN "a57be577deb434"."tbl_sales_contracts" "sc" ON sc.id = r.sales_contract_id WHERE ("r"."status"=2) AND ("am"."user_id"='1001') AND (am.user_id is not null) AND (("sc"."from_project" NOT IN (SELECT t.project_id FROM "a57be577deb434"."tbl_erp_profit_distributes" "t" WHERE ("t"."status"=2) AND (t.project_id IS NOT NULL) GROUP BY "t"."project_id")) OR (sales_contract_id is null)) ) UNION ALL ( SELECT (r.id::varchar || 20014::varchar) as id, r.id as id2, r.supplier_id as supplier_id, r.client_id as client_id, null::integer as user_id, null::integer as contact_id, r.project_id as project_id, r.sales_contract_id as sales_contract_id, r.purchase_contract_id as purchase_contract_id, r.wrote_date, r.serial_no, 20014 as ticket_type, r.abstract, r.description, r.created_by, am.user_id as handler, r.amount * am.pct as amount, r.status, r.settle_amount, false as is_payment_settle, r.created_at FROM "a57be577deb434"."tbl_erp_cost_tickets" "r" LEFT JOIN "a57be577deb434"."tbl_sales_contracts" "sc" ON sc.id = r.sales_contract_id LEFT JOIN "a57be577deb434"."tbl_erp_profit_distributes" "pd" ON pd.project_id = sc.from_project LEFT JOIN "a57be577deb434"."tbl_erp_profit_distribute_pcts" "am" ON am.erp_profit_distribute_id = pd.id WHERE ("r"."status"=2) AND ("am"."user_id"='1001') AND (am.user_id is not null) AND ("sc"."from_project" IN (SELECT t.project_id FROM "a57be577deb434"."tbl_erp_profit_distributes" "t" WHERE ("t"."status"=2) AND (t.project_id IS NOT NULL) GROUP BY "t"."project_id")) ) UNION ALL ( SELECT (r.id::varchar || 20016::varchar) as id, r.id as id2, null::integer as supplier_id, null::integer as client_id, null::integer as user_id, null::integer as contact_id, null::integer as project_id, r.sales_contract_id as sales_contract_id, r.purchase_contract_id as purchase_contract_id, r.wrote_date, r.serial_no, 20016 as ticket_type, r.abstract, r.description, r.created_by, am.user_id as handler, am.amount, r.status, null::numeric as settle_amount, false as is_payment_settle, r.created_at FROM "a57be577deb434"."tbl_erp_cost_convert_tickets" "r" LEFT JOIN "a57be577deb434"."tbl_erp_cost_convert_ticket_handlers" "am" ON am.erp_cost_convert_ticket_id = r.id LEFT JOIN "a57be577deb434"."tbl_sales_contracts" "sc" ON sc.id = r.sales_contract_id WHERE ("r"."status"=2) AND ("am"."user_id"='1001') AND (am.user_id is not null) AND (("sc"."from_project" NOT IN (SELECT t.project_id FROM "a57be577deb434"."tbl_erp_profit_distributes" "t" WHERE ("t"."status"=2) AND (t.project_id IS NOT NULL) GROUP BY "t"."project_id")) OR (sales_contract_id is null)) ) UNION ALL ( SELECT (r.id::varchar || 20016::varchar) as id, r.id as id2, null::integer as supplier_id, null::integer as client_id, null::integer as user_id, null::integer as contact_id, null::integer as project_id, r.sales_contract_id as sales_contract_id, r.purchase_contract_id as purchase_contract_id, r.wrote_date, r.serial_no, 20016 as ticket_type, r.abstract, r.description, r.created_by, am.user_id as handler, r.amount * am.pct as amount, r.status, null::numeric as settle_amount, false as is_payment_settle, r.created_at FROM "a57be577deb434"."tbl_erp_cost_convert_tickets" "r" LEFT JOIN "a57be577deb434"."tbl_sales_contracts" "sc" ON sc.id = r.sales_contract_id LEFT JOIN "a57be577deb434"."tbl_erp_profit_distributes" "pd" ON pd.project_id = sc.from_project LEFT JOIN "a57be577deb434"."tbl_erp_profit_distribute_pcts" "am" ON am.erp_profit_distribute_id = pd.id WHERE ("r"."status"=2) AND ("am"."user_id"='1001') AND (am.user_id is not null) AND ("sc"."from_project" IN (SELECT t.project_id FROM "a57be577deb434"."tbl_erp_profit_distributes" "t" WHERE ("t"."status"=2) AND (t.project_id IS NOT NULL) GROUP BY "t"."project_id")) ) UNION ALL ( SELECT (r.id::varchar || 20011::varchar) as id, r.id as id2, null::integer as supplier_id, r.client_id as client_id, null::integer as user_id, null::integer as contact_id, r.project_id as project_id, null::integer as sales_contract_id, null::integer as purchase_contract_id, r.wrote_date, r.serial_no, 20011 as ticket_type, r.abstract, r.description, r.created_by, r.handler as handler, COALESCE(sum(eipss.actual_total_amount), 0) - COALESCE(sum(eipss.total_amount), 0) as amount, r.status, null::numeric as settle_amount, false as is_payment_settle, r.created_at FROM "a57be577deb434"."tbl_erp_sales_gifts" "r" LEFT JOIN "a57be577deb434"."tbl_erp_inventory_product_spents" "eipss" ON eipss.erp_sales_gift_id = r.id WHERE ("r"."status"=2) AND ("r"."handler"='1001') AND (("r"."project_id" NOT IN (SELECT t.project_id FROM "a57be577deb434"."tbl_erp_profit_distributes" "t" WHERE ("t"."status"=2) AND (t.project_id IS NOT NULL) GROUP BY "t"."project_id")) OR (r.project_id is null)) GROUP BY "r"."id" ) UNION ALL ( SELECT (r.id::varchar || 20011::varchar) as id, r.id as id2, null::integer as supplier_id, r.client_id as client_id, null::integer as user_id, null::integer as contact_id, r.project_id as project_id, null::integer as sales_contract_id, null::integer as purchase_contract_id, r.wrote_date, r.serial_no, 20011 as ticket_type, r.abstract, r.description, r.created_by, am.user_id as handler, (COALESCE(sum(eipss.actual_total_amount), 0) - COALESCE(sum(eipss.total_amount), 0)) * sum(am.pct) as amount, r.status, null::numeric as settle_amount, false as is_payment_settle, r.created_at FROM "a57be577deb434"."tbl_erp_sales_gifts" "r" LEFT JOIN "a57be577deb434"."tbl_erp_inventory_product_spents" "eipss" ON eipss.erp_sales_gift_id = r.id LEFT JOIN "a57be577deb434"."tbl_erp_profit_distributes" "pd" ON pd.project_id = r.project_id LEFT JOIN "a57be577deb434"."tbl_erp_profit_distribute_pcts" "am" ON am.erp_profit_distribute_id = pd.id WHERE ("r"."status"=2) AND ("am"."user_id"='1001') AND (am.user_id is not null) AND (("r"."project_id" IN (SELECT t.project_id FROM "a57be577deb434"."tbl_erp_profit_distributes" "t" WHERE ("t"."status"=2) AND (t.project_id IS NOT NULL) GROUP BY "t"."project_id")) OR (r.project_id is null)) GROUP BY "r"."id", "am"."user_id" ) UNION ALL ( SELECT (r.id::varchar || 20023::varchar) as id, r.id as id2, null::integer as supplier_id, null::integer as client_id, null::integer as user_id, null::integer as contact_id, null::integer as project_id, null::integer as sales_contract_id, null::integer as purchase_contract_id, r.wrote_date, r.serial_no, 20023 as ticket_type, r.abstract, r.description, r.created_by, am.user_id as handler, am.amount, r.status, null::numeric as settle_amount, false as is_payment_settle, r.created_at FROM "a57be577deb434"."tbl_erp_wage_tickets" "r" LEFT JOIN "a57be577deb434"."tbl_erp_wage_ticket_amounts" "am" ON am.erp_wage_ticket_id = r.id WHERE ("r"."status"=2) AND ("am"."user_id"='1001') AND (am.user_id is not null) ) UNION ALL ( SELECT (r.id::varchar || 20024::varchar) as id, r.id as id2, null::integer as supplier_id, null::integer as client_id, null::integer as user_id, null::integer as contact_id, null::integer as project_id, null::integer as sales_contract_id, null::integer as purchase_contract_id, r.wrote_date, r.serial_no, 20024 as ticket_type, r.abstract, r.description, r.created_by, am.user_id as handler, am.amount, r.status, null::numeric as settle_amount, false as is_payment_settle, r.created_at FROM "a57be577deb434"."tbl_erp_social_insurances" "r" LEFT JOIN "a57be577deb434"."tbl_erp_social_insurance_amounts" "am" ON am.erp_social_insurance_id = r.id WHERE ("r"."status"=2) AND ("am"."user_id"='1001') AND (am.user_id is not null) ) UNION ALL ( SELECT (r.id::varchar || 20025::varchar) as id, r.id as id2, null::integer as supplier_id, null::integer as client_id, null::integer as user_id, null::integer as contact_id, null::integer as project_id, null::integer as sales_contract_id, null::integer as purchase_contract_id, r.wrote_date, r.serial_no, 20025 as ticket_type, r.abstract, r.description, r.created_by, am.user_id as handler, am.amount, r.status, null::numeric as settle_amount, false as is_payment_settle, r.created_at FROM "a57be577deb434"."tbl_erp_provident_funds" "r" LEFT JOIN "a57be577deb434"."tbl_erp_provident_fund_amounts" "am" ON am.erp_provident_fund_id = r.id WHERE ("r"."status"=2) AND ("am"."user_id"='1001') AND (am.user_id is not null) ) UNION ALL ( SELECT (r.id::varchar || 20026::varchar) as id, r.id as id2, null::integer as supplier_id, null::integer as client_id, null::integer as user_id, null::integer as contact_id, null::integer as project_id, null::integer as sales_contract_id, null::integer as purchase_contract_id, r.wrote_date, r.serial_no, 20026 as ticket_type, r.abstract, r.description, r.created_by, am.user_id as handler, am.amount, r.status, null::numeric as settle_amount, false as is_payment_settle, r.created_at FROM "a57be577deb434"."tbl_erp_personal_taxs" "r" LEFT JOIN "a57be577deb434"."tbl_erp_personal_tax_amounts" "am" ON am.erp_personal_tax_id = r.id WHERE ("r"."status"=2) AND ("am"."user_id"='1001') AND (am.user_id is not null) ) UNION ALL ( SELECT (r.id::varchar || 20027::varchar) as id, r.id as id2, null::integer as supplier_id, null::integer as client_id, null::integer as user_id, null::integer as contact_id, null::integer as project_id, null::integer as sales_contract_id, null::integer as purchase_contract_id, r.wrote_date, r.serial_no, 20027 as ticket_type, r.abstract, r.description, r.created_by, am.user_id as handler, am.amount, r.status, null::numeric as settle_amount, false as is_payment_settle, r.created_at FROM "a57be577deb434"."tbl_erp_wage_prizes" "r" LEFT JOIN "a57be577deb434"."tbl_erp_wage_prize_amounts" "am" ON am.erp_wage_prize_id = r.id WHERE ("r"."status"=2) AND ("am"."user_id"='1001') AND (am.user_id is not null) )) "sub" ORDER BY created_at DESC LIMIT 20
17:51:26.592infoyii\db\Command::querySELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (5388, 1011, 1001)
17:51:26.593infoyii\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, 5388))
17:51:26.594infoyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_departments" WHERE "id" IN (3, 4, 6)
17:51:26.594infoyii\db\Command::querySELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
17:51:26.595infoyii\db\Command::querySELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=1001)
17:51:26.595infoyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_departments" WHERE "id"=4
17:51:26.595infoyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_clients" WHERE "id" IN (2545, 2553)
17:51:26.596traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
17:51:26.596traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
17:51:26.597infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_visit_module_histories" WHERE ("user_id"=5064) AND ("object_type"=20000) AND ("visit_date"='2025-09-24')
17:51:26.600traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
17:51:26.600traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
17:51:26.601infoyii\db\Command::executeUPDATE "a57be577deb434"."tbl_visit_module_histories" SET "num"=228, "last_visit_at"='now()' WHERE "id"=57055
17:51:26.602infoyii\db\Command::queryINSERT INTO "global"."tbl_api_log" ("code", "schema", "user_id", "device_type", "url", "request", "response", "php_error", "time") VALUES (200, 'a57be577deb434', 5064, 5, 'vue/erp-wage-analysis/in-out-view-out-list', '{"created_at_period":"","created_at_to":"","created_at_from":"","user_id":["1001"],"page":"1","web_access_token":"_AoGeYJ0QgSiLktGksNR6aswyct1iLo2"}', '{"code":2000,"result":{"list":[{"id":2,"id2":2,"supplier_id":"","client_id":"","user_id":"","contact_id":"","project_id":"","sales_contract_id":"","purchase_contract_id":"","wrote_date":"2025-09-15","serial_no":"SBD-20250915-00002","ticket_type":20024,"abstract":"8\u6708\u793e\u4fdd\u8d39","description":"","created_by":5388,"handler":1001,"amount":"0","status":2,"settle_amount":"","is_payment_settle":false,"created_at":"2025-09-15 10:25:57","createdBy":{"id":5388,"key":5388,"name":"\u6768\u71d5\u971e","sex":"F","department_id":6,"avatar":{"id":156,"user_id":5388,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b8d4f68f-e736-3c38-9e2f-1ab47885b3d8.png"},"department":{"id":6,"key":6,"name":"\u8d22\u52a1\u90e8"}},"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"}},"supplier":{},"client":{},"user":{},"contact":{},"ticket_type_display":"\u793e\u4fdd\u5355","bgcolor":"#02A7F0","status_display":"\u5df2\u8ba1\u63d0","unit":"","contract_no":""},{"id":2,"id2":2,"supplier_id":"","client_id":"","user_id":"","contact_id":"","project_id":"","sales_contract_id":"","purchase_contract_id":"","wrote_date":"2025-09-09","serial_no":"GSD-20250909-00002","ticket_type":20026,"abstract":"7\u6708\u5de5\u8d44\u4e2a\u7a0e","description":"","created_by":5388,"handler":1001,"amount":"0","status":2,"settle_amount":"","is_payment_settle":false,"created_at":"2025-09-09 15:39:04","createdBy":{"id":5388,"key":5388,"name":"\u6768\u71d5\u971e","sex":"F","department_id":6,"avatar":{"id":156,"user_id":5388,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b8d4f68f-e736-3c38-9e2f-1ab47885b3d8.png"},"department":{"id":6,"key":6,"name":"\u8d22\u52a1\u90e8"}},"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"}},"supplier":{},"client":{},"user":{},"contact":{},"ticket_type_display":"\u4e2a\u7a0e\u5355","bgcolor":"#02A7F0","status_display":"\u5df2\u8ba1\u63d0","unit":"","contract_no":""},{"id":2,"id2":2,"supplier_id":"","client_id":"","user_id":"","contact_id":"","project_id":"","sales_contract_id":"","purchase_contract_id":"","wrote_date":"2025-09-09","serial_no":"GZD-20250909-00002","ticket_type":20023,"abstract":"8\u6708\u5de5\u8d44","description":"","created_by":5388,"handler":1001,"amount":"0","status":2,"settle_amount":"","is_payment_settle":false,"created_at":"2025-09-09 15:36:02","createdBy":{"id":5388,"key":5388,"name":"\u6768\u71d5\u971e","sex":"F","department_id":6,"avatar":{"id":156,"user_id":5388,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b8d4f68f-e736-3c38-9e2f-1ab47885b3d8.png"},"department":{"id":6,"key":6,"name":"\u8d22\u52a1\u90e8"}},"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"}},"supplier":{},"client":{},"user":{},"contact":{},"ticket_type_display":"\u5de5\u8d44\u5355","bgcolor":"#02A7F0","status_display":"\u5df2\u8ba1\u63d0","unit":"","contract_no":""},{"id":2,"id2":2,"supplier_id":"","client_id":"","user_id":"","contact_id":"","project_id":"","sales_contract_id":"","purchase_contract_id":"","wrote_date":"2025-09-08","serial_no":"FYZSRD-20250908-00001","ticket_type":20016,"abstract":"\u5b9e\u65bd\u5de5\u7a0b\u5e08\u5de5\u65f6\u8d39\u75288\u6708","description":"","created_by":5388,"handler":1001,"amount":"62","status":2,"settle_amount":"","is_payment_settle":false,"created_at":"2025-09-08 09:26:29","createdBy":{"id":5388,"key":5388,"name":"\u6768\u71d5\u971e","sex":"F","department_id":6,"avatar":{"id":156,"user_id":5388,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b8d4f68f-e736-3c38-9e2f-1ab47885b3d8.png"},"department":{"id":6,"key":6,"name":"\u8d22\u52a1\u90e8"}},"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"}},"supplier":{},"client":{},"user":{},"contact":{},"ticket_type_display":"\u8d39\u7528\u8f6c\u5176\u4ed6\u6536\u5165\u5355","bgcolor":"#4B7902","status_display":"\u5df2\u901a\u8fc7","unit":"","contract_no":""},{"id":13,"id2":13,"supplier_id":"","client_id":2545,"user_id":"","contact_id":"","project_id":3899,"sales_contract_id":"","purchase_contract_id":"","wrote_date":"2025-08-28","serial_no":"ZSD-20250828-00001","ticket_type":20011,"abstract":"\u672a\u7a0e","description":"","created_by":1011,"handler":1001,"amount":"900","status":2,"settle_amount":"","is_payment_settle":false,"created_at":"2025-08-28 10:02:49","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"}},"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"}},"supplier":{},"client":{"id":2545,"key":2545,"name":"\u8d44\u821f\u8d44\u4ea7\u7ba1\u7406(\u6df1\u5733)\u6709\u9650\u516c\u53f8"},"user":{},"contact":{},"ticket_type_display":"\u8d60\u9001\u5355","bgcolor":"#4B7902","status_display":"\u5df2\u901a\u8fc7","unit":{"id":2545,"key":2545,"name":"\u8d44\u821f\u8d44\u4ea7\u7ba1\u7406(\u6df1\u5733)\u6709\u9650\u516c\u53f8"},"contract_no":""},{"id":1,"id2":1,"supplier_id":"","client_id":"","user_id":"","contact_id":"","project_id":"","sales_contract_id":"","purchase_contract_id":"","wrote_date":"2025-08-26","serial_no":"GJJD-20250826-00001","ticket_type":20025,"abstract":"8\u6708\u516c\u79ef\u91d1","description":"","created_by":5388,"handler":1001,"amount":"0","status":2,"settle_amount":"","is_payment_settle":false,"created_at":"2025-08-27 14:24:43","createdBy":{"id":5388,"key":5388,"name":"\u6768\u71d5\u971e","sex":"F","department_id":6,"avatar":{"id":156,"user_id":5388,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b8d4f68f-e736-3c38-9e2f-1ab47885b3d8.png"},"department":{"id":6,"key":6,"name":"\u8d22\u52a1\u90e8"}},"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"}},"supplier":{},"client":{},"user":{},"contact":{},"ticket_type_display":"\u516c\u79ef\u91d1\u5355","bgcolor":"#02A7F0","status_display":"\u5df2\u8ba1\u63d0","unit":"","contract_no":""},{"id":4,"id2":4,"supplier_id":"","client_id":"","user_id":"","contact_id":"","project_id":"","sales_contract_id":"","purchase_contract_id":"","wrote_date":"2025-08-21","serial_no":"FYD-20250821-00003","ticket_type":20014,"abstract":"\u9752\u5c9b\u9890\u6770\u9e3f\u5229\u674e\u777f\u8fd4\u6b3e\u5408\u540c\u989d885300\u5143\n","description":"","created_by":5388,"handler":1001,"amount":"348931.5","status":2,"settle_amount":"365","is_payment_settle":false,"created_at":"2025-08-21 17:24:59","createdBy":{"id":5388,"key":5388,"name":"\u6768\u71d5\u971e","sex":"F","department_id":6,"avatar":{"id":156,"user_id":5388,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b8d4f68f-e736-3c38-9e2f-1ab47885b3d8.png"},"department":{"id":6,"key":6,"name":"\u8d22\u52a1\u90e8"}},"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"}},"supplier":{},"client":{},"user":{},"contact":{},"ticket_type_display":"\u8d39\u7528\u5355","bgcolor":"#4B7902","status_display":"\u5df2\u5b8c\u6210","unit":"","contract_no":"","handlers":[{"name":"\u516c\u53f8\u8d39\u7528"}]},{"id":6,"id2":6,"supplier_id":"","client_id":2553,"user_id":"","contact_id":"","project_id":3751,"sales_contract_id":"","purchase_contract_id":"","wrote_date":"2025-08-21","serial_no":"ZSD-20250821-00002","ticket_type":20011,"abstract":"\u672a\u7a0e","description":"\u62b5\u51cf\u6389\u674e\u777f\u7684\u79ef\u5206\uff0c\u9700\u8981\u505a\u4e00\u5f20\u5176\u4ed6\u5e94\u4ed8\u5355365\u6302\u674e\u777f","created_by":1011,"handler":1001,"amount":"365.00","status":2,"settle_amount":"","is_payment_settle":false,"created_at":"2025-08-21 13:54:21","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"}},"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"}},"supplier":{},"client":{"id":2553,"key":2553,"name":"\u9752\u5c9b\u9890\u6770\u9e3f\u5229\u79d1\u6280\u6709\u9650\u516c\u53f8"},"user":{},"contact":{},"ticket_type_display":"\u8d60\u9001\u5355","bgcolor":"#4B7902","status_display":"\u5df2\u901a\u8fc7","unit":{"id":2553,"key":2553,"name":"\u9752\u5c9b\u9890\u6770\u9e3f\u5229\u79d1\u6280\u6709\u9650\u516c\u53f8"},"contract_no":""},{"id":1,"id2":1,"supplier_id":"","client_id":"","user_id":"","contact_id":"","project_id":"","sales_contract_id":"","purchase_contract_id":"","wrote_date":"2025-08-18","serial_no":"FYZSRD-20250818-00001","ticket_type":20016,"abstract":"\u5b9e\u65bd\u5de5\u7a0b\u5e08\u5de5\u65f6\u8d39\u75287\u6708","description":"","created_by":5388,"handler":1001,"amount":"188","status":2,"settle_amount":"","is_payment_settle":false,"created_at":"2025-08-19 10:20:49","createdBy":{"id":5388,"key":5388,"name":"\u6768\u71d5\u971e","sex":"F","department_id":6,"avatar":{"id":156,"user_id":5388,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b8d4f68f-e736-3c38-9e2f-1ab47885b3d8.png"},"department":{"id":6,"key":6,"name":"\u8d22\u52a1\u90e8"}},"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"}},"supplier":{},"client":{},"user":{},"contact":{},"ticket_type_display":"\u8d39\u7528\u8f6c\u5176\u4ed6\u6536\u5165\u5355","bgcolor":"#4B7902","status_display":"\u5df2\u901a\u8fc7","unit":"","contract_no":""},{"id":1,"id2":1,"supplier_id":"","client_id":"","user_id":"","contact_id":"","project_id":"","sales_contract_id":"","purchase_contract_id":"","wrote_date":"2025-08-13","serial_no":"SBD-20250813-00001","ticket_type":20024,"abstract":"7\u6708\u793e\u4fdd\u8d39","description":"","created_by":5388,"handler":1001,"amount":"0","status":2,"settle_amount":"","is_payment_settle":false,"created_at":"2025-08-14 14:14:04","createdBy":{"id":5388,"key":5388,"name":"\u6768\u71d5\u971e","sex":"F","department_id":6,"avatar":{"id":156,"user_id":5388,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b8d4f68f-e736-3c38-9e2f-1ab47885b3d8.png"},"department":{"id":6,"key":6,"name":"\u8d22\u52a1\u90e8"}},"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"}},"supplier":{},"client":{},"user":{},"contact":{},"ticket_type_display":"\u793e\u4fdd\u5355","bgcolor":"#02A7F0","status_display":"\u5df2\u8ba1\u63d0","unit":"","contract_no":""},{"id":1,"id2":1,"supplier_id":"","client_id":"","user_id":"","contact_id":"","project_id":"","sales_contract_id":"","purchase_contract_id":"","wrote_date":"2025-08-14","serial_no":"GZD-20250814-00001","ticket_type":20023,"abstract":"7\u6708\u5de5\u8d44","description":"","created_by":5388,"handler":1001,"amount":"0","status":2,"settle_amount":"","is_payment_settle":false,"created_at":"2025-08-14 14:08:17","createdBy":{"id":5388,"key":5388,"name":"\u6768\u71d5\u971e","sex":"F","department_id":6,"avatar":{"id":156,"user_id":5388,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b8d4f68f-e736-3c38-9e2f-1ab47885b3d8.png"},"department":{"id":6,"key":6,"name":"\u8d22\u52a1\u90e8"}},"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"}},"supplier":{},"client":{},"user":{},"contact":{},"ticket_type_display":"\u5de5\u8d44\u5355","bgcolor":"#02A7F0","status_display":"\u5df2\u8ba1\u63d0","unit":"","contract_no":""},{"id":6806,"id2":6806,"supplier_id":"","client_id":"","user_id":"","contact_id":"","project_id":"","sales_contract_id":"","purchase_contract_id":"","wrote_date":"","serial_no":"XJFYD-20250314-00001","ticket_type":20018,"abstract":"\u4e1a\u52a1\u62a5\u9500","description":"","created_by":1001,"handler":1001,"amount":"10436","status":2,"settle_amount":"10436","is_payment_settle":true,"created_at":"2025-03-14 10:43:55","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"}},"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"}},"supplier":{},"client":{},"user":{},"contact":{},"ticket_type_display":"\u73b0\u91d1\u8d39\u7528\u5355","bgcolor":"#02A7F0","status_display":"\u5f85\u4ed8\u6b3e","unit":"","contract_no":"","handlers":[{"name":"\u516c\u53f8\u8d39\u7528"}]},{"id":6362,"id2":6362,"supplier_id":"","client_id":"","user_id":"","contact_id":"","project_id":"","sales_contract_id":"","purchase_contract_id":"","wrote_date":"","serial_no":"XJFYD-20241017-00003","ticket_type":20018,"abstract":"","description":"","created_by":1001,"handler":1001,"amount":"7054","status":2,"settle_amount":"7054","is_payment_settle":true,"created_at":"2024-10-17 11:13:17","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"}},"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"}},"supplier":{},"client":{},"user":{},"contact":{},"ticket_type_display":"\u73b0\u91d1\u8d39\u7528\u5355","bgcolor":"#02A7F0","status_display":"\u5f85\u4ed8\u6b3e","unit":"","contract_no":"","handlers":[{"name":"\u516c\u53f8\u8d39\u7528"}]},{"id":6361,"id2":6361,"supplier_id":"","client_id":"","user_id":"","contact_id":"","project_id":"","sales_contract_id":"","purchase_contract_id":"","wrote_date":"","serial_no":"XJFYD-20241017-00002","ticket_type":20018,"abstract":"","description":"","created_by":1001,"handler":1001,"amount":"31265","status":2,"settle_amount":"31265","is_payment_settle":true,"created_at":"2024-10-17 11:12:31","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"}},"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"}},"supplier":{},"client":{},"user":{},"contact":{},"ticket_type_display":"\u73b0\u91d1\u8d39\u7528\u5355","bgcolor":"#02A7F0","status_display":"\u5f85\u4ed8\u6b3e","unit":"","contract_no":"","handlers":[{"name":"\u516c\u53f8\u8d39\u7528"}]},{"id":5615,"id2":5615,"supplier_id":"","client_id":"","user_id":"","contact_id":"","project_id":"","sales_contract_id":"","purchase_contract_id":"","wrote_date":"","serial_no":"XJFYD-20240512-00001","ticket_type":20018,"abstract":"\u6253\u52309656\u50a8\u84c4\u5361","description":"","created_by":1001,"handler":1001,"amount":"13545","status":2,"settle_amount":"13545","is_payment_settle":true,"created_at":"2024-05-12 09:59:39","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"}},"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"}},"supplier":{},"client":{},"user":{},"contact":{},"ticket_type_display":"\u73b0\u91d1\u8d39\u7528\u5355","bgcolor":"#02A7F0","status_display":"\u5f85\u4ed8\u6b3e","unit":"","contract_no":"","handlers":[{"name":"\u516c\u53f8\u8d39\u7528"}]},{"id":5195,"id2":5195,"supplier_id":"","client_id":"","user_id":"","contact_id":"","project_id":"","sales_contract_id":"","purchase_contract_id":"","wrote_date":"","serial_no":"XJFYD-20240202-00002","ticket_type":20018,"abstract":"\u4e1a\u52a1\u62db\u5f85\u8d39","description":"","created_by":1001,"handler":1001,"amount":"26515","status":2,"settle_amount":"26515","is_payment_settle":true,"created_at":"2024-02-02 13:14:47","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"}},"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"}},"supplier":{},"client":{},"user":{},"contact":{},"ticket_type_display":"\u73b0\u91d1\u8d39\u7528\u5355","bgcolor":"#02A7F0","status_display":"\u5f85\u4ed8\u6b3e","unit":"","contract_no":"","handlers":[{"name":"\u516c\u53f8\u8d39\u7528"}]},{"id":4309,"id2":4309,"supplier_id":"","client_id":"","user_id":"","contact_id":"","project_id":"","sales_contract_id":"","purchase_contract_id":"","wrote_date":"","serial_no":"XJFYD-20230908-00001","ticket_type":20018,"abstract":"\u65e5\u5e38\u62a5\u9500","description":"","created_by":1001,"handler":1001,"amount":"17603","status":2,"settle_amount":"17603","is_payment_settle":true,"created_at":"2023-09-08 15:25:02","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"}},"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"}},"supplier":{},"client":{},"user":{},"contact":{},"ticket_type_display":"\u73b0\u91d1\u8d39\u7528\u5355","bgcolor":"#02A7F0","status_display":"\u5f85\u4ed8\u6b3e","unit":"","contract_no":"","handlers":[{"name":"\u516c\u53f8\u8d39\u7528"}]},{"id":3966,"id2":3966,"supplier_id":"","client_id":"","user_id":"","contact_id":"","project_id":"","sales_contract_id":"","purchase_contract_id":"","wrote_date":"","serial_no":"XJFYD-20230712-00001","ticket_type":20018,"abstract":"\u4e1a\u52a1\u62db\u5f85\u8d39","description":"","created_by":1001,"handler":1001,"amount":"10854","status":2,"settle_amount":"10854","is_payment_settle":true,"created_at":"2023-07-12 12:18:56","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"}},"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"}},"supplier":{},"client":{},"user":{},"contact":{},"ticket_type_display":"\u73b0\u91d1\u8d39\u7528\u5355","bgcolor":"#02A7F0","status_display":"\u5f85\u4ed8\u6b3e","unit":"","contract_no":"","handlers":[{"name":"\u516c\u53f8\u8d39\u7528"}]},{"id":3606,"id2":3606,"supplier_id":"","client_id":"","user_id":"","contact_id":"","project_id":"","sales_contract_id":"","purchase_contract_id":"","wrote_date":"","serial_no":"XJFYD-20230511-00001","ticket_type":20018,"abstract":"","description":"","created_by":1001,"handler":1001,"amount":"4777","status":2,"settle_amount":"4777","is_payment_settle":true,"created_at":"2023-05-11 09:58:06","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"}},"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"}},"supplier":{},"client":{},"user":{},"contact":{},"ticket_type_display":"\u73b0\u91d1\u8d39\u7528\u5355","bgcolor":"#02A7F0","status_display":"\u5f85\u4ed8\u6b3e","unit":"","contract_no":"","handlers":[{"name":"\u516c\u53f8\u8d39\u7528"}]},{"id":3417,"id2":3417,"supplier_id":"","client_id":"","user_id":"","contact_id":"","project_id":"","sales_contract_id":"","purchase_contract_id":"","wrote_date":"","serial_no":"XJFYD-20230330-00005","ticket_type":20018,"abstract":"2023\u5e741\u6708\u81f32023\u5e744\u6708\n\u65e5\u5e38\u4e1a\u52a1\u62a5\u9500","description":"","created_by":1001,"handler":1001,"amount":"24987","status":2,"settle_amount":"24987","is_payment_settle":true,"created_at":"2023-03-30 14:10:33","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"}},"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"}},"supplier":{},"client":{},"user":{},"contact":{},"ticket_type_display":"\u73b0\u91d1\u8d39\u7528\u5355","bgcolor":"#02A7F0","status_display":"\u5f85\u4ed8\u6b3e","unit":"","contract_no":"","handlers":[{"name":"\u516c\u53f8\u8d39\u7528"}]}],"pagenation":{"totalcount":67,"thispage":1,"pagesize":20}},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}],"mod":0}', FALSE, '2025-09-24 17:51:26') RETURNING "id"
17:51:26.604traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
17:51:26.605traceyii\redis\Connection::executeCommandExecuting Redis Command: SET