'.chr(10);
$now_mon = date('Y-m-d', strtotime($this_monday) + 7*60*60*24*$i);
$now_sun = date('Y-m-d', strtotime('+6 days '.$now_mon));
$cal_html .= '
'.chr(10);
$cal_html .= '
'.chr(10);
$cal_html .= ''.chr(10);
for($p=0;$p<7;$p++){
if($p == 5){
$th_class = ' class="w6"';
} elseif($p == 6){
$th_class = ' class="w0"';
} else {
$th_class = '';
}
$p_day = '+'.$p.' day '.$now_mon;
$cal_html .= ''.date('n/j', strtotime($p_day)).'
（'.$week_arry[$p].'）'.chr(10);
}
$cal_html .= ''.chr(10);
for($p=0;$p<7;$p++){
$cal_html .= '| | '.chr(10);
}
$cal_html .= '
'.chr(10);
$cal_html .= '
'.chr(10);
$cal_html .= '
'.chr(10);
if($i == 0){
//最初の週以前に開始のイベント
$sql = "select *from news where shop_code='event' and exp=1 and startday<='$todayMySQL' and lastday>='$todayMySQL' and openday<='$now_mon' and endday>='$now_mon' order by cate,openday";
$result = $db->query($sql);
if (!$result){
print ("SQLの実行に失敗しました：イベントカレンダー週内開始読出し
");
print('$sql='.$sql.'
');
exit;
} else {
$opend_events = $result->fetchAll(PDO::FETCH_ASSOC);
}
$num = 0;
if(count($opend_events) > 0){
foreach($opend_events as $data){
//日数
$ev_days = (strtotime($data['endday']) - strtotime($now_mon)) / (60*60*24) + 1;
//7日以上の場合翌週のスロットを埋める
$next_p = $i + 1;
if($ev_days > 7) $slot[$next_p][$i] = 1;
//14日以上の場合翌々週のスロットを埋める
$next_np = $i + 2;
if($ev_days > 14) $slot[$next_np][$i] = 1;
$width_style = ($ev_days > 7)?' width:'.(14.25 * $ev_days).'%;':'';
$cal_html .= '- '.$data['news_tit'].'
'.chr(10);
if($ev_days == 1) $num++;
$num++;
$pre_row = $num;
}
}
}
//print('$pre_row='.$pre_row.'
');
//この週開始日のイベント
$sql = "select *from news where shop_code='event' and exp=1 and startday<='$todayMySQL' and lastday>='$todayMySQL' and openday>='$now_mon' and openday<='$now_sun' order by cate,openday";
$result = $db->query($sql);
if (!$result){
print ("SQLの実行に失敗しました：イベントカレンダー週内開始読出し
");
print('$sql='.$sql.'
');
exit;
} else {
$events = $result->fetchAll(PDO::FETCH_ASSOC);
}
/*
print('
');
print_r($events);
print('');
*/
if(count($events) > 0){
$e = 0;
foreach($events as $data){
//日数
$op_utime = strtotime($data['openday']);
$ev_days = (strtotime($data['endday']) - $op_utime) / (60*60*24) + 1;
//print('$ev_days='.$ev_days.'
');
$width_style = ($ev_days > 7)?' width:'.(14.25 * $ev_days).'%;':'';
//開始曜日
$ev_wday = date('w', $op_utime);
//翌週へ続く場合翌週のスロットを埋める
if($ev_wday == 0) {
$this_col = 1;
} else {
$this_col = 8 - $ev_wday;
}
if($ev_days - $this_col > 0){
$next_p = $i + 1;
$slot[$next_p][$e] = 1;
if($ev_days - $this_col > 7){
$next_np = $i + 2;
$slot[$next_np][$e] = 1;
}
}
for($s=$pre_row;$s<20;$s++){
if(isset($slot[$i][$s]) && $slot[$i][$s] == 1){
continue;
} else {
$this_slot =$s;
$slot[$i][$s] = 1;
$num = $s;
if($ev_days ==1){
$next_row = $s+1;
if(isset($slot[$i][$next_row]) && $slot[$i][$next_row] == 1){
} else {
$slot[$i][$next_row] = 1;
$num = $next_row +1;
}
//print('strlen='.strlen($data['news_tit']).'
');
if(strlen($data['news_tit']) > 39){
$this_h = 78;
$next_row++;
$slot[$i][$next_row] = 1;
$num++;
} else {
$this_h = 52;
}
$max_height = 'height:'.$this_h.'px;overflow:hidden;;';
} else {
$max_height = '';
$num++;
}
break;
}
}
if ($data['cate'] == 1){
$page_url = 'wagon.html';
} elseif ($data['cate'] == 2){
$page_url = 'sound.html';
} else {
$page_url = '';
}
$cal_html .= '
'.$data['news_tit'].''.chr(10);
//$cal_html .= '
'.$data['news_tit'].''.chr(10);
//if($ev_days == 1) $num++;
//$num++;
$e++;
}
}
//print('$num='.$num.'
');
if($num_max < $num) $num_max = $num;
if($num_max == 0) $num_max = 1;
$cal_html .= ''.chr(10);
$cal_html .= '