MS4BI HELP 2019

by MS4script
01-Introduction
Preface & Copyright
Getting started
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
Connect DB Create, delete
Import DataSource Import, Consolidation
Administration Admin, User
05- Sql-Query
Sql
Query Form : BTS,SHOW
Grid option
06- Charts
Forms Show, 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.
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 Special
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
14- Cloud.
Account Open
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 2019 version 1

Chapter 6 : CHARTS

KEYWORD : FORMGOOLE : DRAWGEOMAP

Definition

Based on the GOOGLE graphics library, displays Standard GEOMAP charts .

Syntax 1

 	
	 	FormGoogle : DRAWGEOMAP 
		 Begin_sw
			([
			code javascript..table : [{f:'string ', v:'CODE ISO '},latitude],
			])
		 End_sw		;
	

Example 1

 		   
 #includeSYSpathMS4BI "\zInclude\includeChart.h"  
 
	 BEGIN
	position  : relative, 450,650 :  
 	FormGoogle : DRAWGEOMAP 
	 Begin_sw
	([
		['Province','Disposable Income by Household'],
		[{f:'Anhui ', v:'CN-34 '},15154],
		[{f:'Beijing ', v:'CN-11 '},40830],
		[{f:'Chongqing ', v:'CN-50 '},16569],
		[{f:'Zhejiang ', v:'CN-33 '},29775],   
	]),
		{
			colorAxis: {colors: ['yellow', 'red']},
			displayMode: 'regions',
			region: 'CN',
			resolution: 'provinces'
		}
   End_sw	  

	  

Syntax 2 : LoadArray

 	
	 	FormGoogle : DRAWGEOMAP 
		loadArrays :  ArraysName   { field :"NameVar"  } ,
		 Begin_sw
		([
			code javascript.. 
         ])
		 End_sw		;
	

Example 2 LOADARRAY

 		   
 #includeSYSpathMS4BI "\zInclude\includeChart.h"  
 Arrays:    GeoMapRef  Occurs 40 { char StringEx1:20;CHAR stringVal :128; integer IntValEx1;} 
 

	FormGoogle : DRAWGEOMAP 
    loadArrays : GeoMapRef   { field :"stringVal"  } ,
	 Begin_sw
	{
        colorAxis: {colors: ['yellow', 'red']},
        displayMode: 'regions',
        region: 'CN',
        resolution: 'provinces'
	}
    End_sw	  

	  

Prerequisites

- include header file : driver:\MondaySoftware\MS4BI\zInclude\IncludeChart.h (optional)
- ConnectDB{Ms4DB} (DB Name )(optional)

Remarks

IncludeChart.h :

By adding a label to each value, we can still use ISO codes and avoid the troubles of Geocharts not understanding some of the English names of Chinese provinces.
MS4SCRIPT : only ADD-ON MS4BI
GO to see : GOOGLE CHARTS (web)

See also

FORMSHOW,FORMIMAGE,FORMEXCEL,FORMMORRI,FORMLEAFLET,



Chapter 6 : CHARTS

KEYWORD : FORMLEAFLET : DRAWGEOMAP

Definition

Based on the LEAFLET graphics library, displays Standard GEOMAP charts .

Syntax 1

 	
	  
		FormLeaflet : DRAWGEOMAP ID: "string", 
		SetView(latitude,  longitude), Zoom :  integer ,
		height :"var px or % ",width : "var px or %"
 		 Begin_sw
		  code javascript..table : var marker = L.marker([latitude,  longitude]).addTo(mymap).bindPopup("string");
		 End_sw		;
	

Example 1

 		   
  
	FormLeaflet : DRAWGEOMAP ID: "mymap", 
	SetView(51.5112,  101.254), Zoom :  12 ,
	height :"300px",width : "80%"
    Begin_sw
			var marker = L.marker([51.5112,  x]).addTo(map).bindPopup("Hello London");
 	End_sw	; 

	  

Syntax 2 : LoadArray

 	
	    FormLeaflet : DRAWGEOMAP ID: "string", 
		SetView(latitude,  longitude), Zoom :  integer ,
		height :"var px or % ",width : "var px or %"
		loadArrays :  ArraysName   { field :"Arrays NameVar"  } ,
		 Begin_sw
		([
			code javascript.. 
         ])
		 End_sw		;
	

Syntax 3 : TABLE FIELD : go to see : LEAFLET GEOMAP

Example 2 LOADARRAY

 		   
  Arrays:    GeoMapRef  Occurs 40 { char StringEx1:20;CHAR stringVal :128; integer IntValEx1;} 
 

	FormLeaflet : DRAWGEOMAP 
	 ID: "mymap", 
	SetView(51.5112,  101.254), Zoom :  12 ,
	height :"300px",width : "80%"
    loadArrays : GeoMapRef   { field :"stringVal"  } ,
	 Begin_sw
	 
		var influence = L.circle([39.913818,116.363625], 160000).addTo(mymap);
		var circle = L.circle([33.391376,117.557678], {
						color: 'red',
						fillColor: '#f03',
						fillOpacity: 0.5,
						radius: 150000
						}).addTo(mymap);
					circle.bindPopup("I am a circleXXXXXXXXXXXXXXXXXXX.");
		var polygon = L.polygon([
					[27.518280, 120.425766],
					[32.540447,119.243889],
					[27.934572,116.312164]
					]).addTo(mymap);

					polygon.bindPopup("I am a polygon.");

					marker.bindPopup("Hello world!
I am a popup.").openPopup(); var popup = L.popup() .setLatLng([35.8617,104.1954]) .setContent("CHINA.") .openOn(mymap); End_sw

Syntax 3 : TABLE FIELD

 	
	    FormLeaflet : DRAWGEOMAP ID: "string", 
		SetView(latitude,  longitude), Zoom :  integer ,
		height :"var px or % ",width : "var px or %"
		use table ( NameVar  or string , field :"string Table Name field" )
 		 Begin_sw
		([
			code javascript.. 
         ])
		 End_sw		;
	

Example3 : TABLE FIELD

 		   
     Ms4_SQL{ms4DB}("CREATE TABLE [TABEXAMPLE] "+ 
	"(      [INDEXID] TEXT,"+ 
	"       [LONGSTRING] char(1024),"+ 
	"       PRIMARY KEY (`INDEXID`) )");  
 
      Ms4_SQL{ms4DB}("INSERT INTO TABEXAMPLE VALUES('INDEX0','%s')",GeoMapRef[0].stringval);
      Ms4_SQL{ms4DB}("INSERT INTO TABEXAMPLE VALUES('INDEX1','%s')",GeoMapRef[1].stringval);
	  Ms4_SQL{ms4DB}("INSERT INTO TABEXAMPLE VALUES('INDEX2','%s')",GeoMapRef[2].stringval);


	FormLeaflet : DRAWGEOMAP 
	 ID: "mymap", 
		SetView(27.934572,116.312164), Zoom : 4.3 ,
	height :"450px",width : "650px"
	use table ("[TABEXAMPLE]", field :"longstring" ) 
	 Begin_sw
	    var popup = L.popup()
					.setLatLng([35.8617,104.1954])
					.setContent("CHINA.")
					.openOn(mymap);
    End_sw	  

	  

Prerequisites

- include header file : driver:\MondaySoftware\MS4BI\zInclude\IncludeChart.h (optional)
- ConnectDB{Ms4DB} (DB Name )(optional)

Remarks

IncludeChart.h :

MS4SCRIPT : only ADD-ON MS4BI
GO to see : LEAFLET CHARTS (web)

See also

FORMSHOW,FORMIMAGE,FORMEXCEL,FORMMORRIS,FORMLEAFLET

Interested in our project? contact@monday-software.com
The Monday Software team


Copyright 2020 by Monday Software

the official sites :
www.monday-software.com
www.ms4bi.com
demos.ms4bi.com
getms4bi.com
getms4bifree.com
cloud.ms4bi.com
cloud.testing.ms4bi.com
www.ms4script.com

Our purpose : Keep it simple !


written with ms4script
  • MS4BI v.01.0027.01.2020
  • MS4BIRE v.01.0021.10.2019
  • MS4SCRIPT v.01.0027.01.2020
  • help 06/2019

MS4BI in 5 minutes