0) { $row = mysqli_fetch_assoc($result); $sqlsl=mysqli_query($conn,"SELECT * FROM `ah_item_details` WHERE id='".$item_name."'"); $resl= mysqli_fetch_array($sqlsl); $totalunit = $resl['conversion_rate'] * $qty; $existing_item_id = $row['id']; $existing_qty = (int) $row['opening_stock']; $updated_qty = $existing_qty - $totalunit; // Add purchased quantity to stock $update_item = "UPDATE ah_item_tracking_details SET at_price_unit = '$unit_amt',opening_stock = '$updated_qty' , item_date = NOW() WHERE id = '$existing_item_id'"; mysqli_query($conn, $update_item) or die(mysqli_error($conn)); $addStock = " INSERT INTO stock_transactions (item_id, transaction_type, stock, item_tracking_id, transaction_date) VALUES ('$item_name', 'sale', $qty, '$existing_item_id', CURDATE())"; mysqli_query($conn, $addStock) or die(mysqli_error($conn)); } } } } echo ""; } else { echo "Error: " . mysqli_error($conn); } } ?>
Add Sales Details
Credit
Cash
Select Customer Name
Invoice Number
Invoice Date
" placeholder="" class="form-control">
Dispatch Through
#
Item Name
Unit Detail
Qty.
Unit
Price/Unit
Discount
Tax
Amount
WithTax
WithoutTax
%
Amount
%
1.
Select Item Name
Select
Select
Add Row
Total:
Payment By:
Cash
Cheque
Total:
Upload Images:
Recieved:
Add Description:
Balance:
Save