";
}
if ($hasWriteAccess) {
$edit_link = "";
}
if ($hasExecuteAccess) {
$activate_link = "";
}
$pdf_link = "";
$space = " ";
$links = $assign_link . $space . $view_link . $space . $edit_link . $space . $activate_link. $space ;
$village = getFieldFromTable('village', 'village', 'id', $row['address']);
$state = getFieldFromTable('name','states','id',$row['village']);
$tehsil = getFieldFromTable('name','tehsils','id',$row['tehsil']);
$district = getFieldFromTable('name','districts','id',$row['district']);
$subject_name = getCommaSeperatedValuesForInClause("SELECT name FROM courses", "id", $row['subject']);
$education = getFieldFromTable('qualification','qualification','id',$row['education']);
$batch = getFieldFromTable('batch_name','training_batch_master','batch_id',$row['batch_id']);
if ($row['enquiry_date'] && $row['enquiry_date'] !== '0000-00-00') {
$doe = date_format(date_create($row['enquiry_date']), "d-m-Y");
} else {
$doe = 'dd-mm-yyyy';
}
if ($row['unenroll_date'] && $row['unenroll_date'] !== '0000-00-00') {
$dounenroll = date_format(date_create($row['unenroll_date']), "d-m-Y");
} else {
$dounenroll = 'dd-mm-yyyy';
}
// $doe = date_format(date_create($row['enquiry_date']), "d-m-Y");
// $dounenroll = date_format(date_create($row['unenroll_date']), "d-m-Y");
$data['rows'][] = array(
'id' => $row['id'],
'cell' => array($count++,$links, $doe,$dounenroll,$row['remark'],$row['beneficiary_name'],$subject_name, $row['gender'],$village, $state, $tehsil, $district, $row['dob'], $row['trainees_no'], $row['perents_no'], $education, $row['reference_from'],$education)
);
}
echo json_encode($data);
?>