58 Commits

Author SHA1 Message Date
andrew.hardy
b161385309 Update contact details for letters and emails following 'Single Mandate' request from NGM.
git-svn-id: http://locode01.ad.dom/svn/WEBMIP/trunk@58719 248e525c-4dfb-0310-94bc-949c084e9493
2012-08-20 08:34:23 +00:00
andrew.hardy
81db2835f2 Add routines to mip_quotation.pck and mip_*_helper (via gen_mandatory.prc) packages to set to NULL fields in the enquiry that are not relevant for that enquiry type (following issue raised in UAT).
git-svn-id: http://locode01.ad.dom/svn/WEBMIP/trunk@13609 248e525c-4dfb-0310-94bc-949c084e9493
2009-11-20 15:59:47 +00:00
andrew.hardy
1110407d42 Addresses #566
Include ADDITIONAL_ITEM 'SELFPURGING' to cover instances of 'purging' where the user has selected 'NO' - i.e. the customer will carry out any required purging. Used to simplify CAVEAT text selection.

git-svn-id: http://locode01.ad.dom/svn/WEBMIP/trunk@13258 248e525c-4dfb-0310-94bc-949c084e9493
2009-11-03 15:08:58 +00:00
andrew.hardy
a645a35335 Modify additional item cost routines in mip_bulk_load.pck and mip_quotation.pck to make use of enquiry type as a cost parameter. Matching changes to the BULK_LOAD.xls spreadsheet.
Change get_quote_items.fnc to return the descriptions of additional items instead of the 'code'.

git-svn-id: http://locode01.ad.dom/svn/WEBMIP/trunk@12542 248e525c-4dfb-0310-94bc-949c084e9493
2009-09-08 10:58:39 +00:00
andrew.hardy
c621cd7b24 Initial changes to mip_quotation.pck and mip_bulk_load.pck to support PhaseII purging requirements.
New attributes added to Schema/ext_cost.pdc,  Data/BulkLoad/BULK_LOAD.xls (as exported through Data/BulkLoad/MATERIAL_COSTS.csv).

Changes to views V_AICO.vw and V_QUOTE_DETAILS.vw to recognize the new attributes and to stop PURGING being excluded from details.


git-svn-id: http://locode01.ad.dom/svn/WEBMIP/trunk@12526 248e525c-4dfb-0310-94bc-949c084e9493
2009-09-04 16:29:42 +00:00
jamie.priest
1a42b8892f sequencing of the enquiry fields for produce_enquiry_entry_details procedure was based on text rather than numerical order.
git-svn-id: http://locode01.ad.dom/svn/WEBMIP/trunk@12261 248e525c-4dfb-0310-94bc-949c084e9493
2009-08-17 15:20:11 +00:00
jamie.priest
502c6564f9 had a stab at bringing the email output inline with the fds see ticket #550
git-svn-id: http://locode01.ad.dom/svn/WEBMIP/trunk@12254 248e525c-4dfb-0310-94bc-949c084e9493
2009-08-17 12:19:49 +00:00
PriestJ
bfdb160ca1 Fix for #528 email to internal users was being called twice
git-svn-id: http://locode01.ad.dom/svn/WEBMIP/trunk@5644 248e525c-4dfb-0310-94bc-949c084e9493
2008-07-08 12:49:59 +00:00
hardya
f36c5b079a Merged in changes from RB-1.0 related to #524 (Add-Ons not being quoted for).
git-svn-id: http://locode01.ad.dom/svn/WEBMIP/trunk@5624 248e525c-4dfb-0310-94bc-949c084e9493
2008-07-07 15:22:55 +00:00
PriestJ
7c1ad73fa7 Fix for #514 Implemented AH's suggested code, this seems to have fixed the issue. The correct qmax value is now passed for Removal, OFMAT and alteration jobs
git-svn-id: http://locode01.ad.dom/svn/WEBMIP/trunk@5280 248e525c-4dfb-0310-94bc-949c084e9493
2008-06-12 15:15:21 +00:00
hardya
cf4e7ff452 Modified lead time calculations to cope with boundary cases. Addresses #506.
git-svn-id: http://locode01.ad.dom/svn/WEBMIP/trunk@4823 248e525c-4dfb-0310-94bc-949c084e9493
2008-04-17 13:52:20 +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
9b6d215e2c Addresses #502 - lead times to use a Qmax 'inclusive' between upper and lower bounds
git-svn-id: http://locode01.ad.dom/svn/WEBMIP/trunk@4809 248e525c-4dfb-0310-94bc-949c084e9493
2008-04-16 15:11:52 +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
1b445a73e1 mip_quotation.pck addresses #446 (Site Survey Rules) and #465 (Lifting Gear Rules)
mip_bulk_load.pck moved 'init' to package initialization to allow procedures other than load_all be run in isolation.

git-svn-id: http://locode01.ad.dom/svn/WEBMIP/trunk@4753 248e525c-4dfb-0310-94bc-949c084e9493
2008-04-09 16:22:28 +00:00
hardya
759f63c635 MIP_ENQUIRY.pck - address back-end of #439.
mip_quotation.pck - address back-end of #442.

mip_security.pck - track CGI environment variables as part of #454.

mip_quotation.pck - store files with the correct flow_id;

git-svn-id: http://locode01.ad.dom/svn/WEBMIP/trunk@4733 248e525c-4dfb-0310-94bc-949c084e9493
2008-04-07 15:25:13 +00:00
hardya
5974a9c36f Meter Type was missing from labour quote item.
git-svn-id: http://locode01.ad.dom/svn/WEBMIP/trunk@4714 248e525c-4dfb-0310-94bc-949c084e9493
2008-04-03 11:13:25 +00:00
hardya
fde2af4036 Addresses #451
git-svn-id: http://locode01.ad.dom/svn/WEBMIP/trunk@4712 248e525c-4dfb-0310-94bc-949c084e9493
2008-04-03 09:56:56 +00:00
hardya
e310449816 Committed prior to FAT testing
git-svn-id: http://locode01.ad.dom/svn/WEBMIP/trunk@4072 248e525c-4dfb-0310-94bc-949c084e9493
2008-03-26 09:15:49 +00:00
hardya
6bd7a6c926 Additional logging for the mandatory check (see ticket #402)
git-svn-id: http://locode01.ad.dom/svn/WEBMIP/trunk@4019 248e525c-4dfb-0310-94bc-949c084e9493
2008-03-17 12:13:05 +00:00
hardya
5d2da832ea Addresses #396. Checking of existing meter didn't recognize the 'OTHER' meter model correctly in labour-only quotes.
git-svn-id: http://locode01.ad.dom/svn/WEBMIP/trunk@4010 248e525c-4dfb-0310-94bc-949c084e9493
2008-03-14 16:01:33 +00:00
hardya
72de82bbde Addresses #376. Correct detection of a bypass_required reason.
git-svn-id: http://locode01.ad.dom/svn/WEBMIP/trunk@4006 248e525c-4dfb-0310-94bc-949c084e9493
2008-03-14 14:54:52 +00:00
hardya
2c936de2b2 Addresses #394, convertor required to lead to manual quote.
git-svn-id: http://locode01.ad.dom/svn/WEBMIP/trunk@3996 248e525c-4dfb-0310-94bc-949c084e9493
2008-03-14 11:44:27 +00:00
hardya
24c31ebc45 Add calc_meter_reqs to mip_quotation.pck.
Ensure that all calls to add_quote_reason use correct parameters (mip_quotation.pck).

Change grant from 'CREATE ANY VIEW' to 'CREATE VIEW' in InstallMIP.sql following problems installing 'supporting objects' into MIP_TEST.


git-svn-id: http://locode01.ad.dom/svn/WEBMIP/trunk@3989 248e525c-4dfb-0310-94bc-949c084e9493
2008-03-13 18:36:18 +00:00
hardya
8ee044c2dd Addressed #363, assertion error and/or ORA-06502 errors during the quote generation caused by missing Required Meter Size or Qmax in the submitted enquiry.
git-svn-id: http://locode01.ad.dom/svn/WEBMIP/trunk@3975 248e525c-4dfb-0310-94bc-949c084e9493
2008-03-12 17:56:39 +00:00
hardya
b684db635b Ensure that we have a required_qmax for 'exchanges' not affected by 'one-U-step' rules (mip_quotation.pck).
Tidy-up debug messages from MIP_FILES.pck.

git-svn-id: http://locode01.ad.dom/svn/WEBMIP/trunk@3940 248e525c-4dfb-0310-94bc-949c084e9493
2008-03-11 12:10:01 +00:00
hardya
eee0364f94 Ensure that only 'current' modules and meters are selected (mip_quotation.pck).
Where valid from is null in new meters, set the valid from to the start of the day on which they are loaded (mip_bulk_load.pck).


git-svn-id: http://locode01.ad.dom/svn/WEBMIP/trunk@3927 248e525c-4dfb-0310-94bc-949c084e9493
2008-03-10 17:29:43 +00:00
hardya
7597637831 Ensure that only required qmax or required mesc code is used in the module enquiry.
git-svn-id: http://locode01.ad.dom/svn/WEBMIP/trunk@3925 248e525c-4dfb-0310-94bc-949c084e9493
2008-03-10 17:11:17 +00:00
hardya
ed16b182ef Correction to labour cost only quotes to get costing parameters from existing meter (as for module quotes).
git-svn-id: http://locode01.ad.dom/svn/WEBMIP/trunk@3917 248e525c-4dfb-0310-94bc-949c084e9493
2008-03-10 16:20:04 +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
6604eb2831 Add general debug routines (mip_debug.pck, mip_debug_constants.pks)
Send email attachments (mip_quotation.pck, mip_email.pck - templates from WebMIP Email templates.doc)
Add Lifting Gear to 'labour' quotes (mip_quotation.pck)

git-svn-id: http://locode01.ad.dom/svn/WEBMIP/trunk@3860 248e525c-4dfb-0310-94bc-949c084e9493
2008-03-06 11:53:45 +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
hardya
dbcb349c45 Addresses #269, #280, #306.
Add processing to make it clearer which application build has been produced and to link the schema with the correct application (AssociateSchema.sql, SetSubstitution.sql, bulk_load.sql and InstallMIP.cmd)

Changes to schema: METERS now have 'MESC_CODE'. Associated changes in the bulk_load routines and initial changes to mip_quotation.pck (needs confirmation testing).

git-svn-id: http://locode01.ad.dom/svn/WEBMIP/trunk@3830 248e525c-4dfb-0310-94bc-949c084e9493
2008-03-04 12:03:03 +00:00
hardya
1f0c8e4f90 Address #303 - removed <br> from friendly constraint messages.
Amend Qmax values defined within MESC.ctl
Fix bulk_load errors related to loading drawings through MIP_FILES
Amend mip_quotation to produce labour costs where meter size or service pressure is not a cost constraint.
Amend mip_quotation email messages.
Perform additional compilations during install to account for dependency links.
Make meter dimensions optional (mip.tab)

git-svn-id: http://locode01.ad.dom/svn/WEBMIP/trunk@3721 248e525c-4dfb-0310-94bc-949c084e9493
2008-02-26 17:54:21 +00:00
hardya
cc3f165ee5 Updated LeadTimes.csv and modules in line with Gareths email of 20/2/2008
git-svn-id: http://locode01.ad.dom/svn/WEBMIP/trunk@3648 248e525c-4dfb-0310-94bc-949c084e9493
2008-02-20 18:24:35 +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
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
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
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
hardya
5f2186b3ac mip_quotation.pck - remove reference to gtt_manadatory_checks
git-svn-id: http://locode01.ad.dom/svn/WEBMIP/trunk@3412 248e525c-4dfb-0310-94bc-949c084e9493
2008-01-29 11:40:23 +00:00
hardya
7e4f08658b Amend mip_quotation to refer to a permanent table for validation results.
git-svn-id: http://locode01.ad.dom/svn/WEBMIP/trunk@3409 248e525c-4dfb-0310-94bc-949c084e9493
2008-01-29 11:33:37 +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
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
8638b8b2ae Modules/mip_helper_special_cases.pck - correction to rule OM-4
Modules/mip_quotation.pck - add prty_id and owner_prty_id to quote status procedures to record the relevant roles. Add debug routine 'pl' to write a log file of processing. Tidy-up email wording.
Modules/mip_regions.pck - convert given postcode to uppercase before processing.
Modules/mip_virus_check.pck - started work on the virus checking module. So far, just have the ability to write a document to the filesystem. Added new directory, 'WEBMIP_VIRUS' to store these files in.

git-svn-id: http://locode01.ad.dom/svn/WEBMIP/trunk@3381 248e525c-4dfb-0310-94bc-949c084e9493
2008-01-23 18:24:40 +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
e9b5c5a125 mip_quotation.pck - produce quotes for 'EXCHANGE'
V_QUOTE_DETAILS.vw - include hou_code

git-svn-id: http://locode01.ad.dom/svn/WEBMIP/trunk@3303 248e525c-4dfb-0310-94bc-949c084e9493
2008-01-18 16:04:45 +00:00
hardya
9d7b4c263b Added support for Removals.
Added interfaces to quote status setting.

Produce emails on completion of quotation.

git-svn-id: http://locode01.ad.dom/svn/WEBMIP/trunk@3291 248e525c-4dfb-0310-94bc-949c084e9493
2008-01-17 17:51:20 +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