ahmeddabak

Share your User model

You do not have a foreign key user_id in you departments table

Auth::user()->projects please read my previous replay, when a relation is called as a property it returns a collection

You need to define the hasManyThrough relation

public function projects() {
	return $this->hasManyThrough('App\Project', 'App\Department');
}

for more info read the laravel docs: Has Many Through

make sure you are requiring require("ion-rangeslider"); before calling it. you can also try assigning the library to a global variable

window.ionRangeSlider = require("ion-rangeslider");

also make sure you are compiling the code and using the result js file.

First there is a diffirence between calling the relation like a method, or like a property.

when called as a method Auth::user()->departments() you get the relation it self, which in this case is a BelongsToMany relation. that allows you to extends the query or create new records

Auth::user()->departments()->create([
	//
]);

but when called as a property Auth::user()->departments you get the result of the relation, which in this case is a collection of many departments it is equivalent to Auth::user()->departments()->get().

now to resolve the error, you need to know that the projects relation is not on the collection of many items returned by departments but it is on the models inside of it.

so you can do the following on User you can use the hasManyThrough relation which let you query the projects directly from the user model

Auth::user()->projects

or you get the departments and for each of them you get the projects, which will result to a collection of collections.

Auth::user()->departments->map->projects

Since it is a table you must echo the last column even if it was empty, you can use the optional helper to avoid throwing an error when updated by is not set.

 @foreach($tasks as $task)
            <tr>
                <td>{{$task->id}}</td>
                <td>{{$task->title}}</td>
                <td>{{$task->description}}</td>
                <td>{{$task->created_at}}</td>
           	<td>{{$task->createdBy->name}}</td>
                <td>{{optional($task->updatedBy)->name}}</td>
	</tr>
@endforeach

The error is clear. in this file headerTwo.blade.php you are using array_key_exists() to check if an object has a specific property. which is now deprecated. so you instead use isset like this isset($object->property) of using property_exists like this property_exists($object,'property')

Since it is a table you must echo the last column even if it was empty, you can use the optional helper to avoid throwing an error when updated by is not set.

 @foreach($tasks as $task)
            <tr>
                <td>{{$task->id}}</td>
                <td>{{$task->title}}</td>
                <td>{{$task->description}}</td>
                <td>{{$task->created_at}}</td>
           	<td>{{$task->createdBy->name}}</td>
                <td>{{optional($task->updatedBy)->name}}</td>
	</tr>
@endforeach

can you please provide more info about the error, also please share any relevant code

i have updated the code

After scrapping the page, you can search the html for the words you need to find.

it is not an easy task, but to know more you can learn about 'crawlers', there is a good one from spatie

Yes, it is a little bit tricky but not that hard.

class Category extends Model
{
    public function categories()
    {
        return $this->hasMany(static::class, 'parent_id');
    }

    public function nestedCategories()
    {
        return $this->categories()->with('nestedCategories');
    }


    /**
     * Return a collection with all the nested categories
     *
     * @return \Illuminate\Support\Collection
     */
    public function categoryTree()
    {
        return $this->getNestedCategories($this);
    }

    /**
     * Internal recursive call function
     *
     * @param $category
     * @return \Illuminate\Support\Collection
     */
    private function getNestedCategories($category)
    {
        $tree = collect([]);

        foreach ($category->nestedCategories as $category) {
            $tree->push($category);

            $sub_tree = $category->getNestedCategories($category);
            if ($sub_tree->isNotEmpty()) {
                $tree->push($sub_tree);
            }
        }

        return $tree;
    }

}

so now you can call the following code, it lets you get all ids for the category with id 1 and all sub categories, and using the nested relation, you would do one or two queries for the whole branch

$ids = Category::with('nestedCategories')->where('id',1)->get()->categoryTree()->flatten()->pluck('id');

Your are right, this subject was discussed on stackoverflow, here is the little hack they used to fix it

You are checking if the start_date bigger then both dateInStart and dateInStart

and the end_date smaller then both dateInStart and dateInEnd

are you sure this is what you want?

the foreign key customer_id on the users table an be null, when a user selects a customer, then you change the value to the customer->id, if the user changed the customer again you just need to update the customer_id to the new customer->id

$file = \Illuminate\Http\UploadedFile::fake()->create('test.pdf')->store('pdfs')

runphp artisan db:seed -v and post the full stack

Since it is not an spa, i would let laravel do the work of passing the data to the view and handling the logic

if you have phpunit globally installed just run phpunit --self-update on linux or mac or vendor\bin\phpunit --self-update on windows. it should Update PHPUnit to the latest version.

otherwise try to upgrade it using composer.

The easiest solution would be to update the page in order to refresh the token. but the csrf token is used on multiple pages, say for example you have a long form. and the user start filling it and you reload the page while the user is still working on it.

So you can either change the session lifetime in config/session.php, as the csrf token if not changed stay valid as long as the session is valid.

'lifetime' => //how long should the session be valid

or you can update it using an ajax call

//in your web.php
Route::get('update-csrf', function(){
    return csrf_token();
});

<meta name="csrf_token" content="{{ csrf_token() }}">
<script>
            function updateToken(){
                $.get('update-csrf').done(function(data){
                    $('[name="csrf_token"]').attr('content', data);
                });
            }

            setInterval(updateToken, 1000 * 60 * 5); 

</script>

Check which errors you have in the developer tools

Try this

Post::with(['users'=> function($query) {
        $query->where('age','>', 18);
    }])->get();

@lukegalea16

https://github.com/ahmeddabak/laravel-tcp-sockets

So i just did what the article said, you can run it on your local machine

to start listening i created a console command php artisan test it will listen to any tcp connection on port 31337

from windows connect to the computer ip and port 31337 using a telnet client ex. MobaXterm usingth command telnet SERVER_IP 31337

The tcp socket will great you and ask you to enter a string, when you hit enter the server will show you the string reversed and ask you for a new one. it is a simple app but should help you understand tcp sockets.

Credit to Akram Wahid and his article PHP and Laravel Receiving GPS Tracker Data to Specific TCP/IP Port

Please mark this as solved

You should authorize the request, check laravel gates and policies

@lukegalea16

https://github.com/ahmeddabak/laravel-tcp-sockets

So i just did what the article said, you can run it on your local machine

to start listening i created a console command php artisan test it will listen to any tcp connection on port 31337

from windows connect to the computer ip and port 31337 using a telnet client ex. MobaXterm usingth command telnet SERVER_IP 31337

The tcp socket will great you and ask you to enter a string, when you hit enter the server will show you the string reversed and ask you for a new one. it is a simple app but should help you understand tcp sockets.

Credit to Akram Wahid and his article PHP and Laravel Receiving GPS Tracker Data to Specific TCP/IP Port

Area::query() is not a relation, so you can not do relation stuff with it, there are many solutions

1- move the if statement to the controller and there you can create a new query or use the relation

2- if you think you will be needing this in many locations, just create a repository to get the data for you

Just add the withTrashed to your relation on the fly.

  $assetDetails = $assetDetails->with([
            'assetDocuments' => function ($query) {
                $query->withTrashed()->select('id', 'assetId', 'assetUsage', 'volume', 'amount', 'documentType', 'links', 'link', 'userId', 'uploadTime', 'expiryDate', 'coordinate')->orderBy('assetdocument.uploadTime', 'desc')->get();
            },
            'assetDocuments.userDetails:id,firstName,lastName,middleName',
        ]);

@snapey Great work

use Polymorphic Relationships

create both StaffProfile and CustomerProfile models and in your users table add profile_type and profile_id

    $table->morphs('profile');

then in the User model add

public function profile()
    {
        return $this->morphTo();
    }

filteredSubcategories: function() { 
    return this.subcategories.filter((item) => item.category_id == this.form.category_id);
}

filteredSubcategories: function() { 
    return this.subcategories.filter((item) => item.category_id == this.form.category_id);
}

If the problem is solved, please mark this as solved

Just use

Installation::select(DB::raw('COUNT(*) as count'), 'type')->groupBy('type')->pluck('count', 'type');

It should give the exact result you want.

That is not a problem, it is only a cached version of the page in the browser. The user will be logged out and will not be able to do anything

Please mark this as solved

Just use

Installation::select(DB::raw('COUNT(*) as count'), 'type')->groupBy('type')->pluck('count', 'type');

It should give the exact result you want.

The method is there, but it is hidden in a trait.

Just add the code i gave you to the LoginController

In your App\Http\Controllers\Auth\LoginController you can override the logout method to prevent redirecting back, here you can send the user where ever you want

/**
     * Log the user out of the application.
     *
     * @param  \Illuminate\Http\Request  $request
     * @return \Illuminate\Http\Response
     */
    public function logout(Request $request)
    {
        $this->guard()->logout();

        $request->session()->invalidate();

        return $this->loggedOut($request) ?: redirect('/login'); //redirect to login
    }

department is a foreign key as shown in the model. It has department_id that is derived from OrgDepartment.

I do not know how your database or models are built, the code i submitted should give you an idea how to solve the problem. just change $employees->where('employees',$request->get('department')); to what ever works for you.

How do I display each of the search fields and the submit button in the view.

return view('hr.employees.index')->with([
    'employees' => $employees->paginate(6),
    'department' => $request->get('department'),
    'employee_code' => $request->get('employee_code')
]);

then in the view

<input type="text" name="department" value="{{old('department', isset($department) ? $department : null )}}" />
<input type="text" name="employee_code" value="{{old('employee_code', isset($employee_code) ? $employee_code : null )}}" />

 if($request->has('full_name')) {
        $employees->whereRaw("CONCAT(first_name, ' ', other_name, ' ', last_name) LIKE ?", ['%'.$request->get('full_name').'%']);
    }

Auth::user()->password is encrypted, so you can not read the original password and therefore it can not be used to protected a pdf.

<div class="tab-content">

    <div class="tab-pane{{old('tab') == 'kt_tabs_7_4' ? ' active' : null}}" id="kt_tabs_7_4" role="tabpanel">
        //
    </div>

    <div class="tab-pane{{old('tab') == 'kt_tabs_7_5' ? ' active' : null}}" id="kt_tabs_7_5" role="tabpanel">
        //
    </div>

    <div class="tab-pane{{old('tab') == 'kt_tabs_7_1' ? ' active' : null}}" id="kt_tabs_7_1" role="tabpanel">
        //
    </div>

</div>

<div class="tab-content">

    <div class="tab-pane{{old('tab') == 'kt_tabs_7_4' ? ' active' : null}}" id="kt_tabs_7_4" role="tabpanel">
        //
    </div>

    <div class="tab-pane{{old('tab') == 'kt_tabs_7_5' ? ' active' : null}}" id="kt_tabs_7_5" role="tabpanel">
        //
    </div>

    <div class="tab-pane{{old('tab') == 'kt_tabs_7_1' ? ' active' : null}}" id="kt_tabs_7_1" role="tabpanel">
        //
    </div>

</div>

Are you sure that both methods are in the right controller SingleproductController

department is a foreign key as shown in the model. It has department_id that is derived from OrgDepartment.

I do not know how your database or models are built, the code i submitted should give you an idea how to solve the problem. just change $employees->where('employees',$request->get('department')); to what ever works for you.

How do I display each of the search fields and the submit button in the view.

return view('hr.employees.index')->with([
    'employees' => $employees->paginate(6),
    'department' => $request->get('department'),
    'employee_code' => $request->get('employee_code')
]);

then in the view

<input type="text" name="department" value="{{old('department', isset($department) ? $department : null )}}" />
<input type="text" name="employee_code" value="{{old('employee_code', isset($employee_code) ? $employee_code : null )}}" />

I am happy to do a demo project tonight and upload it on git for you.

This code should do the trick, and only display to each user what he has the right to see.

class HrEmployeesController extends Controller
{
 public function index(Request $request)
 {
    $userCompany = Auth::user()->company_id;

    if (Auth::user()->hasRole('Super Admin')) {
        $employees = HrEmployee::query();
    } else {
        $employees = HrEmployee::where('company_id', $userCompany);
    }

    if($request->has('department')) {
        $employees->where('employees',$request->get('department '));
    }

    if($request->has('employee_code')) {
        $employees->where('employee_code',$request->get('employee_code '));
    }


    return view('hr.employees.index')->with('employees', $employees->paginate(6));
 }
}