or DELETE$cMo $cYR $dow $day $time $descr ';
// first week blanks
for ($iDay=1; $iDay<=$DoW1st-1; $iDay++)
$calDet .= 'x ';
// first week dates
$numDays = 8-$DoW1st;
for ($iDay=1; $iDay<=$numDays; $iDay++):
$mDate = cdtom("$mo/$iDay/$YR");
$mo = $_SESSION['mo']; $YR = $_SESSION['YR'];
if ($mDate == $today):
// pink background
$calDet .= "
$iDay ";
else:
$calDet .= "
$iDay ";
endif;
$sql = "select * from cal where date = '$mDate'";
$cur = sql($sql);
$nRows = reccount();
if ($nRows > 0):
$i = 1;
while ($row = getRow($cur,$i)):
extract($row);
$calDet .= "
$time $descr ";
if ($i == $nRows)
break;
$i += 1;
endwhile;
endif;
endfor;
// rest of dates
$day1 = 9-$DoW1st;
for ($iDay=$day1; $iDay<=$nDays; $iDay++):
$dow = date('w',ctod("$mo/$iDay/$YR")); // 0=sunday
if ($dow == 0)
// sunday, start new line
$calDet .= ' ';
$mDate = cdtom("$mo/$iDay/$YR");
if ($mDate == $today)
// put red chk mk along side date
$calDet .= "
$iDay ";
else
$calDet .= "
$iDay ";
// loop thru apts for date
$sql = "select * from cal where date = '$mDate'";
//order by substring(REPLACE(concat('0',time),'12:','00:'),-7), substr(time,-2) ";
$cur = sql($sql);
$nRec = reccount();
if ($nRec > 0):
$i = 1;
while ($row = getRow($cur,$i)):
extract($row);
$calDet .= "";
$calDet .= " ";
if ($i == $nRec)
break;
$i += 1;
endwhile;
endif;
endfor;
// finish last line
$nd = 6-$dow;
for ($j=1; $j<=$nd; $j++)
$calDet .= ' x ';
$calDet .= ' ';
include ('cal.inc');
//msgarr($_SESSION);
}
///////////////////////////////////////////////
function getMoList(){
$mo = $_SESSION['mo'];
$YR = $_SESSION['YR'];
//start 6 mo back, go for 13 mo = 19 mo
$today = date('m/d/Y');
$curMo = date('m',ctod($today));
$curYR = date('Y',ctod($today));
//$cDate = dateplus(dtoc($date),-181);
$cDate = dateplus(dtoc(ctod($today)),-181);
$mo = date('m',ctod($cDate));
$YR = date('Y',ctod($cDate));
$moList = '';
for ($i=1; $i<=20; $i++):
$val = 100*$YR+$mo;
$disp = date('M',ctoD($cDate)).' '.$YR;
// select option with current date
if ($mo == $curMo and $YR == $curYR) :
$moList .= "$disp \n";
else:
$moList .= "
$disp \n";
endif;
if ($mo == 12):
$mo = 1;
$YR += 1;
else:
$mo += 1;
endif;
$cDate = "$mo/1/$YR";
endfor;
return $moList;
}
////////////////////////
function start(){
// set error reporting and connects to mysql based on server, initializes mo, YR session vart
session_start();
$Server=substr($_SERVER['SERVER_SOFTWARE'],0,6);
$site = $_SERVER['SERVER_NAME'];
if ($Server=='Abyss/')
error_reporting(E_ALL); // testing only
else
// error_reporting(0);
error_reporting(0); // production
include ('../common/mysqli.php');
include ('../common/functions.php');
if ($Server=='Abyss/'):
$host='localhost'; $user='php';$password = 'jack'; $db = 'cal';
//elseif (strpos($site,'iketrain.net') > 0):
// host-ed
// $host='localhost'; $user='biketra1_php'; //
// $password='s!vf~L_YP2d1{[S';
// $db = 'biketra1_cal';
else:
// hustly
$host='localhost:3306'; $user = 'php1'; $password='Jackie$522543';
$db = 'jobtrakliteh_cal';
endif;
//msg("$host,$user,$password");
openDb($host,$user,$password);
$r = sql("use $db");
if (!isset($_SESSION['mo'])):
// not set, use current mo, YR;
// current yr
$YR = date('Y',time());
// current month
$mo = date('m',time());
$_SESSION['mo'] = $mo;
$_SESSION['YR'] = $YR;
endif;
}
////////////////////////////////////////////////////////////
function get1st(){
$today = date('Y-m-d');
$d = date("Y-m-01", strtotime($today));
$d = ctod($d);
return dtoc($d);
}
?>