function show_user_list() { $db = init_db(); $tpl = init_tpl(SRVROOT . $this->tmpl_path); $plu_header = SRVROOT . $this->plu_header_path; //加入麵包屑 $func_Cname = "使用者列表"; $trail = new Breadcrumb(); $trail->add($func_Cname, $_SERVER['REQUEST_URI'], 1); $site_data = array(); $count = 0; $dataTotal = $db->get_var("SELECT COUNT(user_id) FROM sys_user WHERE user_id != 'awoo_maintainer'"); list($dataStart, $dataLen, $pagejump) = init_sliding_pager($dataTotal); $sql = "SELECT user_id,user_nickname,user_email FROM sys_user WHERE user_id != 'awoo_maintainer' LIMIT {$dataStart}, {$dataLen}"; $result = $db->get_results($sql); if (isset($result)) { foreach ($result as $rows) { $site_data[] = array('count' => $count + 1, 'user_id' => $rows->user_id, 'user_nickname' => $rows->user_nickname, 'user_email' => $rows->user_email, "show_edit_user_link" => $this->plu_path . "&func=show_edit_user&user_id={$rows->user_id}", "do_del_user_link" => $this->plu_path . "&func=do_del_user&user_id={$rows->user_id}"); $count++; } } $tpl->assign("pager", $pagejump); $tpl->assign("count", $count); $tpl->assign("site_data", $site_data); $tpl->assign("func_Cname", $func_Cname); $tpl->assign("show_add_user_link", $this->plu_path . "&func=show_add_user"); $tpl->assign("plu_header_path", $plu_header); return $tpl->fetch("show_user_list.tpl"); }
function show_m01_list() { $db = init_db(); $tpl = init_tpl(SRVROOT . $this->tmpl_path); $plu_header = SRVROOT . $this->plu_header_path; //加入麵包屑 $func_Cname = "mobile01文章管理"; $trail = new Breadcrumb(); $trail->add($func_Cname, $_SERVER['REQUEST_URI'], 1); ///print_r($_POST); $kw_ids = isset($_POST["kw_ids"]) ? $_POST["kw_ids"] : NULL; $filter = ""; if (isset($kw_ids)) { foreach ($kw_ids as $ids) { if (empty($filter)) { $filter = " WHERE kw_ids LIKE '%[{$ids}]%' "; } else { $filter .= " OR kw_ids LIKE '%[{$ids}]%' "; } } } if (!empty($filter)) { $_SESSION['m01_filter'] = $filter; } else { if (!empty($_GET['page']) && isset($_SESSION['filter']) && !empty($_SESSION['filter'])) { $filter = $_SESSION['m01_filter']; } } $sel_sql = "SELECT DISTINCT kw_id, kw_content FROM plu_keywords"; $sel_result = $db->get_results($sel_sql, ARRAY_A); $dataTotal = $db->get_var("SELECT COUNT(m01_id) FROM plu_mobile01" . $filter); list($dataStart, $dataLen, $pagejump) = init_sliding_pager($dataTotal, 5); $sql = "SELECT m01_id, m01_title, m01_post_time, ModiTime FROM plu_mobile01 " . $filter . " LIMIT {$dataStart}, {$dataLen}"; $result = $db->get_results($sql, ARRAY_A); $tpl->assign("sel_data", $sel_result); $tpl->assign("kw_ids", $kw_ids); $tpl->assign("m01_data", $result); $tpl->assign("pager", $pagejump); $tpl->assign("count", $dataTotal); $tpl->assign("func_Cname", $func_Cname); $tpl->assign("css_path", WEBROOT . $this->css_path); $tpl->assign("img_path", WEBROOT . $this->upload_path); $tpl->assign("show_add_m01_link", $this->plu_path . "&func=show_add_m01"); //$tpl->assign("show_add_news_category", $this->plu_path."&func=show_add_category"); $tpl->assign("plu_header_path", $plu_header); $tpl->assign("show_m01_list_link", $this->plu_path . "&func=show_m01_list"); $tpl->assign("show_edit_m01_link", $this->plu_path . "&func=show_edit_m01&m01_id="); $tpl->assign("do_del_m01_link", $this->plu_path . "&func=do_del_m01&m01_id="); $tpl->assign("jq_multi_select_path", WEBROOT . "/cms/lib/jquery/multiSelect/"); return $tpl->fetch("show_m01_list.tpl"); }
function show_doc_list() { $db = init_db(); $tpl = init_tpl(SRVROOT . $this->tmpl_path); $plu_header = SRVROOT . $this->plu_header_path; //加入麵包屑 $func_Cname = "文件下載管理"; $trail = new Breadcrumb(); $trail->add($func_Cname, $_SERVER['REQUEST_URI'], 1); $filter = ""; if (!empty($_POST["cate_id"]) && preg_match("/^[0-9]*\$/", $_POST["cate_id"])) { $cate_id = $_POST["cate_id"]; $tpl->assign("cate_id", $cate_id); $filter = " WHERE cate_id = {$cate_id} "; } $sel_sql = "SELECT DISTINCT cate_id, cate_name FROM plu_document_category"; $sel_result = $db->get_results($sel_sql, ARRAY_A); $dataTotal = $db->get_var("SELECT COUNT(doc_id) FROM plu_document" . $filter); list($dataStart, $dataLen, $pagejump) = init_sliding_pager($dataTotal); $sql = "SELECT * FROM plu_document" . $filter . " LIMIT {$dataStart}, {$dataLen}"; $result = $db->get_results($sql, ARRAY_A); $newArray = array(); $i = 0; if (count($result) > 0) { foreach ($result as $row) { $newArray[$i] = array(); foreach ($row as $key => $value) { $newArray[$i][$key] = $value; if ($key == "name") { $newArray[$i][$key] = substr($value, 0, strrpos($row[$key], ".")); } } $i++; } } $tpl->assign("sel_data", $sel_result); $tpl->assign("doc_data", $newArray); $tpl->assign("pager", $pagejump); $tpl->assign("count", $dataTotal); $tpl->assign("func_Cname", $func_Cname); $tpl->assign("show_doc_list_url", $this->plu_path . "&func=show_doc_list"); $tpl->assign("show_add_doc_link", $this->plu_path . "&func=show_add_doc"); $tpl->assign("show_add_cate_url", $this->plu_path . "&func=show_add_category"); $tpl->assign("plu_header_path", $plu_header); $tpl->assign("show_edit_doc_link", $this->plu_path . "&func=show_edit_doc&doc_id="); $tpl->assign("do_del_doc_link", $this->plu_path . "&func=do_del_doc&doc_id="); return $tpl->fetch("show_doc_list.tpl"); }
function show_news_list() { $db = init_db(); $tpl = init_tpl(SRVROOT . $this->tmpl_path); $plu_header = SRVROOT . $this->plu_header_path; //加入麵包屑 $func_Cname = "最新消息管理"; $trail = new Breadcrumb(); $trail->add($func_Cname, $_SERVER['REQUEST_URI'], 1); $cate_id = !empty($_POST["cid"]) && preg_match("/^[0-9]*\$/", $_POST["cid"]) ? $_POST["cid"] : NULL; $filter = isset($cate_id) ? " WHERE cate_id = {$cate_id} " : ""; if (!empty($filter)) { $_SESSION['news_filter'] = $filter; } else { if (!empty($_GET['page']) && isset($_SESSION['filter']) && !empty($_SESSION['filter'])) { $filter = $_SESSION['news_filter']; } } $sel_sql = "SELECT DISTINCT cate_id, cate_name FROM plu_news_category"; $sel_result = $db->get_results($sel_sql, ARRAY_A); $dataTotal = $db->get_var("SELECT COUNT(news_id) FROM plu_news" . $filter); list($dataStart, $dataLen, $pagejump) = init_sliding_pager($dataTotal); $orderby = isset($_GET["orderby"]) ? $_GET["orderby"] : ""; if ($orderby == "ASC") { $tpl->assign("news_orderby_cond", $orderby); $tpl->assign("news_orderby_url", $this->plu_path . "&func=show_news_list&orderby=DESC"); $filter .= " ORDER BY ModiTime ASC"; } else { $tpl->assign("news_orderby_url", $this->plu_path . "&func=show_news_list&orderby=ASC"); $filter .= " ORDER BY ModiTime DESC"; } $sql = "SELECT news_id, caption, img_name, ModiTime FROM plu_news" . $filter . " LIMIT {$dataStart}, {$dataLen}"; $result = $db->get_results($sql, ARRAY_A); $tpl->assign("sel_data", $sel_result); $tpl->assign("cate_id", $cate_id); $tpl->assign("news_data", $result); $tpl->assign("pager", $pagejump); $tpl->assign("count", $dataTotal); $tpl->assign("func_Cname", $func_Cname); $tpl->assign("img_path", WEBROOT . $this->upload_path); $tpl->assign("show_add_news_link", $this->plu_path . "&func=show_add_news"); $tpl->assign("show_add_news_category", $this->plu_path . "&func=show_add_category"); $tpl->assign("plu_header_path", $plu_header); $tpl->assign("show_edit_news_link", $this->plu_path . "&func=show_edit_news&news_id="); $tpl->assign("do_del_news_link", $this->plu_path . "&func=do_del_news&news_id="); return $tpl->fetch("show_news_list.tpl"); }
function show_dist_list() { $db = init_db(); $tpl = init_tpl(SRVROOT . $this->tmpl_path); $plu_header = SRVROOT . $this->plu_header_path; //加入麵包屑 $func_Cname = "服務據點管理"; $trail = new Breadcrumb(); $trail->add($func_Cname, $_SERVER['REQUEST_URI'], 1); $place_id = !empty($_POST["place_id"]) && preg_match("/^[0-9]*\$/", $_POST["place_id"]) ? $_POST["place_id"] : NULL; $filter = isset($place_id) ? " WHERE place_id = '{$place_id}' " : ""; $sel_sql = "SELECT DISTINCT place_id, place_name FROM plu_dist_place"; $sel_result = $db->get_results($sel_sql, ARRAY_A); $dataTotal = $db->get_var("SELECT COUNT(dist_id) FROM plu_distributor" . $filter); list($dataStart, $dataLen, $pagejump) = init_sliding_pager($dataTotal); $orderby = isset($_GET["orderby"]) ? $_GET["orderby"] : ""; if ($orderby == "ASC") { $tpl->assign("dist_orderby_cond", $orderby); $tpl->assign("dist_orderby_url", $this->plu_path . "&func=show_dist_list&orderby=DESC"); $filter .= " ORDER BY ModiTime ASC"; } else { $tpl->assign("dist_orderby_url", $this->plu_path . "&func=show_dist_list&orderby=ASC"); $filter .= " ORDER BY ModiTime DESC"; } $sql = "SELECT dist_id, dist_name, dist_phone,dist_address, img_name, ModiTime FROM plu_distributor" . $filter . " LIMIT {$dataStart}, {$dataLen}"; $result = $db->get_results($sql, ARRAY_A); $tpl->assign("sel_data", $sel_result); $tpl->assign("place_id", $place_id); $tpl->assign("dist_data", $result); $tpl->assign("pager", $pagejump); $tpl->assign("count", $dataTotal); $tpl->assign("func_Cname", $func_Cname); $tpl->assign("img_path", WEBROOT . $this->upload_path); $tpl->assign("show_add_dist_link", $this->plu_path . "&func=show_add_dist"); $tpl->assign("show_add_dist_place", $this->plu_path . "&func=show_add_place"); $tpl->assign("plu_header_path", $plu_header); $tpl->assign("show_edit_dist_link", $this->plu_path . "&func=show_edit_dist&dist_id="); $tpl->assign("do_del_dist_link", $this->plu_path . "&func=do_del_dist&dist_id="); return $tpl->fetch("show_dist_list.tpl"); }
function show_member_list() { $db = init_db(); $tpl = init_tpl(SRVROOT . $this->tmpl_path); $plu_header = SRVROOT . $this->plu_header_path; //加入麵包屑 $func_Cname = "會員管理"; $trail = new Breadcrumb(); $trail->add($func_Cname, $_SERVER['REQUEST_URI'], 1); $filter = ""; if (isset($_POST["search_item"])) { $search_item = $_POST["search_item"]; $filter = " WHERE account LIKE '%{$search_item}%' OR name LIKE '%{$search_item}%'"; } else { if (!empty($_POST["gid"]) && preg_match("/^[0-9]*\$/", $_POST["gid"])) { $cate_id = $_POST["gid"]; $tpl->assign("cate_id", $cate_id); $filter = " WHERE group_id = {$cate_id} "; } } $sel_sql = "SELECT DISTINCT group_id, group_name FROM plu_member_group"; $sel_result = $db->get_results($sel_sql, ARRAY_A); $dataTotal = $db->get_var("SELECT COUNT(member_id) FROM plu_member" . $filter); list($dataStart, $dataLen, $pagejump) = init_sliding_pager($dataTotal); $sql = "SELECT * FROM plu_member" . $filter . " LIMIT {$dataStart}, {$dataLen}"; $result = $db->get_results($sql, ARRAY_A); $tpl->assign("sel_data", $sel_result); $tpl->assign("member_data", $result); $tpl->assign("pager", $pagejump); $tpl->assign("count", $dataTotal); $tpl->assign("func_Cname", $func_Cname); $tpl->assign("search_member_url", $this->plu_path . "&func=show_member_list"); $tpl->assign("show_add_member_link", $this->plu_path . "&func=show_add_member"); $tpl->assign("show_add_group_url", $this->plu_path . "&func=show_add_group"); $tpl->assign("plu_header_path", $plu_header); $tpl->assign("show_edit_member_link", $this->plu_path . "&func=show_edit_member&member_id="); $tpl->assign("do_del_member_link", $this->plu_path . "&func=do_del_member&member_id="); return $tpl->fetch("show_member_list.tpl"); }
<?php require_once SRVROOT . "/cms/inc/incpkg.inc.php"; include_db_pkg(); $news_id = isset($_GET['news_id']) ? $_GET['news_id'] : ""; if (!(isset($_GET['news_id']) && preg_match("/^[0-9]*\$/", $_GET['news_id']))) { redirect(WEBROOT, 0, "sorry!!你所要觀看的消息不合法"); exit; } $db = init_db(); $upload_path = "/cms/upload/news/"; $img_path = WEBROOT . $upload_path; $dataTotal = $db->get_var("SELECT COUNT(news_id) FROM plu_news"); list($dataStart, $dataLen, $pagejump) = init_sliding_pager($dataTotal); $sql = "SELECT caption, content, img_name, ModiTime FROM plu_news WHERE news_id = '{$news_id}' LIMIT {$dataStart}, {$dataLen}"; $result = $db->get_results($sql); if (isset($result)) { foreach ($result as $rows) { $path = $img_path . $rows->img_name; if (empty($rows->img_name)) { $path = WEBROOT . "/cms/upload/noImg.jpg"; } ?> <div class="image_box right"> <img style="width:300px;height:248px;" src="<?php echo $path; ?> " /> </div> <div id="news_txtbox" class=" left"> <h3 class="news_h3"><?php
function get_pri_list_count() { $db = init_db(); $dataTotal = $db->get_var("SELECT COUNT(user_id) FROM sys_user WHERE user_id != 'awoo_maintainer' "); list($dataStart, $dataLen, $pagejump) = init_sliding_pager($dataTotal); return $pagejump; }
function show_orders_list() { $db = init_db(); $tpl = init_tpl(SRVROOT . $this->tmpl_path); $plu_header = SRVROOT . $this->plu_header_path; //加入麵包屑 $func_Cname = "訂單管理"; $trail = new Breadcrumb(); $trail->add($func_Cname, $_SERVER['REQUEST_URI'], 1); $filter = ""; if (isset($_GET['opt'])) { switch ($_GET['opt']) { case 1: if ($_POST['deliveryStatus'] == 2) { $filter = " WHERE delivery_status = 1"; } else { if ($_POST['deliveryStatus'] == 3) { $filter = " WHERE delivery_status = 0"; } } break; case 2: if ($_POST['paymentStatus'] == 2) { $filter = " WHERE payment_status = 1"; } else { if ($_POST['paymentStatus'] == 3) { $filter = " WHERE payment_status = 0"; } } break; case 3: if ($_POST['recordedStatus'] == 2) { $filter = " WHERE recorded_status = 1"; } else { if ($_POST['recordedStatus'] == 3) { $filter = " WHERE recorded_status = 0"; } } break; } } else { if (isset($_POST['search_item'])) { $txt = htmlspecialchars($_POST['search_txt']); switch ($_POST['search_item']) { case 0: $filter = " WHERE order_number='{$txt}'"; break; case 1: $filter = " WHERE order_name='{$txt}'"; break; case 2: $filter = " WHERE receiver_name='{$txt}'"; break; case 3: $filter = " a JOIN plu_orders_detail b ON a.order_id=b.order_id JOIN plu_product c ON b.prod_id=c.prod_id WHERE c.name='{$txt}'"; break; case 4: $filter = " a JOIN plu_member b ON a.member_id=b.member_id WHERE account='{$txt}'"; break; } } } $dataTotal = $db->get_var("SELECT COUNT(order_id) FROM plu_orders" . $filter); list($dataStart, $dataLen, $pagejump) = init_sliding_pager($dataTotal); $sql = "SELECT delivery_status, order_id, order_name, order_date, payment_status, total_amount FROM plu_orders" . $filter . " LIMIT {$dataStart}, {$dataLen}"; $result = $db->get_results($sql, ARRAY_A); $tpl->assign("show_orders_list_url", $this->plu_path . "&func=show_orders_list"); $tpl->assign("orders_data", $result); $tpl->assign("pager", $pagejump); $tpl->assign("count", $dataTotal); $tpl->assign("func_Cname", $func_Cname); $tpl->assign("show_add_orders_link", $this->plu_path . "&func=show_add_orders"); $tpl->assign("show_add_orders_category", $this->plu_subpath . "&func=show_add_category"); $tpl->assign("plu_header_path", $plu_header); $tpl->assign("show_edit_orders_link", $this->plu_path . "&func=show_edit_orders&order_id="); $tpl->assign("do_del_orders_link", $this->plu_path . "&func=do_del_orders&order_id="); return $tpl->fetch("show_orders_list.tpl"); }
function show_product_list() { $db = init_db(); $tpl = init_tpl(SRVROOT . $this->tmpl_path); $plu_header = SRVROOT . $this->plu_header_path; //加入麵包屑 $func_Cname = "商品/服務管理"; $trail = new Breadcrumb(); $trail->add($func_Cname, $_SERVER['REQUEST_URI'], 1); $sel_sql = "SELECT DISTINCT cate_id, cate_name FROM plu_product_category WHERE parent_id=-1"; $sel_result = $db->get_results($sel_sql, ARRAY_A); $tpl->assign("sel_data", $sel_result); $tpl->assign("second_cate", $this->get_subcategory_script()); $filter = ""; if (isset($_GET['opt'])) { if ($_GET['opt'] == 1 && !empty($_POST['search_txt'])) { $txt = htmlspecialchars($_POST['search_txt']); switch ($_POST['search_item']) { case 0: //分類名稱 $filter = " a JOIN plu_product_category b ON a.cate_id=b.cate_id WHERE b.cate_name LIKE '%" . $txt . "%'"; break; case 1: //編號 $filter = " WHERE prod_number LIKE '%" . $txt . "%'"; break; default: //商品/服務名稱 $filter = " WHERE name LIKE '%" . $txt . "%'"; break; } } else { if ($_GET['opt'] == 2) { $cate_id = isset($_POST['cate_id']) && preg_match("/^[0-9]*\$/", $_POST['cate_id']) ? $_POST['cate_id'] : ""; $second_cate_id = isset($_POST['second_cate_id']) && preg_match("/^[0-9]*\$/", $_POST['second_cate_id']) ? $_POST['second_cate_id'] : ""; $selectedCategory = 0; if ($second_cate_id != "") { $selectedCategory = $second_cate_id; $tpl->assign("sec_cate_id", $second_cate_id); } else { if ($cate_id != "") { $selectedCategory = $cate_id; } } if ($selectedCategory != 0) { $tpl->assign("cate_id", $cate_id); $sel_sql = "SELECT DISTINCT cate_id, cate_name, parent_id FROM plu_product_category WHERE parent_id='{$cate_id}'"; $sel_result = $db->get_results($sel_sql, ARRAY_A); $tpl->assign("sec_sel_data", $sel_result); $filter = isset($cate_id) ? " WHERE cate_id = {$selectedCategory} " : ""; } } } } else { if (isset($_GET['cate_id'])) { $cate_id = isset($_GET['cate_id']) && preg_match("/^[0-9]*\$/", $_GET['cate_id']) ? $_GET['cate_id'] : ""; $filter = $cate_id != "" ? " WHERE cate_id = '{$cate_id}' " : ""; } } if (!empty($filter)) { $_SESSION['filter'] = $filter; } else { if (!empty($_GET['page']) && isset($_SESSION['filter']) && !empty($_SESSION['filter'])) { $filter = $_SESSION['filter']; } else { //echo "1234"; $_SESSION['filter'] = ""; } } $dataTotal = $db->get_var("SELECT COUNT(prod_id) FROM plu_product" . $filter); list($dataStart, $dataLen, $pagejump) = init_sliding_pager($dataTotal); $sql = "SELECT prod_id, prod_number, name, img_name, content FROM plu_product" . $filter . " ORDER BY ModiTime DESC LIMIT {$dataStart}, {$dataLen}"; $result = $db->get_results($sql, ARRAY_A); $tpl->assign("search_item_url", $this->plu_path . "&func=show_product_list&opt=1"); $tpl->assign("img_path", WEBROOT . $this->upload_path); $newArray = array(); $i = 0; if (isset($result) && count($result) > 0) { foreach ($result as $row) { $newArray[$i] = array(); foreach ($row as $key => $value) { if ($key == "img_name") { $idx = strpos($row[$key], "|"); if ($idx > 0) { $newArray[$i][$key] = substr($value, 0, $idx); } else { $newArray[$i][$key] = $row[$key]; } } else { if ($key == "content") { $newArray[$i][$key] = strip_tags($value); } else { $newArray[$i][$key] = $value; } } } $i++; } } $tpl->assign("show_product_list_url", $this->plu_path . "&func=show_product_list&opt=2"); $tpl->assign("product_data", $newArray); //$result); $tpl->assign("pager", $pagejump); $tpl->assign("count", $dataTotal); $tpl->assign("func_Cname", $func_Cname); $tpl->assign("show_add_product_link", $this->plu_path . "&func=show_add_product"); $tpl->assign("show_add_product_category", $this->plu_subpath . "&func=show_add_category"); $tpl->assign("plu_header_path", $plu_header); $tpl->assign("show_edit_product_link", $this->plu_path . "&func=show_edit_product&prod_id="); $tpl->assign("do_del_product_link", $this->plu_path . "&func=do_del_product&prod_id="); return $tpl->fetch("show_product_list.tpl"); }
function show_objects_list() { $db = init_db(); $tpl = init_tpl(SRVROOT . $this->tmpl_path); $plu_header = SRVROOT . $this->plu_header_path; //加入麵包屑 $func_Cname = "物件管理"; $trail = new Breadcrumb(); $trail->add($func_Cname, $_SERVER['REQUEST_URI'], 1); $county = array(0, '台北市', '基隆市', '台北縣', '宜蘭縣', '桃園縣', '新竹市', '新竹縣', '苗栗縣', '台中市', '台中縣', '彰化縣', '南投縣', '嘉義市', '嘉義縣', '雲林縣', '台南市', '台南縣', '高雄市', '高雄縣', '澎湖縣', '屏東縣', '台東縣', '花蓮縣', '金門縣', '連江縣', '海南諸島'); $district = array('100' => '中正區', '103' => '大同區', '104' => '中山區', '105' => '松山區', '106' => '大安區', '108' => '萬華區', '110' => '信義區', '111' => '士林區', '112' => '北投區', '114' => '內湖區', '115' => '南港區', '116' => '文山區', '200' => '仁愛區', '201' => '信義區', '202' => '中正區', '203' => '中山區', '204' => '安樂區', '205' => '暖暖區', '206' => '七堵區', '207' => '萬里鄉', '208' => '金山鄉', '220' => '板橋市', '221' => '汐止市', '222' => '深坑鄉', '223' => '石碇鄉', '224' => '瑞芳鎮', '226' => '平溪鄉', '227' => '雙溪鄉', '228' => '貢寮鄉', '231' => '新店市', '232' => '坪林鄉', '233' => '烏來鄉', '234' => '永和市', '235' => '中和市', '236' => '土城市', '237' => '三峽鎮', '238' => '樹林市', '239' => '鶯歌鎮', '241' => '三重市', '242' => '新莊市', '243' => '泰山鄉', '244' => '林口鄉', '247' => '蘆洲市', '248' => '五股鄉', '249' => '八里鄉', '251' => '淡水鎮', '252' => '三芝鄉', '253' => '石門鄉', '260' => '宜蘭市', '261' => '頭城鎮', '262' => '礁溪鄉', '263' => '狀圍鄉', '264' => '員山鄉', '265' => '羅東鎮', '266' => '三星鄉', '267' => '大同鄉', '268' => '五結鄉', '269' => '冬山鄉', '270' => '蘇澳鄉', '272' => '南澳鄉', '320' => '中壢市', '324' => '平鎮市', '325' => '龍潭鄉', '326' => '楊梅鎮', '327' => '新屋鄉', '328' => '觀音鄉', '330' => '桃園市', '333' => '龜山鄉', '334' => '八德市', '335' => '大溪鎮', '336' => '復興鄉', '337' => '大圍鄉', '338' => '蘆竹鄉', '300' => '新竹市', '302' => '竹北市', '303' => '湖口鄉', '304' => '新豐鄉', '305' => '新埔鎮', '306' => '關西鎮', '307' => '芎林鄉', '308' => '寶山鄉', '310' => '竹東鎮', '311' => '五峰鄉', '312' => '橫山鄉', '313' => '尖石鄉', '314' => '北埔鄉', '315' => '峨眉鄉', '350' => '竹南鎮', '351' => '頭份鎮', '352' => '三灣鄉', '353' => '南庄鄉', '354' => '獅潭鄉', '356' => '後龍鎮', '357' => '通宵鎮', '358' => '苑裡鎮', '360' => '苗栗市', '361' => '造橋鄉', '362' => '頭屋鄉', '363' => '公館鄉', '364' => '大湖鄉', '365' => '泰安鄉', '366' => '銅鑼鄉', '367' => '三義鄉', '368' => '西湖鄉', '369' => '卓蘭鎮', '400' => '中區', '401' => '東區', '402' => '南區', '403' => '西區', '404' => '北區', '406' => '北屯區', '407' => '西屯區', '408' => '南屯區', '411' => '太平市', '412' => '大里市', '413' => '霧峰鄉', '414' => '烏日鄉', '420' => '豐原市', '421' => '后里鄉', '422' => '石岡鄉', '423' => '東勢鎮', '424' => '和平鄉', '426' => '新社鄉', '427' => '潭子鄉', '428' => '大雅鄉', '429' => '神岡鄉', '432' => '大肚鄉', '433' => '沙鹿鎮', '434' => '龍井鄉', '435' => '梧棲鎮', '436' => '清水鎮', '437' => '大甲鎮', '438' => '外埔鄉', '439' => '大安鄉', '500' => '彰化市', '502' => '芬園鄉', '503' => '花壇鄉', '504' => '秀水鄉', '505' => '鹿港鎮', '506' => '福興鄉', '507' => '線西鄉', '508' => '和美鎮', '509' => '伸港鄉', '510' => '員林鎮', '511' => '社頭鄉', '512' => '永靖鄉', '513' => '埔心鄉', '514' => '溪湖鎮', '515' => '大村鄉', '516' => '埔鹽鄉', '520' => '田中鎮', '521' => '北斗鎮', '522' => '田尾鄉', '523' => '埤頭鄉', '524' => '溪州鄉', '525' => '竹塘鄉', '526' => '二林鎮', '527' => '大城鄉', '528' => '芳苑鄉', '600' => '二水鄉', '540' => '南投市', '541' => '中寮鄉', '542' => '草屯鎮', '544' => '國姓鄉', '545' => '埔里鎮', '546' => '仁愛鄉', '551' => '名間鄉', '552' => '集集鎮', '553' => '水里鄉', '555' => '魚池鄉', '556' => '信義鄉', '557' => '竹山鎮', '558' => '鹿谷鄉', '600' => '嘉義市', '602' => '番路鄉', '603' => '梅山鄉', '604' => '竹崎鄉', '605' => '阿里山鄉', '606' => '中埔鄉', '607' => '大埔鄉', '608' => '水上鄉', '611' => '鹿草鄉', '612' => '太保市', '613' => '朴子市', '614' => '東石鄉', '615' => '六腳鄉', '616' => '新港鄉', '621' => '民雄鄉', '622' => '大林鎮', '623' => '溪口鄉', '624' => '義竹鄉', '625' => '布袋鎮', '630' => '斗南鎮', '631' => '大埤鄉', '632' => '虎尾鎮', '633' => '土庫鎮', '634' => '褒忠鄉', '635' => '東勢鄉', '636' => '臺西鄉', '637' => '崙背鄉', '638' => '麥寮鄉', '640' => '斗六市', '643' => '林內鄉', '646' => '古坑鄉', '647' => '薊桐鄉', '648' => '西螺鎮', '649' => '二崙鄉', '651' => '北港鎮', '652' => '水林鄉', '653' => '口湖鄉', '654' => '四湖鄉', '655' => '元長鄉', '700' => '中區', '701' => '東區', '702' => '南區', '703' => '西區', '704' => '北區', '708' => '安平區', '709' => '安南區', '710' => '永康市', '711' => '歸仁鄉', '712' => '新化鎮', '713' => '左鎮鄉', '714' => '玉井鄉', '715' => '楠西鄉', '716' => '南化鄉', '717' => '仁德鄉', '718' => '關廟鄉', '719' => '龍崎鄉', '720' => '官田鄉', '721' => '麻豆鎮', '722' => '佳里鎮', '723' => '西港鄉', '724' => '七股鄉', '725' => '將軍鄉', '726' => '學甲鎮', '727' => '北門鄉', '730' => '新營市', '731' => '後壁鄉', '732' => '白河鎮', '733' => '東山鄉', '734' => '六甲鄉', '735' => '下營鄉', '736' => '柳營鄉', '737' => '鹽水鎮', '741' => '善化鎮', '742' => '大內鄉', '743' => '山上鄉', '744' => '新市鄉', '745' => '安定鄉', '800' => '新興區', '801' => '前金區', '802' => '苓雅區', '803' => '鹽埕區', '804' => '鼓山區', '805' => '旗津區', '806' => '前鎮區', '807' => '三民區', '811' => '楠梓區', '812' => '小港區', '813' => '左營區', '814' => '仁武鄉', '815' => '大社鄉', '820' => '岡山鎮', '821' => '路竹鄉', '822' => '阿蓮鄉', '823' => '田寮鄉', '824' => '燕巢鄉', '825' => '橋頭鄉', '826' => '梓官鄉', '827' => '彌陀鄉', '828' => '永安鄉', '829' => '湖內鄉', '830' => '鳳山市', '831' => '大寮鄉', '832' => '林園鄉', '833' => '鳥松鄉', '840' => '大樹鄉', '842' => '旗山鎮', '843' => '美濃鎮', '844' => '六龜鄉', '845' => '內門鄉', '846' => '杉林鄉', '847' => '甲仙鄉', '848' => '桃源鄉', '849' => '三民鄉', '851' => '茂林鄉', '852' => '茄萣鄉', '880' => '馬公市', '881' => '西嶼鄉', '882' => '望安鄉', '883' => '七美鄉', '884' => '白沙鄉', '885' => '湖西鄉', '900' => '屏東市', '901' => '三地門鄉', '902' => '霧臺鄉', '903' => '瑪家鄉', '904' => '九如鄉', '905' => '里港鄉', '906' => '高樹鄉', '907' => '鹽埔鄉', '908' => '長治鄉', '909' => '麟洛鄉', '911' => '竹田鄉', '912' => '內埔鄉', '913' => '萬丹鄉', '920' => '潮州鎮', '921' => '泰武鄉', '922' => '來義鄉', '923' => '萬巒鄉', '924' => '崁頂鄉', '925' => '新埤鄉', '926' => '南州鄉', '927' => '林邊鄉', '928' => '東港鎮', '929' => '琉球鄉', '931' => '佳冬鄉', '932' => '新園鄉', '940' => '枋寮鄉', '941' => '枋山鄉', '942' => '春日鄉', '943' => '獅子鄉', '944' => '車城鄉', '945' => '牡丹鄉', '946' => '恆春鎮', '947' => '滿州鄉', '950' => '臺東市', '951' => '綠島鄉', '952' => '蘭嶼鄉', '953' => '延平鄉', '954' => '卑南鄉', '955' => '鹿野鄉', '956' => '關山鎮', '957' => '海端鄉', '958' => '池上鄉', '959' => '東河鄉', '961' => '成功鎮', '962' => '長濱鄉', '963' => '太麻里鄉', '964' => '金峰鄉', '965' => '大武鄉', '966' => '達仁鄉', '970' => '花蓮市', '971' => '新城鄉', '972' => '秀林鄉', '973' => '吉安鄉', '974' => '壽豐鄉', '975' => '鳳林鎮', '976' => '光復鄉', '977' => '豐濱鄉', '978' => '瑞穗鄉', '979' => '萬榮鄉', '981' => '玉里鎮', '982' => '卓溪鄉', '983' => '富里鄉', '891' => '金湖鎮', '892' => '金寧鄉', '893' => '金城鎮', '894' => '烈嶼鄉', '896' => '烏坵鄉', '209' => '南竿', '210' => '北竿', '211' => '莒光', '212' => '東引', '817' => '東沙', '819' => '南沙', '290' => '釣魚台'); $searchStr = ""; $filter = ""; $order = ""; if (isset($_POST['searchbtn'])) { if (!empty($_POST['county']) && preg_match("/^[0-9]*\$/", $_POST["county"])) { $this->setFilterValue($filter, "county=" . $_POST['county']); $searchStr = $county[$_POST['county']] . ","; } if (!empty($_POST['district']) && preg_match("/^[0-9]*\$/", $_POST["district"])) { $this->setFilterValue($filter, "district=" . $_POST['district']); $searchStr .= $district[$_POST['district']] . ","; } if (!empty($_POST['auction_no'])) { $this->setFilterValue($filter, "auction_no LIKE '%" . htmlspecialchars($_POST['auction_no'] . "%'")); $searchStr .= htmlspecialchars($_POST['auction_no']) . ","; } if (!empty($_POST['beginDate']) && preg_match("/^[0-9]{1,4}-[0-9]{1,2}-[0-9]{1,2}\$/", $_POST['beginDate'])) { $searchStr .= $_POST['beginDate']; $_POST['beginDate'] = $this->formatDate($_POST['beginDate']); $this->setFilterValue($filter, "auction_date>='" . $_POST['beginDate'] . "'"); } if (!empty($_POST['endDate']) && preg_match("/^[0-9]{1,4}-[0-9]{1,2}-[0-9]{1,2}\$/", $_POST['endDate'])) { $searchStr .= "-" . $_POST['endDate'] . ",<BR />"; $_POST['endDate'] = $this->formatDate($_POST['endDate']); $this->setFilterValue($filter, "auction_date<='" . $_POST['endDate'] . "'"); } else { $searchStr .= "-<BR />"; } if (!empty($_POST['addr'])) { $this->setFilterValue($filter, "obj_addr LIKE '%" . htmlspecialchars($_POST['addr'] . "%'")); $searchStr .= sprintf('%7s', $_POST['addr']) . "...,"; } $searchStr .= "未放置"; if (!empty($_POST['unplaced_land']) && $_POST['unplaced_land'] == 'land') { $this->setFilterValue($filter, "b.total_area=0"); $searchStr .= "謄本、"; } if (!empty($_POST['unplaced_pic']) && $_POST['unplaced_pic'] == 'pic') { $this->setFilterValue($filter, "c.pha IS NULL "); $searchStr .= "相片、"; } if (!empty($_POST['unplaced_struct']) && $_POST['unplaced_struct'] == 'structure') { $this->setFilterValue($filter, "e.hoa IS NULL "); $searchStr .= "平面圖"; } if (!empty($_POST['unplaced_market']) && $_POST['unplaced_market'] == 'market') { $this->setFilterValue($filter, "quotations_addr_1 = '' AND quotations_addr_2 ='' "); $searchStr .= "行情"; } if (!empty($_POST['unplaced_info']) && $_POST['unplaced_info'] == 'info') { $this->setFilterValue($filter, "d.pia IS NULL "); $searchStr .= "房訊"; } $_SESSION['filter'] = $filter; } else { if (!empty($_GET['page']) && isset($_SESSION['filter']) && !empty($_SESSION['filter'])) { $filter = $_SESSION['filter']; } } if (isset($_GET['OPT'])) { switch ($_GET['OPT']) { case 2: $order = "auction_date"; break; case 3: $order = "auction_times"; break; case 4: $order = "auction_times DESC"; break; case 5: $order = "object_id"; break; case 6: $order = "object_id DESC"; break; default: $order = "auction_date DESC"; } $order = " ORDER BY " . $order; } else { $order = " ORDER BY auction_date DESC"; } $dataTotal = $db->get_var("SELECT COUNT(*) FROM plu_objects a JOIN plu_objects_household b ON a.object_id=b.object_id\r\nLEFT JOIN (SELECT object_id,COUNT(item) as pha FROM plu_objects_pic WHERE item LIKE 'pic_%' GROUP BY object_id) c ON (a.object_id=c.object_id)\r\nLEFT JOIN (SELECT object_id,COUNT(item) as pia FROM plu_objects_pic WHERE item LIKE 'house_pic_%' GROUP BY object_id) d ON (a.object_id=d.object_id)\r\nLEFT JOIN (SELECT object_id,COUNT(item) as hoa FROM plu_objects_pic WHERE item LIKE 'structure_%' GROUP BY object_id) e ON (a.object_id=e.object_id) " . $filter); list($dataStart, $dataLen, $pagejump) = init_sliding_pager($dataTotal); $sql = "SELECT a.*,IFNULL(b.total_area, 0) as total_area,IFNULL(c.pha, 0) as photo_amount,IFNULL(d.pia,0) as pic_amount,IFNULL(e.hoa,0) as house_amount FROM plu_objects a JOIN plu_objects_household b ON a.object_id=b.object_id\r\nLEFT JOIN (SELECT object_id,COUNT(item) as pha FROM plu_objects_pic WHERE item LIKE 'pic_%' GROUP BY object_id) c ON (a.object_id=c.object_id)\r\nLEFT JOIN (SELECT object_id,COUNT(item) as pia FROM plu_objects_pic WHERE item LIKE 'house_pic_%' GROUP BY object_id) d ON (a.object_id=d.object_id)\r\nLEFT JOIN (SELECT object_id,COUNT(item) as hoa FROM plu_objects_pic WHERE item LIKE 'structure_%' GROUP BY object_id) e ON (a.object_id=e.object_id) "; $sql .= $filter . $order . " LIMIT {$dataStart}, {$dataLen}"; // echo $sql."<BR />"; $result = $db->get_results($sql, ARRAY_A); $newArray = array(); $i = 0; if (isset($result) && count($result) > 0) { foreach ($result as $row) { $newArray[$i] = array(); foreach ($row as $key => $value) { if ($key == "county") { $newArray[$i][$key] = $county[$value]; } else { if ($key == "district") { $newArray[$i][$key] = $district[$value]; } else { $newArray[$i][$key] = $value; } } } $i++; } } $tpl->assign("searchStr", $searchStr); $tpl->assign("show_objects_list_url", $this->plu_path . "&func=show_objects_list"); $tpl->assign("OPT", isset($_GET['OPT']) ? intval($_GET['OPT']) : 1); $tpl->assign("objects_data", $newArray); $tpl->assign("pager", $pagejump); $tpl->assign("count", $dataTotal); $tpl->assign("func_Cname", $func_Cname); $tpl->assign("show_add_objects_link", $this->plu_path . "&func=show_add_objects"); $tpl->assign("datepicker_url", WEBROOT . '/cms/lib/js/chineseDatepicker.js'); $tpl->assign("show_add_objects_category", $this->plu_subpath . "&func=show_add_category"); $tpl->assign("plu_header_path", $plu_header); $tpl->assign("img_path", WEBROOT . $this->img_path); $tpl->assign("show_edit_objects_link", $this->plu_path . "&func=show_edit_objects&object_id="); $tpl->assign("do_del_objects_link", $this->plu_path . "&func=do_del_objects&object_id="); return $tpl->fetch("show_objects_list.tpl"); }