File: /home/cafsindia/rms.cafsjobs.com/enrolment_bk/enrolment_callback_bk14dec2020.php
<?php
$frm = "";
if(isset($_REQUEST['frm'])){
$frm = $_REQUEST['frm'];
require("./enrolment_model.php");
$api_model = new enrolment_model;
$controller_name = 'candidate_tracker';
$form_view = $api_model->get_page_info($controller_name);
$form_info = $form_view['field_info'];
}
if($frm === "save"){
// echo"kk";exit;
$prime_qry_key = "";
$prime_qry_value = "";
$prime_upd_query = "";
$prime_id = "prime_".$form_view['field_info'][0]->prime_module_id."_id";
$form_id = $_POST[$prime_id];
$employee_type = $_POST['employee_type'];
foreach($form_view['field_info'] as $setting){
$field_type = $setting->field_type;
$input_view_type = (int)$setting->input_view_type;
$label_id = strtolower(str_replace(" ","_",$setting->label_name));
$field_isdefault = $setting->field_isdefault;
$unique_field = (int)$setting->unique_field;
$view_name = $setting->view_name;
if((int)$field_type === 7){
$multi_name = $label_id."[]";
$value = trim(implode(",",$_POST[$multi_name]));
}else{
$value = str_replace(" "," ",trim($_POST[$label_id]));
}
if((int)$field_type === 4){
$value = date('Y-m-d',strtotime($value));
}else
if((int)$field_type === 13){
$value = date('Y-m-d H:i:s',strtotime($value));
}else
if((int)$field_type === 8){//textbox only
$value = str_replace('"',"xdbquot",$value);
$value = str_replace("'","xquot",$value);
$value = str_replace("&","xxamp",$value);
}
if($label_id === "current_salary" && $value === ""){
$value = 0;
}
if(($input_view_type === 1) || ($input_view_type === 2)){
$prime_upd_query .= $label_id.' = "'.$value.'",';
}
}
$created_on = date("Y-m-d h:i:s");
$logged_id = 1;
$prime_table = "cw_".$controller_name;
$prime_upd_query .= 'trans_updated_by = "'. $logged_id .'",trans_updated_date = "'.$created_on.'"';
$prime_update_query = "UPDATE $prime_table SET ". $prime_upd_query .' WHERE '. $prime_id.' = "'. $form_id .'"';
$update_info = $api_model->get_update($prime_update_query);
if($update_info){
echo json_encode(array('success' => TRUE, 'message' => "Form Incomplete : Proceed to Education Tab to Complete",'insert_id'=>$form_id));
}
}else
if($frm === "rowset_save"){
// echo"ll";exit;
$view_id = $_POST['view_id'];
$module_id = $_POST['module_id'];
$row_prime_id = $_POST['row_prime_id'];
$row_label_name = $_POST['row_label_name'];
$prime_id = $_POST['prime_id'];
echo $api_model->rowset_save($view_id,$module_id,$row_prime_id,$row_label_name,$prime_id,$controller_name);
}else
if($frm === "row_set_edit"){
$row_id = $_POST['row_id'];
$view_id = $_POST['view_id'];
$table_name = $_POST['table_name'];
echo $api_model->row_set_edit($row_id,$view_id,$table_name);
}else
if($frm === "row_set_remove"){
$row_id = $_POST['row_id'];
$view_id = $_POST['view_id'];
$table_name = $_POST['table_name'];
$prime_id = $_POST['prime_id'];
echo $api_model->row_set_remove($row_id,$view_id,$table_name,$prime_id);
}else
if($frm === "remove_file"){
$prime_id_val = $_POST['prime_id_val'];
$is_defult = (int)$_POST['is_defult'];
$input_name = $_POST['input_name'];
$prime_table = "cw_".$controller_name;
echo $api_model->row_set_remove($prime_id_val,$is_defult,$input_name,$prime_table);
}else
if($frm === "calculation_suggest"){
echo $api_model->calculation_suggest();
}else
if($frm === "exit_number"){
$mobile_number = $_POST['mobile_number'];
$_SESSION['mobile_number'] = $mobile_number;
$prime_table = "cw_".$controller_name;
$exit_qry = 'select count(*) as exit_count,candidate_status,inc,prime_candidate_tracker_id from '.$prime_table.' where mobile_number= "'.$mobile_number.'" and trans_status=1';
$exit_rslt = $api_model->is_exit_data($exit_qry);
$exit_count = $exit_rslt['exit_count'];
$status = $exit_rslt['status'];
$incomplete = $exit_rslt['incomplete'];
$prime_id = $exit_rslt['prime_id'];
if((int)$exit_count === 0){
$prefix_code = date("y").date("m").date("d");
$last_count_qry = 'select max(candidate_code) as candidate_code from '.$prime_table.' where candidate_code like "%'.$prefix_code.'%"';
$code_info = $api_model->runQuery("$last_count_qry");
$code_result = $api_model->result($code_info);
$candidate_code = $code_result[0]->candidate_code;
if($candidate_code){
$candidate_code = $candidate_code + 1;
}else{
$candidate_code = $prefix_code."0001";
}
$created_on = date("Y-m-d h:i:s");
$logged_id = 1;
$prime_table = "cw_".$controller_name;
$prime_qry_key .= "mobile_number,candidate_code,trans_created_by,trans_created_date";
$prime_qry_value .= '"'.$mobile_number.'","'.$candidate_code.'","'.$logged_id.'",'.'"'.$created_on.'"';
$prime_insert_query = "insert into $prime_table ($prime_qry_key) values ($prime_qry_value)";
$insert_id = $api_model->get_save($prime_insert_query);
echo json_encode(array('success' => TRUE, 'message' => "Successfully added fill your further information",'insert_id'=>$insert_id,'mobile_number'=>$mobile_number,'candidate_code'=>$candidate_code));
}else{
if((int)$status === 6){
if((int)$incomplete === 2){
echo json_encode(array('success' => true, 'message' => "completed",'form_rslt'=>$prime_id));
}else{
$form_rslt = $api_model->get_form_data($mobile_number);
echo json_encode(array('success' => FALSE, 'message' => "Already exist your details update your profile?",'form_rslt'=>$form_rslt['rslt_info'],'row_set_data'=>$form_rslt['row_view_list']));
}
}else{
echo json_encode(array('success' => false, 'message' => "Your Form Already Submitted.. Please Contact HR",'status'=>true));
}
}
}else
if($frm === "session_exist"){
$mobile_number = $_POST['mobile_number'];
$prime_table = "cw_".$controller_name;
// print_r($prime_table);exit;
$exit_qry = 'select count(*) as exit_count,candidate_status,inc,prime_candidate_tracker_id from '.$prime_table.' where mobile_number= "'.$mobile_number.'" and trans_status=1';
$exit_rslt = $api_model->is_exit_data($exit_qry);
$exit_count = $exit_rslt['exit_count'];
$status = $exit_rslt['status'];
$incomplete = $exit_rslt['incomplete'];
$prime_id = $exit_rslt['prime_id'];
if((int)$exit_count > 0){
if((int)$status === 6){
if((int)$incomplete === 2){
echo json_encode(array('success' => true, 'message' => "completed",'form_rslt'=>$prime_id));
}else{
$form_rslt = $api_model->get_form_data($mobile_number);
echo json_encode(array('success' => true, 'message' => "Already exist your details update your profile?",'form_rslt'=>$form_rslt['rslt_info'],'row_set_data'=>$form_rslt['row_view_list']));
}
}else{
echo json_encode(array('success' => false, 'message' => "Your Form Already Submitted.. Please Contact HR"));
}
}
}else
if($frm === "clear_session"){
unset($_SESSION['mobile_number']);
echo json_encode(array('success' => true));
}else
if($frm === "get_position"){
$department = $_POST['department'];
$position_qry = 'select prime_position_id,position_name from cw_position where department ="'.$department.'" and trans_status = 1';
$position_info = $api_model->runQuery("$position_qry");
$position_result = $api_model->result($position_info);
$position_list = "<option value=''>--- Select Post Applied For ---</option>";
foreach($position_result as $result){
$id = $result->prime_position_id;
$position = $result->position_name;
$position_list .= "<option value='$id'> $position </option>";
}
echo $position_list;
}else
if($frm === "check_dob_exist"){
$date_of_birth = date("Y-m-d",strtotime($_POST['date_of_birth']));
$prime_id = $_POST['prime_id_val'];
$dob_qry = 'select count(*) as count from cw_candidate_tracker where date_of_birth ="'.$date_of_birth.'"';
$dob_info = $api_model->runQuery("$dob_qry");
$dob_result = $api_model->result($dob_info);
$dob_count = $dob_result[0]->count;
if((int)$dob_count > 0){
$update_query = 'UPDATE cw_candidate_tracker SET dob_exist = "1" WHERE prime_candidate_tracker_id = "'. $prime_id .'"';
$update_info = $api_model->get_update($update_query);
if($update_info){
echo json_encode(array('success' => TRUE, 'message' => "Exist"));
}
}else{
$update_query = 'UPDATE cw_candidate_tracker SET dob_exist = "2" WHERE prime_candidate_tracker_id = "'. $prime_id .'"';
$update_info = $api_model->get_update($update_query);
if($update_info){
echo json_encode(array('success' => TRUE, 'message' => "Not Exist"));
}
}
}else
if($frm === "show_education_tab"){
$prime_id = $_POST['prime_id_val'];
$employee_type = $_POST['employee_type'];
//Check Education count
$rowset_edu_count_qry = 'select count(*) as count from cw_candidate_tracker_educational_qualification where trans_status = 1 and prime_candidate_tracker_id ='.$prime_id;
//echo $rowset_edu_count_qry; die;
$rowset_edu_info = $api_model->runQuery("$rowset_edu_count_qry");
$rowset_edu_result = $api_model->result($rowset_edu_info);
$education_count = $rowset_edu_result[0]->count;
if((int)$education_count < 1){
echo json_encode(array('success' => false, 'message' => "Education Tab Should Be Filled"));
}else{
if((int)$employee_type === 1){
$inc = "2";
}else{
$inc = "1";
}
$update_query = 'UPDATE cw_candidate_tracker SET inc = "'.$inc.'" WHERE prime_candidate_tracker_id = "'. $prime_id .'"';
$update_info = $api_model->get_update($update_query);
echo json_encode(array('success' => TRUE));
}
}else
if($frm === "show_experience_tab"){
$prime_id = $_POST['prime_id_val'];
//Check Experience count
$rowset_count_qry = 'select count(*) as count from cw_candidate_tracker_working_experience where trans_status = 1 and prime_candidate_tracker_id ='.$prime_id;
$rowset_info = $api_model->runQuery("$rowset_count_qry");
$rowset_result = $api_model->result($rowset_info);
$work_experience_count = $rowset_result[0]->count;
if((int)$work_experience_count === 0){
echo json_encode(array('success' => false, 'message' => "Work Experience Tab Should Be Filed if you are Experienced"));
}else{
$update_query = 'UPDATE cw_candidate_tracker SET inc = "2" WHERE prime_candidate_tracker_id = "'. $prime_id .'"';
$update_info = $api_model->get_update($update_query);
unset($_SESSION['mobile_number']);
echo json_encode(array('success' => TRUE, 'message' => "Successfully Updated your profiles"));
}
}else
if($frm === "interview_slot_check"){
$date_of_available = date("Y-m-d",strtotime($_POST['date_of_available']));
$interview_slot = $_POST['interview_slot'];
//Check Experience count
$count_qry = 'select count(*) as count from cw_candidate_tracker where date_of_available = "'.$date_of_available.'" and interview_slot = "'.$interview_slot.'" and trans_status = 1';
$count_info = $api_model->runQuery("$count_qry");
$count_result = $api_model->result($count_info);
$count = $count_result[0]->count;
$slot_count_qry = 'select candidate_count from cw_slots where time_slot = "'.$interview_slot.'" and trans_status = 1';
$slot_count_info = $api_model->runQuery("$slot_count_qry");
$slot_count_result = $api_model->result($slot_count_info);
$slot_count = $slot_count_result[0]->candidate_count;
if((int)$count >= (int)$slot_count){
echo json_encode(array('success' => FALSE, 'message' => "Max Count Reached for this Slot. Please Choose Another Time Slot.."));
}else{
echo json_encode(array('success' => TRUE, 'message' => "Slot Available"));
}
}else
if($frm === "upd_candidate_status"){
$prime_id = $_POST['walk_prime_id'];
$reached_status = $_POST['reached_status'];
if((int)$reached_status === 1){
$reached_status = 10;
}else{
$reached_status = 6;
}
$update_query = 'UPDATE cw_candidate_tracker SET candidate_status = "'.$reached_status.'" WHERE prime_candidate_tracker_id = "'. $prime_id .'"';
$update_info = $api_model->get_update($update_query);
if($update_info){
echo json_encode(array('success' => TRUE, 'message' => "Successfully Updated..."));
}else{
echo json_encode(array('success' => FALSE, 'message' => "Try After Sometime..."));
}
}else{
echo json_encode(array('success' => false, 'message' => "Something Went Wrong..! Please Try Again Later"));
}
?>