后台处理
控制器:
public function detail(Request $request)
{
$startime = $request['startTime'];
$stoptime = $request['stopTime'];
// dd($stoptime,$startime);
$data = Order::with('trands')->where('uid', $request->uid);
// dd($data);
if (empty($startime) && empty($stoptime)) {
$data = $data->select();
}
if (!empty($startime) && !empty($stoptime)) {
$data = $data->where('time', 'between', [$startime, $stoptime])->select();
}
if (!empty($stoptime) && empty($stoptime)) {
$data = $data->where('time', '>=', $startime)->select();
}
if (empty($stoptime) && !empty($stoptime)) {
$data = $data->where('time', '<=', $stoptime)->select();
}
return json(['code' => 200, 'data' => $data, 'msg' => 'ok']);
// dd($data->toArray());
}
模型层
public function trands()
{
return $this->hasOne('Trands','id','uid');
}
前端小程序
wxml页面
<view class="section">
<picker mode="date" value="{{startTime}}" start="2019-09-01" end="2022-09-01" bindchange="startTimeChange">
<view class="picker">
开始日期: {{startTime}}
</view>
</picker>
</view>
<view class="section">
<picker mode="date" value="{{stopTime}}" start="2019-09-01" end="2022-09-01" bindchange="stopTimeChange">
<view class="picker">
结束日期: {{stopTime}}
</view>
</picker>
</view>
<button bindtap="show">搜索</button>
<block wx:for="{{detailList}}">
<view style="height: 80px;">
转账<text>{{item.user.nikcname}}</text>
<text>{{item.pice}}元</text>
<view>{{item.time}}</view>
<view wx:if="{{item.state==1}}">待支付</view>
<view wx:if="{{item.state==2}}">转账成功</view>
</view>
</block>
js页面
Page({
/**
* 页面的初始数据
*/
data: {
detailList:[],
startTime:'',
stopTime:''
},
startTimeChange(e){
console.log(e);
this.setData({
startTime:e.detail.value
})
},
stopTimeChange(e){
console.log(e);
this.setData({
stopTime:e.detail.value
})
},
show(e){
wx.request({
url: 'http://www.t.com/index.php/admin/detail',
data:{
startime:this.data.startTime,
stoptime:this.data.stopTime
},
header:{
token:wx.getStorageSync('token')
},
success:ret=>{
console.log(ret.data.data);
this.setData({
detailList:ret.data.data
})
}
})
},
/**
* 生命周期函数--监听页面加载
*/
onLoad: function (options) {
},
/**
* 生命周期函数--监听页面初次渲染完成
*/
onReady: function () {
},
/**
* 生命周期函数--监听页面显示
*/
onShow: function () {
},
/**
* 生命周期函数--监听页面隐藏
*/
onHide: function () {
},
/**
* 生命周期函数--监听页面卸载
*/
onUnload: function () {
},
/**
* 页面相关事件处理函数--监听用户下拉动作
*/
onPullDownRefresh: function () {
},
/**
* 页面上拉触底事件的处理函数
*/
onReachBottom: function () {
},
/**
* 用户点击右上角分享
*/
onShareAppMessage: function () {
}
})