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

208 Commits

Author SHA1 Message Date
PriestJ
0f58ad85e0 added code to set a watermark on the pdf if the file test_watermark.jpg exists in the application images, if it does not exist then no watermark will be shown 
git-svn-id: http://locode01.ad.dom/svn/WEBMIP/trunk@3293 248e525c-4dfb-0310-94bc-949c084e9493
 2008-01-17 18:23:32 +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
mullenm
f0adc3075d changed the procedure names and added the from field from the sys config table. 
git-svn-id: http://locode01.ad.dom/svn/WEBMIP/trunk@3286 248e525c-4dfb-0310-94bc-949c084e9493
 2008-01-17 13:58:37 +00:00
PriestJ
c436af2957 fixed code so that addons is not displayed on the pdf if there are none and made work items not display any unecessary blank lines, and made sure that existing meter details are shown for removal type jobs 
git-svn-id: http://locode01.ad.dom/svn/WEBMIP/trunk@3280 248e525c-4dfb-0310-94bc-949c084e9493
 2008-01-16 17:43:29 +00:00
PriestJ
a45d684c62 added routines to find existing files, and to update existing files 
git-svn-id: http://locode01.ad.dom/svn/WEBMIP/trunk@3279 248e525c-4dfb-0310-94bc-949c084e9493
 2008-01-16 17:41:37 +00:00
mullenm
25fd6ec5c3 added check that the returned role is NOT null if it is return FALSE. This was because it wasn't giving a no data found error as expected. 
git-svn-id: http://locode01.ad.dom/svn/WEBMIP/trunk@3259 248e525c-4dfb-0310-94bc-949c084e9493
 2008-01-16 14:31:11 +00:00
PriestJ
94c33c6342 added comments for set_file_association function 
git-svn-id: http://locode01.ad.dom/svn/WEBMIP/trunk@3257 248e525c-4dfb-0310-94bc-949c084e9493
 2008-01-16 11:48:00 +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
a5dbe5b167 is_tripartite function used to quickly determine if Market participant is a tripartite member or not. Used when determining things like whether AMR or certain types of jobs are available to users 
git-svn-id: http://locode01.ad.dom/svn/WEBMIP/trunk@3244 248e525c-4dfb-0310-94bc-949c084e9493
 2008-01-15 12:55:12 +00:00
mullenm
5e4fd6a160 added new get quote items function for use in the quote accept/reject views and pages. 
git-svn-id: http://locode01.ad.dom/svn/WEBMIP/trunk@3243 248e525c-4dfb-0310-94bc-949c084e9493
 2008-01-15 11:41:09 +00:00
PriestJ
c66351616c get enquiry role, forgot to commit 
git-svn-id: http://locode01.ad.dom/svn/WEBMIP/trunk@3242 248e525c-4dfb-0310-94bc-949c084e9493
 2008-01-15 11:24:00 +00:00
PriestJ
970f0e6b16 added code to get and display caveats 
git-svn-id: http://locode01.ad.dom/svn/WEBMIP/trunk@3225 248e525c-4dfb-0310-94bc-949c084e9493
 2008-01-14 14:18:41 +00:00
PriestJ
e96ef7e20d tried to get caveats in, having troubles so code is broken until monday sorry... 
git-svn-id: http://locode01.ad.dom/svn/WEBMIP/trunk@3208 248e525c-4dfb-0310-94bc-949c084e9493
 2008-01-11 18:55:01 +00:00
hardya
9e182d32cc BULK LOAD - added support drawings, bases and housings 
QUOTATION - moved costing of labour outside of main query, provide more details on failure to produce automatic quote.

git-svn-id: http://locode01.ad.dom/svn/WEBMIP/trunk@3206 248e525c-4dfb-0310-94bc-949c084e9493
 2008-01-11 17:26:52 +00:00
PriestJ
f3844defab Altered code to fix a couple of bugs, moved the base and housing details that are stored on the terms and conditions page out from the case statements they were in so that we always get the base and housing details, we needed this as the caveats with refer to them as minimum measurements for home made house and bases that customers might use 
git-svn-id: http://locode01.ad.dom/svn/WEBMIP/trunk@3200 248e525c-4dfb-0310-94bc-949c084e9493
 2008-01-10 18:33:07 +00:00
hardya
a3765e8f3c mip_quotation.pck - create quote entries for manual quotes. Automatic quotes call PDF build routine. Mark automatic quotes as available. 
mip_bulk_load.pck - initial work on bulk data load .

git-svn-id: http://locode01.ad.dom/svn/WEBMIP/trunk@3181 248e525c-4dfb-0310-94bc-949c084e9493
 2008-01-09 20:06:30 +00:00
PriestJ
177b3d818e now does drawings (requires more testing), hides drawings page if OFMAT or ADD-ON. More tidying up and bug fixing 
git-svn-id: http://locode01.ad.dom/svn/WEBMIP/trunk@3179 248e525c-4dfb-0310-94bc-949c084e9493
 2008-01-09 16:52:54 +00:00
PriestJ
4c10f2ae7b new function in mip_files to set the file association for drawings/enquiries and quotes. Fixed a few more bugs in the quote pdf builder, and have made a short start on getting the module drawings into the quote. 
git-svn-id: http://locode01.ad.dom/svn/WEBMIP/trunk@3175 248e525c-4dfb-0310-94bc-949c084e9493
 2008-01-08 18:43:53 +00:00
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
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
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
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
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
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
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
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
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
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
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
mullenm
e143372f17 added functionality to add party roles and relationships 
git-svn-id: http://locode01.ad.dom/svn/WEBMIP/trunk@2974 248e525c-4dfb-0310-94bc-949c084e9493
 2007-12-12 12:00:54 +00:00
mullenm
9cb6d4539e New procedures created for the user management screens. 
git-svn-id: http://locode01.ad.dom/svn/WEBMIP/trunk@2973 248e525c-4dfb-0310-94bc-949c084e9493
 2007-12-11 18:46:49 +00:00
PriestJ
e0a5a6bfc8 the export csv_routine was incorrectly referring to Y instead of Yes, on the question of whether column headings should be included in the csv file 
git-svn-id: http://locode01.ad.dom/svn/WEBMIP/trunk@2937 248e525c-4dfb-0310-94bc-949c084e9493
 2007-12-04 14:38:29 +00:00
mullenm
5ee8961d58 Updated to allow proper user status login checking. 
git-svn-id: http://locode01.ad.dom/svn/WEBMIP/trunk@2906 248e525c-4dfb-0310-94bc-949c084e9493
 2007-11-29 11:33:48 +00:00
mullenm
ab9471a85f added Jamie's block back in after merge ignored it. honest. 
git-svn-id: http://locode01.ad.dom/svn/WEBMIP/trunk@2905 248e525c-4dfb-0310-94bc-949c084e9493
 2007-11-29 11:31:55 +00:00
mullenm
030c682c3a Updated login to check user account status. 
Merged changes with Jamie's changes from earlier this week.

git-svn-id: http://locode01.ad.dom/svn/WEBMIP/trunk@2904 248e525c-4dfb-0310-94bc-949c084e9493
 2007-11-29 10:58:31 +00:00
hardya
1649327e45 Missing l_rec in code generated by gen_mandatory.prc for MIP_HELPER. 
Ensure that MIP_HELPER is generated prior to reference.

git-svn-id: http://locode01.ad.dom/svn/WEBMIP/trunk@2896 248e525c-4dfb-0310-94bc-949c084e9493
 2007-11-28 10:29:27 +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
PriestJ
4ab118215c general update?! 
git-svn-id: http://locode01.ad.dom/svn/WEBMIP/trunk@2891 248e525c-4dfb-0310-94bc-949c084e9493
 2007-11-27 11:52:30 +00:00
hardya
2920f4d016 Scheme Changes: 
Replaced Access_Controls with APEX_AUTHORISATION
Created POSTCODES, ERROR_LOGS and SYSTEM_CONFIGURATION.
Added missing columns to ENQUIRIES, REGULATORS, etc.
Added views V_PROFILE_RT_CODE_FOR_ENRO.vw, V_PARTY_RELATIONSHIPS.vw, V_LATEST_RT_CODE_FOR_ENRO.vw.

Modules:

Added cout_err.pck, cout_system_configuration.pck.

Data:

Added Data/Demo files
Added Data/Seed files for postcodes, regions and DatabaseItemToFunctionalSpecificationReference.csv

Documentation:

Added Documentation/pldoc for plsqldoc-generated files.
Added Documentation/SupportingDocumentation/Regions to hold region definition information.

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