123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353 |
- <?php
- namespace app\common\model;
- use think\facade\Db;
- class Wholesalegoods extends BaseModel {
- public $page_info;
- const WHOLESALE_GOODS_STATE_CANCEL = 0;
- const WHOLESALE_GOODS_STATE_NORMAL = 1;
-
- public function getWholesalegoodsList($condition, $pagesize = null, $order = '', $field = '*', $limit = 0) {
- if ($pagesize) {
- $res = Db::name('wholesalegoods')->field($field)->where($condition)->order($order)->paginate(['list_rows'=>$pagesize,'query' => request()->param()],false);
- $this->page_info = $res;
- return $res->items();
- } else {
- return $wholesalegoods_list = Db::name('wholesalegoods')->field($field)->where($condition)->limit($limit)->order($order)->select()->toArray();
- }
- }
-
- public function getWholesalegoodsExtendList($condition, $pagesize = null, $order = '', $field = '*', $limit = 0) {
- $wholesalegoods_list = $this->getWholesalegoodsList($condition, $pagesize, $order, $field, $limit);
- if (!empty($wholesalegoods_list)) {
- for ($i = 0, $j = count($wholesalegoods_list); $i < $j; $i++) {
- $wholesalegoods_list[$i] = $this->getWholesalegoodsExtendInfo($wholesalegoods_list[$i]);
- }
- }
- return $wholesalegoods_list;
- }
-
-
- public function getWholesalegoodsExtendIds($condition, $pagesize = null, $order = '', $field = 'goods_id', $limit = 0) {
- $wholesalegoods_id_list = $this->getWholesalegoodsList($condition, $pagesize, $order, $field, $limit);
- if (!empty($wholesalegoods_id_list)) {
- for ($i = 0; $i < count($wholesalegoods_id_list); $i++) {
- $wholesalegoods_id_list[$i] = $wholesalegoods_id_list[$i]['goods_id'];
- }
- }
- return $wholesalegoods_id_list;
- }
-
- public function getWholesalegoodsInfo($condition) {
- $result = Db::name('wholesalegoods')->where($condition)->find();
- return $result;
- }
-
- public function getWholesalegoodsInfoByID($wholesalegoods_id, $store_id = 0) {
- if (intval($wholesalegoods_id) <= 0) {
- return null;
- }
- $condition = array();
- $condition[] = array('wholesalegoods_id','=',$wholesalegoods_id);
- $wholesalegoods_info = $this->getWholesalegoodsInfo($condition);
- if ($store_id > 0 && $wholesalegoods_info['store_id'] != $store_id) {
- return null;
- } else {
- return $wholesalegoods_info;
- }
- }
-
- public function addWholesalegoods($wholesalegoods_info) {
- $wholesalegoods_info['wholesalegoods_state'] = self::WHOLESALE_GOODS_STATE_NORMAL;
- $wholesalegoods_id = Db::name('wholesalegoods')->insertGetId($wholesalegoods_info);
- if($wholesalegoods_id){
-
- $this->_lockGoods($wholesalegoods_info['goods_commonid'],$wholesalegoods_info['goods_id']);
- }
-
- $this->_dGoodsWholesaleCache($wholesalegoods_info['goods_id']);
- $wholesalegoods_info['wholesalegoods_id'] = $wholesalegoods_id;
- $wholesalegoods_info = $this->getWholesalegoodsExtendInfo($wholesalegoods_info);
- return $wholesalegoods_info;
- }
-
- public function editWholesalegoods($update, $condition) {
- $result = Db::name('wholesalegoods')->where($condition)->update($update);
- if ($result) {
- $wholesalegoods_list = $this->getWholesalegoodsList($condition, null, '', 'goods_id');
- if (!empty($wholesalegoods_list)) {
- foreach ($wholesalegoods_list as $val) {
-
- $this->_dGoodsWholesaleCache($val['goods_id']);
- }
- }
- }
- return $result;
- }
-
- public function delWholesalegoods($condition) {
- $wholesalegoods_list = $this->getWholesalegoodsList($condition, null, '', 'goods_id,goods_commonid');
- $result = Db::name('wholesalegoods')->where($condition)->delete();
- if ($result) {
- if (!empty($wholesalegoods_list)) {
- foreach ($wholesalegoods_list as $val) {
- $this->_unlockGoods($val['goods_commonid'],$val['goods_id']);
-
- $this->_dGoodsWholesaleCache($val['goods_id']);
- }
- }
- }
- return $result;
- }
-
- public function getWholesalegoodsExtendInfo($wholesale_info) {
- $wholesale_info['goods_url'] = (string)url('/home/Goods/index', array('goods_id' => $wholesale_info['goods_id']));
- $wholesale_info['image_url'] = goods_cthumb($wholesale_info['goods_image'], 60, $wholesale_info['store_id']);
- $wholesale_info['wholesalegoods_price'] = unserialize($wholesale_info['wholesalegoods_price']);
- return $wholesale_info;
- }
-
- public function getWholesalegoodsCommendList($count = 4) {
- $condition = array();
- $condition[] = array('wholesalegoods_state', '=', self::WHOLESALE_GOODS_STATE_NORMAL);
- $condition[] = array('wholesale_starttime', '<', TIMESTAMP);
- $condition[] = array('wholesale_end_time', '>', TIMESTAMP);
- $wholesale_list = $this->getWholesalegoodsExtendList($condition, null, '', '*', $count);
- return $wholesale_list;
- }
-
- private function _lockGoods($goods_commonid,$goods_id)
- {
- $condition = array();
- $condition[] = array('goods_commonid','=',$goods_commonid);
- $goods_model = model('goods');
- $goods_model->editGoodsCommonLock($condition);
-
- $condition = array();
- $condition[] = array('goods_id','=',$goods_id);
- $goods_model->editGoodsLock($condition);
- }
-
- private function _unlockGoods($goods_commonid,$goods_id)
- {
- $goods_model = model('goods');
- $goods_model->editGoodsUnlock(array('goods_id' => $goods_id));
- if(!$goods_model->getGoodsCount(array('goods_commonid' => $goods_commonid,'goods_lock'=>1))){
- $goods_model->editGoodsCommonUnlock(array('goods_commonid' => $goods_commonid));
- }
- }
-
-
- public function getWholesalegoodsInfoByGoodsID($goods_id) {
- $info = $this->_rGoodsWholesaleCache($goods_id);
- if (empty($info)) {
- $condition = array();
- $condition[] = array('wholesalegoods_state','=',self::WHOLESALE_GOODS_STATE_NORMAL);
- $condition[] = array('wholesale_end_time','>',TIMESTAMP);
- $condition[] = array('goods_id','=',$goods_id);
- $wholesalegoods_list = $this->getWholesalegoodsExtendList($condition, null, 'wholesale_starttime asc', '*', 1);
- $info['info'] = isset($wholesalegoods_list[0]) ? serialize($wholesalegoods_list[0]) : serialize("");
- $this->_wGoodsWholesaleCache($goods_id, $info);
- }
- $wholesalegoods_info = unserialize($info['info']);
- if (!empty($wholesalegoods_info) && ($wholesalegoods_info['wholesale_starttime'] > TIMESTAMP || $wholesalegoods_info['wholesale_end_time'] < TIMESTAMP)) {
- $wholesalegoods_info = array();
- }
- return $wholesalegoods_info;
- }
-
- public function getWholesalegoodsListByGoodsString($goods_string) {
- $wholesalegoods_list = $this->_getWholesalegoodsListByGoods($goods_string);
- $wholesalegoods_list = array_under_reset($wholesalegoods_list, 'goods_id');
- return $wholesalegoods_list;
- }
-
- private function _getWholesalegoodsListByGoods($goods_id_string) {
- $condition = array();
- $condition[] = array('wholesalegoods_state','=',self::WHOLESALE_GOODS_STATE_NORMAL);
- $condition[] = array('wholesale_starttime','<',TIMESTAMP);
- $condition[] = array('wholesale_end_time','>',TIMESTAMP);
- $condition[] = array('goods_id','in', $goods_id_string);
- $wholesalegoods_list = $this->getWholesalegoodsExtendList($condition, null, 'wholesalegoods_id desc', '*');
- return $wholesalegoods_list;
- }
-
- private function _rGoodsWholesaleCache($goods_id) {
- return rcache($goods_id, 'goods_wholesale');
- }
-
- private function _wGoodsWholesaleCache($goods_id, $info) {
- return wcache($goods_id, $info, 'goods_wholesale');
- }
-
- private function _dGoodsWholesaleCache($goods_id) {
- return dcache($goods_id, 'goods_wholesale');
- }
- }
|