function default_Disp($field_value = "")
 {
     if (!$this->getRData('hidden')) {
         $dbc = $this->getDbCon();
         //$dbc = $GLOBALS['conx'];
         list($tablename, $fielduniqid, $fielddisplay, $defaultvalue, $query) = explode(":", $this->getRData('radiobutton'));
         $qFieldDisplay = new SqlQuery($dbc);
         $qFieldDisplay->query("select  {$fielduniqid}, {$fielddisplay} from {$tablename} where {$fielduniqid}='" . $field_value . "'");
         $avfielddisplay = $qFieldDisplay->fetchArray();
         $fval = "";
         for ($i = 1; $i < count($avfielddisplay); $i++) {
             $fval .= $avfielddisplay[$i] . " ";
         }
         // $fval=$vfielddisplay;
         $fval = substr($fval, 0, strlen($fval) - 2);
         $qFieldDisplay->free();
         $this->processed .= $this->no_PhpCode($fval);
     }
 }
Beispiel #2
0
 function default_Form($field_value = "")
 {
     if (!$this->getRData("hidden")) {
         //global $conx;
         //$query = new sqlQuery($conx);
         $tableName = "auditlog";
         $columnName = "application";
         $sql = "SHOW COLUMNS FROM {$tableName} LIKE '{$columnName}'";
         $query = new SqlQuery($this->getDbConn());
         $query->query($sql);
         $row = $query->fetchArray();
         $enum = explode("','", preg_replace("/(enum|set)\\('(.+?)'\\)/", "\\2", $row["Type"]));
         $fval = "<select name=\"fields[" . $this->getFieldName() . "]\">";
         for ($i = 0; $i < sizeof($applications); $i++) {
             $fval .= "<option value=\"" . $applications[$i] . "\">" . $applications[$i] . "</option>";
         }
         $fval .= "</select>";
         $this->processed .= $fval;
     }
 }
Beispiel #3
0
 /**
  * __call magic method to generate DataObject or load data in the object.
  *
  *  This is where the magic happened.
  *  
  *  Those magic methods display saved view, form or saved query as well a manage relations.
  *  ->get_name_of_saved_query will load and run an SQLfusion from the savedquery/ folder.
  *  ->view_name_of_a_serialized_report will load and display a view from the report/ folder.
  *  ->form_name_of_a_serialized_form will load and display a form from the form/ folder.
  *  Relation:
  *  ->GetChildNameOfChildDataObject ($BlogEntries->GetChildComments()) will return an instance of
  *  the child object with a dataset containing only the child entries of the current Object value.
  *  An example is at: http://radria.sqlfusion.com/documentation/core:by_example_php5#relations
  *  ->GetParent... works the same why but look on the Parent relation and will return one record. 
  *
  * @param method name of the method called
  * @param params array of parameters used on the method call.
  */
 public function __call($method, $params)
 {
     try {
         $this->setLog("\n DataObject __call for method:" . $method);
         if (method_exists($this, $method)) {
             return;
         }
         $method_found = false;
         // lets use the method as an ordering.
         if (ereg("^getChild(.*)\$", $method, $match)) {
             $this->setLog("\n DataObject __call for child:" . $match[1]);
             $tablename = strtolower($match[1]);
             $order_limit = $params[0];
             $class_name = $match[1];
             $this->setLog("\n DataObject:" . $tablename . " Doesn exist checking if the table exists");
             $q_tables = new sqlQuery($this->getDbCon());
             $q_tables->getTables();
             $table_found = false;
             if (class_exists($class_name)) {
                 $this->setLog("\n DataObject:" . $class_name . " exist instanciating it with child values");
                 $new_data_object = new $class_name($this->getDbCon());
                 if (strlen($new_data_object->getTable()) > 0) {
                     $tablename = $new_data_object->getTable();
                 }
                 $new_data_object->{$this->getPrimaryKey()} = $this->getPrimaryKeyValue();
                 $new_data_object->query("select * from " . $tablename . " where " . $this->getPrimaryKey() . "=" . $this->getPrimaryKeyValue() . " " . $order_limit);
                 $method_found = true;
                 return $new_data_object;
             } else {
                 $this->setLog("\n DataObject:" . $class_name . " Doesn't exist checking if the table " . $tablename . " exists");
                 while ($tables = $q_tables->fetchArray()) {
                     if ($tablename == $tables[0]) {
                         $table_found = true;
                     }
                 }
                 if ($table_found) {
                     $this->setLog("\nDataObject Table Found creating new data object:" . $tablename);
                     $new_data_object = new DataObject($this->getDbCon());
                     $new_data_object->setTable($tablename);
                     $new_data_object->setPrimaryKey("id" . $tablename);
                     $new_data_object->{$this->getPrimaryKey()} = $this->getData($this->getPrimaryKey());
                     $new_data_object->query("select * from " . $tablename . " where " . $this->getPrimaryKey() . "=" . $this->getData($this->getPrimaryKey()));
                     $method_found = true;
                     //$this->{$tablename} = $new_data_object;
                     return $new_data_object;
                 } else {
                     throw new RadriaException("Table:" . $tablename . " Not Found Could not create an Object");
                 }
             }
         }
         if (ereg("^getParent(.*)\$", $method, $match)) {
             $this->setLog("\n DataObject __call for parent:" . $match[1]);
             $tablename = strtolower($match[1]);
             if (class_exists($tablename) && is_subclass_of($tablename, "DataObject")) {
                 $this->setLog("\n DataObject class for" . $tablename . " exists will instanciate it");
                 $do = new $tablename($this->getDbCon());
                 //$do->query("select * from ".$tablename." where ".$do->getPrimaryKey()."=".$this->getData($do->getPrimaryKey()));
                 $do->getId($this->{$do->getPrimaryKey()});
                 $method_found = true;
                 return $do;
             } else {
                 $this->setLog("\n DataObject class for " . $tablename . " Doesn exist checking if the table exists");
                 $q_tables = new SqlQuery($this->getDbCon());
                 $q_tables->getTables();
                 $table_found = false;
                 while ($tables = $q_tables->fetchArray()) {
                     if ($tablename == $tables[0]) {
                         $table_found = true;
                     }
                 }
                 if ($table_found) {
                     $this->setLog("\n Creating new data object:" . $tablename);
                     $new_data_object = new DataObject($this->getDbCon());
                     $new_data_object->setTable($tablename);
                     $new_data_object->setPrimaryKey("id" . $tablename);
                     $new_data_object->query("select * from " . $tablename . " where " . $new_data_object->getPrimaryKey() . "=" . $this->getData($new_data_object->getPrimaryKey()));
                     $method_found = true;
                     //$this->{$tablename} = $new_data_object;
                     return $new_data_object;
                 } else {
                     throw new RadriaException("Table:" . $tablename . " Not Found");
                 }
             }
         }
         if (!$method_found) {
             //
             throw new RadriaException("Method:" . $method . " Not Found");
             die("Method:" . $method . " Not Found");
         }
         return false;
     } catch (RadriaException $e) {
         $this->setError("\n DataObject Exception: " . $e->getMessage());
         throw new RadriaException($e->getMessage() . " when calling method:" . $method);
     } catch (\Exception $e) {
         trigger_error("Method" . $method . " Not found", E_USER_ERROR);
     }
 }