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 : spices.php

<?php
    include('includes/config.php');
    session_start();
    
    if(isset($_POST['create-ingredients'])) {
      
      $spices_name= mysqli_real_escape_string($con,$_POST['spices_name']);
      $price      = mysqli_real_escape_string($con,$_POST['price']);
      $status     = mysqli_real_escape_string($con,$_POST['status']);
      
      $spices_image=$_FILES['spices_image']['name'];
  
      if($spices_image!=''){
          
         $random =  rand(1000,9999);
                
         $tmpFilePath = $_FILES['spices_image']['tmp_name'];
        
         //save the filename
         $shortname = date('d-m-Y').'-'.$random.'-'.preg_replace("/[^a-z0-9\_\-\.]/i", '', basename($_FILES['spices_image']['name']));
        
         //save the url and the file
         $filePath = "assets/img/spices/" . date('d-m-Y').'-'.$random.'-'.preg_replace("/[^a-z0-9\_\-\.]/i", '', basename($_FILES['spices_image']['name']));
         
         move_uploaded_file($tmpFilePath, $filePath);    
          
     } 
     
      $spice_name_check = mysqli_num_rows(mysqli_query($con,"select * from spices_list where spices_name='".$spices_name."' and status='1' and is_active='1'"));
     
         if($spice_name_check == '0')
         {
            
              $insert_ingredients=mysqli_query($con,"INSERT INTO `spices_list` (`spices_name`, `spices_images`, `price`, `status`, `create_date`) 
              VALUES ('$spices_name', '$shortname', '$price', '$status', CURDATE())");     
			   
			   
			//    die(mysqli_error($con));
               if($insert_ingredients==true) 
               {
                   
                   $_SESSION['alert_msg']='<strong>Success!</strong> Spices Added.';
                   
               } else {
                   
                   $_SESSION['alert_msg']='<strong>Oops!</strong> Something went wrong.';
               }
           
         } else {
             
            $_SESSION['alert_msg']='<strong>Oops!</strong> This spice is already added.';
             
         } 
        
    }
    
    if(isset($_POST['edit-ingredients'])) {
      
      $rec_id      = $_POST['rec_id'];  
      $spices_name = mysqli_real_escape_string($con,$_POST['spices_name']);
	  $price       = mysqli_real_escape_string($con,$_POST['price']);
	  
      $status          = mysqli_real_escape_string($con,$_POST['status']);
      $product_details = mysqli_fetch_array(mysqli_query($con,"select * from spices_list where id='".$rec_id."' and status='1' and is_active='1'"));
   
      $shortname='';
      $spices_image=$_FILES['spices_image']['name'];
  
      if($spices_image!=''){
          
         $random =  rand(1000,9999);
                
         $tmpFilePath = $_FILES['spices_image']['tmp_name'];
        
         //save the filename
         $shortname = date('d-m-Y').'-'.$random.'-'.preg_replace("/[^a-z0-9\_\-\.]/i", '', basename($_FILES['spices_image']['name']));
        
         //save the url and the file
         $filePath = "assets/img/spices/" . date('d-m-Y').'-'.$random.'-'.preg_replace("/[^a-z0-9\_\-\.]/i", '', basename($_FILES['spices_image']['name']));
         
         move_uploaded_file($tmpFilePath, $filePath);    
              
       } else {
        
         $shortname=$product_details['spices_images'];
           
      }
        
      $update_category=mysqli_query($con,"update `spices_list` SET `spices_name`='".$spices_name."', `spices_images`='".$shortname."', `price`='".$price."', `status`='".$status."' where id='".$rec_id."' and is_active='1'");

if($update_category==true) 
       {
           
           $_SESSION['alert_msg']='<strong>Success!</strong> Spices Updated.';
           
       } else {
           
           $_SESSION['alert_msg']='<strong>Oops!</strong> Something went wrong.';
       }
        
    }

if(isset($_GET['delete']))
    {
        $id=$_GET['delete'];
        
        $del=mysqli_query($con,"DELETE FROM  spices_list WHERE  id='".$id."' ");
        
        if($del==true)
        {
            
            $_SESSION['alert_msg']='<strong>Success!</strong> Spices Deleted.';
        }
            
        else {
            
           $_SESSION['alert_msg']='<strong>Oops!</strong> Something went wrong.';
          
        }
    }
    
?>
<!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 - Spices</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/plugins/datatables/datatables.min.css">
		
		
		<link rel="stylesheet" href="assets/css/bootstrap-datetimepicker.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">
								
								<ul class="breadcrumb">
									<li class="breadcrumb-item"><a href="dashboard.php">Dashboard</a></li>
									<li class="breadcrumb-item active">Spices</li>
								</ul>
							</div>
						
							<div class="col-auto">
								<a href="javascript:void(0)" class="btn btn-primary" data-toggle="modal" data-target="#add_category">
									<i class="fas fa-plus"></i> Add Spices
								</a>
						    </div>
						</div>
					</div>
					
					
					<div class="row">
						<div class="col-sm-12">
						
						 <?php if(isset($_POST['create-ingredients']) || isset($_POST['edit-ingredients']) || isset($_GET['delete'])) { ?>
						
						     <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-stripped table-hover datatable">
											<thead class="thead-light">
												<tr>
												   <th>S.No</th>
												   <th>Spices Name</th>
												   
												   <th>Status</th>
												   <th class="text-right">Action</th>
												</tr>
											</thead>
											<tbody>
										        <?php 
									                
                                        		$i=0;
                                                $ingredients=mysqli_query($con,"SELECT * FROM spices_list where is_active='1' ORDER BY id DESC");
                                                while($ingredients_row=mysqli_fetch_array($ingredients)){
                                                $i++;
                                        	    ?>
                                        	    
												<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/spices/<?php echo $ingredients_row['spices_images']; ?>" alt="User Image"> <?php echo $ingredients_row['spices_name']; ?></a>
														</h2>
													</td>
													
													<td>
													<?php if($ingredients_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 class="btn btn-sm btn-info mr-2" href="javascript:void(0)" onclick="edit_ingredients(<?php echo $ingredients_row['id']; ?>)">
															<i class="fas fa-edit mr-1"></i> Edit
														</a>
														<a class="btn btn-sm btn-danger" href="spices.php?delete=<?php echo $ingredients_row['id']?>" onclick="return confirm('Are you sure you want to delete this item?');">
															<i class="fas fa-trash mr-1"></i> Delete
														</a>
													</td>
												</tr>
												<?php }?>
											</tbody>
										</table>
									</div>
								</div>
							</div>
						</div>
					</div>
					
				    
					<div id="add_category" 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 Spices</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" autocomplete="off" enctype="multipart/form-data">
									   
										<div class="form-group">
											<label>Spices Name <span class="text-danger">*</span></label>
											<input class="form-control" type="text" name="spices_name" id="spices_name" required>
										</div>
										<div class="form-group">
											<label>Spices Image <span class="text-danger">*</span></label>
											<input class="form-control" type="file" name="spices_image" id="spices_image" required>
										</div>
										<div class="form-group">
											<label>Price <span class="text-danger">*</span></label>
											<input class="form-control" type="text" name="price" id="price" required>
										</div>
										<div class="form-group">
											<label>Status <span class="text-danger">*</span></label>
											<select class="form-control" name="status" id="status" required>
												<option value="1">Active</option>
												<option value='0'>Inactive</option>
											</select>
										</div>
										<div class="submit-section">
											<button type="submit" class="btn btn-primary submit-btn" name="create-ingredients">Submit</button>
										</div>
									</form>
								</div>
							</div>
						</div>
					</div>
						
					
					
					<div id="edit_ingredient" 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 Spices</h5>
									<button type="button" class="close" data-dismiss="modal" aria-label="Close">
										<span aria-hidden="true">&times;</span>
									</button>
								</div>
								<div class="modal-body" id="view_ingredient_details">
									
								</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/datatables/jquery.dataTables.min.js"></script>
		<script src="assets/plugins/datatables/datatables.min.js"></script>

<script src="assets/plugins/moment/moment.min.js"></script>
		<script src="assets/js/bootstrap-datetimepicker.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>
		    
            // In your Javascript (external .js resource or <script> tag)
        $('#product_id').select2(); 
            
         function edit_ingredients(val) {
             
    		  
    	     $.ajax({  
                url:"ajax_spices_edit.php",  
                method:"POST",  
                data:{ ing_id:val },  
                success:function(data)  
                { 
                 
                  $('#view_ingredient_details').html(data);
                  
                  $('#edit_ingredient').modal('show');
                      
                }  
                
               }); 
            
        	}   
            
        
		</script>

</body>
</html>

${this.title}

Code Editor : spices.php