10.6.24.23 OCSBA D-Base /Volumes/Server HD/Library/WebServer/Documents JDFSW5D6Yfk= JDFSW5D6Yfk= css,Error,ErrorPage,AuthenticationPage,LogoutPage,CGI,summary,IMG,navigation,Home,Confirmation,Add ErrorPage ErrorPage errorpage.php /Volumes/Server HD/Library/WebServer/Documents/Test navigation navigation navigation.php LogoutPage,Home,Find,List /Volumes/Server HD/Library/WebServer/Documents/Test css css glass_green.css /Volumes/Server HD/Library/WebServer/Documents/Test List Last name ascend 25 false BrowseRecord.Title Browse Record ErrorReply.PageBody.Comment Page Body PageTitle.Home Home PageTitle.AddRecord Add Page.Comment.Utility Include utility / error stylesheets Navigation.SummaryReportAllRecords Summary Report on All Records FindRecords.Description.Label2 Database Name DataType.number Number Utilities.Comment9 Link to the browse record page RecordList.php.comment9 perform the find Utilities.Comment8 Link to the add records page RecordList.php.comment8 set skip and max values DeleteReply.Description.Label2 Database Name Utilities.Comment7 Link to the summary report page showing the current list RecordList.ListNav.Comment Display record list page navigation controls RecordList.php.comment7 get the skip and max values Utilities.Comment6 Store the find request in the session RecordList.php.comment6 read and set, or clear the sort criteria Utilities.Comment5 Link to the records list page showing the current list RecordList.php.comment5 set the logical operator Utilities.Comment4 Link to the records list page showing all records RecordList.php.comment4 get the posted record data from the findrecords page Utilities.Comment3 Link to the find records page RecordList.php.comment3 create a find command Utilities.Comment2 Link to the home page RecordList.php.comment2 clear the recid Navigation.RecordList View Record List Utilities.Comment1 result information RecordList.php.comment1 handle the action cgi EditRecord.Description.Comment Page Description SummaryReport.PageBody.Label11 Grand Summary SummaryReport.PageBody.Label10 Group Summary RecordList.PageBody.Comment4 Display record field values RecordList.PageBody.Comment3 If no records in current list, display the "no records found" message RecordList.PageBody.Comment2 Display sortable field header row Button.EditRecord Edit Record Page.Body PAGE BODY DeleteReply.Description.Label Delete Reply DeleteRecord.PHP.Comment2 goto recordlist PageTitles.Confirmation Confirmation RecordList.PageBody.Label3 Restore Original Sort Order RecordList.PageBody.Label2 - no records found - Utilities.Comment14 Link to the records list page showing the current list sorted on a field Utilities.Comment13 Link to the records list page showing the current list at the last page of records Utilities.Comment12 Link to the records list page showing the current list at the next page of records Utilities.Comment11 Link to the records list page showing the current list at the previous page of records Utilities.Comment10 Link to the records list page showing the current list at the first page of records ErrorReply.Description.Label2 Database Name EditRecord.Description.Label Edit Record Navigation.AddRecord Add Record Error.Message2 Error: Error result is NULL! PageTitles.Delete Delete SummaryReport.PageBody.Comment Page Body DeleteRecord.PHP.Comment get the recid of the record to delete PageTitle.Delete Reply Delete FindRecords.PageBody.Comment Page Body Page.DisplayList Display Record List PageTitles.summary summary FormControl.Select.gte Greater Than or Equals Page.Comment formats for dates and times Authentication.LogIn Log In FormControl.Select.gt Greater Than BrowseRecord.PHP.NoRecordsPresent No Records are present. PageTitles.List Record List Home.Comment Page Description BrowseRecord.PHP.Comment10 clear the stored record data Page.Cancel Cancel PageTitles.navigation navigation Page.Comment.StoreFind Ensure that the stored-find variable is used Page.DisplaySummary Display Summary Report Navigation.SummaryReport Summary Report PageTitle.Strings template_strings_en.xml FindRecords.Description.Comment Page Description Button.Reset Reset SummaryReport.PageBody.Label9 Overall Count SummaryReport.PageBody.Label8 Overall Median SummaryReport.PageBody.Label7 Overall Average Page.SaveRecord Save Record SummaryReport.PageBody.Label6 Grand Total BrowseRecord.Description.Label2 Database Name SummaryReport.PageBody.Label5 - no records found - SummaryReport.PageBody.Label4 Group Count SummaryReport.PageBody.Label3 Group Median SummaryReport.PageBody.Label2 Group Average PageTitles.ErrorPage ErrorPage Change.SERVERDELETED Deleted on server EditRecord.PageBody.Comment5 Display record form controls EditRecord.PageBody.Comment4 Provide input controls to add a new relatedset row EditRecord.PageBody.Comment3 Provide input controls to edit each existing relatedset row Navigation.FindAll Find All EditRecord.PageBody.Comment2 Display record field values DataType.container Container FindRecords.Title Find Records PageTitle.Find Records Find Records PageTitles.CGI CGI SummaryReport.Description.Label2 Database Name FindRecords.PageBody.Label Find records if any fields match EditRecord.PageBody.Comment Page Body DataType.time Time BrowseRecord.PageBody.Comment3 Display record form controls BrowseRecord.PageBody.Comment2 Display record field values FormControl.Select.ew Ends With Button.DuplicateRecord Duplicate Record Change.INSYNC In sync with the server's copy FindRecords.Description.Label Find Records Button.Cancel Cancel Navigation.ShowAllRecords Show All Records Page.DisplayFormControls Display record form controls FormControl.Select.eq Equals PageTitles.Error Error DeleteReply.PageBody.Comment Page Body BrowseRecord.PHP.Comment create a new duplicate command Change.DATATYPECHANGE Data type has changed RecordList.php.comment11 get the records RecordList.php.comment10 get status info; page range, found count, total count, first, prev, next, and last links AddRecord.Title Add Record Page.Comment.Session Retrieve the stored find request from the session Home.Label Database Name: Button.SaveRecord Save Record ErrorReply.Description.Comment Page Description PageTitle.Browse Browse Navigation.Comment Navigation Menu SummaryReport.Comment Summary Report Information RecordList.ListNav.Label3 of RecordList.ListNav.Label2 Record Change.SERVERADDED Added on server Page.DisplayDelete Display Delete Reply Error.Message Error PageTitle.Utilities utilities.php ErrorReply.Navigation.Comment Navigation Menu PageTitles.IMG img PageTitles.Add Add Record PageTitles.Browse Browse Record Page.DisplayError Display Error Reply ErrorReply.Title Error Reply FormControl.Select.cn Contains PageTitle.Summary Report Summary Report RecordList.PageBody.Label Click a field label to sort by that column SummaryReport.PageBody.Comment15 Display overall median function result SummaryReport.PageBody.Comment14 Display overall average function result SummaryReport.PageBody.Comment13 Display grand total function result DeleteReply.PageBody.Label The record was deleted. BrowseRecord.Description.Comment Page Description SummaryReport.PageBody.Comment12 If no records in current list, display the "no records found" message SummaryReport.Description.Comment Page Description SummaryReport.PageBody.Comment11 Display summary grand function result SummaryReport.PageBody.Comment10 Display median function result Authentication.AccountName Account Name FormControl.Select.bw Begins With FormControl.Select.Empty Select One RecordList.Description.Comment Page Description RecordList.ListNav.Label Records PageTitles.Home Home AddRecord.Description.Comment Page Description PageTitles.LogoutPage Log Out Button.DeleteRecordConfirm return confirm('Really delete this record') FindRecords.PageBody.Label5 Records FindRecords.PageBody.Label4 Max Page.DisplayRecordValues Display record field values FindRecords.PageBody.Label3 Display FindRecords.PageBody.Label2 Find records if all fields match EditRecord.Description.Label2 Database Name Utilities.Label6 ascending Page.DisplayFind Display Find Records Utilities.Label5 descending Utilities.Label4 Last DataType.timestamp TimeStamp Utilities.Label3 Next Utilities.Label2 Prev BrowseRecord.PHP.Comment9 submit the data to the db BrowseRecord.PHP.Comment8 get the submitted record data BrowseRecord.PHP.Comment7 create the new add command BrowseRecord.PHP.Comment6 now get the record we just edited BrowseRecord.PHP.Comment5 get the posted record data from the edit page BrowseRecord.PHP.Comment4 create an edit command for the record specified by the '-recid' Page.DisplayEdit Display Edit Record BrowseRecord.PHP.Comment3 store the recid so we can display the duplicated record in the browse page AddRecord.Description.Label Add Record cgi.comment52 if the find request is for a field specified highlight the target BrowseRecord.PHP.Comment2 the result contains the record cgi.comment51 call the inherited version to get the data cgi.comment50 if there's a stored find request save a reference PageTitles.Find Find FormControl.Select.neq Not Equals Utilities.Comment query information SummaryReport.php.comment9 get the skip and max values SummaryReport.php.comment8 store the number of columns in this report table SummaryReport.php.comment7 read and set, or clear the sort criteria SummaryReport.php.comment6 set the logical operator SummaryReport.php.comment5 get the posted record data from the findrecords page SummaryReport.php.comment4 create a find command SummaryReport.php.comment3 clear the recid SummaryReport.php.comment2 handle the cgi CSS.Comment 3 major sections of page: Header, Container(body), and Footer PageTitles.Edit Edit SummaryReport.php.comment1 get the report attributes Home.Title Home Button.DeleteRecord Delete Record DeleteReply.Title Delete Reply cgi.comment49 This a wrapper for a FileMaker_Record that checks the find request and encloses any data matching the request in a span marked with the 'found' class. The css files define the look of found items. Utilities.Label First cgi.comment48 Formats field editor for add or edit pages. Records can be a single record, or an array of related records or null. cgi.comment47 No break; fall through to default! SummaryReport.PageBody.Label Group Total DeleteReply.Description.Comment Page Description cgi.comment46 Emit an editor appropriate for the specified field. cgi.comment45 Extract the field name, repetition number, and record id for a submitted field value cgi.comment44 Create a fieldEditRecord for the specified field, repetition, and record id. Store it in the fieldEditRecords array, store it in the session and return the index to be used to look up the original field, repetition, and record id during form submission. cgi.comment43 Return the source attribute value for a container field image cgi.comment42 Formats field data cgi.comment41 ignore empty values cgi.comment40 skip the operators, they are handled above Logout.Message You have successfully logged out. Page.DisplayAdd Display Add Record RecordList.Description.Label2 Database Name Page.Comment.StoreFindVariable Variable to store find request in the session Navigation.Home Home EditRecord.DuplicateRecord Duplicate Record Page.DisplayBrowse Display Browse Record cgi.comment39 now, go through and add the find criteria to the find command cgi.comment38 all the others precede the value cgi.comment37 contains surrounds the value with '*' cgi.comment36 begins with becomes the search value followed by wildcard cgi.comment35 prepend the value with the find operator retrieved from the operator map cgi.comment34 create the fieldname by stripping the operator cgi.comment33 look for operators cgi.comment32 go through the submitted data and convert to a form appropriate for fm php api cgi.comment31 map from cgi to fm php api format cgi.comment30 clear the sort criteria from the find command and the session AddRecord.PageBody.Comment3 Display record form controls AddRecord.PageBody.Comment2 Display record field values Authentication.Password Password Authentication.Title Authentication BrowseRecord.Description.Label Browse Record PageTitles.AuthenticationPage Log In RecordList.PageBody.Comment Page Body SummaryReport.Description.Label Summary Report Page.Comment.Layout Request layout XML grammar for value lists AddRecord.Description.Label2 Database Name FormControl.Select.lte Less Than or Equals Navigation.Edit Edit Record cgi.comment29 otherwise the order is a value list name SummaryReport.php.comment12 get the records cgi.comment28 add the sort criteria from the session to the find command SummaryReport.php.comment11 perform the find cgi.comment27 execute the command SummaryReport.php.comment10 set skip and max values cgi.comment26 related field names end with '.relatedRecID' cgi.comment25 creating a new related value PageTitle.Record List Record List cgi.comment24 handle related fields EditRecord.DeleteConfirm Permanently delete this ENTIRE record? cgi.comment23 lookup the field's edit record within the session Navigation.FindRecords Find Records cgi.comment22 convert time stamp from given date order to xml format for submission EditRecord.DeleteRecord Delete Record cgi.comment21 convert time to xml format for submission cgi.comment20 convert date from given format to xml format for submission PageTitles.Report Summary Report PageTitle.ErrorReply Error PageTitle.Edit Record Edit PageTitles.css css FindRecords.PageBody.Comment6 Form Controls FindRecords.PageBody.Comment5 Display search form controls FindRecords.PageBody.Comment4 Display search field input control DataType.text Text FindRecords.PageBody.Comment3 Display search field operator FindRecords.PageBody.Comment2 Display search field input controls FormControl.Select.lt Less Than EditRecord.Title Edit Record Navigation.Browse Browse Record cgi.comment19 display time stamp in given format cgi.comment18 display time in given format cgi.comment17 display date obtained in xml format in a given output format cgi.comment16 Parses a string containing a time and returns a Date object, or null if the string can't be parsed. cgi.comment15 xml format cgi.comment14 formatDate parses an input string containing a date and returns a Date object. dateString The string containing the unparsed date dateOrder A string describing the order of date elements; 'mdy', 'dmy', etc. delimiter A character delimiter to be used for parsing the input $dateString. returns null if the date can't be parsed. cgi.comment13 now flip the direction for the column header link cgi.comment12 if so, did it specify the sort order parameter? cgi.comment11 was the -sortfieldone query parameter set in the session? cgi.comment10 ascending is the default PageTitles.Duplicate Duplicate Page.Header HEADER RecordList.Description.Label Record List Button.FindRecords Find Records AddRecord.PageBody.Comment Page Body cgi.comment9 clear out recorddata if not an edit cgi.comment8 store edit or new request record data cgi.comment7 clear it for a findall ErrorReply.PageBody.Label An error occurred cgi.comment6 move the submitted data to the stored find request; an array, keys: field names, values: submitted query ErrorReply.Description.Label Error Reply cgi.comment5 always replace the existing find request cgi.comment4 get the field names cgi.comment3 If a key does not start with '-' then it is a field parameter. Capture the field value pairs in a record data array and store it in the session separately under the key 'storedfindrequest' when handling a '-find' request, or in the 'recorddata' key for '-edit' or '-new' cgi.comment2 the record data submitted cgi.comment1 Request parameters are saved in the session and accessed via the CGI. SummaryReport.PageBody.Comment9 Display average function result SummaryReport.PageBody.Comment8 Display total function result SummaryReport.PageBody.Comment7 Display summary function result for this group-by section SummaryReport.PageBody.Comment6 Static Text Version 1.0d1 DataType.date Date SummaryReport.PageBody.Comment5 Image SummaryReport.PageBody.Comment4 Display field values SummaryReport.PageBody.Comment3 Display records in the current group-by section SummaryReport.PageBody.Comment2 Display group-by section header row Page.Navigation Navigation Menu Home.Comment2 Page Body com/filemaker/phpsa/templates/template_strings_en.xml Date paid 00 date INSYNC false Date paid 00 Date paid 00 30 Amount paid 01 text false Amount paid 01 Amount paid 01 33 Amount paid 96 false Amount paid 96 Amount paid 96 25 Amount paid 06 false Amount paid 06 Amount paid 06 43 Amount paid 95 false Amount paid 95 Amount paid 95 24 Amount paid 02 false Amount paid 02 Amount paid 02 35 Date paid 93 false Date paid 93 Date paid 93 15 Amount paid 93 number false Amount paid 93 Amount paid 93 22 Plus two false Plus two Plus two 9 Date paid 96 false Date paid 96 Date paid 96 18 Amount paid 98 false Amount paid 98 Amount paid 98 27 Office phone false Office phone Office phone 5 Amount paid 92 false Amount paid 92 Amount paid 92 21 Date paid 95 false Date paid 95 Date paid 95 17 Plus four false Plus four Plus four 8 Mailing street address true Mailing street address Mailing street address 0 Date paid 03 false Date paid 03 Date paid 03 36 Date paid 98 false Date paid 98 Date paid 98 20 Last name true Last name Last name 13 Mailing PO box false Mailing PO box Mailing PO box 1 Amount paid 97 false Amount paid 97 Amount paid 97 26 First name true First name First name 12 Date paid 97 false Date paid 97 Date paid 97 19 Mailing state true Mailing state Mailing state 3 Amount paid 00 false Amount paid 00 Amount paid 00 31 Company true Company Company 10 Date paid 07 false Date paid 07 Date paid 07 44 Amount paid 04 false Amount paid 04 Amount paid 04 39 Date paid 08 false Date paid 08 Date paid 08 46 Mailing address 2 false Mailing address 2 Mailing address 2 7 e mail address true e mail address e mail address 11 Date paid 02 false Date paid 02 Date paid 02 34 membership number false membership number membership number 48 Amount paid 03 false Amount paid 03 Amount paid 03 37 Amount paid 08 false Amount paid 08 Amount paid 08 47 Date paid 99 false Date paid 99 Date paid 99 28 Date paid 05 false Date paid 05 Date paid 05 40 Amount paid 07 false Amount paid 07 Amount paid 07 45 Amount paid 99 false Amount paid 99 Amount paid 99 29 Date paid 04 false Date paid 04 Date paid 04 38 Date paid 94 false Date paid 94 Date paid 94 16 Mailing city true Mailing city Mailing city 2 Amount paid 05 false Amount paid 05 Amount paid 05 41 Amount paid 94 false Amount paid 94 Amount paid 94 23 Date paid 06 false Date paid 06 Date paid 06 42 Date paid 92 false Date paid 92 Date paid 92 14 Date paid 01 false Date paid 01 Date paid 01 32 Mailing zip true Mailing zip Mailing zip 4 Fax phone false Fax phone Fax phone 6 Input screen false true Record List recordlist.php /Volumes/Server HD/Library/WebServer/Documents/Test summary summary summary.php /Volumes/Server HD/Library/WebServer/Documents/Test Find recordlist.php Date paid 00 false Date paid 00 Date paid 00 30 Amount paid 01 false Amount paid 01 Amount paid 01 33 Amount paid 96 false Amount paid 96 Amount paid 96 25 Amount paid 06 false Amount paid 06 Amount paid 06 43 Amount paid 95 false Amount paid 95 Amount paid 95 24 Amount paid 02 false Amount paid 02 Amount paid 02 35 Date paid 93 false Date paid 93 Date paid 93 15 Amount paid 93 false Amount paid 93 Amount paid 93 22 Plus two false Plus two Plus two 9 Date paid 96 false Date paid 96 Date paid 96 18 Amount paid 98 false Amount paid 98 Amount paid 98 27 Office phone false Office phone Office phone 5 Amount paid 92 false Amount paid 92 Amount paid 92 21 Date paid 95 false Date paid 95 Date paid 95 17 Plus four false Plus four Plus four 8 Mailing street address false Mailing street address Mailing street address 0 Date paid 03 false Date paid 03 Date paid 03 36 Date paid 98 false Date paid 98 Date paid 98 20 Last name true Last name Last name 13 Mailing PO box false Mailing PO box Mailing PO box 1 Amount paid 97 false Amount paid 97 Amount paid 97 26 First name true First name First name 12 Date paid 97 false Date paid 97 Date paid 97 19 Mailing state false Mailing state Mailing state 3 Amount paid 00 false Amount paid 00 Amount paid 00 31 Company true Company Company 10 Date paid 07 false Date paid 07 Date paid 07 44 Amount paid 04 false Amount paid 04 Amount paid 04 39 Date paid 08 false Date paid 08 Date paid 08 46 Mailing address 2 false Mailing address 2 Mailing address 2 7 e mail address true e mail address e mail address 11 Date paid 02 false Date paid 02 Date paid 02 34 membership number false membership number membership number 48 Amount paid 03 false Amount paid 03 Amount paid 03 37 Amount paid 08 false Amount paid 08 Amount paid 08 47 Date paid 99 false Date paid 99 Date paid 99 28 Date paid 05 false Date paid 05 Date paid 05 40 Amount paid 07 false Amount paid 07 Amount paid 07 45 Amount paid 99 false Amount paid 99 Amount paid 99 29 Date paid 04 false Date paid 04 Date paid 04 38 Date paid 94 false Date paid 94 Date paid 94 16 Mailing city true Mailing city Mailing city 2 Amount paid 05 false Amount paid 05 Amount paid 05 41 Amount paid 94 false Amount paid 94 Amount paid 94 23 Date paid 06 false Date paid 06 Date paid 06 42 Date paid 92 false Date paid 92 Date paid 92 14 Date paid 01 false Date paid 01 Date paid 01 32 Mailing zip false Mailing zip Mailing zip 4 Fax phone false Fax phone Fax phone 6 Input screen false true Find findrecords.php /Volumes/Server HD/Library/WebServer/Documents/Test IMG img img.php /Volumes/Server HD/Library/WebServer/Documents/Test CGI CGI fmview.php /Volumes/Server HD/Library/WebServer/Documents/Test Error Error error.php /Volumes/Server HD/Library/WebServer/Documents/Test Home Home home.php Find,List /Volumes/Server HD/Library/WebServer/Documents/Test OCSBA D-Base true Test en_US SearchSite false OUTPUT_SETTINGS_PANEL false