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