142 lines
3.4 KiB
PHP
142 lines
3.4 KiB
PHP
<?php
|
|
declare (strict_types = 1);
|
|
|
|
namespace app\model;
|
|
|
|
use app\exception\ModelException;
|
|
use app\exception\ModelEmptyException;
|
|
|
|
/**
|
|
* @mixin \think\Model
|
|
*/
|
|
class Nav extends Model
|
|
{
|
|
public function category(): \think\model\relation\BelongsTo
|
|
{
|
|
return $this->belongsTo(Category::class);
|
|
}
|
|
|
|
/**
|
|
* @param array $where
|
|
* @return array
|
|
* @throws ModelException
|
|
*/
|
|
public function getNavList(array $where = [],$order='sort asc'): array
|
|
{
|
|
try{
|
|
$res = $this->where($where)->order($order)->select();
|
|
}catch(\Exception $e){
|
|
throw new ModelException($e->getMessage());
|
|
}
|
|
return dataReturn($this->sucCode,$this->getMsg,$res);
|
|
|
|
}
|
|
|
|
/**
|
|
* @param array $where
|
|
* @return array
|
|
* @throws ModelEmptyException
|
|
* @throws ModelException
|
|
*/
|
|
public function getNav(array $where = []): array
|
|
{
|
|
try{
|
|
$res = $this->where($where)->find();
|
|
if(empty($res)){
|
|
throw new ModelEmptyException();
|
|
}
|
|
}catch(ModelEmptyException $me){
|
|
throw new ModelEmptyException();
|
|
}catch(\Exception $e){
|
|
throw new ModelException($e->getMessage());
|
|
}
|
|
return dataReturn($this->sucCode,$this->getMsg,$res);
|
|
|
|
}
|
|
|
|
/**
|
|
* @param array $where
|
|
* @param string $column
|
|
* @return array
|
|
* @throws ModelException
|
|
*/
|
|
public function getMaxOrderNav(array $where = [], string $column='id'): array
|
|
{
|
|
try{
|
|
$res = $this->where($where)->max($column);
|
|
}catch(\Exception $e){
|
|
throw new ModelException($e->getMessage());
|
|
}
|
|
return dataReturn($this->sucCode,$this->getMsg,$res);
|
|
|
|
}
|
|
|
|
/**
|
|
* @param $param
|
|
* @return array
|
|
* @throws ModelException
|
|
*/
|
|
public function addNav($param): array
|
|
{
|
|
try{
|
|
$res = self::create($param);
|
|
}catch(\Exception $e){
|
|
throw new ModelException($e->getMessage());
|
|
}
|
|
return dataReturn($this->sucCode,$this->addMsg,$res->id);
|
|
}
|
|
|
|
/**
|
|
* @param array $where
|
|
* @param array $param
|
|
* @return array
|
|
* @throws ModelException
|
|
*/
|
|
public function updateNav(array $where = [],array $param = []): array
|
|
{
|
|
try{
|
|
$res = self::where($where)->update($param);
|
|
}catch(\Exception $e){
|
|
throw new ModelException($e->getMessage());
|
|
}
|
|
return dataReturn($this->sucCode,$this->updateMsg,$res);
|
|
}
|
|
|
|
/**
|
|
* @param $where
|
|
* @return array
|
|
* @throws ModelException
|
|
*/
|
|
public function softDelNav($where): array
|
|
{
|
|
try{
|
|
$res = $this->where($where)->update($this->delData);
|
|
}catch(\Exception $e){
|
|
throw new ModelException($e->getMessage());
|
|
}
|
|
return dataReturn($this->sucCode,$this->delMsg,$res);
|
|
}
|
|
|
|
/**
|
|
* @param $where
|
|
* @return array
|
|
* @throws ModelException
|
|
*/
|
|
public function delNav($where): array
|
|
{
|
|
try{
|
|
$res = $this->where($where)->delete();
|
|
}catch(\Exception $e){
|
|
throw new ModelException($e->getMessage());
|
|
}
|
|
return dataReturn($this->sucCode,$this->delMsg,$res);
|
|
}
|
|
|
|
public function getCategoryIdAttr($value)
|
|
{
|
|
if(empty($value) || $value == 0){
|
|
$value = null;
|
|
}
|
|
return $value;
|
|
}
|
|
} |