def update(self, party):
party_collection = getCollection(collectionName=self.__collectionName)
party_id = party['party_id']
party['update_time'] = getTime()
for key in party:
if key != 'party_id' and key != '_id' :
party_collection.update({'party_id': party_id}, {'$set': {key: party[key]}})
def findByOpenId(self, request_openId):
issue_collection = getCollection(collectionName=self.__collectionName)
query_key = {'request_openId': request_openId}
query_condition = {'$and': [self.__default_key, query_key]}
issueList = issue_collection.find(query_condition)
return issueList
def finds(self, license_num):
engineer_collection = getCollection(
collectionName=self.__collectionName)
query_key = {'license_num': license_num}
query_condition = {'$and': [self.default_key, query_key]}
engineers = engineer_collection.find(query_condition)
return engineers
def finds(self, license_num):
service_collection = getCollection(
collectionName=self.__collectionName)
query_key = {'license_num': license_num}
query_condition = {'$and': [self.__default_key, query_key]}
services = service_collection.find(query_condition)
return services
def findByOpenId(self, openId):
engineer_collection = getCollection(
collectionName=self.__collectionName)
query_key = {'openId': openId}
query_condition = {'$and': [self.default_key, query_key]}
engineer = engineer_collection.find_one(query_condition)
return engineer
def findById(self, service_id):
service_collection = getCollection(
collectionName=self.__collectionName)
query_key = {'service_id': service_id}
query_condition = {'$and': [self.__default_key, query_key]}
service = service_collection.find_one(query_condition)
return service
def findByEngineerId(self, engineer_id):
engineer_collection = getCollection(
collectionName=self.__collectionName)
query_key = {'engineer_id': engineer_id}
query_condition = {'$and': [self.default_key, query_key]}
engineer = engineer_collection.find_one(query_condition)
return engineer
def findByLicense(self, license_num):
issue_collection = getCollection(collectionName=self.__collectionName)
query_key = {'license_num': license_num}
query_condition = {'$and': [self.__default_key, query_key]}
issueList = issue_collection.find(query_condition)
return issueList
def findFocalByLicense(self, license_num):
engineer_collection = getCollection(
collectionName=self.__collectionName)
license_key = {'license_num': license_num}
type_key = {'type': '01'}
query_condition = {'$and': [type_key, license_key, self.default_key]}
engineer = engineer_collection.find_one(query_condition)
return engineer
def findByAttendeeId(self, attend_id):
attendee_collection = getCollection(
collectionName=self.__collectionName)
query_key = {'attend_id': attend_id}
query_condition = {'$and': [self.default_key, query_key]}
attendee = attendee_collection.find_one(query_condition)
return attendee
def findByOpenId(self, open_id):
attendee_collection = getCollection(
collectionName=self.__collectionName)
query_key = {'attendee_openid': open_id}
query_condition = {'$and': [self.default_key, query_key]}
attendees = attendee_collection.find(query_condition)
return attendees
def insert(self, doctor):
doctor_id = getTimeStamp()
doctor['doctor_id'] = doctor_id
doctor['create_time'] = getTime()
doctor['update_time'] = getTime()
doctor['delete_flag'] = '1'
doctor_collection = getCollection(collectionName=self.__collectionName)
doctor_collection.insert(doctor)
return doctor
def insert(self, wxsys):
#wxsys['program_id'] = getTimeStamp()
wxsys['access_token'] = ''
wxsys['program_message'] = ''
wxsys['create_time'] = getTime()
wxsys['update_time'] = getTime()
wxsys_collection = getCollection(collectionName=self.__collectionName)
wxsys_collection.insert(wxsys)
return wxsys['program_id']
def insert(self, attendee):
attendee['attend_id'] = getTimeStamp()
attendee['create_time'] = getTime()
attendee['update_time'] = getTime()
attendee['attend_status'] = '1'
attendee['payment_flag'] = '0'
attendee_collection = getCollection(
collectionName=self.__collectionName)
attendee_collection.insert(attendee)
return attendee['attend_id']
def insert(self, service):
service_id = getTimeStamp()
service['service_id'] = service_id
service['create_time'] = getTime()
service['update_time'] = getTime()
service['delete_flag'] = '1'
service_collection = getCollection(
collectionName=self.__collectionName)
service_collection.insert(service)
return service
def insert(self, party):
party['party_id'] = getTimeStamp()
party['create_time'] = getTime()
party['update_time'] = getTime()
party['party_status'] = '1'
party['party_attend_num'] = 0
party['payment_flag'] = '0'
party_collection = getCollection(collectionName=self.__collectionName)
party_collection.insert(party)
return party['party_id']
def update(self, wxsys):
wxsys_collection = getCollection(collectionName=self.__collectionName)
program_id = wxsys['program_id']
wxsys['update_time'] = getTime()
for key in wxsys:
if key != 'program_id' and key != '_id':
wxsys_collection.update({'program_id': program_id},
{'$set': {
key: wxsys[key]
}})
def update(self, attendee):
attendee_collection = getCollection(
collectionName=self.__collectionName)
attend_id = attendee['attend_id']
attendee['update_time'] = getTime()
for key in attendee:
if key != 'attend_id' and key != '_id':
attendee_collection.update({'attend_id': attend_id},
{'$set': {
key: attendee[key]
}})
def update(self, issue):
issue_collection = getCollection(collectionName=self.__collectionName)
issue_id = issue['issue_id']
issue['update_time'] = getTime()
for key in issue:
if key != 'issue_id' and key != '_id':
issue_collection.update({'issue_id': issue_id},
{'$set': {
key: issue[key]
}})
return issue
def insert(self, engineer):
engineer_id = getTimeStamp()
engineer['engineer_id'] = engineer_id
engineer['create_time'] = getTime()
engineer['update_time'] = getTime()
engineer['flag'] = '1'
engineer['openId'] = ''
engineer['nickname'] = ''
engineer_collection = getCollection(
collectionName=self.__collectionName)
engineer_collection.insert(engineer)
return engineer_id
def update(self, engineer):
engineer_collection = getCollection(
collectionName=self.__collectionName)
engineer_id = engineer['engineer_id']
engineer['update_time'] = getTime()
for key in engineer:
if key != 'engineer_id' and key != '_id':
engineer_collection.update({'engineer_id': engineer_id},
{'$set': {
key: engineer[key]
}})
return self.findByEngineerId(engineer_id=engineer_id)
def finds(self, party_id=None):
party_collection = getCollection(collectionName=self.__collectionName)
if None == party_id:
partys = party_collection.find()
return partys
else:
query_key = {'party_id': party_id}
query_condition = {'$and': [query_key]}
party = party_collection.find_one(query_condition)
return party
def find(self, party_id=None):
party_collection = getCollection(collectionName=self.__collectionName)
if None == party_id:
partys = party_collection.find(self.default_key)
return partys
else:
query_key = {'party_id' : party_id}
query_condition = {'$and' : [self.default_key, query_key]}
#print(query_condition)
party = party_collection.find_one(query_condition)
return party
def insert(self, wxsyslicense):
wxsyslicense['license_num'] = getTimeStamp()
if wxsyslicense['license_start_date'] == '':
wxsyslicense['license_start_date'] = getToday()
wxsyslicense['license_end_date'] = addDays(
wxsyslicense['license_start_date'],
int(wxsyslicense['license_period']) + 1)
wxsyslicense['focal_openId'] = ''
wxsyslicense['create_time'] = getTime()
wxsyslicense['update_time'] = getTime()
wxsyslicense_collection = getCollection(
collectionName=self.__collectionName)
wxsyslicense_collection.insert(wxsyslicense)
return wxsyslicense['license_num']
def findByParty(self, party_id=None):
attendee_collection = getCollection(
collectionName=self.__collectionName)
#隐藏之后的参与活动也能在活动状态画面查询到
#default_key = self.default_key.copy()
default_key = {'attend_status': {'$in': ['1', '8']}}
if None == party_id:
attendees = attendee_collection.find(default_key)
return attendees
else:
query_key = {'party_id': party_id}
query_condition = {'$and': [default_key, query_key]}
attendee = attendee_collection.find(query_condition)
return attendee
def insert(self, issue):
issue_id = getTimeStamp()
issue['issue_id'] = issue_id
issue['create_time'] = getTime()
issue['update_time'] = getTime()
issue['issue_status'] = '1'
issue['logs'] = [{
'openId': issue['request_openId'],
'nickname': issue['nickname'],
'description': '发起申请',
'create_time': getTime()
}]
issue_collection = getCollection(collectionName=self.__collectionName)
issue_collection.insert(issue)
return issue_id
def update(self, wxsyslicense):
wxsyslicense_collection = getCollection(
collectionName=self.__collectionName)
license_num = wxsyslicense['license_num']
wxsyslicense['license_end_date'] = addDays(
wxsyslicense['license_end_date'],
int(wxsyslicense['license_period']) + 1)
wxsyslicense['update_time'] = getTime()
for key in wxsyslicense:
if key != 'license_num' and key != '_id':
wxsyslicense_collection.update(
{'license_num': license_num},
{'$set': {
key: wxsyslicense[key]
}})
return license_num
def finds(self, license_num):
doctor_collection = getCollection(collectionName=self.__collectionName)
query_key = {'license_num': license_num}
query_condition = {'$and': [self.__default_key, query_key]}
doctors = doctor_collection.find(query_condition)
return doctors
def delete(self, license_num):
wxsys_collection = getCollection(collectionName=self.__collectionName)
delete_key = {'license_num': license_num}
result = wxsys_collection.delete_one(delete_key)
def finds(self):
wxsyslicense_collection = getCollection(
collectionName=self.__collectionName)
licenseList = wxsyslicense_collection.find()
return licenseList
