OXIESEC PANEL
- Current Dir:
/
/
home
/
cubot
/
bin
Server IP: 139.59.38.164
Upload:
Create Dir:
Name
Size
Modified
Perms
📁
..
-
02/03/2023 08:25:32 AM
rwxr-xr-x
📄
auditreport.sh
1.15 KB
02/03/2023 07:34:14 AM
rwxr-xr-x
📄
clripcs
44.5 KB
02/03/2023 07:34:09 AM
rwxr-xr-x
📄
comparedb.sh
487 bytes
02/03/2023 07:34:14 AM
rwxr-xr-x
📄
convertToexcel.pl
3.69 KB
02/03/2023 07:34:15 AM
rwxr-xr-x
📄
convertToexcel_my.rd.pl
3.06 KB
02/03/2023 07:34:15 AM
rwxr-xr-x
📄
crlf.sh
67 bytes
02/03/2023 07:34:15 AM
rwxr-xr-x
📄
cron.sh
173 bytes
02/03/2023 07:34:13 AM
rwxr-xr-x
📄
cubadmserv
1.94 MB
02/03/2023 07:34:14 AM
rwxr-xr-x
📄
cubalert
1.3 MB
02/03/2023 07:34:09 AM
rwxr-xr-x
📄
cubetlserv
1.97 MB
02/03/2023 07:34:09 AM
rwxr-xr-x
📄
cubgphserv
2.55 MB
02/03/2023 07:34:12 AM
rwxr-xr-x
📄
cubmenuserv
2.51 MB
02/03/2023 07:34:14 AM
rwxr-xr-x
📄
cubnotify
2.79 MB
02/03/2023 07:34:09 AM
rwxr-xr-x
📄
cubot.properties
1.93 KB
02/03/2023 07:34:08 AM
rw-r--r--
📄
cubregenxy
947.66 KB
02/03/2023 07:34:08 AM
rwxr-xr-x
📄
cubregenxy.gz
341.15 KB
02/03/2023 07:34:13 AM
rwxr-xr-x
📄
cubrouter
378.71 KB
02/03/2023 07:34:14 AM
rwxr-xr-x
📄
cubrxgate
440.74 KB
02/03/2023 07:34:15 AM
rwxr-xr-x
📄
cubrxlogin
529.18 KB
02/03/2023 07:34:13 AM
rwxr-xr-x
📄
cubsearch
1.58 MB
02/03/2023 07:34:09 AM
rwxr-xr-x
📄
cubsearchrouter
520.15 KB
02/03/2023 07:34:14 AM
rwxr-xr-x
📄
doZip.sh
669 bytes
02/03/2023 07:34:14 AM
rwxr-xr-x
📄
esalesforce
57 bytes
02/03/2023 07:34:09 AM
rwxr-xr-x
📁
etl
-
02/03/2023 07:34:08 AM
rwxr-xr-x
📁
etl_odbc
-
02/03/2023 07:34:13 AM
rwxr-xr-x
📄
finyr.so
25.82 KB
02/03/2023 07:34:11 AM
rwxr-xr-x
📄
finyr.so_16May
26.11 KB
02/03/2023 07:34:08 AM
rwxr-xr-x
📄
fmtxml2ooffice.sh
1013 bytes
02/03/2023 07:34:14 AM
rwxr-xr-x
📄
forecast.R
3.13 KB
02/03/2023 07:34:14 AM
rw-r--r--
📄
gep_days.so
10.03 KB
02/03/2023 07:34:15 AM
rwxr-xr-x
📄
html2csv.sh
2.97 KB
02/03/2023 07:34:14 AM
rwxr-xr-x
📄
html2ps
129.14 KB
02/03/2023 07:34:13 AM
rwxr-xr-x
📄
httpd
565.41 KB
02/03/2023 07:34:15 AM
rwxr-xr-x
📄
httpd_2.2
2.9 MB
02/03/2023 07:34:15 AM
rwxr-xr-x
📁
jars
-
02/03/2023 07:34:14 AM
rwxr-xr-x
📄
jgraphserver.sh
841 bytes
02/03/2023 07:34:13 AM
rwxr-xr-x
📄
libAdaptikTokenServiceProvider.so
631.87 KB
02/03/2023 07:34:14 AM
rwxr-xr-x
📄
libTokenServiceProvider.so
146.98 KB
02/03/2023 07:34:14 AM
rwxr-xr-x
📄
libcrypto.so.0.9.8
38.29 KB
05/03/2022 10:19:39 AM
rw-r--r--
📄
libcubotsvc.so
112.92 KB
02/03/2023 07:34:08 AM
rwxr-xr-x
📄
libdbdriver.so
113.32 KB
02/03/2023 07:34:14 AM
rwxr-xr-x
📄
libldap-2.3.so.0
319.36 KB
05/12/2022 01:52:38 PM
rw-r--r--
📄
libmysqlclient.so
1.52 MB
02/03/2023 07:34:14 AM
rwxr-xr-x
📄
libmysqlclient.so.15
3.78 MB
04/23/2023 02:08:47 PM
rw-r--r--
📄
libmysqlclient.so.16
3.78 MB
04/23/2023 02:08:47 PM
rw-r--r--
📄
libodbc.so.1
421.49 KB
03/26/2018 02:37:19 PM
rw-r--r--
📄
libpcre.so.1
449.93 KB
05/17/2022 07:42:45 AM
rw-r--r--
📄
librxauth.so
98.6 KB
02/03/2023 07:34:14 AM
rwxr-xr-x
📄
librxetl.so
29.8 KB
02/03/2023 07:34:14 AM
rwxr-xr-x
📄
librxfusionchart.so
60.25 KB
02/03/2023 07:34:08 AM
rwxr-xr-x
📄
librxgphserv.so
125.78 KB
02/03/2023 07:34:14 AM
rwxr-xr-x
📄
librxmetadata.so
227.2 KB
02/03/2023 07:34:08 AM
rwxr-xr-x
📄
librxmysql.so
80.75 KB
02/03/2023 07:34:10 AM
rwxr-xr-x
📄
librxolap.so
823.31 KB
02/03/2023 07:34:09 AM
rwxr-xr-x
📄
libssl.so.0.9.8
563.78 KB
05/24/2023 05:14:51 PM
rw-r--r--
📄
libtdsodbc.so
929.6 KB
02/03/2023 07:34:08 AM
rwxr-xr-x
📄
makeXtab2NormalExcel.pl
5.33 KB
02/03/2023 07:34:14 AM
rw-r--r--
📄
mod_axis2.so
226.12 KB
02/03/2023 08:01:00 AM
rwxr-xr-x
📄
mod_jk.so
384.77 KB
02/03/2023 07:34:14 AM
rw-r--r--
📄
mod_rx.so
50.69 KB
02/03/2023 08:01:00 AM
rw-r--r--
📄
multiSheet.pl
5.74 KB
02/03/2023 07:34:12 AM
rwxr-xr-x
📄
preCheck.js
1.03 KB
02/03/2023 07:34:13 AM
rw-r--r--
📄
priority_regen.sh
4.41 KB
02/03/2023 07:34:14 AM
rw-r--r--
📄
procscript.sh
321 bytes
02/03/2023 07:34:14 AM
rwxr-xr-x
📄
rxdummydb.so
108.43 KB
02/03/2023 07:34:14 AM
rwxr-xr-x
📄
rxmssql.so
112.95 KB
02/03/2023 07:34:14 AM
rwxr-xr-x
📄
rxmysql.so
108.4 KB
02/03/2023 07:34:08 AM
rwxr-xr-x
📄
rxodbc.so
113.24 KB
02/03/2023 07:34:14 AM
rwxr-xr-x
📄
rxolite.so
108.45 KB
02/03/2023 07:34:12 AM
rwxr-xr-x
📄
rxora.so
113.03 KB
02/03/2023 07:34:08 AM
rwxr-xr-x
📄
rxsalesforce.so
108 KB
02/03/2023 07:34:14 AM
rwxr-xr-x
📄
rxsybase.so
123.61 KB
02/03/2023 07:34:09 AM
rwxr-xr-x
📄
services.xml
6.64 KB
02/03/2023 07:34:08 AM
rw-r--r--
📄
setvars.sh
556 bytes
02/03/2023 07:34:15 AM
rwxr-xr-x
📁
utils
-
02/03/2023 07:34:08 AM
rwxr-xr-x
📄
ws.core.js
40.18 KB
02/03/2023 07:34:08 AM
rw-r--r--
📄
wsAll.js
142.94 KB
02/03/2023 07:34:09 AM
rw-r--r--
Editing: forecast.R
Close
library(RMySQL) #library(RODBC) library(reshape) library(forecast) library(TTR) # Reading Env variables dbuser <- Sys.getenv("CUBOT_DBUSER"); dbpass <- Sys.getenv("CUBOT_DBPASS"); dbhost <- Sys.getenv("CUBOT_DBHOST"); edashdDir <- Sys.getenv("ED_DIR"); DocRoot <- Sys.getenv("DocRoot"); gphoutdir <- paste(DocRoot, edashdDir, "/be/gphout/"); gphoutdir <- gsub(" ", "", gphoutdir); if(nchar(dbuser) == 0) dbuser <- "cubot" if(nchar(dbhost) == 0) dbhost <- "localhost" # Reading arguments args <- commandArgs(TRUE) dbname<-args[1] reportid <-args[2] series_num <- args[3] gph_filename <- args[4] # Reading Series metadata con <-dbConnect(MySQL(), dbname, dbuser, dbpass, dbhost, client.flag = CLIENT_MULTI_STATEMENTS) res <- dbGetQuery(con, paste("select gs_series_id, gs_title from graph_series where gs_id=", reportid, "and gs_series_num=", series_num)) function_name <- paste(gsub("(^ +)|( +$)", "", res$gs_title[1]), "_forecast") function_name <- gsub(" ", "", function_name) dbSendQuery(con, paste("delete from graph_series where gs_id=", reportid, "and gs_title like '%", function_name,"%'")) seriesnum_n <- dbGetQuery(con, paste("select max(gs_series_num)+1 from graph_series where gs_id=", reportid )) # Reading Report Data data <- dbGetQuery(con, paste("select xy_yval from data_xy where xy_series_id=", res$gs_series_id[1], "order by cast(xy_xval as decimal), cast(xy_xval2 as decimal) asc")) startpt <- dbGetQuery(con, paste("select min(cast(xy_xval as decimal)) from data_xy where xy_series_id=", res$gs_series_id[1])) startpt2 <- dbGetQuery(con, paste("select min(cast(xy_xval2 as decimal)) from data_xy where xy_series_id=", res$gs_series_id[1], " and xy_xval=", startpt)) startpt <- as.integer(startpt) startpt2 <- as.integer(startpt2) startpt startpt2 if(is.na(startpt2)){ data1 <- ts(data, start=c(startpt)) }else{ data1 <- ts(data, frequency=12, start=c(startpt, startpt2)) } data1 # Forecasting starts from here data_arima <- auto.arima(data1) if(is.na(startpt2)){ fc_data <- forecast(data_arima) }else{ fc_data <- forecast(data_arima, h=12) } newdata <- as.data.frame(fc_data) fc_data gphoutdir gph_filename setwd(gphoutdir) png(gph_filename, width=900, height=500) plot(fc_data) grid() dev.off() # write data back to table data2 <- dbGetQuery(con,paste("select ss_seq|0x400000 as series_id from series_seq")) mydata <- cbind(newdata,data2) dbWriteTable(con,"tmp_R",mydata,overwrite=T) dbGetQuery(con,paste("alter table tmp_R add column xy_xval2 char(10)")) dbGetQuery(con,paste("update tmp_R set xy_xval2=SUBSTRING_INDEX(row_names, ' ', 1)")) dbGetQuery(con,paste("update tmp_R set xy_xval2=month(str_to_date(xy_xval2,'%b'))")) dbGetQuery(con,paste("update tmp_R set row_names=SUBSTRING_INDEX(row_names, ' ', -1)")) qry <- paste("replace into graph_series(gs_id, gs_series_id, gs_series_num, gs_title ) values(", reportid, ",", data2, ",", seriesnum_n, ", '", function_name, "')"); qry data <- dbSendQuery(con, qry ); data4 <- dbGetQuery(con, paste("update series_seq set ss_seq=ss_seq+1")) dbGetQuery(con, paste("insert into data_xy (xy_series_id,xy_xval,xy_xval2,xy_yval) select series_id,row_names,xy_xval2,Point_Forecast from tmp_R"))