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);
}
function renderHtml()
{
$langtkursus = new VIH_Model_LangtKursus($this->context->name());
$f*g = VIH_Model_Fag::getList();
$selected = $langtkursus->getFag($this->pdo, 'all');
$data = array('f*g' => $f*g, 'selected' => $selected, 'periods' => VIH_Model_LangtKursus_Periode::getFromKursusId($this->pdo, $this->context->name()));
$tpl = $this->template->create('VIH/Intranet/view/langekurser/f*g');
return $this->render($this, $data);
}
function postForm()
{
if ($this->getForm()->validate()) {
$f*g = new VIH_Model_Fag($this->context->name());
$input = $this->body();
$input['navn'] = vih_handle_microsoft($input['navn']);
$input['beskrivelse'] = vih_handle_microsoft($input['beskrivelse']);
$input['kort_beskrivelse'] = vih_handle_microsoft($input['kort_beskrivelse']);
$input['udvidet_beskrivelse'] = vih_handle_microsoft($input['udvidet_beskrivelse']);
if (!isset($input['published'])) {
$input['published'] = 0;
}
if ($id = $f*g->save($input)) {
if ($this->body('underviser')) {
$f*g->addUnderviser($this->body('underviser'));
}
return new k_SeeOther($this->url('../'));
}
}
return $this->render();
}
function renderPdf()
{
$f*g = new VIH_Model_Fag($this->name());
// beskrivelsen skal deles op og regnes ud, hvor meget, der kan v�re p� hver side.
// det der ikke kan v�re p� midtersiderne skal v�re p� bagsiden.
$pdf = new VIH_PdfBrochure();
$pdf->SetTitle($f*g->get('navn'));
$pdf->SetSubject('Fagbeskrivelse: ' . $f*g->get('navn'));
$pdf->SetAuthor('Lars Olesen, Vejle Idrætshøjskole');
$pdf->SetCreator('Lars Olesen, Vejle Idrætshøjskole');
$pdf->SetDisplayMode('fullpage', 'two');
$pdf->SetKeywords('keyword');
$pdf->VIHContent($f*g->get('beskrivelse'));
$pdf->Output();
}
function renderHtmlEdit()
{
$f*g = VIH_Model_Fag::getList();
$birthday = explode('-', $this->ansat->get('date_birthday'));
$birthday['M'] = $birthday[1];
$birthday['Y'] = $birthday[0];
$birthday['d'] = $birthday[2];
$date_ansat = explode('-', $this->ansat->get('date_ansat'));
$date_ansat['M'] = $date_ansat[1];
$date_ansat['Y'] = $date_ansat[0];
$date_ansat['d'] = $date_ansat[2];
$this->context->getForm()->setDefaults(array('navn' => $this->ansat->get('navn'), 'funktion_id' => $this->ansat->get('funktion_id'), 'adresse' => $this->ansat->get('adresse'), 'postnr' => $this->ansat->get('postnr'), 'postby' => $this->ansat->get('postby'), 'date_birthday' => $birthday, 'date_ansat' => $date_ansat, 'beskrivelse' => $this->ansat->get('beskrivelse'), 'titel' => $this->ansat->get('titel'), 'extra_info' => $this->ansat->get('extra_info'), 'email' => $this->ansat->get('email'), 'telefon' => $this->ansat->get('telefon'), 'mobil' => $this->ansat->get('mobil'), 'website' => $this->ansat->get('website'), 'published' => $this->ansat->get('published')));
if ($this->ansat->get('date_stoppet') == '0000-00-00') {
$this->context->getForm()->setDefaults(array('date_stoppet' => ''));
} else {
$this->context->getForm()->setDefaults(array('date_stoppet' => $this->ansat->get('date_stoppet')));
}
$this->document->setTitle('Rediger underviser');
return $this->getForm()->toHTML();
}
function getSubjectsTable()
{
$test = '';
$i = 0;
$subjects = VIH_Model_Fag::getPublishedWithDescription();
$periods = Doctrine::getTable('VIH_Model_Course_Period')->findByCourseId($this->name());
// columns for the table
$col[] = '';
foreach ($periods as $p) {
$col[] = $p->getName();
}
// subject rows for the table
$row = array();
foreach ($subjects as $subject) {
if (!$subject->get('published')) {
continue;
}
if ($subject->get('faggruppe') != $test) {
++$i;
$row[$i]['faggruppe'] = $subject->get('faggruppe');
$test = $subject->get('faggruppe');
}
$row[$i]['f*g'][$subject->getId()] = $subject;
}
// build table
$attr = array('class' => 'skema');
$table = new HTML_Table($attr);
$table->addRow($col, null, 'th');
foreach ($row as $r) {
$table->addRow(array($r['faggruppe']), null, 'th');
foreach ($r['f*g'] as $f*g) {
$data = array();
$data[] = '<a href="' . $this->url('/f*g/' . $f*g->get('identifier')) . '">' . $f*g->get('navn') . '</a>';
foreach ($periods as $p) {
if ($this->isSubjectAvailable($p, $f*g)) {
$data[] = '•';
} else {
$data[] = '';
}
}
$table->addRow($data);
}
}
return $table->toHtml();
}
function renderHtml()
{
$f*g = new VIH_Model_Fag($this->name());
$undervisere = $f*g->getUndervisere();
$title = $f*g->get('title');
if (empty($title)) {
$title = $f*g->get('navn');
}
$meta['description'] = $f*g->get('description');
$meta['keywords'] = $f*g->get('keywords');
$this->document->setTitle($title);
$this->document->meta = $meta;
$this->document->theme = $f*g->get('identifier');
if ($this->query('show') == 'udvidet') {
$this->document->body_class = 'widepicture';
$this->document->sidepicture = $this->getPictureHTML($f*g->get('identifier'));
} else {
$this->document->body_class = 'sidepicture';
$this->document->widepicture = $this->getWidePictureHTML($f*g->get('identifier'));
}
$data = array('content' => '
<div class="fit"><h1>' . $f*g->get('navn') . '</h1>
' . autoop($f*g->get('beskrivelse')) . '
' . $this->getUdvidetBeskrivelse($f*g) . '</div>', 'content_sub' => $this->getVideo() . '
<h2>Spørgsmål?</h2>
' . $this->getUndervisereHTML($f*g->getUndervisere()) . $this->getSubContent($f*g->get('identifier')));
$tpl = $this->template->create('sidebar-wrapper');
return $tpl->render($this, $data);
}
