English
Óêðà¿íñüêà

Áèáëèîòåêà ïîäãîòîâêè è ïîëó÷åíèÿ äàííûõ äëÿ îò÷¸òíîé äîêóìåíòàöèè

Èìÿ:	TechApp
Îñíîâàí:	ÿíâàðü 2008ã
Âåðñèÿ:	1.0.0
Ñòàòóñ:	Îòêðûòûé (GPL)
Àâòîð:	Ðîìàí Ñàâî÷åíêî
Îïèñàíèå:	Áèáëèîòåêà ôóíêöèé äëÿ îáëåã÷åíèÿ âûïîëíåíèÿ òèïîâûõ âû÷èñëåíèé ïðèìèòèâà ôîðìèðîâàíèÿ îò÷¸òíîé äîêóìåíòàöèè ÑÂÓ "Äîêóìåíò".
Àäðåñ:	ÁÄ â ôàéëå: SQLite.LibDB.doc (oscadalibs.db.gz)

Ïðî áèáëèîòåêó

Áèáëèîòåêà ñîçäà¸òñÿ äëÿ ïðåäîñòàâëåíèÿ òèïîâûõ îïåðàöèé ïîëó÷åíèÿ äàííûõ ïðè ïîñòðîåíèè îò÷¸òíûõ äîêóìåíòîâ ñ èñïîëüçîâàíèåì äàííûõ èñòî÷íèêîâ äàííûõ (DAQ) è èõ àðõèâîâ. Áèáëèîòåêà íå ÿâëÿåòñÿ ñòàòè÷åñêîé, à ñòðîèòñÿ íà îñíîâå ìîäóëÿ JavaLikeCalc, ïîçâîëÿþùåãî ñîçäàâàòü âû÷èñëåíèÿ íà Java-ïîäîáíîì ÿçûêå.

Äëÿ àäðåñàöèè ê ôóíêöèÿì ýòîé áèáëèîòåêè ìîæíî èñïîëüçîâàòü ñòàòè÷åñêèé àäðåñ âûçîâà "DAQ.JavaLikeCalc.lib_doc.{Func}()" èëè äèíàìè÷åñêèé "SYS.DAQ.JavaLikeCalc["lib_doc"]["{Func}"].call()", "SYS.DAQ.JavaLikeCalc["lib_doc"].{Func}()". Ãäå {Func} — èäåíòèôèêàòîð ôóíêöèè â áèáëèîòåêå.

Ïîäêëþ÷èòü áèáëèîòåêó ê ïðîåêòó ñòàíöèè OpenSCADA ìîæíî ïóò¸ì çàãðóçêè âëîæåííîãî ôàéëà ÁÄ, ðàçìåùåíèÿ åãî â äèðåêòîðèè ÁÄ ïðîåêòà ñòàíöèè è ñîçäàíèÿ îáúåêòà ÁÄ äëÿ ìîäóëÿ ÁÄ "SQLite", óêàçàâ ôàéë ÁÄ â êîíôèãóðàöèè.

1 Ñîñòàâ áèáëèîòåêè

 ñâî¸ì ñîñòàâå áèáëèîòåêà ñîäåðæèò íåñêîëüêî ôóíêöèé ÷àñòî âîñòðåáîâàííûõ ïðè ôîðìèðîâàíèè äîêóìåíòîâ íà îñíîâå äàííûõ èñòî÷íèêîâ äàííûõ OpenSCADA. Íàçâàíèÿ ôóíêöèé è èõ ïàðàìåòðîâ äîñòóïíû íà òð¸õ ÿçûêàõ: Àíãëèéñêèé, Ðóññêèé è Óêðàèíñêèé.

Ñðåäíåå çíà÷. àðõèâà (averVal)

Îïèñàíèå: Âû÷èñëåíèå ñðåäíåãî çíà÷åíèÿ çà ïðîìåæóòîê âðåìåíè óêàçàííîãî àðõèâà è âûäà÷à ðåçóëüòàòà ñ óêàçàííûì êîëè÷åñòâîì çíàêîâ ïîñëå òî÷êè.
Ïàðàìåòðû:

Ïðîãðàììà:
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) ? "Ïóñòî" : real2str(vl,prec);

Çàïðîñ çíà÷. àðõèâà (getVal)

Îïèñàíèå: Çàïðîñ çíà÷åíèÿ íà óêàçàííîå âðåìÿ èç óñòàíîâëåííîãî àðõèâà è âûäà÷à ðåçóëüòàòà ñ óêàçàííûì êîëè÷åñòâîì çíàêîâ ïîñëå òî÷êè.
Ïàðàìåòðû:

Ïðîãðàììà:
using Special.FLibSYS; srcTime = time; val = vArh(strPath2Sep(addr)).get(time,uTime,0,archtor); return (val.isEVal() || (strong && srcTime != time)) ? "Ïóñòî" : real2str(val,prec);

Ñóììà çíà÷. àðõèâà (sumVal)

Îïèñàíèå: Âû÷èñëåíèå ñóììû çíà÷åíèé çà ïðîìåæóòîê âðåìåíè óêàçàííîãî àðõèâà è âûäà÷à ðåçóëüòàòà ñ óêàçàííûì êîëè÷åñòâîì çíàêîâ ïîñëå òî÷êè.
Ïàðàìåòðû:

Ïðîãðàììà:
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) ? "Ïóñòî" : real2str(vl,prec);