Project

General

Profile

Edit Copy Actions

Feature #288

open

Document Tracker

Added by Junaid M about 1 year ago. Updated 3 months ago.

Status:
Reopen Bugs Coding Done
Priority:
Normal
Assignee:
Target version:
Start date:
01/18/2024
Due date:
% Done:

70%

Estimated time:
Owner(Agency):
Travvise
Time Taken(HH):
Module:
Document Tracker
Tested By:
unnikannan S
Code Reviewed By:

Description

Coding Document Tracker


Add

Subtasks


Add

Related issues

Updated by Anil KV 8 months ago

??? It is required to Atleast one GDS should be selected in System settings->GDS->Active GDS for the working of this module.
[Remove the message]
Working Ref
-Set Next Doc No
-Set Document Code Format
-Set Document Code

-Add Column after Next No - Highest Value
-Add Column(Last) - Missing Numbers, Deleted Documents
*Active Document Count, Missing Document Count, Deleted Document Count

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
--------------------------------------------------------------------
SELECT fk_doc_no_generator_id,
    MIN(vhr_document_code) AS vhr_document_code,
    MIN(bin_number_part) AS bin_start_number,
    MAX(bin_number_part) AS bin_end_number,
    STRING_AGG(DISTINCT vhr_sys_module_name, ',') AS vhr_sys_module_names,
    MAX(bin_last_number) AS bin_last_number,
    MAX(bin_highest_number) AS bin_highest_number,
    COUNT(int_sys_action_id) FILTER  (WHERE int_sys_action_id != -1) AS bin_active_document_count,
    COUNT(int_sys_action_id) FILTER  (WHERE int_sys_action_id = -1) AS bin_deleted_document_count,
    ARRAY_AGG(bin_number_part) AS arb_generated_doc_numbers
FROM (SELECT doc.fk_doc_no_generator_id,
          doc.vhr_doc_no_code_part AS vhr_document_code,
        doc.vhr_sys_module_name,
          dog.pk_doc_no_generator_id,
        dog.bin_last_number,
        dog.bin_highest_number,
        doc.bin_number_part,
        doc.int_sys_action_id
    FROM document.tbl_documents doc
        INNER JOIN document.tbl_doc_no_generator dog
            ON dog.pk_doc_no_generator_id = doc.fk_doc_no_generator_id
     WHERE ...) AS tmp
GROUP BY fk_doc_no_generator_id

if missing count > 0
show
else
not show

Actions #2

Updated by Anil KV 8 months ago

  • Status changed from New to Ready for Coding
  • % Done changed from 0 to 20
Actions #3

Updated by Anonymous 8 months ago

  • Assignee changed from travvise Admin to Augustin Jose
Actions #4

Updated by Anonymous 8 months ago

  • Assignee changed from Augustin Jose to Sarath Krishnan
Actions #5

Updated by Anonymous 7 months ago

  • Status changed from Ready for Coding to Coding Started
  • % Done changed from 20 to 30
Actions #6

Updated by Sarath Krishnan 7 months ago

  • Status changed from Coding Started to Ready for Coding
  • % Done changed from 30 to 20
Actions #7

Updated by Sarath Krishnan 7 months ago

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

Updated by Sarath Krishnan 7 months ago

  • Status changed from Coding Started to Coding Done
  • % Done changed from 30 to 60

Updated by Avinash MS 7 months ago

  • Status changed from Coding Done to Reopen Bugs
  • % Done changed from 60 to 50
  • Tested By set to Avinash MS

Issue Found
------------------------------------------------
1) Missing Numbers are not shown in the table
2)Show Grid And Module Name In Print In Case Of No Data
3)Fix the issue in translation

Actions #10

Updated by Sarath Krishnan 7 months ago

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

Updated by Arathy PS 6 months ago

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

ISSUE FOUND
----------------
Data should be showing while we click search button without entering data in any fields.

Actions #12

Updated by Sarath Krishnan 6 months ago

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

Updated by unnikannan S 3 months ago

  • Status changed from Reopen Bugs Coding Done to Reopen Bugs
  • % Done changed from 70 to 50
  • Tested By changed from Avinash MS to unnikannan S

ISSUE FIXED

1.Print Not Working

Actions #14

Updated by Anil KV 3 months ago

  • Assignee changed from Sarath Krishnan to Sreeranjini T
Actions #15

Updated by Sreeranjini T 3 months ago

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

Also available in: Atom PDF