https://wiki.catglobe.com/api.php?action=feedcontributions&feedformat=atom&user=Lekhacbaongoc Catglobe Wiki - User contributions [en] 2026-04-08T17:39:15Z User contributions MediaWiki 1.43.0 https://wiki.catglobe.com/index.php?title=PptTabulationTable_class&diff=25576 PptTabulationTable class 2016-08-05T04:40:08Z <p>Lekhacbaongoc: </p> <hr /> <div>&lt;br/&gt;{{CGscriptClass_Template<br /> |Name=PptTabulationTable<br /> |Description=A table PPT element wrapper for use in tabulation. Calling a TabulationScript from a powerponumber must return atleast 1 PPT element.<br /> |Constructors=<br /> {{CGscriptConstructors_Template|Parameters=<br /> {{CGscriptParameters_Template|Type=number|Name=tableid|Description=The return value from createCrossDiagram or createFrequencyDiagram.}}<br /> |Description=Create a table for use in power ponumber.}}<br /> {{CGscriptConstructors_Template|Parameters=<br /> {{CGscriptParameters_Template|Type=number|Name=tableid|Description=The return value from createCrossDiagram or createFrequencyDiagram.|Comma=,}}{{CGscriptParameters_Template|Type=number|Name=top|Description=See Top.|Comma=,}}{{CGscriptParameters_Template|Type=number|Name=left|Description=See Left.|Comma=,}}{{CGscriptParameters_Template|Type=number|Name=width|Description=See Width.|Comma=,}}{{CGscriptParameters_Template|Type=number|Name=height|Description=See Height.}}<br /> |Description=Create a table for use in power ponumber with position.}}<br /> |Methods=<br /> {{CGscriptMethods_Template|ReturnType=string|Name=ToString|Description=The string representation of the object.}}<br /> |Properties=<br /> {{CGscriptProperties_Template|ReturnType=number|Name=Height|HasGetter=1|HasSetter=1|Description=Get/set Height of element in pct of slide. -1 == use Height of element. For tables, 0 == 5% per row.}}<br /> {{CGscriptProperties_Template|ReturnType=number|Name=Left|HasGetter=1|HasSetter=1|Description=Get/set Left offset in pct from UpperLeftCorner. -1 == use positioning of element.}}<br /> {{CGscriptProperties_Template|ReturnType=string|Name=ObjectTypeName|HasGetter=1|Description=The name of the type of object.}}<br /> {{CGscriptProperties_Template|ReturnType=number|Name=Top|HasGetter=1|HasSetter=1|Description=Get/set Top offset in pct from UpperLeftCorner. -1 == use positioning of element.}}<br /> {{CGscriptProperties_Template|ReturnType=TypeInformation|Name=TypeInformation|HasGetter=1|Description=Get information about this class.}}<br /> {{CGscriptProperties_Template|ReturnType=number|Name=Width|HasGetter=1|HasSetter=1|Description=Get/set Width of element in pct of slide. -1 == use Width of element. For tables, 0 == 5% per column.}}<br /> {{CGscriptProperties_Template|ReturnType=number|Name=ZIndex|HasGetter=1|HasSetter=1|Description=Get/set ZIndex of element. -1 == use ZIndex of element.}}<br /> }}<br /> <br /> ==== &lt;span style=&quot;color:#a52a2a&quot;&gt;'''Examples'''&lt;/span&gt; ====<br /> <br /> Type the below script into CGScript prompt to get its result: <br /> &lt;source lang=&quot;javascript&quot;&gt;<br /> Update soon!<br /> &lt;/source&gt;</div> Lekhacbaongoc https://wiki.catglobe.com/index.php?title=PptTabulationTable_class&diff=25575 PptTabulationTable class 2016-08-05T04:35:47Z <p>Lekhacbaongoc: </p> <hr /> <div><br /> <br /> {{CGscriptClass_Template<br /> |Name=&lt;nowiki&gt;PptTabulationTable&lt;/nowiki&gt;<br /> |Description=&lt;nowiki&gt;A table PPT element wrapper for use in tabulation. Calling a TabulationScript from a powerponumber must return atleast 1 PPT element.&lt;/nowiki&gt;<br /> |Constructors=<br /> {{CGscriptConstructors_Template|Parameters=<br /> {{CGscriptParameters_Template|Type=number|Name=&lt;nowiki&gt;tableid&lt;/nowiki&gt;|Description=&lt;nowiki&gt;The return value from createCrossDiagram or createFrequencyDiagram.&lt;/nowiki&gt;}}<br /> |Description=&lt;nowiki&gt;Create a table for use in power ponumber.&lt;/nowiki&gt;}}<br /> {{CGscriptConstructors_Template|Parameters=<br /> {{CGscriptParameters_Template|Type=number|Name=&lt;nowiki&gt;tableid&lt;/nowiki&gt;|Description=&lt;nowiki&gt;The return value from createCrossDiagram or createFrequencyDiagram.&lt;/nowiki&gt;|Comma=,}}{{CGscriptParameters_Template|Type=number|Name=&lt;nowiki&gt;top&lt;/nowiki&gt;|Description=&lt;nowiki&gt;See Top.&lt;/nowiki&gt;|Comma=,}}{{CGscriptParameters_Template|Type=number|Name=&lt;nowiki&gt;left&lt;/nowiki&gt;|Description=&lt;nowiki&gt;See Left.&lt;/nowiki&gt;|Comma=,}}{{CGscriptParameters_Template|Type=number|Name=&lt;nowiki&gt;width&lt;/nowiki&gt;|Description=&lt;nowiki&gt;See Width.&lt;/nowiki&gt;|Comma=,}}{{CGscriptParameters_Template|Type=number|Name=&lt;nowiki&gt;height&lt;/nowiki&gt;|Description=&lt;nowiki&gt;See Height.&lt;/nowiki&gt;}}<br /> |Description=&lt;nowiki&gt;Create a table for use in power ponumber with position.&lt;/nowiki&gt;}}<br /> |Methods=<br /> {{CGscriptMethods_Template|ReturnType=string|Name=&lt;nowiki&gt;ToString&lt;/nowiki&gt;|Description=&lt;nowiki&gt;The string representation of the object.&lt;/nowiki&gt;}}<br /> |Properties=<br /> {{CGscriptProperties_Template|ReturnType=number|Name=&lt;nowiki&gt;Height&lt;/nowiki&gt;|HasGetter=1|HasSetter=1|Description=&lt;nowiki&gt;Get/set Height of element in pct of slide. -1 == use Height of element. For tables, 0 == 5% per row.&lt;/nowiki&gt;}}<br /> {{CGscriptProperties_Template|ReturnType=number|Name=&lt;nowiki&gt;Left&lt;/nowiki&gt;|HasGetter=1|HasSetter=1|Description=&lt;nowiki&gt;Get/set Left offset in pct from UpperLeftCorner. -1 == use positioning of element.&lt;/nowiki&gt;}}<br /> {{CGscriptProperties_Template|ReturnType=string|Name=&lt;nowiki&gt;ObjectTypeName&lt;/nowiki&gt;|HasGetter=1|Description=&lt;nowiki&gt;The name of the type of object.&lt;/nowiki&gt;}}<br /> {{CGscriptProperties_Template|ReturnType=number|Name=&lt;nowiki&gt;Top&lt;/nowiki&gt;|HasGetter=1|HasSetter=1|Description=&lt;nowiki&gt;Get/set Top offset in pct from UpperLeftCorner. -1 == use positioning of element.&lt;/nowiki&gt;}}<br /> {{CGscriptProperties_Template|ReturnType=TypeInformation|Name=&lt;nowiki&gt;TypeInformation&lt;/nowiki&gt;|HasGetter=1|Description=&lt;nowiki&gt;Get information about this class.&lt;/nowiki&gt;}}<br /> {{CGscriptProperties_Template|ReturnType=number|Name=&lt;nowiki&gt;Width&lt;/nowiki&gt;|HasGetter=1|HasSetter=1|Description=&lt;nowiki&gt;Get/set Width of element in pct of slide. -1 == use Width of element. For tables, 0 == 5% per column.&lt;/nowiki&gt;}}<br /> {{CGscriptProperties_Template|ReturnType=number|Name=&lt;nowiki&gt;ZIndex&lt;/nowiki&gt;|HasGetter=1|HasSetter=1|Description=&lt;nowiki&gt;Get/set ZIndex of element. -1 == use ZIndex of element.&lt;/nowiki&gt;}}<br /> }}</div> Lekhacbaongoc https://wiki.catglobe.com/index.php?title=PptTabulationTable_class&diff=25574 PptTabulationTable class 2016-08-05T04:35:22Z <p>Lekhacbaongoc: </p> <hr /> <div><br /> <br /> {{CGscriptClass_Template<br /> |Name=&lt;nowiki&gt;PptTabulationTable&lt;/nowiki&gt;<br /> |Description=&lt;nowiki&gt;A table PPT element wrapper for use in tabulation. Calling a TabulationScript from a powerpoint must return atleast 1 PPT element.&lt;/nowiki&gt;<br /> |Constructors=<br /> {{CGscriptConstructors_Template|Parameters=<br /> {{CGscriptParameters_Template|Type=int|Name=&lt;nowiki&gt;tableid&lt;/nowiki&gt;|Description=&lt;nowiki&gt;The return value from createCrossDiagram or createFrequencyDiagram.&lt;/nowiki&gt;}}<br /> |Description=&lt;nowiki&gt;Create a table for use in power point.&lt;/nowiki&gt;}}<br /> {{CGscriptConstructors_Template|Parameters=<br /> {{CGscriptParameters_Template|Type=int|Name=&lt;nowiki&gt;tableid&lt;/nowiki&gt;|Description=&lt;nowiki&gt;The return value from createCrossDiagram or createFrequencyDiagram.&lt;/nowiki&gt;|Comma=,}}{{CGscriptParameters_Template|Type=number|Name=&lt;nowiki&gt;top&lt;/nowiki&gt;|Description=&lt;nowiki&gt;See Top.&lt;/nowiki&gt;|Comma=,}}{{CGscriptParameters_Template|Type=number|Name=&lt;nowiki&gt;left&lt;/nowiki&gt;|Description=&lt;nowiki&gt;See Left.&lt;/nowiki&gt;|Comma=,}}{{CGscriptParameters_Template|Type=number|Name=&lt;nowiki&gt;width&lt;/nowiki&gt;|Description=&lt;nowiki&gt;See Width.&lt;/nowiki&gt;|Comma=,}}{{CGscriptParameters_Template|Type=number|Name=&lt;nowiki&gt;height&lt;/nowiki&gt;|Description=&lt;nowiki&gt;See Height.&lt;/nowiki&gt;}}<br /> |Description=&lt;nowiki&gt;Create a table for use in power point with position.&lt;/nowiki&gt;}}<br /> |Methods=<br /> {{CGscriptMethods_Template|ReturnType=string|Name=&lt;nowiki&gt;ToString&lt;/nowiki&gt;|Description=&lt;nowiki&gt;The string representation of the object.&lt;/nowiki&gt;}}<br /> |Properties=<br /> {{CGscriptProperties_Template|ReturnType=number|Name=&lt;nowiki&gt;Height&lt;/nowiki&gt;|HasGetter=1|HasSetter=1|Description=&lt;nowiki&gt;Get/set Height of element in pct of slide. -1 == use Height of element. For tables, 0 == 5% per row.&lt;/nowiki&gt;}}<br /> {{CGscriptProperties_Template|ReturnType=number|Name=&lt;nowiki&gt;Left&lt;/nowiki&gt;|HasGetter=1|HasSetter=1|Description=&lt;nowiki&gt;Get/set Left offset in pct from UpperLeftCorner. -1 == use positioning of element.&lt;/nowiki&gt;}}<br /> {{CGscriptProperties_Template|ReturnType=string|Name=&lt;nowiki&gt;ObjectTypeName&lt;/nowiki&gt;|HasGetter=1|Description=&lt;nowiki&gt;The name of the type of object.&lt;/nowiki&gt;}}<br /> {{CGscriptProperties_Template|ReturnType=number|Name=&lt;nowiki&gt;Top&lt;/nowiki&gt;|HasGetter=1|HasSetter=1|Description=&lt;nowiki&gt;Get/set Top offset in pct from UpperLeftCorner. -1 == use positioning of element.&lt;/nowiki&gt;}}<br /> {{CGscriptProperties_Template|ReturnType=TypeInformation|Name=&lt;nowiki&gt;TypeInformation&lt;/nowiki&gt;|HasGetter=1|Description=&lt;nowiki&gt;Get information about this class.&lt;/nowiki&gt;}}<br /> {{CGscriptProperties_Template|ReturnType=number|Name=&lt;nowiki&gt;Width&lt;/nowiki&gt;|HasGetter=1|HasSetter=1|Description=&lt;nowiki&gt;Get/set Width of element in pct of slide. -1 == use Width of element. For tables, 0 == 5% per column.&lt;/nowiki&gt;}}<br /> {{CGscriptProperties_Template|ReturnType=int|Name=&lt;nowiki&gt;ZIndex&lt;/nowiki&gt;|HasGetter=1|HasSetter=1|Description=&lt;nowiki&gt;Get/set ZIndex of element. -1 == use ZIndex of element.&lt;/nowiki&gt;}}<br /> }}</div> Lekhacbaongoc https://wiki.catglobe.com/index.php?title=EmailAccount_getAllGlobalEmails&diff=25573 EmailAccount getAllGlobalEmails 2016-08-03T07:40:51Z <p>Lekhacbaongoc: Created page with &quot;Category:Email_and_SMS_Functions {{HelpFiles}} ===EmailAccount_getAllGlobalEmails=== Get list global emails alias ===Syntax=== EmailAccount_getAllGlobalEmails();...&quot;</p> <hr /> <div>[[Category:Email_and_SMS_Functions]]<br /> {{HelpFiles}}<br /> <br /> ===EmailAccount_getAllGlobalEmails===<br /> <br /> Get list global emails alias<br /> <br /> ===Syntax===<br /> <br /> EmailAccount_getAllGlobalEmails();<br /> <br /> ===Arguments===<br /> <br /> None<br /> <br /> ===Return type===<br /> <br /> array list EmailAccount<br /> <br /> ===Examples===<br /> &lt;source lang=&quot;javascript&quot;&gt;<br /> array globalEmails = EmailAccount_getAllGlobalEmails();<br /> for(number i=0;i&lt;globalEmails.Count;i++)<br /> {<br /> EmailAccount emailAcc = globalEmails[i];<br /> print(&quot;ActualEmail:&quot; + emailAcc.ActualEmail);<br /> print(&quot;Address: &quot; + emailAcc.Address);<br /> print(&quot;Alias: &quot; + emailAcc.Alias);<br /> print(&quot;Default: &quot; + emailAcc.Default);<br /> print(&quot;IsGEA: &quot; + emailAcc.IsGEA);<br /> print(&quot;ResourceId: &quot; + emailAcc.ResourceId);<br /> print(&quot;UseActualEmail: &quot; + emailAcc.UseActualEmail);<br /> print(&quot;--------------------------------------------&quot;);<br /> }<br /> /*<br /> ActualEmail:<br /> Address: system_group@voxmeter.catglobe.com<br /> Alias: System group<br /> Default: True<br /> IsGEA: True<br /> ResourceId: 87<br /> UseActualEmail: False<br /> --------------------------------------------<br /> */<br /> &lt;/source&gt;<br /> __NOTOC__</div> Lekhacbaongoc https://wiki.catglobe.com/index.php?title=EmailAccount_class&diff=25572 EmailAccount class 2016-08-03T07:13:27Z <p>Lekhacbaongoc: </p> <hr /> <div>{{CGscriptClass_Template<br /> |Name=EmailAccount<br /> |Description=Represents an email account.<br /> |Constructors=<br /> {{CGscriptConstructors_Template|Parameters=<br /> {{CGscriptParameters_Template|Type=number|Name=type|Description=2: WebShop, 3: Support}}<br /> |Description=Instanciate an existing email account}}<br /> {{CGscriptConstructors_Template|Parameters=<br /> {{CGscriptParameters_Template|Type=number|Name=type|Description=0: Resource, 1: GlobalEmail, 2: WebShop, 3: Support|Comma=,}}{{CGscriptParameters_Template|Type=number|Name=id|Description=Resource id or global email id. Unused for webshop and support types}}<br /> |Description=Instanciate an existing email account}}<br /> |Methods=<br /> {{CGscriptMethods_Template|ReturnType=Empty|Name=Save|Description=Save the Email Account}}<br /> {{CGscriptMethods_Template|ReturnType=string|Name=ToString|Description=The string representation of the object.}}<br /> |Properties=<br /> {{CGscriptProperties_Template|ReturnType=string|Name=ActualEmail|HasGetter=1|HasSetter=1|Description=Actual Email address}}<br /> {{CGscriptProperties_Template|ReturnType=string|Name=Address|HasGetter=1|HasSetter=1|Description=Email address}}<br /> {{CGscriptProperties_Template|ReturnType=string|Name=Alias|HasGetter=1|HasSetter=1|Description=Alias}}<br /> {{CGscriptProperties_Template|ReturnType=bool|Name=Default|HasGetter=1|Description=Is this the default email account for the resource.}}<br /> {{CGscriptProperties_Template|ReturnType=bool|Name=IsGEA|HasGetter=1|Description=Is the alias for a Global Email or not.}}<br /> {{CGscriptProperties_Template|ReturnType=string|Name=ObjectTypeName|HasGetter=1|Description=The name of the type of object.}}<br /> {{CGscriptProperties_Template|ReturnType=number|Name=ResourceId|HasGetter=1|Description=Id of account}}<br /> {{CGscriptProperties_Template|ReturnType=TypeInformation|Name=TypeInformation|HasGetter=1|Description=Get information about this class.}}<br /> {{CGscriptProperties_Template|ReturnType=bool|Name=UseActualEmail|HasGetter=1|HasSetter=1|Description=If true, the from email will be ActualMail. Otherwise, it will be Address.}}<br /> }}</div> Lekhacbaongoc https://wiki.catglobe.com/index.php?title=EmailAccount_class&diff=25571 EmailAccount class 2016-08-03T07:04:49Z <p>Lekhacbaongoc: </p> <hr /> <div>{{CGscriptClass_Template<br /> |Name=&lt;nowiki&gt;EmailAccount&lt;/nowiki&gt;<br /> |Description=&lt;nowiki&gt;Represents an email account.&lt;/nowiki&gt;<br /> |Constructors=<br /> {{CGscriptConstructors_Template|Parameters=<br /> {{CGscriptParameters_Template|Type=int|Name=&lt;nowiki&gt;type&lt;/nowiki&gt;|Description=&lt;nowiki&gt;2: WebShop, 3: Support&lt;/nowiki&gt;}}<br /> |Description=&lt;nowiki&gt;Instanciate an existing email account&lt;/nowiki&gt;}}<br /> {{CGscriptConstructors_Template|Parameters=<br /> {{CGscriptParameters_Template|Type=int|Name=&lt;nowiki&gt;type&lt;/nowiki&gt;|Description=&lt;nowiki&gt;0: Resource, 1: GlobalEmail, 2: WebShop, 3: Support&lt;/nowiki&gt;|Comma=,}}{{CGscriptParameters_Template|Type=int|Name=&lt;nowiki&gt;id&lt;/nowiki&gt;|Description=&lt;nowiki&gt;Resource id or global email id. Unused for webshop and support types&lt;/nowiki&gt;}}<br /> |Description=&lt;nowiki&gt;Instanciate an existing email account&lt;/nowiki&gt;}}<br /> |Methods=<br /> {{CGscriptMethods_Template|ReturnType=Empty|Name=&lt;nowiki&gt;Save&lt;/nowiki&gt;|Description=&lt;nowiki&gt;Save the Email Account&lt;/nowiki&gt;}}<br /> {{CGscriptMethods_Template|ReturnType=string|Name=&lt;nowiki&gt;ToString&lt;/nowiki&gt;|Description=&lt;nowiki&gt;The string representation of the object.&lt;/nowiki&gt;}}<br /> |Properties=<br /> {{CGscriptProperties_Template|ReturnType=string|Name=&lt;nowiki&gt;ActualEmail&lt;/nowiki&gt;|HasGetter=1|HasSetter=1|Description=&lt;nowiki&gt;Actual Email address&lt;/nowiki&gt;}}<br /> {{CGscriptProperties_Template|ReturnType=string|Name=&lt;nowiki&gt;Address&lt;/nowiki&gt;|HasGetter=1|HasSetter=1|Description=&lt;nowiki&gt;Email address&lt;/nowiki&gt;}}<br /> {{CGscriptProperties_Template|ReturnType=string|Name=&lt;nowiki&gt;Alias&lt;/nowiki&gt;|HasGetter=1|HasSetter=1|Description=&lt;nowiki&gt;Alias&lt;/nowiki&gt;}}<br /> {{CGscriptProperties_Template|ReturnType=bool|Name=&lt;nowiki&gt;Default&lt;/nowiki&gt;|HasGetter=1|Description=&lt;nowiki&gt;Is this the default email account for the resource.&lt;/nowiki&gt;}}<br /> {{CGscriptProperties_Template|ReturnType=bool|Name=&lt;nowiki&gt;IsGEA&lt;/nowiki&gt;|HasGetter=1|Description=&lt;nowiki&gt;Is the alias for a Global Email or not.&lt;/nowiki&gt;}}<br /> {{CGscriptProperties_Template|ReturnType=string|Name=&lt;nowiki&gt;ObjectTypeName&lt;/nowiki&gt;|HasGetter=1|Description=&lt;nowiki&gt;The name of the type of object.&lt;/nowiki&gt;}}<br /> {{CGscriptProperties_Template|ReturnType=int|Name=&lt;nowiki&gt;ResourceId&lt;/nowiki&gt;|HasGetter=1|Description=&lt;nowiki&gt;Id of account&lt;/nowiki&gt;}}<br /> {{CGscriptProperties_Template|ReturnType=TypeInformation|Name=&lt;nowiki&gt;TypeInformation&lt;/nowiki&gt;|HasGetter=1|Description=&lt;nowiki&gt;Get information about this class.&lt;/nowiki&gt;}}<br /> {{CGscriptProperties_Template|ReturnType=bool|Name=&lt;nowiki&gt;UseActualEmail&lt;/nowiki&gt;|HasGetter=1|HasSetter=1|Description=&lt;nowiki&gt;If true, the from email will be ActualMail. Otherwise, it will be Address.&lt;/nowiki&gt;}}<br /> }}</div> Lekhacbaongoc https://wiki.catglobe.com/index.php?title=EmailAccount_class&diff=25570 EmailAccount class 2016-08-03T07:04:26Z <p>Lekhacbaongoc: </p> <hr /> <div><br /> <br /> EmailAccount : Represents an email account.<br /> Constructors:<br /> (int type (2: WebShop, 3: Support)) - Instanciate an existing email account<br /> (int type (0: Resource, 1: GlobalEmail, 2: WebShop, 3: Support), int id (Resource id or global email id. Unused for webshop and support types)) - Instanciate an existing email account<br /> Methods:<br /> Empty Save() - Save the Email Account<br /> string ToString() - The string representation of the object.<br /> Properties:<br /> string ActualEmail HasGetter HasSetter - (Actual Email address)<br /> string Address HasGetter HasSetter - (Email address)<br /> string Alias HasGetter HasSetter - (Alias)<br /> bool Default HasGetter - (Is this the default email account for the resource.)<br /> bool IsGEA HasGetter - (Is the alias for a Global Email or not.)<br /> string ObjectTypeName HasGetter - (The name of the type of object.)<br /> int ResourceId HasGetter - (Id of account)<br /> TypeInformation TypeInformation HasGetter - (Get information about this class.)<br /> bool UseActualEmail HasGetter HasSetter - (If true, the from email will be ActualMail. Otherwise, it will be Address.)</div> Lekhacbaongoc https://wiki.catglobe.com/index.php?title=TimeregStatus_getByUsers&diff=25400 TimeregStatus getByUsers 2016-04-15T02:29:43Z <p>Lekhacbaongoc: </p> <hr /> <div>[[Category:Timereg_Functions]]<br /> {{HelpFiles}}<br /> <br /> === TimeregStatus_getByUsers ===<br /> <br /> Get timereg status by user resource id<br /> <br /> === Syntax ===<br /> <br /> Timereg_getByUsers(arrUserRid, dateStart, dateEnd);<br /> <br /> === Arguments ===<br /> <br /> *arrUserRid: Is array user resource id<br /> <br /> *dateStart: Day and time to start. It is Datetime object.<br /> <br /> *dateEnd: Day and time to end. It is Datetime object.<br /> <br /> === Return type ===<br /> <br /> The function returns a dictionary of user resource id as key and list of Timereg objects as value<br /> <br /> === Examples ===<br /> <br /> &lt;source lang=&quot;javascript&quot;&gt;<br /> array startDate = DateTime_fromInvariant(&quot;2015-09-10 00:00:00&quot;);<br /> array endDate = DateTime_fromInvariant(&quot;2016-09-10 00:00:00&quot;);<br /> array user = User_getCurrentUser();<br /> number urid = user[USER_RESOURCE_ID];<br /> Dictionary regtime = TimeregStatus_getByUsers({urid}, startDate, endDate);<br /> print(&quot;Count regtime: &quot; + regtime[urid].Count);<br /> number i = 0;<br /> for(i=0;i&lt;regtime[urid].Count;i++) {<br /> Timereg a = regtime[urid][i];<br /> print(&quot;Date : &quot; + convertToString(a.Date));<br /> print(&quot;Locked: &quot; + convertToString(a.Locked));<br /> print(&quot;ObjectTypeName: &quot; + convertToString(a.ObjectTypeName));<br /> print(&quot;Status: &quot; + convertToString(a.Status));<br /> print(&quot;TimeregPeriod Name: &quot; + convertToString(a.TimeregPeriod.Name));<br /> print(&quot;TimeregPeriod ObjectTypeName: &quot; + convertToString(a.TimeregPeriod.ObjectTypeName));<br /> print(&quot;TimeregPeriod FromDate: &quot; + convertToString(a.TimeregPeriod.FromDate));<br /> print(&quot;TimeregPeriod ToDate: &quot; + convertToString(a.TimeregPeriod.ToDate));<br /> print(&quot;TimeregPeriod Active: &quot; + convertToString(a.TimeregPeriod.Active));<br /> print(&quot;TotalHours: &quot; + convertToString(a.TotalHours));<br /> print(&quot;==========================================================\n&quot;);<br /> }<br /> <br /> /*<br /> Count regtime: 1<br /> Date : 2016-03-29 00:00:00<br /> Locked: False<br /> ObjectTypeName: Timereg<br /> Status: Met<br /> TimeregPeriod Name: 39.03.2016<br /> TimeregPeriod ObjectTypeName: TimeregPeriod<br /> TimeregPeriod FromDate: 2016-03-29 00:00:00<br /> TimeregPeriod ToDate: 2016-03-29 00:00:00<br /> TimeregPeriod Active: True<br /> TotalHours: 8<br /> ==========================================================<br /> */<br /> &lt;/source&gt; __NOTOC__</div> Lekhacbaongoc https://wiki.catglobe.com/index.php?title=Timereg_getByUsers&diff=25399 Timereg getByUsers 2016-04-15T02:29:20Z <p>Lekhacbaongoc: </p> <hr /> <div>[[Category:Timereg_Functions]]<br /> {{HelpFiles}}<br /> <br /> === Timereg_getByUsers ===<br /> <br /> Returns a dictionary where keys are resource ids and value is a dictionary where the key is the userid and the value is a list of timereg arrays ordered by the date.<br /> <br /> === Syntax ===<br /> <br /> Timereg_getByUsers(UserResourceId, dateStart, dateEnd)<br /> <br /> === Arguments ===<br /> <br /> *UserResourceId: is a array user resource id<br /> *dateStart: is a array datetime<br /> *dateEnd: is a array datetime<br /> <br /> === Return type ===<br /> <br /> The function returns a dictionary of user resource id as key and list of array as value<br /> <br /> Value is array, in which there are 7 items:<br /> <br /> {| style=&quot;border-collapse: collapse; border: 1px solid rgb(1, 1, 1)&quot; class=&quot;tableintopic&quot; width=&quot;876&quot; border=&quot;1&quot; cellpadding=&quot;2&quot;<br /> |- valign=&quot;top&quot; align=&quot;left&quot;<br /> | style=&quot;border: 1px solid rgb(1, 1, 1)&quot; width=&quot;198&quot; bgcolor=&quot;#c0c0c0&quot; | <br /> '''Constant'''<br /> <br /> | style=&quot;border: 1px solid rgb(1, 1, 1)&quot; width=&quot;120&quot; bgcolor=&quot;#c0c0c0&quot; | <br /> '''Data type'''<br /> <br /> | style=&quot;border: 1px solid rgb(1, 1, 1)&quot; width=&quot;558&quot; bgcolor=&quot;#c0c0c0&quot; | <br /> '''Value'''<br /> <br /> |- valign=&quot;top&quot; align=&quot;left&quot;<br /> | style=&quot;border: 1px solid rgb(1, 1, 1)&quot; width=&quot;198&quot; | <br /> OBJECT_TYPE_INDEX<br /> <br /> | style=&quot;border: 1px solid rgb(1, 1, 1)&quot; width=&quot;120&quot; | <br /> number<br /> <br /> | style=&quot;border: 1px solid rgb(1, 1, 1)&quot; width=&quot;558&quot; | <br /> It's index of object type<br /> <br /> |- valign=&quot;top&quot; align=&quot;left&quot;<br /> | style=&quot;border: 1px solid rgb(1, 1, 1)&quot; width=&quot;198&quot; | <br /> TIMEREGRESOURCE_ID<br /> <br /> | style=&quot;border: 1px solid rgb(1, 1, 1)&quot; width=&quot;120&quot; | <br /> number<br /> <br /> | style=&quot;border: 1px solid rgb(1, 1, 1)&quot; width=&quot;558&quot; | <br /> It's Timereg id<br /> <br /> |- valign=&quot;top&quot; align=&quot;left&quot;<br /> | style=&quot;border: 1px solid rgb(1, 1, 1)&quot; width=&quot;198&quot; | <br /> TIMEREGRESOURCE_HOURS<br /> <br /> | style=&quot;border: 1px solid rgb(1, 1, 1)&quot; width=&quot;120&quot; | <br /> number<br /> <br /> | style=&quot;border: 1px solid rgb(1, 1, 1)&quot; width=&quot;558&quot; | <br /> It's number of hours regtime<br /> <br /> |- valign=&quot;top&quot; align=&quot;left&quot;<br /> | style=&quot;border: 1px solid rgb(1, 1, 1)&quot; width=&quot;198&quot; | <br /> TIMEREGRESOURCE_RESOURCE_ID<br /> <br /> | style=&quot;border: 1px solid rgb(1, 1, 1)&quot; width=&quot;120&quot; | <br /> number<br /> <br /> | style=&quot;border: 1px solid rgb(1, 1, 1)&quot; width=&quot;558&quot; | <br /> It's task resource id<br /> <br /> |- valign=&quot;top&quot; align=&quot;left&quot;<br /> | style=&quot;border: 1px solid rgb(1, 1, 1)&quot; width=&quot;198&quot; | <br /> TIMEREGRESOURCE_TIMEREG_ID<br /> <br /> | style=&quot;border: 1px solid rgb(1, 1, 1)&quot; width=&quot;120&quot; | <br /> number<br /> <br /> | style=&quot;border: 1px solid rgb(1, 1, 1)&quot; width=&quot;558&quot; | <br /> It's Timereg resource id<br /> <br /> |- valign=&quot;top&quot; align=&quot;left&quot;<br /> | style=&quot;border: 1px solid rgb(1, 1, 1)&quot; width=&quot;198&quot; | <br /> TIMEREGRESOURCE_DATE<br /> <br /> | style=&quot;border: 1px solid rgb(1, 1, 1)&quot; width=&quot;120&quot; | <br /> Datetime<br /> <br /> | style=&quot;border: 1px solid rgb(1, 1, 1)&quot; width=&quot;558&quot; | <br /> It's array datetime<br /> <br /> |- valign=&quot;top&quot; align=&quot;left&quot;<br /> | style=&quot;border: 1px solid rgb(1, 1, 1)&quot; width=&quot;198&quot; | <br /> TIMEREGRESOURCE_ROLE_ID<br /> <br /> | style=&quot;border: 1px solid rgb(1, 1, 1)&quot; width=&quot;120&quot; | <br /> number<br /> <br /> | style=&quot;border: 1px solid rgb(1, 1, 1)&quot; width=&quot;558&quot; | <br /> It's Timereg role id<br /> <br /> |}<br /> <br /> <br /> <br /> === Examples ===<br /> <br /> &lt;source lang=&quot;javascript&quot;&gt;<br /> array dateStart = DateTime_fromInvariant(&quot;2016-04-01 00:00:00&quot;);<br /> array dateEnd = DateTime_fromInvariant(&quot;2016-04-10 00:00:00&quot;);<br /> Dictionary regtime = Timereg_getByUsers({717536}, dateStart, dateEnd);<br /> <br /> /*<br /> {<br /> &quot;717536&quot;: <br /> {<br /> {38,112561,1,796156,29185,{2016,4,1,0,0,0,0,13},0},<br /> {38,112975,1,794623,29327,{2016,4,5,0,0,0,0,14},0},<br /> {38,113095,1,797702,29185,{2016,4,1,0,0,0,0,13},0}<br /> }<br /> }<br /> */<br /> &lt;/source&gt; __NOTOC__</div> Lekhacbaongoc https://wiki.catglobe.com/index.php?title=Timereg_getByResource&diff=25398 Timereg getByResource 2016-04-15T02:29:04Z <p>Lekhacbaongoc: </p> <hr /> <div>[[Category:Timereg_Functions]]<br /> {{HelpFiles}}<br /> <br /> ==== Timereg_getByResource&lt;br/&gt; ====<br /> <br /> Returns a dictionary where keys are resource ids and value is a dictionary where the key is the userid and the value is a list of timereg arrays ordered by the date.<br /> <br /> '''Syntax'''<br /> <br /> Timereg_getByResource(''ResourceId ''[, dateStart[, dateEnd]])<br /> <br /> '''Arguments'''<br /> <br /> *ResourceId: is a number expression. It is the task or project resource id<br /> *dateStart: is a array datetime<br /> *dateEnd: is a array datetime<br /> <br /> '''Return type'''<br /> <br /> Dictionary<br /> <br /> '''Example'''<br /> <br /> Dictionary a = Timereg_getByResource(738918);<br /> <br /> print(a);<br /> <br /> //{&quot;738918&quot;: {&quot;345465&quot;: &amp;#x7B;&amp;#x7B;38,97850,1,738918,24191,{2015,9,14,0,0,0,0,38},0&amp;#x7D;&amp;#x7D;}}<br /> <br /> __NOTOC__</div> Lekhacbaongoc https://wiki.catglobe.com/index.php?title=Category:Timereg_Functions&diff=25397 Category:Timereg Functions 2016-04-15T02:28:38Z <p>Lekhacbaongoc: Created page with &quot;Category:Functions {{HelpFiles}}&quot;</p> <hr /> <div>[[Category:Functions]]<br /> {{HelpFiles}}</div> Lekhacbaongoc https://wiki.catglobe.com/index.php?title=Timereg_addMinutesSpent&diff=25396 Timereg addMinutesSpent 2016-04-15T02:27:54Z <p>Lekhacbaongoc: </p> <hr /> <div>[[Category:Timereg_Functions]]<br /> {{HelpFiles}}<br /> <br /> ==== Timereg_addMinutesSpent&lt;br/&gt; ====<br /> <br /> Add number of minutes to task or project register<br /> <br /> '''Syntax'''<br /> <br /> Timereg_addMinutesSpent(''ResourceId'',&amp;nbsp; minutesSpent, status[,&amp;nbsp; date[, ''UserResourceId''[, role]]])<br /> <br /> '''Arguments'''<br /> <br /> *''ResourceId'': is a ''number ''expression. It is the task or project resource id<br /> *minutesSpent: is a number of hours to add<br /> *status: is a string type<br /> <br /> {| width=&quot;182&quot; border=&quot;1&quot; cellpadding=&quot;1&quot; cellspacing=&quot;1&quot;<br /> |-<br /> | Met&lt;br/&gt;<br /> |-<br /> | Sick - ½ day&lt;br/&gt;<br /> |-<br /> | Vacation - ½ day&lt;br/&gt;<br /> |-<br /> | Holiday - ½ day&lt;br/&gt;<br /> |-<br /> | Funeral - ½ day&lt;br/&gt;<br /> |-<br /> | Met -1/2 day&lt;br/&gt;<br /> |}<br /> <br /> *date: is an array which is the original date time<br /> *''UserResourceId: is a number expression. It is the new user resource id to add minutes spent.''<br /> *role:&amp;nbsp; is a number type<br /> <br /> {| width=&quot;500&quot; border=&quot;1&quot; cellpadding=&quot;1&quot; cellspacing=&quot;1&quot;<br /> |-<br /> | Index&lt;br/&gt;<br /> | Type&lt;br/&gt;<br /> |-<br /> | 0&lt;br/&gt;<br /> | Project Manager&lt;br/&gt;<br /> |-<br /> | 1&lt;br/&gt;<br /> | Help Author&lt;br/&gt;<br /> |-<br /> | 2&lt;br/&gt;<br /> | Technical Designer&lt;br/&gt;<br /> |-<br /> | 3&lt;br/&gt;<br /> | Developer&lt;br/&gt;<br /> |-<br /> | 4&lt;br/&gt;<br /> | Tester&lt;br/&gt;<br /> |}<br /> <br /> '''Return value'''<br /> <br /> number of hours registered after applying the given minutes<br /> <br /> '''Example'''<br /> <br /> number a = Timereg_addMinutesSpent(738918, 30, &quot;Met&quot;);<br /> <br /> ''print(a); //0.5''<br /> <br /> __NOTOC__</div> Lekhacbaongoc https://wiki.catglobe.com/index.php?title=Category:Timereg&diff=25395 Category:Timereg 2016-04-15T02:27:11Z <p>Lekhacbaongoc: Blanked the page</p> <hr /> <div></div> Lekhacbaongoc https://wiki.catglobe.com/index.php?title=Category:Timereg&diff=25394 Category:Timereg 2016-04-15T02:23:30Z <p>Lekhacbaongoc: </p> <hr /> <div>[[Category:Functions]]<br /> {{HelpFiles}}<br /> == Timereg Functions ==</div> Lekhacbaongoc https://wiki.catglobe.com/index.php?title=TimeregStatus_getByUsers&diff=25393 TimeregStatus getByUsers 2016-04-15T02:22:56Z <p>Lekhacbaongoc: </p> <hr /> <div>[[Category:Timereg]]<br /> {{HelpFiles}}<br /> <br /> === TimeregStatus_getByUsers ===<br /> <br /> Get timereg status by user resource id<br /> <br /> === Syntax ===<br /> <br /> Timereg_getByUsers(arrUserRid, dateStart, dateEnd);<br /> <br /> === Arguments ===<br /> <br /> *arrUserRid: Is array user resource id<br /> <br /> *dateStart: Day and time to start. It is Datetime object.<br /> <br /> *dateEnd: Day and time to end. It is Datetime object.<br /> <br /> === Return type ===<br /> <br /> The function returns a dictionary of user resource id as key and list of Timereg objects as value<br /> <br /> === Examples ===<br /> <br /> &lt;source lang=&quot;javascript&quot;&gt;<br /> array startDate = DateTime_fromInvariant(&quot;2015-09-10 00:00:00&quot;);<br /> array endDate = DateTime_fromInvariant(&quot;2016-09-10 00:00:00&quot;);<br /> array user = User_getCurrentUser();<br /> number urid = user[USER_RESOURCE_ID];<br /> Dictionary regtime = TimeregStatus_getByUsers({urid}, startDate, endDate);<br /> print(&quot;Count regtime: &quot; + regtime[urid].Count);<br /> number i = 0;<br /> for(i=0;i&lt;regtime[urid].Count;i++) {<br /> Timereg a = regtime[urid][i];<br /> print(&quot;Date : &quot; + convertToString(a.Date));<br /> print(&quot;Locked: &quot; + convertToString(a.Locked));<br /> print(&quot;ObjectTypeName: &quot; + convertToString(a.ObjectTypeName));<br /> print(&quot;Status: &quot; + convertToString(a.Status));<br /> print(&quot;TimeregPeriod Name: &quot; + convertToString(a.TimeregPeriod.Name));<br /> print(&quot;TimeregPeriod ObjectTypeName: &quot; + convertToString(a.TimeregPeriod.ObjectTypeName));<br /> print(&quot;TimeregPeriod FromDate: &quot; + convertToString(a.TimeregPeriod.FromDate));<br /> print(&quot;TimeregPeriod ToDate: &quot; + convertToString(a.TimeregPeriod.ToDate));<br /> print(&quot;TimeregPeriod Active: &quot; + convertToString(a.TimeregPeriod.Active));<br /> print(&quot;TotalHours: &quot; + convertToString(a.TotalHours));<br /> print(&quot;==========================================================\n&quot;);<br /> }<br /> <br /> /*<br /> Count regtime: 1<br /> Date : 2016-03-29 00:00:00<br /> Locked: False<br /> ObjectTypeName: Timereg<br /> Status: Met<br /> TimeregPeriod Name: 39.03.2016<br /> TimeregPeriod ObjectTypeName: TimeregPeriod<br /> TimeregPeriod FromDate: 2016-03-29 00:00:00<br /> TimeregPeriod ToDate: 2016-03-29 00:00:00<br /> TimeregPeriod Active: True<br /> TotalHours: 8<br /> ==========================================================<br /> */<br /> &lt;/source&gt; __NOTOC__</div> Lekhacbaongoc https://wiki.catglobe.com/index.php?title=Timereg_getByUsers&diff=25392 Timereg getByUsers 2016-04-15T02:22:35Z <p>Lekhacbaongoc: </p> <hr /> <div>[[Category:Timereg]]<br /> {{HelpFiles}}<br /> <br /> === Timereg_getByUsers ===<br /> <br /> Returns a dictionary where keys are resource ids and value is a dictionary where the key is the userid and the value is a list of timereg arrays ordered by the date.<br /> <br /> === Syntax ===<br /> <br /> Timereg_getByUsers(UserResourceId, dateStart, dateEnd)<br /> <br /> === Arguments ===<br /> <br /> *UserResourceId: is a array user resource id<br /> *dateStart: is a array datetime<br /> *dateEnd: is a array datetime<br /> <br /> === Return type ===<br /> <br /> The function returns a dictionary of user resource id as key and list of array as value<br /> <br /> Value is array, in which there are 7 items:<br /> <br /> {| style=&quot;border-collapse: collapse; border: 1px solid rgb(1, 1, 1)&quot; class=&quot;tableintopic&quot; width=&quot;876&quot; border=&quot;1&quot; cellpadding=&quot;2&quot;<br /> |- valign=&quot;top&quot; align=&quot;left&quot;<br /> | style=&quot;border: 1px solid rgb(1, 1, 1)&quot; width=&quot;198&quot; bgcolor=&quot;#c0c0c0&quot; | <br /> '''Constant'''<br /> <br /> | style=&quot;border: 1px solid rgb(1, 1, 1)&quot; width=&quot;120&quot; bgcolor=&quot;#c0c0c0&quot; | <br /> '''Data type'''<br /> <br /> | style=&quot;border: 1px solid rgb(1, 1, 1)&quot; width=&quot;558&quot; bgcolor=&quot;#c0c0c0&quot; | <br /> '''Value'''<br /> <br /> |- valign=&quot;top&quot; align=&quot;left&quot;<br /> | style=&quot;border: 1px solid rgb(1, 1, 1)&quot; width=&quot;198&quot; | <br /> OBJECT_TYPE_INDEX<br /> <br /> | style=&quot;border: 1px solid rgb(1, 1, 1)&quot; width=&quot;120&quot; | <br /> number<br /> <br /> | style=&quot;border: 1px solid rgb(1, 1, 1)&quot; width=&quot;558&quot; | <br /> It's index of object type<br /> <br /> |- valign=&quot;top&quot; align=&quot;left&quot;<br /> | style=&quot;border: 1px solid rgb(1, 1, 1)&quot; width=&quot;198&quot; | <br /> TIMEREGRESOURCE_ID<br /> <br /> | style=&quot;border: 1px solid rgb(1, 1, 1)&quot; width=&quot;120&quot; | <br /> number<br /> <br /> | style=&quot;border: 1px solid rgb(1, 1, 1)&quot; width=&quot;558&quot; | <br /> It's Timereg id<br /> <br /> |- valign=&quot;top&quot; align=&quot;left&quot;<br /> | style=&quot;border: 1px solid rgb(1, 1, 1)&quot; width=&quot;198&quot; | <br /> TIMEREGRESOURCE_HOURS<br /> <br /> | style=&quot;border: 1px solid rgb(1, 1, 1)&quot; width=&quot;120&quot; | <br /> number<br /> <br /> | style=&quot;border: 1px solid rgb(1, 1, 1)&quot; width=&quot;558&quot; | <br /> It's number of hours regtime<br /> <br /> |- valign=&quot;top&quot; align=&quot;left&quot;<br /> | style=&quot;border: 1px solid rgb(1, 1, 1)&quot; width=&quot;198&quot; | <br /> TIMEREGRESOURCE_RESOURCE_ID<br /> <br /> | style=&quot;border: 1px solid rgb(1, 1, 1)&quot; width=&quot;120&quot; | <br /> number<br /> <br /> | style=&quot;border: 1px solid rgb(1, 1, 1)&quot; width=&quot;558&quot; | <br /> It's task resource id<br /> <br /> |- valign=&quot;top&quot; align=&quot;left&quot;<br /> | style=&quot;border: 1px solid rgb(1, 1, 1)&quot; width=&quot;198&quot; | <br /> TIMEREGRESOURCE_TIMEREG_ID<br /> <br /> | style=&quot;border: 1px solid rgb(1, 1, 1)&quot; width=&quot;120&quot; | <br /> number<br /> <br /> | style=&quot;border: 1px solid rgb(1, 1, 1)&quot; width=&quot;558&quot; | <br /> It's Timereg resource id<br /> <br /> |- valign=&quot;top&quot; align=&quot;left&quot;<br /> | style=&quot;border: 1px solid rgb(1, 1, 1)&quot; width=&quot;198&quot; | <br /> TIMEREGRESOURCE_DATE<br /> <br /> | style=&quot;border: 1px solid rgb(1, 1, 1)&quot; width=&quot;120&quot; | <br /> Datetime<br /> <br /> | style=&quot;border: 1px solid rgb(1, 1, 1)&quot; width=&quot;558&quot; | <br /> It's array datetime<br /> <br /> |- valign=&quot;top&quot; align=&quot;left&quot;<br /> | style=&quot;border: 1px solid rgb(1, 1, 1)&quot; width=&quot;198&quot; | <br /> TIMEREGRESOURCE_ROLE_ID<br /> <br /> | style=&quot;border: 1px solid rgb(1, 1, 1)&quot; width=&quot;120&quot; | <br /> number<br /> <br /> | style=&quot;border: 1px solid rgb(1, 1, 1)&quot; width=&quot;558&quot; | <br /> It's Timereg role id<br /> <br /> |}<br /> <br /> <br /> <br /> === Examples ===<br /> <br /> &lt;source lang=&quot;javascript&quot;&gt;<br /> array dateStart = DateTime_fromInvariant(&quot;2016-04-01 00:00:00&quot;);<br /> array dateEnd = DateTime_fromInvariant(&quot;2016-04-10 00:00:00&quot;);<br /> Dictionary regtime = Timereg_getByUsers({717536}, dateStart, dateEnd);<br /> <br /> /*<br /> {<br /> &quot;717536&quot;: <br /> {<br /> {38,112561,1,796156,29185,{2016,4,1,0,0,0,0,13},0},<br /> {38,112975,1,794623,29327,{2016,4,5,0,0,0,0,14},0},<br /> {38,113095,1,797702,29185,{2016,4,1,0,0,0,0,13},0}<br /> }<br /> }<br /> */<br /> &lt;/source&gt; __NOTOC__</div> Lekhacbaongoc https://wiki.catglobe.com/index.php?title=Timereg_getByResource&diff=25391 Timereg getByResource 2016-04-15T02:21:56Z <p>Lekhacbaongoc: </p> <hr /> <div>[[Category:Timereg]]<br /> {{HelpFiles}}<br /> <br /> ==== Timereg_getByResource&lt;br/&gt; ====<br /> <br /> Returns a dictionary where keys are resource ids and value is a dictionary where the key is the userid and the value is a list of timereg arrays ordered by the date.<br /> <br /> '''Syntax'''<br /> <br /> Timereg_getByResource(''ResourceId ''[, dateStart[, dateEnd]])<br /> <br /> '''Arguments'''<br /> <br /> *ResourceId: is a number expression. It is the task or project resource id<br /> *dateStart: is a array datetime<br /> *dateEnd: is a array datetime<br /> <br /> '''Return type'''<br /> <br /> Dictionary<br /> <br /> '''Example'''<br /> <br /> Dictionary a = Timereg_getByResource(738918);<br /> <br /> print(a);<br /> <br /> //{&quot;738918&quot;: {&quot;345465&quot;: &amp;#x7B;&amp;#x7B;38,97850,1,738918,24191,{2015,9,14,0,0,0,0,38},0&amp;#x7D;&amp;#x7D;}}<br /> <br /> __NOTOC__</div> Lekhacbaongoc https://wiki.catglobe.com/index.php?title=Timereg_addMinutesSpent&diff=25390 Timereg addMinutesSpent 2016-04-15T02:21:00Z <p>Lekhacbaongoc: </p> <hr /> <div>[[Category:Timereg]]<br /> {{HelpFiles}}<br /> <br /> ==== Timereg_addMinutesSpent&lt;br/&gt; ====<br /> <br /> Add number of minutes to task or project register<br /> <br /> '''Syntax'''<br /> <br /> Timereg_addMinutesSpent(''ResourceId'',&amp;nbsp; minutesSpent, status[,&amp;nbsp; date[, ''UserResourceId''[, role]]])<br /> <br /> '''Arguments'''<br /> <br /> *''ResourceId'': is a ''number ''expression. It is the task or project resource id<br /> *minutesSpent: is a number of hours to add<br /> *status: is a string type<br /> <br /> {| width=&quot;182&quot; border=&quot;1&quot; cellpadding=&quot;1&quot; cellspacing=&quot;1&quot;<br /> |-<br /> | Met&lt;br/&gt;<br /> |-<br /> | Sick - ½ day&lt;br/&gt;<br /> |-<br /> | Vacation - ½ day&lt;br/&gt;<br /> |-<br /> | Holiday - ½ day&lt;br/&gt;<br /> |-<br /> | Funeral - ½ day&lt;br/&gt;<br /> |-<br /> | Met -1/2 day&lt;br/&gt;<br /> |}<br /> <br /> *date: is an array which is the original date time<br /> *''UserResourceId: is a number expression. It is the new user resource id to add minutes spent.''<br /> *role:&amp;nbsp; is a number type<br /> <br /> {| width=&quot;500&quot; border=&quot;1&quot; cellpadding=&quot;1&quot; cellspacing=&quot;1&quot;<br /> |-<br /> | Index&lt;br/&gt;<br /> | Type&lt;br/&gt;<br /> |-<br /> | 0&lt;br/&gt;<br /> | Project Manager&lt;br/&gt;<br /> |-<br /> | 1&lt;br/&gt;<br /> | Help Author&lt;br/&gt;<br /> |-<br /> | 2&lt;br/&gt;<br /> | Technical Designer&lt;br/&gt;<br /> |-<br /> | 3&lt;br/&gt;<br /> | Developer&lt;br/&gt;<br /> |-<br /> | 4&lt;br/&gt;<br /> | Tester&lt;br/&gt;<br /> |}<br /> <br /> '''Return value'''<br /> <br /> number of hours registered after applying the given minutes<br /> <br /> '''Example'''<br /> <br /> number a = Timereg_addMinutesSpent(738918, 30, &quot;Met&quot;);<br /> <br /> ''print(a); //0.5''<br /> <br /> __NOTOC__</div> Lekhacbaongoc https://wiki.catglobe.com/index.php?title=Category:Timereg&diff=25389 Category:Timereg 2016-04-15T02:20:05Z <p>Lekhacbaongoc: Created page with &quot;== Timereg Functions ==&quot;</p> <hr /> <div>== Timereg Functions ==</div> Lekhacbaongoc https://wiki.catglobe.com/index.php?title=TimeregStatus_getByUsers&diff=25388 TimeregStatus getByUsers 2016-04-15T02:18:35Z <p>Lekhacbaongoc: </p> <hr /> <div>[[Category:Functions]]<br /> {{HelpFiles}}<br /> <br /> === TimeregStatus_getByUsers ===<br /> <br /> Get timereg status by user resource id<br /> <br /> === Syntax ===<br /> <br /> Timereg_getByUsers(arrUserRid, dateStart, dateEnd);<br /> <br /> === Arguments ===<br /> <br /> *arrUserRid: Is array user resource id<br /> <br /> *dateStart: Day and time to start. It is Datetime object.<br /> <br /> *dateEnd: Day and time to end. It is Datetime object.<br /> <br /> === Return type ===<br /> <br /> The function returns a dictionary of user resource id as key and list of Timereg objects as value<br /> <br /> === Examples ===<br /> <br /> &lt;source lang=&quot;javascript&quot;&gt;<br /> array startDate = DateTime_fromInvariant(&quot;2015-09-10 00:00:00&quot;);<br /> array endDate = DateTime_fromInvariant(&quot;2016-09-10 00:00:00&quot;);<br /> array user = User_getCurrentUser();<br /> number urid = user[USER_RESOURCE_ID];<br /> Dictionary regtime = TimeregStatus_getByUsers({urid}, startDate, endDate);<br /> print(&quot;Count regtime: &quot; + regtime[urid].Count);<br /> number i = 0;<br /> for(i=0;i&lt;regtime[urid].Count;i++) {<br /> Timereg a = regtime[urid][i];<br /> print(&quot;Date : &quot; + convertToString(a.Date));<br /> print(&quot;Locked: &quot; + convertToString(a.Locked));<br /> print(&quot;ObjectTypeName: &quot; + convertToString(a.ObjectTypeName));<br /> print(&quot;Status: &quot; + convertToString(a.Status));<br /> print(&quot;TimeregPeriod Name: &quot; + convertToString(a.TimeregPeriod.Name));<br /> print(&quot;TimeregPeriod ObjectTypeName: &quot; + convertToString(a.TimeregPeriod.ObjectTypeName));<br /> print(&quot;TimeregPeriod FromDate: &quot; + convertToString(a.TimeregPeriod.FromDate));<br /> print(&quot;TimeregPeriod ToDate: &quot; + convertToString(a.TimeregPeriod.ToDate));<br /> print(&quot;TimeregPeriod Active: &quot; + convertToString(a.TimeregPeriod.Active));<br /> print(&quot;TotalHours: &quot; + convertToString(a.TotalHours));<br /> print(&quot;==========================================================\n&quot;);<br /> }<br /> <br /> /*<br /> Count regtime: 1<br /> Date : 2016-03-29 00:00:00<br /> Locked: False<br /> ObjectTypeName: Timereg<br /> Status: Met<br /> TimeregPeriod Name: 39.03.2016<br /> TimeregPeriod ObjectTypeName: TimeregPeriod<br /> TimeregPeriod FromDate: 2016-03-29 00:00:00<br /> TimeregPeriod ToDate: 2016-03-29 00:00:00<br /> TimeregPeriod Active: True<br /> TotalHours: 8<br /> ==========================================================<br /> */<br /> &lt;/source&gt; __NOTOC__</div> Lekhacbaongoc https://wiki.catglobe.com/index.php?title=Timereg_getByUsers&diff=25387 Timereg getByUsers 2016-04-15T02:17:54Z <p>Lekhacbaongoc: </p> <hr /> <div>[[Category:Functions]]<br /> {{HelpFiles}}<br /> <br /> === Timereg_getByUsers ===<br /> <br /> Returns a dictionary where keys are resource ids and value is a dictionary where the key is the userid and the value is a list of timereg arrays ordered by the date.<br /> <br /> === Syntax ===<br /> <br /> Timereg_getByUsers(UserResourceId, dateStart, dateEnd)<br /> <br /> === Arguments ===<br /> <br /> *UserResourceId: is a array user resource id<br /> *dateStart: is a array datetime<br /> *dateEnd: is a array datetime<br /> <br /> === Return type ===<br /> <br /> The function returns a dictionary of user resource id as key and list of array as value <br /> <br /> Value is array, in which there are 7 items:<br /> <br /> {| style=&quot;border-collapse: collapse; border: 1px solid rgb(1, 1, 1)&quot; class=&quot;tableintopic&quot; width=&quot;876&quot; border=&quot;1&quot; cellpadding=&quot;2&quot;<br /> |- valign=&quot;top&quot; align=&quot;left&quot;<br /> | style=&quot;border: 1px solid rgb(1, 1, 1)&quot; width=&quot;198&quot; bgcolor=&quot;#c0c0c0&quot; | <br /> '''Constant'''<br /> <br /> | style=&quot;border: 1px solid rgb(1, 1, 1)&quot; width=&quot;120&quot; bgcolor=&quot;#c0c0c0&quot; | <br /> '''Data type'''<br /> <br /> | style=&quot;border: 1px solid rgb(1, 1, 1)&quot; width=&quot;558&quot; bgcolor=&quot;#c0c0c0&quot; | <br /> '''Value'''<br /> <br /> |- valign=&quot;top&quot; align=&quot;left&quot;<br /> | style=&quot;border: 1px solid rgb(1, 1, 1)&quot; width=&quot;198&quot; | <br /> OBJECT_TYPE_INDEX<br /> <br /> | style=&quot;border: 1px solid rgb(1, 1, 1)&quot; width=&quot;120&quot; | <br /> number<br /> <br /> | style=&quot;border: 1px solid rgb(1, 1, 1)&quot; width=&quot;558&quot; | <br /> It's index of object type<br /> <br /> |- valign=&quot;top&quot; align=&quot;left&quot;<br /> | style=&quot;border: 1px solid rgb(1, 1, 1)&quot; width=&quot;198&quot; | <br /> TIMEREGRESOURCE_ID<br /> <br /> | style=&quot;border: 1px solid rgb(1, 1, 1)&quot; width=&quot;120&quot; | <br /> number<br /> <br /> | style=&quot;border: 1px solid rgb(1, 1, 1)&quot; width=&quot;558&quot; | <br /> It's Timereg id<br /> <br /> |- valign=&quot;top&quot; align=&quot;left&quot;<br /> | style=&quot;border: 1px solid rgb(1, 1, 1)&quot; width=&quot;198&quot; | <br /> TIMEREGRESOURCE_HOURS<br /> <br /> | style=&quot;border: 1px solid rgb(1, 1, 1)&quot; width=&quot;120&quot; | <br /> number<br /> <br /> | style=&quot;border: 1px solid rgb(1, 1, 1)&quot; width=&quot;558&quot; | <br /> It's number of hours regtime<br /> <br /> |- valign=&quot;top&quot; align=&quot;left&quot;<br /> | style=&quot;border: 1px solid rgb(1, 1, 1)&quot; width=&quot;198&quot; | <br /> TIMEREGRESOURCE_RESOURCE_ID<br /> <br /> | style=&quot;border: 1px solid rgb(1, 1, 1)&quot; width=&quot;120&quot; | <br /> number<br /> <br /> | style=&quot;border: 1px solid rgb(1, 1, 1)&quot; width=&quot;558&quot; | <br /> It's task resource id<br /> <br /> |- valign=&quot;top&quot; align=&quot;left&quot;<br /> | style=&quot;border: 1px solid rgb(1, 1, 1)&quot; width=&quot;198&quot; | <br /> TIMEREGRESOURCE_TIMEREG_ID<br /> <br /> | style=&quot;border: 1px solid rgb(1, 1, 1)&quot; width=&quot;120&quot; | <br /> number<br /> <br /> | style=&quot;border: 1px solid rgb(1, 1, 1)&quot; width=&quot;558&quot; | <br /> It's Timereg resource id <br /> <br /> |- valign=&quot;top&quot; align=&quot;left&quot;<br /> | style=&quot;border: 1px solid rgb(1, 1, 1)&quot; width=&quot;198&quot; | <br /> TIMEREGRESOURCE_DATE<br /> <br /> | style=&quot;border: 1px solid rgb(1, 1, 1)&quot; width=&quot;120&quot; | <br /> Datetime<br /> <br /> | style=&quot;border: 1px solid rgb(1, 1, 1)&quot; width=&quot;558&quot; | <br /> It's array datetime <br /> <br /> |- valign=&quot;top&quot; align=&quot;left&quot;<br /> | style=&quot;border: 1px solid rgb(1, 1, 1)&quot; width=&quot;198&quot; | <br /> TIMEREGRESOURCE_ROLE_ID<br /> <br /> | style=&quot;border: 1px solid rgb(1, 1, 1)&quot; width=&quot;120&quot; | <br /> number<br /> <br /> | style=&quot;border: 1px solid rgb(1, 1, 1)&quot; width=&quot;558&quot; | <br /> It's Timereg role id<br /> <br /> |}<br /> <br /> <br /> === Examples ===<br /> <br /> &lt;source lang=&quot;javascript&quot;&gt;<br /> array dateStart = DateTime_fromInvariant(&quot;2016-04-01 00:00:00&quot;);<br /> array dateEnd = DateTime_fromInvariant(&quot;2016-04-10 00:00:00&quot;);<br /> Dictionary regtime = Timereg_getByUsers({717536}, dateStart, dateEnd);<br /> <br /> /*<br /> {<br /> &quot;717536&quot;: <br /> {<br /> {38,112561,1,796156,29185,{2016,4,1,0,0,0,0,13},0},<br /> {38,112975,1,794623,29327,{2016,4,5,0,0,0,0,14},0},<br /> {38,113095,1,797702,29185,{2016,4,1,0,0,0,0,13},0}<br /> }<br /> }<br /> */<br /> &lt;/source&gt;<br /> __NOTOC__</div> Lekhacbaongoc https://wiki.catglobe.com/index.php?title=Timereg_getByUsers&diff=25386 Timereg getByUsers 2016-04-15T02:16:19Z <p>Lekhacbaongoc: </p> <hr /> <div>[[Category:Category:Functions]]<br /> {{HelpFiles}}<br /> <br /> === Timereg_getByUsers ===<br /> <br /> Returns a dictionary where keys are resource ids and value is a dictionary where the key is the userid and the value is a list of timereg arrays ordered by the date.<br /> <br /> === Syntax ===<br /> <br /> Timereg_getByUsers(UserResourceId, dateStart, dateEnd)<br /> <br /> === Arguments ===<br /> <br /> *UserResourceId: is a array user resource id<br /> *dateStart: is a array datetime<br /> *dateEnd: is a array datetime<br /> <br /> === Return type ===<br /> <br /> The function returns a dictionary of user resource id as key and list of array as value <br /> <br /> Value is array, in which there are 7 items:<br /> <br /> {| style=&quot;border-collapse: collapse; border: 1px solid rgb(1, 1, 1)&quot; class=&quot;tableintopic&quot; width=&quot;876&quot; border=&quot;1&quot; cellpadding=&quot;2&quot;<br /> |- valign=&quot;top&quot; align=&quot;left&quot;<br /> | style=&quot;border: 1px solid rgb(1, 1, 1)&quot; width=&quot;198&quot; bgcolor=&quot;#c0c0c0&quot; | <br /> '''Constant'''<br /> <br /> | style=&quot;border: 1px solid rgb(1, 1, 1)&quot; width=&quot;120&quot; bgcolor=&quot;#c0c0c0&quot; | <br /> '''Data type'''<br /> <br /> | style=&quot;border: 1px solid rgb(1, 1, 1)&quot; width=&quot;558&quot; bgcolor=&quot;#c0c0c0&quot; | <br /> '''Value'''<br /> <br /> |- valign=&quot;top&quot; align=&quot;left&quot;<br /> | style=&quot;border: 1px solid rgb(1, 1, 1)&quot; width=&quot;198&quot; | <br /> OBJECT_TYPE_INDEX<br /> <br /> | style=&quot;border: 1px solid rgb(1, 1, 1)&quot; width=&quot;120&quot; | <br /> number<br /> <br /> | style=&quot;border: 1px solid rgb(1, 1, 1)&quot; width=&quot;558&quot; | <br /> It's index of object type<br /> <br /> |- valign=&quot;top&quot; align=&quot;left&quot;<br /> | style=&quot;border: 1px solid rgb(1, 1, 1)&quot; width=&quot;198&quot; | <br /> TIMEREGRESOURCE_ID<br /> <br /> | style=&quot;border: 1px solid rgb(1, 1, 1)&quot; width=&quot;120&quot; | <br /> number<br /> <br /> | style=&quot;border: 1px solid rgb(1, 1, 1)&quot; width=&quot;558&quot; | <br /> It's Timereg id<br /> <br /> |- valign=&quot;top&quot; align=&quot;left&quot;<br /> | style=&quot;border: 1px solid rgb(1, 1, 1)&quot; width=&quot;198&quot; | <br /> TIMEREGRESOURCE_HOURS<br /> <br /> | style=&quot;border: 1px solid rgb(1, 1, 1)&quot; width=&quot;120&quot; | <br /> number<br /> <br /> | style=&quot;border: 1px solid rgb(1, 1, 1)&quot; width=&quot;558&quot; | <br /> It's number of hours regtime<br /> <br /> |- valign=&quot;top&quot; align=&quot;left&quot;<br /> | style=&quot;border: 1px solid rgb(1, 1, 1)&quot; width=&quot;198&quot; | <br /> TIMEREGRESOURCE_RESOURCE_ID<br /> <br /> | style=&quot;border: 1px solid rgb(1, 1, 1)&quot; width=&quot;120&quot; | <br /> number<br /> <br /> | style=&quot;border: 1px solid rgb(1, 1, 1)&quot; width=&quot;558&quot; | <br /> It's task resource id<br /> <br /> |- valign=&quot;top&quot; align=&quot;left&quot;<br /> | style=&quot;border: 1px solid rgb(1, 1, 1)&quot; width=&quot;198&quot; | <br /> TIMEREGRESOURCE_TIMEREG_ID<br /> <br /> | style=&quot;border: 1px solid rgb(1, 1, 1)&quot; width=&quot;120&quot; | <br /> number<br /> <br /> | style=&quot;border: 1px solid rgb(1, 1, 1)&quot; width=&quot;558&quot; | <br /> It's Timereg resource id <br /> <br /> |- valign=&quot;top&quot; align=&quot;left&quot;<br /> | style=&quot;border: 1px solid rgb(1, 1, 1)&quot; width=&quot;198&quot; | <br /> TIMEREGRESOURCE_DATE<br /> <br /> | style=&quot;border: 1px solid rgb(1, 1, 1)&quot; width=&quot;120&quot; | <br /> Datetime<br /> <br /> | style=&quot;border: 1px solid rgb(1, 1, 1)&quot; width=&quot;558&quot; | <br /> It's array datetime <br /> <br /> |- valign=&quot;top&quot; align=&quot;left&quot;<br /> | style=&quot;border: 1px solid rgb(1, 1, 1)&quot; width=&quot;198&quot; | <br /> TIMEREGRESOURCE_ROLE_ID<br /> <br /> | style=&quot;border: 1px solid rgb(1, 1, 1)&quot; width=&quot;120&quot; | <br /> number<br /> <br /> | style=&quot;border: 1px solid rgb(1, 1, 1)&quot; width=&quot;558&quot; | <br /> It's Timereg role id<br /> <br /> |}<br /> <br /> <br /> === Examples ===<br /> <br /> &lt;source lang=&quot;javascript&quot;&gt;<br /> array dateStart = DateTime_fromInvariant(&quot;2016-04-01 00:00:00&quot;);<br /> array dateEnd = DateTime_fromInvariant(&quot;2016-04-10 00:00:00&quot;);<br /> Dictionary regtime = Timereg_getByUsers({717536}, dateStart, dateEnd);<br /> <br /> /*<br /> {<br /> &quot;717536&quot;: <br /> {<br /> {38,112561,1,796156,29185,{2016,4,1,0,0,0,0,13},0},<br /> {38,112975,1,794623,29327,{2016,4,5,0,0,0,0,14},0},<br /> {38,113095,1,797702,29185,{2016,4,1,0,0,0,0,13},0}<br /> }<br /> }<br /> */<br /> &lt;/source&gt;<br /> __NOTOC__</div> Lekhacbaongoc https://wiki.catglobe.com/index.php?title=TimeregStatus_getByUsers&diff=25385 TimeregStatus getByUsers 2016-04-14T10:43:11Z <p>Lekhacbaongoc: Created page with &quot;Category:Category:Functions {{HelpFiles}} ===TimeregStatus_getByUsers=== Get timereg status by user resource id ===Syntax=== Timereg_getByUsers(arrUserRid, dateS...&quot;</p> <hr /> <div>[[Category:Category:Functions]]<br /> {{HelpFiles}}<br /> <br /> ===TimeregStatus_getByUsers===<br /> <br /> Get timereg status by user resource id<br /> <br /> ===Syntax===<br /> <br /> Timereg_getByUsers(arrUserRid, dateStart, dateEnd);<br /> <br /> ===Arguments===<br /> <br /> *arrUserRid: Is array user resource id<br /> <br /> *dateStart: Day and time to start. It is Datetime object. <br /> <br /> *dateEnd: Day and time to end. It is Datetime object. <br /> <br /> ===Return type===<br /> <br /> The function returns a dictionary of user resource id as key and list of Timereg objects as value<br /> <br /> ===Examples===<br /> &lt;source lang=&quot;javascript&quot;&gt;<br /> array startDate = DateTime_fromInvariant(&quot;2015-09-10 00:00:00&quot;);<br /> array endDate = DateTime_fromInvariant(&quot;2016-09-10 00:00:00&quot;);<br /> array user = User_getCurrentUser();<br /> number urid = user[USER_RESOURCE_ID];<br /> Dictionary regtime = TimeregStatus_getByUsers({urid}, startDate, endDate);<br /> print(&quot;Count regtime: &quot; + regtime[urid].Count);<br /> number i = 0;<br /> for(i=0;i&lt;regtime[urid].Count;i++) {<br /> Timereg a = regtime[urid][i];<br /> print(&quot;Date : &quot; + convertToString(a.Date));<br /> print(&quot;Locked: &quot; + convertToString(a.Locked));<br /> print(&quot;ObjectTypeName: &quot; + convertToString(a.ObjectTypeName));<br /> print(&quot;Status: &quot; + convertToString(a.Status));<br /> print(&quot;TimeregPeriod Name: &quot; + convertToString(a.TimeregPeriod.Name));<br /> print(&quot;TimeregPeriod ObjectTypeName: &quot; + convertToString(a.TimeregPeriod.ObjectTypeName));<br /> print(&quot;TimeregPeriod FromDate: &quot; + convertToString(a.TimeregPeriod.FromDate));<br /> print(&quot;TimeregPeriod ToDate: &quot; + convertToString(a.TimeregPeriod.ToDate));<br /> print(&quot;TimeregPeriod Active: &quot; + convertToString(a.TimeregPeriod.Active));<br /> print(&quot;TotalHours: &quot; + convertToString(a.TotalHours));<br /> print(&quot;==========================================================\n&quot;);<br /> }<br /> <br /> /*<br /> Count regtime: 1<br /> Date : 2016-03-29 00:00:00<br /> Locked: False<br /> ObjectTypeName: Timereg<br /> Status: Met<br /> TimeregPeriod Name: 39.03.2016<br /> TimeregPeriod ObjectTypeName: TimeregPeriod<br /> TimeregPeriod FromDate: 2016-03-29 00:00:00<br /> TimeregPeriod ToDate: 2016-03-29 00:00:00<br /> TimeregPeriod Active: True<br /> TotalHours: 8<br /> ==========================================================<br /> */<br /> &lt;/source&gt;<br /> __NOTOC__</div> Lekhacbaongoc https://wiki.catglobe.com/index.php?title=Timereg_class&diff=25384 Timereg class 2016-04-14T10:14:40Z <p>Lekhacbaongoc: </p> <hr /> <div>{{CGscriptClass_Template<br /> |Name=Timereg<br /> |Description=Represent a registration time<br /> <br /> |Methods=<br /> {{CGscriptMethods_Template|ReturnType=empty|Name=Lock|Description=Lock the timereg and save it}}<br /> {{CGscriptMethods_Template|ReturnType=string|Name=ToString|Description=The string representation of the object.}}<br /> <br /> <br /> |Properties=<br /> {{CGscriptProperties_Template|ReturnType=DateTime|Name=Date|HasGetter=1|Description=Get registration date}}<br /> {{CGscriptProperties_Template|ReturnType=bool|Name=Locked|HasGetter=1|Description=Get if the registration is locked}}<br /> {{CGscriptProperties_Template|ReturnType=string|Name=ObjectTypeName|HasGetter=1|Description=The name of the type of object.}}<br /> {{CGscriptProperties_Template|ReturnType=string|Name=Status|HasGetter=1|Description=Get registration type of day (Met, Weekend,... etc)}}<br /> {{CGscriptProperties_Template|ReturnType=TimeregPeriod|Name=TimeregPeriod|HasGetter=1|Description=Get a TimePeriod object in association with the registration}}<br /> {{CGscriptProperties_Template|ReturnType=number|Name=TotalHours|HasGetter=1|Description=Get total hours registered}}<br /> }}<br /> <br /> <br /> &lt;source lang=&quot;javascript&quot;&gt;<br /> array startDate = DateTime_fromInvariant(&quot;2015-09-10 00:00:00&quot;);<br /> array endDate = DateTime_fromInvariant(&quot;2016-09-10 00:00:00&quot;);<br /> array user = User_getCurrentUser();<br /> number urid = user[USER_RESOURCE_ID];<br /> Dictionary regtime = TimeregStatus_getByUsers({urid}, startDate, endDate);<br /> print(&quot;Count regtime: &quot; + regtime[urid].Count);<br /> print(&quot;==========================================================\n&quot;);<br /> number i = 0;<br /> for(i=0;i&lt;regtime[urid].Count;i++) {<br /> Timereg a = regtime[urid][i];<br /> print(&quot;Date : &quot; + convertToString(a.Date));<br /> print(&quot;Locked: &quot; + convertToString(a.Locked));<br /> print(&quot;ObjectTypeName: &quot; + convertToString(a.ObjectTypeName));<br /> print(&quot;Status: &quot; + convertToString(a.Status));<br /> print(&quot;==========================================================\n&quot;);<br /> }<br /> /*<br /> Count regtime: 1<br /> ==========================================================<br /> <br /> Date : 2016-03-29 00:00:00<br /> Locked: False<br /> ObjectTypeName: Timereg<br /> Status: Met<br /> ==========================================================<br /> */<br /> &lt;/source&gt;</div> Lekhacbaongoc https://wiki.catglobe.com/index.php?title=TimeregPeriod_class&diff=25383 TimeregPeriod class 2016-04-14T10:12:03Z <p>Lekhacbaongoc: </p> <hr /> <div>{{CGscriptClass_Template<br /> |Name=TimeregPeriod <br /> |Description=Define a registration period<br /> <br /> |Methods=<br /> {{CGscriptMethods_Template|ReturnType=empty|Name=Activate|Description=Activate the period and save it}}<br /> {{CGscriptMethods_Template|ReturnType=empty|Name=Deactivate|Description=Deactivate the period and save it}}<br /> {{CGscriptMethods_Template|ReturnType=string|Name=ToString|Description=The string representation of the object.}}<br /> <br /> <br /> |Properties=<br /> {{CGscriptProperties_Template|ReturnType=bool|Name=Active|HasGetter=1|Description=Get if the period is active}}<br /> {{CGscriptProperties_Template|ReturnType=DateTime|Name=FromDate|HasGetter=1|Description=Get start date of the period}}<br /> {{CGscriptProperties_Template|ReturnType=string|Name=Name|HasGetter=1|Description=Get name of the period}}<br /> {{CGscriptProperties_Template|ReturnType=string|Name=ObjectTypeName |HasGetter=1|Description=The name of the type of object.}}<br /> {{CGscriptProperties_Template|ReturnType=DateTime|Name=ToDate |HasGetter=1|Description=Get end date of the period}}<br /> }}<br /> <br /> <br /> <br /> &lt;source lang=&quot;javascript&quot;&gt;<br /> array startDate = DateTime_fromInvariant(&quot;2015-09-10 00:00:00&quot;);<br /> array endDate = DateTime_fromInvariant(&quot;2016-09-10 00:00:00&quot;);<br /> array user = User_getCurrentUser();<br /> number urid = user[USER_RESOURCE_ID];<br /> Dictionary regtime = TimeregStatus_getByUsers({urid}, startDate, endDate);<br /> <br /> number i = 0;<br /> for(i=0;i&lt;regtime[urid].Count;i++) {<br /> Timereg a = regtime[urid][i];<br /> print(&quot;TimeregPeriod Name: &quot; + convertToString(a.TimeregPeriod.Name));<br /> print(&quot;TimeregPeriod ObjectTypeName: &quot; + convertToString(a.TimeregPeriod.ObjectTypeName));<br /> print(&quot;TimeregPeriod FromDate: &quot; + convertToString(a.TimeregPeriod.FromDate));<br /> print(&quot;TimeregPeriod ToDate: &quot; + convertToString(a.TimeregPeriod.ToDate));<br /> print(&quot;TimeregPeriod Active: &quot; + convertToString(a.TimeregPeriod.Active));<br /> print(&quot;TotalHours: &quot; + convertToString(a.TotalHours));<br /> print(&quot;==========================================================\n&quot;);<br /> }<br /> <br /> /*<br /> TimeregPeriod Name: 39.03.2016<br /> TimeregPeriod ObjectTypeName: TimeregPeriod<br /> TimeregPeriod FromDate: 2016-03-29 00:00:00<br /> TimeregPeriod ToDate: 2016-03-29 00:00:00<br /> TimeregPeriod Active: True<br /> TotalHours: 8<br /> ==========================================================<br /> <br /> */<br /> &lt;/source&gt;</div> Lekhacbaongoc https://wiki.catglobe.com/index.php?title=TimeregPeriod_class&diff=25382 TimeregPeriod class 2016-04-14T10:10:55Z <p>Lekhacbaongoc: </p> <hr /> <div>{{CGscriptClass_Template<br /> |Name=TimeregPeriod <br /> |Description=Define a registration period<br /> <br /> |Methods=<br /> {{CGscriptMethods_Template|ReturnType=empty|Name=Activate|Description=Activate the period and save it}}<br /> {{CGscriptMethods_Template|ReturnType=empty|Name=Deactivate|Description=Deactivate the period and save it}}<br /> {{CGscriptMethods_Template|ReturnType=string|Name=ToString|Description=The string representation of the object.}}<br /> <br /> <br /> |Properties=<br /> {{CGscriptProperties_Template|ReturnType=bool|Name=Active|HasGetter=1|Description=Get if the period is active}}<br /> {{CGscriptProperties_Template|ReturnType=DateTime|Name=FromDate|HasGetter=1|Description=Get start date of the period}}<br /> {{CGscriptProperties_Template|ReturnType=string|Name=Name|HasGetter=1|Description=Get name of the period}}<br /> {{CGscriptProperties_Template|ReturnType=string|Name=ObjectTypeName |HasGetter=1|Description=The name of the type of object.}}<br /> {{CGscriptProperties_Template|ReturnType=DateTime|Name=ToDate |HasGetter=1|Description=Get end date of the period}}<br /> }}<br /> <br /> <br /> <br /> &lt;source lang=&quot;javascript&quot;&gt;<br /> array startDate = DateTime_fromInvariant(&quot;2015-09-10 00:00:00&quot;);<br /> array endDate = DateTime_fromInvariant(&quot;2016-09-10 00:00:00&quot;);<br /> array user = User_getCurrentUser();<br /> number urid = user[USER_RESOURCE_ID];<br /> Dictionary regtime = TimeregStatus_getByUsers({urid}, startDate, endDate);<br /> <br /> number i = 0;<br /> for(i=0;i&lt;regtime[urid].Count;i++) {<br /> Timereg a = regtime[urid][i];<br /> print(&quot;Date : &quot; + convertToString(a.Date));<br /> print(&quot;Locked: &quot; + convertToString(a.Locked));<br /> print(&quot;ObjectTypeName: &quot; + convertToString(a.ObjectTypeName));<br /> print(&quot;Status: &quot; + convertToString(a.Status));<br /> print(&quot;TimeregPeriod Name: &quot; + convertToString(a.TimeregPeriod.Name));<br /> print(&quot;TimeregPeriod ObjectTypeName: &quot; + convertToString(a.TimeregPeriod.ObjectTypeName));<br /> print(&quot;TimeregPeriod FromDate: &quot; + convertToString(a.TimeregPeriod.FromDate));<br /> print(&quot;TimeregPeriod ToDate: &quot; + convertToString(a.TimeregPeriod.ToDate));<br /> print(&quot;TimeregPeriod Active: &quot; + convertToString(a.TimeregPeriod.Active));<br /> print(&quot;TotalHours: &quot; + convertToString(a.TotalHours));<br /> print(&quot;==========================================================\n&quot;);<br /> }<br /> <br /> /*<br /> Date : 2016-03-29 00:00:00<br /> Locked: False<br /> ObjectTypeName: Timereg<br /> Status: Met<br /> TimeregPeriod Name: 39.03.2016<br /> TimeregPeriod ObjectTypeName: TimeregPeriod<br /> TimeregPeriod FromDate: 2016-03-29 00:00:00<br /> TimeregPeriod ToDate: 2016-03-29 00:00:00<br /> TimeregPeriod Active: True<br /> TotalHours: 8<br /> ==========================================================<br /> */<br /> &lt;/source&gt;</div> Lekhacbaongoc https://wiki.catglobe.com/index.php?title=TimeregPeriod_class&diff=25381 TimeregPeriod class 2016-04-14T10:10:12Z <p>Lekhacbaongoc: </p> <hr /> <div>{{CGscriptClass_Template<br /> |Name=TimeregPeriod <br /> |Description=Define a registration period<br /> <br /> |Methods=<br /> {{CGscriptMethods_Template|ReturnType=empty|Name=Activate|Description=Activate the period and save it}}<br /> {{CGscriptMethods_Template|ReturnType=empty|Name=Deactivate|Description=Deactivate the period and save it}}<br /> {{CGscriptMethods_Template|ReturnType=string|Name=ToString|Description=The string representation of the object.}}<br /> <br /> <br /> |Properties=<br /> {{CGscriptProperties_Template|ReturnType=bool|Name=Active|HasGetter=1|Description=Get if the period is active}}<br /> {{CGscriptProperties_Template|ReturnType=DateTime|Name=FromDate|HasGetter=1|Description=Get start date of the period}}<br /> {{CGscriptProperties_Template|ReturnType=string|Name=Name|HasGetter=1|Description=Get name of the period}}<br /> {{CGscriptProperties_Template|ReturnType=string|Name=ObjectTypeName |HasGetter=1|Description=The name of the type of object.}}<br /> {{CGscriptProperties_Template|ReturnType=DateTime|Name=ToDate |HasGetter=1|Description=Get end date of the period}}<br /> }}<br /> <br /> &lt;source lang=&quot;javascript&quot;&gt;<br /> array startDate = DateTime_fromInvariant(&quot;2015-09-10 00:00:00&quot;);<br /> array endDate = DateTime_fromInvariant(&quot;2016-09-10 00:00:00&quot;);<br /> array user = User_getCurrentUser();<br /> number urid = user[USER_RESOURCE_ID];<br /> Dictionary regtime = TimeregStatus_getByUsers({urid}, startDate, endDate);<br /> print(&quot;Count regtime: &quot; + regtime[urid].Count);<br /> print(&quot;==========================================================\n&quot;);<br /> number i = 0;<br /> for(i=0;i&lt;regtime[urid].Count;i++) {<br /> Timereg a = regtime[urid][i];<br /> print(&quot;TimeregPeriod Name: &quot; + convertToString(a.TimeregPeriod.Name));<br /> print(&quot;TimeregPeriod ObjectTypeName: &quot; + convertToString(a.TimeregPeriod.ObjectTypeName));<br /> print(&quot;TimeregPeriod FromDate: &quot; + convertToString(a.TimeregPeriod.FromDate));<br /> print(&quot;TimeregPeriod ToDate: &quot; + convertToString(a.TimeregPeriod.ToDate));<br /> print(&quot;TimeregPeriod Active: &quot; + convertToString(a.TimeregPeriod.Active));<br /> print(&quot;TotalHours: &quot; + convertToString(a.TotalHours));<br /> print(&quot;==========================================================\n&quot;);<br /> }<br /> <br /> /*<br /> Count regtime: 1<br /> ==========================================================<br /> <br /> TimeregPeriod Name: 39.03.2016<br /> TimeregPeriod ObjectTypeName: TimeregPeriod<br /> TimeregPeriod FromDate: 2016-03-29 00:00:00<br /> TimeregPeriod ToDate: 2016-03-29 00:00:00<br /> TimeregPeriod Active: True<br /> TotalHours: 8<br /> ==========================================================<br /> */<br /> &lt;/source&gt;</div> Lekhacbaongoc https://wiki.catglobe.com/index.php?title=TimeregPeriod_class&diff=25380 TimeregPeriod class 2016-04-14T10:06:38Z <p>Lekhacbaongoc: Created page with &quot;{{CGscriptClass_Template |Name=TimeregPeriod |Description=Define a registration period |Methods= {{CGscriptMethods_Template|ReturnType=empty|Name=Activate|Description=Activa...&quot;</p> <hr /> <div>{{CGscriptClass_Template<br /> |Name=TimeregPeriod <br /> |Description=Define a registration period<br /> <br /> |Methods=<br /> {{CGscriptMethods_Template|ReturnType=empty|Name=Activate|Description=Activate the period and save it}}<br /> {{CGscriptMethods_Template|ReturnType=empty|Name=Deactivate|Description=Deactivate the period and save it}}<br /> {{CGscriptMethods_Template|ReturnType=string|Name=ToString|Description=The string representation of the object.}}<br /> <br /> <br /> |Properties=<br /> {{CGscriptProperties_Template|ReturnType=bool|Name=Active|HasGetter=1|Description=Get if the period is active}}<br /> {{CGscriptProperties_Template|ReturnType=DateTime|Name=FromDate|HasGetter=1|Description=Get start date of the period}}<br /> {{CGscriptProperties_Template|ReturnType=string|Name=Name|HasGetter=1|Description=Get name of the period}}<br /> {{CGscriptProperties_Template|ReturnType=string|Name=ObjectTypeName |HasGetter=1|Description=The name of the type of object.}}<br /> {{CGscriptProperties_Template|ReturnType=DateTime|Name=ToDate |HasGetter=1|Description=Get end date of the period}}<br /> }}</div> Lekhacbaongoc https://wiki.catglobe.com/index.php?title=Timereg_class&diff=25379 Timereg class 2016-04-14T10:01:49Z <p>Lekhacbaongoc: Created page with &quot;{{CGscriptClass_Template |Name=Timereg |Description=Represent a registration time |Methods= {{CGscriptMethods_Template|ReturnType=empty|Name=Lock|Description=Lock the timereg...&quot;</p> <hr /> <div>{{CGscriptClass_Template<br /> |Name=Timereg<br /> |Description=Represent a registration time<br /> <br /> |Methods=<br /> {{CGscriptMethods_Template|ReturnType=empty|Name=Lock|Description=Lock the timereg and save it}}<br /> {{CGscriptMethods_Template|ReturnType=string|Name=ToString|Description=The string representation of the object.}}<br /> <br /> <br /> |Properties=<br /> {{CGscriptProperties_Template|ReturnType=DateTime|Name=Date|HasGetter=1|Description=Get registration date}}<br /> {{CGscriptProperties_Template|ReturnType=bool|Name=Locked|HasGetter=1|Description=Get if the registration is locked}}<br /> {{CGscriptProperties_Template|ReturnType=string|Name=ObjectTypeName|HasGetter=1|Description=The name of the type of object.}}<br /> {{CGscriptProperties_Template|ReturnType=string|Name=Status|HasGetter=1|Description=Get registration type of day (Met, Weekend,... etc)}}<br /> {{CGscriptProperties_Template|ReturnType=TimeregPeriod|Name=TimeregPeriod|HasGetter=1|Description=Get a TimePeriod object in association with the registration}}<br /> {{CGscriptProperties_Template|ReturnType=number|Name=TotalHours|HasGetter=1|Description=Get total hours registered}}<br /> }}</div> Lekhacbaongoc https://wiki.catglobe.com/index.php?title=Group_areMemberOfGroup&diff=25378 Group areMemberOfGroup 2016-04-09T03:59:47Z <p>Lekhacbaongoc: </p> <hr /> <div>[[Category:Group_Functions]]<br /> {{HelpFiles}}<br /> <br /> ===Group_areMemberOfGroup===<br /> <br /> Check the list user resource id are members of the group.<br /> <br /> Which takes the array user resource id and group resource id and returns dictionary of id and true/false. True if member, false if not<br /> <br /> ===Syntax===<br /> <br /> Group_areMemberOfGroup(arrayUserRid,groupRid);<br /> <br /> ===Arguments===<br /> <br /> arrayUserRid: Array number resource id of users<br /> <br /> groupRid: Is a number resource id of the group<br /> <br /> ===Return type===<br /> <br /> Dictionary<br /> <br /> ===Examples===<br /> &lt;source lang=&quot;javascript&quot;&gt;<br /> Group_areMemberOfGroup({3,4,55,56,6407},6397);<br /> //{&quot;3&quot;: False, &quot;4&quot;: False, &quot;55&quot;: False, &quot;56&quot;: False, &quot;6407&quot;: True}<br /> &lt;/source&gt;<br /> __NOTOC__</div> Lekhacbaongoc https://wiki.catglobe.com/index.php?title=Group_areMemberOfGroup&diff=25377 Group areMemberOfGroup 2016-04-09T03:59:01Z <p>Lekhacbaongoc: </p> <hr /> <div>{{HelpFiles}}<br /> <br /> === Group_areMemberOfGroup ===<br /> <br /> Check the list user resource id are members of the group.<br /> <br /> Which takes the array user resource id and group resource id and returns dictionary of id and true/false. True if member, false if not<br /> <br /> === Syntax ===<br /> <br /> Group_areMemberOfGroup(arrayUserRid,groupRid);<br /> <br /> === Arguments ===<br /> <br /> arrayUserRid: Array number resource id of users<br /> <br /> groupRid: Is a number resource id of the group<br /> <br /> === Return type ===<br /> <br /> Dictionary<br /> <br /> === Examples ===<br /> <br /> &lt;source lang=&quot;javascript&quot;&gt;<br /> Group_areMemberOfGroup({3,4,55,56,6407},6397);<br /> //{&quot;3&quot;: False, &quot;4&quot;: False, &quot;55&quot;: False, &quot;56&quot;: False, &quot;6407&quot;: True}<br /> &lt;/source&gt; __NOTOC__</div> Lekhacbaongoc https://wiki.catglobe.com/index.php?title=Group_areMemberOfGroup&diff=25376 Group areMemberOfGroup 2016-04-09T03:58:09Z <p>Lekhacbaongoc: Created page with &quot;Category:Group_Functions {{HelpFiles}} ===Group_areMemberOfGroup=== Check the list user resource id are members of the group. Which takes the array user resource i...&quot;</p> <hr /> <div>[[Category:Group_Functions]]<br /> {{HelpFiles}}<br /> <br /> ===Group_areMemberOfGroup===<br /> <br /> Check the list user resource id are members of the group.<br /> Which takes the array user resource id and group resource id and returns dictionary of id and true/false. True if member, false if not<br /> <br /> ===Syntax===<br /> <br /> Group_areMemberOfGroup(arrayUserRid,groupRid);<br /> <br /> ===Arguments===<br /> <br /> arrayUserRid: Array number resource id of users<br /> groupRid: Is a number resource id of the group<br /> <br /> ===Return type===<br /> <br /> Dictionary<br /> <br /> ===Examples===<br /> &lt;source lang=&quot;javascript&quot;&gt;<br /> Group_areMemberOfGroup({3,4,55,56,6407},6397);<br /> //{&quot;3&quot;: False, &quot;4&quot;: False, &quot;55&quot;: False, &quot;56&quot;: False, &quot;6407&quot;: True}<br /> &lt;/source&gt;<br /> __NOTOC__</div> Lekhacbaongoc https://wiki.catglobe.com/index.php?title=User_getResourceIdFromUserIds&diff=25375 User getResourceIdFromUserIds 2016-04-09T03:46:15Z <p>Lekhacbaongoc: </p> <hr /> <div>[[Category:User_Functions]]<br /> {{HelpFiles}}<br /> <br /> ===User_getResourceIdFromUserIds===<br /> <br /> Get the list resource id from list user id<br /> <br /> ===Syntax===<br /> <br /> User_getResourceIdFromUserIds(arrayUserid);<br /> <br /> ===Arguments===<br /> <br /> arrayUserid: array number id of users.<br /> <br /> ===Return type===<br /> <br /> Array resource id<br /> <br /> ===Examples===<br /> &lt;source lang=&quot;javascript&quot;&gt;<br /> User_getResourceIdFromUserIds({1,2,3,4});<br /> //{3,4,55,56}<br /> &lt;/source&gt;<br /> __NOTOC__</div> Lekhacbaongoc https://wiki.catglobe.com/index.php?title=User_getResourceIdFromUserIds&diff=25374 User getResourceIdFromUserIds 2016-04-09T03:45:50Z <p>Lekhacbaongoc: Created page with &quot;{{HelpFiles}} = User_getResourceIdFromUserIds = Get the list resource id from list user id === Syntax === User_getResourceIdFromUserIds(arrayUserid); === Arguments === a...&quot;</p> <hr /> <div>{{HelpFiles}}<br /> <br /> = User_getResourceIdFromUserIds =<br /> <br /> Get the list resource id from list user id<br /> <br /> === Syntax ===<br /> <br /> User_getResourceIdFromUserIds(arrayUserid);<br /> <br /> === Arguments ===<br /> <br /> arrayUserid: array number id of users.<br /> <br /> === Return type ===<br /> <br /> Array resource id<br /> <br /> === Examples ===<br /> <br /> &lt;source lang=&quot;javascript&quot;&gt;<br /> User_getResourceIdFromUserIds({1,2,3,4});<br /> //{3,4,55,56}<br /> &lt;/source&gt; __NOTOC__</div> Lekhacbaongoc https://wiki.catglobe.com/index.php?title=Question_getAll&diff=25360 Question getAll 2016-02-17T09:52:06Z <p>Lekhacbaongoc: </p> <hr /> <div>[[Category:Questionnaire_Functions]]<br /> {{HelpFiles}}<br /> <br /> === Question_getAll ===<br /> <br /> Get all question by Questionnaire resource Id. <br /> <br /> This function needs RPQ context.<br /> <br /> === Syntax ===<br /> <br /> Question_getAll(questionnaireResourceId[, Isocode]);<br /> <br /> === Arguments ===<br /> <br /> questionnaireResourceId: is a number expression, it is resource id of Questionnaire.<br /> <br /> Isocode: is a string expression, it is [http://www.lingoes.net/en/translator/langcode.htm Iso code] of language<br /> === Return type ===<br /> <br /> array<br /> <br /> === Examples ===<br /> <br /> &lt;source lang=&quot;javascript&quot;&gt;<br /> Question_getAll(234110);<br /> /*<br /> {{12,6801,9,D_Initialize,,{},{}},{12,6805,5,D_InitializeJSON,,{},{}},{12,6802,4,BROWSER,,{},<br /> {}},{12,6803,1,D_CurrentLanguage,,{{13,1,United Kingdom},{13,2,Gemany}},{}},{12,6804,1,Intro,,<br /> {{13,1,I am from SUB},{13,2,I am from HQ}},{}},{12,6806,1,Q1,&lt;p&gt; Please rate the day on relevance and quality &lt;/p&gt;,<br /> {{13,1,Very low},{13,2,Low}, {13,3,Moderate},{13,4,High},{13,5,Very High}},{}}}<br /> */<br /> &lt;/source&gt; __NOTOC__</div> Lekhacbaongoc https://wiki.catglobe.com/index.php?title=Question_getAll&diff=25359 Question getAll 2016-02-17T09:51:28Z <p>Lekhacbaongoc: </p> <hr /> <div>[[Category:Questionnaire_Functions]] (Please change to the correct category)<br /> {{HelpFiles}}<br /> <br /> === Question_getAll ===<br /> <br /> Get all question by Questionnaire resource Id. This function needs RPQ context.<br /> <br /> === Syntax ===<br /> <br /> Question_getAll(questionnaireResourceId[, Isocode]);<br /> <br /> === Arguments ===<br /> <br /> questionnaireResourceId: is a number expression, it is resource id of Questionnaire.<br /> Isocode: is a string expression, it is [http://www.lingoes.net/en/translator/langcode.htm Iso code] of language<br /> === Return type ===<br /> <br /> array<br /> <br /> === Examples ===<br /> <br /> &lt;source lang=&quot;javascript&quot;&gt;<br /> Question_getAll(234110);<br /> /*<br /> {{12,6801,9,D_Initialize,,{},{}},{12,6805,5,D_InitializeJSON,,{},{}},{12,6802,4,BROWSER,,{},<br /> {}},{12,6803,1,D_CurrentLanguage,,{{13,1,United Kingdom},{13,2,Gemany}},{}},{12,6804,1,Intro,,<br /> {{13,1,I am from SUB},{13,2,I am from HQ}},{}},{12,6806,1,Q1,&lt;p&gt; Please rate the day on relevance and quality &lt;/p&gt;,<br /> {{13,1,Very low},{13,2,Low}, {13,3,Moderate},{13,4,High},{13,5,Very High}},{}}}<br /> */<br /> &lt;/source&gt; __NOTOC__</div> Lekhacbaongoc https://wiki.catglobe.com/index.php?title=Question_getAll&diff=25358 Question getAll 2016-02-17T09:26:57Z <p>Lekhacbaongoc: </p> <hr /> <div>[[Category:Questionnaire_Functions]]<br /> {{HelpFiles}}<br /> <br /> === Question_getAll ===<br /> <br /> Get all question by Questionnaire resource Id. This function needs RPQ context.<br /> <br /> === Syntax ===<br /> <br /> Question_getAll(questionnaireResourceId);<br /> <br /> === Arguments ===<br /> <br /> questionnaireResourceId: is a number expression, it is resource id of Questionnaire.<br /> <br /> === Return type ===<br /> <br /> array<br /> <br /> === Examples ===<br /> <br /> &lt;source lang=&quot;javascript&quot;&gt;<br /> Question_getAll(234110);<br /> /*<br /> {{12,6801,9,D_Initialize,,{},{}},{12,6805,5,D_InitializeJSON,,{},{}},{12,6802,4,BROWSER,,{},<br /> {}},{12,6803,1,D_CurrentLanguage,,{{13,1,United Kingdom},{13,2,Gemany}},{}},{12,6804,1,Intro,,<br /> {{13,1,I am from SUB},{13,2,I am from HQ}},{}},{12,6806,1,Q1,&lt;p&gt; Please rate the day on relevance and quality &lt;/p&gt;,<br /> {{13,1,Very low},{13,2,Low}, {13,3,Moderate},{13,4,High},{13,5,Very High}},{}}}<br /> */<br /> &lt;/source&gt; __NOTOC__</div> Lekhacbaongoc https://wiki.catglobe.com/index.php?title=Question_getAll&diff=25357 Question getAll 2016-02-17T09:24:50Z <p>Lekhacbaongoc: </p> <hr /> <div>[[Category:Questionnaire_Functions]]<br /> {{HelpFiles}}<br /> <br /> === Question_getAll ===<br /> <br /> Get all question by Questionnaire resource Id. This function needs RPQ context.<br /> <br /> === Syntax ===<br /> <br /> Question_getAll(questionnaireResourceId);<br /> <br /> === Arguments ===<br /> <br /> questionnaireResourceId: is a number expression, it is resource id of Questionnaire.<br /> <br /> === Return type ===<br /> <br /> array<br /> <br /> === Examples ===<br /> <br /> &lt;source lang=&quot;javascript&quot;&gt;<br /> Question_getAll(234110);<br /> /*<br /> {{12,6801,9,D_Initialize,,{},{}},{12,6805,5,D_InitializeJSON,,{},{}},{12,6802,4,BROWSER,,{},{}},{12,6803,1,D_CurrentLanguage,,{{13,1,United Kingdom},{13,2,Gemany}},{}},{12,6804,1,Intro,,<br /> {{13,1,I am from SUB},{13,2,I am from HQ}},{}},{12,6806,1,Q1,&lt;p&gt; Please rate the day on relevance and quality &lt;/p&gt;,{{13,1,Very low},{13,2,Low}, {13,3,Moderate},{13,4,High},{13,5,Very High}},{}}}<br /> */<br /> &lt;/source&gt; __NOTOC__</div> Lekhacbaongoc https://wiki.catglobe.com/index.php?title=Question_getAll&diff=25356 Question getAll 2016-02-17T09:24:15Z <p>Lekhacbaongoc: </p> <hr /> <div>[[Category:Questionnaire_Functions]]<br /> {{HelpFiles}}<br /> <br /> === Question_getAll ===<br /> <br /> Get all question by Questionnaire resource Id. This function needs RPQ context.<br /> <br /> === Syntax ===<br /> <br /> Question_getAll(questionnaireResourceId);<br /> <br /> === Arguments ===<br /> <br /> questionnaireResourceId: is a number expression, it is resource id of Questionnaire.<br /> <br /> === Return type ===<br /> <br /> array<br /> <br /> === Examples ===<br /> <br /> &lt;source lang=&quot;javascript&quot;&gt;<br /> Question_getAll(234110);<br /> /*<br /> {{12,6801,9,D_Initialize,,{},{}},{12,6805,5,D_InitializeJSON,,{},{}},{12,6802,4,BROWSER,,{},{}},{12,6803,1,D_CurrentLanguage,,{{13,1,United Kingdom},{13,2,Gemany}},{}},{12,6804,1,Intro,,<br /> {{13,1,I am from SUB},{13,2,I am from HQ}},{}},{12,6806,1,Q1,&lt;p&gt; Please rate the day on relevance and quality &lt;/p&gt;,{{13,1,Very low},{13,2,Low}, {13,3,Moderate},{13,4,High},{13,5,Very High}},{}}}<br /> */<br /> &lt;/source&gt; __NOTOC__</div> Lekhacbaongoc https://wiki.catglobe.com/index.php?title=Question_getAll&diff=25355 Question getAll 2016-02-17T09:23:21Z <p>Lekhacbaongoc: </p> <hr /> <div>{{HelpFiles}}<br /> <br /> === Question_getAll ===<br /> <br /> Get all question by Questionnaire resource Id. This function needs RPQ context.<br /> <br /> === Syntax ===<br /> <br /> Question_getAll(questionnaireResourceId);<br /> <br /> === Arguments ===<br /> <br /> questionnaireResourceId: is a number expression, it is resource id of Questionnaire.<br /> <br /> === Return type ===<br /> <br /> array<br /> <br /> === Examples ===<br /> <br /> &lt;source lang=&quot;javascript&quot;&gt;<br /> Question_getAll(234110);<br /> /*<br /> {{12,6801,9,D_Initialize,,{},{}},{12,6805,5,D_InitializeJSON,,{},{}},{12,6802,4,BROWSER,,{},{}},{12,6803,1,D_CurrentLanguage,,{{13,1,United Kingdom},{13,2,Gemany}},{}},{12,6804,1,Intro,,<br /> {{13,1,I am from SUB},{13,2,I am from HQ}},{}},{12,6806,1,Q1,&lt;p&gt; Please rate the day on relevance and quality &lt;/p&gt;,{{13,1,Very low},{13,2,Low}, {13,3,Moderate},{13,4,High},{13,5,Very High}},{}}}<br /> */<br /> &lt;/source&gt; __NOTOC__</div> Lekhacbaongoc https://wiki.catglobe.com/index.php?title=Question_getAll&diff=25354 Question getAll 2016-02-17T09:22:52Z <p>Lekhacbaongoc: </p> <hr /> <div>{{HelpFiles}}<br /> <br /> === Question_getAll ===<br /> <br /> Get all question by Questionnaire resource Id. This function needs RPQ context.<br /> <br /> === Syntax ===<br /> <br /> Question_getAll(questionnaireResourceId);<br /> <br /> === Arguments ===<br /> <br /> questionnaireResourceId: is a number expression, it is resource id of Questionnaire.<br /> <br /> === Return type ===<br /> <br /> array<br /> <br /> === Examples ===<br /> <br /> &lt;source lang=&quot;javascript&quot;&gt;<br /> Question_getAll(234110);<br /> /*<br /> {{12,6801,9,D_Initialize,,{},{}},{12,6805,5,D_InitializeJSON,,{},{}},{12,6802,4,BROWSER,,{},{}},{12,6803,1,D_CurrentLanguage,,{{13,1,United Kingdom},{13,2,Gemany}},{}},{12,6804,1,Intro,,<br /> {{13,1,I am from SUB},{13,2,I am from HQ}},{}},{12,6806,1,Q1,&lt;p&gt; Please rate the day on relevance and quality &lt;/p&gt;,{{13,1,Very low},{13,2,Low}, {13,3,Moderate},{13,4,High},{13,5,Very High}},{}}}<br /> */<br /> &lt;/source&gt; __NOTOC__</div> Lekhacbaongoc https://wiki.catglobe.com/index.php?title=Question_getAll&diff=25353 Question getAll 2016-02-17T09:22:05Z <p>Lekhacbaongoc: </p> <hr /> <div>{{HelpFiles}}<br /> <br /> === Question_getAll ===<br /> <br /> Get all question by Questionnaire resource Id. This function needs RPQ context.<br /> <br /> === Syntax ===<br /> <br /> Question_getAll(questionnaireResourceId);<br /> <br /> === Arguments ===<br /> <br /> questionnaireResourceId: is a number expression, it is resource id of Questionnaire.<br /> <br /> === Return type ===<br /> <br /> array<br /> <br /> === Examples ===<br /> <br /> &lt;source lang=&quot;javascript&quot;&gt;<br /> Question_getAll(234110);<br /> /*<br /> {{12,6801,9,D_Initialize,,{},{}},{12,6805,5,D_InitializeJSON,,{},{}},{12,6802,4,BROWSER,,{},{}},{12,6803,1,D_CurrentLanguage,,{{13,1,United Kingdom},<br /> {13,2,Gemany}},{}},{12,6804,1,Intro,,{{13,1,I am from SUB},{13,2,I am from HQ}},{}},{12,6806,1,Q1,&lt;p&gt; Please rate the day on relevance and quality &lt;/p&gt;,{{13,1,Very low},{13,2,Low}, <br /> {13,3,Moderate},{13,4,High},{13,5,Very High}},{}}}<br /> */<br /> &lt;/source&gt; __NOTOC__</div> Lekhacbaongoc https://wiki.catglobe.com/index.php?title=Question_getAll&diff=25352 Question getAll 2016-02-17T09:21:34Z <p>Lekhacbaongoc: </p> <hr /> <div>{{HelpFiles}}<br /> <br /> ===Question_getAll===<br /> <br /> Get all question by Questionnaire resource Id. This function needs RPQ context.<br /> <br /> === Syntax ===<br /> <br /> Question_getAll(questionnaireResourceId);<br /> <br /> === Arguments ===<br /> <br /> questionnaireResourceId: is a number expression, it is resource id of Questionnaire.<br /> <br /> === Return type ===<br /> <br /> array<br /> <br /> === Examples ===<br /> <br /> &lt;source lang=&quot;javascript&quot;&gt;<br /> Question_getAll(234110);<br /> //{{12,6801,9,D_Initialize,,{},{}},{12,6805,5,D_InitializeJSON,,{},{}},{12,6802,4,BROWSER,,{},{}},{12,6803,1,D_CurrentLanguage,,{{13,1,United Kingdom},<br /> //{13,2,Gemany}},{}},{12,6804,1,Intro,,{{13,1,I am from SUB},{13,2,I am from HQ}},{}},{12,6806,1,Q1,&lt;p&gt; Please rate the day on relevance and quality &lt;/p&gt;,{{13,1,Very low},{13,2,Low}, //{13,3,Moderate},{13,4,High},{13,5,Very High}},{}}}<br /> &lt;/source&gt; __NOTOC__</div> Lekhacbaongoc https://wiki.catglobe.com/index.php?title=Question_getAll&diff=25351 Question getAll 2016-02-17T09:20:49Z <p>Lekhacbaongoc: Created page with &quot;Category:Questionnaire_Functions {{HelpFiles}} =Question_getAll= Get all question by Questionnaire resource Id. This function needs RPQ context. ===Syntax=== Que...&quot;</p> <hr /> <div>[[Category:Questionnaire_Functions]]<br /> {{HelpFiles}}<br /> <br /> =Question_getAll=<br /> <br /> Get all question by Questionnaire resource Id.<br /> This function needs RPQ context.<br /> <br /> ===Syntax===<br /> <br /> Question_getAll(questionnaireResourceId);<br /> <br /> ===Arguments===<br /> <br /> questionnaireResourceId: is a number expression, it is resource id of Questionnaire. <br /> <br /> ===Return type===<br /> <br /> array<br /> <br /> ===Examples===<br /> &lt;source lang=&quot;javascript&quot;&gt;<br /> Question_getAll(234110);<br /> //{{12,6801,9,D_Initialize,,{},{}},{12,6805,5,D_InitializeJSON,,{},{}},{12,6802,4,BROWSER,,{},{}},{12,6803,1,D_CurrentLanguage,,{{13,1,United Kingdom},{13,2,Gemany}},{}},{12,6804,1,Intro,,{{13,1,I am from SUB},{13,2,I am from HQ}},{}},{12,6806,1,Q1,&lt;p&gt; Please rate the day on relevance and quality &lt;/p&gt;,{{13,1,Very low},{13,2,Low},{13,3,Moderate},{13,4,High},{13,5,Very High}},{}}}<br /> &lt;/source&gt;<br /> __NOTOC__</div> Lekhacbaongoc https://wiki.catglobe.com/index.php?title=Timereg_getByUsers&diff=25350 Timereg getByUsers 2016-02-05T09:18:35Z <p>Lekhacbaongoc: </p> <hr /> <div>[[Category:Functions]]<br /> {{HelpFiles}}<br /> <br /> ===Timereg_getByUsers===<br /> <br /> Returns a dictionary where keys are resource ids and value is a dictionary where the key is the userid and the value is a list of timereg arrays ordered by the date. <br /> <br /> ===Syntax===<br /> <br /> Timereg_getByUsers(UserResourceId, dateStart, dateEnd)<br /> <br /> ===Arguments===<br /> <br /> *UserResourceId: is a array user resource id<br /> *dateStart: is a array datetime<br /> *dateEnd: is a array datetime<br /> <br /> ===Return type===<br /> <br /> Dictionary<br /> <br /> ===Examples===<br /> &lt;source lang=&quot;javascript&quot;&gt;<br /> array dateStart = DateTime_fromInvariant(&quot;2016-01-05 00:00:00&quot;);<br /> array dateEnd = DateTime_fromInvariant(&quot;2016-02-05 00:00:00&quot;);<br /> Dictionary regtime = Timereg_getByUsers({717536}, dateStart, dateEnd);<br /> &lt;/source&gt;<br /> __NOTOC__</div> Lekhacbaongoc https://wiki.catglobe.com/index.php?title=Timereg_getByUsers&diff=25349 Timereg getByUsers 2016-02-05T09:18:03Z <p>Lekhacbaongoc: </p> <hr /> <div>[[Category:Functions]]<br /> {{HelpFiles}}<br /> <br /> =Timereg_getByUsers=<br /> <br /> Returns a dictionary where keys are resource ids and value is a dictionary where the key is the userid and the value is a list of timereg arrays ordered by the date. <br /> <br /> ===Syntax===<br /> <br /> Timereg_getByUsers(UserResourceId, dateStart, dateEnd)<br /> <br /> ===Arguments===<br /> <br /> *UserResourceId: is a array user resource id<br /> *dateStart: is a array datetime<br /> *dateEnd: is a array datetime<br /> <br /> ===Return type===<br /> <br /> Dictionary<br /> <br /> ===Examples===<br /> &lt;source lang=&quot;javascript&quot;&gt;<br /> array dateStart = DateTime_fromInvariant(&quot;2016-01-05 00:00:00&quot;);<br /> array dateEnd = DateTime_fromInvariant(&quot;2016-02-05 00:00:00&quot;);<br /> Dictionary regtime = Timereg_getByUsers({717536}, dateStart, dateEnd);<br /> &lt;/source&gt;<br /> __NOTOC__</div> Lekhacbaongoc https://wiki.catglobe.com/index.php?title=Timereg_getByUsers&diff=25348 Timereg getByUsers 2016-02-05T09:13:49Z <p>Lekhacbaongoc: Created page with &quot;Category:Functions {{HelpFiles}} =Timereg_getByUsers= Returns a dictionary where keys are resource ids and value is a dictionary where the key is the userid and th...&quot;</p> <hr /> <div>[[Category:Functions]]<br /> {{HelpFiles}}<br /> <br /> =Timereg_getByUsers=<br /> <br /> Returns a dictionary where keys are resource ids and value is a dictionary where the key is the userid and the value is a list of timereg arrays ordered by the date. <br /> <br /> ===Syntax===<br /> <br /> Timereg_getByUsers(UserResourceId, dateStart, dateEnd)<br /> <br /> ===Arguments===<br /> <br /> *UserResourceId: is a array user resource id<br /> *dateStart: is a array datetime<br /> *dateEnd: is a array datetime<br /> <br /> ===Return type===<br /> <br /> Dictionary<br /> <br /> ===Examples===<br /> &lt;source lang=&quot;javascript&quot;&gt;<br /> array dateStart = DateTime_fromInvariant(&quot;2016-01-05 00:00:00&quot;);<br /> array dateEnd = DateTime_fromInvariant(&quot;2016-02-05 00:00:00&quot;);<br /> <br /> Dictionary regtime = Timereg_getByUsers({717536}, dateStart, dateEnd);<br /> &lt;/source&gt;<br /> __NOTOC__</div> Lekhacbaongoc https://wiki.catglobe.com/index.php?title=File:2016-01-06_16-47-44.png&diff=25318 File:2016-01-06 16-47-44.png 2016-01-11T07:30:37Z <p>Lekhacbaongoc: MsUpload</p> <hr /> <div>MsUpload</div> Lekhacbaongoc https://wiki.catglobe.com/index.php?title=Tabulation_setTableDiagramStyle&diff=25307 Tabulation setTableDiagramStyle 2015-12-08T02:52:44Z <p>Lekhacbaongoc: </p> <hr /> <div>[[Category:Style_setting_functions]]<br /> {{HelpFiles}}<br /> <br /> ===Tabulation_setTableDiagramStyle===<br /> <br /> Sets the style for a chart. <br /> <br /> ===Syntax===<br /> <br /> Tabulation_setTableDiagramStyle(styleType, tableDiagramStyle, argTableDiagramStyle);<br /> <br /> ===Arguments===<br /> <br /> *styleType: is the CELL type that will be affected by the call. It's the value of the Table diagram constants. Or we can also use the name of [http://wiki.catglobe.com/index.php/CGS_Constants_list#Table_Diagram_constants Table Diagram constants]<br /> *tableDiagramStyle: is the kind of style. It's the value of the Table Diagram style constants. Or we can also use the name of [http://wiki.catglobe.com/index.php/CGS_Constants_list#Table_Diagram_style_constants Table Diagram style constants]<br /> *argTableDiagramStyle: is argument for the given tableDiagramStyle<br /> <br /> {| class=&quot;tableintopic&quot; style=&quot;border-collapse: collapse; border: 1px solid rgb(1, 1, 1)&quot; border=&quot;1&quot; cellpadding=&quot;2&quot; width=&quot;958&quot;<br /> |- align=&quot;left&quot; valign=&quot;top&quot;<br /> | style=&quot;border: 1px solid #010101&quot; bgcolor=&quot;#F59D56&quot; width=&quot;227&quot; | <br /> TableDiagramStyle<br /> <br /> | style=&quot;border: 1px solid #010101&quot; bgcolor=&quot;#F59D56&quot; width=&quot;73&quot; |<br /> Argument type<br /> <br /> | style=&quot;border: 1px solid #010101&quot; bgcolor=&quot;#F59D56&quot; width=&quot;433&quot; | <br /> Description<br /> <br /> |-<br /> | colspan=&quot;1&quot; style=&quot;border: 1px solid #010101&quot; width=&quot;227&quot; | TABLE_DIAGRAM_STYLE_FILL&lt;br/&gt;<br /> | style=&quot;border: 1px solid #010101&quot; width=&quot;73&quot; | array&lt;br/&gt;<br /> | style=&quot;border: 1px solid #010101&quot; width=&quot;433&quot; | Is the array of function [http://wiki.catglobe.com/index.php/DiagramFillStyle_getDefault DiagramFillStyle_getDefault]&lt;br/&gt;<br /> |-<br /> | colspan=&quot;1&quot; style=&quot;border: 1px solid #010101&quot; width=&quot;227&quot; | TABLE_DIAGRAM_STYLE_DECIMAL&lt;br/&gt;<br /> | style=&quot;border: 1px solid #010101&quot; width=&quot;174&quot; | number&lt;br/&gt;<br /> | With min 0&lt;br/&gt;<br /> |-<br /> | colspan=&quot;1&quot; style=&quot;border: 1px solid #010101&quot; width=&quot;227&quot; | TABLE_DIAGRAM_STYLE_FONT&lt;br/&gt;<br /> | style=&quot;border: 1px solid #010101&quot; width=&quot;174&quot; | array&lt;br/&gt;<br /> | Is the array of function [http://wiki.catglobe.com/index.php/DiagramFontStyle_getDefault DiagramFontStyle_getDefault]&lt;br/&gt;<br /> |-<br /> | colspan=&quot;1&quot; style=&quot;border: 1px solid #010101&quot; width=&quot;227&quot; | TABLE_DIAGRAM_STYLE_VALIGN&lt;br/&gt;<br /> | style=&quot;border: 1px solid #010101&quot; width=&quot;174&quot; | string&lt;br/&gt;<br /> | takes string values of these Center, Top, Bottom&lt;br/&gt;<br /> |-<br /> | colspan=&quot;1&quot; style=&quot;border: 1px solid #010101&quot; width=&quot;227&quot; | TABLE_DIAGRAM_STYLE_HALIGN&lt;br/&gt;<br /> | style=&quot;border: 1px solid #010101&quot; width=&quot;174&quot; | string&lt;br/&gt;<br /> | takes string values of these Center, Left, Right&lt;br/&gt;<br /> |-<br /> | colspan=&quot;1&quot; style=&quot;border: 1px solid #010101&quot; width=&quot;227&quot; | TABLE_DIAGRAM_STYLE_NUMBER_FORMATTER&lt;br/&gt;<br /> | style=&quot;border: 1px solid #010101&quot; width=&quot;174&quot; | string&lt;br/&gt;<br /> | takes a string.format string, default is &quot;{0:&quot;+decimalplaces+&quot;}&quot;&lt;br/&gt;<br /> |-<br /> | colspan=&quot;1&quot; style=&quot;border: 1px solid #010101&quot; width=&quot;227&quot; | TABLE_DIAGRAM_STYLE_PERCENT_FORMATTER&lt;br/&gt;<br /> | style=&quot;border: 1px solid #010101&quot; width=&quot;174&quot; | string&lt;br/&gt;<br /> | takes a string.format string, default is &quot;{0:&quot;+decimalplaces+&quot;}%&quot;&lt;br/&gt;<br /> |-<br /> | colspan=&quot;1&quot; style=&quot;border: 1px solid #010101&quot; width=&quot;227&quot; | TABLE_DIAGRAM_STYLE_SIGNIFICANCE_FORMATTER&lt;br/&gt;<br /> | style=&quot;border: 1px solid #010101&quot; width=&quot;174&quot; | string&lt;br/&gt;<br /> | takes a string.format string, default is &quot;{0:[+];[-];,} {1}&quot;&lt;br/&gt;where 0 is int that is positive, negative or zero depending on significance and 1 is the Z value&lt;br/&gt;<br /> |-<br /> | colspan=&quot;1&quot; style=&quot;border: 1px solid #010101&quot; width=&quot;227&quot; | TABLE_DIAGRAM_STYLE_BORDER_STYLE&lt;br/&gt;<br /> | style=&quot;border: 1px solid #010101&quot; width=&quot;174&quot; | object&lt;br/&gt;<br /> | takes a [http://wiki.catglobe.com/index.php/TabulationBorder_class Border object]&lt;br/&gt;<br /> |}<br /> <br /> ===Return type===<br /> <br /> Empty<br /> <br /> ===Examples===<br /> *Before set Table diagram style<br /> [[File:Tabulation setTableDiagramStyle1.png|none]]<br /> <br /> <br /> &lt;source lang=&quot;javascript&quot;&gt;<br /> DCS_use(15507609);<br /> Tabulation_setTableLayout(TableChartLayout_Classic);<br /> <br /> array FoS_default = DiagramFontStyle_getDefault(); //Gets a default chart font style object<br /> //Custom chart font style<br /> FoS_default[DIAGRAM_FONT_STYLE_COLOR] = Color_getByRGB(&quot;#000000&quot;);<br /> FoS_default[DIAGRAM_FONT_STYLE_FACE] = &quot;Arial&quot;;<br /> FoS_default[DIAGRAM_FONT_STYLE_SIZE] = 10;<br /> <br /> array FiS_default = DiagramFillStyle_getDefault(); //Gets a default chart fill style object<br /> //Custom chart fill style<br /> FiS_default[DIAGRAM_FILL_STYLE_COLOR] = Color_getByRGB(&quot;#f3f4f5&quot;);<br /> <br /> Tabulation_setTableDiagramStyle(TableDiagram_AllTable, TABLE_DIAGRAM_STYLE_FONT, FoS_default); //Set custom chart font style<br /> Tabulation_setTableDiagramStyle(TableDiagram_AllTable, TABLE_DIAGRAM_STYLE_FILL, FiS_default); //Set custom chart fill style<br /> Tabulation_setTableDiagramStyle(TableDiagram_AllTable, TABLE_DIAGRAM_STYLE_VALIGN, &quot;center&quot;); //Vertical align the content inside<br /> Tabulation_setTableDiagramStyle(TableDiagram_AllTable, TABLE_DIAGRAM_STYLE_HALIGN, &quot;right&quot;); //Horizontal align the content inside<br /> Tabulation_setTableDiagramStyle(TableDiagram_AllTable, TABLE_DIAGRAM_STYLE_NUMBER_FORMATTER, &quot;{0:#;minus #;zero}&quot;); //Set number style format<br /> Tabulation_setTableDiagramStyle(TableDiagram_AllTable, TABLE_DIAGRAM_STYLE_PERCENT_FORMATTER, &quot;{0:#;minus #;zero}pct&quot;); //Set percent style format<br /> Tabulation_setTableDiagramStyle(TableDiagram_AllTable, TABLE_DIAGRAM_STYLE_SIGNIFICANCE_FORMATTER, &quot;{1}{0:+;-;,}&quot;); //Set significance style format<br /> <br /> createCrossDiagram({&quot;QA1&quot;},{&quot;D_Age_Group&quot;});<br /> &lt;/source&gt;<br /> <br /> *After setting Table diagram style with source above<br /> [[File:Tabulation setTableDiagramStyle2.png|none]]<br /> <br /> <br /> <br /> <br /> &lt;source lang=&quot;javascript&quot;&gt;<br /> DCS_use(15507609);<br /> Tabulation_setTableLayout(TableChartLayout_Classic);<br /> array FoS_header = DiagramFontStyle_getDefault(); <br /> FoS_header[DIAGRAM_FONT_STYLE_COLOR] = Color_getByRGB(&quot;#307D7E&quot;);<br /> <br /> array FiS_header = DiagramFillStyle_getDefault();<br /> FiS_header[DIAGRAM_FILL_STYLE_COLOR] = Color_getByRGB(&quot;#AF7817&quot;);<br /> <br /> Tabulation_setTableDiagramStyle(TableDiagram_ColumnHeaderLevel1, TABLE_DIAGRAM_STYLE_FONT, FoS_header);<br /> Tabulation_setTableDiagramStyle(TableDiagram_ColumnHeaderLevel1, TABLE_DIAGRAM_STYLE_FILL, FiS_header);<br /> Tabulation_setTableDiagramStyle(TableDiagram_ColumnHeaderLevel1, TABLE_DIAGRAM_STYLE_HALIGN, &quot;center&quot;);<br /> object customBorderLevel2 = new TabulationBorder(&quot;Top,Bottom&quot;, 2, &quot;Solid&quot;, Color_getByRGB(&quot;#000000&quot;));<br /> Tabulation_setTableDiagramStyle(TableDiagram_ColumnHeaderLevel2, TABLE_DIAGRAM_STYLE_BORDER_STYLE, customBorderLevel2);<br /> Tabulation_setTableDiagramStyle(TableDiagram_AbsoluteColumn, TABLE_DIAGRAM_STYLE_FONT, FoS_header);<br /> Tabulation_setTableDiagramStyle(TableDiagram_AbsoluteColumn, TABLE_DIAGRAM_STYLE_FILL, FiS_header);<br /> Tabulation_setTableDiagramStyle(TableDiagram_AbsoluteColumn, TABLE_DIAGRAM_STYLE_HALIGN, &quot;center&quot;);<br /> <br /> <br /> //-----------------------------<br /> Tabulation_setTableDiagramStyle(TableDiagram_AbsoluteColumnValue, TABLE_DIAGRAM_STYLE_DECIMAL, 0);<br /> //-----------------------------<br /> FiS_header[DIAGRAM_FILL_STYLE_COLOR] = Color_getByRGB(&quot;#387C44&quot;);<br /> Tabulation_setTableDiagramStyle(TableDiagram_ColumnHeaderLevel2, TABLE_DIAGRAM_STYLE_DECIMAL, 1);<br /> Tabulation_setTableDiagramStyle(TableDiagram_ColumnHeaderLevel2, TABLE_DIAGRAM_STYLE_FILL, FiS_header);<br /> Tabulation_setTableDiagramStyle(TableDiagram_PercentageColumn, TABLE_DIAGRAM_STYLE_DECIMAL, 1);<br /> Tabulation_setTableDiagramStyle(TableDiagram_PercentageColumn, TABLE_DIAGRAM_STYLE_FILL, FiS_header);<br /> <br /> ///////////////////////////////////////////////////////////////<br /> array FoS_default = DiagramFontStyle_getDefault(); <br /> FoS_default[DIAGRAM_FONT_STYLE_BOLD] = true; <br /> Tabulation_setTableDiagramStyle(TableDiagram_SignificanceCell, TABLE_DIAGRAM_STYLE_FONT, FoS_default);<br /> TabulationBorder tb = new TabulationBorder(&quot;Left&quot;, 2, &quot;Solid&quot;, Color_getByRGB(&quot;#303030&quot;));<br /> Tabulation_setTableDiagramStyle(TableDiagram_SignificanceCell, TABLE_DIAGRAM_STYLE_BORDER_STYLE, tb);<br /> <br /> array FiS_default = DiagramFillStyle_getDefault();<br /> FoS_default[DIAGRAM_FONT_STYLE_BOLD] = false; <br /> FoS_default[DIAGRAM_FONT_STYLE_COLOR] = Color_getByRGB(&quot;#000000&quot;);<br /> FiS_default[DIAGRAM_FILL_STYLE_COLOR] = Color_getByRGB(&quot;#307D7E&quot;);<br /> Tabulation_setTableDiagramStyle(TableDiagram_SignificanceRow, TABLE_DIAGRAM_STYLE_FONT, FoS_default);<br /> Tabulation_setTableDiagramStyle(TableDiagram_SignificanceRow, TABLE_DIAGRAM_STYLE_FILL, FiS_default);<br /> <br /> createCrossDiagram({&quot;QA1&quot;},{&quot;D_Age_Group&quot;});<br /> &lt;/source&gt;<br /> <br /> *After setting Table diagram style with source above<br /> [[File:setTableDiagramStyle3.png|none]]<br /> <br /> <br /> <br /> <br /> &lt;source lang=&quot;javascript&quot;&gt;<br /> DCS_use(15507609);<br /> Tabulation_setTableLayout(TableChartLayout_Standard);<br /> <br /> Tabulation_setSignificance(true);<br /> Tabulation_setCountAnswer(true);<br /> <br /> Tabulation_setMergeStatisticPctItem(true);<br /> Tabulation_setEnableOddEvenRowHeader(true);<br /> <br /> Tabulation_setAbsText(&quot;abs&quot;);<br /> Tabulation_setPctText(&quot;%&quot;);<br /> Tabulation_setTotalText(&quot;Resp.&quot;);<br /> //--------------------------------------------------//<br /> array FoS_default = DiagramFontStyle_getDefault();<br /> FoS_default[DIAGRAM_FONT_STYLE_COLOR] = Color_getByRGB(&quot;#000000&quot;);<br /> FoS_default[DIAGRAM_FONT_STYLE_FACE] = &quot;Arial&quot;;<br /> FoS_default[DIAGRAM_FONT_STYLE_SIZE] = 10 ;<br /> <br /> array FiS_default = DiagramFillStyle_getDefault();<br /> FiS_default[DIAGRAM_FILL_STYLE_INHERIT] = true;<br /> <br /> array DiagramS_default = Tabulation_getDefaultDiagramStyle(Diagram_Type_Table);<br /> DiagramS_default[TABLE_DIAGRAM_STYLE_FONT] = FoS_default;<br /> DiagramS_default[TABLE_DIAGRAM_STYLE_FILL] = FiS_default;<br /> DiagramS_default[TABLE_DIAGRAM_STYLE_VALIGN] = &quot;center&quot;;<br /> DiagramS_default[TABLE_DIAGRAM_STYLE_HALIGN] = &quot;right&quot;;<br /> DiagramS_default[TABLE_DIAGRAM_STYLE_DECIMAL] = 0;<br /> <br /> Tabulation_setDiagramStyle(TableDiagram_AllTable, DiagramS_default);<br /> //--------------------------------------------------//<br /> FiS_default[DIAGRAM_FILL_STYLE_COLOR] = Color_getByRGB(&quot;#FFFFFF&quot;);<br /> FiS_default[DIAGRAM_FILL_STYLE_INHERIT] = false;<br /> Tabulation_setTableDiagramStyle(TableDiagram_ColumnHeader, TABLE_DIAGRAM_STYLE_FILL, FiS_default);<br /> <br /> FoS_default[DIAGRAM_FONT_STYLE_BOLD] = true;<br /> Tabulation_setTableDiagramStyle(TableDiagram_SignificanceCell, TABLE_DIAGRAM_STYLE_FONT, FoS_default);<br /> Tabulation_setTableDiagramStyle(TableDiagram_SignificanceCell, TABLE_DIAGRAM_STYLE_HALIGN, &quot;right&quot;);<br /> <br /> Tabulation_setTableDiagramStyle(TableDiagram_ColumnHeaderLevel1, TABLE_DIAGRAM_STYLE_HALIGN, &quot;center&quot;);<br /> Tabulation_setTableDiagramStyle(TableDiagram_ColumnHeaderLevel2, TABLE_DIAGRAM_STYLE_HALIGN, &quot;center&quot;);<br /> <br /> Tabulation_setTableDiagramStyle(TableDiagram_SignificanceRowValue, TABLE_DIAGRAM_STYLE_HALIGN, &quot;center&quot;);<br /> object customBorderAllTable = new TabulationBorder(&quot;Top,Bottom,Left,Right&quot;, 0, &quot;None&quot;, Color_getByRGB(&quot;#000000&quot;));<br /> Tabulation_setTableDiagramStyle(TableDiagram_AllTable, TABLE_DIAGRAM_STYLE_BORDER_STYLE, customBorderAllTable);<br /> object customBorderHeaderLevel1 = new TabulationBorder(&quot;Bottom&quot;, 1, &quot;Solid&quot;, Color_getByRGB(&quot;#000000&quot;));<br /> Tabulation_setTableDiagramStyle(TableDiagram_ColumnHeaderLevel1, TABLE_DIAGRAM_STYLE_BORDER_STYLE, customBorderHeaderLevel1);<br /> object customBorderHeaderLevel2 = new TabulationBorder(&quot;Top,Bottom&quot;, 1, &quot;Solid&quot;, Color_getByRGB(&quot;#000000&quot;));<br /> Tabulation_setTableDiagramStyle(TableDiagram_ColumnHeaderLevel2, TABLE_DIAGRAM_STYLE_BORDER_STYLE, customBorderHeaderLevel2);<br /> object customBorderTotalRowValue = new TabulationBorder(&quot;Top&quot;, 1, &quot;Solid&quot;, Color_getByRGB(&quot;#000000&quot;));<br /> Tabulation_setTableDiagramStyle(TableDiagram_TotalRowValue, TABLE_DIAGRAM_STYLE_BORDER_STYLE, customBorderTotalRowValue);<br /> object customBorderSpacerCell = new TabulationBorder(&quot;All&quot;, 0, &quot;None&quot;, Color_getByRGB(&quot;#000000&quot;));<br /> Tabulation_setTableDiagramStyle(TableDiagram_SpacerCell, TABLE_DIAGRAM_STYLE_BORDER_STYLE, customBorderSpacerCell);<br /> <br /> <br /> Tabulation_setTableDiagramStyle(TableDiagram_AllTable, TABLE_DIAGRAM_STYLE_NUMBER_FORMATTER, &quot;{0:##,#;(##,#)}&quot;);<br /> Tabulation_setTableDiagramStyle(TableDiagram_AllTable, TABLE_DIAGRAM_STYLE_PERCENT_FORMATTER, &quot;{0:##,#;(##,#)}&quot;);<br /> Tabulation_setTableDiagramStyle(TableDiagram_AllTable, TABLE_DIAGRAM_STYLE_SIGNIFICANCE_FORMATTER, &quot;{1}{0:+;-;,}&quot;);<br /> <br /> createCrossDiagram({&quot;QA1&quot;},{&quot;D_Age_Group&quot;});<br /> &lt;/source&gt;<br /> *After setting Table diagram style with source above<br /> [[File:setTableDiagramStyle4.png|none]]<br /> <br /> __NOTOC__</div> Lekhacbaongoc https://wiki.catglobe.com/index.php?title=Tabulation_setTableDiagramStyle&diff=25305 Tabulation setTableDiagramStyle 2015-12-08T02:44:07Z <p>Lekhacbaongoc: </p> <hr /> <div>[[Category:Style_setting_functions]]<br /> {{HelpFiles}}<br /> <br /> ===Tabulation_setTableDiagramStyle===<br /> <br /> Sets the style for a chart. <br /> <br /> ===Syntax===<br /> <br /> Tabulation_setTableDiagramStyle(styleType, tableDiagramStyle, argTableDiagramStyle);<br /> <br /> ===Arguments===<br /> <br /> *styleType: is the CELL type that will be affected by the call. It's the value of the Table diagram constants. Or we can also use the name of [http://wiki.catglobe.com/index.php/CGS_Constants_list#Table_Diagram_constants Table Diagram constants]<br /> *tableDiagramStyle: is the kind of style. It's the value of the Table Diagram style constants. Or we can also use the name of [http://wiki.catglobe.com/index.php/CGS_Constants_list#Table_Diagram_style_constants Table Diagram style constants]<br /> *argTableDiagramStyle: is argument for the given tableDiagramStyle<br /> <br /> {| class=&quot;tableintopic&quot; style=&quot;border-collapse: collapse; border: 1px solid rgb(1, 1, 1)&quot; border=&quot;1&quot; cellpadding=&quot;2&quot; width=&quot;958&quot;<br /> |- align=&quot;left&quot; valign=&quot;top&quot;<br /> | style=&quot;border: 1px solid #010101&quot; bgcolor=&quot;#F59D56&quot; width=&quot;227&quot; | <br /> TableDiagramStyle<br /> <br /> | style=&quot;border: 1px solid #010101&quot; bgcolor=&quot;#F59D56&quot; width=&quot;73&quot; |<br /> Argument type<br /> <br /> | style=&quot;border: 1px solid #010101&quot; bgcolor=&quot;#F59D56&quot; width=&quot;433&quot; | <br /> Description<br /> <br /> |-<br /> | colspan=&quot;1&quot; style=&quot;border: 1px solid #010101&quot; width=&quot;227&quot; | TABLE_DIAGRAM_STYLE_FILL&lt;br/&gt;<br /> | style=&quot;border: 1px solid #010101&quot; width=&quot;73&quot; | array&lt;br/&gt;<br /> | style=&quot;border: 1px solid #010101&quot; width=&quot;433&quot; | Is the array of function [http://wiki.catglobe.com/index.php/DiagramFillStyle_getDefault DiagramFillStyle_getDefault]&lt;br/&gt;<br /> |-<br /> | colspan=&quot;1&quot; style=&quot;border: 1px solid #010101&quot; width=&quot;227&quot; | TABLE_DIAGRAM_STYLE_DECIMAL&lt;br/&gt;<br /> | style=&quot;border: 1px solid #010101&quot; width=&quot;174&quot; | number&lt;br/&gt;<br /> | With min 0&lt;br/&gt;<br /> |-<br /> | colspan=&quot;1&quot; style=&quot;border: 1px solid #010101&quot; width=&quot;227&quot; | TABLE_DIAGRAM_STYLE_FONT&lt;br/&gt;<br /> | style=&quot;border: 1px solid #010101&quot; width=&quot;174&quot; | array&lt;br/&gt;<br /> | Is the array of function [http://wiki.catglobe.com/index.php/DiagramFontStyle_getDefault DiagramFontStyle_getDefault]&lt;br/&gt;<br /> |-<br /> | colspan=&quot;1&quot; style=&quot;border: 1px solid #010101&quot; width=&quot;227&quot; | TABLE_DIAGRAM_STYLE_VALIGN&lt;br/&gt;<br /> | style=&quot;border: 1px solid #010101&quot; width=&quot;174&quot; | string&lt;br/&gt;<br /> | takes string values of these Center, Top, Bottom&lt;br/&gt;<br /> |-<br /> | colspan=&quot;1&quot; style=&quot;border: 1px solid #010101&quot; width=&quot;227&quot; | TABLE_DIAGRAM_STYLE_HALIGN&lt;br/&gt;<br /> | style=&quot;border: 1px solid #010101&quot; width=&quot;174&quot; | string&lt;br/&gt;<br /> | takes string values of these Center, Left, Right&lt;br/&gt;<br /> |-<br /> | colspan=&quot;1&quot; style=&quot;border: 1px solid #010101&quot; width=&quot;227&quot; | TABLE_DIAGRAM_STYLE_NUMBER_FORMATTER&lt;br/&gt;<br /> | style=&quot;border: 1px solid #010101&quot; width=&quot;174&quot; | string&lt;br/&gt;<br /> | takes a string.format string, default is &quot;{0:&quot;+decimalplaces+&quot;}&quot;&lt;br/&gt;<br /> |-<br /> | colspan=&quot;1&quot; style=&quot;border: 1px solid #010101&quot; width=&quot;227&quot; | TABLE_DIAGRAM_STYLE_PERCENT_FORMATTER&lt;br/&gt;<br /> | style=&quot;border: 1px solid #010101&quot; width=&quot;174&quot; | string&lt;br/&gt;<br /> | takes a string.format string, default is &quot;{0:&quot;+decimalplaces+&quot;}%&quot;&lt;br/&gt;<br /> |-<br /> | colspan=&quot;1&quot; style=&quot;border: 1px solid #010101&quot; width=&quot;227&quot; | TABLE_DIAGRAM_STYLE_SIGNIFICANCE_FORMATTER&lt;br/&gt;<br /> | style=&quot;border: 1px solid #010101&quot; width=&quot;174&quot; | string&lt;br/&gt;<br /> | takes a string.format string, default is &quot;{0:[+];[-];,} {1}&quot;&lt;br/&gt;where 0 is int that is positive, negative or zero depending on significance and 1 is the Z value&lt;br/&gt;<br /> |-<br /> | colspan=&quot;1&quot; style=&quot;border: 1px solid #010101&quot; width=&quot;227&quot; | TABLE_DIAGRAM_STYLE_BORDER_STYLE&lt;br/&gt;<br /> | style=&quot;border: 1px solid #010101&quot; width=&quot;174&quot; | object&lt;br/&gt;<br /> | takes a [http://wiki.catglobe.com/index.php/TabulationBorder_class Border object]&lt;br/&gt;<br /> |}<br /> <br /> ===Return type===<br /> <br /> Empty<br /> <br /> ===Examples===<br /> *Before set Table diagram style<br /> [[File:Tabulation setTableDiagramStyle1.png|none]]<br /> <br /> <br /> &lt;source lang=&quot;javascript&quot;&gt;<br /> DCS_use(15507609);<br /> Tabulation_setTableLayout(TableChartLayout_Classic);<br /> <br /> array FoS_default = DiagramFontStyle_getDefault(); //Gets a default chart font style object<br /> //Custom chart font style<br /> FoS_default[DIAGRAM_FONT_STYLE_COLOR] = Color_getByRGB(&quot;#000000&quot;);<br /> FoS_default[DIAGRAM_FONT_STYLE_FACE] = &quot;Arial&quot;;<br /> FoS_default[DIAGRAM_FONT_STYLE_SIZE] = 10;<br /> <br /> array FiS_default = DiagramFillStyle_getDefault(); //Gets a default chart fill style object<br /> //Custom chart fill style<br /> FiS_default[DIAGRAM_FILL_STYLE_COLOR] = Color_getByRGB(&quot;#f3f4f5&quot;);<br /> <br /> Tabulation_setTableDiagramStyle(TableDiagram_AllTable, TABLE_DIAGRAM_STYLE_FONT, FoS_default); //Set custom chart font style<br /> Tabulation_setTableDiagramStyle(TableDiagram_AllTable, TABLE_DIAGRAM_STYLE_FILL, FiS_default); //Set custom chart fill style<br /> Tabulation_setTableDiagramStyle(TableDiagram_AllTable, TABLE_DIAGRAM_STYLE_VALIGN, &quot;center&quot;); //Vertical align the content inside<br /> Tabulation_setTableDiagramStyle(TableDiagram_AllTable, TABLE_DIAGRAM_STYLE_HALIGN, &quot;right&quot;); //Horizontal align the content inside<br /> Tabulation_setTableDiagramStyle(TableDiagram_AllTable, TABLE_DIAGRAM_STYLE_NUMBER_FORMATTER, &quot;{0:#;minus #;zero}&quot;); //Set number style format<br /> Tabulation_setTableDiagramStyle(TableDiagram_AllTable, TABLE_DIAGRAM_STYLE_PERCENT_FORMATTER, &quot;{0:#;minus #;zero}pct&quot;); //Set percent style format<br /> Tabulation_setTableDiagramStyle(TableDiagram_AllTable, TABLE_DIAGRAM_STYLE_SIGNIFICANCE_FORMATTER, &quot;{1}{0:+;-;,}&quot;); //Set significance style format<br /> <br /> createCrossDiagram({&quot;QA1&quot;},{&quot;D_Age_Group&quot;});<br /> &lt;/source&gt;<br /> <br /> *After setting Table diagram style with source above<br /> [[File:Tabulation setTableDiagramStyle2.png|none]]<br /> <br /> <br /> <br /> <br /> &lt;source lang=&quot;javascript&quot;&gt;<br /> DCS_use(15507609);<br /> Tabulation_setTableLayout(TableChartLayout_Classic);<br /> array FoS_header = DiagramFontStyle_getDefault(); <br /> FoS_header[DIAGRAM_FONT_STYLE_COLOR] = Color_getByRGB(&quot;#307D7E&quot;);<br /> <br /> array FiS_header = DiagramFillStyle_getDefault();<br /> FiS_header[DIAGRAM_FILL_STYLE_COLOR] = Color_getByRGB(&quot;#AF7817&quot;);<br /> <br /> Tabulation_setTableDiagramStyle(TableDiagram_ColumnHeaderLevel1, TABLE_DIAGRAM_STYLE_FONT, FoS_header);<br /> Tabulation_setTableDiagramStyle(TableDiagram_ColumnHeaderLevel1, TABLE_DIAGRAM_STYLE_FILL, FiS_header);<br /> Tabulation_setTableDiagramStyle(TableDiagram_ColumnHeaderLevel1, TABLE_DIAGRAM_STYLE_HALIGN, &quot;center&quot;);<br /> Tabulation_setTableDiagramStyle(TableDiagram_ColumnHeaderLevel2, TABLE_DIAGRAM_STYLE_BORDER_STYLE, new TabulationBorder(&quot;Top,Bottom&quot;, 2, &quot;Solid&quot;, Color_getByRGB(&quot;#000000&quot;)));<br /> Tabulation_setTableDiagramStyle(TableDiagram_AbsoluteColumn, TABLE_DIAGRAM_STYLE_FONT, FoS_header);<br /> Tabulation_setTableDiagramStyle(TableDiagram_AbsoluteColumn, TABLE_DIAGRAM_STYLE_FILL, FiS_header);<br /> Tabulation_setTableDiagramStyle(TableDiagram_AbsoluteColumn, TABLE_DIAGRAM_STYLE_HALIGN, &quot;center&quot;);<br /> <br /> <br /> //-----------------------------<br /> Tabulation_setTableDiagramStyle(TableDiagram_AbsoluteColumnValue, TABLE_DIAGRAM_STYLE_DECIMAL, 0);<br /> //-----------------------------<br /> FiS_header[DIAGRAM_FILL_STYLE_COLOR] = Color_getByRGB(&quot;#387C44&quot;);<br /> Tabulation_setTableDiagramStyle(TableDiagram_ColumnHeaderLevel2, TABLE_DIAGRAM_STYLE_DECIMAL, 1);<br /> Tabulation_setTableDiagramStyle(TableDiagram_ColumnHeaderLevel2, TABLE_DIAGRAM_STYLE_FILL, FiS_header);<br /> Tabulation_setTableDiagramStyle(TableDiagram_PercentageColumn, TABLE_DIAGRAM_STYLE_DECIMAL, 1);<br /> Tabulation_setTableDiagramStyle(TableDiagram_PercentageColumn, TABLE_DIAGRAM_STYLE_FILL, FiS_header);<br /> <br /> ///////////////////////////////////////////////////////////////<br /> array FoS_default = DiagramFontStyle_getDefault(); <br /> FoS_default[DIAGRAM_FONT_STYLE_BOLD] = true; <br /> Tabulation_setTableDiagramStyle(TableDiagram_SignificanceCell, TABLE_DIAGRAM_STYLE_FONT, FoS_default);<br /> TabulationBorder tb = new TabulationBorder(&quot;Left&quot;, 2, &quot;Solid&quot;, Color_getByRGB(&quot;#303030&quot;));<br /> Tabulation_setTableDiagramStyle(TableDiagram_SignificanceCell, TABLE_DIAGRAM_STYLE_BORDER_STYLE, tb);<br /> <br /> array FiS_default = DiagramFillStyle_getDefault();<br /> FoS_default[DIAGRAM_FONT_STYLE_BOLD] = false; <br /> FoS_default[DIAGRAM_FONT_STYLE_COLOR] = Color_getByRGB(&quot;#000000&quot;);<br /> FiS_default[DIAGRAM_FILL_STYLE_COLOR] = Color_getByRGB(&quot;#307D7E&quot;);<br /> Tabulation_setTableDiagramStyle(TableDiagram_SignificanceRow, TABLE_DIAGRAM_STYLE_FONT, FoS_default);<br /> Tabulation_setTableDiagramStyle(TableDiagram_SignificanceRow, TABLE_DIAGRAM_STYLE_FILL, FiS_default);<br /> <br /> createCrossDiagram({&quot;QA1&quot;},{&quot;D_Age_Group&quot;});<br /> &lt;/source&gt;<br /> <br /> *After setting Table diagram style with source above<br /> [[File:setTableDiagramStyle3.png|none]]<br /> <br /> <br /> <br /> <br /> &lt;source lang=&quot;javascript&quot;&gt;<br /> DCS_use(15507609);<br /> Tabulation_setTableLayout(TableChartLayout_Standard);<br /> <br /> Tabulation_setSignificance(true);<br /> Tabulation_setCountAnswer(true);<br /> <br /> Tabulation_setMergeStatisticPctItem(true);<br /> Tabulation_setEnableOddEvenRowHeader(true);<br /> <br /> Tabulation_setAbsText(&quot;abs&quot;);<br /> Tabulation_setPctText(&quot;%&quot;);<br /> Tabulation_setTotalText(&quot;Resp.&quot;);<br /> //--------------------------------------------------//<br /> array FoS_default = DiagramFontStyle_getDefault();<br /> FoS_default[DIAGRAM_FONT_STYLE_COLOR] = Color_getByRGB(&quot;#000000&quot;);<br /> FoS_default[DIAGRAM_FONT_STYLE_FACE] = &quot;Arial&quot;;<br /> FoS_default[DIAGRAM_FONT_STYLE_SIZE] = 10 ;<br /> <br /> array FiS_default = DiagramFillStyle_getDefault();<br /> FiS_default[DIAGRAM_FILL_STYLE_INHERIT] = true;<br /> <br /> array DiagramS_default = Tabulation_getDefaultDiagramStyle(Diagram_Type_Table);<br /> DiagramS_default[TABLE_DIAGRAM_STYLE_FONT] = FoS_default;<br /> DiagramS_default[TABLE_DIAGRAM_STYLE_FILL] = FiS_default;<br /> DiagramS_default[TABLE_DIAGRAM_STYLE_VALIGN] = &quot;center&quot;;<br /> DiagramS_default[TABLE_DIAGRAM_STYLE_HALIGN] = &quot;right&quot;;<br /> DiagramS_default[TABLE_DIAGRAM_STYLE_DECIMAL] = 0;<br /> <br /> Tabulation_setDiagramStyle(TableDiagram_AllTable, DiagramS_default);<br /> //--------------------------------------------------//<br /> FiS_default[DIAGRAM_FILL_STYLE_COLOR] = Color_getByRGB(&quot;#FFFFFF&quot;);<br /> FiS_default[DIAGRAM_FILL_STYLE_INHERIT] = false;<br /> Tabulation_setTableDiagramStyle(TableDiagram_ColumnHeader, TABLE_DIAGRAM_STYLE_FILL, FiS_default);<br /> <br /> FoS_default[DIAGRAM_FONT_STYLE_BOLD] = true;<br /> Tabulation_setTableDiagramStyle(TableDiagram_SignificanceCell, TABLE_DIAGRAM_STYLE_FONT, FoS_default);<br /> Tabulation_setTableDiagramStyle(TableDiagram_SignificanceCell, TABLE_DIAGRAM_STYLE_HALIGN, &quot;right&quot;);<br /> <br /> Tabulation_setTableDiagramStyle(TableDiagram_ColumnHeaderLevel1, TABLE_DIAGRAM_STYLE_HALIGN, &quot;center&quot;);<br /> Tabulation_setTableDiagramStyle(TableDiagram_ColumnHeaderLevel2, TABLE_DIAGRAM_STYLE_HALIGN, &quot;center&quot;);<br /> <br /> Tabulation_setTableDiagramStyle(TableDiagram_SignificanceRowValue, TABLE_DIAGRAM_STYLE_HALIGN, &quot;center&quot;);<br /> <br /> Tabulation_setTableDiagramStyle(TableDiagram_AllTable, TABLE_DIAGRAM_STYLE_BORDER_STYLE, new TabulationBorder(&quot;Top,Bottom,Left,Right&quot;, 0, &quot;None&quot;, Color_getByRGB(&quot;#000000&quot;)));<br /> Tabulation_setTableDiagramStyle(TableDiagram_ColumnHeaderLevel1, TABLE_DIAGRAM_STYLE_BORDER_STYLE, new TabulationBorder(&quot;Bottom&quot;, 1, &quot;Solid&quot;, Color_getByRGB(&quot;#000000&quot;)));<br /> Tabulation_setTableDiagramStyle(TableDiagram_ColumnHeaderLevel2, TABLE_DIAGRAM_STYLE_BORDER_STYLE, new TabulationBorder(&quot;Top,Bottom&quot;, 1, &quot;Solid&quot;, Color_getByRGB(&quot;#000000&quot;)));<br /> Tabulation_setTableDiagramStyle(TableDiagram_TotalRowValue, TABLE_DIAGRAM_STYLE_BORDER_STYLE, new TabulationBorder(&quot;Top&quot;, 1, &quot;Solid&quot;, Color_getByRGB(&quot;#000000&quot;)));<br /> Tabulation_setTableDiagramStyle(TableDiagram_SpacerCell, TABLE_DIAGRAM_STYLE_BORDER_STYLE, new TabulationBorder(&quot;All&quot;, 0, &quot;None&quot;, Color_getByRGB(&quot;#000000&quot;)));<br /> <br /> <br /> Tabulation_setTableDiagramStyle(TableDiagram_AllTable, TABLE_DIAGRAM_STYLE_NUMBER_FORMATTER, &quot;{0:##,#;(##,#)}&quot;);<br /> Tabulation_setTableDiagramStyle(TableDiagram_AllTable, TABLE_DIAGRAM_STYLE_PERCENT_FORMATTER, &quot;{0:##,#;(##,#)}&quot;);<br /> Tabulation_setTableDiagramStyle(TableDiagram_AllTable, TABLE_DIAGRAM_STYLE_SIGNIFICANCE_FORMATTER, &quot;{1}{0:+;-;,}&quot;);<br /> <br /> createCrossDiagram({&quot;QA1&quot;},{&quot;D_Age_Group&quot;});<br /> &lt;/source&gt;<br /> *After setting Table diagram style with source above<br /> [[File:setTableDiagramStyle4.png|none]]<br /> <br /> __NOTOC__</div> Lekhacbaongoc