Donghee

This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong.
====== 할일 ======
 
  * 메일 쓰기. 금요일 미팅 잡기. 코치타운 서비스 가입
  * 웹페이지 만들기
  * google form 제너레이터 http://sneakysheep.com/google-docs-form-tool-version-2/


function whatIsStyleOf(result)
{
  var resultStyle = '';
  
  var sheet = SpreadsheetApp.openById('10osWgJbb9RjXX2HrsseEwam7AskXF3ugtqPjwnK4p1E').getSheetByName('문항');
  var stylesOfItems = sheet.getRange(1,1, sheet.getLastRow() -1, 2).getValues();
  for (var i = 0; i < stylesOfItems.length ; i++) 
  {
   // Logger.log(stylesOfItems[i][0]);
    if (result === stylesOfItems[i][0]) {
      resultStyle = stylesOfItems[i][1]
    }
  }
  
  return resultStyle;
}

 
function createIncoachingStyleProfileForms() {
  var form = FormApp.getActiveForm();
  form.setTitle('Incoaching Style Profile');
  
  var sheet = SpreadsheetApp.openById('10osWgJbb9RjXX2HrsseEwam7AskXF3ugtqPjwnK4p1E').getSheetByName('문항');
  var stylesOfItems = sheet.getRange(1,1, sheet.getLastRow()  , 2).getValues();
  for (var i = 0; i < stylesOfItems.length ; i=i+2) 
  {
    var item = form.addMultipleChoiceItem();
    item.setTitle('나는');
    item.setRequired(true);
    item.setChoiceValues([stylesOfItems[i][0],stylesOfItems[i+1][0]]);
  }
}

function calculateStyleProfile(lastColumn,a,b,e,f) {
  var sheet = SpreadsheetApp.openById('10osWgJbb9RjXX2HrsseEwam7AskXF3ugtqPjwnK4p1E').getActiveSheet();
  var lastRow = sheet.getLastRow();
  // A
  sheet.getRange(lastRow,lastColumn).setValue(a);
  // B
  sheet.getRange(lastRow,lastColumn+1).setValue(b);
  // E
  sheet.getRange(lastRow,lastColumn+2).setValue(e);
  // F
  sheet.getRange(lastRow,lastColumn+3).setValue(f);
  
  
  // 주도형 D
  var d = a*(e/2);
  // 사교형 I
  var i = a*(f/2);
  // 안정형 S
  var s = b*(f/2);
  // 신중형 C
  var c = b*(e/2);

  var arr = [d,i,s,c];
  var i = arr.indexOf(Math.max.apply(Math, arr));
  
  Logger.log(arr);
  var style = '';
  if (i==0) {
    style = 'D'
  } else if (i ==1) {
    style = 'I';
  } else if (i ==2) {
    style = 'S';
  } else if (i ==3) {
    style = 'C';
  }  
  sheet.getRange(lastRow,lastColumn+4).setValue(style);
  return style;
}
function onOpen() {
  FormApp.getUi() // Or DocumentApp or FormApp.
      .createMenu('Custom Menu')
      .addItem('Show sidebar', 'showSidebar')
      .addToUi();
}

function showSidebar() {
 
 // Display a sidebar with custom UiApp content.
 var uiInstance = UiApp.createApplication()
     .setTitle('Live Result');
 var responses = FormApp.getActiveForm().getResponses();
 uiInstance.add(uiInstance.createLabel(responses.length));      
 FormApp.getUi().showSidebar(uiInstance);
   
}

function onOpen() {
  var fa = FormApp.getActive();
  ScriptApp.newTrigger('onFormSubmit')
      .forSpreadsheet(fa)
      .onFormSubmit()
      .create();
}

function onFormSubmit(event) {
    var logDocument = DocumentApp.openById('17mpPXOsuMD70vpwJwN02Y8hziHB3tHb_l1rN8tAXwaQ');
    var a = 0;
    var b = 0;
    var e = 0;
    var f = 0;
    try {
        var response = event.response;
        //logDocument.getBody().appendParagraph(Utilities.formatString("%s", event.response.getItemResponses().toString()));
        var itemResponses = event.response.getItemResponses();
        for (var j = 1; j < itemResponses.length; j++) {
          var itemResponse = itemResponses[j];
          //logDocument.getBody().appendParagraph(Utilities.formatString('question "%s" was "%s"', itemResponse.getItem().getTitle(),
          //           itemResponse.getResponse()));
          if ('A' === whatIsStyleOf(itemResponse.getResponse())){
            a = a+1;
          }
          if ('B' === whatIsStyleOf(itemResponse.getResponse())){
            b = b+1;
          }
          if ('E' === whatIsStyleOf(itemResponse.getResponse())){
            e = e+1;
          }
          if ('F' === whatIsStyleOf(itemResponse.getResponse())){
            f = f+1;
          }
        }
       var style = calculateStyleProfile(itemResponses.length+3,a,b,e,f);
       var message = Utilities.formatString('A:%s B:%s E:%s F:%s Style:%s', a.toString(), b.toString(), e.toString(), f.toString(), style);
      
       var styleReportImageUrl = Utilities.formatString('http://www.dh8.kr/tmp/ISP_Style_%s.png', style);
       var styleReportImageBlob = UrlFetchApp
                          .fetch(styleReportImageUrl)
                          .getBlob()
                          .setName("styleReportImageBlob");
       //showSidebar();
      
       logDocument.getBody().appendParagraph(message);
       email = itemResponses[0].getResponse();
       //MailApp.sendEmail(email, "ISP", message);
      
       MailApp.sendEmail({
         to: email,
         subject: "ISP 설문 결과",
         htmlBody: "<img src='cid:styleReportImageBlob'><br>" + message,
         inlineImages:
         {
           styleReportImageBlob: styleReportImageBlob,
         }
       });
      
      
    
    } catch(e) {
        errorMessage = (e.name + ' on line: ' + e.lineNumber + ' -> ' + e.message);
        logDocument.getBody().appendParagraph(errorMessage);
    }
}