const mysql = require('./mysql');
const {searchSql,limitSql} = require("../tools/searchSql");
const log = require("../logger").logger("d_solution","info");

function loadSolution(key, page, limit) {
  let sql = ``;
  let values = [];
  sql += `SELECT
            news.id,
            news.remark,
            news.title as name,
            news.image,
            news.source_val as source,
            news.sourceType
          FROM
            hfy_news as news ,
            hfy_news_type as n_type
          WHERE
            news.type_id = n_type.type_id
            and n_type.parent_type = 1
            and n_type.type_key = ?`;
  values = [key];
  let _limitSql = limitSql(limit,page);
  sql += _limitSql.sql;
  values.push(..._limitSql.values);
  log.info(sql);

  console.log(sql)
  console.log(values)
  return mysql.pq(sql, values);
}


module.exports = {
  loadSolution
}