Example usage for org.joda.time DateTime minusDays

Introduction

In this page you can find the example usage for org.joda.time DateTime minusDays.

Prototype

public DateTime minusDays(int days) 

Source Link

Document

Returns a copy of this datetime minus the specified number of days.

Usage

From source file:com.rhythm.swagr.SwagrDAO.java

License:Apache License

private SwagrStructure systemTotals(SwagrOptionsPB req) throws Exception {
    DateTime enddt = new DateTime();
    DateTime startdt = enddt.minusDays(30);
    String dtype = "%";
    String loc = "%";
    String systemTotals = SYSTEM_TOTALS_COUNT;

    if (req.hasDataType())
        if (req.getDataType() != 0)
            dtype = Integer.toString(req.getDataType());
    if (req.hasLocation())
        if (!"ALL".equals(req.getLocation()))
            loc = req.getLocation();//from w  w w  .  j  ava 2 s  . co m

    int valType = req.getValType();
    if (valType == 2)
        systemTotals = SYSTEM_TOTALS_LOAD;
    else if (valType == 3)
        systemTotals = SYSTEM_TOTALS_DURATION;

    try (JdbcService jdbc = swagrJdbcFac.newService(systemTotals)) {
        PreparedStatement ps = jdbc.getPreparedStatement();
        ps.setDate(1, req.hasStartDt() ? new Date(req.getStartDt()) : new Date(startdt.getMillis()));
        ps.setDate(2, req.hasEndDt() ? new Date(req.getEndDt()) : new Date(enddt.getMillis()));
        ps.setString(3, dtype);
        ps.setString(4, loc);
        ps.setInt(5, req.getSystemId());
        ResultSet rs = jdbc.executeQuery();
        return systemTotalsResultSet(rs, req.getSystemId());
    }
}

---

From source file:com.rhythm.swagr.SwagrDAO.java

License:Apache License

private SwagrStructure serviceTotals(SwagrOptionsPB req) throws Exception {
    DateTime enddt = new DateTime();
    DateTime startdt = enddt.minusDays(30);
    String dtype = "%";
    String loc = "%";
    String serviceQuery = SERVICE_TOTALS_COUNT;

    if (req.hasDataType())
        if (req.getDataType() != 0)
            dtype = Integer.toString(req.getDataType());
    if (req.hasLocation())
        if (!"ALL".equals(req.getLocation()))
            loc = req.getLocation();//from  w  w  w.j a v  a  2 s  .c  om

    int valType = req.getValType();
    if (valType == 2)
        serviceQuery = SERVICE_TOTALS_LOAD;
    else if (valType == 3)
        serviceQuery = SERVICE_TOTALS_DURATION;

    try (JdbcService jdbc = swagrJdbcFac.newService(serviceQuery)) {
        PreparedStatement ps = jdbc.getPreparedStatement();
        ps.setDate(1, req.hasStartDt() ? new Date(req.getStartDt()) : new Date(startdt.getMillis()));
        ps.setDate(2, req.hasEndDt() ? new Date(req.getEndDt()) : new Date(enddt.getMillis()));
        ps.setString(3, dtype);
        ps.setString(4, loc);
        ps.setInt(5, req.getSystemId());
        ResultSet rs = jdbc.executeQuery();
        return serviceResultSet(rs);
    }
}

---

From source file:com.rhythm.swagr.SwagrDAO.java

License:Apache License

private SwagrStructure singleReq(SwagrOptionsPB req) throws Exception {
    SwagrStructure struct = new SwagrStructure();
    DateTime enddt = new DateTime();
    DateTime startdt = enddt.minusDays(30);
    String tempLoc;/*from w ww.jav a  2s  .c om*/
    String tempDType;
    if ("ALL".equals(req.getLocation()))
        tempLoc = "%";
    else
        tempLoc = req.getLocation();
    if (req.getDataType() == 0)
        tempDType = "%";
    else
        tempDType = Integer.toString(req.getDataType());

    try (JdbcService jdbc = swagrJdbcFac.newService(SINGLE_REQ)) {
        PreparedStatement ps = jdbc.getPreparedStatement();
        ps.setDate(1, req.hasStartDt() ? new Date(req.getStartDt()) : new Date(startdt.getMillis()));
        ps.setDate(2, req.hasEndDt() ? new Date(req.getEndDt()) : new Date(enddt.getMillis()));
        ps.setInt(3, req.getId());
        ps.setString(4, tempLoc);
        ps.setString(5, tempDType);
        ResultSet rs = jdbc.executeQuery();
        sysStatsDailyResSet(rs, struct);
    }

    try (JdbcService jdbc = swagrJdbcFac.newService(SWAGR_SINGLE_STRINGS_SYS)) {
        PreparedStatement ps = jdbc.getPreparedStatement();
        ps.setInt(1, req.getId());
        ResultSet rs = jdbc.executeQuery();
        reqStrings(rs, struct);
        return struct;
    }
}

---

From source file:com.rhythm.swagr.SwagrDAO.java

License:Apache License

private SwagrStructure singleQuery(SwagrOptionsPB req) throws Exception {
    SwagrStructure struct = new SwagrStructure();
    DateTime enddt = new DateTime();
    DateTime startdt = enddt.minusDays(30);

    try (JdbcService jdbc = swagrJdbcFac.newService(SINGLE_QUERY)) {
        PreparedStatement ps = jdbc.getPreparedStatement();
        ps.setDate(1, req.hasStartDt() ? new Date(req.getStartDt()) : new Date(startdt.getMillis()));
        ps.setDate(2, req.hasEndDt() ? new Date(req.getEndDt()) : new Date(enddt.getMillis()));
        ps.setInt(3, req.getId());//from   w w  w  .  ja  v a 2  s  . c  o  m
        ResultSet rs = jdbc.executeQuery();
        queryStatsDailyResSet(rs, struct);
    }

    try (JdbcService jdbc = swagrJdbcFac.newService(DRJ_SINGLE_STRING)) {
        PreparedStatement ps = jdbc.getPreparedStatement();
        ps.setInt(1, req.getId());
        ResultSet rs = jdbc.executeQuery();
        qStrings(rs, struct);
        return struct;
    }
}

---

From source file:com.rhythm.swagr.SwagrDAO.java

License:Apache License

private SwagrStructure movingAvg(SwagrOptionsPB req) throws Exception {
    SwagrStructure struct;//from w  w w. j a  v  a  2 s  . c o m
    DateTime enddt = new DateTime();
    DateTime startdt = enddt.minusDays(30);

    String tempLoc;
    if ("ALL".equals(req.getLocation()))
        tempLoc = "%";
    else
        tempLoc = req.getLocation();

    String tempDType;
    if (req.getDataType() == 0)
        tempDType = "%";
    else
        tempDType = Integer.toString(req.getDataType());

    //where start,end,loc,dtype,rid,valtype
    try (JdbcService jdbc = swagrJdbcFac.newService(MOVING_AVG)) {
        PreparedStatement ps = jdbc.getPreparedStatement();
        ps.setDate(1, req.hasStartDt() ? new Date(req.getStartDt()) : new Date(startdt.getMillis()));
        ps.setDate(2, req.hasEndDt() ? new Date(req.getEndDt()) : new Date(enddt.getMillis()));
        ps.setString(3, tempLoc);
        ps.setString(4, tempDType);
        ps.setInt(5, req.getId());
        ps.setInt(6, req.getValType());
        ResultSet rs = jdbc.executeQuery();
        struct = movingAvgResSet(rs, req.getValType());
    }

    try (JdbcService jdbc = swagrJdbcFac.newService(SWAGR_SINGLE_STRINGS_SYS)) {
        PreparedStatement ps = jdbc.getPreparedStatement();
        ps.setInt(1, req.getId());
        ResultSet rs = jdbc.executeQuery();
        reqStrings(rs, struct);
        return struct;
    }

}

---

From source file:com.rhythm.swagr.SwagrDAO.java

License:Apache License

private SwagrStructure topXSys(SwagrOptionsPB req) throws Exception {
    SwagrStructure struct = new SwagrStructure();
    DateTime enddt = new DateTime();
    DateTime startdt = enddt.minusDays(30);
    String temploc;/*  ww  w.j  ava  2s.c o m*/
    if ("ALL".equals(req.getLocation()))
        temploc = "%";
    else
        temploc = req.getLocation();
    if (req.getDataType() == 0) {

        //start,end,loc,start,end,topnum,loc,sysid,type
        try (JdbcService jdbc = swagrJdbcFac.newService(SWAGR_TOP_SYS_DISTINCT)) {
            PreparedStatement ps = jdbc.getPreparedStatement();
            ps.setDate(1, req.hasStartDt() ? new Date(req.getStartDt()) : new Date(startdt.getMillis()));
            ps.setDate(2, req.hasEndDt() ? new Date(req.getEndDt()) : new Date(enddt.getMillis()));
            ps.setString(3, temploc);
            ps.setDate(4, req.hasStartDt() ? new Date(req.getStartDt()) : new Date(startdt.getMillis()));
            ps.setDate(5, req.hasEndDt() ? new Date(req.getEndDt()) : new Date(enddt.getMillis()));
            ps.setInt(6, req.getTopNum());
            ps.setString(7, req.getLocation());
            ps.setInt(8, req.getSystemId());
            ps.setInt(9, req.getValType());
            ResultSet rs = jdbc.executeQuery();
            sysStatsDailyResSet(rs, struct);
            jdbc.close();
        }
    } else {
        //start,end,dtype,loc,start,end,topnum,loc,sysid,dtype,valtype
        try (JdbcService jdbc = swagrJdbcFac.newService(S_TOP_DATA_DISTINCT)) {
            PreparedStatement ps = jdbc.getPreparedStatement();
            ps.setDate(1, req.hasStartDt() ? new Date(req.getStartDt()) : new Date(startdt.getMillis()));
            ps.setDate(2, req.hasEndDt() ? new Date(req.getEndDt()) : new Date(enddt.getMillis()));
            ps.setInt(3, req.getDataType());
            ps.setString(4, temploc);
            ps.setDate(5, req.hasStartDt() ? new Date(req.getStartDt()) : new Date(startdt.getMillis()));
            ps.setDate(6, req.hasEndDt() ? new Date(req.getEndDt()) : new Date(enddt.getMillis()));
            ps.setInt(7, req.getTopNum());
            ps.setString(8, req.getLocation());
            ps.setInt(9, req.getSystemId());
            ps.setInt(10, req.getDataType());
            ps.setInt(11, req.getValType());
            ResultSet rs = jdbc.executeQuery();
            sysStatsDailyResSet(rs, struct);
            jdbc.close();
        }
    }

    if (req.getDataType() == 0) {
        try (JdbcService jdbc = swagrJdbcFac.newService(SWAGR_STRINGS_SYS)) {
            PreparedStatement ps = jdbc.getPreparedStatement();
            ps.setDate(1, req.hasStartDt() ? new Date(req.getStartDt()) : new Date(startdt.getMillis()));
            ps.setDate(2, req.hasEndDt() ? new Date(req.getEndDt()) : new Date(enddt.getMillis()));
            ps.setInt(3, req.getTopNum());
            ps.setString(4, req.getLocation());
            ps.setInt(5, req.getSystemId());
            ResultSet rs = jdbc.executeQuery();
            reqStrings(rs, struct);
            return struct;
        }
    } else {
        try (JdbcService jdbc = swagrJdbcFac.newService(SWAGR_STRINGS_DATA)) {
            PreparedStatement ps = jdbc.getPreparedStatement();
            ps.setDate(1, req.hasStartDt() ? new Date(req.getStartDt()) : new Date(startdt.getMillis()));
            ps.setDate(2, req.hasEndDt() ? new Date(req.getEndDt()) : new Date(enddt.getMillis()));
            ps.setInt(3, req.getTopNum());
            ps.setString(4, req.getLocation());
            ps.setInt(5, req.getSystemId());
            ps.setInt(6, req.getDataType());
            ResultSet rs = jdbc.executeQuery();
            reqStrings(rs, struct);
            return struct;
        }
    }
}

---

From source file:com.rhythm.swagr.SwagrDAO.java

License:Apache License

private SwagrStructure topXQ(SwagrOptionsPB req) throws Exception {
    SwagrStructure struct = new SwagrStructure();

    DateTime enddt = new DateTime();
    DateTime startdt = enddt.minusDays(30);

    try (JdbcService jdbc = drjJdbcFac.newService(DRJ_TOP_STATS)) {
        PreparedStatement ps = jdbc.getPreparedStatement();
        ps.setInt(1, req.getHostTypeId());
        ps.setDate(2, req.hasStartDt() ? new Date(req.getStartDt()) : new Date(startdt.getMillis()));
        ps.setDate(3, req.hasEndDt() ? new Date(req.getEndDt()) : new Date(enddt.getMillis()));
        ps.setDate(4, req.hasStartDt() ? new Date(req.getStartDt()) : new Date(startdt.getMillis()));
        ps.setDate(5, req.hasEndDt() ? new Date(req.getEndDt()) : new Date(enddt.getMillis()));
        ps.setInt(6, req.getTopNum());//from  w ww  .j a  v  a  2 s . c o  m
        ps.setInt(7, req.getHostTypeId());
        ResultSet rs = jdbc.executeQuery();
        queryStatsDailyResSet(rs, struct);
    }

    try (JdbcService jdbc = drjJdbcFac.newService(DRJ_STRINGS)) {
        PreparedStatement ps2 = jdbc.getPreparedStatement();
        ps2.setDate(1, req.hasStartDt() ? new Date(req.getStartDt()) : new Date(startdt.getMillis()));
        ps2.setDate(2, req.hasEndDt() ? new Date(req.getEndDt()) : new Date(enddt.getMillis()));
        ps2.setInt(3, req.getTopNum());
        ps2.setInt(4, req.getHostTypeId());
        ResultSet rs2 = jdbc.executeQuery();
        qStrings(rs2, struct);
        return struct;
    }
}

---

From source file:com.rhythm.swagr.SwagrDAO.java

License:Apache License

private SwagrStructure service(SwagrOptionsPB req) throws Exception {
    SwagrStructure struct = new SwagrStructure();

    DateTime enddt = new DateTime();
    DateTime startdt = enddt.minusDays(30);

    //start,end,location,service
    try (JdbcService jdbc = swagrJdbcFac.newService(SWAGR_SERVICES)) {
        PreparedStatement ps = jdbc.getPreparedStatement();
        ps.setDate(1, req.hasStartDt() ? new Date(req.getStartDt()) : new Date(startdt.getMillis()));
        ps.setDate(2, req.hasEndDt() ? new Date(req.getEndDt()) : new Date(enddt.getMillis()));
        ps.setString(3, req.hasLocation() ? req.getLocation() : "%");
        ps.setString(4, req.getDataType() == 0 ? "%" : Integer.toString(req.getDataType()));
        ps.setString(5, req.getService());
        ResultSet rs = jdbc.executeQuery();
        sysStatsDailyResSet(rs, struct);
    }/*from w w w  .j  av a  2 s.  c  om*/

    try (JdbcService jdbc = swagrJdbcFac.newService(SWAGR_SERVICE_STRINGS_SYS)) {
        PreparedStatement ps = jdbc.getPreparedStatement();
        ps.setString(1, req.getService());
        ResultSet rs = jdbc.executeQuery();
        reqStrings(rs, struct);
        return struct;
    }
}

---

From source file:com.rhythm.swagr.SwagrDAO.java

License:Apache License

private SwagrStructure deprecatedService(SwagrOptionsPB req) throws Exception {
    SwagrStructure struct = new SwagrStructure();
    DateTime enddt = new DateTime();
    DateTime startdt = enddt.minusDays(30);

    Map<RequestKey, Integer> requestIDMap = new HashMap<>();

    try (JdbcService jdbc = swagrJdbcFac.newService(SELECT_SYSTEM_REQUESTS)) {
        jdbc.getPreparedStatement().setInt(1, req.getSystemId());
        ResultSet rs = jdbc.executeQuery();
        while (rs.next()) {
            int id = rs.getInt(1);
            requestIDMap.put(new RequestKey(rs.getString(2), rs.getString(3), rs.getString(4)), id);
        }//from ww w .  j a  v  a2s . c om
    }

    List<Integer> depReqIds = new ArrayList<>();

    InfoClient infoClient = InfoClientFactory.getClient(LouieConnectionFactory.getSharedConnection());

    List<ServicePB> services;
    if (req.getService().equals("ALL")) {
        services = infoClient.getAllServices();
    } else {
        services = Collections.singletonList(infoClient.getService(req.getService()));
    }

    for (ServicePB serviceData : services) {
        for (MethodPB method : serviceData.getMethodsList()) {
            if (method.getDeprecated()) {
                StringBuilder paramList = new StringBuilder();
                for (ParamPB param : method.getParamsList()) {
                    paramList.append(param.getType()).append(",");
                }
                if (paramList.length() != 0) {
                    paramList.deleteCharAt(paramList.length() - 1);
                }
                RequestKey rkey = new RequestKey(serviceData.getName(), method.getName(), paramList.toString());
                Integer rid = requestIDMap.get(rkey);
                if (rid != null) {
                    depReqIds.add(rid);
                }
            }
        }
    }

    if (depReqIds.isEmpty()) {
        return struct;
    }
    StringBuilder depQuery = new StringBuilder();
    for (int i = 0; i < depReqIds.size(); i++) {
        depQuery.append("?");
        if (i < depReqIds.size() - 1) {
            depQuery.append(",");
        }
    }
    depQuery.append(")");

    try (JdbcService jdbc = swagrJdbcFac.newService(SWAGR_SERVICES_DEPRECATED + depQuery.toString())) {
        PreparedStatement ps = jdbc.getPreparedStatement();
        ps.setDate(1, req.hasStartDt() ? new Date(req.getStartDt()) : new Date(startdt.getMillis()));
        ps.setDate(2, req.hasEndDt() ? new Date(req.getEndDt()) : new Date(enddt.getMillis()));
        ps.setString(3, req.hasLocation() ? req.getLocation() : "%");
        ps.setString(4, req.getDataType() == 0 ? "%" : Integer.toString(req.getDataType()));
        int i = 5;
        for (int id : depReqIds) {
            ps.setInt(i++, id);
        }
        ResultSet rs = jdbc.executeQuery();
        sysStatsDailyResSet(rs, struct);
    }
    try (JdbcService jdbc = swagrJdbcFac
            .newService(SWAGR_STRINGS_PREFIX + " WHERE r.id IN (" + depQuery.toString())) {
        PreparedStatement ps = jdbc.getPreparedStatement();

        int i = 1;
        for (int id : depReqIds) {
            ps.setInt(i++, id);
        }
        ResultSet rs = jdbc.executeQuery();
        reqStrings(rs, struct);
        return struct;
    }
}

---

From source file:com.salesmanBuddy.dao.JDBCSalesmanBuddyDAO.java

License:Open Source License

private List<SBEmail> generateIndividualSalesmanSummaryEmailsForDealershipIdReportType(Integer dealershipId,
        Integer reportType) {/*w w  w.ja  va 2  s.  c  o  m*/
    DateTime to = new DateTime(DateTimeZone.UTC);
    DateTime from = null;
    switch (reportType) {
    case DAILY_SALESMAN_SUMMARY_EMAIL_TYPE:
        from = to.minusDays(1).minusMinutes(10);
        break;

    case WEEKLY_SALESMAN_SUMMARY_EMAIL_TYPE:
        from = to.minusWeeks(1).minusMinutes(10);
        break;

    case MONTHLY_SALESMAN_SUMMARY_EMAIL_TYPE:
        from = to.minusMonths(1).minusMinutes(10);
        break;

    default:
        throw new RuntimeException(
                "report type invalid for generateIndividualSalesmanSummaryEmailsForDealershipIdReportType");
    }

    List<UserTree> userTrees = this.getUserTreeForDealershipIdType(dealershipId, reportType);
    List<SBEmail> emails = new ArrayList<>();
    for (UserTree ut : userTrees) {

        try {
            String subject = "Report about " + this.getUsersName(ut.getUserId()).getName()
                    + " from Salesman Buddy";
            String body = this.individualSalesmanSummaryReport(this.getUserByGoogleId(ut.getUserId()).getId(),
                    from, to);
            SBEmail email = SBEmail.newPlainTextEmail(REPORTS_EMAIL, null, subject, body, true);
            email.replaceTo(this.getEmailForGoogleId(ut.getSupervisorId()));
            emails.add(email);
        } catch (UserNameException e) {
            e.printStackTrace();
            JDBCSalesmanBuddyDAO.sendErrorToMe(new StringBuilder().append(
                    "Error in generateIndividualSalesmanSummaryEmailsForDealershipIdReportType for getting user's name for userTree: ")
                    .append(ut.toString()).append(", error: ").append(e.getLocalizedMessage()).toString());
        }
    }
    return emails;
}

---

• «
• 1
• 2
• 3
• 4
• 5
• 6
• 7
• 8
• 9
• 10
• 11
• 12
• 13
• 14
• 15
• 16
• 17
• 18
• 19
• 20
• 21
• 22
• 23
• 24
• 25
• 26
• 27
• 28
• »