<?php
namespace app\shouyin\model;
use think\Model;
use app\product\model\Project as ProjectModel;
use app\product\model\Product as ProductModel;
use think\Db;
class UserCardLog extends Model
{
protected $createTime = 'createtime';
protected $updateTime = 'updatetime';
protected $autoWriteTimestamp = true;
public function getProTextAttr($value,$data)
{
if($data['type'] == 1){ $ProjectModel = new ProjectModel;
return $ProjectModel->where('id', $data['pid'])->value('name');
}else{ $ProductModel = new ProductModel;
return $ProductModel->where('id', $data['pid'])->value('name');
}
}
public function getTypeTextAttr($value, $data)
{
$type = ['1'=>'项目','2'=>'产品'];
return $type[$value];
}
public function getPriceAttr($value,$data)
{
if($data['type'] == 1){ $ProjectModel = new ProjectModel;
return $ProjectModel->where('id', $data['pid'])->value('price');
}else{ $ProductModel = new ProductModel;
return $ProductModel->where('id', $data['pid'])->value('price');
}
}
public function getUserNameAttr($value)
{
$name = Db::name('user')->where('id',$value)->value('nick');
return $name;
}
public function hasUser()
{
return $this->hasOne('app\user\model\User', 'id', 'user_id');
}
public function hasCourse()
{
return $this->hasOne('Course', 'id', 'pid');
}
public static function getUserCards($userid,$pid,$type=1)
{
$where = [
['pid','=',$pid],
['user_id','=',$userid],
['type','=',$type],
['use','=',1]
];
$projectCardCount = self::where($where)->count('id');
return $projectCardCount;
}
}