def test_to_int(self):
self.assertEqual(convert_helper.to_int('1'), 1)
self.assertEqual(convert_helper.to_int('1.0'), 0)
self.assertEqual(convert_helper.to_int('1a'), 0)
self.assertEqual(convert_helper.to_int('aaa'), 0)
self.assertEqual(convert_helper.to_int(''), 0)
self.assertEqual(convert_helper.to_int(None), 0)
self.assertEqual(convert_helper.to_int('-1'), -1)
self.assertEqual(convert_helper.to_int(10), 10)
self.assertEqual(convert_helper.to_int(-10), -10)
self.assertEqual(convert_helper.to_int0('1'), 1)
self.assertEqual(convert_helper.to_int0('1.0'), 0)
self.assertEqual(convert_helper.to_int0('1a'), 0)
self.assertEqual(convert_helper.to_int0('aaa'), 0)
self.assertEqual(convert_helper.to_int0(''), 0)
self.assertEqual(convert_helper.to_int0(None), 0)
self.assertEqual(convert_helper.to_int0('-1'), 0)
self.assertEqual(convert_helper.to_int0(10), 10)
self.assertEqual(convert_helper.to_int0(-10), 0)
self.assertEqual(convert_helper.to_int1('1'), 1)
self.assertEqual(convert_helper.to_int1('1.0'), 1)
self.assertEqual(convert_helper.to_int1('1a'), 1)
self.assertEqual(convert_helper.to_int1('aaa'), 1)
self.assertEqual(convert_helper.to_int1(''), 1)
self.assertEqual(convert_helper.to_int1(None), 1)
self.assertEqual(convert_helper.to_int1('-1'), 1)
self.assertEqual(convert_helper.to_int1(10), 10)
self.assertEqual(convert_helper.to_int1(-10), 2)
print(convert_helper.to_int1(-10))
def callback():
"""
获取列表数据
"""
# 检查用户权限
_common_logic.check_user_power()
# 父id
parent_id = convert_helper.to_int0(web_helper.get_query('nodeid', '', is_check_null=False))
# 页面索引
page_number = convert_helper.to_int1(web_helper.get_query('page', '', is_check_null=False))
# 页面页码与显示记录数量
page_size = convert_helper.to_int0(web_helper.get_query('rows', '', is_check_null=False))
# 接收排序参数
sidx = web_helper.get_query('sidx', '', is_check_null=False)
sord = web_helper.get_query('sord', '', is_check_null=False)
# 初始化排序字段
order_by = 'sort asc'
if sidx:
order_by = sidx + ' ' + sord
_department_logic = department_logic.DepartmentLogic()
# 读取记录
wheres = 'parent_id=' + str(parent_id)
result = _department_logic.get_list('*', wheres, page_number, page_size, order_by)
if result:
return json.dumps(result)
else:
return web_helper.return_msg(-1, "查询失败")
def callback():
"""
获取列表数据
"""
# 检查用户权限
_common_logic.check_user_power()
# 页面索引
page_number = convert_helper.to_int1(
web_helper.get_query('page', '', is_check_null=False))
# 页面页码与显示记录数量
page_size = convert_helper.to_int0(
web_helper.get_query('rows', '', is_check_null=False))
sidx = web_helper.get_query('sidx', '', is_check_null=False)
sord = web_helper.get_query('sord', '', is_check_null=False)
# 初始化排序字段
order_by = 'id asc'
if sidx:
order_by = sidx + ' ' + sord
_manager_logic = manager_logic.ManagerLogic()
# 读取记录
result = _manager_logic.get_list('*', '', page_number, page_size, order_by)
if result:
return json.dumps(result, cls=json_helper.CJsonEncoder)
else:
return web_helper.return_msg(-1, "查询失败")
def callback():
"""
获取列表数据
"""
# 检查用户权限
_common_logic.check_user_power()
# 部门id
department_id = convert_helper.to_int0(
web_helper.get_query('department_id', '部门id'))
# 页面索引
page_number = convert_helper.to_int1(
web_helper.get_query('page', '', is_check_null=False))
# 页面页码与显示记录数量
page_size = convert_helper.to_int0(
web_helper.get_query('rows', '', is_check_null=False))
sidx = web_helper.get_query('sidx', '', is_check_null=False)
sord = web_helper.get_query('sord', '', is_check_null=False)
# 初始化排序字段
order_by = 'id asc'
if sidx:
order_by = sidx + ' ' + sord
_positions_logic = positions_logic.PositionsLogic()
# 读取记录
wheres = ''
if department_id:
wheres = 'department_id=' + str(department_id)
result = _positions_logic.get_list('*', wheres, page_number, page_size,
order_by)
if result:
# 直接输出json
return json.dumps(result)
else:
return web_helper.return_msg(-1, "查询失败")
def callback():
"""
获取列表数据
"""
# 检查用户权限
_common_logic.check_user_power()
# 查询条件
wheres = []
start_time = convert_helper.to_date(
web_helper.get_query('start_time', '开始时间', is_check_null=False))
if start_time:
wheres.append('add_time>=' + string(start_time))
end_time = convert_helper.to_date(
web_helper.get_query('end_time', '结束时间', is_check_null=False))
if end_time:
end_time = datetime_helper.timedelta('d', end_time, 1)
wheres.append('add_time<' + string(end_time))
manager_name = web_helper.get_query('manager_name',
'管理员姓名',
is_check_null=False)
if manager_name:
wheres.append('manager_name like \'%' + manager_name + '%\'')
ip = web_helper.get_query('ip', 'ip', is_check_null=False)
if ip:
wheres.append('ip like \'' + ip + '%\'')
remark = web_helper.get_query('remark', '操作内容', is_check_null=False)
if remark:
wheres.append('remark like \'%' + remark + '%\'')
# 页面索引
page_number = convert_helper.to_int1(
web_helper.get_query('page', '', is_check_null=False))
# 页面页码与显示记录数量
page_size = convert_helper.to_int0(
web_helper.get_query('rows', '', is_check_null=False))
sidx = web_helper.get_query('sidx', '', is_check_null=False)
sord = web_helper.get_query('sord', '', is_check_null=False)
# 初始化排序字段
order_by = 'id desc'
if sidx:
order_by = sidx + ' ' + sord
_manager_operation_log_logic = manager_operation_log_logic.ManagerOperationLogLogic(
)
# 读取记录
result = _manager_operation_log_logic.get_list('*', wheres, page_number,
page_size, order_by)
if result:
# 直接输出json
return json.dumps(result, cls=json_helper.CJsonEncoder)
else:
return web_helper.return_msg(-1, "查询失败")
def callback():
"""
获取列表数据
"""
# 产品分类id
product_class_id = convert_helper.to_int0(
web_helper.get_query('product_class_id', '产品分类id',
is_check_null=False))
# 类型
type = web_helper.get_query('type', '类型', is_check_null=False)
# 页面索引
page_number = convert_helper.to_int1(
web_helper.get_query('page', '', is_check_null=False))
# 页面显示记录数量
page_size = convert_helper.to_int0(
web_helper.get_query('rows', '', is_check_null=False))
# 排序字段
sidx = web_helper.get_query('sidx', '', is_check_null=False)
# 顺序还是倒序排序
sord = web_helper.get_query('sord', '', is_check_null=False)
# 设置查询条件
wheres = []
if product_class_id > 0:
wheres.append('product_class_id=' + str(product_class_id))
# 判断是否是前台提交获取数据
if type != 'backstage':
wheres.append('is_enable=1')
# 初始化排序字段
orderby = None
### 设置排序 ###
if sidx:
orderby = sidx + ' ' + sord
# 实例化product表操作类ProductLogic
_product_logic = product_logic.ProductLogic()
result = _product_logic.get_list(
'*,(select name from product_class where id=product_class_id) as product_class_name',
wheres, page_number, page_size, orderby)
if result:
return web_helper.return_raise(
json.dumps(result, cls=json_helper.CJsonEncoder))
else:
return web_helper.return_msg(-1, "查询失败")
def callback():
"""
获取列表数据
"""
# 页面索引
page_number = convert_helper.to_int1(web_helper.get_query('page', '', False))
# 页面显示记录数量
page_size = convert_helper.to_int0(web_helper.get_query('rows', '', False))
# 排序字段
sidx = web_helper.get_query('sidx', '', False)
# 顺序还是倒序排序
sord = web_helper.get_query('sord', '', False)
# 初始化排序字段
order_by = 'sort asc'
if sidx:
order_by = sidx + ' ' + sord
#############################################################
# 初始化输出格式（前端使用jqgrid列表，需要指定输出格式）
data = {
'records': 0,
'total': 0,
'page': 1,
'rows': [],
}
#############################################################
# 执行sql，获取指定条件的记录总数量
sql = 'select count(1) as records from product_class'
result = db_helper.read(sql)
# 如果查询失败或不存在指定条件记录，则直接返回初始值
if not result or result[0]['records'] == 0:
return data
# 保存总记录数量
data['records'] = result[0].get('records', 0)
#############################################################
### 设置分页索引与页面大小 ###
# 设置分页大小
if page_size is None or page_size <= 0:
page_size = 10
# 计算总页数
if data['records'] % page_size == 0:
page_total = data['records'] // page_size
else:
page_total = data['records'] // page_size + 1
# 记录总页面数量
data['total'] = page_total
# 判断提交的页码是否超出范围
if page_number < 1 or page_number > page_total:
page_number = page_total
# 记录当前页面索引值
data['page'] = page_number
# 计算当前页面要显示的记录起始位置
record_number = (page_number - 1) * page_size
# 设置查询分页条件
paging = ' limit ' + str(page_size) + ' offset ' + str(record_number)
### 设置排序 ###
if not order_by:
order_by = 'id desc'
#############################################################
# 组合sql查询语句
sql = "select * from product_class order by %(orderby)s %(paging)s" % \
{'orderby': order_by, 'paging': paging}
# 读取记录
result = db_helper.read(sql)
if result:
# 存储记录
data['rows'] = result
if data:
# 直接输出json
return web_helper.return_raise(json.dumps(data, cls=json_helper.CJsonEncoder))
else:
return web_helper.return_msg(-1, "查询失败")
def callback():
"""
获取列表数据
"""
# 设置查询条件
wheres = ''
# 产品分类id
product_class_id = convert_helper.to_int0(web_helper.get_query('product_class_id', '产品分类id', is_check_null=False))
if product_class_id > 0:
wheres = 'where product_class_id=' + str(product_class_id)
# 页面索引
page_number = convert_helper.to_int1(web_helper.get_query('page', '', is_check_null=False))
# 页面显示记录数量
page_size = convert_helper.to_int0(web_helper.get_query('rows', '', is_check_null=False))
# 排序字段
sidx = web_helper.get_query('sidx', '', is_check_null=False)
# 顺序还是倒序排序
sord = web_helper.get_query('sord', '', is_check_null=False)
# 初始化排序字段
order_by = 'id desc'
if sidx:
order_by = sidx + ' ' + sord
# 类型
type = web_helper.get_query('type', '类型', is_check_null=False)
# 判断是否是前台提交获取数据
if type != 'backstage':
# 判断是否已经存在查询条件了，是的话在原查询条件后面拼接
if wheres:
wheres = wheres + ' and is_enable=1'
else:
wheres = 'where is_enable=1'
#############################################################
# 初始化输出格式（前端使用jqgrid列表，需要指定输出格式）
data = {
'records': 0,
'total': 0,
'page': 1,
'rows': [],
}
#############################################################
# 执行sql，获取指定条件的记录总数量
sql = 'select count(1) as records from product %(wheres)s' % {'wheres': wheres}
result = db_helper.read(sql)
# 如果查询失败或不存在指定条件记录，则直接返回初始值
if not result or result[0]['records'] == 0:
return data
# 保存总记录数量
data['records'] = result[0].get('records', 0)
#############################################################
### 设置分页索引与页面大小 ###
# 设置分页大小
if page_size is None or page_size <= 0:
page_size = 10
# 计算总页数
if data['records'] % page_size == 0:
page_total = data['records'] // page_size
else:
page_total = data['records'] // page_size + 1
# 记录总页面数量
data['total'] = page_total
# 判断提交的页码是否超出范围
if page_number < 1 or page_number > page_total:
page_number = page_total
# 记录当前页面索引值
data['page'] = page_number
# 计算当前页面要显示的记录起始位置
record_number = (page_number - 1) * page_size
# 设置查询分页条件
paging = ' limit ' + str(page_size) + ' offset ' + str(record_number)
### 设置排序 ###
if not order_by:
order_by = 'id desc'
#############################################################
# 组合sql查询语句
sql = "select * from product %(wheres)s order by %(orderby)s %(paging)s" % \
{'wheres': wheres, 'orderby': order_by, 'paging': paging}
# 读取记录
result = db_helper.read(sql)
if result:
# 存储记录
data['rows'] = result
if data:
# 直接输出json
return web_helper.return_raise(json.dumps(data, cls=json_helper.CJsonEncoder))
else:
return web_helper.return_msg(-1, "查询失败")
