} 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;
}
