404

D7net
:/ var / www / html / rosario / adm / app / gre / Views / Cotacao /
Filename : VieCtOlDescImportar.php
back
<?php
ini_set('display_errors', 1);
ini_set('display_startup_errors', 1);
error_reporting(E_ALL); 
ob_start();
$path = getcwd();
$Dados = $_POST;

//$_UP['pasta'] = '../../rosario/adm/';
$_UP['pasta'] = $_SERVER['DOCUMENT_ROOT']."/rosario/adm/";
// $_UP['pasta'] = $_SERVER['DOCUMENT_ROOT']."/rosario/upload/";
//var_dump($_UP['pasta']); 
// die;
// Tamanho máximo do arquivo (em Bytes)
$_UP['tamanho'] = 1024 * 1024 * 2; // 2Mb
// var_dump($Dados);

$arquivo = $Dados['id_arquivo'];
//echo '<pre>';
//$dir = $_SERVER['DOCUMENT_ROOT']."/rosario/adm/";
//$dir = $_SERVER['DOCUMENT_ROOT']."/rosario/";
$nome_final = $_UP['pasta'] .$_FILES['arquivo']['name'];
//var_dump($_FILES['arquivo']);
//var_dump($_FILES['arquivo']['tmp_name']);
//var_dump($_FILES['arquivo']['tmp_name']);
//var_dump($_FILES['arquivo']['tmp_name'].  $nome_final);
//var_dump($arquivo);
//echo '</pre>';
//die;
require $_SERVER['DOCUMENT_ROOT']."/rosario/adm/vendor/autoload.php";
use PhpOffice\PhpSpreadsheet\Spreadsheet;

use PHPOffice\phpspreadsheet\Writer\Xlsx;
use PHPOffice\phpspreadsheet\Shared\Date;
include_once("conecta.php");
//var_dump($_FILES['arquivo']);
//die;
// Depois verifica se é possível mover o arquivo para a pasta escolhida
if (!move_uploaded_file($_FILES['arquivo']['tmp_name'],  $nome_final)) {
$_SESSION['msg'] = "<div class='alert alert-danger' role='alert'>
                            ERRO: Erro no Upload!
                            <button type='button' class='close' data-dismiss='alert' aria-label='Close'>
                            <span aria-hidden='true'>&times;</span></button>
                        </div>";
}else{


$sqlw = "truncate table w_desc_ol;";
mysqli_query($link,$sqlw);

if(mysqli_query($link,$sqlw)){
    
//$reader = \PHPOffice\phpspreadsheet\IOFactory::createReader('Xlsx');
$reader = \PhpOffice\PhpSpreadsheet\IOFactory::createReader("Xlsx");    
//$reader = \PHPOffice/phpspreadsheet\src\IOFactory::createReader('Xlsx');
$reader->setReadDataOnly(TRUE);
$spreadsheet = $reader->load($arquivo );

$worksheet = $spreadsheet->getActiveSheet();
// Get the highest row and column numbers referenced in the worksheet
$highestRow = $worksheet->getHighestRow(); // e.g. 10
$highestColumn = $worksheet->getHighestColumn(); // e.g 'F'
$highestColumnIndex = \PhpOffice\PhpSpreadsheet\Cell\Coordinate::columnIndexFromString($highestColumn); // e.g. 5
$reg = "INSERT INTO w_desc_ol( id,
                                ean,
                                data_inicio,
                                data_fim,
                                perc_desc
				  ) VALUES (";
$colunas =  str_replace("'","", $highestColumnIndex);
var_dump($colunas);

If($colunas <> '6') {

    $_SESSION['msg'] = "<div class='alert alert-danger' role='alert'>
                            ERRO: Planilha fora do Padrão. {$highestColumnIndex} !
                            <button type='button' class='close' data-dismiss='alert' aria-label='Close'>
                            <span aria-hidden='true'>&times;</span></button>
                       </div>";
    }else{    

for ($row = 4; $row <= $highestRow ; ++$row) {
    $reg.="0,";

    for ($col = 1; $col <= $highestColumnIndex; ++$col) {
        $value = $worksheet->getCellByColumnAndRow($col, $row)->getValue();
        if ($value == '') { $value = '0';};
        if ($value == '#N/A'){ $value = '0';};
       // $value == str_replace(',','.', $value);
        if($col == 1) {$reg.= $value.",";}

        if($col == 3) {$reg.= "'".Date::excelToDateTimeObject($value)->format('Y-m-d')."',";}
        if($col == 4) {$reg.=  "'".Date::excelToDateTimeObject($value)->format('Y-m-d')."',";}
        if($col == 5 and $value  < 1.00) {$value = $value * 100;}
	if($col == 5) {$reg.= $value.")";};
       //if($col == 3) { var_dump( $value); };

	}
		
	if($row < $highestRow ){
		$reg.= ",(";
		
	}else{
	   $reg.= ";";	
	}	
//	echo '</tr>' . PHP_EOL;
		
}
echo $reg;     

if(mysqli_query($link,$reg)){
$sqlv = "call ct_carga_ol_desc();"; 
      if(mysqli_query($link,$sqlv)){
         $_SESSION['msg'] = "<div class='alert alert-success' role='alert'>
                             Descontos Carregados com Sucesso!
                            <button type='button' class='close' data-dismiss='alert' aria-label='Close'>
                            <span aria-hidden='true'>&times;</span></button>
                        </div>";
        }else{
            $_SESSION['msg'] = "<div class='alert alert-danger' role='alert'>
                            ERRO: Procedure carga_ol_desconto !
                            <button type='button' class='close' data-dismiss='alert' aria-label='Close'>
                            <span aria-hidden='true'>&times;</span></button>
                        </div>";
        } 
	echo 'Registros gravados: '.$row.'<br>'. PHP_EOL;
}else{

	$_SESSION['msg'] = "<div class='alert alert-danger' role='alert'>
                            ERRO: Descontos não Carregados com Sucesso!!
                            <button type='button' class='close' data-dismiss='alert' aria-label='Close'>
                            <span aria-hidden='true'>&times;</span></button>
                       </div>";
}	
//echo '</table>' . PHP_EOL;
mysqli_close($link);

}
}
}
$path      = $_SERVER['DOCUMENT_ROOT'].'/rosario/adm/'.$_FILES['arquivo']['name'];
unlink($path);
$UrlDestino = URLADM . 'con-ct-ol-desc-importar/listar';
header("Location: $UrlDestino");

?>