alta_venta

// ==================================================
//        Lista 
// ==================================================
altaVenta(req: Request, res: Response) {


    var pIdVendedor = req.params.IdPersona;

    var pIdCliente = req.body[0];
    var pLineaVenta = req.body[1];
    var pLineaTipoPago = req.body[2];
    var pMontoTotal = req.body[3];
    var pFechaVenta = req.body[4];

    pool.query(`call bsp_alta_venta('${pIdVendedor}','${pIdCliente}','${pMontoTotal}','${pFechaVenta}')`, function(err: any, result: any){

        console.log("result es : ",result);
        console.log("err es : ",err);

       if(err){
            logger.error("Error bsp_alta_venta - altaVenta - ventasController " + err);

            pool.query(`call bsp_alta_log('${pIdVendedor}',"${String(result[0][0].Message)}",'ventasController','${result[0][0].Code}','bsp_alta_venta','${err}')`);

            res.status(404).json(err);
            return;
       }      

       // ==============================
       if(result[0][0].Mensaje == 'Ok')
       {

            pLineaVenta.forEach(function (value: any) {

                pool.query(`call bsp_alta_linea_venta('${result[0][0].IdVenta}','${value.IdProductoSabor}','${result[0][0].pIdSucursal}','${value.Cantidad}')`, function(err: any, result2: any){

                    console.log("result2 es : ",result2);
                    console.log("err2 es : ",err);

                    if(err || result2[0][0].Mensaje != 'Ok'){

                        logger.error("Error bsp_alta_venta 2 - altaVenta - ventasController " + err);

                        pool.query(`call bsp_alta_log('${pIdVendedor}',"${String(result2[0][0].Message)}",'ventasController','${result2[0][0].Code}','bsp_alta_venta','${err}')`);

                        res.status(404).json(err);
                        return;
                    }
                    
                    // ==============================
                    if(result2[0][0].Mensaje == 'Ok')
                    {             
                        pLineaTipoPago.forEach(function (value: any) {
             
                             pool.query(`call bsp_alta_tipo_pago('${result[0][0].IdVenta}','${value.IdTipoPago}','${value.SubTotal}','${pIdCliente}')`, function(err: any, result3: any){

                                console.log("result3 es : ",result3);
                                console.log("err3 es : ",err);
                                
                                if(err){
                                    logger.error("Error bsp_alta_venta 3 - altaVenta - ventasController " + err);

                                    pool.query(`call bsp_alta_log('${pIdVendedor}',"${String(result3[0][0].Message)}",'ventasController','${result3[0][0].Code}','bsp_alta_venta','${err}')`);
            
                                     return;
                                 }

                                 res.send(result3);
                             })
                         });
                     }
                     else{
                        logger.error("Error bsp_alta_venta 4 - altaVenta - ventasController " + err);
                     }
                    // =============================
                    // res.json(result);
                })
            });
        }
        else
        {
            logger.error("Error bsp_alta_venta - altaVenta - ventasController " + err);

            pool.query(`call bsp_alta_log('${pIdVendedor}',"Error alta venta",'ventasController','${result}','bsp_alta_venta','${err}')`);
            
            res.status(400).json(result);
           return;
        }
        // ==============================
   })

}