TRIGGER `Customer_Details`.`Client_Account_Payback_AFTER_INSERT` AFTER INSERT ON `Client_Account_Payback` FOR EACH ROW

declare amountPaid float;
declare amountRamianing float;
declare loanAmount float;

select new.Client_Account_Payback_Amount into amountPaid;

select Client_Account_Borrow_Amount_Remaining
from Client_Account_Borrow
where Client_Account_Borrow_ID = new.Client_Account_Payback_Loan_Borrowed_ID
into amountRamianing;

select Client_Account_Amount_Borrowed
from Client_Account_Borrow
where Client_Account_Borrow_ID = new.Client_Account_Payback_Loan_Borrowed_ID
into loanAmount;


set amountRamianing = amountRamianing + amountPaid;

IF amountRamianing > loanAmount THEN
    UPDATE `Client_Account_Borrow`
    SET `Client_Account_Borrow_Amount_Remaining` = amountRamianing
    WHERE `Client_Account_Borrow_ID` = new.Client_Account_Payback_Loan_Borrowed_ID;
ELSE
    UPDATE `Client_Account_Borrow`
    SET `Client_Account_Borrow_Amount_Remaining` = amountRamianing,
    `Client_Account_Borrow_Paid_Back` = true
    WHERE `Client_Account_Borrow_ID` = new.Client_Account_Payback_Loan_Borrowed_ID;
END IF;