Advertisement
Namokonov

SHARAPOV

Nov 9th, 2020
295
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. function SHARAPOV(){  
  2.   const ss = SpreadsheetApp.getActive();
  3.   const sh = ss.getActiveSheet();
  4.   const r = sh.getRange("a1:c").getValues();
  5.  
  6.   r.forEach((y, i) => {
  7.     const range = sh.getRange(++i, 3, 1, 2);
  8.     i > 0 && !y[2] && y[0] && y[1] ? search(query(getIdFromUrl(y[0]), y[1].toString().split(' ')[0])).length ?
  9.       range.setValues([[true, 'есть']]) :
  10.       range.setValues([[true, 'нет']]) : ''})
  11. }
  12.  
  13. function query(folder_id, name){
  14.   return `'${folder_id}' in parents and title contains '${name}'`;  
  15. }
  16.  
  17. function getIdFromUrl(url){ return url.match(/[-\w]{25,}/)}
  18.  
  19. function search(request, pageToken){
  20.   var optionalArgs = {
  21.     q: request,
  22.     maxResults: 1000,
  23.     orderBy: 'modifiedDate desc',
  24.     fields:
  25.       'items(id, title, parents(id), alternateLink, permissions, hasAugmentedPermissions), nextPageToken'
  26.   };
  27.   //(type, id)
  28.   if (pageToken) {
  29.     optionalArgs.pageToken = pageToken;
  30.   }
  31.   var list = Drive.Files.list(optionalArgs);
  32.   var files = list.items;
  33.   if (list.nextPageToken) {
  34.     return files.concat(search("", list.nextPageToken));
  35.   }
  36.   return files;
  37. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement