/** * / * @param Record $record [description] * @return [type] [description] */ public function processRecord(Record $record) { if (!$record->has('activity')) { $record->set('activity', 2); } return $record; }
/** * / * @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 processRecord(Record $record) { $total = (int) $record->get('totalhours') * (int) $record->get('rate'); $record->set('total', $total); return $record; }
/** * / * @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; }