Monthly Archives: Απρίλιος 2012

Singular Logic: Έλαβον moRE

Posted on by

Τις τεχνολογικές λύσεις που υποστηρίζουν τη συγκέντρωση και μετάδοση των αποτελεσμάτων των Βουλευτικών εκλογών 2012 παρουσίασαν σήμερα το Υπουργείο Εσωτερικών και η εταιρία SingularLogic σε κοινή Συνέντευξη Τύπου που πραγματοποιήθηκε στο Ζάππειο Μέγαρο.

Singular Logic: Έλαβον moRE — Infocom

Tips & Tricks – How connect with Facebook and Twitter from Galaxy

Posted on by
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



Continue reading →

Tips & Tricks – How get all days of range even no values present

Posted on by
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

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 enabled Messenger in Galaxy

Posted on by
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

Β  Β  True
Β Β Β  http://compkos-pc:11090/Messenger


Β  Β 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 !