Online PHP editor | output for ulOO6

@ 2026-09-02T15:35:18Z

<?php

declare(strict_types=1);

// VM8
$vm[8] = [
    'juridico_adm',
    'juridico_advogo',
    'juridico_alecrimcosta',
    'juridico_bck',
    'juridico_borchardt',
    'juridico_condoconta',
    'juridico_confi',
    'juridico_costaesa',
    'juridico_covoloadvogados',
    'juridico_dejur',
    'juridico_dejur_bkp',
    'juridico_demo',
    'juridico_drumond',
    'juridico_evl',
    'juridico_fva',
    'juridico_galvaoleonardo',
    'juridico_gradv',
    'juridico_gs',
    'juridico_hba',
    'juridico_jairavansi',
    'juridico_jalocacoes',
    'juridico_jgg',
    'juridico_kazapi',
    'juridico_leonato',
    'juridico_marinsbertoldi',
    'juridico_masa',
    'juridico_medeirossantos',
    'juridico_medina',
    'juridico_mme',
    'juridico_monteiro',
    'juridico_mosello',
    'juridico_mvsadv',
    'juridico_nfa',
    'juridico_orr',
    'juridico_padrao',
    'juridico_paglia',
    'juridico_pbds',
    'juridico_pcpadv',
    'juridico_pqadv',
    'juridico_pz',
    'juridico_qmr',
    'juridico_queirozeandrade',
    'juridico_rangelmoreira',
    'juridico_sarturi',
    'juridico_smnadv',
    'juridico_tgs_old',
    'juridico_total',
    'juridico_victorlopes',
    'juridico_vmz',
];

// VM9
$vm[9] = [
    'juridico_baccin',
    'juridico_bortolotto',
    'juridico_casadolima',
    'juridico_cbsprev',
    'juridico_cmcadvogados',
    'juridico_cms',
    'juridico_cosso',
    'juridico_dladv',
    'juridico_dottoreis',
    'juridico_dsmaazulay',
    'juridico_fcar',
    'juridico_frutuoso',
    'juridico_grupooad',
    'juridico_guimaraes',
    'juridico_inpejam',
    'juridico_jnpmadvogados',
    'juridico_laloni',
    'juridico_lbr',
    'juridico_lzadv',
    'juridico_mirandamafra',
    'juridico_pbt',
    'juridico_reiscostaadvogados',
    'juridico_rigon',
    'juridico_rossetto',
    'juridico_senso',
    'juridico_siqueiracastro',
    'juridico_tagliariadvogados',
    'juridico_teste',
    'juridico_ztfadvogados',
    'juridico_zuninoadv',
];

//VM10
$vm[10] = [
    'juridico_abacocalculos',
    'juridico_advocaciapalma',
    'juridico_alvaroalfredo',
    'juridico_amorecuidado',
    'juridico_bobsinvidal',
    'juridico_bp',
    'juridico_brancomiele',
    'juridico_brizolaejapur',
    'juridico_ca',
    'juridico_caasc',
    'juridico_ccbadv',
    'juridico_cemin',
    'juridico_clvadv',
    'juridico_comoregistrar',
    'juridico_condominio',
    'juridico_cupertinocapital',
    'juridico_donaadv',
    'juridico_fasnadv',
    'juridico_gnl',
    'juridico_goulart',
    'juridico_gr',
    'juridico_isaacmiranda',
    'juridico_laecioadv',
    'juridico_mcga',
    'juridico_mortoza',
    'juridico_msa',
    'juridico_quetesadvocacia',
    'juridico_regent',
    'juridico_roneely',
    'juridico_rosajunior',
    'juridico_sarloemachado',
    'juridico_sdvadv',
    'juridico_shr',
    'juridico_sotopietra',
];

//VM11:
$vm[11] = [
    'juridico_assisesiqueira',
    'juridico_cavallazzi',
    'juridico_chavesemaran',
    'juridico_cmmlaw',
    'juridico_gislandia',
    'juridico_jacintolaw',
    'juridico_marciomoraes',
    'juridico_msradvogados',
    'juridico_nascimentomourao',
    'juridico_pereiraeprates',
    'juridico_pradiadvogados',
    'juridico_sobrecontroller',
    'juridico_wecontroll',
];

$vm[12] = [
    'juridico_teste',
];

//Departamentos oculto
//$query = function (string $base): string {
//    return "SELECT '{$base}' AS `base`,"
//        . " (SELECT COUNT(*) FROM `{$base}`.`departamentos` WHERE `flag_oculto` = 1) AS `dep_ocultos`,"
//        . " (SELECT COUNT(*) FROM `{$base}`.`departamentos`) AS `dep_total`;";
//};

//Coordenadores que perdem acesso por departamento oculto
//Retorno: número de coordenadores
//$query = function (string $base): string {
//    return "SELECT '{$base}' AS `base`, COUNT(DISTINCT `dxr`.`usuarios_id`) AS `coord_dep_oculto`"
//        . " FROM `{$base}`.`departamento_x_responsavel` AS `dxr`"
//        . " INNER JOIN `{$base}`.`departamentos` AS `dep`"
//        . " ON `dep`.`departamentos_id` = `dxr`.`departamentos_id`"
//        . " INNER JOIN `{$base}`.`usuarios` AS `u` ON `u`.`usuarios_id` = `dxr`.`usuarios_id`"
//        . " WHERE `dxr`.`flag_oculto` = 0 AND `dxr`.`flag_coordenador` = 1"
//        . " AND `dep`.`flag_oculto` = 1 AND `u`.`flag_oculto` = 0;";
//};

//Supervisores que perdem acesso por departamento oculto
//Retorno: número de supervisores
//$query = function (string $base): string {
//    return "SELECT '{$base}' AS `base`, COUNT(DISTINCT `uxd`.`usuarios_id`) AS `superv_dep_oculto`"
//        . " FROM `{$base}`.`usuarios_x_dep` AS `uxd`"
//        . " INNER JOIN `{$base}`.`departamentos` AS `dep`"
//        . " ON `dep`.`departamentos_id` = `uxd`.`departamentos_id`"
//        . " INNER JOIN `{$base}`.`usuarios` AS `u` ON `u`.`usuarios_id` = `uxd`.`usuarios_id`"
//        . " WHERE `uxd`.`flag_supervisor` = 1"
//        . " AND `dep`.`flag_oculto` = 1 AND `u`.`flag_oculto` = 0;";
//};

//tarefa que hoje é filtrável/editável por coordenador ou supervisor e deixa de ser.
//ao filtrar por um usuário, tarefas cujo processo está em
//departamento oculto deixam de aparecer pelo vínculo coordenador/supervisor
//Retorno: quantidade de tarefas
//$query = function (string $base): string {
//    return "SELECT '{$base}' AS `base`, COUNT(DISTINCT `pxe`.`pxe_id`) AS `tarefas_perdidas`"
//        . " FROM `{$base}`.`processos_x_etapas` AS `pxe`"
//        . " INNER JOIN `{$base}`.`processos` AS `pr` ON `pr`.`processos_id` = `pxe`.`processos_id`"
//        . " INNER JOIN `{$base}`.`departamentos` AS `dep`"
//        . " ON `dep`.`departamentos_id` = `pr`.`departamentos_id`"
//        . " WHERE `pxe`.`flag_oculto` = 0 AND `pr`.`flag_oculto` = 0"
//        . " AND `dep`.`flag_oculto` = 1"
//        . " AND (EXISTS(SELECT 1 FROM `{$base}`.`departamento_x_responsavel` AS `dxr`"
//        . " WHERE `dxr`.`departamentos_id` = `pr`.`departamentos_id`"
//        . " AND `dxr`.`flag_oculto` = 0 AND `dxr`.`flag_coordenador` = 1)"
//        . " OR EXISTS(SELECT 1 FROM `{$base}`.`usuarios_x_dep` AS `uxd`"
//        . " WHERE `uxd`.`departamentos_id` = `pr`.`departamentos_id`"
//        . " AND `uxd`.`flag_supervisor` = 1));";
//};

//Parametro usr_dep_restringe
$query = function (string $base): string {
    return "SELECT '{$base}' AS `base`,"
        . " EXISTS(SELECT 1 FROM (SELECT `sp`.`sys_par_valor` AS `valor`"
        . " FROM `{$base}`.`sys_par` AS `sp`"
        . " WHERE `sp`.`sys_par_nome` = 'usr_dep_restringe' AND `sp`.`flag_oculto` = 0"
        . " ORDER BY `sp`.`sys_par_id` DESC LIMIT 1) AS `ult`"
        . " WHERE TRIM(`ult`.`valor`) NOT IN ('', '0')) AS `restringe_ativo`,"
        . " EXISTS(SELECT 1 FROM `{$base}`.`sys_par_usr` AS `spu`"
        . " INNER JOIN `{$base}`.`sys_par` AS `sp2` ON `sp2`.`sys_par_id` = `spu`.`sys_par_id`"
        . " WHERE `sp2`.`sys_par_nome` = 'usr_dep_restringe' AND `spu`.`flag_oculto` = 0) AS `tem_sobrescrita`;";
};

$nroVm = 11;
foreach ($vm[$nroVm] as $key => $base) {
    echo $query($base) . PHP_EOL;
}

Output for 8.2.31 - 8.2.33, 8.3.0 - 8.3.33, 8.4.1 - 8.4.25, 8.5.0 - 8.5.10: SELECT 'juridico_assisesiqueira' AS `base`, EXISTS(SELECT 1 FROM (SELECT `sp`.`sys_par_valor` AS `valor` FROM `juridico_assisesiqueira`.`sys_par` AS `sp` WHERE `sp`.`sys_par_nome` = 'usr_dep_restringe' AND `sp`.`flag_oculto` = 0 ORDER BY `sp`.`sys_par_id` DESC LIMIT 1) AS `ult` WHERE TRIM(`ult`.`valor`) NOT IN ('', '0')) AS `restringe_ativo`, EXISTS(SELECT 1 FROM `juridico_assisesiqueira`.`sys_par_usr` AS `spu` INNER JOIN `juridico_assisesiqueira`.`sys_par` AS `sp2` ON `sp2`.`sys_par_id` = `spu`.`sys_par_id` WHERE `sp2`.`sys_par_nome` = 'usr_dep_restringe' AND `spu`.`flag_oculto` = 0) AS `tem_sobrescrita`; SELECT 'juridico_cavallazzi' AS `base`, EXISTS(SELECT 1 FROM (SELECT `sp`.`sys_par_valor` AS `valor` FROM `juridico_cavallazzi`.`sys_par` AS `sp` WHERE `sp`.`sys_par_nome` = 'usr_dep_restringe' AND `sp`.`flag_oculto` = 0 ORDER BY `sp`.`sys_par_id` DESC LIMIT 1) AS `ult` WHERE TRIM(`ult`.`valor`) NOT IN ('', '0')) AS `restringe_ativo`, EXISTS(SELECT 1 FROM `juridico_cavallazzi`.`sys_par_usr` AS `spu` INNER JOIN `juridico_cavallazzi`.`sys_par` AS `sp2` ON `sp2`.`sys_par_id` = `spu`.`sys_par_id` WHERE `sp2`.`sys_par_nome` = 'usr_dep_restringe' AND `spu`.`flag_oculto` = 0) AS `tem_sobrescrita`; SELECT 'juridico_chavesemaran' AS `base`, EXISTS(SELECT 1 FROM (SELECT `sp`.`sys_par_valor` AS `valor` FROM `juridico_chavesemaran`.`sys_par` AS `sp` WHERE `sp`.`sys_par_nome` = 'usr_dep_restringe' AND `sp`.`flag_oculto` = 0 ORDER BY `sp`.`sys_par_id` DESC LIMIT 1) AS `ult` WHERE TRIM(`ult`.`valor`) NOT IN ('', '0')) AS `restringe_ativo`, EXISTS(SELECT 1 FROM `juridico_chavesemaran`.`sys_par_usr` AS `spu` INNER JOIN `juridico_chavesemaran`.`sys_par` AS `sp2` ON `sp2`.`sys_par_id` = `spu`.`sys_par_id` WHERE `sp2`.`sys_par_nome` = 'usr_dep_restringe' AND `spu`.`flag_oculto` = 0) AS `tem_sobrescrita`; SELECT 'juridico_cmmlaw' AS `base`, EXISTS(SELECT 1 FROM (SELECT `sp`.`sys_par_valor` AS `valor` FROM `juridico_cmmlaw`.`sys_par` AS `sp` WHERE `sp`.`sys_par_nome` = 'usr_dep_restringe' AND `sp`.`flag_oculto` = 0 ORDER BY `sp`.`sys_par_id` DESC LIMIT 1) AS `ult` WHERE TRIM(`ult`.`valor`) NOT IN ('', '0')) AS `restringe_ativo`, EXISTS(SELECT 1 FROM `juridico_cmmlaw`.`sys_par_usr` AS `spu` INNER JOIN `juridico_cmmlaw`.`sys_par` AS `sp2` ON `sp2`.`sys_par_id` = `spu`.`sys_par_id` WHERE `sp2`.`sys_par_nome` = 'usr_dep_restringe' AND `spu`.`flag_oculto` = 0) AS `tem_sobrescrita`; SELECT 'juridico_gislandia' AS `base`, EXISTS(SELECT 1 FROM (SELECT `sp`.`sys_par_valor` AS `valor` FROM `juridico_gislandia`.`sys_par` AS `sp` WHERE `sp`.`sys_par_nome` = 'usr_dep_restringe' AND `sp`.`flag_oculto` = 0 ORDER BY `sp`.`sys_par_id` DESC LIMIT 1) AS `ult` WHERE TRIM(`ult`.`valor`) NOT IN ('', '0')) AS `restringe_ativo`, EXISTS(SELECT 1 FROM `juridico_gislandia`.`sys_par_usr` AS `spu` INNER JOIN `juridico_gislandia`.`sys_par` AS `sp2` ON `sp2`.`sys_par_id` = `spu`.`sys_par_id` WHERE `sp2`.`sys_par_nome` = 'usr_dep_restringe' AND `spu`.`flag_oculto` = 0) AS `tem_sobrescrita`; SELECT 'juridico_jacintolaw' AS `base`, EXISTS(SELECT 1 FROM (SELECT `sp`.`sys_par_valor` AS `valor` FROM `juridico_jacintolaw`.`sys_par` AS `sp` WHERE `sp`.`sys_par_nome` = 'usr_dep_restringe' AND `sp`.`flag_oculto` = 0 ORDER BY `sp`.`sys_par_id` DESC LIMIT 1) AS `ult` WHERE TRIM(`ult`.`valor`) NOT IN ('', '0')) AS `restringe_ativo`, EXISTS(SELECT 1 FROM `juridico_jacintolaw`.`sys_par_usr` AS `spu` INNER JOIN `juridico_jacintolaw`.`sys_par` AS `sp2` ON `sp2`.`sys_par_id` = `spu`.`sys_par_id` WHERE `sp2`.`sys_par_nome` = 'usr_dep_restringe' AND `spu`.`flag_oculto` = 0) AS `tem_sobrescrita`; SELECT 'juridico_marciomoraes' AS `base`, EXISTS(SELECT 1 FROM (SELECT `sp`.`sys_par_valor` AS `valor` FROM `juridico_marciomoraes`.`sys_par` AS `sp` WHERE `sp`.`sys_par_nome` = 'usr_dep_restringe' AND `sp`.`flag_oculto` = 0 ORDER BY `sp`.`sys_par_id` DESC LIMIT 1) AS `ult` WHERE TRIM(`ult`.`valor`) NOT IN ('', '0')) AS `restringe_ativo`, EXISTS(SELECT 1 FROM `juridico_marciomoraes`.`sys_par_usr` AS `spu` INNER JOIN `juridico_marciomoraes`.`sys_par` AS `sp2` ON `sp2`.`sys_par_id` = `spu`.`sys_par_id` WHERE `sp2`.`sys_par_nome` = 'usr_dep_restringe' AND `spu`.`flag_oculto` = 0) AS `tem_sobrescrita`; SELECT 'juridico_msradvogados' AS `base`, EXISTS(SELECT 1 FROM (SELECT `sp`.`sys_par_valor` AS `valor` FROM `juridico_msradvogados`.`sys_par` AS `sp` WHERE `sp`.`sys_par_nome` = 'usr_dep_restringe' AND `sp`.`flag_oculto` = 0 ORDER BY `sp`.`sys_par_id` DESC LIMIT 1) AS `ult` WHERE TRIM(`ult`.`valor`) NOT IN ('', '0')) AS `restringe_ativo`, EXISTS(SELECT 1 FROM `juridico_msradvogados`.`sys_par_usr` AS `spu` INNER JOIN `juridico_msradvogados`.`sys_par` AS `sp2` ON `sp2`.`sys_par_id` = `spu`.`sys_par_id` WHERE `sp2`.`sys_par_nome` = 'usr_dep_restringe' AND `spu`.`flag_oculto` = 0) AS `tem_sobrescrita`; SELECT 'juridico_nascimentomourao' AS `base`, EXISTS(SELECT 1 FROM (SELECT `sp`.`sys_par_valor` AS `valor` FROM `juridico_nascimentomourao`.`sys_par` AS `sp` WHERE `sp`.`sys_par_nome` = 'usr_dep_restringe' AND `sp`.`flag_oculto` = 0 ORDER BY `sp`.`sys_par_id` DESC LIMIT 1) AS `ult` WHERE TRIM(`ult`.`valor`) NOT IN ('', '0')) AS `restringe_ativo`, EXISTS(SELECT 1 FROM `juridico_nascimentomourao`.`sys_par_usr` AS `spu` INNER JOIN `juridico_nascimentomourao`.`sys_par` AS `sp2` ON `sp2`.`sys_par_id` = `spu`.`sys_par_id` WHERE `sp2`.`sys_par_nome` = 'usr_dep_restringe' AND `spu`.`flag_oculto` = 0) AS `tem_sobrescrita`; SELECT 'juridico_pereiraeprates' AS `base`, EXISTS(SELECT 1 FROM (SELECT `sp`.`sys_par_valor` AS `valor` FROM `juridico_pereiraeprates`.`sys_par` AS `sp` WHERE `sp`.`sys_par_nome` = 'usr_dep_restringe' AND `sp`.`flag_oculto` = 0 ORDER BY `sp`.`sys_par_id` DESC LIMIT 1) AS `ult` WHERE TRIM(`ult`.`valor`) NOT IN ('', '0')) AS `restringe_ativo`, EXISTS(SELECT 1 FROM `juridico_pereiraeprates`.`sys_par_usr` AS `spu` INNER JOIN `juridico_pereiraeprates`.`sys_par` AS `sp2` ON `sp2`.`sys_par_id` = `spu`.`sys_par_id` WHERE `sp2`.`sys_par_nome` = 'usr_dep_restringe' AND `spu`.`flag_oculto` = 0) AS `tem_sobrescrita`; SELECT 'juridico_pradiadvogados' AS `base`, EXISTS(SELECT 1 FROM (SELECT `sp`.`sys_par_valor` AS `valor` FROM `juridico_pradiadvogados`.`sys_par` AS `sp` WHERE `sp`.`sys_par_nome` = 'usr_dep_restringe' AND `sp`.`flag_oculto` = 0 ORDER BY `sp`.`sys_par_id` DESC LIMIT 1) AS `ult` WHERE TRIM(`ult`.`valor`) NOT IN ('', '0')) AS `restringe_ativo`, EXISTS(SELECT 1 FROM `juridico_pradiadvogados`.`sys_par_usr` AS `spu` INNER JOIN `juridico_pradiadvogados`.`sys_par` AS `sp2` ON `sp2`.`sys_par_id` = `spu`.`sys_par_id` WHERE `sp2`.`sys_par_nome` = 'usr_dep_restringe' AND `spu`.`flag_oculto` = 0) AS `tem_sobrescrita`; SELECT 'juridico_sobrecontroller' AS `base`, EXISTS(SELECT 1 FROM (SELECT `sp`.`sys_par_valor` AS `valor` FROM `juridico_sobrecontroller`.`sys_par` AS `sp` WHERE `sp`.`sys_par_nome` = 'usr_dep_restringe' AND `sp`.`flag_oculto` = 0 ORDER BY `sp`.`sys_par_id` DESC LIMIT 1) AS `ult` WHERE TRIM(`ult`.`valor`) NOT IN ('', '0')) AS `restringe_ativo`, EXISTS(SELECT 1 FROM `juridico_sobrecontroller`.`sys_par_usr` AS `spu` INNER JOIN `juridico_sobrecontroller`.`sys_par` AS `sp2` ON `sp2`.`sys_par_id` = `spu`.`sys_par_id` WHERE `sp2`.`sys_par_nome` = 'usr_dep_restringe' AND `spu`.`flag_oculto` = 0) AS `tem_sobrescrita`; SELECT 'juridico_wecontroll' AS `base`, EXISTS(SELECT 1 FROM (SELECT `sp`.`sys_par_valor` AS `valor` FROM `juridico_wecontroll`.`sys_par` AS `sp` WHERE `sp`.`sys_par_nome` = 'usr_dep_restringe' AND `sp`.`flag_oculto` = 0 ORDER BY `sp`.`sys_par_id` DESC LIMIT 1) AS `ult` WHERE TRIM(`ult`.`valor`) NOT IN ('', '0')) AS `restringe_ativo`, EXISTS(SELECT 1 FROM `juridico_wecontroll`.`sys_par_usr` AS `spu` INNER JOIN `juridico_wecontroll`.`sys_par` AS `sp2` ON `sp2`.`sys_par_id` = `spu`.`sys_par_id` WHERE `sp2`.`sys_par_nome` = 'usr_dep_restringe' AND `spu`.`flag_oculto` = 0) AS `tem_sobrescrita`;

preferences:dark modelive previewkey bindings