print.php ( File view )

  • By cox 2014-08-14
  • View(s):156
  • Download(s):9
  • Point(s): 2
			<html>
<body>
<background = "../images/lorma.jpg">
<script type="text/javascript">
function printTable(obj) {

content = document.getElementById(obj).innerHTML;
newwin = window.open('');
newwin.document.write('<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"\n',
'"http://www.w3.org/TR/html4/strict.dtd">\n',
'<html>\n',
'<head>\n',
'<title>Print Leave Reports</title>\n',
'<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">\n',
'<link href="../Style.css" rel="stylesheet" type="text/css">\n',
'</head>\n',
'<body>\n',
''+content+'\n',
'</body>\n',
'</html>');
newwin.print();
newwin.close();

}
</script>
<body background ="../images/back.gif" >
<table id="table0" width="1091" border="0" cellpadding="0" cellspacing="0">

<?php
require_once('../dbcon.php');

$query = "SELECT
    employee.eid, employee.fname, employee.lname, leaves.leavetype, leaves.fdate, leaves.edate, leaves.endate, DATEDIFF(endate, edate)
    , leaves.reason, leaves.recommending, leaves.deanstatus FROM ccse.leaves INNER JOIN ccse.employee 
        ON (leaves.eid = employee.eid) WHERE employee.eid='$_GET[id]'";
$result = @mysql_query($query);

if($result){

while($row = mysql_fetch_array($result)){


$d = $row['fdate'];
list($yr, $mon, $day) = explode("-",$d);
require_once('month.php');
$fdate = $mon." ".$day.", ".$yr ;

$e = $row['edate'];
list($yr, $mon2, $day) = explode("-",$e);
require_once('edate.php');
$edate = $mon2." ".$day.", ".$yr ;

$ef = $row['endate'];
list($yr, $mon3, $day) = explode("-",$ef);
require_once('endate.php');
$endate = $mon3." ".$day.", ".$yr ;

echo "</b>";echo"<center>";echo"<b>";
echo "<hr width ='450'>";
echo "The Official Leave Report To Be Filled in Triplicates";echo "<br>";
echo " Nzoia Sugar Company LTD";echo "</b>";
echo"</center>";
echo"<center>"; 
echo"P.o Box 285-50200,BUNGOMA";echo "<br>";
echo "Tel:055-30500 Fax:055-30001";echo "<br>";
echo "Cell:0727477777/0733800500";echo "<br>";
echo "E-mail:md@nzoiasugar.com";echo "<br>";
echo"</center>";

echo "<hr width ='360'>";
echo '<table border=0 cellspacing=2 cellpadding=5 bordercolor=#000000 align=center width="500">
<center>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
<b>Date:</b> '.$fdate.'</center></br></br>

 <center><b>To the NSC Director:</b>I have the honor to request for leave:</center>
<td><b>Empoyee ID:</center></td><td>'.$row[0].'</td></tr>
<td><b>Employee Name:</center></td><td>'.$row[2].' , '.$row[1].'</td></tr>
<td><b>Type of Leave:</center></td><td>'.$row[3].'</td></tr>
<td><b>Effective Date:</center></td><td>'.$edate.' &nbsp;&nbsp;<b>TO</b> &nbsp;&nbsp;'.$endate.'</td></tr>
<td><b>Reason:</center></td><td>'.$row[8].'</td></tr>
<td></td>
<td><br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
___<u>'.$row[2].' , '.$row[1].'_____</u><br>&nbsp;&nbsp;
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
<b>Signature over printed Status</td></tr>
<td><b>Supervisor:</center></td><td>'.$row[10].'</td></tr>
<td></td>
<td>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
________________________</u><br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
<b>Supervisor</td></tr>

<td><b>Head Of Section:</center></td><td>'.$row[9].'</td></tr>
<td></td>
<td>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
________________________</u><br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
<b>Head Of Section</td></tr>

<td><b>Head Of Department:</center></td><td>'.$row[9].'</td></tr>
<td></td>
<td>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
________________________</u><br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
<b>Head Of Department</td></tr>

<td><b>Human Resource Manager:</center></td><td>'.$row[10].'</td></tr>
<td></td>
<td>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
________________________</u><br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<b>Human Resource </td></tr>


</tr>';
	
}
echo '</table>';

mysql_free_result($result);
echo "<hr width ='360'>";

}else{

echo '<p>'.mysql_error().'<br /><br />Query:'.$query.'</p>';

}
mysql_close();

?>
<center>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
<a href ="print-report.php"><img src="../images/cancel.gif " width="50" height="20"></a>&nbsp;&nbsp;&nbsp;
<a href="print-reports.php" onClick="printTable('table0'); return false;">
<img src="../images/print2.gif" width="50" height="20" /></a></center>
<html>
			
...
Expand> <Close

Want complete source code? Download it here

Point(s): 2

Download
0 lines left, continue to read
Sponsored links

File list

Tips: You can preview the content of files by clicking file names^_^
Name Size Date
add-employee.php8.98 kB04-07-14 10:43
add-user.php3.26 kB04-07-14 10:27
approve.php157.00 B07-02-09 04:33
date-added.php496.00 B14-02-09 00:10
db-backup-1371292492-5cac8f65a378cc19b150279db357c567.sql3.23 kB15-06-13 06:34
db-backup-1371360757-5cac8f65a378cc19b150279db357c567.sql3.80 kB16-06-13 01:32
db-backup-1371377572-5cac8f65a378cc19b150279db357c567.sql4.88 kB16-06-13 06:12
db-backup-1402914697-5cac8f65a378cc19b150279db357c567.sql6.12 kB16-06-14 13:31
db_backup.php1.79 kB09-11-08 22:21
del-users.php2.39 kB09-02-09 14:49
delete-employee.php2.51 kB07-02-09 05:11
delete-users.php2.32 kB10-02-09 14:45
del_emp.php2.44 kB07-02-09 05:14
deny.php158.00 B07-02-09 04:33
edate.php499.00 B13-02-09 13:42
edit-user.php2.15 kB14-02-09 00:05
editemp-frm.php3.08 kB30-12-08 15:53
edit_emp.php5.08 kB29-11-08 23:07
emp-list.php6.30 kB04-02-09 14:35
emp-profile.php1.67 kB14-02-09 00:03
endate.php499.00 B13-02-09 13:44
fdate.php487.00 B12-02-09 13:24
footer.html104.00 B18-06-14 18:01
header.html5.94 kB18-06-14 15:10
start.php344.00 B16-12-08 05:35
dwsync.xml286.00 B18-06-14 18:01
index.php2.14 kB25-06-14 15:21
logout.php848.00 B18-06-14 17:45
main-index.php397.00 B16-06-14 13:26
month.php486.00 B11-02-09 07:10
month2.php499.00 B13-02-09 14:59
print-report.php1.17 kB11-02-09 07:07
print.php5.41 kB25-06-14 13:41
search-edit.php3.86 kB17-12-08 06:09
search-edituser.php3.86 kB17-12-08 06:11
search.php3.89 kB15-06-13 12:53
verify-editemp.php561.00 B09-02-09 08:09
verifyedit-user.php454.00 B09-02-09 14:35
view-leave.php3.06 kB17-06-13 04:32
viewedit-employee.php5.72 kB14-02-09 00:15
viewedit-user.php4.38 kB09-02-09 07:03
viewpending-leaves.php2.50 kB15-06-13 12:49
dwsync.xml860.00 B04-07-14 10:43
ccse.sql7.20 kB15-08-13 06:14
date.inc.php589.00 B07-11-08 17:12
dbcon.php467.00 B11-06-14 17:19
dapproved.php184.00 B27-02-09 02:11
ddeny.php191.00 B07-02-09 04:33
emp-profile.php1.66 kB14-02-09 00:02
footer.html104.00 B18-06-14 18:00
header.html6.01 kB18-06-14 17:50
start.php344.00 B08-09-08 13:34
dwsync.xml286.00 B18-06-14 18:00
logout.php848.00 B18-06-14 17:43
main-index.php403.00 B18-06-14 17:58
search.php3.96 kB16-06-13 00:26
view-leave.php1.98 kB16-06-13 01:29
viewpending-leaves.php2.50 kB16-06-13 00:28
dwsync.xml288.00 B18-06-14 17:58
fidfrm.php1.64 kB16-06-13 01:15
approval.jpg1.82 kB01-12-08 06:42
approved.jpg1.87 kB01-12-08 06:40
back.gif7.49 kB15-10-08 20:36
Brain_Mill_Logo_1b-1.gif8.41 kB16-02-09 13:23
cancel.gif2.49 kB11-02-09 00:45
delete.jpg1.61 kB01-12-08 06:43
disapproval.jpg1.99 kB01-12-08 06:42
disapproved.jpg2.07 kB01-12-08 06:42
edit.jpg1.35 kB30-11-08 00:37
exthome.png79.83 kB16-02-09 12:16
login.gif208.73 kB08-02-09 07:34
logo.png106.01 kB16-06-14 13:23
nzoia.jpg425.23 kB15-06-13 15:31
print2.gif2.50 kB31-12-08 03:14
resume.gif3.03 kB30-12-08 15:26
top.gif13.75 kB16-06-14 13:36
view.gif2.52 kB20-12-08 00:06
top.gif.mno113.00 B16-06-14 13:36
footer.html104.00 B16-06-14 12:39
header.html5.76 kB18-06-14 17:51
start.php344.00 B08-09-08 13:34
dwsync.xml286.00 B18-06-14 17:51
index.php2.17 kB19-06-14 10:24
leave.php8.69 kB30-07-14 17:17
logout.php842.00 B18-06-14 17:27
main-index.php380.00 B18-06-14 18:07
mysql_connect.php645.00 B07-11-08 03:55
<NSC>0.00 BSystem.ppt 1940992
Reminder.txt192.00 B12-05-09 07:22
Resume.doc35.50 kB18-06-13 00:14
search.php3.50 kB16-06-13 01:21
setid.php1.31 kB21-02-09 08:21
view-availableleave.php1.41 kB07-02-09 04:59
view-leave.php1.67 kB20-02-09 15:51
viewpending-leaves.php2.19 kB16-06-13 01:17
dwsync.xml621.00 B30-07-14 17:17
<_notes>0.00 B09-08-14 11:29
<_notes>0.00 B09-08-14 11:29
<includes>0.00 B09-08-14 11:29
<New>0.00 B0% 15-06-13
<_notes>0.00 B09-08-14 11:29
<includes>0.00 B09-08-14 11:29
<_notes>0.00 B09-08-14 11:29
<_notes>0.00 B09-08-14 11:29
<_notes>0.00 B09-08-14 11:29
<admin>0.00 B09-08-14 11:29
<database>0.00 B09-08-14 11:29
<director>0.00 B09-08-14 11:29
<images>0.00 B09-08-14 11:29
<includes>0.00 B09-08-14 11:29
<presentation>0.00 B09-08-14 11:29
<resume>0.00 B09-08-14 11:29
<sick-leave>0.00 B28-04-09 00:20
<_notes>0.00 B09-08-14 11:29
<OnlineLeaveSystem>0.00 B09-08-14 11:29
...
Sponsored links

print.php (931.49 kB)

Need 2 point
Your Point(s)

Your Point isn't enough.

Get point immediately by PayPal

More(Debit card / Credit card / PayPal Credit / Online Banking)

Submit your source codes. Get more point

LOGIN

Don't have an account? Register now
Need any help?
Mail to: support@codeforge.com

切换到中文版?

CodeForge Chinese Version
CodeForge English Version

Where are you going?

^_^"Oops ...

Sorry!This guy is mysterious, its blog hasn't been opened, try another, please!
OK

Warm tip!

CodeForge to FavoriteFavorite by Ctrl+D