public function excelArticulosPorAlmacen($id) { if ($id != 'all') { $report = Excel::create('Auditoría de Almacén ', function ($excel) use($id) { $excel->sheet('Articulos', function ($sheet) use($id) { $data = array(); $name = Auth::user()->firstName . ' ' . Auth::user()->lastName; $warehouse = Warehouse::findOrFail($id); $data[] = ['Código', 'Nombre', 'Cantidad', 'Serial']; foreach ($warehouse->inventory as $articulo) { if ($articulo['serializable'] == 0) { $data[] = [$articulo['product_code'], $articulo['name'], $articulo['cantidad'], '--']; } else { foreach ($articulo['seriales'] as $item) { $data[] = [$articulo['product_code'], $articulo['name'], '1', $item->serial]; } } } $sheet->fromArray($data); $sheet->setColumnFormat(array('A' => '@', 'B' => '@', 'C' => '0', 'C' => '@')); $sheet->prependRow(1, array('Auditado por:', $name)); $sheet->prependRow(1, array('Fecha: ', \Carbon\Carbon::now('America/Argentina/Buenos_Aires'))); $sheet->prependRow(1, array('Auditoría de ' . $warehouse->name)); $sheet->cells('A1', function ($cells) { $cells->setFontSize(18); $cells->setFontWeight('bold'); }); $sheet->cells('A2:F3', function ($cells) { $cells->setFontSize(16); $cells->setFontWeight('bold'); }); $sheet->cells('A4:F4', function ($cells) { $cells->setFontSize(14); }); $sheet->cells('A5:D5', function ($cells) { $cells->setFontWeight('bold'); }); }); })->export('xlsx'); } }
/** Devuelve el detalle de un almacén especificado * @param $id * @return Warehouse */ public function warehouseDetail($id) { $w = Warehouse::findOrFail($id); return $w; }
public function delete($id) { Warehouse::findOrFail($id)->delete(); return redirect('/almacenes'); }
/** * Update the specified resource in storage. * PUT /warehouses/{id} * * @param int $id * @return Response */ public function update($id, Request $request) { $warehouse = Warehouse::findOrFail($id); $address = $warehouse->address; $this->validate($request, Address::related_rules()); // http://stackoverflow.com/questions/17950118/laravel-eloquent-how-to-update-a-model-and-related-models-in-one-go $warehouse->update(array_merge($request->all(), ['alias' => $request->input('address.alias')])); $request->merge($request->input('address')); $request->merge(['notes' => '']); $address->update($request->except(['address'])); return redirect('warehouses')->with('info', l('This record has been successfully updated :: (:id) ', ['id' => $id], 'layouts') . $request->get('name_commercial')); }
/** * Remove the specified resource from storage. * * @param int $id * @return \Illuminate\Http\Response */ public function destroy($id) { $warehouse = Warehouse::findOrFail($id); $warehouse->delete(); session()->flash('flash_message_danger', 'Almacén borrado correctamente.'); // Si flash_message_important esta presente, el mensaje no desaparece hasta que el usuario lo cierre // session()->flash('flash_message_important', true); return Redirect::to('almacenes'); }