Guest User

Untitled

a guest
Jul 18th, 2018
72
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.03 KB | None | 0 0
  1. ######################################################
  2. # Get all facilities in a county based on facility_id
  3. #####################################################
  4. public function executeRegionResults(sfWebRequest $request)
  5. {
  6. $c = new Criteria();
  7. $c->add(CountyPeer::NICE_TITLE, $request->getParameter('county_name'));
  8. $county = CountyPeer::doSelectOne($c);
  9.  
  10. $c = new Criteria();
  11. $c->add(DistrictPeer::COUNTY_ID, $county->getId());
  12. $districts = DistrictPeer::doSelect($c);
  13.  
  14. $ar_district_ids = array();
  15. foreach($districts as $district)
  16. $ar_district_ids[] = $district->getId();
  17.  
  18. $c = new Criteria();
  19. $c->add(FacilityPeer::DISTRICT_ID, $ar_district_ids, Criteria::IN);
  20. $this->facilities = FacilityPeer::getPager ( $c, $request->getParameter ( 'page', 1 ), 15 );
  21.  
  22. $pager = new sfPropelPager ( 'Facility', 15 );
  23. $pager->setCriteria ( $c );
  24. $pager->setPage ( $this->getRequestParameter ( 'page', 1 ) );
  25. $pager->init ();
  26. $this->pager = $pager;
  27.  
  28.  
  29. return sfView::SUCCESS;
  30. }
Add Comment
Please, Sign In to add comment