12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061 |
- const mongoose = require('mongoose');
- const uuidV1 = require('uuid/v1');
- const _ = require('lodash');
- const scMathUtil = require('../../../public/scMathUtil').getUtil();
- const infoPriceSummaryModel = mongoose.model('std_price_info_summary');
- // 获取分页数据
- const getPagingData = async (page, pageSize, searchStr) => {
- let query = {};
- if (searchStr) {
- const nameReg = new RegExp(searchStr);
- query = {
- $or: [{ classCode: searchStr }, { name: { $regex: nameReg } }]
- }
- }
- const totalCount = await infoPriceSummaryModel.count(query);
- const items = await infoPriceSummaryModel.find(query).lean().sort({ classCode: 1 }).skip(page * pageSize).limit(pageSize);
- return { items, totalCount };
- }
- const UpdateType = {
- UPDATE: 'update',
- DELETE: 'delete',
- CREATE: 'create',
- };
- // 编辑表格
- async function editSummaryData(postData) {
- const bulks = [];
- postData.forEach(data => {
- if (data.type === UpdateType.UPDATE) {
- bulks.push({
- updateOne: {
- filter: { ID: data.ID },
- update: { ...data.data }
- }
- });
- } else if (data.type === UpdateType.DELETE) {
- bulks.push({
- deleteOne: {
- filter: { ID: data.ID }
- }
- });
- } else {
- bulks.push({
- insertOne: {
- document: data.data
- }
- });
- }
- });
- if (bulks.length) {
- await infoPriceSummaryModel.bulkWrite(bulks);
- }
- }
- module.exports = {
- getPagingData,
- editSummaryData,
- }
|