7.10.1. Invoice Items

We make the class for viewing the invoice items via jqGrid a little simpler. Its records are filtered by invoice header code and user-driven search and sort options are not implemented.

  1. package ru.ibase.fbjavaex.jqgrid;
  3. import org.jooq.*;
  5. import java.util.List;
  6. import java.util.Map;
  8. import static ru.ibase.fbjavaex.exampledb.Tables.INVOICE_LINE;
  9. import static ru.ibase.fbjavaex.exampledb.Tables.PRODUCT;
  11. /**
  12.  * The grid handler for the invoice items
  13.  *
  14.  * @author Simonov Denis
  15.  */
  16. public class JqGridInvoiceLine extends JqGrid {
  18.     private int invoiceId;
  20.     public int getInvoiceId() {
  21.         return this.invoiceId;
  22.     }
  24.     public void setInvoiceId(int invoiceId) {
  25.         this.invoiceId = invoiceId;
  26.     }
  28.     /**
  29.      * Returns the total number of records
  30.      *
  31.      * @return
  32.      */
  33.     @Override
  34.     public int getCountRecord() {
  35.         SelectFinalStep<?> select
  36.             = dsl.selectCount()
  37.                  .from(INVOICE_LINE)
  38.                  .where(INVOICE_LINE.INVOICE_ID.eq(this.invoiceId));
  40.         SelectQuery<?> query = select.getQuery();
  42.         return (int) query.fetch().getValue(0, 0);
  43.     }
  45.     /**
  46.      * Returns invoice items
  47.      *
  48.      * @return
  49.      */
  50.     @Override
  51.     public List<Map<String, Object>> getRecords() {
  52.         SelectFinalStep<?> select = dsl.select(
  53.                 INVOICE_LINE.INVOICE_LINE_ID,
  54.                 INVOICE_LINE.INVOICE_ID,
  55.                 INVOICE_LINE.PRODUCT_ID,
  56.                 PRODUCT.NAME.as("PRODUCT_NAME"),
  57.                 INVOICE_LINE.QUANTITY,
  58.                 INVOICE_LINE.SALE_PRICE,
  59.                 INVOICE_LINE.SALE_PRICE.mul(INVOICE_LINE.QUANTITY).as("TOTAL"))
  60.             .from(INVOICE_LINE)
  61.             .innerJoin(PRODUCT).on(PRODUCT.PRODUCT_ID.eq(INVOICE_LINE.PRODUCT_ID))
  62.             .where(INVOICE_LINE.INVOICE_ID.eq(this.invoiceId));
  64.         SelectQuery<?> query = select.getQuery();
  65.         return query.fetchMaps();
  66.     }
  67. }