%table.table
  %tr
    -@table_header.each do |th|
      %th=th
  -@table.each do |tr|
    %tr
      -tr.each do |td|
        %td=td





-if false



  - client = TinyTds::Client.new(username: 'test', password: '@Chatenois!2017', host: '40.89.153.193', appname: "SQL4PS" , port: 1534, database: "JIPE")

  -if false
    -dimensions = client.execute("SELECT TOP 500 * FROM dbo.[JIPE$Purch_ Inv_ Header]")
    -dimensions_results = []
    -dimensions.each do |d|
      -dimensions_results << d

    -dimensions.cancel



  -r = client.execute("SELECT TOP 500 * FROM dbo.[JIPE$Purch_ Inv_ Header] WHERE [Document Date] >= '2019-06-01' AND [Document Date] <  '2019-06-30';")
  =r.count
  -if r.count > 0
    %table.table.table-striped
      %tr
        -ic = 0
        -r.each do |row|
          -ic += 1
          -if ic == 1
            -row.each do |k,v|
              %th
                =k
          
          
      -r.each do |row|
        %tr
          -row.each do |k,v|
            %td
              -if v.class == String
                =v.encode("UTF-8", :invalid => :replace, :undef => :replace)
              -else
                =v

  -r.cancel


-if false

  %table.table
    -SComptaAccount.group(:code).order(:code).each do |sca|
      %tr
        %td=sca.code
        %td=sca.name
        %td
          -sca = SComptaAccount.where(:code => sca.code, :zone => "FRANCE").first
          =sca.account
        %td
          =sca.zone

-client = TinyTds::Client.new(username: 'test', password: '@Chatenois!2017', host: '40.89.153.193', appname: "SQL4PS" , port: 1534, database: "JIPE")
        
%table.table
  -SComptaAccount.where("id >= 172").order(:code).each do |sca|
    %tr
      %td=sca.code
      %td=sca.name
      %td
        =sca.account
        
        -if false
          -a = client.execute("SELECT TOP 1000 * FROM dbo.[JIPE$VAT Posting Setup] WHERE [VAT Prod_ Posting Group] = '#{sca.code}' AND [VAT Bus_ Posting Group] = '#{sca.zone}';")
          -a.count
          -a.cancel
        
          -a.each do |aa|
            -sca.account = aa["Purchase VAT Account"]
            -sca.save
        
      %td
        =sca.zone
        
SELECT TOP 1000 * FROM dbo.[JIPE$VAT Posting Setup] WHERE [VAT Prod_ Posting Group] = 'NORM2014' AND [VAT Bus_ Posting Group] = '';