This page is frozen,

Library for preparation and data acquisition to reporting

Name:	TechApp
Founded:	January 2008
Version:	1.0.0
State:	Free (GPL)
Author:	Roman Savochenko
Description:	Library of functions to facilitate the implementation of typical computations the primitive form of reporting documentation VCA "Document".
Address:	DB in file: SQLite.LibDB.doc (oscadalibs.db.gz)

Contents

About the library

1 The library structure

Average value of archive (averVal)

Getting value from archive (getVal)

Sum values of archive (sumVal)

About the library

Library is created to provide common operations retrieve data for report documents using data from data sources (DAQ) and their archives. The library is not static, but based on the module JavaLikeCalc, allowing to create calculations on the Java-like language.

To address the functions of the library you can use static call address "DAQ.JavaLikeCalc.lib_doc.{Func}()" or dynamic "SYS.DAQ.JavaLikeCalc["lib_doc"]["{Func}"].call()", "SYS.DAQ.JavaLikeCalc["lib_doc"].{Func}()". Where {Func} — function identifier in the library.

To connect the library to the project of the OpenSCADA station it is possible by downloading the attached file of the database, placing it in in the database directory of the station's project and creating the database object for the DB module "SQLite", indicating the database file in the configuration.

1 The library structure

The library contains several functions often needed for report documents preparation based on data of data sources of OpenSCADA. The functions' names and its parameters are available in three languages: English, Russian and Ukrainian.

Average value of archive (averVal)

Description: Calculate the average value over a specified period of time an archive and issuing results with the specified number of decimal points.
Parameters:

ID	Parameter	Type	Mode	Hide	Default
rez	Result	String	Return	false
addr	Address	String	Input	false
bTime	Begin time (s)	Integer	Input	false
eTime	End time (s)	Integer	Input	false
prec	Signs after dot	Integer	Input	false	3
archtor	Archivator	String	Input	false

Program:

using Special.FLibSYS;
a_src = vArh(strPath2Sep(addr));

vl=EVAL_REAL;
buf_beg=max(a_src.begin(0,archtor),bTime);
buf_end=min(a_src.end(0,archtor),eTime);
while( true )
{
  buf_beg1=buf_beg;
  r_val = a_src.get(buf_beg,0,true,archtor);
  if(vl ==  EVAL_REAL) vl = r_val; 
  else if(r_val != EVAL_REAL)
    vl=(vl*(buf_beg-bTime)+r_val*(buf_beg-buf_beg1))/(buf_beg-bTime+buf_beg-buf_beg1);
  if( buf_beg == 0 || buf_beg>=buf_end ) break;
  buf_beg++;
}

return (vl==EVAL_REAL) ? "Empty" : real2str(vl,prec);

Getting value from archive (getVal)

Description: Query the value for a specified time from the assigned archive and issuing the result with the specified number of decimal points.
Parameters:

ID	Parameter	Type	Mode	Hide	Default
rez Result	String	Return	false
addr	Address	String	Input	false
time	Time (s) Integer	Input	false
uTime	Time (us)	Integer	Input	false
prec	Signs after dot	Integer	Input	false	3
archtor	Archivator	String	Input	false
strong	Strong	Boolean	Input	false	0

Program:

using Special.FLibSYS;
srcTime = time;
val = vArh(strPath2Sep(addr)).get(time,uTime,0,archtor);
return (val.isEVal() || (strong && srcTime != time)) ? "Empty" : real2str(val,prec);

Sum values of archive (sumVal)

Description: Calculating the sum of values for a specified period of time an archive and issuing results with the specified number of decimal points.
Parameters:

ID	Parameter	Type	Mode	Hide	Default
rez	Result	String	Return	false
addr	Address	String	Input	false
bTime	Begin time (s)	Integer	Input	false
eTime	End time (s)	Integer	Input	false
prec	Signs after dot	Integer	Input	false	3
archtor	Archivator	String	Input	false

Program:

using Special.FLibSYS;

a_src = vArh(strPath2Sep(addr));

vl=0.0; buf_beg_u=buf_end_u=0;
buf_beg=max(a_src.begin(0,archtor),bTime);
buf_end=min(a_src.end(0,archtor),eTime);
while( true )
{
  r_val = a_src.get(buf_beg,buf_beg_u,true,archtor);
  if(r_val != EVAL_REAL) vl+=r_val;
  if( !buf_beg || buf_beg>=buf_end ) break;
  buf_beg_u++;
}

return (vl==EVAL_REAL) ? "Empty" : real2str(vl,prec);