CREATE DEFINER=CURRENT_USER PROCEDURE `opertaion_rpt`(IN `start_date_filter` DATE, IN `end_date_filter` DATE)
BEGIN
    
    select  ROW_NUMBER() OVER (ORDER BY operations.date) AS Sqn, ifnull(hrm_staffs.name, '') as `Operation doctor`, payment_status as `Payment status` from operations 
    left join operation_intras on operation_intras.operation_id = operations.id 
    left join hrm_staffs on  operation_intras.operating_doctor = hrm_staffs.id
    where operations.date between start_date_filter and end_date_filter;

END
