<?php
	session_start();
	error_reporting(E_ALL);
ini_set('display_errors', '1');
	require_once "_config.php";
	
	$action=$_POST["action"];
	
	if($action=="Insert"){
		
		$uname=mysqli_real_escape_string($con,$_POST["uname"]);
		$utype=mysqli_real_escape_string($con,$_POST["utype"]); 

		if($utype == "PRIMARY")
		{
			$utype = "PRIMARY";
		}else{
			$utype ="";
		}

		$sql="insert into temp_tbl_units (uname,utype) values ('{$uname}','{$utype}') ";
		$con->query($sql);
		
		$now = date("Y-m-d H:i:s");
		$sql1="insert into `{$_SESSION["fyear"]}_tbl_logs` (uid,log_date,log_type,log_mode,log_text) values ('{$_SESSION["logs"]["uid"]}','{$now}','Unit','Entry','{$uname}')"; 
		$con->query($sql1);	 
		$cid = $con->insert_id;
		
		$data["td1"] = "";
		$data["td2"] = "{$uname}";
		$data["td3"] = "{$utype}";
		$data["td4"] = "
			<button type='button' class='btn btn-sm btn-icon btn-active-color-primary  edit' uid='{$uid}' > <i class='fa fa-edit'></i> </button>
			<button type='button' class='btn btn-sm btn-icon btn-active-color-primary del_row' uid='{$uid}'> <i class='fa fa-trash'></i> </button>
		";
		
		echo json_encode($data);
	}
		 
	if($action=="Edit"){
		
		$uname=mysqli_real_escape_string($con,$_POST["uname"]);
		$utype=mysqli_real_escape_string($con,$_POST["utype"]); 
		$sql="update temp_tbl_units set uname='{$uname}',utype='{$utype}' where uid='{$_POST["uid"]}'";
		$con->query($sql);
		
		$now = date("Y-m-d H:i:s"); 
		$sql1="insert into `{$_SESSION["fyear"]}_tbl_logs` (uid,log_date,log_type,log_mode,log_text) values ('{$_SESSION["logs"]["uid"]}','{$now}','Unit','Change','{$uname}')";  
		$con->query($sql1); 
		
		$data["td2"] = "{$uname}";
		$data["td3"] = "{$utype}";
		echo json_encode($data);  
	}
	 
	if($action=="Delete"){
		$now = date("Y-m-d H:i:s");
		
		$row=single($con,"select * from temp_tbl_units  where uid='{$_POST["uid"]}'"); 

		
		$sql1="insert into `{$_SESSION["fyear"]}_tbl_logs` (uid,log_date,log_type,log_mode,log_text) values ('{$_SESSION["logs"]["uid"]}','{$now}','Supplier','Delete','{$row["sname"]}')";  
		$con->query($sql1);    
		
		
		$sql="delete from temp_tbl_units where uid='{$_POST["uid"]}'";
		$con->query($sql); 
		     
	}  
?>