// * treaties. The SOFTWARE PRODUCT is licensed, not sold. *
// * *
// *************************************************************************
-var _0x814b=['stack','name','send','index','SAAsset','rawAttributes','keys','query','filters','intersection','attributes','length','hasOwnProperty','limit','order','sort','where','pick','filter','merge','type','key','VIRTUAL','field','options','include','findAll','show','params','model','fields','includeAll','find','catch','create','body','update','describe','getSubscriptions','nolimit','map','ppppp\x20\x20options','automaticSubscriptionInvoiceAlignment','sequelize','transaction','CmCompany','companyId','DESC','subscriptionId','forEach','log','automaticSubscriptionInvoice\x20productForCompany->','push','TCL:\x20exports.automaticProformaInvoice\x20->\x20err','SequelizeUniqueConstraintError','Duplicate\x20entry.','??????\x20invoiceType','??????\x20updSubscriptionDetail\x20product.id->','??????\x20updSubscriptionDetail\x20product.dateNextInvoice->','dateNextInvoice','Partial','add','subscriptionMonthly','lastInvoice','nextInvoice','companyName','productCode','productDescription','typeName','pricelistName','netPrice','tax','System','subscriptionName','quantity','SAInvoiceDetail','findOne','Automatic\x20Job','close','saStreet','saPostalCode','saCity','saCountry','saISOCode','saFiscalCode','saSocCap','saPIVA','saSDICode','saFiscalMessage','saExpiryDay','bankAccount','bankName','bankstreet','bankpostalCode','bankcountry','bankBICSWIFT','bankIBAN','phone','fax','bankABI','paypalEmail','SAInvoice','pricelistId','isNull','mapValues','createdAt','value','diff','days','diffDay','dayPrice','automaticSubscriptionInvoice','££££££££\x20products','groupBy','all','No\x20product\x20to\x20assign\x20invoice.\x20Invoice\x20not\x20created!!\x20','html-pdf','eml-format','rimraf','zip-dir','fast-json-patch','request-promise','bluebird','mustache','util','path','sox','to-csv','lodash','squel','jsforce','desk.js','querystring','papaparse','ioredis','../../components/auth/service','../../components/parsers/qs','../../config/license/hardware','../../config/logger','api','../../config/environment','sendStatus','status','end','json','count','offset','Content-Range','then','destroy','error'];(function(_0xc940eb,_0x2a3710){var _0x5a2bf4=function(_0x3e29d7){while(--_0x3e29d7){_0xc940eb['push'](_0xc940eb['shift']());}};_0x5a2bf4(++_0x2a3710);}(_0x814b,0x1a2));var _0xb814=function(_0x4a3898,_0x4c9853){_0x4a3898=_0x4a3898-0x0;var _0x25ceb0=_0x814b[_0x4a3898];return _0x25ceb0;};'use strict';var pdf=require(_0xb814('0x0'));var emlformat=require(_0xb814('0x1'));var rimraf=require(_0xb814('0x2'));var zipdir=require(_0xb814('0x3'));var jsonpatch=require(_0xb814('0x4'));var rp=require(_0xb814('0x5'));var moment=require('moment');var BPromise=require(_0xb814('0x6'));var Mustache=require(_0xb814('0x7'));var util=require(_0xb814('0x8'));var path=require(_0xb814('0x9'));var sox=require(_0xb814('0xa'));var csv=require(_0xb814('0xb'));var ejs=require('ejs');var fs=require('fs');var _=require(_0xb814('0xc'));var squel=require(_0xb814('0xd'));var crypto=require('crypto');var jsforce=require(_0xb814('0xe'));var deskjs=require(_0xb814('0xf'));var toCsv=require(_0xb814('0xb'));var querystring=require(_0xb814('0x10'));var Papa=require(_0xb814('0x11'));var Redis=require(_0xb814('0x12'));var authService=require(_0xb814('0x13'));var qs=require(_0xb814('0x14'));var hardwareService=require(_0xb814('0x15'));var logger=require(_0xb814('0x16'))(_0xb814('0x17'));var utils=require('../../config/utils');var config=require(_0xb814('0x18'));var db=require('../../mysqldb')['db'];function respondWithStatusCode(_0x26b35f,_0x15d6ef){_0x15d6ef=_0x15d6ef||0xcc;return function(_0x35b10d){if(_0x35b10d){return _0x26b35f[_0xb814('0x19')](_0x15d6ef);}return _0x26b35f[_0xb814('0x1a')](_0x15d6ef)[_0xb814('0x1b')]();};}function respondWithResult(_0x1438e7,_0x41ed7b){_0x41ed7b=_0x41ed7b||0xc8;return function(_0xa0a2e5){if(_0xa0a2e5){return _0x1438e7[_0xb814('0x1a')](_0x41ed7b)[_0xb814('0x1c')](_0xa0a2e5);}};}function respondWithFilteredResult(_0x44fb96,_0x17f5bd){return function(_0x39bfcf){if(_0x39bfcf){var _0x303aca=_0x39bfcf[_0xb814('0x1d')],_0x3a71d6=_0x17f5bd[_0xb814('0x1e')],_0x45e0d0=_0x17f5bd[_0xb814('0x1e')]+_0x17f5bd['limit'],_0x265a83;if(_0x45e0d0>=_0x303aca){_0x45e0d0=_0x303aca;_0x265a83=0xc8;}else{_0x265a83=0xce;}_0x44fb96[_0xb814('0x1a')](_0x265a83);return _0x44fb96['set'](_0xb814('0x1f'),_0x3a71d6+'-'+_0x45e0d0+'/'+_0x303aca)[_0xb814('0x1c')](_0x39bfcf);}return null;};}function patchUpdates(_0x4c3007){return function(_0x4b55a7){try{jsonpatch['apply'](_0x4b55a7,_0x4c3007,!![]);}catch(_0x399b43){return BPromise['reject'](_0x399b43);}return _0x4b55a7['save']();};}function saveUpdates(_0xb684ea,_0x24211d){return function(_0x25b6b6){if(_0x25b6b6){return _0x25b6b6['update'](_0xb684ea)[_0xb814('0x20')](function(_0x531032){return _0x531032;});}return null;};}function removeEntity(_0x1e6393,_0x1808a3){return function(_0x3b267e){if(_0x3b267e){return _0x3b267e[_0xb814('0x21')]()[_0xb814('0x20')](function(){_0x1e6393[_0xb814('0x1a')](0xcc)[_0xb814('0x1b')]();});}};}function handleEntityNotFound(_0x594470,_0x2ead86){return function(_0x52b7a3){if(!_0x52b7a3){_0x594470[_0xb814('0x19')](0x194);}return _0x52b7a3;};}function handleError(_0x457dac,_0x31c7ec){_0x31c7ec=_0x31c7ec||0x1f4;return function(_0x208927){logger[_0xb814('0x22')](_0x208927[_0xb814('0x23')]);if(_0x208927[_0xb814('0x24')]){delete _0x208927['name'];}_0x457dac[_0xb814('0x1a')](_0x31c7ec)[_0xb814('0x25')](_0x208927);};}exports[_0xb814('0x26')]=function(_0x349394,_0x32ed56){var _0x1d5965={},_0x3f0150={},_0x1e4e89={'count':0x0,'rows':[]};var _0x5a6291=db[_0xb814('0x27')][_0xb814('0x28')];_0x3f0150['model']=_[_0xb814('0x29')](_0x5a6291);_0x3f0150[_0xb814('0x2a')]=_[_0xb814('0x29')](_0x349394['query']);_0x3f0150[_0xb814('0x2b')]=_[_0xb814('0x2c')](_0x3f0150['model'],_0x3f0150[_0xb814('0x2a')]);_0x1d5965['attributes']=_[_0xb814('0x2c')](_0x3f0150['model'],qs['fields'](_0x349394[_0xb814('0x2a')]['fields']));_0x1d5965[_0xb814('0x2d')]=_0x1d5965[_0xb814('0x2d')][_0xb814('0x2e')]?_0x1d5965['attributes']:_0x3f0150['model'];if(!_0x349394[_0xb814('0x2a')][_0xb814('0x2f')]('nolimit')){_0x1d5965[_0xb814('0x30')]=qs[_0xb814('0x30')](_0x349394[_0xb814('0x2a')][_0xb814('0x30')]);_0x1d5965[_0xb814('0x1e')]=qs[_0xb814('0x1e')](_0x349394[_0xb814('0x2a')]['offset']);}_0x1d5965[_0xb814('0x31')]=qs[_0xb814('0x32')](_0x349394[_0xb814('0x2a')][_0xb814('0x32')]);_0x1d5965[_0xb814('0x33')]=qs['filters'](_[_0xb814('0x34')](_0x349394['query'],_0x3f0150[_0xb814('0x2b')]));if(_0x349394[_0xb814('0x2a')][_0xb814('0x35')]){_0x1d5965['where']=_[_0xb814('0x36')](_0x1d5965[_0xb814('0x33')],{'$or':_['map'](_0x5a6291,function(_0x2fcd92){if(_0x2fcd92[_0xb814('0x37')][_0xb814('0x38')]!==_0xb814('0x39')){var _0xd77d96={};_0xd77d96[_0x2fcd92[_0xb814('0x3a')]]={'$like':'%'+_0x349394['query'][_0xb814('0x35')]+'%'};return _0xd77d96;}})});}_0x1d5965=_['merge']({},_0x1d5965,_0x349394[_0xb814('0x3b')]);var _0x4b5583={'where':_0x1d5965[_0xb814('0x33')]};return db['SAAsset'][_0xb814('0x1d')](_0x4b5583)[_0xb814('0x20')](function(_0x54a7fb){_0x1e4e89['count']=_0x54a7fb;if(_0x349394['query']['includeAll']){_0x1d5965[_0xb814('0x3c')]=[{'all':!![]}];}return db[_0xb814('0x27')][_0xb814('0x3d')](_0x1d5965);})[_0xb814('0x20')](function(_0x51cdba){_0x1e4e89['rows']=_0x51cdba;return _0x1e4e89;})[_0xb814('0x20')](respondWithFilteredResult(_0x32ed56,_0x1d5965))['catch'](handleError(_0x32ed56,null));};exports[_0xb814('0x3e')]=function(_0x1098eb,_0x178823){var _0x3063bf={'raw':![],'where':{'id':_0x1098eb[_0xb814('0x3f')]['id']}},_0x42653f={};_0x42653f[_0xb814('0x40')]=_[_0xb814('0x29')](db[_0xb814('0x27')]['rawAttributes']);_0x42653f['query']=_['keys'](_0x1098eb[_0xb814('0x2a')]);_0x42653f['filters']=_[_0xb814('0x2c')](_0x42653f['model'],_0x42653f[_0xb814('0x2a')]);_0x3063bf[_0xb814('0x2d')]=_[_0xb814('0x2c')](_0x42653f[_0xb814('0x40')],qs['fields'](_0x1098eb[_0xb814('0x2a')][_0xb814('0x41')]));_0x3063bf[_0xb814('0x2d')]=_0x3063bf[_0xb814('0x2d')][_0xb814('0x2e')]?_0x3063bf[_0xb814('0x2d')]:_0x42653f['model'];if(_0x1098eb[_0xb814('0x2a')][_0xb814('0x42')]){_0x3063bf[_0xb814('0x3c')]=[{'all':!![]}];}_0x3063bf=_[_0xb814('0x36')]({},_0x3063bf,_0x1098eb[_0xb814('0x3b')]);return db[_0xb814('0x27')][_0xb814('0x43')](_0x3063bf)['then'](handleEntityNotFound(_0x178823,null))['then'](respondWithResult(_0x178823,null))[_0xb814('0x44')](handleError(_0x178823,null));};exports[_0xb814('0x45')]=function(_0x4c08d6,_0x2bf906){return db[_0xb814('0x27')][_0xb814('0x45')](_0x4c08d6[_0xb814('0x46')],{})[_0xb814('0x20')](respondWithResult(_0x2bf906,0xc9))[_0xb814('0x44')](handleError(_0x2bf906,null));};exports[_0xb814('0x47')]=function(_0xe73300,_0x5c7a49){if(_0xe73300[_0xb814('0x46')]['id']){delete _0xe73300[_0xb814('0x46')]['id'];}return db['SAAsset'][_0xb814('0x43')]({'where':{'id':_0xe73300['params']['id']}})[_0xb814('0x20')](handleEntityNotFound(_0x5c7a49,null))[_0xb814('0x20')](saveUpdates(_0xe73300[_0xb814('0x46')],null))[_0xb814('0x20')](respondWithResult(_0x5c7a49,null))[_0xb814('0x44')](handleError(_0x5c7a49,null));};exports[_0xb814('0x21')]=function(_0x2cc806,_0x45480e){return db[_0xb814('0x27')][_0xb814('0x43')]({'where':{'id':_0x2cc806['params']['id']}})['then'](handleEntityNotFound(_0x45480e,null))[_0xb814('0x20')](removeEntity(_0x45480e,null))[_0xb814('0x44')](handleError(_0x45480e,null));};exports[_0xb814('0x48')]=function(_0x3f8e29,_0x1b565c){return db[_0xb814('0x27')][_0xb814('0x48')]()['then'](respondWithResult(_0x1b565c,null))[_0xb814('0x44')](handleError(_0x1b565c,null));};exports[_0xb814('0x49')]=function(_0xf27a6e,_0x5a916d){var _0x3a5556={},_0x4e6f3c={},_0x252293={'count':0x0,'rows':[]};var _0x5dc28e=db[_0xb814('0x27')][_0xb814('0x28')];_0x4e6f3c['model']=_[_0xb814('0x29')](_0x5dc28e);_0x4e6f3c[_0xb814('0x2a')]=_[_0xb814('0x29')](_0xf27a6e['query']);_0x4e6f3c[_0xb814('0x2b')]=_['intersection'](_0x4e6f3c[_0xb814('0x40')],_0x4e6f3c[_0xb814('0x2a')]);_0x3a5556['attributes']=_[_0xb814('0x2c')](_0x4e6f3c['model'],qs['fields'](_0xf27a6e[_0xb814('0x2a')][_0xb814('0x41')]));_0x3a5556[_0xb814('0x2d')]=_0x3a5556['attributes'][_0xb814('0x2e')]?_0x3a5556['attributes']:_0x4e6f3c[_0xb814('0x40')];if(!_0xf27a6e[_0xb814('0x2a')]['hasOwnProperty'](_0xb814('0x4a'))){_0x3a5556['limit']=qs[_0xb814('0x30')](_0xf27a6e[_0xb814('0x2a')][_0xb814('0x30')]);_0x3a5556[_0xb814('0x1e')]=qs[_0xb814('0x1e')](_0xf27a6e[_0xb814('0x2a')][_0xb814('0x1e')]);}_0x3a5556[_0xb814('0x31')]=qs['sort'](_0xf27a6e[_0xb814('0x2a')][_0xb814('0x32')]);_0x3a5556['where']=qs[_0xb814('0x2b')](_[_0xb814('0x34')](_0xf27a6e['query'],_0x4e6f3c[_0xb814('0x2b')]));if(_0xf27a6e['query']['filter']){_0x3a5556[_0xb814('0x33')]=_['merge'](_0x3a5556[_0xb814('0x33')],{'$or':_[_0xb814('0x4b')](_0x5dc28e,function(_0x2dec52){if(_0x2dec52['type'][_0xb814('0x38')]!=='VIRTUAL'){var _0x2ef77d={};_0x2ef77d[_0x2dec52[_0xb814('0x3a')]]={'$like':'%'+_0xf27a6e[_0xb814('0x2a')][_0xb814('0x35')]+'%'};return _0x2ef77d;}})});}_0x3a5556=_[_0xb814('0x36')]({},_0x3a5556,_0xf27a6e[_0xb814('0x3b')]);var _0x2e5f99={'where':_0x3a5556[_0xb814('0x33')]};return db[_0xb814('0x27')]['count'](_0x2e5f99)[_0xb814('0x20')](function(_0x111884){_0x252293[_0xb814('0x1d')]=_0x111884;if(_0xf27a6e[_0xb814('0x2a')][_0xb814('0x42')]){_0x3a5556[_0xb814('0x3c')]=[{'all':!![]}];}console['log'](_0xb814('0x4c'),_0x3a5556);return db['SAAsset'][_0xb814('0x3d')](_0x3a5556);})[_0xb814('0x20')](function(_0xac95cf){_0x252293['rows']=_0xac95cf;return _0x252293;})[_0xb814('0x20')](respondWithFilteredResult(_0x5a916d,_0x3a5556))['catch'](handleError(_0x5a916d,null));};exports[_0xb814('0x4d')]=function(_0x4a65d0,_0x2f0c94,_0x417e45){var _0xa03cd2;if(_0x4a65d0[_0xb814('0x46')]['id']){delete _0x4a65d0[_0xb814('0x46')]['id'];}return db[_0xb814('0x4e')][_0xb814('0x4f')](function(_0x4d44e3){return db[_0xb814('0x50')]['findOne']({'where':{'defaultEntry':0x1},'raw':!![],'logging':!![]})[_0xb814('0x20')](function(_0x22c73f){_0xa03cd2=_0x22c73f;return db[_0xb814('0x27')][_0xb814('0x3d')]({'where':{'dateLastInvoice':null,'deleted':null,'status':null},'order':[[_0xb814('0x51'),_0xb814('0x52')],['pricelistId',_0xb814('0x52')],[_0xb814('0x53'),'DESC']],'raw':!![],'logging':!![]});})[_0xb814('0x20')](function(_0x32a37a){if(_0x32a37a[_0xb814('0x2e')]>0x0){var _0x130033=[];var _0x2161eb=_['groupBy'](_0x32a37a,_0xb814('0x51'));Object['keys'](_0x2161eb)[_0xb814('0x54')](function(_0x16f8f2){var _0x2645f6=_0x2161eb[_0x16f8f2];console[_0xb814('0x55')](_0xb814('0x56'),_0x2645f6);_0x130033[_0xb814('0x57')](addSubscriptionInvoice(_0x2645f6,_0xa03cd2,_0x16f8f2,'Partial',_0x4d44e3));});return BPromise['all'](_0x130033);}});})['then'](function(){return _0x2f0c94[_0xb814('0x19')](0xc8);})['catch'](function(_0x45a8b9){console[_0xb814('0x55')](_0xb814('0x58'),_0x45a8b9);if(_0x45a8b9['name']===_0xb814('0x59')){var _0x45a8b9={'errors':[{'message':_0xb814('0x5a')}]};}_0x2f0c94['status'](0x1f4)[_0xb814('0x25')](_0x45a8b9);});};function updSubscriptionDetail(_0x1bf0b7,_0x1f39c0,_0x3564e0){console['log']('??????\x20updSubscriptionDetail\x20product->',_0x1bf0b7);console[_0xb814('0x55')](_0xb814('0x5b'),_0x1f39c0);console[_0xb814('0x55')](_0xb814('0x5c'),_0x1bf0b7['id']);console[_0xb814('0x55')](_0xb814('0x5d'),_0x1bf0b7[_0xb814('0x5e')]);var _0xe47442;var _0x274ed2;if(_0x1f39c0===_0xb814('0x5f')){_0xe47442=moment();_0x274ed2=_0x1bf0b7[_0xb814('0x5e')];}else{_0xe47442=_0x1bf0b7[_0xb814('0x5e')];_0x274ed2=moment(_0x1bf0b7[_0xb814('0x5e')])[_0xb814('0x60')](_0x1bf0b7[_0xb814('0x61')],'months');}console[_0xb814('0x55')](_0xb814('0x62'),_0xe47442);console[_0xb814('0x55')](_0xb814('0x63'),_0x274ed2);return db[_0xb814('0x27')][_0xb814('0x47')]({'dateLastInvoice':_0xe47442,'dateNextInvoice':_0x274ed2,'agentFullname':'System'},{'where':{'id':_0x1bf0b7['id']},'raw':!![],'transaction':_0x3564e0})[_0xb814('0x44')](function(_0x52e1fc){throw _0x52e1fc;});}function addSubscriptionInvoiceDetail(_0x872d43,_0x39aa00,_0x3c5a58){var _0x2292e6={'companyName':_0x872d43[_0xb814('0x64')],'companyId':_0x872d43['companyId'],'productName':_0x872d43['productName'],'productCode':_0x872d43[_0xb814('0x65')],'productDescription':_0x872d43[_0xb814('0x66')],'typeName':_0x872d43[_0xb814('0x67')],'pricelistName':_0x872d43[_0xb814('0x68')],'priceListId':_0x872d43['pricelistId'],'netPrice':_0x872d43[_0xb814('0x69')],'discount':_0x872d43['discount'],'tax':_0x872d43[_0xb814('0x6a')],'agentFullname':_0xb814('0x6b'),'note':_0x872d43['note'],'subscriptionId':_0x872d43['subscriptionId'],'subscriptionName':_0x872d43[_0xb814('0x6c')],'subscriptionMonthly':_0x872d43['subscriptionMonthly'],'quantity':_0x872d43[_0xb814('0x6d')],'InvoiceId':_0x39aa00['id']};return db[_0xb814('0x6e')][_0xb814('0x45')](_0x2292e6,{'raw':!![],'transaction':_0x3c5a58})[_0xb814('0x44')](function(_0x46784f){throw _0x46784f;});}function addSubscriptionInvoice(_0x420bde,_0x40fe4a,_0x4bd56c,_0x1d37ea,_0x54413d){return db[_0xb814('0x50')]['findOne']({'where':{'id':_0x4bd56c},'raw':!![]})[_0xb814('0x20')](function(_0x43ee60){return db['SAPaymentMethod'][_0xb814('0x6f')]({'where':{'id':_0x43ee60['saPaymentMethod']},'raw':!![]})[_0xb814('0x20')](function(_0x356875){var _0x4e15c2={'name':'Invoice\x20'+moment()+'_'+_0x1d37ea,'note':_0xb814('0x70'),'agentFullname':_0xb814('0x6b'),'status':_0xb814('0x71'),'companyName':_0x43ee60[_0xb814('0x24')],'companyId':_0x43ee60['id'],'paid':0x0,'discount':0x0,'receivingStreet':_0x43ee60[_0xb814('0x72')],'receivingPostalCode':_0x43ee60[_0xb814('0x73')],'receivingCity':_0x43ee60[_0xb814('0x74')],'receivingCountry':_0x43ee60[_0xb814('0x75')],'receivingISOCode':_0x43ee60[_0xb814('0x76')],'receivingFiscalCode':_0x43ee60[_0xb814('0x77')],'receivingPIVA':_0x43ee60['saPIVA'],'receivingSDICode':_0x43ee60['saSDICode'],'receivingFiscalMessage':_0x43ee60['saFiscalMessage'],'receivingExpiryDay':_0x43ee60['saExpiryDay'],'receivingEurope':_0x43ee60['saEurope'],'receivingSocCap':_0x43ee60[_0xb814('0x78')],'issuerName':_0x40fe4a[_0xb814('0x24')],'issuerStreet':_0x40fe4a[_0xb814('0x72')],'issuerPostalCode':_0x40fe4a['saPostalCode'],'issuerCity':_0x40fe4a[_0xb814('0x74')],'issuerCountry':_0x40fe4a[_0xb814('0x75')],'issuerISOCode':_0x40fe4a[_0xb814('0x76')],'issuerFiscalCode':_0x40fe4a[_0xb814('0x77')],'issuerPIVA':_0x40fe4a[_0xb814('0x79')],'issuerSDICode':_0x40fe4a[_0xb814('0x7a')],'issuerFiscalMessage':_0x40fe4a[_0xb814('0x7b')],'issuerExpiryDay':_0x40fe4a[_0xb814('0x7c')],'issuerSocCap':_0x40fe4a['saSocCap'],'issuerBankAccount':_0x356875[_0xb814('0x7d')],'issuerBankName':_0x356875[_0xb814('0x7e')],'issuerBankStreet':_0x356875[_0xb814('0x7f')],'issuerBankPostalCode':_0x356875[_0xb814('0x80')],'issuerBankCity':_0x356875['bankcity'],'issuerBankCountry':_0x356875[_0xb814('0x81')],'issuerBankBICSWIFT':_0x356875[_0xb814('0x82')],'issuerBankIBAN':_0x356875[_0xb814('0x83')],'issuerPhone':_0x40fe4a[_0xb814('0x84')],'issuerFax':_0x40fe4a[_0xb814('0x85')],'issuerEmail':_0x40fe4a['email'],'issuerWeb':_0x40fe4a['website'],'issuerABI':_0x356875[_0xb814('0x86')],'issuerCAB':_0x356875['banckCAB'],'issuerPayPal':_0x356875[_0xb814('0x87')]};return db[_0xb814('0x88')]['create'](_0x4e15c2,{'transaction':_0x54413d})[_0xb814('0x20')](function(_0x486495){var _0xe17e86=[];for(var _0x520d0f=0x0;_0x520d0f<_0x420bde[_0xb814('0x2e')];_0x520d0f++){_0xe17e86[_0xb814('0x57')](updSubscriptionDetail(_0x420bde[_0x520d0f],_0x1d37ea,_0x54413d));}var _0x41867b=[_0xb814('0x65'),_0xb814('0x89'),_0xb814('0x53'),_0xb814('0x69')];_(_0x420bde)['groupBy'](function(_0x5a4e2e){return _[_0xb814('0x43')](_['pick'](_0x5a4e2e,_0x41867b),_['negate'](_[_0xb814('0x8a')]));})[_0xb814('0x8b')](function(_0x25d42d){var _0x57bf1b=_0x25d42d[0x0];_0x57bf1b[_0xb814('0x6d')]=_0x25d42d['length'];if(_0x1d37ea===_0xb814('0x5f')){_0x57bf1b[_0xb814('0x69')]=computePrice(_0x57bf1b[_0xb814('0x8c')],_0x57bf1b[_0xb814('0x5e')],_0x57bf1b['netPrice'],_0x57bf1b[_0xb814('0x61')]);}_0xe17e86[_0xb814('0x57')](addSubscriptionInvoiceDetail(_0x57bf1b,_0x486495,_0x54413d));})[_0xb814('0x8d')]();return BPromise['all'](_0xe17e86);});});})[_0xb814('0x44')](function(_0x3fc77d){console[_0xb814('0x55')]('TCL:\x20exports.automaticProformaInvoice\x20->\x20err',_0x3fc77d);throw _0x3fc77d;});}function computePrice(_0x5d8626,_0x2d0651,_0x9dc06b,_0x216d67){var _0x40b3c5=_0x9dc06b;console[_0xb814('0x55')](_0xb814('0x8c'),_0x5d8626);console[_0xb814('0x55')](_0xb814('0x5e'),_0x2d0651);console[_0xb814('0x55')](_0xb814('0x61'),_0x216d67);console[_0xb814('0x55')](_0xb814('0x69'),_0x9dc06b);if(_0x216d67!=0x0){var _0x5b8d2e=moment(_0x5d8626);var _0x5416dc=moment(_0x2d0651);var _0x2308fc=Math['abs'](_0x5b8d2e[_0xb814('0x8e')](_0x5416dc,_0xb814('0x8f')));console[_0xb814('0x55')](_0xb814('0x90'),_0x2308fc);var _0x405db7=_0x9dc06b/(0x1e*_0x216d67);console[_0xb814('0x55')](_0xb814('0x91'),_0x405db7);_0x40b3c5=_0x405db7*_0x2308fc;}console['log']('total',_0x40b3c5);return _0x40b3c5;}exports[_0xb814('0x92')]=function(_0x4f3125,_0x18678f,_0x21827c){var _0x1becf7;if(_0x4f3125['body']['id']){delete _0x4f3125[_0xb814('0x46')]['id'];}return db[_0xb814('0x4e')][_0xb814('0x4f')](function(_0x38c6da){return db[_0xb814('0x50')]['findOne']({'where':{'defaultEntry':0x1},'raw':!![]})[_0xb814('0x20')](function(_0x4fe23d){_0x1becf7=_0x4fe23d;return db['SAAsset'][_0xb814('0x3d')]({'where':{'dateNextInvoice':{'$lt':moment()},'subscriptionMonthly':{'$ne':0x0},'deleted':null},'order':[[_0xb814('0x51'),_0xb814('0x52')],['pricelistId',_0xb814('0x52')],[_0xb814('0x53'),'DESC']],'raw':!![]});})[_0xb814('0x20')](function(_0x171f83){console['log'](_0xb814('0x93'),_0x171f83);if(_0x171f83[_0xb814('0x2e')]>0x0){var _0x3f4cbf=[];var _0x2365f9=_[_0xb814('0x94')](_0x171f83,_0xb814('0x51'));Object[_0xb814('0x29')](_0x2365f9)[_0xb814('0x54')](function(_0xb115ba){var _0x1f8c7a=_0x2365f9[_0xb115ba];console[_0xb814('0x55')](_0xb814('0x56'),_0x1f8c7a);_0x3f4cbf['push'](addSubscriptionInvoice(_0x1f8c7a,_0x1becf7,_0xb115ba,'Total',_0x38c6da));});return BPromise[_0xb814('0x95')](_0x3f4cbf);}else{var _0x5b13c8={'errors':[{'type':'WARNING','message':_0xb814('0x96')}]};throw _0x5b13c8;}});})['then'](function(){return _0x18678f['sendStatus'](0xc8);})['catch'](function(_0x1044fa){console[_0xb814('0x55')](_0xb814('0x58'),_0x1044fa);if(_0x1044fa['name']===_0xb814('0x59')){var _0x1044fa={'errors':[{'message':_0xb814('0x5a')}]};}_0x18678f[_0xb814('0x1a')](0x1f4)['send'](_0x1044fa);});};
\ No newline at end of file
+var _0x9957=['path','sox','to-csv','ejs','lodash','squel','jsforce','desk.js','querystring','papaparse','ioredis','../../components/auth/service','../../components/parsers/qs','../../config/license/hardware','../../config/logger','../../config/utils','../../config/environment','sendStatus','status','end','json','count','offset','limit','set','Content-Range','apply','save','destroy','then','stack','name','send','index','SAAsset','rawAttributes','keys','query','filters','attributes','intersection','model','fields','length','hasOwnProperty','nolimit','order','where','pick','merge','type','key','VIRTUAL','filter','options','includeAll','include','findAll','rows','catch','show','create','body','find','params','describe','getSubscriptions','sort','map','field','ppppp\x20\x20options','sequelize','transaction','CmCompany','findOne','companyId','DESC','pricelistId','subscriptionId','log','automaticSubscriptionInvoice\x20productForCompany->','push','Partial','all','TCL:\x20exports.automaticProformaInvoice\x20->\x20err','Duplicate\x20entry.','??????\x20updSubscriptionDetail\x20product->','??????\x20invoiceType','??????\x20updSubscriptionDetail\x20product.dateNextInvoice->','dateNextInvoice','add','subscriptionMonthly','nextInvoice','System','companyName','productName','productCode','productDescription','typeName','pricelistName','netPrice','discount','tax','note','subscriptionName','quantity','SAInvoiceDetail','SAPaymentMethod','saPaymentMethod','Invoice\x20','Automatic\x20Job','close','saStreet','saPostalCode','saCountry','saISOCode','saSDICode','saFiscalMessage','saExpiryDay','saEurope','saSocCap','saPIVA','bankAccount','bankName','bankpostalCode','bankcity','bankcountry','bankIBAN','phone','fax','email','bankABI','banckCAB','paypalEmail','groupBy','negate','isNull','createdAt','value','diff','days','dayPrice','total','££££££££\x20products','forEach','WARNING','No\x20product\x20to\x20assign\x20invoice.\x20Invoice\x20not\x20created!!\x20','html-pdf','eml-format','rimraf','zip-dir','request-promise','moment','bluebird','mustache'];(function(_0xdea41a,_0x552987){var _0x15d0d8=function(_0x1e0d0b){while(--_0x1e0d0b){_0xdea41a['push'](_0xdea41a['shift']());}};_0x15d0d8(++_0x552987);}(_0x9957,0x93));var _0x7995=function(_0x3947c9,_0x4d6c97){_0x3947c9=_0x3947c9-0x0;var _0x2e7871=_0x9957[_0x3947c9];return _0x2e7871;};'use strict';var pdf=require(_0x7995('0x0'));var emlformat=require(_0x7995('0x1'));var rimraf=require(_0x7995('0x2'));var zipdir=require(_0x7995('0x3'));var jsonpatch=require('fast-json-patch');var rp=require(_0x7995('0x4'));var moment=require(_0x7995('0x5'));var BPromise=require(_0x7995('0x6'));var Mustache=require(_0x7995('0x7'));var util=require('util');var path=require(_0x7995('0x8'));var sox=require(_0x7995('0x9'));var csv=require(_0x7995('0xa'));var ejs=require(_0x7995('0xb'));var fs=require('fs');var _=require(_0x7995('0xc'));var squel=require(_0x7995('0xd'));var crypto=require('crypto');var jsforce=require(_0x7995('0xe'));var deskjs=require(_0x7995('0xf'));var toCsv=require('to-csv');var querystring=require(_0x7995('0x10'));var Papa=require(_0x7995('0x11'));var Redis=require(_0x7995('0x12'));var authService=require(_0x7995('0x13'));var qs=require(_0x7995('0x14'));var hardwareService=require(_0x7995('0x15'));var logger=require(_0x7995('0x16'))('api');var utils=require(_0x7995('0x17'));var config=require(_0x7995('0x18'));var db=require('../../mysqldb')['db'];function respondWithStatusCode(_0xb0c872,_0x2cb37a){_0x2cb37a=_0x2cb37a||0xcc;return function(_0x19a27e){if(_0x19a27e){return _0xb0c872[_0x7995('0x19')](_0x2cb37a);}return _0xb0c872[_0x7995('0x1a')](_0x2cb37a)[_0x7995('0x1b')]();};}function respondWithResult(_0x2bbe7a,_0x4cc004){_0x4cc004=_0x4cc004||0xc8;return function(_0x58f5ad){if(_0x58f5ad){return _0x2bbe7a[_0x7995('0x1a')](_0x4cc004)[_0x7995('0x1c')](_0x58f5ad);}};}function respondWithFilteredResult(_0x24b5bb,_0x321ae8){return function(_0x3f1d3e){if(_0x3f1d3e){var _0x1a5310=_0x3f1d3e[_0x7995('0x1d')],_0x2202ce=_0x321ae8['offset'],_0x41cbf0=_0x321ae8[_0x7995('0x1e')]+_0x321ae8[_0x7995('0x1f')],_0x5377e5;if(_0x41cbf0>=_0x1a5310){_0x41cbf0=_0x1a5310;_0x5377e5=0xc8;}else{_0x5377e5=0xce;}_0x24b5bb[_0x7995('0x1a')](_0x5377e5);return _0x24b5bb[_0x7995('0x20')](_0x7995('0x21'),_0x2202ce+'-'+_0x41cbf0+'/'+_0x1a5310)[_0x7995('0x1c')](_0x3f1d3e);}return null;};}function patchUpdates(_0x4faa60){return function(_0x54c9ae){try{jsonpatch[_0x7995('0x22')](_0x54c9ae,_0x4faa60,!![]);}catch(_0x5e6f90){return BPromise['reject'](_0x5e6f90);}return _0x54c9ae[_0x7995('0x23')]();};}function saveUpdates(_0x3d463e,_0x4cbe10){return function(_0x3a9b54){if(_0x3a9b54){return _0x3a9b54['update'](_0x3d463e)['then'](function(_0x3e4c54){return _0x3e4c54;});}return null;};}function removeEntity(_0x327b1f,_0x350fd9){return function(_0x1a8568){if(_0x1a8568){return _0x1a8568[_0x7995('0x24')]()[_0x7995('0x25')](function(){_0x327b1f['status'](0xcc)[_0x7995('0x1b')]();});}};}function handleEntityNotFound(_0x46ee4b,_0x204507){return function(_0x285437){if(!_0x285437){_0x46ee4b[_0x7995('0x19')](0x194);}return _0x285437;};}function handleError(_0x13bc35,_0x475351){_0x475351=_0x475351||0x1f4;return function(_0x472195){logger['error'](_0x472195[_0x7995('0x26')]);if(_0x472195[_0x7995('0x27')]){delete _0x472195[_0x7995('0x27')];}_0x13bc35[_0x7995('0x1a')](_0x475351)[_0x7995('0x28')](_0x472195);};}exports[_0x7995('0x29')]=function(_0x56691a,_0x47625f){var _0x5911c3={},_0x229742={},_0x49bc7e={'count':0x0,'rows':[]};var _0xf16cc2=db[_0x7995('0x2a')][_0x7995('0x2b')];_0x229742['model']=_[_0x7995('0x2c')](_0xf16cc2);_0x229742['query']=_[_0x7995('0x2c')](_0x56691a[_0x7995('0x2d')]);_0x229742[_0x7995('0x2e')]=_['intersection'](_0x229742['model'],_0x229742['query']);_0x5911c3[_0x7995('0x2f')]=_[_0x7995('0x30')](_0x229742[_0x7995('0x31')],qs[_0x7995('0x32')](_0x56691a[_0x7995('0x2d')][_0x7995('0x32')]));_0x5911c3['attributes']=_0x5911c3['attributes'][_0x7995('0x33')]?_0x5911c3['attributes']:_0x229742[_0x7995('0x31')];if(!_0x56691a[_0x7995('0x2d')][_0x7995('0x34')](_0x7995('0x35'))){_0x5911c3[_0x7995('0x1f')]=qs['limit'](_0x56691a[_0x7995('0x2d')][_0x7995('0x1f')]);_0x5911c3['offset']=qs['offset'](_0x56691a['query'][_0x7995('0x1e')]);}_0x5911c3[_0x7995('0x36')]=qs['sort'](_0x56691a[_0x7995('0x2d')]['sort']);_0x5911c3[_0x7995('0x37')]=qs[_0x7995('0x2e')](_[_0x7995('0x38')](_0x56691a['query'],_0x229742['filters']));if(_0x56691a[_0x7995('0x2d')]['filter']){_0x5911c3['where']=_[_0x7995('0x39')](_0x5911c3[_0x7995('0x37')],{'$or':_['map'](_0xf16cc2,function(_0x1baa15){if(_0x1baa15[_0x7995('0x3a')][_0x7995('0x3b')]!==_0x7995('0x3c')){var _0x1e3dbf={};_0x1e3dbf[_0x1baa15['field']]={'$like':'%'+_0x56691a[_0x7995('0x2d')][_0x7995('0x3d')]+'%'};return _0x1e3dbf;}})});}_0x5911c3=_[_0x7995('0x39')]({},_0x5911c3,_0x56691a[_0x7995('0x3e')]);var _0x4b1541={'where':_0x5911c3[_0x7995('0x37')]};return db[_0x7995('0x2a')][_0x7995('0x1d')](_0x4b1541)[_0x7995('0x25')](function(_0x1f5bee){_0x49bc7e[_0x7995('0x1d')]=_0x1f5bee;if(_0x56691a['query'][_0x7995('0x3f')]){_0x5911c3[_0x7995('0x40')]=[{'all':!![]}];}return db[_0x7995('0x2a')][_0x7995('0x41')](_0x5911c3);})[_0x7995('0x25')](function(_0x298fc2){_0x49bc7e[_0x7995('0x42')]=_0x298fc2;return _0x49bc7e;})[_0x7995('0x25')](respondWithFilteredResult(_0x47625f,_0x5911c3))[_0x7995('0x43')](handleError(_0x47625f,null));};exports[_0x7995('0x44')]=function(_0x6fe77b,_0x270d52){var _0x7b4e67={'raw':![],'where':{'id':_0x6fe77b['params']['id']}},_0x53cda2={};_0x53cda2[_0x7995('0x31')]=_[_0x7995('0x2c')](db['SAAsset']['rawAttributes']);_0x53cda2[_0x7995('0x2d')]=_['keys'](_0x6fe77b['query']);_0x53cda2[_0x7995('0x2e')]=_[_0x7995('0x30')](_0x53cda2[_0x7995('0x31')],_0x53cda2['query']);_0x7b4e67[_0x7995('0x2f')]=_['intersection'](_0x53cda2[_0x7995('0x31')],qs['fields'](_0x6fe77b['query'][_0x7995('0x32')]));_0x7b4e67[_0x7995('0x2f')]=_0x7b4e67[_0x7995('0x2f')][_0x7995('0x33')]?_0x7b4e67['attributes']:_0x53cda2[_0x7995('0x31')];if(_0x6fe77b[_0x7995('0x2d')][_0x7995('0x3f')]){_0x7b4e67[_0x7995('0x40')]=[{'all':!![]}];}_0x7b4e67=_['merge']({},_0x7b4e67,_0x6fe77b['options']);return db[_0x7995('0x2a')]['find'](_0x7b4e67)[_0x7995('0x25')](handleEntityNotFound(_0x270d52,null))['then'](respondWithResult(_0x270d52,null))[_0x7995('0x43')](handleError(_0x270d52,null));};exports['create']=function(_0x1e795e,_0x1b0373){return db['SAAsset'][_0x7995('0x45')](_0x1e795e[_0x7995('0x46')],{})[_0x7995('0x25')](respondWithResult(_0x1b0373,0xc9))[_0x7995('0x43')](handleError(_0x1b0373,null));};exports['update']=function(_0x2458cb,_0x3e787d){if(_0x2458cb[_0x7995('0x46')]['id']){delete _0x2458cb['body']['id'];}return db[_0x7995('0x2a')][_0x7995('0x47')]({'where':{'id':_0x2458cb[_0x7995('0x48')]['id']}})[_0x7995('0x25')](handleEntityNotFound(_0x3e787d,null))[_0x7995('0x25')](saveUpdates(_0x2458cb['body'],null))[_0x7995('0x25')](respondWithResult(_0x3e787d,null))[_0x7995('0x43')](handleError(_0x3e787d,null));};exports['destroy']=function(_0x3d1dbb,_0x5843ba){return db[_0x7995('0x2a')][_0x7995('0x47')]({'where':{'id':_0x3d1dbb[_0x7995('0x48')]['id']}})[_0x7995('0x25')](handleEntityNotFound(_0x5843ba,null))[_0x7995('0x25')](removeEntity(_0x5843ba,null))[_0x7995('0x43')](handleError(_0x5843ba,null));};exports[_0x7995('0x49')]=function(_0x4d46bc,_0x427dcf){return db[_0x7995('0x2a')][_0x7995('0x49')]()['then'](respondWithResult(_0x427dcf,null))[_0x7995('0x43')](handleError(_0x427dcf,null));};exports[_0x7995('0x4a')]=function(_0x12d4b8,_0x47d1d8){var _0x4ec548={},_0x5a592e={},_0xb70620={'count':0x0,'rows':[]};var _0x1fd1ca=db['SAAsset'][_0x7995('0x2b')];_0x5a592e[_0x7995('0x31')]=_[_0x7995('0x2c')](_0x1fd1ca);_0x5a592e[_0x7995('0x2d')]=_[_0x7995('0x2c')](_0x12d4b8['query']);_0x5a592e[_0x7995('0x2e')]=_['intersection'](_0x5a592e[_0x7995('0x31')],_0x5a592e[_0x7995('0x2d')]);_0x4ec548[_0x7995('0x2f')]=_['intersection'](_0x5a592e['model'],qs['fields'](_0x12d4b8['query'][_0x7995('0x32')]));_0x4ec548[_0x7995('0x2f')]=_0x4ec548[_0x7995('0x2f')][_0x7995('0x33')]?_0x4ec548[_0x7995('0x2f')]:_0x5a592e[_0x7995('0x31')];if(!_0x12d4b8[_0x7995('0x2d')][_0x7995('0x34')](_0x7995('0x35'))){_0x4ec548[_0x7995('0x1f')]=qs[_0x7995('0x1f')](_0x12d4b8[_0x7995('0x2d')][_0x7995('0x1f')]);_0x4ec548[_0x7995('0x1e')]=qs[_0x7995('0x1e')](_0x12d4b8[_0x7995('0x2d')][_0x7995('0x1e')]);}_0x4ec548[_0x7995('0x36')]=qs[_0x7995('0x4b')](_0x12d4b8['query'][_0x7995('0x4b')]);_0x4ec548[_0x7995('0x37')]=qs[_0x7995('0x2e')](_[_0x7995('0x38')](_0x12d4b8['query'],_0x5a592e['filters']));if(_0x12d4b8[_0x7995('0x2d')][_0x7995('0x3d')]){_0x4ec548[_0x7995('0x37')]=_[_0x7995('0x39')](_0x4ec548['where'],{'$or':_[_0x7995('0x4c')](_0x1fd1ca,function(_0x74ff38){if(_0x74ff38[_0x7995('0x3a')][_0x7995('0x3b')]!=='VIRTUAL'){var _0x5e2d97={};_0x5e2d97[_0x74ff38[_0x7995('0x4d')]]={'$like':'%'+_0x12d4b8[_0x7995('0x2d')][_0x7995('0x3d')]+'%'};return _0x5e2d97;}})});}_0x4ec548=_[_0x7995('0x39')]({},_0x4ec548,_0x12d4b8[_0x7995('0x3e')]);var _0x27c5cd={'where':_0x4ec548[_0x7995('0x37')]};return db[_0x7995('0x2a')][_0x7995('0x1d')](_0x27c5cd)['then'](function(_0x18f230){_0xb70620[_0x7995('0x1d')]=_0x18f230;if(_0x12d4b8[_0x7995('0x2d')][_0x7995('0x3f')]){_0x4ec548['include']=[{'all':!![]}];}console['log'](_0x7995('0x4e'),_0x4ec548);return db[_0x7995('0x2a')]['findAll'](_0x4ec548);})[_0x7995('0x25')](function(_0x375fc9){_0xb70620[_0x7995('0x42')]=_0x375fc9;return _0xb70620;})[_0x7995('0x25')](respondWithFilteredResult(_0x47d1d8,_0x4ec548))[_0x7995('0x43')](handleError(_0x47d1d8,null));};exports['automaticSubscriptionInvoiceAlignment']=function(_0x457d09,_0x564fca,_0x3e0a46){var _0xe31dcb;if(_0x457d09[_0x7995('0x46')]['id']){delete _0x457d09[_0x7995('0x46')]['id'];}return db[_0x7995('0x4f')][_0x7995('0x50')](function(_0x2b3c1d){return db[_0x7995('0x51')][_0x7995('0x52')]({'where':{'defaultEntry':0x1},'raw':!![],'logging':!![]})[_0x7995('0x25')](function(_0x2618c4){_0xe31dcb=_0x2618c4;return db[_0x7995('0x2a')]['findAll']({'where':{'dateLastInvoice':null,'deleted':null,'status':null},'order':[[_0x7995('0x53'),_0x7995('0x54')],[_0x7995('0x55'),_0x7995('0x54')],[_0x7995('0x56'),'DESC']],'raw':!![],'logging':!![]});})['then'](function(_0x268fde){if(_0x268fde[_0x7995('0x33')]>0x0){var _0x221542=[];var _0xae6166=_['groupBy'](_0x268fde,_0x7995('0x53'));Object['keys'](_0xae6166)['forEach'](function(_0xca8238){var _0x36d27d=_0xae6166[_0xca8238];console[_0x7995('0x57')](_0x7995('0x58'),_0x36d27d);_0x221542[_0x7995('0x59')](addSubscriptionInvoice(_0x36d27d,_0xe31dcb,_0xca8238,_0x7995('0x5a'),_0x2b3c1d));});return BPromise[_0x7995('0x5b')](_0x221542);}});})[_0x7995('0x25')](function(){return _0x564fca[_0x7995('0x19')](0xc8);})[_0x7995('0x43')](function(_0x560b0a){console[_0x7995('0x57')](_0x7995('0x5c'),_0x560b0a);if(_0x560b0a[_0x7995('0x27')]==='SequelizeUniqueConstraintError'){var _0x560b0a={'errors':[{'message':_0x7995('0x5d')}]};}_0x564fca[_0x7995('0x1a')](0x1f4)[_0x7995('0x28')](_0x560b0a);});};function updSubscriptionDetail(_0x3b0d30,_0x51ab1e,_0x550a10){console[_0x7995('0x57')](_0x7995('0x5e'),_0x3b0d30);console[_0x7995('0x57')](_0x7995('0x5f'),_0x51ab1e);console['log']('??????\x20updSubscriptionDetail\x20product.id->',_0x3b0d30['id']);console[_0x7995('0x57')](_0x7995('0x60'),_0x3b0d30[_0x7995('0x61')]);var _0x35aaec;var _0x4dbab8;if(_0x51ab1e===_0x7995('0x5a')){_0x35aaec=moment();_0x4dbab8=_0x3b0d30[_0x7995('0x61')];}else{_0x35aaec=_0x3b0d30['dateNextInvoice'];_0x4dbab8=moment(_0x3b0d30['dateNextInvoice'])[_0x7995('0x62')](_0x3b0d30[_0x7995('0x63')],'months');}console[_0x7995('0x57')]('lastInvoice',_0x35aaec);console[_0x7995('0x57')](_0x7995('0x64'),_0x4dbab8);return db['SAAsset']['update']({'dateLastInvoice':_0x35aaec,'dateNextInvoice':_0x4dbab8,'agentFullname':_0x7995('0x65')},{'where':{'id':_0x3b0d30['id']},'raw':!![],'transaction':_0x550a10})['catch'](function(_0x31b9e6){throw _0x31b9e6;});}function addSubscriptionInvoiceDetail(_0xa41fff,_0x3dd197,_0x45bd8a){var _0x1a1873={'companyName':_0xa41fff[_0x7995('0x66')],'companyId':_0xa41fff[_0x7995('0x53')],'productName':_0xa41fff[_0x7995('0x67')],'productCode':_0xa41fff[_0x7995('0x68')],'productDescription':_0xa41fff[_0x7995('0x69')],'typeName':_0xa41fff[_0x7995('0x6a')],'pricelistName':_0xa41fff[_0x7995('0x6b')],'priceListId':_0xa41fff[_0x7995('0x55')],'netPrice':_0xa41fff[_0x7995('0x6c')],'discount':_0xa41fff[_0x7995('0x6d')],'tax':_0xa41fff[_0x7995('0x6e')],'agentFullname':_0x7995('0x65'),'note':_0xa41fff[_0x7995('0x6f')],'subscriptionId':_0xa41fff[_0x7995('0x56')],'subscriptionName':_0xa41fff[_0x7995('0x70')],'subscriptionMonthly':_0xa41fff[_0x7995('0x63')],'quantity':_0xa41fff[_0x7995('0x71')],'InvoiceId':_0x3dd197['id']};return db[_0x7995('0x72')][_0x7995('0x45')](_0x1a1873,{'raw':!![],'transaction':_0x45bd8a})[_0x7995('0x43')](function(_0x33479a){throw _0x33479a;});}function addSubscriptionInvoice(_0x2f7f51,_0x34724d,_0x59efff,_0x3fdb4b,_0x10f4ca){return db['CmCompany']['findOne']({'where':{'id':_0x59efff},'raw':!![]})[_0x7995('0x25')](function(_0x3fe8fc){return db[_0x7995('0x73')][_0x7995('0x52')]({'where':{'id':_0x3fe8fc[_0x7995('0x74')]},'raw':!![]})[_0x7995('0x25')](function(_0x5507a0){var _0x2f8a2d={'name':_0x7995('0x75')+moment()+'_'+_0x3fdb4b,'note':_0x7995('0x76'),'agentFullname':_0x7995('0x65'),'status':_0x7995('0x77'),'companyName':_0x3fe8fc[_0x7995('0x27')],'companyId':_0x3fe8fc['id'],'paid':0x0,'discount':0x0,'receivingStreet':_0x3fe8fc[_0x7995('0x78')],'receivingPostalCode':_0x3fe8fc[_0x7995('0x79')],'receivingCity':_0x3fe8fc['saCity'],'receivingCountry':_0x3fe8fc[_0x7995('0x7a')],'receivingISOCode':_0x3fe8fc[_0x7995('0x7b')],'receivingFiscalCode':_0x3fe8fc['saFiscalCode'],'receivingPIVA':_0x3fe8fc['saPIVA'],'receivingSDICode':_0x3fe8fc[_0x7995('0x7c')],'receivingFiscalMessage':_0x3fe8fc[_0x7995('0x7d')],'receivingExpiryDay':_0x3fe8fc[_0x7995('0x7e')],'receivingEurope':_0x3fe8fc[_0x7995('0x7f')],'receivingSocCap':_0x3fe8fc[_0x7995('0x80')],'issuerName':_0x34724d['name'],'issuerStreet':_0x34724d[_0x7995('0x78')],'issuerPostalCode':_0x34724d[_0x7995('0x79')],'issuerCity':_0x34724d['saCity'],'issuerCountry':_0x34724d[_0x7995('0x7a')],'issuerISOCode':_0x34724d[_0x7995('0x7b')],'issuerFiscalCode':_0x34724d['saFiscalCode'],'issuerPIVA':_0x34724d[_0x7995('0x81')],'issuerSDICode':_0x34724d['saSDICode'],'issuerFiscalMessage':_0x34724d[_0x7995('0x7d')],'issuerExpiryDay':_0x34724d[_0x7995('0x7e')],'issuerSocCap':_0x34724d[_0x7995('0x80')],'issuerBankAccount':_0x5507a0[_0x7995('0x82')],'issuerBankName':_0x5507a0[_0x7995('0x83')],'issuerBankStreet':_0x5507a0['bankstreet'],'issuerBankPostalCode':_0x5507a0[_0x7995('0x84')],'issuerBankCity':_0x5507a0[_0x7995('0x85')],'issuerBankCountry':_0x5507a0[_0x7995('0x86')],'issuerBankBICSWIFT':_0x5507a0['bankBICSWIFT'],'issuerBankIBAN':_0x5507a0[_0x7995('0x87')],'issuerPhone':_0x34724d[_0x7995('0x88')],'issuerFax':_0x34724d[_0x7995('0x89')],'issuerEmail':_0x34724d[_0x7995('0x8a')],'issuerWeb':_0x34724d['website'],'issuerABI':_0x5507a0[_0x7995('0x8b')],'issuerCAB':_0x5507a0[_0x7995('0x8c')],'issuerPayPal':_0x5507a0[_0x7995('0x8d')]};return db['SAInvoice']['create'](_0x2f8a2d,{'transaction':_0x10f4ca})[_0x7995('0x25')](function(_0x333379){var _0x4800a8=[];for(var _0x590373=0x0;_0x590373<_0x2f7f51[_0x7995('0x33')];_0x590373++){_0x4800a8[_0x7995('0x59')](updSubscriptionDetail(_0x2f7f51[_0x590373],_0x3fdb4b,_0x10f4ca));}var _0xcdbd2a=[_0x7995('0x68'),_0x7995('0x55'),'subscriptionId','netPrice'];_(_0x2f7f51)[_0x7995('0x8e')](function(_0x54fad4){return _['find'](_[_0x7995('0x38')](_0x54fad4,_0xcdbd2a),_[_0x7995('0x8f')](_[_0x7995('0x90')]));})['mapValues'](function(_0x3b1309){var _0x3cb1d2=_0x3b1309[0x0];_0x3cb1d2[_0x7995('0x71')]=_0x3b1309[_0x7995('0x33')];if(_0x3fdb4b===_0x7995('0x5a')){_0x3cb1d2['netPrice']=computePrice(_0x3cb1d2[_0x7995('0x91')],_0x3cb1d2[_0x7995('0x61')],_0x3cb1d2[_0x7995('0x6c')],_0x3cb1d2[_0x7995('0x63')]);}_0x4800a8['push'](addSubscriptionInvoiceDetail(_0x3cb1d2,_0x333379,_0x10f4ca));})[_0x7995('0x92')]();return BPromise[_0x7995('0x5b')](_0x4800a8);});});})['catch'](function(_0x310272){console[_0x7995('0x57')]('TCL:\x20exports.automaticProformaInvoice\x20->\x20err',_0x310272);throw _0x310272;});}function computePrice(_0x135f7a,_0x50efab,_0x1b4b34,_0x51e7d7){var _0x21f496=_0x1b4b34;console['log'](_0x7995('0x91'),_0x135f7a);console[_0x7995('0x57')]('dateNextInvoice',_0x50efab);console[_0x7995('0x57')]('subscriptionMonthly',_0x51e7d7);console['log'](_0x7995('0x6c'),_0x1b4b34);if(_0x51e7d7!=0x0){var _0x14812d=moment(_0x135f7a);var _0x784492=moment(_0x50efab);var _0xb7c078=Math['abs'](_0x14812d[_0x7995('0x93')](_0x784492,_0x7995('0x94')));console['log']('diffDay',_0xb7c078);var _0xc2648d=_0x1b4b34/(0x1e*_0x51e7d7);console['log'](_0x7995('0x95'),_0xc2648d);_0x21f496=_0xc2648d*_0xb7c078;}console[_0x7995('0x57')](_0x7995('0x96'),_0x21f496);return _0x21f496;}exports['automaticSubscriptionInvoice']=function(_0x48cfb7,_0x2b7852,_0x553c71){var _0x12e9d9;if(_0x48cfb7[_0x7995('0x46')]['id']){delete _0x48cfb7[_0x7995('0x46')]['id'];}return db[_0x7995('0x4f')]['transaction'](function(_0x52d102){return db['CmCompany'][_0x7995('0x52')]({'where':{'defaultEntry':0x1},'raw':!![]})[_0x7995('0x25')](function(_0x23b4c3){_0x12e9d9=_0x23b4c3;return db[_0x7995('0x2a')][_0x7995('0x41')]({'where':{'dateNextInvoice':{'$lt':moment()},'subscriptionMonthly':{'$ne':0x0},'deleted':null},'order':[[_0x7995('0x53'),'DESC'],['pricelistId',_0x7995('0x54')],['subscriptionId','DESC']],'raw':!![]});})[_0x7995('0x25')](function(_0x5e95c0){console['log'](_0x7995('0x97'),_0x5e95c0);if(_0x5e95c0[_0x7995('0x33')]>0x0){var _0x3873f3=[];var _0x5cef2e=_[_0x7995('0x8e')](_0x5e95c0,_0x7995('0x53'));Object[_0x7995('0x2c')](_0x5cef2e)[_0x7995('0x98')](function(_0x227372){var _0x178746=_0x5cef2e[_0x227372];console[_0x7995('0x57')](_0x7995('0x58'),_0x178746);_0x3873f3[_0x7995('0x59')](addSubscriptionInvoice(_0x178746,_0x12e9d9,_0x227372,'Total',_0x52d102));});return BPromise[_0x7995('0x5b')](_0x3873f3);}else{var _0x87a539={'errors':[{'type':_0x7995('0x99'),'message':_0x7995('0x9a')}]};throw _0x87a539;}});})[_0x7995('0x25')](function(){return _0x2b7852['sendStatus'](0xc8);})[_0x7995('0x43')](function(_0x9c67e5){console[_0x7995('0x57')]('TCL:\x20exports.automaticProformaInvoice\x20->\x20err',_0x9c67e5);if(_0x9c67e5['name']==='SequelizeUniqueConstraintError'){var _0x9c67e5={'errors':[{'message':_0x7995('0x5d')}]};}_0x2b7852[_0x7995('0x1a')](0x1f4)[_0x7995('0x28')](_0x9c67e5);});};
\ No newline at end of file
git://repos.xcallymotion.com / motion2.git / blobdiff