☰

bcc-to-gdocs

Jquery commands to get data from forms, ala datatel

当前为 2014-09-02 提交的版本，查看 最新版本。

  1. // ==UserScript==
  2. // @name           bcc-to-gdocs
  3. // @description    Jquery commands to get data from forms, ala datatel
  4. // @include        https://go.bergen.edu/WebAdvisor/WebAdvisor?TOKENIDX*&APP=ST&CONSTITUENCY=WBFC
  5. // @require        https://ajax.googleapis.com/ajax/libs/jquery/1.3.1/jquery.min.js
  6. // @namespace      https://greasyfork.org/scripts/4752-bcc-to-gdocs
  7. // @version 0.0.1.20140902214734
  8. // ==/UserScript==
  9.  
  10. /* On WebAdvisor class rosters add buttons for BCC faculty to display student names
  11. ** in easily cut-and-pasted to spreadsheet form, and automatically create the spreadsheet
  12. ** in Google Docs. I am using the ClientLogin functions from http://userscripts.org/scripts/show/27673
  13. ** which was written by Michael Freeman and AJAX functions from
  14. ** http://gdatatips.blogspot.com/2009/07/create-new-google-docs-spreadsheet-from.html
  15. ** by Eric from Google.
  16. ** and loads of JQuery
  17. */
  18.  
  19. /*
  20. ** Professor of Art and Animation
  21. ** Francis Scrubjay Schmidt 2009, updated 2011, updated 2014
  22. ** Bergen Community College
  23. */
  24.  
  25. var gdocsbuttonfront = '<input name="GDOCS" class="gdocsbutton" value=" To GoogleDocs " id=';
  26. var gdocsbuttonback = ' class="Button"> </td>'; //WebAdvisor looking button straight to gdocs
  27. var rollcallbuttonfront = '<input name="GDOCSROLLCALL" class="rollcallbutton" value=" Roll Call " id=';
  28. var rollcallbuttonback = ' class="Button"> </td>'; //WebAdvisor looking button straight to gdocs
  29. var login    = '<p> Gmail Login &nbsp &nbsp &nbsp &nbsp <input id="name" size=24 type="text"> </p>'; //Gmail user name
  30. var password    = '<p> Gmail Password &nbsp <input id="password" size=24 type="password"> </p>'; //Google password
  31. var cellbuttonfront = '<td> <input name="C&P" class="rostbutton" value=" Roster '; // first half names button
  32. var cellbuttonmiddle = '" id="'; // middle of button
  33. var cellbuttonback = '" class="shortButton">'; // back half names button
  34. var cellblank = '<th class=" FranAdded"> <div> <p id="blank"> <input type="hidden" name="blank" value="o"> </p> </div> </th>';
  35. var classname = []; //where the classname will go
  36. var csv = ''; //where the csv version is
  37. var names = "";
  38. var hrefs = [];//the URLS for AJAX student names
  39. var hoursroom = [];//class meeting times and room
  40. var term = [];//term
  41.  
  42. // Gdocs login stuff at top of page
  43. $('<TextNode textContent="Class Roster Select Section">').each(function () {   // Make sure we are on the right page
  44.     $('<p> &nbsp </p>').appendTo("#screenTitle span:contains('Class Roster Select Section')"); // make a line between
  45.     $(login).appendTo("#screenTitle span:contains('Class Roster Select Section')");       // put username
  46.     $(password).appendTo("#screenTitle span:contains('Class Roster Select Section')");       // put password
  47.     
  48.     // Place to attach buttons for each class		
  49.     $("#GROUP_Grp_LIST_VAR2").each(function () {    // find the table with the classnames
  50.         var classcount = 0;
  51.         $(this).find('table').each(function () {    // find the main table
  52.             $(this).find('tr:first').each(function () {   // find the header
  53.                 $(this).prepend(cellblank); // add a spacer to match rows
  54.             }); 
  55.             $(this).find('tr:gt(0):not(:has(th))').each(function () {   // get rows greater than header (0)
  56.                 classcount ++; //increment the class #
  57.                 $(this).prepend(gdocsbuttonfront + classcount + gdocsbuttonback + rollcallbuttonfront + classcount + rollcallbuttonback + cellbuttonfront + classcount + cellbuttonmiddle + classcount + cellbuttonback); // put the button in to grab and print student names
  58.                 hoursroom[classcount] = $(this).find('.LIST_VAR6 > div > p').text();//the hours and room
  59.                 term[classcount] = $(this).find('.LIST_VAR4 > div > p').text();// get the term
  60.                 $(this).find('td:visible').each(function () { //get each cell of the row
  61.                     $(this).find('a').each(function () { // grabs 'a' tags, with URL of student names for course
  62.                         classname[classcount] = $(this).text(); //for the popup window
  63.                         hrefs[classcount] = $(this).attr("href"); // gets the actual URL
  64.                     });
  65.                 });
  66.             }); // end class row reads
  67.         }); // end table read
  68.         
  69.         // What the Roster button does			
  70.         $(".rostbutton").click(function(){ // Action for class roster button to be pushed to make window
  71.             var target = $(this).attr("id"); //get the # of the row, assign to 'target'
  72.             $.get(hrefs[target], function(data){ //AJAX get url data
  73.                 var rosternames = $(data).find('#GROUP_Grp_LIST_VAR7').html();//student name class table data
  74.                 myWindow = window.open('', 'MyNewWindow', 'width=900,height=500,left=100,top=100,scrollbars= 1'); // makes popup
  75.                 myWindow.document.write('<html><head><title>' + classname[target]+'</title></head><body><font  face="geneva, helvetica, arial"><div><table>' + rosternames + '</table></div></font></body></html>'); // page html
  76.                 myWindow.document.close();
  77.                 myWindow.focus();
  78.             });
  79.         });
  80.         
  81.         $(".rollcallbutton").click(function() {  // Action for rollcall button when clicked do this
  82.             // login modified from http://userscripts.org/scripts/show/27673
  83.             // ajax modified from http://gdatatips.blogspot.com/2009/07/create-new-google-docs-spreadsheet-from.html
  84.             var gauthURL = 'https://www.google.com/accounts/ClientLogin';    // using clientlogin method from google api
  85.             var gToken = '';     // where the string that lets us authenticate lives
  86.             var loginInfo = 'accountType=HOSTED_OR_GOOGLE&service=writely&source=bcc-to-gdocs-Francis-Schmidt';    // header stuff for xml
  87.             var target = $(this).attr("id");
  88.             $.get(hrefs[target], function(data){ //AJAX get url data
  89.                 $(data).find('#GROUP_Grp_LIST_VAR7').each(function (){
  90.                     csv = "1,3,," + '\n';
  91.                     csv += "Name,ID Number," + '\n'; //header row for csv
  92.                     $(this).find('tr:gt(1)').each(function () { 
  93.                         csv += '"'+$(this).find('td.LIST_VAR7 > div > a ').text()+'"' + ','; //student name for csv
  94.                         csv += $(this).find('td.LIST_VAR6 > div > p').text() + '\n'; //student # for csv
  95.                     });
  96.                 }); //end student name class table data
  97.             }); //end AJAX response
  98.             
  99.             //These pieces form the xml that is sent to google docs
  100.             var atom = ["<?xml version='1.0' encoding='UTF-8'?>",
  101.                         '<entry xmlns="http://www.w3.org/2005/Atom">',
  102.                         '<category scheme="http://schemas.google.com/g/2005#kind"',
  103.                         ' term="http://schemas.google.com/docs/2007#spreadsheet"/>',
  104.                         '<title>', "$ROLLCALL " + term[target] + " " + classname[target], '</title>',                    //name the spreadsheet after the classname 
  105.                         '</entry>'].join('');
  106.             
  107.             var body = ['--END_OF_PART\r\n',
  108.                         'Content-Type: application/atom+xml;\r\n\r\n',
  109.                         atom, '\r\n',
  110.                         '--END_OF_PART\r\n',
  111.                         'Content-Type: text/csv\r\n\r\n',
  112.                         csv, '\r\n', // the actual data from webadvisor
  113.                         '--END_OF_PART--\r\n'].join('');
  114.             
  115.             //logininfo has the useremail and password added to the xml needed for authentication
  116.             loginInfo = loginInfo + '&Email=' + $("#name").val();
  117.             loginInfo = loginInfo + '&Passwd=' + $("#password").val();
  118.             
  119.             GM_xmlhttpRequest({   // greasemonkey xml
  120.                 method: 'POST',
  121.                 url: gauthURL,
  122.                 headers: {
  123.                     'User-agent': 'Mozilla/4.0 (compatible) Greasemonkey',
  124.                     'Content-type': 'application/x-www-form-urlencoded'
  125.                 },
  126.                 data: loginInfo,    // the authentication
  127.                 onload: function(responseDetails){
  128.                     if(responseDetails.status != 200) {    // failure 
  129.                         alert('Whoa.  Did you log in? \n\n   Error: ' + responseDetails.status + ': ' + responseDetails.statusText);
  130.                     }
  131.                     if (responseDetails.status == 200) {    // 200 means we are successful, so we send up the spreadsheet
  132.                         tokenText = responseDetails.responseText;   // get the text
  133.                         gToken = tokenText.match(/Auth=[a-z0-9_-]+/i);    // turn it into our token
  134.                         GM_xmlhttpRequest({     // let's light this candle
  135.                             method: 'POST',
  136.                             url: 'http://docs.google.com/feeds/documents/private/full',
  137.                             headers: {
  138.                                 'Authorization': 'GoogleLogin ' + gToken,  
  139.                                 'Content-Type': 'multipart/related; boundary=END_OF_PART',
  140.                                 'Slug': term[target] + " " + classname[target] +'.csv'
  141.                             },                // proves we are allowed to, and says what we are going to do
  142.                             
  143.                             contentType: 'multipart/related; boundary=END_OF_PART',
  144.                             data: body,  //the xml we made above, called body
  145.                             dataType: 'xml',
  146.                             onload: function(responseDetails){ 
  147.                                 if (responseDetails.status == 201) {   // success!
  148.                                     alert('Spreadsheet named ' + "$ROLLCALL"+ term[target] + " " + classname[target] + '\n is now in ' + $("#name").val() + ' docs account');
  149.                                 }
  150.                                 if(responseDetails.status != 201) {    // failure  ;(
  151.                                     alert('Whoops! There was a problem \n\n   Error: ' + responseDetails.status + ': ' + responseDetails.statusText);
  152.                                 }
  153.                                 showLoad(false);
  154.                             }
  155.                         });//end putting stuff up on google
  156.                     }
  157.                 }
  158.             });
  159.         }); //end rollcall button
  160.         
  161.         
  162.         $(".gdocsbutton").click(function() {  // Action for gdocs button when clicked do this
  163.             // login modified from http://userscripts.org/scripts/show/27673
  164.             // ajax modified from http://gdatatips.blogspot.com/2009/07/create-new-google-docs-spreadsheet-from.html
  165.             var gauthURL = 'https://www.google.com/accounts/ClientLogin';    // using clientlogin method from google api
  166.             var gToken = '';     // where the string that lets us authenticate lives
  167.             var loginInfo = 'accountType=HOSTED_OR_GOOGLE&service=writely&source=bcc-to-gdocs-Francis-Schmidt';    // header stuff for xml
  168.             var target = $(this).attr("id");
  169.             $.get(hrefs[target], function(data){ //AJAX get url data
  170.                 $(data).find('#GROUP_Grp_LIST_VAR7').each(function (){
  171.                     csv = '"' + hoursroom[target] + '"' + '\n';
  172.                     csv += "Name,ID Number,Email Address,Phone Number" + '\n'; //header row for csv
  173.                     $(this).find('tr:gt(1)').each(function () { 
  174.                         csv += '"'+$(this).find('td.LIST_VAR7 > div > a ').text()+'"' + ','; //student # for csv
  175.                         csv += $(this).find('td.LIST_VAR6 > div > p').text() + ','; //student # for csv
  176.                         csv += $(this).find('td.LIST_VAR8 > div > a ').text() + ','; //student # for csv
  177.                         csv += $(this).find('td.VAR_LIST1 > div > p').text() + '\n'; //student # for csv
  178.                     });
  179.                 }); //end student name class table data
  180.             }); //end AJAX response
  181.             
  182.             //These pieces form the xml that is sent to google docs
  183.             var atom = ["<?xml version='1.0' encoding='UTF-8'?>",
  184.                         '<entry xmlns="http://www.w3.org/2005/Atom">',
  185.                         '<category scheme="http://schemas.google.com/g/2005#kind"',
  186.                         ' term="http://schemas.google.com/docs/2007#spreadsheet"/>',
  187.                         '<title>', term[target] + " " + classname[target], '</title>',                    //name the spreadsheet after the classname 
  188.                         '</entry>'].join('');
  189.             
  190.             var body = ['--END_OF_PART\r\n',
  191.                         'Content-Type: application/atom+xml;\r\n\r\n',
  192.                         atom, '\r\n',
  193.                         '--END_OF_PART\r\n',
  194.                         'Content-Type: text/csv\r\n\r\n',
  195.                         csv, '\r\n', // the actual data from webadvisor
  196.                         '--END_OF_PART--\r\n'].join('');
  197.             
  198.             //logininfo has the useremail and password added to the xml needed for authentication
  199.             loginInfo = loginInfo + '&Email=' + $("#name").val();
  200.             loginInfo = loginInfo + '&Passwd=' + $("#password").val();
  201.             
  202.             GM_xmlhttpRequest({   // greasemonkey xml
  203.                 method: 'POST',
  204.                 url: gauthURL,
  205.                 headers: {
  206.                     'User-agent': 'Mozilla/4.0 (compatible) Greasemonkey',
  207.                     'Content-type': 'application/x-www-form-urlencoded'
  208.                 },
  209.                 data: loginInfo,    // the authentication
  210.                 onload: function(responseDetails){
  211.                     if(responseDetails.status != 200) {    // failure 
  212.                         alert('Whoa.  Did you log in? \n\n   Error: ' + responseDetails.status + ': ' + responseDetails.statusText);
  213.                     }
  214.                     if (responseDetails.status == 200) {    // 200 means we are successful, so we send up the spreadsheet
  215.                         tokenText = responseDetails.responseText;   // get the text
  216.                         gToken = tokenText.match(/Auth=[a-z0-9_-]+/i);    // turn it into our token
  217.                         GM_xmlhttpRequest({     // let's light this candle
  218.                             method: 'POST',
  219.                             url: 'http://docs.google.com/feeds/documents/private/full',
  220.                             headers: {
  221.                                 'Authorization': 'GoogleLogin ' + gToken,  
  222.                                 'Content-Type': 'multipart/related; boundary=END_OF_PART',
  223.                                 'Slug': term[target] + " " + classname[target] +'.csv'
  224.                             },                // proves we are allowed to, and says what we are going to do
  225.                             
  226.                             contentType: 'multipart/related; boundary=END_OF_PART',
  227.                             data: body,  //the xml we made above, called body
  228.                             dataType: 'xml',
  229.                             onload: function(responseDetails){ 
  230.                                 if (responseDetails.status == 201) {   // success!
  231.                                     alert('Spreadsheet named ' + term[target] + " " + classname[target] + '\n is now in ' + $("#name").val() + ' docs account');
  232.                                 }
  233.                                 if(responseDetails.status != 201) {    // failure  ;(
  234.                                     alert('Whoops! There was a problem \n\n   Error: ' + responseDetails.status + ': ' + responseDetails.statusText);
  235.                                 }
  236.                                 showLoad(false);
  237.                             }
  238.                         });//end putting stuff up on google
  239.                     }
  240.                 }
  241.             });
  242.         }); //end google docs button
  243.     }); // end main table read
  244. });