<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD><TITLE></TITLE>
<META http-equiv=CONTENT-TYPE content="text/html; charset=windows-1252">
<META content="MSHTML 6.00.2800.1106" name=GENERATOR>
<META content=0;0 name=CREATED>
<META content=20080425;15574767 name=CHANGED></HEAD>
<BODY lang=en-US dir=ltr bgColor=#ccff99>
<H2 align=center>MRPRO-Compositions, Communications, Footprints and Obsolescence
Management</H2>
<H4 align=center>Version 5.1 sub Dec 2015</H4>
<H6 align=center>2013 Copyright Papros Inc.- Protected by USA and International
copyright laws</H6>
<FORM name=thisform action=../mrp51>
<DIV align=center>
<P> Search information in supplier responses in XML database <P>
<P> To know if the program has read your data, in general, you must be able to see a Supplier name at least for the declaration being searched. </P>

<div align=left id="content"></div>


<script src="jquery.js" type="text/javascript"></script>
<script type="text/javascript">
var tsrchl;
var mams;
var tdclevl="";
var metl;
var quth;
var exemlid;
var exemlidauth;
var subexidauth;
var subexid;
var subamtuom;
var subamt;
var subsidauth;
var subsid;
var subcat;
var sucatlistid;
var hlatnam;
var hlynam;
var hlyruom;
var hlyruom;
var prodamt;
var produom;
var subpamt;
var subpuom;
var subconc;
var exems;
var hlyrusd;
//spemams
for (var i=0; i<1;i++){

$(document).ready(function(){

function parse(document){

  $(document).find("MainDeclaration").each(function(){
 mams=0;
 $("#content").append(
	'</table><P></P><P ALIGN=left>-----------Searching new declaration---- '+
	'</P>'
	);

 //   var tmplat=$(this).find("FormsInfo").attr('eiccTemplateVersion');
 //   var scmplat=$(this).find("FormsInfo").attr('schemaVersion');

  $("#content").append("<table>");
   $(this).find("BusinessInfo").each(function(){
 // alert("kla");
 //  tsrchl=$(this).find("Response").attr('comments').toLowerCase();
  tsrchl=$(this).find("Response").attr('comments');
// alert("kla1");
mams=1;
if (mams==1) {
//   alert("kla1");
    $("#content").append(
	'<TR ALIGN=left border="1" BGCOLOR=#ffffff ><span><tr><th BGCOLOR=#ccff99>Supplier name:<td BGCOLOR=#ffffff>'+$(this).find("SupplyCompany").attr('name')+
        '</td><th BGCOLOR=#ccff99> Dated:<td BGCOLOR=#ffffff>'+$(this).find("Response").attr('date')+
	'</td><th BGCOLOR=#ccff99>ID:<td BGCOLOR=#ffffff>'+$(this).find("CompanyID").attr('identity')+
        '</td><th BGCOLOR=#ccff99>Contact name:<td BGCOLOR=#ffffff>'+$(this).find("Contact").attr('name')+
        '</td><th BGCOLOR=#ccff99>Contact title:<td BGCOLOR=#ffffff>'+$(this).find("Contact").attr('title')+
        '</td><th BGCOLOR=#ccff99>Contact email:<td BGCOLOR=#ffffff>'+$(this).find("Email").attr('address')+
        '</td><th BGCOLOR=#ccff99>Contact phone:<td BGCOLOR=#ffffff>'+$(this).find("Phone").attr('number')+
        '</td><th BGCOLOR=#ccff99>Contact address:<td BGCOLOR=#ffffff>'+$(this).find("SurfaceAddress").attr('street')+
	'</td>'
	);
              }       //mams=1
//       tsrchl=$(this).find("Response").attr('comments').toLowerCase();
//alert(tsrchl);
//   $("#content").append('</tr></Table>');
$("#content").append('</table><P>');
  });                             //businessinfo
// alert("kla");
   $(this).find("Product").each(function(){
$("#content").append('<B><U>List of ProductIDs and the Declaration that applies to them</U></B>');
$("#content").append('<P>');
$("#content").append("<table>");
// $("#content").append("<table><tr><th>Item Dec Class</th><th>Prod Item Name</th><th>Prod Item Nbr</th><th>Prod Eff Date</th><th>Item Dec Class</th>
//<th>No. of Column(s)</th>
//</tr>
  $(this).find("ProductID").each(function(){
var bodhi=$(this).parent().get( 0 ).tagName;
//
if (bodhi!='SubProduct') {

 produom=$(this).find("Amount").attr('UOM');
 prodamt=$(this).find("Amount").attr('value');

//
    $("#content").append(
	'<TR ALIGN=left border="1" BGCOLOR=#ffffff ><tr><th width =50 BGCOLOR=#ccff99>Prod itemname:<td width =50 BGCOLOR=#ffffff>'+$(this).attr('itemName')+

        '</td><th width =50 BGCOLOR=#ccff99>Prod itemnumber:<td width =100 BGCOLOR=#ffffff>'+$(this).attr('itemNumber')+
        '</td><th width =50 BGCOLOR=#ccff99>Prod effective date:<td width =50 BGCOLOR=#ffffff>'+$(this).attr('effectiveDate')+
        '</td><th width =50 BGCOLOR=#ccff99>Prod requester itemname:<td width =50 BGCOLOR=#ffffff>'+$(this).attr('requesterItemName')+
        '</td><th width =50 BGCOLOR=#ccff99>Prod requester itemnumber:<td width =50 BGCOLOR=#ffffff>'+$(this).attr('requesterItemNumber')+
        '</td><th width =50 BGCOLOR=#ccff99>Prod version:<td width =50 BGCOLOR=#ffffff>'+$(this).attr('version')+
        '</td><th width =50 BGCOLOR=#ccff99>Prod amount:<td width =50 BGCOLOR=#ffffff>'+prodamt+
        '</td><th width =50 BGCOLOR=#ccff99>Prod amnt UOM:<td width =50 BGCOLOR=#ffffff>'+produom+
	'</td>'
	);
}  //bodhi IF
 //$("#content").append('</tr></Table>');
$("#content").append('</table><P>');
    });    //productid
$("#content").append('<table><P>');
$(this).find("InstanceID").each(function(){
$("#content").append(
	'<Table ALIGN=left border="1" BGCOLOR=#ffffff ><span><tr><th BGCOLOR=#ccff99>Instance ID:<td BGCOLOR=#ffffff>'+$(this).attr('identity')+
        '</td><th BGCOLOR=#ccff99>Instance ID authority:<td BGCOLOR=#ffffff>'+$(this).attr('authority')+
	'</td>'
	);
   });    //instanceid
//$("#content").append('<P></P><P>');
$("#content").append('</tr></table><P></P><table></table>                                             ');
$("#content").append('<P></P><P></P>');
//$("#content").append('<NL>');
 //      //product
//
 $("#content").append('<table></table><B><U>Queries (If no queries are listed below, then no queries were found in the declaration)</U></B><P></P>');
 $("#content").append("<table>");
  $(this).find("MaterialInfo").each(function(){

  $(this).find("QueryList").each(function(){
  metl=$(this).attr('identity');
  quth=$(this).attr('authority');
 $("#content").append('</P><P>');
  $(this).find("Query").each(function(){
  $("#content").append('<P>');

  $("#content").append(
	'<TR ALIGN=left border="1" BGCOLOR=#ffffff ><span><tr><th width =50 BGCOLOR=#ccff99>Querylist ID:<td width =100 BGCOLOR=#ffffff>'+metl+
        '</td><th BGCOLOR=#ccff99>Query ID Authority:<td width =100 BGCOLOR=#ffffff>'+quth+
        '</td><th BGCOLOR=#ccff99>Query Statement:<td width =100 BGCOLOR=#ffffff>'+$(this).attr('statement')+
        '</td><th BGCOLOR=#ccff99>Query Response:<td width =100 BGCOLOR=#ffffff>'+$(this).attr('response')+

	'</td>'
	);
 // $("#content").append('</tr></Table>');
 $("#content").append('<P>');
   });    //Query
   });    //Querylist
   });    //MaterialInfo
 $("#content").append('</table><P>');
// #ffff99 is orangish yellow
 $("#content").append('<table><B><U>Sub products (if no gray rows of data are present, no sub products were listed for this product); if any data fields are either not present or "undefined" it means those fields were either not entered or there is a white space entry)</U></B>');
  var fodhi=0;


if (fodhi!=1) {
 //

//
//
  $(this).find("MaterialInfo").each(function(){

 

$(this).find("SubstanceCategoryList").each(function(){
  var thamparent=$(this).parent().get( 0 ).tagName;
 // alert(thamparent);
  if (thamparent!='HomogeneousMaterial') {
  $(this).find("SubstanceCategoryListID").each(function(){
  sucatlistid=$(this).attr('identity');
  sucatlistau=$(this).attr('authority');
  $("#content").append(
	'<tr ALIGN=left border="1" BGCOLOR=#ffffff ><span><tr><th BGCOLOR=#C0C0C0>Substance Category List ID:<td BGCOLOR=#ffffff>'+sucatlistid+
        '</td><th BGCOLOR=#C0C0C0>Substance Category List ID authority:<td BGCOLOR=#ffffff>'+sucatlistau+
	'</tr>'
	);
  });
    $(this).find("SubstanceCategory").each(function(){
   subcat=$(this).attr('name');
 //
 $(this).find("Threshold").each(function(){
  thresh=$(this).attr('threshold');
  othre=$(this).attr('overThreshold');
//
 exems="";
 $(this).find("SubstanceCatExemptionList").each(function(){
 $(this).find("ExemptionListID").each(function(){
 subexid=$(this).attr('identity');
 subexidauth=$(this).attr('authority');
       });    //ExemptionListID
 $(this).find("Exemption").each(function(){

//$("#content").append(

  exems= exems+('</td><th width=50 BGCOLOR=#ADD8E6>Substance Cat Exemption List ID:<td width=50 BGCOLOR=#ffffff> '+subexid+
        '</td><th width=50 BGCOLOR=#ADD8E6>Substance Cat Exemption List Authority:<td width=50 BGCOLOR=#ffffff> '+subexidauth+
        '</td><th width=50 BGCOLOR=#ADD8E6>Substance Cat Exemption ID:<td width=50 BGCOLOR=#ffffff> '+$(this).attr('identity')+
        '</td><th width=50 BGCOLOR=#ADD8E6>Substance Cat Exemption Description:<td width=50 BGCOLOR=#ffffff> '+$(this).attr('description')+
        '</td>'
	 );


       });    //SubstanceCatExemption


   });    //SubstanceCatExemptionList
 // exems='';
 
 $("#content").append(
	'<TR ALIGN=left border="1" BGCOLOR=#ffffff ><td><th width=50 BGCOLOR=#ADD8E6>Substance Category name:<td width=50 BGCOLOR=#ffffff> '+subcat+
	    '</td><th width=50 BGCOLOR=#ADD8E6>Threshold:<td width=50 BGCOLOR=#ffffff> '+thresh+
        '</td><th width=50 BGCOLOR=#ADD8E6>Over Threshold:<td width=50 BGCOLOR=#ffffff> '+othre+
         exems
	 );

//
  });
  
  });    //SubstanceCategory
  }
      });    //SubstanceCategoryList
  


//$("#content").append('<B>End Smelter List for the listed metal (if no blue rows of data are present, no smelters were listed for this metal; if any data fields such as mine name or mine country are either not present or "undefined" it means those fields were either not entered or a white space entry)</B>');
$("#content").append('<P>');
//
//   $("#content").append('</tr></Table>');
//   $("#content").append('<P>');
  
 $("#content").append("</table></P>");
//

   });    //Materialinfo

   }   //fodhi ne1

//no subprod


   });      // product
//alert(tsrchl);
//
    $("#content").append('<P></P><P>');
 });      // mat dec
  $("#content").append("<table>");
$("#content").append('<B><U>Top Product Level Exemption List (If no exemptions are listed below, then there were no product level exemptions listed in the declaration)</U></B><P>');
$(document).find("ExemptionList").each(function(){
  exemlid=$(this).find("ExemptionListID").attr('identity');
  exemlidauth=$(this).find("ExemptionListID").attr('authority');
  $(this).find("Exemption").each(function(){
 $("#content").append(
	'<tr ALIGN=left border="1" BGCOLOR=#ffffff ><span><td><th width=50 BGCOLOR=#ccff99>Exemption List ID:<td width=50 BGCOLOR=#ffffff>'+exemlid+
        '<span></td><th width=50 BGCOLOR=#ccff99>Exemption List authority:<td BGCOLOR=#ffffff>'+exemlidauth+
        '<span></td><th width=50 BGCOLOR=#ccff99>Exemption ID:<td BGCOLOR=#ffffff>'+$(this).attr('identity')+
        '<span></td><th BGCOLOR=#ccff99>Exemption Description:<td BGCOLOR=#ffffff>'+$(this).attr('description')+

	'</td>'
	);
$("#content").append('<P>');
 });                               //Exemption

//  $("#content").append('</tr></Table>');
 $("#content").append("</table></P>");
//alert(mams);
   });                               //Exemptionlist
   $("#content").append("End of data");
}


//sups1235-if (j==1) {smestuff="examp1332-07-6";}
//supe1235
  $.ajax({
    url: "puetits",
    dataType: "xml",
    async: false,
    success: parse,
	error: function(){alert("Error opening file - puetits");}
  });

//supc1235
});


}
</script>
<BR><BR></P></BODY></HTML>
