<?php
 include_once("../../../cfg/conn.php");  
 include ("../functions/users.php");
//error_reporting(0);
if(isset($_POST['saveTheMan'])){	
    $selectedRecord = sanitize($_POST['selectedRecord']);
    $dealerID = sanitize($_POST['dealerID']);
    $companyID = sanitize($_POST['companyID']);
    $manHeadercomID = sanitize($_POST['manHeadercomID']);
    
    $rtTargetJan = sanitize($_POST['rtTargetJan']);
    $rtActualJan = sanitize($_POST['rtActualJan']);
    $rtRateJan = sanitize($_POST['rtRateJan']);
    
    $flTargetJan = sanitize($_POST['flTargetJan']);
    $flActualJan =sanitize($_POST['flActualJan']);
    $flRateJan = sanitize($_POST['flRateJan']);

    $opsTargetJan = sanitize($_POST['opsTargetJan']);
    $opsActualJan = sanitize($_POST['opsActualJan']);
    $opsRateJan = sanitize($_POST['opsRateJan']);

    $manTargetJan = sanitize($_POST['manTargetJan']);
    $manActualJan = sanitize($_POST['manActualJan']);
    $manRateJan = sanitize($_POST['manRateJan']);
    
 
    $sql = "UPDATE mancom_data SET `retail_actual_sales`='$rtActualJan',`retail_target_sales`='$rtTargetJan',`retail_target_vs_actual_rate`='$rtRateJan',
    `fleet_actual_sales`='$flActualJan',`fleet_target_sales`='$flTargetJan',`fleet_target_vs_actual`='$flRateJan',
    `ops_total_sales`='$opsActualJan',`ops_total_target`='$opsTargetJan',`ops_target_vs_actual`='$opsRateJan',
    `plant_target_sales`='$manTargetJan',`plant_actual_sales`='$manActualJan',`plant_target_vs_actual`='$manRateJan', 
    `updated_by`='$userID'='', `date_updated`='$myTimeStamp' WHERE `mancom_hdr_id`='$manHeadercomID' AND  `month_id`='$selectedRecord'"; // AND `comp_id`='$companyID' AND `deal_id`='$dealerID'

    if($conn->query($sql) === TRUE) {
		
	} else {
       
    } 
    echo "Record updated.";
$conn->close(); 
}
//1 jan 1 1
//3 jan 1 3
?>