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

<?php

namespace app\common\model;

use think\Model;


class ProductArea extends Model
{


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

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

      // 追加属性
      protected $append = [
            'create_time_text',
            'update_time_text'
      ];
    
      const Stop           = 0;
      const Normal         = 1;
  
      //状态
      public $status_list = [
          '-1'                    => '全部',
          self::Stop              => '停用',
          self::Normal            => '正常'
      ];


      public static function getProductStock(int $product_id)
      {
            return self::where('status', 1)->where('product_id', $product_id)->count();
      }

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


}