| Server IP : 108.163.255.210 / Your IP : 18.222.167.85 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();
//check if user i slogin or not. If the user is not login redirect it to login.php
if(!isset($_SESSION["adminuser"]) || $_SESSION["adminuser"]=="")
{
header("Location:login.php");
exit;
}
if ($_SESSION['role_id']=="emp" ){
echo "<script>window.location='../index.php' </script>";
exit();
}
//require database connection file and it's supporting file.
require_once("../include/db.php");
$obj=new query_execution();
$uid=md5(uniqid(rand()));
$var=$_GET['var'];
if($var==NULL)
{
$option="<option value='' disabled selected>Select Branch</option>";
}
else
{
$option="<option value='$var' selected>$var</option>";
}
require_once("header.php");
?>
<script>
$(function() {
$( "#datepicker" ).datepicker();
});
</script>
<script type='text/javascript' src='https://code.jquery.com/jquery-1.11.0.min.js'></script>
<script type='text/javascript'>
$(document).ready(function () {
console.log("HELLO")
function exportTableToCSV($table, filename) {
var $headers = $table.find('tr:has(th)')
,$rows = $table.find('tr:has(td)')
// Temporary delimiter characters unlikely to be typed by keyboard
// This is to avoid accidentally splitting the actual contents
,tmpColDelim = String.fromCharCode(11) // vertical tab character
,tmpRowDelim = String.fromCharCode(0) // null character
// actual delimiter characters for CSV format
,colDelim = '","'
,rowDelim = '"\r\n"';
// Grab text from table into CSV formatted string
var csv = '"';
csv += formatRows($headers.map(grabRow));
csv += rowDelim;
csv += formatRows($rows.map(grabRow)) + '"';
// Data URI
var csvData = 'data:application/csv;charset=utf-8,' + encodeURIComponent(csv);
$(this)
.attr({
'download': filename
,'href': csvData
//,'target' : '_blank' //if you want it to open in a new window
});
//------------------------------------------------------------
// Helper Functions
//------------------------------------------------------------
// Format the output so it has the appropriate delimiters
function formatRows(rows){
return rows.get().join(tmpRowDelim)
.split(tmpRowDelim).join(rowDelim)
.split(tmpColDelim).join(colDelim);
}
// Grab and format a row from the table
function grabRow(i,row){
var $row = $(row);
//for some reason $cols = $row.find('td') || $row.find('th') won't work...
var $cols = $row.find('td');
if(!$cols.length) $cols = $row.find('th');
return $cols.map(grabCol)
.get().join(tmpColDelim);
}
// Grab and format a column from the table
function grabCol(j,col){
var $col = $(col),
$text = $col.text();
return $text.replace('"', '""'); // escape double quotes
}
}
// This must be a hyperlink
$("#export").click(function (event) {
// var outputFile = 'export'
var outputFile = window.prompt("What do you want to name your output file (Note: This won't have any effect on Safari)") || 'export';
outputFile = outputFile.replace('.csv','') + '.csv'
// CSV
exportTableToCSV.apply(this, [$('#dvData>table'), outputFile]);
// IF CSV, don't do event.preventDefault() or return false
// We actually need this to be a typical hyperlink
});
});
</script>
<script language="JavaScript">
function getval(sel) {
var url = sel.value;
var url1="company_report.php?var=";
// get selected value
if (url) { // require a URL
window.location =url1+ url; // redirect
}
return false;
}
function x(){
}
</script>
<link rel="stylesheet" href="//code.jquery.com/ui/1.11.4/themes/smoothness/jquery-ui.css">
<script src="//code.jquery.com/jquery-1.10.2.js"></script>
<script src="//code.jquery.com/ui/1.11.4/jquery-ui.js"></script>
<link rel="stylesheet" href="/resources/demos/style.css">
<script type="text/javascript">
// When the document is ready
$(document).ready(function () {
$('#startDate').datepicker({
format: "mm/yyyy",
viewMode: "months",
minViewMode: "months"
});
});
</script>
<!----header ends-->
<!-- Left side column. contains the logo and sidebar -->
<?php
require_once("left.php");
?>
<!-- Content Wrapper. Contains page content -->
<div class="content-wrapper">
<!-- Content Header (Page header) -->
<section class="content-header">
<h1>Company Report</h1>
<ol class="breadcrumb">
<li><a href="dashboard.php"><i class="fa fa-dashboard"></i> Home</a></li>
<li class="active">Company Report</li>
</ol>
</section>
<!-- Main content -->
<section class="content">
<div class="row">
<div class="col-xs-12">
<div class="box">
<div class="box-header">
<h3 class="box-title">Company Report </h3><?php if($_POST['datee']!=""){?><a href="#" id ="export" role='button' class="btn btn-info pull-right">Company's Sheet
</a> <a href="#" id ="export1" role='button' class="btn btn-info pull-right">Bank's Sheet
</a>
<?Php } ?>
</div><!-- /.box-header -->
<div class="box-body">
<form name="" action="" method="post">
<table class="table table-bordered table-hover">
<tr>
<td>
<?php if($_SESSION['branch']!=""){?>
<input type="hidden" name="company1" value="<?php echo $_SESSION['branch'] ?>" >
<?php } else {?>
<select name="company1" onchange="getval(this);" required class="form-control">
<?php echo $option ;
$sql=mysql_query("select * from companies");
while($f=mysql_fetch_array($sql)){
$compname=$f['name'];
?>
<option value="<?php echo $compname ?>"><?php echo $compname ?></option>
<?php } ?>
</select>
<?php } ?>
</td>
<td><input type="text" name="datee" id="startDate" placeholder="Select Month" class="form-control" /></td>
<td><input type="submit" name="submit" value="Check Details" class="btn btn-info pull-left" /></td>
</tr>
</table>
</form>
<?php
if(isset($_POST['submit']))
{
?>
<!---------------------------------- Company's sheet ends -------------------------------------------->
<div id="dvData" >
<table border="1" style="border:1px solid #000;">
<tr>
<td colspan="27"><h3>REGISTER OF PAYMENT OF WAGES(REVISED)</h3></td>
</tr>
<tr>
<td style="text-align: center;" colspan="27">--</td>
</tr>
<tr>
<td style="font-weight:bold;" colspan="6">NAME OF THE ESTABLISHMENT</td>
<td colspan="21">CONCORD LOGISTICS & SERVICES</td>
</tr>
<tr>
<td style="font-weight:bold;" colspan="6">ADDRESS</td>
<td colspan="21">C/O. DR. LAL PATH LABS, AMRIT NAGAR , OPP. AMBALA CLUB, NEAR INCO CHOWK, OLD DELHI ROAD, AMBALA CITY, AMBALA, HARYANA - 134003</td>
</tr>
<tr>
<td style="font-weight:bold;" colspan="6">WAGE PERIOD</td>
<td colspan="21"><?php echo $_POST['datee']; ?> </td>
</tr>
<tr>
<td style="text-align: center;" colspan="27">--</td>
</tr>
<tr>
<td style="font-weight:bold;">SL</td>
<td style="font-weight:bold;">NAME OF THE WORKER</td>
<td style="font-weight:bold;">NO OF</td>
<td style="font-weight:bold;" colspan="6">RATE OF WAGES</td>
<td style="font-weight:bold;" colspan="6">AMOUNT PAYABLE</td>
<td style="font-weight:bold;" colspan="4">DEDUCTION</td>
<td style="font-weight:bold;">AMOUNT</td>
<td style="font-weight:bold;">SIGNATURE</td>
<td style="font-weight:bold;">Employers</td>
<td style="font-weight:bold;">Employers</td>
<td style="font-weight:bold;">CTC</td>
<td style="font-weight:bold;">ESI NO</td>
<td style="font-weight:bold;">PF NO</td>
<td style="font-weight:bold;">incre</td>
</tr>
<tr>
<td style="font-weight:bold;">NO</td>
<td style="font-weight:bold;">FATHER'S NAME</td>
<td style="font-weight:bold;">DAYS</td>
<td style="font-weight:bold;">BASIC</td>
<td style="font-weight:bold;">HRA</td>
<td style="font-weight:bold;">WASH.</td>
<td style="font-weight:bold;">SPL.</td>
<td style="font-weight:bold;">CONV</td>
<td style="font-weight:bold;">TOTAL</td>
<td style="font-weight:bold;">BASIC</td>
<td style="font-weight:bold;">HRA</td>
<td style="font-weight:bold;">WASH.</td>
<td style="font-weight:bold;">SPL.</td>
<td style="font-weight:bold;">CONV</td>
<td style="font-weight:bold;">TOTAL</td>
<td style="font-weight:bold;text-align: center;">ESI</td>
<td style="font-weight:bold;text-align: center;">PF</td>
<td style="font-weight:bold;text-align: center;">TOTAL</td>
<td style="font-weight:bold;text-align: center;">ADV</td>
<td style="font-weight:bold;text-align: center;">PAID</td>
<td style="font-weight:bold;text-align: center;">OF THE</td>
<td style="font-weight:bold;text-align: center;">ESI</td>
<td style="font-weight:bold;text-align: center;">PF</td>
<td style="text-align: center;">--</td>
<td style="text-align: center;">--</td>
<td style="text-align: center;">--</td>
<td style="text-align: center;">--</td>
</tr>
<tr>
<td style="text-align: center;">--</td>
<td style="font-weight:bold;text-align: center;">DESIGNATION</td>
<td style="text-align: center;" colspan="3">--</td>
<td style="font-weight:bold; text-align: center;">ALLO</td>
<td style="font-weight:bold; text-align: center;">ALLO</td>
<td style="font-weight:bold; text-align: center;">ALLO</td>
<td style="text-align: center;">--</td>
<td style="text-align: center;" colspan="2">--</td>
<td style="font-weight:bold;text-align: center;">ALLO</td>
<td style="font-weight:bold; text-align: center;">ALLO</td>
<td style="font-weight:bold; text-align: center;">ALLO</td>
<td style="text-align: center;">--</td>
<td style="text-align: center;" colspan="3">--</td>
<td style="font-weight:bold;text-align: center;">DED</td>
<td style="text-align: center;">--</td>
<td style="font-weight:bold;text-align: center;">EMPLOYEE</td>
<td style="text-align: center;">--</td>
<td style="text-align: center;">--</td>
<td style="text-align: center;">--</td>
<td style="text-align: center;">--</td>
<td style="text-align: center;">--</td>
<td style="text-align: center;">--</td>
</tr>
<?PHP $im=1;
$cs_da=$_POST['datee'];
$cs_com=$_POST['company1'];
$cs_ne="select * from `attendance` where company='$cs_com' && date1='$cs_da'";
$cs_next=mysql_query($cs_ne);
while($cs_n=mysql_fetch_array($cs_next))
{
$cs_id5=$cs_n['id'];
$cs_company5=$cs_n['company'];
$cs_date5=$cs_n['date1'];
$cs_wd5=$cs_n['wd'];
$cs_wo5=$cs_n['wo'];
$cs_wp5=$cs_n['wp'];
$cs_ot5=$cs_n['ot'];
$cs_pd5=$cs_n['pd'];
$cs_gbpay5=$cs_n['gbpay'];$cs_gbpay55=$cs_gbpay55+$cs_gbpay5;
$cs_hra5=$cs_n['hra'];$cs_hra55=$cs_hra55+$cs_hra5;
$cs_conv5=$cs_n['conv'];$cs_conv55=$cs_conv55+$cs_conv5;
$cs_splallow5=$cs_n['splallow'];$cs_splallow55=$cs_splallow55+$cs_splallow5;
$cs_washallow5=$cs_n['washallow'];$cs_washallow55=$cs_washallow55+$cs_washallow5;
$cs_total5=$cs_n['total'];$cs_total55=$cs_total55+$cs_total5;
$cs_gbpay15=$cs_n['gbpay1'];$cs_gbpay155=$cs_gbpay155+$cs_gbpay15;
$cs_hra15=$cs_n['hra1'];$cs_hra155=$cs_hra155+$cs_hra15;
$cs_conv15=$cs_n['conv1'];$cs_conv155=$cs_conv155+$cs_conv15;
$cs_splallow15=$cs_n['splallow1'];$cs_splallow155=$cs_splallow155+$cs_splallow15;
$cs_washallow15=$cs_n['washallow1'];$cs_washallow155=$cs_washallow155+$cs_washallow15;
$cs_overtime5=$cs_n['overtime'];$cs_overtime55=$cs_overtime55+$cs_overtime5;
$cs_total15=$cs_n['total1'];$cs_total155=$cs_total155+$cs_total15;
$cs_gbpay25=$cs_n['gbpay2'];$cs_gbpay255=$cs_gbpay255+$cs_gbpay25;
$cs_hra25=$cs_n['hra2'];$cs_hra255=$cs_hra255+$cs_hra25;
$cs_conv25=$cs_n['conv2'];$cs_conv255=$cs_conv255+$cs_conv25;
$cs_total25=$cs_n['total2'];$cs_total255=$cs_total255+$cs_total25;
$cs_epf5=$cs_n['epf'];$cs_epf55=$cs_epf55+$cs_epf5;
$cs_esi5=$cs_n['esi'];$cs_esi55=$cs_esi55+$cs_esi5;
$cs_lwf5=$cs_n['lwf'];$cs_lwf55=$cs_lwf55+$cs_lwf5;
$cs_canteen5=$cs_n['canteen'];$cs_canteen55=$cs_canteen55+$cs_canteen5;
$cs_total35=$cs_n['total3'];$cs_total355=$cs_total355+$cs_total35;
$cs_net5=$cs_n['net'];$cs_net55=$cs_net55+$cs_net5;
$cs_pd5=$cs_n['pd'];$cs_pd55=$cs_pd55+$cs_pd5;
$cs_employer_pf=$cs_n['employer_pf'];$cs_employer_pf5=$cs_employer_pf5+$cs_employer_pf;
$cs_employer_esi=$cs_n['employer_esi'];$cs_employer_esi5=$cs_employer_esi5+$cs_employer_esi;
$cs_ctc=$cs_n['ctc'];$cs_ctc5=$cs_ctc5+$cs_ctc;
$cs_fetch=mysql_query("select * from employee where company='$cs_company5' && id='$cs_id5'");
$cs_fe=mysql_fetch_array($cs_fetch);
$cs_sno=$cs_fe['sno'];
$cs_name=$cs_fe['name'];
$cs_id=$cs_fe['id'];
$cs_fname=$cs_fe['fname'];
$cs_pf=$cs_fe['pf'];
$cs_esi=$cs_fe['esi'];
$cs_pca=$cs_fe['pca'];
$cs_doj=$cs_fe['d_o_J'];
$cs_coo=$cs_fe['company'];
$cs_designation=$cs_fe['designation'];
$cs_checking_adjst=mysql_query("select * from leave_management where uid='$cs_id5' && month='$cs_da'");
$cs_ca=mysql_fetch_array($cs_checking_adjst);
$cs_tca=$cs_ca['number']+$cs_tca;
if($cs_tca>0)
{
$cs_class="block";
}
else
{
$cs_class="none";
}
?>
<tr>
<td style="text-align: center;" colspan="27">--</td>
</tr>
<tr>
<td style="text-align: center;">--</td>
<td style=""><?php echo $cs_name; ?>
</td>
<td style="text-align: center;" colspan="25">--</td>
</tr>
<tr>
<td style="text-align: center;"><?php echo $im; $im=$im+1;?></td>
<td style=""><?php echo $cs_fname; ?> </td>
<td style="text-align: center;"><?php echo $cs_pd5; ?></td>
<td style="text-align: center;"><?php echo $cs_gbpay5; ?></td>
<td style="text-align: center;"><?PHP echo $cs_hra5; ?></td>
<td style="text-align: center;"><?PHP echo $cs_washallow5; ?></td>
<td style="text-align: center;"><?PHP echo $cs_splallow5; ?></td>
<td style="text-align: center;"><?PHP echo $cs_conv5; ?></td>
<td style="text-align: center;"><?php echo $cs_total5; ?></td>
<td style="text-align: center;"><?php echo $cs_gbpay15; ?></td>
<td style="text-align: center;"><?PHP echo $cs_hra15; ?></td>
<td style="text-align: center;"><?PHP echo $cs_washallow15; ?></td>
<td style="text-align: center;"><?PHP echo $cs_splallow15; ?></td>
<td style="text-align: center;"><?PHP echo $cs_conv15; ?></td>
<td style="text-align: center;"><?php echo $cs_total15; ?></td>
<td style="text-align: center;"><?php echo $cs_esi5; ?></td>
<td style="text-align: center;"><?php echo $cs_epf5; ?></td>
<td style="text-align: center;"><?php echo $cs_total35 ?></td>
<td style="text-align: center;">0</td>
<td style="text-align: center;"><?php echo $cs_net5; ?></td>
<td style="text-align: center;">---</td>
<td style="text-align: center;"><?php echo $cs_employer_esi; ?></td>
<td style="text-align: center;"><?php echo $cs_employer_pf; ?></td>
<td style="text-align: center;"><?php echo $cs_ctc; ?></td>
<td style="text-align: center;"><?php echo $cs_pf; ?></td>
<td style="text-align: center;"><?php echo $cs_esi; ?></td>
<td style="text-align: center;">--</td>
</tr>
<tr>
<td style="text-align: center;">--</td>
<td style=""><?php echo $cs_designation; ?></td>
<td style="text-align: center;" colspan="25">--</td>
</tr>
<tr>
<td style="text-align: center;" colspan="27">--</td>
</tr>
<tr>
<td style="text-align: center;" colspan="27">--</td>
</tr>
<tr>
<?php } ?>
<td style="font-weight:bold;text-align: center;">--</td>
<td style="font-weight:bold;text-align: center;">--</td>
<td style="font-weight:bold;text-align: center;">--</td>
<td style="font-weight:bold;text-align: center;"><?php echo $cs_gbpay55; ?></td>
<td style="font-weight:bold;text-align: center;"><?php echo $cs_hra55; ?></td>
<td style="font-weight:bold;text-align: center;"><?php echo $cs_washallow55; ?></td>
<td style="font-weight:bold;text-align: center;"><?php echo $cs_splallow55; ?></td>
<td style="font-weight:bold;text-align: center;"><?php echo $cs_conv55; ?></td>
<td style="font-weight:bold;text-align: center;"><?php echo $cs_total55; ?></td>
<td style="font-weight:bold;text-align: center;"><?php echo $cs_gbpay155; ?></td>
<td style="font-weight:bold;text-align: center;"><?php echo $cs_hra155; ?></td>
<td style="font-weight:bold;text-align: center;"><?php echo $cs_washallow155; ?></td>
<td style="font-weight:bold;text-align: center;"><?php echo $cs_splallow155; ?></td>
<td style="font-weight:bold;text-align: center;"><?php echo $cs_conv155; ?></td>
<td style="font-weight:bold;text-align: center;"><?php echo $cs_total155; ?></td>
<td style="font-weight:bold;text-align: center;"><?php echo $cs_esi55; ?></td>
<td style="font-weight:bold;text-align: center;"><?php echo $cs_epf55; ?></td>
<td style="font-weight:bold;text-align: center;"><?php echo $cs_total355; ?></td>
<td style="font-weight:bold;text-align: center;">0</td>
<td style="font-weight:bold;text-align: center;"><?php echo $cs_net55; ?></td>
<td style="text-align: center;">--</td>
<td style="font-weight:bold;text-align: center;">0</td>
<td style="font-weight:bold;text-align: center;">0</td>
<td style="font-weight:bold;text-align: center;">0</td>
<td style="text-align: center;">--</td>
<td style="text-align: center;">--</td>
<td style="text-align: center;">--</td>
</tr>
</table>
</div>
<!---------------------------------- Company's sheet ends -------------------------------------------->
<?php }?>
</div><!-- /.box-body -->
</div><!-- /.box -->
</div><!-- /.col -->
</div><!-- /.row -->
</section><!-- /.content -->
</div><!-- /.content-wrapper -->
<?php
require_once("footer.php");
?>