| $dname : | ";
$thisstate = $db_table_prefix."propertystate";
$dropdownlengthrestriction=110;
if ($COMPANYSIDE || client_portal())
{
$sql = "select * from tblhoa
where companyid = '".db_number(companyid())."'
and hoainactive is null
order by hoaname asc";
$my_hoas = db_query($sql);
$exclude = '';
if($my_hoas)
{
foreach($my_hoas as $key => $hoa)
{
if($exclude)
$exclude .= ',';
$exclude .= $hoa['hoaid_master'];
}
$my_hoaarray[0][id]=" ";
$my_hoaarray[0][value]="**************** My HOA's *****************";
$my_hoaarray[0][label]=1;
$i=1;
foreach ($my_hoas as $key=>$hoa)
{
$my_hoaarray[$i][id]=$hoa['hoaid'];
$my_hoaarray[$i][value]=$hoa['hoaname'];
$i++;
}
}
}
$sql = "select hoaid
,hoaname
,hoaaddress
,hoacity
,hoastate
,hoazip
,hoacontact
,hoaphone
,(
'n-' || coalesce(hoaname,'')
|| '-a-' || coalesce(hoaaddress,'')
|| '-c-' || coalesce(hoacity,'')
|| '-s-' || coalesce(hoastate,'')
|| '-z-' || coalesce(hoazip,'')
|| '-ct-' || coalesce(hoacontact,'')
|| '-p-' || coalesce(hoaphone,'')
) as hoakey
from tblhoa";
if ($property)
{
$sql .=" left join ( select name,code
from tblstate
where code = '".db_col($property[$thisstate])."'
or name ='".db_col($property[$thisstate])."')
tblstate on (tblstate.name = hoastate or tblstate.code = hoastate)";
}
$sql .=" where companyid = 0
and hoaid_master = 0 ";
if($property)
$sql .=" and (hoastate = name or hoastate = code) ";
$sql.= " and hoainactive is null ";
if ($exclude)
$sql .=" ". ($exclude ? "and hoaid not in (".$exclude.")" : "");
$sql .= " order by hoaname asc";
global $hoanodups;
if($hoanodups && is_array($hoanodups))
$hoas=$hoanodups;
else
{
$hoas = db_query($sql);
if($hoas)
{
if(!strstr($_SERVER['SCRIPT_NAME'],'property_add.php') && ($_GET['action']!='add'))
$hoas=hoa_removeduplicate($hoas); //Cache for same page because sometimes same date pulled 3 times.
$hoanodups=$hoas;
}
}
if ($hoas)
{
if ($property)
$insertstate ="( $property[$thisstate] )";
$hoaarray[0][id]=" ";
$hoaarray[0][value]=" ********* HOA State $insertstate Database **********";
$hoaarray[0][label]=1;
$i=1;
foreach ($hoas as $key=>$hoa)
{
$selectiondisplay=$hoa['hoaname'];
$dupfields="";
if($hoa['hoacontact'])
$dupfields.=" ".$hoa['hoacontact'];
if($hoa['hoaphone'])
$dupfields.=" (".$hoa['hoaphone'].")";
if($hoa['hoaaddress'])
$dupfields.=" ".$hoa['hoaaddress'];
if($hoa['hoacity'])
$dupfields.=" ".$hoa['hoacity'];
if($hoa['hoastate'])
$dupfields.=" ".$hoa['hoastate'];
if($hoa['hoazip'])
$dupfields.=" ".$hoa['hoazip'];
if($dupfields)
{
if((strlen($dupfields)+strlen($selectiondisplay)+4)>$dropdownlengthrestriction)
{
$duplenrestrict=$dropdownlengthrestriction-(strlen($selectiondisplay)+4);
if($duplenrestrict<0)
$duplenrestrict=0;
$dupfields=substr($dupfields,0,$duplenrestrict)." ...";
}
$selectiondisplay=$selectiondisplay." - [".trim($dupfields)."]";
}
$hoaarray[$i][id]=$hoa['hoaid'];
$hoaarray[$i][value]=$selectiondisplay;
$i++;
}
}
if ($my_hoaarray && $hoaarray)
$hoaarray = array_merge ($my_hoaarray,$hoaarray);
elseif (!$hoaarray) // we got 0 HOA for this state going national.
{
if ($COMPANYSIDE)
{
$mystates = get_mystates();
$sql = "select *
,(
'n-' || coalesce(hoaname,'')
|| '-a-' || coalesce(hoaaddress,'')
|| '-c-' || coalesce(hoacity,'')
|| '-s-' || coalesce(hoastate,'')
|| '-z-' || coalesce(hoazip,'')
|| '-ct-' || coalesce(hoacontact,'')
|| '-p-' || coalesce(hoaphone,'')
) as hoakey
from tblhoa
left join( select name,code
from tblstate";
if($property)
$sql .=" where code = '".db_col($property[$thisstate])."'
or name ='".db_col($property[$thisstate])."')";
if (!$property)
$sql .=" where code in ('" .implode("','",$mystates)."')
or name in ('" .implode("','",$mystates)."'))";
$sql .=" tblstate on (tblstate.name = hoastate)
where (companyid = '".db_number(companyid())."'
or companyid = 0)
and hoaid_master = 0
and hoainactive is null ";
if($property)
$sql .=" and (hoastate=name or hoastate=code) ";
if (!$property)
$sql .="and hoastate in ('" .implode("','",$mystates)."') ";
if ($exclude)
$sql .=" ". ($exclude ? "and hoaid not in (".$exclude.")" : "");
$sql .=" order by hoaname asc";
global $hoanationalnodups;
if($hoanationalnodups && is_array($hoanationalnodups))
$hoas=$hoanationalnodups;
else
{
$hoas = db_query($sql);
if($hoas)
{
if(!strstr($_SERVER['SCRIPT_NAME'],'property_add.php') && ($_GET['action']!='add'))
$hoas=hoa_removeduplicate($hoas); //Cache for same page because sometimes same date pulled 3 times.
$hoanationalnodups=$hoas;
}
}
if ($hoas)
{
$insertstate="";
if ($property)
$insertstate ="State( $property[$thisstate] ) ";
$hoaarray[0][id]=" ";
$hoaarray[0][value]=" ********* HOA ".$insertstate."Database **********";
$hoaarray[0][label]=1;
$i=1;
foreach ($hoas as $key=>$hoa)
{
$selectiondisplay=$hoa['hoaname'];
$dupfields="";
if($hoa['hoacontact'])
$dupfields.=" ".$hoa['hoacontact'];
if($hoa['hoaphone'])
$dupfields.=" (".$hoa['hoaphone'].")";
if($hoa['hoaaddress'])
$dupfields.=" ".$hoa['hoaaddress'];
if($hoa['hoacity'])
$dupfields.=" ".$hoa['hoacity'];
if($hoa['hoastate'])
$dupfields.=" ".$hoa['hoastate'];
if($hoa['hoazip'])
$dupfields.=" ".$hoa['hoazip'];
if($dupfields)
{
if((strlen($dupfields)+strlen($selectiondisplay)+4)>$dropdownlengthrestriction)
{
$duplenrestrict=$dropdownlengthrestriction-(strlen($selectiondisplay)+4);
if($duplenrestrict<0)
$duplenrestrict=0;
$dupfields=substr($dupfields,0,$duplenrestrict)." ...";
}
$selectiondisplay=$selectiondisplay." - [".trim($dupfields)."]";
}
$hoaarray[$i][id]=$hoa['hoaid'];
$hoaarray[$i][value]=$selectiondisplay;
$i++;
}
}
if ($my_hoaarray && $hoaarray)
{
//d("merge",$my_hoaarray);
$hoaarray = array_merge ($my_hoaarray,$hoaarray);
}
else
{
$hoaarray=$my_hoaarray;
}
}
}
if ($COMPANYSIDE)
{
$hoaprefix="property".strtolower($dname);
$sql = " select * from tblproperty
where propertyid = '".db_number ($property[propertyid])."'";
$hoadata=db_first($sql);
}
else
{
$hoaprefix="propertyextension".strtolower($dname);
if ($property)
{
$hoadata1=$property[extension];
unset($hodata);
d($hoadata1);
if (is_array($hoadata1))
{
foreach ($hoadata1 as $row=>$extension)
{
if(strstr($row,'propertyextensionhoa'))
$hoadata[$row]=$extension[propertyextensionentryvalue];
}
$hoaid = $hoadata1[$name][propertyextensionentryvalue];
}else
unset ($hoaid);
}
if (!$hoadata)
{
$hoadata1=$_POST;
unset($hodata);
d(myhoa, $hoadata1);
if (is_array($hoadata1))
{
foreach ($hoadata1 as $extension)
{
if(strstr($row,'propertyextensionhoa'))
$hoadata[$row]=$extension[propertyextensionentryvalue];
}
$hoaid = $hoadata1[$name];
}else
unset ($hoaid);
}
if ($skip)
{
$hoadata = $hoadata1;
$hoaid = $hoadata[propertyextensionhoaid];
}
// AMC Hack to show any hoa that we have id
if ($hoaid)
{
unset($foundhoa);
foreach ($hoaarray as $key=>$value)
{
if ($value[id] == $hoaid)
$foundhoa=1;
}
if (!$foundhoa)
$hoaarray[]=db_first("select hoaid as id, hoaname as value from tblhoa where hoaid=".db_number($hoaid));
}
}
if (!$hoaid && $GLOBALS[customfield_viewonly]) // no hoa selected in readonly mode no need to process any further
{
echo " |
Add Additional Commission