private function setModel($row)
{
$model = new Application_Model_Project();
$model->setId($row->id)->setTitle($row->title)->setDescription($row->description)->setClientInfo($row->client_info)->setStartDate($row->start_date)->setEndDate($row->end_date)->setStatus($row->status)->setProjectManagerId($row->project_manager_id)->setTeamLeaderId($row->team_leader_id)->setAddedon($row->addedon)->setUpdatedon($row->updatedon);
/*find project resource*/
// $projectUser=$row->findManyToManyRowset('Application_Model_DbTable_User','Application_Model_DbTable_ProjectUser');
// $user=new Application_Model_User();
// $arrUser=array();
// foreach($projectUser as $_user)
// {
// $arrUser[]=$user->setModel($_user);
//
// }
// $model->setUsers($arrUser);
$projectUser = new Application_Model_ProjectUser();
$table = $projectUser->getMapper()->getDbTable();
$select = $table->select()->setIntegrityCheck(false)->from(array("pu" => 'project_user'), array('pustatus' => 'status', 'user_id'))->join(array("u" => 'user'), 'u.id=pu.user_id', array('first_name', 'last_name', 'middle_name', 'employee_code'))->join(array("p" => 'project'), 'p.id=pu.project_id')->where("pu.project_id='{$row->id}'");
$model->setProjectUsers($table->fetchAll($select));
/*------------------------*/
return $model;
}
