<?php
include('connection.php');
$order_no=$_POST['order_no'];
$address=$_POST['address'];
$munci=$_POST['munci'];
$thaluk=$_POST['thaluk'];
$customer=$_POST['customer'];
$contact=$_POST['contact'];
$city=$_POST['city'];
$state=$_POST['state'];
$pin=$_POST['pin'];
$gst=$_POST['gst'];
$program=$_POST['program'];
$program_date=$_POST['program_date'];
if(empty($program_date))
$program_date="0000-00-00";
$totalamount=$_POST['totalamount'];
$famount=$_POST['famount'];
$cid=$_REQUEST['id'];
$lid=$_POST['lid'];
$remarks=$_POST['remarks'];
$doi=$_POST['doi'];
$company=$_POST['company'];
$product=$_POST['product'];

$district=$_POST['district'];
$p_capacity=$_POST['p_capacity'];
$gmap = mysqli_real_escape_string($con,$_POST['gmap']);

$sql2="select * from customer_details where cid='$cid'";
$result2=mysqli_query($con,$sql2)or die(mysqli_error());
$row2=mysqli_fetch_array($result2);
$file1=$row2['file1'];
$file2=$row2['file2'];

$doce1=$row2['doc1'];
$doce2=$row2['doc2'];
$doce3=$row2['doc3'];
$doce4=$row2['doc4'];


if(!empty($_FILES["file1"]["tmp_name"]))
 {
$uploads_dir = 'uploads/customer';

        $tmp_name = $_FILES["file1"]["tmp_name"];
        $name = basename($_FILES["file1"]["name"]);
        $random_digit=rand(0000,9999);
        $new_file_name1=$random_digit.$name;

        move_uploaded_file($tmp_name, "$uploads_dir/$new_file_name1");
		unlink('uploads/customer/'.$file1);
		if(empty($new_file_name1))
			$new_file_name1=$file1;
 }
 else
	 $new_file_name1=$file1;
	 
if(!empty($_FILES["file2"]["tmp_name"]))
 {
$uploads_dir = 'uploads/customer';

        $tmp_name = $_FILES["file2"]["tmp_name"];
        $name = basename($_FILES["file2"]["name"]);
        $random_digit=rand(0000,9999);
        $new_file_name2=$random_digit.$name;

        move_uploaded_file($tmp_name, "$uploads_dir/$new_file_name2");
		unlink('uploads/customer/'.$file2);
		if(empty($new_file_name2))
			$new_file_name2=$file2;
 }
 else
	 $new_file_name2=$file2;
	 
	 if(!empty($_FILES["doc1"]["tmp_name"]))
 {
        $uploads_dir = 'uploads';
        $tmp_name = $_FILES["doc1"]["tmp_name"];
        $name = basename($_FILES["doc1"]["name"]);
        $random_digit=rand(0000,9999);
        $doc1=$random_digit.$name;
		move_uploaded_file($tmp_name, "$uploads_dir/$doc1");
 }
 else
 $doc1=$doce1;
 
 
 	 if(!empty($_FILES["doc2"]["tmp_name"]))
 {
        $uploads_dir = 'uploads';
        $tmp_name = $_FILES["doc2"]["tmp_name"];
        $name = basename($_FILES["doc2"]["name"]);
        $random_digit=rand(0000,9999);
        $doc2=$random_digit.$name;
		move_uploaded_file($tmp_name, "$uploads_dir/$doc2");
 }
 else
 $doc2=$doce2;
 
 
 	 if(!empty($_FILES["doc3"]["tmp_name"]))
 {
$uploads_dir = 'uploads';
        $tmp_name = $_FILES["doc3"]["tmp_name"];
        $name = basename($_FILES["doc3"]["name"]);
        $random_digit=rand(0000,9999);
        $doc3=$random_digit.$name;
		move_uploaded_file($tmp_name, "$uploads_dir/$doc3");
 }
 else
 $doc3=$doce3;
 
 
 	 if(!empty($_FILES["doc4"]["tmp_name"]))
 {
        $uploads_dir = 'uploads';
        $tmp_name = $_FILES["doc4"]["tmp_name"];
        $name = basename($_FILES["doc4"]["name"]);
        $random_digit=rand(0000,9999);
        $doc4=$random_digit.$name;
		move_uploaded_file($tmp_name, "$uploads_dir/$doc4");
 }
 else
 $doc4=$doce4;

if(isset($_REQUEST['submit']))
{
    if(empty($lid))
    {
      $sql="update customer_details set order_no='$order_no',address='$address',city='$city',state='$state',pin='$pin',gst='$gst',program='$program',pdate='$program_date',total_amount='$totalamount',famount='$famount',remarks='$remarks' ,`file1`='$new_file_name1',`file2`='$new_file_name2',`customer`='$customer', `phone`='$contact',district='$district',p_capacity='$p_capacity',doc1='$doc1',doc2='$doc2',doc3='$doc3',doc4='$doc4',munci='$munci',thaluk='$thaluk',gmap='$gmap' ,doi='$doi',company='$company',product='$product' where cid='$cid'";  
    }
    else
    {
 $sql="update customer_details set lid='$lid',order_no='$order_no',address='$address',city='$city',state='$state',pin='$pin',gst='$gst',program='$program',pdate='$program_date',total_amount='$totalamount',famount='$famount',remarks='$remarks' ,`file1`='$new_file_name1',`file2`='$new_file_name2',`customer`='$customer', `phone`='$contact',district='$district',p_capacity='$p_capacity',doc1='$doc1',doc2='$doc2',doc3='$doc3',doc4='$doc4',munci='$munci',thaluk='$thaluk',gmap='$gmap' ,doi='$doi',product='$product' where cid='$cid'";
}
	mysqli_query($con,$sql);
	header('location:customer_management.php?log=edit');
	echo '<META HTTP-EQUIV="Refresh" Content="0; URL=customer_management.php?log=edit">'; 
}
?>