server/api/saProformaDetail/saProformaDetail.controller.js

   1 // *************************************************************************
   2 // *                                                                       *
   3 // * xCALLY Motion -  The Omnichannel Contact Center                       *
   4 // * Copyright (c) Xenialab s.r.l. All Rights Reserved                     *
   5 // *                                                                       *
   6 // *************************************************************************
   7 // *                                                                       *
   8 // * Email: info@xcally.com                                                *
   9 // * Website: https://www.xcally.com                                       *
  10 // *                                                                       *
  11 // *************************************************************************
  12 // *                                                                       *
  13 // * The SOFTWARE PRODUCT is protected by copyright laws and international *
  14 // * copyright treaties, as well as other intellectual property laws and   *
  15 // * treaties. The SOFTWARE PRODUCT is licensed, not sold.                         *
  16 // *                                                                       *
  17 // *************************************************************************
  18 var _0xeb74=['key','VIRTUAL','field','options','includeAll','findAll','rows','show','include','find','create','body','catch','update','params','describe','addProformaInvoiceDetail->>','companyName','productName','productCode','productDescription','typeName','pricelistName','priceListId','netPrice','discount','tax','note','subscriptionId','subscriptionName','subscriptionMonthly','SAInvoiceDetail','SAProductQuotation','automaticProformaInvoice','sequelize','transaction','log','push','all','WARNING','No\x20product\x20to\x20assign\x20invoice.\x20Invoice\x20not\x20created!!\x20','TCL:\x20exports.automaticProformaInvoice\x20->\x20err','SequelizeUniqueConstraintError','html-pdf','eml-format','zip-dir','request-promise','moment','bluebird','mustache','util','path','sox','to-csv','ejs','lodash','squel','crypto','desk.js','papaparse','../../components/parsers/qs','../../config/license/hardware','../../config/logger','../../config/environment','../../mysqldb','sendStatus','status','end','count','offset','limit','set','Content-Range','json','reject','save','then','destroy','error','stack','name','send','index','SAProformaDetail','rawAttributes','model','keys','query','intersection','fields','attributes','length','hasOwnProperty','order','sort','where','filters','filter','merge','map','type'];(function(_0x4fca21,_0x4c4209){var _0x13b3e4=function(_0x514ebd){while(--_0x514ebd){_0x4fca21['push'](_0x4fca21['shift']());}};_0x13b3e4(++_0x4c4209);}(_0xeb74,0x15a));var _0x4eb7=function(_0x118e33,_0x4d5e04){_0x118e33=_0x118e33-0x0;var _0x3a1c7d=_0xeb74[_0x118e33];return _0x3a1c7d;};'use strict';var pdf=require(_0x4eb7('0x0'));var emlformat=require(_0x4eb7('0x1'));var rimraf=require('rimraf');var zipdir=require(_0x4eb7('0x2'));var jsonpatch=require('fast-json-patch');var rp=require(_0x4eb7('0x3'));var moment=require(_0x4eb7('0x4'));var BPromise=require(_0x4eb7('0x5'));var Mustache=require(_0x4eb7('0x6'));var util=require(_0x4eb7('0x7'));var path=require(_0x4eb7('0x8'));var sox=require(_0x4eb7('0x9'));var csv=require(_0x4eb7('0xa'));var ejs=require(_0x4eb7('0xb'));var fs=require('fs');var _=require(_0x4eb7('0xc'));var squel=require(_0x4eb7('0xd'));var crypto=require(_0x4eb7('0xe'));var jsforce=require('jsforce');var deskjs=require(_0x4eb7('0xf'));var toCsv=require(_0x4eb7('0xa'));var querystring=require('querystring');var Papa=require(_0x4eb7('0x10'));var Redis=require('ioredis');var authService=require('../../components/auth/service');var qs=require(_0x4eb7('0x11'));var hardwareService=require(_0x4eb7('0x12'));var logger=require(_0x4eb7('0x13'))('api');var utils=require('../../config/utils');var config=require(_0x4eb7('0x14'));var db=require(_0x4eb7('0x15'))['db'];function respondWithStatusCode(_0x290e26,_0x75d5f9){_0x75d5f9=_0x75d5f9||0xcc;return function(_0x3ec034){if(_0x3ec034){return _0x290e26[_0x4eb7('0x16')](_0x75d5f9);}return _0x290e26[_0x4eb7('0x17')](_0x75d5f9)[_0x4eb7('0x18')]();};}function respondWithResult(_0x3f9738,_0x2ebdc1){_0x2ebdc1=_0x2ebdc1||0xc8;return function(_0xb8f804){if(_0xb8f804){return _0x3f9738[_0x4eb7('0x17')](_0x2ebdc1)['json'](_0xb8f804);}};}function respondWithFilteredResult(_0x86f507,_0x11caba){return function(_0x191957){if(_0x191957){var _0x254fe0=_0x191957[_0x4eb7('0x19')],_0xbdac02=_0x11caba[_0x4eb7('0x1a')],_0x29f07e=_0x11caba[_0x4eb7('0x1a')]+_0x11caba[_0x4eb7('0x1b')],_0x79d6be;if(_0x29f07e>=_0x254fe0){_0x29f07e=_0x254fe0;_0x79d6be=0xc8;}else{_0x79d6be=0xce;}_0x86f507['status'](_0x79d6be);return _0x86f507[_0x4eb7('0x1c')](_0x4eb7('0x1d'),_0xbdac02+'-'+_0x29f07e+'/'+_0x254fe0)[_0x4eb7('0x1e')](_0x191957);}return null;};}function patchUpdates(_0xb4a1c5){return function(_0x53ad13){try{jsonpatch['apply'](_0x53ad13,_0xb4a1c5,!![]);}catch(_0x4c84b1){return BPromise[_0x4eb7('0x1f')](_0x4c84b1);}return _0x53ad13[_0x4eb7('0x20')]();};}function saveUpdates(_0xd60487,_0x3ba847){return function(_0x99b872){if(_0x99b872){return _0x99b872['update'](_0xd60487)[_0x4eb7('0x21')](function(_0x377536){return _0x377536;});}return null;};}function removeEntity(_0x41d131,_0x4d320b){return function(_0x4da89e){if(_0x4da89e){return _0x4da89e[_0x4eb7('0x22')]()[_0x4eb7('0x21')](function(){_0x41d131['status'](0xcc)[_0x4eb7('0x18')]();});}};}function handleEntityNotFound(_0x3f4ff3,_0x19df84){return function(_0x41bf74){if(!_0x41bf74){_0x3f4ff3[_0x4eb7('0x16')](0x194);}return _0x41bf74;};}function handleError(_0x4b04ad,_0x2d26b1){_0x2d26b1=_0x2d26b1||0x1f4;return function(_0x211f70){logger[_0x4eb7('0x23')](_0x211f70[_0x4eb7('0x24')]);if(_0x211f70[_0x4eb7('0x25')]){delete _0x211f70[_0x4eb7('0x25')];}_0x4b04ad[_0x4eb7('0x17')](_0x2d26b1)[_0x4eb7('0x26')](_0x211f70);};}exports[_0x4eb7('0x27')]=function(_0x17cd63,_0x8ac471){var _0x470ff7={},_0x5d86d4={},_0x636c2b={'count':0x0,'rows':[]};var _0x3c9c16=db[_0x4eb7('0x28')][_0x4eb7('0x29')];_0x5d86d4[_0x4eb7('0x2a')]=_[_0x4eb7('0x2b')](_0x3c9c16);_0x5d86d4[_0x4eb7('0x2c')]=_[_0x4eb7('0x2b')](_0x17cd63['query']);_0x5d86d4['filters']=_[_0x4eb7('0x2d')](_0x5d86d4[_0x4eb7('0x2a')],_0x5d86d4['query']);_0x470ff7['attributes']=_[_0x4eb7('0x2d')](_0x5d86d4[_0x4eb7('0x2a')],qs['fields'](_0x17cd63[_0x4eb7('0x2c')][_0x4eb7('0x2e')]));_0x470ff7[_0x4eb7('0x2f')]=_0x470ff7[_0x4eb7('0x2f')][_0x4eb7('0x30')]?_0x470ff7[_0x4eb7('0x2f')]:_0x5d86d4[_0x4eb7('0x2a')];if(!_0x17cd63[_0x4eb7('0x2c')][_0x4eb7('0x31')]('nolimit')){_0x470ff7[_0x4eb7('0x1b')]=qs['limit'](_0x17cd63['query']['limit']);_0x470ff7[_0x4eb7('0x1a')]=qs[_0x4eb7('0x1a')](_0x17cd63[_0x4eb7('0x2c')][_0x4eb7('0x1a')]);}_0x470ff7[_0x4eb7('0x32')]=qs['sort'](_0x17cd63[_0x4eb7('0x2c')][_0x4eb7('0x33')]);_0x470ff7[_0x4eb7('0x34')]=qs['filters'](_['pick'](_0x17cd63[_0x4eb7('0x2c')],_0x5d86d4[_0x4eb7('0x35')]));if(_0x17cd63[_0x4eb7('0x2c')][_0x4eb7('0x36')]){_0x470ff7['where']=_[_0x4eb7('0x37')](_0x470ff7['where'],{'$or':_[_0x4eb7('0x38')](_0x3c9c16,function(_0x3b4d77){if(_0x3b4d77[_0x4eb7('0x39')][_0x4eb7('0x3a')]!==_0x4eb7('0x3b')){var _0x1a84b6={};_0x1a84b6[_0x3b4d77[_0x4eb7('0x3c')]]={'$like':'%'+_0x17cd63[_0x4eb7('0x2c')][_0x4eb7('0x36')]+'%'};return _0x1a84b6;}})});}_0x470ff7=_[_0x4eb7('0x37')]({},_0x470ff7,_0x17cd63[_0x4eb7('0x3d')]);var _0x306580={'where':_0x470ff7[_0x4eb7('0x34')]};return db[_0x4eb7('0x28')]['count'](_0x306580)[_0x4eb7('0x21')](function(_0x407584){_0x636c2b[_0x4eb7('0x19')]=_0x407584;if(_0x17cd63[_0x4eb7('0x2c')][_0x4eb7('0x3e')]){_0x470ff7['include']=[{'all':!![]}];}return db[_0x4eb7('0x28')][_0x4eb7('0x3f')](_0x470ff7);})[_0x4eb7('0x21')](function(_0x1ddbf0){_0x636c2b[_0x4eb7('0x40')]=_0x1ddbf0;return _0x636c2b;})[_0x4eb7('0x21')](respondWithFilteredResult(_0x8ac471,_0x470ff7))['catch'](handleError(_0x8ac471,null));};exports[_0x4eb7('0x41')]=function(_0x10539b,_0x2d3aa6){var _0x2c4534={'raw':![],'where':{'id':_0x10539b['params']['id']}},_0x19bfd9={};_0x19bfd9[_0x4eb7('0x2a')]=_[_0x4eb7('0x2b')](db['SAProformaDetail'][_0x4eb7('0x29')]);_0x19bfd9['query']=_[_0x4eb7('0x2b')](_0x10539b[_0x4eb7('0x2c')]);_0x19bfd9[_0x4eb7('0x35')]=_['intersection'](_0x19bfd9[_0x4eb7('0x2a')],_0x19bfd9['query']);_0x2c4534['attributes']=_[_0x4eb7('0x2d')](_0x19bfd9[_0x4eb7('0x2a')],qs['fields'](_0x10539b['query'][_0x4eb7('0x2e')]));_0x2c4534['attributes']=_0x2c4534['attributes'][_0x4eb7('0x30')]?_0x2c4534[_0x4eb7('0x2f')]:_0x19bfd9[_0x4eb7('0x2a')];if(_0x10539b[_0x4eb7('0x2c')][_0x4eb7('0x3e')]){_0x2c4534[_0x4eb7('0x42')]=[{'all':!![]}];}_0x2c4534=_[_0x4eb7('0x37')]({},_0x2c4534,_0x10539b['options']);return db[_0x4eb7('0x28')][_0x4eb7('0x43')](_0x2c4534)[_0x4eb7('0x21')](handleEntityNotFound(_0x2d3aa6,null))[_0x4eb7('0x21')](respondWithResult(_0x2d3aa6,null))['catch'](handleError(_0x2d3aa6,null));};exports[_0x4eb7('0x44')]=function(_0x154dbf,_0x427a4d){return db[_0x4eb7('0x28')]['create'](_0x154dbf[_0x4eb7('0x45')],{})[_0x4eb7('0x21')](respondWithResult(_0x427a4d,0xc9))[_0x4eb7('0x46')](handleError(_0x427a4d,null));};exports[_0x4eb7('0x47')]=function(_0x38ce97,_0x29422c){if(_0x38ce97[_0x4eb7('0x45')]['id']){delete _0x38ce97[_0x4eb7('0x45')]['id'];}return db[_0x4eb7('0x28')][_0x4eb7('0x43')]({'where':{'id':_0x38ce97[_0x4eb7('0x48')]['id']}})[_0x4eb7('0x21')](handleEntityNotFound(_0x29422c,null))[_0x4eb7('0x21')](saveUpdates(_0x38ce97[_0x4eb7('0x45')],null))[_0x4eb7('0x21')](respondWithResult(_0x29422c,null))['catch'](handleError(_0x29422c,null));};exports['destroy']=function(_0x19d0c3,_0x3131ad){return db[_0x4eb7('0x28')]['find']({'where':{'id':_0x19d0c3[_0x4eb7('0x48')]['id']}})[_0x4eb7('0x21')](handleEntityNotFound(_0x3131ad,null))[_0x4eb7('0x21')](removeEntity(_0x3131ad,null))[_0x4eb7('0x46')](handleError(_0x3131ad,null));};exports[_0x4eb7('0x49')]=function(_0x597a5f,_0x2a9dc3){return db['SAProformaDetail']['describe']()[_0x4eb7('0x21')](respondWithResult(_0x2a9dc3,null))['catch'](handleError(_0x2a9dc3,null));};function addProformaInvoiceDetail(_0x11a323,_0x5aed9e,_0x17117c){console['log'](_0x4eb7('0x4a'),_0x11a323);var _0xe532c9={'companyName':_0x11a323[_0x4eb7('0x4b')],'companyId':_0x11a323['companyId'],'productName':_0x11a323[_0x4eb7('0x4c')],'productCode':_0x11a323[_0x4eb7('0x4d')],'productDescription':_0x11a323[_0x4eb7('0x4e')],'typeName':_0x11a323[_0x4eb7('0x4f')],'pricelistName':_0x11a323[_0x4eb7('0x50')],'priceListId':_0x11a323[_0x4eb7('0x51')],'netPrice':_0x11a323[_0x4eb7('0x52')],'discount':_0x11a323[_0x4eb7('0x53')],'tax':_0x11a323[_0x4eb7('0x54')],'agentFullname':_0x11a323['agentFullname'],'note':_0x11a323[_0x4eb7('0x55')],'subscriptionId':_0x11a323[_0x4eb7('0x56')],'subscriptionName':_0x11a323[_0x4eb7('0x57')],'subscriptionMonthly':_0x11a323[_0x4eb7('0x58')],'quantity':_0x11a323['quantity'],'InvoiceId':_0x5aed9e};return db[_0x4eb7('0x59')]['create'](_0xe532c9,{'transaction':_0x17117c})['then'](function(){return db[_0x4eb7('0x5a')][_0x4eb7('0x47')]({'InvoiceId':_0x5aed9e},{'where':{'ProductPriceListId':_0x11a323['priceListId'],'productCode':_0x11a323[_0x4eb7('0x4d')],'ProformaId':_0x11a323['ProformaId']},'transaction':_0x17117c});});}exports[_0x4eb7('0x5b')]=function(_0x52ea7b,_0x34ecc8,_0x3dc1f7){var _0x25e2ce;if(_0x52ea7b['body']['id']){delete _0x52ea7b[_0x4eb7('0x45')]['id'];}console['log'](_0x52ea7b);return db[_0x4eb7('0x5c')][_0x4eb7('0x5d')](function(_0x1e07ad){return db['SAInvoice']['create'](_0x52ea7b['body'],{'transaction':_0x1e07ad,'logging':console[_0x4eb7('0x5e')]})[_0x4eb7('0x21')](function(_0x1db2d7){_0x25e2ce=_0x1db2d7;var _0x366bac=_0x52ea7b[_0x4eb7('0x48')]['id'];return db['SAProformaDetail'][_0x4eb7('0x3f')]({'where':{'ProformaId':_0x366bac},'raw':!![],'logging':console['log']});})['then'](function(_0x4e8bcd){if(_0x4e8bcd[_0x4eb7('0x30')]>0x0){var _0x53b10b=[];for(var _0x340e9f=0x0;_0x340e9f<_0x4e8bcd['length'];_0x340e9f++){_0x53b10b[_0x4eb7('0x5f')](addProformaInvoiceDetail(_0x4e8bcd[_0x340e9f],_0x25e2ce['id'],_0x1e07ad));}return BPromise[_0x4eb7('0x60')](_0x53b10b);}else{var _0x5e5667={'errors':[{'type':_0x4eb7('0x61'),'message':_0x4eb7('0x62')}]};throw _0x5e5667;}});})[_0x4eb7('0x21')](function(){return _0x34ecc8[_0x4eb7('0x16')](0xc8);})[_0x4eb7('0x46')](function(_0xe8362){console['log'](_0x4eb7('0x63'),_0xe8362);if(_0xe8362[_0x4eb7('0x25')]===_0x4eb7('0x64')){var _0xe8362={'errors':[{'message':'Duplicate\x20entry.'}]};}_0x34ecc8[_0x4eb7('0x17')](0x1f4)['send'](_0xe8362);});};