0) { $shop_no = intval(pg_result($rtn,0,"shop_no")); $worker_disp_num = intval(pg_result($rtn,0,"worker_disp_num")); $worker_disp_num_mob = intval(pg_result($rtn,0,"worker_disp_num_mob")); $syukkin_dd_num = intval(pg_result($rtn,0,"syukkin_dd_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")); } 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); if (!is_array($worker_det)) { $worker_det = array(); } $syukkin_list = get_syukkin($shop_no); //出勤表切替設定 if ($syukkin_chg == "") { $syukkin_chg = 0; } if ($syukkin_chg > 12) { $chg_pat = 1; } else { $chg_pat = 2; } $now_hour = date("G",time()); switch ($chg_pat) { case 1: if ($now_hour >= $syukkin_chg) { $day_pat = array ( 0=>"('today'::date+'1day'::interval)::date", 1=>"('today'::date+'2day'::interval)::date", 2=>"('today'::date+'3day'::interval)::date", 3=>"('today'::date+'4day'::interval)::date", 4=>"('today'::date+'5day'::interval)::date", 5=>"('today'::date+'6day'::interval)::date", 6=>"('today'::date+'7day'::interval)::date" ); } else { $day_pat = array ( 0=>"'today'::date", 1=>"('today'::date+'1day'::interval)::date", 2=>"('today'::date+'2day'::interval)::date", 3=>"('today'::date+'3day'::interval)::date", 4=>"('today'::date+'4day'::interval)::date", 5=>"('today'::date+'5day'::interval)::date", 6=>"('today'::date+'6day'::interval)::date" ); } break; case 2: default: if ($now_hour < $syukkin_chg) { $day_pat = array ( 0=>"('today'::date-'1day'::interval)::date", 1=>"'today'::date", 2=>"('today'::date+'1day'::interval)::date", 3=>"('today'::date+'2day'::interval)::date", 4=>"('today'::date+'3day'::interval)::date", 5=>"('today'::date+'4day'::interval)::date", 6=>"('today'::date+'5day'::interval)::date" ); } else { $day_pat = array ( 0=>"'today'::date", 1=>"('today'::date+'1day'::interval)::date", 2=>"('today'::date+'2day'::interval)::date", 3=>"('today'::date+'3day'::interval)::date", 4=>"('today'::date+'4day'::interval)::date", 5=>"('today'::date+'5day'::interval)::date", 6=>"('today'::date+'6day'::interval)::date" ); } break; } $sql = "select ".$day_pat[0]." as a,".$day_pat[1]." as b,".$day_pat[2]." as c,".$day_pat[3]." as d,".$day_pat[4]." as e,".$day_pat[5]." as f,".$day_pat[6]." as g"; //die($sql); $rtn = m_pg_exec($conn,$sql); $date_list[0] = pg_result($rtn,0,'a'); $date_list[1] = pg_result($rtn,0,'b'); $date_list[2] = pg_result($rtn,0,'c'); $date_list[3] = pg_result($rtn,0,'d'); $date_list[4] = pg_result($rtn,0,'e'); $date_list[5] = pg_result($rtn,0,'f'); $date_list[6] = pg_result($rtn,0,'g'); $date_list[0] = mb_convert_encoding($date_list[0],VIEWCODE,"sjis-win"); $date_list[1] = mb_convert_encoding($date_list[1],VIEWCODE,"sjis-win"); $date_list[2] = mb_convert_encoding($date_list[2],VIEWCODE,"sjis-win"); $date_list[3] = mb_convert_encoding($date_list[3],VIEWCODE,"sjis-win"); $date_list[4] = mb_convert_encoding($date_list[4],VIEWCODE,"sjis-win"); $date_list[5] = mb_convert_encoding($date_list[5],VIEWCODE,"sjis-win"); $date_list[6] = mb_convert_encoding($date_list[6],VIEWCODE,"sjis-win"); $dispdate_list[0] = date('n月j日',strtotime($date_list[0].' 00:00')); $dispdate_list[1] = date('n月j日',strtotime($date_list[1].' 00:00')); $dispdate_list[2] = date('n月j日',strtotime($date_list[2].' 00:00')); $dispdate_list[3] = date('n月j日',strtotime($date_list[3].' 00:00')); $dispdate_list[4] = date('n月j日',strtotime($date_list[4].' 00:00')); $dispdate_list[5] = date('n月j日',strtotime($date_list[5].' 00:00')); $dispdate_list[6] = date('n月j日',strtotime($date_list[6].' 00:00')); $dispyoubi_list[0] = date('w',strtotime($date_list[0].' 00:00')); $dispyoubi_list[1] = date('w',strtotime($date_list[1].' 00:00')); $dispyoubi_list[2] = date('w',strtotime($date_list[2].' 00:00')); $dispyoubi_list[3] = date('w',strtotime($date_list[3].' 00:00')); $dispyoubi_list[4] = date('w',strtotime($date_list[4].' 00:00')); $dispyoubi_list[5] = date('w',strtotime($date_list[5].' 00:00')); $dispyoubi_list[6] = date('w',strtotime($date_list[6].' 00:00')); foreach ($dispyoubi_list as $youbi_k=>$youbi_v) { switch ($youbi_v) { case 0 : $dispyoubi_list[$youbi_k] = "日"; $dispyoubi_color[$youbi_k]['start'] = "sun"; $dispyoubi_color[$youbi_k]['end'] = ""; break; case 1 : $dispyoubi_list[$youbi_k] = "月"; $dispyoubi_color[$youbi_k]['start'] = "nomal"; $dispyoubi_color[$youbi_k]['end'] = ""; break; case 2 : $dispyoubi_list[$youbi_k] = "火"; $dispyoubi_color[$youbi_k]['start'] = "nomal"; $dispyoubi_color[$youbi_k]['end'] = ""; break; case 3 : $dispyoubi_list[$youbi_k] = "水"; $dispyoubi_color[$youbi_k]['start'] = "nomal"; $dispyoubi_color[$youbi_k]['end'] = ""; break; case 4 : $dispyoubi_list[$youbi_k] = "木"; $dispyoubi_color[$youbi_k]['start'] = "nomal"; $dispyoubi_color[$youbi_k]['end'] = ""; break; case 5 : $dispyoubi_list[$youbi_k] = "金"; $dispyoubi_color[$youbi_k]['start'] = "nomal"; $dispyoubi_color[$youbi_k]['end'] = ""; break; case 6 : $dispyoubi_list[$youbi_k] = "土"; $dispyoubi_color[$youbi_k]['start'] = "sat"; $dispyoubi_color[$youbi_k]['end'] = ""; break; default: $dispyoubi_list[$youbi_k] = ""; break; } } /* 動画 */ $sql = "select view_type from event2 where del_flag = 0 and (timer_type = 0 or (timer_type = 1 and timer_start <= now() and timer_end >= now())) group by view_type;"; $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[$obj->view_type] = 1; } } /* そくヒメリスト */ $sql = "select * from schedule_view_msg where sv_date = '".$date_list[0]."'"; $rtn = m_pg_exec($conn, $sql); $num = pg_num_rows($rtn); $svm_list = array(); if ($num > 0) { for ($i=0 ; $i<$num ; $i++) { $obj = pg_fetch_object($rtn, $i); $svm_list[$obj->sv_worker_no]["sv_no"] = $obj->sv_no; $svm_list[$obj->sv_worker_no]["sv_date"] = $obj->sv_date; $svm_list[$obj->sv_worker_no]["sv_type"] = $obj->sv_type; $svm_list[$obj->sv_worker_no]["sv_next_time"] = $obj->sv_next_time; $svm_list[$obj->sv_worker_no]["sv_plus_select"] = $obj->sv_plus_select; $svm_list[$obj->sv_worker_no]["sv_plus_text"] = $obj->sv_plus_text; $svm_list[$obj->sv_worker_no]["sv_plus_num"] = $obj->sv_plus_num; $svm_list[$obj->sv_worker_no]["sv_input_date"] = $obj->sv_input_date; $svm_list[$obj->sv_worker_no]["sv_renew_date"] = $obj->sv_renew_date; } } $header_type_check = "cast"; ?>

Girls List

在籍女の子一覧