function getCalendarLecture($obj)
{
$conn = getConnection();
$list_class = getAllActiveBatchClassByBatch($obj);
$list = array();
//Lectures
$complete = 'calendar_green';
$cancelled = 'calendar_red';
$pending = 'calendar_blue';
for ($i = 0; $i < count($list_class); $i++) {
$conn = getConnection();
$query = "SELECT * FROM lecture WHERE activeflag=1 AND batchclassID='" . $list_class[$i]->getID() . "' ORDER BY end_datetime DESC";
$result = mysql_query($query);
while ($member = mysql_fetch_array($result)) {
//$temp = getLecture($member['ID']);
if ($member['status'] == 1) {
$colour = $complete;
} else {
$colour = $cancelled;
}
$temp = array('title' => getBatchClass($member['batchclassID'])->getName() . ' : ' . getUser($member['teacherID'])->getName(), 'start' => $member['start_datetime'], 'end' => $member['end_datetime'], 'className' => $colour, 'allDay' => false, 'url' => 'viewLectureDetails.php?id=' . $member['ID']);
array_push($list, $temp);
}
}
//Lecture Templates
for ($i = 0; $i < count($list_class); $i++) {
$conn = getConnection();
$query = "SELECT * FROM template_lecture WHERE activeflag=1 AND status!=1 AND batchclassID='" . $list_class[$i]->getID() . "' ORDER BY start_date DESC";
$result = mysql_query($query);
while ($member = mysql_fetch_array($result)) {
$start = $member['start_date'] . ' ' . $member['start_time'];
$end = $member['start_date'] . ' ' . $member['end_time'];
if ($member['status'] == 1) {
$colour = $complete;
$temp = array('title' => getBatchClass($member['batchclassID'])->getName() . ' : ' . getUser($member['teacherID'])->getName(), 'start' => $start, 'end' => $end, 'className' => $colour, 'allDay' => false);
} elseif ($member['status'] == -1) {
$colour = $pending;
$temp = array('title' => getBatchClass($member['batchclassID'])->getName() . ' : ' . getUser($member['teacherID'])->getName(), 'start' => $start, 'end' => $end, 'className' => $colour, 'allDay' => false, 'url' => 'addLectureFromTemplate.php?id=' . $member['ID']);
} else {
$colour = $cancelled;
$temp = array('title' => getBatchClass($member['batchclassID'])->getName() . ' : ' . getUser($member['teacherID'])->getName(), 'start' => $start, 'end' => $end, 'className' => $colour, 'allDay' => false);
}
array_push($list, $temp);
}
//$temp = getLectureTemplate($member['ID']);
//$temp = array('title' => getUser($member['teacherID'])->getName(),'start' =>$member['start_datetime'],'end' => $member['end_datetime'],'className' => 'calendar_blue','allDay' => false);
}
if (count($list) != 0) {
return $list;
}
return NULL;
}
function getFullDisplay()
{
return getBatchClass($this->batchclassID)->getBestDisplay();
}
function updateBatchClass($batchID, $extra, $name, $activeflag, $id)
{
$conn = getConnection();
$Obj = getBatchClass($batchID);
$Obj->setName($name);
$Obj->setInfo($extra);
$Obj->setActiveFlag($activeflag);
$Obj->setCreatedBy($id);
$result = $Obj->update();
if ($result) {
$message = "Batch Class Updated Successfully :" . $name;
} else {
$message = "Batch Class Updation Failed : " . $name;
}
return $message;
}
function getClassObj()
{
if ($this->ClassID != 0) {
return getBatchClass($this->ClassID);
} else {
return NULL;
}
}
function read()
{
$conn = getConnection();
$query = "SELECT * FROM student WHERE ID='" . $this->ID . "'";
$result = mysql_query($query);
if (!$result) {
return;
} else {
$member = mysql_fetch_array($result);
$this->setMainID(trim($member['mainID']));
$this->setRollNo(trim($member['rollno']));
$this->setGRno(trim($member['grno']));
$this->setFirstName(trim($member['firstname']));
$this->setLastName(trim($member['lastname']));
$this->setFname(trim($member['Fname']));
$this->setBatchObj(getBatch($member['batchID']));
$this->setExamYear(trim($member['examyear']));
$this->setActiveFlag(trim($member['activeflag']));
$this->setClassObj(getBatchClass($member['classID']));
$this->BranchObj = getBranch($this->getBatchObj()->getID());
$this->setLoginFlag(trim($member['loginflag']));
}
}
