public function insert(Advice $advice)
{
$advice->setAdviceId(null);
$advice->setCreatedAt(new DateTime());
$sql = 'insert into ' . $this->tableName . '(adviceId, content,createdBy,createdAt) ' . 'values( :adviceId, :content, :createdBy, :createdAt)';
return $this->execute($sql, $advice);
//$statement = $this->getDb()->prepare($sql);
// $data = AdviceMapper::getParams($advice);
//echo $data[':content'];
//$statement->execute($data);
// echo date_format($advice->getCreatedAt(), 'Y-m-d H:i:s');
}
public static function map(Advice $advice, array $properties)
{
if (array_key_exists('adviceId', $properties)) {
$advice->setAdviceId($properties['adviceId']);
}
if (array_key_exists('content', $properties)) {
$advice->setContent($properties['content']);
}
if (array_key_exists('createdBy', $properties)) {
$advice->setCreatedBy($properties['createdBy']);
}
if (array_key_exists('createdAt', $properties)) {
$createdAt = DateTransform::createDateTime($properties['createdAt']);
if ($createdAt) {
$advice->setCreatedAt($createdAt);
}
}
}
