-
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();