-- CALL gnsp_convert_doc('SOC','503', 'OC', '60')
DROP PROCEDURE IF EXISTS gnsp_convert_doc;

CREATE PROCEDURE gnsp_convert_doc(i_sdoc_type VARCHAR(3), i_sdoc_id VARCHAR(16), i_tdoc_type VARCHAR(3), i_tdoc_id VARCHAR(16))
BEGIN

IF EXISTS(SELECT doc_type,doc_id FROM orders WHERE doc_type = i_sdoc_type AND doc_id = i_sdoc_id) THEN

INSERT INTO orders(doc_id,doc_source_id,provider_id,sysuser_id,amount,date,discount,doc_type,expiration_date,gross_value,iva,service)
SELECT i_tdoc_id,i_sdoc_id,provider_id,sysuser_id,amount,CURDATE(),discount,i_tdoc_type,expiration_date,gross_value,iva,service
FROM orders
WHERE doc_type = i_sdoc_type AND doc_id = i_sdoc_id;


INSERT INTO orders_products(order_id,product_id,amount_received,amount_requested,discount,doc_type,document_supplier,iva,observation,unit_value)

SELECT i_tdoc_id,product_id,amount_received,amount_requested,discount,i_tdoc_type,document_supplier,iva,observation,unit_value
FROM orders_products
WHERE doc_type = i_sdoc_type AND order_id = i_sdoc_id;

END IF;

END;