Esempi in PHP per XLite\Model\QueryBuilder AQueryBuilder::innerJoin

Esempio n. 1

File: Product.php Progetto: kewaunited/xcart

 /**
  * Define calculated price definition DQL
  *
  * @param \XLite\Model\QueryBuilder\AQueryBuilder $queryBuilder Query builder
  * @param string                                  $alias        Main alias
  *
  * @return string
  */
 protected function defineCalculatedPriceDQL(\XLite\Model\QueryBuilder\AQueryBuilder $queryBuilder, $alias)
 {
     $profile = \XLite\Core\Auth::getInstance()->getProfile();
     if ($profile && $profile->getMembership()) {
         $queryBuilder->innerJoin($alias . '.quickData', 'qd', 'WITH', 'qd.membership = :qdMembership')->setParameter('qdMembership', $profile->getMembership());
     } else {
         $queryBuilder->innerJoin($alias . '.quickData', 'qd', 'WITH', 'qd.membership is null');
     }
     return 'qd.price';
 }