Robie69

Robie69

Member Since 8 Months Ago

Experience Points 1,490
Experience Level 1

3,510 experience to go until the next level!

In case you were wondering, you earn Laracasts experience when you:

  • Complete a lesson — 100pts
  • Create a forum thread — 50pts
  • Reply to a thread — 10pts
  • Leave a reply that is liked — 50pts
  • Receive a "Best Reply" award — 500pts
Lessons Completed 14
Lessons
Completed
Best Reply Awards 0
Best Reply
Awards
  • Start Your Engines Achievement

    Start Your Engines

    Earned once you have completed your first Laracasts lesson.

  • First Thousand Achievement

    First Thousand

    Earned once you have earned your first 1000 experience points.

  • One Year Member Achievement

    One Year Member

    Earned when you have been with Laracasts for 1 year.

  • Two Year Member Achievement

    Two Year Member

    Earned when you have been with Laracasts for 2 years.

  • Three Year Member Achievement

    Three Year Member

    Earned when you have been with Laracasts for 3 years.

  • Four Year Member Achievement

    Four Year Member

    Earned when you have been with Laracasts for 4 years.

  • Five Year Member Achievement

    Five Year Member

    Earned when you have been with Laracasts for 5 years.

  • School In Session Achievement

    School In Session

    Earned when at least one Laracasts series has been fully completed.

  • Welcome To The Community Achievement

    Welcome To The Community

    Earned after your first post on the Laracasts forum.

  • Full Time Learner Achievement

    Full Time Learner

    Earned once 100 Laracasts lessons have been completed.

  • Pay It Forward Achievement

    Pay It Forward

    Earned once you receive your first "Best Reply" award on the Laracasts forum.

  • Subscriber Achievement

    Subscriber

    Earned if you are a paying Laracasts subscriber.

  • Lifer Achievement

    Lifer

    Earned if you have a lifetime subscription to Laracasts.

  • Laracasts Evangelist Achievement

    Laracasts Evangelist

    Earned if you share a link to Laracasts on social media. Please email [email protected] with your username and post URL to be awarded this badge.

  • Chatty Cathy Achievement

    Chatty Cathy

    Earned once you have achieved 500 forum replies.

  • Laracasts Veteran Achievement

    Laracasts Veteran

    Earned once your experience points passes 100,000.

  • Ten Thousand Strong Achievement

    Ten Thousand Strong

    Earned once your experience points hits 10,000.

  • Laracasts Master Achievement

    Laracasts Master

    Earned once 1000 Laracasts lessons have been completed.

  • Laracasts Tutor Achievement

    Laracasts Tutor

    Earned once your "Best Reply" award count is 100 or more.

  • Laracasts Sensei Achievement

    Laracasts Sensei

    Earned once your experience points passes 1 million.

  • Top 50 Achievement

    Top 50

    Earned once your experience points ranks in the top 50 of all Laracasts users.

14 May
1 week ago

Robie69 left a reply on Auto Send Email

@mthomas That was it! I'm using a WAMP install, and the CLI is using the php.ini in C:\wamp64\bin\php\php5.6.35\php.ini However, the Webserver was using C:\wamp64\bin\apache\apache2.4.33\bin\php.in

A simple copy/paste fixed the issue.

I've been beating my head on this for a day now.

thank you!

Robie69 left a reply on Auto Send Email

Windows install. no sudo.

Robie69 left a reply on Auto Send Email


namespace App\Console\Commands;
use App\Http\Controllers;
use App\Mail\DefectEntry;
use Illuminate\Console\Command;
use Mail;
use DB;
class SendEmail extends Command
{
    /**
     * The name and signature of the console command.
     *
     * @var string
     */
    protected $signature = 'email:DefectReport';

    /**
     * The console command description.
     *
     * @var string
     */
    protected $description = 'Send Users Emails';

    /**
     * Create a new command instance.
     *
     * @return void
     */
    public function __construct()
    {
        parent::__construct();
    }

    /**
     * Execute the console command.
     *
     * @return mixed
     */
    public function handle()
    {
    $todaydefects = $this->todayDefects();
    Mail::send(new DefectEntry($todaydefects));
    }

    public function todayDefects()
    {
        $Inspections =DB::table('inspections')
            ->leftJoin('defectentry', 'inspections.ID', '=', 'defectentry.InspectionID')
            ->leftjoin('defectcodes', 'defectentry.DefectID', '=', 'defectcodes.DefectID')
            ->select('inspections.Notes as QANotes','inspections.ID as Inspection_ID','defectentry.*','defectcodes.*','inspections.*')
            ->where([['inspections.Date', '=', date('Y-m-d')]])
            ->orderby('inspections.WorkOrder','desc')
            ->orderby('inspections.ProcessDef','desc')
            ->orderby('inspections.BarcodeID','desc')
            ->get();

        //Change BarcodeID to Username from Visual.
        $Inspections = $Inspections->map(function ($inspection) {

            $user =DB::connection('sqlsrv')->table('EMPLOYEE')->find($inspection->BarcodeID);
            $userName = $user->FIRST_NAME.' '.$user->LAST_NAME;
            $inspection->BarcodeID = $userName;
            return $inspection;
        });

        return $Inspections;

    }

}

Robie69 left a reply on Auto Send Email

The database connection works fine in the controllers. I was able to successfully send the email.

this error only shows up when I try to run the code from command line.

Robie69 started a new conversation Auto Send Email

I'm working on auto sending an email in Laravel 5.4

I've created the desired email template, and tested that it works properly.

Now I need to make it auto send.

I've setup a console command, and copied the code I had in my Controller over.

every time I run the command via command line, I get the following error:

"In Connection.php line 647:

could not find driver (SQL: select top 1 * from [EMPLOYEE] where [id] = 722)

In Connector.php line 68:

could not find driver"

This works perfectly fine in the Controller, so the drivers are loaded. Why won't it work now in the commands folder?