CustomsInvoiceExample.java 34.8 KB
Newer Older
frank.xa.zhang's avatar
frank.xa.zhang committed
1
package pwc.taxtech.atms.vat.entity;
2 3 4 5 6 7 8 9 10

import java.math.BigDecimal;
import java.util.ArrayList;
import java.util.Date;
import java.util.List;

public class CustomsInvoiceExample {
    /**
     * This field was generated by MyBatis Generator.
neo's avatar
neo committed
11
     * This field corresponds to the database table TAX_PROJECT.CUSTOMS_INVOICE
12 13 14 15 16 17 18
     *
     * @mbg.generated
     */
    protected String orderByClause;

    /**
     * This field was generated by MyBatis Generator.
neo's avatar
neo committed
19
     * This field corresponds to the database table TAX_PROJECT.CUSTOMS_INVOICE
20 21 22 23 24 25 26
     *
     * @mbg.generated
     */
    protected boolean distinct;

    /**
     * This field was generated by MyBatis Generator.
neo's avatar
neo committed
27
     * This field corresponds to the database table TAX_PROJECT.CUSTOMS_INVOICE
28 29 30 31 32 33 34
     *
     * @mbg.generated
     */
    protected List<Criteria> oredCriteria;

    /**
     * This method was generated by MyBatis Generator.
neo's avatar
neo committed
35
     * This method corresponds to the database table TAX_PROJECT.CUSTOMS_INVOICE
36 37 38 39 40 41 42 43 44
     *
     * @mbg.generated
     */
    public CustomsInvoiceExample() {
        oredCriteria = new ArrayList<Criteria>();
    }

    /**
     * This method was generated by MyBatis Generator.
neo's avatar
neo committed
45
     * This method corresponds to the database table TAX_PROJECT.CUSTOMS_INVOICE
46 47 48 49 50 51 52 53 54
     *
     * @mbg.generated
     */
    public void setOrderByClause(String orderByClause) {
        this.orderByClause = orderByClause;
    }

    /**
     * This method was generated by MyBatis Generator.
neo's avatar
neo committed
55
     * This method corresponds to the database table TAX_PROJECT.CUSTOMS_INVOICE
56 57 58 59 60 61 62 63 64
     *
     * @mbg.generated
     */
    public String getOrderByClause() {
        return orderByClause;
    }

    /**
     * This method was generated by MyBatis Generator.
neo's avatar
neo committed
65
     * This method corresponds to the database table TAX_PROJECT.CUSTOMS_INVOICE
66 67 68 69 70 71 72 73 74
     *
     * @mbg.generated
     */
    public void setDistinct(boolean distinct) {
        this.distinct = distinct;
    }

    /**
     * This method was generated by MyBatis Generator.
neo's avatar
neo committed
75
     * This method corresponds to the database table TAX_PROJECT.CUSTOMS_INVOICE
76 77 78 79 80 81 82 83 84
     *
     * @mbg.generated
     */
    public boolean isDistinct() {
        return distinct;
    }

    /**
     * This method was generated by MyBatis Generator.
neo's avatar
neo committed
85
     * This method corresponds to the database table TAX_PROJECT.CUSTOMS_INVOICE
86 87 88 89 90 91 92 93 94
     *
     * @mbg.generated
     */
    public List<Criteria> getOredCriteria() {
        return oredCriteria;
    }

    /**
     * This method was generated by MyBatis Generator.
neo's avatar
neo committed
95
     * This method corresponds to the database table TAX_PROJECT.CUSTOMS_INVOICE
96 97 98 99 100 101 102 103 104
     *
     * @mbg.generated
     */
    public void or(Criteria criteria) {
        oredCriteria.add(criteria);
    }

    /**
     * This method was generated by MyBatis Generator.
neo's avatar
neo committed
105
     * This method corresponds to the database table TAX_PROJECT.CUSTOMS_INVOICE
106 107 108 109 110 111 112 113 114 115 116
     *
     * @mbg.generated
     */
    public Criteria or() {
        Criteria criteria = createCriteriaInternal();
        oredCriteria.add(criteria);
        return criteria;
    }

    /**
     * This method was generated by MyBatis Generator.
neo's avatar
neo committed
117
     * This method corresponds to the database table TAX_PROJECT.CUSTOMS_INVOICE
118 119 120 121 122 123 124 125 126 127 128 129 130
     *
     * @mbg.generated
     */
    public Criteria createCriteria() {
        Criteria criteria = createCriteriaInternal();
        if (oredCriteria.size() == 0) {
            oredCriteria.add(criteria);
        }
        return criteria;
    }

    /**
     * This method was generated by MyBatis Generator.
neo's avatar
neo committed
131
     * This method corresponds to the database table TAX_PROJECT.CUSTOMS_INVOICE
132 133 134 135 136 137 138 139 140 141
     *
     * @mbg.generated
     */
    protected Criteria createCriteriaInternal() {
        Criteria criteria = new Criteria();
        return criteria;
    }

    /**
     * This method was generated by MyBatis Generator.
neo's avatar
neo committed
142
     * This method corresponds to the database table TAX_PROJECT.CUSTOMS_INVOICE
143 144 145 146 147 148 149 150 151 152 153
     *
     * @mbg.generated
     */
    public void clear() {
        oredCriteria.clear();
        orderByClause = null;
        distinct = false;
    }

    /**
     * This class was generated by MyBatis Generator.
neo's avatar
neo committed
154
     * This class corresponds to the database table TAX_PROJECT.CUSTOMS_INVOICE
155 156 157 158 159 160 161 162 163 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
     *
     * @mbg.generated
     */
    protected abstract static class GeneratedCriteria {
        protected List<Criterion> criteria;

        protected GeneratedCriteria() {
            super();
            criteria = new ArrayList<Criterion>();
        }

        public boolean isValid() {
            return criteria.size() > 0;
        }

        public List<Criterion> getAllCriteria() {
            return criteria;
        }

        public List<Criterion> getCriteria() {
            return criteria;
        }

        protected void addCriterion(String condition) {
            if (condition == null) {
                throw new RuntimeException("Value for condition cannot be null");
            }
            criteria.add(new Criterion(condition));
        }

        protected void addCriterion(String condition, Object value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value));
        }

        protected void addCriterion(String condition, Object value1, Object value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value1, value2));
        }

        public Criteria andCustomsIdIsNull() {
200
            addCriterion("CUSTOMS_ID is null");
201 202 203 204
            return (Criteria) this;
        }

        public Criteria andCustomsIdIsNotNull() {
205
            addCriterion("CUSTOMS_ID is not null");
206 207 208 209
            return (Criteria) this;
        }

        public Criteria andCustomsIdEqualTo(String value) {
210
            addCriterion("CUSTOMS_ID =", value, "customsId");
211 212 213 214
            return (Criteria) this;
        }

        public Criteria andCustomsIdNotEqualTo(String value) {
215
            addCriterion("CUSTOMS_ID <>", value, "customsId");
216 217 218 219
            return (Criteria) this;
        }

        public Criteria andCustomsIdGreaterThan(String value) {
220
            addCriterion("CUSTOMS_ID >", value, "customsId");
221 222 223 224
            return (Criteria) this;
        }

        public Criteria andCustomsIdGreaterThanOrEqualTo(String value) {
225
            addCriterion("CUSTOMS_ID >=", value, "customsId");
226 227 228 229
            return (Criteria) this;
        }

        public Criteria andCustomsIdLessThan(String value) {
230
            addCriterion("CUSTOMS_ID <", value, "customsId");
231 232 233 234
            return (Criteria) this;
        }

        public Criteria andCustomsIdLessThanOrEqualTo(String value) {
235
            addCriterion("CUSTOMS_ID <=", value, "customsId");
236 237 238 239
            return (Criteria) this;
        }

        public Criteria andCustomsIdLike(String value) {
240
            addCriterion("CUSTOMS_ID like", value, "customsId");
241 242 243 244
            return (Criteria) this;
        }

        public Criteria andCustomsIdNotLike(String value) {
245
            addCriterion("CUSTOMS_ID not like", value, "customsId");
246 247 248 249
            return (Criteria) this;
        }

        public Criteria andCustomsIdIn(List<String> values) {
250
            addCriterion("CUSTOMS_ID in", values, "customsId");
251 252 253 254
            return (Criteria) this;
        }

        public Criteria andCustomsIdNotIn(List<String> values) {
255
            addCriterion("CUSTOMS_ID not in", values, "customsId");
256 257 258 259
            return (Criteria) this;
        }

        public Criteria andCustomsIdBetween(String value1, String value2) {
260
            addCriterion("CUSTOMS_ID between", value1, value2, "customsId");
261 262 263 264
            return (Criteria) this;
        }

        public Criteria andCustomsIdNotBetween(String value1, String value2) {
265
            addCriterion("CUSTOMS_ID not between", value1, value2, "customsId");
266 267 268 269
            return (Criteria) this;
        }

        public Criteria andPayNumIsNull() {
270
            addCriterion("PAY_NUM is null");
271 272 273 274
            return (Criteria) this;
        }

        public Criteria andPayNumIsNotNull() {
275
            addCriterion("PAY_NUM is not null");
276 277 278 279
            return (Criteria) this;
        }

        public Criteria andPayNumEqualTo(String value) {
280
            addCriterion("PAY_NUM =", value, "payNum");
281 282 283 284
            return (Criteria) this;
        }

        public Criteria andPayNumNotEqualTo(String value) {
285
            addCriterion("PAY_NUM <>", value, "payNum");
286 287 288 289
            return (Criteria) this;
        }

        public Criteria andPayNumGreaterThan(String value) {
290
            addCriterion("PAY_NUM >", value, "payNum");
291 292 293 294
            return (Criteria) this;
        }

        public Criteria andPayNumGreaterThanOrEqualTo(String value) {
295
            addCriterion("PAY_NUM >=", value, "payNum");
296 297 298 299
            return (Criteria) this;
        }

        public Criteria andPayNumLessThan(String value) {
300
            addCriterion("PAY_NUM <", value, "payNum");
301 302 303 304
            return (Criteria) this;
        }

        public Criteria andPayNumLessThanOrEqualTo(String value) {
305
            addCriterion("PAY_NUM <=", value, "payNum");
306 307 308 309
            return (Criteria) this;
        }

        public Criteria andPayNumLike(String value) {
310
            addCriterion("PAY_NUM like", value, "payNum");
311 312 313 314
            return (Criteria) this;
        }

        public Criteria andPayNumNotLike(String value) {
315
            addCriterion("PAY_NUM not like", value, "payNum");
316 317 318 319
            return (Criteria) this;
        }

        public Criteria andPayNumIn(List<String> values) {
320
            addCriterion("PAY_NUM in", values, "payNum");
321 322 323 324
            return (Criteria) this;
        }

        public Criteria andPayNumNotIn(List<String> values) {
325
            addCriterion("PAY_NUM not in", values, "payNum");
326 327 328 329
            return (Criteria) this;
        }

        public Criteria andPayNumBetween(String value1, String value2) {
330
            addCriterion("PAY_NUM between", value1, value2, "payNum");
331 332 333 334
            return (Criteria) this;
        }

        public Criteria andPayNumNotBetween(String value1, String value2) {
335
            addCriterion("PAY_NUM not between", value1, value2, "payNum");
336 337 338 339
            return (Criteria) this;
        }

        public Criteria andIssueDateIsNull() {
340
            addCriterion("ISSUE_DATE is null");
341 342 343 344
            return (Criteria) this;
        }

        public Criteria andIssueDateIsNotNull() {
345
            addCriterion("ISSUE_DATE is not null");
346 347 348 349
            return (Criteria) this;
        }

        public Criteria andIssueDateEqualTo(Date value) {
350
            addCriterion("ISSUE_DATE =", value, "issueDate");
351 352 353 354
            return (Criteria) this;
        }

        public Criteria andIssueDateNotEqualTo(Date value) {
355
            addCriterion("ISSUE_DATE <>", value, "issueDate");
356 357 358 359
            return (Criteria) this;
        }

        public Criteria andIssueDateGreaterThan(Date value) {
360
            addCriterion("ISSUE_DATE >", value, "issueDate");
361 362 363 364
            return (Criteria) this;
        }

        public Criteria andIssueDateGreaterThanOrEqualTo(Date value) {
365
            addCriterion("ISSUE_DATE >=", value, "issueDate");
366 367 368 369
            return (Criteria) this;
        }

        public Criteria andIssueDateLessThan(Date value) {
370
            addCriterion("ISSUE_DATE <", value, "issueDate");
371 372 373 374
            return (Criteria) this;
        }

        public Criteria andIssueDateLessThanOrEqualTo(Date value) {
375
            addCriterion("ISSUE_DATE <=", value, "issueDate");
376 377 378 379
            return (Criteria) this;
        }

        public Criteria andIssueDateIn(List<Date> values) {
380
            addCriterion("ISSUE_DATE in", values, "issueDate");
381 382 383 384
            return (Criteria) this;
        }

        public Criteria andIssueDateNotIn(List<Date> values) {
385
            addCriterion("ISSUE_DATE not in", values, "issueDate");
386 387 388 389
            return (Criteria) this;
        }

        public Criteria andIssueDateBetween(Date value1, Date value2) {
390
            addCriterion("ISSUE_DATE between", value1, value2, "issueDate");
391 392 393 394
            return (Criteria) this;
        }

        public Criteria andIssueDateNotBetween(Date value1, Date value2) {
395
            addCriterion("ISSUE_DATE not between", value1, value2, "issueDate");
396 397 398 399
            return (Criteria) this;
        }

        public Criteria andInvoiceTaxAmountIsNull() {
400
            addCriterion("INVOICE_TAX_AMOUNT is null");
401 402 403 404
            return (Criteria) this;
        }

        public Criteria andInvoiceTaxAmountIsNotNull() {
405
            addCriterion("INVOICE_TAX_AMOUNT is not null");
406 407 408 409
            return (Criteria) this;
        }

        public Criteria andInvoiceTaxAmountEqualTo(BigDecimal value) {
410
            addCriterion("INVOICE_TAX_AMOUNT =", value, "invoiceTaxAmount");
411 412 413 414
            return (Criteria) this;
        }

        public Criteria andInvoiceTaxAmountNotEqualTo(BigDecimal value) {
415
            addCriterion("INVOICE_TAX_AMOUNT <>", value, "invoiceTaxAmount");
416 417 418 419
            return (Criteria) this;
        }

        public Criteria andInvoiceTaxAmountGreaterThan(BigDecimal value) {
420
            addCriterion("INVOICE_TAX_AMOUNT >", value, "invoiceTaxAmount");
421 422 423 424
            return (Criteria) this;
        }

        public Criteria andInvoiceTaxAmountGreaterThanOrEqualTo(BigDecimal value) {
425
            addCriterion("INVOICE_TAX_AMOUNT >=", value, "invoiceTaxAmount");
426 427 428 429
            return (Criteria) this;
        }

        public Criteria andInvoiceTaxAmountLessThan(BigDecimal value) {
430
            addCriterion("INVOICE_TAX_AMOUNT <", value, "invoiceTaxAmount");
431 432 433 434
            return (Criteria) this;
        }

        public Criteria andInvoiceTaxAmountLessThanOrEqualTo(BigDecimal value) {
435
            addCriterion("INVOICE_TAX_AMOUNT <=", value, "invoiceTaxAmount");
436 437 438 439
            return (Criteria) this;
        }

        public Criteria andInvoiceTaxAmountIn(List<BigDecimal> values) {
440
            addCriterion("INVOICE_TAX_AMOUNT in", values, "invoiceTaxAmount");
441 442 443 444
            return (Criteria) this;
        }

        public Criteria andInvoiceTaxAmountNotIn(List<BigDecimal> values) {
445
            addCriterion("INVOICE_TAX_AMOUNT not in", values, "invoiceTaxAmount");
446 447 448 449
            return (Criteria) this;
        }

        public Criteria andInvoiceTaxAmountBetween(BigDecimal value1, BigDecimal value2) {
450
            addCriterion("INVOICE_TAX_AMOUNT between", value1, value2, "invoiceTaxAmount");
451 452 453 454
            return (Criteria) this;
        }

        public Criteria andInvoiceTaxAmountNotBetween(BigDecimal value1, BigDecimal value2) {
455
            addCriterion("INVOICE_TAX_AMOUNT not between", value1, value2, "invoiceTaxAmount");
456 457 458 459
            return (Criteria) this;
        }

        public Criteria andInvoiceAmountIsNull() {
460
            addCriterion("INVOICE_AMOUNT is null");
461 462 463 464
            return (Criteria) this;
        }

        public Criteria andInvoiceAmountIsNotNull() {
465
            addCriterion("INVOICE_AMOUNT is not null");
466 467 468 469
            return (Criteria) this;
        }

        public Criteria andInvoiceAmountEqualTo(BigDecimal value) {
470
            addCriterion("INVOICE_AMOUNT =", value, "invoiceAmount");
471 472 473 474
            return (Criteria) this;
        }

        public Criteria andInvoiceAmountNotEqualTo(BigDecimal value) {
475
            addCriterion("INVOICE_AMOUNT <>", value, "invoiceAmount");
476 477 478 479
            return (Criteria) this;
        }

        public Criteria andInvoiceAmountGreaterThan(BigDecimal value) {
480
            addCriterion("INVOICE_AMOUNT >", value, "invoiceAmount");
481 482 483 484
            return (Criteria) this;
        }

        public Criteria andInvoiceAmountGreaterThanOrEqualTo(BigDecimal value) {
485
            addCriterion("INVOICE_AMOUNT >=", value, "invoiceAmount");
486 487 488 489
            return (Criteria) this;
        }

        public Criteria andInvoiceAmountLessThan(BigDecimal value) {
490
            addCriterion("INVOICE_AMOUNT <", value, "invoiceAmount");
491 492 493 494
            return (Criteria) this;
        }

        public Criteria andInvoiceAmountLessThanOrEqualTo(BigDecimal value) {
495
            addCriterion("INVOICE_AMOUNT <=", value, "invoiceAmount");
496 497 498 499
            return (Criteria) this;
        }

        public Criteria andInvoiceAmountIn(List<BigDecimal> values) {
500
            addCriterion("INVOICE_AMOUNT in", values, "invoiceAmount");
501 502 503 504
            return (Criteria) this;
        }

        public Criteria andInvoiceAmountNotIn(List<BigDecimal> values) {
505
            addCriterion("INVOICE_AMOUNT not in", values, "invoiceAmount");
506 507 508 509
            return (Criteria) this;
        }

        public Criteria andInvoiceAmountBetween(BigDecimal value1, BigDecimal value2) {
510
            addCriterion("INVOICE_AMOUNT between", value1, value2, "invoiceAmount");
511 512 513 514
            return (Criteria) this;
        }

        public Criteria andInvoiceAmountNotBetween(BigDecimal value1, BigDecimal value2) {
515 516 517 518 519 520 521 522 523 524 525 526 527 528 529 530 531 532 533 534 535 536 537 538 539 540 541 542 543 544 545 546 547 548 549 550 551 552 553 554 555 556 557 558 559 560 561 562 563 564 565 566 567 568 569 570 571 572 573 574 575 576 577 578 579 580 581 582 583 584 585
            addCriterion("INVOICE_AMOUNT not between", value1, value2, "invoiceAmount");
            return (Criteria) this;
        }

        public Criteria andAuditResultIsNull() {
            addCriterion("AUDIT_RESULT is null");
            return (Criteria) this;
        }

        public Criteria andAuditResultIsNotNull() {
            addCriterion("AUDIT_RESULT is not null");
            return (Criteria) this;
        }

        public Criteria andAuditResultEqualTo(String value) {
            addCriterion("AUDIT_RESULT =", value, "auditResult");
            return (Criteria) this;
        }

        public Criteria andAuditResultNotEqualTo(String value) {
            addCriterion("AUDIT_RESULT <>", value, "auditResult");
            return (Criteria) this;
        }

        public Criteria andAuditResultGreaterThan(String value) {
            addCriterion("AUDIT_RESULT >", value, "auditResult");
            return (Criteria) this;
        }

        public Criteria andAuditResultGreaterThanOrEqualTo(String value) {
            addCriterion("AUDIT_RESULT >=", value, "auditResult");
            return (Criteria) this;
        }

        public Criteria andAuditResultLessThan(String value) {
            addCriterion("AUDIT_RESULT <", value, "auditResult");
            return (Criteria) this;
        }

        public Criteria andAuditResultLessThanOrEqualTo(String value) {
            addCriterion("AUDIT_RESULT <=", value, "auditResult");
            return (Criteria) this;
        }

        public Criteria andAuditResultLike(String value) {
            addCriterion("AUDIT_RESULT like", value, "auditResult");
            return (Criteria) this;
        }

        public Criteria andAuditResultNotLike(String value) {
            addCriterion("AUDIT_RESULT not like", value, "auditResult");
            return (Criteria) this;
        }

        public Criteria andAuditResultIn(List<String> values) {
            addCriterion("AUDIT_RESULT in", values, "auditResult");
            return (Criteria) this;
        }

        public Criteria andAuditResultNotIn(List<String> values) {
            addCriterion("AUDIT_RESULT not in", values, "auditResult");
            return (Criteria) this;
        }

        public Criteria andAuditResultBetween(String value1, String value2) {
            addCriterion("AUDIT_RESULT between", value1, value2, "auditResult");
            return (Criteria) this;
        }

        public Criteria andAuditResultNotBetween(String value1, String value2) {
            addCriterion("AUDIT_RESULT not between", value1, value2, "auditResult");
586 587 588 589
            return (Criteria) this;
        }

        public Criteria andCreateTimeIsNull() {
590
            addCriterion("CREATE_TIME is null");
591 592 593 594
            return (Criteria) this;
        }

        public Criteria andCreateTimeIsNotNull() {
595
            addCriterion("CREATE_TIME is not null");
596 597 598 599
            return (Criteria) this;
        }

        public Criteria andCreateTimeEqualTo(Date value) {
600
            addCriterion("CREATE_TIME =", value, "createTime");
601 602 603 604
            return (Criteria) this;
        }

        public Criteria andCreateTimeNotEqualTo(Date value) {
605
            addCriterion("CREATE_TIME <>", value, "createTime");
606 607 608 609
            return (Criteria) this;
        }

        public Criteria andCreateTimeGreaterThan(Date value) {
610
            addCriterion("CREATE_TIME >", value, "createTime");
611 612 613 614
            return (Criteria) this;
        }

        public Criteria andCreateTimeGreaterThanOrEqualTo(Date value) {
615
            addCriterion("CREATE_TIME >=", value, "createTime");
616 617 618 619
            return (Criteria) this;
        }

        public Criteria andCreateTimeLessThan(Date value) {
620
            addCriterion("CREATE_TIME <", value, "createTime");
621 622 623 624
            return (Criteria) this;
        }

        public Criteria andCreateTimeLessThanOrEqualTo(Date value) {
625
            addCriterion("CREATE_TIME <=", value, "createTime");
626 627 628 629
            return (Criteria) this;
        }

        public Criteria andCreateTimeIn(List<Date> values) {
630
            addCriterion("CREATE_TIME in", values, "createTime");
631 632 633 634
            return (Criteria) this;
        }

        public Criteria andCreateTimeNotIn(List<Date> values) {
635
            addCriterion("CREATE_TIME not in", values, "createTime");
636 637 638 639
            return (Criteria) this;
        }

        public Criteria andCreateTimeBetween(Date value1, Date value2) {
640
            addCriterion("CREATE_TIME between", value1, value2, "createTime");
641 642 643 644
            return (Criteria) this;
        }

        public Criteria andCreateTimeNotBetween(Date value1, Date value2) {
645
            addCriterion("CREATE_TIME not between", value1, value2, "createTime");
646 647 648 649
            return (Criteria) this;
        }

        public Criteria andPeriodIdIsNull() {
650
            addCriterion("PERIOD_ID is null");
651 652 653 654
            return (Criteria) this;
        }

        public Criteria andPeriodIdIsNotNull() {
655
            addCriterion("PERIOD_ID is not null");
656 657 658 659
            return (Criteria) this;
        }

        public Criteria andPeriodIdEqualTo(Integer value) {
660
            addCriterion("PERIOD_ID =", value, "periodId");
661 662 663 664
            return (Criteria) this;
        }

        public Criteria andPeriodIdNotEqualTo(Integer value) {
665
            addCriterion("PERIOD_ID <>", value, "periodId");
666 667 668 669
            return (Criteria) this;
        }

        public Criteria andPeriodIdGreaterThan(Integer value) {
670
            addCriterion("PERIOD_ID >", value, "periodId");
671 672 673 674
            return (Criteria) this;
        }

        public Criteria andPeriodIdGreaterThanOrEqualTo(Integer value) {
675
            addCriterion("PERIOD_ID >=", value, "periodId");
676 677 678 679
            return (Criteria) this;
        }

        public Criteria andPeriodIdLessThan(Integer value) {
680
            addCriterion("PERIOD_ID <", value, "periodId");
681 682 683 684
            return (Criteria) this;
        }

        public Criteria andPeriodIdLessThanOrEqualTo(Integer value) {
685
            addCriterion("PERIOD_ID <=", value, "periodId");
686 687 688 689
            return (Criteria) this;
        }

        public Criteria andPeriodIdIn(List<Integer> values) {
690
            addCriterion("PERIOD_ID in", values, "periodId");
691 692 693 694
            return (Criteria) this;
        }

        public Criteria andPeriodIdNotIn(List<Integer> values) {
695
            addCriterion("PERIOD_ID not in", values, "periodId");
696 697 698 699
            return (Criteria) this;
        }

        public Criteria andPeriodIdBetween(Integer value1, Integer value2) {
700
            addCriterion("PERIOD_ID between", value1, value2, "periodId");
701 702 703 704
            return (Criteria) this;
        }

        public Criteria andPeriodIdNotBetween(Integer value1, Integer value2) {
705
            addCriterion("PERIOD_ID not between", value1, value2, "periodId");
706 707 708
            return (Criteria) this;
        }

709 710
        public Criteria andCreatorIdIsNull() {
            addCriterion("CREATOR_ID is null");
711 712 713
            return (Criteria) this;
        }

714 715
        public Criteria andCreatorIdIsNotNull() {
            addCriterion("CREATOR_ID is not null");
716 717 718
            return (Criteria) this;
        }

719 720
        public Criteria andCreatorIdEqualTo(String value) {
            addCriterion("CREATOR_ID =", value, "creatorId");
721 722 723
            return (Criteria) this;
        }

724 725
        public Criteria andCreatorIdNotEqualTo(String value) {
            addCriterion("CREATOR_ID <>", value, "creatorId");
726 727 728
            return (Criteria) this;
        }

729 730
        public Criteria andCreatorIdGreaterThan(String value) {
            addCriterion("CREATOR_ID >", value, "creatorId");
731 732 733
            return (Criteria) this;
        }

734 735
        public Criteria andCreatorIdGreaterThanOrEqualTo(String value) {
            addCriterion("CREATOR_ID >=", value, "creatorId");
736 737 738
            return (Criteria) this;
        }

739 740
        public Criteria andCreatorIdLessThan(String value) {
            addCriterion("CREATOR_ID <", value, "creatorId");
741 742 743
            return (Criteria) this;
        }

744 745
        public Criteria andCreatorIdLessThanOrEqualTo(String value) {
            addCriterion("CREATOR_ID <=", value, "creatorId");
746 747 748
            return (Criteria) this;
        }

749 750
        public Criteria andCreatorIdLike(String value) {
            addCriterion("CREATOR_ID like", value, "creatorId");
751 752 753
            return (Criteria) this;
        }

754 755
        public Criteria andCreatorIdNotLike(String value) {
            addCriterion("CREATOR_ID not like", value, "creatorId");
756 757 758
            return (Criteria) this;
        }

759 760
        public Criteria andCreatorIdIn(List<String> values) {
            addCriterion("CREATOR_ID in", values, "creatorId");
761 762 763
            return (Criteria) this;
        }

764 765
        public Criteria andCreatorIdNotIn(List<String> values) {
            addCriterion("CREATOR_ID not in", values, "creatorId");
766 767 768
            return (Criteria) this;
        }

769 770
        public Criteria andCreatorIdBetween(String value1, String value2) {
            addCriterion("CREATOR_ID between", value1, value2, "creatorId");
771 772 773
            return (Criteria) this;
        }

774 775
        public Criteria andCreatorIdNotBetween(String value1, String value2) {
            addCriterion("CREATOR_ID not between", value1, value2, "creatorId");
776 777 778 779
            return (Criteria) this;
        }

        public Criteria andStatusIsNull() {
780
            addCriterion("\"STATUS\" is null");
781 782 783 784
            return (Criteria) this;
        }

        public Criteria andStatusIsNotNull() {
785
            addCriterion("\"STATUS\" is not null");
786 787 788 789
            return (Criteria) this;
        }

        public Criteria andStatusEqualTo(Integer value) {
790
            addCriterion("\"STATUS\" =", value, "status");
791 792 793 794
            return (Criteria) this;
        }

        public Criteria andStatusNotEqualTo(Integer value) {
795
            addCriterion("\"STATUS\" <>", value, "status");
796 797 798 799
            return (Criteria) this;
        }

        public Criteria andStatusGreaterThan(Integer value) {
800
            addCriterion("\"STATUS\" >", value, "status");
801 802 803 804
            return (Criteria) this;
        }

        public Criteria andStatusGreaterThanOrEqualTo(Integer value) {
805
            addCriterion("\"STATUS\" >=", value, "status");
806 807 808 809
            return (Criteria) this;
        }

        public Criteria andStatusLessThan(Integer value) {
810
            addCriterion("\"STATUS\" <", value, "status");
811 812 813 814
            return (Criteria) this;
        }

        public Criteria andStatusLessThanOrEqualTo(Integer value) {
815
            addCriterion("\"STATUS\" <=", value, "status");
816 817 818 819
            return (Criteria) this;
        }

        public Criteria andStatusIn(List<Integer> values) {
820
            addCriterion("\"STATUS\" in", values, "status");
821 822 823 824
            return (Criteria) this;
        }

        public Criteria andStatusNotIn(List<Integer> values) {
825
            addCriterion("\"STATUS\" not in", values, "status");
826 827 828 829
            return (Criteria) this;
        }

        public Criteria andStatusBetween(Integer value1, Integer value2) {
830
            addCriterion("\"STATUS\" between", value1, value2, "status");
831 832 833 834
            return (Criteria) this;
        }

        public Criteria andStatusNotBetween(Integer value1, Integer value2) {
835
            addCriterion("\"STATUS\" not between", value1, value2, "status");
836 837 838 839
            return (Criteria) this;
        }

        public Criteria andPartAccntedPeriodIsNull() {
840
            addCriterion("PART_ACCNTED_PERIOD is null");
841 842 843 844
            return (Criteria) this;
        }

        public Criteria andPartAccntedPeriodIsNotNull() {
845
            addCriterion("PART_ACCNTED_PERIOD is not null");
846 847 848 849
            return (Criteria) this;
        }

        public Criteria andPartAccntedPeriodEqualTo(Integer value) {
850
            addCriterion("PART_ACCNTED_PERIOD =", value, "partAccntedPeriod");
851 852 853 854
            return (Criteria) this;
        }

        public Criteria andPartAccntedPeriodNotEqualTo(Integer value) {
855
            addCriterion("PART_ACCNTED_PERIOD <>", value, "partAccntedPeriod");
856 857 858 859
            return (Criteria) this;
        }

        public Criteria andPartAccntedPeriodGreaterThan(Integer value) {
860
            addCriterion("PART_ACCNTED_PERIOD >", value, "partAccntedPeriod");
861 862 863 864
            return (Criteria) this;
        }

        public Criteria andPartAccntedPeriodGreaterThanOrEqualTo(Integer value) {
865
            addCriterion("PART_ACCNTED_PERIOD >=", value, "partAccntedPeriod");
866 867 868 869
            return (Criteria) this;
        }

        public Criteria andPartAccntedPeriodLessThan(Integer value) {
870
            addCriterion("PART_ACCNTED_PERIOD <", value, "partAccntedPeriod");
871 872 873 874
            return (Criteria) this;
        }

        public Criteria andPartAccntedPeriodLessThanOrEqualTo(Integer value) {
875
            addCriterion("PART_ACCNTED_PERIOD <=", value, "partAccntedPeriod");
876 877 878 879
            return (Criteria) this;
        }

        public Criteria andPartAccntedPeriodIn(List<Integer> values) {
880
            addCriterion("PART_ACCNTED_PERIOD in", values, "partAccntedPeriod");
881 882 883 884
            return (Criteria) this;
        }

        public Criteria andPartAccntedPeriodNotIn(List<Integer> values) {
885
            addCriterion("PART_ACCNTED_PERIOD not in", values, "partAccntedPeriod");
886 887 888 889
            return (Criteria) this;
        }

        public Criteria andPartAccntedPeriodBetween(Integer value1, Integer value2) {
890
            addCriterion("PART_ACCNTED_PERIOD between", value1, value2, "partAccntedPeriod");
891 892 893 894
            return (Criteria) this;
        }

        public Criteria andPartAccntedPeriodNotBetween(Integer value1, Integer value2) {
895
            addCriterion("PART_ACCNTED_PERIOD not between", value1, value2, "partAccntedPeriod");
896 897 898 899
            return (Criteria) this;
        }

        public Criteria andAccntedPeriodIsNull() {
900
            addCriterion("ACCNTED_PERIOD is null");
901 902 903 904
            return (Criteria) this;
        }

        public Criteria andAccntedPeriodIsNotNull() {
905
            addCriterion("ACCNTED_PERIOD is not null");
906 907 908 909
            return (Criteria) this;
        }

        public Criteria andAccntedPeriodEqualTo(Integer value) {
910
            addCriterion("ACCNTED_PERIOD =", value, "accntedPeriod");
911 912 913 914
            return (Criteria) this;
        }

        public Criteria andAccntedPeriodNotEqualTo(Integer value) {
915
            addCriterion("ACCNTED_PERIOD <>", value, "accntedPeriod");
916 917 918 919
            return (Criteria) this;
        }

        public Criteria andAccntedPeriodGreaterThan(Integer value) {
920
            addCriterion("ACCNTED_PERIOD >", value, "accntedPeriod");
921 922 923 924
            return (Criteria) this;
        }

        public Criteria andAccntedPeriodGreaterThanOrEqualTo(Integer value) {
925
            addCriterion("ACCNTED_PERIOD >=", value, "accntedPeriod");
926 927 928 929
            return (Criteria) this;
        }

        public Criteria andAccntedPeriodLessThan(Integer value) {
930
            addCriterion("ACCNTED_PERIOD <", value, "accntedPeriod");
931 932 933 934
            return (Criteria) this;
        }

        public Criteria andAccntedPeriodLessThanOrEqualTo(Integer value) {
935
            addCriterion("ACCNTED_PERIOD <=", value, "accntedPeriod");
936 937 938 939
            return (Criteria) this;
        }

        public Criteria andAccntedPeriodIn(List<Integer> values) {
940
            addCriterion("ACCNTED_PERIOD in", values, "accntedPeriod");
941 942 943 944
            return (Criteria) this;
        }

        public Criteria andAccntedPeriodNotIn(List<Integer> values) {
945
            addCriterion("ACCNTED_PERIOD not in", values, "accntedPeriod");
946 947 948 949
            return (Criteria) this;
        }

        public Criteria andAccntedPeriodBetween(Integer value1, Integer value2) {
950
            addCriterion("ACCNTED_PERIOD between", value1, value2, "accntedPeriod");
951 952 953 954
            return (Criteria) this;
        }

        public Criteria andAccntedPeriodNotBetween(Integer value1, Integer value2) {
955
            addCriterion("ACCNTED_PERIOD not between", value1, value2, "accntedPeriod");
956 957 958 959 960 961
            return (Criteria) this;
        }
    }

    /**
     * This class was generated by MyBatis Generator.
neo's avatar
neo committed
962
     * This class corresponds to the database table TAX_PROJECT.CUSTOMS_INVOICE
963 964 965 966 967 968 969 970 971 972 973 974
     *
     * @mbg.generated do_not_delete_during_merge
     */
    public static class Criteria extends GeneratedCriteria {

        protected Criteria() {
            super();
        }
    }

    /**
     * This class was generated by MyBatis Generator.
neo's avatar
neo committed
975
     * This class corresponds to the database table TAX_PROJECT.CUSTOMS_INVOICE
976 977 978 979 980 981 982 983 984 985 986 987 988 989 990 991 992 993 994 995 996 997 998 999 1000 1001 1002 1003 1004 1005 1006 1007 1008 1009 1010 1011 1012 1013 1014 1015 1016 1017 1018 1019 1020 1021 1022 1023 1024 1025 1026 1027 1028 1029 1030 1031 1032 1033 1034 1035 1036 1037 1038 1039 1040 1041 1042 1043 1044 1045 1046 1047 1048 1049 1050 1051 1052 1053 1054 1055 1056 1057 1058 1059 1060 1061 1062 1063 1064
     *
     * @mbg.generated
     */
    public static class Criterion {
        private String condition;

        private Object value;

        private Object secondValue;

        private boolean noValue;

        private boolean singleValue;

        private boolean betweenValue;

        private boolean listValue;

        private String typeHandler;

        public String getCondition() {
            return condition;
        }

        public Object getValue() {
            return value;
        }

        public Object getSecondValue() {
            return secondValue;
        }

        public boolean isNoValue() {
            return noValue;
        }

        public boolean isSingleValue() {
            return singleValue;
        }

        public boolean isBetweenValue() {
            return betweenValue;
        }

        public boolean isListValue() {
            return listValue;
        }

        public String getTypeHandler() {
            return typeHandler;
        }

        protected Criterion(String condition) {
            super();
            this.condition = condition;
            this.typeHandler = null;
            this.noValue = true;
        }

        protected Criterion(String condition, Object value, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.typeHandler = typeHandler;
            if (value instanceof List<?>) {
                this.listValue = true;
            } else {
                this.singleValue = true;
            }
        }

        protected Criterion(String condition, Object value) {
            this(condition, value, null);
        }

        protected Criterion(String condition, Object value, Object secondValue, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.secondValue = secondValue;
            this.typeHandler = typeHandler;
            this.betweenValue = true;
        }

        protected Criterion(String condition, Object value, Object secondValue) {
            this(condition, value, secondValue, null);
        }
    }
}