laravel perform two query in one function

Simply i have a two table

GALLARIES AND MEDIA

In a GALLARIES table id,title,venueId i have saved gallary folder name for the particular venue. In MEDIA Table I have id,imagepath,is_thumb(0 or 1),gallery_Id

What i want to do is when i set is_thumb_image(1) then i have call two function

1 st for unset image all with gallery_id and after i call second function for set is_thumb_image for particular image.

Is it possible to call one function only and perform both functionalty.

Here is my Controller code.

        $albumId = $request->album_id; //table galleries id  - album name
        if($request->is_thumb_image == "true") { 
            $media1->UnsetThumbImage($albumId); // first unset thumb_image 
            $media->setThumbImage($media->id); // call for set thumb_image 
        } else {
            $request->is_banner_image = false;
        }

Here is my model functions

 public function setThumbImage($mediaId) {
   try {
        DB::table('media')
            ->where('id', $mediaId)
            ->update(['is_thumb_image' => 1]);
        $this->is_thumb_image = 1;
    } catch (\Exception $ex) {
        echo $ex->getMessage();
        dd($ex->getTraceAsString());
    }
}

public function UnsetThumbImage($albumid) {
    DB::table('media')
    ->where('gallery_id', $albumid)
    ->update(['is_thumb_image' => 0]);
    $this->is_thumb_image = 1;
}

How can i do it calling only one function.

from Newest questions tagged laravel-5 - Stack Overflow http://ift.tt/2ALOiUI
via IFTTT

how can delete record using db class with softdelete ? can we do?

I Want to delete record using db class but not delete physically delete. I want to softdelete using db class. Is it Possible? My Code is $items =DB::table('forum')->where('forum_id', '=', $forum_id)->softDeletes();

from Newest questions tagged laravel-5 - Stack Overflow http://ift.tt/2nkjfJA
via IFTTT

December month date query not working in Laravel

Very bizarre one here, I have a controller doing a date search for the current month - December in this case.

I have two dates for the range of December - I'm using created_at >= date(2017-12-01) and created_at < date(2018-01-01).

In Laravel the query it is not returning any results at all even though a) I'm expecting some records, and b) mysql query select * from redemptions where created_at >= date('2017-12-01') and created_at < date('2018-01-01') order by created_at desc, gives me the results I expect.

In the controller I have verified via dd that both the dates are as above and the sql dump is correct: select * from redemptions where created_at >= ? and created_at < ? order by created_at desc.

Hope I'm not missing something obvious :)

from Newest questions tagged laravel-5 - Stack Overflow http://ift.tt/2zUNrkk
via IFTTT

Syntax to copy a file in Laravel (5.4) from local to AWS S3?

What's the best way to copy an uploaded file from my Laravel installation (running on Heroku) to S3? I can't do a direct to S3 upload, as it's an image that I'm locally generating a thumbnail for. I also don't want to use any extra libraries etc. (sledgehammer to crack a nut etc.). File needs to go in a particular folder in my S3 bucket. Is this the only/best way? :-

Storage::disk('s3')->put('S3_folder_name/file.jpg', file_get_contents('my_local_file.jpg'));

Thanks

from Newest questions tagged laravel-5 - Stack Overflow http://ift.tt/2keN3WL
via IFTTT

Laravel 5.4 printing out a seating plan

I have an sql table of seats with the columns (id,row, seat_number). Im trying to print out the seats something like this,

A 1,2,3
B 4,5,6
C 7,8,9

I've managed to do this by hard coding if statements for each row, like so

    @if($row->rw==='A')
                  <div class="row">
                      <div class="col-md-1"></div>
                     @foreach($seats as $seat)
                         @if($seat->rw === 'A')
                             
                        @endif
                @endforeach
            </div>
        @endif

What I would like to know is a better method that doesn't require me to hard code each row. I'm guessing it would be some loop that would go through and check the row for unique character and print the seat_numbers in that row.

I'm fairly new to laravel and php as I'm sure you can tell, I don't want anyone to do the work for me I just want pointing in the right direction. Any help is greatly appreciated.

from Newest questions tagged laravel-5 - Stack Overflow http://ift.tt/2ArpO2v
via IFTTT

Laravel 5.5 Inconsistent JSON when using filter on a collection

I am building a simple search for a project I am working on. It works fairly well for the most part. I am running into an issue when using ->filter(function($item) { .. }).

Here is the code:

$users = App\User::select(['id', 'username', 'preferred_first_name', 'preferred_last_name'])
        ->where('username', 'like', $like)
        ->orWhere('preferred_first_name', 'like', $like)
        ->orWhere('preferred_last_name', 'like', $like)
        ->orWhere('id', $query)
        ->get();
$users = $users->filter(function($item) {
    return !$item->is_terminated();
});
return UserResource::collection($users);

And here is the toArray function in UserResource:

public function toArray($request)
{
    return [
        'id' => $this->id,
        'username' => $this->username,
        'full_name' => $this->full_name,
    ];
}

The issue I am having is some of the JSON is returned in two different formats:

Format A: { data: [ {..}, {..}, .. ] }
Format B: { data: {"0": {..}, "1":{..},..} }

I would like all the JSON to be returned in Format A all the time. I've narrowed it down the filter() function. But it is inconsistent. On the search term san it returns in Format B but on the term pha it returns in Format A. If removed everything works perfectly and is returned in the proper format (Format A).

If there's any code missing that could help let me know as I am unsure what needs to be included.

from Newest questions tagged laravel-5 - Stack Overflow http://ift.tt/2jzipUk
via IFTTT

Laravel / VueJS 403 despite hardset true values

I've got an SPA where I'm using Laravel 5.5 as the framework and VueJS in the frontend. I've installed passport but am unsure whether I've done it properly as the documentation seems to go a little bit over my head.

Any post requests that attempt to verify the user through laravel's policies are returning back 403. Even when I hard code a true response through the Policy I still return a 403? The framework and SPA are on the same domain.

Process flow:

axios.delete('/api/barracks/reply/delete/' + this.reply.id, {
   id: this.reply.id
});

-> Which processes through here in my Routes/API

Route::delete('/barracks/reply/delete/{reply}','ForumRepliesController@destroy');

Which then goes here:

public function destroy(ForumReply $reply)
{
    $this->authorize('update', $reply);
}

Which then goes through this:

public function update(User $user, ForumReply $forumReply)
{

    return true;

}

It returns a 403 error. What is also strange is that if I manually try to do the validation with something like an Auth::id()==$reply->id logic it fails because the Auth::id is null??? However in a create method it's able to correctly insert auth()->id() for the same controller.

from Newest questions tagged laravel-5 - Stack Overflow http://ift.tt/2jzNWVT
via IFTTT

laravel Job / Queue not been processed weird infinite loop

I'm trying to create a queue but it doesn't work when I run php artisan queue:work all I get in my terminal is

[2017-11-30 19:56:27] Processing: App\Jobs\ProcessCSV
[2017-11-30 19:56:27] Processing: App\Jobs\ProcessCSV
[2017-11-30 19:56:27] Processing: App\Jobs\ProcessCSV
[2017-11-30 19:56:27] Processing: App\Jobs\ProcessCSV
[2017-11-30 19:56:27] Processing: App\Jobs\ProcessCSV
[2017-11-30 19:56:27] Processing: App\Jobs\ProcessCSV
[2017-11-30 19:56:27] Processing: App\Jobs\ProcessCSV
[2017-11-30 19:56:27] Processing: App\Jobs\ProcessCSV
[2017-11-30 19:56:27] Processing: App\Jobs\ProcessCSV
[2017-11-30 19:56:27] Processing: App\Jobs\ProcessCSV

It's like an infinite loop. The id in my jobs table just goes up and up too. It does work on my laptop but not on my desktop which is very strange. I put in onto my devleopment server and it doesn't work on there either.

My code is below and any help would be appreciated.

Controller

public function upload(Request $request) {
        if($request->file('imported-file')) {

            $user = "craig@boldy.co.uk";

            $file = $request->file('imported-file')->store('uploads', 'public');
            $this->dispatch(new ProcessCSV($file, $user));

            Session::flash('success', 'Your file was uploaded successfully. We will email you once the locations have be imported.');
            return back();

        } else {

            Session::flash('error', 'Please select a file to upload!!!!');
            return back();

        }

    }

Job

public function handle()
    {

        $data = Excel::load($this->file, function($reader) {})->get();

        $apiKey = '';

        foreach($data as $row) {

            if(!empty($row['postcode'])) {

                $url = "http://ift.tt/1jxG3tJ".urlencode($row['postcode'])."&region=uk&key=";
                $tmp = file_get_contents($url);
                $xml = simplexml_load_string($tmp);

                // print_r($xml); exit;

                if((string)$xml->status == 'OK' && isset($xml->result[0])) {

                    if(isset($xml->result[0]->geometry->location->lat)) {
                        $lat = (string)$xml->result[0]->geometry->location->lat;
                    }

                    if(isset($xml->result[0]->geometry->location->lng)) {
                        $lng = (string)$xml->result[0]->geometry->location->lng;
                    }

                }

                Import::updateOrCreate(
                    [
                        'sitecode' => $row['sitecode']
                    ],
                    [
                        'sitecode' => $row['sitecode'],
                        'sitename' => $row['sitename'],
                        'address_1' => $row['address_1'],
                        'address_2' => $row['address_2'],
                        'address_town' => $row['address_town'],
                        'address_postcode' => $row['postcode'],
                        'charity' => $row['charity'],
                        'latitude' => $lat,
                        'longitude' => $lng,
                        'approved' => 1
                    ]
                );

            }

        }


    }

from Newest questions tagged laravel-5 - Stack Overflow http://ift.tt/2Amgzhs
via IFTTT

how can update date in many to many relationship laravel

Can anyone help me on how to update many to many relationship? I have tasks, user can have many tasks and task can have many users (many to many), What I want to achieve is that in update form admin can assign multiple users to specific task. This is done through html multiple select input

this is my controller

public function index()
{
    // this is in main view
    $tasks=Task::all()->load('users');
    $userLogin_id=Auth::user()->id;
    $users=User::all()->where('id','!=',$userLogin_id);
    return view('adminUser.index',compact('tasks','users'));
}


public function store(Request $request)
{
    // to create new task and for who it
    $task =Task::create($request->all());
    $userId=$request['employee'];
    $task->users()->attach($userId);
    return back();
}

public function edit($task_id)
{
    //to go to view that has update code
    $task=Task::find($task_id)->load('users');
    $userLogin_id=Auth::user()->id;
    $users=User::all()->where('id','!=',$userLogin_id);

    return view('adminUser.edit',compact('task','users'));
}

public function update(Request $request, $task_id)
{
    //to update task 
    $user_id=$request['employee'];
    Task::where('id',$task_id)
        ->update(['title'=>$request['title'],
                    'description'=>$request['description'],
                    'status'=>$request['status'],
                    'file_path'=>$request['file_path']]);
    //what i can do complete this method if it is correct
    return redirect('/admin');
}

this my user model

public function tasks(){
   return $this->belongsToMany('App\Task','Todos','user_id','task_id');
}  

this my task model

public function users(){
    return $this->belongsToMany('App\User','todos','task_id','user_id');
}  

from Newest questions tagged laravel-5 - Stack Overflow http://ift.tt/2jyPMGB
via IFTTT

Submit DataTables Selected Value to PHP Deletion function in Laravel via a Post Request

I have a table, using the DataTables API, that is populated with a list of entries from a database. I would like my user to select a entry from the table, click a delete button, and the selected entry will be deleted from the database. I'm using Laravel. So, my initial instinct is to send the selected entry in a post request where I will process the selected entry via a Controller.

1) How can I forward my selected entry (var rowData) to my Laravel Controller via a post request once the user clicks the delete button?

2) Is there a better solution?

[HTML]

<div class="table-responsive">
    <table class="table table-bordered" width="100%" id="someTable"></table>
</div>

<form action="/somePage/deleteObject" method="post">
    <input type="hidden" value="delete">
    <button id="delBtn" type="submit" class="btn" >
        Delete
    </button>
</form>

[Javascript] - Populates table and provides events for when an entry is selected.

<script type="text/javascript">
    $(document).ready(function(){ 
        var table = $('#someTable').DataTable( {
            select: {
                style: 'single'
            },
            "scrollX": true,
            "scrollY": '70vh',
            "scrollCollapse": true,
            "paging": false,
            dom: 'ft',
            "aoColumns": [
                { "sTitle": "Name",  "mData": "name" },
                { "sTitle": "Email", "mData": "email" },
                { "sTitle": "Group", "mData": "group" },
                { "sTitle": "Access Level", "mData": "level" }
            ],
            "aaData": {!! collect($users)->toJson() !!}
        } );

        // Event handling: Pulled directly from DataTables example
        table
            .on( 'select', function ( e, dt, type, indexes ) {
            document.getElementById("delBtn").disabled = false;
            var rowData = table.rows( indexes ).data().toArray();
        } )
            .on( 'deselect', function ( e, dt, type, indexes ) {
            document.getElementById("delBtn").disabled = true;
            var rowData = null;
        } );
    } );
</script>

[Laravel Route]

Route::post('/somePage/deleteObject', 'Controller_Page@deleteObject');

[Laravel Controller]

public function deleteObject(){
    $value =  Request::get('rowData');
    dd("Reached Delete", $value);
}

from Newest questions tagged laravel-5 - Stack Overflow http://ift.tt/2j55dH9
via IFTTT

Attain many has-many-through

I need to attain latest comments from array of users through posts.

Users model

public function comments()
 {
   return $this->hasManyThrough('App\Comment', 'App\Post');
 }

has-many-through

$user = users::where('id',5)->first();

$user->comments()->get()

many has-many-through

$user = users::where('role','member')->get();

How can I achieve this.

from Newest questions tagged laravel-5 - Stack Overflow http://ift.tt/2BoWeHJ
via IFTTT

php code to get the device OS and version?

I am making an Android app with a mechanism that requires getting the device OS and version. I was hoping that you will give me an answer.

ps: working on laravel 5 with php 7.1

from Newest questions tagged laravel-5 - Stack Overflow http://ift.tt/2AKB0Yp
via IFTTT

Laravel DB class no table method on new project

I just can't figured out this issu; On a new Laravel project, I just can't use table method on DB class.

I use PhpStorm as EDI on OSX Sierra with Laravel 5.5.

Here my steps:

1. In terminal: Laravel new testproject
2. In terminal: composer install
3. In terminal: php artisan make:controller testdummy
4. In EDI:

<?php

namespace App\Http\Controllers;

use Illuminate\Http\Request; use Illuminate\Support\Facades\DB;

class testdummy extends Controller

{ // public function index(){ DB::table('title')->insert([ 'label' => 'test1', 'desc' => 'test2', ]); } }

The 'table' have a warning popup in EDI that say: 'Method table not found in Illuminate\Support\Facades\DB'. And no insertion are made to database.

Have you some hints on where to look next to help me find the problem?

thanks,

from Newest questions tagged laravel-5 - Stack Overflow http://ift.tt/2AlU0JK
via IFTTT

Mysql: How to optimize deleting thousands of rows

I have hundred thousand rows in my table and I want to delete with condition It took 15 min but still not done? It's just a plane table no related model. Its a chunk of almost 200k rows that I want to remove I need to specify which needed to remove so I need to use condition If I can just truncate. Is there any way to handle this, I'm using laravel

Details::where('file_name_belongs',$file_name)->delete();

from Newest questions tagged laravel-5 - Stack Overflow http://ift.tt/2AKCvpl
via IFTTT

Displaying the correct datetime value in laravel

I have a blog created with Laravel 5.5, In PostController and in Create function i have specified the time format for "Published_at" cloumn to 24 format, and it's inserted correctly into database with the right format

Nov 30, 2017 | 17:11:19

But when i try to display the time in post page i got this format

30, 11, 2017 | 1:51:29 pm

I don't know why, i have tried to use "strtotime()" solution but i got wrong date and time

Jan 1,1970 | 01:00:00

I hope the problem clearly described

from Newest questions tagged laravel-5 - Stack Overflow http://ift.tt/2zDBbkc
via IFTTT

Laravel - Weird Invalid date time format error when updating post

I am making an edit page to edit posts on my website, Each post is inside of a channel. When I try to edit the post without changing the channel it is in. It gives me a weird error stating:

Invalid DateTime format: 1366 Incorrect integer value: 'PHP' for column 'channel_id' at row 1

But however, When I edit the channel too, It works perfectly fine. What is causing this? I think it has something to do with my form. A post has a channel_id. so that connects it to a channel with that ID. The relations between the two is fine.

This the the piece of form that I think is causing the issue:

<div class="form-group row">
   <div class="col-md-12">
      <label for="Kanaal">Kanaal:</label>
   </div>
   <div class="col-md-12">
     <select class="form-control" id="Kanaal" name="channel_id">
       <option selected></option>
       @foreach($channels as $channel)
       <option value="" >
       
       </option>
       @endforeach
     </select>
   </div>
 </div>

The method where I store the updated post looks like this:

public function updatePost(Request $request, $id)
{

    $post = Post::find($id);
    $post->channel_id = $request->channel_id;
    $post->title = $request->title;
    $post->text = $request->text;
    $post->slug = str_slug($request->title);

    $post->save();

    return back()->with('flash', 'Het bericht is bewerkt!');
}

It reaches the method just fine. But when I do not edit the channel option tag it gives me that error, While if I do edit it, it works fine.

I don't know if I'm explaining this well, But this is the best I can do. Thanks in advance!

from Newest questions tagged laravel-5 - Stack Overflow http://ift.tt/2zS9lEM
via IFTTT

Can't querry datas

I have the following tables:

biens(id,prix,option_id,quartier_id,typebien_id);
options(id,libelle);
typebiens(id,libelle);

I need to select all biens with the specific optionsand typebiens. here is what i do:

    public function afficherCommerce($libelle)
    {
       $bienscommerce = \App\Bien::with(['option','typebien','quartier'])
           ->where('biens','option.id','=','biens.option_id')
           ->where('options.libelle','=',$libelle)
           ->get();
}

But can't query them. Need your help!

from Newest questions tagged laravel-5 - Stack Overflow http://ift.tt/2AKb6Ei
via IFTTT

laravel-localization with translated slug stored in database

I try to make a multilingual laravel. To do this, I use different packages

• spatie/laravel-translatable to store my translation data in the same column under a JSON array
• mcamara/laravel-localization to define my translatable routes

My slugs are translated and stored in database as follows:

{
   "fr": "Accueil",
   "en":"Home"
 }

And all my other translatable data are also like that. And to access one of my data, I use for example, $page->slug or $page->title.

My translations work well. But now, I'm trying to build a menu of languages with the right URLs.

I want, if I am on the page "about" have two links in the menu :

• http://myapp/en/about
• http://myapp/fr/a-propos

Here is my code :

<ul>
    @foreach(LaravelLocalization::getSupportedLocales() as $localeCode => $properties)
        <li>
            <a rel="alternate" hreflang="" href="">
                
            </a>
        </li>
    @endforeach
</ul>

Unfortunately my urls are bad. If I am on the page "about" in English I have in my menu :

• http://myapp/en/about
• http://myapp/fr/about

And I would like http://myapp/fr/a-propos. The data is stored in my database.

Is there a way to make sure to collect data from other languages while in a different locale (here I am in EN and I would like to have the slug FR).

Can you help me ? Thank you very much !

from Newest questions tagged laravel-5 - Stack Overflow http://ift.tt/2ArtmSf
via IFTTT

Laravel 5 validate string with multiple dates comma separated

How can i validate this string with the laravel validate? I want to check if the dates between the commas is a date.

2017-11-11,2017-12-11-2017,2017-13-11

from Newest questions tagged laravel-5 - Stack Overflow http://ift.tt/2nhEgol
via IFTTT

Larave5 permissions issue

I have a simple ansible script to up and run docker environment for local/development machines. Inside the script I have set project permissions task which caused the problems:

One version of the task:

- name: Set permissions
  shell: >
      sudo chown -R :  && sudo chmod ug+w -R 
      && sudo chgrp -R www-data /storage /bootstrap/cache
      && sudo chmod -R ug+rwx /storage /bootstrap/cache

and all working fine until we need to store/change something in storage directory. i.g we can't log command line information.

Another version:

- name: Set permissions
  shell: >
      sudo chown -R : 
      && sudo find  -type f -exec chmod 664 {} \;
      && sudo find  -type d -exec chmod 775 {} \;
      && sudo chgrp -R www-data /storage /bootstrap/cache
      && sudo chmod -R ug+rwx /storage /bootstrap/cache

the issue I'm facing here is when I running npm run dev from my user I got the error:

> @ development /var/www/vhosts/project
> cross-env NODE_ENV=development node_modules/webpack/bin/webpack.js --progress --hide-modules --config=node_modules/laravel-mix/setup/webpack.config.js

sh: 1: cross-env: Permission denied

npm ERR! Linux 4.2.0-42-generic
npm ERR! argv "/usr/bin/node" "/usr/bin/npm" "run" "development"
npm ERR! node v6.11.5
npm ERR! npm  v3.10.10
npm ERR! code ELIFECYCLE
npm ERR! @ development: `cross-env NODE_ENV=development node_modules/webpack/bin/webpack.js --progress --hide-modules --config=node_modules/laravel-mix/setup/webpack.config.js`
npm ERR! Exit status 126
npm ERR! 
npm ERR! Failed at the @ development script 'cross-env NODE_ENV=development node_modules/webpack/bin/webpack.js --progress --hide-modules --config=node_modules/laravel-mix/setup/webpack.config.js'.
npm ERR! Make sure you have the latest version of node.js and npm installed.
npm ERR! If you do, this is most likely a problem with the  package,
npm ERR! not with npm itself.
npm ERR! Tell the author that this fails on your system:
npm ERR!     cross-env NODE_ENV=development node_modules/webpack/bin/webpack.js --progress --hide-modules --config=node_modules/laravel-mix/setup/webpack.config.js
npm ERR! You can get information on how to open an issue for this project with:
npm ERR!     npm bugs 
npm ERR! Or if that isn't available, you can get their info via:
npm ERR!     npm owner ls 
npm ERR! There is likely additional logging output above.

npm ERR! Please include the following file with any support request:
npm ERR!     /var/www/vhosts/project/npm-debug.log

npm ERR! Linux 4.2.0-42-generic
npm ERR! argv "/usr/bin/node" "/usr/bin/npm" "run" "dev"
npm ERR! node v6.11.5
npm ERR! npm  v3.10.10
npm ERR! code ELIFECYCLE
npm ERR! @ dev: `npm run development`
npm ERR! Exit status 1
npm ERR! 
npm ERR! Failed at the @ dev script 'npm run development'.
npm ERR! Make sure you have the latest version of node.js and npm installed.
npm ERR! If you do, this is most likely a problem with the  package,
npm ERR! not with npm itself.
npm ERR! Tell the author that this fails on your system:
npm ERR!     npm run development
npm ERR! You can get information on how to open an issue for this project with:
npm ERR!     npm bugs 
npm ERR! Or if that isn't available, you can get their info via:
npm ERR!     npm owner ls 
npm ERR! There is likely additional logging output above.

FYI: npm install working fine

I would appreciate any help!

from Newest questions tagged laravel-5 - Stack Overflow http://ift.tt/2zC1FlW
via IFTTT

how to create sub page in laravel 5.5?

I am working in laravel 5.5 and I am trying to open page from route like

Route::get('/admin/admin/adminprofile', function() {   return \View::make('admin\adminprofile');});

but it is not working.

from Newest questions tagged laravel-5 - Stack Overflow http://ift.tt/2AfxaW2
via IFTTT

Laravel Media Gallary Function not Working

This is my first question on stack.Here my question is i have function saveMedia, On this function i have save media Images and also set flag is_banner_image or is_thumb_image.When i upload two images and set one image as thumb image it update on table both images as thumb_image. I have added my Controller function here..

public function saveMedia(Request $request) {
    $albumId = $request->album_id;

    try {
        $gallery = Gallery::findOrFail($albumId);
        $media = $gallery->media()->findOrNew($request->id);
        $media->fill($request->all());

        if($request->is_banner_image) { // true or false
            $media->setBannerImage();
        } else {
            $request->is_banner_image = false;
        }

        if($request->is_thumb_image) { // true or false
            $media->setThumbImage();
        } else {
            $request->is_thumb_image = false;
        }

        if($media->save()) {
            return response()->json([
                'id' => $media->id,
                'message' => 'Media saved successfully'
            ]);
        } else {
            return response()->json([
                'message' => 'Unable to save media!!'
            ]);
        }
    } catch (\Exception $ex) {
        return response()->json([
            'message' => 'Unable to save media!!'
        ]);
    }
}

My Model Query function for both thumb image and banner image :

public function setBannerImage() {
    try {
        DB::table('media')
            ->whereIn('gallery_id', $this->gallery->source->gallery->modelKeys())
            ->update(['is_banner_image' => 0]);
        $this->is_banner_image = 1;
    } catch (\Exception $ex) {
        echo $ex->getMessage();
        dd($ex->getTraceAsString());
    }
}

public function setThumbImage() {
    DB::table('media')->
        whereIn('gallery_id', $this->gallery->source->gallery->modelKeys())->
        update(['is_thumb_image' => 0]);
    $this->is_thumb_image = 1;
}

I want to update only one at a time.Thanx in advance.

from Newest questions tagged laravel-5 - Stack Overflow http://ift.tt/2Bmmcvg
via IFTTT

Laravel: Prevent direct access of files from public folder

I am stuck on this part of my laravel application, Where I am asked to protect the files from directly accessed via url browser hit. I have a public folder in which in a doc folder is present where all the documents are going to be uploaded. I just need a solution to prevent this where i can access docs directly from my application but any third party visitor can not view my docs (images,pdfs etc..).

I have tried many solutions but its not at all working. I just want to things :- 1. Protect my docs through direct access. 2. Way of implementing it in laravel (via .htaccess)

I know this can be possible through htaccess, but how? Kindly help Please :)

from Newest questions tagged laravel-5 - Stack Overflow http://ift.tt/2k9muCt
via IFTTT

How To Design Weekly Hours For a lot of Users and show as Yearly Report

Please Help Me To Store Weekly Hours Of Employee Data iN mysqli weekly wise

from Newest questions tagged laravel-5 - Stack Overflow http://ift.tt/2ByQFay
via IFTTT

Which is best way to call model function in controller with multiple where condition using Laravel ?

• Create function in model with multiple where condition
• Possibility to use group by with aggregate (Multiple group by as well)
• Use whereIn
• Use Order By

I mean make it dynamically as more you can

Also explain how we can call in controller by using load model first.

from Newest questions tagged laravel-5 - Stack Overflow http://ift.tt/2iqtKcI
via IFTTT

Migrating from Laravel 4.2 to 5.5 (Authentication / Password Mismatch Error)

I am migrating a project from 4.2 to 5.5. I have reached 5.3, I have taken backups for every successful version update 5.0, 5.1, 5.2. The problem is, after my 5.2 update, my authentication as working well and I was able to login to the system. However, after the 5.3 update, I am not able to login. I have followed all steps from official documentation for upgrading.

Thanks in advance for any help.

from Newest questions tagged laravel-5 - Stack Overflow http://ift.tt/2zClytc
via IFTTT

Page Expired if POST method (Laravel 5.5)

My routes

Route::middleware('auth.basic')->group(function(){


Route::post('/', 'DeliveryController@calc')->name('delivery');

Route::post('pickup/', 'DeliveryController@getPickup');

Route::post('pec_pickup/', 'DeliveryController@getPecPickupPoint');});

when i try send request with postman i got "Page Expired". But if i replace all routes with GET - all ok.

from Newest questions tagged laravel-5 - Stack Overflow http://ift.tt/2nhuS40
via IFTTT

check the object is created and create new one if not exist

I want to create a object to insert a new data or update the value.I want to check the object is created and then create a new object.before create a object I want to check exit or not

$status_tracker=new status_tracker();   

from Newest questions tagged laravel-5 - Stack Overflow http://ift.tt/2iqgMvH
via IFTTT

MySQL: Specified key was too long; max key length is 767 bytes

I'm creating a development version of a Laravel 5.4 application, which is working, albeit without a complete database.

When I ran php artisan migrate it generated most of the tables, but some failed, though without errors.

When I then attempted an import via phpMyAdmin, I got an error:

#1071 - Specified key was too long; max key length is 767 bytes

... on a number of tables, which happen to be the ones the migration failed to create (it's worth noting that some of the tables have multiple keys, so the error itself is — to me at least — a bit vague).

The production application uses MySQL 5.7 while the development application uses 5.6, which I understand is the cause.

Anyone know how I get around this, without using Docker?

from Newest questions tagged laravel-5 - Stack Overflow http://ift.tt/2Aq6Rx1
via IFTTT

storing file path using laravel and component vuejs2

i work with an interface with backend laravel and frontend vuejs2 i used a component to register a new record in my database it work perfectly with the input type text but with input type file i don't know how to get the path and store it using function store of laravel

component vuejs

template

  <input type="file" @change="processFile($event)"  id='image' v-model="article.image" >

</div>
 <div class="modal-footer">

<button type="button" @click="CreateArticle">Enregistrer</button>
 </div>

vue Script

<script>
    export default {
        data(){
            return {
                articles:[],

                article:{
                    image:'',
                },
          }
        },


        methods:{


            CreateArticle:function(){

                axios.post(window.Laravel.url+'/addArticle',this.article)

                .then( response => {
                    if(response.data.etat){

                        this.article.id=response.data.id;
                        this.articles.unshift(this.article);
                        this.article={
                                    id:0,
                                    image:'',

                                }     
                    }

                    })

                  .catch(error => {


                    });
            },

           processFile(event) {
            this.someData = event.target.files[0],

  },
        },

    }
</script>

Controller function

public function addArticle(Request $request){

        $art=new Article();
        if($request->hasFile('image')){
         $art->img=$request->image->store('images');

       }

        $art->save();

    return Response()->json(['etat'=>true,'id'=>$art->id]);

}

route:

Route::post('/addArticle','CategorieController@addArticle');

from Newest questions tagged laravel-5 - Stack Overflow http://ift.tt/2iqdSXs
via IFTTT

How to implement query caching in laravel

I am trying to implement caching in my php/laravel application. I am using the repository pattern along with laravel. Now laravel provides inbuilt cache support something like

$value = Cache::rememberForever('users', function() {
    return DB::table('users')->get();
});

But i wanted to implement a general cache system so that even if i change my database this should work. Any help is appreciated.

from Newest questions tagged laravel-5 - Stack Overflow http://ift.tt/2kbyVgY
via IFTTT

Laravel : Validate JS not appearing in bootstrap Modal

Here is my HTML page. In my HTML page when i tried to submit the form I can see the validate JS Error. But when i convert it to laravel the validation error not appearing. The form comes as Bootstrap modal. What could be possible reason for that?

 <form  id="signin-form" method="POST" action="">
    
       <div class="row clearfix">
           <div class="form-group icon-group col-md-12">
                <div class="group-inner">
                    <input id="field-two" type="email" value="" name="email"  placeholder="Email" >
                </div>
           </div>
           <div class="form-group icon-group col-md-12">
                <div class="group-inner">
                    <input id="field-three" type="password" value="" placeholder="Password" name="password" >
                </div>
           </div>
           <div class="form-group icon-group col-md-12">
                 <div class="group-inner">
                    <button  class="theme-btn btn-style-two ru_btn width100per margin0">Sign In</button>
                 </div>
           </div>
       </div>
   </form>

Here is the snap of validate js which appears in HTML page:

from Newest questions tagged laravel-5 - Stack Overflow http://ift.tt/2AIytOs
via IFTTT

Laravel Download Database Tables in background

I've created command in Laravel which download (copy) database's .sql files from staging server and paste it on production server (Requirement). I don't have SSH access to production server, So created route for that command and execute it from URL. Here are my code.

Route

Route::get('console/import_all',
    function () {
    Artisan::call('importDatabase:staging', ['tables' => 'all']);
});

Command Function

private function downloadFile($url, $path)
{
    sleep(5);
    return copy($url, $path);
}

Now there are approx 30+ files and some of them are more than 10MB in size. My command works fine from SSH (by admin) and from URL as well. But issue is when I hit command from URL, page keeps loading till all download finish. Is there any way to execute this from background? So if admin hit button from admin panel, s/he should not wait for all the time until coping all file finish and I can display message that process has been start and you will notify once done.

from Newest questions tagged laravel-5 - Stack Overflow http://ift.tt/2AgNwOc
via IFTTT

local.ERROR: PDOException: SQLSTATE[HY000]: General error: 1615 Prepared statement needs to be re-prepared in happen in every morning

I am very new to laravel,

Now handling a laravel project it's get error in every morning, and after some time it's become okay. I don't understand what is the issue. I googled it and see some similar issues. But it does not resolve my issue guys help me to find solution for this. It's cause of big time lose for my work.

db version is 5.1.1

from Newest questions tagged laravel-5 - Stack Overflow http://ift.tt/2ipe2Pb
via IFTTT

Laravel / Eloquent - Prevent "deleted_at" Column From Being Returned by get() Method

I have a model that looks like:

<?php

namespace App\Models;

use Illuminate\Database\Eloquent\Model;
use Illuminate\Database\Eloquent\SoftDeletes;

class Location extends Model{

    use SoftDeletes;

    // Name of our database table
    protected $table = 'locations';

    // Column for soft deletes
    protected $dates = ['deleted_at'];

    // Columns that are mass assignable
    protected $fillable = ['name', 'address', 'city'];

}

When I call Location::get(), the deleted_at column is returned by default.

How do I prevent this column from being returned without explicitly specifying it?

from Newest questions tagged laravel-5 - Stack Overflow http://ift.tt/2An5JdD
via IFTTT

Call to undefined method Illuminate\Database\Query\Builder::attachPermission()

Here's my code for DatabaseSeeder

use Illuminate\Database\Seeder;
use App\User;
use App\Role;
use App\Permission;

class DatabaseSeeder extends Seeder
{
    /**
     * Run the database seeds.
     *
     * @return void
     */
    public function run()
    {
       // $this->call(UsersTableSeeder::class);
       DB::table('users')->delete();
       //1) Create Admin Role
       $role = ['name' => 'super-admin', 'display_name' => 'Super Admin', 'description' => 'Full Permission'];
       $role = Role::create($role);
       //2) Set Role Permissions
       // Get all permission, swift through and attach them to the role
       $permission = Permission::get();
       foreach ($permission as $key => $value) {
           $role->attachPermission($value);
       }
       //3) Create Admin User
       $user = ['name' => 'Super Admin User', 'email' => 'superadminuser@test.com', 'password' => Hash::make('superadmin')];
       $user = User::create($user);
       //4) Set User Role
       $user->attachRole($role);
    }
}

While I'm using below command for db seed i get an error saying Call to undefined method Illuminate\Database\Query\Builder::attachPermission(). I know this is common question in the forum but i don't know what's wrong in my code.

php artisan db:seed --class=DatabaseSeeder

from Newest questions tagged laravel-5 - Stack Overflow http://ift.tt/2zQhEky
via IFTTT

Make active class for parent and subs in Laravel

I have menu like this:

<li class="treeview">
        <a href="#"><i class="fa fa-comment"></i> <span>Comments</span>
            <span class="pull-right-container">
                <i class="fa fa-angle-left pull-right"></i>
            </span>
        </a>
        <ul class="treeview-menu">
            <li><a href="http://ift.tt/2Agdbqz">All Comments</a></li>
            <li><a href="http://ift.tt/2AkbDti">My Comments</a></li>
            <li><a href="http://ift.tt/2Ae7skW">Approved</a></li>
            <li><a href="http://ift.tt/2AkbF4o">Disapproved</a></li>
        </ul>
    </li>

All i want is when i click on submenu for example "My comments" menu, the Comments menu and My Comments active will have a class like this

    <li class="active"><a href="#"><i class="fa fa-comment"></i> <span>Comments</span></a></li>
    <li class="active active-sub"><a href="http://ift.tt/2AkbDti">My Comments</a></li>

so how can i make this can be happen? Thanks

from Newest questions tagged laravel-5 - Stack Overflow http://ift.tt/2AgUUJB
via IFTTT

Implementing Smart Search with Laravel and Typeahead.js

im trying to implement a Smart Search with Laravel and Typeahead.js i tryed this code but sadly it didn't work for me and i spent the day trying to solve this problem with no result please help to get it solved

here is my java script code

<script type="text/javascript">
                jQuery(document).ready(function($) {
                  // Set the Options for "Bloodhound" suggestion engine
                  var engine = new Bloodhound({
                    remote: {
                      url: '/find?q=%QUERY%',
                      wildcard: '%QUERY%'
                    },
                    datumTokenizer: Bloodhound.tokenizers.whitespace('q'),
                    queryTokenizer: Bloodhound.tokenizers.whitespace
                  });

                  $(".search-input").typeahead({
                    hint: true,
                    highlight: true,
                    minLength: 1
                  }, {
                    source: engine.ttAdapter(),

                      // This will be appended to "tt-dataset-" to form the class name of the suggestion menu.
                      name: 'usersList',

                      // the key from the array we want to display (name,id,email,etc...)
                      templates: {
                        empty: [
                        '<div class="list-group search-results-dropdown"><div class="list-group-item">Nothing found.</div></div>'
                        ],
                        header: [
                        '<div class="list-group search-results-dropdown">'
                        ],
                        suggestion: function (data) {
                          return '<a href="' + data.profile.name + '" class="list-group-item">' + data.profile.name + '- @' + data.profile.name + '</a>'
                        }
                      }
                    });
                });
         </script>

here is my form / blade.php

 <form class="typeahead" role="search" >
                    <div class="form-group">
                      <input type="search" name="q" class="form-control search-input" placeholder="Search" autocomplete="off">
                    </div>
                  </form>

here is my model

<?php

namespace App;

use Nicolaslopezj\Searchable\SearchableTrait;
use Illuminate\Database\Eloquent\Model;
use App\suggModel;

class SearchModel extends Model
{
     use SearchableTrait;

      protected $searchable = [
         'columns' => [
            'users.name '=> 9, 
            'users.email'=> 10, 
            'users.Phone'=> 8,
            'users.type_user'=> 7,
            'users.region'=> 6,
            'users.city'=> 10,
            'users.AOS'=> 10,
                 ]
        ];

        public function profile()
        {
          return $this->hasOne(suggModel::class);
        }
}

here is my controller

<?php

namespace App\Http\Controllers;

use Illuminate\Http\Request;
use App\suggModel;


class SearchController extends Controller
{
                public function find(Request $request)
                {
                        return suggModel::search($request->get('q'))->get();
                }
}

and here is my rout

Route::get('find', 'SearchController@find');

from Newest questions tagged laravel-5 - Stack Overflow http://ift.tt/2jwv2zj
via IFTTT

search box using GET method

I have a small practice project in Laravel 5.5 I would like to implement a search filter but I do not understand how to apply it. I would like a help. Thank you

from Newest questions tagged laravel-5 - Stack Overflow http://ift.tt/2AHY9KS
via IFTTT

How to filter results in Laravel using Eloquent Models

I am attempting to use the following

$orders = \App\Order::with([
    'Customer' => function ($query) use ($filterFirst, $filterLast, $filterstate)
    {
        if($filterFirst)
        {
            $query->where('customers.first', 'LIKE', "{$filterFirst}%");
        }
        if($filterLast)
        {
            $query->where('customers.last', 'LIKE', "{$filterLast}%");
        }
        if ($filterstate)
        {
            $query->where('customers.state', '=', $filterstate);
        }
    }

However, when I run ->get on $orders I get the entire table of orders, and I just want to get the orders that match the Customer Filters...

Any ideas on how I can accomplish this?

from Newest questions tagged laravel-5 - Stack Overflow http://ift.tt/2AkJzbZ
via IFTTT

Inject Route Action on Controller

I've made a role middleware to check if user has a specific Role:

namespace App\Http\Middleware;

use Closure;

class CheckRole
{
    /**
     * Handle an incoming request.
     *
     * @param  \Illuminate\Http\Request  $request
     * @param  \Closure  $next
     * @return mixed
     */
    public function handle($request, Closure $next)
    {
        if ($request->user() === null) {
            return response("Insufficient permissions", 401);
        }
        $actions = $request->route()->getAction();
        $roles = isset($actions['roles']) ? $actions['roles'] : null;
        if ($request->user()->hasAnyRole($roles) || !$roles) {
            return $next($request);
        }
        return response("Insufficient permissions", 401);
    }
}

If I want to check for some role in a specific role it's easy. I only have to add the middleware and an additional action called roles. E. g.:

Route::get('payments/{id}/pay', [
    'uses' => 'PaymentController@aprove',
    'as' => 'payments.aprove',
    'middleware' => 'roles',
    'roles' => [User::ADMINISTRATOR, User::SPOT_MANAGER, User::SELECTION_PROCESS_MANAGER],
]);

Doing this way works as expected. However, I have some routes that are Route::resource instead of get, post, or something like this. Laravel don't allow for specifying roles => [...] in resource.

The documentation says that if I want to inject middleware on resources I should do this on controller. But I can't specify roles => [...] as I used to do in normal routes anywhere! How could I do this?

Thanks in advance.

from Newest questions tagged laravel-5 - Stack Overflow http://ift.tt/2i1BCxe
via IFTTT

How to count checkboxes using jQuery?

I'm doing a dashboard in Laravel 5.4, and I have a table with several checkboxes. I need to count each time 1 is selected and show the result on the side.

Basically I have to count in real time. And I have 2 lines, I have to count them separately, so I have separate classes

I've tried some things but nothing works.

Thanks in advance for help and ideas on how I can do this, below I leave the code of my checkbox.

{!! Form::checkbox('dente[]', $dente->id, null, ['class'=>'denteCheck-up'] ) !!}

{!! Form::checkbox('dente[]', $dente->id, null, ['class'=>'denteCheck-down'] ) !!}

In jquery, I've tried +/- this

$('.denteCheck-up').change(function(){ });

$('.denteCheck-down').change(function(){ });

I'm trying to get the result to appear here

<td id="count_dentes_up"></td>

<td id="count_dentes_down"></td>

from Newest questions tagged laravel-5 - Stack Overflow http://ift.tt/2AnDpYk
via IFTTT

In Laravel Eloquent create method I am not able to save the data in database

I have Three models:

• Language
• Article
• Category

The Article table has two foreign keys category_id and Language_id. Language-Model has "One to Many" Relationship with Article-Model, Similarly Category-Model has "One to Many" Relationship with Article-Model.

My Category model:

class Category extends Model
            { 

            protected $fillable = [
                 'category_name', 
            ];

            public function articles(){

                return $this->hasMany('App\Article');
             }
           }

My Language model:

class Language extends Model
    {
         protected $fillable = [
            'language_name'
        ];

         public function articles(){

            return $this->hasMany('App\Article');
        }

    }

My Article model:

class Article extends Model
{
 protected $fillable = [

   'language_id','category_id','category_name','article_title',
   'article_desc','source_from','source_url','video_link',
   'audio_url','author_name','article_image_url','like_count'
    ];

    public function languages(){

        return $this->belongsTo('App\Language');
    }

    public function categories(){

        return $this->belongsTo('App\Category');
    }

}

How can I insert in the database using Laravel Eloquent?

 $Article = new Article (
                 [
                   'article_image_url' => $img_url ,
                   'audio_url' => $audio_url,
                   'category_name'=>$category_name ,
                   'article_title'=>$request->article_title,
                   'article_desc'=>$request->article_desc,
                   'source_from'=>$request->source_from,
                    'source_url'=>$request->source_url,
                    'video_link'=>$request->video_link,
                    'author_name'=>$request->author_name,
                    'like_count'=>'0',

                  ]
            );

            $language = new Language;
            $category = new Category;
            $language->articles()->save($Article);

language_id doesn't have a default value; it is foreign key.

from Newest questions tagged laravel-5 - Stack Overflow http://ift.tt/2ilr5kk
via IFTTT

Laravel: How to use `Can` middleware

I want to give users that are logged in and are of a specific type (leader) access to all pages handled by a controller.

In AuthServiceProvider I created the following Gate

Gate::define('isLeader', function ($user) {
  return $user->isLeader();
});

Inside the controller that is only for logged in leaders, I have the following constructor

public function __construct()
{
    $this->middleware('auth');
    $this->middleware('can:isLeader');
}

For users who are a leader this works. But for users who are not a leader I get the error message This action is unauthorized. when accessing a page through this controller:

Instead of throwing an error message I would rather redirect the user to home if he is not a leader. How can I achive this?

from Newest questions tagged laravel-5 - Stack Overflow http://ift.tt/2j3aQpv
via IFTTT

how to save data to pivot table in laravel 5.5?

I have 4 tables:

advertises
id, title, description, thumbnail, category_id, subcategory_id
categories
id, name
subcategories
id, name, category_id
category_subcategory
cateogory_id
subcategory_id

I want to create and save an advertise with its category and subcategory, for example: advertise title: buy a phone with javascript i display a category which is in this case electronics, and the category electronics has subcategories: buy, sell. the user selects the buy subcategory so the advertise will be like this: buy a phone->electronics->buy. now i save the category_id and the subcategory_id in the advertise table, but there are many categories that have the subcategories buy and sell. the subcategory table row looks like:

id, name, category_id
1, buy, 1
2, sell, 1

how to save the data in the database? and how to retrieve the the advertise?

I made an image gallery for each advertise, I made a function that uploads an image to an advertise like a thumbnail, and another function that uploads the other images when you access the edit route, but i want the user to be able to upload more photos when he creates the advertise not after the advertise is created. the images are saved in a separated table:

images
id, name, advertise_id

how to save the images when the user creates the advertise?

this is the advertise model:

<?php

namespace App;

use Illuminate\Database\Eloquent\Model;

class Advertise extends Model
{
    protected $fillable = ['title', 'description', 'image', 'price'];

    public function user()
    {
        return $this->belongsTo('App\User');
    }

    public function category()
    {
        return $this->belongsToMany('App\Category_Subcategory');
    }

    public function subcategory()
    {
        return $this->belongsTo('App\SubCategory');
    }

    public function location()
    {
        return $this->belongsTo('App\Location');
    }

    public function image()
    {
        return $this->hasMany('App\Image');
    }
}

from Newest questions tagged laravel-5 - Stack Overflow http://ift.tt/2Bm19cq
via IFTTT

get only one row from first table in table left join in laravel

I have two table 1. Bog_post 2. blog_image

Now I want only one image from blog_image table. I also save blog id in blog_image table. how can i do this query in laravel ?

from Newest questions tagged laravel-5 - Stack Overflow http://ift.tt/2i0Btdt
via IFTTT

Laravel: Product Update/ Method update does not exist

Trying to update my Auth:user() Product with update method, but always results in Error. User has many products() / Product belongsTo user().

$this->validate($request, [

            'title'=> 'max:140',
            'brand'=> 'max:140',
            'sku'=> 'max:140',
            'description'=> 'max:140',
            'price'=> 'max:140',
            'availability'=> 'max:140',

        ]);

        $product = auth()->user()->products()->findOrFail($id);

        $product->update([

            'title' => $request->input('title'),
            'brand' => $request->input('brand'),
            'sku' => $request->input('sku'),
            'description' => $request->input('description'),
            'price' => $request->input('price'),
            'availability' => $request->input('availability'),

        ]);

Am I missing something within my Controller? Btw.

Auth::user()->products()->update([
            'title' => $request->input('title'),
            'brand' => $request->input('brand'),
            'sku' => $request->input('sku'),
            'description' => $request->input('description'),
            'price' => $request->input('price'),
            'availability' => $request->input('availability'),
]);

updated every User related product to the same values.

So the problem is within the Product specification.

Any suggestions? Thank you

from Newest questions tagged laravel-5 - Stack Overflow http://ift.tt/2BxgXtG
via IFTTT

Laravel connect to Cloud Database no works

my problem is i have laravel APP on my Local Enviroment and i m trying to connect to Cloud based mysql server

Laravel 5.5

i changed my .env file

example :

DB_HOST=46.229.230.***
DB_PORT=3306
DB_DATABASE=name
DB_USERNAME=nameuser
DB_PASSWORD=passuser

but i getting this error and idk why it trying to loggin to 158..... server is restarted database 100% working connect with mysqli works perfect

SQLSTATE[HY000] [1045] Access denied for user 'nameuser'@'158.193.105.***' 

any help ?

from Newest questions tagged laravel-5 - Stack Overflow http://ift.tt/2AiFPaO
via IFTTT

Laravel PHP : How to get Specific Column ID when we apply joins on 3 tables?

I want to get the Rating table ID , but in my jason then will give me the attributes table id when we apply this joins, MY QUERY:

$search = \Request::get('q');
    $u_id = User::find($id);

        $records = DB::table('ratings')->where('user_id' , $id)-
 >where('user_id' , $id)->where(function($q) use ($search){
             $q->where('attribute' , 'like' , '%' .$search. '%');
             $q->orwhere('score' , 'like' , '%' .$search. '%');
             $q->orwhere('attrtype' , 'like' , '%' .$search. '%');
        })
        ->join('users','ratings.user_id','=','users.id')->join('attributes' 
, 'attributes.id' , '=' ,'ratings.attribute_id' )->Paginate(5);
dd($records); 
return view('employee.show',compact('records' , 'u_id' , 'search')); 

After this we Get the ID of Attribute table ,

But we get the Rating tables ID , Thanks Developers in advance.

from Newest questions tagged laravel-5 - Stack Overflow http://ift.tt/2ikAKYC
via IFTTT

laravel collection is 'broken' (strange dots)

I faced this problem before, but couldn't find out the reason. I use laravel 5.5 and php7.0 . I'm fetching data from excel file(about 400 lines) with this excel package(it takes a little bit long to execute the string). the problem is, when I got the collection of data, its kinda 'broken'. what does this mean? I'm sure its not about the package, I had similar problem before when I was making API request, it seems like this problem happens only with big amount of data. can someone explain why this happens and how should fix it? here's my file fetching method

public function index()
{
    \Excel::load('uploads/data.xlsx', function($reader) {
        $results = $reader->all();

        dd($results->all());
    });
}

from Newest questions tagged laravel-5 - Stack Overflow http://ift.tt/2k85oVB
via IFTTT

Laravel Model->get returns 502 Bad Gateway

I am running Laravel 5.x with valet on OS X...

When I execute the following query, I get the response I am looking for...

$orders = \App\Order::with([
    'Customer' => function ($query) use ($filterFirst, $filterLast)
    {
        if($filterFirst) {
            $query->where('customers.first', 'LIKE', "{$filterFirst}%");
        }
        if($filterLast) {
            $query->where('customers.last', 'LIKE', "{$filterLast}%");
        }
        return $query;
    }
]);

However, When I execute this next query, I get a 502 Bad Gateway...

$orders = \App\Order::with([
    'Customer' => function ($query) use ($filterFirst, $filterLast)
    {
        if($filterFirst) {
            $query->where('customers.first', 'LIKE', "{$filterFirst}%");
        }
        if($filterLast) {
            $query->where('customers.last', 'LIKE', "{$filterLast}%");
        }
        return $query;
    },
    'Group' => function ($query) use ($filtercategory)
    {
        if($filtercategory) {
            $query->where('order_groups.groupid', '=', $filtercategory);
        }
        return $query;
    }
]);

Any ideas on how I can further troubleshoot this issue or why it may be happening?

from Newest questions tagged laravel-5 - Stack Overflow http://ift.tt/2BxFsXu
via IFTTT

How to Protect API routs : Laravel 5.4?

How to make API routes only accessible inside the app?

For example http://ift.tt/2zBpFG3 returns the data as intended but it's really insecure since anyone could access it through postman or the browser.

from Newest questions tagged laravel-5 - Stack Overflow http://ift.tt/2AjKJlC
via IFTTT

How to use where with Laravel Eloquent Model

I am attempting to

 $orders = \App\Order::with(['Customer'])->where('customers.first', 'LIKE', "{$filterFirst}%");

However, I am getting

 Column not found: 1054 Unknown column 'customers.first' in 'where clause' (SQL: select * from `orders` where `customers`.`first` LIKE %)

How can I use where as well as with?

from Newest questions tagged laravel-5 - Stack Overflow http://ift.tt/2AkIAIu
via IFTTT

Require Laravel query explanation.

Can anyone explain me what does IF(transactions.retail_cost > 0,1,0) means from the below query ?

       $query = Distributors::selectRaw("distributors.name,distributors.group_id,distributors.pay,SUM(IF(transactions.retail_cost > 0,1,0)) AS trans_number"); 

from Newest questions tagged laravel-5 - Stack Overflow http://ift.tt/2AIb9k3
via IFTTT

Update row with data from another row in the same table in Laravel

I am trying to update one line with another in my database. I can not find a way to do this.

I have a parent line and a child line. I want to update the PARENT activity with the CHILD activity (draft).

In my controller :

public function update(UpdateRequest $request)
  {
    if (Auth::user()->hasRole('Administrateur'))
    {
        // DRAFT ACTIVITY
        $id = $request->id;
        $activity  = Activity::find($id);

        // PARENT ACTIVITY
        $parent_id = $activity->parent_id;
        $parent_activity = Activity::find($parent_id);

        DB::table('activities')->???

      }
  }

Can you help me ? Thank you very much !

from Newest questions tagged laravel-5 - Stack Overflow http://ift.tt/2ig9MkN
via IFTTT

BaseController for all controllers

I have many controllers which get CRUD functions. Some of this functions is copy-paste.

I want to create BaseController which has base functions.

But how identify entity?

I have routes:

    Route::group(['namespace' => 'Posts', 'prefix' => 'posts'], function () {
    Route::get('/', 'PostController@index');
});

and function:

public function index()
{
    return Post::filter(Request::input())->paginate()->appends(Request::input());
}

How i can determinate entity Post?

from Newest questions tagged laravel-5 - Stack Overflow http://ift.tt/2ndRd2d
via IFTTT

why will laravel say all of a sudden Cannot end a section without first starting one in laravel 5.1

@section("page_title", "Home Page")@stop @section("body_class", "page-homepage navigation-fixed-top page-slider")@stop

The above code works just fine for as long as I can remember then yesterday, I ran composer install then aborted in the middle of it.

Afterwards, I started getting the error Cannot end a section without first starting one. I realized the @stop must be removed. I removed it, and everything is fine now, however, I will like to know why @stop suddenly started giving problems.

The version of laravel I was using when @stop started giving problems is Laravel Framework version 5.1.23 (LTS) and the current version which is giving problems with @stop is Laravel Framework version 5.1.46 (LTS)

from Newest questions tagged laravel-5 - Stack Overflow http://ift.tt/2Af15xD
via IFTTT

Put to the next column if condition reached in HTML

I'm currently using bootstrap with laravel5.1. What I have now is a list of items and I want to add column and put the other items there if the list of items reached 4 rows. Please see my code below for reference:

@foreach($keys = [1, 2, 3, 4] as $key)
        @if($key == 1)
            <div style="background: #118C8B; padding: 20px 0;">
        @elseif($key == 2)
            <div style="background: #BCA18D; padding: 20px 0;">
        @elseif($key == 3)
            <div style="background: #F2746B; padding: 20px 0;">
        @elseif($key == 4)
            <div style="background: #F14D49; padding: 20px 0;">
        @endif  
            <div class="container">
                <div class="row">
                    <div class="col-md-3 col-sm-3">
                        <img class="center-block" src="" alt="">
                    </div>
                    <div class="col-md-9 col-sm-9">
                       @foreach($items as $item)
                         
                       @endforeach
                    </div>
                 </div> 
            </div>
@endforeach

from Newest questions tagged laravel-5 - Stack Overflow http://ift.tt/2ngixgw
via IFTTT

Update a value in a destroy method in Laravel

I make a clone system in Laravel. I want to clone activities.

When I click on "Clone", my line is cloned and receives as the value in the column "parent_id" the ID of the original.

The original gets a value of 1 in the "hasClone" column.

But when I want to delete a clone, in my destroy method, I try to set hasClone (the original entry) to NULL before deleting the clone.

Here is my code :

  public function destroyChanges(Activity $activity)
  {

    $parentActivity = Activity::findOrFail($activity->parent_id)->first();
    $parentActivity->hasClone = NULL;
    $parentActivity->save();

    $activity->delete();

    return redirect()->to('/admin/activity/');
  }

Here is my route :

Route::delete('activity/destroyChanges/{id}', ['as' => 'cancel.activity', 'uses' => 'ActivityCrudController@destroyChanges']);

The entry of the clone is deleted correctly. But he does not update the original entry. How to do ? thank you very much

from Newest questions tagged laravel-5 - Stack Overflow http://ift.tt/2k9vUOc
via IFTTT

How to solve permission denied error for phantom js in ubuntu?

I am working on a laravel project where I am trying to use php wrapper of phantom js made by jonnyw. I have done everything written in the docs.

I have downloaded the 32 bit executable file and set the path in my code, but it still gives me the following error: sh: 1: /usr/local/bin/: Permission denied

My code looks like this

$client = PhantomJs::getInstance();
$client->getEngine()->setPath('/usr/local/bin/');

I have read some related issues already.

I am using laravel 5.4 and 4.0 version of jonnnnyw/php-phantomjs.

from Newest questions tagged laravel-5 - Stack Overflow http://ift.tt/2Al1VHo
via IFTTT

Laravel - Session always expired when redirect to other pages

I having an issues, which is user after login, session will randomly expired when from route to another route.

from Newest questions tagged laravel-5 - Stack Overflow http://ift.tt/2zOE1XG
via IFTTT

Laravel login, check if username and pwd are a match in my database

In my login form all I need is just username and a password ,trying to use ajax to get data from sqlite .

.AJAX of my login.blade.php

$(document).ready(function(){

  $("#login").click(function(){
    $.ajax({
      type: "GET",
      url: "UserController.php",
      data: { username: $("#username").val(), password: $("#password").val()},
      success: function(data){

        response = JSON.parse(data);
        if(response[0]){

        }
        else{
          alert(response[1]);
        }
      }
    });
  });

});

my User.php

<?php

namespace App;

use Illuminate\Database\Eloquent\Model;
use Illuminate\Support\Facades\DB;
use Illuminate\Support\Facades\Validator;

class User extends Model
{
    protected $table = 'user';

    /**
     * The attributes that are mass assignable.
     *
     * @var array
     */
    protected $fillable = [
        'username', 'phone','email', 'password','password_confirmation','librarian'
    ];


}

read method in UserController

//to read data from database to login
    public function read(Request $request){


        $results = DB::select('select * from users where id = :id', ['id' => 1]);

        foreach ($users as $user) {
    echo $user->username;
}

my web.php

Route::get('/login', function () {
    return view('login');
});
Route::get('/signup',function(){
    return view('signup');
});
Route::get('/bookscreate',function(){
return view('bookscreate');
});

Route::get('/','BookController@index');
Route::post('signup', 'UserController@store');
//Route::post('signup', 'UserController@read');

Route::resource('/books','BookController');

So my objective is to go to my database table check username and password if they match one of the DB id then allow user to login .

from Newest questions tagged laravel-5 - Stack Overflow http://ift.tt/2AGJEHg
via IFTTT

Route management issue Laravel 5.5

This is part of my routes/web.php file

if(Request::is('users/*'))
    {
        require __DIR__.'/users.php';
    }

I have a file named users.php under the same folder

Route::get('profile',[
    'middleware' => 'auth',
    'uses' =>'home\HomeController@profile'])->name('userprofile');

I'm trying to access users/profile route. But it is not working. Please help

Thanks in Advance

from Newest questions tagged laravel-5 - Stack Overflow http://ift.tt/2AhNuGs
via IFTTT

Can Laravel 5 handle 1000 concurrent users without lagging badly?

I wanted to know that if 1000 users are concurrently using a website built with laravel 5 and also quering database regularly then how does laravel 5 perform ? I know it would be slow but will it be highly slow that it would be unbearable ? Note that i am also going to use ajax a lot.

Please also provide some some tools through which i can check the speed of my laravel 5 application as well as how it will perform when there is actual load as well as other tools through which i can test speed and performance.

And it would be great if someone has real experience of using laravel especially Laravel 5.

And what about Lumen does that really make application faster than laravel and how much ?

from Newest questions tagged laravel-5 - Stack Overflow http://ift.tt/2k7odIv
via IFTTT

How can I solve ErrorExceptionIlluminate\Notifications\SendQueuedNotifications on laravel?

If I executed my notification on production server, there exist error like this :

ErrorExceptionIlluminate\Notifications\SendQueuedNotifications preg_split() expects parameter 2 to be string, array given

I check the error using https://app.bugsnag.com

The full error like this :

On my localhost and my staging server it's no error

It's just error in production server

My notification like this :

<?php
namespace App\Notifications;
use Illuminate\Bus\Queueable;
use Illuminate\Contracts\Broadcasting\ShouldBroadcast;
use Illuminate\Notifications\Notification;
use Illuminate\Contracts\Queue\ShouldQueue;
use Illuminate\Notifications\Messages\MailMessage;
class CheckoutOrder extends Notification implements ShouldQueue, ShouldBroadcast
{
    use Queueable;
    private $data;
    public function __construct($data)
    {
        $this->data = $data;
    }
    public function via($notifiable)
    {
        return ['mail','database','broadcast'];
    }
    public function toMail($notifiable)
    {
        return (new MailMessage)
                    ->subject('test subject')
                    ->view('vendor.notifications.mail.email-checkout-order',['data'=>$this->data, 'name' => $notifiable->name]);
    }
    public function toArray($notifiable)
    {
        return [
            'id'            => $this->data['invoice']->id,
            'time'          => $this->data['invoice']->created_at,
            'group'         => 'purchase',
        ];
    }
}

My env like this :

APP_ENV=production
APP_KEY=secretkey
APP_DEBUG=false
APP_LOG_LEVEL=debug
APP_URL=https://secretapp.co.id

DB_CONNECTION=mysql
DB_HOST=secret
DB_HOST_MONGO=localhost
DB_PORT=3306
DB_DATABASE=secretdb
DB_USERNAME=secretusername
DB_PASSWORD=secretpassword

BROADCAST_DRIVER=pusher
CACHE_DRIVER=redis
SESSION_DRIVER=redis
QUEUE_DRIVER=redis

REDIS_HOST=127.0.0.1
REDIS_PASSWORD=null
REDIS_PORT=6379

MAIL_DRIVER=smtp
MAIL_HOST=smtp.gmail.com
MAIL_PORT=587
MAIL_USERNAME=secret@gmail.com
MAIL_PASSWORD=secret
MAIL_ENCRYPTION=tls

How can I solve this problem?

from Newest questions tagged laravel-5 - Stack Overflow http://ift.tt/2zNlr1Y
via IFTTT

Laravel Custom Validation Method

I'm trying to develop a PHP game with Laravel, and so far a user - with enough gold and not part of a guild - can create a guild using a simple form with one text field. The issue is that currently I'm using Laravel's dd() function in order to show that they failed to have the gold or were already in a guild.

As such, I went looking for a way to give it a more baked-in feel by seeing if I could put this behavior into a custom rule/validator, but I'm unsure as to how to go about this. Examples would be preferred... here's my current function.

public function store(Request $request)
{
    $request->validate([
        'name' => 'required|min:4|alpha_dash|unique:guilds'
    ]);

    $char  = Auth::user()->character;
    $cost  = config('game.create-guild-cost');
    $guild = new Guild;

    if($char->gold < $cost) {
        dd('Not enough money');
    }

    if($char->guild != null) {
        dd('You cannot already be in a guild.');
    }

    $guild->name = request('name');
    $guild->leader_id = $char->id;
    $guild->save();

    $char->gold = $char->gold - $cost;
    $char->guild_id = $guild->id;
    $char->save();

    return redirect()->route('guilds.show', ['guild' => $guild]);
}

from Newest questions tagged laravel-5 - Stack Overflow http://ift.tt/2jvZXM7
via IFTTT

How to use session in custom facade in Laravel 5.5

I am new to Laravel and working on version 5.5. For my knowledge, I have created custom facade and now I am trying to set some session values into this facade as well as try to get the value of set session.

But Laravel is not able to set session in this custom facade. If I do the same thing in controller then it is working fine.

Below are my possible way that I have tried:

public function setUserSession() {  
   //Ist way
   session()->put('user', 'some values');
   var_dump(session()->has('user')); // this is returning me false  

   //2nd way  
   request()->session()->put('user', 'some values');  
   var_dump(request()->session()->has('user')); // this is returning me false 

   Session::set('user', 'some values');  //this is giving me error
   /* for above line I have include below namespace:  
      1.Illuminate\Support\Facades\Session  
   */  
   var_dump(Session::get('user')); // this is returning me false 
}  

Even I have tried the solutions of below link:

How to use session in custom class laravel 5?

But nothing change. Please anyone share your solution for this issue?

Thanks in Advance.

from Newest questions tagged laravel-5 - Stack Overflow http://ift.tt/2Af9lhE
via IFTTT

Laravel - Passing a Count from a Relationship on a "Simple" Page

I was curious if it was possible to pass along a count of a relationship from a controller and put it on a simple page like a home page (which isn't specifically related to any specific model or controller). So say a user hasMany shipments, how can I pass along the count to the page?

I know how to pass along variables to model specific pages (such as show, edit, index and such pages), but not a general pages such as a home page or about page. I'm sorry if I am a bit oblivious on this topic, but I'm not sure where at all to go about with this.

Thanks! Matt

from Newest questions tagged laravel-5 - Stack Overflow http://ift.tt/2ih39yP
via IFTTT

Laravel: Is using download dynamic file a security risk?

I want to offer users in the userarea to download all files from the storage/app/downloads/ folder. I thought about doing it like this in the route file:

Route::get('/home/downloads/{file}', 'Home\DownloadController@show');

and in the controller:

public function show($filename)
{
  $path = storage_path('app/downloads/' . $filename);

  if(!\File::exists($path)){
    return back();
  }

  return response()->download($path);
}

Now I could create a download link for example like this:

<a href="/home/downloads/logo.jpg">Download Logo</a>

I am just not sure if this is a safe way of doing it. Is it possible for users to download files outside the download folder? At least sneaky urls like

/home/downloads/../User.php 

would not be recognizes in route/web.php. But I am not sure if I am overseeing some other possible danger.

from Newest questions tagged laravel-5 - Stack Overflow http://ift.tt/CsFNvy
via IFTTT

Laravel Breadcrumbs for Laravel 5.4

I want to install http://ift.tt/1twBDqx on Laravel 5.4.

The link above is for Laravel 5.5. (package version 4.x)

So I go to http://ift.tt/2BvibWb for package version 3.x but I can see that it recommends to install package the same way as it's installed for L 5.5. via:

composer require davejamesmiller/laravel-breadcrumbs

when I run this, I got a mistake:

Anybody can help me on how to install it's version 3.x?

Thanks in advance!

UPD: I see the package's author also created a separate for for 3.x version here: http://ift.tt/2BvJUpS but I still don't understand how to install it for Laravel 5.4....

from Newest questions tagged laravel-5 - Stack Overflow http://ift.tt/2AeaLbG
via IFTTT

Send PUT from pure Javascript to Laravel controller

i try to send data via PUT method, but Laravel 5.5 do not see any data inside Input (or Request) on destination controller.

Here JS:

    function selectProject(option){

        console.log('Update selected');

        var data = new Object();
        data.project_id = option.value;
        data.user_id =;
        console.log(data);

        var url = "/admin/projects";
        var xhr = new XMLHttpRequest();

        xhr.open("PUT", url+'/update_selected', true);
        xhr.setRequestHeader("X-CSRF-TOKEN", "");
        xhr.onload = function () {
                var response = xhr.responseText;
                if (xhr.readyState == 4 && xhr.status == "200") {
                        console.log(response);
                        document.getElementById("app").innerHTML = response; 
                } else {
                        console.log(response);
                        document.getElementById("app").innerHTML = response; 
                }
        }
        xhr.send(data);
    }

inside Laravel controller i try to showing inputs:

    echo '[Controller]Inputs:';
    return Input::all();

Here output from console.log:

Update selected
{…}
 project_id: "4"
 user_id: 1
 __proto__: Object { … }
[Controller]Inputs:[]

Question: what i'am doing wrong and where is inputs data? p.s. I can use only pure javascript, no jQuery or anothers.

from Newest questions tagged laravel-5 - Stack Overflow http://ift.tt/2BxRsID
via IFTTT

Laravel blade + vue render ajax data couple?

i want to write ajax rendering news using blade + vue.

<div id="news">
    <div class="l_news">
        <div class="post" v-for="post in posts">
            <div class="image" style="background: url() no-repeat center / cover">
                <div class="title">@</div>
            </div>
            <div class="desc">@</div>
        </div>
    </div>
</div>

I have some problem with rendering post image.

But i can't use

url(') }})

How to write correctly?

Thanks in advance!

from Newest questions tagged laravel-5 - Stack Overflow http://ift.tt/2ncxlwH
via IFTTT

laravel config file retun null in config folder

I have a config file called fcm.php in config folder in laravel. The file looks like this:

<?php
return [
    'driver' => env('FCM_PROTOCOL', 'http'),
    'log_enabled' => true,

    'http' => [
        'server_key' => config('app.fcm_mode') == 'user' ? env('FCM_SERVER_KEY', 'Your FCM server key') : env('FCM_DELIVERY_SERVER_KEY', 'Your FCM server key'),
        'sender_id' => config('app.fcm_mode') == 'user' ? env('FCM_SENDER_ID', 'Your sender id') : env('FCM_DELIVERY_SENDER_ID', 'Your sender id'),
        'server_send_url' => 'http://ift.tt/1TmHkUo',
        'server_group_url' => 'http://ift.tt/1mkLeNy',
        'timeout' => 30.0, // in second
    ],
];

It works properly in my localhost(I vendor:publish fcm.php config file), But in a shared host, config('app') return null in this file(config/fcm.php)

What is the problem? Thanks

from Newest questions tagged laravel-5 - Stack Overflow http://ift.tt/2AenEmf
via IFTTT

Filter data in form request in Laravel 5.5

I have generated new form Request for the controller, but I do not know how to filter data before there will handle in the validator and so on.

Are there some native solutions in Laravel for this case?

class TestRequest extends FormRequest
{

  /**
   * Determine if the user is authorized to make this request.
   *
   * @return bool
   */
  public function authorize()
  {
      return true;
  }

  /**
   * Get the validation rules that apply to the request.
   *
   * @return array
   */
  public function rules()
  { 


    return [
       "title" => "required|string",
       "order" => "required|integer"
    ];
  }

}

class TestController extends Controller
{ 
     public function store(TestRequest $request, $chapterId)
     {
       // some business logic
     }
}

There is some solution in Laravel 5.5 but in this example author uses validate for filtering data from request, but I need to use filter inside TestRequest

 $data = $this->validate(request(), [
         //...
    ]); // I can't use this inside TestRequest

from Newest questions tagged laravel-5 - Stack Overflow http://ift.tt/2zM0rcb
via IFTTT

Try upload videofile

I use Laravel 5.4 and I try upload video file. Image file upload successfully.

$video = Request::file('video_file')) {
        $fullName = 'videos/'.uniqid().time().'.'.$video->getClientOriginalExtension();
        Storage::disk()->put($fullName, $video);

But it didn't work. When I try get information about file - size = 0

What I do wrong?

from Newest questions tagged laravel-5 - Stack Overflow http://ift.tt/2ncNQZw
via IFTTT

Method not allowed in Laravel. Why in this case?

I would like to know why I have a "Not Allowed" method in this case. I'm trying to set a value to NULL (I have an hasClone column) when I delete an entry that I duplicated.

My controller :

public function destroyChanges($id)
  {
    $activity = Activity::findOrFail($id);
    $activity->delete();

    return redirect()->to('/admin/activity/setCloneNull/' . $activity->parent_id);
  }

public function setCloneNull($id, Activity $activity)
{
  $activity = $activity->where('id', '=', $id)->first();
  $activity->hasClone = NULL;
  $activity->save();
  return redirect(url('/admin/activity/'));
}

Routes :

  Route::delete('activity/destroyChanges/{id}', ['as' => 'cancel.activity', 'uses' => 'ActivityCrudController@destroyChanges']);
  Route::post('activity/setCloneNull/{id}', ['as' => 'setCloneNull.activity', 'uses' => 'ActivityCrudController@setCloneNull']);

How to make it work? thank you !

from Newest questions tagged laravel-5 - Stack Overflow http://ift.tt/2naukgo
via IFTTT

Why send email use mail laravel does not work if it use shouldqueue?

My mail laravel like this :

<?php
namespace App\Mail;
use Illuminate\Bus\Queueable;
use Illuminate\Mail\Mailable;
use Illuminate\Queue\SerializesModels;
use Illuminate\Contracts\Queue\ShouldQueue;
class OrderReceivedMail extends Mailable implements ShouldQueue
{
    use Queueable, SerializesModels;
    public $order;
    public $store;
    public function __construct($order, $store)
    {
        $this->order = $order;
        $this->store = $store;
        $this->subject('subject');
    }
    public function build()
    {
        $company_email = explode(',',config('app.mail_company'));
        return $this->view('vendor.notifications.mail.email-order-received',['number'=>$this->order->number, 'store_name' => $this->store->name])->bcc($company_email);
    }
}

My env like this :

BROADCAST_DRIVER=pusher
CACHE_DRIVER=redis
SESSION_DRIVER=file
QUEUE_DRIVER=redis

REDIS_HOST=127.0.0.1
REDIS_PASSWORD=null
REDIS_PORT=6379

If the code executed, it does not works. The email failed sended or the mail code not executed

But if I remove implements ShouldQueue, it works. The email success sended

Why if I use shouldqueue it does not works?

from Newest questions tagged laravel-5 - Stack Overflow http://ift.tt/2Ac4D3L
via IFTTT

Laravel How to skip elements if query is null in foreach loops?

I want to show latest posts in each category. If all category is not null, its OK, But if there are empty categories Trying to get property of non-object error. (I mean if category dosen't have any post)

So how can I pass thos categories post, when query returns null ?

Controller;

$categories=Category::with('posts')->latest()->get();
return view('frontend.home',compact('categories');

Blade;

@foreach($categories as $category)

<div class="col-md-3">
  <div class="card text-white">
    <a href="#"> <img class="card-img"
       src=""  alt="Card image">                                             

      <div class="card-img-overlay">
      <h4 class="card-title"></h4>
      </div>
    </a>
  </div>
</div>

@endforeach

Any advice ?

from Newest questions tagged laravel-5 - Stack Overflow http://ift.tt/2hYSyos
via IFTTT

Laravel AJAX/API request not working on AWS

My Laravel 5.5 app has a very simply AJAX POST to the server that works perfectly locally, but returns a 500 Server Error when deployed to my Elastic Beanstalk instance.

I've narrowed down the issue somewhat, but I'm still stumped.

I'm using a route defined in routes/api.php:

Route::post('availabletimes','TimesController@show');

As I test I have reduced TimesController@show to be simply:

public function show(GetShowTimes $request) {
  return "OK";
}

It couldn't be simpler.

I've checked that the X-CSRF-TOKEN is being sent. I've used Postman to test this, as well as my site, and the result is the same: Locally works fine (returns "OK"), deployed to AWS just returns a 500 Server Error.

I've looked through the server logs, and I can see the error being raised, but there's no other information:

"POST /api/availabletimes HTTP/1.1" 500

How can I debug this?

from Newest questions tagged laravel-5 - Stack Overflow http://ift.tt/2iXOipY
via IFTTT

Laravel return object with nesting

Assume the following models:

class Character extends Model
{
    protected $fillable = ['items'];
    protected $guarded = ['id'];

    public function items(){
        return $this->hasMany("App\Item");
    }
}

class Item extends Model
{

    public function character(){
        return $this->belongsTo("App\Character");
    }

}

When a request is made, the controller performs the following:

public function getCharacter(Request $request, $characterID = 0){

        $characters = array(Character::find($characterID));

        foreach($characters as $key => $value){
            //ADD THE ITEMS
            $characters[$key]->items = $characters[$key]->items;
        }
        return $characters;
    }

------This works fine.
Im getting a character json with a member "items" that holds all the data for the corresponding item models.

However, assume Items didnt belong to Character but to ItemPackage. Specifically, Items belong to ItemPackage ( ItemPackage has many Items ) and ItemPackage belongs to Character ( Character has many ItemPackage(s) )

In a similar fashion, i tried performing the following in the controller but it doesnt work.

....
foreach($characters as $key => $value){
    //ADD THE ITEM
    $characters[$key]->itemPackages = $characters[$key]->itemPackages
    //the above line works but we also need to add the item obj data so:
        foreach($characters[$key]->itemPackages as $key2){
            $characters[$key]->itemPackages[$key]->arrayOfItems = "whatever here";
        }
    }
....

Specifically, i get an error of : Undefined offset: 1. Im clearly not understanding the data structures im operating on very well, maybe someone could illuminate me.

Thanks for taking the time

from Newest questions tagged laravel-5 - Stack Overflow http://ift.tt/2k6wvjY
via IFTTT

CRUD -> Destroy Method

I'm not sure how to make a destroy method yet. Can you guys give me a hand here?

I'm using this form:

@foreach($data as $d)
<tr>
<td> </td>
<form method="POST" action="/newuser/delete/{$d->id}">
<input type="hidden" _method="DELETE">   
<td><button type="submit" class="btn btn-default btn-sm">Excluir</button></i></a></td>
</form>
</tr>

@endforeach 

This Controller:

    public function search(Request $request)
    {
    $users = Users::search($request);
    $users1 = Groups::search($request);
    foreach ($users as $user) {
    $data[] = array('Username' => $user->username,
    'id' => $user->id
    );
    };
    foreach ($users1 as $user1){
    $data1[] = array ('id2' => $user1->id);
    };
    return view('user.buscar', compact('data'));
    }

    public function buscar()
    {
    return view ('user.buscar');
    }

    public function destroy($id)
    {
    try {
    DB::transaction(function() use($id)
    {
    $user = Users::find($id);
    $user1 = Groups::find($id);
    $user->delete();
    $user1->delete();
    });
    return redirect('home')
    ->with('message', 'Usuário removido com sucesso!!');
    }
    catch (\Exception $e) {
    return redirect('home')
    ->with('message', 'Usuário não foi removido, verifique os dados!!');
    }

And using this route Route::delete('newuser/delete/{$d->id}', 'UserController@destroy');

I not sure if what I'm doing is right. Please, Be patient I'm new to this.

from Newest questions tagged laravel-5 - Stack Overflow http://ift.tt/2zwm1NA
via IFTTT