rec["当月着地見込み"] = int(float(v["cnt"]) * rec["先月同日比"] / 100) if rec["先月同日比"] != 0 else int(rec["当月累計売上"] * 30 / float((int(date.replace("-","")) % 100))) label = [ "売上", "サブスクリプション売上", "従量売上", "当月累計売上", "先月同日比", "当月着地見込み", ] d = [] d.append([rec["売上"], rec["サブスクリプション売上"], rec["従量売上"], rec["当月累計売上"], rec["先月同日比"], rec["当月着地見込み"]]) table_summary = html_table.table(label, d) #スマ本Andorid for key, value in sorted(params.items()): record = { "アプリ名" : key, "売上" : 0, "サブスクリプション売上" : 0, "従量売上" : 0, "新規ユーザー数" : 0, "DAU" : 0, "当月累計売上" : 0, "先月同日比" : 0, "当月着地見込み" : 0, } #DAU
data[v["book_id"]].setdefault("month_play", 0) data[v["book_id"]].setdefault("name", books[v["book_id"]]["name"]) data[v["book_id"]].setdefault("release", books[v["book_id"]]["release"]) data[v["book_id"]][uu] += int(v["uu"]) data[v["book_id"]][play] += int(v["play_num"]) label = ["名称", "リリース日", "今週のUU", "今週の再生回数", "今週の熱狂度", "先週のUU", "先週の再生回数", "先週の熱狂度", "先月のUU", "先月の再生回数", "先月の熱狂度"] d = [] for k, v in sorted(data.items(), key=lambda x:x[1]["current_uu"], reverse=True): c0 = float(v["current_play"]) / float(v["current_uu"]) if int(v["current_uu"]) != 0 else 0 c1 = float(v["week_play"]) / float(v["week_uu"]) if int(v["week_uu"]) != 0 else 0 c2 = float(v["month_play"]) / float(v["month_uu"]) if int(v["month_uu"]) != 0 else 0 rec = [v["name"], v["release"], str(v["current_uu"]), str(v["current_play"]), str(round(c0,1)), str(v["week_uu"]), str(v["week_play"]), str(round(c1,1)), str(v["month_uu"]), str(v["month_play"]), str(round(c2,1))] d.append(rec) table = html_table.table(label, d) title = u'ETV週間熱狂度レポート' + "( " + str(argvs[1]) + u"の週)" for to_addr in to_addrs: msg = mail_util.create_message_jp_html(from_addr, to_addr, title, table, 'UTF-8') mail_util.send_via_gmail(from_addr, to_addr, msg)