{"iTotalDisplayRecords":"16","query":"\r\n    SELECT SQL_CALC_FOUND_ROWS `shift_id`, `shift_name`, `shift_nick_name`, `shift_start_time`, `shift_end_time`, `shift_start_day`, `shift_end_day`, `shift_status`, `shift_start_latitude`, `shift_start_longitude`, `shift_end_latitude`, `shift_end_longitude`, `shift_max_allowed_radius`, `max_allowed_login_duration`, `max_allowed_logout_duration`, `added_by`, `added_on`, `added_by_usere_name`\r\n    FROM employee_shift_view\r\n    \r\n    ORDER BY shift_start_time ASC\r\n    \r\n    ","aaData":[{"shift_id":"7","shift_name":"07:30-06:30","shift_nick_name":"Project Staff","shift_start_time":"07:30:00","shift_end_time":"18:30:00","shift_start_day":"1","shift_end_day":"1","shift_status":"Active","shift_start_latitude":"","shift_start_longitude":"","shift_end_latitude":"","shift_end_longitude":"","shift_max_allowed_radius":"0","max_allowed_login_duration":"15","max_allowed_logout_duration":"15","added_by":"143620071466608200","added_on":"2024-05-04 09:19:34","added_by_usere_name":"NANJEGOWDA","duration":"11 Hours"},{"shift_id":"10","shift_name":"07:30-04:30","shift_nick_name":"S2","shift_start_time":"07:30:00","shift_end_time":"16:30:00","shift_start_day":"1","shift_end_day":"1","shift_status":"Active","shift_start_latitude":"","shift_start_longitude":"","shift_end_latitude":"","shift_end_longitude":"","shift_max_allowed_radius":"0","max_allowed_login_duration":"15","max_allowed_logout_duration":"15","added_by":"143620071466608200","added_on":"2024-05-04 09:19:44","added_by_usere_name":"NANJEGOWDA","duration":"9 Hours"},{"shift_id":"12","shift_name":"08:00-05:00","shift_nick_name":"S4","shift_start_time":"08:00:00","shift_end_time":"17:00:00","shift_start_day":"1","shift_end_day":"1","shift_status":"Active","shift_start_latitude":"","shift_start_longitude":"","shift_end_latitude":"","shift_end_longitude":"","shift_max_allowed_radius":"0","max_allowed_login_duration":"15","max_allowed_logout_duration":"15","added_by":"143620071466608200","added_on":"2024-05-04 09:19:53","added_by_usere_name":"NANJEGOWDA","duration":"9 Hours"},{"shift_id":"9","shift_name":"08:15-07:30","shift_nick_name":"S1","shift_start_time":"08:15:00","shift_end_time":"19:30:00","shift_start_day":"1","shift_end_day":"1","shift_status":"Active","shift_start_latitude":"","shift_start_longitude":"","shift_end_latitude":"","shift_end_longitude":"","shift_max_allowed_radius":"0","max_allowed_login_duration":"15","max_allowed_logout_duration":"15","added_by":"143620071466608200","added_on":"2024-05-04 09:20:01","added_by_usere_name":"NANJEGOWDA","duration":"11.25 Hours15 Minutes"},{"shift_id":"5","shift_name":"08:30-07:30","shift_nick_name":"AS","shift_start_time":"08:30:00","shift_end_time":"19:30:00","shift_start_day":"1","shift_end_day":"1","shift_status":"Active","shift_start_latitude":"","shift_start_longitude":"","shift_end_latitude":"","shift_end_longitude":"","shift_max_allowed_radius":"0","max_allowed_login_duration":"15","max_allowed_logout_duration":"15","added_by":"143620071466608200","added_on":"2024-05-04 09:20:09","added_by_usere_name":"NANJEGOWDA","duration":"11 Hours"},{"shift_id":"8","shift_name":"Civil Site Shift (08:30-18:30)","shift_nick_name":"Civil Site Shift (08:30-18:30)","shift_start_time":"08:30:00","shift_end_time":"18:30:00","shift_start_day":"1","shift_end_day":"1","shift_status":"Active","shift_start_latitude":"","shift_start_longitude":"","shift_end_latitude":"","shift_end_longitude":"","shift_max_allowed_radius":"0","max_allowed_login_duration":"15","max_allowed_logout_duration":"15","added_by":"171464700312440400","added_on":"2025-12-13 17:20:34","added_by_usere_name":"Admin","duration":"10 Hours"},{"shift_id":"11","shift_name":"08:30-05:30","shift_nick_name":"S3","shift_start_time":"08:30:00","shift_end_time":"17:30:00","shift_start_day":"1","shift_end_day":"1","shift_status":"Active","shift_start_latitude":"","shift_start_longitude":"","shift_end_latitude":"","shift_end_longitude":"","shift_max_allowed_radius":"0","max_allowed_login_duration":"15","max_allowed_logout_duration":"15","added_by":"143620071466608200","added_on":"2024-05-04 09:20:32","added_by_usere_name":"NANJEGOWDA","duration":"9 Hours"},{"shift_id":"14","shift_name":"Admin","shift_nick_name":"Admin","shift_start_time":"08:30:00","shift_end_time":"19:00:00","shift_start_day":"1","shift_end_day":"1","shift_status":"Active","shift_start_latitude":"","shift_start_longitude":"","shift_end_latitude":"","shift_end_longitude":"","shift_max_allowed_radius":"0","max_allowed_login_duration":"15","max_allowed_logout_duration":"15","added_by":"143620071466608200","added_on":"2024-05-04 09:20:46","added_by_usere_name":"NANJEGOWDA","duration":"10.5 Hours30 Minutes"},{"shift_id":"2","shift_name":"GS","shift_nick_name":"GS","shift_start_time":"09:00:00","shift_end_time":"18:00:00","shift_start_day":"1","shift_end_day":"1","shift_status":"Active","shift_start_latitude":"","shift_start_longitude":"","shift_end_latitude":"","shift_end_longitude":"","shift_max_allowed_radius":"0","max_allowed_login_duration":"30","max_allowed_logout_duration":"30","added_by":"176474543981537000","added_on":"2025-12-17 16:34:55","added_by_usere_name":"Amith Kumar Singh","duration":"9 Hours"},{"shift_id":"16","shift_name":"ab","shift_nick_name":"ab","shift_start_time":"09:00:00","shift_end_time":"19:00:00","shift_start_day":"1","shift_end_day":"1","shift_status":"Active","shift_start_latitude":"","shift_start_longitude":"","shift_end_latitude":"","shift_end_longitude":"","shift_max_allowed_radius":"0","max_allowed_login_duration":"9","max_allowed_logout_duration":"20","added_by":"17068555332259700","added_on":"2024-10-16 14:13:37","added_by_usere_name":"MITHUN M SHET","duration":"10 Hours"},{"shift_id":"6","shift_name":"FS","shift_nick_name":"FS","shift_start_time":"09:01:00","shift_end_time":"18:01:00","shift_start_day":"1","shift_end_day":"1","shift_status":"Active","shift_start_latitude":"","shift_start_longitude":"","shift_end_latitude":"","shift_end_longitude":"","shift_max_allowed_radius":"0","max_allowed_login_duration":"15","max_allowed_logout_duration":"10","added_by":"143620071466608200","added_on":"2024-05-04 09:21:03","added_by_usere_name":"NANJEGOWDA","duration":"9 Hours"},{"shift_id":"17","shift_name":"LIASION SHIFT","shift_nick_name":"LS","shift_start_time":"09:02:00","shift_end_time":"18:02:00","shift_start_day":"1","shift_end_day":"1","shift_status":"Active","shift_start_latitude":"","shift_start_longitude":"","shift_end_latitude":"","shift_end_longitude":"","shift_max_allowed_radius":"0","max_allowed_login_duration":"15","max_allowed_logout_duration":"15","added_by":"176474543981537000","added_on":"2025-12-17 16:37:43","added_by_usere_name":"Amith Kumar Singh","duration":"9 Hours"},{"shift_id":"13","shift_name":"General Shift (09:30-18:30)","shift_nick_name":"General Shift (09:30-18:30)","shift_start_time":"09:30:00","shift_end_time":"18:30:00","shift_start_day":"1","shift_end_day":"1","shift_status":"Active","shift_start_latitude":"","shift_start_longitude":"","shift_end_latitude":"","shift_end_longitude":"","shift_max_allowed_radius":"0","max_allowed_login_duration":"30","max_allowed_logout_duration":"30","added_by":"171464700312440400","added_on":"2026-04-29 16:57:23","added_by_usere_name":"Admin","duration":"9 Hours"},{"shift_id":"15","shift_name":"Presales","shift_nick_name":"Presales","shift_start_time":"09:45:00","shift_end_time":"18:45:00","shift_start_day":"1","shift_end_day":"1","shift_status":"Active","shift_start_latitude":"","shift_start_longitude":"","shift_end_latitude":"","shift_end_longitude":"","shift_max_allowed_radius":"0","max_allowed_login_duration":"10","max_allowed_logout_duration":"0","added_by":"161457624467680800","added_on":"2026-07-14 11:09:18","added_by_usere_name":"GOWTHAM.V","duration":"9 Hours"},{"shift_id":"3","shift_name":"PS","shift_nick_name":"PS","shift_start_time":"10:00:00","shift_end_time":"19:00:00","shift_start_day":"1","shift_end_day":"1","shift_status":"Active","shift_start_latitude":"","shift_start_longitude":"","shift_end_latitude":"","shift_end_longitude":"","shift_max_allowed_radius":"0","max_allowed_login_duration":"15","max_allowed_logout_duration":"15","added_by":"143620071466608200","added_on":"2024-05-04 09:21:26","added_by_usere_name":"NANJEGOWDA","duration":"9 Hours"},{"shift_id":"4","shift_name":"CS","shift_nick_name":"CS","shift_start_time":"11:00:00","shift_end_time":"20:00:00","shift_start_day":"1","shift_end_day":"1","shift_status":"Active","shift_start_latitude":"","shift_start_longitude":"","shift_end_latitude":"","shift_end_longitude":"","shift_max_allowed_radius":"0","max_allowed_login_duration":"15","max_allowed_logout_duration":"15","added_by":"143620071466608200","added_on":"2024-05-09 15:57:01","added_by_usere_name":"NANJEGOWDA","duration":"9 Hours"}]}