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
hardya
c9c4299917 mip_bulk_load.pck - initial stage of producing bulk load routines. 
mip_quotation.pck - move bases and housings from main 'install' query to allow a more comprehensive 'reasoning' to be produced. Removed references to 'logger' for 'install'. Added 'lifting gear' to all 'install' quotations.

git-svn-id: http://locode01.ad.dom/svn/WEBMIP/trunk@3173 248e525c-4dfb-0310-94bc-949c084e9493
 2008-01-08 18:20:27 +00:00
hardya
f3c3bb281f Add external table definitions to support bulk loading. 
git-svn-id: http://locode01.ad.dom/svn/WEBMIP/trunk@3172 248e525c-4dfb-0310-94bc-949c084e9493
 2008-01-08 18:15:32 +00:00
PriestJ
cec492e431 added drawings screen to menu system, also pointed menu to DK's screens as they were more up-to-date than AH's 
git-svn-id: http://locode01.ad.dom/svn/WEBMIP/trunk@3168 248e525c-4dfb-0310-94bc-949c084e9493
 2008-01-08 15:57:20 +00:00
mullenm
4c0506eeb1 Latest export after some bug fixes on the user management screens. 
git-svn-id: http://locode01.ad.dom/svn/WEBMIP/trunk@3167 248e525c-4dfb-0310-94bc-949c084e9493
 2008-01-08 15:53:01 +00:00
mullenm
954d42e856 added new procedure to remove parties and associated records from the DB. 
git-svn-id: http://locode01.ad.dom/svn/WEBMIP/trunk@3165 248e525c-4dfb-0310-94bc-949c084e9493
 2008-01-08 15:51:07 +00:00
PriestJ
830c016090 added the ngmlogo and dh's signature, so that they can be used for the pdf quote generation 
git-svn-id: http://locode01.ad.dom/svn/WEBMIP/trunk@3152 248e525c-4dfb-0310-94bc-949c084e9493
 2008-01-07 18:09:02 +00:00
PriestJ
ac7fe30db1 fixed a bug on the data collection for the quotation, was not correctly gathering the delivery costs, also added labour costs. Pointed the generate_detailed_pdf_quote to store the pdf in the APEX_APPLICATION_FILES table, also added code to place the ngm logo and DH's signature to the pages. 
git-svn-id: http://locode01.ad.dom/svn/WEBMIP/trunk@3151 248e525c-4dfb-0310-94bc-949c084e9493
 2008-01-07 18:06:19 +00:00
hardya
daeef4b148 Modified mip_quotation.pck to generate labour quote items for installations. 
git-svn-id: http://locode01.ad.dom/svn/WEBMIP/trunk@3150 248e525c-4dfb-0310-94bc-949c084e9493
 2008-01-07 17:29:43 +00:00
hardya
01b5b4c979 Add V_LACO.vw - shows labour costs 
git-svn-id: http://locode01.ad.dom/svn/WEBMIP/trunk@3149 248e525c-4dfb-0310-94bc-949c084e9493
 2008-01-07 17:29:06 +00:00
mullenm
046f922e96 git-svn-id: http://locode01.ad.dom/svn/WEBMIP/trunk@3148 248e525c-4dfb-0310-94bc-949c084e9493 2008-01-07 17:05:09 +00:00
mullenm
ec8d9344a2 made a correction to the create_party proc 
git-svn-id: http://locode01.ad.dom/svn/WEBMIP/trunk@3147 248e525c-4dfb-0310-94bc-949c084e9493
 2008-01-07 17:05:01 +00:00
PriestJ
b24ea59d33 one of the pages was still commented out! 
git-svn-id: http://locode01.ad.dom/svn/WEBMIP/trunk@3129 248e525c-4dfb-0310-94bc-949c084e9493
 2008-01-04 14:06:24 +00:00
PriestJ
fa6de4187d finished off a bit more of quotation pdf, tidied up a few bits. Moved each page inside individual procedures to make things a bit tidier. Now need to figure out how to get it into the APEX files table. 
git-svn-id: http://locode01.ad.dom/svn/WEBMIP/trunk@3128 248e525c-4dfb-0310-94bc-949c084e9493
 2008-01-04 14:03:05 +00:00
PriestJ
a117f49d54 added another couple of pages top the pdf a few things still need sorting on it, need to talk to AH about the quote_items table and if he is going to populate all the table columns with data 
git-svn-id: http://locode01.ad.dom/svn/WEBMIP/trunk@3121 248e525c-4dfb-0310-94bc-949c084e9493
 2008-01-03 18:42:35 +00:00
PriestJ
53df2a260d made some minor changes, initialized varrays so that the quote_data record could collect data. Also made some changes to the main data collection routine as AH's quote_items table doesn't get populated with some of the stuff it expects (now getting this data from the enquiry table). Started on the build_detailed_pdf function it will now build the first 2 and a half pages of the quotation as a pdf in the testpdf table 
git-svn-id: http://locode01.ad.dom/svn/WEBMIP/trunk@3112 248e525c-4dfb-0310-94bc-949c084e9493
 2008-01-02 18:35:58 +00:00
PriestJ
e80c00df53 now gathers all information for the quotation, but have not tested this. Currently has a collection error on one of my varray types. 
git-svn-id: http://locode01.ad.dom/svn/WEBMIP/trunk@3062 248e525c-4dfb-0310-94bc-949c084e9493
 2007-12-21 18:29:30 +00:00
hardya
d20518e58a Changed quote_items to have primary key on column 'id'. Sequence quit_seq added to service this PK. 
git-svn-id: http://locode01.ad.dom/svn/WEBMIP/trunk@3061 248e525c-4dfb-0310-94bc-949c084e9493
 2007-12-21 17:35:45 +00:00
hardya
d79dcfa1fe Updated mip_regions.pck to include a reference to the source information. 
mip_quotation.pck now able to produce 'module' part of install quotes - missing labour costs.
gen_mandatory.prc modified to pass more of the 'condition' information into the application.

git-svn-id: http://locode01.ad.dom/svn/WEBMIP/trunk@3060 248e525c-4dfb-0310-94bc-949c084e9493
 2007-12-21 17:34:08 +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
mullenm
a02f736963 a few corrections and updates to the party management screens. 
git-svn-id: http://locode01.ad.dom/svn/WEBMIP/trunk@3058 248e525c-4dfb-0310-94bc-949c084e9493
 2007-12-21 16:45:53 +00:00
hardya
0bde1c86c3 Schema changes 
New Tables:
Quote_reasoning - record internal processes against quote
additional_items - moved from within Costs

Changed Tables:
Costs
Quote_items
Bases
Housings
Quotes
Meters
Modules

Views: As listed against this revision.

git-svn-id: http://locode01.ad.dom/svn/WEBMIP/trunk@3057 248e525c-4dfb-0310-94bc-949c084e9493
 2007-12-21 11:29:21 +00:00
PriestJ
848bbd606d added code to get most of the data for the pdf of the quotation, still need to get the tech spec details (detailed dimensions for housing, base and module), not yet tested so use at your peril... 
git-svn-id: http://locode01.ad.dom/svn/WEBMIP/trunk@3056 248e525c-4dfb-0310-94bc-949c084e9493
 2007-12-20 18:28:19 +00:00
hardya
1ccc4ed207 Include not-null values into insert statement of error_logs table. 
git-svn-id: http://locode01.ad.dom/svn/WEBMIP/trunk@3055 248e525c-4dfb-0310-94bc-949c084e9493
 2007-12-20 17:31:01 +00:00
hardya
0ba568bf1b Correction to reformat_post_code for 'AN NAA' format. 
git-svn-id: http://locode01.ad.dom/svn/WEBMIP/trunk@3054 248e525c-4dfb-0310-94bc-949c084e9493
 2007-12-20 17:30:18 +00:00
hardya
7926c9cbd7 Record 'reasoning' process in the quote_reasoning table! 
git-svn-id: http://locode01.ad.dom/svn/WEBMIP/trunk@3053 248e525c-4dfb-0310-94bc-949c084e9493
 2007-12-20 17:29:10 +00:00
mullenm
e3f9c1e5ff corrected issue with displaying party phone numbers. 
git-svn-id: http://locode01.ad.dom/svn/WEBMIP/trunk@3052 248e525c-4dfb-0310-94bc-949c084e9493
 2007-12-20 16:55:14 +00:00
PriestJ
55e08233b3 added method to navigate menu easily 
git-svn-id: http://locode01.ad.dom/svn/WEBMIP/trunk@3039 248e525c-4dfb-0310-94bc-949c084e9493
 2007-12-20 11:05:25 +00:00
mullenm
2d7b5e2ab9 added the new package to the list to be installed. 
git-svn-id: http://locode01.ad.dom/svn/WEBMIP/trunk@3037 248e525c-4dfb-0310-94bc-949c084e9493
 2007-12-20 10:39:03 +00:00
mullenm
115ca7d6b5 added a few new bits and updated create/edit parties to allow new addresses and contact details along with tripartite bits to be stored correctly. 
git-svn-id: http://locode01.ad.dom/svn/WEBMIP/trunk@3036 248e525c-4dfb-0310-94bc-949c084e9493
 2007-12-20 10:32:01 +00:00
mullenm
51c1b09c83 updated the user management screens. 
now includes tripartite fields and other good stuff.

git-svn-id: http://locode01.ad.dom/svn/WEBMIP/trunk@3035 248e525c-4dfb-0310-94bc-949c084e9493
 2007-12-20 10:31:17 +00:00
PriestJ
3c160be40f drawn up a diagram of the request for quotation process as GW and Advantica see it as of today 
git-svn-id: http://locode01.ad.dom/svn/WEBMIP/trunk@3034 248e525c-4dfb-0310-94bc-949c084e9493
 2007-12-19 17:58:33 +00:00
mullenm
5d03fac7f4 git-svn-id: http://locode01.ad.dom/svn/WEBMIP/trunk@3030 248e525c-4dfb-0310-94bc-949c084e9493 2007-12-19 17:08:09 +00:00
mullenm
843d4688c4 new view - v_current_contact_mechanisms 
git-svn-id: http://locode01.ad.dom/svn/WEBMIP/trunk@3029 248e525c-4dfb-0310-94bc-949c084e9493
 2007-12-19 17:02:57 +00:00
mullenm
c61c6dd6b6 get stored party contact details 
git-svn-id: http://locode01.ad.dom/svn/WEBMIP/trunk@3023 248e525c-4dfb-0310-94bc-949c084e9493
 2007-12-19 11:27:41 +00:00
mullenm
c3ef18948b Created new view to display the current address for each party in the system. 
git-svn-id: http://locode01.ad.dom/svn/WEBMIP/trunk@3022 248e525c-4dfb-0310-94bc-949c084e9493
 2007-12-18 17:30:02 +00:00
mullenm
b03c49fb3b Created new view to display the current address for each party in the system. 
git-svn-id: http://locode01.ad.dom/svn/WEBMIP/trunk@3020 248e525c-4dfb-0310-94bc-949c084e9493
 2007-12-18 17:27:54 +00:00
hardya
d353843a77 Modify gen_mandatory.prc to only process non-null field-names. 
Modify mip_regions.pck to expose get_region_for_postcode.

Check-in ongoing work with mip_quotation.pck.

git-svn-id: http://locode01.ad.dom/svn/WEBMIP/trunk@3018 248e525c-4dfb-0310-94bc-949c084e9493
 2007-12-18 17:16:07 +00:00
hardya
2e88e639ca Add views of COSTS table, include effectivity details. 
git-svn-id: http://locode01.ad.dom/svn/WEBMIP/trunk@3017 248e525c-4dfb-0310-94bc-949c084e9493
 2007-12-18 17:13:38 +00:00
PriestJ
c71e701c68 we only need the id of the party in the party_addresses view, not the names username etc. 
git-svn-id: http://locode01.ad.dom/svn/WEBMIP/trunk@3012 248e525c-4dfb-0310-94bc-949c084e9493
 2007-12-18 15:30:14 +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
ed275a4a8a Amended site_file_assocations to point at new DOCUMENTS and DOCUMENT_ROLES tables. 
git-svn-id: http://locode01.ad.dom/svn/WEBMIP/trunk@3008 248e525c-4dfb-0310-94bc-949c084e9493
 2007-12-17 10:15:56 +00:00
hardya
bb77d61785 Added support for Tripartite agreement: 
Table REGI_ENQU_EXCLUSIONS to intersect Region, Enquiry Type and (optionally) Additional Item - used to record all the things that a Non-Tripartite cannot do.
Table PARTIES has column TRIPARTITE_MEMBER (YES/NO) added for use of Market Participant.

Removed EXISTING_SVCP_CODE from ENQUIRIES table - not required.


git-svn-id: http://locode01.ad.dom/svn/WEBMIP/trunk@3005 248e525c-4dfb-0310-94bc-949c084e9493
 2007-12-14 15:15:30 +00:00
mullenm
66af74e120 changed the way the user status is updated on login to correct a "no data found" error. 
git-svn-id: http://locode01.ad.dom/svn/WEBMIP/trunk@3004 248e525c-4dfb-0310-94bc-949c084e9493
 2007-12-14 14:05:05 +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
mullenm
ea698b0d8a corrected an error with the login page when an incorrect password was given. 
git-svn-id: http://locode01.ad.dom/svn/WEBMIP/trunk@2988 248e525c-4dfb-0310-94bc-949c084e9493
 2007-12-14 11:40:22 +00:00
mullenm
e227875010 added "password" field type finder 
git-svn-id: http://locode01.ad.dom/svn/WEBMIP/trunk@2987 248e525c-4dfb-0310-94bc-949c084e9493
 2007-12-14 09:54:32 +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