Commit Graph

183 Commits

Author SHA1 Message Date
hengsin 6302f6f5fd IDEMPIERE-6029 Extract @SQL= and @SQLFIND= to constant (#2230) 2024-03-04 21:17:30 +01:00
Carlos Ruiz 48a3e73798
IDEMPIERE-5967 Release 11 Synergy (#2155)
* IDEMPIERE-5967 Release 11 Synergy

* - Script to set version

* - generate model
2023-12-22 15:33:57 +01:00
Zuhri Utama ee212b7d37
IDEMPIERE-5911 : [IDempiere Monitor] Open Log File on New Tab (#2089) 2023-11-05 12:44:26 +08:00
hengsin 6840b8aeb6
IDEMPIERE-5346 : Adding SSO support (#2018)
- peer review
2023-09-21 16:48:30 +08:00
Deepak Pansheriya 680f9f3757
IDEMPIERE-5346 : Adding SSO support (#1571)
* IDEMPIERE-5346 : Adding SSO support

* IDEMPIERE-5346 : Fix as per peer review feedback.
Valid user should have password not null
removing #SSO_IS_ALREADY_AUTHENTICATE context variable due to security risk
Cross site scripting issue on error.htm
Making show role panel as system configurable
Adding language selection on role panel
Adding SSO support on iDempiere monitor and osgi console

* IDEMPIERE-5346: Redirect to console using static URL to avoid security vulenarabilit

* Committing patch from Carlos pr1571PR

* IDEMPIERE-5565: fixing NPE issue on Role change

* IDEMPIERE-5346: Appling pr1571PR2 from Carlos

* 1. IDEMPIERE-5346: Fix idempiereMonitor goes in a loop of sign-in
- Fix NPE when changing role
- Fix NPE when a user with single role & sysconfig: SSO_SELECT_ROLE is 'N'

* IDEMPIERE-5346 : IDempiere Monitor, use out of box login when SSO is not configured.

* IDEMPIERE-5346: Adding Authorization type on User and Tenant window. Created /webui/admin page for login with application credential.

* IDEMPIERE-5346: Implementing Hengsi's Code review comments
Showing meaning full error when Identity Provider returns error
In SSO filter, ignoreing css, zkau, images and resource URL
Correcting typo in Principal name.
Updated Documentation

* IDEMPIERE-5346 : Fixed documentation, typo and pending review comments

* IDEMPIERE-5346: Use token & SSO principal service to validate in Login.GetClient

* IDEMPIERE-5346: Remove the Domain URL column and refactor the code.

* IDEMPIERE-5346: Adding flag ENABLE_SSO_IDEMPIERE_MONITOR and ENABLE_SSO_OSGI_CONSOLE, using cache for SSOService, defaulting Authentication type on client to “Application and SSO”

* IDEMPIERE-5346: Fixed issue of User SSO type not respected and support for Zoom URL
2023-09-21 16:43:49 +08:00
Carlos Ruiz 7c8fe24435
IDEMPIERE-5567 Support of UUID as Key (FHCA-4195) - AD_PInstance (#2003)
- Implement support to run processes on UUID based tables
- Added SvrProcess.getRecord_UU and getRecord_UUs support
- Added TestUUChangeActive process as toolbar button on "Test UU Based Table" window - supports single and multi
- Added AD_PInstance.AD_Table_ID and AD_PInstance.Record_UU
- NOTE: the migration script tries the best to fill AD_PInstance.AD_Table_ID from different sources, but at the end is very possible that some records will be left with empty table
- The MPInstance constructors that don't manage AD_Table_ID were marked as deprecated to ease discovering the missing parts in plugins
2023-09-13 10:59:21 +08:00
Carlos Ruiz c1d8a50b12
IDEMPIERE-5837 Collect all System Properties of iDempiere in one class (#1980) 2023-08-26 09:39:53 +08:00
hengsin 9c7713fa8d
IDEMPIERE-5448 2023 June Platform Update (#1531)
* IDEMPIERE-5448 Can't launch unit test with Eclipse 2022-09

- upgrade to tycho 3.1.0-SNAPSHOT
- set maven compiler source and target level to 11
- upgrade to junit 5.9.1

* IDEMPIERE-5448 Can't launch unit test with Eclipse 2022-09

- Change tycho version to 3.0.3

* IDEMPIERE-5448 2023 June Platform Update

* IDEMPIERE-5448 2023 June Platform Update

- Explicitly set target, source and release level to JavaSE 11

* IDEMPIERE-5448 2023 June Platform Update

- Use 3.0.5-SNAPSHOT to fix stack overflow error.

* IDEMPIERE-5448 2023 June Platform Update

- Change source, target and release level to JDK 17
- Update target platform name to idempiere-230620

* IDEMPIERE-5448 2023 June Platform Update

- Fix LogFactory ClassNotFound exception with Eclipse 2023-06
2023-06-21 13:44:18 +02:00
hengsin acab52e9a9
IDEMPIERE-5763 Improve reliability of stopping a scheduler (#1885) 2023-06-07 21:28:32 +02:00
Carlos Ruiz 013ba190fd
IDEMPIERE-5567 Support of UUID as Key (FHCA-4195) - Toolbar (#1865)
* IDEMPIERE-5567 Support of UUID as Key (FHCA-4195) - Toolbar

- add support for AD_Attachment, CM_Chat, AD_PostIt and AD_LabelAssignment for UUID based tables

* - Better deprecated message
- Better deprecated management for constructors

* - Fix non unique exception on ad_changelog
- Fix to save changelog just ID on insert and not the UUID for ID based tables
2023-05-31 10:39:10 +08:00
hengsin eb78bd4ee9
IDEMPIERE-5678 Unit Test is failing with PostgreSQL 15 (#1789) 2023-04-19 13:57:34 +02:00
Carlos Ruiz 9e18bc725e
IDEMPIERE-5174 Disable System User - Set new System (#1769) 2023-04-04 11:36:30 +08:00
hengsin 1daa1c70e2
IDEMPIERE-5572 Scheduler: Allow process to suppress auto sending of process execution result to scheduler recipients (#1668) 2023-02-10 14:13:40 +01:00
matheus-marcelinux 9f71eeadbc
IDEMPIERE-5458 - Timezone defined by Organization (#1568)
* # IDEMPIERE-5458 - Timezone defined by Organization

* # IDEMPIERE-5468 - improved unit test

* # IDEMPIERE-5458 - removing user/password from scriptg

* IDEMPIERE-5458 - fix migration script

* IDEMPIERE-5458 - adding field in org info tab
2023-02-01 11:43:06 +08:00
Carlos Ruiz dd7b63aa0d
IDEMPIERE-5523 Release 10 Peace (#1624)
- move master to release-11 development build
2022-12-24 00:20:49 +01:00
Carlos Ruiz 1d9d504801
IDEMPIERE-5523 Release 10 Peace (#1619)
* IDEMPIERE-5523 Release 10 Peace

* - generate model classes

* - Add release image contributed by Vanessa Castro
2022-12-23 14:27:27 +01:00
Elaine Tan 2ff6378720
IDEMPIERE-5472 Unclosed resources (#1565)
* IDEMPIERE-5472 Unclosed resources

* IDEMPIERE-5472 Unclosed resources
2022-11-17 17:35:15 +08:00
Carlos Ruiz 5bd3af0d2f
IDEMPIERE-236 Centralization of hardcoded IDs (#1429)
* IDEMPIERE-236 Centralization of hardcoded IDs

* IDEMPIERE-236 Centralization of hardcoded IDs
2022-08-09 22:12:54 +08:00
Carlos Ruiz 486ae19cdc
IDEMPIERE-5355 Improve default trx name (FHCA-3765) (#1407)
* IDEMPIERE-5355 Improve default trx name (FHCA-3765)

* IDEMPIERE-5355 Improve default trx name (FHCA-3765)

Implement suggestions from Heng Sin
Added SysConfig TRX_AUTOSET_DISPLAY_NAME (default false)

* Delete test/debugging code committed by mistake

* IDEMPIERE-5355 fix method wrongly named
2022-07-26 14:08:32 +08:00
hengsin 73aecb1145
IDEMPIERE-5347 Minor scheduler improvement (#1393) 2022-07-13 23:09:54 +02:00
hengsin f5a0a0a2f6
IDEMPIERE-5093 Scheduler cron pattern scheduling is always using server time zone (#1348)
- Fix unit test.
- Fix server monitor error out if AD_ClientInfo.TimeZone has invalid
value.
2022-05-28 10:54:16 +02:00
PeterTakacs300 b2b31fb087
IDEMPIERE-3294 - check empty String parameter (#1336)
* IDEMPIERE-3294 - check empty String parameter
2022-05-25 14:48:37 +08:00
hengsin 13b37c4acc
IDEMPIERE-5093 Scheduler cron pattern scheduling is always using serv… (#1270)
* IDEMPIERE-5093 Scheduler cron pattern scheduling is always using server time zone

* minor fix for oracle/202203240830_IDEMPIERE-5093.sql

* IDEMPIERE-5093 cheduler cron pattern scheduling is always using server time zone

- add time zone comment for cronpattern field
- use fix format for elapsed time (day'hour:minutes:seconds.millisecond)
- use time zone formatting at server monitor
- include etc/gmt* timezone id. fix handling of invalid user input
- fix wrong editor (date) use for timestamp with time zone field

* IDEMPIERE-5093 cheduler cron pattern scheduling is always using server time zone

- Fix MSchedule.getNextRunMS call.

* IDEMPIERE-5093 Scheduler cron pattern scheduling is always using server time zone

- add T_Timestamp to Test table and window.
- fix date time editor doesn't capture seconds for timestamp with time
zone.
- date time editor: use tenant time zone (if set), fallback to browser
time zone.
- date time editor: fix processing of timestamp with time zone value.
- time zone editor: drop the confusing etc/gmt* entries and support
entry of GMT(+/-)hh:mm custom zone id.

* IDEMPIERE-5093 Scheduler cron pattern scheduling is always using server time zone

Fix NPE

Co-authored-by: Carlos Ruiz <carg67@gmail.com>
2022-04-22 21:28:51 +02:00
igorpojzl 8d5f7768e4
IDEMPIERE-5256 Add Cache to MSession Refactor (#1283) 2022-04-20 19:00:13 +08:00
igorpojzl ef929dfae5
IDEMPIERE-5256 Add Cache to MSession (#1282) 2022-04-07 09:33:41 +08:00
Nicolas Micoud 10fca86adf
IDEMPIERE-4771 - fix typo in message (#1269) 2022-03-29 05:20:49 +08:00
Carlos Ruiz 1a51e92c42
IDEMPIERE-4586 Update translation of Client to Tenant (#1233)
* IDEMPIERE-4586 Update translation of Client to Tenant

* Exclude AD_Ref_List.Name from the update as it impacts too many constants generated in X_ classes

* * update the Updated column too so that it is easier to trace back which records have been updated (as suggested by Heng Sin)

* * Update some additional messages that becomes duplicated (as reported by Nicolas)

* * Add updates to AD_Tab.CommitWarning (as reported by Nicolas)
2022-03-12 16:59:32 +01:00
Carlos Ruiz e1253b153c
IDEMPIERE-5109 Release 9 Horizon (#1091) 2021-12-24 16:41:17 +01:00
Carlos Ruiz adba43ced0
IDEMPIERE-5109 Release 9 Horizon (#1088)
* IDEMPIERE-5109 Release 9 Horizon

- Fill UUID in missing AD_TreeNodeMM_UU

* - IDEMPIERE-1052 - set as Search for High Volume tables

* - Fix supported versions in SECURITY.md

* - Script to set the Version number

* - Set credits and image

* - script to clean trailing space from elements

* - Set entity type EXT for Web Service tables

* - IDEMPIERE-4214 Javadoc: correct warnings on newest java version

* - Improvements to model generator classes

* - Model classes

* - Folders script maintenance new version
2021-12-24 18:05:32 +08:00
Carlos Ruiz 9ae4a2636e
IDEMPIERE-4214 Javadoc: correct warnings on newest java version (#1082)
* iIDEMPIERE-4214 Javadoc: correct warnings on newest java version / fix problem to generate javadoc again

* IDEMPIERE-4214 Javadoc: correct warnings on newest java version / Fix javadoc warnings
2021-12-23 11:44:23 +01:00
Carlos Ruiz a12ba93869
IDEMPIERE-4186 allow workflow to be suspended until after commit of actual transaction (#1034)
* IDEMPIERE-4186 allow workflow to be suspended until after commit of actual  transaction / fix Split Join = AND

* Add unit test for Split AND

* Fix test case - commit and cleanup the changes to workflow
2021-12-14 10:53:43 +08:00
hengsin ceb056e6d8
IDEMPIERE-5048 Minor fix for Scheduler and SvrProcess: set m_trx to null (#989) 2021-11-19 16:12:39 +01:00
hengsin 29f5186d41
IDEMPIERE-5047 iDempiere Server Monitor Improvements (#988) 2021-11-19 16:04:54 +01:00
hengsin 834f3a012f
IDEMPIERE-4981 Make it easier to find Process Audit record for each Scheduler Run (#900) 2021-09-27 22:12:17 +08:00
uthadehikaru b15ddeaea0
IDEMPIERE-4977 IDempiere Homepage using custom image path failed to load the image (#896) 2021-09-24 11:18:49 +08:00
hengsin ae5a665dd8
IDEMPIERE-4933 Platform update for 9.x (#857)
* IDEMPIERE-4933 Platform update for 9.x

- WIP

* IDEMPIERE-4933 Platform update for 9.x

- project to repackaged some osgi bundles from maven

* IDEMPIERE-4933 Platform update for 9.x

- Fix target platform error

* IDEMPIERE-4933 Platform update for 9.x

* IDEMPIERE-4933 Platform update for 9.x

- minor eclipse setting fix
2021-09-04 16:12:10 +02:00
Carlos Ruiz 68a5dc1456
IDEMPIERE-4918 Cannot use simple auth after used OAuth (FHCA-2014) (#842) 2021-08-18 14:51:44 +02:00
hengsin beaaf31d9a
IDEMPIERE-4771 add Cloud Upload interface to report viewer and scheduler (#679)
* IDEMPIERE-4771 add Cloud Upload interface to report viewer and scheduler

* IDEMPIERE-4771 add Cloud Upload interface to report viewer and scheduler

Fix initial output type selection for csv. Fix handling of binary vs
text media type.

* IDEMPIERE-4771 add Cloud Upload interface to report viewer and scheduler

- Change AD_AuthorizationAccount scope from single value to multiple
selection list (AD_AuthorizationScopes replace AD_AuthorizationScope)

* IDEMPIERE-4771 add Cloud Upload interface to report viewer and scheduler

Fix isIntersectCSV db function

* IDEMPIERE-4771 add Cloud Upload interface to report viewer and scheduler

add back AD_AuthorizationScope Configured dynamic validation filter
2021-05-12 13:42:55 +02:00
Ricardo Santana a22b36b744
IDEMPIERE-4776 - iDempiere Monitor: Sort logs and Schedulers (#671)
* IDEMPIERE-4776 - iDempiere Monitor: Sort logs and Schedulers

* IDEMPIERE-4776 - iDempiere Monitor: Sort logs and Schedulers
* get logs already sorted from LogFileInfo

Co-authored-by: Carlos Ruiz <carg67@gmail.com>
2021-04-29 15:31:11 +02:00
Carlos Ruiz 8f31506ac7
IDEMPIERE-4764 Hazelcast distributed cache can be an issue in some environments (#655)
* IDEMPIERE-4764 Hazelcast distributed cache can be an issue in some environments

- Change setting for all caches to be non-distributed

* IDEMPIERE-4764 Hazelcast distributed cache can be an issue in some environments

* TC-324 Fix cache related monitoring and performance issues

- PO & GridTable call to CacheMgt reset should be async.

Co-authored-by: hengsin <hengsin@gmail.com>
2021-04-19 20:41:34 +08:00
Carlos Ruiz c03fefea79
IDEMPIERE-3101 implement OAuth2 for mail (gmail, outlook and other mail system) (#613)
* Avoid NPE when calling the servlet without parameters
2021-03-06 16:22:31 +01:00
Carlos Ruiz 5f2d71347d
IDEMPIERE-3101 implement OAuth2 for mail (gmail, outlook and other mail system) (#593)
* IDEMPIERE-3101 implement OAuth2 for mail (gmail, outlook and other mail system)

WIP - initial version working on zk with google apps mail using OAuth2 Authorization Code Flow and Client Type = web application

* Enable imap reading with OAuth2 in RequestEMailProcessor
* Simplify the code - tested plain and OAuth2 can use the same methods
* Add +SCOPE parameter to AddAuthorizationForm according to IDEMPIERE-4713
* Rename the form AddAuthorizationMailForm to AddAuthorizationForm as is now more generic

* IDEMPIERE-4713
* Rename migration scripts to make it newer than IDEMPIERE-4713
* Add list of scopes attended by a credential
* Change form to accept other scopes, if no scope parameter is passed, then a list is shown, change the menu to fix the EMail scope
* Add MAuthorizationAccount.refreshAndGetAccessToken
* Add translation for messages

* make call generic oauth, avoid using specific google API

* Tests with microsoft as OAuth2 provider
* Add record for microsoft as provider
* Increase size of tokens
* Define mandatory and secure columns
* Update refresh token when it comes on the refresh call
* Revoke endpoint is optional

* Change the approach to a process instead of a form (WIP)
* Implement servlet to process the OAuth2 code

* Solve context suggestion from hengsin

* Implement the form in an automatic popup approach for running on zkwebui

* i18n - add translations for all messages that are shown to user
* on the form opted for click to avoid the problem with browsers forbidding popups
* clean spaces and tabs on line endings

* avoid logging and copy of the secure columns

* Fix problem reported by @d-ruiz about hidden NPE when SMTP Authentication is disabled

* Add writing to AD_PInstance_Para and AD_PInstance_Log the results of processing the servlet
* Control to avoid using the same authorization URL twice
2021-03-06 11:49:39 +01:00
hengsin d96199a2b6
IDEMPIERE-4251 Constant definition for all Env Context (#519)
* IDEMPIERE-4251 Constant definition for all Env Context

replace "#Date" with Env.DATE

* IDEMPIERE-4251 Constant definition for all Env Context

replace "#.." with constant at Env

* IDEMPIERE-4251 Constant definition for all Env Context

Merge patch from Carlos
2021-01-12 21:29:50 +08:00
igorpojzl 829c323170
IDEMPIERE-4636 Cross Tenant issue Request processor (#516)
* IDEMPIERE-4636  Cross Tenant issue Request processor

* IDEMPIERE-4636  Cross Tenant issue Request processor
2021-01-08 17:06:52 +01:00
hengsin 45cfbe6804
IDEMPIERE-4610 Remove obsolete LdapProcessor (#484)
* IDEMPIERE-4610 Remove obsolete LdapProcessor

* IDEMPIERE-4610 Remove obsolete LdapProcessor

Inactivate menu entry (AD_Menu_ID=594) and window (AD_Window_ID=389)

* IDEMPIERE-4610 Remove obsolete LdapProcessor

move migration script to i8.2z folder.
2020-12-28 11:09:17 +01:00
Carlos Ruiz 0485339377
IDEMPIERE-4604 Release 8.2 Phong (#480)
Changes to differentiate test servers 8.2 from 8.2z
2020-12-21 22:12:01 +01:00
Carlos Ruiz 00a08236fc IDEMPIERE-4604 Release 8.2
Credits and version number
2020-12-20 09:25:13 +01:00
Carlos Ruiz 60007e07e6
IDEMPIERE-4521 Release 8.1 (#462)
Change IRC to mattermost
2020-12-13 17:00:04 +08:00
hengsin e017046dac
IDEMPIERE-4590 Scheduler Window: Start Scheduler action change AD_Client_ID to 0 when HazelCast Service is Down/Disable (#449) 2020-12-10 11:54:39 +01:00
Carlos Ruiz 73855a1578 IDEMPIERE-4521 Release 8.1 - RC
Change references in files
2020-11-03 21:59:12 +01:00