File: /home/cafsindia/.trash/backup/active_employee_list/active_callback.php
<?php
$frm = "";
/* Module Initilization */
if (isset($_REQUEST["frm"])){
$frm = $_REQUEST['frm'];
require("./active_model.php");
$api_model = new active_model;
}
if($frm === "update_employee"){
if(isset($_POST['qry_key'])){
$qry_key = $_POST['qry_key'];
}
if(isset($_POST['emp_code'])){
$emp_code = $_POST['emp_code'];
}
if(isset($_POST['qry_val'])){
$qry_val = $_POST['qry_val'];
}
if(isset($_POST['manager_emp_code'])){
$manager_emp_code = $_POST['manager_emp_code'];
}
if(isset($_POST['emp_id'])){
$emp_id = $_POST['emp_id'];
}
if(isset($_POST['date'])){
$date = $_POST['date'];
}
$created_on = date('Y-m-d H:m:s');
//Monthly data update
$update_emp_query = "update cw_employees set ".$qry_key." = '".$qry_val ."' where employee_code = '".$emp_code."' ";
$update_emp = $api_model->runQuery("$update_emp_query");
if($update_emp){
if($qry_key === "stop_pay_status"){
$process_month = date("m-Y",strtotime($date));
$remarks = "Payment Stoped for this month of $process_month";
$stop_pay_qry = 'INSERT INTO cw_employees_stop_payment (prime_employees_id,stop_pay_month,stop_payment_type,stop_payment_remark,trans_created_by,trans_created_date) VALUES ("'.$emp_id .'","'.$process_month .'","2","'.$remarks .'","'.$manager_emp_code .'","'.$created_on .'")';
//echo $stop_pay_qry; die;
$stop_pay = $api_model->runQuery("$stop_pay_qry");
}
echo json_encode(array('success' => True,'message' => "Updated successfully"));
}else{
echo json_encode(array('success' => False,'message' => "Please try again Later"));
}
}else{
echo json_encode(array('success' => False,'message' => "Server Timeout!"));
}
?>