= DATE_SUB(CURRENT_DATE(), INTERVAL 2 WEEK) AND createdate <= '".date('Y-m-d 23:59:59')."'"; $parameters = NULL; } else { //check date time if ($_GET["filter1"] == 3 || $_GET["filter1"] == 5) { $message = ""; if (empty($_GET["filter2"])) { $message .= "請選擇開始日期。\\n\\n"; } else { if (!validateDate($_GET["filter2"], "Y-m-d")) { $message .= "開始日期格式出錯。\\n\\n"; } } if (empty($_GET["filter3"])) { $message .= "請選擇完結日期。\\n\\n"; } else { if (!validateDate($_GET["filter3"], "Y-m-d")) { $message .= "完結日期格式出錯。\\n\\n"; } } if (!empty($_GET["filter2"]) && !empty($_GET["filter3"]) && validateDate($_GET["filter2"], "Y-m-d") && validateDate($_GET["filter3"], "Y-m-d") && $_GET["filter3"] <= $_GET["filter2"]) { $message .= "開始日期必須早於完結日期。\\n\\n"; } if (!empty($message)) { echo ""; exit; } $filter_sql = "and startdate >= ? and startdate <= ?"; $parameters = array($_GET["filter2"], $_GET["filter3"]); } $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) { $filter_sql = "and id = ?"; } if ($_GET["filter1"] == 1 || $_GET["filter1"] == 2) { $filter_sql = "and customer_id = ?"; } if ($_GET["filter1"] == 4) { $filter_sql = "and status = ?"; } $parameters = array($_GET["filter2"]); if ($_GET["filter1"] == 3) { $filter_sql = "and startdate >= ? and startdate <= ?"; $parameters = array($_GET["filter2"], $_GET["filter3"]); } if ($_GET["filter1"] == 5) { $filter_sql = "and createdate >= ? and createdate <= ?"; $parameters = array($_GET["filter2"], $_GET["filter3"]); } } } } //pagination // how many records should be displayed on a page? $records_per_page = 20; // instantiate the pagination object $pagination = new Zebra_Pagination(); // records per page $pagination->records_per_page($records_per_page); $sql = "select count(*) as count from `order` where deleted = 0 " . $filter_sql . " order by id DESC"; $order_info = bind_pdo($sql, $parameters, "selectone"); // the number of total records is the number of records in the array $pagination->records($order_info['count']); $sql = "select * from `order` where deleted = 0 " . $filter_sql . " order by id DESC"; $sql .= ' LIMIT ' . (($pagination->get_page() - 1) * $records_per_page) . ', ' . $records_per_page ; $order_info = bind_pdo($sql, $parameters, "selectall"); foreach ($order_info as $key => $order) { $order_id = $order["id"]; $order_info[$key]["order_code"] = $order["code"]; /*$customer_info = get_customer($order["customer_id"]); $order_info[$key]["customer_code"] = $customer_info["code"]; $order_info[$key]["customer_name"] = $customer_info["customer_name"];*/ $customer_name = get_customer_name(rsa_crypt($order["customer_firstname"], 2), rsa_crypt($order["customer_lastname"], 2)); $order_info[$key]["customer_code"] = $order["customer_code"]; $order_info[$key]["customer_name"] = $customer_name; $order_info[$key]["customer_tel"] = rsa_crypt($order_info[$key]["customer_tel"], 2); } $filter_order_code = ""; $filter_customer_code = ""; $filter_customer_name = ""; $filter_status = ""; $filter_startfrom = ""; $all_order_info = get_order2(); foreach ($all_order_info as $key => $order) { $filter_order_code[$key][0] = $order["id"]; $filter_order_code[$key][1] = $order["code"]; } $all_order_info = get_customer2(); foreach ($all_order_info as $key => $customer) { $filter_customer_code[$key][0] = $customer["id"]; $filter_customer_code[$key][1] = $customer["code"]; $filter_customer_name[$key][0] = $customer["id"]; $filter_customer_name[$key][1] = $customer["customer_name"]; } $status_info = get_master_type_code("ORDER_STATUS"); 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_code, 1 => $filter_customer_code, 2 => $filter_customer_name, 3 => "user_input", 4 => $filter_status, 5 => "user_input"); ?>
 
  
   合約
篩選: " id="filter2_35" class="filter2" style="width: 100px;" placeholder="開始日期"/> " id="filter3_35" class="filter3" style="width: 100px;" placeholder="完結日期"/>

"; print ""; print ""; print ""; /*$customer_type = get_master_type_code("CUSTOMER_TYPE", $order["customer_typeid"]); if($order["customer_typeid"] == "BUSINESS"){ print ""; }else if($order["customer_typeid"] == "PERSONAL"){ print ""; }*/ print ""; print ""; $order_room_info = get_order_room($order["id"]); $order_room_list = ""; foreach ($order_room_info as $detail) { $room_info = get_room($detail["room_id"]); $order_room_list .= check_combine_room($room_info["code"]) . ", "; } $order_room_list = substr_replace($order_room_list, "", -2); print ""; print ""; print ""; print ""; $order_status = get_master_type_code("ORDER_STATUS", $order["status"]); print ""; if ($order["status"] == "NEW") { print ""; } else { print ""; } if ($order["status"] == "NEW") { print ""; } else { print ""; } // Modify print ""; print ""; } ?>
合約編號 門卡號碼 客戶姓名 聯絡電話 租用單位 租用期(月) 生效日期 結束日期 狀態 轉倉 退倉 詳情
 " . $order['order_code'] . "" . $order['room_key'] . "" . $customer_type["name_tc"] . "
".$order["customer_companyname"]."		" . $customer_type["name_tc"] . "" . $order['customer_name'] . "
(" . $order['customer_code'] . ")		" . $order['customer_tel'] . "" . $order_room_list . "" . $order['rent_month'] . "" . $order['startdate'] . "" . $order['enddate'] . "" . $order_status["name_tc"] . "不適用不適用Modify

render(); ?>