home.js 24 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661
  1. const axios = require("axios");
  2. const bcrypt = require("bcryptjs");
  3. const Merchant = require("../models/merchant");
  4. const Ingredient = require("../models/ingredient");
  5. const Recipe = require("../models/recipe");
  6. const Transaction = require("../models/transaction");
  7. const nonPosTransaction = require("../models/nonPosTransaction");
  8. const InventoryAdjustment = require("../models/inventoryAdjustment");
  9. const token = "b48068eb-411a-918e-ea64-52007147e42c";
  10. module.exports = {
  11. landingPage: function(req, res){
  12. return res.render("landingPage/landing");
  13. },
  14. displayInventory: function(req, res){
  15. if(!req.session.user){
  16. return res.redirect("/");
  17. }
  18. Merchant.findOne({_id: req.session.user})
  19. .populate("inventory.ingredient")
  20. .populate("recipes")
  21. .then((merchant)=>{
  22. if(merchant.pos === "clover"){
  23. axios.get(`https://apisandbox.dev.clover.com/v3/merchants/${merchant.posId}/orders?filter=clientCreatedTime>=${merchant.lastUpdatedTime}&expand=lineItems&access_token=${token}`)
  24. .then((result)=>{
  25. let transactions = [];
  26. for(let order of result.data.elements){
  27. let newTransaction = new Transaction({
  28. merchant: merchant._id,
  29. date: new Date(order.createdTime),
  30. device: order.device.id
  31. });
  32. for(let item of order.lineItems.elements){
  33. let recipe = merchant.recipes.find(r => r.posId === item.item.id);
  34. if(recipe){
  35. newTransaction.recipes.push(recipe._id);
  36. for(let ingredient of recipe.ingredients){
  37. let inventoryIngredient = {};
  38. for(let invItem of merchant.inventory){
  39. if(invItem.ingredient._id.toString() === ingredient.ingredient.toString()){
  40. inventoryIngredient = invItem;
  41. }
  42. }
  43. inventoryIngredient.quantity -= ingredient.quantity;
  44. }
  45. }
  46. }
  47. transactions.push(newTransaction);
  48. }
  49. merchant.lastUpdatedTime = Date.now();
  50. merchant.save()
  51. .then((updatedMerchant)=>{
  52. res.render("inventoryPage/inventory", {merchant: updatedMerchant});
  53. Transaction.create(transactions);
  54. return;
  55. })
  56. .catch((err)=>{
  57. console.log(err);
  58. return res.render("error");
  59. });
  60. })
  61. .catch((err)=>{
  62. console.log(err);
  63. });
  64. }else if(merchant.pos === "none"){
  65. return res.render("inventoryPage/inventory", {merchant: merchant})
  66. }else{
  67. return res.redirect("/");
  68. }
  69. })
  70. .catch((err)=>{
  71. console.log(err);
  72. return res.render("error");
  73. });
  74. },
  75. //Display page to set up new merchant with Clover POS
  76. //TODO: This is for development, needs updating for production
  77. merchantSetupClover: function(req, res){
  78. req.session.posId = "YHVPCQMVB1P81";
  79. Ingredient.find()
  80. .then((ingredients)=>{
  81. axios.get(`https://apisandbox.dev.clover.com/v3/merchants/${req.session.posId}/items?access_token=${token}`)
  82. .then((recipes)=>{
  83. return res.render("merchantSetupPage/merchantSetup", {ingredients: ingredients, recipes: recipes.data});
  84. })
  85. .catch((err)=>{
  86. console.log(err);
  87. return res.render("error");
  88. });
  89. })
  90. .catch((err)=>{
  91. console.log(err);
  92. return res.render("error");
  93. });
  94. },
  95. //Display page to set up merchant with no POS system
  96. merchantSetupNone: function(req, res){
  97. Ingredient.find()
  98. .then((ingredients)=>{
  99. return res.render("merchantSetupPage/merchantSetup", {ingredients: ingredients, recipes: null});
  100. })
  101. .catch((err)=>{
  102. console.log(err);
  103. return res.render("error");
  104. });
  105. },
  106. displayRecipes: function(req, res){
  107. if(!req.session.user){
  108. return res.render("error");
  109. }
  110. Merchant.findOne({_id: req.session.user})
  111. .populate({
  112. path: "recipes",
  113. model: "Recipe",
  114. populate: {
  115. path: "ingredients.ingredient",
  116. model: "Ingredient"
  117. }
  118. })
  119. .populate("inventory.ingredient")
  120. .then((merchant)=>{
  121. return res.render("recipesPage/recipes", {merchant: merchant});
  122. })
  123. .catch((err)=>{
  124. console.log(err);
  125. return res.render("error");
  126. });
  127. },
  128. updateRecipes: function(req, res){
  129. if(!req.session.user){
  130. return res.render("error");
  131. }
  132. Merchant.findOne({_id: req.session.user})
  133. .populate("recipes")
  134. .then((merchant)=>{
  135. axios.get(`https://apisandbox.dev.clover.com/v3/merchants/${req.session.user}/items?access_token=${token}`)
  136. .then((result)=>{
  137. let deletedRecipes = merchant.recipes.slice();
  138. for(let i = 0; i < result.data.elements.length; i++){
  139. for(let j = 0; j < deletedRecipes.length; j++){
  140. if(result.data.elements[i].id === deletedRecipes[j].posId){
  141. result.data.elements.splice(i, 1);
  142. deletedRecipes.splice(j, 1);
  143. i--;
  144. break;
  145. }
  146. }
  147. }
  148. for(let recipe of deletedRecipes){
  149. for(let i = 0; i < merchant.recipes.length; i++){
  150. if(recipe._id === merchant.recipes[i]._id){
  151. merchant.recipes.splice(i, 1);
  152. break;
  153. }
  154. }
  155. }
  156. let newRecipes = []
  157. for(let recipe of result.data.elements){
  158. let newRecipe = new Recipe({
  159. posId: recipe.id,
  160. merchant: merchant._id,
  161. name: recipe.name,
  162. ingredients: []
  163. });
  164. merchant.recipes.push(newRecipe);
  165. newRecipes.push(newRecipe);
  166. }
  167. Recipe.create(newRecipes)
  168. .catch((err)=>{
  169. console.log(err);
  170. return res.render("error");
  171. });
  172. merchant.save()
  173. .then((newMerchant)=>{
  174. newMerchant.populate("recipes.ingredients.ingredient").execPopulate()
  175. .then((newestMerchant)=>{
  176. return res.json({merchant: newestMerchant, count: result.data.elements.length});
  177. })
  178. .catch((err)=>{
  179. console.log(err);
  180. return res.render("error");
  181. });
  182. })
  183. .catch((err)=>{
  184. console.log(err);
  185. return res.render("error");
  186. });
  187. })
  188. .catch((err)=>{
  189. console.log(err);
  190. return res.render("error");
  191. });
  192. })
  193. .catch((err)=>{
  194. console.log(err);
  195. return res.render("error");
  196. });
  197. },
  198. createMerchantClover: function(req, res){
  199. let data = JSON.parse(req.body.data);
  200. axios.get(`https://apisandbox.dev.clover.com/v3/merchants/${req.session.posId}?access_token=${token}`)
  201. .then((cloverMerchant)=>{
  202. req.session.posId = undefined;
  203. let salt = bcrypt.genSaltSync(10);
  204. let hash = bcrypt.hashSync(data.password, salt);
  205. let merchant = new Merchant({
  206. name: cloverMerchant.data.name,
  207. email: data.email,
  208. password: hash,
  209. pos: "clover",
  210. posId: cloverMerchant.data.id
  211. });
  212. for(let item of data.inventory){
  213. merchant.inventory.push({
  214. ingredient: item.ingredient.id,
  215. quantity: item.quantity
  216. });
  217. }
  218. for(let recipe of data.recipes){
  219. recipe.merchant = merchant._id;
  220. }
  221. Recipe.create(data.recipes)
  222. .then((recipes)=>{
  223. for(let recipe of recipes){
  224. merchant.recipes.push(recipe._id);
  225. }
  226. merchant.save()
  227. .then((merchant)=>{
  228. req.session.user = merchant._id;
  229. return res.redirect("/inventory");
  230. })
  231. .catch((err)=>{
  232. console.log(err);
  233. return res.render("error");
  234. });
  235. })
  236. .catch((err)=>{
  237. console.log(err);
  238. return res.render("error");
  239. });
  240. Recipe.create(newRecipes)
  241. .then((recipes)=>{
  242. for(let recipe of recipes){
  243. newMerchant.recipes.push(recipe);
  244. }
  245. newMerchant.save()
  246. .then((merchant)=>{
  247. return res.redirect("/inventory");
  248. })
  249. .catch((err)=>{
  250. console.log(err);
  251. return res.render("error");
  252. });
  253. })
  254. .catch((err)=>{
  255. console.log(err);
  256. return res.render("error");
  257. });
  258. })
  259. .catch((err)=>{
  260. console.log(err);
  261. });
  262. },
  263. createMerchantNone: function(req, res){
  264. let data = JSON.parse(req.body.data);
  265. let salt = bcrypt.genSaltSync(10);
  266. let hash = bcrypt.hashSync(data.password, salt);
  267. let merchant = new Merchant({
  268. name: data.name,
  269. email: data.email,
  270. password: hash,
  271. pos: "none"
  272. });
  273. for(let item of data.inventory){
  274. merchant.inventory.push({
  275. ingredient: item.ingredient.id,
  276. quantity: item.quantity
  277. });
  278. }
  279. for(let recipe of data.recipes){
  280. recipe.merchant = merchant._id;
  281. }
  282. Recipe.create(data.recipes)
  283. .then((recipes)=>{
  284. for(let recipe of recipes){
  285. merchant.recipes.push(recipe._id);
  286. }
  287. merchant.save()
  288. .then((merchant)=>{
  289. req.session.user = merchant._id;
  290. return res.redirect("/inventory");
  291. })
  292. .catch((err)=>{
  293. console.log(err);
  294. return res.render("error");
  295. });
  296. })
  297. .catch((err)=>{
  298. console.log(err);
  299. return res.render("error");
  300. });
  301. },
  302. addMerchantIngredient: function(req, res){
  303. if(!req.session.user){
  304. return res.render("error");
  305. }
  306. Merchant.findOne({_id: req.session.user})
  307. .then((merchant)=>{
  308. merchant.inventory.push(req.body);
  309. merchant.save()
  310. .then((newMerchant)=>{
  311. Ingredient.findOne({_id: req.body.ingredient})
  312. .then((ingredient)=>{
  313. return res.json(ingredient);
  314. })
  315. .catch((err)=>{
  316. console.log(err);
  317. return res.render("error");
  318. });
  319. })
  320. .catch((err)=>{
  321. console.log(err);
  322. return res.render("error");
  323. });
  324. })
  325. .catch((err)=>{
  326. console.log(err);
  327. return res.render("error");
  328. });
  329. },
  330. removeMerchantIngredient: function(req, res){
  331. if(!req.session.user){
  332. return res.render("error");
  333. }
  334. Merchant.findOne({_id: req.session.user})
  335. .then((merchant)=>{
  336. for(let i = 0; i < merchant.inventory.length; i++){
  337. if(req.body.ingredientId === merchant.inventory[i]._id.toString()){
  338. merchant.inventory.splice(i, 1);
  339. break;
  340. }
  341. }
  342. merchant.save()
  343. .then(()=>{
  344. return res.json();
  345. })
  346. .catch((err)=>{
  347. console.log(err);
  348. return res.render("error");
  349. });
  350. })
  351. .catch((err)=>{
  352. console.log(err);
  353. return res.render("error");
  354. });
  355. },
  356. updateMerchantIngredient: function(req, res){
  357. if(!req.session.user){
  358. return res.render("error");
  359. }
  360. Merchant.findOne({_id: req.session.user})
  361. .then((merchant)=>{
  362. let updateIngredient = merchant.inventory.find(i => i._id.toString() === req.body.ingredientId);
  363. updateIngredient.quantity += req.body.quantityChange;
  364. merchant.save()
  365. .then((merchant)=>{
  366. res.json();
  367. })
  368. .catch((err)=>{
  369. console.log(err);
  370. return res.render("error");
  371. })
  372. })
  373. .catch((err)=>{
  374. console.log(err);
  375. return res.render("error");
  376. });
  377. let invAdj = new InventoryAdjustment({
  378. date: Date.now(),
  379. merchant: req.session.user,
  380. ingredient: req.body.ingredientId,
  381. quantity: req.body.quantityChange
  382. });
  383. invAdj.save()
  384. .then((newAdjustment)=>{
  385. return;
  386. })
  387. .catch((err)=>{
  388. console.log(err);
  389. return res.render("error");
  390. })
  391. },
  392. addRecipeIngredient: function(req, res){
  393. if(!req.session.user){
  394. return res.render("error");
  395. }
  396. Recipe.findOne({_id: req.body.recipeId})
  397. .then((recipe)=>{
  398. recipe.ingredients.push({
  399. ingredient: req.body.item.ingredient,
  400. quantity: req.body.item.quantity
  401. });
  402. recipe.save()
  403. .then((recipe)=>{
  404. return res.json();
  405. })
  406. .catch((err)=>{
  407. console.log(err);
  408. return res.render("error");
  409. });
  410. })
  411. .catch((err)=>{
  412. console.log(err);
  413. return res.render("error");
  414. });
  415. },
  416. updateRecipeIngredient: function(req, res){
  417. if(!req.session.user){
  418. return res.render("error");
  419. }
  420. Recipe.findOne({_id: req.body.recipeId})
  421. .then((recipe)=>{
  422. for(let ingredient of recipe.ingredients){
  423. if(ingredient._id.toString() === req.body.ingredient._id){
  424. ingredient.quantity = req.body.ingredient.quantity;
  425. recipe.save()
  426. .then((recipe)=>{
  427. return res.json();
  428. })
  429. .catch((err)=>{
  430. console.log(err);
  431. return res.render("error");
  432. })
  433. }
  434. }
  435. })
  436. .catch((err)=>{
  437. console.log(err);
  438. return res.render("error");
  439. });
  440. },
  441. removeRecipeIngredient: function(req, res){
  442. if(!req.session.user){
  443. return res.render("error");
  444. }
  445. Recipe.findOne({_id: req.body.recipeId})
  446. .then((recipe)=>{
  447. for(let i = 0; i < recipe.ingredients.length; i++){
  448. if(recipe.ingredients[i]._id.toString() === req.body.ingredientId){
  449. recipe.ingredients.splice(i, 1);
  450. }
  451. }
  452. recipe.save()
  453. .then((recipe)=>{
  454. return res.json();
  455. })
  456. .catch((err)=>{
  457. console.log(err);
  458. return res.render("error");
  459. });
  460. })
  461. .catch((err)=>{
  462. console.log(err);
  463. return res.render("error");
  464. });
  465. },
  466. getIngredients: function(req, res){
  467. Ingredient.find()
  468. .then((ingredients)=>{
  469. return res.json(ingredients);
  470. })
  471. .catch((err)=>{
  472. console.log(err);
  473. return res.render("error");
  474. });
  475. },
  476. createNewIngredients: function(req, res){
  477. Ingredient.create(req.body)
  478. .then((ingredients)=>{
  479. return res.json(ingredients);
  480. })
  481. .catch((err)=>{
  482. console.log(err);
  483. return res.render("error");
  484. });
  485. },
  486. createIngredient: function(req, res){
  487. Ingredient.create(req.body.ingredient)
  488. .then((ingredient)=>{
  489. Merchant.findOne({_id: req.session.user})
  490. .then((merchant)=>{
  491. let item = {
  492. ingredient: ingredient,
  493. quantity: req.body.quantity
  494. }
  495. merchant.inventory.push(item);
  496. merchant.save()
  497. .then((merchant)=>{
  498. console.log("something");
  499. return res.json(item);
  500. })
  501. .catch((err)=>{
  502. console.log(err);
  503. return res.render("error");
  504. });
  505. })
  506. .catch((err)=>{
  507. console.log(err);
  508. return res.render("error");
  509. });
  510. })
  511. .catch((err)=>{
  512. console.log(err);
  513. return res.render("error");
  514. });
  515. },
  516. createTransaction: function(req, res){
  517. let transaction = new nonPosTransaction({
  518. date: Date.now(),
  519. author: "None",
  520. merchant: req.session.user,
  521. recipes: req.body
  522. });
  523. //Calculate all ingredients used, store to list
  524. Merchant.findOne({_id: req.session.user})
  525. .populate("recipes")
  526. .then((merchant)=>{
  527. for(let reqRecipe of req.body){
  528. let merchRecipe = merchant.recipes.find(r => r._id.toString() === reqRecipe.id);
  529. for(let recipeIngredient of merchRecipe.ingredients){
  530. let merchInvIngredient = merchant.inventory.find(i => i.ingredient.toString() === recipeIngredient.ingredient.toString());
  531. merchInvIngredient.quantity -= recipeIngredient.quantity * reqRecipe.quantity;
  532. }
  533. }
  534. merchant.save()
  535. .then((merchant)=>{
  536. res.json(merchant.inventory);
  537. })
  538. .catch((err)=>{
  539. console.log(err);
  540. return res.render("error");
  541. });
  542. })
  543. .catch((err)=>{
  544. console.log(err);
  545. return res.render("error");
  546. });
  547. transaction.save()
  548. .then((transaction)=>{
  549. return;
  550. })
  551. .catch((err)=>{
  552. console.log(err);
  553. return res.render("error");
  554. });
  555. },
  556. getCloverRecipes: function(req, res){
  557. if(!req.session.user){
  558. return res.render("error");
  559. }
  560. Merchant.findOne({_id: req.session.user})
  561. .then((merchant)=>{
  562. axios.get(`https://apisandbox.dev.clover.com/v3/merchants/${merchant.posId}/items?access_token=${token}`)
  563. .then((recipes)=>{
  564. return res.json(recipes);
  565. })
  566. .catch((err)=>{
  567. return res.json(err);
  568. });
  569. })
  570. .catch((err)=>{
  571. console.log(err);
  572. return res.render("error");
  573. });
  574. },
  575. unregistered: function(req, res){
  576. return res.redirect("/");
  577. },
  578. login: function(req, res){
  579. Merchant.findOne({email: req.body.email})
  580. .then((merchant)=>{
  581. bcrypt.compare(req.body.password, merchant.password, (err, result)=>{
  582. if(result){
  583. req.session.user = merchant._id;
  584. return res.redirect("/inventory");
  585. }
  586. console.log(err);
  587. return res.redirect("/");
  588. });
  589. })
  590. .catch((err)=>{
  591. console.log(err);
  592. return res.redirect("/");
  593. });
  594. }
  595. }