public function delete($params){
		
		$query = sprintf("DELETE FROM `online_booking` WHERE `id`='%s'",
						mysql_real_escape_string($params['id'])
						);
		return parent::run($query);
	}
Example #2
0
 public function __construct()
 {
     if (file_exists(dirname(__FILE__) . '/config.ini')) {
         $this->config = parse_ini_file(dirname(__FILE__) . '/config.ini', TRUE);
     }
     $component = new Model('zip', dirname(__FILE__), $this);
     $this->_component = $component;
     $component->run();
 }
Example #3
0
 public function __construct()
 {
     // erzeugt das Model Objekt, welches einiges erleichtern soll
     $component = new Model('course', dirname(__FILE__), $this);
     $this->_component = $component;
     // startet nun unsere Komponente, dabei kommt die Zuordnung von Aufruf und Funktion
     // aus der Commands.json
     $component->run();
 }
	public function submit($params){
		
		$query = sprintf("INSERT INTO `online_booking` SET `date_from`='%s', `date_to`='%s',
														   `destination`='%s', `accomodation`='%s',
														   `transport`='%s', `payment_method`='%s',
														   `address`='%s', `city`='%s',
														   `telephone`='%s', `email`='%s',
														   `reason`='%s'",
							mysql_real_escape_string($params['date_from']),
							mysql_real_escape_string($params['date_to']),
							mysql_real_escape_string($params['destination']),
							mysql_real_escape_string($params['accomodation']),
							mysql_real_escape_string($params['transport']),
							mysql_real_escape_string($params['payment_method']),
							mysql_real_escape_string($params['address']),
							mysql_real_escape_string($params['city']),
							mysql_real_escape_string($params['telephone']),
							mysql_real_escape_string($params['email']),
							mysql_real_escape_string($params['reason'])
						);
		$id = parent::insert($query);
		
		if(isset($params['parent']['name']) && !empty($params['parent']['name']))
			foreach($params['parent']['name'] as $key => $val){
				//Add parents and date of birth
				$query_parents = sprintf("INSERT INTO `online_booking_passangers` SET `online_booking_id`='%s',
																				      `passanger`='%s',
																				      `birth_date`='%s',
																				      `type`='%s'",
										mysql_real_escape_string($id),
										mysql_real_escape_string($val),
										mysql_real_escape_string($params['parent']['birth_date'][$key]),
										mysql_real_escape_string('Putnik')
										);
				parent::run($query_parents);
			}

			
		if(isset($params['child']['name']) && !empty($params['child']['name']))
			foreach($params['child']['name'] as $key => $val){
				//Add child and date of birth
				$query_child = sprintf("INSERT INTO `online_booking_passangers` SET `online_booking_id`='%s',
																				      `passanger`='%s',
																				      `birth_date`='%s',
																				      `type`='%s'",
										mysql_real_escape_string($id),
										mysql_real_escape_string($val),
										mysql_real_escape_string($params['child']['birth_date'][$key]),
										mysql_real_escape_string('Dete')
										);
				parent::run($query_child);
			}
			
		return true;
		
	}
Example #5
0
	public function setVisible($params){
 		
 		$query = sprintf("SELECT * FROM `accomodation_types` WHERE `id`='%s'",
 						mysql_real_escape_string($params['id'])
 						);
 		$row = parent::queryOne($query);
 		
 		//Change visible status
 		$query = sprintf("UPDATE `accomodation_types` SET `visible`='%s' WHERE `id`='%s'",
 						mysql_real_escape_string(1 - $row['visible']),
 						mysql_real_escape_string($params['id'])
 						);
 		parent::run($query);
 		return true;
 	}
Example #6
0
 public function __construct()
 {
     $component = new Model('', dirname(__FILE__), $this);
     $this->_component = $component;
     $component->run();
 }
Example #7
0
	public function deleteService($params){
		
		$query = sprintf("DELETE FROM `accomodation_services` WHERE `id`='%s'",
						mysql_real_escape_string($params['service_id'])
						);
		return parent::run($query);
	}