hfysite/server/database/d_product.js

const mysql = require('./mysql');
const {searchSql,limitSql} = require("../tools/searchSql");
const log = require("../logger").logger("d_product","info")
function loadProducts(key, page, limit) {
  let sql = ``;
  let values = [];
  sql += `SELECT
            p.proid as id,p.remark,p.name,p.image,p.source,p.sourceType
          FROM
            hfy_product as p ,
            hfy_product_type as p_type
          WHERE
            p.type_id = p_type.type_id
            and p_type.type_key = ?`;
  values = [key];
  let _limitSql = limitSql(limit,page);
  sql += _limitSql.sql;
  values.push(..._limitSql.values);
  console.log(sql);
  console.log(values);
  log.info("test");
  log.info(sql);
  return mysql.pq(sql, values);
}

function getProductInfo(id) {
  let sql = ``;
  let values = [];
  sql += `SELECT
              p.*
          FROM
            hfy_product as p
          WHERE
            p.proid = ?`;
  values = [id];
  return mysql.pq(sql, values);
}

function searchProducts(type='array',searchParam,page,limit){
  let sql = ``;
  let values = [];
  if(type === 'count'){
    sql = `select count(*) as total from hfy_product where 1=1`;
  }else{
    sql = `select * from hfy_product where 1=1`;
  }
  if(searchParam.key){
    sql += ` and name like '%${searchParam.key}%'`
  }
  return searchSql(mysql.pq,type,sql,values,limit,page);
}

module.exports = {
  loadProducts,
  getProductInfo,
  searchProducts
}