<?php// Common includesinclude ("../lib/defines.php");include ("../lib/module.access.php");//include ("../lib/Class.Table.php");include ("../lib/smarty.php");set_time_limit(0);if (! has_rights (ACX_CUSTOMER)){	   Header ("HTTP/1.0 401 Unauthorized");	   Header ("Location: PP_error.php?c=accessdenied");	   die();}$FG_DEBUG = 0;$DBHandle  = DbConnect();$my_max_file_size = (int) MY_MAX_FILE_SIZE_IMPORT;/*************************************************************/	$smarty->display('main.tpl');?><script type="text/javascript"><!--function MM_openBrWindow(theURL,winName,features) { //v2.0  window.open(theURL,winName,features);}//--></script><script language="JavaScript"><!--function sendtofield(form){	if (form.listemail.value.length < 5){		alert ('<?php echo gettext("Insert emails on the Field!")?>');		form.listemail.focus ();		return (false);	}    document.forms["prefs"].elements["task"].value = "field";	document.forms[0].submit();}function sendtoupload(form){	if (form.the_file.value.length < 2){		alert ('<?php echo gettext("Please, you must first select a file !")?>');		form.the_file.focus ();		return (false);	}    document.forms["prefs"].elements["task"].value = "upload";	document.prefs.action='CC_card_import_analyse.php';	document.prefs.submit();}//--></script><script language="JavaScript" type="text/javascript"><!--function deselectHeaders(){    document.prefs.unselected_search_sources[0].selected = false;    document.prefs.selected_search_sources[0].selected = false;}function resetHidden(){    var tmp = '';    for (i = 1; i < document.prefs.selected_search_sources.length; i++) {        tmp += document.prefs.selected_search_sources[i].value;        if (i < document.prefs.selected_search_sources.length - 1)            tmp += "\t";    }    document.prefs.search_sources.value = tmp;}function addSource(){    for (i = 1; i < document.prefs.unselected_search_sources.length; i++) {        if (document.prefs.unselected_search_sources[i].selected) {            document.prefs.selected_search_sources[document.prefs.selected_search_sources.length] = new Option(document.prefs.unselected_search_sources[i].text, document.prefs.unselected_search_sources[i].value);            document.prefs.unselected_search_sources[i] = null;            i--;        }    }    resetHidden();}function removeSource(){    for (i = 1; i < document.prefs.selected_search_sources.length; i++) {        if (document.prefs.selected_search_sources[i].selected) {            document.prefs.unselected_search_sources[document.prefs.unselected_search_sources.length] = new Option(document.prefs.selected_search_sources[i].text, document.prefs.selected_search_sources[i].value)            document.prefs.selected_search_sources[i] = null;            i--;        }    }    resetHidden();}function moveSourceUp(){    var sel = document.prefs.selected_search_sources.selectedIndex;	//var sel = document.prefs["selected_search_sources[]"].selectedIndex;    if (sel == -1 || document.prefs.selected_search_sources.length <= 2) return;    // deselect everything but the first selected item    document.prefs.selected_search_sources.selectedIndex = sel;    if (sel == 1) {        tmp = document.prefs.selected_search_sources[sel];        document.prefs.selected_search_sources[sel] = null;        document.prefs.selected_search_sources[document.prefs.selected_search_sources.length] = tmp;        document.prefs.selected_search_sources.selectedIndex = document.prefs.selected_search_sources.length - 1;    } else {        tmp = new Array();        for (i = 1; i < document.prefs.selected_search_sources.length; i++) {            tmp[i - 1] = new Option(document.prefs.selected_search_sources[i].text, document.prefs.selected_search_sources[i].value)        }        for (i = 0; i < tmp.length; i++) {            if (i + 1 == sel - 1) {                document.prefs.selected_search_sources[i + 1] = tmp[i + 1];            } else if (i + 1 == sel) {                document.prefs.selected_search_sources[i + 1] = tmp[i - 1];            } else {                document.prefs.selected_search_sources[i + 1] = tmp[i];            }        }        document.prefs.selected_search_sources.selectedIndex = sel - 1;    }    resetHidden();}function moveSourceDown(){    var sel = document.prefs.selected_search_sources.selectedIndex;    if (sel == -1 || document.prefs.selected_search_sources.length <= 2) return;    // deselect everything but the first selected item    document.prefs.selected_search_sources.selectedIndex = sel;    if (sel == document.prefs.selected_search_sources.length - 1) {        tmp = new Array();        for (i = 1; i < document.prefs.selected_search_sources.length; i++) {            tmp[i - 1] = new Option(document.prefs.selected_search_sources[i].text, document.prefs.selected_search_sources[i].value)        }        document.prefs.selected_search_sources[1] = tmp[tmp.length - 1];        for (i = 0; i < tmp.length - 1; i++) {            document.prefs.selected_search_sources[i + 2] = tmp[i];        }        document.prefs.selected_search_sources.selectedIndex = 1;    } else {        tmp = new Array();        for (i = 1; i < document.prefs.selected_search_sources.length; i++) {            tmp[i - 1] = new Option(document.prefs.selected_search_sources[i].text, document.prefs.selected_search_sources[i].value)        }        for (i = 0; i < tmp.length; i++) {            if (i + 1 == sel) {                document.prefs.selected_search_sources[i + 1] = tmp[i + 1];            } else if (i + 1 == sel + 1) {                document.prefs.selected_search_sources[i + 1] = tmp[i - 1];            } else {                document.prefs.selected_search_sources[i + 1] = tmp[i];            }        }        document.prefs.selected_search_sources.selectedIndex = sel + 1;    }    resetHidden();}// --></script>     	  <?php	echo $CC_help_import_card;?><center>		<b><?php echo gettext("New Cards have to be imported from a CSV file.");?>.</b></br></br>		<table width="95%" border="0" cellspacing="2" align="center" class="records">              <form name="prefs" enctype="multipart/form-data"  method="post">				<tr>                  <td colspan="2" align=center>				<?php echo gettext("These fields are mandatory");?><br><select  name="bydefault" multiple="multiple" size="4" width="40" class="form_input_select">	<option value="bb1"><?php echo gettext("username");?></option>	<option value="bb2"><?php echo gettext("useralias");?></option>    <option value="bb3"><?php echo gettext("userpass");?></option>    <option value="bb4"><?php echo gettext("uipass");?></option>    <option value="bb5"><?php echo gettext("credit");?></option>    <option value="bb6"><?php echo gettext("lastname");?></option>    <option value="bb7"><?php echo gettext("firstname");?></option>    <option value="bb7"><?php echo gettext("activated");?></option></select><br/><br/><?php echo gettext("Choose the additional fields to import from the CSV file");?>.<br><input name="search_sources" value="nochange" type="hidden"><table>    <tbody><tr>        <td>            <select name="unselected_search_sources" multiple="multiple" size="9" width="50" onchange="deselectHeaders()" class="form_input_select">				<option value=""><?php echo gettext("Unselected Fields...");?></option>				<option value="creationdate"><?php echo gettext("creationdate");?></option>				<option value="firstusedate"><?php echo gettext("firstusedate");?></option>				<option value="expirationdate"><?php echo gettext("expirationdate");?></option>				<option value="enableexpire"><?php echo gettext("enableexpire");?></option>				<option value="expiredays"><?php echo gettext("expiredays");?></option>				<option value="tariff"><?php echo gettext("tariff");?></option>				<option value="id_didgroup"><?php echo gettext("id_didgroup");?></option>				<option value="address"><?php echo gettext("address");?></option>                <option value="city"><?php echo gettext("city");?></option>                <option value="state"><?php echo gettext("state");?></option>                <option value="country"><?php echo gettext("country");?></option>                <option value="zipcode"><?php echo gettext("zipcode");?></option>                <option value="phone"><?php echo gettext("phone");?></option>                <option value="email"><?php echo gettext("email");?></option>                <option value="fax"><?php echo gettext("fax");?></option>                <option value="inuse"><?php echo gettext("inuse");?></option>                <option value="simultaccess"><?php echo gettext("simultaccess");?></option>                <option value="currency"><?php echo gettext("currency");?></option>                <option value="lastuse"><?php echo gettext("lastuse");?></option>                <option value="nbused"><?php echo gettext("nbused");?></option>                <option value="typepaid"><?php echo gettext("typepaid");?></option>                <option value="creditlimit"><?php echo gettext("creditlimit");?></option>                <option value="voipcall"><?php echo gettext("voipcall");?></option>                <option value="sip_buddy"><?php echo gettext("sip_buddy");?></option>                <option value="iax_buddy"><?php echo gettext("iax_buddy");?></option>                <option value="language"><?php echo gettext("language");?></option>                <option value="redial"><?php echo gettext("redial");?></option>                <option value="nbservice"><?php echo gettext("nbservice");?></option>                <option value="id_campaign"><?php echo gettext("id_campaign");?></option>                <option value="num_trials_done"><?php echo gettext("num_trials_done");?></option>                <option value="callback"><?php echo gettext("callback");?></option>                <option value="vat"><?php echo gettext("vat");?></option>                <option value="servicelastrun"><?php echo gettext("servicelastrun");?></option>                <option value="initialbalance"><?php echo gettext("initialbalance");?></option>                <option value="invoiceday"><?php echo gettext("invoiceday");?></option>                <option value="autorefill"><?php echo gettext("autorefill");?></option>                <option value="loginkey"><?php echo gettext("loginkey");?></option>	down_black			</select>        </td>        <td>            <a href="" onclick="addSource(); return false;"><img src="<?php echo Images_Path;?>/forward.png" alt="add source" title="add source" border="0"></a>            <br>            <a href="" onclick="removeSource(); return false;"><img src="<?php echo Images_Path;?>/back.png" alt="remove source" title="remove source" border="0"></a>        </td>        <td>            <select name="selected_search_sources" multiple="multiple" size="9" width="50" onchange="deselectHeaders();" class="form_input_select">				<option value=""><?php echo gettext("Selected Fields...");?></option>			</select>        </td>        <td>            <a href="" onclick="moveSourceUp(); return false;"><img src="<?php echo Images_Path;?>/up_black.png" alt="move up" title="move up" border="0"></a>            <br>            <a href="" onclick="moveSourceDown(); return false;"><img src="<?php echo Images_Path;?>/down_black.png" alt="move down" title="move down" border="0"></a>        </td>    </tr></tbody></table>				</td></tr>                <tr>                  <td colspan="2">                    <div align="center"><span class="textcomment">					  <?php echo gettext("Use the example below  to format the CSV file. Fields are separated by  ; : or ?");?></br>					  <?php echo gettext(". and , are used for decimal format.");?>					  <br/>					  <a href="importsamples.php?sample=Card_Complex" target="superframe"><?php echo gettext("Complex Sample");?></a> -					  <a href="importsamples.php?sample=Card_Simple" target="superframe"> <?php echo gettext("Simple Sample");?></a>                      </span></div>						<center>							<iframe name="superframe" src="importsamples.php?sample=Card_Simple" BGCOLOR=white	width=500 height=80 marginWidth=10 marginHeight=10  frameBorder=1  scrolling=yes>							</iframe>						</center>                  </td>                </tr>                <tr>                  <td colspan="2">                    <p align="center"><span class="textcomment">                      <?php echo gettext("The maximum file size is ");?>                      <?php echo $my_max_file_size / 1024?>                      KB </span><br>                      <input type="hidden" name="MAX_FILE_SIZE" value="<?php echo $my_max_file_size?>">                      <input type="hidden" name="task" value="upload">                      <input name="the_file" type="file" size="50" onFocus=this.select() class="saisie1">                      <input type="button"  value="Import CARD's" onFocus=this.select() class="form_input_button" name="submit1" onClick="sendtoupload(this.form);">                      <br>                      &nbsp; </p>                  </td>                </tr>                <tr>                  <td class="bgcolor_014" colspan="2"><b>                    <?php echo $translate[P34_9]?>                    </b></td>                </tr>              </form>            </table></center><?php	$smarty->display('footer.tpl');?>