$reset_table = "update cc_ratecard set is_merged = 0";
$result_reset = $instance_table->SQLExec($HD_Form->DBHandle, $reset_table);
if ($count > 0) {
$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');
?>
foreach ($currencies_list as $key => $cur_value) {
$currency_list_r[$key] = array($key, $cur_value[1]);
}
$simultaccess_list_r = array();
$simultaccess_list_r["0"] = array("0", gettext("INDIVIDUAL ACCESS"));
$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";
