404

D7net
:/ var / www / html / rosario / adm / app / gre / Views / Cotacao /
Filename : VieCtImportaAgendaLocal.php
back
<?php
ini_set('display_errors', 1);
ini_set('display_startup_errors', 1);
error_reporting(E_ALL); 
ob_start();
$path = getcwd();
$Dados = $_POST;
$anomes = $Dados['anomes'];
$data = $anomes.'-01';
$_UP['pasta'] = '../../rosario/adm/';
//var_dump($_UP['pasta']); 
// Tamanho máximo do arquivo (em Bytes)
$_UP['tamanho'] = 1024 * 1024 * 2; // 2Mb
 var_dump($Dados);
// die;
$arquivo = $Dados['id_arquivo'];
$nome_final = $_FILES['arquivo']['name'];
 require "vendor/autoload.php";
use PhpOffice\PhpSpreadsheet\Spreadsheet;
use PhpOffice\PhpSpreadsheet\Writer\Xlsx;
use PhpOffice\PhpSpreadsheet\Shared\Date;
include_once("conecta.php");
// Depois verifica se é possível mover o arquivo para a pasta escolhida
if (!move_uploaded_file($_FILES['arquivo']['tmp_name'], $_UP['pasta'] . $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_agenda;";
mysqli_query($link,$sqlw);
if(mysqli_query($link,$sqlw)){
$reader = \PhpOffice\PhpSpreadsheet\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_agenda(   anomes, 
                                marca_id,
                                comp_id,
                                marca_propria, 
                                tipo_compra,
                                prazo, 
                                ped_minimo,
                                frequencia,
                                dia_semana,
                                dia_sem1,
                                dia_sem2,
                                dia_sem3,
                                dia_sem4,
                                dia_sem5
				  ) VALUES (";


for ($row = 4; $row <= $highestRow ; ++$row) {



    $reg.="'".$anomes."',";
    for ($col = 1; $col <= $highestColumnIndex; ++$col) {
        $value = $worksheet->getCellByColumnAndRow($col, $row)->getValue();
        if ($value == '') { $value = '0';};
        if ($value == '#N/A'){ $value = '0';};
        if($col == 1) {$reg.= $value.",";}
	if($col == 3) {$reg.= $value.",'";}
        if($col == 6) {$reg.= $value."','";}
        if($col == 7) {$reg.= $value."','";}
	if($col == 8) {$reg.= $value."','";}
	if($col == 9) {$reg.= $value."','";}
        if($col == 10) {$reg.= $value."','";}
	if($col == 11) {$reg.= $value."','";}
        if($col == 15) $reg.= Date::excelToDateTimeObject($value)->format('Y-m-d')."','";
        if($col == 17) $reg.= Date::excelToDateTimeObject($value)->format('Y-m-d')."','";
        if($col == 19) $reg.= Date::excelToDateTimeObject($value)->format('Y-m-d')."','";
        if($col == 21) $reg.= Date::excelToDateTimeObject($value)->format('Y-m-d')."','";
        if($col == 23) $reg.= Date::excelToDateTimeObject($value)->format('Y-m-d')."')";

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

if(mysqli_query($link,$reg)){
    var_dump($reg);
    mysqli_query($link,$reg);
    $sqlv = "call carga_agenda();"; 
      if(mysqli_query($link,$sqlv)){
         $_SESSION['msg'] = "<div class='alert alert-success' role='alert'>
                            Agenda Carregada 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 grava_negociacao !
                            <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: Agenda não Carregada!
                            <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);
}
}
$UrlDestino = URLADM . 'ConCtImportaAgenda/listar';
header("Location: $UrlDestino");

?>