function TreasurySettingsEncode($http_post_vars, $sess, $formAction, $masterTables)
{
global $auth;
$this->sess = $sess;
$this->user = $auth->auth;
$this->formArray["uid"] = $auth->auth["uid"];
$this->user = $auth->auth;
$this->masterTables = $masterTables;
// must be Super-User to access
$pageType = "1%%%%%%%%%";
if (!checkPerms($this->user["userType"], $pageType)) {
header("Location: Unauthorized.php" . $this->sess->url(""));
exit;
}
$this->tpl = new rpts_Template(getcwd(), "keep");
$this->tpl->set_file("rptsTemplate", "TreasurySettingsEncode.htm");
$this->tpl->set_var("TITLE", "Treasury Settings");
$this->formArray = array("formAction" => $formAction, "message" => "", "cutOff" => "");
foreach ($http_post_vars as $key => $value) {
$this->formArray[$key] = $value;
}
if ($this->formArray["discountPeriod_month"] != "" && $this->formArray["discountPeriod_month"] != "") {
$dateStr = putPreZero($this->formArray["discountPeriod_month"]) . "-" . putPreZero($this->formArray["discountPeriod_day"]);
$this->formArray["discountPeriod"] = $dateStr;
}
}
function LandFAAS($http_post_vars, $afsID = "", $propertyID = "", $formAction = "", $sess)
{
$this->sess = $sess;
$this->tpl = new rpts_Template(getcwd(), "keep");
$this->tpl->set_file("rptsTemplate", "LandFAAS.htm");
$this->tpl->set_var("TITLE", "Encode Land");
$this->formArray = array("afsID" => $afsID, "propertyID" => $propertyID, "arpNumber" => "", "propertyIndexNumber" => "", "propertyAdministrator" => "", "personID" => "", "lastName" => "", "firstName" => "", "middleName" => "", "gender" => "", "birth_month" => date("n"), "birth_day" => date("j"), "birth_year" => date("Y"), "maritalStatus" => "", "tin" => "", "addressID" => "", "number" => "", "street" => "", "barangay" => "", "district" => "", "municipalityCity" => "", "province" => "", "telephone" => "", "mobileNumber" => "", "email" => "", "verifiedByID" => "", "verifiedBy" => "", "verifiedByName" => "", "plottingsByID" => "", "plottingsBy" => "", "plottingsByName" => "", "notedByID" => "", "notedBy" => "", "notedByName" => "", "marketValue" => "", "kind" => "", "actualUse" => "", "adjustedMarketValue" => "", "assessmentLevel" => "", "assessedValue" => "", "previousOwner" => "", "previousAssessedValue" => "", "taxability" => "", "effectivity" => "", "appraisedByID" => "", "appraisedBy" => "", "appraisedByName" => "", "appraisedByDate" => "", "recommendingApprovalID" => "", "recommendingApproval" => "", "recommendingApprovalName" => "", "recommendingApprovalDate" => "", "approvedByID" => "", "approvedBy" => "", "approvedByName" => "", "approvedByDate" => "", "memoranda" => "", "postingDate" => "", "octTctNumber" => "", "surveyNumber" => "", "north" => "", "east" => "", "south" => "", "west" => "", "classification" => "", "subClass" => "", "area" => "", "unitValue" => "", "adjustmentFactor" => "", "percentAdjustment" => "", "valueAdjustment" => "", "as_month" => date("n"), "as_day" => date("j"), "as_year" => date("Y"), "re_month" => date("n"), "re_day" => date("j"), "re_year" => date("Y"), "av_month" => date("n"), "av_day" => date("j"), "av_year" => date("Y"), "formAction" => $formAction);
foreach ($http_post_vars as $key => $value) {
$this->formArray[$key] = $value;
//echo $key." = ".$this->formArray[$key]."<br>";
}
$as_dateStr = $this->formArray["as_year"] . "-" . putPreZero($this->formArray["as_month"]) . "-" . putPreZero($this->formArray["as_day"]);
$this->formArray["appraisedByDate"] = $as_dateStr;
$re_dateStr = $this->formArray["re_year"] . "-" . putPreZero($this->formArray["re_month"]) . "-" . putPreZero($this->formArray["re_day"]);
$this->formArray["recommendingApprovalDate"] = $re_dateStr;
$av_dateStr = $this->formArray["av_year"] . "-" . putPreZero($this->formArray["av_month"]) . "-" . putPreZero($this->formArray["av_day"]);
$this->formArray["approvedByDate"] = $av_dateStr;
$AssessorList = new SoapObject(NCCBIZ . "AssessorList.php", "urn:Object");
if (!($xmlStr = $AssessorList->getAssessorList())) {
$this->tpl->set_block("rptsTemplate", "Dropdown", "DropdownBlock");
$this->tpl->set_var("DropdownBlock", "page not found");
} else {
if (!($domDoc = domxml_open_mem($xmlStr))) {
$this->tpl->set_block("rptsTemplate", "Dropdown", "DropdownBlock");
$this->tpl->set_var("DropdownBlock", "error xmlDoc");
} else {
$assessorRecords = new AssessorRecords();
$assessorRecords->parseDomDocument($domDoc);
$this->assessorList = $assessorRecords->getArrayList();
}
}
}
function setForm()
{
$this->formArray["noticeDate"] = date("F d, Y", strtotime($this->formArray["noticeDate_year"] . "-" . putPreZero($this->formArray["noticeDate_month"]) . "-" . putPreZero($this->formArray["noticeDate_day"])));
foreach ($this->formArray as $key => $value) {
$this->tpl->set_var($key, html_entity_to_alpha($value));
}
}
function setForm()
{
$this->formArray["date"] = date("F d, Y");
$this->formArray["orDate"] = date("F d, Y", strtotime($this->formArray["orDate_year"] . "-" . putPreZero($this->formArray["orDate_month"]) . "-" . putPreZero($this->formArray["orDate_day"])));
$this->formArray["dateIssued"] = date("jS \\d\\a\\y of F, Y");
foreach ($this->formArray as $key => $value) {
$this->tpl->set_var($key, $value);
}
}
function filterDate()
{
$filterFromDate = $this->formArray["filterFrom_year"] . "-" . putPreZero($this->formArray["filterFrom_month"]) . "-" . putPreZero($this->formArray["filterFrom_day"]);
$filterToDate = $this->formArray["filterTo_year"] . "-" . putPreZero($this->formArray["filterTo_month"]) . "-" . putPreZero($this->formArray["filterTo_day"]) . " 23:59:59";
$filterFromTimeStr = strtotime($filterFromDate);
$filterToTimeStr = strtotime($filterToDate);
$condition = " " . OD_TABLE . ".dateCreated >= " . $filterFromTimeStr . "";
$condition .= " AND " . OD_TABLE . ".dateCreated <= " . $filterToTimeStr . "";
return $condition;
}
function getDateStr($year, $month, $day)
{
$year = $this->formArray[$year];
$month = $this->formArray[$month];
$day = $this->formArray[$day];
if ($year != "" && $month != "" && $day != "") {
$dateStr = $year . "-" . putPreZero($month) . "-" . putPreZero($day);
} else {
$dateStr = "";
}
return $dateStr;
}
function setForm()
{
$this->formArray["date"] = date("F d, Y");
if ($this->formArray["orDate_year"] != "" && $this->formArray["orDate_month"] != "" && $this->formArray["orDate_day"] != "") {
$this->formArray["orDate"] = date("F d, Y", strtotime($this->formArray["orDate_year"] . "-" . putPreZero($this->formArray["orDate_month"]) . "-" . putPreZero($this->formArray["orDate_day"])));
} else {
$this->formArray["orDate"] = "";
}
foreach ($this->formArray as $key => $value) {
$this->tpl->set_var($key, $value);
}
}
function UserEncode($http_post_vars, $userID = "", $personID = "", $formAction = "", $sess, $ownerID = "", $odID)
{
$this->sess = $sess;
$this->tpl = new rpts_Template(getcwd(), "keep");
$this->tpl->set_file("rptsTemplate", "UserEncode.htm");
$this->tpl->set_var("TITLE", "Encode User / Person");
$this->tpl->set_var("Session", $this->sess->url("") . $this->sess->add_query(array("ownerID" => $ownerID)));
$this->tpl->set_block("rptsTemplate", "Message", "MessageBlock");
$this->formArray = array("userID" => $userID, "username" => "", "userType" => "", "oldPassword" => "", "newPassword" => "", "password" => "", "confirmPassword" => "", "status" => "", "personID" => $personID, "lastName" => "", "firstName" => "", "middleName" => "", "gender" => "", "birth_month" => "", "birth_day" => "", "birth_year" => "", "maritalStatus" => "", "tin" => "", "addressID" => "", "number" => "", "street" => "", "barangay" => "", "district" => "", "municipalityCity" => "", "province" => "", "telephone" => "", "mobileNumber" => "", "email" => "", "formAction" => $formAction, "ownerID" => $ownerID, "odID" => $odID);
foreach ($http_post_vars as $key => $value) {
$this->formArray[$key] = $value;
}
$dateStr = $this->formArray["birth_year"] . "-" . putPreZero($this->formArray["birth_month"]) . "-" . putPreZero($this->formArray["birth_day"]);
$this->birthdate = $dateStr;
}
function NoticeOfDelinquencyPrint($http_post_vars, $sess, $rptopID, $ownerID)
{
$this->now = "now";
$this->sess = $sess;
$this->tpl = new rpts_Template(getcwd(), "keep");
$this->tpl->set_file("rptsTemplate", "noticeOfDelinquency.xml");
$this->tpl->set_var("TITLE", "Notice Of Delinquency Print");
$this->formArray = array("rptopID" => $rptopID, "ownerID" => $ownerID, "lguType" => "", "lguName" => "", "ownerName" => "", "address1" => "", "address2" => "", "tdYPosValue" => "366", "signatory1" => "", "signatory1Designation" => "", "signatory2" => "", "signaotyr2Designation" => "", "dateIssued" => date("F d, Y"), "dateAsOf" => "");
$this->tdRecord = array("arpNumber", "assessedValue", "basic", "sef", "penalty", "class", "location", "year", "taxDue");
foreach ($http_post_vars as $key => $value) {
$this->formArray[$key] = $value;
}
$this->formArray["dateAsOf"] = date("F d, Y", strtotime($this->formArray["asOfDate_year"] . "-" . putPreZero($this->formArray["asOfDate_month"]) . "-" . putPreZero($this->formArray["asOfDate_day"])));
$this->now = $this->formArray["dateAsOf"];
}
function TDEncode($http_post_vars, $afsID, $propertyID = "", $tdID = "", $propertyType = "", $formAction = "", $sess)
{
//global $HTTP_POST_VARS;
global $auth;
$this->sess = $sess;
$this->userID = $auth->auth["uid"];
$this->tpl = new rpts_Template(getcwd(), "keep");
$this->tpl->set_file("rptsTemplate", "TDEncode.htm");
$this->tpl->set_var("TITLE", "Encode TD");
$this->formArray = array("afsID" => $afsID, "tdID" => $tdID, "propertyID" => $propertyID, "propertyType" => $propertyType, "taxDeclarationNumber" => "", "provincialAssessor" => "", "provincialAssessorDate" => "", "cityMunicipalAssessor" => "", "cityMunicipalAssessorDate" => "", "cancelsTDNumber" => "", "canceledByTDNumber" => "", "taxBeginsWithTheYear" => "", "ceasesWithTheYear" => "", "enteredInRPARForYear" => "", "enteredInRPARForBy" => "", "previousOwner" => "", "previousAssessedValue" => "", "pa_month" => "", "pa_day" => "", "pa_year" => "", "cm_month" => "", "cm_day" => "", "cm_year" => "", "formAction" => $formAction);
foreach ($http_post_vars as $key => $value) {
$this->formArray[$key] = $value;
//echo $key." = ".$this->formArray[$key]."<br>";
}
//$this->formArray["taxBeginsWithTheYear"];
$pa_dateStr = $this->formArray["pa_year"] . "-" . putPreZero($this->formArray["pa_month"]) . "-" . putPreZero($this->formArray["pa_day"]);
$this->formArray["provincialAssessorDate"] = $pa_dateStr;
$cm_dateStr = $this->formArray["cm_year"] . "-" . putPreZero($this->formArray["cm_month"]) . "-" . putPreZero($this->formArray["cm_day"]);
$this->formArray["cityMunicipalAssessorDate"] = $cm_dateStr;
}
function Main()
{
switch ($this->formArray["formAction"]) {
case "confirm":
$PaymentEncode = new SoapObject(NCCBIZ . "PaymentEncode.php", "urn:Object");
$ReceiptEncode = new SoapObject(NCCBIZ . "ReceiptEncode.php", "urn:Object");
$CollectionEncode = new SoapObject(NCCBIZ . "CollectionEncode.php", "urn:Object");
$basicReceiptIDArrayIndex = 0;
$sefReceiptIDArrayIndex = 0;
$idleReceiptIDArrayIndex = 0;
// create Basic Receipts
foreach ($this->formArray["basicReceipt"] as $basicReceiptArray) {
$basicReceipt = new Receipt();
$basicReceipt->setReceiptNumber($basicReceiptArray["receiptNumber"]);
$basicReceipt->setReceiptDate($this->formArray["paymentDate"]);
$basicReceipt->setPaymentMode($this->formArray["paymentMode"]);
$basicReceipt->setCheckNumber($this->formArray["checkNumber"]);
$basicReceipt->setDateOfCheck($this->formArray["dateOfCheck"]);
$basicReceipt->setDraweeBank($this->formArray["draweeBank"]);
$basicReceipt->setReceivedFrom($this->formArray["receivedFrom"]);
$basicReceipt->setPreviousReceiptNumber($basicReceiptArray["previousReceiptNumber"]);
$basicReceipt->setPreviousReceiptDate($basicReceiptArray["previousReceiptDate_year"] . "-" . putPreZero($basicReceiptArray["previousReceiptDate_month"] . "-" . putPreZero($basicReceiptArray["previousReceiptDate_day"])));
$basicReceipt->setCityTreasurer($this->formArray["cityTreasurer"]);
$basicReceipt->setDeputyTreasurer($this->formArray["deputyTreasurer"]);
$basicReceipt->setStatus("");
$basicReceipt->setDomDocument();
$domDoc = $basicReceipt->getDomDocument();
$xmlStr = $domDoc->dump_mem(true);
if (!($basicReceiptIDArray[$basicReceiptIDArrayIndex] = $ReceiptEncode->saveReceipt($xmlStr))) {
exit("error save basic receipt");
}
$receiptIDArray[] = $basicReceiptIDArray[$basicReceiptIDArrayIndex];
$basicReceiptIDArrayIndex++;
}
// create Sef Receipts
foreach ($this->formArray["sefReceipt"] as $sefReceiptArray) {
$sefReceipt = new Receipt();
$sefReceipt->setReceiptNumber($sefReceiptArray["receiptNumber"]);
$sefReceipt->setReceiptDate($this->formArray["paymentDate"]);
$sefReceipt->setPaymentMode($this->formArray["paymentMode"]);
$sefReceipt->setCheckNumber($this->formArray["checkNumber"]);
$sefReceipt->setDateOfCheck($this->formArray["dateOfCheck"]);
$sefReceipt->setDraweeBank($this->formArray["draweeBank"]);
$sefReceipt->setReceivedFrom($this->formArray["receivedFrom"]);
$sefReceipt->setPreviousReceiptNumber($sefReceiptArray["previousReceiptNumber"]);
$sefReceipt->setPreviousReceiptDate($sefReceiptArray["previousReceiptDate_year"] . "-" . putPreZero($sefReceiptArray["previousReceiptDate_month"] . "-" . putPreZero($sefReceiptArray["previousReceiptDate_day"])));
$sefReceipt->setCityTreasurer($this->formArray["cityTreasurer"]);
$sefReceipt->setDeputyTreasurer($this->formArray["deputyTreasurer"]);
$sefReceipt->setStatus("");
$sefReceipt->setDomDocument();
$domDoc = $sefReceipt->getDomDocument();
$xmlStr = $domDoc->dump_mem(true);
if (!($sefReceiptIDArray[$sefReceiptIDArrayIndex] = $ReceiptEncode->saveReceipt($xmlStr))) {
exit("error save sef receipt");
}
$receiptIDArray[] = $sefReceiptIDArray[$sefReceiptIDArrayIndex];
$sefReceiptIDArrayIndex++;
}
// create Idle Receipts
foreach ($this->formArray["idleReceipt"] as $idleReceiptArray) {
$idleReceipt = new Receipt();
$idleReceipt->setReceiptNumber($idleReceiptArray["receiptNumber"]);
$idleReceipt->setReceiptDate($this->formArray["paymentDate"]);
$idleReceipt->setPaymentMode($this->formArray["paymentMode"]);
$idleReceipt->setCheckNumber($this->formArray["checkNumber"]);
$idleReceipt->setDateOfCheck($this->formArray["dateOfCheck"]);
$idleReceipt->setDraweeBank($this->formArray["draweeBank"]);
$idleReceipt->setReceivedFrom($this->formArray["receivedFrom"]);
$idleReceipt->setPreviousReceiptNumber($idleReceiptArray["previousReceiptNumber"]);
$idleReceipt->setPreviousReceiptDate($idleReceiptArray["previousReceiptDate_year"] . "-" . putPreZero($idleReceiptArray["previousReceiptDate_month"] . "-" . putPreZero($idleReceiptArray["previousReceiptDate_day"])));
$idleReceipt->setCityTreasurer($this->formArray["cityTreasurer"]);
$idleReceipt->setDeputyTreasurer($this->formArray["deputyTreasurer"]);
$idleReceipt->setStatus("");
$idleReceipt->setDomDocument();
$domDoc = $idleReceipt->getDomDocument();
$xmlStr = $domDoc->dump_mem(true);
if (!($idleReceiptIDArray[$idleReceiptIDArrayIndex] = $ReceiptEncode->saveReceipt($xmlStr))) {
exit("error save idle receipt");
}
$receiptIDArray[] = $idleReceiptIDArray[$idleReceiptIDArrayIndex];
$idleReceiptIDArrayIndex++;
}
$lineCtr = 0;
$basicReceiptIDArrayIndex = 0;
$sefReceiptIDArrayIndex = 0;
$idleReceiptIDArrayIndex = 0;
if (is_array($this->formArray["payment"])) {
foreach ($this->formArray["payment"] as $formPaymentArray) {
$payment = new Payment();
$payment->setTdID($formPaymentArray["tdID"]);
$payment->setDueID($formPaymentArray["dueID"]);
$payment->setDueType($formPaymentArray["dueType"]);
$payment->setBacktaxTDID($formPaymentArray["backtaxTDID"]);
$payment->setTaxDue($formPaymentArray["taxDue"]);
$payment->setAdvancedPaymentDiscount($formPaymentArray["advancedPaymentDiscount"]);
$payment->setEarlyPaymentDiscount($formPaymentArray["earlyPaymentDiscount"]);
$payment->setPenalty($formPaymentArray["penalty"]);
$payment->setAmnesty($formPaymentArray["amnesty"]);
$payment->setBalanceDue($formPaymentArray["balanceDue"]);
$payment->setAmountPaid($formPaymentArray["amountPaid"]);
$payment->setDueDate($formPaymentArray["dueDate"]);
$payment->setPaymentDate($formPaymentArray["paymentDate"]);
$payment->setOwnerID($formPaymentArray["ownerID"]);
$payment->setDomDocument();
$domDoc = $payment->getDomDocument();
$xmlStr = $domDoc->dump_mem(true);
if (!($paymentID = $PaymentEncode->savePayment($xmlStr))) {
exit("error save payment");
}
// basicCollection
if (is_array($formPaymentArray["basicReceipt"])) {
$basicReceiptID = $basicReceiptIDArray[$basicReceiptIDArrayIndex];
foreach ($formPaymentArray["basicReceipt"] as $basicCollectionArray) {
$basicCollection = new Collection();
$basicCollection->setPaymentID($paymentID);
$basicCollection->setReceiptID($basicReceiptID);
$basicCollection->setTaxType($basicCollectionArray["taxType"]);
$basicCollection->setTaxDue($basicCollectionArray["taxDue"]);
$basicCollection->setAdvancedPaymentDiscount($basicCollectionArray["advancedPaymentDiscount"]);
$basicCollection->setEarlyPaymentDiscount($basicCollectionArray["earlyPaymentDiscount"]);
$basicCollection->setPenalty($basicCollectionArray["penalty"]);
$basicCollection->setAmnesty($basicCollectionArray["amnesty"]);
$basicCollection->setBalanceDue($basicCollectionArray["balanceDue"]);
$basicCollection->setAmountPaid($basicCollectionArray["amountPaid"]);
$basicCollection->setDomDocument();
$domDoc = $basicCollection->getDomDocument();
$xmlStr = $domDoc->dump_mem(true);
if (!($basicCollectionID = $CollectionEncode->saveCollection($xmlStr))) {
exit("error save basic collection");
}
}
}
// sefCollection
if (is_array($formPaymentArray["sefReceipt"])) {
$sefReceiptID = $sefReceiptIDArray[$sefReceiptIDArrayIndex];
foreach ($formPaymentArray["sefReceipt"] as $sefCollectionArray) {
$sefCollection = new Collection();
$sefCollection->setPaymentID($paymentID);
$sefCollection->setReceiptID($sefReceiptID);
$sefCollection->setTaxType($sefCollectionArray["taxType"]);
$sefCollection->setTaxDue($sefCollectionArray["taxDue"]);
$sefCollection->setAdvancedPaymentDiscount($sefCollectionArray["advancedPaymentDiscount"]);
$sefCollection->setEarlyPaymentDiscount($sefCollectionArray["earlyPaymentDiscount"]);
$sefCollection->setPenalty($sefCollectionArray["penalty"]);
$sefCollection->setAmnesty($sefCollectionArray["amnesty"]);
$sefCollection->setBalanceDue($sefCollectionArray["balanceDue"]);
$sefCollection->setAmountPaid($sefCollectionArray["amountPaid"]);
$sefCollection->setDomDocument();
$domDoc = $sefCollection->getDomDocument();
$xmlStr = $domDoc->dump_mem(true);
if (!($sefCollectionID = $CollectionEncode->saveCollection($xmlStr))) {
exit("error save basic collection");
}
}
}
// idleCollection
if (is_array($formPaymentArray["idleReceipt"])) {
$idleReceiptID = $idleReceiptIDArray[$idleReceiptIDArrayIndex];
foreach ($formPaymentArray["idleReceipt"] as $idleCollectionArray) {
$idleCollection = new Collection();
$idleCollection->setPaymentID($paymentID);
$idleCollection->setReceiptID($idleReceiptID);
$idleCollection->setTaxType($idleCollectionArray["taxType"]);
$idleCollection->setTaxDue($idleCollectionArray["taxDue"]);
$idleCollection->setAdvancedPaymentDiscount($idleCollectionArray["advancedPaymentDiscount"]);
$idleCollection->setEarlyPaymentDiscount($idleCollectionArray["earlyPaymentDiscount"]);
$idleCollection->setPenalty($idleCollectionArray["penalty"]);
$idleCollection->setAmnesty($idleCollectionArray["amnesty"]);
$idleCollection->setBalanceDue($idleCollectionArray["balanceDue"]);
$idleCollection->setAmountPaid($idleCollectionArray["amountPaid"]);
$idleCollection->setDomDocument();
$domDoc = $idleCollection->getDomDocument();
$xmlStr = $domDoc->dump_mem(true);
if (!($idleCollectionID = $CollectionEncode->saveCollection($xmlStr))) {
exit("error save basic collection");
}
}
}
$lineCtr++;
if ($lineCtr == $this->formArray["maxLinesPerReceipt"] || $lineCtr == count($this->formArray["payment"])) {
$lineCtr = 0;
$basicReceiptIDArrayIndex++;
$sefReceiptIDArrayIndex++;
$idleReceiptIDArrayIndex++;
}
}
$receiptIDArrayQueryString = "";
foreach ($receiptIDArray as $receiptID) {
$receiptIDArrayQueryString .= "&receiptIDArray[]=" . $receiptID;
}
header("Location: PrintReceiptDetails.php" . $this->sess->url("") . "&rptopID=" . $this->formArray["rptopID"] . "&ownerID=" . $this->formArray["ownerID"] . $receiptIDArrayQueryString);
exit;
}
break;
default:
header("Location: Unauthorized.php" . $this->sess->url(""));
exit;
}
}
