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

48 Commits

Author SHA1 Message Date
jamie.priest
689e6a13dd Altered sequence numbers to fall in line with the order GW wants the fields to appear on the email to I&C. The first 3 fields he wants are not in the spreadsheet but can be derived from data in the system. See ticket #550 for more info 
git-svn-id: http://locode01.ad.dom/svn/WEBMIP/trunk@12250 248e525c-4dfb-0310-94bc-949c084e9493
 2009-08-14 16:25:00 +00:00
jamie.priest
f1018ba61e GW's changes after adding the Purging required field 
git-svn-id: http://locode01.ad.dom/svn/WEBMIP/trunk@12165 248e525c-4dfb-0310-94bc-949c084e9493
 2009-08-06 17:15:46 +00:00
jamie.priest
97a06365f0 Document updated to include new purging field. This version has been sent to GW to fill in the gaps. 
git-svn-id: http://locode01.ad.dom/svn/WEBMIP/trunk@12127 248e525c-4dfb-0310-94bc-949c084e9493
 2009-08-05 11:46:21 +00:00
jamie.priest
20562bccb3 requeried diagrams as part of support documentation update, attempting to keep trac documentation up-to-date. 
git-svn-id: http://locode01.ad.dom/svn/WEBMIP/trunk@11548 248e525c-4dfb-0310-94bc-949c084e9493
 2009-06-22 10:05:45 +00:00
hardya
b3ebbef545 Address #504 - Manual Quote not created for Change Capacity (plus fix for subsequently found errors). 
git-svn-id: http://locode01.ad.dom/svn/WEBMIP/trunk@4810 248e525c-4dfb-0310-94bc-949c084e9493
 2008-04-16 16:29:28 +00:00
hardya
cae05e68a9 Address #483 with changes to DATAITEM_ROLES.csv, DATAITEM_ROLES.xls. 
Add conditional compilation for debugging.

Use correct NLS language in dads.conf 

git-svn-id: http://locode01.ad.dom/svn/WEBMIP/trunk@4793 248e525c-4dfb-0310-94bc-949c084e9493
 2008-04-14 17:04:06 +00:00
hardya
d11ee1ccc9 Address #408, Tripartite region check. 
Address #422, Missing mandatory fields when meter model selected. Removed Popup LOV with AJAX select lists. Supporred by mip_select_xml.pck)


git-svn-id: http://locode01.ad.dom/svn/WEBMIP/trunk@4069 248e525c-4dfb-0310-94bc-949c084e9493
 2008-03-25 15:56:53 +00:00
PriestJ
5c62bde0c8 changed ip mbar field name to IP Inlet pressure at request of GW 
git-svn-id: http://locode01.ad.dom/svn/WEBMIP/trunk@4011 248e525c-4dfb-0310-94bc-949c084e9493
 2008-03-14 16:21:06 +00:00
hardya
bdbb396c22 Addresses #390, bypass_other to be mandatory if bypass_required = '7' 
git-svn-id: http://locode01.ad.dom/svn/WEBMIP/trunk@4004 248e525c-4dfb-0310-94bc-949c084e9493
 2008-03-14 14:35:40 +00:00
hardya
320ce75fcf Changes made for BulkLoad information provided by Gareth on 5th March (new bas_dwg/102M.jpg, csv exports) 
New package mip_debug_constants.pks to be used to store compilation constants for debugging purposes (packages to use pl from mip_debug).

mip_quotation.pck modified to support exchanges based on being provided with an existing model rather than meter size. Changes to the DATAITEM_ROLES.csv to support this new field, impact on mandatory rules captured by mip_helper_special_cases.pck

git-svn-id: http://locode01.ad.dom/svn/WEBMIP/trunk@3900 248e525c-4dfb-0310-94bc-949c084e9493
 2008-03-10 12:29:59 +00:00
hardya
892b80a712 Add rule O-M6 to Change Capacity 
git-svn-id: http://locode01.ad.dom/svn/WEBMIP/trunk@3891 248e525c-4dfb-0310-94bc-949c084e9493
 2008-03-07 13:41:44 +00:00
hardya
aca7131f6f Add rule O-M6 to EXISTING_METY_CODE 
git-svn-id: http://locode01.ad.dom/svn/WEBMIP/trunk@3890 248e525c-4dfb-0310-94bc-949c084e9493
 2008-03-07 13:29:55 +00:00
hardya
da9dbc2d94 Add rule O-M6 to deal with EXISTING_METR_CODE being set to 'OTHER' 
Amend rule O-M2 to deal with REQUIRED_MESC_CODE being set to 'OTHER'

git-svn-id: http://locode01.ad.dom/svn/WEBMIP/trunk@3889 248e525c-4dfb-0310-94bc-949c084e9493
 2008-03-07 13:15:04 +00:00
PriestJ
cbc7e50737 made meter model code mandatory for capacity changes 
git-svn-id: http://locode01.ad.dom/svn/WEBMIP/trunk@3877 248e525c-4dfb-0310-94bc-949c084e9493
 2008-03-06 17:24:35 +00:00
hardya
de1d9d408e Alterations to schema (primarily enquiries) to support 'existing' meter requirements due to [wiki:MeetingNotes/MeetingNote3rdMarch Meeting to discuss/spec new variations, 3rd March] 
git-svn-id: http://locode01.ad.dom/svn/WEBMIP/trunk@3837 248e525c-4dfb-0310-94bc-949c084e9493
 2008-03-04 15:14:02 +00:00
PriestJ
d7ea565461 Updated as part of Meeting on 3rd March with GW 
git-svn-id: http://locode01.ad.dom/svn/WEBMIP/trunk@3822 248e525c-4dfb-0310-94bc-949c084e9493
 2008-03-03 18:20:51 +00:00
hardya
6dd271eb4c Changes to 'mandatory' processing to address #270. Ext_dataitem_role.pdc and DATAITEM_ROLES referreed to enquiry type 'CAPACITY CHANGE' rather than 'CHANGE CAPACITY' which caused gen_mandatory not to create mandatory conditions for the 'CHANGE CAPACITY' enquiry type. 
git-svn-id: http://locode01.ad.dom/svn/WEBMIP/trunk@3639 248e525c-4dfb-0310-94bc-949c084e9493
 2008-02-20 10:19:00 +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
34e5c7dd90 deleted tripartite entries as they no longer apply in this context, we would need to add in the regions also. Added GW corrections for the Convertor field. 
git-svn-id: http://locode01.ad.dom/svn/WEBMIP/trunk@3510 248e525c-4dfb-0310-94bc-949c084e9493
 2008-02-11 14:11:55 +00:00
PriestJ
e8ffc3c9bd added title/initials rows for first and second contact as these were originally missed from the spec 
git-svn-id: http://locode01.ad.dom/svn/WEBMIP/trunk@3507 248e525c-4dfb-0310-94bc-949c084e9493
 2008-02-08 18:16:44 +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
db78bf5c4c DatabaseItemToFunctionalSpecificationReference.xls - renamed METY_CODE to EXISTING_METY_CODE, included DISPLAY_SEQUENCE to be used in the generation of emails, etc. 
Minor internal changes to operation of cout_assert.pck and cout_err.pck.
mip_quotation.pck - made validation routines open to external processes. Added enquiry entry details to manual quotes.

Schema - Removed data_items table and amended data_item_roles to support display_sequence requirements.



git-svn-id: http://locode01.ad.dom/svn/WEBMIP/trunk@3407 248e525c-4dfb-0310-94bc-949c084e9493
 2008-01-28 18:41:24 +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
hardya
32dac70391 Updated 'mandatory' field checks. 
git-svn-id: http://locode01.ad.dom/svn/WEBMIP/trunk@3322 248e525c-4dfb-0310-94bc-949c084e9493
 2008-01-21 18:56:25 +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
PriestJ
c6ffb8aa4b added line entry for Existing Convertor 
git-svn-id: http://locode01.ad.dom/svn/WEBMIP/trunk@3238 248e525c-4dfb-0310-94bc-949c084e9493
 2008-01-14 18:49:04 +00:00
hardya
af4d87ac14 Made Additional Item optional against the exclusion. 
git-svn-id: http://locode01.ad.dom/svn/WEBMIP/trunk@2992 248e525c-4dfb-0310-94bc-949c084e9493
 2007-12-14 12:14:30 +00:00
hardya
06787fbeed Updated ERD_TRIPARTITE_AGREEMENT.png to include Additional Item Costs as a potential restriction. 
git-svn-id: http://locode01.ad.dom/svn/WEBMIP/trunk@2990 248e525c-4dfb-0310-94bc-949c084e9493
 2007-12-14 12:11:11 +00:00
hardya
4a985f387b ERD of Tripartite Agreement implementation. 
git-svn-id: http://locode01.ad.dom/svn/WEBMIP/trunk@2989 248e525c-4dfb-0310-94bc-949c084e9493
 2007-12-14 11:50:39 +00:00
hardya
c22e712a33 Amended to include reference to Tripartite agreement. 
git-svn-id: http://locode01.ad.dom/svn/WEBMIP/trunk@2986 248e525c-4dfb-0310-94bc-949c084e9493
 2007-12-13 17:03:05 +00:00
hardya
82d8bb59e2 Updated in line with meeting held on 13th December with Gareth and Jane. 
git-svn-id: http://locode01.ad.dom/svn/WEBMIP/trunk@2984 248e525c-4dfb-0310-94bc-949c084e9493
 2007-12-13 14:02:28 +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
a3522fe7b0 New labour costs sheet describes what information we need before we can get a quote (AH to fill in the rest of the sheet with the appropriate values) altered the Mandatory fields sheet with updated values 
git-svn-id: http://locode01.ad.dom/svn/WEBMIP/trunk@2955 248e525c-4dfb-0310-94bc-949c084e9493
 2007-12-07 16:53:12 +00:00
PriestJ
97020a9c35 finished mapping the mandatory/optional matrix, aware that there may be changes at a later date 
git-svn-id: http://locode01.ad.dom/svn/WEBMIP/trunk@2863 248e525c-4dfb-0310-94bc-949c084e9493
 2007-11-16 14:13:27 +00:00
PriestJ
f730298583 Enquiry datafields mapping and mandatory/optional spreadsheet: Added extra job type columns, in is now has all the jobtypes described in the functional spec appendix data items. Have worked though all the way down to Model Code/Number row 48 (I think). Need to back fill the rows on the columns that I have added 
git-svn-id: http://locode01.ad.dom/svn/WEBMIP/trunk@2860 248e525c-4dfb-0310-94bc-949c084e9493
 2007-11-15 18:05:13 +00:00
hardya
f174ac7747 Schema Changes: 
Attributes (generally size and dimensions) added to REGULATORS, BASES and HOUSINGS.
Changed primary keys on CONNECTION_ORIENTATIONS, FILTERS, REGULATORS to be 'code' rather than 'id'-based.
Altered ENQUIRIES to make contact names, addresses and contact mechanisms explicit within the enquiry rather than using the general contact mechanism.

Seed Data:
Changed 'code' values for HOUSING_TYPES, METER_TYPES, REGULATOR_TYPES and SERVICE_PRESSURES to match their descriptions.

Documentation:
Updated Documentation/Design/DatabaseItemToFunctionalSpecificationReference.xls in line with schema changes.

Demo Data:
Includes modules and related data from the MIP140306 Access database.

git-svn-id: http://locode01.ad.dom/svn/WEBMIP/trunk@2857 248e525c-4dfb-0310-94bc-949c084e9493
 2007-11-15 10:29:55 +00:00
hardya
63161f1e4a Added Documentation/Design/DatabaseItemToFunctionalSpecificationReference.xls as a cross reference between table columns and Functional Specification appendix data items. Incomplete - requires completion of mandatory column information. 
Schema Modifications: Removed column 'Outlet Pressure' from ENQUIRIES table.

git-svn-id: http://locode01.ad.dom/svn/WEBMIP/trunk@2852 248e525c-4dfb-0310-94bc-949c084e9493
 2007-11-13 17:17:01 +00:00
hardya
e91312289b Updated ERDs published from Designer. 
git-svn-id: http://locode01.ad.dom/svn/WEBMIP/trunk@2846 248e525c-4dfb-0310-94bc-949c084e9493
 2007-11-13 09:59:25 +00:00
hardya
e18a8f6cb7 Removed 'not null' requirements from ENQUIRIES table to allow the saving of an incomplete enquiry. 
Corrected Data/Seed/enrt.ctl and Data/Seed/part.ctl to allow enquiry roles to be loaded.

git-svn-id: http://locode01.ad.dom/svn/WEBMIP/trunk@2845 248e525c-4dfb-0310-94bc-949c084e9493
 2007-11-12 17:21:32 +00:00
hardya
a3ad7aa4ae Added ERD_QUOTE.png. 
Modified ERD_ENQUIRY.png to include roles rather than repetition of created by/for attributes.


git-svn-id: http://locode01.ad.dom/svn/WEBMIP/trunk@2796 248e525c-4dfb-0310-94bc-949c084e9493
 2007-10-18 16:51:40 +00:00
hardya
d05c1be338 Added Created For/Updated For to handle proxy work performed on enquiry; Enquiry Type to handle supported types of enquiry. 
git-svn-id: http://locode01.ad.dom/svn/WEBMIP/trunk@2795 248e525c-4dfb-0310-94bc-949c084e9493
 2007-10-18 14:12:28 +00:00
hardya
10f8b10f77 Added ERD_COSTS.png, ERD_PARTY_CONTACT_MECHANISM.png and renamed other images to remove spaces. 
git-svn-id: http://locode01.ad.dom/svn/WEBMIP/trunk@2794 248e525c-4dfb-0310-94bc-949c084e9493
 2007-10-18 12:17:39 +00:00
hardya
c9b54f45e7 Addition of existing meter service pressure category 
git-svn-id: http://locode01.ad.dom/svn/WEBMIP/trunk@2787 248e525c-4dfb-0310-94bc-949c084e9493
 2007-10-12 13:31:44 +00:00
hardya
462f2635c3 Added ERD for Enquiry 
git-svn-id: http://locode01.ad.dom/svn/WEBMIP/trunk@2785 248e525c-4dfb-0310-94bc-949c084e9493
 2007-10-12 09:35:01 +00:00
hardya
df9490682b Removed relationship between Party and User Account 
git-svn-id: http://locode01.ad.dom/svn/WEBMIP/trunk@2784 248e525c-4dfb-0310-94bc-949c084e9493
 2007-10-12 08:22:42 +00:00
hardya
de5dbb778c Renamed remotely to remove comma from name 
git-svn-id: http://locode01.ad.dom/svn/WEBMIP/trunk@2783 248e525c-4dfb-0310-94bc-949c084e9493
 2007-10-12 08:13:10 +00:00
hardya
2629096318 Added ERD for parties and roles. 
git-svn-id: http://locode01.ad.dom/svn/WEBMIP/trunk@2782 248e525c-4dfb-0310-94bc-949c084e9493
 2007-10-12 08:08:13 +00:00
hardya
f0b63e69a5 Created Documentation/Design to hold design details. 
git-svn-id: http://locode01.ad.dom/svn/WEBMIP/trunk@2572 248e525c-4dfb-0310-94bc-949c084e9493
 2007-09-07 09:19:41 +00:00