How do I write the following SQL code in the Codeigniter Model?

Question

select count(situacao) as Qtde, sum(valorcausa) as Total_Valor_Causa 
from processo
where situacao = "Tramitando";

Answer 1

There are several ways to do this, the one I recommend, for making the code more organized is this:

$this->db->select('count(situacao) as Qtde, sum(valorcausa) as Total_Valor_Causa');
$this->db->where('situacao', 'Tramitando');
$query = $this->db->get('processo');

Another way is to put the entire query inside the query(), thus:

$this->db->query('select count(situacao) as Qtde, sum(valorcausa) as Total_Valor_Causa 
from processo where situacao = "Tramitando"')->get();

I recommend the first one because you can add other filters in the query, such as:

$this->db->order_by('Total_Valor_Causa', 'DESC');

The above code will add an order by Total_Valor_Causa.

To return only one line, you can sort by id desc, and limit the query to 1 record, so the result will be the last record inserted;

$this->db->order_by('id', 'DESC');
$this->db->limit(1);

More information