DEnterprise.Class.php 2.5 KB

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758
  1. <?php
  2. /**
  3. * 企业管理Dao
  4. * Created by PhpStorm.
  5. * User: 小威
  6. * Date: 2019/11/04
  7. * Time: 11:50
  8. */
  9. namespace JinDouYun\Dao\Enterprise;
  10. use JinDouYun\Dao\BaseDao;
  11. class DEnterprise extends BaseDao
  12. {
  13. public function __construct($serviceDB = 'default')
  14. {
  15. $this->_table = 'enterprise';
  16. $this->_primary = 'id';
  17. $this->_fields = [
  18. "id", //int(10) NOT NULL AUTO_INCREMENT COMMENT '自增id',
  19. "userCenterId", //int(11) DEFAULT NULL COMMENT '客户id',
  20. "brandName", //varchar(50) DEFAULT NULL COMMENT '品牌名称',
  21. "enterpriseName", //varchar(50) DEFAULT NULL COMMENT '企业名称',
  22. "contact", //varchar(30) DEFAULT NULL COMMENT '联系人',
  23. "mobile", //varchar(20) DEFAULT NULL COMMENT '联系电话',
  24. "provinceCode", //varchar(50) DEFAULT NULL COMMENT '省份编码',
  25. "cityCode", //varchar(50) DEFAULT NULL COMMENT '城市编码',
  26. "districtCode", //varchar(50) DEFAULT NULL COMMENT '区县编码',
  27. "address", //varchar(255) DEFAULT NULL COMMENT '详细地址',
  28. "categoryId", //int(10) DEFAULT NULL COMMENT '企业类别',
  29. "startTime", //int(10) DEFAULT NULL COMMENT '营业时间',
  30. "endTime", //int(10) DEFAULT NULL COMMENT '停业时间',
  31. "logo", //varchar(255) DEFAULT NULL COMMENT '企业logo',
  32. "appid", //varchar(50) DEFAULT NULL COMMENT 'appid',
  33. "appSecret", //char(32) DEFAULT NULL COMMENT 'appSecret',
  34. "token", //char(32) DEFAULT NULL COMMENT 'token',
  35. "deleteStatus", //tinyint(3) DEFAULT '5' COMMENT '删除状态 4:删除 5:正常 6:过期',
  36. "createTime", //int(10) DEFAULT NULL COMMENT '创建时间',
  37. "updateTime", //int(10) DEFAULT NULL COMMENT '更新时间',
  38. "extend", //json DEFAULT NULL COMMENT '扩展字段',
  39. "scope", //tinyint(3) DEFAULT '5' COMMENT '删除状态 4:单店铺 5:多店铺(默认)',
  40. "iosAuditStatus",//tinyint(3) DEFAULT '5' COMMENT '删除状态 4:审核中 5:正常(默认)',
  41. "balance",//余额
  42. "isoem", //tinyint(3) NOT NULL DEFAULT '4' COMMENT 确认企业贴牌 4是确认,5是其他
  43. "oemId",//oem表企业id
  44. ];
  45. $this->_readonly = ['id'];
  46. $this->_create_autofill = [
  47. 'createTime' => time()
  48. ];
  49. $this->_update_autofill = [
  50. 'updateTime' => time()
  51. ];
  52. parent::__construct($serviceDB);
  53. }
  54. }