<?php
//  ------------------------------------------------------------------------ //
// 本模組由 tad 製作
// 製作日期：2008-02-28
// $Id: cate.php,v 1.4 2008/05/05 03:21:31 tad Exp $
// ------------------------------------------------------------------------- //

/*-----------引入檔案區--------------*/
include "../../../include/cp_header.php";
include "../function.php";
include_once XOOPS_ROOT_PATH."/Frameworks/art/functions.php";
include_once XOOPS_ROOT_PATH."/Frameworks/art/functions.admin.php";

/*-----------function區--------------*/
//tad_gallery_cate編輯表單
function tad_gallery_cate_form($csn=""){
        global $xoopsDB,$xoopsModuleConfig,$photo_border,$cate_show_mode_array;
        include_once(XOOPS_ROOT_PATH."/class/xoopsformloader.php");
        include_once(XOOPS_ROOT_PATH."/class/xoopseditor/xoopseditor.php");

        //抓取預設值
        if(!empty($csn)){
                $DBV=get_tad_gallery_cate($csn);
        }else{
                $DBV=array();
        }

        //預設值設定

        $csn=(!isset($DBV['csn']))?"":$DBV['csn'];
        $of_csn=(!isset($DBV['of_csn']))?"":$DBV['of_csn'];
        $title=(!isset($DBV['title']))?"":$DBV['title'];
        $enable_group=(!isset($DBV['enable_group']))?"":explode(",",$DBV['enable_group']);
        $enable_upload_group=(!isset($DBV['enable_upload_group']))?array('1'):explode(",",$DBV['enable_upload_group']);
        $sort=(!isset($DBV['sort']))?auto_get_csn_sort():$DBV['sort'];
        $passwd=(!isset($DBV['passwd']))?"":$DBV['passwd'];
        $mode=(!isset($DBV['mode']))?$xoopsModuleConfig['thumbnail_mode']:$DBV['mode'];
        $show_mode=(!isset($DBV['show_mode']))?"":$DBV['show_mode'];
        $cover=(!isset($DBV['cover']))?"":$DBV['cover'];

        $op=(empty($csn))?"insert_tad_gallery_cate":"update_tad_gallery_cate";

        $cate_select=get_tad_gallery_cate_option(0,0,$of_csn,"","",$csn,1);
        $cover_select=get_cover($csn,$cover);


        //可見群組
        $SelectGroup_name = new XoopsFormSelectGroup("", "enable_group", false,$enable_group, 3, true);
        $SelectGroup_name->addOption("", _MA_TADGAL_ALL_OK, false);
        $enable_group = $SelectGroup_name->render();

        //可上傳群組
        $SelectGroup_name = new XoopsFormSelectGroup("", "enable_upload_group", false,$enable_upload_group, 3, true);
        //$SelectGroup_name->addOption("", _MA_TADGAL_ALL_OK, false);
        $enable_upload_group = $SelectGroup_name->render();

        $option="";
        foreach($photo_border as $key=>$value){
          $selected=($mode==$key)?"selected='selected'":"";
                $option.="<option value='$key' $selected>$value</option>";
        }

        $cate_show_option="";
        foreach($cate_show_mode_array as $key=>$value){
          $selected=($show_mode==$key)?"selected='selected'":"";
                $cate_show_option.="<option value='$key' $selected>$value</option>";
        }


        $cover_default=(!empty($cover))?XOOPS_URL."/uploads/tadgallery/{$cover}":"../images/folder_picture.png";

        $main="
        <script type='text/javascript' src='".XOOPS_URL."/modules/tadgallery/class/jquery.js'></script>
        <script type='text/javascript'>
        $(document).ready(function() {
                $('#adv_form').hide();
                $('#show_adv_form').click(function() {
                        if ($('#adv_form').is(':visible')) {
               $('#adv_form').slideUp();
               $('#show_adv_form').val('"._MA_TADGAL_CATE_ADVANCE_SETUP."');
                        } else{
               $('#adv_form').slideDown();
               $('#show_adv_form').val('"._MA_TADGAL_CATE_HIDE_ADVANCE_SETUP."');
                        }
                });


                $('#shl_form').hide();
                $('#show_shl_form').click(function() {
                        if ($('#shl_form').is(':visible')) {
               $('#shl_form').slideUp();
               $('#show_shl_form').val('"._MA_TADGAL_CATE_SHL_SETUP."');
                        } else{
               $('#shl_form').slideDown();
               $('#show_shl_form').val('"._MA_TADGAL_CATE_HIDE_SHL_SETUP."');
                        }
                });
        });
        </script>
  <form action='{$_SERVER['PHP_SELF']}' method='post' id='myForm' enctype='multipart/form-data'>
  <table class='form_tbl'>

        <tr><td class='title' nowrap>"._MA_TADGAL_SORT."</td>
        <td class='col' colspan=2><input type='text' name='sort' size='5' value='{$sort}'></td></tr>
        <tr><td class='title' nowrap>"._MA_TADGAL_OF_CSN."</td>
        <td class='col' colspan=2><select name='of_csn' size=1>
        $cate_select
        </select></td></tr>

        <tr><td class='title' nowrap>"._MA_TADGAL_TITLE."</td>
        <td class='col' colspan=2><input type='text' name='title' size='30' value='{$title}'></td></tr>

        <tr><td class='title' nowrap>"._MA_TADGAL_COVER."</td>
        <td class='col' colspan=2><select name='cover' size=5 onChange='document.getElementById(\"pic\").src=\"".XOOPS_URL."/uploads/tadgallery/\" + this.value'>
        $cover_select
        </select><br><img src='{$cover_default}' id='pic' vspace=4></td></tr>

        <tr><td colspan=3><input type='button' value='"._MA_TADGAL_CATE_ADVANCE_SETUP."' id='show_adv_form'></div>
                <div id='adv_form'>
          <table class='form_tbl'>
                        <tr><td class='title' nowrap>"._MA_TADGAL_CATE_SHOW_MODE."</td>
                        <td class='col' colspan=2>
                        <select name='show_mode' size='1'>$cate_show_option</select>
                        </td></tr>
                        <tr><td class='title' nowrap>"._MA_TADGAL_PASSWD."</td>
                        <td class='col' colspan=2><input type='text' name='passwd' size='10' value='{$passwd}'>"._MA_TADGAL_PASSWD_DESC."</td></tr>
                        <tr><td class='title' nowrap>"._MA_TADGAL_SHOW_MODE."</td>
                        <td class='col' colspan=2><select size='1' name='mode'>
                        $option
                        </select></td></tr>
                        <tr><td>"._MA_TADGAL_CATE_POWER_SETUP."</td><td class='title'>"._MA_TADGAL_ENABLE_GROUP."</td><td class='title'>"._MA_TADGAL_ENABLE_UPLOAD_GROUP."</td>
                        </tr>
                        <tr><td></td>
                        <td class='col'>$enable_group</td><td class='col'>$enable_upload_group</td>
                        </tr>
                  </table>
          </div>
        </td></tr>

  </table>
        <input type='hidden' name='csn' value='{$csn}'>
  <input type='hidden' name='op' value='{$op}'>
  <input type='submit' value='"._MA_SAVE."'>
  </form>";

        $main=div_3d(_MA_INPUT_CATE_FORM,$main,"raised","display:inline;float:left;");

        return $main;
}

//新增資料到tad_gallery_cate中
function insert_tad_gallery_cate(){
        global $xoopsDB;
        if(empty($_POST['title']))return;
         if(empty($_POST['enable_group']) or in_array("",$_POST['enable_group'])){
    $enable_group="";
        }else{
                $enable_group=implode(",",$_POST['enable_group']);
        }

        if(empty($_POST['enable_upload_group'])){
    $enable_upload_group="1";
        }else{
                $enable_upload_group=implode(",",$_POST['enable_upload_group']);
        }

        $sql = "insert into ".$xoopsDB->prefix("tad_gallery_cate")." (of_csn,title,passwd,enable_group,enable_upload_group,sort,mode,show_mode) values('{$_POST['of_csn']}','{$_POST['title']}','{$_POST['passwd']}','{$enable_group}','{$enable_upload_group}','{$_POST['sort']}','{$_POST['mode']}','{$_POST['show_mode']}')";
        $xoopsDB->query($sql) or redirect_header($_SERVER['PHP_SELF'],3, mysql_error());
        //取得最後新增資料的流水編號
        $csn=$xoopsDB->getInsertId();
        return $csn;
}

//列出所有tad_gallery_cate資料
function list_tad_gallery_cate($of_csn=1,$level=0){
        global $xoopsDB,$xoopsModule,$photo_border;
        $old_level=$level;
        $left=$level*18+4;
        $level++;

 $MDIR=$xoopsModule->getVar('dirname');

        $sql = "select csn,of_csn,title,passwd,enable_group,enable_upload_group,sort,mode,cover from ".$xoopsDB->prefix("tad_gallery_cate")." where of_csn='{$of_csn}' order by sort";
        $result = $xoopsDB->query($sql) or redirect_header($_SERVER['PHP_SELF'],3, mysql_error());


        if($old_level==0){
                $data="
                <script>
                function delete_tad_gallery_cate_func(csn){
                        var sure = window.confirm('"._BP_DEL_CHK."');
                        if (!sure)        return;
                        location.href=\"{$_SERVER['PHP_SELF']}?op=delete_tad_gallery_cate&csn=\" + csn;
                }
                </script>
                <table id='tbl'>
                <tr>
                <th>("._MA_TADGAL_SORT.") "._MA_TADGAL_TITLE."</th>
                <th>"._MA_TADGAL_ENABLE_GROUP."</th>
                <th>"._MA_TADGAL_ENABLE_UPLOAD_GROUP."</th>
                <th>"._BP_FUNCTION."</th>
                </tr>
                <tbody>";
        }else{
                $data="";
        }

        while(list($csn,$of_csn,$title,$passwd,$enable_group,$enable_upload_group,$sort,$mode,$cover)=$xoopsDB->fetchRow($result)){
                $g_txt=txt_to_group_name($enable_group,_MA_TADGAL_ALL_OK);
                $gu_txt=txt_to_group_name($enable_upload_group,_MA_TADGAL_ALL_OK);
                $passwd_txt=(empty($passwd))?"":""._MA_TADGAL_PASSWD.":{$passwd}";
                $lock=(empty($passwd))?"":"<img src='../images/view_lock.png' alt='$passwd_txt' title='$passwd_txt' align='absmiddle'>";
                $pic=(empty($cover))?"../images/no_cover.png":"".XOOPS_URL."/uploads/tadgallery/{$cover}";
                $photo_border_mode=(empty($photo_border[$mode]))?"":"<div style='color:#FF99CC;font-size:11px;margin-top:3px;'>[ {$photo_border[$mode]} ]{$lock}</div>";

                $data.="<tr>
                <td style='padding-left: {$left}px;' class='col' >
                <img src='{$pic}' width=50 align=left hspace=4 alt='{$passwd_txt}' title='{$passwd_txt}'>
                <font color='#99CCCC'>(".$sort.") </font><b><a href='../index.php?csn=$csn'>{$title}</a></b>{$photo_border_mode}</td>
                <td class='col'>{$g_txt}</td>
                <td class='col'>{$gu_txt}</td>
                <td>
                <a href='{$_SERVER['PHP_SELF']}?op=tad_gallery_cate_form&csn=$csn'><img src='".XOOPS_URL."/modules/{$MDIR}/images/edit.gif' alt='"._BP_EDIT."' title='"._BP_EDIT."'></a>
                <a href=\"javascript:delete_tad_gallery_cate_func($csn);\"><img src='".XOOPS_URL."/modules/{$MDIR}/images/del.gif' alt='"._BP_DEL."' title='"._BP_DEL."'></a></td></tr>";
                $data.=list_tad_gallery_cate($csn,$level);
        }

        if($old_level==0){
                $data.="
                </tbody>
                </table>";
        }



        return $data;
}





//更新tad_gallery_cate某一筆資料
function update_tad_gallery_cate($csn=""){
        global $xoopsDB;
         if(empty($_POST['enable_group']) or in_array("",$_POST['enable_group'])){
    $enable_group="";
        }else{
                $enable_group=implode(",",$_POST['enable_group']);
        }

        if(empty($_POST['enable_upload_group'])){
    $enable_upload_group="1";
        }else{
                $enable_upload_group=implode(",",$_POST['enable_upload_group']);
        }
        $sql = "update ".$xoopsDB->prefix("tad_gallery_cate")." set of_csn = '{$_POST['of_csn']}', title = '{$_POST['title']}', passwd = '{$_POST['passwd']}', enable_group = '{$enable_group}', enable_upload_group = '{$enable_upload_group}', sort = '{$_POST['sort']}', mode = '{$_POST['mode']}', show_mode = '{$_POST['show_mode']}', cover = '{$_POST['cover']}' where csn='$csn'";
        $xoopsDB->queryF($sql) or redirect_header($_SERVER['PHP_SELF'],3, mysql_error());
        return $csn;
}

//刪除tad_gallery_cate某筆資料資料
function delete_tad_gallery_cate($csn=""){
        global $xoopsDB;

        //先找出底下所有相片
        $sql="select sn from ".$xoopsDB->prefix("tad_gallery")." where csn='$csn'";
        $xoopsDB->query($sql) or redirect_header($_SERVER['PHP_SELF'],3, mysql_error());
        while(list($sn)=$xoopsDB->fetchRow($result)){
          delete_tad_gallery($sn="");
        }

        //找出底下分類，並將分類的所屬分類清空
        $sql="update ".$xoopsDB->prefix("tad_gallery_cate")." set  of_csn='' where of_csn='$csn'";
        $xoopsDB->queryF($sql) or redirect_header($_SERVER['PHP_SELF'],3, mysql_error());

        //刪除之
        $sql = "delete from ".$xoopsDB->prefix("tad_gallery_cate")." where csn='$csn'";
        $xoopsDB->queryF($sql) or redirect_header($_SERVER['PHP_SELF'],3, mysql_error());

}

/*-----------執行動作判斷區----------*/
$op = (!isset($_REQUEST['op']))? "main":$_REQUEST['op'];
$_GET['csn'] = (!isset($_GET['csn'])) ? 0 : intval($_GET['csn']);

switch($op){
        //替換資料
        case "replace_tad_gallery_cate":
        replace_tad_gallery_cate();
        header("location: {$_SERVER['PHP_SELF']}");
        break;

        //新增資料
        case "insert_tad_gallery_cate":
        insert_tad_gallery_cate();
        header("location: {$_SERVER['PHP_SELF']}");
        break;

        //輸入表格
        case "tad_gallery_cate_form";
        $main=tad_gallery_cate_form($_GET['csn']);
        break;

        //刪除資料
        case "delete_tad_gallery_cate";
        delete_tad_gallery_cate($_GET['csn']);
        mk_rss_xml();
        header("location: {$_SERVER['PHP_SELF']}");
        break;

        //更新資料
        case "update_tad_gallery_cate";
        update_tad_gallery_cate($_POST['csn']);
        header("location: {$_SERVER['PHP_SELF']}");
        break;

        //預設動作
        default:
        $main=tad_gallery_cate_form($_GET['csn']);
        $data=list_tad_gallery_cate(0);
        $main.=div_3d(_MA_TADGAL_LIST_CATE,$data,"corners","display:inline;") . "<br clear='both' />";
        break;


}

/*-----------秀出結果區--------------*/
xoops_cp_header();
loadModuleAdminMenu(1);
echo "<link rel='stylesheet' type='text/css' media='screen' href='../module.css' />";
echo $main;
xoops_cp_footer();

?>