public function execute() { //open model $model = new PeopleModel(); //retrieve all people $people = $model->getPeopleList(); //return results as json object echo json_encode($people); }
public function execute() { //grab people $model = new PeopleModel(); $people = $model->getPeopleList(); //grab deals $model = new DealModel(); $deals = $model->getDealList(); //grab notes categories $model = new NoteModel(); $categories = $model->getNoteCategories(); //construct data obj $data = array('people' => $people, 'deals' => $deals, 'categories' => $categories); //encode and return results echo json_encode($data); }
public function execute() { //open model $model = new PeopleModel(); //retrieve all people $people = $model->getPeopleList(); if (count($people)) { foreach ($people as $index => $row) { $people[$index]['type'] = "person"; $people[$index]['association_link'] = RouteHelper::_('index.php?view=people&layout=person&id=' . $row['id']); } } //open model $model = new DealModel(); //retrieve all people $deals = $model->getDealList(); if (count($deals)) { foreach ($deals as $index => $row) { $deals[$index]['type'] = 'deal'; $deals[$index]['association_link'] = RouteHelper::_('index.php?view=deals&layout=deal&id=' . $row['id']); } } //open model $model = new CompanyModel(); //retrieve all people $companies = $model->getCompanyList(); if (count($companies)) { foreach ($companies as $index => $row) { $companies[$index]['type'] = 'company'; $companies[$index]['association_link'] = RouteHelper::_('index.php?view=companies&layout=company&id=' . $row['id']); } } //merge our results to a grand object $results = array_merge($people, $deals, $companies); //return results as json object echo json_encode($results); }
public static function getPeopleList() { //open model $model = new PeopleModel(); //retrieve all people $people = $model->getPeopleList(); $people_list = array(); if (count($people)) { foreach ($people as $index => $row) { $people_list[$row['id']] = $row['first_name'] . ' ' . $row['last_name']; } } return $people_list; }