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

if (isset($_POST['day_submit'])) {
	
	$dayBookDate1=$_POST['date1'];
	$dayBookDate2=$_POST['date2'];
	$sub=2;
}





?>



<!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>Artist Event Count</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 -->
				
				
					<?php if ($user_type==1 OR $user_type==4){ ?>
                <section id="main-content">
				
				
			
				
				
				
				
				
				<div class="row">
				
				        <div class="col-lg-12">
						
						<div class="panel panel-info m-t-15">
                                            <div class="panel-heading">Artist Event Count</div>
                                            <div class="panel-body">
						
								

								  
								  
								  
								  
								 
								  
								  
								  
								  
								  
								  
								  
								  
								  
                                    <div class="row">
                        <div class="col-lg-12">
                            <div class="card alert">
							
							
							
							
							
							
							
							
							
							
							
                               
								
								
								
								
								
								
								
								
								
						
								
								
								
						
								
								
								
								
								
								
								
								
								
								
								
								
								
								
								 	<div class="row-form clearfix">
					       <form action='report_artist.php'  method='POST'> 
								
								
								  <div class="col-sm-2">  <div class="span3"> From <input class="date" type="date" value="<?php echo $dayBookDate1; ?>" name="date1" id="datetimepicker2"/></div>  </div>
						     
                           <div class="col-sm-2"> <div class="span3"> To <input class="date" type="date"  value="<?php echo $dayBookDate2; ?>" name="date2" id="datetimepicker2"/></div>  </div>						   
                            <div class="col-sm-6">  <div class="span3"> &nbsp; </div><input class="submit" type="submit"  name="day_submit"  value="Search" />  </div>
								
								
							</div>	
								
								
								</br>
								
								
								
								
								
								 <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>Name</th>
													<th>Username / Email</th>
														<th>Mobile</th>
													<th>Type</th>
                                                    
												
													  
													<th>Event</th>
                                                </tr>
                                            </thead>
                                            <tbody>
											
											
	<?php 
	



						$sqlSelectedLG = "SELECT *, (case when type='Photographer' then (SELECT count(id) FROM `events` WHERE FIND_IN_SET(artists.id, photographers)) when type='Videographer' then (SELECT count(id) FROM `events` WHERE FIND_IN_SET(artists.id, videographers)) end) as total FROM `artists` ";
				
			 if($sub=="2") {
				 
				       $sqlSelectedLG = "SELECT *, (case when type='Photographer' then (SELECT count(id) FROM `events` WHERE FIND_IN_SET(artists.id, photographers) AND (date BETWEEN '$dayBookDate1' AND '$dayBookDate2') ) when type='Videographer' then (SELECT count(id) FROM `events` WHERE FIND_IN_SET(artists.id, videographers) AND (date BETWEEN '$dayBookDate1' AND '$dayBookDate2') ) end) as total FROM `artists` ";
					   
					   
 } 
$sqlSelectedLG = mysqli_query($connection, $sqlSelectedLG);
while ($list = mysqli_fetch_object($sqlSelectedLG)) {

                                    
                                   
                                    $idn = $list->id;
								    
									
									
									
                                    $name = $list->name;
									   $email = $list->email;
									     $mobile = $list->mobile;
										 	
											    $type = $list->type;
												
									$total = $list->total;
												
                                  
								
                                    
                                   
                                ?>
											
											
											
											
                                                <tr>
                                                 
                                                    <td><?php echo $name;  ?></td>
                                                    <td><?php echo $email;  ?></td>
													  <td><?php echo $mobile;  ?></td>
                                                    <td><?php echo $type;  ?></td>
													
													<td> 
													<?php echo $total;  ?>
													</td>
													
													
                                                </tr>
                                                
												
<?php } ?>			
												
                                            </tbody>
                                        </table>
                                    </div>
                                </div>
								
								
								
								
								
								
								
                            </div>
                            <!-- /# card -->
                        </div>
                        <!-- /# column -->
                    </div>

                                   


							 </div> </div>
							
                        </div>
				
				
                        <!-- /# column -->
                        
                    </div>
				
				
				
				
				
                    <!-- /# row -->
                     <?php include("footer.php"); ?>
                </section>
				
				
				<?php } ?>
            </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>