select data based on the array

Question

I have an array from query like below:

array:84 [
      0 => array:2 [
        "comp" => "50007148"
        "cus" => "F0401"
      ]
      1 => array:2 [
        "comp" => "50007148"
        "cus" => "J0050"
      ]
      2 => array:2 [
        "comp" => "50007148"
        "cus" => "L"
      ]
      3 => array:2 [
        "comp" => "50007148"
        "cus" => "LT"
      ]
      4 => array:2 [
        "comp" => "50007148"
        "cus" => "RP"
      ]

Now I need to write a query where comp, cus in above query.

$rslt = Stdetl::whereIn('comp, cus', $categories)
                           ->where(YEAR(docdate), '=', 2019)
                           ->get(SUM(number))->toArray();

But this query is not working. I am getting error as follows:

(1/1) FatalErrorException
Call to undefined function App\Http\Controllers\YEAR()

But this is not the only mistake in that query .

Jerodev · Accepted Answer · 2019-01-16 11:57:39Z

1

YEAR() is a mysql function, you should use whereRaw() to query this. Like this:

->whereRaw('YEAR(docdate) = 2019')

Update:

For your whereIn() part, you have to make two queries, one for each column. So you will have to get the correct values from the array. This can be done using array_map.

For example:

->whereIn('comp', array_map(function($cat) { return $cat['comp']; }, $categories))
->whereIn('cus', array_map(function($cat) { return $cat['cus']; }, $categories))

edited Jan 16, 2019 at 11:57

answered Jan 16, 2019 at 11:20

Jerodev

33.3k11 gold badges96 silver badges113 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

S S Over a year ago

thank you .. I have error in whereIn('comp, cus', $categories) too even though there is comp and cus in table, it says Column not found: 1054 Unknown column 'comp, cus'

Jerodev Over a year ago

I have added an update for the whereIn part of the query.

Palak Jadav · Accepted Answer · 2019-01-16 12:24:07Z

0

You can't use whereIn like that, use this way

$rslt=Stdetl::whereIn('comp', $categories)
             ->whereIn('cus', $categories)
             ->where(date('Y', strtotime(docdate)), '=', 2019)
              ->get(SUM(number))->toArray();;

edited Jan 16, 2019 at 12:24

answered Jan 16, 2019 at 12:14

Palak Jadav

1,2901 gold badge13 silver badges27 bronze badges

2 Comments

S S Over a year ago

I tried like this but it take only first wherein only

Palak Jadav Over a year ago

use DB instead DB::table('table_name')->whereIn('comp', $categories) ->whereIn('cus', $categories)->where(date('Y', strtotime(docdate)), '=', 2019)->get(SUM(number))->toArray();

Collectives™ on Stack Overflow

select data based on the array

2 Answers 2

2 Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related