emailpollingservice.php

<?php

namespace App\Http\Controllers;

use Webklex\IMAP\Client;
use App\InsertTicket;


class EmailPollingService extends Controller {

    public function check() {

        $oClient = new Client([
            'host'          => env("IMAP_HOST", "somedefaultvalue"),
            'port'          => env("IMAP_PORT", "somedefaultvalue"),
            'encryption'    => env("IMAP_ENCRYPTION", "somedefaultvalue"),
            'validate_cert' => env("IMAP_VALIDATE_CERT", "somedefaultvalue"),
            'username'      => env("IMAP_USERNAME", "somedefaultvalue"),
            'password'      => env("IMAP_PASSWORD", "somedefaultvalue"),
            'protocol'      => env("IMAP_PROTOCOL", "somedefaultvalue"),
        ]);
        $oClient->connect();
        $aFolder = $oClient->getFolders();
        foreach($aFolder as $oFolder){
            $aMessage = $oFolder->query()->since(now()->subDays(1))->get();
            foreach($aMessage as $oMessage) {
                /*
                InsertTicket::create([
                    'subject'=>$oMessage->getSubject(),
                    'body'=>$oMessage->getSubject(),
                    ['body' => $oMessage->getHTMLBody(true)],
                ]);
                */
                $ticket = InsertTicket::firstOrNew(
                    ['subject' => $oMessage->getSubject()],
                    ['body' => $oMessage->getHTMLBody(true)],
                    ['sender' => $oMessage->getSender()[0]->mail],
                    ['opened_at' => $oMessage->getDate()],
                    ['attachment' => $oMessage->getAttachments()->count()]);
                $ticket->save();
            }
        }   
    }
    


}

insertticket.php

<?php

namespace App;

use Illuminate\Database\Eloquent\Model;


class InsertTicket extends Model
{
    protected $table = 'tickets';
    protected $fillable = ['subject', 'body', 'sender', 'opened_at', 'attachment'];

}