Translations:TAS:Pokročilé/Pluginy/Input, Output/Import/SolverTech.Tasha.Plugins.IO.Database.config/5/pl

<?xml version="1.0" encoding="utf-8"?> <DatabaseIOSettings xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">

 <ConnectionString>Server=192.168.10.101;Database=StwPh_29454174_2019;User Id=tasha;Password=TasHa2019</ConnectionString>
 <CommandText><![CDATA[

SELECT objednavky.RefADdod AS id ,objednavky.Cislo AS CisloObjednavky ,objednavky.firma AS firma ,objednavky.Firma2 AS name ,objednavky.Ulice2 AS ulice ,objednavky.PSC2 AS psc ,objednavky.Obec2 AS mesto ,0 AS x ,0 AS y ,10 AS duration ,600 AS start1 ,1600 AS end1 ,2 AS precedence ,objednavky.Cislo AS CisloObjednavky ,objednavky.Datum AS DatumDodani ,KcCelkem ,CASE WHEN objednavky.Email IS NULL THEN objednavky.Email2 ELSE objednavky.Email END AS email ,objednavky.Utvar2 AS utvar ,objednavky.Tel AS tel ,objednavky.tel2 AS tel2 ,objednavky.Pozn AS pozn ,objednavky.Pozn2 AS pozn2 ,[StwPh_62742710_2019].[dbo].OBJpol.Mnozstvi AS demand1 ,[StwPh_62742710_2019].[dbo].OBJpol.MJ AS jednotka ,[StwPh_62742710_2019].[dbo].OBJpol.MJKoef AS koeficient ,CONCAT([StwPh_62742710_2019].[dbo].OBJpol.SText,' - ',[StwPh_62742710_2019].[dbo].OBJpol.Pozn) AS info1 FROM [StwPh_62742710_2019].[dbo].[OBJ] AS objednavky LEFT JOIN [StwPh_62742710_2019].[dbo].OBJpol ON objednavky.ID=[StwPh_62742710_2019].[dbo].OBJpol.RefAg WHERE objednavky.Vyrizeno=0 AND objednavky.Datum=>'XXXdateXXX' ]]>

 </CommandText>
 <DbProvider>mssql</DbProvider>

</DatabaseIOSettings>