69 行
2.1 KiB
PHP
可执行文件
69 行
2.1 KiB
PHP
可执行文件
<?php
|
|
|
|
/**
|
|
* 微信素材模型 - 数据对象模型
|
|
* @version LV1.0
|
|
*/
|
|
namespace Common\Model;
|
|
|
|
use Think\Model;
|
|
|
|
class WxSourceitemModel extends Model {
|
|
protected $tableName = 'wxsourceitem';
|
|
protected $fields = array (
|
|
0 => "id",//int(11) NOT NULL AUTO_INCREMENT,
|
|
1 => "media_id",//varchar(32) DEFAULT NULL COMMENT '文章素材id',
|
|
2 => "title",//varchar(100) DEFAULT 标题,
|
|
3 => "author",// varchar(50) DEFAULT NULL COMMENT '作者',
|
|
4 => "digest",// varchar(20) DEFAULT NULL COMMENT '摘要',
|
|
5 => "content",// text COMMENT '内容',
|
|
6 => "thumb_media_id",// varchar(255) DEFAULT NULL COMMENT '封面素材id',
|
|
7 => "show_cover_pic",// smallint(1) DEFAULT NULL COMMENT '是否显示封面图片',
|
|
8 => "url",// varchar(255) DEFAULT NULL,
|
|
9 => "create_time",// varchar(11) DEFAULT 创建时间,
|
|
10 => "update_time",// varchar(11) DEFAULT 修改时间,
|
|
11 => "sourceid",// varchar(11) DEFAULT 素材id,
|
|
12 => "thumb_media_src",// varchar(11) DEFAULT 素材id,
|
|
);
|
|
/**
|
|
* 获取素材列表信息
|
|
*/
|
|
public function getcontent($sourceid){
|
|
$map['sourceid'] = $sourceid;
|
|
$content = $this->field('id,url,media_id,title,update_time,url,thumb_media_id,thumb_media_src,show_cover_pic,content,digest')->where($map)->select();
|
|
return $content;
|
|
}
|
|
public function Sourceupdate($map,$data){
|
|
$re = $this->where($map)->save($data);
|
|
return $re;
|
|
}
|
|
/**
|
|
* @param $map
|
|
* @return mixedx
|
|
*/
|
|
public function delItem($map){
|
|
$re = $this->where($map)->delete();
|
|
return $re;
|
|
}
|
|
public function getIdArray($map){
|
|
$content = $this->where($map)->getField('sourceid',true);
|
|
return $content;
|
|
}
|
|
/**
|
|
* 添加微信素材
|
|
*/
|
|
public function addsource($data){
|
|
$re = $this->add($data);
|
|
return $re;
|
|
}
|
|
|
|
/** 通过id 寻找微信素材信息
|
|
* @param $media_id
|
|
*/
|
|
public function getSource($media_id){
|
|
$map['media_id'] = $media_id;
|
|
$cache = $this->where($map)->find();
|
|
return $cache;
|
|
}
|
|
|
|
} |