33 lines
1.1 KiB
PHP
33 lines
1.1 KiB
PHP
<?php
|
|
|
|
namespace Modules\Portal\Http\Controllers\Marketer;
|
|
|
|
use App\Transaction;
|
|
use Illuminate\Http\Request;
|
|
use Modules\Portal\Http\Controllers\BasePortalController;
|
|
use Yajra\DataTables\Facades\DataTables;
|
|
|
|
class ExpenseController extends BasePortalController
|
|
{
|
|
public function index(Request $request)
|
|
{
|
|
$business_id = $this->businessId();
|
|
$user_id = auth()->id();
|
|
|
|
if ($request->ajax()) {
|
|
$expenses = Transaction::where('business_id', $business_id)
|
|
->where('type', 'expense')
|
|
->where('expense_for', $user_id)
|
|
->select('id', 'ref_no', 'transaction_date', 'final_total', 'additional_notes');
|
|
|
|
return Datatables::of($expenses)
|
|
->editColumn('transaction_date', '{{@format_date($transaction_date)}}')
|
|
->editColumn('final_total', '<span class="display_currency" data-currency_symbol="true">{{$final_total}}</span>')
|
|
->rawColumns(['final_total'])
|
|
->make(true);
|
|
}
|
|
|
|
return view('portal::marketer.expenses.index');
|
|
}
|
|
}
|