| 1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980818283848586878889909192939495969798 |
- <?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_rf_analysis".
- *
- * @property int $id ID
- * @property int $mall_id 商城ID
- * @property int $purchase_interval 购买间隔时间天
- * @property int $f_users5 购买频率>=5客户数
- * @property int $f_users4 购买频率=4客户数
- * @property int $f_users3 购买频率=3客户数
- * @property int $f_users2 购买频率=2客户数
- * @property int $f_users1 购买频率=1客户数
- * @property float $f_total_pay_money5 购买频率>=5累计支付金额
- * @property float $f_total_pay_money4 购买频率=4累计支付金额
- * @property float $f_total_pay_money3 购买频率=3累计支付金额
- * @property float $f_total_pay_money2 购买频率=2累计支付金额
- * @property float $f_total_pay_money1 购买频率=1累计支付金额
- * @property int|null $status 状态[-1:删除;0:禁用;1启用;]
- * @property int $created_at 创建时间
- * @property int $updated_at 上次更新数据时间
- */
- class CensusMallRfAnalysis extends BaseActiveRecord
- {
- /**
- * {@inheritdoc}
- */
- public static function tableName()
- {
- return '{{%census_mall_rf_analysis}}';
- }
- /**
- * {@inheritdoc}
- */
- public function rules()
- {
- return [
- [['mall_id','purchase_interval', 'f_users1', 'f_users2', 'f_users3', 'f_users4', 'f_users5', 'status', 'created_at', 'updated_at'], 'integer'],
- [['f_total_pay_money1', 'f_total_pay_money2', 'f_total_pay_money3', 'f_total_pay_money4', 'f_total_pay_money5'], 'number'],
- ];
- }
- /**
- * {@inheritdoc}
- */
- public function attributeLabels()
- {
- return [
- 'id' => 'ID',
- 'mall_id' => '商城ID',
- 'purchase_interval' => '购买间隔时间天',
- 'f_users5' => '购买频率>=5客户数',
- 'f_users4' => '购买频率=4客户数',
- 'f_users3' => '购买频率=3客户数',
- 'f_users2' => '购买频率=2客户数',
- 'f_users1' => '购买频率=1客户数',
- 'f_total_pay_money5' => '购买频率>=5累计支付金额',
- 'f_total_pay_money4' => '购买频率=4累计支付金额',
- 'f_total_pay_money3' => '购买频率=3累计支付金额',
- 'f_total_pay_money2' => '购买频率=2累计支付金额',
- 'f_total_pay_money1' => '购买频率=1累计支付金额',
- '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 ($model==null) {
- $model = new self();
- $model->loadDefaultValues();
- }
- if(!$model->load($params,'') || !$model->save()){
- var_dump($model->getErrorMessage());
- throw new \Exception($model->getErrorMessage());
- }
- return $model;
- } catch (\Exception $e) {
- self::$static_error = $e->getMessage();
- return false;
- }
- }
- }
|