Τις τεχνολογικές λύσεις που υποστηρίζουν τη συγκέντρωση και μετάδοση των αποτελεσμάτων των Βουλευτικών εκλογών 2012 παρουσίασαν σήμερα το Υπουργείο Εσωτερικών και η εταιρία SingularLogic σε κοινή Συνέντευξη Τύπου που πραγματοποιήθηκε στο Ζάππειο Μέγαρο.
Monthly Archives: Απρίλιος 2012
Tips & Tricks – How connect with Facebook and Twitter from Galaxy
In this post we learn how we can connect with ours friends in Facebook and Twitter within Galaxy
Choose CRM Setup / Contacts / Social Account
Here you can create your social account but first you must create a facebook app atΒ https://developers.facebook.com/appsΒ or a twitter app atΒ https://dev.twitter.com/Β Β and fill proper fields in Social Account
Choose CRM Setup / Contacts / Social Account
Here you can create your social account but first you must create a facebook app atΒ https://developers.facebook.com/appsΒ or a twitter app atΒ https://dev.twitter.com/Β Β and fill proper fields in Social Account
SingularLogic Galaxy presentation
Tips & Tricks – How get all days of range even no values present
In this post we learn how we can get all days of range even no values present in these days
For example we get for a range of days balance of stocks even no transaction made in some of days in range
Β
Sql that return values for above sample is below
Β
with cte as
(
select dte = CONVERT(datetime,SUBSTRING(CAST(‘@DateFrom’ AS VARCHAR),1,CHARINDEX(‘ ‘, CAST(‘@DateFrom’ AS VARCHAR)) – 1),103)
union all
select DATEADD(dd,1,dte) from cte where dte < CONVERT(datetime,SUBSTRING(CAST(‘@DateTo’ AS VARCHAR),1,CHARINDEX(‘ ‘, CAST(‘@DateTo’ AS VARCHAR)) – 1),103))
select CONVERT(nvarchar,cte.dte,103), GXITEM.GXCODE ITEMCODE,GXITEM.GXDESCRIPTION,GXWAREHOUSE.GXCODE WAREHOUSECODE ,
dbo.GXGETITEMSUMDATEWRHSSTTP(GXITEMCOMPANYPROP.GXITEMID,’743D7942-4CCB-474B-B140-06011F6795CC’ ,cte.dte,’Bal_A’,
GXWAREHOUSE.GXID,’585BA65A-3BF4-426B-A7B7-B7F0C007BF52′) BALANCE
FROM cte,GXWAREHOUSE,
GXITEMCOMPANYPROP inner join GXITEM ON GXITEMCOMPANYPROP.GXITEMID=GXITEM.GXID
WHEREΒ
(
GXITEMCOMPANYPROP.GXITEMID in (select GXITEMACCUM.GXITEMID FROM GXITEMACCUM WHEREΒ
GXITEMACCUM.GXDATE>=CONVERT(datetime,SUBSTRING(CAST(‘@DateFrom’ AS VARCHAR),1,CHARINDEX(‘ ‘, CAST(‘@DateFrom’ AS VARCHAR)) – 1),103) AND GXITEMACCUM.GXDATE<=CONVERT(datetime,SUBSTRING(CAST(‘@DateTo’ AS VARCHAR),1,CHARINDEX(‘ ‘, CAST(‘@DateTo’ AS VARCHAR)) – 1),103)
AND GXITEMACCUM.GXWRHSID=GXWAREHOUSE.GXID )
or
dbo.GXGETITEMSUMDATEWRHSSTTP(GXITEMCOMPANYPROP.GXITEMID,’743D7942-4CCB-474B-B140-06011F6795CC’ ,CONVERT(datetime,SUBSTRING(CAST(‘@DateFrom’ AS VARCHAR),1,CHARINDEX(‘ ‘, CAST(‘@DateFrom’ AS VARCHAR)) – 1),103),’Bal_A’,
GXWAREHOUSE.GXID,’585BA65A-3BF4-426B-A7B7-B7F0C007BF52′)<>0)
@where
ORDER BY GXITEM.GXCODE,CTE.dte
(
select dte = CONVERT(datetime,SUBSTRING(CAST(‘@DateFrom’ AS VARCHAR),1,CHARINDEX(‘ ‘, CAST(‘@DateFrom’ AS VARCHAR)) – 1),103)
union all
select DATEADD(dd,1,dte) from cte where dte < CONVERT(datetime,SUBSTRING(CAST(‘@DateTo’ AS VARCHAR),1,CHARINDEX(‘ ‘, CAST(‘@DateTo’ AS VARCHAR)) – 1),103))
select CONVERT(nvarchar,cte.dte,103), GXITEM.GXCODE ITEMCODE,GXITEM.GXDESCRIPTION,GXWAREHOUSE.GXCODE WAREHOUSECODE ,
dbo.GXGETITEMSUMDATEWRHSSTTP(GXITEMCOMPANYPROP.GXITEMID,’743D7942-4CCB-474B-B140-06011F6795CC’ ,cte.dte,’Bal_A’,
GXWAREHOUSE.GXID,’585BA65A-3BF4-426B-A7B7-B7F0C007BF52′) BALANCE
FROM cte,GXWAREHOUSE,
GXITEMCOMPANYPROP inner join GXITEM ON GXITEMCOMPANYPROP.GXITEMID=GXITEM.GXID
WHEREΒ
(
GXITEMCOMPANYPROP.GXITEMID in (select GXITEMACCUM.GXITEMID FROM GXITEMACCUM WHEREΒ
GXITEMACCUM.GXDATE>=CONVERT(datetime,SUBSTRING(CAST(‘@DateFrom’ AS VARCHAR),1,CHARINDEX(‘ ‘, CAST(‘@DateFrom’ AS VARCHAR)) – 1),103) AND GXITEMACCUM.GXDATE<=CONVERT(datetime,SUBSTRING(CAST(‘@DateTo’ AS VARCHAR),1,CHARINDEX(‘ ‘, CAST(‘@DateTo’ AS VARCHAR)) – 1),103)
AND GXITEMACCUM.GXWRHSID=GXWAREHOUSE.GXID )
or
dbo.GXGETITEMSUMDATEWRHSSTTP(GXITEMCOMPANYPROP.GXITEMID,’743D7942-4CCB-474B-B140-06011F6795CC’ ,CONVERT(datetime,SUBSTRING(CAST(‘@DateFrom’ AS VARCHAR),1,CHARINDEX(‘ ‘, CAST(‘@DateFrom’ AS VARCHAR)) – 1),103),’Bal_A’,
GXWAREHOUSE.GXID,’585BA65A-3BF4-426B-A7B7-B7F0C007BF52′)<>0)
@where
ORDER BY GXITEM.GXCODE,CTE.dte
Let’s see some part of sql command
Β
Β
with cte as
(
select dte = CONVERT(datetime,SUBSTRING(CAST(‘@DateFrom’ AS VARCHAR),1,CHARINDEX(‘ ‘, CAST(‘@DateFrom’ AS VARCHAR)) – 1),103)
union all
select DATEADD(dd,1,dte) from cte where dte < CONVERT(datetime,SUBSTRING(CAST(‘@DateTo’ AS VARCHAR),1,CHARINDEX(‘ ‘, CAST(‘@DateTo’ AS VARCHAR)) – 1),103))
Tips & Tricks – How enable your pop3 e-mail account in Galaxy
In this post we learn how we can enable your pop3 e-mail account in Galaxy
Note : You must have CRM Galaxy module enabled
Note : You must have CRM Galaxy module enabled
First run Glx.Config and enable Scheduler
Β
Restart Galaxy Server
Login in Galaxy
Choose Profile / Workpost
Β
Tips & Tricks – Basic customization Galaxy Browsers
In this post we learn how we can make basic customization to Galaxy Browsers
First we must choose Settings / Installation / Options and change the field Browser List mode to Windows Grid.
Tips & Tricks – How enabled Messenger in Galaxy
To enableΒ MessengerΒ in Β GalaxyΒ applicationΒ takes 3Β steps
1. Go toΒ C:\Galaxy\Config\MessengerΒ
Β Β OpenΒ theΒ fileΒ Messenger with notepad .ModifyΒ these 2Β lines
Β Β
Β Β Β
Β Β ForΒ compkos–pcΒ write theΒ name of yoursΒ GalaxyΒ Server
2.Β Login in Galaxy applicationΒ and selectΒ
Β Β SettingsΒ / Installation
Β Β SelectΒ MessengerΒ address field andΒ put theΒ addressΒ thatΒ you specifiedΒ above.
3.Β ChooseΒ fromΒ theΒ Widgets toolbarΒ Β MessengerΒ and ifΒ other usersΒ activate theΒ MessengerΒ on their desktop chooseΒ anyone you wantΒ and startΒ theΒ conversation
Note : To see yours messages the user that you choosed Β , he must choose in Messenger widget you and open dialog chat windowΒ
Happy chat !
SingularLogic Galaxy TV Spot
Compkos Software Blog journey begin !
Compkos Software Blog start its journey today
Welcome passengers !
Welcome passengers !