def ft_channels_edit_second():
start_response()
chid = get_formData('which_chid')
obj = deal_mysql()
msg = ("""SELECT ulv.channel_id,tvs.chname,ulv.gen_address
from ulv_genaddress as ulv inner join tvs_channel as tvs
on ulv.channel_id=tvs.chid and ulv.channel_id=%s""" % chid[0])
result = obj.askdata(msg)
info = result.pop(0)
headers = ["频道信息"]
print(yate.include_header("频道修改"))
print(yate.start_form("ft_channels_editDone.py"))
print(yate.start_table(tb_width="100%", tb_border="1px solid"))
print(yate.tb_header(headers))
print(yate.start_row())
print(yate.checked_radio_button('which_chid',[info[0],info[1]]))
print(yate.end_row())
print(yate.start_row())
print(yate.input_text("which_addr",info[2]))
print(yate.end_row())
print(yate.start_row())
print(yate.end_form("确定"))
print(yate.end_row())
print(yate.end_table())
obj.Close()
def select_sp():
obj = deal_mysql("uspset.ini")
msg = '''select id,name from u_sp'''
results = obj.askdata(msg)
obj.Close()
headers = ["运营商名称"]
print(yate.start_response())
print(yate.include_header("首页运营"))
print(yate.start_form("op_guidepage_arrange.py"))
print(yate.start_table(tb_width="50%", tb_border="1px solid"))
print(yate.tb_header(headers))
for array in results:
print(yate.start_row())
print(yate.checked_radio_button('which_spid',[array[0],array[1]]))
print(yate.end_row())
print(yate.end_table())
print(yate.start_table(tb_width="50%", tb_border="1px solid"))
print(yate.start_row())
print(yate.end_form("确定"))
print(yate.end_row())
print(yate.end_table())
def ft_channels_editFirst():
obj = deal_mysql()
msg = ('''SELECT ulv.channel_id,tvs.chname
from ulv_genchannels as ulv
inner join tvs_channel as tvs
on tvs.chid=ulv.channel_id order by ulv.sort_id, ulv.channel_id;''')
result = obj.askdata(msg)
headers = ["频道名称"]
print(yate.start_response())
print(yate.include_header("频道维护"))
print(yate.start_form("ft_channels_edit.py"))
print(yate.start_table(tb_width="100%", tb_border="1px solid"))
print(yate.tb_header(headers))
print(yate.start_row())
print(yate.select('which_chid'))
#for array in result:
print(yate.select_option(result))
print(yate.end_select())
print(yate.end_row())
print(yate.start_row())
print(yate.end_form("确定"))
print(yate.end_row())
print(yate.end_table())
obj.Close()
def channels_offline(channel_offline=True):
message = ("""SELECT ulv_genchannels.channel_id,
tvs_channel.chname,
ulv_genaddress.gen_address,
ulv_status.des
FROM ulv_genchannels
NATURAL JOIN tvs_channel, ulv_genaddress, ulv_status
WHERE ulv_genchannels.channel_id = tvs_channel.chid
AND tvs_channel.chid = ulv_genaddress.channel_id
AND ulv_status.status_id=1 order by ulv_genchannels.sort_id, ulv_genchannels.channel_id""")
conn = my_sql.connect()
cursor = conn.cursor()
cursor.execute(message)
result = cursor.fetchall()
conn.close()
headers = ["频道名称", "频道编号", "直播路径", "发布状态"]
print(yate.start_response())
if channel_offline:
print(yate.include_header("频道下线"))
else:
print(yate.include_header("已发布频道"))
print(yate.start_form("ft_channels_offline.py"))
print(yate.start_table(tb_width="100%", tb_border="1px solid"))
print(yate.tb_header(headers))
for array in result:
print(yate.do_table(array, channel_offline))
print(yate.end_table())
if channel_offline==True:
print(yate.end_form("确定"))
def channels():
message = """select live_channel.chid,tvs_channel.chname,live_server.live_ip,live_url.live_path,live_status.sname """
message += """from tvs_channel,live_channel,live_server,live_url,live_status where tvs_channel.chid=live_channel.chid and """
message += """live_status.statusid=live_channel.statusid and live_url.live_urlid=live_channel.live_urlid and live_url.serverid = live_server.serverid """
message += """and live_url.status=0 order by live_channel.chid """
conn = my_sql.connect()
cursor = conn.cursor()
cursor.execute(message)
result = cursor.fetchall()
conn.close()
headers = ["频道名称", "直播地址", "直播路径", "发布状态"]
print(yate.start_response())
print(yate.include_header("JSB living system"))
print(yate.start_form("edit.py"))
print(yate.start_table(tb_width="80%", tb_border="1px solid"))
print(yate.tb_caption("已发布频道"))
print(yate.tb_header(headers))
for array in result:
print(yate.tb_data(array[1:]))
print(yate.end_table())
print(yate.end_form())
print(yate.include_footer({"Home": "/index.html"}))
def channels_operation(sp_id):
chidDic = dict() #store the checked chid from sp_id
obj = deal_mysql()
msg = ('''SELECT ulv.channel_id,tvs.chname
from ulv_genchannels as ulv
inner join tvs_channel as tvs
on tvs.chid=ulv.channel_id order by ulv.sort_id, ulv.channel_id;''')
msgn = ('''SELECT chid,sp_id from ulv_opchannels where sp_id=%d''' % int(sp_id))
result = obj.askdata(msg)
checked = obj.askdata(msgn)
for ele in checked:
chidDic[ele[0]] = ele[1]
nobj = deal_mysql('uspset.ini')
msgs = '''select name from u_sp where id=%s''' % int(sp_id)
response = nobj.askdata(msgs)
headers = ["频道名称", "频道编号"]
print(yate.start_response())
print(yate.include_header("频道运营"))
print(yate.start_form("op_channels_generate.py"))
print(yate.start_table(tb_width="50%", tb_border="1px solid"))
theader = ['运营商']
print(yate.tb_header(theader))
print(yate.start_row())
print('<input type="radio" checked="checked" name="which_sp" value="'+(sp_id)+'"/>"'+response[0][0]+'"')
print(yate.end_row())
print(yate.end_table())
print(yate.start_table(tb_width="50%", tb_border="1px solid"))
print(yate.tb_header(headers))
for array in result:
if chidDic.get(array[0],None)==None:
print(yate.do_operationtable(array))
else:
print(yate.checked_operationtable(array))
print(yate.end_table())
print(yate.start_table(tb_width="50%", tb_border="1px solid"))
print(yate.start_row())
print(yate.end_form("确定"))
print(yate.end_row())
print(yate.end_table())
obj.Close()
nobj.Close()
def channels_collect():
start_response()
obj = deal_mysql()
msg = ("""SELECT chid,chname from tvs_channel where status=0""")
result = obj.askdata(msg)
#info = result.pop(0)
headers = ["频道信息"]
print(yate.include_header("新频道收录"))
print(yate.start_form("ft_channels_collectDone.py"))
print(yate.start_table(tb_width="50%", tb_border="1px solid"))
print(yate.tb_header(headers))
print(yate.start_row())
print(yate.select('which_chid'))
print(yate.select_option(result))
print(yate.end_select())
print('<input type="text" name="which_addr" />')
print(yate.end_row())
print(yate.start_row())
print(yate.end_form("确定"))
print(yate.end_row())
print(yate.end_table())
obj.Close()
def print_operationboundary():
obj = deal_mysql('uspset.ini')
msg = '''select id,name from u_sp;'''
response = obj.askdata(msg)
headers = ["运营商"]
print(yate.start_response())
print(yate.include_header("运营发布"))
print("<p ><b>点击下面的运营商名称可选择要发布的频道</b></p>")
print(yate.start_table(tb_width="50%", tb_border="1px solid"))
print(yate.tb_header(headers))
print(yate.start_div('channel_div'))
print(yate.start_form("op_channels_select.py"))
for element in response:
print('<tr><td>')
print(yate.radio_button("which_sp",element))
print('</tr></td>')
print(yate.start_row())
print(yate.end_form("确定"))
print(yate.end_row())
print(yate.end_table())
print(yate.end_div())
obj.Close()