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