Gecko [ eternalseasoning.com ]

Name	Size	Permission
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
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 : stock.php

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

if(isset($_POST['stock_update']))
    {
        $stock_id=$_POST['stock_id'];
        $open_stock=$_POST['open_stock'];
        $current_stock=$_POST['current_stock'];
        
        $update_stock= $open_stock + $current_stock;
        
        $current_stock_price=$_POST['current_stock_price'];
        $profit_amt=$_POST['profit_amt'];
        
        $before_stock_value=$update_stock * $current_stock_price;
       
        $after_price= ($current_stock_price/100)*$profit_amt;
        
		$stock_after_profit= $current_stock_price + $after_price;
		
		$stock_after_profit  = round($stock_after_profit,2);
        
        $stock_value_after_profit= $stock_after_profit * $update_stock;
        
        $stock_update=mysqli_query($con,"update spices_list set stock_qty='".$update_stock."',price='".$current_stock_price."',profit_amt='".$profit_amt."',
        before_stock_value='".$before_stock_value."',after_stock_price='".$stock_after_profit."',after_stock_value='".$stock_value_after_profit."' where id='".$stock_id."' and is_active='1'");

//update worls cuisines spice list price
		$fetchWorldCuisinesSpice = mysqli_query($con,"select * FROM world_cuisines_spices where spice_id='".$stock_id."' ");
		
		while ($spices = mysqli_fetch_assoc($fetchWorldCuisinesSpice) ) {
			$unitPrice  = $stock_after_profit;
			$quantity = $spices['sprice_quantity'];

$totalPrice  = (($unitPrice)/100)*(($quantity)/10);
			$totalPrice  = round($totalPrice,2);

$spice_update=mysqli_query($con,"update world_cuisines_spices set price='".$totalPrice."' where spice_id = '".$stock_id."' and sprice_quantity = '".$quantity."'");
			$totalProductPrice = mysqli_fetch_assoc(mysqli_query($con,"select SUM(price) AS total FROM world_cuisines_spices WHERE world_cuisines_id='".$spices['world_cuisines_id']."' "));
			$product_price_update=mysqli_query($con,"update our_products set  price = '".round($totalProductPrice['total'],2) ."' WHERE id = '".$spices['world_cuisines_id']."' ");

}

//update porridge spice list price
		$fetchPorridgeSpice = mysqli_query($con,"select * FROM porridge_spices where spice_id='".$stock_id."' ");
		
		while ($spices = mysqli_fetch_assoc($fetchPorridgeSpice) ) {
			$unitPrice  = $stock_after_profit;
			$quantity = $spices['sprice_quantity'];

$totalPrice  = (($unitPrice)/100)*(($quantity)/10);
			$totalPrice  = round($totalPrice,2);

$spice_update=mysqli_query($con,"update porridge_spices set price='".$totalPrice."' where spice_id = '".$stock_id."' and sprice_quantity = '".$quantity."'");
			$totalProductPrice = mysqli_fetch_assoc(mysqli_query($con,"select SUM(price) AS total FROM porridge_spices WHERE porridge_id='".$spices['porridge_id']."' "));
			$product_price_update=mysqli_query($con,"update our_products set  price = '".round($totalProductPrice['total'],2) ."' WHERE id = '".$spices['porridge_id']."' ");

}

//update reacipies spice list price
		$fetchReacipiesSpice = mysqli_query($con,"select * FROM reacipie_items where product_id='".$stock_id."' ");
		
		while ($spices = mysqli_fetch_assoc($fetchReacipiesSpice) ) {
			$unitPrice  = $stock_after_profit;
			$quantity = $spices['quantity'];

$totalPrice  = (($unitPrice)/100)*(($quantity)/10);
			$totalPrice  = round($totalPrice, 2);

$spice_update=mysqli_query($con,"update reacipie_items set product_price='".$totalPrice."' where product_id = '".$stock_id."' and quantity = '".$quantity."'");
			$totalProductPrice = mysqli_fetch_assoc(mysqli_query($con,"select SUM(product_price) AS total FROM reacipie_items WHERE reacipie_id='".$spices['reacipie_id']."' "));
			$product_price_update=mysqli_query($con,"update reacipies set subtotal = '".round($totalProductPrice['total'],2)."', total_price = '".$totalProductPrice['total']."', is_active = 1 WHERE id = '".$spices['reacipie_id']."' ");

}

if($stock_update)
        {
            echo "<script>alert('Success! Stock values updated.');location.href='stock.php'</script>";
        }
            
        else {
            
            echo "<script>alert('Oops! Something went wrong.');location.href='stock.php'</script>";
        }
    }
    
    
    $_SESSION['pch_form_date']='';
    $_SESSION['pch_to_date']='';
    
    if(isset($_POST['search'])) {
        
      $_SESSION['pch_form_date']=$_POST['from_date'];  
      $_SESSION['pch_to_date']=$_POST['to_date'];  
        
    }
    
?>
<!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 - Stock Details</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">
		
		<style>
		 
		 .text-primary {
		     
                color: #0f1568 !important;
            } 
            		    
		</style>
		
		
	</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</a></li>
									<li class="breadcrumb-item active">Stock Details</li>
								</ul>
							</div>
						</div>
					</div>
					
				
					
					<div class="row">
						<div class="col-sm-12">
							<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</th>
												   <th>Stock in KG</th>
												   <th>Stock Price/KG Before Profit</th>
												   <th>Stock Value Before Profit</th>
												   <th>Action</th>
												   <th>Profit (%)</th>
												   <th>Stock Price/KG After Profit</th>
												   <th>Stock Value After Profit</th>
												   <th>Status</th>
												</tr>
											</thead>
											<tbody>
										        <?php 
									                
                                        		$i=0;
                                        		$before_stock_price_profit_tot=0;
                                                $before_stock_value_profit_tot=0;
                                                $after_stock_price_profit_tot=0;
                                                $after_stock_value_profit_tot=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++;
                                                
                                                $before_stock_price_profit_tot=$before_stock_price_profit_tot+$ingredients_row['price'];
                                                $before_stock_value_profit_tot=$before_stock_value_profit_tot+$ingredients_row['before_stock_value'];
                                                $after_stock_price_profit_tot=$after_stock_price_profit_tot+$ingredients_row['after_stock_price'];
                                                $after_stock_value_profit_tot=$after_stock_value_profit_tot+$ingredients_row['after_stock_value'];
                                        	    ?>
                                        	    
                                        	    <div class="modal fade" id="stock_modal_<?php echo $ingredients_row['id']; ?>" tabindex="-1" role="dialog" aria-labelledby="myLargeModalLabel" aria-hidden="true">
                                                    <div class="modal-dialog" role="document">
                                                        <div class="modal-content">
                                                            <div class="modal-header">
                                                                <h5 class="modal-title" id="exampleModalLabel">Stock Update</h5>
                                                                <button type="button" class="close" data-dismiss="modal" aria-label="Close">
                                                                  <span aria-hidden="true">&times;</span>
                                                                </button>
                                                            </div>
                                                            <form method="post" >
                                                                <div class="modal-body">
                                                                
                                                                <div class="row">
                                                                    <div class="col-md-12">
                                                                        <input type="hidden" name="stock_id" id="stock_id" value="<?php echo $ingredients_row['id']; ?>">
                                                                        <h3 style="text-align:center;"><?php echo $ingredients_row['spices_name']; ?></h3>
                                                                    </div>
                                                                </div>
                                                                
                                                                <div class="row">
                                                                    <div class="col-md-6">
                                                                        <label>Opening Stock</label>
                                                                        <div class="form-group">
                                                                            <input type="text" class="form-control" name="open_stock" value="<?php echo $ingredients_row['stock_qty']; ?>" readonly>
                                                                        </div>
                                                                    </div>
                                                                    <div class="col-md-6">
                                                                        <label>Opening Stock Price/KG</label>
                                                                        <div class="form-group">
                                                                            <input type="text" class="form-control" name="open_stock_price" id="open_stock_price" value="<?php echo $ingredients_row['price']; ?>" readonly>
                                                                        </div>
                                                                    </div>
                                                                </div>
                                                                
                                                                <div class="row">
                                                                    <div class="col-md-6">
                                                                        <label>New Stock</label>
                                                                        <div class="form-group">
                                                                            <input type="text" class="form-control" name="current_stock" id="current_stock" required>
                                                                        </div>
                                                                    </div>
                                                                    <div class="col-md-6">
                                                                        <label>New Stock Price/KG</label>
                                                                        <div class="form-group">
                                                                            <input type="text" class="form-control" name="current_stock_price" id="current_stock_price" required>
                                                                        </div>
                                                                    </div>
                                                                    
                                                                    <div class="col-md-6">
                                                                        <label>Profit Amount (%)</label>
                                                                        <div class="form-group">
                                                                            <input type="text" class="form-control" name="profit_amt" id="profit_amt" required>
                                                                        </div>
                                                                    </div>
                                                                    
                                                                </div>
                                                                    
                                                                </div>
                                                                <div class="modal-footer">
                                                                    <button type="button" class="btn btn-secondary" data-dismiss="modal">Close</button>
                                                                    <button type="submit" name="stock_update" class="btn btn-primary">Submit</button>
                                                                </div>
                                                          </form>    
                                                        </div>
                                                    </div>
                                                </div>
                                        	    
                                        	    
												<tr>
												    <td><?php echo $i; ?></td>
													<td><?php echo $ingredients_row['spices_name']; ?></td>
													<td><?php echo $ingredients_row['stock_qty']; ?></td>
													<td>£<?php echo number_format($ingredients_row['price'],2); ?></td>
													<td>£<?php echo number_format($ingredients_row['before_stock_value'],2); ?></td>
													<td class="text-right">
														<a class="btn btn-sm btn-info mr-2" href="javascript:void(0)" data-toggle="modal" data-target="#stock_modal_<?php echo $ingredients_row['id']; ?>">
															<i class="fas fa-edit mr-1"></i> Update
														</a>
													</td>
													<td><?php echo $ingredients_row['profit_amt']; ?>%</td>
													<td>£<?php echo number_format($ingredients_row['after_stock_price'],2); ?></td>
													<td>£<?php echo number_format($ingredients_row['after_stock_value'],2); ?></td>
													<td>
													 
													 <?php if($ingredients_row['stock_qty'] >= 2 ) { ?>
													  
													  <span class="badge bg-success-light">In Stock</span>
													  
													 <?php } else { ?>
													 
													   <span class="badge bg-danger-light">Out of Stock</span>
													   
													 <?php } ?>
													    
													</td>
													
												</tr>
												
												<?php } ?>
												
											</tbody>
											
											<tfoot>
											    <th colspan="3">Total</th>
											    <th>£<?php echo number_format($before_stock_price_profit_tot,2); ?></th>
											    <th>£<?php echo number_format($before_stock_value_profit_tot,2); ?></th>
											    <th colspan="2">&nbsp;</th>
											    <th>£<?php echo number_format($after_stock_price_profit_tot,2); ?></th>
											    <th>£<?php echo number_format($after_stock_value_profit_tot,2); ?></th>
											    <th>&nbsp;</th>
											</tfoot>
											
										</table>
									</div>
								</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>

</body>
</html>

${this.title}

Code Editor : stock.php