Laravel-date format variable SQL query for API value
given date value in string format , getting error in SQL query , so have to change it into date format in Laravel using Carbon function ( for date time )
laravel controller sample work to get values in json [RestAPI]
<?php
namespace App\Http\Controllers;
use Illuminate\Http\Request;
use App\Http\Resources\OrdersCollection;
use Illuminate\Support\Facades\DB;
use App\Http\Controllers\Controller;
use app\Orders;
use Response;
use Carbon\Carbon;
class OrdersController extends Controller
{
//
public function index(Request $request)
{
$fdate = $request->query('fdate');
$gdate = $request->query('gdate');
$users = DB::table('abctable')
->select(DB::raw('count(*) as count, city'))
->join('n3d_sales_flat_order_address',
'abctable.entity_id', '=', 'xyztable.parent_id')
->whereBetween('abctable.created_at',[new Carbon($fdate),new Carbon($gdate)])
->groupBy('xyztable.city')
->get();
return Response::json($users);
}
}
Carbon function
$users = DB::table(‘abctable’)
->select(DB::raw(‘count(*) as count, city’))
->join(‘n3d_sales_flat_order_address’,
‘abctable.entity_id’, ‘=’, ‘xyztable.parent_id’)
->whereBetween(‘abctable.created_at’,[new Carbon($fdate),new Carbon($gdate)])
->groupBy(‘xyztable.city’)
->get();