alias('fg') ->leftJoin(['fc' => FoodCat:: tableName()], 'fc.id = fg.cat_id') ->where([ 'fg.is_delete' => 0, 'fg.store_id' => get_store_id() ]); if (!empty($name)) { $query->andWhere(['like', 'fg.name', $name]); } if ($cat_id > 0) { $query->andWhere(['cat_id' => $cat_id]); } if ($status > -1) { $query->andWhere(['status' => $status]); } $query->select('fg.*, fc.name as cat_name')->orderBy(['sort' => SORT_DESC]); $list = pagination_make($query); foreach ($list['list'] as &$item) { if (!empty($item['cover_pic'])) { $item['cover_pic'] = json_decode($item['cover_pic'], true); $item['attr'] = json_decode($item['attr'], true); } if (empty($item['attr'])) { $item['attr'] = ''; } } return [ 'code' => 0, 'msg' => 'success', 'data' => [ 'data' => $list['list'], 'pageNo' => $list['pageNo'], 'totalCount' => $list['totalCount'], ], ]; } public function actionChangeStatus() { $id = post_params('id'); $type = post_params('type', 'status'); $cat = FoodGoods::findOne($id); $cat->{$type} = $cat->{$type} === 1 ? 0 : 1; if ($cat->save()) { return [ 'code' => 0, 'msg' => '修改成功' ]; } return [ 'code' => 1, 'msg' => '修改失败', ]; } public function actionDel() { $id = post_params('id'); $cat = FoodGoods::findOne($id); $cat->is_delete = 1; if ($cat->save()) { return [ 'code' => 0, 'msg' => '删除成功' ]; } return [ 'code' => 1, 'msg' => '删除失败', ]; } public function actionEdit() { try { $data = all_params(); if (empty($data['cover_pic'])) { return [ 'code' => 1, 'msg' => '请上传封面图', ]; } if ($data['id'] > 0) { $goods = FoodGoods::findOne($data['id']); if (!$goods) { return [ 'code' => 1, 'msg' => '商品不存在', ]; } } else { $goods = new FoodGoods(); } $goods->store_id = get_store_id(); $goods->name = $data['name']; $goods->subtitle = $data['subtitle']; $goods->price = $data['price']; $goods->original_price = $data['original_price']; $goods->detail = $data['detail']; $goods->cat_id = $data['cat_id']; $goods->status = (int)$data['status']; $goods->is_recommend = (int)$data['is_recommend']; $goods->sort = $data['sort']; $goods->virtual_sales = $data['virtual_sales']; $goods->cover_pic = json_encode($data['cover_pic']); if ($data['is_use_attr'] && !empty($data['attr'])) { $goods->attr = json_encode($data['attr']); } else { $goods->attr = ''; } if ($goods->save()) { // $pic = $data['cover_pic'][0]['url']; // 上传物料 // list($width, $height, $type, $attr) = getimagesize($pic); // if ($width < 750) { // $result = Image::image_resize($pic, \Yii::$app->basePath . '/runtime/image/foods.png', '750px', '600px'); // } // Todo 暂时屏蔽支付宝物料上传 // $res = AlipayProfit::file_upload($pic); // \Yii::warning(['<========= 创建商品图片物料 ==========>', $pic, $res]); // if ($res['code'] == 10000 && $res['msg'] == 'Success') { // $goods->material_id = $res['material_id']; // if (!$goods->save()) { // \Yii::warning(['<========= 创建商品图片物料入库失败 ==========>', $goods->errors]); // } // } return [ 'code' => 0, 'msg' => '保存成功' ]; } else { return [ 'code' => 1, 'error' => $goods->errors[0], 'msg' => '保存失败', ]; } } catch (\Throwable $throwable) { return [ 'code' => 1, 'msg' => '保存失败', 'error' => $throwable->getMessage(), ]; } } public function actionBatch() { try { $ids = post_params('ids', []); $action = post_params('action'); if (empty($ids) || empty($action)) { return [ 'code' => 1, 'msg' => '缺少参数', ]; } $actions = [ 'status_up', // 批量上架 'status_down', // 批量下架 'recommend', // 批量推荐 'un_recommend', // 批量取消推荐 'delete', // 批量删除 ]; if (in_array($action, $actions) === false) { return [ 'code' => 1, 'msg' => '参数不正确', ]; } if ($action == 'status_up') { } switch ($action) { case 'status_up': FoodGoods::updateAll(['status' => 1], ['id' => $ids]); break; case 'status_down': FoodGoods::updateAll(['status' => 0], ['id' => $ids]); break; case 'recommend': FoodGoods::updateAll(['is_recommend' => 1], ['id' => $ids]); break; case 'un_recommend': FoodGoods::updateAll(['is_recommend' => 0], ['id' => $ids]); break; case 'delete': FoodGoods::updateAll(['is_delete' => 1], ['id' => $ids]); break; } return [ 'code' => 0, 'msg' => '操作成功', ]; } catch (\Throwable $throwable) { return [ 'code' => 1, 'msg' => '操作失败', 'error' => $throwable->getMessage(), ]; } } public function actionNewList() { $store_id = get_store_id(); // 分类 $cats = FoodCat::find()->where(['store_id' => $store_id, 'is_delete' => 0, 'is_show' => 1])->orderBy('sort desc')->select('id, name as title, desc as subtitle, pic_url as icon')->asArray()->all(); if (empty($cats)) { return [ 'code' => 1, 'msg' => '分类未找到' ]; } foreach ($cats as $key => &$cat) { $goods_list = FoodGoods::find()->where(['store_id' => $store_id, 'cat_id' => $cat['id'], 'is_delete' => 0, 'status' => 1]) ->select('id, name, cover_pic as goods_pic, subtitle as desc, price, original_price, attr, virtual_sales as sales')->orderBy('sort desc')->asArray()->all(); if (empty($goods_list)) { // 如果当前分类下无商品,不作展示 unset($cats[$key]); continue; } foreach ($goods_list as $key => $goods) { $goods_list[$key]['goods_pic'] = Json::decode($goods['goods_pic'])[0]['url']; $goods_list[$key]['attr'] = Json::decode($goods['attr']); } $cat['list'] = $goods_list; } sort($cats); return [ 'code' => 0, 'msg' => 'success', 'data' => $cats ]; } }