Project

General

Profile

Edit Copy Actions

Feature #69

open

Cheque Book List

Added by Anil KV over 2 years ago. Updated 4 months ago.

Status:
Reopen Bugs Testing Done
Priority:
Normal
Assignee:
Target version:
Start date:
10/15/2022
Due date:
% Done:

90%

Estimated time:
Owner(Agency):
Travvise
Time Taken(HH):
Module:
Cheque Book List
Tested By:
unnikannan S
Code Reviewed By:

Description

Coding Cheque Book List


Files

clipboard-202410141053-gengh.png (74.7 KB) clipboard-202410141053-gengh.png Arathy PS, 10/14/2024 10:54 AM

Add

Subtasks


Add

Related issues

Actions #1

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

Actions #4

Updated by Anonymous over 2 years ago

  • Status changed from New to Particialy Coding Done
  • % Done changed from 0 to 30
Actions #5

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

Actions #7

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

Actions #9

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

Actions #12

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.

Actions #14

Updated by Junaid M over 1 year ago

  • Assignee changed from Abhiram Venu to Shahil Haris
Actions #15

Updated by Shahil Haris over 1 year ago

  • Status changed from Reopen Bugs to Reopen Bugs Coding Done
  • % Done changed from 50 to 60
Actions #16

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

Actions #18

Updated by Junaid M 12 months ago

  • Assignee changed from Amal Siby to Nithin Raj
Actions #19

Updated by Nithin Raj 12 months ago

  • Status changed from Reopen Bugs to Reopen Bugs Coding Done
  • % Done changed from 50 to 70

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.FIX BUGS ON PRINT

Actions #21

Updated by Nithin Raj 12 months ago

  • Status changed from Reopen Bugs to Reopen Bugs Coding Done
  • % Done changed from 50 to 70

Updated by unnikannan S 12 months ago

ISSUE FOUNDED

1.FREEZE THE UI FIELDS AFTER SHOWING THE DATA

Actions #23

Updated by unnikannan S 12 months ago

  • Status changed from Reopen Bugs Coding Done to Reopen Bugs
  • % Done changed from 70 to 50
Actions #24

Updated by Nithin Raj 12 months ago

  • Status changed from Reopen Bugs to Reopen Bugs Coding Done
  • % Done changed from 50 to 70

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
2.SHOWING BLANK WHILE SELECTING PRINT BUTTON WITHOUT DATA

done

Actions #26

Updated by Nithin Raj 12 months ago

  • Status changed from Reopen Bugs to Reopen Bugs Coding Done
  • % Done changed from 50 to 70

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

Actions #28

Updated by Junaid M 12 months ago

  • Assignee changed from Nithin Raj to Vivekp V

Updated by Vivekp V 12 months ago

  • Status changed from Reopen Bugs to Reopen Bugs Coding Done
  • % Done changed from 50 to 70

ISSUE FIXED

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 unnikannan S 12 months ago

TESTING DONE

Updated by Arathy PS 7 months ago

  • Status changed from Reopen Bugs Coding Done to Reopen Bugs
  • % Done changed from 70 to 50

ISSUE FOUNDED:
1)UPDATE THE NO: OF USED, NO: OF CANCELLED AND BALANCE AS WE USE CHEQUE LEAFS

Updated by Vivekp V 7 months ago

  • Status changed from Reopen Bugs to Reopen Bugs Coding Done
  • % Done changed from 50 to 70

ISSUE FIXED:
1)UPDATE THE NO: OF USED, NO: OF CANCELLED AND BALANCE AS WE USE CHEQUE LEAFS

Updated by unnikannan S 6 months ago

  • Status changed from Reopen Bugs Coding Done to Reopen Bugs
  • % Done changed from 70 to 50

ISSUE FOUNDED

1.Clear Bank Code On Focus Out While Clearing Name

Updated by Vivekp V 6 months ago

  • Status changed from Reopen Bugs to Reopen Bugs Coding Done
  • % Done changed from 50 to 70

ISSUE FIXED

1.Clear Bank Code On Focus Out While Clearing Name

Updated by unnikannan S 6 months ago

  • Status changed from Reopen Bugs Coding Done to Reopen Bugs
  • % Done changed from 70 to 50

ISSUE FOUNDED

1.Freeze The Bank Auto Completion Field After Showing Data In List

Updated by Vivekp V 6 months ago

  • Status changed from Reopen Bugs to Reopen Bugs Coding Done
  • % Done changed from 50 to 70

ISSUE FIXED

1.Freeze The Bank Auto Completion Field After Showing Data In List

Updated by Arathy PS 5 months ago

ISSUE FOUND
-----------------------
1. Incorrect values in the used, cancelled and balance columns

image of a newly created cheque book.

Updated by Vivekp V 5 months ago

  • Status changed from Reopen Bugs to Reopen Bugs Coding Done
  • % Done changed from 50 to 70

ISSUE FIXED
-----------------------
1. Incorrect values in the used, cancelled and balance columns

Actions #39

Updated by Arathy PS 4 months ago

  • Status changed from Reopen Bugs Coding Done to Reopen Bugs Testing Done
  • % Done changed from 70 to 90

Updated by Arathy PS 4 months ago

  • Status changed from Reopen Bugs Testing Done to Reopen Bugs
  • % Done changed from 90 to 50

ISSUE FOUND
----------------------------------------
1. When status is 'not used' the the cheque books that are used are showing.

Updated by Vivekp V 4 months ago

  • Status changed from Reopen Bugs to Reopen Bugs Coding Done
  • % Done changed from 50 to 70

ISSUE FIXED
----------------------------------------
1. When status is 'not used' the the cheque books that are used are showing.

Actions #42

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
Edit Copy Actions

Also available in: Atom PDF