/src/test/java/com/alibaba/json/bvt/bug/Bug_for_yangzhou.java

https://github.com/alibaba/fastjson · Java · 1143 lines · 907 code · 234 blank · 2 comment · 19 complexity · 2a154d7c8af30d38fbc57bc814a7830b MD5 · raw file

  1. package com.alibaba.json.bvt.bug;
  2. import com.alibaba.fastjson.JSON;
  3. import com.alibaba.fastjson.JSONObject;
  4. import junit.framework.TestCase;
  5. import java.util.ArrayList;
  6. import java.util.Date;
  7. import java.util.List;
  8. public class Bug_for_yangzhou extends TestCase {
  9. public void test_for_issue() throws Exception {
  10. String test = "{\"distinct\":false,\"oredCriteria\":[{\"allCriteria\":[{\"betweenValue\":false,\"condition\":\"area_id =\",\"listValue\":false,\"noValue\":false,\"singleValue\":true,\"value\":917477670000000000},{\"betweenValue\":false,\"condition\":\"cabinet_id =\",\"listValue\":false,\"noValue\":false,\"singleValue\":true,\"value\":500036},{\"betweenValue\":false,\"condition\":\"status =\",\"listValue\":false,\"noValue\":false,\"singleValue\":true,\"value\":0}],\"criteria\":[{\"$ref\":\"$.oredCriteria[0].allCriteria[0]\"},{\"$ref\":\"$.oredCriteria[0].allCriteria[1]\"},{\"$ref\":\"$.oredCriteria[0].allCriteria[2]\"}],\"valid\":true}],\"page\":true,\"pageIndex\":0,\"pageSize\":1,\"pageStart\":1}";
  11. System.out.println(test);
  12. CabinetAuthCodeParam cabinetAuthCodeParam = JSONObject.toJavaObject(JSON.parseObject(test), CabinetAuthCodeParam.class);
  13. System.out.println(JSON.toJSONString(cabinetAuthCodeParam));
  14. final String jsonString = JSON.toJSONString(cabinetAuthCodeParam);
  15. assertEquals("{\"distinct\":false,\"oredCriteria\":[{\"allCriteria\":[{\"listValue\":false,\"noValue\":false,\"condition\":\"area_id =\",\"betweenValue\":false,\"singleValue\":true,\"value\":917477670000000000},{\"listValue\":false,\"noValue\":false,\"condition\":\"cabinet_id =\",\"betweenValue\":false,\"singleValue\":true,\"value\":500036},{\"listValue\":false,\"noValue\":false,\"condition\":\"status =\",\"betweenValue\":false,\"singleValue\":true,\"value\":0}],\"criteria\":[{\"$ref\":\"$.oredCriteria[0].allCriteria[0]\"},{\"$ref\":\"$.oredCriteria[0].allCriteria[1]\"},{\"$ref\":\"$.oredCriteria[0].allCriteria[2]\"}],\"valid\":true}],\"page\":true,\"pageIndex\":0,\"pageSize\":1,\"pageStart\":1}", jsonString);
  16. // CabinetAuthCodeRecordParam cabinetAuthCodeRecordParam = JSONObject.toJavaObject(JSON.parseObject(jsonString), CabinetAuthCodeRecordParam.class);
  17. // System.out.println(JSON.toJSONString(cabinetAuthCodeRecordParam));
  18. }
  19. public static class CabinetAuthCodeParam {
  20. protected String orderByClause;
  21. protected boolean distinct;
  22. protected boolean page;
  23. protected int pageIndex;
  24. protected int pageSize;
  25. protected int pageStart;
  26. protected List<Criteria> oredCriteria;
  27. public CabinetAuthCodeParam() {
  28. oredCriteria = new ArrayList<Criteria>();
  29. }
  30. public CabinetAuthCodeParam appendOrderByClause(OrderCondition orderCondition, SortType sortType) {
  31. if (null != orderByClause) {
  32. orderByClause = orderByClause + ", " + orderCondition.getColumnName() + " " + sortType.getValue();
  33. } else {
  34. orderByClause = orderCondition.getColumnName() + " " + sortType.getValue();
  35. }
  36. return this;
  37. }
  38. public String getOrderByClause() {
  39. return orderByClause;
  40. }
  41. public void setDistinct(boolean distinct) {
  42. this.distinct = distinct;
  43. }
  44. public boolean isDistinct() {
  45. return distinct;
  46. }
  47. public void setPage(boolean page) {
  48. this.page = page;
  49. }
  50. public boolean isPage() {
  51. return page;
  52. }
  53. public int getPageIndex() {
  54. return pageIndex;
  55. }
  56. public void setPageSize(int pageSize) {
  57. this.pageSize = pageSize < 1 ? 10 : pageSize;
  58. this.pageIndex = pageStart < 1 ? 0 : (pageStart - 1) * this.pageSize;
  59. }
  60. public int getPageSize() {
  61. return pageSize;
  62. }
  63. public void setPageStart(int pageStart) {
  64. this.pageStart = pageStart < 1 ? 1 : pageStart;
  65. this.pageIndex = (this.pageStart - 1) * this.pageSize;
  66. }
  67. public int getPageStart() {
  68. return pageStart;
  69. }
  70. public List<Criteria> getOredCriteria() {
  71. return oredCriteria;
  72. }
  73. public void or(Criteria criteria) {
  74. oredCriteria.add(criteria);
  75. }
  76. public Criteria or() {
  77. Criteria criteria = createCriteriaInternal();
  78. oredCriteria.add(criteria);
  79. return criteria;
  80. }
  81. public Criteria createCriteria() {
  82. Criteria criteria = createCriteriaInternal();
  83. if (oredCriteria.size() == 0) {
  84. oredCriteria.add(criteria);
  85. }
  86. return criteria;
  87. }
  88. protected Criteria createCriteriaInternal() {
  89. Criteria criteria = new Criteria();
  90. return criteria;
  91. }
  92. public void clear() {
  93. oredCriteria.clear();
  94. orderByClause = null;
  95. distinct = false;
  96. }
  97. protected abstract static class GeneratedCriteria {
  98. protected List<Criterion> criteria;
  99. protected GeneratedCriteria() {
  100. super();
  101. criteria = new ArrayList<Criterion>();
  102. }
  103. public boolean isValid() {
  104. return criteria.size() > 0;
  105. }
  106. public List<Criterion> getAllCriteria() {
  107. return criteria;
  108. }
  109. public List<Criterion> getCriteria() {
  110. return criteria;
  111. }
  112. protected void addCriterion(String condition) {
  113. if (condition == null) {
  114. throw new RuntimeException("Value for condition cannot be null");
  115. }
  116. criteria.add(new Criterion(condition));
  117. }
  118. protected void addCriterion(String condition, Object value, String property) {
  119. if (value == null) {
  120. throw new RuntimeException("Value for " + property + " cannot be null");
  121. }
  122. criteria.add(new Criterion(condition, value));
  123. }
  124. protected void addCriterion(String condition, Object value1, Object value2, String property) {
  125. if (value1 == null || value2 == null) {
  126. throw new RuntimeException("Between values for " + property + " cannot be null");
  127. }
  128. criteria.add(new Criterion(condition, value1, value2));
  129. }
  130. public Criteria andIdIsNull() {
  131. addCriterion("id is null");
  132. return (Criteria) this;
  133. }
  134. public Criteria andIdIsNotNull() {
  135. addCriterion("id is not null");
  136. return (Criteria) this;
  137. }
  138. public Criteria andIdEqualTo(Long value) {
  139. addCriterion("id =", value, "id");
  140. return (Criteria) this;
  141. }
  142. public Criteria andIdNotEqualTo(Long value) {
  143. addCriterion("id <>", value, "id");
  144. return (Criteria) this;
  145. }
  146. public Criteria andIdGreaterThan(Long value) {
  147. addCriterion("id >", value, "id");
  148. return (Criteria) this;
  149. }
  150. public Criteria andIdGreaterThanOrEqualTo(Long value) {
  151. addCriterion("id >=", value, "id");
  152. return (Criteria) this;
  153. }
  154. public Criteria andIdLessThan(Long value) {
  155. addCriterion("id <", value, "id");
  156. return (Criteria) this;
  157. }
  158. public Criteria andIdLessThanOrEqualTo(Long value) {
  159. addCriterion("id <=", value, "id");
  160. return (Criteria) this;
  161. }
  162. public Criteria andIdIn(List<Long> values) {
  163. addCriterion("id in", values, "id");
  164. return (Criteria) this;
  165. }
  166. public Criteria andIdNotIn(List<Long> values) {
  167. addCriterion("id not in", values, "id");
  168. return (Criteria) this;
  169. }
  170. public Criteria andIdBetween(Long value1, Long value2) {
  171. addCriterion("id between", value1, value2, "id");
  172. return (Criteria) this;
  173. }
  174. public Criteria andIdNotBetween(Long value1, Long value2) {
  175. addCriterion("id not between", value1, value2, "id");
  176. return (Criteria) this;
  177. }
  178. public Criteria andGmtCreateIsNull() {
  179. addCriterion("gmt_create is null");
  180. return (Criteria) this;
  181. }
  182. public Criteria andGmtCreateIsNotNull() {
  183. addCriterion("gmt_create is not null");
  184. return (Criteria) this;
  185. }
  186. public Criteria andGmtCreateEqualTo(Date value) {
  187. addCriterion("gmt_create =", value, "gmtCreate");
  188. return (Criteria) this;
  189. }
  190. public Criteria andGmtCreateNotEqualTo(Date value) {
  191. addCriterion("gmt_create <>", value, "gmtCreate");
  192. return (Criteria) this;
  193. }
  194. public Criteria andGmtCreateGreaterThan(Date value) {
  195. addCriterion("gmt_create >", value, "gmtCreate");
  196. return (Criteria) this;
  197. }
  198. public Criteria andGmtCreateGreaterThanOrEqualTo(Date value) {
  199. addCriterion("gmt_create >=", value, "gmtCreate");
  200. return (Criteria) this;
  201. }
  202. public Criteria andGmtCreateLessThan(Date value) {
  203. addCriterion("gmt_create <", value, "gmtCreate");
  204. return (Criteria) this;
  205. }
  206. public Criteria andGmtCreateLessThanOrEqualTo(Date value) {
  207. addCriterion("gmt_create <=", value, "gmtCreate");
  208. return (Criteria) this;
  209. }
  210. public Criteria andGmtCreateIn(List<Date> values) {
  211. addCriterion("gmt_create in", values, "gmtCreate");
  212. return (Criteria) this;
  213. }
  214. public Criteria andGmtCreateNotIn(List<Date> values) {
  215. addCriterion("gmt_create not in", values, "gmtCreate");
  216. return (Criteria) this;
  217. }
  218. public Criteria andGmtCreateBetween(Date value1, Date value2) {
  219. addCriterion("gmt_create between", value1, value2, "gmtCreate");
  220. return (Criteria) this;
  221. }
  222. public Criteria andGmtCreateNotBetween(Date value1, Date value2) {
  223. addCriterion("gmt_create not between", value1, value2, "gmtCreate");
  224. return (Criteria) this;
  225. }
  226. public Criteria andGmtModifiedIsNull() {
  227. addCriterion("gmt_modified is null");
  228. return (Criteria) this;
  229. }
  230. public Criteria andGmtModifiedIsNotNull() {
  231. addCriterion("gmt_modified is not null");
  232. return (Criteria) this;
  233. }
  234. public Criteria andGmtModifiedEqualTo(Date value) {
  235. addCriterion("gmt_modified =", value, "gmtModified");
  236. return (Criteria) this;
  237. }
  238. public Criteria andGmtModifiedNotEqualTo(Date value) {
  239. addCriterion("gmt_modified <>", value, "gmtModified");
  240. return (Criteria) this;
  241. }
  242. public Criteria andGmtModifiedGreaterThan(Date value) {
  243. addCriterion("gmt_modified >", value, "gmtModified");
  244. return (Criteria) this;
  245. }
  246. public Criteria andGmtModifiedGreaterThanOrEqualTo(Date value) {
  247. addCriterion("gmt_modified >=", value, "gmtModified");
  248. return (Criteria) this;
  249. }
  250. public Criteria andGmtModifiedLessThan(Date value) {
  251. addCriterion("gmt_modified <", value, "gmtModified");
  252. return (Criteria) this;
  253. }
  254. public Criteria andGmtModifiedLessThanOrEqualTo(Date value) {
  255. addCriterion("gmt_modified <=", value, "gmtModified");
  256. return (Criteria) this;
  257. }
  258. public Criteria andGmtModifiedIn(List<Date> values) {
  259. addCriterion("gmt_modified in", values, "gmtModified");
  260. return (Criteria) this;
  261. }
  262. public Criteria andGmtModifiedNotIn(List<Date> values) {
  263. addCriterion("gmt_modified not in", values, "gmtModified");
  264. return (Criteria) this;
  265. }
  266. public Criteria andGmtModifiedBetween(Date value1, Date value2) {
  267. addCriterion("gmt_modified between", value1, value2, "gmtModified");
  268. return (Criteria) this;
  269. }
  270. public Criteria andGmtModifiedNotBetween(Date value1, Date value2) {
  271. addCriterion("gmt_modified not between", value1, value2, "gmtModified");
  272. return (Criteria) this;
  273. }
  274. public Criteria andAreaIdIsNull() {
  275. addCriterion("area_id is null");
  276. return (Criteria) this;
  277. }
  278. public Criteria andAreaIdIsNotNull() {
  279. addCriterion("area_id is not null");
  280. return (Criteria) this;
  281. }
  282. public Criteria andAreaIdEqualTo(Long value) {
  283. addCriterion("area_id =", value, "areaId");
  284. return (Criteria) this;
  285. }
  286. public Criteria andAreaIdNotEqualTo(Long value) {
  287. addCriterion("area_id <>", value, "areaId");
  288. return (Criteria) this;
  289. }
  290. public Criteria andAreaIdGreaterThan(Long value) {
  291. addCriterion("area_id >", value, "areaId");
  292. return (Criteria) this;
  293. }
  294. public Criteria andAreaIdGreaterThanOrEqualTo(Long value) {
  295. addCriterion("area_id >=", value, "areaId");
  296. return (Criteria) this;
  297. }
  298. public Criteria andAreaIdLessThan(Long value) {
  299. addCriterion("area_id <", value, "areaId");
  300. return (Criteria) this;
  301. }
  302. public Criteria andAreaIdLessThanOrEqualTo(Long value) {
  303. addCriterion("area_id <=", value, "areaId");
  304. return (Criteria) this;
  305. }
  306. public Criteria andAreaIdIn(List<Long> values) {
  307. addCriterion("area_id in", values, "areaId");
  308. return (Criteria) this;
  309. }
  310. public Criteria andAreaIdNotIn(List<Long> values) {
  311. addCriterion("area_id not in", values, "areaId");
  312. return (Criteria) this;
  313. }
  314. public Criteria andAreaIdBetween(Long value1, Long value2) {
  315. addCriterion("area_id between", value1, value2, "areaId");
  316. return (Criteria) this;
  317. }
  318. public Criteria andAreaIdNotBetween(Long value1, Long value2) {
  319. addCriterion("area_id not between", value1, value2, "areaId");
  320. return (Criteria) this;
  321. }
  322. public Criteria andAuthCodeIsNull() {
  323. addCriterion("auth_code is null");
  324. return (Criteria) this;
  325. }
  326. public Criteria andAuthCodeIsNotNull() {
  327. addCriterion("auth_code is not null");
  328. return (Criteria) this;
  329. }
  330. public Criteria andAuthCodeEqualTo(String value) {
  331. addCriterion("auth_code =", value, "authCode");
  332. return (Criteria) this;
  333. }
  334. public Criteria andAuthCodeNotEqualTo(String value) {
  335. addCriterion("auth_code <>", value, "authCode");
  336. return (Criteria) this;
  337. }
  338. public Criteria andAuthCodeGreaterThan(String value) {
  339. addCriterion("auth_code >", value, "authCode");
  340. return (Criteria) this;
  341. }
  342. public Criteria andAuthCodeGreaterThanOrEqualTo(String value) {
  343. addCriterion("auth_code >=", value, "authCode");
  344. return (Criteria) this;
  345. }
  346. public Criteria andAuthCodeLessThan(String value) {
  347. addCriterion("auth_code <", value, "authCode");
  348. return (Criteria) this;
  349. }
  350. public Criteria andAuthCodeLessThanOrEqualTo(String value) {
  351. addCriterion("auth_code <=", value, "authCode");
  352. return (Criteria) this;
  353. }
  354. public Criteria andAuthCodeLike(String value) {
  355. addCriterion("auth_code like", value, "authCode");
  356. return (Criteria) this;
  357. }
  358. public Criteria andAuthCodeNotLike(String value) {
  359. addCriterion("auth_code not like", value, "authCode");
  360. return (Criteria) this;
  361. }
  362. public Criteria andAuthCodeIn(List<String> values) {
  363. addCriterion("auth_code in", values, "authCode");
  364. return (Criteria) this;
  365. }
  366. public Criteria andAuthCodeNotIn(List<String> values) {
  367. addCriterion("auth_code not in", values, "authCode");
  368. return (Criteria) this;
  369. }
  370. public Criteria andAuthCodeBetween(String value1, String value2) {
  371. addCriterion("auth_code between", value1, value2, "authCode");
  372. return (Criteria) this;
  373. }
  374. public Criteria andAuthCodeNotBetween(String value1, String value2) {
  375. addCriterion("auth_code not between", value1, value2, "authCode");
  376. return (Criteria) this;
  377. }
  378. public Criteria andCabinetIdIsNull() {
  379. addCriterion("cabinet_id is null");
  380. return (Criteria) this;
  381. }
  382. public Criteria andCabinetIdIsNotNull() {
  383. addCriterion("cabinet_id is not null");
  384. return (Criteria) this;
  385. }
  386. public Criteria andCabinetIdEqualTo(Long value) {
  387. addCriterion("cabinet_id =", value, "cabinetId");
  388. return (Criteria) this;
  389. }
  390. public Criteria andCabinetIdNotEqualTo(Long value) {
  391. addCriterion("cabinet_id <>", value, "cabinetId");
  392. return (Criteria) this;
  393. }
  394. public Criteria andCabinetIdGreaterThan(Long value) {
  395. addCriterion("cabinet_id >", value, "cabinetId");
  396. return (Criteria) this;
  397. }
  398. public Criteria andCabinetIdGreaterThanOrEqualTo(Long value) {
  399. addCriterion("cabinet_id >=", value, "cabinetId");
  400. return (Criteria) this;
  401. }
  402. public Criteria andCabinetIdLessThan(Long value) {
  403. addCriterion("cabinet_id <", value, "cabinetId");
  404. return (Criteria) this;
  405. }
  406. public Criteria andCabinetIdLessThanOrEqualTo(Long value) {
  407. addCriterion("cabinet_id <=", value, "cabinetId");
  408. return (Criteria) this;
  409. }
  410. public Criteria andCabinetIdIn(List<Long> values) {
  411. addCriterion("cabinet_id in", values, "cabinetId");
  412. return (Criteria) this;
  413. }
  414. public Criteria andCabinetIdNotIn(List<Long> values) {
  415. addCriterion("cabinet_id not in", values, "cabinetId");
  416. return (Criteria) this;
  417. }
  418. public Criteria andCabinetIdBetween(Long value1, Long value2) {
  419. addCriterion("cabinet_id between", value1, value2, "cabinetId");
  420. return (Criteria) this;
  421. }
  422. public Criteria andCabinetIdNotBetween(Long value1, Long value2) {
  423. addCriterion("cabinet_id not between", value1, value2, "cabinetId");
  424. return (Criteria) this;
  425. }
  426. public Criteria andCabinetNoIsNull() {
  427. addCriterion("cabinet_no is null");
  428. return (Criteria) this;
  429. }
  430. public Criteria andCabinetNoIsNotNull() {
  431. addCriterion("cabinet_no is not null");
  432. return (Criteria) this;
  433. }
  434. public Criteria andCabinetNoEqualTo(String value) {
  435. addCriterion("cabinet_no =", value, "cabinetNo");
  436. return (Criteria) this;
  437. }
  438. public Criteria andCabinetNoNotEqualTo(String value) {
  439. addCriterion("cabinet_no <>", value, "cabinetNo");
  440. return (Criteria) this;
  441. }
  442. public Criteria andCabinetNoGreaterThan(String value) {
  443. addCriterion("cabinet_no >", value, "cabinetNo");
  444. return (Criteria) this;
  445. }
  446. public Criteria andCabinetNoGreaterThanOrEqualTo(String value) {
  447. addCriterion("cabinet_no >=", value, "cabinetNo");
  448. return (Criteria) this;
  449. }
  450. public Criteria andCabinetNoLessThan(String value) {
  451. addCriterion("cabinet_no <", value, "cabinetNo");
  452. return (Criteria) this;
  453. }
  454. public Criteria andCabinetNoLessThanOrEqualTo(String value) {
  455. addCriterion("cabinet_no <=", value, "cabinetNo");
  456. return (Criteria) this;
  457. }
  458. public Criteria andCabinetNoLike(String value) {
  459. addCriterion("cabinet_no like", value, "cabinetNo");
  460. return (Criteria) this;
  461. }
  462. public Criteria andCabinetNoNotLike(String value) {
  463. addCriterion("cabinet_no not like", value, "cabinetNo");
  464. return (Criteria) this;
  465. }
  466. public Criteria andCabinetNoIn(List<String> values) {
  467. addCriterion("cabinet_no in", values, "cabinetNo");
  468. return (Criteria) this;
  469. }
  470. public Criteria andCabinetNoNotIn(List<String> values) {
  471. addCriterion("cabinet_no not in", values, "cabinetNo");
  472. return (Criteria) this;
  473. }
  474. public Criteria andCabinetNoBetween(String value1, String value2) {
  475. addCriterion("cabinet_no between", value1, value2, "cabinetNo");
  476. return (Criteria) this;
  477. }
  478. public Criteria andCabinetNoNotBetween(String value1, String value2) {
  479. addCriterion("cabinet_no not between", value1, value2, "cabinetNo");
  480. return (Criteria) this;
  481. }
  482. public Criteria andStatusIsNull() {
  483. addCriterion("status is null");
  484. return (Criteria) this;
  485. }
  486. public Criteria andStatusIsNotNull() {
  487. addCriterion("status is not null");
  488. return (Criteria) this;
  489. }
  490. public Criteria andStatusEqualTo(Short value) {
  491. addCriterion("status =", value, "status");
  492. return (Criteria) this;
  493. }
  494. public Criteria andStatusNotEqualTo(Short value) {
  495. addCriterion("status <>", value, "status");
  496. return (Criteria) this;
  497. }
  498. public Criteria andStatusGreaterThan(Short value) {
  499. addCriterion("status >", value, "status");
  500. return (Criteria) this;
  501. }
  502. public Criteria andStatusGreaterThanOrEqualTo(Short value) {
  503. addCriterion("status >=", value, "status");
  504. return (Criteria) this;
  505. }
  506. public Criteria andStatusLessThan(Short value) {
  507. addCriterion("status <", value, "status");
  508. return (Criteria) this;
  509. }
  510. public Criteria andStatusLessThanOrEqualTo(Short value) {
  511. addCriterion("status <=", value, "status");
  512. return (Criteria) this;
  513. }
  514. public Criteria andStatusIn(List<Short> values) {
  515. addCriterion("status in", values, "status");
  516. return (Criteria) this;
  517. }
  518. public Criteria andStatusNotIn(List<Short> values) {
  519. addCriterion("status not in", values, "status");
  520. return (Criteria) this;
  521. }
  522. public Criteria andStatusBetween(Short value1, Short value2) {
  523. addCriterion("status between", value1, value2, "status");
  524. return (Criteria) this;
  525. }
  526. public Criteria andStatusNotBetween(Short value1, Short value2) {
  527. addCriterion("status not between", value1, value2, "status");
  528. return (Criteria) this;
  529. }
  530. public Criteria andAssignTimeIsNull() {
  531. addCriterion("assign_time is null");
  532. return (Criteria) this;
  533. }
  534. public Criteria andAssignTimeIsNotNull() {
  535. addCriterion("assign_time is not null");
  536. return (Criteria) this;
  537. }
  538. public Criteria andAssignTimeEqualTo(Date value) {
  539. addCriterion("assign_time =", value, "assignTime");
  540. return (Criteria) this;
  541. }
  542. public Criteria andAssignTimeNotEqualTo(Date value) {
  543. addCriterion("assign_time <>", value, "assignTime");
  544. return (Criteria) this;
  545. }
  546. public Criteria andAssignTimeGreaterThan(Date value) {
  547. addCriterion("assign_time >", value, "assignTime");
  548. return (Criteria) this;
  549. }
  550. public Criteria andAssignTimeGreaterThanOrEqualTo(Date value) {
  551. addCriterion("assign_time >=", value, "assignTime");
  552. return (Criteria) this;
  553. }
  554. public Criteria andAssignTimeLessThan(Date value) {
  555. addCriterion("assign_time <", value, "assignTime");
  556. return (Criteria) this;
  557. }
  558. public Criteria andAssignTimeLessThanOrEqualTo(Date value) {
  559. addCriterion("assign_time <=", value, "assignTime");
  560. return (Criteria) this;
  561. }
  562. public Criteria andAssignTimeIn(List<Date> values) {
  563. addCriterion("assign_time in", values, "assignTime");
  564. return (Criteria) this;
  565. }
  566. public Criteria andAssignTimeNotIn(List<Date> values) {
  567. addCriterion("assign_time not in", values, "assignTime");
  568. return (Criteria) this;
  569. }
  570. public Criteria andAssignTimeBetween(Date value1, Date value2) {
  571. addCriterion("assign_time between", value1, value2, "assignTime");
  572. return (Criteria) this;
  573. }
  574. public Criteria andAssignTimeNotBetween(Date value1, Date value2) {
  575. addCriterion("assign_time not between", value1, value2, "assignTime");
  576. return (Criteria) this;
  577. }
  578. public Criteria andUseTimeIsNull() {
  579. addCriterion("use_time is null");
  580. return (Criteria) this;
  581. }
  582. public Criteria andUseTimeIsNotNull() {
  583. addCriterion("use_time is not null");
  584. return (Criteria) this;
  585. }
  586. public Criteria andUseTimeEqualTo(Date value) {
  587. addCriterion("use_time =", value, "useTime");
  588. return (Criteria) this;
  589. }
  590. public Criteria andUseTimeNotEqualTo(Date value) {
  591. addCriterion("use_time <>", value, "useTime");
  592. return (Criteria) this;
  593. }
  594. public Criteria andUseTimeGreaterThan(Date value) {
  595. addCriterion("use_time >", value, "useTime");
  596. return (Criteria) this;
  597. }
  598. public Criteria andUseTimeGreaterThanOrEqualTo(Date value) {
  599. addCriterion("use_time >=", value, "useTime");
  600. return (Criteria) this;
  601. }
  602. public Criteria andUseTimeLessThan(Date value) {
  603. addCriterion("use_time <", value, "useTime");
  604. return (Criteria) this;
  605. }
  606. public Criteria andUseTimeLessThanOrEqualTo(Date value) {
  607. addCriterion("use_time <=", value, "useTime");
  608. return (Criteria) this;
  609. }
  610. public Criteria andUseTimeIn(List<Date> values) {
  611. addCriterion("use_time in", values, "useTime");
  612. return (Criteria) this;
  613. }
  614. public Criteria andUseTimeNotIn(List<Date> values) {
  615. addCriterion("use_time not in", values, "useTime");
  616. return (Criteria) this;
  617. }
  618. public Criteria andUseTimeBetween(Date value1, Date value2) {
  619. addCriterion("use_time between", value1, value2, "useTime");
  620. return (Criteria) this;
  621. }
  622. public Criteria andUseTimeNotBetween(Date value1, Date value2) {
  623. addCriterion("use_time not between", value1, value2, "useTime");
  624. return (Criteria) this;
  625. }
  626. public Criteria andBizTypeIsNull() {
  627. addCriterion("biz_type is null");
  628. return (Criteria) this;
  629. }
  630. public Criteria andBizTypeIsNotNull() {
  631. addCriterion("biz_type is not null");
  632. return (Criteria) this;
  633. }
  634. public Criteria andBizTypeEqualTo(Short value) {
  635. addCriterion("biz_type =", value, "bizType");
  636. return (Criteria) this;
  637. }
  638. public Criteria andBizTypeNotEqualTo(Short value) {
  639. addCriterion("biz_type <>", value, "bizType");
  640. return (Criteria) this;
  641. }
  642. public Criteria andBizTypeGreaterThan(Short value) {
  643. addCriterion("biz_type >", value, "bizType");
  644. return (Criteria) this;
  645. }
  646. public Criteria andBizTypeGreaterThanOrEqualTo(Short value) {
  647. addCriterion("biz_type >=", value, "bizType");
  648. return (Criteria) this;
  649. }
  650. public Criteria andBizTypeLessThan(Short value) {
  651. addCriterion("biz_type <", value, "bizType");
  652. return (Criteria) this;
  653. }
  654. public Criteria andBizTypeLessThanOrEqualTo(Short value) {
  655. addCriterion("biz_type <=", value, "bizType");
  656. return (Criteria) this;
  657. }
  658. public Criteria andBizTypeIn(List<Short> values) {
  659. addCriterion("biz_type in", values, "bizType");
  660. return (Criteria) this;
  661. }
  662. public Criteria andBizTypeNotIn(List<Short> values) {
  663. addCriterion("biz_type not in", values, "bizType");
  664. return (Criteria) this;
  665. }
  666. public Criteria andBizTypeBetween(Short value1, Short value2) {
  667. addCriterion("biz_type between", value1, value2, "bizType");
  668. return (Criteria) this;
  669. }
  670. public Criteria andBizTypeNotBetween(Short value1, Short value2) {
  671. addCriterion("biz_type not between", value1, value2, "bizType");
  672. return (Criteria) this;
  673. }
  674. public Criteria andBizOutIdIsNull() {
  675. addCriterion("biz_out_id is null");
  676. return (Criteria) this;
  677. }
  678. public Criteria andBizOutIdIsNotNull() {
  679. addCriterion("biz_out_id is not null");
  680. return (Criteria) this;
  681. }
  682. public Criteria andBizOutIdEqualTo(Long value) {
  683. addCriterion("biz_out_id =", value, "bizOutId");
  684. return (Criteria) this;
  685. }
  686. public Criteria andBizOutIdNotEqualTo(Long value) {
  687. addCriterion("biz_out_id <>", value, "bizOutId");
  688. return (Criteria) this;
  689. }
  690. public Criteria andBizOutIdGreaterThan(Long value) {
  691. addCriterion("biz_out_id >", value, "bizOutId");
  692. return (Criteria) this;
  693. }
  694. public Criteria andBizOutIdGreaterThanOrEqualTo(Long value) {
  695. addCriterion("biz_out_id >=", value, "bizOutId");
  696. return (Criteria) this;
  697. }
  698. public Criteria andBizOutIdLessThan(Long value) {
  699. addCriterion("biz_out_id <", value, "bizOutId");
  700. return (Criteria) this;
  701. }
  702. public Criteria andBizOutIdLessThanOrEqualTo(Long value) {
  703. addCriterion("biz_out_id <=", value, "bizOutId");
  704. return (Criteria) this;
  705. }
  706. public Criteria andBizOutIdIn(List<Long> values) {
  707. addCriterion("biz_out_id in", values, "bizOutId");
  708. return (Criteria) this;
  709. }
  710. public Criteria andBizOutIdNotIn(List<Long> values) {
  711. addCriterion("biz_out_id not in", values, "bizOutId");
  712. return (Criteria) this;
  713. }
  714. public Criteria andBizOutIdBetween(Long value1, Long value2) {
  715. addCriterion("biz_out_id between", value1, value2, "bizOutId");
  716. return (Criteria) this;
  717. }
  718. public Criteria andBizOutIdNotBetween(Long value1, Long value2) {
  719. addCriterion("biz_out_id not between", value1, value2, "bizOutId");
  720. return (Criteria) this;
  721. }
  722. public Criteria andFeatureIsNull() {
  723. addCriterion("feature is null");
  724. return (Criteria) this;
  725. }
  726. public Criteria andFeatureIsNotNull() {
  727. addCriterion("feature is not null");
  728. return (Criteria) this;
  729. }
  730. public Criteria andFeatureEqualTo(String value) {
  731. addCriterion("feature =", value, "feature");
  732. return (Criteria) this;
  733. }
  734. public Criteria andFeatureNotEqualTo(String value) {
  735. addCriterion("feature <>", value, "feature");
  736. return (Criteria) this;
  737. }
  738. public Criteria andFeatureGreaterThan(String value) {
  739. addCriterion("feature >", value, "feature");
  740. return (Criteria) this;
  741. }
  742. public Criteria andFeatureGreaterThanOrEqualTo(String value) {
  743. addCriterion("feature >=", value, "feature");
  744. return (Criteria) this;
  745. }
  746. public Criteria andFeatureLessThan(String value) {
  747. addCriterion("feature <", value, "feature");
  748. return (Criteria) this;
  749. }
  750. public Criteria andFeatureLessThanOrEqualTo(String value) {
  751. addCriterion("feature <=", value, "feature");
  752. return (Criteria) this;
  753. }
  754. public Criteria andFeatureLike(String value) {
  755. addCriterion("feature like", value, "feature");
  756. return (Criteria) this;
  757. }
  758. public Criteria andFeatureNotLike(String value) {
  759. addCriterion("feature not like", value, "feature");
  760. return (Criteria) this;
  761. }
  762. public Criteria andFeatureIn(List<String> values) {
  763. addCriterion("feature in", values, "feature");
  764. return (Criteria) this;
  765. }
  766. public Criteria andFeatureNotIn(List<String> values) {
  767. addCriterion("feature not in", values, "feature");
  768. return (Criteria) this;
  769. }
  770. public Criteria andFeatureBetween(String value1, String value2) {
  771. addCriterion("feature between", value1, value2, "feature");
  772. return (Criteria) this;
  773. }
  774. public Criteria andFeatureNotBetween(String value1, String value2) {
  775. addCriterion("feature not between", value1, value2, "feature");
  776. return (Criteria) this;
  777. }
  778. }
  779. public static class Criteria extends GeneratedCriteria {
  780. protected Criteria() {
  781. super();
  782. }
  783. }
  784. public static class Criterion {
  785. private String condition;
  786. private Object value;
  787. private Object secondValue;
  788. private boolean noValue;
  789. private boolean singleValue;
  790. private boolean betweenValue;
  791. private boolean listValue;
  792. private String typeHandler;
  793. public String getCondition() {
  794. return condition;
  795. }
  796. public Object getValue() {
  797. return value;
  798. }
  799. public Object getSecondValue() {
  800. return secondValue;
  801. }
  802. public boolean isNoValue() {
  803. return noValue;
  804. }
  805. public boolean isSingleValue() {
  806. return singleValue;
  807. }
  808. public boolean isBetweenValue() {
  809. return betweenValue;
  810. }
  811. public boolean isListValue() {
  812. return listValue;
  813. }
  814. public String getTypeHandler() {
  815. return typeHandler;
  816. }
  817. protected Criterion(String condition) {
  818. super();
  819. this.condition = condition;
  820. this.typeHandler = null;
  821. this.noValue = true;
  822. }
  823. protected Criterion(String condition, Object value, String typeHandler) {
  824. super();
  825. this.condition = condition;
  826. this.value = value;
  827. this.typeHandler = typeHandler;
  828. if (value instanceof List<?>) {
  829. this.listValue = true;
  830. } else {
  831. this.singleValue = true;
  832. }
  833. }
  834. protected Criterion(String condition, Object value) {
  835. this(condition, value, null);
  836. }
  837. protected Criterion(String condition, Object value, Object secondValue, String typeHandler) {
  838. super();
  839. this.condition = condition;
  840. this.value = value;
  841. this.secondValue = secondValue;
  842. this.typeHandler = typeHandler;
  843. this.betweenValue = true;
  844. }
  845. protected Criterion(String condition, Object value, Object secondValue) {
  846. this(condition, value, secondValue, null);
  847. }
  848. }
  849. public enum OrderCondition {
  850. ID("id"),
  851. GMTCREATE("gmt_create"),
  852. GMTMODIFIED("gmt_modified"),
  853. AREAID("area_id"),
  854. AUTHCODE("auth_code"),
  855. CABINETID("cabinet_id"),
  856. CABINETNO("cabinet_no"),
  857. STATUS("status"),
  858. ASSIGNTIME("assign_time"),
  859. USETIME("use_time"),
  860. BIZTYPE("biz_type"),
  861. BIZOUTID("biz_out_id"),
  862. FEATURE("feature");
  863. private String columnName;
  864. OrderCondition(String columnName) {
  865. this.columnName = columnName;
  866. }
  867. public String getColumnName() {
  868. return columnName;
  869. }
  870. public static OrderCondition getEnumByName(String name) {
  871. OrderCondition[] orderConditions = OrderCondition.values();
  872. for (OrderCondition orderCondition : orderConditions) {
  873. if (orderCondition.name().equalsIgnoreCase(name)) {
  874. return orderCondition;
  875. }
  876. }
  877. throw new RuntimeException("OrderCondition of " + name + " enum not exist");
  878. }
  879. @Override
  880. public String toString() {
  881. return columnName;
  882. }
  883. }
  884. public enum SortType {
  885. ASC("asc"),
  886. DESC("desc");
  887. private String value;
  888. SortType(String value) {
  889. this.value = value;
  890. }
  891. public String getValue() {
  892. return value;
  893. }
  894. public static SortType getEnumByName(String name) {
  895. SortType[] sortTypes = SortType.values();
  896. for (SortType sortType : sortTypes) {
  897. if (sortType.name().equalsIgnoreCase(name)) {
  898. return sortType;
  899. }
  900. }
  901. throw new RuntimeException("SortType of " + name + " enum not exist");
  902. }
  903. @Override
  904. public String toString() {
  905. return value;
  906. }
  907. }
  908. }
  909. }