125 lines
3.2 KiB
PHP
125 lines
3.2 KiB
PHP
<?php
|
|
declare(strict_types=1);
|
|
|
|
namespace app\manager\controller;
|
|
|
|
use think\admin\Controller;
|
|
use think\admin\service\AdminService;
|
|
|
|
/**
|
|
* 回传记录管理
|
|
* @auth true
|
|
* @menu true
|
|
*/
|
|
class PackageCallbackRecords extends Controller
|
|
{
|
|
/**
|
|
* 绑定数据表
|
|
* @var string
|
|
*/
|
|
protected $table = 'offer_package_callback_records';
|
|
|
|
/**
|
|
* 回传记录列表
|
|
* @auth true
|
|
* @menu true
|
|
*/
|
|
public function index()
|
|
{
|
|
$this->title = '回传记录列表';
|
|
$this->fetch();
|
|
}
|
|
|
|
/**
|
|
* 获取回传记录列表
|
|
* @auth true
|
|
*/
|
|
public function get_list()
|
|
{
|
|
try {
|
|
$page = input('page/d', 1);
|
|
$limit = input('limit/d', 15);
|
|
$where = [];
|
|
|
|
// 包名搜索
|
|
if ($package_name = input('package_name/s', '')) {
|
|
$where[] = ['package_name', 'like', "%{$package_name}%"];
|
|
}
|
|
|
|
// 事件名称搜索
|
|
if ($event_name = input('event_name/s', '')) {
|
|
$where[] = ['event_name', 'like', "%{$event_name}%"];
|
|
}
|
|
|
|
// 推送ID搜索
|
|
if ($push_record_id = input('push_record_id/d', '')) {
|
|
$where[] = ['push_record_id', '=', $push_record_id];
|
|
}
|
|
|
|
// 状态筛选
|
|
if ($status = input('status/s', '')) {
|
|
$where[] = ['status', '=', $status];
|
|
}
|
|
|
|
// 时间范围筛选
|
|
if ($start_time = input('start_time/s', '')) {
|
|
$where[] = ['callback_time', '>=', $start_time];
|
|
}
|
|
if ($end_time = input('end_time/s', '')) {
|
|
$where[] = ['callback_time', '<=', $end_time];
|
|
}
|
|
|
|
// 查询数据
|
|
$query = $this->app->db->name($this->table)
|
|
->alias('a')
|
|
->join('offer_package_push_records b', 'a.push_record_id = b.id', 'left')
|
|
->field('a.*, b.source_type');
|
|
|
|
// 获取总数
|
|
$total = $query->where($where)->count();
|
|
|
|
// 分页查询数据
|
|
$list = $query->where($where)
|
|
->order('a.id desc')
|
|
->limit(($page - 1) * $limit, $limit)
|
|
->select()
|
|
->toArray();
|
|
|
|
return json([
|
|
'code' => 0,
|
|
'msg' => '',
|
|
'count' => $total,
|
|
'data' => $list
|
|
]);
|
|
|
|
} catch (\Exception $e) {
|
|
trace("获取回传记录列表异常：" . $e->getMessage());
|
|
return json([
|
|
'code' => 1,
|
|
'msg' => '获取数据失败，请稍后重试',
|
|
'count' => 0,
|
|
'data' => []
|
|
]);
|
|
}
|
|
}
|
|
|
|
/**
|
|
* 查看详情
|
|
* @auth true
|
|
*/
|
|
public function detail()
|
|
{
|
|
$id = input('id/d', 0);
|
|
if (empty($id)) {
|
|
$this->error('参数错误');
|
|
}
|
|
|
|
$vo = $this->app->db->name($this->table)->where('id', $id)->find();
|
|
if (empty($vo)) {
|
|
$this->error('记录不存在');
|
|
}
|
|
|
|
$this->vo = $vo;
|
|
$this->fetch();
|
|
}
|
|
}
|