} else { unset($record["auth_" . $lang]); $record["create_date"] = $record["update_date"] = date("Y-m-d H:i:s"); $record["create_name"] = $record["update_name"] = $_SESSION["admin_info"]["account"]; $conn->AutoExecute($table, $record, "INSERT"); $conn->Execute("UPDATE " . $table . " SET `auth_" . $lang . "`='" . substr($auth, 0, -1) . "' WHERE id='" . $conn->Insert_ID() . "'"); //--修正特殊字符無法寫入欄位 alert("新增完成", Get_Url(array())); exit; } } if ($del_id) { $sql = " delete from " . $table . " where id in (" . $del_id . ")"; //刪除資料 $conn->Execute($sql); alert("刪除完成", Page_get_url('del_id')); exit; } $session_auth = explode(",", $_SESSION["admin_info"]["auth"]); if ($id || $id == '0') { $sql .= " id=" . $id; $data = $conn->GetRow($sql); $data["status_html"] = Make_radio($_SETUP["status"], $data["status"], "status"); $lang_sql = " and lang ='" . $lang . "'"; //---只抓取該語系資料 $sql = " select * from " . PREFIX . "sysmenu WHERE ifview=1 and parents='0'" . $lang_sql . " order by lang,sort"; $menu = $conn->GetArray($sql); $sql = " select * from " . PREFIX . "sysmenu WHERE ifview=1 and parents!='0'" . $lang_sql . " order by sort"; $menu_2 = $conn->GetArray($sql); //---語系資料表截取 $temp_lang = $conn->GetArray("select * from " . PREFIX . "language where status>0");
//抓出mysql全部舊資料 /* $sql_all = "select * from ".$table; $all_tmp = $conn->GetArray($sql_all); */ $data_id = $all_data_id = $class_list = $all_tmp = $class_count = $class_count_old = ""; $type = $record["type"]; unset($record["type"]); unset($record["act"]); unset($record["lang"]); //將POST之資料組成array foreach ($record as $k => $v) { $data_id = explode("_", $k); $now_id = $data_id[count($data_id) - 1]; $data_idx = ""; unset($data_id[count($data_id) - 1]); $data_idx = implode("_", $data_id); $data[$now_id][$data_idx] = $v; } //有更改的資料開始一筆一筆進行update if ($data) { foreach ($data as $k => $v) { $v["update_date"] = date("Y-m-d H:i:s"); $v["update_name"] = $_SESSION["admin_info"]["account"]; $where = "id=" . $k; $conn->AutoExecute($table, $v, "UPDATE", $where); } } alert("修改完成", Page_get_url('')); exit;
} } $record["lang"] = $post["lang"] = $lang = $_SESSION["admin_info"]["lang"]; if ($_SESSION["re_url"] != NULL && $_SESSION["admin_info"]["account"] != NULL) { //-判斷是否經由內頁連入 登入後導回內頁 $url_s = $_SESSION["re_url"]; unset($_SESSION["re_url"]); LinkTo($url_s); } //--後台編輯器載入前台式樣檔 $css_temp = $conn->GetRow("select * from " . PREFIX . "setting where type='web_css'"); $tpl->assign("web_css", '<script> website_css="' . $css_temp["detail"] . '";</script>'); //config設定檔 $page_name = Now_file(); define('LANG', $lang); $_SESSION["admin_info"]["page"] = Page_get_url(''); $mail = new PHPMailer(); // 建立新物件 $mail->IsHTML(true); // 設定郵件內容為HTML $mail->CharSet = "utf-8"; // 設定郵件編碼 $mail->Encoding = "base64"; $mail->WordWrap = 50; // 每50個字元自動斷行 $smtp_set = $conn->GetRow("select * from " . PREFIX . "data_list where type='smtp_mail' and status=1"); //--啟用 SMTP模式 if ($smtp_set) { //--網站設定 $sql = " select * from " . PREFIX . "setting WHERE lang = '" . quotes($lang) . "' order by id"; $tmp = $conn->GetArray($sql);
} //抓出其分類下的子分類 end } $del_list = substr($del_list, 0, -1); $sql = "select * from " . $table . " WHERE lv in (" . $del_list . ") order by parents,lv,sort"; $data = ""; $data = $conn->GetArray($sql); if ($data) { foreach ($data as $k => $v) { $data[$k]["ifview"] = $_SETUP["status"][$v["ifview"]]; } include_once "index.php"; //assign 所有資料、共用頁面 $tpl->assign("content", ROOT_PATH . $admin_path . "templates/_sysmenu.html"); $tpl->display(ROOT_PATH . $admin_path . "templates/index.html"); echo '<script>if(confirm(\'刪除此分類將會刪除底下所有子分類,確定要繼續嗎?\')==true){location=\'?del=sure&del_list=' . $del_list . '&del_id=' . $del_id . '\';}else{location=\'' . Page_get_url('del_id') . '\';}</script>'; exit; } else { LinkTo("?del=sure&del_id=" . $del_id); exit; } } //新增 更新 刪除 結束 //無限層分類制作 $html = Make_class($conn); $sql = " select * from " . $table . " WHERE 1=1 and "; if ($id || $id == '0') { $sql .= " id=" . $id; $data = $conn->GetRow($sql); $data["ifview"] = Make_radio($_SETUP["status"], $data["ifview"], "ifview"); $html = Make_class($conn, $data["lv"]);
function Page_table_class($data, $now_page, $per_page_qty) { $tmp["now_page"] = $now_page; $tmp["all_page"] = ceil(count($data) / $per_page_qty); $tmp["start_date"] = ($now_page - 1) * $per_page_qty + 1; if ($tmp["now_page"] < $tmp["all_page"]) { $tmp["end_date"] = $tmp["start_date"] + $per_page_qty - 1; } else { $tmp["end_date"] = $tmp["start_date"] + count($data) - $per_page_qty * ($now_page - 1) - 1; } if ($tmp["now_page"] == 1) { $i = 0; } else { $i = 1; } $tmp["up_url"] = Page_get_url('page') . "&page=" . ($now_page - $i) . Post_to_get($_POST); if ($tmp["now_page"] == $tmp["all_page"]) { $i = 0; } else { $i = 1; } $tmp["down_url"] = Page_get_url('page') . "&page=" . ($now_page + $i) . Post_to_get($_POST); $tmp["page_date_count"] = $tmp["end_date"] - $tmp["start_date"] + 1; //jump_page 用之 html樣式建製 for ($i = 1; $i <= $tmp["all_page"]; $i++) { $tmp["jump_page_html"] .= "<option value='" . $i . "'"; if ($i == $tmp["now_page"]) { $tmp["jump_page_html"] .= 'selected="selected"'; } $tmp["jump_page_html"] .= ">" . $i . "</option>"; } //給jump用之url值 $tmp["jump_page_url"] = Page_get_url('page'); if (count($data) < 1) { $tmp["start_date"] = 0; $tmp["now_page"] = 0; $tmp["up_url"] = "#"; $tmp["down_url"] = "#"; } return $tmp; }