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, "查询失败")