I want to import excel, and my code of controller is $path = $request->file('file')->getRealPath(); $dataOfMember = Excel::toArray(new InterfaceMember(), $path); $dataOfMember = $dataOfMember[0]; $insert_dataOfMember = []; foreach ($dataOfMember as $row) { $insert_dataOfMember[] = [ 'kodeToko' => $kodeToko = session('authData')['kodeToko'], 'idMember' =>…
I am working on a workshop mechanic directory for a client using Laravel 8 framework and he wants a feature to review the workshop and also select multiple mechanics who the client worked with. Each Workshop have multiple reviews and…
I was maintaining a stock inventory system while selling a product available stock will be reduced based on oldest purchased means which product purchased first will be sold out first. I take the sales quantity with following lines: $product_id =…
https://github.com/spatie/laravel-csp https://github.com/frontegg/frontegg-vue I Need help, After i added the laravel csp the front egg vue login page not working. Refused to apply inline style because it violates the following Content Security Policy directive: "style-src 'self' https://fonts.googleapis.com 'nonce-loop' 'unsafe-inline' nonce-loop". Note…
I have implemented a query like this : $categories = DB::select("SELECT categories.* FROM categories left JOIN products on products.category_root = categories.id") ->withCount('products') ->where('products_count' , '>' , 0)->get(); that mean get categories where have at least one product with category_root equal…
Laravel with does not work currently next to get method when get has argument I have two table that has one-to-many relationship. I wrote this code: Page::with('user:id,name')->get(); that work currently, but I want specific columns from pages table (such as…
I have the following models/tables: branch: id - integer department: id - integer teacher: id - integer branch_department_id - integer branch_department: id - integer branch_id - integer department_id - integer each branch has many departments through the pivot table branch_department…
I'm working on a tdd project where I simply want to make sure that the password is not returned by mistake. here is the test I wrote. public function testInfoMethodJsonStructure() { $user = User::factory()->create(); $response = $this ->actingAs($user) ->get('/api/profile/info'); $response->assertStatus(200);…
I was working on a laravel project. The following is the code of my UserController: <?php namespace AppHttpControllersBackendAdminUsers; use AppModelsUser; use IlluminateHttpRequest; use SpatiePermissionModelsRole; use AppHttpControllersController; use IlluminateSupportFacadesSession; use AppRepositoriesInterfacesUserRepositoryInterface; class UserController extends Controller { protected $userRepository; public function __construct(UserRepositoryInterface…
The calculation of the total price of products with their quantity. the total price exists in the order migration table with a default of 0 value, and I want to put the $res value in the total_price column. public function…