Performance Profiling

Total processing time: 192 ms; Peak memory: 7.015 MB. Show Profiling Timeline

总计17条数据

Time	Duration	Category	Info

17:51:13.563	47.3 ms	yii\db\Command::query	SELECT COUNT() FROM (SELECT 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 (("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::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 stop_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::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 (("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::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 (("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::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 (("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::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 stop_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::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 (("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::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 (("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::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 (("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::varchar \|\| 20011::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, 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 (("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::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 (("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::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 (("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::varchar \|\| 20014::varchar) as id, r.id as id2, r.supplier_id as supplier_id, r.client_id as client_id, null::integer as user_id, null::integer as contact_id, r.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 (("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::varchar \|\| 20015::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, 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 (("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::varchar \|\| 20016::varchar) as id, r.id as id2, null::integer as supplier_id, null::integer as client_id, null::integer as user_id, null::integer as contact_id, 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 (("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::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 (("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::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 (("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::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 (("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::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 (("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::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 (("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::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 stop_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::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 (("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::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 (("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::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 (("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::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 (("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::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 (("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::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 (("rvr"."user_id"=1001) OR ("rsvr"."user_id"=1001)) AND ("r"."status" != 0) GROUP BY "r"."id", "rvr"."status", "rsvr"."status" )) "sub" WHERE (("verify_status" != 0) OR (verify_status is null)) AND (("stop_verify_status" != 0) OR (stop_verify_status is null)) AND (("cancel_verify_status" != 0) OR (cancel_verify_status is null)) ORDER BY case when verify_status = 0 or stop_verify_status = 0 or cancel_verify_status = 0 THEN 1 else 2 end asc, created_at DESC) "c"
17:51:13.612	39.9 ms	yii\db\Command::query	SELECT * 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 (("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::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 stop_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::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 (("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::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 (("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::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 (("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::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 stop_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::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 (("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::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 (("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::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 (("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::varchar \|\| 20011::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, 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 (("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::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 (("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::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 (("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::varchar \|\| 20014::varchar) as id, r.id as id2, r.supplier_id as supplier_id, r.client_id as client_id, null::integer as user_id, null::integer as contact_id, r.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 (("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::varchar \|\| 20015::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, 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 (("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::varchar \|\| 20016::varchar) as id, r.id as id2, null::integer as supplier_id, null::integer as client_id, null::integer as user_id, null::integer as contact_id, 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 (("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::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 (("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::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 (("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::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 (("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::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 (("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::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 (("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::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 stop_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::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 (("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::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 (("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::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 (("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::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 (("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::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 (("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::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 (("rvr"."user_id"=1001) OR ("rsvr"."user_id"=1001)) AND ("r"."status" != 0) GROUP BY "r"."id", "rvr"."status", "rsvr"."status" )) "sub" WHERE (("verify_status" != 0) OR (verify_status is null)) AND (("stop_verify_status" != 0) OR (stop_verify_status is null)) AND (("cancel_verify_status" != 0) OR (cancel_verify_status is null)) ORDER BY case when verify_status = 0 or stop_verify_status = 0 or cancel_verify_status = 0 THEN 1 else 2 end asc, created_at DESC LIMIT 40
17:51:13.704	26.5 ms	yii\db\Command::query	SELECT COUNT() FROM (SELECT 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 (("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::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 stop_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::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 (("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::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 (("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::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 (("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::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 stop_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::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 (("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::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 (("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::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 (("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::varchar \|\| 20011::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, 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 (("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::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 (("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::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 (("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::varchar \|\| 20014::varchar) as id, r.id as id2, r.supplier_id as supplier_id, r.client_id as client_id, null::integer as user_id, null::integer as contact_id, r.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 (("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::varchar \|\| 20015::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, 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 (("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::varchar \|\| 20016::varchar) as id, r.id as id2, null::integer as supplier_id, null::integer as client_id, null::integer as user_id, null::integer as contact_id, 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 (("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::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 (("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::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 (("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::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 (("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::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 (("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::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 (("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::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 stop_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::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 (("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::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 (("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::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 (("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::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 (("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::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 (("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::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 (("rvr"."user_id"=1001) OR ("rsvr"."user_id"=1001)) AND ("r"."status" != 0) GROUP BY "r"."id", "rvr"."status", "rsvr"."status" )) "sub") "sub" WHERE (("verify_status" != 0) OR (verify_status is null)) AND (("stop_verify_status" != 0) OR (stop_verify_status is null)) AND (("cancel_verify_status" != 0) OR (cancel_verify_status is null))
17:51:13.657	22.9 ms	yii\db\Command::query	SELECT COUNT() FROM (SELECT 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 (("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::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 stop_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::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 (("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::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 (("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::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 (("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::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 stop_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::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 (("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::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 (("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::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 (("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::varchar \|\| 20011::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, 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 (("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::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 (("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::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 (("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::varchar \|\| 20014::varchar) as id, r.id as id2, r.supplier_id as supplier_id, r.client_id as client_id, null::integer as user_id, null::integer as contact_id, r.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 (("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::varchar \|\| 20015::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, 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 (("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::varchar \|\| 20016::varchar) as id, r.id as id2, null::integer as supplier_id, null::integer as client_id, null::integer as user_id, null::integer as contact_id, 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 (("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::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 (("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::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 (("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::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 (("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::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 (("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::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 (("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::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 stop_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::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 (("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::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 (("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::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 (("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::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 (("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::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 (("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::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 (("rvr"."user_id"=1001) OR ("rsvr"."user_id"=1001)) AND ("r"."status" != 0) GROUP BY "r"."id", "rvr"."status", "rsvr"."status" )) "sub") "sub"
17:51:13.681	21.8 ms	yii\db\Command::query	SELECT COUNT() FROM (SELECT 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 (("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::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 stop_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::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 (("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::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 (("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::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 (("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::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 stop_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::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 (("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::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 (("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::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 (("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::varchar \|\| 20011::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, 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 (("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::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 (("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::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 (("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::varchar \|\| 20014::varchar) as id, r.id as id2, r.supplier_id as supplier_id, r.client_id as client_id, null::integer as user_id, null::integer as contact_id, r.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 (("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::varchar \|\| 20015::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, 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 (("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::varchar \|\| 20016::varchar) as id, r.id as id2, null::integer as supplier_id, null::integer as client_id, null::integer as user_id, null::integer as contact_id, 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 (("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::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 (("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::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 (("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::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 (("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::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 (("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::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 (("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::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 stop_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::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 (("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::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 (("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::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 (("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::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 (("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::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 (("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::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 (("rvr"."user_id"=1001) OR ("rsvr"."user_id"=1001)) AND ("r"."status" != 0) GROUP BY "r"."id", "rvr"."status", "rsvr"."status" )) "sub") "sub" WHERE ("verify_status"=0) OR ("stop_verify_status"=0) OR ("cancel_verify_status"=0)
17:51:13.732	3.7 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_visit_module_histories" WHERE ("user_id"=1001) AND ("object_type"=20000) AND ("visit_date"='2025-09-10')
17:51:13.553	2.5 ms	yii\db\Command::query	SELECT * FROM "global"."vw_user_login" WHERE "id"=1001
17:51:13.551	1.9 ms	yii\db\Connection::open	Opening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta
17:51:13.737	1.8 ms	yii\db\Command::query	INSERT INTO "global"."tbl_api_log" ("code", "schema", "user_id", "device_type", "url", "request", "response", "php_error", "time") VALUES (200, 'a57be577deb434', 1001, 5, 'vue/erp-dashboard/list-verify', '{"status":"1","page":"1","pageSize":"40","web_access_token":"2BZqbE639wqIoHhgH0VfUgn-meZYtkbz"}', '{"code":2000,"result":{"list":[{"id":1585,"id2":1585,"supplier_id":"","client_id":2125,"user_id":"","contact_id":"","wrote_date":"2025-09-10","serial_no":"XSDD-20250910-00008","ticket_type":20007,"abstract":"","description":"","created_by":5087,"amount":"1580000","status":2,"settle_amount":"","is_payment_settle":false,"created_at":"2025-09-10 17:48:33","verify_status":1,"stop_verify_status":1,"cancel_verify_status":"","createdBy":{"id":5087,"key":5087,"name":"\u5218\u5fae","sex":"F","department_id":1,"avatar":{"id":62,"user_id":5087,"name":"\/files\/cdn\/a57be577deb434\/avatar\/06f75b3a-7b6c-37a8-81c0-b2934104daa7.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"supplier":{},"client":{"id":2125,"key":2125,"name":"\u5317\u4eac\u822a\u661f\u673a\u5668\u5236\u9020\u6709\u9650\u516c\u53f8239\u5382"},"user":{},"contact":{},"ticket_type_display":"\u9500\u552e\u8ba2\u5355","bgcolor":"#4B7902","status_display":"\u5df2\u901a\u8fc7","unit":{"id":2125,"key":2125,"name":"\u5317\u4eac\u822a\u661f\u673a\u5668\u5236\u9020\u6709\u9650\u516c\u53f8239\u5382"}},{"id":1583,"id2":1583,"supplier_id":"","client_id":2128,"user_id":"","contact_id":"","wrote_date":"2025-09-10","serial_no":"XSDD-20250910-00006","ticket_type":20007,"abstract":"","description":"","created_by":5087,"amount":"1150000","status":2,"settle_amount":"","is_payment_settle":false,"created_at":"2025-09-10 17:41:02","verify_status":1,"stop_verify_status":"","cancel_verify_status":"","createdBy":{"id":5087,"key":5087,"name":"\u5218\u5fae","sex":"F","department_id":1,"avatar":{"id":62,"user_id":5087,"name":"\/files\/cdn\/a57be577deb434\/avatar\/06f75b3a-7b6c-37a8-81c0-b2934104daa7.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"supplier":{},"client":{"id":2128,"key":2128,"name":"\u5317\u4eac\u81ea\u52a8\u5316\u63a7\u5236\u8bbe\u5907\u7814\u7a76\u624033\u6240"},"user":{},"contact":{},"ticket_type_display":"\u9500\u552e\u8ba2\u5355","bgcolor":"#4B7902","status_display":"\u5df2\u901a\u8fc7","unit":{"id":2128,"key":2128,"name":"\u5317\u4eac\u81ea\u52a8\u5316\u63a7\u5236\u8bbe\u5907\u7814\u7a76\u624033\u6240"}},{"id":1582,"id2":1582,"supplier_id":"","client_id":3369,"user_id":"","contact_id":"","wrote_date":"2025-09-10","serial_no":"XSDD-20250910-00005","ticket_type":20007,"abstract":"","description":"","created_by":5064,"amount":"444","status":2,"settle_amount":"","is_payment_settle":false,"created_at":"2025-09-10 17:23:46","verify_status":1,"stop_verify_status":"","cancel_verify_status":"","createdBy":{"id":5064,"key":5064,"name":"\u59da\u96ea\u7eaf","sex":"F","department_id":10,"avatar":{"id":38,"user_id":5064,"name":"\/files\/cdn\/a57be577deb434\/avatar\/5bec09dc-1f7a-3542-89a2-cedfefb3fded.png"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"supplier":{},"client":{"id":3369,"key":3369,"name":"\u4e2d\u56fd\u4e2d\u7164\u80fd\u6e90\u96c6\u56e2\u6709\u9650\u516c\u53f8"},"user":{},"contact":{},"ticket_type_display":"\u9500\u552e\u8ba2\u5355","bgcolor":"#4B7902","status_display":"\u5df2\u901a\u8fc7","unit":{"id":3369,"key":3369,"name":"\u4e2d\u56fd\u4e2d\u7164\u80fd\u6e90\u96c6\u56e2\u6709\u9650\u516c\u53f8"}},{"id":1581,"id2":1581,"supplier_id":"","client_id":2747,"user_id":"","contact_id":"","wrote_date":"2025-09-10","serial_no":"XSDD-20250910-00004","ticket_type":20007,"abstract":"","description":"","created_by":5064,"amount":"18855","status":2,"settle_amount":"","is_payment_settle":false,"created_at":"2025-09-10 17:09:45","verify_status":1,"stop_verify_status":"","cancel_verify_status":"","createdBy":{"id":5064,"key":5064,"name":"\u59da\u96ea\u7eaf","sex":"F","department_id":10,"avatar":{"id":38,"user_id":5064,"name":"\/files\/cdn\/a57be577deb434\/avatar\/5bec09dc-1f7a-3542-89a2-cedfefb3fded.png"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"supplier":{},"client":{"id":2747,"key":2747,"name":"\u4e2d\u56fd\u5316\u5b66\u5de5\u7a0b\u96c6\u56e2"},"user":{},"contact":{},"ticket_type_display":"\u9500\u552e\u8ba2\u5355","bgcolor":"#4B7902","status_display":"\u5df2\u901a\u8fc7","unit":{"id":2747,"key":2747,"name":"\u4e2d\u56fd\u5316\u5b66\u5de5\u7a0b\u96c6\u56e2"}},{"id":1580,"id2":1580,"supplier_id":"","client_id":2166,"user_id":"","contact_id":"","wrote_date":"2025-09-10","serial_no":"XSDD-20250910-00003","ticket_type":20007,"abstract":"","description":"","created_by":1001,"amount":"129992","status":2,"settle_amount":"","is_payment_settle":false,"created_at":"2025-09-10 16:53:26","verify_status":1,"stop_verify_status":"","cancel_verify_status":"","createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4,"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"},"department":{"id":4,"key":4,"name":"\u603b\u7ecf\u7406"}},"supplier":{},"client":{"id":2166,"key":2166,"name":"\u6c5f\u539f\u521b\u82af\u79d1\u6280\uff08\u5317\u4eac\uff09\u6709\u9650\u516c\u53f8"},"user":{},"contact":{},"ticket_type_display":"\u9500\u552e\u8ba2\u5355","bgcolor":"#4B7902","status_display":"\u5df2\u901a\u8fc7","unit":{"id":2166,"key":2166,"name":"\u6c5f\u539f\u521b\u82af\u79d1\u6280\uff08\u5317\u4eac\uff09\u6709\u9650\u516c\u53f8"}},{"id":1579,"id2":1579,"supplier_id":"","client_id":93,"user_id":"","contact_id":"","wrote_date":"2025-09-10","serial_no":"XSDD-20250910-00002","ticket_type":20007,"abstract":"","description":"","created_by":1001,"amount":"130000","status":4,"settle_amount":"","is_payment_settle":false,"created_at":"2025-09-10 16:43:00","verify_status":2,"stop_verify_status":"","cancel_verify_status":"","createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4,"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"},"department":{"id":4,"key":4,"name":"\u603b\u7ecf\u7406"}},"supplier":{},"client":{"id":93,"key":93,"name":"\u5eb7\u9f99\u5316\u6210(\u5317\u4eac)\u65b0\u836f\u6280\u672f\u80a1\u4efd\u6709\u9650\u516c\u53f8"},"user":{},"contact":{},"ticket_type_display":"\u9500\u552e\u8ba2\u5355","bgcolor":"#D9001B","status_display":"\u5df2\u62d2\u7edd","unit":{"id":93,"key":93,"name":"\u5eb7\u9f99\u5316\u6210(\u5317\u4eac)\u65b0\u836f\u6280\u672f\u80a1\u4efd\u6709\u9650\u516c\u53f8"}},{"id":1578,"id2":1578,"supplier_id":"","client_id":2166,"user_id":"","contact_id":"","wrote_date":"2025-09-10","serial_no":"XSDD-20250910-00001","ticket_type":20007,"abstract":"","description":"","created_by":1001,"amount":"129992","status":8,"settle_amount":"","is_payment_settle":false,"created_at":"2025-09-10 16:37:43","verify_status":1,"stop_verify_status":"","cancel_verify_status":1,"createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4,"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"},"department":{"id":4,"key":4,"name":"\u603b\u7ecf\u7406"}},"supplier":{},"client":{"id":2166,"key":2166,"name":"\u6c5f\u539f\u521b\u82af\u79d1\u6280\uff08\u5317\u4eac\uff09\u6709\u9650\u516c\u53f8"},"user":{},"contact":{},"ticket_type_display":"\u9500\u552e\u8ba2\u5355","bgcolor":"#8400FF","status_display":"\u5df2\u9000\u5355","unit":{"id":2166,"key":2166,"name":"\u6c5f\u539f\u521b\u82af\u79d1\u6280\uff08\u5317\u4eac\uff09\u6709\u9650\u516c\u53f8"}},{"id":3,"id2":3,"supplier_id":"","client_id":"","user_id":"","contact_id":"","wrote_date":"2025-09-10","serial_no":"GZD-20250910-00001","ticket_type":20023,"abstract":"\u6d4b\u8bd5","description":"","created_by":1001,"amount":"66","status":2,"settle_amount":"4","is_payment_settle":false,"created_at":"2025-09-10 15:50:46","verify_status":1,"stop_verify_status":"","cancel_verify_status":"","createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4,"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"},"department":{"id":4,"key":4,"name":"\u603b\u7ecf\u7406"}},"supplier":{},"client":{},"user":{},"contact":{},"ticket_type_display":"\u5de5\u8d44\u5355","bgcolor":"#02A7F0","status_display":"\u5df2\u8ba1\u63d0","unit":{}},{"id":2,"id2":2,"supplier_id":"","client_id":"","user_id":"","contact_id":"","wrote_date":"2025-09-09","serial_no":"GZD-20250909-00001","ticket_type":20023,"abstract":"\u6d4b\u8bd5","description":"","created_by":1001,"amount":"66","status":4,"settle_amount":"0","is_payment_settle":false,"created_at":"2025-09-09 17:00:10","verify_status":2,"stop_verify_status":"","cancel_verify_status":"","createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4,"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"},"department":{"id":4,"key":4,"name":"\u603b\u7ecf\u7406"}},"supplier":{},"client":{},"user":{},"contact":{},"ticket_type_display":"\u5de5\u8d44\u5355","bgcolor":"#D9001B","status_display":"\u5df2\u62d2\u7edd","unit":{}},{"id":2126,"id2":2126,"supplier_id":"","client_id":"","user_id":5064,"contact_id":"","wrote_date":"2025-09-06","serial_no":"FKD-20250906-00006","ticket_type":20012,"abstract":"","description":"","created_by":1001,"amount":"4","status":2,"settle_amount":"0","is_payment_settle":true,"created_at":"2025-09-06 13:20:11","verify_status":1,"stop_verify_status":"","cancel_verify_status":"","createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4,"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"},"department":{"id":4,"key":4,"name":"\u603b\u7ecf\u7406"}},"supplier":{},"client":{},"user":{"id":5064,"key":5064,"name":"\u59da\u96ea\u7eaf"},"contact":{},"ticket_type_display":"\u4ed8\u6b3e\u5355","bgcolor":"#02A7F0","status_display":"\u5f85\u4ed8\u6b3e","unit":{"id":5064,"key":5064,"name":"\u59da\u96ea\u7eaf"}},{"id":33,"id2":33,"supplier_id":"","client_id":"","user_id":5064,"contact_id":"","wrote_date":"2025-09-06","serial_no":"QTYFD-20250906-00004","ticket_type":20020,"abstract":"","description":"","created_by":1001,"amount":"4","status":2,"settle_amount":"0","is_payment_settle":false,"created_at":"2025-09-06 12:56:11","verify_status":1,"stop_verify_status":"","cancel_verify_status":"","createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4,"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"},"department":{"id":4,"key":4,"name":"\u603b\u7ecf\u7406"}},"supplier":{},"client":{},"user":{"id":5064,"key":5064,"name":"\u59da\u96ea\u7eaf"},"contact":{},"ticket_type_display":"\u5176\u4ed6\u5e94\u4ed8\u5355","bgcolor":"#4B7902","status_display":"\u5df2\u5b8c\u6210","unit":{"id":5064,"key":5064,"name":"\u59da\u96ea\u7eaf"}},{"id":2125,"id2":2125,"supplier_id":"","client_id":"","user_id":5064,"contact_id":"","wrote_date":"2025-09-06","serial_no":"FKD-20250906-00005","ticket_type":20012,"abstract":"","description":"","created_by":1001,"amount":"4","status":4,"settle_amount":"0","is_payment_settle":false,"created_at":"2025-09-06 12:55:34","verify_status":2,"stop_verify_status":"","cancel_verify_status":"","createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4,"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"},"department":{"id":4,"key":4,"name":"\u603b\u7ecf\u7406"}},"supplier":{},"client":{},"user":{"id":5064,"key":5064,"name":"\u59da\u96ea\u7eaf"},"contact":{},"ticket_type_display":"\u4ed8\u6b3e\u5355","bgcolor":"#D9001B","status_display":"\u5df2\u62d2\u7edd","unit":{"id":5064,"key":5064,"name":"\u59da\u96ea\u7eaf"}},{"id":2124,"id2":2124,"supplier_id":"","client_id":"","user_id":5064,"contact_id":"","wrote_date":"2025-09-06","serial_no":"FKD-20250906-00004","ticket_type":20012,"abstract":"444","description":"444","created_by":1001,"amount":"4","status":4,"settle_amount":"0","is_payment_settle":false,"created_at":"2025-09-06 12:41:43","verify_status":2,"stop_verify_status":"","cancel_verify_status":"","createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4,"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"},"department":{"id":4,"key":4,"name":"\u603b\u7ecf\u7406"}},"supplier":{},"client":{},"user":{"id":5064,"key":5064,"name":"\u59da\u96ea\u7eaf"},"contact":{},"ticket_type_display":"\u4ed8\u6b3e\u5355","bgcolor":"#D9001B","status_display":"\u5df2\u62d2\u7edd","unit":{"id":5064,"key":5064,"name":"\u59da\u96ea\u7eaf"}},{"id":32,"id2":32,"supplier_id":"","client_id":"","user_id":5064,"contact_id":"","wrote_date":"2025-09-06","serial_no":"QTYFD-20250906-00003","ticket_type":20020,"abstract":"","description":"","created_by":1001,"amount":"4","status":2,"settle_amount":"4","is_payment_settle":false,"created_at":"2025-09-06 12:30:57","verify_status":1,"stop_verify_status":"","cancel_verify_status":"","createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4,"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"},"department":{"id":4,"key":4,"name":"\u603b\u7ecf\u7406"}},"supplier":{},"client":{},"user":{"id":5064,"key":5064,"name":"\u59da\u96ea\u7eaf"},"contact":{},"ticket_type_display":"\u5176\u4ed6\u5e94\u4ed8\u5355","bgcolor":"#02A7F0","status_display":"\u5f85\u4ed8\u6b3e","unit":{"id":5064,"key":5064,"name":"\u59da\u96ea\u7eaf"}},{"id":2123,"id2":2123,"supplier_id":"","client_id":"","user_id":5064,"contact_id":"","wrote_date":"2025-09-06","serial_no":"FKD-20250906-00003","ticket_type":20012,"abstract":"5435","description":"","created_by":1001,"amount":"55","status":2,"settle_amount":"0","is_payment_settle":true,"created_at":"2025-09-06 10:10:23","verify_status":1,"stop_verify_status":"","cancel_verify_status":"","createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4,"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"},"department":{"id":4,"key":4,"name":"\u603b\u7ecf\u7406"}},"supplier":{},"client":{},"user":{"id":5064,"key":5064,"name":"\u59da\u96ea\u7eaf"},"contact":{},"ticket_type_display":"\u4ed8\u6b3e\u5355","bgcolor":"#02A7F0","status_display":"\u5f85\u4ed8\u6b3e","unit":{"id":5064,"key":5064,"name":"\u59da\u96ea\u7eaf"}},{"id":31,"id2":31,"supplier_id":"","client_id":"","user_id":5064,"contact_id":"","wrote_date":"2025-09-06","serial_no":"QTYFD-20250906-00002","ticket_type":20020,"abstract":"","description":"","created_by":1001,"amount":"55","status":2,"settle_amount":"55","is_payment_settle":false,"created_at":"2025-09-06 10:08:07","verify_status":1,"stop_verify_status":"","cancel_verify_status":"","createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4,"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"},"department":{"id":4,"key":4,"name":"\u603b\u7ecf\u7406"}},"supplier":{},"client":{},"user":{"id":5064,"key":5064,"name":"\u59da\u96ea\u7eaf"},"contact":{},"ticket_type_display":"\u5176\u4ed6\u5e94\u4ed8\u5355","bgcolor":"#02A7F0","status_display":"\u5f85\u4ed8\u6b3e","unit":{"id":5064,"key":5064,"name":"\u59da\u96ea\u7eaf"}},{"id":2122,"id2":2122,"supplier_id":"","client_id":"","user_id":5064,"contact_id":"","wrote_date":"2025-09-06","serial_no":"FKD-20250906-00001","ticket_type":20012,"abstract":"","description":"","created_by":1001,"amount":"666","status":2,"settle_amount":"0","is_payment_settle":true,"created_at":"2025-09-06 10:06:08","verify_status":1,"stop_verify_status":"","cancel_verify_status":"","createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4,"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"},"department":{"id":4,"key":4,"name":"\u603b\u7ecf\u7406"}},"supplier":{},"client":{},"user":{"id":5064,"key":5064,"name":"\u59da\u96ea\u7eaf"},"contact":{},"ticket_type_display":"\u4ed8\u6b3e\u5355","bgcolor":"#02A7F0","status_display":"\u5f85\u4ed8\u6b3e","unit":{"id":5064,"key":5064,"name":"\u59da\u96ea\u7eaf"}},{"id":30,"id2":30,"supplier_id":"","client_id":"","user_id":5064,"contact_id":"","wrote_date":"2025-09-06","serial_no":"QTYFD-20250906-00001","ticket_type":20020,"abstract":"","description":"","created_by":1001,"amount":"666","status":2,"settle_amount":"666","is_payment_settle":false,"created_at":"2025-09-06 10:00:31","verify_status":1,"stop_verify_status":"","cancel_verify_status":"","createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4,"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"},"department":{"id":4,"key":4,"name":"\u603b\u7ecf\u7406"}},"supplier":{},"client":{},"user":{"id":5064,"key":5064,"name":"\u59da\u96ea\u7eaf"},"contact":{},"ticket_type_display":"\u5176\u4ed6\u5e94\u4ed8\u5355","bgcolor":"#02A7F0","status_display":"\u5f85\u4ed8\u6b3e","unit":{"id":5064,"key":5064,"name":"\u59da\u96ea\u7eaf"}},{"id":29,"id2":29,"supplier_id":"","client_id":"","user_id":"","contact_id":"","wrote_date":"2025-09-05","serial_no":"QTYFD-20250905-00002","ticket_type":20020,"abstract":"","description":"","created_by":5250,"amount":"1","status":2,"settle_amount":"0","is_payment_settle":false,"created_at":"2025-09-05 18:16:52","verify_status":1,"stop_verify_status":"","cancel_verify_status":"","createdBy":{"id":5250,"key":5250,"name":"\u8463\u8363","sex":"M","department_id":10,"avatar":{"id":157,"user_id":5250,"name":"\/files\/cdn\/a57be577deb434\/avatar\/10f9a0d9-7ea7-3910-9465-6ece76a0dae4.png"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"supplier":{},"client":{},"user":{},"contact":{},"ticket_type_display":"\u5176\u4ed6\u5e94\u4ed8\u5355","bgcolor":"#4B7902","status_display":"\u5df2\u5b8c\u6210","unit":{}},{"id":28,"id2":28,"supplier_id":"","client_id":"","user_id":5064,"contact_id":"","wrote_date":"2025-09-05","serial_no":"QTYFD-20250905-00001","ticket_type":20020,"abstract":"\u6d4b\u8bd5","description":"\u6d4b\u8bd5","created_by":1001,"amount":"500","status":6,"settle_amount":"0","is_payment_settle":false,"created_at":"2025-09-05 18:13:10","verify_status":3,"stop_verify_status":"","cancel_verify_status":"","createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4,"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"},"department":{"id":4,"key":4,"name":"\u603b\u7ecf\u7406"}},"supplier":{},"client":{},"user":{"id":5064,"key":5064,"name":"\u59da\u96ea\u7eaf"},"contact":{},"ticket_type_display":"\u5176\u4ed6\u5e94\u4ed8\u5355","bgcolor":"#D900AA","status_display":"\u7ea2\u5b57\u53cd\u51b2","unit":{"id":5064,"key":5064,"name":"\u59da\u96ea\u7eaf"}},{"id":7,"id2":7,"supplier_id":"","client_id":3311,"user_id":"","contact_id":"","wrote_date":"2025-09-04","serial_no":"XSYJFTD-20250904-00006","ticket_type":20028,"abstract":"","description":"","created_by":1001,"amount":"75760","status":2,"settle_amount":"","is_payment_settle":false,"created_at":"2025-09-04 11:55:18","verify_status":1,"stop_verify_status":"","cancel_verify_status":"","createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4,"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"},"department":{"id":4,"key":4,"name":"\u603b\u7ecf\u7406"}},"supplier":{},"client":{"id":3311,"key":3311,"name":"\u5317\u4eac\u534e\u8fb0\u60a6\u79d1\u6280\u6709\u9650\u516c\u53f8"},"user":{},"contact":{},"ticket_type_display":"\u9500\u552e\u4e1a\u7ee9\u5206\u644a\u5355","bgcolor":"#4B7902","status_display":"\u5df2\u901a\u8fc7","unit":{"id":3311,"key":3311,"name":"\u5317\u4eac\u534e\u8fb0\u60a6\u79d1\u6280\u6709\u9650\u516c\u53f8"}},{"id":6,"id2":6,"supplier_id":"","client_id":3364,"user_id":"","contact_id":"","wrote_date":"2025-09-04","serial_no":"XSYJFTD-20250904-00005","ticket_type":20028,"abstract":"","description":"","created_by":1001,"amount":"570000","status":2,"settle_amount":"","is_payment_settle":false,"created_at":"2025-09-04 11:19:15","verify_status":1,"stop_verify_status":"","cancel_verify_status":"","createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4,"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"},"department":{"id":4,"key":4,"name":"\u603b\u7ecf\u7406"}},"supplier":{},"client":{"id":3364,"key":3364,"name":"\u5317\u4eac\u6781\u901a\u4e16\u7eaa\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8\uff08\u8fc7\u5355\uff09"},"user":{},"contact":{},"ticket_type_display":"\u9500\u552e\u4e1a\u7ee9\u5206\u644a\u5355","bgcolor":"#4B7902","status_display":"\u5df2\u901a\u8fc7","unit":{"id":3364,"key":3364,"name":"\u5317\u4eac\u6781\u901a\u4e16\u7eaa\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8\uff08\u8fc7\u5355\uff09"}},{"id":5,"id2":5,"supplier_id":"","client_id":3387,"user_id":"","contact_id":"","wrote_date":"2025-09-04","serial_no":"XSYJFTD-20250904-00003","ticket_type":20028,"abstract":"","description":"","created_by":5388,"amount":"114632","status":2,"settle_amount":"","is_payment_settle":false,"created_at":"2025-09-04 11:17:36","verify_status":1,"stop_verify_status":"","cancel_verify_status":"","createdBy":{"id":5388,"key":5388,"name":"\u6768\u71d5\u971e","sex":"F","department_id":6,"avatar":{"id":156,"user_id":5388,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b8d4f68f-e736-3c38-9e2f-1ab47885b3d8.png"},"department":{"id":6,"key":6,"name":"\u8d22\u52a1\u90e8"}},"supplier":{},"client":{"id":3387,"key":3387,"name":"\u5317\u4eac\u4e45\u5b89\u667a\u8baf\u79d1\u6280\u6709\u9650\u516c\u53f8"},"user":{},"contact":{},"ticket_type_display":"\u9500\u552e\u4e1a\u7ee9\u5206\u644a\u5355","bgcolor":"#4B7902","status_display":"\u5df2\u901a\u8fc7","unit":{"id":3387,"key":3387,"name":"\u5317\u4eac\u4e45\u5b89\u667a\u8baf\u79d1\u6280\u6709\u9650\u516c\u53f8"}},{"id":1,"id2":1,"supplier_id":"","client_id":3389,"user_id":"","contact_id":"","wrote_date":"2025-09-04","serial_no":"XSTHD-20250904-00001","ticket_type":20009,"abstract":"","description":"","created_by":1001,"amount":"26666.66","status":1,"settle_amount":"","is_payment_settle":false,"created_at":"2025-09-04 10:45:56","verify_status":1,"stop_verify_status":"","cancel_verify_status":"","createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4,"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"},"department":{"id":4,"key":4,"name":"\u603b\u7ecf\u7406"}},"supplier":{},"client":{"id":3389,"key":3389,"name":"\u4e2d\u56fd\u8bc1\u5238\u62a5\u6709\u9650\u8d23\u4efb\u516c\u53f8"},"user":{},"contact":{},"ticket_type_display":"\u9500\u552e\u9000\u8d27\u5355","bgcolor":"#EA8917","status_display":"\u5ba1\u6279\u4e2d","unit":{"id":3389,"key":3389,"name":"\u4e2d\u56fd\u8bc1\u5238\u62a5\u6709\u9650\u8d23\u4efb\u516c\u53f8"}},{"id":2121,"id2":2121,"supplier_id":90,"client_id":"","user_id":"","contact_id":"","wrote_date":"2025-09-04","serial_no":"FKD-20250904-00001","ticket_type":20012,"abstract":"1","description":"","created_by":1001,"amount":"1","status":2,"settle_amount":"0","is_payment_settle":true,"created_at":"2025-09-04 10:33:10","verify_status":1,"stop_verify_status":"","cancel_verify_status":"","createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4,"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"},"department":{"id":4,"key":4,"name":"\u603b\u7ecf\u7406"}},"supplier":{"id":90,"key":90,"name":"\u7d2b\u5149\u6653\u901a\u79d1\u6280\u6709\u9650\u516c\u53f8"},"client":{},"user":{},"contact":{},"ticket_type_display":"\u4ed8\u6b3e\u5355","bgcolor":"#02A7F0","status_display":"\u5f85\u4ed8\u6b3e","unit":{"id":90,"key":90,"name":"\u7d2b\u5149\u6653\u901a\u79d1\u6280\u6709\u9650\u516c\u53f8"}},{"id":2021,"id2":2021,"supplier_id":"","client_id":3286,"user_id":"","contact_id":"","wrote_date":"2025-09-04","serial_no":"SKD-20250904-00002","ticket_type":20013,"abstract":"\u505c\u7528","description":"","created_by":1001,"amount":"1","status":2,"settle_amount":"0","is_payment_settle":false,"created_at":"2025-09-04 10:32:38","verify_status":1,"stop_verify_status":"","cancel_verify_status":"","createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4,"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"},"department":{"id":4,"key":4,"name":"\u603b\u7ecf\u7406"}},"supplier":{},"client":{"id":3286,"key":3286,"name":"\u826f\u56fe\u79d1\u6280\uff08\u4e0a\u6d77\uff09\u6709\u9650\u516c\u53f8"},"user":{},"contact":{},"ticket_type_display":"\u6536\u6b3e\u5355","bgcolor":"#4B7902","status_display":"\u5df2\u5b8c\u6210","unit":{"id":3286,"key":3286,"name":"\u826f\u56fe\u79d1\u6280\uff08\u4e0a\u6d77\uff09\u6709\u9650\u516c\u53f8"}},{"id":2,"id2":2,"supplier_id":"","client_id":"","user_id":"","contact_id":"","wrote_date":"2025-09-04","serial_no":"FYZSRD-20250904-00001","ticket_type":20016,"abstract":"\u6d4b\u8bd5","description":"\u6d4b\u8bd5","created_by":1001,"amount":"700","status":2,"settle_amount":"","is_payment_settle":false,"created_at":"2025-09-04 10:29:12","verify_status":1,"stop_verify_status":"","cancel_verify_status":"","createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4,"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"},"department":{"id":4,"key":4,"name":"\u603b\u7ecf\u7406"}},"supplier":{},"client":{},"user":{},"contact":{},"ticket_type_display":"\u8d39\u7528\u8f6c\u5176\u4ed6\u6536\u5165\u5355","bgcolor":"#4B7902","status_display":"\u5df2\u901a\u8fc7","unit":{}},{"id":4,"id2":4,"supplier_id":"","client_id":982,"user_id":"","contact_id":"","wrote_date":"2025-09-04","serial_no":"XSYJFTD-20250904-00002","ticket_type":20028,"abstract":"\u8ba9\u6211\u65e5\u8ba9\u6211\u65e5","description":"","created_by":1001,"amount":"2486850","status":2,"settle_amount":"","is_payment_settle":false,"created_at":"2025-09-04 10:12:10","verify_status":1,"stop_verify_status":"","cancel_verify_status":"","createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4,"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"},"department":{"id":4,"key":4,"name":"\u603b\u7ecf\u7406"}},"supplier":{},"client":{"id":982,"key":982,"name":"\u4e2d\u56fd\u4fe1\u606f\u5b89\u5168\u7814\u7a76\u6240"},"user":{},"contact":{},"ticket_type_display":"\u9500\u552e\u4e1a\u7ee9\u5206\u644a\u5355","bgcolor":"#4B7902","status_display":"\u5df2\u901a\u8fc7","unit":{"id":982,"key":982,"name":"\u4e2d\u56fd\u4fe1\u606f\u5b89\u5168\u7814\u7a76\u6240"}},{"id":1577,"id2":1577,"supplier_id":"","client_id":2130,"user_id":"","contact_id":"","wrote_date":"2025-07-17","serial_no":"XSDD-20250904-00001","ticket_type":20007,"abstract":"","description":"","created_by":1001,"amount":"20000000","status":2,"settle_amount":"","is_payment_settle":false,"created_at":"2025-09-04 10:01:22","verify_status":1,"stop_verify_status":"","cancel_verify_status":"","createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4,"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"},"department":{"id":4,"key":4,"name":"\u603b\u7ecf\u7406"}},"supplier":{},"client":{"id":2130,"key":2130,"name":"\u5317\u4eac\u4eac\u822a\u8ba1\u7b97\u901a\u8baf\u7814\u7a76\u6240304"},"user":{},"contact":{},"ticket_type_display":"\u9500\u552e\u8ba2\u5355","bgcolor":"#4B7902","status_display":"\u5df2\u901a\u8fc7","unit":{"id":2130,"key":2130,"name":"\u5317\u4eac\u4eac\u822a\u8ba1\u7b97\u901a\u8baf\u7814\u7a76\u6240304"}},{"id":2020,"id2":2020,"supplier_id":"","client_id":3389,"user_id":"","contact_id":"","wrote_date":"2025-09-04","serial_no":"SKD-20250904-00001","ticket_type":20013,"abstract":"","description":"","created_by":1001,"amount":"80000","status":2,"settle_amount":"0","is_payment_settle":false,"created_at":"2025-09-04 09:20:43","verify_status":1,"stop_verify_status":"","cancel_verify_status":"","createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4,"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"},"department":{"id":4,"key":4,"name":"\u603b\u7ecf\u7406"}},"supplier":{},"client":{"id":3389,"key":3389,"name":"\u4e2d\u56fd\u8bc1\u5238\u62a5\u6709\u9650\u8d23\u4efb\u516c\u53f8"},"user":{},"contact":{},"ticket_type_display":"\u6536\u6b3e\u5355","bgcolor":"#4B7902","status_display":"\u5df2\u5b8c\u6210","unit":{"id":3389,"key":3389,"name":"\u4e2d\u56fd\u8bc1\u5238\u62a5\u6709\u9650\u8d23\u4efb\u516c\u53f8"}},{"id":7496,"id2":7496,"supplier_id":"","client_id":3389,"user_id":"","contact_id":"","wrote_date":"2025-09-04","serial_no":"XJFYD-20250904-00001","ticket_type":20018,"abstract":" \u5206\u644a\u7684 \u6309\u5206\u644a\u7684\u7b97 \u4e0d\u5206\u644a\u7684\u6309\u624b\u586b\u7684\u7b97","description":"","created_by":1001,"amount":"600","status":6,"settle_amount":"0","is_payment_settle":false,"created_at":"2025-09-04 09:13:39","verify_status":3,"stop_verify_status":"","cancel_verify_status":"","createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4,"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"},"department":{"id":4,"key":4,"name":"\u603b\u7ecf\u7406"}},"supplier":{},"client":{"id":3389,"key":3389,"name":"\u4e2d\u56fd\u8bc1\u5238\u62a5\u6709\u9650\u8d23\u4efb\u516c\u53f8"},"user":{},"contact":{},"ticket_type_display":"\u73b0\u91d1\u8d39\u7528\u5355","bgcolor":"#D900AA","status_display":"\u7ea2\u5b57\u53cd\u51b2","unit":{"id":3389,"key":3389,"name":"\u4e2d\u56fd\u8bc1\u5238\u62a5\u6709\u9650\u8d23\u4efb\u516c\u53f8"}},{"id":11,"id2":11,"supplier_id":"","client_id":3389,"user_id":"","contact_id":"","wrote_date":"2025-09-04","serial_no":"FY-20250904-00001","ticket_type":20014,"abstract":"","description":"","created_by":1001,"amount":"900","status":2,"settle_amount":"0","is_payment_settle":false,"created_at":"2025-09-04 09:12:20","verify_status":1,"stop_verify_status":"","cancel_verify_status":"","createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4,"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"},"department":{"id":4,"key":4,"name":"\u603b\u7ecf\u7406"}},"supplier":{},"client":{"id":3389,"key":3389,"name":"\u4e2d\u56fd\u8bc1\u5238\u62a5\u6709\u9650\u8d23\u4efb\u516c\u53f8"},"user":{},"contact":{},"ticket_type_display":"\u8d39\u7528\u5355","bgcolor":"#4B7902","status_display":"\u5df2\u5b8c\u6210","unit":{"id":3389,"key":3389,"name":"\u4e2d\u56fd\u8bc1\u5238\u62a5\u6709\u9650\u8d23\u4efb\u516c\u53f8"}},{"id":14,"id2":14,"supplier_id":"","client_id":3389,"user_id":"","contact_id":"","wrote_date":"2025-09-04","serial_no":"ZSD-20250904-00001","ticket_type":20011,"abstract":"\u4e2d\u56fd\u8bc1\u5238\u62a5\u6709\u9650\u8d23\u4efb\u516c\u53f8","description":"\u4e2d\u56fd\u8bc1\u5238\u62a5\u6709\u9650\u8d23\u4efb\u516c\u53f8","created_by":1001,"amount":"0","status":2,"settle_amount":"","is_payment_settle":false,"created_at":"2025-09-04 09:07:19","verify_status":1,"stop_verify_status":"","cancel_verify_status":"","createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4,"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"},"department":{"id":4,"key":4,"name":"\u603b\u7ecf\u7406"}},"supplier":{},"client":{"id":3389,"key":3389,"name":"\u4e2d\u56fd\u8bc1\u5238\u62a5\u6709\u9650\u8d23\u4efb\u516c\u53f8"},"user":{},"contact":{},"ticket_type_display":"\u8d60\u9001\u5355","bgcolor":"#4B7902","status_display":"\u5df2\u901a\u8fc7","unit":{"id":3389,"key":3389,"name":"\u4e2d\u56fd\u8bc1\u5238\u62a5\u6709\u9650\u8d23\u4efb\u516c\u53f8"}},{"id":33,"id2":33,"supplier_id":725,"client_id":"","user_id":"","contact_id":"","wrote_date":"2025-09-03","serial_no":"CGRK-20250903-00001","ticket_type":20002,"abstract":"","description":"","created_by":1001,"amount":"16700","status":4,"settle_amount":"","is_payment_settle":false,"created_at":"2025-09-03 17:13:22","verify_status":3,"stop_verify_status":"","cancel_verify_status":"","createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4,"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"},"department":{"id":4,"key":4,"name":"\u603b\u7ecf\u7406"}},"supplier":{"id":725,"key":725,"name":"\u5317\u4eac\u795e\u7801\u4fe1\u521b\u8f6f\u4ef6\u6709\u9650\u516c\u53f8"},"client":{},"user":{},"contact":{},"ticket_type_display":"\u91c7\u8d2d\u5165\u5e93\u5355","bgcolor":"#D9001B","status_display":"\u5df2\u62d2\u7edd","unit":{"id":725,"key":725,"name":"\u5317\u4eac\u795e\u7801\u4fe1\u521b\u8f6f\u4ef6\u6709\u9650\u516c\u53f8"}},{"id":19,"id2":19,"supplier_id":"","client_id":3389,"user_id":"","contact_id":"","wrote_date":"2025-09-03","serial_no":"XSCKD-20250903-00001","ticket_type":20008,"abstract":"\u6d4b\u8bd5\u5206\u644a\u5355","description":"\u6d4b\u8bd5","created_by":1001,"amount":"26666.66","status":1,"settle_amount":"","is_payment_settle":false,"created_at":"2025-09-03 15:46:36","verify_status":1,"stop_verify_status":"","cancel_verify_status":"","createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4,"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"},"department":{"id":4,"key":4,"name":"\u603b\u7ecf\u7406"}},"supplier":{},"client":{"id":3389,"key":3389,"name":"\u4e2d\u56fd\u8bc1\u5238\u62a5\u6709\u9650\u8d23\u4efb\u516c\u53f8"},"user":{},"contact":{},"ticket_type_display":"\u9500\u552e\u51fa\u5e93\u5355","bgcolor":"#EA8917","status_display":"\u5ba1\u6279\u4e2d","unit":{"id":3389,"key":3389,"name":"\u4e2d\u56fd\u8bc1\u5238\u62a5\u6709\u9650\u8d23\u4efb\u516c\u53f8"}},{"id":1,"id2":1,"supplier_id":"","client_id":3389,"user_id":"","contact_id":"","wrote_date":"2025-09-03","serial_no":"XSYJFTD-20250903-00001","ticket_type":20028,"abstract":"","description":"","created_by":1001,"amount":"80000","status":6,"settle_amount":"","is_payment_settle":false,"created_at":"2025-09-03 15:42:58","verify_status":"","stop_verify_status":1,"cancel_verify_status":"","createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4,"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"},"department":{"id":4,"key":4,"name":"\u603b\u7ecf\u7406"}},"supplier":{},"client":{"id":3389,"key":3389,"name":"\u4e2d\u56fd\u8bc1\u5238\u62a5\u6709\u9650\u8d23\u4efb\u516c\u53f8"},"user":{},"contact":{},"ticket_type_display":"\u9500\u552e\u4e1a\u7ee9\u5206\u644a\u5355","bgcolor":"#D900AA","status_display":"\u7ea2\u5b57\u53cd\u51b2","unit":{"id":3389,"key":3389,"name":"\u4e2d\u56fd\u8bc1\u5238\u62a5\u6709\u9650\u8d23\u4efb\u516c\u53f8"}},{"id":1576,"id2":1576,"supplier_id":"","client_id":3389,"user_id":"","contact_id":"","wrote_date":"2025-08-21","serial_no":"XSDD-20250903-00001","ticket_type":20007,"abstract":"","description":"","created_by":1001,"amount":"80000","status":2,"settle_amount":"","is_payment_settle":false,"created_at":"2025-09-03 15:40:10","verify_status":1,"stop_verify_status":"","cancel_verify_status":"","createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4,"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"},"department":{"id":4,"key":4,"name":"\u603b\u7ecf\u7406"}},"supplier":{},"client":{"id":3389,"key":3389,"name":"\u4e2d\u56fd\u8bc1\u5238\u62a5\u6709\u9650\u8d23\u4efb\u516c\u53f8"},"user":{},"contact":{},"ticket_type_display":"\u9500\u552e\u8ba2\u5355","bgcolor":"#4B7902","status_display":"\u5df2\u901a\u8fc7","unit":{"id":3389,"key":3389,"name":"\u4e2d\u56fd\u8bc1\u5238\u62a5\u6709\u9650\u8d23\u4efb\u516c\u53f8"}},{"id":7495,"id2":7495,"supplier_id":"","client_id":"","user_id":"","contact_id":"","wrote_date":"2025-09-01","serial_no":"XJFYD-20250901-00003","ticket_type":20018,"abstract":"7\u6708\u8d39\u7528\u53d1\u7968306656.16*0.05","description":"","created_by":5388,"amount":"15333","status":1,"settle_amount":"0","is_payment_settle":false,"created_at":"2025-09-01 11:38:48","verify_status":"","stop_verify_status":"","cancel_verify_status":"","createdBy":{"id":5388,"key":5388,"name":"\u6768\u71d5\u971e","sex":"F","department_id":6,"avatar":{"id":156,"user_id":5388,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b8d4f68f-e736-3c38-9e2f-1ab47885b3d8.png"},"department":{"id":6,"key":6,"name":"\u8d22\u52a1\u90e8"}},"supplier":{},"client":{},"user":{},"contact":{},"ticket_type_display":"\u73b0\u91d1\u8d39\u7528\u5355","bgcolor":"#EA8917","status_display":"\u5ba1\u6279\u4e2d","unit":{}},{"id":10,"id2":10,"supplier_id":"","client_id":2182,"user_id":"","contact_id":"","wrote_date":"2025-08-29","serial_no":"FY-20250829-00004","ticket_type":20014,"abstract":"\u5317\u4eac\u65af\u5948\u514b\u739b\u5218\u6625\u8fd4\u6b3e\u5408\u540c\u989d17500\u5143","description":"","created_by":5388,"amount":"1600","status":2,"settle_amount":"0","is_payment_settle":false,"created_at":"2025-08-29 17:48:41","verify_status":1,"stop_verify_status":"","cancel_verify_status":"","createdBy":{"id":5388,"key":5388,"name":"\u6768\u71d5\u971e","sex":"F","department_id":6,"avatar":{"id":156,"user_id":5388,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b8d4f68f-e736-3c38-9e2f-1ab47885b3d8.png"},"department":{"id":6,"key":6,"name":"\u8d22\u52a1\u90e8"}},"supplier":{},"client":{"id":2182,"key":2182,"name":"\u5317\u4eac\u5357\u65b9\u65af\u5948\u514b\u739b\u6da1\u8f6e\u6280\u672f\u6709\u9650\u516c\u53f8"},"user":{},"contact":{},"ticket_type_display":"\u8d39\u7528\u5355","bgcolor":"#4B7902","status_display":"\u5df2\u5b8c\u6210","unit":{"id":2182,"key":2182,"name":"\u5317\u4eac\u5357\u65b9\u65af\u5948\u514b\u739b\u6da1\u8f6e\u6280\u672f\u6709\u9650\u516c\u53f8"}},{"id":9,"id2":9,"supplier_id":"","client_id":3366,"user_id":"","contact_id":"","wrote_date":"2025-08-29","serial_no":"FY-20250829-00003","ticket_type":20014,"abstract":"\u5317\u4eac\u6052\u4fe1\u901a\u6797\u6770\u8fd4\u6b3e\u5408\u540c\u989d750\u5143","description":"","created_by":5388,"amount":"150","status":2,"settle_amount":"0","is_payment_settle":false,"created_at":"2025-08-29 17:47:08","verify_status":1,"stop_verify_status":"","cancel_verify_status":"","createdBy":{"id":5388,"key":5388,"name":"\u6768\u71d5\u971e","sex":"F","department_id":6,"avatar":{"id":156,"user_id":5388,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b8d4f68f-e736-3c38-9e2f-1ab47885b3d8.png"},"department":{"id":6,"key":6,"name":"\u8d22\u52a1\u90e8"}},"supplier":{},"client":{"id":3366,"key":3366,"name":"\u8fc7\u5355-\u5317\u4eac\u4e2d\u4f01\u6613\u4ed8\u5546\u52a1\u670d\u52a1\u6709\u9650\u516c\u53f8\uff08\u5317\u4eac\u6052\u4fe1\u901a\u7535\u4fe1\u670d\u52a1\u6709\u9650\u516c\u53f8\uff09"},"user":{},"contact":{},"ticket_type_display":"\u8d39\u7528\u5355","bgcolor":"#4B7902","status_display":"\u5df2\u5b8c\u6210","unit":{"id":3366,"key":3366,"name":"\u8fc7\u5355-\u5317\u4eac\u4e2d\u4f01\u6613\u4ed8\u5546\u52a1\u670d\u52a1\u6709\u9650\u516c\u53f8\uff08\u5317\u4eac\u6052\u4fe1\u901a\u7535\u4fe1\u670d\u52a1\u6709\u9650\u516c\u53f8\uff09"}}],"pagenation":{"totalcount":7649,"thispage":1,"pagesize":40},"statusCount":[{"count":51,"key":1,"name":"\u6211\u7684\u5f85\u5ba1\u6838","status":0,"color":"#FEF7EC","border":"#FF9200"},{"count":7649,"key":2,"name":"\u6211\u7684\u5df2\u5ba1\u6838","status":1,"color":"#E7F3D5","border":"#70B603"},{"count":7700,"key":4,"name":"\u5168\u90e8","status":"","color":"#F9D4D9","border":"#D9001B"}]},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}],"mod":0}', FALSE, '2025-09-10 17:51:13') RETURNING "id"
17:51:13.556	1.6 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
17:51:13.736	0.9 ms	yii\db\Command::execute	UPDATE "a57be577deb434"."tbl_visit_module_histories" SET "num"=430, "last_visit_at"='now()' WHERE "id"=56512
17:51:13.653	0.7 ms	yii\db\Command::query	SELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id" IN (5250, 1001, 5388, 5087, 5064))
17:51:13.655	0.5 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_clients" WHERE "id" IN (2125, 2128, 3369, 2747, 2166, 93, 3311, 3364, 3387, 3389, 3286, 982, 2130, 2182, 3366)
17:51:13.655	0.4 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_suppliers" WHERE "id" IN (90, 725)
17:51:13.652	0.4 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (5087, 5064, 1001, 5250, 5388)
17:51:13.654	0.4 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_departments" WHERE "id" IN (10, 4, 6, 1)
17:51:13.656	0.2 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_users" WHERE "id"=5064