function tad_web_action_form($ActionID = "")
{
global $xoopsDB, $xoopsUser, $WebID, $MyWebs, $isMyWeb, $xoopsTpl, $TadUpFiles, $web_cate;
if (!$isMyWeb and $MyWebs) {
redirect_header($_SERVER['PHP_SELF'] . "?op=WebID={$MyWebs[0]}&tad_web_action_form", 3, _MD_TCW_AUTO_TO_HOME);
} elseif (empty($MyWebs)) {
redirect_header("index.php", 3, _MD_TCW_NOT_OWNER);
}
//抓取預設值
if (!empty($ActionID)) {
$DBV = get_tad_web_action($ActionID);
} else {
$DBV = array();
}
//預設值設定
//設定「ActionID」欄位預設值
$ActionID = !isset($DBV['ActionID']) ? $ActionID : $DBV['ActionID'];
//設定「ActionName」欄位預設值
$ActionName = !isset($DBV['ActionName']) ? "" : $DBV['ActionName'];
//設定「ActionDesc」欄位預設值
$ActionDesc = !isset($DBV['ActionDesc']) ? "" : $DBV['ActionDesc'];
//設定「ActionDate」欄位預設值
$ActionDate = !isset($DBV['ActionDate']) ? date("Y-m-d") : $DBV['ActionDate'];
//設定「ActionPlace」欄位預設值
$ActionPlace = !isset($DBV['ActionPlace']) ? "" : $DBV['ActionPlace'];
//設定「uid」欄位預設值
$user_uid = $xoopsUser ? $xoopsUser->getVar('uid') : "";
$uid = !isset($DBV['uid']) ? $user_uid : $DBV['uid'];
//設定「WebID」欄位預設值
$WebID = !isset($DBV['WebID']) ? $WebID : $DBV['WebID'];
//設定「ActionCount」欄位預設值
$ActionCount = !isset($DBV['ActionCount']) ? "" : $DBV['ActionCount'];
//設定「CateID」欄位預設值
$CateID = !isset($DBV['CateID']) ? "" : $DBV['CateID'];
$cate_menu = $web_cate->cate_menu($CateID);
$xoopsTpl->assign('cate_menu', $cate_menu);
$op = empty($ActionID) ? "insert_tad_web_action" : "update_tad_web_action";
if (!file_exists(TADTOOLS_PATH . "/formValidator.php")) {
redirect_header("index.php", 3, _MD_NEED_TADTOOLS);
}
include_once TADTOOLS_PATH . "/formValidator.php";
$formValidator = new formValidator("#myForm", true);
$formValidator_code = $formValidator->render();
$xoopsTpl->assign('formValidator_code', $formValidator_code);
$xoopsTpl->assign('ActionName', $ActionName);
$xoopsTpl->assign('ActionDesc', $ActionDesc);
$xoopsTpl->assign('ActionDate', $ActionDate);
$xoopsTpl->assign('ActionPlace', $ActionPlace);
//$xoopsTpl->assign('list_del_file',upfile::list_del_file("ActionID",$ActionID,true));
$xoopsTpl->assign('ActionID', $ActionID);
$xoopsTpl->assign('WebID', $WebID);
$xoopsTpl->assign('next_op', $op);
$xoopsTpl->assign('op', 'tad_web_action_form');
$TadUpFiles->set_col('ActionID', $ActionID);
//若 $show_list_del_file ==true 時一定要有
$upform = $TadUpFiles->upform(true, 'upfile');
$xoopsTpl->assign('upform', $upform);
}
function tad_web_link_form($LinkID = "")
{
global $xoopsDB, $xoopsUser, $WebID, $MyWebs, $xoopsTpl, $isMyWeb, $web_cate;
if (!$isMyWeb and $MyWebs) {
redirect_header($_SERVER['PHP_SELF'] . "?WebID={$MyWebs[0]}&op=tad_web_link_form", 3, _MD_TCW_AUTO_TO_HOME);
} elseif (empty($MyWebs)) {
redirect_header("index.php", 3, _MD_TCW_NOT_OWNER);
}
//抓取預設值
if (!empty($LinkID)) {
$DBV = get_tad_web_link($LinkID);
} else {
$DBV = array();
}
//預設值設定
//設定「LinkID」欄位預設值
$LinkID = !isset($DBV['LinkID']) ? "" : $DBV['LinkID'];
//設定「LinkTitle」欄位預設值
$LinkTitle = !isset($DBV['LinkTitle']) ? "" : $DBV['LinkTitle'];
//設定「LinkDesc」欄位預設值
$LinkDesc = !isset($DBV['LinkDesc']) ? "" : $DBV['LinkDesc'];
//設定「LinkUrl」欄位預設值
$LinkUrl = !isset($DBV['LinkUrl']) ? "" : $DBV['LinkUrl'];
//設定「LinkCounter」欄位預設值
$LinkCounter = !isset($DBV['LinkCounter']) ? "" : $DBV['LinkCounter'];
//設定「LinkSort」欄位預設值
$LinkSort = !isset($DBV['LinkSort']) ? tad_web_link_max_sort() : $DBV['LinkSort'];
//設定「WebID」欄位預設值
$WebID = !isset($DBV['WebID']) ? $WebID : $DBV['WebID'];
//設定「uid」欄位預設值
$user_uid = $xoopsUser ? $xoopsUser->getVar('uid') : "";
$uid = !isset($DBV['uid']) ? $user_uid : $DBV['uid'];
//設定「CateID」欄位預設值
$CateID = !isset($DBV['CateID']) ? "" : $DBV['CateID'];
$cate_menu = $web_cate->cate_menu($CateID);
$xoopsTpl->assign('cate_menu', $cate_menu);
$op = empty($LinkID) ? "insert_tad_web_link" : "update_tad_web_link";
//$op="replace_tad_web_link";
if (!file_exists(TADTOOLS_PATH . "/formValidator.php")) {
redirect_header("index.php", 3, _MD_NEED_TADTOOLS);
}
include_once TADTOOLS_PATH . "/formValidator.php";
$formValidator = new formValidator("#myForm", true);
$formValidator_code = $formValidator->render();
$xoopsTpl->assign('formValidator_code', $formValidator_code);
$xoopsTpl->assign('LinkTitle', $LinkTitle);
$xoopsTpl->assign('LinkUrl', $LinkUrl);
$xoopsTpl->assign('LinkDesc', $LinkDesc);
$xoopsTpl->assign('LinkSort', $LinkSort);
$xoopsTpl->assign('WebID', $WebID);
$xoopsTpl->assign('LinkID', $LinkID);
$xoopsTpl->assign('next_op', $op);
$xoopsTpl->assign('op', 'tad_web_link_form');
}
function tad_web_cate_form($CateID = '')
{
global $xoopsDB, $xoopsTpl, $isAdmin;
//抓取預設值
if (!empty($CateID)) {
$DBV = get_tad_web_cate($CateID);
} else {
$DBV = array();
}
//預設值設定
//設定 CateID 欄位的預設值
$CateID = !isset($DBV['CateID']) ? $CateID : $DBV['CateID'];
$xoopsTpl->assign('CateID', $CateID);
//設定 WebID 欄位的預設值
$WebID = !isset($DBV['WebID']) ? '' : $DBV['WebID'];
$xoopsTpl->assign('WebID', $WebID);
//設定 CateName 欄位的預設值
$CateName = !isset($DBV['CateName']) ? '' : $DBV['CateName'];
$xoopsTpl->assign('CateName', $CateName);
//設定 ColName 欄位的預設值
$ColName = !isset($DBV['ColName']) ? 'web_cate' : $DBV['ColName'];
$xoopsTpl->assign('ColName', $ColName);
//設定 ColSN 欄位的預設值
$ColSN = !isset($DBV['ColSN']) ? '0' : $DBV['ColSN'];
$xoopsTpl->assign('ColSN', $ColSN);
//設定 CateSort 欄位的預設值
$CateSort = !isset($DBV['CateSort']) ? tad_web_cate_max_sort($WebID, $ColName, $ColSN) : $DBV['CateSort'];
$xoopsTpl->assign('CateSort', $CateSort);
//設定 CateEnable 欄位的預設值
$CateEnable = !isset($DBV['CateEnable']) ? '1' : $DBV['CateEnable'];
$xoopsTpl->assign('CateEnable', $CateEnable);
//設定 CateCounter 欄位的預設值
$CateCounter = !isset($DBV['CateCounter']) ? '0' : $DBV['CateCounter'];
$xoopsTpl->assign('CateCounter', $CateCounter);
$op = empty($CateID) ? "save_tad_web_cate" : "update_tad_web_cate";
//$op = "replace_tad_web_cate";
//套用formValidator驗證機制
if (!file_exists(TADTOOLS_PATH . "/formValidator.php")) {
redirect_header("index.php", 3, _TAD_NEED_TADTOOLS);
}
include_once TADTOOLS_PATH . "/formValidator.php";
$formValidator = new formValidator("#myForm", true);
$formValidator_code = $formValidator->render();
$xoopsTpl->assign('action', $_SERVER["PHP_SELF"]);
$xoopsTpl->assign('formValidator_code', $formValidator_code);
$xoopsTpl->assign('now_op', 'tad_web_cate_form');
$xoopsTpl->assign('next_op', $op);
}
function tad_web_discuss_form($DiscussID = "")
{
global $xoopsDB, $xoopsUser, $WebID, $MyWebs, $isAdmin, $xoopsTpl, $web_cate;
if (!isAdmin and !$MyWebs and empty($_SESSION['LoginMemID'])) {
redirect_header("index.php", 3, _MD_TCW_LOGIN_TO_POST);
}
//抓取預設值
if (!empty($DiscussID)) {
$DBV = get_tad_web_discuss($DiscussID);
} else {
$DBV = array();
}
//預設值設定
if ($MyWebs) {
//設定「uid」欄位預設值
$uid = !isset($DBV['uid']) ? $xoopsUser->uid() : $DBV['uid'];
//設定「MemID」欄位預設值
$MemID = !isset($DBV['MemID']) ? 0 : $DBV['MemID'];
//設定「LoginMemName」欄位預設值
$MemName = !isset($DBV['MemName']) ? $xoopsUser->name() : $DBV['MemName'];
//設定「WebID」欄位預設值
$WebID = !isset($DBV['WebID']) ? $WebID : $DBV['WebID'];
} else {
//設定「uid」欄位預設值
$uid = !isset($DBV['uid']) ? 0 : $DBV['uid'];
//設定「MemID」欄位預設值
$MemID = !isset($DBV['MemID']) ? $LoginMemID : $DBV['MemID'];
//設定「LoginMemName」欄位預設值
$MemName = !isset($DBV['MemName']) ? $LoginMemName : $DBV['MemName'];
//設定「WebID」欄位預設值
$WebID = !isset($DBV['WebID']) ? $_SESSION['LoginWebID'] : $DBV['WebID'];
}
//設定「DiscussID」欄位預設值
$DiscussID = !isset($DBV['DiscussID']) ? "" : $DBV['DiscussID'];
//設定「ReDiscussID」欄位預設值
$ReDiscussID = !isset($DBV['ReDiscussID']) ? "" : $DBV['ReDiscussID'];
//設定「DiscussTitle」欄位預設值
$DiscussTitle = !isset($DBV['DiscussTitle']) ? "" : $DBV['DiscussTitle'];
//設定「DiscussContent」欄位預設值
$DiscussContent = !isset($DBV['DiscussContent']) ? "" : $DBV['DiscussContent'];
//設定「DiscussDate」欄位預設值
$DiscussDate = !isset($DBV['DiscussDate']) ? date("Y-m-d H:i:s") : $DBV['DiscussDate'];
//設定「LastTime」欄位預設值
$LastTime = !isset($DBV['LastTime']) ? date("Y-m-d H:i:s") : $DBV['LastTime'];
//設定「DiscussCounter」欄位預設值
$DiscussCounter = !isset($DBV['DiscussCounter']) ? "" : $DBV['DiscussCounter'];
//設定「CateID」欄位預設值
$CateID = !isset($DBV['CateID']) ? "" : $DBV['CateID'];
$new_cate = empty($_SESSION['LoginMemID']) ? true : false;
$cate_menu = $web_cate->cate_menu($CateID, $new_cate);
$xoopsTpl->assign('cate_menu', $cate_menu);
$op = empty($DiscussID) ? "insert_tad_web_discuss" : "update_tad_web_discuss";
//$op="replace_tad_web_discuss";
if (!file_exists(TADTOOLS_PATH . "/formValidator.php")) {
redirect_header("index.php", 3, _MD_NEED_TADTOOLS);
}
include_once TADTOOLS_PATH . "/formValidator.php";
$formValidator = new formValidator("#myForm", true);
$formValidator_code = $formValidator->render();
$xoopsTpl->assign('formValidator_code', $formValidator_code);
$xoopsTpl->assign('DiscussTitle', $DiscussTitle);
$xoopsTpl->assign('DiscussContent', $DiscussContent);
$xoopsTpl->assign('WebID', $WebID);
$xoopsTpl->assign('DiscussID', $DiscussID);
$xoopsTpl->assign('ReDiscussID', $ReDiscussID);
$xoopsTpl->assign('next_op', $op);
$xoopsTpl->assign('op', 'tad_web_discuss_form');
}
function jill_booking_item_form($jbi_sn = "")
{
global $xoopsDB, $xoopsTpl;
//抓取預設值
if (!empty($jbi_sn)) {
$DBV = get_jill_booking_item($jbi_sn);
} else {
$DBV = array();
}
//預設值設定
$myts =& MyTextSanitizer::getInstance();
//設定 jbi_sn 欄位的預設值
$jbi_sn = !isset($DBV['jbi_sn']) ? $jbi_sn : $DBV['jbi_sn'];
$xoopsTpl->assign('jbi_sn', $jbi_sn);
//設定 jbi_start 欄位的預設值
$jbi_start = !isset($DBV['jbi_start']) ? date("Y-m-d") : $DBV['jbi_start'];
$yesterday = date("Y-m-d", strtotime('-1 day'));
$xoopsTpl->assign('jbi_start', $jbi_start);
$xoopsTpl->assign('yesterday', $yesterday);
//設定 jbi_end 欄位的預設值
$jbi_end = !isset($DBV['jbi_end']) ? "" : $DBV['jbi_end'];
$xoopsTpl->assign('jbi_end', $jbi_end);
//設定 jbi_title 欄位的預設值
$jbi_title = !isset($DBV['jbi_title']) ? "" : $DBV['jbi_title'];
$xoopsTpl->assign('jbi_title', $jbi_title);
//設定 jbi_desc 欄位的預設值
$jbi_desc = !isset($DBV['jbi_desc']) ? "" : $myts->displayTarea($DBV['jbi_desc'], $html = 1, $smiley = 1, $xcode = 1, $image = 1, $br = 0);
if (!file_exists(TADTOOLS_PATH . "/ck.php")) {
redirect_header("index.php", 3, _MD_NEED_TADTOOLS);
}
include_once TADTOOLS_PATH . "/ck.php";
$Editor = new CKEditor("jill_booking", "jbi_desc", $jbi_desc);
$Editor->setToolbarSet('myBasic');
$Editor_code = $Editor->render();
$xoopsTpl->assign('Editor_code', $Editor_code);
//設定 jbi_approval 欄位的預設值
$jbi_approval = !isset($DBV['jbi_approval']) ? "0" : $DBV['jbi_approval'];
$xoopsTpl->assign('jbi_approval', $jbi_approval);
//設定 jbi_sort 欄位的預設值
$jbi_sort = !isset($DBV['jbi_sort']) ? jill_booking_item_max_sort() : $DBV['jbi_sort'];
$xoopsTpl->assign('jbi_sort', $jbi_sort);
//設定 jbi_enable 欄位的預設值
$jbi_enable = !isset($DBV['jbi_enable']) ? "1" : $DBV['jbi_enable'];
$xoopsTpl->assign('jbi_enable', $jbi_enable);
$op = empty($jbi_sn) ? "insert_jill_booking_item" : "update_jill_booking_item";
//$op="replace_jill_booking_item";
//套用formValidator驗證機制
if (!file_exists(TADTOOLS_PATH . "/formValidator.php")) {
redirect_header("index.php", 3, _TAD_NEED_TADTOOLS);
}
include_once TADTOOLS_PATH . "/formValidator.php";
$formValidator = new formValidator("#myForm", true);
$formValidator_code = $formValidator->render();
//加入Token安全機制
include_once XOOPS_ROOT_PATH . "/class/xoopsformloader.php";
$token = new XoopsFormHiddenToken();
$token_form = $token->render();
$xoopsTpl->assign("token_form", $token_form);
$xoopsTpl->assign('action', $_SERVER["PHP_SELF"]);
$xoopsTpl->assign('formValidator_code', $formValidator_code);
$xoopsTpl->assign('now_op', 'jill_booking_item_form');
$xoopsTpl->assign('next_op', $op);
}
function tad_web_form($WebID = null)
{
global $xoopsDB, $xoopsUser, $xoopsTpl, $TadUpFiles;
$pic = "";
//抓取預設值
if (!empty($WebID)) {
$DBV = get_tad_web($WebID);
//圖案
$TadUpFiles->set_col("WebLogo", $WebID, "1");
$web_logo = $TadUpFiles->get_pic_file("thumb");
$pic = empty($web_logo) ? "" : "background-image:url({$web_logo});background-repeat: no-repeat; background-position: top right;";
} else {
$DBV = array();
}
//預設值設定
//設定「WebID」欄位預設值
$WebID = !isset($DBV['WebID']) ? $WebID : $DBV['WebID'];
//設定「WebName」欄位預設值
$WebName = !isset($DBV['WebName']) ? "" : $DBV['WebName'];
//設定「WebSort」欄位預設值
$WebSort = !isset($DBV['WebSort']) ? tad_web_max_sort() : $DBV['WebSort'];
//設定「WebEnable」欄位預設值
$WebEnable = !isset($DBV['WebEnable']) ? "" : $DBV['WebEnable'];
//設定「WebCounter」欄位預設值
$WebCounter = !isset($DBV['WebCounter']) ? "" : $DBV['WebCounter'];
//設定「WebOwner」欄位預設值
$WebOwner = !isset($DBV['WebOwner']) ? "" : $DBV['WebOwner'];
//設定「WebOwnerUid」欄位預設值
$WebOwnerUid = !isset($DBV['WebOwnerUid']) ? "" : $DBV['WebOwnerUid'];
//設定「WebTitle」欄位預設值
$WebTitle = !isset($DBV['WebTitle']) ? "" : $DBV['WebTitle'];
$op = empty($WebID) ? "insert_tad_web" : "update_tad_web";
//$op="replace_tad_web";
if (!file_exists(TADTOOLS_PATH . "/formValidator.php")) {
redirect_header("index.php", 3, _MA_NEED_TADTOOLS);
}
include_once TADTOOLS_PATH . "/formValidator.php";
$formValidator = new formValidator("#myForm", true);
$formValidator_code = $formValidator->render();
$sql = "select uid,uname,name from " . $xoopsDB->prefix("users") . " order by uname";
$result = $xoopsDB->query($sql) or redirect_header($_SERVER['PHP_SELF'], 3, mysql_error());
$user_menu = "<select name='WebOwnerUid'>";
while ($all = $xoopsDB->fetchArray($result)) {
foreach ($all as $k => $v) {
${$k} = $v;
}
$name = empty($name) ? "" : "（{$name}）";
$selected = $uid == $WebOwnerUid ? "selected" : "";
$user_menu .= "<option value='{$uid}' {$selected}>{$uname} {$name}</option>";
}
$user_menu .= "</select>";
//$jquery = get_jquery(true);
$xoopsTpl->assign('pic', $pic);
$xoopsTpl->assign('user_menu', $user_menu);
$xoopsTpl->assign('WebName', $WebName);
$xoopsTpl->assign('WebTitle', $WebTitle);
$xoopsTpl->assign('WebOwner', $WebOwner);
$xoopsTpl->assign('WebEnable1', chk($WebEnable, "1", "1"));
$xoopsTpl->assign('WebEnable0', chk($WebEnable, "0"));
$xoopsTpl->assign('WebSort', $WebSort);
$xoopsTpl->assign('WebID', $WebID);
$xoopsTpl->assign('next_op', $op);
$xoopsTpl->assign('jquery', $jquery);
}
function jill_booking_form($jbi_sn = "")
{
global $xoopsDB, $xoopsTpl, $xoopsModuleConfig;
//場地設定
$item_opt = get_jill_booking_time_options($jbi_sn);
if (!empty($jbi_sn)) {
//場地資訊
$itemArr = get_jill_booking_item($jbi_sn, 1);
$xoopsTpl->assign('itemArr', $itemArr);
// array ('jbi_sn' => '2','jbi_title' =>'多功能教室','jbi_desc' => '<p>多功能教室多功能教室</p>','jbi_sort' => '1','jbi_start' => '2015-01-28','jbi_end' => '0000-00-00','jbi_enable' => '1','jbi_approval' => '0',)
//die(var_export($itemArr));
//預設值設定
//設定 jb_booking_content 欄位的預設值
$xoopsTpl->assign('jb_booking_content', "");
//設定 jb_start_date 欄位的預設值
$jb_start_date = strtotime($itemArr['jbi_start']) <= strtotime(date("Y-m-d")) ? date("Y-m-d") : $itemArr['jbi_start'];
$xoopsTpl->assign('jb_start_date', $jb_start_date);
//設定 jb_end_date 欄位的預設值
$xoopsTpl->assign('jb_end_date', $jb_start_date);
//設定可預約之週數及日期
$max_bookingweek = $xoopsModuleConfig['max_bookingweek'];
//$show_range = date("Y-m-d", strtotime("+$max_bookingweek week"));
if (empty($max_bookingweek)) {
//場地預約結束日期
$end = $itemArr['jbi_end'] == '0000-00-00' ? 0 : strtotime($itemArr['jbi_end']);
$max_date = $end == 0 ? '' : $itemArr['jbi_end'];
} else {
$endtime = strtotime("+{$max_bookingweek} week");
if ($itemArr['jbi_end'] == '0000-00-00') {
$end = $endtime;
} else {
$end = strtotime($itemArr['jbi_end']) >= $endtime ? $endtime : strtotime($itemArr['jbi_end']);
}
$max_date = date("Y-m-d", $end);
}
//die($max_date);
$xoopsTpl->assign('max_date', $max_date);
//時段資訊
$timeArr = get_bookingtime_jbisn($jbi_sn);
$xoopsTpl->assign('timeArr', $timeArr);
//die(var_export($timeArr));
$weektime = "";
foreach ($timeArr as $t => $time) {
for ($w = 0; $w < 7; $w++) {
$jbt_sn = $time['jbt_sn'];
$jbt_week = strval($time['jbt_week']);
$weektime[$t][$w]['jbt_week'] = strpos($jbt_week, strval($w)) !== false ? "<input type='checkbox' name='jb_week[{$jbt_sn}][]' value='{$w}' >" : "<span style='color:#D44950'><i class='fa fa-times'></i></span>";
}
}
//die(var_export($weektime));
//套用formValidator驗證機制
if (!file_exists(TADTOOLS_PATH . "/formValidator.php")) {
redirect_header("index.php", 3, _TAD_NEED_TADTOOLS);
}
include_once TADTOOLS_PATH . "/formValidator.php";
$formValidator = new formValidator("#myForm", true);
$formValidator_code = $formValidator->render();
//加入Token安全機制
include_once XOOPS_ROOT_PATH . "/class/xoopsformloader.php";
$token = new XoopsFormHiddenToken();
$token_form = $token->render();
$xoopsTpl->assign("token_form", $token_form);
$xoopsTpl->assign('formValidator_code', $formValidator_code);
$xoopsTpl->assign('weektime', $weektime);
$xoopsTpl->assign('next_op', "insert_jill_booking");
}
$xoopsTpl->assign('item_opt', $item_opt);
$xoopsTpl->assign('now_op', 'jill_booking_form');
$xoopsTpl->assign('action', $_SERVER["PHP_SELF"]);
}
function list_jill_booking_time($jbi_sn = "")
{
global $xoopsDB, $xoopsTpl, $isAdmin;
if (empty($jbi_sn)) {
return;
}
$item = get_jill_booking_item($jbi_sn);
include_once XOOPS_ROOT_PATH . "/modules/tadtools/jeditable.php";
$jeditable = new jeditable();
$myts =& MyTextSanitizer::getInstance();
$sql = "select * from `" . $xoopsDB->prefix("jill_booking_time") . "`\n where `jbi_sn`='{$jbi_sn}' order by `jbt_sort`";
$result = $xoopsDB->query($sql) or redirect_header($_SERVER['PHP_SELF'], 3, mysql_error());
$total = $xoopsDB->getRowsNum($result);
$all_content = "";
$i = 0;
while ($all = $xoopsDB->fetchArray($result)) {
//以下會產生這些變數： $jbt_sn , $jbi_sn , $jbt_title , $jbt_sort
foreach ($all as $k => $v) {
${$k} = $v;
}
//過濾讀出的變數值
$jbt_title = $myts->htmlSpecialChars($jbt_title);
$jeditable->setTextCol("#jbt_title_{$jbt_sn}", 'time.php', '100%', '11pt', "{'jbt_sn':{$jbt_sn},'op' : 'save_jbt_title'}", _TAD_EDIT . _MA_JILLBOOKIN_JBT_TITLE);
$all_content[$i]['jbi_sn'] = $jbi_sn;
$all_content[$i]['jbt_sn'] = $jbt_sn;
$all_content[$i]['jbt_title_link'] = "<a href='{$_SERVER['PHP_SELF']}?jbt_sn={$jbt_sn}'>{$jbt_title}</a>";
$all_content[$i]['jbt_title'] = $jbt_title;
$all_content[$i]['jbt_sort'] = $jbt_sort;
$all_content[$i]['jbt_week'] = strval($jbt_week);
$booking_times = get_booking_times($jbt_sn);
$all_content[$i]['booking_times'] = empty($booking_times) ? "" : sprintf(_MA_JILLBOOKIN_BOOKING_TIME, $booking_times);
$w_arr = explode(',', $jbt_week);
for ($j = 0; $j <= 7; $j++) {
$name = "w{$j}";
$pic = in_array($j, $w_arr) ? "yes.gif" : "no.gif";
$all_content[$i][$name] = "<img src='../images/{$pic}' id='{$jbt_sn}_{$j}' onClick=\"change_enable({$jbt_sn},{$j});\" style='cursor: pointer;'>";
}
++$i;
}
//die(var_export($all_content));
//刪除確認的JS
$xoopsTpl->assign('item', $item);
$xoopsTpl->assign('bar', $bar);
$xoopsTpl->assign('action', $_SERVER['PHP_SELF']);
$xoopsTpl->assign('isAdmin', $isAdmin);
$xoopsTpl->assign('all_content', $all_content);
$xoopsTpl->assign('now_op', 'list_jill_booking_time');
$xoopsTpl->assign('jbi_sn', $jbi_sn);
if (!file_exists(XOOPS_ROOT_PATH . "/modules/tadtools/sweet_alert.php")) {
redirect_header("index.php", 3, _MA_NEED_TADTOOLS);
}
include_once XOOPS_ROOT_PATH . "/modules/tadtools/sweet_alert.php";
$sweet_alert = new sweet_alert();
$delete_jill_booking_time_func = $sweet_alert->render('delete_jill_booking_time_func', "{$_SERVER['PHP_SELF']}?op=delete_jill_booking_time&jbi_sn={$jbi_sn}&jbt_sn=", "jbt_sn");
$xoopsTpl->assign('delete_jill_booking_time_func', $delete_jill_booking_time_func);
//套用formValidator驗證機制
if (!file_exists(TADTOOLS_PATH . "/formValidator.php")) {
redirect_header("index.php", 3, _TAD_NEED_TADTOOLS);
}
include_once TADTOOLS_PATH . "/formValidator.php";
$formValidator = new formValidator("#myForm", true);
$formValidator_code = $formValidator->render();
$xoopsTpl->assign('formValidator_code', $formValidator_code);
$jeditable_set = $jeditable->render();
$xoopsTpl->assign('jeditable_set', $jeditable_set);
//找出現有場地
$i = 0;
$place_time = "";
$sql = "select a.* , count(b.jbt_sn) as counter from `" . $xoopsDB->prefix("jill_booking_item") . "` as a join `" . $xoopsDB->prefix("jill_booking_time") . "` as b on a.jbi_sn=b.jbi_sn where a.jbi_enable='1' group by b.jbi_sn";
$result = $xoopsDB->query($sql) or redirect_header($_SERVER['PHP_SELF'], 3, mysql_error());
while ($data = $xoopsDB->fetchArray($result)) {
$data['jbi_link'] = sprintf(_MA_JILLBOOKIN_IMPORT_PLACE, $data['jbi_title'], $data['counter']);
$place_time[$i] = $data;
$i++;
}
$xoopsTpl->assign('place_time', $place_time);
$xoopsTpl->assign('jquery', get_jquery(true));
}
function tad_web_news_form($NewsID = "")
{
global $xoopsDB, $xoopsUser, $WebID, $MyWebs, $isMyWeb, $xoopsTpl, $TadUpFiles, $web_cate;
if (!$isMyWeb and $MyWebs) {
redirect_header($_SERVER['PHP_SELF'] . "?WebID={$MyWebs[0]}&op=tad_web_news_form", 3, _MD_TCW_AUTO_TO_HOME);
} elseif (empty($MyWebs)) {
redirect_header("index.php", 3, _MD_TCW_NOT_OWNER);
}
$Class = getWebInfo($WebID);
//抓取預設值
if (!empty($NewsID)) {
$DBV = get_tad_web_news($NewsID);
} else {
$DBV = array();
}
//設定「NewsID」欄位預設值
$NewsID = !isset($DBV['NewsID']) ? "" : $DBV['NewsID'];
//設定「NewsTitle」欄位預設值
if (isset($DBV['NewsTitle'])) {
$NewsTitle = _NEWS_KIND == "homework" ? $Class['WebTitle'] . date(" Y-m-d ") . _MD_TCW_HOMEWORK : $DBV['NewsTitle'];
} else {
$NewsTitle = _NEWS_KIND == "homework" ? $Class['WebTitle'] . date(" Y-m-d ") . _MD_TCW_HOMEWORK : "";
}
//設定「NewsContent」欄位預設值
if (isset($DBV['NewsContent'])) {
$NewsContent = $DBV['NewsContent'];
} else {
$NewsContent = _NEWS_KIND == "homework" ? _MD_TCW_HOMEWORK_DEFAULT : "";
}
//設定「NewsDate」欄位預設值
$NewsDate = !isset($DBV['NewsDate']) ? date("Y-m-d H:i:s") : $DBV['NewsDate'];
//設定「toCal」欄位預設值
if (!isset($DBV['toCal'])) {
$toCal = _NEWS_KIND == "homework" ? date("Y-m-d") : "";
} else {
$toCal = $DBV['toCal'] == "0000-00-00 00:00:00" ? "" : $DBV['toCal'];
}
//設定「NewsPlace」欄位預設值
$NewsPlace = !isset($DBV['NewsPlace']) ? "" : $DBV['NewsPlace'];
//設定「NewsMaster」欄位預設值
$NewsMaster = !isset($DBV['NewsMaster']) ? "" : $DBV['NewsMaster'];
//設定「NewsUrl」欄位預設值
$NewsUrl = !isset($DBV['NewsUrl']) ? "" : $DBV['NewsUrl'];
//設定「WebID」欄位預設值
$WebID = !isset($DBV['WebID']) ? $WebID : $DBV['WebID'];
//設定「NewsKind」欄位預設值
$NewsKind = !isset($DBV['NewsKind']) ? "" : $DBV['NewsKind'];
//設定「NewsCounter」欄位預設值
$NewsCounter = !isset($DBV['NewsCounter']) ? "" : $DBV['NewsCounter'];
//設定「CateID」欄位預設值
$CateID = !isset($DBV['CateID']) ? "" : $DBV['CateID'];
$cate_menu = $web_cate->cate_menu($CateID);
$xoopsTpl->assign('cate_menu', $cate_menu);
$op = empty($NewsID) ? "insert_tad_web_news" : "update_tad_web_news";
//$op="replace_tad_web_news";
if (!file_exists(TADTOOLS_PATH . "/formValidator.php")) {
redirect_header("index.php", 3, _MD_NEED_TADTOOLS);
}
include_once TADTOOLS_PATH . "/formValidator.php";
$formValidator = new formValidator("#myForm", true);
$formValidator_code = $formValidator->render();
if (_USE_FCKEDITOR) {
include_once XOOPS_ROOT_PATH . "/modules/tadtools/ck.php";
$ck = new CKEditor("tad_web", "NewsContent", $NewsContent);
$ck->setHeight(300);
$editor = $ck->render();
} else {
$editor = "<textarea name='NewsContent' id='NewsContent' class='span12'>{$NewsContent}</textarea>";
}
$_SHOW_NEWS_PLACE = $_SHOW_NEWS_MASTER = $_USE_NEWS_FORM_DATETIME = $_SHOW_NEWS_URL = $_SHOW_NEWS_TOCAL = $_SHOW_NEWS_UPLOAD = "";
$xoopsTpl->assign('formValidator_code', $formValidator_code);
$xoopsTpl->assign('op', $op);
$xoopsTpl->assign('NewsID', $NewsID);
$xoopsTpl->assign('NewsContent_editor', $editor);
$xoopsTpl->assign('SHOW_NEWS_UPLOAD', _SHOW_NEWS_UPLOAD);
$xoopsTpl->assign('SHOW_NEWS_TOCAL', _SHOW_NEWS_TOCAL);
$xoopsTpl->assign('toCal', $toCal);
$xoopsTpl->assign('USE_NEWS_FORM_DATETIME', _USE_NEWS_FORM_DATETIME);
$xoopsTpl->assign('NewsDate', $NewsDate);
$xoopsTpl->assign('SHOW_NEWS_URL', _SHOW_NEWS_URL);
$xoopsTpl->assign('NewsUrl', $NewsUrl);
$xoopsTpl->assign('SHOW_NEWS_MASTER', _SHOW_NEWS_MASTER);
$xoopsTpl->assign('NewsMaster', $NewsMaster);
$xoopsTpl->assign('SHOW_NEWS_PLACE', _SHOW_NEWS_PLACE);
$xoopsTpl->assign('NewsPlace', $NewsPlace);
$xoopsTpl->assign('NewsTitle', $NewsTitle);
$TadUpFiles->set_col("NewsID", $NewsID);
$upform = $TadUpFiles->upform();
$xoopsTpl->assign('upform', $upform);
}
function tad_web_mems_form($WebID = "0", $MemID = "0")
{
global $xoopsDB, $xoopsUser, $TadUpFiles;
//抓取預設值
if (!empty($MemID)) {
$DBV = get_tad_web_mems($MemID);
$DBV2 = get_tad_web_link_mems($MemID);
} else {
$DBV = $DBV2 = array();
}
//`MemID`, `MemName`, `MemNickName`, `MemSex`, `MemUnicode`, `MemBirthday`, `MemUrl`, `MemClassOrgan`, `MemExpertises`, `uid`, `MemUname`, `MemPasswd`, `MemNum`, `MemSort`, `MemEnable`, `top`, `left`
//設定「MemName」欄位預設值
$MemName = !isset($DBV['MemName']) ? "" : $DBV['MemName'];
//設定「MemNickName」欄位預設值
$MemNickName = !isset($DBV['MemNickName']) ? "" : $DBV['MemNickName'];
//設定「MemSex」欄位預設值
$MemSex = !isset($DBV['MemSex']) ? "" : $DBV['MemSex'];
//設定「MemUnicode」欄位預設值
$MemUnicode = !isset($DBV['MemUnicode']) ? "" : $DBV['MemUnicode'];
//設定「MemBirthday」欄位預設值
$MemBirthday = !isset($DBV['MemBirthday']) ? "" : $DBV['MemBirthday'];
//設定「MemUrl」欄位預設值
$MemUrl = !isset($DBV['MemUrl']) ? "" : $DBV['MemUrl'];
//設定「MemClassOrgan」欄位預設值
$MemClassOrgan = !isset($DBV['MemClassOrgan']) ? "" : $DBV['MemClassOrgan'];
//設定「MemExpertises」欄位預設值
$MemExpertises = !isset($DBV['MemExpertises']) ? "" : $DBV['MemExpertises'];
//設定「uid」欄位預設值
$uid = !isset($DBV['uid']) ? "" : $DBV['uid'];
//設定「MemUname」欄位預設值
$MemUname = !isset($DBV['MemUname']) ? "" : $DBV['MemUname'];
//設定「MemPasswd」欄位預設值
$MemPasswd = !isset($DBV['MemPasswd']) ? "" : $DBV['MemPasswd'];
//設定「MemNum」欄位預設值
$MemNum = !isset($DBV2['MemNum']) ? "" : $DBV2['MemNum'];
//設定「MemSort」欄位預設值
$MemSort = !isset($DBV2['MemSort']) ? "" : $DBV2['MemSort'];
//設定「MemEnable」欄位預設值
$MemEnable = !isset($DBV2['MemEnable']) ? "" : $DBV2['MemEnable'];
//設定「top」欄位預設值
$top = !isset($DBV['top']) ? "" : $DBV['top'];
//設定「left」欄位預設值
$left = !isset($DBV['left']) ? "" : $DBV['left'];
$op = empty($MemID) ? "insert_tad_web_mems" : "update_tad_web_mems";
$TadUpFiles->set_col("MemID", $MemID, 1);
$pic_url = $TadUpFiles->get_pic_file('thumb');
if (empty($pic_url)) {
$pic = $MemSex == '1' ? XOOPS_URL . "/modules/tad_web/images/boy.gif" : XOOPS_URL . "/modules/tad_web/images/girl.gif";
$cover = "";
} else {
$pic = $pic_url;
$cover = "background-size: cover;";
}
$color2 = $MemSex == '1' ? "#000066" : "#660000";
$pic = !empty($MemID) ? "\n <div id='{$MemID}' style='padding: 5px;font-size: 12px; border:0px dotted gray;width:60px;height:50px;background:transparent url({$pic}) top center no-repeat;margin:0px auto;{$cover}'>\n </div>" : "";
if (!file_exists(TADTOOLS_PATH . "/formValidator.php")) {
redirect_header("index.php", 3, _MA_NEED_TADTOOLS);
}
include_once TADTOOLS_PATH . "/formValidator.php";
$formValidator = new formValidator("#myForm", true);
$formValidator_code = $formValidator->render();
if (!empty($MemID)) {
$del_btn = "<a href=\"javascript:delete_student_func({$MemID});\" class='btn btn-danger'>" . _TAD_DEL . "</a>\n ";
} else {
$del_btn = "";
}
$main = "\n {$formValidator_code}\n <script type='text/javascript' src='" . TADTOOLS_URL . "/My97DatePicker/WdatePicker.js'></script>\n <script type='text/javascript'>\n function delete_student_func(MemID){\n var sure = window.confirm('" . _TAD_DEL_CONFIRM . "');\n if (!sure) return;\n location.href=\"{$_SERVER['PHP_SELF']}?op=delete_tad_web_mems&MemID=\" + MemID;\n }\n </script>\n <form action='{$_SERVER['PHP_SELF']}' method='post' id='myForm' enctype='multipart/form-data'>\n <fieldset>\n <legend>" . _MD_TCW_STUDENT_SETUP . "</legend>\n\n <!--學生姓名-->\n <div class='row'>\n <label class='col-md-1'>" . _MD_TCW_MEM_NAME . "</label>\n <div class='col-md-3'>\n <input type='text' name='MemName' value='{$MemName}' id='MemName' class='validate[required] form-control' placeholder='" . _MD_TCW_MEM_NAME . "'>\n </div>\n\n <!--學生暱稱-->\n <label class='col-md-1'>" . _MD_TCW_MEM_NICKNAME . "</label>\n <div class='col-md-3'>\n <input type='text' name='MemNickName' value='{$MemNickName}' id='MemNickName' class='form-control' placeholder='" . _MD_TCW_MEM_NICKNAME . "'>\n </div>\n\n <div class='col-md-4'>\n {$pic}\n </div>\n </div>\n\n\n <div class='row'>\n <!--性別-->\n <label class='col-md-1'>" . _MD_TCW_MEM_SEX . "</label>\n <div class='col-md-3'>\n <select name='MemSex' class='form-control'>\n <option value='1' " . chk($MemSex, '1', '1', 'selected') . ">" . _MD_TCW_BOY . "</option>\n <option value='0' " . chk($MemSex, '0', '0', 'selected') . ">" . _MD_TCW_GIRL . "</option>\n </select>\n </div>\n\n <!--生日-->\n <label class='col-md-1'>" . _MD_TCW_MEM_BIRTHDAY . "</label>\n <div class='col-md-3'>\n <input type='text' name='MemBirthday' value='{$MemBirthday}' id='MemBirthday' class='form-control' onClick=\"WdatePicker({dateFmt:'yyyy-MM-dd' , startDate:'%y-%M-%d}'})\" placeholder='" . _MD_TCW_MEM_BIRTHDAY . "'>\n </div>\n\n <label class='col-md-1'>" . _MD_TCW_UPLOAD_MEM_PHOTO . "</label>\n <div class='col-md-3'>\n <input type='file' name='upfile[]' class='form-control' maxlength='1' accept='gif|jpg|png|GIF|JPG|PNG'>\n </div>\n </div>\n\n\n <div class='row'>\n\n <!--學號-->\n <label class='col-md-1'>" . _MD_TCW_MEM_UNICODE . "</label>\n <div class='col-md-3'>\n <input type='text' name='MemUnicode' value='{$MemUnicode}' id='MemUnicode' class='validate[required] form-control' placeholder='" . _MD_TCW_MEM_UNICODE . "'>\n </div>\n\n <!--座號-->\n <label class='col-md-1'>" . _MD_TCW_MEM_NUM . "</label>\n <div class='col-md-3'>\n <input type='text' name='MemNum' value='{$MemNum}' id='MemNum' class='validate[required] form-control' placeholder='" . _MD_TCW_MEM_NUM . "'>\n </div>\n\n\n <!--是否還在班上-->\n <label class='col-md-1'>" . _MD_TCW_MEM_STATUS . "</label>\n <div class='col-md-3'>\n <select name='MemEnable' id='MemEnable' class='form-control'>\n <option value='1' " . chk($MemEnable, '1', '1', 'selected') . ">" . _MD_TCW_MEM_ENABLE . "</option>\n <option value='0' " . chk($MemEnable, '0', '', 'selected') . ">" . _MD_TCW_MEM_UNABLE . "</option>\n </select>\n </div>\n\n </div>\n\n\n <div class='row'>\n\n <!--帳號-->\n <label class='col-md-1'>" . _MD_TCW_MEM_UNAME . "</label>\n <div class='col-md-3'>\n <input type='text' name='MemUname' value='{$MemUname}' id='MemUname' class='validate[required] form-control' placeholder='" . _MD_TCW_MEM_UNAME . "'>\n </div>\n\n <!--密碼-->\n <label class='col-md-1'>" . _MD_TCW_MEM_PASSWD . "</label>\n <div class='col-md-3'>\n <input type='text' name='MemPasswd' value='{$MemPasswd}' id='MemPasswd' class='validate[required] form-control' placeholder='" . _MD_TCW_MEM_PASSWD . "'>\n </div>\n\n <div class='col-md-4'>\n {$del_btn}\n <input type='hidden' name='WebID' value='{$WebID}'>\n <input type='hidden' name='MemID' value='{$MemID}'>\n <input type='hidden' name='op' value='{$op}'>\n <button type='submit' class='btn btn-primary'>" . _TAD_SAVE . "</button>\n </div>\n </div>\n\n </fieldset>\n </form>\n ";
return $main;
}
function tad_cal_cate_form($cate_sn = "")
{
global $xoopsDB, $xoopsUser, $xoopsTpl;
include_once XOOPS_ROOT_PATH . "/class/xoopsformloader.php";
//include_once(XOOPS_ROOT_PATH."/class/xoopseditor/xoopseditor.php");
//抓取預設值
if (!empty($cate_sn)) {
$DBV = get_tad_cal_cate($cate_sn);
} else {
$DBV = array();
}
//預設值設定
//設定「cate_sn」欄位預設值
$cate_sn = !isset($DBV['cate_sn']) ? "" : $DBV['cate_sn'];
//設定「cate_title」欄位預設值
$cate_title = !isset($DBV['cate_title']) ? _MA_TADCAL_NEW_CALENDAR : $DBV['cate_title'];
//設定「cate_sort」欄位預設值
$cate_sort = !isset($DBV['cate_sort']) ? tad_cal_cate_max_sort() : $DBV['cate_sort'];
//設定「cate_enable」欄位預設值
$cate_enable = !isset($DBV['cate_enable']) ? "" : $DBV['cate_enable'];
//設定「cate_handle」欄位預設值
$cate_handle = !isset($DBV['cate_handle']) ? "" : $DBV['cate_handle'];
//設定「enable_group」欄位預設值
$enable_group = !isset($DBV['enable_group']) ? "" : explode(",", $DBV['enable_group']);
//設定「enable_upload_group」欄位預設值
$enable_upload_group = !isset($DBV['enable_upload_group']) ? array('1') : explode(",", $DBV['enable_upload_group']);
//設定「google_id」欄位預設值
$google_id = !isset($DBV['google_id']) ? "" : $DBV['google_id'];
//設定「google_pass」欄位預設值
$google_pass = !isset($DBV['google_pass']) ? "" : $DBV['google_pass'];
//設定「cate_bgcolor」欄位預設值
$cate_bgcolor = !isset($DBV['cate_bgcolor']) ? "rgb(120,177,255)" : $DBV['cate_bgcolor'];
//設定「cate_color」欄位預設值
$cate_color = !isset($DBV['cate_color']) ? "rgb(255,255,255)" : $DBV['cate_color'];
$op = empty($cate_sn) ? "insert_tad_cal_cate" : "update_tad_cal_cate";
//$op="replace_tad_cal_cate";
//可見群組
$SelectGroup_name = new XoopsFormSelectGroup("", "enable_group", false, $enable_group, 3, true);
$SelectGroup_name->addOption("", _MA_TADCAL_ALL_OK, false);
$SelectGroup_name->setExtra('class="span12 form-control"');
$enable_group = $SelectGroup_name->render();
//可上傳群組
$SelectGroup_name = new XoopsFormSelectGroup("", "enable_upload_group", false, $enable_upload_group, 3, true);
$SelectGroup_name->setExtra('class="span12 form-control"');
$enable_upload_group = $SelectGroup_name->render();
if (!file_exists(TADTOOLS_PATH . "/formValidator.php")) {
redirect_header("index.php", 3, _MA_NEED_TADTOOLS);
}
include_once TADTOOLS_PATH . "/formValidator.php";
$formValidator = new formValidator("#myForm", true);
$formValidator_code = $formValidator->render();
$xoopsTpl->assign('next_op', $op);
$xoopsTpl->assign('cate_sn', $cate_sn);
$xoopsTpl->assign('cate_handle', $cate_handle);
$xoopsTpl->assign('enable_upload_group', $enable_upload_group);
$xoopsTpl->assign('enable_group', $enable_group);
$xoopsTpl->assign('cate_enable1', chk($cate_enable, '1', '1'));
$xoopsTpl->assign('cate_enable0', chk($cate_enable, '0'));
$xoopsTpl->assign('cate_sort', $cate_sort);
$xoopsTpl->assign('cate_color', $cate_color);
$xoopsTpl->assign('cate_bgcolor', $cate_bgcolor);
$xoopsTpl->assign('cate_title', $cate_title);
$xoopsTpl->assign('formValidator_code', $formValidator_code);
$xoopsTpl->assign('google_id', $google_id);
$xoopsTpl->assign('google_pass', $google_pass);
$xoopsTpl->assign('op', 'tad_cal_cate_form');
}
