//--------------------------------------------------------------------
//declaration
//--------------------------------------------------------------------
var fromDate = "1/1/2004";
var toDate = "1/1/2004";
var ispart = false;
var partCode = "";
var interbase = "";
var Ihref = "_SYS_UHOME";
var showHQ = false;
var showSGP = false;
var showHK = false;
var wantFilter = false;
var wantReplacement = false;
var xmlResult = new Array();
var xmlResult_2 = new Array();
var repeatControl = new Array();
var ArrDate = new Array();
var culNum = 0;
var Token = 0;
var QtyToken = 0;
var numQty = 0;
var SalesDay = 0;
var StockDay = 0;
var Percentage = 0;
var CurrentDB = "";
var isChild = false;
var PreMode = "M";
var currentParent = 0;
var MySelectedDebtor = new Array();
var selectForeman = new Array();
var globalvalue = "";
	var selecteddebtor = "";
//--------------------------------------------------------------------
function SwapOption(myid,subid,myhref){
	var snum = myid.options[myid.selectedIndex].value;
	
 	var xmlfile = Ihref + "/xml/admin/debtorname.xml?database=" + snum + "&all=no";
 	alert(xmlfile);
	ajaxLoader(xmlfile,subid,10);
}
//--------------------------------------------------------------------
function reset_toDefault(){
fromDate = "1/1/2004";
toDate = "1/1/2004";
ispart = false;
partCode = "";
interbase = "";
showHQ = false;
showSGP = false;
showHK = false;
QtyToken = 0;
numQty = 0;
wantFilter = false;
wantReplacement = false;
xmlResult = new Array();
xmlResult_2 = new Array();
repeatControl = new Array();
ArrDate = new Array();
Token = 0;
QtyToken = 0;
numQty = 0;
TokenLength = 1;
SalesDay = 0;
StockDay = 0;
Percentage = 0;
isChild = false;
PreMode = "M";
var currentParent = 0;
document.getElementById("reportdate").innerHTML = "";
document.getElementById("loadingarea").innerHTML = "";
document.getElementById("refreshbutton").innerHTML = "";
document.getElementById("result").innerHTML = "";
document.getElementById("downloadexcel").innerHTML = "";
}
//--------------------------------------------------------------------
function print_cust_reorder(){
	reset_toDefault();
	var pkey = document.getElementById("selecteddebtor");
	selecteddebtor = "";
	
	for(i = 0; i < pkey.length; i++){
		selecteddebtor += pkey.options[i].value + "@";
		//MySelectedDebtor[MySelectedDebtor.length] = pkey.options[i].value;
	}
	

	interbase = document.getElementById("warehouse").options[document.getElementById("warehouse").selectedIndex].value;                                                                                                                                                                                                                                            
	from = document.getElementById("fromdate").value;
	to = document.getElementById("todate").value;
	document.getElementById("reportdate").innerHTML = "<h4>" + from + " - " + to + "<input type=\"hidden\" name=\"reportdate\" value=\""+ from + " - " + to +"\"</h4>";
	strfrom = from.split("/");
	strto = to.split("/");
	fromDate = strfrom[1] + "/" + strfrom[0] + "/" + strfrom[2];
	toDate = strto[1] + "/" + strto[0] + "/" + strto[2];
	BetweenListDate(fromDate,toDate);
	
	SalesDay = document.getElementById("salesday").value;
	StockDay = document.getElementById("instock").value;
	Percentage = document.getElementById("percentage").value;
	if(document.getElementById("ymhq").checked == true){ showHQ = true; TokenLength++; numQty++; }
	if(document.getElementById("ymsgp").checked == true){ showSGP = true; TokenLength++; numQty++; }
	if(document.getElementById("ymhk").checked == true){ showHK = true; TokenLength++; numQty++; }
	if(document.getElementById("filteredreorder").checked == true) wantFilter = true;
	if(document.getElementById("showreplacement").checked == true) wantReplacement = true;
	if(document.getElementById("ispart").checked == true) ispart = true;
	partCode = document.getElementById("partcode").value;
	_report_salesQty_1();
	//alert(interbase);
}
//--------------------------------------------------------------------
function _report_salesQty_1(){
	productcode = "";
	if(ispart == true){
		productcode = "&product=" + partCode;
	}
	var xmlfile = Ihref + "/xml/admin/salesonday.xml?database=" + interbase + "&fromdate=" + ArrDate[Token][0] + "&todate=" + ArrDate[Token][1] + productcode + "&filter=" + selecteddebtor;
	//alert(xmlfile);
	//return;
	ajaxLoader(xmlfile,Ihref,46);
	percentage = Token / ArrDate.length * 100;
	percentage = Math.round(percentage);
	document.getElementById("loadingarea").innerHTML = "Loading : " + percentage + "%" ;
	return;
}
//--------------------------------------------------------------------
function custReorder_getallRecord(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 rec = sim.getElementsByTagName('ITEM');
			for(i=0; i < rec.length; i++){
				var my_main = sim.getElementsByTagName('ITEM').item(i);
				STOCK = my_main.getElementsByTagName('STOCK')[0].getAttribute("text");
				PRODUCTID = my_main.getElementsByTagName('PRODUCTID')[0].getAttribute("text");
				QTY = my_main.getElementsByTagName('QTY')[0].getAttribute("text");
				if(pkey = in_array(PRODUCTID, repeatControl)){
					xmlResult[pkey][2] = parseInt(xmlResult[pkey][2]) + parseInt(QTY);
				}else{
				pkey = xmlResult.length;
				repeatControl[pkey] = PRODUCTID;
				xmlResult[pkey] = [PRODUCTID, STOCK, QTY, [], [], 0, 0, 0, 0, 0, [], 0, 0, 0, 0];
				// product code, stock id, qty, stock on hand, fz, 30 day sales, po order, hq,sgp,hk, replacement.
				}
			}
		}else if(hadRec == 'noserver'){
			alert("Internet Connection was disconnected, Please Re-Run Report ! ");
		}
	Token = Token + 1;
	if(Token < ArrDate.length){
			_report_salesQty_1();
	}else{
		document.getElementById("loadingarea").innerHTML = "[Total Result : " + xmlResult.length + "] "  ;
		xmlResult.sort();
		if(wantReplacement == true){
			
			document.getElementById("loadingarea").innerHTML = "[Total Result : " + xmlResult.length + "] Loading Replacement : 0 %"  ;
			Token = 0;
			load_replacement();
		}else{
			
			print_table_column();
		}
		
		
}
}
//--------------------------------------------------------------------
function in_array(searchKey, arrayInfo){
	for(i = 0; i < arrayInfo.length; i++){
		if(searchKey == arrayInfo[i]) return i;
	}
	return false;
}
//--------------------------------------------------------------------
function load_replacement(){
	
			var xmlfile = Ihref + "/xml/admin/findreplacement.xml?database=" + interbase + "&product=" + xmlResult[Token][0];
			ajaxLoader(xmlfile,Ihref,47);
			percentage = Token / xmlResult.length * 100;
			percentage = Math.round(percentage);
			document.getElementById("loadingarea").innerHTML = "[Total Result : " + xmlResult.length + "] Loading Replacement :  " + percentage + "%" ;
}
//--------------------------------------------------------------------
function custReorder_findreplacement(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 rec = sim.getElementsByTagName('ITEM');
			for(i=0; i < rec.length; i++){
				var my_main = sim.getElementsByTagName('ITEM').item(i);
				STOCK = my_main.getElementsByTagName('STOCK')[0].getAttribute("text");
				PRODUCTID = my_main.getElementsByTagName('PRODUCTID')[0].getAttribute("text");
				xmlResult[Token][10][xmlResult[Token][10].length] = [PRODUCTID, STOCK, 0, [], [], 0, 0, 0, 0, 0, [], 0, 0, 0, 0]
			}
			
		}else if(hadRec == 'noserver'){
			alert("Internet Connection was disconnected, Please Re-Run Report ! ");
		}	
	Token = Token + 1;
	//alert(xmlResult.length);
	if(Token < xmlResult.length){
		
		load_replacement();
	}else{
		print_table_column();
	}
		
	
}
//--------------------------------------------------------------------
function find_productlocation(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 rec = sim.getElementsByTagName('ITEM');
			if(rec.length == 0 ){
				xmlResult_2[Token][3][xmlResult_2[Token][3].length] = [0, "--"];
			}else{
			for(i=0; i < rec.length; i++){
				var my_main = sim.getElementsByTagName('ITEM').item(i);
				QTY = my_main.getElementsByTagName('QTY')[0].getAttribute("text");
				MYlocation = my_main.getElementsByTagName('LOCATION')[0].getAttribute("text");
				xmlResult_2[Token][3][xmlResult_2[Token][3].length] = [QTY, MYlocation];
			}
		}
		}
	
		document.getElementById("loadingarea").innerHTML = "[Total Result : " + Token + "/" + xmlResult_2.length + "] [20%]"   ;
		var xmlfile = Ihref + "/xml/admin/purchasedorder.xml?database=" + interbase + "&product=" + xmlResult_2[Token][0];
		ajaxLoader(xmlfile,Ihref,53);
}
//--------------------------------------------------------------------
function find_purchasedorder(xhr){
	if(!evt) var evt = window.event;
		var i;
		QTY = 0;
		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 rec = sim.getElementsByTagName('ITEM').item(0);
			QTY = rec.getElementsByTagName('QTY')[0].getAttribute("text");
		}
		xmlResult_2[Token][6] = QTY;
		document.getElementById("loadingarea").innerHTML = "[Total Result : " + Token + "/" + xmlResult_2.length + "] [40%]"   ;
		var xmlfile = Ihref + "/xml/admin/salesqty.xml?database=" + interbase + "&product=" + xmlResult_2[Token][0] + "&salesday=" + SalesDay + "&outfilter=" + selecteddebtor;
		ajaxLoader(xmlfile,Ihref,54);
	
}
//--------------------------------------------------------------------
function find_salesinvoice(xhr){
	if(!evt) var evt = window.event;
		var i;
		QTY = 0;
		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 rec = sim.getElementsByTagName('ITEM').item(0);
			QTY = rec.getElementsByTagName('QTY')[0].getAttribute("text");
		}
		xmlResult_2[Token][5] = QTY;
		document.getElementById("loadingarea").innerHTML = "[Total Result : " + Token + "/" + xmlResult_2.length + "] [50%]"   ;
		if(selecteddebtor != ""){
		var xmlfile = Ihref + "/xml/admin/salesqty.xml?database=" + interbase + "&product=" + xmlResult_2[Token][0] + "&salesday=" + SalesDay + "&infilter=" + selecteddebtor;
		ajaxLoader(xmlfile,Ihref,62);
		}else{
		if(showHQ == true){
			loadQty("YMHQ");
		} 
		if(showSGP == true){
			loadQty("YMSGP");
		}
		if(showHK == true){
			loadQty("YMHK");
		}
		if(showHQ == false && showSGP == false && showHK == false){
			bind_tr();
		}
		}
		
}
//--------------------------------------------------------------------
function find_outtotal(xhr){
	if(!evt) var evt = window.event;
		var i;
		QTY = 0;
		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 rec = sim.getElementsByTagName('ITEM').item(0);
			QTY = rec.getElementsByTagName('QTY')[0].getAttribute("text");
		}
	xmlResult_2[Token][11] = QTY;
		document.getElementById("loadingarea").innerHTML = "[Total Result : " + Token + "/" + xmlResult_2.length + "] [60%]"   ;
	
	if(showHQ == true){
			loadQty("YMHQ");
		} 
		if(showSGP == true){
			loadQty("YMSGP");
		}
		if(showHK == true){
			loadQty("YMHK");
		}
		if(showHQ == false && showSGP == false && showHK == false){
			bind_tr();
		}
}
//--------------------------------------------------------------------
function loadQty(interBD){
	var xmlfile = Ihref + "/xml/admin/searchqty.xml?database=" + interBD + "&product=" + xmlResult_2[Token][0] ;
	
	ajaxLoader(xmlfile,Ihref,55);
}
//--------------------------------------------------------------------
function find_searchqty(xhr){
	if(!evt) var evt = window.event;
		var i;
		QTY = 0;
		
		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 rec = sim.getElementsByTagName('ITEM').item(0);
			QTY = rec.getElementsByTagName('QTY')[0].getAttribute("text");
			DB = rec.getElementsByTagName('DBI')[0].getAttribute("text");
			
			switch(DB){
				case "YMHQ":
				xmlResult_2[Token][7] = QTY;
				break;
				case "YMSGP":
				xmlResult_2[Token][8] = QTY;
				break;
				case "YMHK":
				xmlResult_2[Token][9] = QTY;
				break;
			}
			BKtoken();
		}else{
			DB = xhr.responseXML.getElementsByTagName('product').item(0).getAttribute("db");
			switch(DB){
				case "YMHQ":
				xmlResult_2[Token][7] = "--";
				break;
				case "YMSGP":
				xmlResult_2[Token][8] = "--";
				break;
				case "YMHK":
				xmlResult_2[Token][9] = "--";
				break;
			}
			BKtoken();
		}
		
}
//--------------------------------------------------------------------
function BKtoken(){
	QtyToken = QtyToken + 1;
	//alert(QtyToken + " " + numQty);
	if(QtyToken >= numQty){
		
		document.getElementById("loadingarea").innerHTML = "[Total Result : " + Token + "/" + xmlResult_2.length + "] [100%]"   ;
		QtyToken = 0;
		bind_tr();
	}
}
//--------------------------------------------------------------------

//--------------------------------------------------------------------
function bind_tr(){
	  //document.getElementById("loadingpart").innerHTML = xmlResult_2[parseInt(Token) + 1 ][0];
	  NetQty = 0;
		
		
		numStockDay = SalesDay / StockDay;
		myFirstLoc = new Array();
		mySecondLoc = new Array();
		CurrLoc = xmlResult_2[Token][3];
		numRow = 0;
		QtyonHand = 0;
		for(i = 0; i < CurrLoc.length; i++){
			tmpStr = CurrLoc[i][1];
			tmpQty = CurrLoc[i][0];
			QtyonHand = parseInt(QtyonHand) + parseInt(CurrLoc[i][0]);
			tmpName = tmpStr.substr(0,4);
			if(interbase == "YMHQ" && tmpName.toUpperCase() == "YMFZ"){
				mySecondLoc[mySecondLoc.length] = [tmpStr, tmpQty];
			}else{
				myFirstLoc[myFirstLoc.length] = [tmpStr, tmpQty];
			}
		}
		numRow = myFirstLoc.length;
		
		if(myFirstLoc.length < mySecondLoc.length){
			numRow = mySecondLoc.length;
		}
		//alert(numRow + " " + myFirstLoc.length + " " + mySecondLoc.length);
		NumKeep = xmlResult_2[Token][5] / numStockDay ;
		NumKeep = NumKeep.toFixed(2);
		//numReorder = parseInt(NumKeep) - parseInt(QtyonHand);
		numPercentage = 100 + parseInt(Percentage);
		numPercentage = numPercentage / 100;
		numReorder = NumKeep * numPercentage;
		numReorder = numReorder.toFixed(2);
		NetQty = numReorder - parseInt(xmlResult_2[Token][6]) - parseInt(QtyonHand);
		//alert(NetQty + "=" + numReorder + "-" + parseInt(xmlResult_2[Token][6])  + "-" +  parseInt(QtyonHand));
		//numReorder = numReorder.toFixed(2);
		
		if(NetQty > 0 && xmlResult_2[Token][10] == "M"){
					currentParent = xmlResult_2[Token][11];
		}
		//alert( currentParent + "  " + xmlResult_2[Token][11]);
		if(wantFilter == true && wantReplacement == true){
			if(xmlResult_2[Token][10] == "R" && currentParent != xmlResult_2[Token][11]){
					Token = Token + 1;
					document.getElementById("loadingarea").innerHTML = "[Total Result : " + Token + "/" + xmlResult_2.length + "] [0]"   ;
					var xmlfile = Ihref + "/xml/admin/productlocation.xml?database=" + interbase + "&product=" + xmlResult_2[Token][0];
					ajaxLoader(xmlfile,Ihref,52);
					return;
			}
			if(NetQty < 0 && xmlResult_2[Token][10] == "M"){
				if(Token > xmlResult_2.length){
					document.getElementById("loadingarea").innerHTML = "[Total Result : 100 %] [Done]"   ;
				}else{
					Token = Token + 1;
					document.getElementById("loadingarea").innerHTML = "[Total Result : " + Token + "/" + xmlResult_2.length + "] [0]"   ;
					var xmlfile = Ihref + "/xml/admin/productlocation.xml?database=" + interbase + "&product=" + xmlResult_2[Token][0];
					ajaxLoader(xmlfile,Ihref,52);
					return;
				}
		
			
			}
		}else	if(wantFilter == true){
			if(NetQty < 0 ){
				//Token = Token + 1;
				if(Token > xmlResult_2.length){
					document.getElementById("loadingarea").innerHTML = "[Total Result : 100 %] [Done]"   ;
				}else{
					Token = Token + 1;
					document.getElementById("loadingarea").innerHTML = "[Total Result : " + Token + "/" + xmlResult_2.length + "] [0]"   ;
				var xmlfile = Ihref + "/xml/admin/productlocation.xml?database=" + interbase + "&product=" + xmlResult_2[Token][0];
				ajaxLoader(xmlfile,Ihref,52);
				}
			return;
			}
		}
	
		document.getElementById("loadingarea").innerHTML = "[Total Result : " + Token + "/" + xmlResult_2.length + "] [100%]"   ;
		myColor = "tdLigth";
		if(xmlResult_2[Token][10] == "R"){
			myColor = "tdLigthr";
		}
		xmlResult_2[Token][12] = "N";
		if(NetQty > 0 ) {
		
			xmlResult_2[Token][12] = "O";
			globalvalue = culNum + "@" + NumKeep + "@" + numReorder + "@" + NetQty;
			var xmlfile = Ihref + "/xml/admin/cust_last_supp.xml?database=" + interbase + "&product=" + xmlResult_2[Token][0];
				//alert(xmlfile);
				ajaxLoader(xmlfile,Ihref,63);
		}else{
		printing_out(culNum, NumKeep, numReorder, NetQty);
		}
		
		
}
//--------------------------------------------------------------------
function find_lastsupplier(xhr){
	//alert("work here");
	if(!evt) var evt = window.event;
		var i;
		QTY = 0;
		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 rec = sim.getElementsByTagName('ITEM').item(0);
			xmlResult_2[Token][13] = rec.getElementsByTagName('SUPP')[0].getAttribute("text");
			xmlResult_2[Token][14] = rec.getElementsByTagName('PRICE')[0].getAttribute("text");
		}
		strMe = globalvalue.split("@");
		globalvalue = "";
		printing_out(strMe[0], strMe[1], strMe[2], strMe[3]);
}
//--------------------------------------------------------------------
function printing_out(wculNum, NumKeep, numReorder, NetQty){
	var tbody = document.getElementById("tbl").getElementsByTagName("TBODY")[0];
		var row = document.createElement("TR");
		row.appendChild(bind_td(xmlResult_2[Token][10], myColor, "[" + culNum + "][01]"));
		row.appendChild(bind_td(xmlResult_2[Token][0], myColor, "[" + culNum + "][0]"));
			
		row.appendChild(bind_td(xmlResult_2[Token][2], myColor, "[" + culNum + "][1]"));
		if(myFirstLoc.length == 0 ){
			row.appendChild(bind_td("--", myColor, "[" + culNum + "][2]"));
			row.appendChild(bind_td(0, myColor, "[" + culNum + "][3]"));
		}else{
			row.appendChild(bind_td(myFirstLoc[0][0], myColor, "[" + culNum + "][2]"));
			row.appendChild(bind_td(myFirstLoc[0][1], myColor, "[" + culNum + "][3]"));
		}
	
		row.appendChild(bind_td(xmlResult_2[Token][5], myColor, "[" + culNum + "][4]"));
		row.appendChild(bind_td(NumKeep, myColor, "[" + culNum + "][5]"));
		row.appendChild(bind_td(numReorder, myColor, "[" + culNum + "][6]"));
	
		row.appendChild(bind_td(xmlResult_2[Token][6], myColor, "[" + culNum + "][7]"));	
		row.appendChild(bind_td(Math.ceil(NetQty), myColor, "[" + culNum + "][8]"));
		row.appendChild(bind_td(xmlResult_2[Token][11], myColor, "[" + culNum + "][14]"));
		if(interbase == "YMHQ"){
			
			if(mySecondLoc.length == 0 ){
				row.appendChild(bind_td("--", myColor, "[" + culNum + "][9]"));
				row.appendChild(bind_td(0, myColor, "[" + culNum + "][10]"));
			}else{
				row.appendChild(bind_td(mySecondLoc[0][0], myColor, "[" + culNum + "][9]"));
				row.appendChild(bind_td(mySecondLoc[0][1], myColor, "[" + culNum + "][10]"));
			}
		}
		row.appendChild(bind_td(xmlResult_2[Token][12], myColor, "[" + culNum + "][15]"));
		row.appendChild(bind_td(xmlResult_2[Token][13], myColor, "[" + culNum + "][16]"));
		row.appendChild(bind_td(xmlResult_2[Token][14], myColor, "[" + culNum + "][17]"));
		if(showHQ == true) row.appendChild(bind_td(xmlResult_2[Token][7], myColor, "[" + culNum + "][11]"));
		if(showSGP == true) row.appendChild(bind_td(xmlResult_2[Token][8], myColor, "[" + culNum + "][12]"));
		if(showHK == true) row.appendChild(bind_td(xmlResult_2[Token][9], myColor, "[" + culNum + "][13]"));   
		tbody.appendChild(row);
		culNum++;
		
		for(j = 1; j < numRow; j++){
		
		var row = document.createElement("TR");
		row.appendChild(bind_td("", myColor, "[" + culNum + "][0]"));
		row.appendChild(bind_td("", myColor, "[" + culNum + "][1]"));
		row.appendChild(bind_td("", myColor, "[" + culNum + "][111]"));
		if(myFirstLoc.length <= j ){
			//alert(myFirstLoc.length + " " + j);
			row.appendChild(bind_td("", myColor, "[" + culNum + "][2]"));
			row.appendChild(bind_td("", myColor, "[" + culNum + "][3]"));
		}else{
			
			row.appendChild(bind_td(myFirstLoc[j][0], myColor, "[" + culNum + "][2]"));
			row.appendChild(bind_td(myFirstLoc[j][1],  myColor, "[" + culNum + "][3]"));
		}
		
		row.appendChild(bind_td("", myColor, "[" + culNum + "][4]"));
		row.appendChild(bind_td("", myColor, "[" + culNum + "][5]"));
		row.appendChild(bind_td("", myColor, "[" + culNum + "][6]"));
		row.appendChild(bind_td("", myColor, "[" + culNum + "][7]"));
		row.appendChild(bind_td("", myColor, "[" + culNum + "][8]"));
		if(interbase == "YMHQ"){
			
			if(mySecondLoc.length <= j ){
				row.appendChild(bind_td("", myColor, "[" + culNum + "][9]"));
				row.appendChild(bind_td("", myColor, "[" + culNum + "][10]"));
			}else{
				row.appendChild(bind_td(mySecondLoc[j][0], myColor, "[" + culNum + "][9]"));
				row.appendChild(bind_td(mySecondLoc[j][1], myColor, "[" + culNum + "][10]"));
			}
		}
		row.appendChild(bind_td("", myColor, "[" + culNum + "][15]"));
		row.appendChild(bind_td("", myColor, "[" + culNum + "][16]"));
		row.appendChild(bind_td("", myColor, "[" + culNum + "][17]"));
		if(showHQ == true)row.appendChild(bind_td("", myColor, "[" + culNum + "][11]"));
		if(showSGP == true)row.appendChild(bind_td("", myColor, "[" + culNum + "][12]"));
		if(showHK == true)row.appendChild(bind_td("", myColor, "[" + culNum + "][13]")); 
		tbody.appendChild(row);
		culNum++;
		}
	Token = Token + 1;
	if(Token >= xmlResult_2.length){
		document.getElementById("loadingarea").innerHTML = "[Total Result : 100 %] [Done]"   ;
	}else{
	document.getElementById("loadingarea").innerHTML = "[Total Result : " + Token + "/" + xmlResult_2.length + "] [0]"   ;
	var xmlfile = Ihref + "/xml/admin/productlocation.xml?database=" + interbase + "&product=" + xmlResult_2[Token][0];
	ajaxLoader(xmlfile,Ihref,52);
	}
	return;
}
//--------------------------------------------------------------------
function print_table_column(){
	

		for(i = 0; i < xmlResult.length; i++){
			
			xmlResult_2[xmlResult_2.length] = [	xmlResult[i][0], 
																					xmlResult[i][1],
																					xmlResult[i][2],
																					xmlResult[i][3],
																					xmlResult[i][4],
																					xmlResult[i][5],
																					xmlResult[i][6],
																					xmlResult[i][7],
																					xmlResult[i][8],
																					xmlResult[i][9],
																					"M",
																					i,
																					xmlResult[i][12],
																					xmlResult[i][13],
																					xmlResult[i][14]
																				];
			myProductCode = xmlResult[i][1];
			
			if(xmlResult[i][10].length > 0){
				for(k = 0; k < xmlResult[i][10].length; k++){
					if(xmlResult[i][10][k][0] != "" ){
						
							xmlResult_2[xmlResult_2.length] = [	xmlResult[i][10][k][0], 
																									xmlResult[i][10][k][1],
																									xmlResult[i][10][k][2],
																									xmlResult[i][10][k][3],
																									xmlResult[i][10][k][4],
																									xmlResult[i][10][k][5],
																									xmlResult[i][10][k][6],
																									xmlResult[i][10][k][7],
																									xmlResult[i][10][k][8],
																									xmlResult[i][10][k][9],
																									"R",
																									i,
																									xmlResult[i][12],
																									xmlResult[i][13],
																									xmlResult[i][14]
																									];
					}
				}
			}
		}
	document.getElementById("result").innerHTML = "";
	str = 	"<table border=\"0\" cellpadding=\"2\" cellspacing=\"2\" class=\"frm\" width=\"1200\" id=\"tbl\" name=\"tbl\">" +
					"<tr>" +
					"<td class=\"tdDeep\" width=\"15\">&nbsp;</td>" +
					"<td class=\"tdDeep\">Part Code</td>" +
					"<td class=\"tdDeep\">Sold Qty</td>" +
					"<td class=\"tdDeep\" colspan=\"2\">" + interbase + "</td>" +
					"<td class=\"tdDeep\">Sales in " + SalesDay + " day(s)</td>" +
					"<td class=\"tdDeep\">Keep stock in " + StockDay + " day(s)</td>" +
					"<td class=\"tdDeep\">Propose Order add " + Percentage + "%</td>" +
					"<td class=\"tdDeep\">Back Order QTY</td>" + 
					"<td class=\"tdDeep\">Net Propose Order QTY</td>" + 
					"<td class=\"tdDeep\">Other Sales QTY</td>";
	if(interbase == "YMHQ"){
		str += "<td class=\"tdDeep\" colspan=\"2\">YMFZ</td>";
	}
	str += "<td class=\"tdDeep\">Need Order ?</td>";
	str += "<td class=\"tdDeep\">Last Supplier</td>";
	str += "<td class=\"tdDeep\">Last Purc Price</td>";
	if(showHQ == true) str += "<td class=\"tdDeep\">YMHQ</td>";
	if(showSGP == true) str += "<td class=\"tdDeep\">YMSGP</td>";
	if(showHK == true) str += "<td class=\"tdDeep\">YMHK</td>";   
		
	str +=	"</tr>" +
					"</table>" + 
					"<input type=\"hidden\" name=\"interbase\" value=\"" + interbase + "\">" + 
					"<input type=\"hidden\" name=\"salesday\" value=\"" + SalesDay + "\">" + 
					"<input type=\"hidden\" name=\"stockday\" value=\"" + StockDay + "\">" + 
					"<input type=\"hidden\" name=\"percentage\" value=\"" + Percentage + "\">" + 
					"<input type=\"hidden\" name=\"showHQ\" value=\"" + showHQ + "\">" + 
					"<input type=\"hidden\" name=\"showHK\" value=\"" + showHK + "\">" + 
					"<input type=\"hidden\" name=\"showSGP\" value=\"" + showSGP + "\">" + 
					"<input type=\"submit\" name=\"submitreorder\" value=\"Download Excel File\">";
	document.getElementById("result").innerHTML = str;
	document.getElementById("refreshbutton").innerHTML = "<input type=\"button\" onClick=\"refresh_button();\" value=\"Refresh button\">";
	Token = 0;
	document.getElementById("loadingarea").innerHTML = "[Total Result : " + Token + "/" + xmlResult_2.length + "] [0]"   ;
	
	var xmlfile = Ihref + "/xml/admin/productlocation.xml?database=" + interbase + "&product=" + xmlResult_2[Token][0];
	ajaxLoader(xmlfile,Ihref,52);
}
//--------------------------------------------------------------------
function check_IsNumeric(myId, myName){
	myInput = myId.value;
	if(IsNumeric(myInput) == false){
		alert(myInput + " is not numerical order for " + myName);
		myId.value = 0;
		return;
	}
	return;
}
//--------------------------------------------------------------------
function refresh_button(){
	alert(xmlResult_2[Token][0]);
	var xmlfile = Ihref + "/xml/admin/productlocation.xml?database=" + interbase + "&product=" + xmlResult_2[Token][0];
	ajaxLoader(xmlfile,Ihref,52);
}
//--------------------------------------------------------------------