alimall.hdlkeji.com/application/api/controller/Community.php

<?php

namespace app\api\controller;

use app\common\controller\Api;
use app\common\model\CooperationConfiguration;
use app\common\model\Document;
use app\common\model\Cooperation;
use app\common\model\DownloadLink;
use app\common\model\Faq;
use app\common\model\TeachingVideo;
use app\common\model\VersionComparison;
use app\common\model\VersionUpdating;
use app\common\model\VersionUpdatingText;
use app\common\model\Visit;
use app\common\model\VisitConfiguration;

/**
 * 社区接口
 */
class Community extends Api
{
//    protected $noNeedLogin = ['document,teaching_video'];
    protected $noNeedLogin = ['*'];

    /**
     * 教学视频列表
     */
    public function teaching_video(){
        $list = [];
        $classify = config('site.goodstype');
        foreach ($classify as $v){
            $data = TeachingVideo::all(function ($query) use ($v){
                $query->where('type',$v)->limit(3);
            });
            array_push($list,$data);
        }
        $this->success('成功',$list);
    }

    /**
     * 教学视频详情
     * @ApiParams (name="type",description="好柿购','多享柿','门柿购','海柿购','柿知识")
     */
    public function teaching_video_x(){
        $data = TeachingVideo::all(function ($query){
            $query->where('type',input('type'))->field('*,TIME_TO_SEC(duration) as total');
        });
        $total = 0;
        foreach ($data as $v){
            $total += $v['total'];
            unset($v['total']);
        }

        $total=$this->changeTimeType($total);
        $list = ['list'=>$data,'total'=>$total];
        $this->success('成功',$list);
    }
    /**
     * 计算视频总时长
     */
    public function changeTimeType($seconds){
        if ($seconds >3600){
            $hours =intval($seconds/3600);
            $minutes = $seconds % 3600;
            $time = $hours.":".gmstrftime('%M:%S',$minutes);
        }else{
            $time = gmstrftime('%H:%M:%S',$seconds);
        }
        return$time;
    }
    /**
     * 文档概览
     */
    public function document_list(){
        $data = Document::all(function ($query){
           $query->where(['pid'=>0,'ismenu'=>1])->order('belong sec');
        });
        $this->success('成功',$data);
    }
    /**
     * 文档列表
     * @ApiParams (name="type",description="0好柿购，1多享柿，2门柿购，3海柿购，4柿知识")
     */
    public function document(){
        switch (input('type')){
            case 0:
                $where = ['belong'=>0];
                break;
            case 1:
                $where = ['belong'=>1];
                break;
            case 2:
                $where = ['belong'=>2];
                break;
            case 3:
                $where = ['belong'=>3];
                break;
            case 4:
                $where = ['belong'=>4];
        }
//        $data = Document::where($where)
//            ->where(['ismenu'=>1,'pid'=>0])
//            ->with(['subset'=>function($query)use{
//
//            }])
//            ->field('id,pid,title,weigh,ismenu')
//            ->order('weigh desc')
//            ->select();
        $data = Document::where($where)->field('id,pid,title,weigh,ismenu,belong')->order('weigh desc')->select();
        $res = [];
        foreach ($data as $k=>$v){
            array_push($res,$v->toarray());
        }
        $list = $this->getTree($res,'id','pid','children');
        $this->success('返回成功', $list);
    }
    /**
     * 树形化
     * @param $arr
     * @param $id
     * @param $fid
     * @param $child_name
     * @return array
     */
    function getTree($arr, $id = 'id', $fid = 'fid', $child_name = 'children'){
        $refer = array();
        $tree = array();
        foreach ($arr as $k => $v) {
            $refer[$v[$id]] = &$arr[$k]; //创建主键的数组引用
        }
        foreach ($arr as $k => $v) {
            $pid = $v[$fid]; //获取当前分类的父级id
            if ($pid == 0) {
                $tree[] = &$arr[$k]; //顶级栏目
            } else {
                if (isset($refer[$pid])) {
                    $refer[$pid][$child_name][] = &$arr[$k]; //如果存在父级栏目，则添加进父级栏目的子栏目数组中
                }
            }
        }
        return $tree;
    }
    /**
     * 文档详情
     * @ApiParams (name="id",description="")
     */
    public function document_details(){
        $this->success('成功',Document::where(['id'=>$this->request->post('id')])->value('content'));
    }
    /**
     * 成为合作伙伴
     * @ApiParams (name="token")
     * @ApiParams (name="name",description="姓名")
     * @ApiParams (name="phone",description="联系方式")
     * @ApiParams (name="company",description="公司名称")
     */
    public function become_cooperation(){
        $rule = [
            'name|姓名'=>'require',
            'phone|联系方式'=>'require',
            'company|公司名称'=>'require',
        ];
        $data = $this->_validate($rule);

        $data['uid'] = $this->auth->id;
        Cooperation::create($data)?$this->success('提交成功'):$this->error('提交失败');
    }
    /**
     * 预约参观公司
     * @ApiParams (name="token")
     * @ApiParams (name="name",description="称呼")
     * @ApiParams (name="phone",description="手机号")
     * @ApiParams (name="visit_time",description="参观时间")
     */
    public function visit(){
        $rule = [
            'name|称呼'=>'require',
            'phone|手机号'=>'require',
            'visit_time|参观时间'=>'require',
        ];
        $data = $this->_validate($rule);

        $data['uid'] = $this->auth->id;
        Visit::insert($data)?$this->success('提交成功'):$this->error('提交失败');
    }
    /**
     * 下载地址
     */
    public function download_link(){
        $link = DownloadLink::all();
        foreach ($link as &$value){
            $value['image'] = explode(',',$value['image']);
        }
        $this->success('请求成功',$link);
    }

    /**
     * 版本对比
     */
    public function version_comparison(){
        $link = VersionComparison::all();
        foreach ($link as &$value){
            $value['image'] = explode(',',$value['image']);
        }
        $this->success('请求成功',$link);
    }

    /**
     * 版本更新列表
     */
    public function version_updating(){
        $data = VersionUpdating::all();
        $res = [];
        foreach ($data as $k=>$v){
            array_push($res,$v->toarray());
        }
        $list = $this->getTree($res,'id','pid','children');
        $this->success('请求成功',$list);
    }
    /**
     * 版本更新内容
     * @ApiParams(name='id')
     */
    public function version_updating_content(){
        $data = VersionUpdatingText::all(['classify_id'=>input('id')]);
        $this->success('请求成功',$data);
    }
    /**
     * 版本更新分类（3级）
     * @ApiParams (name="id")
     */
    public function version_updating_three(){
        $data = VersionUpdating::all(['pid'=>input('id'),'ismenu'=>0]);
        $this->success('请求成功',$data);
    }
    /**
     * 论坛
     */
    public function luntan(){
    }
    /**
     * 成为合作伙伴
     */
    public function cooperation_configuration(){
        $res = CooperationConfiguration::all();
        foreach ($res as $k=>&$v){
            $v['image'] = explode(',',$v['image']);
        }
        $this->success('请求成功',$res);
    }
    /**
     * 参观公司
     */
    public function visit_configuration(){
        $res = VisitConfiguration::all();
        foreach ($res as $k=>&$v){
            $v['image'] = explode(',',$v['image']);
        }
        $this->success('请求成功',$res);
    }
    /**
     * 常见问题
     */
    public function faq(){
        $res = Faq::all();
        $this->success('请求成功',$res);
    }
    /**
     * 常见问题浏览
     */
    public function browse_faq(){
        $res = Faq::all();
        foreach ($res as $v){
            $v->getQuery()->where('id',$v['id'])->inc('browse')->update();
        }
        $this->success('请求成功');
    }

}