public function get_files($typeID)
{
$this->db->order_by('name', 'asc');
$query = $this->db->get_where('file', array('typeID' => $typeID));
$files = array();
$i = 0;
foreach ($query->result() as $row) {
$files[$i]['fileID'] = $row->fileID;
$files[$i]['typeID'] = $row->typeID;
$files[$i]['categoryID'] = $row->categoryID;
$files[$i]['name'] = $row->name;
$files[$i]['description'] = $row->description;
$files[$i]['fullpath'] = $row->fullpath;
$files[$i]['filename'] = $row->filename;
$files[$i]['extension'] = str_replace('.', '', $row->extension);
$files[$i]['mimetype'] = $row->mimetype;
$files[$i]['title'] = $row->title;
$files[$i]['size'] = $row->size;
$files[$i]['width'] = $row->width;
$files[$i]['height'] = $row->height;
$files[$i]['created'] = $row->created;
$files[$i]['created_by'] = $row->created_by;
$files[$i]['modified'] = $row->modified;
$files[$i]['modified_by'] = $row->modified_by;
$files[$i]['row_color'] = $this->color = cp_get_color($this->color);
$i++;
}
return $files;
}
public function get_einsatz_cue_list()
{
$this->db->order_by('name', 'ASCENDING');
$query = $this->db->get('einsatz_cue');
$einsatz_cues = array();
$i = 0;
foreach ($query->result() as $row) {
$cue = new Einsatz_cue_Model();
$cue->id = $row->cueID;
$cue->name = $row->name;
$cue->mimic = $row->mimic;
$cue->example = $row->example;
$cue->aao = $row->aao;
$cue->row_color = $this->color = cp_get_color($this->color);
$this->db->where('cueID', $row->cueID);
$this->db->from('einsatz_content');
$count = $this->db->count_all_results();
if ($count >= 1) {
$cue->deletable = 0;
} else {
$cue->deletable = 1;
}
$einsatz_cues[$i] = $cue;
$i++;
}
return $einsatz_cues;
}
public function get_team_liste()
{
$this->db->order_by('name', 'ASCENDING');
$query = $this->db->get('mannschaft_team');
$teams = array();
$i = 0;
foreach ($query->result() as $row) {
$team = new Funktion_Model();
$team->id = $row->teamID;
$team->name = $row->name;
$team->row_color = $this->color = cp_get_color($this->color);
$teams[$i] = $team;
$i++;
}
return $teams;
}
public function get_funktion_liste()
{
$this->db->order_by('orderID', 'ASCENDING');
$query = $this->db->get('mannschaft_fuehrungsfunktion');
$funktionen = array();
$i = 0;
foreach ($query->result() as $row) {
$funktion = new Funktion_Model();
$funktion->id = $row->funktionID;
$funktion->name = $row->name;
$funktion->orderID = $row->orderID;
$funktion->row_color = $this->color = cp_get_color($this->color);
$funktionen[$i] = $funktion;
$i++;
}
return $funktionen;
}
public function get_abteilung_liste()
{
$this->db->order_by('orderID', 'ASCENDING');
$query = $this->db->get('mannschaft_abteilung');
$abteilungen = array();
$i = 0;
foreach ($query->result() as $row) {
$abteilung = new Funktion_Model();
$abteilung->id = $row->abteilungID;
$abteilung->name = $row->name;
$abteilung->orderID = $row->orderID;
$abteilung->row_color = $this->color = cp_get_color($this->color);
$abteilungen[$i] = $abteilung;
$i++;
}
return $abteilungen;
}
public function get_mannschaft_liste()
{
$this->db->select('mannschaftID, name, vorname, online');
$query = $this->db->get('v_mannschaft');
$team = array();
$i = 0;
foreach ($query->result() as $row) {
$mannschaft = new Mannschaft_Model();
$mannschaft->mitgliedID = $row->mannschaftID;
$mannschaft->name = $row->name;
$mannschaft->vorname = $row->vorname;
$mannschaft->online = $row->online;
$mannschaft->row_color = $this->color = cp_get_color($this->color);
$team[$i] = $mannschaft;
$i++;
}
return $team;
}
public function get_dienstgrad_liste()
{
$this->db->order_by('orderID', 'ASCENDING');
$query = $this->db->get('mannschaft_dienstgrad');
$dienstgrade = array();
$i = 0;
foreach ($query->result() as $row) {
$dienstgrad = new Dienstgrad_Model();
$dienstgrad->id = $row->dienstgradID;
$dienstgrad->name = $row->name;
$dienstgrad->name_w = $row->name_w;
$dienstgrad->name_m = $row->name_m;
$dienstgrad->img = $row->img;
$dienstgrad->orderID = $row->orderID;
$dienstgrad->row_color = $this->color = cp_get_color($this->color);
$dienstgrade[$i] = $dienstgrad;
$i++;
}
return $dienstgrade;
}
public function get_user_list($id = 0)
{
if ($id != 0) {
$this->db->where('userID', $id);
}
$this->db->order_by('last_name', 'asc');
$query = $this->db->get($this->db_user_table);
$i = 0;
foreach ($query->result() as $row) {
$counter = $i + 1;
$this->user[$i]['row_color'] = $this->color = cp_get_color($this->color);
$this->user[$i]['id'] = $counter;
$this->user[$i]['userID'] = $row->userID;
$this->user[$i]['username'] = $row->username;
$this->user[$i]['email'] = $row->email;
$this->user[$i]['vorname'] = $row->first_name;
$this->user[$i]['nachname'] = $row->last_name;
$this->user[$i]['active'] = $row->active;
$i++;
}
return $this->user;
}
public function get_value_list($key = null, $order = null)
{
if ($key != null) {
$this->db->where('keyword', $key);
}
if ($order != null) {
$this->db->order_by($order[0], $order[1]);
}
$query = $this->db->get('autosuggest_values');
$values = array();
$i = 0;
foreach ($query->result() as $row) {
$value = new Autosuggest_model();
$value->id = $row->autosuggestID;
$value->keyword = $row->keyword;
$value->value = $row->value;
$value->row_color = $this->color = cp_get_color($this->color);
$values[$i] = $value;
$i++;
}
return $values;
}
public function get_email_list()
{
$this->db->order_by('purpose', 'ASC');
$this->db->order_by('email', 'ASC');
$query = $this->db->get('info_email');
$emails = array();
$i = 0;
foreach ($query->result() as $row) {
$emails[$i]['id'] = $row->emailID;
$emails[$i]['email'] = $row->email;
$emails[$i]['forwarded'] = str_replace(',', '<br>', $row->forwarded_mails);
$emails[$i]['purpose'] = $row->purpose;
$emails[$i]['type'] = $row->type;
if ($row->size == '' || $row->size == 0) {
$emails[$i]['size'] = '-';
} else {
$emails[$i]['size'] = $row->size . ' MB';
}
$emails[$i]['row_color'] = $this->color = cp_get_color($this->color);
$i++;
}
return $emails;
}
public function get_news_categories()
{
$query = $this->db->get('news_category');
$cat = array();
$i = 0;
foreach ($query->result() as $row) {
$cat[$row->categoryID]['categoryID'] = $row->categoryID;
$cat[$row->categoryID]['title'] = $row->title;
$cat[$row->categoryID]['row_color'] = $this->color = cp_get_color($this->color);
$i++;
}
return $cat;
}
public function get_routes($restrict = 'none')
{
if ($restrict == 'active') {
$this->db->where('sys_routes.active', 1);
}
$this->db->order_by('bereich', 'asc');
$this->db->order_by('name', 'asc');
$this->db->order_by('route', 'asc');
$this->db->join('module', 'module.moduleID = sys_routes.moduleID');
$query = $this->db->get('sys_routes');
$routes = array();
$i = 0;
foreach ($query->result() as $row) {
$routes[$i]['routeID'] = $row->routeID;
$routes[$i]['moduleName'] = $row->name;
$routes[$i]['bereich'] = $row->bereich;
$routes[$i]['internalLink'] = $row->internal_link;
$routes[$i]['route'] = $row->route;
$routes[$i]['active'] = $row->active;
$routes[$i]['row_color'] = $this->color = cp_get_color($this->color);
$i++;
}
return $routes;
}
public function get_adminmessage()
{
$this->load->helper('html');
$message = array();
$this->color = cp_get_color($this->color);
$query = $this->db->get('admin_message');
$row = $query->row();
$userdata = $this->cp_auth->cp_get_user_by_id($row->userID);
$message['datetime'] = cp_get_ger_datetime($row->datetime);
$message['editor'] = $userdata->first_name . ' ' . $userdata->last_name;
$message['titel'] = $row->title;
$message['message'] = $row->message;
$message['rowColor'] = $this->color;
return $message;
}
public function get_menue_list($online)
{
$menue = array();
$menue_meta = array();
$menue_shortlink = array();
$count = 0;
$count_meta = 0;
$count_shortlink = 0;
$where = array($this->area => 1, 'superID' => 0, 'section' => 'main');
if ($online == 'online') {
$where['online'] = 1;
}
$this->db->order_by('orderID', 'asc');
$query = $this->db->get_where('menue', $where);
$count = $query->num_rows();
$i = 0;
foreach ($query->result() as $row) {
$menue[$i]['menueID'] = $row->menueID;
$menue[$i]['name'] = $row->name;
$menue[$i]['link'] = $row->link;
$menue[$i]['target'] = $row->target;
$menue[$i]['slug'] = $row->slug;
$menue[$i]['online'] = $row->online;
$menue[$i]['orderID'] = $row->orderID;
$menue[$i]['row_color'] = $this->color = cp_get_color($this->color);
$where = array('superID' => $row->menueID);
if ($online == 'online') {
$where['online'] = 1;
}
$this->db->order_by('orderID', 'asc');
$query2 = $this->db->get_where('menue', $where);
$menue[$i]['subItems'] = $query2->num_rows();
if ($query2->num_rows() != 0) {
$j = 0;
foreach ($query2->result() as $row2) {
$menue[$i]['submenue'][$j]['menueID'] = $row2->menueID;
$menue[$i]['submenue'][$j]['name'] = $row2->name;
$menue[$i]['submenue'][$j]['link'] = $row2->link;
$menue[$i]['submenue'][$j]['target'] = $row2->target;
$menue[$i]['submenue'][$j]['slug'] = $row2->slug;
$menue[$i]['submenue'][$j]['online'] = $row2->online;
$menue[$i]['submenue'][$j]['orderID'] = $row2->orderID;
$menue[$i]['submenue'][$j]['row_color'] = $this->color = cp_get_color($this->color);
$j++;
}
}
$i++;
}
$where = array($this->area => 1, 'section' => 'meta');
if ($online == 'online') {
$where['online'] = 1;
}
$this->db->order_by('orderID', 'asc');
$query = $this->db->get_where('menue', $where);
$i = 0;
$count_meta = $query->num_rows();
foreach ($query->result() as $row) {
$menue_meta[$i]['menueID'] = $row->menueID;
$menue_meta[$i]['name'] = $row->name;
$menue_meta[$i]['link'] = $row->link;
$menue_meta[$i]['target'] = $row->target;
$menue_meta[$i]['slug'] = $row->slug;
$menue_meta[$i]['online'] = $row->online;
$menue_meta[$i]['orderID'] = $row->orderID;
$menue_meta[$i]['row_color'] = $this->color = cp_get_color($this->color);
$i++;
}
$where = array($this->area => 1, 'section' => 'shortlink');
if ($online == 'online') {
$where['online'] = 1;
}
$this->db->order_by('orderID', 'asc');
$query = $this->db->get_where('menue', $where);
$i = 0;
$count_shortlink = $query->num_rows();
foreach ($query->result() as $row) {
$menue_shortlink[$i]['menueID'] = $row->menueID;
$menue_shortlink[$i]['name'] = $row->name;
$menue_shortlink[$i]['link'] = $row->link;
$menue_shortlink[$i]['target'] = $row->target;
$menue_shortlink[$i]['slug'] = $row->slug;
$menue_shortlink[$i]['online'] = $row->online;
$menue_shortlink[$i]['orderID'] = $row->orderID;
$menue_shortlink[$i]['row_color'] = $this->color = cp_get_color($this->color);
$i++;
}
$menue_ret['menue'] = $menue;
$menue_ret['menue_meta'] = $menue_meta;
$menue_ret['menue_shortlink'] = $menue_shortlink;
$menue_ret['count'] = $count;
$menue_ret['count_meta'] = $count_meta;
$menue_ret['count_shortlink'] = $count_shortlink;
return $menue_ret;
}
<table cellpadding="0" cellspacing="1" id="user_table" class="tablesorter">
<thead>
<tr>
<th class="headline_id">ID</td>
<th class="headline_name">Benutzername</td>
<th class="headline_mail">Email</td>
<th class="headline_name">Nachname</td>
<th class="headline_name">Vorname</td>
<th class="headline_name">Gruppe</td>
<th class="headline_status">Status</td>
<th colspan="3" class="headline_edit">Edit</td>
</tr>
</thead>
<tbody>
<? foreach($user as $u) :
$row_color = cp_get_color($row_color);
$i++;
?>
<tr bgcolor="<?php
echo $row_color;
?>
">
<td><?php
echo str_pad($i, 5, '0', STR_PAD_LEFT);
?>
</td>
<td><?php
echo $u->uacc_username;
?>
</td>
<td><?php
public function get_images($id)
{
$query = $this->db->get_where('fahrzeug_img', array('fahrzeugID' => $id));
$images = array();
$i = 0;
foreach ($query->result() as $row) {
$this->color = cp_get_color($this->color);
$images[$i]['imageID'] = $row->imgID;
$images[$i]['fahrzeugID'] = $row->fahrzeugID;
$images[$i]['img_desc'] = $row->description;
$images[$i]['img_file'] = $row->img_file;
$images[$i]['img_thumb'] = $row->thumb_file;
$images[$i]['img_small_pic'] = $row->small_pic;
$images[$i]['img_type'] = $row->filetype;
$images[$i]['row_color'] = $this->color;
$i++;
}
return $images;
}
</p>
<p> </p>
<? endif; ?>
<h1>Cache verwalten</h1>
<table cellpadding="0" cellspacing="1" id="setting_table">
<thead>
<tr>
<th class="headline_titel">Dateiname</th>
<th class="headline_datetime">Erstellung</th>
<th class="headline_edit">Edit</th>
</tr>
</thead>
<tbody>
<? foreach($files as $item) :
$color = cp_get_color($color);
?>
<tr bgcolor="<?php
echo $color;
?>
">
<td><?php
echo $item['name'];
?>
</td>
<td><?php
echo date('d.m.Y H:i:s', $item['date']);
?>
</td>
<? if($privileged['delete']) : ?>
<td><a id="delete_file" href="<?php
public function get_stages()
{
$this->db->order_by('name', 'asc');
$query = $this->db->get('page_stage');
$stages = array();
$i = 0;
foreach ($query->result() as $row) {
$stages[$i]['stageID'] = $row->stageID;
$stages[$i]['name'] = $row->name;
$stages[$i]['file'] = $row->file;
$stages[$i]['online'] = $row->online;
$stages[$i]['row_color'] = $this->color = cp_get_color($this->color);
$i++;
}
return $stages;
}
public function get_images($id)
{
$query = $this->db->get_where('einsatz_img', array('einsatzID' => $id));
$images = array();
$i = 0;
foreach ($query->result() as $row) {
$this->color = cp_get_color($this->color);
$images[$i]['imageID'] = $row->imgID;
$images[$i]['einsatzID'] = $row->einsatzID;
$images[$i]['img_desc'] = $row->description;
$images[$i]['img_file'] = $row->img_file;
$images[$i]['img_thumb'] = $row->thumb_file;
$images[$i]['img_type'] = $row->filetype;
$images[$i]['photographer'] = $row->photographer;
$images[$i]['row_color'] = $this->color;
$i++;
}
return $images;
}
