$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 <> ''";