TAAS

GUI CHANGES

*ADD MANDATORY FIELD ON MAIN DOC PERIOD
 *ADD BLUE STAR ON SUB DOC INCLUDED PERIOD

->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

-> 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