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