get('access');
return datatables()
->eloquent($query)
->addColumn('action', function ($query) use ($access){
$action1 = '';
$action2 = '';
$action3 = '';
return $access == 2 ? $action2 : ($access ==3 ? $action3 : $action1);
})
->addColumn('username', function ($query) use ($access){
return @$query->users->username;
})
->addColumn('phone_number', function($query){
return @$query->users->phone_number;
})
->addColumn('unit_price', function($query){
return @$query->users->credit->price;
})
->addColumn('old_balance', function($query) {
return @$query->users->credit->old_bal;
})
->addColumn('new_balance', function($query) {
return @$query->users->credit->new_bal;
})
->addColumn('amount_credited', function($query) {
return @$query->users->credit->credited;
})
->addColumn('source_of_crediting', function($query) {
return @$query->users->creditHistory->reverse()->first()->credited_by;
})
->addColumn('last_date_of_crediting', function($query) {
return @$query->users->creditHistory->reverse()->first()->date_credited;
})
->addColumn('sms_count_sent', function($query) {
return @$query->users->logs->count();
})
->addColumn('total_amount_sent', function($query) {
return @$query->users->credit->price * @$query->users->logs->count();
});
}
/**
* Get query source of dataTable.
*
* @param \App\Admin/FinancialAnalysisReportDataTable $model
* @return \Illuminate\Database\Eloquent\Builder
*/
public function query()
{
$from = $this->request()->get('from_date');
$to = $this->request()->get('to_date');
$type = $this->request()->get('type');
$status = $this->request()->get('status');
$from_date = Carbon::parse(Carbon::parse($from))->subDay(1);
$to_date = Carbon::parse(Carbon::parse($to))->addDay(1);
$roleId = strtolower($type) == 'reseller' ?
Role::where('name', 'reseller')->firstOrFail()->id :
Role::where('name', 'user')->firstOrFail()->id;
$query = Company::query()
->join('company_statuses','company_statuses.company_id','companies.id')
->whereHas('users')
->orderByDesc('company_statuses.status')
->select('companies.*');
if (!empty($from_date) && !empty($to_date) && !empty($status))
{
$query = Company::query()
->join('company_statuses','company_statuses.company_id','companies.id')
->whereHas('users',function ($user){
$user->where('created_by','npontu');
})->orderByDesc('company_statuses.status')
->select('companies.*');
}
return $this->applyScopes($query);
}
/**
* Optional method if you want to use html builder.
*
* @return \Yajra\DataTables\Html\Builder
*/
public function html()
{
return $this->builder()
->columns($this->getColumns())
->ajax('')
->addAction(['width' => '140px'])
->dom('Bfrtip')
->buttons(
Button::make('export'),
Button::make('print'),
Button::make('reset'),
Button::make('reload')
);
}
/**
* Get columns.
*
* @return array
*/
protected function getColumns()
{
return [
'name',
'username'=>['searchable'=>'false'],
'phone_number',
'unit_price',
'old_balance',
'new_balance',
'amount_credited',
'source_of_crediting',
'last_date_of_crediting',
'sms_count_sent',
'total_amount_sent',
];
}
/**
* Get filename for export.
*
* @return string
*/
protected function filename()
{
return 'Admin\FinancialAnalysisReport_' . time();
}
}