function main()
{
global $db, $template, $cache;
$loginname = getCookie("adminname");
$keyword = be("all", "keyword");
$stype = be("all", "stype");
$area = be("all", "area");
$topic = be("all", "topic");
$level = be("all", "level");
$from = be("all", "from");
$sserver = be("all", "sserver");
$sstate = be("all", "sstate");
$repeat = be("all", "repeat");
$repeatlen = be("all", "repeatlen");
$order = be("all", "order");
$pagenum = be("all", "page");
$sort = be("all", "sort");
$spic = be("all", "spic");
$hide = be("all", "hide");
$d_status = be("all", "d_status");
$douban_score = be("all", "douban_score");
$ipadpic = be("all", "ipadpic");
$d_douban_id = be("all", "d_douban_id");
$can_search_device = be("all", "can_search_device");
if (!isNum($level)) {
$level = 0;
} else {
$level = intval($level);
}
if (!isNum($sstate)) {
$sstate = 0;
} else {
$sstate = intval($sstate);
}
if (!isNum($stype)) {
$stype = 0;
} else {
$stype = intval($stype);
}
if (!isNum($area)) {
$area = 0;
} else {
$area = intval($area);
}
if (!isNum($topic)) {
$topic = 0;
} else {
$topic = intval($topic);
}
if (!isNum($spic)) {
$spic = 0;
} else {
$spic = intval($spic);
}
if (!isNum($ipadpic)) {
$ipadpic = 0;
} else {
$ipadpic = intval($ipadpic);
}
if (!isNum($hide)) {
$hide = -1;
} else {
$hide = intval($hide);
}
if (!isNum($douban_score)) {
$douban_score = 0;
} else {
$douban_score = intval($douban_score);
}
if (!isNum($repeatlen)) {
$repeatlen = 0;
}
if (!isNum($d_status)) {
$d_status = -1;
} else {
$d_status = intval($d_status);
}
if (isNum($d_douban_id)) {
$d_douban_id = intval($d_douban_id);
}
if (!isNum($pagenum)) {
$pagenum = 1;
} else {
$pagenum = intval($pagenum);
}
if ($pagenum < 1) {
$pagenum = 1;
}
$where = " d_type in (1,2,3,131) ";
$keyword_col = be("all", "keyword_col");
if (!isN($keyword)) {
$keyword = trim($keyword);
if (isN($keyword_col)) {
$where .= " AND ( d_directed like '%" . $keyword . "%' or d_starring like '%" . $keyword . "%' or d_name like '%" . $keyword . "%' or d_enname like '%" . $keyword . "%' ) ";
} else {
$where .= " AND " . $keyword_col . " like '%" . $keyword . "%' ";
}
}
if ($stype > 0) {
$typearr = getValueByArray($cache[0], "t_id", $stype);
if (is_array($typearr)) {
$where = $where . " and d_type in (" . $typearr["childids"] . ")";
} else {
$where .= " AND d_type=" . $stype . " ";
}
}
if ($stype == -1) {
$where .= " AND d_type=0 ";
}
if ($area > 0) {
$where .= " AND d_area = " . $area . " ";
}
if ($topic > 0) {
$where .= " AND d_topic = " . $topic . " ";
}
if ($level > 0) {
$where .= " AND d_level = " . $level . " ";
}
if ($sstate == 1) {
$where .= " AND d_state>0 ";
} else {
if ($sstate == 2) {
$where .= " AND d_state=0 ";
}
}
if ($hide != -1) {
$where .= " AND d_hide=" . $hide . " ";
}
if ($d_douban_id == -1) {
$where .= " AND d_douban_id=" . $d_douban_id . " ";
} else {
if ($d_douban_id == 1) {
$where .= " AND d_douban_id >0 ";
} else {
if ($d_douban_id == 2) {
$where .= " AND d_douban_id =0 ";
}
}
}
if ($d_status != -1) {
$where .= " AND d_status=" . $d_status . " ";
}
if ($douban_score == 1) {
$where .= " AND d_score >0 ";
}
if ($douban_score == 2) {
$where .= " AND d_score <=0 ";
}
if ($stype == 1 || $stype == 2) {
$douban_scoreT = "block";
} else {
$douban_scoreT = "none";
}
if (!isN($can_search_device)) {
// if($can_search_device ==='TV'){
// $where .= " AND can_search_device like '%TV%' ";
// }else {
// $where .= " AND (can_search_device like '".$can_search_device."' or can_search_device is null or can_search_device ='' ) ";
// }
$where .= " AND (can_search_device like '" . $can_search_device . "' or can_search_device is null or can_search_device ='' ) ";
}
if ($repeat == "ok") {
$repeatSearch = " d_name ";
if ($repeatlen > 0) {
$repeatSearch = " substring(d_name,1," . $repeatlen . ") ";
}
$repeatsql = " , (SELECT " . $repeatSearch . " as d_name1 FROM {pre}vod GROUP BY d_name1 HAVING COUNT(*)>1) as `t2` ";
$where .= " AND `{pre}vod`.`d_name`=`t2`.`d_name1` ";
if (isN($order)) {
$order = "d_name,d_addtime";
}
}
$douban_comment = be("all", "douban_comment");
if (!isNum($douban_comment)) {
$douban_comment = 0;
} else {
$douban_comment = intval($douban_comment);
}
if ($douban_comment == 1) {
$where .= " and d_id in (SELECT DISTINCT content_id FROM tbl_comments WHERE author_id IS NULL AND thread_id IS NULL) ";
}
if ($douban_comment == 2) {
$where .= " and d_id not in (SELECT DISTINCT content_id FROM tbl_comments WHERE author_id IS NULL AND thread_id IS NULL) ";
}
if (isN($order)) {
$orders = "d_time desc ";
} else {
if (!isN($sort)) {
$orders = $order . ' ' . $sort;
}
}
if (!isN($sserver)) {
$where .= " AND d_playserver like '%" . $sserver . "%' ";
}
if (!isN($from)) {
$where .= " and d_playfrom like '%" . $from . "%' ";
}
if ($spic == 1) {
$where .= " AND d_pic = '' ";
} else {
if ($spic == 2) {
$where .= " and d_pic not like '%joyplus%' and d_pic!='' ";
}
}
if ($ipadpic == 1) {
$where .= " AND (d_pic_ipad = '' or d_pic_ipad is null )";
} else {
if ($ipadpic == 2) {
$where .= " AND d_pic_ipad not like '%joyplus%' and d_pic_ipad != '' ";
}
}
$select_weburl = be("all", "select_weburl");
$select_videourl = be("all", "select_videourl");
$select_videourl_play = be("all", "select_videourl_play");
if (!isNum($select_videourl_play)) {
$select_videourl_play = -1;
} else {
$select_videourl_play = intval($select_videourl_play);
}
if ($select_videourl_play == 0) {
$where .= " AND d_play_check = 0 ";
}
if ($select_videourl_play == 2) {
$where .= " AND d_play_check = 2 ";
}
if ($select_videourl_play == 1) {
$where .= " AND d_play_check = 1 ";
}
if ($select_weburl == 1) {
$where .= " AND webUrls is not null and webUrls !='' ";
}
if ($select_weburl == 2) {
$where .= " AND (webUrls is null or webUrls ='') ";
}
if ($select_videourl == 1) {
$where .= " AND d_downurl is not null and d_downurl !='' ";
}
if ($select_videourl == 2) {
$where .= " AND (d_downurl is null or d_downurl ='') ";
}
$sql = "SELECT count(*) FROM {pre}vod " . $repeatsql . " where " . $where;
$nums = $db->getOne($sql);
$pagecount = ceil($nums / app_pagenum);
//$sql = "SELECT d_year,d_id, d_name, d_enname, d_play_num,d_type,d_state,d_topic, d_level, d_hits, d_time,d_remarks,d_playfrom,d_hide,p.id as popular_id FROM {pre}vod ".$repeatsql." left join {pre}vod_popular as p on p.vod_id=d_id WHERE" . $where . " ORDER BY " . $orders . " limit ".(app_pagenum * ($pagenum-1)) .",".app_pagenum;
$sql = "SELECT d_year,d_id, d_name, d_enname, d_play_num,d_type,d_state,d_topic, d_level, d_hits, d_time,d_remarks,d_playfrom,d_hide FROM {pre}vod " . $repeatsql . " WHERE" . $where . " ORDER BY " . $orders . " limit " . app_pagenum * ($pagenum - 1) . "," . app_pagenum;
// var_dump($sql);
$rs = $db->query($sql);
?>
<script type="text/javascript" src="./resource/thickbox-compressed.js"></script>
<script type="text/javascript" src="./resource/thickbox.js"></script>
<link href="./resource/thickbox.css" rel="stylesheet" type="text/css" />
<script language="javascript">
$(document).ready(function(){
$("#form1").validate({
rules:{
repeatlen:{
number:true,
max:10
}
}
});
$("#btnrepeat").click(function(){
var repeatlen = $("#repeatlen").val();
var reg = /^\d+$/;
var re = repeatlen.match(reg);
if (!re){ repeatlen=0; }
if (repeatlen >20){ alert("长度最大20");$("#repeatlen").focus();return;}
var url = "admin_vod.php?repeat=ok&repeatlen=" + repeatlen;
window.location.href=url;
});
$("#btnDel").click(function(){
if(confirm('确定要删除吗')){
$("#form1").attr("action","admin_vod.php?action=del");
$("#form1").submit();
}
else{return false}
});
$("#plsc").click(function(){
var ids="",rc=false;
$("input[name='d_id']").each(function() {
if(this.checked){
if(rc)ids+=",";
ids = ids + this.value;
rc=true;
}
});
$("#form1").attr("action","admin_makehtml.php?acton=viewpl&flag=vod&d_id="+ids);
$("#form1").submit();
});
});
function filter(){
var stype=$("#stype").val();
var order=$("#order").val();
var from=$("#from").val();
var sort=$("#sort").val();
var keyword=$("#keyword").val();
var keyword_col=$("#keyword_col").val();
var can_search_device=$("#can_search_device").val();
var url = "admin_online_subscribe.php?can_search_device="+can_search_device+"&keyword_col="+keyword_col+"&sort="+sort+"&keyword="+encodeURI(keyword)+"&stype="+stype+"&order="+order+"&from="+from; //ipadpic
window.location.href=url;
}
function prepareWeiboText(type,id,name){
document.getElementById( "weiboText").value= name;
document.getElementById( "notify_msg_prod_id").value= id;
document.getElementById( "notify_msg_prod_type").value= type;
$('#SendWeiboMsg').empty();
}
function sendWeiboText(){
var weibotxt= document.getElementById( "weiboText").value;
var notify_msg_prod_id= document.getElementById( "notify_msg_prod_id").value;
var notify_msg_prod_type= document.getElementById( "notify_msg_prod_type").value;
var urlT='admin_vod.php?action=notifyMsg&prod_type='+notify_msg_prod_type+'&prod_id='+notify_msg_prod_id+'&content=' +encodeURIComponent(weibotxt) ;
var channels= document.getElementById( "channel[]");
alert(channels);
for(var i = 0; i < channels.length; i++){
if (channels[i].checked == true) {
urlT = urlT +'&channels='+channels[i].value;
}
}
$.post(urlT, {Action:"post"}, function (data, textStatus){
if(textStatus == "success"){
//alert(data);
$('#SendWeiboMsg').empty().append(data);
}else{
$('#SendWeiboMsg').empty().append('发送失败。');
}
});
// alert(urlT);
}
</script>
<table class="admin_online_subscribe tb">
<tr>
<td>
<table width="96%" border="0" align="center" cellpadding="3" cellspacing="1">
<tr>
<td colspan="2">
过滤条件：<select id="stype" name="stype" onchange="javascript:{var typeid= this.options[this.selectedIndex].value; if(typeid=='1' || typeid=='2'){document.getElementById('btnsearchs').style.display='block'; document.getElementById('btnsearchsThumbs').style.display='block';document.getElementById('btnsearchsComment').style.display='block';}else {document.getElementById('btnsearchs').style.display='none'; document.getElementById('btnsearchsThumbs').style.display='none';document.getElementById('btnsearchsComment').style.display='none';}}">
<option value="0">视频栏目</option>
<option value="-1" <?php
if ($stype == -1) {
echo "selected";
}
?>
>没有栏目</option>
<?php
echo makeSelectAll("{pre}vod_type", "t_id", "t_name", "t_pid", "t_sort", 0, "", " | ", $stype);
?>
</select>
<select id="order" name="order">
<option value="d_time">视频排序</option>
<option value="d_id" <?php
if ($order == "d_id") {
echo "selected";
}
?>
>视频编号</option>
<option value="d_name" <?php
if ($order == "d_name") {
echo "selected";
}
?>
>视频名称</option>
<option value="d_play_num" <?php
if ($order == "d_play_num") {
echo "selected";
}
?>
>播放次数</option>
<option value="d_year" <?php
if ($order == "d_year") {
echo "selected";
}
?>
>上映日期</option>
</select>
<select id="sort" name="sort">
<option value="desc" <?php
if ($sort == "desc") {
echo "selected";
}
?>
>视频排序 降序序</option>
<option value="asc" <?php
if ($sort == "asc") {
echo "selected";
}
?>
>视频排序 升序</option>
</select>
<select id="from" name="from">
<option value="">视频播放器</option>
<?php
echo makeSelectPlayer($from);
?>
</select>
<select id="can_search_device" name="can_search_device">
<option value="" >投放设备</option>
<option value="TV" <?php
if ($can_search_device === 'TV') {
echo "selected";
}
?>
>TV版</option>
<option value="iPad" <?php
if ($can_search_device === 'iPad') {
echo "selected";
}
?>
>iPad版</option>
<option value="iphone" <?php
if ($can_search_device === 'iphone') {
echo "selected";
}
?>
>iphone版</option>
<option value="apad" <?php
if ($can_search_device === 'apad') {
echo "selected";
}
?>
>Android-Pad版</option>
<option value="aphone" <?php
if ($can_search_device === 'aphone') {
echo "selected";
}
?>
>Android-Phone版</option>
<option value="web" <?php
if ($can_search_device === 'web') {
echo "selected";
}
?>
>网站版</option>
</select>
</td>
</tr>
<tr>
<td colspan="4">
关键字：<input id="keyword" size="40" name="keyword" value="<?php
echo $keyword;
?>
">
<select id="keyword_col" name="keyword_col">
<option value="">关键字的匹配列</option>
<option value="d_name" <?php
if ($keyword_col == "d_name") {
echo "selected";
}
?>
>视频名称</option>
<option value="d_starring" <?php
if ($keyword_col == "d_starring") {
echo "selected";
}
?>
>演员</option>
<option value="d_directed" <?php
if ($keyword_col == "d_directed") {
echo "selected";
}
?>
>导演</option>
</select>
<input class="input" type="button" value="搜索" id="btnsearch" onClick="filter();">
</td>
</tr>
</table>
</td>
</tr>
</table>
<form id="form1" name="form1" method="post">
<table class="tb">
<tr>
<td width="10%">编号</td>
<td width="25%">名称</td>
<td width="10%">播放次数</td>
<td width="10%">上映日期</td>
<td width="5%">分类</td>
<td width="20%">时间</td>
<td width="20%">操作</td>
</tr>
<?php
if ($nums == 0) {
?>
<tr><td align="center" colspan="12">没有任何记录!</td></tr>
<?php
} else {
while ($row = $db->fetch_array($rs)) {
$d_id = $row["d_id"];
$tname = "未知";
$tenname = "";
$typearr = getValueByArray($cache[0], "t_id", $row["d_type"]);
if (is_array($typearr)) {
$tname = $typearr["t_name"];
$tenname = $typearr["t_enname"];
}
?>
<tr>
<td><?php
echo $d_id;
?>
</td>
<td><?php
echo substring($row["d_name"], 20);
?>
<?php
if ($row["d_state"] > 0) {
echo "<font color=\"red\">[" . $row["d_state"] . "]</font>";
}
?>
<?php
if (!isN($row["d_remarks"])) {
echo "<font color=\"red\">[" . $row["d_remarks"] . "]</font>";
}
?>
<?php
if ($row["d_hide"] == 1) {
echo "<font color=\"red\">[隐藏]</font>";
}
?>
</td>
<td><?php
echo $row["d_play_num"];
?>
</td>
<td><?php
echo $row["d_year"];
?>
</td>
<td><?php
echo $tname;
?>
</td>
<td><?php
echo isToday($row["d_time"]);
?>
</td>
<td><a href="admin_vod_topic.php?action=info&id=<?php
echo $d_id;
?>
">所在榜单</a> |
<a class="thickbox" href="#TB_inline?height=400&width=600&inlineId=myOnPageContent" onclick="javascript:{prepareWeiboText('<?php
echo $row["d_type"];
?>
','<?php
echo $d_id;
?>
','<?php
echo substring($row["d_name"], 20);
?>
');}" > 消息推送</a> </td>
</tr>
<?php
}
}
?>
<!-- <tr>-->
<!-- <td colspan="12">-->
<!-- 全选<input name="chkall" type="checkbox" id="chkall" value="1" onClick="checkAll(this.checked,'d_id[]');"/> -->
<!-- 批量操作：<input type="button" id="btnDel" value="删除" class="input">-->
<!-- <input type="button" id="pltj" value="推荐" onClick="plset('pltj','vod')" class="input">-->
<!-- <input type="button" id="plfl" value="分类" onClick="plset('plfl','vod')" class="input">-->
<!-- <input type="button" id="plzt" value="专题" onClick="plset('plzt','vod')" class="input">-->
<!-- <input type="button" id="plluobo" value="轮播图" onClick="plsetLuobo()" class="input">-->
<!-- <input type="button" id="plbd" value="视频悦单" onClick="plsetBD('plbd','vod','1')" class="input">-->
<!-- <input type="button" id="plbd" value="视频悦榜" onClick="plsetBD('plbd','vod','2')" class="input">-->
<!-- <input type="button" id="plrq" value="人气" onClick="plset('plrq','vod')" class="input">-->
<!-- <input type="button" id="plsc" value="生成" class="input">-->
<!-- <input type="button" id="plyc" value="显隐" onClick="plset('plyc','vod')" class="input">-->
<!-- <span id="plmsg" name="plmsg"></span>-->
<!-- </td>-->
<!-- </tr>-->
<tr class="formlast">
<td align="center" colspan="12">
<?php
echo pagelist_manage($pagecount, $pagenum, $nums, app_pagenum, "admin_online_subscribe.php?page={p}&can_search_device=" . $can_search_device . "&keyword=" . urlencode($keyword) . "&keyword_col=" . $keyword_col . "&sort=" . $sort . "&order=" . $order . "&stype=" . $stype . "&from=" . $from);
?>
</td>
</tr>
</table>
</form>
<div id="myOnPageContent" style="display:none">
<script language="javascript">
$('#form2').form({
success:function(data){
$('#SendWeiboMsg').empty().append(data);
$("#btnEdit").attr("disabled",false);
}
});
$("#btnEdit").click(function(){
if(confirm('确定要推送消息吗')){
$("#form2").attr("action","?action=notifyMsg");
var weibotxt= $("#weiboText").val();
$("#btnEdit").attr("disabled",true);
if(weibotxt ==''){
alert("发送内容不能为空。");
$("#btnEdit").attr("disabled",false);
return;
}
if(weibotxt.length>=110){
alert("你发送的内容太长，不能超过110个字符。");
$("#btnEdit").attr("disabled",false);
return;
}
var prod_id= $("#notify_msg_prod_id").val();
var prod_type= $("#notify_msg_prod_type").val();
$('#SendWeiboMsg').empty().append('正在推送消息.....<br/>');
var urlT='admin_online_subscribe.php?action=notifyMsg¬ify_msg_prod_type='+prod_type+'¬ify_msg_prod_id='+prod_id+'&content=' +encodeURIComponent(weibotxt) ;
var channels=document.getElementsByName("channel[]");
var channelFlag=true;
var index=0;
var indexSelect=0;
for(var i = 0; i < channels.length; i++){
if (channels[i].checked == true) {
channelFlag=false;
indexSelect++;
urlTs = urlT +'&channel='+channels[i].value;
// alert(channels[i].value);
$.post(urlTs, {Action:"post"}, function (data, textStatus){
if(textStatus == "success"){
index++;
//alert(data);
$('#SendWeiboMsg').append(data).append('<br/>');
}else{
index++;
$('#SendWeiboMsg').append('发送失败。').append('<br/>');
}
if( index==indexSelect){
$("#btnEdit").attr("disabled",false);
$('#SendWeiboMsg').append('推送消息完成。').append('<br/>');
}
});
}
}
if(channelFlag){
alert('你必须要选择一个频道发送');
}
//$("#form2").submit();
}
});
</script>
<form id="form2" name="form1" method="post">
<table class="table" cellpadding="0" cellspacing="0" width="100%" border="0">
<thead class="tb-tit-bg">
<!-- <tr>-->
<!-- <td > <h3 class="title"> 发送设备:<select name="device_type" id="device_type" > -->
<!-- <option value="" >所有设备</option>-->
<!-- <option value="ios" >IOS</option>-->
<!-- <option value="android" >Android</option> -->
<!-- </select> -->
<!-- </h3></td> -->
<!-- -->
<!-- </tr>-->
<tr>
<td colspan="2"><span><h3>发送信息</h3></span></td>
</tr>
<input type="hidden" name="notify_msg_prod_id" id="notify_msg_prod_id" value="">
<input type="hidden" name="notify_msg_prod_type" id="notify_msg_prod_type" value="">
<tr>
<td colspan="2" align="center"><textarea name="wbText" id="weiboText" rows="10" cols="90"></textarea></td>
</tr>
<tr>
<td align="left"> <br/>
Parse 云推送<br/>
<input type="checkbox" id='channel[]' name="channel[]" value="CHANNEL_ANDROID" />悦视频 Android版<br/>
<!-- <input type="checkbox" id='channel[]' name="channel[]" value="CHANNEL_TV" />悦视频 TV版<br/>-->
<input type="checkbox" id='channel[]' name="channel[]" value="CHANNEL_IOS" />悦视频 IOS版<br/>
<input type="checkbox" id='channel[]' name="channel[]" value="CHANNEL_IPHONE" />今晚剧场iphone版<br/>
<input type="checkbox" id='channel[]' name="channel[]" value="CHANNEL_IPAD" />今晚剧场IPAD版<br/>
</td>
<td align="left"> <br/>
百度云推送<br/>
<input type="checkbox" id='channel[]' name="channel[]" value="CHANNEL_ANDROID_BAIDU" />悦视频 Android版<br/>
<!-- <input type="checkbox" id='channel[]' name="channel[]" value="CHANNEL_TV_BAIDU" />悦视频 TV版<br/>-->
<input type="checkbox" id='channel[]' name="channel[]" value="CHANNEL_IOS_BAIDU" />悦视频 IOS版<br/>
<input type="checkbox" id='channel[]' name="channel[]" value="CHANNEL_IPHONE_BAIDU" />今晚剧场iphone版<br/>
<input type="checkbox" id='channel[]' name="channel[]" value="CHANNEL_IPAD_BAIDU" />今晚剧场IPAD版<br/>
</td>
</tr>
<tr>
<td align="center" colspan="2"><input type="button" value="发送消息" id="btnEdit" class="input" /></td>
</tr>
<tr>
<td align="left" colspan="2"> <font color=red><span id="SendWeiboMsg"></span></font></td>
</tr>
</thead>
</table>
</form>
</div>
<?php
if ($pagenum == 1 && $where == " 1=1 ") {
echo "<script>showpic();</script>";
}
unset($rs);
}
function View()
{
$d_id = be("all", "id");
global $db;
?>
<table class="admin_vod_feedback tb" width="50%">
<tr>
<td width="5%"></td>
<td width="40%">反馈类别</td>
<td>反馈次数</td>
</tr>
<?php
for ($i = 1; $i <= 10; $i++) {
if ($i == 8) {
continue;
}
?>
<tr><td></td>
<td><select id="feedback_types" name="feedback_types" disabled>
<option value="9" <?php
if ($i == "9") {
echo "selected";
}
?>
>程序反馈影片无法播放</option>
<option value="1" <?php
if ($i == "1") {
echo "selected";
}
?>
>用户反馈影片无法播放</option>
<option value="2" <?php
if ($i == "2") {
echo "selected";
}
?>
>用户反馈影片播放不流畅</option>
<option value="3" <?php
if ($i == "3") {
echo "selected";
}
?>
>用户反馈影片加载比较慢</option>
<option value="4" <?php
if ($i == "4") {
echo "selected";
}
?>
>用户反馈影片不能下载</option>
<option value="5" <?php
if ($i == "5") {
echo "selected";
}
?>
>用户反馈观看影片时出现闪退</option>
<option value="6" <?php
if ($i == "6") {
echo "selected";
}
?>
>用户反馈画质不清晰</option>
<option value="7" <?php
if ($i == "7") {
echo "selected";
}
?>
>用户反馈音画不同步</option>
<option value="8" <?php
if ($i == "8") {
echo "selected";
}
?>
>用户反馈其它（用户自己填写，可不填）</option>
<option value="10" <?php
if ($i == "10") {
echo "selected";
}
?>
>程序反馈视频地址失效</option>
</select></td>
<td><?php
echo $db->getOne("select count(*) as count from tbl_video_feedback where feedback_type like '%" . $i . "%' and prod_id=" . $d_id);
?>
</td>
</tr>
<?php
}
?>
</table>
<table class="admin_vod_feedback tb" width="50%">
<tr>
<td colspan="3">反馈类别:其它（用户自己填写，可不填）</td>
</tr>
<tr>
<td width="5%"></td>
<td>反馈时间</td>
<td>反馈内容</td>
</tr>
<?php
$rs = $db->query("select * from tbl_video_feedback where feedback_type like '%8%' and prod_id=" . $d_id);
while ($row = $db->fetch_array($rs)) {
?>
<tr><td width="5%"></td>
<td width="40%"><?php
echo isToday($row["create_date"]);
?>
</td>
<td><?php
echo substring($row["feedback_memo"], 20);
?>
</td>
</tr>
<?php
}
unset($rs);
?>
</table>
<?php
echo '</body>
</html>';
}
function main()
{
global $db, $cache, $parse_appid_restkey;
$topic_id = be("all", "topic_id");
$flag = be("all", "flag");
if (!isNum($topic_id)) {
$topic_id = 0;
} else {
$topic_id = intval($topic_id);
}
if (!isNum($flag)) {
$flag = -1;
} else {
$flag = intval($flag);
}
$where = " 1=1 ";
$where .= " AND a.topic_id =" . $topic_id;
if ($flag == 1) {
$where .= " AND a.flag =1 ";
}
if ($flag == 0) {
$where .= " AND a.flag =0 ";
}
$pagenum = be("all", "page");
if (!isNum($pagenum)) {
$pagenum = 1;
} else {
$pagenum = intval($pagenum);
}
if ($pagenum < 1) {
$pagenum = 1;
}
$sql = "SELECT count(a.prod_id) FROM {pre}vod_pasre_item a,{pre}vod vod where a.prod_id=vod.d_id and vod.favority_user_count >0 ";
$nums = $db->getOne($sql);
$pagecount = ceil($nums / app_pagenum);
$sql = "SELECT a.channels as channels, vod.d_remarks ,vod.d_state,a.d_status as status,a.id as id, a.create_date as create_date, vod.favority_user_count as favority_user_count, vod.d_name as vod_name,vod.d_id as vod_id FROM {pre}vod_pasre_item a,{pre}vod vod where a.prod_id=vod.d_id and vod.favority_user_count >0 order by vod.favority_user_count desc, a.d_status asc, a.create_date desc limit " . app_pagenum * ($pagenum - 1) . "," . app_pagenum;
//var_dump($sql);
$rs = $db->query($sql);
?>
<script language="javascript">
function filter(){
var topic_id=$("#topic_id").val();
var st_flag =$("#st_flag").val();
var url = "admin_vod_topic_items.php?topic_id="+topic_id+"&flag="+st_flag;
window.location.href=url;
}
$(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_pasre_item");
$("#form1").submit();
}
else{return false}
});
$("#btnEdit").click(function(){
if(confirm('确定要推送消息吗')){
var url='admin_subscribe.php?action=editall&ids=';
var channels=document.getElementsByName("ids[]");
var channelFlag=true;
var ids='';
for(var i = 0; i < channels.length; i++){
if (channels[i].checked == true) {
channelFlag=false;
ids=channels[i].value+","+ids;
}
}
if(channelFlag){
alert("你至少需要选择一个视频");
}else {
location.href=url+ids;
}
// location.href
}
});
// $("#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>
<table class="admin_subscribe tb">
<form action="" method="post" id="form1" name="form1">
<tr>
<td width="5%"> </td>
<td width="10%">视频ID</td>
<td>视频名称</td>
<td>推送应用</td>
<td width="15%">更新时间</td>
<td width="5%">追剧人数</td>
<td width="5%">操作</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="ids[]" type="checkbox" id="ids" value="<?php
echo $t_id;
?>
" /></td>
<td><?php
echo $row["vod_id"];
?>
</td>
<td><a href="admin_vod.php?action=edit&id=<?php
echo $row["vod_id"];
?>
">
<?php
echo $row["vod_name"];
?>
</a>
<?php
if ($row["d_state"] > 0) {
echo "<font color=\"red\">[" . $row["d_state"] . "]</font>";
}
?>
<?php
if (!isN($row["d_remarks"])) {
echo "<font color=\"red\">[" . $row["d_remarks"] . "]</font>";
}
?>
</td>
<td> <?php
$tempChannels = $row["channels"];
//$parse_appid_restkey
if (isN($tempChannels)) {
echo '所有应用';
} else {
$tempChannels = explode(",", $tempChannels);
foreach ($tempChannels as $tChannel) {
echo '[' . $parse_appid_restkey[$tChannel]['appname'] . '] ';
}
}
?>
</td>
<td>
<?php
echo isToday($row["create_date"]);
?>
</td>
<td>
<?php
echo $row["favority_user_count"];
?>
</td>
<td>
<a href="admin_ajax.php?action=del&tab={pre}vod_pasre_item&ids=<?php
echo $t_id;
?>
" onClick="return confirm('确定要删除吗?');">删除</a></td>
</tr>
<?php
}
}
?>
<tr class="formlast">
<td colspan="8"><input type="checkbox" name="chkall" id="chkall" class="checkbox" onClick="checkAll(this.checked,'ids[]')" /> 全选
<input type="button" value="批量删除" id="btnDel" class="input" />
<input type="button" value="发送消息" id="btnEdit" class="input" />
</td></tr>
<tr align="center" class="formlast">
<td colspan="8">
<?php
echo pagelist_manage($pagecount, $pagenum, $nums, app_pagenum, "admin_subscribe.php?page={p}&topic_id=" . $topic_id . "&flag=" . $flag);
?>
</td>
</tr>
</table>
</form>
</body>
</html>
<?php
unset($rs);
}
function printDay($i, $eventDaysArray)
{
// wenn Heute UND ein Event ist, beide Klassen hinzufügen
if (isToday($i) && isEvent($eventDaysArray, $i)) {
echo "<td class='today' class='eventDay'>" . $i . "</td>";
} elseif (isToday($i)) {
echo "<td class='today'>" . $i . "</td>";
} elseif (isEvent($eventDaysArray, $i)) {
echo "<td class='eventDay'>" . $i . "</td>";
} else {
echo "<td>" . $i . "</td>";
}
}
function getPrice($symbol, $date)
{
if (isToday($date) == true) {
$url = 'http://finance.yahoo.com/q/ecn?s=' . $symbol;
if (($file = fopen($url, "r")) == false) {
return -1;
}
$r = "";
do {
$data = fread($file, 8192);
$r .= $data;
} while (strlen($data) != 0);
$idx = strpos($r, 'Last Trade:', 0);
$idx = strpos($r, '<b>', $idx);
$end = strpos($r, '</b>', $idx);
$val = substr($r, $idx + 3, $end - $idx - 3);
if (is_numeric($val) == false) {
return -1;
}
return $val;
} else {
$mm = intval(substr($date, 5, 2)) - 1;
$dd = substr($date, 8, 2);
$yyyy = substr($date, 0, 4);
$url = 'http://finance.yahoo.com/q/hp?s=' . $symbol . '&a=' . $mm . '&b=' . $dd . '&c=' . $yyyy . '&d=' . $mm . '&e=' . $dd . '&f=' . $yyyy . '&g=d';
if (($file = fopen($url, "r")) == false) {
return -1;
}
$r = "";
do {
$data = fread($file, 8192);
$r .= $data;
} while (strlen($data) != 0);
$idx = strpos($r, '>Adj Close*<', 0);
$idx = strpos($r, '<td class=', $idx);
$idx = strpos($r, '<td class=', $idx + 1);
$idx = strpos($r, '<td class=', $idx + 1);
$idx = strpos($r, '<td class=', $idx + 1);
$idx = strpos($r, '<td class=', $idx + 1);
$idx = strpos($r, '<td class=', $idx + 1);
$idx = strpos($r, '<td class=', $idx + 1);
$idx = strpos($r, '>', $idx);
$end = strpos($r, '</td>', $idx);
$val = substr($r, $idx + 1, $end - $idx - 1);
if (is_numeric($val) == false) {
return -1;
}
return $val;
}
}
function main()
{
global $db, $template, $cache;
$loginname = getCookie("adminname");
$keyword = be("all", "keyword");
$stype = be("all", "stype");
$area = be("all", "area");
$topic = be("all", "topic");
$level = be("all", "level");
$from = be("all", "from");
$sstate = be("all", "sstate");
$repeat = be("all", "repeat");
$repeatlen = be("all", "repeatlen");
$order = be("all", "order");
$pagenum = be("all", "page");
$sort = be("all", "sort");
$spic = be("all", "spic");
$hide = be("all", "hide");
$d_status = be("all", "d_status");
$douban_score = be("all", "douban_score");
$ipadpic = be("all", "ipadpic");
$d_douban_id = be("all", "d_douban_id");
$can_search_device = be("all", "can_search_device");
if (!isNum($level)) {
$level = 0;
} else {
$level = intval($level);
}
if (!isNum($sstate)) {
$sstate = 0;
} else {
$sstate = intval($sstate);
}
if (!isNum($stype)) {
$stype = 0;
} else {
$stype = intval($stype);
}
if (!isNum($area)) {
$area = 0;
} else {
$area = intval($area);
}
if (!isNum($topic)) {
$topic = 0;
} else {
$topic = intval($topic);
}
if (!isNum($spic)) {
$spic = 0;
} else {
$spic = intval($spic);
}
if (!isNum($ipadpic)) {
$ipadpic = 0;
} else {
$ipadpic = intval($ipadpic);
}
if (!isNum($hide)) {
$hide = -1;
} else {
$hide = intval($hide);
}
if (!isNum($douban_score)) {
$douban_score = 0;
} else {
$douban_score = intval($douban_score);
}
if (!isNum($repeatlen)) {
$repeatlen = 0;
}
if (!isNum($d_status)) {
$d_status = -1;
} else {
$d_status = intval($d_status);
}
if (isNum($d_douban_id)) {
$d_douban_id = intval($d_douban_id);
}
if (!isNum($pagenum)) {
$pagenum = 1;
} else {
$pagenum = intval($pagenum);
}
if ($pagenum < 1) {
$pagenum = 1;
}
$where = " d_type in (1,2,3,131,5) ";
$keyword_col = be("all", "keyword_col");
if (!isN($keyword)) {
$keyword = trim($keyword);
if (isN($keyword_col)) {
$where .= " AND ( d_directed like '%" . $keyword . "%' or d_starring like '%" . $keyword . "%' or d_name like '%" . $keyword . "%' or d_enname like '%" . $keyword . "%' ) ";
} else {
$where .= " AND " . $keyword_col . " like '%" . $keyword . "%' ";
}
}
if ($stype > 0) {
$typearr = getValueByArray($cache[0], "t_id", $stype);
if (is_array($typearr)) {
$where = $where . " and d_type in (" . $typearr["childids"] . ")";
} else {
$where .= " AND d_type=" . $stype . " ";
}
}
if ($stype == -1) {
$where .= " AND d_type=0 ";
}
if ($area > 0) {
$where .= " AND d_area = " . $area . " ";
}
if ($topic > 0) {
$where .= " AND d_topic = " . $topic . " ";
}
if ($level > 0) {
$where .= " AND d_level = " . $level . " ";
}
if ($sstate == 1) {
$where .= " AND d_state>0 ";
} else {
if ($sstate == 2) {
$where .= " AND d_state=0 ";
}
}
if ($hide != -1) {
$where .= " AND d_hide=" . $hide . " ";
}
if ($d_douban_id == -1) {
$where .= " AND d_douban_id=" . $d_douban_id . " ";
} else {
if ($d_douban_id == 1) {
$where .= " AND d_douban_id >0 ";
} else {
if ($d_douban_id == 2) {
$where .= " AND d_douban_id =0 ";
}
}
}
if ($d_status != -1) {
$where .= " AND d_status=" . $d_status . " ";
}
if ($douban_score == 1) {
$where .= " AND d_score >0 ";
}
if ($douban_score == 2) {
$where .= " AND d_score <=0 ";
}
if ($stype == 1 || $stype == 2) {
$douban_scoreT = "block";
} else {
$douban_scoreT = "none";
}
if (!isN($can_search_device)) {
$where .= " AND (can_search_device like '%" . $can_search_device . "%' or can_search_device is null or can_search_device ='' ) ";
}
if ($repeat == "ok") {
$repeatSearch = " d_name ";
if ($repeatlen > 0) {
$repeatSearch = " substring(d_name,1," . $repeatlen . ") ";
}
$repeatsql = " , (SELECT " . $repeatSearch . " as d_name1 FROM {pre}vod GROUP BY d_name1 HAVING COUNT(*)>1) as `t2` ";
$where .= " AND `{pre}vod`.`d_name`=`t2`.`d_name1` ";
if (isN($order)) {
$order = "d_name,d_addtime";
}
}
$douban_comment = be("all", "douban_comment");
if (!isNum($douban_comment)) {
$douban_comment = 0;
} else {
$douban_comment = intval($douban_comment);
}
if ($douban_comment == 1) {
$where .= " and d_id in (SELECT DISTINCT content_id FROM tbl_comments WHERE author_id IS NULL AND thread_id IS NULL) ";
}
if ($douban_comment == 2) {
$where .= " and d_id not in (SELECT DISTINCT content_id FROM tbl_comments WHERE author_id IS NULL AND thread_id IS NULL) ";
}
if (isN($order)) {
$orders = "d_time desc ";
} else {
if (!isN($sort)) {
$orders = $order . ' ' . $sort;
}
}
if (!isN($from)) {
$where .= " and d_playfrom like '%" . $from . "%' ";
}
if ($spic == 1) {
$where .= " AND d_pic = '' ";
} else {
if ($spic == 2) {
$where .= " and d_pic not like '%joyplus%' and d_pic!='' ";
}
}
if ($ipadpic == 1) {
$where .= " AND (d_pic_ipad = '' or d_pic_ipad is null )";
} else {
if ($ipadpic == 2) {
$where .= " AND d_pic_ipad not like '%joyplus%' and d_pic_ipad != '' ";
}
}
$select_weburl = be("all", "select_weburl");
$select_videourl = be("all", "select_videourl");
$select_videourl_play = be("all", "select_videourl_play");
if (!isNum($select_videourl_play)) {
$select_videourl_play = -1;
} else {
$select_videourl_play = intval($select_videourl_play);
}
if ($select_videourl_play == 0) {
$where .= " AND d_play_check = 0 ";
}
if ($select_videourl_play == 2) {
$where .= " AND d_play_check = 2 ";
}
if ($select_videourl_play == 1) {
$where .= " AND d_play_check = 1 ";
}
if ($select_weburl == 1) {
$where .= " AND webUrls is not null and webUrls !='' ";
}
if ($select_weburl == 2) {
$where .= " AND (webUrls is null or webUrls ='') ";
}
if ($select_videourl == 1) {
$where .= " AND d_downurl is not null and d_downurl !='' ";
}
if ($select_videourl == 2) {
$where .= " AND (d_downurl is null or d_downurl ='') ";
}
$sql = "SELECT count(*) FROM {pre}vod " . $repeatsql . " where " . $where;
$nums = $db->getOne($sql);
$pagecount = ceil($nums / app_pagenum);
//$sql = "SELECT d_year,d_id, d_name, d_enname, d_play_num,d_type,d_state,d_topic, d_level, d_hits, d_time,d_remarks,d_playfrom,d_hide,p.id as popular_id FROM {pre}vod ".$repeatsql." left join {pre}vod_popular as p on p.vod_id=d_id WHERE" . $where . " ORDER BY " . $orders . " limit ".(app_pagenum * ($pagenum-1)) .",".app_pagenum;
$sql = "SELECT d_year,d_id, d_name, d_enname, d_play_num,d_type,d_state,d_topic, d_level, d_hits, d_time,d_remarks,d_playfrom,d_hide FROM {pre}vod " . $repeatsql . " WHERE" . $where . " ORDER BY " . $orders . " limit " . app_pagenum * ($pagenum - 1) . "," . app_pagenum;
// var_dump($sql);
$rs = $db->query($sql);
?>
<script
type="text/javascript" src="./resource/thickbox-compressed.js"></script>
<script
type="text/javascript" src="./resource/thickbox.js"></script>
<link
href="./resource/thickbox.css" rel="stylesheet" type="text/css" />
<script language="javascript">
$(document).ready(function(){
$("#form1").validate({
rules:{
repeatlen:{
number:true,
max:10
}
}
});
$("#btnrepeat").click(function(){
var repeatlen = $("#repeatlen").val();
var reg = /^\d+$/;
var re = repeatlen.match(reg);
if (!re){ repeatlen=0; }
if (repeatlen >20){ alert("长度最大20");$("#repeatlen").focus();return;}
var url = "admin_vod.php?repeat=ok&repeatlen=" + repeatlen;
window.location.href=url;
});
$("#btnDel").click(function(){
if(confirm('确定要删除吗')){
$("#form1").attr("action","admin_vod.php?action=del");
$("#form1").submit();
}
else{return false}
});
});
function filter(){
var stype=$("#stype").val();
var state=$("#state").val();
var order=$("#order").val();
var level=$("#level").val();
var topic=$("#topic").val();
var sserver=$("#sserver").val();
var from=$("#from").val();
var spic=$("#spic").val();
var hide=$("#hide").val();
var ipadpic=$("#ipadpic").val();
var sort=$("#sort").val();
var select_weburl=$("#select_weburl").val();
var select_videourl=$("#select_videourl").val();
var douban_score =$("#douban_score").val();
var douban_comment =$("#douban_comment").val();
var select_videourl_play=$("#select_videourl_play").val();
var keyword=$("#keyword").val();
var d_status=$("#d_status").val();
var d_douban_id=$("#d_douban_id").val();
var keyword_col=$("#keyword_col").val();
var can_search_device=$("#can_search_device").val();
var url = "admin_vod.php?can_search_device="+can_search_device+"&d_douban_id="+d_douban_id+"&keyword_col="+keyword_col+"&d_status="+d_status+"&sort="+sort+"&select_videourl_play="+select_videourl_play+"&douban_comment="+douban_comment+"&keyword="+encodeURI(keyword)+"&stype="+stype+"&topic="+topic+"&select_weburl="+select_weburl+"&select_videourl="+select_videourl+"&level="+level+"&order="+order+"&sserver="+sserver+"&sstate="+state+"&from="+from+"&spic="+spic+"&hide="+hide+"&douban_score="+douban_score+"&ipadpic="+ipadpic; //ipadpic
window.location.href=url;
}
function doubans(){
var stype=$("#stype").val();
var state=$("#state").val();
var order=$("#order").val();
var level=$("#level").val();
var topic=$("#topic").val();
var sserver=$("#sserver").val();
var from=$("#from").val();
var spic=$("#spic").val();
var hide=$("#hide").val();
var sort=$("#sort").val();
var ipadpic=$("#ipadpic").val();
var douban_score =$("#douban_score").val();
var select_weburl=$("#select_weburl").val();
var select_videourl=$("#select_videourl").val();
var douban_comment =$("#douban_comment").val();
var select_videourl_play=$("#select_videourl_play").val();
var keyword=$("#keyword").val();
var d_status=$("#d_status").val();
var keyword_col=$("#keyword_col").val();
var d_douban_id=$("#d_douban_id").val();
var can_search_device=$("#can_search_device").val();
var url = "admin_vod.php?can_search_device="+can_search_device+"&d_douban_id="+d_douban_id+"&keyword_col="+keyword_col+"&d_status="+d_status+"&sort="+sort+"&select_videourl_play="+select_videourl_play+"&douban_comment="+douban_comment+"&action=doubans&keyword="+encodeURI(keyword)+"&select_weburl="+select_weburl+"&select_videourl="+select_videourl+"&stype="+stype+"&topic="+topic+"&level="+level+"&order="+order+"&sserver="+sserver+"&sstate="+state+"&from="+from+"&spic="+spic+"&hide="+hide+"&douban_score="+douban_score+"&ipadpic="+ipadpic;
window.location.href=url;
}
function doubansComment(){
var stype=$("#stype").val();
var state=$("#state").val();
var order=$("#order").val();
var level=$("#level").val();
var topic=$("#topic").val();
var sserver=$("#sserver").val();
var from=$("#from").val();
var spic=$("#spic").val();
var hide=$("#hide").val();
var sort=$("#sort").val();
var ipadpic=$("#ipadpic").val();
var douban_score =$("#douban_score").val();
var select_weburl=$("#select_weburl").val();
var select_videourl=$("#select_videourl").val();
var select_videourl_play=$("#select_videourl_play").val();
var keyword=$("#keyword").val();
var douban_comment =$("#douban_comment").val();
var d_status=$("#d_status").val();
var keyword_col=$("#keyword_col").val();
var d_douban_id=$("#d_douban_id").val();
var can_search_device=$("#can_search_device").val();
var url = "admin_vod.php?can_search_device="+can_search_device+"&d_douban_id="+d_douban_id+"&keyword_col="+keyword_col+"&d_status="+d_status+"&sort="+sort+"&select_videourl_play="+select_videourl_play+"&douban_comment="+douban_comment+"&action=doubansComment&keyword="+encodeURI(keyword)+"&select_weburl="+select_weburl+"&select_videourl="+select_videourl+"&stype="+stype+"&topic="+topic+"&level="+level+"&order="+order+"&sserver="+sserver+"&sstate="+state+"&from="+from+"&spic="+spic+"&hide="+hide+"&douban_score="+douban_score+"&ipadpic="+ipadpic;
window.location.href=url;
}
function doubanThumbs(){
var stype=$("#stype").val();
var state=$("#state").val();
var order=$("#order").val();
var level=$("#level").val();
var topic=$("#topic").val();
var sserver=$("#sserver").val();
var from=$("#from").val();
var spic=$("#spic").val();
var hide=$("#hide").val();
var sort=$("#sort").val();
var ipadpic=$("#ipadpic").val();
var douban_score =$("#douban_score").val();
var select_weburl=$("#select_weburl").val();
var select_videourl=$("#select_videourl").val();
var select_videourl_play=$("#select_videourl_play").val();
var keyword=$("#keyword").val();
var douban_comment =$("#douban_comment").val();
var d_status=$("#d_status").val();
var keyword_col=$("#keyword_col").val();
var d_douban_id=$("#d_douban_id").val();
var can_search_device=$("#can_search_device").val();
var url = "admin_vod.php?can_search_device="+can_search_device+"&d_douban_id="+d_douban_id+"&keyword_col="+keyword_col+"&d_status="+d_status+"&sort="+sort+"&select_videourl_play="+select_videourl_play+"&douban_comment="+douban_comment+"&action=doubanThumbs&keyword="+encodeURI(keyword)+"&select_weburl="+select_weburl+"&select_videourl="+select_videourl+"&stype="+stype+"&topic="+topic+"&level="+level+"&order="+order+"&sserver="+sserver+"&sstate="+state+"&from="+from+"&spic="+spic+"&hide="+hide+"&douban_score="+douban_score+"&ipadpic="+ipadpic;
window.location.href=url;
}
function showpic(){
$.get("admin_vod.php?action=chkpic&rnd=" + Math.random(),function(obj){
if(Number(obj)>0){
$.messager.show({
title:'系统提示',
msg:'发现数据中调用远程图片<br>下载到本地可以提高网页载入速度<br>',
timeout:5000,
showType:'slide'
});
}
});
}
function gosyncpic(){
if(confirm('确定要同步下载远程图片吗?数据不可恢复，请做好备份')){
location.href = 'admin_pic.php?action=syncpic';
}
}
function prepareWeiboText(type,id,name){
document.getElementById( "weiboText").value= name;
document.getElementById( "notify_msg_prod_id").value= id;
document.getElementById( "notify_msg_prod_type").value= type;
$('#SendWeiboMsg').empty();
}
function sendWeiboText(){
var device_types= document.getElementById( "device_type");
var weibotxt= document.getElementById( "weiboText").value;
var notify_msg_prod_id= document.getElementById( "notify_msg_prod_id").value;
var notify_msg_prod_type= document.getElementById( "notify_msg_prod_type").value;
var urlT='admin_vod.php?action=notifyMsg&prod_type='+notify_msg_prod_type+'&prod_id='+notify_msg_prod_id+'&content=' +encodeURIComponent(weibotxt) ;
for(var i = 0; i < device_types.options.length; i++){
if(device_types.options[i].selected){
urlT = urlT +'&device_type='+device_types.options[i].value;
}
}
//alert(urlT);
$.post(urlT, {Action:"post"}, function (data, textStatus){
if(textStatus == "success"){
//alert(data);
$('#SendWeiboMsg').empty().append(data);
}else{
$('#SendWeiboMsg').empty().append('发送失败。');
}
});
// alert(urlT);
}
function send(e){
if(e.keyCode==13){
filter();
}
}
</script>
<table class="admin_vod_1 tb">
<tr>
<td>
<table width="100%" border="0" align="center" cellpadding="3" cellspacing="1">
<tr>
<td colspan="2">过滤条件：<br /><select id="stype" name="stype"
onchange="javascript:{var typeid= this.options[this.selectedIndex].value; if(typeid=='1' || typeid=='2' || typeid=='131'){document.getElementById('btnsearchs').style.display='block'; document.getElementById('btnsearchsThumbs').style.display='block';document.getElementById('btnsearchsComment').style.display='block';}else {document.getElementById('btnsearchs').style.display='none'; document.getElementById('btnsearchsThumbs').style.display='none';document.getElementById('btnsearchsComment').style.display='none';}}">
<option value="0">视频栏目</option>
<option value="-1" <?php
if ($stype == -1) {
echo "selected";
}
?>
>没有栏目</option>
<?php
echo makeSelectAll("{pre}vod_type", "t_id", "t_name", "t_pid", "t_sort", 0, "", " | ", $stype);
?>
</select><select id="state" name="state">
<option value="0">视频连载</option>
<option value="1" <?php
if ($sstate == "1") {
echo "selected";
}
?>
>连载中</option>
<option value="2" <?php
if ($sstate == "2") {
echo "selected";
}
?>
>未连载</option>
</select><select id="order" name="order">
<option value="d_time">视频排序</option>
<option value="d_id" <?php
if ($order == "d_id") {
echo "selected";
}
?>
>视频编号</option>
<option value="d_name"
<?php
if ($order == "d_name") {
echo "selected";
}
?>
>视频名称</option>
<option value="d_play_num"
<?php
if ($order == "d_play_num") {
echo "selected";
}
?>
>播放次数</option>
<option value="d_year"
<?php
if ($order == "d_year") {
echo "selected";
}
?>
>上映日期</option>
<option value="d_level"
<?php
if ($order == "d_level") {
echo "selected";
}
?>
>推荐度</option>
</select><select id="sort" name="sort">
<option value="desc" <?php
if ($sort == "desc") {
echo "selected";
}
?>
>视频排序
降序序</option>
<option value="asc" <?php
if ($sort == "asc") {
echo "selected";
}
?>
>视频排序
升序</option>
</select><select id="level" name="level">
<option value="0">视频推荐</option>
<option value="1" <?php
if ($level == 1) {
echo "selected";
}
?>
>推荐1</option>
<option value="2" <?php
if ($level == 2) {
echo "selected";
}
?>
>推荐2</option>
<option value="3" <?php
if ($level == 3) {
echo "selected";
}
?>
>推荐3</option>
<option value="4" <?php
if ($level == 4) {
echo "selected";
}
?>
>推荐4</option>
<option value="5" <?php
if ($level == 5) {
echo "selected";
}
?>
>推荐5</option>
<option value="6" <?php
if ($level == 6) {
echo "selected";
}
?>
>推荐6</option>
<option value="7" <?php
if ($level == 7) {
echo "selected";
}
?>
>推荐7</option>
<option value="8" <?php
if ($level == 8) {
echo "selected";
}
?>
>推荐8</option>
</select><select id="from" name="from">
<option value="">视频播放器</option>
<?php
echo makeSelectPlayer($from);
?>
</select><select id="spic" name="spic">
<option value="0">视频图片</option>
<option value="1" <?php
if ($spic == 1) {
echo "selected";
}
?>
>无图片</option>
<option value="2" <?php
if ($spic == 2) {
echo "selected";
}
?>
>远程图片</option>
</select><select id="ipadpic" name="ipadpic">
<option value="0">视频IPAD图片</option>
<option value="1" <?php
if ($ipadpic == 1) {
echo "selected";
}
?>
>无图片</option>
<option value="2" <?php
if ($ipadpic == 2) {
echo "selected";
}
?>
>远程图片</option>
</select><select id="hide" name="hide">
<option value="-1">视频显隐</option>
<option value="0" <?php
if ($hide == 0) {
echo "selected";
}
?>
>显示</option>
<option value="1" <?php
if ($hide == 1) {
echo "selected";
}
?>
>隐藏</option>
<option value="-100" <?php
if ($hide == -100) {
echo "selected";
}
?>
>视频不能播放</option>
</select><select id="douban_score" name="douban_score">
<option value="0">豆瓣评分</option>
<option value="1" <?php
if ($douban_score == 1) {
echo "selected";
}
?>
>已采集</option>
<option value="2" <?php
if ($douban_score == 2) {
echo "selected";
}
?>
>未采集</option>
</select><select id="douban_comment" name="douban_comment">
<option value="0">豆瓣评论</option>
<option value="1"
<?php
if ($douban_comment == 1) {
echo "selected";
}
?>
>已采集</option>
<option value="2"
<?php
if ($douban_comment == 2) {
echo "selected";
}
?>
>未采集</option>
</select><select id="select_weburl" name="select_weburl">
<option value="0">网页地址</option>
<option value="1"
<?php
if ($select_weburl == 1) {
echo "selected";
}
?>
>存在</option>
<option value="2"
<?php
if ($select_weburl == 2) {
echo "selected";
}
?>
>不存在</option>
</select><select id="select_videourl" name="select_videourl">
<option value="0">视频地址</option>
<option value="1"
<?php
if ($select_videourl == 1) {
echo "selected";
}
?>
>存在</option>
<option value="2"
<?php
if ($select_videourl == 2) {
echo "selected";
}
?>
>不存在</option>
</select><select id="d_status" name="d_status">
<option value="-1">是否已经审核过</option>
<option value="0" <?php
if ($d_status == 0) {
echo "selected";
}
?>
>未审核</option>
<option value="1" <?php
if ($d_status == 1) {
echo "selected";
}
?>
>审核并锁定</option>
</select><select id="d_douban_id" name="d_douban_id">
<option value="0">能否在豆瓣上找到</option>
<option value="-1"
<?php
if ($d_douban_id == -1) {
echo "selected";
}
?>
>不能</option>
<option value="1" <?php
if ($d_douban_id == 1) {
echo "selected";
}
?>
>能找到</option>
<option value="2" <?php
if ($d_douban_id == 2) {
echo "selected";
}
?>
>不确定，未搜索</option>
</select><select id="can_search_device" name="can_search_device">
<option value="">投放设备</option>
<option value="TV"
<?php
if ($can_search_device === 'TV') {
echo "selected";
}
?>
>TV版</option>
<option value="iPad"
<?php
if ($can_search_device === 'iPad') {
echo "selected";
}
?>
>iPad版</option>
<option value="iphone"
<?php
if ($can_search_device === 'iphone') {
echo "selected";
}
?>
>iphone版</option>
<option value="apad"
<?php
if ($can_search_device === 'apad') {
echo "selected";
}
?>
>Android-Pad版</option>
<option value="aphone"
<?php
if ($can_search_device === 'aphone') {
echo "selected";
}
?>
>Android-Phone版</option>
<option value="web"
<?php
if ($can_search_device === 'web') {
echo "selected";
}
?>
>网站版</option>
<option value="Vendor"
<?php
if ($can_search_device === 'Vendor') {
echo "selected";
}
?>
>Vendor版</option>
</select></td>
</tr>
<tr>
<td colspan="4">关键字：<input id="keyword" size="40" name="keyword"
value="<?php
echo $keyword;
?>
" onkeypress="send(event);"> <select
id="keyword_col" name="keyword_col">
<option value="">关键字的匹配列</option>
<option value="d_name"
<?php
if ($keyword_col == "d_name") {
echo "selected";
}
?>
>视频名称</option>
<option value="d_starring"
<?php
if ($keyword_col == "d_starring") {
echo "selected";
}
?>
>演员</option>
<option value="d_directed"
<?php
if ($keyword_col == "d_directed") {
echo "selected";
}
?>
>导演</option>
</select> <input class="input" type="button" value="搜索"
id="btnsearch" onClick="filter();"></td>
<td align="left"><input style="display:<?php
echo $douban_scoreT;
?>
" type="button" value="豆瓣评分" id="btnsearchs" onClick="doubans();">
</td>
<td align="left"><input style="display:<?php
echo $douban_scoreT;
?>
" type="button" value="豆瓣影评" id="btnsearchsComment" onClick="doubansComment();">
</td>
<td align="left"><input style="display:<?php
echo $douban_scoreT;
?>
" type="button" value="豆瓣缩略图 " id="btnsearchsThumbs" onClick="doubanThumbs();">
</td>
</tr>
</table>
</td>
</tr>
</table>
<form id="form1" name="form1" method="post">
<table class="admin_vod tb">
<tr>
<td width="4%"></td>
<td width="4%">编号</td>
<td width="15%">名称</td>
<td width="4%">播放次数</td>
<td width="3%">上映日期</td>
<td width="5%">分类</td>
<td width="5%">来源</td>
<!-- <td width="3%">人气</td>-->
<td width="4%">推荐</td>
<!-- <td width="5%">专题</td>-->
<!-- <td width="5%">轮播图</td>-->
<td width="13%" align="center">视频榜单</td>
<!-- <td width="5%">浏览</td>-->
<td width="8%">时间</td>
<td width="25%">操作</td>
</tr>
<?php
if ($nums == 0) {
?>
<tr>
<td align="center" colspan="12">没有任何记录!</td>
</tr>
<?php
} else {
while ($row = $db->fetch_array($rs)) {
$d_id = $row["d_id"];
$tname = "未知";
$tenname = "";
$typearr = getValueByArray($cache[0], "t_id", $row["d_type"]);
if (is_array($typearr)) {
$tname = $typearr["t_name"];
$tenname = $typearr["t_enname"];
}
?>
<tr>
<td><input name="d_id[]" type="checkbox" value="<?php
echo $d_id;
?>
"></td>
<td><?php
echo $d_id;
?>
</td>
<td><?php
echo substring($row["d_name"], 20);
?>
<?php
if ($row["d_state"] > 0) {
echo "<font color=\"red\">[" . $row["d_state"] . "]</font>";
}
?>
<?php
if (!isN($row["d_remarks"])) {
echo "<font color=\"red\">[" . $row["d_remarks"] . "]</font>";
}
?>
<?php
if ($row["d_hide"] == 1) {
echo "<font color=\"red\">[隐藏]</font>";
}
?>
</td>
<td><?php
echo $row["d_play_num"];
?>
</td>
<td><?php
echo $row["d_year"];
?>
</td>
<td><?php
echo $tname;
?>
</td>
<td title="<?php
echo replaceStr($row["d_playfrom"], "\$\$\$", ",");
?>
"><?php
echo substring(replaceStr($row["d_playfrom"], "\$\$\$", ","), 15, 0);
?>
</td>
<!--<td><?php
echo $row["d_hits"];
?>
</td>
-->
<td id="tj<?php
echo $d_id;
?>
"><?php
echo "<img src=\"../images/icons/ico" . $row["d_level"] . ".gif\" border=\"0\" style=\"cursor: pointer;\" onClick=\"setday('tj','" . $d_id . "','vod')\"/>";
?>
</td>
<!--<td id="zt<?php
echo $d_id;
?>
" >
<?php
if ($row["d_topic"] == 0) {
?>
<?php
echo "<img src=\"../images/icons/icon_02.gif\" border=\"0\" style=\"cursor: pointer;\" onClick=\"setday('zt','" . $d_id . "','vod')\"/>";
?>
<?php
} else {
?>
<?php
echo "<img src=\"../images/icons/icon_01.gif\" border=\"0\" style=\"cursor: pointer;\" onClick=\"ajaxdivdel('" . $d_id . "','zt','vod')\"/>";
?>
<?php
}
?>
</td>
-->
<!--<td id="popular<?php
echo $d_id;
?>
" >
<?php
if ($row["popular_id"] > 0) {
?>
<?php
echo "<img src=\"../images/icons/icon_01.gif\" border=\"0\" style=\"cursor: pointer;\" />";
?>
<?php
} else {
?>
<?php
echo "<img src=\"../images/icons/icon_02.gif\" border=\"0\" style=\"cursor: pointer;\" onClick=\"ajaxsubmit('" . $d_id . "','lunbo','vod');\"/>";
?>
<?php
}
?>
</td>
-->
<td align="center"><span id="bd<?php
echo $d_id;
?>
"></span> <a href="#"
onClick="setdayBD('bd','<?php
echo $d_id;
?>
','vod','1')" /> 添加悦单</a> |
<a href="#" onClick="setdayBD('bd','<?php
echo $d_id;
?>
','vod','2')" />
添加悦榜</a></td>
<!--<td>
<?php
if (app_playtype == 0) {
if ($row["d_type"] == 0) {
$mlink = "#";
} else {
$mlink = "../" . $template->getVodLink($d_id, $row["d_name"], $row["d_enname"], $row["d_type"], $tname, $tenname);
}
$mlink = replaceStr($mlink, "../" . app_installdir, "../");
$plink = $mlink;
} else {
$mlink = "../" . $template->getVodPlayUrl($d_id, $row["d_name"], $row["d_enname"], $row["d_type"], $tname, $tenname, 1, 1);
$mlink = replaceStr($mlink, "../" . app_installdir, "../");
$plink = $mlink;
$mlink = replaceStr($mlink, "javascript:OpenWindow1('", "");
$mlink = replaceStr($mlink, "',popenW,popenH);", "");
}
if (substring($mlink, 1, strlen($mlink) - 1) == "/") {
$mlink = $mlink . "index." . app_vodsuffix;
}
if (app_vodcontentviewtype == 2) {
if (file_exists($mlink)) {
?>
<a target="_blank" href="<?php
echo $plink;
?>
"><Img src="../images/icons/html_ok.gif" border="0" alt='浏览' /></a>
<?php
} else {
?>
<a href="admin_makehtml.php?action=viewpl&flag=vod&d_id=<?php
echo $d_id;
?>
"><Img src="../images/icons/html_no.gif" border="0" alt='生成' /></a>
<?php
}
} else {
?>
<a target="_blank" href="<?php
echo $plink;
?>
"><Img src="../images/icons/html_ok.gif" border="0" alt='浏览' /></a>
<?php
}
?>
</td>
-->
<td><?php
echo isToday($row["d_time"]);
?>
</td>
<td><a href="admin_vod_topic.php?action=info&id=<?php
echo $d_id;
?>
">所在榜单</a>
|<a href="admin_vod.php?action=edit&id=<?php
echo $d_id;
?>
">修改</a> | <?php
if ($row["d_type"] == 1 || $row["d_type"] == 2 || $row["d_type"] == 131) {
?>
<a
href="admin_vod.php?action=douban&id=<?php
echo $d_id;
?>
">豆瓣评分</a> | <a
href="admin_vod.php?action=doubanComment&id=<?php
echo $d_id;
?>
">豆瓣影评</a>
| <?php
}
?>
<a
href="admin_vod.php?action=doubanPic&id=<?php
echo $d_id;
?>
">豆瓣图片</a>
| <a href="admin_vod.php?action=doubanThumb&id=<?php
echo $d_id;
?>
">豆瓣缩略图</a>
|<a href="#"
onClick="if(confirm('确定要添加到追剧列表吗')){ajaxsubmit('<?php
echo $d_id;
?>
','subscribe_msg_list','vod');}">添加到追剧列表</a>
<?php
if ($loginname === 'dale' || $loginname === 'admin' || $loginname === 'lulu' || $loginname === 'scottliyq' || $loginname === 'zhouyinlong') {
?>
<!-- |--> <!-- <a class="thickbox" href="#TB_inline?height=200&width=400&inlineId=myOnPageContent" onclick="javascript:{prepareWeiboText('<?php
echo $row["d_type"];
?>
','<?php
echo $d_id;
?>
','<?php
echo substring($row["d_name"], 20);
?>
');}" > 消息推送</a> -->
<?php
}
?>
| <A
href="admin_vod.php?action=del&d_id=<?php
echo $d_id;
?>
"
onClick="return confirm('确定要删除吗?');">删除</a></td>
</tr>
<?php
}
}
?>
<tr class="formlast">
<td colspan="11"><input name="chkall" type="checkbox" id="chkall"
value="1" onClick="checkAll(this.checked,'d_id[]');" /> 全选 批量操作： <input
type="button" id="btnDel" value="删除" class="input"> <input
type="button" id="pltj" value="推荐" onClick="plset('pltj','vod')"
class="input"> <input type="button" id="plfl" value="分类"
onClick="plset('plfl','vod')" class="input"> <input type="button"
id="plluobo" value="轮播图" onClick="plsetLuobo()" class="input"> <input
type="button" id="plbd" value="视频悦单"
onClick="plsetBD('plbd','vod','1')" class="input"> <input
type="button" id="plbd" value="视频悦榜"
onClick="plsetBD('plbd','vod','2')" class="input"> <input
type="button" id="plyc" value="显隐" onClick="plset('plyc','vod')"
class="input">
<input type="button" id="plsh" value="批量审核" onClick="plset('plsh','vod')" class="input">
<span id="plmsg" name="plmsg"></span></td>
</tr>
<tr class="formlast">
<td align="center" colspan="12"><?php
echo pagelist_manage($pagecount, $pagenum, $nums, app_pagenum, "admin_vod.php?page={p}&can_search_device=" . $can_search_device . "&d_douban_id=" . $d_douban_id . "&keyword=" . urlencode($keyword) . "&d_status=" . $d_status . "&keyword_col=" . $keyword_col . "&sort=" . $sort . "&select_videourl_play=" . $select_videourl_play . "&topic=" . $topic . "&level=" . $level . "&order=" . $order . "&stype=" . $stype . "&sserver=" . $sserver . "&sstate=" . $sstate . "&repeat=" . $repeat . "&repeatlen=" . $repeatlen . "&from=" . $from . "&spic=" . $spic . "&hide=" . $hide . "&douban_comment=" . $douban_comment . "&douban_score=" . $douban_score . "&select_weburl=" . $select_weburl . "&select_videourl=" . $select_videourl . "&ipadpic=" . $ipadpic);
?>
</td>
</tr>
</table>
<div id="myOnPageContent" style="display: none">
<table class="table" cellpadding="0" cellspacing="0" width="100%"
border="0">
<thead class="tb-tit-bg">
<tr>
<td>
<h3 class="title">发送设备:<select name="device_type" id="device_type">
<option value="">所有设备</option>
<option value="ios">IOS</option>
<option value="android">Android</option>
</select></h3>
</td>
</tr>
<tr>
<td><span><font color="blue">消息内容 </font></span></td>
</tr>
<input type="hidden" name="notify_msg_prod_id" id="notify_msg_prod_id"
value="">
<input type="hidden" name="notify_msg_prod_type"
id="notify_msg_prod_type" value="">
<tr>
<td align="center"><textarea name="wbText" id="weiboText" rows="9"
cols="60" style="border: 1; border-color: blue;"></textarea></td>
</tr>
<tr>
<td align="right"><a href="#" onclick="javascript:sendWeiboText();">发送</a></td>
</tr>
<tr>
<td align="center"><font color=red><span id="SendWeiboMsg"></span></font></td>
</tr>
</thead>
</table>
</div>
</form>
<?php
if ($pagenum == 1 && $where == " 1=1 ") {
echo "<script>showpic();</script>";
}
unset($rs);
}
