Advertisement
kuroshan1104

final gas

Oct 28th, 2022
178
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 3.12 KB | None | 0 0
  1. var conjunto = 1;
  2. var limite = 400;
  3.  
  4. // no tocar
  5. var contador = 0 + (limite*(conjunto-1));
  6. var skip = limite*(conjunto-1);
  7. var skip_c = 0;
  8.  
  9. function listFilesAndFolders(){
  10. var folderId = Browser.inputBox('Enter folder ID', Browser.Buttons.OK_CANCEL);
  11. if (folderId === "") {
  12. Browser.msgBox('Folder ID is invalid');
  13. return;
  14. }
  15. getFolderTree(folderId, true);
  16. };
  17.  
  18.  
  19.  
  20. function getFolderTree(folderId, listAll) {
  21. try {
  22. var parentFolder = DriveApp.getFolderById(folderId);
  23. var file, data, sheet = SpreadsheetApp.getActiveSheet();
  24. if(conjunto == 1) {
  25. sheet.clear();
  26. sheet.appendRow(["Name", "URL"]);
  27. }
  28. getChildFolders(parentFolder.getName(), parentFolder, data, sheet, listAll);
  29. } catch (e) {
  30. Logger.log(e.toString());
  31. }
  32. };
  33.  
  34. function getChildFolders(parentName, parent, data, sheet, listAll) {
  35. var childFolders = parent.getFolders();
  36. while (childFolders.hasNext()) {
  37. var childFolder = childFolders.next();
  38. var files = childFolder.getFiles();
  39. while (listAll & files.hasNext()) {
  40. var childFile = files.next();
  41. if(skip_c <= skip) {
  42. skip_c+=1;
  43. } else {
  44. contador+=1;
  45. if(contador<=conjunto*limite) {
  46. data = [
  47. childFile.getName().replace(".pdf",""),
  48. childFile.getUrl(),
  49. ]; var conjunto = 1;
  50. var limite = 400;
  51.  
  52. // no tocar
  53. var contador = 0 + (limite*(conjunto-1));
  54. var skip = limite*(conjunto-1);
  55. var skip_c = 0;
  56.  
  57. function listFilesAndFolders(){
  58. var folderId = Browser.inputBox('Enter folder ID', Browser.Buttons.OK_CANCEL);
  59. if (folderId === "") {
  60. Browser.msgBox('Folder ID is invalid');
  61. return;
  62. }
  63. getFolderTree(folderId, true);
  64. };
  65.  
  66.  
  67.  
  68. function getFolderTree(folderId, listAll) {
  69. try {
  70. var parentFolder = DriveApp.getFolderById(folderId);
  71. var file, data, sheet = SpreadsheetApp.getActiveSheet();
  72. if(conjunto == 1) {
  73. sheet.clear();
  74. sheet.appendRow(["Name", "URL"]);
  75. }
  76. getChildFolders(parentFolder.getName(), parentFolder, data, sheet, listAll);
  77. } catch (e) {
  78. Logger.log(e.toString());
  79. }
  80. };
  81.  
  82. function getChildFolders(parentName, parent, data, sheet, listAll) {
  83. var childFolders = parent.getFolders();
  84. while (childFolders.hasNext()) {
  85. var childFolder = childFolders.next();
  86. var files = childFolder.getFiles();
  87. while (listAll & files.hasNext()) {
  88. var childFile = files.next();
  89. if(skip_c <= skip) {
  90. skip_c+=1;
  91. } else {
  92. contador+=1;
  93. if(contador<=conjunto*limite) {
  94. data = [
  95. childFile.getName().replace(".pdf",""),
  96. childFile.getUrl(),
  97. ];
  98. sheet.appendRow(data);
  99. } else {
  100. return;
  101. }
  102. }
  103.  
  104. }
  105. getChildFolders(parentName + "/" + childFolder.getName(), childFolder, data, sheet, listAll);
  106. }
  107. };
  108. sheet.appendRow(data);
  109. } else {
  110. return;
  111. }
  112. }
  113.  
  114. }
  115. getChildFolders(parentName + "/" + childFolder.getName(), childFolder, data, sheet, listAll);
  116. }
  117. };
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement