def admin_user_netcard_update(netcard_id, db):
vdbm = dbm.DbM(db)
#数据库字段名参考：netcard_id, nickname, image, commuity_user_id, user_id
utf_forms = bottle.request.forms.decode("utf-8")
vdbm.update(table='netcard',
condition=' where netcard_id=' + netcard_id,
form_dict=utf_forms.dict)
def admin_user_livingcard_update(livingcard_id, db):
vdbm = dbm.DbM(db)
#数据库字段名参考：livingcard_id, name, address, zip_code, house_number, user_id
utf_forms = bottle.request.forms.decode("utf-8")
vdbm.update(table='livingcard',
condition=' where livingcard_id=' + livingcard_id,
form_dict=utf_forms.dict)
def admin_user_citizencard_add(db):
vdbm = dbm.DbM(db)
# 数据库字段名参考：citizen_id, name, identification_type, identification_value, marriage_status,
# employment_status, residence_category, resident_status, education_status, politics_status,
# migration_status, income_status, nation, gender, relationship, user_id, apartment_id,
# age, status, phone
utf_forms = bottle.request.forms.decode("utf-8")
vdbm.insert(table='citizen_resident', **utf_forms)
def admin_user_partycard_update(partycard_id, db):
vdbm = dbm.DbM(db)
# 数据库字段名参考：partycard_id, relation, party_branch, position, type, status, join_date, confirm_date,
# inspection_person, application_id, user_id
utf_forms = bottle.request.forms.decode("utf-8")
vdbm.update(table='partycard',
condition=' where partycard_id=' + partycard_id,
form_dict=utf_forms.dict)
def admin_user_role_update(user_role_id, db):
role_id = bottle.request.forms.role_id
role_description = bottle.request.forms.role_description
user_role_description = bottle.request.forms.user_role_description
description_detail = bottle.request.forms.description_detail
role_type_id = bottle.request.forms.role_type_id
vdbm = dbm.DbM(db)
vdbm.update(table='role',
condition=' where role_id=' + role_id,
role_type_id=role_type_id,
description=role_description)
vdbm.update(table='user_role',
condition=' where user_role_id=' + user_role_id,
role_id=role_id,
description=user_role_description,
description_detail=description_detail)
def admin_user_update(userid, db):
password = bottle.request.forms.password
email = bottle.request.forms.email
name = bottle.request.forms.name
identity_number = bottle.request.forms.identity_number
card_id = bottle.request.forms.card_id
user_type_id = bottle.request.forms.user_type_id
# image = bottle.request.files.get('image')
# image.save('files')
vdbm = dbm.DbM(db)
vdbm.update(table='user',
condition=' where user_id=' + userid,
password=password,
email=email,
name=name,
identity_number=identity_number,
card_id=card_id,
user_type_id=user_type_id,
image='default.jpg')
def admin_user_partycard_add(db):
vdbm = dbm.DbM(db)
# 数据库字段名参考：partycard_id, relation, party_branch, position, type, status, join_date, confirm_date,
# inspection_person, application_id, user_id
utf_forms = bottle.request.forms.decode("utf-8")
vdbm.insert(table='partycard', **utf_forms)
def admin_user_netcard_add(db):
vdbm = dbm.DbM(db)
# 数据库字段名参考：netcard_id, nickname, image, commuity_user_id, user_id
utf_forms = bottle.request.forms.decode("utf-8")
vdbm.insert(table='netcard', **utf_forms)
def admin_user_livingcard_add(db):
vdbm = dbm.DbM(db)
# 数据库字段名参考：livingcard_id, name, address, zip_code, house_number, user_id
utf_forms = bottle.request.forms.decode("utf-8")
vdbm.insert(table='livingcard', **utf_forms)
def admin_user_role_add(db):
vdbm = dbm.DbM(db)
utf_forms = bottle.request.forms.decode("utf-8")
vdbm.insert(table='user_role', **utf_forms)
