|
Server IP : 103.191.208.50 / Your IP : 216.73.216.53 Web Server : LiteSpeed System : Linux orion.herosite.pro 4.18.0-553.53.1.lve.el8.x86_64 #1 SMP Wed May 28 17:01:02 UTC 2025 x86_64 User : celkcksm ( 1031) PHP Version : 7.4.33 Disable Function : show_source, system, shell_exec, passthru, popen, exec MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : ON Directory (0750) : /home/celkcksm/websites/bengaledu.e-campus.co.in/ |
| [ Home ] | [ C0mmand ] | [ Upload File ] |
|---|
<?php
include ("include/makeSession.php");
include("checksmsbalance.php");
include('include/function.php');
include("include/header.php");
include("include/sidebar.php");
if(isset($_REQUEST['upid']) && $_REQUEST['upid']!=''){
$dovalue="PaySetInstallment";
$doid=$_REQUEST['upid'];
$tableid=$_GET['tableid'];
$upuserresult=mysqli_query($con,"select * from setinstallment where id='".$_REQUEST['upid']."'");
$upuserarr=mysqli_fetch_array($upuserresult);
$nextamount=mysqli_fetch_array(mysqli_query($con,"select amount from setinstallment where id>".$upuserarr['id']."
AND studentid='".$upuserarr['studentid']."' order by id asc limit 1"))['amount'];
if($tableid==0 || $tableid==''){
$upuserresult1=mysqli_query($con,"select * from admission_enquiry_form where student_id='".$upuserarr['studentid']."'");
}
if($tableid==1){
$upuserresult1=mysqli_query($con,"select * from direct_admission where student_id='".$upuserarr['student_id']."'");
}
$upuserarr1=mysqli_fetch_assoc($upuserresult1);
}else{
$dovalue="StudentEnquiryEntry";
$doid='';
}
?>
<div class="content-wrapper">
<!-- Content Header (Page header) -->
<section class="content-header">
<h1> Payment Installment <small></small> </h1>
<ol class="breadcrumb">
<li><a href="#"><i class="fa fa-dashboard"></i> Home</a></li>
<li><a href="#">Payment Installment</a></li>
</ol>
</section>
<!-- Main content -->
<section class="content">
<div class="row">
<div class="col-md-12">
<div class="box box-info">
<div class="box-header">
<h3 class="box-title">Payment Installment <small></small></h3>
<!-- tools box -->
<div class="pull-right box-tools">
<button class="btn btn-info btn-sm" data-widget="collapse" data-toggle="tooltip" title="Collapse"><i class="fa fa-minus"></i></button>
<button class="btn btn-info btn-sm" data-widget="remove" data-toggle="tooltip" title="Remove"><i class="fa fa-times"></i></button>
</div><!-- /. tools -->
</div><!-- /.box-header -->
<div class="box-body pad">
<div class="col-md-12">
<form method="post" action="action1.php" name="addcategory" id="addcategory" enctype="multipart/form-data" role="form">
<input type="hidden" name="do" value="<?php echo $dovalue;?>" />
<input type="hidden" name="doid1" value="<?php echo $doid;?>" />
<input type="hidden" name="tableid" value="0" />
<input type="hidden" name="UserID" value="<?php echo $_SESSION["ecomid"];?>" />
<div class="form-group col-md-6">
<label>Student Id *</label>
<input name="enquiry_id" type="text" placeholder="Installment Date" id="ContentPlaceHolder1_txtStudentName" value="<?php if(isset($_REQUEST['upid'])){ echo $upuserarr['studentid'];}?>" class="form-control" required>
</div>
<div class="form-group col-md-6">
<label>Installment Last Date *</label>
<input name="lastpaymentdate" type="text" placeholder="Installment Date" id="ContentPlaceHolder1_txtStudentName" value="<?php if(isset($_REQUEST['upid'])){ echo $upuserarr['installmentdate'];}?>" readonly class="form-control" required>
</div>
<div class="form-group col-md-6">
<label> Total Amount. *</label>
<input name="totalfee" type="number" maxlength="10" placeholder="Amount" id="ContentPlaceHolder1_txtMobile" value="<?php if(isset($_REQUEST['upid'])){ echo $upuserarr1['totalfee'];}?>" readonly class="form-control" required>
</div>
<?php
$paymemonts=0;
$setinstallmentamount=0;
$fineamont=0;
$dateted = date('m/d/Y');
$idfg=$_REQUEST['upid']-1;
for($i=0; $i<$upuserarr['numberofinstallment']; $i++){
$payment_amountd=mysqli_query($con,"select payment_amount,fine from payinstallment where enquiry_id='".$upuserarr['studentid']."' and installment_id ='".$idfg."' ");
$payment_amountd=mysqli_fetch_array($payment_amountd);
$paymemonts +=$payment_amountd['payment_amount'];
$fineamont +=$payment_amountd['fine'];
$setinstallments=mysqli_query($con,"select amount from setinstallment where studentid='".$upuserarr['studentid']."' and id='".$idfg."' ");
$setinstallments=mysqli_fetch_array($setinstallments);
$setinstallmentamount +=$setinstallments['amount'];
// echo $payment_amountd['payment_amount'];
$idfg--;
}
$finaltotalamount=$fineamont+$setinstallmentamount-$paymemonts;
?>
<div class="form-group col-md-6">
<label>Discount *</label>
<input name="installmentdate" type="text" placeholder="Installment Date" id="ContentPlaceHolder1_txtStudentName" value="<?php if(isset($_REQUEST['upid'])){ echo $upuserarr1['lessdiscount'];}?>" readonly class="form-control" required>
</div>
<div class="form-group col-md-6">
<label>Payment Date *</label>
<input name="payment_date" type="text" placeholder="Installment Date" id="ContentPlaceHolder1_txtStudentName" value="<?php if(isset($_REQUEST['upid'])){ echo date('m/d/Y');}?>" class="form-control" readonly required>
</div>
<?php
$date1 = date('Y-m-d');
// $date2 =$upuserarr['installmentdate'] ;
$date2 =date("Y-m-d", strtotime($upuserarr['installmentdate']));
/// echo $date1."<br>";
// echo $date2."<br>";
if($date1 <= $date2){
?>
<div class="form-group col-md-6">
<label>Fine *</label>
<input name="fine" type="number" placeholder="Fine" value="0" id="ContentPlaceHolder1_txtLastQualification" class="form-control" readonly >
</div>
<?php }else{ ?>
<div class="form-group col-md-6">
<label>Fine *</label>
<input name="fine" type="number" placeholder="Fine" value="<?php if(isset($_REQUEST['upid'])){ echo $upuserarr['latefine'];}?>" id="ContentPlaceHolder1_txtLastQualification" class="form-control" readonly>
<?php $finaltotalamount=$finaltotalamount+$upuserarr['latefine'];
// echo $totalamounts; ?>
</div>
<h3 style='color:red;'>Your Installment Date Complete And Add Fine Next Installment</h3>
<?php } ?>
<div class="form-group col-md-6">
<label> Paid Amount. *</label>
<input type="hidden" id="payment_amount_s" value="<?php if(isset($_REQUEST['upid'])){ echo $upuserarr['amount']+$finaltotalamount;}?>" />
<input type="hidden" id="nextamount" value="<?php if(isset($_REQUEST['upid'])&&!empty($nextamount)){ echo $nextamount;} else echo 0; ?>" />
<input name="payment_amount" type="text" id="payment_amount" placeholder="Amount" value="<?php if(isset($_REQUEST['upid'])){ echo $upuserarr['amount']+$finaltotalamount;}?>"
<?php $setinstallmentsiddesc=mysqli_query($con,"select id from setinstallment where studentid='".$upuserarr['studentid']."' order by id desc limit 1");
$setinstallmentsiddesc=mysqli_fetch_array($setinstallmentsiddesc);
if($setinstallmentsiddesc['id']==$_REQUEST['upid']){
echo "readonly";
}else{
}
?>
class="form-control" required>
</div>
<div class="col-md-6"> <div class="form-group">
<label>Payment Mode :</label>
<select name="payment_mode" required aria-required="true" class="form-control" id="bankpa" >
<option value="">-Select-</option>
<option value="Cash" <?php if($upuserarr['payment_mode']=='Cash'){ echo 'selected';} ?>>Cash</option>
<option value="Cheque" <?php if($upuserarr['payment_mode']=='Cheque'){ echo 'selected';} ?>>Cheque</option>
<option value="Demand Draft" <?php if($upuserarr['payment_mode']=='Demand Draft'){ echo 'selected';} ?>>Demand Draft</option>
<option value="POS" <?php if($upuserarr['payment_mode']=='POS'){ echo 'selected';} ?>>POS</option>
</select> </div>
</div>
<div class="col-md-6" id="bankhide" style="display:none;"> <div class="form-group">
<label>Bank Name:</label>
<input name="bank_name" type="text" class="form-control" id="checkno"
value="<?php if(isset($_REQUEST['upid'])){ echo $upuserarr['bank_name'];}?>" placeholder="Bank Name">
</div>
</div>
<div class="col-md-6" id="checkhide" style="display:none;"> <div class="form-group">
<label>Cheque No :</label>
<input name="checkno" type="text" class="form-control" id="checkno"
value="<?php if(isset($_REQUEST['upid'])){ echo $upuserarr['check_no'];}?>" placeholder="Cheque No">
</div>
</div>
<div class="col-md-6" id="deposithide" style="display:none;"> <div class="form-group">
<label>Deposit To :</label>
<select name="bank" class="form-control subject" id='banknamfdg'>
<option value="NA" class='asde'>-select-</option>
<?php $CasteQuery=mysqli_query($con,"select * from bankdetails");
while($CasteRow=mysqli_fetch_array($CasteQuery)){
echo '<option value="'.$CasteRow['id'].'" '.($upuserarr['bank'] == $CasteRow['id'] ? 'selected="selected"' : '' ).' >'.$CasteRow['bankname'].'</option>';
} ?>
</select>
</div>
</div>
<div class="form-group" id="DdNo">
<label>DD. No</label>
<input type="text" name="DdNo" value="<?php if(isset($_REQUEST['upid']) && $upuserarr['DdNo']>0){ echo $upuserarr['DdNo'];}?>" placeholder="Demand Draft Number" id="ContentPlaceHolder1_txtDdNo" class="form-control">
</div>
<div class="form-group" id="POSTransaction">
<label>POS Transaction </label>
<input type="text" name="POSTransaction" value="<?php if(isset($_REQUEST['upid']) && $upuserarr['POSTransaction']>0){ echo $upuserarr['POSTransaction'];}?>" placeholder="POS Transaction Number" id="ContentPlaceHolder1_txtPOSTransaction" class="form-control">
</div>
<div class="box-footer">
<?php
$upih=$_REQUEST['upid']-1;
$setinstallmentsid=mysqli_query($con,"select * from setinstallment where studentid='".$upuserarr['studentid']."' order by id asc limit 1");
$setinstallmentsid=mysqli_fetch_array($setinstallmentsid);
// echo $setinstallmentsid['id'];
$firstinstallment=mysqli_query($con,"select * from payinstallment where enquiry_id='".$upuserarr['studentid']."'");
$firstinstallment=mysqli_num_rows($firstinstallment);
//print_r($firstinstallment);
// echo $firstinstallment;
if($firstinstallment==0 && $setinstallmentsid['id']==$_REQUEST['upid'] ){ ?>
<input type="submit" class="btn btn-primary" name="ctl00$ContentPlaceHolder1$btnsave" value="Save"/> <input type="reset" name="ctl00$ContentPlaceHolder1$btn_reset" value="Reset" id="ContentPlaceHolder1_btn_reset" class="btn btn-primary">
<?php }else{
$upuserresultfg=mysqli_query($con,"select * from payinstallment where installment_id='".$upih."'");
$upuserarrdd=mysqli_fetch_array($upuserresultfg);
if($upuserarrdd>0){
?>
<input type="submit" class="btn btn-primary" name="ctl00$ContentPlaceHolder1$btnsave" value="Save"/> <input type="reset" name="ctl00$ContentPlaceHolder1$btn_reset" value="Reset" id="ContentPlaceHolder1_btn_reset" class="btn btn-primary">
<?php }else{
echo "<h3 style='color:red; text-align:center;'>Please Pay Previous Installment !</h3>";
} }?>
</div>
</form>
</div>
</div>
</div><!-- /.box -->
</div><!-- /.col-->
</div><!-- ./row -->
</section><!-- /.content -->
</div>
<?php include('include/footer.php');?>
<script>
$(document).ready(function(){
$("#payment_amount").keyup(function(){
if(parseInt(parseInt($("#payment_amount_s").val())+parseInt($("#nextamount").val()))<parseInt($(this).val())){
alert("Value must be <= Current + Next Installment value ( Rs. "+(parseInt($("#payment_amount_s").val())+parseInt($("#nextamount").val()))+" )");
$(this).val($("#payment_amount_s").val());
}
});
$('#bankpa').on('change',function(){
if($('#bankpa').val()=='Cash'){
$('#deposithide').css('display','none');
$('#bankhide').css('display','none');
$('#checkhide').css('display','none');
$('#POSTransaction').css('display','none');
$('#DdNo').css('display','none');
}else if($('#bankpa').val()=='Cheque'){
$('#deposithide').css('display','block');
$('#bankhide').css('display','block');
$('#checkhide').css('display','block');
$('#POSTransaction').css('display','none');
$('#DdNo').css('display','none');
}else if($('#bankpa').val()=='POS'){
$('#deposithide').css('display','none');
$('#bankhide').css('display','none');
$('#checkhide').css('display','none');
$('#POSTransaction').css('display','block');
$('#DdNo').css('display','none');
}else if($('#bankpa').val()=='Demand Draft'){
$('#deposithide').css('display','none');
$('#bankhide').css('display','none');
$('#checkhide').css('display','none');
$('#POSTransaction').css('display','none');
$('#DdNo').css('display','block');
}
});
});
</script>