Viewing file:  TransactionController.php (1.46 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\Plan;
use App\Models\Transaction;
use Carbon\Carbon;
use Illuminate\Http\Request;
class TransactionController extends Controller
{
public function index(){
return view('admin.transaction.index');
}
public function getAllTransactions(Request $request)
{
if($request->limit) {
$transactions=Transaction::orderByDesc('created_at')->limit(10);
}else {
$transactions=Transaction::orderByDesc('created_at')->get();
}
return datatables()->of($transactions)
->addColumn('customer', function ($q) {
$customer=isset($q->customer)?$q->customer->full_name:'';
return $customer;
})
->addColumn('amount', function ($q) {
$amount=isset($q->amount)?formatNumberWithCurrSymbol($q->amount):0;
return $amount;
})
->addColumn('plan', function ($q) {
$plan = Plan::where('id', $q->ref_id)->first();
if($plan) {
$title='<p class="d-block m-0">'.'<b>'.trans('admin.plan_name').'</b>'.': '.'<span class="text-muted">'.urlencode($plan->title).'</span>'.'</p>';
return '<div class="d-block">'.$title.'</div>';
}
})
->rawColumns(['customer','amount','plan'])
->toJson();
}
}
|