📖 File Reader
<?php
namespace app\api\controller;
use app\BaseController;
use app\common\Common_time;
use app\api\common\Common_user;
use think\facade\Db;
use think\facade\View;
class Merchant extends Base
{
/*我的商户*/
public function merchant_list()
{
$time_info = Common_time::time_info();
$time_yc = strtotime(date("Y-m-1 00:00:00",time()));
$keyword = input("param.keyword");
$type_dabiao = input("param.type_dabiao");
$where = 1;
if (!empty($keyword)){
$where .= " and (b.name like '%".$keyword."%' or b.mobile = '$keyword')";
}
if ($type_dabiao != ''){
$where .= " and a.is_dabiao = $type_dabiao";
}
//我的机具
$machine = db::name("machine")->alias("a")
->join("user b","a.user_id = b.user_id","LEFT")
->field("a.id,a.user_id,a.number,a.is_dabiao,a.add_time,b.name,b.mobile")
->where("(a.user_id = $this->user_id or a.buy_user_id = $this->user_id) and a.is_binding = 1 and a.is_activate = 1 and ".$where)
->order("a.id desc")
->page($this->page,$this->limit)
->select();
$machine = json_decode($machine,true);
foreach ($machine as $k => $v){
//刷卡金额
if ($v["is_dabiao"] == 1){
$machine[$k]["dabiao"] = '达标';
}else{
$machine[$k]["dabiao"] = '未达标';
}
//获取上个月交易额度
$money_sy = db::name("api_data")->where("sn = '$v[number]' and time_tj >= $time_info[b_time] and time_tj <= $time_info[e_time] and dabao = '达标'")->sum("money");
//获取本月交易额度
$money_by = db::name("api_data")->where("sn = '$v[number]' and time_tj >= $time_yc and dabao = '达标'")->sum("money");
//累计交易
$money_lj = db::name("api_data")->where("sn = '$v[number]' and dabao = '达标'")->sum("money");
//开户日期
$machine_time = date("Y-m-d H:i",$v["add_time"]);
$machine[$k]["money_sy"] = $money_sy;
$machine[$k]["money_by"] = $money_by;
$machine[$k]["money_lj"] = $money_lj;
$machine[$k]["machine_time"] = $machine_time;
}
$data = [
'machine'=>$machine,
];
return $this->succeed_json("ok",$data);
}
/*商户详情*/
public function merchant_info()
{
$sn = input("param.sn");
if (empty($sn)){
return $this->error_json("参数错误");
}
//我的机具
$machine = db::name("machine")->alias("a")
->join("user b","a.user_id = b.user_id","LEFT")
->field("a.id,a.number,a.add_time,b.name,b.mobile")
->where("a.number = '$sn'")
->find();
//累计交易
$money_lj = db::name("api_data")->where("sn = '$machine[number]'")->sum("money");
//累计交易数量
$count_lj = db::name("api_data")->where("sn = '$machine[number]'")->count();
//开户日期
$machine_time = date("Y-m-d H:i",$machine["add_time"]);
/*统计数据（交易额）*/
$week_q7 = Common_time::week();//前七天的时间
//七天日期
$zhouqi_q7 = date("m/d",$week_q7["stime7_timestamp"]).','.date("m/d",$week_q7["stime6_timestamp"]).','.date("m/d",$week_q7["stime5_timestamp"]).','.date("m/d",$week_q7["stime4_timestamp"]).','.date("m/d",$week_q7["stime3_timestamp"]).','.date("m/d",$week_q7["stime2_timestamp"]).','.date("m/d",$week_q7["stime1_timestamp"]);
//七天团队全部交易额度
$tuandui_zhou_money7 = Common_user::tuandui_deal($this->user_id,$week_q7["stime7_timestamp"],$week_q7["stime6_timestamp"],1);
$tuandui_zhou_money6 = Common_user::tuandui_deal($this->user_id,$week_q7["stime6_timestamp"],$week_q7["stime5_timestamp"],1);
$tuandui_zhou_money5 = Common_user::tuandui_deal($this->user_id,$week_q7["stime5_timestamp"],$week_q7["stime4_timestamp"],1);
$tuandui_zhou_money4 = Common_user::tuandui_deal($this->user_id,$week_q7["stime4_timestamp"],$week_q7["stime3_timestamp"],1);
$tuandui_zhou_money3 = Common_user::tuandui_deal($this->user_id,$week_q7["stime3_timestamp"],$week_q7["stime2_timestamp"],1);
$tuandui_zhou_money2 = Common_user::tuandui_deal($this->user_id,$week_q7["stime2_timestamp"],$week_q7["stime1_timestamp"],1);
$tuandui_zhou_money1 = Common_user::tuandui_deal($this->user_id,$week_q7["stime1_timestamp"],$week_q7["stime0_timestamp"],1);
$zhouqi_q7_data = $tuandui_zhou_money7.','.$tuandui_zhou_money6.','.$tuandui_zhou_money5.','.$tuandui_zhou_money4.','.$tuandui_zhou_money3.','.$tuandui_zhou_money2.','.$tuandui_zhou_money1;
$nian_q6 = Common_time::month();//前6个月时间
//前6个月日期
$yuefen_q6 = date("Y/m",$nian_q6["begin_time6_timestamp"]).','.date("Y/m",$nian_q6["begin_time5_timestamp"]).','.date("Y/m",$nian_q6["begin_time4_timestamp"]).','.date("Y/m",$nian_q6["begin_time3_timestamp"]).','.date("Y/m",$nian_q6["begin_time2_timestamp"]).','.date("Y/m",$nian_q6["begin_time1_timestamp"]);
//前6个月团队交易额度
$tuandui_yue_money6 = Common_user::tuandui_deal($this->user_id,$nian_q6["begin_time6_timestamp"],$nian_q6["begin_time5_timestamp"],1);
$tuandui_yue_money5 = Common_user::tuandui_deal($this->user_id,$nian_q6["begin_time5_timestamp"],$nian_q6["begin_time4_timestamp"],1);
$tuandui_yue_money4 = Common_user::tuandui_deal($this->user_id,$nian_q6["begin_time4_timestamp"],$nian_q6["begin_time3_timestamp"],1);
$tuandui_yue_money3 = Common_user::tuandui_deal($this->user_id,$nian_q6["begin_time3_timestamp"],$nian_q6["begin_time2_timestamp"],1);
$tuandui_yue_money2 = Common_user::tuandui_deal($this->user_id,$nian_q6["begin_time2_timestamp"],$nian_q6["begin_time1_timestamp"],1);
$tuandui_yue_money1 = Common_user::tuandui_deal($this->user_id,$nian_q6["begin_time1_timestamp"],$nian_q6["begin_time0_timestamp"],1);
$yuefen_q6_data = $tuandui_yue_money6.','.$tuandui_yue_money5.','.$tuandui_yue_money4.','.$tuandui_yue_money3.','.$tuandui_yue_money2.','.$tuandui_yue_money1;
$data = [
'machine'=>$machine,
'money_lj'=>$money_lj,
'count_lj'=>$count_lj,
'machine_time'=>$machine_time,
'zhouqi_q7'=>$zhouqi_q7,
'zhouqi_q7_data'=>$zhouqi_q7_data,
'yuefen_q6'=>$yuefen_q6,
'yuefen_q6_data'=>$yuefen_q6_data,
];
return $this->succeed_json("ok",$data);
}
}