/**
* /
* @param Record $record [description]
* @return [type] [description]
*/
public function update(Record $record)
{
$values = $record->getUpdateValueString();
$sql = "UPDATE areas SET {$values} WHERE id=:id";
$result = $this->db->run($sql, $record->toArray());
return $result;
}
/**
* /
* @param Record $record [description]
* @return [type] [description]
*/
public function insert(Record $record)
{
$sql = "INSERT INTO log (user_id, group_name, group_id, action, item_name, item_id, nonce, created)\n VALUES (:user_id, :group_name, :group_id, :action, :item_name, :item_id, :nonce, NOW())";
$values = $record->toArray();
$result = $this->db->run($sql, $values);
return $result;
}
/**
* /
* @param Record $record [description]
* @return [type] [description]
*/
public function update(Record $record)
{
$id = $record->get('id');
if (!$id) {
throw new \Exception("Id must be set", 1);
}
$values = $record->getUpdateValueString();
$sql = "UPDATE blocks SET {$values} WHERE 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 terms SET parent_id=:parent_id WHERE id=:id";
$result = $this->db->run($sql, array('id' => $id, 'parent_id' => $record->get('parent_id')));
$record->remove('type_id');
$record->remove('parent_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', 'term');
$record->set('id', $id);
$result = $this->db->run($sql, $record->toArray());
return $result;
}
/**
* /
* @param Record $record [description]
* @return [type] [description]
*/
public function insert(Record $record)
{
$sql = "INSERT INTO invoices (project_id, hours, rate, total, activity, created) \n VALUES (:project_id, :totalhours, :rate, :total, 1, NOW())";
$result = $this->db->run($sql, $record->toArray());
return $result;
}
/**
* /
* @param Record $record [description]
* @return [type] [description]
*/
public function update(Record $record)
{
$sql = "UPDATE roles SET name=:name, activity=:activity \n WHERE 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 insert(Record $record)
{
$sql = "INSERT INTO tickets (dev_id, user_id, hash, priority, description, activity, created, modified) \n VALUES (:dev_id, :user_id, UUID(), :priority, :description, :activity, NOW(), NOW())";
$result = $this->db->run($sql, $record->toArray());
return $result;
}
/**
* /
* @param Record $record [description]
* @return [type] [description]
*/
public function update(Record $record)
{
$sql = "UPDATE projects SET title=:title, description=:description, activity=:activity";
$result = $this->db->run($sql, $record->toArray());
return $result;
}
/**
* /
* @param Record $record [description]
* @return [type] [description]
*/
public function update(Record $record)
{
$sql = "UPDATE config SET activity=:activity, value=:value, modified=NOW() \n WHERE key=:key";
$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;
}
/**
* /
* @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)
{
$id = $record->get('id');
$record->remove('id');
$language = $record->get('language');
$record->remove('language');
$sql = "UPDATE contents SET date_pub=:date_pub, 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('date_pub');
$record->remove('parent_id');
$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('id', $id);
$record->set('item_name', 'content');
$result = $this->db->run($sql, $record->toArray());
return $result;
}
