Exemple #1
0
 /**
  * add a virtual field that counts occurring relations
  * @param $key
  */
 public function countRel($key)
 {
     if (isset($this->fieldConf[$key])) {
         // one-to-one, one-to-many
         if ($this->fieldConf[$key]['relType'] == 'belongs-to-one') {
             if ($this->dbsType == 'sql') {
                 $this->mapper->set('count_' . $key, 'count(' . $key . ')');
                 $this->grp_stack = !$this->grp_stack ? $key : $this->grp_stack . ',' . $key;
             } elseif ($this->dbsType == 'mongo') {
                 $this->_mongo_addGroup(array('keys' => array($key => 1), 'reduce' => 'prev.count_' . $key . '++;', "initial" => array("count_" . $key => 0)));
             } else {
                 trigger_error('Cannot add direct relational counter.');
             }
         } elseif ($this->fieldConf[$key]['relType'] == 'has-many') {
             $relConf = $this->fieldConf[$key]['has-many'];
             if ($relConf['hasRel'] == 'has-many') {
                 // many-to-many
                 if ($this->dbsType == 'sql') {
                     $mmTable = $this->mmTable($relConf, $key);
                     $filter = array($mmTable . '.' . $relConf['relField'] . ' = ' . $this->table . '.' . $this->primary);
                     $from = $mmTable;
                     if (array_key_exists($key, $this->relFilter) && !empty($this->relFilter[$key][0])) {
                         $options = array();
                         $from = $mmTable . ' ' . $this->_sql_left_join($key, $mmTable, $relConf['relPK'], $relConf['relTable']);
                         $relFilter = $this->relFilter[$key];
                         $this->_sql_mergeRelCondition($relFilter, $relConf['relTable'], $filter, $options);
                     }
                     $filter = $this->queryParser->prepareFilter($filter, $this->dbsType, $this->db, $this->fieldConf);
                     $crit = array_shift($filter);
                     if (count($filter) > 0) {
                         $this->preBinds += $filter;
                     }
                     $this->mapper->set('count_' . $key, '(select count(' . $mmTable . '.' . $relConf['relField'] . ') from ' . $from . ' where ' . $crit . ' group by ' . $mmTable . '.' . $relConf['relField'] . ')');
                 } else {
                     // count rel
                     $this->countFields[] = $key;
                 }
             } elseif ($this->fieldConf[$key]['has-many']['hasRel'] == 'belongs-to-one') {
                 // many-to-one
                 if ($this->dbsType == 'sql') {
                     $fConf = $relConf[0]::resolveConfiguration();
                     $fTable = $fConf['table'];
                     $rKey = $relConf[1];
                     $crit = $fTable . '.' . $rKey . ' = ' . $this->table . '.' . $this->primary;
                     $filter = $this->mergeWithRelFilter($key, array($crit));
                     $filter = $this->queryParser->prepareFilter($filter, $this->dbsType, $this->db, $this->fieldConf);
                     $crit = array_shift($filter);
                     if (count($filter) > 0) {
                         $this->preBinds += $filter;
                     }
                     $this->mapper->set('count_' . $key, '(select count(' . $fTable . '.' . $fConf['primary'] . ') from ' . $fTable . ' where ' . $crit . ' group by ' . $fTable . '.' . $rKey . ')');
                 } else {
                     // count rel
                     $this->countFields[] = $key;
                 }
             }
         }
     }
 }
Exemple #2
0
 /**
  * Count records that match criteria
  * @param null $filter
  * @param int $ttl
  * @return mixed
  */
 public function count($filter = NULL, $ttl = 0)
 {
     $filter = $this->queryParser->prepareFilter($filter, $this->dbsType);
     return $this->mapper->count($filter, $ttl);
 }