Asignar valor a variable en un SP

[jnavarrete2311]

Mira te lo mando mejor sin codigo comentado:

Código MySQL:

-- --------------------------------------------------------------------------------
-- Routine DDL
-- Note: comments before and after the routine body will not be stored by the server
-- --------------------------------------------------------------------------------
DELIMITER $$
 
CREATE DEFINER=`root`@`localhost` PROCEDURE `InsertOrder`(
IN Nombre VARCHAR(100),
IN Apellido VARCHAR(100),
IN TotalPaidNoTax float,
IN TotalConTax float,
IN ShippingNoTax float,
IN ReferenceCode VARCHAR(100),
IN CurrentState INT,
IN Payment VARCHAR(100),
IN Module VARCHAR(100),
IN Tax float
)
BEGIN
 
DECLARE customer_id INT;
SET customer_id = 0;
SELECT id_customer
FROM `ps_customer` 
WHERE firstname = Nombre AND lastname= Apellido
INTO customer_id; 
SELECT customer_id;
 
    set @id_cart = (select MAX(id_cart) from `ps_cart`);
    set @id_address = (select id_address from `ps_address` where firstname = Nombre and lastname= Apellido); 
    set @id_guest = (select id_guest from `ps_guest` where id_customer = @customer_id);
 
            insert into  `ps_cart`(id_shop_group,id_shop,id_carrier,delivery_option,id_lang,
                                   id_address_delivery,id_address_invoice,id_currency,id_customer,
                                   id_guest,secure_key,recyclable,gift,gift_message,allow_seperated_package,
                                   date_add,date_upd
                                   )
            select
                  id_shop_group,id_shop,id_carrier,delivery_option,id_lang,id_address_delivery,
                  id_address_invoice,id_currency,id_customer,id_guest,secure_key,recyclable,gift,
                  gift_message,allow_seperated_package,date_add = CURRENT_TIMESTAMP(),
                  date_upd = CURRENT_TIMESTAMP() 
            from 
                ps_cart where id_cart = @id_cart;
                        
            set @id_cart = (select MAX(id_cart) from ps_cart);
 
            update `ps_cart` set id_guest=@id_guest, id_address_delivery = @id_address, 
                                 id_address_invoice = @id_address, id_customer = @customer_id, 
                                 date_add=CURRENT_TIMESTAMP(),date_upd=CURRENT_TIMESTAMP() 
            where id_cart=@id_cart;
 
            set @id_cart = (select MAX(id_cart) from ps_cart);
            set @id_order_max = (select MAX(id_order) from `ps_orders`);
            set @invoice_number = (select invoice_number from `ps_orders` where id_order = @id_order_max);
            set @TotalMenosShippingIncl = (TotalPaidNoTax - 2.32); 
            set @TotalProductMenosShipping = (TotalConTax  - 2.32); 
            set @shippingTax = ShippingNoTax + ((ShippingNoTax * Tax)/100); 
            
            insert into `ps_orders`(reference,id_carrier,id_lang,id_customer,id_cart,id_currency,
                                    id_address_delivery,id_address_invoice,current_state,secure_key,
                                    payment,conversion_rate,module,gift_message,shipping_number,
                                    total_paid,total_paid_tax_incl,total_paid_tax_excl,total_paid_real,
                                    total_products,total_products_wt,total_shipping,total_shipping_tax_incl,
                                    total_shipping_tax_excl,carrier_tax_rate,date_add,date_upd
                                    )
                              values(
                                    ReferenceCode,2,4,@customer_id,@id_cart,1,@id_address,@id_address,
                                    CurrentState,'91b5b10c93a6f626f8e6154b32279510',Payment,
                                    1.000000,Module,'','',TotalConTax,TotalConTax,TotalPaidNoTax,
                                    0.00,@TotalMenosShippingIncl,@TotalProductMenosShipping,@shippingTax,
                                    @shippingTax,ShippingNoTax,Tax,CURRENT_TIMESTAMP(),CURRENT_TIMESTAMP()
                                    );
END