def get(self):
if not self.current_user:
self.redirect("/signin")
return
_id = tornado.escape.xhtml_escape(self.current_user)
_signedInUser = user.find(int(_id))
_message = self.get_argument("message", None)
messages = []
if _message is not None:
messages.append(_message)
_user_id = self.get_argument("user_id", None)
_name = self.get_argument("name", None)
if _user_id is not None:
results = healthcan.user_id(_id, _user_id)
elif _name is not None:
results = healthcan.name(_id, _name)
else:
results = healthcan.select_by_user_id(_signedInUser.attr["id"])
self.render("healthcans.html",
user=_signedInUser,
healthcans=results,
messages=messages,
user_id=_user_id,
name=_name,
errors=[])
def get(self):
if not self.current_user:
self.redirect("/signin")
return
# サインインユーザーの取得
_id = tornado.escape.xhtml_escape(self.current_user)
_signedInUser = user.find(int(_id))
# 他の画面からのメッセージを取得
_message = self.get_argument("message", None)
messages = []
if _message is not None: messages.append(_message)
# 概要を取得
_summary = self.get_argument("summary", None)
# ユーザーごとの現金出納帳データを取得
if _summary is not None:
results = cashbook.summary(_id, _summary)
else:
results = cashbook.select_by_user_id(_signedInUser.attr["id"])
self.render("cashbooks.html",
user=_signedInUser,
cashbooks=results,
messages=messages,
summary=_summary,
errors=[])
def post(self):
# パラメータの取得
_fid = self.get_argument("fav", None)
_word = self.get_argument("f-word", None)
# ユーザーのIDを取得
_id = tornado.escape.xhtml_escape(self.current_user)
_uid = int(_id)
_signedInUser = user.find(int(_id))
# 入力された料理のidを取得
_cid = cooking.find_nametoid(_word)
f = favorites.build()
if _fid == "None":
f.attr["favorites_id"] = None
else:
f.attr["favorites_id"] = _fid
f.attr["user_id"] = _uid
f.attr["cooking_id"] = _cid
# import pdb
# pdb.set_trace()
f.save()
# ページへリダイレクト
self.redirect("/search?form-word=" + _word)
def get(self):
if not self.current_user:
self.redirect("/signin")
return
# サインインユーザーの取得
_id = tornado.escape.xhtml_escape(self.current_user)
_signedInUser = user.find(int(_id))
# 他の画面からのメッセージを取得
_message = self.get_argument("message", None)
messages = []
if _message is not None: messages.append(_message)
results = []
_word = self.get_argument("word", None)
if _word is not None:
results = innerList.search(_id, _word)
else:
# ユーザーごとの現金出納帳データを取得
results = innerList.select_by_user_id(_signedInUser.attr["id"])
self.render("innerLists.html",
user=_signedInUser,
innerLists=results,
messages=messages,
errors=[])
"""# 概要を取得
def get(self, id): # idはURLで指定されたIDが入る
if not self.current_user:
self.redirect("/signin")
return
# サインインユーザーの取得
_id = tornado.escape.xhtml_escape(self.current_user)
_signedInUser = user.find(int(_id))
# cashbookより指定されたIDでデータ取得
cb = cashbook.find(id)
# データが見つからない場合は404エラーを返す
# 404エラーは、raise tornado.web.HTTPError(404) で返せます
if (cb is None):
raise tornado.web.HTTPError(404)
# 取得したCashBookデータの、ユーザーIDがサインインID異なる場合も404エラーを返す
# print(type(cb.attr['user_id']))
# print(type(_id))
if (cb.attr['user_id'] != int(_id)):
raise tornado.web.HTTPError(404)
self.render(
"cashbook_form.html",
user=_signedInUser,
mode="show", # modeはshowとする
cashbook=cb,
messages=[],
errors=[])
def post(self):
# サインインユーザの取得
_id = tornado.escape.xhtml_escape(self.current_user)
_signedInUser = user.find(int(_id))
# 他の画面からのメッセージを取得
_message = self.get_argument("message", None)
messages = []
if _message is not None:
messages.append(_message)
# 概要を取得
_favorite_id = self.get_argument("favorite", None)
result = _signedInUser.favorite_update(_favorite_id, _id)
if result is None:
self.redirect("/mypageUser")
else:
if result == False:
self.render("serarchResults.html",
user=_signedInUser,
artists=result,
messages=[],
errors=["できませーん"])
else:
self.redirect("/mypageUser?message=%s" %
tornado.escape.url_escape("お気に入り登録完了"))
def post(self):
if not self.current_user:
self.redirect("/signin")
return
# サインインユーザーの取得
_id = tornado.escape.xhtml_escape(self.current_user)
_signedInUser = user.find(int(_id))
# POSTされたパラメータを取得
p_id = self.get_argument("wishlist_id", None)
w = wishList.move(p_id)
il = innerList.build()
il.attr["user_id"] = w.attr["user_id"] # ユーザーIDはサインインユーザーより取得
il.attr["product_name"] = w.attr["name"]
il.attr["kind"] = w.attr["kind"]
il.attr["amount"] = w.attr["quantity"]
il.attr["whose"] = ""
il.attr["lim"] = ""
il.save()
self.redirect("/wishlist")
def get(self):
if not self.current_user:
self.redirect("/signin")
return
# サインインユーザーの取得
_id = tornado.escape.xhtml_escape(self.current_user)
_signedInUser = user.find(int(_id))
self.render("cash_sort.html")
def get(self):
if not self.current_user:
self.redirect("/signin")
return
_id = int(tornado.escape.xhtml_escape(self.current_user))
_signedInUser = user.find(_id)
self.render("dashboard.html", user=_signedInUser)
def get(self):
if not self.current_user:
self.redirect("/signin")
return
# サインインユーザーの取得
_id = tornado.escape.xhtml_escape(self.current_user)
_signedInUser = user.find(int(_id))
# ダッシュボードを表示
self.render("innerList.html", user=_signedInUser)
def post(self, id):
if not self.current_user:
self.redirect("/signin")
return
# サインインユーザーの取得
_id = tornado.escape.xhtml_escape(self.current_user)
_signedInUser = user.find(int(_id))
# POSTされたパラメータを取得
p_product_name = self.get_argument("form-product_name", None)
p_lim = self.get_argument("form-lim", None)
p_amount = self.get_argument("form-amount", None)
p_whose = self.get_argument("form-whose", None)
p_kind = self.get_argument("form-kind", None)
# 現金出納帳データの組み立て
il = innerList.build()
il.attr["user_id"] = int(_id) # ユーザーIDはサインインユーザーより取得
il.attr["id"] = id
errors = []
if p_product_name is None: errors.append("品名は必須です。")
il.attr["product_name"] = p_product_name
il.attr["lim"] = p_lim
il.attr["whose"] = p_whose
il.attr["kind"] = p_kind
il.attr["amount"] = p_amount
#il.attr["last_updated"] = p_last_updated
if len(errors) > 0: # エラーは新規登録画面に渡す
self.render("innerList_form.html",
user=_signedInUser,
mode="new",
innerList=il,
messages=[],
errors=[])
return
# 登録
# print(vars(w))
il_id = il.save()
if il_id == False:
self.render("innerList_form.html",
user=_signedInUser,
mode="new",
innerList=il,
messages=[],
errors=["登録時に致命的なエラーが発生しました。"])
else:
# 登録画面へリダイレクト(登録完了の旨を添えて)
self.redirect(
"/?message=%s" %
tornado.escape.url_escape("変更を完了しました。(ID:%s)" % il_id))
def post(self):
if not self.current_user:
self.redirect("/signin")
return
# サインインユーザーの取得
_id = tornado.escape.xhtml_escape(self.current_user)
_signedInUser = user.find(int(_id))
# POSTされたパラメータを取得
p_date = self.get_argument("form-date", None)
p_summary = self.get_argument("form-summary", None)
p_detail = self.get_argument("form-detail", None)
p_income = self.get_argument("form-income", None)
p_expenses = self.get_argument("form-expenses", None)
# 現金出納帳データの組み立て
cb = cashbook.build()
cb.attr["user_id"] = int(_id) # ユーザーIDはサインインユーザーより取得
# パラメータエラーチェック
errors = []
if p_date is None:
errors.append("日付は必須です。")
else:
# 文字列をdatetime.dateオブジェクトへをキャスト
cb.attr["date"] = datetime.datetime.strptime(p_date, '%Y-%m-%d').date()
if p_summary is None: errors.append("摘要は必須です。")
#(交通費)を自動で追加
summary = "交通費" + "(" + p_summary + ")"
cb.attr["summary"] = summary
cb.attr["detail"] = p_detail
if p_income is None and p_expenses is None: errors.append("収入/支出のどちらかは入力してください。")
if p_income is None: p_income = 0
if p_expenses is None: p_expenses = 0
cb.attr["income"] = Decimal(p_income)
cb.attr["expenses"] = Decimal(p_expenses)
# 金額計算(収入 - 支出)
cb.attr["amount"] = cb.attr["income"] - cb.attr["expenses"]
if len(errors) > 0: # エラーは新規登録画面に渡す
self.render("cashbook_formfixed.html", user=_signedInUser, mode="new", cashbook=cb, messages=[], errors=[])
return
# 登録
# print(vars(cb))
cb_id = cb.save()
if cb_id == False:
self.render("cashbook_formfixed.html", user=_signedInUser, mode="new", cashbook=cb, messages=[], errors=["登録時に致命的なエラーが発生しました。"])
else:
# 登録画面へリダイレクト(登録完了の旨を添えて)
self.redirect("/cashbooks?message=%s" % tornado.escape.url_escape("新規登録完了しました。(ID:%s)" % cb_id))
def get(self):
if not self.current_user:
self.redirect("/signin")
return
# サインインユーザーの取得
_id = tornado.escape.xhtml_escape(self.current_user)
_signedInUser = user.find(int(_id))
w = wishList.build()
self.render("wishList_form.html", user=_signedInUser, mode="new", wishList=w, messages=[], errors=[])
def get(self):
if not self.current_user:
self.redirect("/signin")
return
# サインインユーザーの取得
_id = tornado.escape.xhtml_escape(self.current_user)
_signedInUser = user.find(int(_id))
cb = cashbook.build()
self.render("cashbookfixed_form.html", user=_signedInUser, mode="new", cashbook=cb, messages=[], errors=[])
def get(self):
if not self.current_user:
self.redirect("/signin")
return
# サインインユーザーの取得
_id = tornado.escape.xhtml_escape(self.current_user)
_signedInUser = user.find(int(_id))
# ダッシュボードを表示
print(_signedInUser)
flower = cashbook.select_flower(_id)
self.render("dashboard.html", user=_signedInUser, flower=flower)
def get(self):
if not self.current_user:
self.redirect("/top")
return
# サインインユーザーの取得
_id = tornado.escape.xhtml_escape(self.current_user)
_signedInUser = user.find(int(_id))
# ダッシュボードを表示
if _signedInUser.attr["artist_name"] == None:
self.render("mypageUser.html", user=_signedInUser)
else:
self.render("mypageArtist.html", user=_signedInUser)
def get(self):
if not self.current_user:
self.redirect("/signin")
return
# サインインユーザーの取得
_id = int(tornado.escape.xhtml_escape(self.current_user))
_signedInUser = user.find(_id)
# その他必要な処理をここで
# ダッシュボードを表示
self.render("dashboard.html", user=_signedInUser)
def get(self):
if not self.current_user:
self.redirect("/signin")
return
_id = tornado.escape.xhtml_escape(self.current_user)
_signedInUser = user.find(int(_id))
_weight = healthcan.weight(_id)
_bmi = healthcan.bmi(_id)
self.render("dashboard.html",
user=_signedInUser,
weight=_weight,
bmi=_bmi)
def get(self, id):
if not self.current_user:
self.redirect("/signin")
return
# サインインユーザーの取得
_id = tornado.escape.xhtml_escape(self.current_user)
_signedInUser = user.find(int(_id))
cb = cashbook.find(id)
if cb is None: raise tornado.web.HTTPError(404) # データが見つからない場合は404エラーを返す
if cb.attr["user_id"] != _signedInUser.attr["id"]: raise tornado.web.HTTPError(404) # ユーザーIDが異なる場合も404エラーを返す
self.render("cashbook_form.html", user=_signedInUser, mode="show", cashbook=cb, messages=[], errors=[])
def get(self, id):
if not self.current_user:
self.redirect("/signin")
return
# サインインユーザーの取得
_id = tornado.escape.xhtml_escape(self.current_user)
_signedInUser = user.find(int(_id))
w = wishList.find(id)
if w is None: raise tornado.web.HTTPError(404) # データが見つからない場合は404エラーを返す
if w.attr["user_id"] != _signedInUser.attr["id"]: raise tornado.web.HTTPError(404) # ユーザーIDが異なる場合も404エラーを返す
self.render("wishList_form.html", user=_signedInUser, mode="edit", wishList=w, messages=[], errors=[])
def get(self, id):
if not self.current_user:
self.redirect("/signin")
return
# サインインユーザーの取得
_id = tornado.escape.xhtml_escape(self.current_user)
_signedInUser = user.find(int(_id))
cb = cashbook.find(id)
if cb is None: raise tornado.web.HTTPError(404) # データが見つからない場合は404エラーを返す
if cb.attr["user_id"] != _signedInUser.attr["id"]: raise tornado.web.HTTPError(404) # ユーザーIDが異なる場合も404エラーを返す
cb.delete()
self.redirect("/cashbooks")
def get(self):
if not self.current_user:
self.redirect("/signin")
return
_id = tornado.escape.xhtml_escape(self.current_user)
_signedInUser = user.find(int(_id))
hc = healthcan.build()
self.render("healthcan_form.html",
user=_signedInUser,
mode="new",
healthcan=hc,
messages=[],
errors=[])
def get(self):
if not self.current_user:
self.redirect("/signin")
return
# サインインユーザーの取得
_id = tornado.escape.xhtml_escape(self.current_user)
_signedInUser = user.find(int(_id))
with DBConnector(dbName='db_%s' % project.name()) as con, con.cursor(MySQLdb.cursors.DictCursor) as cursor:
cursor.execute("""
SELECT
*
FROM
table_cashbook
ORDER BY
id;
""")
results = cursor.fetchall()
if (len(results) == 0):
print(None)
return None
cash_attrs = [
"id",
"user_id",
"ym",
# "data",
# "summary",
# "detail",
# "income",
# "expenses",
# "amount",
# "last_updated"
]
response = {}
self.write("[".encode())
for data in results:
for attr in cash_attrs:
if(attr == "data"):
response["%s" % attr] = str(data["%s" % attr])
else:
response["%s" % attr] = data["%s" % attr]
self.set_header("Content-Type", "application/json; charset=UTF-8")
self.write(json.dumps(response))
if(results[-1] != data):
self.write(','.encode())
self.write("]".encode())
def post(self):
if not self.current_user:
self.redirect("/signin")
return
# サインインユーザーの取得
_id = tornado.escape.xhtml_escape(self.current_user)
_signedInUser = user.find(int(_id))
# POSTされたパラメータを取得
p_id = self.get_argument("innerlist_id", None)
il = innerList.find(p_id)
il.delete()
self.redirect("/")
def get(self):
_id = tornado.escape.xhtml_escape(self.current_user)
_uid = int(_id)
_signedInUser = user.find(int(_id))
_word = self.get_argument("form-word", None)
# ingredient.pyからingredient_idを取得
ingredient_id = ingredient.find_nametoingredient_id(_word)
# amount.pyからingredient_idを使いcooking_idを取得
cooking_ids = amount.find_ingredient_idtocooking_id(ingredient_id)
_cooking_names = [cooking.find_idtoname(coo) for coo in cooking_ids]
_favorites = favorites.find_favorite(_uid)
self.render("search.html", user=_signedInUser)
def get(self, id):
if not self.current_user:
self.redirect("/signin")
return
_id = tornado.escape.xhtml_escape(self.current_user)
_signedInUser = user.find(int(_id))
hc = healthcan.find(id)
if hc is None:
raise tornado.web.HTTPError(404)
if hc.attr["user_id"] != _signedInUser.attr["id"]:
raise tornado.web.HTTPError(404)
self.render("healthcan_form.html",
user=_signedInUser,
mode="show",
healthcan=hc,
messages=[],
errors=[])
def post(self):
if not self.current_user:
self.redirect("/signin")
return
# サインインユーザーの取得
_id = tornado.escape.xhtml_escape(self.current_user)
_signedInUser = user.find(int(_id))
# POSTされたパラメータを取得
p_name = self.get_argument("form-name", None)
p_quantity = self.get_argument("form-quantity", None)
p_kind = self.get_argument("form-kind", None)
#p_last_updated = self.get_argument("form-last_updated", None)
# 現金出納帳データの組み立て
w = wishList.build()
w.attr["user_id"] = int(_id) # ユーザーIDはサインインユーザーより取得
errors = []
if p_name is None: errors.append("品名は必須です。")
w.attr["name"] = p_name
w.attr["quantity"] = p_quantity
w.attr["kind"] = p_kind
#w.attr["last_updated"] = p_last_updated
if len(errors) > 0: # エラーは新規登録画面に渡す
self.render("wishList_form.html", user=_signedInUser, mode="new", wishList=w, messages=[], errors=[])
return
# 登録
# print(vars(w))
w_id = w.save()
if w_id == False:
self.render("wishList_form.html", user=_signedInUser, mode="new", wishList=w, messages=[], errors=["登録時に致命的なエラーが発生しました。"])
else:
# 登録画面へリダイレクト(登録完了の旨を添えて)
self.redirect("/wishlist?message=%s" % tornado.escape.url_escape("新規登録完了しました。(ID:%s)" % w_id))
def get(self):
if not self.current_user:
self.redirect("/signin")
return
# サインインユーザーの取得
_id = tornado.escape.xhtml_escape(self.current_user)
_signedInUser = user.find(int(_id))
with DBConnector(dbName='db_%s' % project.name()) as con, con.cursor(
MySQLdb.cursors.DictCursor) as cursor:
cursor.execute(
"""
SELECT
summary
, SUM(expenses) AS sum_expenses
FROM
table_cashbook
WHERE
user_id = %s
AND expenses != 0
GROUP BY
summary
ORDER BY
sum_expenses DESC;
""", (int(_id), ))
results = cursor.fetchall()
if (len(results) == 0):
return None
response = {}
response["labels"] = []
response["values"] = []
for data in results:
response["labels"].append(data["summary"])
response["values"].append(str(data["sum_expenses"]))
self.set_header("Content-Type", "application/json; charset=UTF-8")
self.write(json.dumps(response))
def get(self):
_id = tornado.escape.xhtml_escape(self.current_user)
_uid = int(_id)
_signedInUser = user.find(int(_id))
# ユーザーIDによるお気に入り情報の取得
_favorites = favorites.find_favorite(_uid)
_cooking_names = [
cooking.find_idtoname(fav["cooking_id"]) for fav in _favorites
]
# favorites_IDを取得
# _favorite = [fav["favorites_id"] for fav in _favorites]
# if len(_favorite) == 0:
# _favorite = None
# else:
# _favorite = _favorite
self.render("profile.html",
user=_signedInUser,
favorites=_favorites,
cooking_names=_cooking_names)
def post(self):
if not self.current_user:
self.redirect("/signin")
return
# サインインユーザーの取得
_id = tornado.escape.xhtml_escape(self.current_user)
_signedInUser = user.find(int(_id))
p_summary = self.get_argument("summary", None)
p_date = self.get_argument("year", None) + self.get_argument("month", None)
print(self.get_argument("summary", None))
if p_summary is not "" and p_date is not "":
self.redirect("/cashbooks?summary=%s&date=%s" % (p_summary, p_date,))
if p_summary is not "":
self.redirect("/cashbooks?summary=%s" % p_summary)
return
if p_date is not "":
self.redirect("/cashbooks?date=%s" % p_date)
return
self.redirect('/cashbooks')
