Rescue Data to Create Dynamic Tables and Charts

Question

all right?

I have a question here in a project I picked up, I am not an expert in database and much less in php, I am in the learning phase. I need a function to collect some database data in a way that I can use them to create some tables and graphs.

It should look more or less like this table:

But she’s bringing the data like this:

I need the data to be listed in the way shown in the first table, and then I need to do the sum corresponding to the month, in order to generate a graph. Don’t notice the graph, but only the marking of the circle in red which is what I need at the moment:

There are two tables to work with this data. One is the font table, which would be where the person got the contact (google, Whatsapp, pamphlet, etc). The other table would be the registration table, which contains the "registration date" and the "ID" of the contact source.

My code is as follows:

Model

function total_fontes() {       

    $this->db->select('COUNT(*) AS total');
    $this->db->from('clientes cl');
    $this->db->join('fontes ft', 'ft.id_fonte = cl.fontes_id_fonte');

    $query = $this->db->get();  

    foreach ($query->result_array() as $val) {
        return $val['total']; 
    }
} 

Controller:

public function index() {

    $data = array(
        'page_title' => 'Gráficos',
        'show_clientes' => $this->mdl_clientes->get_datas(), //busca de datas com group_by
        'show_fontes' => $this->mdl_fontes->get_ordem_alfabetica(),//busca fontes e ordena alfabeticamente
        'fontes_quantidades' => $this->mdl_fontes->total_fontes(),//busca o total de fontes por dia (nao funciona)
    );

    $flash_msg = $this->session->flashdata('flash_message');
    if (isset($flash_msg) && !empty($flash_msg)) {
        $data['flash'] = $flash_msg;
    }

    $this->load->view('graficos/vwGraficos.php', $data);

}

View (no formatting, I’m searching first to be able to list):

<table border="1">

    <?php if($show_fontes != FALSE) : ?>

            <tr>
                <td>DATA</td>

                <?php foreach($show_fontes as $fnt) : ?>

                    <td>
                        <?= $fnt->titulo_fonte; ?>
                    </td>

                <?php endforeach; ?>
            </tr>
    <?php endif; ?>    

            <?php if($show_clientes != FALSE) : ?>

                <?php foreach($show_clientes as $clnt) : ?>
                    <tr>
                        <td>
                            <?= $clnt->data_registro; ?>
                        </td>
                        <td>
                            <?= $fontes_quantidades; ?>
                        </td>
                    </tr>
                <?php endforeach; ?>

            <?php endif; ?>

If you can help me, I’d appreciate it.