InvoiceFlow.php 4.1 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109
  1. <?php
  2. namespace common\models;
  3. use Yii;
  4. /**
  5. * This is the model class for table "{{%INVOICE_FLOW}}".
  6. *
  7. * @property string $ID
  8. * @property string $USER_ID 会员ID
  9. * @property string $REAL_NAME 会员姓名
  10. * @property string $DEC_LV 报单级别
  11. * @property string $EMP_LV 聘级
  12. * @property string $MOBILE 手机号
  13. * @property string $REG_TYPE 注册类型
  14. * @property string $REG_NAME 注册名称
  15. * @property string $CREDIT_CODE 统一社会信用代码
  16. * @property string $SALE_NAME 销售方名称
  17. * @property string $TAXPAYER_NUMBER 纳税人识别号
  18. * @property string $INVOICE_ACCOUNT 交易账户-发票账户
  19. * @property string $INVOICE_SN 发票号
  20. * @property string $TAX_ACCOUNT 交易账户-税款账户
  21. * @property int $OUTED_AT 开票日期
  22. * @property int $DEDUCT_PERIOD_NUM 发票冲减期数
  23. * @property string $AMOUNT 金额
  24. * @property string $TOTAL 当前总金额
  25. * @property string $WITHDRAW_SN 提现流水号
  26. * @property int $IS_INCR 是否增加
  27. * @property string $REMARK 备注
  28. * @property int $PERIOD_NUM 所在期数
  29. * @property int $CALC_MONTH 所在结算月
  30. * @property string $CREATE_ADMIN 创建人
  31. * @property string $CREATE_REMARK 创建备注
  32. * @property int $CREATE_TIME 创建时间
  33. * @property string $AUDIT_ADMIN 审核人
  34. * @property string $AUDIT_REMARK 审核备注
  35. * @property int $AUDIT_TIME 审核时间
  36. * @property string $P_MONTH 表分区的日期索引
  37. * @property int $CREATED_AT 创建时间
  38. */
  39. class InvoiceFlow extends \common\components\ActiveRecord
  40. {
  41. /**
  42. * {@inheritdoc}
  43. */
  44. public static function tableName()
  45. {
  46. return '{{%INVOICE_FLOW}}';
  47. }
  48. /**
  49. * {@inheritdoc}
  50. */
  51. public function rules()
  52. {
  53. return [
  54. [['USER_ID', 'REAL_NAME', 'DEC_LV', 'EMP_LV', 'MOBILE', 'REG_TYPE', 'REG_NAME', 'CREDIT_CODE', 'REMARK', 'PERIOD_NUM', 'CALC_MONTH', 'CREATE_ADMIN', 'CREATE_TIME', 'AUDIT_ADMIN', 'AUDIT_TIME', 'P_MONTH', 'CREATED_AT'], 'required'],
  55. [['OUTED_AT', 'DEDUCT_PERIOD_NUM', 'IS_INCR', 'PERIOD_NUM', 'CALC_MONTH', 'CREATE_TIME', 'AUDIT_TIME', 'CREATED_AT'], 'integer'],
  56. [['AMOUNT', 'TOTAL'], 'number'],
  57. [['ID', 'USER_ID', 'DEC_LV', 'EMP_LV', 'MOBILE', 'REG_TYPE', 'CREATE_ADMIN', 'AUDIT_ADMIN'], 'string', 'max' => 32],
  58. [['REAL_NAME'], 'string', 'max' => 128],
  59. [['REG_NAME', 'CREDIT_CODE', 'SALE_NAME', 'TAXPAYER_NUMBER', 'INVOICE_ACCOUNT', 'INVOICE_SN', 'TAX_ACCOUNT', 'WITHDRAW_SN', 'REMARK'], 'string', 'max' => 255],
  60. [['CREATE_REMARK', 'AUDIT_REMARK'], 'string', 'max' => 4000],
  61. [['P_MONTH'], 'string', 'max' => 7],
  62. [['ID'], 'unique'],
  63. ];
  64. }
  65. /**
  66. * {@inheritdoc}
  67. */
  68. public function attributeLabels()
  69. {
  70. return [
  71. 'ID' => 'ID',
  72. 'USER_ID' => '会员ID',
  73. 'REAL_NAME' => '会员姓名',
  74. 'DEC_LV' => '报单级别',
  75. 'EMP_LV' => '聘级',
  76. 'MOBILE' => '手机号',
  77. 'REG_TYPE' => '注册类型',
  78. 'REG_NAME' => '注册名称',
  79. 'CREDIT_CODE' => '统一社会信用代码',
  80. 'SALE_NAME' => '销售方名称',
  81. 'TAXPAYER_NUMBER' => '纳税人识别号',
  82. 'INVOICE_ACCOUNT' => '交易账户-发票账户',
  83. 'INVOICE_SN' => '发票号',
  84. 'TAX_ACCOUNT' => '交易账户-税款账户',
  85. 'OUTED_AT' => '开票日期',
  86. 'DEDUCT_PERIOD_NUM' => '发票冲减期数',
  87. 'AMOUNT' => '金额',
  88. 'TOTAL' => '当前总金额',
  89. 'WITHDRAW_SN' => '提现流水号',
  90. 'IS_INCR' => '是否增加',
  91. 'REMARK' => '备注',
  92. 'PERIOD_NUM' => '所在期数',
  93. 'CALC_MONTH' => '所在结算月',
  94. 'CREATE_ADMIN' => '创建人',
  95. 'CREATE_REMARK' => '创建备注',
  96. 'CREATE_TIME' => '创建时间',
  97. 'AUDIT_ADMIN' => '审核人',
  98. 'AUDIT_REMARK' => '审核备注',
  99. 'AUDIT_TIME' => '审核时间',
  100. 'P_MONTH' => '表分区的日期索引',
  101. 'CREATED_AT' => '创建时间',
  102. ];
  103. }
  104. }