EPSIAE » eneraptor

import groovy.sql.*

import java.sql.*

	def dataSource

		def db_sql = new Sql(dataSource)

		def single = db_sql.firstRow("show data_directory")

		def loca = single.data_directory

		def partition = new File(loca)

		def totalSpace = partition.getTotalSpace()

		def freeSpace  = partition.getFreeSpace()

		totalSpace = (int)((totalSpace/1024)/1024)

		freeSpace = (int)((freeSpace/1024)/1024)

		def percent = 100 - ((int) ((freeSpace/totalSpace)*100))

		[totalSpace: totalSpace, freeSpace: freeSpace, percent: percent]

	def graph = {

		List devices = new ArrayList()

		List data = new ArrayList()

		DeviceInfo.findAllByInputDevice(true).each {

			devices << it

		}

		if(params['dataList'])

			data = params['dataList']

		else if(params['deviceId'] && params['fromDate'] && params['tillDate']) {

			def c = LoggedData.createCriteria()

			def results = c {

				and {

					eq("deviceId",params['deviceId'])

					between("dateRecieved",params['fromDate'],params['tillDate'])

				}

				order("dateRecieved","asc")

			}

			results.each {

				data << [it.dateRecieved.getTime(),it.reportedData]

			}

		}

		[data: data, devices: devices, params:params]

	}