custom/search.php

   1 <?php
   2 //// Copyright (C) 2009 Aron Racho <aron@mi-squared.com>
   3
   4 // This program is free software; you can redistribute it and/or
   5 // modify it under the terms of the GNU General Public License
   6 // as published by the Free Software Foundation; either version 2
   7 // of the License, or (at your option) any later version.
   8
   9
  10
  11 require_once("../interface/globals.php");
  12 ?>
  13 <html>
  14 <head>
  15   <link rel="stylesheet" href="<?php echo $css_header;?>" type="text/css">
  16 <style type="text/css">
  17  body {
  18   font-size:8pt;
  19   font-weight:normal;
  20   padding: 5px 3px 5px 3px;
  21   background: #94D6E7;
  22  }
  23 </style>
  24 <script language="javascript">
  25         function doSelectorButton() {
  26                 var selector = document.getElementById('selectorButton');
  27                 var value;
  28                 if ( selector.value == "<?php echo htmlspecialchars( xl('Select All'), ENT_QUOTES); ?>" ) {
  29                         selector.value = "<?php echo htmlspecialchars( xl('Unselect All'), ENT_QUOTES); ?>";
  30                         value = true;
  31                 } else {
  32                         selector.value = "<?php echo htmlspecialchars( xl('Select All'), ENT_QUOTES); ?>";
  33                         value = false;
  34                 }
  35                 var checkBoxes = document.getElementsByName( "searchFields" );
  36                 setAll( checkBoxes, value );
  37         }
  38
  39         function setAll(field, value) {
  40                 for (i = 0; i < field.length; i++) {
  41                         field[i].checked = value ;
  42                 }
  43         }
  44
  45         function doSubmit() {
  46                 // buildup fieldstring
  47                 var checkBoxes = document.getElementsByName( "searchFields" );
  48                 var fieldString = '';
  49     var ssc = document.forms[0].search_service_code.value;
  50                 for (i = 0; i < checkBoxes.length; i++) {
  51                         if ( checkBoxes[i].checked ) {
  52                                 if ( fieldString != '' ) {
  53                                         fieldString += "~";
  54                                 }
  55                                 fieldString += checkBoxes[i].value;
  56                         }
  57                 }
  58                 if ( opener != null ) {
  59                         if (fieldString == undefined || (fieldString == '' && ssc.length == '')) {
  60                                 alert("<?php echo htmlspecialchars( xl('You must select some fields to continue.'), ENT_QUOTES); ?>");
  61                                 return false;
  62                         }
  63                         opener.processFilter(fieldString, ssc);
  64                 }
  65         }
  66
  67 </script>
  68 </head>
  69
  70 <body>
  71 <form>
  72
  73         <table>
  74           <tr>
  75                 <td>
  76                   <b><?php echo htmlspecialchars(xl('Select Fields')); ?>:</b>
  77                 </td>
  78             <td>
  79                 <input type="button" value="<?php echo htmlspecialchars( xl('Submit'), ENT_QUOTES); ?>" id="submit" onclick="javascript:doSubmit();"></input>
  80             </td>
  81                 <td>
  82                 <input type="button" value="<?php echo htmlspecialchars( xl('Select All'), ENT_QUOTES); ?>" id="selectorButton" onclick="javascript:doSelectorButton();"></input>
  83                 </td>
  84           </tr>
  85         </table>
  86
  87         <?php
  88     function echoFilterItem($iter, $fieldId, $fieldTitle) {
  89                         if ($iter % 3 == 0) {
  90                                 if ( $iter > 0 ) {
  91                                         echo "</tr>\n";
  92                                 }
  93                                 echo "<tr>\n";
  94                         }
  95                         echo "<td>";
  96                         echo "<input type='checkbox' value='".htmlspecialchars( ${fieldId}, ENT_QUOTES)."' name='searchFields'/> <b>".htmlspecialchars( $fieldTitle, ENT_NOQUOTES)."</b>";
  97                         echo "</td>\n";
  98     }
  99
 100                 $layoutCols = sqlStatement( "SELECT field_id, title, description, group_name "
 101       . "FROM layout_options "
 102       . "WHERE form_id='DEM' "
 103       . "AND group_name not like ('%Employer%' ) AND uor != 0 "
 104       . "ORDER BY group_name,seq"
 105                 );
 106
 107                 echo "<table>";
 108
 109                 for($iter=0; $row=sqlFetchArray($layoutCols); $iter++) {
 110                         $label = $row['title'] ? $row['title'] : $row['description'];
 111                         if ( !$label ) {
 112                                 $label = $row['field_id'];
 113                         }
 114                         echoFilterItem(
 115                                 $iter,
 116                                 $row['field_id'],
 117                                 xl_layout_label($label)
 118                         );
 119                 }
 120     echoFilterItem($iter++, 'pid', xl('Internal Identifier (pid)'));
 121
 122                 // Finish the row gracefully.
 123                 while ($iter++ % 3) echo "<td>&nbsp;</td>\n";
 124                 echo "</tr>\n";
 125
 126                 // Write a final line to solicit an optional service code.
 127                 echo "<tr>\n";
 128                 echo "<td colspan='3'>";
 129                 echo "<input type='text' value='' name='search_service_code' size='8' /> " .
 130                         "<b>" . htmlspecialchars(xl('Service Code')) . "</b> (" .
 131                         htmlspecialchars(xl('if entered, select only those who have had this service')) . ")";
 132                 echo "</td>\n";
 133                 echo "</tr>\n";
 134
 135                 echo "</table>";
 136         ?>
 137
 138 </form>
 139 </body>
 140 </html>