Feature #69
openCheque Book List
Added by Anil KV over 2 years ago. Updated 4 months ago.
90%
Files
clipboard-202410141053-gengh.png (74.7 KB) clipboard-202410141053-gengh.png | Arathy PS, 10/14/2024 10:54 AM |
Subtasks
Related issues
Updated by Anil KV over 2 years ago
- Assignee set to Junaid M
- Module changed from Cheque Book to Cheque Book List
Updated by Anil KV over 2 years ago
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;
Updated by Anil KV over 2 years ago
AND pk_cheque_book_id IN(SELECT DISTINCT fk_cheque_book_id FROM tbl_cheque_leaf WHERE vhr_cheque_number input
Updated by Anonymous over 2 years ago
- Status changed from New to Particialy Coding Done
- % Done changed from 0 to 30
Updated by Anonymous over 2 years ago
- Status changed from Particialy Coding Done to Coding Done
- % Done changed from 30 to 60
Updated by Amal Cyriac over 2 years ago
- Status changed from Coding Done to Reopen Bugs
- % Done changed from 60 to 50
- Tested By set to Amal Cyriac
ISSUE FOUND
*****
1.SET MANDATORY BOX RED
Updated by Junaid M over 2 years ago
- Status changed from Reopen Bugs to Reopen Bugs Coding Done
- % Done changed from 50 to 60
Updated by Amal Cyriac over 2 years ago
- Status changed from Reopen Bugs Coding Done to Reopen Bugs
- % Done changed from 60 to 50
ISSUE FOUND
*****
1.SET MANDATORY FIELD RED AND REQUIRED
Updated by Junaid M about 2 years ago
- Status changed from Reopen Bugs to Coding Done
- % Done changed from 50 to 60
Updated by unnikannan S over 1 year ago
- Status changed from Coding Done to Reopen Bugs
- % Done changed from 60 to 50
- Tested By changed from Amal Cyriac to unnikannan S
ISSUE FOUNDED
1.ADD BLANK OPTION IN STATUS
Updated by unnikannan S over 1 year ago
unnikannan S wrote in #note-10:
ISSUE FOUNDED
1.ADD BLANK OPTION IN STATUS
2.CLICKING EDIT OPTION LOG OUT
Updated by Anil KV over 1 year ago
- Assignee changed from Junaid M to Abhiram Venu
Updated by Seema Mathew over 1 year ago
- Tested By changed from unnikannan S to Seema Mathew
ISSUE FOUNDED****
1.EDIT ICON REDIRECTION IS NOT WORKING.
Updated by Junaid M over 1 year ago
- Assignee changed from Abhiram Venu to Shahil Haris
Updated by Shahil Haris over 1 year ago
- Status changed from Reopen Bugs to Reopen Bugs Coding Done
- % Done changed from 50 to 60
Updated by Junaid M about 1 year ago
- Assignee changed from Shahil Haris to Amal Siby
Updated by unnikannan S about 1 year ago
- Status changed from Reopen Bugs Coding Done to Reopen Bugs
- % Done changed from 70 to 50
- Tested By changed from Seema Mathew to unnikannan S
ISSUE FOUNDED
1.SHOWING PRINT BLANK
2.CHANGE PRINT OPTION POP UP (REFER BRANCH)
Done
Updated by unnikannan S 12 months ago
- Status changed from Reopen Bugs Coding Done to Reopen Bugs
- % Done changed from 70 to 50
ISSUE FOUNDED
1.CORRECT THE FUNCTION OF RESET BUTTON (REFER OTHER REPORT/LIST MODULES)
2.IN CASE OF NO DATA FOUND IN UI NOT NEED TO FREEZE THE FILTER FIELDS
Updated by Arathy PS 5 months ago
- File clipboard-202410141053-gengh.png clipboard-202410141053-gengh.png added
- Status changed from Reopen Bugs Coding Done to Reopen Bugs
- % Done changed from 70 to 50
ISSUE FOUND
-----------------------
1. Incorrect values in the used, cancelled and balance columns
image of a newly created cheque book.
Updated by Theja Ponon 4 months ago
- Status changed from Reopen Bugs Coding Done to Reopen Bugs Testing Done
- % Done changed from 70 to 90