srv/src/controllers/generate.js - master - lablist/papyrus

srv/src/controllers/generate.js
220 строк7 KB
bubeew
First init.
01 мар 2024, 17:26
01 мар 2024, 17:265d5fca2
const {
  existsSync,
  mkdirSync,
  writeFileSync
} = require("fs");
const path = require("path");
const ejs = require("ejs");
const _ = require("lodash");
const { query, queryOne } = require("../database");
const {
  status,
  statusSuccess,
  statusError
} = require("../helpers/status");
const {
  _getDTree
} = require("./directions");
const {
  _getPrices
} = require("./prices");
const {
  _getPriceTypes
} = require("./priceTypes");
const {
  notFilledArray
} = require("../helpers/validations");

const appPath = path.resolve();

const leafIdType= "direction_type_id";
const leafIdName = "id_direction";
const branchIdName = "parent_id";
const orderName = "rate";
const pathName = "direction_path_name";
const humanName = "human_name";

const leafTypes = {
  prices: 4,
  contacts: 8
}

function getBranch(nodes, pid="0") {
  return nodes.filter((l)=>{
    return (Number(l[branchIdName]) === Number(pid) && l.active)
  }).sort((a,b)=>(Number(a[orderName]) - Number(b[orderName])))
}

function leaf(nodes, leafItem, leafIndex) {
  const leafId = leafItem[leafIdName];
  const branch = getBranch(nodes, leafId);
  const aHref = `/${leafItem[pathName]}.html`;
  if (notFilledArray(branch)) {
    return `<li><a href="${aHref}">${leafItem[humanName]}</a></li>`;
  }
  return `<li><span class="opener">${leafItem[humanName]}</span>${branches(nodes, leafId)}</li>`;
};

function branches(nodes, pid) {
  const branch = getBranch(nodes, pid);
  if (!notFilledArray(branch)) {
    return `<ul>${branch.map((leafItem, leafIndex) => leaf(nodes, leafItem, leafIndex)).join("")}</ul>`;
  }
}


function getPriceRows(prices=[], tid) {
  return prices.filter((l)=>{
    return (Number(l.typeid) === Number(tid))
  }).sort((a,b)=>(Number(a[orderName]) - Number(b[orderName])))
}

function getPricesTable(pType, prices=[]) {
  if (notFilledArray(prices)) {
    return "";
  }
  const rows = getPriceRows(prices, pType?.id);
  if (!notFilledArray(rows)) {
    return `
        <h4>${pType?.name || ""}</h4>
        <div class="table-wrapper">
          <table class="alt">
            <thead>
              <tr><th>Код услуги</th><th>Наименование услуги</th><th>Цена услуги</th></tr>
            </thead>
            <tbody>
              ${rows.map((rowItem) => (`<tr><td>${rowItem.code}</td><td>${rowItem.name}</td><td>${rowItem.price}</td></tr>`)).join("")}
            </tbody>
            <tfoot>
              <tr><td colspan="3"></td></tr>
            </tfoot>
          </table>
        </div>
      `;
  }
}

const dict = {
  success: {
    created: "Сайт создан.",
  },
  errors: {
    unknown: "Неизвестная ошибка.",
    template: "Ошибка сборки шаблона страницы."
  }
}

const all = async (req, res) => {
  try {
    const cData = await queryOne('SELECT * FROM company LIMIT 1;');
    const pages = await query('SELECT * FROM pages;');

    const homePathStr = path.join(appPath, "/src/views/pages/home.ejs");
    const pagePathTmpStr = path.join(appPath, "/src/views/pages/page.ejs");
    const contactsPathStr = path.join(appPath, "/src/views/pages/contacts.ejs");
    const pricesPathStr = path.join(appPath, "/src/views/pages/prices.ejs");

    const dTree = await _getDTree();
    if (!dTree.ok) {
      console.error(dTree.data);
      statusError.message = dict.errors.unknown;
      return res.status(status.error).send(statusError);
    }
    const menuTree = branches(dTree.data, "0");

    const homeDir = dTree.data.find(i=>i[leafIdName] == 1);
    const homePage = pages.find(i=>i.id_page == homeDir["page_id"]);

    if (cData.yandex_mapconstructor) {
      yamapctr = `<iframe src="${cData.yandex_mapconstructor}" width="100%" height="400" frameborder="0"></iframe>`
    }

    const homeStr = await ejs.renderFile(homePathStr, {data: cData, menu: menuTree, homePage: homePage, yamapctr: yamapctr}, {async: false });

    const mainPathStr = path.join(appPath, "/src/public/index.html");
    writeFileSync(mainPathStr, homeStr, { encoding:'utf8', flag:'w' });

    const renderPage = async (element) => {
      const pageId = element["page_id"];
      const pagePath = element["direction_path_name"] || "";
      const dbPage = pages.find(i=>i.id_page == pageId);
      let page = {
        name: "",
        photo: "",
        body: ""
      }

      if (pagePath.length <= 0 || !dbPage) {
        return;
      }

      if (pageId) {
        page = {
          pageDir: `<a href="/index.html" class="logo"><strong>Главная/${element?.direction_names}</strong></a>`,
          name: dbPage.page_name,
          photo: dbPage.page_photo ? `<span class="image main"><img src="/assets/img/${dbPage.page_photo}" alt="" /></span>` : "",
          body: dbPage.page_body
        }
      }
      const pagePathStr = path.join(appPath, `/src/public/${pagePath}.html`);
      const pagePathDirStr = path.dirname(pagePathStr);
      const pageFileStr = path.basename(pagePathStr);
      if (!existsSync(pagePathDirStr)) {
        mkdirSync(pagePathDirStr);
      }

      if (leafTypes.contacts == element[leafIdType]) {
        let yamap = "";
        if (cData.yandex_map) {
          yamap = `<iframe src="${cData.yandex_map}" width="100%" height="400" frameborder="0"></iframe>`
        }
        const contactsStr = await ejs.renderFile(contactsPathStr, {data: {
          site_title: dbPage?.site_title ? dbPage?.site_title : cData.site_title,
          site_keywords: dbPage?.site_keywords ? dbPage?.site_keywords : cData.site_keywords,
          site_description: dbPage?.site_description ? dbPage?.site_description : cData.site_description
        }, page: page, menu: menuTree, cData: cData, yamap : yamap}, {async: false });
        writeFileSync(pagePathStr, contactsStr, { encoding:'utf8', flag:'w' });
        return;
      }

      if (leafTypes.prices == element[leafIdType]) {
        let pTable = "";
        const priceTypes = await _getPriceTypes();
        const pricesTable = await _getPrices();

        if (priceTypes.ok && !notFilledArray(priceTypes.data) && pricesTable.ok && !notFilledArray(pricesTable.data)) {
          pTable = priceTypes.data.map((pType)=>getPricesTable(pType, pricesTable.data)).join("")
        }

        const hpricesStr = await ejs.renderFile(pricesPathStr, {data: {
          site_title: dbPage?.site_title ? dbPage?.site_title : cData.site_title,
          site_keywords: dbPage?.site_keywords ? dbPage?.site_keywords : cData.site_keywords,
          site_description: dbPage?.site_description ? dbPage?.site_description : cData.site_description
        }, page: page, menu: menuTree, cData: cData, pTable : pTable}, {async: false });
        writeFileSync(pagePathStr, hpricesStr, { encoding:'utf8', flag:'w' });
        return;
      }

      const homeStr = await ejs.renderFile(pagePathTmpStr, {data: {
        site_title: dbPage?.site_title ? dbPage?.site_title : cData.site_title,
        site_keywords: dbPage?.site_keywords ? dbPage?.site_keywords : cData.site_keywords,
        site_description: dbPage?.site_description ? dbPage?.site_description : cData.site_description
      }, page: page, menu: menuTree, cData: cData}, {async: false });
      writeFileSync(pagePathStr, homeStr, { encoding:'utf8', flag:'w' });
    }

    dTree.data.forEach(element => renderPage(element));

  } catch (error) {
    console.error(error);
    statusError.message = dict.errors.unknown;
    return res.status(status.error).send(statusError);
  }
  statusSuccess.data= {} 
  statusSuccess.message = dict.success.created;
  return res.status(status.created).send(statusSuccess);
}

module.exports = {
  all
};