#!/bin/bash
source cfg.sh
export yyyymm
export pre1_yyyymm
echo $yyyymm


cd ..


######
echo "活跃用户-当月有过登录的用户总数:"
cat ./log/1_info${yyyymm}* | grep event_id:1, | awk -F"," '{print $3}' | awk -F ":" '{print $2}' | sort | uniq | wc -l

######
echo "新增用户-当月新增登陆过得用户总数:"
cat ./log/1_info${yyyymm}* | grep event_id:6, | awk -F"," '{print $3}' | awk -F ":" '{print $2}' | sort | uniq > xin_zen_user_${yyyymm}
cat xin_zen_user_${yyyymm} | wc -l

######
echo "留存用户-当月和上月都登录过的用户总数:"
cat ./log/1_info${yyyymm}* | grep event_id:1, | awk -F"," '{print $3}' | awk -F ":" '{print $2}' | sort | uniq > 1

cat ./log/1_info${pre1_yyyymm}* | grep event_id:1, | awk -F"," '{print $3}' | awk -F ":" '{print $2}' | sort | uniq >> 1

cat 1 | sort | uniq -d > liu_cun_user_${yyyymm} 
cat liu_cun_user_${yyyymm} | wc -l

rm 1


######
echo "回流用户-当月有登录记录，上月没有登录记录，上上月有登录记录的用户总数:"
cat ./log/1_info${yyyymm}* | grep event_id:1, | awk -F"," '{print $3}' | awk -F ":" '{print $2}' | sort | uniq > 1

cat ./log/1_info${pre2_yyyymm}* | grep event_id:1, | awk -F"," '{print $3}' | awk -F ":" '{print $2}' | sort | uniq >> 1

#yyyymm和pre2_yyyymm中有重复的放在2中
cat 1 | sort | uniq -d > 2

cat ./log/1_info${pre1_yyyymm}* | grep event_id:1, | awk -F"," '{print $3}' | awk -F ":" '{print $2}' | sort | uniq > 3

cat 2 > 4
cat 3 >> 4

cat 4 | sort | uniq -d > 5

cat 2 > 6
cat 5 >> 6

cat 6 | sort | uniq -u > hui_liu_user_${yyyymm}

cat hui_liu_user_${yyyymm} | wc -l

rm 1 2 3 4 5 6


######
echo "新增留存数-上月新增用户中在本月有登录过的用户总数:"
cat ./log/1_info${yyyymm}* | grep event_id:1, | awk -F"," '{print $3}' | awk -F ":" '{print $2}' | sort | uniq > 1

cat xin_zen_user_${pre1_yyyymm} >> 1

cat 1 | sort | uniq -d | wc -l

rm 1


######
echo "留存留存数-上月留存用户中在本月有登录过的用户总数:"
cat ./log/1_info${yyyymm}* | grep event_id:1, | awk -F"," '{print $3}' | awk -F ":" '{print $2}' | sort | uniq > 1

cat liu_cun_user_${pre1_yyyymm} >> 1

cat 1 | sort | uniq -d | wc -l

rm 1


######
echo "回流用户留存数-上月回流用户中在本月有登录的用户总数:"
cat ./log/1_info${yyyymm}* | grep event_id:1, | awk -F"," '{print $3}' | awk -F ":" '{print $2}' | sort | uniq > 1

cat hui_liu_user_${pre1_yyyymm} >> 1

cat 1 | sort | uniq -d | wc -l

rm 1


######
echo "付费总额-当月付费金额总数"
#cat ./log/1_info${yyyymm}* | grep event_id:2, | awk -F"," '{print $6}' | awk '{a += $0} END {print a}'
cat ./log/1_info${yyyymm}* | grep event_id:2, | awk -F"," '{print $6}' | awk -F":" '{print $2}' | awk '{a += $0} END {print a}'


######
echo "付费人数-当月有过付费行为的用户总数"
cat ./log/1_info${yyyymm}* | grep event_id:2, | awk -F"," '{print $3}' | awk -F ":" '{print $2}' | sort | uniq | wc -l



######
echo "新增付费人数-产生首次付费行为的用户总数"
cat ./log/1_info${yyyymm}* | grep event_id:7, | wc -l




######
echo "输金币流水(game_id,房间分数,钱的变化量)"
cat ./log/1_info${yyyymm}* | grep event_id:3, | awk -F "," '{print $8}' | awk '{a += $0} END {print a}'
echo "200:"
cat ./log/1_info${yyyymm}* | grep event_id:3, | awk -F "," '{print $6,$7,$8}' | grep " 200 " | awk '{a += $3} END {print a}'
echo "1500:"
cat ./log/1_info${yyyymm}* | grep event_id:3, | awk -F "," '{print $6,$7,$8}' | grep " 1500 " | awk '{a += $3} END {print a}'



######
echo "赢金币流水(game_id,房间分数,钱的变化量)"
cat ./log/1_info${yyyymm}* | grep event_id:4, | awk -F "," '{print $8}' | awk '{a += $0} END {print a}'
echo "200:"
cat ./log/1_info${yyyymm}* | grep event_id:4, | awk -F "," '{print $6,$7,$8}' | grep " 200 " | awk '{a += $3} END {print a}'
echo "1500:"
cat ./log/1_info${yyyymm}* | grep event_id:4, | awk -F "," '{print $6,$7,$8}' | grep " 1500 " | awk '{a += $3} END {print a}'



######
echo "牌局(game_id,房间分数)"
cat ./log/1_info${yyyymm}* | grep event_id:5, | wc -l
echo "200:"
cat ./log/1_info${yyyymm}* | grep event_id:5, | awk -F "," '{print $6,$7}' | grep " 200" | wc -l
echo "1500:"
cat ./log/1_info${yyyymm}* | grep event_id:5, | awk -F "," '{print $6,$7}' | grep " 1500" | wc -l