/* Decoded by unphp.net */

?><?php
ini_set('display_errors', 'Off'); 
header( 'content-type: text/html; charset=utf-8' );

if (file_exists('../utilities/fonction.inc.php'))  require_once '../utilities/fonction.inc.php';

function __autoload($class)
{
	if (file_exists("../utilities/{$class}.php")) include_once("../utilities/{$class}.php"); 
}

$obj = new database;

$error     = NULL;
$filename  = NULL;
$fileJson  = NULL;
$jResponse = array ();

define('MAX_SIZE', 2000000);
$path       = "uploads/";
$extAllowed = array('csv');
$table      = isset($_REQUEST['cbTable'])   ? filter_var($_REQUEST['cbTable'], FILTER_SANITIZE_STRING)   : NULL; 
$delimit    = isset($_REQUEST['cbDelimit']) ? filter_var($_REQUEST['cbDelimit'], FILTER_SANITIZE_STRING) : NULL; 

if ( isset($_FILES['uploadFile']) && $_FILES['uploadFile']['error'] === 0 ) 
{
	$name     = $_FILES["uploadFile"]["name"];
	$tmpName  = $_FILES["uploadFile"]["tmp_name"];
	$fileName = clean_french_string($name);
	
	$targetFile = basename($fileName);
	$extension  = pathinfo($targetFile, PATHINFO_EXTENSION);

	if ( !in_array(strtolower($extension), $extAllowed) ) { $error = "Format de fichier incorrect"; }
	else
	{ 
		if ( filesize($_FILES['fichier']['tmp_name']) > MAX_SIZE ) { $error = "Fichier trop gros"; }
		else
		{ 
			if ( @move_uploaded_file($tmpName, $targetFile) ) 
			{ 
				$row = 1;
				if (($handle = fopen($targetFile, "r")) !== FALSE) 
				{ 
				    while (($data = fgetcsv($handle, 99000, ",")) !== FALSE) 
				    {
				        $num = count($data);
				        $row++;
				        for ($c=0; $c < $num; $c++) { $tabcsv[] = utf8_encode($data[$c]); }
				    }	// while (($data = fgetcsv($handle, 99000, ",")) !== FALSE)
				    
				    csv( $obj, $table, $targetFile, $delimit, $tabcsv );
				    fclose($handle);
				}	// if (($handle = fopen($targetFile, "r")) !== FALSE) 
			}	// if ( @move_uploaded_file($tmpName, $targetFile) ) 
		    else { $error = "&Eacute;chec de l'Upload !"; }
		}
	}	
}   // if ( isset($_FILES['uploadFile']) && $_FILES['uploadFile']['error'] === 0 ) 
else { $error = "Aucun fichier re&ccedil;u ou fichier volumineux"; }	

function csv( $obj, $table, $targetFile, $delimit, $tabcsv )
{
	$arHead = explode($delimit, $tabcsv[0]);	
	$nbLgn  = count($arHead);	
	$dbName = $obj->getConfigs('DATA');
	if ( $nbLgn > 0 ) :
		$sql    = "SELECT name FROM sys.columns WHERE OBJECT_ID = OBJECT_ID('[{$table}]') ";
		$sttCol = $obj->showData($sql);
?>
		<form name="frmImport" method="post" action="">
			<input type="hidden" name="txtFile"  id="txtFile"  value="<?php echo $targetFile; ?>" readonly />
			<input type="hidden" name="txtTable" id="txtTable" value="<?php echo $table; ?>"      readonly />
			<input type="hidden" name="txtLimit" id="txtLimit" value="<?php echo $delimit; ?>"    readonly />
			<input type="hidden" name="txtLigne" id="txtLigne" value="<?php echo $nbLgn; ?>"      readonly />
			<table align="center" cellspacing="2" cellpadding="2" border="0">
				<thead>
					<tr align="center" style="font-weight:bold">
						<td align="center">Champ du fichier CSV</td>
						<td>&nbsp;</td>
						<td align="center">Champ de la table</td>
					</tr>
				</thead>
				<tbody>
				<?php
					for ( $i = 0 ; $i < $nbLgn ; $i++ ) :	
						echo "<tr>
";
							echo "<td align='center'>
";
								echo "<select name=colcsv{$i} id=colcsv{$i}>
";
								echo "<option value=''>(Aucun)</option>
";
								foreach ($arHead as $key => $value) 
								{
									echo "<option value={$key} " . ( ($i == $key) ? "selected" : NULL ) . ">{$value}</option>
";
								}
								echo "</select>
";
							echo "</td>
";
							echo "<td>&nbsp;</td>
";
							echo "<td align='center'>
";
								echo "<select name=coltbl{$i} id=coltbl{$i}>
";
								echo "<option value=''>(Aucun)</option>
";
								foreach ($sttCol as $key => $value)  : 
									extract($lstCol);
									echo "<option value={$key} " . ( ($i == $key)  ? "selected" : NULL ) . ">" . $sttCol[$key]['name'] . "</option>
";
								endforeach;
								echo "</select>
";
							echo "</td>
";
						echo "</tr>
";
					endfor;
				?>
				</tbody>
				<tfoot>
					<tr><td colspan="3" height="2">&nbsp;</td></tr>
					<tr>
                    	<td align="center" colspan="3">
                        	<button class='customBtn btnImport'>Importer</button>
                        </td>
                    </tr>						
				</tfoot>
			</table>
		</form>
<?php
	endif;	// if ( $nbLgn > 0 ) :
}	// function csv( $obj, $table, $targetFile, $delimit, $tabcsv )
echo "{$error}<br>
";
?>
<script type="text/javascript" src="scripts/jquery.min.js"></script>
<script type="text/javascript">
$(document).ready(function()
{
	$('.btnImport').click(function() 
    { 
    	var sHtml   = "";
    	var toSend  = "";
    	var nbLigne = $("#txtLigne").val();
    	
        toSend  = "txtTable="  + $("#txtTable").val();
        toSend += "&txtLimit="  + $("#txtLimit").val();
        toSend += "&txtFile="  + $("#txtFile").val(); 
        toSend += "&txtLigne="  + nbLigne;
        for ( i = 0 ; i < nbLigne ; i++ )
        { 
        	ccsv = "colcsv" + i;
        	scsv = "#" + ccsv;
        	tcsv = "#" + ccsv + " option:selected";
        	ctbl = "coltbl" + i; 
        	stbl = "#" + ctbl;	 
        	ttbl = "#" + ctbl + " option:selected";
        	toSend += "&txtcsv" + i + "=" + $(tcsv).text();
        	toSend += "&valcsv" + i + "=" + $(scsv).val();
        	toSend += "&txttbl" + i + "=" + $(ttbl).text();
        	toSend += "&valtbl" + i + "=" + $(stbl).val();
        }	// for ( i = 0 ; i < nbLigne ; i++ ) 
        
        sHtml = "<div><img src='images/ajax-loader.gif' />&nbsp;Veuillez-patienter</div>";
        $('#uploadStatus').html(sHtml);         
        
        $.post("synchro/doImport.php", toSend).done(function(rep) 
        { 
            $('#uploadStatus').html("Import effectu&eacute;"); 
            return false;
        });        

        return false;
    }); 
}); 
</script>