CensusMallRfAnalysis.php 3.5 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980818283848586878889909192939495969798
  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_rf_analysis".
  8. *
  9. * @property int $id ID
  10. * @property int $mall_id 商城ID
  11. * @property int $purchase_interval 购买间隔时间天
  12. * @property int $f_users5 购买频率>=5客户数
  13. * @property int $f_users4 购买频率=4客户数
  14. * @property int $f_users3 购买频率=3客户数
  15. * @property int $f_users2 购买频率=2客户数
  16. * @property int $f_users1 购买频率=1客户数
  17. * @property float $f_total_pay_money5 购买频率>=5累计支付金额
  18. * @property float $f_total_pay_money4 购买频率=4累计支付金额
  19. * @property float $f_total_pay_money3 购买频率=3累计支付金额
  20. * @property float $f_total_pay_money2 购买频率=2累计支付金额
  21. * @property float $f_total_pay_money1 购买频率=1累计支付金额
  22. * @property int|null $status 状态[-1:删除;0:禁用;1启用;]
  23. * @property int $created_at 创建时间
  24. * @property int $updated_at 上次更新数据时间
  25. */
  26. class CensusMallRfAnalysis extends BaseActiveRecord
  27. {
  28. /**
  29. * {@inheritdoc}
  30. */
  31. public static function tableName()
  32. {
  33. return '{{%census_mall_rf_analysis}}';
  34. }
  35. /**
  36. * {@inheritdoc}
  37. */
  38. public function rules()
  39. {
  40. return [
  41. [['mall_id','purchase_interval', 'f_users1', 'f_users2', 'f_users3', 'f_users4', 'f_users5', 'status', 'created_at', 'updated_at'], 'integer'],
  42. [['f_total_pay_money1', 'f_total_pay_money2', 'f_total_pay_money3', 'f_total_pay_money4', 'f_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. 'f_users5' => '购买频率>=5客户数',
  55. 'f_users4' => '购买频率=4客户数',
  56. 'f_users3' => '购买频率=3客户数',
  57. 'f_users2' => '购买频率=2客户数',
  58. 'f_users1' => '购买频率=1客户数',
  59. 'f_total_pay_money5' => '购买频率>=5累计支付金额',
  60. 'f_total_pay_money4' => '购买频率=4累计支付金额',
  61. 'f_total_pay_money3' => '购买频率=3累计支付金额',
  62. 'f_total_pay_money2' => '购买频率=2累计支付金额',
  63. 'f_total_pay_money1' => '购买频率=1累计支付金额',
  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'],
  74. 'purchase_interval' => $params['purchase_interval'],
  75. 'status' => [StatusEnum::ENABLED, StatusEnum::DISABLED]]);
  76. if ($model==null) {
  77. $model = new self();
  78. $model->loadDefaultValues();
  79. }
  80. if(!$model->load($params,'') || !$model->save()){
  81. var_dump($model->getErrorMessage());
  82. throw new \Exception($model->getErrorMessage());
  83. }
  84. return $model;
  85. } catch (\Exception $e) {
  86. self::$static_error = $e->getMessage();
  87. return false;
  88. }
  89. }
  90. }