@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