|
Server : Apache System : Linux iZ6xhqomji47p1Z 5.10.134-15.al8.x86_64 #1 SMP Thu Jul 20 00:44:04 CST 2023 x86_64 User : www ( 1000) PHP Version : 8.1.30 Disable Function : passthru,exec,system,putenv,chroot,chgrp,chown,shell_exec,popen,proc_open,pcntl_exec,ini_alter,ini_restore,dl,openlog,syslog,readlink,symlink,popepassthru,pcntl_alarm,pcntl_fork,pcntl_waitpid,pcntl_wait,pcntl_wifexited,pcntl_wifstopped,pcntl_wifsignaled,pcntl_wifcontinued,pcntl_wexitstatus,pcntl_wtermsig,pcntl_wstopsig,pcntl_signal,pcntl_signal_dispatch,pcntl_get_last_error,pcntl_strerror,pcntl_sigprocmask,pcntl_sigwaitinfo,pcntl_sigtimedwait,pcntl_exec,pcntl_getpriority,pcntl_setpriority,imap_open,apache_setenv Directory : /www/wwwroot/fsjlkj.cn/application/user/model/ |
<?php
/**
* 易优CMS
* ============================================================================
* 版权所有 2016-2028 海南赞赞网络科技有限公司，并保留所有权利。
* 网站地址: http://www.eyoucms.com
* ----------------------------------------------------------------------------
* 如果商业用途务必到官方购买正版授权, 以免引起不必要的法律纠纷.
* ============================================================================
* Author: 小虎哥 <1105415366@qq.com>
* Date: 2018-4-3
*/
namespace app\user\model;
use think\Db;
use think\Model;
use think\Config;
/**
* 会员投稿
*/
class UsersRelease extends Model
{
private $home_lang = 'cn';
//初始化
protected function initialize()
{
// 需要调用`Model`的`initialize`方法
parent::initialize();
$this->home_lang = get_home_lang();
}
/**
* 后置操作方法
* 自定义的一个函数 用于数据保存后做的相应处理操作, 使用时手动调用
* @param int $aid 产品id
* @param array $post post数据
* @param string $opt 操作
*/
public function afterSave($aid, $post, $opt, $table)
{
$post['aid'] = $aid;
$addonFieldExt = !empty($post['addonFieldExt']) ? $post['addonFieldExt'] : array();
$this->dealChannelPostData($post['channel'], $post, $addonFieldExt);
// 图集模型
if ($post['channel'] == 3) {
$this->saveimg($aid, $post);
} else if ($post['channel'] == 4) {
model('DownloadFile')->savefile($aid, $post);
} else if ($post['channel'] == 5) {
model('MediaFile')->savefile($aid, $post,$opt);
}
// 处理TAG标签
model('Taglist')->savetags($aid, $post['typeid'], $post['tags'], $post['arcrank'], $opt);
if ('edit' == $opt) {
// 清空sql_cache_table数据缓存表 并 添加查询执行语句到mysql缓存表
Db::name('sql_cache_table')->execute('TRUNCATE TABLE '.config('database.prefix').'sql_cache_table');
model('SqlCacheTable')->InsertSqlCacheTable(true);
} else {
// 处理mysql缓存表数据
if (isset($post['arcrank']) && 0 <= $post['arcrank']) {
// 投稿已审核
model('SqlCacheTable')->UpdateSqlCacheTable($post, $opt, $table, true);
} else if (isset($post['arcrank']) && -1 == $post['arcrank']) {
// 投稿待审核
model('SqlCacheTable')->UpdateDraftSqlCacheTable($post, $opt, true);
}
}
}
/**
* 删除单条图集的所有图片
* @author 小虎哥 by 2018-4-3
*/
public function delImgUpload($aid = array())
{
if (!is_array($aid)) {
$aid = array($aid);
}
$result = Db::name('ImagesUpload')->where(array('aid'=>array('IN', $aid)))->delete();
return $result;
}
/**
* 保存图集图片
* @author 小虎哥 by 2018-4-3
*/
public function saveimg($aid, $post = array())
{
$imgupload = isset($post['imgupload']) ? $post['imgupload'] : array();
$imgintro = isset($post['imgintro']) ? $post['imgintro'] : array();
if (!empty($imgupload)) {
array_pop($imgupload); // 弹出最后一个
// 删除产品图片
$this->delImgUpload($aid);
// 添加图片
$data = array();
$sort_order = 0;
foreach($imgupload as $key => $val)
{
if($val == null || empty($val)) continue;
$filesize = 0;
$img_info = array();
if (is_http_url($val)) {
$imgurl = handle_subdir_pic($val);
} else {
$imgurl = ROOT_PATH.ltrim($val, '/');
$filesize = @filesize('.'.$val);
}
$img_info = @getimagesize($imgurl);
$width = isset($img_info[0]) ? $img_info[0] : 0;
$height = isset($img_info[1]) ? $img_info[1] : 0;
$type = isset($img_info[2]) ? $img_info[2] : 0;
$attr = isset($img_info[3]) ? $img_info[3] : '';
$mime = isset($img_info['mime']) ? $img_info['mime'] : '';
$title = !empty($post['title']) ? $post['title'] : '';
$intro = !empty($imgintro[$key]) ? $imgintro[$key] : '';
++$sort_order;
$data[] = array(
'aid' => $aid,
'title' => $title,
'image_url' => $val,
'intro' => $intro,
'width' => $width,
'height' => $height,
'filesize' => $filesize,
'mime' => $mime,
'sort_order' => $sort_order,
'add_time' => getTime(),
);
}
if (!empty($data)) {
Db::name('ImagesUpload')->insertAll($data);
// 没有封面图时，取第一张图作为封面图
$litpic = isset($post['litpic']) ? $post['litpic'] : '';
if (empty($litpic)) {
$litpic = $data[0]['image_url'];
Db::name('archives')->where(array('aid'=>$aid))->update(array('litpic'=>$litpic, 'update_time'=>getTime()));
}
}
delFile(UPLOAD_PATH."images/thumb/$aid"); // 删除缩略图
}
}
/**
* 获取单条记录
*/
public function getInfo($aid, $field = null, $isshowbody = true)
{
$result = array();
$field = !empty($field) ? $field : '*';
$result = Db::name('archives')->field($field)
->where([
'aid' => $aid,
'lang' => get_home_lang(),
])
->find();
if ($isshowbody) {
$tableName = M('channeltype')->where('id','eq',$result['channel'])->getField('table');
$result['addonFieldExt'] = Db::name($tableName.'_content')->where('aid',$aid)->find();
}
if (5 == $result['channel']){
$result['courseware'] = Db::name('media_content')->where('aid',$aid)->value('courseware');
}
// 文章TAG标签
if (!empty($result)) {
$typeid = isset($result['typeid']) ? $result['typeid'] : 0;
$tags = model('Taglist')->getListByAid($aid, $typeid);
if (!empty($tags['tag_arr'])){
$result['tags'] = $tags['tag_arr'];
}else{
$result['tags'] = '';
}
}
return $result;
}
/**
* 获取单条图集的所有图片
* @author 小虎哥 by 2018-4-3
*/
public function getImgUpload($aid, $field = '*')
{
$result = Db::name('ImagesUpload')->field($field)
->where('aid', $aid)
->order('sort_order asc')
->select();
return $result;
}
/**
* 查询解析模型数据用以构造from表单
*/
public function dealChannelPostData($channel_id, $data = array(), $dataExt = array())
{
if (!empty($dataExt) && !empty($channel_id)) {
$nowDataExt = array();
$fieldTypeList = model('Channelfield')->getListByWhere(array('channel_id'=>$channel_id), 'name,dtype', 'name');
foreach ($dataExt as $key => $val) {
/*处理复选框取消选中的情况下*/
if (preg_match('/^(.*)(_eyempty)$/', $key) && empty($val)) {
$key = preg_replace('/^(.*)(_eyempty)$/', '$1', $key);
$nowDataExt[$key] = '';
continue;
}
/*end*/
$key = preg_replace('/^(.*)(_eyou_is_remote|_eyou_remote|_eyou_local)$/', '$1', $key);
$dtype = !empty($fieldTypeList[$key]) ? $fieldTypeList[$key]['dtype'] : '';
switch ($dtype) {
case 'checkbox':
{
$val = implode(',', $val);
break;
}
case 'region':
{
if (!is_numeric($val)) { // 三级联动
//选择全国的时候干掉城市区域的值
if ($val[0] == 0){
if (isset($val[1])) unset($val[1]);
if (isset($val[2])) unset($val[2]);
}else{
$parent_data = Db::name('region')->where('id',$val[0])->find();
if (!empty($parent_data) && !empty($parent_data['parent_id'])){
//只有市级和区域能选择
array_unshift($val,$parent_data['parent_id']);
//只有区域能选择
if (3 == $parent_data['level']){
$parent_id = Db::name('region')->where('id',$val[0])->value('parent_id');
array_unshift($val,$parent_id);
}
}
}
//三级联动的需要选择
$val = implode(',', $val);
} else {
if (is_array($val)) {
$new_val = [];
foreach ($val as $_k => $_v) {
$_v = trim($_v);
if (!empty($_v)) {
$new_val[] = $_v;
}
}
$val = $new_val;
} else {
$val = trim($val);
}
}
break;
}
case 'switch':
case 'int':
{
$val = intval($val);
break;
}
case 'img':
{
$val = $dataExt[$key];
break;
}
case 'imgs':
{
$eyou_imgupload_list = [];
foreach ($val as $k2 => $v2) {
$v2 = trim($v2);
if (empty($v2)) continue;
$eyou_imgupload_list[] = [
'image_url' => handle_subdir_pic($v2),
'intro' => '',
];
}
$val = serialize($eyou_imgupload_list);
break;
}
case 'files':
{
foreach ($val as $k2 => $v2) {
if (empty($v2)) {
unset($val[$k2]);
continue;
}
$val[$k2] = trim($v2);
}
$val = implode(',', $val);
break;
}
case 'datetime':
{
$val = !empty($val) ? strtotime($val) : getTime();
break;
}
case 'decimal':
{
$moneyArr = explode('.', $val);
$money1 = !empty($moneyArr[0]) ? intval($moneyArr[0]) : '0';
$money2 = !empty($moneyArr[1]) ? intval(msubstr($moneyArr[1], 0, 2)) : '00';
$val = $money1.'.'.$money2;
break;
}
case 'htmltext':
{
if (!empty($val)) {
$val = preg_replace("/^&nbsp;/i", "", $val);
}
$val = preg_replace("/<script[\s\S]*?script>/i", "", $val);
$val = trim($val);
}
default:
{
if (is_array($val)) {
$new_val = [];
foreach ($val as $_k => $_v) {
$_v = trim($_v);
if (!empty($_v)) {
$new_val[] = $_v;
}
}
$val = $new_val;
} else {
$val = trim($val);
}
break;
}
}
$nowDataExt[$key] = $val;
}
$nowData = array(
'aid' => $data['aid'],
'add_time' => getTime(),
'update_time' => getTime(),
);
$nowDataExt = array_merge($nowDataExt, $nowData);
$tableExt = M('channeltype')->where('id', $channel_id)->getField('table');
$tableExt .= '_content';
$count = M($tableExt)->where('aid', $data['aid'])->count();
if (empty($count)) {
M($tableExt)->insert($nowDataExt);
} else {
M($tableExt)->where('aid', $data['aid'])->save($nowDataExt);
}
}
}
/**
* 查询解析数据表的数据用以构造from表单
* @param return $list
* @param 用于添加，不携带数据
*/
public function GetUsersReleaseData($channel_id = null, $typeid = null, $aid = null, $method = 'add')
{
$hideField = array('id','aid','add_time','update_time','content_ey_m'); // 不显示在发布表单的字段
$channel_id = intval($channel_id);
$map = array(
'channel_id' => array('eq', $channel_id),
'name' => array('notin', $hideField),
'ifmain' => 0,
'ifeditable' => 1,
'is_release' => 1,
);
$row = model('Channelfield')->getListByWhere($map, '*');
/*编辑时显示的数据*/
$addonRow = array();
if ('edit' == $method) {
if (6 == $channel_id) {
$aid = Db::name('archives')->where(array('typeid'=>$typeid, 'channel'=>$channel_id))->getField('aid');
}
$tableExt = Db::name('channeltype')->where('id', $channel_id)->getField('table');
$tableExt .= '_content';
$addonRow = Db::name($tableExt)->field('*')->where('aid', $aid)->find();
}
/*--end*/
$channelfieldBindRow = Db::name('channelfield_bind')->where([
'typeid' => ['IN', [0, $typeid]],
])->column('field_id');
foreach ($row as $key=>$val){
if (!in_array($val['id'], $channelfieldBindRow) && !in_array($val['name'], ['content','content_ey_m'])) {
unset($row[$key]);
}
}
$list = $this->showViewFormData($row, 'addonFieldExt', $addonRow);
return $list;
}
/**
* 查询解析数据表的数据用以构造from表单
* @param return $list
* @param 用于修改，携带数据
* @author 陈风任 by 2019-2-20
*/
public function getDataParaList($users_id = '')
{
// 字段及内容数据处理
$row = M('users_parameter')->field('a.*,b.info,b.users_id')
->alias('a')
->join('__USERS_LIST__ b', "a.para_id = b.para_id AND b.users_id = {$users_id}", 'LEFT')
->where([
'a.lang' => $this->home_lang,
'a.is_hidden' => 0,
])
->order('a.sort_order asc,a.para_id asc')
->select();
// 根据所需数据格式，拆分成一维数组
$addonRow = [];
foreach ($row as $key => $value) {
$addonRow[$value['name']] = $value['info'];
}
// 根据不同字段类型封装数据
$list = $this->showViewFormData($row, 'users_', $addonRow);
return $list;
}
/**
* 处理页面显示字段的表单数据
* @param array $list 字段列表
* @param array $formFieldStr 表单元素名称的统一数组前缀
* @param array $addonRow 字段的数据
* @author 陈风任 by 2019-2-20
*/
public function showViewFormData($list, $formFieldStr, $addonRow = array())
{
if (!empty($list)) {
foreach ($list as $key => $val) {
$val['fieldArr'] = $formFieldStr;
switch ($val['dtype']) {
case 'int':
{
if (isset($addonRow[$val['name']])) {
$val['dfvalue'] = $addonRow[$val['name']];
} else {
if(preg_match("#[^0-9]#", $val['dfvalue']))
{
$val['dfvalue'] = "";
}
}
break;
}
case 'float':
case 'decimal':
{
if (isset($addonRow[$val['name']])) {
$val['dfvalue'] = $addonRow[$val['name']];
} else {
if(preg_match("#[^0-9\.]#", $val['dfvalue']))
{
$val['dfvalue'] = "";
}
}
break;
}
case 'select':
{
$dfvalue = $val['dfvalue'];
$dfvalueArr = explode(',', $dfvalue);
$val['dfvalue'] = $dfvalueArr;
if (isset($addonRow[$val['name']])) {
$val['trueValue'] = explode(',', $addonRow[$val['name']]);
} else {
$dfTrueValue = !empty($dfvalueArr[0]) ? $dfvalueArr[0] : '';
$val['trueValue'] = array();
}
break;
}
case 'radio':
{
$dfvalue = $val['dfvalue'];
$dfvalueArr = explode(',', $dfvalue);
$val['dfvalue'] = $dfvalueArr;
if (isset($addonRow[$val['name']])) {
$val['trueValue'] = explode(',', $addonRow[$val['name']]);
} else {
$dfTrueValue = !empty($dfvalueArr[0]) ? $dfvalueArr[0] : '';
$val['trueValue'] = array($dfTrueValue);
}
break;
}
case 'region':
{
$dfvalue = unserialize($val['dfvalue']);
$RegionData = [];
$region_ids = explode(',', $dfvalue['region_ids']);
foreach ($region_ids as $id_key => $id_value) {
$RegionData[$id_key]['id'] = $id_value;
}
$region_names = explode('，', $dfvalue['region_names']);
foreach ($region_names as $name_key => $name_value) {
$RegionData[$name_key]['name'] = $name_value;
}
$val['dfvalue'] = $RegionData;
if (isset($addonRow[$val['name']])) {
$val['trueValue'] = explode(',', $addonRow[$val['name']]);
} else {
if ( !empty($val['set_type']) && 1 == $val['set_type']){
$val['trueValue'] = [];
}else {
$dfTrueValue = !empty($dfvalueArr[0]) ? $dfvalueArr[0] : '';
$val['trueValue'] = array($dfTrueValue);
}
}
if ( !empty($val['set_type']) && 1 == $val['set_type']){
//三级联动的需要处理
$rid = $val['dfvalue'][0]['id'];
$region_data = Db::name('region')->where('id',$rid)->find();//这里查出来的只能是省级1或者市级2
$val['region_level'] = $region_data['level'];
$region_arr = [['id'=>-1,'name'=>'请选择']];
if (2 == $region_data['level']){
$province_list = get_province_list();
$val['city_list'] = array_merge($region_arr,$val['dfvalue']);
$val['trueValue'][0] = $region_data['parent_id'];
$val['dfvalue'] = $province_list;
}elseif (3 == $region_data['level']){
$province_list = get_province_list();
$province_id = Db::name('region')->where('id',$region_data['parent_id'])->value('parent_id');
$val['area_list'] = array_merge($region_arr,$val['dfvalue']);
$val['dfvalue'] = $province_list;
$val['trueValue'][0] = $province_id;
$val['trueValue'][1] = $region_data['parent_id'];
if (empty($val['trueValue'][2])) $val['trueValue'][2] = -1;
}
if (!empty($val['trueValue'][1])){
$field_region_type = config('global.field_region_type');
//如果是4个特殊的直辖市,市的数据直接显示到区
if (in_array($val['trueValue'][0],$field_region_type)){
$city_ids = Db::name('region')->where(['level'=>2,'parent_id'=>$val['trueValue'][0]])->column('id');
$city_list = Db::name('region')->where(['level'=>3])->where('parent_id','in',$city_ids)->select();
}else{
$city_list = Db::name('region')->where(['level'=>2,'parent_id'=>$val['trueValue'][0]])->select();
}
$val['city_list'] = array_merge($region_arr,$city_list);
}
if (!empty($val['trueValue'][2])){
$area_list = Db::name('region')->where(['level'=>3,'parent_id'=>$val['trueValue'][1]])->select();
$val['area_list'] = array_merge($region_arr,$area_list);
}
}
break;
}
case 'checkbox':
{
$dfvalue = $val['dfvalue'];
$dfvalueArr = explode(',', $dfvalue);
$val['dfvalue'] = $dfvalueArr;
if (isset($addonRow[$val['name']])) {
$val['trueValue'] = explode(',', $addonRow[$val['name']]);
} else {
$val['trueValue'] = array();
}
break;
}
case 'img':
{
if (isset($addonRow[$val['name']])) {
$val['dfvalue'] = handle_subdir_pic($addonRow[$val['name']]);
}
break;
}
case 'file':
{
if (isset($addonRow[$val['name']])) {
$val['dfvalue'] = handle_subdir_pic($addonRow[$val['name']]);
}
$ext = tpCache('basic.file_type');
$val['ext'] = !empty($ext) ? $ext : "zip|gz|rar|iso|doc|xls|ppt|wps";
$val['filesize'] = upload_max_filesize();
break;
}
case 'media':
{
if (isset($addonRow[$val['name']])) {
$val['dfvalue'] = handle_subdir_pic($addonRow[$val['name']],'media');
}
$val['upload_flag'] = 'local';
$WeappConfig = Db::name('weapp')->field('code, status')->where('code', 'IN', ['Qiniuyun', 'AliyunOss', 'Cos'])->where('status',1)->select();
foreach ($WeappConfig as $value) {
if ('Qiniuyun' == $value['code']) {
$val['upload_flag'] = 'qny';
} else if ('AliyunOss' == $value['code']) {
$val['upload_flag'] = 'oss';
} else if ('Cos' == $value['code']) {
$val['upload_flag'] = 'cos';
}
}
$ext = tpCache('basic.media_type');
$val['ext'] = !empty($ext) ? $ext : "swf|mpg|mp3|rm|rmvb|wmv|wma|wav|mid|mov|mp4";
$val['filesize'] = upload_max_filesize();
break;
}
case 'imgs':
{
$val[$val['name'].'_eyou_imgupload_list'] = array();
if (isset($addonRow[$val['name']]) && !empty($addonRow[$val['name']])) {
if (preg_match('/^a\:(\d+)\:\{/', $addonRow[$val['name']])) {
$eyou_imgupload_list = unserialize($addonRow[$val['name']]);
} else {
$eyou_imgupload_list = explode(',', $addonRow[$val['name']]);
foreach ($eyou_imgupload_list as $_k => $_v) {
$eyou_imgupload_list[$_k] = [
'image_url' => $_v,
'intro' => '',
];
}
}
//支持子目录
foreach ($eyou_imgupload_list as $k1 => $v1) {
$eyou_imgupload_list[$k1]['image_url'] = handle_subdir_pic($v1['image_url']);
}
$val[$val['name'].'_eyou_imgupload_list'] = $eyou_imgupload_list;
}
break;
}
case 'datetime':
{
$val['dfvalue'] = !empty($addonRow[$val['name']]) ? date('Y-m-d H:i:s', $addonRow[$val['name']]) : date('Y-m-d H:i:s');
break;
}
case 'htmltext':
{
$val['dfvalue'] = isset($addonRow[$val['name']]) ? $addonRow[$val['name']] : $val['dfvalue'];
$val['dfvalue'] = handle_subdir_pic($val['dfvalue'], 'html');//支持子目录
break;
}
default:
{
$val['dfvalue'] = isset($addonRow[$val['name']]) ? $addonRow[$val['name']] : $val['dfvalue'];
if (is_string($val['dfvalue'])) {
//支持子目录
$val['dfvalue'] = handle_subdir_pic($val['dfvalue'], 'html');
$val['dfvalue'] = handle_subdir_pic($val['dfvalue']);
}
break;
}
}
$list[$key] = $val;
}
}
return $list;
}
}