function _fetch()
{
$query = "\n\t\t\tSELECT\n\t\t\t\tclass_id,\n\t\t\t\tclass_external_id,\n\t\t\t\tclass_department,\n\t\t\t\tclass_number,\n\t\t\t\tclass_section,\n\t\t\t\tclass_semester,\n\t\t\t\tclass_year,\n\t\t\t\tclass_name,\n\t\t\t\tFK_owner,\n\t\t\t\tFK_ugroup,\n\t\t\t\tFK_classgroup\n\t\t\tFROM\n\t\t\t\tclass\n\t\t\tWHERE class_id='" . addslashes($this->id) . "'\n\t\t";
$r = db_query($query);
if (db_num_rows($r)) {
$a = db_fetch_assoc($r);
} else {
return false;
}
$this->code = generateCourseCode($a['class_id']);
$this->external_id = $a['class_external_id'];
$this->name = $a['class_name'];
$this->department = $a['class_department'];
$this->number = $a['class_number'];
$this->section = $a['class_section'];
$this->semester = $a['class_semester'];
$this->year = $a['class_year'];
$this->owner = $a['FK_owner'];
$this->ugroup = $a['FK_ugroup'];
$this->classgroup = $a['FK_classgroup'];
}
function doClassForm($a, $p = '', $e = 0)
{
global $cfg;
?>
<tr>
<td><?php
echo $e ? $a[$p . 'id'] : " ";
?>
</td>
<td><?php
echo $e ? generateCourseCode($a[$p . 'id']) : "";
?>
</td>
<td><input type='text' name='external_id' size='10' value="<?php
echo $a[$p . 'external_id'];
?>
" /></td>
<td><input type='text' name='name' size='20' value="<?php
echo $a[$p . 'name'];
?>
" /></td>
<td><input type='text' name='department' size='3' value="<?php
echo $a[$p . 'department'];
?>
" /></td>
<td><input type='text' name='number' size='3' value="<?php
echo $a[$p . 'number'];
?>
" /></td>
<td><input type='text' name='section' size='1' value="<?php
echo $a[$p . 'section'];
?>
" /></td>
<td><select name='semester'>
<?php
foreach (array_keys($cfg['semesters']) as $semesterKey) {
print "<option" . ($a[$p . 'semester'] == $semesterKey ? " selected='selected'" : "") . " value='" . $semesterKey . "'>";
print $cfg['semesters'][$semesterKey]['name'];
print "</option>";
}
?>
</select>
</td>
<td><input type='text' name='year' size='4' value="<?php
echo $a[$p . 'year'];
?>
" /></td>
<td><input type='text' name='owner' size='8' value="<?php
echo $a['classowner_uname'];
?>
" /> <a href="Javascript:sendWindow('addeditor',400,250,'add_editor.php?$sid&comingfrom=classes')">choose</a></td>
<td><?php
echo $a[classgroup_name];
?>
</td>
<td align='center'>
<input type='hidden' name='action' value='<?php
echo $e ? "edit" : "add";
?>
' />
<?php
echo $e ? "<input type='hidden' name='id' value='" . $a[$p . "id"] . "' /><input type='hidden' name='commit' value='1' />" : "";
?>
<a href='#' onclick='document.addform.submit()'><?php
echo $e ? "update" : "add class";
?>
</a>
<!-- | <a href='classes.php'>cancel</a> -->
</td>
</tr>
<?php
}
function isgroup($group)
{
global $_isgroup_cache;
if (isset($_isgroup_cache[$group])) {
return $_isgroup_cache[$group];
}
$query = "SELECT class_id FROM class INNER JOIN classgroup ON FK_classgroup = classgroup_id WHERE classgroup_name='" . addslashes($group) . "'";
$r = db_query($query);
if (db_num_rows($r)) {
$temp_c = array();
while ($a = db_fetch_assoc($r)) {
$temp_c[] = generateCourseCode($a[class_id]);
}
$_isgroup_cache[$group] = true;
return $temp_c;
}
$_isgroup_cache[$group] = false;
return 0;
}
</tr>
<?php
if ($numGroups) {
while ($a = db_fetch_assoc($r)) {
print "<tr>";
print "<td>";
print "{$a['classgroup_name']}";
print "</td>";
print "<td align='center'>";
print "<a href='{$PHP_SELF}?{$sid}&del=group&group={$a['classgroup_id']}'>[del]</a>";
print "</td>";
print "</tr>";
$query = "\n\t\t\tSELECT\n\t\t\t\t*\n\t\t\tFROM\n\t\t\t\tclassgroup\n\t\t\t\t\tINNER JOIN\n\t\t\t\tclass\n\t\t\t\t\tON\n\t\t\t\t\t\tFK_classgroup = classgroup_id\n\t\t\tWHERE\n\t\t\t\tclassgroup_id = {$a['classgroup_id']}\n\t\t";
$r2 = db_query($query);
while ($b = db_fetch_assoc($r2)) {
print "<tr>";
print "<td style='padding-left: 20px'>";
print "-> " . generateCourseCode($b[class_id]) . "</a>";
print "</td>";
print "<td align='center'>";
print "<a href='{$PHP_SELF}?{$sid}&del=class&group={$a['classgroup_id']}&class={$b['class_id']}'>[remove]</a>";
print "</td>";
print "</tr>";
}
}
} else {
print "<tr><td colspan='2'>No class groups.</td></tr>";
}
?>
</table><br />
<div align='right'><input type='button' value='Close Window' onclick='window.close()' /></div>
$yesterday = date(Ymd) - 1;
if (db_num_rows($r)) {
while ($a = db_fetch_assoc($r)) {
print "<tr>";
//print "<td class='td$color'><span style='white-space: nowrap;'>";
//print "<a href='viewlogs.php?$sid&site=$a[name]' style='color: #000;'>";
//print "$yesterday";
//if (strncmp($today, $a[editedtimestamp], 8) == 0 || strncmp($yesterday, $a[editedtimestamp], 8) == 0) print "<b>";
//print timestamp2usdate($a[editedtimestamp],1);
//if (strncmp($today, $a[editedtimestamp], 8) == 0 || strncmp($yesterday, $a[editedtimestamp], 8) == 0) print "</b>";
//print "</span>";
//print "</a>";
//print "</td>";
print "<td class='td{$color}'><a href='#' onclick=\"selectUser('" . $a[uname] . "')\" style='color: #000;'>{$a['fname']}</a></td>";
print "<td class='td{$color}'>{$a['uname']}</td>";
print "<td class='td{$color}'><a href='#' onclick=\"selectClass('" . generateCourseCode($a[id]) . "')\" style='color: #000;'>" . generateCourseCode($a[id]) . "</a></td>";
print "<td class='td{$color}'>{$a['type']}</td>";
/*print "<td class='td$color'><span style='color: #".(($a[active])?"090'>active":"900'>inactive")."</span></td>";
print "<td class='td$color'>$a[type]</td>";
print "<td class='td$color'><span style='color: #";
if ($a[viewpermissions] == 'anyone') print "000";
if ($a[viewpermissions] == 'midd') print "00c";
if ($a[viewpermissions] == 'class') print "900";
print "'>$a[viewpermissions]</span></td>";
print "<td class='td$color'>$a[theme]</td>";
print "<td class='td$color'>";
print "<a href='#' onclick='opener.window.location=\"index.php?$sid&action=site&site=$a[name]\"'>";
print "$a[title]";
print "</a>";
print "</td>";
print "<td class='td$color'>";
function getClassesFromName($name)
{
if (group::exists($name)) {
$query = "SELECT class_id FROM class INNER JOIN classgroup ON FK_classgroup = classgroup_id AND classgroup_name='" . addslashes($name) . "'";
// echo $query."<br />";
$r = db_query($query);
$classes = array();
while ($a = db_fetch_assoc($r)) {
$classes[] = generateCourseCode($a[class_id]);
}
return $classes;
}
return false;
}
