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; }