1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41
|
function doGet() {
var app = UiApp.createApplication();
var mygrid = app.createGrid(3, 2);
mygrid.setWidget(0, 0, app.createLabel('Date de début:'));
mygrid.setWidget(0, 1, app.createDateBox().setId('dateA'));
mygrid.setWidget(1, 0, app.createLabel('Date de fin:'));
mygrid.setWidget(1, 1, app.createDateBox().setId('dateB'));
var mybutton = app.createButton('OK');
mybutton.setId("mybutton");
var mypanel = app.createVerticalPanel();
mypanel.setId('mypanel');
mypanel.add(mygrid);
mypanel.add(mybutton);
app.add(mypanel);
var handler = app.createServerHandler('summaryOnDemand');
handler.addCallbackElement(mypanel);
mybutton.addClickHandler(handler);
return app;
}
function summaryOnDemand(e) {
var app = UiApp.getActiveApplication();
var dateA = e.parameter.dateA;
var dateB = e.parameter.dateB;
var panel = app.getElementById('mypanel');
panel.setVisible(false);
// var mydoc = SpreadsheetApp.openById("0AiK_IybPWcGcdEV5V2JQUHhtUHp1dEhEN3NuQjdrVWc");
var file = summary(dateA,dateB,true);
var folder = DocsList.getFolderById("0ByK_IybPWcGcX1lUTlRET0dQVXc");
file.addToFolder(folder);
MailApp.sendEmail(Session.getActiveUser().getEmail(),"Rapport réclamation à la demande","Le document ce trouve dans google drive à présent, pour y accéder directement : " + file.getUrl())
app.close();
return app;
} |
Partager