Example #1
0
 function handle(&$params)
 {
     $app =& Dataface_Application::getInstance();
     import('Dataface/XMLTool.php');
     $xt = new Dataface_XMLTool();
     echo $xt->header();
     echo $xt->getInfo();
     echo $xt->footer();
     exit;
 }
Example #2
0
 function handle(&$params)
 {
     import('Dataface/XMLTool.php');
     $xml = new Dataface_XMLTool();
     $app =& Dataface_Application::getInstance();
     $query =& $app->getQuery();
     $table =& Dataface_Table::loadTable($query['-table']);
     echo $xml->header();
     $auth =& Dataface_AuthenticationTool::getInstance();
     echo "<![CDATA[";
     print_r($_SESSION);
     echo "]]>";
     echo "<user>" . $auth->getLoggedInUsername() . "</user>";
     echo $xml->toXML($table);
     //echo $xml->toXML($app->getRecord());
     echo $xml->toXML($app->getResultSet());
     echo $xml->footer();
     exit;
 }
Example #3
0
 function handle(&$params)
 {
     $app =& Dataface_Application::getInstance();
     $query =& $app->getQuery();
     $mt =& Dataface_ModuleTool::getInstance();
     $mod =& $mt->loadModule('modules_DataGrid');
     if (PEAR::isError($mod)) {
         return $mod;
     }
     $dataGrid = $mod->getDataGrid($query['-gridid']);
     if (!$dataGrid) {
         return PEAR::raiseError("Error, the specified data grid could not be found");
     }
     import('Dataface/XMLTool.php');
     $xmlTool = new Dataface_XMLTool();
     $records = df_get_records_array($query['-table'], $query, null, null, false);
     $rows = array();
     $fieldDefs = $dataGrid->getFieldDefs();
     foreach ($records as $record) {
         $row = array();
         $row['__recordID__'] = $record->getId();
         foreach ($fieldDefs as $colName => $fieldDef) {
             if (strpos($colName, '#') === false) {
                 // No index was provided so index is 0
                 $index = 0;
                 $fieldName = $colName;
             } else {
                 list($fieldName, $index) = explode('#', $colName);
             }
             $row[str_replace('.', '-', $colName)] = $xmlTool->xmlentities($record->strval($fieldName, $index));
         }
         $rows[] = $row;
         unset($record);
     }
     if (@$_GET['--format'] == 'csv') {
         import('actions/export_csv.php');
         $temp = tmpfile();
         $headings = array();
         if ($rows) {
             foreach ($fieldDefs as $key => $val) {
                 $headings[] = $val['widget']['label'];
             }
         }
         fputcsv($temp, $headings, ",", '"');
         foreach ($rows as $row) {
             $thisrow = array();
             foreach ($row as $key => $val) {
                 if ($key != '__recordID__') {
                     $thisrow[] = $val;
                 }
             }
             fputcsv($temp, $thisrow, ",", '"');
         }
         fseek($temp, 0);
         header("Content-type: text/csv; charset=" . $app->_conf['oe']);
         header('Content-disposition: attachment; filename="' . $query['-table'] . '_' . $dataGrid->name . '_export_' . date('Y_m_d_H_i_s') . '.csv"');
         $fstats = fstat($temp);
         echo fread($temp, $fstats['size']);
         fclose($temp);
     } else {
         header("Content-type: application/xml; charset=" . $app->_conf['oe']);
         df_register_skin('DataGrid', DATAFACE_PATH . '/modules/DataGrid/templates');
         df_display(array('rows' => &$rows), 'DataGrid/datastore.xml');
     }
     exit;
 }
Example #4
0
 function buildRow($recordID)
 {
     import('Dataface/XMLTool.php');
     $xmlTool = new Dataface_XMLTool();
     if (is_a($recordID, 'Dataface_Record')) {
         $record =& $recordID;
     } else {
         $record =& df_get_record_by_id($recordID);
     }
     if (PEAR::isError($record)) {
         return $record;
     }
     $row = array();
     $row['__recordID__'] = $record->getId();
     foreach ($this->getFieldDefs() as $colName => $fieldDef) {
         if (strpos($colName, '#') === false) {
             // No index was provided so index is 0
             $index = 0;
             $fieldName = $colName;
         } else {
             list($fieldName, $index) = explode('#', $colName);
         }
         $row[str_replace('.', '-', $colName)] = $xmlTool->xmlentities($record->strval($fieldName, $index));
     }
     return $row;
 }