@php //dump($record_mod,$record_elem) $m=1; $e=1; $record_mod_count=count($record_mod); $record_elem_count=count($record_elem); @endphp /* --------------------------------------------------------------------------------------------------
ATUALIZACAO DO SQL - TEMPLATE DA PERMISSÃO
-- QUANTIDADE DE MOD: {{$record_mod_count}}
-- QUANTIDADE DE ELEM: {{$record_elem_count}}
-- DICAS: ADICIONE ANTES OS MODULOS E OS ELEMENTOS
-------------------------------------------------------------------------------------------------- */

/* EXCLUIR REGISTROS */
DELETE FROM `system_perm_mod_template` WHERE `idPermTemplate` IN ('1','2','3','4');

DELETE FROM `system_perm_elem_template` WHERE `idPermModTemp` IN ('1','2','3','4');


/* ADD REGISTROS */
/* system_perm_mod_template */
INSERT INTO system_perm_mod_template (idMod, idStatusPerm, idPermTemplate) VALUES
@foreach($record_mod as $row_mod) ({{$row_mod->idMod}}, '{{$row_mod->idStatusPerm}}', {{$row_mod->idPermTemplate}}) @if($m==$record_mod_count) ; @else , @endif @php($m++)
@endforeach
/* system_perm_elem_template */
INSERT INTO system_perm_elem_template (idElem, idStatusPerm, idMod, idPermModTemp) VALUES
@foreach($record_elem as $row_elem) ({{$row_elem->idElem}}, {{$row_elem->idStatusPerm}}, {{$row_elem->idMod}}, {{$row_elem->idPermModTemp}})@if($e==$record_elem_count); @else , @endif @php($e++)
@endforeach