Viewing file:  MessageReportController.php (2.51 KB) -rw-r--r--
Select action/file-type:
 (+) |  (+) |  (+) | Code (+) | Session (+) |  (+) | SDB (+) |  (+) |  (+) |  (+) |  (+) |  (+) |
<?php
namespace App\Http\Controllers\Admin;
use App\Http\Controllers\Controller;
use App\Models\Customer;
use App\Models\MessageReport;
use App\Models\Report;
use Carbon\Carbon;
use Illuminate\Http\Request;
class MessageReportController extends Controller
{
public function report(Request $request){
$data['request_data']=$request->only('customer_id','main_type','sub_type','date');
$data['customers']=Customer::orderByDesc('created_at')->get();
return view('admin.report.message_report', $data);
}
public function getAllReports(Request $request){
$reports = MessageReport::orderByDesc('created_at');
if($request->destination){
$reports = $reports->where('sent_type', $request->destination);
}
if($request->type){
if($request->type=='sms'){
$type='SMS';
}else if($request->type=='whatsapp'){
$type='Whatsapp';
}else if($request->type=='mms'){
$type='MMS';
}else if($request->type=='voicecall'){
$type='Voice SMS';
}
}
if($request->date){
$dates= explode('-', $request->date);
$fromDate= isset($dates[0])?$dates[0]:Carbon::now()->subDays(3);
$toDate= isset($dates[1])?$dates[1]:Carbon::now();
$reports = $reports->whereBetween('created_at',[$fromDate, $toDate]);
}
return datatables()->of($reports)
->addColumn('profile', function ($q) {
$profile='<div><h6 class="d-block">'.$q->customer->full_name.'</h6><b>'.$q->customer->email.'</b></div>';
return $profile;
})
->addColumn('details', function ($q) {
$type='';
if($q->type=='sms'){
$type='SMS';
}else if($q->type=='whatsapp'){
$type='Whatsapp';
}else if($q->type=='mms'){
$type='MMS';
}else if($q->type=='voicecall'){
$type='Voice SMS';
}
$type='<h6>Type:'.$type.'</h6>';
$destination='<h6>Destination:'.ucfirst($q->sent_type).'</h6>';
$date='<h6>Date:'.formatDate($q->created_at).'</h6>';
return '<div>'.$type.$destination.$date.'</div>';
})
->rawColumns(['profile','details'])
->toJson();
}
}
|