/**
* Starts the subscription
* Notice: Use this otherwise earlier saved stuff will be deleted when going back in the form
*
* @return inserted id on success
*/
function start($input)
{
if ($this->id == 0 or !empty($this->status[$this->get('status')]) and $this->status[$this->get('status')] == 'tilmeldt') {
$sql_type = "INSERT INTO ";
$sql_end = ", date_created = NOW(), session_id = '" . $this->session_id . "' ";
} else {
$sql_type = "UPDATE ";
$sql_end = " WHERE session_id = '" . $this->session_id . "'";
}
$sql = $sql_type . "kortkursus_tilmelding\n SET\n status_key = " . $this->getStatusKey('undervejs') . ",\n kortkursus_id = " . $input['kursus_id'] . ",\n antal_deltagere = " . $input['antal_deltagere'] . ",\n ip = '" . vih_get_ip_address() . "',\n date_updated = NOW()\n " . $sql_end;
$db = new DB_Sql();
$db->query($sql);
if ($this->id == 0) {
$this->id = $db->insertedId();
}
$this->load();
return $this->id;
}
function save($input)
{
$input = array_map('trim', $input);
$input = array_map('mysql_escape_string', $input);
if (!$this->validate($input)) {
return 0;
}
if ($this->id > 0) {
$sql_type = "UPDATE ";
$sql_end = " WHERE id = " . $this->id;
} else {
$sql_type = "INSERT INTO ";
$sql_end = ", date_created = NOW()";
}
$sql = $sql_type . " facilitet\r\n SET navn = '" . $input['navn'] . "',\r\n beskrivelse = '" . $input['beskrivelse'] . "',\r\n date_updated = NOW(),\r\n kategori_id = " . $input['kategori_id'] . ",\r\n title = '" . $input['title'] . "',\r\n description = '" . $input['description'] . "',\r\n keywords = '" . $input['keywords'] . "',\r\n published = '" . (int) $input['published'] . "',\r\n identifier = '" . $input['identifier'] . "'\r\n " . $sql_end;
$db = new DB_Sql();
$db->query($sql);
if ($this->id == 0) {
return $this->id = $db->insertedId();
}
return $this->id;
}
public function save($input)
{
if ($this->id > 0) {
$sql_type = "UPDATE ";
$sql_end = " WHERE id = " . $this->id;
} else {
$sql_type = "INSERT INTO ";
$sql_end = ", date_created = NOW()";
}
$sql = $sql_type . " langtkursus_fag SET\r\n date_updated = NOW(),\r\n navn = '" . mysql_escape_string($input['navn']) . "',\r\n title = '" . mysql_escape_string($input['title']) . "',\r\n keywords = '" . mysql_escape_string($input['keywords']) . "',\r\n fag_gruppe_id = '" . mysql_escape_string($input['faggruppe_id']) . "',\r\n description = '" . mysql_escape_string($input['description']) . "',\r\n beskrivelse = '" . mysql_escape_string($input['beskrivelse']) . "',\r\n kort_beskrivelse = '" . mysql_escape_string($input['kort_beskrivelse']) . "',\r\n udvidet_beskrivelse = '" . mysql_escape_string($input['udvidet_beskrivelse']) . "',\r\n identifier = '" . mysql_escape_string($input['identifier']) . "',\r\n published = '" . (int) $input['published'] . "'" . $sql_end;
$db = new DB_Sql();
$db->query($sql);
if ($this->id == 0) {
$this->id = $db->insertedId();
}
return $this->id;
}
public function save($var)
{
$f*g = array();
if (isset($var['f*g'])) {
$f*g = $var['f*g'];
unset($var['f*g']);
}
$var = array_map('trim', $var);
$var = array_map('mysql_escape_string', $var);
if (!$this->validate($var)) {
return false;
}
if ($this->id == 0) {
$sql_type = "INSERT INTO ";
$sql_end = ", date_created = NOW()";
} else {
$sql_type = "UPDATE ";
$sql_end = " WHERE id = " . $this->id;
}
$save = array('date_updated = NOW()');
foreach ($var as $key => $value) {
$save[] = $key . " = '" . $value . "'";
}
//belong_to = '".$var["belong_to"]."',
$sql = $sql_type . "langtkursus\r\n SET " . implode(',', $save) . $sql_end;
$db = new DB_Sql();
$db->query($sql);
if (empty($this->id)) {
$this->id = $db->insertedId();
}
$this->load();
return $this->id;
}
/**
*
* Der m� i denne funktion ikke bruges array_map() til at genneml�be
* v�rdierne, da den �del�gger arrayet til andet brug.
* Sune: Nu har jeg alligevel benyttet array_map, for jeg kan ikke se hvor man ikke kan det.
*/
function save($input)
{
settype($input['arbejdstelefon'], 'string');
settype($input['mobil'], 'string');
settype($input['adresse'], 'string');
settype($input['postnr'], 'string');
settype($input['postby'], 'string');
if (!$this->validate($input)) {
return 0;
}
$var = $input;
$navn = vih_split_name($var['navn']);
$var['fornavn'] = $navn['fornavn'];
$var['efternavn'] = $navn['efternavn'];
if ($this->id == 0) {
$sql_type = "INSERT INTO ";
$sql_end = ", date_created = NOW()";
} else {
$sql_type = "UPDATE ";
$sql_end = ", date_changed = NOW() WHERE id = " . $this->id;
}
$sql = $sql_type . "adresse SET\r\n fornavn = '" . $var['fornavn'] . "',\r\n efternavn = '" . $var['efternavn'] . "',\r\n adresse = '" . $var['adresse'] . "',\r\n postnr = '" . $var['postnr'] . "',\r\n postby = '" . $var['postby'] . "',\r\n email = '" . $var['email'] . "',\r\n arbejdstelefon = '" . $var['arbejdstelefon'] . "',\r\n telefon = '" . $var['telefonnummer'] . "',\r\n mobil = '" . $var['mobil'] . "'" . $sql_end;
$db = new DB_Sql();
$db->query($sql);
if ($this->id == 0) {
return $db->insertedId();
}
$this->load();
return $this->id;
}
function save($var)
{
$save = array('date_updated = NOW()');
foreach ($var as $key => $value) {
$save[] = $key . " = '" . $value . "'";
}
if ($this->id > 0) {
$sql_type = "UPDATE ";
$sql_end = " WHERE id = " . $this->id;
} else {
$sql_type = "INSERT INTO ";
$sql_end = ", date_created=NOW()";
}
$sql = $sql_type . "kortkursus SET " . implode(',', $save) . $sql_end;
$db = new DB_Sql();
$db->query($sql);
if ($this->id == 0) {
$this->id = $db->insertedId();
}
$this->load();
return $this->id;
}
/**
* Update the registration
*
* @return inserted id on success
*/
function save($var)
{
$var['navn'] = $var['kontaktnavn'];
if (!isset($var['afbestillingsforsikring'])) {
$var['afbestillingsforsikring'] = 0;
}
if (!isset($var['rabat'])) {
$var['rabat'] = 0;
}
if (!$this->validate($var)) {
return 0;
}
// Adresse gemmes
$adresse = new VIH_Model_Adresse((int) $this->get('adresse_id'));
$adresse_id = $adresse->save($var);
// her laves sql-typerne
if ($this->id > 0) {
$sql_type = "UPDATE ";
$sql_end = " WHERE id = " . $this->id;
} else {
throw new Exception('Der kan kun oprettes ordrer fra OnlineTilmelding');
}
$db = new DB_Sql();
$sql = $sql_type . "kortkursus_tilmelding\n SET\n date_updated = NOW(),\n adresse_id = " . $adresse_id . ",\n besked = '" . $var['besked'] . "',\n afbestillingsforsikring = '" . $var['afbestillingsforsikring'] . "',\n rabat = '" . $var['rabat'] . "'\n " . $sql_end;
$db->query($sql);
if ($this->id == 0) {
$this->id = $db->insertedId();
}
// ekstra oplysninger
if (!empty($var['hvilkettidligerekursus'])) {
$oplysning = new VIH_Model_KortKursus_Tilmelding_TilmeldingOplysning($this);
$oplysning->save('hvilkettidligerekursus', $var['hvilkettidligerekursus']);
}
$this->load();
return $this->id;
}
function save($var)
{
if (!isset($var['published'])) {
$var['published'] = 0;
}
$var = array_map('mysql_escape_string', $var);
if (!is_array($var)) {
return 0;
} elseif (!$this->validate()) {
return 0;
}
$db = new DB_Sql();
if ($this->id == 0) {
$sql_type = "INSERT INTO ";
$sql_end = ", date_created = NOW()";
} else {
$sql_type = "UPDATE ";
$sql_end = " WHERE id = " . $this->id;
}
$navn = vih_split_name($var['navn']);
$sql_items = "fornavn = '" . $navn['fornavn'] . "',";
$sql_items .= "efternavn = '" . $navn['efternavn'] . "',";
$sql_items .= "adresse = '" . $var['adresse'] . "',";
$sql_items .= "postnr = '" . $var['postnr'] . "',";
$sql_items .= "postby = '" . $var['postby'] . "',";
$sql_items .= "date_birthday = '" . $var['date_birthday'] . "',";
$sql_items .= "date_ansat = '" . $var['date_ansat'] . "',";
$sql_items .= "date_stoppet = '" . $var['date_stoppet'] . "',";
$sql_items .= "titel = '" . $var['titel'] . "',";
$sql_items .= "extra_info = '" . $var['extra_info'] . "',";
$sql_items .= "beskrivelse = '" . $var['beskrivelse'] . "',";
$sql_items .= "telefon = '" . $var['telefon'] . "',";
$sql_items .= "mobil = '" . $var['mobil'] . "',";
$sql_items .= "email = '" . $var['email'] . "',";
$sql_items .= "funktion_id = '" . $var['funktion_id'] . "',";
$sql_items .= "website = '" . $var['website'] . "',";
$sql_items .= "published = '" . (int) $var['published'] . "',";
$db->query($sql_type . " ansat SET " . $sql_items . " date_updated = NOW()" . $sql_end);
if ($this->id == 0) {
$this->id = $db->insertedId();
}
return $this->id;
}
/**
* Bruges til at opdatere ventelisteperson
*
* @return inserted id on success
*/
function save($var)
{
$var = array_map("mysql_escape_string", $var);
$var = array_map("strip_tags", $var);
$var = array_map("trim", $var);
if (!$this->validate($var)) {
return 0;
}
// Adresse gemmes
$adresse = new VIH_Model_Adresse((int) $this->get('adresse_id'));
if (!($adresse_id = $adresse->save($var))) {
return 0;
}
// her laves sql-typerne
if ($this->id > 0) {
$sql_type = "UPDATE ";
$sql_end = " WHERE id = " . $this->id;
} else {
$sql_type = "INSERT INTO ";
$sql_end = ', date_created = NOW(), belong_to = ' . $this->belong_to . ', belong_to_id = ' . $this->belong_to_id;
}
$sql = $sql_type . "venteliste SET\r\n date_updated = NOW(),\r\n adresse_id = " . $adresse_id . ",\r\n besked = '" . $var['besked'] . "',\r\n antal = " . $var['antal'] . "\r\n " . $sql_end;
$db = new DB_Sql();
$db->query($sql);
if ($this->id == 0) {
$this->id = $db->insertedId();
}
$this->load();
return $this->id;
}
/**
* @todo - denne metode b�r hedde save() fordi den ikke updater, men gemmer
*/
function update($input)
{
$db = new DB_Sql();
if (!is_array($input)) {
throw new Exception("Input skal være et array i FileHandler->updateInstance");
}
$input = array_map("mysql_escape_string", $input);
$input = array_map("strip_tags", $input);
$input = array_map("trim", $input);
$sql = array();
$sql[] = 'date_changed = NOW()';
if (isset($input['file_name'])) {
$sql[] = 'file_name = "' . $input['file_name'] . '"';
}
if (isset($input['server_file_name'])) {
$sql[] = 'server_file_name = "' . $input['server_file_name'] . '"';
}
if (isset($input['file_size'])) {
$sql[] = 'file_size = ' . (int) $input['file_size'];
}
if (isset($input['file_type_key'])) {
$mime_type = $this->_getMimeType($input['file_type_key'], 'key');
$sql[] = 'file_type_key = "' . $input['file_type_key'] . '"';
} elseif (isset($input['file_type'])) {
$mime_type = $this->_getMimeType($input['file_type'], 'mime_type');
$sql[] = 'file_type_key = "' . $mime_type['key'] . '"';
} elseif ($this->id == 0) {
throw new Exception('you need to provide a file type the first time you save an image');
exit;
}
$sql[] = 'accessibility_key = 3';
if ($this->id != 0) {
$db->query("UPDATE file_handler SET " . implode(', ', $sql) . " WHERE id = " . $this->id);
} else {
$sql[] = 'access_key = "' . $this->kernel->randomKey(50) . '"';
$sql[] = 'active = 1';
$db->query("INSERT INTO file_handler SET " . implode(', ', $sql) . ", date_created = NOW()");
$this->id = $db->insertedId();
}
return $this->id;
}
public function save($var)
{
$var = array_map('mysql_escape_string', $var);
$var = array_map('strip_tags', $var);
$var = array_map('trim', $var);
$var['cpr'] = str_replace('-', '', $var['cpr']);
if (!$this->validate($var)) {
return false;
}
if ($this->id > 0) {
$sql_type = "UPDATE ";
$sql_end = " WHERE id = " . $this->id;
} else {
$sql_type = "INSERT INTO ";
$sql_end = '';
}
// @todo hack because enevaerelse og sambo is only set when?
settype($var['indkvartering_key'], 'integer');
settype($var['sambo'], 'string');
$navn = vih_split_name($var['navn']);
$fornavn = $navn['fornavn'];
$efternavn = $navn['efternavn'];
$sql = $sql_type . TABLE_KORTKURSUS_TILMELDING_DELTAGER . "\r\n SET tilmelding_id = " . $this->tilmelding->getId() . ",\r\n fornavn = '" . $fornavn . "',\r\n efternavn = '" . $efternavn . "',\r\n cpr = '" . $var['cpr'] . "',\r\n indkvartering_key = '" . $var['indkvartering_key'] . "'" . $sql_end;
$db = new DB_Sql();
$db->query($sql);
if ($this->id == 0) {
$this->id = $db->insertedId();
}
$this->load();
// save information about the participant
// common information
$oplysning = new VIH_Model_KortKursus_Tilmelding_DeltagerOplysning($this);
$oplysning->save('sambo', $var['sambo']);
// klassen skal selv vide, hvilken type kursus og agere derefter
$kursustype = $this->tilmelding->getKursus()->get("gruppe_id");
switch ($kursustype) {
case '1':
// golf
$oplysning->save('handicap', (double) $var['handicap']);
$oplysning->save('klub', $var['klub']);
$oplysning->save('dgu', $var['dgu']);
break;
case '2':
// other
break;
case '3':
// bridge
$oplysning->save('niveau', $var['niveau']);
break;
case '4':
// golf og bridge
$oplysning->save('handicap', (double) $var['handicap']);
$oplysning->save('klub', $var['klub']);
$oplysning->save('dgu', $var['dgu']);
$oplysning->save('niveau', $var['niveau']);
break;
case 5:
// idrætscamp
$oplysning->save('speciale', $var['speciale']);
default:
break;
}
$this->load();
return $this->id;
}
function save($input)
{
array_map('trim', $input);
array_map('strip_tags', $input);
array_map('mysql_escape_string', $input);
settype($input['betaling_id'], 'integer');
$type = array_search($input['type'], $this->allowed_type);
if ($type === false) {
die('Ulovlig type i Historik->save');
}
$input['type'] = $type;
if (!$this->validate($input)) {
return 0;
}
$db = new DB_Sql();
if ($this->id == 0) {
$sql_type = "INSERT INTO historik ";
$sql_end = ", date_created = NOW()";
} else {
$sql_type = "UPDATE historik ";
$sql_end = " WHERE id = " . $this->id;
}
$db->query($sql_type . " SET\r\n date_updated = NOW(),\r\n type = " . $input['type'] . ",\r\n belong_to = " . $this->belong_to_key . ",\r\n belong_to_id = " . $this->belong_to_id . ",\r\n comment = '" . $input['comment'] . "',\r\n betaling_id = " . intval($input['betaling_id']) . " " . $sql_end);
if ($this->id == 0) {
$this->id = $db->insertedId();
}
$this->load();
return $this->id;
}
