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