<?php
require_once("../includes/dbsmain.inc.php");
$pdf_id=$_REQUEST['pdf_id'];
$DelImageId=$_REQUEST['DelID'];
 if(!empty($DelImageId)){ 
   $imageToDel=db_scalar("select pdf_name from tbl_pdf where 1 and pdf_id='$DelImageId'"); 
   @unlink('../pdf_files/'.$imageToDel);
   $sqldel="delete from tbl_pdf where 1 and pdf_id='$DelImageId'";
   db_query($sqldel);
   set_session_msg("Catalog Updated Successfully !");
   header("Location: upload-catalog.php");
   exit;
 }

if(is_post_back()) {
if (isset($_POST['submit'])) {
    for ($i = 0; $i < count($_FILES['file']['name']); $i++) {
	     $imgName=$_FILES['file']['name'][$i];
		 $gTitle=$_POST['title'][$i];
		 
		   //**** Change Duplicate Image name Start Here****//
		 $ext = substr($imgName, strrpos($imgName, "."));		 
		 $imageDupli = db_scalar("select count(*) from tbl_pdf where 1 and pdf_name='$imgName'"); 
		 if($imageDupli > 0){
		  $imgName = basename($imgName, $ext);
		  $imgName = basename($imgName, $ext) . rand(1,1000) . $ext;
		 }else{
		  $imgName = $imgName;
		 }
		 //**** Change Duplicate Image name End Here****//
		 
         if (move_uploaded_file($_FILES['file']['tmp_name'][$i],"../pdf_files/$imgName")) {
			
			    $sql = "insert into tbl_pdf set 
		                   pdf_status='Active',
						   pdf_title='$gTitle',
						   pdf_name='$imgName',
						   pdf_add_date=now()";
						   db_query($sql);				
            } 
			       
        }
		set_session_msg("Catalog uploaded successfully !");
		header("Location: upload-catalog.php");
		exit;
    }
 }
?>
<link href="styles.css" rel="stylesheet" type="text/css">
<link href="imgstyle.css" rel="stylesheet" type="text/css">
<script src="jquery.min.js"></script>
<script src="scriptami.js"></script>
<?php include("top.inc.php");?>
            <table width="100%" border="0" cellspacing="0" cellpadding="0">
              <tr>
                <td id="pageHead"><div id="txtPageHead"> Add/Edit Catalog PDF</div></td>
              </tr>
            </table>
            <div><strong class="msg" style="margin-left:500px; margin-bottom:5px;">
              <?=display_sess_msg()?>
              </strong></div>
            <div style="width:100%;">
              <?php			
			    $sql_fetch = db_query("select * from tbl_pdf where 1");
			  $cntDATA=mysqli_num_rows($sql_fetch);
			   if($cntDATA > 0){
			  while($DATA = mysqli_fetch_array($sql_fetch)) {
		          @extract($DATA);
             ?>
              <div style="width:200px; height:130px; margin-top:10px;border:1px outset #fff; float:left; margin-left:8px;">
                <p align="center" style="font-size:13px; font-weight:bold;"><?=$DATA['pdf_name']?></p>
                <p align="center"><a href="upload-catalog.php?DelID=<?=$DATA['pdf_id']?>"><img src="images/no.gif"></a></p>
				<p align="center"><?=$DATA['pdf_title']?></p>
              </div>
              <? }} ?>
              <div class="cb"></div>
            </div>
            <table width="55%"  border="0" align="center" cellpadding="0" cellspacing="0" class="tableForm" style="border:1px outset #fff; margin-top:5px; margin-bottom:10px;">
              <tr>
                <td class="tdLabel" style="padding:8px;"><div id="maindiv">
                    <div id="formdiv">
                      <form enctype="multipart/form-data" action="" method="post">
                        <div id="filediv">
                          <input name="file[]" type="file" id="file" multiple /><br><br>
						  <input name="title[]" type="text" id="title" style="width:230px; height:26px;" placeholder="Enter Title"/>
                          </div>
                        <br/>
                        <input type="button" id="add_more" class="upload" value="Add More Files"/>
                        <input type="submit" value="Upload File" name="submit" id="upload" class="upload"/>
                      </form>
                      <br/>
                    </div>
                  </div></td>
              </tr>
            </table>
            <?php include("bottom.inc.php");?>