I'm encountering an issue with PhpSpreadsheet where I'm getting an "Invalid cell coordinate" error while trying to export an excel report from laravel project, Specifically with coordinates like '01'. I've checked my code and ensured that I'm using integer column…
I created CustomerController in Http, later, I fixed-route get customers, but getting an error in a single action Controller. I tried to show off CustomerController view for displaying customers logged in page Here is my error message: Use of undefined…
Relation public function groups() { return $this->belongsToMany('AppModelsItemGroup','item_to_group','item_id','item_group_id'); } ** How to select all Items that have item_group_id 0 and 9 BOTH?** $zero_and_nine_count = AppModelsItem::with(['groups' => function ($query) { $where[] = ['item_group_id', , 0]; $where[] = ['item_group_id', '=', 9]; $query->where($where); }])->count();…
In a laravel php application I use the sentry to keep error info for example this controller: class MuController { private function someMethodThatThrowsException() { throw new Exception('Told ya'); } public function foo() { try { $this->someMethodThatThrowsException(); return new JsonResponse(204); }…
I have a export method in Laravel 5.8 for exporting some results from oders table: public static function getAllData() { $records = DB::table('orders as t1') ->leftjoin('payments as t2', 't1.ord_id', '=', 't2.pay_ord_id') ->leftjoin('members as t3', 't2.pay_creator_id', '=', 't3.mbr_usr_id') ->where('t2.pay_confirm', 1) ->where('t1.ord_status','completed')…
I have tried validating the user request like this: $data = $request->validate([ 'fname' => 'nullable', 'lname' => 'nullable', 'gender' => 'required', 'mobile' => 'required|unique:users,usr_name', 'ncode' => 'nullable', 'password' => 'required', 'password_confirmation' => 'required', ]); That the mobile filed value must…
I want to export some results in Excel from the Model method, so I added this, public static function getAllData() { $records = DB::table('orders as t1') ->leftjoin('payments as t2', 't1.ord_id', '=', 't2.pay_ord_id') ->select(DB::raw("case when pay_type_id=190 then t1.ord_total - t2.pay_amount as…
I'm working with Laravel 5.8 and I have this method: public function getCourseDefinition() { $course_definition = DB::table('getCourseDefinition'); if (request()->has('cod_title') && request('cod_title')) $course_definition = $course_definition->whereRaw("cod_title = ?", [request('cod_title')]); } So it basically checks if the request contains cod_title, then searches for…
I'm working with Laravel 5.8 and I have made this Controller method for creating some records inside the DB. public function doTheUpload(Request $request) { try{ $request->validate([ 'video' => 'nullable|mimes:mp4', 'video_thumb' => 'required|mimes:jpg,png,jpeg', 'video_name' => 'required', 'video_desc' => 'nullable', 'available_download' =>…
I'm working with Laravel 5.8 and I have this syntax: @php($counter_foreach = 0) @foreach($memnames as $mem=>$memname) @php @endphp @endforeach Now when I run this, I get syntax error, unexpected 'endforeach' (T_ENDFOREACH) error: But when I remove @php @endphp, and replace…