talent_map/server/api/modules/v1/controllers/CommonController.php

<?php
/**
 * Created by PhpStorm.
 * User:  NODELOG
 * Date: 2017/4/14
 * Time: 下午10:49
 */

namespace api\modules\v1\controllers;


use api\common\controllers\Controller;
use api\modules\v1\models\Category;
use api\modules\v1\models\Team;
use api\modules\v1\models\TeamMember;
use common\enums\CodeEnum;
use common\helpers\Regexp;
use common\helpers\Util;
use common\models\Article;
use common\models\Page;
use common\modules\attachment\components\UploadedFile;
use common\modules\attachment\models\Attachment;
use common\modules\config\models\Config;
use PhpOffice\PhpSpreadsheet\Cell\Coordinate;
use PhpOffice\PhpSpreadsheet\IOFactory;
use Yii;
use yii\captcha\Captcha;
use yii\helpers\ArrayHelper;
use yii\helpers\StringHelper;
use yii\web\Response;

class CommonController extends Controller
{

    /**
     * 单页内容
     * @return array
     */
    public function actionPage()
    {
        $slug = request('slug');
        if (!$slug) {
            return ['errcode' => CodeEnum::CODE_ERROR, 'errmsg' => '页面未找到'];
        }

        $page = Page::findOne(['slug' => $slug]);
        if (empty($page)) {
            return ['errcode' => CodeEnum::CODE_ERROR, 'errmsg' => '页面未找到'];
        }

        return ['data' => $page];
    }

    /**
     * @return array
     * @api {get} /v1/common/configs 平台配置
     * @apiGroup 通用接口
     * @apiVersion 1.0.0
     *
     * @apiSuccess {Number} errcode    状态码，0：请求成功
     * @apiSuccess {String} errmsg   提示信息
     * @apiSuccess {Object} data    配置信息
     *
     * @apiError {Number} errcode    状态码，500：请求失败
     * @apiError {String} errmsg   提示信息
     *
     * @apiSuccessExample {json} 成功响应:
     * {"errcode":0,"errmsg":"ok","data":{}}
     *
     * @apiErrorExample {json} 失败响应:
     * {"errcode":500,"errmsg":"请求失败"}
     *
     * @author nodelog
     */
    public function actionConfig()
    {
        $config = ArrayHelper::map(Config::find()->where(['group' => ['site', 'mobile', 'pc']])->select(['name', 'value'])->all(), 'name', 'value');
        //自动判断数组
        $config['hot_search'] = Yii::$app->config->get('hot_search');

        return ['data' => $config];
    }

    /**
     * @return array
     * @throws \yii\db\Exception
     * @api {post} /v1/common/upload 上传文件
     * @apiGroup 通用接口
     * @apiVersion 1.0.0
     *
     * @apiHeader {String} Content-Type 内容类型.
     * @apiHeader {String} accept 传输方式.
     * @apiHeaderExample {json} Header-Example:
     *     {
     *       "Content-Type": "multipart/form-data",
     *       'accept': 'application/json',
     *     }
     *
     * @apiParam  {String} file 上传文件表单名
     *
     * @apiSuccess {Number} errcode    状态码，0：请求成功
     * @apiSuccess {String} errmsg   提示信息
     * @apiSuccess {Object} data    服务器上文件信息
     *
     * @apiError {Number} errcode    状态码，500：请求失败
     * @apiError {String} errmsg   提示信息
     *
     * @apiSuccessExample {json} 成功响应:
     * {"errcode":0,"errmsg":"ok","data":{}}
     *
     * @apiErrorExample {json} 失败响应:
     * {"errcode":500,"errmsg":"请求失败"}
     *
     * @author nodelog
     */
    public function actionUpload()
    {
        $transaction = Yii::$app->db->beginTransaction();
        try {
            $files = UploadedFile::getInstancesByName('file');
            $attachment = Attachment::uploadFromPost(date('Ymd'), $files[0]);
            $transaction->commit();

            return ['data' => $attachment];
        } catch (\Exception $e) {
            $transaction->rollback();

            return ['errcode' => CodeEnum::CODE_ERROR, 'errmsg' => $e->getMessage()];
        }
    }

    /**
     * 平台版本号
     * @return array|mixed
     * @author nodelog
     */
    public function actionVersion()
    {
        return ['data' => Yii::$app->config->get('version')];
    }

    /**
     * @return array
     * @throws \yii\web\ServerErrorHttpException
     * @author nodelog
     */
    public function actionTest()
    {

        $list = \common\models\Category::find()->where([])->select('title')->column();
        Yii::$app->response->format = Response::FORMAT_JSON;

        return ['data' => $list];


        //分类
        /* @var $cateList \common\models\Category[] */
        $cateList = Category::find()->where(['like', 'title', '表%', false])->orderBy(['id' => SORT_ASC])->all();


        /* 读取excel */
        $fileName = \Yii::getAlias('@storagePath/upload/data.xlsx');//path
        $inputFileType = IOFactory::identify($fileName);
        $reader = IOFactory::createReader($inputFileType);
        $spreadsheet = $reader->load($fileName);
        $reader->setReadDataOnly(true); // 设置后无法获取excel中的图片
        $worksheetList = $spreadsheet->getAllSheets();
        $excelData = [];
        foreach ($worksheetList as $index => $worksheet) {
            $highestRow = $worksheet->getHighestRow(); // 取得总行数
            $highestColumn = $worksheet->getHighestColumn(); // 取得总列数
            $highestColumnIndex = Coordinate::columnIndexFromString($highestColumn); // 取得总列数

            $category = $cateList[$index];
            for ($row = 1; $row <= $highestRow; $row++) {
                //一行一条数据
                $data = [];
                for ($col = 1; $col <= $highestColumnIndex; $col++) {
                    $val = (string)$worksheet->getCellByColumnAndRow($col, $row)->getValue();

                    //第一行初始化
                    if ($row == 1 && $col == 1) {
                        $attr = [];
                    }
                    if ($row == 1) {
                        $attr[$col] = $this->getAttrByTitle($val);
                    } else {
                        if (!$data[$attr[$col]]) {

                            $data[$attr[$col]] = $val;
                        } else {
                            $data[$attr[$col]] = $data[$attr[$col]] . $val;

                        }
                    }
                }
                //一行完整数据取完
                if ($row != 1) {
                    if ($data['sort'] != "") {
                        $excelData[] = [
                            'sort' => $data['sort'],
                            'title' => $data['title'],
                            'company' => $data['company'] ? $data['company'] : '',
                            'position' => $data['position'] ? $data['position'] : '',
                            'chain' => $data['chain'] ? $data['chain'] : '',
                            'principal' => $data['principal'] ? $data['principal'] : '',
                            'intro' => $data['intro'] ? $data['intro'] : '',
                            'description' => $this->generateDesc($data['intro']),
                            'city' => $data['city'] ? $data['city'] : '',
                            'address' => $data['address'] ? $data['address'] : '',
                            'tel' => $data['tel'] ? $data['tel'] : '',
                            'category_id' => $category->id,
                            'category' => $category->title,
                            'module' => $category->module,
                        ];
                    } else {
                        //合并数据
                        foreach ($data as $key => $value) {
                            $excelData[count($excelData) - 1][$key] .= $value;
                        }
                    }
                }
            }
        }

        Yii::$app->db->createCommand()->batchInsert(Article::tableName(), ['sort', 'title', 'company', 'position', 'chain', 'principal', 'intro', 'description', 'city', 'address', 'tel', 'category_id', 'category', 'module'], $excelData)->execute();

        return ['data' => ['count' => count($excelData), 'list' => $excelData]];

    }


    private function getAttrByTitle($title)
    {
        switch ($title) {
            //基本信息
            case '序号':
                return 'sort';
            case '姓名':
            case '名称':
            case '基地名称':
            case '产业集群':
            case '企业名称':
            case '商会名称':
                return 'title';
            case '城市':
            case '区域':
            case '国内城市分布':
            case '常住地':
                return 'city';
            case '地址':
                return 'address';
            case '联系方式':
            case '商会电话':
                return 'tel';
            //扩展信息

            case '公司':
            case '企业':
            case '单位':
            case '单位名称':
                return 'company';
            case '职务':
                return 'position';

            case '专长方向':
            case '研究领域':
            case '研究方向':
            case '简介':
            case '基地特色':
            case '科室/研究方向':
            case '专长方向/荣誉':
            case '投资产业领域':
            case '主要产品':
            case '个人简介':
                return 'intro';
            case '产业领域':
            case '产业类别':
            case '产业链':
            case '细分方向':
            case '细分领域':
            case '重点投资行业/研究领域':
                return 'chain';
            case '负责人':
            case '秘书长':
            case '法人':
                return 'principal';
        }
    }

    // 摘要生成方式
    private function generateDesc($intro)
    {

        if (empty($intro)) {
            return '';
        }
        return StringHelper::truncate(preg_replace('/\s+/', ' ', strip_tags($intro)), 150);
    }
}