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
|
<!DOCTYPE html>
<html>
<head>
<?php require_once '../include/head.php'; ?>
<?php require_once '../include/checkuser.php'; ?>
<?php require_once '../include/Nav_bar.php'; ?>
<?php include_once '../include/DBConnect.php'; ?>
<?php require_once '../include/Classes/PHPExcel.php' ?>
<?php require_once '../include/Classes/PHPExcel/IOFactory.php' ?>
<?php require_once '../include/Classes/PHPExcel/Writer/Excel2007.php' ?>
<?php $edit_id = $_GET['id']; ?>
<script>
$(function() {
$('.date-picker').datetimepicker({pickTime: false});
});
</script>
</head>
<body>
<?php
$today = date('Y-m-d');
$paydate = date('Y-m-d');
?>
<!-- line between nav bar and content -->
<div class="text-right">
<ul class="breadcrumb">
<li class="active">Receipt</li>
</ul>
</div>
<!-- line between nav bar and content -->
<div class="container-fluid pathways-container">
<form id="search_form" class="form-inline" action="" method="POST">
<table border="0" class="table table-bordered table-hover table-condensed">
<tr>
<td><h3>View Receipt</h3></td>
</tr>
<?php
$query = "Select receipt_code, receipt_date, receipt_from, payment_of, total_amount, is_cash, bank_name,cheque_code , is_normal, campus_id from receipt where deleted = 0 and receipt_id = '$edit_id'";
$result = $dbh->query($query);
$result->setFetchMode(PDO::FETCH_OBJ);
while ($row = $result->fetch()) {
$receiptNo = $row->receipt_code;
$paydate = $row->receipt_date;
$name = $row->receipt_from;
$money = $row->total_amount;
$payof = $row->payment_of;
$bank_name = $row->bank_name;
$chequeno = $row->cheque_code;
$payway = $row->is_cash;
$type = $row->is_normal;
?>
<tr>
<td width="20%"><label>Type</label></td>
<td><select disabled="" readonly="" name="type">
<option value="0" readonly="">Normal</option>
<option value="1" readonly="">Community Chest</option>
</select></td>
</tr>
<tr>
<td width="20%"><label>Date</label></td>
<td><div class="input-append date-picker">
<input id="start_date" readonly="" class="dateISO" type="text" maxlength="200" data-format="yyyy-MM-dd" name="paydate" value="<?= $today ?>" style="width:90px" required>
</div></td>
</tr>
<tr>
<td width="20%"><label>Receipt from:</label></td>
<td><input readonly="" type="text" value="<?= $name ?>" name="name"></td>
</tr>
<tr>
<td width="20%"><label >The sum of Hong Kong Dollars:</label></td>
<td><input readonly="" type="text" value="<?= $money ?>"name="money"></td>
</tr>
<tr>
<td width="20%"><label>Payment of:</label></td>
<td><input readonly="" type="text" value="<?= $payof ?>" name="payof" style="width: 80%"></td>
</tr>
<tr>
<td width="20%">Pay Type</td>
<td><select disabled="" name ="payway" id="payway" readonly="">
<option <?php if ($payway == 0) { ?> selected="" <?php } ?>value="0" readonly="">By cash</option>
<option <?php if ($payway == 1) { ?> selected="" <?php } ?> value="1" readonly="">By cheque</option>
</select></td>
</tr>
<?php if ($payway == 1) { ?>
<tr>
<td width="20%">Bank Name</td>
<td><input readonly="" type="text" name="bank_name" value="<?= $bank_name ?>"></td>
<tr>
<td width="20%">Cheque Code</td>
<td><input readonly="" type="text" name="chequeno" value="<?= $chequeno ?>"></td>
</tr>
<?php } ?>
</tr>
<tr>
<td width="20%">Campus:</td>
<td><select readonly="" name="campus" required="true" disabled="">
<?php
$query = "Select campus_id,campus_name from campus";
$result = $dbh->query($query);
$result->setFetchMode(PDO::FETCH_OBJ);
while ($row = $result->fetch()) {
if ($row->campus_id == $campus)
print '<option selected value=' . $row->campus_id . '>' . $row->campus_name . '</option>';
if ($row->campus_id != $campus)
print '<option value=' . $row->campus_id . '>' . $row->campus_name . '</option>';
}
?>
</select>
</td>
</tr>
<?php } ?>
</table>
<div class="pathways-inline-block">
<a href="receipt_index.php" class="btn">Back</a>
</div>
<div class="pathways-inline-block">
<a href="receipt_Deleted.php?id=<?= $edit_id ?>" class="btn">Delete</a>
</div>
<div class="pathways-inline-block">
<a href="receipt_Export.php?id=<?= $edit_id ?>" class="btn">Export</a>
</div>
</form>
</div> <!-- /container -->
</body>
</html>
|