Project

General

Profile

Edit Copy Actions

Feature #265

open

Document User Permission

Added by Anil KV over 1 year ago. Updated 4 months ago.

Status:
Reopen Bugs Coding Done
Priority:
Normal
Assignee:
Target version:
Start date:
10/26/2023
Due date:
% Done:

70%

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

Description

Coding Document User Permission


Files

clipboard-202408271133-34doh.png (81.2 KB) clipboard-202408271133-34doh.png Arathy PS, 08/27/2024 11:33 AM

Add

Subtasks


Add

Related issues

Updated by Anil KV over 1 year ago

  • Status changed from New to Open
  • Assignee changed from travvise Admin to Amal Siby
  • % Done changed from 0 to 10

-> Table: locking.tbl_doc_user_permission

Actions #2

Updated by Amal Siby over 1 year ago

  • Status changed from Open to Coding Started
  • Start date changed from 07/19/2023 to 10/26/2023
  • % Done changed from 10 to 40

Updated by Amal Siby over 1 year ago

Coding Logic
-------------
1, Gui Change ==> Add ModifiedBy in Grid
2, Don't allow same range of period from And to date.
3, Keep Log while Deleting.
If the item has Deleted Then Show in the grid with red Color And Not Allow Edit and Delete
4, While updating the existing item ( delete it internally, at the same time Insert should be performed, update should not be performed.).

Updated by Amal Siby about 1 year ago

  • Status changed from Coding Started to Particialy Coding Done

Log Section is Pending

Actions #5

Updated by Amal Siby about 1 year ago

  • Status changed from Particialy Coding Done to Coding Done
  • % Done changed from 40 to 60

Updated by unnikannan S about 1 year ago

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

ISSUE FOUNDED

1.ERROR IN UNLOCK

P0001: jsnSqlRes: {"sinSqlCustomStatus" : 1, "strSqlCustomStatusCode" : "ERROR", "strSqlCustomMessage" : "Document User Permission Save Failed", "strSqlCustomErrorType" : "DATABASE_SYSTEM_ERROR", "strSqlCustomErrorCode" : null, "strSqlSysMessage" : "invalid transaction termination", "strSqlSysExceptionDetail" : "", "strSqlSysExceptionHint" : "PL/pgSQL function sp_insert_or_update_doc_user_permission_log(bigint) line 80 at ROLLBACK\nSQL statement \"CALL sp_insert_or_update_doc_user_permission_log(CAST(jsnDocUserPermission>>'binDocUserPermissionId' AS BIGINT)::BIGINT, jsnSqlRes)\"\nPL/pgSQL function sp_insert_or_update_doc_user_permission(jsonb) line 24 at CALL", "binSqlPk" : 9, "binSqlLogPk" : 0, "strSqlDocNo" : null, "dctSqlOtherData" : {"binDocUserPermissionId": "9"}}

Add 2.SHOW VALID DOC DATE
Fixed 3.ERROR WHILE UNLOCK WITHOUT DOC NO ADDING (Error converting value {null} to type 'System.DateTime'. Path 'mdlDocUserPermission.dtmLocked', line 1, position 724.)

Actions #7

Updated by Amal Siby about 1 year ago

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

Updated by unnikannan S about 1 year ago

TESTING DONE

Updated by unnikannan S 12 months ago

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

UI CHANGE

Done 1.Column Items-(SlNo, DocAction, ActionDate&Time, ActionUser, Permission Period, Action Permitted, UpdateType, Remarks, Add

Done 2.NEW SELECT BOX-UPDATE LOCK TYPE (Change Locking Multi Selections)
*Document Update (Default)
*Posting Change Lock

3.User Permission No Log
Done 4.Doc Locking+Doc Lock Log+Doc User Permission Descending Order Data Sort BY Date Wise

Actions #10

Updated by Amal Siby 12 months ago

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

Updated by Arathy PS 7 months ago

ISSUE FOUND:

Issue in date in the document user permission history

Actions #12

Updated by Anonymous 6 months ago

  • Assignee changed from Amal Siby to Augustin Jose

Updated by Augustin Jose 6 months ago

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

Not able to reproduce

Updated by Arathy PS 5 months ago

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

ISSUE FOUND
----------------------------------------------
1. Full Data from document locking history is showing.
2. Document user permission history is not showing.
3. No translation for action permission, locked, grid title, unlock.

Actions #15

Updated by Arathy PS 5 months ago

  • Assignee changed from Augustin Jose to Nithin PM
Actions #16

Updated by Nithin PM 4 months ago

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

Updated by Arathy PS 4 months ago

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

ISSUE FOUND
-------------------------------------------
1. Status not changing when document has given user permission and then locked then again loaded to document user permission.

Actions #18

Updated by Nithin PM 4 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