1#@!#!123s

22527 1#@!#!123s
: / home / journeyindianow / public_html / admin /
Filename : tour_package.php
back
<?php 
include("main.php");

if(isset($_POST['product_insert'])){
	$title    	  = mysqli_real_escape_string($con,$_POST['title']);
	$keywords    = mysqli_real_escape_string($con,$_POST['keywords']);
	$headerdes   = mysqli_real_escape_string($con,$_POST['description']);
	$name 	  = mysqli_real_escape_string($con,$_POST['name']);
	$category = mysqli_real_escape_string($con,$_POST['category']);
	$price    = mysqli_real_escape_string($con,$_POST['price']);
	$content  = mysqli_real_escape_string($con,$_POST['content']);
	$des2  = mysqli_real_escape_string($con,$_POST['des2']);
	$des3  = mysqli_real_escape_string($con,$_POST['des3']);
	$des4  = mysqli_real_escape_string($con,$_POST['des4']);
	$featured = mysqli_real_escape_string($con,$_POST['featured']);
	$pagelink = mysqli_real_escape_string($con,$_POST['pagelink']);
	$pic  	  =  $_FILES['picture']['name'];
	if($_POST['subcat']!=''){
		$subcat   = mysqli_real_escape_string($con,$_POST['subcat']);
	}else{
		$subcat   = 0;
	}
	
	 if($_FILES['picture']['name']!= '')
		{
			$extension		= end(explode(".", $pic));
			$targate_file	= time().rand(10,100).".".$extension;
			if (move_uploaded_file($_FILES['picture']['tmp_name'],"product/".$targate_file)){
				 $insert = "INSERT INTO `tour_package`(`intCategoryId`, `varProductName`, `varPrice`,`varImage`, `txtDescription`, `varFeatured`, `varMetaTitle`, `varMetaKeywords`, `txtMetaDescription`, subcat,txtDescription2,txtDescription3,txtDescription4,varLInk) VALUES ($category,'$name','$price','$targate_file','$content','$featured','$title','$keywords','$headerdes',$subcat,'$des2','$des3','$des4','$pagelink')";
				if(mysqli_query($con,$insert))
				{
					echo "<script>alert('Submitted Successfully');</script>";
					echo "<script>window.location.replace('tour_package.php');</script>";
				}else{
					echo "<script>alert('Something went wrong');</script>";
				} 
			}
	   }else{
		   echo "<script>alert('Something went wrong');</script>";
	   }
	   
	    
	   
}

/* product edit code */
if(isset($_POST['product_update'])){
	$title    	  = mysqli_real_escape_string($con,$_POST['title']);
	$keywords    = mysqli_real_escape_string($con,$_POST['keywords']);
	$headerdes   = mysqli_real_escape_string($con,$_POST['description']);
	$pid 	  = mysqli_real_escape_string($con,$_POST['product_update']);
	$name 	  = mysqli_real_escape_string($con,$_POST['name']);
	$category = mysqli_real_escape_string($con,$_POST['category']);
	$price    = mysqli_real_escape_string($con,$_POST['price']);
	$content  = mysqli_real_escape_string($con,$_POST['content']);
	$featured = mysqli_real_escape_string($con,$_POST['featured']);
	$pic  	  =  $_FILES['picture']['name'];
	
	$update = "UPDATE `tour_package` SET `intCategoryId`=$category,`varProductName`='$name',`varPrice`='$price',`txtDescription`='$content',`varFeatured`='$featured',`varMetaTitle`='$title',`varMetaKeywords`='$keywords',`txtMetaDescription`='$headerdes'";
	 if($_FILES['picture']['name']!= '')
		{
			$extension		= end(explode(".", $pic));
			$targate_file	= time().rand(10,100).".".$extension;
			if (move_uploaded_file($_FILES['picture']['tmp_name'],"product/".$targate_file)){
				 $update .= ",`varImage`='$targate_file'";
			}
	   }
	   
	     $update .= " WHERE `intId`=$pid";
		if($up = mysqli_query($con,$update))
		{
			echo "<script>alert('Updated Successfully');</script>";
			echo "<script>window.location.replace('tour_package.php');</script>";
		}else{
			echo "<script>alert('Something went wrong');</script>";
			echo "<script>window.location.replace('tour_package.php');</script>";
		} 
	   
}

/* product edit code */

/* product delete code */
if(isset($_POST['delete'])){
	
	$id = mysqli_real_escape_string($con,$_POST['delete']);
	$squery = mysqli_query($con,"SELECT `varImage` FROM `tour_package` WHERE `intId`=$id");
	$res    = mysqli_fetch_object($squery);
	unlink("product/$res->varImage");
	$delete = mysqli_query($con,"DELETE FROM `tour_package` WHERE `intId`=$id");
	if($delete){
		
		echo "<script>window.location.replace('tour_package.php');</script>";
	}else{
		echo '<script>alert("Something went wrong");</script>';
	}
}
/* end product delete code */

?>
<!--  page-wrapper -->
<div id="page-wrapper">
	<div class="row">
		<!-- Page Header -->
		<div class="col-lg-12">
			<h1 class="page-header">Tour Package</h1>
		</div>
		<!--End Page Header -->
	</div>
	<div class="row">
		<div class="col-sm-12">
			<div class="panel panel-default">
				<div class="panel-heading"><h3 class="panel-title">Add Package <span style="color:red;float:right">* Required</span></h3></div>
				<div class="panel-body">
					<div class=" form">
						<form role="form" method="post" action="" enctype="multipart/form-data">	
							<fieldset>	
								<div class="form-group">	
									<div class="col-sm-12">
										<label for="disabledSelect ">Name <span style="color:red;">*</span></label>
										<input class="form-control" required="" name="name" type="text" value="" >
									</div>
								</div>
								<div class="form-group">	
									<div class="col-sm-6">
										<label for="disabledSelect ">Category <span style="color:red;">*</span></label>
										<select class="form-control category" required="" name="category" >
											<option>Choose Category</option>
										<?php 
											$category = mysqli_query($con,"SELECT `intId`, `varName` FROM `tour_category`");
											if(mysqli_num_rows($category) > 0){
												while($crow = mysqli_fetch_object($category) ){
													echo '<option value="'.$crow->intId.'">'.$crow->varName.'</option>';
												}
											}
										?>
										</select>
									</div>
									<div class="col-sm-6">
										<label for="disabledSelect ">Sub Category <span style="color:red;">*</span></label>
										<select class="form-control subcat" required="" name="subcat" >
											<option value="">Choose SubcateCategory</option>
										
										</select>
									</div>
								</div>	
												
								<div class="form-group">							
									<div class="col-sm-6">
										<label for="disabledSelect ">Image</label>
										<input class="form-control" name="picture" type="file" >
									</div>
									<div class="col-sm-6">
										<label for="disabledSelect ">Page Link</label>
										<input class="form-control" name="pagelink" type="text" >
									</div>
								</div>
								 
							<!--	<div class="form-group ">
									<div class="col-lg-12">
										<label for="ccomment">SEO Title</label>
										<input class="form-control "  type="text" name="title"  aria-required="true" value="<?php echo $res->varMetaTitle; ?>">
									</div>
								</div>
								<div class="form-group ">
									<div class="col-lg-6">
										<label for="ccomment">SEO Keywords</label>
										<textarea class="form-control"  name="keywords" required="required" aria-required="true" placeholder="Enter The Keywords">
										<?php echo $res->varMetaKeywords; ?></textarea>
									</div>
									<div class="col-lg-6">
										<label for="ccomment">SEO Description</label>
										<textarea class="form-control"  name="description" required="required" aria-required="true" placeholder="Enter The Description"><?php echo $res->txtMetaDescription; ?></textarea>
									</div>
								</div>-->
								 
								<div class="form-group">
									<div class="col-sm-12">
										<label for="disabledSelect">Description <span style="color:red;">*</span></label>
										<textarea class="form-control ckeditor" id="js-my-textarea1" name="content" required=""  placeholder="Enter The Content" ></textarea>
									</div>
								</div>
								<!--<div class="form-group">
									<div class="col-sm-12">
										<label for="disabledSelect">Tour Itinerary <span style="color:red;">*</span></label>
										<textarea class="form-control ckeditor" id="js-my-textarea1" name="des2" required=""  placeholder="Enter The Content" ></textarea>
									</div>
								</div>
								<div class="form-group">
									<div class="col-sm-12">
										<label for="disabledSelect">Inclusion / Exclusion <span style="color:red;">*</span></label>
										<textarea class="form-control ckeditor" id="js-my-textarea1" name="des3" required=""  placeholder="Enter The Content" ></textarea>
									</div>
								</div>
								<div class="form-group">
									<div class="col-sm-12">
										<label for="disabledSelect">Terms &amp; Conditions <span style="color:red;">*</span></label>
										<textarea class="form-control ckeditor" id="js-my-textarea1" name="des4" required=""  placeholder="Enter The Content" ></textarea>
									</div>
								</div>-->
								<br/><br/>
								<div class="form-group">
									<div class="col-sm-12">		
										<button type="submit" name="product_insert" class="btn btn-primary" style="margin-top:10px;">Submit</button>
										<a href="all_tour_package.php"><button type="button" name="" class="btn btn-primary" style="margin-top:10px;">View All Tour Packages</button></a>
									</div>
								</div>			
							</fieldset>
						</form>
					</div> <!-- .form -->
				</div> <!-- panel-body -->
			</div> <!-- panel -->
		</div> <!-- col -->
	</div> <!-- End row -->
			<!--<div class="row">
				<div class="col-lg-12">
                  <!--   Kitchen Sink - ->
                    <div class="panel panel-default">
                        <div class="panel-heading">
							 All Records 
                        </div>
                        <div class="panel-body">
                            <div class="table-responsive">
                                <table class="table table-striped table-bordered table-hover">
                                    <thead>
                                        <tr>
                                            <th>Sno.</th>
                                            <th>Image</th>
                                            <th>Category</th>
                                            <th>Sub Category</th>
                                            <th>Name</th>
                                           <!-- <th>Content</th> - ->                          
                                            <th>Edit</th>
                                            <th>Delete</th>
                                        </tr>
                                    </thead>
                                    <tbody>
										<?php 
										
											/*$query = mysqli_query($con,"SELECT * FROM `tour_package`");
											
											if($query){  
												 $sno = 1;
												while($row = mysqli_fetch_object($query)){
													
													$cat = mysqli_query($con,"SELECT  * FROM `tour_category` WHERE `intId`=$row->intCategoryId");
													$catrow = mysqli_fetch_object($cat);
													
													 $subcatrow = mysqli_query($con,"SELECT  * FROM subcategory WHERE intId=$row->subcat");
													$scat = mysqli_fetch_object($subcatrow); 
													
													echo '<tr>
															<td>'.$sno.'</td>
															<td><img src="'.$base_url.'admin/product/'.$row->varImage.'" height="75" width="75" /></td>
															<td>'.$catrow->varName.'</td>
															<td>'.ucwords($scat->varName).'</td>
															<td>'.$row->varProductName.'</td>
															<!--<td>'.$row->txtDescription.'</td>-->
															<td>
																<a href="#" class="on-default edit-row"><i class="fa fa-pencil" data-toggle="modal" data-target="#edit_'.$row->intId.'"></i></a>
															</td>
															<td>
																<a href="#" class="on-default edit-row"><i class="fa fa-trash-o" data-toggle="modal" data-target="#del_'.$row->intId.'"></i></a>
															</td>
	<!-- Package Update Modal -->
	<div class="modal fade" id="edit_'.$row->intId.'" role="dialog">
		<div class="modal-dialog modal-lg">
		
		  <!-- Modal content-->
		  <div class="modal-content">
			<div class="modal-header">
			  <button type="button" class="close" data-dismiss="modal">&times;</button>
			  <h4 class="modal-title">Update Product </h4>
			</div>
			<div class="modal-body">
				<form role="form" method="post" action="" enctype="multipart/form-data">	
					<fieldset>						
						<div class="form-group">							
							<div class="col-sm-7">
								<label for="disabledSelect ">Image</label>
								<input class="form-control" name="picture" type="file" >
							</div>
							<div class="col-sm-5">
								<img src="'.$base_url.'admin/product/'.$row->varImage.'" height="75" width="75">
							</div>
						</div>
						<div class="form-group">	
							<div class="col-sm-12">
								<label for="disabledSelect ">Name <span style="color:red;">*</span></label>
								<input class="form-control" required="" name="name" type="text" value="'.$row->varProductName.'" >
							</div>
						</div>
						<div class="form-group">	
							<div class="col-sm-6">
								<label for="disabledSelect ">Category <span style="color:red;">*</span></label>
								<select class="form-control category1" required="" name="category" >';
								
									$category = mysqli_query($con,"SELECT `intId`, `varName` FROM `tour_category`");
									if(mysqli_num_rows($category) > 0){
										while($crow = mysqli_fetch_object($category) ){
											if($crow->intId == $row->intCategoryId){
												echo '<option value="'.$crow->intId.'" selected>'.$crow->varName.'</option>';
											}else{
												echo '<option value="'.$crow->intId.'">'.$crow->varName.'</option>';
											}
											
										}
									}
							
									
									
										
						echo	'</select>
							</div>
							<div class="col-sm-6">
								<label for="disabledSelect ">Sub Category <span style="color:red;">*</span></label>
								<select class="form-control subcat1" required="" name="subcat" >
									<option value="'.$scat->intId.'">'.$scat->varName.'</option>
								
								</select>
							</div>	
						</div>	
					 
						<div class="form-group ">
							<div class="col-lg-12">
								<label for="ccomment" >SEO Title</label>
								<input class="form-control "  type="text" name="title"  aria-required="true" value="'. $row->varMetaTitle .'">
							</div>
						</div>
						<div class="form-group ">
							<div class="col-lg-6">
								<label for="ccomment" >SEO Keywords</label>
								<textarea class="form-control"  name="keywords" required="required" aria-required="true" placeholder="Enter The Keywords">
								'.$row->varMetaKeywords.'</textarea>
							</div>
							<div class="col-lg-6">
								<label for="ccomment">SEO Description</label>
								<textarea class="form-control"  name="description" required="required" aria-required="true" placeholder="Enter The Description">'. $row->txtMetaDescription.'</textarea>
							</div>
						</div>
				 
						<div class="form-group">
							<div class="col-sm-12">
								<label for="disabledSelect">Description <span style="color:red;">*</span></label>
								<textarea class="form-control ckeditor" id="js-my-textarea1" name="content" required=""  placeholder="Enter The Content" >'.$row->txtDescription .'</textarea>
							</div>
						</div>
						<br/><br/>
						<div class="form-group">
							<div class="col-sm-12">		
								<button type="submit" name="product_update" class="btn btn-primary" value="'.$row->intId.'" style="margin-top:10px;">Update</button>
							</div>
						</div>			
					</fieldset>
				</form>
			</div>
			<div class="modal-footer">
			  <button type="button" class="btn btn-default" data-dismiss="modal">No</button>
			</div>
		  </div>
		  
		</div>
	</div>														
	<!-- Package Delete Modal -->
	<div class="modal fade" id="del_'.$row->intId.'" role="dialog">
		<div class="modal-dialog modal-sm">
		
		  <!-- Modal content-->
		  <div class="modal-content">
			<div class="modal-header">
			  <button type="button" class="close" data-dismiss="modal">&times;</button>
			  <h4 class="modal-title">Delete Tour Package </h4>
			</div>
			<div class="modal-body">
			  <p>Are you sure, you want to delete this Package?</p>
			</div>
			<div class="modal-footer">
				<form  method="post">
					<button type="submit"  value="'.$row->intId.'" class="btn btn-danger" name="delete">Yes</button></a>
					<button type="button" class="btn btn-default" data-dismiss="modal">No</button>
				</form>
			</div>
		  </div>
		  
		</div>
	</div>
														</tr>';
														$sno ++;
												}
											}else{
												echo "Record Not Found";
											}*/
										?>
                                      
                                        
                                    </tbody>
                                </table>
                            </div>
                        </div>
                    </div>
                     <!-- End  Kitchen Sink - ->
                </div>
			</div>-->
</div>
        <!-- end page-wrapper -->
		<script src="https://ajax.googleapis.com/ajax/libs/jquery/3.4.1/jquery.min.js"></script>
<script>
$(document).ready(function(){
	 
	
	
	
	$(".category").change(function(){
 
		var cat  = $(this).val();
		 
		$.post("ajax_subcat.php",{cat:cat},function(data){
			//alert(data);
			$(".subcat").html(data);
		});
	});
	
	$(".subcat").change(function(){
		
		var subcat = $(this).val();
		var cat  = $(".category").val();
		 
		$.post("ajax_supercat.php",{cat:cat,subcat:subcat},function(data){
			$(".supercat").html(data);
		});
	});
	
	$(".category1").change(function(){
 
		var cat  = $(this).val();
		 
		$.post("ajax_subcat.php",{cat:cat},function(data){
			//alert(data);
			$(".subcat1").html(data);
		});
	});
		$(".subcat1").change(function(){
		
		var subcat = $(this).val();
		var cat  = $(".category1").val();
		// alert(subcat+" "+cat);
		$.post("ajax_supercat.php",{cat:cat,subcat:subcat},function(data){
			$(".supercat1").html(data);
		});
	});
});

$(document).ready(function() {
    $('#example').DataTable();
} );
</script>

<?php include("footer.php"); ?>