lot.inc.php File Reference

liaison entre lot et copropriétaires More...

Go to the source code of this file.

Variables
global	$cn
global	$g_copro_parameter
	$f_add_button =new IButton('add_card')
$f_add_button	label =_('Créer une nouvelle fiche')
	$filter =$g_copro_parameter->categorie_lot.",".$g_copro_parameter->categorie_coprop.",".$g_copro_parameter->categorie_immeuble
$f_add_button	javascript =" this.filter='$filter';this.jrn=-1;select_card_type(this);"
	$a_immeuble
	$coprop
	$lot
	$a_undef_lot

Detailed Description

liaison entre lot et copropriétaires

Definition in file lot.inc.php.

Variable Documentation

$a_immeuble

Initial value:

=$cn->get_array(" select f_id,vw_name,quick_code
    from vw_fiche_attr
    where
    fd_id=$1
    ",array($g_copro_parameter->categorie_immeuble))

Todo:

ajouter tri

Definition at line 48 of file lot.inc.php.

$a_undef_lot

Initial value:

=$cn->get_array(" select lot_id,
    vw_name as lot_name,
    quick_code as lot_qcode,
        vw_description as lot_desc
    from
    coprop.summary as s join vw_fiche_attr on (lot_id::numeric=f_id)
    where
    coalesce(s.building_id,'')='' or coalesce(s.coprop_id,'')=''
        or coalesce(s.building_id,'') not in (select building_id from coprop.summary) 
        or coalesce(s.coprop_id,'') not in (select coprop_id from coprop.summary) 
    ")

Definition at line 81 of file lot.inc.php.

global $cn

Definition at line 29 of file lot.inc.php.

$coprop

Initial value:

=$cn->prepare("coprop"," select distinct coprop_id,
    vw_name as copro_name,
        vw_first_name as copro_first_name,
    quick_code as copro_qcode
    from
    coprop.summary as s join vw_fiche_attr on (coprop_id::numeric=f_id)
    where
    coalesce(s.building_id,'')=$1 
    ")

Definition at line 57 of file lot.inc.php.

$f_add_button =new IButton('add_card')

Definition at line 33 of file lot.inc.php.

$filter =$g_copro_parameter->categorie_lot.",".$g_copro_parameter->categorie_coprop.",".$g_copro_parameter->categorie_immeuble

Definition at line 37 of file lot.inc.php.

global $g_copro_parameter

Definition at line 29 of file lot.inc.php.

$lot

Initial value:

=$cn->prepare("lot"," select distinct lot_id,
    vw_name as lot_name,
    quick_code as lot_qcode,
        vw_description as lot_desc
    from
    coprop.summary as s join vw_fiche_attr on (lot_id::numeric=f_id)
    where
    coalesce(s.building_id,'')=$1 and coalesce(s.coprop_id,'')=$2
    ")

Definition at line 69 of file lot.inc.php.

Referenced by Install_Plugin\create_card().

$f_add_button javascript =" this.filter='$filter';this.jrn=-1;select_card_type(this);"

Definition at line 38 of file lot.inc.php.

$f_add_button label =_('Créer une nouvelle fiche')

Definition at line 34 of file lot.inc.php.