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

<?php
   session_start();
   include('includes/config.php');
   
   if(isset($_POST['edit_products'])) {
       
      $rec_id=mysqli_real_escape_string($con,$_POST['rec_id']);    
      
      $product_id        = mysqli_real_escape_string($con,$_POST['product_id']); 
      $product_name      = mysqli_real_escape_string($con,$_POST['product_name']);
    //   $product_qty       = mysqli_real_escape_string($con,$_POST['product_qty']);
      $product_price     = mysqli_real_escape_string($con,$_POST['product_price']);
      $product_status     = mysqli_real_escape_string($con,$_POST['product_status']);
    //   $recepie_ingredient = mysqli_real_escape_string($con,$_POST['recepie_ingredient']);
      
      $product_details = mysqli_fetch_array(mysqli_query($con,"select * from our_products where id='".$rec_id."' and status='1' and is_active='1'"));
      
      $shortname = '';
      
	   $product_image=$_FILES['product_image']['name'];
	   
	     $spiceIds        = $_POST['spice_id'];
        $spiceNames      = $_POST['spice_name'];
        $spiceQuantities = $_POST['sprice_quantity'];
        $price           = $_POST['price'];

$totalPrice = 0;
        for ($i=0; $i < count($price); $i++) { 
           # code...
           $totalPrice  = $totalPrice+$price[$i];
        }

$totalWeight = 0;
	    for ($i=0; $i < count($price); $i++) { 
			# code...

$totalWeight = $totalWeight+$spiceQuantities[$i];
		}
     
         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/deals/" . 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 our_products set category_id='".$product_id."',product_name='".$product_name."',product_image='".$shortname."',price='".$totalPrice."',status='".$product_status."', total_weight='".$totalWeight."' where id='".$rec_id."' and is_active='1'");
	  $deleteSpices       =  mysqli_query($con,"DELETE  FROM  world_cuisines_spices WHERE world_cuisines_id='".$rec_id."' ");

if($update_tax_status == true) {

for ($i=0; $i < count($price) ; $i++) {

# code...
			$insertSpices  = mysqli_query($con, "INSERT INTO `world_cuisines_spices` (`spice_id`,`world_cuisines_id`, `spice_name`,`sprice_quantity`,`price`) 
						   VALUES ('$spiceIds[$i]', '$rec_id', '$spiceNames[$i]', '$spiceQuantities[$i]', '$price[$i]') ");
		 }
          
           $_SESSION['alert_msg']='<strong>Success!</strong> World Cuisines Product Updated.';
          
      } else {
		  
		die(mysqli_error($con));

//    $_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 - Edit World Cuisines</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/bootstrap3-wysihtml5.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">World Cuisines</h3>
                        <ul class="breadcrumb">
                           <li class="breadcrumb-item"><a href="dashbaord.php">Dashboard</a></li>
                           <li class="breadcrumb-item active">Edit World Cuisines</li>
                        </ul>
                     </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 } ?>
                     <?php
                        $cuisine_id=$_GET['cuisine_id'];
                        $seasoning_mix_details=mysqli_fetch_array(mysqli_query($con,"select * from our_products where id='".$cuisine_id."' and status='1' and is_active='1'"));
                        
                        ?>
                     
                     <div id="filter_inputs" class="card filter-card" style="display:block;">
                        <div class="card-body pb-0">
                           <form method="post" enctype="multipart/form-data" autocomplete="off">
                              <div class="row">
                                 <div class="col-md-4">
                                    <div class="form-group">
                                       <label>Cuisine Category <span class="text-danger">*</span></label><br>
                                       <select class="form-control product_select2" id="product_id" name="product_id" style="width:100%;" required>
                                          <option value="">Select Category</option>
                                          <?php 
                                             $product_master=mysqli_query($con,"select * from cusines where is_active='1'");
                                             while($product_master_row=mysqli_fetch_array($product_master))
                                             {
                                             ?>    
                                          <option value="<?php echo $product_master_row['id']; ?>" <?php if($product_master_row['id']==$seasoning_mix_details['category_id']) { ?> selected <?php } ?>><?php echo $product_master_row['cusine_name']; ?></option>
                                          <?php } ?>	
                                       </select>
                                    </div>
                                 </div>
                                 <div class="col-md-4">
                                    <div class="form-group">
                                       <label>Product Name <span class="text-danger">*</span></label>
                                       <input type="hidden" name="rec_id" id="rec_id" value="<?php echo $seasoning_mix_details['id']; ?>">
                                       <input class="form-control" type="text" name="product_name" id="product_name" value="<?php echo $seasoning_mix_details['product_name']; ?>" required>
                                    </div>
                                 </div>
                                 <div class="col-md-4">
                                    <div class="form-group">
                                       <label>Product Image</label><br>
                                       <input type="file" name="product_image" id="product_image" >
                                    </div>
                                 </div>
                                
                                 <div class="col-md-4">
                                    <div class="form-group">
                                       <label>Price <span class="text-danger">*</span></label>
                                       <input class="form-control" type="text" name="product_price" id="product_price" value="<?php echo $seasoning_mix_details['price']; ?>" required>
                                    </div>
                                 </div>
                                 <div class="col-md-4">  
    										<div class="form-group">
    											<label>Total weight (Gm) <span class="text-danger">*</span></label>
    											 <input class="form-control" readonly type="text"  value="<?php echo $seasoning_mix_details['total_weight']; ?>" required>
    										</div>
										</div>
                                 <div class="col-md-4">
                                    <div class="form-group">
                                       <label>Status <span class="text-danger">*</span></label>
                                       <select class="form-control" id="product_status" name="product_status" required>
                                          <option value="1" <?php if($seasoning_mix_details['status']=='1') { ?> selected <?php } ?>>Active</option>
                                          <option value="0" <?php if($seasoning_mix_details['status']=='0') { ?> selected <?php } ?>>Inactive</option>
                                       </select>
                                    </div>
                                 </div>

<div class="col-md-12">
                                    <label>Product Ingredients</label>  
									<table>
									   <?php  $spicesquery  = mysqli_query($con, "SELECT * FROM world_cuisines_spices WHERE world_cuisines_id='$cuisine_id' ");

$count = 1;
									          while($spices = mysqli_fetch_array($spicesquery)) { 
												$spiceQuery     =  mysqli_query($con, "SELECT * FROM spices_list");
												?>
									   <tr id="spice-strip<?php echo  $spices['id'] ?>" data-parient="test" class="clone<?= $spices['id'] ?>">
									       <td>
										      <div class="form-group mr-5">
											       <label for="">Select Spice</label>

<select name="spice_id[]" required class="form-control product_select2" style="width:100%" onchange="reflectName(<?= $spices['id'] ?>)" id="spice_id<?= $spices['id'] ?>">
                                           <option value="">Choose Spice</option>
												       <?php  while ( $value = mysqli_fetch_assoc($spiceQuery)) {

if($spices['spice_id'] == $value['id']) {
														   ?>
														    	<option selected name="<?= $value['spices_name'] ?>" unit_price_per_kg="<?= $value['after_stock_price'] ?>"  value="<?= $value['id'] ?>"  ><?= $value['spices_name'] ?> </option>

<?php } else { ?>

<option name="<?= $value['spices_name'] ?>" unit_price_per_kg="<?= $value['after_stock_price'] ?>"  value="<?= $value['id'] ?>"  ><?= $value['spices_name'] ?> </option>
														   <?php } ?>	
													 
													<?php  }  ?>
													</select>
											  </div>
										   </td>
										   <td>
										       <div class="form-group mr-4">
											        <label for="">Spice Name</label>
													<input type="text" value="<?= $spices['spice_name'] ?>" name="spice_name[]" readonly class="form-control" id="spice-name<?= $spices['id'] ?>">
											   </div>
										   </td>
										   <td>
										       <div class="form-group mr-4">
											        <label for="">Spice Quantity in Grams</label>
													<input type="text" value="<?= $spices['sprice_quantity'] ?>" required onkeyup="calculatePrice(<?= $spices['id'] ?>)" name="sprice_quantity[]"  class="form-control" id="sprice_quantity<?= $spices['id'] ?>">
											   </div>
											   <input type="hidden" name="unit_price_per_kg" id="unit_price_per_kg" >
										   </td>
										   <td>
										       <div class="form-group mr-4">
											        <label for="">Price</label>
													<input type="text" value="<?= $spices['price'] ?>" readonly name="price[]" id="total-price<?= $spices['id'] ?>" class="form-control" >
											   </div>
										   </td>

<td>
										      <?php  if($count == 1) { ?>
										      <button class="btn btn-primary btn-sm" id="button" type="button" onclick="appendTr(<?= $spices['id'] ?>)" onclick="" >+</button>
											  <?php  }else {  ?>
												<button class="btn btn-primary btn-sm" id="button" type="button" onclick="removeTr(<?= $spices['id'] ?>)" onclick="" >-</button>
											  <?php } ?>

</td>
									   </tr>
													<?php $count++;  } ?>
									</table>
                                    
                                 </div>

<div class="col-md-12">
                                    <div class="form-group"> 
                                       <button class="btn btn-primary submit-btn" name="edit_products" style="float: right;margin-bottom:25px;">Submit</button>
                                    </div>
                                 </div>
                              </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 src="assets/js/bootstrap3-wysihtml5.all.min.js"></script>
      <script>

function appendTr(id)
      {
        var randomId        =  Math.floor(Math.random()*90000) + 10000;
        var x               =  document.querySelectorAll('[data-parient=test]');
        var totalClone      =  x.length-1;

$('.product_select2').select2("destroy");

$tr     =    $('#spice-strip'+id).closest("tr").clone().attr({"class":"clone"+randomId});
        $tr.insertAfter((x[totalClone]).closest("tr"));
        $(".clone"+randomId).find("td:eq(4)").find('#button').remove();

$(".clone"+randomId).find("td:eq(0)").find('#spice_id'+id).removeAttr('onchange');

$(".clone"+randomId).find("td:eq(0)").find('#spice_id').find("span").remove();
        $(".clone"+randomId).find("td:eq(0)").find('#spice_id').val();

$(".clone"+randomId).find("td:eq(0)").find('#spice_id'+id).attr({'id':'spice_id'+randomId, 'onChange':'reflectName('+randomId+')'});
        $(".clone"+randomId).find("td:eq(0)").find('#spice_id').select2();

$(".clone"+randomId).find("td:eq(1)").find('#spice-name'+id).attr('id','spice-name'+randomId);
        $(".clone"+randomId).find("td:eq(2)").find('#sprice_quantity'+id).attr({'id':'sprice_quantity'+randomId, 'onKeyup':'calculatePrice('+randomId+')'});
        $(".clone"+randomId).find("td:eq(3)").find('#total-price'+id).attr('id','total-price'+randomId);

$(".clone"+randomId).find("td:eq(4)").prepend("<button type='button' onclick='removeTr("+randomId+")' class='btn btn-primary btn-sm'>-</button>");

$('.product_select2').select2();

}

function removeTr(randomId) {
         $('.clone'+randomId).remove();

}
        
		function reflectName(randomId) {

randomId = randomId || 0;
         if(randomId) {

var name = $('#spice_id'+randomId+' option:selected').attr('name');
            $('#spice-name'+randomId).val(name);

} else {

var name = $('#spice_id option:selected').attr('name');
            $('#spice-name').val(name);
         }
		}

function calculatePrice(randomId) {

randomId = randomId || 0;
         if(randomId) {

var unitPrice  = $('#spice_id'+randomId+' option:selected').attr('unit_price_per_kg');
            var quantity   = $('#sprice_quantity'+randomId).val();

var totalPrice  = (parseFloat(unitPrice)/100)*(parseFloat(quantity)/10);
            totalPrice   = totalPrice.toFixed(2);
            $('#total-price'+randomId).val(totalPrice);

} else {

var unitPrice  = $('#spice_id option:selected').attr('unit_price_per_kg');
            var quantity   = $('#sprice_quantity').val();

var totalPrice  = (parseFloat(unitPrice)/100)*(parseFloat(quantity)/10);
            totalPrice   = totalPrice.toFixed(2);
            $('#total-price').val(totalPrice);
         }

}

$('#product_select1,.product_select2').select2(); 
          $('.textarea').wysihtml5({
               toolbar: { fa: true }
             });
         
      </script>
   </body>
</html>

${this.title}

Code Editor : edit_world_cuisines.php