$page, 'total' => $total, 'rows' => []];
$sql1 = "SELECT * FROM training_batch_enrollment WHERE ohc_type_id = '$ohc_id' and (status ='VOP' || status ='SAD' ||status ='VOA'|| status ='VOR') $searchSql $sortSql $limitSql";
$results = mysqli_query($conn, $sql1);
$count = ($page - 1) * $rp + 1;
while ($row1 = mysqli_fetch_assoc($results)) {
$id = $row1['id'];
$view_link = "" ;
$edit_link = "" ;
$delete_link = "" ;
$links = $view_link . " " . $edit_link . " " . $delete_link;
$item_desc = '';
$sql_procure_items = "SELECT * FROM training_batch_enrollment_beneficiary WHERE batch_pri_tbl_id='$id'";
error_log("dipak mali".$sql_procure_items);
$results_procure_items = mysqli_query($conn, $sql_procure_items);
while ($row_procure_items = mysqli_fetch_assoc($results_procure_items)) {
$patient_name = getFieldFromTable('patient_name', 'patient_master', 'id', $row_procure_items['beneficiary_id']);
error_log($row_procure_items['beneficiary_id']."bene ".$patient_name);
$item_desc .= '' . $patient_name . '
';
}
$subject = getFieldFromTable('name','courses','id',$row1['subject']);
$batch_name = getFieldFromTable('batch_name','training_batch_master','batch_id',$row1['batch_id']);
if($row1['status']=='SAD'){
$status = 'Draft';
}elseif($row1['status']=='VOP'){
$status = ' Approval Pending ';
}elseif($row1['status']=='VOA'){
$status = ' Approved ';
}elseif($row1['status']=='VOR'){
$status = ' Reject ';
}
else{
$status = '';
}
if($row1['batch_started']=='1'){
$batch_started = 'Yes';
}elseif($row1['batch_started']=='0'){
$batch_started = ' No ';
}
$batch_start_date = date_format(date_create($row1['batch_start_date']),"d-m-Y");
$batch_end_date = date_format(date_create($row1['batch_end_date']),"d-m-Y");
$data['rows'][] = [
'id' => $id,
'cell' => [$links,$count++,$batch_name,$batch_start_date,$batch_end_date,$subject,$status,$batch_started, $item_desc]
];
}
echo json_encode($data);
?>