Пример #1
0
 /**
  * 返回用于查询关联表数据的 SQL 语句
  *
  * @param string $sql
  * @param string $in
  *
  * @return string
  */
 function _getFindSQLBase($sql, $in)
 {
     if ($in) {
         $sql .= " WHERE {$this->qforeignKey} {$in}";
     }
     if ($this->conditions) {
         if (is_array($this->conditions)) {
             $conditions = FLEA_Db_SqlHelper::parseConditions($this->conditions, $this->assocTDG);
             if (is_array($conditions)) {
                 $conditions = $conditions[0];
             }
         } else {
             $conditions =& $this->conditions;
         }
         if ($conditions) {
             $sql .= " AND {$conditions}";
         }
     }
     if ($this->sort && $this->countOnly == false) {
         $sql .= " ORDER BY {$this->sort}";
     }
     return $sql;
 }
Пример #2
0
 /**
  * 根据关联表的 counterCache 选项更新统计信息
  *
  * @param array $row
  */
 function _updateCounterCache(&$row)
 {
     foreach (array_keys($this->links) as $linkKey) {
         $link =& $this->links[$linkKey];
         /* @var $link FLEA_Db_TableLink */
         if ($link->type != BELONGS_TO || !$link->enabled || !$link->counterCache) {
             continue;
         }
         $link->init();
         $f = $link->assocTDG->qfield($link->counterCache);
         if (isset($row[$link->foreignKey])) {
             $fkv = $this->dbo->qstr($row[$link->foreignKey]);
         } else {
             $pkv = $this->dbo->qstr($row[$this->primaryKey]);
             $sql = "SELECT {$link->foreignKey} FROM {$this->qtableName} WHERE {$this->qpk} = {$pkv}";
             $fkv = $this->dbo->getOne($sql);
         }
         $conditions = "{$link->qforeignKey} = {$fkv}";
         if ($link->conditions) {
             if (is_array($link->conditions)) {
                 $conditions = FLEA_Db_SqlHelper::parseConditions($link->conditions, $link->assocTDG);
                 if (is_array($conditions)) {
                     $conditions = $conditions[0];
                 }
             } else {
                 $conditions =& $link->conditions;
             }
             if ($conditions) {
                 $conditions = "{$link->qforeignKey} = {$fkv} AND {$conditions}";
             }
         }
         $sql = "UPDATE {$link->assocTDG->qtableName} SET {$f} = (SELECT COUNT(*) FROM {$this->qtableName} WHERE {$conditions}) WHERE {$link->assocTDG->qpk} = {$fkv}";
         $this->dbo->execute($sql);
     }
 }
 /**
  * 分析查询条件,返回 WHERE 子句
  *
  * @param array $conditions
  * @param boolean $queryLinks
  *
  * @return string
  */
 function getWhere($conditions, $queryLinks = true)
 {
     // 处理查询条件
     $where = FLEA_Db_SqlHelper::parseConditions($conditions, $this);
     $sqljoin = '';
     $distinct = '';
     do {
         if (!is_array($where)) {
             $whereby = $where != '' ? " WHERE {$where}" : '';
             break;
         }
         $arr = $where;
         list($where, $linksWhere) = $arr;
         unset($arr);
         if (!$this->autoLink || !$queryLinks) {
             $whereby = $where != '' ? " WHERE {$where}" : '';
             break;
         }
         foreach ($linksWhere as $linkid => $lws) {
             if (!isset($this->links[$linkid]) || !$this->links[$linkid]->enabled) {
                 continue;
             }
             $link =& $this->links[$linkid];
             /* @var $link FLEA_Db_TableLink */
             if (!$link->init) {
                 $link->init();
             }
             $distinct = 'DISTINCT ';
             switch ($link->type) {
                 case HAS_ONE:
                 case HAS_MANY:
                     /* @var $link FLEA_Db_HasOneLink */
                     $sqljoin .= "LEFT JOIN {$link->assocTDG->qtableName} ON {$link->mainTDG->qpk} = {$link->qforeignKey} ";
                     break;
                 case BELONGS_TO:
                     /* @var $link FLEA_Db_BelongsToLink */
                     $sqljoin .= "LEFT JOIN {$link->assocTDG->qtableName} ON {$link->assocTDG->qpk} = {$link->qforeignKey} ";
                     break;
                 case MANY_TO_MANY:
                     /* @var $link FLEA_Db_ManyToManyLink */
                     $sqljoin .= "INNER JOIN {$link->qjoinTable} ON {$link->qforeignKey} = {$this->qpk} INNER JOIN {$link->assocTDG->qtableName} ON {$link->assocTDG->qpk} = {$link->qassocForeignKey} ";
                     break;
             }
             $lw = reset($lws);
             if (isset($lw[3])) {
                 $whereby = $where != '' ? " WHERE {$where} {$lw[3]} " : ' WHERE';
             } else {
                 $whereby = $where != '' ? " WHERE {$where} AND " : ' WHERE';
             }
             foreach ($lws as $lw) {
                 list($field, $value, $op, $expr, $isCommand) = $lw;
                 if (!$isCommand) {
                     $field = $link->assocTDG->qfield($field);
                     $value = $this->dbo->qstr($value);
                     $whereby .= " {$field} {$op} {$value} {$expr}";
                 } else {
                     $whereby .= " {$value} {$expr}";
                 }
             }
             $whereby = substr($whereby, 0, -(strlen($expr) + 1));
             unset($link);
         }
         $whereby = " {$sqljoin} {$whereby}";
     } while (false);
     if ($queryLinks) {
         return array($whereby, $distinct);
     } else {
         return $whereby;
     }
 }