def add_photo(self, user, photo):
usrDao = UserDAO()
roles = usrDao.get_role(user)
if '3' in roles:
session_power.add(photo)
session_power.commit()
return 1
else:
return -1
def add_tower(self, user, tower):
usrDao = UserDAO()
roles = usrDao.get_role(user)
if '3' in roles:
session_power.add(tower)
session_power.commit()
return 1
else:
return -1
def add_lines(self, user, lines):
usrDao = UserDAO()
roles = usrDao.get_role(user)
if '3' in roles:
for item in lines:
session_power.add(item)
session_power.commit()
return 1
else:
return -1
def add_photo(self, user, photo):
usrDao = UserDAO()
roles = usrDao.get_role(user)
if '3' in roles:
self.session_power.add(photo)
try:
self.session_power.commit()
except:
self.session_power.rollback()
return 1
else:
return 3030701
def update_tower(self, user, tower):
usrDao = UserDAO()
roles = usrDao.get_role(user)
if '3' in roles:
self.session_power.merge(tower)
try:
self.session_power.commit()
except:
self.session_power.rollback()
return 1
else:
return 3020501
def add_line(self, user, line):
usrDao = UserDAO()
roles = usrDao.get_role(user)
if '3' in roles:
self.session_power.add(line)
try:
self.session_power.commit()
except:
self.session_power.rollback()
return 1
else:
return 3010901
def add_photos(self, user, photos):
usrDao = UserDAO()
roles = usrDao.get_role(user)
if '3' in roles:
for item in photos:
self.session_power.add(item)
try:
self.session_power.commit()
except:
self.session_power.rollback()
return 1
else:
return 3030901
def query_tower_pages(self, user, voltage, work_team, line_name,
page_size):
q = self.session_power.query(Lines)
usrDao = UserDAO()
roles = usrDao.get_role(user)
if voltage:
q = q.filter(Lines.lines_voltage == voltage)
if work_team:
q = q.filter(Lines.lines_work_team == work_team)
if line_name:
q = q.filter(Lines.lines_name == line_name)
lines = q.filter(Lines.deleted == 0).all()
linenames = []
for line in lines:
linenames.append(line.lines_name)
towersNum = self.session_power.query(Towers).filter(
Towers.tower_linename.in_(linenames)).count() / page_size + 1
item = {}
item['pages'] = towersNum
return item
def query_line_condition(self, user, voltage, work_team, line_name,
page_size, page_index):
q = self.session_power.query(Lines)
usrDao = UserDAO()
roles = usrDao.get_role(user)
if voltage:
q = q.filter(Lines.lines_voltage == voltage)
if work_team:
q = q.filter(Lines.lines_work_team == work_team)
if line_name:
q = q.filter(Lines.lines_name == line_name)
lines = q.filter(Lines.deleted == 0).all()
linenames = []
for line in lines:
linenames.append(line.lines_name)
if len(linenames) > 0:
towers = self.session_power.query(Towers).filter(
Towers.tower_linename.in_(linenames)).limit(page_size).offset(
(page_index - 1) * page_size).all()
return class_to_dict(towers)
else:
return None