123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211 |
- <?php
- namespace app\admin\server\life;
- use app\admin\model\LifeGoods;
- class GoodsServer
- {
- /**
- * Notes:获取商品列表
- * @param string $keywords
- * @param int $page
- * @param int $limit
- * @return array
- * User: ZQ
- * Date: 2022/9/13
- */
- public static function getGoodsList(int $page, int $limit, string $keywords)
- {
- [$list, $count] = LifeGoods::getGoodsList($page, $limit, $keywords);
- if (!empty($list)){
- foreach ($list as $k => $v){
- $list[$k]['goods_slide'] = explode(',',$v['goods_slide']);
- $list[$k]['goods_create_time'] = date('Y-m-d H:i:s',$v['goods_create_time']);
- if (!empty($v['goods_update_time'])){
- $list[$k]['goods_update_time'] = date('Y-m-d H:i:s',$v['goods_update_time']);
- }
- }
- }
- return compact('list', 'page', 'limit', 'count');
- }
- /**
- * Notes:修改商品
- * @param string $goods_name
- * @param int $goods_id
- * @return int
- * User: ZQ
- * Date: 2022/9/3
- */
- public static function updateGoods($goods_id,$goods_name,$goods_img,$goods_category_id,$goods_shop_id,$goods_is_new,$goods_price,$goods_content,$goods_sell_num,$goods_postage_id,$goods_status,$goods_weight,$goods_sort,$goods_slide,$goods_pack_price,$food_attr,$food_varieties,$food_packaging,$food_storage,$admin_id)
- {
- LifeGoods::affairBegin();
- try {
- $where = [];
- $where['goods_id'] = $goods_id;
- $data = [];
- $data['goods_name'] = $goods_name;
- $data['goods_img'] = $goods_img;
- $data['goods_shop_id'] = $goods_shop_id;
- $data['goods_is_new'] = $goods_is_new;
- $data['goods_price'] = $goods_price;
- $data['goods_content'] = $goods_content;
- $data['goods_sell_num'] = $goods_sell_num;
- $data['goods_postage_id'] = $goods_postage_id;
- $data['goods_category_id'] = $goods_category_id;
- $data['goods_status'] = $goods_status;
- $data['goods_weight'] = $goods_weight;
- $data['goods_sort'] = $goods_sort;
- $data['goods_slide'] = implode(',',$goods_slide);
- $data['goods_pack_price'] = $goods_pack_price;
- $data['goods_attr'] = $food_attr;
- $data['goods_varieties'] = $food_varieties;
- $data['goods_packaging'] = $food_packaging;
- $data['goods_storage'] = $food_storage;
- $data['goods_update_time'] = time();
- $result = LifeGoods::where($where)->update($data);
- if ($result !== false){
- $msg = '管理员:' . $admin_id . '在:' . date("Y-m-d H:i:s", time()) . '修改健康超市商品-编号: ' . $goods_id;
- plog('life-goods-update', '悦活-健康超市-修改商品', $msg);
- LifeGoods::affairCommit();
- return true;
- }
- throw new \Exception('操作失败!');
- }catch (\Exception $exception){
- LifeGoods::affairRollback();
- throw new \Exception($exception->getMessage(), 500);
- }
- }
- /**
- * Notes:删除商品
- * @param int $goods_id
- * @return int
- * User: ZQ
- * Date: 2022/9/13
- */
- public static function delGoods($goods_id,$admin_id)
- {
- LifeGoods::affairBegin();
- try {
- $where = [];
- $where['goods_id'] = $goods_id;
- $data['goods_is_del'] = 1;
- $result = LifeGoods::where($where)->update($data);
- if (!empty($result)){
- $msg = '管理员:' . $admin_id . '在:' . date("Y-m-d H:i:s", time()) . '删除健康超市商品-编号: ' . $goods_id;
- plog('life-goods-delete', '悦活-健康超市-删除商品', $msg);
- LifeGoods::affairCommit();
- return true;
- }else{
- return false;
- }
- }catch (\Exception $exception){
- LifeGoods::affairRollback();
- throw new \Exception($exception->getMessage(), 500);
- }
- }
- /**
- * Notes: 添加商品
- * @param string $goods_name
- * @param array $goods_rules
- * @return int
- * User: ZQ
- * Date: 2022/9/13
- */
- public static function insertGoods($goods_name,$goods_img,$goods_category_id,$goods_shop_id,$goods_is_new,$goods_price,$goods_content,$goods_sell_num,$goods_postage_id,$goods_status,$goods_weight,$goods_sort,$goods_slide,$goods_pack_price,$food_attr,$food_varieties,$food_packaging,$food_storage,$admin_id)
- {
- LifeGoods::affairBegin();
- try {
- $data = [];
- $data['goods_name'] = $goods_name;
- $data['goods_img'] = $goods_img;
- $data['goods_shop_id'] = $goods_shop_id;
- $data['goods_is_new'] = $goods_is_new;
- $data['goods_price'] = $goods_price;
- $data['goods_content'] = $goods_content;
- $data['goods_sell_num'] = $goods_sell_num;
- $data['goods_postage_id'] = $goods_postage_id;
- $data['goods_category_id'] = $goods_category_id;
- $data['goods_status'] = $goods_status;
- $data['goods_weight'] = $goods_weight;
- $data['goods_sort'] = $goods_sort;
- $data['goods_slide'] = implode(',',$goods_slide);
- $data['goods_pack_price'] = $goods_pack_price;
- $data['goods_attr'] = $food_attr;
- $data['goods_varieties'] = $food_varieties;
- $data['goods_packaging'] = $food_packaging;
- $data['goods_storage'] = $food_storage;
- $data['goods_create_time'] = time();
- $result = LifeGoods::insertGetId($data);
- if (!empty($result)){
- $msg = '管理员:' . $admin_id . '在:' . date("Y-m-d H:i:s", time()) . '添加健康超市商品-编号: ' . $result;
- plog('life-goods-create', '悦活-健康超市-添加商品', $msg);
- LifeGoods::affairCommit();
- return $result;
- }
- throw new \Exception('操作失败!');
- }catch (\Exception $exception){
- LifeGoods::affairRollback();
- throw new \Exception($exception->getMessage(), 500);
- }
- }
- /**
- * Notes:查询商品
- * @param int $goods_id
- * @return int
- * User: ZQ
- * Date: 2022/9/13
- */
- public static function goodsInfo($goods_id)
- {
- $where = [];
- $where['goods_id'] = $goods_id;
- $where['goods_is_del'] = 0;
- $result = LifeGoods::where($where)
- ->leftJoin('merchant_shop','shop_id','=','life_market_goods.goods_shop_id')
- ->leftJoin('category','category_id','=','life_market_goods.goods_category_id')
- ->first(['life_market_goods.*','merchant_shop.shop_name','category.category_name']);
- if (!empty($result)){
- $result['goods_slide'] = explode(',',$result['goods_slide']);
- $result['goods_create_time'] = date('Y-m-d H:i:s',$result['goods_create_time']);
- if (!empty($result['goods_update_time'])){
- $result['goods_update_time'] = date('Y-m-d H:i:s',$result['goods_update_time']);
- }
- }
- return $result;
- }
- /**
- * Notes:修改商品状态
- * @param string $goods_name
- * @param int $goods_status
- * @return int
- * User: ZQ
- * Date: 2022/9/15
- */
- public static function updateStatus($goods_id, $goods_status)
- {
- LifeGoods::affairBegin();
- try {
- $where = [];
- $where['goods_id'] = $goods_id;
- $data = [];
- $data['goods_status'] = $goods_status;
- $result = LifeGoods::where($where)->update($data);
- if ($result !== false){
- LifeGoods::affairCommit();
- return true;
- }
- throw new \Exception('操作失败!');
- }catch (\Exception $exception){
- LifeGoods::affairRollback();
- throw new \Exception($exception->getMessage(), 500);
- }
- }
- }
|