-
Notifications
You must be signed in to change notification settings - Fork 0
/
create_report.php
133 lines (120 loc) · 3.64 KB
/
create_report.php
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
<?php
session_start();
if (!isset($_SESSION["username"])) {
header("location:login.php");
exit;
}
include "include/connect.php";
include "include/gensettings.php";
$sql = "SELECT * from settings";
$result = mysql_query($sql, $connect) or die("cant execute query!z");
while ($row = mysql_fetch_array($result)) {
$footer_in_table = $row['footer'];
}
if (isset($_POST['op'])) {
$report_type = $_POST['report_type'];
//echo $header;
if ($report_type == "") {
$ok = "Please enter footer name!";
} else {
header('location:report/index1.php?d=1');
echo 'wah';
//$sql="UPDATE settings set footer='$footer'";
//$result=mysql_query($sql,$connect) or die("cant execute query! #1");
//$ok="$footer_in_table change to $footer!";
//$header_title="";
}
}
?>
<!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>
<script type="text/JavaScript">
<!--
function MM_openBrWindow1(theURL,winName,features) { //v2.0
window.open(theURL,winName,features);
}
//-->
</script>
<script src="js/msgbox.js"></script>
<script type="text/javascript">
function disable_false(){
document.form1.create.disable=true
}
</script>
<style type="text/css">
<!--
body,td,th {
font-family: Arial, Helvetica, sans-serif;
font-size: 12px;
}
a:link {
color: #FFCC00;
}
a:visited {
color: #FF9900;
}
a:hover {
color: #FFFF00;
}
a:active {
color: #FFFF00;
}
#Layer2 {position:absolute;
width:200px;
height:115px;
z-index:2;
left: 315px;
top: 114px;
}
-->
</style>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Create report</title>
<link href="css/<?php echo $css; ?>" rel="stylesheet" type="text/css" />
</head>
<body onLoad="
if (document.all) { w = document.body.clientWidth; h = document.body.clientHeight; }
else if (document.layers) { w = window.innerWidth; h = window.innerHeight; }
if (window.moveTo) window.moveTo(w/2,h/1)"onLoad="
if (document.all) { w = document.body.clientWidth; h = document.body.clientHeight; }
else if (document.layers) { w = window.innerWidth; h = window.innerHeight; }
if (window.moveTo) window.moveTo(w/2,h/1)">
<form id="form1" name="form1" method="post" action="create_report.php">
<table width="100%" border="0">
<tr>
<td colspan="2"><?php echo $ok; ?></td>
<td width="6%"> </td>
</tr>
<tr>
<td colspan="3"><strong>Reports of books borrowed </strong>
<hr /></td>
</tr>
<tr>
<td> </td>
<td colspan="2" align="left"> </td>
</tr>
<tr>
<td> </td>
<td colspan="2" align="left"> </td>
</tr>
<tr>
<td width="2%"> </td>
<td colspan="2" align="left"> </td>
</tr>
<tr>
<td> </td>
<td width="92%" align="center">
<input name="op2" type="hidden" id="op2" value="1" />
<input type="button" name="Button" value="Weekly" onclick="MM_openBrWindow1('report/index1.php?d=1','','scrollbars=yes,width=1000,height=800')" class="btn"/>
<input type="button" name="Button3" value="Monthly" onclick="MM_openBrWindow1('report/index1.php?d=2','','scrollbars=yes,width=1000,height=800')" class="btn"/>
<input type="button" name="Submit2" value="Yearly" onclick="MM_openBrWindow1('report/index1.php?d=3','','scrollbars=yes,width=1000,height=800')" class="btn"/>
<input name="button2" type="submit" id="button" value="Cancel" onclick="javascript:window.close();" class="btn"/> </td>
<td>
<input name="op" type="hidden" id="op" value="1" />
</td>
</tr>
</table>
</form>
</body>
</html>