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