function Main($referer = "")
{
if (!$referer || !isset($referer)) {
$referer = "OwnerList.php";
}
$this->tpl->set_var("referer", $referer);
switch ($this->formArray["formAction"]) {
case "save" || "view" || "viewOnly":
$this->tpl->set_var("referer", $referer);
$CompanyDetails = new SoapObject(NCCBIZ . "CompanyDetails.php", "urn:Object");
if (!($xmlStr = $CompanyDetails->getCompanyDetails($this->formArray["companyID"]))) {
$this->tpl->set_block("rptsTemplate", "Table", "TableBlock");
$this->tpl->set_var("TableBlock", "record not found");
} else {
if (!($domDoc = domxml_open_mem($xmlStr))) {
$this->tpl->set_block("rptsTemplate", "Table", "TableBlock");
$this->tpl->set_var("TableBlock", "error xmlDoc");
} else {
$company = new Company();
$company->parseDomDocument($domDoc);
$this->formArray["companyID"] = $company->getCompanyID();
$this->formArray["companyName"] = $company->getCompanyName();
$this->formArray["tin"] = $company->getTin();
$this->formArray["telephone"] = $company->getTelephone();
$this->formArray["fax"] = $company->getFax();
$address = $company->addressArray[0];
if (is_a($address, Address)) {
$this->formArray["addressID"] = $address->getAddressID();
$this->formArray["number"] = $address->getNumber();
$this->formArray["street"] = $address->getStreet();
$this->formArray["barangay"] = $address->getBarangay();
$this->formArray["district"] = $address->getDistrict();
$this->formArray["municipalityCity"] = $address->getMunicipalitycity();
$this->formArray["province"] = $address->getProvince();
}
$this->formArray["email"] = $company->getEmail();
$this->formArray["website"] = $company->getWebsite();
}
}
if ($this->formArray["formAction"] == "viewOnly") {
$this->tpl->set_block("rptsTemplate", "ViewOnly", "ViewOnlyBlock");
$this->tpl->set_var("ViewOnlyBlock", "");
}
break;
case "cancel":
//header("location: CompanyList.php");
exit;
break;
default:
$this->tpl->set_block("rptsTemplate", "ACK", "ACKBlock");
$this->tpl->set_var("ACKBlock", "");
}
//*/
$this->setForm();
$this->tpl->parse("templatePage", "rptsTemplate");
$this->tpl->finish("templatePage");
$this->tpl->p("templatePage");
}
function encoder_redirect_success(Company $company)
{
$Company_Name = $company->getCompanyName();
$Company_Name_Amharic = $company->getCompanyNameAmharic();
$dir = "VIEW/html/Encoder/Add_Company/Company_List.php?success=1&Company_Name={$Company_Name}&Company_Name_Amharic={$Company_Name_Amharic}";
$url = BASE_URL . $dir;
header("Location:{$url}");
//redirect the encoder to the regions add place
exit;
}
function Main()
{
switch ($this->formArray["ownerType"]) {
case "Person":
$this->tpl->set_block("rptsTemplate", "CompanyDetails", "CompanyDetailsBlock");
$this->tpl->set_var("CompanyDetailsBlock", "");
$person = new Person();
$person->selectRecord($this->formArray["id"]);
$this->tpl->set_var("id", $person->getPersonID());
$this->tpl->set_var("lastName", $person->getLastName());
$this->tpl->set_var("firstName", $person->getFirstName());
$this->tpl->set_var("middleName", $person->getMiddleName());
$this->tpl->set_var("gender", $person->getGender());
$this->tpl->set_var("birthday", $person->getBirthday());
$this->tpl->set_var("maritalStatus", $person->getMaritalStatus());
$this->tpl->set_var("tin", $person->getTin());
$address = $person->addressArray[0];
if (is_a($address, Address)) {
$this->tpl->set_var("fullAddress", $address->getFullAddress());
}
$this->tpl->set_var("telephone", $person->getTelephone());
$this->tpl->set_var("mobileNumber", $person->getMobileNumber());
$this->tpl->set_var("email", $person->getEmail());
break;
case "Company":
$this->tpl->set_block("rptsTemplate", "PersonDetails", "PersonDetailsBlock");
$this->tpl->set_var("PersonDetailsBlock", "");
$company = new Company();
$company->selectRecord($this->formArray["id"]);
$this->tpl->set_var("id", $company->getCompanyID());
$this->tpl->set_var("companyName", $company->getCompanyName());
$this->tpl->set_var("tin", $company->getTin());
$this->tpl->set_var("telephone", $company->getTelephone());
$this->tpl->set_var("fax", $company->getFax());
$address = $company->addressArray[0];
if (is_a($address, Address)) {
$this->tpl->set_var("fullAddress", $address->getFullAddress());
}
$this->tpl->set_var("email", $company->getEmail());
$this->tpl->set_var("website", $company->getWebsite());
break;
default:
exit("No Person/Company selected. <a href='OwnerList.php" . $this->sess->url("") . "'>Click here</a> to go back to the Owner List.");
break;
}
$this->tpl->set_var("ownerType", $this->formArray["ownerType"]);
$this->tpl->set_var("uname", $this->user["uname"]);
$this->tpl->set_var("today", date("F j, Y"));
$this->setPageDetailPerms();
$this->tpl->set_var("Session", $this->sess->url(""));
$this->tpl->parse("templatePage", "rptsTemplate");
$this->tpl->finish("templatePage");
$this->tpl->p("templatePage");
}
/**
* Save Company
* @param Company $company
* @returns boolean
* @throws DaoException
*/
public function saveCompany(Company $company)
{
try {
$infoStr = $company->comapanyName . '|' . $company->country . '|' . $company->street1 . '|' . $company->street2 . '|' . $company->state . '|' . $company->city . '|' . $company->zipCode . '|' . $company->phone . '|' . $company->fax . '|' . $company->taxId . '|' . $company->naics . '|' . $company->comments;
$q = Doctrine_Query::create()->from('CompanyGeninfo')->where("code = ?", "001");
$companyGeninfo = $q->fetchOne();
$companyGeninfo->setGeninfoValues($infoStr);
$companyGeninfo->save();
$rootCompanyStructure = $this->readCompanyStructure(1);
$rootCompanyStructure->setTitle($company->getCompanyName());
$rootCompanyStructure->save();
return true;
} catch (Exception $e) {
throw new DaoException($e->getMessage());
}
}
function setCompanyList()
{
$db = new DB_RPTS();
$db1 = new DB_RPTS();
$db->query("SELECT DISTINCT companyID from OwnerCompany inner join Owner on Owner.ownerID=OwnerCompany.ownerID where Owner.rptopID <> ''");
$this->tpl->set_block("rptsTemplate", "Company", "cBlk");
for ($i = 0; $db->next_record(); $i++) {
$companyID = $db->f("companyID");
$company = new Company();
if ($company->selectRecord($companyID)) {
//$setPersonArray($person);
$this->tpl->set_var(companyName, $company->getCompanyName());
$this->tpl->set_var(companyID, $companyID);
}
$this->tpl->parse("cBlk", "Company", true);
}
}
function getOwnerName($ownerType, $id)
{
$ownerName = "";
switch ($ownerType) {
case "Person":
$person = new Person();
$person->selectRecord($id);
$ownerName = $person->getName();
$this->tpl->set_var("openWin", "PersonDetails.php" . $this->sess->url("") . "&personID=" . $id . "&formAction=viewOnly");
break;
case "Company":
$company = new Company();
$company->selectRecord($id);
$ownerName = $company->getCompanyName();
$this->tpl->set_var("openWin", "CompanyDetails.php" . $this->sess->url("") . "&companyID=" . $id . "&formAction=viewOnly");
break;
}
return $ownerName;
}
$div_style = 'style="display:none;"';
}
echo '<input type="checkbox" name="setRec" id="setRec" value= "Yes" ', $checked, ' onclick="setRecurent();" />', ' ', '<span class="text12"><b>', _('Set this invoice as recurrent'), '</b></span><br /><br />', '<div id="rec_section" class="text12" ', $div_style, '>', _('Repeat this invoice every: <br />'), '<div class="spacerblock_5"></div>', '<input type="text" name="recurrent" id="recurrent" size="2" value="', $recurrence, '"> ', $_SESSION['RecurrentInvoice']->generateRecurrentFrequencyCombo($frequency), '<br /><br /><br />', _('(like every 2 Months or every 3 Days)'), '</div><br />';
// Recurrent Part ends here
?>
</div>
</div>
<div class="left_menu_footer"></div><br /><br />
</td><td class="layout_rcolumn">
<div class="contentfull">
<div class="text32"><b><?php
echo _('Edit Invoice'), ' ', $_SESSION['do_invoice']->num;
?>
:</b> <?php
$company_name = $do_company->getCompanyName($_SESSION['do_invoice']->idcompany);
echo empty($company_name) ? $do_contact->getContactName($_SESSION['do_invoice']->idcontact) : $company_name;
?>
</div>
<div class="spacerblock_20"></div>
<div class="invoice_edit">
<?php
if ($_SESSION['do_invoice']->inv_logo == '') {
echo '<a href="/settings_invoice.php">Upload Logo</a>';
} else {
echo '<img src="/files/' . $_SESSION['do_invoice']->inv_logo . '" alt="" /><br />';
}
?>
<div class="spacerblock_20"></div>
<table class="layout_columns">
<tr>
function Main()
{
$this->getSignatory();
if (is_array($this->formArray["personCompanyIDArray"])) {
$this->tpl->set_block("rptsTemplate", "Page", "PageBlock");
foreach ($this->formArray["personCompanyIDArray"] as $personCompanyID) {
$this->tpl->set_var("pageNumber", $this->pageNumber);
switch ($this->formArray["ownerType"]) {
case "Company":
$company = new Company();
$company->selectRecord($personCompanyID);
$nameList = $company->getCompanyName();
break;
case "Person":
default:
$person = new Person();
$person->selectRecord($personCompanyID);
$nameList = $person->getName();
break;
}
$this->tpl->set_var("nameList", $nameList);
$tdNumberList = "";
$tdArray = $this->getTDArrayFromOwner($personCompanyID);
if (is_array($tdArray)) {
foreach ($tdArray as $td) {
if ($tdNumberList != "") {
$tdNumberList .= "\n";
}
$tdNumberList .= $this->getTDNumberListLine($td);
}
}
$this->tpl->set_var("tdNumberList", $tdNumberList);
$this->tpl->parse("PageBlock", "Page", true);
$this->pageNumber++;
}
} else {
exit("no owners selected");
}
$this->setLguDetails();
$this->setForm();
$this->tpl->parse("templatePage", "rptsTemplate");
$this->tpl->finish("templatePage");
$testpdf = new PDFWriter();
$testpdf->setOutputXML($this->tpl->get("templatePage"), "test");
if (isset($this->formArray["print"])) {
$testpdf->writePDF($name);
//,$this->formArray["print"]);
} else {
$testpdf->writePDF($name);
}
}
function Main()
{
switch ($this->formArray["formAction"]) {
case "edit":
$CompanyDetails = new SoapObject(NCCBIZ . "CompanyDetails.php", "urn:Object");
if (!($xmlStr = $CompanyDetails->getCompanyDetails($this->formArray["companyID"]))) {
$this->tpl->set_block("rptsTemplate", "Table", "TableBlock");
$this->tpl->set_var("TableBlock", "record not found");
} else {
if (!($domDoc = domxml_open_mem($xmlStr))) {
$this->tpl->set_block("rptsTemplate", "Table", "TableBlock");
$this->tpl->set_var("TableBlock", "error xmlDoc");
} else {
$company = new Company();
$company->parseDomDocument($domDoc);
$this->formArray["companyID"] = $company->getCompanyID();
$this->formArray["companyName"] = $company->getCompanyName();
$this->formArray["tin"] = $company->getTin();
$this->formArray["telephone"] = $company->getTelephone();
$this->formArray["fax"] = $company->getFax();
$address = $company->addressArray[0];
if (is_a($address, Address)) {
$this->formArray["addressID"] = $address->getAddressID();
$this->formArray["number"] = $address->getNumber();
$this->formArray["street"] = $address->getStreet();
$this->formArray["barangay"] = $address->getBarangay();
$this->formArray["district"] = $address->getDistrict();
$this->formArray["municipalityCity"] = $address->getMunicipalitycity();
$this->formArray["province"] = $address->getProvince();
}
$this->formArray["email"] = $company->getEmail();
$this->formArray["website"] = $company->getWebsite();
}
}
break;
case "save":
$CompanyEncode = new SoapObject(NCCBIZ . "CompanyEncode.php", "urn:Object");
if ($this->formArray["companyID"] != "") {
$CompanyDetails = new SoapObject(NCCBIZ . "CompanyDetails.php", "urn:Object");
if (!($xmlStr = $CompanyDetails->getCompanyDetails($this->formArray["companyID"]))) {
$this->tpl->set_block("rptsTemplate", "Table", "TableBlock");
$this->tpl->set_var("TableBlock", "record not found");
} else {
if (!($domDoc = domxml_open_mem($xmlStr))) {
$this->tpl->set_block("rptsTemplate", "Table", "TableBlock");
$this->tpl->set_var("TableBlock", "error xmlDoc");
} else {
$company = new Company();
$company->parseDomDocument($domDoc);
$address = $company->addressArray[0];
if (is_a($address, Address)) {
$address->setAddressID($this->formArray["addressID"]);
$address->setNumber($this->formArray["number"]);
$address->setStreet($this->formArray["street"]);
$address->setBarangay($this->formArray["barangay"]);
$address->setDistrict($this->formArray["district"]);
$address->setMunicipalityCity($this->formArray["municipalityCity"]);
$address->setProvince($this->formArray["province"]);
$address->setDomDocument();
}
//$company->selectRecord($this->formArray["companyID"]);
$company->setCompanyID($this->formArray["companyID"]);
$company->setCompanyName($this->formArray["companyName"]);
$company->setTin($this->formArray["tin"]);
$company->setTelephone($this->formArray["telephone"]);
$company->setFax($this->formArray["fax"]);
$company->setAddressArray($address);
$company->setEmail($this->formArray["email"]);
$company->setWebsite($this->formArray["website"]);
$company->setDomDocument();
$doc = $company->getDomDocument();
$xmlStr = $doc->dump_mem(true);
if (!($ret = $CompanyEncode->updateCompany($xmlStr))) {
exit("error update");
}
}
}
} else {
$address = new Address();
$address->setNumber($this->formArray["number"]);
$address->setStreet($this->formArray["street"]);
$address->setBarangay($this->formArray["barangay"]);
$address->setDistrict($this->formArray["district"]);
$address->setMunicipalityCity($this->formArray["municipalityCity"]);
$address->setProvince($this->formArray["province"]);
$address->setDomDocument();
$company = new Company();
$company->setCompanyID($this->formArray["companyID"]);
$company->setCompanyName($this->formArray["companyName"]);
$company->setTelephone($this->formArray["telephone"]);
$company->setFax($this->formArray["fax"]);
$company->setTin($this->formArray["tin"]);
$company->setAddressArray($address);
$company->setEmail($this->formArray["email"]);
$company->setWebsite($this->formArray["website"]);
$company->setDomDocument();
$doc = $company->getDomDocument();
$xmlStr = $doc->dump_mem(true);
if (!($ret = $CompanyEncode->saveCompany($xmlStr, $this->formArray["ownerID"]))) {
exit("error save");
}
}
$this->formArray["companyID"] = $ret;
//echo $ret;
//}
header("location: CompanyClose.php?parentURL=" . urlencode($this->formArray["parentURL"]));
exit;
//*/
//else echo "tumpak!";
break;
case "cancel":
header("location: CompanyList.php");
exit;
break;
default:
if ($this->formArray["locID"]) {
$ODDetails = new SoapObject(NCCBIZ . "ODDetails.php", "urn:Object");
if (!($xmlStr = $ODDetails->getLocation($this->formArray["locID"]))) {
exit("xml failed");
} else {
if (!($domDoc = domxml_open_mem($xmlStr))) {
} else {
$loc = new LocationAddress();
$loc->parseDomDocument($domDoc);
foreach ($loc as $key => $value) {
$this->formArray[$key] = $value;
}
}
}
}
$this->tpl->set_block("rptsTemplate", "companyID", "companyIDBlock");
$this->tpl->set_var("companyIDBlock", "");
$this->tpl->set_block("rptsTemplate", "ACK", "ACKBlock");
$this->tpl->set_var("ACKBlock", "");
}
//*/
$this->setForm();
$this->tpl->parse("templatePage", "rptsTemplate");
$this->tpl->finish("templatePage");
$this->tpl->p("templatePage");
}
echo _('No, I\'ll add later');
?>
</a><br /><br />
</div>
<?php
$do_inv_payment_log = new PaymentLog();
$do_inv_payment_log->getPaymentLog($_SESSION['do_invoice']->idinvoice);
while ($do_inv_payment_log->next()) {
$count = 0;
$e_del_log = new Event("PaymentLog->eventDeletePaymentLog");
$e_del_log->addParam("goto", $_SERVER['PHP_SELF']);
$e_del_log->addParam("id", $do_inv_payment_log->idpaymentlog);
$e_del_log->addParam("amt", $do_inv_payment_log->amount);
echo '<div id="templt', $count, '" class="co_worker_item co_worker_desc">';
echo '<div style="position: relative;">';
echo '<span class="text12"><span class="text_lightblue">', $do_inv_payment_log->ref_num, '</span> <span class="sep1">|</span> <b>', $_SESSION['do_invoice']->viewAmount($do_inv_payment_log->amount), '</b><br />', '<b>', isset($_SESSION['do_invoice']->idcompany) ? $do_company->getCompanyName($_SESSION['do_invoice']->idcompany) : $do_contact->getContactName($_SESSION['do_invoice']->idcontact), '</b><br />', '<span class="text_darkgray">Received: ', date('F j, Y', $do_inv_payment_log->timestamp), '</span></span>';
$img_del = '<img class="delete_icon_tag" border="0" width="14px" height="14px" src="/images/delete.gif">';
echo '<div width="15px" id="trashcan', $count, '" class="deletenote" style="right:0;">' . $e_del_log->getLink($img_del, ' title="' . _('Remove') . '"') . '</div>';
echo '</div></div>';
echo '<div class="invoiceline12"></div>';
$count++;
}
?>
</div>
</div>
<div class="left_menu_footer"></div><br /><br />
<?php
}
?>
<?php
function Main()
{
$this->formArray['currentDate'] = date("F d, Y");
$MunicipalityCityDetails = new SoapObject(NCCBIZ . "MunicipalityCityDetails.php", "urn:Object");
#test values
//$this->formArray['municipalityCityID']=1;
if (!($xmlStr = $MunicipalityCityDetails->getMunicipalityCityDetails($this->formArray['municipalityCityID']))) {
#echo($xmlStr);
//exit("xml failed for municipality");
header("Location: " . $this->sess->url("ViewSOA.php") . "&status=2");
} else {
if (!($domDoc = domxml_open_mem($xmlStr))) {
echo "error xmlDoc";
} else {
$MunicipalityCity = new MunicipalityCity();
$MunicipalityCity->parseDomDocument($domDoc);
$this->formArray['municipality'] = $MunicipalityCity->getDescription();
}
}
#test values
//$this->formArray['ownerID']=5;
#echo("ownerID=".$this->formArray['ownerID']."<br>");
// $this->displayOwnerList($this->formArray['ownerID']);
#test values
//$this->formArray["rptopID"]=15;
if ($this->formArray['personID'] != "") {
$person = new Person();
$person->selectRecord($this->formArray['personID']);
$this->tpl->set_var(ownerName, $person->getFullName());
$this->tpl->set_var(ownerNo, $person->getTin());
$address = $person->addressArray[0];
$this->tpl->set_var(ownerAddress, $address->getNumber() . " " . $address->getStreet() . " " . $address->getBarangay() . " " . $address->getDistrict() . " " . $address->getMunicipalitycity() . " " . $address->getProvince());
$db = new DB_RPTS();
$sql = "SELECT rptopID FROM Owner inner join OwnerPerson on Owner.ownerID=OwnerPerson.ownerID WHERE Owner.rptopID <> '' AND OwnerPerson.personID=" . $this->formArray['personID'];
$db->query($sql);
} else {
$company = new Company();
$company->selectRecord($this->formArray['companyID']);
$this->tpl->set_var(ownerName, $company->getCompanyName());
$this->tpl->set_var(ownerNo, $company->getCompanyID());
$address = $company->addressArray[0];
$this->tpl->set_var(ownerAddress, $address->getNumber() . " " . $address->getStreet() . " " . $address->getBarangay() . " " . $address->getDistrict() . " " . $address->getMunicipalitycity() . " " . $address->getProvince());
$db = new DB_RPTS();
$sql = "SELECT rptopID FROM Owner inner join OwnerPerson on Owner.ownerID=OwnerPerson.ownerID WHERE Owner.rptopID <> '' AND OwnerPerson.personID=" . $this->formArray['companyID'];
$db->query($sql);
}
/*$person = new Person();
$person->selectRecord($this->formArray['personID']);
$this->tpl->set_var(ownerName,$person->getFullName());
$this->tpl->set_var(ownerNo,$person->getTin());
$address = $person->addressArray[0];
$this->tpl->set_var(ownerAddress,$address->getNumber() ." ".$address->getStreet()." ".$address->getBarangay()." ".$address->getDistrict()." ".$address->getMunicipalitycity()." ".$address->getProvince());
$db = new DB_RPTS();
$sql = "SELECT rptopID FROM Owner inner join OwnerPerson on Owner.ownerID=OwnerPerson.ownerID WHERE Owner.rptopID <> '' AND OwnerPerson.personID=".$this->formArray['personID'];
$db->query($sql);*/
$this->tpl->set_block("rptsTemplate", "ROW", "RowBlk");
for ($i = 0; $db->next_record(); $i++) {
$rptopID = $db->f("rptopID");
$RPTOPDetails = new SoapObject(NCCBIZ . "RPTOPDetails.php", "urn:Object");
if (!($xmlStr = $RPTOPDetails->getRPTOP($rptopID))) {
// exit("xml failed for RPTOP");
header("Location: " . $this->sess->url("ViewSOA.php") . "&status=1");
} else {
//echo $xmlStr;
if (!($domDoc = domxml_open_mem($xmlStr))) {
$this->tpl->set_block("rptsTemplate", "OwnerListTable", "OwnerListTableBlock");
$this->tpl->set_var("OwnerListTableBlock", "error xmlDoc");
} else {
$rptop = new RPTOP();
$td = new TD();
$rptop->parseDomDocument($domDoc);
foreach ($rptop as $key => $value) {
$this->formArray['payableYear'] = $rptop->getTaxableYear();
$rptopID = $rptop->getRptopID();
if ($key == "tdArray") {
$tdCtr = 0;
if (count($value)) {
foreach ($value as $tkey => $tvalue) {
$td->selectRecord($tvalue->getTdID());
$assessedValue = number_format($td->getAssessedValue(), 2, ".", "");
$propertyType = $td->getPropertyType();
$TaxDeclarationNumber = $td->getTaxDeclarationNumber();
// $this->tpl->set_var(kind,$propertyType);
// $this->tpl->set_var(currentTDNo,$TaxDeclarationNumber);
/* $dues = new Dues();
$dues->create($td->getTdID(), "","","","2003");
$this->tpl->set_var(basic,$dues->getBasic());
$totBasic += $dues->getBasic();
$this->tpl->set_var(sef,$dues->getSEF());
$totSEF += $dues->getSEF();
$this->tpl->set_var(total,$dues->getSEF()+$dues->getBasic());
$totTaxDue += $dues->getSEF()+$dues->getBasic();*/
$afsID = $td->getAfsID();
$afs = new AFS();
$afs->selectRecord($afsID);
$od = new OD();
$od->selectRecord($afs->getOdID());
$addr = $od->getLocationAddress();
if (count($addr)) {
$location = $addr->getFullAddress();
// $this->tpl->set_var(location,$addr->getFullAddress());
$munCityID = $addr->getMunicipalityCityID();
// if($munCityID == $this->formArray['municipalityCityID'])
// $this->tpl->set_var(municipality,$addr->getMunicipalityCity());
}
if (count($afs->landArray)) {
foreach ($afs->landArray as $afsKey => $afsValue) {
$actualUse = $afsValue->getActualUse();
$landActualUses = new LandActualUses();
$landActualUses->selectRecord($actualUse);
//$this->tpl->set_var("class",$landActualUses->getCode());
$Code = $landActualUses->getCode();
}
}
if (count($afs->improvementsBuildingsArray)) {
foreach ($afs->improvementsBuildingsArray as $afsKey => $afsValue) {
$actualUse = $afsValue->getActualUse();
$improvementsBuildingsActualUses = new improvementsBuildingsActualUses();
$improvementsBuildingsActualUses->selectRecord($actualUse);
//$this->tpl->set_var("class",$improvementsBuildingsActualUses->getCode());
$Code = $improvementsBuildingsActualUses->getCode();
}
}
//echo $afs->get
// echo $munCityID ."==". $this->formArray['municipalityCityID']."<br>";
if ($munCityID == $this->formArray['municipalityCityID']) {
$this->tpl->set_var(location, $location);
$this->tpl->set_var("class", $Code);
$this->tpl->set_var(kind, $propertyType);
$this->tpl->set_var(currentTDNo, $TaxDeclarationNumber);
$this->tpl->set_var(municipality, $addr->getMunicipalityCity());
$dues = new Dues();
$dues->create($td->getTdID(), "", "", "", "2003");
$totTaxDue += $dues->getSEF() + $dues->getBasic();
$basic = number_format($dues->getBasic(), "2", ".", "");
$this->tpl->set_var(basic, $basic);
$totBasic += $basic;
$sef = number_format($dues->getSEF(), "2", ".", "");
$this->tpl->set_var(sef, $sef);
$totSEF += number_format($sef, "2", ".", "");
$this->tpl->set_var(total, number_format($sef + $basic, "2", ".", ""));
$this->tpl->set_var(marketValue, number_format($afs->getTotalMarketValue(), 2));
$totMarketValue += $afs->getTotalMarketValue();
$this->tpl->set_var(assessedValue, number_format($afs->getTotalAssessedValue(), 2));
$totAssessedValue += $afs->getTotalAssessedValue();
$pIndexNo = $afs->getPropertyIndexNumber();
if ($pIndexNo == "") {
$pIndexNo = "No value specified";
}
$this->tpl->set_var(pin, $pIndexNo);
//echo $afs->getTotalMarketValue();
/* if(count($afs->landArray)){
foreach($afs->landArray as $afsKey => $afsValue){
$this->tpl->set_var(pin,$afsValue->getPropertyIndexNumber());
}
}
*/
$this->tpl->parse("RowBlk", "ROW", true);
}
//else{
// $this->tpl->set_var("RowBlk","");
// }
}
#end foreach($value)
}
#end if coun value
$this->tpl->set_var(totalMarketValue, number_format($totMarketValue, 2));
$this->tpl->set_var(totalAssessedValue, number_format($totAssessedValue, 2));
$this->tpl->set_var(totalBasic, number_format($totBasic, 2));
$this->tpl->set_var(totalSEF, number_format($totSEF, 2));
$this->tpl->set_var(totalTaxDue, number_format($totTaxDue, 2));
}
}
}
// $this->tpl->parse("RowBlk","ROW",true);
}
}
// $owner
/* $RPTOPDetails = new SoapObject(NCCBIZ."RPTOPDetails.php", "urn:Object");
if (!$xmlStr = $RPTOPDetails->getRPTOP($this->formArray["rptopID"])){
//exit("xml failed for RPTOP");
header("Location: ".$this->sess->url("ViewSOA.php")."&status=1");
}
else{
//echo $xmlStr;
if(!$domDoc = domxml_open_mem($xmlStr)) {
$this->tpl->set_block("rptsTemplate", "OwnerListTable", "OwnerListTableBlock");
$this->tpl->set_var("OwnerListTableBlock", "error xmlDoc");
}
else {
$rptop = new RPTOP;
$td = new TD();
$rptop->parseDomDocument($domDoc);
$status_report = "";
foreach($rptop as $key => $value){
$this->formArray['payableYear'] = $rptop->getTaxableYear();
$rptopID = $rptop->getRptopID();
if($key=="tdArray"){
$tdCtr = 0;
if (count($value)){
$this->tpl->set_block("rptsTemplate","ROW","RowBlk");
foreach($value as $tkey => $tvalue){
$td->selectRecord($tvalue->getTdID());
$assessedValue = number_format($td->getAssessedValue(),2,".","");
$propertyType = $td->getPropertyType();
$TaxDeclarationNumber = $td->getTaxDeclarationNumber();
//$tdCtr++;
$this->tpl->set_var(kind,$propertyType);
$this->tpl->set_var(currentTDNo,$TaxDeclarationNumber);
/* $dues = new Dues();
$dues->create($td->getTdID(), "","","","2003");
$this->tpl->set_var(basic,$dues->getBasic());
$totBasic += $dues->getBasic();
$this->tpl->set_var(sef,$dues->getSEF());
$totSEF += $dues->getSEF();
$this->tpl->set_var(total,$dues->getSEF()+$dues->getBasic());
$totTaxDue += $dues->getSEF()+$dues->getBasic();*/
/* $afsID = $td->getAfsID();
$afs = new AFS();
$afs->selectRecord($afsID);
$od = new OD();
$od->selectRecord($afs->getOdID());
$addr = $od->getLocationAddress();
if(count($addr)){
$this->tpl->set_var(location,$addr->getFullAddress());
$munCityID = $addr->getMunicipalityCityID();
if($munCityID == $this->formArray['municipalityCityID'])
$this->tpl->set_var(municipality,$addr->getMunicipalityCity());
}
if(count($afs->landArray)){
foreach($afs->landArray as $afsKey => $afsValue){
$actualUse = $afsValue->getActualUse();
$landActualUses = new LandActualUses();
$landActualUses->selectRecord($actualUse);
$this->tpl->set_var("class",$landActualUses->getCode());
}
}
if(count($afs->improvementsBuildingsArray)){
foreach($afs->improvementsBuildingsArray as $afsKey => $afsValue){
$actualUse = $afsValue->getActualUse();
$improvementsBuildingsActualUses = new improvementsBuildingsActualUses();
$improvementsBuildingsActualUses->selectRecord($actualUse);
$this->tpl->set_var("class",$improvementsBuildingsActualUses->getCode());
}
}
//echo $afs->get
if($munCityID == $this->formArray['municipalityCityID']){
$dues = new Dues();
$dues->create($td->getTdID(), "","","","2003");
$this->tpl->set_var(basic,number_format($dues->getBasic(),"2",".",""));
$totBasic += $dues->getBasic();
$this->tpl->set_var(sef,number_format($dues->getSEF(),"2",".",""));
$totSEF += $dues->getSEF();
$this->tpl->set_var(total,number_format($dues->getSEF()+$dues->getBasic(),"2",".",""));
$pIndexNo = $afs->getPropertyIndexNumber();
if($pIndexNo==""){
$pIndexNo = "No value specified";
}
$this->tpl->set_var(pin,$pIndexNo);
$this->tpl->set_var(marketValue,$afs->getTotalMarketValue());
$totMarketValue += $afs->getTotalMarketValue();
$this->tpl->set_var(assessedValue,$afs->getTotalAssessedValue());
$totAssessedValue += $afs->getTotalAssessedValue();
//echo $afs->getTotalMarketValue();
/* if(count($afs->landArray)){
foreach($afs->landArray as $afsKey => $afsValue){
$this->tpl->set_var(pin,$afsValue->getPropertyIndexNumber());
}
}
*/
/* $this->tpl->parse("RowBlk","ROW",true);
}else{
$this->tpl->set_var("RowBlk","");
}
}#end foreach($value)
}#end if coun value
// $this->tpl->set_block("rptsTemplate","STAT",sBlk);
// $this->tpl->set_var(status_report,$status_report);
// $this->tpl->parse(sBlk,"STAT",true);
$this->tpl->set_var(totalMarketValue,$totMarketValue);
$this->tpl->set_var(totalAssessedValue,$totAssessedValue);
$this->tpl->set_var(totalBasic,$totBasic);
$this->tpl->set_var(totalSEF,$totSEF);
$this->tpl->set_var(totalTaxDue,$totTaxDue);
}
}
}
}*/
$this->setForm();
$this->tpl->set_var("Session", $this->sess->url(""));
$this->tpl->parse("templatePage", "rptsTemplate");
$this->tpl->finish("templatePage");
$this->tpl->p("templatePage");
}
function Main()
{
$this->formArray['currentDate'] = date("F d, Y");
$MunicipalityCityDetails = new SoapObject(NCCBIZ . "MunicipalityCityDetails.php", "urn:Object");
#test values
//$this->formArray['municipalityCityID']=1;
if (!($xmlStr = $MunicipalityCityDetails->getMunicipalityCityDetails($this->formArray['municipalityCityID']))) {
#echo($xmlStr);
exit("xml failed for municipality");
//header("Location: ".$this->sess->url("ViewSOA.php")."&status=2");
} else {
if (!($domDoc = domxml_open_mem($xmlStr))) {
echo "error xmlDoc";
} else {
$MunicipalityCity = new MunicipalityCity();
$MunicipalityCity->parseDomDocument($domDoc);
$this->formArray['municipality'] = $MunicipalityCity->getDescription();
}
}
if ($this->formArray['personID'] != "") {
$person = new Person();
$person->selectRecord($this->formArray['personID']);
$this->tpl->set_var(ownerName, $person->getFullName());
$this->tpl->set_var(ownerNo, $person->getTin());
$address = $person->addressArray[0];
if (is_object($address)) {
$this->tpl->set_var(ownerAddress, $address->getNumber() . " " . $address->getStreet() . " " . $address->getBarangay() . " " . $address->getDistrict() . " " . $address->getMunicipalitycity() . " " . $address->getProvince());
} else {
$this->tpl->set_var(ownerAddress, "");
}
$db = new DB_RPTS();
$sql = "SELECT rptopID FROM Owner inner join OwnerPerson on Owner.ownerID=OwnerPerson.ownerID WHERE Owner.rptopID <> '' AND OwnerPerson.personID=" . $this->formArray['personID'];
$db->query($sql);
} else {
$company = new Company();
$company->selectRecord($this->formArray['companyID']);
$this->tpl->set_var(ownerName, $company->getCompanyName());
$this->tpl->set_var(ownerNo, $company->getCompanyID());
$address = $company->addressArray[0];
$this->tpl->set_var(ownerAddress, $address->getNumber() . " " . $address->getStreet() . " " . $address->getBarangay() . " " . $address->getDistrict() . " " . $address->getMunicipalitycity() . " " . $address->getProvince());
$db = new DB_RPTS();
$sql = "SELECT rptopID FROM Owner inner join OwnerPerson on Owner.ownerID=OwnerPerson.ownerID WHERE Owner.rptopID <> '' AND OwnerPerson.personID=" . $this->formArray['companyID'];
$db->query($sql);
}
$ypos = 325;
$this->tpl->set_block("rptsTemplate", "ROW", "RowBlk");
for ($i = 0; $db->next_record(); $i++) {
$rptopID = $db->f("rptopID");
$RPTOPDetails = new SoapObject(NCCBIZ . "RPTOPDetails.php", "urn:Object");
if (!($xmlStr = $RPTOPDetails->getRPTOP($rptopID))) {
// exit("xml failed for RPTOP");
header("Location: " . $this->sess->url("ViewSOA.php") . "&status=1");
} else {
//echo $xmlStr;
if (!($domDoc = domxml_open_mem($xmlStr))) {
$this->tpl->set_block("rptsTemplate", "OwnerListTable", "OwnerListTableBlock");
$this->tpl->set_var("OwnerListTableBlock", "error xmlDoc");
} else {
$rptop = new RPTOP();
$td = new TD();
$rptop->parseDomDocument($domDoc);
foreach ($rptop as $key => $value) {
$this->formArray['payableYear'] = $rptop->getTaxableYear();
$rptopID = $rptop->getRptopID();
if ($key == "tdArray") {
$tdCtr = 0;
if (count($value)) {
foreach ($value as $tkey => $tvalue) {
$td->selectRecord($tvalue->getTdID());
$assessedValue = number_format($td->getAssessedValue(), 2, ".", "");
$propertyType = $td->getPropertyType();
$TaxDeclarationNumber = $td->getTaxDeclarationNumber();
$afsID = $td->getAfsID();
$afs = new AFS();
$afs->selectRecord($afsID);
$od = new OD();
$od->selectRecord($afs->getOdID());
$addr = $od->getLocationAddress();
if (count($addr)) {
$location = strtoupper($addr->getNumber() . " " . substr($addr->getBarangay(), 0, 4) . " " . substr($addr->getMunicipalityCity(), 0, 3) . " " . substr($addr->getProvince(), 0, 3));
$munCityID = $addr->getMunicipalityCityID();
}
if (count($afs->landArray)) {
foreach ($afs->landArray as $afsKey => $afsValue) {
$actualUse = $afsValue->getActualUse();
$landActualUses = new LandActualUses();
$landActualUses->selectRecord($actualUse);
$Code = $landActualUses->getCode();
}
}
if (count($afs->improvementsBuildingsArray)) {
foreach ($afs->improvementsBuildingsArray as $afsKey => $afsValue) {
$actualUse = $afsValue->getActualUse();
$improvementsBuildingsActualUses = new improvementsBuildingsActualUses();
$improvementsBuildingsActualUses->selectRecord($actualUse);
$Code = $improvementsBuildingsActualUses->getCode();
}
}
if ($munCityID == $this->formArray['municipalityCityID']) {
$this->tpl->set_var(location, $location);
$this->tpl->set_var("class", $Code);
$this->tpl->set_var(kind, strtoupper(substr($propertyType, 0, 4)));
$this->tpl->set_var(currentTDNo, $TaxDeclarationNumber);
$this->tpl->set_var(municipality, $addr->getMunicipalityCity());
//$dues = new Dues();
//$dues->create($td->getTdID(),"2003");
//$totTaxDue += $dues->getSEF()+$dues->getBasic();
$dues = new Dues($tvalue->getTdID(), $rptop->getTaxableYear(), $assessedValue);
$paymentPeriod = $dues->getPaymentMode();
$totalTaxDue = $dues->getPaidBasic($paymentPeriod) + $dues->getPaidSEF($paymentPeriod) + $dues->getPaidIdle($paymentPeriod);
if ($dues->getAmnesty()) {
$dues->setPctPenalty(0.0);
} else {
$totalTaxDue += $dues->getPenalty($paymentPeriod);
}
if ($dues->getIsDiscount()) {
$taxDue->setDiscount($totalTaxDue);
$totalTaxDue -= $dues->getDiscount();
}
$interest = $dues->getPctPenalty();
if ($interest > 0 && $paymentPeriod != "Annual") {
$paymentPeriod = "Annual";
}
$basic = number_format($dues->getPaidBasic(), "2", ".", "");
$this->tpl->set_var(basic, $basic);
$totBasic += $basic;
$sef = number_format($dues->getPaidSEF(), "2", ".", "");
$this->tpl->set_var(sef, $sef);
$totSEF += number_format($sef, "2", ".", "");
$this->tpl->set_var(total, number_format($sef + $basic, "2", ".", ""));
$this->tpl->set_var(marketValue, number_format($afs->getTotalMarketValue(), 2));
$totMarketValue += $afs->getTotalMarketValue();
$this->tpl->set_var(assessedValue, number_format($afs->getTotalAssessedValue(), 2));
$totAssessedValue += $afs->getTotalAssessedValue();
$pIndexNo = $afs->getPropertyIndexNumber();
if ($pIndexNo == "") {
$pIndexNo = "No value specified";
}
$ypos = $ypos - 10;
$this->tpl->set_var(ypos, $ypos);
$this->tpl->set_var(pin, $pIndexNo);
$this->tpl->parse("RowBlk", "ROW", true);
}
}
#end foreach($value)
}
#end if coun value
$this->tpl->set_var(totalMarketValue, number_format($totMarketValue, 2));
$this->tpl->set_var(totalAssessedValue, number_format($totAssessedValue, 2));
$this->tpl->set_var(totalBasic, number_format($totBasic, 2));
$this->tpl->set_var(totalSEF, number_format($totSEF, 2));
$this->tpl->set_var(totalTaxDue, number_format($totalTaxDue, 2));
}
}
}
}
}
$this->setForm();
$this->tpl->set_var("Session", $this->sess->url(""));
/* $this->tpl->parse("templatePage", "rptsTemplate");
$this->tpl->finish("templatePage");
$this->tpl->p("templatePage");
*/
$this->tpl->parse("templatePage", "rptsTemplate");
$this->tpl->finish("templatePage");
$rptrpdf = new PDFWriter();
$rptrpdf->setOutputXML($this->tpl->get('templatePage'), "string");
$rptrpdf->writePDF("viewSOA.pdf");
}
public static function printQueue(Pad $pad, $cprecode, $printserver, $memo)
{
$printer = Printer::model()->find('lid=:printerId and dpid=:dpid', array(':printerId' => $pad->printer_id, ':dpid' => $pad->dpid));
if (empty($printer)) {
return array('status' => 0, 'dpid' => $siteno->dpid, 'jobid' => "0", 'type' => 'none', 'msg' => yii::t('app', 'PAD还没有设置默认打印机'));
}
$listData = array("22" . Helper::setPrinterTitle(Company::getCompanyName($pad->dpid), 8));
if (!empty($memo)) {
array_push($listData, "br");
array_push($listData, "11" . $memo);
}
array_push($listData, "00");
array_push($listData, "br");
$precode = $cprecode;
//后面加切纸
$sufcode = "0A0A0A0A0A0A1D5601";
$printret = array();
$orderid = "0000000000";
$retccontent = Helper::printConetent($printer, $listData, $precode, $sufcode, $printserver, $orderid);
return $retccontent;
}
public static function act_getCompanyName($where = ' 1 ')
{
if (!Auth::checkAccess(__CLASS__, __FUNCTION__)) {
self::$errCode = '5905';
self::$errMsg = 'You have no access to get Company name';
echo json_encode(array('errCode' => self::$errCode, 'errMsg' => self::$errMsg));
return false;
}
$data = Company::getCompanyName($where);
if (!$data) {
self::$errCode = Company::$errCode;
self::$errMsg = Company::$errMsg;
echo json_encode(array('errCode' => self::$errCode, 'errMsg' => self::$errMsg));
return false;
}
return $data;
}
function Add_Company(Company $company)
{
$Company_Name = $company->getCompanyName();
$Company_Name_Amharic = $company->getCompanyNameAmharic();
$query = "INSERT INTO Company (Name,Name_Amharic,Registration_Date) VALUES ('{$Company_Name}','{$Company_Name_Amharic}', Now())";
$result = mysqli_query($this->getDbc(), $query);
if ($result) {
return TRUE;
} else {
return FALSE;
}
}
/**
* A custom method within the Plugin to generate the content
*
*/
function generatePaymentLogDetails()
{
$output = '';
$do_company = new Company();
$output .= '<div class="center_elem center_text">';
$button_payment = new DynamicButton();
$output .= $button_payment->CreateButton('#', 'receive payment', '', 'addPayment();return false;', 'dyn_button_receive_payment', 'width:138px;margin:0 auto;');
$output .= '</div><div class="spacerblock_20"></div>' . "\n";
if ($_SESSION['extra_amt'] != '') {
$cancel_payment = new Event("do_invoice->eventCancelMultiPayment");
$cancel_payment->setLevel(10);
$cancel_link = $cancel_payment->getLink(_('Cancel'));
$msg = '<div style="margin-left:0px;">';
$msg .= '<div class="messages_unauthorized">';
$msg .= _('Add payment ') . $_SESSION['do_invoice']->viewAmount($_SESSION['extra_amt']) . _(' with the Note: ') . '"' . $_SESSION['ref_num'] . '"' . _(' or with the amount you want.') . ' ' . $cancel_link;
$msg .= '</div></div>';
$output .= "\n" . '<div id="add_payment" style="display:block;">';
$output .= $msg;
} else {
/*$do_payment_invoice = new PaymentInvoice();
if($do_payment_invoice->getExtraAmoutNotPaid() !== false ){
$msg = '<div style="margin-left:0px;">';
$msg .= '<div class="messages_unauthorized">';
$msg .= _('You have some extra amount not yet applied to invoices, do you want to apply them now ? ');
$e_apply_extra_amt = new Event("do_invoice->eventSetApplyExtraAmount");
$apply_link = $e_apply_extra_amt->getLink(_('apply'));
$msg .='<br />'.$apply_link;
$msg .='</div></div>';
$output .= $msg ;
$output .= "\n".'<div id="add_payment" style="display:block;">';
}else{
$output .= "\n".'<div id="add_payment" style="display:none;">';
}*/
$output .= "\n" . '<div id="add_payment" style="display:none;">';
}
$e_add_pay = new Event("do_invoice->eventAddPayment");
$e_add_pay->setLevel(20);
$e_add_pay->addParam("goto", $_SERVER['PHP_SELF']);
$e_add_pay->addParam('id', $_SESSION['do_invoice']->idinvoice);
$output .= $e_add_pay->getFormHeader();
$output .= $e_add_pay->getFormEvent();
if ($_SESSION['extra_amt'] != '') {
$output .= _('Amount :') . ' <br /><input type="Text" name="payment_amt" id="payment_amt" value="' . $_SESSION['extra_amt'] . '"><br />';
} else {
$output .= _('Amount :') . ' <br /><input type="Text" name="payment_amt" id="payment_amt" value="' . $_SESSION['do_invoice']->amt_due . '"><br />';
$output .= _('Note :') . ' <br /><input type="Text" name="payment_ref_num" id="payment_ref_num" value=""><br />';
}
$output .= '<input type="submit" name="psubmit" value="' . _('Add Payment') . '">';
$output .= '</form>';
$output .= ' <br /><a href="#" onclick="hidePayment();return false;">' . _('No, I\'ll add later') . '</a><br /><br />';
$output .= "\n" . '</div>';
$do_inv_payment_log = new PaymentLog();
$do_inv_payment_log->getPaymentLog($_SESSION['do_invoice']->idinvoice);
while ($do_inv_payment_log->next()) {
$count = 0;
$e_del_log = new Event("PaymentLog->eventDeletePaymentLog");
$e_del_log->addParam("goto", $_SERVER['PHP_SELF']);
$e_del_log->addParam("id", $do_inv_payment_log->idpaymentlog);
$e_del_log->addParam("amt", $do_inv_payment_log->amount);
$output .= "\n" . '<div id="templt' . $count . '" class="co_worker_item co_worker_desc">';
$output .= "\n" . '<div style="position: relative;">';
$output .= "\n" . '<span class="text12"><span class="text_lightblue">' . $do_inv_payment_log->ref_num . '</span> <span class="sep1">|</span> <b>' . $_SESSION['do_invoice']->viewAmount($do_inv_payment_log->amount) . '</b><br />' . '<b>' . (isset($_SESSION['do_invoice']->idcompany) ? $do_company->getCompanyName($_SESSION['do_invoice']->idcompany) : $do_contact->getContactName($_SESSION['do_invoice']->idcontact)) . '</b><br />' . '<span class="text_darkgray">Received: ' . date('F j, Y', $do_inv_payment_log->timestamp) . '</span></span>';
$img_del = '<img class="delete_icon_tag" border="0" width="14px" height="14px" src="/images/delete.gif">';
$output .= "\n" . '<div width="15px" id="trashcan' . $count . '" class="deletenote" style="right:0;">' . $e_del_log->getLink($img_del, ' title="' . _('Remove') . '"') . '</div>';
$output .= "\n" . '</div></div>';
$output .= "\n" . '<div class="invoiceline12"></div>';
$count++;
}
$output .= "\n" . '</div>';
return $output;
}
