CensusMallRmAnalysis.php 3.6 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293
  1. <?php
  2. namespace common\models\census;
  3. use common\enums\StatusEnum;
  4. use common\models\base\BaseActiveRecord;
  5. use Yii;
  6. /**
  7. * This is the model class for table "qimall_census_mall_rm_analysis".
  8. *
  9. * @property int $id ID
  10. * @property int $mall_id 商城ID
  11. * @property int $purchase_interval 购买间隔时间天
  12. * @property int $m_users5 M-消费金额>=2000客户数
  13. * @property int $m_users4 M-消费金额1000<=M<2000客户数
  14. * @property int $m_users3 M-消费金额500<=M<=1000客户数
  15. * @property int $m_users2 M-消费金额200<=M<=500客户数
  16. * @property int $m_users1 M-消费金额m<200客户数
  17. * @property float $m_total_pay_money5 M-消费金额>=2000累计支付金额
  18. * @property float $m_total_pay_money4 M-消费金额1000<=M<2000累计支付金额
  19. * @property float $m_total_pay_money3 M-消费金额500<=M<=1000累计支付金额
  20. * @property float $m_total_pay_money2 M-消费金额200<=M<=500累计支付金额
  21. * @property float $m_total_pay_money1 M-消费金额m<200累计支付金额
  22. * @property int|null $status 状态[-1:删除;0:禁用;1启用;]
  23. * @property int $created_at 创建时间
  24. * @property int $updated_at 上次更新数据时间
  25. */
  26. class CensusMallRmAnalysis extends BaseActiveRecord
  27. {
  28. /**
  29. * {@inheritdoc}
  30. */
  31. public static function tableName()
  32. {
  33. return '{{%census_mall_rm_analysis}}';
  34. }
  35. /**
  36. * {@inheritdoc}
  37. */
  38. public function rules()
  39. {
  40. return [
  41. [['mall_id','purchase_interval', 'm_users1', 'm_users2', 'm_users3', 'm_users4', 'm_users5', 'status', 'created_at', 'updated_at'], 'integer'],
  42. [['m_total_pay_money1', 'm_total_pay_money2', 'm_total_pay_money3', 'm_total_pay_money4', 'm_total_pay_money5'], 'number'],
  43. ];
  44. }
  45. /**
  46. * {@inheritdoc}
  47. */
  48. public function attributeLabels()
  49. {
  50. return [
  51. 'id' => 'ID',
  52. 'mall_id' => '商城ID',
  53. 'purchase_interval' => '购买间隔时间天',
  54. 'm_users5' => 'M-消费金额>=2000客户数',
  55. 'm_users4' => 'M-消费金额1000<=M<2000客户数',
  56. 'm_users3' => 'M-消费金额500<=M<=1000客户数',
  57. 'm_users2' => 'M-消费金额200<=M<=500客户数',
  58. 'm_users1' => 'M-消费金额m<200客户数',
  59. 'm_total_pay_money5' => 'M-消费金额>=2000累计支付金额',
  60. 'm_total_pay_money4' => 'M-消费金额1000<=M<2000累计支付金额',
  61. 'm_total_pay_money3' => 'M-消费金额500<=M<=1000累计支付金额',
  62. 'm_total_pay_money2' => 'M-消费金额200<=M<=500累计支付金额',
  63. 'm_total_pay_money1' => 'M-消费金额m<200累计支付金额',
  64. 'status' => '状态[-1:删除;0:禁用;1启用;]',
  65. 'created_at' => '创建时间',
  66. 'updated_at' => '上次更新数据时间',
  67. ];
  68. }
  69. public static function setData($params)
  70. {
  71. try {
  72. if (empty($params['mall_id']) || empty($params['purchase_interval'])) return false;
  73. $model = self::findOne(['mall_id' => $params['mall_id'], 'purchase_interval' => $params['purchase_interval'], 'status' => [StatusEnum::ENABLED, StatusEnum::DISABLED]]);
  74. if (empty($model)) {
  75. $model = new self();
  76. $model->loadDefaultValues();
  77. }
  78. $model->load($params, '');
  79. if (!$model->save()) throw new \Exception($model->getErrorMessage());
  80. return $model;
  81. } catch (\Exception $e) {
  82. self::$static_error = $e->getMessage();
  83. return false;
  84. }
  85. }
  86. }