<?
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;
}

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);

//出勤表切替設定
if ($syukkin_chg == "") { $syukkin_chg = 0; }
$nowtime_hour = intval(date("G"));
$nowtime_min = intval(date("i"));
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 || ($nowtime_min > 29 && $now_hour >= $syukkin_chg) ) {
			$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"
			);
		} else {
			$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"
			);
		}
		break;
	case 2:
	default:
		if ($now_hour > $syukkin_chg || ($nowtime_min > 29 && $now_hour >= $syukkin_chg) ) {
			$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"
			);
		} else {
			$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"
			);
		}
		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";
$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'] = "</font>"; 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'] = "</font>"; break;
		default: $dispyoubi_list[$youbi_k] = ""; break;
	}
}

if (!is_array($worker_det)) {
	$worker_det = array();
}

$sql = "select * from event where del_flag = 0 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"]		= mb_convert_encoding($obj->event_text,VIEWCODE,"sjis-win");
		$event_list[$i]["event_url"]		= mb_convert_encoding($obj->event_url,VIEWCODE,"sjis-win");
	}
}

$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 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_view_list = array();
if ($num > 0) {
	for ($i=0 ; $i<$num ; $i++) {
		$obj     = pg_fetch_object($rtn, $i);
		$movie_view_list[$i]["event_no"]		= $obj->event_no;
		$movie_view_list[$i]["event_name"]		= mb_convert_encoding($obj->event_name,VIEWCODE,"sjis-win");
		$movie_view_list[$i]["event_image"]		= $obj->event_image;
		$movie_view_list[$i]["event_image_top"]	= $obj->event_image_top;
		$movie_view_list[$i]["view_type"]		= $obj->view_type;
		$movie_view_list[$i]["input_date"]		= $obj->input_date;
	}
}

$sql = "select * from newly_info where shop_no=${shop_no} and body!='' and del_flg='f' and regist_time <= now() and child_no=1";
$rtn = m_pg_exec($conn,$sql);
$Info_num = pg_num_rows($rtn);

$sql_ofs = "";
$sql = "select * from newly_info where shop_no=${shop_no} and body!='' and del_flg='f' and regist_time <= now() order by write_no desc,child_no";
$rtn = m_pg_exec($conn,$sql);
$num = pg_num_rows($rtn);

$Info = array();
if ($num > 0) {
	for ($i=0 ; $i<$num ; $i++) {
		$obj = pg_fetch_object($rtn,$i);
		$Info[$obj->write_no][$obj->child_no]['title'] = $obj->title;
		$Info[$obj->write_no][$obj->child_no]['lastup_time'] = substr($obj->lastup_time,0,16);
		$Info[$obj->write_no][$obj->child_no]['body'] = $obj->body;
	}
}
require_once $_SERVER['DOCUMENT_ROOT']."/ism_get_wintro.php";

$wintro = array();

$cate = 1;
$wintro[1] = get_wintro($shop_no,1);

if(0 <= intval(date("i")) && intval(date("i")) < 9){
	$view_standby_time = date("H").":10";
} else if(10 <= intval(date("i")) && intval(date("i")) < 19){
	$view_standby_time = date("H").":20";
} else if(20 <= intval(date("i")) && intval(date("i")) < 29){
	$view_standby_time = date("H").":30";
} else if(30 <= intval(date("i")) && intval(date("i")) < 39){
	$view_standby_time = date("H").":40";
} else if(40 <= intval(date("i")) && intval(date("i")) < 49){
	$view_standby_time = date("H").":50";
} else if(50 <= intval(date("i")) && intval(date("i")) < 59){
	$view_standby_time = date("H",strtotime("+1 hour")).":00";
}

/* そくヒメリスト */
$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 = "newface";
?>
<?php include_once(dirname(__FILE__) . "/../php/header.php"); ?>


<link rel="stylesheet" href="../common/css/project/girls.css">

<!--main-->
<main>

<!--subCONTENT-->
<div class="subCONTENT">

<!--head-->
<div class="head">
<h1><span>N</span>ew <span>F</span>ace<br></h1>
<h2>最近入店した女の子</h2>

<!--cp_breadcrumb-->
<div class="cp_breadcrumb">
<ul class="breadcrumbs">
<li><a href="https://purazaten-fuji.com/"><i class="fas fa-home"></i></a> <a href="../top">ホーム</a></li>
<li><a href="./">新人情報</a></li>
</ul>
</div>
<!--//cp_breadcrumb-->

</div>
<!--//head-->

<!--wrap-->
<div class="wrap">

<!--girlsLIST-->
<div class="girlsLIST">
<?php
$newface_ct = 0;
if (count($wintro[1])) {
	foreach ($wintro[1] as $k=>$v) {
		$worker = get_worker($k);
		if ($worker['att1'] == '/shop/purazatenfuji/img/noimage.png' || $worker['att1'] == '/shop/purazatenfuji/img/noimage.jpg') {
			//そのまま
			$worker['att1'] = "/common/img/noimages.jpg";
		}
		else {
			$worker['att1'] = "{$worker['att1']}";
		}

		$gra_ct = 0;
		if ($worker['att3'] != '/shop/purazatenfuji/img/noimage.png' && $worker['att3'] != '/shop/purazatenfuji/img/noimage.jpg' && $worker['att3'] != '') {
			$gra_ct++;
		}
		if ($worker['att31'] != '/shop/purazatenfuji/img/noimage_s.png' && $worker['att31'] != '/shop/purazatenfuji/img/noimage_s.jpg' && $worker['att31'] != '') {
			$gra_ct++;
		}
		if ($worker['att32'] != '/shop/purazatenfuji/img/noimage_s.png' && $worker['att32'] != '/shop/purazatenfuji/img/noimage_s.jpg' && $worker['att32'] != '') {
			$gra_ct++;
		}
		if ($worker['att33'] != '/shop/purazatenfuji/img/noimage_s.png' && $worker['att33'] != '/shop/purazatenfuji/img/noimage_s.jpg' && $worker['att33'] != '') {
			$gra_ct++;
		}
		if ($worker['att34'] != '/shop/purazatenfuji/img/noimage_s.png' && $worker['att34'] != '/shop/purazatenfuji/img/noimage_s.jpg' && $worker['att34'] != '') {
			$gra_ct++;
		}
		if ($worker['att35'] != '/shop/purazatenfuji/img/noimage_s.png' && $worker['att35'] != '/shop/purazatenfuji/img/noimage_s.jpg' && $worker['att35'] != '') {
			$gra_ct++;
		}

		$koe_list = array();
		$koe_list = getKoeList_u($worker['worker_no']);

		$syukkin_st = (!empty($syukkin_list[$date_list[0]][$worker['worker_no']]['syukkin_st'])) ? $syukkin_list[$date_list[0]][$worker['worker_no']]['syukkin_st'] : "";
		$syukkin_ed = (!empty($syukkin_list[$date_list[0]][$worker['worker_no']]['syukkin_ed'])) ? $syukkin_list[$date_list[0]][$worker['worker_no']]['syukkin_ed'] : "";

		if($worker['worker_name'] != ""){
?>
<li class="listitem">
<a href="../profile/?w=<?php echo($worker['worker_no']) ?>">
<figure>
<div class="situation">
<?php if($worker['image_icon05'] == 1){ ?><div class="icon-taiken">体験入店</div><?php } ?>
<?php if($worker['image_icon06'] == 1){ ?><div class="icon-new">新人</div><?php } ?>
<?php if($worker['image_icon08'] == 1){ ?><div class="icon-update">更新</div><?php } ?>
</div>
<img src="<?php echo($worker['att1']); ?>" width="600" height="800" alt="画像"/>
<?php if(array_key_exists($worker['worker_no'],$svm_list) && $svm_list[$worker['worker_no']]["sv_type"] == 1){ ?>
<div class="sokuhime reflection"><i class="fa-regular fa-clock"></i><?php echo($view_standby_time); ?>-待機中<?php if($svm_list[$worker["worker_no"]]["sv_plus_select"] == 1 || $svm_list[$worker["worker_no"]]["sv_plus_select"] == 2 || $svm_list[$worker["worker_no"]]["sv_plus_select"] == 3){ echo("（".mb_convert_encoding($view_plus_status_list[$svm_list[$worker["worker_no"]]["sv_plus_select"]],VIEWCODE,"sjis-win")."）"); } ?></div>
<?php } else if(array_key_exists($worker['worker_no'],$svm_list) && $svm_list[$worker['worker_no']]["sv_type"] == 2){ ?>
<div class="sokuhime nexttime reflection"><i class="fa-regular fa-clock"></i>次回-<?php echo(date("H:i",strtotime($today_date." ".$svm_list[$worker["worker_no"]]["sv_next_time"]))); ?><?php if($svm_list[$worker["worker_no"]]["sv_plus_select"] == 1 || $svm_list[$worker["worker_no"]]["sv_plus_select"] == 2 || $svm_list[$worker["worker_no"]]["sv_plus_select"] == 3){ echo("（".mb_convert_encoding($view_plus_status_list[$svm_list[$worker["worker_no"]]["sv_plus_select"]],VIEWCODE,"sjis-win")."）"); } ?></div>
<?php } else if(array_key_exists($worker['worker_no'],$svm_list) && $svm_list[$worker['worker_no']]["sv_type"] == 3){ ?>
<div class="sokuhime endtime reflection"><i class="fa-regular fa-clock"></i>受付終了</div>
<?php } ?>
</figure>
<h3><span><?php echo(mb_convert_encoding($worker['worker_name'],VIEWCODE,"sjis-win")) ?></span>（<?php echo(mb_convert_encoding($worker['age'],VIEWCODE,"sjis-win")) ?>歳）</h3>
<div class="size">T<?php echo(mb_convert_encoding($worker['tall'],VIEWCODE,"sjis-win")); ?> B<?php echo(mb_convert_encoding($worker['bust'],VIEWCODE,"sjis-win")); ?>(<?php echo(mb_convert_encoding($worker['bust_cup'],VIEWCODE,"sjis-win")); ?>) W<?php echo(mb_convert_encoding($worker['waist'],VIEWCODE,"sjis-win")); ?> H<?php echo(mb_convert_encoding($worker['hip'],VIEWCODE,"sjis-win")); ?></div>
<div class="catch"><?php echo(mb_convert_encoding($worker['free10'],VIEWCODE,"sjis-win")) ?>&nbsp;</div>
<div class="listicon">
<?php if(array_key_exists($worker['worker_no'],$movie_list)){ ?><div class="active"><img src="../common/image/listicon/icon-mov.png" width="100" height="100" alt=""/></div><?php } else { ?><div><img src="../common/image/listicon/icon-mov.png" width="100" height="100" alt=""/></div><?php } ?>
<?php if(count($koe_list) > 0){ ?><div class="active"><img src="../common/image/listicon/icon-voice.png" width="100" height="100" alt=""/></div><?php } else { ?><div><img src="../common/image/listicon/icon-voice.png" width="100" height="100" alt=""/></div><?php } ?>
<?php if($gra_ct > 0){ ?><div class="active"><img src="../common/image/listicon/icon-gravure.png" width="100" height="100" alt=""/></div><?php } else { ?><div><img src="../common/image/listicon/icon-gravure.png" width="100" height="100" alt=""/></div><?php } ?>
<?php if(!empty($worker['blog_url'])){ ?><div class="active"><img src="../common/image/listicon/icon-blog.png" width="100" height="100" alt="写メ日記"/></div><?php } else { ?><div><img src="../common/image/listicon/icon-blog.png" width="100" height="100" alt="写メ日記"/></div><?php } ?>
<?php if(!empty($worker['free11'])){ ?><div class="active"><img src="../common/image/listicon/icon-x.png" width="100" height="100" alt="X"/></div><?php } else { ?><div><img src="../common/image/listicon/icon-x.png" width="100" height="100" alt="X"/></div><?php } ?>
</div>
<div class="type">
<?php if(array_key_exists($worker['image_icon01'],$BUNRUI_ICON_LIST)){ ?><div><?php echo(mb_convert_encoding($BUNRUI_ICON_LIST[$worker['image_icon01']],VIEWCODE,"sjis-win")) ?></div><?php } ?>
<?php if(array_key_exists($worker['image_icon02'],$BUNRUI_ICON_LIST)){ ?><div><?php echo(mb_convert_encoding($BUNRUI_ICON_LIST[$worker['image_icon02']],VIEWCODE,"sjis-win")) ?></div><?php } ?>
<?php if(array_key_exists($worker['image_icon03'],$BUNRUI_ICON_LIST)){ ?><div><?php echo(mb_convert_encoding($BUNRUI_ICON_LIST[$worker['image_icon03']],VIEWCODE,"sjis-win")) ?></div><?php } ?>
<?php if(array_key_exists($worker['image_icon04'],$BUNRUI_ICON_LIST)){ ?><div><?php echo(mb_convert_encoding($BUNRUI_ICON_LIST[$worker['image_icon04']],VIEWCODE,"sjis-win")) ?></div><?php } ?>
</div>
<!--div class="schtime">本日 <i class="fa-regular fa-clock"></i>10:00-18:00</div-->
</a>
</li>
<?php
			$newface_ct++;
			// 表示件数制限
//			if($newface_ct >= 4){
//				break;
//			}
		}
	}
}
?>
</div>
<!--//girlsLIST-->

</div>
<!--//wrap-->
</div>
<!--//subCONTENT-->

</main>
<!--//main-->


<script src="../common/js/jquery-3.5.1.min.js"></script>
<script src="../common/js/easing.js"></script>
<script src="../common/js/matchHeight.js"></script>
<script src="../common/js/shadowbox.js"></script>
<script src="../common/js/swiper.min.js"></script>
<script src="../common/js/common.js"></script>

<?php include_once(dirname(__FILE__) . "/../php/footer.php"); ?>