var MySelectedDebtor = new Array(); var partrecord = new Array(); var finalResult = new Array(); var RowNum = 0; var Rtoken = 0; var display_supplier = false; var show_reorder = false; var show_max = false; var gotAll = false; var show_header = false; var selected_report_type = ''; var rowNumber = 0; //-------------------------------------------------------------------- function SwapOption3(myid,subid,myhref){ var snum = myid.options[myid.selectedIndex].value; //var elSel = document.getElementById(subid); var xmlfile = myhref + "/xml/admin/quotationname.xml?database=" + snum ; //AddSel_Opt(elSel,"All","All"); ajaxLoader(xmlfile,subid,10); } //-------------------------------------------------------------------- function print_debtor_order(myid0, myid,myhref){ var snum = document.getElementById(myid0).options[document.getElementById(myid0).selectedIndex].value; var pkey = document.getElementById("mydebtor").value; var txtProductID = document.getElementById("txtProductID").value; var fromDate = document.getElementById("fromdate").value; var toDate = document.getElementById("todate").value; var reportType = getCheckedValue(document.form1.reportType); var selecteddebtor = ""; if(reportType != "value"){ if(txtProductID.length == 0){ alert("Product ID field is required to generate the selected report!"); return false; } } if(selected_report_type != reportType){ show_header = false; selected_report_type = reportType; } if(show_header == false){ fntshowheader(selected_report_type); show_header = true; } if(pkey == "null"){ pkey = ""; } switch(reportType){ case "value": var xmlfile = myhref + "/xml/admin/quotation_value.xml?database=" + snum + "&fromDate=" + fromDate + "&toDate=" + toDate + "&customer=" + pkey; //alert(xmlfile); ajaxLoader(xmlfile,0,79); break; case "item": var xmlfile = myhref + "/xml/admin/quotation_item.xml?database=" + snum + "&fromDate=" + fromDate + "&toDate=" + toDate + "&productid=" + txtProductID; //alert(xmlfile); ajaxLoader(xmlfile,0,80); break; case "summary": var xmlfile = myhref + "/xml/admin/quotation_summary.xml?database=" + snum + "&fromDate=" + fromDate + "&toDate=" + toDate + "&productid=" + txtProductID + "&customer=" + pkey; //alert(xmlfile); ajaxLoader(xmlfile,0,81); break; break; case "itemsummary": var xmlfile = myhref + "/xml/admin/quotation_itemsummary.xml?database=" + snum + "&fromDate=" + fromDate + "&toDate=" + toDate + "&productid=" + txtProductID + "&customer=" + pkey; //alert(xmlfile); show_header = false; ajaxLoader(xmlfile,0,82); break; break; } } //-------------------------------------------------------------------- var NS4 = (navigator.appName == "Netscape" && parseInt(navigator.appVersion) < 5); //-------------------------------------------------------------------- function quotation_summary_report(xhr,_id){ if(!evt) var evt = window.event; var i; var sims = xhr.responseXML.getElementsByTagName('product'); var sim = sims.item(0); var my_main = sim.getElementsByTagName('ITEM'); for(i = 0; i < my_main.length; i++) { var branch = my_main.item(i).getAttribute("branch"); var productid = my_main.item(i).getAttribute("productid"); var customer = my_main.item(i).getAttribute("customer"); var lastquotationdate = my_main.item(i).getAttribute("lastquotationdate"); var lastquotaionno = my_main.item(i).getAttribute("lastquotaionno"); var unitprice = my_main.item(i).getAttribute("unitprice"); var tbl = document.getElementById("tblResult"); var tblR = document.createElement("tr"); var tblD1 = document.createElement("td"); var tblD2 = document.createElement("td"); var tblD3 = document.createElement("td"); var tblD4 = document.createElement("td"); var tblD5 = document.createElement("td"); var tblD6 = document.createElement("td"); tblD1.innerHTML = branch + ""; tblD1.className = "tdLigth"; tblR.appendChild(tblD1); tblD2.innerHTML = productid + ""; tblD2.className = "tdLigth"; tblR.appendChild(tblD2); tblD3.innerHTML = customer + ""; tblD3.className = "tdLigth"; tblR.appendChild(tblD3); tblD4.innerHTML = lastquotationdate + ""; tblD4.className = "tdLigth"; tblR.appendChild(tblD4); tblD5.innerHTML = lastquotaionno + ""; tblD5.className = "tdLigth"; tblR.appendChild(tblD5); tblD6.innerHTML = unitprice + ""; tblD6.className = "tdLigth"; tblR.appendChild(tblD6); tbl.appendChild(tblR); rowNumber = rowNumber + 1; } } //-------------------------------------------------------------------- function quotation_itemsummary_report(xhr,_id){ if(!evt) var evt = window.event; var i; var sims = xhr.responseXML.getElementsByTagName('product'); var sim = sims.item(0); var my_main = sim.getElementsByTagName('ITEM'); for(i = 0; i < my_main.length; i++) { var branch = my_main.item(i).getAttribute("branch"); var productid = my_main.item(i).getAttribute("productid"); var customer = my_main.item(i).getAttribute("customer"); var lastquotationdate = my_main.item(i).getAttribute("lastquotationdate"); var lastquotaionno = my_main.item(i).getAttribute("lastquotaionno"); var unitprice = my_main.item(i).getAttribute("unitprice"); var status1 = my_main.item(i).getAttribute("status"); var tbl = document.getElementById("tblResult"); var tblR = document.createElement("tr"); var tblD1 = document.createElement("td"); var tblD2 = document.createElement("td"); var tblD3 = document.createElement("td"); var tblD4 = document.createElement("td"); var tblD5 = document.createElement("td"); var tblD6 = document.createElement("td"); tblD1.innerHTML = branch + ""; tblD1.className = "tdLigth"; tblR.appendChild(tblD1); tblD2.innerHTML = customer + ""; tblD2.className = "tdLigth"; tblR.appendChild(tblD2); tblD3.innerHTML = lastquotationdate + ""; tblD3.className = "tdLigth"; tblR.appendChild(tblD3); tblD4.innerHTML = lastquotaionno + ""; tblD4.className = "tdLigth"; tblR.appendChild(tblD4); tblD5.innerHTML = unitprice + ""; tblD5.className = "tdLigth"; tblR.appendChild(tblD5); tblD6.innerHTML = status1 + ""; tblD6.className = "tdLigth"; tblR.appendChild(tblD6); tbl.appendChild(tblR); rowNumber = rowNumber + 1; } var title1 = document.getElementById("title_panel"); var fromDate = document.getElementById("fromdate").value; var toDate = document.getElementById("todate").value; title1.innerHTML = "

PRODUCT ID : " + productid + "
FROM DATE : " + fromDate + "TO DATE:" + toDate + "

" + ""; } //-------------------------------------------------------------------- function quotation_value_report(xhr,_id){ if(!evt) var evt = window.event; var i; var sims = xhr.responseXML.getElementsByTagName('product'); var sim = sims.item(0); var branch = sim.getElementsByTagName('ITEM').item(0).getAttribute("branch"); var totalquote = sim.getElementsByTagName('ITEM').item(0).getAttribute("totalquotevalue"); var totalorder = sim.getElementsByTagName('ITEM').item(0).getAttribute("totalordervalue"); var balance = sim.getElementsByTagName('ITEM').item(0).getAttribute("balance"); var tbl = document.getElementById("tblResult"); var tblR = document.createElement("tr"); var tblD1 = document.createElement("td"); var tblD2 = document.createElement("td"); var tblD3 = document.createElement("td"); var tblD4 = document.createElement("td"); tblD1.innerHTML = branch + ""; tblD1.className = "tdLigth"; tblR.appendChild(tblD1); tblD2.innerHTML = totalquote + ""; tblD2.className = "tdLigth"; tblR.appendChild(tblD2); tblD3.innerHTML = totalorder + ""; tblD3.className = "tdLigth"; tblR.appendChild(tblD3); tblD4.innerHTML = balance + ""; tblD4.className = "tdLigth"; tblR.appendChild(tblD4); tbl.appendChild(tblR); rowNumber = rowNumber + 1; } //-------------------------------------------------------------------- function quotation_item_report(xhr,_id){ if(!evt) var evt = window.event; var i; var sims = xhr.responseXML.getElementsByTagName('product'); var sim = sims.item(0); var branch = sim.getElementsByTagName('ITEM').item(0).getAttribute("branch"); var productid = sim.getElementsByTagName('ITEM').item(0).getAttribute("productid"); var totalquote = sim.getElementsByTagName('ITEM').item(0).getAttribute("totalquoteqty"); var totalorder = sim.getElementsByTagName('ITEM').item(0).getAttribute("totalorderqty"); var balance = sim.getElementsByTagName('ITEM').item(0).getAttribute("balance"); var tbl = document.getElementById("tblResult"); var tblR = document.createElement("tr"); var tblD1 = document.createElement("td"); var tblD2 = document.createElement("td"); var tblD3 = document.createElement("td"); var tblD4 = document.createElement("td"); var tblD5 = document.createElement("td"); tblD1.innerHTML = branch + ""; tblD1.className = "tdLigth"; tblR.appendChild(tblD1); tblD2.innerHTML = productid + ""; tblD2.className = "tdLigth"; tblR.appendChild(tblD2); tblD3.innerHTML = totalquote + ""; tblD3.className = "tdLigth"; tblR.appendChild(tblD3); tblD4.innerHTML = totalorder + ""; tblD4.className = "tdLigth"; tblR.appendChild(tblD4); tblD5.innerHTML = balance + ""; tblD5.className = "tdLigth"; tblR.appendChild(tblD5); tbl.appendChild(tblR); rowNumber = rowNumber + 1; } //-------------------------------------------------------------------- function fntshowheader(rptType){ var panel = document.getElementById("result_panel"); var tbl = document.createElement("table"); var tblR = document.createElement("tr"); rowNumber = 0; panel.innerHTML = ""; tbl.id = "tblResult"; tbl.width = "800px;"; switch(rptType){ case "value": var tblH1 = document.createElement("th"); var tblH2 = document.createElement("th"); var tblH3 = document.createElement("th"); var tblH4 = document.createElement("th"); tblH1.innerHTML = "Branch"; tblH1.className = "tdDeep"; tblR.appendChild(tblH1); tblH2.innerHTML = "Total Quote Value"; tblH2.className = "tdDeep"; tblR.appendChild(tblH2); tblH3.innerHTML = "Total Order Value"; tblH3.className = "tdDeep"; tblR.appendChild(tblH3); tblH4.innerHTML = "Balance"; tblH4.className = "tdDeep"; tblR.appendChild(tblH4); break; case "item": var tblH1 = document.createElement("th"); var tblH2 = document.createElement("th"); var tblH3 = document.createElement("th"); var tblH4 = document.createElement("th"); var tblH5 = document.createElement("th"); tblH1.innerHTML = "Branch"; tblH1.className = "tdDeep"; tblR.appendChild(tblH1); tblH2.innerHTML = "Product ID"; tblH2.className = "tdDeep"; tblR.appendChild(tblH2); tblH3.innerHTML = "Total Quote Qty"; tblH3.className = "tdDeep"; tblR.appendChild(tblH3); tblH4.innerHTML = "Total Order Qty"; tblH4.className = "tdDeep"; tblR.appendChild(tblH4); tblH5.innerHTML = "Balance"; tblH5.className = "tdDeep"; tblR.appendChild(tblH5); break; case "summary": var tblH1 = document.createElement("th"); var tblH2 = document.createElement("th"); var tblH3 = document.createElement("th"); var tblH4 = document.createElement("th"); var tblH5 = document.createElement("th"); var tblH6 = document.createElement("th"); tblH1.innerHTML = "Branch"; tblH1.className = "tdDeep"; tblR.appendChild(tblH1); tblH2.innerHTML = "Product ID"; tblH2.className = "tdDeep"; tblR.appendChild(tblH2); tblH3.innerHTML = "Customer Name"; tblH3.className = "tdDeep"; tblR.appendChild(tblH3); tblH4.innerHTML = "Last Quotation Date"; tblH4.className = "tdDeep"; tblR.appendChild(tblH4); tblH5.innerHTML = "Quotation No."; tblH5.className = "tdDeep"; tblR.appendChild(tblH5); tblH6.innerHTML = "Quote Price (per item)"; tblH6.className = "tdDeep"; tblR.appendChild(tblH6); break; case "itemsummary": var tblH1 = document.createElement("th"); var tblH2 = document.createElement("th"); var tblH3 = document.createElement("th"); var tblH4 = document.createElement("th"); var tblH5 = document.createElement("th"); var tblH6 = document.createElement("th"); tblH1.innerHTML = "Branch"; tblH1.className = "tdDeep"; tblR.appendChild(tblH1); tblH2.innerHTML = "Customer Name"; tblH2.className = "tdDeep"; tblR.appendChild(tblH2); tblH3.innerHTML = "Last Quotation Date"; tblH3.className = "tdDeep"; tblR.appendChild(tblH3); tblH4.innerHTML = "Quotation No."; tblH4.className = "tdDeep"; tblR.appendChild(tblH4); tblH5.innerHTML = "Quote Price (per item)"; tblH5.className = "tdDeep"; tblR.appendChild(tblH5); tblH6.innerHTML = "Status"; tblH6.className = "tdDeep"; tblR.appendChild(tblH6); break; } tbl.appendChild(tblR); panel.appendChild(tbl); rowNumber = rowNumber + 1; } //-------------------------------------------------------------------- function getCheckedValue(radioObj) { if(!radioObj) return ""; var radioLength = radioObj.length; if(radioLength == undefined) if(radioObj.checked) return radioObj.value; else return ""; for(var i = 0; i < radioLength; i++) { if(radioObj[i].checked) { return radioObj[i].value; } } return ""; } //--------------------------------------------------------------------