public function TagsByQuery($module, $config)
{
$ret = array();
$rows = TagQuery::TagsByQuery($this->db, $module, $config);
while ($d = $this->db->fetch_array($rows)) {
$ret[] = $d['tag'];
}
return $ret;
}
public static function ExpeledGroupList(Ab_Database $db)
{
$sql = "\n\t\t\tSELECT \n \t\t\tDISTINCT groupid\n \t\tFROM " . $db->prefix . "rb_students\n \t\tWHERE transferal = 1\n\t\t";
$rows = $db->query_read($sql);
$group = '';
while ($dd = $db->fetch_array($rows)) {
$group .= $dd["groupid"] . ',';
}
if (strlen($group) > 0) {
$rowid = substr($group, 0, -1);
$sql = "\n\t\t\t \t\tSELECT\n\t \t\t\t\t\t\tg.groupid as id,\n\t\t\t \t\t\t\tg.numgroup,\n\t\t\t \t\t\t\tg.numcrs,\n\t\t\t \t\t\t\tg.dateline,\n\t\t\t \t\t\t\tf.fieldid,\n\t\t\t \t\t\t\tp.code,\n\t\t\t \t\t\t\tp.name,\n\t \t\t\t\t\t\tf.frmstudy,\n\t \t\t\t\t\t\tf.note,\n\t\t\t \t\t\t\tf.remove\n\t\t\t \t\tFROM " . $db->prefix . "rb_groups g\n\t\t\t \t\tINNER JOIN " . $db->prefix . "rb_fieldstudy f ON g.fieldid = f.fieldid\n\t\t\t \t\tINNER JOIN " . $db->prefix . "un_edulevel e ON f.edulevelid = e.edulevelid\n \t\t\t\t\tINNER JOIN " . $db->prefix . "un_program p ON p.programid = e.programid\n\t\t\t \t\tWHERE g.groupid IN (" . $rowid . ")\n\t\t\t \t\t\t\t\tAND g.remove=0\n\t\t\t \t";
return $rows = $db->query_read($sql);
}
}
