| Properties | Assignment Status | Assignment(s) | |||||||
|---|---|---|---|---|---|---|---|---|---|
|
";
foreach($cntopts as $optval=>$opttext)
{
$checked="";
if($cnt==$optval)
$checked=checked;
echo " $opttext "; } echo " |
";
foreach($statusopts as $optval=>$opttext)
{
$checked="";
if(in_array($optval,$statusarr))
$checked=checked;
echo " $opttext "; } echo " |
";
foreach($assnopts as $optval=>$opttext)
{
$checked="";
if($assignmentmethodid==$optval)
$checked=checked;
$display="assignment";
if($optval>0)
$display="$opttext assignment";
echo " $opttext "; } echo " |
|||||||
', label=> 'Safeguard Update' );
$arr[10][cenbam][updatemap]["reorekeydate"] = propertyextensionsafeguardrekeydate;
$arr[10][cenbam][updatemap]["reotrashoutdate"] = propertyextensionsafeguardtrashoutdate;
$arr[10][cenbam][updatemap]["reowinterizedate"] = propertyextensionsafeguardwinterizationdate;
$arr[10][cenbam][updatemap]["lastgrasscutdate"] = propertyextensiongrasscutdate;
$arr[10][cenbam][updatefrom]=array('loan'=>propertyextensionloannumber);
$arr[7] = $arr[10];
$arr= $arr[$clientcompanyid];
if(!$arr)
return array();
return $arr;
}
function clientcompanyproperty_pageaction_run($clientcompanyid, $pageaction)
{
$actions = clientcompanyproperty_pageactions($clientcompanyid);
$action = $actions[$pageaction];
if(!$action)
ddie("Invalid pageaction: $pageaction");
if(!file_exists($action[page]))
return false;
extract($action);
include($action[page]);
return true;
}
function clientproperty_ext_save($clientcompanypropertyid,$key,$value,$noupdate_keys='')
{
if (trim($clientcompanypropertyid) == '' || empty($key) )
return false;
if (is_array($value))
developer_error('Array passed in for clientproperty_ext_save variable $value', 'There was an array passed in for the parameter $value which is not set up to be handled inside of this function. This will cause issues with the trim function later on, and more importantly is not handled with the database. This message is included to trace back to the file that called this function');
$keys=$key;
if(is_array($keys) && $value!==false)
developer_error("Invalid call to clientproperty_ext_save, if you pass an array in to \$key then you must pass the boolean false into \$value");
if(!is_array($keys))
$keys = array($key=>$value);
$value = "$value";
$extens = db_query("select propertyextensionkey as key, propertyextensionentryid id from tblpropertyextensionentry where clientcompanypropertyid = {$clientcompanypropertyid} and propertyextensionkey in ('".implode("','",array_keys($keys))."')",1,0,'key');
foreach($keys as $key=>$value)
{
$extenid = $extens[$key][id];
if ($extenid)
{
//we are removing the entry if blank
//to help keep the table size down
//if we have data here and we have
//instructions to not update the field
if ($noupdate_keys[$key] && $extens[$key])
continue;
else if (trim($value) == '')
{
$sql .= ";
delete from tblpropertyextensionentry
where propertyextensionentryid = {$extenid}";
}
//otherwise update
else
{
$sql .= ";
update tblpropertyextensionentry
set propertyextensionentryvalue = ".db_tick($value)."
where propertyextensionentryid = {$extenid}";
}
}
else
{
//don't insert new blank values
//to help keep table sizes down
if (trim($value) == '')
continue;
if (!is_string($value) && !is_numeric($value) )
continue;
$sql .= ";
insert into tblpropertyextensionentry (clientcompanypropertyid, propertyextensionkey, propertyextensionentryvalue)
values ($clientcompanypropertyid, ".db_tick($key).", ".db_tick($value).")";
}
}
if($sql)
$rval = db_exec($sql, 1);
return $rval;
}
function clientcompanyproperty_ext_save($clientcompanypropertyid,$key,$value)
{
$sql = "insert into tblpropertyextensionextentry (clientcompanypropertyid, propertyextensionkey)
select $clientcompanypropertyid, '$key'
where not exists (
select 1 from tblpropertyextensionextentry
where clientcompanypropertyid = $clientcompanypropertyid
and propertyextensionkey = '$key'
)
";
db_exec($sql,1);
$sql = "update tblpropertyextensionextentry
set propertyextensionentryextvalue= ".db_tick($value)."
where clientcompanypropertyid = $clientcompanypropertyid
and propertyextensionkey = '$key' ";
db_exec($sql,1);
}
function clientcompanyproperty_ext_merge($propertyarr)
{
if($propertyarr[clientcompanypropertyid])
$arr[] = $propertyarr;
else
$arr = $propertyarr;
foreach($arr as $k=>$property)
$propids[] = $property[clientcompanypropertyid];
$sql = "select * from tblpropertyextensionextentry where clientcompanypropertyid in (".db_number_list($propids).")";
$qry = db_query($sql);
foreach($qry as $row)
$aarr[$row[clientcompanypropertyid]][$row[propertyextensionkey]]=$row[propertyextensionentryextvalue];
foreach($propertyarr as &$property)
if($aarr[$property[clientcompanypropertyid]])
$property = array_merge($property,$aarr[$property[clientcompanypropertyid]]);
return $propertyarr;
}
function hoa_name($hoaid)
{
$sql = "select hoaname from tblhoa where hoaid = ".db_number($hoaid);
$hoa = db_first($sql);
return $hoa[hoaname];
}
function clientcompanyproperty_getadditionaldata($clientcompanypropertyid)
{
$sql = "select *
, case
when staffid> 0 then (select companyname from tblcompany join tbllogin lc using(companyid) where staffid = c.staffid)
when accountstaffid> 0 then (select accountname from tblaccount join tblaccountstaff lc using(accountid) where accountstaffid = c.accountstaffid)
when externaluserid> 0 then (select externalusercompanyname from tblexternaluser where externaluserid = c.externaluserid)
end as companyname
from tblclientcompanypropertyassignment a
join tblclientcompanyproperty b using(clientcompanypropertyid)
join vw_assigntypes c using(accountstaffid, staffid, externaluserid,assignmentaliasclientstaffid)
join tblassignmentmethod d using (assignmentmethodid)
where clientcompanypropertyid = $clientcompanypropertyid
and d.clientcompanyid=b.clientcompanyid
and clientcompanypropertyassignmentexpired is null
and clientcompanypropertyassignmentrevokeddate is null
and clientcompanypropertyassignmentaccepteddate is not null
and clientcompanypropertyassignmentaccepteddate in
(
select max (clientcompanypropertyassignmentaccepteddate) as clientcompanypropertyassignmentaccepteddate
from tblclientcompanypropertyassignment ta
join tblclientcompanyproperty tb using(clientcompanypropertyid)
join vw_assigntypes tc using(accountstaffid, staffid, externaluserid,assignmentaliasclientstaffid)
join tblassignmentmethod td using (assignmentmethodid)
where clientcompanypropertyid = $clientcompanypropertyid
and td.clientcompanyid=tb.clientcompanyid
and clientcompanypropertyassignmentexpired is null
and clientcompanypropertyassignmentrevokeddate is null
and clientcompanypropertyassignmentaccepteddate is not null
group by assignmentmethodid
)";
$sql2 = "select assignmentmethodname
,assignmentmethodname as assignname
,assignmentmethodname as assignphone
,assignmentmethodname as assigncell
,assignmentmethodname as assignemail
,assignmentmethodname as assigncompanyname
from tblassignmentmethod where assignmentmethodinactivedate is null and clientcompanyid = ".clientcompanyid();
if($clientcompanypropertyid<0)
{
$sql = $sql2;
}
$assigns = db_query($sql);
foreach($assigns as $assign)
{
$ids[]=$assign[assignmentmethodid];
$amname=$assign[assignmentmethodname];
$amname = strtolower($amname);
$amname = str_replace(' ','',$amname);
$amname = str_replace("'",'',$amname);
$amname = str_replace('"','',$amname);
$kam = 'assigned'.$amname;
$replaceqrynewarr[$kam.name]=$assign[assignname];
$replaceqrynewarr[$kam.phone]=$assign[assignphone];
$replaceqrynewarr[$kam.cell]=$assign[assigncell];
$replaceqrynewarr[$kam.email]=$assign[assignemail];
$replaceqrynewarr[$kam.companyname]=$assign[assignemail];
if(isset($assign[staffid]))
$replaceqrynewarr[$kam.companyname]=get_assignedcompanyname($assign[staffid],$assign[accountstaffid],$assign[externaluserid],$assign['assignmentaliasclientstaffid']);
}
return $replaceqrynewarr;
}
function clientcompanyproperty_get_attributehistory($clientcompanypropertyid)
{
$db_clientcompanypropertyid = db_number($clientcompanypropertyid);
//get attribute history if we have one
if ($db_clientcompanypropertyid)
{
$title = "The date and time this field was last changed on.";
$sql = "
select attributehistorycolumn, max(attributehistorycreateddate) as attributehistorycreateddate
from tblattributehistory
where 0=0";
if ($db_clientcompanypropertyid)
$sql .= "
and clientcompanypropertyid = $db_clientcompanypropertyid";
$sql .= "
group by attributehistorycolumn";
if ($sql)
$attr_history = db_query($sql, 1, 0, attributehistorycolumn);
foreach ($attr_history as $key => $value)
$attr_history[$key][formatteddate] = "".dttime_format($attr_history[$key][attributehistorycreateddate])."";
return $attr_history;
}
}
function prep_vhtmlreport($propertyid,$html){
global $property;
exec( "find " . $_SERVER['DOCUMENT_ROOT'] . '/clientcompanylogos/ -name "' . clientcompanyid() . '.*"',$logopath);
$property = db_first ("select * from tblclientcompanyproperty where clientcompanypropertyid = ".db_number($propertyid));
$property[logopath]=str_replace($_SERVER['DOCUMENT_ROOT'] ."/","",array_shift($logopath));
$property = array_merge($property,db_first("select * from tblclientcompany where clientcompanyid =".clientcompanyid()));
$tmp= get_clientcompanyclient($property[clientcompanyclientid]);
$property[clientcompanyclientid] =$tmp[clientcompanyclientname];
unset($tmp);
$property[clientcompanypropertyupdated] = array_shift(explode(".",$property[clientcompanypropertyupdated]));
$property[clientcompanypropertyupdatedby] = get_loginusername($property[clientcompanypropertyupdatedby]);
$sql = "select propertyextensionentryvalue, propertyextensionkey, clientcompanypropertyid
from tblpropertyextensionentry
where clientcompanypropertyid =".db_number($propertyid);
$extensions = db_query($sql,1,0,propertyextensionkey);
foreach ($extensions as $key=>$extension){
$property[$key]=$extension[propertyextensionentryvalue];
}
$sql = "select name from tblrole
left join (select * from tblclientcompanypropertyrole
where clientcompanypropertyid = ".db_number($propertyid).") r using (roleid)
join (select clientstafffname|| ' '|| clientstafflname as name,clientstaffid from tblclientstaff) as clientstaff using (clientstaffid)
where clientcompanyid = ".db_number(clientcompanyid())."
and rolepropertyworking = 1
and rolename ilike 'Asset Manager'
order by rolename";
$property[assetmanager] = db_firstval($sql);
$property[propertyextensiondaysonmarket] = get_daystillnow($property[propertyextensionlistdate]);
$property[received] = dt_format(array_shift(explode(".",$property[clientcompanypropertycreated])));
$property[propertyextensiondaysininventory] = get_daystillnow($property[clientcompanypropertycreated]);
$property[propertyextensionyearbuilt] = get_yearstillnow($property[propertyextensionyearbuilt]);
$property[clientcompanypropertyapprtobpo] = apprtobpoval($property[propertyextensioninitialappraisalvalue],$property[propertyextensioninitialbpovalue]);
foreach ($property as $key=>$val){
if ((strstr($key,"value") || strstr($key,"price")) && is_numeric($val))
$property[$key]=number_format($val);
}
ob_start();
$property = array_merge($property,clientcompanyproperty_getadditionaldata($propertyid));
$null=ob_end_clean();
unset($null);
return $html;
}
/**
* get_marketingreports
* @param unknown $propertyid
*/
function get_marketingreports($propertyid){
$doctype = get_documenttype_byname('marketingreport');
$doctypeid = $doctype[documenttypeid];
$reportdocs = db_query("select documentid,documentname,documenttitle, documentloadedby,documentdateloaded from tbldocument where documenttypeid=".db_number($doctypeid)." and clientcompanypropertyid =".db_number($propertyid)." order by documentid desc");
foreach ($reportdocs as $key=>$document){
$filepath = get_document_full_path(db_firstval("select documentid from tbldocument where documentid=".db_number($document[documentid])));
$reportdocs[$key][filepath]="document/".end(explode("/document/",$filepath));
$reportdocs[$key][comment] = db_firstval("select marketingreportscomment from tblmarketingreportscomment where documentid=".db_number($document[documentid]));
}
unset ($doctype,$doctypeid,$filepath);
return $reportdocs;
}
/**
* @name apprtobpoval
* @param unknown $appraisal
* @param unknown $bpoval
* @return number
* @comment This function returns positive or negative %
*/
function apprtobpoval ($appraisal,$bpoval){
if ($bpoval>$appraisal){
$tmp=$appraisal;
$appraisal = db_number($bpoval);
$bpoval = db_number($tmp);
}
if ($appraisal >0){
$r=$bpoval/$appraisal;
$result = round($r,2);
$result = $result * 100;
}else
$result =0;
if (!$tmp)
$result = 0-$result;
return $result;
}
function marketingreportui(){
?>| Marketing Report |
|---|