function displayPlantsTreesList($plantsTreesList)
{
$plantTotal = 0;
if (count($plantsTreesList)) {
$p = 0;
$plantitems = '';
$adjcount = $this->formArray["adjcount"];
$adjfact = '';
$percadj = 0;
$markval = 0;
$valuadj = 0;
$adjmark = 0;
$summcount = $this->formArray["summcount"];
$summuse = '';
$summadj = 0;
$summlvl = 0;
$summasv = 0;
foreach ($plantsTreesList as $key => $plantsTrees) {
if ($this->pl == 0) {
//$this->formArray["arpNumber"] = $plantsTrees->getArpNumber();
//$this->formArray["propertyIndexNumber"] = $plantsTrees->getPropertyIndexNumber();
$this->formArray["surveyNumber"] = $plantsTrees->getSurveyNumber();
//$this->formArray["taxability"] = $plantsTrees->getTaxability();
//$this->formArray["effectivity"] = $plantsTrees->getEffectivity();
$this->formArray["memoranda"] = $plantsTrees->getMemoranda();
if (is_a($plantsTrees->propertyAdministrator, Person)) {
$this->formArray["administrator"] = $plantsTrees->propertyAdministrator->getFullName();
if (is_a($plantsTrees->propertyAdministrator->addressArray[0], "address")) {
$address1 = $plantsTrees->propertyAdministrator->addressArray[0]->getNumber();
$address1 .= " " . $plantsTrees->propertyAdministrator->addressArray[0]->getStreet();
$address1 .= ", " . $plantsTrees->propertyAdministrator->addressArray[0]->getBarangay();
$address2 = $plantsTrees->propertyAdministrator->addressArray[0]->getDistrict();
$address2 .= ", " . $plantsTrees->propertyAdministrator->addressArray[0]->getMunicipalityCity();
$address2 .= ", " . $plantsTrees->propertyAdministrator->addressArray[0]->getProvince();
$this->formArray["adminAddress1"] = $address1;
$this->formArray["adminAddress2"] = $address2;
}
$this->formArray["adminTelno"] = $plantsTrees->propertyAdministrator->getTelephone();
}
if ($this->recommendingApproval == "") {
if (is_numeric($plantsTrees->recommendingApproval)) {
$recommendingApproval = new Person();
$recommendingApproval->selectRecord($plantsTrees->recommendingApproval);
$this->formArray["recommendingApproval"] = $recommendingApproval->getFullName();
$this->recommendingApproval = $recommendingApproval->getFullName();
} else {
$recommendingApproval = $land->recommendingApproval;
$this->formArray["recommendingApproval"] = $recommendingApproval;
$this->recommendingApproval = $recommendingApproval;
}
}
$this->formArray["dateRecommendingApproval"] = $plantsTrees->getRecommendingApprovalDate();
if ($this->approvedBy == "") {
if (is_numeric($plantsTrees->approvedBy)) {
$approvedBy = new Person();
$approvedBy->selectRecord($plantsTrees->approvedBy);
$this->formArray["approvedBy"] = $approvedBy->getFullName();
$this->approvedBy = $approvedBy->getFullName();
} else {
$approvedBy = $approvedBy->recommendingApproval;
$this->formArray["approvedBy"] = $approvedBy;
$this->approvedBy = $approvedBy;
}
}
$this->formArray["dateApprovedBy"] = $plantsTrees->getApprovedByDate();
}
if ($p < 14) {
$this->formArray["plantstart"] -= 17;
$offset = $this->formArray["plantstart"];
// productClass
$plantsTreesClasses = new PlantsTreesClasses();
if (is_numeric($plantsTrees->getProductClass())) {
$plantsTreesClasses->selectRecord($plantsTrees->getProductClass());
$this->formArray["productClass" . ($p + 1)] = $plantsTreesClasses->getDescription();
} else {
$this->formArray["productClass" . ($p + 1)] = $plantsTrees->getProductClass();
}
$plantitems .= '<textitem xpos="55" ypos="' . $offset . '" font="Helvetica" size="8" align="left">' . $this->formArray["productClass" . ($p + 1)] . '</textitem>' . "\r\n";
$this->formArray["areaPlanted" . ($p + 1)] = $plantsTrees->getAreaPlanted();
$plantitems .= '<textitem xpos="228" ypos="' . $offset . '" font="Helvetica" size="8" align="right">' . $this->formArray["areaPlanted" . ($p + 1)] . '</textitem>' . "\r\n";
$this->formArray["totalNumber" . ($p + 1)] = $plantsTrees->getTotalNumber();
$plantitems .= '<textitem xpos="290" ypos="' . $offset . '" font="Helvetica" size="8" align="right">' . $this->formArray["totalNumber" . ($p + 1)] . '</textitem>' . "\r\n";
$this->formArray["nonFruit" . ($p + 1)] = $plantsTrees->getNonFruitBearing();
$plantitems .= '<textitem xpos="342" ypos="' . $offset . '" font="Helvetica" size="8" align="right">' . $this->formArray["nonFruit" . ($p + 1)] . '</textitem>' . "\r\n";
$this->formArray["fruit" . ($p + 1)] = $plantsTrees->getFruitBearing();
$plantitems .= '<textitem xpos="380" ypos="' . $offset . '" font="Helvetica" size="8" align="right">' . $this->formArray["fruit" . ($p + 1)] . '</textitem>' . "\r\n";
$this->formArray["age" . ($p + 1)] = $plantsTrees->getAge();
$plantitems .= '<textitem xpos="426" ypos="' . $offset . '" font="Helvetica" size="8" align="right">' . $this->formArray["age" . ($p + 1)] . '</textitem>' . "\r\n";
$this->formArray["unitPrice" . ($p + 1)] = $plantsTrees->getUnitPrice();
$plantitems .= '<textitem xpos="482" ypos="' . $offset . '" font="Helvetica" size="8" align="right">' . $this->formArray["unitPrice" . ($p + 1)] . '</textitem>' . "\r\n";
$this->formArray["plantMrktVal" . ($p + 1)] = $plantsTrees->getMarketValue();
$plantitems .= '<textitem xpos="545" ypos="' . $offset . '" font="Helvetica" size="8" align="right">' . number_format($plantsTrees->getMarketValue(), 2) . '</textitem>' . "\r\n";
$plantitems .= '<lineitem x1="50" y1="' . ($offset - 6) . '" x2="550" y2="' . ($offset - 6) . '">blurb</lineitem>';
$plantTotal = $plantTotal + toFloat($plantsTrees->getMarketValue());
}
if ($this->pl < 14) {
if ($percadj != (double) $plantsTrees->getPercentAdjustment()) {
if ($markval > 0) {
$adjcount++;
$this->formArray["adjstart"] -= 16;
$offset = $this->formArray["adjstart"];
$adjitems .= '<textitem xpos="147" ypos="' . $offset . '" font="Helvetica" size="8" align="right">' . number_format($markval, 2) . ' (P)' . '</textitem>' . "\r\n";
$adjitems .= '<textitem xpos="155" ypos="' . $offset . '" font="Helvetica" size="8" align="left">' . $adjfact . '</textitem>' . "\r\n";
$adjitems .= '<textitem xpos="405" ypos="' . $offset . '" font="Helvetica" size="8" align="right">' . number_format($percadj, 2) . '</textitem>' . "\r\n";
$adjitems .= '<textitem xpos="475" ypos="' . $offset . '" font="Helvetica" size="8" align="right">' . number_format($valuadj, 2) . '</textitem>' . "\r\n";
$adjitems .= '<textitem xpos="545" ypos="' . $offset . '" font="Helvetica" size="8" align="right">' . number_format($adjmark, 2) . '</textitem>' . "\r\n";
$adjitems .= '<lineitem x1="50" y1="' . ($offset - 5) . '" x2="550" y2="' . ($offset - 5) . '">blurb</lineitem>';
}
$percadj = (double) $plantsTrees->getPercentAdjustment();
$adjfact = $plantsTrees->getAdjustmentFactor();
$markval = 0;
$valuadj = 0;
$adjmark = 0;
}
$markval += (double) $plantsTrees->getMarketValue();
$valuadj += (double) $plantsTrees->getValueAdjustment();
$adjmark += (double) $plantsTrees->getAdjustedMarketValue();
$this->formArray["valAdjFacMrktVal" . ($this->pl + 1)] = $plantsTrees->getMarketValue();
$this->formArray["adjFacTxt" . ($this->pl + 1)] = $plantsTrees->getAdjustmentFactor();
$this->formArray["adjFacInt" . ($this->pl + 1)] = "P";
$this->formArray["adjustment" . ($this->pl + 1)] = $plantsTrees->getPercentAdjustment();
$this->formArray["valueAdjustment" . ($this->pl + 1)] = $plantsTrees->getValueAdjustment();
$this->formArray["valAdjFacAdjMrktVal" . ($this->pl + 1)] = $plantsTrees->getAdjustedMarketValue();
$this->formArray["valAdjFacTotal"] = $this->formArray["valAdjFacTotal"] + toFloat($plantsTrees->getAdjustedMarketValue());
}
if ($this->pl < 14) {
$this->formArray["kind" . ($this->pl + 1)] = $plantsTrees->getKind();
// actualUse
$plantsTreesActualUses = new PlantsTreesActualUses();
//if(is_numeric($plantsTrees->getActualUse())){
$plantsTreesActualUses->selectRecord($plantsTrees->getActualUse());
$this->formArray["propertyActualUse" . ($this->p + 1)] = $plantsTreesActualUses->getDescription();
//}
//else{
// $this->formArray["propertyActualUse".($this->p+1)] = $plantsTrees->getActualUse();
//}
$this->formArray["propertyAdjMrktVal" . ($this->pl + 1)] = $plantsTrees->getAdjustedMarketValue();
$this->formArray["level" . ($this->pl + 1)] = $plantsTrees->getAssessmentLevel();
$this->formArray["assessedValue" . ($this->pl + 1)] = $plantsTrees->getAssessedValue();
$this->formArray["propertyAdjMrktValTotal"] = $this->formArray["propertyAdjMrktValTotal"] + toFloat($plantsTrees->getAdjustedMarketValue());
$this->formArray["propertyTotal"] = $this->formArray["propertyTotal"] + toFloat($plantsTrees->getAssessedValue());
if ($summuse != $plantsTreesActualUses->getDescription()) {
if ($summasv > 0) {
$summcount++;
$this->formArray["summstart"] -= 14;
$offset = $this->formArray["summstart"];
$summitems .= '<textitem xpos="55" ypos="' . $offset . '" font="Helvetica" size="8" align="left">' . 'IMPROVEMENTS' . '</textitem>' . "\r\n";
$summitems .= '<textitem xpos="155" ypos="' . $offset . '" font="Helvetica" size="8" align="left">' . htmlentities($summuse) . '</textitem>' . "\r\n";
$summitems .= '<textitem xpos="405" ypos="' . $offset . '" font="Helvetica" size="8" align="right">' . number_format($summadj, 2) . '</textitem>' . "\r\n";
$summitems .= '<textitem xpos="475" ypos="' . $offset . '" font="Helvetica" size="8" align="right">' . number_format($summlvl, 2) . '</textitem>' . "\r\n";
$summitems .= '<textitem xpos="545" ypos="' . $offset . '" font="Helvetica" size="8" align="right">' . number_format($summasv, 2) . '</textitem>' . "\r\n";
$summitems .= '<lineitem x1="50" y1="' . ($offset - 5) . '" x2="550" y2="' . ($offset - 5) . '">blurb</lineitem>';
}
$summuse = $plantsTreesActualUses->getDescription();
$summlvl = (double) $plantsTrees->getAssessmentLevel();
$summadj = 0;
$summasv = 0;
}
$summadj += (double) $plantsTrees->getAdjustedMarketValue();
/*
$fp=fopen("/home/site/log/landfaas.txt","a");
fwrite($fp,$plantsTrees->getAssessedValue());
fclose($fp);
*/
$summasv += (double) str_replace(",", "", $plantsTrees->getAssessedValue());
}
$p++;
$this->pl++;
}
if ($markval > 0) {
$adjcount++;
$this->formArray["adjstart"] -= 16;
$offset = $this->formArray["adjstart"];
$adjitems .= '<textitem xpos="147" ypos="' . $offset . '" font="Helvetica" size="8" align="right">' . number_format($markval, 2) . ' (P)' . '</textitem>' . "\r\n";
$adjitems .= '<textitem xpos="155" ypos="' . $offset . '" font="Helvetica" size="8" align="left">' . $adjfact . '</textitem>' . "\r\n";
$adjitems .= '<textitem xpos="405" ypos="' . $offset . '" font="Helvetica" size="8" align="right">' . number_format($percadj, 2) . '</textitem>' . "\r\n";
$adjitems .= '<textitem xpos="475" ypos="' . $offset . '" font="Helvetica" size="8" align="right">' . number_format($valuadj, 2) . '</textitem>' . "\r\n";
$adjitems .= '<textitem xpos="545" ypos="' . $offset . '" font="Helvetica" size="8" align="right">' . number_format($adjmark, 2) . '</textitem>' . "\r\n";
$adjitems .= '<lineitem x1="50" y1="' . ($offset - 5) . '" x2="550" y2="' . ($offset - 5) . '">blurb</lineitem>';
}
if ($summasv > 0) {
$summcount++;
$this->formArray["summstart"] -= 14;
$offset = $this->formArray["summstart"];
$summitems .= '<textitem xpos="55" ypos="' . $offset . '" font="Helvetica" size="8" align="left">' . 'IMPROVEMENTS' . '</textitem>' . "\r\n";
$summitems .= '<textitem xpos="155" ypos="' . $offset . '" font="Helvetica" size="8" align="left">' . htmlentities($summuse) . '</textitem>' . "\r\n";
$summitems .= '<textitem xpos="405" ypos="' . $offset . '" font="Helvetica" size="8" align="right">' . number_format($summadj, 2) . '</textitem>' . "\r\n";
$summitems .= '<textitem xpos="475" ypos="' . $offset . '" font="Helvetica" size="8" align="right">' . number_format($summlvl, 2) . '</textitem>' . "\r\n";
$summitems .= '<textitem xpos="545" ypos="' . $offset . '" font="Helvetica" size="8" align="right">' . number_format($summasv, 2) . '</textitem>' . "\r\n";
$summitems .= '<lineitem x1="50" y1="' . ($offset - 5) . '" x2="550" y2="' . ($offset - 5) . '">blurb</lineitem>';
}
for ($pp = $p; $pp < 14; $pp++) {
$this->formArray["plantstart"] -= 17;
$offset = $this->formArray["plantstart"];
$plantitems .= '<lineitem x1="50" y1="' . ($offset - 6) . '" x2="550" y2="' . ($offset - 6) . '">blurb</lineitem>';
}
for ($ll = $adjcount; $ll < 8; $ll++) {
$this->formArray["adjstart"] -= 16;
$offset = $this->formArray["adjstart"];
$adjitems .= '<lineitem x1="50" y1="' . ($offset - 5) . '" x2="550" y2="' . ($offset - 5) . '">blurb</lineitem>';
}
for ($ll = $summcount; $ll < 8; $ll++) {
$this->formArray["summstart"] -= 16;
$offset = $this->formArray["summstart"];
$summitems .= '<lineitem x1="50" y1="' . ($offset - 5) . '" x2="550" y2="' . ($offset - 5) . '">blurb</lineitem>';
}
$this->formArray["adjcount"] += $adjcount;
$this->formArray["adjitems"] .= $adjitems;
$this->formArray["summitems"] .= $summitems;
$this->formArray["plantitems"] = $plantitems;
}
$this->formArray["plantTotal"] = $plantTotal;
}
function displayTD($afsID)
{
$this->tpl->set_block("rptsTemplate", "TDTable", "TDTableBlock");
$this->tpl->set_block("rptsTemplate", "TDDBEmpty", "TDDBEmptyBlock");
$TDDetails = new SoapObject(NCCBIZ . "TDDetails.php", "urn:Object");
if (!($xmlStr = $TDDetails->getTDFromAfsID($this->formArray["afsID"]))) {
$this->tpl->set_var("tdID", "");
$this->tpl->set_var("TDTableBlock", "");
$this->tpl->parse("TDDBEmptyBlock", "TDDBEmpty", true);
} else {
//echo $xmlStr;
if (!($domDoc = domxml_open_mem($xmlStr))) {
$this->tpl->set_var("tdID", "");
$this->tpl->set_var("TDTableBlock", "");
$this->tpl->parse("TDDBEmptyBlock", "TDDBEmpty", true);
} else {
$td = new TD();
$td->parseDomDocument($domDoc);
// update Cancels/CanceledBy TDNumber
$td = $this->updateTDCancelsTDNumber($td);
$td = $this->updateTDCanceledByTDNumber($td);
$this->formArray["tdID"] = $td->tdID;
$this->formArray["taxDeclarationNumber"] = $td->taxDeclarationNumber;
//provincialAssessor
if (is_numeric($td->provincialAssessor)) {
$provincialAssessor = new Person();
$provincialAssessor->selectRecord($td->provincialAssessor);
$this->formArray["provincialAssessor"] = $provincialAssessor->getFullName();
} else {
$this->formArray["provincialAssessor"] = $td->provincialAssessor;
}
//provincialAssessorDate
if ($td->provincialAssessorDate) {
list($dateArr["year"], $dateArr["month"], $dateArr["day"]) = explode("-", $td->provincialAssessorDate);
$this->formArray["pa_yearValue"] = removePreZero($dateArr["year"]);
eval(MONTH_ARRAY);
//$monthArray
$this->formArray["pa_month"] = $monthArray[removePreZero($dateArr["month"])];
$this->formArray["pa_dayValue"] = removePreZero($dateArr["day"]);
} else {
$this->formArray["pa_yearValue"] = "";
$this->formArray["pa_month"] = "";
$this->formArray["pa_dayValue"] = "";
}
//cityMunicipalAssessor
if (is_numeric($td->cityMunicipalAssessor)) {
$cityMunicipalAssessor = new Person();
$cityMunicipalAssessor->selectRecord($td->cityMunicipalAssessor);
$this->formArray["cityMunicipalAssessor"] = $cityMunicipalAssessor->getFullName();
} else {
$this->formArray["cityMunicipalAssessor"] = $td->cityMunicipalAssessor;
}
//cityMunicipalAssessorDate
if ($td->cityMunicipalAssessorDate) {
list($dateArr["year"], $dateArr["month"], $dateArr["day"]) = explode("-", $td->cityMunicipalAssessorDate);
$this->formArray["cm_yearValue"] = removePreZero($dateArr["year"]);
eval(MONTH_ARRAY);
//$monthArray
$this->formArray["cm_month"] = $monthArray[removePreZero($dateArr["month"])];
$this->formArray["cm_dayValue"] = removePreZero($dateArr["day"]);
} else {
$this->formArray["cm_yearValue"] = "";
$this->formArray["cm_month"] = "";
$this->formArray["cm_dayValue"] = "";
}
$this->formArray["cancelsTDNumber"] = $td->cancelsTDNumber;
$this->formArray["canceledByTDNumber"] = $td->canceledByTDNumber;
$this->formArray["taxBeginsWithTheYear"] = $td->taxBeginsWithTheYear;
$this->formArray["ceasesWithTheYear"] = $td->ceasesWithTheYear;
//enteredInRPARForBy
if (is_numeric($td->enteredInRPARForBy)) {
$enteredInRPARForBy = new Person();
$enteredInRPARForBy->selectRecord($td->enteredInRPARForBy);
$this->formArray["enteredInRPARForBy"] = $enteredInRPARForBy->getFullName();
} else {
$this->formArray["enteredInRPARForBy"] = $td->enteredInRPARForBy;
}
$this->formArray["enteredInRPARForYear"] = $td->enteredInRPARForYear;
$this->formArray["previousOwner"] = $td->previousOwner;
$this->formArray["previousAssessedValue"] = $td->previousAssessedValue;
$this->tpl->set_var("previousOwner", $td->previousOwner);
if ($td->previousAssessedValue != "") {
$this->tpl->set_var("previousAssessedValue", number_format(toFloat($td->previousAssessedValue), 2, ".", ","));
}
$this->tpl->set_var("TDDBEmptyBlock", "");
$this->tpl->parse("TDTableBlock", "TDTable", true);
}
}
}
function displayAssessedValues($landList, $plantsTreesList, $improvementsBuildingsList, $machineriesList)
{
$totalMarketValue = 0;
$totalAssessedValue = 0;
$totalArea = 0;
// RC 20091008
$nLandTotalAssessedValue = 0;
$nLandTotalAdjustedMarketValue = 0;
$nLandTotalArea = 0;
$nPlantsTotalAssessedValue = 0;
$nPlantsTotalAdjustedMarketValue = 0;
$nBuildingsTotalAssessedValue = 0;
$nBuildingsTotalAdjustedMarketValue = 0;
$nBuildingsTotalArea = 0;
// RC 20091008
$nMachineriesTotalAssessedValue = 0;
$nMachineriesTotalAdjustedMarketValue = 0;
$swornLandTotal = 0;
$swornImprovementTotal = 0;
$swornOverallTotal = 0;
$i = 1;
$flag = 0;
$counter = 0;
$summlvl = 0;
$summuse = "";
$summcla = "";
//RC 20091001 for summary total by Use & level
if (count($landList)) {
$this->formArray["kindIsLand"] = "X";
// RC 20091006
foreach ($landList as $key => $land) {
if ($i < 5) {
// classification
$landClasses = new LandClasses();
if (is_numeric($land->getClassification())) {
$landClasses->selectRecord($land->getClassification());
$landClassesDescription = $landClasses->getDescription();
$landClassesCode = $landClasses->getCode();
} else {
$landClassesDescription = $land->getClassification();
$landClassesCode = $land->getClassification();
}
// subClass
$landSubclasses = new LandSubclasses();
if (is_numeric($land->getSubClass())) {
$landSubclasses->selectRecord($land->getSubClass());
$landSubclassesDescription = $landSubclasses->getDescription();
$landSubclassesCode = $landSubclasses->getCode();
} else {
$landSubclassesDescription = $land->getSubClass();
$landSubclassesCode = $land->getSubClass();
}
// actualUse
$landActualUses = new LandActualUses();
if (is_numeric($land->getActualUse())) {
$landActualUses->selectRecord($land->getActualUse());
$landActualUsesDescription = $landActualUses->getDescription();
$landActualUsesCode = $landActualUses->getCode();
} else {
$landActualUsesDescription = $land->getActualUse();
$landActualUsesCode = $land->getActualUse();
}
// add pre new
if ($landActualUsesCode == "RE" || $landActualUsesCode == "COM" || $landActualUsesCode == "IND" || $landActualUsesCode == "MI" || $landActualUsesCode == "TI" || $landActualUsesCode == "SP") {
$tempname = $landActualUsesDescription;
$counter += 1;
}
// end of2 add
$totalMarketValue += toFloat($land->getAdjustedMarketValue());
$totalAssessedValue += toFloat($land->getAssessedValue());
$swornLandTotal += toFloat($land->getAdjustedMarketValue());
$swornOverallTotal += toFloat($land->getAdjustedMarketValue());
// display the summary of lands value
if ($counter > 0) {
$this->formArray["propertyActualUse" . $i] = $tempname;
} else {
$this->formArray["propertyActualUse" . $i] = "Agricultural";
}
//RC 20091001 To properly report summary by Actual Use and Level
$thislvl = $land->getAssessmentLevel();
$thisuse = $landActualUsesDescription;
if ($summuse == '') {
//RC first record
$summlvl = $thislvl;
$summuse = $thisuse;
$summcla = $landClassesDescription;
$nLandTotalArea = 0;
$nLandTotalAssessedValue = 0;
$nLandTotalAdjustedMarketValue = 0;
}
if ($summlvl != $thislvl || $summuse != $thisuse) {
//RC print if new assessment level or new actual use
$this->formArray["propertyKind" . $i] = "Land";
$this->formArray["classification" . $i] = $summcla;
$this->formArray["propertyActualUse" . $i] = $summuse;
$this->formArray["findingsTotalArea" . $i] = $nLandTotalArea;
$this->formArray["propertyMarketValue" . $i] = $nLandTotalAdjustedMarketValue;
$this->formArray["propertyAssessmentLevel" . $i] = $summlvl . "%";
$this->formArray["propertyAssessedValue" . $i] = $nLandTotalAssessedValue;
$i++;
$nLandTotalAssessedValue = 0;
$nLandTotalAdjustedMarketValue = 0;
$nLandTotalArea = 0;
$summlvl = $thislvl;
$summuse = $thisuse;
$summcla = $landClassesDescription;
}
$nLandTotalAssessedValue += toFloat($land->getAssessedValue());
$nLandTotalAdjustedMarketValue += toFloat($land->getAdjustedMarketValue());
$nLandTotalArea += toFloat($land->getArea());
}
}
$this->formArray["propertyKind" . $i] = "Land";
$this->formArray["classification" . $i] = $summcla;
$this->formArray["propertyActualUse" . $i] = $summuse;
$this->formArray["findingsTotalArea" . $i] = $nLandTotalArea;
$this->formArray["propertyMarketValue" . $i] = $nLandTotalAdjustedMarketValue;
$this->formArray["propertyAssessmentLevel" . $i] = $summlvl . "%";
$this->formArray["propertyAssessedValue" . $i] = $nLandTotalAssessedValue;
$i++;
// end of summary of lands
}
if (count($plantsTreesList)) {
$this->formArray["kindIsOthers"] = "X";
// RC 20091006
foreach ($plantsTreesList as $key => $plantsTrees) {
if ($i < 5) {
// productClass
$plantsTreesClasses = new PlantsTreesClasses();
if (is_numeric($plantsTrees->getProductClass())) {
$plantsTreesClasses->selectRecord($plantsTrees->getProductClass());
$plantsTreesClassesDescription = $plantsTreesClasses->getDescription();
$plantsTreesClassesCode = $plantsTreesClasses->getCode();
} else {
$plantsTreesClassesDescription = $plantsTrees->getProductClass();
$plantsTreesClassesCode = $plantsTrees->getProductClass();
}
// actualUse
$plantsTreesActualUses = new PlantsTreesActualUses();
if (is_numeric($plantsTrees->getActualUse())) {
$plantsTreesActualUses->selectRecord($plantsTrees->getActualUse());
$plantsTreesActualUsesDescription = $plantsTreesActualUses->getDescription();
$plantsTreesActualUsesCode = $plantsTreesActualUses->getCode();
} else {
$plantsTreesActualUsesDescription = $plantsTrees->getActualUse();
$plantsTreesActualUsesCode = $plantsTrees->getActualUse();
}
//$this->formArray["propertyKind".($i+1)] = "PlantsTrees";
//$this->formArray["propertyActualUse".($i+1)] =$plantsTreesActualUsesDescription;
//$this->formArray["propertyMarketValue".($i+1)] =$plantsTrees->getAdjustedMarketValue();
//$this->formArray["propertyAssessmentLevel".($i+1)] = $plantsTrees->getAssessmentLevel();
//$this->formArray["propertyAssessedValue".($i+1)] = $plantsTrees->getAssessedValue();
$totalMarketValue += toFloat($plantsTrees->getAdjustedMarketValue());
$totalAssessedValue += toFloat($plantsTrees->getAssessedValue());
$nPlantsTotalAssessedValue += toFloat($plantsTrees->getAssessedValue());
$nPlantsTotalAdjustedMarketValue += toFloat($plantsTrees->getAdjustedMarketValue());
$swornLandTotal += toFloat($plantsTrees->getAdjustedMarketValue());
$swornOverallTotal += toFloat($plantsTrees->getAdjustedMarketValue());
//$i++;
}
}
$this->formArray["propertyKind" . $i] = "PlantTrees";
//inserted May 31, 2008
$this->formArray["classification" . $i] = $plantsTreesClassesDescription;
$this->formArray["propertyActualUse" . $i] = $plantsTreesActualUsesDescription;
$this->formArray["propertyMarketValue" . $i] = $nPlantsTotalAdjustedMarketValue;
$this->formArray["propertyAssessmentLevel" . $i] = $plantsTrees->getAssessmentLevel();
$this->formArray["propertyAssessedValue" . $i] = $nPlantsTotalAssessedValue;
$i++;
// additional new line for total of LAND AND PLANT TREES
// $nSwornLandTotal =$nPlantsTotalAdjustedMarketValue + $nLandTotalAdjustedMarketValue;
// $this->formArray["swornLandTotal"] =$nSwornLandTotal; //number_format($nSwornLandTotal,2);
// END
}
if (count($improvementsBuildingsList)) {
$this->formArray["kindIsBuilding"] = "X";
// RC 20091006
// $this->formArray["numberOfStoreys"] = $improvementsBuildings->getNumberOfStoreys();
$nBuildingTotalArea = 0;
$nBuildingTotalAssessedValue = 0;
$nBuildingTotalAdjustedMarketValue = 0;
foreach ($improvementsBuildingsList as $key => $improvementsBuildings) {
if ($i < 5) {
// buildingClassification
$improvementsBuildingsClasses = new ImprovementsBuildingsClasses();
if (is_numeric($improvementsBuildings->getBuildingClassification())) {
$improvementsBuildingsClasses->selectRecord($improvementsBuildings->getBuildingClassification());
$improvementsBuildingsClassesDescription = $improvementsBuildingsClasses->getDescription();
$improvementsBuildingsClassesCode = $improvementsBuildingsClasses->getCode();
} else {
$improvementsBuildingsClassesDescription = $improvementsBuildings->getBuildingClassification();
$improvementsBuildingsClassesCode = $improvementsBuildings->getBuildingClassification();
}
// actualUse
$improvementsBuildingsActualUses = new ImprovementsBuildingsActualUses();
if (is_numeric($improvementsBuildings->getActualUse())) {
$improvementsBuildingsActualUses->selectRecord($improvementsBuildings->getActualUse());
$improvementsBuildingsActualUsesDescription = $improvementsBuildingsActualUses->getDescription();
$improvementsBuildingsActualUsesCode = $improvementsBuildingsActualUses->getCode();
} else {
$improvementsBuildingsActualUsesDescription = $improvementsBuildings->getActualUse();
$improvementsBuildingsActualUsesCode = $improvementsBuildings->getActualUse();
}
$totalMarketValue += toFloat($improvementsBuildings->getAdjustedMarketValue());
$totalAssessedValue += toFloat($improvementsBuildings->getAssessedValue());
$totalArea += $improvementsBuildings->getTotalBuildingArea();
// RC 20091008
$thislvl = $improvementsBuildings->getAssessmentLevel();
$thisuse = $improvementsBuildingsActualUsesDescription;
if ($summuse == '') {
//RC first record
$summlvl = $thislvl;
$summuse = $thisuse;
$summcla = $improvementsBuildingsClassesDescription;
}
if ($summlvl != $thislvl || $summuse != $thisuse) {
//RC print if new assessment level or new actual use
$this->formArray["propertyKind" . $i] = "Land";
$this->formArray["classification" . $i] = $summcla;
$this->formArray["propertyActualUse" . $i] = $summuse;
$this->formArray["findingsTotalArea" . $i] = $nBuildingTotalArea;
$this->formArray["propertyMarketValue" . $i] = $nBuildingTotalAdjustedMarketValue;
$this->formArray["propertyAssessmentLevel" . $i] = $summlvl . "%";
$this->formArray["propertyAssessedValue" . $i] = $nBuildingTotalAssessedValue;
$i++;
$nBuildingTotalAssessedValue = 0;
$nBuildingTotalAdjustedMarketValue = 0;
$nBuildingTotalArea = 0;
$summlvl = $thislvl;
$summuse = $thisuse;
$summcla = $improvementsBuildingsClassesDescription;
}
$nBuildingTotalAssessedValue += toFloat($improvementsBuildings->getAssessedValue());
$nBuildingTotalAdjustedMarketValue += toFloat($improvementsBuildings->getAdjustedMarketValue());
$nBuildingTotalArea += toFloat($improvementsBuildings->getTotalBuildingArea());
$swornImprovementTotal += toFloat($improvementsBuildings->getAdjustedMarketValue());
$swornOverallTotal += toFloat($improvementsBuildings->getAdjustedMarketValue());
}
}
$this->formArray["propertyKind" . $i] = "ImprovementsBuildings";
$this->formArray["classification" . $i] = $improvementsBuildingsClassesDescription;
$this->formArray["propertyActualUse" . $i] = $improvementsBuildingsActualUsesDescription;
$this->formArray["findingsTotalArea" . $i] = $nBuildingTotalArea;
$this->formArray["propertyMarketValue" . $i] = $nBuildingTotalAdjustedMarketValue;
$this->formArray["propertyAssessmentLevel" . $i] = $improvementsBuildings->getAssessmentLevel() . "%";
$this->formArray["propertyAssessedValue" . $i] = $nBuildingTotalAssessedValue;
$i++;
$this->formArray["findingsTotalArea"] = $totalArea;
//RC 20091008
}
if (count($machineriesList)) {
$this->formArray["kindIsMachinery"] = "X";
// RC 20091006
foreach ($machineriesList as $key => $machineries) {
if ($i < 5) {
// kind
$machineriesClasses = new MachineriesClasses();
if (is_numeric($machineries->getKind())) {
$machineriesClasses->selectRecord($machineries->getKind());
$machineriesClassesDescription = $machineriesClasses->getDescription();
$machineriesClassesCode = $machineriesClasses->getCode();
} else {
$machineriesClassesDescription = $machineries->getKind();
$machineriesClassesCode = $machineries->getActualUse();
}
// actualUse
$machineriesActualUses = new MachineriesActualUses();
if (is_numeric($machineries->getActualUse())) {
$machineriesActualUses->selectRecord($machineries->getActualUse());
$machineriesActualUsesDescription = $machineriesActualUses->getDescription();
$machineriesActualUsesCode = $machineriesActualUses->getCode();
} else {
$machineriesActualUsesDescription = $machineries->getActualUse();
$machineriesActualUsesCode = $machineries->getActualUse();
}
$totalMarketValue += toFloat($machineries->getAdjustedMarketValue());
$totalAssessedValue += toFloat($machineries->getAssessedValue());
$nMachineriesTotalAssessedValue += toFloat($machineries->getAssessedValue());
$nMachineriesTotalAdjustedMarketValue += toFloat($machineries->getAdjustedMarketValue());
$swornImprovementTotal += toFloat($machineries->getAdjustedMarketValue());
$swornOverallTotal += toFloat($machineries->getAdjustedMarketValue());
// $i++;
}
}
$this->formArray["propertyKind" . $i] = "Machineries";
$this->formArray["classification" . $i] = $machineriesClassesDescription;
$this->formArray["propertyActualUse" . $i] = $machineriesActualUsesDescription;
$this->formArray["propertyMarketValue" . $i] = $nMachineriesTotalAdjustedMarketValue;
$this->formArray["propertyAssessmentLevel" . $i] = $machineries->getAssessmentLevel();
$this->formArray["propertyAssessedValue" . $i] = $nMachineriesTotalAssessedValue;
$i++;
}
// add pre hehe for sworn statement total and machineries
$this->formArray["swornLandTotal"] = $swornLandTotal;
$this->formArray["swornImprovementTotal"] = $swornImprovementTotal;
$this->formArray["swornOverallTotal"] = $swornOverallTotal;
// $nSwornImprovementTotal =$nMachineriesTotalAdjustedMarketValue + $nBuildingsTotalAdjustedMarketValue;
// $this->formArray["swornImprovementTotal"] =$nSwornImprovementTotal;
// $nSwornOverallTotal =$nSwornImprovementTotal + $nSwornLandTotal;
// $this->formArray["swornOverallTotal"] =$nSwornOverallTotal;
// end
$this->formArray["totalMarketValue"] = $totalMarketValue;
$this->formArray["totalAssessedValue"] = $totalAssessedValue;
$this->formArray["totalAssessedValueInWords"] = makewords($totalAssessedValue);
}
function validationField($oldValue, $newValue, $typeField, $defaultValue)
{
if ($newValue == $oldValue) {
return false;
}
if (empty($newValue)) {
return $defaultValue;
}
switch ($typeField) {
case 'float':
return toFloat($newValue);
break;
case 'int':
return intval($newValue);
break;
case 'bool':
return toFloat($newValue);
break;
}
}
<div class="row">
<div class="col-md-4">
<div class="ibox float-e-margins">
<div class="ibox-title">
<h5>Курсы валют</h5>
</div>
<div class="ibox-content">
<ul class="list-group clear-list">
<?php
$i = 1;
?>
@foreach($_glob['_curr'] as $_curr)
<li class="list-group-item plr10 @if($i == 1) fist-item @endif ">
<span class="pull-right">
{{$_curr['RATE']}} <small class="text-muted">(<?php
echo toFloat($_curr['DIFFERENT']);
?>
)</small>
</span>
<b>{{$_curr['CURRENCY']}}</b>
</li>
<?php
if ($i == 5) {
break;
}
?>
<?php
$i++;
?>
@endforeach
</ul>
function displayAssessedValues($landList, $plantsTreesList, $improvementsBuildingsList, $machineriesList)
{
$totalMarketValue = 0;
$totalAssessedValue = 0;
$nLandTotalAssessedValue = 0;
$nLandTotalAdjustedMarketValue = 0;
$nPlantsTotalAssessedValue = 0;
$nPlantsTotalAdjustedMarketValue = 0;
$nBuildingsTotalAssessedValue = 0;
$nBuildingsTotalAdjustedMarketValue = 0;
$nMachineriesTotalAssessedValue = 0;
$nMachineriesTotalAdjustedMarketValue = 0;
$swornLandTotal = 0;
$swornImprovementTotal = 0;
$swornOverallTotal = 0;
$i = 1;
$flag = 0;
$counter = 0;
if (count($landList)) {
foreach ($landList as $key => $land) {
if ($i < 5) {
// classification
$landClasses = new LandClasses();
if (is_numeric($land->getClassification())) {
$landClasses->selectRecord($land->getClassification());
$landClassesDescription = $landClasses->getDescription();
$landClassesCode = $landClasses->getCode();
} else {
$landClassesDescription = $land->getClassification();
$landClassesCode = $land->getClassification();
}
// subClass
$landSubclasses = new LandSubclasses();
if (is_numeric($land->getSubClass())) {
$landSubclasses->selectRecord($land->getSubClass());
$landSubclassesDescription = $landSubclasses->getDescription();
$landSubclassesCode = $landSubclasses->getCode();
} else {
$landSubclassesDescription = $land->getSubClass();
$landSubclassesCode = $land->getSubClass();
}
// actualUse
$landActualUses = new LandActualUses();
if (is_numeric($land->getActualUse())) {
$landActualUses->selectRecord($land->getActualUse());
$landActualUsesDescription = $landActualUses->getDescription();
$landActualUsesCode = $landActualUses->getCode();
} else {
$landActualUsesDescription = $land->getActualUse();
$landActualUsesCode = $land->getActualUse();
}
// add pre new hehe
if ($landActualUsesCode == "RES" || $landActualUsesCode == "COM" || $landActualUsesCode == "IND" || $landActualUsesCode == "MI" || $landActualUsesCode == "TI" || $landActualUsesCode == "SP") {
$tempname = $landActualUsesDescription;
$counter += 1;
}
// end of add hehe
$totalMarketValue += toFloat($land->getAdjustedMarketValue());
$totalAssessedValue += toFloat($land->getAssessedValue());
$nLandTotalAssessedValue += toFloat($land->getAssessedValue());
$nLandTotalAdjustedMarketValue += toFloat($land->getAdjustedMarketValue());
$swornLandTotal += toFloat($land->getAdjustedMarketValue());
$swornOverallTotal += toFloat($land->getAdjustedMarketValue());
// $this->formArray["propertyKind".($i)] = "Land";
// $this->formArray["propertyActualUse".($i)] = $landActualUsesDescription;
// $this->formArray["propertyMarketValue".($i)] = $land->getAdjustedMarketValue();
// $this->formArray["propertyAssessmentLevel".($i)] = $land->getAssessmentLevel();
// $this->formArray["propertyAssessedValue".($i)] = $land->getAssessedValue();
// $totalMarketValue+=toFloat($land->getAdjustedMarketValue());
// $totalAssessedValue+=toFloat($land->getAssessedValue());
//$i++;
}
}
//}
// display the summary of lands value
if ($counter > 0) {
$this->formArray["propertyActualUse" . $i] = $tempname;
} else {
$this->formArray["propertyActualUse" . $i] = "Agricultural";
}
$this->formArray["propertyKind" . $i] = "Land";
// $this->formArray["propertyActualUse".($i)] = "Agricultural";
$this->formArray["propertyMarketValue" . $i] = $nLandTotalAdjustedMarketValue;
$this->formArray["propertyAssessmentLevel" . $i] = $land->getAssessmentLevel();
$this->formArray["propertyAssessedValue" . $i] = $nLandTotalAssessedValue;
$i++;
// end of summary of lands
}
if (count($plantsTreesList)) {
foreach ($plantsTreesList as $key => $plantsTrees) {
if ($i < 5) {
// productClass
$plantsTreesClasses = new PlantsTreesClasses();
if (is_numeric($plantsTrees->getProductClass())) {
$plantsTreesClasses->selectRecord($plantsTrees->getProductClass());
$plantsTreesClassesDescription = $plantsTreesClasses->getDescription();
$plantsTreesClassesCode = $plantsTreesClasses->getCode();
} else {
$plantsTreesClassesDescription = $plantsTrees->getProductClass();
$plantsTreesClassesCode = $plantsTrees->getProductClass();
}
// actualUse
$plantsTreesActualUses = new PlantsTreesActualUses();
if (is_numeric($plantsTrees->getActualUse())) {
$plantsTreesActualUses->selectRecord($plantsTrees->getActualUse());
$plantsTreesActualUsesDescription = $plantsTreesActualUses->getDescription();
$plantsTreesActualUsesCode = $plantsTreesActualUses->getCode();
} else {
$plantsTreesActualUsesDescription = $plantsTrees->getActualUse();
$plantsTreesActualUsesCode = $plantsTrees->getActualUse();
}
//$this->formArray["propertyKind".($i+1)] = "PlantsTrees";
//$this->formArray["propertyActualUse".($i+1)] =$plantsTreesActualUsesDescription;
//$this->formArray["propertyMarketValue".($i+1)] =$plantsTrees->getAdjustedMarketValue();
//$this->formArray["propertyAssessmentLevel".($i+1)] = $plantsTrees->getAssessmentLevel();
//$this->formArray["propertyAssessedValue".($i+1)] = $plantsTrees->getAssessedValue();
$totalMarketValue += toFloat($plantsTrees->getAdjustedMarketValue());
$totalAssessedValue += toFloat($plantsTrees->getAssessedValue());
$nPlantsTotalAssessedValue += toFloat($plantsTrees->getAssessedValue());
$nPlantsTotalAdjustedMarketValue += toFloat($plantsTrees->getAdjustedMarketValue());
$swornLandTotal += toFloat($plantsTrees->getAdjustedMarketValue());
$swornOverallTotal += toFloat($plantsTrees->getAdjustedMarketValue());
//$i++;
}
}
$this->formArray["propertyKind" . $i] = "PlantTrees";
$this->formArray["propertyActualUse" . $i] = $plantsTreesActualUsesDescription;
$this->formArray["propertyMarketValue" . $i] = $nPlantsTotalAdjustedMarketValue;
$this->formArray["propertyAssessmentLevel" . $i] = $plantsTrees->getAssessmentLevel();
$this->formArray["propertyAssessedValue" . $i] = $nPlantsTotalAssessedValue;
$i++;
// additional new line for total of LAND AND PLANT TREES
// $nSwornLandTotal =$nPlantsTotalAdjustedMarketValue + $nLandTotalAdjustedMarketValue;
// $this->formArray["swornLandTotal"] =$nSwornLandTotal; //number_format($nSwornLandTotal,2);
// END
}
if (count($improvementsBuildingsList)) {
foreach ($improvementsBuildingsList as $key => $improvementsBuildings) {
if ($i < 5) {
// buildingClassification
$improvementsBuildingsClasses = new ImprovementsBuildingsClasses();
if (is_numeric($improvementsBuildings->getBuildingClassification())) {
$improvementsBuildingsClasses->selectRecord($improvementsBuildings->getBuildingClassification());
$improvementsBuildingsClassesDescription = $improvementsBuildingsClasses->getDescription();
$improvementsBuildingsClassesCode = $improvementsBuildingsClasses->getCode();
} else {
$improvementsBuildingsClassesDescription = $improvementsBuildings->getBuildingClassification();
$improvementsBuildingsClassesCode = $improvementsBuildings->getBuildingClassification();
}
// actualUse
$improvementsBuildingsActualUses = new ImprovementsBuildingsActualUses();
if (is_numeric($improvementsBuildings->getActualUse())) {
$improvementsBuildingsActualUses->selectRecord($improvementsBuildings->getActualUse());
$improvementsBuildingsActualUsesDescription = $improvementsBuildingsActualUses->getDescription();
$improvementsBuildingsActualUsesCode = $improvementsBuildingsActualUses->getCode();
} else {
$improvementsBuildingsActualUsesDescription = $improvementsBuildings->getActualUse();
$improvementsBuildingsActualUsesCode = $improvementsBuildings->getActualUse();
}
//$this->formArray["propertyKind".($i+1)] = "ImprovementsBuildings";
//$this->formArray["propertyActualUse".($i+1)] = $improvementsBuildingsActualUsesDescription;
//$this->formArray["propertyMarketValue".($i+1)] = $improvementsBuildings->getAdjustedMarketValue();
//$this->formArray["propertyAssessmentLevel".($i+1)] = $improvementsBuildings->getAssessmentLevel();
//$this->formArray["propertyAssessedValue".($i+1)] = $improvementsBuildings->getAssessedValue();
$totalMarketValue += toFloat($improvementsBuildings->getAdjustedMarketValue());
$totalAssessedValue += toFloat($improvementsBuildings->getAssessedValue());
$nBuildingsTotalAssessedValue += toFloat($improvementsBuildings->getAssessedValue());
$nBuildingsTotalAdjustedMarketValue += toFloat($improvementsBuildings->getAdjustedMarketValue());
$swornImprovementTotal += toFloat($improvementsBuildings->getAdjustedMarketValue());
$swornOverallTotal += toFloat($improvementsBuildings->getAdjustedMarketValue());
// $i++;
}
}
$this->formArray["propertyKind" . $i] = "ImprovementsBuildings";
$this->formArray["propertyActualUse" . $i] = $improvementsBuildingsActualUsesDescription;
$this->formArray["propertyMarketValue" . $i] = $nBuildingsTotalAdjustedMarketValue;
$this->formArray["propertyAssessmentLevel" . $i] = $improvementsBuildings->getAssessmentLevel();
$this->formArray["propertyAssessedValue" . $i] = $nBuildingsTotalAssessedValue;
$i++;
}
if (count($machineriesList)) {
foreach ($machineriesList as $key => $machineries) {
if ($i < 5) {
// kind
$machineriesClasses = new MachineriesClasses();
if (is_numeric($machineries->getKind())) {
$machineriesClasses->selectRecord($machineries->getKind());
$machineriesClassesDescription = $machineriesClasses->getDescription();
$machineriesClassesCode = $machineriesClasses->getCode();
} else {
$machineriesClassesDescription = $machineries->getKind();
$machineriesClassesCode = $machineries->getActualUse();
}
// actualUse
$machineriesActualUses = new MachineriesActualUses();
if (is_numeric($machineries->getActualUse())) {
$machineriesActualUses->selectRecord($machineries->getActualUse());
$machineriesActualUsesDescription = $machineriesActualUses->getDescription();
$machineriesActualUsesCode = $machineriesActualUses->getCode();
} else {
$machineriesActualUsesDescription = $machineries->getActualUse();
$machineriesActualUsesCode = $machineries->getActualUse();
}
//$this->formArray["propertyKind".($i+1)] = "Machineries";
//$this->formArray["propertyActualUse".($i+1)] = $machineriesActualUsesDescription;
//$this->formArray["propertyMarketValue".($i+1)] = $machineries->getAdjustedMarketValue();
//$this->formArray["propertyAssessmentLevel".($i+1)] = $machineries->getAssessmentLevel();
//$this->formArray["propertyAssessedValue".($i+1)] = $machineries->getAssessedValue();
$totalMarketValue += toFloat($machineries->getAdjustedMarketValue());
$totalAssessedValue += toFloat($machineries->getAssessedValue());
$nMachineriesTotalAssessedValue += toFloat($machineries->getAssessedValue());
$nMachineriesTotalAdjustedMarketValue += toFloat($machineries->getAdjustedMarketValue());
$swornImprovementTotal += toFloat($machineries->getAdjustedMarketValue());
$swornOverallTotal += toFloat($machineries->getAdjustedMarketValue());
// $i++;
}
}
$this->formArray["propertyKind" . $i] = "Machineries";
$this->formArray["propertyActualUse" . $i] = $machineriesActualUsesDescription;
$this->formArray["propertyMarketValue" . $i] = $nMachineriesTotalAdjustedMarketValue;
$this->formArray["propertyAssessmentLevel" . $i] = $machineries->getAssessmentLevel();
$this->formArray["propertyAssessedValue" . $i] = $nMachineriesTotalAssessedValue;
$i++;
}
// add pre hehe for sworn statement total and machineries
$this->formArray["swornLandTotal"] = $swornLandTotal;
$this->formArray["swornImprovementTotal"] = $swornImprovementTotal;
$this->formArray["swornOverallTotal"] = $swornOverallTotal;
// $nSwornImprovementTotal =$nMachineriesTotalAdjustedMarketValue + $nBuildingsTotalAdjustedMarketValue;
// $this->formArray["swornImprovementTotal"] =$nSwornImprovementTotal;
$grandTotalArea = $findingsTotalArea + $bfindingsFloorArea;
// $this->formArray["swornOverallTotal"] =$nSwornOverallTotal;
// end
$this->formArray["totalMarketValue"] = $totalMarketValue;
$this->formArray["totalAssessedValue"] = $totalAssessedValue;
$this->formArray["totalAssessedValueInWords"] = makewords($totalAssessedValue);
}
function displayPlantsTreesList($plantsTreesList)
{
$plantTotal = 0;
if (count($plantsTreesList)) {
$p = 0;
foreach ($plantsTreesList as $key => $plantsTrees) {
if ($this->pl == 0) {
//$this->formArray["arpNumber"] = $plantsTrees->getArpNumber();
//$this->formArray["propertyIndexNumber"] = $plantsTrees->getPropertyIndexNumber();
$this->formArray["surveyNumber"] = $plantsTrees->getSurveyNumber();
$this->formArray["taxability"] = $plantsTrees->getTaxability();
$this->formArray["effectivity"] = $plantsTrees->getEffectivity();
$this->formArray["memoranda"] = $plantsTrees->getMemoranda();
if (is_a($plantsTrees->propertyAdministrator, Person)) {
$this->formArray["administrator"] = $plantsTrees->propertyAdministrator->getFullName();
if (is_a($plantsTrees->propertyAdministrator->addressArray[0], "address")) {
$address1 = $plantsTrees->propertyAdministrator->addressArray[0]->getNumber();
$address1 .= " " . $plantsTrees->propertyAdministrator->addressArray[0]->getStreet();
$address1 .= ", " . $plantsTrees->propertyAdministrator->addressArray[0]->getBarangay();
$address2 = $plantsTrees->propertyAdministrator->addressArray[0]->getDistrict();
$address2 .= ", " . $plantsTrees->propertyAdministrator->addressArray[0]->getMunicipalityCity();
$address2 .= ", " . $plantsTrees->propertyAdministrator->addressArray[0]->getProvince();
$this->formArray["adminAddress1"] = $address1;
$this->formArray["adminAddress2"] = $address2;
}
$this->formArray["adminTelno"] = $plantsTrees->propertyAdministrator->getTelephone();
}
if ($this->recommendingApproval == "") {
if (is_numeric($plantsTrees->recommendingApproval)) {
$recommendingApproval = new Person();
$recommendingApproval->selectRecord($plantsTrees->recommendingApproval);
$this->formArray["recommendingApproval"] = $recommendingApproval->getFullName();
$this->recommendingApproval = $recommendingApproval->getFullName();
} else {
$recommendingApproval = $land->recommendingApproval;
$this->formArray["recommendingApproval"] = $recommendingApproval;
$this->recommendingApproval = $recommendingApproval;
}
}
$this->formArray["dateRecommendingApproval"] = $plantsTrees->getRecommendingApprovalDate();
if ($this->approvedBy == "") {
if (is_numeric($plantsTrees->approvedBy)) {
$approvedBy = new Person();
$approvedBy->selectRecord($plantsTrees->approvedBy);
$this->formArray["approvedBy"] = $approvedBy->getFullName();
$this->approvedBy = $approvedBy->getFullName();
} else {
$approvedBy = $approvedBy->recommendingApproval;
$this->formArray["approvedBy"] = $approvedBy;
$this->approvedBy = $approvedBy;
}
}
$this->formArray["dateApprovedBy"] = $plantsTrees->getApprovedByDate();
}
if ($p < 9) {
// productClass
$plantsTreesClasses = new PlantsTreesClasses();
if (is_numeric($plantsTrees->getProductClass())) {
$plantsTreesClasses->selectRecord($plantsTrees->getProductClass());
$this->formArray["productClass" . ($p + 1)] = $plantsTreesClasses->getDescription();
} else {
$this->formArray["productClass" . ($p + 1)] = $plantsTrees->getProductClass();
}
$this->formArray["areaPlanted" . ($p + 1)] = $plantsTrees->getAreaPlanted();
$this->formArray["totalNumber" . ($p + 1)] = $plantsTrees->getTotalNumber();
$this->formArray["nonFruit" . ($p + 1)] = $plantsTrees->getNonFruitBearing();
$this->formArray["fruit" . ($p + 1)] = $plantsTrees->getFruitBearing();
$this->formArray["age" . ($p + 1)] = $plantsTrees->getAge();
$this->formArray["unitPrice" . ($p + 1)] = $plantsTrees->getUnitPrice();
$this->formArray["plantMrktVal" . ($p + 1)] = $plantsTrees->getMarketValue();
$plantTotal = $plantTotal + toFloat($plantsTrees->getMarketValue());
}
if ($this->pl < 6) {
$this->formArray["valAdjFacMrktVal" . ($this->pl + 1)] = $plantsTrees->getMarketValue();
$this->formArray["adjFacTxt" . ($this->pl + 1)] = $plantsTrees->getAdjustmentFactor();
$this->formArray["adjFacInt" . ($this->pl + 1)] = "P";
$this->formArray["adjustment" . ($this->pl + 1)] = $plantsTrees->getPercentAdjustment();
$this->formArray["valueAdjustment" . ($this->pl + 1)] = $plantsTrees->getValueAdjustment();
$this->formArray["valAdjFacAdjMrktVal" . ($this->pl + 1)] = $plantsTrees->getAdjustedMarketValue();
$this->formArray["valAdjFacTotal"] = $this->formArray["valAdjFacTotal"] + toFloat($plantsTrees->getAdjustedMarketValue());
}
if ($this->pl < 5) {
$this->formArray["kind" . ($this->pl + 1)] = $plantsTrees->getKind();
// actualUse
$plantsTreesActualUses = new PlantsTreesActualUses();
if (is_numeric($plantsTrees->getActualUse())) {
$plantsTreesActualUses->selectRecord($plantsTrees->getActualUse());
$this->formArray["propertyActualUse" . ($this->p + 1)] = $plantsTreesActualUses->getDescription();
} else {
$this->formArray["propertyActualUse" . ($this->p + 1)] = $plantsTrees->getActualUse();
}
$this->formArray["propertyAdjMrktVal" . ($this->pl + 1)] = $plantsTrees->getAdjustedMarketValue();
$this->formArray["level" . ($this->pl + 1)] = $plantsTrees->getAssessmentLevel();
$this->formArray["assessedValue" . ($this->pl + 1)] = $plantsTrees->getAssessedValue();
$this->formArray["propertyAdjMrktValTotal"] = $this->formArray["propertyAdjMrktValTotal"] + toFloat($plantsTrees->getAdjustedMarketValue());
$this->formArray["propertyTotal"] = $this->formArray["propertyTotal"] + toFloat($plantsTrees->getAssessedValue());
}
$p++;
$this->pl++;
}
}
$this->formArray["plantTotal"] = $plantTotal;
}
/**
* Store a newly created resource in storage.
*
* @param Request $request
* @return Response
*/
public function store(Purchase $purchaseModel, History $historyModel, Product $productModel, User $userModel, Request $request)
{
if (isset($_POST['update_template'])) {
//pr($_POST);
if (isset($_POST['col']) and !empty($_POST['col'])) {
$fields = serialize($_POST['col']);
} else {
$fields = null;
}
if (!empty($_POST['name_template'])) {
$template_name = $_POST['name_template'];
} elseif (isset($_POST['selected_name_template']) and !empty($_POST['selected_name_template'])) {
$template_name = $_POST['selected_name_template'];
} else {
$template_name = 'По умолчанию';
}
$template_id = $userModel->checkTemplates($template_name, 'purchases');
if ($template_id != null) {
$res = array('fields' => $fields);
$userModel->updateTemplate($res, $template_id, 'purchases');
} else {
//добавляем шаблон
$res = array('type' => 'purchases', 'user_id' => Auth::User()->id, 'template' => $template_name, 'fields' => $fields);
$userModel->addTemplates($res, 'purchases');
}
Session::flash('message', GetMessages("SUCCESS_SETTINGS_SAVE"));
return redirect($_SERVER['HTTP_REFERER']);
}
if (isset($_POST['delete_template'])) {
$userModel->deleteTemplate($_POST['selected_name_template'], 'purchases');
Session::flash('message', GetMessages("SUCCESS_TEMPLATE_DELETE"));
return redirect($_SERVER['HTTP_REFERER']);
}
if (isset($_POST['select_template'])) {
$userModel->updateUser(Auth::User()->id, array('template_prod_id' => $_POST['selected_name_template']));
Session::flash('message', GetMessages("SUCCESS_SETTINGS_SAVE"));
return redirect($_SERVER['HTTP_REFERER']);
}
if (isset($_POST['search_button'])) {
//pr($_POST);
if (strlen($_POST['search_field']) > 0) {
return redirect()->route('purchase.search.index', ['string' => $_POST['search_field']]);
} else {
return redirect($_SERVER['HTTP_REFERER']);
}
}
if (isset($_POST['update_purchase'])) {
if (!right('EditProduct')) {
abort(404);
}
unset($_POST['update_purchase']);
unset($_POST['_token']);
//pr($_POST);
$res = array();
foreach ($_POST as $element) {
if (array_key_exists('check', $element)) {
unset($element['check']);
//sort
isset($element['sort']['new']) ? $element['sort']['new'] = intval($element['sort']['new']) : ($field['sort']['new'] = '');
if ($element['sort']['new'] != $element['sort']['old']) {
$res[$element['id']]['purchase.sort'] = $element['sort']['new'];
}
//flag
!isset($element['flag']['new']) ? $element['flag']['new'] = 0 : ($element['flag']['new'] = 1);
if ($element['flag']['new'] != $element['flag']['old']) {
$res[$element['id']]['products.flag'] = $element['flag']['new'];
}
//base_price
isset($element['base_price']['new']) ? $element['base_price']['new'] = toFloat($element['base_price']['new']) : ($field['base_price']['new'] = 0);
if ($element['base_price']['new'] != $element['base_price']['old']) {
$res[$element['id']]['base_price'] = $element['base_price']['new'];
}
//currency
if ($element['currency']['new'] != $element['currency']['old']) {
$res[$element['id']]['currency'] = $element['currency']['new'];
}
//raise
isset($element['raise']['new']) ? $element['raise']['new'] = toFloat($element['raise']['new']) : ($field['raise']['new'] = 0);
if ($element['raise']['new'] != $element['raise']['old']) {
$res[$element['id']]['raise'] = $element['raise']['new'];
}
//discount_price
isset($element['discount_price']['new']) ? $element['discount_price']['new'] = toFloat($element['discount_price']['new']) : ($field['discount_price']['new'] = 0);
if ($element['discount_price']['new'] != $element['discount_price']['old']) {
$res[$element['id']]['discount_price'] = $element['discount_price']['new'];
}
//discount_bulk
isset($element['discount_bulk']['new']) ? $element['discount_bulk']['new'] = toFloat($element['discount_bulk']['new']) : ($field['discount_bulk']['new'] = 0);
if ($element['discount_bulk']['new'] != $element['discount_bulk']['old']) {
$res[$element['id']]['discount_bulk'] = $element['discount_bulk']['new'];
}
//comment
if ($element['comment']['new'] != $element['comment']['old']) {
$res[$element['id']]['comment'] = trim($element['comment']['new']);
}
//purchase update
if (isset($res[$element['id']]['products.flag']) or isset($res[$element['id']]['purchase.sort']) or isset($res[$element['id']]['base_price']) or isset($res[$element['id']]['currency']) or isset($res[$element['id']]['raise']) or isset($res[$element['id']]['discount_price']) or isset($res[$element['id']]['discount_bulk']) or isset($res[$element['id']]['comment'])) {
$res[$element['id']]['product_id'] = $element['product_id'];
$res[$element['id']]['purchase.updated_at'] = date('Y-m-d H:i:s');
$res[$element['id']]['purchase.user_id'] = Auth::User()->id;
}
}
}
if (count($res) > 0) {
//pr($res);
$purchaseModel->updatePurchase($res);
$historyModel->saveHistory('update_purchase', $res);
Session::flash('message', GetMessages("SUCCESS_DATA_PRODUCTS_UPDATE"));
return redirect($_SERVER['HTTP_REFERER']);
} else {
Session::flash('message', GetMessages("ERROR_NO_DATA_FOR_UPDATE"));
return redirect($_SERVER['HTTP_REFERER']);
}
}
if (isset($_POST['cp_page_sbmt'])) {
$userModel->where('id', Auth::User()->id)->update(array('count_products' => $_POST['cp_page_val']));
Session::flash('message', GetMessages("SUCCESS_UPDATE"));
return redirect($_SERVER['HTTP_REFERER']);
}
}
function displayImprovementsBuildingsList($improvementsBuildingsList)
{
if (count($improvementsBuildingsList)) {
$i = 0;
foreach ($improvementsBuildingsList as $key => $improvementsBuildings) {
if ($i == 0) {
//$this->formArray["arpNumber"] = $improvementsBuildings->getArpNumber();
//$this->formArray["propertyIndexNumber"] = $improvementsBuildings->getPropertyIndexNumber();
$this->formArray["landPIN"] = $improvementsBuildings->getLandPIN();
$this->displayLandPINDetails();
$this->formArray["foundation"] = $improvementsBuildings->getFoundation();
$this->formArray["windows"] = $improvementsBuildings->getWindows();
$this->formArray["columns"] = $improvementsBuildings->getColumnsBldg();
$this->formArray["stairs"] = $improvementsBuildings->getStairs();
$this->formArray["beams"] = $improvementsBuildings->getBeams();
$this->formArray["partition"] = $improvementsBuildings->getPartition();
$this->formArray["trussFraming"] = $improvementsBuildings->getTrussFraming();
$this->formArray["wallFinish"] = $improvementsBuildings->getWallFinish();
$this->formArray["roof"] = $improvementsBuildings->getRoof();
$this->formArray["electrical"] = $improvementsBuildings->getElectrical();
$this->formArray["exteriorWalls"] = $improvementsBuildings->getExteriorWalls();
$this->formArray["toiletAndBath"] = $improvementsBuildings->getToiletAndBath();
$this->formArray["flooring"] = $improvementsBuildings->getFlooring();
$this->formArray["plumbingSewer"] = $improvementsBuildings->getPlumbingSewer();
$this->formArray["doors"] = $improvementsBuildings->getDoors();
$this->formArray["fixtures"] = $improvementsBuildings->getFixtures();
$this->formArray["ceiling"] = $improvementsBuildings->getCeiling();
$this->formArray["dateConstructed"] = $improvementsBuildings->getDateConstructed();
$this->formArray["structuralTypes"] = $improvementsBuildings->getStructuralTypes();
$this->formArray["dateOccupied"] = $improvementsBuildings->getDateOccupied();
$this->formArray["memoranda"] = $improvementsBuildings->getMemoranda();
// buildingClassification
$improvementsBuildingsClasses = new ImprovementsBuildingsClasses();
if (is_numeric($improvementsBuildings->getBuildingClassification())) {
$improvementsBuildingsClasses->selectRecord($improvementsBuildings->getBuildingClassification());
$this->formArray["classification"] = $improvementsBuildingsClasses->getDescription();
} else {
$this->formArray["classification"] = $improvementsBuildings->getBuildingClassification();
}
$this->formArray["dateCompleted"] = $improvementsBuildings->getDateCompleted();
$this->formArray["bldgPermit"] = $improvementsBuildings->getBuildingPermit();
$this->formArray["areaOfGroundFloor"] = $improvementsBuildings->getAreaOfGroundFloor();
$this->formArray["buildingAge"] = $improvementsBuildings->getBuildingAge();
$this->formArray["totalBuildingArea"] = $improvementsBuildings->getTotalBuildingArea();
$this->formArray["numberOfStoreys"] = $improvementsBuildings->getNumberOfStoreys();
$this->formArray["cctNumber"] = $improvementsBuildings->getCctNumber();
// NCC Modification checked and implemented by K2 : November 18, 2005
// details:
// commented out line 448, changed lines 451 to 455
//$this->formArray["bldgCore1"] = $improvementsBuildings->getBuildingCoreAndAdditionalItems();
$this->formArray["bldgCore1"] = number_format($improvementsBuildings->getUnitValue(), 2);
$this->formArray["depMarketValue"] = $improvementsBuildings->getDepreciatedMarketValue();
$this->formArray["marketValue"] = number_format($improvementsBuildings->getMarketValue(), 2);
$this->formArray["addItems"] = number_format($improvementsBuildings->getAddItems(), 2);
$this->formArray["subTotal"] = "";
$this->formArray["adjustments"] = number_format($improvementsBuildings->getMarketValue() + $improvementsBuildings->getAddItems(), 2);
$this->formArray["depreciationRate"] = $improvementsBuildings->getDepreciationRate();
$this->formArray["subTotal2"] = "";
$this->formArray["depreciationRate"] = $improvementsBuildings->getDepreciationRate();
$this->formArray["accumulatedDepreciation"] = $improvementsBuildings->getAccumulatedDepreciation();
if (is_a($improvementsBuildings->propertyAdministrator, Person)) {
if ($improvementsBuildings->propertyAdministrator->getLastName() != "") {
$this->formArray["administrator"] = $improvementsBuildings->propertyAdministrator->getFullName();
}
if (is_a($improvementsBuildings->propertyAdministrator->addressArray[0], "address")) {
$address1 = $improvementsBuildings->propertyAdministrator->addressArray[0]->getNumber();
if ($address1 != "") {
$address1 .= " ";
}
$address1 .= $improvementsBuildings->propertyAdministrator->addressArray[0]->getStreet();
if ($address1 != "") {
$address1 .= ", ";
}
$address1 .= $improvementsBuildings->propertyAdministrator->addressArray[0]->getBarangay();
$address2 = $improvementsBuildings->propertyAdministrator->addressArray[0]->getDistrict();
if ($address2 != "") {
$address2 .= ", ";
}
$address2 .= $improvementsBuildings->propertyAdministrator->addressArray[0]->getMunicipalityCity();
if ($address2 != "") {
$address2 .= ", ";
}
$address2 .= $improvementsBuildings->propertyAdministrator->addressArray[0]->getProvince();
$this->formArray["adminAddress1"] = $address1;
$this->formArray["adminAddress2"] = $address2;
}
$this->formArray["adminTelno"] = $improvementsBuildings->propertyAdministrator->getTelephone();
}
// recommendingApproval
if (is_numeric($improvementsBuildings->recommendingApproval)) {
$recommendingApproval = new Person();
$recommendingApproval->selectRecord($improvementsBuildings->recommendingApproval);
$this->formArray["recommendingApproval"] = $recommendingApproval->getFullName();
$this->recommendingApproval = $recommendingApproval->getFullName();
} else {
$recommendingApproval = $improvementsBuildings->recommendingApproval;
$this->formArray["recommendingApproval"] = $recommendingApproval;
$this->recommendingApproval = $recommendingApproval;
}
$this->formArray["dateRecommendingApproval"] = $improvementsBuildings->getRecommendingApprovalDate();
// approvedBy
if (is_numeric($improvementsBuildings->approvedBy)) {
$approvedBy = new Person();
$approvedBy->selectRecord($improvementsBuildings->approvedBy);
$this->formArray["approvedBy"] = $approvedBy->getFullName();
$this->approvedBy = $approvedBy->getFullName();
} else {
$approvedBy = $improvementsBuildings->approvedBy;
$this->formArray["approvedBy"] = $approvedBy;
$this->approvedBy = $approvedBy;
}
$this->formArray["dateApprovedBy"] = $improvementsBuildings->getApprovedByDate();
// appraisedBy (assessedBy)
if (is_numeric($improvementsBuildings->appraisedBy)) {
$appraisedBy = new Person();
$appraisedBy->selectRecord($improvementsBuildings->appraisedBy);
$this->formArray["assessedBy"] = $appraisedBy->getFullName();
$this->appraisedBy = $appraisedBy->getFullName();
} else {
$appraisedBy = $improvementsBuildings->appraisedBy;
$this->formArray["assessedBy"] = $appraisedBy;
$this->appraisedBy = $appraisedBy;
}
$this->formArray["dateAssessedBy"] = $improvementsBuildings->getAppraisedByDate();
}
if ($i < 4) {
$this->formArray["kind" . ($i + 1)] = $improvementsBuildings->getKind();
// actualUse
$improvementsBuildingsActualUses = new ImprovementsBuildingsActualUses();
if (is_numeric($improvementsBuildings->getActualUse())) {
$improvementsBuildingsActualUses->selectRecord($improvementsBuildings->getActualUse());
$this->formArray["actualUse" . ($i + 1)] = $improvementsBuildingsActualUses->getDescription();
} else {
$this->formArray["actualUse" . ($i + 1)] = $improvementsBuildings->getActualUse();
}
// NCC Modification checked and implemented by K2 : November 18, 2005
// details:
// commented out line 557, added line 558, changed "marketValue" to "depMarketValue"
//$this->formArray["marketValue".($i+1)] = $improvementsBuildings->getMarketValue();
$this->formArray["depMarketValue" . ($i + 1)] = $improvementsBuildings->getDepreciatedMarketValue();
$this->formArray["assessmentLevel" . ($i + 1)] = $improvementsBuildings->getAssessmentLevel();
$this->formArray["assessedValue" . ($i + 1)] = $improvementsBuildings->getAssessedValue();
$this->formArray["total"] += toFloat($this->formArray["assessedValue" . ($i + 1)]);
}
$i++;
}
// NCC Modification checked and implemented by K2 : November 18, 2005
// details:
// added for() loop in lines 572 to 578 that resets values to:
// "kind, actualUse, depMarketValue, assessmentLevel" and "assessedValue"
for ($j = $i; $j < 4; $j++) {
$this->formArray["kind" . ($j + 1)] = '';
$this->formArray["actualUse" . ($j + 1)] = '';
$this->formArray["depMarketValue" . ($j + 1)] = '';
$this->formArray["assessmentLevel" . ($j + 1)] = '';
$this->formArray["assessedValue" . ($j + 1)] = '';
}
}
$this->formArray["valAdjFacTotal"] = $valAdjFacTotal;
$this->formArray["propertyAdjMrktValTotal"] = $propertyAdjMrktValTotal;
$this->formArray["propertyTotal"] = $propertyTotal;
}
function getRetRate($list)
{
//配资列表
foreach ($list as $k => $v) {
$list[$k]['retrate'] = toFloat($v['profit_loss'] / ($v['principal'] + $v['shares_money']) * 100);
}
return $list;
}
/**
* Store a newly created resource in storage.
*
* @param Request $request
* @return Response
*/
public function store(Label $labelModel, Request $request, Purchase $purchaseModel, User $userModel, Product $productModel, History $historyModel)
{
if (isset($_POST['update_template'])) {
//pr($_POST);
if (isset($_POST['col']) and !empty($_POST['col'])) {
$fields = serialize($_POST['col']);
} else {
$fields = null;
}
if (!empty($_POST['name_template'])) {
$template_name = $_POST['name_template'];
} elseif (isset($_POST['selected_name_template']) and !empty($_POST['selected_name_template'])) {
$template_name = $_POST['selected_name_template'];
} else {
$template_name = 'По умолчанию';
}
$template_id = $userModel->checkTemplates($template_name, 'products');
if ($template_id != null) {
$res = array('fields' => $fields);
$userModel->updateTemplate($res, $template_id, 'products');
} else {
//добавляем шаблон
$res = array('type' => 'products', 'user_id' => Auth::User()->id, 'template' => $template_name, 'fields' => $fields);
$userModel->addTemplates($res, 'products');
}
Session::flash('message', GetMessages("SUCCESS_SETTINGS_SAVE"));
return redirect($_SERVER['HTTP_REFERER']);
}
if (isset($_POST['delete_template'])) {
$userModel->deleteTemplate($_POST['selected_name_template'], 'products');
Session::flash('message', GetMessages("SUCCESS_TEMPLATE_DELETE"));
return redirect($_SERVER['HTTP_REFERER']);
}
if (isset($_POST['select_template'])) {
$userModel->updateUser(Auth::User()->id, array('template_prod_id' => $_POST['selected_name_template']));
Session::flash('message', GetMessages("SUCCESS_SETTINGS_SAVE"));
return redirect($_SERVER['HTTP_REFERER']);
}
if (isset($_POST['search_button'])) {
//pr($_POST);
if (strlen($_POST['search_field']) > 0) {
return redirect()->route('product.search.index', ['string' => $_POST['search_field']]);
} else {
return redirect($_SERVER['HTTP_REFERER']);
}
}
if (isset($_POST['update_products'])) {
if (!right('EditProduct')) {
abort(404);
}
unset($_POST['update_products']);
unset($_POST['_token']);
$res = array();
$reViewAbsents = false;
//pr($_POST);
foreach ($_POST as $element) {
if (array_key_exists('check', $element)) {
unset($element['check']);
$childs = false;
if (isset($element['childs'])) {
$childs = unserialize($productModel->where('id', $element['id'])->pluck('childs'));
}
//status
!isset($element['status']['new']) ? $element['status']['new'] = 0 : ($element['status']['new'] = 1);
if ($element['status']['new'] != $element['status']['old']) {
$res[$element['id']]['products.status'] = $element['status']['new'];
}
//name
if ($element['name']['new'] != $element['name']['old']) {
$res[$element['id']]['products.name'] = trim($element['name']['new']);
}
//monitoring_name
if ($element['monitoring_name']['new'] != $element['monitoring_name']['old']) {
$res[$element['id']]['products.monitoring_name'] = trim($element['monitoring_name']['new']);
}
//absent
if ($element['absent']['new'] != $element['absent']['old']) {
if (empty($element['absent']['new'])) {
$res[$element['id']]['products.absent'] = null;
} else {
$res[$element['id']]['products.absent'] = trim($element['absent']['new']);
}
$reViewAbsents = true;
}
//article
if ($element['article']['new'] != $element['article']['old']) {
$res[$element['id']]['products.article'] = trim($element['article']['new']);
}
//in_stock
!isset($element['in_stock']['new']) ? $element['in_stock']['new'] = 0 : ($element['in_stock']['new'] = 1);
if ($element['in_stock']['new'] != $element['in_stock']['old']) {
$res[$element['id']]['products.in_stock'] = $element['in_stock']['new'];
}
//flag
!isset($element['flag']['new']) ? $element['flag']['new'] = 0 : ($element['flag']['new'] = 1);
if ($element['flag']['new'] != $element['flag']['old']) {
$res[$element['id']]['products.flag'] = $element['flag']['new'];
}
//sort
if ($element['sort']['new'] != $element['sort']['old']) {
$res[$element['id']]['products.sort'] = $element['sort']['new'];
}
//mrc
if ($element['mrc']['new'] != $element['mrc']['old']) {
$res[$element['id']]['products.mrc'] = toFloat($element['mrc']['new']);
}
//mrc_currency
if ($element['mrc_currency']['new'] != $element['mrc_currency']['old']) {
$res[$element['id']]['products.mrc_currency'] = $element['mrc_currency']['new'];
}
//mrc_relation
if ($element['mrc_relation']['new'] != $element['mrc_relation']['old']) {
$res[$element['id']]['products.mrc_relation'] = trim($element['mrc_relation']['new']);
}
//mrc_raise_relation
if ($element['mrc_raise_relation']['new'] != $element['mrc_raise_relation']['old']) {
$res[$element['id']]['products.mrc_raise_relation'] = trim($element['mrc_raise_relation']['new']);
}
//price
if ($element['price']['new'] != $element['price']['old']) {
$res[$element['id']]['products.price'] = toFloat($element['price']['new']);
}
//price_currency
if ($element['price_currency']['new'] != $element['price_currency']['old']) {
$res[$element['id']]['products.price_currency'] = $element['price_currency']['new'];
}
//price_relation
if ($element['price_relation']['new'] != $element['price_relation']['old']) {
$res[$element['id']]['products.price_relation'] = trim($element['price_relation']['new']);
}
//price_raise_relation
if ($element['price_raise_relation']['new'] != $element['price_raise_relation']['old']) {
$res[$element['id']]['products.price_raise_relation'] = trim($element['price_raise_relation']['new']);
}
//target_margin
isset($element['target_margin']['new']) ? $element['target_margin']['new'] = toFloat($element['target_margin']['new']) : ($element['target_margin']['new'] = 0);
if ($element['target_margin']['new'] != $element['target_margin']['old']) {
$res[$element['id']]['products.target_margin'] = $element['target_margin']['new'];
}
//common_price
isset($element['common_price']['new']) ? $element['common_price']['new'] = toFloat($element['common_price']['new']) : ($element['common_price']['new'] = 0);
if ($element['common_price']['new'] != $element['common_price']['old']) {
$res[$element['id']]['products.common_price'] = $element['common_price']['new'];
}
if (isset($element['GK_enabled']['old'])) {
//GK_enabled
!isset($element['GK_enabled']['new']) ? $element['GK_enabled']['new'] = 0 : ($element['GK_enabled']['new'] = 1);
if ($element['GK_enabled']['new'] != $element['GK_enabled']['old']) {
$res[$element['id']]['GK.enabled'] = $element['GK_enabled']['new'];
}
//GK_yandex_enabled
!isset($element['GK_yandex_enabled']['new']) ? $element['GK_yandex_enabled']['new'] = 0 : ($element['GK_yandex_enabled']['new'] = 1);
if ($element['GK_yandex_enabled']['new'] != $element['GK_yandex_enabled']['old']) {
$res[$element['id']]['GK.yandex_enabled'] = $element['GK_yandex_enabled']['new'];
}
//GK_price
if ($element['GK_price']['new'] != $element['GK_price']['old']) {
$res[$element['id']]['GK.price'] = toFloat($element['GK_price']['new']);
if ($childs) {
foreach ($childs as $child) {
$res[$child['product_id']]['GK.price'] = $res[$element['id']]['GK.price'] * $child['multiplicator'];
$res[$child['product_id']]['GK.to_export'] = 1;
}
}
}
//GK_price_currency
if ($element['GK_price_currency']['new'] != $element['GK_price_currency']['old']) {
$res[$element['id']]['GK.currency'] = $element['GK_price_currency']['new'];
if ($childs) {
foreach ($childs as $child) {
$res[$child['product_id']]['GK.currency'] = $res[$element['id']]['GK.currency'];
$res[$child['product_id']]['GK.to_export'] = 1;
}
}
}
//GK update
if (isset($res[$element['id']]['products.in_stock']) or isset($res[$element['id']]['GK.enabled']) or isset($res[$element['id']]['GK.yandex_enabled']) or isset($res[$element['id']]['GK.price']) or isset($res[$element['id']]['GK.currency'])) {
$res[$element['id']]['GK.to_export'] = 1;
$res[$element['id']]['GK.updated_at'] = date('Y-m-d H:i:s');
$res[$element['id']]['GK.user_id'] = Auth::User()->id;
$res[$element['id']]['products.updated_at'] = date('Y-m-d H:i:s');
$res[$element['id']]['products.user_id'] = Auth::User()->id;
}
}
if (isset($element['TV_enabled']['old'])) {
//TV_enabled
!isset($element['TV_enabled']['new']) ? $element['TV_enabled']['new'] = 0 : ($element['TV_enabled']['new'] = 1);
if ($element['TV_enabled']['new'] != $element['TV_enabled']['old']) {
$res[$element['id']]['TV.enabled'] = $element['TV_enabled']['new'];
}
//TV_yandex_enabled
!isset($element['TV_yandex_enabled']['new']) ? $element['TV_yandex_enabled']['new'] = 0 : ($element['TV_yandex_enabled']['new'] = 1);
if ($element['TV_yandex_enabled']['new'] != $element['TV_yandex_enabled']['old']) {
$res[$element['id']]['TV.yandex_enabled'] = $element['TV_yandex_enabled']['new'];
}
//TV_price
if ($element['TV_price']['new'] != $element['TV_price']['old']) {
$res[$element['id']]['TV.price'] = toFloat($element['TV_price']['new']);
if ($childs) {
foreach ($childs as $child) {
$res[$child['product_id']]['TV.price'] = $res[$element['id']]['TV.price'] * $child['multiplicator'];
$res[$child['product_id']]['TV.to_export'] = 1;
}
}
}
//TV_price_currency
if ($element['TV_price_currency']['new'] != $element['TV_price_currency']['old']) {
$res[$element['id']]['TV.currency'] = $element['TV_price_currency']['new'];
if ($childs) {
foreach ($childs as $child) {
$res[$child['product_id']]['TV.currency'] = $res[$element['id']]['TV.currency'];
$res[$child['product_id']]['TV.to_export'] = 1;
}
}
}
//TV update
if (isset($res[$element['id']]['products.in_stock']) or isset($res[$element['id']]['TV.enabled']) or isset($res[$element['id']]['TV.yandex_enabled']) or isset($res[$element['id']]['TV.price']) or isset($res[$element['id']]['TV.currency'])) {
$res[$element['id']]['TV.to_export'] = 1;
$res[$element['id']]['TV.updated_at'] = date('Y-m-d H:i:s');
$res[$element['id']]['TV.user_id'] = Auth::User()->id;
$res[$element['id']]['products.updated_at'] = date('Y-m-d H:i:s');
$res[$element['id']]['products.user_id'] = Auth::User()->id;
}
}
if (isset($element['MK_enabled']['old'])) {
//MK_enabled
!isset($element['MK_enabled']['new']) ? $element['MK_enabled']['new'] = 0 : ($element['MK_enabled']['new'] = 1);
if ($element['MK_enabled']['new'] != $element['MK_enabled']['old']) {
$res[$element['id']]['MK.enabled'] = $element['MK_enabled']['new'];
}
//MK_yandex_enabled
!isset($element['MK_yandex_enabled']['new']) ? $element['MK_yandex_enabled']['new'] = 0 : ($element['MK_yandex_enabled']['new'] = 1);
if ($element['MK_yandex_enabled']['new'] != $element['MK_yandex_enabled']['old']) {
$res[$element['id']]['MK.yandex_enabled'] = $element['MK_yandex_enabled']['new'];
}
//MK_price
if ($element['MK_price']['new'] != $element['MK_price']['old']) {
$res[$element['id']]['MK.price'] = toFloat($element['MK_price']['new']);
if ($childs) {
foreach ($childs as $child) {
$res[$child['product_id']]['MK.price'] = $res[$element['id']]['MK.price'] * $child['multiplicator'];
$res[$child['product_id']]['MK.to_export'] = 1;
}
}
}
//MK_price_currency
if ($element['MK_price_currency']['new'] != $element['MK_price_currency']['old']) {
$res[$element['id']]['MK.currency'] = $element['MK_price_currency']['new'];
if ($childs) {
foreach ($childs as $child) {
$res[$child['product_id']]['MK.currency'] = $res[$element['id']]['MK.currency'];
$res[$child['product_id']]['MK.to_export'] = 1;
}
}
}
//MK update
if (isset($res[$element['id']]['products.in_stock']) or isset($res[$element['id']]['MK.enabled']) or isset($res[$element['id']]['MK.yandex_enabled']) or isset($res[$element['id']]['MK.price']) or isset($res[$element['id']]['MK.currency'])) {
$res[$element['id']]['MK.to_export'] = 1;
$res[$element['id']]['MK.updated_at'] = date('Y-m-d H:i:s');
$res[$element['id']]['MK.user_id'] = Auth::User()->id;
$res[$element['id']]['products.updated_at'] = date('Y-m-d H:i:s');
$res[$element['id']]['products.user_id'] = Auth::User()->id;
}
}
//product update
if (isset($res[$element['id']]['products.status']) or isset($res[$element['id']]['products.name']) or isset($res[$element['id']]['products.article']) or isset($res[$element['id']]['products.in_stock']) or isset($res[$element['id']]['products.mrc']) or isset($res[$element['id']]['products.mrc_currency']) or isset($res[$element['id']]['products.mrc_relation']) or isset($res[$element['id']]['products.mrc_raise_relation']) or isset($res[$element['id']]['products.price']) or isset($res[$element['id']]['products.price_currency']) or isset($res[$element['id']]['products.price_relation']) or isset($res[$element['id']]['products.price_raise_relation']) or isset($res[$element['id']]['products.target_margin']) or isset($res[$element['id']]['products.common_price'])) {
$res[$element['id']]['products.updated_at'] = date('Y-m-d H:i:s');
$res[$element['id']]['products.user_id'] = Auth::User()->id;
}
}
}
if (count($res) > 0) {
$productModel->updatingListProducts($res);
$historyModel->saveHistory('update_products', $res);
if ($reViewAbsents) {
$absentModel = new Absent();
$absents = $productModel->getAbsentsList();
$absentModel->addAbsentsList($absents);
}
Session::flash('message', GetMessages("SUCCESS_DATA_PRODUCTS_UPDATE"));
return redirect($_SERVER['HTTP_REFERER']);
} else {
Session::flash('message', GetMessages("ERROR_NO_DATA_FOR_UPDATE"));
return redirect($_SERVER['HTTP_REFERER']);
}
}
if (isset($_POST['update_product'])) {
if (!right('EditProduct')) {
abort(404);
}
//pr($_POST);
$res = array();
//status
!isset($_POST['status']['new']) ? $_POST['status']['new'] = 0 : ($_POST['status']['new'] = 1);
if ($_POST['status']['new'] != $_POST['status']['old']) {
$res[$_POST['id']]['products.status'] = $_POST['status']['new'];
}
//name
if ($_POST['name']['new'] != $_POST['name']['old']) {
$res[$_POST['id']]['products.name'] = trim($_POST['name']['new']);
}
//article
if ($_POST['article']['new'] != $_POST['article']['old']) {
$res[$_POST['id']]['products.article'] = trim($_POST['article']['new']);
}
//ean
if ($_POST['ean']['new'] != $_POST['ean']['old']) {
$res[$_POST['id']]['products.ean'] = trim($_POST['ean']['new']);
}
//in_stock
!isset($_POST['in_stock']['new']) ? $_POST['in_stock']['new'] = 0 : ($_POST['in_stock']['new'] = 1);
if ($_POST['in_stock']['new'] != $_POST['in_stock']['old']) {
$res[$_POST['id']]['products.in_stock'] = $_POST['in_stock']['new'];
}
//mrc
isset($_POST['mrc']['new']) ? $_POST['mrc']['new'] = toFloat($_POST['mrc']['new']) : ($_POST['mrc']['new'] = 0);
if ($_POST['mrc']['new'] != $_POST['mrc']['old']) {
$res[$_POST['id']]['products.mrc'] = toFloat($_POST['mrc']['new']);
}
//price
isset($_POST['price']['new']) ? $_POST['price']['new'] = toFloat($_POST['price']['new']) : ($_POST['price']['new'] = 0);
if ($_POST['price']['new'] != $_POST['price']['old']) {
$res[$_POST['id']]['products.price'] = toFloat($_POST['price']['new']);
}
//target_margin
if ($_POST['target_margin']['new'] != $_POST['target_margin']['old']) {
$res[$_POST['id']]['products.target_margin'] = toFloat($_POST['target_margin']['new']);
}
//category_id
if ($_POST['category_id']['new'] != $_POST['category_id']['old']) {
$res[$_POST['id']]['products.category_id'] = intval($_POST['category_id']['new']);
}
//brand_id
if ($_POST['brand_id']['new'] != $_POST['brand_id']['old']) {
$res[$_POST['id']]['products.brand_id'] = intval($_POST['brand_id']['new']);
}
//childs
if (isset($_POST['childs']) and !empty($_POST['childs'])) {
foreach ($_POST['childs'] as $key => $child) {
if (empty($child['product_id']) or empty($child['multiplicator'])) {
unset($_POST['childs'][$key]);
}
}
if (!empty($_POST['childs'])) {
$res[$_POST['id']]['products.childs'] = serialize($_POST['childs']);
} else {
$res[$_POST['id']]['products.childs'] = null;
}
}
if (isset($_POST['GK_enabled']['old'])) {
//GK_id
isset($_POST['GK_id']['new']) ? $_POST['GK_id']['new'] = intval($_POST['GK_id']['new']) : ($_POST['GK_id']['new'] = 0);
if ($_POST['GK_id']['new'] != $_POST['GK_id']['old']) {
if ($_POST['GK_id']['new'] !== 0 and $_POST['GK_id']['new'] !== 1) {
if (count($productModel->checkSiteId('GK', $_POST['GK_id']['new'])) > 0) {
Session::flash('message', GetMessages("ERROR_SITE_ID_EXISTS"));
return redirect($_SERVER['HTTP_REFERER']);
}
}
$res[$_POST['id']]['GK.site_id'] = $_POST['GK_id']['new'];
}
//GK_enabled
!isset($_POST['GK_enabled']['new']) ? $_POST['GK_enabled']['new'] = 0 : ($_POST['GK_enabled']['new'] = 1);
if ($_POST['GK_enabled']['new'] != $_POST['GK_enabled']['old']) {
$res[$_POST['id']]['GK.enabled'] = $_POST['GK_enabled']['new'];
}
//GK_yandex_enabled
!isset($_POST['GK_yandex_enabled']['new']) ? $_POST['GK_yandex_enabled']['new'] = 0 : ($_POST['GK_yandex_enabled']['new'] = 1);
if ($_POST['GK_yandex_enabled']['new'] != $_POST['GK_yandex_enabled']['old']) {
$res[$_POST['id']]['GK.yandex_enabled'] = $_POST['GK_yandex_enabled']['new'];
}
//GK_price
isset($_POST['GK_price']['new']) ? $_POST['GK_price']['new'] = toFloat($_POST['GK_price']['new']) : ($_POST['GK_price']['new'] = 0);
if ($_POST['GK_price']['new'] != $_POST['GK_price']['old']) {
$res[$_POST['id']]['GK.price'] = $_POST['GK_price']['new'];
}
//GK_price_currency
if ($_POST['GK_price_currency']['new'] != $_POST['GK_price_currency']['old']) {
$res[$_POST['id']]['GK.currency'] = $_POST['GK_price_currency']['new'];
}
//GK update
if (isset($res[$_POST['id']]['products.in_stock']) or isset($res[$_POST['id']]['GK.enabled']) or isset($res[$_POST['id']]['GK.yandex_enabled']) or isset($res[$_POST['id']]['GK.price']) or isset($res[$_POST['id']]['GK.currency'])) {
$res[$_POST['id']]['GK.to_export'] = 1;
$res[$_POST['id']]['GK.updated_at'] = date('Y-m-d H:i:s');
$res[$_POST['id']]['GK.user_id'] = Auth::User()->id;
}
}
if (isset($_POST['TV_enabled']['old'])) {
//TV_id
isset($_POST['TV_id']['new']) ? $_POST['TV_id']['new'] = intval($_POST['TV_id']['new']) : ($_POST['TV_id']['new'] = 0);
if ($_POST['TV_id']['new'] != $_POST['TV_id']['old']) {
if ($_POST['TV_id']['new'] !== 0 and $_POST['TV_id']['new'] !== 1) {
if (count($productModel->checkSiteId('TV', $_POST['TV_id']['new'])) > 0) {
Session::flash('message', GetMessages("ERROR_SITE_ID_EXISTS"));
return redirect($_SERVER['HTTP_REFERER']);
}
}
$res[$_POST['id']]['TV.site_id'] = $_POST['TV_id']['new'];
}
//TV_enabled
!isset($_POST['TV_enabled']['new']) ? $_POST['TV_enabled']['new'] = 0 : ($_POST['TV_enabled']['new'] = 1);
if ($_POST['TV_enabled']['new'] != $_POST['TV_enabled']['old']) {
$res[$_POST['id']]['TV.enabled'] = $_POST['TV_enabled']['new'];
}
//TV_yandex_enabled
!isset($_POST['TV_yandex_enabled']['new']) ? $_POST['TV_yandex_enabled']['new'] = 0 : ($_POST['TV_yandex_enabled']['new'] = 1);
if ($_POST['TV_yandex_enabled']['new'] != $_POST['TV_yandex_enabled']['old']) {
$res[$_POST['id']]['TV.yandex_enabled'] = $_POST['TV_yandex_enabled']['new'];
}
//TV_price
isset($_POST['TV_price']['new']) ? $_POST['TV_price']['new'] = toFloat($_POST['TV_price']['new']) : ($_POST['TV_price']['new'] = 0);
if ($_POST['TV_price']['new'] != $_POST['TV_price']['old']) {
$res[$_POST['id']]['TV.price'] = $_POST['TV_price']['new'];
}
//TV_price_currency
if ($_POST['TV_price_currency']['new'] != $_POST['TV_price_currency']['old']) {
$res[$_POST['id']]['TV.currency'] = $_POST['TV_price_currency']['new'];
}
//TV update
if (isset($res[$_POST['id']]['products.in_stock']) or isset($res[$_POST['id']]['TV.enabled']) or isset($res[$_POST['id']]['TV.yandex_enabled']) or isset($res[$_POST['id']]['TV.price']) or isset($res[$_POST['id']]['TV.currency'])) {
$res[$_POST['id']]['TV.to_export'] = 1;
$res[$_POST['id']]['TV.updated_at'] = date('Y-m-d H:i:s');
$res[$_POST['id']]['TV.user_id'] = Auth::User()->id;
}
}
if (isset($_POST['MK_enabled']['old'])) {
//MK_id
isset($_POST['MK_id']['new']) ? $_POST['MK_id']['new'] = intval($_POST['MK_id']['new']) : ($_POST['MK_id']['new'] = 0);
if ($_POST['MK_id']['new'] != $_POST['MK_id']['old']) {
if ($_POST['MK_id']['new'] !== 0 and $_POST['MK_id']['new'] !== 1) {
if (count($productModel->checkSiteId('MK', $_POST['MK_id']['new'])) > 0) {
Session::flash('message', GetMessages("ERROR_SITE_ID_EXISTS"));
return redirect($_SERVER['HTTP_REFERER']);
}
}
$res[$_POST['id']]['MK.site_id'] = $_POST['MK_id']['new'];
}
//MK_enabled
!isset($_POST['MK_enabled']['new']) ? $_POST['MK_enabled']['new'] = 0 : ($_POST['MK_enabled']['new'] = 1);
if ($_POST['MK_enabled']['new'] != $_POST['MK_enabled']['old']) {
$res[$_POST['id']]['MK.enabled'] = $_POST['MK_enabled']['new'];
}
//MK_yandex_enabled
!isset($_POST['MK_yandex_enabled']['new']) ? $_POST['MK_yandex_enabled']['new'] = 0 : ($_POST['MK_yandex_enabled']['new'] = 1);
if ($_POST['MK_yandex_enabled']['new'] != $_POST['MK_yandex_enabled']['old']) {
$res[$_POST['id']]['MK.yandex_enabled'] = $_POST['MK_yandex_enabled']['new'];
}
//MK_price
isset($_POST['MK_price']['new']) ? $_POST['MK_price']['new'] = toFloat($_POST['MK_price']['new']) : ($_POST['MK_price']['new'] = 0);
if ($_POST['MK_price']['new'] != $_POST['MK_price']['old']) {
$res[$_POST['id']]['MK.price'] = $_POST['MK_price']['new'];
}
//MK_price_currency
if ($_POST['MK_price_currency']['new'] != $_POST['MK_price_currency']['old']) {
$res[$_POST['id']]['MK.currency'] = $_POST['MK_price_currency']['new'];
}
//MK update
if (isset($res[$_POST['id']]['products.in_stock']) or isset($res[$_POST['id']]['MK.enabled']) or isset($res[$_POST['id']]['MK.yandex_enabled']) or isset($res[$_POST['id']]['MK.price']) or isset($res[$_POST['id']]['MK.currency'])) {
$res[$_POST['id']]['MK.to_export'] = 1;
$res[$_POST['id']]['MK.updated_at'] = date('Y-m-d H:i:s');
$res[$_POST['id']]['MK.user_id'] = Auth::User()->id;
}
}
//product update
if (isset($res[$_POST['id']]['products.status']) or isset($res[$_POST['id']]['products.name']) or isset($res[$_POST['id']]['products.article']) or isset($res[$_POST['id']]['products.ean']) or isset($res[$_POST['id']]['products.in_stock']) or isset($res[$_POST['id']]['products.mrc']) or isset($res[$_POST['id']]['products.price']) or isset($res[$_POST['id']]['products.target_margin']) or isset($res[$_POST['id']]['products.category_id']) or isset($res[$_POST['id']]['products.brand_id'])) {
$res[$_POST['id']]['products.updated_at'] = date('Y-m-d H:i:s');
$res[$_POST['id']]['products.user_id'] = Auth::User()->id;
}
if (count($res) > 0 or isset($arLabels)) {
$productModel->updatingListProducts($res);
$historyModel->saveHistory('update_products', $res);
Session::flash('message', GetMessages("SUCCESS_DATA_PRODUCTS_UPDATE"));
return redirect($_SERVER['HTTP_REFERER']);
} else {
Session::flash('message', GetMessages("ERROR_NO_DATA_FOR_UPDATE"));
return redirect($_SERVER['HTTP_REFERER']);
}
}
if (isset($_POST['update_labels'])) {
$label = trim($_POST['labels']['new']);
if ($label != $_POST['labels']['old']) {
$labelModel->joinLabels($_POST['product_id'], explode(',', $_POST['labels']['new']));
Session::flash('message', GetMessages("SUCCESS_DATA_PRODUCTS_UPDATE"));
return redirect($_SERVER['HTTP_REFERER']);
} else {
Session::flash('message', GetMessages("ERROR_NO_DATA_FOR_UPDATE"));
return redirect($_SERVER['HTTP_REFERER']);
}
}
if (isset($_POST['add_to_site'])) {
if (!right('EditProduct')) {
abort(404);
}
//pr($_POST);
if (isset($_POST['GK'])) {
if (!isset($_POST['GK']['product_id']) or strlen($_POST['GK']['product_id']) < 1) {
Session::flash('message', GetMessages("ERROR"));
return redirect($_SERVER['HTTP_REFERER']);
}
if (!empty($_POST['GK']['site_id']) and count($productModel->checkSiteId('GK', $_POST['GK']['site_id'])) > 0) {
Session::flash('message', GetMessages("ERROR_SITE_ID_EXISTS"));
return redirect($_SERVER['HTTP_REFERER']);
}
$res = array();
$res['product_id'] = $_POST['GK']['product_id'];
!empty($_POST['GK']['site_id']) ? $res['site_id'] = intval($_POST['GK']['site_id']) : ($res['site_id'] = 1);
isset($_POST['GK']['enabled']) ? $res['enabled'] = 1 : ($res['enabled'] = 0);
isset($_POST['GK']['yandex_enabled']) ? $res['yandex_enabled'] = 1 : ($res['yandex_enabled'] = 0);
!empty($_POST['GK']['currency']) ? $res['currency'] = $_POST['GK']['currency'] : ($res['currency'] = 'RUB');
!empty($_POST['GK']['price']) ? $res['price'] = toFloat($_POST['GK']['price']) : ($res['price'] = 0);
$res['created_at'] = date('Y-m-d H:i:s');
$res['updated_at'] = date('Y-m-d H:i:s');
$res['user_id'] = Auth::User()->id;
$productModel->addToSite($res, 'GK');
$historyModel->saveHistory('add_to_site', $res['product_id'], 'ГарантКомфорт');
Session::flash('message', GetMessages("SUCCESS_PRODUCT_ADD_TO_SITE"));
return redirect($_SERVER['HTTP_REFERER']);
}
if (isset($_POST['TV'])) {
if (!isset($_POST['TV']['product_id']) or strlen($_POST['TV']['product_id']) < 1) {
Session::flash('message', GetMessages("ERROR"));
return redirect($_SERVER['HTTP_REFERER']);
}
if (!empty($_POST['TV']['site_id']) and count($productModel->checkSiteId('TV', $_POST['TV']['site_id'])) > 0) {
Session::flash('message', GetMessages("ERROR_SITE_ID_EXISTS"));
return redirect($_SERVER['HTTP_REFERER']);
}
$res = array();
$res['product_id'] = $_POST['TV']['product_id'];
!empty($_POST['TV']['site_id']) ? $res['site_id'] = intval($_POST['TV']['site_id']) : ($res['site_id'] = 1);
isset($_POST['TV']['enabled']) ? $res['enabled'] = 1 : ($res['enabled'] = 0);
isset($_POST['TV']['yandex_enabled']) ? $res['yandex_enabled'] = 1 : ($res['yandex_enabled'] = 0);
!empty($_POST['TV']['currency']) ? $res['currency'] = $_POST['TV']['currency'] : ($res['currency'] = 'RUB');
!empty($_POST['TV']['price']) ? $res['price'] = toFloat($_POST['TV']['price']) : ($res['price'] = 0);
$res['created_at'] = date('Y-m-d H:i:s');
$res['updated_at'] = date('Y-m-d H:i:s');
$res['user_id'] = Auth::User()->id;
$productModel->addToSite($res, 'TV');
$historyModel->saveHistory('add_to_site', $res['product_id'], 'Таваго');
Session::flash('message', GetMessages("SUCCESS_PRODUCT_ADD_TO_SITE"));
return redirect($_SERVER['HTTP_REFERER']);
}
if (isset($_POST['MK'])) {
if (!isset($_POST['MK']['product_id']) or strlen($_POST['MK']['product_id']) < 1) {
Session::flash('message', GetMessages("ERROR"));
return redirect($_SERVER['HTTP_REFERER']);
}
if (!empty($_POST['MK']['site_id']) and count($productModel->checkSiteId('MK', $_POST['MK']['site_id'])) > 0) {
Session::flash('message', GetMessages("ERROR_SITE_ID_EXISTS"));
return redirect($_SERVER['HTTP_REFERER']);
}
$res = array();
$res['product_id'] = $_POST['MK']['product_id'];
!empty($_POST['MK']['site_id']) ? $res['site_id'] = intval($_POST['MK']['site_id']) : ($res['site_id'] = 1);
isset($_POST['MK']['enabled']) ? $res['enabled'] = 1 : ($res['enabled'] = 0);
isset($_POST['MK']['yandex_enabled']) ? $res['yandex_enabled'] = 1 : ($res['yandex_enabled'] = 0);
!empty($_POST['MK']['currency']) ? $res['currency'] = $_POST['MK']['currency'] : ($res['currency'] = 'RUB');
!empty($_POST['MK']['price']) ? $res['price'] = toFloat($_POST['MK']['price']) : ($res['price'] = 0);
$res['created_at'] = date('Y-m-d H:i:s');
$res['updated_at'] = date('Y-m-d H:i:s');
$res['user_id'] = Auth::User()->id;
$productModel->addToSite($res, 'MK');
$historyModel->saveHistory('add_to_site', $res['product_id'], 'МаксКлимат');
Session::flash('message', GetMessages("SUCCESS_PRODUCT_ADD_TO_SITE"));
return redirect($_SERVER['HTTP_REFERER']);
}
}
if (isset($_POST['add_purchase'])) {
if (!right('EditProduct')) {
abort(404);
}
//pr($_POST);
$res = array();
$res['vendor_id'] = $_POST['provider'];
$res['product_id'] = $_POST['product_id'];
$res['currency'] = $_POST['currency'];
!empty($_POST['base_price']) ? $res['base_price'] = toFloat($_POST['base_price']) : ($res['base_price'] = 0);
!empty($_POST['discount_price']) ? $res['discount_price'] = toFloat($_POST['discount_price']) : ($res['discount_price'] = 0);
!empty($_POST['raise']) ? $res['raise'] = toFloat($_POST['raise']) : ($res['raise'] = 0);
!empty($_POST['discount_bulk']) ? $res['discount_bulk'] = toFloat($_POST['discount_bulk']) : ($res['discount_bulk'] = 0);
$res['created_at'] = date('Y-m-d H:i:s');
$res['updated_at'] = date('Y-m-d H:i:s');
$res['user_id'] = Auth::User()->id;
$purchaseModel->addPurchase($res);
$historyModel->saveHistory('add_purchase', $res['product_id']);
Session::flash('message', GetMessages("SUCCESS_ADD_PURCHASE"));
return redirect($_SERVER['HTTP_REFERER']);
}
if (isset($_POST['update_purchase'])) {
if (!right('EditProduct')) {
abort(404);
}
unset($_POST['_token']);
unset($_POST['update_purchase']);
//pr($_POST);
$res = array();
foreach ($_POST as $element) {
//base_price
if (isset($element['base_price'])) {
if ($element['base_price']['new'] != $element['base_price']['old']) {
$res[$element['purchase_id']]['base_price'] = $element['base_price']['new'];
}
} else {
$res[$element['purchase_id']]['base_price'] = 0;
}
//currency
if (isset($element['currency'])) {
if ($element['currency']['new'] != $element['currency']['old']) {
$res[$element['purchase_id']]['currency'] = $element['currency']['new'];
}
} else {
$res[$element['purchase_id']]['currency'] = 'RUB';
}
//raise
if (isset($element['raise'])) {
if ($element['raise']['new'] != $element['raise']['old']) {
$res[$element['purchase_id']]['raise'] = $element['raise']['new'];
}
} else {
$res[$element['purchase_id']]['raise'] = 1;
}
//discount_price
if (isset($element['discount_price'])) {
if ($element['discount_price']['new'] != $element['discount_price']['old']) {
$res[$element['purchase_id']]['discount_price'] = $element['discount_price']['new'];
}
} else {
$res[$element['purchase_id']]['discount_price'] = 0;
}
//discount_bulk
if (isset($element['discount_bulk'])) {
if ($element['discount_bulk']['new'] != $element['discount_bulk']['old']) {
$res[$element['purchase_id']]['discount_bulk'] = $element['discount_bulk']['new'];
}
} else {
$res[$element['purchase_id']]['discount_bulk'] = 0;
}
if (isset($res[$element['purchase_id']]['base_price']) or isset($res[$element['purchase_id']]['currency']) or isset($res[$element['purchase_id']]['raise']) or isset($res[$element['purchase_id']]['discount_price']) or isset($res[$element['purchase_id']]['discount_bulk'])) {
$res[$element['purchase_id']]['product_id'] = $element['product_id'];
$res[$element['purchase_id']]['purchase.updated_at'] = date('Y-m-d H:i:s');
$res[$element['purchase_id']]['purchase.user_id'] = Auth::User()->id;
}
}
//pr($res);
if (count($res) > 0) {
$purchaseModel->updatePurchase($res);
$historyModel->saveHistory('update_purchase', $res);
Session::flash('message', GetMessages("SUCCESS_DATA_PRODUCTS_UPDATE"));
return redirect($_SERVER['HTTP_REFERER']);
} else {
Session::flash('message', GetMessages("ERROR_NO_DATA_FOR_UPDATE"));
return redirect($_SERVER['HTTP_REFERER']);
}
}
if (isset($_POST['create_product'])) {
if (!right('EditProduct')) {
abort(404);
}
unset($_POST['_token']);
unset($_POST['create_product']);
//pr($_POST);
if (strlen($request->input('name')) > 0) {
$res = array();
$res['name'] = $request->input('name');
$res['article'] = $request->input('article');
$res['ean'] = $request->input('ean');
$res['status'] = isset($_POST['status']) ? 1 : 0;
$res['category_id'] = $request->input('category_id');
$res['brand_id'] = $request->input('brand_id');
$res['mrc'] = empty($_POST['mrc']) ? 0 : $_POST['mrc'];
$res['mrc_currency'] = empty($_POST['mrc_currency']) ? 'RUB' : $_POST['mrc_currency'];
$res['price'] = empty($_POST['price']) ? 0 : $_POST['price'];
$res['price_currency'] = empty($_POST['price_currency']) ? 'RUB' : $_POST['price_currency'];
$res['target_margin'] = $request->input('target_margin');
$res['in_stock'] = isset($_POST['in_stock']) ? 1 : 0;
$res['user_id'] = Auth::User()->id;
$res['created_at'] = date('Y-m-d H:i:s');
$res['updated_at'] = date('Y-m-d H:i:s');
$id = $productModel->createProduct($res);
$historyModel->saveHistory('create_product', $id);
Session::flash('message', GetMessages("SUCCESS_CREATE_NEW_PRODUCT"));
return redirect()->route('product.show', ['id' => $id]);
} else {
Session::flash('message', GetMessages("ERROR_EMPTY_NAME_PRODUCT"));
return redirect($_SERVER['HTTP_REFERER']);
}
}
if (isset($_POST['ajax'])) {
if (!right('EditProduct')) {
abort(404);
}
return $productModel->checkSiteId($_POST['site'], $_POST['id']);
}
if (isset($_POST['cp_page_sbmt'])) {
$userModel->where('id', Auth::User()->id)->update(array('count_products' => $_POST['cp_page_val']));
Session::flash('message', GetMessages("SUCCESS_UPDATE"));
return redirect($_SERVER['HTTP_REFERER']);
}
}
function displayMachineriesList($machineriesList)
{
$totAcqCst = 0;
$totOthers = 0;
$totMrktVal = 0;
$totalMarketValue = 0;
$totalAssessmentValue = 0;
if (count($machineriesList)) {
$i = 0;
foreach ($machineriesList as $key => $machineries) {
if ($i == 0) {
// $this->formArray["arpNumber"] = $machineries->getArpNumber();
// $this->formArray["propertyIndexNumber"] = $machineries->getPropertyIndexNumber();
$this->formArray["taxability"] = $machineries->getTaxability();
$this->formArray["effectivity"] = $machineries->getEffectivity();
$this->formArray["buildingPIN"] = $machineries->getBuildingPin();
$this->formArray["landPIN"] = $machineries->getLandPin();
$this->formArray["memoranda"] = $machineries->getMemoranda();
if (is_a($machineries->propertyAdministrator, Person)) {
$this->formArray["userAdmin"] = $machineries->propertyAdministrator->getFullName();
if (is_a($machineries->propertyAdministrator->addressArray[0], "address")) {
$address1 = $machineries->propertyAdministrator->addressArray[0]->getNumber();
$address1 .= " " . $machineries->propertyAdministrator->addressArray[0]->getStreet();
$address1 .= ", " . $machineries->propertyAdministrator->addressArray[0]->getBarangay();
$address2 = $machineries->propertyAdministrator->addressArray[0]->getDistrict();
$address2 .= ", " . $machineries->propertyAdministrator->addressArray[0]->getMunicipalityCity();
$address2 .= ", " . $machineries->propertyAdministrator->addressArray[0]->getProvince();
$this->formArray["userAdminAddress"] = $address1 . " " . $address2;
}
$this->formArray["userAdminTelNo"] = $machineries->propertyAdministrator->getTelephone();
}
// recommendingApproval
if (is_numeric($machineries->recommendingApproval)) {
$recommendingApproval = new Person();
$recommendingApproval->selectRecord($machineries->recommendingApproval);
$this->formArray["cityAssessor"] = $recommendingApproval->getFullName();
$this->recommendingApproval = $recommendingApproval->getFullName();
} else {
$recommendingApproval = $machineries->recommendingApproval;
$this->formArray["cityAssessor"] = $recommendingApproval;
$this->recommendingApproval = $recommendingApproval;
}
$this->formArray["dateCityAssessor"] = $machineries->getRecommendingApprovalDate();
// approvedBy
if (is_numeric($machineries->approvedBy)) {
$approvedBy = new Person();
$approvedBy->selectRecord($machineries->approvedBy);
$this->formArray["provincialAssessor"] = $approvedBy->getFullName();
$this->approvedBy = $approvedBy->getFullName();
} else {
$approvedBy = $land->approvedBy;
$this->formArray["provincialAssessor"] = $approvedBy;
$this->approvedBy = $approvedBy;
}
$this->formArray["dateProvAssessor"] = $machineries->getApprovedByDate();
// appraisedBy (assessedBy)
if (is_numeric($machineries->appraisedBy)) {
$appraisedBy = new Person();
$appraisedBy->selectRecord($machineries->appraisedBy);
$this->formArray["assessedBy"] = $appraisedBy->getFullName();
$this->appraisedBy = $appraisedBy->getFullName();
} else {
$appraisedBy = $machineries->appraisedBy;
$this->formArray["assessedBy"] = $appraisedBy;
$this->appraisedBy = $appraisedBy;
}
$this->formArray["dateAssessedBy"] = $machineries->getAppraisedByDate();
}
if ($i < 9) {
$this->formArray["tbl1Desc" . ($i + 1)] = $machineries->machineryDescription;
$this->formArray["tbl2Desc" . ($i + 1)] = $machineries->machineryDescription;
$this->formArray["brandNo" . ($i + 1)] = $machineries->brand . " " . $machineries->modelNumber;
$this->formArray["capacity" . ($i + 1)] = $machineries->capacity;
$this->formArray["dateAcquired" . ($i + 1)] = $machineries->dateAcquired;
$this->formArray["condAcq" . ($i + 1)] = $machineries->conditionWhenAcquired;
$this->formArray["lifeEst" . ($i + 1)] = $machineries->estimatedEconomicLife;
$this->formArray["lifeRem" . ($i + 1)] = $machineries->remainingEconomicLife;
$this->formArray["dateInst" . ($i + 1)] = $machineries->dateOfInstallation;
$this->formArray["dateOper" . ($i + 1)] = $machineries->dateOfOperation;
$this->formArray["remarks" . ($i + 1)] = $machineries->remarks;
$this->formArray["units" . ($i + 1)] = $machineries->numberOfUnits;
$this->formArray["acqCost" . ($i + 1)] = $machineries->acquisitionCost;
$this->formArray["freight" . ($i + 1)] = $machineries->freightCost;
$this->formArray["insurnc" . ($i + 1)] = $machineries->insuranceCost;
$this->formArray["instaln" . ($i + 1)] = $machineries->installationCost;
$this->formArray["others" . ($i + 1)] = $machineries->othersCost;
$this->formArray["mrktVal" . ($i + 1)] = $machineries->marketValue;
$this->formArray["depr" . ($i + 1)] = $machineries->depreciation;
$this->formArray["depMVal" . ($i + 1)] = $machineries->depreciatedMarketValue;
$totAcqCst = $totAcqCst + toFloat($machineries->acquisitionCost);
$totOthers = $totOthers + toFloat($machineries->othersCost);
$totMrktVal = $totMrktVal + toFloat($machineries->marketValue);
$totalMarketValue = $totMrktVal;
$totalAssessmentValue = $totalAssessmentValue + toFloat($machineries->assessedValue);
}
$i++;
}
}
$this->formArray["totAcqCst"] = $totAcqCst;
$this->formArray["totOthers"] = $totOthers;
$this->formArray["totMrktVal"] = $totMrktVal;
$this->formArray["totalMarketValue"] = $totalMarketValue;
$this->formArray["totalAssessmentValue"] = $totalAssessmentValue;
}
function displayMachineriesList($machineriesList)
{
if (count($machineriesList)) {
foreach ($machineriesList as $mkey => $machineries) {
// "kind" is assumed to be treated as "classes" for machineries
$machineriesClasses = new MachineriesClasses();
if (is_numeric($machineries->getKind())) {
$machineriesClasses->selectRecord($machineries->getKind());
$machineriesClassesDescription = $machineriesClasses->getDescription();
$machineriesClassesCode = $machineriesClasses->getCode();
} else {
$machineriesClassesDescription = $machineries->getKind();
$machineriesClassesCode = $machineries->getActualUse();
}
// "classification" is assumed to be treated as "actualUse" for machineries
$machineriesActualUses = new MachineriesActualUses();
if (is_numeric($machineries->getActualUse())) {
$machineriesActualUses->selectRecord($machineries->getActualUse());
$machineriesActualUsesDescription = $machineriesActualUses->getDescription();
$machineriesActualUsesCode = $machineriesActualUses->getCode();
} else {
$machineriesActualUsesDescription = $machineries->getActualUse();
$machineriesActualUsesCode = $machineries->getActualUse();
}
// NCC Modification checked and implemented by K2 : November 21, 2005
// details:
// - changed `if($this->formArray["p"] <= 3)` to `if(...<=10)` in line xx
// - added lines 547 to 561
// - added line 585
if ($this->formArray["p"] <= 10) {
$p = $this->formArray["p"];
$this->formArray["ypos"] -= 12;
$offset = $this->formArray["ypos"];
$items .= "<textitem xpos=\"40\" ypos=\"" . $offset . "\" font=\"Helvetica\" size=\"10\" align=\"left\">" . $machineriesClassesDescription . "</textitem>";
$items .= "<textitem xpos=\"146\" ypos=\"" . $offset . "\" font=\"Helvetica\" size=\"9\" align=\"left\">" . $machineriesActualUsesDescription . "</textitem>";
$items .= "<textitem xpos=\"337\" ypos=\"" . $offset . "\" font=\"Helvetica\" size=\"10\" align=\"right\">" . number_format($machineries->getMarketValue(), 2) . "</textitem>";
$items .= "<textitem xpos=\"430\" ypos=\"" . $offset . "\" font=\"Helvetica\" size=\"10\" align=\"right\">" . number_format($machineries->getAssessmentLevel(), 2) . "</textitem>";
$items .= "<textitem xpos=\"558\" ypos=\"" . $offset . "\" font=\"Helvetica\" size=\"10\" align=\"right\">" . $machineries->getAssessedValue() . "</textitem>";
$offsetx = $offset - 3;
$items .= "<lineitem x1=\"40\" y1=\"" . $offsetx . "\" x2=\"120\" y2=\"" . $offsetx . "\">blurb</lineitem>";
$items .= "<lineitem x1=\"147\" y1=\"" . $offsetx . "\" x2=\"220\" y2=\"" . $offsetx . "\">blurb</lineitem>";
$items .= "<lineitem x1=\"244\" y1=\"" . $offsetx . "\" x2=\"337\" y2=\"" . $offsetx . "\">blurb</lineitem>";
$items .= "<lineitem x1=\"358\" y1=\"" . $offsetx . "\" x2=\"445\" y2=\"" . $offsetx . "\">blurb</lineitem>";
$items .= "<lineitem x1=\"457\" y1=\"" . $offsetx . "\" x2=\"558\" y2=\"" . $offsetx . "\">blurb</lineitem>";
$this->formArray["kind" . $p] = $machineriesClassesDescription;
$this->formArray["classification" . $p] = $machineriesActualUsesDescription;
$this->formArray["marketValue" . $p] = un_number_format($machineries->getMarketValue());
$this->formArray["assessmentLevel" . $p] = un_number_format($machineries->getAssessmentLevel());
$this->formArray["assessedValue" . $p] = un_number_format($machineries->getAssessedValue());
} else {
if ($this->formArray["p"] > 3) {
if ($this->formArray["kindOthers"] != "") {
$this->formArray["kindOthers"] .= "; ";
}
if ($this->formArray["kindOthers"] == "") {
$this->formArray["kindOthers"] = "Others: ";
}
$this->formArray["kindOthers"] .= $machineriesClassesDescription;
$this->formArray["kindOthers"] .= " MV=P" . formatCurrency($machineries->getMarketValue());
$this->formArray["kindOthers"] .= " AV=P" . formatCurrency($machineries->getAssessedValue());
}
}
$this->formArray["totalMarketValue"] += toFloat($machineries->getMarketValue());
$this->formArray["totalAssessedValue"] += toFloat($machineries->getAssessedValue());
$this->formArray["p"]++;
}
$this->formArray["landitems"] = $items;
}
}
function displayAssessedValues($landList, $plantsTreesList, $improvementsBuildingsList, $machineriesList)
{
$totalMarketValue = 0;
$totalAssessedValue = 0;
$i = 0;
if (count($landList)) {
foreach ($landList as $key => $land) {
if ($i < 4) {
// classification
$landClasses = new LandClasses();
if (is_numeric($land->getClassification())) {
$landClasses->selectRecord($land->getClassification());
$landClassesDescription = $landClasses->getDescription();
$landClassesCode = $landClasses->getCode();
} else {
$landClassesDescription = $land->getClassification();
$landClassesCode = $land->getClassification();
}
// subClass
$landSubclasses = new LandSubclasses();
if (is_numeric($land->getSubClass())) {
$landSubclasses->selectRecord($land->getSubClass());
$landSubclassesDescription = $landSubclasses->getDescription();
$landSubclassesCode = $landSubclasses->getCode();
} else {
$landSubclassesDescription = $land->getSubClass();
$landSubclassesCode = $land->getSubClass();
}
// actualUse
$landActualUses = new LandActualUses();
if (is_numeric($land->getActualUse())) {
$landActualUses->selectRecord($land->getActualUse());
$landActualUsesDescription = $landActualUses->getDescription();
$landActualUsesCode = $landActualUses->getCode();
} else {
$landActualUsesDescription = $land->getActualUse();
$landActualUsesCode = $land->getActualUse();
}
$this->formArray["propertyKind" . ($i + 1)] = "Land";
$this->formArray["propertyActualUse" . ($i + 1)] = $landActualUsesDescription;
$this->formArray["propertyMarketValue" . ($i + 1)] = $land->getMarketValue();
$this->formArray["propertyAssessmentLevel" . ($i + 1)] = $land->getAssessmentLevel();
$this->formArray["propertyAssessedValue" . ($i + 1)] = $land->getAssessedValue();
$totalMarketValue += toFloat($land->getMarketValue());
$totalAssessedValue += toFloat($land->getAssessedValue());
$i++;
}
}
}
if (count($plantsTreesList)) {
foreach ($plantsTreesList as $key => $plantsTrees) {
if ($i < 4) {
// productClass
$plantsTreesClasses = new PlantsTreesClasses();
if (is_numeric($plantsTrees->getProductClass())) {
$plantsTreesClasses->selectRecord($plantsTrees->getProductClass());
$plantsTreesClassesDescription = $plantsTreesClasses->getDescription();
$plantsTreesClassesCode = $plantsTreesClasses->getCode();
} else {
$plantsTreesClassesDescription = $plantsTrees->getProductClass();
$plantsTreesClassesCode = $plantsTrees->getProductClass();
}
// actualUse
$plantsTreesActualUses = new PlantsTreesActualUses();
if (is_numeric($plantsTrees->getActualUse())) {
$plantsTreesActualUses->selectRecord($plantsTrees->getActualUse());
$plantsTreesActualUsesDescription = $plantsTreesActualUses->getDescription();
$plantsTreesActualUsesCode = $plantsTreesActualUses->getCode();
} else {
$plantsTreesActualUsesDescription = $plantsTrees->getActualUse();
$plantsTreesActualUsesCode = $plantsTrees->getActualUse();
}
$this->formArray["propertyKind" . ($i + 1)] = "PlantsTrees";
$this->formArray["propertyActualUse" . ($i + 1)] = $plantsTreesActualUsesDescription;
$this->formArray["propertyMarketValue" . ($i + 1)] = $plantsTrees->getMarketValue();
$this->formArray["propertyAssessmentLevel" . ($i + 1)] = $plantsTrees->getAssessmentLevel();
$this->formArray["propertyAssessedValue" . ($i + 1)] = $plantsTrees->getAssessedValue();
$totalMarketValue += toFloat($plantsTrees->getMarketValue());
$totalAssessedValue += toFloat($plantsTrees->getAssessedValue());
$i++;
}
}
}
if (count($improvementsBuildingsList)) {
foreach ($improvementsBuildingsList as $key => $improvementsBuildings) {
if ($i < 4) {
// buildingClassification
$improvementsBuildingsClasses = new ImprovementsBuildingsClasses();
if (is_numeric($improvementsBuildings->getBuildingClassification())) {
$improvementsBuildingsClasses->selectRecord($improvementsBuildings->getBuildingClassification());
$improvementsBuildingsClassesDescription = $improvementsBuildingsClasses->getDescription();
$improvementsBuildingsClassesCode = $improvementsBuildingsClasses->getCode();
} else {
$improvementsBuildingsClassesDescription = $improvementsBuildings->getBuildingClassification();
$improvementsBuildingsClassesCode = $improvementsBuildings->getBuildingClassification();
}
// actualUse
$improvementsBuildingsActualUses = new ImprovementsBuildingsActualUses();
if (is_numeric($improvementsBuildings->getActualUse())) {
$improvementsBuildingsActualUses->selectRecord($improvementsBuildings->getActualUse());
$improvementsBuildingsActualUsesDescription = $improvementsBuildingsActualUses->getDescription();
$improvementsBuildingsActualUsesCode = $improvementsBuildingsActualUses->getCode();
} else {
$improvementsBuildingsActualUsesDescription = $improvementsBuildings->getActualUse();
$improvementsBuildingsActualUsesCode = $improvementsBuildings->getActualUse();
}
$this->formArray["propertyKind" . ($i + 1)] = "ImprovementsBuildings";
$this->formArray["propertyActualUse" . ($i + 1)] = $improvementsBuildingsActualUsesDescription;
$this->formArray["propertyMarketValue" . ($i + 1)] = $improvementsBuildings->getMarketValue();
$this->formArray["propertyAssessmentLevel" . ($i + 1)] = $improvementsBuildings->getAssessmentLevel();
$this->formArray["propertyAssessedValue" . ($i + 1)] = $improvementsBuildings->getAssessedValue();
$totalMarketValue += toFloat($improvementsBuildings->getMarketValue());
$totalAssessedValue += toFloat($improvementsBuildings->getAssessedValue());
$i++;
}
}
}
if (count($machineriesList)) {
foreach ($machineriesList as $key => $machineries) {
if ($i < 4) {
// kind
$machineriesClasses = new MachineriesClasses();
if (is_numeric($machineries->getKind())) {
$machineriesClasses->selectRecord($machineries->getKind());
$machineriesClassesDescription = $machineriesClasses->getDescription();
$machineriesClassesCode = $machineriesClasses->getCode();
} else {
$machineriesClassesDescription = $machineries->getKind();
$machineriesClassesCode = $machineries->getActualUse();
}
// actualUse
$machineriesActualUses = new MachineriesActualUses();
if (is_numeric($machineries->getActualUse())) {
$machineriesActualUses->selectRecord($machineries->getActualUse());
$machineriesActualUsesDescription = $machineriesActualUses->getDescription();
$machineriesActualUsesCode = $machineriesActualUses->getCode();
} else {
$machineriesActualUsesDescription = $machineries->getActualUse();
$machineriesActualUsesCode = $machineries->getActualUse();
}
$this->formArray["propertyKind" . ($i + 1)] = "Machineries";
$this->formArray["propertyActualUse" . ($i + 1)] = $machineriesActualUsesDescription;
$this->formArray["propertyMarketValue" . ($i + 1)] = $machineries->getMarketValue();
$this->formArray["propertyAssessmentLevel" . ($i + 1)] = $machineries->getAssessmentLevel();
$this->formArray["propertyAssessedValue" . ($i + 1)] = $machineries->getAssessedValue();
$totalMarketValue += toFloat($machineries->getMarketValue());
$totalAssessedValue += toFloat($machineries->getAssessedValue());
$i++;
}
}
}
$this->formArray["totalMarketValue"] = $totalMarketValue;
$this->formArray["totalAssessedValue"] = $totalAssessedValue;
$this->formArray["totalAssessedValueInWords"] = makewords($totalAssessedValue);
}
