1
Hello, I’m trying to plot a treemap with data from a BD (mysql), however, nothing appears. I have tried several alternatives and unsuccessfully. I have been able to plot several graphs, except treemap, I believe the problem is in the creation of php data table.
Follow part of php to fetch the data:
	$table = array();
			//colunas 
			$table['cols'] = array(
				array('label'=>'Rota','type'=>'string'),
				array('label'=>'Rota2','type'=>'string'),
                 array('label'=>'Entregas','type'=>'number'),
					array('label'=>'Entregas_cor','type'=>'number')
				);
			//rows
				$rows = array();
				
					$query = $pdo->prepare("SELECT COUNT(sk_carga) as qtd_entregas, carga_rota as rota FROM dim_lg_carga where id_empresa = :sk_empresa GROUP BY 2");
					$query->bindParam(':sk_empresa',$sk_empresa, PDO::PARAM_INT);
					$query->execute();
							while ($linha=$query->fetch(PDO::FETCH_ASSOC)){
						
								$rota =$linha['rota'];
								
								$rota2 =null;
								
							$qtd_entregas = intval($linha['qtd_entregas']);
								
								
						$qtd_entregas_cor = intval($linha['qtd_entregas']);
								$temp = array();
								$temp[] = array('v'=>$rota);
								$temp[] = array('v'=>$rota2);
								
								$temp[] = array('v'=>$qtd_entregas);
								$temp[] = array('v'=>$qtd_entregas_cor);
								$rows[] = array('c'=>$temp);
					}
						
						$table['rows'] = $rows;
							$jsonTable = json_encode($table);
							
							
							echo $jsonTable;
							called JS:
            	google.setOnLoadCallback(desenharGraficoEntregasRotas);
			
						function desenharGraficoEntregasRotas(){
							// ajax
							
							var jsonDados10 = $.ajax({
							//url:"Model/Empresa/get_entregas_motorista.php",
							url:'http://localhost/sistema-bi-web/Model/Empresa/get_rotas_entregas.php',
								dataType: "json",
								async: false
							}).responseText;
						var options10 = {
									     minColor: '#f00',
								          midColor: '#ddd',
								          maxColor: '#0d0',
								          headerHeight: 15,
								          fontColor: 'black',
								          showScale: true
						};
					
							//dados do grafico
							var dados10 = new google.visualization.DataTable(jsonDados10);
						
						var grafico10= new google.visualization.TreeMap(document.getElementById('grafico_entregas_rota'));
							// desenha o grafico de acordo com os parametros passados
							grafico10.draw(dados10, options10); 
		}HTML part:
	<div class="panel-body">
						<div class="canvas-wrapper">
						<div id="grafico_entregas_rota"></div>
						</div>
					</div>Exemplification Database:
sk_load column route
1.......... Pituba
2.......... Pituba
3.......... Pituba
4.......... Pituba
5.......... Sprouts
6.......... Pituba
7.......... You sprout...
8.......... Green line