aurawindsurfing

Hey @thebigk

This might be long shot but is there a way to sitemap your images and give it to google that way?

Here is some info I found: https://support.google.com/webmasters/answer/178636?hl=en

@hafizurupm it is the right place to learn how to make such a system for sure.

Start from https://laracasts.com/series/laravel-6-from-scratch

This will give you a good idea where you should start.

Hey @connecteev

AWS <> as close to free as possible

as fast as possible <> as close to free as possible

If you want something free and really well thought then go and try https://www.netlify.com/ this might serve your goal with few tweaks.

Hope it helps!

Hey @poxin

Trucker looks more like for mapping resources. What you need it to possibly Cache your responses from API to have some sort of safety on your side when API will be down. This way you will have old data to work with or by setting expiry on Cache you will actually limit your API queries.

Just an idea.

Hope it helps!

Why not do simple bash script for your project?

https://laravel-news.com/bash-aliases

Have it chained in one command and commit all of them at once, maybe even detect if there was a change and and only then commit that submodule?

Hope it helps!

Hi @konrms

I have a similar setup working. Some points from my notes that might help you troubleshoot.

Did you add

extension=oci8.so

to your php-fpm.ini?

check if it is installed:

php -m | grep oci

or

<?php phpinfo(); ?>
i
print_r(get_loaded_extensions());

test connection from your app:

$conn = oci_connect("USER", "passwprd", "localhost/xe");
 echo $conn;

Only here install yajra

Hope it helps!

Hey @region23

This solution does not run your Queue Worker in docker. It runs a command from outside of your docker container to run in a docker container called php

I stopped working with docker but the idea will be to run this command from within the container and actually build it with it already set up. Go back to the thread you are referencing and you will see that you answer is voted -3

https://stackoverflow.com/questions/48884802/docker-laravel-queuework

Go for one of the accepted solutions.

Hope it helps!

No worries! Oracle Magic!

Hi @konrms

I have a similar setup working. Some points from my notes that might help you troubleshoot.

Did you add

extension=oci8.so

to your php-fpm.ini?

check if it is installed:

php -m | grep oci

or

<?php phpinfo(); ?>
i
print_r(get_loaded_extensions());

test connection from your app:

$conn = oci_connect("USER", "passwprd", "localhost/xe");
 echo $conn;

Only here install yajra

Hope it helps!

Is this a question or a statement? 😃

@itxrahulsingh read the docs carefully.

The way this works is that request to your app will hit every middleware each time you ask for anything. This is how login of users works. Here, for example, you have default middleware that is already in use in your app:

protected $middlewareGroups = [
        'web' => [
            \App\Http\Middleware\EncryptCookies::class,
            \Illuminate\Cookie\Middleware\AddQueuedCookiesToResponse::class,
            \Illuminate\Session\Middleware\StartSession::class,
            // \Illuminate\Session\Middleware\AuthenticateSession::class,
            \Illuminate\View\Middleware\ShareErrorsFromSession::class,
            \App\Http\Middleware\VerifyCsrfToken::class,
            \Illuminate\Routing\Middleware\SubstituteBindings::class,
        ],

        'api' => [
            'throttle:60,1',
            'bindings',
        ],
    ];

So before anything happends in your app it already check for:

• cookies
• sessions
• authenticated sesssions
• errors in session
• csrf token

So it already checks if user is logged in. You only need to add another one that will let users log in only within working hours.

It will always work for every request to your app.

Hope it helps!

Hey @farshadf

Modify it to your needs but something like that will do the trick:

$room_capacity = Capacity::query()
            ->whereBetween('date', [
                Carbon::now()->startOfMonth()->subMonth()->toDateString(),
                Carbon::now()->startOfMonth()->subMonth()->endOfMonth()->toDateString(),
            ])
            ->get();

This here makes no sense:

->whereDate('from_date', '<=', $dates[$t])

It actually should be:

->where('date', '<=', $dates[$t])

Also if you try to do a booking system then try to think in a smallest possible interval when you think about your reservations. For instance if room can only be booked for 1 day, then instead of creating from_date to_date you could create 31 days in a given month and then create lets say 4 consecutive bookings for one day for that room - meaning it would be booked for 4 days.

This type of approach will make your system more flexible and easier to work with.

You can even go down to hours and book rooms per hours. Even go down to minutes etc etc. Your future queries would be much simpler then as well.

Hope it helps!

@itxrahulsingh read the docs carefully.

The way this works is that request to your app will hit every middleware each time you ask for anything. This is how login of users works. Here, for example, you have default middleware that is already in use in your app:

protected $middlewareGroups = [
        'web' => [
            \App\Http\Middleware\EncryptCookies::class,
            \Illuminate\Cookie\Middleware\AddQueuedCookiesToResponse::class,
            \Illuminate\Session\Middleware\StartSession::class,
            // \Illuminate\Session\Middleware\AuthenticateSession::class,
            \Illuminate\View\Middleware\ShareErrorsFromSession::class,
            \App\Http\Middleware\VerifyCsrfToken::class,
            \Illuminate\Routing\Middleware\SubstituteBindings::class,
        ],

        'api' => [
            'throttle:60,1',
            'bindings',
        ],
    ];

So before anything happends in your app it already check for:

• cookies
• sessions
• authenticated sesssions
• errors in session
• csrf token

So it already checks if user is logged in. You only need to add another one that will let users log in only within working hours.

It will always work for every request to your app.

Hope it helps!

Hi @zyxxyzyxz

Have a look here: https://laravel.com/docs/master/eloquent-relationships#updating-belongs-to-relationships

There are quite a few that you could use like

$user->account()->associate($account);
$user->account()->dissociate();

$user->save();

There is also one for pivots

// Detach a single role from the user...
$user->roles()->detach($roleId);

// Detach all roles from the user...
$user->roles()->detach();

Hope it helps!

Hi @zyxxyzyxz

Have a look here: https://laravel.com/docs/master/eloquent-relationships#updating-belongs-to-relationships

There are quite a few that you could use like

$user->account()->associate($account);
$user->account()->dissociate();

$user->save();

There is also one for pivots

// Detach a single role from the user...
$user->roles()->detach($roleId);

// Detach all roles from the user...
$user->roles()->detach();

Hope it helps!

Hey @shirotzumiyake

@foreach ($reactions as $reaction)

Inside this loop you should call $reaction and not $react

Also try to move your logic to Controller that displays this blade. There should suppose to be as little logic in your views as possible.

Hope it helps!

Hey @muazzamazaz

The simple answer "you can not".

While you access your app not from a browser then there is no cookies, no session etc.

What you need is JWT, have a look here: https://laravel.com/docs/5.8/passport

In a nutshell, you need to authorise every request that will hit your app's API.

Hope it helps!

Hey @muzafferdede

It could be a bit long shot but did you consider using tap() when you look at the docs this helper looks somewhat underrated:

https://laravel.com/docs/master/helpers#method-tap

but if you look at how Taylor is using it: https://medium.com/@taylorotwell/tap-tap-tap-1fc6fc1f93a6

It makes all the difference! I bet you can use it for your Class as well.

Hope it helps!

@itxrahulsingh create additional middleware that check for office hours.

Check the docs here: https://laravel.com/docs/master/middleware#defining-middleware

Hope it helps!

@farshadf I guess you need to go for a long long walk and look at it from distance.

You have quite experienced guys trying to help you here. I think you might be to fix on your way of doing things.

If you are trying to solve something with a monster query then it means that your whole app needs to be redesigned as it does not suit your purpose. Look at putting some of this directly on models that are involved. Then from use those models to simplify your controllers then break you query into smaller queries or query scopes etc etc.

Monster Queries are bad!

Happy Coding!

@farshadf are you able to write the same query in MySQL IDE and get expected results? Maybe try this first and make sure your query works on MySQL level?

Then he should run his method on results of groupBy it returns completely new set of records, this is why orderBy does not work I think.

Hey @farshadf

Use sortBy instead of orderBy

Hey @andreixfr

public function edit($id)
    {
        $model = Models::with('model_media')->findOrFail($id);
        if(!isset($model->sort)){
        $data['allMedia'] = ModelMedia::where([["model_id", "=", $id]])->orderBy('sort')->get();
      }else{
        $data['allMedia'] = ModelMedia::where([["model_id", "=", $id]])->orderBy('sort', 'DESC')->get();
      }

Hope it helps!

Hey @andreixfr

public function edit($id)
    {
        $model = Models::with('model_media')->findOrFail($id);
        if(!isset($model->sort)){
        $data['allMedia'] = ModelMedia::where([["model_id", "=", $id]])->orderBy('sort')->get();
      }else{
        $data['allMedia'] = ModelMedia::where([["model_id", "=", $id]])->orderBy('sort', 'DESC')->get();
      }

Hope it helps!

Hi @untymage

Your code finds only 1 artist. It does not look for usages of tag pop

$artist = Artist::withCount('tags')->find($id);

$artist->tags_count;

Try:

$artist->albums->where('tags', 'like', '%' . 'pop' . '%')->count()

Hope it helps!

You add guzzle with composer.

You push to the server only composer.json

Server installs it while deploying your code or you install it by hand by running

composer install

on your server.

What are you using for deployement of your code?

Hey @finchy70

First get a regular valet to work. Remove everything associated with valet and reinstall it completely.

It is questionable why Catalina should have anything to do with valet not working. It could be a simple restart of the machine that caused some changes to kick in that you have introduced yourself few weeks before.

Does valet start at all? What does it say when it starts?

What can you see when you run:

valet paths

valet links

Hi @myke2424

Something like that should do the trick for a start:

{{$months = collect(['Jan, Feb, Mar, Apr, May, Jun, Jul, Aug, Sep, Oct, Nov, Dec'])}}

<table class="table table-striped table-sm">
    <thead>
    <tr>
        <th scope="col">Month</th>
        <th scope="col">Overtime Hours</th>
        <th scope="col">Compensation Hours</th>
        <th scope="col">Vacation</th>
        <th scope="col">Personal Hours</th>
        <th scope="col">Sick Hours</th>
    </tr>
    </thead>
    <tbody>
    @foreach ($months as $month)
        <tr>
            <th scope="row">{{$month}}</th>
            <td></td>
            <td></td>
            <td></td>
            <td></td>
            <td>
        </tr>
    @endforeach
    </tbody>
</table>

@kidereo to download the file you need to send it to your browser as a response. Similar to what you do to send your browser to a view.

When you click something, just return from your controller Storage::download() that should do the trick.

Remember that you can download only one file that way.

Hope it helps!

Little google search: https://github.com/collizo4sky/omnipay-2checkout

https://dev.to/shuv1824/using-svelte-js-with-laravel-part-1-setting-up-laravel-application-with-svelte-36p4

Hi @andreixfr

Enable button if:

$last_report = $user->reports->latest()->first()->get();
if ($last_report->created_at < Carbon::now()->subMinutes(5)->toDateTimeString()) {
// show modal button
}

@wallyj

When you installed laravel did you install the latest version? Version 6.0.x does not support Braintree as far as I'm aware:

https://laravel.com/docs/6.x/braintree

but 5.8 does:

https://laravel.com/docs/5.8/braintree

Check version of your Cashier as well. I think this is the highest that supports Brainthree but I could be wrong: https://github.com/laravel/cashier/releases/tag/v9.3.5

Hope it helps!

Hey @gustavocassoto

You can pass token in the header of your http request as well.

Hey @arketekt

Yes this is exactly the way you should do this:

php artisan vendor:publish

The overwrite anything you like in resources/views In those views there should be references to the styling files so you might just want to write your own styles and drop the basic ones.

Hope it helps!

Hey @wva

Why not simply do in blade:

$team->upcomingEvents()->oldest()

Or whatever way you decide which one is coming up next.

What are you using to do this? You would typically do this with javascript so when some property changes the badge appears.

Do you have access to the console of that server?

You should run:

php artisan key:generate

Hope it helps!

Here is a simple 1-1 messaging package if anyone is looking for this: https://github.com/aurawindsurfing/messenger

Spot on @rugavy thanks!

Hey @successdav

Just think about it as a complete separate website that happen to have address shop.stechmax.com

From here it is just any ecommerce solution that you are looking after, wheater it will be laravel, shopify or anything else.

There is hundreads of materials how to to set up ecommerce out there.

Hey @bobbybouwmann

I'm building my first package and was wondering why:

if (!class_exists(CreateSomeTable))

did not detect the migration files, which in turn caused duplicate migration files while publishing which in turn caused the whole thing to crash ;-)

I changed the way I cjeck it in my ServiceProvider to:

if (empty(glob(database_path('migrations/*_create_messages_table.php'))))
            {
                $this->publishes([
                    __DIR__ . '/../database/migrations/0000_00_00_000000_create_messages_table.php' => database_path('migrations/' . date('Y_m_d_His', time()) . '_create_messages_table.php'),
                ], 'migrations');
            }

and now it is working as expected.

I was wondering however if there was any particular reason for them being excluded, other then making no sense to import them 😀

Hey Guys!

Just wonder if anyone can share with me why up until 5.4 everything in database folder was autoloaded:

"autoload": {
        "classmap": [
            "database"
        ],
        "psr-4": {
            "App\": "app/"
        }
    },

but since 5.5 it is only factories and seeds that are autoloaded.

"autoload": {
        "classmap": [
            "database/seeds",
            "database/factories"
        ],
        "psr-4": {
            "App\": "app/"
        }
    },

Could not find the pull request on github for this.

Thanks!

In console it should give you the line. If not then it is the first place you try to use this variable.

Hey @miwal

I just wonder, why would you write comments in your blade files at all? If you find yourself writing comments then your code is not clear to understand IMHO. Not that Laravel Core does not have lots of comments 😀

Hey @barley

Did you see this video? It might answer some of your questions:

Hey @dennys

Two problems here:

You should login only your users. Think about it. Every Trainer Formatore is a user. So just login users.

Second change the default field for user like in the documentation: https://laravel.com/docs/master/authentication#included-authenticating

Username Customization By default, Laravel uses the email field for authentication. If you would like to customize this, you may define a username method on your LoginController:

public function username()
{
    return 'username';
}

Hope it helps!

Hi Guys. I need some help with making my relationship query better. I have 4 columns like so:

users
user_id

vendors
id
user_id

jobs
id
user_id

offers
id
vendor_id

This is the query I came up with to display Vendor Jobs via offers that he placed. So user owns the jobs and vendors can place offers on them. Here is the query:

public function closedJobs()
    {
        return Job::whereState('closed')->with(['offers' => function ($offers) {
            $offers->whereVendorId($this->id);
        }]);
    }

Any way to handle it better? I did not want to install any third party packages like hasManyThroughDeep I want to use plain laravel eloquent only no RAW queries.

Thanks!

Sorry - edited my answer:

Do:

npm install quill

in terminal while being inside you application folder.

Edit /resources/js.app.js after

window.Vue = require('vue');

add

import Quill from 'quill';

Vue.use(Quill);

In your webpack.mix.js

Make sure it is part of the mix:

mix.js('resources/js/app.js', 'public/js')
    .sass('resources/sass/app.scss', 'public/css');

run npm run dev

Now it should be available to you.