public function edit(Request $request)
 {
     $var = $request->detailPurchases;
     //->except($request->detailPurchases["id"]);
     $purchase = $this->purchaseRepo->find($request->input('id'));
     $purchase->detPres()->detach();
     //die();
     //var_dump($purchase); die();
     foreach ($var as $object) {
         //$detailPurchase=$object->merge(['id' => '0']);
         //var_dump($object); die();
         //request merge;
         $detailPurchaseRepox = new DetailPurchaseRepo();
         $insertar = new DetailPurchaseManager($detailPurchaseRepox->getModel(), $object);
         $insertar->save();
         $detailPurchaseRepox = null;
     }
     return response()->json(['estado' => true]);
 }
Пример #2
0
 public function create(Request $request)
 {
     // var_dump($request->all());die();
     \DB::beginTransaction();
     $saldoTemp = 0;
     $codigoHeadIS = 0;
     $purchase = $this->purchaseRepo->getModel();
     $payment = $this->paymentRepo->getModel();
     $pendientAccount = $this->pendientAccountRepo->getModel();
     $var = $request->detailOrderPurchases;
     $almacen_id = $request->input("warehouses_id");
     if (!empty($request->input("compraDirecta"))) {
         foreach ($var as $object) {
             $stockmodel = new StockRepo();
             $object['warehouse_id'] = $almacen_id;
             $object["variant_id"] = $object["Codigovar"];
             $stockac = $stockmodel->encontrar($object["variant_id"], $almacen_id);
             if (!empty($stockac)) {
                 $object["stockActual"] = floatval($stockac->stockActual) + floatval($object["cantidad"]);
                 //var_dump($object["stockActual"]);die();
                 $manager = new StockManager($stockac, $object);
                 $manager->save();
                 $stock = null;
             } else {
                 $object["stockActual"] = $object["cantidad"];
                 //var_dump($object["stockActual"]);die();
                 $manager = new StockManager($stockRepo->getModel, $object);
             }
             $stockac = null;
         }
     }
     //==================================Cancelar Factura
     if ($request->input('estado') == 2) {
         //var_dump("hola");die();
         foreach ($var as $object) {
             $stockmodel = new StockRepo();
             $object['warehouse_id'] = $almacen_id;
             $object["variant_id"] = $object["Codigovar"];
             $stockac = $stockmodel->encontrar($object["variant_id"], $almacen_id);
             //var_dump($stockac);die();
             if (!empty($stockac)) {
                 $object["porLlegar"] = floatval($stockac->porLlegar) - floatval($object["cantidad"]);
                 $manager = new StockManager($stockac, $object);
                 $manager->save();
                 $stock = null;
             }
             //}
             $stockac = null;
         }
         $orderPurchase = $this->orderPurchaseRepo->find($request->id);
         $ordercompra = new OrderPurchaseManager($orderPurchase, $request->except('fechaPedido', 'fechaPrevista', 'montoBruto', 'montoTotal', 'descuento'));
         $ordercompra->save();
         if ($this->orderPurchaseRepo->validateDate(substr($request->input('fechaPedido'), 0, 10)) and $this->orderPurchaseRepo->validateDate(substr($request->input('fechaPrevista'), 0, 10))) {
             $orderPurchase->fechaPedido = substr($request->input('fechaPedido'), 0, 10);
             $orderPurchase->fechaPrevista = substr($request->input('fechaPrevista'), 0, 10);
         } else {
             $orderPurchase->fechaPedido = null;
             $orderPurchase->fechaPrevista = null;
         }
         $orderPurchase->save();
         $payment1 = $this->paymentRepo->paymentById($request->input('id'));
         $pendientAccount = $this->pendientAccountRepo->getModel();
         //$pendientAcc=$this->pendientAccountRepo->verSaldos($payment1->id);
         if (!empty($payment1)) {
             $detPayment = $this->detPaymentRepo->verPagosAdelantados($payment1->id);
             if (!empty($detPayment)) {
                 foreach ($detPayment as $detPayment) {
                     $request->merge(["estado" => 0]);
                     $SaldosTemporales = $this->pendientAccountRepo->find2($detPayment['Saldo_F']);
                     if ($SaldosTemporales != null) {
                         $request->merge(['Saldo' => $SaldosTemporales->Saldo + $detPayment['montoPagado']]);
                         $request->merge(['orderPurchase_id' => $SaldosTemporales->orderPurchase_id]);
                         $request->merge(['supplier_id' => $SaldosTemporales->supplier_id]);
                         $insercount = new PendientAccountManager($SaldosTemporales, $request->all());
                         $insercount->save();
                     } else {
                         $request->merge(['orderPurchase_id' => $request->input('id')]);
                         $request->merge(['Saldo' => $payment1->Acuenta]);
                         $insercount = new PendientAccountManager($pendientAccount, $request->all());
                         $insercount->save();
                     }
                 }
                 ///================solucion Errores==================================
             } else {
                 $request->merge(['orderPurchase_id' => $request->input('id')]);
                 $request->merge(['Saldo' => $payment1->Acuenta]);
                 $insercount = new PendientAccountManager($pendientAccount, $request->all());
                 $insercount->save();
                 $provicional = $request->idpayment;
             }
             //==========================fin
         }
     } else {
         //===================================UpdateOrderPurchase===========================================
         if ($request->input('estado') == 1) {
             $request->merge(["Estado" => 1]);
             // var_dump($request->input("Estado"));die();
             $orderPurchase = $this->orderPurchaseRepo->find($request->id);
             //var_dump($orderPurchase->Estado);die();
             $ordercompra = new OrderPurchaseManager($orderPurchase, $request->except('fechaPedido', 'fechaPrevista', 'montoBruto', 'montoTotal', 'descuento'));
             $ordercompra->save();
             if ($this->orderPurchaseRepo->validateDate(substr($request->input('fechaPedido'), 0, 10)) and $this->orderPurchaseRepo->validateDate(substr($request->input('fechaPrevista'), 0, 10))) {
                 $orderPurchase->fechaPedido = substr($request->input('fechaPedido'), 0, 10);
                 $orderPurchase->fechaPrevista = substr($request->input('fechaPrevista'), 0, 10);
             } else {
                 $orderPurchase->fechaPedido = null;
                 $orderPurchase->fechaPrevista = null;
             }
             $orderPurchase->save();
             $verSiExiste = $this->detailOrderPurchaseRepo->Comprobar($request->id);
             //***************************************************************
             if (!empty($verSiExiste[0])) {
                 //var_dump("no deve entrar");die();
                 $orderPurchase->detPres()->detach();
                 foreach ($var as $object1) {
                     //$hola=$var[$n];
                     //$object[]
                     $object1["Cantidad_Ll"] = $object1["cantidad1"];
                     $object1["pendiente"] = floatval($object1["cantidad"]) - floatval($object1["cantidad1"]);
                     /*if(!empty($object1["cantidad1"])){
                           //var_dump("holay".$object1["cantidad1"]);die();
                           //$object1["cantidad"]=$object1["Cantidad_Ll"];
                           //$object1["pendiente"]=$object1["pendiente"];
                           $object1["montoBruto"]=floatval($object1["cantidad"])*floatval($object1["preProducto"]);
                           $object1["montoTotal"]=floatval($object1["montoBruto"])-((floatval($object1["montoBruto"])*floatval($object1["descuento"]))/100);
                       }else{
                           //var_dump("dos".$object1["cantidad1"]);die();
                         
                           if($object1["Cantidad_Ll"]=='0' && $object1["montoBruto"]=='0'){
                             $object1["Cantidad_Ll"]=0;
                             $object1["pendiente"]=$object1["cantidad"];
                             $object1["montoBruto"]=floatval($object1["cantidad"])*floatval($object1["preProducto"]);
                             $object1["montoTotal"]=floatval($object1["montoBruto"])-((floatval($object1["montoBruto"])*floatval($object1["descuento"]))/100);
                           }else{
                               if($object1["Cantidad_Ll"]>0){
                                    $object1["Cantidad_Ll"]=$object1["cantidad"];
                                    $object1["pendiente"]=0;
                                    $object1["montoBruto"]=floatval($object1["cantidad"])*floatval($object1["preProducto"]);
                                    $object1["montoTotal"]=floatval($object1["montoBruto"])-((floatval($object1["montoBruto"])*floatval($object1["descuento"]))/100);
                               }else{  
                                    $object1["Cantidad_Ll"]=$object1["cantidad"];
                                    $object1["pendiente"]=0;
                                    $object1["montoBruto"]=floatval($object1["cantidad"])*floatval($object1["preProducto"]);
                                    $object1["montoTotal"]=floatval($object1["montoBruto"])-((floatval($object1["montoBruto"])*floatval($object1["descuento"]))/100);
                           }
                         }
                       
                       }*/
                     ////if($hola->cantidad1!=null){
                     ////    $object1["Cantidad_Ll"]=$hola->Cantidad_Ll;
                     ////    $object1["pendiente"]=$hola->pendiente;
                     ////
                     ////}else{
                     ////    $object1["Cantidad_Ll"]=$object1["cantidad"];
                     ////    $object1["pendiente"]=0;
                     ////}
                     //var_dump($hola['Cantidad_Ll']);die();
                     if (floatval($object1["preCompra"]) > 0) {
                         $detailOrderPurchaseRepox = new DetailOrderPurchaseRepo();
                         $insertar = new DetailOrderPurchaseManager($detailOrderPurchaseRepox->getModel(), $object1);
                         $insertar->save();
                         $detailOrderPurchaseRepox = null;
                         //$n++;
                     }
                 }
                 //   var_dump($var);die();
             }
         }
         //==============================================================================
         $codOrder = $request->input("orderPurchase_id");
         $fechaActual = $request->input("fecha");
         //var_dump($fechaActual);die();
         //=============================Creando compra =============================
         //var_dump($var); die();
         $manager = new PurchaseManager($purchase, $request->except('fechaEntrega'));
         $manager->save();
         if ($this->purchaseRepo->validateDate(substr($request->input('fechaEntrega'), 0, 10))) {
             $purchase->fechaEntrega = substr($request->input('fechaEntrega'), 0, 10);
         } else {
             $purchase->fechaEntrega = null;
         }
         $purchase->save();
         $temporal = $purchase->id;
         // return $temporal;
         $request->merge(["purchase_id" => $temporal]);
         $detailPurchaseRepox;
         $consulPayment = null;
         //$almacen_id=$request->input("warehouses_id");
         //========================================================================
         $total = 0;
         foreach ($var as $object) {
             //========================insertDEtalles=========================
             $object['orderPurchase_id'] = $codOrder;
             $object['purchases_id'] = $temporal;
             $object['purchase_id'] = $temporal;
             $object['Fecha'] = $fechaActual;
             $object['warehouse_id'] = $almacen_id;
             $object["variant_id"] = $object["Codigovar"];
             $stockmodel = new StockRepo();
             $stockac = $stockmodel->encontrar($object["variant_id"], $almacen_id);
             if ($request->input('estado') == 1) {
                 // var_dump($object1["cantidad1"]);
                 $cantidadReal = $object["cantidad"];
                 $object["cantidad"] = $object["cantidad1"];
                 if ($request->input("tCambio") == "sol") {
                     //var_dump("hola este es soles");die();
                     $object["montoBruto"] = floatval($object["cantidad1"]) * floatval($object["preProducto"]);
                     $object["montoBrutoDolar"] = floatval($object["montoBruto"]) / floatval($request->input("tasaDolar"));
                     $object["montoTotal"] = floatval($object["cantidad1"]) * floatval($object["preCompra"]);
                     $object["montoTotalDolar"] = floatval($object["montoTotal"]) / floatval($request->input("tasaDolar"));
                     $total = $total + $object["montoTotal"];
                 } else {
                     $object["montoBrutoDolar"] = floatval($object["cantidad1"]) * floatval($object["preProductoDolar"]);
                     $object["montoBruto"] = floatval($object["montoBrutoDolar"]) * floatval($request->input("tasaDolar"));
                     $object["montoTotalDolar"] = floatval($object["cantidad1"]) * floatval($object["preCompraDolar"]);
                     $object["montoTotal"] = floatval($object["montoTotalDolar"]) * floatval($request->input("tasaDolar"));
                     $total = $total + $object["montoTotalDolar"];
                 }
                 //  var_dump($object["cantidad"]);
                 /*if(!empty($object["cantidad1"])){
                           $object["cantidad"]=$object["Cantidad_Ll"];
                        }else{
                          if($object["preCompra"]==0){
                                  $object["cantidad"]=$object["cantidad"];
                            }else{
                                  if($object["Cantidad_Ll"]==0 && $object["montoBruto"]==0)
                                  {
                                     $object["cantidad"]=$object["Cantidad_Ll"];
                                  }else{
                                   //if(floatval($object["Cantidad_Ll"])>0){
                                   //   $object["cantidad"]=$object["Cantidad_Ll"]; 
                                   //}else{
                                     $object["cantidad"]=$object["cantidad"];
                                   //}
                              }
                        }
                   }**/
                 //***************************************************
                 // $stockmodel = new StockRepo;
                 //$object['warehouse_id']=$almacen_id;
                 //$object["variant_id"]=$object["Codigovar"];
                 //$stockac=$stockmodel->encontrar($object["variant_id"],$almacen_id);
                 $cantidaCalculada = floatval($object["cantidad1"]) - floatval($object["Cantidad_Ll"]);
                 if ($cantidaCalculada < 0) {
                     $cantidaCalculada = floatval($cantidaCalculada * -1);
                 }
                 /*
                                   if(!empty($object["cantidad1"])){
                                       $cantidaCalculada=floatval($object["cantidad1"])-floatval($object["Cantidad_Ll"]);
                                   }else{ 
                                     if($object["preCompra"]==0){
                                           $cantidaCalculada=floatval($object["cantidad"]);
                                     }else{
                                          if($object["Cantidad_Ll"]==0 && $object["montoBruto"]==0){
                                                $cantidaCalculada=0;
                                           }else{
                                          $cantidaCalculada=floatval($object["cantidad"])-floatval($object["Cantidad_Ll"]);
                                           }
                                     }
                                   }*/
                 //*****************ssss*************************
             } else {
                 $stockmodel = new StockRepo();
                 $object['warehouse_id'] = $almacen_id;
                 $object["variant_id"] = $object["Codigovar"];
                 $cantidaCalculada = $object["cantidad"];
             }
             //$object["cantidad"]=$cantidaCalculada;
             if (intval($object["cantidad"] > 0)) {
                 //var_dump($object);die();
                 $detailPurchaseRepox = new DetailPurchaseRepo();
                 $insertar = new DetailPurchaseManager($detailPurchaseRepox->getModel(), $object);
                 $insertar->save();
                 $detailPurchaseRepox = null;
             }
             if ($request->input('estado') == 1) {
                 $purchase1 = $this->purchaseRepo->find($temporal);
                 if ($request->input("tCambio") == "sol") {
                     $request->merge(['montoBruto' => floatval($total)]);
                     $request->merge(['montoBrutoDolar' => floatval($total) / floatval($request->input("tasaDolar"))]);
                 } else {
                     $request->merge(['montoBrutoDolar' => floatval($total)]);
                     $request->merge(['montoBruto' => floatval($total) * floatval($request->input("tasaDolar"))]);
                 }
                 if (!empty($purchase1->descuento)) {
                     if ($request->input("tCambio") == "sol") {
                         $request->merge(['montoTotal' => floatval($total) - floatval($total) * floatval($purchase1->descuento) / 100]);
                         $request->merge(['montoTotalDolar' => floatval($total) / floatval($request->input("tasaDolar"))]);
                     } else {
                         $request->merge(['montoTotalDolar' => floatval($total) - floatval($total) * floatval($purchase1->descuento) / 100]);
                         $request->merge(['montoTotal' => floatval($total) * floatval($request->input("tasaDolar"))]);
                     }
                 } else {
                     if ($request->input("tCambio") == "sol") {
                         $request->merge(['montoTotal' => floatval($total)]);
                         $request->merge(['montoTotalDolar' => floatval($total) / floatval($request->input("tasaDolar"))]);
                     } else {
                         $request->merge(['montoTotalDolar' => floatval($total)]);
                         $request->merge(['montoTotal' => floatval($total) * floatval($request->input("tasaDolar"))]);
                     }
                 }
                 $manager = new PurchaseManager($purchase1, $request->except('fechaEntrega'));
                 $manager->save();
             }
             //======================Si Existe Stock Pendiente Por Agregar===============================
             $inputStock = $this->inputStockRepo->getModel();
             $object["warehouses_id"] = $request->input("warehouses_id");
             $object["cantidad_llegado"] = $cantidaCalculada;
             $object['descripcion'] = 'Entrada por compra';
             $object['tipo'] = 'Compra';
             if (!empty($cantidadReal)) {
                 if (floatval($cantidadReal) > 0) {
                     if (!empty($stockac)) {
                         $object["stockActual"] = $stockac->stockActual + $cantidaCalculada;
                         if ($object["Cantidad_Ll"] > 0) {
                             $object["porLlegar"] = floatval($stockac->porLlegar) - floatval($cantidaCalculada);
                         } else {
                             $object["porLlegar"] = floatval($stockac->porLlegar) - floatval($cantidadReal);
                         }
                         //======================Actualizando stock si es que variante existe===============================
                         $manager = new StockManager($stockac, $object);
                         $manager->save();
                         $stock = null;
                     } else {
                         if (!empty($stockac->porLlegar)) {
                             $object["porLlegar"] = floatval($stockac->porLlegar) - floatval($object["cantidad"]);
                         } else {
                             $object["porLlegar"] = 0;
                         }
                         //======================Registrando estock si es que variante no existe===============================
                         $manager = new StockManager($stockmodel->getModel(), $object);
                         $manager->save();
                         $stockmodel = null;
                     }
                     $stockac = null;
                 }
             }
             if ($cantidaCalculada > 0) {
                 ////======================Registrando en notas de cabecera===============================
                 if ($codigoHeadIS === 0 && $cantidaCalculada > 0) {
                     $headInputStock = $this->headInputStockRepo->getModel();
                     //var_dump($object);die();
                     $object["user_id"] = auth()->user()->id;
                     $inserHeadInputStock = new HeadInputStockManager($headInputStock, $object);
                     $inserHeadInputStock->save();
                     $codigoHeadIS = $headInputStock->id;
                 }
                 ////======================Registrando en notas de detalles===============================cantidad_llegado
                 //if(!empty($object["equivalencia"])){
                 //  if($object["equivalencia"]>0){
                 //    $object["cantidad_llegado"]=$object["cantidad_llegado"]*$object["equivalencia"];
                 //  }
                 //}
                 $object['headInputStock_id'] = $codigoHeadIS;
                 $inserInputStock = new inputStockManager($inputStock, $object);
                 $inserInputStock->save();
             }
         }
         //======================Creando reporte por cada linea de detalle de compra===============================
         //====================Creando y actualizando pagos si que existe adelantos====================================
         if ($request->input('compraDirecta') == 1) {
             $request->merge(["Acuenta" => 0]);
             $inserPay = new PaymentManager($payment, $request->all());
             $inserPay->save();
         } else {
             // var_dump($request->orderPurchase_id);die();
             $consulPayment = $this->paymentRepo->paymentById($request->orderPurchase_id);
             if (!empty($consulPayment)) {
                 // var_dump("entrando XD");die();
                 $request->merge(["Acuenta" => $consulPayment->Acuenta]);
                 $request->merge(["Saldo" => floatval($request->input("montoTotal")) - floatval($request->input("Acuenta"))]);
                 //$request->merge(["Acuenta"=>0]);
                 $inserPay = new PaymentManager($consulPayment, $request->all());
                 $inserPay->save();
                 //------------------------------------
                 if (floatval($request->Saldo) < 0) {
                     $request->merge(['Saldo' => floatval($request->Saldo * -1)]);
                     //$request->merge(["estado"=>0]);
                     $insercount = new PendientAccountManager($pendientAccount, $request->except("estado"));
                     $insercount->save();
                 }
             } else {
                 $request->merge(["Acuenta" => 0]);
                 $request->merge(["Saldo" => floatval($request->input("montoTotal")) - floatval($request->input("Acuenta"))]);
                 $inserPay = new PaymentManager($payment, $request->all());
                 $inserPay->save();
                 //$saldoTemp=$inserPay->Saldo;
             }
         }
         //var_dump("recolectando verdadero salfdo".$consulPayment->Saldo);die();
         // if(!empty($consulPayment)){
         // }
         if (!empty($consulPayment)) {
             $detPayment = $this->detPaymentRepo->verPagosAdelantados($consulPayment->id);
             if ($detPayment != null) {
                 foreach ($detPayment as $detPayment) {
                     if ($detPayment->Saldo_F != null) {
                         $saldos = $this->pendientAccountRepo->find2($detPayment['Saldo_F']);
                         if ($saldos != null) {
                             if ($saldos->Saldo == 0) {
                                 $request->merge(['Saldo' => 0]);
                                 $request->merge(['estado' => 1]);
                                 $request->merge(['orderPurchase_id' => $saldos->orderPurchase_id]);
                                 $request->merge(['supplier_id' => $saldos->supplier_id]);
                                 $insercount = new PendientAccountManager($saldos, $request->all());
                                 $insercount->save();
                             }
                         }
                     }
                 }
             }
         }
         ///==========================Registrando saldo Afavor ========================================
     }
     \DB::commit();
     return response()->json(['estado' => true, 'nombres' => $purchase->nombres]);
 }