function tad_web_list_cate()
{
global $xoopsDB, $xoopsTpl, $isAdmin;
$myts = MyTextSanitizer::getInstance();
$sql = "select * from `" . $xoopsDB->prefix("tad_web_cate") . "` where `WebID`='0' and `ColName`='web_cate' and `ColSN`='0' order by `CateSort`";
$result = $xoopsDB->query($sql) or redirect_header($_SERVER['PHP_SELF'], 3, mysql_error());
$all_content = '';
$i = 0;
$web_cate = get_web_cate_arr();
while ($all = $xoopsDB->fetchArray($result)) {
//以下會產生這些變數： $CateID, $WebID, $CateName, $ColName, $ColSN, $CateSort, $CateEnable, $CateCounter
foreach ($all as $k => $v) {
${$k} = $v;
}
//將是/否選項轉換為圖示
$CateEnable = $CateEnable == 1 ? '<img src="' . XOOPS_URL . '/modules/tad_web/images/yes.gif" alt="' . _YES . '" title="' . _YES . '">' : '<img src="' . XOOPS_URL . '/modules/tad_web/images/no.gif" alt="' . _NO . '" title="' . _NO . '">';
//過濾讀出的變數值
$CateName = $myts->htmlSpecialChars($CateName);
$ColName = $myts->htmlSpecialChars($ColName);
$ColSN = $myts->htmlSpecialChars($ColSN);
$all_content[$i]['CateID'] = $CateID;
$all_content[$i]['WebID'] = ${$WebID};
$all_content[$i]['CateName'] = $CateName;
$all_content[$i]['ColName'] = $ColName;
$all_content[$i]['ColSN'] = $ColSN;
$all_content[$i]['CateSort'] = $CateSort;
$all_content[$i]['CateEnable'] = $CateEnable;
$all_content[$i]['CateCounter'] = $CateCounter;
//die(var_export($web_cate[0]));
$all_content[$i]['repository'] = $web_cate[0];
$all_content[$i]['destination'] = $web_cate[$CateID];
$all_content[$i]['web_cate_arr_str'] = implode(",", $web_cate[$CateID]['WebID']);
$all_content[$i]['web_cate_blank_arr'] = implode(",", $web_cate[0]['WebID']);
$i++;
}
//刪除確認的JS
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_obj = new sweet_alert();
$delete_tad_web_cate_func = $sweet_alert_obj->render('delete_tad_web_cate_func', "{$_SERVER['PHP_SELF']}?op=delete_tad_web_cate&CateID=", "CateID");
$xoopsTpl->assign('delete_tad_web_cate_func', $delete_tad_web_cate_func);
$xoopsTpl->assign('tad_web_cate_jquery_ui', get_jquery(true));
$xoopsTpl->assign('bar', $bar);
$xoopsTpl->assign('action', $_SERVER['PHP_SELF']);
$xoopsTpl->assign('isAdmin', $isAdmin);
$xoopsTpl->assign('all_content', $all_content);
}
function list_jill_booking_item()
{
global $xoopsDB, $xoopsTpl, $isAdmin;
$myts =& MyTextSanitizer::getInstance();
$sql = "select * from `" . $xoopsDB->prefix("jill_booking_item") . "` order by `jbi_sort`";
//getPageBar($原sql語法, 每頁顯示幾筆資料, 最多顯示幾個頁數選項);
$PageBar = getPageBar($sql, 20, 10, null, null, $_SESSION['bootstrap']);
$bar = $PageBar['bar'];
$sql = $PageBar['sql'];
$total = $PageBar['total'];
$result = $xoopsDB->query($sql) or redirect_header($_SERVER['PHP_SELF'], 3, mysql_error());
$all_content = "";
$i = 0;
while ($all = $xoopsDB->fetchArray($result)) {
//以下會產生這些變數： $jbi_sn , $jbi_start , $jbi_end , $jbi_title , $jbi_desc , $jbi_approval , $jbi_sort , $jbi_enable
foreach ($all as $k => $v) {
${$k} = $v;
}
//將是/否選項轉換為圖示
$jbi_enable = $jbi_enable == 1 ? '<img src="../images/yes.gif" alt="' . _YES . '" title="' . _YES . '">' : '<img src="../images/no.gif" alt="' . _NO . '" title="' . _NO . '">';
if (empty($jbi_approval)) {
$jbi_approval = '<img src="../images/no.gif" alt="' . _NO . '" title="' . _NO . '">';
} else {
$jbi_approvalArr = explode(";", $jbi_approval);
//die(var_dump($jbi_approvalArr));
$jbi_approval = "";
foreach ($jbi_approvalArr as $approval_uid) {
$jbi_approval .= XoopsUser::getUnameFromId($approval_uid, 1) . ",";
}
$jbi_approval = substr($jbi_approval, 0, -1);
}
//過濾讀出的變數值
$jbi_start = $myts->htmlSpecialChars($jbi_start);
$jbi_end = $myts->htmlSpecialChars($jbi_end);
$jbi_title = $myts->htmlSpecialChars($jbi_title);
$jbi_desc = $myts->displayTarea($jbi_desc, 1, 1, 1, 1, 0);
$all_content[$i]['jbi_sn'] = $jbi_sn;
$all_content[$i]['jbi_start'] = $jbi_start;
$all_content[$i]['jbi_end'] = $jbi_end;
$all_content[$i]['jbi_title_link'] = "<a href='{$_SERVER['PHP_SELF']}?jbi_sn={$jbi_sn}'>{$jbi_title}</a>";
$all_content[$i]['jbi_title'] = $jbi_title;
$all_content[$i]['jbi_desc'] = $jbi_desc;
$all_content[$i]['jbi_approval'] = $jbi_approval;
$all_content[$i]['jbi_sort'] = $jbi_sort;
$all_content[$i]['jbi_enable'] = $jbi_enable;
++$i;
}
//刪除確認的JS
$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_item');
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_item_func = $sweet_alert->render('delete_jill_booking_item_func', "{$_SERVER['PHP_SELF']}?op=delete_jill_booking_item&jbi_sn=", "jbi_sn");
$xoopsTpl->assign('delete_jill_booking_item_func', $delete_jill_booking_item_func);
}
function jill_booking_list($def_jbi_sn = "")
{
global $xoopsDB, $xoopsTpl, $xoopsUser, $isAdmin, $Isapproval;
if (!$xoopsUser) {
return;
}
//場地設定
$item_opt = get_jill_booking_time_options($def_jbi_sn);
$xoopsTpl->assign('item_opt', $item_opt);
$where_jbisn = empty($def_jbi_sn) ? "" : " and c.jbi_sn='{$def_jbi_sn}' ";
$uid = $xoopsUser->uid();
$myts =& MyTextSanitizer::getInstance();
$sql = "select a.jb_sn,a.jb_date,a.jbt_sn,a.jb_waiting,a.jb_status,b.jb_uid,b.jb_booking_time,b.jb_booking_content,b.jb_start_date,b.jb_end_date,c.jbi_sn,c.jbt_title,c.jbt_sort,d.jbi_title,d.jbi_approval\n from `" . $xoopsDB->prefix("jill_booking_date") . "` as a\n join `" . $xoopsDB->prefix("jill_booking") . "` as b on a.jb_sn=b.jb_sn\n join `" . $xoopsDB->prefix("jill_booking_time") . "` as c on a.jbt_sn=c.jbt_sn\n join `" . $xoopsDB->prefix("jill_booking_item") . "` as d on c.jbi_sn=d.jbi_sn\n where b.`jb_uid`='{$uid}' {$where_jbisn} order by a.jb_status desc,a.`jb_date` desc,a.`jb_waiting`,a.jbt_sn ";
//die($sql);
//getPageBar($原sql語法, 每頁顯示幾筆資料, 最多顯示幾個頁數選項);
$PageBar = getPageBar($sql, 20, 10, null, null, $_SESSION['bootstrap']);
$bar = $PageBar['bar'];
$sql = $PageBar['sql'];
$total = $PageBar['total'];
$result = $xoopsDB->query($sql) or redirect_header($_SERVER['PHP_SELF'], 3, mysql_error());
$all_content = "";
$i = 0;
while ($all = $xoopsDB->fetchArray($result)) {
//以下會產生這些變數：jb_sn,jb_date,jbt_sn,,jb_waiting,jb_status,jb_uid,jb_booking_time,jb_booking_content,jb_start_date,jb_end_date,jbi_sn,jbt_title,jbt_sort,jbi_title,jbi_approval
foreach ($all as $k => $v) {
${$k} = $v;
}
//過濾讀出的變數值
$jb_booking_content = $myts->displayTarea($jb_booking_content, 1, 1, 0, 1, 0);
$jb_start_date = $myts->htmlSpecialChars($jb_start_date);
$jb_end_date = $myts->htmlSpecialChars($jb_end_date);
$all_content[$i]['jb_sn'] = $jb_sn;
$all_content[$i]['jb_date'] = $jb_date;
$all_content[$i]['jbt_sn'] = $jbt_sn;
$all_content[$i]['primary'] = $jbi_sn . "_" . $jb_date . "_" . $jbt_sn;
$all_content[$i]['jb_waiting'] = $jb_waiting;
$all_content[$i]['jb_status'] = $jb_status;
$all_content[$i]['jb_uid'] = XoopsUser::getUnameFromId($jb_uid, 1);
$all_content[$i]['jb_booking_time'] = $jb_booking_time;
$all_content[$i]['jb_booking_content'] = $jb_booking_content;
$all_content[$i]['jb_start_date'] = $jb_start_date;
$all_content[$i]['jb_end_date'] = $jb_end_date;
$all_content[$i]['jbi_sn'] = $jbi_sn;
$all_content[$i]['jbt_title'] = $jbt_title;
$all_content[$i]['jbt_sort'] = $jbt_sort;
$all_content[$i]['jbi_title'] = $jbi_title;
$all_content[$i]['jbi_approval'] = $jbi_approval;
$today = date("Y-m-d");
$all_content[$i]['fun'] = strtotime($jb_date) >= strtotime($today) ? 1 : '';
$i++;
}
//刪除確認的JS
$xoopsTpl->assign('bar', $bar);
$xoopsTpl->assign('action', $_SERVER['PHP_SELF']);
$xoopsTpl->assign('isAdmin', $isAdmin);
$xoopsTpl->assign('all_content', $all_content);
$xoopsTpl->assign('now_op', 'jill_booking_list');
if (!file_exists(XOOPS_ROOT_PATH . "/modules/tadtools/sweet_alert.php")) {
redirect_header("index.php", 3, _MD_NEED_TADTOOLS);
}
include_once XOOPS_ROOT_PATH . "/modules/tadtools/sweet_alert.php";
$sweet_alert = new sweet_alert();
$delete_jill_booking_func = $sweet_alert->render('delete_jill_booking_func', "{$_SERVER['PHP_SELF']}?op=delete_jill_booking&primary=", "primary");
$xoopsTpl->assign('delete_jill_booking_func', $delete_jill_booking_func);
}
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 jill_booking_approvallist($jbi_sn = "")
{
global $xoopsDB, $xoopsTpl, $xoopsUser, $isAdmin;
$uid = $xoopsUser->uid();
$myts =& MyTextSanitizer::getInstance();
//場地設定
$item_opt = get_jill_booking_time_options($jbi_sn, $uid);
//die(var_export($item_opt));
if (!empty($jbi_sn)) {
$itemArr = get_jill_booking_item($jbi_sn, 1);
$checkapproval = explode(";", $itemArr['jbi_approval']);
if (in_array($uid, $checkapproval)) {
$sql = "select b.jb_sn,b.jbt_sn,b.jb_date,b.jb_waiting,b.jb_status,c.jbi_sn,c.jbt_title,d.jb_uid,d.jb_booking_time,d.jb_booking_content,d.jb_start_date,d.jb_end_date from `" . $xoopsDB->prefix("jill_booking_date") . "` as b\n join `" . $xoopsDB->prefix("jill_booking_time") . "` as c on b.jbt_sn=c.jbt_sn\n join `" . $xoopsDB->prefix("jill_booking") . "` as d on b.jb_sn=d.jb_sn\n where c.jbi_sn='{$jbi_sn}' && b.jb_status='0' && b.jb_date>= ' " . date("Y-m-d", xoops_getUserTimestamp(time())) . " ' order by b.jb_date ,b.jbt_sn,d.jb_booking_time";
//die($sql);
//getPageBar($原sql語法, 每頁顯示幾筆資料, 最多顯示幾個頁數選項);
$PageBar = getPageBar($sql, 20, 10, null, null, $_SESSION['bootstrap']);
$bar = $PageBar['bar'];
$sql = $PageBar['sql'];
$total = $PageBar['total'];
$result = $xoopsDB->query($sql) or redirect_header($_SERVER['PHP_SELF'], 3, mysql_error());
$all_content = "";
$i = 0;
while ($all = $xoopsDB->fetchArray($result)) {
//以下會產生這些變數： a.jb_sn,a.jb_week,a.jbt_sn,b.jb_date,b.jb_waiting,b.jb_status,c.jbi_sn,c.jbt_title,c.jbt_sort,c.jbt_week,d.jb_uid,d.jb_booking_time,d.jb_booking_content,d.jb_start_date,d.jb_end_date
foreach ($all as $k => $v) {
${$k} = $v;
}
//過濾讀出的變數值
$jb_booking_content = $myts->displayTarea($jb_booking_content, 1, 1, 0, 1, 0);
$jb_start_date = $myts->htmlSpecialChars($jb_start_date);
$jb_end_date = $myts->htmlSpecialChars($jb_end_date);
$all_content[$i]['jb_sn'] = $jb_sn;
$all_content[$i]['jbt_sn'] = $jbt_sn;
$all_content[$i]['jb_date'] = $jb_date;
$all_content[$i]['jb_week'] = date('w', strtotime($jb_date));
$all_content[$i]['jb_waiting'] = $jb_waiting;
$all_content[$i]['jb_status'] = $jb_status;
$all_content[$i]['jbi_sn'] = $jbi_sn;
$all_content[$i]['jbt_title'] = $jbt_title;
$all_content[$i]['jb_uid'] = XoopsUser::getUnameFromId($jb_uid, 1);
$all_content[$i]['jb_booking_time'] = $jb_booking_time;
$all_content[$i]['jb_booking_content'] = $jb_booking_content;
$all_content[$i]['jb_start_date'] = $jb_start_date;
$all_content[$i]['jb_end_date'] = $jb_end_date;
$i++;
}
}
}
//die(var_dump($all_content));
//刪除確認的JS
if (!file_exists(XOOPS_ROOT_PATH . "/modules/tadtools/sweet_alert.php")) {
redirect_header("index.php", 3, _MD_NEED_TADTOOLS);
}
include_once XOOPS_ROOT_PATH . "/modules/tadtools/sweet_alert.php";
$sweet_alert = new sweet_alert();
$delete_jill_booking_func = $sweet_alert->render('delete_jill_booking_func', "{$_SERVER['PHP_SELF']}?op=delete_booking&jb_info=", "jb_info");
$xoopsTpl->assign('delete_jill_booking_func', $delete_jill_booking_func);
$xoopsTpl->assign('bar', $bar);
$xoopsTpl->assign('action', $_SERVER['PHP_SELF']);
$xoopsTpl->assign('isAdmin', $isAdmin);
$xoopsTpl->assign('item_opt', $item_opt);
$xoopsTpl->assign('all_content', $all_content);
$xoopsTpl->assign('now_op', 'jill_booking_approvallist');
}
