CREATE PROCEDURE `fillProducts`()
Begin
 declare i int default 1;
 declare tableSize int;
 declare eachDuration int;
 declare accrSize int;
 declare percent float;
 declare duration int;
 declare actualDur int;
 declare closed int;
 declare d date;
 declare sum decimal;
 declare amount decimal;
 declare k int;
 declare days float default 365.0;
 declare firstAmount int;
 start transaction;

 SELECT COUNT(*) into tableSize FROM deposits;
 SELECT COUNT(*) FROM accruals into accrSize;

 IF accrSize <1 THEN
  set i = 1;
  while (i <= 7) do


    set duration = ( SELECT Duration FROM deposits WHERE ID = i);
    set closed = ( SELECT IsClosed  FROM deposits WHERE ID = i);
    set d = (Select OpenDate FROM deposits WHERE ID = i);
    SELECT Amount FROM deposits WHERE ID = i into firstAmount;



    IF closed >0 THEN
        SELECT ActualDuration into actualDur FROM deposits WHERE deposits.ID =i;
        IF actualDur < duration THEN set percent = 3;
        ELSE set percent = 7;
        END IF;

    ELSE set actualDur = curdate() - d;
        set percent = 7;
    END IF;
    set amount = firstAmount * 5;# / days;
    set eachDuration = 1;
insert into accruals values (i, 2, curdate(), firstAmount, 'asdasd');

    while( eachDuration <= actualDur) do
        #insert into accruals
                #(DepositID, Date, Amount, Description) VALUES ( i, d + eachDuration, amount , "blablabla");
    set eachDuration = eachDuration +1;
    end while;



    set i = i + 1;
  end while;
 END IF;



commit;

end$$

call fillProducts()$$