El carrito de la compra está vacío!
Has Click aquí para continuar comprando.
STRCompra

{"options":{"id":"B56A4893-2844-47E5-A057-0A00BE73A767","DBToken":"SEVEN202102USIC","idTienda":"tienda-1","es":"router","Lead":{"id":"fvr4WeQ2i50k7rwiCzgpSO2J6pP81fMLAwNPZ4TcHhfsCoYDvG","codi":332723},"singlePage":1,"alldata":1,"noCloseConnection":1},"alldata":1,"initoptions":{"id":"B56A4893-2844-47E5-A057-0A00BE73A767","DBToken":"SEVEN202102USIC","idTienda":"tienda-1","es":"router","Lead":{"id":"fvr4WeQ2i50k7rwiCzgpSO2J6pP81fMLAwNPZ4TcHhfsCoYDvG","codi":332723},"singlePage":1,"alldata":1,"noCloseConnection":1},"sql":"\n DECLARE @client int,@tipo varchar(59);\n SET @tipo ='pedTienda';\n SET @client = 332723;\n\n if NOT EXISTS(select num from webspedidosNoms where client = @client and tipo = @tipo and (ISNULL(comandesId,0) = 0 OR swProcesado IS NULL)) begin\n Declare @num int;\n select @num = (select isnull(max(num),0) from webspedidosNoms) + 1;\n insert into webspedidosNoms (num, client, fecha,tipo ) values (@num, @client,getdate(),@tipo )\n select num, nom, client, fecha\n from webspedidosNoms where num = @num\n\n end else begin\n select TOP 1 num, nom, client, fecha,\n swConfirmado, ISNULL(comandesId,0) as comandesId,\n swRecogidaEnTienda,swKubyPasarela, direccionEnvio, domicilioEnvio, ISNULL(comentari,'') as observaciones\n from webspedidosNoms where client = @client and tipo = @tipo and (ISNULL(comandesId,0) = 0 OR swProcesado IS NULL) order by num DESC\n end\n ","pedido":{"num":564,"nom":null,"client":332723,"fecha":"2021-11-29T03:34:57.120Z","subtotal":0},"articulos":null,"noitems":true}