jbangjia/app/admin/controller/TuanzhangincomelogController.php

<?php

namespace app\admin\controller;

use think\exception\ValidateException;
use think\facade\Db;
use app\model\OrderGoods;

class TuanzhangincomelogController extends Base
{

	/*
 	* @Description  数据列表
 	*/
	function index()
	{
		$keyword = input('post.keyword', '', 'serach_in');
		$create_time = input('post.create_time', '', 'serach_in');

		$where = [];
		$where['weid'] = weid();
		$query = Db::name('tuanzhang_incomelog')
			->alias('ti')
			->join('order', 'ti.order_id = order.id')
			->join('member', 'ti.buyer_id = member.id')
			->join('tuanzhang', 'ti.uuid = tuanzhang.uuid')
			->field('ti.*, order.is_times, order.timesdate, order.timestype, order.begin_time, order.end_time
			,order.is_times,member.nickname,tuanzhang.title');

		if (!empty($keyword)) {
			$query->where('ti.order_num_alias|member.nickname|tuanzhang.title', 'like', '%' . $keyword . '%');
		}

		if (!empty($create_time)) {
			$query->where('ti.create_time', 'between', [strtotime($create_time[0]), strtotime($create_time[1])]);
		}
		$res = $query->order('ti.id desc')->paginate(getpage())->toArray();

		foreach ($res['data'] as &$vo) {
			if ($vo['is_times'] == 1) {
				if ($vo['timesdate']) {
					if ($vo['timestype'] == 1) {
						$vo['yue_time'] = '每月:' . $vo['timesdate'] . '号';
					} else {
						$vo['yue_time'] = '每周周:' . $vo['timesdate'];
					}
				} else {
					$vo['yue_time'] = '还没有预约时间';
				}
			} else {
				$vo['yue_time'] = time_format($vo['begin_time']) . ' 到 ' . date('H:i', $vo['end_time']);
			}

			$vo['orderGoods'] = OrderGoods::where('order_id', $vo['order_id'])->select();
		}

		$data['data'] = $res;
		return $this->json($data);
	}
}