<?php
 
 //api_controller?frm=save_rms&post_data=post_data
	$frm = "";
	/* Module Initilization */
	if (isset($_REQUEST["frm"])){
	    $frm = $_REQUEST['frm']; 
	    require("./api_model.php");
	    $api_model = new api_model;
	}
	if($frm === "offer_save"){
		$rms_code ="";
		if(isset($_POST['candidate_code'])){
			$rms_code = $_POST['candidate_code'];
		}
		$mobile_number ="";
		if(isset($_POST['mobile_number'])){
			$mobile_number = $_POST['mobile_number'];
		}
		$candidate_name ="";
		if(isset($_POST['candidate_name'])){
			$candidate_name = $_POST['candidate_name'];
		}
		$department ="";
		/*if(isset($_POST['department'])){
			$department = $_POST['department'];
		}*/
		$post_applied_for ="";
		/*if(isset($_POST['post_applied_for'])){
			$post_applied_for = $_POST['post_applied_for'];
		}*/
		$salary_commited ="";
		if(isset($_POST['salary_commited'])){
			$salary_commited = $_POST['salary_commited'];
		}
		$doj ="";
		if(isset($_POST['date_of_joining'])){
			$doj = date('Y-m-d',strtotime($_POST['date_of_joining']));
		}
		$candidate_branch ="";
		if(isset($_POST['company_branch'])){
			$candidate_branch = $_POST['company_branch'];
		}
		$candidate_loc ="";
		if(isset($_POST['company_location'])){
			$candidate_loc = $_POST['company_location'];
		}
		$candidate_email ="";
		if(isset($_POST['email_id'])){
			$candidate_email = $_POST['email_id'];
		}
		$resend_mail ="";
		if(isset($_POST['resend_mail'])){
			$resend_mail = $_POST['resend_mail'];
		}
		$rslt ="";
		if($rms_code){
			$exit_qry  = 'select count(*) as rslt from cw_offer_letter where rms_code ="'.$rms_code.'" and trans_status =1';
			$exit_rslt =  $api_model->is_exit_data($exit_qry);
			$exit_count = $exit_rslt[0]->rslt;
			if((int)$exit_count === 0){
				$offer_reference_number = $api_model->generate_number();
				$prime_insert_query = 'insert into cw_offer_letter (rms_code,employee_name,employee_mobile_number,emp_dept,employee_designation,salary,branch,offer_location,employee_email_id,joining_date,offer_reference_number) values ("'.$rms_code.'","'.$candidate_name.'","'.$mobile_number.'","'.$department.'","'.$post_applied_for.'","'.$salary_commited.'","'.$candidate_branch.'","'.$candidate_loc.'","'.$candidate_email.'","'.$doj.'","'.$offer_reference_number.'")';
				$rslt = $api_model->offer_insert($prime_insert_query);
			}else{
				//, emp_dept = "'. $department .'",employee_designation = "'. $post_applied_for .'"
				$prime_update_query  = 'UPDATE cw_offer_letter SET employee_mobile_number = "'. $mobile_number .'",employee_name = "'. $candidate_name .'",salary = "'. $salary_commited .'",branch = "'. $candidate_branch .'",offer_location = "'. $candidate_loc .'",employee_email_id = "'. $candidate_email .'",joining_date = "'. $doj .'" WHERE rms_code = "'. $rms_code .'" and trans_status =1';
				$rslt = $api_model->offer_update($prime_update_query,$rms_code,$resend_mail);
			}
		}
		return_rslt($frm,$rslt);
	}else{
	    echo json_encode(array(
			'Status' => 400,
	        'success' => False,
	        'data' => "Bad Request"
	    ));
	}
	function return_rslt($frm,$rslt){
		if(!$rslt){
			echo json_encode(array('success' => FALSE, 'sts' =>"No Record found"));
		}else{
			echo json_encode(array('success' => TRUE, "$frm" => $rslt));
		}
	}
?>