Iterate over loop

Iterate over loop

Hi,

I have the following script setup to create PDF voucher based on the input.Number_Of_E_Vouchers , e.g. if the value is 4, 4 vouchers will be generated, but seem the loop stopped after generating 1 voucher, is there any coding issue with the below script?

Thanks a lot for your suggestion.


  2. //get max voucher
  3. maxVoucher = input.Number_Of_E_Vouchers;
  4. //initialise lists
  5. vList = {0};
  6. vnList = Collection();
  7. //initialise string
  8. vString = "";
  9. //get dates
  10. issueDate = input.Added_Time.tostring("dd-MMM-yyyy");
  11. expiryDate = input.Added_Time.addMonth(3).tostring("dd-MMM-yyyy");
  12. //fetch ac record
  13. acRecord = Add_Customers[ID = input.Add_Customers_Lookup];
  14. custID = acRecord.Customer_ID.tostring();
  15. //iterate over v list
  16. for each index vl in vList
  17. {
  18. //fetch ts record
  19. tsRecord = Templates[Type = "Customers" && For_field = "Actual Voucher Template" && Status == "Active"];
  20. //check if
  21. if(vl < maxVoucher)
  22. {
  23. //creates voucher number
  24. vn = input.ID + "-" + vl;
  25. vqrc = "<img src='https://chart.googleapis.com/chart?chl=" + vn + "&chs=100x100&cht=qr&chld=H|0'/>";
  26. //add vn to list
  27. vnList.insert(vn);
  28. //creates vt string
  29. vtString = tsRecord.Message;
  30. //replace merge fields
  31. vtString = vtString.replaceAll("${Name}",input.Add_Customers_Lookup.Name,true);
  32. vtString = vtString.replaceAll("${Customer_ID}",custID,true);
  33. vtString = vtString.replaceAll("${voucherType}","Entitles the bearer to 1 Lesson",true);
  34. vtString = vtString.replaceAll("${expiryDate}",expiryDate,true);
  35. vtString = vtString.replaceAll("${issueDate}",issueDate,true);
  36. vtString = vtString.replaceAll("${voucherQRcode}",vqrc,true);
  37. vtString = vtString.replaceAll("${voucherNum}",vn,true);
  38. vList.add(vl + 1);
  39. //check if
  40. if(vl = maxVoucher - 1)
  41. {
  42. vString = vString + "<div>" + vtString + "</div>";
  43. }
  44. else
  45. {
  46. vString = vString + "<div>" + vtString + "</div><p style='page-break-after: always !important;'>&nbsp;</p>";
  47. }
  48. }
  49. }
  50. input.voucherNumberList = vnList;
  51. input.voucherDetail = vString;
  52. //fetch te record
  53. teRecord = Templates[Type = "Customers" && For_field = "Voucher Email" && Status == "Active"];
  54. //check if
  55. if(teRecord.count() > 0)
  56. {
  57. //fetch subject
  58. subjectLine = teRecord.Subject_field;
  59. //fetch message
  60. messageBody = teRecord.Message;
  61. //replace merge fields
  62. messageBody = messageBody.replaceAll("${Name}",acRecord.Name,true);
  63. messageBody = messageBody.replaceAll("${Customer_ID}",custID,true);
  64. messageBody = messageBody.replaceAll("${voucherType}","Entitles the bearer to 1 Lessons",true);
  65. messageBody = messageBody.replaceAll("${expiryDate}",expiryDate,true);
  66. vtString = vtString.replaceAll("${issueDate}",issueDate,true);
  67. sendTo = "test@test.com"
  68. //send mail
  69. sendmail
  70. [
  71. from :zoho.adminuserid
  72. to :"test@test.com"
  73. subject :subjectLine
  74. message :messageBody
  75. Attachments :template:E_Voucher_Actual_Template as PDF
  76. ]
  77. }