mvnp/Código completo

## Código completo
<?php defined('BASEPATH') OR exit('No direct script access allowed');

class Welcome4 extends CI_Controller {

	/**
	 * Gera a tabela de valores sem os nomes das naturezas e
	 * foi inserido as colunas de PACOTE e NATUREZA no início
	 * e implementado a possível ordenação por orden alfabética
	 * de naturezas ou possível ordenação por ordem alfabética
	 * de pacotes ...
	 * @return [type] [description]
	 */
	public function index(){
		$this->load->view('welcome_message');
	}

	private function QueryValores(){

		$sql = "SELECT SUM(LANC_VALOR) AS VALOR, LANC_NAT_ID, natureza.NAT_DESCRICAO AS NAT_DESCRICAO, pacote.PCT_DESCRICAO AS PCT_DESCRICAO FROM meuslancamentos INNER JOIN natureza ON meuslancamentos.LANC_NAT_ID = natureza.NAT_ID INNER JOIN pacote ON pacote.PCT_ID = natureza.NAT_PCT_ID GROUP BY LANC_NAT_ID, LANC_DT_PAGTO ORDER BY PCT_ID ASC, LANC_DT_PAGTO ASC";
		$result = $this->db->query($sql)->result_array();

		/*echo "<pre>";
			print_r($result);
		echo "</pre>";*/

		return $result;
	}

	private function GetCats(){

		$sql = "SELECT NAT_ID FROM natureza";
		$result = $this->db->query($sql)->num_rows();

		return $result;
	}

	public function table(){

		$array 		= $this->QueryValores();
		$countRows 	= count($array);
		$countCats 	= $this->GetCats();

		echo "<!DOCTYPE html>
		<html lang=\"en\">
		<head>
			<meta charset=\"UTF-8\">
			<title>Document</title>
			<link rel=\"stylesheet\" href=\"https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/css/bootstrap.min.css\" />
		</head>
		<body class=\"container\" style=\"width:120%!important\">
			<h1>Tabela de Somatória de Lançamentos</h1>
			<table class=\"table table-bordered table-striped\">
				<thead>
					<tr>
						<td>PACOTE</td>
						<td>NATUREZA</td>
						<td>JAN</td>
						<td>FEV</td>
						<td>MAR</td>
						<td>ABR</td>
						<td>MAI</td>
						<td>JUN</td>
						<td>JUL</td>
						<td>AGO</td>
						<td>SET</td>
						<td>OUT</td>
						<td>NOV</td>
						<td>DEZ</td>
						<td>TOTAL</td>
						<td>MEDIA</td>
					</tr>
				</thead>
				<tbody>
					<tr>";
					$count = 0;
					foreach ($array as $indice) {
						$count++;
						if($count == 0 OR ($count % 12 == 0)){
							echo "<td>{$indice['VALOR']}</td></tr>";
						} else {
							if($count % 12 == 1) { echo "<td>{$indice['PCT_DESCRICAO']}</td>"; }
							if($count % 12 == 1) { echo "<td>{$indice['NAT_DESCRICAO']}</td>"; }
							echo "<td>{$indice['VALOR']}</td>";
						}
					}
				echo "</tbody>";

	}
}
	<?php defined('BASEPATH') OR exit('No direct script access allowed');

	class Welcome4 extends CI_Controller {

	/**
	* Gera a tabela de valores sem os nomes das naturezas e
	* foi inserido as colunas de PACOTE e NATUREZA no início
	* e implementado a possível ordenação por orden alfabética
	* de naturezas ou possível ordenação por ordem alfabética
	* de pacotes ...
	* @return [type] [description]
	*/
	public function index(){
	$this->load->view('welcome_message');
	}

	private function QueryValores(){

	$sql = "SELECT SUM(LANC_VALOR) AS VALOR, LANC_NAT_ID, natureza.NAT_DESCRICAO AS NAT_DESCRICAO, pacote.PCT_DESCRICAO AS PCT_DESCRICAO FROM meuslancamentos INNER JOIN natureza ON meuslancamentos.LANC_NAT_ID = natureza.NAT_ID INNER JOIN pacote ON pacote.PCT_ID = natureza.NAT_PCT_ID GROUP BY LANC_NAT_ID, LANC_DT_PAGTO ORDER BY PCT_ID ASC, LANC_DT_PAGTO ASC";
	$result = $this->db->query($sql)->result_array();

	/*echo "<pre>";
	print_r($result);
	echo "</pre>";*/

	return $result;
	}

	private function GetCats(){

	$sql = "SELECT NAT_ID FROM natureza";
	$result = $this->db->query($sql)->num_rows();

	return $result;
	}

	public function table(){

	$array = $this->QueryValores();
	$countRows = count($array);
	$countCats = $this->GetCats();

	echo "<!DOCTYPE html>
	<html lang=\"en\">
	<head>
	<meta charset=\"UTF-8\">
	<title>Document</title>
	<link rel=\"stylesheet\" href=\"https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/css/bootstrap.min.css\" />
	</head>
	<body class=\"container\" style=\"width:120%!important\">
	<h1>Tabela de Somatória de Lançamentos</h1>
	<table class=\"table table-bordered table-striped\">
	<thead>
	<tr>
	<td>PACOTE</td>
	<td>NATUREZA</td>
	<td>JAN</td>
	<td>FEV</td>
	<td>MAR</td>
	<td>ABR</td>
	<td>MAI</td>
	<td>JUN</td>
	<td>JUL</td>
	<td>AGO</td>
	<td>SET</td>
	<td>OUT</td>
	<td>NOV</td>
	<td>DEZ</td>
	<td>TOTAL</td>
	<td>MEDIA</td>
	</tr>
	</thead>
	<tbody>
	<tr>";
	$count = 0;
	foreach ($array as $indice) {
	$count++;
	if($count == 0 OR ($count % 12 == 0)){
	echo "<td>{$indice['VALOR']}</td></tr>";
	} else {
	if($count % 12 == 1) { echo "<td>{$indice['PCT_DESCRICAO']}</td>"; }
	if($count % 12 == 1) { echo "<td>{$indice['NAT_DESCRICAO']}</td>"; }
	echo "<td>{$indice['VALOR']}</td>";
	}
	}
	echo "</tbody>";

	}
	}