andy/mip
1
0
Fork 0
Code Issues Pull Requests Releases Wiki Activity
849 Commits 1 Branch 0 Tags
master
Commit Graph

156 Commits

Author SHA1 Message Date
hardya
2b3d0c909c Added support for 'friendly' database constraint messages. 
Changed SUPP role type description following training session.

git-svn-id: http://locode01.ad.dom/svn/WEBMIP/trunk@3628 248e525c-4dfb-0310-94bc-949c084e9493
 2008-02-19 11:30:44 +00:00
hardya
9a50fc6938 Altered meter size codes (Seed/MESC.ctl) to replace '"' with 'inch'. See #190. 
git-svn-id: http://locode01.ad.dom/svn/WEBMIP/trunk@3611 248e525c-4dfb-0310-94bc-949c084e9493
 2008-02-18 09:33:56 +00:00
hardya
cd398f258c Changes made following test of the training environment. 
git-svn-id: http://locode01.ad.dom/svn/WEBMIP/trunk@3608 248e525c-4dfb-0310-94bc-949c084e9493
 2008-02-15 20:34:04 +00:00
hardya
dfd3210818 Bulk Load: Changes to default values for 'unknown' items, inclusion of LeadTimes.csv 
MIP_QUOTATION: Changes to make use of LeadTimes.csv

git-svn-id: http://locode01.ad.dom/svn/WEBMIP/trunk@3605 248e525c-4dfb-0310-94bc-949c084e9493
 2008-02-15 18:01:40 +00:00
PriestJ
a02ecbf704 added scripts for uat will only install one user (advantica) 
git-svn-id: http://locode01.ad.dom/svn/WEBMIP/trunk@3529 248e525c-4dfb-0310-94bc-949c084e9493
 2008-02-12 17:13:49 +00:00
hardya
3dcee7fb94 Latest version of BULK_LOAD.xls exported as CSV files, changes to syco.ctl file. 
Modified mip_bulk_load.pck to convert '"' to 'inch' in meter size codes imported from LABOUR_COSTS.csv.

git-svn-id: http://locode01.ad.dom/svn/WEBMIP/trunk@3527 248e525c-4dfb-0310-94bc-949c084e9493
 2008-02-12 16:52:40 +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
bf678428c8 updated caveat text on BULK_LOAD.xls to include updated supply caveat. Updated CAVEATS.csv to the current caveat text. 
git-svn-id: http://locode01.ad.dom/svn/WEBMIP/trunk@3517 248e525c-4dfb-0310-94bc-949c084e9493
 2008-02-12 11:34:36 +00:00
hardya
68f300c2ca Fixes made for #102, #103, #49, #108 
git-svn-id: http://locode01.ad.dom/svn/WEBMIP/trunk@3504 248e525c-4dfb-0310-94bc-949c084e9493
 2008-02-08 16:23:12 +00:00
PriestJ
36a6f94c3a altered the order the service pressures are recorded in the database, so that they are in a nice order on the enquiry screen 
git-svn-id: http://locode01.ad.dom/svn/WEBMIP/trunk@3500 248e525c-4dfb-0310-94bc-949c084e9493
 2008-02-08 14:40:13 +00:00
hardya
224e841305 Add module Qmax to bulk load process and quotation generation. 
Add tripartite_agreement_message to mip_quotation.pck (supported by mip_tripartite.pck). Produces a message when enquiry does not meet tripartite requirements.

Removed extraneous role types for Seed/prtp.ctl and Seed/rt.ctl.

git-svn-id: http://locode01.ad.dom/svn/WEBMIP/trunk@3497 248e525c-4dfb-0310-94bc-949c084e9493
 2008-02-08 12:25:46 +00:00
hardya
ee3dcd0ad9 Alter bulk_load routines to match discussions with Gareth regarding costs. 
Added 'quotation_text' and 'contact_text' to regions, to be used during quote document generation.

git-svn-id: http://locode01.ad.dom/svn/WEBMIP/trunk@3494 248e525c-4dfb-0310-94bc-949c084e9493
 2008-02-07 17:52:22 +00:00
hardya
12f2693a5c Changes to schema and code to place 'id' as PK field in quote_events and enquiry_events as part of ticket #78. 
Changed BULK_LOAD.xls to have two tabs to represent costs. Also includes QMAX against module - none of these changes are represented in the current code.

git-svn-id: http://locode01.ad.dom/svn/WEBMIP/trunk@3480 248e525c-4dfb-0310-94bc-949c084e9493
 2008-02-06 17:28:44 +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
hardya
e4547a542b Add support for system calls (ticket #77). 
git-svn-id: http://locode01.ad.dom/svn/WEBMIP/trunk@3465 248e525c-4dfb-0310-94bc-949c084e9493
 2008-02-05 10:28:17 +00:00
hardya
bfbd602cbe Data/BulkLoad/BULK_LOAD.xls : include full list of postcodes. 
git-svn-id: http://locode01.ad.dom/svn/WEBMIP/trunk@3461 248e525c-4dfb-0310-94bc-949c084e9493
 2008-02-04 18:17: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
f9672916f0 ah made changes to build scripts to fix a few errors 
git-svn-id: http://locode01.ad.dom/svn/WEBMIP/trunk@3416 248e525c-4dfb-0310-94bc-949c084e9493
 2008-01-29 13:11:12 +00:00
PriestJ
34575be877 added fat build scripts for the FAT environment, it works!, I had to create a workspace to create the application in. Also had to manually copy the images and css to the application. 
git-svn-id: http://locode01.ad.dom/svn/WEBMIP/trunk@3406 248e525c-4dfb-0310-94bc-949c084e9493
 2008-01-28 18:33:23 +00:00
hardya
64339b874a Record the party selecting a quote. 
git-svn-id: http://locode01.ad.dom/svn/WEBMIP/trunk@3384 248e525c-4dfb-0310-94bc-949c084e9493
 2008-01-24 14:14:07 +00:00
hardya
7311d92835 Seed/enst.ctl - add INVALID status 
Documentation/Design/DatabaseItemToFunctionalSpecificationReference.xls - add rule O-M5
Documentation/pldoc - regenerated
Modules/mip_helper_special_cases.pck - make reference to Tripartite rule O-M5 (handled by mip_quotation.pck and mip_tripartite.pck
Schema - removed DATA_ITEM_ROLES_IMPORT, added views of enquiries and quote statuses

git-svn-id: http://locode01.ad.dom/svn/WEBMIP/trunk@3354 248e525c-4dfb-0310-94bc-949c084e9493
 2008-01-22 17:59:56 +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
hardya
13c9c0ca97 Changes made to support Bulk Load. 
git-svn-id: http://locode01.ad.dom/svn/WEBMIP/trunk@3255 248e525c-4dfb-0310-94bc-949c084e9493
 2008-01-15 18:45:58 +00:00
hardya
f29afedb1e Updated BULK_LOAD.xls to include bases, housings and costs. 
git-svn-id: http://locode01.ad.dom/svn/WEBMIP/trunk@3207 248e525c-4dfb-0310-94bc-949c084e9493
 2008-01-11 17:27:51 +00:00
hardya
268153a8eb Produced cleaner versions of the images: MIP5>PowerPoint>Impress and save as JPG 
git-svn-id: http://locode01.ad.dom/svn/WEBMIP/trunk@3205 248e525c-4dfb-0310-94bc-949c084e9493
 2008-01-11 15:59:40 +00:00
hardya
0a7e1feed1 Converted colours to 16.7million to allow PLPDF to manipulate correctly. 
git-svn-id: http://locode01.ad.dom/svn/WEBMIP/trunk@3201 248e525c-4dfb-0310-94bc-949c084e9493
 2008-01-11 12:13:25 +00:00
hardya
8e64181a1b Attempting to tidy up the drawings to allow plpdf to display them... doesn't seem to have helped. 
git-svn-id: http://locode01.ad.dom/svn/WEBMIP/trunk@3197 248e525c-4dfb-0310-94bc-949c084e9493
 2008-01-10 17:49:58 +00:00
PriestJ
9b806bb480 added rough housing jpegs 
git-svn-id: http://locode01.ad.dom/svn/WEBMIP/trunk@3188 248e525c-4dfb-0310-94bc-949c084e9493
 2008-01-10 14:00:04 +00:00
hardya
947a7c6dd4 Delete the moved files. 
git-svn-id: http://locode01.ad.dom/svn/WEBMIP/trunk@3187 248e525c-4dfb-0310-94bc-949c084e9493
 2008-01-10 13:53:21 +00:00
hardya
34803b1174 Move module drawings to their own directory 
git-svn-id: http://locode01.ad.dom/svn/WEBMIP/trunk@3186 248e525c-4dfb-0310-94bc-949c084e9493
 2008-01-10 13:43:14 +00:00
PriestJ
a4ba9f6b03 added base drawings in bas_dwg dir 
git-svn-id: http://locode01.ad.dom/svn/WEBMIP/trunk@3185 248e525c-4dfb-0310-94bc-949c084e9493
 2008-01-10 13:39:23 +00:00
PriestJ
726800b0e3 Added some rough jpeg module drawings for the bulk upload 
git-svn-id: http://locode01.ad.dom/svn/WEBMIP/trunk@3184 248e525c-4dfb-0310-94bc-949c084e9493
 2008-01-10 13:33:36 +00:00
hardya
d9a37fb4c4 Source files for bulk load 
git-svn-id: http://locode01.ad.dom/svn/WEBMIP/trunk@3183 248e525c-4dfb-0310-94bc-949c084e9493
 2008-01-10 13:32:40 +00:00
hardya
54625dcb9f Added additional_items and costs to the demo data. 
git-svn-id: http://locode01.ad.dom/svn/WEBMIP/trunk@3059 248e525c-4dfb-0310-94bc-949c084e9493
 2007-12-21 17:31:34 +00:00
hardya
812592d3b1 Added syco.ctl to populate the system_configuration table. 
git-svn-id: http://locode01.ad.dom/svn/WEBMIP/trunk@3011 248e525c-4dfb-0310-94bc-949c084e9493
 2007-12-18 10:10:39 +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
hardya
429ac5f909 Documentation 
New and amended ERDs.

Schema
Added support for documents.
Added modules to costs.

Data
Added document role types.

git-svn-id: http://locode01.ad.dom/svn/WEBMIP/trunk@2983 248e525c-4dfb-0310-94bc-949c084e9493
 2007-12-12 16:30:57 +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
PriestJ
4e275aa855 Altered install scripts to add a base user in the seed data. Also altered install script to correctly accept a 6th parameter. Edited mip_security.authorize so that if no data is returned the system returns false. 
git-svn-id: http://locode01.ad.dom/svn/WEBMIP/trunk@2894 248e525c-4dfb-0310-94bc-949c084e9493
 2007-11-27 18:39:27 +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
cb7b890a92 Data: 
Replace multiple Data/Seed 'role_types' files with Data/Seed/rt.ctl

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