import commands
import utility.device_master as dev_master
import utility.html_table as html_table
import utility.mail_util as mail_util
import math
import utility.date_func as date_func
import utility.html as html_util
import utility.google_chart_api as gchart
argvs = sys.argv
end = int(argvs[1])
summary_app_name = 'kidsnbooks'
if len(argvs) > 2:
summary_app_name = argvs[2]
start = date_func.ndaysago(end, 100)
yyyymmdd, yyyymm, yyyy, mm, dd = date_func.get_yyyymmdd(end)
date_end = yyyy + "-" + str('%02d' % int(mm)) + "-" + str('%02d' % int(dd))
yyyymmdd, yyyymm, yyyy, mm, dd = date_func.get_yyyymmdd(start)
date_start = yyyy + "-" + str('%02d' % int(mm)) + "-" + str('%02d' % int(dd))
from_addr = '*****@*****.**'
to_addrs = ['*****@*****.**', '*****@*****.**']
#to_addrs = ['*****@*****.**']
list = ['kidsnbooks', 'rhythmtap', 'rhythmtapplus', 'rhythmetv', 'kdmode',
'rhythm', 'rhythmplus', 'rhythmonstage', 'goccozoo']
allinone_tab = {}
#後でメールの文章を入れる
t = "サービス詳細KPIレポート" + "(" + str(end) + ")"
#/usr/bin/env python
# -*- coding: utf-8 -*-
import sys
sys.path.append('/home/takagi/git/analytics/analytics_tool')
import utility.db_utility as db_util
from datetime import datetime as dt
import datetime
import commands
import utility.device_master as dev_master
import utility.date_func as date_func
argvs = sys.argv
install_date = int(argvs[1].replace("-", ""))
d007 = date_func.ndaysago(install_date, -7)
d014 = date_func.ndaysago(install_date, -14)
d035 = date_func.ndaysago(install_date, -35)
d060 = date_func.ndaysago(install_date, -60)
d100 = date_func.ndaysago(install_date, -100)
d180 = date_func.ndaysago(install_date, -180)
d370 = date_func.ndaysago(install_date, -370)
d730 = date_func.ndaysago(install_date, -730)
user_data = {}
#DB
db = {
"meta" : { "server" : "inhousedb.smartsrv.in",
"db_name" : "statistics",
"table" : ["mnl_metalog_light_fast"],
"colum" : "*"
},
sys.path.append('/home/takagi/git/analytics/analytics_tool')
import utility.db_utility as db_util
from datetime import datetime as dt
import datetime
import commands
import utility.device_master as dev_master
import utility.html_table as html_table
import utility.mail_util as mail_util
import math
import utility.date_func as date_func
import utility.html as html_util
import utility.google_chart_api as gchart
argvs = sys.argv
day01 = int(argvs[1])
day03 = date_func.ndaysago(day01, 2)
day07 = date_func.ndaysago(day01, 6)
day30 = date_func.ndaysago(day01, 29)
day60 = date_func.ndaysago(day01, 59)
day90 = date_func.ndaysago(day01, 89)
from_addr = '*****@*****.**'
#to_addrs = ['*****@*****.**', '*****@*****.**']
to_addrs = ['*****@*****.**']
html = ""
doc = html_util.document()
#売上
from datetime import datetime as dt
import commands
import utility.device_master as dev_master
import utility.easy_access as ea
import utility.date_func as df
argvs = sys.argv
lower = 20130625
#DB
#課金した日の取得
data = ea.first_subscription("kidsnbooks", 20130625, 20130930)
#本データ
for i in range(110):
date = df.ndaysago(lower, -i)
b = ea.kidsnbooks_booklog(date)
for uid, d in data.items():
data[uid].setdefault("book_id", None)
data[uid].setdefault("book_name", None)
data[uid].setdefault("date", None)
if b.has_key(uid):
if d["date"] == None or (d["date"] > b[uid]["start"] and b[uid]["start"] >= d["subdate"]):
data[uid]["date"] = b[uid]["start"]
data[uid]["book_id"] = b[uid]["book_id"]
data[uid]["book_name"] = b[uid]["book_name"]
#summary
summary = {}
import commands
import utility.device_master as dev_master
import utility.html_table as html_table
import utility.mail_util as mail_util
import math
import utility.date_func as date_func
import utility.html as html_util
import utility.google_chart_api as gchart
argvs = sys.argv
end = int(argvs[1])
summary_app_name = 'kidsnbooks'
if len(argvs) > 2:
summary_app_name = argvs[2]
start = date_func.ndaysago(end, 90)
yyyymmdd, yyyymm, yyyy, mm, dd = date_func.get_yyyymmdd(end)
date_end = yyyy + "-" + str('%02d' % int(mm)) + "-" + str('%02d' % int(dd))
yyyymmdd, yyyymm, yyyy, mm, dd = date_func.get_yyyymmdd(start)
date_start = yyyy + "-" + str('%02d' % int(mm)) + "-" + str('%02d' % int(dd))
from_addr = '*****@*****.**'
to_addrs = ['*****@*****.**', '*****@*****.**']
#to_addrs = ['*****@*****.**']
title = ''
app_analyze = {}
if summary_app_name == 'kidsnbooks':
title = 'スマほん'