public function index()
{
$data['slider'] = Slide::orderBy('created_at', 'asc')->get();
$data['sideslider'] = SideSlider::orderBy('created_at', 'asc')->get();
$data['partner'] = Partner::orderBy('created_at', 'asc')->get();
$data['category'] = Category::with('SubCategory')->orderBy('created_at', 'asc')->get();
$data['itemcar'] = Items::orderBy('category_id', 'asc')->get();
$data['items'] = Items::orderBy('created_at', 'asc')->paginate(45);
$data['itemshot'] = Items::where('spec', 'like', '%1%')->orderBy('created_at', 'asc')->get();
$data['onlyur'] = Items::where('spec', 'like', '%0%')->orderBy('created_at', 'asc')->get();
$data['itemsave'] = Items::where('spec', 'like', '%4%')->orderBy('created_at', 'asc')->get();
$data['itemtop'] = Items::where('spec', 'like', '%5%')->orderBy('created_at', 'asc')->get();
$data['news'] = News::orderBy('created_at', 'asc')->take(3)->skip(0)->get();
$data['staff'] = Staff::orderBy('created_at', 'asc')->take(4)->skip(0)->get();
return view('site.index', $data);
}
public function showall()
{
$items = Items::orderBy('created_at', 'desc')->get();
$categories = DB::table('categories')->get();
foreach ($items as $item) {
$r = DB::table('sub_categories')->select('categories_id')->where('id', $item->sub_categories_id)->get();
$item['category'] = $r[0]->categories_id;
}
$news = News::take(3)->get();
return view('index', ['categories' => $categories, 'items' => $items, 'news' => $news]);
}
public function edit($id)
{
$acquisition = Acquisitions::find($id);
if ($acquisition) {
$contacts = Contacts::type('PROVEEDOR')->orderBy('name')->get()->lists('name', 'id');
$items = Items::orderBy('item_name')->lists('item_name', 'id');
return view('acquisition.edit', compact('acquisition', 'contacts', 'items'));
} else {
return redirect()->action('AcquisitionsController@index')->with('error', 'La compra solicitada no existe');
}
}
