use location;
CREATE TABLE IF NOT EXISTS `calendrier` (
  `jours` date  primary key
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
drop procedure if exists pr_calendrier;

delimiter //
create procedure pr_calendrier(in nb int, out nb_jours_we int, out dernier_jour varchar(50))
begin
  declare cpt int;
  declare datej datetime;
  declare sauv_datej  datetime;
  DELETE FROM calendrier;
  set cpt = 0;
  set nb_jours_we=0;
  
  while cpt < nb
  do
    set datej = date_add(current_date(),interval cpt day);
    
    if dayofweek(datej)!=1 and dayofweek(datej)!=7 then
		insert into calendrier values (datej);
	else
		set nb_jours_we=nb_jours_we+1;
    end if;
    set cpt   = cpt + 1;
    set sauv_datej=datej;
  end while;
  set dernier_jour=DATE_FORMAT(sauv_datej,'%d-%m-%y');
  
end;
//
delimiter ;
call pr_calendrier(21, @nb, @dernier_jour);
select @nb, @dernier_jour;
-- select @dernier_jour;
select * from calendrier;