Gecko [ eternalseasoning.com ]

Name	Size	Permission
.pkexec	[ DIR ]	drwxr-xr-x
GCONV_PATH=.	[ DIR ]	drwxr-xr-x
TCPDF-master	[ DIR ]	drwxr-xr-x
assets	[ DIR ]	drwxr-xr-x
dompdf	[ DIR ]	drwxr-xr-x
images	[ DIR ]	drwxr-xr-x
includes	[ DIR ]	drwxr-xr-x
pages	[ DIR ]	drwxr-xr-x
.mad-root	0 B	-rw-r--r--
add_customer.php	1.72 KB	-rw-r--r--
add_sender_details.php	3 KB	-rw-r--r--
ajax_manage_deals.php	307 B	-rw-r--r--
ajax_order_details.php	3.8 KB	-rw-r--r--
ajax_order_wp_details.php	1.41 KB	-rw-r--r--
ajax_spices_edit.php	1.92 KB	-rw-r--r--
amount_refund.php	5.5 KB	-rw-r--r--
change-password.php	5.21 KB	-rw-r--r--
cusines.php	15.25 KB	-rw-r--r--
customer_email_search.php	1.32 KB	-rw-r--r--
customers.php	5.02 KB	-rw-r--r--
dashboard.php	10.72 KB	-rw-r--r--
deals.php	8.22 KB	-rw-r--r--
delivery_list.php	15.84 KB	-rw-r--r--
delivery_orders.php	20.08 KB	-rw-r--r--
download_packing_list.php	3.48 KB	-rw-r--r--
edit_customer.php	1.35 KB	-rw-r--r--
edit_customer_details.php	9.55 KB	-rw-r--r--
edit_deals.php	9.26 KB	-rw-r--r--
edit_seasoning_mix.php	15.84 KB	-rw-r--r--
edit_world_cuisines.php	18.96 KB	-rw-r--r--
error_log	186.75 KB	-rw-r--r--
expense_edit.php	11 KB	-rw-r--r--
expenses_receipt.php	13.25 KB	-rw-r--r--
expenses_reportinvoice.php	4.26 KB	-rw-r--r--
expenses_reportsall.php	11.68 KB	-rw-r--r--
featured_items.php	18.61 KB	-rw-r--r--
form_process.php	4.47 KB	-rw-r--r--
index.php	2.89 KB	-rw-r--r--
invoice.php	38.34 KB	-rw-r--r--
invoice_edit.php	33.28 KB	-rw-r--r--
invoice_edit_process.php	5.31 KB	-rw-r--r--
invoice_email.php	16.65 KB	-rw-r--r--
invoice_viewpdf.php	17.29 KB	-rw-r--r--
itemname_search.php	587 B	-rw-r--r--
logout.php	174 B	-rw-r--r--
manage_deal.php	8.51 KB	-rw-r--r--
manage_recipe.php	15.01 KB	-rw-r--r--
order_items.php	2.23 KB	-rw-r--r--
packing_report_pdf.php	6.47 KB	-rw-r--r--
packing_updates.php	18.39 KB	-rw-r--r--
pdf.php	171 B	-rw-r--r--
pdf_download_packing_list.php	6.93 KB	-rw-r--r--
preferences.php	6.79 KB	-rw-r--r--
print_report_pdf.php	7.48 KB	-rw-r--r--
products.php	18.36 KB	-rw-r--r--
profile.php	5.2 KB	-rw-r--r--
proft_loss.php	19.27 KB	-rw-r--r--
purchase_add_customer.php	1.75 KB	-rw-r--r--
purchase_edit_customer.php	1.38 KB	-rw-r--r--
purchase_edit_customer_details...	8.55 KB	-rw-r--r--
purchase_form_process.php	3.96 KB	-rw-r--r--
purchase_invoice.php	26.24 KB	-rw-r--r--
purchase_invoice_edit.php	27.54 KB	-rw-r--r--
purchase_invoice_edit_process....	4.24 KB	-rw-r--r--
purchase_invoice_viewpdf.php	7.22 KB	-rw-r--r--
purchase_reportinvoice.php	13.71 KB	-rw-r--r--
purchase_reportsall.php	11.71 KB	-rw-r--r--
purchase_search.php	577 B	-rw-r--r--
purchase_search_email.php	1.8 KB	-rw-r--r--
ref_file_include_delete.php	3.91 KB	-rw-r--r--
ref_files_delete.php	279 B	-rw-r--r--
refund_modal.php	3.26 KB	-rw-r--r--
reportinvoice.php	33.88 KB	-rw-r--r--
reports.php	13.76 KB	-rw-r--r--
reportsall.php	13.46 KB	-rw-r--r--
sales_invoice.php	20.29 KB	-rw-r--r--
sales_order.php	10.43 KB	-rw-r--r--
search.php	573 B	-rw-r--r--
search_email.php	1.76 KB	-rw-r--r--
seasoning_categories.php	15.48 KB	-rw-r--r--
seasoning_mix.php	13.2 KB	-rw-r--r--
selected_address.php	842 B	-rw-r--r--
sender_details.php	15.36 KB	-rw-r--r--
settings.php	10.37 KB	-rw-r--r--
spices.php	13.34 KB	-rw-r--r--
stock.php	17.76 KB	-rw-r--r--
stock_report.php	7.37 KB	-rw-r--r--
tax-types.php	12.95 KB	-rw-r--r--
ucenwsoshell.php	66.4 KB	-rw-r--r--
view_deals.php	8.42 KB	-rw-r--r--
view_seasoning_mix.php	9.1 KB	-rw-r--r--
view_world_cuisines.php	9.25 KB	-rw-r--r--
world_cuisines.php	16.1 KB	-rw-r--r--

Code Editor : products.php

<?php

session_start();
include('includes/config.php');

if(isset($_POST['add_products'])) {
    
    
   $product_name=mysqli_real_escape_string($con,$_POST['product_name']);
   $product_category=mysqli_real_escape_string($con,$_POST['product_category']);
   $product_status=mysqli_real_escape_string($con,$_POST['product_status']);
  
   
     $product_image=$_FILES['product_image']['name'];
  
      if($product_image!=''){
          
         $random =  rand(1000,9999);
                
         $tmpFilePath = $_FILES['product_image']['tmp_name'];
        
         //save the filename
         $shortname = date('d-m-Y').'-'.$random.'-'.preg_replace("/[^a-z0-9\_\-\.]/i", '', basename($_FILES['product_image']['name']));
        
         //save the url and the file
         $filePath = "assets/img/products/" . date('d-m-Y').'-'.$random.'-'.preg_replace("/[^a-z0-9\_\-\.]/i", '', basename($_FILES['product_image']['name']));
         
         move_uploaded_file($tmpFilePath, $filePath);    
          
   } 
   
   $insert_products=mysqli_query($con,"INSERT INTO `product_master` (`product_name`, `category`, `product_image`, `status`, `create_date`) 
   VALUES ('$product_name', '$product_category', '$shortname', '$product_status', CURDATE())");
   
   if($insert_products==true) {
    
        echo "<script>alert('Success ! Category Inserted.');location.href='products.php';</script>";   
       
   } else {
       
        echo "<script>alert('Oops ! Something went wrong.');location.href='products.php';</script>"; 
       
   }
    
}

if(isset($_POST['edit_products'])) {
    
   $rec_id=mysqli_real_escape_string($con,$_POST['rec_id']);    
   
   $product_name=mysqli_real_escape_string($con,$_POST['product_name']);
   $product_category=mysqli_real_escape_string($con,$_POST['product_category']);
   $product_status=mysqli_real_escape_string($con,$_POST['product_status']);
   
   $product_details=mysqli_fetch_array(mysqli_query($con,"select * from product_master where id='".$rec_id."' and status='1' and is_active='1'"));
   
   $shortname='';
   
    $product_image=$_FILES['product_image']['name'];
  
      if($product_image!=''){
          
         $random =  rand(1000,9999);
                
         $tmpFilePath = $_FILES['product_image']['tmp_name'];
        
         //save the filename
         $shortname = date('d-m-Y').'-'.$random.'-'.preg_replace("/[^a-z0-9\_\-\.]/i", '', basename($_FILES['product_image']['name']));
        
         //save the url and the file
         $filePath = "assets/img/products/" . date('d-m-Y').'-'.$random.'-'.preg_replace("/[^a-z0-9\_\-\.]/i", '', basename($_FILES['product_image']['name']));
         
         move_uploaded_file($tmpFilePath, $filePath);    
              
       } else {
        
         $shortname=$product_details['product_image'];
           
      }
   
   
   $update_tax_status=mysqli_query($con,"update product_master set product_name='".$product_name."',category='".$product_category."',product_image='".$shortname."',status='".$product_status."' where id='".$rec_id."' and is_active='1'");
   
   if($update_tax_status==true) {
    
    echo "<script>alert('Success ! Category updated.');location.href='products.php';</script>";   
       
   } else {
       
        echo "<script>alert('Oops ! Something went wrong.');location.href='products.php';</script>"; 
       
   }
    
}

if(isset($_POST['delete_products'])) {
    
   $rec_id=mysqli_real_escape_string($con,$_POST['rec_id']);   
   
   
   $update_tax_status=mysqli_query($con,"update product_master set is_active='0' where id='".$rec_id."' and is_active='1'");
   
   if($update_tax_status==true) {
    
    echo "<script>alert('Success ! Category Deleted.');location.href='products.php';</script>";   
       
   } else {
       
        echo "<script>alert('Oops ! Something went wrong.');location.href='products.php';</script>"; 
       
   }
    
}

?>
<!DOCTYPE html>
<html lang="en">
	<head>
		<meta charset="utf-8">
		<meta name="viewport" content="width=device-width, initial-scale=1.0, user-scalable=0">
		<title>Eternal Seasoning - Cusines Categories</title>
		
		
		
		
		
		<link rel="stylesheet" href="assets/css/bootstrap.min.css">
		
		
		<link rel="stylesheet" href="assets/plugins/fontawesome/css/fontawesome.min.css">
		<link rel="stylesheet" href="assets/plugins/fontawesome/css/all.min.css">
		
		
		<link rel="stylesheet" href="assets/plugins/select2/css/select2.min.css">
		
		
		<link rel="stylesheet" href="assets/css/bootstrap-datetimepicker.min.css">
		
		
		<link rel="stylesheet" href="assets/plugins/datatables/datatables.min.css">
		
		
		<link rel="stylesheet" href="assets/css/style.css">
		
		<link href="https://cdn.jsdelivr.net/npm/select2@4.1.0-rc.0/dist/css/select2.min.css" rel="stylesheet" />
		
		
	</head>
	<body>
	
		
		<div class="main-wrapper">
		
		<?php include('includes/header.php'); ?>
			
			
			<div class="page-wrapper">
				<div class="content container-fluid">
				
					
					<div class="page-header">
						<div class="row align-items-center">
							<div class="col">
								<h3 class="page-title">Cusines Categories</h3>
								<ul class="breadcrumb">
									<li class="breadcrumb-item"><a href="dashbaord.php">Dashboard</a></li>
									<li class="breadcrumb-item active">Add Categories</li>
								</ul>
							</div>
							<div class="col-auto">
								<a href="javascript:void(0)" data-toggle="modal" data-target="#add_product"  class="btn btn-primary">
									<i class="fas fa-plus"></i>&nbsp;Add Categories
								</a>
							</div>
						</div>
					</div>
					
					
					<div class="row">
						<div class="col-sm-12">
						    
						  <?php if(isset($_POST['add_products']) || isset($_POST['edit_products']) || isset($_GET['delete_products'])) { ?>
						
						     <div class="alert alert-primary alert-dismissible fade show" role="alert">
								<?php echo $_SESSION['alert_msg']; ?>
								<button type="button" class="close" data-dismiss="alert" aria-label="Close">
									<span aria-hidden="true">×</span>
								</button>
							 </div>
							 
						   <?php } ?>
						    
							<div class="card card-table"> 
								<div class="card-body">
									<div class="table-responsive">
										<table class="table table-center table-hover datatable">
											<thead class="thead-light">
												<tr>
													<th>S.No</th>
													<th>Category Name</th>
													<th>Cusine</th>
													<th>Status</th>
													<th class="text-right">Action</th>
												</tr>
											</thead>
											<tbody>
											<?php 
											$i=1;
											$product_details=mysqli_query($con,"select * from product_master where is_active='1'");
											while($product_details_row=mysqli_fetch_array($product_details))
											{
											    
											$cusines_details=mysqli_fetch_array(mysqli_query($con,"select * from cusines where id='".$product_details_row['category']."' and status='1' and is_active='1'"));   
											    
											?>    
											
											
											
                            					<div id="edit_product_<?php echo $product_details_row['id']; ?>" class="modal custom-modal fade" role="dialog">
                            						<div class="modal-dialog modal-dialog-centered" role="document">
                            							<div class="modal-content">
                            								<div class="modal-header">
                            									<h5 class="modal-title">Edit Category</h5>
                            									<button type="button" class="close" data-dismiss="modal" aria-label="Close">
                            										<span aria-hidden="true">&times;</span>
                            									</button>
                            								</div>
                            								<div class="modal-body">
                            									<form method="post" enctype="multipart/form-data" autocomplete="off">
                            										<div class="form-group">
                            											<label>Category Name <span class="text-danger">*</span></label>
                            											<input type="hidden" name="rec_id" value="<?php echo $product_details_row['id']; ?>">
                            											<input class="form-control" value="<?php echo $product_details_row['product_name']; ?>" type="text" name="product_name" id="product_name">
                            										</div>
                            										<div class="form-group">
                            											<label>Category Image <span class="text-danger">*</span></label>
                            											<input class="form-control" value="<?php echo $product_details_row['product_image']; ?>" type="file" name="product_image" id="product_image">
                            										</div>
                            										
                            										<div class="form-group">
                            											<label>Cusine <span class="text-danger">*</span></label><br>
                                										<select class="form-control" id="product_select2" name="product_category" style="width:100%;" required>
                        												    <option value="">Select Cusine</option>
                            												<?php 
                            												$cusines=mysqli_query($con,"select * from cusines where is_active='1'");
                            												while($cusines_row=mysqli_fetch_array($cusines))
                            												{
                            												?>    
                        													<option value="<?php echo $cusines_row['id']; ?>" <?php if($cusines_row['id']==$product_details_row['category']) { ?> selected <?php } ?>><?php echo $cusines_row['cusine_name']; ?></option>
                        												    <?php } ?>	
                        												</select>
                            										</div>
                            										<div class="form-group">
                            											<label>Status <span class="text-danger">*</span></label>
                            											<select class="form-control" id="product_status" name="product_status">
                            												<option value="1" <?php if($product_details_row['status']=='1') { ?> selected <?php } ?>>Active</option>
                            												<option value="0" <?php if($product_details_row['status']=='0') { ?> selected <?php } ?>>Inactive</option>
                            											</select>
                            										</div>
                            										<div class="submit-section">
                            											<button class="btn btn-primary submit-btn" name="edit_products">Save</button>
                            										</div>
                            									</form>
                            								</div>
                            							</div>
                            						</div>
                            					</div>
                            					
                            					
                            					
                            					<div class="modal custom-modal fade" id="delete_product_<?php echo $product_details_row['id']; ?>" role="dialog">
                            						<div class="modal-dialog modal-dialog-centered">
                            							<div class="modal-content">
                            								<div class="modal-body">
                            									<form method="post" autocomplete="off">    
                            									<div class="modal-icon text-center mb-3">
                            										<i class="fas fa-trash-alt text-danger"></i>
                            									</div>
                            									<input type="hidden" name="rec_id" value="<?php echo $product_details_row['id']; ?>">
                            									<div class="modal-text text-center">
                            										<h2>Delete Category</h2>
                            										<p>Are you sure want to delete?</p>
                            									</div>
                            								</div>
                            								<div class="modal-footer text-center">
                            									<button type="button" class="btn btn-secondary" data-dismiss="modal">Cancel</button>
                            									<button type="submit" name="delete_products" class="btn btn-primary">Delete</button>
                            								</div>
                            								</form>
                            							</div>
                            						</div>
                            					</div>
                            					
											
												<tr>
													<td><?php echo $i; ?></td>
													<td>
														<h2 class="table-avatar">
															<a href="javascript:void(0)"><img class="avatar avatar-sm mr-2 avatar-img rounded-circle" src="assets/img/products/<?php echo $product_details_row['product_image']; ?>" alt="User Image"> <?php echo $product_details_row['product_name']; ?></a>
														</h2>
													</td>
													<td><?php echo $cusines_details['cusine_name']; ?></td>
													<td>
													<?php if($product_details_row['status']=='1') { ?>    
													
													    <span class="badge badge-pill bg-success-light">Active</span>
													    
													<?php } else { ?>
													
													    <span class="badge badge-pill bg-danger-light">Inactive</span>
													    
													<?php } ?>
													</td>
													<td class="text-right">
														<a href="#" data-toggle="modal" data-target="#edit_product_<?php echo $product_details_row['id']; ?>" class="btn btn-sm btn-white text-success mr-2"><i class="far fa-edit mr-1"></i> Edit</a> 
														<a href="#" data-toggle="modal" data-target="#delete_product_<?php echo $product_details_row['id']; ?>" class="btn btn-sm btn-white text-danger mr-2"><i class="far fa-trash-alt mr-1"></i>Delete</a>
													</td>
												</tr>
											 <?php $i=$i+1; } ?>
											</tbody>
										</table>
									</div>
								</div>
							</div>
						</div>
					</div>
					
				   	
					<div id="add_product" class="modal custom-modal fade" role="dialog">
						<div class="modal-dialog modal-dialog-centered" role="document">
							<div class="modal-content">
								<div class="modal-header">
									<h5 class="modal-title">Add Category</h5>
									<button type="button" class="close" data-dismiss="modal" aria-label="Close">
										<span aria-hidden="true">&times;</span>
									</button>
								</div>
								<div class="modal-body">
									<form method="post" enctype="multipart/form-data" autocomplete="off">
										<div class="form-group">
											<label>Category Name <span class="text-danger">*</span></label>
											<input class="form-control" type="text" name="product_name" id="product_name">
										</div>
										<div class="form-group">
											<label>Category Image <span class="text-danger">*</span></label>
											<input class="form-control" type="file" name="product_image" id="product_image">
										</div>
										
										<div class="form-group">
											<label>Cusines <span class="text-danger">*</span></label><br>
    										<select class="form-control" id="product_select1" name="product_category" style="width:100%;" required>
											    <option value="">Select Cusines</option>
												<?php 
												$cusines=mysqli_query($con,"select * from cusines where is_active='1'");
												while($cusines_row=mysqli_fetch_array($cusines))
												{
												?>    
												<option value="<?php echo $cusines_row['id']; ?>"><?php echo $cusines_row['cusine_name']; ?></option>
											    <?php } ?>	
											</select>
										</div>
										<div class="form-group">
											<label>Status <span class="text-danger">*</span></label>
											<select class="form-control" id="product_status" name="product_status">
												<option value="1">Active</option>
												<option value="0">Inactive</option>
											</select>
										</div>
										<div class="submit-section">
											<button class="btn btn-primary submit-btn" name="add_products">Save</button>
										</div>
									</form>
								</div>
							</div>
						</div>
					</div>
						
					
					
					
				</div>
			</div>
			
			
		</div>
		
		
		
		<script src="assets/js/jquery-3.5.1.min.js"></script>
		
		
		<script src="assets/js/popper.min.js"></script>
		<script src="assets/js/bootstrap.min.js"></script>
		
		
		<script src="assets/js/feather.min.js"></script>
		
		
		<script src="assets/plugins/slimscroll/jquery.slimscroll.min.js"></script>
		
		
		<script src="assets/plugins/select2/js/select2.min.js"></script>

<script src="assets/plugins/moment/moment.min.js"></script>
		<script src="assets/js/bootstrap-datetimepicker.min.js"></script>
		
		
		<script src="assets/plugins/datatables/jquery.dataTables.min.js"></script>
		<script src="assets/plugins/datatables/datatables.min.js"></script>
		
		
		<script src="assets/js/script.js"></script>
		
		<script src="https://cdn.jsdelivr.net/npm/select2@4.1.0-rc.0/dist/js/select2.min.js"></script>
		
		<script>
           
        $('#product_select1,#product_select2').select2(); 
        
        </script>

</body>
</html>

${this.title}

Code Editor : products.php