1、在文章或图片模型增加新字段：
字段类型：万能字段
字段名：relation_download
字段别名： 相关下载
相关参数：
<input type='hidden' name='info[relation_download]' id='relation_download' value='{FIELD_VALUE}' style='50' >
<ul class="list-dot" id="relation_download_text"></ul>
<div>
<input type='button' value="添加相关" onclick="omnipotent('selectid','?m=content&c=content&a=public_relationdownlist&modelid=2','添加相关下载',1)" class="button" style="width:66px;">
<span class="edit_content">
<input type='button' value="显示已有" onclick="show_relation_download(3,2,{ID})" class="button" style="width:66px;">
</span>
</div>
2、打开statics/js/content_addtop.js，在function show_relation(modelid,id) {}下面新增以下代码
//移除相关下载
function remove_relationdownload(sid,id) {
var relation_ids = $('#relation_download').val();
if(relation_ids !='' ) {
$('#'+sid).remove();
var r_arr = relation_ids.split('|');
var newrelation_ids = '';
$.each(r_arr, function(i, n){
if(n!=id) {
if(i==0) {
newrelation_ids = n;
} else {
newrelation_ids = newrelation_ids+'|'+n;
}
}
});
$('#relation_download').val(newrelation_ids);
}
}
//显示相关下载
function show_relation_download(modelid,target_modelid,id) {
//$.getJSON("?m=content&c=content&a=public_getjson_ids2&modelid="+modelid+"&id="+id, function(json){
$.getJSON("?m=content&c=content&a=public_getjson_ids2&modelid="+modelid+"&target_modelid="+target_modelid+"&id="+id, function(json){
var newrelation_ids2 = '';
if(json==null) {
alert('没有添加相关下载');
return false;
}
$.each(json, function(i, n){
newrelation_ids2 += "<li id='"+n.sid+"'>·<span>"+n.title+"</span><a href='javascript:;' class='close' onclick=\"remove_relationdownload('"+n.sid+"',"+n.id+")\"></a></li>";
});
$('#relation_download_text').html(newrelation_ids2);
});
}3、打开phpcms/modules/content/content.php，在public function public_getjson_ids() {}下面增加以下代码
/**
* 相关下载选择
*/
public function public_relationdownlist() {
pc_base::load_sys_class('format','',0);
$show_header = '';
$model_cache = getcache('model','commons');
if(!isset($_GET['modelid'])) {
showmessage(L('please_select_modelid'));
} else {
$page = intval($_GET['page']);
$modelid = intval($_GET['modelid']);
$this->db->set_model($modelid);
$where = '';
if($_GET['catid']) {
$catid = intval($_GET['catid']);
$where .= "catid='$catid'";
}
$where .= $where ? ' AND status=99' : 'status=99';
if(isset($_GET['keywords'])) {
$keywords = trim($_GET['keywords']);
$field = $_GET['field'];
if(in_array($field, array('id','title','keywords','description'))) {
if($field=='id') {
$where .= " AND `id` ='$keywords'";
} else {
$where .= " AND `$field` like '%$keywords%'";
}
}
}
$infos = $this->db->listinfo($where,'',$page,12);
$pages = $this->db->pages;
include $this->admin_tpl('relationdownlist');
}
}
public function public_getjson_ids2() {
$modelid = intval($_GET['modelid']);
$target_modelid = intval($_GET['target_modelid']);
$id = intval($_GET['id']);
$this->db->set_model($modelid);
$tablename = $this->db->table_name;
$this->db->table_name = $tablename.'_data';
$r = $this->db->get_one(array('id'=>$id),'relation_download');
if($r['relation_download']) {
$relation = str_replace('|', ',', $r['relation_download']);
$relation = trim($relation,',');
$where = "id IN($relation)";
$infos = array();
$this->db->set_model($target_modelid);
$this->model = getcache('model', 'commons');
$this->db->table_name = $this->db->db_tablepre.$this->model[$target_modelid]['tablename'];
$datas = $this->db->select($where,'id,title');
foreach($datas as $_v) {
$_v['sid'] = 'd'.$_v['id'];
if(strtolower(CHARSET)=='gbk') $_v['title'] = iconv('gbk', 'utf-8', $_v['title']);
$infos[] = $_v;
}
echo json_encode($infos);
}
}4、在phpcms/modules/content/templates 文件夹中创建新文件relationdownlist.tpl.php，代码如下
<?php
defined('IN_ADMIN') or exit('No permission resources.');
include $this->admin_tpl('header','admin');
?>
<div class="pad-10">
<form name="searchform" action="" method="get" >
<input type="hidden" value="content" name="m">
<input type="hidden" value="content" name="c">
<input type="hidden" value="public_relationdownlist" name="a">
<input type="hidden" value="<?php echo $modelid;?>" name="modelid">
<table width="100%" cellspacing="0" class="search-form">
<tbody>
<tr>
<td align="center">
<div class="explain-col">
<select name="field">
<option value='title' <?php if($_GET['field']=='title') echo 'selected';?>><?php echo L('title');?></option>
<option value='keywords' <?php if($_GET['field']=='keywords') echo 'selected';?> ><?php echo L('keywords');?></option>
<option value='description' <?php if($_GET['field']=='description') echo 'selected';?>><?php echo L('description');?></option>
<option value='id' <?php if($_GET['field']=='id') echo 'selected';?>>ID</option>
</select>
<?php echo form::select_category('',$catid,'name="catid"',L('please_select_category'),$modelid,0,1);?>
<input name="keywords" type="text" value="<?php echo stripslashes($_GET['keywords'])?>" style="width:330px;" class="input-text" />
<input type="submit" name="dosubmit" class="button" value="<?php echo L('search');?>" />
</div>
</td>
</tr>
</tbody>
</table>
</form>
<div class="table-list">
<table width="100%" cellspacing="0" >
<thead>
<tr>
<th ><?php echo L('title');?></th>
<th width="100"><?php echo L('belong_category');?></th>
<th width="100"><?php echo L('addtime');?></th>
</tr>
</thead>
<tbody>
<?php foreach($infos as $r) { ?>
<tr onclick="select_list(this,'<?php echo safe_replace($r['title']);?>',<?php echo $r['id'];?>)" class="cu" title="<?php echo L('click_to_select');?>">
<td align='left' ><?php echo $r['title'];?></td>
<td align='center'><?php echo $this->categorys[$r['catid']]['catname'];?></td>
<td align='center'><?php echo format::date($r['inputtime']);?></td>
</tr>
<?php }?>
</tbody>
</table>
<div id="pages"><?php echo $pages;?></div>
</div>
</div>
<style type="text/css">
.line_ff9966,.line_ff9966:hover td{
background-color:#FF9966;
}
.line_fbffe4,.line_fbffe4:hover td {
background-color:#fbffe4;
}
</style>
<SCRIPT LANGUAGE="JavaScript">
function select_list(obj,title,id) {
var relation_ids = parent.window.$('#relation_download').val();
var sid = 'd<?php echo $modelid;?>'+id;
if($(obj).attr('class')=='line_ff9966' || $(obj).attr('class')==null) {
$(obj).attr('class','line_fbffe4');
parent.window.$('#'+sid).remove();
if(relation_ids !='' ) {
var r_arr = relation_ids.split('|');
var newrelation_ids = '';
$.each(r_arr, function(i, n){
if(n!=id) {
if(i==0) {
newrelation_ids = n;
} else {
newrelation_ids = newrelation_ids+'|'+n;
}
}
});
parent.window.$('#relation_download').val(newrelation_ids);
}
} else {
$(obj).attr('class','line_ff9966');
var str = "<li id='"+sid+"'>·<span>"+title+"</span><a href='javascript:;' class='close' onclick=\"remove_relationdownload('"+sid+"',"+id+")\"></a></li>";
//window.top.$('#relation_text').append(str);
parent.window.$('#relation_download_text').append(str);
if(relation_ids =='' ) {
parent.window.$('#relation_download').val(id);
} else {
relation_ids = relation_ids+'|'+id;
parent.window.$('#relation_download').val(relation_ids);
}
}
}
</SCRIPT>
</body>
</html>5、更新系统缓存，添加或修改文章或图片
6、前端模板调用代码
{if $relation_download!=''}
{php $rel = explode('|',$relation_download);}
{loop $rel $id}
{pc:get sql="select title,id,url,thumb from v9_download where id=$id"}
{loop $data $r}
<li><a href="{$r['url']}" target="_blank"><span class="refe-img"><img src="{$r[thumb]}" alt="{$r[title]}" /></span><span class="pro-name">{$r[title]}</span></a></li>
{/loop}
{/pc}
{/loop}
{/if}7、前端模板直接下载文件代码
{if $relation_download!=''}
{php $rel = explode('|',$relation_download);}
{loop $rel $id}
{pc:get sql="select * from v9_download as a,v9_download_data as b where a.id=b.id and a.id=$id"}
{loop $data $r}
{php $xiazai = string2array($r['downfiles']);}
{loop $xiazai $b}
<li class="relation_download"><a href="{$b[fileurl]}" target="_blank"><div class="refe-img"><div class="refe-img-thumb" {if $r[thumb]}style="background-image: url({$r[thumb]})"{else}style="background-image: url({siteurl($siteid)}/images/common/down_thumb_noimg.png)"{/if}></div></div><span class="pro-description">{$r[title]}</span></a></li>
{/loop}
{/loop}
{/pc}
{/loop}
{/if}发表评论:
◎欢迎参与讨论，请在这里发表您的看法、交流您的观点。
相关文章
phpcms-v9中将一个站点下的文章内容完美的推送到另一个站点下2024-09-24
phpcms loop循环判断是否为最后一条的代码2024-06-18
phpcms文章列表增加一键推送到百度功能2022-12-08
phpcms 标题SEO栏目不同的代码2022-11-14
PHPCMS替换内容的两种方法：str_replace和preg_replace2022-10-25
phpcms 搜索结果第一页比设定的多一条数据的解决办法2021-01-05
phpcms v9 字段多行文本不换行的解决办法2020-09-22
phpcms 栏目和文章页面“您没有访问该信息的权限”跳转登陆页面2020-09-17
phpcms 模板header包含action="lists"导致搜索结果错误的解决方案2020-04-26
phpcms转向链接过滤#的问题解决2020-04-23