/**
* /
* @param Record $record [description]
* @return [type] [description]
*/
public function update(Record $record)
{
$id = $record->get('id');
$record->remove('id');
$language = $record->get('language');
$record->remove('language');
$sql = "UPDATE collections SET parent_id=:parent_id, modified=NOW() WHERE id=:id";
$result = $this->db->run($sql, array('id' => $id, 'parent_id' => $record->get('parent_id')));
$record->remove('parent_id');
$record->remove('type_id');
$values = $record->getUpdateValueString();
$sql = "UPDATE translations SET {$values}\n WHERE item_id=:id \n AND language=:language\n AND item_name=:item_name";
$record->set('language', $language);
$record->set('item_name', 'collection');
$record->set('id', $id);
$result = $this->db->run($sql, $record->toArray());
return $result;
}
/**
* /
* @param Record $record [description]
* @return [type] [description]
*/
public function update(Record $record)
{
$id = $record->get('id');
$record->remove('id');
$language = $record->get('language');
$record->remove('language');
$sql = "UPDATE resources SET modified=NOW() WHERE id=:id";
$result = $this->db->run($sql, array('id' => $id));
$record->remove('type_id');
$record->remove('url');
$record->remove('filepath');
$record->remove('filename');
$record->remove('extension');
$record->remove('embed');
$record->remove('mimetype');
$values = $record->getUpdateValueString();
$sql = "UPDATE translations \n SET {$values} \n WHERE item_id=:id \n AND language=:language\n AND item_name=:item_name";
$record->set('language', $language);
$record->set('item_name', 'term');
$record->set('id', $id);
$result = $this->db->run($sql, $record->toArray());
return $result;
}
/**
* /
* @param Record $record [description]
* @return [type] [description]
*/
public function update(Record $record)
{
$sql = "UPDATE types SET name=:name, item_name=:item_name WHERE id=:id";
$result = $this->db->run($sql, array('item_name' => $record->get('item_name'), 'name' => $record->get('name'), 'id' => $record->get('id')));
$record->remove('name');
$sql = "UPDATE translations SET user_id=:user_id, language=:language, slug=:slug, title=:title\n WHERE item_id=:id AND item_name=:item_name";
$result = $this->db->run($sql, $record->toArray());
return $result;
}
/**
* /
* @param Record $record [description]
* @return [type] [description]
*/
public function update(Record $record)
{
$id = $record->get('id');
$record->remove('id');
$values = $record->getUpdateValueString();
$sql = "UPDATE users \n SET {$values}, modified=NOW() WHERE id=:id";
$record->set('id', $id);
$result = $this->db->run($sql, $record->toArray());
return $result;
}
/**
* /
* @return [type] [description]
*/
public function handlePostRequest()
{
// try to get $_POST
$body = $this->app->request->post();
// if $_POST is empty, try to get json request body instead
if (empty($body)) {
$json = $app->request->getBody();
$body = json_decode($json, true);
}
$record = new Record($body);
if (!$record->has('nonce') || !$this->app->nonce->verify($record->get('nonce'))) {
$this->errorForbidden();
}
$record->remove('nonce');
return $record;
}
