<?php

/************************
*************************
    << tbl_encomendas >>
    OAORNO – nº encomenda
    OACUNO – nº cliente
    OKCUNM – nome cliente
    OASMCD – nº vendedor
    OAWCON – forma de contacto. Se for “TEL” marcamos o campo envia_cliente=1 para que seja enviado um email de confirmação da encomenda
    CBEMAL – e-mail
    OAORDT – data encomenda

    << tbl_linhas >>
    OBORNO – nº encomenda
    OBPONR – linha encomenda
    OBITNO – artigo
    OBITDS – descrição
    OBORQT – qtd encomendada
    MMUNMS – UM base
    OBSAPR – preço venda
    OBSPUN – UM venda
    OBDIP1 – desc1
    OBDIP2 – desc2
    OBDIP3 – desc3
    OBDIP4 – desc4
    OBDWDT – data pretendida de entrega
    OBRGDT – data encomenda (linha)
*************************
*************************/

namespace App\Http\Controllers;

use App\Lamimail;
use App\LamimailOrders;
use App\LamimailLines;
use Illuminate\Http\Request;
use Illuminate\Support\Facades\Validator;
use Illuminate\Support\Facades\Mail;
use App\Mail\NewOrdersRegistered;
use PDO;
use DB;
use Auth;


class LamimailController extends Controller
{
    /**
     * Instantiate a new controller instance.
     *
     * @return void
     */
    public function __construct()
    {
        // calls the middleware: SetDatabaseConnection
        $this->middleware('SetDatabaseConnection:lamimail');
    }

    public function cronjobs ()
    {
        return view('lamimail.cronjobs');
    }

    /**
     * Obtem todas as encomendas (+linhas) em aberto no AS400 e insere na db caso não existam
     */
    public function cronjob1_execute ()
    {
        // Obtem os Utilizadores do Grupo Expedição
        $utilizadores_expedic = DB::connection('lamiapps')->table('tbl_users')->select('email')->where('group_id', '=', 3)->get();

        //dd($utilizadores_expedic[0]->name);
        Mail::to($utilizadores_expedic->email)->send(new NewOrdersRegistered('', ''));
        dd('end');
    }

    /**
     * Display a listing of the resource.
     *
     * @return \Illuminate\Http\Response
     */
    public function index()
    {
        return view('lamimail.index');
    }

    /**
     * Show the form for creating a new resource.
     *
     * @return \Illuminate\Http\Response
     */
    public function create()
    {
        //
    }

    /**
     * Store a newly created resource in storage.
     *
     * @param  \Illuminate\Http\Request  $request
     * @return \Illuminate\Http\Response
     */
    public function store(Request $request)
    {
        //
    }

    /**
     * Display the specified resource.
     *
     * @param  \App\Lamimail  $lamimail
     * @return \Illuminate\Http\Response
     */
    public function show(Lamimail $lamimail)
    {
        //
    }

    /**
     * Show the form for editing the specified resource.
     *
     * @param  \App\Lamimail  $lamimail
     * @return \Illuminate\Http\Response
     */
    public function edit(Lamimail $lamimail)
    {
        //
    }

    /**
     * Update the specified resource in storage.
     *
     * @param  \Illuminate\Http\Request  $request
     * @param  \App\Lamimail  $lamimail
     * @return \Illuminate\Http\Response
     */
    public function update(Request $request, Lamimail $lamimail)
    {
        //
    }

    /**
     * Remove the specified resource from storage.
     *
     * @param  \App\Lamimail  $lamimail
     * @return \Illuminate\Http\Response
     */
    public function destroy(Lamimail $lamimail)
    {
        //
    }
}