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);
}
}
}
}
if (array_key_exists('adviceId', $properties)) {
$where = ' where adviceId = ' . $properties['adviceId'];
}
if (array_key_exists('createdAt', $properties)) {
$where = ' where createdAt = ' . $properties['createdAt'];
}
if (array_key_exists('createdBy', $properties)) {
$where = ' where createdBy = ' . $properties['createdBy'];
}
if (array_key_exists('order by', $properties)) {
$orderBy = ' order by ' . $properties['order by'];
}
if (array_key_exists('group by', $properties)) {
$groupBy = ' group by ' . $properties['group by'];
}
return $sql . $where . $groupBy . $orderBy . ';';
}
}
$adviceDao = new AdviceDao();
$adviceDao->getDb();
$advice = new Advice();
$advice->setContent('what if i want to eat without getting fat while i have been escaping exercising for decades');
$advice->setCreatedBy(1);
//$adviceDao->insert($advice);
var_dump($adviceDao->findById('2'));
//var_dump($adviceDao->findAll());
//echo $adviceDao->delete('2');
//echo $adviceDao->getFindSql();
//echo $adviceDao->getFindSql(array('createdAt'=>'2015-10-10'));
var_dump($adviceDao->find(array("createdBy" => 2)));
