[Andro-hacker] [andro commit] r1365 - x6 interface: filling in an auto-complete field now causes any relevant Fetches to execut...

[<cod...@go...>]

Author: ke...@se...
Date: Wed May 27 12:12:22 2009
New Revision: 1365

Modified:
    trunk/andro/clib/x6.js
    trunk/andro/lib/index_hidden.php

Log:
x6 interface: filling in an auto-complete field now causes any relevant  
Fetches to execute and display as asynchronous JSON calls.

Fixes issue 14
status: Verified

Modified: trunk/andro/clib/x6.js
==============================================================================
--- trunk/andro/clib/x6.js	(original)
+++ trunk/andro/clib/x6.js	Wed May 27 12:12:22 2009
@@ -3572,6 +3572,13 @@
          x6inputs.setClass(inp);
          x6inputs.afterBlurner(inp);
          x6inputs.x6select.hide();
+        // KFD 5/27/09 Google #14 Must fetch
+        if($(inp).prop('xtableidpar','')!='') {
+        	x6.json.init('x6fetch',$(inp).attr('xtableid'));
+        	x6.json.addParm('x6col',$(inp).attr('xcolumnid'));
+        	x6.json.addParm('x6val',$(inp).val());
+        	x6.json.execute(true,true);
+        }
          x6.console.log("Input Blur DONE");
          x6.console.groupEnd();
          return true;

Modified: trunk/andro/lib/index_hidden.php
==============================================================================
--- trunk/andro/lib/index_hidden.php	(original)
+++ trunk/andro/lib/index_hidden.php	Wed May 27 12:12:22 2009
@@ -470,6 +470,7 @@
  // responsible for returning all headers, HTML or anything
  // else it wants to send back.
  if(    gp('ajxFETCH')   =='1') index_hidden_ajxFETCH();
+elseif(gp('x6fetch')     <>'') index_hidden_x6FETCH();
  elseif(gp('ajxfSELECT')  <>'') index_hidden_ajxfSELECT();
  elseif(gp('ajxc1table')  <>'') index_hidden_ajx1ctable();
  elseif(gp('gp_function') <>'') index_hidden_function();
@@ -1359,6 +1360,67 @@
     }
     echo implode('|-|',$returns);
  }
+
+# KFD 5/27/09
+# Google #14.  X6 must do FETCH operations when user navigates off
+#              autoselect columns.
+function index_hidden_x6FETCH() {
+   $returns=array();
+
+    # This is everything that *might* go back, make a place
+    # for all of it
+    $GLOBALS['AG']['x4'] = array(
+        'error'=>array()
+        ,'debug'=>array()
+        ,'notice'=>array()
+        ,'html'=>array()
+        ,'script'=>array()
+    );
+
+    // First fetch the values
+    $table_id  = gp('x6fetch');
+    $dd        = ddTable($table_id);
+    $column    = gp('x6col');
+    $colvalue  = gp('x6val');
+
+    # Look for fetch columns that pull from this column's
+    # table_id_fko
+    $tfko = $dd['flat'][$column]['table_id_fko'];
+    $cfko = $dd['flat'][$column]['column_id_fko'];
+    $cols = array();
+    foreach($dd['flat'] as $fcol=>$cdetails) {
+       $arr = array('FETCH','FETCHDEF','DISTRIBUTE');
+       if(in_array($cdetails['automation_id'],$arr)) {
+           if($cdetails['auto_table_id']==$tfko) {
+               $cols[$fcol] = $cdetails['auto_column_id'];
+           }
+       }
+    }
+
+    # We now have a list of source and destination
+    # columns, build the query
+    $sql="Select ".implode(',',$cols)
+       ." FROM $tfko WHERE $cfko = ".SQLFC($colvalue);
+    FB::Send($sql);
+    $row = SQL_OneRow($sql);
+    FB::Send($row);
+    foreach($cols as $fcol=>$srccol) {
+       $type = $dd['flat'][$fcol]['formshort'];
+       if($type=='date'){
+           x6html(
+                "x6inp_{$table_id}_$fcol"
+                ,date("Y-m-d",dEnsureTs($row[$srccol]))
+           );
+       }
+       else {
+           x6html("x6inp_{$table_id}_$fcol",$row[$srccol]);
+       }
+    }
+    echo json_encode_safe($GLOBALS['AG']['x4']);
+    exit;
+}
+
+

  // ------------------------------------------------------------------
  // >> Simple SQL Query, return SQL_Allrows array