I'm trying to use a HasMany relation in a HasOne. I have following Models: class Auction extends Model { //... public function bids(): HasMany { return $this->hasMany(Bid::class, 'auction_id'); } public function approvedBids(): HasMany { return $this->bids()->approved(); } public function topBids():…
I have a table with 3 columns: firstname lastname fullname in migration: Schema::create('owners', function (Blueprint $table) { $table->id(); $table->string('firstname',20); $table->string('lastname', 20); $table->string('fullname')->storedAs('CONCAT(firstname,lastname)'); $table->timestamps(); }); the problem is that i want to change the concatenation order in the controller i tried…
What I'm trying to do is this: I have two tables with One to Many relationship sectors id name position set_plan_id seat_plans id name order I want to sort all sectors based on the order field present in seat_plans (which…
By default, Laravel uses the email and password fields for authentication , I want to change the default fileds for authentication and set the code_massar , date_naissance fields as default any help !! Schema::create('users', function (Blueprint $table) { $table->id(); $table->string('name');…
I have problem with validating html select. I put rules and all other form controls work fine but only select not show validate message. Model class Post extends Model { protected $table = 'post'; static $rules = [ 'title' =>…
Below is my laravel 8 api route and middleware that I use Route::group(['middleware'=>['auth:api', 'StripScript'],'prefix' => 'v1'], function(){ Route::get('/list', [ListController::class, 'list']); }); I this I want to bypass middleware 'auth:api' if I get request from specific ip address so user doesn't…
I am trying to update image to image/brand/ folder but unexpectedly error is occurred. public function update(Request $request,$id){ $validated = $request->validate([ 'brand_name' => 'required|max:4', // 'brand_image' => 'required|mimes:jpg,jpeg,png', ]); $old_image=$request->old_image; $brandimage=$request->file('brand_image'); $image_gen=hexdec(uniqid()); $image_exten=strtolower($brandimage->getClientOriginalExtension()); $image_name=$image_gen.'.'.$image_exten; $image_location='image/brand/'; $image_uplioad= $image_location.$image_name; $brandimage->move($image_location,$image_name); unlink($old_image); Brand::find($id)->update([…
App For Rental Car : I need check car if available between 2 date and check quantity ("column name : qty"), There is no need for a car more than the available number of cars (number cars booking < QTY…
I am working on a blogging application in Laravel 8. The application gives the users rights by assigning them roles. Every role has a set of permissions. There is a many-to-many relationship between roles and permissions. In the user-rights view,…
How do I return the following response format using the code below: {"data":[],"meta":{"paging":{"links":[],"total":0},"time":0.079}} The controller code: public function someMethod() { $var=SomeModel::with(['status' => function ($query) { $query->where('name', 'like', '%Pending Payment%'); }])->get(); return [ 'data' => $var, ]; } Response am getting…