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
PriestJ
09e9a673d5 added missing fax and telephone fields 
git-svn-id: http://locode01.ad.dom/svn/WEBMIP/trunk@3455 248e525c-4dfb-0310-94bc-949c084e9493
 2008-02-04 13:18:29 +00:00
hardya
c8bf407cc8 mip_bulk_load.pck: moved call to get_globals to reduce occasional 'parent not found' errors. 
git-svn-id: http://locode01.ad.dom/svn/WEBMIP/trunk@3454 248e525c-4dfb-0310-94bc-949c084e9493
 2008-02-04 11:31:51 +00:00
PriestJ
8c92041a07 tidied up data so that we don't have more than one role per user, also added some roles to cs and icu users for test purposes 
git-svn-id: http://locode01.ad.dom/svn/WEBMIP/trunk@3453 248e525c-4dfb-0310-94bc-949c084e9493
 2008-02-04 11:07:15 +00:00
hardya
6c4617b1c3 Bulk Load: Latest version of POSTCODES.csv. 
Data/Seed and Data/Test: Correction to apau.ctl to remove duplicates.

Modules/compile.sql: Correction to 'report' query.

Schema/ext...: Check whether external tables have been defined before attempting to drop them.

Schema/v_...: Force creation of views that rely on PL/SQL code. Explicitly name the column returned by V_QUOTE_DETAILS.vw so that the comments can be applied.



git-svn-id: http://locode01.ad.dom/svn/WEBMIP/trunk@3452 248e525c-4dfb-0310-94bc-949c084e9493
 2008-02-04 10:49:50 +00:00
PriestJ
5c190dc233 Initial set of enquiry tests, will need to test that enquiry can be saved, updated and that the request for quote, manual quote and upload file processes work also 
git-svn-id: http://locode01.ad.dom/svn/WEBMIP/trunk@3451 248e525c-4dfb-0310-94bc-949c084e9493
 2008-02-03 18:19:50 +00:00
PriestJ
4cb052039b fixed some display bugs on enquiry screen, altered menu to include create enquiry option and edit enquiry item 
git-svn-id: http://locode01.ad.dom/svn/WEBMIP/trunk@3450 248e525c-4dfb-0310-94bc-949c084e9493
 2008-02-03 18:13:04 +00:00
PriestJ
9dbb78b302 more access control descriptions added, added supplier admin roles, relationships and users 
git-svn-id: http://locode01.ad.dom/svn/WEBMIP/trunk@3449 248e525c-4dfb-0310-94bc-949c084e9493
 2008-02-03 18:10:37 +00:00
PriestJ
b46eecab21 added entry for supplier admin 
git-svn-id: http://locode01.ad.dom/svn/WEBMIP/trunk@3448 248e525c-4dfb-0310-94bc-949c084e9493
 2008-02-03 18:06:22 +00:00
PriestJ
92d4ebcb67 added function to test if a quotation document/file exists 
git-svn-id: http://locode01.ad.dom/svn/WEBMIP/trunk@3446 248e525c-4dfb-0310-94bc-949c084e9493
 2008-02-01 17:33:52 +00:00
PriestJ
ade5b1b425 added fixes and new code for manual quotation process 
git-svn-id: http://locode01.ad.dom/svn/WEBMIP/trunk@3445 248e525c-4dfb-0310-94bc-949c084e9493
 2008-02-01 17:28:28 +00:00
PriestJ
ce81ac1541 extra security added to manual quote button, only webMIPadmin and I&C can see it 
git-svn-id: http://locode01.ad.dom/svn/WEBMIP/trunk@3439 248e525c-4dfb-0310-94bc-949c084e9493
 2008-01-31 17:49:46 +00:00
PriestJ
71a83113e7 can now delete enquiries and system now warns you before deleting a file 
git-svn-id: http://locode01.ad.dom/svn/WEBMIP/trunk@3437 248e525c-4dfb-0310-94bc-949c084e9493
 2008-01-31 16:25:56 +00:00
PriestJ
6833abac25 added delete_enquiry function so that web mip admin and i&c can delete enquiries 
git-svn-id: http://locode01.ad.dom/svn/WEBMIP/trunk@3436 248e525c-4dfb-0310-94bc-949c084e9493
 2008-01-31 16:00:40 +00:00
PriestJ
e208461112 Added page to handle deletion of files, need to do some more testing in relation to security and who can do what. 
git-svn-id: http://locode01.ad.dom/svn/WEBMIP/trunk@3433 248e525c-4dfb-0310-94bc-949c084e9493
 2008-01-30 18:28:14 +00:00
PriestJ
05d0caac63 Added function to delete the file from the documents, document_roles tables and wwv_flow_files view. It accepts the document id (from the documents table) 
git-svn-id: http://locode01.ad.dom/svn/WEBMIP/trunk@3432 248e525c-4dfb-0310-94bc-949c084e9493
 2008-01-30 17:35:11 +00:00
PriestJ
f7bdbda3bd Fixed exchange PDF bug (too few parameters). Added code to report 2 different table 1's, one for LP jobs and one for MP jobs. Adjusted the layout of some of the pages so that the caveats will all fit on one page. 
git-svn-id: http://locode01.ad.dom/svn/WEBMIP/trunk@3428 248e525c-4dfb-0310-94bc-949c084e9493
 2008-01-30 12:06:46 +00:00
PriestJ
1d109ffdff made changes to pdf output inline with request from GW, awaiting confirmation on 2 further points that he raised so there will be further changes... 
git-svn-id: http://locode01.ad.dom/svn/WEBMIP/trunk@3421 248e525c-4dfb-0310-94bc-949c084e9493
 2008-01-29 18:19:51 +00:00
PriestJ
f9672916f0 ah made changes to build scripts to fix a few errors 
git-svn-id: http://locode01.ad.dom/svn/WEBMIP/trunk@3416 248e525c-4dfb-0310-94bc-949c084e9493
 2008-01-29 13:11:12 +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
PriestJ
34575be877 added fat build scripts for the FAT environment, it works!, I had to create a workspace to create the application in. Also had to manually copy the images and css to the application. 
git-svn-id: http://locode01.ad.dom/svn/WEBMIP/trunk@3406 248e525c-4dfb-0310-94bc-949c084e9493
 2008-01-28 18:33:23 +00:00
PriestJ
b60557ab63 Completed validations for the enquiry form. Altered the menu system so the login and change password screens do not hug the left of the window, added login menu item, added code to hide/display login and logout menu items dependant on whether the user is logged in or not 
git-svn-id: http://locode01.ad.dom/svn/WEBMIP/trunk@3405 248e525c-4dfb-0310-94bc-949c084e9493
 2008-01-28 17:54:24 +00:00
PriestJ
922822cc13 added start of the enquiry validation, still need to add some extra bits for some fields 
git-svn-id: http://locode01.ad.dom/svn/WEBMIP/trunk@3400 248e525c-4dfb-0310-94bc-949c084e9493
 2008-01-25 18:36:02 +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
PriestJ
67eda0b870 Enquiry screen:added some cosmetic changes, request for quote button now hidden when not required and passes the enquiry id to matts select-a-quote screen. Screen is now read-only when enquiry moves out of "in progress" 
git-svn-id: http://locode01.ad.dom/svn/WEBMIP/trunk@3372 248e525c-4dfb-0310-94bc-949c084e9493
 2008-01-23 16:53:45 +00:00
mullenm
445dd18fe3 added default user management URLs 
git-svn-id: http://locode01.ad.dom/svn/WEBMIP/trunk@3357 248e525c-4dfb-0310-94bc-949c084e9493
 2008-01-23 10:50:14 +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
PriestJ
374ba0aee9 added function to get enquiry status, intend to use it to make enquiry read only 
git-svn-id: http://locode01.ad.dom/svn/WEBMIP/trunk@3345 248e525c-4dfb-0310-94bc-949c084e9493
 2008-01-22 17:08:03 +00:00
PriestJ
d985e13a1d removed set_file_association function as this is now stored and called from the mip_files package 
git-svn-id: http://locode01.ad.dom/svn/WEBMIP/trunk@3335 248e525c-4dfb-0310-94bc-949c084e9493
 2008-01-22 13:36:54 +00:00
hardya
e3911c7920 Added missing ext_dataitem_role.pdc 
git-svn-id: http://locode01.ad.dom/svn/WEBMIP/trunk@3324 248e525c-4dfb-0310-94bc-949c084e9493
 2008-01-21 19:09:21 +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
PriestJ
4c1959004d Added request for quotation button and associated process, does not yet work.... 
git-svn-id: http://locode01.ad.dom/svn/WEBMIP/trunk@3320 248e525c-4dfb-0310-94bc-949c084e9493
 2008-01-21 17:06:46 +00:00
PriestJ
5e317a7809 altered enquiry screen in line with changes that AH had made, fixed LOV values that did not return the correct YES, NO return values and also the Load type LOV 
git-svn-id: http://locode01.ad.dom/svn/WEBMIP/trunk@3318 248e525c-4dfb-0310-94bc-949c084e9493
 2008-01-21 16:05:54 +00:00
hardya
acf28dc3b1 Alter references from mety_code to existing_mety_code in response to r3310 
git-svn-id: http://locode01.ad.dom/svn/WEBMIP/trunk@3317 248e525c-4dfb-0310-94bc-949c084e9493
 2008-01-21 16:01:06 +00:00
PriestJ
45bd2ad4b7 fixed bugs in tests, now tests that a file can be uploaded to the drawing 
git-svn-id: http://locode01.ad.dom/svn/WEBMIP/trunk@3316 248e525c-4dfb-0310-94bc-949c084e9493
 2008-01-21 16:00:24 +00:00
PriestJ
2ccdbf5dfd updated file upload screen so that the correct document role type is set. 
git-svn-id: http://locode01.ad.dom/svn/WEBMIP/trunk@3314 248e525c-4dfb-0310-94bc-949c084e9493
 2008-01-21 12:46:03 +00:00
PriestJ
620d7765b3 removed references to mip_dev_e schema, must have been copied from some test code, caused an error on the test instance of webmip, and would have on the live system 
git-svn-id: http://locode01.ad.dom/svn/WEBMIP/trunk@3313 248e525c-4dfb-0310-94bc-949c084e9493
 2008-01-21 12:29:04 +00:00
PriestJ
6bd8f2d96c Fixed bug in drawing_exists function it never returned a value if the drawing wasn't found, now returns false. Added null checks on the update association so that the where clause has a chance of working 
git-svn-id: http://locode01.ad.dom/svn/WEBMIP/trunk@3311 248e525c-4dfb-0310-94bc-949c084e9493
 2008-01-21 11:45:25 +00:00
hardya
564c5ef063 Schema Changes: 
Enquiries - renamed LOGGER_REQUIRED to EXISTING_LOGGER
Enquiries - renamed METY_CODE to EXISTING_METY_CODE

git-svn-id: http://locode01.ad.dom/svn/WEBMIP/trunk@3310 248e525c-4dfb-0310-94bc-949c084e9493
 2008-01-21 11:03:06 +00:00
PriestJ
999b0c5728 added some tests (that don't yet work) to drawingstests, sorted a few things out and merged the constants file 
git-svn-id: http://locode01.ad.dom/svn/WEBMIP/trunk@3309 248e525c-4dfb-0310-94bc-949c084e9493
 2008-01-18 17:44:24 +00:00
PriestJ
6eaba775e4 altered drawing screen to use the upload file screen to add images, matts fixed the enquiry screen and added some fixes to the manual quote stuff 
git-svn-id: http://locode01.ad.dom/svn/WEBMIP/trunk@3307 248e525c-4dfb-0310-94bc-949c084e9493
 2008-01-18 17:24:50 +00:00
PriestJ
9b51c05f4f merged my constants file with dash's 
git-svn-id: http://locode01.ad.dom/svn/WEBMIP/trunk@3306 248e525c-4dfb-0310-94bc-949c084e9493
 2008-01-18 16:22:00 +00:00
kanagad
e8e7f8c7a9 git-svn-id: http://locode01.ad.dom/svn/WEBMIP/trunk@3305 248e525c-4dfb-0310-94bc-949c084e9493 2008-01-18 16:17:50 +00:00
kanagad
e76615cb2e git-svn-id: http://locode01.ad.dom/svn/WEBMIP/trunk@3304 248e525c-4dfb-0310-94bc-949c084e9493 2008-01-18 16:13:27 +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
kanagad
40ebb2557f new tests 
git-svn-id: http://locode01.ad.dom/svn/WEBMIP/trunk@3302 248e525c-4dfb-0310-94bc-949c084e9493
 2008-01-18 15:41:17 +00:00
kanagad
52b5a4d40b now tests depth tooo 
git-svn-id: http://locode01.ad.dom/svn/WEBMIP/trunk@3301 248e525c-4dfb-0310-94bc-949c084e9493
 2008-01-18 15:40:07 +00:00
kanagad
3adfbc620f added a few extra constants 
git-svn-id: http://locode01.ad.dom/svn/WEBMIP/trunk@3300 248e525c-4dfb-0310-94bc-949c084e9493
 2008-01-18 15:38:52 +00:00