File: /home/cafsindia/hrms_cafsinfotech_in/OLD/NEWBK/enrolment/enrolment_callback.php
<?php
$frm = "";
if(isset($_REQUEST['frm'])){
$frm = $_REQUEST['frm'];
require("./enrolment_model.php");
$api_model = new enrolment_model;
$controller_name = 'employees';
$form_view = $api_model->get_page_info($controller_name);
$form_info = $form_view['field_info'];
}
if($frm === "save"){
$prime_qry_key = "";
$prime_qry_value = "";
$prime_upd_query = "";
$prime_id = "prime_custom_".$form_view['field_info'][0]->prime_module_id."_id";
$form_id = $_POST[$prime_id];
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;
$date_type = $setting->date_type;
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));
}
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_custom_".$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);
echo json_encode(array('success' => TRUE, 'message' => "Successfully Updated your profiles",'insert_id'=>$form_id));
}else
if($frm === "rowset_save"){
$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_custom_".$controller_name;
echo $api_model->remove_file($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'];
$prime_table = "cw_custom_".$controller_name;
$offer_exit_qry = 'select count(*) as offer_rslt,employee_name,offer_reference_number,branch,offer_location,employee_email_id,emp_dept,employee_designation,reporting,actual_joining_date,photo,id_proof,permanent_address_proof,current_addrerss_proof,education_proof,upload_document,pan_card_proof,rms_code from cw_offer_letter where employee_mobile_number= "'.$mobile_number.'" and enroll_status = 3';
$offer_exit_data = $api_model->is_offer_exit($offer_exit_qry);
$offer_exit_count = $offer_exit_data[0]->offer_rslt;
$emp_name = $offer_exit_data[0]->employee_name;
$offer_reference_no = $offer_exit_data[0]->offer_reference_number;
$branch = $offer_exit_data[0]->branch;
$offer_location = $offer_exit_data[0]->offer_location;
$email_id = $offer_exit_data[0]->employee_email_id;
$emp_dept = $offer_exit_data[0]->emp_dept;
$emp_design = $offer_exit_data[0]->employee_designation;
$reporting = $offer_exit_data[0]->reporting;
$doj = $offer_exit_data[0]->actual_joining_date;
$join_date = date('d-m-Y',strtotime($doj));
$photo = $offer_exit_data[0]->photo;
$id_proof = $offer_exit_data[0]->id_proof;
$permanent_address = $offer_exit_data[0]->permanent_address_proof;
$current_addrerss = $offer_exit_data[0]->current_addrerss_proof;
$education_proof = $offer_exit_data[0]->education_proof;
$aadhar_doc = $offer_exit_data[0]->upload_document;
$pan_card_doc = $offer_exit_data[0]->pan_card_proof;
$rms_code = $offer_exit_data[0]->rms_code;
if((int)$offer_exit_count === 1){
$exit_qry = 'select count(*) as rslt, manager_status,hr_status from '.$prime_table.' where mobile_number= "'.$mobile_number.'"';
$exit_rslt = $api_model->is_exit_data($exit_qry);
$exit_count = $exit_rslt['exit_count'];
$manager_status = $exit_rslt['manager_status'];
$hr_status = $exit_rslt['hr_status'];
if((int)$exit_count === 0){
$exit_employee_qry = 'select count(*) as emp_rslt from cw_employees where mobile_number= "'.$mobile_number.'"';
$exit_emp_count = $api_model->is_exit_emp_data($exit_employee_qry);
if((int)$exit_emp_count === 0){
$created_on = date("Y-m-d H:i:s");
$logged_id = 1;
$user_right = 7;//user right employee
//New Path
$photo_new = str_replace('upload_files/offer_letter/','upload_files/custom_approval/',$offer_exit_data[0]->photo);
$id_proof_new = str_replace('upload_files/offer_letter/','upload_files/custom_approval/',$offer_exit_data[0]->id_proof);
$permanent_address_new = str_replace('upload_files/offer_letter/','upload_files/custom_approval/',$offer_exit_data[0]->permanent_address_proof);
$current_address_new = str_replace('upload_files/offer_letter/','upload_files/custom_approval/',$offer_exit_data[0]->current_addrerss_proof);
$education_proof_new = str_replace('upload_files/offer_letter/','upload_files/custom_approval/',$offer_exit_data[0]->education_proof);
$aadhar_doc_new = str_replace('upload_files/offer_letter/','upload_files/custom_approval/',$offer_exit_data[0]->upload_document);
$pan_card_proof = str_replace('upload_files/offer_letter/','upload_files/custom_approval/',$offer_exit_data[0]->pan_card_proof);
//Copy Proofs from offer letter to custom approval
copy("../".$photo,"../".$photo_new);
copy("../".$id_proof,"../".$id_proof_new);
copy("../".$permanent_address,"../".$permanent_address_new);
copy("../".$current_addrerss,"../".$current_address_new);
copy("../".$education_proof,"../".$education_proof_new);
copy("../".$aadhar_doc,"../".$aadhar_doc_new);
copy("../".$pan_card_doc,"../".$pan_card_proof);
$prime_qry_key .= "emp_name,mobile_number,offer_reference_no,branch,location,personal_email_id,department,designation,manager_report,date_of_joining,user_right,profile_picture,id_proof,address_proof,current_addrerss_proof,education_proof,aadhar_card_proof,pan_card_proof,rms_code,trans_created_by,trans_created_date";
$prime_qry_value .= '"'.$emp_name.'","'.$mobile_number.'","'.$offer_reference_no.'","'.$branch.'","'.$offer_location.'","'.$email_id.'","'.$emp_dept.'","'.$emp_design.'","'.$reporting.'","'.$doj.'","'.$user_right.'","'.$photo_new.'","'.$id_proof_new.'","'.$permanent_address_new.'","'.$current_address_new.'","'.$education_proof_new.'","'.$aadhar_doc_new.'","'.$pan_card_proof.'","'.$rms_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,'emp_name'=>$emp_name,'offer_reference_no'=>$offer_reference_no,'branch'=>$branch,'date_of_joining'=>$join_date));
}else{
echo json_encode(array('success' => FALSE, 'message' => "Already exit user data, Contact HR Team",'user_status'=>0));
}
}else{
if((int)$manager_status === 1){
$form_rslt = $api_model->get_form_data($mobile_number);
echo json_encode(array('success' => FALSE, 'message' => "Already exit your details update your profile?",'user_status'=>$manager_status,'form_rslt'=>$form_rslt['rslt_info'],'row_set_data'=>$form_rslt['row_view_list']));
}else
if(((int)$manager_status === 3) || ((int)$hr_status === 4)){
echo json_encode(array('success' => FALSE, 'message' => "Contact your HR team, your profile is rejected",'user_status'=>0));
}else{
echo json_encode(array('success' => FALSE, 'message' => "Contact your HR team, your profile is verified",'user_status'=>2));
}
}
}else{
echo json_encode(array('success' => FALSE, 'message' => "Contact your HR team, offer letter is not issued",'user_status'=>0));
}
}
/*else
if($frm === "offerno_exit"){
$offer_no = $_POST['offer_no'];
$mobile_number = $_POST['mobile_number'];
$offerno_exit_qry = 'select count(*) as offer_rslt from cw_offer_letter where employee_mobile_number= "'.$mobile_number.'" and offer_reference_number="'.$offer_no.'"';
$offerno_exit_rslt = $api_model->is_offerno_exit($offerno_exit_qry);
$offerno_exit_count = $offerno_exit_rslt['exit_offerno_count'];
if((int)$offerno_exit_count === 1){
echo json_encode(array('success' => TRUE, 'message' => "Ok, Proceed!"));
}else{
echo json_encode(array('success' => FALSE, 'message' => "Invalid Offer Reference Number!"));
}
}*/
?>