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--
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-expences.php

<head>
    <meta charset="utf-8">
    <meta name="viewport" content="width=device-width,initial-scale=1">
    <?php include("includes/css.php");?>
    <style>
        .modal-body .form-label {
            font-weight: 600;
        }

.viewptdt .form-label {
            font-weight: 600;
        }

.viewptdt label {
            margin-top: 10px;
        }

.form-check-input {
            background-color: var(--bs-bg-level-1);
            border: 1px solid #6163f8;
        }

.form-switch .form-check-input {
            margin-left: -2em;
            margin-right: 5px;
        }

.tbladdt .form-control {
            background-color: #fff !important;
            padding: 8px 0.2rem !important;
            min-width: 45px !important;
        }
    </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">
                   <form action="" method="post" enctype="multipart/form-data"> 
                    <div class="row">
                        <div class="col-12">
                            <div class="portlet">
                                <div class="row portlet-header portlet-header-bordered">
                                         <h3 class="portlet-title">Add EXpences Details</h3>
                                    </div> 
                                </div>
                                <div class="portlet-body">
                                    <div class="row">
                                        <div class="col-md-8">
                                            <div class="row">
                                                <div class="col-md-4 mt-2">
                                                    <select class="form-control" name="exp_cat_id" required>
                                                        <option value="">Select expences category</option>
                                                        <?php $sqlct=mysqli_query($conn,"select * from expenses_category");
                                                        while($resct= mysqli_fetch_array($sqlct)){ ?>
                                                        <option value="<?= $resct['id'];?>"><?= $resct['ename'];?></option>
                                                        <?php } ?>
                                                    </select>
                                                </div>
                                            </div>
                                        </div>
                                        <div class="col-md-4">
                                            <div class="mb-2">
                                                <label class="form-label">Expences No.</label>
                                                <input type="text" name="exp_no" value="" placeholder="Enter expences Number" class="form-control">
                                            </div>
                                            <div class="mb-2">
                                                <label class="form-label">Date</label>
                                                <input type="text" name="exp_date" value="<?= date("Y/m/d");?>" placeholder="" class="form-control">
                                            </div>
                                        </div>
                                    </div>
                                 <hr />
                                <div class="portlet-body table-responsive">
                                    <table id="datatable" class="table table-bordered table-striped table-hover tbladdt">
                                        <thead>
                                            <tr>
                                                <th style="text-align:center;" rowspan="2">#</th>
                                                <th style="text-align:center;" rowspan="2">Item Name</th>
                                                  <th style="text-align:center;" rowspan="2">Qty.</th>
                                                <th style="text-align:center;">Price/Unit</th>
                                                 <th style="text-align:center;" rowspan="2">Amount</th>
                                                <th style="text-align:center;" rowspan="2">Action</th>
                                                </tr>
                                           
                                     </thead>
                                        <tbody id="">
                                            <tr  class="dynamic_field customer_records">
                                                <td class="row-index">1</td>
                                                <td> <input type="text" name="item_name" id="item_name" class="form-control" value="" style="border:0px solid #ccc;border-bottom:1px solid #ccc">
                                               </td>
                                                <td> <input type="number" name="qty[]" id="qty" class="form-control qty" value="1" style="border:0px solid #ccc;border-bottom:1px solid #ccc"></td> 
                                                <td><input type="number" name="unit_amt[]" id="unit_amt" class="form-control unit_amt" style="border:0px solid #ccc;border-bottom:1px solid #ccc"></td>
                                                <td><input type="number" name="ttl_amt[]" id="" class="form-control ttl_amt" style="border:0px solid #ccc;border-bottom:1px solid #ccc"></td>
                                               <td>
                                                    <center> 
                                                        <button name="edit" id="<?= $res['id'];?>" class="btn btn-success edit_data"> <i class="far fa-edit"></i></button>
                                                        <a href="javascript:delete_ptype_by_ID('<?php echo $res['id'] ?>');" class="btn btn-danger shadow btn-xs sharp"><i class="fa fa-trash"></i></a>
                                                    </center>
                                                </td>
                                            </tr>
                                             <tr>
                                        <th colspan="6" style="border: 0px;">
                                            <div class="customer_records_dynamic" style="width:100%"></div>
                                       </th>
                                       </tr>
                                        </tbody>
                                        <tfoot>
                                            <tr>
                                                <td colspan="2"><span class="btn btn-warning extra-fields-customer">Add Row</span></td>
                                                <td colspan="1"><strong>Total:</strong> </td> 
                                                <td class="text-center"> <input type="text" value="" id="" class="form-control total_amt" style="border:0px solid #ccc;border-bottom:1px solid #ccc" readonly></td>
                                                 <td colspan="2" class="text-center"><input type="text" id="total_amt" class="form-control total_amt" style="border:0px solid #ccc;border-bottom:1px solid #ccc" readonly></td>
                                            </tr>

</tfoot>
                                    </table>
                                </div>
                            </div>
                        </div>
                        </div>
                     <div class="row">
                        <div class="mb-1 col-md-4"> <h6 style="margin-top:5px;"><strong>Payment By:</strong></h6>
                            <select class="form-control" name="payment_by">
                                <option>Cash</option>
                                <option>Cheque</option>
                            </select> 
                            <br/>
                            <label>Reference No.</label><input type="text" class="form-control"><br/>
                             <div class="mb-1 col-md-12">
                            <h6 style="margin-top:5px;"><strong>Upload Images:</strong></h6>
                       <input class="form-control" type="file" name="item_img"></div>
                             <div class="mb-1 col-md-12"><h6 style="margin-top:5px;"><strong>Add Description:</strong></h6><br/>
                            <textarea class="form-control" name="desp" rows="1">  </textarea>
                         </div>
                         </div>
                         <div class="mb-1 col-md-5"> </div>
                         <div class="mb-1 col-md-3 ttl-cls"><strong>Total:</strong><br/><input type="text" name="total_amt" id="stotal_amts" class="form-control stotal_amts" style="border:0px solid #ccc;border-bottom:1px solid #ccc"></div> 
                    </div>  
                     <div class="row"> 
                        <div class="mb-1 col-md-9"></div>
                        <div class="mb-1 mt-2 col-md-3">
                            <button class="btn btn-primary btn-lg mb-3" name="psubmit" type="submit"> Save</button>
                        </div>
                    </div>
                  </form>  
                </div>

<?php include("includes/footer.php");?>
            </div>
        </div>
        <?php include("includes/js.php");?>
<script type="text/javascript">
    $(document).ready(function () {
        /*$('.extra-fields-customer').click(function() {
            $('.customer_records').clone().appendTo('.customer_records_dynamic');
            $('.customer_records_dynamic .customer_records').addClass('single remove');
            $('.single .extra-fields-customer').remove();
            $('.single').append('<a href="#" class="remove-field btn-remove-customer">X</a>');
            $('.customer_records_dynamic > .single').attr("class", "remove");

$('.customer_records_dynamic input').each(function() {
                var count = 0;
                $(this).find('.row-index').text(index + 1);
                var fieldname = $(this).attr("name");
                $(this).attr('name', fieldname + count);
                count++;
            });

});
        $(document).on('click', '.remove-field', function(e) {
            $(this).parent('.remove').remove();
            e.preventDefault();
            someFunction();
        });*/

var rowIndex = 1; // Track row index

// Add new row dynamically
    $(".extra-fields-customer").click(function () {
        var $clone = $(".customer_records").first().clone(); // Clone first row

// Update row index
        rowIndex++;
        $clone.find(".row-index").text(rowIndex);

// Reset input values and update `name` attributes properly
        $clone.find("input").each(function () {
            var name = $(this).attr("name");
            if (name) {
                $(this).attr("name", name.replace(/\[\d+\]/, "") + "[" + (rowIndex - 1) + "]");
            }
            $(this).val(""); // Clear cloned input values
        });

// Remove `edit` and `delete` IDs to prevent duplication issues
        $clone.find(".edit_data").removeAttr("id");
        $clone.find(".btn-remove-customer").remove();

// Append remove button
        $clone.append('<td><a href="#" class="remove-field btn btn-danger">X</a></td>');

// Append to the table
        $(".customer_records_dynamic").append($clone);
    });

// Remove row dynamically
    $(document).on("click", ".remove-field", function (e) {
        e.preventDefault();
        $(this).closest("tr").remove();
        updateTotalAmount();
    });
    $("table").on("keyup change", ".qty, .unit_amt", function () {
        var $row = $(this).closest("tr");
        var price = parseFloat($row.find(".unit_amt").val()) || 0;
        var qty = parseFloat($row.find(".qty").val()) || 0;
        var total = price * qty;
        $row.find(".ttl_amt").val(total.toFixed(2));
        //row.find("#httl_amt").val(isNaN(total.toFixed(2)) ? "" : total);
        updateTotalAmount();
    });

// Function to update total amount
    function updateTotalAmount() {
        var sum = 0;
        $(".ttl_amt").each(function () {
            sum += parseFloat($(this).val()) || 0;
        });
        $("#total_amt, #total_amts, #stotal_amts").val(sum.toFixed(2));
    }
    });
/*(function() {
    "use strict";
    $("table").on("keyup", ".qty", function() {
               var totals = 0;
      var row = $(this).closest("tr");
      var price = parseFloat(row.find("#unit_amt").val());
      var qty = parseFloat(row.find("#qty").val());
      var total = price * qty;
      row.find("#ttl_amt").val(isNaN(rtotal) ? "" : total);
      row.find("#httl_amt").val(isNaN(rtotal) ? "" : total);
    });
  })();
(function() {
    $('body').on('keyup', '#received_amount', function(){
      var ramt = $(this).val();  
      var $container = $(this).closest(".container-fluid");
      var prc = $container.find("#stotal_amts").val();
      var total = prc - ramt;
      $("#total_amts").val(isNaN(total) ? "" : total);
    });
  })();
$(document).on("keyup", ".discount,.qty", function() {
    var sum = 0;
    $(".ttl_amt").each(function(){
        sum += +$(this).val();
    });
    $("#total_amt").val(sum);
    $("#total_amts").val(sum);
    $("#stotal_amts").val(sum);
}); 
function someFunction() {
    var sum = 0;
    $(".ttl_amt").each(function(){
        sum += +$(this).val();
    });
    $("#total_amt").val(sum);
    $("#total_amts").val(sum);
    $("#stotal_amts").val(sum);
} 
(function() {
    "use strict";
    $("table").on("change", ".it_id", function() {    
        var row = $(this).closest("tr");
        var it_id=$(this).val();
        $.ajax({
            type:'post',
            url:'get_item_expences.php',
            data:{it_id: it_id},
            dataType:'json',
            success:function(data){
                console.log(data);
                row.find('#unit_amt').val(data.price);
                 row.find('#tax_gst').val(data.tax_rate); 
                 row.find('#ttl_amt').val(data.price); 
                 row.find('#httl_amt').val(data.price); 
             //$('#container').container('show'); 
                 someFunction();
            },
            error:function(){}
        });
    });
  })();

</html>

${this.title}

Code Editor : add-expences.php