#! /bin/sh

# as well as catcom also send to...
#ccmadminemail="demo@mon2"
#ccmadminemail="ccmcdr"
ccmadminemail="support@transmit.com.au"
export ccmadminemail

# connection library
SYBASE=/usr/local/freetds
LD_LIBRARY_PATH=${LD_LIBRARY_PATH}:$SYBASE/lib
export SYBASE LD_LIBRARY_PATH

# Callmanager Config

# if different to Telmax21 time zone then
# set TZ here for location of Callmanager
#TZ=AEST-10AEDT,M10.5.0,M3.5.0/2:00:00
#export TZ

###TDSDUMP="";  export TDSDUMP
##TDSHOST="serverbox";  export TDSHOST
#TDSHOST="137.154.210.7";       export TDSHOST
#TDSPORT="1433";        export TDSPORT
##TDSVER="4.2"; export TDSVER
#TDSVER="7.0";  export TDSVER

# encrypt password
#SQSHEXTRAARGS="-X";    export SQSHEXTRAARGS

#ccmcdrdb="CDR"
#ccmcdrtable="CallDetailRecord"
#cm3cdruser="CiscoCCMCDR"
#ccmpassword="dipsy"
###ccmcdruser="DOMAIN\\username"
##ccmpassword="mypassword"
#ccmipphlo="5100 7000 8888"
#ccmipphhi="6999 7999 8888"
#ccmipphlo="1000 60200 60300"
#ccmipphhi="1009 60299 60399"
# get from sql
eval `gextrng $parentsiteid ccmipphlo ccmipphhi`
# get from unl file
#eval `tstgextrng 333_extranges.unl ccmipphlo ccmipphhi`
#echo "ccmipphlo=[$ccmipphlo]"
#echo "ccmipphhi=[$ccmipphhi]"

# sqsh auto start file
##ccmsqshrcfile="$CATPATH/.ccm.sqshrc"
#ccmsqshrcfile="./.ccm.sqshrc"

# rjs 26/4/2018
# store duration in 1 second increments
CLUDURINSECS="1"

# exclude non connected calls
CCMEXCL0DURATION="0"

# rjs 08/10/2014
CCMCDRVER="10.0"
CCMCDRDELIM="|"
CCMCDRSKIPFIRST="0"

# 0= Unified Callmanger (No MS SQLServer)
# 1= CallManager based on MS SQLServer
CCMCDRSQLSERVER="0"
CCMCDRFTPDELIM=","
CCMCDRFTPSKIPFIRST="2"
# ccm cdr data ftp dir (from Cisco Callmanager)
CCMCDRFTPDIR="/u/catcom/database/ccmcdr"
#CCMCDRFTPDIR=""
# ccm cdr stow dir
CCMCDRSTOWDIR="/u/catcom/database/scl/${nodename}/data"

## CM 8 has over 100 input fields
## standar sco awk can only handle 100, so use gawk
#if [ $CCMCDRVER -ge 8 ]; then
        AWK="gawk"
        export AWK
#fi

export ccmsqshrcfile
export ccmcdrtable
export ccmcdruser
export ccmpassword
export ccmipphhi
export CCMCDRVER
export CCMCDRDELIM
export CCMCDRSKIPFIRST
export CCMCDRSQLSERVER
export CCMCDRFTPDELIM
export CCMCDRFTPSKIPFIRST
export CCMCDRFTPDIR
export CCMCDRSTOWDIR

#------------------------------
# testing config

# use this to handle VIDEO calls
dovideo="0"
export dovideo

# use this to split internal calls into in/out on routetrunk 8888888
splitinternal="0"
export splitinternal

## use this for destination instead of default lastRedirectDN
#usefinalCalledPartyNumber="1"
# use this for destination instead of default lastRedirectDN
# and split diverted calls
usefinalCalledPartyNumber="2"
export usefinalCalledPartyNumber

# conferance bride extn, if not set then finalCalledPartyNumber is used
cbridgeextn="3999"
export cbridgeextn

# trunklocalid translation from rtipaddr table
IPADDRfmt="3"
export IPADDRfmt
useccmdevicenames="1"
export useccmdevicenames

#---------------------------------------------------
# extn alter tables  used to convert party numbers in the cdr to extensions

# Kings Park (KPK)
# Corporate: +61|002 985376xx -> 876xx 
#     Local: +61|002 888932xx -> 876xx 

# Penrith (PEN)
# Corporate: +612|002 985346xx -> 846xx
#     Local: +612|002 473296xx -> 846xx

# Spring Hill (SPH)
# Corporate: +612|002 2425222xx -> 822xx
# Corporate: +612|002 2425226xx -> 826xx
#     Local: +612|002 4255xxxxx -> 846xx
# what about 837xx ?

# Picton (PIC)
# 029853534 -> 8534x

# South Windsor (SWR )
# old Panasonic ranges were 2xx and 3xx
# UC is
# Corporate: +612|002 9853758x -> 8758x
# Corporate: +612|002 9853759x -> 8759x

# ShellHarbour (SHR)
# Corporate: +612|002 425227xx -> 827xx

# Moss Vale (MVL)
# Corporate: +612|002 425224xx -> 824xx

# North Parramatta (NPA)
# Corporate: +612|002 985355xx -> 855xx

# Ulladulla (UDA)
# (old Nortel was local 024454 813xx)
# Corporate: +612|002 425221xx -> 821xx

# Katoomba (KTA)
# Corporate: +612|002 985342x -> 842xx

# Glendening (GDG)
# Corporate: +612|002 9853535x -> 8535x
# Corporate: +612|002 9853536x -> 8536x
# Corporate: +612|002 9853537x -> 8537x
# Corporate: +612|002 9853538x -> 8538x
# Corporate: +612|002 9853539x -> 8539x
# Corporate: +612|002 985370xx -> 870xx
# Corporate: +612|002 985371xx -> 871xx
# Corporate: +612|002 985372xx -> 872xx
# Corporate: +612|002 985373xx -> 873xx

# Narellan (NLN)
# Corporate: +612|002 985344xx -> 844xx

# Nowra (NWA)
# (old Nortel was local 024423 836xx)
# Corporate: +612|002 425220xx -> 820xx

# Coniston (CTN)
# Corporate: +612|002 425225xx -> 825xx
# Corporate: +612|002 425228xx -> 828xx
# Corporate: +612|002 425229xx -> 829xx

# Kandos (KDS)
# Corporate: +612|002 9853520x -> 8520x
# Corporate: +612|002 9853521x -> 8521x
# and
# Bowenfells (BFS)
# Corporate: +612|002 9853522x -> 8522x
# Corporate: +612|002 9853523x -> 8523x
# Corporate: +612|002 9853524x -> 8524x
# Corporate: +612|002 9853525x -> 8525x
# Corporate: +612|002 9853526x -> 8526x
# Corporate: +612|002 9853527x -> 8527x
# Corporate: +612|002 9853528x -> 8528x
# Corporate: +612|002 9853529x -> 8529x
# so Kandos and Bowenfells
# Corporate: +612|002 985352xx -> 852xx

# Hoxton Park (HNP)
# Corporate: +612|002 985356xx -> 856xx
# Corporate: +612|002 985378xx -> 878xx
# Corporate: +612|002 985379xx -> 879xx


# Hoxton Park Training (HPT)
# Corporate: +612|002 9853750x -> 8750x
# Corporate: +612|002 9853751x -> 8751x
# Corporate: +612|002 9853752x -> 8752x
# Corporate: +612|002 9853753x -> 8753x
# Corporate: +612|002 9853754x -> 8754x
# Corporate: +612|002 9853755x -> 8755x

# Blacktown Westpont (WBT)
# Corporate: +612|002 985373xx -> 873xx
# Corporate: +612|002 985374xx -> 874xx
# Corporate: +612|002 985377xx -> 877xx

# Spare 854x (ex. Kandos)


# last of all - match shorter 029853.....
# Huntingwood (HTG)
# Corporate: +612|002|02
#              985340xx -> 840xx
#              985341xx -> 841xx
#              985343xx -> 843xx
#              985349xx -> 849xx
#              985350xx -> 850xx
#              985351xx -> 851xx
#              9853530x -> 8430x
#              9853531x -> 8431x
#              9853532x -> 8432x
#              9853533x -> 8433x
#              985358xx -> 858xx
#              985359xx -> 859xx
#              98536xxx -> 86xxx
#              9853756x -> 856xx
#              9853757x -> 857xx
#              983190xx -> 890xx
# CCX
#              864598xx -> 59xxx
#              864599xx -> 59xxx
# did originally have just 
# Corporate: +612|002|02 9853xxxx -> 8xxxx
#10,029853,7,4,8,|\
#11,0029853,8,4,8,|\
#11,6129853,8,4,8,|\

# rest is for external numbers....
# for matching standard dial prefix tables, (with 0 overrirde carrier)
#translate rest of 611xxxx -> 0xxxxx
#translate rest of 61xxxxx -> 00xxxxx

# rjs 30/04/2023
# for Zetron iPhone System 8 digit numbers to be used as extn
# 00286027966 -> 86027966
# 002985357xx -> 985357xx
# and
# +61286027966 -> 86027966
# +612985357xx -> 985357xx

# ndigits_before,digits_prefix, digits_start, ndigits_after, return_prefix, retrn_postfix|...
ccmextnalterlist="\
12,c00214,4,6,|\
12,c00311,4,6,|\
12,c00211,7,6,|\
11,c00214,4,6,|\
11,00286027966,4,8,|\
11,002985357,4,8,|\
11,61286027966,4,8,|\
11,612985357,8,4,8,|\
11,002985373,8,4,8,|\
11,612985373,8,4,8,|\
11,002985374,8,4,8,|\
11,612985374,8,4,8,|\
11,002985377,8,4,8,|\
11,612985377,8,4,8,|\
11,0029853750,8,4,8,|\
11,6129853750,8,4,8,|\
11,0029853751,8,4,8,|\
11,6129853751,8,4,8,|\
11,0029853752,8,4,8,|\
11,6129853752,8,4,8,|\
11,0029853753,8,4,8,|\
11,6129853753,8,4,8,|\
11,0029853754,8,4,8,|\
11,6129853754,8,4,8,|\
11,0029853755,8,4,8,|\
11,6129853755,8,4,8,|\
11,002985356,8,4,8,|\
11,612985356,8,4,8,|\
11,002985378,8,4,8,|\
11,612985378,8,4,8,|\
11,002985379,8,4,8,|\
11,612985379,8,4,8,|\
11,002985352,8,4,8,|\
11,612985352,8,4,8,|\
11,002425220,8,4,8,|\
11,612425220,8,4,8,|\
11,002425221,8,4,8,|\
11,612425221,8,4,8,|\
11,002425225,8,4,8,|\
11,612425225,8,4,8,|\
11,002425228,8,4,8,|\
11,612425228,8,4,8,|\
11,002425229,8,4,8,|\
11,612425229,8,4,8,|\
11,002442386,9,3,83,|\
11,612442386,9,3,83,|\
11,002985344,8,4,8,|\
11,612985344,8,4,8,|\
11,0029853535,8,4,8,|\
11,6129853535,8,4,8,|\
11,0029853536,8,4,8,|\
11,6129853536,8,4,8,|\
11,0029853537,8,4,8,|\
11,6129853537,8,4,8,|\
11,0029853538,8,4,8,|\
11,6129853538,8,4,8,|\
11,0029853539,8,4,8,|\
11,6129853539,8,4,8,|\
11,002985370,8,4,8,|\
11,612985370,8,4,8,|\
11,002985371,8,4,8,|\
11,612985371,8,4,8,|\
11,002985372,8,4,8,|\
11,612985372,8,4,8,|\
11,002985373,8,4,8,|\
11,612985373,8,4,8,|\
11,002985342,8,4,8,|\
11,612985342,8,4,8,|\
11,002985376,8,4,8,|\
11,612985376,8,4,8,|\
11,002985346,8,4,8,|\
11,612985346,8,4,8,|\
11,002473296,8,4,8,|\
11,612473296,8,4,8,|\
11,002425222,8,4,8,|\
11,612425222,8,4,8,|\
11,002425226,8,4,8,|\
11,612425226,8,4,8,|\
11,0029853534,8,4,8,|\
11,6129853534,8,4,8,|\
11,0029853758,8,4,8,|\
11,6129853758,8,4,8,|\
11,0029853759,8,4,8,|\
11,6129853759,8,4,8,|\
11,002425227,8,4,8,|\
11,612425227,8,4,8,|\
11,002425224,8,4,8,|\
11,612425224,8,4,8,|\
11,002985355,8,4,8,|\
11,612985355,8,4,8,|\
11,002445493,9,3,81,|\
11,612445493,9,3,81,|\
10,02985340,7,4,8,|\
10,02985341,7,4,8,|\
10,02985343,7,4,8,|\
10,02985349,7,4,8,|\
10,02985350,7,4,8,|\
10,02985351,7,4,8,|\
10,029853530,7,4,8,|\
10,029853531,7,4,8,|\
10,029853532,7,4,8,|\
10,029853533,7,4,8,|\
10,02985358,7,4,8,|\
10,02985359,7,4,8,|\
10,0298536,7,4,8,|\
10,029853756,7,4,8,|\
10,029853757,7,4,8,|\
10,02983190,7,4,8,|\
10,02864598,7,4,5,|\
10,02864599,7,4,5,|\
11,002985340,8,4,8,|\
11,002985341,8,4,8,|\
11,002985343,8,4,8,|\
11,002985349,8,4,8,|\
11,002985350,8,4,8,|\
11,002985351,8,4,8,|\
11,0029853530,8,4,8,|\
11,0029853531,8,4,8,|\
11,0029853532,8,4,8,|\
11,0029853533,8,4,8,|\
11,002985358,8,4,8,|\
11,002985359,8,4,8,|\
11,00298536,8,4,8,|\
11,0029853756,8,4,8,|\
11,0029853757,8,4,8,|\
11,002983190,8,4,8,|\
11,002864598,8,4,5,|\
11,002864599,8,4,5,|\
11,612985340,8,4,8,|\
11,612985341,8,4,8,|\
11,612985343,8,4,8,|\
11,612985349,8,4,8,|\
11,612985350,8,4,8,|\
11,612985351,8,4,8,|\
11,6129853530,8,4,8,|\
11,6129853531,8,4,8,|\
11,6129853532,8,4,8,|\
11,6129853533,8,4,8,|\
11,612985358,8,4,8,|\
11,612985359,8,4,8,|\
11,61298536,8,4,8,|\
11,6129853756,8,4,8,|\
11,6129853757,8,4,8,|\
11,612983190,8,4,8,|\
11,612864598,8,4,5,|\
11,612864599,8,4,5,|\
6,611,3,4,0,|\
6,61,3,4,00,|\
7,61,3,5,00,|\
8,611,3,6,0,|\
8,61,3,6,00,|\
9,61,3,7,00,|\
10,61,3,8,00,|\
11,61,3,9,00|\
12,611,3,10,0,|\
12,61,3,10,00,|\
13,61,3,11,00,|\
14,61,3,12,00,|\
15,61,3,13,00,|\
16,61,3,14,00,|\
17,61,3,15,00,|\
18,61,3,16,00,|\
19,61,3,17,00,|\
20,61,3,18,00,|\
21,61,3,19,00,|\
22,61,3,20,00,|\
"
export ccmextnalterlist

#---------------------------------------------------

if [ -z "$ccmrawoutfile" ]; then
        #ccmrawoutfile="/u/catcom/clu/ccm_${nodename}.raw"
        #ccmrawoutfile="./ccm_${nodename}.raw"
        ccmrawoutfile="/u/catcom/database/scl/ccm_${nodename}.raw"
fi
export ccmrawoutfile

if [ -z "$ccmlogfile" ]; then
        #ccmlogfile="/u/catcom/clu/ccm_${nodename}.log"
        #ccmlogfile="./ccm_${nodename}.log"
        ccmlogfile="/u/catcom/database/scl/ccm_${nodename}.log"
        #ccmlogfile="/u/catcom/database/scl/ccm_${nodename}_$$.log"
fi
export ccmlogfile

if [ -z "$ccmerrfile" ]; then
        #ccmerrfile="/u/catcom/clu/ccm_${nodename}.err"
        #ccmerrfile="./ccm_${nodename}.err"
        ccmerrfile="/u/catcom/database/scl/ccm_${nodename}.err"
        #ccmerrfile="/u/catcom/database/scl/ccm_${nodename}_$$.err"
fi
export ccmerrfile

# set logging level 0..9
if [ -z "$ccmloglevel" ]; then
        ccmloglevel="4";        export ccmloglevel
fi

rm -f "$ccmrawoutfile"
rm -f "$ccmlogfile"
rm -f "$ccmerrfile"

#------------------------------