Viewing file:  ReportController.php (3.86 KB) -rw-r--r--
Select action/file-type:
 (+) |  (+) |  (+) | Code (+) | Session (+) |  (+) | SDB (+) |  (+) |  (+) |  (+) |  (+) |  (+) |
<?php
namespace App\Http\Controllers\Customer;
use App\Http\Controllers\Controller;
use Illuminate\Http\Request;
class ReportController extends Controller
{
public function index(){
return view('customer.report.transaction');
}
public function gateData(){
$transactions = auth('customer')->user()->customer_plans()->select(['id','customer_id','plan_id','transaction_id','price','payment_method','created_at','status']);
return datatables()->of($transactions)
->addColumn('plan', function ($q) {
return $q->plan->title;
})
->addColumn('payment_method', function ($q) {
return ucfirst($q->payment_method);
})
->addColumn('price', function ($q) {
return formatNumberWithCurrSymbol($q->price);
})
->addColumn('created_at', function ($q) {
return formatDate($q->created_at);
})
->addColumn('status', function ($q) {
if($q->status=='approved'){
$status='<span class="badge bg-green">Approved</span>';
}elseif ($q->status=='pending'){
$status='<span class="badge bg-primary">Pending</span>';
}else{
$status='<span class="badge bg-danger">Rejected</span>';
}
return $status;
})
->addColumn('action',function($q){
return '<a class="btn btn-sm btn-danger" data-message="Are you sure you want to delete this document?"
data-action='.route('customer.ai.content.delete',['id'=>$q->id,'type'=>'document']).'
data-input={"_method":"delete"}
data-toggle="modal" data-target="#modal-confirm">Delete</a>' ;
})
->rawColumns(['action','status'])
->toJson();
}
public function planIndex(){
return view('customer.report.plan');
}
public function PlanGateData(){
$transactions = auth('customer')->user()->customer_plans()->select(['id','customer_id','plan_id','start_date','expired_date','price','payment_method','status']);
return datatables()->of($transactions)
->addColumn('plan', function ($q) {
return $q->plan->title;
})
->addColumn('payment_method', function ($q) {
return ucfirst($q->payment_method);
})
->addColumn('price', function ($q) {
return formatNumberWithCurrSymbol($q->price);
})
->addColumn('start_date', function ($q) {
return formatDate($q->start_date);
})
->addColumn('expired_date', function ($q) {
return formatDate($q->expired_date);
})
->addColumn('status', function ($q) {
if($q->status=='approved'){
$status='<span class="badge bg-green">Approved</span>';
}elseif ($q->status=='pending'){
$status='<span class="badge bg-primary">Pending</span>';
}else{
$status='<span class="badge bg-danger">Rejected</span>';
}
return $status;
})
->addColumn('action',function($q){
return '<a class="btn btn-sm btn-danger" data-message="Are you sure you want to delete this document?"
data-action='.route('customer.ai.content.delete',['id'=>$q->id,'type'=>'document']).'
data-input={"_method":"delete"}
data-toggle="modal" data-target="#modal-confirm">Delete</a>' ;
})
->rawColumns(['action','status'])
->toJson();
}
}
|