/** * Show the form for creating a new resource. * * @return Response */ public function create($recipe_id, $type) { $recipe = Recipes::findOrFail($recipe_id); if ($type == 'recipe') { $included_recipes = RecipeItems::where(['recipe_id' => $recipe_id, 'type' => $type])->lists('sub_recipe'); $included_recipes[] = $recipe_id; $select_recipes = $included_recipes ? Recipes::whereNotIn('id', $included_recipes)->lists('title', 'id') : Recipes::lists('title', 'id'); if ($select_recipes) { return view('RecipeItems.create_recipe')->with(array('title' => $this->title, 'recipe' => $recipe, 'recipes' => $select_recipes, 'type' => $type)); } else { Session::flash('flash_message', 'It looks like you have included all possible recipes already.'); return Redirect::action('RecipeItemsController@index', $recipe->id); } } else { $items = ItemUnits::orderBy('default', 'DESC')->get(); $items_units = []; foreach ($items as $item) { $items_units['list'][$item->item()->first()->id][] = ['id' => $item->id, 'title' => $item->unit()->first()->title]; $items_units['php_list'][$item->item()->first()->id][$item->id] = $item->unit()->first()->title; $items_units['factors'][$item->id] = $item->factor; } $select_items = Items::whereNotIn('id', RecipeItems::where(['recipe_id' => $recipe_id, 'type' => $type])->lists('item_id'))->orderBy('title', 'ASC')->lists('title', 'id'); if ($select_items) { return view('RecipeItems.create_item')->with(array('title' => $this->title, 'recipe' => $recipe, 'items' => $select_items, 'items_units' => $items_units, 'type' => $type)); } else { Session::flash('flash_message', 'It looks like you have used all possible products in your recipe.'); return Redirect::action('RecipeItemsController@index', $recipe->id); } } }
public function setDefault($id) { $itemUnit = ItemUnits::findOrFail($id); Helper::add($id, 'changed item ' . $itemUnit->item()->first()->title . '(ID ' . $itemUnit->item()->first()->id . ') default unit to ' . $itemUnit->unit()->first()->title); ItemUnits::where('item_id', $itemUnit->item_id)->update(['default' => 0]); ItemUnits::where('id', $id)->update(['default' => 1]); ItemUnits::where(['item_id' => $itemUnit->item_id])->update(['factor' => DB::raw('factor/' . $itemUnit->factor)]); StockItem::where(['item_id' => $itemUnit->item_id])->update(['stock' => DB::raw('stock/' . $itemUnit->factor)]); RecipeItems::where(['item_id' => $itemUnit->item_id])->update(['value' => DB::raw('value/' . $itemUnit->factor)]); Menu::where(['item_id' => $itemUnit->item_id])->update(['value' => DB::raw('value/' . $itemUnit->factor)]); ItemPurchases::where(['item_id' => $itemUnit->item_id])->update(['value' => DB::raw('value/' . $itemUnit->factor)]); StockCheck::where(['item_id' => $itemUnit->item_id])->update(['before' => DB::raw('`before` / ' . $itemUnit->factor), 'after' => DB::raw('`after` / ' . $itemUnit->factor)]); return Redirect::action('ItemUnitsController@index', array('item_id' => $itemUnit->item_id)); }
/** * Show the form for editing the specified resource. * * @param int $id * @return Response */ public function edit($id) { $item_purchase = ItemPurchases::findOrFail($id); $purchase = $item_purchase->purchase()->first(); $type = $item_purchase->type; if ($type == 'item') { $items = ItemUnits::orderBy('default', 'DESC')->get(); $items_units = []; foreach ($items as $item) { $items_units['list'][$item->item()->first()->id][] = ['id' => $item->id, 'title' => $item->unit()->first()->title]; $items_units['php_list'][$item->item()->first()->id][$item->id] = $item->unit()->first()->title; $items_units['factors'][$item->id] = $item->factor; $items_units['item_to_unit'][$item->id] = $item->unit()->first()->id; } $select_items = Items::orderBy('title', 'ASC')->lists('title', 'id'); if ($select_items) { return view('ItemPurchases.edit_item')->with(array('title' => $this->title, 'purchase' => $purchase, 'items' => $select_items, 'items_units' => $items_units, 'type' => $type, 'item' => $item_purchase)); } else { Session::flash('flash_message', 'It looks like you have used all possible products in your invoice.'); return Redirect::action('ItemPurchasesController@index', $purchase->id); } } else { return view('ItemPurchases.edit_custom')->with(array('title' => $this->title, 'purchase' => $purchase, 'type' => $type, 'item' => $item_purchase)); } }
public function setDefault($id) { $itemUnit = ItemUnits::findOrFail($id); ItemUnits::where('item_id', $itemUnit->item_id)->update(['default' => 0]); ItemUnits::where('id', $id)->update(['default' => 1]); ItemUnits::where(['item_id' => $itemUnit->item_id])->update(['factor' => DB::raw('factor/' . $itemUnit->factor)]); return Redirect::action('ItemUnitsController@index', array('item_id' => $itemUnit->item_id)); }
/** * Show the form for editing the specified resource. * * @param int $id * @return Response */ public function edit($id) { $waste = Wastes::findOrFail($id); $currentPeriodId = Helper::defaultPeriodId(); $periods = StockPeriods::all(); $period_list = array(); foreach ($periods as $period) { $period_list[$period->id] = 'Stock #' . $period->number . ' (' . $period->date_from . ' - ' . ($period->id == $currentPeriodId ? 'NOW' : $period->date_to) . ')'; } if (Input::has('stock_period')) { $currentPeriodId = Input::get('stock_period'); } $select_recipes = Recipes::orderBy('title', 'ASC')->lists('title', 'id'); $items = ItemUnits::orderBy('default', 'DESC')->get(); $items_units = []; foreach ($items as $item) { $items_units['list'][$item->item()->first()->id][] = ['id' => $item->id, 'title' => $item->unit()->first()->title]; $items_units['php_list'][$item->item()->first()->id][$item->id] = $item->unit()->first()->title; $items_units['factors'][$item->id] = $item->factor; } $select_items = Items::orderBy('title', 'ASC')->lists('title', 'id'); $select_menus = Menu::orderBy('title', 'ASC')->lists('title', 'id'); $select_reasons = WasteReasons::orderBy('reason', 'ASC')->lists('reason', 'id'); return view('Wastes.edit')->with(array('title' => $this->title, 'recipes' => $select_recipes, 'items' => $select_items, 'items_units' => $items_units, 'menus' => $select_menus, 'period' => $currentPeriodId, 'stocks_list' => $period_list, 'reasons' => $select_reasons, 'waste' => $waste)); }
public function assign($id) { $menu = Menu::findOrFail($id); $select_recipes = Recipes::orderBy('title', 'ASC')->lists('title', 'id'); $items = ItemUnits::orderBy('default', 'DESC')->get(); $items_units = []; foreach ($items as $item) { $items_units['list'][$item->item()->first()->id][] = ['id' => $item->id, 'title' => $item->unit()->first()->title]; $items_units['php_list'][$item->item()->first()->id][$item->id] = $item->unit()->first()->title; $items_units['factors'][$item->id] = $item->factor; } $select_items = Items::orderBy('title', 'ASC')->lists('title', 'id'); return view('Menus.assign')->with(array('title' => $this->title, 'item' => $menu, 'recipes' => $select_recipes, 'items' => $select_items, 'items_units' => $items_units)); }