#!/usr/bin/ruby
# frozen_string_literal: true

# Diese Software unterliegt der GPL
# Copyright Karlheinz Klingbeil

require 'securerandom'
require 'parseconfig'
require 'optparse'
require 'syslog'
require 'fileutils'
require 'mysql2'
require 'time'

BANNER = 'dmc 0.3/17.07.2025'
CONFIGFILE = '/etc/dmc.secrets'
TMPFILES_EXTENSIONS = ['', '.png', '.txt'].freeze
DEFAULT_VALUE = ' '
DEFAULT_PRINTERNAME = 'labordrucker'
PCL_COMMAND = '/usr/local/bin/pcl6'
TESSERACT_COMMAND = '/usr/bin/tesseract'

class Dmc
  def initialize
    Encoding.default_external = Encoding::UTF_8
    Encoding.default_internal = Encoding::UTF_8
    $stdout = File.new('/dev/null', 'w')
    @config = {}
    @daten = {}
    log BANNER
    @config[:tmpfile] = ''
    @config[:printername] = DEFAULT_PRINTERNAME
    @config[:pcl_command] = PCL_COMMAND
    @config[:tesseract_command] = TESSERACT_COMMAND
    OptionParser.new do |opts|
      opts.banner = 'Usage: dmc2 [options]'
      opts.on('-p', '--printer', 'print directly') { |v| @config[:printer] = v }
      opts.on('-f', '--file name', 'input file') { |v| @config[:tmpfile] = v }
      opts.on('-n', '--printer name', 'input file') { |v| @config[:printername] = v }
    end.parse!
    readConfig CONFIGFILE
    createTmpFile
    convert
    cleanup
  end

  def readConfig(configfile)
    configdata = ParseConfig.new(configfile)
    @config[:temp_extensions] = TMPFILES_EXTENSIONS
    @config[:temp_dir] = configdata['temp_dir']
    @config[:out_dir] = configdata['out_dir']
    @config[:stdin] = false
    if @config[:tmpfile].empty?
      @config[:tmpfile] = File.join(configdata['temp_dir'], SecureRandom.uuid)
      @config[:stdin] = true
    end
    log "File=#{@config[:tmpfile]}"
    @config[:now] = Time.new
    @config[:tif_tmp] = "#{@config[:tmpfile]}.png"
    @config[:txt_tmp] = @config[:tmpfile]
    @config[:out_basefilename] = @config[:now].strftime('%Y-%m-%d-%H-%M')
    @config[:mysql_host] = configdata['mysql_host']
    @config[:mysql_database] = configdata['mysql_database']
    @config[:mysql_user] = configdata['mysql_user']
    @config[:mysql_passwd] = configdata['mysql_passwd']
    @config[:printername] = configdata['printername']
    @config[:pcl_command] = configdata['pcl_command']
    @config[:tesseract_command] = configdata['tesseract_command']
    @daten[:d_bezeichnung] = [/bezeichnung/, DEFAULT_VALUE, 'bezeichnung']
    @daten[:d_losnummer] = [/losnummer/, DEFAULT_VALUE, 'losnummer']
    @daten[:d_firmware] = [/Firmwareversion:/, DEFAULT_VALUE, 'firmware']
    @daten[:d_dma_seriennummer] = [/DMA.*Dichte.*Seriennummer:/, DEFAULT_VALUE, 'dma_seriennummer']
    @daten[:d_xsample_seriennummer] = [/.*xsample.*Seriennummer:.*/, DEFAULT_VALUE, 'xsample_seriennummer']
    @daten[:d_proben_id] = [/Eindeutige.*Probennr.:/, DEFAULT_VALUE, 'proben_id']
    @daten[:d_datum] = [/Datum:/, DEFAULT_VALUE, 'datum']
    @daten[:d_zeit] = [/Zeit:/, DEFAULT_VALUE, 'zeit']
    @daten[:d_staerke] = [/Ethanol.*OIML.*\(.*\):/, DEFAULT_VALUE, 'staerke']
    @daten[:d_dichte_temperatur] = [/Dichte Temperatur:/, DEFAULT_VALUE, 'dichte_temperatur']
    @daten[:d_relative_dichte] = [/Relative Dichte:/, DEFAULT_VALUE, 'rel_dichte']
    @daten[:d_dichte] = [/Dichte:.*g/, DEFAULT_VALUE, 'dichte']
    @daten[:d_feld_1] = [/Feld 1:/, DEFAULT_VALUE, 'feld1']
    @daten[:d_feld_2] = [/Feld 2/, DEFAULT_VALUE, 'feld2']
    @daten[:d_feld_3] = [/Feld 3/, DEFAULT_VALUE, 'feld3']
    @daten[:d_status] = [/Dichte Status:/, DEFAULT_VALUE, 'status']
    @daten[:d_zucker] = [/Zucker/, DEFAULT_VALUE, 'zucker']
    @daten[:d_extrakt] = [/.*trakt.*:/, DEFAULT_VALUE, 'extrakt']
    @daten[:d_datum_zeit] = [/datum_zeit/, @config[:now].strftime('%Y-%m-%d %H:%M:%S'), 'datum_zeit']
  end

  def convert
    log 'convert'
    cmd = "#{@config[:pcl_command]} -r300 -dNOPAUSE -sDEVICE=pngmono -o #{@config[:tif_tmp]} #{@config[:tmpfile]}"
    log cmd
    `#{cmd}`
    cmd = "#{@config[:tesseract_command]} #{@config[:tif_tmp]}  #{@config[:txt_tmp]}   -l deu"
    log cmd
    `#{cmd}`
    readTxt
    writeOutputFiles
    if !@config[:printer].nil?
      printDirect
    elsif writeDatabase
    end
  end

  def printDirect
    cmd = "/usr/bin/lp -d#{@config[:printername]} #{@config[:tmpfile]}"
    log cmd
    `#{cmd}`
  end

  def writeDatabase
    con = Mysql2::Client.new(host: @config[:mysql_host], username: @config[:mysql_user],
                             password: @config[:mysql_passwd], database: @config[:mysql_database])
    columns = ''
    values = ''
    @daten.each_value do |value|
      columns += "#{value[2]},"
      values += "'#{value[1]}',"
      log "c=#{value[2]} == #{value[1]}"
    end
    columns = columns.chop
    values = values.chop
    if columns.length > 1 && values.length > 1
      cmd = "INSERT INTO dm (#{columns}) VALUES (#{values})"
      log cmd
      con.query(cmd)
    end
    return if con.nil?

    con.close
  end

  def writeOutputFiles
    output_dir = File.join(@config[:out_dir], @config[:now].strftime('%Y'), @config[:now].strftime('%-m'),
                           "#{@config[:now].strftime('%Y')}-#{@config[:now].strftime('%m')}-#{@config[:now].strftime('%d')}")
    FileUtils.mkdir_p output_dir
    output_pdf_file = File.join(output_dir,
                                "#{@config[:out_basefilename]}__#{@daten[:d_proben_id][1].gsub(/\s+/, '')}.pdf")
    cmd = "#{@config[:pcl_command]} -r300 -dNOPAUSE -sDEVICE=pdfwrite -o #{output_pdf_file}  #{@config[:tmpfile]}"
    log cmd
    `#{cmd}`
    output_text_file = File.join(output_dir,
                                 "#{@config[:out_basefilename]}__#{@daten[:d_proben_id][1].gsub(/\s+/, '')}.txt")
    cmd = "cp #{@config[:tmpfile]}.txt #{output_text_file}"
    log cmd
    `#{cmd}`
  end

  def readTxt
    textfile = "#{@config[:txt_tmp]}.txt"
    log "Reading textfile : #{textfile}"
    lines = File.readlines(textfile)
    lines.each do |line|
      @daten.each_value do |value|
        match = line.match(value[0])
        value[1] = line[line.index(':') + 1..].strip unless match.nil?
      end
    end
    begin
      @daten[:d_datum_zeit][1] =
        Time.parse("#{@daten[:d_datum][1]} #{@daten[:d_zeit][1]}").strftime('%Y-%m-%d %H:%M:%S')
    rescue ArgumentError
      @daten[:d_datum_zeit][1] = Time.new.to_s
    end
    log "datum: #{@daten[:d_datum_zeit][1]}"
  end

  def createTmpFile
    return unless @config[:stdin] == true

    f = $stdin.read
    log "Create Temp File :#{@config[:tmpfile]}"
    tmp = File.open(@config[:tmpfile], 'w')
    tmp.write(f)
    tmp.close
  end

  def cleanup
    @config[:temp_extensions].each do |ext|
      del = @config[:tmpfile] + ext
      if File.exist?(del)
        log "Delete Temp File :#{del}"
        File.delete(del)
      end
    end
  end

  def getTimeStamp
    date = Time.new
    date.strftime('%Y-%m-%d-%H-%M-%S')
  end

  def log(str)
    str = "#{getTimeStamp} :#{str}\n"
    str = str.sub('%', 'P')
    puts str
    Syslog.open($PROGRAM_NAME, Syslog::LOG_PID | Syslog::LOG_CONS)
    Syslog.log(Syslog::LOG_PID, str)
    Syslog.close
  end
end

Dmc.new
