<?php
namespace app\common\model;

use think\facade\Db;
use think\Model;

/**
 * 推荐位
 * @author aaron
 *
 */
class Recommend extends BaseModel
{
    protected $pk = 'rid';

    public function NursingHome()
    {
        return $this->belongsTo(NursingHome::class,'table_id');
    }

    public function sojourn()
    {
        return $this->belongsTo(Sojourn::class,'table_id');
    }

    /**
     * 添加推荐位数据
     * @param unknown $table_id 外键
     * @param unknown $table_type 类型
     * @param unknown $recommend_ids    推荐位
     */
    public static function createRecommend($table_id, $table_type, $recommend_ids)
    {
        Db::startTrans();
        //根据外键清空原有值
        self::del([
            'table_id'  =>  $table_id,
            'table_type'  =>  $table_type,
        ]);
        //添加新值
        if($recommend_ids) {
            foreach ($recommend_ids as $recommend_id) {
                $d = [
                    'table_id'  =>  $table_id,
                    'table_type'  =>  $table_type,
                    'r_id'  =>  $recommend_id,
                ];
                self::add($d, true);
            }
        }

        Db::commit();
    }

    /**
     * 更新推荐位排序
     * @param unknown $data 数据
     * @param unknown $table_id 外键
     * @param unknown $sort 排序
     * @return boolean
     */
    public static function updateRecommendSort($recommend_id, $sortArr)
    {
        Db::startTrans();
        //更新值
        foreach ($sortArr as $rid=>$sort) {
            $d = [
                'recommend_id'  =>  $recommend_id,
                'sort'  =>  $sort,
            ];
            self::where('rid', $rid)->update($d);
        }
        Db::commit();

        return true;
    }

    /**
     * 删除推荐位
     * @param unknown $table_id
     */
    public static function remove($table_id, $table_type)
    {
        return self::destroy(['table_id'=>$table_id, 'table_type'=>$table_type]);
    }

    public static function getRecommendCount($table_id, $table_type)
    {
        return self::where('table_id',$table_id)->where('table_type',$table_type)->count();
    }


    public static function getRecommendId($table_id)
    {
        return self::where('table_id',$table_id)->column('recommend_id');
    }

    /**
     * 获取推荐位数据
     * @param unknown $table_type   类型
     * @param unknown $recommend_id
     * @param number $limit
     * @return unknown
     */
    public static function getRecommendList($table_type, $recommend_id, $limit = 99, $order = ['sort'=>'asc'])
    {
        $return = [];
        $data = self::with([$table_type])
            ->where('r_id',$recommend_id)
            ->where('table_type',$table_type)
            ->order($order)
            ->limit($limit)
            ->select();

        if(!$data->isEmpty()) {
            foreach ($data as $item) {
                $sort = $item->sort;
                $item->$table_type->sort = $sort;
                $return[] = $item->$table_type;
            }
        }

        return $return;
    }

    /*public static function getRecommendList($relation_name, $recommend_id, $where = [], $limit = 99)
    {
        $return = [];
        $data = self::with([$relation_name])
            ->where('recommend_id',$recommend_id)
            ->where('table_type',$relation_name)
            ->where($where)
            ->order('sort','desc')
            ->limit($limit)
            ->select();
        if($data) {
            foreach ($data as $item) {
                $return[] = $item->$relation_name;
            }
        }

        return $return;
    }*/

}