add($data); return $res; } /** * 更新 * @param $map * @param $save * @return mixed */ public function updateOrder($map, $save) { $res = $this->where($map)->save($save); return $res; } /** * @param $map 查询条件 * @param string $field 需要获取的字段 * @param string $order 排序 * @param string $alias1 sell表别名 * @param string $alias2 goods表别名 * @param string $page 页码及条数 * @return mixed */ public function getSelectAndGoods($map, $field = '', $order = '', $alias1 = 's', $alias2 = 'g', $page = '') { if ($order == '') { $order = $alias1 . '.id asc'; } if ($field == '') { $field = $alias1 . '.*,' . $alias2 . '.*'; } if ($page) { $res = $this->alias($alias1) ->join('ls_retail_goods as ' . $alias2 . ' on ' . $alias1 . '.goods_id=' . $alias2 . '.id', 'LEFT') ->field($field) ->where($map) ->order($order) ->page($page) ->select(); } else { $res = $this->alias($alias1) ->join('ls_retail_goods as ' . $alias2 . ' on ' . $alias1 . '.goods_id=' . $alias2 . '.id', 'LEFT') ->field($field) ->where($map) ->order($order) ->select(); } return $res; } /** * 获取一条 * @param $map * @param string $field * @return mixed */ public function getFind($map, $field = '*') { $res = $this->field($field)->where($map)->find(); return $res; } /** * @param $map * @param string $field * @param string $order * @param string $page * @return mixed */ public function getSelect($map, $field = '*', $order = 'id asc', $page = '') { if ($page) { $res = $this->field($field)->where($map)->order($order)->page($page)->select(); } else { $res = $this->field($field)->where($map)->order($order)->select(); } return $res; } /** * 获去数量 * @param $map * @return mixed */ public function getCount($map) { $res = $this->where($map)->count(); return $res; } /** * 获取某字段 * @param $map * @param string $fields * @param $bol * @return mixed */ public function getFindField($map, $fields = 'id', $bol = false) { $res = $this->where($map)->getField($fields, $bol); return $res; } /** * 某个字段向上增加 * @param $map 条件 * @param $key 字段名 * @param $val 增加的值 * @return mixed */ public function toSetInc($map, $key, $val) { $res = $this->where($map)->setInc($key, $val); return $res; } /** * 某个字段向下加减少 * @param $map 条件 * @param $key 字段名 * @param $val 减少的值 * @return mixed */ public function toSetDec($map, $key, $val) { $res = $this->where($map)->setDec($key, $val); return $res; } /** * 获取某字段的sum值 * @param $map * @param $key * @return mixed */ public function getSum($map, $key) { $res = $this->where($map)->sum($key); return $res ? $res : 0; } /** * 查询根据某个字段排序的列表 * @param $map * @param string $group_field * @param string $field * @return mixed */ public function getGroupSelect($map, $group_field, $field = '*') { $res = $this->field($field)->where($map)->group($group_field)->select(); return $res; } }