- self.gnuplot.sql = 'select timestamp,h->\'Max_down\' as Max_down,h->\'Max_up\' as Max_up from cpe_Davolink where username = \'' + response[0].cn + '\' order by timestamp desc limit 100';
- self.gnuplot.img = '/gnuplot?hide=1;with=points;sql=' + self.gnuplot.sql;
- console.info( 'gnuplot', self.gnuplot );
- self.message = 'generating ADSL graph for '+response[0].cn + ' ';
+ var parser = response[0]._cpe_parser;
+ console.info( 'parser', parser );
+ if ( h_cols = self.cpe_hash[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_' + parser + ' where username = \'' + response[0].cn + '\' order by timestamp desc limit 100';
+
+ self.gnuplot.img = '/gnuplot?hide=1;with=points;sql=' + self.gnuplot.sql;
+ console.info( 'gnuplot', self.gnuplot );
+ self.message = 'generating ADSL graph for '+response[0].cn + ' ';
+ } else {
+ self.message = 'no graph defined for ' + parser;
+ }