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