mirror of
https://github.com/crmeb/CRMEB.git
synced 2025-12-20 17:42:59 +00:00
122 lines
3.5 KiB
PHP
122 lines
3.5 KiB
PHP
<?php
|
|
/**
|
|
* @author: xaboy<365615158@qq.com>
|
|
* @day: 2017/11/13
|
|
*/
|
|
|
|
namespace app\admin\model\system;
|
|
|
|
use crmeb\traits\ModelTrait;
|
|
use crmeb\basic\BaseModel;
|
|
|
|
/**
|
|
* 文件检验model
|
|
* Class SystemFile
|
|
* @package app\admin\model\system
|
|
*/
|
|
class SystemAttachment extends BaseModel
|
|
{
|
|
|
|
/**
|
|
* 数据表主键
|
|
* @var string
|
|
*/
|
|
protected $pk = 'att_id';
|
|
|
|
/**
|
|
* 模型名称
|
|
* @var string
|
|
*/
|
|
protected $name = 'system_attachment';
|
|
|
|
use ModelTrait;
|
|
|
|
/**
|
|
* TODO 添加附件记录
|
|
* @param $name
|
|
* @param $att_size
|
|
* @param $att_type
|
|
* @param $att_dir
|
|
* @param string $satt_dir
|
|
* @param int $pid
|
|
* @param int $imageType
|
|
* @param int $time
|
|
* @return SystemAttachment
|
|
*/
|
|
public static function attachmentAdd($name,$att_size,$att_type,$att_dir,$satt_dir='',$pid = 0,$imageType = 1 ,$time = 0 , $module_type=1)
|
|
{
|
|
$data['name'] = $name;
|
|
$data['att_dir'] = $att_dir;
|
|
$data['satt_dir'] = $satt_dir;
|
|
$data['att_size'] = $att_size;
|
|
$data['att_type'] = $att_type;
|
|
$data['image_type'] = $imageType;
|
|
$data['module_type'] = $module_type;
|
|
$data['time'] = $time ? $time : time();
|
|
$data['pid'] = $pid;
|
|
return self::create($data);
|
|
}
|
|
|
|
/**
|
|
* TODO 获取分类图
|
|
* @param $id
|
|
* @return array
|
|
*/
|
|
public static function getAll($id){
|
|
$model = new self;
|
|
$where['pid'] = $id;
|
|
$where['module_type'] = 1;
|
|
$model->where($where)->order('att_id desc');
|
|
return $model->page($model,$where,'',24);
|
|
}
|
|
|
|
/** 获取图片列表
|
|
* @param $where
|
|
* @return array
|
|
*/
|
|
public static function getImageList($where)
|
|
{
|
|
$model = new self;
|
|
$model = $model->where('module_type', 1);
|
|
if(isset($where['pid']) && $where['pid']) $model = $model->where('pid', $where['pid']);
|
|
$model = $model->page((int)$where['page'],(int)$where['limit']);
|
|
$model = $model->order('att_id desc,time desc');
|
|
$list = $model->select();
|
|
$list = count($list) ? $list->toArray() : [];
|
|
$site_url = SystemConfig::getConfigValue('site_url');
|
|
foreach ($list as &$item){
|
|
if($site_url) {
|
|
$item['satt_dir'] = (strpos($item['satt_dir'], $site_url) !== false || strstr($item['satt_dir'], 'http') !== false) ? $item['satt_dir'] : $site_url . $item['satt_dir'];
|
|
$item['att_dir'] = (strpos($item['att_dir'], $site_url) !== false || strstr($item['att_dir'], 'http') !== false) ? $item['satt_dir'] : $site_url . $item['att_dir'];
|
|
}
|
|
}
|
|
$count = self::where(['pid'=>$where['pid'],'module_type'=>1])->count();
|
|
return compact('list','count');
|
|
}
|
|
/**
|
|
* TODO 获取单条信息
|
|
* @param $value
|
|
* @param string $field
|
|
* @return array
|
|
* @throws \think\Exception
|
|
* @throws \think\db\exception\DataNotFoundException
|
|
* @throws \think\db\exception\ModelNotFoundException
|
|
* @throws \think\exception\DbException
|
|
*/
|
|
public static function getInfo($value,$field = 'att_id'){
|
|
$where[$field] = $value;
|
|
$count = self::where($where)->count();
|
|
if(!$count) return false;
|
|
return self::where($where)->find()->toArray();
|
|
}
|
|
|
|
/**
|
|
* 清除昨日海报
|
|
* @return bool
|
|
* @throws \Exception
|
|
*/
|
|
public static function emptyYesterdayAttachment()
|
|
{
|
|
return self::whereTime('time','yesterday')->where(['module_type'=>2])->delete();
|
|
}
|
|
} |