add($data); return $res; } /** * 更新 * @param $map * @param $save * @return mixed */ public function updateOrder($map, $save) { if(!isset($map['status'])){ $map['status'] = array('in','0,1'); } $res = $this->where($map)->save($save); return $res; } /** * 获取一条 * @param $map * @param string $field * @return mixed */ public function getFind($map, $field = '*') { if(!isset($map['status'])){ $map['status'] = array('in','0,1'); } $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(!isset($map['status'])){ $map['status'] = array('in','0,1'); } 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) { if(!isset($map['status'])){ $map['status'] = array('in','0,1'); } $res = $this->where($map)->count(); 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; } public function getShoppingHostGoods($shopping_ids){ $goods = $this->alias('g') ->join("ls_retail_shopping as s on g.id=s.goods_id") ->join('ls_retail_host as h on h.goods_id=g.id AND h.type=2 AND h.starttime < ' . time() . ' AND h.endtime >' . time(), 'LEFT') ->field('h.status as h_status,s.sku_id,s.num,g.id,g.status,g.goods_name,g.goods_num,g.good_image,g.goods_image_id,g.good_number,g.purch_price,g.goods_class_id,g.online_price,g.vip_online_price,g.vip_online_integral,g.vip_online_state,g.label_id,g.shop_mem_status,g.shop_mem_price,g.issellonline,g.can_exchange_weigh,g.plus_mem_status,plus_price') ->where(array('s.id' => array('in', $shopping_ids))) ->select(); return $goods; } public function getFindField($map,$fields,$bol = false) { $fields = $fields?$fields:"*"; $res = $this->where($map)->getField($fields, $bol); return $res; } }