bills_lib_interfaces.js 34 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842843844845846847848849850851852853854855856857858859860861862863864865866867868869870871872873874875876877878879880881882883884885886887888889890891892893894895896897898899900901902903904905906907908909910911912913914915916917918919920921922923924925926927928929930931932933934935936937938939940941942943944945946947948949950951952953954955956957958959960961962963964965966967968969970971972973974975976977978979980981982983984985986987988989990991992993994995996997998999100010011002
  1. /**
  2. * Created by vian on 2017/3/20.
  3. */
  4. let model = require("./bills_lib_model");
  5. let counter = require("../../../public/counter/counter");
  6. let StdBillsLib = model.stdBillsLibMod;
  7. let Bills = model.billsMod;
  8. let JobContent = model.jobContentMod;
  9. let ItemCharacter = model.itemCharacterMod;
  10. /*var fieldArr = ["code", "name", "unit", "ruleText", "Expression"];*/
  11. let billsLibDao = function(){};
  12. billsLibDao.prototype.getMaxNumber = function(gData, callback){
  13. let billsLibId = gData.billsLibId;
  14. let field = gData.field;
  15. if(field === 'jobs'){
  16. JobContent.find({billsLibId: billsLibId, deleted: false}).sort({code: -1}).limit(1).exec(function(err, result){
  17. if(err){
  18. callback(1, 'Error', null);
  19. }
  20. else {
  21. callback(0, '', result);
  22. }
  23. });
  24. }
  25. else if(field === 'items'){
  26. ItemCharacter.find({billsLibId: billsLibId, deleted: false}).sort({code: -1}).limit(1).exec(function(err, result){
  27. if(err){
  28. callback(1, 'Error', null);
  29. }
  30. else {
  31. callback(0, '', result);
  32. }
  33. });
  34. }
  35. };
  36. //----------StdBillsLib-------------------
  37. billsLibDao.prototype.getABillsLib = function(data, callback){
  38. let billsLibId = data.billsLibId;
  39. StdBillsLib.find({billsLibId: billsLibId, deleted: false}, function(err, data){
  40. if(err){
  41. callback(1, 'Error', null);
  42. }
  43. else {
  44. callback(0, '', data);
  45. }
  46. });
  47. };
  48. billsLibDao.prototype.getStdBillsLib = function(data, callback){
  49. let userId = data.userId;
  50. StdBillsLib.find({userId: userId, deleted: false}, "-_id", function(err, data){
  51. if(err){
  52. callback(1, "Error", null);
  53. }
  54. else{
  55. callback(0, "", data);
  56. }
  57. })
  58. };
  59. billsLibDao.prototype.createStdBillsLib = function(clibData, callback){
  60. counter.counterDAO.getIDAfterCount(counter.moduleName.billsLib, 1, function(err, result){
  61. let billsLibId = result.value.sequence_value;
  62. let userId = clibData.userId;
  63. let billsLibName = clibData.name;
  64. let createDate = Date.now();
  65. let newStdBillsLib = {
  66. userId: userId,
  67. billsLibId: billsLibId,
  68. billsLibName: billsLibName,
  69. createDate: createDate,
  70. deleted: false
  71. };
  72. StdBillsLib.create(newStdBillsLib, function(err){
  73. if(err){
  74. callback(1, "Error", null);
  75. }
  76. else {
  77. StdBillsLib.find({billsLibId: billsLibId}, function(err, data){
  78. if(err){
  79. callback(1, "Error", null)
  80. }
  81. else {
  82. callback(0, "", data);
  83. }
  84. });
  85. }
  86. });
  87. });
  88. };
  89. billsLibDao.prototype.deleteStdBillsLib = function(billsLibId, callback){
  90. StdBillsLib.update({billsLibId: billsLibId}, {$set: {deleted: true}}, function(err){
  91. if(err){
  92. callback(1, 'Error');
  93. }
  94. else{
  95. callback(0, '');
  96. }
  97. });
  98. };
  99. billsLibDao.prototype.renameStdBillsLib = function(renameData, callback){
  100. let billsLibId = renameData.id;
  101. let renameVal = renameData.value;
  102. StdBillsLib.update({billsLibId: billsLibId}, {$set:{billsLibName: renameVal}}, function(err){
  103. if(err){
  104. callback(1, "Error");
  105. }
  106. else{
  107. callback(0, "");
  108. }
  109. });
  110. };
  111. billsLibDao.prototype.getStdBillsLibName = function(billsLibId, callback){
  112. StdBillsLib.find({billsLibId: billsLibId, deleted: false}, "-_id", function(err, data){
  113. if(err){
  114. callback(1, "Error", null);
  115. }
  116. else {
  117. callback(0, "", data);
  118. }
  119. });
  120. };
  121. billsLibDao.prototype.getCurrentUniqId = function(callback){
  122. counter.counterDAO.getCurrentID(counter.moduleName.billsLib, function(result, err){
  123. let id = result.sequence_value;
  124. if(err){
  125. console.log(`enter1`);
  126. callback(1, 'Error', null);
  127. }
  128. else{
  129. console.log(`enter2: ${result}`);
  130. console.log(`enter2-id: ${id}`);
  131. callback(0, '', id);
  132. }
  133. });
  134. }
  135. //----------------------------Bills---------------------
  136. billsLibDao.prototype.getBills = function (billsLibId, callback) {
  137. Bills.find({billsLibId: billsLibId, deleted: false}, "-_id", function(err, billsData){
  138. if(err){
  139. callback(1, "Error", null);
  140. }
  141. else{
  142. callback(0, "", billsData);
  143. }
  144. });
  145. }
  146. billsLibDao.prototype.createBills = function(cbillsData, callback){
  147. let newId = cbillsData.newId;
  148. let pid = cbillsData.ParentID;
  149. let nid = cbillsData.NextSiblingID;
  150. let billsLibId = cbillsData.billsLibId;
  151. let newBills = {
  152. ID: newId,
  153. ParentID: pid,
  154. NextSiblingID: nid,
  155. billsLibId: billsLibId,
  156. code: '',
  157. name: '',
  158. unit: '',
  159. ruleText: '',
  160. Expression: '',
  161. recharge:'',
  162. deleted: false
  163. };
  164. Bills.create(newBills, function(err){
  165. if(err){
  166. callback(1, "Error");
  167. }
  168. else{
  169. callback(0, "");
  170. }
  171. });
  172. };
  173. billsLibDao.prototype.updatePNId= function(upData, callback){
  174. let billsLibId = upData.billsLibId;
  175. let updateDatas = upData.updateData;
  176. let success = true;
  177. if(updateDatas.length > 0){
  178. updateDatas.forEach(function(data){
  179. if(data.ID.length >1){
  180. data.ID.forEach(function(id){
  181. if(data.ParentID && data.NextSiblingID){
  182. Bills.update({billsLibId: billsLibId, ID: id}, {$set: {ParentID: data.ParentID, NextSiblingID: data.NextSiblingID}}, function(err){
  183. if(err){
  184. callback(1, "Error")
  185. success = false;
  186. }
  187. });
  188. }
  189. else if(data.ParentID && !data.NextSiblingID){
  190. Bills.update({billsLibId: billsLibId, ID: id}, {$set: {ParentID: data.ParentID}}, function(err){
  191. if(err){
  192. callback(1, 'Error');
  193. success = false;
  194. }
  195. });
  196. }
  197. else if(!data.ParentID && data.NextSiblingID){
  198. Bills.update({billsLibId: billsLibId, ID: id}, {$set: {NextSiblingID: data.NextSiblingID}}, function(err){
  199. if(err){
  200. callback(1, 'Error');
  201. success = false;
  202. }
  203. });
  204. }
  205. });
  206. }
  207. else {
  208. if(data.ParentID && data.NextSiblingID){
  209. Bills.update({billsLibId: billsLibId, ID: data.ID}, {$set: {ParentID: data.ParentID, NextSiblingID: data.NextSiblingID}}, function(err){
  210. if(err){
  211. callback(1, "Error")
  212. success = false;
  213. }
  214. });
  215. }
  216. else if(data.ParentID && !data.NextSiblingID){
  217. Bills.update({billsLibId: billsLibId, ID: data.ID}, {$set: {ParentID: data.ParentID}}, function(err){
  218. if(err){
  219. callback(1, 'Error');
  220. success = false;
  221. }
  222. });
  223. }
  224. else if(!data.ParentID && data.NextSiblingID){
  225. Bills.update({billsLibId: billsLibId, ID: data.ID}, {$set: {NextSiblingID: data.NextSiblingID}}, function(err){
  226. if(err){
  227. callback(1, 'Error');
  228. success = false;
  229. }
  230. });
  231. }
  232. }
  233. });
  234. }
  235. if(success){
  236. callback(0, '');
  237. }
  238. }
  239. billsLibDao.prototype.updateBills = function(ubillsData, callback){
  240. let billsLibId = ubillsData.billsLibId;
  241. let updateId = ubillsData.updateId;
  242. let updateField = ubillsData.field;
  243. let updateData = ubillsData.data;
  244. if(updateField === "code"){
  245. Bills.update({billsLibId: billsLibId, ID: updateId}, {$set: {code: updateData}}, function(err){
  246. if(err){
  247. callback(1, "Error");
  248. }
  249. else {
  250. callback(0, "");
  251. }
  252. });
  253. }
  254. else if(updateField === "name"){
  255. Bills.update({billsLibId: billsLibId, ID: updateId}, {$set: {name: updateData}}, function(err){
  256. if(err){
  257. callback(1, "Error");
  258. }
  259. else {
  260. callback(0, "");
  261. }
  262. });
  263. }
  264. else if(updateField === "unit"){
  265. Bills.update({billsLibId: billsLibId, ID: updateId}, {$set: {unit: updateData}}, function(err){
  266. if(err){
  267. callback(1, "Error");
  268. }
  269. else {
  270. callback(0, "");
  271. }
  272. });
  273. }
  274. else if(updateField === "ruleText"){
  275. Bills.update({billsLibId: billsLibId, ID: updateId}, {$set: {ruleText: updateData}}, function(err){
  276. if(err){
  277. callback(1, "Error");
  278. }
  279. else {
  280. callback(0, "");
  281. }
  282. });
  283. }
  284. else if(updateField === "jobs"){
  285. Bills.update({billsLibId: billsLibId, ID: updateId}, {$addToSet: {jobs: updateData}}, function(err){
  286. if(err){
  287. callback(1, "Error");
  288. }
  289. else {
  290. callback(0, "");
  291. }
  292. });
  293. }
  294. else if(updateField === "items"){
  295. Bills.update({billsLibId: billsLibId, ID: updateId}, {$addToSet: {items: updateData}}, function(err){
  296. if(err){
  297. callback(1, "Error");
  298. }
  299. else {
  300. callback(0, "");
  301. }
  302. });
  303. }
  304. }
  305. billsLibDao.prototype.updateBillsArr = function(updateData, callback){
  306. let billsLibId = updateData.billsLibId;
  307. let updateId = updateData.updateId;
  308. let orgId = updateData.orgId;
  309. let newId = updateData.newId;
  310. let classify = updateData.classify;
  311. let type = updateData.type;
  312. let success = true;
  313. if(classify === 'jobs'){
  314. if(orgId && newId && type === 'update'){
  315. Bills.update({billsLibId: billsLibId, ID: updateId, jobs: orgId}, {$set: {'jobs.$': newId}}, function(err){
  316. if(err){
  317. callback(1, 'Error');
  318. }
  319. else {
  320. callback(0, '');
  321. }
  322. });
  323. }
  324. if(orgId && !newId && type === 'delete'){
  325. orgId.forEach(function(oid){
  326. Bills.update({billsLibId: billsLibId, ID: updateId}, {$pull: {jobs: oid}}, function(err){
  327. if(err){
  328. callback(1, 'Error');
  329. }
  330. });
  331. });
  332. }
  333. //todo: test
  334. if(orgId && !newId && type === 'deleteAll'){
  335. updateId.forEach(function(uid){
  336. orgId.forEach(function(oid){
  337. Bills.update({billsLibId: billsLibId, ID: uid}, {$pull: {jobs: oid}}, function(err){
  338. if(err){
  339. callback(1, 'Error');
  340. }
  341. });
  342. });
  343. });
  344. }
  345. }
  346. else if(classify === 'items'){
  347. if(orgId && newId && type === 'update'){
  348. Bills.update({billsLibId: billsLibId, ID: updateId, items: orgId}, {$set: {'items.$': newId}}, function(err){
  349. if(err){
  350. callback(1, 'Error');
  351. }
  352. else {
  353. callback(0, '');
  354. }
  355. });
  356. }
  357. if(orgId && !newId && type === 'delete'){
  358. orgId.forEach(function(oid){
  359. Bills.update({billsLibId: billsLibId, ID: updateId}, {$pull: {items: oid}}, function(err){
  360. if(err){
  361. callback(1, 'Error');
  362. }
  363. });
  364. });
  365. }
  366. if(orgId && !newId && type === 'deleteAll'){
  367. updateId.forEach(function(uid){
  368. orgId.forEach(function(oid){
  369. Bills.update({billsLibId: billsLibId, ID: uid}, {$pull: {items: oid}}, function(err){
  370. if(err){
  371. callback(1, 'Error');
  372. }
  373. });
  374. });
  375. });
  376. }
  377. }
  378. };
  379. billsLibDao.prototype.pasteBills = function(pData, callback){
  380. let datas = pData.datas;
  381. datas.forEach(function(data){
  382. Bills.update({billsLibId: data.billsLibId, ID: data.ID}, {$set: {code: data.code, name: data.name, unit: data.unit, ruleText: data.ruleText}}, function(err){
  383. if(err){
  384. callback(1, 'Error');
  385. }
  386. });
  387. });
  388. }
  389. billsLibDao.prototype.updateRecharge = function(uData, callback){
  390. let billsLibId = uData.billsLibId;
  391. let updateIds = uData.updateIds;
  392. let data = uData.data;
  393. let success = true;
  394. updateIds.forEach(function(id){
  395. Bills.update({billsLibId: billsLibId, ID: id}, {$set: {recharge: data}}, function(err){
  396. if(err){
  397. callback(1, 'Error');
  398. success = false;
  399. }
  400. });
  401. });
  402. if(success){
  403. callback(0, '');
  404. }
  405. };
  406. billsLibDao.prototype.pasteRel = function (data, callback) {
  407. const UpdateExist = 'updateExist', UpdateNew = 'updateNew', CreateExist = 'createExist', CreateNew = 'createNew';
  408. let success = true;
  409. let ueDatas = [], unDatas = [], ceDatas = [], cnDatas = [];
  410. let frontDatas ;
  411. let pasteDatas = data.pasteDatas;
  412. let field = data.field;
  413. let updateDatas = pasteDatas.updateDatas;
  414. let createDatas = pasteDatas.createDatas;
  415. const Jobs = 'jobs', Items = 'items';
  416. if(field === Jobs){
  417. if(updateDatas.length > 0){
  418. for(let i=0; i<updateDatas.length; i++){
  419. if(updateDatas[i].type === UpdateExist){
  420. let orgJobId = updateDatas[i].orgJobId, newJobId = updateDatas[i].newJobId,
  421. nodeId = updateDatas[i].nodeId, billsLibId = updateDatas[i].billsLibId, newData = updateDatas[i].newData;
  422. if(orgJobId && newJobId && nodeId && billsLibId){
  423. Bills.update({billsLibId: billsLibId, ID: nodeId, jobs: orgJobId}, {$set: {'jobs.$': newJobId}}, function(err){
  424. if(err){
  425. success = false;
  426. }
  427. else{
  428. }
  429. });
  430. }
  431. }
  432. if(updateDatas[i].type === UpdateNew){
  433. let billsLibId = updateDatas[i].billsLibId, nodeId = updateDatas[i].nodeId, newData = updateDatas[i].newData,
  434. orgJobId = updateDatas[i].orgJobId, code = updateDatas[i].code, id = updateDatas[i].newJobId;
  435. if(billsLibId && nodeId && newData && orgJobId && code && id){
  436. let newJobContent;
  437. newJobContent = {
  438. id: id,
  439. billsLibId: billsLibId,
  440. code: code,
  441. content: newData,
  442. deleted: false
  443. }
  444. JobContent.create(newJobContent, function(err){
  445. if(err){
  446. success = false;
  447. }
  448. else{
  449. Bills.update({billsLibId: billsLibId, ID: nodeId, jobs: orgJobId}, {$set: {'jobs.$': id}}, function(err){
  450. if(err){
  451. success = false;
  452. }
  453. else{
  454. }
  455. });
  456. }
  457. });
  458. }
  459. }
  460. }
  461. }
  462. if(createDatas.length > 0){
  463. for(let i=0; i<createDatas.length; i++){
  464. if(createDatas[i].type === CreateExist){
  465. let billsLibId = createDatas[i].billsLibId, newData = createDatas[i].newData,
  466. nodeId = createDatas[i].nodeId, jobId = createDatas[i].jobId;
  467. if(billsLibId && newData && nodeId && jobId){
  468. Bills.update({billsLibId: billsLibId, ID: nodeId}, {$addToSet: {jobs: jobId}}, function(err){
  469. if(err){
  470. success = false;
  471. }
  472. else {
  473. }
  474. });
  475. }
  476. }
  477. if(createDatas[i].type === CreateNew){
  478. let billsLibId = createDatas[i].billsLibId, newData = createDatas[i].newData,
  479. code = createDatas[i].code, nodeId = createDatas[i].nodeId, id = createDatas[i].id;
  480. if(billsLibId && newData && code && id){
  481. let newJobContent;
  482. newJobContent = {
  483. id: id,
  484. billsLibId: billsLibId,
  485. code: code,
  486. content: newData,
  487. deleted: false
  488. }
  489. JobContent.create(newJobContent, function(err){
  490. if(err){
  491. success = false;
  492. }
  493. else{
  494. Bills.update({billsLibId: billsLibId, ID: nodeId}, {$addToSet: {jobs: id}}, function(err){
  495. if(err){
  496. success = false;
  497. }
  498. else {
  499. }
  500. });
  501. }
  502. });
  503. }
  504. }
  505. }
  506. }
  507. }
  508. if(field === Items){
  509. if(updateDatas.length > 0){
  510. for(let i=0; i<updateDatas.length; i++){
  511. if(updateDatas[i].type === UpdateExist){
  512. let orgItemId = updateDatas[i].orgItemId, newItemId = updateDatas[i].newItemId,
  513. nodeId = updateDatas[i].nodeId, billsLibId = updateDatas[i].billsLibId, newData = updateDatas[i].newData;
  514. if(orgItemId && newItemId && nodeId && billsLibId){
  515. Bills.update({billsLibId: billsLibId, ID: nodeId, items: orgItemId}, {$set: {'items.$': newItemId}}, function(err){
  516. if(err){
  517. success = false;
  518. }
  519. else{
  520. }
  521. });
  522. }
  523. }
  524. if(updateDatas[i].type === UpdateNew){
  525. let billsLibId = updateDatas[i].billsLibId, nodeId = updateDatas[i].nodeId, newData = updateDatas[i].newData,
  526. orgItemId = updateDatas[i].orgItemId, code = updateDatas[i].code, id = updateDatas[i].newItemId;
  527. if(billsLibId && nodeId && newData && orgItemId && code && id){
  528. let newItemContent;
  529. newItemContent = {
  530. id: id,
  531. billsLibId: billsLibId,
  532. code: code,
  533. content: newData,
  534. deleted: false
  535. }
  536. ItemCharacter.create(newItemContent, function(err){
  537. if(err){
  538. success = false;
  539. }
  540. else{
  541. Bills.update({billsLibId: billsLibId, ID: nodeId, items: orgItemId}, {$set: {'items.$': id}}, function(err){
  542. if(err){
  543. success = false;
  544. }
  545. else{
  546. }
  547. });
  548. }
  549. });
  550. }
  551. }
  552. }
  553. }
  554. if(createDatas.length > 0){
  555. for(let i=0; i<createDatas.length; i++){
  556. if(createDatas[i].type === CreateExist){
  557. let billsLibId = createDatas[i].billsLibId, newData = createDatas[i].newData,
  558. nodeId = createDatas[i].nodeId, itemId = createDatas[i].itemId;
  559. if(billsLibId && newData && nodeId && itemId){
  560. Bills.update({billsLibId: billsLibId, ID: nodeId}, {$addToSet: {items: itemId}}, function(err){
  561. if(err){
  562. success = false;
  563. }
  564. else {
  565. }
  566. });
  567. }
  568. }
  569. if(createDatas[i].type === CreateNew){
  570. let billsLibId = createDatas[i].billsLibId, newData = createDatas[i].newData,
  571. code = createDatas[i].code, nodeId = createDatas[i].nodeId, id = createDatas[i].id;
  572. if(billsLibId && newData && code && id){
  573. let newItemContent;
  574. newItemContent = {
  575. id: id,
  576. billsLibId: billsLibId,
  577. code: code,
  578. content: newData,
  579. deleted: false
  580. }
  581. ItemCharacter.create(newItemContent, function(err){
  582. if(err){
  583. success = false;
  584. }
  585. else{
  586. Bills.update({billsLibId: billsLibId, ID: nodeId}, {$addToSet: {items: id}}, function(err){
  587. if(err){
  588. success = false;
  589. }
  590. else {
  591. }
  592. });
  593. }
  594. });
  595. }
  596. }
  597. }
  598. }
  599. }
  600. };
  601. billsLibDao.prototype.deleteBills = function(delData, callback){
  602. let deleteIds = delData.deleteIds;
  603. let billsLibId = delData.billsLibId;
  604. let success = true;
  605. if(deleteIds){
  606. deleteIds.forEach(function(delId){
  607. Bills.update({billsLibId: billsLibId, ID: delId}, {$set: {deleted: true}}, function(err){
  608. if(err){
  609. success = false;
  610. callback(1, 'Error');
  611. }
  612. });
  613. });
  614. if(success){
  615. callback(0, '');
  616. }
  617. }
  618. }
  619. //--------------JobContent------------------
  620. billsLibDao.prototype.getJobContent = function(gJobData, callback){
  621. let billsLibId = gJobData.billsLibId;
  622. JobContent.find({billsLibId: billsLibId, deleted: false}, '-_id').sort({code: 1}).exec(function(err, result){
  623. if(err){
  624. callback(1, 'Error', null);
  625. }
  626. else {
  627. callback(0, '', result);
  628. }
  629. });
  630. }
  631. billsLibDao.prototype.createJobContent = function(cJobData, callback){
  632. let data = cJobData.data;
  633. let billsLibId = cJobData.billsLibId;
  634. let serialNo = cJobData.serialNo;
  635. let id = cJobData.id;
  636. let newJobContent;
  637. newJobContent = {
  638. id: id,
  639. billsLibId: billsLibId,
  640. code: serialNo,
  641. content: data,
  642. deleted: false
  643. }
  644. JobContent.create(newJobContent, function(err){
  645. if(err){
  646. callback(1, "Error", null);
  647. }
  648. else{
  649. callback(0, "", id);
  650. }
  651. });
  652. };
  653. billsLibDao.prototype.updateJobContent = function(uJobData, callback){
  654. let billsLibId = uJobData.billsLibId;
  655. let field = uJobData.field;
  656. let updateData = uJobData.data;
  657. let updateid = uJobData.updateId;
  658. if(field == "code"){
  659. JobContent.update({billsLibId: billsLibId, id: updateid}, {$set: {code: updateData}}, function(err){
  660. if(err){
  661. callback(1, "Error");
  662. }
  663. else{
  664. callback(0, "");
  665. }
  666. });
  667. }
  668. else if(field == "content"){
  669. JobContent.update({billsLibId: billsLibId, id: updateid}, {$set: {content: updateData}}, function(err){
  670. if(err){
  671. callback(1, "Error");
  672. }
  673. else{
  674. callback(0, "");
  675. }
  676. });
  677. }
  678. };
  679. billsLibDao.prototype.deleteJobContent = function(data, callback){
  680. let delIds = data.ids;
  681. let billsLibId = data.billsLibId;
  682. let success = true;
  683. delIds.forEach(function(id){
  684. JobContent.update({billsLibId: billsLibId, id: id}, {$set: {deleted: true}}, function(err){
  685. if(err){
  686. success = false;
  687. callback(1, 'Error');
  688. }
  689. });
  690. });
  691. }
  692. billsLibDao.prototype.pasteJobs = function (data, callback) {
  693. let pasteDatas = data.pasteDatas;
  694. let updateDatas = pasteDatas.updateDatas,
  695. createDatas = pasteDatas.createDatas;
  696. if(updateDatas.length > 0){
  697. for(let i=0; i<updateDatas.length; i++){
  698. let updateId = updateDatas[i].orgId,
  699. field = updateDatas[i].field,
  700. updateData = updateDatas[i].data, billsLibId = updateDatas[i].billsLibId;
  701. if(field === 'code'){
  702. JobContent.update({billsLibId: billsLibId, id: updateId}, {$set: {code: updateData}}, function(err){
  703. if(err){
  704. }
  705. });
  706. }
  707. else{
  708. JobContent.update({billsLibId: billsLibId, id: updateId}, {$set: {content: updateData}}, function(err){
  709. if(err){
  710. }
  711. });
  712. }
  713. }
  714. }
  715. if(createDatas.length > 0){
  716. for(let i =0; i<createDatas.length; i++){
  717. let billsLibId = createDatas[i].billsLibId, id = createDatas[i].id,
  718. code , content;
  719. let jobObj;
  720. if(createDatas[i].type === 'CreateT'){
  721. jobObj = {
  722. billsLibId: billsLibId,
  723. id: id,
  724. code: createDatas[i].code,
  725. content: createDatas[i].content,
  726. deleted: false
  727. }
  728. }
  729. else{
  730. if(createDatas[i].field === 'code'){
  731. jobObj = {
  732. billsLibId: billsLibId,
  733. id: id,
  734. code: createDatas[i].data,
  735. content: '',
  736. deleted: false
  737. }
  738. }
  739. else {
  740. jobObj = {
  741. billsLibId: billsLibId,
  742. id: id,
  743. code: createDatas[i].code,
  744. content: createDatas[i].data,
  745. deleted: false
  746. }
  747. }
  748. }
  749. JobContent.create(jobObj, function(err){
  750. if(err){
  751. }
  752. });
  753. }
  754. }
  755. }
  756. //----------------------ItemCharacter---------------------
  757. billsLibDao.prototype.getItemCharacter = function(gdata, callback){
  758. let billsLibId = gdata.billsLibId;
  759. ItemCharacter.find({billsLibId: billsLibId, deleted: false}, '-_id').sort({code: 1}).exec(function(err, result){
  760. if(err){
  761. callback(1, 'Error', null);
  762. }
  763. else {
  764. callback(0, '', result);
  765. }
  766. });
  767. }
  768. billsLibDao.prototype.createItemCharacter = function(cItemData, callback){
  769. let data = cItemData.data;
  770. let billsLibId = cItemData.billsLibId;
  771. let serialNo = cItemData.serialNo;
  772. let newItemCharacter;
  773. let id = cItemData.id;
  774. newItemCharacter = {
  775. id: id,
  776. billsLibId: billsLibId,
  777. content: data,
  778. code: serialNo,
  779. deleted: false
  780. }
  781. ItemCharacter.create(newItemCharacter, function(err){
  782. if(err){
  783. callback(1, "Error", null);
  784. }
  785. else{
  786. callback(0, "", id);
  787. }
  788. });
  789. };
  790. billsLibDao.prototype.updateItemCharacter = function(uItemData, callback){
  791. let field = uItemData.field;
  792. let updateData = uItemData.data;
  793. let id = uItemData.updateId;
  794. let billsLibId = uItemData.billsLibId;
  795. if(field === "code"){
  796. ItemCharacter.update({billsLibId: billsLibId, id: id}, {$set: {code: updateData}}, function(err){
  797. if(err){
  798. callback(1, "Error");
  799. }
  800. else{
  801. callback(0, "");
  802. }
  803. });
  804. }
  805. else if(field === "content"){
  806. ItemCharacter.update({billsLibId: billsLibId, id: id}, {$set: {content: updateData}}, function(err){
  807. if(err){
  808. callback(1, "Error");
  809. }
  810. else{
  811. callback(0, "");
  812. }
  813. });
  814. }
  815. };
  816. billsLibDao.prototype.updateValue = function(uData, callback){
  817. let type = uData.type;
  818. let updateId = uData.updateId;
  819. let data = uData.data;
  820. let deleteCodes = uData.deleteCodes;
  821. let billsLibId = uData.billsLibId;
  822. if(type === 'create'){
  823. ItemCharacter.update({billsLibId: billsLibId, id: updateId}, {$addToSet: {itemValue: data}}, function(err){
  824. if(err){
  825. callback(1, 'Error');
  826. }
  827. else{
  828. callback(0, '');
  829. }
  830. });
  831. }
  832. else if(type === 'update'){
  833. if(data.field === 'code'){
  834. ItemCharacter.update({billsLibId: billsLibId, id: updateId, 'itemValue.code': data.code}, {$set: {'itemValue.$.code': data.newData}}, function(err){
  835. if(err){
  836. callback(1, 'Error');
  837. }
  838. else{
  839. callback(0, '');
  840. }
  841. });
  842. }
  843. else {
  844. ItemCharacter.update({billsLibId: billsLibId, id: updateId, 'itemValue.code': data.code}, {$set: {'itemValue.$.value': data.newData}}, function(err){
  845. if(err){
  846. callback(1, 'Error');
  847. }
  848. else{
  849. callback(0, '');
  850. }
  851. });
  852. }
  853. }
  854. //delete
  855. else {
  856. if(deleteCodes.length > 0){
  857. deleteCodes.forEach(function(code){
  858. ItemCharacter.update({billsLibId: billsLibId, id: updateId}, {$pull: {itemValue: {code: code}}}, function(err){
  859. if(err){
  860. callback(1, 'Error');
  861. }
  862. });
  863. });
  864. }
  865. }
  866. };
  867. billsLibDao.prototype.deleteItemCharacter = function(data, callback){
  868. let delIds = data.ids;
  869. let success = true;
  870. let billsLibId = data.billsLibId;
  871. delIds.forEach(function(id){
  872. /*ItemCharacter.remove({id: id}, function(err){
  873. if(err){
  874. callback(1, "Error");
  875. }
  876. });*/
  877. ItemCharacter.update({billsLibId: billsLibId, id: id}, {$set: {deleted: true}}, function(err){
  878. if(err){
  879. success = false;
  880. callback(1, 'Error');
  881. }
  882. });
  883. });
  884. }
  885. billsLibDao.prototype.pasteItems = function (data, callback) {
  886. let pasteDatas = data.pasteDatas;
  887. let updateDatas = pasteDatas.updateDatas,
  888. createDatas = pasteDatas.createDatas;
  889. if(updateDatas.length > 0){
  890. for(let i=0; i<updateDatas.length; i++){
  891. let updateId = updateDatas[i].orgId,
  892. field = updateDatas[i].field,
  893. updateData = updateDatas[i].data, billsLibId = updateDatas[i].billsLibId;
  894. if(field === 'code'){
  895. ItemCharacter.update({billsLibId: billsLibId, id: updateId}, {$set: {code: updateData}}, function(err){
  896. if(err){
  897. }
  898. });
  899. }
  900. else{
  901. ItemCharacter.update({billsLibId: billsLibId, id: updateId}, {$set: {content: updateData}}, function(err){
  902. if(err){
  903. }
  904. });
  905. }
  906. }
  907. }
  908. if(createDatas.length > 0){
  909. for(let i =0; i<createDatas.length; i++){
  910. let billsLibId = createDatas[i].billsLibId, id = createDatas[i].id,
  911. code , content;
  912. let itemObj;
  913. if(createDatas[i].type === 'CreateT'){
  914. itemObj = {
  915. billsLibId: billsLibId,
  916. id: id,
  917. code: createDatas[i].code,
  918. content: createDatas[i].content,
  919. deleted: false
  920. }
  921. }
  922. else{
  923. if(createDatas[i].field === 'code'){
  924. itemObj = {
  925. billsLibId: billsLibId,
  926. id: id,
  927. code: createDatas[i].data,
  928. content: '',
  929. deleted: false
  930. }
  931. }
  932. else {
  933. itemObj = {
  934. billsLibId: billsLibId,
  935. id: id,
  936. code: createDatas[i].code,
  937. content: createDatas[i].data,
  938. deleted: false
  939. }
  940. }
  941. }
  942. ItemCharacter.create(itemObj, function(err){
  943. if(err){
  944. }
  945. });
  946. }
  947. }
  948. };
  949. //
  950. module.exports = new billsLibDao();