TAAS

SELECT cb.pk_cheque_book_id,
cb.fk_bank_id,
ac.pk_account_id,
ac.vhr_account_name,
ac.vhr_display_name,
cb.dat_entered,
cb.vhr_cheque_book_number,
cb.vhr_start_number,
cb.vhr_end_number,
cb.arb_fk_branch_ids,
csc.int_active,
csc.int_canceled,
csc.int_used,
csc.int_sequirty
FROM paidcheque.tbl_cheque_book AS cb
LEFT JOIN (
SELECT MIN AS fk_cheque_book_id,
COUNT AS int_active,
COUNT AS int_canceled,
COUNT AS int_used,
COUNT AS int_sequirty
FROM (
SELECT * FROM CROSSTAB(
$$ SELECT vhr_cheque_number,
fk_cheque_book_id,
sin_leaf_status,
vhr_cheque_number
FROM paidcheque.tbl_cheque_leaf
ORDER BY 1 $$,
$$ SELECT sin_status FROM GENERATE_SERIES(0,3) AS sin_status $$) AS
(vhr_cheque_number VARCHAR,
fk_cheque_book_id INT,
vhr_canceled VARCHAR,
vhr_active VARCHAR,
vhr_used VARCHAR,
vhr_sequirty VARCHAR)) AS tmp
GROUP BY fk_cheque_book_id) AS csc
ON cb.pk_cheque_book_id = csc.fk_cheque_book_id
LEFT JOIN accounts.tbl_account AS ac
ON cb.fk_bank_id = ac.pk_account_id
WHERE int_sys_action_id != -1 AND ...
AND pk_cheque_book_id IN

---------REFINED-----------

SELECT
cb.pk_cheque_book_id,
cb.fk_bank_id,
ac.pk_account_id,
ac.vhr_account_name,
ac.vhr_display_name,
cb.dat_entered,
cb.vhr_cheque_book_number,
cb.vhr_start_number,
cb.vhr_end_number,
cb.arb_fk_branch_ids,
csc.int_active,
csc.int_canceled,
csc.int_used,
csc.int_sequirty
FROM paidcheque.tbl_cheque_book AS cb
LEFT JOIN (
SELECT
MIN AS fk_cheque_book_id,
COUNT AS int_active,
COUNT AS int_canceled,
COUNT AS int_used,
COUNT AS int_sequirty
FROM (
SELECT * FROM CROSSTAB(
$$ SELECT vhr_cheque_number,
fk_cheque_book_id,
sin_leaf_status,
vhr_cheque_number
FROM paidcheque.tbl_cheque_leaf
ORDER BY 1 $$,
$$ SELECT sin_status FROM GENERATE_SERIES(0,3) AS sin_status $$) AS
(vhr_cheque_number VARCHAR,
fk_cheque_book_id INT,
vhr_canceled VARCHAR,
vhr_active VARCHAR,
vhr_used VARCHAR,
vhr_sequirty VARCHAR)) AS tmp
GROUP BY fk_cheque_book_id) AS csc

ON cb.pk_cheque_book_id = csc.fk_cheque_book_id
LEFT JOIN accounts.tbl_account AS ac
ON cb.fk_bank_id = ac.pk_account_id
WHERE cb.int_sys_action_id != -1 ;
AND pk_cheque_book_id IN;

AND pk_cheque_book_id IN(SELECT DISTINCT fk_cheque_book_id FROM tbl_cheque_leaf WHERE vhr_cheque_number input

unnikannan S wrote in #note-10:

ISSUE FOUNDED

1.ADD BLANK OPTION IN STATUS
2.CLICKING EDIT OPTION LOG OUT

ISSUE FOUNDED

1.FREEZE THE UI FIELDS AFTER SHOWING THE DATA

TESTING DONE