Feature #295
openUser Activity Report
Added by Junaid M about 1 year ago. Updated about 5 hours ago.
Start date:
02/02/2024
Due date:
% Done:
70%
Estimated time:
Owner(Agency):
Travvise
Time Taken(HH):
Module:
User Activity Report
Tested By:
unnikannan S
Code Reviewed By:
Files
master tab.txt (1.53 KB) master tab.txt | Greeshma S, 05/25/2024 07:42 PM |
Subtasks
Related issues
Updated by Junaid M about 1 year ago
- Status changed from New to Open
- % Done changed from 0 to 10
Updated by Anil KV about 1 year ago
=> GUI Change -> User Mandatory and User -> Document Activity List change - Remove Created By Column - Remove Action Date & Time Column - Increase Action width -> Master Activity List change - Remove Created By Column - Remove Action Date & Time Column - Increase Action width => Document Activity SQL ======================== SELECT MAX(bin_documents_id) AS bin_documents_id, MAX(fk_branch_id) AS fk_branch_id, MAX(fk_department_id) fk_department_id, MAX(vhr_document_no) AS vhr_document_no,, MAX(dat_document) AS dat_document, MAX(vhr_account_code) AS vhr_account_code, MAX(vhr_account_name) AS vhr_account_name, ARRAY_AGG ('Created' || '#' || fk_created_user_id::text || '#' || to_char(DATE dtm_created, 'DD/MM/YYYY') || '~Edited#' || fk_last_modified_user_id::text || '#' || to_char(DATE dtm_last_modified, 'DD/MM/YYYY') || '~Deleted#' || fk_deleted_user_id::text || '#' || to_char(DATE dtm_deleted, 'DD/MM/YYYY') || '~Prited#' || fk_printed_user_id::text || '#' || to_char(DATE dtm_printed, 'DD/MM/YYYY') ) arr_actions FROM ( SELECT pk_documents_id AS bin_documents_id, fk_branch_id, fk_department_id, vhr_document_no, dat_document, vhr_account_code, vhr_account_name, fk_created_user_id, dtm_created, fk_last_modified_user_id, dtm_last_modified, fk_deleted_user_id, dtm_deleted, NULL fk_printed_user_id, NULL prl.dtm_printed FROM document.tbl_documents doc LEFT JOIN accounts.tbl_account ac ON doc.fk_ledger_id = ac.pk_account_id WHERE fk_branch_id = AND fk_department_id AND (fk_created_user_id = INPUT_USER_ID OR fk_last_modified_user_id = INPUT_USER_ID OR fk_deleted_user_id = INPUT_USER_ID) AND (dtm_created BETWEEN INPUT_ACTION_FROM AND INPUT_ACTION_TO OR dtm_last_modified BETWEEN INPUT_ACTION_FROM AND INPUT_ACTION_TO OR dtm_deleted BETWEEN INPUT_ACTION_FROM AND INPUT_ACTION_TO) AND dat_document BETWEEN INPUT_DOCFROM AND INPUT_DOC_TO ... UNION ALL SELECT bin_documents_id, fk_branch_id, fk_department_id, vhr_document_no, dat_document, vhr_account_code, vhr_account_name, fk_created_user_id, dtm_created, fk_last_modified_user_id, dtm_last_modified, fk_deleted_user_id, dtm_deleted, NULL fk_printed_user_id, NULL prl.dtm_printed FROM FROM tbl_documents_log docl LEFT JOIN accounts.tbl_account ac ON docl.fk_ledger_id = ac.pk_account_id WHERE fk_branch_id = AND fk_department_id AND (fk_created_user_id = INPUT_USER_ID OR fk_last_modified_user_id = INPUT_USER_ID OR fk_deleted_user_id = INPUT_USER_ID) AND (dtm_created BETWEEN INPUT_ACTION_FROM AND INPUT_ACTION_TO OR dtm_last_modified BETWEEN INPUT_ACTION_FROM AND INPUT_ACTION_TO OR dtm_deleted BETWEEN INPUT_ACTION_FROM AND INPUT_ACTION_TO) AND dat_document BETWEEN INPUT_DOCFROM AND INPUT_DOC_TO ... UNION ALL SELECT doc.pk_documents_id AS bin_documents_id, doc.fk_branch_id, doc.fk_department_id, doc.vhr_document_no, doc.dat_document, doc.vhr_account_code, doc.vhr_account_name, NULL fk_created_user_id, NULL dtm_created, NULL fk_last_modified_user_id, NULL dtm_last_modified, NULL fk_deleted_user_id, NULL dtm_deleted, prl.fk_printed_user_id, prl.dtm_printed, FROM tbl_print_action_log prl LEFT JOIN document.tbl_documents doc ON prl.vhr_document_no doc.vhr_document_no LEFT JOIN accounts.tbl_account ac ON doc.fk_ledger_id = ac.pk_account_id WHERE fk_branch_id = AND fk_department_id AND (fk_created_user_id = INPUT_USER_ID OR fk_last_modified_user_id = INPUT_USER_ID OR fk_deleted_user_id = INPUT_USER_ID) AND (dtm_created BETWEEN INPUT_ACTION_FROM AND INPUT_ACTION_TO OR dtm_last_modified BETWEEN INPUT_ACTION_FROM AND INPUT_ACTION_TO OR dtm_deleted BETWEEN INPUT_ACTION_FROM AND INPUT_ACTION_TO) AND dat_document BETWEEN INPUT_DOCFROM AND INPUT_DOC_TO ... UNION ALL ... service.tbl_service service.tbl_service_log .. ) GROUP BY vhr_document_no ORDER BY bin_documents_id -> Action Column Value LstAction = [] loop strAction in arr_actions lst1 = strAction.split("~") loop str1 in lst1 lst2 = str1.split("#") IF lst2 [1] == INPUT_USER_ID LstAction.Add(lst2[0] + "(" + lst2[2] + ")" ) strAction = LstAction.join(', ') => Master Tab SQL ================= SELECT sin_ac_category, vhr_account_code, vhr_account_name, fk_created_user_id, dtm_created, fk_last_modified_user_id, dtm_last_modified, fk_deleted_user_id, dtm_deleted, FROM accounts.tbl_account UNION settings.tbl_settings UNION localization.tbl_language UNION localization.tbl_country UNION [All INHERITS(tbl_action_user_and_date_time) non document and support doc tables] -> Action Column Value IF fk_created_user_id == INPUT_USER_ID LstAction.Add("Created(" + dtm_created.forat(..) + ")" ) IF fk_last_modified_user_id== INPUT_USER_ID LstAction.Add("Edited(" + dtm_last_modified.forat(..) + ")" ) IF fk_deleted_user_id== INPUT_USER_ID LstAction.Add("Deleted(" + dtm_deleted.forat(..) + ")" )
Updated by Anil KV about 1 year ago
- Status changed from Open to Ready for Coding
- % Done changed from 10 to 20
Updated by Junaid M about 1 year ago
- Assignee changed from travvise Admin to Greeshma S
Updated by Greeshma S 10 months ago
- Status changed from Ready for Coding to Coding Done
- % Done changed from 20 to 60
Updated by Greeshma S 10 months ago
- Status changed from Coding Done to Coding Started
- % Done changed from 60 to 30
Updated by Greeshma S 10 months ago
- Status changed from Coding Started to Coding Done
- % Done changed from 30 to 60
Updated by Greeshma S 10 months ago
- Status changed from Reopen Bugs to Reopen Bugs Coding Done
- % Done changed from 50 to 70
Updated by Greeshma S 10 months ago
- Status changed from Reopen Bugs to Reopen Bugs Coding Done
- % Done changed from 50 to 70
Updated by Greeshma S 10 months ago
- Status changed from Reopen Bugs to Reopen Bugs Coding Done
- % Done changed from 50 to 70
Updated by Greeshma S 8 months ago
- Status changed from Reopen Bugs to Reopen Bugs Coding Done
- % Done changed from 50 to 70
Updated by Greeshma S 8 months ago
- Status changed from Reopen Bugs to Reopen Bugs Coding Done
- % Done changed from 50 to 70
Updated by Greeshma S 8 months ago
- Status changed from Reopen Bugs to Reopen Bugs Coding Done
- % Done changed from 50 to 70
Updated by Greeshma S 5 months ago
- Status changed from Reopen Bugs to Reopen Bugs Coding Done
- % Done changed from 50 to 70
Updated by Greeshma S 11 days ago
- Status changed from Reopen Bugs to Reopen Bugs Coding Done
- % Done changed from 50 to 70
Updated by Theja Ponon 4 days ago
- Status changed from Reopen Bugs Coding Done to Reopen Bugs
- % Done changed from 70 to 50
Issue Found
----------
1)In master tab seperate entry for received and paid cheque when any doc with this master used as fop
Updated by Greeshma S 4 days ago
- Status changed from Reopen Bugs to Reopen Bugs Coding Done
- % Done changed from 50 to 70
Updated by Theja Ponon about 6 hours ago
- Status changed from Reopen Bugs Coding Done to Reopen Bugs
- % Done changed from 70 to 50
Issue Found
--------
1)On redirection by clicking the doc number ,data is not loading in respective module
Updated by Greeshma S about 5 hours ago
- Status changed from Reopen Bugs to Reopen Bugs Coding Done
- % Done changed from 50 to 70