function list_photos($csn = "", $uid = "")
{
global $xoopsModuleConfig, $xoopsTpl, $tadgallery;
if (!file_exists(XOOPS_ROOT_PATH . "/modules/tadtools/fancybox.php")) {
redirect_header("index.php", 3, _MA_NEED_TADTOOLS);
}
include_once XOOPS_ROOT_PATH . "/modules/tadtools/fancybox.php";
if ($csn) {
$tadgallery->set_orderby("photo_sort");
$tadgallery->set_view_csn($csn);
$tadgallery->set_only_thumb($xoopsModuleConfig['only_thumb']);
$cate = $tadgallery->get_tad_gallery_cate($csn);
$xoopsTpl->assign("cate", $cate);
$upload_powers = $tadgallery->chk_cate_power("upload");
if ($upload_powers) {
include_once XOOPS_ROOT_PATH . "/modules/tadtools/jeditable.php";
$file = "save.php";
$jeditable = new jeditable();
$jeditable->setTextAreaCol("#content", $file, '90%', '100px', "{'csn':{$csn},'op' : 'save'}", _MD_TADGAL_EDIT_CATE_CONTENT);
$jeditable_set = $jeditable->render();
$xoopsTpl->assign("jeditable_set", $jeditable_set);
}
} else {
$tadgallery->set_orderby("rand");
$tadgallery->set_limit($xoopsModuleConfig['thumbnail_number']);
}
$tadgallery->get_photos();
$tadgallery->get_albums();
$cate_fancybox = new fancybox('.editbtn');
$cate_fancybox_code = $cate_fancybox->render(false);
$xoopsTpl->assign('cate_fancybox_code', $cate_fancybox_code);
if (!file_exists(XOOPS_ROOT_PATH . "/modules/tadtools/colorbox.php")) {
redirect_header("index.php", 3, _MA_NEED_TADTOOLS);
}
include_once XOOPS_ROOT_PATH . "/modules/tadtools/colorbox.php";
$colorbox = new colorbox('.Photo');
$colorbox_code = $colorbox->render(false);
$xoopsTpl->assign('colorbox_code', $colorbox_code);
$xoopsTpl->assign('only_thumb', $xoopsModuleConfig['only_thumb']);
}
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));
}
