38 $f_add_button->javascript=
" this.filter='$filter';this.jrn=-1;select_card_type(this);";
57 $coprop=
$cn->prepare(
"coprop",
" select distinct coprop_id,
58 vw_name as copro_name,
59 vw_first_name as copro_first_name,
60 quick_code as copro_qcode
62 coprop.summary as s join vw_fiche_attr on (coprop_id::numeric=f_id)
64 coalesce(s.building_id,'')=$1
69 $lot=
$cn->prepare(
"lot",
" select distinct lot_id,
71 quick_code as lot_qcode,
72 vw_description as lot_desc
74 coprop.summary as s join vw_fiche_attr on (lot_id::numeric=f_id)
76 coalesce(s.building_id,'')=$1 and coalesce(s.coprop_id,'')=$2
83 quick_code as lot_qcode,
84 vw_description as lot_desc
86 coprop.summary as s join vw_fiche_attr on (lot_id::numeric=f_id)
88 coalesce(s.building_id,'')='' or coalesce(s.coprop_id,'')=''
89 or coalesce(s.building_id,'') not in (select building_id from coprop.summary)
90 or coalesce(s.coprop_id,'') not in (select coprop_id from coprop.summary)
95 require_once
'template/coprop_lot_list.php';
global $g_copro_parameter