#!/bin/bash

SQL="mysql -Bs --force -uroot -peuro2000 eurotest"
USB_MOUNTPOINT="/mnt/backup"
#SQL="cat"
export LANG=en_US.UTF-8
export PATH=`pwd`:$PATH
VOKNO_NAME='Import da Nettun@3000/Nettun@7000Plus'
HOST=`hostname`
DEVEL_HOST=0
if [ $HOST == 'sunshine.spintec.it' ]
then
  DEVEL_HOST=1
  SQL="mysql -uroot eurotest"
fi

sysmsg "$VOKNO_NAME" "Inserire PenDrive con salvataggio da importare e premere il bottone OK. La conversione durera' alcuni secondi..."

rm -rf /tmp/presetting_files
if [ -d "$USB_MOUNTPOINT/crf7100/presetting_files" -a -d "$USB_MOUNTPOINT/crf3000/presetting_files" ]
then
  sysmsg "$VOKNO_NAME" "Trovati salvataggi sia del Nettun@7000Plus sia del Nettun@3000. Impossibile procedere. Preparare PenDrive con salvataggio di una sola macchina."  
  exit 1 
fi

if unzip -l "$USB_MOUNTPOINT/presetting_files.zip" | grep -q presetting_files
then
  unzip -d /tmp "$USB_MOUNTPOINT/presetting_files.zip"
fi
if [ -d "$USB_MOUNTPOINT/presetting_files" ]
then
  cp -r $USB_MOUNTPOINT/presetting_files /tmp
fi
if [ -d "$USB_MOUNTPOINT/crf7100/presetting_files" ]
then  
  cp -r $USB_MOUNTPOINT/crf7100/presetting_files /tmp
fi
if [ -d "$USB_MOUNTPOINT/crf3000/presetting_files" ]
then
  cp -r $USB_MOUNTPOINT/crf3000/presetting_files /tmp
fi

if [ ! -d '/tmp/presetting_files' ]
then
  sysmsg "$VOKNO_NAME" "Non sono stati trovati i dati da convertire"  
  exit 1 
fi

# Convert decimal values xx,yy into xx.yy
for csv in `ls /tmp/presetting_files/*.csv`
do
  cat $csv | sed -e 's/\([0-9]\),\([0-9]\)/\1.\2/g' > /tmp/nettuna_conv.csv
  cp /tmp/nettuna_conv.csv $csv
  rm -f /tmp/nettuna_conv.csv
done

cat systools/distr/OlivettiImport.sql | systools/patch_sql | $SQL  > /tmp/NETTUNA_RESULT 2>&1

if [ $? -gt 0 ] || cat /tmp/NETTUNA_RESULT | grep -qi error
then
 sysmsg "$VOKNO_NAME" "Errore durante inserimento nel database. Contattare l'assistenza tecnica"
else
 sysmsg "$VOKNO_NAME" "Conversione terminata con sucesso"
fi

