Zend Framework数据库操作

/**
     * 给Zend_Db_Select增加where条件
     * 
     * @param Zend_Db_Select $select
     * @param array $where
     * @return Zend_Db_Select
     */
    protected function addWhereToSelect($select, $where) {
        foreach ($where as $k=>$v) {
            if ($v === null) {
                $select->where($k);
            } else {
                $select->where($k, $v);
            }
        }
        if ($this->_status_fieldname) {
            $select->where($this->_status_fieldname . ' < ?', Mana_Const::STATUS_DEL);
        }
        return $select;
    }

 

/**
     * 给Zend_Db_Select增加where条件
     * 
     * @param Zend_Db_Select $select
     * @param array $where
     * @return Zend_Db_Select
     */
    protected function addWhereToSelect($select, $where) {
        foreach ($where as $k=>$v) {
            if ($v === null) {
                $select->where($k);
            } else {
                $select->where($k, $v);
            }
        }
        if ($this->_status_fieldname) {
            $select->where($this->_status_fieldname . ' < ?', Mana_Const::STATUS_DEL);
        }
        return $select;
    }

/**
     * Update delete等增加where条件
     * 
     * @param array $where
     * @return string
     */
    protected function addWhereToUdl($where) {
        $sw = '';
        foreach ($where as $quote=>$val) {
            if ($val === null) {
                $sw .= ' ' . $quote . ' AND';
            } else {
                $sw .= ' ' .$this->_db->quoteInto($quote, $val) . ' AND';
            }
        }
        if ($sw) {
            $sw = trim($sw, 'AND');
        }
        return $sw;
    }

/**
     * 
     * 获得满足条件的第一行数据
     * @param array $mixWhere
     * 设置连表情况
     *
     * @param array $options like
     * array(
     *     tables=>array('key'=>array('tablename'=>'', 'on'=>'', 'fields'=>array())),
     *     'where'=>array(
     *         'tbl.field = ?'=>val,
     *     )
     * )
     */
    public function getRow($mixWhere = array(), $options = array()) {
        $objSelect = $this->_db->select();        
        $objSelect->from(array('s'=>$this->getTableName()),'*');
        $objSelect = $this->addWhereToSelect($objSelect, $mixWhere);
        $objSelect = $this->addOptionsToSelect($objSelect, $options);
        $this->_logger->log(__CLASS__ . '.'.__FUNCTION__ . '.'.$objSelect->__toString(), Zend_Log::INFO);
        $objRow = $this->_db->fetchRow($objSelect,null,Zend_Db::FETCH_OBJ);
        return $objRow;
    }

/**
     * 获得满足条件记录数量
     * 
     * @param array $mixWhere
     * 设置连表情况
     *
     * @param array $options like
     * array(
     *     tables=>array('key'=>array('tablename'=>'', 'on'=>'', 'fields'=>array())),
     *     'where'=>array(
     *         'tbl.field = ?'=>val,
     *     )
     * )
     * @return int
     */
    public function getCount($mixWhere = array(), $options = array()) {
        $objSelect = $this->_db->select();        
        $objSelect->from(array('s'=>$this->getTableName()),array('COUNT(1)'));
        $objSelect = $this->addWhereToSelect($objSelect, $mixWhere);
        $objSelect = $this->addOptionsToSelect($objSelect, $options);
        $this->_logger->log(__CLASS__ . '.'.__FUNCTION__ . '.'.$objSelect->__toString(), Zend_Log::INFO);
        $num = $this->_db->fetchOne($objSelect,null,Zend_Db::FETCH_OBJ);
        return $num;
    }
    

 

/**
     * 
     * Enter description here ...
     * @param Zend_Db_Select $select
     * @param unknown_type $options
     * 设置连表情况
     *
     * @param array $options like
     * array(
     *     tables=>array('key'=>array('tablename'=>'', 'on'=>'', 'fields'=>array(), 'jointype'=>'join|joinleft|joinright')),
     *     'where'=>array(
     *         'tbl.field = ?'=>val,
     *     )
     * )
     * @return Zend_Db_Select
     */
    protected function addOptionsToSelect($select, $options) {
        if (empty($options)) {
            return $select;
        }
        $tables = $options['tables'];
        foreach ($tables as $key=>$tblJoinInfo) {
            $tName = '';
            if (is_numeric($key)) {
                $tName = $tblJoinInfo['tablename'];
            } else {
                $tName = array($key=>$tblJoinInfo['tablename']);
            }
            if ($tblJoinInfo['jointype'] == '' || $tblJoinInfo['jointype'] == 'join') {
                $select->join($tName, $tblJoinInfo['on'], $tblJoinInfo['fields']);
            } elseif ($tblJoinInfo['jointype'] == 'joinleft') {
                $select->joinLeft($tName, $tblJoinInfo['on'], $tblJoinInfo['fields']);
            } elseif ($tblJoinInfo['jointype'] == 'joinright') {
                $select->joinRight($tName, $tblJoinInfo['on'], $tblJoinInfo['fields']);
            } else {
                throw new Exception('查询错误', 90001);
            }
        }
        $wheres = $options['where'];
        if ($wheres) {
            $select = $this->addWhereToSelect($select, $wheres);
        }
        return $select;
    }

 

/**
     * 
     * 获得满足条件的所有行数据
     * @param array $mixWhere
     * 设置连表情况
     *
     * @param array $options like
     * array(
     *     tables=>array('key'=>array('tablename'=>'', 'on'=>'', 'fields'=>array())),
     *     'where'=>array(
     *         'tbl.field = ?'=>val,
     *     )
     * )
     */
    public function getRows($mixWhere = array(), $options = array()) {
        $objSelect = $this->_db->select();
        $objSelect->from(array('s'=>$this->getTableName()),'*');
        $objSelect = $this->addWhereToSelect($objSelect, $mixWhere);
        $objSelect = $this->addOptionsToSelect($objSelect, $options);
        $this->_logger->log(__CLASS__ . '.'.__FUNCTION__ . '.'.$objSelect->__toString(), Zend_Log::INFO);
        $objRows = $this->_db->fetchAll($objSelect,null,Zend_Db::FETCH_OBJ);
        return $objRows;
    }