Laserfiche WebLink
<br />Ol~" ,) ')3 <br />"ll ~ J <br /> <br />Retrieving a Water <br />Information Sheet <br /> <br />Overlay management <br />OMI routines <br /> <br />33 <br /> <br />The Water Information Sheet is created dynamically as the user requests to edit it <br />though the Edit/Water Information Sheet menu item. SPWRMS reads a format for <br />the selected water district and creates the new Water Information Sheet based on the <br />contents of that file. The application then searches the database for a saved sheet for <br />that district on that date. If a saved sheet is found, it is retrieved. Otherwise the appli- <br />cation reads the most recently saved sheet for that district. <br /> <br />When the user chooses a Water Information Sheet to edit, the application creates a <br />new sheet and initializes it with values. This section discusses the process of creating <br />and loading the Water Information Sheet. <br /> <br />SPWRMS uses the end_da te of the Preferences dialog to determine the day in <br />which to load the Water Information Sheet. If the user has selected a time interval of <br />some number of hours up to the present, the current day.s sheet is loaded. Otherwise, <br />the sheet for the day corresponding to the end_date of the time interval is loaded. The <br />function LoadlnfoSheet (int wd, char * date) returns the newly- <br />created sheet. <br /> <br />LoadlnfoSheet () first calls Crea telnfoSheet () which reads the appro- <br />priate format file and initializes the structures which comprise the Water Information <br />Sheet. The result is a set of data structures that have the appropriate number of rows, <br />each of the correct type and with proper writability, but which lack any data values. <br /> <br />LoadlnfoSheet () then checks to see if the requested sheet is saved in the data- <br />base. If it is not and an overlay sheet has been submitted for this day, the overlay is <br />loaded by a call to LoadOverlay () . Rows loaded by this function are flagged (as <br />is the sheet itself). Next, a search is performed to find the most recently-saved sheet <br />for that district. After determining the appropriate date, the values are retrieved from <br />the database. If values are read in for a previous day, the new flag is set to I, and the <br />user in notified of this action via a message on the sheet. The most recent sheet is used <br />to populate all rows not provided by the overlay. <br /> <br />Several DMI routines are used to do the data retrieval. SQLLoadWisHeader ( ) <br />gets data associated with the whole sheet, thus filling in the info_sheet_ <br />header_rec struct. SQLLoadWisRow () is then called to load data for the rows <br />in the sheet. This function is called once for each row of type struct, ftowgage, or <br />spotcheck. Other row types do not have associated values saved in the database, and <br />the contents are filled in by calculations (e.g., as for rows of type subtotal, total, and <br />formula) or left empty (e.g., as for rows of type string). Loading the rows completes <br />the Water Information Sheet data, which can then be displayed. <br /> <br />Overlay management is primarily performed by the three DMI functions, <br />LoadOverlay(),SavelnfoSheetOverlay() andLoadlnfoSheet- <br />ForOverlay() . <br /> <br />The function LoadOverlay (info_sheet_header_rec * sheet, <br />char * date) loads the overlay into the information sheet passed for the speci- <br />fied date. This function works by calling the DMI routines SQLLoadWis- <br />Header (). SQLLoadWisRow(), LoadDiversionList (), and <br />LoadExchangeList () specifying the use of the Overlay tables. The flags, <br />from_overlay are set for the rows loaded. <br /> <br />The function SavelnfoSheetOverlay ( ) saves the provided overlay (a Water <br />Information Sheet with overlay_mark flags set to I) to the database. First any previ- <br />