def set_user_member(self, organization_id, user_id, excuse):
info = self.find_data(['type'],
organization_id=organization_id,
user_id=user_id,
get_some=False)
if not info: #如果没有该条数据
info = {}
info['type'] = 0
self.insert_into_db({
"organization_id":
organization_id,
"user_id":
user_id,
"type":
self.is_ord_memeber,
"msg":
excuse,
"change_date":
PublicFunc.get_current_datetime()
})
return
new_type = info['type'] | self.is_ord_memeber
return self.update_db({'type': new_type},
organization_id=organization_id,
user_id=user_id,
msg=excuse,
change_date=PublicFunc.get_current_datetime())
def set_user_apply(self, organization_id, user_id, excuse):
"""
设置用户为申请状态
"""
info = self.find_data(['type'],
organization_id=organization_id,
user_id=user_id,
get_some=False)
if not info: #如果没有该条数据
info = {}
info['type'] = 0
self.insert_into_db({
"organization_id":
organization_id,
"user_id":
user_id,
"type":
self.is_applying,
"msg":
excuse,
"change_date":
PublicFunc.get_current_datetime()
})
return
new_type = info['type'] | self.is_applying
return self.update_db({'type': new_type},
organization_id=organization_id,
user_id=user_id)
def get_act_status(self,regis_start_time,regis_end_time,start_time,end_time):
current_datatime = PublicFunc.get_current_datetime()
if current_datatime < regis_start_time: return {'flag':0,'name':'预告'}
if current_datatime < regis_end_time: return {'flag':1,'name':'报名中'}
if current_datatime < start_time: return {'flag':2,'name':'马上开始'}
if current_datatime < end_time: return {'flag':3,'name':'进行中'}
else: return {'flag':4,'name':'已结束'}
return '结束'
def add_pic(self,uid,album_id,file_name,org_id):
# create_time = int(time.time())
create_time = PublicFunc.get_current_datetime()
type = self.org_pic
web_path = options.ipnet + "/Uploads/AlbumPic/" + file_name
self.insert_into_db({'user_id':uid,'create_time':create_time,'type':type,'type_id':org_id,'target_id':album_id,'file_path':'','web_path':web_path,
'file_name':file_name,'file_path':self.file_path,'file_old_name':'','old_width':0,'old_height':0,'old_size':0,
'msg':''})
return
def save_trace(self, uid, logitude, latitude):
current_time = PublicFunc.get_current_stamp()
current_date = PublicFunc.get_current_datetime()
result = self.insert_into_db({
'uid': uid,
'logitude': logitude,
'latitude': latitude,
'timestamp': current_time,
'date_time': current_date
})
return
def create_album(self, uid, org_id, album_name):
data_dict = {
'organization_id': org_id,
'name': album_name,
'create_time': PublicFunc.get_current_datetime(),
'count': 0,
'show_times': 0,
'msg': '',
'create_user': uid
}
va = self.insert_into_db(data_dict)
return va
def attend_activity(self, activity_id, user_id, truename, tel, sex):
create_time = PublicFunc.get_current_datetime()
info_dict = {
"activity_id": activity_id,
"user_id": user_id,
"true_name": truename,
"tel": tel,
"sex": sex,
"create_time": create_time
}
self.insert_into_db(info_dict)
return True
def add_pic(self, uid, album_id, file_name, org_id):
# create_time = int(time.time())
create_time = PublicFunc.get_current_datetime()
type = self.org_pic
web_path = options.ipnet + "/Uploads/AlbumPic/" + file_name
self.insert_into_db({
'user_id': uid,
'create_time': create_time,
'type': type,
'type_id': org_id,
'target_id': album_id,
'file_path': '',
'web_path': web_path,
'file_name': file_name,
'file_path': self.file_path,
'file_old_name': '',
'old_width': 0,
'old_height': 0,
'old_size': 0,
'msg': ''
})
return
def judge_has_focus(self, organization_id, user_id):
"""
return True if has focus else False
"""
info = self.find_data(['type'],
organization_id=organization_id,
user_id=user_id,
get_some=False)
if not info:
self.insert_into_db({
'user_id':
user_id,
'organization_id':
organization_id,
'msg':
'',
'type':
0,
'change_date':
PublicFunc.get_current_datetime()
})
return False
return True if int(info['type']) & (self.has_focus + self.is_admin +
self.is_ord_memeber) else False
def set_user_member(self,organization_id,user_id,excuse):
info = self.find_data(['type'],organization_id=organization_id,user_id=user_id,get_some=False)
if not info:#如果没有该条数据
info = {}
info['type'] = 0
self.insert_into_db({"organization_id":organization_id,"user_id":user_id,"type":self.is_ord_memeber,"msg":excuse,"change_date":PublicFunc.get_current_datetime()})
return
new_type = info['type'] | self.is_ord_memeber
return self.update_db({'type':new_type},organization_id=organization_id,user_id=user_id,msg=excuse,change_date=PublicFunc.get_current_datetime())
def judge_has_focus(self,organization_id,user_id):
"""
return True if has focus else False
"""
info = self.find_data(['type'],organization_id=organization_id,user_id=user_id,get_some=False)
if not info:
self.insert_into_db({'user_id':user_id,'organization_id':organization_id,'msg':'','type':0,'change_date':PublicFunc.get_current_datetime()})
return False
return True if int(info['type']) & (self.has_focus + self.is_admin + self.is_ord_memeber) else False
def set_user_apply(self,organization_id,user_id,excuse):
"""
设置用户为申请状态
"""
info = self.find_data(['type'],organization_id=organization_id,user_id=user_id,get_some=False)
if not info:#如果没有该条数据
info = {}
info['type'] = 0
self.insert_into_db({"organization_id":organization_id,"user_id":user_id,"type":self.is_applying,"msg":excuse,"change_date":PublicFunc.get_current_datetime()})
return
new_type = info['type'] | self.is_applying
return self.update_db({'type':new_type},organization_id=organization_id,user_id=user_id)
def get_act_info(self,uid,activity_id):
"""
attend_status_name 状态名称
attend_status 状态id
attend_status attend_status_name
0 已经报名
1 报名未开始
2 报名
3 报名结束
4 参与中
5 进行中
6 已结束
"""
act_info = ActivityInfoModel().get_act_info(activity_id)
# 'co_organizer','organizer','supporting_agency','crowner_crowner'
act_info['co_organizer'] = act_info['co_organizer'].split('||') if act_info['co_organizer'] else []
act_info['organizer'] = act_info['organizer'].split("||") if act_info['organizer'] else []
act_info['sponsor_sponsor'] = act_info['sponsor_sponsor'].split("||") if act_info['sponsor_sponsor'] else []
act_info['supporting_agency'] = act_info['supporting_agency'].split("||") if act_info['supporting_agency'] else []
act_info['crowner_crowner'] = act_info['crowner_crowner'].split("||") if act_info['crowner_crowner'] else []
act_info['time_scope'] = act_info['start_time'] + "至" + act_info['end_time']
act_info_status = self.get_act_status(act_info['regis_start_time'],act_info['regis_end_time'],act_info['start_time'],act_info['end_time'])
act_info['activity_status'] = act_info_status['name']
act_info['activity_status_id'] = act_info_status['flag']
act_info['regist_avail'] = act_info['regis_max'] - act_info['regist_member']
attend_status = 0 #init status id
attend_status_name = ''#init status name
user_has_attend = int(ActivitySignUpModel().judge_have_attend(uid,activity_id))
current_datatime = PublicFunc.get_current_datetime()
if current_datatime < act_info['regis_start_time']:
attend_status = 1
attend_status_name = '报名未开始'
elif current_datatime < act_info['regis_end_time']:
if user_has_attend:
attend_status = 0
attend_status_name = '已报名'
else:
attend_status = 2
attend_status_name = '报名'
elif current_datatime < act_info['start_time']:
if user_has_attend:
attend_status = 0
attend_status_name = '已报名'
else:
attend_status = 3
attend_status_name = '报名结束'
elif current_datatime < act_info['end_time']:
if user_has_attend:
attend_status = 4
attend_status_name = '参与中'
else:
attend_status = 5
attend_status_name = '进行中'
elif current_datatime > act_info['end_time']:
attend_status = 6
attend_status_name = '已结束'
act_info['attend_status'] = attend_status
act_info['attend_status_name'] = attend_status_name
##if the man has agree the activity???
act_info['have_zan'] = 1 if '|' + str(uid) + "|" in act_info['like_list'] else 0
return act_info
def save_trace(self,uid,logitude,latitude):
current_time = PublicFunc.get_current_stamp()
current_date = PublicFunc.get_current_datetime()
result = self.insert_into_db({'uid':uid,'logitude':logitude,'latitude':latitude,'timestamp':current_time,'date_time':current_date})
return
def create_album(self,uid,org_id,album_name):
data_dict = {'organization_id':org_id,'name':album_name,'create_time':PublicFunc.get_current_datetime(),'count':0,'show_times':0,'msg':'','create_user':uid}
va = self.insert_into_db(data_dict)
return va