<?php
// +----------------------------------------------------------------------
// | ThinkCMF [ WE CAN DO IT MORE SIMPLE ]
// +----------------------------------------------------------------------
// | Copyright (c) 2013-2018 http://www.thinkcmf.com All rights reserved.
// +----------------------------------------------------------------------
// | Licensed ( http://www.apache.org/licenses/LICENSE-2.0 )
// +----------------------------------------------------------------------
// | Author: 老猫 <thinkcmf@126.com>
// +----------------------------------------------------------------------
namespace app\portal\controller;

use cmf\controller\HomeBaseController;
use app\portal\model\PortalCategoryModel;
use app\portal\model\PortalPostModel;
use think\Db;

class SitemapController extends HomeBaseController
{
    public function index()
    {
        $site = $this->siteinfo();
        $url = $site."/\r\n";
        $html = '<a href="'.$site.'/">首页</a>';
        $xml = '<?xml version="1.0" encoding="utf-8"?><urlset><url><loc>'.$site.'/</loc></url>';
        $portalCategoryModel = new PortalCategoryModel();
        $category = $portalCategoryModel->where('status', 1)->where('delete_time', 0)->select();
        foreach($category as $val)
        {
            $geturl = $this->geturl('portal/List/index?id='.$val['id'].'');
            $url .= $site."/".$geturl['url'].".html\r\n";
            $html .= '<a href="'.$site.'/'.$geturl['url'].'.html">'.$val['name'].'</a>'."<br>";
            $xml .= '<url><loc>'.$site.'/'.$geturl['url'].'.html</loc></url>';
        }
        $PortalPostModel = new PortalPostModel();

        $where['post_status'] = '1';
        $where['post_type'] = '2';
        $article = $PortalPostModel->where($where)->where('delete_time', 0)->select();
        foreach($article as $value)
        {
            $geturl = $this->geturl('portal/Page/index?id='.$value['id'].'');
            if(empty($geturl['url']))
            {
                $url .= $site."/portal/Page/index?id=".$value['id']."\r\n";
                $html .=  '<a href="'.$site.'/portal/Page/index?id='.$value['id'].'">'.$value['post_title'].'</a>'."<br>";
                $xml .= '<url><loc>'.$site.'/portal/Page/index?id='.$value['id'].'</loc></url>';
            }
            else
            {
                $url .= $site."/".$geturl['url'].".html"."\r\n";
                $html .=  '<a href="'.$site.'/'.$geturl['url'].'.html">'.$value['post_title'].'</a>'."<br>";
                $xml .= '<url><loc>'.$site.'/'.$geturl['url'].'.html</loc></url>';
            }
        }
        $where['post_status'] = '1';
        $where['post_type'] = '1';
        $article = $PortalPostModel->where($where)->where('delete_time', 0)->select();
        foreach($article as $value)
        {
            $url .= $site."/article/".$value['id'].".html"."\r\n";
            $html .=  '<a href="'.$site.'/article/'.$value['id'].'.html">'.$value['post_title'].'</a>'."<br>";
            $xml .= '<url><loc>'.$site.'/article/'.$value['id'].'.html</loc></url>';
        }
        $xml .= '</urlset>';
        $this->updatetxt($url);
        $this->updatexml($xml);
    }
    private function geturl($url)
    {
        $result = Db::name('route')->where(["full_url"=>$url])->find();
        return $result;
    }
    private function siteinfo()
    {
        $result = Db::name('option')->find();
        $resultarr = json_decode($result['option_value'],true);
        return $resultarr['site_url'];
    }
    private function updatetxt($data)
    {
        $this->writefile('txt',$data);
    }
    private function updatexml($data)
    {
        $this->writefile('xml',$data);
    }
    private function writefile($type,$data)
    {
        $myfile = fopen($_SERVER['DOCUMENT_ROOT']."/site.".$type, "w") or die("Unable to open file!");
        fwrite($myfile, $data);
        fclose($myfile);
    }
}

评论