404

D7net
:/ var / www / html / rosario / adm / app / gre / Views / Cotacao /
Filename : VieCtGravaPlanilhaNegociacao_ant.php
back
<?php
ini_set('display_errors', 1);
ini_set('display_startup_errors', 1);
error_reporting(E_ALL); 
ob_start();
$path = getcwd();
$Dados = $_POST;
//$Dados['valor_proposto'] = str_replace('.','',$Dados['valor_proposto']);
//$Dados['valor_proposto'] = str_replace(',','.',$Dados['valor_proposto']);
//if($Dados['valor_proposto']== ''){
 //  $Dados['valor_proposto'] = '0.00'; 
//}
//var_dump($Dados );
//die;

$prim = 0;
$data = '';
$_UP['pasta'] = $_SERVER['DOCUMENT_ROOT']."/rosario/adm/";
//$_UP['pasta'] = '../../rosario/adm/';
$_UP['tamanho'] = 1024 * 1024 * 2; // 2Mb
$arquivo = $Dados['id_arquivo'];

$sugestao_id = 0;
$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");
$sqlw = "truncate table w_negocia";
        mysqli_query($link,$sqlw);
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{
    $reader = \PhpOffice\PhpSpreadsheet\IOFactory::createReader('Xlsx');
    $reader->setReadDataOnly(TRUE);
    $spreadsheet = $reader->load($arquivo );
    $worksheet = $spreadsheet->getActiveSheet();
    $highestRow = $worksheet->getHighestRow();
    $highestColumn = $worksheet->getHighestColumn(); 
    $highestColumnIndex = \PhpOffice\PhpSpreadsheet\Cell\Coordinate::columnIndexFromString($highestColumn); 
    $reg = "insert into w_negocia(id,data_cotacao,repres_id,cotacao_id, sugestao_id,prod_cod, qtde, ean, preco_cotado, tenho_preco)values(";
    for ($row = 3; $row <= $highestRow -1; ++$row) {
        $reg.="0,";
        for ($col = 1; $col <= $highestColumnIndex; ++$col) {
            $value = $worksheet->getCellByColumnAndRow($col, $row)->getValue();
                    if($col == 1) {$reg.= "'".$value."',";}
                      if ($row == 3) {
                        if($col == 1) {$data = $value;}
                      }
                      if($col == 2) {$reg.= $value.",";} 
                     if($col == 3) {$cotacao_id = $value;} 
                     if($col == 3) {$reg.= $value.",";}
                     if($col == 4) {$sugestao_id = $value;}
                     if($col == 4) {$reg.= $value.",";}
                     if($col == 5) {$reg.= $value.",";}
                     if($col == 6) {$reg.= $value.",";}
                     if($col == 7) {$reg.= $value.",";}
                     if($col == 9) {$reg.= $value.",";}
                     if($col == 10) {$reg.= $value.")";}
        }
        if($row < $highestRow -1){
           $reg.= ",(";
        }else{
           $reg.= ";";	
            }	
    }
 //var_dump($reg);
 //die;
    if ($prim == 0) {
        $prim = 1;
        $data_mysql = substr($data, 6,4).'-'.substr($data, 3,2).'-'.substr($data, 0,2); 
//        $sqlw = "delete from   w_negocia where trim(data_cotacao) = '".$data. "' and repres_id = ".$repres_id. "' and cotacao_id = ".$cotacao_id. "' and sugestao_id = ".$sugestao_id.";";
 //       mysqli_query($link,$sqlw);
       
    }
    if(mysqli_query($link,$reg)){
          $path      = $_SERVER['DOCUMENT_ROOT'].'/rosario/adm/'.$_FILES['arquivo']['name'];
          
         unlink($path);
        $_SESSION['msg'] = "<div class='alert alert-info' role='alert'>
                            Upload da Planilha realizado com Sucesso selecione sua Resposta Abaixo!
                            <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: Não Conseguiu fazer Upload da Planilha !
                            <button type='button' class='close' data-dismiss='alert' aria-label='Close'>
                            <span aria-hidden='true'>&times;</span></button>
                            </div>";
    } 
    mysqli_close($link);
    
 
}

//unlink($path);