:::
6. 表格拉動排序
6-1 上課範例：admin/cate.php
<?php
/*-----------引入檔案區--------------*/
include_once "header_admin.php";
/*-----------function區--------------*/
//contact_cate編輯表單
function contact_cate_form($gsn=""){
global $xoopsDB,$xoopsUser;
//抓取預設值
if(!empty($gsn)){
$DBV=get_contact_cate($gsn);
}else{
$DBV=array();
}
//預設值設定
//設定「gsn」欄位預設值
$gsn=(!isset($DBV['gsn']))?$gsn:$DBV['gsn'];
//設定「title」欄位預設值
$title=(!isset($DBV['title']))?null:$DBV['title'];
//設定「parent_gsn」欄位預設值
$parent_gsn=(!isset($DBV['parent_gsn']))?null:$DBV['parent_gsn'];
//設定「sort」欄位預設值
$sort=(!isset($DBV['sort']))?contact_cate_max_sort():$DBV['sort'];
$op=(empty($gsn))?"insert_contact_cate":"update_contact_cate";
$main="
<form action='{$_SERVER['PHP_SELF']}' method='post'>
<table class='form_tbl'>
<!--群組名稱-->
<tr><td class='title' nowrap>群組名稱</td>
<td class='col'><input type='text' name='title' size='20' value='{$title}' id='title' ></td></tr>
<!--父群組-->
<tr><td class='title' nowrap>父群組</td>
<td class='col'>
<select name='parent_gsn' size=1 >
<option value='' ".chk($parent_gsn,'','1','selected')."></option>
".get_contact_cate_options('edit' , $gsn , $parent_gsn )."
</select>
</td></tr>
<!--排序-->
<tr><td class='title' nowrap>排序</td>
<td class='col'><input type='text' name='sort' size='20' value='{$sort}' id='sort'></td></tr>
<tr>
<td class='bar' colspan='2'>
<!--群組編號-->
<input type='hidden' name='gsn' value='{$gsn}'>
<input type='hidden' name='op' value='{$op}'>
<input type='submit' value='儲存'>
</td>
</tr>
</table>
</form>";
//raised,corners,inset
$main=div_3d("群組設定",$main,"raised");
return $main;
}
//自動取得contact_cate的最新排序
function contact_cate_max_sort(){
global $xoopsDB;
$sql = "select max(`sort`) from `".$xoopsDB->prefix("contact_cate")."`";
$result = $xoopsDB->query($sql) or redirect_header($_SERVER['PHP_SELF'],3, mysql_error());
list($sort)=$xoopsDB->fetchRow($result);
return ++$sort;
}
//新增資料到contact_cate中
function insert_contact_cate(){
global $xoopsDB,$xoopsUser;
$myts =& MyTextSanitizer::getInstance();
$sql = "insert into `".$xoopsDB->prefix("contact_cate")."`
(`title` , `parent_gsn` , `sort`)
values('{$_POST['title']}' , '{$_POST['parent_gsn']}' , '{$_POST['sort']}')";
$xoopsDB->query($sql) or redirect_header($_SERVER['PHP_SELF'],3, mysql_error());
//取得最後新增資料的流水編號
$gsn = $xoopsDB->getInsertId();
return $gsn;
}
//更新contact_cate某一筆資料
function update_contact_cate($gsn=""){
global $xoopsDB,$xoopsUser;
$myts =& MyTextSanitizer::getInstance();
$sql = "update `".$xoopsDB->prefix("contact_cate")."` set
`title` = '{$_POST['title']}' ,
`parent_gsn` = '{$_POST['parent_gsn']}' ,
`sort` = '{$_POST['sort']}'
where `gsn` = '$gsn'";
$xoopsDB->queryF($sql) or redirect_header($_SERVER['PHP_SELF'],3, mysql_error());
return $gsn;
}
//刪除contact_cate某筆資料資料
function delete_contact_cate($gsn=""){
global $xoopsDB , $isAdmin;
$sql = "delete from `".$xoopsDB->prefix("contact_cate")."` where `gsn` = '{$gsn}'";
$xoopsDB->queryF($sql) or redirect_header($_SERVER['PHP_SELF'],3, mysql_error());
}
//取得contact_cate無窮分類列表
function list_contact_cate_loop($show_function=1 , $parent_gsn=0 , $i=0){
global $xoopsDB , $xoopsModule;
$MDIR=$xoopsModule->getVar('dirname');
$sql = "select * from `".$xoopsDB->prefix("contact_cate")."` where `parent_gsn` = '{$parent_gsn}' order by `sort`";
$result = $xoopsDB->query($sql) or redirect_header($_SERVER['PHP_SELF'],3, mysql_error());
$function_title=($show_function)?"<th>功能</th>":"";
$prefix=str_repeat("----",$i);
$i++;
$data="";
while($all=$xoopsDB->fetchArray($result)){
//以下會產生這些變數： $gsn , $title , $parent_gsn , $sort
foreach($all as $k=>$v){
$$k=$v;
}
$fun=($show_function)?"
<td>
<a href='{$_SERVER['PHP_SELF']}?op=contact_cate_form&gsn=$gsn'><img src='".XOOPS_URL."/modules/{$MDIR}/images/edit.gif' alt='編輯'></a>
<a href=\"javascript:delete_contact_cate_func($gsn);\"><img src='".XOOPS_URL."/modules/{$MDIR}/images/del.gif' alt='刪除'></a>
</td>":"";
$data.="
<tr id='tr_{$gsn}'>
<td>{$prefix}<a href='{$_SERVER['PHP_SELF']}?gsn={$gsn}'>{$title}</a> <img src='".XOOPS_URL."/modules/tadtools/treeTable/images/updown_s.png' style='cursor: s-resize;margin:0px 4px;' alt='拉動排序' title='拉動排序'> ({$sort})</td>
$fun
</tr>";
$data.=list_contact_cate_loop($show_function,$gsn,$i);
}
if($parent_gsn!='0'){
return $data;
}else{
$jquery=get_jquery(true);
$main="
$jquery
<script type='text/javascript'>
$(document).ready(function(){
$('#sort').sortable({ opacity: 0.6, cursor: 'move', update: function() {
var order = $(this).sortable('serialize');
$.post('save_sort.php', order, function(theResponse){
$('#save_msg').html(theResponse);
});
}
});
});
function delete_contact_cate_func(gsn){
var sure = window.confirm('確定要刪除此資料？');
if (!sure) return;
location.href=\"{$_SERVER['PHP_SELF']}?op=delete_contact_cate&gsn=\" + gsn;
}
</script>
<div id='save_msg' style='margin:10px auto;'></div>
<table summary='list_table' id='tbl' style='width:100%;'>
<tr>
<th nowrap>群組名稱</th>
$function_title</tr>
<tbody id='sort'>
$data
</tbody>
<tr>
<td colspan=6 class='bar'>
<a href='{$_SERVER['PHP_SELF']}?op=contact_cate_form'><img src='".XOOPS_URL."/modules/{$MDIR}/images/add.gif' alt='"._BP_ADD."' align='right'></a>
{$bar}</td></tr>
</table>";
//raised,corners,inset
$main=div_3d("",$main,"corners");
}
return $main;
}
//取得所有contact_cate分類選單的選項（模式 = edit[編輯用] or show[顯示用],目前分類編號,目前分類的所屬編號）
function get_contact_cate_options($mode='show' , $default_gsn="0" , $default_parent_gsn="0" , $unselect_level="" , $start_search_sn="0" , $level=0){
global $xoopsDB , $xoopsModule;
$sql = "select `gsn` , `title` from `".$xoopsDB->prefix("contact_cate")."` where `parent_gsn` = '{$start_search_sn}' order by `sort`";
$result = $xoopsDB->query($sql) or redirect_header($_SERVER['PHP_SELF'] , 3, mysql_error());
$prefix=str_repeat(" " , $level);
$level++;
$unselect=explode("," , $unselect_level);
$main="";
while(list($gsn , $title)=$xoopsDB->fetchRow($result)){
if($mode=="edit"){
$selected=($gsn==$default_parent_gsn)?"selected=selected":"";
$selected.=($gsn==$default_gsn)?"disabled=disabled":"";
$selected.=(in_array($level , $unselect))?"disabled=disabled":"";
}else{
$selected=($gsn==$default_gsn)?"selected=selected":"";
$selected.=(in_array($level , $unselect))?"disabled=disabled":"";
}
$main.="<option value=$gsn $selected>{$prefix}{$title}</option>";
$main.=get_contact_cate_options($mode , $default_gsn , $default_parent_gsn , $unselect_level , $gsn , $level);
}
return $main;
}
/*-----------執行動作判斷區----------*/
$op = empty($_REQUEST['op'])? "":$_REQUEST['op'];
$sn=empty($_REQUEST['sn'])?"":intval($_REQUEST['sn']);
$gsn=empty($_REQUEST['gsn'])?"":intval($_REQUEST['gsn']);
$files_sn=empty($_REQUEST['files_sn'])?"":intval($_REQUEST['files_sn']);
switch($op){
//新增資料
case "insert_contact_cate":
$gsn=insert_contact_cate();
header("location: {$_SERVER['PHP_SELF']}");
break;
//更新資料
case "update_contact_cate":
update_contact_cate($gsn);
header("location: {$_SERVER['PHP_SELF']}");
break;
//輸入表格
case "contact_cate_form":
$main=contact_cate_form($gsn);
break;
//刪除資料
case "delete_contact_cate":
delete_contact_cate($gsn);
header("location: {$_SERVER['PHP_SELF']}");
break;
//預設動作
default:
$main=list_contact_cate_loop();
break;
}
/*-----------秀出結果區--------------*/
module_admin_footer($main,1);
?>
