System Administration

Choose an External Link to Modify

//Main Global variable definition var scrolltable = "competitor"; var blankalpha = ""; var zeronum = 0; var prevlabel = "Page Up"; var nextlabel = "Page Dn"; var result = 0; var top = "Top of List"; // end globals //reset linkpage num after pressing page up, page down or top if (request.prevbutt == prevlabel) {client.linkpagenum = request.prevpagenum} else {if(request.nextbutt==nextlabel) {client.linkpagenum = request.nextpagenum} else{if(request.prevbutt ==top) {client.linkpagenum = 1;} } } function CursorMaster_SA02() // creates the key entry for the scrollkey table by using the TopPage object. { temppage3 = new TopPage(client.userid, scrolltable, client.linkpagenum, blankalpha, blankalpha, zeronum, zeronum); temppage3.sel_scroll(); // The complexity in the sql is due to the paging logic, which is driven by the data prestent on the scrollkey table. This causes only rows greater that the entry on scrollkey to be selected. This sql ensures that values shown on the previous page will not be shown again, and that no data will be missed. CompetitorLink = database.cursor('SELECT competitorid, competitorname, url, description FROM competitor WHERE ((competitorname = "' + temppage3.alphakey1 + '") AND (competitorid >= "' + temppage3.numkey1+ '")) OR (competitorname > "' + temppage3.alphakey1 + '") ORDER BY competitorname, competitorid'); } function CursorUser_SA02() // creates the key entry for the scrollkey table by using the TopPage object. { temppage4 = new TopPage(client.userid, scrolltable, client.linkpagenum, blankalpha, blankalpha, zeronum, zeronum); temppage4.sel_scroll(); CompetitorLink = database.cursor('SELECT competitorid, competitorname, url, description FROM competitor WHERE ownerid = "' + temppage4.userid + '" AND ((competitorname = "' + temppage4.alphakey1 + '" AND competitorid >= "' + temppage4.numkey1 + '") OR (competitorname > "' + temppage4.alphakey1 + '")) ORDER BY competitorname, competitorid'); } function BuildTableHeader_SA02() { //this funtion builds the table header. It is only called if there is data to display write("
"); write(""); write(""); write(""); write(""); write(""); write(""); write(""); } function BuildTableData_SA02() { var keepfetching = "true"; //this variable is used to control cursor fetching. var printhead = "false"; //this variable is used to control printing the table header only when at // least one row from the cursor was found. var indx=1; //this variable is used to determine if another page of data exists while(keepfetching =="true") {if(CompetitorLink.next()) {if(printhead=="false") {BuildTableHeader_SA02(); //only build table header if data exists printhead = "true"; } if(indx<11) // only print ten rows, the eleventh is stored in scrollkey { write(""); write(""); write(""); write(""); write(""); indx++; } else {keepfetching = "false";} } else {keepfetching = "false"; indx = 10;}//needed to prevent page down from printing if 10th row is last one }; // end WHILE loop if((printhead=="false")&&(client.linkpagenum==1)) //prints message stating no date was found {Print_No_Found();} if(indx == 11) //more data exists for at least one more row on one more page { var nextpage = 0; nextpage = parseInt(client.linkpagenum) + 1; // the following fields are needed because database fields cannot be accessed once the // cursor is closed. var compid = parseInt(CompetitorLink.competitorid); var compname = ""+CompetitorLink.competitorname+""; CompetitorLink.close(); temppage1 = new TopPage(client.userid, scrolltable, nextpage, compname, blankalpha, compid, zeronum); newpageresult = temppage1.ins_scroll(); // data for next page inserted on scrollkey table if(newpageresult !=0) {temppage1.upd_scroll();}; } else {CompetitorLink.close();}; write("
You Have Authority to Modify the Following Entries, Page " + client.linkpagenum + "
ModDelCompanyURLDescription
" + CompetitorLink.competitorname + ""+CompetitorLink.url+"" + CompetitorLink.description + "

"); return indx; } function DeterminePaging_SA02() { //determines which buttons need to be created for the bottom of the page write("

"); write(""); if(client.linkpagenum > 2) {CreateTopButton_SA02()} if (client.linkpagenum != 1) {CreatePrevButton_SA02()} if(indx == 11) {CreateNextButton_SA02()} } function CreateTopButton_SA02() { // creates Top button if user is beyond page two. This button sends the user to the top of the list write(""); } function CreatePrevButton_SA02() { // creates Page Up button if user is beyone page one var prevpage = parseInt(client.linkpagenum) - 1; write(""); } function CreateNextButton_SA02() { // creates Page Down button if data exists for another page. var newpage = parseInt(client.linkpagenum) + 1; write(""); } if((client.linkpagenum == "null")||(client.linkpagenum == null)) { client.linkpagenum = 1 temppage2 = new TopPage(client.userid, scrolltable, 1, blankalpha, blankalpha, zeronum, zeronum); pageoneresult = temppage2.ins_scroll(); if(pageoneresult !=0) {temppage2.upd_scroll();} } if(client.accesslevel == "A") /* Different logic exists for a standard user versus one with Admin authority */ {CursorMaster_SA02();} else {CursorUser_SA02();} indx = BuildTableData_SA02(); DeterminePaging_SA02();
"); write(""); write("
"); write(""); write(""); write("
"); write(""); write(""); write("