【第一个】
#!/bin/bash
#每个用户的总充值和消费以及剩余。
cat yuanbao.txt |grep -v 2016 |awk '{print $3}' |awk '!a[$0]++' >user.list #把用户名去重后添加到一个文件里
cat /dev/null > all.log
while read user
do
buy=`cat yuanbao.txt |grep $user |awk '{print $7}' |awk '{sum += $1};END {print sum}'` #取出所以第7列的总值
now=`cat yuanbao.txt |grep $user |awk 'END{print $9}'` #取出每个用户第9列的最后一行的值
zong=$((buy-now)) #总充值减去剩余的
echo "用户 $user 总充值 $buy 已消费 $zong 剩余 $now" >> all.log
done < user.list
【第二个】
#!/bin/bash
#每个用户每一天的充值buy总和
cat /dev/null > day.log
#NOW=date +%Y-%m
while read user
do
for ((i=1;i<=366;i++))
do
NOW=`date +%F`
SHIJIAN=`date -d "2013-12-31 +$i day" +%Y-%m-%d`
if [ ${SHIJIAN} = ${NOW} ]; then
break
fi
cat yuanbao.txt |grep $SHIJIAN |grep $user &>/dev/null
if [ $? -eq 0 ] ; then
BUY=`cat yuanbao.txt |grep $SHIJIAN |grep $user |awk '{print $7}' |awk '{sum += $1};END {print sum}'`
echo "$SHIJIAN 账号 $user 每一天buy总 $BUY" >> day.log
fi
done
done < user.list
【第三个】
#!/bin/bash
#每个用户每个月的充值总和
cat yuanbao.txt |grep -v 2016 |awk '{print $3}' |awk '!a[$0]++' >user.list #把用户名去重后添加到一个文件里
cat /dev/null > month.log
while read user
do
for ((i=1;i<=50;i++))
do
NOW=`date +%Y-%m`
SHIJIAN=`date -d "2013-12-01 +$i month" +%Y-%m`
if [ ${SHIJIAN} = ${NOW} ]; then
break
fi
cat yuanbao.txt |grep $SHIJIAN |grep $user &>/dev/null
if [ $? -eq 0 ] ; then
BUY=`cat yuanbao.txt |grep $SHIJIAN |grep $user |awk '{print $7}' |awk '{sum += $1};END {print sum}'`
echo "$SHIJIAN 账号$user buy总和$BUY" >> month.log
fi
done
done < user.list
#cat month.log.bak | grep 'buy总和" "' > month.log
【第四个】
#!/bin/bash
#每一天所有用户的buy总和
cat /dev/null > day.log
NOW=`date +%F`
for ((i=1;i<=1000;i++))
do
SHIJIAN=`date -d "2013-12-31 +$i day" +%Y-%m-%d`
if [ ${SHIJIAN} = ${NOW} ];then
break
fi
cat yuanbao.txt |grep $SHIJIAN &>/dev/null
if [ $? -eq 0 ] ; then
ZHI=`cat yuanbao.txt |grep $SHIJIAN |awk '{print $7}' |awk '{sum += $1};END {print sum}'`
echo "$SHIJIAN daily sum $ZHI" >> day.log
fi
done
【第五个】
#!/bin/bash
#每月所有用户的充值总和
cat /dev/null > month.log
NOW=`date +%Y-%m`
for ((i=1;i<=1000;i++))
do
SHIJIAN=`date -d "2013-12-01 +$i month" +%Y-%m`
if [ ${SHIJIAN} = ${NOW} ];then
break
fi
#cat yuanbao.txt |grep $SHIJIAN &>/dev/null
#if [ $? -eq 0 ] ; then
ZHI=`cat yuanbao.txt |grep $SHIJIAN |awk '{print $7}' |awk '{sum += $1};END {print sum}'`
echo "$SHIJIAN 每月所有用户充值总和是:$ZHI" >> month.log
#fi
done