Posts by Alan Sousa • 1 point

• 0

  votes

  1

  answer

  101

  views

  A: Column not found using ALIAS in Laravel

  I found the solution, in case someone find the same problem, or similar, I only changed some information in the query. Vendas::leftjoin('faturamento', 'faturamento.CodVenda','=','vendas.CodVenda')…

  php sql laravel querybuilder

  answered 5 years, 11 months ago Alan Sousa 1

• -2

  votes

  1

  answer

  101

  views

  Q: Column not found using ALIAS in Laravel

  I am in trouble when accessing a column in the Windows query Builder, the following code works in Sql Workbench. Vendas::selectRaw('if(faturamento.Codfaturamento is null, vendas.totalvenda,…

  php sql laravel querybuilder

  asked 5 years, 12 months ago Alan Sousa 1

• 0

  votes

  1

  answer

  119

  views

  A: Create query in query Builder - Standard

  I managed to solve, it would have to be done with whereRaw, to bring the query I had done in SQL to Laravel. $total_hoje = Vendas::whereRaw('date(DataEmissao)=date(NOW())') ->whereIn('tipo',…

  mysql laravel querybuilder

  answered 6 years ago Alan Sousa 1

• 0

  votes

  1

  answer

  119

  views

  Q: Create query in query Builder - Standard

  I’m starting to work with Laravel and need to make a query in the database, is a simple query, but as I’m starting I do not know yet perform it. I need to get the sales done today, yesterday, this…

  mysql laravel querybuilder

  asked 6 years ago Alan Sousa 1