private function submitFirst($params){
if(isset($params['id']) && !empty($params['id'])){
$query = sprintf("UPDATE `accomodations` SET
`name`='%s', `add`='%s', `accomodation_type_id`='%s',
`type_id`='%s', `type_desc`='%s',
`desc`='%s', `conditions`='%s',
`web_desc`='%s', `web_keywords`='%s',
`map`='%s', `code`='%s', `cat`='%s'
WHERE `id`='%s'",
mysql_real_escape_string($params['name']),
mysql_real_escape_string($params['add']),
mysql_real_escape_string($params['accomodation_type']),
mysql_real_escape_string($params['type']),
mysql_real_escape_string($params['type_desc']),
mysql_real_escape_string($params['desc']),
mysql_real_escape_string($params['conditions']),
mysql_real_escape_string($params['web_desc']),
mysql_real_escape_string($params['web_keywords']),
mysql_real_escape_string($params['map']),
mysql_real_escape_string($params['code']),
mysql_real_escape_string($params['cat']),
mysql_real_escape_string($params['id'])
);
mysql_query($query);
$newId = $params['id'];
//Set link name
$linkName = parent::getLinkName(array('name' => $params['name'], 'id' => $newId), 'accomodations');
$queryLink = sprintf("UPDATE `accomodations` SET `link_name`='%s' WHERE `id`='%s'",
mysql_real_escape_string($linkName),
mysql_real_escape_string($newId)
);
parent::run($queryLink);
}else{
$query = sprintf("INSERT INTO `accomodations` SET
`name`='%s', `add`='%s', `accomodation_type_id`='%s',
`type_id`='%s', `type_desc`='%s',
`desc`='%s', `conditions`='%s',
`web_desc`='%s', `web_keywords`='%s',
`map`='%s', `code`='%s', `cat`='%s'",
mysql_real_escape_string($params['name']),
mysql_real_escape_string($params['add']),
mysql_real_escape_string($params['accomodation_type']),
mysql_real_escape_string($params['type']),
mysql_real_escape_string($params['type_desc']),
mysql_real_escape_string($params['desc']),
mysql_real_escape_string($params['conditions']),
mysql_real_escape_string($params['web_desc']),
mysql_real_escape_string($params['web_keywords']),
mysql_real_escape_string($params['map']),
mysql_real_escape_string($params['code']),
mysql_real_escape_string($params['cat'])
);
$newId = parent::insert($query);
//Set link name
$linkName = parent::getLinkName(array('name' => $params['name'], 'id' => $newId), 'accomodations');
$queryLink = sprintf("UPDATE `accomodations` SET `link_name`='%s' WHERE `id`='%s'",
mysql_real_escape_string($linkName),
mysql_real_escape_string($newId)
);
parent::run($queryLink);
}
return $newId;
}
private function submitFirst($params){
if(isset($params['id']) && !empty($params['id'])){
$query = sprintf("UPDATE `accomodation_types` SET
`name`='%s', `destination_id`='%s',
`desc`='%s', `desc_bottom`='%s', `gen_desc`='%s', `conditions`='%s',
`web_desc`='%s', `web_keywords`='%s',
`start`='%s', `from`='%s', `accomodation`='%s'
WHERE `id`='%s'",
mysql_real_escape_string($params['name']),
mysql_real_escape_string($params['destination']),
mysql_real_escape_string($params['desc']),
mysql_real_escape_string($params['desc_bottom']),
mysql_real_escape_string($params['gen_desc']),
mysql_real_escape_string($params['conditions']),
mysql_real_escape_string($params['web_desc']),
mysql_real_escape_string($params['web_keywords']),
mysql_real_escape_string($params['start']),
mysql_real_escape_string($params['from']),
mysql_real_escape_string($params['accomodation']),
mysql_real_escape_string($params['id'])
);
mysql_query($query);
//Update image if added
if(isset($params['image']) && $params['image']['error'] == 0){
$query_img = sprintf("UPDATE `accomodation_types` SET `image`='%s' WHERE `id`='%s'",
mysql_real_escape_string($params['image']['name']),
mysql_real_escape_string($params['id'])
);
mysql_query($query_img);
}
//Update pdf if added
if(isset($params['pdf']) && $params['pdf']['error'] == 0){
$query_img = sprintf("UPDATE `accomodation_types` SET `pdf`='%s' WHERE `id`='%s'",
mysql_real_escape_string($params['pdf']['name']),
mysql_real_escape_string($params['id'])
);
mysql_query($query_img);
}
$newId = $params['id'];
//Insert into
if(isset($params['transport']) && !empty($params['transport'])){
//Remove those that are canceled
$tmp_t = "";
$c = 0;
foreach($params['transport'] as $value) $tmp_t.= $value . (++$c<count($params['transport'])?",":"");
$query_t = sprintf("DELETE FROM `accomodation_type_transport` WHERE
`accomodation_type_id`='%s' AND
`transport_id` NOT IN ('%s')",
mysql_real_escape_string($newId),
mysql_real_escape_string($tmp_t)
);
mysql_query($query_t);
//Add new
foreach($params['transport'] as $value){
$query_t = sprintf("INSERT INTO `accomodation_type_transport` SET
`accomodation_type_id`='%s',
`transport_id`='%s'",
mysql_real_escape_string($newId),
mysql_real_escape_string($value)
);
mysql_query($query_t);
}
}
//Set link name
$linkName = parent::getLinkName(array('name' => $params['name'], 'id' => $newId), 'accomodation_types');
$queryLink = sprintf("UPDATE `accomodation_types` SET `link_name`='%s' WHERE `id`='%s'",
mysql_real_escape_string($linkName),
mysql_real_escape_string($newId)
);
parent::run($queryLink);
}else{
$position = 1;
$query_position = sprintf("SELECT `position` FROM `accomodation_types` ORDER BY `position` DESC LIMIT 0, 1");
$res_position = mysql_query($query_position);
if(mysql_num_rows($res_position) > 0){
$row_position = mysql_fetch_assoc($res_position);
$position = $row_position['position'] + 1;
}
$position_left = 1;
$query_position_left = sprintf("SELECT `position_left` FROM `accomodation_types` ORDER BY `position_left` DESC LIMIT 0, 1");
$res_position_left = mysql_query($query_position_left);
if(mysql_num_rows($res_position_left) > 0){
$row_position_left = mysql_fetch_assoc($res_position_left);
$position_left = $row_position_left['position_left'] + 1;
}
$query = sprintf("INSERT INTO `accomodation_types` SET
`name`='%s', `destination_id`='%s',
`desc`='%s', `desc_bottom`='%s',
`gen_desc`='%s', `start`='%s', `from`='%s',
`conditions`='%s',
`web_desc`='%s', `web_keywords`='%s', `image`='%s',
`pdf`='%s', `position`='%s',
`position_left`='%s', `accomodation`='%s'",
mysql_real_escape_string($params['name']),
mysql_real_escape_string($params['destination']),
mysql_real_escape_string($params['desc']),
mysql_real_escape_string($params['desc_bottom']),
mysql_real_escape_string($params['gen_desc']),
mysql_real_escape_string($params['start']),
mysql_real_escape_string($params['from']),
mysql_real_escape_string($params['conditions']),
mysql_real_escape_string($params['web_desc']),
mysql_real_escape_string($params['web_keywords']),
mysql_real_escape_string(isset($params['image']['name'])?$params['image']['name']:''),
mysql_real_escape_string(isset($params['pdf']['name'])?$params['pdf']['name']:''),
mysql_real_escape_string($position),
mysql_real_escape_string($position_left),
mysql_real_escape_string($params['accomodation'])
);
$newId = parent::insert($query);
//Insert into
if(isset($params['transport']) && !empty($params['transport']))
foreach($params['transport'] as $key => $value){
$query_t = sprintf("INSERT INTO `accomodation_type_transport` SET
`accomodation_type_id`='%s',
`transport_id`='%s'",
mysql_real_escape_string($newId),
mysql_real_escape_string($value)
);
mysql_query($query_t);
}
//Set link name
$linkName = parent::getLinkName(array('name' => $params['name'], 'id' => $newId), 'accomodation_types');
$queryLink = sprintf("UPDATE `accomodation_types` SET `link_name`='%s' WHERE `id`='%s'",
mysql_real_escape_string($linkName),
mysql_real_escape_string($newId)
);
parent::run($queryLink);
}
return $newId;
}
