#!/bin/bash
#
# $Id: mail_relay_by_sender,v 1.2 2002/03/18 22:47:35 syatskevich Exp $
#
#      ( ).
#

#  
if [ "x$PSQL" = "x" ]; then
	echo "   (PSQL).  $0 "
	exit 1
fi

# DOMAINNAME,  ,  
# ,   
. /etc/sysconfig/network
if [ "x$DOMAINNAME" = "x" ]; then
	echo "   .  $0 "
fi

#    
if [ "x$FILTER" != "x" ]; then
	WHERE_FILTER="WHERE ($FILTER)"
	AND_FILTER="AND ($FILTER)"
fi

if [ "x$KB" = "x" ]; then
	KB=1
fi

QUERY="
SELECT
	sender                  AS \"\",
	SUM (count)             AS \"-\",
	ROUND (SUM (bytes)/$KB, 0) AS \"\"

FROM mail_log
WHERE sender   NOT LIKE '%$DOMAINNAME' AND
      reciever NOT LIKE '%$DOMAINNAME' $AND_FILTER
GROUP BY sender

ORDER BY \"\""

echo "**************************************************************"
echo "*     , "
echo "*  "
echo "*"
echo "*    '-'  "
echo "*"
echo "*  :"
echo "*     = $KB"
echo "**************************************************************"
$PSQL -c "$QUERY"
