UserStatisticsTotal.php 4.4 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109
  1. <?php
  2. namespace common\models\user;
  3. use Yii;
  4. /**
  5. * This is the model class for table "qimall_user_statistics_total".
  6. *
  7. * @property int $id ID
  8. * @property int $mall_id 商城ID
  9. * @property int $user_id 用户ID
  10. * @property int $order_num 下单数
  11. * @property float $order_money
  12. * @property int $pay_num 支付订单数
  13. * @property float $pay_money
  14. * @property int $pay_goods_num 支付商品件数
  15. * @property float|null $average_money 客单价(订单总额/订单总数)
  16. * @property int $finish_order_num 已完成订单数
  17. * @property float $finish_order_money
  18. * @property int $finish_goods_num 已完成商品数
  19. * @property int $refund_order_num 退款订单数
  20. * @property float $refund_order_money
  21. * @property int $refund_goods_num 退款商品数
  22. * @property float $recharge_money
  23. * @property float $original_order_money
  24. * @property int $cancel_order_num 已取消订单数
  25. * @property float $cancel_order_money
  26. * @property int $cancel_goods_num 已取消商品数
  27. * @property float $balance_pay
  28. * @property float $wechat_pay
  29. * @property float $ali_pay
  30. * @property int $status 状态【1启用 0禁用 -1删除】
  31. * @property int $created_at 创建时间
  32. * @property int $updated_at 更新数据时间
  33. * @property int $share_nums 分享次数
  34. * @property int $visit_nums 访问次数
  35. * @property float $pay_selling_price 已支付的订单售价总额(商品价格)
  36. * @property float $finish_selling_price 已完成的订单售价总额(商品价格)
  37. * @property float $user_goods_price_total 已支付的业绩
  38. * @property int $user_order_num 用户订单数(订单售后完成会减)
  39. * @property int $refund_finish_order_num
  40. * @property float $refund_finish_order_money
  41. */
  42. class UserStatisticsTotal extends \common\models\base\BaseActiveRecord
  43. {
  44. /**
  45. * {@inheritdoc}
  46. */
  47. public static function tableName()
  48. {
  49. return 'qimall_user_statistics_total';
  50. }
  51. /**
  52. * {@inheritdoc}
  53. */
  54. public function rules()
  55. {
  56. return [
  57. [['mall_id', 'user_id', 'order_num', 'pay_num', 'pay_goods_num', 'finish_order_num', 'finish_goods_num', 'refund_order_num', 'refund_goods_num', 'cancel_order_num', 'cancel_goods_num', 'status', 'created_at', 'updated_at', 'share_nums', 'visit_nums', 'user_order_num', 'refund_finish_order_num'], 'integer'],
  58. [['order_money', 'pay_money', 'average_money', 'finish_order_money', 'refund_order_money', 'recharge_money', 'original_order_money', 'cancel_order_money', 'balance_pay', 'wechat_pay', 'ali_pay', 'pay_selling_price', 'finish_selling_price', 'user_goods_price_total', 'refund_finish_order_money'], 'number'],
  59. ];
  60. }
  61. /**
  62. * {@inheritdoc}
  63. */
  64. public function attributeLabels()
  65. {
  66. return [
  67. 'id' => 'ID',
  68. 'mall_id' => 'Mall ID',
  69. 'user_id' => 'User ID',
  70. 'order_num' => 'Order Num',
  71. 'order_money' => 'Order Money',
  72. 'pay_num' => 'Pay Num',
  73. 'pay_money' => 'Pay Money',
  74. 'pay_goods_num' => 'Pay Goods Num',
  75. 'average_money' => 'Average Money',
  76. 'finish_order_num' => 'Finish Order Num',
  77. 'finish_order_money' => 'Finish Order Money',
  78. 'finish_goods_num' => 'Finish Goods Num',
  79. 'refund_order_num' => 'Refund Order Num',
  80. 'refund_order_money' => 'Refund Order Money',
  81. 'refund_goods_num' => 'Refund Goods Num',
  82. 'recharge_money' => 'Recharge Money',
  83. 'original_order_money' => 'Original Order Money',
  84. 'cancel_order_num' => 'Cancel Order Num',
  85. 'cancel_order_money' => 'Cancel Order Money',
  86. 'cancel_goods_num' => 'Cancel Goods Num',
  87. 'balance_pay' => 'Balance Pay',
  88. 'wechat_pay' => 'Wechat Pay',
  89. 'ali_pay' => 'Ali Pay',
  90. 'status' => 'Status',
  91. 'created_at' => 'Created At',
  92. 'updated_at' => 'Updated At',
  93. 'share_nums' => 'Share Nums',
  94. 'visit_nums' => 'Visit Nums',
  95. 'pay_selling_price' => 'Pay Selling Price',
  96. 'finish_selling_price' => 'Finish Selling Price',
  97. 'user_goods_price_total' => 'User Goods Price Total',
  98. 'user_order_num' => 'User Order Num',
  99. 'refund_finish_order_num' => 'Refund Finish Order Num',
  100. 'refund_finish_order_money' => 'Refund Finish Order Money',
  101. ];
  102. }
  103. }