UserTeamDateAchievementStatistics.php 3.9 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687
  1. <?php
  2. namespace common\models\statistics;
  3. use Yii;
  4. /**
  5. * This is the model class for table "qimall_user_team_date_achievement_statistics_1".
  6. *
  7. * @property int $id
  8. * @property int $user_id
  9. * @property int $mall_id
  10. * @property int $user_direct_order_total 直推会员订单总数(jxmall_user_children.level=1)
  11. * @property int $user_indirect_order_total 间推会员订单总数(jxmall_user_children.level=2)
  12. * @property float $user_team_order_price_total 团队会员订单总额(不包括本人)
  13. * @property float $user_direct_order_price_total 直推会员订单总额(jxmall_user_children.level=1)
  14. * @property float $user_indirect_order_price_total 间推会员订单总额(jxmall_user_children.level=2)
  15. * @property int|null $team_finish_order_total 团队完成订单数量(不包括本人)
  16. * @property float|null $team_finish_order_price_total 团队完成订单金额(不包括本人)
  17. * @property float $user_direct_pay_selling_price 直推已支付的订单售价总额(商品价格)
  18. * @property float $user_direct_finish_selling_price 直推已完成的订单售价总额(商品价格)
  19. * @property float $user_indirect_pay_selling_price 间推已支付的订单售价总额(商品价格)
  20. * @property float $user_indirect_finish_selling_price 间推已完成的订单售价总额(商品价格)
  21. * @property float $team_goods_price_total 群组总业绩(不包含运费)(不包含自己)
  22. * @property float $team_pay_selling_price 群组产品总额(不包含自己)
  23. * @property int $team_order_num 群组订单总数(不包含自己)
  24. * @property int $team_finish_selling_price 团队已完成的订单售价总额(商品价格)
  25. * @property int $date 日期
  26. * @property int $created_at
  27. * @property int $updated_at
  28. */
  29. class UserTeamDateAchievementStatistics extends BaseUserTeamStatistics
  30. {
  31. /**
  32. * 是否是根据日期统计
  33. *
  34. * @var bool
  35. */
  36. const IS_BY_DATE = true;
  37. /**
  38. * {@inheritdoc}
  39. */
  40. public static function tableName()
  41. {
  42. return 'qimall_user_team_date_achievement_statistics_' . self::$currentTableNum;
  43. }
  44. /**
  45. * {@inheritdoc}
  46. */
  47. public function rules()
  48. {
  49. return [
  50. [['user_id', 'mall_id', 'user_direct_order_total', 'user_indirect_order_total', 'team_finish_order_total', 'date', 'created_at', 'updated_at'], 'integer'],
  51. [['user_team_order_price_total', 'user_direct_order_price_total', 'user_indirect_order_price_total', 'team_finish_order_price_total', 'user_direct_pay_selling_price', 'user_direct_finish_selling_price', 'user_indirect_pay_selling_price', 'user_indirect_finish_selling_price', 'team_finish_selling_price'], 'number'],
  52. [['user_id', 'date'], 'unique', 'targetAttribute' => ['user_id', 'date']],
  53. ];
  54. }
  55. /**
  56. * {@inheritdoc}
  57. */
  58. public function attributeLabels()
  59. {
  60. return [
  61. 'id' => 'ID',
  62. 'user_id' => 'User ID',
  63. 'mall_id' => 'Mall ID',
  64. 'user_direct_order_total' => 'User Direct Order Total',
  65. 'user_indirect_order_total' => 'User Indirect Order Total',
  66. 'user_team_order_price_total' => 'User Team Order Price Total',
  67. 'user_direct_order_price_total' => 'User Direct Order Price Total',
  68. 'user_indirect_order_price_total' => 'User Indirect Order Price Total',
  69. 'team_finish_order_total' => 'Team Finish Order Total',
  70. 'team_finish_order_price_total' => 'Team Finish Order Price Total',
  71. 'user_direct_pay_selling_price' => 'User Direct Pay Selling Price',
  72. 'user_direct_finish_selling_price' => 'User Direct Finish Selling Price',
  73. 'user_indirect_pay_selling_price' => 'User Indirect Pay Selling Price',
  74. 'user_indirect_finish_selling_price' => 'User Indirect Finish Selling Price',
  75. 'date' => 'Date',
  76. 'created_at' => 'Created At',
  77. 'updated_at' => 'Updated At',
  78. ];
  79. }
  80. }