44 lines
1.5 KiB
PHP
44 lines
1.5 KiB
PHP
<?php
|
|
|
|
namespace App\Http\Controllers;
|
|
|
|
use App\Exports\MintExport;
|
|
use App\Models\MintModel;
|
|
use Illuminate\Http\Request;
|
|
use Illuminate\Database\Eloquent\Builder;
|
|
use Maatwebsite\Excel\Facades\Excel;
|
|
|
|
class MintController extends Controller
|
|
{
|
|
|
|
public function index(Request $request)
|
|
{
|
|
$size = $request->get('size', 10);
|
|
$map = function (Builder $builder) use ($request) {
|
|
|
|
if ($request->input('status') == 1){
|
|
$builder->where('suspend', 1);
|
|
}else if ($request->input('status') == 2){
|
|
$builder->where('done', 1);
|
|
}else if ($request->input('status') == 3){
|
|
$builder->where('ignore', 1);
|
|
}
|
|
|
|
if ($request->has('account')&& ! empty($request->input('account'))){
|
|
$builder->where('account', $request->input('account'));
|
|
}
|
|
if ($request->has('unikey')&& ! empty($request->input('unikey'))){
|
|
$builder->where('unikey', $request->input('unikey'));
|
|
}
|
|
if($request->has('time')&& ! empty($request->input('time')[0] && !empty($request->input('time')[1]))){
|
|
$start = strtotime($request->input('time')[0]);
|
|
$end = strtotime($request->input('time')[1]);
|
|
$builder->whereBetween('createtime',[$start,$end]);
|
|
}
|
|
|
|
};
|
|
$data = MintModel::where($map)->orderBy('idx','desc')->paginate($size)->toArray();
|
|
return $this->success($data);
|
|
}
|
|
}
|