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

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

<?php

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

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


include("user.php");

date_default_timezone_set('Asia/Dhaka');
$date_c = date('Y-m-d H:i:s', time());

$add_date=date("Y-m-d");

?>

<!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>Add Event</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">
	   <link href="assets/css/lib/select2/select2.min.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">Approximate Event Add</div>
                                            <div class="panel-body">
											
											<?php


	
if (isset($_POST['submit'])) { 

$date = $_POST['date'];
$details = $_POST['details'];
									
					
					$sqlinsert = "INSERT INTO `event_aprox` (`id`, `date`, `details`, `status`, `added_by`, `added_at`) VALUES (NULL, '$date', '$details', '1', '$ad_id', '$date_c');";
											   
				    $sqlinsert = mysqli_query($connection, $sqlinsert); 
									
					
					
					
					
$sqlUpdate = "INSERT INTO `activity_log` (`id`, `user`, `activity`, `time`) VALUES (NULL, '$ad_id', 'added aprox. event from add approx. event page', '$date_c')";
$sqlUpdate = mysqli_query($connection, $sqlUpdate); 
					
					
											 
 echo "<div>
 </br>
 </div>";
 include_once('updated.html');									  
}


if (isset($_POST['submit_edit'])) { 

$ndate = $_POST['date'];
$ndetails = $_POST['details'];
$eid = $_POST['eid'];								
					
					$sqlup = "UPDATE `event_aprox` SET `details` = '$ndetails',`date` = '$ndate' WHERE `event_aprox`.`id` = '$eid' ;";
											   
				    $sqlup = mysqli_query($connection, $sqlup); 
									
					
					
					
					
$sqlUpdate = "INSERT INTO `activity_log` (`id`, `user`, `activity`, `time`) VALUES (NULL, '$ad_id', 'edit aprox. event from approx. event page', '$date_c')";
$sqlUpdate = mysqli_query($connection, $sqlUpdate); 
					
					
											 
 echo "<div>
 </br>
 </div>";
 include_once('updated.html');									  
}

if (isset($_POST['submit_del'])) { 

$del_id = $_POST['del_id'];
								
					
					$sqlup = "DELETE FROM `event_aprox` WHERE `event_aprox`.`id` = '$del_id' ";
											   
				    $sqlup = mysqli_query($connection, $sqlup); 
						
					
$sqlUpdate = "INSERT INTO `activity_log` (`id`, `user`, `activity`, `time` ) VALUES (NULL, '$ad_id', 'deleted aprox. event from add approx. event page', '$date_c')";
$sqlUpdate = mysqli_query($connection, $sqlUpdate); 
					
					
											 
 echo "<div>
 </br>
 </div>";
 include_once('updated.html');									  
}

											?>
						
                    <div class="row">
                        <div class="col-lg-12">
						
						
						<?php
						if (isset($_GET['action'])) { 

$action=$_GET['action'];
if($action=='edit'){
$edit=$_GET['id'];
	
$sqlSelectedLG = "SELECT * from `event_aprox` where id='$edit' ";
						

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

$edetails = $list->details;
$edate = $list->date;

}	 ?>								
	


<div class="card alert">
                                <div class="card-body">
								
								 <form class="form-valide" action="#" method="post">
								 
								
											 <div class="form-group row">
											<label class="col-lg-2 col-form-label" >Approx. Event Date  </label>
												 <div class="col-lg-2">
												 <input name="date" type="date" value="<?php echo $edate;  ?>" >  </div>
								   </div>
								 <div class="form-group row">
											<label class="col-lg-2 col-form-label" >Approx. Event Details  </label>
												 <div class="col-lg-2">
												 <textarea name='details' rows='3' cols='50' ><?php echo $edetails; ?></textarea>  </div>
								   </div>
								   
								   
							<input type='hidden' name='eid' value='<?php echo $edit;  ?>'/>
										<br> <button type="submit" name="submit_edit" class="btn btn-success">Save it</button> <hr><br>
								
								
								
								
								
								
								
								</form>
								
								
								
								
								
								
                                </div>
                            </div>

<?php
	
}


}
						
						?>
						
						
						<?php
						if (isset($_GET['action'])) { 

$action=$_GET['action'];
if($action=='add'){ ?>
						
						
                            <div class="card alert">
                                <div class="card-body">
								
								 <form class="form-valide" action="#" method="post">
								 
								
											 <div class="form-group row">
											<label class="col-lg-2 col-form-label" >Approx. Event Date  </label>
												 <div class="col-lg-2">
												 <input name="date" type="date" value="<?php echo $add_date;  ?>" >  </div>
								   </div>
								 <div class="form-group row">
											<label class="col-lg-2 col-form-label" >Approx. Event Details  </label>
												 <div class="col-lg-2">
												 <textarea name='details' rows='3' cols='50' ></textarea>  </div>
								   </div>
								   
								   
							
										<br> <button type="submit" name="submit" class="btn btn-success">Add it</button> <hr><br>
								
								
								
								
								
								
								
								</form>
								
								
								
								
								
								
                                </div>
                            </div>
							
						<?php } } ?>							
							
							
							
                        </div>
                                  



                                   


							 </div>




       <div class="row">
                        <div class="col-lg-12">
                            <div class="card alert">
							
							  <a href="add_approx_event.php?action=add"> <button class="btn btn-success btn-md" > ADD NEW </button> </a>
							  
							  
                                <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>Date</th>
                                                    <th>Details</th>
													<th>Added at</th>
													<th>Added By</th>
													
													<th>Action</th>
                                                </tr>
                                            </thead>
                                            <tbody>
											
											<?php
$sl=0;
$sqlSelectedLG = "SELECT t1.*,t2.name from `event_aprox` as t1 left join users as t2 on t1.added_by=t2.id ";
						

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

                                    
                                   
                                    $idn = $list->id;
									$details = $list->details;
									$ev_added_at = $list->added_at;
									$ev_added_at = date('d/m/Y', strtotime( $ev_added_at));
									
								    $date = $list->date;
									$date = date('d/m/Y', strtotime( $date));
									
									$added_by = $list->name;
									
									$status = $list->status;
									if($status=='1'){$st_view='Active';}
									if($status=='2'){$st_view='Deactive';}	 	
									$sl=$sl+1;
                                   
                                ?>
											
											
											
											
											
											
											
											
											
											
											
											
                                                <tr>
                                                    <td><?php echo $sl;  ?>  </td>
													<td><?php echo $date;  ?>  </td>
													<td><?php echo $details;  ?>  </td>
													<td><?php echo $ev_added_at;  ?>  </td>
													<td><?php echo $added_by;  ?>  </td>
													
													<td> 
													
															
													
  <a href="add_approx_event.php?action=edit&id=<?php echo $idn;  ?>"> <button class="btn btn-success btn-md" type="submit"><i class="ti-pencil-alt"></i></button> </a>
                                                  <form action='add_approx_event.php' method='post'>
												
													<input type='hidden' name='sub' value='3'>
													<input type='hidden' name='del_id' value='<?php echo $idn;  ?>'>
													<button class="btn remove btn-danger btn-md" onclick="return confirm('Are you sure you want to Cancel?');" type="submit" name='submit_del' ><i class="ti-close"></i></button> 
												

												


												</form>
													</td>
                                                </tr>
                                                
<?php } ?>	
                                            </tbody>
                                        </table>
                                    </div>
                                </div>
                            </div>
                            <!-- /# card -->
                        </div>
                        <!-- /# column -->
                    </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>
	
	
    <script type="text/javascript">
        function addEvent() {
            var number_of_events = parseInt($("#numberOfEvents").val()) + 1;
            $("#numberOfEvents").val(number_of_events);
            $("#eventTable").append("<tr id=\"event"+number_of_events.toString()+"_row\">\n" +
                "                                        <td><input name=\"event"+number_of_events.toString()+"_date\" type=\"date\"></td>\n" +
                "                                        <td><input name=\"event"+number_of_events.toString()+"_event\" type=\"text\"></td>\n" +
                "                                        <td><input name=\"event"+number_of_events.toString()+"_time\" type=\"time\"></td>\n" +
                "                                        <td><input name=\"event"+number_of_events.toString()+"_venue\" type=\"text\"></td>\n" +
                "                                        <td><input name=\"event"+number_of_events.toString()+"_parlar\" type=\"text\"></td>\n" +
                "                                        <td><input name=\"event"+number_of_events.toString()+"_decor\" type=\"text\"></td>\n" +				
                "                                        <td><input name=\"event"+number_of_events.toString()+"_guest\" type=\"text\"></td>\n" +
				"                                        <td><input name=\"event"+number_of_events.toString()+"_value\" type=\"text\"></td>\n" +
                "                                    </tr>");
        };

        function removeEvent() {
            var number_of_events_prev = parseInt($("#numberOfEvents").val()) ;
            var number_of_events = number_of_events_prev - 1;
            if (number_of_events === 0) return;
            $("#numberOfEvents").val(number_of_events);
            $("#event"+number_of_events_prev.toString()+"_row").remove();
        }
    </script>
	
	
	
	
	<script>
        $(document).ready(function() {
            $('.select2').select2();
        });
    </script>

		 <script src="assets/js/lib/select2/select2.full.min.js"></script>
		 
		 
</body>

</html>