Passing SQL data in codeigniter to highcharts with JSON -

-

i having trouble passing sql data controller view. have verified information shows model. don't know json i'm trying learn. goal populate chart 2 fields numbers highcharts javascript. please help, thank you!

controller

function dashboard() {      // tickets in queue     $query = $this->mhedash_model->maint_pending_tickets();     $result3 = $query->result_array();      $this->table->set_heading('work number', 'vehicle number','submit date','submit time');     $data['table']['vehicle in queue']  = $this->table->generate_table($result3);       // active tickets     $query = $this->mhedash_model->select_active();     $result = $query->result_array();      $this->table->set_heading('service number','start date','mechanic','vehicle number','description','type');     $data['table']['vehicles actively being worked on']  = $this->table->generate_table($result);        // tickets waiting on parts     $query = $this->mhedash_model->select_pending_parts();     $result2 = $query->result_array();      $this->table->set_heading('service number','start date','mechanic','vehicle number','description','type');     $data['table']['waiting parts']  = $this->table->generate_table($result2);      //graph - availble highreaches     $query = $this->mhedash_model->graph_available_hr();     $result4 = $query->result_array();     $data['row']['']  = $this->table->generate_table($result4);       $query = $this->mhedash_model->graph_available_dt();     $result5 = $query->result_array();     $data['row']['']  = $this->table->generate_table($result5);        $series_data[] = array('name' => 'available', 'data' => (int)$result4);     $series_data[] = array('name' => 'not_available', 'data' => (int)$result5);     $this->view_data['series_data'] = json_encode($series_data, json_numeric_check);       // load view     $data['page_title'] = 'mhe dashboard';     $data['main_content'] = 'mhe/mhe_dashboard_view';     $data['array'] = $result;     $data['array2'] = $result2;     $data['array3'] = $result3;       print json_encode($series_data);     //echo json_encode($series_data, json_numeric_check);      return $this->load->view('includes/template',$data);  }

view has highcharts javascript

var chart; $(function () {     $('#container').highcharts({     chart: {         type: 'column'     },     xaxis: {         categories: ['one', 'two']     },     plotoptions: {         series: {             allowpointselect: true         }     },     series: [{         data: [<?php echo join($series_data, ',') ?>]     }] });   // button action $('#button').click(function () {     var chart = $('#container').highcharts(),         selectedpoints = chart.getselectedpoints();      if (chart.lbl) {         chart.lbl.destroy();     }     chart.lbl = chart.renderer.label('you selected ' + selectedpoints.length + ' points', 100, 60)         .attr({             padding: 10,             r: 5,             fill: highcharts.getoptions().colors[1],             zindex: 5         })         .css({             color: 'white'         })         .add(); }); });         </script>

also, prints when print son_encode $series_data

[{"name":"available","data":1},{"name":"not_available","data":1}]


Comments

Post a Comment

Popular posts from this blog

node.js - Mongoose: Cast to ObjectId failed for value on newly created object after setting the value -

-
this question has answer here: what's mongoose error cast objectid failed value xxx @ path “_id”? 7 answers even though has been asked many times because entity has no valid objectid field. i came across situation objectid set value can casted objectid still error. the schema: var serviceschema = parammongoose.schema({ servicename:{ type: parammongoose.schema.types.objectid , ref: 'servicenames',required:true } }); pseudo code: servicefromdb=new service({servicename:'some name'}); servicefromdb.servicename='000000000000000000000001'; servicefromdb.save(function(paramerror,paramdata){ if(paramerror){ console.log('but but...',servicefromdb,paramerror) } }); the output of code is: but but... { servicename: 000000000000000000000001, _id: 55079a90286f49280364f78b } { [casterror: cast objectid faile...
Read more

gradle error "Cannot convert the provided notation to a File or URI" -

-
i have defined 2 system properties in gradle.properties: systemprop.builddir=build systemprop.cfgdir=build\\cfg and have following task defined in build.gradle: task clean(group:'clean',description:'clean project') << { ant.sequential { delete(dir: system.properties.builddir) mkdir(dir: system.properties.builddir) delete(dir: system.properties.cfgdir) mkdir(dir: system.properties.cfgdir) } } this generates following error: execution failed task ':clean'. > cannot convert provided notation file or uri: {dir=build}. following types/formats supported: - string or charsequence path, e.g 'src/main/java' or '/usr/include' - string or charsequence uri, e.g 'file:/usr/include' - file instance. - uri or url instance. but equivalent block of code not generate error , works expected: task clean(group:'clean',description:'clean project') << { ...
Read more

python - NameError: name 'subprocess' is not defined -

-
i'm trying make rng website: http://jamesdotcom.com/?p=417 . when run following code: captureimage = subprocess.popen( [ "fswebcam", "-r", "356x292", "-d", "/dev/video0", "static.jpg", "--skip", "10" ], stdout=devnull, stderr=devnull) captureimage.communicate() i following error message: nameerror: name 'subprocess' not defined what should do? thanks have imported first? import subprocess captureimage = subprocess.popen(["fswebcam", ...) subprocess included in python standard library since python 2.4. should not necessary install it.
Read more