Shell 脚本练习

【第一个】

#!/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