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

849 Commits

This Branch
This Branch
All Branches
Author SHA1 Message Date
andrew.hardy
100fc61d8b Completed work on plsql_ccflag switches to allow easier testing: 
- force_old_address makes old contact details appear;
- force_new_address makes new contact details appear;
- force_old_date makes the change over date appear to be 13-aug-2012

These switches should be used exclusive to one-another.
In production, no compilation switches should be used.

git-svn-id: http://locode01.ad.dom/svn/WEBMIP/trunk@58720 248e525c-4dfb-0310-94bc-949c084e9493
 2012-08-20 08:34:52 +00:00
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
4ed6e01260 Keep a copy of the APEX workspace within the application repository 
git-svn-id: http://locode01.ad.dom/svn/WEBMIP/trunk@58718 248e525c-4dfb-0310-94bc-949c084e9493
 2012-08-20 08:29:58 +00:00
jamie.priest
e22d925b9c Latest changes from the NGM team only labour and material costs have changed again, should be the last revision for the Apr 2012 bulkload. 
git-svn-id: http://locode01.ad.dom/svn/WEBMIP/trunk@51419 248e525c-4dfb-0310-94bc-949c084e9493
 2012-03-27 16:17:51 +00:00
jamie.priest
3e0dcc51b0 Updated the BulkLoad sheet based on the latest file supplied by NGM (23/03/2012), the BULK_LOAD.xls is a cleaned version with unwanted data cells removed. Only new LABOUR_COSTS.csv and MATERIAL_COSTS.csv data had changed from the sheet. 
git-svn-id: http://locode01.ad.dom/svn/WEBMIP/trunk@51229 248e525c-4dfb-0310-94bc-949c084e9493
 2012-03-25 12:11:20 +00:00
andrew.hardy
99d3210ea5 Modified bulk load process to correctly assign ALTERATION costs (previously used EXCHANGE costs). 
git-svn-id: http://locode01.ad.dom/svn/WEBMIP/trunk@51117 248e525c-4dfb-0310-94bc-949c084e9493
 2012-03-22 17:57:44 +00:00
andrew.gilmore
2c4461fde1 Received at GL Noble Denton 16:48 on Tuesday 20th March 2012 
git-svn-id: http://locode01.ad.dom/svn/WEBMIP/trunk@51043 248e525c-4dfb-0310-94bc-949c084e9493
 2012-03-21 12:34:33 +00:00
andrew.gilmore
55b30d8c94 CSV files created from data received at GL Noble Denton 16:48 on Tuesday 20th March 2012 
git-svn-id: http://locode01.ad.dom/svn/WEBMIP/trunk@51042 248e525c-4dfb-0310-94bc-949c084e9493
 2012-03-21 12:33:14 +00:00
andrew.gilmore
ae40d1b14a CSV files created from data received at GL Noble Denton mid-day on Friday 16th March 2012 
git-svn-id: http://locode01.ad.dom/svn/WEBMIP/trunk@50967 248e525c-4dfb-0310-94bc-949c084e9493
 2012-03-20 14:59:15 +00:00
andrew.gilmore
8237ae9e20 Received at GL Noble Denton mid-day on Friday 16th March 2012 
git-svn-id: http://locode01.ad.dom/svn/WEBMIP/trunk@50882 248e525c-4dfb-0310-94bc-949c084e9493
 2012-03-19 12:12:53 +00:00
hardya
dc3ce0940f Added in error 
git-svn-id: http://locode01.ad.dom/svn/WEBMIP/trunk@50876 248e525c-4dfb-0310-94bc-949c084e9493
 2012-03-19 12:05:08 +00:00
andrew.gilmore
0e9ca75d77 git-svn-id: http://locode01.ad.dom/svn/WEBMIP/trunk@50874 248e525c-4dfb-0310-94bc-949c084e9493 2012-03-19 11:57:19 +00:00
dharshani.k
2a0f4900c3 Labour Costs and Material Costs CSV from 26Oct11 Production Load E.xls 
git-svn-id: http://locode01.ad.dom/svn/WEBMIP/trunk@40159 248e525c-4dfb-0310-94bc-949c084e9493
 2011-10-26 11:16:28 +00:00
dharshani.k
28d2649d66 26Oct11 Production Load E.xls saved as BULK_LOAD.xls for upload 
git-svn-id: http://locode01.ad.dom/svn/WEBMIP/trunk@40158 248e525c-4dfb-0310-94bc-949c084e9493
 2011-10-26 11:14:38 +00:00
dharshani.k
3582cc121b Labour Costs and Material Costs CSV from 26Oct11 Production Load D.xls 
git-svn-id: http://locode01.ad.dom/svn/WEBMIP/trunk@40157 248e525c-4dfb-0310-94bc-949c084e9493
 2011-10-26 10:15:37 +00:00
dharshani.k
da33ae692b 26Oct11 Production Load D.xls saved as BULK_LOAD.xls for upload 
git-svn-id: http://locode01.ad.dom/svn/WEBMIP/trunk@40156 248e525c-4dfb-0310-94bc-949c084e9493
 2011-10-26 10:05:52 +00:00
dharshani.k
d1bdf56159 Labour Costs and Material Costs CSV from 19Oct Load B corrected date.xls 
git-svn-id: http://locode01.ad.dom/svn/WEBMIP/trunk@39982 248e525c-4dfb-0310-94bc-949c084e9493
 2011-10-24 09:33:26 +00:00
dharshani.k
3a63bbde76 19Oct Load B corrected date.xls saved as BULK_LOAD.xls for upload 
git-svn-id: http://locode01.ad.dom/svn/WEBMIP/trunk@39961 248e525c-4dfb-0310-94bc-949c084e9493
 2011-10-21 15:44:52 +00:00
dharshani.k
21f04bce4b Labour and Material costs from 19Oct Load B.xls 
git-svn-id: http://locode01.ad.dom/svn/WEBMIP/trunk@39900 248e525c-4dfb-0310-94bc-949c084e9493
 2011-10-20 12:03:33 +00:00
dharshani.k
c8261402e4 19Oct Load B.xls saved as BULK_LOAD.xls for upload 
git-svn-id: http://locode01.ad.dom/svn/WEBMIP/trunk@39895 248e525c-4dfb-0310-94bc-949c084e9493
 2011-10-20 12:01:59 +00:00
dharshani.k
3bc1ab5f1d Junk columns removed 
git-svn-id: http://locode01.ad.dom/svn/WEBMIP/trunk@39871 248e525c-4dfb-0310-94bc-949c084e9493
 2011-10-20 09:42:54 +00:00
dharshani.k
fc8eccb4c3 Labour and Material costs from 19Oct Load A.xls 
git-svn-id: http://locode01.ad.dom/svn/WEBMIP/trunk@39870 248e525c-4dfb-0310-94bc-949c084e9493
 2011-10-20 09:35:46 +00:00
dharshani.k
307bddd61a 19Oct Load A.xls saved as BULK_LOAD.xls for upload 
git-svn-id: http://locode01.ad.dom/svn/WEBMIP/trunk@39869 248e525c-4dfb-0310-94bc-949c084e9493
 2011-10-20 09:32:37 +00:00
dharshani.k
0ba033e5e2 Original bulk load file provided for the upload 
git-svn-id: http://locode01.ad.dom/svn/WEBMIP/trunk@39868 248e525c-4dfb-0310-94bc-949c084e9493
 2011-10-20 09:30:18 +00:00
dharshani.k
0efab5c9ba git-svn-id: http://locode01.ad.dom/svn/WEBMIP/trunk@38996 248e525c-4dfb-0310-94bc-949c084e9493 2011-10-07 12:08:51 +00:00
dharshani.k
770b53de21 git-svn-id: http://locode01.ad.dom/svn/WEBMIP/trunk@38984 248e525c-4dfb-0310-94bc-949c084e9493 2011-10-07 10:22:36 +00:00
dharshani.k
653b9b571f Unwanted data lines removed 
git-svn-id: http://locode01.ad.dom/svn/WEBMIP/trunk@38937 248e525c-4dfb-0310-94bc-949c084e9493
 2011-10-06 13:43:01 +00:00
dharshani.k
65f16d711d Latest material cost data 
git-svn-id: http://locode01.ad.dom/svn/WEBMIP/trunk@38936 248e525c-4dfb-0310-94bc-949c084e9493
 2011-10-06 13:39:21 +00:00
dharshani.k
34ad5a1e03 Latest labour cost data 
git-svn-id: http://locode01.ad.dom/svn/WEBMIP/trunk@38935 248e525c-4dfb-0310-94bc-949c084e9493
 2011-10-06 13:38:51 +00:00
dharshani.k
bfc499348b Latest labour cost data 
git-svn-id: http://locode01.ad.dom/svn/WEBMIP/trunk@38933 248e525c-4dfb-0310-94bc-949c084e9493
 2011-10-06 13:26:27 +00:00
dharshani.k
e53d67a5c8 Bulk load data provided on 06/10/2011 
git-svn-id: http://locode01.ad.dom/svn/WEBMIP/trunk@38932 248e525c-4dfb-0310-94bc-949c084e9493
 2011-10-06 13:12:55 +00:00
andrew.hardy
053ce6148a Addressed #573 by modifying mip_quotation_document.pck so that the quotation page costs do not overlap. 
git-svn-id: http://locode01.ad.dom/svn/WEBMIP/trunk@26040 248e525c-4dfb-0310-94bc-949c084e9493
 2010-09-02 14:42:01 +00:00
andrew.hardy
04696f1008 Moved the signature image upwards in the signature block (following earlier movements of the text). 
git-svn-id: http://locode01.ad.dom/svn/WEBMIP/trunk@25710 248e525c-4dfb-0310-94bc-949c084e9493
 2010-08-17 09:14:23 +00:00
andrew.hardy
b66ed437f4 Moved the body of the quotation front page up by 4 units to give space below the signature block (mip_quotation_document.pck). 
git-svn-id: http://locode01.ad.dom/svn/WEBMIP/trunk@25663 248e525c-4dfb-0310-94bc-949c084e9493
 2010-08-13 14:23:32 +00:00
andrew.hardy
78497b6b8f Modify mip_quotation_document and f155.sql to use new signature on 
documents.

git-svn-id: http://locode01.ad.dom/svn/WEBMIP/trunk@25576 248e525c-4dfb-0310-94bc-949c084e9493
 2010-08-10 16:45:56 +00:00
andrew.hardy
099645fa72 Added PRTY_MKTP_SHORTCODE_UK to constraint_messages (following support call showing error when user entered a duplicate market participant shortcode). 
git-svn-id: http://locode01.ad.dom/svn/WEBMIP/trunk@17082 248e525c-4dfb-0310-94bc-949c084e9493
 2010-04-13 15:26:43 +00:00
jamie.priest
bd2fb7941b bulkload changes for april 2010, includes the raw BULK_LOAD.xls provided by Ng metering finance team. The csv files are manipulated in order to get the correct data into the system. 
git-svn-id: http://locode01.ad.dom/svn/WEBMIP/trunk@16979 248e525c-4dfb-0310-94bc-949c084e9493
 2010-03-31 20:04:26 +00:00
jamie.priest
ca7c636d19 file added for the purpose of moving from 1.0.6 to 1.1.0, this is a copy of the caveat_texts from the UAT system. The contents were updated to read correctly during the UAT process and will be required for the 1.1.0 release. Normally we'd expect the data to appear in the bulkload sheet but this has not been possible. This script will be run once the system has been upgraded. 
git-svn-id: http://locode01.ad.dom/svn/WEBMIP/trunk@16908 248e525c-4dfb-0310-94bc-949c084e9493
 2010-03-25 17:23:48 +00:00
andrew.hardy
bd1afd4652 Modified InstallMIP.cmd to halt with error message if invalid data load requested. 
git-svn-id: http://locode01.ad.dom/svn/WEBMIP/trunk@16907 248e525c-4dfb-0310-94bc-949c084e9493
 2010-03-25 16:35:59 +00:00
andrew.hardy
a94562afc6 Modified the dateformat retrieved by the Java routine 'DirList' (MIP_DIRLIST.jsp). Previous version would generate an ORA-1850 when viewing files with a file modified time during the midnight hour. 
git-svn-id: http://locode01.ad.dom/svn/WEBMIP/trunk@16885 248e525c-4dfb-0310-94bc-949c084e9493
 2010-03-24 11:46:28 +00:00
jamie.priest
61118404a8 updated costs report screen (18) so that additional items now display the MEter type, Meter size, enquiry type and Service pressure. This will help the I&C team to manage the costs on purging a little easier. 
git-svn-id: http://locode01.ad.dom/svn/WEBMIP/trunk@15130 248e525c-4dfb-0310-94bc-949c084e9493
 2010-01-07 11:16:31 +00:00
jamie.priest
61bff865f8 set search quotes (page 14) so pagination is reset on branch. Also changed pagination type as the select list could have blown up on the live server 
git-svn-id: http://locode01.ad.dom/svn/WEBMIP/trunk@13638 248e525c-4dfb-0310-94bc-949c084e9493
 2009-11-23 12:19:24 +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
jamie.priest
651a1ab38c fix for the quote reports screen, it was only returning the first 10000 quotes. Have altered this so that it will return the first 1000000. 
git-svn-id: http://locode01.ad.dom/svn/WEBMIP/trunk@13298 248e525c-4dfb-0310-94bc-949c084e9493
 2009-11-05 10:43:30 +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
b9a3a321f9 Add Upgrade Scripts to convert release 1.0.6 to current version. 
git-svn-id: http://locode01.ad.dom/svn/WEBMIP/trunk@13046 248e525c-4dfb-0310-94bc-949c084e9493
 2009-10-12 12:05:47 +00:00
jamie.priest
f6ae239211 possible fix for ticket #564 
git-svn-id: http://locode01.ad.dom/svn/WEBMIP/trunk@12916 248e525c-4dfb-0310-94bc-949c084e9493
 2009-09-29 15:16:37 +00:00
jamie.priest
b025bea06e fix for ticket #563 (also first introduction of the test script) 
git-svn-id: http://locode01.ad.dom/svn/WEBMIP/trunk@12915 248e525c-4dfb-0310-94bc-949c084e9493
 2009-09-29 14:18:53 +00:00
jamie.priest
addad49af2 fix for ticket #562, commit also includes the jquery date picker that AH has added 
git-svn-id: http://locode01.ad.dom/svn/WEBMIP/trunk@12885 248e525c-4dfb-0310-94bc-949c084e9493
 2009-09-25 13:55:39 +00:00
jamie.priest
8bdf50dc19 Fix for ticket #556, for some reason the print atributes for the ADIT_CODE column were set to 0 width, I've changed this to 6 
git-svn-id: http://locode01.ad.dom/svn/WEBMIP/trunk@12704 248e525c-4dfb-0310-94bc-949c084e9493
 2009-09-15 14:35:16 +00:00