6) { $cd = 0; }
$sql = "select * from m_shop where shop_code='${s}'";
$rtn = m_pg_exec($conn,$sql);
if (pg_numrows($rtn) > 0) {
$shop_no = intval(pg_result($rtn,0,"shop_no"));
$syukkin_pat = intval(pg_result($rtn,0,"syukkin_pat"));
$worker_disp_num_mob = intval(pg_result($rtn,0,"worker_disp_num_mob"));
$syukkin_dd_num = intval(pg_result($rtn,0,"syukkin_dd_num"));
$syukkin_1line_disp_num = intval(pg_result($rtn,0,"syukkin_1line_disp_num"));
$eigyou_st = pg_result($rtn,0,"eigyou_st");
$eigyou_ed = pg_result($rtn,0,"eigyou_ed");
$syukkin_chg = intval(pg_result($rtn,0,"syukkin_chg"));
$syukkin_comment_use = pg_result($rtn,0,"syukkin_comment_use");
$worker_disp_num = $syukkin_1line_disp_num;
}
else {
echo "店舗情報がありません。";
exit;
}
require_once $_SERVER['DOCUMENT_ROOT']."/ism_get_shop.php";
require_once $_SERVER['DOCUMENT_ROOT']."/ism_get_worker.php";
require_once $_SERVER['DOCUMENT_ROOT']."/ism_get_syukkin.php";
require_once $_SERVER['DOCUMENT_ROOT']."/error_report.php";
require_once $_SERVER['DOCUMENT_ROOT']."/ismsis/koe/common.php";
//在籍者情報を抽出
$shop_det = get_shop($shop_no);
$worker_det = get_worker_list($shop_no);
$syukkin_list = get_syukkin($shop_no);
/* 動画 */
$sql = "select * from event2 where del_flag = 0 and (timer_type = 0 or (timer_type = 1 and timer_start <= now() and timer_end >= now())) order by del_flag,view_no,input_date desc;";
$rtn = m_pg_exec($conn,$sql);
$num = pg_num_rows($rtn);
$movie_list = array();
if ($num > 0) {
for ($i=0 ; $i<$num ; $i++) {
$obj = pg_fetch_object($rtn, $i);
$movie_list[$i]["event_no"] = $obj->event_no;
$movie_list[$i]["event_name"] = mb_convert_encoding($obj->event_name,VIEWCODE,"sjis-win");
$movie_list[$i]["event_image"] = $obj->event_image;
$movie_list[$i]["event_image_top"] = $obj->event_image_top;
$movie_list[$i]["view_type"] = $obj->view_type;
$movie_list[$i]["input_date"] = $obj->input_date;
}
}
if (!is_array($worker_det)) {
$worker_det = array();
}
$header_type_check = "movie";
?>
動画一覧
$value){ ?>