#!/bin/sh
#
# Pbx Accounting / Billing
# Copyright 2000-2002 (c) Calin Damian
# http://pbx.sourceforge.net
#
# $Id: processfile,v 1.1.1.1 2002/02/27 19:25:04 calinovich Exp $
#

HOME="/var/worker"
PATH=/bin:/sbin:/usr/bin:/usr/sbin


# Process the input file
  # Stoping pbx capture
/etc/rc.d/init.d/pbx stop
  # Writing lines with errors to /var/log/pbx.err
sed '/?/!d' $1 >> $HOME/log/pbxerr.log
  #Replace ' with :
sed 's/'`echo "'"`'/:/g' $1 > $HOME/tmp/temp.temp
cp --force $HOME/tmp/temp.temp $1
rm -f $HOME/tmp/temp.temp
  # Processing input file
$HOME/scripts/sed_script $1 > /tmp/logging.txt
  # Importing into MySQL
mysqlimport --local --columns=datetime,ext,co,dialnumber,ring,duration,acccode,cd --force -h localhost -u import_user --password=o9as8r4h --silent --fields-terminated-by=, pbx /tmp/logging.txt

  # Making backups
#cp --force $HOME/capture.log $HOME/backup/"`date +"%Y.%m.%d %H.%M"`"
sed '/^$/d'  $HOME/capture.log >> $HOME/backup/"`date +"%Y.%m.%d"`"

  # Adding info in log
#echo "`date +"%Y/%m/%d-%H:%M"` :  Script executed."
#/usr/bin/logger -t pbx -p INFO Import script executed at "`date +"%Y/%m/%d-%H:%M"`"
echo Import script executed at "`date +"%Y/%m/%d-%H:%M"`" >> $HOME/log/execution.log

  # Removing /capture.log
rm -f $HOME/capture.log

  # Starting pbx capture
/etc/rc.d/init.d/pbx start

