| Server IP : 210.245.233.93 / Your IP : 216.73.216.226 Web Server : Apache/2.2.15 (CentOS) System : Linux webserver2.onesolution.com.hk 2.6.32-754.35.1.el6.x86_64 #1 SMP Sat Nov 7 12:42:14 UTC 2020 x86_64 User : apache ( 48) PHP Version : 5.3.3 Disable Function : exec, shell_exec, system, passthru, popen, proc_open, pcntl_exec MySQL : ON | cURL : ON | WGET : ON | Perl : ON | Python : ON | Sudo : ON | Pkexec : ON Directory : /var/www/(Del)pathways.org.hk/MIS20140127/old20140414/Receipt/ |
Upload File : |
<!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'; ?>
<script>
$(function() {
$('.date-picker').datetimepicker({pickTime: false});
$('.stun').select2();
});
</script>
</head>
<?php
$invoice_id;
$startdate = date('Y-m-d');
$enddate = date('Y-m-d');
$today = date('Y-m-d');
?>
<body>
<!-- line between nav bar and content -->
<div class="text-right">
<ul class="breadcrumb">
<li class="active">Receipt</li>
</ul>
</div>
<div class="container-fluid pathways-container">
<div>
<table border="0" width="100%">
<tr>
<td><h2>Receipt</h2></td>
<td><a href="receipt_search.php" class="btn pull-right"><i class="icon-plus"></i> Add</a></td>
</tr>
</table>
</div>
<div class="pathways-search">
<form id="search_form" class="form-inline" action="" method="POST">
<div class="pathways-inline-block">
<label class="">Date</label>
<div class="input-append date-picker">
<input id="start_date" class="dateISO" type="text" maxlength="200" data-format="yyyy-MM-dd" name="startdate" value="<?php
if (isset($_POST['go']))
echo $_POST['startdate'];
else
echo $startdate;
?>" style="width:90px" required>
<span class="add-on">
<i class="icon-calendar" data-date-icon="icon-calendar" data-time-icon="icon-time"></i>
</span>
</div>
<label class="" >To</label>
<div class="input-append date-picker">
<input id="end_date" class="dateISO" type="text" maxlength="200" data-format="yyyy-MM-dd" name="enddate" value="<?php
if (isset($_POST['go']))
echo $_POST['enddate'];
else
echo $enddate;
?>" style="width:90px" required>
<span class="add-on">
<i class="icon-calendar" data-date-icon="icon-calendar" data-time-icon="icon-time"></i>
</span>
</div>
</div>
<div class="pathways-inline-block">
<label>Receipt Code</label>
<select name="searchreceipt" id="receipt" class="stun" style="width:230px">
<option value="ALL"> </option>
<?php $sth = $dbh->query("SELECT `receipt_code` receipt_code,`receipt_id` receipt_id FROM `receipt` WHERE `actived`=1 and`deleted`=0"); ?>
<?php while ($ResultSet = $sth->fetch(PDO::FETCH_ASSOC)) { ?>
<option <?php
if (isset($_POST['go'])) {
if ($_POST['searchreceipt'] == $ResultSet['receipt_id']) {
?> selected <?php
}
}
?>value="<?= $ResultSet['receipt_id']; ?>"><?= $ResultSet['receipt_code'] ?></option>
<?php } ?>
</select>
</div>
<!--div class="pathways-inline-block">
<label>Campus</label>
<select name="searchcampus">
<option value="ALL">ALL</option>
<?php
$query = "Select campus_id,campus_name from campus";
$result = $dbh->query($query);
$result->setFetchMode(PDO::FETCH_OBJ);
while ($row = $result->fetch()) { ?>
<option <?php if(isset($_POST['go'])) {
if ($_POST['searchcampus'] == $row->campus_id) {
?> selected <?php
}
}
?> value="<?=$row->campus_id ?>" ><?=$row->campus_name?></option>';
<?php } ?>
</select>
</div-->
<div class="pathways-inline-block">
<button class="btn" name="go" value="go" style="margin-left:30px" type="submit">Search</button>
</div>
</form>
</div>
<?php
if (isset($_POST['go'])) {
$startdate = $_POST['startdate'];
$enddate = $_POST['enddate'];
$Tdata = false;
$searchBycampus = NULL;
// $searchcampus = $_POST['searchcampus'];
$searchCode = $_POST['searchreceipt'];
/* if($searchcampus != 'ALL'){
$searchBycampus = "campus_id = '$searchcampus' and ";
}*/
?>
<form id="search_form" class="form-inline" action="" method="POST">
<table class="table table-striped table-bordered table-hover table-condensed" id="tablehead">
<thead>
<tr>
<th style="min-width:50px; width:5%"></th>
<th style="min-width:50px; width:5%">Type</th>
<th style="min-width:50px;">Receipt_Code</th>
</tr>
</thead>
<tbody>
<?php
$query = "select receipt_id, receipt_code, is_normal from receipt where deleted = 0 and ". $searchBycampus ."receipt_date between '$startdate' and '$enddate' ";
if ($searchCode != 'ALL') {
$query = "select receipt_id, receipt_code, is_normal from receipt where deleted = 0 and ". $searchBycampus ." receipt_id = '$searchCode'";
}
//$query = "select total_amount, invoice_code, event_code from invoice where deleted = 0 and stu_linking_id = '$studentid' ";
$result = $dbh->query($query);
$result->setFetchMode(PDO::FETCH_OBJ);
while ($row = $result->fetch()) {
$Tdata = true;
?>
<tr>
<td>
<div class="btn-group" data-toggle="buttons">
<a href="receipt_View.php?id=<?= $row->receipt_id ?>" class="btn"><i class="icon-eye-open"></i> View</a>
<!--a href="receipt_Edit.php?id=<?php // $row->receipt_id ?>" class="btn">Edit</a-->
</div>
</td>
<td>
<h5><?php
if ($row->is_normal == 0)
echo 'normal';
else
echo'C C';
?></h5>
</td>
<td>
<h5><?= $row->receipt_code ?></h5>
</td>
</tr>
<?php
}
if ($Tdata == FALSE) {
?>
<tr><td colspan = "5"><h5>No Receipt searched</h5></td></tr>
<?php } ?>
</tbody>
</table>
</form>
<?php } ?>
</div> <!-- /container -->
</body>
</html>