| 123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293 |
- <?php
- namespace common\models\census;
- use common\enums\StatusEnum;
- use common\models\base\BaseActiveRecord;
- use Yii;
- /**
- * This is the model class for table "qimall_census_mall_rm_analysis".
- *
- * @property int $id ID
- * @property int $mall_id 商城ID
- * @property int $purchase_interval 购买间隔时间天
- * @property int $m_users5 M-消费金额>=2000客户数
- * @property int $m_users4 M-消费金额1000<=M<2000客户数
- * @property int $m_users3 M-消费金额500<=M<=1000客户数
- * @property int $m_users2 M-消费金额200<=M<=500客户数
- * @property int $m_users1 M-消费金额m<200客户数
- * @property float $m_total_pay_money5 M-消费金额>=2000累计支付金额
- * @property float $m_total_pay_money4 M-消费金额1000<=M<2000累计支付金额
- * @property float $m_total_pay_money3 M-消费金额500<=M<=1000累计支付金额
- * @property float $m_total_pay_money2 M-消费金额200<=M<=500累计支付金额
- * @property float $m_total_pay_money1 M-消费金额m<200累计支付金额
- * @property int|null $status 状态[-1:删除;0:禁用;1启用;]
- * @property int $created_at 创建时间
- * @property int $updated_at 上次更新数据时间
- */
- class CensusMallRmAnalysis extends BaseActiveRecord
- {
- /**
- * {@inheritdoc}
- */
- public static function tableName()
- {
- return '{{%census_mall_rm_analysis}}';
- }
- /**
- * {@inheritdoc}
- */
- public function rules()
- {
- return [
- [['mall_id','purchase_interval', 'm_users1', 'm_users2', 'm_users3', 'm_users4', 'm_users5', 'status', 'created_at', 'updated_at'], 'integer'],
- [['m_total_pay_money1', 'm_total_pay_money2', 'm_total_pay_money3', 'm_total_pay_money4', 'm_total_pay_money5'], 'number'],
- ];
- }
- /**
- * {@inheritdoc}
- */
- public function attributeLabels()
- {
- return [
- 'id' => 'ID',
- 'mall_id' => '商城ID',
- 'purchase_interval' => '购买间隔时间天',
- 'm_users5' => 'M-消费金额>=2000客户数',
- 'm_users4' => 'M-消费金额1000<=M<2000客户数',
- 'm_users3' => 'M-消费金额500<=M<=1000客户数',
- 'm_users2' => 'M-消费金额200<=M<=500客户数',
- 'm_users1' => 'M-消费金额m<200客户数',
- 'm_total_pay_money5' => 'M-消费金额>=2000累计支付金额',
- 'm_total_pay_money4' => 'M-消费金额1000<=M<2000累计支付金额',
- 'm_total_pay_money3' => 'M-消费金额500<=M<=1000累计支付金额',
- 'm_total_pay_money2' => 'M-消费金额200<=M<=500累计支付金额',
- 'm_total_pay_money1' => 'M-消费金额m<200累计支付金额',
- 'status' => '状态[-1:删除;0:禁用;1启用;]',
- 'created_at' => '创建时间',
- 'updated_at' => '上次更新数据时间',
- ];
- }
- public static function setData($params)
- {
- try {
- if (empty($params['mall_id']) || empty($params['purchase_interval'])) return false;
- $model = self::findOne(['mall_id' => $params['mall_id'], 'purchase_interval' => $params['purchase_interval'], 'status' => [StatusEnum::ENABLED, StatusEnum::DISABLED]]);
- if (empty($model)) {
- $model = new self();
- $model->loadDefaultValues();
- }
- $model->load($params, '');
- if (!$model->save()) throw new \Exception($model->getErrorMessage());
- return $model;
- } catch (\Exception $e) {
- self::$static_error = $e->getMessage();
- return false;
- }
- }
- }
|