<?php 
include('header.php');
include('left_sidebar.php');

$button=@$_GET["mode"]=="edit"? "Update": "Submit";
if(@$_GET["objID"]!="")
{
      $CatRs=mysqli_query($con,"select * from tp_blog where id='".$_GET["objID"]."'") ;
      $CatRow=mysqli_fetch_assoc($CatRs) ;  
  
}

if($_POST["Submit"]=="Update")
{
extract($_POST);
$cQuery="update tp_blog set category='".mysqli_real_escape_string($con,$_REQUEST["category"])."',
page='".mysqli_real_escape_string($con,$_REQUEST["category_id"])."',
category_id='".mysqli_real_escape_string($con,$_REQUEST["category_id"])."',
sort='".mysqli_real_escape_string($con,"1")."',
added_date='".strftime('%Y-%m-%d %H:%M:%S', time())."',
modified_date='".strftime('%Y-%m-%d %H:%M:%S', time())."'";
				
				if($_FILES['image1']['name']!=""){                           
          $image=time()."-".md5(rand())."-".$_FILES['image1']['name'];              
             if($image!=""){
                $cQuery.=",filename ='".$image."'"    ;              
                $target="../file_upload/blogs/";
                $source=$_FILES["image1"]["tmp_name"];
                $target=$target.$image;
                move_uploaded_file($source,$target) ; 
              }               
              } 	
			 $cQuery.="  where id='".$_GET["objID"]."'" ;
		
		$RowCons=mysqli_query($con,$cQuery) or die(mysql_error());
		  if($RowCons)
		   {
				 $_SESSION["msg"]="record is updated successfully ";
				 header("location:view_reports.php");
				 exit() ;
		   }

}else if(isset($_POST["Submit"])=="Submit")
{
		extract($_POST);

		$cQuery="insert into tp_blog set category='".mysqli_real_escape_string($con,$_REQUEST["category"])."',
page='".mysqli_real_escape_string($con,$_REQUEST["category_id"])."',
category_id='".mysqli_real_escape_string($con,$_REQUEST["category_id"])."',
sort='".mysqli_real_escape_string($con,"1")."',
added_date='".strftime('%Y-%m-%d %H:%M:%S', time())."',
modified_date='".strftime('%Y-%m-%d %H:%M:%S', time())."'";
				
				if($_FILES['image1']['name']!="")
                        {                            
          $image=time()."-".md5(rand())."-".$_FILES['image1']['name'];
                
             if($image!="")
             {
                $cQuery.=",filename ='".$image."'"    ;              
                $target="../file_upload/blogs/";
                $source=$_FILES["image1"]["tmp_name"];
                $target=$target.$image;
                move_uploaded_file($source,$target) ; 
              }     
                } 
		$RowCons=mysqli_query($con,$cQuery) or die(mysql_error());
		if($RowCons)
		   {
				 $_SESSION["msg"]="One Record Is Inserted ";
				 header("location:add_report.php");
				 exit() ;
		   
		   }

}

?>
       
        <!-- ============================================================== -->
        <!-- Page wrapper  -->
        <!-- ============================================================== -->
        <div class="page-wrapper">
            <!-- ============================================================== -->
            <!-- Container fluid  -->
            <!-- ============================================================== -->
            <div class="container-fluid">
                <!-- ============================================================== -->
                <!-- Bread crumb and right sidebar toggle -->
                <!-- ============================================================== -->
                <div class="row page-titles">
                    <div class="col-md-5 col-8 align-self-center">
                        <h3 class="text-themecolor">New report</h3>
                        <ol class="breadcrumb">
                            <li class="breadcrumb-item"><a href="javascript:void(0)">Home</a></li>
                            <li class="breadcrumb-item active">New report</li>
                        </ol>
                    </div>
                   
                </div>
                <!-- ============================================================== -->
                <!-- End Bread crumb and right sidebar toggle -->
                <!-- ============================================================== -->
                <!-- ============================================================== -->
                <!-- Start Page Content -->
                <!-- ============================================================== -->
                
                 <!-- Row -->
                   <div class="row">
                    <div class="col-sm-12">
                        <div class="card">
                            <div class="card-body">
                                <h4 class="card-title">New report</h4>
                              
                               
                                <form class="form" method="post" action="" enctype="multipart/form-data">
                                 <?php if(isset($_SESSION["msg"]))
					{ ?>										
										<div class="alert alert-success"> <?php echo $_SESSION["msg"]; ?>
                                            <button type="button" class="close" data-dismiss="alert" aria-label="Close"> <span class="mdi mdi-check-circle-outline"aria-hidden="true"></span> </button>
                                        </div>
									<?php unset($_SESSION["msg"]);	}
										?>

                                    <div class="form-group row">
                                        <label for="example-search-input" class="col-2 col-form-label">Select Page</label>
                                        <div class="col-10">
                                        <select class="custom-select col-12" id="inlineFormCustomSelect" name="category_id" required>

<option value=""> --Select-- </option>

<?php $CatRs2=mysqli_query($con,"select * from tp_category where status='1' order by category_id desc") ;

while($categories=mysqli_fetch_assoc($CatRs2)){?>



<!--<option value='<?php echo $categories['id'];?>' <?php if($CatRow['subcategory']==$categories['page']){ echo "Selected";}?>> <?php echo $categories['subcategory'];?></option>";-->

<option value='<?php echo $categories['subcategory'];?>' <?php if($CatRow['page']==$categories['subcategory']){ echo "Selected";}?>> <?php echo $categories['subcategory'];?></option>
<?php  }

?>

 </select>

                                        
                                            
                                        </div>
                                    </div>
                                     
                                     <div class="form-group row">
                                        <label for="example-tel-input" class="col-2 col-form-label">Title:</label>
                                        <div class="col-10">
                                            <input class="form-control" type="text" name="category" value="<?php echo htmlspecialchars($CatRow["category"]);?>" id="example-tel-input" placeholder="title" required>
                                        </div>
                                    </div>
                                     <div class="form-group row">
                                        <label for="example-text-input" class="col-2 col-form-label">PDF Report</label>
                                        <div class="col-7">
                                            <input class="form-control" type="file" accept="application/pdf" id="example-file-input" name="image1">
                                        </div>
										<div class="col-3">
										<?php if(isset($CatRow["filename"])){?>
                                           <img src="../file_upload/blogs/PDF.png" height="50">
										<?php } ?>
                                        </div>
                                    </div>
                                    
									                                   
                                    <input name="Submit" type="hidden"  value="<?=$button;?>"/> 
                                   <button type="submit" name="submit" class="btn btn-info waves-effect waves-light ">Submit</button> 
                                </form>
                            </div>
                        </div>
                    </div>
                </div>  
               
                
                     
                <!-- ============================================================== -->
                <!-- End PAge Content -->
                <!-- ============================================================== -->
               <?php include('footer.php');?>