cc_card_import.php

来自「asterisk用 的voip记费软件」· PHP 代码 · 共 349 行

<?php
// Common includes
include ("../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');
?>