public function item($id = 0)
{
$item = Items::find($id);
if ($item['obj']) {
$obj = json_decode($item['obj'], true);
$item['obj'] = $obj;
if (!isset($obj['images'])) {
$item->images = [];
} else {
$item->images = $obj['images'];
}
}
$catalog_banner = UIComponents::where('name', '=', 'catalog-banner')->get()->first();
$catalog_banner_arr = [];
if (isset($catalog_banner) && isset($catalog_banner->obj)) {
$obj = json_decode($catalog_banner->obj);
if (isset($obj->images)) {
$catalog_banner_arr['images'] = $obj->images;
}
if (isset($obj->html)) {
$catalog_banner_arr['html'] = $obj->html;
}
}
if (isset($item['obj']['Версия/Модификация']) && trim($item['obj']['Версия/Модификация']) != '') {
$item['name'] = "{$item['obj']['type_auto'][0]['children'][0]['text']}" . " {$item['obj']['type_auto'][0]['children'][0]['children'][0]['text']}" . " {$item['obj']['Версия/Модификация']}" . " {$item['obj']['God_vypuska'][0]['text']}";
} else {
$item['name'] = "{$item['obj']['type_auto'][0]['children'][0]['text']}" . " {$item['obj']['type_auto'][0]['children'][0]['children'][0]['text']}" . " {$item['obj']['God_vypuska'][0]['text']}";
}
return view('catalog/catalog/item', ['item' => $item, 'catalog_banner' => $catalog_banner_arr]);
}
/**
* Display a listing of the resource.
*
* @return \Illuminate\Http\Response
*/
public function index()
{
//
// $name = Auth::user()->email;
// return view('dashboard');
$user = Auth::user()->name;
$userId = Auth::user()->id;
$locateInDbUser = App\User::find($userId);
$locateInDbItems = App\Items::find($userId);
$locateInDbWatchlist = App\Watchlist::find($userId);
$itemsWatched = DB::table('watchlists')->where('user_id', '=', $userId)->count();
$itemsOwned = DB::table('items')->where('users_id', '=', $userId)->count();
$benefit = $locateInDbUser->benefits;
$auction_wins = $locateInDbUser->auction_wins;
$itemsOnWatchlist = DB::table('watchlists')->where('user_id', '=', $userId)->get();
if ($itemsOnWatchlist == []) {
$queryWatchlist = '';
return view('dashboard')->with('user', $user)->with('userId', $userId)->with('benefits', $benefit)->with('auction_wins', $auction_wins)->with('itemsWatched', $itemsWatched)->with('itemsOwned', $itemsOwned)->with('itemsOnWatchlist', $itemsOnWatchlist)->with('queryWatchlist', $queryWatchlist);
} else {
$queryWatchlist = DB::table('items');
foreach ($itemsOnWatchlist as $itemOnWatchlist) {
$queryWatchlist->orWhere('id', '=', $itemOnWatchlist->item_id);
}
$queryWatchlist = $queryWatchlist->get();
// return $queryWatchlist;
return view('dashboard')->with('user', $user)->with('userId', $userId)->with('benefits', $benefit)->with('auction_wins', $auction_wins)->with('itemsWatched', $itemsWatched)->with('itemsOwned', $itemsOwned)->with('itemsOnWatchlist', $itemsOnWatchlist)->with('queryWatchlist', $queryWatchlist);
}
}
public function index($id = 0)
{
$categories = Categories::all();
$categories = $categories->sortBy('sort_id');
$item = Items::find($id);
$comments = Comments::where('items_id', '=', $id)->get();
$data = ['categories' => $categories, 'item' => $item, 'id' => $item->categories_id, 'comments' => $comments];
return view('items.index', $data);
}
/**
* Display the specified resource.
*
* @param int $id
* @return \Illuminate\Http\Response
*/
public function show($id)
{
$item = Items::find($id);
if ($item) {
return view('item.addImage', compact('item'));
} else {
return redirect()->action('ItemsController@index')->with('error', 'El producto solicitado no existe');
}
}
public function add(Request $request)
{
$validator = $this->validator($request->all());
if ($validator->fails()) {
$this->throwValidationException($request, $validator);
}
$item = Items::find($request->items_id);
$item->count_comments++;
$item->save();
$this->create($request->all());
return redirect('items/' . $request->items_id);
}
/**
* Display a listing of the resource.
*
* @return \Illuminate\Http\Response
*/
public function index()
{
//
$user = Auth::user()->name;
$userId = Auth::user()->id;
$locateInDbUser = App\User::find($userId);
$locateInDbItems = App\Items::find($userId);
$locateInDbWatchlist = App\Watchlist::find($userId);
$itemsWatched = DB::table('watchlists')->where('user_id', '=', $userId)->count();
$itemsSelect = DB::table('items')->where('betting_status', '=', 1)->where('users_id', '=', $userId)->orderBy('id', 'asc')->lists('item_name');
$itemsOwned = DB::table('items')->where('users_id', '=', $userId)->count();
$benefit = $locateInDbUser->benefits;
$auction_wins = $locateInDbUser->auction_wins;
return view('retrieveOffer')->with('user', $user)->with('userId', $userId)->with('benefits', $benefit)->with('auction_wins', $auction_wins)->with('itemsWatched', $itemsWatched)->with('itemsOwned', $itemsOwned)->with('itemsSelect', $itemsSelect);
}
/**
* Display a listing of the resource.
*
* @return \Illuminate\Http\Response
*/
public function showItemDetail($slug, $id)
{
$data['item'] = Items::findOrFail($id);
$item = Items::findOrFail($id);
if (is_dir(public_path() . '/uploads/photos/' . $id . '/')) {
$photos = scandir(public_path() . '/uploads/photos/' . $id . '/', 1);
$files = array_diff($photos, array('.', '..'));
} else {
$files = [];
}
$data['review'] = Review::where('item_id', $id)->get();
$data['item_id'] = $id;
$data['itemphotos'] = $files;
$data['colors'] = Items::find($id)->ItemColors()->get();
$data['sizes'] = Items::find($id)->ItemSize()->get();
$data['partner'] = Partner::orderBy('created_at', 'asc')->get();
$data['category'] = Category::with('SubCategory')->orderBy('created_at', 'asc')->get();
$data['topseller'] = Items::where('category_id', '1')->get();
$data['categorytop'] = Category::findOrFail($item->category_id);
$data['subcategorytop'] = SubCategory::findOrFail($item->subcategory_id);
$data['related'] = Items::where('category_id', $item->category_id)->get();
return view('site.item-detail', $data);
}
public function store(Request $request)
{
$v = $this->validator($request->all());
//VALIDACIÓN DE FORMULARIO
if ($v->fails()) {
return redirect()->back()->withErrors($v->errors())->withInput();
} else {
//SE CREA UN NUEVA COMPRA
$imagexml = $request->xml_path;
$xml = $request->file('xml_path');
$imagepdf = $request->pdf_path;
$pdf = $request->file('pdf_path');
$filenamexml = 'xml' . time() . '.' . $imagexml->getClientOriginalExtension();
$filenamepdf = 'pdf' . time() . '.' . $imagepdf->getClientOriginalExtension();
$acquisitionsCreate = Acquisitions::create(['xml_path' => 'images/acquisition/' . $filenamexml, 'pdf_path' => 'images/acquisition/' . $filenamepdf, 'bill_number' => $request->bill_number, 'provider_id' => $request->provider_id, 'user_id' => $request->user()->id, 'sub_total' => $request->sub_total, 'total' => $request->total]);
$lastInsertedId = $acquisitionsCreate->id;
$arrayQuantity = $request->acquisition_quantity;
$arrayItem = $request->item_id;
if ($acquisitionsCreate) {
//SE REGISTRA LA ACTIVIDAD EN LA BITACORA
$this->binnacle("REGISTRÓ NUEVA COMPRA", $request);
//SE GUARDA LA IMAGEN
$request->file('xml_path')->move('images/acquisition/', $filenamexml);
$request->file('pdf_path')->move('images/acquisition/', $filenamepdf);
//SE GUARDAN LOS ITEMS DE LA COMPRA
foreach ($request->cost as $key => $value) {
$itemsCreate = AcquisitionItems::create(['cost' => $value, 'acquisition_quantity' => $arrayQuantity[$key], 'item_id' => $arrayItem[$key], 'acquisition_id' => $lastInsertedId]);
$items = Items::find($arrayItem[$key]);
$items->fill(['stock_quantity' => $items->stock_quantity + $arrayQuantity[$key]]);
$items->save();
}
}
Session::flash('message', 'Compra creada correctamente');
return Redirect::to('/acquisition/create');
}
}
public function show($id)
{
$items = Items::find($id);
$parameters = $items->parameters;
$count = $parameters->count();
$res = collect([]);
for ($i = 0; $i < $count; $i++) {
$value = Items_parameters::where('items_id', $items->id)->get()[$i]->value;
$res->push(collect(['title' => $parameters[$i]->title, 'unit' => $parameters[$i]->unit, 'value' => $value]));
}
$res = $res->toArray();
if ($items->preview != "") {
$images = explode(';', $items->preview);
} else {
$images = null;
}
$categories = "";
$categories = DB::table('sub_categories')->select('title')->where('id', $items->sub_categories_id)->get();
if (!empty($categories)) {
$categories = $categories[0]->title;
} else {
$categories = "non categories";
}
$main_categories = Category::all();
return view('show-item', ['items' => $items, 'res' => $res, 'images' => $images, 'categories' => $categories, 'main_categories' => $main_categories]);
}
/**
* Remove the specified resource from storage.
*
* @param int $id
* @return \Illuminate\Http\Response
*/
public function delete($id)
{
$item = Items::find($id);
$item->delete();
return \Redirect::action('Admin\\ItemsController@index');
}
public function destroy(Request $request, $id)
{
//ELIMINA PRODUCTO
$item = Items::find($id);
if ($item->delete()) {
//SE REGISTRA LA ACTIVIDAD EN LA BITACORA
$this->binnacle("ELIMINÓ PRODUCTO", $request);
}
return redirect()->action('ItemsController@index')->with('message', 'El producto se eliminó correctamente');
}
public function FinalItembet($idItem)
{
$user = Auth::user()->name;
$userId = Auth::user()->id;
$locateInDbUser = App\User::find($userId);
$locateInDbItems = App\Items::find($userId);
$locateInDbWatchlist = App\Watchlist::find($userId);
$itemId = explode('X', $idItem);
$itemId = intval($itemId[0]);
$itemsWatched = DB::table('watchlists')->where('user_id', '=', $userId)->count();
$itemsName = DB::table('items')->where('id', '=', $itemId)->value('item_name');
$itemsDescription = DB::table('items')->where('id', '=', $itemId)->value('description');
$itemsMin = DB::table('items')->where('id', '=', $itemId)->value('minimalPrice');
$itemsOwned = DB::table('items')->where('users_id', '=', $userId)->count();
$benefit = $locateInDbUser->benefits;
$auction_wins = $locateInDbUser->auction_wins;
//
return view('FinalItembet')->with('user', $user)->with('userId', $userId)->with('benefits', $benefit)->with('auction_wins', $auction_wins)->with('itemsWatched', $itemsWatched)->with('itemsOwned', $itemsOwned)->with('itemsDescription', $itemsDescription)->with('itemsMin', $itemsMin)->with('itemId', $itemId)->with('itemsName', $itemsName);
}
public function editItem($id)
{
$item = Items::find($id);
$items_type = DB::table('item_type')->get();
return View('items.edit_item', ['item' => $item, 'item_type_list' => $items_type]);
}
/**
* Remove the specified resource from storage.
*
* @param int $id
* @return \Illuminate\Http\Response
*/
public function destroy($id)
{
$data = Items::find($id);
if ($data) {
$data->delete();
return response()->json($data);
} else {
return $this->error("No item with this id");
}
}
public function searchItemForm()
{
$itemToSearchName = Input::get('itemName');
$itemToSearchSelect = Input::get('userChosen');
$itemToSearchSelect2 = Input::get('categoryChosen');
$user = Auth::user()->name;
$userId = Auth::user()->id;
// $itemsToId=DB::table('items')
// ->where('item_name','=',$itemToOffer)
// ->where('users_id','=',$userId)
// ->first();
$query = DB::table('items');
$query->where('users_id', '<>', $userId);
$query->where('betting_status', '=', 1);
if ($itemToSearchSelect != 'Any user') {
// $query->where('user')
$usersSelect = DB::table('users')->where('email', '=', $itemToSearchSelect)->first();
$query->where('users_id', '=', $usersSelect->id);
}
if ($itemToSearchSelect2 != 'Any category') {
// $query->where('user')
// $catSelect=DB::table('categories')
// ->where('catname','=',$itemToSearchSelect2)
// ->first();
$query->where('category1', '=', $itemToSearchSelect2);
}
if ($itemToSearchName != '') {
$query->where('item_name', 'LIKE', '%' . $itemToSearchName . '%');
}
$rows = $query->get();
if ($rows == []) {
Session::flash('messageErrorDate', "No match, redefine your search terms");
return redirect('searchItem');
} else {
$rows = $query->paginate(10);
$user = Auth::user()->name;
$userId = Auth::user()->id;
$locateInDbUser = App\User::find($userId);
$locateInDbItems = App\Items::find($userId);
$locateInDbWatchlist = App\Watchlist::find($userId);
$itemsWatched = DB::table('watchlists')->where('user_id', '=', $userId)->count();
$usersTable = DB::table('users');
$itemsOwned = DB::table('items')->where('users_id', '=', $userId)->count();
$benefit = $locateInDbUser->benefits;
$auction_wins = $locateInDbUser->auction_wins;
Session::flash('messageOkSearch', "");
return view('searchResults')->with('user', $user)->with('userId', $userId)->with('benefits', $benefit)->with('auction_wins', $auction_wins)->with('itemsWatched', $itemsWatched)->with('itemsOwned', $itemsOwned)->with('rowsSearch', $rows)->with('usersTable', $usersTable);
}
// return $rows;
}
public function editItem($id)
{
$item = Items::find($id);
return View('items.edit_item', ['item' => $item]);
}
public function addToWatchlist($id)
{
// DB::table('items')->insert(
// ['item_name' => $itemName, 'description' => $itemDescription,'originalOwner'
// =>$user,'users_id'=>$userId,'minimalPrice' =>$minimalPrice,'category1'
// =>$category1,'category2' =>$category2,'category3' =>$category3,'category4' =>$category4]
// );
$user = Auth::user()->name;
$userId = Auth::user()->id;
$locateInDbItems = App\Items::find($id);
if ($locateInDbItems->auction_time == NULL) {
Session::flash('messageErrorDate', "An auction time has not been set for this item. Retry later");
return redirect('searchItem');
} else {
$alreadyWatchlisted = DB::table('watchlists')->where('user_id', '=', $userId)->where('item_id', '=', $id)->get();
if ($alreadyWatchlisted == []) {
DB::table('watchlists')->insert(['user_id' => $userId, 'item_id' => $id]);
Session::flash('messageOkOffer', "The item has been added to your watchlist");
return redirect('searchItem');
} else {
Session::flash('messageErrorDate', "This item has already been added to your watchlist");
return redirect('searchItem');
}
// Session::flash('messageOk',"The item has been watchlisted");
// return redirect('searchItem');
// return $alreadyWatchlisted;
}
}
