<?php
require_once(dirname(__FILE__)."/../../admin/lib/common.php");

$area_pref_no = "1";
$sid = $_GET["sid"];
$gid = $_GET["gid"];

//////////店舗情報読み込み//////////
$sql = "SELECT * FROM shop WHERE shop_id ='".$sid."'";
$result = mysqli_query($con,$sql);

while($data = mysqli_fetch_array($result)){
$shop_id = $data["shop_id"];
$shop_rank = $data["shop_rank"];
$shop_course = $data["shop_course"];
$shop_name = $data["shop_name"];
$shop_code = $data["shop_code"];
$shop_tanto = $data["shop_tanto"];
$shop_pref = $data["shop_pref"];
$shop_pref_jp = pref_jp($shop_pref);
$shop_pref_jp2 = pref_jp2($shop_pref);
$shop_pref_en = pref_en($shop_pref);
$shop_addr = $data["shop_addr"];
$shop_area = $data["shop_area"];
$shop_time = $data["shop_time"];
$shop_tel = $data["shop_tel"];
$shop_tel_sub1 = $data["shop_tel_sub1"];
$shop_tel_sub1_name = $data["shop_tel_sub1_name"];
$shop_tel_sub1_text = $data["shop_tel_sub1_text"];
$shop_tel_sub2 = $data["shop_tel_sub2"];
$shop_tel_sub2_name = $data["shop_tel_sub2_name"];
$shop_tel_sub2_text = $data["shop_tel_sub2_text"];
$shop_mail = $data["shop_mail"];
$shop_sp_url = $data["shop_sp_url"];
$shop_pr = $data["shop_pr"];
$side_banner = $data["side_banner"];
$register = $data["register"];
$nyukin = $data["nyukin"];
$shop_update = $data["shop_update"];
break;
}

//////////エリア読み込み//////////
$area_sql = "SELECT * FROM area WHERE area_pref='".$shop_pref ."' AND area_id='".$shop_area."' ORDER BY area_name_en ASC";
$area_result = mysqli_query($con,$area_sql);

while($area_data = mysqli_fetch_array($area_result)){
$area_id = $area_data["area_id"];
$area_pref = $area_data["area_pref"];
	$area_pref_jp = pref_jp($area_pref);
	$area_pref_en = pref_en($area_pref);
$area_name_en = $area_data["area_name_en"];
$area_name_jp = $area_data["area_name_jp"];
}


//////////女の子名読み込み//////////
$girl_sql = "SELECT * FROM girl WHERE girl_id='".$gid."'";
$girl_result = mysqli_query($con,$girl_sql);
if(!$girl_sql){
print("SQLの実行に失敗しました。
");
exit;
}
while($girl_data = mysqli_fetch_array($girl_result)){
$girl_id = $girl_data["girl_id"];
$girl_name = $girl_data["girl_name"];
$girl_pr = $girl_data["girl_pr"];
$size_b = $girl_data["size_b"];
$cup = $girl_data["cup"];
$size_w = $girl_data["size_w"];
$size_h = $girl_data["size_h"];
$size_t = $girl_data["size_t"];
$age = $girl_data["age"];
$blood = $girl_data["blood"];
$main_p = $girl_data["main_p"];
$p1 = $girl_data["p1"];
$p2 = $girl_data["p2"];
$p3 = $girl_data["p3"];
$p4 = $girl_data["p4"];
$p5 = $girl_data["p5"];
$rank = $girl_data["rank"];
$girl_birthplace = $girl_data["girl_birthplace"];
$girl_charmpoint = $girl_data["girl_charmpoint"];
$girl_job = $girl_data["girl_job"];
$girl_hobby = $girl_data["girl_hobby"];
$girl_skill = $girl_data["girl_skill"];
$girl_likefood = $girl_data["girl_likefood"];
$girl_holiday = $girl_data["girl_holiday"];
$girl_man = $girl_data["girl_man"];
$girl_dream = $girl_data["girl_dream"];
$girl_sort = $girl_data["girl_sort"];
$sun = $girl_data["sun"];
$sun_start = $girl_data["sun_start"];
	$sun_start24 = over24($sun_start);
$sun_end = $girl_data["sun_end"];
	$sun_end24 = over24($sun_end);
$sun_check = $girl_data["sun_check"];
$mon = $girl_data["mon"];
$mon_start = $girl_data["mon_start"];
	$mon_start24 = over24($mon_start);
$mon_end = $girl_data["mon_end"];
	$mon_end24 = over24($mon_end);
$mon_check = $girl_data["mon_check"];
$tue = $girl_data["tue"];
$tue_start = $girl_data["tue_start"];
	$tue_start24 = over24($tue_start);
$tue_end = $girl_data["tue_end"];
	$tue_end24 = over24($tue_end);
$tue_check = $girl_data["tue_check"];
$wed = $girl_data["wed"];
$wed_start = $girl_data["wed_start"];
	$wed_start24 = over24($wed_start);
$wed_end = $girl_data["wed_end"];
	$wed_end24 = over24($wed_end);
$wed_check = $girl_data["wed_check"];
$thu = $girl_data["thu"];
$thu_start = $girl_data["thu_start"];
	$thu_start24 = over24($thu_start);
$thu_end = $girl_data["thu_end"];
	$thu_end24 = over24($thu_end);
$thu_check = $girl_data["thu_check"];
$fri = $girl_data["fri"];
$fri_start = $girl_data["fri_start"];
	$fri_start24 = over24($fri_start);
$fri_end = $girl_data["fri_end"];
	$fri_end24 = over24($fri_end);
$fri_check = $girl_data["fri_check"];
$sat = $girl_data["sat"];
$sat_start = $girl_data["sat_start"];
	$sat_start24 = over24($sat_start);
$sat_end = $girl_data["sat_end"];
	$sat_end24 = over24($sat_end);
$sat_check = $girl_data["sat_check"];
}

//////////動画読み込み//////////
$movie_sql = "SELECT * FROM movie WHERE movie_shop_id ='".$sid."' AND movie_girl_id ='".$gid."' ORDER BY movie_update DESC LIMIT 1";
$movie_result = mysqli_query($con,$movie_sql) or die(mysqli_error());
if(!$movie_sql){
print("SQLの実行に失敗しました。
");
exit;
}
while($movie_data = mysqli_fetch_array($movie_result)){
$movie_id = $movie_data["movie_id"];
$movie_shop_id = $movie_data["movie_shop_id"];
$movie_code = $movie_data["movie_code"];
$movie_update = $movie_data["movie_update"];
break;
}


//////////　スマホページへリダイレクト　//////////
$redirect = <<< EOF
<script type="text/javascript">
if ((navigator.userAgent.indexOf('iPhone') > 0 && 
navigator.userAgent.indexOf('iPad') == -1) || 
navigator.userAgent.indexOf('iPod') > 0 || 
navigator.userAgent.indexOf('Android') > 0) {
	location.href = './girl_sp.html?sid=$sid&gid=$gid';
}
</script>
EOF;


$title = "{$shop_name} {$girl_name} ｜ 【セクシーズ】 {$shop_pref_jp}セクキャバ情報";
$keywords = "<meta name=\"keywords\" content=\"{$girl_name}\" />";
$description = "<meta name=\"description\" content=\"{$shop_name}【{$girl_name}】のプロフィール・出勤情報(週間)・ちょっぴりエッチなムービー等々、知りたい情報を一挙公開!!\" />";
include("../../temp.php");
echo ${'head_'.$shop_pref_en};
echo ${'header_shop_'.$shop_pref_en};
?>

<div id="contents_back">
<div id="contents">
<div id="main">


<!-- ▽ 女の子画像 ＋ プロフィール詳細 -->

<p><img src="<?php echo $furl;?>/img/tit_girl_profile.png" alt="女の子写真・各種プロフィール詳細" /></p>

<div class="girl_profile_contents">
<div align="center">

<!--▼女の子画像-->
<?php
echo <<< SET
<div id="girl">
<div id="girl_photo">
SET;
if(! $main_p == 0) {
echo <<< SET
<img src="{$furl}/img/photo.php?src=../{$shop_pref_en}/{$shop_code}/img/{$main_p}&h=&w=300&zc=1" name="photo" id="photo" onclick="MM_swapImage('photo','','{$furl}/img/photo.php?src=../{$shop_pref_en}/{$shop_code}/img/{$main_p}&h=&w=300&zc=1',1)" />
SET;
}
else {
echo <<< SET
<img src="{$furl}/img/nophoto.jpg" width="300" name="photo" id="photo" />
SET;
}

echo <<< EOF
<div class="girl_photo_line">
EOF;

if(! $p1 == 0) {
echo <<< SET
<div class="girl_photo_m">
<img src="{$furl}/img/photo.php?src=../{$shop_pref_en}/{$shop_code}/img/{$p1}&h=&w=50&zc=1" name="p1" id="p1" onclick="MM_swapImage('photo','','{$furl}/img/photo.php?src=../{$shop_pref_en}/{$shop_code}/img/{$p1}&h=&w=300&zc=1',1)" />
</div>
SET;
}

if(! $p2 == 0) {
echo <<< SET
<div class="girl_photo_m">
<img src="{$furl}/img/photo.php?src=../{$shop_pref_en}/{$shop_code}/img/{$p2}&h=&w=50&zc=1" name="p2" id="p2" onclick="MM_swapImage('photo','','{$furl}/img/photo.php?src=../{$shop_pref_en}/{$shop_code}/img/{$p2}&h=&w=300&zc=1',1)" />
</div>
SET;
}

if(! $p3 == 0) {
echo <<< SET
<div class="girl_photo_m">
<img src="{$furl}/img/photo.php?src=../{$shop_pref_en}/{$shop_code}/img/{$p3}&h=&w=50&zc=1" name="p3" id="p3" onclick="MM_swapImage('photo','','{$furl}/img/photo.php?src=../{$shop_pref_en}/{$shop_code}/img/{$p3}&h=&w=300&zc=1',1)" />
</div>
SET;
}

if(! $p4 == 0) {
echo <<< SET
<div class="girl_photo_m">
<img src="{$furl}/img/photo.php?src=../{$shop_pref_en}/{$shop_code}/img/{$p4}&h=&w=50&zc=1" name="p4" id="p4" onclick="MM_swapImage('photo','','{$furl}/img/photo.php?src=../{$shop_pref_en}/{$shop_code}/img/{$p4}&h=&w=300&zc=1',1)" />
</div>
SET;
}


if(! $p5 == 0) {
echo <<< SET
<div class="girl_photo_m">
<img src="{$furl}/img/photo.php?src=../{$shop_pref_en}/{$shop_code}/img/{$p5}&h=&w=50&zc=1" name="p5" id="p5" onclick="MM_swapImage('photo','','{$furl}/img/photo.php?src=../{$shop_pref_en}/{$shop_code}/img/{$p5}&h=&w=300&zc=1',1)" />
</div>
SET;
}


echo <<< EOF
</div>
</div>
EOF;
?>
<!--▲女の子画像-->


<!--▼女の子プロフィール-->
<div class="girl_profile">
<table class="girl_profile_tbl">
<tr>
<td class="td1">名前（年齢）</td>
<td class="td3"><span class="pink b f16"><?=$girl_name?></span>（<?=$age?>歳）</td>
</tr>
<tr>
<td class="td1">店名とエリア</td>
<td class="td3"><a href="<?=$http?><?=$shop_pref_en?>.<?=$domain?>/<?=$shop_code?>/"><?=$shop_name?></a><br /><?=$area_name_jp?></td>
</tr>
<tr>
<td class="td1">サイズ</td>
<td class="td3"><b>身長：</b><?=$size_t?> cm<br /><b>B:</b><?=$size_b?>（<?=$cup?>） ／ <b>W:</b><?=$size_w?> ／ <b>H:</b><?=$size_h?></td>
</tr>
<tr>
<td class="td1">血液型</td>
<td class="td3"><?=$blood?></td>
</tr>
<tr>
<td class="td1">出身地</td>
<td class="td3"><?=$girl_birthplace?></td>
</tr>
<tr>
<td class="td1">チャームポイント</td>
<td class="td3"><?=$girl_charmpoint?></td>
</tr>
<tr>
<td class="td1">前職</td>
<td class="td3"><?=$girl_job?></td>
</tr>
<tr>
<td class="td1">趣味</td>
<td class="td3"><?=$girl_hobby?></td>
</tr>
<tr>
<td class="td1">特技</td>
<td class="td3"><?=$girl_skill?></td>
</tr>
<tr>
<td class="td1">好きな食べ物</td>
<td class="td3"><?=$girl_likefood?></td>
</tr>
<tr>
<td class="td1">休日の過ごし方</td>
<td class="td3"><?=$girl_holiday?></td>
</tr>
<tr>
<td class="td1">キュンとする仕草・<br />男性の好きな部分など</td>
<td class="td3"><?=$girl_man?></td>
</tr>
<tr>
<td class="td1">将来の夢</td>
<td class="td3"><?=$girl_dream?></td>
</tr>
<tr>
<td class="td1">お店からのメッセージ</td>
<td class="td3"><?=$girl_pr?></td>
</tr>
</table>
</div>

</div>
<!--▲女の子プロフィール-->

</div>
</div>

<!-- △ 女の子画像 ＋ プロフィール詳細 -->


<!--▼女の子出勤情報-->
<p style="margin-top:20px;"><img src="<?php echo $furl;?>/img/tit_girl_schedule.png" alt="この女の子の出勤スケジュール（週間）" /></p>
<table class="girl_weektbl">
<?php
$sc_day[0] = date("n月j日", strtotime("-6 hours"));
$sc_day[1] = date("n月j日", strtotime("+18 hours"));
$sc_day[2] = date("n月j日", strtotime("+42 hours"));
$sc_day[3] = date("n月j日", strtotime("+66 hours"));
$sc_day[4] = date("n月j日", strtotime("+90 hours"));
$sc_day[5] = date("n月j日", strtotime("+114 hours"));
$sc_day[6] = date("n月j日", strtotime("+138 hours"));

$sc_week[0] = date("w", strtotime("-6 hours"));
$sc_week[1] = date("w", strtotime("+18 hours"));
$sc_week[2] = date("w", strtotime("+42 hours"));
$sc_week[3] = date("w", strtotime("+66 hours"));
$sc_week[4] = date("w", strtotime("+90 hours"));
$sc_week[5] = date("w", strtotime("+114 hours"));
$sc_week[6] = date("w", strtotime("+138 hours"));

for ($j=0; $j<7; $j++){
      		switch ($sc_week[$j]) {
				case 0:
					$sc_weekj[$j] = "（日）";
					$sc_date[$j] = $sun;
					$sc_start[$j] = $sun_start24;
					$sc_end[$j] = $sun_end24;
					$sc_check[$j] = $sun_check;
					break;
				case 1:
					$sc_weekj[$j] = "（月）";
					$sc_date[$j] = $mon;
					$sc_start[$j] = $mon_start24;
					$sc_end[$j] = $mon_end24;
					$sc_check[$j] = $mon_check;
					break;
				case 2:
					$sc_weekj[$j] = "（火）";
					$sc_date[$j] = $tue;
					$sc_start[$j] = $tue_start24;
					$sc_end[$j] = $tue_end24;
					$sc_check[$j] = $tue_check;
					break;
				case 3:
					$sc_weekj[$j] = "（水）";
					$sc_date[$j] = $wed;
					$sc_start[$j] = $wed_start24;
					$sc_end[$j] = $wed_end24;
					$sc_check[$j] = $wed_check;
					break;
				case 4:
					$sc_weekj[$j] = "（木）";
					$sc_date[$j] = $thu;
					$sc_start[$j] = $thu_start24;
					$sc_end[$j] = $thu_end24;
					$sc_check[$j] = $thu_check;
					break;
				case 5:
					$sc_weekj[$j] = "（金）";
					$sc_date[$j] = $fri;
					$sc_start[$j] = $fri_start24;
					$sc_end[$j] = $fri_end24;
					$sc_check[$j] = $fri_check;
					break;
				case 6:
					$sc_weekj[$j] = "（土）";
					$sc_date[$j] = $sat;
					$sc_start[$j] = $sat_start24;
					$sc_end[$j] = $sat_end24;
					$sc_check[$j] = $sat_check;
					break;
		      	}

if ($sc_week[$j] == 0) {
echo <<< EOF
<td class="d h30 c sun">{$sc_day[$j]}{$sc_weekj[$j]}</td>
EOF;
}
elseif ($sc_week[$j] == 6) {
echo <<< EOF
<td class="d h30 c sat">{$sc_day[$j]}{$sc_weekj[$j]}</td>
EOF;
}
else {
echo <<< EOF
<td class="d h30 c day">{$sc_day[$j]}{$sc_weekj[$j]}</td>
EOF;
}
}
echo <<< EOF
</tr>
<tr>
EOF;

for ($i=0; $i<7; $i++){

      		switch ($sc_week[$i]) {
				case 0:
					$sc_weekj[$i] = "（日）";
					$sc_date[$i] = $sun;
					$sc_start[$i] = $sun_start24;
					$sc_end[$i] = $sun_end24;
					$sc_check[$i] = $sun_check;
					break;
				case 1:
					$sc_weekj[$i] = "（月）";
					$sc_date[$i] = $mon;
					$sc_start[$i] = $mon_start24;
					$sc_end[$i] = $mon_end24;
					$sc_check[$i] = $mon_check;
					break;
				case 2:
					$sc_weekj[$i] = "（火）";
					$sc_date[$i] = $tue;
					$sc_start[$i] = $tue_start24;
					$sc_end[$i] = $tue_end24;
					$sc_check[$i] = $tue_check;
					break;
				case 3:
					$sc_weekj[$i] = "（水）";
					$sc_date[$i] = $wed;
					$sc_start[$i] = $wed_start24;
					$sc_end[$i] = $wed_end24;
					$sc_check[$i] = $wed_check;
					break;
				case 4:
					$sc_weekj[$i] = "（木）";
					$sc_date[$i] = $thu;
					$sc_start[$i] = $thu_start24;
					$sc_end[$i] = $thu_end24;
					$sc_check[$i] = $thu_check;
					break;
				case 5:
					$sc_weekj[$i] = "（金）";
					$sc_date[$i] = $fri;
					$sc_start[$i] = $fri_start24;
					$sc_end[$i] = $fri_end24;
					$sc_check[$i] = $fri_check;
					break;
				case 6:
					$sc_weekj[$i] = "（土）";
					$sc_date[$i] = $sat;
					$sc_start[$i] = $sat_start24;
					$sc_end[$i] = $sat_end24;
					$sc_check[$i] = $sat_check;
					break;
		      	}

if($sc_start[$i]=="休み") {
echo <<< EOF
<td class="d h30 c">
<br />
休み<br />
<br />
</td>
EOF;
}
elseif($sc_start[$i]) {
echo <<< EOF
<td class="d h30 c">
{$sc_start[$i]}<br />
｜<br />
{$sc_end[$i]}
</td>
EOF;
}
else {
echo <<< EOF
<td class="d h30 c">
<br />
要TEL確認<br />
<br />
</td>
EOF;
}

}
echo <<< EOF
</tr>
</table>
EOF;
?>
</table>
<!--▲女の子出勤情報-->


<!--▼女の子動画-->
<?php
if ($movie_id){
echo <<< EOF
<a name="movie" id="movie"></a>
<p style="margin-top:20px;"><img src="{$furl}/img/tit_girl_movie.png" alt="女の子動画" /></p>
<div class="girl_movie">
<div class="movie_iframe">
<iframe width="640" height="480" src="https://www.youtube.com/embed/{$movie_code}?rel=0&modestbranding=1&fs=0&autohide=1" frameborder="0" allowfullscreen></iframe>
</div>

<div class="movie_poem">
<img src="{$furl}/img/movie_right_poem.png" alt="実際に、お店へ行けば胸もめる">
</div>
</div>
EOF;
}
?>
<!--▲女の子動画-->


</div>
</div>
<?php echo $footer; ?>