Package com.dotmarketing.common.db

Examples of com.dotmarketing.common.db.DotConnect.loadResults()

3104
3105
3106
3107
3108
3109
3110
3111
3112
3113
3114
      }

      //Looking for children containers overriding inheritance to also apply the cascade changes
      dc.setSQL(selectChildrenContainerWithIndividualPermissionsSQL);
      dc.addParam(host.getPermissionId());
      idsToUpdate = dc.loadResults();
      ContainerAPI containerAPI = APILocator.getContainerAPI();
      permission = 0;
      if (inheritablePermission != null) {
        permission = inheritablePermission.getPermission();
      }
View Full Code Here
3148
3149
3150
3151
3152
3153
3154
3155
3156
3157
3158
    // changes
    dc.setSQL(selectChildrenFolderWithDirectPermissionsSQL);
    dc.addParam(host.getPermissionId());
    dc.addParam(isHost ? "%" : folderPath + "%");
    dc.addParam(isHost ? " " : folderPath + "");
    List<Map<String, String>> idsToUpdate = dc.loadResults();
    FolderAPI folderAPI = APILocator.getFolderAPI();
    int permission = 0;
    if (inheritablePermission != null) {
      permission = inheritablePermission.getPermission();
    }
View Full Code Here
3190
3191
3192
3193
3194
3195
3196
3197
3198
3199
3200
    // Selecting html pages which are children and need individual
    // permission changes
    dc.setSQL(selectChildrenHTMLPageWithIndividualPermissionsSQL);
    dc.addParam(host.getPermissionId());
    dc.addParam(isHost ? "%" : folderPath + "%");
    idsToUpdate = dc.loadResults();
    HTMLPageAPI pageAPI = APILocator.getHTMLPageAPI();
    permission = 0;
    if (inheritablePermission != null) {
      permission = inheritablePermission.getPermission();
    }
View Full Code Here
3232
3233
3234
3235
3236
3237
3238
3239
3240
3241
3242
    // Selecting files which are children and need individual permission
    // changes
    dc.setSQL(selectChildrenFileWithIndividualPermissionsSQL);
    dc.addParam(host.getPermissionId());
    dc.addParam(isHost ? "%" : folderPath + "%");
    idsToUpdate = dc.loadResults();
    FileAPI fileAPI = APILocator.getFileAPI();
    permission = 0;
    if (inheritablePermission != null) {
      permission = inheritablePermission.getPermission();
    }
View Full Code Here
3274
3275
3276
3277
3278
3279
3280
3281
3282
3283
3284
    // Selecting links which are children and need individual permission
    // changes
    dc.setSQL(selectChildrenLinkWithIndividualPermissionsSQL);
    dc.addParam(host.getPermissionId());
    dc.addParam(isHost ? "%" : folderPath + "%");
    idsToUpdate = dc.loadResults();
    MenuLinkAPI linkAPI = APILocator.getMenuLinkAPI();
    permission = 0;
    if (inheritablePermission != null) {
      permission = inheritablePermission.getPermission();
    }
View Full Code Here
3316
3317
3318
3319
3320
3321
3322
3323
3324
3325
3326
    // Selecting content which are children and need individual permission
    // changes
    dc.setSQL(selectChildrenContentWithIndividualPermissionsByPathSQL);
    dc.addParam(host.getPermissionId());
    dc.addParam(isHost ? "%" : folderPath + "%");
    idsToUpdate = dc.loadResults();
    ContentletAPI contentAPI = APILocator.getContentletAPI();
    permission = 0;
    if (inheritablePermission != null) {
      permission = inheritablePermission.getPermission();
    }
View Full Code Here
3364
3365
3366
3367
3368
3369
3370
3371
3372
3373
3374
    // changes
    dc.setSQL(selectChildrenStructureWithIndividualPermissionsByPathSQL);
    dc.addParam(isHost ? "%" : folderPath + "%");
    dc.addParam(host.getPermissionId());
    dc.addParam(host.getPermissionId());
    idsToUpdate = dc.loadResults();
    permission = 0;
    if (inheritablePermission != null) {
      permission = inheritablePermission.getPermission();
    }
View Full Code Here
501
502
503
504
505
506
507
508
509
510
511
        db.setSQL(GET_TOTAL_HTML_PAGE_VIEWS_BY_LANGUAGE);
        db.addParam(uri);
        db.addParam(startDate);
        db.addParam(endDate);
        db.addParam(hostId);
        return db.loadResults();
    }

    @SuppressWarnings("unchecked")
  public static List<Map<String, String>> getTopInternalReferringPages(String uri, java.util.Date startDate, java.util.Date endDate, String hostId) throws DotDataException {
        DotConnect db = new DotConnect();
View Full Code Here
3555
3556
3557
3558
3559
3560
3561
3562
3563
3564
3565
      permIds.append("'"+inode.getIdentifier()+"'");
      if((permIdCount>0 && permIdCount%500==0) || (permIdCount==permissionables.size()-1)){
        permIds.append(") ");
        DotConnect dc = new DotConnect();
        dc.setSQL(permissionRefSQL.toString()+permIds.toString() + " UNION " +individualPermissionSQL.toString() + permIds.toString());
        List<Map<String, Object>> results = (ArrayList<Map<String, Object>>)dc.loadResults();
          for (int i = 0; i < results.size(); i++) {
            Map<String, Object> hash = (Map<String, Object>) results.get(i);
            if(!hash.isEmpty()){
              String assetId = (String) hash.get("asset_id");
              permsToReturn.add(permissionableMap.get(assetId));
View Full Code Here
514
515
516
517
518
519
520
521
522
523
524
        db.addParam(uri);
        db.addParam(startDate);
        db.addParam(endDate);
        db.addParam(hostId);
        db.setMaxRows(5);
        return db.loadResults();
    }
   
    @SuppressWarnings("unchecked")
  public static List<Map<String, String>> getTopInternalOutgoingPages(String uri, java.util.Date startDate, java.util.Date endDate, String hostId) throws DotDataException {
        DotConnect db = new DotConnect();
View Full Code Here
TOP
Copyright © 2018 www.massapi.com. All rights reserved.
All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.