Changeset 471

Show
Ignore:
Timestamp:
11/25/08 16:55:52 (1 month ago)
Author:
nicolas
Message:

Bourse : limite les nouveaux produits au secuteur sélectionné

Files:

Legend:

Unmodified
Added
Removed
Modified
Copied
Moved
  • trunk/lib/model/MarketPeer.php

    r433 r471  
    8484          $criterion->addAnd($c->getNewCriterion(MarketPeer::CREATED_AT, $end_at, Criteria::LESS_EQUAL)); 
    8585          $c->add($criterion); 
     86          // sector limit 
     87          $c2 = new Criteria(); 
     88          $c2->add(Market_sectorPeer::AGENCY_ID, sfContext::getInstance()->getUser()->getSubscriber()->getAgencyId()); 
     89          $sectors = Market_sectorPeer::doSelect($c2); 
     90          foreach($sectors as $sector): 
     91            $apicity = ApicityPeer::retrieveByPk($sector->getCityId()); 
     92            $c->add(MarketPeer::CITY, $apicity); 
     93          endforeach; 
    8694      return MarketPeer::doCount($c); 
    8795    else: 
     
    108116          $criterion->addAnd($c->getNewCriterion(MarketPeer::UPDATED_AT, $end_at, Criteria::LESS_EQUAL)); 
    109117          $c->add($criterion); 
     118          // sector limit 
     119          $c2 = new Criteria(); 
     120          $c2->add(Market_sectorPeer::AGENCY_ID, sfContext::getInstance()->getUser()->getSubscriber()->getAgencyId()); 
     121          $sectors = Market_sectorPeer::doSelect($c2); 
     122          foreach($sectors as $sector): 
     123            $apicity = ApicityPeer::retrieveByPk($sector->getCityId()); 
     124            $c->add(MarketPeer::CITY, $apicity); 
     125          endforeach; 
    110126      return MarketPeer::doCount($c); 
    111127    else: