private function guardarItems($idFactura)
{
try {
if (Session::has('carrito')) {
$carrito = Session::get('carrito');
if (empty($carrito)) {
$filasAfectadas = FacturaItem::where('factura_id', '=', $idFactura)->delete();
return false;
}
foreach ($carrito as $item) {
$fi = new FacturaItem();
$fi->factura_id = $idFactura;
$fi->articulo_id = $item['articulo']->id;
$fi->cantidad = $item['cantidad'];
$fi->precio = $item['articulo']->precio;
$fi->iva = $item['articulo']->iva;
$fi->save();
}
return true;
}
} catch (Exception $e) {
$filasAfectadas = FacturaItem::where('factura_id', '=', $idFactura)->delete();
return false;
}
}
public function getMyPurchase($id)
{
$title = "Factura";
$fac = Facturas::find($id);
$user = User::find($fac->user_id);
$aux = FacturaItem::where('factura_id', '=', $id)->get(array('item_id', 'item_qty'));
$i = 0;
foreach ($aux as $a) {
$b = Items::find($a->item_id);
$b->qty = $a->item_qty;
$aux = Misc::where('item_id', '=', $a->item_id)->where('deleted', '=', 0)->first();
$b->img = Images::where('misc_id', '=', $aux->id)->where('deleted', '=', 0)->first();
$item[$i] = $b;
$i++;
}
return View::make('user.factura')->with('fact', $item)->with('title', $title)->with('user', $user)->with('factura', $fac);
}
public function getProcesePurchase($id)
{
$title = "Metodo de pago | Nia Boutique.com";
$fac = Facturas::find($id);
$x = FacturaItem::where('factura_id', '=', $id)->sum('item_qty');
$aux = FacturaItem::where('factura_id', '=', $id)->get(array('item_id', 'item_qty', 'item_talla', 'item_color', 'item_precio'));
$i = 0;
$auxT = 0;
$auxQ = 0;
$p = '';
foreach ($aux as $a) {
$b = Items::where('item.id', '=', $a->item_id)->first();
$p = $p . $b->item_nomb . ', ';
$b->qty = $a->item_qty;
$b->precio = $a->item_precio;
$b->item_talla = Tallas::where('id', '=', $a->item_talla)->pluck('talla_desc');
$b->item_color = Colores::where('id', '=', $a->item_color)->pluck('color_desc');
$auxT = $auxT + $b->qty * $b->item_precio;
$auxQ = $auxQ + $b->qty;
$aux = Misc::where('item_id', '=', $a->item_id)->where('deleted', '=', 0)->first();
$b->img = Images::where('misc_id', '=', $aux->id)->where('deleted', '=', 0)->first();
$item[$i] = $b;
$i++;
}
$total = 0;
$method = 'hola';
$bancos = Bancos::where('deleted', '=', 0)->get();
return View::make('indexs.showCart')->with('title', $title)->with('method', $method)->with('total', $total)->with('items', $item)->with('id', $id)->with('bancos', $bancos);
}
public function postPaymentElim()
{
$id = Input::get('id');
$motivo = Input::get('motivo');
$fac = Facturas::find($id);
$fi = FacturaItem::where('factura_id', '=', $fac->id)->get();
foreach ($fi as $f) {
$item = Misc::where('item_id', '=', $f->item_id)->where('item_talla', '=', $f->item_talla)->where('item_color', '=', $f->item_color)->first();
$item->item_stock = $item->item_stock + $f->item_qty;
$item->save();
}
$fac->deleted = 1;
$fac->save();
$user = User::find($fac->user_id);
if ($fac->save()) {
$data = array('username' => Auth::user()->username, 'fac' => $id, 'fecha' => date('d-m-Y', time()), 'motivo' => $motivo);
Mail::send('emails.reject', $data, function ($message) use($id, $motivo, $user) {
$message->subject('Correo de aviso niaboutique.com');
$message->to($user->email);
});
return Response::json(array('type' => 'success', 'msg' => 'Pago eliminado correctamente.'));
} else {
return Response::json(array('type' => 'danger', 'msg' => 'Error al eliminar el pago.'));
}
}
