<?php
	$frm = "";
	if(isset($_REQUEST['frm'])){
		$frm = $_REQUEST['frm'];
		require("./offer_model.php");
		$api_model            = new offer_model;
		$controller_name      = 'offer_letter';
		$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_".$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){
				if((int)$date_type === 1){
					$value = date('Y-m-d',strtotime($value));
				}else{
					$value = $value;
				}
			}else
			if((int)$field_type === 13){
				$value = date('Y-m-d H:i:s',strtotime($value));
			}

			if(($input_view_type === 1) || ($input_view_type === 2)){
				$prime_qry_key     .= $label_id.",";
				$prime_qry_value   .= '"'.$value.'",';
				$prime_upd_query   .= $label_id.' = "'.$value.'",';
			}
		}
		
		$created_on = date("Y-m-d H:i:s");
		$prime_table  = "cw_".$controller_name;
		$logged_id  = 1;
		if((int)$form_id === 0){
			$prime_qry_key     .= "trans_created_by,trans_created_date";
			$prime_qry_value   .= '"'.$logged_id.'",'.'"'.$created_on.'"';
			$prime_insert_query = "insert into $prime_table ($prime_qry_key) values ($prime_qry_value)";
			$insert_result = $api_model->get_save($prime_insert_query);
			echo json_encode(array('success' => TRUE, 'message' => "Successfully added", 'insert_id' => $insert_result));
		}else{
            $prime_upd_query    .= 'enroll_status= "2",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_".$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_offer"){
		$offer_code   = $_POST['offer_code'];
		$_SESSION['offer_code']    = $offer_code;
		$offer_exit_qry  = 'select count(*) as offer_count,prime_offer_letter_id,enroll_status from cw_offer_letter where offer_reference_number= "'.$offer_code.'" and trans_status = 1';
		$offer_exit_data  = $api_model->is_exit_data($offer_exit_qry);
		$offer_count      = $offer_exit_data[0]->offer_count;
		$insert_id        = $offer_exit_data[0]->prime_offer_letter_id;
		$enroll_status    = $offer_exit_data[0]->enroll_status;
		if(((int)$offer_count === 1) && (((int)$enroll_status === 1) || ((int)$enroll_status === 4))){
			$form_rslt  =  $api_model->get_form_data($offer_code);
			echo json_encode(array('success' => True, "message" => "Please upload original scanned documents!!!",'form_rslt'=>$form_rslt['rslt_info'],'row_set_data'=>$form_rslt['row_view_list'],'insert_id'=>$insert_id,'enroll_status'=>$enroll_status));
		}else
		if(((int)$offer_count === 1) && ((int)$enroll_status === 2)){
			echo json_encode(array('success'=>False,'message'=>'Waiting for Hr verification'));
		}else
		if(((int)$offer_count === 1) && ((int)$enroll_status === 3)){
			echo json_encode(array('success'=>False,'message'=>'Approved your document, contact Hr Team'));
		}else
		if(((int)$offer_count === 1) && ((int)$enroll_status === 5)){
			echo json_encode(array('success'=>False,'message'=>'No response for document upload'));
		}else{
			echo json_encode(array('success'=>False,'message'=>'Please enter the valid offer number'));
		}	
	}
?>