<?php

namespace app\api\model\plus\release;

use app\common\model\plus\release\Project as ProjectModel;
use app\common\model\plus\release\DemandUser as DemandUserModel;
use app\common\model\plus\release\SupplyUser as SupplyUserModel;
use app\common\model\plus\release\ReleaseProjectImage as ReleaseProjectImageModel;

/**
 * 模型
 */
class Project extends ProjectModel
{
    /**
     * 获取列表
     */
    public function getList($user_id, $postdata)
    {
        $model = $this;
        if(!empty($postdata["keyword"])){
            $model = $model->where('name', 'like', '%'.$postdata["keyword"].'%');
        }
        if(!empty($postdata["category_id"])){
            if($postdata["category_id"] == '-1'){
                //根据分类匹配
                $category_ids = (new ProjectModel())->where('user_id','=',$user_id)
                ->where('project_type','=',$postdata["product_type"])
                ->column('category_id');
                if(!empty($category_ids)){
                    $model = $model->where('category_id', 'in', $category_ids); 
                }
            }else{
               $model = $model->where('category_id', '=', $postdata["category_id"]); 
            }
            
        }

        //添加项目排序查询
        if(!empty($postdata["order_sort"]) && $postdata["order_sort"] == 1){
            $order = "actual_views desc,create_time desc";
        }else{
            $order = "create_time desc";
        }
        $list = $model->with(['category','user'])->where('is_delete', '=', 0)
            ->where('project_type', '=', $postdata["product_type"])
            ->where('status', '=', 1)
            ->where('is_show', '=', 1)
            ->where('user_id', '<>', $user_id)
            ->order($order)
            ->paginate($postdata);

         foreach($list as &$val){
            if($postdata["product_type"] == 0){
                $release_user = DemandUserModel::detail($val['user_id'],['grade']);
            }else{
                $release_user = SupplyUserModel::detail($val['user_id'],['grade']);
            }
            $val['grade'] = empty($release_user['grade']) ? '' : $release_user['grade'];
            $image_list = ReleaseProjectImageModel::getImage($val["project_id"]);
            $val['image'] = empty($image_list[0]) ? '/static/default.png' : $image_list[0]['file_path']; 
         }   
         return $list;
    }  

    /**
     * 详情
     */
    public static function detail($project_id)
    {
        if (!$model = parent::detail($project_id)) {
            throw new BaseException(['msg' => '不存在']);
        }
        // 累积阅读数
        $model->where('project_id', '=', $project_id)->inc('actual_views', 1)->update();
        return $model;
    }

    /**
     * 获取列表
     */
    public function getIndexList($user, $show_num=2)
    {
        $model = $this;
        $user_id = 0;
        if(!empty($user)){
                $user_id = $user['user_id'];
               //根据分类匹配
                $category_ids = (new ProjectModel())->where('user_id','=',$user['user_id'])
                ->column('category_id');
                if(!empty($category_ids)){
                    $model = $model->where('category_id', 'in', $category_ids); 
                }   
        }
        $list = $model->with(['category','user'])->where('is_delete', '=', 0)
            ->where('status', '=', 1)
            ->where('is_show', '=', 1)
            ->order(['create_time' => 'desc'])
            ->paginate($show_num);

         foreach($list as &$val){
            if($val["product_type"] == 0){
                $release_user = DemandUserModel::detail($val['user_id'],['grade']);
                //需求项目获取供应用户
                $my_user =  SupplyUserModel::detail($user_id);
            }else{
                $release_user = SupplyUserModel::detail($val['user_id'],['grade']);
                //供应项目获取需求用户
                $my_user =  DemandUserModel::detail($user_id);
            }
            $val['is_check'] = empty($my_user['is_check']) ? 0 : $my_user['is_check'];
            $val['grade'] = empty($release_user['grade']) ? '' : $release_user['grade'];
            $image_list = ReleaseProjectImageModel::getImage($val["project_id"]);
            $val['image'] = empty($image_list[0]) ? '/static/default.png' : $image_list[0]['file_path']; 
         }   
         return $list;
    }  

}