TECHNICAL GUIDE: XML with Jquey HTML

Example:

XML FILE CODE:

<?xml version="1.0" encoding="UTF-8"?>
-<root> -<hc modid="1" contentname="Security" contentcd="SEC"> <hs subcontentname="Location Master" subcontentcd="LOC"/> <hs subcontentname="Organization" subcontentcd="ORG"/> <hs subcontentname="Printer Location Mapping" subcontentcd="PLOC"/> <hs subcontentname="Printer Location Report Mapping" subcontentcd="PLR"/> <hs subcontentname="Roles" subcontentcd="Roles"/> <hs subcontentname="Field Role Security" subcontentcd="SFRS"/> <hs subcontentname="User Management Summary" subcontentcd="UMS"/> <hs subcontentname="User Printer Settings" subcontentcd="UPS"/> <hs subcontentname="Users" subcontentcd="User"/> </hc> -<hc modid="2" contentname="Denied Party Screening" contentcd="DPS"> <hs subcontentname="DPSSearch" subcontentcd="DPSEA"/> <hs subcontentname="DPSSettings" subcontentcd="DPSET"/> <hs subcontentname="Saved Srch Data" subcontentcd="DPSSSD"/> <hs subcontentname="Stop Words" subcontentcd="DPSSW"/> </hc> -<hc modid="3" contentname="Vendor Management System" contentcd="VMS"> <hs subcontentname="Solicitation Request Rating" subcontentcd="QSRE"/> <hs subcontentname="Solicitation Response" subcontentcd="SOLRSP"/> <hs subcontentname="Solicitation Status" subcontentcd="SOLSTAT"/> <hs subcontentname="Question Master" subcontentcd="VMS_QSTMST"/> </hc> -<hc modid="5" contentname="Master" contentcd="MST"> <hs subcontentname="Address Details" subcontentcd="AAR"/> <hs subcontentname="ADD Case Numbers" subcontentcd="ACN"/> <hs subcontentname="Ad Hoc Group Summary" subcontentcd="ADHCGS"/> <hs subcontentname="AD HOC Report Creation" subcontentcd="ADHCRT"/> <hs subcontentname="ADH Group" subcontentcd="ADHGRP"/> <hs subcontentname="Ad Hoc Report Create" subcontentcd="ADHRPTCT"/> <hs subcontentname="AD HOC Summary" subcontentcd="ADHSUM"/> <hs subcontentname="Booking Party Master" subcontentcd="BKPM"/> <hs subcontentname="Bill To PartyMaster" subcontentcd="BTPM"/> <hs subcontentname="Carriers" subcontentcd="CARM"/> <hs subcontentname="Company Logo" subcontentcd="CMP_LOGO"/> <hs subcontentname="Company Defaults" subcontentcd="CMPDE"/> <hs subcontentname="Company Transmission history" subcontentcd="CMPTH"/> <hs subcontentname="Related Companies" subcontentcd="CMREM"/> <hs subcontentname="Company Supplier relationship" subcontentcd="CMSUR"/> <hs subcontentname="Comments on Code" subcontentcd="COC"/> <hs subcontentname="Entry Template" subcontentcd="CRTEM"/> <hs subcontentname="Countries" subcontentcd="CS"/> <hs subcontentname="Customer Settings" subcontentcd="CSET"/> <hs subcontentname="Consolidator" subcontentcd="CSLM"/> <hs subcontentname="CSMS Message" subcontentcd="CSMS"/> <hs subcontentname="Department Defaults" subcontentcd="DEPDE"/> <hs subcontentname="Department Master" subcontentcd="DEPT"/> <hs subcontentname="Department Logo" subcontentcd="DEPT_LOGO"/> <hs subcontentname="Dom Ports" subcontentcd="DPORTS"/> <hs subcontentname="Entities" subcontentcd="Ent"/> <hs subcontentname="ScheduleB" subcontentcd="EXPSCB"/> <hs subcontentname="Exchange Rates" subcontentcd="EXRS"/> <hs subcontentname="FDA Compliances" subcontentcd="FDAC"/> <hs subcontentname="FDAProducts" subcontentcd="FDAP"/> <hs subcontentname="Flex Captions" subcontentcd="FFS"/> <hs subcontentname="Firms" subcontentcd="FIRMS"/> <hs subcontentname="Foreign Ports" subcontentcd="FP"/> <hs subcontentname="GTK Data Feature" subcontentcd="GDF"/> <hs subcontentname="Create Dynamic Report" subcontentcd="GDR"/> <hs subcontentname="Group Master" subcontentcd="GMST"/> <hs subcontentname="Gold Prices" subcontentcd="GP"/> <hs subcontentname="Adhoc Reports" subcontentcd="GRT"/> <hs subcontentname="GTK dashBoard Tasks" subcontentcd="GTKDBTASK"/> <hs subcontentname="Customs Holidays" subcontentcd="HDAY"/> <hs subcontentname="HTS Master" subcontentcd="HTS"/> <hs subcontentname="ImportCodes" subcontentcd="IC"/> <hs subcontentname="ImportCodeMaster" subcontentcd="ICM"/> <hs subcontentname="ISFImporters" subcontentcd="ISFIMP"/> <hs subcontentname="ISFManufacturers" subcontentcd="ISFMF"/> <hs subcontentname="Org Logo" subcontentcd="LOGO"/> <hs subcontentname="Master File Settings" subcontentcd="MFS"/> <hs subcontentname="Mode OF Transport" subcontentcd="MOT"/> <hs subcontentname="Company Billing XREF" subcontentcd="MSTCBX"/> <hs subcontentname="Company Master RD" subcontentcd="MSTCMPMST"/> <hs subcontentname="Company Summary" subcontentcd="MSTCMPS"/> <hs subcontentname="Reports" subcontentcd="MSTREPS"/> <hs subcontentname="NDES" subcontentcd="NDES"/> <hs subcontentname="Org ABI Settings" subcontentcd="OABIS"/> <hs subcontentname="Org AES Settings" subcontentcd="OAES"/> <hs subcontentname="Org Data Maintanence" subcontentcd="ODM"/> <hs subcontentname="Org Importer settings & Defaults" subcontentcd="OIMP"/> <hs subcontentname="Org Indicator Settings" subcontentcd="OIS"/> <hs subcontentname="Org Port Settings" subcontentcd="OPS"/> <hs subcontentname="Organization Details" subcontentcd="ORGDETL"/> <hs subcontentname="Party Master" subcontentcd="PTY"/> <hs subcontentname="Party Type" subcontentcd="PTYP"/> <hs subcontentname="Party Settings" subcontentcd="PTYSET"/> <hs subcontentname="Show Regulatory Documents" subcontentcd="RegDoc"/> <hs subcontentname="Standard Remarks" subcontentcd="REMARKS"/> <hs subcontentname="Ruling Numbers" subcontentcd="RUL"/> <hs subcontentname="Rules" subcontentcd="RULES"/> <hs subcontentname="Company Contacts" subcontentcd="SCC"/> <hs subcontentname="Company Master" subcontentcd="SCM"/> <hs subcontentname="Company Notes" subcontentcd="SCN"/> <hs subcontentname="Signature Upload" subcontentcd="SIGNUPD"/> <hs subcontentname="Stuffing Location" subcontentcd="SLM"/> <hs subcontentname="Organization Master" subcontentcd="SOM"/> <hs subcontentname="Request User" subcontentcd="SRU"/> <hs subcontentname="Supplier Settings" subcontentcd="SSET"/> <hs subcontentname="Ship To Party Master" subcontentcd="STPM"/> <hs subcontentname="CTPAT" subcontentcd="SVCTPAT"/> <hs subcontentname="Vendor Defaults" subcontentcd="SVD"/> <hs subcontentname="Vendor Master" subcontentcd="SVM"/> <hs subcontentname="Vendor Notes" subcontentcd="SVN"/> <hs subcontentname="Work Flow" subcontentcd="SWF"/> <hs subcontentname="TestReport" subcontentcd="TRPT"/> <hs subcontentname="TestRport" subcontentcd="TSTRPT"/> <hs subcontentname="Unit of Measure" subcontentcd="UOM"/> <hs subcontentname="User Settings" subcontentcd="USRSET"/> </hc> -<hc modid="7" contentname="Imports" contentcd="IMP"> <hs subcontentname="3461 ALT" subcontentcd="3461ALT"/> <hs subcontentname="3461/Immediate Delivery" subcontentcd="3461ID"/> <hs subcontentname="7501 Entry Summary" subcontentcd="7501ES"/> <hs subcontentname="7512 Document" subcontentcd="7512D"/> <hs subcontentname="ACS Responses" subcontentcd="ACSRES"/> <hs subcontentname="AirINBOND Transimission" subcontentcd="AIRINBND"/> <hs subcontentname="Customs Invoice" subcontentcd="CIV"/> <hs subcontentname="ClassificationEntry OtherInfo" subcontentcd="CLSENTINFO"/> <hs subcontentname="Classification Entry" subcontentcd="CLSENTRY"/> <hs subcontentname="Data Exchange Status" subcontentcd="DES"/> <hs subcontentname="Delivery Order Report" subcontentcd="DOREP"/> <hs subcontentname="Delivery Orders" subcontentcd="DOS"/> <hs subcontentname="Delivery Tracking" subcontentcd="DT"/> <hs subcontentname="Entry Create" subcontentcd="EC"/> <hs subcontentname="Entry Invoice" subcontentcd="EIM"/> <hs subcontentname="Entry Invoice Other Info" subcontentcd="EIOI"/> <hs subcontentname="Entry Merge" subcontentcd="EM"/> <hs subcontentname="Entry Reports" subcontentcd="ENTREPS"/> <hs subcontentname="Shipment Tracking" subcontentcd="ENTRK"/> <hs subcontentname="Entry Summary" subcontentcd="EntrySum"/> <hs subcontentname="Entry Query Response" subcontentcd="EQR"/> <hs subcontentname="Entry Results" subcontentcd="ERS"/> <hs subcontentname="File Status Change" subcontentcd="FSC"/> <hs subcontentname="Invoice Line Details" subcontentcd="ILD"/> <hs subcontentname="Entry DashBoard" subcontentcd="IMPENTDB"/> <hs subcontentname="Entry Tracking" subcontentcd="IMPEntTrck"/> <hs subcontentname="Group Invoice to Entry" subcontentcd="IMPGIE"/> <hs subcontentname="Invoice Halt Report" subcontentcd="IMPIHR"/> <hs subcontentname="ACE Manual Entry" subcontentcd="IMPMNENR"/> <hs subcontentname="ImpPartmasterdtl" subcontentcd="IMPPRTDT"/> <hs subcontentname="Importer Partmaster" subcontentcd="IMPPRTMST"/> <hs subcontentname="Inbond QP" subcontentcd="IQP"/> <hs subcontentname="InBond QP Report" subcontentcd="IQPR"/> <hs subcontentname="Liquidations" subcontentcd="LIQ"/> <hs subcontentname="Manual Entry" subcontentcd="MANEN"/> <hs subcontentname="Multiple Document Printing" subcontentcd="MDP"/> <hs subcontentname="Manage Reports" subcontentcd="MNGREPS"/> <hs subcontentname="Profit Center" subcontentcd="PC"/> <hs subcontentname="Process Entries" subcontentcd="PE"/> <hs subcontentname="ADD/CVD Query" subcontentcd="QADDCVD"/> <hs subcontentname="Entry Summary/Cargo Release" subcontentcd="QESCR"/> <hs subcontentname="Query HTS Harmonized Tarrif" subcontentcd="QHTS"/> <hs subcontentname="Importers Query" subcontentcd="QIMP"/> <hs subcontentname="Query MID" subcontentcd="QMID"/> <hs subcontentname="OGA Query" subcontentcd="QOGA"/> <hs subcontentname="Extract Refrence Files" subcontentcd="QRF"/> <hs subcontentname="Statemnent/ACH Reroute" subcontentcd="QSACH"/> <hs subcontentname="Quota Visa Details" subcontentcd="QVD"/> <hs subcontentname="QuotaVisaQuery" subcontentcd="QVQ"/> <hs subcontentname="Entry Invoice Other Info" subcontentcd="RDEIOI"/> <hs subcontentname="Statements" subcontentcd="STA"/> <hs subcontentname="ACH" subcontentcd="TACH"/> <hs subcontentname="Automated Invoice Interface" subcontentcd="TAII"/> <hs subcontentname="Entry Transmissions" subcontentcd="TCR"/> <hs subcontentname="Entry Summary" subcontentcd="TES"/> <hs subcontentname="Entry Summary Delete" subcontentcd="TESD"/> <hs subcontentname="FDA Prior Notice" subcontentcd="TFDAPN"/> <hs subcontentname="View Exceptions" subcontentcd="TGBE"/> <hs subcontentname="Importers" subcontentcd="TI5106"/> <hs subcontentname="InBond QP Notification" subcontentcd="TIQPN"/> <hs subcontentname="Manufacturer Update" subcontentcd="TMU"/> <hs subcontentname="OGA Retransmission/T.I.B" subcontentcd="TOGATIB"/> <hs subcontentname="Statement Mini Delete" subcontentcd="TSMD"/> <hs subcontentname="User Statistics" subcontentcd="USS"/> </hc> -<hc modid="9" contentname="Exports" contentcd="EXP"> <hs subcontentname="Company EDI" subcontentcd="CEDI"/> <hs subcontentname="Data Exchange Status" subcontentcd="EDES"/> <hs subcontentname="Commercial Invoice Report" subcontentcd="EXPCIR"/> <hs subcontentname="Customer Master" subcontentcd="EXPCUST"/> <hs subcontentname="Export Information Codes" subcontentcd="EXPEXINF"/> <hs subcontentname="Freight Terms" subcontentcd="EXPFRTRM"/> <hs subcontentname="Inbond Types" subcontentcd="EXPINBND"/> <hs subcontentname="License Codes" subcontentcd="EXPLICEN"/> <hs subcontentname="Payment Terms" subcontentcd="EXPPYTRM"/> <hs subcontentname="Shipment" subcontentcd="EXPS"/> <hs subcontentname="Multiple Document Printing" subcontentcd="EXPS"/> <hs subcontentname="Sales Order" subcontentcd="EXPSO"/> <hs subcontentname="Sales Order Summary" subcontentcd="EXPSOSUM"/> <hs subcontentname="Shipment Transmit" subcontentcd="EXPST"/> <hs subcontentname="Trade Terms" subcontentcd="EXPTRADE"/> <hs subcontentname="Shipment Summary" subcontentcd="ShipSum"/> </hc> -<hc modid="10" contentname="Pre Entry" contentcd="PRENT"> <hs subcontentname="Commercial Invoice" subcontentcd="CMIS"/> <hs subcontentname="Invoice Report" subcontentcd="INVREPPRNT"/> <hs subcontentname="Invoice Summary" subcontentcd="INVSUM"/> <hs subcontentname="Invoice Transmit" subcontentcd="INVTRANS"/> <hs subcontentname="Manifest Inquiry" subcontentcd="MAI"/> <hs subcontentname="Pre Invoice Entry" subcontentcd="PEI"/> <hs subcontentname="Purchase Order" subcontentcd="PO"/> <hs subcontentname="PO Summary" subcontentcd="POSUMMARY"/> </hc> -<hc modid="11" contentname="Parts" contentcd="PRTS"> <hs subcontentname="Classification Help" subcontentcd="PARTCSH"/> <hs subcontentname="Part Classification Process" subcontentcd="PCP"/> <hs subcontentname="Part Category" subcontentcd="PRTCTG"/> <hs subcontentname="Part CategoryDetails" subcontentcd="PRTCTGDTLS"/> <hs subcontentname="Part DashBoard" subcontentcd="PRTDB"/> <hs subcontentname="UpdatePartDetails" subcontentcd="PRTDU"/> <hs subcontentname="Material Code" subcontentcd="PRTMATCD"/> <hs subcontentname="Material Class" subcontentcd="PRTMATCLS"/> <hs subcontentname="Part Master" subcontentcd="PRTMST"/> <hs subcontentname="Part Master Details" subcontentcd="PRTMSTDT"/> </hc> -<hc modid="12" contentname="Accounting" contentcd="ACNTG"> <hs subcontentname="Billing Codes" subcontentcd="BILCODES"/> <hs subcontentname="Billing InvEntries" subcontentcd="BILINVENT"/> <hs subcontentname="Cash Entries" subcontentcd="CASHENT"/> <hs subcontentname="Check Entries" subcontentcd="CHKENT"/> <hs subcontentname="Check Printing" subcontentcd="CHKPRNT"/> <hs subcontentname="Check Register" subcontentcd="CHKREG"/> <hs subcontentname="DutyFees Transfer" subcontentcd="DTYFEES"/> <hs subcontentname="Global Bill Codes" subcontentcd="GBC"/> <hs subcontentname="Importer Billing" subcontentcd="IMPBIL"/> <hs subcontentname="Invoice Print" subcontentcd="INVPRNT"/> <hs subcontentname="Invoice Register" subcontentcd="INVREP"/> <hs subcontentname="Payout Changes" subcontentcd="PAYCHNG"/> </hc> -<hc modid="13" contentname="Free Trade Agreements" contentcd="TA"> <hs subcontentname="Costed BOM" subcontentcd="CBOM"/> <hs subcontentname="Data Copy" subcontentcd="CF"/> <hs subcontentname="Costed BOM" subcontentcd="COBOM"/> <hs subcontentname="Customer" subcontentcd="CUSGPM"/> <hs subcontentname="BOM Summary" subcontentcd="FTABOMSumm"/> <hs subcontentname="Customer Certificate Mgnt" subcontentcd="FTACert"/> <hs subcontentname="Company Contact" subcontentcd="FTACmpCntc"/> <hs subcontentname="Company" subcontentcd="FTACmpMstr"/> <hs subcontentname="GL Account" subcontentcd="FTAGLACC"/> <hs subcontentname="FTA New Certificate" subcontentcd="FTANewCert"/> <hs subcontentname="Product Cost Configuration" subcontentcd="FTAPCC"/> <hs subcontentname="Part" subcontentcd="FTAPI"/> <hs subcontentname="FTA RI Certificate" subcontentcd="FTARICert"/> <hs subcontentname="Solicitation Log" subcontentcd="FTASOLLOG"/> <hs subcontentname="Solicitation Response" subcontentcd="FTASRSP"/> <hs subcontentname="Supplier TA Cert Entry" subcontentcd="FTASRSPDE"/> <hs subcontentname="Supplier AALA Cert Entry" subcontentcd="FTASupAALA"/> <hs subcontentname="Vendor Master" subcontentcd="FTAVEN"/> <hs subcontentname="Vendor Summary" subcontentcd="FTAVENSUM"/> <hs subcontentname="TA Analysis" subcontentcd="TAA"/> <hs subcontentname="Charge Code" subcontentcd="TACHRG"/> <hs subcontentname="Charge Type" subcontentcd="TACHRGTYPE"/> <hs subcontentname="Cost Type" subcontentcd="TACSTTYPE"/> <hs subcontentname="TA Setup" subcontentcd="TASET"/> <hs subcontentname="Solicitation Request" subcontentcd="TASolReq"/> <hs subcontentname="What-If Analysis" subcontentcd="TAWIA"/> <hs subcontentname="What-If Summary" subcontentcd="TAWIS"/> <hs subcontentname="Tariff Rule" subcontentcd="TFRUL"/> <hs subcontentname="Trace List" subcontentcd="TRCL"/> </hc></root>

SQL QUERY CODE:

select hc.contentcd,hc.contentname,hc.modid,hs.subcontentcd,hs.subcontentname from hlpmstcontent hc

inner join hlpmstsubcontent hs on hs.modid=hc.modid for xml auto

HTML CODE:

<!doctype html>
<html>
<head id="Head1">
    <title>GTKonnect Help System</title>
    
    <link href="Black/BlackStyle.css" media="screen" rel="stylesheet" />
    <link href="Mobile.css" rel="stylesheet" media="handheld" />

    <script src="JS/jquery.js" type="text/javascript"></script>

    <script src="JS/dropdown.js" type="text/javascript"></script>

    <script src="JS/Contentdropdown.js" type="text/javascript"></script>

    <link rel="stylesheet" href="http://code.jquery.com/mobile/latest/jquery.mobile.min.css" />

    <script>
        $(document).bind("mobileinit", function() {
            $.mobile.ajaxEnabled = false;
        });
    </script>
    <script type="text/javascript" language="javascript">
        $(document).ready(init);
        //var mainXML;
        var curProgram = "";
        var curLanguage = "";
        function init() {
            $("#ContentList").show();
            loadContentXML("XML/HlpContent.xml");
        }

        function loadContentXML(_xml) {
            $.ajax({
                type: "GET",
                url: _xml,
                dataType: "xml",
                success: setContentXML
            }) // close ajax
        }


        function setContentXML(_xml) {
            var _idx = 0;
            var curOption;
            var curContent = $(_xml).find('hc') //finding xml elements with hc
            $(curContent).each(function(i) {
                var hc = $(this);
                curOption = $("<option value='" + $(hc).attr('modid') + "'>" + $(hc).attr('contentname') + "</option>")
                curOption.data("hc", hc); // bind the country node data from the XML to the option of the dropdown
                $(curOption).appendTo($('#ContentList'))
            })
        }

/*
NOTE: Yellow clor indicates how to read XML node value

XML ROOT:<hc modid="1" contentname="Security" contentcd="SEC">

We wnat to read values for this xml

you want to get xml "contentname" using:$(hc).attr('contentname')

you want to get xml "modid" using:$(hc).attr('modid')

TECHNICAL GUIDE

Specializations

Thursday, December 6, 2012

XML with Jquey HTML

No comments:

Post a Comment

Popular Posts