function initialize()
{
var temp;
initMatrix("form_contents0");
fillMatrix();
if(complete_report!="")
reloadTable(complete_report);
setPersonal();
setHomeCurrencyIndex();
getTodaysDate();
}
var num_of_load_menu_entries=10;
var num_of_params=10;
var max_columns = 7;
var row_number=1;
var num_of_rows= 3*2;
var form_width = 800;
var matrix_division = 100;
var matrix_repetition = 1;
var max_repetitions = 1;
var max_rows = matrix_division*max_repetitions+1;
var setWidth = 130;
var table_sub_rows = new Array();
var loadMenu = new Array(num_of_load_menu_entries);
var submitArray = new Array();
var selected_currencies_array;
var selected_currencies_index;
var load_menu = true;
var user_name = "";
var session = false;
var deleteMenuOffset = 0;
var file_view_choice = new Array();
var file_list = new Array();
// keeps track of the row which is uploading an image
var row = null;
function initMatrix(target)
{
var limit = matrix_repetition*matrix_division + 1;
var text;
var code = '
';
document.getElementById(target).innerHTML=code;
}
function fillMatrix()
{
createMenu();
while(row_number<=num_of_rows) {
createRow(row_number);
file_view_choice[(row_number-1)/2] = 0;
row_number+=2;
}
}
// populates headers
function createMenu()
{
var ref;
ref = document.getElementById("row0column0");
ref.innerHTML = 'No.';
ref = document.getElementById("row0column1");
ref.innerHTML = 'Expense Type';
ref = document.getElementById("row0column2");
ref.innerHTML = 'Date of Purchase (mm/dd/yyyy)';
ref = document.getElementById("row0column3");
ref.innerHTML = 'Amount';
ref = document.getElementById("row0column4");
ref.innerHTML = 'Currency of Purchase';
ref = document.getElementById("row0column5");
ref.innerHTML = 'Payment Method and Rate';
ref = document.getElementById("row0column6");
ref.innerHTML = 'Exchange Rate';
}
/**
* Fills a row with the appropriate fields
*/
function createRow(number)
{
var code;
var ref;
ref = document.getElementById("row"+number+"column0");
document.getElementById("row"+number).style.display = "";
//the value for the area object is increased by one to signify that the sub row
//is in the next row of the matrix; the index for the main row should be odd.
ref.width=setWidth;
ref.innerHTML = ''+(number+1)/2+'';
ref.innerHTML += '';
//expense type : INPUT FIELD IS expen_field_#
ref = document.getElementById("row"+number+"column1");
ref.width = "160";
code = '';
ref.innerHTML = code;
//date of purchase : INPUT FIELDS ARE date_field_#, date_field1_#, and date_field2_#
ref = document.getElementById("row"+number+"column2");
ref.innerHTML = '';
//amount
ref = document.getElementById("row"+number+"column3");
ref.innerHTML = '';
//currency of purchase : INPUT FIELD IS curr_field_#
code = '';
ref = document.getElementById("row"+number+"column4");
ref.innerHTML = code;
//payment method : INPUT FIELD IS pay_field_#
code = '
';
ref = document.getElementById("row"+number+"column5");
ref.innerHTML = code;
//exchange rate : INPUT FIELD IS rate_field_#
ref = document.getElementById("row"+number+"column6");
ref.innerHTML = '';
//sub row variables
var numer = (number-1)/2;
table_sub_rows[numer] = new Array('','','');
}
function eliminateRow(number)
{
var temp;
var limit = max_columns - ((max_columns - 2)*(1-number%2));
for(var i=0; i< limit; i++) {
temp = "row" + number + "column" + i;
document.getElementById(temp).width = null;
document.getElementById(temp).innerHTML = "";
}
document.getElementById('row'+number).style.display = 'none';
}
/**
* sets up and fills in the "sub-row"
* the "sub-row" contains the fields to enter the expense comments, location, and image
*/
function deploySubRow(number)
{
var code;
// removes the display style (should've been "none" to hide the row)
document.getElementById("row"+number).style.display = '';
//number is the row index on the matrix that can be filled by this sub row, the variable
//does not represent the entry number. number/2 is the entry number
// changes the arrow to correspond with the subrow being deployed (ie. down arrow removed and up arrow shown)
// removes down arrow
document.getElementById("row"+(number-1)+"column0").innerHTML = ''+(number)/2+'';
// adds up arrow
ref = document.getElementById("row"+number+"column0");
ref.innerHTML = '';
ref.innerHTML += '';
// builds the HTML for the fields for images, comments and location
var index = number/2 - 1;
ref = document.getElementById("row"+number+"column1");
code = '
';
// applies HTML code to the screen
ref.innerHTML = code;
var loc_field = document.getElementById('loc_field_'+(number-1));
loc_field.value = table_sub_rows[index][0];
// sets selected index to the image currently selected by user for this expense
for(var i=0; i';
ref.innerHTML += '';
var temp=row_num + 1;
document.getElementById("row"+temp).size = null;
var number = (temp/2);
//clears the elements of information
for(var i=0; i<2; i++) {
document.getElementById("row"+temp+"column"+i).width=null;
document.getElementById("row"+temp+"column"+i).innerHTML = '';
}
}
/**
* updates the array with the new information entered in a SubRow
* indexes:
* 0 - location
* 1 - comments
* 2 - images
*/
function setSubRow(index, i, value)
{
table_sub_rows[index][i] = value;
}
/**
* If number of rows is less than max rows, a new row is added, otherwise the
* user is alerted they have the maximum number of rows already.
*/
function createNewRow()
{
if (num_of_rows+2 < max_rows) {
if(row_number > matrix_repetition*matrix_division) {
matrix_repetition++;
initMatrix("form_contents"+(matrix_repetition-1));
}
createRow(row_number);
file_view_choice[(row_number-1)/2] = 0;
num_of_rows += 2;
row_number += 2;
} else {
alert("Cannot create any more rows");
}
}
function createNewRow_check()
{
createNewRow();
}
/**
* Deletes the last row in the table
*/
function deleteRow()
{
if (num_of_rows!=0){
row_number-=2;
num_of_rows-=2;
eliminateRow(row_number);
eliminateRow(row_number+1);
}
table_sub_rows[(row_number-1)/2] = null;
if((row_number-2) < (matrix_repetition-1)*matrix_division && matrix_repetition>1) {
matrix_repetition--;
document.getElementById("form_contents"+matrix_repetition).innerHTML = '';
}
}
function deleteRow_check(){
deleteRow();
}
function clearReport_check(){
if(confirm('This action will erase the current form.\nDo you wish to continue?')){
freshReport();
}
}
/**
* Creates a new report
* - deletes all rows
* - clears the report description
* - creates three fresh rows
*/
function freshReport(){
while(num_of_rows>0){
deleteRow();
}
for(var i=0; i<3; i++){
createNewRow();
}
document.getElementById('report_desc').value = "";
}
/**
* Returns a string containing all the 'profile information'
* includes full name, company, email, home currency, and report description.
*/
function getGeneralInfo()
{
var text="";
var o;
text += "full_name=" + document.getElementById("report_person_name").value + "&";
text += "company=" + document.getElementById("report_comp_name").value + "&";
text += "email=" + document.getElementById("report_email").value + "&";
o = document.getElementById("homecurrency");
text += "curr=" + o.options[o.selectedIndex].value + "&";
text += "description=" + document.getElementById("report_desc").value + "&";
return text;
}
/**
* Checks each row to see if there is any information recorded. if there is
* it's data is appended to a string containing all the information
*
* Returns a string containing each expense.
*/
function verifyForm(save_name)
{
var postMsg = "";
var empty = true;
for(var i=1; i<=num_of_rows;) {
if (checkRow(i)){
postMsg+=submitRow(i);
empty = false;
}
i+=2;
}
if(empty){
alert("The report is empty.");
return "";
} else {
return postMsg;
}
}
/**
* Checks the row specified if it contains any information.
*
* Returns true (contains information) / false (contains no information)
*/
function checkRow(index)
{
temp1 = document.getElementById('expen_field_'+index);
temp2 = document.getElementById('curr_field_'+index);
temp3 = document.getElementById('pay_field_'+index);
if(temp1.options[temp1.selectedIndex].value + "" != "-1" ||
document.getElementById('date_field_'+index).value + "" != "" ||
document.getElementById('am_field_'+index).value + "" != "" ||
temp2.options[temp2.selectedIndex].value + "" != "-1" ||
temp3.options[temp3.selectedIndex].value + "" != "-1" ||
document.getElementById('rate_field_'+index).value + "" != "" ||
table_sub_rows[(index-1)/2][0] + "" != "" ||
table_sub_rows[(index-1)/2][1] + "" != "" ||
table_sub_rows[(index-1)/2][2] + "" != "") {
return true;
} else {
return false;
}
}
/**
* Returns a string containing the information from the row specified
* Formatting will depend on the global variable "session"
* "session" is true for generating a report and false for all other calls.
*/
function submitRow(index)
{
var No, Expense_Type, Date_of_Purchase, Amount, Home_Currency;
var Purchase_Currency, Payment_Method, Exchange_Rate;
var Location, Comments, Image;
var oldindex=index;
var o;
No = "" + ((index+1)/2);
//expen_field_#
Expense_Type = document.getElementById('expen_field_'+index).selectedIndex;
Date_of_Purchase = document.getElementById('date_field_'+index).value;
//am_field_#
Amount = document.getElementById('am_field_'+index).value + "";
//homecurrency
o = document.getElementById('homecurrency');
Home_Currency = o.options[o.selectedIndex].value;
//curr_field_#
o = document.getElementById('curr_field_'+index);
Purchase_Currency = o.options[o.selectedIndex].value;
if (Purchase_Currency == -1) { Purchase_Currency = Home_Currency; }
//pay_field_#
Payment_Method = document.getElementById('pay_field_'+index).selectedIndex;
//rate_field_#
Exchange_Rate = document.getElementById('rate_field_'+index).value + "";
//loc_field_#
index = (index+1)/2 - 1;
Location = escape(table_sub_rows[index][0]);//document.getElementById('loc_field_'+index).value + "";
Comments = escape(table_sub_rows[index][1]);//document.getElementById('com_field_'+index).value + "";
Image = escape(table_sub_rows[index][2]);//document.getElementById('image_field_'+index).value + "";
if(!session){
//{No, Expen, Date, Am, Home_curr, Sell_curr, Pay, Rate, Loc, Com, Image};
var msg = "No=" + No + "&Expen=" + Expense_Type + "&Date=" + Date_of_Purchase + "&Am=" + Amount;
msg += "&Curr=" + Purchase_Currency + "&Pay=" + Payment_Method + "&Rate=" + Exchange_Rate;
msg += "&Loc=" + Location + "&Com=" + Comments+ "&Image=" + Image + "&?";
}
else {
var msg = No + "&" + Expense_Type + "&" + Date_of_Purchase + "&" + Amount;
msg += "&" + Purchase_Currency + "&" + Payment_Method + "&" + Exchange_Rate;
msg += "&" + Location + "&" + Comments+ "&" + Image + "&?";
var o = document.getElementById('curr_field_'+oldindex);
var p = o.options[o.selectedIndex].value;
if (p == -1) { p = Home_Currency; }
selected_currencies_array[selected_currencies_index++] = p + ":" + Date_of_Purchase;
}
return msg;
}
/**
* Gets the correct XML object depending on the users browser. Used in the xmlHTTP calls.
*/
function getXmlObject()
{
var xmlhttp;
try {
xmlhttp = new XMLHttpRequest();
} catch (e) {
try {
xmlhttp=new ActiveXObject("Msxml2.XMLHTTP");
} catch (e) {
try {
xmlhttp=new ActiveXObject("Microsoft.XMLHTTP");
} catch (E) {
xmlhttp=false;
}
}
}
if (!xmlhttp) {
try {
xmlhttp = new XMLHttpRequest();
} catch (e) {
xmlhttp = false;
}
}
return xmlhttp;
}
/**
* Sends a message through xmlHTTP to the server and returns the response text.
*/
function requestQuery(msg){
var text;
var xmlhttp = getXmlObject();
if(!xmlhttp) {
alert("Failed to initialize XMLHTTP object. Please update your browser version.");
} else {
xmlhttp.open("POST", reportajaxURL, false);
try {
xmlhttp.setRequestHeader("Content-Type", "application/x-www-form-urlencoded");
} catch (e) {}
xmlhttp.onreadystatechange=function(){
if (xmlhttp.readyState == 4) {
text = xmlhttp.responseText;
if(text.indexOf('?')<0 && text.length>4) {
alert(text);
if(text == "You need to be logged in to use this option.\r\n") {
location.href = loginURL;
}
}
return text;
}
}
xmlhttp.send(msg);
}
if (xmlhttp.readyState == 4) {
return xmlhttp.responseText;
}
}
var refreshed_rows;//this index is used to erase the data of the rows
//that are not overwritten by the loading process
function reloadTable(text)
{
var temp=0;
refreshed_rows = new Array(num_of_rows/2);
for(var i=0; i<(num_of_rows/2); i++)
refreshed_rows[i]=false;
while((temp=text.indexOf("?"))>0) {
reloadRow(text.substring(0, temp));
text = text.substring((temp+1));
}
for(var i=0; i-1; i++) {
values[i] = text.substring(0, end);
text = text.substring((end+1));
}
if(i!=5) {
alert("Incomplete load from server.\n Load action failed.");
} else {
document.getElementById("report_person_name").value = values[0];
document.getElementById("report_comp_name").value = values[1];
document.getElementById("report_email").value = values[2];
var ref = document.getElementById("homecurrency");
for(var i=0; i-1; i++) {
values[i] = text.substring(0, end);
text = text.substring((end+1));
}
if (i!=num_of_params)
alert("Incomplete load from server.\n Load action failed.");
else {
//the following code is dependant on the way the table is coded
//any changes to the table should be reflected here as well
//num_of_params=10
var info_row_num = parseInt(values[0]);
if ((info_row_num-1) < refreshed_rows.length)
refreshed_rows[info_row_num-1] = true;
while(info_row_num > num_of_rows/2)
createNewRow();
var index=(2*info_row_num-1);
var number=index;
document.getElementById('expen_field_'+index).selectedIndex = values[1];
document.getElementById('date_field_'+index).value = values[2];
document.getElementById('am_field_'+index).value = values[3];
var ref = document.getElementById('curr_field_'+index);
for(var i=0; i';
ref.innerHTML += '';
number++;
for(var i=0; i<2; i++) {
// document.getElementById("row"+number+"column"+i).width=null;
document.getElementById("row"+number+"column"+i).innerHTML = '';
}
}
}
function clearRow(index)
{
document.getElementById('expen_field_'+index).selectedIndex = 0;
document.getElementById('date_field_'+index).value = "";
document.getElementById('am_field_'+index).value = "";
document.getElementById('curr_field_'+index).selectedIndex = 0;
document.getElementById('pay_field_'+index).selectedIndex = 0;
document.getElementById('rate_field_'+index).value = "";
index = (index-1)/2;
table_sub_rows[index][0] = "";
table_sub_rows[index][1] = "";
table_sub_rows[index][2] = "";
}
/**
* Generates the string containing the expense report, sends it to the server to generate the report.
*/
function generateReport()
{
var info = "G";
var o;
info += escape(document.getElementById("report_person_name").value) + "&";
info += escape(document.getElementById("report_comp_name").value) + "&";
info += escape(document.getElementById("report_desc").value) + "&";
o = document.getElementById("homecurrency");
info += o.options[o.selectedIndex].value + "&";
info += escape(document.getElementById("report_email").value) + "&";
info += o.options[o.selectedIndex].value + "&?";
session = true;
selected_currencies_array = new Array();
selected_currencies_index = 0;
var msg = verifyForm("blank");
for(var i=0; i
';
ref.innerHTML += '';
// builds the HTML for the fields for images, comments and location
var index = number/2 - 1;
ref = document.getElementById("row"+number+"column1");
code = '
';
ref.innerHTML += '';
var temp=row_num + 1;
document.getElementById("row"+temp).size = null;
var number = (temp/2);
//clears the elements of information
for(var i=0; i<2; i++) {
document.getElementById("row"+temp+"column"+i).width=null;
document.getElementById("row"+temp+"column"+i).innerHTML = '';
}
}
/**
* updates the array with the new information entered in a SubRow
* indexes:
* 0 - location
* 1 - comments
* 2 - images
*/
function setSubRow(index, i, value)
{
table_sub_rows[index][i] = value;
}
/**
* If number of rows is less than max rows, a new row is added, otherwise the
* user is alerted they have the maximum number of rows already.
*/
function createNewRow()
{
if (num_of_rows+2 < max_rows) {
if(row_number > matrix_repetition*matrix_division) {
matrix_repetition++;
initMatrix("form_contents"+(matrix_repetition-1));
}
createRow(row_number);
file_view_choice[(row_number-1)/2] = 0;
num_of_rows += 2;
row_number += 2;
} else {
alert("Cannot create any more rows");
}
}
function createNewRow_check()
{
createNewRow();
}
/**
* Deletes the last row in the table
*/
function deleteRow()
{
if (num_of_rows!=0){
row_number-=2;
num_of_rows-=2;
eliminateRow(row_number);
eliminateRow(row_number+1);
}
table_sub_rows[(row_number-1)/2] = null;
if((row_number-2) < (matrix_repetition-1)*matrix_division && matrix_repetition>1) {
matrix_repetition--;
document.getElementById("form_contents"+matrix_repetition).innerHTML = '';
}
}
function deleteRow_check(){
deleteRow();
}
function clearReport_check(){
if(confirm('This action will erase the current form.\nDo you wish to continue?')){
freshReport();
}
}
/**
* Creates a new report
* - deletes all rows
* - clears the report description
* - creates three fresh rows
*/
function freshReport(){
while(num_of_rows>0){
deleteRow();
}
for(var i=0; i<3; i++){
createNewRow();
}
document.getElementById('report_desc').value = "";
}
/**
* Returns a string containing all the 'profile information'
* includes full name, company, email, home currency, and report description.
*/
function getGeneralInfo()
{
var text="";
var o;
text += "full_name=" + document.getElementById("report_person_name").value + "&";
text += "company=" + document.getElementById("report_comp_name").value + "&";
text += "email=" + document.getElementById("report_email").value + "&";
o = document.getElementById("homecurrency");
text += "curr=" + o.options[o.selectedIndex].value + "&";
text += "description=" + document.getElementById("report_desc").value + "&";
return text;
}
/**
* Checks each row to see if there is any information recorded. if there is
* it's data is appended to a string containing all the information
*
* Returns a string containing each expense.
*/
function verifyForm(save_name)
{
var postMsg = "";
var empty = true;
for(var i=1; i<=num_of_rows;) {
if (checkRow(i)){
postMsg+=submitRow(i);
empty = false;
}
i+=2;
}
if(empty){
alert("The report is empty.");
return "";
} else {
return postMsg;
}
}
/**
* Checks the row specified if it contains any information.
*
* Returns true (contains information) / false (contains no information)
*/
function checkRow(index)
{
temp1 = document.getElementById('expen_field_'+index);
temp2 = document.getElementById('curr_field_'+index);
temp3 = document.getElementById('pay_field_'+index);
if(temp1.options[temp1.selectedIndex].value + "" != "-1" ||
document.getElementById('date_field_'+index).value + "" != "" ||
document.getElementById('am_field_'+index).value + "" != "" ||
temp2.options[temp2.selectedIndex].value + "" != "-1" ||
temp3.options[temp3.selectedIndex].value + "" != "-1" ||
document.getElementById('rate_field_'+index).value + "" != "" ||
table_sub_rows[(index-1)/2][0] + "" != "" ||
table_sub_rows[(index-1)/2][1] + "" != "" ||
table_sub_rows[(index-1)/2][2] + "" != "") {
return true;
} else {
return false;
}
}
/**
* Returns a string containing the information from the row specified
* Formatting will depend on the global variable "session"
* "session" is true for generating a report and false for all other calls.
*/
function submitRow(index)
{
var No, Expense_Type, Date_of_Purchase, Amount, Home_Currency;
var Purchase_Currency, Payment_Method, Exchange_Rate;
var Location, Comments, Image;
var oldindex=index;
var o;
No = "" + ((index+1)/2);
//expen_field_#
Expense_Type = document.getElementById('expen_field_'+index).selectedIndex;
Date_of_Purchase = document.getElementById('date_field_'+index).value;
//am_field_#
Amount = document.getElementById('am_field_'+index).value + "";
//homecurrency
o = document.getElementById('homecurrency');
Home_Currency = o.options[o.selectedIndex].value;
//curr_field_#
o = document.getElementById('curr_field_'+index);
Purchase_Currency = o.options[o.selectedIndex].value;
if (Purchase_Currency == -1) { Purchase_Currency = Home_Currency; }
//pay_field_#
Payment_Method = document.getElementById('pay_field_'+index).selectedIndex;
//rate_field_#
Exchange_Rate = document.getElementById('rate_field_'+index).value + "";
//loc_field_#
index = (index+1)/2 - 1;
Location = escape(table_sub_rows[index][0]);//document.getElementById('loc_field_'+index).value + "";
Comments = escape(table_sub_rows[index][1]);//document.getElementById('com_field_'+index).value + "";
Image = escape(table_sub_rows[index][2]);//document.getElementById('image_field_'+index).value + "";
if(!session){
//{No, Expen, Date, Am, Home_curr, Sell_curr, Pay, Rate, Loc, Com, Image};
var msg = "No=" + No + "&Expen=" + Expense_Type + "&Date=" + Date_of_Purchase + "&Am=" + Amount;
msg += "&Curr=" + Purchase_Currency + "&Pay=" + Payment_Method + "&Rate=" + Exchange_Rate;
msg += "&Loc=" + Location + "&Com=" + Comments+ "&Image=" + Image + "&?";
}
else {
var msg = No + "&" + Expense_Type + "&" + Date_of_Purchase + "&" + Amount;
msg += "&" + Purchase_Currency + "&" + Payment_Method + "&" + Exchange_Rate;
msg += "&" + Location + "&" + Comments+ "&" + Image + "&?";
var o = document.getElementById('curr_field_'+oldindex);
var p = o.options[o.selectedIndex].value;
if (p == -1) { p = Home_Currency; }
selected_currencies_array[selected_currencies_index++] = p + ":" + Date_of_Purchase;
}
return msg;
}
/**
* Gets the correct XML object depending on the users browser. Used in the xmlHTTP calls.
*/
function getXmlObject()
{
var xmlhttp;
try {
xmlhttp = new XMLHttpRequest();
} catch (e) {
try {
xmlhttp=new ActiveXObject("Msxml2.XMLHTTP");
} catch (e) {
try {
xmlhttp=new ActiveXObject("Microsoft.XMLHTTP");
} catch (E) {
xmlhttp=false;
}
}
}
if (!xmlhttp) {
try {
xmlhttp = new XMLHttpRequest();
} catch (e) {
xmlhttp = false;
}
}
return xmlhttp;
}
/**
* Sends a message through xmlHTTP to the server and returns the response text.
*/
function requestQuery(msg){
var text;
var xmlhttp = getXmlObject();
if(!xmlhttp) {
alert("Failed to initialize XMLHTTP object. Please update your browser version.");
} else {
xmlhttp.open("POST", reportajaxURL, false);
try {
xmlhttp.setRequestHeader("Content-Type", "application/x-www-form-urlencoded");
} catch (e) {}
xmlhttp.onreadystatechange=function(){
if (xmlhttp.readyState == 4) {
text = xmlhttp.responseText;
if(text.indexOf('?')<0 && text.length>4) {
alert(text);
if(text == "You need to be logged in to use this option.\r\n") {
location.href = loginURL;
}
}
return text;
}
}
xmlhttp.send(msg);
}
if (xmlhttp.readyState == 4) {
return xmlhttp.responseText;
}
}
var refreshed_rows;//this index is used to erase the data of the rows
//that are not overwritten by the loading process
function reloadTable(text)
{
var temp=0;
refreshed_rows = new Array(num_of_rows/2);
for(var i=0; i<(num_of_rows/2); i++)
refreshed_rows[i]=false;
while((temp=text.indexOf("?"))>0) {
reloadRow(text.substring(0, temp));
text = text.substring((temp+1));
}
for(var i=0; i