Project

General

Profile

Edit Copy Actions
Copy link

Feature #212

open

Recurring Documents Summary

Added by Junaid M over 1 year ago. Updated about 1 month ago.

Status:
Reopen Bugs Testing Done
Priority:
Normal
Assignee:
Shilpa Pavithran
Target version:
22.12
Start date:
06/27/2023
Due date:
% Done:

90%

Estimated time:
Owner(Agency):
Travvise
Time Taken(HH):
Module:
Recurring Documents Summary
Tested By:
Code Reviewed By:
Quote

Description

Coding Recurring Documents Summary

Add

Subtasks

Add

Related issues

QuoteActions
Copy link
 #1

Updated by Anonymous over 1 year ago

GUI CHANGES

*ADD MANDATORY FIELD ON MAIN DOC PERIOD
 *ADD BLUE STAR ON SUB DOC INCLUDED PERIOD
QuoteActions
Copy link
 #2

Updated by Anil KV 8 months ago 

->Status
Tick-Not Started(Document Creation)
Tick-Part Completed(Some Documents Created)
Tick-Fully Completed(Full Documents Created)
Tick-Includ Canceled Documents
UnTick-Deleted
-> Add a colunsafter Pending - Cancel(Count)
-> Pending to Pending(Count)
-> last Column Details icon - redirect to 'Recurring Documents Details'
-> Grid 'Status' Column value
-Not Started(Document Creation)
-Part Completed(Some Documents Created)
-Fully Completed(Full Documents Created)
-Deleted

SQL
-> Discus with Anil
Ref: https://www.db-fiddle.com/f/2VWyUD9YnFcFCMbJkfz6YS/0
Select      m.remarks, 
            Count(d.status) filter (where d.status = 1) as status1_cnt,
            Count(d.status) filter (where d.status = 2) as status2_cnt,
            Count(d.status) filter (where d.status = 3) as status3_cnt
From        master m
Inner Join details d ON( d.m_id = m.m_id )
Group By    m.remarks
Actions
Copy link
 #3

Updated by Anil KV 8 months ago

  • Status changed from New to Ready for Coding
  • % Done changed from 0 to 20
Actions
Copy link
 #4

Updated by Anonymous 7 months ago

  • Assignee changed from travvise Admin to Bertin Joseph
Actions
Copy link
 #5

Updated by Anil KV 5 months ago

  • Assignee changed from Bertin Joseph to Amal Ck
Actions
Copy link
 #6

Updated by Junaid M 5 months ago

  • Assignee changed from Amal Ck to Shilpa Pavithran
Actions
Copy link
 #7

Updated by Shilpa Pavithran 5 months ago

  • Status changed from Ready for Coding to Coding Started
  • % Done changed from 20 to 30
Actions
Copy link
 #8

Updated by Shilpa Pavithran 5 months ago

  • Status changed from Coding Started to Ready for Coding
  • % Done changed from 30 to 20
Actions
Copy link
 #9

Updated by Shilpa Pavithran 4 months ago

  • Status changed from Ready for Coding to Coding Started
  • % Done changed from 20 to 30
Actions
Copy link
 #10

Updated by Shilpa Pavithran 4 months ago

  • Status changed from Coding Started to Coding Done
  • % Done changed from 30 to 60
QuoteActions
Copy link
 #11

Updated by Theja Ponon about 2 months ago

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

ISSUE FOUND
------------------
1)ISSUE ON STATUS FILTERING
2)ISSUE ON REDIRECTION TO DETAIL PAGE
3)DOCUMENT NUMBER IS NOT REDIRECTING TO DOCUMENT MODULE

Actions
Copy link
 #12

Updated by Shilpa Pavithran about 1 month ago

  • Status changed from Reopen Bugs to Reopen Bugs Coding Done
  • % Done changed from 50 to 70
Actions
Copy link
 #13

Updated by Theja Ponon about 1 month ago

  • Status changed from Reopen Bugs Coding Done to Reopen Bugs Testing Done
  • % Done changed from 70 to 90
Edit Copy Actions
Copy link

Also available in: Atom PDF