TransWar File Browser

Path: C:\

<?php 
  ini_set('max_execution_time',259200); 
  ini_set('memory_limit' , '-1' ) ;
  require_once("conecta_Agendas.php");
  require_once("matriz.php");
  require_once("RequestAPI.php");
  if (!$conn){echo "<script language='JavaScript'>alert('Erro na abertura do Banco de Dados!!!');window.close();opener.location.href=opener.location.href;</script>";}
  $id = $_POST["id"];
  $nome = trim($_POST["nome"]);
  $urgente =$_POST["urgente"];
  if ($_POST["ch"]!=''){
    $ch = trim($_POST["ch"]);
  }else{
    echo"<script language='JavaScript'>window.close();opener.location.href=opener.location.href;</script>";
  }
  $v1='nota';
  $v2='chave';
  $v3 = $ch;
  $v1=$pt1[$v1];
  $v2=$pt2[$v1][$v2];
  $dataResponse = new RequestAPI();
  $resposta = $dataResponse->getResponse($endpt[$v1], $v2, $v3);
  $data=json_decode($resposta[1], true);
  $resta=$resposta[0];if($resta<=5){sleep(40);}
  if ($data['success']!=1 or $data['total']==0){
    echo'<script language="JavaScript">alert("Essa Nota Fiscal NÃO está no sistema!!!");window.close();opener.location.href=opener.location.href;</script>';
  }else {
    $query1 = sqlsrv_query($conn,"SELECT 
       id_AgendaNFs as agendaNF
      ,id_Agenda
      ,ds_Agenda as agenda
      ,ds_ChaveNFe
    FROM tbdAgendaNFs
    WHERE ds_ChaveNFe='".$ch."'", array(), array( "Scrollable" => SQLSRV_CURSOR_KEYSET ));
    $num = sqlsrv_num_rows($query1);
    if ( $num != 0 ) {
      while ($res1 = sqlsrv_fetch_array($query1, SQLSRV_FETCH_ASSOC)) {
        $agenda=trim($res1['agenda']);$agendaNF=$res1['agendaNF'];
        if($res1['id_Agenda']==0){
          echo"<script language='JavaScript'>location.href='alteraNFagenda.php?id=".$id."&agenda=".$nome."&urgente=".$urgente."&agendaNF=".$agendaNF."';</script>";
        }else{
          echo"<script language='JavaScript'>decisao = confirm('JÁ está na agenda ($agenda). Confirma a Alteração?');if (decisao){location.href='alteraNFagenda.php?id=".$id."&agenda=".$nome."&urgente=".$urgente."&agendaNF=".$agendaNF."';}else{window.close();opener.location.href=opener.location.href;}</script>";
        }
      }
    }else{
      $nrNF=$data['data'][0]['number'];
      $query2 = sqlsrv_query($conn,"INSERT INTO tbdAgendaNFs
        ([id_Agenda]
        ,[ds_Agenda]
        ,[nr_NotaFiscal]
        ,[ds_Urgente]
        ,[ds_ChaveNFe])
      VALUES (
        '"  . $id . "',
        '"  . $nome . "',
        '"  . $nrNF . "',
        '"  . $urgente . "',
        '"  . $ch . "')");
      if(sqlsrv_rows_affected($query2) != 0){  
        echo "<script type=\"text/javascript\">alert(\"Nota Fiscal Cadastrada com Sucesso.\");window.close();opener.location.href=opener.location.href;</script>";
      }else{
        echo "<script type=\"text/javascript\">alert(\"Houve ERRO no cadastro dessa Nota Fiscal.\");window.close();opener.location.href=opener.location.href;</script>";
      }     
    }
  }
?>