public function save($model = null, $forceInsert = false)
{
$this->getAdapter()->beginTransaction();
$this->setUseTransaction(false);
if ($forceInsert) {
parent::save($model, $forceInsert);
} else {
$sql = 'DELETE FROM volunteer_expertise_area WHERE volunteer_id=?';
unset($params);
$params[] = $model->id;
$smtp = $this->getDefaultAdapter()->prepare($sql);
$smtp->execute($params);
}
foreach ($model->expertise_areas_id as $key => $exp) {
$sql = 'INSERT INTO volunteer_expertise_area (volunteer_id, expertise_area_id) VALUES(?,?)';
unset($params);
$params[] = $model->id;
$params[] = $exp;
$smtp = $this->getDefaultAdapter()->prepare($sql);
$smtp->execute($params);
}
$this->getDefaultAdapter()->commit();
}
/**
* prepare data to be returned from query
* @param array
* @return Agana_Calendar_Model_Agenda
*/
protected function _prepareReturnData($data, $returnArray = true)
{
$ret = parent::_prepareReturnData($data, $returnArray);
return $ret;
}
public function get($id)
{
$person = parent::get($id, false);
// $db = $this->getDefaultAdapter();
// $sql = $db->select()
// ->from('person_media')
// ->where('person_id = ?', $id);
// $db->setFetchMode(Zend_DB::FETCH_ASSOC);
// $mediaRow = $db->fetchRow($sql);
//
// $media = null;
// if ($mediaRow) {
// $mediaDao = new Media_Persist_Dao_Image();
// $media = $mediaDao->get($mediaRow['media_id']);
// }
// $person->setMedia($media);
return $person;
}
public function getAll($params = null)
{
$params['from'] = 'v_Employee';
return parent::getAll($params);
}
public function __construct($config = array())
{
parent::__construct($config);
$this->setTrackUpdateAuditTrail(true);
$this->setAuditTrailClassName('App_Module_Audit');
}
