<?php namespace Phpcmf\Field;
class Related extends \Phpcmf\Library\A_Field {
public function __construct(...$params) {
parent::__construct(...$params);
$this->fieldtype = ['TEXT' => '']; $this->defaulttype = 'TEXT'; }
public function option($option) {
$_option = '';
$_module = \Phpcmf\Service::C()->get_cache('module-'.SITE_ID.'-content');
if ($_module) {
foreach ($_module as $dir => $t) {
$_option.= '<option value="'.$dir.'" '.($dir == $option['module'] ? 'selected' : '').'>'.$t['name'].'</option>';
}
}
return ['<div class="form-group">
<label class="col-md-2 control-label">'.dr_lang('内容模块').'</label>
<div class="col-md-9">
<label><select class="form-control" name="data[setting][option][module]">
'.$_option.'
</select></label>
<span class="help-block">'.dr_lang('必须选择一个模块作为关联数据源').'</span>
</div>
</div>
<div class="form-group">
<label class="col-md-2 control-label">'.dr_lang('最大显示数量').'</label>
<div class="col-md-9">
<label><input type="text" class="form-control" size="10" name="data[setting][option][limit]" value="'.$option['limit'].'"></label>
<span class="help-block">'.dr_lang('关联列表搜索结果最大显示数量，默认50条').'</span>
</div>
</div>
<div class="form-group">
<label class="col-md-2 control-label">'.dr_lang('友情提示').'</label>
<div class="col-md-9">
<div class="form-control-static">'.dr_lang('此字段不能参与搜索条件筛选').'</div>
</div>
</div>'];
}
public function output($value) {
return $value;
}
public function insert_value($field) {
$data = \Phpcmf\Service::L('Field')->post[$field['fieldname']];
$value = !$data ? '' : implode(',', $data);
\Phpcmf\Service::L('Field')->data[$field['ismain']][$field['fieldname']] = $value;
}
public function input($field, $value = '') {
if ($this->_not_edit($field, $value)) {
return $this->show($field, $value);
}
$name = $field['fieldname'];
$tips = isset($field['setting']['validate']['tips']) && $field['setting']['validate']['tips'] ? '<span class="help-block" id="dr_'.$name.'_tips">'.$field['setting']['validate']['tips'].'</span>' : '';
$area = \Phpcmf\Service::C()->_is_mobile() ? '["95%", "90%"]' : '["50%", "45%"]';
$module = isset($field['setting']['option']['module']) ? $field['setting']['option']['module'] : '';
$tpl = '<tr id="dr_items_'.$name.'_{id}"><td>{id}</td><td>{value}<input type="hidden" name="data['.$name.'][]" value="{id}"></td><td width="45"><a class="btn btn-xs btn-danger" href="javascript:;" onclick="$(\\\'#dr_items_'.$name.'_{id}\\\').remove()"><i class="fa fa-trash"></i></a></td></tr>';
$url = '/index.php?s=api&c=api&m=related&site='.SITE_ID.'&module='.$module.'&limit='.intval($field['setting']['option']['limit']);
$text = ($field['setting']['validate']['required'] ? '<span class="required" aria-required="true"> * </span>' : '').$field['name'];
$str = '';
$str.= '
<table class="table table-striped table-bordered fc-sku-table table-hover">
<thead>
<tr>
<th width="90" style="border-left-width: 1px!important;">Id </th>
<th>'.dr_lang('主题').' </th>
<th width="50"> </th>
</tr>
</thead>
<tbody id="related_'.$name.'-sort-items">';
$value = @trim($value, ',');
if ($value && is_string($value)) {
$db = \Phpcmf\Service::M()->db->query('select id,title,url from '.\Phpcmf\Service::M()->dbprefix(SITE_ID.'_'.$module).' where id IN ('.$value.') order by instr("'.$value.'", id)');
$query = $db ? $db->getResultArray() : [];
if ($query) {
foreach ($query as $t) {
$id = $t['id'];
$value = '<a href="'.$t['url'].'" target="_blank">'.$t['title'].'</a>';
$str.= str_replace(array('{id}', '{value}', '\\'), array($id, $value, ''), $tpl);
}
}
}
$str.= '</tbody>';
$str.= '</table>';
$str.= '<p>';
$str.= '<button type="button" class="btn btn-default btn-sm" onClick="dr_add_related_'.$name.'()"> <i class="fa fa-plus"></i> '.dr_lang('关联内容').'</button>';
$str.= '</p>';
$str.= $tips;
$str.= '
<script type="text/javascript">
$("#related_'.$name.'-sort-items").sortable();
function dr_add_related_'.$name.'() {
layer.open({
type: 2,
title: \'<i class="fa fa-cog"></i> '.dr_lang('关联内容').'\',
fix:true,
shadeClose: true,
shade: 0,
area: '.$area.',
btn: ["'.dr_lang('关联').'"],
success: function (json) {
if (json.code == 0) {
layer.close();
dr_tips(json.code, json.msg);
}
},
yes: function(index, layero){
var body = layer.getChildFrame(\'body\', index);
var loading = layer.load(2, {
time: 10000
});
$.ajax({type: "POST",dataType:"json", url: "'.$url.'&is_ajax=1", data: $(body).find(\'#myform\').serialize(),
success: function(json) {
layer.close(loading);
if (json.code == 1) {
layer.close(index);
var temp = \''.$tpl.'\';
var html = "";
for(var i in json.data.result){
var tpl = temp;
var v = json.data.result[i];
if($("#dr_items_'.$name.'_"+v.id).length>0)
{
dr_tips(0, "'.dr_lang('已经存在').'");
return;
}
tpl = tpl.replace(/\{id\}/g, v.id);
tpl = tpl.replace(/\{value\}/g, v.value);
html+= tpl;
}
$(\'#related_'.$name.'-sort-items\').append(html);
dr_tips(1, json.msg);
} else {
dr_tips(0, json.msg);
}
return false;
}
});
return false;
},
content: "'.$url.'&is_ajax=1"
});
}
</script>';
return $this->input_format($name, $text, $str);
}
public function show($field, $value = null) {
$str = '';
$str.= '
<table class="table table-striped table-bordered table-advance">
<thead>
<tr>
<th width="90" style="border-left-width: 2px!important;"> Id </th>
<th>'.dr_lang('主题').' </th>
</tr>
</thead>
<tbody>';
$value = @trim($value, ',');
$module = isset($field['setting']['option']['module']) ? $field['setting']['option']['module'] : '';
if ($value && is_string($value)) {
$db = \Phpcmf\Service::M()->db->query('select id,title,url from '.\Phpcmf\Service::M()->dbprefix(SITE_ID.'_'.$module).' where id IN ('.$value.') order by instr("'.$value.'", id)');
$query = $db ? $db->getResultArray() : [];
if ($query) {
foreach ($query as $t) {
$str .= '<tr><td>' . $t['id'] . '</td><td><a href="' . $t['url'] . '" target="_blank">' . $t['title'] . '</a></td></tr>';;
}
}
}
$str.= '</tbody>';
$str.= '</table>';
return $this->input_format($field['fieldname'], $field['name'], $str);
}
}