Protime bug 2020 fix

Rem a faire tourner dans le dossier du programme
Rem Noter le nom du serveur

rem lecture du connect.in
for /f "delims=" %%i in ('type ".\Resource\connect.ini" ^|findstr /i /r "OdbcServer"') do set %%i
for /f "delims=" %%i in ('type ".\Resource\connect.ini" ^|findstr /i /r "OdbcDataBase"') do set %%i


set PathProtime=C:\Program Files\Protime\Protime Premium

echo ARRET DES SERVICES EN COURS...

"%PathProtime%\tools\Pskill" calcserver32.exe
net stop "Protime CalcManager"
net stop "Protime NotifyServer"
net stop "Protime InfoServer"

Rem noter ici le nom du user de la base SQL
set SQL_USER=time_user
Rem noter ici le mot de passe du user SQL
set SQL_PASS=letmein32
Rem Requête qui supprime l’ancien Trigger
osql -U %SQL_USER% -P %SQL_PASS% -S %OdbcServer% -d %OdbcDatabase% -Q " DROP TRIGGER tr_upddate; "
osql -U %SQL_USER% -P %SQL_PASS% -S %OdbcServer% -d %OdbcDatabase% -Q " DROP TRIGGER E_I_CalcRequest; "
Rem Requête qui modifie les dates
osql -U %SQL_USER% -P %SQL_PASS% -S %OdbcServer% -d %OdbcDatabase% -Q "UPDATE BOOKINGS SET BOOKDATE = BOOKDATE + 01000000 WHERE REC_NR IN (SELECT REC_NR FROM BOOKINGS WHERE BOOKDATE < '19500101') "
Rem requête qui crée le trigger bookings
osql -U %SQL_USER% -P %SQL_PASS% -S %OdbcServer% -d %OdbcDatabase% -Q " CREATE TRIGGER [dbo].[E_I_BOOKINGS] ON [dbo].[BOOKINGS] FOR INSERT AS SET NOCOUNT ON; UPDATE BOOKINGS SET BOOKDATE = BOOKDATE + 01000000 WHERE REC_NR IN (SELECT REC_NR FROM inserted WHERE BOOKDATE < '19500101')"
Rem requête qui crée le trigger CalcRequest
osql -U %SQL_USER% -P %SQL_PASS% -S %OdbcServer% -d %OdbcDatabase% -Q "CREATE TRIGGER [dbo].[E_I_CalcRequest] ON [dbo].[CALCREQUEST] FOR INSERT AS UPDATE[dbo].[CALCREQUEST] SET DATEFROM = DATEFROM + 01000000, DATETO=DATETO + 01000000 WHERE DATEFROM < '19500101'"
Rem requête qui nettoie la table CalcRequest
osql -U %SQL_USER% -P %SQL_PASS% -S %OdbcServer% -d %OdbcDatabase% -Q " DELETE FROM [dbo].[CALCREQUEST] "

net start "Protime NotifyServer"
net start "Protime Calcmanager"
net start "protime InfoServer"
pause