service = $services; } public function jhPriceTrend(Request $request){ $list = Db::name('sys_func_log')->where('type', 1)->order('id desc')->field('money,create_at,free_day')->page(1, 30)->select()->toArray(); return api_succ_return(['msg'=>'成功', 'data'=>$list]); } public function jhPriceTrendList(Request $request){ $post = $request->post(); $page = $post['page']; $list = Db::name('sys_func_log')->where('type', 1)->order('id asc')->field('id,money,create_at,free_day')->page($page, $post['limit'])->select()->toArray(); $min_id = Db::name('sys_func_log')->where('type', 1)->min('id'); try { foreach ($list as $key=>&$val){ if ($page == 1){ if ($key == 0){ $val['tips'] = '--'; $val['text_color'] = '#959595'; }else{ if ($list[$key-1]['money'] == $val['money']){ $val['tips'] = '持平'; $val['text_color'] = '#959595'; }elseif ($list[$key-1]['money'] > $val['money']){ $val['tips'] = '下降'; $val['text_color'] = '#4DBFA3'; }else{ $val['tips'] = '增长'; $val['text_color'] = '#F76363'; } } }else{ if ($key == 0){ $max_id = Db::name('sys_func_log')->where('type', 1)->where('id', '<', $val['id'])->max('id'); $info = Db::name('sys_func_log')->where('type', 1)->where('id', $max_id)->find(); if ($info['money'] == $val['money']){ $val['tips'] = '持平'; $val['text_color'] = '#959595'; }elseif ($info['money'] > $val['money']){ $val['tips'] = '下降'; $val['text_color'] = '#4DBFA3'; }else{ $val['tips'] = '增长'; $val['text_color'] = '#F76363'; } }else{ if ($list[$key-1]['money'] == $val['money']){ $val['tips'] = '持平'; $val['text_color'] = '#959595'; }elseif ($list[$key-1]['money'] > $val['money']){ $val['tips'] = '下降'; $val['text_color'] = '#4DBFA3'; }else{ $val['tips'] = '增长'; $val['text_color'] = '#F76363'; } } } } }catch (Exception $e){ return $e->getMessage(); } return api_succ_return(['msg'=>'成功', 'data'=>$list]); } public function jhBuyMsg(Request $request){ $list = Db::name('tz_log') ->alias('l') ->where('l.type', 1) ->leftJoin('user u', 'u.id = l.uid') ->withAttr('create_at', function ($val, $data){ return sr_getcurtime(strtotime($val), 'Y年m月d日H').'点'; }) ->field('l.id,l.uid,l.create_at,l.score,u.nickname') ->select() ->toArray(); return api_succ_return(['msg'=>'成功', 'data'=>$list]); } }