<?php
/**
 * Created by PhpStorm.
 * User: ZCY
 * Date: 2018/10/15
 * Time: 20:41
 */
namespace common\models\psources;

use common\core\BaseActiveRecord;
use Yii;

class CoinApplication extends BaseActiveRecord
{
    public static function getDb()
    {
        return Yii::$app->get('p_sources');
    }

    public static function tableName()
    {
        return '{{%coin_application}}';
    }

    public function beforeSave($instert)
    {
        if (parent::beforeSave($instert)) {
            if ($this->isNewRecord) {
                $this->create_time = Yii::$app->formatter->asTimestamp('now');
            } else {
                $this->update_time = Yii::$app->formatter->asTimestamp('now');
            }
            return true;
        } else {
            return false;
        }
    }

    public static function getList($page = 1, $limit = 10, $condition = [], $order_by = ['sort' => SORT_ASC], $select = [])
    {
        $query = self::find();
        foreach($condition as $item){
            $query = $query->andWhere($item);
        }
        $count = $query->count();
        $data  = $query->offset(($page - 1) * 10)->limit($limit)->orderby($order_by);
        $data = $data->asArray()->all();
        $icon_Items = array_column($data,'icon');
        $icon_Infos = CoinImage::getItemsByIds($icon_Items);
        $recommendItems = CoinApplicateRecommend::getRecommendItemsByType(2);
        foreach($data as $key => &$value){
            if($value['icon']){
                $value['icon_url'] = $icon_Infos[$value['icon']]['base_url'].$icon_Infos[$value['icon']]['file_url'];
            }else{
                $value['icon_url'] = '';
            }
            if($value['h5_url']){
                $value['has_h5'] = 1;
            }else{
                $value['has_h5'] = 0;
            }
            if($value['android_url']){
                $value['has_android'] = 1;
            }else{
                $value['has_android'] = 0;
            }
            $has_ios_url = $value['ios_url']?1:0;
            $has_app_store = $value['app_store_url']?1:0;
            if($has_ios_url && $has_app_store){
                $value['has_ios'] = 3;
            }else if($has_ios_url){
                $value['has_ios'] = 1;
            }else if($has_app_store){
                $value['has_ios'] = 2;
            }else{
                $value['has_ios'] = 0;
            }
            if(isset($recommendItems[$value['id']])){
                $value['isrecommend'] = 1;
            }
        }
        return ['count' => $count, 'data' => $data, 'code' => 0];
    }

    public static function getApplicateById($id)
    {
        return self::find()->where(['id' => $id])->asArray()->one();
    }

    public static function getApplicate($id)
    {
        return self::find()->where(['id' => $id])->one();
    }
}