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

<?php

namespace app\common\model;

use think\Cache;
use think\Model;

/**
 * 激活码用户日志
 */
class CodeUserLogModel extends Model
{

      protected $name = "code_user_log";

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

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

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

      //添加激活码记录
      public static function addCodeUserLog(int $uid, int $parent_id, int $level, int $gift1 =0, int $gift2 =0, $frozen =0, string $code_no)
      {
            $codeUserLogModel = new self();
            $codeUserLogModel->user_id = $uid;
            $codeUserLogModel->gift1 = $gift1;
            $codeUserLogModel->gift2 = $gift2;
            $codeUserLogModel->frozen = $frozen;
            $codeUserLogModel->level  = $level;
            $codeUserLogModel->parent_id = $parent_id;
            $codeUserLogModel->code_no   = $code_no;
            $codeUserLogModel->save();
      }


      public function users()
      {
            return $this->hasOne('UserModel', 'id', 'user_id', [], 'LEFT')->setEagerlyType(0);
      }


      //产品
      public function product1()
      {
            return $this->hasOne('ProductLists', 'id', 'gift1', [], 'LEFT')->setEagerlyType(0);
      }

      public function product2()
      {
            return $this->hasOne('ProductLists', 'id', 'gift2', [], 'LEFT')->setEagerlyType(0);
      }

    
      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);
      }


}