function getList($type = '') { $value = array(); $i = 0; $db = new DB_Sql(); if ($type == 'all') { $db->query("SELECT *, DATE_FORMAT(date_created, '%d-%m-%Y %H:%i') AS date_dk FROM materialebestilling ORDER BY date_created"); } else { $db->query("SELECT *, DATE_FORMAT(date_created, '%d-%m-%Y %H:%i') AS date_dk FROM materialebestilling WHERE er_sendt = 0 ORDER BY date_created"); } while ($db->nextRecord()) { $value[$i]['id'] = $db->f('id'); $value[$i]['navn'] = $db->f('navn'); $value[$i]['adresse'] = $db->f('adresse'); $value[$i]['postnr'] = $db->f('postnr'); $value[$i]['postby'] = $db->f('postby'); $value[$i]['email'] = $db->f('email'); $value[$i]['telefon'] = $db->f('telefon'); $value[$i]['langekurser'] = $db->f('langekurser'); $value[$i]['kortekurser'] = $db->f('kortekurser'); $value[$i]['kursuscenter'] = $db->f('kursuscenter'); $value[$i]['efterskole'] = $db->f('efterskole'); $value[$i]['besked'] = $db->f('besked'); $value[$i]['date_dk'] = $db->f('date_dk'); $value[$i]['er_sendt'] = $db->f('er_sendt'); $i++; } return $value; }
function renderHtml() { $get = $this->query(); if (1 == 2 and !empty($get['date']['Y'])) { $date = $get['date']['Y'] . '-' . $get['date']['M'] . '-' . $get['date']['d']; } elseif (!empty($get['date'])) { $date = $get['date']; } else { $date = date('Y-m-d'); } $this->getForm()->setDefaults(array('date' => $date)); $db = new DB_Sql(); // Tr�kker alle ud p� den p�g�ldende holdliste $db->query("SELECT DISTINCT(tilmelding.id) AS id, x_fag.hold, x_fag.id AS hold_id\r\n FROM langtkursus_tilmelding tilmelding\r\n INNER JOIN langtkursus ON langtkursus.id = tilmelding.kursus_id\r\n INNER JOIN adresse ON tilmelding.adresse_id = adresse.id\r\n INNER JOIN langtkursus_tilmelding_x_fag x_fag ON tilmelding.id = x_fag.tilmelding_id\r\n INNER JOIN langtkursus_fag f*g ON x_fag.fag_id = f*g.id\r\n INNER JOIN langtkursus_fag_periode periode ON langtkursus.id = periode.langtkursus_id\r\n WHERE\r\n (\r\n (tilmelding.dato_start <= '{$date}' AND tilmelding.dato_slut >= '{$date}')\r\n OR (tilmelding.dato_slut = '0000-00-00' AND langtkursus.dato_start <= '{$date}' AND langtkursus.dato_slut >= '{$date}'))\r\n AND tilmelding.active = 1 AND x_fag.fag_id = " . $this->name() . " AND (periode.date_start <= '{$date}' AND periode.date_end >= '{$date}')\r\n AND (periode.date_start <= '{$date}' AND periode.date_end >= '{$date}' AND x_fag.periode_id = periode.id)\r\n ORDER BY x_fag.hold ASC, adresse.fornavn ASC"); $list = array(); while ($db->nextRecord()) { $list[$db->f('id')] = new VIH_Model_LangtKursus_Tilmelding($db->f('id')); $list[$db->f('id')]->value['hold'] = (int) $db->f('hold'); $list[$db->f('id')]->value['hold_id'] = (int) $db->f('hold_id'); } $f*g = new VIH_Model_Fag($this->name()); // skal hente holdnumrene for den p�g�ldende tilmelding $data = array('tilmeldinger' => $list); // $this->getForm()->toHTML() // echo $date; $this->document->setTitle($f*g->get('navn')); $tpl = $this->template->create('VIH/Intranet/view/holdlister/holdliste'); return '<p>' . count($list) . '</p>' . $date . $this->render($this, $data); }
public function getList($show = "open") { $sql_ekstra = ""; switch ($show) { case 'åbne': // fall through // fall through case 'open': $sql_ekstra = "published = 1 AND DATE_ADD(dato_start, INTERVAL 14 DAY) > NOW()"; break; case 'aktuelle': $sql_ekstra = "dato_slut > NOW()"; break; case 'intranet': $sql_ekstra = "dato_slut > DATE_SUB(NOW(), INTERVAL 400 DAY)"; break; case 'old': $sql_ekstra = "dato_slut > DATE_SUB(NOW(), INTERVAL 3650 DAY)"; break; default: $sql_ekstra = " 1 = 1"; break; } $db = new DB_Sql(); $db->query("SELECT id FROM langtkursus WHERE " . $sql_ekstra . " AND active = 1 ORDER BY dato_start ASC, dato_slut DESC, belong_to ASC, navn ASC"); $kurser = array(); while ($db->nextRecord()) { $kurser[] = new VIH_Model_LangtKursus($db->f('id')); } return $kurser; }
private function init() { $db = new DB_Sql(); $db->query("SELECT id FROM langtkursus_tilmelding WHERE session_id = '" . $this->session_id . "'"); if ($db->nextRecord()) { parent::__construct($db->f('id')); } }
public static function getList() { $db = new DB_Sql(); $db->query("SELECT id FROM langtkursus_fag_gruppe WHERE active = 1"); $grp = array(); while ($db->nextRecord()) { $grp[] = new VIH_Model_Fag_Gruppe($db->f('id')); } return $grp; }
protected function load() { $db = new DB_Sql(); $sql = "SELECT art, indhold FROM kortkursus_tilmelding_oplysninger\r\n WHERE tilmelding_id = '" . $this->tilmelding->get('id') . "'"; $db->query($sql); while ($db->nextRecord()) { $this->value[$db->f('art')] = $db->f('indhold'); } return true; }
public function get($art) { if (!empty($this->info[$art])) { return $this->info[$art]; } $art = trim(strip_tags(mysql_escape_string($art))); $sql = "SELECT art, indhold FROM kortkursus_deltager_oplysninger_ny\r\n WHERE deltager_id = '" . $this->deltager->get('id') . "'"; $db = new DB_Sql(); $db->query($sql); while ($db->nextRecord()) { $this->info[$db->f('art')] = $db->f('indhold'); } if (!empty($this->info[$art])) { return $this->info[$art]; } }
function _is_jubilar($auth) { $jubilar = false; $db = new DB_Sql(); $db->query("SELECT aargange FROM elevforeningen_jubilar ORDER BY id DESC"); if ($db->nextRecord()) { $jubilar_aargange = array_values(unserialize($db->f('aargange'))); } $contact = $auth->get(); $keywords = $auth->contact_client->getConnectedKeywords($contact['id']); $jubilar = false; if (is_array($keywords)) { foreach ($keywords as $key => $value) { if (in_array($value, $jubilar_aargange)) { $jubilar = true; } } } return $jubilar; }
function load() { $db = new DB_Sql(); $sql = "SELECT id, fornavn, efternavn, adresse, postnr, postby, arbejdstelefon, telefon, mobil, email FROM adresse WHERE id = " . $this->id . " LIMIT 1"; $db->query($sql); if (!$db->nextRecord()) { return 0; } $this->id = $db->f('id'); $this->value['id'] = $db->f('id'); $this->value['navn'] = trim($db->f('fornavn') . ' ' . $db->f('efternavn')); $this->value['fornavn'] = $db->f('fornavn'); $this->value['efternavn'] = $db->f('efternavn'); $this->value['adresse'] = $db->f('adresse'); $this->value['postnr'] = $db->f('postnr'); $this->value['postby'] = $db->f('postby'); $this->value['arbejdstelefon'] = $db->f('arbejdstelefon'); $this->value['telefon'] = $db->f('telefon'); $this->value['mobil'] = $db->f('mobil'); $this->value['email'] = $db->f('email'); return 1; }
/** * Statistics * * @todo Optimize */ function statistik($filter = '') { // count number of spots on each course $countPladser = 0; $countOptagne = 0; $db1 = new DB_Sql(); $sql = "SELECT id, pladser FROM kortkursus\r\n WHERE published=1\r\n AND tilmeldingsmulighed = 'Ja'\r\n AND DATE_FORMAT(dato_start, '%Y') >= 2005"; if (!empty($filter)) { $sql .= "\tAND gruppe_id = " . (int) $filter; } $sql .= " ORDER BY dato_start ASC"; $db1->query($sql); while ($db1->nextRecord()) { $countPladser += $db1->f('pladser'); $kursus = new VIH_Model_KortKursus($db1->f('id')); $countOptagne += $kursus->getOptagnePladser(); } if ($countPladser == 0) { $countPladser = 1; } $percent = round($countOptagne / $countPladser * 100, 0); return array('pladser' => $countPladser, 'percent' => $percent, 'optagne' => $countOptagne); }
function rateDifference() { $db = new DB_Sql(); $rate_samlet = $this->get("pris_tilmeldingsgebyr"); $db->query("SELECT beloeb FROM langtkursus_tilmelding_rate WHERE langtkursus_tilmelding_id = " . $this->id); while ($db->nextRecord()) { $rate_samlet += $db->f("beloeb"); } return $rate_samlet - $this->get("pris_total"); }
/** * Cleans up old subscriptions * * NOTICE: Use cancel() and not delete() * * @return 1 on success */ function cleanUp() { $db = new DB_Sql(); $db->query("SELECT id, DATE_ADD(date_updated, INTERVAL 1 HOUR) AS date_created FROM kortkursus_tilmelding\n WHERE DATE_ADD(date_updated, INTERVAL 1 HOUR) < NOW()\n AND (status_key = '" . $this->getStatusKey('undervejs') . "' OR status_key = '" . $this->getStatusKey('ikke tilmeldt') . "') AND active = 1"); while ($db->nextRecord()) { $tilmelding = new VIH_Model_KortKursus_Tilmelding($db->f('id')); $tilmelding->setStatus('annulleret'); } return true; }
function getForfaldenDato($key = '', $sprog = '') { if (!in_array($key, array('depositum', ''))) { throw new Exception("Tilmelding->getForfaldenDato"); } if (!empty($sprog)) { $sprog = '_' . $sprog; } $db = new DB_Sql(); switch ($key) { case 'depositum': $db->query("SELECT\n date_add(date_created, interval 10 day) AS dato_forfalden,\n DATE_FORMAT(date_add(date_created, interval 10 day), '%d-%m-%Y') AS forfald_dk\n FROM kortkursus_tilmelding\n WHERE id=" . $this->get('id')); break; default: $db->query("SELECT date_sub(dato_start, interval 42 day) AS dato_forfalden,\n DATE_FORMAT(date_sub(dato_start, interval 42 day), '%d-%m-%Y') AS forfald_dk\n FROM kortkursus\n WHERE id=" . $this->kursus->get('id')); break; } if (!$db->nextRecord()) { return 0; } return $db->f('forfald' . $sprog); }
function findType($type) { $type_key = array_search($type, $this->allowed_type); if ($type_key === false) { throw new Exception('Ulovlig type i Historik->findType'); } $db = new DB_Sql(); $db->query("SELECT id FROM historik WHERE type = " . $type_key . " AND belong_to = " . $this->belong_to_key . " AND belong_to_id = " . $this->belong_to_id . " AND active = 1"); if ($db->nextRecord()) { return $db->f('id'); } else { return 0; } }
public function getKurser() { $db = new DB_Sql(); $db->query("SELECT * FROM langtkursus_x_fag INNER JOIN langtkursus ON langtkursus_x_fag.langtkursus_id = langtkursus.id WHERE fag_id = " . $this->id . ' AND dato_start > NOW() AND langtkursus.active = 1 AND langtkursus.published = 1 GROUP BY langtkursus_id ORDER BY dato_start'); $kurser = array(); while ($db->nextRecord()) { $kurser[] = new VIH_Model_LangtKursus($db->f('langtkursus_id')); } return $kurser; }
function loadInstance($type, $param = array()) { if ($this->id == 0) { return 0; } $type_prop = $this->getInstanceType($type); if ($type_prop === false) { return 0; throw new Exception("Ugyldig type i FileHandler->loadInstance"); } $db = new DB_Sql(); $db->query("SELECT * FROM file_handler_instance WHERE active = 1 AND file_handler_id = " . $this->id . " AND type_key = " . $type_prop['type_key']); if (!$db->nextRecord()) { $id = $this->createInstance($type, $param); $db->query("SELECT * FROM file_handler_instance WHERE active = 1 AND id = " . $id); if (!$db->nextRecord()) { return 0; //throw new Exception("Kunne ikke hente instance i FileHandler->loadInstance"); } } $this->value['instance_id'] = $db->f('id'); $this->value['date_created'] = $db->f('date_created'); $this->value['date_updated'] = $db->f('date_changed'); $this->value['server_file_name'] = $db->f('server_file_name'); $this->value['file_size'] = $db->f('file_size'); $this->value['type'] = $type; $this->value['file_path'] = PATH_UPLOAD_INSTANCE . $db->f('server_file_name'); $this->value['file_path'] = $this->instance_path . $db->f('server_file_name'); if (!file_exists($this->get('file_path'))) { return; } $this->value['last_modified'] = filemtime($this->get('file_path')); $this->value['file_uri'] = FILE_VIEWER . '?/' . $this->kernel->intranet->get('public_key') . '/' . $this->get('access_key') . '/' . $this->get('type') . '/' . urlencode($this->get('file_name')); return true; }
function getIndkvartering() { $out = array('price' => 0, 'text' => 'Ingen valgt'); if ($this->get('indkvartering_key') == 0) { return $out; } $db = new DB_Sql(); $gateway = new VIH_Model_KortKursus_Indkvartering($this->tilmelding->kursus); $db->query('SELECT id, price FROM kortkursus_x_indkvartering WHERE kursus_id = ' . $this->tilmelding->kursus->getId() . ' AND indkvartering_key = ' . $this->get('indkvartering_key')); while ($db->nextRecord()) { $out['price'] = $db->f('price'); $out['text'] = $gateway->getType($this->get('indkvartering_key')); } return $out; }
public function getPictures() { $db = new DB_Sql(); $db->query("SELECT * FROM langtkursus_x_file WHERE langtkursus_id = " . $this->id); $id = array(); while ($db->nextRecord()) { $id[]['file_id'] = $db->f('file_id'); } return $id; }
/** * Giver list over personer p� ventelisten * * @return array med ventelistepersoner */ function getList() { $sql = "SELECT *, DATE_FORMAT(date_created, '%d-%m-%Y') AS date_created_dk FROM venteliste\r\n WHERE belong_to = " . $this->belong_to . " AND belong_to_id = " . $this->belong_to_id . " AND active = 1\r\n ORDER BY date_created"; $db = new DB_Sql(); $db->query($sql); $venteliste = array(); $i = 0; $nummer = 1; while ($db->nextRecord()) { $venteliste[$i]['id'] = $db->f("id"); $venteliste[$i]['nummer'] = $nummer; $venteliste[$i]['antal'] = $db->f("antal"); $venteliste[$i]['kursus_id'] = $db->f('belong_to_id'); $venteliste[$i]['date_created_dk'] = $db->f('date_created_dk'); $venteliste[$i]['besked'] = $db->f('besked'); $nummer++; $adresse = new VIH_Model_Adresse($db->f('adresse_id')); $venteliste[$i]['adresse_id'] = $adresse->get('id'); $venteliste[$i]['navn'] = $adresse->get('navn'); $venteliste[$i]['adresse'] = $adresse->get('adresse'); $venteliste[$i]['postnr'] = $adresse->get('postnr'); $venteliste[$i]['postby'] = $adresse->get('postby'); $venteliste[$i]['telefon'] = $adresse->get('telefon'); $venteliste[$i]['arbejdstelefon'] = $adresse->get('arbejdstelefon'); $venteliste[$i]['mobil'] = $adresse->get('mobil'); $venteliste[$i]['email'] = $adresse->get('email'); $i++; } return $venteliste; }
function getList($type = 'published') { $db = new DB_Sql(); $sql = "SELECT id FROM facilitet WHERE active = 1"; if ($type == 'published') { $sql .= " AND published = 1"; } elseif ($type == 'højskole') { $sql .= " AND kategori_id > 0 AND kategori_id < 4 AND published = 1"; } $sql .= " ORDER BY kategori_id, navn"; $db->query($sql); $list = array(); while ($db->nextRecord()) { $list[] = new VIH_Model_Facilitet($db->f('id')); } return $list; }
function getFag() { $db = new DB_Sql(); $db->query("SELECT * FROM ansat_x_fag INNER JOIN langtkursus_fag f*g ON ansat_x_fag.fag_id = f*g.id WHERE ansat_id = " . $this->id . " AND f*g.active = 1 AND f*g.published = 1"); $f*g = array(); while ($db->nextRecord()) { $f*g[] = new VIH_Model_Fag($db->f('fag_id')); } return $f*g; }