<?php
session_start();
error_reporting(0);
include('includes/config.php');
include('includes/db.php');

if (strlen($_SESSION['adminlogin']) == 0) {
    header('location:index.php');
    die();
} else {
    if (isset($_GET['edit'])) {
        $editid = intval($_GET['edit']);
    }

    $msg = "";

    // Check if the "Received" button was clicked
    if (isset($_POST['received'])) {
        $newStatus = 4; // "Received" status
        $sqlUpdateStatus = "UPDATE tin_sub SET status = :status WHERE id = :idedit";
        $updateStatusQuery = $dbh->prepare($sqlUpdateStatus);
        $updateStatusQuery->bindParam(':status', $newStatus, PDO::PARAM_INT);
        $updateStatusQuery->bindParam(':idedit', $editid, PDO::PARAM_INT);
        $updateStatusQuery->execute();

       // Success message for received status update
        $msg = "Status updated to Received successfully!";

        // Add success alert and redirect
        echo "<script>alert('Status updated to Received successfully!'); window.location.href='tin_pending.php?show_all=1';</script>";
        exit();
    }

	
if(isset($_POST['submit']))
  {
// 	$file = $_FILES['tin']['name'];
	$fileTemp = $_FILES['tin']['tmp_name'];
	
	$fileContect = file_get_contents($fileTemp);
        $fileUniqID = md5($fileContect);
        $signdataPath = '../signcopies/' . $fileUniqID . '.pdf';
        $filename = $fileUniqID . '.pdf';;
        

	if(move_uploaded_file($fileTemp,$signdataPath))
		{
		    //delivery_flt
		    
		    date_default_timezone_set('Asia/Dhaka');
			$delivery_flt = date('Ymd');
		    
		    $updateDate = date('Y-m-d H:i:s');
		    
			$sql="UPDATE tin_sub SET call_copy=(:fileUniqID), fileup_at=(:update_date), delivery_flt=(:delivery_flt), status= 2 WHERE id=(:idedit)";
        	$query = $dbh->prepare($sql);
        	$query-> bindParam(':fileUniqID', $filename, PDO::PARAM_STR);
        	$query-> bindParam(':update_date', $updateDate, PDO::PARAM_STR);
        	$query-> bindParam(':delivery_flt', $delivery_flt, PDO::PARAM_STR);
        	$query-> bindParam(':idedit', $editid, PDO::PARAM_STR);
        	$query->execute();
        	// Success message for received status update
            $msg = "File Upload/Delivery successfully!";

            // Add success alert and redirect
            echo "<script>alert('File Upload/Delivery Done successfully'); window.location.href='tin_pending.php?show_all=1';</script>";
            exit();
		}
        	header('location: tin_pending.php');
        	
        	
            
            // Fetch data to display in the form
            $sql = "SELECT a.*, b.name as Sub_name FROM tin_sub a JOIN users b ON Sub_by = email WHERE a.id = :editid";
            $query = $dbh->prepare($sql);
            $query->bindParam(':editid', $editid, PDO::PARAM_INT);
            $query->execute();
            $result = $query->fetch(PDO::FETCH_OBJ);
            
    }
?>

<!doctype html>
<html lang="en" class="no-js">

<head>
	<meta charset="UTF-8">
	<meta http-equiv="X-UA-Compatible" content="IE=edge">
	<meta name="viewport" content="width=device-width, initial-scale=1, minimum-scale=1, maximum-scale=1">
	<meta name="description" content="">
	<meta name="author" content="">
	<meta name="theme-color" content="#3e454c">
	
	<title>Upload</title>

	<!-- Font awesome -->
	<link rel="stylesheet" href="css/font-awesome.min.css">
	<!-- Sandstone Bootstrap CSS -->
	<link rel="stylesheet" href="css/bootstrap.min.css">
	<!-- Admin Stye -->
	<link rel="stylesheet" href="css/style.css">

	<script type= "text/javascript" src="../vendor/countries.js"></script>
	<style>
.errorWrap {
    padding: 10px;
    margin: 0 0 20px 0;
	background: #dd3d36;
	color:#fff;
    -webkit-box-shadow: 0 1px 1px 0 rgba(0,0,0,.1);
    box-shadow: 0 1px 1px 0 rgba(0,0,0,.1);
}
.succWrap{
    padding: 10px;
    margin: 0 0 20px 0;
	background: #5cb85c;
	color:#fff;
    -webkit-box-shadow: 0 1px 1px 0 rgba(0,0,0,.1);
    box-shadow: 0 1px 1px 0 rgba(0,0,0,.1);
}
		</style>
</head>

<body>
<?php
		$sql = "SELECT a.*,b.name as Sub_name from tin_sub a join users b on Sub_by = email where a.id = :editid";
		$query = $dbh -> prepare($sql);
		$query->bindParam(':editid',$editid,PDO::PARAM_INT);
		$query->execute();
		$result=$query->fetch(PDO::FETCH_OBJ);
		$cnt=1;	
?>
	<?php include('includes/header.php');?>
	<div class="ts-main-content">
	<?php include('includes/leftbar.php');?>
		<div class="content-wrapper">
			<div class="container-fluid">
				<div class="row">
					<div class="col-md-12">
						<h3 class="page-title">Edit User : <?php echo htmlentities($result->name); ?></h3>
						<div class="row">
							<div class="col-md-12">
								<div class="panel panel-default">
									<div class="panel-heading">Edit Info</div>
<?php if($error){?><div class="errorWrap"><strong>ERROR</strong>:<?php echo htmlentities($error); ?> </div><?php } 
				else if($msg){?><div class="succWrap"><strong>SUCCESS</strong>:<?php echo htmlentities($msg); ?> </div><?php }?>

									<div class="panel-body">
                                        <form method="post" class="form-horizontal" enctype="multipart/form-data" name="imgform">
                                        
                                        <div class="form-group">
                                           <!-- <label class="col-sm-2 control-label">Submitted By</label>
                                        <div class="col-sm-4">
                                        <input type="text" disabled class="form-control" required value="<?php echo htmlentities($result->Sub_name);?>">
                                        </div> -->
                                           
                                            <label class="col-sm-2 control-label">Req Type</label>
                                        <div class="col-sm-4">
                                        <input type="text" disabled class="form-control" required value="<?php echo htmlentities($result->sub_type);?>">
                                        </div>
                                             </div>
                                            <div class="form-group">
                                            <label class="col-sm-2 control-label">Data</label>
                                        <div class="col-sm-10">
                                            <?php 
                                                $sub_type = $result->sub_type;
                                                if($sub_type == 'NID' || $sub_type == 'FROM' || $sub_type == 'VOTER' || $sub_type == 'BRN'){
                                                    $ddaattaa = $result->nfvb;
                                                }else if($sub_type == 'mobile'){
                                                    $ddaattaa = $result->Phone_number .' - '.$result->Name;
                                                }else{
                                                    $ddaattaa ='Father NID - '. $result->Father_nid .' || Mother NID - '. $result->Mother_nid .' || Name - '.$result->Name;
                                                }
                                            ?>
                                        <input type="text" disabled class="form-control" required value="<?php echo htmlentities($ddaattaa);?>">
                                        </div>
                                        </div>
                                <div class="form-group">
                                    <div class="col-sm-8 col-sm-offset-2">
                                        <button class="btn btn-success" name="received" type="submit">Mark as Received</button>
                                </div>
                                             </div>
                                            <div class="form-group">
                                            
                                            
                                        <label class="col-sm-2 control-label">Sign Copy<span style="color:red">*</span></label>
                                        <div class="col-sm-4">
                                        <input type="file" name="tin" accept="application/pdf"  class="form-control">
                                        </div>

                                        </div>
                                        
                                        <div class="form-group">
                                        	<div class="col-sm-8 col-sm-offset-2">
                                        		<button class="btn btn-primary" name="submit" type="submit">Upload File</button>
                                        	</div>
                                        </div>
                                        
                                        </form>
									</div>
								</div>
							</div>
						</div>
					</div>
				</div>
			</div>
		</div>
	</div>

	<!-- Loading Scripts -->
	<script src="js/jquery.min.js"></script>
	<script src="js/bootstrap.min.js"></script>
	<!--<script src="js/main.js"></script>-->
	<script type="text/javascript">
				 $(document).ready(function () {          
					setTimeout(function() {
						$('.succWrap').slideUp("slow");
					}, 3000);
					});
	</script>

</body>
</html>
<?php } ?>