#!/bin/bash
NEW_COUNTER=$1

MYSQL_ASK="mysql -u euro3g -BNrpeuro3g eurotest"

disp_send()
{

  source /opt/euro-beta/euro3g_remote_display.config

  counter_val=$1
  if [ $counter_val -lt 0 ]
  then
    counter_val=0;
  fi
  if [ $counter_val -gt 999 ]
  then
    counter_val=999;
  fi

  for disp_idx in ${!EURO3G_REMOTE_DISPLAY_ADDRESS_ARRAY[*]}
  {
    e3g_disp=${EURO3G_REMOTE_DISPLAY_ADDRESS_ARRAY[$disp_idx]}
    disp_header=${EURO3G_REMOTE_DISPLAY_HEADER_ARRAY[$disp_idx]}
    disp_footer=${EURO3G_REMOTE_DISPLAY_FOOTER_ARRAY[$disp_idx]}
    disp_stretch=${EURO3G_REMOTE_DISPLAY_STRETCH_ARRAY[$disp_idx]}

    echo -en "STRETCH:$disp_stretch" | nc $e3g_disp 7755
    echo -en "HEADER:$disp_header" | nc $e3g_disp 7755
    echo -en $counter_val | nc $e3g_disp 7755
    echo -en "FOOTER:$disp_footer" | nc $e3g_disp 7755
  }
}

ORDER_STOCK=`echo 'SELECT FLOOR(SUM(order_qty)) FROM objednavka LEFT JOIN newplu ON newplu.plucode = objednavka.plu_id LEFT JOIN department on department.dept_id = newplu.dept WHERE order_idx<1000 AND !category AND !ingredient AND delivery_monitor="1"' | $MYSQL_ASK`
DELIVERY_STOCK=`echo 'SELECT FLOOR(SUM(stock)) FROM newplu LEFT JOIN department on department.dept_id = newplu.dept WHERE !category AND !ingredient AND delivery_monitor="1"' | $MYSQL_ASK`
systools/set_eurodb_config_val DeliveryStockSum int $(( $NEW_COUNTER - $DELIVERY_STOCK + $ORDER_STOCK ))

#echo -n "STRETCH:1:4:2"
#echo -n "HEADER:Possiamo preparare ancora" | nc 192.168.160.201 7755
#echo -n $NEW_COUNTER | nc 192.168.160.201 7755
#echo -en "FOOTER:PIZZE\n(impasto lievitato per 30 ore)" | nc 192.168.160.201 7755

#disp_send "STRETCH:1:4:2"
#disp_send "HEADER:Possiamo preparare ancora"
#disp_send $NEW_COUNTER
#disp_send "FOOTER:PIZZE\n(impasto lievitato per 30 ore)"

disp_send $NEW_COUNTER
