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-payment-due.php

<?php include("includes/db_config.php");
error_reporting(E_ALL);
ini_set('display_errors', '1');
if (isset($_POST['add_submit'])) {
extract($_POST);
date_default_timezone_set('Asia/Kolkata');
$datetime = date('Y-m-d H:i:s');
$tmp_file = $_FILES['image']['tmp_name'];
$ext = pathinfo($_FILES["image"]["name"], PATHINFO_EXTENSION);
$rand = md5(uniqid().rand());
$itm_img = $rand.".".$ext;
move_uploaded_file($tmp_file,"images/".$itm_img);
$balance= $total_amt - (int)$received_amount;
$sqlss=mysqli_query($conn,"select * from tbl_ah_items where type ='Sale' And id='".$idd."'");
$resk= mysqli_fetch_array($sqlss);
$balances= (int)$resk['total_amt'] - (int)$_POST['received_amount'];
$ramt= (int)$resk['received_amount'] + (int)$_POST['received_amount'];
$customer_id=$resk['customer_id'];
$sqltk ="UPDATE sale_details SET total_amt='$balances',received_amount='$ramt' WHERE id='$idd'"; 
$restk=mysqli_query($conn,$sqltk) or die(mysqli_error());
$sql="INSERT into ah_sales_payment_in(receipt_no,date,customer_id,total_amount,received_amonut,balance,payment_type,cheque_no,desp,bank_name,transaction_id,opening_balance,as_on,image) values ('$receipt_no','$date','$customer_id','$total_amt','$received_amount','$balance','$payment_type','$cheque_no','$desp','$bank_name','$transaction_id','$opening_balance','$as_on','$itm_img')";
if(mysqli_query($conn, $sql)){
   echo "<script>location.replace('payment-in.php');</script>"; 
  }
}
 ?>
<!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-body .form-label {
            font-weight: 600;
        }

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

.viewptdt label {
            margin-top: 10px;
        }
    </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 row">
                                     <div class="col-md-12">
                                        <h3 class="portlet-title">Add Payment In</h3>
                                    </div>                                 
                                </div>
                                <div class="portlet-body">
                        <?php $idd=$_GET['id'];
                        $sql=mysqli_query($conn,"select * from tbl_ah_items where type ='Sale' And id='".$idd."'");
                        $res= mysqli_fetch_array($sql);
                        $cid=$res['customer_id'];
                        $sqlpt=mysqli_query($conn,"SELECT * from ah_party where id='".$cid."'");
                        $restpy=mysqli_fetch_array($sqlpt); 
                        $sqlfts=mysqli_fetch_array(mysqli_query($conn,"select * from ah_sales_payment_in order by id DESC"));
                        if(!empty($sqlfts['receipt_no'])){
                        $in_no= (int)$sqlfts['receipt_no'];
                        $receipt_no= ++$in_no; }else{
                        $receipt_no='1'; }
                        $query = mysqli_query($conn,"SELECT SUM(total_amt) as ttl FROM sale_details WHERE customer_id = '".$cid."'");
                        $rows = mysqli_fetch_array($query); 
                        $sql_query = mysqli_query($conn,"SELECT SUM(received_amonut) as rttl FROM ah_sales_payment_in WHERE customer_id = '".$cid."'");
                          $row = mysqli_fetch_array($sql_query);
                          if(!empty($row['rttl'])){ 
                          $data= "Bal: ". $rows['ttl'] - $row['rttl'];
                          $bals= $rows['ttl'] - $row['rttl'];
                           }else{
                          $data= "Bal: ". $rows['ttl']; 
                          $bals= $rows['ttl']; } ?>
                        <form action="" method="post" enctype="multipart/form-data">
                                <div class="row">
                                 <div class="mb-3 col-md-4">
                                <label class="form-label">Receipt No.</label>
                                <input type="text" value="<?= $receipt_no; ?>" placeholder="Enter Receipt No." name="receipt_no"  class="form-control" readonly>
                            </div>
                         <div class="mb-3 col-md-4">
                                <label class="form-label">Date</label>
                                <input type="date" placeholder="Choose Date" name="date"  class="form-control">
                            </div>
                            <div class="mb-3 col-md-4">
                                <label class="form-label">Customer Name</label>
                                <input type="text" value="<?= $restpy['party_name'];?>" placeholder="Choose Date" name=""  class="form-control" readonly>
                                <span ><?= $res['total_amt'];?></span>
                            </div>
                            <div class="mb-3 col-md-4">
                                <label class="form-label">Phone No.</label>
                                <input type="tel" placeholder="Enter Phone No." value="<?= $restpy['party_phone_no'];?>" name="phone_no"  class="form-control">
                            </div>
                            <div class="mb-3 col-md-4">
                                <label class="form-label">Recieved Amount(Rs.)</label>
                                <input type="text" placeholder="Enter Amount" name="received_amount"  class="form-control" >
                                 <input type="hidden" value="<?= $res['total_amt']; ?>" name="total_amt"  class="form-control">
                                 <input type="hidden" value="<?= $res['id']; ?>" name="idd" class="form-control">
                               
                            </div>
                           
                            <div class="mb-3 col-md-12">
                                <label class="form-label">Description</label>
                                <textarea type="text" placeholder="Description" name="desp" class="form-control" rows="2"></textarea>
                            </div>
                            <div class="mb-3 col-md-4">
                                <label class="form-label">Payment Type</label>
                                <select class="form-control" name="payment_type" id="type" onchange="yesnoCheck(this);">
                                    <option value="">Select Type</option>
                                    <option value="">Cash</option>
                                    <option value="cheque-no">Cheque No.</option>
                                    <option value="bank-ac">Bank A/c</option>
                                </select>
                            </div>     
                           
                            <div id="bkdt" class="display:none">
                            <div class="mb-3 col-md-4">
                                <label class="form-label">Bank Name</label>
                                <input type="text" placeholder="" name="bank_name"  class="form-control">
                            </div>
                             <div class="mb-3 col-md-4">
                                <label class="form-label">Opening Balance</label>
                                <input type="text" placeholder="" name="opening_balance"  class="form-control">
                            </div> 
                            <div class="mb-3 col-md-4">
                                <label class="form-label"> As On</label>
                                <input type="date" value="" name="as_on" class="form-control">
                            </div>
                            </div>
                            <div class="mb-3 col-md-4" id="ifYes">
                                <label class="form-label">Reference No.</label>
                                <input type="text" placeholder="Enter Reference No." name="transaction_id"  class="form-control">
                            </div>
                            <div class="mb-3 col-md-4">
                                <label class="form-label">Images</label>
                                <input type="file" placeholder="" name="image"  class="form-control">
                            </div> 
                            <div class="clearfix"> </div>
                            <div class="mb-3 col-md-4"> 
                                <button class="btn btn-primary btn-lg" name="add_submit" type="submit">Submit</button>
                            </div>  
                            </div> 
                        </form>
                    </div>
                </div>
            </div>

<?php include("includes/footer.php");?>
        </div>
    </div>
    <?php include("includes/js.php");?>
 <script type="text/javascript">
  /*  function yesnoCheck(that) {
    if (that.value == "cheque-no") {
        document.getElementById("ifYes").style.display = "block";
    }else if (that.value == "bank-ac") {
        document.getElementById("bkdt").style.display = "block";
    }else{
     document.getElementById("ifYes").style.display = "none";
     document.getElementById("bkdt").style.display = "none";   
    }
    }*/
$(function() {
    $('#ifYes').hide(); 
    $('#bkdt').hide(); 
    $('#type').change(function(){
        if($('#type').val() == 'cheque-no') {
            $('#ifYes').show(); 
        } else {
            $('#ifYes').hide(); 
        } 
     if($('#type').val() == 'bank-ac') {
            $('#bkdt').show(); 
        } else {
            $('#bkdt').hide(); 
        } 
    });
});
$(document).ready(function(){
    $('#cidd').on('change', function(){
        var cidd=$(this).val();
        $.ajax({
            type:'post',
            url:'get_due_amt.php',
            data:{cidd: cidd},
            dataType:'json',
            success:function(data){
                console.log(data);
                $('#amt_rm').text(data); 
             //$('#container').container('show'); 
            },
            error:function(){}
        });
    });
  });  
/*$(function(){
      // bind change event to select
      $('#dynamic_select').on('change', function () {
          var url = $(this).val(); // get selected value
          if (url) { // require a URL
              window.location = url; // redirect
          }
          return false;
      });
    });*/
</script>    
</body>

</html>

${this.title}

Code Editor : add-payment-due.php