<?php
namespace app\common\model;

use app\common\utils\Upload;
use think\Model;

class Attachment extends BaseModel {
    
    protected $pk = 'aid';
    
    /*public static function onAfterDelete($model)
    {
        $filename = $model->getData('filename');
        if(!empty($filename)) {
             \Upload::delAttach($filename);
        }
    }*/

    /**
     * 附件删除
     * @param unknown $where    条件
     * @return bool
     */
    public static function del($filename)
    {
        if(empty($filename)) {
            return true;
        }
        try {
            $where = [];
            $where[] = ['filename|url', '=', $filename];
            $model = self::detail($where);
            Upload::delAttach($model->filename);
            $model->delete();
        }catch (\Exception $e){
            Log::add($e->getMessage());
            return false;
        }

        return true;
    }
    
    /**
     * 获取图片访问地址
     * @param unknown $value
     * @return string
     */
    public function getFilenameAttr($value)
    {
        return Upload::getUrl($value);
    }
    
    
    /**
     * 根据hash 更新table_id
     * @param unknown $hash
     * @param unknown $table_id
     */
    public static function updateTableId($hash , $table_id)
    {
        self::where('hash','in',$hash)->update(['table_id'=>$table_id]);
    }
    
    /**
     * 根据hash更新排序
     * @param unknown $hash
     */
    public static function updateSort($hash)
    {
        $hash = explode(',', $hash);
        foreach ($hash as $key=>$value)
        {
            self::where('hash',$value)->update(['sort'=>$key]);
        }
    }
}