How to make several separate selects with laravel 4.2?

Question

How to make several separate selects with laravel 4.2?

Navigation

#1 by (0 votes)

0

Hello, I need to do a select in a table, but if I do not receive the month by the parameter I must do the SUM method to sum every month

if($month != 0){
            $dbRegister = tb_data::selectRaw('tb_data.total_points');
        }else{
            $dbRegister = tb_data::selectRaw('sum(tb_data.total_points)');
        }   
$dbRegister->selectRaw('TB_USERS.login,TB_USERS.name)->get()

The problem is that if I do this way above, laravel dsconsidera select within the if

Would anyone have a better solution?

mysql laravel laravel-eloquent

asked by anonymous 26.01.2018 / 15:06

1 answer

App is closing when debugging on Android How do I sweep a string and bring different parts of it?

score 0 · Answer 1

You can use addSelect as follows:

if($month != 0)
{
      $dbRegister = tb_data::selectRaw('tb_data.total_points');
}
else
{
     $dbRegister = tb_data::selectRaw('sum(tb_data.total_points)');
}   


$dbRegister->addSelect('TB_USERS.login','TB_USERS.name')->get();

That is, addSelect adds more elements in SQL .

Query Builder - Selects