<?php
   session_start(); 
   include("../include/config.php");
   include("../include/functions.php"); 
   validate_admin();
   ?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
   <head>
      <title><?php echo SITE_TITLE; ?></title>
      <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
      <link href="css/admin.css" rel="stylesheet" type="text/css" />
      <script>
         function checkall(objForm)
         {
         len = objForm.elements.length;
         var i=0;
         for( i=0 ; i<len ; i++){
         if (objForm.elements[i].type=='checkbox') 
         objForm.elements[i].checked=objForm.check_all.checked;
         }
         }
         function del_prompt(frmobj,comb)
         {
         //alert(comb);
         if(comb=='Delete'){
         if(confirm ("Are you sure you want to delete record(s)"))
         {
         frmobj.action = "reels-del.php";
         frmobj.what.value="Delete";
         frmobj.submit();
         
         }
         else{ 
         return false;
         }
         }
         else if(comb=='Deactivate'){
         frmobj.action = "reels-del.php";
         frmobj.what.value="Deactivate";
         frmobj.submit();
         }
         else if(comb=='Activate'){
         frmobj.action = "reels-del.php";
         frmobj.what.value="Activate";
         frmobj.submit();
         }
         
         
         }
         
      </script>
   </head>
   <body>
      <table width="100%" border="0" cellpadding="0" cellspacing="0">
         <?php include("header.php") ?>
         <tr>
            <td align="right" class="paddRtLt70" valign="top">
               <table width="99%" border="0" cellspacing="0" cellpadding="0">
                  <tr>
                     <td align="right" valign="top">
                        <table width="100%" border="0" cellspacing="0" cellpadding="0">
                           <!------------ Search Section ----------------->
                           <tr>
                              <td height="10"></td>
                           </tr>
                           <!----- Search End --------->
                           <tr>
                              <td align="left" valign="middle" class="headingbg bodr text14">
                                 <em><img src="images/arrow2.gif" width="21" height="21" hspace="10" align="absmiddle" /></em>Admin: View   Reels
                                 <span  style="float:right; padding-right:10px;">
                                 <input type="button" name="add" value="Add reel"  class="button" onclick="location.href='reels-addf.php'" /></span> 
                              </td>
                           </tr>
                           <form name="frm" method="post" action="reels-del.php" enctype="multipart/form-data">
                              <tr>
                                 <td height="100" align="left" valign="top" bgcolor="#FFFFFF" class="bodr">
                                    <table width="100%" cellpadding="0" cellspacing="0">
                                       <?php if($_SESSION['sess_msg']){ ?>
                                       <tr>
                                          <td  align="center"><font color="#FF0000"><strong><?php echo $_SESSION['sess_msg'];$_SESSION['sess_msg']='';?></strong></font></td>
                                       </tr>
                                       <?php }?>
                                       <tr>
                                          <td align="left">
                                             <?php 
                                                $where='';
                                                $start=0;
                                                if(isset($_GET['start'])) $start=$_GET['start'];
                                                $pagesize=15;
                                                
                                                $order_by='order_no';
                                       
                                                $order_by2='asc';
                                          
                                                $sql=$obj->Query("select * from tbl_store_reels where 1=1 $where order by $order_by $order_by2 limit $start, $pagesize");
                                                $sql2=$obj->query("select * from tbl_store_reels where 1=1 $where order by $order_by $order_by2",$debug=-1);
                                                $reccnt=$obj->numRows($sql2);
                                                
                                                if($reccnt==0)
                                                {
                                                ?>
                                             <table width="100%" border="0" cellspacing="0" cellpadding="0">
                                                <tr>
                                                   <td align="center" valign="middle"><font face="Arial, Helvetica, sans-serif"   color="#FF0000" size="+1">No Record</font></td>
                                                </tr>
                                             </table>
                                             <?php 
                                                }
                                                else
                                                {
                                                ?>
                                             <table width="100%" border="0" cellspacing="0" cellpadding="0">
                                                <tr>
                                                   <td width="11%" align="left" class="padd5" bgcolor="#e7efef"><strong>S No.</strong></td>
                                                   <td width="15%" align="left" bgcolor="#e7efef" class="padd5"><strong>Title</strong> <?php echo sort_arrows('id') ?></td>
                                                   <td width="15%" align="left" bgcolor="#e7efef" class="padd5"><strong>Store name</strong> </td>

                                                   <td width="33%" align="left" bgcolor="#e7efef" class="padd5"><strong> Poster Image</strong> </td>
                                                   <td width="33%" align="left" bgcolor="#e7efef" class="padd5"><strong>Video Url</strong> </td>
												    <td width="9%" align="center" bgcolor="#e7efef" class="padd5"><strong>Display Order</strong></td>
                                                   <td width="9%" align="center" bgcolor="#e7efef" class="padd5"><strong>Status</strong></td>
                                                   <td width="6%" align="center" class="padd5" bgcolor="#e7efef"><strong>Action</strong></td>
                                                   <td width="11%" align="center" bgcolor="#e7efef" class="padd5" >  <input name="check_all" type="checkbox"   id="check_all" onclick="checkall(this.form)" value="check_all" /></td>
                                                </tr>
                                                <?php
                                                   $i=0;
                                                   while($line=$obj->fetchNextObject($sql))
                                                   {
                                                   $i++;
                                                   
                                                   
                                                   if($i%2==0)
                                                   {
                                                   $bgcolor = "#f6f6f6";
                                                   }
                                                   else
                                                   {
                                                   $bgcolor = "";	
                                                   }
                                                   ?>
                                                <tr bgcolor="<?php echo $bgcolor;?>">
                                                   <td class="padd5"><strong><?php echo $i+$start; ?>.</strong></td>
                                                   <td class="padd5"><?php echo stripslashes($line->title);?></td>
                                                   <td class="padd5"><?php echo getField('storename','tbl_order_status',$line->storeid);?></td>
               							               <td class="padd5"><?php if($line->poster_img) {?>
                                      <img src="<?php echo SITE_URL_CDN; ?>/upload_images/reels/<?php echo $line->poster_img; ?>" width="50" height="50" />
                                      <?php } ?></td>
													   <td class="padd5"><?php echo $line->video_url;?></td>
													   <td class="padd5"><?php echo $line->order_no;?></td>
               												  
                                                   <td align="center" valign="middle" class="padd5">
                                                      <?php if($line->status==1){?><img src="images/enable.gif" border="0" title="Activated" /> <?php } else{ ?><img src="images/disable.gif" border="0" title="Deactivated" /><?php }?>																		
                                                   </td>
                                                   <td align="center" valign="middle" class="padd5">
                                                      <a href="reels-addf.php?id=<?php echo $line->id;?>" ><img src="images/edit3.gif" border="0" title="Edit" /></a>
                                                   </td>
                                                   <td align="center" valign="middle" class="padd5">
                                                      <input type="checkbox" name="ids[]" value="<?php echo $line->id;?>" />																		
                                                   </td>
                                                </tr>
                                                <?php
                                                   }
                                                   
                                                   ?>
                                                <tr>
                                                   <td valign="top" colspan="11"  align="right">&nbsp;</td>
                                                </tr>
                                                <tr>
                                                   <td valign="top" colspan="11"  align="right" class="dark_red" style="padding-right:150px;"><?php include("../include/paging.inc.php"); ?></td>
                                                </tr>
                                                <tr>
                                                   <td align="right"  style="padding-right:80px;" colspan="11">&nbsp;</td>
                                                </tr>
                                                <tr>
                                                   <td align="right"  style="padding-right:80px;" colspan="11">&nbsp;</td>
                                                </tr>
                                                <tr>
                                                   <td align="right"  style="padding-right:80px;" colspan="11"> <input type="hidden" name="what" value="what" />
                                                      <input type="submit" name="Submit" value="Activate" class="button" onclick="return del_prompt(this.form,this.value)" />
                                                      <input type="submit" name="Submit" value="Deactivate" class="button" onclick="return del_prompt(this.form,this.value)" />
                                                      <input type="submit" name="Submit" value="Delete" class="button" onclick="return del_prompt(this.form,this.value)" />
                                                   </td>
                                                </tr>
                                             </table>
                                             <?php }?>
                                          </td>
                                       </tr>
                                    </table>
                                 </td>
                              </tr>
                           </form>
                        </table>
                     </td>
                  </tr>
               </table>
            </td>
         </tr>
         <tr>
            <td height="100"></td>
         </tr>
         <?php include('footer.php'); ?>
      </table>
   </body>
</html>