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

<?php

namespace app\common\model;

use think\Cache;
use think\Model;

/**
 * 激活码
 */
class CodeNoModel extends Model
{

      protected $name = "code_no";

      // 自动写入时间戳字段
      protected $autoWriteTimestamp = 'int';

      // 定义时间戳字段名
      protected $createTime = 'create_time';
      protected $updateTime = 'update_time';
      protected $deleteTime = false;

      // 追加属性
      protected $append = [
            'create_time_text',
            'update_time_text'
      ];

      //状态： 0已使用 1正常
      const STATUS_USED = 0;
      const STATUS_NORMAL = 1;


      //生成唯一激活码6位
      public static function getCodeNo($len = 6): string
      {
            $string='abcdefghijklmnopqrstuvwxyzABCDEFGHJKLMNPQEST123456789';
            do {
                  $code = substr(str_shuffle($string), 0, $len);
                  $cnt  = self::where('code_no', $code)->count();
                  
            } while ($cnt);
            return $code;
      }

      //添加激活记录
      public static function setActivate($uid, $level)
      {
            $code = self::getCodeNo();
            self::create([
                  'user_id' => $uid,
                  'level' => $level,
                  'code_no' => $code,
                  'status' => self::STATUS_NORMAL,
            ]);
            return $code;
      }



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


      public function getUpdateTimeTextAttr($value, $data)
      {
            $value = $value ? $value : (isset($data['update_time']) ? $data['update_time'] : '');
            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);
      }


}