Ndtyjky

I have an array which consist of date and time with 'x' seconds of time interval as shown below [Example 1].

I am not sure of the ways of writing a query to group the data from array[0] to array[1], array[2] to array[3].

Can anybody help me out here ? Thank you.

Example 1:



    array:15 [▼

      0 => "'2018-11-01 00:00:00'"

      1 => "'2018-11-01 00:30:00'"

      2 => "'2018-11-01 01:00:00'"

      3 => "'2018-11-01 01:30:00'"

      4 => "'2018-11-01 02:00:00'"

      5 => "'2018-11-01 02:30:00'"

      6 => "'2018-11-01 03:00:00'"

      7 => "'2018-11-01 03:30:00'"

      8 => "'2018-11-01 04:00:00'"

      9 => "'2018-11-01 04:30:00'"

      10 => "'2018-11-01 05:00:00'"

      11 => "'2018-11-01 05:30:00'"

      12 => "'2018-11-01 06:00:00'"

      13 => "'2018-11-01 06:30:00'"

      14 => "'2018-11-01 07:00:00'"

      15 => "'2018-11-01 07:30:00'"

    ]

My current query looks like this

$testQuery = DB::Table('receipt_tbl')

    // ->whereRaw('created_at IN (' . implode(',' ,$timeIntv) . ')')

    ->whereBetween('created_at', [ Carbon::createFromTimestamp($startDate) ,  Carbon::createFromTimestamp($endDate)])

    ->where('receipt_type', $receiptObj->id)

    // ->groupBy('group_date')

    ->get();