function Main()
{
switch ($this->formArray["formAction"]) {
case "remove":
//echo "removeOwnerRPTOP(".$this->formArray["rptopID"].",".$this->formArray["ownerID"].",".$this->formArray["personID"].",".$this->formArray["companyID"].")";
$OwnerList = new SoapObject(NCCBIZ . "OwnerList.php", "urn:Object");
if (count($this->formArray["personID"]) || count($this->formArray["companyID"])) {
if (!($deletedRows = $OwnerList->removeOwnerRPTOP($this->formArray["rptopID"], $this->formArray["ownerID"], $this->formArray["personID"], $this->formArray["companyID"]))) {
$this->tpl->set_var("msg", "SOAP failed");
//echo "SOAP failed";
} else {
$this->tpl->set_var("msg", $deletedRows . " records deleted");
}
} else {
$this->tpl->set_var("msg", "0 records deleted");
}
header("location: RPTOPDetails.php" . $this->sess->url("") . $this->sess->add_query(array("rptopID" => $this->formArray["rptopID"])));
exit;
break;
default:
$this->tpl->set_var("msg", "");
}
//select
$RPTOPDetails = new SoapObject(NCCBIZ . "RPTOPDetails.php", "urn:Object");
if (!($xmlStr = $RPTOPDetails->getRPTOP($this->formArray["rptopID"]))) {
exit("xml failed");
} else {
//echo($xmlStr);
if (!($domDoc = domxml_open_mem($xmlStr))) {
$this->tpl->set_block("rptsTemplate", "OwnerListTable", "OwnerListTableBlock");
$this->tpl->set_var("OwnerListTableBlock", "error xmlDoc");
} else {
$rptop = new RPTOP();
$rptop->parseDomDocument($domDoc);
//print_r($rptop);
foreach ($rptop as $key => $value) {
switch ($key) {
case "owner":
//$RPTOPEncode = new SoapObject(NCCBIZ."RPTOPEncode.php", "urn:Object");
if (is_a($value, "Owner")) {
$this->formArray["ownerID"] = $rptop->owner->getOwnerID();
$xmlStr = $rptop->owner->domDocument->dump_mem(true);
if (!$xmlStr) {
$this->tpl->set_block("rptsTemplate", "OwnerListTable", "OwnerListTableBlock");
$this->tpl->set_var("OwnerListTableBlock", "");
} else {
if (!($domDoc = domxml_open_mem($xmlStr))) {
$this->tpl->set_block("rptsTemplate", "OwnerListTable", "OwnerListTableBlock");
$this->tpl->set_var("OwnerListTableBlock", "error xmlDoc");
} else {
$this->displayOwnerList($domDoc);
}
}
} else {
$this->tpl->set_block("rptsTemplate", "PersonList", "PersonListBlock");
$this->tpl->set_var("PersonListBlock", "");
$this->tpl->set_block("rptsTemplate", "CompanyList", "CompanyListBlock");
$this->tpl->set_var("CompanyListBlock", "");
}
break;
case "cityAssessor":
if (is_numeric($value)) {
$cityAssessor = new Person();
$cityAssessor->selectRecord($value);
$this->tpl->set_var("cityAssessorID", $cityAssessor->getPersonID());
$this->tpl->set_var("cityAssessorName", $cityAssessor->getFullName());
$this->formArray["cityAssessorName"] = $cityAssessor->getFullName();
} else {
$cityAssessor = $value;
$this->tpl->set_var("cityAssessorID", $cityAssessor);
$this->tpl->set_var("cityAssessorName", $cityAssessor);
$this->formArray["cityAssessorName"] = $cityAssessor;
}
break;
case "cityTreasurer":
if (is_numeric($value)) {
$cityTreasurer = new Person();
$cityTreasurer->selectRecord($value);
$this->tpl->set_var("cityTreasurerID", $cityTreasurer->getPersonID());
$this->tpl->set_var("cityTreasurerName", $cityTreasurer->getFullName());
$this->formArray["cityTreasurerName"] = $cityTreasurer->getFullName();
} else {
$cityTreasurer = $value;
$this->tpl->set_var("cityTreasurerID", $cityTreasurer);
$this->tpl->set_var("cityTreasurerName", $cityTreasurer);
$this->formArray["cityTreasurerName"] = $cityTreasurer;
}
break;
case "tdArray":
$this->tpl->set_block("rptsTemplate", "defaultTDList", "defaultTDListBlock");
$this->tpl->set_block("rptsTemplate", "toggleTDList", "toggleTDListBlock");
$this->tpl->set_block("rptsTemplate", "TDList", "TDListBlock");
$tdCtr = 0;
if (count($value)) {
$this->tpl->set_block("rptsTemplate", "TDDBEmpty", "TDDBEmptyBlock");
$this->tpl->set_var("TDDBEmptyBlock", "");
/*
$this->tpl->set_block("TDList", "Land", "LandBlock");
$this->tpl->set_block("TDList", "PlantsTrees", "PlantsTreesBlock");
$this->tpl->set_block("TDList", "ImprovementsBuildings", "ImprovementsBuildingsBlock");
$this->tpl->set_block("TDList", "Machineries", "MachineriesBlock");
*/
foreach ($value as $tkey => $tvalue) {
//foreach($tvalue as $column => $val){
// $this->tpl->set_var($column,$val);
//}
$this->tpl->set_var("tdID", $tvalue->getTDID());
$this->tpl->set_var("taxDeclarationNumber", $tvalue->getTaxDeclarationNumber());
$this->tpl->set_var("afsID", $tvalue->getAfsID());
$this->tpl->set_var("cancelsTDNumber", $tvalue->getCancelsTDNumber());
$this->tpl->set_var("canceledByTDNumber", $tvalue->getCanceledByTDNumber());
$this->tpl->set_var("taxBeginsWithTheYear", $tvalue->getTaxBeginsWithTheYear());
$this->tpl->set_var("ceasesWithTheYear", $tvalue->getCeasesWithTheYear());
$this->tpl->set_var("enteredInRPARForBy", $tvalue->getEnteredInRPARForBy());
$this->tpl->set_var("enteredInRPARForYear", $tvalue->getEnteredInRPARForYear());
$this->tpl->set_var("previousOwner", $tvalue->getPreviousOwner());
$this->tpl->set_var("previousAssessedValue", $tvalue->getPreviousAssessedValue());
list($dateArr["year"], $dateArr["month"], $dateArr["day"]) = explode("-", $tvalue->getProvincialAssessorDate());
$this->tpl->set_var("pa_yearValue", removePreZero($dateArr["year"]));
$this->tpl->set_var("pa_month", removePreZero($dateArr["month"]));
$this->tpl->set_var("pa_dayValue", removePreZero($dateArr["day"]));
list($dateArr["year"], $dateArr["month"], $dateArr["day"]) = explode("-", $tvalue->getCityMunicipalAssessorDate());
$this->tpl->set_var("cm_yearValue", removePreZero($dateArr["year"]));
$this->tpl->set_var("cm_month", removePreZero($dateArr["month"]));
$this->tpl->set_var("cm_dayValue", removePreZero($dateArr["day"]));
$this->tpl->set_var("provincialAssessorName", $tvalue->provincialAssessor);
$this->tpl->set_var("cityMunicipalAssessorName", $tvalue->cityMunicipalAssessor);
//$this->tpl->set_var("assessedValue",$tvalue->getAssessedValue());
$this->tpl->set_var("propertyType", $tvalue->getPropertyType());
$this->tpl->set_var("basicTax", "");
$this->tpl->set_var("sefTax", "");
$this->tpl->set_var("total", "");
//$this->tpl->set_var("basicTax",$tvalue->getBasicTax());
//$this->tpl->set_var("sefTax",$tvalue->getSefTax());
//$this->tpl->set_var("total",$tvalue->getTotal());
$AFSDetails = new SoapObject(NCCBIZ . "AFSDetails.php", "urn:Object");
if (!($xmlStr = $AFSDetails->getAFS($tvalue->getAfsID()))) {
//$this->tpl->set_block("rptsTemplate", "AFSTable", "AFSTableBlock");
//$this->tpl->set_var("AFSTableBlock", "afs not found");
} else {
//echo $xmlStr;
if (!($domDoc = domxml_open_mem($xmlStr))) {
//$this->tpl->set_block("rptsTemplate", "OwnerListTable", "OwnerListTableBlock");
//$this->tpl->set_var("OwnerListTableBlock", "error xmlDoc");
} else {
$afs = new AFS();
$afs->parseDomDocument($domDoc);
$this->formArray["landTotalMarketValue"] += $afs->getLandTotalMarketValue();
$this->formArray["landTotalAssessedValue"] += $afs->getLandTotalAssessedValue();
$this->formArray["plantTotalMarketValue"] += $afs->getPlantTotalMarketValue();
$this->formArray["plantTotalAssessedValue"] += $afs->getPlantTotalAssessedValue();
$this->formArray["bldgTotalMarketValue"] += $afs->getBldgTotalMarketValue();
$this->formArray["bldgTotalAssessedValue"] += $afs->getBldgTotalAssessedValue();
$this->formArray["machTotalMarketValue"] += $afs->getMachTotalMarketValue();
$this->formArray["machTotalAssessedValue"] += $afs->getMachTotalAssessedValue();
$this->formArray["totalMarketValue"] += $afs->getTotalMarketValue();
$this->formArray["totalAssessedValue"] += $afs->getTotalAssessedValue();
$this->tpl->set_var("marketValue", number_format($afs->getTotalMarketValue(), 2, '.', ','));
$this->tpl->set_var("assessedValue", number_format($afs->getTotalAssessedValue(), 2, '.', ','));
$this->tpl->set_var("taxability", $afs->getTaxability());
$this->tpl->set_var("effectivity", $afs->getEffectivity());
$this->formArray["idle"] = "No";
if ($tvalue->getPropertyType() == "Land") {
if (is_array($afs->landArray)) {
// if land is stripped
if (count($afs->landArray) > 1) {
foreach ($afs->landArray as $land) {
if ($land->getIdle() == "Yes") {
$this->formArray["idle"] = "Yes";
break;
}
}
} else {
$this->formArray["idle"] = $afs->landArray[0]->getIdle();
}
}
}
if ($this->formArray["idle"] == "") {
$this->formArray["idle"] = "No";
}
$this->tpl->set_var("idle", $this->formArray["idle"]);
}
}
// grab Due from tdID
$this->formArray["totalTaxDue"] = 0.0;
$DueDetails = new SoapObject(NCCBIZ . "DueDetails.php", "urn:Object");
if (!($xmlStr = $DueDetails->getDueFromTdID($tvalue->getTdID(), $rptop->getTaxableYear()))) {
$this->tpl->set_var("dueID", "");
$this->tpl->set_var("dueDate", "---/--/--");
$this->tpl->set_var("basicTax", "uncalculated");
$this->tpl->set_var("sefTax", "uncalculated");
$this->tpl->set_var("idleTax", "uncalculated");
$this->tpl->set_var("taxDue", "uncalculated");
} else {
if (!($domDoc = domxml_open_mem($xmlStr))) {
$this->tpl->set_var("dueDate", "---/--/--");
$this->tpl->set_var("dueID", "uncalculated");
$this->tpl->set_var("basicTax", "uncalculated");
$this->tpl->set_var("sefTax", "uncalculated");
$this->tpl->set_var("idleTax", "uncalculated");
$this->tpl->set_var("taxDue", "uncalculated");
} else {
$due = new Due();
$due->parseDomDocument($domDoc);
$this->tpl->set_var("dueID", $due->getDueID());
$this->tpl->set_var("dueDate", date("M. d, Y", strtotime($due->getDueDate())));
$this->tpl->set_var("basicTax", formatCurrency($due->getBasicTax()));
$this->tpl->set_var("sefTax", formatCurrency($due->getSEFTax()));
$this->tpl->set_var("idleTax", formatCurrency($due->getIdleTax()));
$this->tpl->set_var("taxDue", formatCurrency($due->getTaxDue()));
$this->formArray["totalTaxDue"] += $due->getTaxDue();
}
}
// refresh tdHistory
// insert/update Dues from PreviousTD as BacktaxTD for CurrentTD
// if previous TD has no Dues, create a Due and insert as BacktaxTD
$this->formArray["taxableYear"] = $rptop->getTaxableYear();
$this->refreshTDHistory($tvalue);
$this->tpl->set_var("ctr", $tdCtr);
$this->tpl->parse("defaultTDListBlock", "defaultTDList", true);
$this->tpl->parse("toggleTDListBlock", "toggleTDList", true);
$this->tpl->parse("TDListBlock", "TDList", true);
/*
$this->tpl->set_var("LandBlock", "");
$this->tpl->set_var("PlantsTreesBlock", "");
$this->tpl->set_var("ImprovementsBuildingsBlock", "");
$this->tpl->set_var("MachineriesBlock", "");
*/
$tdCtr++;
}
} else {
$this->tpl->set_var("defaultTDListBlock", "//no default");
$this->tpl->set_var("toggleTDListBlock", "//no Toggle");
$this->tpl->set_var("TDListBlock", "");
}
$this->tpl->set_var("tdCtr", $tdCtr);
break;
case "landTotalMarketValue":
if (!$this->formArray[$key]) {
$this->formArray[$key] = $value;
}
break;
case "landTotalAssessedValue":
if (!$this->formArray[$key]) {
$this->formArray[$key] = $value;
}
break;
case "plantTotalMarketValue":
if (!$this->formArray[$key]) {
$this->formArray[$key] = $value;
}
break;
case "plantTotalAssessedValue":
if (!$this->formArray[$key]) {
$this->formArray[$key] = $value;
}
break;
case "bldgTotalMarketValue":
if (!$this->formArray[$key]) {
$this->formArray[$key] = $value;
}
break;
case "bldgTotalAssessedValue":
if (!$this->formArray[$key]) {
$this->formArray[$key] = $value;
}
break;
case "machTotalMarketValue":
if (!$this->formArray[$key]) {
$this->formArray[$key] = $value;
}
break;
case "machTotalAssessedValue":
if (!$this->formArray[$key]) {
$this->formArray[$key] = $value;
}
break;
case "totalMarketValue":
if (!$this->formArray[$key]) {
$this->formArray[$key] = $value;
}
break;
case "totalAssessedValue":
if (!$this->formArray[$key]) {
$this->formArray[$key] = $value;
}
break;
default:
$this->formArray[$key] = $value;
}
}
$this->formArray["totalMarketValue"] = $this->formArray["landTotalMarketValue"] + $this->formArray["plantTotalMarketValue"] + $this->formArray["bldgTotalMarketValue"] + $this->formArray["machTotalMarketValue"];
$this->formArray["totalAssessedValue"] = $this->formArray["landTotalAssessedValue"] + $this->formArray["plantTotalAssessedValue"] + $this->formArray["bldgTotalAssessedValue"] + $this->formArray["machTotalAssessedValue"];
unset($rptop);
$AFSEncode = new SoapObject(NCCBIZ . "AFSEncode.php", "urn:Object");
$rptop = new RPTOP();
$rptop->setRptopID($this->formArray["rptopID"]);
$rptop->setLandTotalMarketValue($this->formArray["landTotalMarketValue"]);
$rptop->setLandTotalAssessedValue($this->formArray["landTotalAssessedValue"]);
$rptop->setPlantTotalMarketValue($this->formArray["plantTotalMarketValue"]);
$rptop->setPlantTotalPlantAssessedValue($this->formArray["plantTotalAssessedValue"]);
$rptop->setBldgTotalMarketValue($this->formArray["bldgTotalMarketValue"]);
$rptop->setBldgTotalAssessedValue($this->formArray["bldgTotalAssessedValue"]);
$rptop->setMachTotalMarketValue($this->formArray["machTotalMarketValue"]);
$rptop->setMachTotalAssessedValue($this->formArray["machTotalAssessedValue"]);
$rptop->setTotalMarketValue($this->formArray["totalMarketValue"]);
$rptop->setTotalAssessedValue($this->formArray["totalAssessedValue"]);
$rptop->setCreatedBy($this->userID);
$rptop->setModifiedBy($this->userID);
$rptop->setDomDocument();
$RPTOPEncode = new SoapObject(NCCBIZ . "RPTOPEncode.php", "urn:Object");
$rptop->setDomDocument();
$doc = $rptop->getDomDocument();
$xmlStr = $doc->dump_mem(true);
//echo $xmlStr;
if (!($ret = $RPTOPEncode->updateRPTOPtotals($xmlStr))) {
echo "ret=" . $ret;
}
//echo $ret;
}
}
$this->setForm();
$this->setPageDetailPerms();
$this->tpl->set_var("uname", $this->user["uname"]);
$this->tpl->set_var("today", date("F j, Y"));
$this->tpl->set_var("Session", $this->sess->url("") . $this->sess->add_query(array("rptopID" => $this->formArray["rptopID"], "ownerID" => $this->formArray["ownerID"])));
$this->tpl->parse("templatePage", "rptsTemplate");
$this->tpl->finish("templatePage");
$this->tpl->p("templatePage");
}
function getCollectionTargetsForCurrentQuarter($year)
{
$conditionQuarterEndingDate = date("Y-m-d", strtotime($this->formArray["quarterEndingDate"] . " " . $year));
$conditionQuarterBeginningDate = date("Y-m-d", strtotime($this->formArray["quarterBeginningDate"] . " " . $year));
$sql = "SELECT * FROM " . DUE_TABLE . " WHERE dueDate >= '" . $conditionQuarterBeginningDate . "' AND dueDate <= '" . $conditionQuarterEndingDate . "';";
$db = new DB_RPTS();
$db->query($sql);
$dueRecords = new DueRecords();
$dueRecords = new DueRecords();
while ($db->next_record()) {
$due = new Due();
$due->selectRecord($db->f("dueID"));
$dueRecords->arrayList[] = $due;
}
if (is_array($dueRecords->arrayList)) {
foreach ($dueRecords->arrayList as $due) {
if ($due->getDueType() != "Q1") {
$this->formArray["basic"] += $due->getBasicTax();
$this->formArray["sef"] += $due->getSefTax();
$this->formArray["idle"] += $due->getIdleTax();
}
}
}
}
