<?php
	session_start(); 
	include("../include/config.php");
	include("../include/simpleimage.php");
	include("../include/functions.php"); 
	//$BASE_URL = 'https://www.dev.goquicklly.com';
	$BASE_URL ='https://www.quicklly.com';
	validate_admin();
	if($_REQUEST['submitForm']=='yes'){
	    $parentID=$_POST['parentID'];
	    $sub_id=$_POST['sub_id'];
	    $secID=$_POST['secID'];
	    $name=mysqli_real_escape_string($GLOBALS['conn'],$_POST['name']);
	    $display_order=$_POST['display_order'];
	    $status=$_POST['status'];
	   
	   
            if($sub_id=='')
            {
	    $obj->query("insert into home_page_sub_data set parentID='".$parentID."',secID='".$secID."',name='".$name."',display_order='".$display_order."',status='".$status."'");
            $_SESSION['sess_msg']='Data added sucessfully';
            }
            else
            {
$obj->query("update home_page_sub_data set parentID='".$parentID."',secID='".$secID."',name='".$name."',display_order='".$display_order."',status='".$status."' where subID='".$sub_id."'");
            $_SESSION['sess_msg']='Data updated sucessfully';
            }
	 
                      header("location:manage-home-app-page.php");
		              exit();	
  }  
?>
<!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=iso-8859-1" />
<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 = "home-page-del.php";
					frmobj.what.value="Delete";
					frmobj.submit();
					
				}
				else{ 
				return false;
				}
		}
		else if(comb=='Deactivate'){
			frmobj.action = "home-page-del.php";
			frmobj.what.value="Deactivate";
			frmobj.submit();
		}
		else if(comb=='Activate'){
			frmobj.action = "home-page-del.php";
			frmobj.what.value="Activate";
			frmobj.submit();
		}
		
		
	}

</script>

</head>
<body>
<table width="100%" border="0" cellpadding="0" cellspacing="0">
<?php include("header.php"); 
if(isset($_GET['sub_id']))
{
    	$cardsname = $obj->query("SELECT * FROM home_page_sub_data where subID='".$_GET['sub_id']."'");
                            $cardrow = $obj->fetchNextObject($cardsname);   
}
?>
<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 align="left" valign="middle" class="bodr" style="padding-bottom:20px;">
									<table width="100%" border="0" cellspacing="0" cellpadding="3">
  
  <tr><td height="10"></td></tr>
  <tr>
    <td>
    <td height="100" align="left" valign="top" bgcolor="#f3f4f6" class="bodr">
                            <form name="frm" method="POST" enctype="multipart/form-data" action="">
						<input type="hidden" name="submitForm" value="yes" />
						<input type="hidden" name="display_page" value="2">
						<input type="hidden" name="parentID" value="<?php echo $_REQUEST['id'];?>" />
						<input type="hidden" name="sub_id" value="<?php echo $_REQUEST['sub_id'];?>" />
						<input type="hidden" name="img_tmp" value="<?=@$cardrow->photo?>">
							<table width="100%" cellpadding="0" cellspacing="0">
									<tr>
										<td align="center" colspan="2" class="paddRt14 paddBot11">
										<font color="#FF0000"><strong><?php echo $_SESSION['sess_msg']; $_SESSION['sess_msg']='';?></strong></font></td>
									</tr>
									
										<tr >
										<td width="18%" align="right" class="paddBot11 paddRt14"> Section Type</td>
										<td width="82%" align="left" class="paddBot11">
									    <select class="form-control" name="secID" required>
									        <option value="">--Select--</option>
									       <?php
									       $sesction=$obj->query("select * from tbl_section where status=1 order by id");
									       while($line=$obj->fetchNextObject($sesction))
									       {
									       ?>
									       <option value="<?=$line->id?>" <?php if($cardrow->secID==$line->id){ echo "selected"; } ?> ><?=$line->section_name?></option>
									       <?php
									       }
									       ?>
									    </select>
										</td> 
									</tr>
									
								
									
									
									
									
								
									
										<tr >
										<td width="18%" align="right" class="paddBot11 paddRt14"> Title</td>
										<td width="82%" align="left" class="paddBot11">
									<input type="text" name="name" value="<?=@$cardrow->name?>" required>
										</td> 
									</tr>
									
									<!--	<tr >
										<td width="18%" align="right" class="paddBot11 paddRt14"> Photo</td>
										<td width="82%" align="left" class="paddBot11">
									<input type="file" name="fileImg" accept="image/png" >
									
								
										</td> 
									</tr>-->
									<?php
									if(@$cardrow->photo!='')
									{
									?>
									<tr>
									    <td></td>
									    <td>	<img src="<?=$BASE_URL."/".@$cardrow->photo?>" style="width:100px; height:100px;float:left"></td>
									</tr>
									<?php
									}
									?>
									<tr >
										<td width="18%" align="right" class="paddBot11 paddRt14"> Display Order</td>
										<td width="82%" align="left" class="paddBot11">
									<input type="number" name="display_order" value="<?=@$cardrow->display_order?>" required>
										</td> 
									</tr>
								<tr >
										<td width="18%" align="right" class="paddBot11 paddRt14"> Status</td>
										<td width="82%" align="left" class="paddBot11">
										<select name="status" required>
                                      <option value="">Select Status</option>
                                      <option value="1" <?php if(@$cardrow->status=="1"){ echo "selected"; } ?>>Active</option>
                                      <option value="0" <?php if(@$cardrow->status=="0"){ echo "selected"; } ?>>Deactive</option>
                                      </select>
										</td> 
									</tr>
									
							  
								
									
									
						
									<tr>
										<td width="18%" align="right" class="paddRt14 paddBot11">&nbsp;</td>
										<td width="82%" align="left" class="paddBot11">
											<input type="submit" name="submit" value="Submit"  class="submit" border="0"/> 	                  		 &nbsp;&nbsp;
											<input name="Reset" type="reset" id="Reset" value="Reset" class="submit" border="0" /></td>
									</tr>
								</table></form>
							</td>
</td>
  </tr>
</table>

									</td>
								</tr>
                                <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>
									<span  style="float:right; padding-right:10px;">
					                </span>
									</td>
								</tr>
								<form name="frm" method="post" action="#" 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 

$sql2=$obj->query("select * from home_page_sub_data where parentID='".$_GET['id']."' order by display_order");
$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 align="center" colspan="15"><strong><?php echo $reccnt; ?> Record Found.</strong></td></tr>
																<tr>
																	<td width="2%" align="left" class="padd5" bgcolor="#f3f4f6"><strong>S No.</strong></td>
																	<td width="2%" align="left" class="padd5" bgcolor="#f3f4f6"><strong>Display Order</strong></td>
																		<td width="2%" align="left" class="padd5" bgcolor="#f3f4f6"><strong>Section ID</strong></td>
																
                                               <td width="5%" align="center" bgcolor="#f3f4f6" class="padd5"><strong>Title</strong></td>
                                               
                                               					<td width="9%" align="center" bgcolor="#f3f4f6" class="padd5"><strong>Manage Product</strong></td>
																	<td width="9%" align="center" bgcolor="#f3f4f6" class="padd5"><strong>Status</strong></td>
															
																	
																  <td width="14%" align="center" bgcolor="#f3f4f6" class="padd5" >  <input name="check_all" type="checkbox"   id="check_all" onclick="checkall(this.form)" value="check_all" /></td>
																</tr><form method="post">
																<?php
																$i=0;
																while($line=$obj->fetchNextObject($sql2))
																{
																$i++;
															
																
																if($i%2==0)
																{
																$bgcolor = "#f3f4f6";
																}
																else
																{
																$bgcolor = "";
																}
																?>
																	<tr bgcolor="<?php echo $bgcolor;?>">
																		<td class="padd5"><strong><?php echo $i+$start; ?>.</strong></td>
																		
																		<td class="padd5"><?php echo $line->display_order; ?>																
																		<input type="hidden" value="<?=$line->id?>" name="id[<?php echo $i; ?>]">																		</td>                                                                       
																		<td class="padd5"><?php echo $line->secID; ?></td>
																		
									
                                        <td class="padd5"><?php echo $line->name; ?></td>
                                         
                                          
                                         
                                                                        <td align="center" valign="middle" class="padd5"><a href='manage-home-sub-app.php?sub_id=<?php echo $line->subID;?>&id=<?=@$_GET['id']?>'>Manage Product</a></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">
																	<input type="checkbox" name="ids[]" value="<?php echo $line->id;?>" />																		</td>
																	</tr>
																<?php
																
																}
																
																?>																<tr></tr>																<tr>															
																<!--<td colspan="5"><button class="button" type="submit">Change Display Order</button></td>-->																</tr></form>
													<tr>
                          <td valign="top" colspan="15"  align="right">&nbsp;</td>   </tr>    			
	<tr>
                          <td valign="top" colspan="15"  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="15">&nbsp;</td>
	  </tr>
	<tr>
	  <td align="right"  style="padding-right:80px;" colspan="15">&nbsp;</td>
	  </tr>
<!--	<tr><td align="right"  style="padding-right:80px;" colspan="15"> <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'); ?>
<script src="https://code.jquery.com/ui/1.10.3/jquery-ui.js"></script>
<script>
    function get_type(a)
    {
       
        if(a=='predefined'){
            $("#type").show();
            $("#sections").prop('required',true);
            $("#section_id").hide();
            $("#store_id").hide();
        }else
        {
            $("#sections").prop('required',false);
            $("#type").hide();
            $("#section_id").show();
            $("#store_id").show();
            
        }
        
    }
     function getStores(section_id)
     {
       
      $.ajax({
        url: 'ajax-get-store.php',
        type: 'post',
        data: { "sectionid": section_id},
        success: function(response) { 
            
            $("#stores_id").html(response);
        }
    });
     }
</script>

</table>
</body>
</html>