public function __construct(CustomFields $customFieldsMangaer)
{
$this->customFieldsMangaer = $customFieldsMangaer;
if (Request::ajax()) {
$this->layout = 'backend.ajax_layout';
}
View::composer('backend.camposextra.layout', function ($view) {
$data['camposextra'] = CustomField::all();
$view->nest('sidebar', 'backend.camposextra.list', $data);
});
}
public function getMetadatos($id_encabezado)
{
$encabezado = EstructuraEncabezado::find($id_encabezado);
$customFields = CustomField::all();
$data['encabezado'] = $encabezado;
$data['custom_fields'] = $customFields;
$this->layout->content = View::make('backend.estructuras.metadatos', $data);
}
/**
* Query builder scope to search on text for complex Bootstrap Tables API
*
* @param Illuminate\Database\Query\Builder $query Query builder instance
* @param text $search Search term
*
* @return Illuminate\Database\Query\Builder Modified query builder
*/
public function scopeTextSearch($query, $search)
{
$search = explode(' ', $search);
return $query->where(function ($query) use($search) {
foreach ($search as $search) {
$query->whereHas('model', function ($query) use($search) {
$query->whereHas('category', function ($query) use($search) {
$query->where(function ($query) use($search) {
$query->where('categories.name', 'LIKE', '%' . $search . '%')->orWhere('models.name', 'LIKE', '%' . $search . '%');
});
});
})->orWhere(function ($query) use($search) {
$query->whereHas('assetstatus', function ($query) use($search) {
$query->where('status_labels.name', 'LIKE', '%' . $search . '%');
});
})->orWhere(function ($query) use($search) {
$query->whereHas('company', function ($query) use($search) {
$query->where('companies.name', 'LIKE', '%' . $search . '%');
});
})->orWhere(function ($query) use($search) {
$query->whereHas('defaultLoc', function ($query) use($search) {
$query->where('locations.name', 'LIKE', '%' . $search . '%');
});
})->orWhere(function ($query) use($search) {
$query->whereHas('assigneduser', function ($query) use($search) {
$query->where(function ($query) use($search) {
$query->where('users.first_name', 'LIKE', '%' . $search . '%')->orWhere('users.last_name', 'LIKE', '%' . $search . '%')->orWhere(function ($query) use($search) {
$query->whereHas('userloc', function ($query) use($search) {
$query->where('locations.name', 'LIKE', '%' . $search . '%');
});
});
});
});
})->orWhere('assets.name', 'LIKE', '%' . $search . '%')->orWhere('asset_tag', 'LIKE', '%' . $search . '%')->orWhere('serial', 'LIKE', '%' . $search . '%')->orWhere('order_number', 'LIKE', '%' . $search . '%')->orWhere('notes', 'LIKE', '%' . $search . '');
}
foreach (CustomField::all() as $field) {
$query->orWhere($field->db_column_name(), 'LIKE', "%{$search}%");
}
});
}
public function getAddcampoextra()
{
$data['camposextra'] = CustomField::all();
return View::make('backend/customfields/selecttype', $data);
}
