function deleteTaxFee($nature_code, $tax_fee_code)
{
if ($nature_code) {
$strWhere[EBPLS_BUSINESS_NATURE_NATURE_CODE] = $nature_code;
}
$strValues[EBPLS_BUSINESS_NATURE_TAXFEES_TAX_FEE_CODE] = $tax_fee_code;
ebpls_delete_data($this->m_dbLink, EBPLS_BUSINESS_NATURE_TAXFEES_TABLE, $strWhere);
}
function delete($economic_org_id)
{
$strWhere[ECONOMIC_ORG_ID] = $economic_org_id;
$strValues[] = "count(*) as cnt";
$result = ebpls_delete_data($this->m_dbLink, EBPLS_ECONOMIC_ORGANIZATION_TABLE, $strWhere);
if ($result < 0) {
$this->setError($result, get_db_error());
}
return $result;
}
function delete($owner_id)
{
$strWhere[OWNER_ID] = $owner_id;
$strValues[] = "count(*) as cnt";
// check if owner have existing transactions
$result = ebpls_select_data($this->m_dbLink, EBPLS_TRANSACTION_TABLE, $strValues, $strWhere, NULL, NULL, NULL, NULL);
if (is_array($result) && $result[0]["cnt"] > 0) {
$this->debug("DELETE OWNER FAILED, OWNER HAVE AN EXISTING TRANSACTION");
return -1;
} else {
if ($result < 0) {
$this->debug("DELETE OWNER FAILED [error:{$ret},msg=" . get_db_error() . "]");
return -1;
}
}
$result = ebpls_delete_data($this->m_dbLink, EBPLS_OCC_PERMIT_TABLE, $strWhere);
if ($result < 0) {
$this->setError($result, get_db_error());
}
return $result;
}
function delete($code = NULL)
{
if ($code) {
$strWhere[EBPLS_TAX_FEE_CODE] = $code;
} else {
$strWhere[EBPLS_TAX_FEE_CODE] = $this->data_elems[EBPLS_TAX_FEE_CODE];
}
// let the InnoDB foreign keys do the validation of usage - 8/30/2004 1:47AM - stephen
// check if fee code is being used, if currently being used then terminate delete command
$strColumns[EBPLS_TAX_FEE_CODE] = "*";
$result1 = ebpls_select_data($this->m_dbLink, EBPLS_PDR_FEE_TABLE_REF, $strColumns, $strWhere);
$result2 = ebpls_select_data($this->m_dbLink, EBPLS_PDR_TAX_TABLE_REF, $strColumns, $strWhere);
$result3 = ebpls_select_data($this->m_dbLink, EBPLS_PAYABLES_REF, $strColumns, $strWhere);
if (is_array($result1) || is_array($result2) || is_array($result3)) {
$this->setError(-1, "Tax/Fee Code already in use, can't delete.");
return -1;
}
$result = ebpls_delete_data($this->m_dbLink, EBPLS_TAX_FEE_TABLE, $strWhere);
if ($result < 0) {
$this->setError($result, get_db_error());
}
return $result;
}
function delete($formula_id)
{
if ($formula_id) {
$strWhere[EBPLS_FORMULAS_FORMULA_ID] = $formula_id;
} else {
$strWhere[EBPLS_FORMULAS_FORMULA_ID] = $this->data_elems[EBPLS_FORMULAS_FORMULA_ID];
}
$result = ebpls_delete_data($this->m_dbLink, EBPLS_FORMULAS_TABLE, $strWhere);
if ($result < 0) {
$this->setError($result, get_db_error());
}
return $result;
}
function _delete($trans_id, $tax_fee_code, $nature_code, $admin, $user_level)
{
$strWhere[TF_TRANS_ID] = $trans_id;
$strWhere[TF_TAX_FEE_CODE] = $tax_fee_code;
$strWhere[TF_TAX_BUSINESS_NATURE_CODE] = $nature_code;
$result = ebpls_delete_data($this->m_dbLink, TF_TABLE, $strWhere);
if ($result < 0) {
$this->setError($result, get_db_error());
}
return $result;
}
function delete($veh_id)
{
$strWhere[EBPLS_MOTORIZED_VEH_MOTOR_ID] = $veh_id;
$result = ebpls_delete_data($this->m_dbLink, EBPLS_MOTORIZED_VEHICLES_TABLE, $strWhere);
if ($result < 0) {
$this->setError($result, get_db_error());
}
return $result;
}
function delete($bAll = false)
{
$strWhere[NATURE_BUSINESS_ID] = $this->business_id;
if (!$bAll) {
$strWhere[NATURE_BUSINESS_NATURE_CODE] = $this->getData(NATURE_BUSINESS_NATURE_CODE);
}
$result = ebpls_delete_data($this->m_dbLink, NATURE_BUSINESS_TABLE, $strWhere);
if ($result < 0) {
$this->setError($result, get_db_error());
}
return $result;
}
function delete($temp_id)
{
$strWhere[TEMP_ID] = $temp_id;
$strValues[] = "count(*) as cnt";
$result = ebpls_delete_data($this->m_dbLink, EBPLS_ZIP_TABLE, $strWhere);
if ($result < 0) {
$this->setError($result, get_db_error());
}
return $result;
}
function delete($owner_id)
{
$strWhere[INDUSTRY_SECTOR_CODE] = $owner_id;
$strValues[] = "count(*) as cnt";
$result = ebpls_delete_data($this->m_dbLink, EBPLS_INDUSTRY_SECTOR_TABLE, $strWhere);
if ($result < 0) {
$this->setError($result, get_db_error());
}
return $result;
}
/**
* Used on update payment, delete only those payment schedules which has no amount paid
*
*
**/
function _deleteINTERNAL(&$trans_obj, $fee_id, $payment_status)
{
$strWhere[TPS_TRANS_ID] = $trans_obj->getData(TRANS_ID);
$strWhere[TPS_FEE_ID] = $fee_id;
$strWhere[TPS_PAYMENT_STATUS] = $payment_status;
$strWhere[TPS_PAYMENT_AMOUNT_PAID] = array(" = ", 0.0);
$result = ebpls_delete_data($this->m_dbLink, TPS_TABLE, $strWhere);
if ($result < 0) {
$this->setError($result, get_db_error());
}
return $result;
}
function delete($owner_id)
{
$strWhere[CIT_ID] = $owner_id;
$strValues[] = "count(*) as cnt";
// check if owner have existing transactions
$result = ebpls_delete_data($this->m_dbLink, EBPLS_CTC_INTEREST_TABLE, $strWhere);
if ($result < 0) {
$this->setError($result, get_db_error());
}
return $result;
}
function delete($code)
{
$strWhere[$this->m_strCodeKey] = $code;
$result = ebpls_delete_data($this->m_dbLink, $this->m_strTableKey, $strWhere);
if ($result < 0) {
$this->setError($result, get_db_error());
}
return $result;
}
function delete($id = NULL)
{
// check if fee code is being used, if currently being used then terminate delete command
if ($id) {
$strWhere[$this->m_strPrimaryKey] = $id;
} else {
$strWhere[$this->m_strPrimaryKey] = $this->data_elems[$this->m_strPrimaryKey];
}
$result = ebpls_delete_data($this->m_dbLink, $this->m_strTable, $strWhere);
if ($result < 0) {
$this->setError($result, get_db_error());
}
return $result;
}
function delete($owner_id)
{
$strWhere[OCCUPANCY_TYPE_CODE] = $owner_id;
//$strValues[] = "count(*) as cnt";
$result = ebpls_delete_data($this->m_dbLink, EBPLS_OCCUPANCY_TYPE_TABLE, $strWhere);
if ($result < 0) {
$this->setError($result, get_db_error());
}
return $result;
}
function delete($code = NULL)
{
// check if fee code is being used, if currently being used then terminate delete command
if ($code) {
$strWhere[EBPLS_ACCT_CODE] = $code;
} else {
$strWhere[EBPLS_ACCT_CODE] = $this->data_elems[EBPLS_ACCT_CODE];
}
$result = ebpls_delete_data($this->m_dbLink, EBPLS_COT_TABLE, $strWhere);
if ($result < 0) {
$this->setError($result, get_db_error());
}
return $result;
}
function delete($economic_area_id)
{
$strWhere[ECONOMIC_AREA_ID] = $economic_area_id;
$strValues[] = "count(*) as cnt";
// check if owner have existing transactions
$result = ebpls_delete_data($this->m_dbLink, EBPLS_ECONOMIC_TABLE, $strWhere);
if ($result < 0) {
$this->setError($result, get_db_error());
}
return $result;
}
function delete()
{
$strWhere[TR_TRANS_ID] = $this->getData(TR_TRANS_ID);
$strWhere[TR_REQUIREMENT_CODE] = $this->getData(TR_REQUIREMENT_CODE);
$result = ebpls_delete_data($this->m_dbLink, TR_TABLE, $strWhere);
if ($result < 0) {
$this->setError($result, get_db_error());
}
return $result;
}
function delete($sign_id)
{
$strWhere[SIGN_ID] = $sign_id;
$strValues[] = "count(*) as cnt";
// check if owner have existing transactions
$result = ebpls_delete_data($this->m_dbLink, EBPLS_SIGNATORIES_TABLE, $strWhere);
if ($result < 0) {
$this->setError($result, get_db_error());
}
return $result;
}
function delete($zip_code)
{
$strWhere[ZIP_CODE] = $zip_code;
$strValues[] = "count(*) as cnt";
// check if owner have existing transactions
$result = ebpls_delete_data($this->m_dbLink, EBPLS_ZIP_TABLE, $strWhere);
if ($result < 0) {
$this->setError($result, get_db_error());
}
return $result;
}
function delete($trans_id, $nature_code)
{
$strWhere[TRANS_BUSNATURE_TRANS_ID] = $trans_id;
$strWhere[TRANS_BUSNATURE_BUSINESS_NATURE_CODE] = $nature_code;
$ret = ebpls_delete_data($this->m_dbLink, TRANS_BUSNATURE_TABLE, $strWhere);
return $ret;
}
