<?php

class grid_fgstock_rtf
{
   var $Db;
   var $Erro;
   var $Ini;
   var $Lookup;
   var $nm_data;
   var $texto_tag;
   var $arquivo;
   var $tit_doc;
   var $sc_proc_grid; 
   var $NM_cmp_hidden = array();

   //---- 
   function grid_fgstock_rtf()
   {
      $this->nm_data   = new nm_data("en_us");
      $this->texto_tag = "";
   }

   //---- 
   function monta_rtf()
   {
      $this->inicializa_vars();
      $this->gera_texto_tag();
      $this->grava_arquivo_rtf();
      $this->monta_html();
   }

   //----- 
   function inicializa_vars()
   {
      global $nm_lang;
      $dir_raiz          = strrpos($_SERVER['PHP_SELF'],"/") ;  
      $dir_raiz          = substr($_SERVER['PHP_SELF'], 0, $dir_raiz + 1) ;  
      $this->nm_location = $this->Ini->sc_protocolo . $this->Ini->server . $dir_raiz; 
      $this->arquivo    = "sc_rtf";
      $this->arquivo   .= "_" . date("YmdHis") . "_" . rand(0, 1000);
      $this->arquivo   .= "_grid_fgstock";
      $this->arquivo   .= ".rtf";
      $this->tit_doc    = "grid_fgstock.rtf";
   }

   //----- 
   function gera_texto_tag()
   {
     global $nm_lang;
      global
             $nm_nada, $nm_lang;

      $_SESSION['scriptcase']['sc_sql_ult_conexao'] = ''; 
      $this->sc_proc_grid = false; 
      $nm_raiz_img  = ""; 
      if (isset($_SESSION['scriptcase']['sc_apl_conf']['grid_fgstock']['field_display']) && !empty($_SESSION['scriptcase']['sc_apl_conf']['grid_fgstock']['field_display']))
      {
          foreach ($_SESSION['scriptcase']['sc_apl_conf']['grid_fgstock']['field_display'] as $NM_cada_field => $NM_cada_opc)
          {
              $this->NM_cmp_hidden[$NM_cada_field] = $NM_cada_opc;
          }
      }
      if (isset($_SESSION['sc_session'][$this->Ini->sc_page]['grid_fgstock']['usr_cmp_sel']) && !empty($_SESSION['sc_session'][$this->Ini->sc_page]['grid_fgstock']['usr_cmp_sel']))
      {
          foreach ($_SESSION['sc_session'][$this->Ini->sc_page]['grid_fgstock']['usr_cmp_sel'] as $NM_cada_field => $NM_cada_opc)
          {
              $this->NM_cmp_hidden[$NM_cada_field] = $NM_cada_opc;
          }
      }
      if (isset($_SESSION['sc_session'][$this->Ini->sc_page]['grid_fgstock']['php_cmp_sel']) && !empty($_SESSION['sc_session'][$this->Ini->sc_page]['grid_fgstock']['php_cmp_sel']))
      {
          foreach ($_SESSION['sc_session'][$this->Ini->sc_page]['grid_fgstock']['php_cmp_sel'] as $NM_cada_field => $NM_cada_opc)
          {
              $this->NM_cmp_hidden[$NM_cada_field] = $NM_cada_opc;
          }
      }
      if (isset($_SESSION['sc_session'][$this->Ini->sc_page]['grid_fgstock']['campos_busca']) && !empty($_SESSION['sc_session'][$this->Ini->sc_page]['grid_fgstock']['campos_busca']))
      { 
          $this->invoice = $_SESSION['sc_session'][$this->Ini->sc_page]['grid_fgstock']['campos_busca']['invoice']; 
          $tmp_pos = strpos($this->invoice, "##@@");
          if ($tmp_pos !== false)
          {
              $this->invoice = substr($this->invoice, 0, $tmp_pos);
          }
          $this->p_o_number = $_SESSION['sc_session'][$this->Ini->sc_page]['grid_fgstock']['campos_busca']['p_o_number']; 
          $tmp_pos = strpos($this->p_o_number, "##@@");
          if ($tmp_pos !== false)
          {
              $this->p_o_number = substr($this->p_o_number, 0, $tmp_pos);
          }
          $this->dye_lot = $_SESSION['sc_session'][$this->Ini->sc_page]['grid_fgstock']['campos_busca']['dye_lot']; 
          $tmp_pos = strpos($this->dye_lot, "##@@");
          if ($tmp_pos !== false)
          {
              $this->dye_lot = substr($this->dye_lot, 0, $tmp_pos);
          }
          $this->open = $_SESSION['sc_session'][$this->Ini->sc_page]['grid_fgstock']['campos_busca']['open']; 
          $tmp_pos = strpos($this->open, "##@@");
          if ($tmp_pos !== false)
          {
              $this->open = substr($this->open, 0, $tmp_pos);
          }
      } 
      $this->nm_field_dinamico = array();
      $this->nm_order_dinamico = array();
      $this->sc_where_orig   = $_SESSION['sc_session'][$this->Ini->sc_page]['grid_fgstock']['where_orig'];
      $this->sc_where_atual  = $_SESSION['sc_session'][$this->Ini->sc_page]['grid_fgstock']['where_pesq'];
      $this->sc_where_filtro = $_SESSION['sc_session'][$this->Ini->sc_page]['grid_fgstock']['where_pesq_filtro'];
      if (isset($_SESSION['sc_session'][$this->Ini->sc_page]['grid_fgstock']['rtf_name']))
      {
          $this->arquivo = $_SESSION['sc_session'][$this->Ini->sc_page]['grid_fgstock']['rtf_name'];
          $this->tit_doc = $_SESSION['sc_session'][$this->Ini->sc_page]['grid_fgstock']['rtf_name'];
          unset($_SESSION['sc_session'][$this->Ini->sc_page]['grid_fgstock']['rtf_name']);
      }
      if (in_array(strtolower($this->Ini->nm_tpbanco), $this->Ini->nm_bases_sybase))
      { 
          $nmgp_select = "SELECT INVOICE, P_O_NUMBER, DYE_LOT, LOCATION, STYLE, COLOR, COLOR_NO, WIDTH, DESCRIPTIO, YARDS_RECD, SHIPPED, WASTE, OPEN, SELL_AT, FINISH, OTHER_LOT, COST, AMOUNT, TRANS, ALO, FIN_NO, PUTUP, RELEASED, GROSS, TARE, NET, CYARDS, RCOUNT, ESTNET, NONETCT from " . $this->Ini->nm_tabela; 
      } 
      elseif (in_array(strtolower($this->Ini->nm_tpbanco), $this->Ini->nm_bases_mysql))
      { 
          $nmgp_select = "SELECT INVOICE, P_O_NUMBER, DYE_LOT, LOCATION, STYLE, COLOR, COLOR_NO, WIDTH, DESCRIPTIO, YARDS_RECD, SHIPPED, WASTE, OPEN, SELL_AT, FINISH, OTHER_LOT, COST, AMOUNT, TRANS, ALO, FIN_NO, PUTUP, RELEASED, GROSS, TARE, NET, CYARDS, RCOUNT, ESTNET, NONETCT from " . $this->Ini->nm_tabela; 
      } 
      elseif (in_array(strtolower($this->Ini->nm_tpbanco), $this->Ini->nm_bases_mssql))
      { 
       $nmgp_select = "SELECT INVOICE, P_O_NUMBER, DYE_LOT, LOCATION, STYLE, COLOR, COLOR_NO, WIDTH, DESCRIPTIO, YARDS_RECD, SHIPPED, WASTE, OPEN, SELL_AT, FINISH, OTHER_LOT, COST, AMOUNT, TRANS, ALO, FIN_NO, PUTUP, RELEASED, GROSS, TARE, NET, CYARDS, RCOUNT, ESTNET, NONETCT from " . $this->Ini->nm_tabela; 
      } 
      elseif (in_array(strtolower($this->Ini->nm_tpbanco), $this->Ini->nm_bases_oracle))
      { 
          $nmgp_select = "SELECT INVOICE, P_O_NUMBER, DYE_LOT, LOCATION, STYLE, COLOR, COLOR_NO, WIDTH, DESCRIPTIO, YARDS_RECD, SHIPPED, WASTE, OPEN, SELL_AT, FINISH, OTHER_LOT, COST, AMOUNT, TRANS, ALO, FIN_NO, PUTUP, RELEASED, GROSS, TARE, NET, CYARDS, RCOUNT, ESTNET, NONETCT from " . $this->Ini->nm_tabela; 
      } 
      elseif (in_array(strtolower($this->Ini->nm_tpbanco), $this->Ini->nm_bases_informix))
      { 
          $nmgp_select = "SELECT INVOICE, P_O_NUMBER, DYE_LOT, LOCATION, STYLE, COLOR, COLOR_NO, WIDTH, DESCRIPTIO, YARDS_RECD, SHIPPED, WASTE, OPEN, SELL_AT, FINISH, OTHER_LOT, COST, AMOUNT, TRANS, ALO, FIN_NO, PUTUP, RELEASED, GROSS, TARE, NET, CYARDS, RCOUNT, ESTNET, NONETCT from " . $this->Ini->nm_tabela; 
      } 
      else 
      { 
          $nmgp_select = "SELECT INVOICE, P_O_NUMBER, DYE_LOT, LOCATION, STYLE, COLOR, COLOR_NO, WIDTH, DESCRIPTIO, YARDS_RECD, SHIPPED, WASTE, OPEN, SELL_AT, FINISH, OTHER_LOT, COST, AMOUNT, TRANS, ALO, FIN_NO, PUTUP, RELEASED, GROSS, TARE, NET, CYARDS, RCOUNT, ESTNET, NONETCT from " . $this->Ini->nm_tabela; 
      } 
      $nmgp_select .= " " . $_SESSION['sc_session'][$this->Ini->sc_page]['grid_fgstock']['where_pesq'];
      $nmgp_order_by = $_SESSION['sc_session'][$this->Ini->sc_page]['grid_fgstock']['order_grid'];
      $nmgp_select .= $nmgp_order_by; 
      $_SESSION['scriptcase']['sc_sql_ult_comando'] = $nmgp_select;
      $rs = $this->Db->Execute($nmgp_select);
      if ($rs === false && !$rs->EOF && $GLOBALS["NM_ERRO_IBASE"] != 1)
      {
         $this->Erro->mensagem(__FILE__, __LINE__, "banco", $this->Ini->Nm_lang['lang_errm_dber'], $this->Db->ErrorMsg());
         exit;
      }

      $this->texto_tag .= "<table>\r\n";
      $this->texto_tag .= "<tr>\r\n";
      foreach ($_SESSION['sc_session'][$this->Ini->sc_page]['grid_fgstock']['field_order'] as $Cada_col)
      { 
          $SC_Label = (isset($this->New_label['invoice'])) ? $this->New_label['invoice'] : "INVOICE"; 
          if ($Cada_col == "invoice" && (!isset($this->NM_cmp_hidden[$Cada_col]) || $this->NM_cmp_hidden[$Cada_col] != "off"))
          {
             if (!NM_is_utf8($SC_Label))
              {
                  $SC_Label = mb_convert_encoding($SC_Label, "UTF-8", $_SESSION['scriptcase']['charset']);
              }
              $SC_Label = str_replace('<', '&lt;', $SC_Label);
              $SC_Label = str_replace('>', '&gt;', $SC_Label);
              $this->texto_tag .= "<td>" . $SC_Label . "</td>\r\n";
          }
          $SC_Label = (isset($this->New_label['p_o_number'])) ? $this->New_label['p_o_number'] : "P O NUMBER"; 
          if ($Cada_col == "p_o_number" && (!isset($this->NM_cmp_hidden[$Cada_col]) || $this->NM_cmp_hidden[$Cada_col] != "off"))
          {
             if (!NM_is_utf8($SC_Label))
              {
                  $SC_Label = mb_convert_encoding($SC_Label, "UTF-8", $_SESSION['scriptcase']['charset']);
              }
              $SC_Label = str_replace('<', '&lt;', $SC_Label);
              $SC_Label = str_replace('>', '&gt;', $SC_Label);
              $this->texto_tag .= "<td>" . $SC_Label . "</td>\r\n";
          }
          $SC_Label = (isset($this->New_label['dye_lot'])) ? $this->New_label['dye_lot'] : "DYE LOT"; 
          if ($Cada_col == "dye_lot" && (!isset($this->NM_cmp_hidden[$Cada_col]) || $this->NM_cmp_hidden[$Cada_col] != "off"))
          {
             if (!NM_is_utf8($SC_Label))
              {
                  $SC_Label = mb_convert_encoding($SC_Label, "UTF-8", $_SESSION['scriptcase']['charset']);
              }
              $SC_Label = str_replace('<', '&lt;', $SC_Label);
              $SC_Label = str_replace('>', '&gt;', $SC_Label);
              $this->texto_tag .= "<td>" . $SC_Label . "</td>\r\n";
          }
          $SC_Label = (isset($this->New_label['location'])) ? $this->New_label['location'] : "LOCATION"; 
          if ($Cada_col == "location" && (!isset($this->NM_cmp_hidden[$Cada_col]) || $this->NM_cmp_hidden[$Cada_col] != "off"))
          {
             if (!NM_is_utf8($SC_Label))
              {
                  $SC_Label = mb_convert_encoding($SC_Label, "UTF-8", $_SESSION['scriptcase']['charset']);
              }
              $SC_Label = str_replace('<', '&lt;', $SC_Label);
              $SC_Label = str_replace('>', '&gt;', $SC_Label);
              $this->texto_tag .= "<td>" . $SC_Label . "</td>\r\n";
          }
          $SC_Label = (isset($this->New_label['style'])) ? $this->New_label['style'] : "STYLE"; 
          if ($Cada_col == "style" && (!isset($this->NM_cmp_hidden[$Cada_col]) || $this->NM_cmp_hidden[$Cada_col] != "off"))
          {
             if (!NM_is_utf8($SC_Label))
              {
                  $SC_Label = mb_convert_encoding($SC_Label, "UTF-8", $_SESSION['scriptcase']['charset']);
              }
              $SC_Label = str_replace('<', '&lt;', $SC_Label);
              $SC_Label = str_replace('>', '&gt;', $SC_Label);
              $this->texto_tag .= "<td>" . $SC_Label . "</td>\r\n";
          }
          $SC_Label = (isset($this->New_label['color'])) ? $this->New_label['color'] : "COLOR"; 
          if ($Cada_col == "color" && (!isset($this->NM_cmp_hidden[$Cada_col]) || $this->NM_cmp_hidden[$Cada_col] != "off"))
          {
             if (!NM_is_utf8($SC_Label))
              {
                  $SC_Label = mb_convert_encoding($SC_Label, "UTF-8", $_SESSION['scriptcase']['charset']);
              }
              $SC_Label = str_replace('<', '&lt;', $SC_Label);
              $SC_Label = str_replace('>', '&gt;', $SC_Label);
              $this->texto_tag .= "<td>" . $SC_Label . "</td>\r\n";
          }
          $SC_Label = (isset($this->New_label['color_no'])) ? $this->New_label['color_no'] : "COLOR NO"; 
          if ($Cada_col == "color_no" && (!isset($this->NM_cmp_hidden[$Cada_col]) || $this->NM_cmp_hidden[$Cada_col] != "off"))
          {
             if (!NM_is_utf8($SC_Label))
              {
                  $SC_Label = mb_convert_encoding($SC_Label, "UTF-8", $_SESSION['scriptcase']['charset']);
              }
              $SC_Label = str_replace('<', '&lt;', $SC_Label);
              $SC_Label = str_replace('>', '&gt;', $SC_Label);
              $this->texto_tag .= "<td>" . $SC_Label . "</td>\r\n";
          }
          $SC_Label = (isset($this->New_label['width'])) ? $this->New_label['width'] : "WIDTH"; 
          if ($Cada_col == "width" && (!isset($this->NM_cmp_hidden[$Cada_col]) || $this->NM_cmp_hidden[$Cada_col] != "off"))
          {
             if (!NM_is_utf8($SC_Label))
              {
                  $SC_Label = mb_convert_encoding($SC_Label, "UTF-8", $_SESSION['scriptcase']['charset']);
              }
              $SC_Label = str_replace('<', '&lt;', $SC_Label);
              $SC_Label = str_replace('>', '&gt;', $SC_Label);
              $this->texto_tag .= "<td>" . $SC_Label . "</td>\r\n";
          }
          $SC_Label = (isset($this->New_label['descriptio'])) ? $this->New_label['descriptio'] : "DESCRIPTIO"; 
          if ($Cada_col == "descriptio" && (!isset($this->NM_cmp_hidden[$Cada_col]) || $this->NM_cmp_hidden[$Cada_col] != "off"))
          {
             if (!NM_is_utf8($SC_Label))
              {
                  $SC_Label = mb_convert_encoding($SC_Label, "UTF-8", $_SESSION['scriptcase']['charset']);
              }
              $SC_Label = str_replace('<', '&lt;', $SC_Label);
              $SC_Label = str_replace('>', '&gt;', $SC_Label);
              $this->texto_tag .= "<td>" . $SC_Label . "</td>\r\n";
          }
          $SC_Label = (isset($this->New_label['yards_recd'])) ? $this->New_label['yards_recd'] : "YARDS RECD"; 
          if ($Cada_col == "yards_recd" && (!isset($this->NM_cmp_hidden[$Cada_col]) || $this->NM_cmp_hidden[$Cada_col] != "off"))
          {
             if (!NM_is_utf8($SC_Label))
              {
                  $SC_Label = mb_convert_encoding($SC_Label, "UTF-8", $_SESSION['scriptcase']['charset']);
              }
              $SC_Label = str_replace('<', '&lt;', $SC_Label);
              $SC_Label = str_replace('>', '&gt;', $SC_Label);
              $this->texto_tag .= "<td>" . $SC_Label . "</td>\r\n";
          }
          $SC_Label = (isset($this->New_label['shipped'])) ? $this->New_label['shipped'] : "SHIPPED"; 
          if ($Cada_col == "shipped" && (!isset($this->NM_cmp_hidden[$Cada_col]) || $this->NM_cmp_hidden[$Cada_col] != "off"))
          {
             if (!NM_is_utf8($SC_Label))
              {
                  $SC_Label = mb_convert_encoding($SC_Label, "UTF-8", $_SESSION['scriptcase']['charset']);
              }
              $SC_Label = str_replace('<', '&lt;', $SC_Label);
              $SC_Label = str_replace('>', '&gt;', $SC_Label);
              $this->texto_tag .= "<td>" . $SC_Label . "</td>\r\n";
          }
          $SC_Label = (isset($this->New_label['waste'])) ? $this->New_label['waste'] : "WASTE"; 
          if ($Cada_col == "waste" && (!isset($this->NM_cmp_hidden[$Cada_col]) || $this->NM_cmp_hidden[$Cada_col] != "off"))
          {
             if (!NM_is_utf8($SC_Label))
              {
                  $SC_Label = mb_convert_encoding($SC_Label, "UTF-8", $_SESSION['scriptcase']['charset']);
              }
              $SC_Label = str_replace('<', '&lt;', $SC_Label);
              $SC_Label = str_replace('>', '&gt;', $SC_Label);
              $this->texto_tag .= "<td>" . $SC_Label . "</td>\r\n";
          }
          $SC_Label = (isset($this->New_label['open'])) ? $this->New_label['open'] : "OPEN"; 
          if ($Cada_col == "open" && (!isset($this->NM_cmp_hidden[$Cada_col]) || $this->NM_cmp_hidden[$Cada_col] != "off"))
          {
             if (!NM_is_utf8($SC_Label))
              {
                  $SC_Label = mb_convert_encoding($SC_Label, "UTF-8", $_SESSION['scriptcase']['charset']);
              }
              $SC_Label = str_replace('<', '&lt;', $SC_Label);
              $SC_Label = str_replace('>', '&gt;', $SC_Label);
              $this->texto_tag .= "<td>" . $SC_Label . "</td>\r\n";
          }
          $SC_Label = (isset($this->New_label['sell_at'])) ? $this->New_label['sell_at'] : "SELL AT"; 
          if ($Cada_col == "sell_at" && (!isset($this->NM_cmp_hidden[$Cada_col]) || $this->NM_cmp_hidden[$Cada_col] != "off"))
          {
             if (!NM_is_utf8($SC_Label))
              {
                  $SC_Label = mb_convert_encoding($SC_Label, "UTF-8", $_SESSION['scriptcase']['charset']);
              }
              $SC_Label = str_replace('<', '&lt;', $SC_Label);
              $SC_Label = str_replace('>', '&gt;', $SC_Label);
              $this->texto_tag .= "<td>" . $SC_Label . "</td>\r\n";
          }
          $SC_Label = (isset($this->New_label['finish'])) ? $this->New_label['finish'] : "FINISH"; 
          if ($Cada_col == "finish" && (!isset($this->NM_cmp_hidden[$Cada_col]) || $this->NM_cmp_hidden[$Cada_col] != "off"))
          {
             if (!NM_is_utf8($SC_Label))
              {
                  $SC_Label = mb_convert_encoding($SC_Label, "UTF-8", $_SESSION['scriptcase']['charset']);
              }
              $SC_Label = str_replace('<', '&lt;', $SC_Label);
              $SC_Label = str_replace('>', '&gt;', $SC_Label);
              $this->texto_tag .= "<td>" . $SC_Label . "</td>\r\n";
          }
          $SC_Label = (isset($this->New_label['other_lot'])) ? $this->New_label['other_lot'] : "OTHER LOT"; 
          if ($Cada_col == "other_lot" && (!isset($this->NM_cmp_hidden[$Cada_col]) || $this->NM_cmp_hidden[$Cada_col] != "off"))
          {
             if (!NM_is_utf8($SC_Label))
              {
                  $SC_Label = mb_convert_encoding($SC_Label, "UTF-8", $_SESSION['scriptcase']['charset']);
              }
              $SC_Label = str_replace('<', '&lt;', $SC_Label);
              $SC_Label = str_replace('>', '&gt;', $SC_Label);
              $this->texto_tag .= "<td>" . $SC_Label . "</td>\r\n";
          }
          $SC_Label = (isset($this->New_label['cost'])) ? $this->New_label['cost'] : "COST"; 
          if ($Cada_col == "cost" && (!isset($this->NM_cmp_hidden[$Cada_col]) || $this->NM_cmp_hidden[$Cada_col] != "off"))
          {
             if (!NM_is_utf8($SC_Label))
              {
                  $SC_Label = mb_convert_encoding($SC_Label, "UTF-8", $_SESSION['scriptcase']['charset']);
              }
              $SC_Label = str_replace('<', '&lt;', $SC_Label);
              $SC_Label = str_replace('>', '&gt;', $SC_Label);
              $this->texto_tag .= "<td>" . $SC_Label . "</td>\r\n";
          }
          $SC_Label = (isset($this->New_label['amount'])) ? $this->New_label['amount'] : "AMOUNT"; 
          if ($Cada_col == "amount" && (!isset($this->NM_cmp_hidden[$Cada_col]) || $this->NM_cmp_hidden[$Cada_col] != "off"))
          {
             if (!NM_is_utf8($SC_Label))
              {
                  $SC_Label = mb_convert_encoding($SC_Label, "UTF-8", $_SESSION['scriptcase']['charset']);
              }
              $SC_Label = str_replace('<', '&lt;', $SC_Label);
              $SC_Label = str_replace('>', '&gt;', $SC_Label);
              $this->texto_tag .= "<td>" . $SC_Label . "</td>\r\n";
          }
          $SC_Label = (isset($this->New_label['trans'])) ? $this->New_label['trans'] : "TRANS"; 
          if ($Cada_col == "trans" && (!isset($this->NM_cmp_hidden[$Cada_col]) || $this->NM_cmp_hidden[$Cada_col] != "off"))
          {
             if (!NM_is_utf8($SC_Label))
              {
                  $SC_Label = mb_convert_encoding($SC_Label, "UTF-8", $_SESSION['scriptcase']['charset']);
              }
              $SC_Label = str_replace('<', '&lt;', $SC_Label);
              $SC_Label = str_replace('>', '&gt;', $SC_Label);
              $this->texto_tag .= "<td>" . $SC_Label . "</td>\r\n";
          }
          $SC_Label = (isset($this->New_label['alo'])) ? $this->New_label['alo'] : "ALO"; 
          if ($Cada_col == "alo" && (!isset($this->NM_cmp_hidden[$Cada_col]) || $this->NM_cmp_hidden[$Cada_col] != "off"))
          {
             if (!NM_is_utf8($SC_Label))
              {
                  $SC_Label = mb_convert_encoding($SC_Label, "UTF-8", $_SESSION['scriptcase']['charset']);
              }
              $SC_Label = str_replace('<', '&lt;', $SC_Label);
              $SC_Label = str_replace('>', '&gt;', $SC_Label);
              $this->texto_tag .= "<td>" . $SC_Label . "</td>\r\n";
          }
          $SC_Label = (isset($this->New_label['fin_no'])) ? $this->New_label['fin_no'] : "FIN NO"; 
          if ($Cada_col == "fin_no" && (!isset($this->NM_cmp_hidden[$Cada_col]) || $this->NM_cmp_hidden[$Cada_col] != "off"))
          {
             if (!NM_is_utf8($SC_Label))
              {
                  $SC_Label = mb_convert_encoding($SC_Label, "UTF-8", $_SESSION['scriptcase']['charset']);
              }
              $SC_Label = str_replace('<', '&lt;', $SC_Label);
              $SC_Label = str_replace('>', '&gt;', $SC_Label);
              $this->texto_tag .= "<td>" . $SC_Label . "</td>\r\n";
          }
          $SC_Label = (isset($this->New_label['putup'])) ? $this->New_label['putup'] : "PUTUP"; 
          if ($Cada_col == "putup" && (!isset($this->NM_cmp_hidden[$Cada_col]) || $this->NM_cmp_hidden[$Cada_col] != "off"))
          {
             if (!NM_is_utf8($SC_Label))
              {
                  $SC_Label = mb_convert_encoding($SC_Label, "UTF-8", $_SESSION['scriptcase']['charset']);
              }
              $SC_Label = str_replace('<', '&lt;', $SC_Label);
              $SC_Label = str_replace('>', '&gt;', $SC_Label);
              $this->texto_tag .= "<td>" . $SC_Label . "</td>\r\n";
          }
          $SC_Label = (isset($this->New_label['released'])) ? $this->New_label['released'] : "RELEASED"; 
          if ($Cada_col == "released" && (!isset($this->NM_cmp_hidden[$Cada_col]) || $this->NM_cmp_hidden[$Cada_col] != "off"))
          {
             if (!NM_is_utf8($SC_Label))
              {
                  $SC_Label = mb_convert_encoding($SC_Label, "UTF-8", $_SESSION['scriptcase']['charset']);
              }
              $SC_Label = str_replace('<', '&lt;', $SC_Label);
              $SC_Label = str_replace('>', '&gt;', $SC_Label);
              $this->texto_tag .= "<td>" . $SC_Label . "</td>\r\n";
          }
          $SC_Label = (isset($this->New_label['gross'])) ? $this->New_label['gross'] : "GROSS"; 
          if ($Cada_col == "gross" && (!isset($this->NM_cmp_hidden[$Cada_col]) || $this->NM_cmp_hidden[$Cada_col] != "off"))
          {
             if (!NM_is_utf8($SC_Label))
              {
                  $SC_Label = mb_convert_encoding($SC_Label, "UTF-8", $_SESSION['scriptcase']['charset']);
              }
              $SC_Label = str_replace('<', '&lt;', $SC_Label);
              $SC_Label = str_replace('>', '&gt;', $SC_Label);
              $this->texto_tag .= "<td>" . $SC_Label . "</td>\r\n";
          }
          $SC_Label = (isset($this->New_label['tare'])) ? $this->New_label['tare'] : "TARE"; 
          if ($Cada_col == "tare" && (!isset($this->NM_cmp_hidden[$Cada_col]) || $this->NM_cmp_hidden[$Cada_col] != "off"))
          {
             if (!NM_is_utf8($SC_Label))
              {
                  $SC_Label = mb_convert_encoding($SC_Label, "UTF-8", $_SESSION['scriptcase']['charset']);
              }
              $SC_Label = str_replace('<', '&lt;', $SC_Label);
              $SC_Label = str_replace('>', '&gt;', $SC_Label);
              $this->texto_tag .= "<td>" . $SC_Label . "</td>\r\n";
          }
          $SC_Label = (isset($this->New_label['net'])) ? $this->New_label['net'] : "NET"; 
          if ($Cada_col == "net" && (!isset($this->NM_cmp_hidden[$Cada_col]) || $this->NM_cmp_hidden[$Cada_col] != "off"))
          {
             if (!NM_is_utf8($SC_Label))
              {
                  $SC_Label = mb_convert_encoding($SC_Label, "UTF-8", $_SESSION['scriptcase']['charset']);
              }
              $SC_Label = str_replace('<', '&lt;', $SC_Label);
              $SC_Label = str_replace('>', '&gt;', $SC_Label);
              $this->texto_tag .= "<td>" . $SC_Label . "</td>\r\n";
          }
          $SC_Label = (isset($this->New_label['cyards'])) ? $this->New_label['cyards'] : "CYARDS"; 
          if ($Cada_col == "cyards" && (!isset($this->NM_cmp_hidden[$Cada_col]) || $this->NM_cmp_hidden[$Cada_col] != "off"))
          {
             if (!NM_is_utf8($SC_Label))
              {
                  $SC_Label = mb_convert_encoding($SC_Label, "UTF-8", $_SESSION['scriptcase']['charset']);
              }
              $SC_Label = str_replace('<', '&lt;', $SC_Label);
              $SC_Label = str_replace('>', '&gt;', $SC_Label);
              $this->texto_tag .= "<td>" . $SC_Label . "</td>\r\n";
          }
          $SC_Label = (isset($this->New_label['rcount'])) ? $this->New_label['rcount'] : "RCOUNT"; 
          if ($Cada_col == "rcount" && (!isset($this->NM_cmp_hidden[$Cada_col]) || $this->NM_cmp_hidden[$Cada_col] != "off"))
          {
             if (!NM_is_utf8($SC_Label))
              {
                  $SC_Label = mb_convert_encoding($SC_Label, "UTF-8", $_SESSION['scriptcase']['charset']);
              }
              $SC_Label = str_replace('<', '&lt;', $SC_Label);
              $SC_Label = str_replace('>', '&gt;', $SC_Label);
              $this->texto_tag .= "<td>" . $SC_Label . "</td>\r\n";
          }
          $SC_Label = (isset($this->New_label['estnet'])) ? $this->New_label['estnet'] : "ESTNET"; 
          if ($Cada_col == "estnet" && (!isset($this->NM_cmp_hidden[$Cada_col]) || $this->NM_cmp_hidden[$Cada_col] != "off"))
          {
             if (!NM_is_utf8($SC_Label))
              {
                  $SC_Label = mb_convert_encoding($SC_Label, "UTF-8", $_SESSION['scriptcase']['charset']);
              }
              $SC_Label = str_replace('<', '&lt;', $SC_Label);
              $SC_Label = str_replace('>', '&gt;', $SC_Label);
              $this->texto_tag .= "<td>" . $SC_Label . "</td>\r\n";
          }
          $SC_Label = (isset($this->New_label['nonetct'])) ? $this->New_label['nonetct'] : "NONETCT"; 
          if ($Cada_col == "nonetct" && (!isset($this->NM_cmp_hidden[$Cada_col]) || $this->NM_cmp_hidden[$Cada_col] != "off"))
          {
             if (!NM_is_utf8($SC_Label))
              {
                  $SC_Label = mb_convert_encoding($SC_Label, "UTF-8", $_SESSION['scriptcase']['charset']);
              }
              $SC_Label = str_replace('<', '&lt;', $SC_Label);
              $SC_Label = str_replace('>', '&gt;', $SC_Label);
              $this->texto_tag .= "<td>" . $SC_Label . "</td>\r\n";
          }
      } 
      $this->texto_tag .= "</tr>\r\n";
      while (!$rs->EOF)
      {
         $this->texto_tag .= "<tr>\r\n";
         $this->invoice = $rs->fields[0] ;  
         $this->p_o_number = $rs->fields[1] ;  
         $this->dye_lot = $rs->fields[2] ;  
         $this->location = $rs->fields[3] ;  
         $this->style = $rs->fields[4] ;  
         $this->color = $rs->fields[5] ;  
         $this->color_no = $rs->fields[6] ;  
         $this->width = $rs->fields[7] ;  
         $this->descriptio = $rs->fields[8] ;  
         $this->yards_recd = $rs->fields[9] ;  
         $this->yards_recd = (strpos(strtolower($this->yards_recd), "e")) ? (float)$this->yards_recd : $this->yards_recd; 
         $this->yards_recd = (string)$this->yards_recd;
         $this->shipped = $rs->fields[10] ;  
         $this->shipped = (strpos(strtolower($this->shipped), "e")) ? (float)$this->shipped : $this->shipped; 
         $this->shipped = (string)$this->shipped;
         $this->waste = $rs->fields[11] ;  
         $this->waste = (strpos(strtolower($this->waste), "e")) ? (float)$this->waste : $this->waste; 
         $this->waste = (string)$this->waste;
         $this->open = $rs->fields[12] ;  
         $this->open = (strpos(strtolower($this->open), "e")) ? (float)$this->open : $this->open; 
         $this->open = (string)$this->open;
         $this->sell_at = $rs->fields[13] ;  
         $this->finish = $rs->fields[14] ;  
         $this->other_lot = $rs->fields[15] ;  
         $this->cost = $rs->fields[16] ;  
         $this->cost = (strpos(strtolower($this->cost), "e")) ? (float)$this->cost : $this->cost; 
         $this->cost = (string)$this->cost;
         $this->amount = $rs->fields[17] ;  
         $this->amount =  str_replace(",", ".", $this->amount);
         $this->amount = (strpos(strtolower($this->amount), "e")) ? (float)$this->amount : $this->amount; 
         $this->amount = (string)$this->amount;
         $this->trans = $rs->fields[18] ;  
         $this->alo = $rs->fields[19] ;  
         $this->alo = (strpos(strtolower($this->alo), "e")) ? (float)$this->alo : $this->alo; 
         $this->alo = (string)$this->alo;
         $this->fin_no = $rs->fields[20] ;  
         $this->putup = $rs->fields[21] ;  
         $this->released = $rs->fields[22] ;  
         $this->released = (string)$this->released;
         $this->gross = $rs->fields[23] ;  
         $this->gross = (string)$this->gross;
         $this->tare = $rs->fields[24] ;  
         $this->tare = (string)$this->tare;
         $this->net = $rs->fields[25] ;  
         $this->net = (string)$this->net;
         $this->cyards = $rs->fields[26] ;  
         $this->cyards = (strpos(strtolower($this->cyards), "e")) ? (float)$this->cyards : $this->cyards; 
         $this->cyards = (string)$this->cyards;
         $this->rcount = $rs->fields[27] ;  
         $this->rcount = (string)$this->rcount;
         $this->estnet = $rs->fields[28] ;  
         $this->estnet = (string)$this->estnet;
         $this->nonetct = $rs->fields[29] ;  
         $this->nonetct = (string)$this->nonetct;
         $this->sc_proc_grid = true; 
         foreach ($_SESSION['sc_session'][$this->Ini->sc_page]['grid_fgstock']['field_order'] as $Cada_col)
         { 
            if (!isset($this->NM_cmp_hidden[$Cada_col]) || $this->NM_cmp_hidden[$Cada_col] != "off")
            { 
                $NM_func_exp = "NM_export_" . $Cada_col;
                $this->$NM_func_exp();
            } 
         } 
         $this->texto_tag .= "</tr>\r\n";
         $rs->MoveNext();
      }
      $this->texto_tag .= "</table>\r\n";

      $rs->Close();
   }
   //----- invoice
   function NM_export_invoice()
   {
         if (!NM_is_utf8($this->invoice))
         {
             $this->invoice = mb_convert_encoding($this->invoice, "UTF-8", $_SESSION['scriptcase']['charset']);
         }
          $this->invoice = str_replace('<', '&lt;', $this->invoice);
          $this->invoice = str_replace('>', '&gt;', $this->invoice);
         $this->texto_tag .= "<td>" . $this->invoice . "</td>\r\n";
   }
   //----- p_o_number
   function NM_export_p_o_number()
   {
         if (!NM_is_utf8($this->p_o_number))
         {
             $this->p_o_number = mb_convert_encoding($this->p_o_number, "UTF-8", $_SESSION['scriptcase']['charset']);
         }
          $this->p_o_number = str_replace('<', '&lt;', $this->p_o_number);
          $this->p_o_number = str_replace('>', '&gt;', $this->p_o_number);
         $this->texto_tag .= "<td>" . $this->p_o_number . "</td>\r\n";
   }
   //----- dye_lot
   function NM_export_dye_lot()
   {
         if (!NM_is_utf8($this->dye_lot))
         {
             $this->dye_lot = mb_convert_encoding($this->dye_lot, "UTF-8", $_SESSION['scriptcase']['charset']);
         }
          $this->dye_lot = str_replace('<', '&lt;', $this->dye_lot);
          $this->dye_lot = str_replace('>', '&gt;', $this->dye_lot);
         $this->texto_tag .= "<td>" . $this->dye_lot . "</td>\r\n";
   }
   //----- location
   function NM_export_location()
   {
         if (!NM_is_utf8($this->location))
         {
             $this->location = mb_convert_encoding($this->location, "UTF-8", $_SESSION['scriptcase']['charset']);
         }
          $this->location = str_replace('<', '&lt;', $this->location);
          $this->location = str_replace('>', '&gt;', $this->location);
         $this->texto_tag .= "<td>" . $this->location . "</td>\r\n";
   }
   //----- style
   function NM_export_style()
   {
         if (!NM_is_utf8($this->style))
         {
             $this->style = mb_convert_encoding($this->style, "UTF-8", $_SESSION['scriptcase']['charset']);
         }
          $this->style = str_replace('<', '&lt;', $this->style);
          $this->style = str_replace('>', '&gt;', $this->style);
         $this->texto_tag .= "<td>" . $this->style . "</td>\r\n";
   }
   //----- color
   function NM_export_color()
   {
         if (!NM_is_utf8($this->color))
         {
             $this->color = mb_convert_encoding($this->color, "UTF-8", $_SESSION['scriptcase']['charset']);
         }
          $this->color = str_replace('<', '&lt;', $this->color);
          $this->color = str_replace('>', '&gt;', $this->color);
         $this->texto_tag .= "<td>" . $this->color . "</td>\r\n";
   }
   //----- color_no
   function NM_export_color_no()
   {
         if (!NM_is_utf8($this->color_no))
         {
             $this->color_no = mb_convert_encoding($this->color_no, "UTF-8", $_SESSION['scriptcase']['charset']);
         }
          $this->color_no = str_replace('<', '&lt;', $this->color_no);
          $this->color_no = str_replace('>', '&gt;', $this->color_no);
         $this->texto_tag .= "<td>" . $this->color_no . "</td>\r\n";
   }
   //----- width
   function NM_export_width()
   {
         if (!NM_is_utf8($this->width))
         {
             $this->width = mb_convert_encoding($this->width, "UTF-8", $_SESSION['scriptcase']['charset']);
         }
          $this->width = str_replace('<', '&lt;', $this->width);
          $this->width = str_replace('>', '&gt;', $this->width);
         $this->texto_tag .= "<td>" . $this->width . "</td>\r\n";
   }
   //----- descriptio
   function NM_export_descriptio()
   {
         if (!NM_is_utf8($this->descriptio))
         {
             $this->descriptio = mb_convert_encoding($this->descriptio, "UTF-8", $_SESSION['scriptcase']['charset']);
         }
          $this->descriptio = str_replace('<', '&lt;', $this->descriptio);
          $this->descriptio = str_replace('>', '&gt;', $this->descriptio);
         $this->texto_tag .= "<td>" . $this->descriptio . "</td>\r\n";
   }
   //----- yards_recd
   function NM_export_yards_recd()
   {
         nmgp_Form_Num_Val($this->yards_recd, $_SESSION['scriptcase']['reg_conf']['grup_num'], $_SESSION['scriptcase']['reg_conf']['dec_num'], "3", "S", "2", "", "N:" . $_SESSION['scriptcase']['reg_conf']['neg_num'], $_SESSION['scriptcase']['reg_conf']['simb_neg'], $_SESSION['scriptcase']['reg_conf']['num_group_digit']) ; 
         if (!NM_is_utf8($this->yards_recd))
         {
             $this->yards_recd = mb_convert_encoding($this->yards_recd, "UTF-8", $_SESSION['scriptcase']['charset']);
         }
          $this->yards_recd = str_replace('<', '&lt;', $this->yards_recd);
          $this->yards_recd = str_replace('>', '&gt;', $this->yards_recd);
         $this->texto_tag .= "<td>" . $this->yards_recd . "</td>\r\n";
   }
   //----- shipped
   function NM_export_shipped()
   {
         nmgp_Form_Num_Val($this->shipped, $_SESSION['scriptcase']['reg_conf']['grup_num'], $_SESSION['scriptcase']['reg_conf']['dec_num'], "3", "S", "2", "", "N:" . $_SESSION['scriptcase']['reg_conf']['neg_num'], $_SESSION['scriptcase']['reg_conf']['simb_neg'], $_SESSION['scriptcase']['reg_conf']['num_group_digit']) ; 
         if (!NM_is_utf8($this->shipped))
         {
             $this->shipped = mb_convert_encoding($this->shipped, "UTF-8", $_SESSION['scriptcase']['charset']);
         }
          $this->shipped = str_replace('<', '&lt;', $this->shipped);
          $this->shipped = str_replace('>', '&gt;', $this->shipped);
         $this->texto_tag .= "<td>" . $this->shipped . "</td>\r\n";
   }
   //----- waste
   function NM_export_waste()
   {
         nmgp_Form_Num_Val($this->waste, $_SESSION['scriptcase']['reg_conf']['grup_num'], $_SESSION['scriptcase']['reg_conf']['dec_num'], "3", "S", "2", "", "N:" . $_SESSION['scriptcase']['reg_conf']['neg_num'], $_SESSION['scriptcase']['reg_conf']['simb_neg'], $_SESSION['scriptcase']['reg_conf']['num_group_digit']) ; 
         if (!NM_is_utf8($this->waste))
         {
             $this->waste = mb_convert_encoding($this->waste, "UTF-8", $_SESSION['scriptcase']['charset']);
         }
          $this->waste = str_replace('<', '&lt;', $this->waste);
          $this->waste = str_replace('>', '&gt;', $this->waste);
         $this->texto_tag .= "<td>" . $this->waste . "</td>\r\n";
   }
   //----- open
   function NM_export_open()
   {
         nmgp_Form_Num_Val($this->open, $_SESSION['scriptcase']['reg_conf']['grup_num'], $_SESSION['scriptcase']['reg_conf']['dec_num'], "3", "S", "2", "", "N:" . $_SESSION['scriptcase']['reg_conf']['neg_num'], $_SESSION['scriptcase']['reg_conf']['simb_neg'], $_SESSION['scriptcase']['reg_conf']['num_group_digit']) ; 
         if (!NM_is_utf8($this->open))
         {
             $this->open = mb_convert_encoding($this->open, "UTF-8", $_SESSION['scriptcase']['charset']);
         }
          $this->open = str_replace('<', '&lt;', $this->open);
          $this->open = str_replace('>', '&gt;', $this->open);
         $this->texto_tag .= "<td>" . $this->open . "</td>\r\n";
   }
   //----- sell_at
   function NM_export_sell_at()
   {
         if (!NM_is_utf8($this->sell_at))
         {
             $this->sell_at = mb_convert_encoding($this->sell_at, "UTF-8", $_SESSION['scriptcase']['charset']);
         }
          $this->sell_at = str_replace('<', '&lt;', $this->sell_at);
          $this->sell_at = str_replace('>', '&gt;', $this->sell_at);
         $this->texto_tag .= "<td>" . $this->sell_at . "</td>\r\n";
   }
   //----- finish
   function NM_export_finish()
   {
         if (!NM_is_utf8($this->finish))
         {
             $this->finish = mb_convert_encoding($this->finish, "UTF-8", $_SESSION['scriptcase']['charset']);
         }
          $this->finish = str_replace('<', '&lt;', $this->finish);
          $this->finish = str_replace('>', '&gt;', $this->finish);
         $this->texto_tag .= "<td>" . $this->finish . "</td>\r\n";
   }
   //----- other_lot
   function NM_export_other_lot()
   {
         if (!NM_is_utf8($this->other_lot))
         {
             $this->other_lot = mb_convert_encoding($this->other_lot, "UTF-8", $_SESSION['scriptcase']['charset']);
         }
          $this->other_lot = str_replace('<', '&lt;', $this->other_lot);
          $this->other_lot = str_replace('>', '&gt;', $this->other_lot);
         $this->texto_tag .= "<td>" . $this->other_lot . "</td>\r\n";
   }
   //----- cost
   function NM_export_cost()
   {
         nmgp_Form_Num_Val($this->cost, $_SESSION['scriptcase']['reg_conf']['grup_num'], $_SESSION['scriptcase']['reg_conf']['dec_num'], "3", "S", "2", "", "N:" . $_SESSION['scriptcase']['reg_conf']['neg_num'], $_SESSION['scriptcase']['reg_conf']['simb_neg'], $_SESSION['scriptcase']['reg_conf']['num_group_digit']) ; 
         if (!NM_is_utf8($this->cost))
         {
             $this->cost = mb_convert_encoding($this->cost, "UTF-8", $_SESSION['scriptcase']['charset']);
         }
          $this->cost = str_replace('<', '&lt;', $this->cost);
          $this->cost = str_replace('>', '&gt;', $this->cost);
         $this->texto_tag .= "<td>" . $this->cost . "</td>\r\n";
   }
   //----- amount
   function NM_export_amount()
   {
         nmgp_Form_Num_Val($this->amount, $_SESSION['scriptcase']['reg_conf']['grup_val'], $_SESSION['scriptcase']['reg_conf']['dec_val'], "2", "S", "2", "", "V:" . $_SESSION['scriptcase']['reg_conf']['monet_f_pos'] . ":" . $_SESSION['scriptcase']['reg_conf']['monet_f_neg'], $_SESSION['scriptcase']['reg_conf']['simb_neg'], $_SESSION['scriptcase']['reg_conf']['unid_mont_group_digit']) ; 
         if (!NM_is_utf8($this->amount))
         {
             $this->amount = mb_convert_encoding($this->amount, "UTF-8", $_SESSION['scriptcase']['charset']);
         }
          $this->amount = str_replace('<', '&lt;', $this->amount);
          $this->amount = str_replace('>', '&gt;', $this->amount);
         $this->texto_tag .= "<td>" . $this->amount . "</td>\r\n";
   }
   //----- trans
   function NM_export_trans()
   {
         if (!NM_is_utf8($this->trans))
         {
             $this->trans = mb_convert_encoding($this->trans, "UTF-8", $_SESSION['scriptcase']['charset']);
         }
          $this->trans = str_replace('<', '&lt;', $this->trans);
          $this->trans = str_replace('>', '&gt;', $this->trans);
         $this->texto_tag .= "<td>" . $this->trans . "</td>\r\n";
   }
   //----- alo
   function NM_export_alo()
   {
         nmgp_Form_Num_Val($this->alo, $_SESSION['scriptcase']['reg_conf']['grup_num'], $_SESSION['scriptcase']['reg_conf']['dec_num'], "3", "S", "2", "", "N:" . $_SESSION['scriptcase']['reg_conf']['neg_num'], $_SESSION['scriptcase']['reg_conf']['simb_neg'], $_SESSION['scriptcase']['reg_conf']['num_group_digit']) ; 
         if (!NM_is_utf8($this->alo))
         {
             $this->alo = mb_convert_encoding($this->alo, "UTF-8", $_SESSION['scriptcase']['charset']);
         }
          $this->alo = str_replace('<', '&lt;', $this->alo);
          $this->alo = str_replace('>', '&gt;', $this->alo);
         $this->texto_tag .= "<td>" . $this->alo . "</td>\r\n";
   }
   //----- fin_no
   function NM_export_fin_no()
   {
         if (!NM_is_utf8($this->fin_no))
         {
             $this->fin_no = mb_convert_encoding($this->fin_no, "UTF-8", $_SESSION['scriptcase']['charset']);
         }
          $this->fin_no = str_replace('<', '&lt;', $this->fin_no);
          $this->fin_no = str_replace('>', '&gt;', $this->fin_no);
         $this->texto_tag .= "<td>" . $this->fin_no . "</td>\r\n";
   }
   //----- putup
   function NM_export_putup()
   {
         if (!NM_is_utf8($this->putup))
         {
             $this->putup = mb_convert_encoding($this->putup, "UTF-8", $_SESSION['scriptcase']['charset']);
         }
          $this->putup = str_replace('<', '&lt;', $this->putup);
          $this->putup = str_replace('>', '&gt;', $this->putup);
         $this->texto_tag .= "<td>" . $this->putup . "</td>\r\n";
   }
   //----- released
   function NM_export_released()
   {
         nmgp_Form_Num_Val($this->released, $_SESSION['scriptcase']['reg_conf']['grup_num'], $_SESSION['scriptcase']['reg_conf']['dec_num'], "0", "S", "2", "", "N:" . $_SESSION['scriptcase']['reg_conf']['neg_num'] , $_SESSION['scriptcase']['reg_conf']['simb_neg'], $_SESSION['scriptcase']['reg_conf']['num_group_digit']) ; 
         if (!NM_is_utf8($this->released))
         {
             $this->released = mb_convert_encoding($this->released, "UTF-8", $_SESSION['scriptcase']['charset']);
         }
          $this->released = str_replace('<', '&lt;', $this->released);
          $this->released = str_replace('>', '&gt;', $this->released);
         $this->texto_tag .= "<td>" . $this->released . "</td>\r\n";
   }
   //----- gross
   function NM_export_gross()
   {
         nmgp_Form_Num_Val($this->gross, $_SESSION['scriptcase']['reg_conf']['grup_num'], $_SESSION['scriptcase']['reg_conf']['dec_num'], "0", "S", "2", "", "N:" . $_SESSION['scriptcase']['reg_conf']['neg_num'] , $_SESSION['scriptcase']['reg_conf']['simb_neg'], $_SESSION['scriptcase']['reg_conf']['num_group_digit']) ; 
         if (!NM_is_utf8($this->gross))
         {
             $this->gross = mb_convert_encoding($this->gross, "UTF-8", $_SESSION['scriptcase']['charset']);
         }
          $this->gross = str_replace('<', '&lt;', $this->gross);
          $this->gross = str_replace('>', '&gt;', $this->gross);
         $this->texto_tag .= "<td>" . $this->gross . "</td>\r\n";
   }
   //----- tare
   function NM_export_tare()
   {
         nmgp_Form_Num_Val($this->tare, $_SESSION['scriptcase']['reg_conf']['grup_num'], $_SESSION['scriptcase']['reg_conf']['dec_num'], "0", "S", "2", "", "N:" . $_SESSION['scriptcase']['reg_conf']['neg_num'] , $_SESSION['scriptcase']['reg_conf']['simb_neg'], $_SESSION['scriptcase']['reg_conf']['num_group_digit']) ; 
         if (!NM_is_utf8($this->tare))
         {
             $this->tare = mb_convert_encoding($this->tare, "UTF-8", $_SESSION['scriptcase']['charset']);
         }
          $this->tare = str_replace('<', '&lt;', $this->tare);
          $this->tare = str_replace('>', '&gt;', $this->tare);
         $this->texto_tag .= "<td>" . $this->tare . "</td>\r\n";
   }
   //----- net
   function NM_export_net()
   {
         nmgp_Form_Num_Val($this->net, $_SESSION['scriptcase']['reg_conf']['grup_num'], $_SESSION['scriptcase']['reg_conf']['dec_num'], "0", "S", "2", "", "N:" . $_SESSION['scriptcase']['reg_conf']['neg_num'] , $_SESSION['scriptcase']['reg_conf']['simb_neg'], $_SESSION['scriptcase']['reg_conf']['num_group_digit']) ; 
         if (!NM_is_utf8($this->net))
         {
             $this->net = mb_convert_encoding($this->net, "UTF-8", $_SESSION['scriptcase']['charset']);
         }
          $this->net = str_replace('<', '&lt;', $this->net);
          $this->net = str_replace('>', '&gt;', $this->net);
         $this->texto_tag .= "<td>" . $this->net . "</td>\r\n";
   }
   //----- cyards
   function NM_export_cyards()
   {
         nmgp_Form_Num_Val($this->cyards, $_SESSION['scriptcase']['reg_conf']['grup_num'], $_SESSION['scriptcase']['reg_conf']['dec_num'], "3", "S", "2", "", "N:" . $_SESSION['scriptcase']['reg_conf']['neg_num'], $_SESSION['scriptcase']['reg_conf']['simb_neg'], $_SESSION['scriptcase']['reg_conf']['num_group_digit']) ; 
         if (!NM_is_utf8($this->cyards))
         {
             $this->cyards = mb_convert_encoding($this->cyards, "UTF-8", $_SESSION['scriptcase']['charset']);
         }
          $this->cyards = str_replace('<', '&lt;', $this->cyards);
          $this->cyards = str_replace('>', '&gt;', $this->cyards);
         $this->texto_tag .= "<td>" . $this->cyards . "</td>\r\n";
   }
   //----- rcount
   function NM_export_rcount()
   {
         nmgp_Form_Num_Val($this->rcount, $_SESSION['scriptcase']['reg_conf']['grup_num'], $_SESSION['scriptcase']['reg_conf']['dec_num'], "0", "S", "2", "", "N:" . $_SESSION['scriptcase']['reg_conf']['neg_num'] , $_SESSION['scriptcase']['reg_conf']['simb_neg'], $_SESSION['scriptcase']['reg_conf']['num_group_digit']) ; 
         if (!NM_is_utf8($this->rcount))
         {
             $this->rcount = mb_convert_encoding($this->rcount, "UTF-8", $_SESSION['scriptcase']['charset']);
         }
          $this->rcount = str_replace('<', '&lt;', $this->rcount);
          $this->rcount = str_replace('>', '&gt;', $this->rcount);
         $this->texto_tag .= "<td>" . $this->rcount . "</td>\r\n";
   }
   //----- estnet
   function NM_export_estnet()
   {
         nmgp_Form_Num_Val($this->estnet, $_SESSION['scriptcase']['reg_conf']['grup_num'], $_SESSION['scriptcase']['reg_conf']['dec_num'], "0", "S", "2", "", "N:" . $_SESSION['scriptcase']['reg_conf']['neg_num'] , $_SESSION['scriptcase']['reg_conf']['simb_neg'], $_SESSION['scriptcase']['reg_conf']['num_group_digit']) ; 
         if (!NM_is_utf8($this->estnet))
         {
             $this->estnet = mb_convert_encoding($this->estnet, "UTF-8", $_SESSION['scriptcase']['charset']);
         }
          $this->estnet = str_replace('<', '&lt;', $this->estnet);
          $this->estnet = str_replace('>', '&gt;', $this->estnet);
         $this->texto_tag .= "<td>" . $this->estnet . "</td>\r\n";
   }
   //----- nonetct
   function NM_export_nonetct()
   {
         nmgp_Form_Num_Val($this->nonetct, $_SESSION['scriptcase']['reg_conf']['grup_num'], $_SESSION['scriptcase']['reg_conf']['dec_num'], "0", "S", "2", "", "N:" . $_SESSION['scriptcase']['reg_conf']['neg_num'] , $_SESSION['scriptcase']['reg_conf']['simb_neg'], $_SESSION['scriptcase']['reg_conf']['num_group_digit']) ; 
         if (!NM_is_utf8($this->nonetct))
         {
             $this->nonetct = mb_convert_encoding($this->nonetct, "UTF-8", $_SESSION['scriptcase']['charset']);
         }
          $this->nonetct = str_replace('<', '&lt;', $this->nonetct);
          $this->nonetct = str_replace('>', '&gt;', $this->nonetct);
         $this->texto_tag .= "<td>" . $this->nonetct . "</td>\r\n";
   }

   //----- 
   function grava_arquivo_rtf()
   {
      global $nm_lang, $doc_wrap;
      $rtf_f = fopen($this->Ini->root . $this->Ini->path_imag_temp . "/" . $this->arquivo, "w");
      require_once($this->Ini->path_third      . "/rtf_new/document_generator/cl_xml2driver.php"); 
      $text_ok  =  "<?xml version=\"1.0\" encoding=\"UTF-8\" ?>\r\n"; 
      $text_ok .=  "<DOC config_file=\"" . $this->Ini->path_third . "/rtf_new/doc_config.inc\" >\r\n"; 
      $text_ok .=  $this->texto_tag; 
      $text_ok .=  "</DOC>\r\n"; 
      $xml = new nDOCGEN($text_ok,"RTF"); 
      fwrite($rtf_f, $xml->get_result_file());
      fclose($rtf_f);
   }

   function nm_conv_data_db($dt_in, $form_in, $form_out)
   {
       $dt_out = $dt_in;
       if (strtoupper($form_in) == "DB_FORMAT")
       {
           if ($dt_out == "null" || $dt_out == "")
           {
               $dt_out = "";
               return $dt_out;
           }
           $form_in = "AAAA-MM-DD";
       }
       if (strtoupper($form_out) == "DB_FORMAT")
       {
           if (empty($dt_out))
           {
               $dt_out = "null";
               return $dt_out;
           }
           $form_out = "AAAA-MM-DD";
       }
       nm_conv_form_data($dt_out, $form_in, $form_out);
       return $dt_out;
   }
   //---- 
   function monta_html()
   {
      global $nm_url_saida, $nm_lang;
      include($this->Ini->path_btn . $this->Ini->Str_btn_grid);
      unset($_SESSION['sc_session'][$this->Ini->sc_page]['grid_fgstock']['rtf_file']);
      if (is_file($this->Ini->root . $this->Ini->path_imag_temp . "/" . $this->arquivo))
      {
          $_SESSION['sc_session'][$this->Ini->sc_page]['grid_fgstock']['rtf_file'] = $this->Ini->root . $this->Ini->path_imag_temp . "/" . $this->arquivo;
      }
?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
            "http://www.w3.org/TR/1999/REC-html401-19991224/loose.dtd">
<HTML<?php echo $_SESSION['scriptcase']['reg_conf']['html_dir'] ?>>
<HEAD>
 <TITLE><?php echo $this->Ini->Nm_lang['lang_othr_grid_titl'] ?> - fgstock :: RTF</TITLE>
 <META http-equiv="Content-Type" content="text/html; charset=<?php echo $_SESSION['scriptcase']['charset_html'] ?>" />
  <META http-equiv="Expires" content="Fri, Jan 01 1900 00:00:00 GMT"/>
  <META http-equiv="Last-Modified" content="<?php echo gmdate("D, d M Y H:i:s"); ?> GMT"/>
  <META http-equiv="Cache-Control" content="no-store, no-cache, must-revalidate"/>
  <META http-equiv="Cache-Control" content="post-check=0, pre-check=0"/>
  <META http-equiv="Pragma" content="no-cache"/>
  <link rel="stylesheet" type="text/css" href="../_lib/css/<?php echo $this->Ini->str_schema_all ?>_export.css" /> 
  <link rel="stylesheet" type="text/css" href="../_lib/buttons/<?php echo $this->Ini->Str_btn_css ?>" /> 
</HEAD>
<BODY class="scExportPage">
<?php echo $this->Ini->Ajax_result_set ?>
<table style="border-collapse: collapse; border-width: 0; height: 100%; width: 100%"><tr><td style="padding: 0; text-align: center; vertical-align: middle">
 <table class="scExportTable" align="center">
  <tr>
   <td class="scExportTitle" style="height: 25px">RTF</td>
  </tr>
  <tr>
   <td class="scExportLine" style="width: 100%">
    <table style="border-collapse: collapse; border-width: 0; width: 100%"><tr><td class="scExportLineFont" style="padding: 3px 0 0 0" id="idMessage">
    <?php echo $this->Ini->Nm_lang['lang_othr_file_msge'] ?>
    </td><td class="scExportLineFont" style="text-align:right; padding: 3px 0 0 0">
     <?php echo nmButtonOutput($this->arr_buttons, "bexportview", "document.Fview.submit()", "document.Fview.submit()", "idBtnView", "", "", "", "", "", "", $this->Ini->path_botoes, "", "", "", "", "", "only_text", "text_right", "", "");
 ?>
     <?php echo nmButtonOutput($this->arr_buttons, "bdownload", "document.Fdown.submit()", "document.Fdown.submit()", "idBtnDown", "", "", "", "", "", "", $this->Ini->path_botoes, "", "", "", "", "", "only_text", "text_right", "", "");
 ?>
     <?php echo nmButtonOutput($this->arr_buttons, "bvoltar", "document.F0.submit()", "document.F0.submit()", "idBtnBack", "", "", "", "", "", "", $this->Ini->path_botoes, "", "", "", "", "", "only_text", "text_right", "", "");
 ?>
    </td></tr></table>
   </td>
  </tr>
 </table>
</td></tr></table>
<form name="Fview" method="get" action="<?php echo $this->Ini->path_imag_temp . "/" . $this->arquivo ?>" target="_blank" style="display: none"> 
</form>
<form name="Fdown" method="get" action="grid_fgstock_download.php" target="_blank" style="display: none"> 
<input type="hidden" name="nm_tit_doc" value="<?php echo NM_encode_input($this->tit_doc); ?>"> 
<input type="hidden" name="nm_name_doc" value="<?php echo NM_encode_input($this->Ini->path_imag_temp . "/" . $this->arquivo) ?>"> 
</form>
<FORM name="F0" method=post action="./"> 
<INPUT type="hidden" name="script_case_init" value="<?php echo NM_encode_input($this->Ini->sc_page); ?>"> 
<INPUT type="hidden" name="script_case_session" value="<?php echo NM_encode_input(session_id()); ?>"> 
<INPUT type="hidden" name="nmgp_opcao" value="volta_grid"> 
</FORM> 
</BODY>
</HTML>
<?php
   }
   function nm_gera_mask(&$nm_campo, $nm_mask)
   { 
      $trab_campo = $nm_campo;
      $trab_mask  = $nm_mask;
      $tam_campo  = strlen($nm_campo);
      $trab_saida = "";
      $mask_num = false;
      for ($x=0; $x < strlen($trab_mask); $x++)
      {
          if (substr($trab_mask, $x, 1) == "#")
          {
              $mask_num = true;
              break;
          }
      }
      if ($mask_num )
      {
          $ver_duas = explode(";", $trab_mask);
          if (isset($ver_duas[1]) && !empty($ver_duas[1]))
          {
              $cont1 = count(explode("#", $ver_duas[0])) - 1;
              $cont2 = count(explode("#", $ver_duas[1])) - 1;
              if ($cont2 >= $tam_campo)
              {
                  $trab_mask = $ver_duas[1];
              }
              else
              {
                  $trab_mask = $ver_duas[0];
              }
          }
          $tam_mask = strlen($trab_mask);
          $xdados = 0;
          for ($x=0; $x < $tam_mask; $x++)
          {
              if (substr($trab_mask, $x, 1) == "#" && $xdados < $tam_campo)
              {
                  $trab_saida .= substr($trab_campo, $xdados, 1);
                  $xdados++;
              }
              elseif ($xdados < $tam_campo)
              {
                  $trab_saida .= substr($trab_mask, $x, 1);
              }
          }
          if ($xdados < $tam_campo)
          {
              $trab_saida .= substr($trab_campo, $xdados);
          }
          $nm_campo = $trab_saida;
          return;
      }
      for ($ix = strlen($trab_mask); $ix > 0; $ix--)
      {
           $char_mask = substr($trab_mask, $ix - 1, 1);
           if ($char_mask != "x" && $char_mask != "z")
           {
               $trab_saida = $char_mask . $trab_saida;
           }
           else
           {
               if ($tam_campo != 0)
               {
                   $trab_saida = substr($trab_campo, $tam_campo - 1, 1) . $trab_saida;
                   $tam_campo--;
               }
               else
               {
                   $trab_saida = "0" . $trab_saida;
               }
           }
      }
      if ($tam_campo != 0)
      {
          $trab_saida = substr($trab_campo, 0, $tam_campo) . $trab_saida;
          $trab_mask  = str_repeat("z", $tam_campo) . $trab_mask;
      }
   
      $iz = 0; 
      for ($ix = 0; $ix < strlen($trab_mask); $ix++)
      {
           $char_mask = substr($trab_mask, $ix, 1);
           if ($char_mask != "x" && $char_mask != "z")
           {
               if ($char_mask == "." || $char_mask == ",")
               {
                   $trab_saida = substr($trab_saida, 0, $iz) . substr($trab_saida, $iz + 1);
               }
               else
               {
                   $iz++;
               }
           }
           elseif ($char_mask == "x" || substr($trab_saida, $iz, 1) != "0")
           {
               $ix = strlen($trab_mask) + 1;
           }
           else
           {
               $trab_saida = substr($trab_saida, 0, $iz) . substr($trab_saida, $iz + 1);
           }
      }
      $nm_campo = $trab_saida;
   } 
}

?>
