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)));