print results in descending order

I need to print results in a decreasing way

controller:

$servicios = \App\Models\Eventos::All()->sortByDesc('hora');

blade.php

  @foreach ($servicios as $hoy)
                                        <tr>
                                            <td class="checkbox-column text-center"> </td>
                                            <td></td>
                                            <td></td>
                                            <td></td>
                                            <td></td>
                                            <td></td>
                                            <td class="text-center"><span class="shadow-none ">
                                            @if($hoy->prioridad == 'badge badge-primary') 
                                          Normal
                                            @elseif($hoy->prioridad == 'badge badge-warning') 
                                           Prioridad
                                             @elseif($hoy->prioridad == 'badge badge-success') 
                                          Personal
                                             @elseif ($hoy->prioridad == 'badge badge-danger') 
                                           Urgente
          

                                            @endif
                                            
                                            </span></td>
                                        
                                        @endforeach

the problem is that it does not print with the foreach with the DESC order

from Newest questions tagged laravel-5 - Stack Overflow https://ift.tt/3AgNcLZ
via IFTTT

I am getting wrong assets url using Laravel helper "secure_asset"

I have a website on domain mydomain.space

I include in my blade file some js file in such way:

<script  type="text/javascript" src="{!! secure_asset('js/app.js') !!}"></script>

But then, on production, I see in browser logs, that frontend try to load file by this URL:

http://mydomainspace/js/app.js

Yeah, for some reason it removes dot and as result - it is wrong URL... But when I display APP_URL variable - it shows "mydomain.space" (with dot).

Why I lose dot in URL when use secure_asset helper?

from Newest questions tagged laravel-5 - Stack Overflow https://ift.tt/3AinDdk
via IFTTT

it doesn't take my password set in a variable

i need help to know why my static password saved in variable does not work

I'm doing is deleting records, but with a password to confirm the action

Controller:

public function eliminar($id) {
    $registros = \App\Models\Registro::find($id);
    if (! $registros) {
        session()->flash('error_message', 'Model not found with the given id:');
        return back();
    }

    // static password
    $password = ('asdf');

    // $password is the password that you have saved somewhere
    if (request()->password_field_value == $password) {
       
        $registros->delete();
        
        session()->flash('success_message', 'Model deleted successfully.');
        return back();
    }

    session()->flash('error_message', 'Invalid password. Try again');
    return redirect('sistema');
}

blade

@extends('layouts.app')
    
@section('content')
    <h1>Do you want to delete the record?</h1>
    <form action="" class="d-inline" method="POST">
        @method('DELETE')
        @csrf
        <button type="submit" class="btn btn-danger btn-sm">DELETE</button>
        <div class="form-group col-md-6">
            <label for="telefono">Password</label>
            <input name="password" type="password" class="form-control" id="password"  required>
        </div>
    </form> 
@endsection

I need to know why it always throws an error, Invalid password. Try again

help please

from Newest questions tagged laravel-5 - Stack Overflow https://ift.tt/3AcLmf7
via IFTTT

How to use another table as the login table instead of 'Users'

I have a project that has 2 tables, 1 for users details and one for login, but I want my login table to be 'webusers' instead of 'users' as Laravel uses 'users' as the default table for authentication.

I tried to change my model and auth.php but to no luck. Has anyone tried this before?

My Model:

    <?php

namespace App\Models;

use Illuminate\Auth\Authenticatable as AuthenticableTrait;
use Illuminate\Database\Eloquent\Model;
use Illuminate\Contracts\Auth\MustVerifyEmail;
use Illuminate\Database\Eloquent\Factories\HasFactory;
use Illuminate\Foundation\Auth\User as Authenticatable;
use Illuminate\Notifications\Notifiable;

class User extends Authenticatable
{
    use HasFactory, Notifiable;
    protected $table = "webusers";
    /**
     * The attributes that are mass assignable.
     *
     * @var array
     */
    protected $fillable = [
        'name',
        'email',
        'password',
    ];

    /**
     * The attributes that should be hidden for arrays.
     *
     * @var array
     */
    protected $hidden = [
        'password',
        'remember_token',
    ];

    /**
     * The attributes that should be cast to native types.
     *
     * @var array
     */
    protected $casts = [
        'email_verified_at' => 'datetime',
    ];
}

auth.php:

<?php

return [

    /*
    |--------------------------------------------------------------------------
    | Authentication Defaults
    |--------------------------------------------------------------------------
    |
    | This option controls the default authentication "guard" and password
    | reset options for your application. You may change these defaults
    | as required, but they're a perfect start for most applications.
    |
    */

    'defaults' => [
        'guard' => 'web',
        'passwords' => 'webusers',
    ],

    /*
    |--------------------------------------------------------------------------
    | Authentication Guards
    |--------------------------------------------------------------------------
    |
    | Next, you may define every authentication guard for your application.
    | Of course, a great default configuration has been defined for you
    | here which uses session storage and the Eloquent user provider.
    |
    | All authentication drivers have a user provider. This defines how the
    | users are actually retrieved out of your database or other storage
    | mechanisms used by this application to persist your user's data.
    |
    | Supported: "session", "token"
    |
    */

    'guards' => [
        'web' => [
            'driver' => 'session',
            'provider' => 'webusers',
        ],

        'api' => [
            'driver' => 'token',
            'provider' => 'webusers',
            'hash' => false,
        ],
    ],

    /*
    |--------------------------------------------------------------------------
    | User Providers
    |--------------------------------------------------------------------------
    |
    | All authentication drivers have a user provider. This defines how the
    | users are actually retrieved out of your database or other storage
    | mechanisms used by this application to persist your user's data.
    |
    | If you have multiple user tables or models you may configure multiple
    | sources which represent each model / table. These sources may then
    | be assigned to any extra authentication guards you have defined.
    |
    | Supported: "database", "eloquent"
    |
    */

    'providers' => [
        'webusers' => [
            'driver' => 'eloquent',
            'model' => App\Models\User::class,
        ],

        // 'users' => [
        //     'driver' => 'database',
        //     'table' => 'users',
        // ],
    ],

    /*
    |--------------------------------------------------------------------------
    | Resetting Passwords
    |--------------------------------------------------------------------------
    |
    | You may specify multiple password reset configurations if you have more
    | than one user table or model in the application and you want to have
    | separate password reset settings based on the specific user types.
    |
    | The expire time is the number of minutes that the reset token should be
    | considered valid. This security feature keeps tokens short-lived so
    | they have less time to be guessed. You may change this as needed.
    |
    */

    'passwords' => [
        'users' => [
            'provider' => 'webusers',
            'table' => 'password_resets',
            'expire' => 60,
            'throttle' => 60,
        ],
    ],

    /*
    |--------------------------------------------------------------------------
    | Password Confirmation Timeout
    |--------------------------------------------------------------------------
    |
    | Here you may define the amount of seconds before a password confirmation
    | times out and the user is prompted to re-enter their password via the
    | confirmation screen. By default, the timeout lasts for three hours.
    |
    */

    'password_timeout' => 10800,

];

from Newest questions tagged laravel-5 - Stack Overflow https://ift.tt/3jtOptC
via IFTTT

delete if password is correct

i need to create a condition that clears the record but with a password.

if the password is correct execute the delete();

controller:

      public function eliminar($id){

    $registros = \App\Models\Registro::findOrFail($id);
    $registros->delete();
     
    return redirect('sistema')->with('mensaje', 'Registro Borrado con exito');
}

    public function borrar($id){
        // return $request->all();
        $data = [
            'category_name' => 'datatable',
            'page_name' => 'multiple_tables',
        'has_scrollspy' => 0,
        'scrollspy_offset' => '',
        'fechax' => Carbon::now(),
        'borrar' => \App\Models\Registro::findOrFail($id),
        'password' => 'PASSCODE',
      

        ];
       
    

        return view('borrar')->with($data);
    }

blade.php:

  <h1>Do you want to delete the record?</h1>



<form action="" class="d-inline" method="POST">
    @method('DELETE')
    @csrf
    <button type="submit" class="btn btn-danger btn-sm">DELETE</button>


    <div class="form-group col-md-6">
                                                <label for="telefono">Password</label>
                                                <input name="password" type="password" class="form-control" id="telefono"  required>
                                            </div>
</form> 

the password is obtained statically

How can I make it delete without the password is identical?

help please

from Newest questions tagged laravel-5 - Stack Overflow https://ift.tt/3x62aTe
via IFTTT

Special Characters and Searches with Laravel elequant

The issue I am having is with Special Characters. Search with the inputs %(Modular), __(_Underscore), O(Number). It will not filter out any result. it will display all the results. Where as searching templates having other special characters and number displaying correct results.

If in the DB I have subject of myname is % user, and the users search input is %, it doesn't find the result. Same with__(_Underscore), O(Number).

($searchkeyword) {
                    $q->where(function($query) use ($searchkeyword) {
                        $query->where('studentname', 'like', "%$searchkeyword%")
                        ->orWhere('subject', 'like', "%$searchkeyword%")
                        ->orWhere('city', 'like', "%$searchkeyword%");
                    });
                })

from Newest questions tagged laravel-5 - Stack Overflow https://ift.tt/3w8bbto
via IFTTT

Laravel Sanctum not generating token if user id data type is string

I want to have string data type user's id in laravel and authenticate via sanctum but when i change user's id data type from bigInteger -> String it causes error while generating token but when i'm using bigInteger it works fine.

How to use string data type in user's id and authenticate via sanctum any help!

error:

Illuminate\Database\QueryException: SQLSTATE[HY000]: General error: 1364 Field 'id' doesn't have a default value (SQL: insert into `personal_access_tokens` (`name`, `token`, `abilities`, `tokenable_id`, `tokenable_type`, `updated_at`, `created_at`) values (apiToken, 3a8d3965b6af9d8d5b9caaa5ae557f69dc63c70ae1777e4f5509734d605b2fa4, ["*"], 5fa6ab1ef3206dd468a74eaf5a35d2bd, App\Models\User, 2021-06-30 06:47:05, 2021-06-30 06:47:05)) in file C:\Laravel\gleecia\vendor\laravel\framework\src\Illuminate\Database\Connection.php on line 692

from Newest questions tagged laravel-5 - Stack Overflow https://ift.tt/3jwxBlx
via IFTTT

condition hide if it was used on the day

i need create a condition that hides a field if it was already used on the day. the fields to hide are hours i need to create the condition so that the time is not taken twice

that is, if the 10:00 shift has already been used, no one can use it again on the day of the date.

Blade.php:

                        <div class="col-md-6  col-sm-6 col-12">
                                <div class="form-group start-date">
                                    <label for="start-date" class="">Hora:</label>
                                    <div class="d-flex">
                                
                                    <select name="hora" class="form-control form-control-sm">
                                    @foreach($horarios as $dato)
    <option>

    </option>
    @endforeach

</select>
                                    </div>
                                </div>
                            </div>
                            
                        </div>

controller:

     public function index(){
       

          $datax = [
            'category_name' => 'apps',
            'page_name' => 'calendar',
            'has_scrollspy' => 0,
            'scrollspy_offset' => '',
    

        ];


       
       
  
         $month = date("Y-m");
         //
         $data = $this->calendar_month($month);
         $mes = $data['month'];
         // obtener mes en espanol
         $mespanish = $this->spanish_month($mes);
         $mes = $data['month'];
$registros = \App\Models\Horarios::All();
  
         return view("home",[
           'data' => $data,
           'mes' => $mes,
           'mespanish' => $mespanish,
           'horarios' => $registros
         ])->with($datax);
  
     }

help please

from Newest questions tagged laravel-5 - Stack Overflow https://ift.tt/3qxPMZw
via IFTTT

I want when i update code then its display on top of page

$data = MoviesModel::where('id', $request->id)->update(['title' => $request->title]);

from Newest questions tagged laravel-5 - Stack Overflow https://ift.tt/3hhOWvN
via IFTTT

Laravel Eloquent how to get relationship self object?

I have tables with below relationship

And my HousingAdvertisement model has

public function nearPlaces()
{
    return $this->hasMany(HousingAdNearPlace::class);
}

and HousingAdNearPlace

public function nearPlace()
{
    return $this->hasOne(NearPlace::class, 'id');
}

when I make query like this:

HousingAdvertisement::with('nearPlaces.nearPlace')->where('user_id', '=', auth()->user()->id)->get();

I got HousingAdNearPlace object in HousingAdvertisement model:

[...
{
...,
"near_places": [
        {
            "id": 27,
            "housing_advertisement_id": 48,
            "near_place_id": 3,
            "created_at": "2021-06-29T12:23:35.000000Z",
            "updated_at": "2021-06-29T12:23:35.000000Z",
            "near_place": null
        },
        {
            "id": 28,
            "housing_advertisement_id": 48,
            "near_place_id": 4,
            "created_at": "2021-06-29T12:23:35.000000Z",
            "updated_at": "2021-06-29T12:23:35.000000Z",
            "near_place": null
        }
    ]
...]

How can I got self NearPlace model like this:

[...
{
...,
"near_places": [
        {
            "id": 3,
            "name": "Park",
            "slug": "park",
            "created_at": "2021-06-29T06:25:57.000000Z",
            "updated_at": "2021-06-29T06:25:57.000000Z"
        },
        {
            "id": 4,
            "name": "Beach",
            "slug": "beach",
            "created_at": "2021-06-29T06:25:57.000000Z",
            "updated_at": "2021-06-29T06:25:57.000000Z"
        }
    ]
...]

from Newest questions tagged laravel-5 - Stack Overflow https://ift.tt/3hgFKb8
via IFTTT

Laravel excel add complex headers to an export

I need to export a sheet with a complex heading. I need a main heading and another sub level heading after.

I'm trying like this,

use Maatwebsite\Excel\Concerns\FromQuery;
use Maatwebsite\Excel\Concerns\WithHeadings;

class InvoicesExport implements FromQuery, WithHeadings
{   
    public function headings(): array
    {
        return [
            'Account 1' =>[
                "Account 1 id",
                "Account 1 branch"  
            ],
            'Account 2' =>[
                "Account 2 id",
                "Account 2 branch"  
            ],
        ];
    }
}

But getting header columns like, [ "Account 1 id", "Account 1 branch" ]

is there a way to archive this task?

from Newest questions tagged laravel-5 - Stack Overflow https://ift.tt/3joHC49
via IFTTT

How can you change the table where you users are called from in PHP/Laravel

I'm pretty new to Laravel and PHP but I have made an app that requires a user to log in, now this table is called users and all my users sit in there, but I want to make another table called temUsers and use that table instead... but I don't know where the code points to that user table so I can change it to temUsers. Can anyone please assist in knowing which file would point to this?.

from Newest questions tagged laravel-5 - Stack Overflow https://ift.tt/3w1BDov
via IFTTT

Integrate Cloudflare CDN to laravel [closed]

I want to integrate cloudflare cdn into my laravel project and I am new to laravel. Can anyone guide me in achieving this or any document or tutorial from where I can achieve this. Help will be highly appreciated.

from Newest questions tagged laravel-5 - Stack Overflow https://ift.tt/3h2x6Or
via IFTTT

How can I retrieve data using Eloquent model without accessing the appended fields' function?

I am using Laravel 5.4.

service.php

$results = Coupon::select(...self::SELECTED_FIELDS)->with('user:id,email');
$results = $results
    ->orderBy('created_at', 'DESC')
    ->limit($limit)
    ->offset($offset)
    ->get()
    // Apparently you need to hide the computed fields manually in Laravel?
    ->each(function($row){
        $row->setHidden(
            'coupons',
            'coupons_count',
            'coupon_ids_string',
            'assigned_coupon_ids',
            'used_coupon_ids'
        );
    });

The model codes:

protected $appends = [
    'coupons',
    'coupons_count',
    'coupon_ids_string',
    'assigned_coupon_ids',
    'used_coupon_ids'
];

function getCouponIDsStringAttribute() {
    echo('Hahaha');
    // ... A lot of thing happened here, accessing database, do joins
}
function getCouponsAttribute() {
    echo('Hahaha');
    // ... A lot of thing happened here, accessing database, do joins
}
function getCouponsCountAttribute() {
    echo('Hahaha');
    // ... A lot of thing happened here, accessing database, do joins
}
function getAssignedCouponIDsAttribute() {
    echo('Hahaha');
    // ... A lot of thing happened here, accessing database, do joins
}
function getUsedCouponIDsAttribute() {
    echo('Hahaha');
    // ... A lot of thing happened here, accessing database, do joins
}

When the codes above executed, the result of $results will execute all the appended fields's function. Output in the browser:

HahahaHahahaHahahaHahahaHahaha

I only want the appended fields to be calculated when I accessed to. I don't need to have the appended fields to be calculated for every time I ask for Coupon . How can I achieve this? Thanks!

from Newest questions tagged laravel-5 - Stack Overflow https://ift.tt/3w8hmh3
via IFTTT

PHPUnit tests actually runs the code instead of just testing

I am not really sure if I set it up correctly or not as it is my first time working with PHPUnit tests.

I want to test one particular console command which sends emails to users.

Here's my unit test.

     /**
     * @test
     */
    public function test_expiring_assessment_command_success()
    {
        $user = $this->getOrCreateTestUser();
        $assessment = $this->getOrCreateTestOnlineVisit($user, 'cancelled');

        Log::debug($assessment); //this log logs the factory created assessment
        Log::debug(env('APP_ENV')); //testing

        $this->artisan('process:send-visit-emails');
    }

This is the code in my SendVistEmails.php

    /**
     * Execute the console command.
     *
     * @return int
     */
    public function handle()
    {
        $from = Carbon::now()->subDays(7)->startOfDay();
        $to = $from->copy()->endOfDay();

        $assessments = Assessment::query()
            ->whereIn('status', ['pending_pause', 'pending'])
            ->whereNotNull('response_required_from')
            ->whereBetween('response_required_from', [$from, $to])
            ->select('details', 'status')
            ->get();

        foreach ($assessments as $a){
            Log::debug($a); //this logs assessments present in DB instead of the one created in my test.
        }

        $assessments->each->expire();
    }

Now, when I run phpunit tests it just interacts with code and sends emails to all the users present in DB.

I want to run command just for testing and in my SendVistEmails.php code, when I log $a, it should have only the assessment my unit test created and not the ones from DB.

I spent two days on this reading so much documentation but couldn't figure out What am I missing.

from Newest questions tagged laravel-5 - Stack Overflow https://ift.tt/3jixbPI
via IFTTT

php artisan queue:flush does not flush the queues

Our log is blowing up due to non-stop retries by the queue workers despite having the retries set to 1 only. This is literally caused by 3 different failed job payloads that are being retried millions of times due to a fatal error.

1. Why aren't the queued jobs just failed after the 1st one as configured?
2. Why doesn't php artisan queue:flush actually flush the queues so it will stop retrying all jobs?

Queue is SQS based so I went into SQS and purged there and then restart the queue workers, but I would have expected the flush command and the retry setting to have done their jobs.

from Newest questions tagged laravel-5 - Stack Overflow https://ift.tt/3dnqh7S
via IFTTT

laravel 5 change mysql password

I have the feeling that my mysql database has been hacked by someone doing minor changes (very strange but very annoying). So I want to change mysql password. I remember that a while ago and I had some issues (I had to delete a cache to finally get it to work but I don't remember which file). So I want to be sure that I do it correctly as the site is live.

1/ I would change the password of the database. 2/ I would edit the .ENV aqnd change it there 3/ From the console, I would run the following commands: php artisan cache:clear php artisan config:clear php artisan config:cache 4/ Then there is that cache file I need to delete but which one is it?

Is this the correct procedure?

from Newest questions tagged laravel-5 - Stack Overflow https://ift.tt/3xUKERC
via IFTTT

"Call to private Instamojo\Instamojo::__construct() from context" in Laravel

public function pay(Request $request){

 $api = new \Instamojo\Instamojo(
   config('services.instamojo.api_key'),
   config('services.instamojo.auth_token'),
   config('services.instamojo.url')
);

try {
$response = $api->paymentRequestCreate(array(
   "purpose" => "FIFA 16",
   "amount" => $request->amount,
   "buyer_name" => "$request->name",
   "send_email" => true,
   "email" => "$request->email",
   "phone" => "$request->mobile_number",
   "redirect_url" => "http://127.0.0.1:8000/pay-success"
   ));
    
   header('Location: ' . $response['longurl']);
   exit();
}catch (Exception $e) {
print('Error: ' . $e->getMessage());
}
}

Error after submitting form on $api = new \Instamojo\Instamojo( line. Error:- Call to private Instamojo\Instamojo::__construct()

from Newest questions tagged laravel-5 - Stack Overflow https://ift.tt/3h0HciV
via IFTTT

Laravel Controller update model from different users

In my Laravel application, I have a Model called Project which has, among others, a property called approved_at. There is also a ProjectController, which contains the usual methods *(index, show, create, update, edit...)

Now, the user that created the Project can edit it (modifying its other attributes), but only some "staff" members have the right to approve one.

From what I understand, there can be two ways to handle the approval operation:

1. Both users, from their respective views (let's call them edit and approve) fire the ProjectController@update method, which will internally distinguish who-can-do-what by means of authorization or policies;
2. I create a new ProjectApprovalController, with its own update method, and check the authorization at the endpoint (eg, /projects/{id}/approve).

What is the best approach to tackle this behaviour?

from Newest questions tagged laravel-5 - Stack Overflow https://ift.tt/3y3hBM5
via IFTTT

How to add command to run Laravel cron job in Ovi Panel?

I am trying to add a command to run my cron job. But It showing path is not available.

I added php then file path and command.

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

Where is the notification push code on Laravel

Sorry for asking this question. I'm new to laravel and I'm trying to find out the location of the responsible script of sending the notification on submite button event.

When I go to

http://127.0.0.1:8000/push-notificaiton

You know there you fill the title and message then you submit it to a script or code where you find the targeted auth username.

I want to know the location of that code to edit it in order to do one more things such as inserting title and message in database after sending the push notification to use.

from Newest questions tagged laravel-5 - Stack Overflow https://ift.tt/3jfA6bL
via IFTTT

Laravel eloquent query groupBy category with sum and sortBy sum

I have 3 related tables:

Table category :

+-----+---------------+
| id  | nama_kategori |
+-----+---------------+
| 1   | Sayur         |
| 2   | daging        |
| 3   | buah          | 
+-----+---------------+

Table Barang

+-----+-------------+-------------+
| id  | nama_barang | id_kategori |
+-----+-------------+-------------+
| 1   | Sayur 1     | 1           |  
| 2   | Sayur 2     | 1           |   
| 3   | Daging Ayam | 2           |   
| 4   | Apple       | 3           |   
| 5   | Banana      | 3           |      
+-----+-------------+-------------+

Table barang_keluar

+-----+-------------+-----------+---------+
| id  | tgl_keluar  | id_barang | jml_bk  |
+-----+-------------+-----------+---------+
| 1   | 02-03-2021  | 1         |   200   |
| 2   | 04-03-2021  | 2         |   100   |
| 3   | 12-03-2021  | 1         |   100   |
| 4   | 15-03-2021  | 3         |   500   |
| 5   | 20-03-2021  | 2         |   100   |
| 6   | 25-03-2021  | 1         |   100   |
| 6   | 25-03-2021  | 4         |   100   |
| 6   | 25-03-2021  | 5         |   100   |
+-----+-------------+-----------+---------+

The query I'm making now looks like this:

$kategorix='All';
$bulan = '2021-03';
$bulanx=Carbon::parse($bulan)->format('Y-m');
    
$kategoriy=DB::table('barang_keluar')->join('barang','barang.id','=','barang_keluar.id_barang')
            ->join('kategori','kategori.id','=','barang.id_kategori')
            ->select('barang_keluar.id_barang',
                     'barang.id_kategori',
                     'kategori.nama_kategori',
                      DB::raw('sum(jml_bk) as total'))
             ->where(DB::raw("date_format(tgl_keluar,'%Y-%m')"), '=', $bulanx)
             ->groupBy('id_barang','id_kategori','nama_kategori')
             ->orderBy('tgl_keluar')
             ->orderBy('total')
             ->get();
                    
$barang = $kategoriy->groupBy('id_kategori');
$array = collect($barang)->sort($barang->sum('total'))->reverse()->toArray();

and the results I get:

array:5 [▼
  1 => array:1 [▼
    0 => {#939 ▼
      +"id_barang": 1
      +"id_kategori": 1
      +"nama_kategori": "Sayur 1"
      +"total": "400"
    }
  0 => {#939 ▼
      +"id_barang": 2
      +"id_kategori": 1
      +"nama_kategori": "Sayur 2"
      +"total": "200"
    }
  ]
  2 => array:1 [▼
    0 => {#943 ▼
      +"id_barang": 3
      +"id_kategori": 2
      +"nama_kategori": "Daging"
      +"total": "500"
    }
  ]
  3 => array:1 [▼
    0 => {#945 ▼
      +"id_barang": 4
      +"id_kategori": 3
      +"nama_kategori": "Apple"
      +"total": "100"
    }
    0 => {#945 ▼
      +"id_barang": 5
      +"id_kategori": 3
      +"nama_kategori": "Banana"
      +"total": "100"
    }
  ]  
]

How to get the result of sort By('subtotal') from groupBy('category_id'). Please help

I've tried adding query array and sort like this. but the result is still the same as above

$array = collect($barang)->sort($barang->sum('total'))->reverse()->toArray();

Maybe the blade table example that I made would be like this, but sorted by subtotal of the large - small values. Please help

from Newest questions tagged laravel-5 - Stack Overflow https://ift.tt/3qnPioU
via IFTTT

Method Illuminate\Database\Eloquent\Collection::save does not exist

i have a problem when updating the database

error: Method Illuminate\Database\Eloquent\Collection::save does not exist.

controller:

 public function actualizar(Request $request){
    
    $nuevoIngreso = \App\Models\Servicio::all();
    $nuevoIngreso->costo = $request->costo;
    $nuevoIngreso->duracion = $request->duracion;
    $nuevoIngreso->mantenimiento = $request->mantenimiento;
    $nuevoIngreso->save();
    return redirect('servicios')->with('mensaje', 'Ficha Actualizada.');

}

blade.php

         <form method="POST" action="">
                
@csrf

                    @foreach ($servicios as $costo)
<h1 class="text-center text-primary">   </h1>
                  <div class="form-group row">
                    <label for="example-text-input" class="col-md-2 col-form-label form-control-label">Costo</label>
                    <div class="col-md-10">
                      <input class="form-control" type="text" value="">
                
                    </div>
                    <label for="example-text-input" class="col-md-2 col-form-label form-control-label">Duración</label>
                    <div class="col-md-10">
                      <input class="form-control" type="text" value="" id="example-text-input">
                    </div>
                    <label for="example-text-input" class="col-md-2 col-form-label form-control-label">Mantenimiento</label>
                    <div class="col-md-10">
                      <input class="form-control" type="text" value="" id="example-text-input">
                    </div>
                  </div>
                 <hr>
               @endforeach

               <button type="submit" class="btn btn-success float-right" float-rightdata-toggle="sweet-alert" data-sweet-alert="success">SAVE</button>
                </form>

help please

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

foreach prints bad characters

foreach prints bad characters

I am printing a variable but it shows wrong

controller:

$servicios = Registro::where('user_id', $cliente->id)->get('tiposistema');

blade.php:

<div class="row">
    <div class="col">
      <h4>Servicios Contratados:</h4>
    </div>
    <div class="col">
        @foreach($servicios as $ver)
            
        @endforeach
    </div>
</div>

Help please

from Newest questions tagged laravel-5 - Stack Overflow https://ift.tt/3h2cxRd
via IFTTT

Laravel Model binding resource 404 error on show, edit ,delete parameter

I have a model Category and CategoriesController resource and in my web route I have:

Route::group(['prefix' => 'admin', 'as' => 'admin.', 'namespace' => 'Admin', 'middleware' => ['auth']], function () {

    Route::resource('comments', 'CommentsController');


    // Categories
    Route::delete('categories/destroy', 'CategoriesController@massDestroy')->name('categories.massDestroy');

    Route::resource('categories', 'CategoriesController');

});

but only works with index and create the others edit, delete shows 404 , my routes list is this:

Example,I try to show the category 5 like this:

  public function show(Category $category)
{
   
    dd($category);
    return view('admin.categories.show', compact('category'));
}

but I get 404 error only in show, edit, delete.

from Newest questions tagged laravel-5 - Stack Overflow https://ift.tt/3wVebuA
via IFTTT

hide a record according to status

I need to hide a record if the status is == 'Terminado'.

It is done with an if condition, but I don't know how to apply it

blade.php

  <tbody>
                                    @foreach($registros as $registro)
                                       @if($registro->sucursal == Auth::user()->sucursal) 
                                       @if($registro->empleado == Auth::user()->tipo) 
                             
                               
                                        <tr>
                                            <td></td>
                                            <td></td>
                                            <td>
                                                <div class="progress br-30">

                                                @if($registro->estado == 'Ingresado') 
                                                <div class="progress-bar br-30 bg-primary" role="progressbar" style="width: 20%" aria-valuenow="67" aria-valuemin="0" aria-valuemax="100"></div>
                                                @elseif($registro->estado == 'Envío de Prespuesto') 
                                                 <div class="progress-bar br-30 bg-secondry" role="progressbar" style="width: 40%" aria-valuenow="67" aria-valuemin="0" aria-valuemax="100"></div>
                                                 @elseif($registro->estado == 'Anticipo Recibido') 
                                                 <div class="progress-bar br-30 bg-warning" role="progressbar" style="width: 60%" aria-valuenow="67" aria-valuemin="0" aria-valuemax="100"></div>
                                                 @elseif ($registro->estado == 'En Reparación') 
                                                 <div class="progress-bar br-30 bg-danger" role="progressbar" style="width: 80%" aria-valuenow="67" aria-valuemin="0" aria-valuemax="100"></div>
                                                 @elseif ($registro->estado == 'Terminado') 
                                                 <div class="progress-bar br-30 bg-success" role="progressbar" style="width: 100%" aria-valuenow="67" aria-valuemin="0" aria-valuemax="100"></div>
                                                 @elseif ($registro->estado == 'Cancelado') 
                                                 <div class="progress-bar br-30 bg-danger" role="progressbar" style="width: 100%" aria-valuenow="67" aria-valuemin="0" aria-valuemax="100"></div>


                                                @endif

                                                    
                                                </div>
                                            </td>
                                            <td></td>
                                            <td></td>
                                            <td> @if($registro->presupuesto == null) No Aplicado @else $ @endif</td>
                                            <td class="text-center">
                                                <div class="dropdown custom-dropdown">
                                                    <a class="dropdown-toggle" href="#" role="button" id="dropdownMenuLink1" data-toggle="dropdown" aria-haspopup="true" aria-expanded="true">
                                                        <svg xmlns="http://www.w3.org/2000/svg" width="24" height="24" viewBox="0 0 24 24" fill="none" stroke="currentColor" stroke-width="2" stroke-linecap="round" stroke-linejoin="round" class="feather feather-more-horizontal"><circle cx="12" cy="12" r="1"></circle><circle cx="19" cy="12" r="1"></circle><circle cx="5" cy="12" r="1"></circle></svg>
                                                    </a>
                                                    <div class="dropdown-menu" aria-labelledby="dropdownMenuLink1">
                                                    <a class="dropdown-item" href="">Ver</a>
                                                        <a href="" class="dropdown-item" href="javascript:void(0);">Actualizar</a>
                                                        <a class="dropdown-item" href="javascript:void(0);">Borrar</a>
                                                    </div>
                                                </div>
                                            </td>
                                        </tr>
                                        @elseif($registro->estado == 'Terminado') 
                                        
                                        @endif
                                        @endif
                                        @endforeach
                                    </tbody>

the foreach should not show if the status field is == Terminado

but if it has no finished status, if it should show record

controller:

 public function registros(){

        if (Auth::guest()) return redirect('/login');

        $data = [
            'category_name' => 'datatable',
            'page_name' => 'multiple_tables',
        'has_scrollspy' => 0,
        'scrollspy_offset' => '',
        'fechax' => Carbon::now(),

        ];

      

        $registros = \App\Models\Registro::All();
       
        return view('pages.tables.table_dt_multiple_tables',compact('registros'))->with($data);
   


    }

attached blade controller attached blade controller help pls

from Newest questions tagged laravel-5 - Stack Overflow https://ift.tt/3wOmhVL
via IFTTT

I need to update mysql table when someone use my referral code

I need to update mysql table when someone use my referral code which is store in my route using cookie.

i want to check if the cookie ref is available , if it is available two table Wallet and Referral will be updated with the transaction id and the balance on the wallet. I keep getting a success message which means the transaction is working but the table is not update. Below is my code. Thanks

Route

Route::redirect('/', '/index', 301);
Route::get('/index', function() {
    if(!empty($_GET['ref'])) {
        $ref = $_GET['ref'];
        setcookie('ref', $ref, time() + (86400), "/");
        // return redirect()->route('power.index', ['ref' => $ref]);
        // print_r($_COOKIE['ref']);
       return redirect()->route('power.index');
    } else {
        return view('index');
    }
    
})->name('index');

Referral Table

namespace App;

use Illuminate\Database\Eloquent\Model;

class Referral extends Model
{
    //
    protected $fillable = [
        'reftrans', 
        'refuserid', 
        'refamount', 
        'reftype'];
        
        protected $table = 'referrals';
        
        
}

UserTable

namespace App;

use Tymon\JWTAuth\Contracts\JWTSubject;
use Illuminate\Notifications\Notifiable;
use Illuminate\Foundation\Auth\User as Authenticatable;

class User extends Authenticatable implements JWTSubject
{
    use Notifiable;

    /**
     * The attributes that are mass assignable.
     *
     * @var array
     */
    protected $fillable = [
        'fname', 'lname', 'email', 'password', 'phone', 'gLocatorID', 'role_id'
    ];

    /**
     * The attributes that should be hidden for arrays.
     *
     * @var array
     */
    protected $hidden = [
        'password', 'remember_token',
    ];

    protected $with = [
        'wallet', 'vendor'
    ];

    // Rest omitted for brevity

    /**
     * Get the identifier that will be stored in the subject claim of the JWT.
     *
     * @return mixed
     */
    public function getJWTIdentifier()
    {
        return $this->getKey();
    }

    /**
     * Return a key value array, containing any custom claims to be added to the JWT.
     *
     * @return array
     */
    public function getJWTCustomClaims()
    {
        return [];
    }

    public function wallet()
    {
        return $this->hasOne(Wallet::class);
    }

    public function vendor() {
        return $this->hasOne(Vendor::class);
    }

    // public function getPhoneAttribute() {
    //     return "+234" . $this->phone;
    // }
}

Wallet Table

namespace App;

use Illuminate\Database\Eloquent\Model;

class Wallet extends Model
{
    protected $fillable = [
        'user_id', 'balance'
    ];

    public function owner()
    {
        return $this->belongsTo(User::class);
    }

    public function transactions()
    {
        return $this->hasMany(WalletTransaction::class);
    }
}

Controller

class PowerController extends Controller
{

                 if(\Auth::check()) {
                 $rUserID = \Auth::id();
                     dd(cookie::get['ref']);
                     dd($ref);
                     if (isset($ref)){
                         
                     if ($ref == $rUserID){
                     
                     //define amount n type
                     $amt = 25.00;
                     $type = 'Power';
                     //Updating Wallet
                     $wallet = \App\Wallet::find($user_id)->rUserID;
                     $wallet->balance = $wallet->balance + $amt;  
                     $wallet->save(); 
                     
                     //Updating Referral
                     $referral = new \App\Referral;    
                     $referral->reftrans = $powerTransaction->id; 
                     $referral->refuserid = $rUserID; 
                     $referral->refamount = $amt; 
                     $referral->reftype = $type; 
                     $referral->save(); 
                     }
                 }else {
                 //do nothing
             }else{
                 //do nothing
            }
                   
}
 ``` 

Referral link

<input type="text" class="form-control" value="" id="myInput">

from Newest questions tagged laravel-5 - Stack Overflow https://ift.tt/3gUZVLy
via IFTTT

Model field mapping with eloquent in laravel using attribute

Hi I have a structure in db like this:

Category id name_pl name_en

Post id title body lang category

Ofcourse Post->category i related to Category->id. What I'm trying to achive is to get posts with category name depending on Post-lang like this:

{
   id: 1,
   title: "Something",
   body: "whatever",
   categoryName: "Category name in correct language"
}

. I've been trying to do that using atrribute in Post model like this:

    public function getCategoryNameAttribute()
    {
        $category = Category::find($this->category)->load('icon');
        return [
            'id' => $category->id,
            'name' => $this->lang === 'pl' ? $category->name_pl : $category->name_en,
        ];
    }

But in this case I have n+1 problem. I've been trying to use with() method but inside attribude method I get only category id. Any ideas?

from Newest questions tagged laravel-5 - Stack Overflow https://ift.tt/3hh6BE7
via IFTTT

how to show 404 page in laravel 5.2?

I want to show the 404 pages in laravel 5.2 projects. but how is possible and how to handle errors in laravel 5.2? please help me!

1. how to handle errors in laravel 5.2?
2. how to return 404 page?
3. if cannot find URL then return 404 page in laravel 5.2?

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

The query is not working properly. filter in laravel

$data = Orders::join('order_details','order_details.orders_id','=','orders.id')
            ->join('users','users.id','=','orders.user_id') 
            ->select('orders.*','order_details.total_pay','users.first_name','users.last_name') 
            ->where(function($query) use ($user_name,$promotion_code,$status){
                $query->orwhereRaw("concat(first_name, ' ', last_name) like '%$user_name%'")
                ->Where('promotion_code', $promotion_code)
                ->Where('status', $status);             
            }); 

1.When I search all three data at the same time it's ok . But why I input 1/3 data or 2/3 data it doesn't filter?

from Newest questions tagged laravel-5 - Stack Overflow https://ift.tt/3h46kUP
via IFTTT

AJAX data not reaching Laravel Controller method

I am trying to make updates to an app that is using Laravel 5.6. I have the following Laravel set up:

Route

Route::post('getFeedData', 'SurveyController@getFeedData')->name('getFeedData');

Controller

use App\Http\Controllers\Controller;
use App\Classes\FeedRequest;        
class SurveyController extends Controller
{
    public function getFeedData(FeedRequest $request){
        $obj = new FeedRequest();
        
        DebugBar::info($request);
        return response($this->surveyRepository->getNewFeed($obj));
    }
}

My FeedRequest Class

namespace App\Classes;

class FeedRequest {
    public $segments;
    public $locations;
    public $departments;
    public $improvementCats;
    public $search;
    public $waste;
    public $count;
    public $offset;

    public function __construct() {
        $this->segments = array();
        $this->locations = array();
        $this->departments = array();
        $this->improvementCats = 0;
        $this->search = '';
        $this->waste = array();
        $this->count = 20;
        $this->offset = 0;
    }
}

And Lastly My JS

$.ajax({
            url: "/getFeedData",
            type: 'POST',
            contentType: "application/json",
            headers: {
             'X-CSRF-TOKEN': $('meta[name="csrf-token"]').attr('content')
            },
            data: JSON.stringify(request),
        })
        .done((response, textStatus, xhr) => {
            ...
        })
        .fail(() => {
            ...
        }) 

My Controller method is executing but I always have the default version of my FeedRequest object. When I change the controller to accept the default Laravel Request object all my passed parameters are in the "content" attribute. What am I missing to properly hydrate the FeedRequest parameter?

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

Text extraction from Driving Licence using PHP/Laravel

Are there any standard libraries that can help with text extraction from predefined formats like Driving Licence?

We are looking to integrate it with the laravel application.

Thank you in advance.

from Newest questions tagged laravel-5 - Stack Overflow https://ift.tt/3gLtlwJ
via IFTTT

Laravel Markdown mail logo not working on server

Markdown mail logo not working on server works perfect in local

i have follow below steps.

1. publish laravel mail files
2. Changes in resources/views/vendor/mail/html/header.blade.php

Thanks in advance

from Newest questions tagged laravel-5 - Stack Overflow https://ift.tt/3zPVqun
via IFTTT

Convert JSON IN LARAVEL

Here is my JSON

[
    {
        "TIMESTAMP": "2021-06-09 13:13:26",
        "COL1": "10",
        "COL2": "20",
        "COL3": "30"
    },
    {
        "TIMESTAMP": "2021-06-22 13:13:26",
        "COL1": "20",
        "COL2": "30",
        "COL3": "40"
    },
    {
        "TIMESTAMP": "2021-06-21 13:13:26",
        "COL1": "1",
        "COL2": "2",
        "COL3": "3"
    },
    {
        "TIMESTAMP": "2021-06-20 13:13:26",
        "COL1": "40",
        "COL2": "50",
        "COL3": "60"
    }
]   

I need to refactor the json According to the Column name like (EXPECTED OUTPUT)

[
    {
      "TITLE":"COL1"
      "DATA":[10,20,1,40]
      
    },
    {
       "TITLE":"COL2"
      "DATA":[20,30,2,50]
      
    },
    {
      "TITLE":"COL3"
      "DATA":[30,40,3,60]
      
    },
]
  

I was tried but it not working

$data = json_decode($result, true); 
$refactored = array_map(function($item) {
    return (object)[
        'TIMESTAMP' => $item['TIMESTAMP'],
        'DATA' => [ $item['COL1'], $item['COL2'], $item['COL3'] ]
    ];
}, $data);
dump($refactored);

Someone help me out with this. The column may be 3 or more and it must be dynamic. Thanks in advance.

from Newest questions tagged laravel-5 - Stack Overflow https://ift.tt/3qrjWxB
via IFTTT

SQLSTATE[HY000] [1049] Unknown database 'test' (SQL: select * from `users` where `username` = admin123 limit 1)

I am getting this error while trying on laragon

SQLSTATE[HY000] [1049] Unknown database 'test' (SQL: select * from users where username = admin123 limit 1)

from Newest questions tagged laravel-5 - Stack Overflow https://ift.tt/3xMadEK
via IFTTT

Call to private Instamojo\Instamojo::__construct() from context

public function pay(Request $request){

$api = new \Instamojo\Instamojo(
       config('services.instamojo.api_key'),
       config('services.instamojo.auth_token'),
       config('services.instamojo.url')
   );

 try {
   $response = $api->paymentRequestCreate(array(
       "purpose" => "FIFA 16",
       "amount" => $request->amount,
       "buyer_name" => "$request->name",
       "send_email" => true,
       "email" => "$request->email",
       "phone" => "$request->mobile_number",
       "redirect_url" => "http://127.0.0.1:8000/pay-success"
       ));
        
       header('Location: ' . $response['longurl']);
       exit();
   }catch (Exception $e) {
    print('Error: ' . $e->getMessage());
  }
}

Error after submitting form on $api = new \Instamojo\Instamojo( line.

Error:- Call to private Instamojo\Instamojo::__construct()

from Newest questions tagged laravel-5 - Stack Overflow https://ift.tt/3x13FBO
via IFTTT

PHPUnit in Laravel 5.2 Not Passing When Form Validation is Added

I'm currently trying to add validation to my forms. It works fine when I test it but it fails when I run my unit test on it. Removing the validation code allows it to pass with no problems. I tried rewriting the validation portion of the code to do the check manually but no luck. I'm not sure what else I can try. Any help is appreciated.

The error I get:

Did not land on expected page [http://localhost/dashboard].

Failed asserting that two strings are equal.
--- Expected
+++ Actual
@@ @@
-'http://localhost/dashboard'
+'http://localhost/reset-password'

Here's what the form validator looks like:

 public function submit(Request $request)
    {        
        $validation_errors = [];

        $currentUser = $request->user();

        $currentUser->password = Hash::make($request->input('new_password'));
        $currentUser->reset_password = false;

        $user = User::where('id', $currentUser->id)->first();

        // >>>>>> Validation Code Start <<<<<<<< //
        // >>>>>> Removing this block allows it to pass <<<<<<< //

        $newPassword = $request->input('new_password');
        // Check if password is the same as the one in the database
        if(Hash::check($newPassword, $user->password))
        {
            return back()->withErrors('Your password can not be the same as your old password.');
        }

        // Check for special characters
        if (!preg_match('/[\'\/~`\!@#\$%\^&\*\(\)_\-\+=\{\}\[\]\|;:"\<\>,\.\?\\\]/',
        $newPassword))
        {
            array_push($validation_errors, "Please make sure your password contains a special character.");
        }
        
        // Check for numbers
        if (!preg_match('~[0-9]~', $newPassword))
        {
            array_push($validation_errors, "Please make sure your password contains a number.");
        }

        // Check for Upper/Lower case
        if (!preg_match('/[A-Z][a-z]*/', $newPassword))
        {
            array_push($validation_errors, "Please make sure your password contains a combination of uppercase and lowercase letters.");
        }

        // Check for Password length
        if (strlen($newPassword) < 10) 
        {
            array_push($validation_errors, "Please make sure your password length is a minimum than 10 characters.");
        }

        if (count($validation_errors) > 0)
        {
            return back()->withErrors($validation_errors);
        }
        // >>>>>> Validation Code End <<<<<<<< //

        $currentUser->save();

        return redirect()->route('/dashboard');
    }

And this is the unit test code:

public function testResetPasswordSuccess()
    {
        $this->betestUser();
        $this->visit('/reset-password')
            ->type('123', 'password')
            ->type('123', 'password_confirm')
            ->press('Save')
            ->seePageIs('/dashboard');
    }

And for anyone curious, this is how I originally validated the form:

$this->validate($request, [
            'password' => [
                'bail',
                'required',
                'confirmed',
            ],
            'password_confirm' => [
                'bail',
                'required',
            ],
        ]);

from Newest questions tagged laravel-5 - Stack Overflow https://ift.tt/3qfWpQd
via IFTTT

Laravel get method parameters cannot be fetched

I faced a weird issue in Laravel today, the version am using is Laravel 5.5 and I have defined a route as below in the application.

 Route::get('getplaylist/{playlistid}/{page}', 'Mycontroller@getplaylist');

And in my controller am trying to fetch the parameters, weirdly

dd($request->all()); // results in empty array []

whereas the below one works,

dd($request->playlistid);

Any help would be appreciated on what is happening behind the scenes. The issue am facing is am not able to validate the request since an empty '[]' array is resulted.

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

how to sort data including special characters in laravel in composer

how to sort data including special characters in laravel

like 332-1 , 332-2 , 332-10 , 332-11 , 332-20

when try to sort

got

332-1 , 332-10, 332-11,332-2, 332-20

   $data = GeneralVehicle::with('pricingVehicle', 'watermarkVehicle')
        ->where('save_check', '!=', 2)
        ->where('hidden_check', 0);
    if ($transit != 0)
        $data->where('selection', 2)
            
            ->orderBy('lot_no', 'asc');
    else
        $data->whereIn('selection', [1, 3, 5])
            ->orderBy('lot_no', 'desc');
    if ($location != 0)
        $data->where('location', $location);
    else
        $data->whereIn('location', [1, 2, 3]);
    if ($category != 0)
        $data->where('category', $category);
    $vehicles_total = $data->get();
    $vehicles = $data->paginate(20);

from Newest questions tagged laravel-5 - Stack Overflow https://ift.tt/3wLKwDW
via IFTTT

I can't find the user and sum

i have a problem, i need to add the debt of a user

controller:

 public function cliente($id){

        // $nota = App\Nota::find($id);
    
        //Aquí valida si existe sino redirije al 404
        $datos = [
            'category_name' => 'datatable',
            'page_name' => 'multiple_tables',
        'registro' => Registro::find($id),

        ];

        $cliente = \App\Models\User::findOrFail($id);
    
    
        return view('cliente', compact('cliente'))->with($datos);
    }

blade.php

<div class="row">
<div class="col">
  <h4>Debt Sum:</h4>
</div>
<div class="col">
 
</div>

Database:

i need to add the field "deuda" of the user, the relationship is in user_id with the users table

the error that I get is: Trying to get property 'user_id' of non-object

help pls

from Newest questions tagged laravel-5 - Stack Overflow https://ift.tt/35HkDcx
via IFTTT

Converting complex SQL select to Laravel Eloquent

I am new to Laravel and trying to support an existing application that is in Laravel 5. I am trying to convert the following SQL to eloquent structure

SELECT s.id, 
CONCAT(u.first_name, ' ', u.last_name) AS user_name, 
u.avatar_location AS user_img, 
s.employee_photo, 
d.name AS department, 
seg.name AS segment, 
s.survey_title, 
s.before_action, 
s.before_picture, 
s.action, 
s.action_date, 
s.after_action, 
s.after_picture, 
s.nominated, 
s.awarded, 
s.created_at, 
s.updated_at,
(SELECT COUNT(1) FROM likes l WHERE l.survey_id = s.id) AS likes,
(SELECT COUNT(1) FROM likes l WHERE l.survey_id = s.id AND l.user_id = 5) AS UserLikes,
(SELECT COUNT(1) FROM comments c WHERE c.survey_id = s.id ) AS comments
FROM surveys s 
JOIN departments d 
ON s.department = d.id 
JOIN segments seg 
ON s.segment_id = seg.id 
JOIN users u 
ON s.user_id = u.id 
WHERE s.status = 'Approved' 
ORDER BY s.action_date DESC
LIMIT 20 OFFSET 20

I know enough Laravel to know that my basic start would probably be

$surveys = DB::table('surveys')
    ->join('departments',  'surveys.department', '=', 'departments.id')
    ->join('segments', 'surveys.segment_id', '=', 'segments.id')
    ->join('users', 'surveys.user_id', '=', 'users.id')
    ->where('surveys.status', 'Approved')
    ->orderBy('surveys.action_date')
    ->skip(20)-take(20)
    ->select(...)->get();

However, I am not sure how to do the subqueries. Looking for any suggestions.

Thanks!

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

The query did not execute properly

$data = User::where('inet_id', "like", "%" . $inet . "%")
         ->orWhere('email', "like", "%" . $email . "%")
         ->orWhere('phone', "like", "%" . $phone . "%")
         ->get();

1. It only executes the query when searching all 3 data once. But I want to search by separate data too.

from Newest questions tagged laravel-5 - Stack Overflow https://ift.tt/3gIrsRu
via IFTTT

why is my query not working adding like %%

$data = User::WhereRaw("concat(first_name, ' ', last_name) like '%$request->user_name%'")
->orwhere('inet_id',"like", "%" .$request->active_id. "%")
->orwhere('email',"like", "%" . $request->email. "%")
->orwhere('phone',"like", "%" . $request->phone . "%")->get();

1. Why is my query not working adding like %% .

from Newest questions tagged laravel-5 - Stack Overflow https://ift.tt/3qaQmMM
via IFTTT

Apple Pay Integration In Laravel

I want to integrate apple pay into my Laravel website but unable to find the proper solution for its integration. Is there any REST API documentation for apple pay integration in PHP.? Like,

1. create payment API in Apple Pay
2. refund payment API in Apple Pay

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

Refactor the JSON object in Laravel

Here's my JSON:

[
    {
        "ID": 1,
        "SOURCEID": 1,
        "TIMESTAMP": "2020-04-05 07:05:29",
        "VALUE": "30"
    },
    {
        "ID": 4,
        "SOURCEID": 2,
        "TIMESTAMP": "2020-04-05 07:05:17",
        "VALUE": "40"
    },
    {
        "ID": 3,
        "SOURCEID": 1,
        "TIMESTAMP": "2020-04-06 12:04:59",
        "VALUE": "35"
    },
    {
        "ID": 5,
        "SOURCEID": 1,
        "TIMESTAMP": "2020-06-17 12:01:32",
        "VALUE": "1"
    },
    {
        "ID": 6,
        "SOURCEID": 2,
        "TIMESTAMP": "2021-06-17 13:55:29",
        "VALUE": "2"
    }
]

I need to refactor the JSON like

I need JSON to be refactor based on timestamp and source id and JSON is dynamic like a number of source id present in the given JSON there are two ids that is 1 and 2. Below I gave the expected output.

I need a Unique time stamp in a separate array-like

 [2020-04-05,2020-04-06,2020-06-17,2021-06-17]
    { "sourceid: 1, "data":[30,35,1,0], }, { "sourceid": 2, "data":[40,0,0,2], }

Note: The value fills according to the date. Other it should fill as 0.

I have tried like this :

    `$data=json_decode($result);

    $timestamp=[];
    $dataList=[];
    foreach ($data as $value){

        $date=\Carbon\Carbon::parse($value->TIMESTAMP)->toDateString();

        if(!in_array($date, $timestamp, true)){
            array_push($timestamp, $date);
        }
        
        if(isset($dataList[$value->SOURCEID])){
            array_push($dataList[$value->SOURCEID]['data'],$value->VALUE);
        } else{
            $dataList[$value->SOURCEID]=[
                'SOURCEID'=>$value->SOURCEID,
                'data'=>[$value->VALUE]
            ];
        }
    }
    dump($timestamp);
    dump($dataList);` 

But it produce like

{ "sourceid: 1, "data":[30,35,1], }, { "sourceid": 2, "data":[40,2]}

but I need like

{ "sourceid: 1, "data":[30,35,1,0], }, { "sourceid": 2, "data":[40,0,0,2] }

from Newest questions tagged laravel-5 - Stack Overflow https://ift.tt/3zJF0DC
via IFTTT

PHP Fatal error: Uncaught PDOException: SQLSTATE[200]: Integrity constraint violation: 1062 Duplicate entry '0' for key 'PRIMARY' [closed]

[20-Jun-2021 14:57:53 UTC] PHP Fatal error: Uncaught PDOException: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '0' for key 'PRIMARY' in /home2/islamage/public_html/vendor/laravel/framework/src/Illuminate/Database/Connection.php:464 Stack trace: #0 /home2/islamage/public_html/vendor/laravel/framework/src/Illuminate/Database/Connection.php(464): PDOStatement->execute() #1 /home2/islamage/public_html/vendor/laravel/framework/src/Illuminate/Database/Connection.php(664): Illuminate\Database\Connection->Illuminate\Database{closure}('insert into tr...', Array) #2 /home2/islamage/public_html/vendor/laravel/framework/src/Illuminate/Database/Connection.php(631): Illuminate\Database\Connection->runQueryCallback('insert into tr...', Array, Object(Closure)) #3 /home2/islamage/public_html/vendor/laravel/framework/src/Illuminate/Database/Connection.php(465): Illuminate\Database\Connection->run('insert into tr...', Array, Object(Closure)) #4 /home2/islamage/public_html/vendor/laravel/framework/src/Illuminate/Database/Connection.php(417): in /home2/islamage/public_html/vendor/laravel/framework/src/Illuminate/Database/Connection.php on line 671 [20-Jun-2021 14:57:53 UTC] PHP Fatal error: Uncaught PDOException: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '0' for key 'PRIMARY' in /home2/islamage/public_html/vendor/laravel/framework/src/Illuminate/Database/Connection.php:464 Stack trace: #0 /home2/islamage/public_html/vendor/laravel/framework/src/Illuminate/Database/Connection.php(464): PDOStatement->execute() #1 /home2/islamage/public_html/vendor/laravel/framework/src/Illuminate/Database/Connection.php(664): Illuminate\Database\Connection->Illuminate\Database\{closure}('insert into tr...', Array) #2 /home2/islamage/public_html/vendor/laravel/framework/src/Illuminate/Database/Connection.php(631): Illuminate\Database\Connection->runQueryCallback('insert into tr...', Array, Object(Closure)) #3 /home2/islamage/public_html/vendor/laravel/framework/src/Illuminate/Database/Connection.php(465): Illuminate\Database\Connection->run('insert into tr...', Array, Object(Closure)) #4 /home2/islamage/public_html/vendor/laravel/framework/src/Illuminate/Database/Connection.php(417): in /home2/islamage/public_html/vendor/laravel/framework/src/Illuminate/Database/Connection.php on line 671

from Newest questions tagged laravel-5 - Stack Overflow https://ift.tt/3xxzXEw
via IFTTT

error add money from all records - count()

i need to add up all the money in the column "ingresos".

Error: Property [presupuesto] does not exist on this collection instance.

used the variable :

database:

Controller:

public function contador(){

        if (Auth::guest()) return redirect('/login');

      

        $contador = \App\Models\Registro::All();
       
        return view('contador',compact('contador'));
   


    }

I need to add the income

from Newest questions tagged laravel-5 - Stack Overflow https://ift.tt/3xDtXKD
via IFTTT

Laravel chunkbyid for joins

When i use chunkById on a Query Builder with joins I am not getting the output

 DB::table('cs')
 ->join('hw','hw.p1', '=', 'cs.awb')
 ->where('cs.dv','hw')
 ->chunkById(100, function ($hw_orders) use (&$hwCount) {
 foreach ($hw_orders as $hwd){
  Log::info('Number ' . $hwd->awb);
 });

I want to know how I could chunk this data with joins. Thank you

from Newest questions tagged laravel-5 - Stack Overflow https://ift.tt/3iV1OdM
via IFTTT

Trying to get property of non-object - name

i am trying to print the username, but it gives me error

Trying to get property of non-object

Models

User:

<?php

namespace App\Models;
use App\Models\Registro;
use Illuminate\Contracts\Auth\MustVerifyEmail;
use Illuminate\Database\Eloquent\Factories\HasFactory;
use Illuminate\Foundation\Auth\User as Authenticatable;
use Illuminate\Notifications\Notifiable;

class User extends Authenticatable
{
    use HasFactory, Notifiable;

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

    /**
     * The attributes that should be hidden for arrays.
     *
     * @var array
     */
    protected $hidden = [
        'password',
        'remember_token',
    ];

    /**
     * The attributes that should be cast to native types.
     *
     * @var array
     */
    protected $casts = [
        'email_verified_at' => 'datetime',
    ];
    public function registros(){
      
       
         return $this->belongsTo('\App\Models\Registro', 'user_id');
    }
}

Registro:

<?php

namespace App\Models;

use Illuminate\Database\Eloquent\Factories\HasFactory;
use Illuminate\Database\Eloquent\Model;
use \App\Models\User;

class Registro extends Model
{
    use HasFactory;

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

    }
   
}

database:

in blade.php:

maybe I'm doing something wrong with relationships, but I can't figure it out on my own

<tbody class="list">
            @foreach($registros as $registro)
              <tr>
                <th scope="row">
                  <div class="media align-items-center">
                    <a href="#" class="avatar rounded-circle mr-3">
                      <img alt="Image placeholder" src="../../assets/img/theme/bootstrap.jpg">
                    </a>
                    <div class="media-body">
                      <span class="name mb-0 text-sm"></span>
                    </div>
                  </div>
                </th>
            
              </tr>
             @endforeach
            </tbody>

try changed relationships but it doesn't work does not allow me to print the name of user_id, help pls

from Newest questions tagged laravel-5 - Stack Overflow https://ift.tt/3wFfUUH
via IFTTT

Laravel 8 File Validation

I'm new to laravel and I have been struggling to validate uploaded files.

Below is the code that handles validation:

// (I tried mime, mimes, mimetypes) none of them are validating any of the files correctly.
        $validator = Validator::make($request->all(), [
            'proposal_summary' => 'mimetypes:application/pdf|max:2048',
            'plagiarism_report' => 'mimetypes:pdf,doc,docx,txt|max:2048',
            'final_proposal' => 'mimes:pdf,doc,docx,txt|max:2048',
        ]);

I tested this with PDF, docx and txt files, all without success. I get an error saying the files must be a file of type: pdf, doc, docx, txt. Even though they are. I am sure I am doing something wrong, so any help would be appreciated. Please let me know if you require more code or further explanation.

from Newest questions tagged laravel-5 - Stack Overflow https://ift.tt/3qcdfzh
via IFTTT

How to merge two rows and get result?

Table Data:

sales_products table data:

product_id	quantity	sales price
1	4	300
1	5	300
2	3	400
2	2	400
3	3	100

products table

id	product_name
1	product_x
2	product_y
3	product_z

Expected Query Output

product_name	Quantity	Total_Price
product_x	9	2700
product_y	5	2000
product_z	3	300

I was trying with following Query and didn't get expected output

$invoiceDetails = DB::table('products')
    ->join('sales_products', 'sales_products.product_id', '=', 'products.id')
    ->select(
        'products.product_name',
        'sales_products.quantity',
        'sales_products.sales_price',
        DB::raw('(sales_products.quantity * sales_products.sales_price) as total')
    )
    ->where('sales_products.invoice_id', '=', $id)
    ->get();

from Newest questions tagged laravel-5 - Stack Overflow https://ift.tt/3wDBgBD
via IFTTT

Added relationship to laravel model doesn't exist

I've makde some changes to a laravel model php file and the changes never get picked up.

I've tried clearing the cache, adding errors, renaming/deleting the file and the site just runs as if none of these things have happened.

It also only seems to happen to this one file in particular, the other model files are fine when I add changes

Anyone had this happen before?

from Newest questions tagged laravel-5 - Stack Overflow https://ift.tt/3xvCzTw
via IFTTT

Why i can't edit image properties on ckeditor after uploading image on laravel

i have trouble editing my image properties after uploading it in ckeditor4, the image properties seems like been disabled? i can't click anything on high and width input box, or hspace ande vspace. the only thing that i can press are the cancel and save button. does anyone have the same issue? and perhaps the solution for it?.

here i attachthe code for my blade for the ckeditor,and my upload image in the controller

//code on my blade

<div class="form-group">
        <label>Deskripsi</label>
          <textarea type="text" name="deskripsi" class="form-control" placeholder="Deskripsi Item"> </textarea>
           <script>
              CKEDITOR.replace( 'deskripsi', {                                     filebrowserUploadUrl: "", filebrowserUploadMethod: 'form',
filebrowserBrowseUrl : " type=2&editor=ckeditor&fldr=",
filebrowserImageBrowseUrl : "?type=1&editor=ckeditor&fldr=",
config.allowedContent = 'a[!href,target];img[src,alt,width,height]; span[*](*)',
                                });
           </script>
</div>

 public function uploadImage(Request $request)
    {
        if($request->hasFile('upload')) {
         
            //get filename with extension
            $fileNameWithExtension = $request->file('upload')->getClientOriginalName();
       
            //get filename without extension
            $fileName = pathinfo($fileNameWithExtension, PATHINFO_FILENAME);
       
            //get file extension
            $extension = $request->file('upload')->getClientOriginalExtension();
       
            //filename to store
            $fileNameToStore = $fileName.'_'.time().'.'.$extension;
       
            //Upload File
            $request->file('upload')->storeAs('public/uploads', $fileNameToStore);
  
             
            $CKEditorFuncNum = $request->input('CKEditorFuncNum') ? $request->input('CKEditorFuncNum') : 0;
             
            if($CKEditorFuncNum > 0){
             
                $url = asset('storage/uploads/'.$fileNameToStore); 
                $msg = 'Image successfully uploaded'; 
                $renderHtml = "<script>window.parent.CKEDITOR.tools.callFunction($CKEditorFuncNum, '$url', '$msg')</script>";
                 
                // Render HTML output 
                @header('Content-type: text/html; charset=utf-8'); 
                echo $renderHtml;
                 
            } else {
             
                $url = asset('storage/uploads/'.$fileNameToStore); 
                $msg = 'Image successfully uploaded'; 
                $renderHtml = "<script>window.parent.CKEDITOR.tools.callFunction($CKEditorFuncNum, '$url', '$msg')</script>";
                return response()->json([
                    'uploaded' => '1',
                    'fileName' => $fileNameToStore,
                    'url' => $url
                ]);
            }
             
        }
    }

from Newest questions tagged laravel-5 - Stack Overflow https://ift.tt/3xpG9yi
via IFTTT

Controller method very fast (0.2s) but TTFB is 15 seconds

So I've timed my controller method in Laravel with both microtime(true) and getrusage, and checked the actual data responded - it processes my request in ~0.2s, so quite fast.

The actual TTFB for it to respond back to my app is a massive 12 seconds.

Given the data is obtained and returned so quickly, where could this bottleneck be?

I'm aware it's quite a vague question, but I honestly have no idea what could be doing this. Has anyone encountered similar? Included the controller method below, in case it's handy. Just using a standard Axios get() request to run the query.

public function authenticate(Request $request){
    $credentials = $request->only('email', 'password');

    try {
        if (! $token = JWTAuth::attempt($credentials)) {
            return response()->json(['error' => 'invalid_credentials'], 401);
        }
    } catch (JWTException $e) {
        return response()->json(['error' => 'could_not_create_token'], 500);
    }

    $user = User::where('email',$request->email)->first();

    if($request->invitationIdIfExists){
        $invitation = Invitation::find($request->invitationIdIfExists);

        if($invitation->recipient_email == $user->email){
            $request->headers->set('Authorization', 'Bearer '.$token);
        
            Helper::processInvitation($invitation, $user);
        }
    }

    $user->touch();

    $user->token = $token;

    $user->load(['accounts', 'minTodoDays', 'minNotifications']);

    $user->todo_days = $user->minTodoDays;
    $user->notifications = $user->minNotifications;

    unset($user->minTodoDays);
    unset($user->minNotifications);

    $invitationIfExists = Invitation::where('recipient_email', $user->email)->where('completed', 0)->first();

    if($invitationIfExists){
        $user->invitedAccount = $invitationIfExists->account;
    }

    return $user;
}

from Newest questions tagged laravel-5 - Stack Overflow https://ift.tt/3q4lyNw
via IFTTT

Refactoring of Json in laravel

Alright, I need some assistance from an expert.

I have attached my Json below[

    {
        "ID": 1,
        "SOURCEID": 1,
        "TIMESTAMP": "2020-04-05 07:05:29",
        "VALUE": "30"
    },
    {
        "ID": 4,
        "SOURCEID": 2,
        "TIMESTAMP": "2020-04-05 07:05:17",
        "VALUE": "40"
    },
    {
        "ID": 3,
        "SOURCEID": 1,
        "TIMESTAMP": "2020-04-06 12:04:59",
        "VALUE": "35"
    },
    {
        "ID": 5,
        "SOURCEID": 1,
        "TIMESTAMP": "2020-06-17 12:01:32",
        "VALUE": "1"
    },
    {
        "ID": 6,
        "SOURCEID": 2,
        "TIMESTAMP": "2021-06-17 13:55:29",
        "VALUE": "2"
    }
]

I need to refactor the json like

1. I need Unique time stamp in separate array like [2020-04-05,2020-04-06,2020-06-17,2021-06-17]

2. I need json to be refactor based on timestamp and source id and json is dynamic like number of source id present in the given json there are two id that is 1 and 2. Below I gave expected output.

   { "sourceid: 1, "data":[30,35,1,0], }, { "sourceid": 2, "data":[40,0,0,2], }

Thanks in advance.

from Newest questions tagged laravel-5 - Stack Overflow https://ift.tt/3ztyfFY
via IFTTT

first() not working on string with more than one words [closed]

private function getBrandIdFromName($brandName){
        $brand = Brand::query()->where('slug',$brandName)->first();
        if($brand){
            return $brand->id;
        }else{
            $newBrand = [
                'name'=>$brandName,
                'is_active'=>"1",
                'meta'=>[
                    'meta_title'=>null,
                    'meta_description'=>null,
                ]
            ];
            $brand = Brand::create($newBrand);
            return $brand->id;
        }
    }

here 'slug' and 'name' are column in different tables

for one word like "puma" its working fine. but for more than one word like "puma world" it not working well i.e. its importing name again and again. I dont know its reason wheather its causing because of first() or any other mistake. if anyone know please do help.

from Newest questions tagged laravel-5 - Stack Overflow https://ift.tt/35v02bp
via IFTTT

Update pdf which is open in laravel

I'm creating pdf file using DOM pdf, it is working but when i try to recreate it with same name and the pdf file is open then i'm getting this error message:

message: exception: "ErrorException" file: "C:\xampp\htdocs\xxxxxxx\vendor\league\flysystem\src\Adapter\Local.php" line: 199"file_put_contents(C:\xampp\htdocs\XXXX\storage\app\public/pdf/salary/40_file-2021.pdf): failed to open stream: Resource temporarily unavailable" trace: [{function: "handleError", class: "Illuminate\Foundation\Bootstrap\HandleExceptions", type: "->"},…]

             $dompdf = new Dompdf();
             $dompdf->set_option('isHtml5ParserEnabled', true);
             $dompdf->set_option('isRemoteEnabled', true);  
             $html = view('admin/pdf',['data'=>$data_new])->render();
             $dompdf->loadHtml($html);
             $dompdf->setPaper('A4', 'portrait');
             $dompdf->render();
             $fileName = 'pdf/salary/'.$data_new->user_id.'_'.$data_new->application_id.'.pdf';
             Storage::put('public/'.$fileName, $dompdf->output());

Any suggestion is highly appreciated.

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

Cross Authentication between two different Laravel application

Background

The two application is developed in PHP Laravel web application. In the application, App 1 and App 2 are two difference Application and being managed by two different team. App 1 is use to trim video while App 2 is use to showcase their video.

Algorithms:

1. In the App 1 (Ex. Facebook), user can login to the system and upload video together with some form details.
2. App 1 then trim and process the video and save inside the FileSystem.
3. After the process, App 1 then POST the results to App 2 (Ex. Instagram).
4. In the App 2, the video is then uploaded with the respective user information and showcase to public.

Problem

• How do APP 1 authenticate the user in APP 2.
• What is the best approach and most user friendly method while provide a secure authentication

The thing that I concern is the authentication part of App 2. How do we authenticate the user in App 2 before sending the videos to App 1 due to difference user login method?

Some Work that I managed to found on Google

First Way: hash(Master Key + [INFO])

1. Create a master key that are known by only App 1 and App 2. Then hash the master with some extra information (Ex. time()). Then App 2 can validate the hash information with its own master key and if the result is similar then, user can pass through the authentication process and straight away post the video on App 2.

Second Way: OAUTH Token

2. User have to login to the App 2 and generate OAUTH token. Then user need to submit their OAUTH token on App 1 to allows for video posting. This method is not really user friendly as this approach is somewhat the approach for developer.

Not really sure about the terminology used for this type of authentication. Feel free to let me know in the comment section. Thank you very much.

from Newest questions tagged laravel-5 - Stack Overflow https://ift.tt/35xFK0O
via IFTTT

Console not finding the function even if it was included/imported - Javascript / Laravel

I'm currently working on an old project work which utilizes a function for the dropdown design of the web application running in PHP/Laravel.

It shows me this error on the console:

app.js:121 Uncaught TypeError: $(...).dcDrilldown is not a function
at HTMLDocument.<anonymous> (app.js:121)
at j (jquery.min.js:2)

But when I checked my app.blade.php under resources/views, it is importing the file that contains that specific function:

<script type="text/javascript" src=""></script>

Inside the drilldown.js, the function dcDrilldown is found:

(function($){
//define the new for the plugin ans how to call it
    console.log("Here I am with open arms~");
    $.fn.dcDrilldown = function(options) {
        console.log("Now I come to you~");

On the console logs, the logs "Here I am with open arms~" is being shown but not the console inside the function: Click here for image

Any ideas why the dcDrilldown function is not being found? Thanks!

from Newest questions tagged laravel-5 - Stack Overflow https://ift.tt/3wyHMcV
via IFTTT

solution for double text in laravel

private function getBrandIdFromName($brandName){
        $brand = Brand::query()->where('slug',$brandName)->first();
        
        if($brand){
            return $brand->id;
        }else{
            $newBrand = [
                'name'=>$brandName,
                'is_active'=>"1",
                'meta'=>[
                    'meta_title'=>null,
                    'meta_description'=>null,
                ]
            ];
            $brand = Brand::create($newBrand);
            return $brand->id;
        }
    }

this is my code when i import one text "nike" its working well. but when i import 2 text like "nike world" its importing text "nike world" again and again when i import text again. please do help if anyone has solution.

from Newest questions tagged laravel-5 - Stack Overflow https://ift.tt/3vyFvNB
via IFTTT

Add the user ID on the URL

I'm trying to pass a user id on the URL. Once I click on the icon, it should redirect to a specific page with datatables.

and I should see the ID appended on the url

Here are my codes, JS, controller and route. But it won't work.

 <a class="btn btn-link btn-success btn-just-icon btn-round" href="" title="SMS History">
                    <i class="material-icons">sms</i>
                    <div class="ripple-container"></div>
                </a>

controller:

public function getView($id)
{


    $smshistory = SmsOutboundsHistory::find($id);

    return view('pages.sms-history')->withSmshistory($smshistory); }

Route: Route::get('/pages/history/{id}', 'HistoryController@getView');

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

Laravel Permissions Always return TRUE

I'm trying to create a condition for a button using permissions, but even though the permission is not assigned to the user, it returns TRUE... always.

This is what I have in my controller:

public function edit($id){
    $permisos = Auth::user()->hasPermissionTo('listaPrecios.utilidadCero');
    dd($permisos);

    return view('panel.lista_precio.lista_precio_edit')
        ->with( 'permisos' , $permisos);
}

The dd is only to check its status.

Could you help me to resolve this issue? I saw different posts where if you use Can it works, unfortunately it did not work for me either.

from Newest questions tagged laravel-5 - Stack Overflow https://ift.tt/3gvG5re
via IFTTT

APP_ENV=dev causes A facade root has not been set

so i have updated the APP_ENV=dev the original APP_ENV=local, now it is my assumption that the following change causes me with the following error

A facade root has not been set

laravel.ERROR: A facade root has not been set. {"exception":"[object] (RuntimeException(code: 0): A facade root has not been set. at /var/app/current/vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php:236) [stacktrace] #0 /var/app/current/app/Exceptions/Handler.php(80): Illuminate\Support\Facades\Facade::__callStatic('check', Array) #1 /var/app/current/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(314): App\Exceptions\Handler->report(Object(GuzzleHttp\Exception\ConnectException)) #2 /var/app/current/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(118): Illuminate\Foundation\Http\Kernel->reportException(Object(GuzzleHttp\Exception\ConnectException)) #3 /var/app/current/public/index.php(55): Illuminate\Foundation\Http\Kernel->handle(Object(Illuminate\Http\Request)) #4 {main} "}

Not i already run PHP artisan config:cahce and PHP artisan cache:clear

from Newest questions tagged laravel-5 - Stack Overflow https://ift.tt/357mk2K
via IFTTT

SQLSTATE[HY000] [1045] Access denied for user 'root'@'localhost' (using password: NO) - laravel

I am using MAMP in the macOs. I was download the laravel 5 from cpanel. I am getting this error:

SQLSTATE[HY000] [1045] Access denied for user 'root'@'localhost' (using password: NO) (SQL: select * from `products` where `pro_status` = 1 and `pro_stock` > 0 order by `pro_id` desc limit 8)

But can't fix it.

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

Laravel Collection Sum by Item Key

I have the following Laravel collection $output. I want to sum total for each value of sex 1 and 2. I have tried $output->sum('total') but it gives overall total .

Illuminate\Support\Collection {#1334 ▼
  #items: array:11 [▼
    0 => {#1348 ▼
      +"total": 1037931027.8459
      +"status": 2
      +"sex": 1
    }
    1 => {#1346 ▼
      +"total": 1091237622.0488
      +"status": 2
      +"sex": 2
    }
    2 => {#1342 ▼
      +"total": 1103340160.4262
      +"status": 1
      +"sex": 1
    }
    3 => {#1349 ▼
      +"total": 6004661.498201
      +"status": 4
      +"sex": 1
    }
   ]
 }    

from Newest questions tagged laravel-5 - Stack Overflow https://ift.tt/3pYnMOs
via IFTTT

Laravel excel library(Maatwebsite) : How to create a drop down with multiple select for Export

I'm using Laravel Excel to export excel with larvel. I need a dropdown with multiple select.

use App\MyModel;
use Maatwebsite\Excel\Concerns\FromArray;
use Maatwebsite\Excel\Concerns\WithHeadings;

class MyModelExport implements FromArray, WithHeadings
{
    public $rowCount = 0;
    public function array(): array
    {
        $branches = MyModel::get([
            "title",
            "ranks",
        ]);

        $data = [];
        

        foreach ($items $key => $item) {

            $data[$key]['title'] = $item->title;
            $data[$key]['ranks'] = $item->ranks;
        }

        $this->rowCount = count($data);
        return $data;
    }

    public function registerEvents(): array {
        
        return [
            AfterSheet::class => function(AfterSheet $event) {
                /** @var Sheet $sheet */
                $sheet = $event->sheet;

                /**
                 * validation for bulkuploadsheet
                 */
                
                for($i=2; $i<=$this->rowCount+1; $i++){
                    $sheet->setCellValue('B'.$i, $sheet->getCell('B'.$i)->getValue());
                    $configs = "dis1, dis 2, dis 3";
                    $objValidation = $sheet->getCell('B'.$i)->getDataValidation();
                    $objValidation->setType(DataValidation::TYPE_LIST);
                    $objValidation->setErrorStyle(DataValidation::STYLE_INFORMATION);
                    $objValidation->setAllowBlank(false);
                    $objValidation->setShowInputMessage(true);
                    $objValidation->setShowErrorMessage(true);
                    $objValidation->setShowDropDown(true);
                    $objValidation->setErrorTitle('Input error');
                    $objValidation->setError('Value is not in list.');
                    $objValidation->setPromptTitle('Pick from list');
                    $objValidation->setPrompt('Please pick a rank from the drop-down list.');
                    $objValidation->setFormula1('"' . $configs . '"');
                }
            },
        ];
    }

    public function headings(): array
    {
        return [
            'Title',
            'Ranks'
        ];
    }
}

This code gives a dropdown. But what I need a dropdown with multiple selects. Simply I need to select multiple ranks in one cell.

from Newest questions tagged laravel-5 - Stack Overflow https://ift.tt/3wHWqPr
via IFTTT