| Server IP : 108.163.255.210 / Your IP : 18.117.231.160 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 error_reporting(0);
session_start();
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Salary Management System</title>
<link href="dist/css/stylesheet.css" type="text/css" rel="stylesheet" />
<style>
body h1, p, label, table, tr, td, th{
color:#333 !important;
}
label{font-weight:bold;}
table tr td:nth-child(3){border:none;}
table tr td:nth-child(2){text-align:right;}
table tr td:nth-child(5){text-align:right;}
</style>
</head>
<?php
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'];
}
?>
<script type="text/javascript" src="http://jqueryjs.googlecode.com/files/jquery-1.3.1.min.js" > </script>
<script type="text/javascript">
function PrintElem(elem)
{
Popup($(elem).html());
}
function Popup(data)
{
var mywindow = window.open('', 'my div', 'height=400,width=600');
mywindow.document.write('<html><head><title>my div</title>');
/*optional stylesheet*/ //mywindow.document.write('<link rel="stylesheet" href="main.css" type="text/css" />');
mywindow.document.write('</head><body >');
mywindow.document.write(data);
mywindow.document.write('</body></html>');
mywindow.document.close(); // necessary for IE >= 10
mywindow.focus(); // necessary for IE >= 10
mywindow.print();
mywindow.close();
return true;
}
</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>
<body>
<input type="button" class="btn btn-info " name="print" onclick="PrintElem('#mydiv')" value="Print" /> <a href="javascript:demoFromHTML()" class="button"> <input type="button" class="btn btn-info " name="pdf" value="Save PDF" /></a>
<div id="mydiv">
<div id="new">
<table style="width:95%; padding:2px; margin:auto;" id="example1">
<tr>
<th colspan="5"><h1 style="margin:5px;">lorem ipsum</h1></th>
</tr>
<tr>
<th colspan="5">
lorem ipsum lorem ipsumlorem ipsumlorem ipsum<br/>
<span style="font-weight:normal;">Pay Slip for the Month of <?php echo $month ?></span>
</th>
</tr>
<tr>
<td>S. No. </td>
<td><?php echo $sno ?></td>
<td width="100px"> </td>
<th colspan="2">Salary Payable</td>
</tr>
<tr>
<td>Emp. Code</td>
<td><?php echo $id ?></td>
<td width="100px"> </td>
<td>Basic</td>
<td><?php echo $gbpay15 ?></td>
</tr>
<tr>
<td>Emp. Name</td>
<td style="text-align:left;"><?php echo $name ?></td>
<td width="100px"> </td>
<td>HRA</td>
<td><?php echo $hra15 ?></td>
</tr>
<tr>
<td style="border:none;"> </td>
<td style="border:none;"> </td>
<td style="border:none;"> </td>
<td>Conveyance</td>
<td><?php echo $conv15 ?>
</td>
</tr>
<tr>
<td>Days Worked</td>
<td><?php echo $wp5 ?></td>
<td width="100px"> </td>
<td>Others</td>
<td>0</td>
</tr>
<tr>
<td>(CL+PL+Adjusment)</td>
<td><?php echo $number ?></td>
<td width="100px"> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td>Days in Month</td>
<td><?php echo $wd5 ?></td>
<td width="100px"> </td>
<td>Incentive</td>
<td></td>
</tr>
<tr>
<td style="border:none;"> </td>
<td style="border:none;"> </td>
<td style="border:none;"> </td>
<td>Over Time</td>
<td><?php echo $overtime5 ?></td>
</tr>
<tr>
<td style="border:none;"> </td>
<td style="border:none;"> </td>
<td style="border:none;"> </td>
<td>Total Salary Payable</td>
<td><?php echo $total15 ?></td>
</tr>
<tr>
<td style="border:none;"> </td>
<td style="border:none;"> </td>
<td style="border:none;"> </td>
<td style="border:none;"> </td>
<td style="border:none;"> </td>
</tr>
<tr>
<td>Basic</td>
<td><?php echo $gbpay5 ?></td>
<td width="100px"> </td>
<td colspan="2" style="border:none;"> </td>
</tr>
<tr>
<td>HRA</td>
<td><?php echo $hra5 ?></td>
<td width="100px"> </td>
<td colspan="2" style="border:none;"> </td>
</tr>
<tr>
<td>Conveyance</td>
<td><?php echo $conv5 ?></td>
<td width="100px"> </td>
<td colspan="2" style="border:none;"> </td>
</tr>
<tr>
<td>Others</td>
<td>0</td>
<td width="100px"> </td>
<th colspan="2">Total Deduction</th>
</tr>
<tr>
<td>Total</td>
<td><?php echo $total5 ?></td>
<td width="100px"> </td>
<td>ESIC</td>
<td><?php echo $esi5 ?></td>
</tr>
<tr>
<td style="border:none;"> </td>
<td style="border:none;"> </td>
<td width="100px"> </td>
<td>Loan</td>
<td>0</td>
</tr>
<tr>
<th colspan="2">Net Payable</th>
<td width="100px" style="border:none;"> </td>
<td style="border-left:2px solid #999;">Mobile</td>
<td style="text-align:right;">0</td>
</tr>
<tr>
<td>Net Amount</td>
<td><?php echo $net5 ?></td>
<td width="100px"> </td>
<td>Welfare</td>
<td><?php echo $lwf5 ?></td>
</tr>
<tr>
<td style="border:none;"> </td>
<td style="border:none;"> </td>
<td width="100px"> </td>
<td>EMP-PF</td>
<td><?php echo $epf5 ?></td>
</tr>
<tr>
<td style="border:none;"> </td>
<td style="border:none;"> </td>
<td width="100px"> </td>
<td>I-TAX / Advance</td>
<td>0</td>
</tr>
<tr>
<td style="border:none;"> </td>
<td style="border:none;"> </td>
<td width="100px"> </td>
<td>Uniform and Canteen</td>
<td><?php echo $canteen5 ?></td>
</tr>
<tr>
<td style="border:none;"> </td>
<td style="border:none;"> </td>
<td width="100px"> </td>
<td>Total Deduction</td>
<td><?php echo $total35 ?></td>
</tr>
<tr>
<td style="border:none;"> </td>
<td style="border:none;"> </td>
<td style="border:none;"> </td>
<td style="border:none;"> </td>
<td style="border:none;"> </td>
</tr>
<tr>
<th style="border-right:none; text-align:left;">Prepared By :</th>
<td style="border-left:none;"></td>
<td width="100px"> </td>
<th style="border-right:none; text-align:left;">Received By :</th>
<td style="border-left:none;"></td>
</tr>
<tr>
<td style="border:none;"> </td>
<td style="border:none;"> </td>
<td style="border:none;"> </td>
<td style="border:none;"> </td>
<td style="border:none;"> </td>
</tr>
</table>
</div>
</div>
</body>
</html>