Sergiu17

Amazon from scratch with Laravel & VueJS

https://www.cloudways.com/blog/connect-android-app-with-laravel-api/

https://www.google.com/search?q=laravel+api+for+android+app

@theunforgiven this is what I'd probably do

@foreach($costItems as $key => $cost)
    <td contentEditable="true" class="edit" id="q1_{{ $key }}"></td>
@endforeach

<button>Save</button>

<script>
    const itemsToBeSubmitted = []; // store here edited items

    $(".edit").focusout(function(){
        let split_id = this.id.split('_');
        let field_name = split_id[0];
        let edit_id = split_id[1];
        let value = $(this).text();

        itemsToBeSubmitted.push({
            field: field_name,
            value: value,
            id: edit_id
        });
    });

    // Now you have an array all edited elements
    document.querySelector('button').addEventListener('click', function() {
        $.ajax({
            url: '/claim/store',
            type: 'post',
            data: itemsToBeSubmitted,  // edited items
            success: (response) => {
                console.log('Saved successfully');
            }
        });
    });

PHP part

public function store(Request $request)
{
    $request->all(); // this is an array of arrays
    
    foreach($request->all() as $item)
    {
        // $item['id'], $item['field'], $item['value'];
        $model = Model::find($item['id'];
        
        $model->{$item['field']} = $item['value'];

        $model->save();
    }

    return 'Done';
}

I didn't tested this code, but I created something similar before. Hope it helps

@theunforgiven this is what I'd probably do

@foreach($costItems as $key => $cost)
    <td contentEditable="true" class="edit" id="q1_{{ $key }}"></td>
@endforeach

<button>Save</button>

<script>
    const itemsToBeSubmitted = []; // store here edited items

    $(".edit").focusout(function(){
        let split_id = this.id.split('_');
        let field_name = split_id[0];
        let edit_id = split_id[1];
        let value = $(this).text();

        itemsToBeSubmitted.push({
            field: field_name,
            value: value,
            id: edit_id
        });
    });

    // Now you have an array all edited elements
    document.querySelector('button').addEventListener('click', function() {
        $.ajax({
            url: '/claim/store',
            type: 'post',
            data: itemsToBeSubmitted,  // edited items
            success: (response) => {
                console.log('Saved successfully');
            }
        });
    });

PHP part

public function store(Request $request)
{
    $request->all(); // this is an array of arrays
    
    foreach($request->all() as $item)
    {
        // $item['id'], $item['field'], $item['value'];
        $model = Model::find($item['id'];
        
        $model->{$item['field']} = $item['value'];

        $model->save();
    }

    return 'Done';
}

I didn't tested this code, but I created something similar before. Hope it helps

You probably don't have permissions, try with chmod or chown

cd /var/www/project
ll // to see current permissions to storage folder
chmod -R 775 storage

Hi, show us the method which is triggered when you submit the post request

{{ auth()->user()->name }}

make sure this view is under auth middleware

@karolgil

$model->relation()->delete();

$article = Article::find(1);
$article->comments()->delete();

Also, consider what @codebyray said, will work much faster, with less code )

@karolgil

$model->relation()->delete();

$article = Article::find(1);
$article->comments()->delete();

Also, consider what @codebyray said, will work much faster, with less code )

@kumar201087mca check this out -- https://askubuntu.com/questions/452860/usr-bin-sudo-must-be-owned-by-uid-0-and-have-the-setuid-bit-set

Looks like the problem is in permissions, try to change with

sudo chmod 777 -R /storage

@dk4210

foreach($array['data'] as $user)
{
    if($user['name'] === 'bob') {
        echo $user['clientOid'], ' ', $user['schema'], ' ', $user['createdBy'];
    }
}

Like so

foreach($array['data'] as $user)
{
    if($user['name'] === 'bob') {
        print_r($user);
    }
}

$array['data'][0]['name']; // this should give you the name

$array['data'][0]['name']; // this should give you the name

@bmartus limit() returns Query and of course there's no user on the Query class

return $this->comments()->latest()->first(); // change to first.

hope this will be last issue. Also, you need to add an if statement to check if there is at least on comment, then print it, otherwise you will get trying to get property of non object

@bmartus limit() returns Query and of course there's no user on the Query class

return $this->comments()->latest()->first(); // change to first.

hope this will be last issue. Also, you need to add an if statement to check if there is at least on comment, then print it, otherwise you will get trying to get property of non object

@bmartus ok

return $this->comments()->latest()->limit(1); // add () after comments

Trying to get property of non object is this the error you get?

@antoine_herbert Good, you are using CURL, here is the doc from php.net - https://www.php.net/manual/en/function.curl-setopt.php

// took from examples
$data = array('name' => 'Foo', 'file' => '@/home/user/test.png');

curl_setopt($ch, CURLOPT_POSTFIELDS, $data);

@antoine_herbert that's totally different question..how do you send your request? using HTML Form? JavaScript? Postman? cURL? Any other mobile/desktop app?

Hi,

https://laravel.com/docs/6.x/routing#basic-routing

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

https://www.youtube.com/results?search_query=POST+Request+laravel

I can't even understand your post title

@inspiredprynce I don't know the structure of your tables, but what I can say is that you can GROUP by many columns, you mentioned per day, sign_in, roll_call and sign_out

GROUP BY DAY(create_at), sign_in, roll_call, sign_out

Hope I got it right

Hi,

// this query will return last ID of the grouped result of the given column
SELECT MAX(id) FROM your_table_name GROUP BY your_column_which_determinates_duplicates;

Let's take an example, tags table, id, name

id | name
----------------
1 | php
2 | laravel
3 | vue
4 | php
5 | ruby
6 | js
7 | vue
8 | js


SELECT MAX(id), name FROM tabs GROUP BY name; // this will return
id | name
----------------
2 | laravel
4 | php
5 | ruby
7 | vue
8 | js

// now if you have IDS which you don't want to delete, use `WHERE id NOT IN` 
DELETE FROM tags WHERE id NOT IN (
    SELECT * FROM (SELECT MAX(id) FROM tags GROUP BY name) AS ids
);

if($borrowrequest->stauts = 1) {

shouldn't be == or === ?

the same is true for your elseif statement, you need comparison operator, not assignment

Hi

public function store(Request $request)
{
    request()->validate([
        'amount' => 'required',
        'comment' => 'required',
        'customer_id' => 'required'
    ]);

    $payment = Payment::create($request->all());

    DB::table('payment_credit_updates')->insert([
        'customer_id' => $payment->customer_id,
        'amount' => $payment->amount,
        'date' => $payment->created_at, 
        'type' => 'DR'
    ]);

    return redirect()->back() ->with('success','category created successfully.'); }
}

Hi

public function store(Request $request)
{
    request()->validate([
        'amount' => 'required',
        'comment' => 'required',
        'customer_id' => 'required'
    ]);

    $payment = Payment::create($request->all());

    DB::table('payment_credit_updates')->insert([
        'customer_id' => $payment->customer_id,
        'amount' => $payment->amount,
        'date' => $payment->created_at, 
        'type' => 'DR'
    ]);

    return redirect()->back() ->with('success','category created successfully.'); }
}

@kalimeromk hope it helps :)

Schema::create('languages', function (Blueprint $table) {
    $table->bigIncrements('id');
    $table->string('name');
    $table->bigInteger('parent_id')->nullable();
});

Route::get('/', function () {
    // cache them if you don't change the often
    // you could even put them in local storage of the browser
    $languages = App\Language::with('children')->where('parent_id', 0)->get();

    return view('languages', compact('languages'));
});

@php
    function generateTree($languages, $level = 0)
    {
        foreach ($languages as $language) {
            if (count($language->children)) {
                echo '<option>', str_repeat("&mdash; ", $level) . $language->name, '</option>';
                generateTree($language->children, $level + 1);
            } else {
                echo '<option>', str_repeat("&mdash; ", $level) . $language->name . '</option>';
            }
        }
    }
@endphp

<select>
    @php generateTree($languages) @endphp
</select>

https://jsbin.com/kivuvuqofi/edit?html,js,output

@neeraj1005 Laravel View Composers if you want to share a variable to a specific view or every single view - https://laravel.com/docs/6.x/views#view-composers

@neeraj1005 would be nice to put this code in your controller, reason for this is that views should be dummy

// AdminLoginController.php

public function login()
{
    $data = Tbl_logo::find(1); // 1 should be dynamic I think
    // like Tbl_logo::where('company_id', auth()->id)->first();

    return view('admin.login', compact('data'));
}

this would be better

$data = Tbl_logo::get(); // collection
$data = Tbl_logo::first() // model instance
$data = Tbl_logo::where('user_id', auth()->id)->first() // model instance
$data = auth()->user()->tbl->company_avatar // model instance if u have relationship

You need a model instance in order to access company_avatar

$data = Tbl_logo::get(); // collection
$data = Tbl_logo::first() // model instance
$data = Tbl_logo::where('user_id', auth()->id)->first() // model instance
$data = auth()->user()->tbl->company_avatar // model instance if u have relationship

You need a model instance in order to access company_avatar

@mostafalaravel yes, but is bad practice to do test on your production database

public function test_links()
{
    $user = App\User::find($id); // $id is placeholder, App\User::find(1)

    $this->actingAs($user);
}

@kalimeromk https://laracasts.com/discuss/channels/eloquent/category-tree here is one stupid solution, recursive query

Or read about https://en.wikipedia.org/wiki/Nested_set_model or use cache

@mostafalaravel yes - https://laravel.com/docs/6.x/database-testing#writing-factories

factory(App\User::class)->create(['is_admin' => true]);

Hi, https://laravel.com/docs/5.1/testing#sessions-and-authentication

    public function testApplication()
    {
        $user = factory(App\User::class)->create();

        $this->actingAs($user)

Hi, https://laracasts.com/discuss/channels/laravel/handling-posttoolargeexception

and the answer is here - https://laracasts.com/discuss/channels/laravel/exception-handler-for-posttoolargeexception

Hi, https://laracasts.com/discuss/channels/laravel/handling-posttoolargeexception

and the answer is here - https://laracasts.com/discuss/channels/laravel/exception-handler-for-posttoolargeexception

Assuming you are using Vue and Axios.

Axios Interceptors https://github.com/axios/axios#interceptors

Fire an event every time when request is send or response is received.

Catch the event with your <show-loader> component, and toggle it's visibility.

How to create EventBus file - https://alligator.io/vuejs/global-event-bus/

Interceptors

// bootstrap.js
window.axios.interceptors.request.use(function (config) {
    EventBus.$emit('toggle-loader', true);

    return config;
}, function (error) {
    EventBus.$emit('toggle-loader', false);

    return Promise.reject(error);
});

axios.interceptors.response.use(function (response) {
    EventBus.$emit('toggle-loader', false);

    return response;
}, function (error) {
    EventBus.$emit('toggle-loader', false);

    return Promise.reject(error);
});

// Loader.vue
<template>
    <img v-if="visible" src="/images/spinner.gif" alt="">
</template>

<script>
    import { EventBus } from "../event-bus";

    export default {
        name: "Loader",

        data: function () {
            return {
                visible: false
            }
        },

        created() {
            EventBus.$on('toggle-loader', (boolean) => {
                this.visible = boolean;
            });
        }
    }
</script>

Hope it works and it helps

You have to configure yourself.

Nginx or Apache - both work great. Some people like Nginx, others like Apache.

https://laravel.com/docs/5.8/validation#rule-unique

unique:table,column,except,idColumn

$this->validate($request, [
    'im' => ['required', 'string', 'max:6', 'unique:table,column']
]);

1. Do you have errors in console?

2. As you typing do you see any request sent to your server? ( network tab in browser's dev tools )

3. Make sure you attach X-CSRF-TOKEN header to your request ( this is for Laravel )

<script type="text/javascript">
$.ajaxSetup({
    headers: {
        'X-CSRF-TOKEN': $('meta[name="csrf-token"]').attr('content')
    }
});
</script>

@icelander Hi again, we had a conversation here - https://laracasts.com/discuss/channels/laravel/displaying-an-output

$result = [];

foreach($or as $items) {
    foreach($items as $serializedObject) {
        $result[] = unserialize($serializedObject);
    }
}

return view('profiles.orders', ['orders' => $result]);

let's try to add an if statement, and append to result array only if we have cart property, something like this:

$result = [];

foreach($or as $items) {
    foreach($items as $serializedObject) {
        $userializedObject = unserialize($serializedObject);

        if (property_exists ($userializedObject , 'cart') ) {
            $result[] = $userializedObject;
        }
    }
}

return view('profiles.orders', ['orders' => $result]);

I didn't test it, hope it helps

But, would be even better is you'd add some kind of validation before you save this serialized string into database.

@icelander

$orders = Auth::user()->transactions;
$or = $orders->map->only(['cart'])->all();

$result = [];

foreach($or as $serializedObject) {
    $result[] = unserialize($serializedObject[0]);
}

return view('profiles.orders', ['orders' => $result]);

something like this, not sure why you have nested array, if it may have more values, you need to add one more foreach

foreach($or as $items) {
    foreach($items as $serializedObject) {
        $result[] = unserialize($serializedObject);
    }
}

@icelander

$orders = Auth::user()->transactions;
$or = $orders->map->only(['cart'])->all();

$result = [];

foreach($or as $serializedObject) {
    $result[] = unserialize($serializedObject[0]);
}

return view('profiles.orders', ['orders' => $result]);

something like this, not sure why you have nested array, if it may have more values, you need to add one more foreach

foreach($or as $items) {
    foreach($items as $serializedObject) {
        $result[] = unserialize($serializedObject);
    }
}

Hi, looks like your object is serialized, probably you store this information as a string in your database, all you have to do is to unserialize the string - https://www.php.net/manual/en/function.unserialize.php

@mehmetanbaki sad :/

search in google, how to install LAMP and Composer, hope you will find a tutorial, and your OS will accept everything

@mehmetanbaki do you have composer.json in your root directory project? do you have vendor directory? do you know why a vendor directory and composer.json are needed?

Do you use GIT? or how you changed your OS?