<?php 
$page_name="addpost"; 
include ('../common/library.php');
include ('../common/helper.php');    
include ('../template/header.php'); 
include ('../template/sidebar.php');
 
if(isset($_POST['save'])){
  $blog_title     = $_POST['blog_title'];
  $blog_body  = $_POST['blog_body'];
  $keyword  = $_POST['keyword'];
  $cat_id  = $_POST['cat_id'];
  $date  	   = $_POST['date'];
  $entry_by    = $_SESSION['user_id'];
  $slug_url     = strtolower($blog_title);
  $slug_url     = str_replace(' ','-',$slug_url);


  $file = $_FILES['pic'];    //image upload
  $file_name = $file['name'];
  $file_path = $file['tmp_name'];  //image upload
  $location= '../files/blogs/'.$file_name;
  move_uploaded_file($file_path, $location);

  
 $insert =$conn->query("insert into tbl_post (`blog_title`,`blog_body`,`keyword`,`cat_id`,`date`,`pic`,`slug_url`,`entry_by`) values('".$blog_title."','".$blog_body."','".$keyword."','".$cat_id."','".$date."','".$file_name."','".$slug_url."','".$entry_by."')");
  if($insert==true)
  {
  $insert_id = mysqli_insert_id($conn);
  
  $msg =  '<span style="color:green; font-weight:bold; font-size:18px;">Successfully Inserted.</span>';
  
  }
  else
  {
  $msg =  '<span style="color:red; font-weight:bold; font-size:18px;">Plesae Try Again!</span>';
 }

}


if(isset($_POST['update'])){

  $update_id      = $_POST['update_id'];
  $blog_title    	  = $_POST['blog_title'];
  $blog_body     = $_POST['blog_body'];
  $keyword  		  = $_POST['keyword'];
  $cat_id  	  = $_POST['cat_id'];
  $date  		  = $_POST['date'];
  $timeNow        = date("Y-m-d H:i:s");
  $entry_by       = $_SESSION['user_id'];

  $file = $_FILES['pic'];    //image upload
  $file_name = $file['name'];
  $file_path = $file['tmp_name'];  //image upload
	 $location= '../files/blogs/'.$file_name;
	 move_uploaded_file($file_path, $location);


  
  if($file_name){
  $update = $conn->query("update tbl_post set blog_title='".$blog_title."',blog_body='".$blog_body."',keyword='".$keyword."',cat_id='".$cat_id."',date='".$date."',pic='".$file_name."',updated_by='".$entry_by."',updated_at='".$timeNow."' where id='".$update_id."'");
  }else{
	$update = $conn->query("update tbl_post set blog_title='".$blog_title."',blog_body='".$blog_body."',keyword='".$keyword."',cat_id='".$cat_id."',date='".$date."',updated_by='".$entry_by."',updated_at='".$timeNow."' where id='".$update_id."'");

  }
  
  if($update==true)
  {

  $msg =  '<span style="color:green; font-weight:bold; font-size:18px;"> Successfully Updated.</span>';
  
  }
  else
  {
  $msg =  '<span style="color:red; font-weight:bold; font-size:18px;">Plesae Try Again!</span>';
 }
}

if(isset($_POST['delete'])){

  $delete_id  = $_POST['delete_id'];

  
  if($delete_id>0){
  $update = $conn->query("update tbl_post set status='Inactive' where id='".$delete_id."'");
  }
  
  if($update==true)
  {

	$msg =  '<span style="color:green; font-weight:bold; font-size:18px;">About Successfully Deleted.</span>';
  
  }
  else
  {
  $msg =  '<span style="color:red; font-weight:bold; font-size:18px;">Plesae Try Again!</span>';
 }
}


?>

		
		<div class="main-panel">
			<div class="content">				
                     <div class="row">
						<div class="col-md-12">
							<div class="card">
								<div class="card-header">
									<div class="d-flex align-items-center">
										<h4 class="card-title"><?=$msg?></h4>
										<button class="btn btn-primary btn-round ml-auto" data-toggle="modal" data-target="#addRowModal">
											<i class="fa fa-plus"></i>											
											Add Post
										</button>
									</div>
								</div>
								<div class="card-body">
									<!-- Modal -->
									<form action="<?=$_POST['PHP_SELF']?>" method="post" enctype="multipart/form-data">
									<div class="modal fade" id="addRowModal" tabindex="-1" role="dialog" aria-hidden="true">
										<div class="modal-dialog" role="document">
											<div class="modal-content">
												<div class="modal-header no-bd">
													<h5 class="modal-title">
														<span class="fw-mediumbold">
														Add Post</span> 
														<span class="fw-light">
														
														</span>
													</h5>
													<button type="button" class="close" data-dismiss="modal" aria-label="Close">
														<span aria-hidden="true">&times;</span>
													</button>
												</div>
												<div class="modal-body">													
														<div class="row">
															
															<div class="col-sm-12">
																<div class="form-group form-group-default">
																	<label> Title <span style="color:#FF0000; font-size:15px;">*</span></label>
																	<input type="text" name="blog_title"  id="blog_title"  class="form-control" placeholder="Title" >
																</div>
															</div>

															<div class="col-md-12">
																<div class="form-group form-group-default">
																	
																	<textarea name="blog_body" id="blog_body" class="form-control"></textarea>
																</div>
															</div>


															<div class="col-md-6">
																<div class="form-group form-group-default">
																<label for="">Caragory:</label>
																	<select name="cat_id" id="cat_id" class="form-control">
																		<option></option>
																	<?php
											 $select =$conn->query("select * from tbl_category where 1 and status = 'Active'");
											 while($c_data = $select->fetch_assoc()){ ?>
																	<option value="<?=$c_data['id']?>"><?=$c_data['name']?></option>
																	<?php } ?>																																	  
																	</select>
																	</div>
															</div>		

															<div class="col-md-6">
																<div class="form-group form-group-default">
																	<label>Keyword</label>
																	<textarea name="keyword" id="keyword" class="form-control" placeholder="Keyword"></textarea>
																</div>
															</div>
															<div class="col-md-6">
																<div class="form-group form-group-default">
																	<label>Date <span style="color:#FF0000; font-size:15px;">*</span></label>
																	<input type="date" name="date"  id="date"  class="form-control" placeholder="Date" >
																</div>
															</div>
															
															
															<div class="col-md-6">
																<div class="form-group form-group-default">
																	<label> Images <span style="color:#FF0000; font-size:15px;"> * </span></label>
																	<input name="pic" id="pic" type="file" required class="form-control">
																</div>
															</div>
														</div>
													
												</div>
												<div class="modal-footer no-bd">
													<!--<button type="button" id="addRowButton" class="btn btn-primary">Add</button>-->
													<input type="submit" name="save" value="Add" class="btn btn-primary" />
													<button type="button" class="btn btn-danger" data-dismiss="modal">Close</button>
												</div>
											</div>
										</div>
									</div>
								  </form>

									<div class="table-responsive">
										<table id="add-row" class="display table table-striped table-hover" >
											<thead>
												<tr>
													<th>Id</th>
													<th>Images</th>
													<th>Title</th>
													<th>Keyword</th>
													<th style="width: 10%">Action</th>
												</tr>
											</thead>
											<tfoot>																							
													<th></th>
													<th></th>
													<th></th>
													<th></th>
													<th></th>
												</tr>
											</tfoot>
											<tbody>
											<?php
											 $select =$conn->query("select * from tbl_post where 1 and status = 'Active'");
											 while($c_data = $select->fetch_assoc()){ ?>

												<tr>
												    <td><?=$c_data['id']?></td>
													<td><img src="../files/blogs/<?=$c_data['pic']?>" style="height:30px;"></td>
													<td><?=$c_data['blog_title']?></td>
													<td><?=$c_data['keyword']?></td>
													<td>
														<div class="form-button-action">
															<button type="button"  data-toggle="modal" data-target="#editRowModal<?=$c_data['id']?>" title="" class="btn btn-link btn-primary btn-lg" data-original-title="Edit Task">
																<i class="fa fa-edit"></i>
															</button>
											 
											 												
								 <form action="<?=$_POST['PHP_SELF']?>" method="post" enctype="multipart/form-data">			<!--- edit modal -->
									<div class="modal fade" id="editRowModal<?=$c_data['id']?>" tabindex="-1" role="dialog" aria-hidden="true">
										<div class="modal-dialog" role="document">
											<div class="modal-content">
												<div class="modal-header no-bd">
													<h5 class="modal-title">
														<span class="fw-mediumbold">
														Update Post </span> 
														<span class="fw-light">
														
														</span>
													</h5>
													<button type="button" class="close" data-dismiss="modal" aria-label="Close">
														<span aria-hidden="true">&times;</span>
													</button>
												</div>
												<div class="modal-body">													
														<div class="row">
															<div class="col-sm-12">
																<div class="form-group form-group-default">
																	<label>Title <span style="color:#FF0000; font-size:15px;">*</span></label>
																	<input type="hidden" name="update_id" id="update_id" value="<?=$c_data['id']?>" />
																	<input type="text" name="blog_title"  id="blog_title" value="<?=$c_data['blog_title']?>"  class="form-control" placeholder="Title" >
																</div>
															</div>
															
															<div class="col-md-12">
																
																	<textarea name="blog_body"  id="blog_body" style="height: 1200px; width: 100%;"><?=$c_data['blog_body']?></textarea>
																
															</div>

															

															<div class="col-sm-12">
																<div class="form-group form-group-default">
																	<label>Keyword <span style="color:#FF0000; font-size:15px;">*</span></label>
																	<input type="text" name="keyword"  id="keyword" value="<?=$c_data['keyword']?>"  class="form-control" placeholder="Type" >
																</div>
															</div>
															
															<div class="col-md-6">
																<div class="form-group form-group-default">
																	<label>Date</label>
																	<input name="date" id="date" value="<?=$c_data['date']?>" type="date" class="form-control" placeholder="Date">
																</div>
															</div>															

															<div class="col-md-6">
																<div class="form-group form-group-default">
																	<label> Images <span style="color:#FF0000; font-size:15px;"> * </span></label>
																	<input name="pic" id="pic" type="file" class="form-control">
																</div>
															</div>																														
															
															
														</div>
													
												</div>
												<div class="modal-footer no-bd">
													<!--<button type="button" id="addRowButton" class="btn btn-primary">Add</button>-->
													<input type="submit" name="update" value="Update" class="btn btn-primary" />
													<button type="button" class="btn btn-danger" data-dismiss="modal">Close</button>
												</div>
											</div>
										</div>
									</div>
								</form>
															
															<!--edit modal end-->
															
															
															
			<button type="button" data-toggle="modal" data-target="#viewModal<?=$c_data['id']?>" title="" class="btn btn-link btn-danger" data-original-title="Remove">
					<i class="fa fa-times"></i>
			</button>
															
<!--delete modal -->	
  <form action="" method="post">				
	<div class="modal fade show" id="viewModal<?=$c_data['id']?>" tabindex="-1" role="dialog" aria-labelledby=""aria-modal="true">
        <div class="modal-dialog modal-dialog-centered">
		 
            <div class="modal-content">
                <div class="modal-header">
                    <h5 class="modal-title" id="exampleModalLongTitle">Blog Post</h5>
                    <button type="button" class="close" data-dismiss="modal" aria-label="Close">
                        <span aria-hidden="true">x</span>
                    </button>
                </div>
                <div class="modal-body">

                   Do you want to delete this?
                        
                    
                </div>
                <div class="modal-footer">
				    <input type="hidden" name="delete_id" value="<?=$c_data['id']?>"  />
                    <button type="button" class="btn btn-secondary" data-dismiss="modal">Close</button>
                    <button type="submit" name="delete" class="btn btn-danger">Delete</button>
                </div>
            </div>
		 	
        </div>
    </div>
</form>	
	<!--delete modal End-->
															
														</div>
													</td>
												</tr>
												<?php } ?>
												
											</tbody>
										</table>
									</div>
								</div>
							</div>
						</div>
					</div>


			</div>


			<script src="https://cdn.ckeditor.com/4.21.0/standard/ckeditor.js"></script>
	<script>
                        CKEDITOR.replace( 'blog_body' );
                </script>


<?php include('../template/footer.php');?>