| Server IP : 108.163.255.210 / Your IP : 3.12.34.96 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
$("#export2").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="bank_slipsheet.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>Bank Report</h1>
<ol class="breadcrumb">
<li><a href="dashboard.php"><i class="fa fa-dashboard"></i> Home</a></li>
<li class="active">Bank 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">Bank Report </h3><?php if($_POST['datee']!=""){?> <a href="#" id ="export2" role='button' class="btn btn-info pull-right">Download CSV
</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">
<option value="All">All</option>
<?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>
<select class="form-control" placeholder="Bank name" name="bank" id="bank" required>
<option value="" >Select Bank Name</option>
<option value="CASH" <?php if($bank=="CASH"){echo "selected"; }?> >CASH</option>
<option value="HDFC" <?php if($bank=="HDFC"){echo "selected"; }?> >HDFC</option>
<option value="SBI" <?php if($bank=="SBI"){echo "selected"; }?>>SBI</option>
<option value="OTHER" <?php if($bank=="OTHER"){echo "selected"; }?>>OTHER</option>
</select>
</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']))
{
?>
<!---------------------------------- Bank's report starts -------------------------------------------->
<div id="dvData" >
<table border="1" style="border:1px solid #000;">
<tr align="center">
<td colspan="4"><h3>CONCORD LOGISTICS & SERVICES</h3></td>
</tr>
<tr align="center">
<td colspan="4">C-4/97/2, SAFDERJUNG DEVELOPMENT AREA NEW DELHI- 110016</td>
</tr>
<tr align="center">
<td colspan="1"><strong>PH:</strong></td>
<td colspan="3">9810010322</td>
</tr>
<tr align="center">
<td colspan="1"><strong>Co. Name :</strong></td>
<td colspan="3">CONCORD LOGISTICS & SERVICES</td>
</tr>
<tr align="center">
<td colspan="1"><strong>Co. Code :</strong></td>
<td colspan="3">3401B</td>
</tr>
<tr align="center">
<td colspan="1"><strong>Month:</strong></td>
<td colspan="3"><?php echo $_POST['datee']; ?></td>
</tr>
<tr align="center">
<td colspan="1"><strong>A/c No.</strong></td>
<td colspan="3">04672560000753</td>
</tr>
<tr align="center">
<td colspan="1"><strong>Date:</strong></td>
<td colspan="3"><?php echo date("d/m/Y"); ?></td>
</tr>
<tr align="center">
<td><strong>Sl.No.</strong></td>
<td><strong>Account No</strong></td>
<td><strong>Salary</strong></td>
<td><strong>Name</strong></td>
</tr>
<?PHP $im1=1;
$br_da=$_POST['datee'];
$br_com=$_POST['company1'];
$br_bank=$_POST['bank'];
if($br_com=='All'){
$br_ne="select * from `attendance` where date1='$br_da' ";
}else{
$br_ne="select * from `attendance` where company='$br_com' && date1='$br_da' ";
}
$br_next=mysql_query($br_ne);
while($br_n=mysql_fetch_array($br_next))
{
$br_id5=$br_n['id'];
$br_company5=$br_n['company'];
$br_date5=$br_n['date1'];
$br_net5=$br_n['net'];
//echo "select * from employee where company='$br_company5' && id='$br_id5' && bank='".$_POST['bank']."'";
$br_fetch=mysql_query("select * from employee where company='$br_company5' && id='$br_id5' && bank='".$_POST['bank']."'");
$br_fe=mysql_fetch_array($br_fetch);
$br_sno=$br_fe['sno'];
$br_name=$br_fe['name'];
$br_bank_no=$br_fe['bank_no'];
if($br_fe['bank']==$_POST['bank'] )
{
?>
<tr align="center">
<td><?php echo $im1; $im1=$im1+1;?></td>
<td><?php echo $br_bank_no; ?></td>
<td><?php echo $br_net5; ?></td>
<td><?php echo $br_name; ?></td>
</tr>
<?php }} ?>
</table>
</div>
<?php } ?>
<!---------------------------------- Bank's report ends -------------------------------------------->
</div><!-- /.box-body -->
</div><!-- /.box -->
</div><!-- /.col -->
</div><!-- /.row -->
</section><!-- /.content -->
</div><!-- /.content-wrapper -->
<?php
require_once("footer.php");
?>