//initial function to display search results
function submit_createBatch_search()
{
var orderString = orderSearchArray.join("~");
document.getElementById("orderString").value = orderString;
//alert(orderString);
var location = document.getElementById('location').value;
var chemicals = document.getElementById('chemicals').value;
var startDate = document.getElementById('startDate').value;
var endDate = document.getElementById('endDate').value;
var page = "dbQuery.php?mode=getSearchData&location=" + location + "&chemicals=" + chemicals + "&startDate=" + startDate + "&endDate=" + endDate + "&orderString=" + orderString ;
var returnData = process_AJAX(page,1);
var resultArray = returnData.split("||");
//alert (resultArray);
//the table below displays the results of the search and allows the user to delete any particular row by calling the function 'submit_Resummarize_Batch_search(\""+resultArrayContent[0]+"\" --> carring the bc_id of the array
var dataTable = document.getElementById('SearchTable');
var numRows = dataTable.rows.length;
if (numRows > 1)
{
//Delete all previous data in result table
for (var i = numRows; i > 1; i--)
{
var rowIndexValue = i - 1;
dataTable.deleteRow(rowIndexValue);
}
}
////ensures that there is data in the response text
if (resultArray[0] != '')
{
orderResultArray.length = 0;
for (var i = 0; i < resultArray.length -1; i++)
{
var resultArrayContent = resultArray[i].split("~");
var newRow = dataTable.insertRow(-1);
var ID = newRow.insertCell(0);
var bc_id = newRow.insertCell(1);
var location = newRow.insertCell(2);
var releaseDate = newRow.insertCell(3);
var chemical = newRow.insertCell(4);
var uom = newRow.insertCell(5);
var carrier = newRow.insertCell(6);
var grower = newRow.insertCell(7);
var farm = newRow.insertCell(8);
var field = newRow.insertCell(9);
var rowID = i + 1;
ID.innerHTML="<img src= '../images/delete.gif' onClick='submit_Resummarize_Batch_search(\""+resultArrayContent[0]+"\");'/>";
bc_id.innerHTML=resultArrayContent[0];
location.innerHTML=resultArrayContent[1];
releaseDate.innerHTML=resultArrayContent[2];
chemical.innerHTML=resultArrayContent[3];
uom.innerHTML=resultArrayContent[4];
carrier.innerHTML=resultArrayContent[8];
grower.innerHTML=resultArrayContent[5];
farm.innerHTML=resultArrayContent[6];
field.innerHTML=resultArrayContent[7];
field.innerHTML=resultArrayContent[9];
orderResultArray.push(resultArrayContent[0]);
}
}
////////the following table displays the summary results of the above table
var BatchTable = document.getElementById('BatchSummary');
var numRows = BatchTable.rows.length;
if (numRows > 1)
{
//Delete all previous data in result table
for (var i = numRows; i > 1; i--)
{
var rowIndexValue = i - 1;
BatchTable.deleteRow(rowIndexValue);
}
}
////ensures that there is data in the response text
if (resultArray[0] != '')
{
for (var i = 0; i < resultArray.length -1; i++)
{
var resultArrayContent = resultArray[i].split("~");
var newRow = BatchTable.insertRow(-1);
var Title = newRow.insertCell(0);
var blankA = newRow.insertCell(1);
var blankB = newRow.insertCell(2);
var blankC = newRow.insertCell(3);
var blankF = newRow.insertCell(4);
var blankAA = newRow.insertCell(5);
Title.innerHTML="<B>Batch Summary</B>";
blankA.innerHTML="";
blankB.innerHTML="";
blankC.innerHTML="";
blankF.innerHTML="";
blankAA.innerHTML="";
var newRow2 = BatchTable.insertRow(-1);
var ChemicalLabel = newRow2.insertCell(0);
var Chemical = newRow2.insertCell(1);
var blankG = newRow2.insertCell(2);
var BatchLabel = newRow2.insertCell(3);
var Batch = newRow2.insertCell(4);
ChemicalLabel.innerHTML="Product:";
Chemical.innerHTML=resultArrayContent[3];
blankG.innerHTML="";
BatchLabel.innerHTML="Batch Name:";
Batch.innerHTML="<input name=\"batch\" type=\"text\" size=\"30\" maxlength=\"25\" />";
var newRow3 = BatchTable.insertRow(-1);
var AmountLabel = newRow3.insertCell(0);
var Amount = newRow3.insertCell(1);
var blankH = newRow3.insertCell(2);
var PilotLabel = newRow3.insertCell(3);
var Pilot = newRow3.insertCell(4);
AmountLabel.innerHTML="Amount:";
Amount.innerHTML=resultArrayContent[10];
blankH.innerHTML="";
PilotLabel.innerHTML="Pilot:";
Pilot.innerHTML="<select name=\"pilot\"><option>Chris Haak</option> </select>";
var newRow4 = BatchTable.insertRow(-1);
var blankD = newRow4.insertCell(0);
var blankE = newRow4.insertCell(1);
var blankBB = newRow4.insertCell(2);
var MixingLabel = newRow4.insertCell(3);
var MixingLocation = newRow4.insertCell(4);
blankD.innerHTML="";
blankE.innerHTML="";
blankBB.innerHTML="";
MixingLabel.innerHTML="Junge Mixing Location:";
MixingLocation.innerHTML="<select name=\"mixingLocation\"><option>Virden</option> <option>Lincoln</option></select>";
var newRow5 = BatchTable.insertRow(-1);
var CarrierLabel = newRow5.insertCell(0);
var Carrier = newRow5.insertCell(1);
var blank1 = newRow5.insertCell(2);
var blank2 = newRow5.insertCell(3);
CarrierLabel.innerHTML="Carrier:";
Carrier.innerHTML=resultArrayContent[8];
blank1.innerHTML="";
blank2.innerHTML="";
var newRow6 = BatchTable.insertRow(-1);
var CAmountLabel = newRow6.insertCell(0);
var CarrierAmount = newRow6.insertCell(1);
var blank3 = newRow6.insertCell(2);
var blank4 = newRow6.insertCell(3);
CAmountLabel.innerHTML="Amount:";
CarrierAmount.innerHTML=resultArrayContent[11];
blank3.innerHTML="";
blank4.innerHTML="";
//alert(resultArray.length);
}
var newRow7 = BatchTable.insertRow(-1);
var blank5 = newRow7.insertCell(0);
var blank6 = newRow7.insertCell(1);
var Save = newRow7.insertCell(2);
var Cancel = newRow7.insertCell(3);
blank5.innerHTML="";
blank6.innerHTML="";
Save.innerHTML="<button type=button name=\"Save\" onClick=\"save_Batch();\">Save</button>";
Cancel.innerHTML="<button type=button name=\"Cancel\" onClick=\"cancel_Batch();\">Cancel</button>";
}
}///end of function for search results
///the following function resummarizes and redisplays the results after the user deletes one of the search results
function submit_Resummarize_Batch_search(deleteOrderId)
{
for (var i=0; i<orderResultArray.length; i++) {
if (deleteOrderId == orderResultArray[i]) {
orderResultArray.splice(i,1);
}
}
var orderString = orderResultArray.join("~");
document.getElementById("orderString").value = orderString;
//alert(orderString);
var page = "dbQuery.php?mode=getSearchData&orderString=" + orderString;
var returnData = process_AJAX(page,1);
var resultArray = returnData.split("||");
//alert (resultArray);
/// redisplaying the search results after deleting a row
var dataTable = document.getElementById('SearchTable');
var numRows = dataTable.rows.length;
if (numRows > 1)
{
//Delete all previous data in result table
for (var i = numRows; i > 1; i--)
{
var rowIndexValue = i - 1;
dataTable.deleteRow(rowIndexValue);
}
}
////ensures that there is data in the response text
if (resultArray[0] != '')
{
orderResultArray.length = 0;
for (var i = 0; i < resultArray.length -1; i++)
{
var resultArrayContent = resultArray[i].split("~");
var newRow = dataTable.insertRow(-1);
var ID = newRow.insertCell(0);
var bc_id = newRow.insertCell(1);
var location = newRow.insertCell(2);
var releaseDate = newRow.insertCell(3);
var chemical = newRow.insertCell(4);
var uom = newRow.insertCell(5);
var carrier = newRow.insertCell(6);
var grower = newRow.insertCell(7);
var farm = newRow.insertCell(8);
var field = newRow.insertCell(9);
var rowID = i + 1;
ID.innerHTML="<img src= '../images/delete.gif' onClick='submit_Resummarize_Batch_search("+resultArrayContent[0]+");'/>";
bc_id.innerHTML=resultArrayContent[0];
location.innerHTML=resultArrayContent[1];
releaseDate.innerHTML=resultArrayContent[2];
chemical.innerHTML=resultArrayContent[3];
uom.innerHTML=resultArrayContent[4];
carrier.innerHTML=resultArrayContent[8];
grower.innerHTML=resultArrayContent[5];
farm.innerHTML=resultArrayContent[6];
field.innerHTML=resultArrayContent[7];
field.innerHTML=resultArrayContent[9];
//alert(resultArray.length);
}
}
////////this redisplays the summary results after the users deletes a row
var BatchTable = document.getElementById('BatchSummary');
var numRows = BatchTable.rows.length;
if (numRows > 1)
{
//Delete all previous data in result table
for (var i = numRows; i > 1; i--)
{
var rowIndexValue = i - 1;
BatchTable.deleteRow(rowIndexValue);
}
}
////ensures that there is data in the response text
if (resultArray[0] != '')
{
for (var i = 0; i < resultArray.length -1; i++)
{
var resultArrayContent = resultArray[i].split("~");
var newRow = BatchTable.insertRow(-1);
var Title = newRow.insertCell(0);
var blankA = newRow.insertCell(1);
var blankB = newRow.insertCell(2);
var blankC = newRow.insertCell(3);
var blankF = newRow.insertCell(4);
var blankAA = newRow.insertCell(5);
Title.innerHTML="<B>Batch Summary</B>";
blankA.innerHTML="";
blankB.innerHTML="";
blankC.innerHTML="";
blankF.innerHTML="";
blankAA.innerHTML="";
var newRow2 = BatchTable.insertRow(-1);
var ChemicalLabel = newRow2.insertCell(0);
var Chemical = newRow2.insertCell(1);
var blankG = newRow2.insertCell(2);
var BatchLabel = newRow2.insertCell(3);
var Batch = newRow2.insertCell(4);
ChemicalLabel.innerHTML="Product:";
Chemical.innerHTML=resultArrayContent[3];
blankG.innerHTML="";
BatchLabel.innerHTML="Batch Name:";
Batch.innerHTML="<input name=\"batch\" type=\"text\" size=\"30\" maxlength=\"25\" />";
var newRow3 = BatchTable.insertRow(-1);
var AmountLabel = newRow3.insertCell(0);
var Amount = newRow3.insertCell(1);
var blankH = newRow3.insertCell(2);
var PilotLabel = newRow3.insertCell(3);
var Pilot = newRow3.insertCell(4);
AmountLabel.innerHTML="Amount:";
Amount.innerHTML=resultArrayContent[10];
blankH.innerHTML="";
PilotLabel.innerHTML="Pilot:";
Pilot.innerHTML="<select name=\"pilot\"><option>Chris Haak</option> </select>";
var newRow4 = BatchTable.insertRow(-1);
var blankD = newRow4.insertCell(0);
var blankE = newRow4.insertCell(1);
var blankBB = newRow4.insertCell(2);
var MixingLabel = newRow4.insertCell(3);
var MixingLocation = newRow4.insertCell(4);
blankD.innerHTML="";
blankE.innerHTML="";
blankBB.innerHTML="";
MixingLabel.innerHTML="Junge Mixing Location:";
MixingLocation.innerHTML="<select name=\"mixingLocation\"><option>Virden</option> <option>Lincoln</option></select>";
var newRow5 = BatchTable.insertRow(-1);
var CarrierLabel = newRow5.insertCell(0);
var Carrier = newRow5.insertCell(1);
var blank1 = newRow5.insertCell(2);
var blank2 = newRow5.insertCell(3);
CarrierLabel.innerHTML="Carrier:";
Carrier.innerHTML=resultArrayContent[8];
blank1.innerHTML="";
blank2.innerHTML="";
var newRow6 = BatchTable.insertRow(-1);
var CAmountLabel = newRow6.insertCell(0);
var CarrierAmount = newRow6.insertCell(1);
var blank3 = newRow6.insertCell(2);
var blank4 = newRow6.insertCell(3);
CAmountLabel.innerHTML="Amount:";
CarrierAmount.innerHTML=resultArrayContent[11];
blank3.innerHTML="";
blank4.innerHTML="";
//alert(resultArray.length);
}
var newRow7 = BatchTable.insertRow(-1);
var blank5 = newRow7.insertCell(0);
var blank6 = newRow7.insertCell(1);
var Save = newRow7.insertCell(2);
var Cancel = newRow7.insertCell(3);
blank5.innerHTML="";
blank6.innerHTML="";
Save.innerHTML="<button type=button name=\"Save\" onClick=\"save_Batch();\">Save</button>";
Cancel.innerHTML="<button type=button name=\"Cancel\" onClick=\"cancel_Batch();\">Cancel</button>";
}
}///end of function for search results