<?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;
    }

}