def AddFavByCatID():
intCatID = request.form['intCatID']
strFavoriteTitle = request.form['strFavoriteTitle']
strDescription = request.form['strDescription']
intRanking = request.form['intRanking']
objCategory = Categories_Lookup.query.filter_by(id=intCatID).first()
if not objCategory is None:
objFavorite = Favorite.query.filter(
Favorite.category_id == intCatID,
Favorite.title == strFavoriteTitle).first()
if objFavorite is None:
objSameRankItem = Favorite.query.filter_by(
category_id=intCatID, ranking=intRanking).first()
if objSameRankItem:
rankReorder(intCatID, intRanking)
fav = Favorite(title=strFavoriteTitle,
description=strDescription,
ranking=intRanking,
cteated_date=datetime.now(),
modified_date=datetime.now(),
Category=objCategory)
db.session.add(fav)
db.session.commit()
response = success(fav.as_dict())
objLogs = Audit_Log(
description="Add New Favorite (%s) for (%s) Category" %
(strFavoriteTitle, objCategory.title),
log_date=datetime.now())
db.session.add(objLogs)
db.session.commit()
else:
response = failure("Favorite Name Must be Unique")
else:
response = failure("This Category is not exists")
return jsonify(response)