123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255 |
- <?php
- namespace app\admin\server\life;
- use app\admin\model\LifeFood;
- class FoodServer
- {
- /**
- * Notes:获取健康美食列表
- * @param string $keywords
- * @param int $page
- * @param int $limit
- * @return array
- * User: ZQ
- * Date: 2022/10/17
- */
- public static function getFoodList(int $page, int $limit, string $keywords)
- {
- [$list, $count] = LifeFood::getFoodList($page, $limit, $keywords);
- if (!empty($list)){
- foreach ($list as $k => $v){
- $list[$k]['food_silde'] = explode(',',$v['food_silde']);
- $list[$k]['food_materials'] = json_decode($v['food_materials'],true);
- $list[$k]['food_condiment'] = json_decode($v['food_condiment'],true);
- $list[$k]['food_create_time'] = date('Y-m-d H:i:s',$v['food_create_time']);
- if (!empty($v['food_update_time'])){
- $list[$k]['food_update_time'] = date('Y-m-d H:i:s',$v['food_update_time']);
- }
- }
- }
- return compact('list', 'page', 'limit', 'count');
- }
- /**
- * Notes:获取分类下的美食列表
- * @return int
- * User: ZQ
- * Date: 2022/10/17
- */
- public static function getFoodAll($food_category_id)
- {
- $where = [];
- $where['food_is_del'] = 0;
- $where['food_status'] = 0;
- $where['food_type'] = 1;
- if (!empty($food_category_id)){
- $where['food_category_id'] = $food_category_id;
- }
- $list = LifeFood::where($where)
- ->select(['food_id','food_name'])
- ->get()
- ->toArray();
- return $list;
- }
- /**
- * Notes:修改健康美食
- * @param string $food_name
- * @param int $food_id
- * @return int
- * User: ZQ
- * Date: 2022/10/17
- */
- public static function updateFood($food_silde, $food_shop_id, $food_storage, $food_packaging, $food_varieties, $food_attr, $food_postage_id, $food_weight, $food_id, $food_name, $food_img, $food_price, $food_category_id, $food_pack_price, $food_materials, $food_condiment, $food_type, $food_package, $food_label, $food_status, $food_content,$food_cater_time,$food_cater_type,$food_package_num, $food_week, $admin_id)
- {
- LifeFood::affairBegin();
- try {
- $where = [];
- $where['food_id'] = $food_id;
- $data = [];
- $data['food_name'] = $food_name;
- $data['food_img'] = $food_img;
- $data['food_price'] = $food_price;
- $data['food_category_id'] = $food_category_id;
- $data['food_pack_price'] = $food_pack_price;
- $data['food_materials'] = json_encode($food_materials);
- $data['food_condiment'] = json_encode($food_condiment);
- $data['food_type'] = $food_type;
- $data['food_package'] = $food_package;
- $data['food_label'] = $food_label;
- $data['food_status'] = $food_status;
- $data['food_content'] = $food_content;
- $data['food_silde'] = $food_silde;
- $data['food_shop_id'] = $food_shop_id;
- $data['food_storage'] = $food_storage;
- $data['food_packaging'] = $food_packaging;
- $data['food_varieties'] = $food_varieties;
- $data['food_attr'] = $food_attr;
- $data['food_postage_id'] = $food_postage_id;
- $data['food_weight'] = $food_weight;
- $data['food_cater_time'] = $food_cater_time;
- $data['food_cater_type'] = $food_cater_type;
- $data['food_package_num'] = $food_package_num;
- $data['food_week'] = $food_week ? implode(',',$food_week) : '';
- $data['food_update_time'] = time();
- $result = LifeFood::where($where)->update($data);
- if ($result !== false){
- $msg = '管理员:' . $admin_id . '在:' . date("Y-m-d H:i:s", time()) . '修改健康美食-编号: ' . $food_id;
- plog('life-food-update', '悦活-健康美食-修改健康美食', $msg);
- LifeFood::affairCommit();
- return true;
- }
- throw new \Exception('操作失败!');
- }catch (\Exception $exception){
- LifeFood::affairRollback();
- throw new \Exception($exception->getMessage(), 500);
- }
- }
- /**
- * Notes:删除健康美食
- * @param int $food_id
- * @return int
- * User: ZQ
- * Date: 2022/10/17
- */
- public static function delFood($food_id,$admin_id)
- {
- LifeFood::affairBegin();
- try {
- $where = [];
- $where['food_id'] = $food_id;
- $data['food_is_del'] = 1;
- $result = LifeFood::where($where)->update($data);
- if (!empty($result)){
- $msg = '管理员:' . $admin_id . '在:' . date("Y-m-d H:i:s", time()) . '删除健康美食-编号: ' . $food_id;
- plog('life-food-delete', '悦活-健康美食-删除健康美食', $msg);
- LifeFood::affairCommit();
- return true;
- }else{
- return false;
- }
- }catch (\Exception $exception){
- LifeFood::affairRollback();
- throw new \Exception($exception->getMessage(), 500);
- }
- }
- /**
- * Notes: 添加健康美食
- * @param string $food_name
- * @param array $food_rules
- * @return int
- * User: ZQ
- * Date: 2022/10/17
- */
- public static function insertFood($food_silde, $food_shop_id, $food_storage, $food_packaging, $food_varieties, $food_attr, $food_postage_id, $food_weight, $food_name, $food_img, $food_price, $food_category_id, $food_pack_price, $food_materials, $food_condiment, $food_type, $food_package, $food_label, $food_status, $food_content,$food_cater_time,$food_cater_type,$food_package_num, $food_week, $admin_id)
- {
- LifeFood::affairBegin();
- try {
- $data = [];
- $data['food_name'] = $food_name;
- $data['food_img'] = $food_img;
- $data['food_price'] = $food_price;
- $data['food_category_id'] = $food_category_id;
- $data['food_pack_price'] = $food_pack_price;
- $data['food_materials'] = json_encode($food_materials);
- $data['food_condiment'] = json_encode($food_condiment);
- $data['food_type'] = $food_type;
- $data['food_package'] = $food_package;
- $data['food_label'] = $food_label;
- $data['food_status'] = $food_status;
- $data['food_content'] = $food_content;
- $data['food_silde'] = $food_silde;
- $data['food_shop_id'] = $food_shop_id;
- $data['food_storage'] = $food_storage;
- $data['food_packaging'] = $food_packaging;
- $data['food_varieties'] = $food_varieties;
- $data['food_attr'] = $food_attr;
- $data['food_postage_id'] = $food_postage_id;
- $data['food_weight'] = $food_weight;
- $data['food_cater_time'] = $food_cater_time;
- $data['food_cater_type'] = $food_cater_type;
- $data['food_package_num'] = $food_package_num;
- $data['food_week'] = $food_week ? implode(',',$food_week) : '';
- $data['food_create_time'] = time();
- $result = LifeFood::insertGetId($data);
- if (!empty($result)){
- $msg = '管理员:' . $admin_id . '在:' . date("Y-m-d H:i:s", time()) . '添加健康美食-编号: ' . $result;
- plog('life-food-create', '悦活-健康美食-添加健康美食', $msg);
- LifeFood::affairCommit();
- return $result;
- }
- throw new \Exception('操作失败!');
- }catch (\Exception $exception){
- LifeFood::affairRollback();
- throw new \Exception($exception->getMessage(), 500);
- }
- }
- /**
- * Notes:查询健康美食
- * @param int $food_id
- * @return int
- * User: ZQ
- * Date: 2022/10/17
- */
- public static function foodInfo($food_id)
- {
- $where = [];
- $where['food_id'] = $food_id;
- $result = LifeFood::where($where)
- ->leftJoin('category','category_id','=','life_healthy_food.food_category_id')
- ->first(['life_healthy_food.*','category.category_name']);
- if (!empty($result)){
- $food_package= explode(',',$result['food_package']);
- if (!empty($food_package)){
- for ($i=0;$i<count($food_package);$i++){
- $intval[] = (int)$food_package[$i];
- }
- $result['food_package'] = $intval;
- }
- $result['food_materials'] = json_decode($result['food_materials'],true);
- $result['food_condiment'] = json_decode($result['food_condiment'],true);
- $result['food_create_time'] = date('Y-m-d H:i:s',$result['food_create_time']);
- $result['food_silde'] = explode(',',$result['food_silde']);
- $result['food_week'] = explode(',',$result['food_week']);
- if (!empty($result['food_update_time'])){
- $result['food_update_time'] = date('Y-m-d H:i:s',$result['food_update_time']);
- }
- }
- return $result;
- }
- /**
- * Notes:修改健康美食状态
- * @param string $food_name
- * @param int $food_status
- * @return int
- * User: ZQ
- * Date: 2022/9/15
- */
- public static function updateStatus($food_id, $food_status)
- {
- LifeFood::affairBegin();
- try {
- $where = [];
- $where['food_id'] = $food_id;
- $data = [];
- $data['food_status'] = $food_status;
- $result = LifeFood::where($where)->update($data);
- if ($result !== false){
- LifeFood::affairCommit();
- return true;
- }
- throw new \Exception('操作失败!');
- }catch (\Exception $exception){
- LifeFood::affairRollback();
- throw new \Exception($exception->getMessage(), 500);
- }
- }
- }
|