ZZCX_yii/backend/modules/api/models/BaseArea.php

<?php

namespace backend\modules\api\models;

use yii\db\ActiveRecord;

/**
 * This is the model class for table "base_area".
 *
 * @property integer $ID
 * @property integer $PARENT_ID
 * @property integer $CANCEL_FLAG
 * @property integer $CREATE_USER_ID
 * @property string $CREATE_TIME
 * @property integer $UPDATE_USER_ID
 * @property string $UPDATE_TIME
 * @property string $AREA_NAME
 * @property string $POSTCODE
 * @property string $POI_TYPE
 * @property integer $POI_TYPE1
 * @property string $POI_TYPE2
 */
class BaseArea extends ActiveRecord
{
    /**
     * @inheritdoc
     */
    public static function tableName()
    {
        return 'base_area';
    }

    /**
     * @inheritdoc
     */
    public function rules()
    {
        return [
            [['ID', 'UPDATE_TIME', 'AREA_NAME'], 'required'],
            [['ID', 'PARENT_ID', 'CANCEL_FLAG', 'CREATE_USER_ID', 'UPDATE_USER_ID', 'POI_TYPE1'], 'integer'],
            [['CREATE_TIME', 'UPDATE_TIME', 'POSTCODE', 'POI_TYPE'], 'string', 'max' => 20],
            [['AREA_NAME'], 'string', 'max' => 100],
            [['POI_TYPE2'], 'string', 'max' => 255],
        ];
    }

    /**
     * @inheritdoc
     */
    public function attributeLabels()
    {
        return [
            'ID' => 'ID',
            'PARENT_ID' => '父记录ID，DICT_TYPE.ID',
            'CANCEL_FLAG' => '记录有效性标记，CANCEL_FLAG=0记录有效；CANCEL_FLAG=1，记录已删除',
            'CREATE_USER_ID' => '记录创建用户ID',
            'CREATE_TIME' => '记录创建时间',
            'UPDATE_USER_ID' => '记录最后更新用户ID',
            'UPDATE_TIME' => '记录最后更新时间',
            'AREA_NAME' => 'Area  Name',
            'POSTCODE' => '邮编',
            'POI_TYPE' => 'POI类型',
            'POI_TYPE1' => '类别',
            'POI_TYPE2' => '类型',
        ];
    }


    /**
     * Function Description:获取分页数组
     * Function Name: getPage
     *
     * @param int $total_row 总条数
     * @param int $page_size 每页条数
     * @param int $current_page 当前页
     *
     * @return array
     *
     * @author 张帅
     */
    public function getPage($total_row, $page_size, $current_page)
    {
        $total_page = ceil($total_row / $page_size);
        if ($total_page <= 1) {
            $page_arr = [];
            return $page_arr;
        }
        #region 页首
        $page_arr = ['首页', '<上一页', 1];
        #endregion

        #region 页前
        if ($current_page <= 5) {
            for ($i = 2; $i <= $current_page; $i++) {
                $page_arr[] = $i;
            }
        } else {
            if ($total_page > 6) {
                $page_arr[] = '...';
            }
            if ($total_page - $current_page <= 2) {
                for ($i = $total_page - 4; $i <= $current_page; $i++) {
                    $page_arr[] = $i;
                }
            } else {
                $page_arr[] = $current_page - 2;
                $page_arr[] = $current_page - 1;
                $page_arr[] = $current_page;
            }
        }
        #endregion

        #region 页后
        if ($total_page - $current_page <= 4) {
            for ($i = $current_page + 1; $i < $total_page; $i++) {
                $page_arr[] = $i;
            }
        } else {
            if ($current_page >= 3) {
                $page_arr[] = $current_page + 1;
                $page_arr[] = $current_page + 2;
                if ($total_page > 6) {
                    $page_arr[] = '...';
                }
            } else {
                for ($i = $current_page + 1; $i <= 5; $i++) {
                    $page_arr[] = $i;
                }
                if ($total_page > 6) {
                    $page_arr[] = '...';
                }
            }
        }
        #endregion

        #region 页尾
        if ($current_page != $total_page) {
            $page_arr[] = $total_page;
        }
        $page_arr[] = '下一页>';
        $page_arr[] = '末页';
        #endregion

        return $page_arr;
    }

    /**
     * Des:获取信息
     * Name: getInfo
     * @param $name
     * @return array
     * @author 倪宗锋
     */
    public function getInfoByName($name)
    {
        $info = self::find()
            ->from(self::tableName())
            ->where(['=', 'AREA_NAME', $name])
            ->asArray()
            ->one();
        return $info;
    }
}