- self.gnuplot_sql = '/gnuplot?sql=select timestamp,snrtx,attntx,pwrtx,pwrrx,attnrx,snrrx from adsl where username = \'' + response[0].cn + '\'';
+ self._cpe_parser = response[0]._cpe_parser;
+ self.username = response[0].cn;
+ self.cpe = {
+ parser: self._cpe_parser,
+ table: 'cpe_' + self._cpe_parser,
+ };
+
+ $xhr('JSON', '/table/' + self.cpe.table + '?username='+self.username+';callback=JSON_CALLBACK', function( code, table ) {
+ self.cpe.rows = table.rows;
+ self.message = 'loaded cpe_'+self.cpe.parser+' rows';
+ });
+ self.message = 'loading cpe_'+self.cpe.parser+' rows...';
+
+ if ( h_cols = self.cpe_hash[self.cpe.parser] ) {
+ var cols = [ 'timestamp' ];
+ for ( var i = 0; i < h_cols.length; i++ ) {
+ cols.push( 'h->\'' + h_cols[i] + '\' as "' + h_cols[i] + '"' );
+ }
+console.debug( cols );
+ self.gnuplot.sql = 'select ' + cols.join(',') + ' from cpe_' + self.cpe.parser + ' where username = \'' + self.username + '\' order by timestamp desc limit 100';
+
+ console.info( 'gnuplot', self.gnuplot );
+ self.message = 'generating ADSL graph for '+self.username;
+ self.gnuplot.img = '/gnuplot?hide=1;with=points;sql=' + self.gnuplot.sql;
+ } else {
+ self.message = 'no graph defined for ' + self.cpe.parser;
+ }
+