require_once $_SERVER['DOCUMENT_ROOT']."/ismsis/lib/vars.php";
require_once $_SERVER['DOCUMENT_ROOT']."/ismsis/lib/func_postgres.php";
require_once $_SERVER['DOCUMENT_ROOT']."/ismsis/lib/bbs_setting.php";
$conn = m_pg_conn();
//店舗NoをGET
$s = 'purazatenfuji';
$shop_no = $s;
//不正なフォーマットの場合exit;
if ($shop_no == "") {
echo "shop_no format inaccurate!";
exit;
}
$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;
$newwin_x = pg_result($rtn,0,"newly_info_openwin_x");
$newwin_y = pg_result($rtn,0,"newly_info_openwin_y");
$newly_info_paging_num_pc = pg_result($rtn,0,"newly_info_paging_num_pc");
if (empty($newly_info_paging_num_pc)) $newly_info_paging_num_pc = 0;
} else {
echo "店舗情報がありません。";
exit;
}
$sql = "select * from event where (del_flag = 0 or del_flag = 2) and (view_type = 1 or view_type = 4) 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);
$event_list = array();
if ($num > 0) {
for ($i=0 ; $i<$num ; $i++) {
$obj = pg_fetch_object($rtn, $i);
$event_list[$i]["event_no"] = $obj->event_no;
$event_list[$i]["event_name"] = mb_convert_encoding($obj->event_name,VIEWCODE,"sjis-win");
$event_list[$i]["event_image"] = $obj->event_image;
$event_list[$i]["event_image_top"] = $obj->event_image_top;
$event_list[$i]["event_text"] = str_replace("\n","
",mb_convert_encoding($obj->event_text,VIEWCODE,"sjis-win"));
$event_list[$i]["event_url"] = mb_convert_encoding($obj->event_url,VIEWCODE,"sjis-win");
}
}
$header_type_check = "event";
?>