static function DelNotification($id) {
if (is_numeric($id)) {
$DBHandle = DbConnect();
$table = new Table("cc_notification", "*");
$CLAUSE = " id = " . $id ;
$table->Delete_table($DBHandle, $CLAUSE);
$table = new Table("cc_notification_admin", "*");
$CLAUSE = " id_notification = " . $id ;
$table->Delete_table($DBHandle, $CLAUSE);
return true;
} else
return false;
}
/**
* Function did_use_delete
* @public
*/
static public function did_use_delete()
{
$FormHandler = FormHandler::GetInstance();
$processed = $FormHandler->getProcessed();
$did_id=$processed['id'];
$FG_TABLE_DID_USE_NAME = "cc_did_use";
$FG_TABLE_DID_USE_CLAUSE= "id_did = '".$did_id."' and releasedate IS NULL";
$FG_TABLE_DID_USE_PARAM= "releasedate = now()";
$instance_did_use_table = new Table($FG_TABLE_DID_USE_NAME);
$result_query= $instance_did_use_table -> Update_table ($FormHandler->DBHandle, $FG_TABLE_DID_USE_PARAM, $FG_TABLE_DID_USE_CLAUSE, null);
$FG_TABLE_DID_USE_NAME = "cc_did_destination";
$instance_did_use_table = new Table($FG_TABLE_DID_USE_NAME);
$FG_TABLE_DID_USE_CLAUSE= "id_cc_did = '".$did_id."'";
$result_query= $instance_did_use_table -> Delete_table ($FormHandler->DBHandle, $FG_TABLE_DID_USE_CLAUSE, null);
}
}
$HD_Form->setDBHandler(DbConnect());
$HD_Form->init();
if ($id != "" || !is_null($id)) {
$HD_Form->FG_EDITION_CLAUSE = str_replace("%id", "{$id}", $HD_Form->FG_EDITION_CLAUSE);
}
if (!isset($form_action)) {
$form_action = "list";
}
//ask-add
if (!isset($action)) {
$action = $form_action;
}
if ($form_action == "delete") {
$instance_table = new Table($HD_Form->FG_TABLE_NAME, null);
$res_delete = $instance_table->Delete_table($HD_Form->DBHandle, $HD_Form->FG_EDITION_CLAUSE, null);
if (!$res_delete) {
echo "error deletion";
} else {
unlink($path);
}
}
if ($form_action == "restore") {
$instance_table_backup = new Table($HD_Form->FG_TABLE_NAME, $HD_Form->FG_QUERY_EDITION);
$list = $instance_table_backup->Get_list($HD_Form->DBHandle, $HD_Form->FG_EDITION_CLAUSE, null, null, null, null, 1, 0);
$path = $list[0][1];
if (substr($path, -3) == '.gz') {
// WE NEED TO GZIP
$run_gzip = GUNZIP_EXE . " -c " . $path . " | ";
}
if (DB_TYPE != 'postgres') {
/**
* Function to del_content
* @public
*/
function perform_del_content($sub_action, $id)
{
$processed = $this->getProcessed();
$table_split = preg_split("/:/", $this->FG_TABLE_EDITION[$sub_action][14]);
if (array_key_exists($table_split[1] . '_hidden', $processed)) {
$value = trim($processed[$table_split[1] . '_hidden']);
} else {
$value = trim($processed[$table_split[1]]);
}
$instance_sub_table = new Table($table_split[0], $table_split[1] . ", " . $table_split[5]);
$SPLIT_FG_DELETE_CLAUSE = $table_split[1] . "='" . $value . "' AND " . $table_split[5] . "='" . trim($id) . "'";
$instance_sub_table->Delete_table($this->DBHandle, $SPLIT_FG_DELETE_CLAUSE, $func_table = null);
}
}
$param_update .= $sp . "{$fields_name}" . $sp . " = '" . addslashes(trim(${$fields_name})) . "'";
}
}
if ($FG_DEBUG == 1) {
echo "<br><hr> {$param_update}";
}
if ($VALID_SQL_REG_EXP) {
$instance_table->Update_table($DBHandle, $param_update, $FG_EDITION_CLAUSE, $func_table = null);
}
if ($VALID_SQL_REG_EXP && isset($FG_GO_LINK_AFTER_ACTION)) {
Header("Location: {$FG_GO_LINK_AFTER_ACTION}" . $id);
}
}
if ($form_action == "delete") {
$res_delete = $instance_table->Delete_table($DBHandle, $FG_EDITION_CLAUSE, $func_table = null);
if (!$res_delete) {
echo gettext("error deletion");
} else {
}
$FG_INTRO_TEXT_DELETION = str_replace("%id", "{$id}", $FG_INTRO_TEXT_DELETION);
$FG_INTRO_TEXT_DELETION = str_replace("%table", "{$FG_TABLE_NAME}", $FG_INTRO_TEXT_DELETION);
if (isset($FG_GO_LINK_AFTER_ACTION)) {
Header("Location: {$FG_GO_LINK_AFTER_ACTION_DELETE}" . $id);
}
}
if ($form_action == "edit" || $form_action == "ask-delete" || $form_action == "ask-edit" || $form_action == "add-content" || $form_action == "del-content") {
if ($FG_DEBUG >= 2) {
echo "FG_EDITION_CLAUSE:{$FG_EDITION_CLAUSE}";
}
$list = $instance_table->Get_list($DBHandle, $FG_EDITION_CLAUSE, null, null, null, null, 1, 0);
$values = " {$id} , {$addrate}";
$add_rate_table->Add_table($DBHandle, $values, $fields);
Header("Location: A2B_package_manage_rates.php?id={$id}");
}
if (isset($delrate) && is_numeric($delrate)) {
$DBHandle = DbConnect();
$del_rate_table = new Table("cc_package_rate", "*");
$CLAUSE = " package_id = " . $id . " AND rate_id = {$delrate}";
$del_rate_table->Delete_table($DBHandle, $CLAUSE);
Header("Location: A2B_package_manage_rates.php?id={$id}");
}
if (isset($delallrate) && $delallrate) {
$DBHandle = DbConnect();
$del_rate_table = new Table("cc_package_rate", "*");
$CLAUSE = " package_id = " . $id;
$del_rate_table->Delete_table($DBHandle, $CLAUSE);
Header("Location: A2B_package_manage_rates.php?id={$id}");
}
$smarty->display('main.tpl');
//load rates
$DBHandle = DbConnect();
$table_rates = new Table("cc_package_rate JOIN cc_ratecard ON cc_ratecard.id = cc_package_rate.rate_id LEFT JOIN cc_prefix ON cc_prefix.prefix = cc_ratecard.destination ", "DISTINCT cc_ratecard.id,cc_prefix.destination, cc_ratecard.dialprefix");
$rates_clauses = " cc_package_rate.package_id = {$id}";
$result_rates = $table_rates->Get_list(DbConnect(), $rates_clauses);
echo $CC_help_offer_package;
?>
<br/>
<SCRIPT LANGUAGE="javascript">
var win= null;
function addrate(selvalue)
****************************************************************************/
set_time_limit(0);
error_reporting(E_ALL ^ (E_NOTICE | E_WARNING));
include_once dirname(__FILE__) . "/../Class.Table.php";
include dirname(__FILE__) . "/../Class.A2Billing.php";
write_log(LOGFILE_CRONT_ARCHIVE_DATA, basename(__FILE__) . ' line:' . __LINE__ . "[#### ARCHIVING DATA BEGIN ####]");
if (!$A2B->DbConnect()) {
echo "[Cannot connect to the database]\n";
write_log(LOGFILE_CRONT_ARCHIVE_DATA, basename(__FILE__) . ' line:' . __LINE__ . "[Cannot connect to the database]");
exit;
}
$A2B = new A2Billing();
$A2B->load_conf($agi, NULL, 0, $idconfig);
$instance_table = new Table();
$from_month = $A2B->config["backup"]['archive_data_x_month'];
if ($A2B->config["database"]['dbtype'] == "postgres") {
$condition = "CURRENT_TIMESTAMP - interval '{$from_month} months' > starttime";
} else {
$condition = "DATE_SUB(NOW(),INTERVAL {$from_month} MONTH) > starttime";
}
$value = "SELECT sessionid,uniqueid,username,nasipaddress,starttime,stoptime,sessiontime,calledstation,startdelay,stopdelay,terminatecause,usertariff,calledprovider,calledcountry,calledsub,calledrate,sessionbill,destination,id_tariffgroup,id_tariffplan,id_ratecard,id_trunk,sipiax,src,id_did,buyrate,buycost,id_card_package_offer,real_sessiontime FROM cc_call where {$condition}";
$func_fields = "sessionid,uniqueid,username,nasipaddress,starttime,stoptime,sessiontime,calledstation,startdelay,stopdelay,terminatecause,usertariff,calledprovider,calledcountry,calledsub,calledrate,sessionbill,destination,id_tariffgroup,id_tariffplan,id_ratecard,id_trunk,sipiax,src,id_did,buyrate,buycost,id_card_package_offer,real_sessiontime";
$func_table = 'cc_call_archive';
$id_name = "";
$subquery = true;
$result = $instance_table->Add_table($A2B->DBHandle, $value, $func_fields, $func_table, $id_name, $subquery);
$fun_table = "cc_call";
$result = $instance_table->Delete_table($A2B->DBHandle, $condition, $fun_table);
write_log(LOGFILE_CRONT_ARCHIVE_DATA, basename(__FILE__) . ' line:' . __LINE__ . "[#### ARCHIVING DATA END ####]");
function archive_data($condition, $entity = "")
{
$handle = DbConnect();
$instance_table = new Table();
if (!empty($entity)) {
if ($entity == "card") {
$func_fields = "id, creationdate, firstusedate, expirationdate, enableexpire, expiredays, username, useralias, uipass, credit, tariff, id_didgroup, activated, status, lastname, firstname, address, city, state, country, zipcode, phone, email, fax, inuse, simultaccess, currency, lastuse, nbused, typepaid, creditlimit, voipcall, sip_buddy, iax_buddy, language, redial, runservice, nbservice, id_campaign, num_trials_done, vat, servicelastrun, initialbalance, invoiceday, autorefill, loginkey, mac_addr, id_timezone, tag, voicemail_permitted, voicemail_activated, last_notification, email_notification, notify_email, credit_notification, id_group, company_name, company_website, VAT_RN, traffic, traffic_target, discount, restriction";
$value = "SELECT {$func_fields} FROM cc_card {$condition}";
$func_table = 'cc_card_archive';
$id_name = "";
$subquery = true;
$result = $instance_table->Add_table($handle, $value, $func_fields, $func_table, $id_name, $subquery);
$fun_table = "cc_card";
if (strpos($condition, 'WHERE') > 0) {
$condition = str_replace("WHERE", "", $condition);
}
$result = $instance_table->Delete_table($handle, $condition, $fun_table);
} else {
if ($entity == "call") {
$value = "SELECT id, sessionid,uniqueid,card_id,nasipaddress,starttime,stoptime,sessiontime,calledstation,sessionbill,id_tariffgroup,id_tariffplan,id_ratecard,id_trunk,sipiax,src,id_did,buyrate,id_card_package_offer,real_sessiontime FROM cc_call {$condition}";
$func_fields = "id, sessionid,uniqueid,card_id,nasipaddress,starttime,stoptime,sessiontime,calledstation,sessionbill,id_tariffgroup,id_tariffplan,id_ratecard,id_trunk,sipiax,src,id_did,buyrate,id_card_package_offer,real_sessiontime";
$func_table = 'cc_call_archive';
$id_name = "";
$subquery = true;
$result = $instance_table->Add_table($handle, $value, $func_fields, $func_table, $id_name, $subquery);
if (strpos($condition, 'WHERE') > 0) {
$condition = str_replace("WHERE", "", $condition);
}
$fun_table = "cc_call";
$result = $instance_table->Delete_table($handle, $condition, $fun_table);
}
}
}
return 1;
}
function archive_data($condition, $entity = "")
{
if (empty($condition)) {
return 0;
exit;
}
$handle = DbConnect();
$instance_table = new Table();
if (!empty($entity)) {
if ($entity == "card") {
$value = "SELECT id, creationdate, firstusedate, expirationdate, enableexpire, expiredays, username, useralias, uipass, credit, tariff, id_didgroup, activated, status, lastname, firstname, address, city, state, country, zipcode, phone, email,fax, inuse, simultaccess, currency, lastuse,nbused, typepaid, creditlimit, voipcall, sip_buddy, iax_buddy, language, redial, runservice, nbservice, id_campaign, num_trials_done, callback, vat, servicelastrun, initialbalance, invoiceday,autorefill, loginkey, activatedbyuser, mac_addr, id_timezone, tag, template_invoice, template_outstanding FROM cc_card {$condition}";
$func_fields = "id, creationdate, firstusedate, expirationdate, enableexpire, expiredays, username, useralias, uipass, credit, tariff, id_didgroup, activated, status, lastname, firstname, address, city, state, country, zipcode, phone, email,fax, inuse, simultaccess, currency, lastuse,nbused, typepaid, creditlimit, voipcall, sip_buddy, iax_buddy, language, redial, runservice, nbservice, id_campaign, num_trials_done, callback, vat, servicelastrun, initialbalance, invoiceday,autorefill, loginkey, activatedbyuser, mac_addr, id_timezone, tag, template_invoice, template_outstanding";
$func_table = 'cc_card_archive';
$id_name = "";
$subquery = true;
$result = $instance_table->Add_table($handle, $value, $func_fields, $func_table, $id_name, $subquery);
$fun_table = "cc_card";
if (strpos($condition, 'WHERE') > 0) {
$condition = str_replace("WHERE", "", $condition);
}
$result = $instance_table->Delete_table($handle, $condition, $fun_table);
} else {
if ($entity == "call") {
$value = "SELECT id, sessionid,uniqueid,username,nasipaddress,starttime,stoptime,sessiontime,calledstation,startdelay,stopdelay,terminatecause,usertariff,calledprovider,calledcountry,calledsub,calledrate,sessionbill,destination,id_tariffgroup,id_tariffplan,id_ratecard,id_trunk,sipiax,src,id_did,buyrate,buycost,id_card_package_offer,real_sessiontime FROM cc_call {$condition}";
$func_fields = "id, sessionid,uniqueid,username,nasipaddress,starttime,stoptime,sessiontime,calledstation,startdelay,stopdelay,terminatecause,usertariff,calledprovider,calledcountry,calledsub,calledrate,sessionbill,destination,id_tariffgroup,id_tariffplan,id_ratecard,id_trunk,sipiax,src,id_did,buyrate,buycost,id_card_package_offer,real_sessiontime";
$func_table = 'cc_call_archive';
$id_name = "";
$subquery = true;
$result = $instance_table->Add_table($handle, $value, $func_fields, $func_table, $id_name, $subquery);
if (strpos($condition, 'WHERE') > 0) {
$condition = str_replace("WHERE", "", $condition);
}
$fun_table = "cc_call";
$result = $instance_table->Delete_table($handle, $condition, $fun_table);
}
}
}
return 1;
}
function Remove_Card($security_key, $transaction_code, $account_number, $cardnumber)
{
// The wrapper variables for security
// $security_key = API_SECURITY_KEY;
$logfile = SOAP_LOGFILE;
$mysecurity_key = API_SECURITY_KEY;
$mail_content = "[" . date("Y/m/d G:i:s", mktime()) . "] " . "SOAP API - Request asked: Remove_Card [{$transaction_code}, {$account_number}, {$cardnumber}]";
// CHECK SECURITY KEY
if (md5($mysecurity_key) !== $security_key || strlen($security_key) == 0) {
a2b_mail(EMAIL_ADMIN, "ALARM : API - CODE_ERROR SECURITY_KEY ", $mail_content);
error_log("[" . date("Y/m/d G:i:s", mktime()) . "] " . " CODE_ERROR SECURITY_KEY" . "\n", 3, $logfile);
sleep(2);
return array($transaction_code, '', '', '', '', 'Error', 'KEY - BAD PARAMETER' . "{$security_key} - {$mysecurity_key}");
}
// Create new account
$FG_TABLE = "cc_card";
$DBHandle = DbConnect();
$instance_sub_table = new Table($FG_TABLE);
$FG_EDITION_CLAUSE = " username = '******' ";
$res_delete = $instance_sub_table->Delete_table($DBHandle, $FG_EDITION_CLAUSE);
if (!$res_delete) {
return array($transaction_code, $account_number, $cardnumber, 'result=ERROR', 'Cannot remove this cardnumber');
} else {
return array($transaction_code, $account_number, $cardnumber, 'result=OK', '');
}
}
function delete_agi_confx($agi_conf)
{
if (empty($handle)) {
$handle = DbConnect();
}
$instance_table = new Table();
$clause = "group_title = '{$agi_conf}'";
$fun_table = "cc_config_group";
$result = $instance_table->Delete_table($handle, $clause, $fun_table);
$clause = "config_group_title = '{$agi_conf}'";
$fun_table = "cc_config";
$result = $instance_table->Delete_table($handle, $clause, $fun_table);
return $result;
}
else $result_param ="faild";
header("Location: A2B_agent_home.php?" . "id=" . $id . "&result=$result_param");
die();
}
header("Location: A2B_agent_home.php?" . "id=" . $id . "&result=faild");
die();
break;
case 'delete' :
if(is_numeric($id_msg)){
$DBHandle = DbConnect();
$instance_table = new Table("cc_message_agent","*");
$clause = "id = $id_msg";
$result=$instance_table -> Get_list($DBHandle, $clause);
if(is_array($result) && sizeof($result)>0){
$order = $result[0]['order_display'];
$instance_table -> Delete_table($DBHandle, $clause);
$instance_table->Update_table($DBHandle, "order_display = order_display - 1", "id_agent = '".$id."' AND order_display >".$order);
echo "true";
die();
}
echo "false";
die();
}
echo "false";
die();
break;
case 'up' :
if(is_numeric($id_msg)){
$DBHandle = DbConnect();
$clause = "id = $id_msg";
$instance_table = new Table("cc_message_agent","*");
public function delPayment($idpayment)
{
if (!is_null($this->id)) {
$DBHandle = DbConnect();
$instance_sub_table = new Table("cc_invoice_payment", "*");
$CLAUSE = " id_invoice = " . $this->id . " AND id_payment = {$idpayment}";
$result = null;
$instance_sub_table->Delete_table($DBHandle, $CLAUSE);
} else {
return null;
}
}