<?php
	   
		$path = $_POST["path"];
		$id = (int)$_POST["id"];
		$service = $_POST["service"];
		$name_en = $_POST["name"];
		$cusId = (int)$_POST["customer"];
		require "db.php";
		$st='';
		if(strlen($path)>0){
			$temp = explode("\\",$path);
			$n =count($temp);
			$st = $temp[$n-1];
		}
		if(strcmp($service,"add")==0){
			$sql = "SELECT * FROM details WHERE id = $id";
			$result = mysql_query($sql);
			if(mysql_num_rows($result)>0){
				$sql = "UPDATE details  set file_name_en = '$st', name_en = '$name_en',cusId = $cusId WHERE id = $id";
			}
			else{
				$sql = "INSERT INTO details (name_en,file_name_en,cusId) VALUES ('$name_en','$st',$cusId)";
			}
			if ($_FILES["file"]["error"] > 0)
 			{
  				echo "Error: " . $_FILES["file"]["error"] . "<br />";
  			}
			else
  			{
				if(!file_exists("../files/" . $_FILES["file"]["name"]))
      			{
     				 move_uploaded_file($_FILES["file"]["tmp_name"],"../files/" . $_FILES["file"]["name"]);
					 
     
      			}
    		}
		}
		else if(strcmp($service,"edit")==0){
			if(strlen($path)>0){
				if ($_FILES["file"]["error"] > 0)
 			 	{
  					echo "Error: " . $_FILES["file"]["error"] . "<br />";
  				}
				else
  				{
					if(!file_exists("../files/" . $_FILES["file"]["name"]))
      				{
     					 move_uploaded_file($_FILES["file"]["tmp_name"],"../files/" . $_FILES["file"]["name"]);
					}
    			}
				$sql = "UPDATE details  SET file_name_en = '$st',name_en = '$name_en',cusId = $cusId WHERE id = $id";
			 }
			 else{
			 	$sql = "UPDATE details  SET name_en = '$name_en',cusId = $cusId WHERE id = $id";
			 }
			 
		}
		else{
			$sql = "DELETE FROM details  WHERE id = $id";
		}
		//echo $sql;
		mysql_query($sql);
	
	header("Location: index.php?page=private"); 
?>