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