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