FoodCartListForm.php 10 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239
  1. <?php
  2. /**
  3. * 重庆赤晓店信息科技有限公司
  4. * https://www.chixiaodian.com
  5. * Copyright (c) 2023 赤店商城 All rights reserved.
  6. */
  7. namespace app\modules\alliance\models;
  8. use app\models\Attr;
  9. use app\models\AttrGroup;
  10. use app\models\common\CommonGoods;
  11. use app\models\FoodCart;
  12. use app\models\FoodFlag;
  13. use app\models\Goods;
  14. use app\models\Md;
  15. use app\models\SaasUser;
  16. use app\models\Store;
  17. use app\models\User;
  18. use yii\base\Model;
  19. use yii\data\Pagination;
  20. class FoodCartListForm extends Model
  21. {
  22. public $store_id;
  23. public $user_id;
  24. public $page;
  25. public $limit;
  26. public $list;
  27. public $flag_id;
  28. public $table_num;
  29. public function rules()
  30. {
  31. return [
  32. [['page', 'limit', 'flag_id', 'table_num'], 'integer'],
  33. [['page',], 'default', 'value' => 1],
  34. [['limit',], 'default', 'value' => 1000],
  35. ];
  36. }
  37. public function search()
  38. {
  39. $food_flag = FoodFlag::findOne($this->flag_id);
  40. if (empty($food_flag) && !empty($this->table_num)) {
  41. $table_num = $this->table_num;
  42. $food_flag = FoodFlag::findOne(['store_id' => get_store_id(), 'md_id' => 0, 'table_num' => $table_num, 'status' => 0, 'type' => 1]);
  43. }
  44. $flag_id = $food_flag->id;
  45. $md_name = isset(Store::findOne(get_store_id())->name) ? Store::findOne(get_store_id())->name : '';
  46. $saas_user = get_saas_user();
  47. if ($food_flag->status == 1) {
  48. return [
  49. 'code' => 0,
  50. 'msg' => 'success',
  51. 'data' => [
  52. 'total_price' => 0,
  53. 'num' => 0,
  54. 'list' => [],
  55. 'user_id' => FoodFlag::findOne($flag_id)->user_id,
  56. 'saas_id' =>$saas_user->id,
  57. 'md_name' => $md_name
  58. ],
  59. ];
  60. }
  61. $query = FoodCart::find()->where(['flag_id' => $flag_id, 'is_delete' => 0]);
  62. $query->andWhere([
  63. 'or',
  64. [
  65. 'status' => 1
  66. ]
  67. ]);
  68. $count = $query->count();
  69. $pagination = new Pagination(['totalCount' => $count, 'page' => $this->page - 1, 'pageSize' => 10000,]);
  70. /* @var FoodCart[] $list */
  71. $list = $query->orderBy('goods_id DESC')->limit($pagination->limit)->offset($pagination->offset)->all();
  72. $total_price = 0;
  73. $user_list = [];
  74. $num = 0;
  75. if (!empty($list)) {
  76. $saas_ids = array_unique(array_column($list, 'saas_id'));
  77. foreach ($saas_ids as $saas_id) {
  78. $goods_list = [];
  79. foreach ($list as $item) {
  80. if ($item->saas_id == $saas_id) {
  81. $goods = Goods::findOne([
  82. 'id' => $item->goods_id,
  83. 'is_delete' => 0,
  84. 'status' => 1,
  85. ]);
  86. if (!$goods) {
  87. continue;
  88. }
  89. $num += $item->num;
  90. $attr_list = Attr::find()->alias('a')
  91. ->select('ag.attr_group_name,a.attr_name,a.attr_group_id,a.id')
  92. ->leftJoin(['ag' => AttrGroup::tableName()], 'a.attr_group_id=ag.id')
  93. ->where(['a.id' => json_decode($item->attr, true)])
  94. ->asArray()->all();
  95. $attr = $goods->attr;
  96. $price = $goods->price;
  97. $status = $goods->status;
  98. $goodsData = [
  99. 'attr' => $attr,
  100. 'price' => $price,
  101. 'is_level' => $goods->is_level,
  102. ];
  103. $goods_attr_info = CommonGoods::currentGoodsAttr($goodsData, (array) json_decode($item->attr, true));
  104. $attr_num = intval(empty($goods_attr_info['num']) ? 0 : $goods_attr_info['num']);
  105. $goods_pic = isset($goods_attr_info['pic']) && !empty($goods_attr_info['pic']) ? $goods->getGoodsPic(0)->pic_url : $goods->cover_pic;
  106. $price = round(empty($goods_attr_info['price']) ? $goods->price : $goods_attr_info['price'], 2);
  107. $goods_price = $price * $item->num;
  108. $total_price += $goods_price;
  109. $goods_list[] = [
  110. 'attr_group_list' => $goods->getAttrGroupList(),
  111. 'attr' => $goods->attr,
  112. 'use_attr' => $goods->use_attr,
  113. 'num' => $item->num,
  114. 'goods_num' => $goods->getNum(),
  115. 'user_id' => $item->user_id,
  116. 'cart_id' => $item->id,
  117. 'goods_id' => $goods->id,
  118. 'goods_name' => $goods->name,
  119. 'goods_pic' => $goods_pic,
  120. 'attr_list' => $attr_list,
  121. 'price' => $price,
  122. 'unitPrice' => doubleval($goods_attr_info['price']),
  123. 'max_num' => $attr_num,
  124. 'disabled' => ($item->num > $attr_num) ? true : false,
  125. 'status' => $status
  126. ];
  127. }
  128. }
  129. //$saas_user = SaasUser::findOne(['mobile' => User::findOne($user_id)->binding]);
  130. $item_saas_user = SaasUser::findOne($saas_id);
  131. $user_list[] = [
  132. 'name' => $item_saas_user->name,
  133. 'avatar' => $item_saas_user->avatar,
  134. 'user_id' =>0,
  135. 'saas_id' =>$item_saas_user->id,
  136. 'goods_list' => $goods_list
  137. ];
  138. }
  139. return [
  140. 'code' => 0,
  141. 'msg' => 'success',
  142. 'data' => [
  143. 'num' => $num,
  144. 'total_price' => $total_price,
  145. 'list' => $user_list,
  146. 'user_id' => FoodFlag::findOne($flag_id)->user_id,
  147. 'saas_id' =>$saas_user->id,
  148. 'md_name' => $md_name,
  149. 'flag_id' => $flag_id
  150. ],
  151. ];
  152. }
  153. // if (!empty($list) && $food_flag->type == 1) {
  154. // $goods_list = [];
  155. // foreach ($list as $item) {
  156. // $goods = Goods::findOne([
  157. // 'id' => $item->goods_id,
  158. // 'is_delete' => 0,
  159. // 'status' => 1,
  160. // ]);
  161. // if (!$goods) {
  162. // continue;
  163. // }
  164. // $num += $item->num;
  165. // $attr_list = Attr::find()->alias('a')
  166. // ->select('ag.attr_group_name,a.attr_name,a.attr_group_id,a.id')
  167. // ->leftJoin(['ag' => AttrGroup::tableName()], 'a.attr_group_id=ag.id')
  168. // ->where(['a.id' => json_decode($item->attr, true)])
  169. // ->asArray()->all();
  170. //
  171. // $attr = $goods->attr;
  172. // $price = $goods->price;
  173. // $status = $goods->status;
  174. // $goodsData = [
  175. // 'attr' => $attr,
  176. // 'price' => $price,
  177. // 'is_level' => $goods->is_level,
  178. // ];
  179. // $goods_attr_info = CommonGoods::currentGoodsAttr($goodsData, (array) json_decode($item->attr, true));
  180. // $attr_num = intval(empty($goods_attr_info['num']) ? 0 : $goods_attr_info['num']);
  181. // $goods_pic = isset($goods_attr_info['pic']) && !empty($goods_attr_info['pic']) ? $goods->getGoodsPic(0)->pic_url : $goods->cover_pic;
  182. // $price = round(empty($goods_attr_info['price']) ? $goods->price : $goods_attr_info['price'], 2);
  183. // $goods_price = $price * $item->num;
  184. // $total_price += $goods_price;
  185. // $goods_list['goods_list'][] = [
  186. // 'attr_group_list' => $goods->getAttrGroupList(),
  187. // 'attr' => $goods->attr,
  188. // 'use_attr' => $goods->use_attr,
  189. // 'num' => $item->num,
  190. // 'goods_num' => $goods->getNum(),
  191. // 'user_id' => $item->user_id,
  192. // 'cart_id' => $item->id,
  193. // 'goods_id' => $goods->id,
  194. // 'goods_name' => $goods->name,
  195. // 'goods_pic' => $goods_pic,
  196. // 'attr_list' => $attr_list,
  197. // 'price' => $price,
  198. // 'unitPrice' => doubleval($goods_attr_info['price']),
  199. // 'max_num' => $attr_num,
  200. // 'disabled' => ($item->num > $attr_num) ? true : false,
  201. // 'status' => $status
  202. // ];
  203. // }
  204. // if (!empty($goods_list)) {
  205. // $user_list[] = $goods_list;
  206. // }
  207. // return [
  208. // 'code' => 0,
  209. // 'msg' => 'success',
  210. // 'data' => [
  211. // 'num' => $num,
  212. // 'total_price' => $total_price,
  213. // 'list' => $user_list,
  214. // 'user_id' => FoodFlag::findOne($this->flag_id)->user_id,
  215. // 'md_name' => Md::findOne(get_md_id())->name
  216. // ],
  217. // ];
  218. // }
  219. return [
  220. 'code' => 0,
  221. 'msg' => 'success',
  222. 'data' => [
  223. 'num' => 0,
  224. 'total_price' => 0,
  225. 'list' => [],
  226. 'user_id' => FoodFlag::findOne($this->flag_id)->user_id,
  227. 'saas_id' => $saas_user->id,
  228. 'md_name' => $md_name
  229. ],
  230. ];
  231. }
  232. }