{"iTotalDisplayRecords":"2","query":"\r\n SELECT SQL_CALC_FOUND_ROWS `employee_bonus_id`, `employee_id`, `paid_salary_id`, `bonus_amount`, `bonus_title`, `payable_month`, `bonus_status`, `remarks`, `added_by`, `added_on`, `approved_by`, `approved_on`, `hr_employee_name`, `hr_employee_code`, `hr_employee_department`, `hr_employee_company`, `general_task_department_name`, `added_user_name`, `approved_user_name`, `paid_salary_from_date`\r\n FROM employee_bonus_view\r\n \r\n ORDER BY payable_month ASC\r\n \r\n ","aaData":[{"employee_bonus_id":"2","employee_id":"145898173447688900","paid_salary_id":"720","bonus_amount":"200","bonus_title":"yyy","payable_month":"2020-11-01","bonus_status":"Approved","remarks":"0","added_by":"143620071466608200","added_on":"2020-11-09 09:53:46","approved_by":"143620071466608200","approved_on":"0000-00-00 00:00:00","hr_employee_name":"VENKATA RAMANAIAH YETURU","hr_employee_code":"293","hr_employee_department":"13","hr_employee_company":"1","general_task_department_name":"PROCESS EXCELLENCE","added_user_name":"NANJEGOWDA","approved_user_name":"NANJEGOWDA","paid_salary_from_date":"2020-11-01"},{"employee_bonus_id":"1","employee_id":"145898173447688900","paid_salary_id":"0","bonus_amount":"100","bonus_title":"tttt","payable_month":"2020-11-01","bonus_status":"Reject","remarks":"0","added_by":"143620071466608200","added_on":"2020-11-09 09:26:19","approved_by":"143620071466608200","approved_on":"2020-11-09 10:04:49","hr_employee_name":"VENKATA RAMANAIAH YETURU","hr_employee_code":"293","hr_employee_department":"13","hr_employee_company":"1","general_task_department_name":"PROCESS EXCELLENCE","added_user_name":"NANJEGOWDA","approved_user_name":"NANJEGOWDA","paid_salary_from_date":null}]}