@php

    if(env('FILESYSTEM_DRIVER') == 's3'){
        $fileurlbase = env('URLS3') . '/' . env('FILEKEY') . '/';
    }else{
        $fileurlbase = env('APP_URL') . '/';
    }

    $td_colunas_fields_key  = [];
    $td_colunas_fields      = json_decode('[{"name":"Empresa","type":"select","size":"12","auto_fill_fields":false,"disabled":false,"note":null,"value":null,"relationship":"Cadastro de Empresa","relationship_reference":"Nome da Empresa","relationshipReferenceClassName":"CadastroDeEmpresa","relationshipReferenceCleanName":"nome_da_empresa","className":"Empresa","cleanName":"empresa"},{"name":"id","type":"number","size":"1","auto_fill_fields":false,"disabled":true,"note":null,"value":null,"actions_advanced":true,"buttonGlyphicon":"","className":"Id","cleanName":"id"},{"name":"Colaborador","type":"select","size":"3","auto_fill_fields":true,"disabled":false,"note":null,"value":null,"relationship":"Cadastro de Funcion\u00e1rios","relationship_reference":"Nome Completo","buttonGlyphicon":"","actions_advanced":true,"exibeFiltros":true,"relationshipReferenceClassName":"CadastroDeFuncionarios","relationshipReferenceCleanName":"nome_completo","className":"Colaborador","cleanName":"colaborador"},{"name":"Cargo","type":"select","size":"2","auto_fill_fields":false,"disabled":false,"note":null,"value":null,"relationship":"Cargos","relationship_reference":"Cargos","buttonGlyphicon":"","actions_advanced":true,"exibeFiltros":true,"relationshipReferenceClassName":"Cargos","relationshipReferenceCleanName":"cargos","className":"Cargo","cleanName":"cargo"},{"name":"Data Admissao","type":"date","size":"2","auto_fill_fields":false,"buttonGlyphicon":"","disabled":false,"note":null,"value":null,"class":"date","actions_advanced":true,"exibeFiltros":true,"operatorfield":false,"aliasBetween":"&","className":"DataAdmissao","cleanName":"data_admissao"},{"name":"L\u00edder","type":"text","size":"3","auto_fill_fields":false,"buttonGlyphicon":"","className":"Lider","cleanName":"lider"},{"name":"Dias 90","type":"date","size":"2","auto_fill_fields":false,"buttonGlyphicon":"","actions_advanced":true,"alias":"90 Dias","disabled":false,"note":null,"value":null,"class":"date","className":"Dias90","cleanName":"dias_90"},{"name":"Realizados90","type":"selectbox","options":["Sim","N\u00e3o"],"size":"2","auto_fill_fields":false,"buttonGlyphicon":"","actions_advanced":true,"alias":"Realizados?","disabled":false,"note":null,"value":null,"class":"dataehoraauto","className":"Realizados90","cleanName":"realizados90"},{"name":"1. Recep\u00e7\u00e3o da Empresa","type":"section","size":12,"auto_fill_fields":false,"disabled":false,"note":null,"value":null,"className":"1RecepcaoDaEmpresa","cleanName":"1_recepcao_da_empresa"},{"name":"rp1","type":"selectbox","options":["\u00d3timo","Bom","Regular"],"size":"2","auto_fill_fields":false,"actions_advanced":true,"alias":"Resposta","buttonGlyphicon":"","disabled":false,"note":null,"value":null,"className":"Rp1","cleanName":"rp1"},{"name":"Obs 1","type":"text","size":"12","auto_fill_fields":false,"buttonGlyphicon":"","actions_advanced":true,"alias":"Observa\u00e7\u00e3o","className":"Obs1","cleanName":"obs_1"},{"name":"2. Treinamento Inicial","type":"section","size":12,"auto_fill_fields":false,"buttonGlyphicon":"","disabled":false,"note":null,"value":null,"className":"2TreinamentoInicial","cleanName":"2_treinamento_inicial"},{"name":"rp22","type":"selectbox","options":["\u00d3timo","Bom","Regular"],"size":"2","auto_fill_fields":false,"actions_advanced":true,"buttonGlyphicon":"","alias":"90 Dias","disabled":false,"note":null,"value":null,"className":"Rp22","cleanName":"rp22"},{"name":"Obs 2","type":"text","size":"12","auto_fill_fields":false,"actions_advanced":true,"alias":"Observa\u00e7\u00e3o","buttonGlyphicon":"","className":"Obs2","cleanName":"obs_2"},{"name":"3. Realiza sem Suporte","type":"section","size":12,"auto_fill_fields":false,"disabled":false,"note":null,"value":null,"className":"3RealizaSemSuporte","cleanName":"3_realiza_sem_suporte"},{"name":"rp22","type":"selectbox","options":["Sim","N\u00e3o"],"size":"2","auto_fill_fields":false,"buttonGlyphicon":"","actions_advanced":true,"alias":"90 Dias","disabled":false,"note":null,"value":null,"className":"Rp22","cleanName":"rp22"},{"name":"Obs 3","type":"text","size":"12","auto_fill_fields":false,"actions_advanced":true,"alias":"Observa\u00e7\u00e3o","buttonGlyphicon":"","className":"Obs3","cleanName":"obs_3"},{"name":"4. Relacionamento com L\u00edder","type":"section","size":12,"auto_fill_fields":false,"disabled":false,"note":null,"value":null,"className":"4RelacionamentoComLider","cleanName":"4_relacionamento_com_lid"},{"name":"rp42","type":"selectbox","options":["\u00d3timo","Bom","Regular"],"size":"2","auto_fill_fields":false,"buttonGlyphicon":"","actions_advanced":true,"alias":"90 Dias","disabled":false,"note":null,"value":null,"className":"Rp42","cleanName":"rp42"},{"name":"Obs 4","type":"text","size":"12","auto_fill_fields":false,"buttonGlyphicon":"","actions_advanced":true,"alias":"Observa\u00e7\u00e3o","className":"Obs4","cleanName":"obs_4"},{"name":"5. Relacionamento com Colegas","type":"section","size":12,"auto_fill_fields":false,"disabled":false,"note":null,"value":null,"className":"5RelacionamentoComColegas","cleanName":"5_relacionamento_com_col"},{"name":"rp52","type":"selectbox","options":["\u00d3timo","Bom","Regular"],"size":"2","auto_fill_fields":false,"buttonGlyphicon":"","actions_advanced":true,"alias":"90 Dias","disabled":false,"note":null,"value":null,"className":"Rp52","cleanName":"rp52"},{"name":"Obs 5","type":"text","size":"12","auto_fill_fields":false,"actions_advanced":true,"alias":"Observa\u00e7\u00e3o","buttonGlyphicon":"","className":"Obs5","cleanName":"obs_5"},{"name":"6. Sal\u00e1rio e benef\u00edcio","type":"section","size":12,"auto_fill_fields":false,"disabled":false,"note":null,"value":null,"className":"6SalarioEBeneficio","cleanName":"6_salario_e_beneficio"},{"name":"rp62","type":"selectbox","options":["\u00d3timo","Bom","Regular"],"size":"2","auto_fill_fields":false,"buttonGlyphicon":"","actions_advanced":true,"alias":"90 Dias","disabled":false,"note":null,"value":null,"className":"Rp62","cleanName":"rp62"},{"name":"Obs 6","type":"text","size":"12","auto_fill_fields":false,"actions_advanced":true,"alias":"Observa\u00e7\u00e3o","className":"Obs6","cleanName":"obs_6"},{"name":"7. Nota","type":"section","size":12,"auto_fill_fields":false,"disabled":false,"note":null,"value":null,"className":"7Nota","cleanName":"7_nota"},{"name":"rp72","type":"number","size":"2","auto_fill_fields":false,"actions_advanced":true,"alias":"90 Dias","description":"De 0 a 10","disabled":false,"note":null,"value":null,"buttonGlyphicon":"","className":"Rp72","cleanName":"rp72"}]',true);
    foreach($td_colunas_fields as $tcf){ $td_colunas_fields_key[$tcf['cleanName']] = $tcf; }
    // :: Buscando Opções de Quadro
    $quadros                = [];
    $quadros_options        = [];

    // ! Tipo -> Seleção
    if($td_colunas_fields_key[$kanban_field]['type'] == 'selectbox'){
        $Get_Options            = 'Get_options_'.$kanban_field;
        if(method_exists($controller_model,$Get_Options)){
            $quadros_options    = $controller_model::$Get_Options();
        }

    // ! Tipo -> Relacionamento
    }elseif($td_colunas_fields_key[$kanban_field]['type'] == 'select'){
        $Get_relationship           = "\\App\\Models\\".$td_colunas_fields_key[$kanban_field]['relationshipReferenceClassName'];
        $Get_relationship_reference = $td_colunas_fields_key[$kanban_field]['relationshipReferenceCleanName'];
        $Get_Options                = $Get_relationship::kanban_list(10000, $Get_relationship_reference);
        $quadros_options            = $Get_Options->toArray();
    }

    foreach($quadros_options as $key => $qo){
        $quadros[$key]['id']     = (string) $key;
        $quadros[$key]['title']  = (in_array($key,[0,''])?'Início':$qo);
        $quadros[$key]['item']   = [];
    }

    foreach($av_de_experiencia_90 as $key => $list){

        // ! Verifica se o 'Registro' possuí 'Status' caso contrário = (null,0,'')
        // atribuí para o 'Início' posição = 0
        $list->$kanban_field = (in_array($list->$kanban_field,[null,0,''])?0:$list->$kanban_field);

        $quadros[$list->$kanban_field]['item'][$key]['column'] = (string) $kanban_field;
        $quadros[$list->$kanban_field]['item'][$key]['id']     = (string) $list->id;
        $quadros[$list->$kanban_field]['item'][$key]['title']  = '';

        if(is_array($td_colunas_fields)){
            foreach($td_colunas_fields as $tcf){
                if(
                    (isset($tcf['hidden_view']) && $tcf['hidden_view']) ||
                    ($td_colunas_fields_key[$kanban_field]['type'] == 'select' and $tcf['cleanName'] == $kanban_field)
                ){ continue; }

                try {
                    // :: Texto
                    if(isset($tcf['type']) and $tcf['type'] == 'text'){
                        $cleanName = $tcf['cleanName'];
                        $quadros[$list->$kanban_field]['item'][$key]['title'] .= '
                            <div class="kanban-box-columns">
                                <div class="kanban-bc-campo">'.$tcf['name'].':</div>
                                <div class="kanban-bc-campo-value">'.(!empty($list->$cleanName)?$list->$cleanName:'---').'</div>
                            </div>';
                    // :: Relacionamento
                    }elseif(isset($tcf['type']) and $tcf['type'] == 'select' and isset($tcf['className']) and isset($tcf['relationshipReferenceCleanName'])){
                        $cleanName = $tcf['cleanName'];
                        $className = $tcf['className'];
                        $relationshipReferenceCleanName = $tcf['relationshipReferenceCleanName'];
                        $quadros[$list->$kanban_field]['item'][$key]['title'] .= '
                            <div class="kanban-box-columns">
                                <div class="kanban-bc-campo">'.$tcf['name'].':</div>
                                <div class="kanban-bc-campo-value">'.($list->$className?$list->$className->$relationshipReferenceCleanName:'---').'</div>
                            </div>';
                    // :: Caixa de Seleção
                    }elseif(isset($tcf['type']) and $tcf['type'] == 'selectbox' and isset($tcf['cleanName'])){
                        $cleanName      = $tcf['cleanName'];
                        $Get_Options    = 'Get_'.$cleanName;
                        $quadros[$list->$kanban_field]['item'][$key]['title'] .= '
                            <div class="kanban-box-columns">
                                <div class="kanban-bc-campo">'.$tcf['name'].':</div>
                                <div class="kanban-bc-campo-value">'.(!empty($list->$Get_Options())?$list->$Get_Options():'---').'</div>
                            </div>';
                    // :: Data
                    }elseif(isset($tcf['type']) and $tcf['type'] == 'data'){
                        $cleanName      = $tcf['cleanName'];
                        $quadros[$list->$kanban_field]['item'][$key]['title'] .= '
                            <div class="kanban-box-columns">
                                <div class="kanban-bc-campo">'.$tcf['name'].':</div>
                                <div class="kanban-bc-campo-value">'.(!empty($list->$cleanName)?$list->$cleanName:'---').'</div>
                            </div>';

                    // :: Data e Hora
                    }elseif(isset($tcf['type']) and $tcf['type'] == 'dataehora'){
                        $cleanName      = $tcf['cleanName'];
                        $quadros[$list->$kanban_field]['item'][$key]['title'] .= '
                            <div class="kanban-box-columns">
                                <div class="kanban-bc-campo">'.$tcf['name'].':</div>
                                <div class="kanban-bc-campo-value">'.(!empty($list->$cleanName)?$list->$cleanName:'---').'</div>
                            </div>';

                    // :: Hora
                    }elseif(isset($tcf['type']) and $tcf['type'] == 'hora'){
                        $cleanName      = $tcf['cleanName'];
                        $quadros[$list->$kanban_field]['item'][$key]['title'] .= '
                            <div class="kanban-box-columns">
                                <div class="kanban-bc-campo">'.$tcf['name'].':</div>
                                <div class="kanban-bc-campo-value">'.(!empty($list->$cleanName)?$list->$cleanName:'---').'</div>
                            </div>';

                    // :: Data / Date - Pop Up
                    }elseif(isset($tcf['type']) and $tcf['type'] == 'date'){
                        $cleanName      = $tcf['cleanName'];
                        $quadros[$list->$kanban_field]['item'][$key]['title'] .= '
                            <div class="kanban-box-columns">
                                <div class="kanban-bc-campo">'.$tcf['name'].':</div>
                                <div class="kanban-bc-campo-value">'.(!empty($list->$cleanName)?date("d/m/Y", strtotime($list->$cleanName)):'---').'</div>
                            </div>';

                    // :: Data e Hora / Datetime - Pop Up
                    }elseif(isset($tcf['type']) and $tcf['type'] == 'datetime'){
                        $cleanName      = $tcf['cleanName'];
                        $quadros[$list->$kanban_field]['item'][$key]['title'] .= '
                            <div class="kanban-box-columns">
                                <div class="kanban-bc-campo">'.$tcf['name'].':</div>
                                <div class="kanban-bc-campo-value">'.((!empty($list->$cleanName) and (bool)strtotime($list->$cleanName))?date("d/m/Y H:i", strtotime($list->$cleanName)):'---').'</div>
                            </div>';

                    // :: Data e Hora Automático / Dataehoraauto
                    }elseif(isset($tcf['type']) and $tcf['type'] == 'dataehoraauto'){
                        $cleanName      = $tcf['cleanName'];
                        $quadros[$list->$kanban_field]['item'][$key]['title'] .= '
                            <div class="kanban-box-columns">
                                <div class="kanban-bc-campo">'.$tcf['name'].':</div>
                                <div class="kanban-bc-campo-value">'.((!empty($list->$cleanName) and (bool)strtotime($list->$cleanName))?date("d/m/Y H:i", strtotime($list->$cleanName)):'---').'</div>
                            </div>';

                    // :: CNPJ
                    }elseif(isset($tcf['type']) and $tcf['type'] == 'cnpj'){
                        $cleanName      = $tcf['cleanName'];
                        $quadros[$list->$kanban_field]['item'][$key]['title'] .= '
                            <div class="kanban-box-columns">
                                <div class="kanban-bc-campo">'.$tcf['name'].':</div>
                                <div class="kanban-bc-campo-value">'.(!empty($list->$cleanName)?$list->$cleanName:'---').'</div>
                            </div>';

                    // :: CPF
                    }elseif(isset($tcf['type']) and $tcf['type'] == 'cpf'){
                        $cleanName      = $tcf['cleanName'];
                        $quadros[$list->$kanban_field]['item'][$key]['title'] .= '
                            <div class="kanban-box-columns">
                                <div class="kanban-bc-campo">'.$tcf['name'].':</div>
                                <div class="kanban-bc-campo-value">'.(!empty($list->$cleanName)?$list->$cleanName:'---').'</div>
                            </div>';

                    // :: E-mail
                    }elseif(isset($tcf['type']) and $tcf['type'] == 'email'){
                        $cleanName      = $tcf['cleanName'];
                        $quadros[$list->$kanban_field]['item'][$key]['title'] .= '
                            <div class="kanban-box-columns">
                                <div class="kanban-bc-campo">'.$tcf['name'].':</div>
                                <div class="kanban-bc-campo-value">'.(!empty($list->$cleanName)?$list->$cleanName:'---').'</div>
                            </div>';

                    // :: Dinheiro R$ / Money
                    }elseif(isset($tcf['type']) and $tcf['type'] == 'money'){
                        $cleanName      = $tcf['cleanName'];
                        $quadros[$list->$kanban_field]['item'][$key]['title'] .= '
                            <div class="kanban-box-columns">
                                <div class="kanban-bc-campo">'.$tcf['name'].':</div>
                                <div class="kanban-bc-campo-value">'.(!empty($list->$cleanName)?number_format($list->$cleanName,2,'.',''):'---').'</div>
                            </div>';

                    // :: Cálculo / calculo
                    }elseif(isset($tcf['type']) and $tcf['type'] == 'calculo'){
                        $cleanName      = $tcf['cleanName'];
                        $quadros[$list->$kanban_field]['item'][$key]['title'] .= '
                            <div class="kanban-box-columns">
                                <div class="kanban-bc-campo">'.$tcf['name'].':</div>
                                <div class="kanban-bc-campo-value">'.(!empty($list->$cleanName)?number_format($list->$cleanName,2,'.',''):'---').'</div>
                            </div>';

                    // :: Numérico / number
                    }elseif(isset($tcf['type']) and $tcf['type'] == 'number'){
                        $cleanName      = $tcf['cleanName'];
                        $quadros[$list->$kanban_field]['item'][$key]['title'] .= '
                            <div class="kanban-box-columns">
                                <div class="kanban-bc-campo">'.$tcf['name'].':</div>
                                <div class="kanban-bc-campo-value">'.(!empty($list->$cleanName)?$list->$cleanName:'---').'</div>
                            </div>';

                    // :: Cep
                    }elseif(isset($tcf['type']) and $tcf['type'] == 'cep'){
                        $cleanName      = $tcf['cleanName'];
                        $quadros[$list->$kanban_field]['item'][$key]['title'] .= '
                            <div class="kanban-box-columns">
                                <div class="kanban-bc-campo">'.$tcf['name'].':</div>
                                <div class="kanban-bc-campo-value">'.(!empty($list->$cleanName)?$list->$cleanName:'---').'</div>
                            </div>';

                    // :: Upload / file
                    }elseif(isset($tcf['type']) and $tcf['type'] == 'file'){
                        $cleanName         = $tcf['cleanName'];
                        $campo_value       = '---';
                        if(!empty($list->$cleanName) and count(explode(".", $list->$cleanName)) >= 2){
                            $campo_href    = (in_array(explode(".", $list->$cleanName)[1], array("jpg", "jpeg", "gif", "png", "bmp", "mp4", "pdf", "doc", "docx", "rar", "zip", "txt", "7zip", "csv", "xls", "xlsx")) ? $fileurlbase . "images/" . $list->$cleanName : "javascript:void(0);");
                            $campo_img_src = (in_array(explode(".", $list->$cleanName)[1], array("mp4", "pdf", "doc", "docx", "rar", "zip", "txt", "7zip", "csv", "xls", "xlsx")) ? explode(".", $list->$cleanName)[1] . "-icon.png" : $fileurlbase . "images/" . $list->$cleanName);
                            $campo_value   = '<a class="fancybox" rel="gallery1" target="_blank" href="'.$campo_href.'"><img src="'.$campo_img_src.'" style="max-width: 200px; max-height: 70px; height: auto; width: auto; margin-top: 2px;" /></a>';
                        }
                        $quadros[$list->$kanban_field]['item'][$key]['title'] .= '
                            <div class="kanban-box-columns">
                                <div class="kanban-bc-campo">'.$tcf['name'].':</div>
                                <div class="kanban-bc-campo-value">'.$campo_value.'</div>
                            </div>';
                    }
                }catch(\Exception $e){ }
            }
        }

        $quadros[$list->$kanban_field]['item'][$key]['title']     .= '
            <div class="kanban-buttons text-right">
                <button modulo="av_de_experiencia_90" modulo_id="'.$list->id.'" modulo_method="GET" modulo_url="av_de_experiencia_90/'.$list->id.'/edit" modulo_redirect="true" class="btn btn-xs btn-default kanban-btn-edit"><i class="glyphicon glyphicon-edit" title="Editar"></i></button>
                <button modulo="av_de_experiencia_90" modulo_id="'.$list->id.'" modulo_method="GET" modulo_url="av_de_experiencia_90/'.$list->id.'/copy" modulo_redirect="true" class="btn btn-xs btn-default kanban-btn-copy"><i class="glyphicon glyphicon-copy" title="Duplicar linha"></i></button>
                <button modulo="av_de_experiencia_90" modulo_id="'.$list->id.'" modulo_method="GET" modulo_url="av_de_experiencia_90/'.$list->id.'" modulo_redirect="true" class="btn btn-xs btn-default kanban-btn-view"><i class="glyphicon glyphicon-eye-open" title="Visualizar"></i></button>
                <button modulo="av_de_experiencia_90" modulo_id="'.$list->id.'" class="btn btn-xs btn-danger excluir-auto-confirma" style="float:none;margin: 0px;" title="Excluir"><i class="glyphicon glyphicon-trash"></i></button>
            </div>
        ';
    }
    $quadros = array_values($quadros);
    foreach($quadros as $key => $q){ $quadros[$key]['item'] = array_values($q['item']); }
    // - ::

    $boards_list = json_encode(array_values($quadros));
@endphp
<div class="form-group form-group-btn-index text-right">
    @if(\App\Models\Permissions::permissaoUsuario(\Auth::user(), "$controller@store") OR $isPublic)
        <a href="{{ URL('/') }}/av_de_experiencia_90/create" class="btn btn-default form-group-btn-index-cadastrar"><i class="glyphicon glyphicon-plus"></i> Cadastrar</a>
    @endif
</div>
<div style="clear:both;"></div>
{{--
<div id="DEBUG" style="display:none;">
    {{ print_r($td_colunas_fields) }}
</div>
--}}
<section>
    <div id="app_kanban">
    </div>
</section>

@section('script')

    <script type="text/javascript">
        var kanban1 = new jKanban({
            element:'#app_kanban',
            addItemButton: false,
            gutter           : '15px',
            widthBoard       : '250px',
            responsivePercentage: false,
            itemAddOptions: {},
            itemHandleOptions: {},
            click            : function (el) {  },
            context          : function (el, event) {  },
            dropEl           : function (el, target, source, sibling) {
                //console.log('el: '+ el); console.log('target: '+ target); console.log('source: '+ source); console.log('sibling: '+ sibling);
                let item_id         = $(el).attr("data-eid");
                let item_column     = $(el).attr("data-column");
                let item_target_id  = $(target).closest('.kanban-board').attr("data-id");
                let item_source_id  = $(source).closest('.kanban-board').attr("data-id");
                // Verifico se está no mesmo Quadro
                if($(target).find('[data-eid=\"'+item_id+'\"]').length && $(source).find('[data-eid=\"'+item_id+'\"]').length){ return false; }
                //console.log('item_id: '+ item_id); console.log('item_column: '+ item_column); console.log('item_target_id: '+ item_target_id); console.log('item_source_id: '+ item_source_id);
                let data = {
                    '_method': 'PUT',
                    '_token': $("meta[name=\'csrf-token\']").attr('content'),
                    'id': item_id,
                    'update_kanban': 1,
                    'item_column': item_column,
                    'item_target_id': item_target_id,
                    'item_source_id': item_source_id
                }
                //console.log('---- data ----'); console.log(data);
                let ajax_return = false;
                $.ajax({
                    dataType: 'json',
                    type: 'POST',
                    async: false,
                    url: base+'/av_de_experiencia_90/'+item_id,
                    data: data,
                    success: function(d){
                        if(d.ok != undefined){
                            ajax_return = true;
                        }
                    },
                    error: function(xhr, statusText, errorThrown){
                        d = xhr.responseJSON;
                        ajax_return = false;
                        console.log('KB Quadro | Error: ' + statusText,xhr);
                        if(d.error != undefined){ alert(d.error); }
                    }
                });
                return ajax_return;
            },
            dragendEl        : function (el) { },
            dragBoard        : function (el, source) { },
            dragendBoard     : function (el) { },
            buttonClick      : function(el, boardId) { },
            propagationHandlers: [],
            dragBoards       : false,
            dragItems        : true,
            boards           : {!! $boards_list !!}
        });

        RA.load.form_acoes($('.kanban-btn-edit'));
        RA.load.form_acoes($('.kanban-btn-copy'));
        RA.load.form_acoes($('.kanban-btn-view'));
        RA.onload();
    </script>

@endsection