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(): # 排序字段 sidx = web_helper.get_query('sidx', '', False) # 排序方式 sord = web_helper.get_query('sord', '', False) # 初始化输出格式 data = {'rows': []} # 排序sql order_by = 'sort asc' if sidx: order_by = sidx + ' ' + sord if not order_by: order_by = ' id desc ' # 获取数据 sql_data = 'select * from product_class order by %(orderby)s ' % { 'orderby': order_by } result = db_helper.read(sql_data) if result: data['rows'] = result if data: return web_helper.return_raise( json.dumps(data, cls=json_helper.CJsonEncoder)) 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(): # 页面索引 page_number = convert_helper.to_int_default( web_helper.get_query('page', '', False), 1) # 页面显示记录数量 page_size = convert_helper.to_int_default( web_helper.get_query('rows', '', False), 10) # page_size = 2 # 排序字段 sidx = web_helper.get_query('sidx', '', False) # 排序方式 sord = web_helper.get_query('sord', '', False) # 初始化输出格式 data = { 'records': 0, # 总记录数 'total': 0, # 总页数 'page': 1, # 页数 'rows': [] } # 获取记录总数 sql_count = 'select count(1) as records from product_class' result = db_helper.read(sql_count) if not result or result[0]['records'] == 0: return data data['records'] = result[0].get('records', 0) # 计算总页数 if data['records'] % page_size == 0: page_total = data['records'] // page_size else: page_total = data['records'] // page_size + 1 data['total'] = page_total data['page'] = page_number # 排序sql order_by = 'sort asc' if sidx: order_by = sidx + ' ' + sord if not order_by: order_by = ' id desc ' # 分页sql record_number = (page_number - 1) * page_size paging = ' limit ' + str(page_size) + ' offset ' + str(record_number) # 获取数据 sql_data = 'select * from product_class order by %(orderby)s %(paging)s' % { 'orderby': order_by, 'paging': paging } result = db_helper.read(sql_data) if result: data['rows'] = result if data: return web_helper.return_raise( json.dumps(data, cls=json_helper.CJsonEncoder)) 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 ArticalOnly(): uid = web_helper.get_query('id', '主键(时间戳)') print("uid", uid) selectThisArtical = """ select "artical_name", "artical_type", "likesnum", "answernum", "readnum", "artical" from "articaltable" where id = '%s' """ % (uid) recode_result = db_helper.read(selectThisArtical) return web_helper.return_msg(0, '查询成功', recode_result)
def get_visit(): scanEmail_helper.fun_timer() ip_inner = web_helper.get_ip() ip_outer = web_helper.get_query("IP", "ip_outer") province = web_helper.get_query('province', '省') city = web_helper.get_query('city', '市') district = web_helper.get_query('district', '区县') sql = """SELECT code FROM "cityInfomation" WHERE name = '%s' and "parentCode" = (select code from "cityInfomation" where name = '%s')""" % ( district, city, ) manager_result = db_helper.read(sql) # 判断用户记录是否存在 code = manager_result[0].get('code', '').rstrip() sql_2 = """SELECT COUNT(1) FROM "visitRecode" WHERE code='%s'""" % (code) recode_result = db_helper.read(sql_2) count = recode_result[0].get('count', '') if count > 0: sql = """ UPDATE "visitRecode" SET valueindex=valueindex+1 WHERE code='%s'; """ % (code) data = () db_helper.write(sql, data) else: t = int(time.time()) insert = """ insert into "visitRecode" ("dateTime", "visitIP", "code", "ip_inner", valueIndex) values (%s, %s, %s, %s, 1) """ data = (t, ip_outer, code, ip_inner) db_helper.write(insert, data) return web_helper.return_msg(0, 'success')
def callback(): id = web_helper.get_query('id', '', False) id = convert_helper.to_int_default(id, 0) # 判断分类有没有被引用 sql = 'select count(1) as records from product where product_class_id=%s' % str( id) result = db_helper.read(sql) if result and result[0].get('records', -1) > 0: return web_helper.return_msg(-1, '该分类已被引用,请清除对该分类的绑定后再来删除') else: sql = 'delete from product_class where id=%s returning id' % (id) val = (id) result = db_helper.write(sql, val) if result: return web_helper.return_msg(0, '成功') 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 test(): name = web_helper.get_query('name', '', False) return name
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, "查询失败")