123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206 |
- <?php
- namespace app\admin\server\raise;
- use app\admin\model\RaiseOldGoods;
- class RaiseOldGoodsServer
- {
- /**
- * Notes:获取养老产品列表
- * @param string $keywords
- * @param int $page
- * @param int $limit
- * @return array
- * User: ZQ
- * Date: 2022/10/31
- */
- public static function getGoodsList(int $page, int $limit, string $keywords)
- {
- [$list, $count] = RaiseOldGoods::getGoodsList($page, $limit, $keywords);
- if (!empty($list)){
- foreach ($list as $k => $v){
- $list[$k]['goods_add_time'] = date('Y-m-d H:i:s',$v['goods_add_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/10/31
- */
- public static function updateGoods($goods_id, $goods_name, $goods_title, $goods_time, $goods_category_id, $goods_banner, $goods_label, $goods_status, $goods_service_population, $goods_service_consumables, $goods_service_qualifications, $goods_service_explain, $goods_service_standard, $goods_service_process, $goods_technological, $goods_tips, $goods_shop_id, $goods_price, $admin_id)
- {
- RaiseOldGoods::affairBegin();
- try {
- $where = [];
- $where['goods_id'] = $goods_id;
- $data = [];
- $data['goods_name'] = $goods_name;
- $data['goods_title'] = $goods_title;
- $data['goods_time'] = $goods_time;
- $data['goods_category_id'] = $goods_category_id;
- $data['goods_banner'] = $goods_banner;
- $data['goods_label'] = $goods_label;
- $data['goods_service_population'] = $goods_service_population;
- $data['goods_service_consumables'] = $goods_service_consumables;
- $data['goods_service_qualifications'] = $goods_service_qualifications;
- $data['goods_service_explain'] = $goods_service_explain;
- $data['goods_service_standard'] = $goods_service_standard;
- $data['goods_service_process'] = $goods_service_process;
- $data['goods_technological'] = $goods_technological;
- $data['goods_tips'] = $goods_tips;
- $data['goods_status'] = $goods_status;
- $data['goods_price'] = $goods_price;
- $data['goods_shop_id'] = $goods_shop_id;
- $data['goods_update_time'] = time();
- $result = RaiseOldGoods::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);
- RaiseOldGoods::affairCommit();
- return true;
- }
- throw new \Exception('操作失败!');
- }catch (\Exception $exception){
- RaiseOldGoods::affairRollback();
- throw new \Exception($exception->getMessage(), 500);
- }
- }
- /**
- * Notes:删除养老产品
- * @param int $goods_id
- * @return int
- * User: ZQ
- * Date: 2022/10/31
- */
- public static function delGoods($goods_id,$admin_id)
- {
- RaiseOldGoods::affairBegin();
- try {
- $where = [];
- $where['goods_id'] = $goods_id;
- $data['goods_del'] = 1;
- $result = RaiseOldGoods::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);
- RaiseOldGoods::affairCommit();
- return true;
- }else{
- return false;
- }
- }catch (\Exception $exception){
- RaiseOldGoods::affairRollback();
- throw new \Exception($exception->getMessage(), 500);
- }
- }
- /**
- * Notes: 添加养老产品
- * @param string $goods_name
- * @param array $goods_rules
- * @return int
- * User: ZQ
- * Date: 2022/10/31
- */
- public static function insertGoods($goods_name, $goods_title, $goods_time, $goods_category_id, $goods_banner, $goods_label, $goods_status, $goods_service_population, $goods_service_consumables, $goods_service_qualifications, $goods_service_explain, $goods_service_standard, $goods_service_process, $goods_technological, $goods_tips, $goods_shop_id, $goods_price, $admin_id)
- {
- RaiseOldGoods::affairBegin();
- try {
- $data = [];
- $data['goods_name'] = $goods_name;
- $data['goods_title'] = $goods_title;
- $data['goods_time'] = $goods_time;
- $data['goods_category_id'] = $goods_category_id;
- $data['goods_banner'] = $goods_banner;
- $data['goods_label'] = $goods_label;
- $data['goods_service_population'] = $goods_service_population;
- $data['goods_service_consumables'] = $goods_service_consumables;
- $data['goods_service_qualifications'] = $goods_service_qualifications;
- $data['goods_service_explain'] = $goods_service_explain;
- $data['goods_service_standard'] = $goods_service_standard;
- $data['goods_service_process'] = $goods_service_process;
- $data['goods_technological'] = $goods_technological;
- $data['goods_tips'] = $goods_tips;
- $data['goods_status'] = $goods_status;
- $data['goods_price'] = $goods_price;
- $data['goods_shop_id'] = $goods_shop_id;
- $data['goods_add_time'] = time();
- $result = RaiseOldGoods::insertGetId($data);
- if (!empty($result)){
- $msg = '管理员:' . $admin_id . '在:' . date("Y-m-d H:i:s", time()) . '添加万悦养老产品-编号: ' . $result;
- plog('life-goods-create', '养老服务-养老产品-添加养老产品', $msg);
- RaiseOldGoods::affairCommit();
- return $result;
- }
- throw new \Exception('操作失败!');
- }catch (\Exception $exception){
- RaiseOldGoods::affairRollback();
- throw new \Exception($exception->getMessage(), 500);
- }
- }
- /**
- * Notes:查询养老产品
- * @param int $goods_id
- * @return int
- * User: ZQ
- * Date: 2022/10/31
- */
- public static function goodsInfo($goods_id)
- {
- $where = [];
- $where['goods_id'] = $goods_id;
- $result = RaiseOldGoods::where($where)
- ->leftJoin('category','category_id','=','raise_old_goods.goods_category_id')
- ->leftJoin('merchant_shop','shop_id','=','raise_old_goods.goods_shop_id')
- ->first(['raise_old_goods.*','category.category_name','merchant_shop.shop_name']);
- if (!empty($result)){
- $result['goods_add_time'] = date('Y-m-d H:i:s',$result['goods_add_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)
- {
- RaiseOldGoods::affairBegin();
- try {
- $where = [];
- $where['goods_id'] = $goods_id;
- $data = [];
- $data['goods_status'] = $goods_status;
- $result = RaiseOldGoods::where($where)->update($data);
- if ($result !== false){
- RaiseOldGoods::affairCommit();
- return true;
- }
- throw new \Exception('操作失败!');
- }catch (\Exception $exception){
- RaiseOldGoods::affairRollback();
- throw new \Exception($exception->getMessage(), 500);
- }
- }
- }
|