TransWar File Browser

Path: C:\

<?php 
  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'];
            }
          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>";
            }     
        }
    }
?>