All Downloads are FREE. Search and download functionalities are using the official Maven repository.
  • Log In
  • Register

    • se.vgregion.usdservice.USDServiceImpl Maven / Gradle / Ivy

    There is a newer version: 3.24
    Show newest version
    /**
 * Copyright 2010 Västra Götalandsregionen
 *
 *   This library is free software; you can redistribute it and/or modify
 *   it under the terms of version 2.1 of the GNU Lesser General Public
 *   License as published by the Free Software Foundation.
 *
 *   This library is distributed in the hope that it will be useful,
 *   but WITHOUT ANY WARRANTY; without even the implied warranty of
 *   MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
 *   GNU Lesser General Public License for more details.
 *
 *   You should have received a copy of the GNU Lesser General Public
 *   License along with this library; if not, write to the
 *   Free Software Foundation, Inc., 59 Temple Place, Suite 330,
 *   Boston, MA 02111-1307  USA
 *
 */

package se.vgregion.usdservice;

import java.io.ByteArrayInputStream;
import java.io.File;
import java.io.InputStream;
import java.io.UnsupportedEncodingException;
import java.net.MalformedURLException;
import java.net.URL;
import java.rmi.RemoteException;
import java.util.ArrayList;
import java.util.Enumeration;
import java.util.List;
import java.util.Properties;

import javax.activation.DataHandler;
import javax.activation.FileDataSource;
import javax.xml.parsers.DocumentBuilder;
import javax.xml.parsers.DocumentBuilderFactory;
import javax.xml.rpc.holders.StringHolder;
import javax.xml.xpath.XPath;
import javax.xml.xpath.XPathConstants;
import javax.xml.xpath.XPathExpression;
import javax.xml.xpath.XPathFactory;

import org.apache.axis.client.Call;
import org.apache.axis.client.Service;
import org.apache.axis.utils.StringUtils;
import org.apache.commons.logging.Log;
import org.apache.commons.logging.LogFactory;
import org.w3c.dom.Document;
import org.w3c.dom.Node;
import org.w3c.dom.NodeList;

import se.vgregion.usdservice.domain.Issue;

import com.ca.www.UnicenterServicePlus.ServiceDesk.USD_WebServiceSoap;
import com.ca.www.UnicenterServicePlus.ServiceDesk.USD_WebServiceSoapSoapBindingStub;

/**
 * @author Andrew Culbert
 * @author Ulf Carlsson
 * 
 */
public class USDServiceImpl implements USDService {

    private URL endPoint;
    private String wsUser;
    private String wsPassword;
    private String wsAttachmentRepHandle;
    private USD_WebServiceSoapSoapBindingStub webService;
    private static final Log log = LogFactory.getLog(USDServiceImpl.class);

    private Properties usdAppToGroupMappings;

    // Define which attributes to fetch when retrieving contact's issue list
    private static final String[] attributeNamesMultiTypeList = new String[] { "description", "summary",
            "status.sym", "ref_num", "web_url", "type" };
    private static final String[] attributeNamesChangeOrderList = new String[] { "description", "summary",
            "status.sym", "chg_ref_num", "web_url" };

    private static final String TYPE_ISSUE = "IS";
    private static final String TYPE_CHANGE_ORDER = "C";

    public USDServiceImpl(Properties p) {
        String sEndPoint = p.getProperty("endpoint");
        try {
            endPoint = new URL(sEndPoint);
        } catch (MalformedURLException e) {
            throw new RuntimeException("URL not found:" + sEndPoint, e);
        }
        this.wsUser = p.getProperty("user");
        this.wsPassword = p.getProperty("password");
        this.wsAttachmentRepHandle = p.getProperty("repositoryHandle");
    }

    public Properties getUsdAppToGroupMappings() {
        return usdAppToGroupMappings;
    }

    public void setUsdAppToGroupMappings(Properties appToGroupMappings) {
        this.usdAppToGroupMappings = appToGroupMappings;

        // System.out.println("USDMappings:" + usdAppToGroupMappings);

    }

    private void createAttachment(USD_WebServiceSoap service, int sid, String repHandle, String objectHandle,
            String description, String fileName) throws Exception {

        FileDataSource fds = new FileDataSource(fileName);
        DataHandler dhandler = new DataHandler(fds);
        // Affix DIME type header to attachment before sending
        ((javax.xml.rpc.Stub) service)._setProperty(org.apache.axis.client.Call.ATTACHMENT_ENCAPSULATION_FORMAT,
                Call.ATTACHMENT_ENCAPSULATION_FORMAT_DIME);
        ((org.apache.axis.client.Stub) service).addAttachment(dhandler);
        // Create attachment
        service.createAttachment(sid, repHandle, objectHandle, description, fileName);
        //System.out.println("Creating attachment...SUCCESS");

    }

    protected String getHandleFromResponse(InputStream xml) throws Exception {

        DocumentBuilderFactory docBuilderFactory = DocumentBuilderFactory.newInstance();
        DocumentBuilder docBuilder = docBuilderFactory.newDocumentBuilder();
        Document doc = docBuilder.parse(xml);

        NodeList handles = doc.getElementsByTagName("Handle");
        int i = handles.getLength();

        for (int s = 0; s < handles.getLength(); s++) {
            Node handleNode = handles.item(s);
            return handleNode.getFirstChild().getNodeValue();
        }

        return "";
    }

    private String getGroupHandle(String groupName) {

        int sessionID = 0;
        String sql = "type = 2308 and delete_flag = 0 and last_name = '" + groupName + "'";

        try {
            sessionID = getWebService().login(wsUser, wsPassword);
            String result = getWebService().doSelect(sessionID, "cnt", sql, -1, new String[] { "last_name" });
            ByteArrayInputStream s = new ByteArrayInputStream(result.getBytes());
            return getHandleFromResponse(s);
        } catch (RemoteException e) {
            throw new RuntimeException("Error when getting group handle", e);
        } catch (Exception e) {
            throw new RuntimeException("Error when parsing xml response when searching for a group", e);
        }

    }

    public String createRequest(Properties requestParameters, String userId, List files,
            List filenames) {

        String result = null;
        int sessionID = 0;
        try {

            String contactHandle;
            sessionID = getWebService().login(wsUser, wsPassword);
            try {
                contactHandle = getHandleForUserid(sessionID, userId);
            } catch (Throwable e) {
                log.debug("Trying default contactHandle:" + e.getMessage());
                // Use the wsUser if the user is unknown
                contactHandle = getHandleForUserid(sessionID, wsUser);

                // contactHandle = wsUser;

            }
            requestParameters.setProperty("customer", contactHandle);
            List lAttributes = new ArrayList();
            List lAttributeValues = new ArrayList();

            for (Enumeration e = requestParameters.keys(); e.hasMoreElements();) {
                String key = (String) e.nextElement();
                lAttributes.add(key);
                lAttributeValues.add(key);
                lAttributeValues.add(requestParameters.getProperty(key));
            }

            String[] attributes = lAttributes.toArray(new String[0]);
            String[] attrVals = lAttributeValues.toArray(new String[0]);
            String[] propertyValues = new String[0];

            StringHolder newRequestHandle = new StringHolder();
            StringHolder newRequestNumber = new StringHolder();

            String template = "";

            result = getWebService().createRequest(sessionID, contactHandle, attrVals, propertyValues, template,
                    attributes, newRequestHandle, newRequestNumber);
            byte[] bytes = result.getBytes("utf-8");
            ByteArrayInputStream s = new ByteArrayInputStream(bytes);
            // System.out.println("USDResponse=" + new String(bytes));
            String handle;
            try {
                handle = getHandleFromResponse(s);
            } catch (Exception e) {
                throw new RuntimeException("Error parsing handle to USD incident from xml response...\n" + result,
                        e);
            }

            if (handle != "") {
                if (files != null && files.size() > 0) {
                    int i = 0;
                    for (File f : files) {
                        try {
                            if (filenames != null && filenames.size() > 0) {
                                File newFile = new File(f.getParentFile(), filenames.get(i));
                                boolean renameSuccess = f.renameTo(newFile);
                                if (renameSuccess) {
                                    f = new File(f.getParentFile(), filenames.get(i));
                                }
                            }
                            // System.out.println("Attaching: " +
                            // f.getAbsolutePath());
                            this.createAttachment(getWebService(), sessionID, wsAttachmentRepHandle, handle,
                                    "Attachment " + i, f.getAbsolutePath());
                        } catch (Exception e) {
                            throw new RuntimeException("Error creating attchment in USD", e);
                        }
                        i++;
                    }
                }
            }

        } catch (RemoteException e) {
            log.error("Failed to create request to USD Service", e);
            try {
                getWebService().logout(sessionID);
            } catch (RemoteException e1) {
                // No action
            }
            throw new RuntimeException(e);
        } catch (UnsupportedEncodingException e) {
            throw new RuntimeException("TODO: Handle this exception better", e);
        } finally {

            try {

                getWebService().logout(sessionID);

            } catch (RemoteException e) {
                log.warn(e);
            }
        }

        return result;
    }

    protected USD_WebServiceSoapSoapBindingStub getWebService() {
        if (webService == null) {
            Service service1 = new Service();
            try {
                webService = new USD_WebServiceSoapSoapBindingStub(endPoint, service1);
            } catch (Exception e) {
                throw new RuntimeException(e);
            }
        }
        return webService;
    }

    public String getUSDGroupHandleForApplicationName(String appName) {
        String usdGroupName = usdAppToGroupMappings.getProperty(appName);
        // System.out.println("usdAppToGroupMappings=" + usdAppToGroupMappings);
        String result = getGroupHandle(usdGroupName);
        if (result == null || result.length() == 0) {

            throw new RuntimeException("No group handle found for application name=" + appName);
        }
        return result;
    }

    private List getIssuesForContact(String userId, int sessionID, String contactHandle, Integer maxRows)
            throws RemoteException {
        List taskList = new ArrayList();

        StringBuilder whereClause = new StringBuilder();
        int endIndex = -1; // To fetch max number of rows, which according to
        // spec is 250 per call

        // Handle end index input
        if (maxRows != null && maxRows >= -1) {
            endIndex = maxRows.intValue();
        }

        // Build where clause
        whereClause.append("affected_contact.id = U'"); // requestor.id
        whereClause.append(contactHandle);
        whereClause.append("' AND active = 1");

        // Get list xml
        String listXml = getWebService().doSelect(sessionID, "iss", whereClause.toString(), endIndex,
                attributeNamesMultiTypeList);

        // Get input stream for xml data
        ByteArrayInputStream bais = new ByteArrayInputStream(listXml.getBytes());

        // Parse xml to list
        taskList = getIssuesFromList(bais, TYPE_ISSUE);

        return taskList;
    }

    private List getRequestForContact(String userId, int sessionID, String contactHandle, Integer maxRows)
            throws RemoteException {
        List taskList = new ArrayList();

        StringBuilder whereClause = new StringBuilder();
        int endIndex = -1; // To fetch max number of rows, which according to
        // spec is 250 per call

        // Handle end index input
        if (maxRows != null && maxRows >= -1) {
            endIndex = maxRows.intValue();
        }

        // Build where clause
        whereClause.append("customer.id = U'");
        whereClause.append(contactHandle);
        whereClause.append("' AND active = 1");

        // Get list xml
        String listXml = getWebService().doSelect(sessionID, "cr", whereClause.toString(), endIndex,
                attributeNamesMultiTypeList);

        // Get input stream for xml data
        ByteArrayInputStream bais = new ByteArrayInputStream(listXml.getBytes());

        // Parse xml to list
        taskList = getIssuesFromList(bais, null);

        return taskList;
    }

    private List getChangeOrdersForContact(String userId, int sessionID, String contactHandle,
            Integer maxRows) throws RemoteException {
        List taskList = new ArrayList();

        StringBuilder whereClause = new StringBuilder();
        int endIndex = -1; // To fetch max number of rows, which according to
        // spec is 250 per call

        // Handle end index input
        if (maxRows != null && maxRows >= -1) {
            endIndex = maxRows.intValue();
        }

        // Build where clause
        whereClause.append("affected_contact.id = U'");
        whereClause.append(contactHandle);
        whereClause.append("' AND active = 1");

        // Get list xml
        String listXml = getWebService().doSelect(sessionID, "chg", whereClause.toString(), endIndex,
                attributeNamesChangeOrderList);

        // Get input stream for xml data
        ByteArrayInputStream bais = new ByteArrayInputStream(listXml.getBytes());

        // Parse xml to list
        taskList = getIssuesFromList(bais, TYPE_CHANGE_ORDER);

        return taskList;
    }

    protected List getIssuesFromList(InputStream xml, String defaultType) throws RuntimeException {
        List issueList = new ArrayList();

        try {
            // Parse the XML to get a DOM to query
            DocumentBuilderFactory dbfactory = DocumentBuilderFactory.newInstance();
            dbfactory.setNamespaceAware(true);
            dbfactory.setXIncludeAware(true);

            DocumentBuilder parser = dbfactory.newDocumentBuilder();
            Document doc = parser.parse(xml);

            // Get an XPath processor
            XPathFactory xpfactory = XPathFactory.newInstance();
            XPath xpathprocessor = xpfactory.newXPath();

            // Create XPath expressions
            String xpathUDSObject = "/UDSObjectList/UDSObject";
            XPathExpression udsObjectXPath = xpathprocessor.compile(xpathUDSObject);

            // Execute the XPath expressions
            NodeList udsObjects = (NodeList) udsObjectXPath.evaluate(doc, XPathConstants.NODESET);
            for (int i = 1; i < udsObjects.getLength() + 1; i++) {
                Issue issue = new Issue();

                // Get summary
                StringBuilder xPath = new StringBuilder();
                xPath.append("/UDSObjectList/UDSObject[");
                xPath.append(i);
                xPath.append("]/Attributes/Attribute[AttrName='summary']/AttrValue");

                XPathExpression attributeValueXPath = xpathprocessor.compile(xPath.toString());
                String value = (String) attributeValueXPath.evaluate(doc, XPathConstants.STRING);
                issue.setSummary(value);

                // Get description
                xPath = new StringBuilder();
                xPath.append("/UDSObjectList/UDSObject[");
                xPath.append(i);
                xPath.append("]/Attributes/Attribute[AttrName='description']/AttrValue");

                attributeValueXPath = xpathprocessor.compile(xPath.toString());
                value = (String) attributeValueXPath.evaluate(doc, XPathConstants.STRING);
                issue.setDescription(value);

                // Get status
                xPath = new StringBuilder();
                xPath.append("/UDSObjectList/UDSObject[");
                xPath.append(i);
                xPath.append("]/Attributes/Attribute[AttrName='status.sym']/AttrValue");

                attributeValueXPath = xpathprocessor.compile(xPath.toString());
                value = (String) attributeValueXPath.evaluate(doc, XPathConstants.STRING);
                issue.setStatus(value);

                // Get ref_num
                xPath = new StringBuilder();
                xPath.append("/UDSObjectList/UDSObject[");
                xPath.append(i);
                if (TYPE_CHANGE_ORDER.equals(defaultType)) {
                    xPath.append("]/Attributes/Attribute[AttrName='chg_ref_num']/AttrValue");
                } else {
                    xPath.append("]/Attributes/Attribute[AttrName='ref_num']/AttrValue");
                }
                attributeValueXPath = xpathprocessor.compile(xPath.toString());
                value = (String) attributeValueXPath.evaluate(doc, XPathConstants.STRING);
                // No "dead" issues...
                if (StringUtils.isEmpty(value)) {
                    continue;
                }
                issue.setRefNum(value);

                // Get web_url
                xPath = new StringBuilder();
                xPath.append("/UDSObjectList/UDSObject[");
                xPath.append(i);
                xPath.append("]/Attributes/Attribute[AttrName='web_url']/AttrValue");

                attributeValueXPath = xpathprocessor.compile(xPath.toString());
                value = (String) attributeValueXPath.evaluate(doc, XPathConstants.STRING);
                issue.setUrl(value);

                // Get type
                xPath = new StringBuilder();
                xPath.append("/UDSObjectList/UDSObject[");
                xPath.append(i);
                xPath.append("]/Attributes/Attribute[AttrName='type']/AttrValue");

                attributeValueXPath = xpathprocessor.compile(xPath.toString());
                value = (String) attributeValueXPath.evaluate(doc, XPathConstants.STRING);
                if (StringUtils.isEmpty(value)) {
                    value = defaultType;
                }
                issue.setType(value);

                // Add Issue object to list
                issueList.add(issue);
            }

            return issueList;
        } catch (Exception e) {
            log.error("Error when trying to parse issue list from XML", e);
            throw new RuntimeException("Error when trying to parse issue list from XML", e);
        }
    }

    /*
     * (non-Javadoc)
     * 
     * @see se.vgregion.usdservice.USDService#getRecordsForContact(java.lang.String, java.lang.Integer)
     */
    public List getRecordsForContact(String userId, Integer maxRows) {
        List records = new ArrayList();

        int sessionID = 0;
        try {
            // Login and get session
            sessionID = getWebService().login(wsUser, wsPassword);

            String contactHandle;
            try {
                contactHandle = getHandleForUserid(sessionID, userId);
            } catch (Throwable e) {
                log.error("Could not get handle for user with userId " + userId);
                // TODO: User not registered in USD? Should we inform the user?
                return records;
            }

            // Rid object type from handle
            if (contactHandle != null) {
                contactHandle = contactHandle.replace("cnt:", "");
            }

            // Incidents, Problems and Change Orders
            List changeOrdersForContact = getChangeOrdersForContact(userId, sessionID, contactHandle,
                    maxRows);
            // Requests
            List requestForContact = getRequestForContact(userId, sessionID, contactHandle, maxRows);
            // Issues
            List issuesForContact = getIssuesForContact(userId, sessionID, contactHandle, maxRows);
            records.addAll(changeOrdersForContact);
            records.addAll(requestForContact);
            records.addAll(issuesForContact);

        } catch (RemoteException e) {
            log.error("Failed to get issue list from USD Service for user=" + userId, e);
            try {
                getWebService().logout(sessionID);
            } catch (RemoteException e1) {
                // No action
            }
            throw new RuntimeException(e);
        } finally {
            try {
                getWebService().logout(sessionID);
            } catch (RemoteException e) {
                log.warn(e);
            }
        }

        return records;
    }

    private String getHandleForUserid(int sessionID, String userId) throws RemoteException {
        return new StringBuffer(getWebService().getHandleForUserid(sessionID, userId)).toString();
    }

    public String createRequest(Properties testParameters, String string, List files) {
        return createRequest(testParameters, string, files, null);
    }
}
    
    
    
    

    




    
    
    © 2015 - 2025 Weber Informatics LLC | Privacy Policy