Package com.lbslocal.cc.objects.v0.common

Examples of com.lbslocal.cc.objects.v0.common.Pagination

164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
    return extent;
  }

  public Extent getExtentCitySQL(City city, int idLicenca) throws Exception {
    Extent extent = new Extent();

    try {
      if (Functions.IsNullOrEmpty(city.getCountry()))
        city.setCountry("Brasil");

      try {
        Connection con = dataBase.getConnection(Functions.getDataBase(idLicenca, city.getCountry()).getSource());

        CallableStatement cst = con.prepareCall("{call CP_WS_TB_CIDADES_SELECT_FONETICO(?,?,?,?,?)}");
        cst.setString(1, city.getName());
        cst.setString(2, city.getState());
        cst.setInt(3, 1);
        cst.setInt(4, 2);
        cst.setInt(5, 0);

        cst.execute();

        ResultSet rs1 = cst.getResultSet();

        while (rs1.next()) {

          extent.setXMax(rs1.getDouble("xmax"));
          extent.setXMin(rs1.getDouble("xmin"));
          extent.setYMax(rs1.getDouble("ymax"));
          extent.setYMin(rs1.getDouble("ymin"));
          break;
        }
        rs1.close();

        cst.close();
View Full Code Here
391
392
393
394
395
396
397
398
399
400
401
402
403
404
405
406
         
          String XMaxYMax = response.substring(response.indexOf("LLMAX=") + 6); //.substring(0, response.substring(response.indexOf("LLMAX=") + 6).indexOf(Pattern.quote("|")));
          XMaxYMax = XMaxYMax.substring(0, XMaxYMax.indexOf("|"));
          String XMinYMin = response.substring(response.indexOf("LLMIN=") + 6); //.substring(0, response.substring(response.indexOf("LLMIN=") + 6).indexOf(Pattern.quote("%")));
          XMinYMin = XMinYMin.substring(0, XMinYMin.indexOf("%"));
          Extent miEx = new Extent();

          miEx.setXMax(Double.parseDouble(XMaxYMax.split(",")[1].replace(",", ".")));
          miEx.setXMin(Double.parseDouble(XMinYMin.split(",")[1].replace(",", ".")));
          miEx.setYMax(Double.parseDouble(XMaxYMax.split(",")[0].replace(",", ".")));
          miEx.setYMin(Double.parseDouble(XMinYMin.split(",")[0].replace(",", ".")));

          mi.setExtent(miEx);

        } else {
          throw (new Exception("Falha ao gerar mapa"));
View Full Code Here
552
553
554
555
556
557
558
559
560
561
562
  public MapInfo getZoom(String routeId, Extent extent, double percZoom, MapOptions mo, int idLicenca, int methodID) throws Exception {
    MapInfo mi = new MapInfo();

    try {
      /*** Gerar o zoom da imagem ***/
      Extent extTmp = Functions.doZoom(extent, percZoom);
      mi = renderMap(routeId, "", extTmp, mo, idLicenca, methodID);
    } catch (Exception ex) {
      // throw (ex);
      throw (new Exception("getZoom: Falha ao efetuar zoom da imagem."));
    }
View Full Code Here
566
567
568
569
570
571
572
573
574
575
576
  public MapInfo getZoomRadius(String routeId, Point point, int radius, MapOptions mo, int idLicenca, int methodID, String mapType) throws Exception {
    MapInfo mi = new MapInfo();

    try {
      // Envelope env = new EnvelopeClass();
      Extent ext = Functions.CalcRadius(radius, point);
      mi = renderMap(routeId, "", ext, mo, idLicenca, methodID, mapType);
    } catch (Exception ex) {

      Utils.LogError("CC","getZoomRadius - IdWebservice : 7", "point.x -> " + point.getX() + " | " + "point.y -> " + point.getY() + " | "
          + "raio -> " + radius + " | " + ex.getMessage() + "|" + ex.getStackTrace());
View Full Code Here
593
594
595
596
597
598
599
600
601
602
603
  public MapInfo getZoomRadius(String routeId, String routeResponse, Extent extent, MapOptions mo, int idLicenca, int methodID) throws Exception {
    MapInfo mi = new MapInfo();

    try {
      // Envelope env = new EnvelopeClass();
      Extent ext = extent;

      mi = renderMap(routeId, routeResponse, ext, mo, idLicenca, methodID);
    } catch (Exception ex) {

      Utils.LogError("CC","getZoomRadius - IdWebservice : 7", ex.getMessage() + "|" + ex.getStackTrace());
View Full Code Here
610
611
612
613
614
615
616
617
618
619
620
  public MapInfo getZoomWindow(String routeId, Extent oldExtent, Extent newExtentInPixels, MapOptions mo, int idLicenca, int methodID)
      throws Exception {
    MapInfo mi = new MapInfo();

    try {
      Extent newExtent = getNewExtent(oldExtent, newExtentInPixels, mo.getMapSize());
      mi = renderMap(routeId, "", newExtent, mo, idLicenca, methodID);

    } catch (Exception ex) {

      Utils.LogError("CC","getZoomWindow- IdWebservice : 8", ex.getMessage() + "|" + ex.getStackTrace());
View Full Code Here
681
682
683
684
685
686
687
688
689
690
691
    MapInfo mi = new MapInfo();

    try {
      Point point = new Point(-62.9569009522848, -21.3320991286825);

      Extent ext = Functions.CalcRadius(3800045, point);

      mi = renderMap(routeId, "", ext, mo, idLicenca, methodID);
    } catch (Exception ex) {
      Utils.LogError("CC","getZoomFullExtent- IdWebservice : 3", ex.getMessage() + "|" + ex.getStackTrace());
View Full Code Here
228
229
230
231
232
233
234
235
236
  public static Extent CalcRadius(Integer radius, Point point) {
    /*** Calcula o extent do raio ***/
    double raio = radius * 9.7125097125097125097125097125097e-6;

    // Envelope env = new EnvelopeClass();
    Extent ext = new Extent(point.getX() - raio, point.getY() - raio, point.getX() + raio, point.getY() + raio);

    return ext;
  }
View Full Code Here
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
      String fields = po.getFieldList();
      String orderBy = "";
     
      fields = fields.replace("|", ",");
     
      Extent ext = new Extent();
     
      double raio = radius * 9.7125097125097125097125097125097e-6;
     
      ext.setXMin(point.getX() - raio);
      ext.setXMax(point.getX() + raio);
      ext.setYMin(point.getY() + raio);
      ext.setYMax(point.getY() - raio);
     
      if (fields.split(Pattern.quote(",")).length > 0)
        orderBy = " , " + fields.split(Pattern.quote(","))[0];
     
      if (whereClause[0] != "")
        whereClause[0] = "and " + whereClause[0];
     
      strSelect = "select count(1) as total from dados_clientes." + tb[i] + " where x<>0 and ((x>=" + ext.getXMin() + " and x<=" + ext.getXMax() + ") and (y>=" + ext.getYMin() + " and y<="
          + ext.getYMax() + "))" + whereClause[0];
     
      Connection con = dataBase.getConnection("DADOS_WEBSERVICES");
     
      Statement st = con.createStatement();
      ResultSet rr = st.executeQuery(strSelect.toUpperCase());
     
      rr.next();
      int nrReg = rr.getInt("total");
     
      rr.close();
      st.close();
      con.close();
     
      if (po.getResultRange().getRecordsPerPage() > 50)
        po.getResultRange().setRecordsPerPage(50);
     
      if (po.getResultRange().getRecordsPerPage() < 1)
        po.getResultRange().setRecordsPerPage(5);
     
      Pagination pg = Functions.definePage(nrReg, po.getResultRange().getRecordsPerPage(), po.getResultRange().getPageIndex());
     
      strSelect = "select tabela, x, y, 102960 *  SQRT(POWER(x - " + point.getX() + ",2) + POWER(y - " + point.getY() + ",2)) as distancia, " + fields + " from dados_clientes." + tb[i]
          + " where x<>0 and ((x>=" + ext.getXMin() + " and x<=" + ext.getXMax() + ") and (y>=" + ext.getYMin() + " and y<=" + ext.getYMax() + "))" + whereClause[0] + " order by distancia "
          + orderBy + " LIMIT " + (pg.getRecordsInitial() - 1) + "," + (pg.getRecordsFinal());
     
      con = dataBase.getConnection("DADOS_WEBSERVICES");
     
      st = con.createStatement();
View Full Code Here
147
148
149
150
151
152
153
154
155
156
157
      routeOptions.getVehicle().setTollFeeCat(ro.getVehicle().getTollFeeCat());
      CommonRoute r = new CommonRoute(_maquina, _server, _port, _output, _dns, _dataSource, _dataSourceMapa);
      rpi = r.getRoute(idLicenca, rs, routeOptions, CommonRoute._getRoute);
     
      ri.setMapInfo(new MapInfo());
      ri.getMapInfo().setExtent(new Extent());
      ri.getMapInfo().getExtent().setXMax(rpi.getMapInfo().getExtent().getXMax());
      ri.getMapInfo().getExtent().setXMin(rpi.getMapInfo().getExtent().getXMin());
      ri.getMapInfo().getExtent().setYMax(rpi.getMapInfo().getExtent().getYMax());
      ri.getMapInfo().getExtent().setYMin(rpi.getMapInfo().getExtent().getYMin());
      ri.getMapInfo().setUrl(rpi.getMapInfo().getUrl());
View Full Code Here
TOP

Related Classes of com.lbslocal.cc.objects.v0.common.Pagination

  • com.lbslocal.api.connect.ControlAddressFinder
  • com.lbslocal.api.connect.ControlMapRender
  • com.lbslocal.api.connect.ControlRoute
  • com.lbslocal.api.view.AddressFinder
  • com.lbslocal.api.view.MapRender
  • com.lbslocal.api.view.Route
  • com.lbslocal.cc.common.Functions
  • com.lbslocal.cc.core.CommonAddress
  • com.lbslocal.cc.core.CommonMap
  • com.lbslocal.cc.core.CommonProximity
    • Copyright © 2018 www.massapicom. 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.