Untitled

mail@pastecode.io avatarunknown
plain_text
2 months ago
629 B
0
Indexable
Never
CREATE DEFINER=`root`@`localhost` PROCEDURE `sp_create_bill`(
		IN p_StaffId VARCHAR(10), 
		IN p_OrderCusomerId INT, 
		IN p_Tax VARCHAR(20), 
		IN p_FristName VARCHAR(50), 
		IN p_LastName VARCHAR(50)
    )
BEGIN
	DECLARE OldBillId INT;
    
    SELECT BillId INTO OldBillId FROM bill WHERE CustomerOrderId = p_OrderCusomerId;
    
    IF(OldBillId IS NULL) THEN
		INSERT INTO bill (CreateDate, Tax, FristName, LastName, CustomerOrderId, StaffId)
        VALUES (NOW(), p_Tax, p_FristName, p_LastName, p_OrderCusomerId, p_StaffId);
        
		SELECT LAST_INSERT_ID() AS BillId;
	ELSE 
		SELECT OldBillId AS BillId;
	END IF;
END