<?php

namespace App\Http\Controllers;
use Illuminate\Http\Request;
use App\Http\Requests\LambdaRequest;
use App\Models\MessageSend;
use App\Models\MessageTemplate;
use App\Models\Session;
use DB;

class MsgsendController extends LocalController
{
    public function __construct()
    {
        $this->middleware('auth');
        $this->_service = 'mag';
        $this->_module = 'magazine';
        $this->_viewname = 'msgsend';
        $this->_title = 'Send Messages';
        $this->_base_url = '/msgsend';
        $this->_basemodel = new MessageSend;
    }

    protected function get_list_buttons() {
        return [ ['title' => 'Add New', 'link' => $this->_base_url.'/addnew' ] ];
    }

    protected function get_list_data(Request $request) {
        $templa = MessageTemplate::where('status', 'active')->select('id', 'title')->get();
        $templates = [];
        foreach($templa as $d) {
            $templates[$d->id] = $d->title;
        }
        $ssions = Session::where('status', 'active')->select('id', 'number', 'venue')->get();
        $programs = [];
        $vanues = [];
        foreach($ssions as $s) {
            $programs[$s->id] = $s->number;
            $vanues[$s->id] = $s->venue;
        }

        $data = $this->_basemodel->orderby('id', 'desc')->get();
        $dd = [];
        foreach($data->toArray() as $d) {
            $d['title'] = $templates[ $d['template'] ];
            $d['program'] = isset($programs[ $d['session_id'] ]) ? $programs[ $d['session_id'] ] : '-';
            $d['venue'] = isset($vanues[ $d['session_id'] ]) ? $vanues[ $d['session_id'] ] : '-';
            $dd[] = (object)$d;
        }
        //echo '<pre>'; print_r($dd); print_r($vanues); exit;
        return $dd;
    }

    // protected function get_list_data(Request $request) {
    //     $data = DB::table('message_send as ms')->leftjoin('sessions as s', 'ms.')
    //     $dd = [];
    //     foreach($data->toArray() as $d) {
    //         $dd[] = (object)$d;
    //     }
    //     return $dd;
    // }

    protected function get_list_fields(){
        return [
            'actions' => ['title' => 'Actions', 'buttons' => [ 'edit', 'delete' ] ],
            //'type' => ['title' => 'Session Type', 'type' => 'text'],
            'program' => ['title' => 'Program', 'type' => 'text'],
            'venue' => ['title' => 'Venue', 'type' => 'text'],
            'title' => ['title' => 'Template', 'type' => 'text'],
            'created_at' => ['title' => 'Date Sent', 'type' => 'datetime'],
            'status' => ['title' => 'Status', 'type' => 'select'],
        ];
    }

    protected function get_form_fields($type, $values){
        $sessions = Session::where('status', 'active')->select('id', 'number', 'type', 'start_date', 'venue')->orderby('id', 'desc')->get();
        $session_bb = [];
        foreach($sessions as $session){
            $session_bb[$session->id] = $session->type.' ('.$session->number.') '. date("d-m-Y", strtotime($session->start_date)) . ' (' . $session->venue. ')';
        }

        $data = MessageTemplate::where('status', 'active')->select('id', 'title', 'template_body', 'template_code', 'header_params', 'body_params', 'button_params', 'button_url', 'button_label')->get();
        $templates = [];
        $template_data = [];
        foreach($data as $d) {
            $templates[$d->id] = $d->title;
            $template_data[$d->id] = $d;
        }
        //echo '<pre>'; print_r($templates); exit;
        $fields = [
            'session_id' => ['title' => 'Session', 'type' => 'select', 'values' => $session_bb , 'required' => true],
            'template' => ['title' => 'Template', 'type' => 'template', 'values' => $templates , 'template_data' => $template_data, 'required' => true],
            'template_body' => ['title' => 'Template Body', 'type' => 'keywords', 'fullwidth' => true],
            'header_params' => ['title' => 'Header Params (only if changes needed)', 'type' => 'keywords', 'fullwidth' => true],
            'body_params' => ['title' => 'Body Params (only if changes needed)', 'type' => 'keywords', 'fullwidth' => true],
            'button_params' => ['title' => 'Button Params (only if changes needed)', 'type' => 'keywords', 'fullwidth' => true],
            'button_cta' => ['title' => 'Email CTA (from template)', 'type' => 'keywords', 'fullwidth' => true],
            'audience' => ['title' => 'Audience', 'type' => 'select', 'values' => ['all' => 'All', 'attended' => 'Only Attended'] , 'required' => true],
            'status' => ['title' => 'Status', 'type' => 'select', 'required' => true, 'values' => ['active' => 'Active', 'disabled' => 'Disabled'] ],
        ];
        return $fields;
    }

    protected function _beforesave($type, $request) {
        $post = $request->except('_token');
        if(isset($post['header_params'])) $post['header_params'] = implode('||',$post['header_params']);
        if(isset($post['body_params'])) $post['body_params'] = implode('||',$post['body_params']);
        if(isset($post['button_params'])) $post['button_params'] = implode('||',$post['button_params']);
        //echo '<pre>'; print_r($post); exit;
        return $post;
    }
    
}