def info_add():
start_response()
#print(yate.start_response('text/plain;charset="UTF-8"'))
obj = deal_mysql()
msg = '''select id,comment from u_apptype '''
items = obj.askdata(msg)
msgs = '''SELECT ulv.channel_id,tvs.chname
from ulv_genchannels as ulv
inner join tvs_channel as tvs
on tvs.chid=ulv.channel_id; '''
channel_items = obj.askdata(msgs)
obj.Close()
print(yate.render_guidepage_header('首页内容增加','首页内容增加','op_guidepage_infodeal.py','别名'))
print(yate.start_div('types'))
print("<label for='types'>类型</label>")
print(yate.start_select_onblur('types','types','setdisabled(this);'))
print(yate.select_option(items))
print(yate.end_select())
print(yate.end_div())
print(yate.render_guidepage_form('类型包名','logo地址'))
print(yate.start_div('channel'))
#print(yate.para('类型选择了APK请在URL栏输入地址，类型选择了频道请在频道下拉框中选一个相应的频道'))
print("<label for='channel'>频道</label>")
print(yate.select_id_name('channel','channel'))
print(yate.select_option(channel_items))
print(yate.end_select())
print(yate.end_div())
value = '确定'
print(yate.rend_guidepage_end(value))
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 genaddress_publish():
# channel_list
allchannel = {}
allcatagory = {}
conn = my_sql.connect()
cur = conn.cursor()
cur.execute(
"""select live_url.chid,live_url.live_urlid,tvs_channel.chname from tvs_channel,
live_url where tvs_channel.status=0 and live_url.status=0 and live_url.chid=tvs_channel.chid order by tvs_channel.chid"""
)
dic = cur.fetchall()
apd = ""
for each in dic:
apd = " ".join([str(each[0]), str(each[1])])
allchannel[apd] = each[2].encode("utf-8")
apd = ""
# print allchannel
# select catagory id
cur.execute("""select sort_id,sort_name from live_sort """)
catagorydic = cur.fetchall()
conn.close()
for each in catagorydic:
allcatagory[each[0]] = each[1].encode("utf-8")
print(yate.start_response())
print(yate.render_publish(urls="edit.py"))
# print(yate.start_form("edit.py"))
print(yate.select("mix"))
print(yate.select_list_new(allchannel))
print(yate.end_select())
print(yate.select("sortid"))
print(yate.select_list_new(allcatagory))
print(yate.end_select())
"""
print(yate.select('logo'))
print(yate.select_list_n(alllogoname))
print(yate.end_select())
"""
# print(yate.end_form("add"))
print(yate.submit())
def channels_publish():
cmdmsg = ("""SELECT tvs_channel.chid, tvs_channel.chname
FROM tvs_channel
NATURAL JOIN ulv_genaddress
WHERE tvs_channel.`status` <> 1 AND tvs_channel.chid = ulv_genaddress.channel_id
order by tvs_channel.chid""")
conn = my_sql.connect()
cur = conn.cursor()
cur.execute(cmdmsg)
result = cur.fetchall()
msg = ("""select sort_id,sort_name from ulv_sort""")
cur.execute(msg)
sortinfo = cur.fetchall()
conn.close()
print(yate.start_response())
print(yate.include_header("上线频道"))
print("<p ><b>通过下面的复选框选择要上线的频道</b></p>")
print(yate.start_form("ft_channels_publish.py"))
print(yate.start_table(tb_width="50%", tb_border="1px solid"))
print(yate.start_row())
print("<center>")
print(yate.select("channel_id"))
print(yate.select_option(result))
print(yate.end_select())
print('</center>')
print(yate.end_row())
print(yate.start_row())
print("<center>")
print(yate.select("sort_id"))
print(yate.select_option(sortinfo))
print(yate.end_select())
print('</center>')
print(yate.end_row())
print(yate.start_row())
print(yate.end_form("确定"))
print(yate.end_row())
print(yate.end_table())
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()
#select catagory id
cur.execute("""select sort_id,sort_name from live_sort """)
catagorydic = cur.fetchall()
allcatagory = {}
for each in catagorydic:
allcatagory[each[0]] = each[1].encode('utf-8')
print(yate.start_response())
print(yate.render_publish())
print(yate.start_form("edit.py"))
print(yate.select('cid'))
print(yate.select_list_n(allchannel))
print(yate.end_select())
print(yate.select('catagory'))
print(yate.select_list_n(allcatagory))
print(yate.end_select())
"""
print(yate.select('serverip'))
print(yate.select_list_n(allserver))
print(yate.end_select())
print(yate.select('storagepath'))
print(yate.select_list_n(allstor_path))
print(yate.end_select())
print(yate.select('logo'))
print(yate.select_list_n(alllogoname))
def guidpage_arrange():
spid = get_formData('which_spid')
obj = deal_mysql()
msg = '''select id,alias from u_items'''
results = obj.askdata(msg)
nummsg = '''select item_id,position from u_homepage where spid=%s''' % spid[0]
homeitem= obj.askdata(nummsg)
obj.Close()
nobj = deal_mysql('uspset.ini')
nmsg = """select name from u_sp where id=%s""" % spid[0]
spname = nobj.askdata(nmsg)
nobj.Close()
#headers = ["频道名称", "频道编号"]
print(yate.start_response())
aa = "频道运营"
aa.encode('utf-8')
print(yate.include_header(aa))
print(yate.start_form("op_guidepage_storage.py"))
print(yate.start_table(tb_width="75%", tb_border="1px solid"))
print(yate.start_row())
print('<input type="radio" checked="checked" name="which_sp" value="'+(spid[0])+'"/>"'+spname[0][0]+'"')
print(yate.end_row())
print(yate.end_table())
print(yate.start_table(tb_width="75%", tb_border="5px solid"))
'''
spid has in u_homepage
'''
if homeitem !=():
position = dict()
for eachItem in homeitem:
position.update({eachItem[0]:eachItem[1]})
for i in range(2):
print(yate.start_tr())
for iters in range(3):
if i == 1:
iters = iters + 3
print(yate.start_td())
pos = 'pos'+str(iters)
print(yate.select(pos))
for item in results:
if item[0] in position.keys() and position[item[0]]==iters+1:
print(yate.select_optione_with_selected(item,True))
else:
print(yate.select_optione_with_selected(item))
print(yate.end_select())
print(yate.end_td())
print(yate.end_tr())
else:
for i in range(2):
print(yate.start_tr())
for iters in range(3):
if i == 1:
iters = iters + 3
print(yate.start_td())
pos = 'pos'+str(iters)
print(yate.select(pos))
print(yate.select_option(results))
print(yate.end_select())
print(yate.end_td())
print(yate.end_tr())
print(yate.end_table())
print(yate.start_table(tb_width="75%", tb_border="1px solid"))
print(yate.start_row())
print(yate.end_form("确定"))
print(yate.end_row())
print(yate.end_table())
print('</body></html>')
