All files / source/inboundOrderProductPartial information.js

100% Statements 3/3
100% Branches 2/2
100% Functions 2/2
100% Lines 3/3

Press n or j to go to the next uncovered block, b, p or k for the previous block.

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82        2x                                                   1x                                                                                       1x              
import { models } from '../../../config/database';
import InboundOrderProductPartialDao from '../../database/dao/inboundOrderProductPartial';
 
async function getInboundOrderProductPartial(query, opts = {}) {
  return InboundOrderProductPartialDao.findInboundOrderProductPartial(query, {
    attributes: [
      'id',
      'branchCode',
      'inboundOrderProductId',
      'sequence',
      'baptismLabel',
      'stage',
      'quantity',
      'quantityStorage',
      'suggestedAddress',
      'status',
      'note',
      'storageProductUser',
      'storageProductAt',
      'createdUser',
      'createdAt',
      'updatedUser',
      'updatedAt',
    ],
    ...opts,
  });
}
 
async function getInboundOrderProductPartials(query, opts = {}) {
  const inboundOrderProductPartials =
    await InboundOrderProductPartialDao.findInboundOrderProductPartials(query, {
      attributes: [
        'id',
        'branchCode',
        'inboundOrderProductId',
        'sequence',
        'baptismLabel',
        'quantity',
        'quantityStorage',
        'suggestedAddress',
        'status',
        'note',
        'storageProductUser',
        'storageProductAt',
        'createdUser',
        'createdAt',
        'updatedUser',
        'updatedAt',
      ],
      include: [
        {
          required: false,
          model: models.InboundOrderProduct,
          as: 'inboundOrderProduct',
          attributes: ['inboundOrderId', 'productCode', 'lineNumber'],
          include: [
            {
              required: false,
              model: models.Product,
              as: 'product',
              attributes: ['name'],
            },
            {
              required: true,
              model: models.InboundOrder,
              as: 'inboundOrder',
              attributes: ['orderNumber'],
            },
          ],
        },
      ],
      ...opts,
    });
 
  return inboundOrderProductPartials;
}
 
export default {
  getInboundOrderProductPartial,
  getInboundOrderProductPartials,
};