<?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());



?>

<!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>Reports</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">Reports</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">Reports</div>
                                            <div class="panel-body">
											
											
                    <div class="row">
                        <div class="col-lg-12">
                            <div class="card alert">
                                <div class="card-body">
								
								 <div class="panel panel-warning m-t-15"> <div class="panel-body">
											
											
											
								 
								 <div class="form-group row">
                                                <label class="col-lg-2 col-form-label" > &nbsp; Summary Report </label>
												
                                                <div class="col-lg-2">
												     <form class="form-valide" action="report_total_print.php" target="_blank"method="get">
                                                     <select class="form-control bg-ash border-none select2" data-placeholder="Select existing Booking" style="width: 100%;" name="year">
													 
														
														<option value="2019"> 2019 </option>
														<option value="2020"> 2020 </option>
														<option value="2021"> 2021 </option>
														<option value="2022"> 2022 </option>
														<option value="2023"> 2023 </option>
														<option value="2024"> 2024 </option>
														<option value="2025"> 2025 </option>
							 
                                                    </select>
													<button type="submit"  class="btn btn-success">View & Print</button> 
													</form>
                                                </div>
												 
												  <div class="col-lg-2">
												     <form class="form-valide" action="report_total_exp.php" target="_blank" method="get">
                                                     <select class="form-control bg-ash border-none select2" data-placeholder="Select existing Booking" style="width: 100%;" name="year">
													 
														
														<option value="2019"> 2019 </option>
														<option value="2020"> 2020 </option>
														<option value="2021"> 2021 </option>
														<option value="2022"> 2022 </option>
														<option value="2023"> 2023 </option>
														<option value="2024"> 2024 </option>
														<option value="2025"> 2025 </option>
							 
                                                    </select>
													<button type="submit"  class="btn btn-primary">Exportable</button> 
													</form>
                                                </div>
												
												 
                                  </div>
											
								
								
								
								</div> </div>
								
								
								
								 
								
								
								<div class="panel panel-primary m-t-15"> <div class="panel-body">
								
								
								 
								 <div class="form-group row">
                                                <label class="col-lg-2 col-form-label" > &nbsp;  Monthly Due List   </label>
												
                                                <div class="col-lg-2">
												<form class="form-valide" action="report_due_months_list_print.php" target="_blank" method="get">
                                                     <select class="form-control bg-ash border-none select2" data-placeholder="Select existing Booking" style="width: 100%;" name="year">
													 
														
														<option value="2019"> 2019 </option>
														<option value="2020"> 2020 </option>
														<option value="2021"> 2021 </option>
														<option value="2022"> 2022 </option>
														<option value="2023"> 2023 </option>
														<option value="2024"> 2024 </option>
														<option value="2025"> 2025 </option>
							 
                                                    </select>
													<button type="submit"  class="btn btn-success">View</button> 
												</form>	
                                                </div>
												 
												 <div class="col-lg-2">
												<form class="form-valide" action="report_due_months_list_exp.php" target="_blank" method="get">
                                                     <select class="form-control bg-ash border-none select2" data-placeholder="Select existing Booking" style="width: 100%;" name="year">
													 
														
														<option value="2019"> 2019 </option>
														<option value="2020"> 2020 </option>
														<option value="2021"> 2021 </option>
														<option value="2022"> 2022 </option>
														<option value="2023"> 2023 </option>
														<option value="2024"> 2024 </option>
														<option value="2025"> 2025 </option>
							 
                                                    </select>
													<button type="submit"  class="btn btn-primary">Exportable</button> 
												</form>	
                                                </div>
												 
                                  </div>
											
								
								
								</div></div>
								
								
								<div class="panel panel-primary m-t-15"> <div class="panel-body">
								
								
								 
								 <div class="form-group row">
                                                <label class="col-lg-2 col-form-label" > &nbsp;  Monthly Delivery Report   </label>
												
                                                <div class="col-lg-2">
												<form class="form-valide" action="report_delivery_monthly_print.php" target="_blank" method="get">
                                                     <select class="form-control bg-ash border-none select2" data-placeholder="Select existing Booking" style="width: 100%;" name="year">
													 
														
														<option value="2019"> 2019 </option>
														<option value="2020"> 2020 </option>
														<option value="2021"> 2021 </option>
														<option value="2022"> 2022 </option>
														<option value="2023"> 2023 </option>
														<option value="2024"> 2024 </option>
														<option value="2025"> 2025 </option>
							 
                                                    </select>
													<button type="submit"  class="btn btn-success">View</button> 
												</form>	
                                                </div>
												 
												 
                                  </div>
											
								
								
								</div></div>
								
								
								
								<div class="panel panel-success m-t-15"> <div class="panel-body">
								
								
								   
                          
                                    <div class="col-sm-12"> 
						    <form class="form-valide" action="report_due_list_print.php" target="_blank" method="get">
							<table>
							<tr>
							<td>
							Due List From <input class="date" type="date" value="<?php echo $dayBookDate1; ?>" name="date1" id="datetimepicker2"/>
							</td>
							<td>
							To <input class="date" type="date"  value="<?php echo $dayBookDate2; ?>" name="date2" id="datetimepicker2"/>
							</td>
							<td>
							
							</td>
							
							<td> &nbsp;
							 <button type="submit"  class="btn btn-success">View</button> 
							</td>
							
							</tr>
							</table>
						    </form>
							
							<form class="form-valide" action="report_due_list_exp.php" target="_blank" method="get">
							<table>
							<tr>
							<td>
							Due List From <input class="date" type="date" value="<?php echo $dayBookDate1; ?>" name="date1" id="datetimepicker2"/>
							</td>
							<td>
							To <input class="date" type="date"  value="<?php echo $dayBookDate2; ?>" name="date2" id="datetimepicker2"/>
							</td>
							<td>
							
							</td>
							
							<td> &nbsp;
							 <button type="submit"  class="btn btn-primary">Exportable</button> 
							</td>
							
							</tr>
							</table>
						    </form>
							
							
							 <form class="form-valide" action="report_due_list_cur_month_print.php" target="_blank" method="get">
							<table>
							<tr>
							<td>
							Due List From Event Date <input class="date" type="date" value="<?php echo $dayBookDate1; ?>" name="date1" id="datetimepicker2"/>
							</td>
							<td>
							To <input class="date" type="date"  value="<?php echo $dayBookDate2; ?>" name="date2" id="datetimepicker2"/>
							</td>
							<td>
							
							</td>
							
							<td> &nbsp;
							 <button type="submit"  class="btn btn-success">View</button> 
							</td>
							
							</tr>
							</table>
						    </form>
							
						   </div>
						     


</div></div>


	<div class="panel panel-warning m-t-15"> <div class="panel-body">
<form class="form-valide" action="report_total_print_SP.php" target="_blank" method="post">
                          
                                    <div class="col-sm-12"> 
						   
							<table>
							<tr>
							<td>
							Reporting Years &nbsp;
							</td>
							<td> 
	 <input type="checkbox" name="check_list[]" value="2019"> 2019 &nbsp;
    <input type="checkbox" name="check_list[]" value="2020">  2020 &nbsp; 
    <input type="checkbox" name="check_list[]" value="2021">  2021 &nbsp;
	<input type="checkbox" name="check_list[]" value="2022">  2022 &nbsp;
	<input type="checkbox" name="check_list[]" value="2023">  2023 &nbsp;
	<input type="checkbox" name="check_list[]" value="2024">  2024 &nbsp;
	<input type="checkbox" name="check_list[]" value="2025">  2025 &nbsp;
	<input type="checkbox" name="check_list[]" value="2026">  2026 &nbsp;
	<input type="checkbox" name="check_list[]" value="2027">  2027 &nbsp;
	<input type="checkbox" name="check_list[]" value="2028">  2028 &nbsp;
	<input type="checkbox" name="check_list[]" value="2029">  2029 &nbsp;
	<input type="checkbox" name="check_list[]" value="2030">  2030 &nbsp;
							</td>
							
							
							</tr>
							
						
							</table>
							
							<table>
							<tr>
							
							<td> &nbsp;
							 <select class="form-control bg-ash border-none select2" " name="type">
													 
														<option value="booking_value"> Booking Value </option>
														<option value="event_value"> Event Value </option>
														<option value="booking_no"> Booking No </option>
							 
                                                    </select>
							</td>
							
							<td> 
							 <button type="submit"  class="btn btn-success">View</button> 
							</td>
							
							
							</tr>
							
						
							</table>
							
							
						    
						   </div>
						     
</form>

</div></div>

<div class="panel panel-success m-t-15"> <div class="panel-body">

<form class="form-valide" action="report_due_invoice_list_print.php" target="_blank" method="get">
                          
                                    <div class="col-sm-12"> 
						   
							<table>
							<tr>
							<td>
							Due Invoice List <input class="date" type="date" value="<?php echo $dayBookDate1; ?>" name="date1" id="datetimepicker2"/>
							</td>
							<td>
							To <input class="date" type="date"  value="<?php echo $dayBookDate2; ?>" name="date2" id="datetimepicker2"/>
							</td>
							<td>
							
							</td>
							
							<td> &nbsp;
							 <button type="submit"  class="btn btn-success">View</button> 
							</td>
							
							</tr>
							</table>
						    
						   </div>
						     
</form>


</div></div>




	<div class="panel panel-success m-t-15"> <div class="panel-body">
								
								
								   
                          
                                    <div class="col-sm-12"> 
						    <form class="form-valide" action="report_payment_list_print.php" target="_blank" method="get">
							<table>
							<tr>
							<td>
							Payment Received <input class="date" type="date" value="<?php echo $dayBookDate1; ?>" name="date1" id="datetimepicker2"/>
							</td>
							<td>
							To <input class="date" type="date"  value="<?php echo $dayBookDate2; ?>" name="date2" id="datetimepicker2"/>
							</td>
							<td>
							
							</td>
							
							<td> &nbsp;
							 <button type="submit"  class="btn btn-success">View</button> 
							</td>
							
							</tr>
							</table>
						    </form>
							
							<form class="form-valide" action="report_payment_list_exp.php" target="_blank" method="get">
							<table>
							<tr>
							<td>
							Payment Received <input class="date" type="date" value="<?php echo $dayBookDate1; ?>" name="date1" id="datetimepicker2"/>
							</td>
							<td>
							To <input class="date" type="date"  value="<?php echo $dayBookDate2; ?>" name="date2" id="datetimepicker2"/>
							</td>
							<td>
							
							</td>
							
							<td> &nbsp;
							 <button type="submit"  class="btn btn-primary">Exportable</button> 
							</td>
							
							</tr>
							</table>
						    </form>
							
						   </div>
						     


</div></div>











									
								<table height="500">
								<tr>
								<td> &nbsp;
								</td>
								</tr>
								</table>
								
								
								
								
								
								
								
								
								
								
								
								
								
                                </div>
                            </div>
                        </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>
	
	
    <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>