26 Commits

Author SHA1 Message Date
jamie.priest
283dcd1e6f updated Watir install scripts to work with the latest version of Watir (1.6.2)
git-svn-id: http://locode01.ad.dom/svn/WEBMIP/trunk@12272 248e525c-4dfb-0310-94bc-949c084e9493
2009-08-18 17:12:31 +00:00
PriestJ
579882102f removed code to import supporting object definitions as we don't have any and the install was breaking
git-svn-id: http://locode01.ad.dom/svn/WEBMIP/trunk@4028 248e525c-4dfb-0310-94bc-949c084e9493
2008-03-17 14:42:51 +00:00
PriestJ
30c3f98e35 added role (CS)for expired user so he can change his password, as the security model insists on the users having a role.
git-svn-id: http://locode01.ad.dom/svn/WEBMIP/trunk@4025 248e525c-4dfb-0310-94bc-949c084e9493
2008-03-17 14:30:22 +00:00
PriestJ
63a5951bd1 for ticket #354, set the apau.ctl control file to accurately reflect the page security model. Removed the file from the different builds and updated the seed version of the file. Now we'll have one consistent file for all builds.
git-svn-id: http://locode01.ad.dom/svn/WEBMIP/trunk@3942 248e525c-4dfb-0310-94bc-949c084e9493
2008-03-11 12:13:16 +00:00
PriestJ
87260a3f50 added access for MIPADMIN for pages 80-82
git-svn-id: http://locode01.ad.dom/svn/WEBMIP/trunk@3934 248e525c-4dfb-0310-94bc-949c084e9493
2008-03-10 18:36:55 +00:00
PriestJ
b159a639ff added SUPPADMIN rights to the apex_authorization table loaders
git-svn-id: http://locode01.ad.dom/svn/WEBMIP/trunk@3933 248e525c-4dfb-0310-94bc-949c084e9493
2008-03-10 18:31:03 +00:00
PriestJ
c350428b1c updated data inline with ticket #321, had made the change in the front end code but not committed the backend data that complemented it, this ashould change for all builds
git-svn-id: http://locode01.ad.dom/svn/WEBMIP/trunk@3919 248e525c-4dfb-0310-94bc-949c084e9493
2008-03-10 16:41:35 +00:00
hardya
aab27144a0 Remove timestamp from output of mip_friendly_messages.pck
Add constraint to regi_enqu_exclusions to prevent both enquiry and additional items being recorded on the same row.

Allow schema to be passed to apex_auto_install.rb.

git-svn-id: http://locode01.ad.dom/svn/WEBMIP/trunk@3666 248e525c-4dfb-0310-94bc-949c084e9493
2008-02-21 17:56:52 +00:00
hardya
3fdf82de7f Altered prty.ctl so that manu_ref matches organization name - this prevents duplication during bulk_load.
git-svn-id: http://locode01.ad.dom/svn/WEBMIP/trunk@3630 248e525c-4dfb-0310-94bc-949c084e9493
2008-02-19 11:51:11 +00:00
PriestJ
7504e1196b Updated so that the authorization for MH's user screens for admin and suppadmin work
git-svn-id: http://locode01.ad.dom/svn/WEBMIP/trunk@3524 248e525c-4dfb-0310-94bc-949c084e9493
2008-02-12 16:31:03 +00:00
PriestJ
df85a185a8 fixed incorrect key values for party 404 as a party role
git-svn-id: http://locode01.ad.dom/svn/WEBMIP/trunk@3467 248e525c-4dfb-0310-94bc-949c084e9493
2008-02-05 12:37:22 +00:00
PriestJ
6262527571 error on row 11 was preventing data from uploading correctly
git-svn-id: http://locode01.ad.dom/svn/WEBMIP/trunk@3466 248e525c-4dfb-0310-94bc-949c084e9493
2008-02-05 12:14:08 +00:00
PriestJ
5965febd68 tidied up party relationship as we were giving agents two roles agent and supplieradmin
git-svn-id: http://locode01.ad.dom/svn/WEBMIP/trunk@3460 248e525c-4dfb-0310-94bc-949c084e9493
2008-02-04 17:50:15 +00:00
PriestJ
8c92041a07 tidied up data so that we don't have more than one role per user, also added some roles to cs and icu users for test purposes
git-svn-id: http://locode01.ad.dom/svn/WEBMIP/trunk@3453 248e525c-4dfb-0310-94bc-949c084e9493
2008-02-04 11:07:15 +00:00
hardya
6c4617b1c3 Bulk Load: Latest version of POSTCODES.csv.
Data/Seed and Data/Test: Correction to apau.ctl to remove duplicates.

Modules/compile.sql: Correction to 'report' query.

Schema/ext...: Check whether external tables have been defined before attempting to drop them.

Schema/v_...: Force creation of views that rely on PL/SQL code. Explicitly name the column returned by V_QUOTE_DETAILS.vw so that the comments can be applied.



git-svn-id: http://locode01.ad.dom/svn/WEBMIP/trunk@3452 248e525c-4dfb-0310-94bc-949c084e9493
2008-02-04 10:49:50 +00:00
PriestJ
9dbb78b302 more access control descriptions added, added supplier admin roles, relationships and users
git-svn-id: http://locode01.ad.dom/svn/WEBMIP/trunk@3449 248e525c-4dfb-0310-94bc-949c084e9493
2008-02-03 18:10:37 +00:00
PriestJ
5c4dcdaeca turned off code to delete previous imports as it was not clicking the okay to delete dialog box, the code will run on my machine if it is run from a dos prompt
git-svn-id: http://locode01.ad.dom/svn/WEBMIP/trunk@3287 248e525c-4dfb-0310-94bc-949c084e9493
2008-01-17 14:26:41 +00:00
PriestJ
ba55144f24 added code to click the ok button when you try to delete the previous installs
git-svn-id: http://locode01.ad.dom/svn/WEBMIP/trunk@3285 248e525c-4dfb-0310-94bc-949c084e9493
2008-01-17 13:26:09 +00:00
PriestJ
09eb862dc4 added code to delete previous installs, it actually just deletes all the installs on the first page, but this should be enough.
git-svn-id: http://locode01.ad.dom/svn/WEBMIP/trunk@3283 248e525c-4dfb-0310-94bc-949c084e9493
2008-01-17 11:44:59 +00:00
mullenm
b94659f48b added new users for the login testing.
git-svn-id: http://locode01.ad.dom/svn/WEBMIP/trunk@3009 248e525c-4dfb-0310-94bc-949c084e9493
2007-12-17 11:34:26 +00:00
PriestJ
f2ffbfa4b4 need to have an entry for agents as they need to see page 32 for my tests.
git-svn-id: http://locode01.ad.dom/svn/WEBMIP/trunk@2943 248e525c-4dfb-0310-94bc-949c084e9493
2007-12-05 16:34:53 +00:00
PriestJ
b68f2ebcb1 Saved in the new menu code, also changed the autoinstall for the test environment so that it will dynamically call the sql export scripts for apex rather than using a hardcoded string.
git-svn-id: http://locode01.ad.dom/svn/WEBMIP/trunk@2935 248e525c-4dfb-0310-94bc-949c084e9493
2007-12-03 17:10:49 +00:00
PriestJ
a35df4b603 Altered test install scripts so that the script now runs a watir script that installs the webmip test application onto apex. At this point in time it only installs the application export file (the CSS,theme and pictures have to be installed manually). This means we can now automatically install a test instance of webmip.
git-svn-id: http://locode01.ad.dom/svn/WEBMIP/trunk@2934 248e525c-4dfb-0310-94bc-949c084e9493
2007-12-03 16:15:37 +00:00
PriestJ
69c2ead1ee fixed bug in Installmip.cmd, test section would never get run and the usage section caused an error.
Massaged the test data so that some base users get added to the test schema, duplicated the seed party data upload so that the Advantica user still exists

git-svn-id: http://locode01.ad.dom/svn/WEBMIP/trunk@2897 248e525c-4dfb-0310-94bc-949c084e9493
2007-11-28 13:17:46 +00:00
hardya
7877296419 Changed InstallMIP.cmd to allow 6th parameter to indicate data to be loaded after the Seed.
Added missing schema tables.

git-svn-id: http://locode01.ad.dom/svn/WEBMIP/trunk@2893 248e525c-4dfb-0310-94bc-949c084e9493
2007-11-27 16:23:36 +00:00
hardya
2920f4d016 Scheme Changes:
Replaced Access_Controls with APEX_AUTHORISATION
Created POSTCODES, ERROR_LOGS and SYSTEM_CONFIGURATION.
Added missing columns to ENQUIRIES, REGULATORS, etc.
Added views V_PROFILE_RT_CODE_FOR_ENRO.vw, V_PARTY_RELATIONSHIPS.vw, V_LATEST_RT_CODE_FOR_ENRO.vw.

Modules:

Added cout_err.pck, cout_system_configuration.pck.

Data:

Added Data/Demo files
Added Data/Seed files for postcodes, regions and DatabaseItemToFunctionalSpecificationReference.csv

Documentation:

Added Documentation/pldoc for plsqldoc-generated files.
Added Documentation/SupportingDocumentation/Regions to hold region definition information.

git-svn-id: http://locode01.ad.dom/svn/WEBMIP/trunk@2890 248e525c-4dfb-0310-94bc-949c084e9493
2007-11-27 11:48:13 +00:00