ConfigurationRequestLogsProfilingDatabaseAsset BundlesMailTimeline
68a4583305a9c: POST https://beta.jinchangxiao.com/vue/erp-dashboard/list-verify at 2025-08-19 06:55:47 pm by 124.64.23.198

Database Queries

总计4条数据
TimeDurationTypeQuery
  
18:55:47.0293.0 msSELECTSELECT * FROM "global"."vw_user_login" WHERE "id"=1001

[+] Explain
18:55:47.0342.1 msSELECTSELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001

[+] Explain
18:55:47.1172.1 msSELECTSELECT COUNT(*) FROM (SELECT * FROM ((SELECT * FROM (SELECT r.id, 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, rvr.status as verify_status, rsvr.status 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 (("rvr"."user_id"=1001) OR ("rsvr"."user_id"=1001)) AND ("r"."status" != 0) GROUP BY "r"."id", "rvr"."status", "rsvr"."status") "sub") UNION ALL ( SELECT r.id, 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, rvr.status as verify_status, rsvr.status as stop_verify_status, rcvr.status 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 (("rvr"."user_id"=1001) OR ("rsvr"."user_id"=1001) OR ("rcvr"."user_id"=1001)) AND ("r"."status" != 0) GROUP BY "r"."id", "rvr"."status", "rsvr"."status", "rcvr"."status" ) UNION ALL ( SELECT r.id, 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, rvr.status as verify_status, rsvr.status 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 (("rvr"."user_id"=1001) OR ("rsvr"."user_id"=1001)) AND ("r"."status" != 0) GROUP BY "r"."id", "rvr"."status", "rsvr"."status" ) UNION ALL ( SELECT r.id, 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, rvr.status as verify_status, rsvr.status 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 (("rvr"."user_id"=1001) OR ("rsvr"."user_id"=1001)) AND ("r"."status" != 0) GROUP BY "r"."id", "rvr"."status", "rsvr"."status" ) UNION ALL ( SELECT r.id, 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, rvr.status as verify_status, rsvr.status 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 (("rvr"."user_id"=1001) OR ("rsvr"."user_id"=1001)) AND ("r"."status" != 0) GROUP BY "r"."id", "rvr"."status", "rsvr"."status" ) UNION ALL ( SELECT r.id, 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, rvr.status as verify_status, rsvr.status as stop_verify_status, rcvr.status 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 (("rvr"."user_id"=1001) OR ("rsvr"."user_id"=1001) OR ("rcvr"."user_id"=1001)) AND ("r"."status" != 0) GROUP BY "r"."id", "rvr"."status", "rsvr"."status", "rcvr"."status" ) UNION ALL ( SELECT r.id, 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, rvr.status as verify_status, rsvr.status 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 (("rvr"."user_id"=1001) OR ("rsvr"."user_id"=1001)) AND ("r"."status" != 0) GROUP BY "r"."id", "rvr"."status", "rsvr"."status" ) UNION ALL ( SELECT r.id, 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, rvr.status as verify_status, rsvr.status 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 (("rvr"."user_id"=1001) OR ("rsvr"."user_id"=1001)) AND ("r"."status" != 0) GROUP BY "r"."id", "rvr"."status", "rsvr"."status" ) UNION ALL ( SELECT r.id, 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, rvr.status as verify_status, rsvr.status 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 (("rvr"."user_id"=1001) OR ("rsvr"."user_id"=1001)) AND ("r"."status" != 0) GROUP BY "r"."id", "rvr"."status", "rsvr"."status" ) UNION ALL ( SELECT r.id, 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, 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, rvr.status as verify_status, rsvr.status 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 (("rvr"."user_id"=1001) OR ("rsvr"."user_id"=1001)) AND ("r"."status" != 0) GROUP BY "r"."id", "rvr"."status", "rsvr"."status" ) UNION ALL ( SELECT r.id, 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, rvr.status as verify_status, rsvr.status 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 (("rvr"."user_id"=1001) OR ("rsvr"."user_id"=1001)) AND ("r"."status" != 0) GROUP BY "r"."id", "rvr"."status", "rsvr"."status" ) UNION ALL ( SELECT r.id, 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, 20012 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, rvr.status as verify_status, rsvr.status 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 (("rvr"."user_id"=1001) OR ("rsvr"."user_id"=1001)) AND ("r"."status" != 0) GROUP BY "r"."id", "rvr"."status", "rsvr"."status" ) UNION ALL ( SELECT r.id, 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, 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, rvr.status as verify_status, rsvr.status 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 (("rvr"."user_id"=1001) OR ("rsvr"."user_id"=1001)) AND ("r"."status" != 0) GROUP BY "r"."id", "rvr"."status", "rsvr"."status" ) UNION ALL ( SELECT r.id, 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, 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, rvr.status as verify_status, rsvr.status 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 (("rvr"."user_id"=1001) OR ("rsvr"."user_id"=1001)) AND ("r"."status" != 0) GROUP BY "r"."id", "rvr"."status", "rsvr"."status" ) UNION ALL ( SELECT r.id, 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, rvr.status as verify_status, rsvr.status 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 (("rvr"."user_id"=1001) OR ("rsvr"."user_id"=1001)) AND ("r"."status" != 0) GROUP BY "r"."id", "rvr"."status", "rsvr"."status" ) UNION ALL ( SELECT r.id, 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, rvr.status as verify_status, rsvr.status 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 (("rvr"."user_id"=1001) OR ("rsvr"."user_id"=1001)) AND ("r"."status" != 0) GROUP BY "r"."id", "rvr"."status", "rsvr"."status" ) UNION ALL ( SELECT r.id, 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, rvr.status as verify_status, rsvr.status 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 (("rvr"."user_id"=1001) OR ("rsvr"."user_id"=1001)) AND ("r"."status" != 0) GROUP BY "r"."id", "rvr"."status", "rsvr"."status" ) UNION ALL ( SELECT r.id, 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, 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, rvr.status as verify_status, rsvr.status 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 (("rvr"."user_id"=1001) OR ("rsvr"."user_id"=1001)) AND ("r"."status" != 0) GROUP BY "r"."id", "rvr"."status", "rsvr"."status" ) UNION ALL ( SELECT r.id, 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, rvr.status as verify_status, rsvr.status 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 (("rvr"."user_id"=1001) OR ("rsvr"."user_id"=1001)) AND ("r"."status" != 0) GROUP BY "r"."id", "rvr"."status", "rsvr"."status" ) UNION ALL ( SELECT r.id, 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, rvr.status as verify_status, rsvr.status as stop_verify_status, rcvr.status 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 (("rvr"."user_id"=1001) OR ("rsvr"."user_id"=1001) OR ("rcvr"."user_id"=1001)) AND ("r"."status" != 0) GROUP BY "r"."id", "rvr"."status", "rsvr"."status", "rcvr"."status" ) UNION ALL ( SELECT r.id, 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, rvr.status as verify_status, rsvr.status 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 (("rvr"."user_id"=1001) OR ("rsvr"."user_id"=1001)) AND ("r"."status" != 0) GROUP BY "r"."id", "rvr"."status", "rsvr"."status" ) UNION ALL ( SELECT r.id, 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, rvr.status as verify_status, rsvr.status 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 (("rvr"."user_id"=1001) OR ("rsvr"."user_id"=1001)) AND ("r"."status" != 0) GROUP BY "r"."id", "rvr"."status", "rsvr"."status" ) UNION ALL ( SELECT r.id, 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, rvr.status as verify_status, rsvr.status 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 (("rvr"."user_id"=1001) OR ("rsvr"."user_id"=1001)) AND ("r"."status" != 0) GROUP BY "r"."id", "rvr"."status", "rsvr"."status" ) UNION ALL ( SELECT r.id, 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, rvr.status as verify_status, rsvr.status 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 (("rvr"."user_id"=1001) OR ("rsvr"."user_id"=1001)) AND ("r"."status" != 0) GROUP BY "r"."id", "rvr"."status", "rsvr"."status" ) UNION ALL ( SELECT r.id, 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, rvr.status as verify_status, rsvr.status 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 (("rvr"."user_id"=1001) OR ("rsvr"."user_id"=1001)) AND ("r"."status" != 0) GROUP BY "r"."id", "rvr"."status", "rsvr"."status" )) "sub" ORDER BY case when verify_status = 0 or stop_verify_status = 0 or cancel_verify_status = 0 else 2 end asc, created_at DESC) "c"

[+] Explain
18:55:47.1243.9 msINSERTINSERT INTO "global"."tbl_api_log" ("code", "schema", "user_id", "device_type", "url", "request", "response", "php_error", "time") VALUES (NULL, 'a57be577deb434', 1001, 5, 'vue/erp-dashboard/list-verify', '{"page":"1","web_access_token":"dut1vXihUglGelt2KMXELnSbFppny3OV"}', '{"code":"","data":null,"status":0,"msg":[{"name":"error","success":"","error":"SQLSTATE[42601]: Syntax error: 7 ERROR: syntax error at or near \"else\"\nLINE 501: ...top_verify_status = 0 or cancel_verify_status = 0 else 2 end...\n ^\nThe SQL being executed was: SELECT COUNT(*) FROM (SELECT * FROM ((SELECT * FROM (SELECT \n r.id,\n r.supplier_id,\n null::integer as client_id,\n null::integer as user_id,\n null::integer as contact_id,\n r.wrote_date,\n r.serial_no,\n 20002 as ticket_type,\n r.abstract,\n r.description,\n r.created_by,\n r.amount,\n r.status,\n null::numeric as settle_amount,\n false as is_payment_settle,\n r.created_at,\n rvr.status as verify_status,\n rsvr.status as stop_verify_status,\n null::integer as cancel_verify_status\n 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 ((\"rvr\".\"user_id\"=1001) OR (\"rsvr\".\"user_id\"=1001)) AND (\"r\".\"status\" != 0) GROUP BY \"r\".\"id\", \"rvr\".\"status\", \"rsvr\".\"status\") \"sub\") UNION ALL ( SELECT \n r.id,\n r.supplier_id,\n null::integer as client_id,\n null::integer as user_id,\n null::integer as contact_id,\n r.wrote_date,\n r.serial_no,\n 20001 as ticket_type,\n r.abstract,\n r.description,\n r.created_by,\n r.amount,\n r.status,\n null::numeric as settle_amount,\n false as is_payment_settle,\n r.created_at,\n rvr.status as verify_status,\n rsvr.status as stop_verify_status,\n rcvr.status as cancel_verify_status\n 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 ((\"rvr\".\"user_id\"=1001) OR (\"rsvr\".\"user_id\"=1001) OR (\"rcvr\".\"user_id\"=1001)) AND (\"r\".\"status\" != 0) GROUP BY \"r\".\"id\", \"rvr\".\"status\", \"rsvr\".\"status\", \"rcvr\".\"status\" ) UNION ALL ( SELECT \n r.id,\n r.supplier_id,\n null::integer as client_id,\n null::integer as user_id,\n null::integer as contact_id,\n r.wrote_date,\n r.serial_no,\n 20003 as ticket_type,\n r.abstract,\n r.description,\n r.created_by,\n r.amount,\n r.status,\n null::numeric as settle_amount,\n false as is_payment_settle,\n r.created_at,\n rvr.status as verify_status,\n rsvr.status as stop_verify_status,\n null::integer as cancel_verify_status\n 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 ((\"rvr\".\"user_id\"=1001) OR (\"rsvr\".\"user_id\"=1001)) AND (\"r\".\"status\" != 0) GROUP BY \"r\".\"id\", \"rvr\".\"status\", \"rsvr\".\"status\" ) UNION ALL ( SELECT \n r.id,\n null::integer as supplier_id,\n null::integer as client_id,\n null::integer as user_id,\n null::integer as contact_id,\n r.wrote_date,\n r.serial_no,\n 20004 as ticket_type,\n r.abstract,\n r.description,\n r.created_by,\n r.amount,\n r.status,\n null::numeric as settle_amount,\n false as is_payment_settle,\n r.created_at,\n rvr.status as verify_status,\n rsvr.status as stop_verify_status,\n null::integer as cancel_verify_status\n 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 ((\"rvr\".\"user_id\"=1001) OR (\"rsvr\".\"user_id\"=1001)) AND (\"r\".\"status\" != 0) GROUP BY \"r\".\"id\", \"rvr\".\"status\", \"rsvr\".\"status\" ) UNION ALL ( SELECT \n r.id,\n null::integer as supplier_id,\n null::integer as client_id,\n null::integer as user_id,\n null::integer as contact_id,\n r.wrote_date,\n r.serial_no,\n 20005 as ticket_type,\n r.abstract,\n r.description,\n r.created_by,\n r.amount,\n r.status,\n null::numeric as settle_amount,\n false as is_payment_settle,\n r.created_at,\n rvr.status as verify_status,\n rsvr.status as stop_verify_status,\n null::integer as cancel_verify_status\n 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 ((\"rvr\".\"user_id\"=1001) OR (\"rsvr\".\"user_id\"=1001)) AND (\"r\".\"status\" != 0) GROUP BY \"r\".\"id\", \"rvr\".\"status\", \"rsvr\".\"status\" ) UNION ALL ( SELECT \n r.id,\n null::integer as supplier_id,\n r.client_id as client_id,\n null::integer as user_id,\n null::integer as contact_id,\n r.wrote_date,\n r.serial_no,\n 20007 as ticket_type,\n r.abstract,\n r.description,\n r.created_by,\n r.amount,\n r.status,\n null::numeric as settle_amount,\n false as is_payment_settle,\n r.created_at,\n rvr.status as verify_status,\n rsvr.status as stop_verify_status,\n rcvr.status as cancel_verify_status\n 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 ((\"rvr\".\"user_id\"=1001) OR (\"rsvr\".\"user_id\"=1001) OR (\"rcvr\".\"user_id\"=1001)) AND (\"r\".\"status\" != 0) GROUP BY \"r\".\"id\", \"rvr\".\"status\", \"rsvr\".\"status\", \"rcvr\".\"status\" ) UNION ALL ( SELECT \n r.id,\n null::integer as supplier_id,\n r.client_id as client_id,\n null::integer as user_id,\n null::integer as contact_id,\n r.wrote_date,\n r.serial_no,\n 20008 as ticket_type,\n r.abstract,\n r.description,\n r.created_by,\n r.amount,\n r.status,\n null::numeric as settle_amount,\n false as is_payment_settle,\n r.created_at,\n rvr.status as verify_status,\n rsvr.status as stop_verify_status,\n null::integer as cancel_verify_status\n 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 ((\"rvr\".\"user_id\"=1001) OR (\"rsvr\".\"user_id\"=1001)) AND (\"r\".\"status\" != 0) GROUP BY \"r\".\"id\", \"rvr\".\"status\", \"rsvr\".\"status\" ) UNION ALL ( SELECT \n r.id,\n null::integer as supplier_id,\n r.client_id as client_id,\n null::integer as user_id,\n null::integer as contact_id,\n r.wrote_date,\n r.serial_no,\n 20009 as ticket_type,\n r.abstract,\n r.description,\n r.created_by,\n r.amount,\n r.status,\n null::numeric as settle_amount,\n false as is_payment_settle,\n r.created_at,\n rvr.status as verify_status,\n rsvr.status as stop_verify_status,\n null::integer as cancel_verify_status\n 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 ((\"rvr\".\"user_id\"=1001) OR (\"rsvr\".\"user_id\"=1001)) AND (\"r\".\"status\" != 0) GROUP BY \"r\".\"id\", \"rvr\".\"status\", \"rsvr\".\"status\" ) UNION ALL ( SELECT \n r.id,\n r.supplier_id as supplier_id,\n r.client_id as client_id,\n null::integer as user_id,\n null::integer as contact_id,\n r.wrote_date,\n r.serial_no,\n 20010 as ticket_type,\n r.abstract,\n r.description,\n r.created_by,\n r.amount,\n r.status,\n null::numeric as settle_amount,\n false as is_payment_settle,\n r.created_at,\n rvr.status as verify_status,\n rsvr.status as stop_verify_status,\n null::integer as cancel_verify_status\n 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 ((\"rvr\".\"user_id\"=1001) OR (\"rsvr\".\"user_id\"=1001)) AND (\"r\".\"status\" != 0) GROUP BY \"r\".\"id\", \"rvr\".\"status\", \"rsvr\".\"status\" ) UNION ALL ( SELECT \n r.id,\n r.supplier_id as supplier_id,\n r.client_id as client_id,\n null::integer as user_id,\n null::integer as contact_id,\n r.wrote_date,\n r.serial_no,\n 20011 as ticket_type,\n r.abstract,\n r.description,\n r.created_by,\n r.amount,\n r.status,\n null::numeric as settle_amount,\n false as is_payment_settle,\n r.created_at,\n rvr.status as verify_status,\n rsvr.status as stop_verify_status,\n null::integer as cancel_verify_status\n 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 ((\"rvr\".\"user_id\"=1001) OR (\"rsvr\".\"user_id\"=1001)) AND (\"r\".\"status\" != 0) GROUP BY \"r\".\"id\", \"rvr\".\"status\", \"rsvr\".\"status\" ) UNION ALL ( SELECT \n r.id,\n r.supplier_id as supplier_id,\n r.client_id as client_id,\n r.user_id as user_id,\n r.contact_id as contact_id,\n r.wrote_date,\n r.serial_no,\n 20013 as ticket_type,\n r.abstract,\n r.description,\n r.created_by,\n r.amount,\n r.status,\n r.settle_amount,\n false as is_payment_settle,\n r.created_at,\n rvr.status as verify_status,\n rsvr.status as stop_verify_status,\n null::integer as cancel_verify_status\n 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 ((\"rvr\".\"user_id\"=1001) OR (\"rsvr\".\"user_id\"=1001)) AND (\"r\".\"status\" != 0) GROUP BY \"r\".\"id\", \"rvr\".\"status\", \"rsvr\".\"status\" ) UNION ALL ( SELECT \n r.id,\n r.supplier_id as supplier_id,\n r.client_id as client_id,\n null::integer as user_id,\n r.contact_id as contact_id,\n r.wrote_date,\n r.serial_no,\n 20012 as ticket_type,\n r.abstract,\n r.description,\n r.created_by,\n r.amount,\n r.status,\n r.settle_amount,\n false as is_payment_settle,\n r.created_at,\n rvr.status as verify_status,\n rsvr.status as stop_verify_status,\n null::integer as cancel_verify_status\n 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 ((\"rvr\".\"user_id\"=1001) OR (\"rsvr\".\"user_id\"=1001)) AND (\"r\".\"status\" != 0) GROUP BY \"r\".\"id\", \"rvr\".\"status\", \"rsvr\".\"status\" ) UNION ALL ( SELECT \n r.id,\n r.supplier_id as supplier_id,\n r.client_id as client_id,\n null::integer as user_id,\n null::integer as contact_id,\n r.wrote_date,\n r.serial_no,\n 20015 as ticket_type,\n r.abstract,\n r.description,\n r.created_by,\n r.amount,\n r.status,\n r.settle_amount,\n false as is_payment_settle,\n r.created_at,\n rvr.status as verify_status,\n rsvr.status as stop_verify_status,\n null::integer as cancel_verify_status\n 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 ((\"rvr\".\"user_id\"=1001) OR (\"rsvr\".\"user_id\"=1001)) AND (\"r\".\"status\" != 0) GROUP BY \"r\".\"id\", \"rvr\".\"status\", \"rsvr\".\"status\" ) UNION ALL ( SELECT \n r.id,\n null::integer as supplier_id,\n null::integer as client_id,\n null::integer as user_id,\n null::integer as contact_id,\n r.wrote_date,\n r.serial_no,\n 20016 as ticket_type,\n r.abstract,\n r.description,\n r.created_by,\n r.amount,\n r.status,\n null::numeric as settle_amount,\n false as is_payment_settle,\n r.created_at,\n rvr.status as verify_status,\n rsvr.status as stop_verify_status,\n null::integer as cancel_verify_status\n 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 ((\"rvr\".\"user_id\"=1001) OR (\"rsvr\".\"user_id\"=1001)) AND (\"r\".\"status\" != 0) GROUP BY \"r\".\"id\", \"rvr\".\"status\", \"rsvr\".\"status\" ) UNION ALL ( SELECT \n r.id,\n null::integer as supplier_id,\n null::integer as client_id,\n null::integer as user_id,\n null::integer as contact_id,\n r.wrote_date,\n r.serial_no,\n 20017 as ticket_type,\n r.abstract,\n r.description,\n r.created_by,\n r.amount,\n r.status,\n null::numeric as settle_amount,\n false as is_payment_settle,\n r.created_at,\n rvr.status as verify_status,\n rsvr.status as stop_verify_status,\n null::integer as cancel_verify_status\n 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 ((\"rvr\".\"user_id\"=1001) OR (\"rsvr\".\"user_id\"=1001)) AND (\"r\".\"status\" != 0) GROUP BY \"r\".\"id\", \"rvr\".\"status\", \"rsvr\".\"status\" ) UNION ALL ( SELECT \n r.id,\n r.supplier_id as supplier_id,\n r.client_id as client_id,\n null::integer as user_id,\n null::integer as contact_id,\n r.wrote_date,\n r.serial_no,\n 20018 as ticket_type,\n r.abstract,\n r.description,\n r.created_by,\n r.amount,\n r.status,\n r.settle_amount,\n r.is_payment_settle,\n r.created_at,\n rvr.status as verify_status,\n rsvr.status as stop_verify_status,\n null::integer as cancel_verify_status\n 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 ((\"rvr\".\"user_id\"=1001) OR (\"rsvr\".\"user_id\"=1001)) AND (\"r\".\"status\" != 0) GROUP BY \"r\".\"id\", \"rvr\".\"status\", \"rsvr\".\"status\" ) UNION ALL ( SELECT \n r.id,\n r.supplier_id as supplier_id,\n r.client_id as client_id,\n null::integer as user_id,\n null::integer as contact_id,\n r.wrote_date,\n r.serial_no,\n 20019 as ticket_type,\n r.abstract,\n r.description,\n r.created_by,\n r.amount,\n r.status,\n r.settle_amount,\n r.is_payment_settle,\n r.created_at,\n rvr.status as verify_status,\n rsvr.status as stop_verify_status,\n null::integer as cancel_verify_status\n 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 ((\"rvr\".\"user_id\"=1001) OR (\"rsvr\".\"user_id\"=1001)) AND (\"r\".\"status\" != 0) GROUP BY \"r\".\"id\", \"rvr\".\"status\", \"rsvr\".\"status\" ) UNION ALL ( SELECT \n r.id,\n r.supplier_id as supplier_id,\n r.client_id as client_id,\n null::integer as user_id, \n r.contact_id as contact_id,\n r.wrote_date,\n r.serial_no,\n 20020 as ticket_type,\n r.abstract,\n r.description,\n r.created_by,\n r.amount,\n r.status,\n r.settle_amount,\n false as is_payment_settle,\n r.created_at,\n rvr.status as verify_status,\n rsvr.status as stop_verify_status,\n null::integer as cancel_verify_status\n 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 ((\"rvr\".\"user_id\"=1001) OR (\"rsvr\".\"user_id\"=1001)) AND (\"r\".\"status\" != 0) GROUP BY \"r\".\"id\", \"rvr\".\"status\", \"rsvr\".\"status\" ) UNION ALL ( SELECT \n r.id,\n r.supplier_id as supplier_id,\n r.client_id as client_id,\n r.user_id as user_id,\n r.contact_id as contact_id,\n r.wrote_date,\n r.serial_no,\n 20021 as ticket_type,\n r.abstract,\n r.description,\n r.created_by,\n r.amount,\n r.status,\n r.settle_amount,\n false as is_payment_settle,\n r.created_at,\n rvr.status as verify_status,\n rsvr.status as stop_verify_status,\n null::integer as cancel_verify_status\n 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 ((\"rvr\".\"user_id\"=1001) OR (\"rsvr\".\"user_id\"=1001)) AND (\"r\".\"status\" != 0) GROUP BY \"r\".\"id\", \"rvr\".\"status\", \"rsvr\".\"status\" ) UNION ALL ( SELECT \n r.id,\n r.supplier_id,\n null::integer as client_id,\n null::integer as user_id,\n null::integer as contact_id,\n r.wrote_date,\n r.serial_no,\n 20022 as ticket_type,\n r.abstract,\n r.description,\n r.created_by,\n r.amount,\n r.status,\n null::numeric as settle_amount,\n false as is_payment_settle,\n r.created_at,\n rvr.status as verify_status,\n rsvr.status as stop_verify_status,\n rcvr.status as cancel_verify_status\n 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 ((\"rvr\".\"user_id\"=1001) OR (\"rsvr\".\"user_id\"=1001) OR (\"rcvr\".\"user_id\"=1001)) AND (\"r\".\"status\" != 0) GROUP BY \"r\".\"id\", \"rvr\".\"status\", \"rsvr\".\"status\", \"rcvr\".\"status\" ) UNION ALL ( SELECT \n r.id,\n null::integer as supplier_id,\n null::integer as client_id,\n null::integer as user_id,\n null::integer as contact_id,\n r.wrote_date,\n r.serial_no,\n 20023 as ticket_type,\n r.abstract,\n r.description,\n r.created_by,\n r.amount,\n r.status,\n r.settle_amount,\n r.is_payment_settle,\n r.created_at,\n rvr.status as verify_status,\n rsvr.status as stop_verify_status,\n null::integer as cancel_verify_status\n 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 ((\"rvr\".\"user_id\"=1001) OR (\"rsvr\".\"user_id\"=1001)) AND (\"r\".\"status\" != 0) GROUP BY \"r\".\"id\", \"rvr\".\"status\", \"rsvr\".\"status\" ) UNION ALL ( SELECT \n r.id,\n null::integer as supplier_id,\n null::integer as client_id,\n null::integer as user_id,\n null::integer as contact_id,\n r.wrote_date,\n r.serial_no,\n 20024 as ticket_type,\n r.abstract,\n r.description,\n r.created_by,\n r.amount,\n r.status,\n r.settle_amount,\n r.is_payment_settle,\n r.created_at,\n rvr.status as verify_status,\n rsvr.status as stop_verify_status,\n null::integer as cancel_verify_status\n 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 ((\"rvr\".\"user_id\"=1001) OR (\"rsvr\".\"user_id\"=1001)) AND (\"r\".\"status\" != 0) GROUP BY \"r\".\"id\", \"rvr\".\"status\", \"rsvr\".\"status\" ) UNION ALL ( SELECT \n r.id,\n null::integer as supplier_id,\n null::integer as client_id,\n null::integer as user_id,\n null::integer as contact_id,\n r.wrote_date,\n r.serial_no,\n 20025 as ticket_type,\n r.abstract,\n r.description,\n r.created_by,\n r.amount,\n r.status,\n r.settle_amount,\n r.is_payment_settle,\n r.created_at,\n rvr.status as verify_status,\n rsvr.status as stop_verify_status,\n null::integer as cancel_verify_status\n 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 ((\"rvr\".\"user_id\"=1001) OR (\"rsvr\".\"user_id\"=1001)) AND (\"r\".\"status\" != 0) GROUP BY \"r\".\"id\", \"rvr\".\"status\", \"rsvr\".\"status\" ) UNION ALL ( SELECT \n r.id,\n null::integer as supplier_id,\n null::integer as client_id,\n null::integer as user_id,\n null::integer as contact_id,\n r.wrote_date,\n r.serial_no,\n 20026 as ticket_type,\n r.abstract,\n r.description,\n r.created_by,\n r.amount,\n r.status,\n r.settle_amount,\n r.is_payment_settle,\n r.created_at,\n rvr.status as verify_status,\n rsvr.status as stop_verify_status,\n null::integer as cancel_verify_status\n 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 ((\"rvr\".\"user_id\"=1001) OR (\"rsvr\".\"user_id\"=1001)) AND (\"r\".\"status\" != 0) GROUP BY \"r\".\"id\", \"rvr\".\"status\", \"rsvr\".\"status\" ) UNION ALL ( SELECT \n r.id,\n null::integer as supplier_id,\n null::integer as client_id,\n null::integer as user_id,\n null::integer as contact_id,\n r.wrote_date,\n r.serial_no,\n 20027 as ticket_type,\n r.abstract,\n r.description,\n r.created_by,\n r.amount,\n r.status,\n r.settle_amount,\n r.is_payment_settle,\n r.created_at,\n rvr.status as verify_status,\n rsvr.status as stop_verify_status,\n null::integer as cancel_verify_status\n 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 ((\"rvr\".\"user_id\"=1001) OR (\"rsvr\".\"user_id\"=1001)) AND (\"r\".\"status\" != 0) GROUP BY \"r\".\"id\", \"rvr\".\"status\", \"rsvr\".\"status\" )) \"sub\" ORDER BY case when verify_status = 0 or stop_verify_status = 0 or cancel_verify_status = 0 else 2 end asc, created_at DESC) \"c\"","trace":{"name":"Database Exception","message":"SQLSTATE[42601]: Syntax error: 7 ERROR: syntax error at or near \"else\"\nLINE 501: ...top_verify_status = 0 or cancel_verify_status = 0 else 2 end...\n ^\nThe SQL being executed was: SELECT COUNT(*) FROM (SELECT * FROM ((SELECT * FROM (SELECT \n r.id,\n r.supplier_id,\n null::integer as client_id,\n null::integer as user_id,\n null::integer as contact_id,\n r.wrote_date,\n r.serial_no,\n 20002 as ticket_type,\n r.abstract,\n r.description,\n r.created_by,\n r.amount,\n r.status,\n null::numeric as settle_amount,\n false as is_payment_settle,\n r.created_at,\n rvr.status as verify_status,\n rsvr.status as stop_verify_status,\n null::integer as cancel_verify_status\n 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 ((\"rvr\".\"user_id\"=1001) OR (\"rsvr\".\"user_id\"=1001)) AND (\"r\".\"status\" != 0) GROUP BY \"r\".\"id\", \"rvr\".\"status\", \"rsvr\".\"status\") \"sub\") UNION ALL ( SELECT \n r.id,\n r.supplier_id,\n null::integer as client_id,\n null::integer as user_id,\n null::integer as contact_id,\n r.wrote_date,\n r.serial_no,\n 20001 as ticket_type,\n r.abstract,\n r.description,\n r.created_by,\n r.amount,\n r.status,\n null::numeric as settle_amount,\n false as is_payment_settle,\n r.created_at,\n rvr.status as verify_status,\n rsvr.status as stop_verify_status,\n rcvr.status as cancel_verify_status\n 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 ((\"rvr\".\"user_id\"=1001) OR (\"rsvr\".\"user_id\"=1001) OR (\"rcvr\".\"user_id\"=1001)) AND (\"r\".\"status\" != 0) GROUP BY \"r\".\"id\", \"rvr\".\"status\", \"rsvr\".\"status\", \"rcvr\".\"status\" ) UNION ALL ( SELECT \n r.id,\n r.supplier_id,\n null::integer as client_id,\n null::integer as user_id,\n null::integer as contact_id,\n r.wrote_date,\n r.serial_no,\n 20003 as ticket_type,\n r.abstract,\n r.description,\n r.created_by,\n r.amount,\n r.status,\n null::numeric as settle_amount,\n false as is_payment_settle,\n r.created_at,\n rvr.status as verify_status,\n rsvr.status as stop_verify_status,\n null::integer as cancel_verify_status\n 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 ((\"rvr\".\"user_id\"=1001) OR (\"rsvr\".\"user_id\"=1001)) AND (\"r\".\"status\" != 0) GROUP BY \"r\".\"id\", \"rvr\".\"status\", \"rsvr\".\"status\" ) UNION ALL ( SELECT \n r.id,\n null::integer as supplier_id,\n null::integer as client_id,\n null::integer as user_id,\n null::integer as contact_id,\n r.wrote_date,\n r.serial_no,\n 20004 as ticket_type,\n r.abstract,\n r.description,\n r.created_by,\n r.amount,\n r.status,\n null::numeric as settle_amount,\n false as is_payment_settle,\n r.created_at,\n rvr.status as verify_status,\n rsvr.status as stop_verify_status,\n null::integer as cancel_verify_status\n 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 ((\"rvr\".\"user_id\"=1001) OR (\"rsvr\".\"user_id\"=1001)) AND (\"r\".\"status\" != 0) GROUP BY \"r\".\"id\", \"rvr\".\"status\", \"rsvr\".\"status\" ) UNION ALL ( SELECT \n r.id,\n null::integer as supplier_id,\n null::integer as client_id,\n null::integer as user_id,\n null::integer as contact_id,\n r.wrote_date,\n r.serial_no,\n 20005 as ticket_type,\n r.abstract,\n r.description,\n r.created_by,\n r.amount,\n r.status,\n null::numeric as settle_amount,\n false as is_payment_settle,\n r.created_at,\n rvr.status as verify_status,\n rsvr.status as stop_verify_status,\n null::integer as cancel_verify_status\n 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 ((\"rvr\".\"user_id\"=1001) OR (\"rsvr\".\"user_id\"=1001)) AND (\"r\".\"status\" != 0) GROUP BY \"r\".\"id\", \"rvr\".\"status\", \"rsvr\".\"status\" ) UNION ALL ( SELECT \n r.id,\n null::integer as supplier_id,\n r.client_id as client_id,\n null::integer as user_id,\n null::integer as contact_id,\n r.wrote_date,\n r.serial_no,\n 20007 as ticket_type,\n r.abstract,\n r.description,\n r.created_by,\n r.amount,\n r.status,\n null::numeric as settle_amount,\n false as is_payment_settle,\n r.created_at,\n rvr.status as verify_status,\n rsvr.status as stop_verify_status,\n rcvr.status as cancel_verify_status\n 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 ((\"rvr\".\"user_id\"=1001) OR (\"rsvr\".\"user_id\"=1001) OR (\"rcvr\".\"user_id\"=1001)) AND (\"r\".\"status\" != 0) GROUP BY \"r\".\"id\", \"rvr\".\"status\", \"rsvr\".\"status\", \"rcvr\".\"status\" ) UNION ALL ( SELECT \n r.id,\n null::integer as supplier_id,\n r.client_id as client_id,\n null::integer as user_id,\n null::integer as contact_id,\n r.wrote_date,\n r.serial_no,\n 20008 as ticket_type,\n r.abstract,\n r.description,\n r.created_by,\n r.amount,\n r.status,\n null::numeric as settle_amount,\n false as is_payment_settle,\n r.created_at,\n rvr.status as verify_status,\n rsvr.status as stop_verify_status,\n null::integer as cancel_verify_status\n 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 ((\"rvr\".\"user_id\"=1001) OR (\"rsvr\".\"user_id\"=1001)) AND (\"r\".\"status\" != 0) GROUP BY \"r\".\"id\", \"rvr\".\"status\", \"rsvr\".\"status\" ) UNION ALL ( SELECT \n r.id,\n null::integer as supplier_id,\n r.client_id as client_id,\n null::integer as user_id,\n null::integer as contact_id,\n r.wrote_date,\n r.serial_no,\n 20009 as ticket_type,\n r.abstract,\n r.description,\n r.created_by,\n r.amount,\n r.status,\n null::numeric as settle_amount,\n false as is_payment_settle,\n r.created_at,\n rvr.status as verify_status,\n rsvr.status as stop_verify_status,\n null::integer as cancel_verify_status\n 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 ((\"rvr\".\"user_id\"=1001) OR (\"rsvr\".\"user_id\"=1001)) AND (\"r\".\"status\" != 0) GROUP BY \"r\".\"id\", \"rvr\".\"status\", \"rsvr\".\"status\" ) UNION ALL ( SELECT \n r.id,\n r.supplier_id as supplier_id,\n r.client_id as client_id,\n null::integer as user_id,\n null::integer as contact_id,\n r.wrote_date,\n r.serial_no,\n 20010 as ticket_type,\n r.abstract,\n r.description,\n r.created_by,\n r.amount,\n r.status,\n null::numeric as settle_amount,\n false as is_payment_settle,\n r.created_at,\n rvr.status as verify_status,\n rsvr.status as stop_verify_status,\n null::integer as cancel_verify_status\n 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 ((\"rvr\".\"user_id\"=1001) OR (\"rsvr\".\"user_id\"=1001)) AND (\"r\".\"status\" != 0) GROUP BY \"r\".\"id\", \"rvr\".\"status\", \"rsvr\".\"status\" ) UNION ALL ( SELECT \n r.id,\n r.supplier_id as supplier_id,\n r.client_id as client_id,\n null::integer as user_id,\n null::integer as contact_id,\n r.wrote_date,\n r.serial_no,\n 20011 as ticket_type,\n r.abstract,\n r.description,\n r.created_by,\n r.amount,\n r.status,\n null::numeric as settle_amount,\n false as is_payment_settle,\n r.created_at,\n rvr.status as verify_status,\n rsvr.status as stop_verify_status,\n null::integer as cancel_verify_status\n 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 ((\"rvr\".\"user_id\"=1001) OR (\"rsvr\".\"user_id\"=1001)) AND (\"r\".\"status\" != 0) GROUP BY \"r\".\"id\", \"rvr\".\"status\", \"rsvr\".\"status\" ) UNION ALL ( SELECT \n r.id,\n r.supplier_id as supplier_id,\n r.client_id as client_id,\n r.user_id as user_id,\n r.contact_id as contact_id,\n r.wrote_date,\n r.serial_no,\n 20013 as ticket_type,\n r.abstract,\n r.description,\n r.created_by,\n r.amount,\n r.status,\n r.settle_amount,\n false as is_payment_settle,\n r.created_at,\n rvr.status as verify_status,\n rsvr.status as stop_verify_status,\n null::integer as cancel_verify_status\n 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 ((\"rvr\".\"user_id\"=1001) OR (\"rsvr\".\"user_id\"=1001)) AND (\"r\".\"status\" != 0) GROUP BY \"r\".\"id\", \"rvr\".\"status\", \"rsvr\".\"status\" ) UNION ALL ( SELECT \n r.id,\n r.supplier_id as supplier_id,\n r.client_id as client_id,\n null::integer as user_id,\n r.contact_id as contact_id,\n r.wrote_date,\n r.serial_no,\n 20012 as ticket_type,\n r.abstract,\n r.description,\n r.created_by,\n r.amount,\n r.status,\n r.settle_amount,\n false as is_payment_settle,\n r.created_at,\n rvr.status as verify_status,\n rsvr.status as stop_verify_status,\n null::integer as cancel_verify_status\n 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 ((\"rvr\".\"user_id\"=1001) OR (\"rsvr\".\"user_id\"=1001)) AND (\"r\".\"status\" != 0) GROUP BY \"r\".\"id\", \"rvr\".\"status\", \"rsvr\".\"status\" ) UNION ALL ( SELECT \n r.id,\n r.supplier_id as supplier_id,\n r.client_id as client_id,\n null::integer as user_id,\n null::integer as contact_id,\n r.wrote_date,\n r.serial_no,\n 20015 as ticket_type,\n r.abstract,\n r.description,\n r.created_by,\n r.amount,\n r.status,\n r.settle_amount,\n false as is_payment_settle,\n r.created_at,\n rvr.status as verify_status,\n rsvr.status as stop_verify_status,\n null::integer as cancel_verify_status\n 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 ((\"rvr\".\"user_id\"=1001) OR (\"rsvr\".\"user_id\"=1001)) AND (\"r\".\"status\" != 0) GROUP BY \"r\".\"id\", \"rvr\".\"status\", \"rsvr\".\"status\" ) UNION ALL ( SELECT \n r.id,\n null::integer as supplier_id,\n null::integer as client_id,\n null::integer as user_id,\n null::integer as contact_id,\n r.wrote_date,\n r.serial_no,\n 20016 as ticket_type,\n r.abstract,\n r.description,\n r.created_by,\n r.amount,\n r.status,\n null::numeric as settle_amount,\n false as is_payment_settle,\n r.created_at,\n rvr.status as verify_status,\n rsvr.status as stop_verify_status,\n null::integer as cancel_verify_status\n 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 ((\"rvr\".\"user_id\"=1001) OR (\"rsvr\".\"user_id\"=1001)) AND (\"r\".\"status\" != 0) GROUP BY \"r\".\"id\", \"rvr\".\"status\", \"rsvr\".\"status\" ) UNION ALL ( SELECT \n r.id,\n null::integer as supplier_id,\n null::integer as client_id,\n null::integer as user_id,\n null::integer as contact_id,\n r.wrote_date,\n r.serial_no,\n 20017 as ticket_type,\n r.abstract,\n r.description,\n r.created_by,\n r.amount,\n r.status,\n null::numeric as settle_amount,\n false as is_payment_settle,\n r.created_at,\n rvr.status as verify_status,\n rsvr.status as stop_verify_status,\n null::integer as cancel_verify_status\n 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 ((\"rvr\".\"user_id\"=1001) OR (\"rsvr\".\"user_id\"=1001)) AND (\"r\".\"status\" != 0) GROUP BY \"r\".\"id\", \"rvr\".\"status\", \"rsvr\".\"status\" ) UNION ALL ( SELECT \n r.id,\n r.supplier_id as supplier_id,\n r.client_id as client_id,\n null::integer as user_id,\n null::integer as contact_id,\n r.wrote_date,\n r.serial_no,\n 20018 as ticket_type,\n r.abstract,\n r.description,\n r.created_by,\n r.amount,\n r.status,\n r.settle_amount,\n r.is_payment_settle,\n r.created_at,\n rvr.status as verify_status,\n rsvr.status as stop_verify_status,\n null::integer as cancel_verify_status\n 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 ((\"rvr\".\"user_id\"=1001) OR (\"rsvr\".\"user_id\"=1001)) AND (\"r\".\"status\" != 0) GROUP BY \"r\".\"id\", \"rvr\".\"status\", \"rsvr\".\"status\" ) UNION ALL ( SELECT \n r.id,\n r.supplier_id as supplier_id,\n r.client_id as client_id,\n null::integer as user_id,\n null::integer as contact_id,\n r.wrote_date,\n r.serial_no,\n 20019 as ticket_type,\n r.abstract,\n r.description,\n r.created_by,\n r.amount,\n r.status,\n r.settle_amount,\n r.is_payment_settle,\n r.created_at,\n rvr.status as verify_status,\n rsvr.status as stop_verify_status,\n null::integer as cancel_verify_status\n 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 ((\"rvr\".\"user_id\"=1001) OR (\"rsvr\".\"user_id\"=1001)) AND (\"r\".\"status\" != 0) GROUP BY \"r\".\"id\", \"rvr\".\"status\", \"rsvr\".\"status\" ) UNION ALL ( SELECT \n r.id,\n r.supplier_id as supplier_id,\n r.client_id as client_id,\n null::integer as user_id, \n r.contact_id as contact_id,\n r.wrote_date,\n r.serial_no,\n 20020 as ticket_type,\n r.abstract,\n r.description,\n r.created_by,\n r.amount,\n r.status,\n r.settle_amount,\n false as is_payment_settle,\n r.created_at,\n rvr.status as verify_status,\n rsvr.status as stop_verify_status,\n null::integer as cancel_verify_status\n 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 ((\"rvr\".\"user_id\"=1001) OR (\"rsvr\".\"user_id\"=1001)) AND (\"r\".\"status\" != 0) GROUP BY \"r\".\"id\", \"rvr\".\"status\", \"rsvr\".\"status\" ) UNION ALL ( SELECT \n r.id,\n r.supplier_id as supplier_id,\n r.client_id as client_id,\n r.user_id as user_id,\n r.contact_id as contact_id,\n r.wrote_date,\n r.serial_no,\n 20021 as ticket_type,\n r.abstract,\n r.description,\n r.created_by,\n r.amount,\n r.status,\n r.settle_amount,\n false as is_payment_settle,\n r.created_at,\n rvr.status as verify_status,\n rsvr.status as stop_verify_status,\n null::integer as cancel_verify_status\n 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 ((\"rvr\".\"user_id\"=1001) OR (\"rsvr\".\"user_id\"=1001)) AND (\"r\".\"status\" != 0) GROUP BY \"r\".\"id\", \"rvr\".\"status\", \"rsvr\".\"status\" ) UNION ALL ( SELECT \n r.id,\n r.supplier_id,\n null::integer as client_id,\n null::integer as user_id,\n null::integer as contact_id,\n r.wrote_date,\n r.serial_no,\n 20022 as ticket_type,\n r.abstract,\n r.description,\n r.created_by,\n r.amount,\n r.status,\n null::numeric as settle_amount,\n false as is_payment_settle,\n r.created_at,\n rvr.status as verify_status,\n rsvr.status as stop_verify_status,\n rcvr.status as cancel_verify_status\n 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 ((\"rvr\".\"user_id\"=1001) OR (\"rsvr\".\"user_id\"=1001) OR (\"rcvr\".\"user_id\"=1001)) AND (\"r\".\"status\" != 0) GROUP BY \"r\".\"id\", \"rvr\".\"status\", \"rsvr\".\"status\", \"rcvr\".\"status\" ) UNION ALL ( SELECT \n r.id,\n null::integer as supplier_id,\n null::integer as client_id,\n null::integer as user_id,\n null::integer as contact_id,\n r.wrote_date,\n r.serial_no,\n 20023 as ticket_type,\n r.abstract,\n r.description,\n r.created_by,\n r.amount,\n r.status,\n r.settle_amount,\n r.is_payment_settle,\n r.created_at,\n rvr.status as verify_status,\n rsvr.status as stop_verify_status,\n null::integer as cancel_verify_status\n 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 ((\"rvr\".\"user_id\"=1001) OR (\"rsvr\".\"user_id\"=1001)) AND (\"r\".\"status\" != 0) GROUP BY \"r\".\"id\", \"rvr\".\"status\", \"rsvr\".\"status\" ) UNION ALL ( SELECT \n r.id,\n null::integer as supplier_id,\n null::integer as client_id,\n null::integer as user_id,\n null::integer as contact_id,\n r.wrote_date,\n r.serial_no,\n 20024 as ticket_type,\n r.abstract,\n r.description,\n r.created_by,\n r.amount,\n r.status,\n r.settle_amount,\n r.is_payment_settle,\n r.created_at,\n rvr.status as verify_status,\n rsvr.status as stop_verify_status,\n null::integer as cancel_verify_status\n 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 ((\"rvr\".\"user_id\"=1001) OR (\"rsvr\".\"user_id\"=1001)) AND (\"r\".\"status\" != 0) GROUP BY \"r\".\"id\", \"rvr\".\"status\", \"rsvr\".\"status\" ) UNION ALL ( SELECT \n r.id,\n null::integer as supplier_id,\n null::integer as client_id,\n null::integer as user_id,\n null::integer as contact_id,\n r.wrote_date,\n r.serial_no,\n 20025 as ticket_type,\n r.abstract,\n r.description,\n r.created_by,\n r.amount,\n r.status,\n r.settle_amount,\n r.is_payment_settle,\n r.created_at,\n rvr.status as verify_status,\n rsvr.status as stop_verify_status,\n null::integer as cancel_verify_status\n 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 ((\"rvr\".\"user_id\"=1001) OR (\"rsvr\".\"user_id\"=1001)) AND (\"r\".\"status\" != 0) GROUP BY \"r\".\"id\", \"rvr\".\"status\", \"rsvr\".\"status\" ) UNION ALL ( SELECT \n r.id,\n null::integer as supplier_id,\n null::integer as client_id,\n null::integer as user_id,\n null::integer as contact_id,\n r.wrote_date,\n r.serial_no,\n 20026 as ticket_type,\n r.abstract,\n r.description,\n r.created_by,\n r.amount,\n r.status,\n r.settle_amount,\n r.is_payment_settle,\n r.created_at,\n rvr.status as verify_status,\n rsvr.status as stop_verify_status,\n null::integer as cancel_verify_status\n 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 ((\"rvr\".\"user_id\"=1001) OR (\"rsvr\".\"user_id\"=1001)) AND (\"r\".\"status\" != 0) GROUP BY \"r\".\"id\", \"rvr\".\"status\", \"rsvr\".\"status\" ) UNION ALL ( SELECT \n r.id,\n null::integer as supplier_id,\n null::integer as client_id,\n null::integer as user_id,\n null::integer as contact_id,\n r.wrote_date,\n r.serial_no,\n 20027 as ticket_type,\n r.abstract,\n r.description,\n r.created_by,\n r.amount,\n r.status,\n r.settle_amount,\n r.is_payment_settle,\n r.created_at,\n rvr.status as verify_status,\n rsvr.status as stop_verify_status,\n null::integer as cancel_verify_status\n 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 ((\"rvr\".\"user_id\"=1001) OR (\"rsvr\".\"user_id\"=1001)) AND (\"r\".\"status\" != 0) GROUP BY \"r\".\"id\", \"rvr\".\"status\", \"rsvr\".\"status\" )) \"sub\" ORDER BY case when verify_status = 0 or stop_verify_status = 0 or cancel_verify_status = 0 else 2 end asc, created_at DESC) \"c\"","code":42601,"type":"yii\\db\\Exception","file":"\/var\/www\/beta\/vendor\/yiisoft\/yii2\/db\/Schema.php","line":637,"stack-trace":["#0 \/var\/www\/beta\/vendor\/yiisoft\/yii2\/db\/Command.php(915): yii\\db\\Schema->convertException(Object(PDOException), ''SELECT COUNT(*)...'')","#1 \/var\/www\/beta\/vendor\/yiisoft\/yii2\/db\/Command.php(388): yii\\db\\Command->queryInternal(''fetchColumn'', 0)","#2 \/var\/www\/beta\/vendor\/yiisoft\/yii2\/db\/Query.php(436): yii\\db\\Command->queryScalar()","#3 \/var\/www\/beta\/vendor\/yiisoft\/yii2\/db\/ActiveQuery.php(334): yii\\db\\Query->queryScalar(''COUNT(*)'', NULL)","#4 \/var\/www\/beta\/vendor\/yiisoft\/yii2\/db\/Query.php(319): yii\\db\\ActiveQuery->queryScalar(''COUNT(*)'', NULL)","#5 \/var\/www\/beta\/modules\/vue\/controllers\/ErpDashboardController.php(476): yii\\db\\Query->count()","#6 [internal function]: app\\modules\\vue\\controllers\\ErpDashboardController->actionListVerify()","#7 \/var\/www\/beta\/vendor\/yiisoft\/yii2\/base\/InlineAction.php(57): call_user_func_array(Array, Array)","#8 \/var\/www\/beta\/vendor\/yiisoft\/yii2\/base\/Controller.php(156): yii\\base\\InlineAction->runWithParams(Array)","#9 \/var\/www\/beta\/vendor\/yiisoft\/yii2\/base\/Module.php(522): yii\\base\\Controller->runAction(''list-verify'', Array)","#10 \/var\/www\/beta\/vendor\/yiisoft\/yii2\/web\/Application.php(102): yii\\base\\Module->runAction(''vue\/erp-dashboa...'', Array)","#11 \/var\/www\/beta\/vendor\/yiisoft\/yii2\/base\/Application.php(379): yii\\web\\Application->handleRequest(Object(yii\\web\\Request))","#12 \/var\/www\/beta\/web\/index.php(24): yii\\base\\Application->run()","#13 {main}"],"error-info":["42601",7,"ERROR: syntax error at or near \"else\"\nLINE 501: ...top_verify_status = 0 or cancel_verify_status = 0 else 2 end...\n ^"],"previous":{"name":"Exception","message":"SQLSTATE[42601]: Syntax error: 7 ERROR: syntax error at or near \"else\"\nLINE 501: ...top_verify_status = 0 or cancel_verify_status = 0 else 2 end...\n ^","code":"42601","type":"PDOException","file":"\/var\/www\/beta\/vendor\/yiisoft\/yii2\/db\/Command.php","line":900,"stack-trace":["#0 \/var\/www\/beta\/vendor\/yiisoft\/yii2\/db\/Command.php(900): PDOStatement->execute()","#1 \/var\/www\/beta\/vendor\/yiisoft\/yii2\/db\/Command.php(388): yii\\db\\Command->queryInternal(''fetchColumn'', 0)","#2 \/var\/www\/beta\/vendor\/yiisoft\/yii2\/db\/Query.php(436): yii\\db\\Command->queryScalar()","#3 \/var\/www\/beta\/vendor\/yiisoft\/yii2\/db\/ActiveQuery.php(334): yii\\db\\Query->queryScalar(''COUNT(*)'', NULL)","#4 \/var\/www\/beta\/vendor\/yiisoft\/yii2\/db\/Query.php(319): yii\\db\\ActiveQuery->queryScalar(''COUNT(*)'', NULL)","#5 \/var\/www\/beta\/modules\/vue\/controllers\/ErpDashboardController.php(476): yii\\db\\Query->count()","#6 [internal function]: app\\modules\\vue\\controllers\\ErpDashboardController->actionListVerify()","#7 \/var\/www\/beta\/vendor\/yiisoft\/yii2\/base\/InlineAction.php(57): call_user_func_array(Array, Array)","#8 \/var\/www\/beta\/vendor\/yiisoft\/yii2\/base\/Controller.php(156): yii\\base\\InlineAction->runWithParams(Array)","#9 \/var\/www\/beta\/vendor\/yiisoft\/yii2\/base\/Module.php(522): yii\\base\\Controller->runAction(''list-verify'', Array)","#10 \/var\/www\/beta\/vendor\/yiisoft\/yii2\/web\/Application.php(102): yii\\base\\Module->runAction(''vue\/erp-dashboa...'', Array)","#11 \/var\/www\/beta\/vendor\/yiisoft\/yii2\/base\/Application.php(379): yii\\web\\Application->handleRequest(Object(yii\\web\\Request))","#12 \/var\/www\/beta\/web\/index.php(24): yii\\base\\Application->run()","#13 {main}"]}}}]}', TRUE, '2025-08-19 18:55:47') RETURNING "id"

[+] Explain