Fetch response

[pinezapple]

• Select all sale bill response

• Select Sale bill by id response

• Select all borrow form response

• Select borrow form by id

• Select all payment response (pending)

• Select payment by id (pending)

• Select all avail/damaged/selling barcode response

• Select barcode by id response

• Select all from black list

• Select black list by id

[pinezapple]

Select all sale bill response

[
   {
       sale_bill_id: 0,
       librarian_id: 0,
       librarian_name: "",
       total_money: 0,
       created_at:  timestamp
   },
   {
       sale_bill_id: 0,
       librarian_id: 0,
       librarian_name: "",
       total_money: 0,
       created_at:  timestamp
   },
  ...
]

[pinezapple]

Select Sale bill by id response

{
	sale_bill_id: 0,
	librarian_id: 0,
	librarian_name: "",
	total_money: 0,
	barcodes: [
             {
        	barcode_id: 0,
	        doc_name: "",
	        money: 0,
              },
             {
        	barcode_id: 0,
	        doc_name: "",
	        money: 0,
              },
            ...
        ],
	created_at: timestamp,
}

[pinezapple]

Select all borrow form response

[
  {
	borrow_form_id: 0,
	librarian_id: 0,
	librarian_name: "",
        reader_id: 0,
	reader_name: "",
	status: 0,
	fine: 0,
	barcode_id: [0,0,0],
	start_time: timestamp,
	end_time: timestamp,
	created_at: timestamp,
	updated_at: timestamp,
   },
  {
	borrow_form_id: 0,
	librarian_id: 0,
	librarian_name: "",
        reader_id: 0,
	reader_name: "",
	status: 0,
	fine: 0,
	barcode_id: [0,0,0],
	start_time: timestamp,
	end_time: timestamp,
	created_at: timestamp,
	updated_at: timestamp,
   },
  ...
]

[pinezapple]

Select borrow form by id

{
        borrow_form_id: 0,
	librarian_id: 0,
	librarian_name: "",
        reader_id: 0,
	reader_name: "",
	status: 0,
	fine: 0,
	barcodes: [
        {
	  barcode_id: 0,
	  status: 0,
	  doc_name: "",
	  author: "",
	  fee: 0,
	  price: 0
        }, 
        ...
        ]
	start_time: timestamp,
	end_time: timestamp
}

[pinezapple]

Select all payment response (pending, will be fixed by tmr):

[
{
  payment_id: 0,
  borrow_form_id: 0,
  total_money: 0,
  librarian_id: 0,
  librarian_name: "",
  reader_id: 0,
  reader_name: "",
  created_at: timestamp
},
....
]

[pinezapple]

Select payment by id (pending, will be fixed by tmr)::

{
	payment_id: 0,
	borrow_form_id: 0,
	librarian_id: 0,
        reader_id: 0,
	total_money: 0,
        fine: 0,
	barcodes: [
        {
	  barcode_id 0, 
	  status: 0,
          doc_name: "",
          author_name: "",
	  money: 0
        },
        ....
        ]
}

[pinezapple]

Select all avail/damaged/selling barcode response:

[
  {
	barcode_id: 0,
	status: 0,
	doc_name: "",
	doc_id: 0,
	version: "",
	author: "",
	publisher: "",
	fee: 0
	price: 0
	description: ""
	category: ""
	sale_bill_id: 0,
	created_at: timestamp
  },
  {
	barcode_id: 0,
	status: 0,
	doc_name: "",
	doc_id: 0,
	version: "",
	author: "",
	publisher: "",
	fee: 0
	price: 0
	description: ""
	category: ""
	sale_bill_id: 0,
	created_at: timestamp
  },
...
]

[pinezapple]

Select barcode by id response:

  {
	barcode_id: 0,
	status: 0,
	doc_name: "",
	doc_id: 0,
	version: "",
	author: "",
	publisher: "",
	fee: 0
	price: 0
	description: ""
	category: ""
	sale_bill_id: 0,
	created_at: timestamp
  }

[pinezapple]

Select all from black list:

[
  {
    user_id: 0,
    username: "",
    count: 0,
    money: 0,
  },
  {
    user_id: 0,
    username: "",
    count: 0,
    money: 0,
  },
]

[pinezapple]

Select black list by id:

{
    user_id: 0,
    username: "",
    count: 0,
    money: 0,
    detail: [
      {
         user_id: 0,
         borrow_form_id: 0,
         money: 0,
         created_at
      },
      ...
    ]
}

[pinezapple]

Select all document response:

[
 {
	    doc_id: 0,
	    doc_name: "",
	    category_name: "",
	    created_at: timestamp
}


]

[pinezapple]

Select Doc by id

 {
	    doc_id: 0,
	    doc_name: "",
	    category_name: "",
            doc_version: [
             {
              document_version_id:0
              document_version: "",
              publisher:"",
              author_name:"",
              count:0,
              price:0,
            }
            ],
	    created_at: timestamp
}