@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","buttonGlyphicon":"","relationshipReferenceClassName":"CadastroDeEmpresa","relationshipReferenceCleanName":"nome_da_empresa","className":"Empresa","cleanName":"empresa"},{"name":"Detalhamento da Educa\u00e7\u00e3o Continuada","type":"section","size":12,"auto_fill_fields":false,"disabled":false,"note":null,"value":null,"className":"DetalhamentoDaEducacaoContinuada","cleanName":"detalhamento_da_educacao"},{"name":"Nome do Treinamento","type":"text","size":"4","auto_fill_fields":false,"buttonGlyphicon":"","actions_advanced":true,"className":"NomeDoTreinamento","cleanName":"nome_do_treinamento"},{"name":"Tipo","type":"select","size":"2","auto_fill_fields":false,"buttonGlyphicon":"","disabled":false,"note":null,"value":null,"relationship":"Tipo de Treinamento","relationship_reference":"Tipo","actions_advanced":true,"exibeFiltros":true,"select_enable_create":true,"alias":"Tipo do Treinamento","relationshipReferenceClassName":"TipoDeTreinamento","relationshipReferenceCleanName":"tipo","className":"Tipo","cleanName":"tipo"},{"name":"Carga Hor\u00e1ria","type":"text","size":"2","auto_fill_fields":false,"buttonGlyphicon":"","actions_advanced":true,"alias":"Carga Hor\u00e1ria (Em minutos)","description":"Em minutos","className":"CargaHoraria","cleanName":"carga_horaria"},{"name":"Data","type":"date","size":"2","auto_fill_fields":false,"disabled":false,"note":null,"value":null,"class":"date","buttonGlyphicon":"","actions_advanced":true,"exibeFiltros":true,"className":"Data","cleanName":"data"},{"name":"N\u00famero de Participantes","type":"number","size":"2","auto_fill_fields":false,"disabled":false,"note":null,"value":null,"className":"NumeroDeParticipantes","cleanName":"numero_de_participantes"},{"name":"Int ou Ext","type":"selectbox","options":["Interno","Externo"],"size":"2","auto_fill_fields":false,"buttonGlyphicon":"","actions_advanced":true,"alias":"Interno ou Externo?","disabled":false,"note":null,"value":null,"className":"IntOuExt","cleanName":"int_ou_ext"}]',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($treinamentos 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'] .= '
'.$tcf['name'].':
'.(!empty($list->$cleanName)?$list->$cleanName:'---').'
';
// :: 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'] .= '
'.$tcf['name'].':
'.($list->$className?$list->$className->$relationshipReferenceCleanName:'---').'
';
// :: 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'] .= '
'.$tcf['name'].':
'.(!empty($list->$Get_Options())?$list->$Get_Options():'---').'
';
// :: Data
}elseif(isset($tcf['type']) and $tcf['type'] == 'data'){
$cleanName = $tcf['cleanName'];
$quadros[$list->$kanban_field]['item'][$key]['title'] .= '
'.$tcf['name'].':
'.(!empty($list->$cleanName)?$list->$cleanName:'---').'
';
// :: Data e Hora
}elseif(isset($tcf['type']) and $tcf['type'] == 'dataehora'){
$cleanName = $tcf['cleanName'];
$quadros[$list->$kanban_field]['item'][$key]['title'] .= '
'.$tcf['name'].':
'.(!empty($list->$cleanName)?$list->$cleanName:'---').'
';
// :: Hora
}elseif(isset($tcf['type']) and $tcf['type'] == 'hora'){
$cleanName = $tcf['cleanName'];
$quadros[$list->$kanban_field]['item'][$key]['title'] .= '
'.$tcf['name'].':
'.(!empty($list->$cleanName)?$list->$cleanName:'---').'
';
// :: Data / Date - Pop Up
}elseif(isset($tcf['type']) and $tcf['type'] == 'date'){
$cleanName = $tcf['cleanName'];
$quadros[$list->$kanban_field]['item'][$key]['title'] .= '
'.$tcf['name'].':
'.(!empty($list->$cleanName)?date("d/m/Y", strtotime($list->$cleanName)):'---').'
';
// :: Data e Hora / Datetime - Pop Up
}elseif(isset($tcf['type']) and $tcf['type'] == 'datetime'){
$cleanName = $tcf['cleanName'];
$quadros[$list->$kanban_field]['item'][$key]['title'] .= '
'.$tcf['name'].':
'.((!empty($list->$cleanName) and (bool)strtotime($list->$cleanName))?date("d/m/Y H:i", strtotime($list->$cleanName)):'---').'
';
// :: Data e Hora Automático / Dataehoraauto
}elseif(isset($tcf['type']) and $tcf['type'] == 'dataehoraauto'){
$cleanName = $tcf['cleanName'];
$quadros[$list->$kanban_field]['item'][$key]['title'] .= '
'.$tcf['name'].':
'.((!empty($list->$cleanName) and (bool)strtotime($list->$cleanName))?date("d/m/Y H:i", strtotime($list->$cleanName)):'---').'
';
// :: CNPJ
}elseif(isset($tcf['type']) and $tcf['type'] == 'cnpj'){
$cleanName = $tcf['cleanName'];
$quadros[$list->$kanban_field]['item'][$key]['title'] .= '
'.$tcf['name'].':
'.(!empty($list->$cleanName)?$list->$cleanName:'---').'
';
// :: CPF
}elseif(isset($tcf['type']) and $tcf['type'] == 'cpf'){
$cleanName = $tcf['cleanName'];
$quadros[$list->$kanban_field]['item'][$key]['title'] .= '
'.$tcf['name'].':
'.(!empty($list->$cleanName)?$list->$cleanName:'---').'
';
// :: E-mail
}elseif(isset($tcf['type']) and $tcf['type'] == 'email'){
$cleanName = $tcf['cleanName'];
$quadros[$list->$kanban_field]['item'][$key]['title'] .= '
'.$tcf['name'].':
'.(!empty($list->$cleanName)?$list->$cleanName:'---').'
';
// :: Dinheiro R$ / Money
}elseif(isset($tcf['type']) and $tcf['type'] == 'money'){
$cleanName = $tcf['cleanName'];
$quadros[$list->$kanban_field]['item'][$key]['title'] .= '
'.$tcf['name'].':
'.(!empty($list->$cleanName)?number_format($list->$cleanName,2,'.',''):'---').'
';
// :: Cálculo / calculo
}elseif(isset($tcf['type']) and $tcf['type'] == 'calculo'){
$cleanName = $tcf['cleanName'];
$quadros[$list->$kanban_field]['item'][$key]['title'] .= '
'.$tcf['name'].':
'.(!empty($list->$cleanName)?number_format($list->$cleanName,2,'.',''):'---').'
';
// :: Numérico / number
}elseif(isset($tcf['type']) and $tcf['type'] == 'number'){
$cleanName = $tcf['cleanName'];
$quadros[$list->$kanban_field]['item'][$key]['title'] .= '
'.$tcf['name'].':
'.(!empty($list->$cleanName)?$list->$cleanName:'---').'
';
// :: Cep
}elseif(isset($tcf['type']) and $tcf['type'] == 'cep'){
$cleanName = $tcf['cleanName'];
$quadros[$list->$kanban_field]['item'][$key]['title'] .= '
'.$tcf['name'].':
'.(!empty($list->$cleanName)?$list->$cleanName:'---').'
';
// :: 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 = ' ';
}
$quadros[$list->$kanban_field]['item'][$key]['title'] .= '
'.$tcf['name'].':
'.$campo_value.'
';
}
}catch(\Exception $e){ }
}
}
$quadros[$list->$kanban_field]['item'][$key]['title'] .= '
';
}
$quadros = array_values($quadros);
foreach($quadros as $key => $q){ $quadros[$key]['item'] = array_values($q['item']); }
// - ::
$boards_list = json_encode(array_values($quadros));
@endphp
@if(\App\Models\Permissions::permissaoUsuario(\Auth::user(), "$controller@store") OR $isPublic)
Cadastrar
@endif
{{--
{{ print_r($td_colunas_fields) }}
--}}
@section('script')
@endsection