function printBusinessPermit(&$transObj, $additional_info = NULL)
 {
     $permit_type = $transObj->getPermitType();
     $permit = $transObj->getPermit();
     $owner = $transObj->getOwnerInfo();
     $clsBus = new EBPLSEnterprise($this->m_dbLink, false);
     $clsBus->view($transObj->getData(TRANS_BUSINESS_ID));
     // header
     $header_template = $this->m_strTemplatesPath . "bus/header.html";
     // footer
     $footer_template = $this->m_strTemplatesPath . "bus/footer.html";
     // body
     // item 1 -> onwer info
     $infoPath = $this->m_strTemplatesPath . "bus/business_info.html";
     $strContent = constructTemplate($infoPath, $owner->getData());
     // item 2 -> business info
     $strContent = constructTemplate($strContent, $clsBus->getData(), false);
     // item 3 -> line of business
     $strLOBTemplatePath = $this->m_strTemplatesPath . "bus/line_of_business_record.html";
     $arrLOB = $transObj->getLineOfBusiness();
     for ($i = 0; $i < count($arrLOB); $i++) {
         $arrLOB[$i]->data_elems[TRANS_BUSNATURE_CAPITAL_INVESTMENT] = number_format($arrLOB[$i]->getData(TRANS_BUSNATURE_CAPITAL_INVESTMENT), 2);
         $arrLOB[$i]->data_elems[TRANS_BUSNATURE_LAST_GROSS] = number_format($arrLOB[$i]->getData(TRANS_BUSNATURE_LAST_GROSS), 2);
         $tmpRec = constructTemplate($strLOBTemplatePath, $arrLOB[$i]->getData()) . "\n";
         $arrLOBRec[] = $tmpRec;
     }
     // ctc info
     // payables taxes/fees
     $strFeesTemplatePath = $this->m_strTemplatesPath . "bus/fees_record.html";
     $arrFees = $transObj->getFeesList();
     $total_fees = 0;
     for ($i = 0; $i < count($arrFees); $i++) {
         $total_fees += $arrFees[$i]->getData(TF_TAX_TOTAL_AMOUNT_DUE);
         $arrFees[$i]->data_elems[TF_TAX_TOTAL_AMOUNT_DUE] = number_format($arrFees[$i]->getData(TF_TAX_TOTAL_AMOUNT_DUE), 2);
         $tmpRec = constructTemplate($strFeesTemplatePath, $arrFees[$i]->getData()) . "\n";
         $arrFeesData[] = $tmpRec;
     }
     // create template header
     $strHeader = constructTemplate($header_template, $additional_info);
     // create template footer
     $strFooter = constructTemplate($footer_template, $additional_info);
     $strContent = str_replace("[REPORTS_HEADER]", $strHeader, $strContent);
     $strContent = str_replace("[REPORTS_FOOTER]", $strFooter, $strContent);
     $strContent = str_replace("[RECORDS_LOB]", join("\n", $arrLOBRec), $strContent);
     $strContent = str_replace("[RECORDS_FEES]", join("\n", $arrFeesData), $strContent);
     $strContent = str_replace("[TOTAL_FEES]", number_format($total_fees, 2), $strContent);
     echo $strContent;
 }
 /**
  * Adds new occ permit application, creates an instance of EBPLSTransaction class, accessible using getTransaction of EBPLSPermit class.
  * Instance of EBPLSTransaction class identifies the Permit application status and requirements status in the system.
  *
  */
 function newApplication($creator, $user_level)
 {
     if ($this->m_dbLink) {
         $clsOwner = new EBPLSOwner($this->m_dbLink);
         unset($this->data_elems[BE_BUSINESS_PERMIT_ID]);
         $owner_id = $this->data_elems[BE_OWNER_ID];
         if ($clsOwner->view($owner_id) <= 0) {
             $this->debug("Onwer with owner id {$owner_id} not found.");
             return -1;
         }
         // check business id
         $bus_id = $this->data_elems[BE_BUSINESS_ID];
         $clsEnterprise = new EBPLSEnterprise($this->m_dbLink);
         $ret = $clsEnterprise->view($bus_id);
         if ($ret < 0) {
             $this->debug("Business with bus id {$bus_id} not found.");
             return -1;
         }
         $owner_id = $this->data_elems[BE_OWNER_ID];
         if ($clsOwner->view($owner_id) <= 0) {
             $this->debug("Onwer with owner id {$owner_id} not found.");
             return -1;
         }
         $this->setOwner($clsOwner);
         if (($error_num = $this->validateData()) > 0) {
             // create reg ts
             $ts = time();
             $nYear = date("Y", $ts);
             $dt = date("Y-m-d H:i:s", $ts);
             $this->data_elems[BE_APPLICATION_DATE] = $dt;
             $this->data_elems[BE_FOR_YEAR] = $nYear;
             $this->setPermitRegistrationDates($dt, $dt, $nYear);
             $strValues = $this->data_elems;
             // create permit
             $ret = ebpls_insert_data($this->m_dbLink, EBPLS_BUSINESS_PERMIT_TABLE, $strValues);
             if ($ret < 0) {
                 $this->debug("CREATE BUS PERMIT FAILED [error:{$ret},msg=" . get_db_error() . "]");
                 $this->setError($ret, get_db_error());
             } else {
                 $this->debug("CREAT BUS OK {$ret}");
                 $this->data_elems[BE_BUSINESS_PERMIT_ID] = $ret;
                 $this->m_strPermitNo = $ret;
                 $this->m_strPermitType = PERMIT_TYPE_BUSINESS;
             }
             return $ret;
         } else {
             $this->debug("CREATE BUS PERMIT FAILED [error:{$ret},msg=" . get_db_error() . "]");
             return $error_num;
         }
     } else {
         $this->debug("CREATE BUS FAILED INVALID DB LINK {$this->m_dbLink}");
         $this->setError($ret, "Invalid Db link {$this->m_dbLink}");
         return -1;
     }
 }
 /**
  *
  *
  **/
 function update($bus_id, $admin, $user_level)
 {
     $bus_id = $bus_id == NULL ? $this->getData(BUSINESS_ID) : $bus_id;
     $this->data_elems[BUSINESS_ID] = $bus_id;
     if (!is_numeric($bus_id) || $bus_id == NULL || $bus_id == "" || $bus_id <= 0) {
         $this->debug("Update failed, invalid business id value = {$bus_id}.");
         return -2;
     }
     $clsTmp = new EBPLSEnterprise($this->m_dbLink, $this->m_bDebug);
     if ($clsTmp->view($bus_id) < 0) {
         $this->debug("Update failed, business with id '{$bus_id}' not found.");
         return -1;
     }
     if ($this->m_arrBusinessNatureDelete != NULL) {
         $this->debug("UPDATE BUS ENTERPRISE DELETE Nature");
         for ($i = 0; $i < count($this->m_arrBusinessNatureDelete); $i++) {
             $clsENature = new EBPLSEnterpriseNature($this->m_dbLink, $this, $this->m_bDebug);
             $clsENature->setData(NATURE_BUSINESS_NATURE_CODE, $this->m_arrBusinessNatureDelete[$i]);
             $clsENature->delete();
         }
     } else {
         $this->debug("UPDATE BUS ENTERPRISE DELETE Nature NOT EXECUTED");
     }
     if ($this->m_arrBusinessNatureUpdate != NULL) {
         $this->debug("UPDATE BUS ENTERPRISE UPDATE Nature");
         for ($i = 0; $i < count($this->m_arrBusinessNatureUpdate); $i++) {
             $clsENature = $this->m_arrBusinessNatureUpdate[$i];
             $clsENature->update();
         }
     } else {
         $this->debug("UPDATE BUS ENTERPRISE UPDATE Nature NOT EXECUTED");
     }
     if ($this->m_arrBusinessNatureAdd != NULL) {
         $this->debug("UPDATE BUS ENTERPRISE ADD Nature");
         for ($i = 0; $i < count($this->m_arrBusinessNatureAdd); $i++) {
             $clsNature = $this->m_arrBusinessNatureAdd[$i];
             $clsNature->setData(NATURE_BUSINESS_ID, $bus_id);
             $clsNature->add($admin);
         }
     } else {
         $this->debug("UPDATE BUS ENTERPRISE ADD Nature NOT EXECUTED");
     }
     // exclude those not changed
     $arrData = $this->getData();
     foreach ($arrData as $key => $value) {
         if ($arrData[$key] != NULL) {
             // remove keys using index number, bug on view method on this class
             if (!is_numeric($key)) {
                 $strValues[$key] = $value;
             }
         }
     }
     if (($error_num = $this->validateData(true)) > 0) {
         $strWhere[BUSINESS_ID] = $bus_id;
         $ret = ebpls_update_data($this->m_dbLink, EBPLS_BUSINESS_TABLE, $strValues, $strWhere);
         if ($ret < 0) {
             $this->setError($ret, get_db_error());
             $this->debug("UPDATE BUS ENTERPRISE FAILED [error:{$ret},msg=" . get_db_error() . "]");
             return $ret;
         } else {
             $this->debug("UPDATE BUSINESS ENTERPRISE SUCCESSFULL [{$ret}]");
             return $ret;
         }
     } else {
         $this->debug("UPDATE BUSINESS ENTERPRISE FAILED [error:{$ret},msg=" . get_db_error() . "]");
         return -1;
     }
 }
Exemple #4
0
        $HTTP_POST_VARS["ctc_first_name"] = $clsOwner->getData(OWNER_FIRST_NAME);
        $HTTP_POST_VARS["ctc_middle_name"] = $clsOwner->getData(OWNER_MIDDLE_NAME);
        $HTTP_POST_VARS["ctc_last_name"] = $clsOwner->getData(OWNER_LAST_NAME);
        $HTTP_POST_VARS["ctc_tin_no"] = $clsOwner->getData(OWNER_TIN_NO);
        $HTTP_POST_VARS["ctc_birth_date"] = $clsOwner->getData(OWNER_BIRTH_DATE);
        $HTTP_POST_VARS["ctc_civil_status"] = strtoupper($clsOwner->getData(OWNER_CIVIL_STATUS));
        $HTTP_POST_VARS["ctc_citizenship"] = $clsOwner->getData(OWNER_CITIZENSHIP);
        $HTTP_POST_VARS["ctc_gender"] = $clsOwner->getData(OWNER_GENDER);
        $HTTP_POST_VARS["ctc_address"] = $clsOwner->getData(OWNER_HOUSE_NO) . " " . $clsOwner->getData(OWNER_STREET);
        //$HTTP_POST_VARS["ctc_icr_no"] = $clsOwner->getData(OWNER_ICR_NO);
        $HTTP_POST_VARS["ctc_owner_id"] = $clsOwner->getData(OWNER_ID);
        $ctc_type = "INDIVIDUAL";
        if (intval($ctc_business_id)) {
            $ctc_type = "BUSINESS";
            // load business enterprise info
            $clsBus = new EBPLSEnterprise($dbLink);
            $clsBus->view($ctc_business_id);
            $HTTP_POST_VARS["ctc_company"] = $clsBus->getData(BUSINESS_NAME);
            $HTTP_POST_VARS["ctc_tin_no"] = $clsBus->getData(BUSINESS_TIN_REG_NO);
            $HTTP_POST_VARS["ctc_place_of_incorporation"] = $clsBus->getData(BUSINESS_TIN_REG_NO);
            $HTTP_POST_VARS["ctc_company_address "] = $clsBus->getData(BUSINESS_LOT_NO) . " " . $clsBus->getData(BUSINESS_STREET);
            $HTTP_POST_VARS["ctc_place_issued"] = $clsBus->getData(BUSINESS_TIN_REG_NO);
            $HTTP_POST_VARS["ctc_date_issued"] = $clsBus->getData(BUSINESS_DATE_ESTABLISHED);
            $HTTP_POST_VARS["ctc_business_id"] = $clsBus->getData(BUSINESS_ID);
        }
    }
}
?>
<div align="CENTER">
<!---// start of the table //-->
<table border=0 cellspacing=0 cellpadding=0 width='100%'>
Exemple #5
0
$permit_type = trim($permit_type);
$permit_no = trim($permit_no);
$owner_id = trim($owner_id);
$method_of_application = trim($method_of_application);
$is_new = true;
//--- check first the method method_of_application NEW
$submit_button_name = 'S U B M I T';
if (!strcasecmp($child_reload, 'reload')) {
    //log_err("refresh");
    //--- get the owner
    $clsOwner = new EBPLSOwner($dbLink, $debug);
    $clsOwner->view(trim($child_reload_owner_id));
    $owner_datarow = $clsOwner->getData();
    //--- get the business name
    if (strlen(trim($child_reload_permit_no)) > 0) {
        $clsEnterprise = new EBPLSEnterprise($dbLink, $debug);
        $permit_id = $clsEnterprise->view(trim($child_reload_permit_no));
        $datarow = $clsEnterprise->getData();
        //--- get the business_nature_list
        $business_nature_list = $clsEnterprise->getBusinessNatureList($datarow[BUSINESS_ID]);
    }
}
//--- chk the sublevels
/*if(   ! is_valid_sublevels(27) or ! is_valid_sublevels(28) )
 {
 	setUrlRedirect('index.php?part=999');
	
 } 
*/
?>
<link rel="stylesheet" href="stylesheets/default.css" type="text/css"/>
 function setTransactionStatus($trans_id, $status, $creator, $user_level)
 {
     switch ($status) {
         case TRANS_STATUS_ASSESSMENT:
             if ($user_level != TRANS_LEVEL_APPLICATION_OFFICER && $user_level != TRANS_LEVEL_ADMIN_OFFICER && $user_level != TRANS_LEVEL_ROOT_OFFICER) {
                 $this->debug("setTransactionStatus Failed, user level {$user_level} of {$admin} is not allowed.");
                 $this->setError(-1, "setTransactionStatus Failed, user level {$user_level} of {$admin} is not allowed.");
                 return -1;
             }
             if (!is_numeric($this->getData(TRANS_ID))) {
                 $this->debug("setTransactionStatus Failed, transaction not loaded, load by invoking loadTransaction.");
                 $this->setError(-1, "setTransactionStatus Failed, transaction not loaded, load by invoking loadTransaction.");
                 return -1;
             }
             if ($this->getData(TRANS_TRANSACTION_STATUS) != TRANS_STATUS_APPLICATION) {
                 $this->debug("setTransactionStatus Failed, transaction status already " . $this->getData(TRANS_TRANSACTION_STATUS));
                 $this->setError(-1, "setTransactionStatus Failed, transaction status already " . $this->getData(TRANS_TRANSACTION_STATUS));
                 return -1;
             }
             // NOTE : additional checking should be done here if all requirements have been submitted
             $pen_req_list = $this->getRequirementList(REQUIREMENT_STATUS_PENDING);
             //print_r($pen_req_list);
             if ($pen_req_list != -1 && count($pen_req_list) > 0) {
                 $this->debug("setTransactionStatus Failed, pending requirements not yet submitted.");
                 $this->setError(-1, "setTransactionStatus Failed, pending requirements not yet submitted.");
                 return -1;
             }
             ebpls_start_transaction($this->m_dbLink);
             $ass_code = get_next_system_code($this->m_dbLink, CODES_ASS_COL);
             $strWhere[TRANS_ID] = $trans_id;
             $strValue[TRANS_TRANSACTION_STATUS] = TRANS_STATUS_ASSESSMENT;
             $strValue[TRANS_ASSESSMENT_CODE] = $ass_code;
             $strValue[TRANS_ASSESSMENT_DATE] = date("Y-m-d H:i:s");
             $strValue[TRANS_APPLICATION_DATE_PROCESSED] = date("Y-m-d H:i:s");
             $strValue[TRANS_ADMIN_USER] = $creator;
             $ret = ebpls_update_data($this->m_dbLink, EBPLS_TRANSACTION_TABLE, $strValue, $strWhere);
             if ($ret < 0) {
                 $this->debug("Promotion of transaction to ASSESSMENT stage failed.");
                 $this->setError(-1, get_db_error());
                 ebpls_rollback_transaction($this->m_dbLink);
             } else {
                 $this->debug("Promotion of transaction to ASSESSMENT stage ok.");
                 $ret_app_code = update_system_code($this->m_dbLink, CODES_ASS_COL, $ass_code);
             }
             ebpls_commit_transaction($this->m_dbLink);
             break;
         case TRANS_STATUS_PAYMENT:
             if ($user_level != TRANS_LEVEL_ASSESSMENT_OFFICER && $user_level != TRANS_LEVEL_ADMIN_OFFICER && $user_level != TRANS_LEVEL_ROOT_OFFICER) {
                 $this->debug("assessTransaction Failed, user level {$user_level} of {$admin} is not allowed.");
                 $this->setError(-1, "assessTransaction Failed, user level {$user_level} of {$admin} is not allowed.");
                 return -1;
             }
             if (!is_numeric($this->getData(TRANS_ID))) {
                 $this->debug("assessTransaction Failed, transaction not loaded, load by invoking loadTransaction.");
                 $this->setError(-1, "assessTransaction Failed, transaction not loaded, load by invoking loadTransaction.");
                 return -1;
             }
             if ($this->getData(TRANS_TRANSACTION_STATUS) != TRANS_STATUS_ASSESSMENT) {
                 $this->debug("assessTransaction Failed, transaction status already " . $this->getData(TRANS_TRANSACTION_STATUS));
                 $this->setError(-1, "assessTransaction Failed, transaction status already " . $this->getData(TRANS_TRANSACTION_STATUS));
                 return -1;
             }
             // NOTE : check if payment mode have beens set
             if (!$this->isPaymentModeSet()) {
                 $this->setError(-1, "Payment not yet set, please set payment mode before setting transaction for payment status.");
                 return -1;
             }
             ebpls_start_transaction($this->m_dbLink);
             $pay_code = get_next_system_code($this->m_dbLink, CODES_PAY_COL);
             $strWhere[TRANS_ID] = $trans_id;
             $strValue[TRANS_TRANSACTION_STATUS] = TRANS_STATUS_PAYMENT;
             $strValue[TRANS_PAYMENT_CODE] = $pay_code;
             $strValue[TRANS_PAYMENT_DATE] = date("Y-m-d H:i:s");
             $strValue[TRANS_ASSESSMENT_DATE_PROCESSED] = date("Y-m-d H:i:s");
             $strValue[TRANS_ADMIN_USER] = $creator;
             $ret = ebpls_update_data($this->m_dbLink, EBPLS_TRANSACTION_TABLE, $strValue, $strWhere);
             if ($ret < 0) {
                 $this->debug("Promotion of transaction to ASSESSMENT stage failed.");
                 $this->setError(-1, get_db_error());
                 ebpls_rollback_transaction($this->m_dbLink);
             } else {
                 $this->debug("Promotion of transaction to ASSESSMENT stage ok.");
                 $ret_app_code = update_system_code($this->m_dbLink, CODES_PAY_COL, $pay_code);
             }
             ebpls_commit_transaction($this->m_dbLink);
             break;
         case TRANS_STATUS_APPROVAL:
             if ($user_level != TRANS_LEVEL_PAYMENT_OFFICER && $user_level != TRANS_LEVEL_ADMIN_OFFICER && $user_level != TRANS_LEVEL_ROOT_OFFICER) {
                 $this->debug("paymentTransaction Failed, user level {$user_level} of {$admin} is not allowed.");
                 $this->setError(-1, "paymentTransaction Failed, user level {$user_level} of {$admin} is not allowed.");
                 return -1;
             }
             if (!is_numeric($this->getData(TRANS_ID))) {
                 $this->debug("paymentTransaction Failed, transaction not loaded, load by invoking loadTransaction.");
                 $this->setError(-1, "paymentTransaction Failed, transaction not loaded, load by invoking loadTransaction.");
                 return -1;
             }
             if ($this->getData(TRANS_TRANSACTION_STATUS) != TRANS_STATUS_PAYMENT) {
                 $this->debug("paymentTransaction Failed, transaction status already " . $this->getData(TRANS_TRANSACTION_STATUS));
                 $this->setError(-1, "paymentTransaction Failed, transaction status already " . $this->getData(TRANS_TRANSACTION_STATUS));
                 return -1;
             }
             //
             ebpls_start_transaction($this->m_dbLink);
             $apr_code = get_next_system_code($this->m_dbLink, CODES_APR_COL);
             $strWhere[TRANS_ID] = $trans_id;
             $strValue[TRANS_TRANSACTION_STATUS] = TRANS_STATUS_APPROVAL;
             $strValue[TRANS_APPROVAL_CODE] = $apr_code;
             $strValue[TRANS_APPROVAL_DATE] = date("Y-m-d H:i:s");
             $strValue[TRANS_PAYMENT_DATE_PROCESSED] = date("Y-m-d H:i:s");
             $strValue[TRANS_ADMIN_USER] = $creator;
             $ret = ebpls_update_data($this->m_dbLink, EBPLS_TRANSACTION_TABLE, $strValue, $strWhere);
             if ($ret < 0) {
                 $this->debug("Promotion of transaction to ASSESSMENT stage failed.");
                 $this->setError(-1, get_db_error());
                 ebpls_rollback_transaction($this->m_dbLink);
             } else {
                 $this->debug("Promotion of transaction to ASSESSMENT stage ok.");
                 $ret_app_code = update_system_code($this->m_dbLink, CODES_APR_COL, $apr_code);
             }
             ebpls_commit_transaction($this->m_dbLink);
             break;
         case TRANS_STATUS_RELEASING:
             if ($user_level != TRANS_LEVEL_APPROVAL_OFFICER && $user_level != TRANS_LEVEL_ADMIN_OFFICER && $user_level != TRANS_LEVEL_ROOT_OFFICER) {
                 $this->debug("approveTransaction Failed, user level {$user_level} of {$admin} is not allowed.");
                 $this->setError(-1, "approveTransaction Failed, user level {$user_level} of {$admin} is not allowed.");
                 return -1;
             }
             if (!is_numeric($this->getData(TRANS_ID))) {
                 $this->debug("approveTransaction Failed, transaction not loaded, load by invoking loadTransaction.");
                 $this->setError(-1, "approveTransaction Failed, transaction not loaded, load by invoking loadTransaction.");
                 return -1;
             }
             if ($this->getData(TRANS_TRANSACTION_STATUS) != TRANS_STATUS_APPROVAL) {
                 $this->debug("setStatusForReleasing Failed, transaction status already " . $this->getData(TRANS_TRANSACTION_STATUS));
                 $this->setError(-1, "setStatusForReleasing Failed, transaction status already " . $this->getData(TRANS_TRANSACTION_STATUS));
                 return -1;
             }
             ebpls_start_transaction($this->m_dbLink);
             $rel_code = get_next_system_code($this->m_dbLink, CODES_REL_COL);
             $strWhere[TRANS_ID] = $trans_id;
             $strValue[TRANS_TRANSACTION_STATUS] = TRANS_STATUS_RELEASING;
             $strValue[TRANS_RELEASE_CODE] = $rel_code;
             $strValue[TRANS_RELEASE_DATE] = date("Y-m-d H:i:s");
             $strValue[TRANS_APPROVAL_DATE_PROCESSED] = date("Y-m-d H:i:s");
             $strValue[TRANS_ADMIN_USER] = $creator;
             $ret = ebpls_update_data($this->m_dbLink, EBPLS_TRANSACTION_TABLE, $strValue, $strWhere);
             if ($ret < 0) {
                 $this->debug("Promotion of transaction to ASSESSMENT stage failed.");
                 $this->setError(-1, get_db_error());
                 ebpls_rollback_transaction($this->m_dbLink);
             } else {
                 $this->debug("Promotion of transaction to ASSESSMENT stage ok.");
                 $ret_app_code = update_system_code($this->m_dbLink, CODES_REL_COL, $rel_code);
             }
             ebpls_commit_transaction($this->m_dbLink);
             break;
         case TRANS_STATUS_RELEASED:
         case TRANS_STATUS_REJECTED:
             if ($user_level != TRANS_LEVEL_RELEASING_OFFICER && $user_level != TRANS_LEVEL_ADMIN_OFFICER && $user_level != TRANS_LEVEL_ROOT_OFFICER) {
                 $this->debug("releaseTransaction Failed, user level {$user_level} of {$admin} is not allowed.");
                 $this->setError(-1, "releaseTransaction Failed, user level {$user_level} of {$admin} is not allowed.");
                 return -1;
             }
             if (!is_numeric($this->getData(TRANS_ID))) {
                 $this->debug("releaseTransaction Failed, transaction not loaded, load by invoking loadTransaction.");
                 $this->setError(-1, "releaseTransaction Failed, transaction not loaded, load by invoking loadTransaction.");
                 return -1;
             }
             if ($this->getData(TRANS_TRANSACTION_STATUS) != TRANS_STATUS_RELEASING) {
                 $this->debug("releaseTransaction Failed, transaction status already " . $this->getData(TRANS_TRANSACTION_STATUS));
                 $this->setError(-1, "releaseTransaction Failed, transaction status already " . $this->getData(TRANS_TRANSACTION_STATUS));
                 return -1;
             }
             // get permit no
             $permit_type = $this->getPermitType();
             $permit_id = $this->getPermitId();
             switch ($permit_type) {
                 case PERMIT_TYPE_BUSINESS:
                     $key = CODES_PERMIT_BUS_COL;
                     break;
                 case PERMIT_TYPE_OCCUPATIONAL:
                     $key = CODES_PERMIT_OCCUPATIONAL_COL;
                     break;
                 case PERMIT_TYPE_PEDDLER:
                     $key = CODES_PERMIT_PEDDLER_COL;
                     break;
                 case PERMIT_TYPE_FRANCHISE:
                     $key = CODES_PERMIT_FRANCHISE_BUS_COL;
                     break;
                 case PERMIT_TYPE_MOTORIZED:
                     $key = CODES_PERMIT_MOTORIZED_COL;
                     break;
                 case PERMIT_TYPE_FISHERY:
                     $key = CODES_PERMIT_FISHERY_COL;
                     break;
                 default:
                     $this->debug("Invalid Transaction permit type {$permit_type}, can't process release of transaction.");
                     return -1;
                     break;
             }
             ebpls_start_transaction($this->m_dbLink);
             $strWhere[TRANS_ID] = $trans_id;
             $strValue[TRANS_TRANSACTION_STATUS] = $status;
             $strValue[TRANS_RELEASE_DATE_PROCESSED] = date("Y-m-d H:i:s");
             $strValue[TRANS_ADMIN_USER] = $creator;
             if ($status == TRANS_STATUS_RELEASED && ($this->getData(TRANS_TYPE) == TRANS_TYPE_NEW || $this->getData(TRANS_TYPE) == TRANS_TYPE_RENEW)) {
                 $permit_code = get_next_system_code($this->m_dbLink, $key);
                 $strValue[TRANS_PERMIT_CODE] = $permit_code;
             }
             // use ebplsPermit as a factory class to retrieve proper class reference with the right type
             // of EBPLSPermit subclass
             $clsPermit = new EBPLSPermit($this->m_dbLink, false);
             $clsPermitToUpdate = $clsPermit->createPermit($this->m_dbLink, $permit_id, $permit_type, false);
             if ($clsPermitToUpdate != null) {
                 // update transaction with permit code of permit
                 $ret = ebpls_update_data($this->m_dbLink, EBPLS_TRANSACTION_TABLE, $strValue, $strWhere);
                 if ($ret < 0) {
                     $this->debug("Promotion of transaction to {$status} stage failed.");
                     $this->setError(-1, get_db_error());
                     ebpls_rollback_transaction($this->m_dbLink);
                 } else {
                     // update permit of table
                     $clsPermitToUpdate->assignPermitCode($permit_code);
                     if ($status == TRANS_STATUS_RELEASED && ($this->getData(TRANS_TYPE) == TRANS_TYPE_NEW || $this->getData(TRANS_TYPE) == TRANS_TYPE_RENEW)) {
                         $ret_app_code = update_system_code($this->m_dbLink, $key, $permit_code);
                     }
                     $this->debug("Promotion of transaction to {$status} stage ok.");
                 }
                 // set permit status
                 if ($permit_type == PERMIT_TYPE_BUSINESS) {
                     $clsBus = new EBPLSEnterprise($this->m_dbLink);
                     $clsBus->_updateBusinessNatureApplication($nature_code, NULL, NULL, NULL, "PROCESSED");
                 }
                 ebpls_commit_transaction($this->m_dbLink);
             } else {
                 $this->debug("Promotion of transaction to {$status} stage failed, unable to create class permit to assigne permit code.");
                 ebpls_rollback_transaction($this->m_dbLink);
             }
             break;
         default:
             $this->debug("Unrecognized status {$status} value passed.");
             break;
     }
     $this->data_elem[TRANS_TRANSACTION_STATUS] = $status;
     return $ret;
 }