Gecko [ www.ilwfwelfarefederation.com ]

Name	Size	Permission
assets	[ DIR ]	drwxr-xr-x
images	[ DIR ]	drwxr-xr-x
includes	[ DIR ]	drwxr-xr-x
1add-new-item.php	17.03 KB	-rw-r--r--
add-delivery-challan.php	10.46 KB	-rw-r--r--
add-estimate.php	23.75 KB	-rw-r--r--
add-expences-category.php	6.73 KB	-rw-r--r--
add-expences-item.php	10.97 KB	-rw-r--r--
add-expences.php	16.81 KB	-rw-r--r--
add-items.csv	28 B	-rw-r--r--
add-new-item.php	18.64 KB	-rw-r--r--
add-new-party.php	10.54 KB	-rw-r--r--
add-new-return.php	21.23 KB	-rw-r--r--
add-new-sale.php	9.53 KB	-rw-r--r--
add-new-vendor.php	10.08 KB	-rw-r--r--
add-parties.csv	38 B	-rw-r--r--
add-party.csv	28 B	-rw-r--r--
add-payment-due.php	11.23 KB	-rw-r--r--
add-payment-in.php	10.74 KB	-rw-r--r--
add-payment-out.php	8.78 KB	-rw-r--r--
add-purchase-detail.php	34.35 KB	-rw-r--r--
add-purchase-order.php	24.45 KB	-rw-r--r--
add-purchase-return.php	21.25 KB	-rw-r--r--
add-sale-detail.php	35.3 KB	-rw-r--r--
add-sale-order.php	10.22 KB	-rw-r--r--
adminer.php	465.43 KB	-rw-r--r--
ajax_add_item.php	785 B	-rw-r--r--
ajax_get_item.php	1.03 KB	-rw-r--r--
ajax_get_item1.php	284 B	-rw-r--r--
ajax_get_tax.php	872 B	-rw-r--r--
all-expences.php	4.89 KB	-rw-r--r--
all-item.php	33.57 KB	-rw-r--r--
all-parties.php	5.48 KB	-rw-r--r--
all-party.php	21.53 KB	-rw-r--r--
all-purchase-list.php	8.28 KB	-rw-r--r--
all-purchase-order.php	12.82 KB	-rw-r--r--
all-sale-invoice.php	30.85 KB	-rw-r--r--
all-sale-list.php	6.47 KB	-rw-r--r--
all-sale-order.php	15.67 KB	-rw-r--r--
all-transactions.php	7.73 KB	-rw-r--r--
all-vendor.php	20.5 KB	-rw-r--r--
balance-sheet.php	22.25 KB	-rw-r--r--
bank-statement.php	4.89 KB	-rw-r--r--
bank-transaction.php	4.97 KB	-rw-r--r--
bill-wise-profits.php	8.73 KB	-rw-r--r--
cash-flow.php	10.94 KB	-rw-r--r--
cash-transaction.php	4.46 KB	-rw-r--r--
convert-purchase-order-detail....	17.64 KB	-rw-r--r--
dashboard.php	117.9 KB	-rw-r--r--
day-book.php	3.78 KB	-rw-r--r--
day_book.php	7.87 KB	-rw-r--r--
delete_delivery_challan.php	288 B	-rw-r--r--
delete_estimate.php	267 B	-rw-r--r--
delete_expct.php	279 B	-rw-r--r--
delete_expences.php	263 B	-rw-r--r--
delete_expitm.php	277 B	-rw-r--r--
delete_item.php	264 B	-rw-r--r--
delete_party.php	258 B	-rw-r--r--
delete_paymin.php	269 B	-rw-r--r--
delete_paymout.php	274 B	-rw-r--r--
delete_primery_unit.php	265 B	-rw-r--r--
delete_purchase.php	270 B	-rw-r--r--
delete_purchase_order.php	284 B	-rw-r--r--
delete_purchase_return.php	281 B	-rw-r--r--
delete_return.php	260 B	-rw-r--r--
delete_sales.php	266 B	-rw-r--r--
delete_sales_item.php	181 B	-rw-r--r--
delete_secd_unit.php	270 B	-rw-r--r--
delete_taxrate.php	257 B	-rw-r--r--
delete_vendor.php	258 B	-rw-r--r--
delivery-challan.php	11.48 KB	-rw-r--r--
discount-report.php	4.81 KB	-rw-r--r--
edit-delivery-challan.php	22.32 KB	-rw-r--r--
edit-estimate.php	22.26 KB	-rw-r--r--
edit-expences-detail.php	19.06 KB	-rw-r--r--
edit-firm.php	7.62 KB	-rw-r--r--
edit-new-return.php	23.71 KB	-rw-r--r--
edit-payment-out.php	6.23 KB	-rw-r--r--
edit-purchase-detail.php	36.19 KB	-rw-r--r--
edit-purchase-order-detail.php	17.66 KB	-rw-r--r--
edit-purchase-return.php	23.69 KB	-rw-r--r--
edit-purchase-return1.php	10.56 KB	-rw-r--r--
edit-sale-detail.php	21.84 KB	-rw-r--r--
edit-sale-order-detail.php	17.72 KB	-rw-r--r--
edit-sale-order.php	10.39 KB	-rw-r--r--
edit_expct.php	293 B	-rw-r--r--
edit_expitm.php	291 B	-rw-r--r--
edit_item.php	616 B	-rw-r--r--
edit_party.php	284 B	-rw-r--r--
edit_paymtin.php	295 B	-rw-r--r--
edit_paymtout.php	299 B	-rw-r--r--
edit_primery_unit.php	288 B	-rw-r--r--
edit_secd_unit.php	290 B	-rw-r--r--
edit_taxrate.php	284 B	-rw-r--r--
edit_vendor.php	284 B	-rw-r--r--
estimate.php	15.65 KB	-rw-r--r--
expense-category-report.php	4.66 KB	-rw-r--r--
expense-item-report.php	5.04 KB	-rw-r--r--
expense-transaction.php	5.6 KB	-rw-r--r--
fetch_orders.php	1.87 KB	-rw-r--r--
fetch_profit_report.php	2.15 KB	-rw-r--r--
fetch_purchase_data.php	2.74 KB	-rw-r--r--
fetch_transactions.php	5.04 KB	-rw-r--r--
fixed-assets-transaction-summa...	6.73 KB	-rw-r--r--
form-number-27EQ.php	4.87 KB	-rw-r--r--
get_balance.php	631 B	-rw-r--r--
get_conversion_rate.php	570 B	-rw-r--r--
get_due_amt.php	654 B	-rw-r--r--
get_due_amt1.php	1.14 KB	-rw-r--r--
get_gst_price.php	503 B	-rw-r--r--
get_item_expences.php	290 B	-rw-r--r--
get_qty.php	793 B	-rw-r--r--
get_unit_price.php	2.17 KB	-rw-r--r--
get_unit_price1.php	441 B	-rw-r--r--
gst-rate-report.php	5.25 KB	-rw-r--r--
gst-report.php	4.99 KB	-rw-r--r--
home.php	1.58 KB	-rw-r--r--
import-item.php	6.11 KB	-rw-r--r--
import-parties.php	5.88 KB	-rw-r--r--
index.php	19.06 KB	-rw-r--r--
invoice-estimate-detail.php	57.5 KB	-rw-r--r--
invoice-sale-detail.php	30.75 KB	-rw-r--r--
invoice.php	30.14 KB	-rw-r--r--
item-detail.php	4.75 KB	-rw-r--r--
item-report-by-party.php	5.74 KB	-rw-r--r--
item-wise-profit-lose.php	6.4 KB	-rw-r--r--
itemwise-discount.php	5.98 KB	-rw-r--r--
logout.php	128 B	-rw-r--r--
low-stock-summary.php	4.31 KB	-rw-r--r--
manage-stocks.php	5.04 KB	-rw-r--r--
other-assets-transaction-summa...	7.18 KB	-rw-r--r--
parties-report-by-item.php	6.68 KB	-rw-r--r--
party-statement.php	24.88 KB	-rw-r--r--
party-wise-profit-lose.php	5.42 KB	-rw-r--r--
payment-in.php	21.54 KB	-rw-r--r--
payment-out.php	21.76 KB	-rw-r--r--
primery-units.php	7.97 KB	-rw-r--r--
purchase-return.php	13.37 KB	-rw-r--r--
return.php	13.06 KB	-rw-r--r--
sale-or-purchase-report-by-ite...	4.78 KB	-rw-r--r--
sale-order-item.php	5.48 KB	-rw-r--r--
sale-orders.php	5.95 KB	-rw-r--r--
sale-purchase-by-party-group.p...	4.26 KB	-rw-r--r--
sale-purchase-by-party.php	4.98 KB	-rw-r--r--
secondary-units.php	7.95 KB	-rw-r--r--
sidebar.php	13.08 KB	-rw-r--r--
stock-detail.php	6.22 KB	-rw-r--r--
stock-summary-report-by-item-c...	3.04 KB	-rw-r--r--
stock-summary.php	5.27 KB	-rw-r--r--
tax-rate.php	7.05 KB	-rw-r--r--
tcs-receivable.php	4.86 KB	-rw-r--r--
tds-payable.php	5.09 KB	-rw-r--r--
tds-receivable.php	5.1 KB	-rw-r--r--
trial-balance-report.php	25.47 KB	-rw-r--r--
update_items.php	3.13 KB	-rw-r--r--
update_vendor.php	2.36 KB	-rw-r--r--
view-all-party-transaction-det...	5.64 KB	-rw-r--r--
view-balance-details.php	5.93 KB	-rw-r--r--
view-purchase-detail.php	10.26 KB	-rw-r--r--
view-purchase-order-detail.php	8.29 KB	-rw-r--r--
view-sale-detail.php	9.19 KB	-rw-r--r--
view_item.php	485 B	-rw-r--r--
view_party.php	284 B	-rw-r--r--
view_vendor.php	285 B	-rw-r--r--

Code Editor : add-new-item.php

<?php include("includes/db_config.php");
/*if (isset($_POST['submit'])) {
// var_dump($_FILES);
extract($_POST);
date_default_timezone_set('Asia/Kolkata');
$datetime = date('Y-m-d H:i:s');
if($disc_type=="Percentage"){
$dis_price = $sale_price - ($sale_price * ($disc_sprice / 100));
}elseif($disc_type=="Amount"){
$dis_price = $sale_price - $disc_sprice;    
}else{
$dis_price = $sale_price;    
}
if($tax_rates == "None"){
$total=$dis_price;
}else{
$sqlct=mysqli_query($conn,"select * from tax_rate where id='".$tax_rates."'");
$resct= mysqli_fetch_array($sqlct);
$tax=$resct['tax_gst'];
$tax_rate=filter_var($tax, FILTER_SANITIZE_NUMBER_INT);
$tax=$dis_price*$tax_rate/100;
$total=$dis_price+$tax;
}

$sql="INSERT into ah_item_details(`item_name`, `item_hsn`, `item_code`, `sale_price`, `tax_type`, `disc_sale`, `disc_type`, `wholesale_price`, `wtax`, `min_wqty`, `purchase_price`, `ptax`, `tax_rate`) values ('$item_name','$item_hsn','$item_code','$sale_price','$tax_type','$disc_sale','$disc_type','$wholesale_price','$wtax','$min_wqty','$purchase_price','$ptax','$tax_rate')";
 if  (mysqli_query($conn, $sql)){
     $last_id = mysqli_insert_id($conn);

$sql_item_tracking="INSERT INTO `ah_item_tracking_details`(`item_id`, `opening_stock`, `at_price_unit`, `item_date`, `min_stock_quatity`, `item_location`) VALUES ('$last_id','$opening_stock','$at_price_unit','$item_date','$min_stock_quatity','$item_location')";
     $insert = mysqli_query($conn, $sql_item_tracking);
      if(count($_FILES['item_img']['name']) > 0)  {
            for($i = 0; $i < count($_FILES['item_img']['name']); $i++){
                $tmp_file = $_FILES['item_img']['tmp_name'][$i];
                $ext = pathinfo($_FILES["item_img"]["name"][$i], PATHINFO_EXTENSION);
                $rand = md5(uniqid().rand());
                $upd_image = $rand.".".$ext;
                move_uploaded_file($tmp_file,"images/item/".$upd_image);
    $sql_prd="INSERT into ah_item_images(item_id,image) values ('$last_id','$upd_image')";
    $prd_res=mysqli_query($conn, $sql_prd) or die(mysqli_error());
      }
    }     
     echo "<script>location.replace('all-item.php');</script>";
 }
}*/
if (isset($_POST['submit'])) {
    // Extract POST data securely
    $item_name = $_POST['item_name'] ?? '';
    $item_hsn = $_POST['item_hsn'] ?? '';
    $item_code = $_POST['item_code'] ?? '';
    $sale_price = $_POST['sale_price'] ?? 0;
    $tax_type = $_POST['tax_type'] ?? '';
    $disc_sale = $_POST['disc_sale'] ?? 0;
    $disc_type = $_POST['disc_type'] ?? '';
    $wholesale_price = $_POST['wholesale_price'] ?? 0;
    $wtax = $_POST['wtax'] ?? 0;
    $min_wqty = $_POST['min_wqty'] ?? 0;
    $purchase_price = $_POST['purchase_price'] ?? 0;
    $ptax = $_POST['ptax'] ?? 0;
    $tax_rate = $_POST['tax_rate'] ?? 0;

// Set timezone and get current datetime
    date_default_timezone_set('Asia/Kolkata');
    $datetime = date('Y-m-d H:i:s');

// Prepared statement to insert into `ah_item_details`
    $sql = "INSERT INTO ah_item_details (item_name, item_hsn, item_code, sale_price, tax_type, disc_sale, disc_type, wholesale_price, wtax, min_wqty, purchase_price, ptax, tax_rate) 
            VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)";
    
    $stmt = mysqli_prepare($conn, $sql);
    mysqli_stmt_bind_param($stmt, "sssdsdsddidid", $item_name, $item_hsn, $item_code, $sale_price, $tax_type, $disc_sale, $disc_type, $wholesale_price, $wtax, $min_wqty, $purchase_price, $ptax, $tax_rate);
    
    if (mysqli_stmt_execute($stmt)) {
        $last_id = mysqli_insert_id($conn);
        
        // Insert into `ah_item_tracking_details`
        $opening_stock = $_POST['opening_stock'] ?? 0;
        $at_price_unit = $_POST['at_price_unit'] ?? 0;
        $item_date = $_POST['item_date'] ?? date('Y-m-d');
        $min_stock_quantity = $_POST['min_stock_quatity'] ?? 0;
        $item_location = $_POST['item_location'] ?? '';

$sql_tracking = "INSERT INTO ah_item_tracking_details (item_id, opening_stock, at_price_unit, item_date, min_stock_quatity, item_location) 
                         VALUES (?, ?, ?, ?, ?, ?)";
        
        $stmt_tracking = mysqli_prepare($conn, $sql_tracking);
        mysqli_stmt_bind_param($stmt_tracking, "iddsis", $last_id, $opening_stock, $at_price_unit, $item_date, $min_stock_quantity, $item_location);
        mysqli_stmt_execute($stmt_tracking);

// Redirect
        echo "<script>location.replace('all-item.php');</script>";
    } else {
        echo "Error: " . mysqli_error($conn);
    }

// Close statements
    mysqli_stmt_close($stmt);
    mysqli_stmt_close($stmt_tracking);
    mysqli_close($conn);
}
?>
<!DOCTYPE html>
<html lang="en" dir="ltr" data-theme="light">
<meta http-equiv="content-type" content="text/html;charset=utf-8" />

<head>
    <meta charset="utf-8">
    <meta name="viewport" content="width=device-width,initial-scale=1">
    <?php include("includes/css.php");?>
    <style>
    .modal-dialog {
  max-width: 800px!important;
  margin-right: auto;
  margin-left: auto;
}</style>
</head>

<body class="preload-active aside-active aside-mobile-minimized aside-desktop-maximized">
    <div class="holder">
        <?php include("includes/sidebar.php");?>
        <div class="wrapper">
            <?php include("includes/header.php");?>
            <div class="content">
                <div class="container-fluid g-5">
                    <div class="row">
                        <div class="col-12">
                            <div class="portlet">
                                <div class="portlet-header portlet-header-bordered">
                                    <h3 class="portlet-title">Add New Item</h3>
                                </div>
                                <div class="portlet-body">
                                    <form class="row g-3" action="" method="post" enctype="multipart/form-data">
                                        <div class="mb-3 col-md-6">
                                            <label class="form-label">Item Name</label>
                                            <input type="text" placeholder="Enter Item Name" name="item_name" class="form-control">
                                        </div>
                                        <div class="mb-3 col-md-3">
                                            <label class="form-label">Item HSN/SAC</label>
                                            <input type="text" name="item_hsn" placeholder="Enter Item HSN/SAC" class="form-control">
                                        </div>
                                        <div class="mb-3 col-md-3">
                                            <label class="form-label">Item Code</label>
                                            <input type="text" value="" name="item_code" class="form-control">
                                        </div>
                                       <div class="mb-3 col-md-3">
                                            <label class="form-label">Primary Unit</label>
                                            <select class="form-control puid" name="punit" id="uid">
                                                <option value="">Select</option>
                                                <?php $sql2="SELECT * from primery_unit";
                                                    $exe2=mysqli_query($conn,$sql2);
                                                    while($res2=mysqli_fetch_array($exe2)){ ?>
                                                <option value="<?= $res2['id'];?>" data-wd="<?= $res2['unit']; ?>"><?= $res2['unit'];?>(<?= $res2['short_name'];?>)</option>
                                                <?php } ?>
                                            </select>
                                        </div>
                                        <div class="mb-3 col-md-3">
                                            <label class="form-label">Secondary Unit</label>
                                            <select class="form-control sunit" name="sunit" id="sid">
                                                <option value="">Select</option>
                                            </select>
                                        </div>
                                        <div class="mb-3 col-md-3" id="crate" style="display: none;">
                                            <label class="form-label">Select Conversion Rate</label><br>
                                            <input type="radio" name="ctrate" > 1<span class="punit">  
                                            </span>= <input type="text" value="0.0" name="crate"  class="form-control"><span class="sunits"></span>
                                        </div> 
                                        <hr/>
                                         <div class="portlet-header portlet-header-bordered">
                                            <h3 class="portlet-title">Pricing</h3>
                                        </div>
                                        <div class="row">
                                            <div class="mb-1 col-md-12"><h3 style="font-size:18px;color:blue;">Sale Price</h3></div>
                                        <div class="mb-3 col-md-2">
                                            <label class="form-label">Sale Price</label>
                                            <input type="text" name="sale_price" id="sale_price" class="form-control">
                                        </div>  
                                        <div class="mb-3 col-md-2">
                                             <label class="form-label">Tax Type</label>
                                    <select class="form-control" name="tax_type" id="wtaxs">
                                        <option>Select</option>
                                        <option>With Tax</option>
                                        <option>Without Tax</option>
                                    </select>
                                        </div> 
                                            <div class="mb-3 col-md-2">
                                            <label class="form-label">Disc. On Sale Price</label>
                                            <input type="text" name="disc_sale" class="form-control">
                                        </div>
                                        <div class="mb-3 col-md-1">
                                            <label class="form-label">Disc. Type</label>
                                            <select class="form-control" name="disc_type">
                                                <option value="">Select</option>
                                                <option>Percentage</option>
                                                <option>Amount</option>
                                            </select>
                                        </div> <hr/>
                                            <div class="clearfix"></div>
                                              <div class="row">
                                            <div class="mb-1 col-md-12"><h3 style="font-size:18px;color:blue;">Wholesale Price</h3></div>
                                        <div class="mb-3 col-md-2">
                                            <label class="form-label">Wholesale Price</label>
                                            <input type="text" name="wholesale_price" id="wholesale_price" class="form-control">
                                        </div>  
                                        <div class="mb-3 col-md-2">
                                             <label class="form-label">Tax Type</label>
                                    <select class="form-control" name="wtax" id="wtaxs">
                                        <option>Select</option>
                                        <option>With Tax</option>
                                        <option>Without Tax</option>
                                    </select>
                                        </div> 
                                            <div class="mb-3 col-md-3">
                                            <label class="form-label">Minimum Wholesale Quantity</label>
                                            <input type="text" name="min_wqty" class="form-control">
                                        </div> 
                                            <div class="clearfix"></div>
                                                  <hr/>
                                              <div class="row">
                                            <div class="mb-1 col-md-12"><h3 style="font-size:18px;color:blue;">Purchase Price</h3></div>
                                        <div class="mb-3 col-md-2">
                                            <label class="form-label">Purchase Price</label>
                                            <input type="text" name="purchase_price" id="purchase_price" class="form-control">
                                        </div>  
                                        <div class="mb-3 col-md-2">
                                             <label class="form-label">Tax Type</label>
                                    <select class="form-control" name="ptax" id="ptaxs">
                                        <option>Select</option>
                                        <option>With Tax</option>
                                        <option>Without Tax</option>
                                    </select>
                                        </div> 
                                          <div class="mb-3 col-md-1">
                                            <label class="form-label">Tax Rate</label>
                                            <select class="form-control" name="tax_rate" id="tax_rates">
                                                <option value="">Select</option>
                                                <option value="None">None</option>
                                                <?php $sql2="SELECT * from tax_rate";
                                                    $exe2=mysqli_query($conn,$sql2);
                                                    while($res2=mysqli_fetch_array($exe2)){ ?>
                                                <option value="<?= $res2['id'];?>"><?= $res2['tax_gst'];?></option>
                                                <?php } ?>
                                            </select>
                                        </div> 
                                          
                                        <hr/>
                                        <div class="clearfix"></div>
                                         <div class="portlet-header portlet-header-bordered">
                                            <h3 class="portlet-title">Stock</h3>
                                        </div>
                                        <div class="mb-3 col-md-4">
                                            <label class="form-label">Opening Quantity</label>
                                            <input type="tel" name="opening_stock" placeholder="Opening Quantity" class="form-control">
                                        </div>
                                        <div class="mb-3 col-md-4">
                                            <label class="form-label">At Price/Unit</label>
                                            <input type="text" name="at_price_unit" placeholder="At Price/Unit" class="form-control">
                                        </div>
                                       
                                        <div class="mb-3 col-md-4">
                                            <label class="form-label">Min Stock Maintain</label>
                                            <input type="text" class="form-control" name="min_stock_quatity" value="">
                                        </div> 
                                          <div class="mb-3 col-md-4">
                                            <label class="form-label">Date</label>
                                            <input type="date" placeholder="" name="item_date" class="form-control">
                                        </div>
                                        <div class="mb-3 col-md-4">
                                            <label class="form-label">Item Location</label>
                                            <input type="text" class="form-control" name="item_location" value="">
                                        </div> 
                                        <div class="clearfix"></div>
                                        <div class="col-md-4"><button name="submit" type="submit" class="btn btn-primary btn-lg">Save</button></div>
                                    </form>
                                </div>
                            </div>
                        </div>
                    </div>
                </div>
            </div>
            <?php include("includes/footer.php");?>
        </div>
    </div>
<?php include("includes/js.php");?>
<script>
$(document).ready(function(){
    $('#uid').on('change', function(){
        var uid = $(this).val();
       // alert(cat_id);
        if(uid){
            $.ajax({
                type:'POST',
                url:'ajax_get_item.php',
                data:'uid='+uid,
                success:function(html){
                    $('#sid').html(html);
                   // console.log(html);
                   // $('#city').html('<option value="">Select Division</option>'); 
                }
            }); 
        }
    });
});
 $(document).ready(function(){
    $("#uid").change(function(){
        $("#crate").toggle();
    });
});
 $(function() {
$('body').on('change', '.puid', function() {
   data_uid = $(this).find(':selected').data('wd');
    $(".punit").text(data_uid);
});
}); 
 $(function() {
$('body').on('change', '.sunit', function() {
   data_suid = $(this).find(':selected').data('us');
    $(".sunits").text(data_suid);
});
}); 
 (function() {
    "use strict";
    $("body").on("change", ".tax_gsts", function() {    
        var row = $(this).closest(".container-fluid");
        var gst_id=$(this).val();
        var price = parseFloat(row.find(".sale_price").val());
        $.ajax({
            type:'post',
            url:'get_gsts_price.php',
            data:{gst_id: gst_id , price: price},
            dataType:'json',
            success:function(data){
                console.log(data);
                 row.find('#ttl_amt').val(data.total); 
                 row.find('#ds_amt').val(data.taxs); 
                // row.find('#amount').val(data.taxs); 
                //$('#container').container('show'); 
                 someFunction();
            },
            error:function(){}
        });
    });
  })(); 
    </script>
</body>

</html>

${this.title}

Code Editor : add-new-item.php