RWACha-API/application/common/model/AnnouncementType.php

<?php

namespace app\common\model;

use Exception;
use fast\Action;
use fast\Asset;
use fast\RechargeOrderType;
use fast\RechargeStatus;
use think\Db;
use think\Model;

class AnnouncementType extends Model
{

      protected $name = "announcement_type";

      
      // 开启自动写入时间戳字段
      protected $autoWriteTimestamp = 'int';
      //定义时间戳字段名
      protected $createTime = 'createtime';
      protected $updateTime = 'updatetime';
      
      // 追加属性
      protected $append = [
            'createtime_text',
            'updatetime_text'
      ];

      //获取子分类
      public static function getSubTypeById(object $data, string $lan){

            foreach ($data as &$item) {
            $item->sub_type_name = '';
            if(!empty($item->sub_type_id)) $item->sub_type_name = self::whereIn('id', $item->sub_type_id)->field('id,'.$lan.'_title as title,color')->select();
            }
            return $data;
      }

      //获取大分类子分类
      public static function getSubTypeByPId(int $typeId, string $lan){

            return self::where('pid', $typeId)->column('id,'.$lan.'_title as title');
      }
    

      public function getCreatetimeTextAttr($value, $data)
      {
            $value = $value ? $value : (isset($data['createtime']) ? $data['createtime'] : '');
            return is_numeric($value) ? date("Y-m-d H:i:s", $value) : $value;
      }


      public function getUpdatetimeTextAttr($value, $data)
      {
            $value = $value ? $value : (isset($data['updatetime']) ? $data['updatetime'] : '');
            return is_numeric($value) ? date("Y-m-d H:i:s", $value) : $value;
      }

      protected function setCreatetimeAttr($value)
      {
            return $value === '' ? null : ($value && !is_numeric($value) ? strtotime($value) : $value);
      }

      protected function setUpdatetimeAttr($value)
      {
            return $value === '' ? null : ($value && !is_numeric($value) ? strtotime($value) : $value);
      }
}