<?php
require_once('config.inc.php');

$target_time    = ((int)date('H') < $config_shop['switch_day_hour']) ? BASE_TIME - 86400 : BASE_TIME;
$sql_YYYY       = funSqlText(date('Y', $target_time));
$sql_MM         = funSqlText(date('n', $target_time));
$sql_DD         = funSqlText(date('j', $target_time));


//************************************************
//* 待機情報
//************************************************
// $target_time    = BASE_TIME;
// $target_time    = ((int)date('H', $target_time) < $config_shop['switch_day_hour']) ? $target_time - 86400 : $target_time;
// $target_hour    = ((int)date('H', $target_time) >= 0 && (int)date('H', $target_time) < $config_shop['switch_day_hour']) ? (int)date('H', $target_time) + 24 : (int)date('H', $target_time);
// $target_minute  = (int)date('i', $target_time);
// $target_minutes = $target_hour * 60 + $target_minute;

// $print_today = date('m', $target_time).'月'.date('d', $target_time).'日';

// $sql = '
//     SELECT
//         23INHH,
//         23INMM,
//         23OUTHH,
//         23OUTMM,
//         23WorkFlg,
//         23StandFlg,
//         23EMHH,
//         23EMMM,
//         06PresonID,
//         06Name,
//         06Age,
//         06He,
//         06B,
//         06W,
//         06H,
//         06Cup,
//         CAST(CONCAT(23INHH, LPAD(23INMM, 2, 0)) AS UNSIGNED) AS start_time,
//         CAST(CONCAT(23OUTHH, LPAD(23OUTMM, 2, 0)) AS UNSIGNED) AS finish_time,
//         CAST(CONCAT(23EMHH, LPAD(23EMMM, 2, 0)) AS UNSIGNED) AS waiting_time,
//         CASE
//             WHEN 23EMHH >= 23INHH THEN (23EMHH * 60 + 23EMMM) - '.$target_minutes.' + 1
//             ELSE (23INHH * 60 + 23INMM) - '.$target_minutes.' + 1
//         END wait_interval,
//         CASE
//             WHEN 23StandFlg=0 THEN  0 /* なし */
//             WHEN 23StandFlg=3 THEN  1 /* LAST1 */
//             WHEN 23StandFlg=2 THEN 20 /* 予約受付中 */
//             WHEN 23StandFlg=1 THEN 30 /* SOLDOUT */
//             WHEN 23StandFlg=4 THEN 40 /* 当日欠勤 */
//             ELSE 1
//         END status,
//         CASE
//             WHEN 23EMHH=99 THEN 1
//             ELSE 0
//         END wait_last_flag,
//         CASE
//             WHEN 101DivisionFlg7 = 0 THEN 0
//             ELSE 1
//         END discount_order
//     FROM
//         23MPSchedule
//         LEFT JOIN 06Person
//             ON 06ID=23ID
//             AND 06PresonID=23PresonID
//         LEFT JOIN 101MPDivisionFlg
//             ON 06ID=101ID
//             AND 06PresonID=101PresonID
//     WHERE
//         23YYYY="'.date('Y', $target_time).'"
//         AND 23MM="'.date('n', $target_time).'"
//         AND 23DD="'.date('j', $target_time).'"
//         AND 23WorkFlg=1
//         AND 06DisPub=1
//         AND (23StandFlg=0 OR 23StandFlg=3)
//     ORDER BY
//         status,
//         wait_interval,
//         start_time,
//         finish_time,
//         06Row
// ';
// $result = mysql_query($sql, $conn);

// $html_now = '';
// $include_slider_script = 'jquery.bxsliderfixed.js';
// if(mysql_num_rows($result) > 0){
//     // 表示人数によって読み込むJSを変更
//     if(mysql_num_rows($result) > 4){
//         $include_slider_script = 'jquery.bxslider.js';
//     }else{
//         $include_slider_script = 'jquery.bxsliderfixed.js';
//         //$include_slider_script = 'jquery.bxslider.js';
//     }
//     $i = 0;
//     while($ary_row = mysql_fetch_assoc($result)){
//         $person_id               = $ary_row['06PresonID'];
//         $person_name             = $ary_row['06Name'];
//         $person_age              = $ary_row['06Age'];
//         $person_height           = $ary_row['06He'];
//         $person_bust             = $ary_row['06B'];
//         $person_bustcup          = $ary_row['06Cup'];
//         $person_waist            = $ary_row['06W'];
//         $person_hip              = $ary_row['06H'];
//         $schedule_status         = $ary_row['23StandFlg'];
//         $schedule_wait_interval  = $ary_row['wait_interval'];
//         $schedule_wait_last_flag = $ary_row['wait_last_flag'];

//         // 出勤時間(表示用)
//         $schedule_start  = '';
//         $schedule_start .= ($ary_row['23INHH'] > 24) ? $ary_row['23INHH'] - 24 : $ary_row['23INHH'];
//         $schedule_start .= ':';
//         $schedule_start .= sprintf('%02d', $ary_row['23INMM']);
//         // 退勤時間(表示用)
//         $schedule_finish = '';
//         if($ary_row['23OUTHH'] == 99){
//             $schedule_finish .= 'LAST';
//         }else{
//             $schedule_finish .= ($ary_row['23OUTHH'] > 24) ? $ary_row['23OUTHH'] - 24 : $ary_row['23OUTHH'];
//             $schedule_finish .= ':';
//             $schedule_finish .= sprintf('%02d', $ary_row['23OUTMM']);
//         }

//         // サムネイル
//         $dir      = './images/person/'.$person_id.'/';
//         $filename = isExistTheImage($dir, 'ImageThum');
//         if($filename != ''){
//             $thumbnail_filepath = $dir.$filename;
//         }else{
//             $thumbnail_filepath = './img/noimg/170_227.jpg';
//         }

//         // ランクアイコン
//         // ※0がTrueで1がFalseになってるので注意！
//         $sql2    = 'SELECT 101DivisionFlg1, 101DivisionFlg2, 101DivisionFlg3, 101DivisionFlg4, 101DivisionFlg5, 101DivisionFlg6, 101DivisionFlg7 FROM 101MPDivisionFlg WHERE 101PresonID='.$person_id;
//         $result2 = mysql_query($sql2, $conn);
//         if(mysql_num_rows($result2)){
//             while($ary_row2 = mysql_fetch_assoc($result2)){
//                 $ary_rank_flg['premium']    = $ary_row2['101DivisionFlg1']; // プレミアムアイコンのフラグ
//                 //$ary_rank_flg['']         = $ary_row2['101DivisionFlg2'];
//                 $ary_rank_flg['vip']        = $ary_row2['101DivisionFlg3']; // ビップアイコンのフラグ
//                 $ary_rank_flg['royalvip']   = $ary_row2['101DivisionFlg4']; // ロイヤルビップアイコンのフラグ
//                 $ary_rank_flg['queen']      = $ary_row2['101DivisionFlg5']; // クイーンアイコンのフラグ
//                 $ary_rank_flg['mervis']     = $ary_row2['101DivisionFlg6']; // メルビスアイコンのフラグ
//                 $ary_rank_flg['discount']   = $ary_row2['101DivisionFlg7']; // 割引対象のフラグ
//             }
//         }
//         if($ary_rank_flg['premium'] == 0){
//             $person_rank_icon   = '<img src="img/rank/premium.png" alt="プレミアム">';
//         }else if($ary_rank_flg['vip'] == 0){
//             $person_rank_icon   = '<img src="img/rank/vip.png" alt="ビップ">';
//         }else if($ary_rank_flg['royalvip'] == 0){
//             $person_rank_icon   = '<img src="img/rank/royal.png" alt="ロイヤルビップ">';
//         }else if($ary_rank_flg['queen'] == 0){
//             $person_rank_icon   = '<img src="img/rank/queen.png" alt="クイーン">';
//         }else if($ary_rank_flg['mervis'] == 0){
//             $person_rank_icon   = '<img src="img/rank/mervis.png" alt="メルビス">';
//         }else{
//             $person_rank_icon   = '<img src="img/rank/basic.png" alt="ベーシック">';
//         }
//         // 割引対象の場合は他のアイコンを上書きして優先表示
//         if($ary_rank_flg['discount'] == 0){
//             $person_rank_icon   = '<img src="img/rank/disicon.png" alt="割引対象">';
//         }

//         // スターテスアイコン
//         $schedule_status_msg = '<time class="time">&nbsp;</time>';
//         switch($schedule_status){
//             case 0:
//                 // 待ち時間表示は当日の出勤情報のみ表示
//                 if(!$schedule_wait_last_flag){
//                     if($schedule_wait_interval <= 0){
//                         $schedule_status_msg = '<time class="now_waiting"><img src="img/icon/chance.gif" width="166" height="18" alt="今すぐのご案内可能です♪" /></time>';
//                     }else{
//                         $schedule_status_msg = '<time class="time">あと'.$schedule_wait_interval.'分</time>';
//                     }
//                 }
//                 break;
//             case 3:
//                 $schedule_status_msg = '<time class="time">LAST 1</time>';
//                 break;
//             default:
//                 $schedule_status_msg = '<time class="time">&nbsp;</time>';
//                 break;
//         }

//         // HTML
//         $html_now .= '
//             <div class="list">
//                 <a href="profile.html?PresonID='.$person_id.'">
//                     <span class="rank">'.$person_rank_icon.'</span>
//                     <p class="thumb"><img src="'.$thumbnail_filepath.'" width="170" alt="あかり"></p>
//                     <p class="name">'.$person_name.'('.$person_age.')</p>
//                     <p class="size">'.$person_height.'&nbsp;.'.$person_bust.'('.$person_bustcup.')&nbsp;.'.$person_waist.'&nbsp;.'.$person_hip.'</p>
//                     '.$schedule_status_msg.'
//                     <p class="btn"><img src="img/btn/profile_schedule_prof.png" alt="プロフィールを見る" /></p>
//                 </a>
//             </div>
//         ';
//         $i ++;
//     }
//     if($i < 4){
//         for($ii = $i; $ii < 4; $ii ++){
//             // HTML今すぐ
//             $html_now .= '
//                 <div class="list">
//                 </div>
//             ';
//         }
//     }
// }
//************************************************


//************************************************
//* 新着情報
//************************************************
// SELECTコマンドを実行してデータを取得する
$sql  = "SELECT * FROM 04Newtop ";
$sql .= "WHERE ";
$sql .= "04ID=$sql_Id AND 04DelFlg=0 AND 04DisPub=1 ";
$sql .= "ORDER BY 04IYY DESC, 04IMM DESC, 04IDD DESC, 04IHH DESC, 04III DESC, 04ISS DESC, 04PresonID DESC ";
$sql .= "LIMIT 2 ";

$res = mysql_query($sql, $conn);
while ($row = mysql_fetch_array($res, MYSQL_ASSOC)) {
    $IYY = $row["04IYY"];
    $IMM = $row["04IMM"];
    $IDD = $row["04IDD"];

    $obj_NewDate  = date('Y').'.'.date('n').'.'.date('j').'&nbsp;'.date('H').':'.date('i');
    $obj_Title    = $row["04Title"];
    $obj_PresonID = $row["04PresonID"];
    $obj_Comment  = htmlspecialchars_decode(htmlspecialchars_decode($row["04Comment"]));
    $obj_Comment  = str_replace("<p>","",$obj_Comment);
    $obj_Comment  = str_replace("</p>","<br>",$obj_Comment);

    // 画像
    $dirpath       = "images/new/".$row["04PresonID"]."/";
    $obj_Image_img = isExistTheImage($dirpath,"new_Image");
    $fail_url      = "";
    if($obj_Image_img != ""){
        $fail_url      = $dirpath.$obj_Image_img;
        $obj_Image_img = '<img src="'.$fail_url.'" width="470" height="293" alt="'.$obj_Title.'">';
    }else{
        $obj_Image_img = "";
    }

    $obj_LinkFlg    = $row["04LinkFlg"];
    $obj_06PresonID = $row["0406PresonID"];
    $html_stand_tag = '';


    // リンク
    switch($obj_LinkFlg){
        case "1":
            $obj_Image_Link = '<a href="profile.html?PresonID='.$obj_06PresonID.'">'.$obj_Image_img.'</a>';

            $obj_stand_message = '<p class="state"></p>';
            $person_today_icon = '';
            $sql2 = "SELECT ";
            $sql2 .= "  23YYYY, ";
            $sql2 .= "  23MM, ";
            $sql2 .= "  23DD, ";
            $sql2 .= "  23INHH, ";
            $sql2 .= "  23INMM, ";
            $sql2 .= "  23OUTHH, ";
            $sql2 .= "  23OUTMM, ";
            $sql2 .= "  23EMHH, ";
            $sql2 .= "  23EMMM, ";
            $sql2 .= "  23INHH, ";
            $sql2 .= "  23WorkFlg, ";
            $sql2 .= "  23StandFlg ";
            $sql2 .= "FROM 23MPSchedule ";
            $sql2 .= "WHERE ";
            $sql2 .= "23ID = $sql_Id AND 23PresonID = $obj_06PresonID ";
            $sql2 .= "AND 23YYYY = $sql_YYYY AND  23MM = $sql_MM AND 23DD = $sql_DD AND 23WorkFlg <> '0' ";

            $res2 = mysql_query($sql2, $conn);
            if(count($res2) > 0){
                while($row2 = mysql_fetch_assoc($res2)){
                    $obj_23YYYY     = sprintf("%02d",$row2["23YYYY"]);
                    $obj_23MM       = sprintf("%02d",$row2["23MM"]);
                    $obj_23DD       = sprintf("%02d",$row2["23DD"]);
                    $obj_INHH       = sprintf("%02d",$row2["23INHH"]);
                    $obj_INMM       = sprintf("%02d",$row2["23INMM"]);
                    $obj_OUTHH      = sprintf("%02d",$row2["23OUTHH"]);
                    $obj_OUTMM      = sprintf("%02d",$row2["23OUTMM"]);
                    $obj_EMHH       = $row2["23EMHH"];
                    $obj_EMMM       = $row2["23EMMM"];


                    //0：未出勤 1：出勤 2：出勤予定
                    $obj_WorkFlg = $row2["23WorkFlg"];
                    if($obj_WorkFlg == 1) {
                        $person_today_icon = '<p class="today"><img src="img/icon/today.gif" width="72" height="15" alt="本日出勤" /></p>';

                        //0：なし 1：SOLDOUT 2：予約受付中 3:LAST 1
                        $obj_standFlg = $row2["23StandFlg"];


                        $dateTime = mktime(date("H"), date("i"), 0, date("m"), date("d"), date("Y"));//基準日を秒で取得
                        $todayTime = mktime($obj_EMHH, $obj_EMMM, 0, $obj_23MM, $obj_23DD, $obj_23YYYY);
                        if($obj_EMHH < 6){$todayTime = $todayTime + 86400;}
                        $diffTime = $todayTime - $dateTime;
                        $restMin = $diffTime/60;
                        switch($obj_standFlg) {
                            case 0:
                                if($restMin < 0) {
                                    $obj_stand_message = '<p class="state"><img src="img/icon/chance.gif" width="166" height="18" alt="今すぐのご案内可能です♪" /></p>';
                                    break;
                                }
                                $obj_stand_message = '<p class="state">あと'.$restMin.'分</p>';
                                break;
                            case 1:
                                $obj_stand_message = '<p class="state">SOLDOUT</p>';
                                  // 次回出勤取得
                                  $ary_nextAttendance = get_nextAttendance($conn ,$obj_PresonID, $config_shop['switch_day_hour']);
                                  if(mysql_num_rows($ary_nextAttendance) > 0){
                                      while($ary_nextAttendance_val = mysql_fetch_assoc($ary_nextAttendance)){
                                              $nextschedule_date    = date('n/j' , strtotime($ary_nextAttendance_val['23YYYY']."-".$ary_nextAttendance_val['23MM']."-".$ary_nextAttendance_val['23DD']));
                                              // 出勤時間(表示用)
                                              $nextschedule_start  = '';
                                              $nextschedule_start .= ($ary_nextAttendance_val['23INHH'] > 24) ? $ary_nextAttendance_val['23INHH'] - 24 : $ary_nextAttendance_val['23INHH'];
                                              $nextschedule_start .= ':';
                                              $nextschedule_start .= sprintf('%02d', $ary_nextAttendance_val['23INMM']);

                                              $obj_stand_message = '<p class="state">次回'.$nextschedule_date.' '.$nextschedule_start.'～</p>';
                                      }
                                  }
                                break;
                            case 2:
                                $obj_stand_message = '<p class="state">予約受付中</p>';
                                break;
                            case 3:
                                $obj_stand_message = '<p class="state">LAST 1</p>';
                                break;
                            case 4:
                                $obj_stand_message = '<p class="state">当日欠勤</p>';
                                break;
                            case 9:
                              $obj_stand_message = '<p class="state"><img src="img/icon/ichibante.gif" width="100" height="18" alt="出勤一番手" /></p>';
                              break;
                            default :
                                $obj_stand_message = '<p class="state">&nbsp;</p>';
                                break;
                        }
                    }
                }
            }

            $html_stand_tag = '
                <div class="status">
                    <div class="box">
                        <span class="txt">待ち時間</span>
                        '.$obj_stand_message.'
                    </div>
                </div>
            ';


            break;
        case "2":
            $obj_Image_Link = '<a href ="./#bottom-contens">'.$obj_Image_img.'</a>';
            break;
        case "3":
            $obj_Image_Link = '<a href ="mailmaga.html">'.$obj_Image_img.'</a>';
            break;
        case "4":
            $obj_Image_Link = '<a href ="event.html">'.$obj_Image_img.'</a>';
            break;
        case "0":
            $obj_Image_Link = $obj_Image_img;
            break;
    }

    $html_news .= '
        <!-- one box -->
        <li>
            <p class="thumb">'.$obj_Image_Link.'</p>
            <div class="top_realtime_box">
                <time>'.$obj_NewDate.'</time>
                '.$html_stand_tag.'
                <h4 class="contens-ttl">'.$obj_Title.'</h4>
                <div class="com">
                    '.$obj_Comment.'
                </div>
            </div>
        </li>
        <!-- /one box -->
    ';
}
//************************************************


//************************************************
//* 出勤情報
//************************************************
$day = (preg_match('/\d+/', $_GET['day'])) ? htmlspecialchars($_GET['day'], ENT_QUOTES) : 0;

$html_daylink = '';
for($i = 0; $i < 7; $i ++){
    $select_target_time             = BASE_TIME + 86400 * $i;
    $select_target_time             = ((int)date('H') < $config_shop['switch_day_hour']) ? $select_target_time - 86400 : $select_target_time;
    $select_target_year             = date('Y', $select_target_time);
    $select_target_month            = date('n', $select_target_time);
    $select_target_day              = date('j', $select_target_time);
    $select_target_daycount         = $i + 1;
    $select_target_str              = ($i == 0) ? '本日' : $select_target_month.'/'.$select_target_day.'('.$config_dayoftheweek[date('w', $select_target_time)].')';
    $today                          = ($day == $i) ? 'on' : '';
    $get_param                      = ($i > 0) ? '?day='.$i : '';
    $html_daylink .= '<li class="'.$today.'"><a href="index.html'.$get_param.'#bottom-contens">'.$select_target_str.'</a></li>';
}

$target_time    = ($day > 0) ? BASE_TIME + 86400 * $day : BASE_TIME;
$target_time    = ((int)date('H', $target_time) >= 0 && (int)date('H', $target_time) < $config_shop['switch_day_hour']) ? $target_time - 86400 : $target_time;
$target_hour    = ((int)date('H', $target_time) >= 0 && (int)date('H', $target_time) < $config_shop['switch_day_hour']) ? (int)date('H', $target_time) + 24 : (int)date('H', $target_time);
$target_minute  = (int)date('i', $target_time);
$target_minutes = $target_hour * 60 + $target_minute;


$print_today = date('m', $target_time).'月'.date('d', $target_time).'日';

$sql = '
    SELECT
        23INHH,
        23INMM,
        23OUTHH,
        23OUTMM,
        23WorkFlg,
        23StandFlg,
        23EMHH,
        23EMMM,
        06PresonID,
        06Name,
        06Age,
        06He,
        06B,
        06W,
        06H,
        06Cup,
        06NYY,
        06NMM,
        06NDD,
        CAST(CONCAT(23INHH, LPAD(23INMM, 2, 0)) AS UNSIGNED) AS start_time,
        CAST(CONCAT(23OUTHH, LPAD(23OUTMM, 2, 0)) AS UNSIGNED) AS finish_time,
        CAST(CONCAT(23EMHH, LPAD(23EMMM, 2, 0)) AS UNSIGNED) AS waiting_time,
        CASE
            WHEN 23EMHH >= 23INHH THEN (23EMHH * 60 + 23EMMM) - '.$target_minutes.' + 1
            ELSE (23INHH * 60 + 23INMM) - '.$target_minutes.' + 1
        END wait_interval,
        CASE
            WHEN 23StandFlg=0 THEN  0 /* なし */
            WHEN 23StandFlg=3 THEN  1 /* LAST1 */
            WHEN 23StandFlg=2 THEN 20 /* 予約受付中 */
            WHEN 23StandFlg=1 THEN 30 /* SOLDOUT */
            WHEN 23StandFlg=4 THEN 40 /* 当日欠勤 */
            WHEN 23StandFlg=9 THEN 0 /* 出勤一番手 */
            ELSE 1
        END status,
        CASE
            WHEN 23EMHH=99 THEN 1
            ELSE 0
        END wait_last_flag,
        CASE
            WHEN 101DivisionFlg7 = 0 THEN 0
            ELSE 1
        END discount_order
    FROM
        23MPSchedule
        LEFT JOIN 06Person
            ON 06ID=23ID
            AND 06PresonID=23PresonID
        LEFT JOIN 101MPDivisionFlg
            ON 06ID=101ID
            AND 06PresonID=101PresonID
    WHERE
        23YYYY="'.date('Y', $target_time).'"
        AND 23MM="'.date('n', $target_time).'"
        AND 23DD="'.date('j', $target_time).'"
        AND 23WorkFlg=1
        AND 06DisPub=1
    ORDER BY
        status,
        wait_interval,
        start_time,
        finish_time,
        06Row
';
$result = mysql_query($sql, $conn);

$html_schedule_tmp = '';
if(mysql_num_rows($result) > 0){
    while($ary_row = mysql_fetch_assoc($result)){
        $person_id               = $ary_row['06PresonID'];
        $person_name             = $ary_row['06Name'];
        $person_age              = $ary_row['06Age'];
        $person_height           = $ary_row['06He'];
        $person_bust             = $ary_row['06B'];
        $person_bustcup          = $ary_row['06Cup'];
        $person_waist            = $ary_row['06W'];
        $person_hip              = $ary_row['06H'];
        $schedule_status         = $ary_row['23StandFlg'];
        $schedule_wait_interval  = $ary_row['wait_interval'];
        $schedule_wait_last_flag = $ary_row['wait_last_flag'];
        $obj_NYY      = $ary_row["06NYY"];
        $obj_NMM      = $ary_row["06NMM"];
        $obj_NDD      = $ary_row["06NDD"];

        // 出勤時間(表示用)
        $schedule_start  = '';
        $schedule_start .= ($ary_row['23INHH'] > 24) ? $ary_row['23INHH'] - 24 : $ary_row['23INHH'];
        $schedule_start .= ':';
        $schedule_start .= sprintf('%02d', $ary_row['23INMM']);
        // 退勤時間(表示用)
        $schedule_finish = '';
        if($ary_row['23OUTHH'] == 99){
            $schedule_finish .= 'LAST';
        }else{
            $schedule_finish .= ($ary_row['23OUTHH'] > 24) ? $ary_row['23OUTHH'] - 24 : $ary_row['23OUTHH'];
            $schedule_finish .= ':';
            $schedule_finish .= sprintf('%02d', $ary_row['23OUTMM']);
        }

        // サムネイル
        $dir      = './images/person/'.$person_id.'/';
        $filename = isExistTheImage($dir, 'ImageThum');
        if($filename != ''){
            $thumbnail_filepath = $dir.$filename;
        }else{
            $thumbnail_filepath = './img/noimg/141_188.jpg';
        }

        // スターテスアイコン
        $schedule_status_msg = '<time class="time">&nbsp;</time>';
        if($day <= 0){
            switch($schedule_status){
                case 0:
                    // 待ち時間表示は当日の出勤情報のみ表示
                    if($_GET['daycount'] <= 1 && !$schedule_wait_last_flag){
                        if($schedule_wait_interval <= 0){
                            $schedule_status_msg = '<time class="now_waiting2"><img src="img/icon/chance.gif" width="166" height="18" alt="今すぐのご案内可能です♪" /></time>';
                        }else{
                            $schedule_status_msg = '<time class="time">あと'.$schedule_wait_interval.'分</time>';
                        }
                    }else{
                        if(!$schedule_wait_last_flag){
                            $schedule_status_msg = '<time class="time">&nbsp;</time>';
                        }else{
                            $schedule_status_msg = '<time class="time">SOLDOUT</time>';
                            // 次回出勤取得
                            $ary_nextAttendance = get_nextAttendance($conn ,$person_id, $config_shop['switch_day_hour']);
                            if(mysql_num_rows($ary_nextAttendance) > 0){
                                while($ary_nextAttendance_val = mysql_fetch_assoc($ary_nextAttendance)){
                                        $nextschedule_date    = date('n/j' , strtotime($ary_nextAttendance_val['23YYYY']."-".$ary_nextAttendance_val['23MM']."-".$ary_nextAttendance_val['23DD']));
                                        // 出勤時間(表示用)
                                        $nextschedule_start  = '';
                                        $nextschedule_start .= ($ary_nextAttendance_val['23INHH'] > 24) ? $ary_nextAttendance_val['23INHH'] - 24 : $ary_nextAttendance_val['23INHH'];
                                        $nextschedule_start .= ':';
                                        $nextschedule_start .= sprintf('%02d', $ary_nextAttendance_val['23INMM']);

                                        $schedule_status_msg = '<time class="time">次回'.$nextschedule_date.' '.$nextschedule_start.'～</time>';
                                }
                            }
                        }
                    }
                    break;
                case 1:
                    $schedule_status_msg = '<time class="time">SOLDOUT</time>';
                    // 次回出勤取得
                    $ary_nextAttendance = get_nextAttendance($conn ,$person_id, $config_shop['switch_day_hour']);
                    if(mysql_num_rows($ary_nextAttendance) > 0){
                        while($ary_nextAttendance_val = mysql_fetch_assoc($ary_nextAttendance)){
                                $nextschedule_date    = date('n/j' , strtotime($ary_nextAttendance_val['23YYYY']."-".$ary_nextAttendance_val['23MM']."-".$ary_nextAttendance_val['23DD']));
                                // 出勤時間(表示用)
                                $nextschedule_start  = '';
                                $nextschedule_start .= ($ary_nextAttendance_val['23INHH'] > 24) ? $ary_nextAttendance_val['23INHH'] - 24 : $ary_nextAttendance_val['23INHH'];
                                $nextschedule_start .= ':';
                                $nextschedule_start .= sprintf('%02d', $ary_nextAttendance_val['23INMM']);

                                $schedule_status_msg = '<time class="time">次回'.$nextschedule_date.' '.$nextschedule_start.'～</time>';
                        }
                    }
                    break;
                case 2:
                    $schedule_status_msg = '<time class="time">予約受付中</time>';
                    break;
                case 3:
                    $schedule_status_msg = '<time class="time">LAST 1</time>';
                    break;
                case 4:
                    $schedule_status_msg = '<time class="time">当日欠勤</time>';
                    break;
                case 9:
                    $schedule_status_msg = '<time class="now_waiting2"><img src="img/icon/ichibante.gif" width="100" height="18" alt="出勤一番手" /></time>';
                    break;
                default:
                    $schedule_status_msg = '<time class="time">&nbsp;</time>';
                    break;
            }
        }

        // ランクアイコン
        // ※0がTrueで1がFalseになってるので注意！
        $sql2    = 'SELECT 101DivisionFlg1, 101DivisionFlg2, 101DivisionFlg3, 101DivisionFlg4, 101DivisionFlg5, 101DivisionFlg6, 101DivisionFlg7, 101DivisionFlg8 FROM 101MPDivisionFlg WHERE 101PresonID='.$person_id;
        $result2 = mysql_query($sql2, $conn);
        if(mysql_num_rows($result2)){
            while($ary_row2 = mysql_fetch_assoc($result2)){
                $ary_rank_flg['premium']    = $ary_row2['101DivisionFlg1']; // プレミアムアイコンのフラグ
                //$ary_rank_flg['']         = $ary_row2['101DivisionFlg2'];
                $ary_rank_flg['vip']        = $ary_row2['101DivisionFlg3']; // ビップアイコンのフラグ
                $ary_rank_flg['royalvip']   = $ary_row2['101DivisionFlg4']; // ロイヤルビップアイコンのフラグ
                $ary_rank_flg['queen']      = $ary_row2['101DivisionFlg5']; // クイーンアイコンのフラグ
                $ary_rank_flg['mervis']     = $ary_row2['101DivisionFlg6']; // メルビスアイコンのフラグ
                $ary_rank_flg['discount']   = $ary_row2['101DivisionFlg7']; // 割引対象のフラグ
                $ary_rank_flg['stforce']    = $ary_row2['101DivisionFlg8']; // セントフォースアイコンのフラグ
            }
        }
        if($ary_rank_flg['premium'] == 0){
            $person_rank_icon   = '<img src="img/rank/premium.png" alt="プレミアム">';
        }else if($ary_rank_flg['vip'] == 0){
            $person_rank_icon   = '<img src="img/rank/vip.png" alt="ビップ">';
        }else if($ary_rank_flg['royalvip'] == 0){
            $person_rank_icon   = '<img src="img/rank/royal.png" alt="ロイヤルビップ">';
        }else if($ary_rank_flg['queen'] == 0){
            $person_rank_icon   = '<img src="img/rank/queen.png" alt="クイーン">';
        }else if($ary_rank_flg['mervis'] == 0){
            $person_rank_icon   = '<img src="img/rank/mervis.png" alt="メルビス">';
        }else if($ary_rank_flg['stforce'] == 0){
            $person_rank_icon   = '<img src="img/rank/stforce.png" alt="セントフォース">';
        }else{
            $person_rank_icon   = '<img src="img/rank/basic.png" alt="ベーシック">';
        }
        // 割引対象の場合は他のアイコンを上書きして優先表示
        if($ary_rank_flg['discount'] == 0){
            $person_rank_icon   = '<img src="img/rank/disicon.png" alt="割引対象">';
        }

  // 新人
  if($obj_NYY.sprintf('%02d', $obj_NMM).sprintf('%02d', $obj_NDD) >= date('Ymd', $newface_limit_timestamp)){
    $person_newface_icon   = '<p class="newface"><img src="img/icon/newface.gif" width="73" height="15" alt="NEW FACE" /></p>';
  }else{
    $person_newface_icon   = '';
  }

        // HTML出勤情報
        $html_schedule .= '
            <li>
                <a href="profile.html?PresonID='.$person_id.'">
                    '.$schedule_status_msg.'
                    <p class="thumb"><img src="'.$thumbnail_filepath.'" width="202"></p>
                    <span class="name">'.$person_name.'('.$person_age.')</span>
                    <span class="size">'.$person_height.'&nbsp;.'.$person_bust.'('.$person_bustcup.')&nbsp;.'.$person_waist.'&nbsp;.'.$person_hip.'</span>
                    <span class="work">'.$schedule_start.'～'.$schedule_finish.'</span>
                    <p class="icon">'.$person_rank_icon.'</p>
                    '.$person_newface_icon.'
                </a>
            </li>
        ';

    }
}
//************************************************


//************************************************
//* イベントバナー
//************************************************
// SELECTコマンドを実行してデータを取得する
$sql_Id = funSqlText($obj_CustomerID);
$sql  = "SELECT * FROM 05Event ";
$sql .= "WHERE ";
$sql .= "05ID = $sql_Id AND 05DelFlg = '0' AND 05DisPub = 1 ";
$sql .= "ORDER BY 05IYY DESC , 05IMM DESC , 05IDD DESC , 05IHH DESC , 05III DESC , 05ISS DESC , 05PresonID DESC ";

$res = mysql_query($sql, $conn);
while ($row = mysql_fetch_array($res, MYSQL_ASSOC)) {
    $IYY            = $row["05IYY"];
    $IMM            = $row["05IMM"];
    $IDD            = $row["05IDD"];

    $obj_Title      = $row["05Title"];
    $obj_PresonID   = $row["05PresonID"];

    $obj_Category   = $row["05Category"];

    $dirpath        = "./images/event/".$row["05PresonID"]."/";
    $obj_Image_img  = isExistTheImage($dirpath,"event_Image");
    $fail_url       = "";
    if($obj_Image_img != ""){
        $fail_url          = $dirpath.$obj_Image_img;
        $ary_html_eventbanner[$obj_Category]['main']  .= '<li><a href="./event.html#'.$obj_PresonID.'"><img src="'.$fail_url.'" width="410" alt="'.$obj_Title.'"></a></li>';
        $ary_html_eventbanner[$obj_Category]['thumb'] .= '<li><div><img src="'.$fail_url.'" width="171" alt="'.$obj_Title.'"></div></li>';
    }
}
//************************************************


//************************************************
//* TOP用動画
//************************************************
$sql = "SELECT * FROM 06Person ";
$sql .= "WHERE ";
$sql .= "06ID = $sql_Id AND 06DisPub = '1' AND 06DelFlg = '0' ";
$sql .= " AND 06MoviePc != '' ";
$sql .= "ORDER BY 06Row ";

// SELECTコマンドを実行してデータを取得する
// SQL用の変数に変換
$sql = "SELECT * FROM 210TopMovie ";
$sql .= " LEFT OUTER JOIN 06Person ";
$sql .= "  ON 06PresonID = 21006PresonID ";
$sql .= "ORDER BY 210PresonID ";
$res = mysql_query($sql, $conn);
while ($row = mysql_fetch_array($res, MYSQL_ASSOC)) {

    $obj_PresonID = $row["06PresonID"];
    $sql_PresonID = funSqlText($obj_PresonID);
    $obj_Name     = $row["06Name"];
    $obj_Age      = $row["06Age"];
    $obj_He       = $row["06He"];
    $obj_B        = $row["06B"];
    $obj_W        = $row["06W"];
    $obj_H        = $row["06H"];
    $obj_Cup      = $row["06Cup"];
    $obj_NYY      = $row["06NYY"];
    $obj_NMM      = $row["06NMM"];
    $obj_NDD      = $row["06NDD"];
    $obj_NHH      = $row["06NHH"];
    $obj_NII      = $row["06NII"];
    $obj_NSS      = $row["06NSS"];
    $obj_Comment  = $row["06Comment"];
    $obj_DisPub   = $row["06DisPub"];
    $obj_DisIcon  = $row["06DisIcon"];
    $obj_Row      = $row["06Row"];


  if(!$obj_PresonID){
    continue;
  }


    $obj_stand_message = '<p class="state"></p>';
    $person_today_icon = '';
    $sql2 = "SELECT ";
    $sql2 .= "  23YYYY, ";
    $sql2 .= "  23MM, ";
    $sql2 .= "  23DD, ";
    $sql2 .= "  23INHH, ";
    $sql2 .= "  23INMM, ";
    $sql2 .= "  23OUTHH, ";
    $sql2 .= "  23OUTMM, ";
    $sql2 .= "  23EMHH, ";
    $sql2 .= "  23EMMM, ";
    $sql2 .= "  23INHH, ";
    $sql2 .= "  23WorkFlg, ";
    $sql2 .= "  23StandFlg ";
    $sql2 .= "FROM 23MPSchedule ";
    $sql2 .= "WHERE ";
    $sql2 .= "23ID = $sql_Id AND 23PresonID = $sql_PresonID ";
    $sql2 .= "AND 23YYYY = $sql_YYYY AND  23MM = $sql_MM AND 23DD = $sql_DD AND 23WorkFlg <> '0' ";

    $res2 = mysql_query($sql2, $conn);
    if(count($res2) > 0){
        while($row2 = mysql_fetch_assoc($res2)){
            $obj_23YYYY     = sprintf("%02d",$row2["23YYYY"]);
            $obj_23MM       = sprintf("%02d",$row2["23MM"]);
            $obj_23DD       = sprintf("%02d",$row2["23DD"]);
            $obj_INHH       = sprintf("%02d",$row2["23INHH"]);
            $obj_INMM       = sprintf("%02d",$row2["23INMM"]);
            $obj_OUTHH      = sprintf("%02d",$row2["23OUTHH"]);
            $obj_OUTMM      = sprintf("%02d",$row2["23OUTMM"]);
            $obj_EMHH       = $row2["23EMHH"];
            $obj_EMMM       = $row2["23EMMM"];


            //0：未出勤 1：出勤 2：出勤予定
            $obj_WorkFlg = $row2["23WorkFlg"];
            if($obj_WorkFlg == 1) {
                $person_today_icon = '<p class="today"><img src="img/icon/today.gif" width="72" height="15" alt="本日出勤" /></p>';

                //0：なし 1：SOLDOUT 2：予約受付中 3:LAST 1
                $obj_standFlg = $row2["23StandFlg"];


                $dateTime = mktime(date("H"), date("i"), 0, date("m"), date("d"), date("Y"));//基準日を秒で取得
                $todayTime = mktime($obj_EMHH, $obj_EMMM, 0, $obj_23MM, $obj_23DD, $obj_23YYYY);
                if($obj_EMHH < 6){$todayTime = $todayTime + 86400;}
                $diffTime = $todayTime - $dateTime;
                $restMin = $diffTime/60;
                switch($obj_standFlg) {
                    case 0:
                        if($restMin < 0) {
                            $obj_stand_message = '<p class="state"><img src="img/icon/chance.gif" width="166" height="18" alt="今すぐのご案内可能です♪" /></p>';
                            break;
                        }
                        $obj_stand_message = '<p class="state">あと'.$restMin.'分</p>';
                        break;
                    case 1:
                        $obj_stand_message = '<p class="state">SOLDOUT</p>';
              // 次回出勤取得
              $ary_nextAttendance = get_nextAttendance($conn ,$obj_PresonID, $config_shop['switch_day_hour']);
              if(mysql_num_rows($ary_nextAttendance) > 0){
                  while($ary_nextAttendance_val = mysql_fetch_assoc($ary_nextAttendance)){
                          $nextschedule_date    = date('n/j' , strtotime($ary_nextAttendance_val['23YYYY']."-".$ary_nextAttendance_val['23MM']."-".$ary_nextAttendance_val['23DD']));
                          // 出勤時間(表示用)
                          $nextschedule_start  = '';
                          $nextschedule_start .= ($ary_nextAttendance_val['23INHH'] > 24) ? $ary_nextAttendance_val['23INHH'] - 24 : $ary_nextAttendance_val['23INHH'];
                          $nextschedule_start .= ':';
                          $nextschedule_start .= sprintf('%02d', $ary_nextAttendance_val['23INMM']);

                          $obj_stand_message = '<p class="state">次回'.$nextschedule_date.' '.$nextschedule_start.'～</p>';
                  }
              }

                        break;
                    case 2:
                        $obj_stand_message = '<p class="state">予約受付中</p>';
                        break;
                    case 3:
                        $obj_stand_message = '<p class="state">LAST 1</p>';
                        break;
                    case 4:
                        $obj_stand_message = '<p class="state">当日欠勤</p>';
                        break;
            case 9:
              $obj_stand_message = '<p class="state"><img src="img/icon/ichibante.gif" width="100" height="18" alt="出勤一番手" /></p>';
              break;
                    default :
                        $obj_stand_message = '<p class="state">&nbsp;</p>';
                        break;
                }
            }
        }
    }


    // 新人
    if($obj_NYY.sprintf('%02d', $obj_NMM).sprintf('%02d', $obj_NDD) >= date('Ymd', $newface_limit_timestamp)){
        $person_newface_icon   = '<p class="newface"><img src="img/icon/newface.gif" width="72" height="15" alt="NEW FACE" /></p>';
    }else{
        $person_newface_icon   = '';
    }


    // $obj_Movie = htmlspecialchars_decode($row["06MoviePc"]);
    $obj_Movie = htmlspecialchars_decode($row["210Comment"]);
    $obj_Movie = preg_replace("/width=([0-9]+)/",'width=482', $obj_Movie);
    $obj_Movie = preg_replace('/width="([0-9]+)"/','width="482"', $obj_Movie);
    $obj_Movie = preg_replace("/height=([0-9]+)/",'height=271', $obj_Movie);
    $obj_Movie = preg_replace('/height="([0-9]+)"/','height="271"', $obj_Movie);


    $html_movie .= '
        <li>
          <p class="name">'.$obj_Name.'('.$obj_Age.')</p>
          <p class="data">'.$obj_He.'&nbsp;.'.$obj_B.'('.$obj_Cup.')&nbsp;.'.$obj_W.'&nbsp;.'.$obj_H.'</p>
          '.$person_today_icon.'
          '.$person_newface_icon.'
          <p class="time">待ち時間</p>
          '.$obj_stand_message.'
          <div class="movieBox">
              '.$obj_Movie.'
          </div>
        </li>
    ';


}
//************************************************


print <<< HERE
{$html_pc_start}
<body>
{$html_auth}
<!-- head-wrapper -->
{$html_pc_header}
<!-- /head-wrapper -->
    <!-- contens-wrapper-cover -->
    <div class="contens-wrapper-cover top">
        <!-- top_realtime#default -->
        <div class="news_content">
            <h3 class="ttl">
                <img src="img/ttl/realtime.png" alt="リアルタイム"/>
            </h3>
            <div class="top_realtime_d">
                <div class="top_realtime_btn">
                    <a href="realtime.html"><img src="img/btn/top_more.png" width="107" height="29" alt="もっと見る" /></a>
                </div>
                <ul class="clearfix list fixHeight ">
                    {$html_news}
                </ul>
            </div>
        </div>
        <!-- /top_realtime#default -->

        <!-- bottom-contens -->
        <div class="bottom-contens clearfix" id="bottom-contens">
            <!-- girl-area -->
            <section class="girl-area">
                <h3 class="ttl">
                <img src="img/ttl/today_schedule.png" width="283" height="64" alt="本日の出勤情報"></h3>
                <div class="right mt25">
                    <a href="./schedule.html"><img src="./img/btn/more_tommrow.png" alt="明日以降の出勤情報" width="178"></a>
                </div>
                <br class="clear">
                <!-- top-schedule -->
                <div class="top-schedule clearfix" id="schedule">
                    <ul class="list clearfix">
                        {$html_schedule}
                    </ul>
                </div>
                <!-- /top-schedule -->
                <!-- chat-area -->
                <section class="chat-area">
                    <iframe src="http://miechat.tv/parts/h5liveparts.html?id=44925&no=1&rgb=FF4488" width="350" height="309" frameborder="0" scrolling="no"></iframe>
                </section>
                <!-- /chat-area -->
                <!-- chat-area2 -->
                <section class="chat-area2">
                    <iframe src="http://miechat.tv/parts/h5liveparts.html?id=44925&no=2&rgb=FF4488" width="350" height="309" frameborder="0" scrolling="no"></iframe>
                </section>
                <!-- /chat-area2 -->
                <br class="clear">
            </section>
            <!-- /girl-area -->
            <!-- side-area -->
            <div class="side-area">
                <ul class="banner">
                    <li>
                        <a href="https://www.girlsheaven-job.net/osaka/ma-49/sa-465/osaka_ateliana/?of=y" target="_blank">
                            <img src="img/btn/top_side_girl_recruit.png" alt="求人サイトはこちら">
                        </a>
                    </li>
                    <li>
                        <a href="http://www.atelianagroup-mens.jp/" target="_blank">
                            <img src="img/btn/top_side_mens_recruit.png" alt="運営スタッフ募集">
                        </a>
                    </li>
                </ul>
                <!-- photomail -->
                <div class="photomail">
                    <div class="dto_diary_widget">
                        <iframe frameborder="0" src="http://mobile.cityheaven.net/k/osaka_ateliana/B6GirlDiaryList/?of=y" width="174" height="728"></iframe>
                    </div>
                </div>
                <!-- /photomail -->
            </div>
            <!-- /side-area -->
        </div>
        <!-- /bottom-contens -->

        <!-- middle-contens-default -->
        <div class="top_slide_contens">
            <!-- event-slide-area -->
            <div class="top_slide_wrap01">
                <div class="event-slide-area">
                    <!-- lof-slidecontent -->
                    <div id="jslidernews2" class="lof-slidecontent">
                        <div class="preload">
                            <div></div>
                        </div>
                        <div class="button-previous">Previous</div>
                        <!-- MAIN CONTENT -->
                        <div class="main-slider-content">
                            <ul class="sliders-wrap-inner">
                                {$ary_html_eventbanner[1]['main']}
                            </ul>
                        </div>
                        <!-- END MAIN CONTENT -->
                        <div class="button-next">Next</div>
                    </div>
                    <!-- lof-slidecontentEnd -->
                </div>
            </div>
            <!-- /event-slide-area -->
            <!-- recruit-slide-area -->
            <div class="top_slide_wrap02">
                <div class="recruit-slide-area">
                    <!-- lof-slidecontent -->
                    <div id="jslidernews3" class="lof-slidecontent">
                        <div class="preload">
                            <div></div>
                        </div>
                        <div class="button-previous">Previous</div>
                        <!-- MAIN CONTENT -->
                        <div class="main-slider-content">
                            <ul class="sliders-wrap-inner">
                                {$ary_html_eventbanner[2]['main']}
                            </ul>
                        </div>
                        <!-- END MAIN CONTENT -->
                        <div class="button-next">Next</div>
                    </div>
                    <!-- lof-slidecontentEnd -->
                </div>
            </div>
            <!-- /recruit-slide-area -->
        </div>
        <!-- /middle-contens-default -->

        <!-- movie-contens -->
        <div class="movie-contens clearfix">
        <ul class="list">

          {$html_movie}

        </ul>
        </div>
        <!-- movie-contens -->

        <p class="pagetop">
            <a href="#">
                <img src="img/btn/pagetop.png" width="91" height="24" alt="pagetop">
            </a>
        </p>
    </div>
    <!-- /contens-wrapper-cover -->
    <!-- footer -->
    {$html_pc_footer}
    <!-- /footer -->
    <script src="js/lightbox.js"></script>
    <script src="js/switchImage_fl.js"></script>
    <script src="js/jquery.easing.js"></script>
    <script src="js/script.js"></script>
    <script src="js/site.js"></script>
    <!--<script src="js/{$include_slider_script}"></script>-->
    <script defer src="js/modernizr.js"></script>
    
	<script type="text/javascript">
		setTimeout("location.reload()",1000*90);
	</script>
</body>
{$html_pc_finish}
HERE;
?>