Server IP : 108.163.255.210 / Your IP : 18.191.223.30 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/public_html/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"); ?>