MobileApp

//@Configuration
public class RedisConfiguration {

用户管理：
http://127.0.0.1:9006/form/rest/user

更新测试方案
    @RunWith(SpringJUnit4ClassRunner.class)
    @SpringApplicationConfiguration(classes = Application.class)
    @WebAppConfiguration
    public class MongoDBGeoSpatialTest {
    
    <dependency>
        <groupId>org.springframework.boot</groupId>
        <artifactId>spring-boot-starter-test</artifactId>
        <scope>test</scope>
    </dependency>
 
------------------------------------
com.supermy.geo已经移植到push-server;代码暂不删除。

完成rbac 权限模型样例数据

微服务基础框架准备已经完成。

extjs-filter 已经移植到es-query;详见web+app;
清除原有filter的代码改造 ok；
升级spring-boot1.2.7 ok;
升级spring-boot1.3.5 ok;

{"DATA":
    [{"deleted":null,"enabled":null,"createDate":"2016-07-14T00:00:00.000+0800","createBy":"","updateDate":"2016-07-14T09:55:50.000+0800","updateBy":"","name":"xyz","code":"xyz","pwd":"\u79d8\u94a5","tokenExpire":90,"iplist":"bb","ipBindtime":300,"ipTimeout":60,"connectCount":100,"limitBandwidth":"3000","status":false,
        "pkId":4,"_links":{"self":{"href":"http://172.16.71.56:9006/form/rest/channel_auth/filter/channel_auth/4","templated":false}},"_embedded":{}},
     {"deleted":null,"enabled":null,"createDate":"2016-07-14T00:00:00.000+0800","createBy":"system1","updateDate":"2016-07-14T09:48:29.000+0800","updateBy":"system2","name":"test","code":"test","pwd":"test","tokenExpire":1,"iplist":"192.168.59.103","ipBindtime":300,"ipTimeout":61,"connectCount":100,"limitBandwidth":"100","status":true,
        "pkId":1,"_links":{"self":{"href":"http://172.16.71.56:9006/form/rest/channel_auth/filter/channel_auth/1","templated":false}},"_embedded":{}},
     {"deleted":null,"enabled":null,"createDate":"2016-07-14T00:00:00.000+0800","createBy":"","updateDate":"2016-07-14T09:55:46.000+0800","updateBy":"","name":"abc","code":"abc","pwd":"\u79d8\u94a5","tokenExpire":90,"iplist":"aa","ipBindtime":300,"ipTimeout":60,"connectCount":100,"limitBandwidth":"2000","status":false,
        "pkId":3,"_links":{"self":{"href":"http://172.16.71.56:9006/form/rest/channel_auth/filter/channel_auth/3","templated":false}},"_embedded":{}}],
 "PAGE":{"size":23,"totalElements":3,"totalPages":1,"number":0}}
 
 {"DATA":
    {"_links":{},"_embedded":{"channel_auth":[{"deleted":null,"code":"test","pkId":1,"pwd":"test","connectCount":100,"enabled":null,"limitBandwidth":"100","ipBindtime":300,"updateBy":"system2","updateDate":"2016-07-14T09:48:29.000+0800","createDate":"2016-07-14T00:00:00.000+0800","tokenExpire":1,"_links":{"self":{"href":"http:\/\/172.16.71.56\/form\/rest\/channel_auth\/1","templated":false}},"name":"test","_embedded":{},"iplist":"192.168.59.103","createBy":"system1","status":true,"ipTimeout":61}]}},
 "PAGE":{"page":{"totalElements":30}}}
 
 
extjs 要求的返回值
更新：单个记录与总记录数量
删除：result response:......{"DATA":{},"PAGE":{"page":{"totalElements":2}}}

http://127.0.0.1:9006/form/rest/channel_auth/filter?_dc=1467884593669&sort=name%2CASC&sort=code%2CDESC&page=0&filter=%5B%7B%22type%22%3A%22string%22%2C%22value%22%3A%22test%22%2C%22field%22%3A%22name%22%7D%2C%7B%22type%22%3A%22string%22%2C%22value%22%3A%22test%22%2C%22field%22%3A%22code%22%7D%5D&start=0&size=23

_dc=1467884593669
sort=name,ASC
sort=code,DESC
page=0
filter=[{"type":"string","value":"test","field":"name"},
        {"type":"string","value":"test","field":"code"}]
start=0
size=23

走extjs[get]->nginx-lua[post]->直接发送到 es;
{
"query": {
  "bool": {
    "must": {//必须符合以下条件
      "term": {
        "name": "test"
      }
    },
    "should": {//满足其中某个条件
      "term": {
        "name": "test"
      }
    },
    "must_not": {//不能符合以下条件
      "term": {
        "code": "test1"
      }
    }
  }
},
"from": 0, //分页
"size": 1,
"sort": {  //排序
  "code": {
    "order": "desc"
  }
}
}

指令采用json 格式传递,不采用POJO 序列化;
redis+lua 进行抢红包/秒杀/抢单的核心实现;



字符串解析成JavaBean：当数据量较少时首选FastJson，数据量较大使用Jackson。但是Jackson无法堆一个对象集合进行解析，只能转成一个Map集合，这点Gson和FastJson处理的比较好。
字符串解析成JSON：当数据量较少时首选FastJson，数据量较大使用Jackson。
JavaBean构造JSON：当数据量较少时选择Gson，数据量较大可使用Jackson。
集合构造JSON：首先Jackson，其次Fastjson。

todo 优化 com.fasterxml.jackson.core 的应用

匹配订单,向司机发送订单信息完成.


订单信息格式
o:流水号

    > db.location.save( {_id: "18610586581", position: [0.1, -0.1]} )
    > db.location.save( {_id: "18610586582", position: [1.0, 1.0]} )
    > db.location.save( {_id: "18610586583", position: [0.5, 0.5]} )
    > db.location.save( {_id: "18610586584", position: [-0.5, -0.5]} )
     
    接着指定location索引
    > db.location.ensureIndex( {position: "2d"} )

通过单ip 访问频率,控制用户访问频率;

todo:条件组合查询使用es 进行改造;

geo LBS 服务圆圈查询
http://127.0.0.1:9006/form/rest/webgeo/circle?x1=0.0&y1=0.0&bj=0.7
http://127.0.0.1:9006/form/rest/webgeo/circle?x1=0.0&y1=0.0&bj=0.75
http://127.0.0.1:9006/form/rest/webgeo/near?x1=0.1&y1=0.1&bj=700
http://127.0.0.1:9006/form/rest/webgeo/near?x1=0.1&y1=0.1&bj=750

准备数据
首先定义一个位置集合,给定a,b,c,d节点.
> db.createCollection("location")
{ "ok" : 1 }
> db.location.save( {_id: "A", position: [0.1, -0.1]} )
> db.location.save( {_id: "B", position: [1.0, 1.0]} )
> db.location.save( {_id: "C", position: [0.5, 0.5]} )
> db.location.save( {_id: "D", position: [-0.5, -0.5]} )
 
接着指定location索引
db.location.ensureIndex( {position: "2d"} )
现在我们可以进行简单的GEO查询

查询point(0,0),半径0.7附近的点
> db.location.find( {position: { $near: [0,0], $maxDistance: 0.7  } } )
{ "_id" : "A", "position" : [ 0.1, -0.1 ] }
 
查询point(0,0),半径0.75附近的点 
> db.location.find( {position: { $near: [0,0], $maxDistance: 0.75  } } )
{ "_id" : "A", "position" : [ 0.1, -0.1 ] }
{ "_id" : "C", "position" : [ 0.5, 0.5 ] }
{ "_id" : "D", "position" : [ -0.5, -0.5 ] }
 
我们可以看到半径不一样,查询出的点也不一样,因为c点坐标为[0.5,0.5],c至圆点的距离根据勾股定理可得出Math.sqrt(0.25 +0.25) ≈ 0.707,所以最大距离0.7时查找不到你要的点.

查询[0.25, 0.25], [1.0,1.0]区域附近的点
> db.location.find( {position: { $within: { $box: [ [0.25, 0.25], [1.0,1.0] ] }  } } )
{ "_id" : "C", "position" : [ 0.5, 0.5 ] }
{ "_id" : "B", "position" : [ 1, 1 ] }

解决方案
@JsonFormat进行时区处理；处理完成送到数据库，处理完成送到 response; 前端根据显示需要显示所需的格式。
 
mysql -u app -p
mysql> set @@global.show_compatibility_56=ON;
    

实体类的get方法就需要多一个@JsonFormat的注解配置
@DateTimeFormat(pattern="yyyy-MM-dd HH:mm:ss")  
@JsonFormat(pattern="yyyy-MM-dd HH:mm:ss",timezone = "GMT+8")  
public Date getCreateTime() {  
return this.createTime;  
}  
@DateTimeFormat(pattern="yyyy-MM-dd")  
@JsonFormat(pattern="yyyy-MM-dd",timezone = "GMT+8")  
public Date getBirthday() {  
    return this.birthday;  
}  

调整之后访问路径
http://127.0.0.1:9006/form/rest/public/channel.html

美化SQL 语句    
hibernate.show_sql=true
hibernate.use_sql_comments=true
hibernate.format_sql=true

application.properties 配置
server.context-path=/rest/api

nginx 配置
    location /rest {
            proxy_pass http://133.224.220.66:9000/rest;
    }

mvn package spring-boot:repackage
生成的war 不能正常加载到 tomcat

http://www.thetekblog.com/2014/03/upgrading-to-hibernate-4-3-4-final-nosuchmethod/
http://docs.spring.io/spring-boot/docs/current/reference/html/build-tool-plugins-maven-plugin.html
http://docs.spring.io/spring-boot/docs/current/reference/html/howto-database-initialization.html

spring-boot 按class生成时间进行加载没有解决

Extjs grid 的下拉选项与显示预处理完成

两个老问题圆满解决。
extjs grid filter 条件编辑面板在chrome 浏览器下失效的问题解决；
行编辑器保存按钮，在数据正确之后不能自动变回的问题解决。

修正日期 boolean 类型的过滤

内部整合 todo?
http://127.0.0.1:8080/channel_auth/filter/?_dc=1435308762365&sort=name%2CASC&sort=code%2CDESC&page=0&filter=%5B%7B%22type%22%3A%22numeric%22%2C%22comparison%22%3A%22lt%22%2C%22value%22%3A6%2C%22field%22%3A%22id%22%7D%2C%7B%22type%22%3A%22numeric%22%2C%22comparison%22%3A%22gt%22%2C%22value%22%3A2%2C%22field%22%3A%22id%22%7D%2C%7B%22type%22%3A%22string%22%2C%22value%22%3A%2212%22%2C%22field%22%3A%22code%22%7D%2C%7B%22type%22%3A%22boolean%22%2C%22value%22%3Atrue%2C%22field%22%3A%22status%22%7D%2C%7B%22type%22%3A%22date%22%2C%22comparison%22%3A%22lt%22%2C%22value%22%3A11212212%2C%22field%22%3A%22createDate%22%7D%5D&start=0&size=10

Pageable and PageRequest 增加参数 MyFilter;
SimpleJpaRepository 增加filter 参数处理判断；
增加MyRepositoryEntityController，增加/{repository}/filter入口

todo:
        lua  template 简化消费者的前端使用。

//废除
AbstractPageRequest1
public int getOffset() {//fixme jamesmo 2016-06-23 解决page=1传递进来，其实计算错误的问题。
    return (page-1) * size;
}

filter test url
http://127.0.0.1:8080/channel_auth/filter/?_dc=1435308762365&sort=name%2CASC&sort=code%2CDESC&page=0&filter=%5B%7B%22type%22%3A%22numeric%22%2C%22comparison%22%3A%22lt%22%2C%22value%22%3A6%2C%22field%22%3A%22pkId%22%7D%2C%7B%22type%22%3A%22numeric%22%2C%22comparison%22%3A%22gt%22%2C%22value%22%3A2%2C%22field%22%3A%22pkId%22%7D%2C%7B%22type%22%3A%22string%22%2C%22value%22%3A%2212%22%2C%22field%22%3A%22code%22%7D%2C%7B%22type%22%3A%22boolean%22%2C%22value%22%3Atrue%2C%22field%22%3A%22status%22%7D%2C%7B%22type%22%3A%22date%22%2C%22comparison%22%3A%22lt%22%2C%22value%22%3A%2206%2F26%2F2015%22%2C%22field%22%3A%22createDate%22%7D%5D&start=0&size=10

Thymeleaf是一个XML/XHTML/HTML5模板引擎，可用于Web与非Web环境中的应用开发
Thymeleaf提供了一个用于整合Spring MVC的可选模块，在应用开发中，你可以使用Thymeleaf来完全代替JSP，或其他模板引擎，如Velocity、
FreeMarker等。Thymeleaf的主要目标在于提供一种可被浏览器正确显示的、格式良好的模板创建方式，因此也可以用作静态建模。你可以使用它
创建经过验证的XML与HTML模板。相对于编写逻辑或代码，开发者只需将标签属性添加到模板中即可。接下来，这些标签属性就会在DOM（文档对象
模型）上执行预先制定好的逻辑。

# 代表 获取对象 从 messages bundle 也就是消息的资源本地化文件
$ 表示从model里面获取
# $这2个可以一起用 比如#{'system.'+${model.id}}  -----这相当于 #{system.01}的资源本地化文件中的system.01内容
表达式基本对象：
        #ctx：context object
        #root或者#vars
        #locale
        #httpServletRequest
        #httpSession
         
        表达式功能对象：
        #dates：java.util.Date的功能方法类。
        #calendars:类似#dates，面向java.util.Calendar
        #numbers:格式化数字的功能方法类。
        #strings：字符串对象的功能类，contains,startWiths,prepending/appending等等。
        #objects:对objects的功能类操作。
        #bools:对布尔值求值的功能方法。
        #arrays：对数组的功能类方法。
        #lists:对lists功能类方法
        #sets
        #maps
        #aggregates:对数组或者集合创建聚合的功能方法，
        th:text="${#aggregates.sum(o.orderLines.{purchasePrice * amount})}"
         
        #messages:在变量表达式中获取外部信息的功能类方法。
        #ids：处理可能重复的id属性的功能类方法。

        <table>
          <thead>
            <tr>
              <th th:text="#{msgs.headers.name}">Name</th>
              <th th:text="#{msgs.headers.price}">Price</th>
            </tr>
          </thead>
          <tbody>
            <tr th:each="prod : ${allProducts}">
              <td th:text="${prod.name}">Oranges</td>
              <td th:text="${#numbers.formatDecimal(prod.price,1,2)}">0.99</td>
            </tr>
          </tbody>
        </table>

http://127.0.0.1:8080/people/
http://127.0.0.1:8080/people/1
http://127.0.0.1:8080/people/?page=1&size=2&sort=firstName
http://127.0.0.1:8080/people/?page=1&size=2&sort=firstName,asc

http://127.0.0.1:8080/people/search
http://127.0.0.1:8080/people/search/findByLastName?name=客气
http://127.0.0.1:8080/people/search/findByFirstNameLike?firstName=实施跟踪12%  --通配符号需要转码
http://127.0.0.1:8080/people/search/findByEmailAddress?lname=施跟踪2
http://127.0.0.1:8080/people/search/findByName?name1=跟踪12&name2=气

java -jar target/gs-accessing-data-rest-0.1.0.jar

rest excetion 信息控制