@RequestMapping("list")
public ModelAndView list() {
List<Media> list = service.query(0);
JSONArray array = new JSONArray();
for (Media ch : list) {
array.add(ch.toJson());
}
return ViewUtil.renderListView("_media.jsp", array.toJSONString());
}
public JSONObject getManufacturers() {
JSONObject result = new JSONObject();
Connection dbConnection = null;
try {
Class.forName("com.mysql.jdbc.Driver");
dbConnection =
DriverManager.getConnection(PathNames.DB_URL, PathNames.USERNAME, PathNames.PASSWORD);
String query =
"SELECT * FROM "
+ PathNames.DB_MANUFACTURER_CATEGORIES
+ " cats, "
+ PathNames.DB_MANUFACTURERS
+ " mans WHERE cats.category_key='"
+ catkey
+ "' AND mans.manufacturer_id=cats.manufacturer_id";
System.out.println(query);
// Execute a query
Statement statement = dbConnection.createStatement();
ResultSet rs = statement.executeQuery(query);
JSONArray typeList = new JSONArray();
while (rs.next()) {
JSONObject curr = new JSONObject();
curr.put("catkey", rs.getString("category_key"));
curr.put("manufacturer_id", rs.getString("manufacturer_id"));
curr.put("manufacturer", rs.getString("manufacturer"));
curr.put("image", rs.getString("image_name"));
typeList.add(curr);
}
result.put("manufacturers", typeList);
manufacturers = result;
} catch (SQLException | ClassNotFoundException ex) {
ex.printStackTrace();
} finally {
try {
dbConnection.close();
} catch (Exception e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
return result;
}
public static JSONObject jsonObjectFromManifest(Manifest manifest) {
JSONObject rootObject = new JSONObject();
rootObject.put(ManifestConstants.TIME, manifest.getTimestamp());
rootObject.put(
ManifestConstants.GUID, manifest.getGuid()); // unique identifier for this manifest.
rootObject.put(ManifestConstants.URLROOT, manifest.getUrlRoot());
rootObject.put(ManifestConstants.VERSION, manifest.getVersion());
// let's get that array
JSONArray array = new JSONArray();
for (Entry entry : manifest.getEntries()) {
array.add(jsonObjectFromEntry(entry));
}
rootObject.put(ManifestConstants.ENTRIES, array);
return rootObject;
}
/**
* This method is use for create web application
*
* @param payload request payload for web app create api
* @param webAppDetail bean object of the web application
* @throws IOException Throws this when failed to create web application
* @throws RegistryException Throws this when UUID failed while requesting
* @throws AppManagementException Throws this when gateway port failed while retrieving
* @throws java.lang.InterruptedException Throws this when thread failed
*/
private String createWebApplication(String payload, WebAppDetail webAppDetail)
throws IOException, RegistryException, AppManagementException, InterruptedException {
String currentUserName = webAppDetail.getUserName();
String creatorSession = webAppDetail.getCreatorSession();
httpHandler.doPostHttps(
httpsBackEndUrl + "/publisher/asset/webapp",
payload,
creatorSession,
"application/x-www-form-urlencoded");
JSONArray claimsAry = new JSONArray();
ConcurrentHashMap<String, String[]> claimMap = webAppDetail.getClaims();
Iterator entries = claimMap.entrySet().iterator();
while (entries.hasNext()) {
Map.Entry thisEntry = (Map.Entry) entries.next();
String claimName = ((String[]) thisEntry.getValue())[0];
claimsAry.add(claimName);
}
JSONObject configJson = new JSONObject();
configJson.put("provider", "wso2is-5.0.0"); // use a constant
configJson.put("logout_url", "");
configJson.put("claims", claimsAry);
configJson.put("app_name", webAppDetail.getWebAppName());
configJson.put("app_verison", webAppDetail.getVersion());
configJson.put("app_transport", "http");
configJson.put("app_context", webAppDetail.getContext());
configJson.put("app_provider", webAppDetail.getUserName());
configJson.put("app_allowAnonymous", "false");
configJson.put("app_acsURL", "");
httpHandler.doPostHttps(
httpsBackEndUrl + "/publisher/api/sso/addConfig",
configJson.toJSONString(),
creatorSession,
"application/json; charset=UTF-8");
String appPath =
"/_system/governance/appmgt/applicationdata/provider/"
+ currentUserName
+ "/"
+ webAppDetail.getWebAppName()
+ "/1.0.0/webapp";
String UUID = wsRegistryServiceClient.getUUID(appPath);
String trackingIDResponse =
httpHandler
.doGet(
httpsBackEndUrl + "/publisher/api/asset/webapp/trackingid/" + UUID,
"",
creatorSession,
"")
.split(":")[1]
.trim();
String trackingID = trackingIDResponse.substring(1, (trackingIDResponse.length() - 2));
webAppDetail.setTrackingCode(trackingID);
invokeStatistcsJavascriptBuilder =
new InvokeStatistcsJavascriptBuilder(
trackingID, ipAddress, Configuration.getGatewayPort("http"));
if (webAppDetail.getWebAppName().equals("PlanYourTrip_" + currentUserName)) {
invokeStatistcsJavascriptBuilder.buildInvokeStaticsJavascriptFile(
appmHomePath + "/repository/deployment/server/webapps/plan-your-trip-1.2.0");
} else if (webAppDetail.getWebAppName().equals("TravelBooking_" + currentUserName)) {
invokeStatistcsJavascriptBuilder.buildInvokeStaticsJavascriptFile(
appmHomePath + "/repository/deployment/server/webapps/travel-booking-1.2.0/js");
}
log.info(webAppDetail.getWebAppName() + " created and UUID is : " + UUID);
return UUID;
}