zendframework 2 Model 数据模型的使用方法

刚认识zf2时, 对数据模型比较陌生. 接触一段时间后, 才能慢慢上手. 故留下笔记供大家参考.

1.使用方法

以下为获取一行记录封装好的函数.

        /** * select 获取一条记录 *  * @param array|string $where : 兼容getRow(1) * @param array $extra * @return Array */public function getRow($where = '', $extra = array()){$sql = $this->sql;$select = $sql->select();if (isset($where['or']) && is_array($where)){$select->where($this->_getWhere($where['or']), 'OR');$where['or'] = '';unset($where['or']);}if ($where){$select->where($this->_getWhere($where));}if (isset($extra['join'])){//$extra['join'] = array(array('t2' => 'table2'), 'name' => 't2.name', '*', 'left');$select->join($extra['join'][0],//第二个表, 别名用法$extra['join'][1],isset($extra['join'][3]) ? $extra['join'][3] : '*',isset($extra['join'][4]) ? $extra['join'][4] : 'left');} isset($extra['group']) && $select->group($extra['group']); isset($extra['having']) && $select->having($extra['having']); isset($extra['columns']) && $select->columns($extra['columns']); $this->log('getRow='.$this->sql->getSqlStringForSqlObject($select));$rowset = $this->selectWith($select);return $this->iconv($rowset->current(), true);}

其中对where 进行了封装, 实现传入多种用途, 如 like , between 等方法

        /** * 解析where *  * @param array $where * array( *  'id' => '4', *  'id' => array(4, 5), //in 操作 *  'like' => array('name' => 'abc', 'word' => 'hello'), *  'between' => array('id' => array('3', '12')), *  'not' => array('name' => 'abc', 'word' => 'hello'),// name != 'abc' and word != 'hello' *  'or' => array('name' => 'abc', 'word' => 'hello'),//生成 where name = 'abc' or word = 'hello' and ... * ) * @return array */private function _getWhere($where){$whereArr = array();if (!is_array($where)){$whereArr = array($this->primaryKey => $where);}elseif (is_array($where)){foreach ($where as $key => $val){switch ($key){case 'like' : foreach ($val as $itemKey => $itemVal) {$whereArr[] = $this->sql->select()->where->like($itemKey, $itemVal);}break;case 'not' : foreach ($val as $itemKey => $itemVal) {$whereArr[] = new Operator($itemKey, '!=', $itemVal);}break;case 'between' :foreach ($val as $itemKey => $itemVal) {$whereArr[] = $this->sql->select()->where->between($itemKey, $itemVal[0], $itemVal[1]);}break;case 'greater' : foreach ($val as $itemKey => $itemVal) {$whereArr[] = new Operator($itemKey, '>=', $itemVal);}break;default:$whereArr[$key] = $val;}}}return $whereArr;}

当获取多行 getList 时以此类推..

2. 关于代码的复用

我目前的方式是把getRow, getList, insert, update, delete 封装到模型的继承类中, 这样就不必为每个模型写这些基本操作. 当然若遇到业务复杂时, 可单独在模型中开小灶, 单独写.

Author : [e-mail]

Time : 2013.8.30 周五