var selBased = "grn";
var selDB = "Home";
var myhref = "_SYS_UHOME";
var token = 0;
var colResult = Array();
var stockResult = Array();
var RToken = 0;
var Req_Replacement = false;
//--------------------------------------------------------------------
function searchList(){
	var elSel = document.getElementById("filterout");
	RemoveAll_Opt(elSel);
	selectedItem=document.form1.basedOn
	for (i=0; i<selectedItem.length;i++){
		if(selectedItem[i].checked == true){
			selBased = selectedItem[i].value;
		}
	}
	if(selBased == "grn"){
		var xmlfile = myhref + "/xml/admin/grn.xml?database=" + selDB;
		ajaxLoader(xmlfile,myhref,67);
	}else{
			var xmlfile = myhref + "/xml/admin/debtorname.xml?database=" + selDB + "";
		ajaxLoader(xmlfile,myhref,68);
	}
	
	
}
//--------------------------------------------------------------------
function XSel_Coming_SalesOrder(xhr){
	if(!evt) var evt = window.event;
var elSel = document.getElementById("mylist");
var i;

	
	 		var sims = xhr.responseXML.getElementsByTagName('cperson');
		var sim = sims.item(0);
		
		var my_main = sim.getElementsByTagName('debtor');
		RemoveAll_Opt(elSel);
		
 		if (elSel.selectedIndex >= 0) {
		 	for(i = 0; i < my_main.length; i++) {
		 		
		 	  mytext = my_main.item(i).getAttribute("text");
		 	  myval = my_main.item(i).getAttribute("value");
		    AddSel_Opt(elSel,mytext,myval);
		   }
		   alert(" Debtor Name loading is Completed");
 			}
	
}
//--------------------------------------------------------------------
function XSel_GRN(xhr){

if(!evt) var evt = window.event;
var elSel = document.getElementById("mylist");
var i;

	
	 	var sims = xhr.responseXML.getElementsByTagName('product');
		var sim = sims.item(0);
		
	
		RemoveAll_Opt(elSel);
		
 		if (elSel.selectedIndex >= 0) {
		 	for(i = 0; i < sim.getElementsByTagName('ITEM').length; i++) {
		 		var my_main = sim.getElementsByTagName('ITEM').item(i);
		 	 	TRANSNO = my_main.getElementsByTagName('TRANSNO')[0].getAttribute("text");
		    AddSel_Opt(elSel,TRANSNO,TRANSNO);
		   }
		   alert(" TRANSNO loading is Completed");
 			}
	

}
//--------------------------------------------------------------------
function searchStockComing(){
	var strTbl = "";
	Req_Replacement = document.getElementById("replacement").checked;
	
	strTbl = 		"<input type=\"hidden\" name=\"gotReplacement\" value=\"" + Req_Replacement + "\">" +
							"<table border=\"0\" cellpadding=\"2\" cellspacing=\"2\" width=\"1600\" class=\"tbl\" id=\"table_stock\">" + 
							"<tr>";
	if(Req_Replacement == true){
	strTbl +=  "<td>&nbsp;</td>";
	}
	strTbl +=		"<td class=\"tdDeep\">Part No.</td>" +
							"<td class=\"tdDeep\">Description</td>" + 
							"<td class=\"tdDeep\">QTY</td>" + 
							"<td class=\"tdDeep\"></td>" + 
							"<td class=\"tdDeep\">Unit</td>" + 
							"<td class=\"tdDeep\">Last 3 months sales Qty</td>" + 
							"<td class=\"tdDeep\">YMBC Ex-Stock</td>" + 
							"<td class=\"tdDeep\">YMFZ ex stock</td>" + 
							"<td class=\"tdDeep\">Total S.order(MY)</td>" + 
							"<td class=\"tdDeep\">Total S.order(Oversea)</td>" + 
							"<td class=\"tdDeep\">YMAS</td>" + 
							"<td class=\"tdDeep\">YMPH</td>" + 
							"<td class=\"tdDeep\">YMKT</td>" + 
							"<td class=\"tdDeep\">YMKG</td>" + 
							"<td class=\"tdDeep\">YMKK</td>" + 
							"<td class=\"tdDeep\">YMBW</td>" + 
							"<td class=\"tdDeep\">YMKL</td>" + 
							"<td class=\"tdDeep\">YMKJ</td>" + 
							"<td class=\"tdDeep\">YMMLK</td>" + 
							"<td class=\"tdDeep\">YMJB</td>" + 
							"<td class=\"tdDeep\">YMIP</td>" + 
							"<td class=\"tdDeep\">YMHK</td>" + 
							"<td class=\"tdDeep\">YMSZ</td>" +
							"<td class=\"tdDeep\">YMSGP</td>" + 
							"<td class=\"tdDeep\">YMTH</td>" + 
							"<td class=\"tdDeep\">YMID</td>" + 
							"<td class=\"tdDeep\">TPSB</td>" + 
							"<td class=\"tdDeep\">QTP</td>" + 
							"</tr>" +
							"</table>";
	document.getElementById("dvResult").innerHTML = "<form method=\"POST\" target=\"_blank\" action=\"" + myhref + "/pub/admin/stockcoming.html\">" + 
																									strTbl + 
																									"<input type=\"submit\" value=\"Download Excel File\"></form>";
	document.getElementById("loadingStatus").innerHTML = "Loading ...";
	var mySel = document.getElementById("filterout");
	var strSel = "";
	for(i = 0; i < mySel.length; i++){
		
		strSel += mySel.options[i].value + ",";
		
	}
	if(selBased == "grn"){
		var xmlfile = myhref + "/xml/admin/grn_stock.xml?database=" + selDB + "&sel=" + strSel;

	}else{
		
		var xmlfile = myhref + "/xml/admin/waiting_stock.xml?database=" + selDB + "&sel=" + strSel;
	}
	//alert(xmlfile);
	ajaxLoader(xmlfile,myhref,65);
}
//--------------------------------------------------------------------
function comingStock_array(xhr){
	
	if(!evt) var evt = window.event;
		var i;
		var hadRec = xhr.responseXML.getElementsByTagName('product').item(0).getAttribute("text");
		
		if(hadRec == 'found'){
	 		var sims = xhr.responseXML.getElementsByTagName('product');
			var sim = sims.item(0);
			
			for(i = 0; i < sim.getElementsByTagName('ITEM').length; i++){
				var my_main = sim.getElementsByTagName('ITEM').item(i);
				pkey = my_main.getElementsByTagName('PKEY')[0].getAttribute("text");
				productid =	my_main.getElementsByTagName('PRODUCTID')[0].getAttribute("text");
				desc = my_main.getElementsByTagName('DESC')[0].getAttribute("text");
				if(Req_Replacement == false) { 
					colResult[colResult.length] = [pkey, productid,desc, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0,"M"];
				}else{
					stockResult[stockResult.length] = [pkey, productid, desc];
				}		
			}
			if(Req_Replacement == false) {
				 
		updateStatus();
		searchSalesOrder();
		return;
			}else{
		find_replacement();
			}
			
			//document.write("<pre>");
			//document.write(print_r(colResult))
			//updateStatusR();
			//searchSalesOrder();
		}
}
//--------------------------------------------------------------------
function find_replacement(){
	if(Req_Replacement == false) { 
		updateStatus();
		searchSalesOrder();
	}else{
		
	colResult[colResult.length] = [stockResult[RToken][0], stockResult[RToken][1], stockResult[RToken][2], 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0,"M"];
	var xmlfile = myhref + "/xml/admin/replacement_stock.xml?database=" + selDB + "&PKEY=" + stockResult[RToken][0];
	ajaxLoader(xmlfile,myhref,69);
	}
	
	
}
//--------------------------------------------------------------------
function XSel_getReplacement(xhr){
	if(!evt) var evt = window.event;
		var i;
		var hadRec = xhr.responseXML.getElementsByTagName('product').item(0).getAttribute("text");
		
		if(hadRec == 'found'){
	 		var sims = xhr.responseXML.getElementsByTagName('product');
			var sim = sims.item(0);
			
			for(i = 0; i < sim.getElementsByTagName('ITEM').length; i++){
				var my_main = sim.getElementsByTagName('ITEM').item(i);
				pkey = my_main.getElementsByTagName('PKEY')[0].getAttribute("text");
				productid =	my_main.getElementsByTagName('PRODUCTID')[0].getAttribute("text");
				desc = my_main.getElementsByTagName('DESC')[0].getAttribute("text");
			
				//stockResult[stockResult.length] = [pkey, productid, desc];
				colResult[colResult.length] = [pkey, productid, desc, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0,0,"R"];		
			}
		}
	
	RToken++;
	if(RToken == stockResult.length){
		updateStatus();
		searchSalesOrder();
	}else{
		
		
		updateStatusR();
		find_replacement();
	}
}
//--------------------------------------------------------------------
function searchSalesOrder(){
	//document.writeln("<pre>");
	//document.writeln(print_r(colResult));
	var xmlfile = myhref + "/xml/admin/coming_stock.xml?database=" + selDB + "&productid=" + colResult[token][0];
	
	ajaxLoader(xmlfile,myhref,66);
}
//--------------------------------------------------------------------
function printResult(xhr){
	if(!evt) var evt = window.event;
		var i;
		var hadRec = xhr.responseXML.getElementsByTagName('product').item(0).getAttribute("text");
		if(hadRec == 'found'){
	 		var sims = xhr.responseXML.getElementsByTagName('product');
			var sim = sims.item(0);
			var my_main = sim.getElementsByTagName('ITEM').item(0);
			colResult[token][3] = my_main.getElementsByTagName('QTY')[0].getAttribute("text");
			colResult[token][4] = my_main.getElementsByTagName('UOM')[0].getAttribute("text");
			colResult[token][5] = my_main.getElementsByTagName('LAST3')[0].getAttribute("text");
			colResult[token][6] = my_main.getElementsByTagName('ONHQ')[0].getAttribute("text");
			colResult[token][7] = my_main.getElementsByTagName('ONFZ')[0].getAttribute("text");
			colResult[token][8] = my_main.getElementsByTagName('ORDMY')[0].getAttribute("text");
			colResult[token][9] = my_main.getElementsByTagName('ORDOS')[0].getAttribute("text");
			colResult[token][10] = my_main.getElementsByTagName('YMAS')[0].getAttribute("text");
			colResult[token][11] = my_main.getElementsByTagName('YMPH')[0].getAttribute("text");
			colResult[token][12] = my_main.getElementsByTagName('YMKT')[0].getAttribute("text");
			colResult[token][13] = my_main.getElementsByTagName('YMKG')[0].getAttribute("text");
			colResult[token][14] = my_main.getElementsByTagName('YMKK')[0].getAttribute("text");
			colResult[token][15] = my_main.getElementsByTagName('YMBW')[0].getAttribute("text");
			colResult[token][16] = my_main.getElementsByTagName('YMKL')[0].getAttribute("text");
			colResult[token][17] = my_main.getElementsByTagName('YMKJ')[0].getAttribute("text");
			colResult[token][18] = my_main.getElementsByTagName('YMMLK')[0].getAttribute("text");
			colResult[token][19] = my_main.getElementsByTagName('YMJB')[0].getAttribute("text");
			colResult[token][20] = my_main.getElementsByTagName('YMIP')[0].getAttribute("text");
			colResult[token][21] = my_main.getElementsByTagName('YMHK')[0].getAttribute("text");
			colResult[token][22] = my_main.getElementsByTagName('YMSGP')[0].getAttribute("text");
			colResult[token][23] = my_main.getElementsByTagName('YMTH')[0].getAttribute("text");
			colResult[token][24] = my_main.getElementsByTagName('YMID')[0].getAttribute("text");
			colResult[token][25] = my_main.getElementsByTagName('TPSB')[0].getAttribute("text");
			colResult[token][26] = my_main.getElementsByTagName('QTP')[0].getAttribute("text");
			colResult[token][27] = my_main.getElementsByTagName('MY_TOTAL')[0].getAttribute("text");
			colResult[token][28] = my_main.getElementsByTagName('OS_TOTAL')[0].getAttribute("text");
			colResult[token][29] = my_main.getElementsByTagName('YMSZ')[0].getAttribute("text");
		}
	var tbody = document.getElementById("table_stock").getElementsByTagName("TBODY")[0];
  var row = document.createElement("TR");
  if(colResult[token][30] == "R"){ 
  	myColor = "tdLigthr";
  }else{
  	myColor = "tdLigth";
  }
  
 
  myColor2 = "tdDeep";
  if(Req_Replacement == true){
	var td0 = document.createElement("TD");
  td0.className = myColor;
  td0.innerHTML = colResult[token][30] + "<input type=\"hidden\" name=\"col[" + token + "][0]\" value=\"" + colResult[token][30] + "\">";
	row.appendChild(td0);
	}
  var td1 = document.createElement("TD");
  td1.className = myColor;
  td1.innerHTML = colResult[token][1] + "<input type=\"hidden\" name=\"col[" + token + "][1]\" value=\"" + colResult[token][1] + "\">";
	row.appendChild(td1);
	var td2 = document.createElement("TD");
  td2.className = myColor;
  td2.innerHTML = colResult[token][2] + "<input type=\"hidden\" name=\"col[" + token + "][2]\" value=\"" + colResult[token][2] + "\">";
	row.appendChild(td2);
	var td3 = document.createElement("TD");
  td3.className = myColor;
  td3.innerHTML = colResult[token][3] + "<input type=\"hidden\" name=\"col[" + token + "][3]\" value=\"" + colResult[token][3] + "\">";
	row.appendChild(td3);
	var td = document.createElement("TD");
  td.className = myColor;
  td.innerHTML = "<input type=\"hidden\" name=\"col[" + token + "][empty]\" value=\"\">";
	row.appendChild(td);
	var td4 = document.createElement("TD");
  td4.className = myColor;
  td4.innerHTML = colResult[token][4] + "<input type=\"hidden\" name=\"col[" + token + "][4]\" value=\"" + colResult[token][4] + "\">";
	row.appendChild(td4);
	var td5 = document.createElement("TD");
  td5.className = myColor;
  td5.innerHTML = colResult[token][5] + "<input type=\"hidden\" name=\"col[" + token + "][5]\" value=\"" + colResult[token][5] + "\">";
	row.appendChild(td5);
	var td6 = document.createElement("TD");
  td6.className = myColor;
  td6.innerHTML = colResult[token][6] + "<input type=\"hidden\" name=\"col[" + token + "][6]\" value=\"" + colResult[token][6] + "\">";
	row.appendChild(td6);
	var td7 = document.createElement("TD");
  td7.className = myColor;
  td7.innerHTML = colResult[token][7] + "<input type=\"hidden\" name=\"col[" + token + "][7]\" value=\"" + colResult[token][7] + "\">";
	row.appendChild(td7);
	var td8 = document.createElement("TD");
  td8.className = myColor;
  td8.innerHTML = colResult[token][8] + "<input type=\"hidden\" name=\"col[" + token + "][8]\" value=\"" + colResult[token][8] + "\">";
	row.appendChild(td8);
	var td9 = document.createElement("TD");
  td9.className = myColor;
  td9.innerHTML = colResult[token][9] + "<input type=\"hidden\" name=\"col[" + token + "][9]\" value=\"" + colResult[token][9] + "\">";
	row.appendChild(td9);
	//var td27 = document.createElement("TD");
  //td27.className = myColor;
  //td27.innerHTML = colResult[token][27] + "<input type=\"hidden\" name=\"col[" + token + "][27]\" value=\"" + colResult[token][27] + "\">";
	//row.appendChild(td27);
	var td10 = document.createElement("TD");
  td10.className = myColor;
  td10.innerHTML = colResult[token][10] + "<input type=\"hidden\" name=\"col[" + token + "][10]\" value=\"" + colResult[token][10] + "\">";
	row.appendChild(td10);
	var td11 = document.createElement("TD");
  td11.className = myColor;
  td11.innerHTML = colResult[token][11] + "<input type=\"hidden\" name=\"col[" + token + "][11]\" value=\"" + colResult[token][11] + "\">";
	row.appendChild(td11);
	var td12 = document.createElement("TD");
  td12.className = myColor;
  td12.innerHTML = colResult[token][12] + "<input type=\"hidden\" name=\"col[" + token + "][12]\" value=\"" + colResult[token][12] + "\">";
	row.appendChild(td12);
	var td13 = document.createElement("TD");
  td13.className = myColor;
  td13.innerHTML = colResult[token][13] + "<input type=\"hidden\" name=\"col[" + token + "][13]\" value=\"" + colResult[token][13] + "\">";
	row.appendChild(td13);
	var td14 = document.createElement("TD");
  td14.className = myColor;
  td14.innerHTML = colResult[token][14] + "<input type=\"hidden\" name=\"col[" + token + "][14]\" value=\"" + colResult[token][14] + "\">";
	row.appendChild(td14);
	var td15 = document.createElement("TD");
  td15.className = myColor;
  td15.innerHTML = colResult[token][15] + "<input type=\"hidden\" name=\"col[" + token + "][15]\" value=\"" + colResult[token][15] + "\">";
	row.appendChild(td15);
	var td16 = document.createElement("TD");
  td16.className = myColor;
  td16.innerHTML = colResult[token][16] + "<input type=\"hidden\" name=\"col[" + token + "][13]\" value=\"" + colResult[token][16] + "\">";
	row.appendChild(td16);
	var td17 = document.createElement("TD");
  td17.className = myColor;
  td17.innerHTML = colResult[token][17] + "<input type=\"hidden\" name=\"col[" + token + "][17]\" value=\"" + colResult[token][17] + "\">";
	row.appendChild(td17);
	var td18 = document.createElement("TD");
  td18.className = myColor;
  td18.innerHTML = colResult[token][18] + "<input type=\"hidden\" name=\"col[" + token + "][18]\" value=\"" + colResult[token][18] + "\">";
	row.appendChild(td18);
	var td19 = document.createElement("TD");
  td19.className = myColor;
  td19.innerHTML = colResult[token][19] + "<input type=\"hidden\" name=\"col[" + token + "][19]\" value=\"" + colResult[token][19] + "\">";
	row.appendChild(td19);
	var td20 = document.createElement("TD");
  td20.className = myColor;
  td20.innerHTML = colResult[token][20] + "<input type=\"hidden\" name=\"col[" + token + "][20]\" value=\"" + colResult[token][20] + "\">";
	row.appendChild(td20);
	//var td28 = document.createElement("TD");
  //td28.className = myColor;
  //td28.innerHTML = colResult[token][28] + "<input type=\"hidden\" name=\"col[" + token + "][28]\" value=\"" + colResult[token][28] + "\">";
	//row.appendChild(td28);
	var td21 = document.createElement("TD");
  td21.className = myColor;
  td21.innerHTML = colResult[token][21] + "<input type=\"hidden\" name=\"col[" + token + "][21]\" value=\"" + colResult[token][21] + "\">";
	row.appendChild(td21);
	var td181 = document.createElement("TD");
  td181.className = myColor;
  td181.innerHTML = colResult[token][29] + "<input type=\"hidden\" name=\"col[" + token + "][181]\" value=\"" + colResult[token][29] + "\">";
	row.appendChild(td181);
	var td22 = document.createElement("TD");
  td22.className = myColor;
  td22.innerHTML = colResult[token][22] + "<input type=\"hidden\" name=\"col[" + token + "][22]\" value=\"" + colResult[token][22] + "\">";
	row.appendChild(td22);
	var td23 = document.createElement("TD");
  td23.className = myColor;
  td23.innerHTML = colResult[token][23] + "<input type=\"hidden\" name=\"col[" + token + "][23]\" value=\"" + colResult[token][23] + "\">";
	row.appendChild(td23);
	var td24 = document.createElement("TD");
  td24.className = myColor;
  td24.innerHTML = colResult[token][24] + "<input type=\"hidden\" name=\"col[" + token + "][24]\" value=\"" + colResult[token][24] + "\">";
	row.appendChild(td24);
	var td25 = document.createElement("TD");
  td25.className = myColor;
  td25.innerHTML = colResult[token][25] + "<input type=\"hidden\" name=\"col[" + token + "][25]\" value=\"" + colResult[token][25] + "\">";
	row.appendChild(td25);
	var td26 = document.createElement("TD");
  td26.className = myColor;
  td26.innerHTML = colResult[token][26] + "<input type=\"hidden\" name=\"col[" + token + "][26]\" value=\"" + colResult[token][26] + "\">";
	row.appendChild(td26);
  tbody.appendChild(row);
  token = token + 1;
  if(token < colResult.length){
  updateStatus();
  searchSalesOrder();
	}else{
		updateStatus();
	}
}
//--------------------------------------------------------------------
function updateStatus(){
	document.getElementById("loadingStatus").innerHTML = "Received item : " + token + " / " + colResult.length;
}
//--------------------------------------------------------------------
function updateStatusR(){
	document.getElementById("loadingStatus").innerHTML = "Received Replacement item : " + RToken + " / " + stockResult.length;
}