@echo off

set WEBSITE_DIR=assistenten

rem set USERNAME=sp647642
rem set PASSWORD=n8JcDmZz
rem set FTPSITE=home.telfort.nl

set USERNAME=planningjhdd
set PASSWORD=zxcvbnm
set FTPSITE=ftp.deds.nl


REM gevonden op internet, het zet de datum in %date%
FOR /F "TOKENS=1* DELIMS= " %%A IN ('DATE/T') DO SET CDATE=%%B
FOR /F "TOKENS=1,2 eol=/ DELIMS=/ " %%A IN ('DATE/T') DO SET mm=%%B
FOR /F "TOKENS=1,2 DELIMS=/ eol=/" %%A IN ('echo %CDATE%') DO SET dd=%%B
FOR /F "TOKENS=2,3 DELIMS=/ " %%A IN ('echo %CDATE%') DO SET yyyy=%%B
SET date=%mm%%dd%%yyyy%

REM We gaan eerst even archiveren
mkdir archief\%date%
copy *.xls archief\%date%\
copy *.html archief\%date%\

REM We gaan nu de xls op de website zetten en daarna de html
echo user %USERNAME% %PASSWORD%  > ftp-script
echo binary                     >> ftp-script
echo mkdir archief              >> ftp-script
echo cd archief                 >> ftp-script
echo mkdir %WEBSITE_DIR%        >> ftp-script
echo cd %WEBSITE_DIR%           >> ftp-script
echo mkdir %date%               >> ftp-script
echo put publiceer.bat          >> ftp-script
echo cd %date%                  >> ftp-script
echo mput *.xls                 >> ftp-script
echo cd ..                      >> ftp-script
echo cd ..                      >> ftp-script
echo cd ..                      >> ftp-script
echo mkdir %WEBSITE_DIR%        >> ftp-script
echo cd %WEBSITE_DIR%           >> ftp-script
echo mput *.html                >> ftp-script
echo quit                       >> ftp-script

ftp -i -n -s:ftp-script %FTPSITE%

del ftp-script