include "search_data.php";
//$sql .= " 1=1 order by create_date desc";
$sql .= " 1=1 and ( control>" . $_SESSION["admin_info"]["control"] . " OR (control=" . $_SESSION["admin_info"]["control"] . " AND id=" . $_SESSION["admin_info"]["id"] . ")) order by create_date desc";
$data = $conn->PageExecute($sql, $per_page_qty, $page);
if ($data) {
foreach ($data as $k => $v) {
foreach ($v as $k_2 => $v_2) {
$data_temp[$k][$k_2] = $v_2;
}
//存入新陣列 給與 smarty section 使用
//$data_temp[$k]["status"] = $_SETUP["status"][$data_temp[$k]["status"]];
/*foreach($group as $k_2 => $v_2)
if($data_temp[$k]["group_id"] == $v_2["id"])
$data_temp[$k]["group_html"] = $v_2["name"];
*/
$data_temp[$k]["group_html"] = '<select name="group_id_' . $data_temp[$k]["id"] . '">' . Make_sql_list($group, $data_temp[$k]["group_id"]) . '</select>';
$data_temp[$k]["status_html"] = Make_radio($_SETUP["status"], $data_temp[$k]["status"], "status_" . $data_temp[$k]["id"]);
}
$tpl->assign("page_table", Page_table($data, $per_page_qty));
$data = $data_temp;
}
$_SESSION["admin_info"]["view"] = "list";
}
include_once "index.php";
//assign 所有資料、共用頁面
$tpl->assign("content", ROOT_PATH . $admin_path . "templates/admin.html");
$tpl->display(ROOT_PATH . $admin_path . "templates/index.html");
?>
if ($ajx["class_id"] == 10) {
$sql = "select * from " . PREFIX . "products WHERE recommend=1";
}
//館長推荐
} else {
$sql = "select * from " . PREFIX . "products WHERE " . quotes($ajx["row"]) . "=" . quotes($ajx["class_id"]);
}
$tmp = array();
$tmp = $conn->GetArray($sql);
echo '<option value="">請選擇產品</option>' . Make_sql_list($tmp, NULL);
exit;
}
//樹狀分類 分層 篩選
if ($call == "category_select") {
$sql = "select * from " . PREFIX . "category WHERE parent_id=" . quotes($ajx["id"]) . " order by lft,rgt";
echo Make_sql_list($conn->GetArray($sql), NULL);
exit;
}
//重寄會員認證信
if ($call == "registered_send") {
$sql = " select * from " . PREFIX . "setting WHERE lang = '" . quotes($lang) . "'";
$tmp = $conn->GetArray($sql);
$web_set["title"] = deQuotes($tmp["0"]["detail"], -1);
$web_set["keyword"] = deQuotes($tmp["1"]["detail"], -1);
$web_set["receive_email"] = $tmp["2"]["detail"];
$web_set["default_email_title"] = $tmp["3"]["detail"];
$web_set["send_email"] = $tmp["4"]["detail"];
$web_set["favorite_url"] = "http://" . $_SERVER["HTTP_HOST"];
$sql = "Select * from " . PREFIX . "member WHERE id=" . quotes($ajx["member_id"]);
$add = $conn->GetRow($sql);
$add["n"] = $ajx["member_id"];
