12){
$monthNext=1;
$yearNext=$year+1;
}else{
$yearNext=$year;
}
$mkdate_today=mktime(0,0,0,date('m'),date('j'),date('Y'));
$mkdate=mktime(0,0,0,$month,1,$year);
$full_month=date('F',$mkdate);
$weekday=date('w',$mkdate);
$last_days=date('t',$mkdate);
$day=1;
//-----set month,year for query
$months=str_pad($month,2,"0",STR_PAD_LEFT);
$sdateCk=mktime(0,0,0, $months,1 , $year); //m d y
$edateCk=mktime(0,0,0, $months, $last_days, $year);
//----query data
$condition=" ((date_start BETWEEN ".$sdateCk." AND ".$edateCk.") OR (date_end BETWEEN ".$sdateCk." AND ".$edateCk."))";
$condition.=" AND date_status='Online'";
$condition.=" ORDER BY date_start ";
//---------------------------home photo-------------------
$rsData=$objSelect->selectRecord('tbltraining_date',$condition,'');
if($num=mysql_num_rows($rsData)){
$p=1;
while($row=mysql_fetch_array($rsData)){
$conditionA=" activities_id='".$row['activities_id']."' ";
$conditionA.=" and activities_status='Online' ";
//---------------------------home photo-------------------
$rsDataA=$objSelect->selectRecord('tbltraining_activities',$conditionA,'');
if($rowA=mysql_fetch_array($rsDataA)){
$idActivities[$p]=$rowA['activities_id'];
$sDate[$p]=$row['date_start'];
$eDate[$p]=$row['date_end'];
$idDate[$p]=$row['date_id'];
$gStart=date('j',$row['date_start']);
$gEnd=date('j',$row['date_end']);
$type=$row['calendar_course'];
if($gStart>$gEnd){
if(date('m',$row['date_start'])==$month){
$gEnd=$last_days;
}else{
$gStart=1;
}
}
for($i=$gStart;$i<=$gEnd;$i++){
$list[$i].='yes';
$link[$i]='date_id='.$row['date_id'].'&activities_id='.$row['activities_id'].'&month='.$month.'&year='.$year;
}//----end for
$p++;
}//----end if($rowA=mysql_fetch_array($rsDataA)){
}
}
if($_GET['txtNo']!=""){
$idActivities='';
$condition=" ((date_start<=".$_GET['txtNo'].")AND(date_end>=".$_GET['txtNo']."))";
$condition.=" AND date_status='Online'";
$condition.=" ORDER BY activities_id,date_start";
//---------------------------home photo-------------------
$rsData=$objSelect->selectRecord('tbltraining_date',$condition,'');
$p=1;
while($row=mysql_fetch_array($rsData)){
$idActivities[$p]=$row['activities_id'];
$p++;
}
}
?>
บริษัท การจัดการธุรกิจ จำกัด (Business Management Co., Ltd)
Activities Calendar
  |
| อาทิตย์ |
จันทร์ |
อังคาร |
พุธ |
พฤหัสบดี |
ศุกร์ |
เสาร์ |
'.($last_days-$p).'';
$start++;
$p=$p-1;
}
$weekday++;
while($day<=$last_days){
$txtNo_date=mktime(0,0,0,$months,$day,$year);
if($mkdate_today==$txtNo_date){$class='class="TdDate_current"';}else{$class='';}
if($list[$day]!=""){
echo '| '.$day.' | ';
}else{
echo ''.$day.' | ';
}//---end if($list[$day]!=""){
if($weekday==7 and $day!=$last_days){
echo '
';
$weekday=0;
}
$day++;
$weekday++;
}
while($weekday<=7){
echo '| | ';
$weekday++;
} ?>
วันที่ |
หลักสูตร |
วิทยากร |
$value){
if(!in_array($value,$idK)){
$idK[$key]=$value;
$showDate=showDate($value);
$conditionA=" activities_id='".$value."' ";
$conditionA.=" and activities_status='Online' ";
//---------------------------home photo-------------------
$rsDataA=$objSelect->selectRecord('tbltraining_activities',$conditionA,'');
if($numA=mysql_num_rows($rsDataA)){
$rowA=mysql_fetch_array($rsDataA);?>
>
|
|
|
|
| No Data! |
วันที่มีกิจกรรม (คลิกที่วันที่เพื่อดูกิจกรรม)