def query_page(self, name = '', productUserRealName = '', devUserRealName = '',
status = 0, page = 1 , size = 12):
sql = self._query_sql
isdelete = state.Boole['false']
ps = [isdelete]
if 0 != status:
sql = sql + ' and status = %s '
ps.append(status)
if '' != name:
sql = sql + ' and name like %s '
ps.append('%'+name+'%')
if '' != productUserRealName:
sql = sql + ' and productUserRealName like %s '
ps.append('%'+productUserRealName+'%')
if '' != devUserRealName:
sql = sql + ' and devUserRealName like %s '
ps.append('%'+devUserRealName+'%')
sql = sql + ' order by createTime desc '
yz = tuple(ps)
projects = mysql.find_page(sql, yz, self._query_col, page, size)
if None != projects['data']:
for r in projects['data']:
r['statusname'] = state.ProjectStatus.get(r['status'])
return projects
def query_page(self,
name='',
productUserRealName='',
devUserRealName='',
status=0,
page=1,
size=12):
sql = self._query_sql
isdelete = state.Boole['false']
ps = [isdelete]
if 0 != status:
sql = sql + ' and status = %s '
ps.append(status)
if '' != name:
sql = sql + ' and name like %s '
ps.append('%' + name + '%')
if '' != productUserRealName:
sql = sql + ' and productUserRealName like %s '
ps.append('%' + productUserRealName + '%')
if '' != devUserRealName:
sql = sql + ' and devUserRealName like %s '
ps.append('%' + devUserRealName + '%')
sql = sql + ' order by createTime desc '
yz = tuple(ps)
projects = mysql.find_page(sql, yz, self._query_col, page, size)
if None != projects['data']:
for r in projects['data']:
r['statusname'] = state.ProjectStatus.get(r['status'])
return projects
def query_by_type_userName_status_begin_end(self, type, userName, status, startDate, endDate, page = 1, size = 12):
sql = self._query_sql
isdelete = state.Boole['false']
ps = [isdelete]
if 0 != type:
sql = sql + ' and t.type = %s '
ps.append(type)
if not str_helper.is_null_or_empty(userName):
sql = sql + ' and t.userName = %s '
ps.append(userName)
if 0 != status:
sql = sql + ' and t.`status` = %s '
ps.append(status)
if not str_helper.is_null_or_empty(startDate):
sql = sql + ' and t.startDate >= %s '
ps.append(startDate)
if not str_helper.is_null_or_empty(endDate):
sql = sql + ' and t.startDate <= %s '
ps.append(endDate)
sql = sql + ' order by t.startDate asc '
yz = tuple(ps)
tasks = mysql.find_page(sql, yz, self._query_col, page, size)
if None != tasks['data']:
for r in tasks['data']:
r = self._format_task_status_type(r)
return tasks
def query_by_type_userName_status_begin_end(self,
type,
userName,
status,
startDate,
endDate,
page=1,
size=12):
sql = self._query_sql
isdelete = state.Boole['false']
ps = [isdelete]
if 0 != type:
sql = sql + ' and t.type = %s '
ps.append(type)
if not str_helper.is_null_or_empty(userName):
sql = sql + ' and t.userName = %s '
ps.append(userName)
if 0 != status:
sql = sql + ' and t.`status` = %s '
ps.append(status)
if not str_helper.is_null_or_empty(startDate):
sql = sql + ' and t.startDate >= %s '
ps.append(startDate)
if not str_helper.is_null_or_empty(endDate):
sql = sql + ' and t.startDate <= %s '
ps.append(endDate)
sql = sql + ' order by t.startDate asc '
yz = tuple(ps)
tasks = mysql.find_page(sql, yz, self._query_col, page, size)
if None != tasks['data']:
for r in tasks['data']:
r = self._format_task_status_type(r)
return tasks
def query_page( id = '', name = '', realName = '', departmentID = 0,tel = '', mobile = '', email = '', status = 0,
createTimeBegin = 0, createTimeEnd = 0, lastUpdateTimeBegin = 0, lastUpdateTimeEnd = 0, page = 1, size = 12):
sql = _query_sql
isdelete = state.Boole['false']
ps = [isdelete]
if '' != id:
sql = sql + ' and u.id = %s '
ps.append(id)
if 0 != status:
sql = sql + ' and u.status = %s '
ps.append(status)
if 0 != departmentID:
sql = sql + ' and u.departmentID = %s '
ps.append(departmentID)
if '' != name:
sql = sql + ' and u.name like %s '
ps.append('%'+name+'%')
if '' != realName:
sql = sql + ' and u.realName like %s '
ps.append('%'+realName+'%')
if '' != tel:
sql = sql + ' and u.tel like %s '
ps.append('%'+tel+'%')
if '' != email:
sql = sql + ' and u.email like %s '
ps.append('%'+email+'%')
if '' != mobile:
sql = sql + ' and u.mobile like %s '
ps.append('%'+mobile+'%')
# if None != createTimeBegin and '' != createTimeBegin:
# sql = sql + ' and u.createTime >= %s '
# ps.append(createTimeBegin)
# if None != createTimeEnd and '' != createTimeEnd:
# sql = sql + ' and u.createTime <= %s '
# ps.append(createTimeEnd)
# if None != lastUpdateTimeBegin and '' != lastUpdateTimeBegin:
# sql = sql + ' and u.lastUpdateTime >= %s '
# ps.append(lastUpdateTimeBegin)
# if None != lastUpdateTimeEnd and '' != lastUpdateTimeEnd:
# sql = sql + ' and u.lastUpdateTime <= %s '
# ps.append(lastUpdateTimeEnd)
yz = tuple(ps)
sql = sql + ' order by u.user_id desc '
print(sql)
users = mysql.find_page(sql, yz, _query_col, page, size)
rid = 1
if None != users['aaData']:
for r in users['aaData']:
r['DT_RowId'] = 'row_' + str(rid)
r['user_beginDate'] = str(r['user_beginDate'])[0:10]
r['user_endDate'] = str(r['user_endDate'])[0:10]
r['user_status'] = state.UserStatus.get(r['user_status'])
rid += 1
return users
def query_page_by_roleid( roleID = '', userName = '', page = 1, size = 12):
sql = _query_role_all_user_sql
isdelete = state.Boole['false']
ps = [ roleID, isdelete, roleID, isdelete, isdelete ]
if not str_helper.is_null_or_empty(userName):
sql = sql + ' and u.name = %s '
ps.append(userName)
yz = tuple(ps)
sql = sql + ' order by u.departmentID asc , u.id desc '
users = mysql.find_page(sql, yz, _query_col, page, size)
if None != users['data']:
for r in users['data']:
r['beginDate'] = str(r['beginDate'])[0:10]
r['endDate'] = str(r['endDate'])[0:10]
r['statusname'] = state.UserStatus.get(r['status'])
return users
def query_page(name='', status=0, page=1, size=12):
sql = _query_sql
isdelete = state.Boole['false']
ps = [isdelete]
if 0 != status:
sql = sql + ' and status = %s '
ps.append(status)
if '' != name:
sql = sql + ' and name like %s '
ps.append('%' + name + '%')
sql = sql + ' order by createTime asc '
yz = tuple(ps)
deps = mysql.find_page(sql, yz, _query_col, page, size)
if None != deps['data']:
for r in deps['data']:
r['statusname'] = state.Status.get(r['status'])
return deps
def query_page(name = '', status = 0, page = 1 , size = 12):
sql = _query_sql
isdelete = state.Boole['false']
ps = [isdelete]
if 0 != status:
sql = sql + ' and status = %s '
ps.append(status)
if '' != name:
sql = sql + ' and name like %s '
ps.append('%'+name+'%')
sql = sql + ' order by createTime asc '
yz = tuple(ps)
deps = mysql.find_page(sql, yz, _query_col, page, size)
if None != deps['data']:
for r in deps['data']:
r['statusname'] = state.Status.get(r['status'])
return deps
def query_page( id = '', name = '', status = 0, page = 1, size = 12):
sql = _query_sql
isdelete = state.Boole['false']
ps = [isdelete]
if '' != id:
sql = sql + ' and id = %s '
ps.append(id)
if 0 != status:
sql = sql + ' and status = %s '
ps.append(status)
if '' != name:
sql = sql + ' and name like %s '
ps.append('%'+name+'%')
yz = tuple(ps)
sql = sql + ' order by id desc '
roles = mysql.find_page(sql, yz, _query_col, page, size)
if None != roles['data']:
for r in roles['data']:
r['statusname'] = state.Status.get(r['status'])
return roles
def query_page(id='', name='', status=0, page=1, size=12):
sql = _query_sql
isdelete = state.Boole['false']
ps = [isdelete]
if '' != id:
sql = sql + ' and id = %s '
ps.append(id)
if 0 != status:
sql = sql + ' and status = %s '
ps.append(status)
if '' != name:
sql = sql + ' and name like %s '
ps.append('%' + name + '%')
yz = tuple(ps)
sql = sql + ' order by id desc '
usergroups = mysql.find_page(sql, yz, _query_col, page, size)
if None != usergroups['data']:
for r in usergroups['data']:
r['statusname'] = state.Status.get(r['status'])
return usergroups
def query_page(operID, operUserName, appCode, funcPath, action, operIp,
beginTime, endTime, page, size):
sql = _query_sql
ps = []
if None != operID and 0 != operID:
sql = sql + ' and u.operID = %s '
ps.append(operID)
if None != operUserName and '' != operUserName:
sql = sql + ' and u.operUserName = %s '
ps.append(operUserName)
if None != appCode and '' != appCode:
sql = sql + ' and u.appCode = %s '
ps.append(appCode)
if None != funcPath and '' != funcPath:
sql = sql + ' and u.funcPath = %s '
ps.append(funcPath)
if None != action and '' != action:
sql = sql + ' and u.action = %s '
ps.append(action)
if None != operIp and '' != operIp:
sql = sql + ' and u.operIp = %s '
ps.append(operIp)
if None != beginTime and '' != beginTime:
sql = sql + ' and u.operTime >= %s '
ps.append(beginTime + ' 00:00:00')
if None != endTime and '' != endTime:
sql = sql + ' and u.operTime <= %s '
ps.append(endTime + ' 23:59:59')
yz = tuple(ps)
sql = sql + ' order by u.id desc '
logs = mysql.find_page(sql, yz, _query_col, page, size)
if None != logs['data']:
for r in logs['data']:
# r['operTime'] = str(r['operTime'])[0:20]
r['actionname'] = state.logAction[r['action']]
return logs
def query_page( operID , operUserName, appCode, funcPath, action, operIp, beginTime, endTime, page, size):
sql = _query_sql
ps = []
if None != operID and 0 != operID:
sql = sql + ' and u.operID = %s '
ps.append(operID)
if None != operUserName and '' != operUserName:
sql = sql + ' and u.operUserName = %s '
ps.append(operUserName)
if None != appCode and '' != appCode:
sql = sql + ' and u.appCode = %s '
ps.append(appCode)
if None != funcPath and '' != funcPath:
sql = sql + ' and u.funcPath = %s '
ps.append(funcPath)
if None != action and '' != action:
sql = sql + ' and u.action = %s '
ps.append(action)
if None != operIp and '' != operIp:
sql = sql + ' and u.operIp = %s '
ps.append(operIp)
if None != beginTime and '' != beginTime:
sql = sql + ' and u.operTime >= %s '
ps.append(beginTime + ' 00:00:00')
if None != endTime and '' != endTime:
sql = sql + ' and u.operTime <= %s '
ps.append(endTime+ ' 23:59:59')
yz = tuple(ps)
sql = sql + ' order by u.id desc '
logs = mysql.find_page(sql, yz, _query_col, page, size)
if None != logs['data']:
for r in logs['data']:
# r['operTime'] = str(r['operTime'])[0:20]
r['actionname'] = state.logAction[r['action']]
return logs
def query_page(self, id = '', name = '', realName = '', departmentID = 0,
tel = '', mobile = '', email = '', status = 0, page = 1, size = 12):
sql = self._query_sql
isdelete = state.Boole['false']
ps = [isdelete]
if '' != id:
sql = sql + ' and id = %s '
ps.append(id)
if 0 != status:
sql = sql + ' and status = %s '
ps.append(status)
if 0 != departmentID:
sql = sql + ' and departmentID = %s '
ps.append(departmentID)
if '' != name:
sql = sql + ' and name like %s '
ps.append('%'+name+'%')
if '' != realName:
sql = sql + ' and realName like %s '
ps.append('%'+realName+'%')
if '' != tel:
sql = sql + ' and tel like %s '
ps.append('%'+tel+'%')
if '' != email:
sql = sql + ' and email like %s '
ps.append('%'+email+'%')
if '' != mobile:
sql = sql + ' and mobile like %s '
ps.append('%'+mobile+'%')
yz = tuple(ps)
sql = sql + ' order by id desc '
users = mysql.find_page(sql, yz, self._query_col, page, size)
if None != users['data']:
for r in users['data']:
r['statusname'] = state.UserStatus.get(r['status'])
return users
def query_page_group_roles(self, userGroupID, page = 1, size = 12):
isdelete = state.Boole['false']
yz = (userGroupID, isdelete, state.statusActive)
roles = mysql.find_page(self._query_group_roles_sql, yz, self._query_group_roles_col, page, size)
return roles
def query_page_role_groups( roleID, page = 1, size = 12):
isdelete = state.Boole['false']
yz = (roleID, isdelete, state.statusActive)
roles = mysql.find_page(_query_role_groups_sql, yz, _query_role_groups_col, page, size)
return roles
def query_page_group_roles(userGroupID, page=1, size=12):
isdelete = state.Boole['false']
yz = (userGroupID, isdelete, state.statusActive)
roles = mysql.find_page(_query_group_roles_sql, yz, _query_group_roles_col,
page, size)
return roles
def query_page_user_groups(userID, page=1, size=12):
isdelete = state.Boole['false']
yz = (userID, isdelete, state.statusActive)
users = mysql.find_page(_query_user_groups_sql, yz, _query_user_groups_col,
page, size)
return users
def query_page_user_roles( userID, page = 1, size = 12):
isdelete = state.Boole['false']
yz = (userID, isdelete, state.statusActive)
roles = mysql.find_page(_query_user_roles_sql, yz, _query_user_roles_col, page, size)
return roles
def query_page_group_users( userGroupID, page = 1, size = 12):
isdelete = state.Boole['false']
yz = (userGroupID, isdelete, state.statusActive)
users = mysql.find_page(_query_group_users_sql, yz, _query_group_users_col, page, size)
return users
def query_page_user_groups(self, userID, page = 1, size = 12):
isdelete = state.Boole['false']
yz = (userID, isdelete, state.statusActive)
users = mysql.find_page(self._query_user_groups_sql, yz, self._query_user_groups_col, page, size)
return users
