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