【GAS、Google Spreadsheet】ブログに使用した画像をGoogleドライブで管理するために書いたスクリプト

1
function moveFileToFolder(postedList) {
2
  // declare for prepare.
3
  var alreadyPostedList = [], alreadyPostedChr = '済';
4

5
  // get list of aticle already posted.
6
  postedList.forEach(function(value) {
7
    if(value[1] == alreadyPostedChr) {
8
      alreadyPostedList.push(value[0]);
9
    }
10
  });
11

12
  // declare for get list of folders.
13
  var folder_id = 'XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX', // Folder ID of image for article.
14
    folder,
15
    folders,
16
    folder_now,
17
    key_date_folder,
18
    folderDict = {},
19
    prefix_folder = "◆完了分_", // prefix of folder of image for article already posted.
20
    date_format_8   = "yyyyMMdd",
21
    date_format_6   = "yyyyMM";
22

23
  // get list of folders.
24
  folder = DriveApp.getFolderById(folder_id);
25
  folders = folder.getFolders();
26
  while(folders.hasNext()) {
27
    folder_now = folders.next();
28
    if (prefix_folder == folder_now.getName().substring(0, prefix_folder.length)) {
29
      key_date_folder = folder_now.getName().substring(prefix_folder.length, prefix_folder.length + date_format_6.length);
30
      folderDict[key_date_folder] = folder_now.getId();
31
    }
32
  }
33

34
  // declare for get list of image files.
35
  var files,
36
    file,
37
    key_date_file_6,
38
    key_date_file_8,
39
    fileList = [];
40

41
  // get list of image files.
42
  files = folder.getFiles();
43
  while(files.hasNext()) {
44
    file = files.next();
45
    key_date_file_6 = file.getName().substring(0, date_format_6.length);
46
    key_date_file_8 = file.getName().substring(0, date_format_8.length);
47

48
    if (alreadyPostedList.find(key => key === key_date_file_8) != null) {
49
      fileList.push([key_date_file_8, key_date_file_6, file.getId()]);
50
    }
51
  }
52
  console.log(fileList);
53

54
  // declare for move file to folder
55
  var targetFile, toFolder;
56

57
  // move file to folder
58
  fileList.forEach(function(movingList) {
59
    if (movingList[1] != "") {
60
      targetFile = DriveApp.getFileById(movingList[2]);
61
      toFolder   = DriveApp.getFolderById(folderDict[movingList[1]]);
62
      targetFile.moveTo(toFolder);
63
    }
64
  });
65

66
}
67

68
function readGssColumns() {
69
  // declare for prepare.
70
  var ss,
71
    sheetName = 'ブログ_記事',
72
    sheet,
73
    postedNumber,
74
    row_for_postedNumber = 6,
75
    column_for_postedNumber = 13;
76
  ss = SpreadsheetApp.getActive();
77
  sheet = ss.getSheetByName(sheetName);
78
  postedNumber = Number(sheet.getRange(row_for_postedNumber, column_for_postedNumber).getValue());
79

80
  // declare for get list from GSS.
81
  var dateList   = [],
82
    dateList_formated = [],
83
    postedList = [],
84
    i = 2, // index of row to start reading sheet.
85
    column_for_date   = 3, // index of 「起票日」column.
86
    column_for_posted = 6, // index og 「投稿済」column.
87
    returnList = [];
88

89
  // get dateList and cleansing.
90
  dateList   = sheet.getRange(i, column_for_date, postedNumber, 1).getValues();
91
  for (let j = 0; j < postedNumber; j++) {
92
    dateList_formated.push(Utilities.formatDate(dateList[j][0], 'JST', 'yyyyMMdd'));
93
  }
94

95
  // get postedList.
96
  postedList = sheet.getRange(i, column_for_posted, postedNumber, 1).getValues();
97

98
  // create returnList
99
  for (let k = 0; k < postedNumber; k++) {
100
    returnList.push([dateList_formated[k], postedList[k][0]]);
101
  }
102

103
  return returnList;
104
}
105

106
function manageFilesGoogleDrive() {
107
  // declare for execute.
108
  var postedList;
109
  postedList = readGssColumns();
110
  moveFileToFolder(postedList);
111
}