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');
}
