Ðóññêàÿ âåðñèÿ
Óêðà¿íñüêà âåðñ³ÿ

Library for preparation and data acquisition to reporting

Name:	TechApp
Founded:	January 2008
Version:	0.5.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)

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:

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:

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:

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);