| 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/hkosl.com/innoutstorage/webadmin/ |
Upload File : |
<?php
require_once("check_login.php");
$_SESSION["index_url_parameter"] = get_index_url_parameter();
if (!isset($_GET["filter1"]) && !isset($_GET["filter2"]) && !isset($_GET["all"])) {
$invoice_info = array();
$filter_sql = " and createdate BETWEEN DATE_SUB(CURRENT_DATE(), INTERVAL 2 WEEK) AND DATE_SUB(CURRENT_DATE(), INTERVAL -1 DAY) ";
$parameters = NULL;
} else {
$filter_sql = "";
if (isset($_GET["all"]) && (int)$_GET["all"] == 1) {
$filter_sql = "";
$parameters = NULL;
} else {
if (isset($_GET["filter1"]) && isset($_GET["filter2"])) {
if ($_GET["filter1"] == 0) { //order_id
$filter_sql = "and invoice.order_id = ?";
}
if ($_GET["filter1"] == 1) { //customer_id
$filter_sql = "and invoice.customer_id = ?";
}
if ($_GET["filter1"] == 2) { //deposit status
$filter_sql = "and invoice.status = ?";
}
$parameters = array($_GET["filter2"]);
}
}
}
$sql = "select *,
invoice.id as invoice_id,
invoice.status as invoice_status,
invoice.code as invoice_code,
invoice.docdate as invoice_docdate,
invoice.duedate as invoice_duedate,
invoice.lastupdate as invoice_lastupdate,
invoice.lastupby as invoice_lastupby
from `invoice` invoice
where invoice.deleted = 0 " . $filter_sql . " order by invoice.id DESC";
$invoice_info = bind_pdo($sql, $parameters, "selectall");
foreach ($invoice_info as $key => $invoice) {
$customer_id = $invoice["customer_id"];
$invoice_info[$key]["customer_id"] = $invoice["customer_id"];
$customer_info = get_customer($customer_id);
$invoice_info[$key]["customer_code"] = $customer_info["code"];
$invoice_info[$key]["customer_name"] = $customer_info["customer_name"];
if (!empty($invoice["order_id"])) {
$order_info = get_order($invoice["order_id"]);
$invoice_info[$key]["order_code"] = $order_info["code"];
$invoice_info[$key]["customer_name"] = $order_info["customer_name"];
}
$invoice_status = get_master_type_code("INVOICE_STATUS", $invoice["invoice_status"]);
if (!empty($invoice_status["name_tc"])) {
$invoice_info[$key]["invoice_status"] = $invoice_status["name_tc"];
} else {
$invoice_info[$key]["invoice_status"] = "";
}
}
$filter_order = "";
$filter_customer = "";
$filter_status = "";
//$all_customer_info = get_customer();
$all_customer_info = get_customer2();
//$all_order_info = get_order(NULL, 0);
$all_order_info = get_order2();
$status_info = get_master_type_code("INVOICE_STATUS");
foreach ($all_customer_info as $key => $customer) {
$filter_customer[$key][0] = $customer["id"];
$filter_customer[$key][1] = $customer['customer_name'] . " (" . $customer["code"] . ")";
}
foreach ($all_order_info as $key => $order) {
$filter_order[$key][0] = $order["id"];
$filter_order[$key][1] = $order["code"];
}
foreach ($status_info as $key => $status) {
$filter_status[$key][0] = $status["code"];
$filter_status[$key][1] = $status["name_tc"];
}
$filter1_info = array("合約", "客戶", "狀態");
$filter2_info = array(0 => $filter_order, 1 => $filter_customer, 2 => $filter_status);
?>
<!DOCTYPE html>
<html>
<head>
<?php require_once("html_head.php"); ?>
<script type="text/javascript" src="js/chosen_v1.4.1/chosen.jquery.min.js"></script>
<link rel="stylesheet" href="js/chosen_v1.4.1/chosen.min.css">
<script type="text/javascript">
$(function () {
$("#filter1").chosen({width: "100px", search_contains: true});
$("#filter2_0").chosen({width: "250px", search_contains: true});
$("#filter2_1").chosen({width: "250px", search_contains: true});
$("#filter2_2").chosen({width: "250px", search_contains: true});
$("#filter2_0_chosen").css("display", "none");
$("#filter2_1_chosen").css("display", "none");
$("#filter2_2_chosen").css("display", "none");
<?php
if (isset($_GET["filter1"])) {
echo '$("#filter2_"+' . $_GET["filter1"] . '+"_chosen").css("display", "inline-block");';
}
?>
$("#filter1").change(function () {
var filter_1_key = $(this).val();
$(".filter2").css("display", "none");
$("#filter2_0_chosen").css("display", "none");
$("#filter2_1_chosen").css("display", "none");
$("#filter2_2_chosen").css("display", "none");
$("#filter2_" + filter_1_key + "_chosen").css("display", "inline-block");
});
});
function filter() {
var filter1 = $("select[name='filter1']").val();
var filter2 = $("#filter2_" + filter1).val();
if (filter1 != "" && filter2 != "") {
top.location.href = 'invoice_index.php?filter1=' + filter1 + '&filter2=' + filter2;
} else {
alert("請選擇篩選方式。");
}
}
</script>
</head>
<body>
<table width="1200" height="600" border="0" cellpadding="0" cellspacing="0">
<tr>
<td width="200" align="left" valign="top">
<table width="200" border="0" cellpadding="0" cellspacing="0">
<tr>
<td height="70" align="left" valign="middle"> </td>
</tr>
<tr>
<td width="200" align="left" valign="top"><!-- Main Menu -->
<?php require("menu.php"); ?><!-- End Main Menu --></td>
</tr>
</table>
</td>
<td width="1000" align="left" valign="top">
<table width="1000" border="0" cellpadding="0" cellspacing="0">
<tr>
<td>
<table width="1000" border="0" cellspacing="0" cellpadding="0">
<tr>
<td height="70" class="pagetitletxt"> </td>
<td width="50" align="center" class="icontxt">
<a href="invoice_addform.php"><img src="images/iconNew.png" alt="Add" width="32" height="32" border="0"/><br/> 新增
</a>
</td>
</tr>
</table>
</td>
</tr>
<tr>
<td class="pagetitletxt">
<b><img src="images/iconList.jpg" width="48" height="48" align="absmiddle"/> 租金及其他發票
</b></td>
</tr>
<tr>
<td height="25" align="left" valign="middle" class="msg"><?php if (isset($_GET["msg"])) echo $_GET['msg']; ?></td>
</tr>
<tr>
<td align="left" valign="middle">
<div>篩選: <select name="filter1" id="filter1">
<option value="">---請選擇---</option>
<?php
foreach ($filter1_info as $key => $filter1) {
if (isset($_GET["filter1"]))
$selected = matched_option($key, $_GET["filter1"], "select");
echo '<option value="' . $key . '" ' . $selected . '>' . $filter1 . '</option>';
}
?>
</select>
<select name="filter2" id="filter2_0" class="filter2 ">
<option value="">---請選擇---</option>
<?php
foreach ($filter2_info[0] as $data) {
if (isset($_GET["filter2"]))
$selected = matched_option($data[0], $_GET["filter2"], "select");
echo '<option value="' . $data[0] . '" ' . $selected . ' class="' . $key . '">' . $data[1] . '</option>';
}
?>
</select>
<select name="filter2" id="filter2_1" class="filter2 ">
<option value="">---請選擇---</option>
<?php
foreach ($filter2_info[1] as $data) {
if (isset($_GET["filter2"]))
$selected = matched_option($data[0], $_GET["filter2"], "select");
echo '<option value="' . $data[0] . '" ' . $selected . ' class="' . $key . '">' . $data[1] . '</option>';
}
?>
</select>
<select name="filter2" id="filter2_2" class="filter2 ">
<option value="">---請選擇---</option>
<?php
foreach ($filter2_info[2] as $data) {
if (isset($_GET["filter2"]))
$selected = matched_option($data[0], $_GET["filter2"], "select");
echo '<option value="' . $data[0] . '" ' . $selected . ' class="' . $key . '">' . $data[1] . '</option>';
}
?>
</select>
<button type="button" onclick="filter();">送出</button>
<button type="button" onclick="window.location.href='invoice_index.php?all=1';" style="margin-left: 15px;">
全部發票
</button>
</div>
<br>
<form action="invoice_invoice_update.php" method="post" name="invoice_invoice_update" id="invoice_invoice_update" enctype="multipart/form-data">
<table width="1000" border="0" cellpadding="0" cellspacing="0">
<tr>
<td width="10" class="listtitletxt"></td>
<td width="130" class="listtitletxt">發票編號</td>
<td width="130" class="listtitletxt">合約編號</td>
<td width="130" class="listtitletxt">客戶編號</td>
<td width="150" class="listtitletxt">客戶姓名</td>
<td width="80" class="listtitletxt">發票日期</td>
<td width="80" class="listtitletxt">發票到期</td>
<td width="100" class="listtitletxt">金額</td>
<td width="50" class="listtitletxt">狀態</td>
<td width="20" class="listtitletxt"></td>
</tr>
<?php
foreach ($invoice_info as $invoice) {
print "<tr>";
print "<td class='listtxt' style='padding-left:5'> </td>";
print "<td class='listtxt' style='padding-left:5'>" . $invoice{'invoice_code'} . "</td>";
if (!empty($invoice{'order_id'})) {
//$order_info = get_order($invoice["order_id"]);
print "<td class='listtxt' style='padding-left:5'><a href='order_modifyform.php?order_id=" . $invoice["order_id"] . "' target='_blank'> " . $invoice{'order_code'} . "</a></td>";
} else {
print "<td class='listtxt' style='padding-left:5'>-</td>";
}
print "<td class='listtxt' style='padding-left:5'><a href='customer_modifyform.php?id=" . $invoice["customer_id"] . "' target='_blank'> " . $invoice{'customer_code'} . "</a></td>";
print "<td class='listtxt' style='padding-left:5'><a href='customer_modifyform.php?id=" . $invoice["customer_id"] . "' target='_blank'>" . $invoice{'customer_name'} . "</a></td>";
print "<td class='listtxt' style='padding-left:5'>" . $invoice{'invoice_docdate'} . "</td>";
print "<td class='listtxt' style='padding-left:5'>" . $invoice{'invoice_duedate'} . "</td>";
print "<td class='listtxt' style='padding-left:5'>$" . numberformat($invoice{'amount'}) . "</td>";
print "<td class='listtxt' style='padding-left:5'>" . $invoice["invoice_status"] . "</td>";
// Modify
print "<td class='listtxt' align='center'><a href='#' onClick=\"window.location='invoice_modifyform.php?id=" . $invoice{'invoice_id'} . "'\"><img src='images/btnModify.png' title='Modify' alt='Modify' hspace='2' border='0'></a></td>";
print "</tr>";
}
?>
</table>
<br> <br> <br> <br>
</form>
</td>
</tr>
</table>
</td>
</tr>
</table>
</body>
</html>