404

D7net
:/ proc / thread-self / cwd /
Filename : importa_convenio.php
back
<?php

set_time_limit(0); 

include_once("conecta.php");

error_reporting(E_ALL ^ E_NOTICE);

?>
<?php header("Content-type: text/html; charset=utf-8"); ?>
<meta http-equiv="content-type" content="text/html; charset=utf-8" />

 <form id="saldo"  name="saldo" action="?go=gravar" method="POST" enctype="multipart/form-data">

 <title>Importa Conveniado</title>

 <h1>IMPORTAÇÃO CONVENIADOS INATIVOS - ROSARIO</h1>
  <br><p>	<input type="file" name="arquivo" value="selecionar" />

<br><p>	<input type="submit" id="confirma" value="CONFIRMAR" />

</p>

</p>

       <p>

         <a href="../index.php">Pagina Principal</a>

        </p>  

 </form>

</body>

</div>

</html>

<?php

$cont = 0;
$sqlw = "truncate table w_conveniado";
mysqli_query($link,$sqlw);
if(@$_GET['go'] == 'gravar') {
	$datahoje = $_POST['data'];
	$dir = $_SERVER['DOCUMENT_ROOT']."/rosario/";
	$nome = $_FILES['arquivo']['name'];	
	$uploadfile = $dir.$_FILES['arquivo']['name'];
	$inipath = php_ini_loaded_file();
	$mv = move_uploaded_file($_FILES['arquivo']['tmp_name'], $uploadfile);
	if ($mv) {
		$handle = fopen($nome, "r");
		$rowli = 0;
		while ($line = fgetcsv($handle, 10000, ";")) {
			if ($rowli++ == 0) {
				continue;
			}
			 $line = str_replace(',','.', $line);
			  
		}
		$handle = fopen($nome, "r");
		$row = 0;

		while ($line = fgetcsv($handle, 10000, ";")) {
			$num = count($line);
			if ($row++ == 0) {
				continue;
			}
		
			$line = str_replace(",","", $line);
			$line = str_replace("'"," ", $line);
			


			$line[2] = str_replace('NULL',"0",$line[2]);
			$line[2] = str_replace("-","",$line[2]);
			$line[2] = str_replace(" ","0",$line[2]);
			$line[2] = str_replace(".","",$line[2]);
			$line[2] = str_replace("/","",$line[2]);
			$line[2] = str_replace("\xA0", ' ',$line[2]);
			$line[2] = str_replace("\xBA", ' ',$line[2]);
			$line[2] = str_replace("\xC", ' ',$line[2]);
			$line[2] = str_replace("\xD3", ' ',$line[2]);
			$line[2] = str_replace("\xD5", ' ',$line[2]);
			$line[2] = str_replace("\xC7", '  ',$line[2]);
			$line[2] = str_replace("\xC3", '*',$line[2]);
			$line[2] = str_replace("\xCANIO W", ' ',$line[2]);
			$line[2] = str_replace("\xC1", ' ',$line[2]);
			$line[2] = str_replace("\xA0", ' ',$line[2]);
			$line[2] = str_replace("\xC2NCER0",' ',$line[2]);
                        $line[2] = str_replace("\xE7\xF5es0L",' ',$line[2]);
			$line[2] = str_replace("\xCANIO0W",' ',$line[2]);
			$line[2] = str_replace("\xC90AGUI",' ',$line[2]);	
			$line[2] = str_replace("\xC9IA0DA",' ',$line[2]);
                        $line[2] = str_replace("\xBA", '',$line[2]);
                        $line[2] = str_replace("\xE3", 'a',$line[2]);
                        $line[2] = str_replace("\xEAnio", '',$line[2]);
                        $line[2] = str_replace("\x9676", '',$line[2]); 
                        $line[2] = str_replace("\x9619", '',$line[2]); 
                        $line[2] = str_replace("\x9679", '',$line[2]);   
                        $line[2] = str_replace("\x9630", '',$line[2]);   
                        $line[2] = str_replace("\x9635", '',$line[2]); 
            $line[1] = str_replace("\x9635", '',$line[1]); 						
                         $line[1] = str_replace("\x9630", '',$line[1]);   
                        $line[1] = str_replace("\x9679", '',$line[1]);  
                        $line[1] = str_replace("\x9619", '',$line[1]); 
						
			$line[1] = str_replace(","," ",$line[1]);
			$line[1] = str_replace("/"," ",$line[1]);
			$line[1] = str_replace("\xBA", '.',$line[1]);
			$line[1] = str_replace("\xC", '**' ,$line[1]);
			$line[1] = str_replace("\xD3", 'O',$line[1]);
			$line[1] = str_replace("\xD5", 'O',$line[1]);
			$line[1] = str_replace("\xC7", 'Ç',$line[1]);
			$line[1] = str_replace("\x87", 'A',$line[1]);
			$line[1] = str_replace("\xC3", 'C',$line[1]);
			$line[1] = str_replace("\x83", '**',$line[1]);
                        $line[1] = str_replace("\xBA", '',$line[1]);
                        $line[1] = str_replace("\xE3", 'a',$line[1]);
                        $line[1] = str_replace("\xEAnio", '',$line[1]); 
                        $line[1] = str_replace("\x9676", '',$line[1]); 
			$line[1] = str_replace("\xCANIO W", 'E',$line[1]);
			$line[1] = str_replace("\xC1", 'Á',$line[1]);
			$line[1] = str_replace("\xA0", '',$line[1]);
                        $line[1] = str_replace("\xC2NCER0",'**9',$line[1]);	
			$line[1] = str_replace("\xE7",'ç',$line[1]);
			$line[1] = str_replace("\xF5",'õ',$line[1]);
			$line[1] = str_replace("\xCANIO0W",'**10',$line[1]);
                        $line[1] = str_replace("\xC9",'E',$line[1]);
			$line[1] = str_replace("\xC2",'Â',$line[1]);
			$line[3] = str_replace('NULL',"0",$line[3]);
			$line[3] = str_replace("-","",$line[3]);
			$line[3] = str_replace(" ","0",$line[3]);
			$line[3] = str_replace(".","",$line[3]);
			$line[3] = str_replace("/","",$line[3]);
			$line[3] = str_replace("\xA0", ' ',$line[3]);
			$line[3] = str_replace("\xBA", ' ',$line[3]);
			$line[3] = str_replace("\xC", ' ',$line[3]);
			$line[3] = str_replace("\xD3", ' ',$line[3]);
			$line[3] = str_replace("\xD5", ' ',$line[3]);
			$line[3] = str_replace("\xC7", '  ',$line[3]);
			$line[3] = str_replace("\xC3", '*',$line[3]);
			$line[3] = str_replace("\xCANIO W", ' ',$line[3]);
			$line[3] = str_replace("\xC1", ' ',$line[3]);
			$line[3] = str_replace("\xA0", ' ',$line[3]);
			$line[3] = str_replace("\xC2NCER0",' ',$line[3]);
            		$line[3] = str_replace("\xE7\xF5es0L",' ',$line[3]);
			$line[3] = str_replace("\xCANIO0W",' ',$line[3]);
			$line[3] = str_replace("\xC90AGUI",' ',$line[3]);	
			$line[3] = str_replace("\xC9IA0DA",' ',$line[3]);
            		$line[3] = str_replace("\xBA", '',$line[3]);
            		$line[3] = str_replace("\xE3", 'a',$line[3]);
            		$line[3] = str_replace("\xEAnio", '',$line[3]);
            		$line[3] = str_replace("\x9676", '',$line[3]);
                        $line[3] = str_replace("\x9619", '',$line[3]); 
			$line[3] = str_replace("\x9679", '',$line[3]);
 			$line[3] = str_replace("\x9630", '',$line[3]);  
 			$line[3] = str_replace("\x9635", '',$line[3]);  
            $line[3] = str_replace("\x9635", '',$line[3]);
			$line[4] = str_replace("\x9635", '',$line[4]);
 			$line[4] = str_replace("\x9630", '',$line[4]);  
			$line[4] = str_replace("\x9679", '',$line[4]); 
            $line[4] = str_replace("\x9619", '',$line[4]); 
			$line[4] = str_replace('NULL',"0",$line[4]);
			$line[4] = str_replace("-","",$line[4]);
			$line[4] = str_replace(" ","0",$line[4]);
			$line[4] = str_replace(".","",$line[4]);
			$line[4] = str_replace("/","",$line[4]);
			$line[4] = str_replace("\xA0", ' ',$line[4]);
			$line[4] = str_replace("\xBA", ' ',$line[4]);
			$line[4] = str_replace("\xC", ' ',$line[4]);
			$line[4] = str_replace("\xD3", ' ',$line[4]);
			$line[4] = str_replace("\xD5", ' ',$line[4]);
			$line[4] = str_replace("\xC7", '  ',$line[4]);
			$line[4] = str_replace("\xC3", '*',$line[4]);
			$line[4] = str_replace("\xCANIO W", ' ',$line[4]);
			$line[4] = str_replace("\xC1", ' ',$line[4]);
			$line[4] = str_replace("\xA0", ' ',$line[4]);
			$line[4] = str_replace("\xC2NCER0",' ',$line[4]);
                        $line[4] = str_replace("\xE7\xF5es0L",' ',$line[4]);
			$line[4] = str_replace("\xCANIO0W",' ',$line[4]);
			$line[4] = str_replace("\xC90AGUI",' ',$line[4]);	
			$line[4] = str_replace("\xC9IA0DA",' ',$line[4]);
                        $line[4] = str_replace("\xBA", '',$line[4]);
                        $line[4] = str_replace("\xE3", 'a',$line[4]);
                        $line[4] = str_replace("\xEAnio", '',$line[4]);
                        $line[4] = str_replace("\x9676", '',$line[4]);
			$line[0] = str_replace('NULL',"0",$line[0]);
			$line[0] = str_replace("-","",$line[0]);
			$line[0] = str_replace(" ","0",$line[0]);
			$line[0] = str_replace(".","",$line[0]);
			$line[0] = str_replace("/","",$line[0]);
			$line[0] = str_replace("\xA0", ' ',$line[0]);
			$line[0] = str_replace("\xBA", ' ',$line[0]);
			$line[0] = str_replace("\xC", ' ',$line[0]);
			$line[0] = str_replace("\xD3", ' ',$line[0]);
			$line[0] = str_replace("\xD5", ' ',$line[0]);
			$line[0] = str_replace("\xC7", '  ',$line[0]);
			$line[0] = str_replace("\xC3", '*',$line[0]);
			$line[0] = str_replace("\xCANIO W", ' ',$line[0]);
			$line[0] = str_replace("\xC1", ' ',$line[0]);
			$line[0] = str_replace("\xA0", ' ',$line[0]);
			$line[0] = str_replace("\xC2NCER0",' ',$line[0]);
                        $line[0] = str_replace("\xE7\xF5es0L",' ',$line[0]);
			$line[0] = str_replace("\xCANIO0W",' ',$line[0]);
			$line[0] = str_replace("\xC90AGUI",' ',$line[0]);	
			$line[0] = str_replace("\xC9IA0DA",' ',$line[0]);
                        $line[0] = str_replace("\xBA", '',$line[0]);
                        $line[0] = str_replace("\xE3", 'a',$line[0]);
                        $line[0] = str_replace("\xEAnio", '',$line[0]);
                        $line[0] = str_replace("\x9676", '',$line[0]);	
			$line[0] = str_replace("\x9619", '',$line[0]); 
			$line[0] = str_replace("\x9679", '',$line[0]);
                        $line[0] = str_replace("\x9630", '',$line[0]);
			$line[0] = str_replace("\x9635", '',$line[0]);						

			$sql .= "( '{$line[2]}'
					   ,'{$line[4]}'
					   ,'{$line[10]}'
					   ,'{$line[0]}'
					   ,'{$line[1]}')";
			if($rowli == $row){
				$sql .="";
			}else{
				$sql .=",";
			}
		
	}
	
		 $sql1 = "INSERT INTO w_conveniado(cpf, 
										status,ciclo,
										cod_empresa,
										empresa
					) VALUES  {$sql}
				";

		
//var_dump($sql1);
	 if(mysqli_query($link,$sql1)){
		include_once("conecta.php");
  	    $sqlv = "call carga_conveniado();";
        if(!mysqli_query($link,$sqlv)){ 
	 	  printf ('Erro Procedure');
		}else{   
			 echo "<br>Linhas Lidas: <b>".$rowli."</b> - Linhas Atualizadas: <b>". $row.'</b><br><br>';
			 echo "<b>               **  CONVENIADOS INATIVOS IMPORTADOS COM SUCESSO !! ****";
        }
	}else{
		var_dump($link);
    }
	fclose($handle);
    mysqli_close($link);
} else {
   if (!$res) {
   printf("ERRO");

}

}

}

?>