filterDefinition = self::availableQueryFilters();
}
/**
* Build DataTable class.
*
* @param mixed $query Results from query() method.
* @return \Yajra\DataTables\DataTableAbstract
*/
public function dataTable($query)
{
$dataTable = new EloquentDataTable($query);
$this->applyLinks($dataTable, self::SHOW_URL_ROUTE,'contacts_');
$dataTable->editColumn('status', function ($record) {
$text = "$record->status";
return DataTableHelper::applyLink($text, route(self::SHOW_URL_ROUTE, $record->id));
});
$dataTable->editColumn('phone', function ($record) {
$text ='';
if ($record->phone) {
$text = " $record->phone";
}
return DataTableHelper::applyLink($text, route(self::SHOW_URL_ROUTE, $record->id));
});
$dataTable->editColumn('email', function ($record) {
$text = " $record->email";
return DataTableHelper::applyLink($text, route(self::SHOW_URL_ROUTE, $record->id));
});
$dataTable->filterColumn('owner', function ($query, $keyword) {
DataTableHelper::queryOwner($query, $keyword, 'contacts');
});
$dataTable->filterColumn('created_at', function ($query, $keyword) {
$dates = DataTableHelper::getDatesForFilter($keyword);
if ($dates != null) {
$query->whereBetween('contacts.created_at', array($dates[0], $dates[1]));
}
});
$dataTable->filterColumn('updated_at', function ($query, $keyword) {
$dates = DataTableHelper::getDatesForFilter($keyword);
if ($dates != null) {
$query->whereBetween('contacts.updated_at', array($dates[0], $dates[1]));
}
});
$dataTable->filterColumn('birth_date', function ($query, $keyword) {
$dates = DataTableHelper::getDatesForFilter($keyword);
if ($dates != null) {
$query->whereBetween('contacts.birth_date', array($dates[0], $dates[1]));
}
});
return $dataTable;
}
/**
* Get query source of dataTable.
*
*
* @return \Illuminate\Database\Eloquent\Builder
*/
public function query(Contact $model)
{
$query = $model->newQuery()
->with('owner')
->with('contactEmails')
->leftJoin('contacts_dict_status', 'contacts.contact_status_id', '=', 'contacts_dict_status.id')
->leftJoin('contacts_dict_source', 'contacts.contact_source_id', '=', 'contacts_dict_source.id')
->leftJoin('customer_dict_language', 'contacts.language_id', '=', 'customer_dict_language.id')
->leftJoin('bap_country', 'contacts.country_id', '=', 'bap_country.id')
->leftJoin('accounts', 'contacts.account_id', '=', 'accounts.id')
->select([
'contacts.*',
'bap_country.name as country',
'contacts_dict_status.id as status_id',
'contacts_dict_status.name as status',
'contacts_dict_status.color as status_color',
'contacts_dict_source.id as source_id',
'contacts_dict_source.name as source',
'customer_dict_language.name as language',
'accounts.name as account_name',
]);
if (!empty($this->filterRules)) {
$queryBuilderParser = new QueryBuilderParser();
$queryBuilder = $queryBuilderParser->parse($this->filterRules, $query);
return $queryBuilder;
}
return $query;
}
/**
* Optional method if you want to use html builder.
*
* @return \Yajra\DataTables\Html\Builder
*/
public function html()
{
// If you need to Customize override this
return $this->tableBuilder();
}
/**
* @return array
*/
protected function getColumns()
{
$columns = ContactDatatable::availableColumns();
$result = [];
if ($this->allowSelect) {
$result = $this->btnCheck_selection;
}
if ($this->allowUnlink) {
$result = $this->btnUnlink;
}
if ($this->allowUnlink) {
$result = $result + $this->btnQuick_edit;;
}
$result = $result + $columns;
return $result;
}
}