MS4BIĀ®

MS4BI HELP 2022

by MS4script
01-Introduction
Preface & Copyright
Getting started
Informations + Cmd/param Server
Demos Simple
02- Declarations
Structure
Type
03- Instructions
Conditions if,do,while..
String functions Str..()
Get + Include functions Get, Include..
Date-Time Day, Time, Year.
Display
Call
Formulas Complex
04- Database
Connector Ado, Odbc, Dsn, SAP, Ms4
DB Connect Create, delete
Import DataSource Import, Consolidation
Administration Admin, User
05- Sql-Query
Sql
Query Form : BTS,PLUS
Grid option
06- Charts
Forms Plus, Win, Image, Excel, Morris...
Pie Std, Donut, 3D...
Bar Std, Stack, Line, Area, Plot
Radar
QrCode, Gauge
Step, Stock...
,Google,Leaflet... GeoMap
,Gantt,Timeline,Org.
DrawWindow [web]
07- Dashboard
Form tab, no tab
Responsive UI
08- Report
Report Hierarchy
Report Design
09- Filters
Dialogue + Call
10- Menus
Menu Design
Menu Frameset
Menu Custom
11-UI : Responsive
Tables Responsive,Frame,position
List Group
Text
Panel Header, body, Footer
Button Button, Progress Bar
Icon & Button
Collapse Group, Panel
Notifications
12- Encryption
Encrypt
Decrypt
13- Windows
Dialogue
Picture, Frame, Button..
MsgBox
Grid

Designer

00-OverView
01-Transaction
02-Setting
05-Import
10-Formula
15-Report-Part1
16-Report-Part2
20-Query-Part1
21-Query-Part2
25-Report-Query-Style
30-QrCodeImage
31-Windows
32-Frame
40-TabStrip
50-Collapse
60-BeginForm
63-Input-SubmitBox
70-Input-Select
71-Input-Insert
72-Input-Update
73-Input-Delete
75-Input-Query
77-ListComBo
81-Button-Link
82-Button-DataList
86-Sticky-Label
91-Insert-PhpJsHtml
92-Insert-MS4script
15- Css, html, Php, js.
Insert Native language Begin_sw..End_Sw
16-Install + tools.
Installation & Configuration This Menu
Generate Native... Php, Html, js..
Code Generator Ms4 Script
MarkDown Ms4 Script
Source Code Menu Help This Menu
written with ms4script
      

BASIC HELP : MS4BI by MS4script

2022 version 1.10

Chapter 6 : CHARTS

KEYWORD : FORMGOOGLE : DRAWGANTT

Definition

Based on the GOOGLE graphics library, displays Standard, Pie, Bar, Grid , GeoMap, Gantt, Timeline, Organization, WordTree charts .

Syntax 1

  	
	 	
	FormGoogle : DRAWGANTT 
	 Begin_sw
	([  
** columns are :
Task ID ,Task Name,Resource,Start Date,End Date,Duration,Percent Complete,Dependencies
**code javascript..table : 
['string ', 'string','string',  new Date(year,day, month), new Date(year,day, month), null,  percent,  null],
	])
	 var options = {
			options...
		};
	 End_sw		;	 
	

Syntax 2 : LoadArray

  	
	 	
	FormGoogle :  DRAWGANTT 
	LoadArray : ArrayName   {field : "string Array Var"  } ,
  	 Begin_sw
 	 var options = {
			options...
		};
	 End_sw		;	 
	

Syntax 2 : Table Field

  	
	 	
	FormGoogle : DRAWGANTT 
	use table ( NameVar  or string , field :"string Table Name field" )
	 Begin_sw
	 var options = {
			options...
		};
	 End_sw		;	 
	

Example 1

  		   
 FormGoogle : DRAWGANTT 
 Begin_sw
([
 ['Research', 'Find sources','robert',
  new Date(2015, 0, 1), new Date(2015, 0, 5), null,  100,  null],
 ['Write', 'Write paper','john',
  null, new Date(2015, 0, 9), daysToMilliseconds(3), 25, 'Research,Outline'],
 ['Cite', 'Create bibliography','john',
  null, new Date(2015, 0, 7), daysToMilliseconds(1), 20, 'Research'],
 ['Complete', 'Hand in paper','cath',
   null, new Date(2015, 0, 10), daysToMilliseconds(1), 0, 'Cite,Write'],
 ['Outline', 'Outline paper','phil',
  null, new Date(2015, 0, 6), daysToMilliseconds(1), 100, 'Research']
 ]);

      var options = {
        height: 275
      };
        End_sw		; 
	  

FormGoogle : DRAWGANTT




    

MS4BI : GANTT (Google chart)

Source & Copy FormGoogle GANTT
Visualise ALL Examples : FormGoogle
Visualise ALL CHART examples

Remarks

IncludeChart.h : (optional)
MS4SCRIPT : only ADD-ON MS4BI
GO to see : GOOGLE CHARTS (web)



KEYWORD : FORMGOOGLE : DRAWTIMELINE

Definition

Based on the GOOGLE graphics library, displays Standard, Pie, Bar, Grid , GeoMap, Gantt, Timeline, Organization, WordTree charts .

Syntax 1

  	
	 	
	FormGoogle :  DRAWTIMELINE 
	height :"var px or % ",width : "var px or %"
	 Begin_sw
	([
** 4 columns : string1, string2, date start, date end
** code javascript..table : 
['string ', 'string', new Date(year,day, month), 
		         new Date(year,day, month) 
	])
	
	  var options = {
			timeline: { otions.. }
		};
	 End_sw		;	 
	

Syntax 2 : LOADARRAY : go to see : GANTT

Syntax 3 : TABLE FIELD : go to see : GANTT

Example

  		   
FormGoogle : DRAWTimeline  , height : "280px", width : "1200px" 
 Begin_sw
([ ** 4 columns : string1, string2, date start, date end
[ 'Magnolia Room', 'Beginning JavaScript',       new Date(0,0,0,12,0,0),  new Date(0,0,0,13,30,0) ],
[ 'Magnolia Room', 'Intermediate JavaScript',     new Date(0,0,0,14,0,0),  new Date(0,0,0,15,30,0) ],
[ 'Magnolia Room', 'Advanced JavaScript',        new Date(0,0,0,16,0,0),  new Date(0,0,0,17,30,0) ],
[ 'Willow Room',   'Beginning Google Charts',     new Date(0,0,0,12,30,0), new Date(0,0,0,14,0,0)],
[ 'Willow Room',   'Intermediate Google Charts',   new Date(0,0,0,14,30,0), new Date(0,0,0,16,0,0)],
[ 'Willow Room',   'Advanced Google Charts',      new Date(0,0,0,16,30,0), new Date(0,0,0,18,0,0)] 
] );
	
		var options = {
			timeline: { colorByRowLabel: true }
		};
 
        End_sw		; 
	  

FormGoogle : DRAWGANTT




    

MS4BI : TIMELINE (Google chart) DAY : 2020 06 14

Source & Copy FormGoogle Timeline
Visualise ALL Examples : FormGoogle
Visualise ALL CHART examples

Remarks

IncludeChart.h : (optional)
MS4SCRIPT : only ADD-ON MS4BI
GO to see : GOOGLE CHARTS (web)



KEYWORD : FORMGOOGLE : DRAWORG

Definition

Based on the GOOGLE graphics library, displays Standard, Pie, Bar, Grid , GeoMap, Gantt, Timeline, Organization, WordTree charts .

Syntax 1

  	
**Organization	
 	
FormGoogle :  DRAWORG 
Begin_sw
	([
** 4 columns : Name , Manager ,ToolTip 
** code javascript..table : 
[{v:'string', f:'string", "string"],
	])
 	 
	

Syntax 2 : LOADARRAY : go to see : GANTT

Syntax 3 : TABLE FIELD : go to see : GANTT

Example

  		   
FormGoogle : DRAWORG 
** columns are :Name , Manager ,ToolTip 
Begin_sw
([
 [{v:'Mike', f:'Mike
President
'},'', 'The President'], [{v:'Jim', f:'Jim
Vice President
'},'Mike', 'VP'], ['Alice', 'Mike', ''], ['Bob', 'Jim', 'Bob Sponge'], ['Carol', 'Bob', ''] ]); End_sw ;
Visualise Example : FormGoogle ORG
Source & Copy FormGoogle ORG
Visualise ALL Examples : FormGoogle
Visualise ALL CHART examples

Remarks

IncludeChart.h : (optional)
MS4SCRIPT : only ADD-ON MS4BI
GO to see : GOOGLE CHARTS (web)



KEYWORD : FORMGOOGLE : DRAWWORDTREE

Definition

Based on the GOOGLE graphics library, displays Standard, Pie, Bar, Grid , GeoMap, Gantt, Timeline, Organization, WordTree charts .

Syntax 1

  	
**Organization	
 	
FormGoogle :  DRAWWORDTREE 
Begin_sw
	([
** code javascript..table : 
 
	])
 	var options = {
          wordtree: {
            format: 'implicit',
            word: 'string
          }
        }; 
	

Syntax 2 : LOADARRAY : go to see : GANTT

Syntax 3 : TABLE FIELD : go to see : GANTT

Example

  		   
FormGoogle : DRAWWORDTREE
 Begin_sw
[ ['Phrases'],
            ['cats are better than dogs'],
            ['cats eat kibble'],
            ['cats are better than hamsters'],
            ['cats are awesome'],
            ['cats are people too'],
            ['cats eat mice'],
            ['cats meowing'],
            ['cats in the cradle'],
            ['cats eat mice'],
            ['cats in the cradle lyrics'],
            ['cats eat kibble'],
            ['cats for adoption'],
            ['cats are family'],
            ['cats eat mice'],
            ['cats are better than kittens'],
            ['cats are evil'],
            ['cats are weird'],
            ['cats eat mice'],
          ]
        );

        var options = {
          wordtree: {
            format: 'implicit',
            word: 'cats'
          }
        };
End_sw		; 
	  
Visualise Example : FormGoogle WORDTREE
Source & Copy FormGoogle WORDTREE
Visualise ALL Examples : FormGoogle
Visualise ALL CHART examples

Remarks

IncludeChart.h : (optional)
MS4SCRIPT : only ADD-ON MS4BI
GO to see : GOOGLE CHARTS (web)

See also

FormPlus,FormPchart,FORMExcel,FORMMorris,FORMLeaflet,FORMChartJs

Interested in joining us? contact@mgplanete.com
The Mg Planete team


Copyright 2022 by Mandragore Planete

the official sites :
mgplanete.com
getms4bi.com
demos.ms4bi.com
help.ms4bi.com
ms4script.com

Download

official site :
getms4bi.com

Our purpose : Keep it simple !


written with ms4script
  • help 01.010.2022.8

MS4BI in 5 minutes