ConfigurationRequestLogsProfilingDatabaseAsset BundlesMailTimeline
All Latest
6a1d36f80ceb1: POST https://beta.jinchangxiao.com/vue/dashboard/get-notice at 2026-06-01 03:38:32 pm by 221.216.117.119

Log Messages

总计82条数据
TimeLevelCategoryMessage
 
15:38:32.051traceyii\base\Application::bootstrapBootstrap with yii\log\Dispatcher
15:38:32.051traceyii\base\Module::getModuleLoading module: debug
15:38:32.052traceyii\base\Application::bootstrapBootstrap with yii\debug\Module::bootstrap()
15:38:32.053traceyii\redis\Connection::openOpening redis DB connection: redis.server.local:6379, database=1
15:38:32.053traceyii\redis\Connection::executeCommandExecuting Redis Command: SELECT
15:38:32.053traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
15:38:32.053infotime tracing start1780299512053678080
15:38:32.053traceyii\web\UrlManager::parseRequestNo matching URL rules. Using default URL parsing logic.
15:38:32.053traceyii\web\Application::handleRequestRoute requested: 'vue/dashboard/get-notice'
15:38:32.053traceyii\base\Module::getModuleLoading module: vue
15:38:32.054infoyii\web\Session::openSession started
15:38:32.055infoyii\db\Command::querySELECT * FROM "global"."vw_user_login" WHERE "id"=1001
15:38:32.055infoyii\db\Connection::openOpening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta
15:38:32.056traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
15:38:32.056traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
15:38:32.057traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
15:38:32.057traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
15:38:32.057infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
15:38:32.059traceyii\base\Controller::runActionRoute to run: vue/dashboard/get-notice
15:38:32.059traceyii\base\InlineAction::runWithParamsRunning action: app\modules\vue\controllers\DashboardController::actionGetNotice()
15:38:32.059traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
15:38:32.062traceuranus\rbac\DbManager::checkAccessFromCacheChecking permission: viewSchedule
15:38:32.062traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: StoreKeeper
15:38:32.062traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: Operator
15:38:32.062traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: TechDirector
15:38:32.062traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: Engineer
15:38:32.062traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: Admin
15:38:32.063infoyii\db\Command::querySELECT COUNT(*) FROM "a57be577deb434"."tbl_schedules" WHERE ("is_complete"=FALSE) AND ("created_by"=1001)
15:38:32.128traceuranus\rbac\DbManager::checkAccessFromCacheChecking permission: viewTask
15:38:32.128traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: StoreKeeper
15:38:32.128traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: Engineer
15:38:32.128traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: TechDirector
15:38:32.128traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: ProjectManager
15:38:32.128traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: 电话销售
15:38:32.128traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: Admin
15:38:32.129infoyii\db\Command::querySELECT count(id) FROM "a57be577deb434"."tbl_tasks" WHERE ("status"=0) AND ("head_of"=1001)
15:38:32.130traceuranus\rbac\DbManager::checkAccessFromCacheChecking permission: viewReimbursement
15:38:32.130traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: StoreKeeper
15:38:32.130traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: Operator
15:38:32.130traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: TechDirector
15:38:32.130traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: ProjectManager
15:38:32.130traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: SalesDirector
15:38:32.130traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: Engineer
15:38:32.130traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: Admin
15:38:32.131infoyii\db\Command::querySELECT COUNT(*) FROM "a57be577deb434"."tbl_reimbursements" WHERE ("next_verify_user"=1001) AND ("status" != 0)
15:38:32.135traceuranus\rbac\DbManager::checkAccessFromCacheChecking permission: viewApprove
15:38:32.135traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: StoreKeeper
15:38:32.135traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: Operator
15:38:32.135traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: TechDirector
15:38:32.135traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: SalesDirector
15:38:32.135traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: ProjectManager
15:38:32.135traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: Engineer
15:38:32.135traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: AccountManager
15:38:32.136traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
15:38:32.137traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
15:38:32.137traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
15:38:32.138traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
15:38:32.139infoyii\db\Command::querySELECT "id" FROM "a57be577deb434"."tbl_users" WHERE "user_status"='1' ORDER BY "id"
15:38:32.141infoyii\db\Command::querySELECT COUNT(*) FROM (SELECT r.*, CASE WHEN rvr.status = 0 And next_verify_user = 1001 THEN 1 WHEN rcvr.status = 0 And next_cancel_verify_user = 1001 THEN 2 ELSE 0 END as approvesort FROM "a57be577deb434"."tbl_approves" "r" LEFT JOIN "a57be577deb434"."tbl_users" "u" ON r.created_by = u.id LEFT JOIN "a57be577deb434"."tbl_approve_verify_rels" "rvr" ON rvr.approve_id = r.id LEFT JOIN "a57be577deb434"."tbl_approve_cancel_verify_rels" "rcvr" ON rcvr.approve_id = r.id LEFT JOIN "a57be577deb434"."tbl_clients" "client" ON client.id = r.client_id AND client.deleted = FALSE LEFT JOIN "a57be577deb434"."tbl_term_taxonomy_relationships" "dt1" ON dt1.object_id = r.id AND dt1.term_id = 17 WHERE ("rvr"."user_id"=1001) AND ("r"."status" != 0) AND ("r"."status" IN (1, 5)) AND ((("r"."next_verify_user"=1001) AND ("rvr"."status"=0)) OR (("r"."next_cancel_verify_user"=1001) AND ("rcvr"."status"=0))) GROUP BY "r"."id", "approvesort") "sub"
15:38:32.147traceuranus\rbac\DbManager::checkAccessFromCacheChecking permission: viewPunchApprove
15:38:32.147traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: Admin
15:38:32.147infoyii\db\Command::querySELECT COUNT(*) FROM "a57be577deb434"."tbl_punch_repairs" WHERE ("next_verify_user"=1001) OR ("next_cancel_verify_user"=1001)
15:38:32.159infoyii\db\Command::querySELECT COUNT(*) FROM "a57be577deb434"."tbl_punch_aways" WHERE ("next_verify_user"=1001) OR ("next_cancel_verify_user"=1001)
15:38:32.169infoyii\db\Command::querySELECT COUNT(*) FROM "a57be577deb434"."tbl_punch_overtimes" WHERE ("next_verify_user"=1001) OR ("next_cancel_verify_user"=1001)
15:38:32.171infoyii\db\Command::querySELECT COUNT(*) FROM "a57be577deb434"."tbl_punch_leaves" WHERE ("next_verify_user"=1001) OR ("next_cancel_verify_user"=1001)
15:38:32.172infoyii\db\Command::querySELECT COUNT(*) FROM "a57be577deb434"."tbl_punch_travels" WHERE ("next_verify_user"=1001) OR ("next_cancel_verify_user"=1001)
15:38:32.173traceuranus\rbac\DbManager::checkAccessFromCacheChecking permission: viewErp
15:38:32.173traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: StoreKeeper
15:38:32.173traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: FinancialAudit
15:38:32.173traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: AccountManager
15:38:32.181infoyii\db\Command::querySELECT COUNT(*) FROM ((SELECT * FROM (SELECT (r.id::varchar || 20002::varchar) as id, r.id as id2, r.supplier_id, null::integer as client_id, null::integer as user_id, null::integer as contact_id, r.wrote_date, r.serial_no, 20002 as ticket_type, r.abstract, r.description, r.created_by, r.amount, r.status, null::numeric as settle_amount, false as is_payment_settle, r.created_at, CASE WHEN 1 = r.verify_type THEN rvr.status ELSE ( CASE WHEN r.next_verify_user = 1001 THEN 0 ELSE (CASE WHEN rvr.status = 0 THEN NULL ELSE rvr.status END) END) END as verify_status, CASE WHEN 1 = r.verify_type THEN rsvr.status ELSE ( CASE WHEN r.next_stop_verify_user = 1001 THEN 0 ELSE (CASE WHEN rsvr.status = 0 THEN NULL ELSE rsvr.status END) END) END as stop_verify_status, null::integer as cancel_verify_status FROM "a57be577deb434"."tbl_erp_purchase_inbounds" "r" LEFT JOIN "a57be577deb434"."tbl_erp_purchase_inbound_verify_rels" "rvr" ON rvr.erp_purchase_inbound_id = r.id AND rvr.user_id = 1001 LEFT JOIN "a57be577deb434"."tbl_erp_purchase_inbound_stop_verify_rels" "rsvr" ON rsvr.erp_purchase_inbound_id = r.id AND rsvr.user_id = 1001 WHERE "r"."status" != 0 GROUP BY "r"."id", "rvr"."status", "rsvr"."status") "sub") UNION ALL ( SELECT (r.id::varchar || 20001::varchar) as id, r.id as id2, r.supplier_id, null::integer as client_id, null::integer as user_id, null::integer as contact_id, r.wrote_date, r.serial_no, 20001 as ticket_type, r.abstract, r.description, r.created_by, r.amount, r.status, null::numeric as settle_amount, false as is_payment_settle, r.created_at, CASE WHEN 1 = r.verify_type THEN rvr.status ELSE ( CASE WHEN r.next_verify_user = 1001 THEN 0 ELSE (CASE WHEN rvr.status = 0 THEN NULL ELSE rvr.status END) END) END as verify_status, CASE WHEN 1 = r.verify_type THEN rsvr.status ELSE ( CASE WHEN r.next_stop_verify_user = 1001 THEN 0 ELSE (CASE WHEN rsvr.status = 0 THEN NULL ELSE rsvr.status END) END) END as stop_verify_status, CASE WHEN 1 = r.verify_type THEN rcvr.status ELSE ( CASE WHEN r.next_cancel_verify_user = 1001 THEN 0 ELSE (CASE WHEN rcvr.status = 0 THEN NULL ELSE rcvr.status END) END) END as cancel_verify_status FROM "a57be577deb434"."tbl_erp_purchase_orders" "r" LEFT JOIN "a57be577deb434"."tbl_erp_purchase_order_verify_rels" "rvr" ON rvr.erp_purchase_order_id = r.id AND rvr.user_id = 1001 LEFT JOIN "a57be577deb434"."tbl_erp_purchase_order_stop_verify_rels" "rsvr" ON rsvr.erp_purchase_order_id = r.id AND rsvr.user_id = 1001 LEFT JOIN "a57be577deb434"."tbl_erp_purchase_order_cancel_verify_rels" "rcvr" ON rcvr.erp_purchase_order_id = r.id AND rcvr.user_id = 1001 WHERE "r"."status" != 0 GROUP BY "r"."id", "rvr"."status", "rsvr"."status", "rcvr"."status" ) UNION ALL ( SELECT (r.id::varchar || 20003::varchar) as id, r.id as id2, r.supplier_id, null::integer as client_id, null::integer as user_id, null::integer as contact_id, r.wrote_date, r.serial_no, 20003 as ticket_type, r.abstract, r.description, r.created_by, r.amount, r.status, null::numeric as settle_amount, false as is_payment_settle, r.created_at, CASE WHEN 1 = r.verify_type THEN rvr.status ELSE ( CASE WHEN r.next_verify_user = 1001 THEN 0 ELSE (CASE WHEN rvr.status = 0 THEN NULL ELSE rvr.status END) END) END as verify_status, CASE WHEN 1 = r.verify_type THEN rsvr.status ELSE ( CASE WHEN r.next_stop_verify_user = 1001 THEN 0 ELSE (CASE WHEN rsvr.status = 0 THEN NULL ELSE rsvr.status END) END) END as stop_verify_status, null::integer as cancel_verify_status FROM "a57be577deb434"."tbl_erp_purchase_returns" "r" LEFT JOIN "a57be577deb434"."tbl_erp_purchase_return_verify_rels" "rvr" ON rvr.erp_purchase_return_id = r.id AND rvr.user_id = 1001 LEFT JOIN "a57be577deb434"."tbl_erp_purchase_return_stop_verify_rels" "rsvr" ON rsvr.erp_purchase_return_id = r.id AND rsvr.user_id = 1001 WHERE "r"."status" != 0 GROUP BY "r"."id", "rvr"."status", "rsvr"."status" ) UNION ALL ( SELECT (r.id::varchar || 20004::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, r.wrote_date, r.serial_no, 20004 as ticket_type, r.abstract, r.description, r.created_by, r.amount, r.status, null::numeric as settle_amount, false as is_payment_settle, r.created_at, CASE WHEN 1 = r.verify_type THEN rvr.status ELSE ( CASE WHEN r.next_verify_user = 1001 THEN 0 ELSE (CASE WHEN rvr.status = 0 THEN NULL ELSE rvr.status END) END) END as verify_status, CASE WHEN 1 = r.verify_type THEN rsvr.status ELSE ( CASE WHEN r.next_stop_verify_user = 1001 THEN 0 ELSE (CASE WHEN rsvr.status = 0 THEN NULL ELSE rsvr.status END) END) END as stop_verify_status, null::integer as cancel_verify_status FROM "a57be577deb434"."tbl_erp_inventory_losts" "r" LEFT JOIN "a57be577deb434"."tbl_erp_inventory_lost_verify_rels" "rvr" ON rvr.erp_inventory_lost_id = r.id AND rvr.user_id = 1001 LEFT JOIN "a57be577deb434"."tbl_erp_inventory_lost_stop_verify_rels" "rsvr" ON rsvr.erp_inventory_lost_id = r.id AND rsvr.user_id = 1001 WHERE "r"."status" != 0 GROUP BY "r"."id", "rvr"."status", "rsvr"."status" ) UNION ALL ( SELECT (r.id::varchar || 20031::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, r.wrote_date, r.serial_no, 20031 as ticket_type, r.abstract, r.description, r.created_by, r.amount, r.status, null::numeric as settle_amount, false as is_payment_settle, r.created_at, CASE WHEN 1 = r.verify_type THEN rvr.status ELSE ( CASE WHEN r.next_verify_user = 1001 THEN 0 ELSE (CASE WHEN rvr.status = 0 THEN NULL ELSE rvr.status END) END) END as verify_status, CASE WHEN 1 = r.verify_type THEN rsvr.status ELSE ( CASE WHEN r.next_stop_verify_user = 1001 THEN 0 ELSE (CASE WHEN rsvr.status = 0 THEN NULL ELSE rsvr.status END) END) END as stop_verify_status, null::integer as cancel_verify_status FROM "a57be577deb434"."tbl_erp_inventory_overflows" "r" LEFT JOIN "a57be577deb434"."tbl_erp_inventory_overflow_verify_rels" "rvr" ON rvr.erp_inventory_overflow_id = r.id AND rvr.user_id = 1001 LEFT JOIN "a57be577deb434"."tbl_erp_inventory_overflow_stop_verify_rels" "rsvr" ON rsvr.erp_inventory_overflow_id = r.id AND rsvr.user_id = 1001 WHERE "r"."status" != 0 GROUP BY "r"."id", "rvr"."status", "rsvr"."status" ) UNION ALL ( SELECT (r.id::varchar || 20005::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, r.wrote_date, r.serial_no, 20005 as ticket_type, r.abstract, r.description, r.created_by, r.amount, r.status, null::numeric as settle_amount, false as is_payment_settle, r.created_at, CASE WHEN 1 = r.verify_type THEN rvr.status ELSE ( CASE WHEN r.next_verify_user = 1001 THEN 0 ELSE (CASE WHEN rvr.status = 0 THEN NULL ELSE rvr.status END) END) END as verify_status, CASE WHEN 1 = r.verify_type THEN rsvr.status ELSE ( CASE WHEN r.next_stop_verify_user = 1001 THEN 0 ELSE (CASE WHEN rsvr.status = 0 THEN NULL ELSE rsvr.status END) END) END as stop_verify_status, null::integer as cancel_verify_status FROM "a57be577deb434"."tbl_erp_inventory_builds" "r" LEFT JOIN "a57be577deb434"."tbl_erp_inventory_build_verify_rels" "rvr" ON rvr.erp_inventory_build_id = r.id AND rvr.user_id = 1001 LEFT JOIN "a57be577deb434"."tbl_erp_inventory_build_stop_verify_rels" "rsvr" ON rsvr.erp_inventory_build_id = r.id AND rsvr.user_id = 1001 WHERE "r"."status" != 0 GROUP BY "r"."id", "rvr"."status", "rsvr"."status" ) UNION ALL ( SELECT (r.id::varchar || 20030::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, r.wrote_date, r.serial_no, 20030 as ticket_type, r.abstract, r.description, r.created_by, r.amount, r.status, null::numeric as settle_amount, false as is_payment_settle, r.created_at, CASE WHEN 1 = r.verify_type THEN rvr.status ELSE ( CASE WHEN r.next_verify_user = 1001 THEN 0 ELSE (CASE WHEN rvr.status = 0 THEN NULL ELSE rvr.status END) END) END as verify_status, CASE WHEN 1 = r.verify_type THEN rsvr.status ELSE ( CASE WHEN r.next_stop_verify_user = 1001 THEN 0 ELSE (CASE WHEN rsvr.status = 0 THEN NULL ELSE rsvr.status END) END) END as stop_verify_status, null::integer as cancel_verify_status FROM "a57be577deb434"."tbl_erp_inventory_disassembles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_inventory_disassemble_verify_rels" "rvr" ON rvr.erp_inventory_disassemble_id = r.id AND rvr.user_id = 1001 LEFT JOIN "a57be577deb434"."tbl_erp_inventory_disassemble_stop_verify_rels" "rsvr" ON rsvr.erp_inventory_disassemble_id = r.id AND rsvr.user_id = 1001 WHERE "r"."status" != 0 GROUP BY "r"."id", "rvr"."status", "rsvr"."status" ) UNION ALL ( SELECT (r.id::varchar || 20007::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.wrote_date, r.serial_no, 20007 as ticket_type, r.abstract, r.description, r.created_by, r.amount, r.status, null::numeric as settle_amount, false as is_payment_settle, r.created_at, CASE WHEN 1 = r.verify_type THEN rvr.status ELSE ( CASE WHEN r.next_verify_user = 1001 THEN 0 ELSE (CASE WHEN rvr.status = 0 THEN NULL ELSE rvr.status END) END) END as verify_status, CASE WHEN 1 = r.verify_type THEN rsvr.status ELSE ( CASE WHEN r.next_stop_verify_user = 1001 THEN 0 ELSE (CASE WHEN rsvr.status = 0 THEN NULL ELSE rsvr.status END) END) END as stop_verify_status, CASE WHEN 1 = r.verify_type THEN rcvr.status ELSE ( CASE WHEN r.next_cancel_verify_user = 1001 THEN 0 ELSE (CASE WHEN rcvr.status = 0 THEN NULL ELSE rcvr.status END) END) END as cancel_verify_status FROM "a57be577deb434"."tbl_erp_sales_orders" "r" LEFT JOIN "a57be577deb434"."tbl_erp_sales_order_verify_rels" "rvr" ON rvr.erp_sales_order_id = r.id AND rvr.user_id = 1001 LEFT JOIN "a57be577deb434"."tbl_erp_sales_order_stop_verify_rels" "rsvr" ON rsvr.erp_sales_order_id = r.id AND rsvr.user_id = 1001 LEFT JOIN "a57be577deb434"."tbl_erp_sales_order_cancel_verify_rels" "rcvr" ON rcvr.erp_sales_order_id = r.id AND rcvr.user_id = 1001 WHERE "r"."status" != 0 GROUP BY "r"."id", "rvr"."status", "rsvr"."status", "rcvr"."status" ) UNION ALL ( SELECT (r.id::varchar || 20008::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.wrote_date, r.serial_no, 20008 as ticket_type, r.abstract, r.description, r.created_by, r.amount, r.status, null::numeric as settle_amount, false as is_payment_settle, r.created_at, CASE WHEN 1 = r.verify_type THEN rvr.status ELSE ( CASE WHEN r.next_verify_user = 1001 THEN 0 ELSE (CASE WHEN rvr.status = 0 THEN NULL ELSE rvr.status END) END) END as verify_status, CASE WHEN 1 = r.verify_type THEN rsvr.status ELSE ( CASE WHEN r.next_stop_verify_user = 1001 THEN 0 ELSE (CASE WHEN rsvr.status = 0 THEN NULL ELSE rsvr.status END) END) END as stop_verify_status, null::integer as cancel_verify_status FROM "a57be577deb434"."tbl_erp_sales_outbounds" "r" LEFT JOIN "a57be577deb434"."tbl_erp_sales_outbound_verify_rels" "rvr" ON rvr.erp_sales_outbound_id = r.id AND rvr.user_id = 1001 LEFT JOIN "a57be577deb434"."tbl_erp_sales_outbound_stop_verify_rels" "rsvr" ON rsvr.erp_sales_outbound_id = r.id AND rsvr.user_id = 1001 WHERE "r"."status" != 0 GROUP BY "r"."id", "rvr"."status", "rsvr"."status" ) UNION ALL ( SELECT (r.id::varchar || 20009::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.wrote_date, r.serial_no, 20009 as ticket_type, r.abstract, r.description, r.created_by, r.amount, r.status, null::numeric as settle_amount, false as is_payment_settle, r.created_at, CASE WHEN 1 = r.verify_type THEN rvr.status ELSE ( CASE WHEN r.next_verify_user = 1001 THEN 0 ELSE (CASE WHEN rvr.status = 0 THEN NULL ELSE rvr.status END) END) END as verify_status, CASE WHEN 1 = r.verify_type THEN rsvr.status ELSE ( CASE WHEN r.next_stop_verify_user = 1001 THEN 0 ELSE (CASE WHEN rsvr.status = 0 THEN NULL ELSE rsvr.status END) END) END as stop_verify_status, null::integer as cancel_verify_status FROM "a57be577deb434"."tbl_erp_sales_returns" "r" LEFT JOIN "a57be577deb434"."tbl_erp_sales_return_verify_rels" "rvr" ON rvr.erp_sales_return_id = r.id AND rvr.user_id = 1001 LEFT JOIN "a57be577deb434"."tbl_erp_sales_return_stop_verify_rels" "rsvr" ON rsvr.erp_sales_return_id = r.id AND rsvr.user_id = 1001 WHERE "r"."status" != 0 GROUP BY "r"."id", "rvr"."status", "rsvr"."status" ) UNION ALL ( SELECT (r.id::varchar || 20010::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.wrote_date, r.serial_no, 20010 as ticket_type, r.abstract, r.description, r.created_by, r.amount, r.status, null::numeric as settle_amount, false as is_payment_settle, r.created_at, CASE WHEN 1 = r.verify_type THEN rvr.status ELSE ( CASE WHEN r.next_verify_user = 1001 THEN 0 ELSE (CASE WHEN rvr.status = 0 THEN NULL ELSE rvr.status END) END) END as verify_status, CASE WHEN 1 = r.verify_type THEN rsvr.status ELSE ( CASE WHEN r.next_stop_verify_user = 1001 THEN 0 ELSE (CASE WHEN rsvr.status = 0 THEN NULL ELSE rsvr.status END) END) END as stop_verify_status, null::integer as cancel_verify_status FROM "a57be577deb434"."tbl_erp_purchase_gifts" "r" LEFT JOIN "a57be577deb434"."tbl_erp_purchase_gift_verify_rels" "rvr" ON rvr.erp_purchase_gift_id = r.id AND rvr.user_id = 1001 LEFT JOIN "a57be577deb434"."tbl_erp_purchase_gift_stop_verify_rels" "rsvr" ON rsvr.erp_purchase_gift_id = r.id AND rsvr.user_id = 1001 WHERE "r"."status" != 0 GROUP BY "r"."id", "rvr"."status", "rsvr"."status" ) 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.wrote_date, r.serial_no, 20011 as ticket_type, r.abstract, r.description, r.created_by, r.amount, r.status, null::numeric as settle_amount, false as is_payment_settle, r.created_at, CASE WHEN 1 = r.verify_type THEN rvr.status ELSE ( CASE WHEN r.next_verify_user = 1001 THEN 0 ELSE (CASE WHEN rvr.status = 0 THEN NULL ELSE rvr.status END) END) END as verify_status, CASE WHEN 1 = r.verify_type THEN rsvr.status ELSE ( CASE WHEN r.next_stop_verify_user = 1001 THEN 0 ELSE (CASE WHEN rsvr.status = 0 THEN NULL ELSE rsvr.status END) END) END as stop_verify_status, null::integer as cancel_verify_status FROM "a57be577deb434"."tbl_erp_sales_gifts" "r" LEFT JOIN "a57be577deb434"."tbl_erp_sales_gift_verify_rels" "rvr" ON rvr.erp_sales_gift_id = r.id AND rvr.user_id = 1001 LEFT JOIN "a57be577deb434"."tbl_erp_sales_gift_stop_verify_rels" "rsvr" ON rsvr.erp_sales_gift_id = r.id AND rsvr.user_id = 1001 WHERE "r"."status" != 0 GROUP BY "r"."id", "rvr"."status", "rsvr"."status" ) UNION ALL ( SELECT (r.id::varchar || 20013::varchar) as id, r.id as id2, r.supplier_id as supplier_id, r.client_id as client_id, r.user_id as user_id, r.contact_id as contact_id, r.wrote_date, r.serial_no, 20013 as ticket_type, r.abstract, r.description, r.created_by, r.amount, r.status, r.settle_amount, false as is_payment_settle, r.created_at, CASE WHEN 1 = r.verify_type THEN rvr.status ELSE ( CASE WHEN r.next_verify_user = 1001 THEN 0 ELSE (CASE WHEN rvr.status = 0 THEN NULL ELSE rvr.status END) END) END as verify_status, CASE WHEN 1 = r.verify_type THEN rsvr.status ELSE ( CASE WHEN r.next_stop_verify_user = 1001 THEN 0 ELSE (CASE WHEN rsvr.status = 0 THEN NULL ELSE rsvr.status END) END) END as stop_verify_status, null::integer as cancel_verify_status FROM "a57be577deb434"."tbl_erp_collect_tickets" "r" LEFT JOIN "a57be577deb434"."tbl_erp_collect_ticket_verify_rels" "rvr" ON rvr.erp_collect_ticket_id = r.id AND rvr.user_id = 1001 LEFT JOIN "a57be577deb434"."tbl_erp_collect_ticket_stop_verify_rels" "rsvr" ON rsvr.erp_collect_ticket_id = r.id AND rsvr.user_id = 1001 WHERE "r"."status" != 0 GROUP BY "r"."id", "rvr"."status", "rsvr"."status" ) UNION ALL ( SELECT (r.id::varchar || 20012::varchar) as id, r.id as id2, r.supplier_id as supplier_id, r.client_id as client_id, r.user_id as user_id, r.contact_id as contact_id, r.wrote_date, r.serial_no, 20012 as ticket_type, r.abstract, r.description, r.created_by, r.amount, r.status, r.settle_amount, r.is_payment_settle, r.created_at, CASE WHEN 1 = r.verify_type THEN rvr.status ELSE ( CASE WHEN r.next_verify_user = 1001 THEN 0 ELSE (CASE WHEN rvr.status = 0 THEN NULL ELSE rvr.status END) END) END as verify_status, CASE WHEN 1 = r.verify_type THEN rsvr.status ELSE ( CASE WHEN r.next_stop_verify_user = 1001 THEN 0 ELSE (CASE WHEN rsvr.status = 0 THEN NULL ELSE rsvr.status END) END) END as stop_verify_status, null::integer as cancel_verify_status FROM "a57be577deb434"."tbl_erp_payment_tickets" "r" LEFT JOIN "a57be577deb434"."tbl_erp_payment_ticket_verify_rels" "rvr" ON rvr.erp_payment_ticket_id = r.id AND rvr.user_id = 1001 LEFT JOIN "a57be577deb434"."tbl_erp_payment_ticket_stop_verify_rels" "rsvr" ON rsvr.erp_payment_ticket_id = r.id AND rsvr.user_id = 1001 WHERE "r"."status" != 0 GROUP BY "r"."id", "rvr"."status", "rsvr"."status" ) 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, r.contact_id as contact_id, r.wrote_date, r.serial_no, 20014 as ticket_type, r.abstract, r.description, r.created_by, r.amount, r.status, r.settle_amount, false as is_payment_settle, r.created_at, CASE WHEN 1 = r.verify_type THEN rvr.status ELSE ( CASE WHEN r.next_verify_user = 1001 THEN 0 ELSE (CASE WHEN rvr.status = 0 THEN NULL ELSE rvr.status END) END) END as verify_status, CASE WHEN 1 = r.verify_type THEN rsvr.status ELSE ( CASE WHEN r.next_stop_verify_user = 1001 THEN 0 ELSE (CASE WHEN rsvr.status = 0 THEN NULL ELSE rsvr.status END) END) END as stop_verify_status, null::integer as cancel_verify_status FROM "a57be577deb434"."tbl_erp_cost_tickets" "r" LEFT JOIN "a57be577deb434"."tbl_erp_cost_ticket_verify_rels" "rvr" ON rvr.erp_cost_ticket_id = r.id AND rvr.user_id = 1001 LEFT JOIN "a57be577deb434"."tbl_erp_cost_ticket_stop_verify_rels" "rsvr" ON rsvr.erp_cost_ticket_id = r.id AND rsvr.user_id = 1001 WHERE "r"."status" != 0 GROUP BY "r"."id", "rvr"."status", "rsvr"."status" ) UNION ALL ( SELECT (r.id::varchar || 20015::varchar) as id, r.id as id2, r.supplier_id as supplier_id, r.client_id as client_id, r.user_id as user_id, r.contact_id as contact_id, r.wrote_date, r.serial_no, 20015 as ticket_type, r.abstract, r.description, r.created_by, r.amount, r.status, r.settle_amount, false as is_payment_settle, r.created_at, CASE WHEN 1 = r.verify_type THEN rvr.status ELSE ( CASE WHEN r.next_verify_user = 1001 THEN 0 ELSE (CASE WHEN rvr.status = 0 THEN NULL ELSE rvr.status END) END) END as verify_status, CASE WHEN 1 = r.verify_type THEN rsvr.status ELSE ( CASE WHEN r.next_stop_verify_user = 1001 THEN 0 ELSE (CASE WHEN rsvr.status = 0 THEN NULL ELSE rsvr.status END) END) END as stop_verify_status, null::integer as cancel_verify_status FROM "a57be577deb434"."tbl_erp_other_income_tickets" "r" LEFT JOIN "a57be577deb434"."tbl_erp_other_income_ticket_verify_rels" "rvr" ON rvr.erp_other_income_ticket_id = r.id AND rvr.user_id = 1001 LEFT JOIN "a57be577deb434"."tbl_erp_other_income_ticket_stop_verify_rels" "rsvr" ON rsvr.erp_other_income_ticket_id = r.id AND rsvr.user_id = 1001 WHERE "r"."status" != 0 GROUP BY "r"."id", "rvr"."status", "rsvr"."status" ) UNION ALL ( SELECT (r.id::varchar || 20016::varchar) as id, r.id as id2, r.supplier_id, r.client_id, null::integer as user_id, null::integer as contact_id, r.wrote_date, r.serial_no, 20016 as ticket_type, r.abstract, r.description, r.created_by, r.amount, r.status, null::numeric as settle_amount, false as is_payment_settle, r.created_at, CASE WHEN 1 = r.verify_type THEN rvr.status ELSE ( CASE WHEN r.next_verify_user = 1001 THEN 0 ELSE (CASE WHEN rvr.status = 0 THEN NULL ELSE rvr.status END) END) END as verify_status, CASE WHEN 1 = r.verify_type THEN rsvr.status ELSE ( CASE WHEN r.next_stop_verify_user = 1001 THEN 0 ELSE (CASE WHEN rsvr.status = 0 THEN NULL ELSE rsvr.status END) END) END as stop_verify_status, null::integer as cancel_verify_status FROM "a57be577deb434"."tbl_erp_cost_convert_tickets" "r" LEFT JOIN "a57be577deb434"."tbl_erp_cost_convert_ticket_verify_rels" "rvr" ON rvr.erp_cost_convert_ticket_id = r.id AND rvr.user_id = 1001 LEFT JOIN "a57be577deb434"."tbl_erp_cost_convert_ticket_stop_verify_rels" "rsvr" ON rsvr.erp_cost_convert_ticket_id = r.id AND rsvr.user_id = 1001 WHERE "r"."status" != 0 GROUP BY "r"."id", "rvr"."status", "rsvr"."status" ) UNION ALL ( SELECT (r.id::varchar || 20017::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, r.wrote_date, r.serial_no, 20017 as ticket_type, r.abstract, r.description, r.created_by, r.amount, r.status, null::numeric as settle_amount, false as is_payment_settle, r.created_at, CASE WHEN 1 = r.verify_type THEN rvr.status ELSE ( CASE WHEN r.next_verify_user = 1001 THEN 0 ELSE (CASE WHEN rvr.status = 0 THEN NULL ELSE rvr.status END) END) END as verify_status, CASE WHEN 1 = r.verify_type THEN rsvr.status ELSE ( CASE WHEN r.next_stop_verify_user = 1001 THEN 0 ELSE (CASE WHEN rsvr.status = 0 THEN NULL ELSE rsvr.status END) END) END as stop_verify_status, null::integer as cancel_verify_status FROM "a57be577deb434"."tbl_erp_bank_transfer_tickets" "r" LEFT JOIN "a57be577deb434"."tbl_erp_bank_transfer_ticket_verify_rels" "rvr" ON rvr.erp_bank_transfer_ticket_id = r.id AND rvr.user_id = 1001 LEFT JOIN "a57be577deb434"."tbl_erp_bank_transfer_ticket_stop_verify_rels" "rsvr" ON rsvr.erp_bank_transfer_ticket_id = r.id AND rsvr.user_id = 1001 WHERE "r"."status" != 0 GROUP BY "r"."id", "rvr"."status", "rsvr"."status" ) 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, r.wrote_date, r.serial_no, 20018 as ticket_type, r.abstract, r.description, r.created_by, r.amount, r.status, r.settle_amount, r.is_payment_settle, r.created_at, CASE WHEN 1 = r.verify_type THEN rvr.status ELSE ( CASE WHEN r.next_verify_user = 1001 THEN 0 ELSE (CASE WHEN rvr.status = 0 THEN NULL ELSE rvr.status END) END) END as verify_status, CASE WHEN 1 = r.verify_type THEN rsvr.status ELSE ( CASE WHEN r.next_stop_verify_user = 1001 THEN 0 ELSE (CASE WHEN rsvr.status = 0 THEN NULL ELSE rsvr.status END) END) END as stop_verify_status, null::integer as cancel_verify_status FROM "a57be577deb434"."tbl_erp_cash_cost_tickets" "r" LEFT JOIN "a57be577deb434"."tbl_erp_cash_cost_ticket_verify_rels" "rvr" ON rvr.erp_cash_cost_ticket_id = r.id AND rvr.user_id = 1001 LEFT JOIN "a57be577deb434"."tbl_erp_cash_cost_ticket_stop_verify_rels" "rsvr" ON rsvr.erp_cash_cost_ticket_id = r.id AND rsvr.user_id = 1001 WHERE "r"."status" != 0 GROUP BY "r"."id", "rvr"."status", "rsvr"."status" ) UNION ALL ( SELECT (r.id::varchar || 20019::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.wrote_date, r.serial_no, 20019 as ticket_type, r.abstract, r.description, r.created_by, r.amount, r.status, r.settle_amount, r.is_payment_settle, r.created_at, CASE WHEN 1 = r.verify_type THEN rvr.status ELSE ( CASE WHEN r.next_verify_user = 1001 THEN 0 ELSE (CASE WHEN rvr.status = 0 THEN NULL ELSE rvr.status END) END) END as verify_status, CASE WHEN 1 = r.verify_type THEN rsvr.status ELSE ( CASE WHEN r.next_stop_verify_user = 1001 THEN 0 ELSE (CASE WHEN rsvr.status = 0 THEN NULL ELSE rsvr.status END) END) END as stop_verify_status, null::integer as cancel_verify_status FROM "a57be577deb434"."tbl_erp_advance_payment_tickets" "r" LEFT JOIN "a57be577deb434"."tbl_erp_advance_payment_ticket_verify_rels" "rvr" ON rvr.erp_advance_payment_ticket_id = r.id AND rvr.user_id = 1001 LEFT JOIN "a57be577deb434"."tbl_erp_advance_payment_ticket_stop_verify_rels" "rsvr" ON rsvr.erp_advance_payment_ticket_id = r.id AND rsvr.user_id = 1001 WHERE "r"."status" != 0 GROUP BY "r"."id", "rvr"."status", "rsvr"."status" ) UNION ALL ( SELECT (r.id::varchar || 20020::varchar) as id, r.id as id2, r.supplier_id as supplier_id, r.client_id as client_id, r.user_id as user_id, r.contact_id as contact_id, r.wrote_date, r.serial_no, 20020 as ticket_type, r.abstract, r.description, r.created_by, r.amount, r.status, r.settle_amount, false as is_payment_settle, r.created_at, CASE WHEN 1 = r.verify_type THEN rvr.status ELSE ( CASE WHEN r.next_verify_user = 1001 THEN 0 ELSE (CASE WHEN rvr.status = 0 THEN NULL ELSE rvr.status END) END) END as verify_status, CASE WHEN 1 = r.verify_type THEN rsvr.status ELSE ( CASE WHEN r.next_stop_verify_user = 1001 THEN 0 ELSE (CASE WHEN rsvr.status = 0 THEN NULL ELSE rsvr.status END) END) END as stop_verify_status, null::integer as cancel_verify_status FROM "a57be577deb434"."tbl_erp_other_payment_tickets" "r" LEFT JOIN "a57be577deb434"."tbl_erp_other_payment_ticket_verify_rels" "rvr" ON rvr.erp_other_payment_ticket_id = r.id AND rvr.user_id = 1001 LEFT JOIN "a57be577deb434"."tbl_erp_other_payment_ticket_stop_verify_rels" "rsvr" ON rsvr.erp_other_payment_ticket_id = r.id AND rsvr.user_id = 1001 WHERE "r"."status" != 0 GROUP BY "r"."id", "rvr"."status", "rsvr"."status" ) UNION ALL ( SELECT (r.id::varchar || 20021::varchar) as id, r.id as id2, r.supplier_id as supplier_id, r.client_id as client_id, r.user_id as user_id, r.contact_id as contact_id, r.wrote_date, r.serial_no, 20021 as ticket_type, r.abstract, r.description, r.created_by, r.amount, r.status, r.settle_amount, false as is_payment_settle, r.created_at, CASE WHEN 1 = r.verify_type THEN rvr.status ELSE ( CASE WHEN r.next_verify_user = 1001 THEN 0 ELSE (CASE WHEN rvr.status = 0 THEN NULL ELSE rvr.status END) END) END as verify_status, CASE WHEN 1 = r.verify_type THEN rsvr.status ELSE ( CASE WHEN r.next_stop_verify_user = 1001 THEN 0 ELSE (CASE WHEN rsvr.status = 0 THEN NULL ELSE rsvr.status END) END) END as stop_verify_status, null::integer as cancel_verify_status FROM "a57be577deb434"."tbl_erp_other_collect_tickets" "r" LEFT JOIN "a57be577deb434"."tbl_erp_other_collect_ticket_verify_rels" "rvr" ON rvr.erp_other_collect_ticket_id = r.id AND rvr.user_id = 1001 LEFT JOIN "a57be577deb434"."tbl_erp_other_collect_ticket_stop_verify_rels" "rsvr" ON rsvr.erp_other_collect_ticket_id = r.id AND rsvr.user_id = 1001 WHERE "r"."status" != 0 GROUP BY "r"."id", "rvr"."status", "rsvr"."status" ) UNION ALL ( SELECT (r.id::varchar || 20022::varchar) as id, r.id as id2, r.supplier_id, null::integer as client_id, null::integer as user_id, null::integer as contact_id, r.wrote_date, r.serial_no, 20022 as ticket_type, r.abstract, r.description, r.created_by, r.amount, r.status, null::numeric as settle_amount, false as is_payment_settle, r.created_at, CASE WHEN 1 = r.verify_type THEN rvr.status ELSE ( CASE WHEN r.next_verify_user = 1001 THEN 0 ELSE (CASE WHEN rvr.status = 0 THEN NULL ELSE rvr.status END) END) END as verify_status, CASE WHEN 1 = r.verify_type THEN rsvr.status ELSE ( CASE WHEN r.next_stop_verify_user = 1001 THEN 0 ELSE (CASE WHEN rsvr.status = 0 THEN NULL ELSE rsvr.status END) END) END as stop_verify_status, CASE WHEN 1 = r.verify_type THEN rcvr.status ELSE ( CASE WHEN r.next_cancel_verify_user = 1001 THEN 0 ELSE (CASE WHEN rcvr.status = 0 THEN NULL ELSE rcvr.status END) END) END as cancel_verify_status FROM "a57be577deb434"."tbl_erp_purchase_costs" "r" LEFT JOIN "a57be577deb434"."tbl_erp_purchase_cost_verify_rels" "rvr" ON rvr.erp_purchase_cost_id = r.id AND rvr.user_id = 1001 LEFT JOIN "a57be577deb434"."tbl_erp_purchase_cost_stop_verify_rels" "rsvr" ON rsvr.erp_purchase_cost_id = r.id AND rsvr.user_id = 1001 LEFT JOIN "a57be577deb434"."tbl_erp_purchase_cost_cancel_verify_rels" "rcvr" ON rcvr.erp_purchase_cost_id = r.id AND rcvr.user_id = 1001 WHERE "r"."status" != 0 GROUP BY "r"."id", "rvr"."status", "rsvr"."status", "rcvr"."status" ) 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, r.wrote_date, r.serial_no, 20023 as ticket_type, r.abstract, r.description, r.created_by, r.amount, r.status, r.settle_amount, r.is_payment_settle, r.created_at, CASE WHEN 1 = r.verify_type THEN rvr.status ELSE ( CASE WHEN r.next_verify_user = 1001 THEN 0 ELSE (CASE WHEN rvr.status = 0 THEN NULL ELSE rvr.status END) END) END as verify_status, CASE WHEN 1 = r.verify_type THEN rsvr.status ELSE ( CASE WHEN r.next_stop_verify_user = 1001 THEN 0 ELSE (CASE WHEN rsvr.status = 0 THEN NULL ELSE rsvr.status END) END) END as stop_verify_status, null::integer as cancel_verify_status FROM "a57be577deb434"."tbl_erp_wage_tickets" "r" LEFT JOIN "a57be577deb434"."tbl_erp_wage_ticket_verify_rels" "rvr" ON rvr.erp_wage_ticket_id = r.id AND rvr.user_id = 1001 LEFT JOIN "a57be577deb434"."tbl_erp_wage_ticket_stop_verify_rels" "rsvr" ON rsvr.erp_wage_ticket_id = r.id AND rsvr.user_id = 1001 WHERE "r"."status" != 0 GROUP BY "r"."id", "rvr"."status", "rsvr"."status" ) 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, r.wrote_date, r.serial_no, 20024 as ticket_type, r.abstract, r.description, r.created_by, r.amount, r.status, r.settle_amount, r.is_payment_settle, r.created_at, CASE WHEN 1 = r.verify_type THEN rvr.status ELSE ( CASE WHEN r.next_verify_user = 1001 THEN 0 ELSE (CASE WHEN rvr.status = 0 THEN NULL ELSE rvr.status END) END) END as verify_status, CASE WHEN 1 = r.verify_type THEN rsvr.status ELSE ( CASE WHEN r.next_stop_verify_user = 1001 THEN 0 ELSE (CASE WHEN rsvr.status = 0 THEN NULL ELSE rsvr.status END) END) END as stop_verify_status, null::integer as cancel_verify_status FROM "a57be577deb434"."tbl_erp_social_insurances" "r" LEFT JOIN "a57be577deb434"."tbl_erp_social_insurance_verify_rels" "rvr" ON rvr.erp_social_insurance_id = r.id AND rvr.user_id = 1001 LEFT JOIN "a57be577deb434"."tbl_erp_social_insurance_stop_verify_rels" "rsvr" ON rsvr.erp_social_insurance_id = r.id AND rsvr.user_id = 1001 WHERE "r"."status" != 0 GROUP BY "r"."id", "rvr"."status", "rsvr"."status" ) 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, r.wrote_date, r.serial_no, 20025 as ticket_type, r.abstract, r.description, r.created_by, r.amount, r.status, r.settle_amount, r.is_payment_settle, r.created_at, CASE WHEN 1 = r.verify_type THEN rvr.status ELSE ( CASE WHEN r.next_verify_user = 1001 THEN 0 ELSE (CASE WHEN rvr.status = 0 THEN NULL ELSE rvr.status END) END) END as verify_status, CASE WHEN 1 = r.verify_type THEN rsvr.status ELSE ( CASE WHEN r.next_stop_verify_user = 1001 THEN 0 ELSE (CASE WHEN rsvr.status = 0 THEN NULL ELSE rsvr.status END) END) END as stop_verify_status, null::integer as cancel_verify_status FROM "a57be577deb434"."tbl_erp_provident_funds" "r" LEFT JOIN "a57be577deb434"."tbl_erp_provident_fund_verify_rels" "rvr" ON rvr.erp_provident_fund_id = r.id AND rvr.user_id = 1001 LEFT JOIN "a57be577deb434"."tbl_erp_provident_fund_stop_verify_rels" "rsvr" ON rsvr.erp_provident_fund_id = r.id AND rsvr.user_id = 1001 WHERE "r"."status" != 0 GROUP BY "r"."id", "rvr"."status", "rsvr"."status" ) 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, r.wrote_date, r.serial_no, 20026 as ticket_type, r.abstract, r.description, r.created_by, r.amount, r.status, r.settle_amount, r.is_payment_settle, r.created_at, CASE WHEN 1 = r.verify_type THEN rvr.status ELSE ( CASE WHEN r.next_verify_user = 1001 THEN 0 ELSE (CASE WHEN rvr.status = 0 THEN NULL ELSE rvr.status END) END) END as verify_status, CASE WHEN 1 = r.verify_type THEN rsvr.status ELSE ( CASE WHEN r.next_stop_verify_user = 1001 THEN 0 ELSE (CASE WHEN rsvr.status = 0 THEN NULL ELSE rsvr.status END) END) END as stop_verify_status, null::integer as cancel_verify_status FROM "a57be577deb434"."tbl_erp_personal_taxs" "r" LEFT JOIN "a57be577deb434"."tbl_erp_personal_tax_verify_rels" "rvr" ON rvr.erp_personal_tax_id = r.id AND rvr.user_id = 1001 LEFT JOIN "a57be577deb434"."tbl_erp_personal_tax_stop_verify_rels" "rsvr" ON rsvr.erp_personal_tax_id = r.id AND rsvr.user_id = 1001 WHERE "r"."status" != 0 GROUP BY "r"."id", "rvr"."status", "rsvr"."status" ) 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, r.wrote_date, r.serial_no, 20027 as ticket_type, r.abstract, r.description, r.created_by, r.amount, r.status, r.settle_amount, r.is_payment_settle, r.created_at, CASE WHEN 1 = r.verify_type THEN rvr.status ELSE ( CASE WHEN r.next_verify_user = 1001 THEN 0 ELSE (CASE WHEN rvr.status = 0 THEN NULL ELSE rvr.status END) END) END as verify_status, CASE WHEN 1 = r.verify_type THEN rsvr.status ELSE ( CASE WHEN r.next_stop_verify_user = 1001 THEN 0 ELSE (CASE WHEN rsvr.status = 0 THEN NULL ELSE rsvr.status END) END) END as stop_verify_status, null::integer as cancel_verify_status FROM "a57be577deb434"."tbl_erp_wage_prizes" "r" LEFT JOIN "a57be577deb434"."tbl_erp_wage_prize_verify_rels" "rvr" ON rvr.erp_wage_prize_id = r.id AND rvr.user_id = 1001 LEFT JOIN "a57be577deb434"."tbl_erp_wage_prize_stop_verify_rels" "rsvr" ON rsvr.erp_wage_prize_id = r.id AND rsvr.user_id = 1001 WHERE "r"."status" != 0 GROUP BY "r"."id", "rvr"."status", "rsvr"."status" ) UNION ALL ( SELECT (r.id::varchar || 20028::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.wrote_date, r.serial_no, 20028 as ticket_type, r.abstract, r.description, r.created_by, sum(p.budget) as amount, r.status, null::numeric as settle_amount, false as is_payment_settle, r.created_at, CASE WHEN 1 = r.verify_type THEN rvr.status ELSE ( CASE WHEN r.next_verify_user = 1001 THEN 0 ELSE (CASE WHEN rvr.status = 0 THEN NULL ELSE rvr.status END) END) END as verify_status, CASE WHEN 1 = r.verify_type THEN rsvr.status ELSE ( CASE WHEN r.next_stop_verify_user = 1001 THEN 0 ELSE (CASE WHEN rsvr.status = 0 THEN NULL ELSE rsvr.status END) END) END as stop_verify_status, null::integer as cancel_verify_status FROM "a57be577deb434"."tbl_erp_profit_distributes" "r" LEFT JOIN "a57be577deb434"."tbl_projects" "p" ON r.project_id = p.id LEFT JOIN "a57be577deb434"."tbl_erp_profit_distribute_verify_rels" "rvr" ON rvr.erp_profit_distribute_id = r.id AND rvr.user_id = 1001 LEFT JOIN "a57be577deb434"."tbl_erp_profit_distribute_stop_verify_rels" "rsvr" ON rsvr.erp_profit_distribute_id = r.id AND rsvr.user_id = 1001 WHERE "r"."status" != 0 GROUP BY "r"."id", "rvr"."status", "rsvr"."status" )) "sub" WHERE ("verify_status"=0) OR ("stop_verify_status"=0) OR ("cancel_verify_status"=0)
15:38:32.213infoyii\db\Command::querySELECT COUNT(*) FROM ((SELECT * FROM (SELECT (r.id::varchar || 20012::varchar) as id, r.id as id2, r.supplier_id as supplier_id, r.client_id as client_id, r.user_id as user_id, r.contact_id as contact_id, r.wrote_date, r.serial_no, 20012 as ticket_type, r.abstract, r.description, r.created_by, r.amount, r.status, r.settle_amount, r.is_payment_settle, r.created_at, r.verify_at FROM "a57be577deb434"."tbl_erp_payment_tickets" "r" WHERE "r"."status"=2 GROUP BY "r"."id") "sub") 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, r.wrote_date, r.serial_no, 20018 as ticket_type, r.abstract, r.description, r.created_by, r.amount, r.status, r.settle_amount, r.is_payment_settle, r.created_at, r.verify_at FROM "a57be577deb434"."tbl_erp_cash_cost_tickets" "r" WHERE "r"."status"=2 GROUP BY "r"."id" ) UNION ALL ( SELECT (r.id::varchar || 20019::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.wrote_date, r.serial_no, 20019 as ticket_type, r.abstract, r.description, r.created_by, r.amount, r.status, r.settle_amount, r.is_payment_settle, r.created_at, r.verify_at FROM "a57be577deb434"."tbl_erp_advance_payment_tickets" "r" WHERE "r"."status"=2 GROUP BY "r"."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, r.wrote_date, r.serial_no, 20023 as ticket_type, r.abstract, r.description, r.created_by, r.amount, r.status, r.settle_amount, settle_amount >= amount as is_payment_settle, r.created_at, r.verify_at FROM "a57be577deb434"."tbl_erp_wage_tickets" "r" WHERE "r"."status"=2 GROUP BY "r"."id" ) 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, r.wrote_date, r.serial_no, 20024 as ticket_type, r.abstract, r.description, r.created_by, r.amount, r.status, r.settle_amount, r.is_payment_settle, r.created_at, r.verify_at FROM "a57be577deb434"."tbl_erp_social_insurances" "r" WHERE "r"."status"=2 GROUP BY "r"."id" ) 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, r.wrote_date, r.serial_no, 20025 as ticket_type, r.abstract, r.description, r.created_by, r.amount, r.status, r.settle_amount, r.is_payment_settle, r.created_at, r.verify_at FROM "a57be577deb434"."tbl_erp_provident_funds" "r" WHERE "r"."status"=2 GROUP BY "r"."id" ) 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, r.wrote_date, r.serial_no, 20026 as ticket_type, r.abstract, r.description, r.created_by, r.amount, r.status, r.settle_amount, r.is_payment_settle, r.created_at, r.verify_at FROM "a57be577deb434"."tbl_erp_personal_taxs" "r" WHERE "r"."status"=2 GROUP BY "r"."id" ) 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, r.wrote_date, r.serial_no, 20027 as ticket_type, r.abstract, r.description, r.created_by, r.amount, r.status, r.settle_amount, r.is_payment_settle, r.created_at, r.verify_at FROM "a57be577deb434"."tbl_erp_wage_prizes" "r" WHERE "r"."status"=2 GROUP BY "r"."id" )) "sub" WHERE (("ticket_type" IN (20018, 20023, 20024, 20025, 20026, 20027)) AND ("is_payment_settle"=0)) OR (("ticket_type" IN (20012, 20019)) AND ("is_payment_settle"=0))
15:38:32.221traceuranus\rbac\DbManager::checkAccessFromCacheChecking permission: viewClient
15:38:32.221traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: StoreKeeper
15:38:32.221traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: Admin
15:38:32.222infoyii\db\Command::querySELECT COUNT(*) FROM "a57be577deb434"."tbl_clients" "c" LEFT JOIN (SELECT sub_c.id, extract(epoch FROM (CURRENT_TIMESTAMP - max( sl.end_at))) / 86400 AS last_contact FROM "a57be577deb434"."tbl_clients" "sub_c" LEFT JOIN "a57be577deb434"."tbl_work_logs" "sl" ON sl.client_id = sub_c.id WHERE ("sub_c"."sales_rep"=1001) AND ("sub_c"."deleted"=FALSE) GROUP BY "sub_c"."id") "sub" ON c.id = sub.id LEFT JOIN "a57be577deb434"."tbl_client_classes" "cc" ON c.client_class = cc.id WHERE (("c"."sales_rep"=1001) AND ("c"."deleted"=FALSE)) AND ((("sub"."last_contact" IS NOT NULL) AND (sub.last_contact > cc.notice_days)) OR (("sub"."last_contact" IS NULL) AND (EXTRACT (epoch FROM ( CURRENT_DATE - c.created_at ) ) / 86400 > cc.notice_days)))
15:38:32.252infoyii\db\Command::querySELECT count(tmp.id) FROM (SELECT "c"."id" FROM "a57be577deb434"."tbl_cases" "c" LEFT JOIN "a57be577deb434"."tbl_case_assignments" "ca" ON ca.case_id = c.id LEFT JOIN "a57be577deb434"."tbl_clients" "cl" ON c.client_id = cl.id WHERE ("c"."case_status" IN (1, 2, 3)) AND (("ca"."engineer_id"=1001) AND ("ca"."assignment_status" IN (1, 2))) GROUP BY "c"."id") "tmp"
15:38:32.277traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
15:38:32.279traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
15:38:32.279infoyii\db\Command::queryINSERT INTO "global"."tbl_api_log" ("code", "schema", "user_id", "device_type", "url", "request", "response", "php_error", "time", "duration") VALUES (200, 'a57be577deb434', 1001, 5, 'vue/dashboard/get-notice', '{"web_access_token":"XCfRahmCFXcXmdIMLA2cYqURDbuJi7wa"}', '{"code":2000,"result":[{"name":"\u5f85\u529e\u4e8b\u9879","name_display":"","id":"","key":"schedule","num":1,"bedge":1,"badge":1,"item":"\u4ef6","content":"\u5f85\u5904\u7406"},{"name":"\u9879\u76ee\u4efb\u52a1","name_display":"","id":"","key":"task","num":1,"bedge":1,"badge":1,"item":"\u4ef6","content":"\u5f85\u5904\u7406"},{"name":"\u62a5\u9500\u5ba1\u6279","name_display":"","id":"","key":"reimbursement","num":3,"bedge":3,"badge":3,"item":"\u4ef6","content":"\u5f85\u5904\u7406"},{"name":"\u5ba1\u6279\u7ba1\u7406","name_display":"","id":"","key":"approve","num":3,"bedge":3,"badge":3,"item":"\u4ef6","content":"\u5f85\u5904\u7406"},{"name":"\u8003\u52e4\u5ba1\u6279","name_display":"","id":"","key":"punch-approve","num":1,"bedge":1,"badge":1,"item":"\u4ef6","content":"\u5f85\u5904\u7406"},{"name":"ERP\u5f85\u5ba1\u6838","name_display":"","id":"","key":"erp-approve","num":27,"bedge":27,"badge":27,"item":"\u4ef6","content":"\u5f85\u5904\u7406"},{"name":"ERP\u5f85\u7ed3\u7b97","name_display":"","id":"","key":"erp-settle","num":42,"bedge":42,"badge":42,"item":"\u4ef6","content":"\u5f85\u5904\u7406"},{"name":"\u5f85\u8054\u7cfb","id":"","name_display":"","key":"uncontact","num":62,"bedge":62,"badge":62,"item":"\u4e2a","content":"\u5f85\u8054\u7cfb"},{"name":"Case","name_display":"","id":"","key":"case-to-done","num":0,"bedge":0,"badge":0,"item":"\u4e2a","content":"\u5f85\u5904\u7406"}],"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}],"mod":0,"ip":"221.216.117.119","ua":"Mozilla\/5.0 (Macintosh; Intel Mac OS X 10.15; rv:151.0) Gecko\/20100101 Firefox\/151.0"}', FALSE, '2026-06-01 15:38:32', 225885696) RETURNING "id"
15:38:32.281traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
15:38:32.282traceyii\redis\Connection::executeCommandExecuting Redis Command: SET