#!/bin/ksh
###############################################################################
# -----------------------------------------------------------------------------
#
# ------------------------------------------------------------------------------
################################################################################                                                                                                              
# Variable list                                                 
FILE="/usr/errors/errors_07/unknown_07.txt"             
MAILING_LIST="mailbox_07.cfg"                                                   
LIST_SITE=`cut -d# -f1 $FILE |sort -u`                                       
PATH="/usr/errors/errors_07/rejet_07/"                                      
UNLOAD="dbaccess katali ../error_07_output.sql"                                   
                                                                             
# unload unknown_07.txt                                                      
$UNLOAD                                                                      

# Extract site                                                               
for SITE in ${LIST_SITE}                                                     
do                                                                           
                                                                             
# Extract SITE                                                               
echo "Extraction infos for centre $SITE..."                            
                                                                             
echo "Hi, \n" >$PATH$SITE.txt                                          
echo " This is list of all errors found :\n" >>$PATH$SITE.txt
echo "Clothes   Colors   Type     Age         Eyes     Hair  \n" >>$PATH$SITE.txt      
                                                                             
grep $SITE $FILE |sed 's/\#/    /g' >>$PATH$SITE.txt                   
                                                                             
echo "\n" >>$PATH$SITE.txt                                                 
echo "This is real errors from you ? \n" >>$PATH$SITE.txt

echo "Where is send ? \n" >>$PATH$SITE.txt

echo "CDLT.\n" >>$PATH$SITE.txt
                                                                             
# Send Mail                                                                  
TO=`grep ^$SITE $MAILING_LIST|cut -d: -f2`                                   
                                                                             
# Convert file in DOS mode...                                       
unix2dos -ascii $PATH$SITE.txt $PATH$SITE.txt 2>/dev/null                
                                                                             
echo "Send to $PATH$SITE.txt a $TO"                              
SEND=`cat $PATH$SITE.txt`                                                  
                                                                             
# Send mail auto to center                                        
mailx -r myemail_is_here@testers.com -s "$SITE - Real Errors - Error 07" myemail_is_here@testers.com ${TO} < $PATH$SITE.txt 
                 
done