$msg = "Ratecard is successfully merged.";
} else {
$msg = "Ratecard is not merged, please try again with different search criteria.";
}
}
$_SESSION['search_ratecard'] = "";
}
$HD_Form->FG_FILTER_SEARCH_FORM = true;
$HD_Form->FG_FILTER_SEARCH_TOP_TEXT = gettext("Define the search criteria");
$HD_Form->FG_FILTER_SEARCH_1_TIME_TEXT = gettext("Start Date / Month");
$HD_Form->FG_FILTER_SEARCH_2_TIME_TEXT = gettext("Start Date / Day");
$HD_Form->FG_FILTER_SEARCH_2_TIME_FIELD = 'startdate';
$HD_Form->AddSearchElement_C1(gettext("TAG"), 'tag', 'tagtype');
$HD_Form->AddSearchElement_C1(gettext("DESTINATION"), 'destination', 'destinationtype');
$HD_Form->AddSearchElement_C1(gettext("PREFIX"), 'dialprefix', 'dialprefixtype');
$HD_Form->AddSearchElement_C2(gettext("BUYRATE"), 'buyrate1', 'buyrate1type', 'buyrate2', 'buyrate2type', 'buyrate');
$HD_Form->AddSearchElement_C2(gettext("RATE INITIAL"), 'rateinitial1', 'rateinitial1type', 'rateinitial2', 'rateinitial2type', 'rateinitial');
$HD_Form->prepare_list_subselection('list');
$HD_Form->FG_FILTER_SEARCH_FORM_SELECT_TEXT = 'TRUNK';
$HD_Form->AddSearchElement_Select('SELECT TRUNK', "cc_trunk", "id_trunk, trunkcode, providerip", "", "trunkcode", "ASC", "id_trunk");
$_SESSION['search_ratecard'] = $HD_Form->FG_TABLE_CLAUSE;
/*************************************************************/
$instance_table_tariffname = new Table("cc_tariffplan", "id, tariffname");
$con = "";
$list_tariffname = $instance_table_tariffname->Get_list($HD_Form->DBHandle, $con, "tariffname", "ASC", null, null, null, null);
$nb_tariffname = count($list_tariffname);
$smarty->display('main.tpl');
?>
<script language="JavaScript" type="text/javascript">
<!--
function deselectHeaders()
$simultaccess_list_r["1"] = array("1", gettext("SIMULTANEOUS ACCESS"));
$language_list_r = array();
$language_list_r["0"] = array("en", gettext("ENGLISH"));
$language_list_r["1"] = array("es", gettext("SPANISH"));
$language_list_r["2"] = array("fr", gettext("FRENCH"));
$HD_Form->FG_FILTER_SEARCH_FORM = true;
$HD_Form->FG_FILTER_SEARCH_TOP_TEXT = gettext('Define specific criteria to search for cards created.');
$HD_Form->FG_FILTER_SEARCH_1_TIME_TEXT = gettext('Creation date / Month');
$HD_Form->FG_FILTER_SEARCH_2_TIME_TEXT = gettext('Creation date / Day');
$HD_Form->FG_FILTER_SEARCH_2_TIME_FIELD = 'creationdate';
$HD_Form->AddSearchElement_C1(gettext("ACCOUNT NUMBER"), 'username', 'usernametype');
$HD_Form->AddSearchElement_C1(gettext("LASTNAME"), 'lastname', 'lastnametype');
$HD_Form->AddSearchElement_C1(gettext("LOGIN"), 'useralias', 'useraliastype');
$HD_Form->AddSearchElement_C1(gettext("MACADDRESS"), 'mac_addr', 'macaddresstype');
$HD_Form->AddSearchElement_C1(gettext("EMAIL"), 'email', 'emailtype');
$HD_Form->AddSearchElement_C2(gettext("CUSTOMER ID (SERIAL)"), 'id1', 'id1type', 'id2', 'id2type', 'id');
$HD_Form->AddSearchElement_C2(gettext("CREDIT"), 'credit1', 'credit1type', 'credit2', 'credit2type', 'credit');
$HD_Form->AddSearchElement_C2(gettext("INUSE"), 'inuse1', 'inuse1type', 'inuse2', 'inuse2type', 'inuse');
$HD_Form->FG_FILTER_SEARCH_FORM_SELECT_TEXT = '';
$HD_Form->AddSearchElement_Select(gettext("SELECT LANGUAGE"), null, null, null, null, null, "language", 0, $language_list_r);
$HD_Form->AddSearchElement_Select(gettext("SELECT TARIFF"), "cc_tariffgroup", "id, tariffgroupname, id", "", "tariffgroupname", "ASC", "tariff");
$HD_Form->AddSearchElement_Select(gettext("SELECT STATUS"), null, null, null, null, null, "status", 0, $cardstatus_list_r);
$HD_Form->AddSearchElement_Select(gettext("SELECT ACCESS"), null, null, null, null, null, "simultaccess", 0, $simultaccess_list_r);
$HD_Form->AddSearchElement_Select(gettext("SELECT CURRENCY"), null, null, null, null, null, "currency", 0, $currency_list_r);
$HD_Form->prepare_list_subselection('list');
$HD_Form->FG_TABLE_ID = "id";
$HD_Form->FG_TABLE_DEFAULT_SENS = "ASC";
$nb_customer = 0;
$limit_massmail = 2000;
if (!empty($HD_Form->FG_TABLE_CLAUSE)) {
$HD_Form->FG_TABLE_CLAUSE .= " AND email <> ''";
