book_admin/application/api/controller/Tdcapi.php

<?php
/**
 * Created by: PhpStorm
 * User: lytian
 * Date: 2020/3/3
 * Time: 16:24
 */

namespace app\api\controller;


use app\common\controller\Api;
use think\Config;
use think\Db;
use think\Log;

class Tdcapi extends Api
{
    public function shoplist()
    {
        Log::info("params:".json_encode($this->request->param()));
        $content = '';
        $channel_id = Config::get('site.tdc_bookinfo_url_channel') ?: 7349;
        $dbConfig = Config::get("expanddb");
        $rows = Db::connect($dbConfig)->query("SELECT * FROM gdt_book");
        if ($rows) {
            $content = <<<EOF
<product_set>
EOF;
;
            foreach ($rows as $row) {
                $description = str_replace([''], [""], $row['description']);
                $path = '/index/book/info?book_id='.$row['book_id'];
                $webUrl = getCurrentDomain($channel_id, $path);
                $content .= <<<EOF
                
  <product>            
    <product_id>{$row['book_id']}</product_id>
    <product_name>{$row['book_name']}</product_name>
    <first_category_name>{$row['first_category_name']}</first_category_name>
    <second_category_name>{$row['second_category_name']}</second_category_name>
    <third_category_name></third_category_name>
    <fourth_category_name></fourth_category_name>
    <first_category_id>{$row['first_category_id']}</first_category_id>
    <second_category_id>{$row['second_category_id']}</second_category_id>
    <third_category_id></third_category_id>
    <fourth_category_id></fourth_category_id>
    <author>{$row['author']}</author>
    <description><![CDATA[{$description}]]></description>
    <video_url></video_url>
    <semantic_label></semantic_label>
    <image_url>{$row['cover_image']}</image_url>
    <additional_image_url></additional_image_url>
    <expiration_time>{$row['expire_date']}</expiration_time>
    <additional_video_url></additional_video_url>
    <target_url_android></target_url_android>
    <target_url_ios></target_url_ios>
    <target_url_mobile>{$webUrl}</target_url_mobile>
    <target_url_wechat>{$webUrl}</target_url_wechat>
    <universal_link></universal_link>
    <additional_target_url_mobile></additional_target_url_mobile>
    <additional_target_url_android></additional_target_url_android>
    <additional_target_url_ios></additional_target_url_ios>
    <additional_target_url_wechat></additional_target_url_wechat>
    <additional_universal_link></additional_universal_link>
    <target_url_mini_program_id></target_url_mini_program_id>
    <target_url_mini_program_path></target_url_mini_program_path>
    <additional_target_url_mini_program_id></additional_target_url_mini_program_id>
    <additional_target_url_mini_program_path></additional_target_url_mini_program_path>
    <favorite_count></favorite_count>
    <like_count></like_count>
    <comment_count></comment_count>
    <author_fans_count></author_fans_count>
    <ratings></ratings>
    <if_new_book>{$row['isnew']}</if_new_book>
  </product>
EOF;
            }
            $content .= <<<EOF
            
</product_set>
EOF;
            ;
        }
    exit($content);
    }
}