cc_card_import_analyse.php

asterisk用 的voip记费软件

<?php
// Common includes
include ("../lib/defines.php");
include ("../lib/module.access.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();
}

getpost_ifset(array('search_sources', 'task', 'status','uploadedfile_name'));

if ($search_sources!='nochange'){

	//echo "<br>---$search_sources";
	$fieldtoimport= split("\t", $search_sources);
	$fieldtoimport_sql = str_replace("\t", ", ", $search_sources);
	$fieldtoimport_sql = trim ($fieldtoimport_sql);
	if (strlen($fieldtoimport_sql)>0) $fieldtoimport_sql = ', '.$fieldtoimport_sql;
}

	 $field[0]="username";
	 $field[1]="useralias";
     $field[2]="userpass";
     $field[3]="uipass";
     $field[4]="credit";
     $field[5]="lastname";
     $field[6]="firstname";
     $field[7]="activated";

$FG_DEBUG = 0;

if (DB_TYPE == "mysql"){
	$sp = "`";
}

// THIS VARIABLE DEFINE THE COLOR OF THE HEAD TABLE
$FG_TABLE_ALTERNATE_ROW_COLOR[] = "#FFFFFF";
$FG_TABLE_ALTERNATE_ROW_COLOR[] = "#F2F8FF";


$Temps1 = time();


if ($FG_DEBUG == 1) echo "::::>> ".$the_file;


//INUTILE
$my_max_file_size = (int) MY_MAX_FILE_SIZE_IMPORT;


if ($FG_DEBUG == 1) echo "<br> Task :: $task";

if ($task=='upload'){

	//---------------------------------------------------------
	//		 Effacer tout les fichiers du repertoire cache.
	//---------------------------------------------------------

	$the_file_name = $_FILES['the_file']['name'];
	$the_file_type = $_FILES['the_file']['type'];
	$the_file = $_FILES['the_file']['tmp_name'];

	if(count($_FILES) > 0)
	{
		$errortext = validate_upload($the_file, $the_file_type);	
		if ($errortext != "" || $errortext  != false)	
		{
			echo $errortext;
			exit;
		}
		$new_filename = "/tmp/".MDP(6).".csv";
		if (file_exists($new_filename))
		{
			echo $_FILES["file"]["name"] . " already exists. ";
		}
		else
		{
			if(!move_uploaded_file($_FILES["the_file"]["tmp_name"],	$new_filename))
			{
			    echo gettext("File Save Failed, FILE=".$new_filename);
			}
		}
		$the_file = $new_filename;
	}
	else
	{		
		$the_file_type = $uploadedfile_type;
		$the_file = $uploadedfile_name;
	}

	if ($FG_DEBUG == 1) echo "<br> FILE  ::> ".$the_file_name;
	if ($FG_DEBUG == 1) echo "<br> THE_FILE:$the_file <br>THE_FILE_TYPE:$the_file_type";

	 $fp = fopen($the_file,  "r");
	 if (!$fp){  /* THE FILE DOESN'T EXIST */
		 echo  gettext('THE FILE DOESNOT EXIST');
		 exit();
	 }

	 $chaine1 = '"\'';

 	$nb_imported=0;
	$nb_to_import=0;
	$DBHandle  = DbConnect();
    $find_createdate = 0 ;

	while (!feof($fp)){

			 //if ($nb_imported==1000) break;
             $ligneoriginal = fgets($fp,4096);  /* On se d茅place d'une ligne */
             if($ligneoriginal == "")
             {
                 break;
             }
			 $ligneoriginal = trim ($ligneoriginal);
			 $ligneoriginal = strtolower($ligneoriginal);


			 for ($i = 0; $i < strlen($chaine1); $i++)
					$ligne = str_replace($chaine1[$i], ' ', $ligneoriginal);

			 $ligne = str_replace(',', '.', $ligne);
			 $val= split(';', $ligne);
			 $val[0]=str_replace('"', '', $val[0]); //DH
			 $val[1]=str_replace('"', '', $val[1]); //DH
             $val[2]=str_replace('"', '', $val[2]); //DH
			 $val[0]=str_replace("'", '', $val[0]); //DH
			 $val[1]=str_replace("'", '', $val[1]); //DH
             $val[2]=str_replace("'", '', $val[2]); //DH

			 if ($status!="ok") break;
			 //if ($val[2]!='' && strlen($val[2])>0){
			 if (substr($ligne,0,1)!='#' && substr($ligne,0,2)!='"#'){

				 $FG_ADITION_SECOND_ADD_TABLE  = 'cc_card';
				 $FG_ADITION_SECOND_ADD_FIELDS = 'username, useralias, userpass, uipass, credit, lastname, firstname, activated'; //$fieldtoimport_sql
				 $FG_ADITION_SECOND_ADD_VALUE  = "'".$val[0]."', '".$val[1]."', '".$val[2]."', '".$val[3]."', '".$val[4]."', '".$val[5]."', '".$val[6]."', '".$val[7]."'";

				 for ($k=0;$k<count($fieldtoimport);$k++)
                 {

					if (!empty($val[$k + 8]) || $val[$k + 8]=='0')
					{
						$val[$k+3]=str_replace('"', '', $val[$k + 8]); //DH
						$val[$k+3]=str_replace("'", '', $val[$k + 8]); //DH

						if ($fieldtoimport[$k]=="startdate" && ($val[$k + 8]=='0' || $val[$k + 8]=='')) continue;
						if ($fieldtoimport[$k]=="stopdate" && ($val[$k + 8]=='0' || $val[$k + 8]=='')) continue;

						$FG_ADITION_SECOND_ADD_FIELDS .= ', '.$fieldtoimport[$k];

						if (is_numeric($val[$k + 8])) {
							$FG_ADITION_SECOND_ADD_VALUE .= ", ".$val[$k + 8]."";
						}else{
							$FG_ADITION_SECOND_ADD_VALUE .= ", '".$val[$k + 8]."'";
						}

						if ($fieldtoimport[$k] == "creationdate")  $find_createdate = 1;

					}
				 }

                 $begin_date = date("Y");
                 $begin_date_plus = date("Y") + 25;
	             $end_date = date("-m-d H:i:s");
	             $comp_date = "'".$begin_date.$end_date."'";
                 $comp_date_plus = "'".$begin_date_plus.$end_date."'";

				 if ($find_createdate != 1 ){
					$FG_ADITION_SECOND_ADD_FIELDS .= ', creationdate';
			 		$FG_ADITION_SECOND_ADD_VALUE .= ", '".$begin_date.$end_date."'";
				 }

				 $TT_QUERY .= "INSERT INTO $sp".$FG_ADITION_SECOND_ADD_TABLE."$sp (".$FG_ADITION_SECOND_ADD_FIELDS.") values (".trim ($FG_ADITION_SECOND_ADD_VALUE).") ";
				 $nb_to_import++;
			}

			if ($TT_QUERY!='' && strlen($TT_QUERY)>0 && ($nb_to_import==1) ){

				$nb_to_import=0;
				$result_query =  $DBHandle -> Execute($TT_QUERY);
				if ($result_query){ $nb_imported = $nb_imported + 1;
				}else{$buffer_error.= $ligneoriginal.'<br/>';}
				$TT_QUERY='';

			}


		} // END WHILE EOF


		if ($TT_QUERY!='' && strlen($TT_QUERY)>0 && ($nb_to_import>0) ){
				
				$result_query = @ $DBHandle -> Execute($TT_QUERY);
				if ($result_query) $nb_imported = $nb_imported + $nb_to_import;
		}


}

$Temps2 = time();
$Temps = $Temps2 - $Temps1;
//echo "<br>".$Temps2;
//echo "<br>Script Time :".$Temps."<br>";



// #### HEADER SECTION
$smarty->display('main.tpl');

?>


<style type="text/css">
<!--
div.myscroll {
	align: left;
	height: 100px;
	width: 600px;
	overflow: auto;
	border: 1px solid #ddd;
	background-color: #FFFFFF;
	padding: 5px;
}
-->
</style>

<script type="text/javascript">
<!--

function MM_openBrWindow(theURL,winName,features) { //v2.0
  window.open(theURL,winName,features);
}

function sendtoupload(form){

    document.forms["myform"].elements["task"].value = "upload";
	document.forms[0].submit();
}

//-->
</script>
      
	  <?php
	  if ($status=="ok"){
	  		echo $CC_help_import_card_confirm;
	  }else{
			echo $CC_help_import_card_analyse;
	  }
	  ?>
		<?php  if ($status!="ok"){?>

		<center>
		<?php echo gettext("The first line of your import is previewed below, please check to ensure that every is correct.")?>
		</center>

		<table align=center border="0" cellpadding="2" cellspacing="2" width="300">
			<tbody>
                <tr class="form_head">
                  <td class="tableBody" style="padding: 2px;" align="center" width="50%">
                    <strong> <span class="white_link"><?php echo gettext("FIELD")?> </span> </strong>
				  </td>
				  <td class="tableBody" style="padding: 2px;" align="center" width="50%">
                    <strong> <span class="white_link"><?php echo gettext("VALUE")?> </span> </strong>
				  </td>
                </tr>
				<?php  for ($i=0;$i<count($field);$i++){ ?>
               	<tr bgcolor="<?php echo $FG_TABLE_ALTERNATE_ROW_COLOR[($i+1)%2]?>"  onMouseOver="bgColor='#C4FFD7'" onMouseOut="bgColor='<?php echo $FG_TABLE_ALTERNATE_ROW_COLOR[($i+1)%2]?>'">
				 <td class="tableBody" align="left" valign="top"><b><?php echo strtoupper($field[$i])?></b></td>
				 <td class="tableBody" align="center" valign="top"><?php echo $val[$i]?></td>
				</tr>
				<?php  } ?>
				<?php  for ($i=0;$i<count($fieldtoimport);$i++){ ?>
               	<tr bgcolor="<?php echo $FG_TABLE_ALTERNATE_ROW_COLOR[($i)%2]?>"  onMouseOver="bgColor='#C4FFD7'" onMouseOut="bgColor='<?php echo $FG_TABLE_ALTERNATE_ROW_COLOR[($i)%2]?>'">
				 <td class="tableBody" align="left" valign="top"><b><?php echo strtoupper($fieldtoimport[$i])?></b></td>
				 <td class="tableBody" align="center" valign="top"><?php echo $val[$i + 8]?></td>
				</tr>
				<?php  } ?>

			</tbody>
		</table>




<br></br>
		<table width="95%" border="0" cellspacing="2" align="center" class="records">

              <form name="myform" enctype="multipart/form-data" action="CC_card_import_analyse.php" method="post" >
				<INPUT type="hidden" name="search_sources" value="<?php echo $search_sources?>">

                <tr>
                  <td colspan="2">
                    <div align="center"><span class="textcomment">
                       <?php echo gettext("Please check if the datas above are correct")?>. <br><b><?php echo gettext("If Yes")?></b>,&nbsp;<?php echo gettext("you can continue the import. Otherwise you must fix your csv file!")?> 
                      </span></div>
                  </td>
                </tr>
                <tr>
                  <td colspan="2">
                    <p align="center">
                      <input type="hidden" name="MAX_FILE_SIZE" value="<?php echo $my_max_file_size?>">
                      <input type="hidden" name="task" value="upload">
					  <input type="hidden" name="status" value="ok">
                     <input type="hidden" name="uploadedfile_name" value="<?php echo $new_filename?>">
			  			<input type="hidden" name="uploadedfile_type" value="<?php echo $the_file_type?>">
                      <input type="submit" value="<?php echo gettext("Continue to Import the CARD's")?>" onFocus=this.select() class="form_input_text" name="submit1" >
                      <br>
                      &nbsp; </p>
                  </td>
                </tr>

                <tr>
                  <td  class="bgcolor_014" colspan="2"><b>
                    <?php echo $translate[P34_9]?>
                    </b></td>
                </tr>

              </form>
            </table>

			<?php }else{ ?>

			</br>
			<table width="75%" border="0" cellspacing="2" align="center" class="records">

				<TR>
				  	<TD style="border-bottom: medium dotted #ED2525" align="center">&nbsp;</TD>
				</TR>
                <tr>
				  <td colspan="2" class="bgcolor_015" style="padding-left: 5px; padding-right: 3px;" align=center>
                    <div align="center"><span class="textcomment">

					  <br>
					  <?php 
					  $log = new Logger();
					  $log -> insertLog($_SESSION["admin_id"], 2, "CARDs IMPORTED", $nb_imported." New CARDS Imported Successfully", '', $_SERVER['REMOTE_ADDR'], $_SERVER['REQUEST_URI'],'');
					  $log = null;
					  ?>
					  <?php echo gettext("Success")?>, <?php echo $nb_imported?>&nbsp; <?php echo gettext("new cards have been imported.")?> 
					  <br>
                      </span></div>
					  <br><br>


					  <?php  if (!empty($buffer_error)){ ?>
					  <center>
					  	 <b><i><?php echo gettext("Line that has not been inserted!")?></i></b>
						 <div class="myscroll">
							  <span style="color: red;">
							  <?php echo $buffer_error?>
							  </span>
						 </div>
						</center>
						<br>
					 <?php  } ?>

                  </td>
                </tr>
			</table>

			<?php }?>
			<br>
<?php
	// #### Footer SECTION
$smarty->display('footer.tpl');
?>