hfysite/server/database/d_solution.js

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);
  return mysql.pq(sql, values);
}

function searchSolution(type='array',searchParam,page,limit){
  let sql;
  let values = [];
  if(type === 'count'){
    sql = `select count(*) as total `;
  }else{
    sql = `select
    news.id,
    news.remark,
    news.title as name,
    news.image,
    news.source,
    news.sourceType,
    n_type.type_key
    `;
  }
  sql += `
   from
   hfy_news as news ,
   hfy_news_type as n_type
  `
  sql += ` where news.type_id = n_type.type_id`
  if(searchParam.parentType) {
    sql += ` and n_type.parent_type = ?`
    values.push(searchParam.parentType);
  }

  if(searchParam.key){
    sql += ` and news.title like '%${searchParam.key}%'`
  }

  if(searchParam.type){
    sql += ` and n_type.type_key = ?`
    values.push(searchParam.type)
  }
  return searchSql(mysql.pq,type,sql,values,limit,page);
}

function getSolutionInfo(id) {
  let sql = ``;
  let values = [];
  sql += `SELECT
            news.*
          FROM
            hfy_news as news
          WHERE
            news.id = ?`;
  values = [id];
  return mysql.pq(sql, values);
}

module.exports = {
  loadSolution,
  searchSolution,
  getSolutionInfo

}