| Server IP : 108.163.255.210 / Your IP : 3.145.103.119 Web Server : Apache System : Linux blossom.urlnameserver.com 3.10.0-1160.80.1.el7.x86_64 #1 SMP Tue Nov 8 15:48:59 UTC 2022 x86_64 User : ( 1172) PHP Version : 7.2.34 Disable Function : eval,escapeshellarg,proc_close,proc_get_status,proc_nice,proc_open,symlink,system,pcntl_exec,getrusage,chown,chgp,closelog,openlog,syslog,define_syslog_variables,php_ini_loaded_file,getservbyname,getservbyport,posix_getgid,posix_getgrgid,proc_terminate,pfsockopen,apache_child_terminate,posix_mkfifo,posix_setpgid,posix_setuid,hypot,pg_host,pos,posix_access,posix_getcwd,posix_getservbyname,myshellexec,getpid,posix_getsid,posix_isatty,posix_kill,posix_mknod,posix_setgid,posix_setsid,posix_setuid,posix_times,posix_uname,ps_fill,posix_getpwuid,global,ini_restore,zip_open,zip_read,rar_open,bzopen,bzread,bzwrite,apache_get_modules,apache_get_version,phpversionphpinfo,php_ini_scanned_files,get_current_user,disk_total_space,diskfreespace,leak,imap_list,hypo,filedump,safe_mode,getmygid,apache_getenv,apache_setenv,bzread,bzwrite,bzopen,phpini,higlight_file,dos_conv,get_cwd,er_log,cmd,e_name,vdir,get_dir,only_read,ftok,ftpexec,posix_getpwnam,mysql_list_dbs,disk_free_space,session_save_path,confirm_phpdoc_compiled,zip_entry_rea,php_u,psockopen,crack_opendict,crack_getlastmessage,crack_closedict,crack_check,fpassthru,posix_get_last_error,posix_getlogin,posix_getgroups,posix_strerror,posix_getrlimit,posix_getpgrp,posix_getgrnam,pos,dl MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : ON | Sudo : ON | Pkexec : ON Directory : /home/unilinki/www/payroll/admin/ |
Upload File : |
<?php
session_start();
include("../include/db.php");
if($_POST['smt1']='smt1')
{
if($_SESSION['branch']!='')
{
$id=$_SESSION['admin_id'];
$comp=$_SESSION['branch'];
}else{
$comp=$_POST['comp'];
$id=$_POST['emp'];
}
$month=$_POST['month'];
$sal=mysql_query("select * from attendance where id='$id' && date1='$month' && company='$comp'");
$num=mysql_num_rows($sal);
if($num != 1)
{
echo "<center><p style='margin-top:300px;'><b>Sorry! No record found for this month</b></center></p>";
exit();
}
$n=mysql_fetch_array($sal);
$id5=$n['id'];
$company5=$n['company'];
$date5=$n['date1'];
$adj_check=mysql_query("select * from leave_management where uid='$id5' && month='$date5'");
while($ac=mysql_fetch_array($adj_check))
{
$number=$ac['number']+$number;
}
$wd5=$n['wd'];
$wo5=$n['wo'];
$wp5=$n['wp'];
$ot5=$n['ot'];
$gbpay5=$n['gbpay'];
$hra5=$n['hra'];
$conv5=$n['conv'];
$total5=$n['total'];
$gbpay15=$n['gbpay1'];
$hra15=$n['hra1'];
$conv15=$n['conv1'];
$overtime5=$n['overtime'];
$total15=$n['total1'];
$gbpay25=$n['gbpay2'];
$hra25=$n['hra2'];
$conv25=$n['conv2'];
$total25=$n['total2'];
$epf5=$n['epf'];
$esi5=$n['esi'];
$lwf5=$n['lwf'];
$canteen5=$n['canteen'];
$total35=$n['total3'];
$net5=$n['net'];
$pd5=$n['pd'];
$total51=$total5+$total51;
$total151=$total15+$total151;
$total251=$total25+$total251;
$total351=$total35+$total351;
$net51=$net5+$net51;
$fetch=mysql_query("select * from employee where company='$company5' && id='$id5'");
$fe=mysql_fetch_array($fetch);
$sno=$fe['sno'];
$name=$fe['name'];
$id=$fe['id'];
$fname=$fe['fname'];
$pf=$fe['pf'];
$esi=$fe['esi'];
$pca=$fe['pca'];
$doj=$fe['d_o_J'];
$coo=$fe['company'];
}
$disp_month=explode("/",$n['date1']);
if($disp_month[0]=='01'){
$mon="January";
}elseif($disp_month[0]=='02'){
$mon="February";
}elseif($disp_month[0]=='03'){
$mon="March";
}elseif($disp_month[0]=='04'){
$mon="April";
}elseif($disp_month[0]=='05'){
$mon="May";
}elseif($disp_month[0]=='06'){
$mon="June";
}elseif($disp_month[0]=='07'){
$mon="July";
}elseif($disp_month[0]=='08'){
$mon="August";
}elseif($disp_month[0]=='09'){
$mon="September";
}elseif($disp_month[0]=='10'){
$mon="October";
}elseif($disp_month[0]=='11'){
$mon="November";
}elseif($disp_month[0]=='12'){
$mon="December";
}
?>
<!DOCTYPE Html>
<html>
<head>
<script type="text/javascript" src="http://jqueryjs.googlecode.com/files/jquery-1.3.1.min.js" > </script>
<script type="text/javascript">
function printData()
{
var printContent = document.getElementById("mydiv");
var windowUrl = 'about:blank';
var num;
var uniqueName = new Date();
var windowName = 'Print' + uniqueName.getTime();
var printWindow = window.open(num, windowName, 'left=50000,top=50000,width=0,height=0');
var cssReference = printWindow.document.createElement("link")
cssReference.href = "CSSFileName.css"; //include real path like "CSS/CSSFileName.css"
cssReference.rel = "stylesheet";
cssReference.type = "text/css";
printWindow.document.write(printContent.outerHTML);
printWindow.document.getElementsByTagName('head')[0].appendChild(cssReference);
printWindow.document.close();
printWindow.focus();
printWindow.print();
printWindow.close();
}
</script>
<script src="http://mrrio.github.io/jsPDF/dist/jspdf.debug.js"></script>
<script>
function demoFromHTML() {
var pdf = new jsPDF('p', 'pt', 'letter');
// source can be HTML-formatted string, or a reference
// to an actual DOM element from which the text will be scraped.
source = $('#new')[0];
// we support special element handlers. Register them with jQuery-style
// ID selector for either ID or node name. ("#iAmID", "div", "span" etc.)
// There is no support for any other type of selectors
// (class, of compound) at this time.
specialElementHandlers = {
// element with id of "bypass" - jQuery style selector
'#bypassme': function (element, renderer) {
// true = "handled elsewhere, bypass text extraction"
return true
}
};
margins = {
top: 80,
bottom: 60,
left: 40,
width: 1200
};
// all coords and widths are in jsPDF instance's declared units
// 'inches' in this case
pdf.fromHTML(
source, // HTML string or DOM elem ref.
margins.left, // x coord
margins.top, { // y coord
'width': margins.width, // max width of content on PDF
'elementHandlers': specialElementHandlers
},
function (dispose) {
// dispose: object with X, Y of the last line add to the PDF
// this allow the insertion of new lines after html
pdf.save('BAS.pdf');
}, margins);
}
</script>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>Salary Slip</title>
<link href='https://fonts.googleapis.com/css?family=Open+Sans:400,700' rel='stylesheet' type='text/css'>
<style>
body{
padding: 0px;
font-size: 15px;
font-family: 'Open Sans', sans-serif;
font-weight:400;
}
.align-center{
text-align:center;
}
.margin{
margin-top:5px;
margin-bottom:0px;
}
h2{margin-top:20px !important;}
.table-heading{
font-weight:700;
text-align:left;
}
span{font-size: 10px;
font-family: 'Open Sans', sans-serif;}
.text-left{text-align:left;}
.text-right{text-align:right;}
.float-left{float:left; border-left:1px solid #000; border-top:1px solid #000}
.float-right{float:left; border-right:1px solid #000; border-top:1px solid #000}
.table-left{margin-left:5%;}
.table-left1{border:1px solid #000 }
.table-left2{border:1px solid #000; }
.table-left3{float:left; border-left:1px solid #000; border-right:1px solid #000; border-bottom:1px solid #000; }
.table-right{margin-right:5%;}
.margintop{margin-top: 20px;}
.clearfix{clear: both;}
.width30{width:33%;float:left;font-weight:bold;}
.padding10{padding:0 5%;}
.padding101{padding-left:10px;}
.salinhand{
padding-top:10px;
}
</style>
</head>
<body>
<input type="button" class="btn btn-info " name="print" onclick="printData()" value="Print" />
<div id="mydiv">
<div id="new">
<!--<h2 class="align-center margin">CONCORD LOGISTICS & SERVICES</h2>
<h5 class="align-center margin">5E/1, 3RD FLOOR, RISHI SADAN JUNGI HOUSE , SHAHPURJAT , NEW DELHI- 110049</h5>-->
<table cellpadding="0" cellspacing="0" border="0" class="" width="100%">
<tr><td colspan="2" valign="top" align="center"><img src="dist/img/salery_logo.jpg" alt="" /></td></tr>
<tr><td align="center" valign="top" colspan="2"><h3 class="align-center margin">Payslip for the month of <?php echo $mon; ?> <?php echo $disp_month[1]; ?></h3> </td></tr>
<tr>
<td valign="top">
<div class="margintop">
<table cellpadding="0" cellspacing="0" border="0" class="float-left " width="100%">
<tr>
<td class="table-heading padding101">Emp Code :</td>
<td class="text-left"><span id="emp_id"><?php echo $fe['emp_id']; ?></span></td>
</tr>
<tr class="table-heading">
<td class="table-heading padding101">Emp Name :</td>
<td class="text-left"><span id="emp_name"><?php echo $name; ?></span></td>
</tr>
<tr class="table-heading">
<td class="table-heading padding101">Designation :</th>
<td class="text-left"><span id="emp_designation"><?php echo $fe['designation']; ?></span></td>
</tr>
<tr class="table-heading">
<td class="table-heading padding101">Department :</td>
<td class="text-left"><span id="emp_department"><?php echo $fe['company']; ?>,<?php echo $fe['area']; ?></span></td>
</tr>
</table>
</div>
</td>
<td valign="top">
<div class="margintop">
<table cellpadding="0" cellspacing="0" border="0" class="float-right" width="100%">
<tr>
<td class="table-heading padding101">PF No. :</td>
<td class="text-left"><span id="emp_pf"><?php echo $pf; ?></span></td>
</tr>
<tr class="table-heading">
<td class="table-heading padding101">ESI No. :</td>
<td class="text-left"><span id="emp_esi"><?php echo $esi; ?></span></td>
</tr>
<tr class="table-heading">
<td class="table-heading padding101">Mode of Pay :</td>
<td class="text-left"><span id="emp_pay"><?php echo $fe['bank']; ?></span></td>
</tr>
<tr class="table-heading">
<td class="table-heading padding101">No. OF Days :</td>
<td class="text-left"><span id="emp_days"><?php echo $n['pd']; ?></span></td>
</tr>
</table>
</div>
</td>
</tr>
<div class="clearfix"></div>
<br/>
<tr>
<td>
<table cellpadding="0" cellspacing="1" class="table-left1 tablesalart" width="100%">
<tr><td colspan="2" class="padding101">Earnings</td>
</tr>
<tr>
<td class="padding101"><strong>Particulars</strong></td>
<td class="padding101" align="center"><strong>Amount (Rs)</strong></td>
</tr>
<tr>
<td class="padding101">Basic Salary</td>
<td align="center"><?php echo $n['gbpay1']; ?></td>
</tr>
<tr>
<td class="padding101">House Rent Allowance</td>
<td align="center"><?php echo $n['hra1']; ?></td>
</tr>
<tr>
<td class="padding101">Conveyance Allowance</td>
<td align="center"><?php echo $n['conv1']; ?></td>
</tr>
<tr>
<td class="padding101">Washing Allowance</td>
<td align="center"><?php echo $n['washallow1']; ?></td>
</tr>
<tr>
<td class="padding101">Special Allowance</td>
<td align="center"><?php echo $n['splallow1']; ?></td>
</tr>
<tr>
<td class="padding101">DA</td>
<td align="center"><?php echo $n['da1']; ?></td>
</tr>
<tr>
<td class="padding101">Employers EPF Share</td>
<td align="center"><?php echo $n['employer_pf']; ?></td>
</tr>
<tr>
<td class="padding101">Employers ESI Share</td>
<td align="center"><?php echo $n['employer_esi']; ?></td>
</tr>
<tr>
<td class="padding101">Reimbursement</td>
<td align="center"><?php echo $n['overtime']; ?></td>
</tr>
</table>
</td>
<td valign="top">
<table cellpadding="0" cellspacing="1" class="table-left1 tablesalart" width="100%">
<tr>
<td class="padding101"><strong>Deductions</strong></td>
<td align="center" class="padding101" ><strong>Amount (Rs)</strong></td>
</tr>
<tr>
<td class="padding101">EPF Scheme</td>
<td align="center"><?php echo $n['epf']; ?></td>
</tr>
<tr>
<td class="padding101">ESI Scheme</td>
<td align="center"><?php echo $n['esi']; ?></td>
</tr>
<tr><td colspan="2"> </td></tr>
<tr><td colspan="2"> </td></tr>
<tr><td colspan="2"> </td></tr>
<tr><td colspan="2"> </td></tr>
<tr><td colspan="2"> </td></tr>
<tr><td colspan="2"> </td></tr>
<tr><td colspan="2"> </td></tr>
<tr><td colspan="2"> </td></tr>
</table>
</td>
</tr>
<tr>
<td>
<table cellpadding="0" cellspacing="0" class="tablesalart table-left2" width="100%">
<tr>
<td width="63%" class="padding101"><strong>Total Earnings</strong></td>
<td width="37%" align="center">
<strong>
<?php echo $G2=$n['gbpay1']+$n['hra1']+$n['conv1']+$n['washallow1']+$n['splallow1']+$n['da1']+$n['employer_pf']+$n['employer_esi']+$n['overtime']; ?>
</strong>
</td>
</tr>
</table>
</td>
<td>
<table cellpadding="0" cellspacing="0" class="tablesalart table-left2" width="100%">
<tr>
<td width="63%" class="padding101"><strong>Total Deductions</strong></td>
<td width="37%" align="center"><strong><?php echo $to_ded=$n['epf']+$n['esi']; ?></strong></td>
</tr>
</table>
</td>
</tr>
<tr>
<td colspan="2">
<table cellpadding="0" cellspacing="0" class="tablesalart table-left3" width="100%">
<tr>
<td class="padding101"><strong>Net Salary: Rs. <?php echo $n['net']; ?></strong></td>
</tr>
<tr >
<td class="padding10" colspan="2">This Computer Generated Salary Slip Does Not Require Any Signature.</td>
</tr>
</table>
</td>
<tr>
</table>
</body>
</html>