<?php require_once("header.php");?>
<?php require_once("left-nav.php");?>
<style>
.v-middle {
vertical-align:middle !important;
}

span.home-lbl {
    background: #FFEB3B;
    padding: 1px 15px 1px 15px;
    font-size: 11px;
    font-weight: 600;
    color: red;
    border: solid thin #f0df4d;
    position: relative;
    top: 5px;
}</style>
<?php
/*$DelID=$_GET["DelID"];
if($DelID!=""){
$imgDel=db_scalar("SELECT header_logo FROM  tbl_header WHERE header_id='$DelID'");	
$sql="delete from tbl_header where header_id='$DelID'";
db_query($sql);
@unlink("../flash_images/$imgDel");
header("location:manage-gallery.php");
exit;
}*/

if($st!=""){
$st=$_REQUEST['st'];
$pageID=$_REQUEST['pid'];

if($st==1){
$sql="UPDATE tbl_image_gallery SET image_status='Inactive' WHERE image_id='$pageID' ";	
$res=db_query($sql);	
if($res>0){
$_SESSION["msg"]="Selected image is deactivated successfully.";	
}	
}else{
$sql="UPDATE tbl_image_gallery SET image_status='Active' WHERE image_id='$pageID' ";	
$res=db_query($sql);	
if($res>0){
$_SESSION["msg"]="Selected image is activated successfully.";	
}	
	
}

header("location:manage-gallery.php");
exit;
}


if(is_post_back()) {
	$arr_ids = $_REQUEST['arr_ids'];
  $Arr_size=sizeof($arr_ids);
	if(is_array($arr_ids)) {
		$str_ids = implode(',', $arr_ids); 

		if(isset($_REQUEST['Delete']) || isset($_REQUEST['Delete_x']) ) {
   for($i=0; $i<$Arr_size; $i++)
    {
        $qc_del = db_scalar("select image_name from tbl_image_gallery where image_id='$arr_ids[$i]'");
     @unlink("../gallery_images/$qc_del");
      db_query("delete from tbl_image_gallery where image_id='$arr_ids[$i]' ");
    }
$_SESSION["msg"]="Selected image is deleted successfully."; 

			//db_query("delete from  tbl_header where header_id in ($str_ids)");
		} else if(isset($_REQUEST['Activate']) || isset($_REQUEST['Activate_x']) ) {
			$res=db_query("update  tbl_image_gallery set image_status = 'Active' where image_id in ($str_ids)");
			  
			  if($res>0){
			  $_SESSION["msg"]="Selected image is actived successfully.";	
			  }
			  
		} else if(isset($_REQUEST['Deactivate']) || isset($_REQUEST['Deactivate_x']) ) {
      $res=db_query("update  tbl_image_gallery set image_status = 'Inactive' where image_id in ($str_ids)");
      
       if($res>0){
        $_SESSION["msg"]="Selected image is deactivated successfully."; 
        }
        
    }else if(isset($_REQUEST['remove_for_home']) || isset($_REQUEST['remove_for_home_x']) ) {
      $res=db_query("update  tbl_image_gallery set image_for_home = 'No' where image_id in ($str_ids)");
      
       if($res>0){
        $_SESSION["msg"]="Selected image removed from our gallery of home page."; 
        }
        
    }else if(isset($_REQUEST['set_for_home']) || isset($_REQUEST['set_for_home_x']) ) {
      $res=db_query("update  tbl_image_gallery set image_for_home = 'Yes' where image_id in ($str_ids)");
      
       if($res>0){
        $_SESSION["msg"]="Selected image set for our gallery at home page."; 
        }
        
    }

    /*else if(isset($_REQUEST['show_in_header']) || isset($_REQUEST['show_in_header_x']) ) {
			db_query("update  tbl_header set site_pages_show_in_header='Yes' where header_id in ($str_ids)");
		}else if(isset($_REQUEST['show_in_header_r']) || isset($_REQUEST['show_in_header_r_x']) ) {
			db_query("update  tbl_header set site_pages_show_in_header='No' where header_id in ($str_ids)");
		}else if(isset($_REQUEST['show_in_footer']) || isset($_REQUEST['show_in_footer_x']) ) {
			db_query("update  tbl_header set site_pages_show_in_footer='Yes' where header_id in ($str_ids)");
		}else if(isset($_REQUEST['show_in_footer_r']) || isset($_REQUEST['show_in_footer_r_x']) ) {
			db_query("update  tbl_header set site_pages_show_in_footer='No' where header_id in ($str_ids)");
		}*/
	}
/*	if(isset($_REQUEST['Update'])){
		foreach($site_pages_order_by as $key=>$value){
		db_query("update tbl_header set site_pages_order_by='$value' where header_flash_id='$key'");
		}
	}*/
	header("Location: ".$_SERVER['HTTP_REFERER']);
	exit;
}

$start = intval($start);
$pagesize = intval($pagesize)==0?$pagesize=DEF_PAGE_SIZE:$pagesize;

$order_by == '' ? $order_by = 'image_status' : true;
$order_by2 == '' ? $order_by2 = 'asc' : true;
 
/*$sql = "select * from  tbl_header  where 1 AND header_flash_type='Left'";
*/

$sql = "select * from  tbl_image_gallery  where 1 ";
$sql = apply_filter($sql, $header_flash_title, 'like','image_title');
$sql .= " order by $order_by $order_by2 ";
$sql .= " limit $start, $pagesize ";
//echo $sql;
$pager = new midas_pager_sql($sql, $pagesize, $start);
if($pager->total_records) {
	$result = db_query($sql);
}
?>

<script language="JavaScript" type="text/javascript" src="../includes/general.js"></script>

         <!-- =============================================== -->
         <!-- Content Wrapper. Contains page content -->
         <div class="content-wrapper">
            <!-- Content Header (Page header) -->
            <section class="content-header">
               <div class="header-icon">
                  <i class="fa fa-picture-o" aria-hidden="true"></i>

               </div>
               <div class="header-title">
                  <h1>Gallery</h1>
                  <small>Image List</small>
                  
                  
                  <a href="addedit-gallery.php"><button id="btn-go-back" type="button" class="btn btn-labeled btn-inverse m-b-5 pull-right">
<span class="btn-label" ><i class="fa fa-plus" aria-hidden="true"></i>
</span>Add New
</button></a>
                  
                  
               </div>


               
               
            </section>
            <!-- Main content -->
            <section class="content">
               <div class="row">

<?php if($_SESSION["msg"]!=""){?>               
<div class="alert alert-success alert-dismissable fade in text-center" style="background-color:#dff0d8;border:none; color:#000;margin:10px 0 0 0">
    <a href="#" class="close" data-dismiss="alert" aria-label="close">&times;</a>
    <strong>Success!&nbsp;&nbsp;&nbsp;</strong> <?=$_SESSION["msg"]?>.
  </div>
<?php 
unset($_SESSION["msg"]);
}?> 

<div class="col-lg-12">

<? if($pager->total_records>0) {?>
<div class="col-lg-6 text-left" >
<? $pager->show_displaying()?>
</div>
<div class="col-lg-6 text-right" >Records Per Page:
<?=pagesize_dropdown('pagesize', $pagesize);?>
</div>
<?php
}
?>

</div>


                  <div class="col-sm-12">
                     <div class="panel panel-bd lobidrag" data-edit-title='false' data-close='false' data-reload='false'>
                        
                        
                           
                        
                        
                        <div class="panel-heading">
                           <div class="btn-group" id="buttonexport">
                              <a href="#">
                                 <h4>Gallery Image List</h4>
                              </a>
                           </div>
                        </div>
                        
                        



                        
                        <div class="panel-body">
                        <!-- Plugin content:powerpoint,txt,pdf,png,word,xl -->
                           <!-- Plugin content:powerpoint,txt,pdf,png,word,xl -->
<? if($pager->total_records>0) {?>                           
                           <div class="table-responsive">
<form action="" method="post" enctype="multipart/form-data">                           
                              <table id="dataTableExample1" class="table table-bordered table-striped table-hover">
                                 <thead>
                                    <tr class="info">                                      
                                       <th class="text-center">S.No.</th>            
                                       <th class="text-center">Image</th>    
                                       <th class="text-center">Title</th>
                                      <!--  <th class="text-center">Category Name</th> -->

                                       <th class="text-center">Status</th>
                                       <th class="text-center">Action</th>
                                       <th class="text-center"><input name="check_all" type="checkbox" id="check_all" value="1" onclick="checkall(this.form)" /></th>
                                    </tr>
                                 </thead>
                                 
<tbody>
                                   
<?
$cnt=0;
while ($line_raw = mysqli_fetch_array($result)) {
	$line = ms_display_value($line_raw);
	@extract($line);
	$css = ($css=='trOdd')?'trEven':'trOdd';
?>                                   
                                    <tr>
                            
                            
                            <td class="text-center v-middle"><?=++$cnt?></td>
                            
<td class="text-center v-middle"><a href="<?=SITE_WS_PATH?>" target="_blank"><img src="../gallery_images/<?=$image_name?>" height="100" width="75"  style="border:solid thin #ccc;padding:5px;"></a></td>                            
                                     
<td class="text-center v-middle"><?=$line_raw["image_title"]?>
  <p>
<?php if($image_for_home=='Yes'){?>
<span class="home-lbl"><i class="fa fa-home font-black"></i> Home</span>                             
<?php }?>
</p>  

</td>
<!-- <td class="text-center v-middle"><?=db_scalar("select category_name from tbl_category where category_url='$line_raw[image_category_name]' ");?></td>
 -->
                                     

<td class="text-center v-middle">
<?php if($line_raw["image_status"]=="Active"){?>
<a href="manage-gallery.php?st=1&pid=<?=$line_raw["image_id"]?>"><span class="label-custom label label-default">Active</span></a>
<?php }else{?>
<a href="manage-gallery.php?st=0&pid=<?=$line_raw["image_id"]?>"><span class="label-danger label label-default">Inactive</span></a>
<?php }?>

</td>
                                       <td class="text-center v-middle">
<a href="addedit-gallery.php?edit_id=<?=$line_raw["image_id"]?>"><button type="button" class="btn btn-add btn-sm" ><i class="fa fa-pencil"></i></button>
</a>                                          


<!-- <a href="manage-slider.php?DelID=<?=$line_raw["header_flash_id"]?>"><button type="button" class="btn 
btn-danger btn-sm" ><i class="fa fa-trash"></i></button>
</a>   -->                                        


                                       </td>
<td class="text-center v-middle"><input name="arr_ids[]" type="checkbox" id="arr_ids[]" value="<?=$image_id?>" /></td>                                           
                                       
                                    </tr>
<?php
}
?>
                                    
<tr> <td colspan="7">


<!-- <button type="submit" name="remove_for_home"  class="btn btn-primary pull-right " onClick="return select_chk()">Remove Our Gallery</button>

<button type="submit" name="set_for_home" class="btn btn-default pull-right mr5" onClick="return select_chk()">Set Our Gallery</button>
 -->
<button type="submit" name="Deactivate"  class="btn btn-warning pull-right " onClick="return select_chk()">Make Inactive</button>

<button type="submit" name="Activate" class="btn btn-success pull-right mr5" onClick="return select_chk()">Make Active</button>
<button type="submit" name="Delete" class="btn btn-success pull-right mr5 label-danger" onClick="return select_chk()">Delete</button>

</td></tr>                                    
                                    
                                    
                                 </tbody>
</form>
                              </table>
                              
<? $pager->show_pager();?>
                                             
                              
                           </div>
<?php }else{?>
<div class="col-lg-12 msg text-center">Sorry, no records found.</div>
<?php }?>
                           
                        </div>
                     </div>
                  </div>
               </div>
               <!-- customer Modal1 -->
               
               <!-- /.modal -->
               <!-- Modal -->    
               <!-- Customer Modal2 -->
               
               <!-- /.modal -->
            </section>
            <!-- /.content -->
         </div>


   <script language="javascript">
function select_chk(){
var chks = document.getElementsByName('arr_ids[]');
var hasChecked = false;
for (var i = 0; i < chks.length; i++){
if (chks[i].checked){
  hasChecked = true;
  break;
  }
}
if (hasChecked == false){
alert("Please Select At Least One.");
return false;
}
}
</script> 


<?php require_once("footer.php"); ?>