Backlog Courrier

résultat en CMD :

psql -U maarch -d 2010 -c "select * from entities where entity_id =  (select entity_by_res_id(100))"

id | entity_id |       entity_label        |        short_label        | entity_full_name | enabled | adrs_1 | adrs_2 | adrs_3 | zipcode | city | country |       email       |     business_id      | parent_entity_id | entity_type | ldap_id | producer_service | folder_import | external_id 
----+-----------+---------------------------+---------------------------+------------------+---------+--------+--------+--------+---------+------+---------+-------------------+----------------------+------------------+-------------+---------+------------------+---------------+-------------
  1 | VILLE     | Ville de Maarch-les-bains | Ville de Maarch-les-bains |                  | Y       |        |        |        |         |      |         | support@maarch.fr | 45239273100025/VILLE |                  | Direction   |         |                  |               | {}

fonction sql :

create or replace function entity_by_res_id(id int) returns varchar AS $BODY$
declare
    entity varchar;
    res varchar;
begin
    select initiator into entity from res_view_letterbox where res_id = id;
    select entity_tree(entity) into res;
    return res;
END;
$BODY$ LANGUAGE plpgsql;


create or replace function entity_tree(entity varchar) returns varchar AS $BODY$
declare
    parentid varchar;
    res varchar;
begin
    select parent_entity_id into parentid from entities where entity_id = $1;
    if parentid is null or parentid = '' then
        return $1;
    else
        select entity_tree(parentid) into res;
        return res;
    end if;   
END;
$BODY$ LANGUAGE plpgsql;

code bloquant CustomFieldController.php ligne 356-358:

         if (stripos($body['values']['clause'], 'select') !== false) {
             return ['errors' => 'Clause is not valid', 'lang' => 'invalidClause'];
         }

ok je test avec la vue.

avec la vue pas de soucis.

create or replace view vue
AS select r.res_id, 
 r.typist,
 e.entity_label as root_entity
from res_letterbox r
left join entities e on entity_id = entity_by_res_id(r.res_id::int)

a cloturer