<?php session_start(); ob_start(); ?>

<?php  include 'header.php'; ?>

<?php
ini_set('display_errors', 0);

if(empty($_SESSION['LOGINID']) && empty($_SESSION['LOGINNM']) ){

	header("Location:index.php");
}


include("user.php");


$action = $_GET['action'];

 $eid = mysqli_real_escape_string($connection, $_GET['id']);

?>



<!DOCTYPE html>
<html lang="en">

<head>
    <meta charset="utf-8">
    <meta http-equiv="X-UA-Compatible" content="IE=edge">
    <meta name="viewport" content="width=device-width, initial-scale=1">
    <title>Video Assignments</title>
    <!-- ================= Favicon ================== -->
    <!-- Standard -->
    <link rel="shortcut icon" href="http://placehold.it/64.png/000/fff">
    <!-- Retina iPad Touch Icon-->
    <link rel="apple-touch-icon" sizes="144x144" href="http://placehold.it/144.png/000/fff">
    <!-- Retina iPhone Touch Icon-->
    <link rel="apple-touch-icon" sizes="114x114" href="http://placehold.it/114.png/000/fff">
    <!-- Standard iPad Touch Icon-->
    <link rel="apple-touch-icon" sizes="72x72" href="http://placehold.it/72.png/000/fff">
    <!-- Standard iPhone Touch Icon-->
    <link rel="apple-touch-icon" sizes="57x57" href="http://placehold.it/57.png/000/fff">
    <!-- Styles -->
     <link href="assets/css/lib/data-table/buttons.bootstrap.min.css" rel="stylesheet" />
    <link href="assets/css/lib/font-awesome.min.css" rel="stylesheet">
    <link href="assets/css/lib/themify-icons.css" rel="stylesheet">
    <link href="assets/css/lib/owl.carousel.min.css" rel="stylesheet" />
    <link href="assets/css/lib/owl.theme.default.min.css" rel="stylesheet" />
    <link href="assets/css/lib/weather-icons.css" rel="stylesheet" />
    <link href="assets/css/lib/menubar/sidebar.css" rel="stylesheet">
    <link href="assets/css/lib/bootstrap.min.css" rel="stylesheet">
    <link href="assets/css/lib/unix.css" rel="stylesheet">
    <link href="assets/css/style.css" rel="stylesheet">
</head>

<body>

   
   
   
     <?php include("sidebar.php"); ?>
	
	
    <!-- /# sidebar -->
     <?php include("top.php"); ?>
	<!-- /# topebar --> 
	
	
	
    <div class="content-wrap">
        <div class="main">
            <div class="container-fluid">
                <div class="row">
                    <div class="col-lg-8 p-r-0 title-margin-right">
                        <div class="page-header">
                            <div class="page-title">
                                <h1>Hello, <span>Welcome Here</span></h1>
                            </div>
                        </div>
                    </div>
                    <!-- /# column -->
                    <div class="col-lg-4 p-l-0 title-margin-left">
                        <div class="page-header">
                            <div class="page-title">
                                <ol class="breadcrumb text-right">
                                    <li><a href="#">Dashboard</a></li>
                                    <li class="active">Home</li>
                                </ol>
                            </div>
                        </div>
                    </div>
                    <!-- /# column -->
                </div>
                <!-- /# row -->
                <section id="main-content">
				
				
			
				
				
				
				
				
				<div class="row">
				
				        <div class="col-lg-12">
						
						<div class="panel panel-info m-t-15">
                                            <div class="panel-heading">Video Editor Assignments</div>
                                            <div class="panel-body">
						
								

								  
								  
								  
								  
								  <?php
								  
								  
								  if (isset($_POST['sub_id'])) {
										 $phid=$_POST['phid'];
										 $ev_id=$_POST['ev_id'];
										 $sqlUpdate = "UPDATE vd_edit SET
  status = 'checked'
												  											  
 WHERE
 id = '$phid'           
";

$sqlUpdate = mysqli_query($connection, $sqlUpdate); 
											 
$sql="INSERT INTO `notifications` (`id`, `details`, `ev_id`, `status`,`type`, `added_at`, `updated_at`) VALUES (NULL, 'Video Editing Done', '$ev_id', '1', '2', CURRENT_TIMESTAMP, CURRENT_TIMESTAMP);";											 
											
mysqli_query($connection, $sql); 
										      echo "<div>
											 </br>
											 </div>";
											 include_once('updated.html');
									}
								  
								  
								  
								  
								  
								  
								  
								  
								  
								  
								  if (isset($_POST['submitbt_vd'])) {
									  
									
									  
								
											    $vd_edit_id=$_POST['vd_edit_id'];
	$vd_editor=$_POST['vd_editor'];
	
	$vd_edit_date=$_POST['vd_edit_date'];
	if($vd_edit_date==""){
		$sqlUpdate = mysqli_query($connection, "UPDATE `vd_edit` SET `date` = NULL WHERE `vd_edit`.`id` = '$vd_edit_id';"); 
		}
		else {
			$sqlUpdate = mysqli_query($connection, "UPDATE `vd_edit` SET `date` = '$vd_edit_date' WHERE `vd_edit`.`id` = '$vd_edit_id';"); 
		}
	$vd_hdd=$_POST['hdd'];
	$vd_remarks=$_POST['remarks'];
	$vd_edit_status=$_POST['vd_edit_status'];
	if($vd_edit_status==""){
		$sqlUpdate = mysqli_query($connection, "UPDATE `vd_edit` SET `status` = '' WHERE `vd_edit`.`id` = '$vd_edit_id';"); 
		}
		else {
			$sqlUpdate = mysqli_query($connection, "UPDATE `vd_edit` SET `status` = 'checked' WHERE `vd_edit`.`id` = '$vd_edit_id';"); 
		}
	
	
	
	$sqlUpdate = "UPDATE vd_edit SET
  editor = '$vd_editor',
 hdd = '$vd_hdd',
 remarks = '$vd_remarks'
												  											  
 WHERE
 id = '$vd_edit_id'           
";

$sqlUpdate = mysqli_query($connection, $sqlUpdate); 
											 
											 echo "<div>
											 </br>
											 </div>";
											 include_once('updated.html');
								
										  
										  
										 
											
										
									  
								  }
								  
								  ?>
								  
								  
								  
								  
								  
								  
								  
								  
								  
                                    <div class="row">
                        <div class="col-lg-12">
                            <div class="card alert">
							
							
							
							
							
							
							
							
							
							
							
                               
								
								
								
								
								
								<?php
								
								
								
						
					if ($user_type==3){  ?>
								
								
								 <div class="bootstrap-data-table-panel">
                                    <div class="table-responsive">
                                        <table id="bootstrap-data-table-export" class="table table-striped table-bordered">
                                            <thead>
                                                <tr>
												      <th>SL.</th>
                                                     <th>Ass. Date</th>
													 <th>Editor</th>
													  <th>Event Date</th>
													   <th>Booking ID</th>
													    <th>Diary of</th>
														<th>Event Type</th>
														<th>VG Names</th>
                                                    <th>HDD No</th>
                                                    
													<th>Remarks</th>
													<th>Status</th>
													<th>Action</th>
													
                                                </tr>
                                            </thead>
                                            <tbody>
											
											<?php

						$sqlSelectedLG = "select g1.id,g1.evidn, g1.date as ev_date,g1.booking_id,g1.booking_name,g1.event_type,g1.vd_names,g1.booking_status,g2.id phid, g2.* from (SELECT v1.* , GROUP_CONCAT(v2.name ORDER BY v2.id) as vd_names FROM (SELECT p1.* , GROUP_CONCAT(p2.name ORDER BY p2.id) as ph_names FROM (select a1.* , a2.name as event_type from (SELECT t1.*,t1.id evidn, t2.name as client_name, t2.booking_id,t2.booking_name, t2.cell_1,t2.cell_2,t2.status booking_status FROM `events` as t1 left join bookings as t2 on t1.temp_id=t2.id order by t1.date) as a1 left join event_types as a2 on a1.type=a2.id) as p1 left join artists as p2 ON FIND_IN_SET(p2.id, p1.photographers) group by p1.id) as v1 left join artists as v2 ON FIND_IN_SET(v2.id, v1.videographers) group by v1.id ORDER BY TIMESTAMP(v1.date,v1.time) ) as g1 LEFT JOIN (select x1.*, x2.name FROM `vd_edit` as x1 left join users as x2 on x1.editor=x2.id) as g2 on g1.id=g2.event_id where g2.status!='checked' AND g2.editor='$ad_id' ";
						
						if (($_GET['all']) == "yes" ) {
							$sqlSelectedLG = "select g1.id,g1.evidn, g1.date as ev_date,g1.booking_id,g1.booking_name,g1.event_type,g1.vd_names,g1.booking_status,g2.id phid, g2.* from (SELECT v1.* , GROUP_CONCAT(v2.name ORDER BY v2.id) as vd_names FROM (SELECT p1.* , GROUP_CONCAT(p2.name ORDER BY p2.id) as ph_names FROM (select a1.* , a2.name as event_type from (SELECT t1.*,t1.id evidn, t2.name as client_name, t2.booking_id,t2.booking_name, t2.cell_1,t2.cell_2,t2.status booking_status FROM `events` as t1 left join bookings as t2 on t1.temp_id=t2.id order by t1.date) as a1 left join event_types as a2 on a1.type=a2.id) as p1 left join artists as p2 ON FIND_IN_SET(p2.id, p1.photographers) group by p1.id) as v1 left join artists as v2 ON FIND_IN_SET(v2.id, v1.videographers) group by v1.id ORDER BY TIMESTAMP(v1.date,v1.time) ) as g1 LEFT JOIN (select x1.*, x2.name FROM `vd_edit` as x1 left join users as x2 on x1.editor=x2.id) as g2 on g1.id=g2.event_id where g2.status='checked' AND g2.editor='$ad_id' ";
						}

$sqlSelectedLG = mysqli_query($connection, $sqlSelectedLG);
while ($list = mysqli_fetch_object($sqlSelectedLG)) {

                                     $phid = $list->phid;
                                   
                                    $idn = $list->evidn;
									$as_date = $list->date;
									$vd_editor_name = $list->name;
									 $ev_date = $list->ev_date;
								   $booking_id = $list->booking_id;
									$diary_of = $list->booking_name;
									$event_type = $list->event_type;
									$vd_names = $list->vd_names;
									$vd_hdd = $list->hdd;
																			 
									$vd_remarks = $list->remarks; 	 	   
                                  $vd_edit_status = $list->status; 	 
									
									if($vd_edit_status==""){$vd_edit_status='pending';}
									if($vd_edit_status=="checked"){$vd_edit_status='done';}
									
									
										$sl=$sl+1;
								
                                    
                                   
                                ?>
											
											
											
											
                                                <tr>
												    <td> <?php echo $sl;  ?> </td>
												
                                                    <td>  <?php echo $as_date;  ?> </td>
													   <td><?php echo $vd_editor_name;  ?></td>
                                                    <td><?php echo $ev_date;  ?></td>
                                                    <td><?php echo $booking_id;  ?></td>
													  <td><?php echo $diary_of;  ?></td>
                                                    <td><?php echo $event_type;  ?></td>
													 <td><?php echo $vd_names;  ?></td>
													  <td><?php echo $vd_hdd;  ?></td>
													
														<td><?php echo $vd_remarks;  ?></td>
														<td><?php echo $vd_edit_status;  ?></td>
													
													<td>

<?php if (($_GET['all'])!= "yes" ) { ?>

													<form action='assignments_video.php' method='post'>
													<a href="event_print.php?id=<?php echo $idn;  ?>" target="_blank"> <button class="info" type="button"> <i class="ti-printer"></i> </button> </a>
													<input type='hidden' name='phid' value='<?php echo $phid;  ?>'>
														<input type='hidden' name='ev_id' value='<?php echo $idn;  ?>'>
													<button class="btn done btn-success btn-md" onclick="return confirm('Are you sure you want to mark this done?');" type="submit" name='sub_id' ><i class="ti-check"></i></button> 
<?php } ?>												  </form>	
													</td>
													
													
                                                </tr>
                                                
												
<?php } ?>			
												
                                            </tbody>
                                        </table>
                                    </div>
                                </div>
								
								<?php   } ?>
								
                            </div>
                            <!-- /# card -->
                        </div>
                        <!-- /# column -->
                    </div>

                                   


							 </div> </div>
							
                        </div>
				
				
                        <!-- /# column -->
                        
                    </div>
				
				
				
				
				
                    <!-- /# row -->
                     <?php include("footer.php"); ?>
                </section>
            </div>
        </div>
    </div>

    <div id="search">
        <button type="button" class="close">×</button>
        <form>
            <input type="search" value="" placeholder="type keyword(s) here" />
            <button type="submit" class="btn btn-primary">Search</button>
        </form>
    </div>


    </div>
    <script src="assets/js/lib/jquery.min.js"></script>
    <!-- jquery vendor -->
    <script src="assets/js/lib/jquery.nanoscroller.min.js"></script>
    <!-- nano scroller -->
    <script src="assets/js/lib/menubar/sidebar.js"></script>
    <script src="assets/js/lib/preloader/pace.min.js"></script>
    <!-- sidebar -->
    <script src="assets/js/lib/bootstrap.min.js"></script>
    <!-- bootstrap -->
   
    <script src="assets/js/scripts.js"></script>
	
	 <script src="assets/js/lib/data-table/datatables.min.js"></script>
    <script src="assets/js/lib/data-table/buttons.dataTables.min.js"></script>
    <script src="assets/js/lib/data-table/dataTables.buttons.min.js"></script>
    <script src="assets/js/lib/data-table/buttons.flash.min.js"></script>
    <script src="assets/js/lib/data-table/jszip.min.js"></script>
    <script src="assets/js/lib/data-table/pdfmake.min.js"></script>
    <script src="assets/js/lib/data-table/vfs_fonts.js"></script>
    <script src="assets/js/lib/data-table/buttons.html5.min.js"></script>
    <script src="assets/js/lib/data-table/buttons.print.min.js"></script>
    <script src="assets/js/lib/data-table/datatables-init.js"></script>



</body>

</html>