function main() { global $db, $cache; $tv_id = be("all", "tv_id"); $day = be("all", "day"); if (!isNum($tv_id)) { $tv_id = 0; } else { $tv_id = intval($tv_id); } if (isN($day)) { $day = date('Y-m-d', time()); } $where = " 1=1 "; $where .= " AND tv_id =" . $tv_id; $pagenum = be("all", "page"); if (!isNum($pagenum)) { $pagenum = 1; } else { $pagenum = intval($pagenum); } if ($pagenum < 1) { $pagenum = 1; } $sql = "SELECT count(*) FROM {pre}tv_play" . " where " . $where; $nums = $db->getOne($sql); $pagecount = ceil($nums / app_pagenum); $sql = "SELECT * FROM {pre}tv_play where " . $where . " ORDER BY id ASC limit " . app_pagenum * ($pagenum - 1) . "," . app_pagenum; $rs = $db->query($sql); ?> <script language="javascript"> function filter(){ var tv_id=$("#tv_id").val(); var url = "admin_program_play.php?tv_id="+tv_id; window.location.href=url; } $(document).ready(function(){ $("#form2").validate({ rules:{ t_name:{ required:true, // stringCheck:true, maxlength:64 }, // t_enname:{ // required:true, //// stringCheck:true, // maxlength:128 // }, // t_template:{ // required:true, // maxlength:128 // }, t_pic:{ maxlength:254 }, t_sort:{ number:true }, t_des:{ required:true, maxlength:254 } } }); $('#form1').form({ onSubmit:function(){ if(!$("#form1").valid()) {return false;} }, success:function(data){ $.messager.alert('系统提示', data, 'info',function(){ location.href=location.href; }); } }); $('#form2').form({ onSubmit:function(){ if(!$("#form2").valid()) {return false;} }, success:function(data){ $.messager.alert('系统提示', data, 'info'); } }); $("#btnDel").click(function(){ if(confirm('确定要删除吗')){ $("#form1").attr("action","admin_ajax.php?action=del&flag=batch&tab={pre}vod_topic"); $("#form1").submit(); } else{return false} }); $("#btnAddLunBo").click(function(){ if(confirm('确定要添加到轮播图吗')){ $("#form1").attr("action","admin_ajax.php?action=lunboForTopic&flag=batch&tab={pre}vod_popular"); $("#form1").submit(); } else{return false} }); $("#btnEdit").click(function(){ $("#form1").attr("action","?action=editall"); $("#form1").submit(); }); $("#btnAdd").click(function(){ $('#form2').form('clear'); $("#flag").val("add"); $('#win1').window('open'); }); $("#btnCancel").click(function(){ location.href= location.href; }); }); function edit(id) { $('#form2').form('clear'); $("#flag").val("edit"); $('#win1').window('open'); $('#form2').form('load','admin_ajax.php?action=getinfo&tab={pre}tv&col=id&val='+id); } </script> <table class="admin_program_play tb"> <tr> <td> <table border="0" align="center" cellpadding="3" cellspacing="1"> <tr> <td colspan="2"> 过滤条件:频道<select id="tv_id" name="tv_id" > <?php echo makeSelectWhere("{pre}tv", "id", "tv_name", "tv_type", "", " | ", $tv_id, " where status=1"); ?> </select> <input class="input" type="button" value="搜索" id="btnsearch" onClick="filter();"> | <a href="admin_program.php">返回电视直播</a> </td> </tr> </table> </td> </tr> </table> <table class="tb"> <form action="" method="post" id="form1" name="form1"> <tr> <td width="5%"> </td> <td width="5%">编号</td> <td>播放来源</td> <td>显示到app</td> <td width="45%">直播地址</td> <td>清晰度</td> <td width="10%">操作</td> </tr> <?php if ($nums == 0) { ?> <tr><td align="center" colspan="7">没有任何记录!</td></tr> <?php } else { while ($row = $db->fetch_array($rs)) { $t_id = $row["id"]; ?> <tr> <td> <input name="t_id[]" type="checkbox" id="t_id" value="<?php echo $t_id; ?> " /></td> <td><?php echo $t_id; ?> </td> <td> <select id="tv_playfrom<?php echo $t_id; ?> " name="tv_playfrom<?php echo $t_id; ?> "> <option value="">请选择播放来源</option> <?php echo makeSelectTV_live("tv_playfrom", $row["tv_playfrom"]); ?> </select> </td> <td> <select id="status<?php echo $t_id; ?> " name="status<?php echo $t_id; ?> "> <option value="0" <?php if ($row["status"] == 0) { echo "selected"; } ?> >不显示</option> <option value="1" <?php if ($row["status"] == 1) { echo "selected"; } ?> >显示</option> </select> </td> <td> <input type="text" name="tv_playurl<?php echo $t_id; ?> " value="<?php echo $row["tv_playurl"]; ?> " size="100"/></td> <td> <select id="tv_definition<?php echo $t_id; ?> " name="tv_definition<?php echo $t_id; ?> "> <option value=""> </option> <option value="mp4" <?php if ($row["tv_definition"] === 'mp4') { echo "selected"; } ?> >高清</option> <option value="flv" <?php if ($row["tv_definition"] === 'flv') { echo "selected"; } ?> >流畅</option> </select> </td> <td> <!-- <a href="javascript:void(0)" onclick="edit('<?php echo $t_id; ?> ');return false;">修改</a> --> <a href="admin_ajax.php?action=del&tab={pre}tv_play&t_id=<?php echo $t_id; ?> " onClick="return confirm('确定要删除吗?');">删除</a> </td> </tr> <?php } } ?> <tr class="formlast"> <td colspan="7"><input type="checkbox" name="chkall" id="chkall" class="checkbox" onClick="checkAll(this.checked,'t_id[]')" /> 全选 <!-- <input type="button" value="批量删除" id="btnDel" class="input" />--> <input type="button" value="批量修改" id="btnEdit" class="input" /> <input type="button" value="添加" id="btnAdd" class="input" /> </td></tr> <tr align="center" > <td colspan="8"> <?php echo pagelist_manage($pagecount, $pagenum, $nums, app_pagenum, "admin_program.php?page={p}&tv_type=" . $tv_type . "&keyword=" . urlencode($keyword)); ?> </td> </tr> </table> </form> <div id="win1" class="easyui-window" title="窗口" style="padding:5px;width:450px;" closed="true" closable="false" minimizable="false" maximizable="false"> <form action="admin_ajax.php?action=save&tab={pre}tv_play&tv_id=<?php echo $tv_id; ?> " method="post" name="form2" id="form2"> <table class="tb"> <input id="id" name="id" type="hidden" value=""> <input id="flag" name="flag" type="hidden" value=""> <tr> <td>直播地址来源:</td> <td><select id="tv_playfrom" name="tv_playfrom"> <?php echo makeSelectTV_live("tv_playfrom", ''); ?> </select> </td> </tr> <tr> <td>显示到App:</td> <td><select id="status" name="status"> <option value="0" selected>不显示</option> <option value="1" >显示</option> </select> </td> </tr> <tr> <td>直播视频地址:</td> <td> <TEXTAREA id="tv_playurl" NAME="tv_playurl" ROWS="2" style="width:300px;table-layout:fixed; word-wrap:break-word;"></TEXTAREA> </td> </tr> <tr> <td>直播来源清晰度:</td> <td> <select id="tv_definition" name="tv_definition"> <option value=""> </option> <option value="mp4" >高清</option> <option value="flv">流畅</option> </select> </td> </tr> <tr align="center" > <td colspan="2"><input class="input" type="submit" value="保存" id="btnSave"> <input class="input" type="button" value="返回" id="btnCancel"></td> </tr> </table> </form> </div> </body> </html> <?php unset($rs); }
function main() { global $db, $cache; $tv_id = be("all", "tv_id"); $day = be("all", "day"); if (!isNum($tv_id)) { $tv_id = 0; } else { $tv_id = intval($tv_id); } if (isN($day)) { $day = date('Y-m-d', time()); } $where = " 1=1 "; $where .= " AND tv_id =" . $tv_id; $where .= " AND day ='" . $day . "'"; $pagenum = be("all", "page"); if (!isNum($pagenum)) { $pagenum = 1; } else { $pagenum = intval($pagenum); } if ($pagenum < 1) { $pagenum = 1; } $sql = "SELECT count(*) FROM {pre}tv_program_item as a " . " where " . $where; $nums = $db->getOne($sql); $pagecount = ceil($nums / app_pagenum); $sql1 = "SELECT * FROM {pre}tv_program_item where " . $where . " and play_time<='12:00' order by play_time asc "; $sql2 = "SELECT * FROM {pre}tv_program_item where " . $where . " and play_time>'12:00' order by play_time asc "; // var_dump($sql); $rs1 = $db->query($sql1); $rs2 = $db->query($sql2); ?> <script language="javascript"> function filter(){ var tv_id=$("#tv_id").val(); var day =$("#date").val(); if(day ==''){ var url = "admin_program_items_day.php?tv_id="+tv_id+"&day="+day; }else { var url = "admin_program_items.php?tv_id="+tv_id+"&day="+day; } window.location.href=url; } function collecProgram(){ var tv_id=$("#tv_id").val(); var day =$("#date").val(); var url = "admin_program_items.php?action=collecProgram&tv_id="+tv_id+"&day="+day; $.get(url,"", function(obj) { alert(obj); }); } $(document).ready(function(){ $('#form1').form({ onSubmit:function(){ if(!$("#form1").valid()) {return false;} }, success:function(data){ $.messager.alert('系统提示', data, 'info',function(){ location.href=location.href; }); } }); $("#btnDel").click(function(){ if(confirm('确定要删除吗')){ $("#form1").attr("action","admin_ajax.php?action=del&flag=batch&tab={pre}vod_topic_items"); $("#form1").submit(); } else{return false} }); $("#btnEdit").click(function(){ $("#form1").attr("action","?action=editall"); $("#form1").submit(); }); $("#btnAdd").click(function(){ $('#form2').form('clear'); $("#flag").val("add"); $('#win1').window('open'); }); $("#btnAdd_down").click(function(){ $('#form2').form('clear'); $("#flag").val("add"); $('#win1').window('open'); }); $('#form2').form({ onSubmit:function(){ if(!$("#form2").valid()) {return false;} }, success:function(data){ $.messager.alert('系统提示', data, 'info'); } }); // $("#btnAdd").click(function(){ // window.location.href="admin_vod.php?topic_id=<?php echo $topic_id; ?> "; // }); $("#btnCancel").click(function(){ location.href= location.href; }); }); function edit(id) { $('#form2').form('clear'); $("#flag").val("edit"); $('#win1').window('open'); $('#form2').form('load','admin_ajax.php?action=getinfo&tab={pre}vod_topic&col=t_id&val='+id); } </script> <script type="text/javascript" src="/js/calendar.js"></script> <table class="admin_program_items tb"> <tr> <td> <table border="0" cellpadding="3" cellspacing="1"> <tr> <td colspan="2"> 过滤条件:频道 <select id="tv_id" name="tv_id" > <?php echo makeSelectWhere("{pre}tv", "id", "tv_name", "tv_type", "", " | ", $tv_id, " where status=1"); ?> </select> <input id="date" name="date" type="text" onclick="new Calendar().show(this);" value="<?php echo $day; ?> " readonly="readonly"/> <input class="input" type="button" value="搜索" id="btnsearch" onClick="filter();"> | <input class="input" type="button" value="采集节目单" id="btnsearch1" onClick="collecProgram();"> | <a class="input" href="admin_program.php">返回电视直播</a> </td> </tr> </table> </td> </tr> </table> <table class="tb"> <form action="" method="post" id="form1" name="form1"> <tr> <td align="left">AM 00:00-12:00节目单</td> <td align=""left"" width="50%">AM 12:00-24:00节目单 <input type="button" value="添加" id="btnAdd" class="input" /> </td> </tr> <?php if ($nums == 0) { ?> <tr class="formlast"><td align="center" colspan="2">没有任何记录!</td></tr> <?php } else { ?> <tr> <td align="left" valign="top"> <?php while ($row1 = $db->fetch_array($rs1)) { $t_id1 = $row1["id"]; ?> <input name="t_id[]" type="checkbox" id="t_id" value="<?php echo $t_id1; ?> " /> <input type="text" name="play_time<?php echo $t_id1; ?> " value="<?php echo $row1["play_time"]; ?> " size="5"/> <input type="text" name="video_name<?php echo $t_id1; ?> " value="<?php echo $row1["video_name"]; ?> " size="40"/> <select id="program_type<?php echo $t_id1; ?> " name="program_type<?php echo $t_id1; ?> " > <option value=''>节目类别</option> <?php echo makeSelectTV_live("prod_type", $row1["program_type"]); ?> </select><br/> <?php } ?> </td> <td align="left"> <?php while ($row2 = $db->fetch_array($rs2)) { $t_id2 = $row2["id"]; ?> <input name="t_id[]" type="checkbox" id="t_id" value="<?php echo $t_id2; ?> " /> <input type="text" name="play_time<?php echo $t_id2; ?> " value="<?php echo $row2["play_time"]; ?> " size="5"/> <input type="text" name="video_name<?php echo $t_id2; ?> " value="<?php echo $row2["video_name"]; ?> " size="40"/> <select id="program_type<?php echo $t_id2; ?> " name="program_type<?php echo $t_id2; ?> " > <option value=''>节目类别</option> <?php echo makeSelectTV_live("prod_type", $row2["program_type"]); ?> </select><br/> <?php } ?> </td> </tr> <?php } ?> <tr class="formlast"> <td colspan="7"><input type="checkbox" name="chkall" id="chkall" class="checkbox" onClick="checkAll(this.checked,'t_id[]')" /> 全选 <!-- <input type="button" value="批量删除" id="btnDel" class="input" />--> <input type="button" value="批量修改" id="btnEdit" class="input" /> <input type="button" value="添加" id="btnAdd_down" class="input" /> </td></tr> </table> </form> <div id="win1" class="easyui-window" title="窗口" style="padding:5px;width:450px;" closed="true" closable="false" minimizable="false" maximizable="false"> <form action="admin_ajax.php?action=save&tab={pre}tv_program_item&tv_id=<?php echo $tv_id; ?> &day=<?php echo $day; ?> " method="post" name="form2" id="form2"> <table class="tb"> <input id="id" name="id" type="hidden" value=""> <input id="flag" name="flag" type="hidden" value=""> <tr> <td width="30%">播放时间:</td> <td><input id="play_time" size=5 value="" name="play_time">(格式xx:xx, 比如23:20) </td> </tr> <tr> <td width="30%">播放节目:</td> <td><input id="video_name" size=40 value="" name="video_name"> </td> </tr> <tr> <td width="30%">节目类别:</td> <td> <select id="program_type" name="program_type" > <option value=''></option> <?php echo makeSelectTV_live("prod_type", ''); ?> </select> </td> </tr> <tr align="center" > <td colspan="2"><input class="input" type="submit" value="保存" id="btnSave"> <input class="input" type="button" value="返回" id="btnCancel"></td> </tr> </table> </form> </div> </body> </html> <?php unset($rs1); unset($rs2); }
function main() { global $db, $cache; $tv_id = be("all", "tv_id"); $day = be("all", "day"); if (!isNum($tv_id)) { $tv_id = 0; } else { $tv_id = intval($tv_id); } $day = date('Y-m-d', time()); $dateTime = strtotime($date); $offset = date('w', time()); $day = ''; ?> <script language="javascript"> function filter(){ var tv_id=$("#tv_id").val(); var day =$("#date").val(); if(day ==''){ var url = "admin_program_items_day.php?tv_id="+tv_id+"&day="+day; }else { var url = "admin_program_items.php?tv_id="+tv_id+"&day="+day; } window.location.href=url; } function collecProgram(){ var tv_id=$("#tv_id").val(); var day =$("#date").val(); var url = "admin_program_items.php?action=collecProgram&tv_id="+tv_id+"&day="+day; $.get(url,"", function(obj) { alert(obj); }); } $(document).ready(function(){ $('#form1').form({ onSubmit:function(){ if(!$("#form1").valid()) {return false;} }, success:function(data){ $.messager.alert('系统提示', data, 'info',function(){ location.href=location.href; }); } }); $("#btnDel").click(function(){ if(confirm('确定要删除吗')){ $("#form1").attr("action","admin_ajax.php?action=del&flag=batch&tab={pre}vod_topic_items"); $("#form1").submit(); } else{return false} }); $("#btnEdit").click(function(){ $("#form1").attr("action","?action=editall"); $("#form1").submit(); }); $("#btnAdd").click(function(){ $('#form2').form('clear'); $("#flag").val("add"); $('#win1').window('open'); }); $("#btnAdd_down").click(function(){ $('#form2').form('clear'); $("#flag").val("add"); $('#win1').window('open'); }); $('#form2').form({ onSubmit:function(){ if(!$("#form2").valid()) {return false;} }, success:function(data){ $.messager.alert('系统提示', data, 'info'); } }); // $("#btnAdd").click(function(){ // window.location.href="admin_vod.php?topic_id=<?php echo $topic_id; ?> "; // }); $("#btnCancel").click(function(){ location.href= location.href; }); }); function edit(id) { $('#form2').form('clear'); $("#flag").val("edit"); $('#win1').window('open'); $('#form2').form('load','admin_ajax.php?action=getinfo&tab={pre}vod_topic&col=t_id&val='+id); } </script> <script type="text/javascript" src="/js/calendar.js"></script> <table class="tb"> <tr> <td> <table width="96%" border="0" align="center" cellpadding="3" cellspacing="1"> <tr> <td colspan="2"> 过滤条件:频道 <select id="tv_id" name="tv_id" > <?php echo makeSelectWhere("{pre}tv", "id", "tv_name", "tv_type", "", " | ", $tv_id, " where status=1"); ?> </select> <input id="date" name="date" type="text" onclick="new Calendar().show(this);" value="<?php echo $day; ?> " readonly="readonly"/> <input class="input" type="button" value="搜索" id="btnsearch" onClick="filter();"> | <input class="input" type="button" value="采集节目单" id="btnsearch1" onClick="collecProgram();"> | <a href="admin_program.php">返回电视直播</a> </td> </tr> </table> </td> </tr> </table> <table class="tb"> <form action="" method="post" id="form1" name="form1"> <tr> <td align="left" ><font color="<?php if (1 - $offset == 0) { echo 'blue'; } else { echo 'black'; } ?> ">星期一 <?php echo date('Y-m-d', strtotime(1 - $offset . ' day')); ?> </font></td> <td align="left"><font color="<?php if (2 - $offset == 0) { echo 'blue'; } else { echo 'black'; } ?> ">星期二 <?php echo date('Y-m-d', strtotime(2 - $offset . ' day')); ?> </font></td> <td align="left"><font color="<?php if (3 - $offset == 0) { echo 'blue'; } else { echo 'black'; } ?> ">星期三 <?php echo date('Y-m-d', strtotime(3 - $offset . ' day')); ?> </font></td> <td align="left"><font color="<?php if (4 - $offset == 0) { echo 'blue'; } else { echo 'black'; } ?> ">星期四 <?php echo date('Y-m-d', strtotime(4 - $offset . ' day')); ?> </font></td> <td align="left"><font color="<?php if (5 - $offset == 0) { echo 'blue'; } else { echo 'black'; } ?> ">星期五 <?php echo date('Y-m-d', strtotime(5 - $offset . ' day')); ?> </font></td> <td align="left"><font color="<?php if (6 - $offset == 0) { echo 'blue'; } else { echo 'black'; } ?> ">星期六 <?php echo date('Y-m-d', strtotime(6 - $offset . ' day')); ?> </font></td> <td align="left"><font color="<?php if (7 - $offset == 0) { echo 'blue'; } else { echo 'black'; } ?> ">星期日 <?php echo date('Y-m-d', strtotime(7 - $offset . ' day')); ?> </font></td> </tr> <?php if (false) { ?> <tr><td align="center" colspan="2">没有任何记录!</td></tr> <?php } else { ?> <tr> <?php for ($i = 1; $i < 8; $i++) { ?> <td align="left" valign="top" nowrap> <?php $day = date('Y-m-d', strtotime($i - $offset . ' day')); $sql = "SELECT * FROM {pre}tv_program_item where tv_id =" . $tv_id . " AND day ='" . $day . "' order by play_time asc "; $rs = $db->query($sql); while ($row1 = $db->fetch_array($rs)) { $t_id1 = $row1["id"]; ?> <input name="t_id[]" type="checkbox" id="t_id" value="<?php echo $t_id1; ?> " /> <input type="text" name="play_time<?php echo $t_id1; ?> " value="<?php echo $row1["play_time"]; ?> " size="5"/> <input type="text" name="video_name<?php echo $t_id1; ?> " value="<?php echo $row1["video_name"]; ?> " size="20"/> <select id="program_type<?php echo $t_id1; ?> " name="program_type<?php echo $t_id1; ?> " > <option value=''>节目类别</option> <?php echo makeSelectTV_live("prod_type", $row1["program_type"]); ?> </select><br/> <?php } unset($rs); ?> </td> <?php } ?> </tr> <?php } ?> <tr> <td colspan="7">全选<input type="checkbox" name="chkall" id="chkall" class="checkbox" onClick="checkAll(this.checked,'t_id[]')" /> <!-- <input type="button" value="批量删除" id="btnDel" class="input" />--> <input type="button" value="批量修改" id="btnEdit" class="input" /> <!-- <input type="button" value="添加" id="btnAdd_down" class="input" />--> </td></tr> </table> </form> <div id="win1" class="easyui-window" title="窗口" style="padding:5px;width:450px;" closed="true" closable="false" minimizable="false" maximizable="false"> <form action="admin_ajax.php?action=save&tab={pre}tv_program_item&tv_id=<?php echo $tv_id; ?> &day=<?php echo $day; ?> " method="post" name="form2" id="form2"> <table class="tb"> <input id="id" name="id" type="hidden" value=""> <input id="flag" name="flag" type="hidden" value=""> <tr> <td width="30%">播放时间:</td> <td><input id="play_time" size=5 value="" name="play_time">(格式xx:xx, 比如23:20) </td> </tr> <tr> <td width="30%">播放节目:</td> <td><input id="video_name" size=40 value="" name="video_name"> </td> </tr> <tr> <td width="30%">节目类别:</td> <td> <select id="program_type" name="program_type" > <option value=''></option> <?php echo makeSelectTV_live("prod_type", ''); ?> </select> </td> </tr> <tr align="center" > <td colspan="2"><input class="input" type="submit" value="保存" id="btnSave"> <input class="input" type="button" value="返回" id="btnCancel"></td> </tr> </table> </form> </div> </body> </html> <?php }
function main() { global $db, $cache; $program_type = be("all", "program_type"); $where = ' 1=1 '; if (!isN($program_type)) { $where .= " and program_type ='" . $program_type . "'"; } else { $where .= " and program_type =''"; } $sql = "SELECT * FROM mac_tv_program_type_item where " . $where; $rs = $db->query($sql); // var_dump($sql); $content = ''; while ($row1 = $db->fetch_array($rs)) { $content = $content . chr(10) . $row1["program_name"]; } unset($rs); ?> <script language="javascript"> function filter(){ var program_type=$("#program_type").val(); var url = "admin_program_type_items.php?program_type="+program_type; window.location.href=url; } $(document).ready(function(){ $("#form2").validate({ rules:{ t_name:{ required:true, // stringCheck:true, maxlength:64 }, // t_enname:{ // required:true, //// stringCheck:true, // maxlength:128 // }, // t_template:{ // required:true, // maxlength:128 // }, t_pic:{ maxlength:254 }, t_sort:{ number:true }, t_des:{ required:true, maxlength:254 } } }); $('#form1').form({ onSubmit:function(){ if(!$("#form1").valid()) {return false;} }, success:function(data){ $.messager.alert('系统提示', data, 'info',function(){ location.href=location.href; }); } }); $('#form2').form({ onSubmit:function(){ if(!$("#form2").valid()) {return false;} }, success:function(data){ $.messager.alert('系统提示', data, 'info'); } }); $("#btnDel").click(function(){ if(confirm('确定要删除吗')){ $("#form1").attr("action","admin_ajax.php?action=del&flag=batch&tab={pre}vod_topic"); $("#form1").submit(); } else{return false} }); $("#btnAddLunBo").click(function(){ if(confirm('确定要添加到轮播图吗')){ $("#form1").attr("action","admin_ajax.php?action=lunboForTopic&flag=batch&tab={pre}vod_popular"); $("#form1").submit(); } else{return false} }); $("#btnEdit").click(function(){ $("#form1").attr("action","?action=editall"); $("#form1").submit(); }); $("#btnAdd").click(function(){ $('#form2').form('clear'); $("#flag").val("add"); $('#win1').window('open'); }); $("#btnCancel").click(function(){ location.href= location.href; }); }); function edit(id) { $('#form2').form('clear'); $("#flag").val("edit"); $('#win1').window('open'); $('#form2').form('load','admin_ajax.php?action=getinfo&tab={pre}tv&col=id&val='+id); } </script> <table class="tb"> <tr> <td> <table width="96%" border="0" align="center" cellpadding="3" cellspacing="1"> <tr> <td colspan="2"> 过滤条件:节目类别 <select id="program_type" name="program_type" > <option value=''> </option> <?php echo makeSelectTV_live("prod_type", $program_type); ?> </select> <input class="input" type="button" value="搜索" id="btnsearch" onClick="filter();"> | <a href="admin_program.php">返回电视直播</a> </td> </tr> </table> </td> </tr> </table> <form name="form1" id="form1" method="post" action="?action=save"> <table class="tb"> <input id="backurl" name="backurl" type="hidden" value="<?php echo $backurl; ?> "> <input id="backurl" name="program_type" type="hidden" value="<?php echo $program_type; ?> "> <tr> <td><font color='red'><?php echo $program_type; ?> </font> 类别对应的关键词,每一行对应一个关键词</td> </tr> <tr> <td> <textarea id="keyword" name="keyword" style="width:500px;height:400px;"><?php echo $content; ?> </textarea> </td> </tr> <tr align="center"> <td><input class="input" type="submit" value="保存" id="btnSave"> <input class="input" type="button" value="返回" id="btnCancel"> </td> </tr> </table> </form> <div id="win1" class="easyui-window" title="窗口" style="padding:5px;width:450px;" closed="true" closable="false" minimizable="false" maximizable="false"> <form action="admin_ajax.php?action=save&tab={pre}tv_program_type_item&program_type=<?php echo $program_type; ?> " method="post" name="form2" id="form2"> <table class="tb"> <input id="id" name="id" type="hidden" value=""> <input id="flag" name="flag" type="hidden" value=""> <tr> <td>直播地址来源:</td> <td><select id="tv_playfrom" name="tv_playfrom"> <?php echo makeSelectTV_live("tv_playfrom", ''); ?> </select> </td> </tr> <tr> <td>显示到App:</td> <td><select id="status" name="status"> <option value="0" selected>不显示</option> <option value="1" >显示</option> </select> </td> </tr> <tr> <td>直播视频地址:</td> <td> <TEXTAREA id="tv_playurl" NAME="tv_playurl" ROWS="2" style="width:300px;table-layout:fixed; word-wrap:break-word;"></TEXTAREA> </td> </tr> <tr align="center" > <td colspan="2"><input class="input" type="submit" value="保存" id="btnSave"> <input class="input" type="button" value="返回" id="btnCancel"></td> </tr> </table> </form> </div> </body> </html> <?php }
function main() { global $db, $cache; $keyword = be("all", "keyword"); $tv_type = be("all", "tv_type"); $country = be("all", "country"); $area = be("all", "area"); if (!isNum($tv_type)) { $tv_type = -1; } else { $tv_type = intval($tv_type); } $where = "1=1 "; if (!isN($keyword)) { $where .= " AND tv_name LIKE '%" . $keyword . "%' "; } if (!isN($area)) { $where .= " AND area = '" . $area . "' "; } if (!isN($country)) { $where .= " AND country = '" . $country . "' "; } if ($tv_type !== '-1' && $tv_type != -1) { $where .= " AND tv_type =" . $tv_type; } $pagenum = be("all", "page"); if (!isNum($pagenum)) { $pagenum = 1; } else { $pagenum = intval($pagenum); } if ($pagenum < 1) { $pagenum = 1; } $sql = "SELECT count(*) FROM {pre}tv" . " where " . $where; $nums = $db->getOne($sql); $pagecount = ceil($nums / app_pagenum); $sql = "SELECT * FROM {pre}tv where " . $where . " ORDER BY tv_type desc,id ASC limit " . app_pagenum * ($pagenum - 1) . "," . app_pagenum; $rs = $db->query($sql); ?> <script language="javascript"> function filter(){ var keyword=$("#keyword").val(); var tv_type=$("#tv_type").val(); var country=$("#country").val(); var area=$("#area").val(); var url = "admin_program.php?tv_type="+tv_type+"&keyword="+encodeURI(keyword)+"&area="+encodeURI(area)+"&country="+encodeURI(country); window.location.href=url; } function exportExcel(){ var url = "admin_program.php?action=exportExcel"; window.location.href=url; } $(document).ready(function(){ $("#form2").validate({ rules:{ t_name:{ required:true, // stringCheck:true, maxlength:64 }, // t_enname:{ // required:true, //// stringCheck:true, // maxlength:128 // }, // t_template:{ // required:true, // maxlength:128 // }, t_pic:{ maxlength:254 }, t_sort:{ number:true }, t_des:{ required:true, maxlength:254 } } }); $('#form1').form({ onSubmit:function(){ if(!$("#form1").valid()) {return false;} }, success:function(data){ $.messager.alert('系统提示', data, 'info',function(){ location.href=location.href; }); } }); $('#form2').form({ onSubmit:function(){ if(!$("#form2").valid()) {return false;} }, success:function(data){ $.messager.alert('系统提示', data, 'info'); } }); $("#btnDel").click(function(){ if(confirm('确定要删除吗')){ $("#form1").attr("action","admin_ajax.php?action=del&flag=batch&tab={pre}vod_topic"); $("#form1").submit(); } else{return false} }); $("#btnAddLunBo").click(function(){ if(confirm('确定要添加到轮播图吗')){ $("#form1").attr("action","admin_ajax.php?action=lunboForTopic&flag=batch&tab={pre}vod_popular"); $("#form1").submit(); } else{return false} }); $("#btnEdit").click(function(){ $("#form1").attr("action","?action=editall"); $("#form1").submit(); }); $("#btnAdd").click(function(){ $('#form2').form('clear'); $("#flag").val("add"); $('#win1').window('open'); }); $("#btnCancel").click(function(){ location.href= location.href; }); }); function edit(id) { $('#form2').form('clear'); $("#flag").val("edit"); $('#win1').window('open'); $('#form2').form('load','admin_ajax.php?action=getinfo&tab={pre}tv&col=id&val='+id); } </script> <table class="admin_program tb"> <tr> <td> <table border="0" cellpadding="3" cellspacing="1"> <tr> <td colspan="2"> 过滤条件: <select id="tv_type" name="tv_type"> <option value="-1">类型</option> <option value="1" <?php if ($tv_type == 1) { echo "selected"; } ?> >央视</option> <option value="2" <?php if ($tv_type == 2) { echo "selected"; } ?> >卫视</option> <option value="3" <?php if ($tv_type == 3) { echo "selected"; } ?> >城市</option> <option value="4" <?php if ($tv_type == 4) { echo "selected"; } ?> >CETV</option> <option value="5" <?php if ($tv_type == 5) { echo "selected"; } ?> >数字</option> </select> <select id="country" name="country"> <option value="">请选择国家</option> <?php echo makeSelectTV_live("country", $country); ?> </select> <select id="area" name="area"> <option value="">请选择地区</option> <?php echo makeSelectTV_live("area", $area); ?> </select> </td> </tr> <tr> <td colspan="6"> 关键字:<input id="keyword" size="40" name="keyword" value="<?php echo $keyword; ?> "> <input class="input" type="button" value="搜索" id="btnsearch" onClick="filter();"> <a href="admin_program.php?action=exportExcel"><font color="red"><b>导出频道</b></font></a> </td> <td width="150px"> </td> </tr> </table> </td> </tr> </table> <table class="tb"> <form action="" method="post" id="form1" name="form1"> <tr> <td width="5%"> </td> <td width="5%">编号</td> <td>名称</td> <td>国家</td> <td>地区</td> <!-- <td>编码</td>--> <td>类型</td> <td>显示到app</td> <!-- <td width="45%">直播地址</td>--> <td width="40%">操作</td> </tr> <?php if ($nums == 0) { ?> <tr><td align="center" colspan="7">没有任何记录!</td></tr> <?php } else { while ($row = $db->fetch_array($rs)) { $t_id = $row["id"]; ?> <tr> <td> <input name="t_id[]" type="checkbox" id="t_id" value="<?php echo $t_id; ?> " /></td> <td><?php echo $t_id; ?> </td> <td> <input type="text" name="tv_name<?php echo $t_id; ?> " value="<?php echo $row["tv_name"]; ?> " size="40"/></td> <td> <select id="country<?php echo $t_id; ?> " name="country<?php echo $t_id; ?> "> <option value="">请选择国家</option> <?php echo makeSelectTV_live("country", $row["country"]); ?> </select> </td> <td><select id="area<?php echo $t_id; ?> " name="area<?php echo $t_id; ?> "> <option value="">请选择地区</option> <?php echo makeSelectTV_live("area", $row["area"]); ?> </select></td> <!-- <td>--> <!-- <input type="text" name="tv_code<?php echo $t_id; ?> " value="<?php echo $row["tv_code"]; ?> " size="20"/></td>--> <td> <select id="tv_type" name="tv_type<?php echo $t_id; ?> "> <option value="-1">类型</option> <option value="1" <?php if ($row["tv_type"] == 1) { echo "selected"; } ?> >央视</option> <option value="2" <?php if ($row["tv_type"] == 2) { echo "selected"; } ?> >卫视</option> <option value="3" <?php if ($row["tv_type"] == 3) { echo "selected"; } ?> >城市</option> <option value="4" <?php if ($row["tv_type"] == 4) { echo "selected"; } ?> >CETV</option> <option value="5" <?php if ($row["tv_type"] == 5) { echo "selected"; } ?> >数字</option> </select> </td> <td> <select id="status<?php echo $t_id; ?> " name="status<?php echo $t_id; ?> "> <option value="0" <?php if ($row["status"] == 0) { echo "selected"; } ?> >不显示</option> <option value="1" <?php if ($row["status"] == 1) { echo "selected"; } ?> >显示</option> </select> </td> <!-- <td>--> <!-- <input type="text" name="tv_playurl<?php echo $t_id; ?> " value="<?php echo $row["tv_playurl"]; ?> " size="70"/></td>--> <!-- --> <td> <a href="admin_program_items.php?tv_id=<?php echo $t_id; ?> ">显示节目单</a> | <a href="admin_program_play.php?tv_id=<?php echo $t_id; ?> ">显示直播源</a> | <a href="javascript:void(0)" onclick="edit('<?php echo $t_id; ?> ');return false;">修改</a> <!-- | <a href="admin_ajax.php?action=del&tab={pre}vod_topic&t_id=<?php echo $t_id; ?> " onClick="return confirm('确定要删除吗?');">删除</a> |--> </td> </tr> <?php } } ?> <tr class="formlast"> <td colspan="7"><input type="checkbox" name="chkall" id="chkall" class="checkbox" onClick="checkAll(this.checked,'t_id[]')" /> 全选 <!-- <input type="button" value="批量删除" id="btnDel" class="input" />--> <input type="button" value="批量修改" id="btnEdit" class="input" /> <input type="button" value="添加" id="btnAdd" class="input" /> </td></tr> <tr align="center" class="formlast"> <td colspan="8"> <?php echo pagelist_manage($pagecount, $pagenum, $nums, app_pagenum, "admin_program.php?page={p}&tv_type=" . $tv_type . "&keyword=" . urlencode($keyword)); ?> </td> </tr> </table> </form> <div id="win1" class="easyui-window" title="窗口" style="padding:5px;width:450px;" closed="true" closable="false" minimizable="false" maximizable="false"> <form action="admin_ajax.php?action=save&tab={pre}tv" method="post" name="form2" id="form2"> <table class="tb"> <input id="id" name="id" type="hidden" value=""> <input id="flag" name="flag" type="hidden" value=""> <tr> <td width="30%">电视名称:</td> <td><input id="tv_name" size=40 value="" name="tv_name"> </td> </tr> <!-- <tr>--> <!-- <td>电视编码:</td>--> <!-- <td> <input id="tv_code" size=40 value="" name="tv_code">--> <!-- </td>--> <!-- </tr>--> <tr> <td>电视节目类别:</td> <td><select id="tv_type" name="tv_type"> <option value="-1">类型</option> <option value="1" >央视</option> <option value="2">卫视</option> <option value="3" >城市</option> <option value="4">CETV</option> <option value="5">数字</option> </select> </td> </tr> <tr> <td>国家:</td> <td><select id="country" name="country"> <?php echo makeSelectTV_live("country", ''); ?> </select> </td> </tr> <tr> <td>地区:</td> <td><select id="area" name="area"> <?php echo makeSelectTV_live("area", ''); ?> </select> </td> </tr> <tr> <td>显示到App:</td> <td><select id="status" name="status"> <option value="0" selected>不显示</option> <option value="1" >显示</option> </select> </td> </tr> <!-- <tr>--> <!-- <td>直播视频地址:</td>--> <!-- <td>--> <!-- <TEXTAREA id="tv_playurl" NAME="tv_playurl" ROWS="2" style="width:300px;table-layout:fixed; word-wrap:break-word;"></TEXTAREA>--> <!-- </td>--> <!-- </tr>--> <tr align="center" > <td colspan="2"><input class="input" type="submit" value="保存" id="btnSave"> <input class="input" type="button" value="返回" id="btnCancel"></td> </tr> </table> </form> </div> </body> </html> <?php unset($rs); }
function main() { global $db, $cache; $keyword = be("all", "keyword"); $tv_type = be("all", "tv_type"); $where = " 1=1 "; if (!isN($keyword)) { $where .= " AND video_name LIKE '%" . $keyword . "%' "; } $pagenum = be("all", "page"); if (!isNum($pagenum)) { $pagenum = 1; } else { $pagenum = intval($pagenum); } if ($pagenum < 1) { $pagenum = 1; } $sql = "SELECT count( * )\r\nFROM (\r\n\r\nSELECT count( video_name )\r\nFROM `mac_tv_program_item`\r\nWHERE (program_type IS NULL\r\nOR program_type = '' ) and video_name is not null and video_name !='' and " . $where . "\r\nGROUP BY video_name\r\n) AS c\r\n\t"; $nums = $db->getOne($sql); // var_dump($sql); $pagecount = ceil($nums / 100); $sql = "SELECT video_name FROM `mac_tv_program_item` WHERE (program_type IS NULL OR program_type = '' ) and video_name is not null and video_name !='' and " . $where . " GROUP BY video_name limit " . 100 * ($pagenum - 1) . "," . '100'; $rs = $db->query($sql); ?> <script language="javascript"> function filter(){ var keyword=$("#keyword").val(); var url = "admin_program_type_items.php?keyword="+encodeURI(keyword); window.location.href=url; } $(document).ready(function(){ $("#form2").validate({ rules:{ t_name:{ required:true, // stringCheck:true, maxlength:64 }, // t_enname:{ // required:true, //// stringCheck:true, // maxlength:128 // }, // t_template:{ // required:true, // maxlength:128 // }, t_pic:{ maxlength:254 }, t_sort:{ number:true }, t_des:{ required:true, maxlength:254 } } }); $('#form1').form({ onSubmit:function(){ if(!$("#form1").valid()) {return false;} }, success:function(data){ $.messager.alert('系统提示', data, 'info',function(){ location.href=location.href; }); } }); $('#form2').form({ onSubmit:function(){ if(!$("#form2").valid()) {return false;} }, success:function(data){ $.messager.alert('系统提示', data, 'info'); } }); $("#btnDel").click(function(){ if(confirm('确定要删除吗')){ $("#form1").attr("action","admin_ajax.php?action=del&flag=batch&tab={pre}vod_topic"); $("#form1").submit(); } else{return false} }); $("#btnAddLunBo").click(function(){ if(confirm('确定要添加到轮播图吗')){ $("#form1").attr("action","admin_ajax.php?action=lunboForTopic&flag=batch&tab={pre}vod_popular"); $("#form1").submit(); } else{return false} }); $("#btnEdit").click(function(){ $("#form1").attr("action","?action=editall"); $("#form1").submit(); }); $("#btnAdd").click(function(){ $('#form2').form('clear'); $("#flag").val("add"); $('#win1').window('open'); }); $("#btnCancel").click(function(){ location.href= location.href; }); }); function edit(id) { $('#form2').form('clear'); $("#flag").val("edit"); $('#win1').window('open'); $('#form2').form('load','admin_ajax.php?action=getinfo&tab={pre}tv&col=id&val='+id); } </script> <table class="tb"> <tr> <td> <table width="96%" border="0" align="center" cellpadding="3" cellspacing="1"> <tr> <td colspan="6"> 关键字:<input id="keyword" size="40" name="keyword" value="<?php echo $keyword; ?> "> <input class="input" type="button" value="搜索" id="btnsearch" onClick="filter();"> </td> <td width="150px"> </td> </tr> </table> </td> </tr> </table> <table class="tb"> <form action="" method="post" id="form1" name="form1"> <?php if ($nums == 0) { ?> <tr><td align="center" colspan="7">没有任何记录!</td></tr> <?php } else { ?> <tr> <td>下面节目还没归类,请选择相应的节目类别<select id="program_type" name="program_type" > <?php echo makeSelectTV_live("prod_type", ''); ?> </select> 全选<input type="checkbox" name="chkall" id="chkall" class="checkbox" onClick="checkAll(this.checked,'t_id[]')" /> <input type="button" value="批量归档" id="btnEdit" class="input" /> </td> </tr> <tr> <td> <?php $index = 0; while ($row = $db->fetch_array($rs)) { $index++; $t_id = $row["video_name"]; ?> <input name="t_id[]" type="checkbox" id="t_id" value="<?php echo $t_id; ?> " /> <?php echo $t_id; ?> <?php if ($index % 10 === 0) { echo '<br/>'; } ?> <?php } ?> </td> </tr> <?php } ?> <tr align="center" > <td colspan="8"> <?php echo pagelist_manage($pagecount, $pagenum, $nums, app_pagenum, "admin_program_type_items.php?page={p}&keyword=" . urlencode($keyword)); ?> </td> </tr> </table> </form> <div id="win1" class="easyui-window" title="窗口" style="padding:5px;width:450px;" closed="true" closable="false" minimizable="false" maximizable="false"> <form action="admin_ajax.php?action=save&tab={pre}tv" method="post" name="form2" id="form2"> <table class="tb"> <input id="id" name="id" type="hidden" value=""> <input id="flag" name="flag" type="hidden" value=""> <tr> <td width="30%">电视名称:</td> <td><input id="tv_name" size=40 value="" name="tv_name"> </td> </tr> <!-- <tr>--> <!-- <td>电视编码:</td>--> <!-- <td> <input id="tv_code" size=40 value="" name="tv_code">--> <!-- </td>--> <!-- </tr>--> <tr> <td>电视节目类别:</td> <td><select id="tv_type" name="tv_type"> <option value="-1">类型</option> <option value="1" >央视</option> <option value="2">卫视</option> <option value="3" >城市</option> <option value="4">CETV</option> <option value="5">数字</option> </select> </td> </tr> <tr> <td>国家:</td> <td><select id="country" name="country"> <?php echo makeSelectTV_live("country", ''); ?> </select> </td> </tr> <tr> <td>地区:</td> <td><select id="area" name="area"> <?php echo makeSelectTV_live("area", ''); ?> </select> </td> </tr> <tr> <td>显示到App:</td> <td><select id="status" name="status"> <option value="0" selected>不显示</option> <option value="1" >显示</option> </select> </td> </tr> <!-- <tr>--> <!-- <td>直播视频地址:</td>--> <!-- <td>--> <!-- <TEXTAREA id="tv_playurl" NAME="tv_playurl" ROWS="2" style="width:300px;table-layout:fixed; word-wrap:break-word;"></TEXTAREA>--> <!-- </td>--> <!-- </tr>--> <tr align="center" > <td colspan="2"><input class="input" type="submit" value="保存" id="btnSave"> <input class="input" type="button" value="返回" id="btnCancel"></td> </tr> </table> </form> </div> </body> </html> <?php unset($rs); }