function Dataface_NavMenu($tables, $current = '') { $this->_tables = $tables; if ($current) { $this->_current = $current; } else { foreach ($tables as $table) { $this->_current = $table; break; } } //$this->_smarty = new Smarty; //$this->_smarty->template_dir = $GLOBALS['Dataface_Globals_Templates']; //$this->_smarty->compile_dir = $GLOBALS['Dataface_Globals_Templates_c']; $this->_skinTool =& Dataface_SkinTool::getInstance(); }
function HTML_QuickForm_Renderer_Dataface(&$form) { $this->_skinTool =& Dataface_SkinTool::getInstance(); parent::HTML_QuickForm_Renderer_Default(); $this->setRequiredNoteTemplate(''); }
function df_editable($content, $id) { $skinTool = Dataface_SkinTool::getInstance(); return $skinTool->editable(array('id' => $id), $content, $skinTool); }
function getGroupTemplate($name) { $name = $this->_formatFieldName($name); $group =& $this->_table->getField($name); $context = array('group' => &$group, 'content' => '{content}'); $skinTool =& Dataface_SkinTool::getInstance(); ob_start(); $skinTool->display($context, 'Dataface_Quickform_group.html'); $o = ob_get_contents(); ob_end_clean(); return $o; }
function toHtml() { $context = array(); $context['relatedList'] = $this; $app =& Dataface_Application::getInstance(); $context['app'] =& $app; $query =& $app->getQuery(); $context['query'] =& $query; if (isset($query['-related:sort'])) { $sortcols = explode(',', trim($query['-related:sort'])); $sort_columns = array(); foreach ($sortcols as $sortcol) { $sortcol = trim($sortcol); if (strlen($sortcol) === 0) { continue; } $sortcol = explode(' ', $sortcol); if (count($sortcol) > 1) { $sort_columns[$sortcol[0]] = strtolower($sortcol[1]); } else { $sort_columns[$sortcol[0]] = 'asc'; } break; } unset($sortcols); // this was just a temp array so we get rid of it here } else { $sort_columns = array(); } $context['sort_columns'] =& $sort_columns; $sort_columns_arr = array(); foreach ($sort_columns as $colkey => $colorder) { $sort_columns_arr[] = '`' . $colkey . '`' . $colorder; } if (count($sort_columns_arr) > 0) { $sort_columns_str = implode(', ', $sort_columns_arr); } else { $sort_columns_str = 0; } unset($query); $skinTool =& Dataface_SkinTool::getInstance(); $context['skinTool'] =& $skinTool; $resultController =& $skinTool->getResultController(); $context['resultController'] =& $resultController; $s =& $this->_table; $r =& $this->_relationship->_schema; $fkeys = $this->_relationship->getForeignKeyValues(); $local_fkey_fields = array(); foreach ($fkeys as $fk_table_name => $fk_table_cols) { foreach ($fk_table_cols as $k => $v) { if (is_string($v) and $v and $v[0] === '$') { $local_fkey_fields[$k] = $v; } } } $default_order_column = $this->_relationship->getOrderColumn(); //echo "Def order col = $default_order_column"; ob_start(); df_display(array('redirectUrl' => $_SERVER['PHP_SELF'] . '?' . $_SERVER['QUERY_STRING']), 'Dataface_MoveUpForm.html'); $moveUpForm = ob_get_contents(); ob_end_clean(); $context['moveUpForm'] = $moveUpForm; $records =& $this->_record->getRelatedRecords($this->_relationship_name, true, $this->_start, $this->_limit, $this->_where); if (PEAR::isError($records)) { $records->addUserInfo("Error retrieving records from relationship " . $this->_relationship_name); return $records; } $context['records'] =& $records; //echo "<br/><b>Now Showing</b> ".($this->_start+1)." to ".(min($this->_start + $this->_limit, $this->_record->numRelatedRecords($this->_relationship_name))); $perms = $this->_record->getPermissions(array('relationship' => $this->_relationship_name)); $context['perms'] = $perms; $context['record_editable'] = Dataface_PermissionsTool::edit($this->_record); $context['can_add_new_related_record'] = @$perms['add new related record']; $context['can_add_existing_related_record'] = @$perms['add existing related record']; if (!$this->hideActions and ($context['record_editable'] or @$perms['add new related record'] or @$perms['add existing related record'])) { $query = array('-action' => 'new_related_record'); $link = Dataface_LinkTool::buildLink($query); $context['new_related_record_query'] = $query; $context['new_related_record_link'] = $link; $domainTable = $this->_relationship->getDomainTable(); //$context['domainTable'] =& $domainTable; $importTablename = $domainTable; if (!PEAR::isError($domainTable)) { //This relationship is many-to-many so we can add existing records to it. $query2 = array('-action' => 'existing_related_record'); $context['existing_related_record_query'] = $query2; $link2 = Dataface_LinkTool::buildLink($query2); $context['existing_related_record_link'] = $link2; $destTables = $this->_relationship->getDestinationTables(); $context['destTables'] =& $destTables; $importTablename = $destTables[0]->tablename; $context['importTablename'] = $importTablename; } if (!PEAR::isError($importTablename)) { $importTable =& Dataface_Table::loadTable($importTablename); $context['importTable'] =& $importTable; $query3 = array('-action' => 'import'); $context['import_related_records_query'] =& $query3; $link3 = Dataface_LinkTool::buildLink($query3); $context['import_related_records_link'] = $link3; } } $imgIcon = DATAFACE_URL . '/images/search_icon.gif'; $searchSrc = DATAFACE_URL . '/js/Dataface/RelatedList/search.js'; $relname = $this->_relationship_name; $context['relationship_label'] = $this->_relationship->getLabel(); $context['relname'] = $relname; $context['relationship_name'] = $this->_relationship_name; $context['searchSrc'] = $searchSrc; $context['imgIcon'] = $imgIcon; if (!$this->hideActions) { $num_related_records = $this->_record->numRelatedRecords($this->_relationship_name, $this->_where); $now_showing_start = $this->_start + 1; $now_showing_finish = min($this->_start + $this->_limit, $this->_record->numRelatedRecords($this->_relationship_name, $this->_where)); $stats_context = array('num_related_records' => $num_related_records, 'now_showing_start' => $now_showing_start, 'now_showing_finish' => $now_showing_finish, 'relationship_name' => $this->_relationship_name, 'limit_field' => $resultController->limitField('related:'), 'back_link' => $this->_backButtonHtml(), 'next_link' => $this->_forwardButtonHtml()); import('Dataface/ActionTool.php'); $at =& Dataface_ActionTool::getInstance(); $actions = $at->getActions(array('category' => 'related_list_actions')); $context['related_list_actions'] = $actions; foreach ($stats_context as $k => $v) { $context[$k] = $v; } } import('Dataface/ActionTool.php'); $at =& Dataface_ActionTool::getInstance(); $selected_actions = $at->getActions(array('category' => 'selected_related_result_actions')); $context['selected_actions'] = $selected_actions; if ($this->_relationship->_schema['list']['type'] == 'treetable') { import('Dataface/TreeTable.php'); $treetable = new Dataface_TreeTable($this->_record, $this->_relationship->getName()); $context['treetable'] = $treetable->toHtml(); } else { echo $moveUpForm; if (!$this->hideActions and $this->_where) { $filterQuery =& $app->getQuery(); $context['filterQuery'] =& $filterQuery; } if (count($records) > 0) { ob_start(); echo ' <table class="listing relatedList relatedList--' . $this->_tablename . ' relatedList--' . $this->_tablename . '--' . $this->_relationship_name . '" id="relatedList"> <thead> <tr>'; if (count($selected_actions) > 0) { echo '<th>'; if (!$this->hideActions) { echo '<input type="checkbox" onchange="toggleSelectedRows(this,\'relatedList\');">'; } echo '</th>'; } $cols = array_keys(current($records)); $col_tables = array(); $table_keys = array(); $localFields = $this->_record->table()->fields(); $usedColumns = array(); foreach ($cols as $key) { if ($key == $default_order_column) { continue; } if (is_int($key)) { continue; } if (isset($sort_columns[$key])) { $class = 'sorted-column-' . $sort_columns[$key]; $query = array(); $qs_columns = $sort_columns; unset($qs_columns[$key]); $sort_query = $key . ' ' . ($sort_columns[$key] == 'desc' ? 'asc' : 'desc'); foreach ($qs_columns as $qcolkey => $qcolvalue) { $sort_query .= ', ' . $qcolkey . ' ' . $qcolvalue; } } else { $class = 'unsorted-column'; $sort_query = $key . ' asc'; foreach ($sort_columns as $scolkey => $scolvalue) { $sort_query .= ', ' . $scolkey . ' ' . $scolvalue; } } $sq = array('-related:sort' => $sort_query); $link = Dataface_LinkTool::buildLink($sq); $fullpath = $this->_relationship_name . '.' . $key; $field =& $this->_relationship->getField($key); if (isset($this->_relationship->_schema['visibility'][$key]) and $this->_relationship->_schema['visibility'][$key] == 'hidden') { continue; } if ($field['visibility']['list'] != 'visible') { continue; } if ($s->isBlob($fullpath) or $s->isPassword($fullpath)) { continue; } if (isset($local_fkey_fields[$key]) and !isset($this->_relationship->_schema['visibility'][$key])) { continue; } if (PEAR::isError($field)) { $field->addUserInfo("Error getting field info for field {$key} in RelatedList::toHtml() "); return $field; } $usedColumns[] = $key; $label = $field['widget']['label']; if (isset($field['column']) and @$field['column']['label']) { $label = $field['column']['label']; } $legend = ''; if (@$field['column'] and @$field['column']['legend']) { $legend = '<span class="column-legend">' . df_escape($field['column']['legend']) . '</span>'; } if (!$this->noLinks) { echo '<th><a href="' . df_escape($link) . '">' . df_escape($field['widget']['label']) . "</a> {$legend}</th>\n"; } else { echo '<th>' . $field['widget']['label'] . '</th>'; } if (!isset($col_tables[$key])) { $col_tables[$key] = $field['tablename']; } if (!isset($table_keys[$col_tables[$key]])) { $table_table =& Dataface_Table::loadTable($field['tablename']); $table_keys[$col_tables[$key]] = array_keys($table_table->keys()); unset($table_table); } unset($field); } echo "</tr>\n\t\t\t\t\t</thead>\n\t\t\t\t\t<tbody id=\"relatedList-body\">\n\t\t\t\t\t"; $limit = min($this->_limit, $this->_record->numRelatedRecords($this->_relationship_name, $this->_where) - $this->_start); $relatedTable = $this->_relationship->getDomainTable(); if (PEAR::isError($relatedTable)) { $relatedTable = reset($r['selected_tables']); } $relatedTable = Dataface_Table::loadTable($relatedTable); $relatedKeys = array_keys($relatedTable->keys()); foreach (array_keys($relatedKeys) as $i) { $relatedKeys[$i] = $this->_relationship_name . "." . $relatedKeys[$i]; } $fullpaths = array(); $fields_index = array(); foreach ($usedColumns as $key) { $fullpaths[$key] = $this->_relationship_name . '.' . $key; $fields_index[$key] =& $this->_relationship->getField($key); } $evenRow = false; for ($i = $this->_start; $i < $this->_start + $limit; $i++) { $rowClass = $evenRow ? 'even' : 'odd'; $evenRow = !$evenRow; if ($default_order_column and @$perms['reorder_related_records']) { $style = 'cursor:move'; // A variable that will be used below in javascript to decide // whether to make the table sortable or not $sortable_js = 'true'; } else { $style = ''; $sortable_js = 'false'; } $context['sortable_js'] = $sortable_js; unset($rrec); $rrec = $this->_record->getRelatedRecord($this->_relationship_name, $i, $this->_where, $sort_columns_str); //new Dataface_RelatedRecord($this->_record, $this->_relationship_name, $this->_record->getValues($fullpaths, $i, 0, $sort_columns_str)); $rrecid = $rrec->getId(); $rowPerms = $rrec->getPermissions(); if (!@$rowPerms['view']) { continue; } echo "<tr class=\"listing {$rowClass}\" style=\"{$style}\" id=\"row_{$rrecid}\">"; if (count($selected_actions) > 0) { echo ' <td class="' . $rowClass . ' viewableColumn" nowrap>'; if (!$this->hideActions) { echo '<input xf-record-id="' . df_escape($rrecid) . '" class="rowSelectorCheckbox" id="rowSelectorCheckbox:' . df_escape($rrecid) . '" type="checkbox">'; } echo '</td>'; } $link_queries = array(); foreach ($usedColumns as $key) { if (is_int($key)) { continue; } $fullpath = $fullpaths[$key]; unset($field); $field =& $fields_index[$key]; //$s->getField($fullpath); $srcRecord =& $rrec->toRecord($field['tablename']); if (!@$app->_conf['legacy_compatibility_mode']) { $link = $this->_record->getURL('-action=view_related_record&-related-record-id=' . urlencode($rrecid)); } else { //$link = $srcRecord->getURL('-action=browse&-portal-context=' . urlencode($rrecid)); $link = $rrec->getURL('-action=browse', $field['tablename']); } $srcRecordId = $srcRecord->getId(); //$val = $this->_record->preview($fullpath, $i,255, $this->_where, $sort_columns_str); if ($srcRecord->table()->isContainer($field['name']) or $srcRecord->table()->isBlob($field['name'])) { $val = $rrec->htmlValue($key, array('class' => 'blob-preview')); //$rrec->htmlValue($key); } else { $val = strip_tags($rrec->display($key)); } $title = ""; if ($key == $default_order_column) { unset($field); unset($srcRecord); continue; } else { if ($val != 'NO ACCESS') { $accessClass = 'viewableColumn'; } else { $accessClass = ''; } $cellClass = 'resultListCell resultListCell--' . $key; $cellClass .= ' ' . $srcRecord->table()->getType($key); $renderVal = $this->renderCell($srcRecord, $field['Field']); if (isset($renderVal)) { $val = $renderVal; } if ($link and !@$field['noLinkFromListView'] and !$this->noLinks and $rrec->checkPermission('link', array('field' => $key))) { $val = "<a href=\"" . df_escape($link) . "\" title=\"" . df_escape($title) . "\" data-xf-related-record-id=\"" . df_escape($srcRecordId) . "\" class=\"xf-related-record-link\">" . $val . "</a>"; } echo "<td class=\"{$cellClass} {$rowClass} {$accessClass}\">{$val}</td>\n"; unset($srcRecord); } } echo "</tr>\n"; } echo "</tbody>\n\t\t\t\t\t</table>"; $related_table_html = ob_get_contents(); $context['related_table_html'] = $related_table_html; ob_end_clean(); if (!$this->hideActions) { ob_start(); echo '<form id="result_list_selected_items_form" method="post">'; $app =& Dataface_Application::getInstance(); $q =& $app->getQuery(); foreach ($q as $key => $val) { if (strlen($key) > 1 and $key[0] == '-' and $key[1] == '-') { continue; } echo '<input type="hidden" name="' . $key . '" value="' . df_escape($val) . '">'; } echo '<input type="hidden" name="--selected-ids" id="--selected-ids">'; echo '<input type="hidden" name="-from" id="-from" value="' . $q['-action'] . '">'; echo '</form>'; $selected_actions_form = ob_get_contents(); $context['selected_actions_form'] = $selected_actions_form; ob_end_clean(); // This bit of javascript goes through all of the columns and removes all columns that // don't have any accessible information for this query. (i.e. any columns for which // each row's value is 'NO ACCESS' is removed $prototype_url = DATAFACE_URL . '/js/scriptaculous/lib/prototype.js'; $context['prototype_url'] = $prototype_url; $scriptaculous_url = DATAFACE_URL . '/js/scriptaculous/src/scriptaculous.js'; $context['scriptaculous_url'] = $scriptaculous_url; $effects_url = DATAFACE_URL . '/js/scriptaculous/src/effects.js'; $context['effects_url'] = $effects_url; $dragdrop_url = DATAFACE_URL . '/js/scriptaculous/src/dragdrop.js'; $context['dragdrop_url'] = $dragdrop_url; $thisRecordID = $this->_record->getId(); $context['thisRecordID'] = $thisRecordID; } } } Dataface_JavascriptTool::getInstance()->import('xataface/actions/related_list.js'); ob_start(); $context['filters'] = $this->filters; df_display($context, 'xataface/RelatedList/list.html'); $out = ob_get_contents(); ob_end_clean(); return $out; }
function toHtml() { $app =& Dataface_Application::getInstance(); $query =& $app->getQuery(); if (isset($query['-related:sort'])) { $sortcols = explode(',', trim($query['-related:sort'])); $sort_columns = array(); foreach ($sortcols as $sortcol) { $sortcol = trim($sortcol); if (strlen($sortcol) === 0) { continue; } $sortcol = explode(' ', $sortcol); if (count($sortcol) > 1) { $sort_columns[$sortcol[0]] = strtolower($sortcol[1]); } else { $sort_columns[$sortcol[0]] = 'asc'; } break; } unset($sortcols); // this was just a temp array so we get rid of it here } else { $sort_columns = array(); } $sort_columns_arr = array(); foreach ($sort_columns as $colkey => $colorder) { $sort_columns_arr[] = '`' . $colkey . '`' . $colorder; } if (count($sort_columns_arr) > 0) { $sort_columns_str = implode(', ', $sort_columns_arr); } else { $sort_columns_str = 0; } //echo $sort_columns_str;exit; unset($query); $skinTool =& Dataface_SkinTool::getInstance(); $resultController =& $skinTool->getResultController(); $s =& $this->_table; $r =& $this->_relationship->_schema; $fkeys = $this->_relationship->getForeignKeyValues(); $default_order_column = $this->_relationship->getOrderColumn(); //echo "Def order col = $default_order_column"; ob_start(); df_display(array('redirectUrl' => $_SERVER['PHP_SELF'] . '?' . $_SERVER['QUERY_STRING']), 'Dataface_MoveUpForm.html'); $moveUpForm = ob_get_contents(); ob_end_clean(); $records =& $this->_record->getRelatedRecords($this->_relationship_name, true, $this->_start, $this->_limit, $this->_where); if (PEAR::isError($records)) { $records->addUserInfo("Error retrieving records from relationship " . $this->_relationship_name . " on line " . __LINE__ . " of file " . __FILE__); return $records; } ob_start(); //echo "<br/><b>Now Showing</b> ".($this->_start+1)." to ".(min($this->_start + $this->_limit, $this->_record->numRelatedRecords($this->_relationship_name))); $perms = $this->_record->getPermissions(array('relationship' => $this->_relationship_name)); if (Dataface_PermissionsTool::edit($this->_record) or @$perms['add new related record'] or @$perms['add existing related record']) { $query = array('-action' => 'new_related_record'); $link = Dataface_LinkTool::buildLink($query); $domainTable = $this->_relationship->getDomainTable(); $importTablename = $domainTable; if (!PEAR::isError($domainTable)) { //This relationship is many-to-many so we can add existing records to it. $query2 = array('-action' => 'existing_related_record'); $link2 = Dataface_LinkTool::buildLink($query2); $destTables = $this->_relationship->getDestinationTables(); $importTablename = $destTables[0]->tablename; } if (!PEAR::isError($importTablename)) { $importTable =& Dataface_Table::loadTable($importTablename); $query3 = array('-action' => 'import'); $link3 = Dataface_LinkTool::buildLink($query3); } echo "<div id=\"relatedActionsWrapper\" class=\"contentActions\"><ul id=\"relatedActions\">"; if ($this->_relationship->supportsAddNew() and @$perms['add new related record']) { echo "<li id=\"addNew\"><a id=\"add_new_related_record\" href=\"{$link}\">" . df_translate('scripts.Dataface.RelatedList.toHtml.LABEL_ADD_NEW_RELATED_RECORD', "Add New " . ucfirst($this->_relationship_name) . " Record", array('relationship' => ucfirst($this->_relationship_name))) . "</a></li>"; } if ($this->_relationship->supportsAddExisting() and isset($query2) and @$perms['add existing related record']) { echo "<li id=\"addExisting\"><a id=\"add_existing_related_record\" href=\"{$link2}\">" . df_translate('scripts.Dataface.RelatedList.toHtml.LABEL_ADD_EXISTING_RELATED_RECORD', "Add Existing " . ucfirst($this->_relationship_name) . " Record", array('relationship' => ucfirst($this->_relationship_name))) . "</a></li>"; } if (isset($query3) and count($importTable->getImportFilters()) > 0) { echo "<li id=\"import\"><a id=\"import_related_records\" href=\"{$link3}\">" . df_translate('scripts.Dataface.RelatedList.toHtml.LABEL_IMPORT_RELATED_RECORDS', "Import " . ucfirst($this->_relationship_name) . " Records", array('relationship' => ucfirst($this->_relationship_name))) . "</a></li>"; } echo "</ul></div>"; } $out = ob_get_contents(); ob_end_clean(); ob_start(); $imgIcon = DATAFACE_URL . '/images/search_icon.gif'; $searchSrc = DATAFACE_URL . '/js/Dataface/RelatedList/search.js'; $relname = $this->_relationship_name; echo <<<END \t\t<div class="result-tools" style="float:left"> \t\t\t<script language="javascript" type="text/javascript" src="{$searchSrc}"></script> \t\t\t<a href="#" onclick="Dataface.RelatedList.showSearch('{$relname}', document.getElementById('related_find_wrapper')); return false;" title="Filter these results"><img src="{$imgIcon}" alt="Filter" /></a> \t\t\t \t\t</div> END; echo '<div class="result-stats">'; $num_related_records = $this->_record->numRelatedRecords($this->_relationship_name, $this->_where); $now_showing_start = $this->_start + 1; $now_showing_finish = min($this->_start + $this->_limit, $this->_record->numRelatedRecords($this->_relationship_name, $this->_where)); echo df_translate('scripts.Dataface.RelatedList.toHtml.MESSAGE_FOUND', "<b>Found</b> " . $num_related_records . " Records in relationship <i>" . $this->_relationship_name . "</i>", array('num' => $num_related_records, 'relationship' => $this->_relationship_name)) . "<br/>" . df_translate('scripts.Dataface.RelatedList.toHtml.MESSAGE_NOW_SHOWING', "<b>Now Showing</b> " . $now_showing_start . " to " . $now_showing_finish, array('start' => $now_showing_start, 'finish' => $now_showing_finish)) . "</div>\n\t\t\t<div class=\"limit-field\">\n\t\t\t"; echo $resultController->limitField('related:'); echo "</div>\n\t\t\t<div class=\"prev-link\">" . $this->_backButtonHtml() . "</div>\n\t\t\t<div class=\"next-link\">" . $this->_forwardButtonHtml() . "</div>\n\t\t"; import('Dataface/ActionTool.php'); $at =& Dataface_ActionTool::getInstance(); $actions = $at->getActions(array('category' => 'related_list_actions')); echo <<<END \t\t<div class="result-list-actions"> \t\t<ul class="icon-only" id="result-list-actions"> END; foreach ($actions as $action) { if (@$action['onclick']) { $onclick = 'onclick="' . htmlspecialchars($action['onclick']) . '"'; } else { $onclick = ''; } echo <<<END \t\t\t <li id="result-list-actions-{$action['id']}" class="plain"> \t\t\t \t\t\t<a id="result-list-actions-{$action['id']}-link"href="{$action['url']}" {$onclick} \t\t\t accesskey="e" title="{$action['description']}"> \t\t\t <img id="result-list-actions-{$action['id']}-icon"src="{$action['icon']}" alt="{$action['label']}"/> \t\t\t\t<span class="action-label">{$action['label']}</span> \t\t\t</a> \t\t </li> END; } echo <<<END \t\t</ul> \t\t \t\t</div> END; $relatedResultController = ob_get_contents(); ob_end_clean(); ob_start(); //echo '<div style="clear: both"/>'; echo '<div class="resultlist-controller">'; echo $relatedResultController; echo "</div>"; import('Dataface/ActionTool.php'); $at =& Dataface_ActionTool::getInstance(); $selected_actions = $at->getActions(array('category' => 'selected_related_result_actions')); if ($this->_relationship->_schema['list']['type'] == 'treetable') { import('Dataface/TreeTable.php'); $treetable = new Dataface_TreeTable($this->_record, $this->_relationship->getName()); echo $treetable->toHtml(); } else { echo $moveUpForm; if ($this->_where) { $filterQuery =& $app->getQuery(); echo '<div>Showing matches for query <em>"' . htmlspecialchars($filterQuery['-related:search']) . '"</em> <a href="' . $app->url('-related:search=') . '" title="Remove this filter to show all records in this relationship"> <img src="' . DATAFACE_URL . '/images/delete.gif" alt="Remove filter" /> </a> </div>'; } echo '<div style="display:none" id="related_find_wrapper"></div>'; if (count($records) > 0) { echo ' <table class="listing relatedList relatedList--' . $this->_tablename . ' relatedList--' . $this->_tablename . '--' . $this->_relationship_name . '" id="relatedList"> <thead> <tr>'; if (count($selected_actions) > 0) { echo '<th><input type="checkbox" onchange="toggleSelectedRows(this,\'relatedList\');"></th> '; } $cols = array_keys(current($records)); $col_tables = array(); $table_keys = array(); $usedColumns = array(); foreach ($cols as $key) { if ($key == $default_order_column) { continue; } if (is_int($key)) { continue; } if (isset($sort_columns[$key])) { $class = 'sorted-column-' . $sort_columns[$key]; $query = array(); $qs_columns = $sort_columns; unset($qs_columns[$key]); $sort_query = $key . ' ' . ($sort_columns[$key] == 'desc' ? 'asc' : 'desc'); foreach ($qs_columns as $qcolkey => $qcolvalue) { $sort_query .= ', ' . $qcolkey . ' ' . $qcolvalue; } } else { $class = 'unsorted-column'; $sort_query = $key . ' asc'; foreach ($sort_columns as $scolkey => $scolvalue) { $sort_query .= ', ' . $scolkey . ' ' . $scolvalue; } } $sq = array('-related:sort' => $sort_query); $link = Dataface_LinkTool::buildLink($sq); $fullpath = $this->_relationship_name . '.' . $key; $field =& $s->getField($fullpath); if (isset($this->_relationship->_schema['visibility'][$key]) and $this->_relationship->_schema['visibility'][$key] == 'hidden') { continue; } if ($field['visibility']['list'] != 'visible') { continue; } if ($s->isBlob($fullpath) or $s->isPassword($fullpath)) { continue; } if (PEAR::isError($field)) { $field->addUserInfo("Error getting field info for field {$key} in RelatedList::toHtml() on line " . __LINE__ . " of file " . __FILE__); return $field; } $usedColumns[] = $key; $label = $field['widget']['label']; if (isset($field['column']) and @$field['column']['label']) { $label = $field['column']['label']; } $legend = ''; if (@$field['column'] and @$field['column']['legend']) { $legend = '<span class="column-legend">' . htmlspecialchars($field['column']['legend']) . '</span>'; } echo '<th><a href="' . $link . '">' . $field['widget']['label'] . "</a> {$legend}</th>\n"; if (!isset($col_tables[$key])) { $col_tables[$key] = $field['tablename']; } if (!isset($table_keys[$col_tables[$key]])) { $table_table =& Dataface_Table::loadTable($field['tablename']); $table_keys[$col_tables[$key]] = array_keys($table_table->keys()); unset($table_table); } unset($field); } echo "</tr>\n\t\t\t\t\t</thead>\n\t\t\t\t\t<tbody id=\"relatedList-body\">\n\t\t\t\t\t"; $limit = min($this->_limit, $this->_record->numRelatedRecords($this->_relationship_name, $this->_where) - $this->_start); $relatedTable = $this->_relationship->getDomainTable(); if (PEAR::isError($relatedTable)) { $relatedTable = reset($r['selected_tables']); } $relatedTable = Dataface_Table::loadTable($relatedTable); $relatedKeys = array_keys($relatedTable->keys()); foreach (array_keys($relatedKeys) as $i) { $relatedKeys[$i] = $this->_relationship_name . "." . $relatedKeys[$i]; } $fullpaths = array(); $fields_index = array(); foreach ($usedColumns as $key) { $fullpaths[$key] = $this->_relationship_name . '.' . $key; $fields_index[$key] =& $s->getField($fullpaths[$key]); } $evenRow = false; for ($i = $this->_start; $i < $this->_start + $limit; $i++) { $rowClass = $evenRow ? 'even' : 'odd'; $evenRow = !$evenRow; if ($default_order_column and @$perms['reorder_related_records']) { $style = 'cursor:move'; // A variable that will be used below in javascript to decide // whether to make the table sortable or not $sortable_js = 'true'; } else { $style = ''; $sortable_js = 'false'; } unset($rrec); $rrec = $this->_record->getRelatedRecord($this->_relationship_name, $i, $this->_where, $sort_columns_str); //new Dataface_RelatedRecord($this->_record, $this->_relationship_name, $this->_record->getValues($fullpaths, $i, 0, $sort_columns_str)); $rrecid = $rrec->getId(); echo "<tr class=\"listing {$rowClass}\" style=\"{$style}\" id=\"row_{$rrecid}\">"; if (count($selected_actions) > 0) { echo ' <td class="' . $rowClass . ' viewableColumn" nowrap> <input class="rowSelectorCheckbox" id="rowSelectorCheckbox:' . $rrecid . '" type="checkbox"> '; echo ' </td>'; } $link_queries = array(); foreach ($usedColumns as $key) { if (is_int($key)) { continue; } $fullpath = $fullpaths[$key]; unset($field); $field =& $fields_index[$key]; //$s->getField($fullpath); $srcRecord =& $rrec->toRecord($field['tablename']); $link = $srcRecord->getURL('-action=browse'); /* if ( isset($link_queries[$col_tables[$key]]) ){ $query = $link_queries[$col_tables[$key]]; $failed = false; } else { $query = array( "-action"=>"browse", "-relationship"=>null, "-cursor"=>0, "-table"=>$col_tables[$key]) ; $failed = false; // flag to indicate if we failed to generate appropriate link foreach ( $table_keys[$col_tables[$key]] as $table_key ){ $query[$table_key] = "=".$this->_record->getValueAsString($this->_relationship_name.'.'.$table_key, $i, $this->_where, $sort_columns_str); if ( $query[$table_key] == '=' ){ if ( isset( $fkeys[$col_tables[$key]][$table_key]) ){ $query[$table_key] = $this->_record->parseString($fkeys[$col_tables[$key]][$table_key]); } else { $failed = true; } } } $link_queries[$col_tables[$key]] = $query; } if ( $failed ){ $link = "#"; } else { $link = Dataface_LinkTool::buildLink($query, false); } */ //$val = ''; $val = $this->_record->preview($fullpath, $i, 255, $this->_where, $sort_columns_str); $title = ""; if ($key == $default_order_column) { unset($field); unset($srcRecord); continue; } else { if ($val != 'NO ACCESS') { $accessClass = 'viewableColumn'; } else { $accessClass = ''; } $cellClass = 'resultListCell resultListCell--' . $key; $renderVal = $this->renderCell($srcRecord, $field['Field']); if (isset($renderVal)) { $val = $renderVal; } else { if ($link and !@$field['noLinkFromListView']) { $val = "<a href=\"{$link}\" title=\"" . htmlspecialchars($title) . "\">" . $val . "</a>"; } } echo "<td class=\"{$cellClass} {$rowClass} {$accessClass}\">{$val}</td>\n"; unset($srcRecord); } } echo "</tr>\n"; } echo "</tbody>\n\t\t\t\t\t</table>"; echo '<form id="result_list_selected_items_form" method="post">'; $app =& Dataface_Application::getInstance(); $q =& $app->getQuery(); foreach ($q as $key => $val) { if (strlen($key) > 1 and $key[0] == '-' and $key[1] == '-') { continue; } echo '<input type="hidden" name="' . $key . '" value="' . htmlspecialchars($val) . '">'; } echo '<input type="hidden" name="--selected-ids" id="--selected-ids">'; echo '<input type="hidden" name="-from" id="-from" value="' . $query['-action'] . '">'; echo '</form>'; if (count($selected_actions) > 0) { echo '<div id="selected-actions">' . df_translate('scripts.GLOBAL.LABEL_WITH_SELECTED', 'With Selected') . ': <ul class="selectedActionsMenu" id="result_list-selectedActionsMenu">'; foreach ($selected_actions as $action) { echo <<<END \t\t\t\t\t\t<li id="action-{$action['id']}"><a href="{$action['url']}" title="{$action['description']}">{$action['label']}</a></li> END; } echo '</ul></div>'; } echo '<div class="resultlist-controller">'; echo $relatedResultController; echo '</div>'; // This bit of javascript goes through all of the columns and removes all columns that // don't have any accessible information for this query. (i.e. any columns for which // each row's value is 'NO ACCESS' is removed $prototype_url = DATAFACE_URL . '/js/scriptaculous/lib/prototype.js'; $scriptaculous_url = DATAFACE_URL . '/js/scriptaculous/src/scriptaculous.js'; $effects_url = DATAFACE_URL . '/js/scriptaculous/src/effects.js'; $dragdrop_url = DATAFACE_URL . '/js/scriptaculous/src/dragdrop.js'; $thisRecordID = $this->_record->getId(); echo <<<END \t\t\t\t<script language="javascript" src="{$prototype_url}"></script> \t\t\t\t<script language="javascript" src="{$scriptaculous_url}"></script> \t\t\t\t<script language="javascript" src="{$effects_url}"></script> \t\t\t\t<script language="javascript" src="{$dragdrop_url}"></script> \t\t\t\t<script language="javascript"><!-- \t\t\t\tfunction removeUnauthorizedColumns(){ \t\t\t\t\tvar relatedList = document.getElementById('relatedList'); \t\t\t\t\tvar trs = relatedList.getElementsByTagName('tr'); \t\t\t\t\tvar viewableColumns = []; \t\t\t\t\tvar numCols = 0; \t\t\t\t\tfor (var i=0; i<trs.length; i++){ \t\t\t\t\t\tvar tr = trs[i]; \t\t\t\t\t\tvar tds = tr.getElementsByTagName('td'); \t\t\t\t\t\tfor (var j=0; j<tds.length; j++){ \t\t\t\t\t\t\tvar td = tds[j]; \t\t\t\t\t\t\tif ( td.className.indexOf('viewableColumn') >= 0 ){ \t\t\t\t\t\t\t\tviewableColumns[j] = true; \t\t\t\t\t\t\t} \t\t\t\t\t\t\tnumCols = j; \t\t\t\t\t\t} \t\t\t\t\t} \t\t\t\t\tfor (var j=viewableColumns.length; j<=numCols; j++){ \t\t\t\t\t\tviewableColumns[j] = false; \t\t\t\t\t} \t\t\t\t\t \t\t\t\t\t \t\t\t\t\tfor (var i=0; i<trs.length; i++){ \t\t\t\t\t\tvar tds = trs[i].getElementsByTagName('td'); \t\t\t\t\t\tif ( tds.length <= 0 ){ \t\t\t\t\t\t\tvar tds = trs[i].getElementsByTagName('th'); \t\t\t\t\t\t} \t\t\t\t\t\t \t\t\t\t\t\tfor (var j=0; j<viewableColumns.length; j++){ \t\t\t\t\t\t\tif ( !viewableColumns[j] ){ \t\t\t\t\t\t\t\ttds[j].style.display = 'none'; \t\t\t\t\t\t\t} \t\t\t\t\t\t} \t\t\t\t\t\t \t\t\t\t\t} \t\t\t\t} \t\t\t\tremoveUnauthorizedColumns(); \t\t\t\t \t\t\t\t \t\t\t\tif ( {$sortable_js} ){ \t\t\t\t\tSortable.create("relatedList-body", \t\t\t\t\t\t\t{ \t\t\t\t\t\t\t\tdropOnEmpty:true, \t\t\t\t\t\t\t\tconstraint:false, \t\t\t\t\t\t\t\t//handle:'move-handle', \t\t\t\t\t\t\t\ttag:'tr', \t\t\t\t\t\t\t\tonUpdate: function(container){ \t\t\t\t\t\t\t\t\t \t\t\t\t\t\t\t\t\tvar params = Sortable.serialize('relatedList-body'); \t\t\t\t\t\t\t\t\tparams += '&'+window.location.search.substring(1); \t\t\t\t\t\t\t\t\t \t\t\t\t\t\t\t\t\tparams += '&-action=reorder_related_records';//&--recordid='+escape('{$thisRecordID}'); \t\t\t\t\t\t\t\t\t \t\t\t\t\t\t\t\t\tnew Ajax.Request( \t\t\t\t\t\t\t\t\t\tDATAFACE_SITE_HREF, { \t\t\t\t\t\t\t\t\t\t\tmethod: 'post', \t\t\t\t\t\t\t\t\t\t\tparameters: params, \t\t\t\t\t\t\t\t\t\t\tonSuccess: function(transport){ \t\t\t\t\t\t\t\t\t\t\t \t\t\t\t\t\t\t\t\t\t\t\t//document.getElementById('details-controller').innerHTML = transport.responseText; \t\t\t\t\t\t\t\t\t\t\t}, \t\t\t\t\t\t\t\t\t\t\tonFailure:function(){ \t\t\t\t\t\t\t\t\t\t\t\talert('Failed to sort records.'); \t\t\t\t\t\t\t\t\t\t\t} \t\t\t\t\t\t\t\t\t\t} \t\t\t\t\t\t\t\t\t); \t\t\t\t\t\t\t\t\t \t\t\t\t\t\t\t\t} \t\t\t\t\t\t\t\t//only:'movable' \t\t\t\t\t\t\t}); \t\t\t\t\t\t//Sortable.create("dataface-sections-main", \t\t\t\t\t\t//{dropOnEmpty:true,constraint:false, handle:'movable-handle',tag:'div',only:'movable', onUpdate:updateSections}); \t\t\t\t}\t \t\t\t\t \t\t\t\t//--></script> \t\t\t\t END; } else { echo "<p>" . df_translate('scripts.GLOBAL.NO_RECORDS_MATCHED_REQUEST', 'No records matched your request.') . "</p>"; } } $out .= ob_get_contents(); ob_end_clean(); return $out; }
function getGroupTemplate($name) { $name = $this->_formatFieldName($name); $group =& $this->_table->getField($name); //print_r($group); //if ( isset($this->_fields[$name]['widget']['description'] )){ // $description = $this->_fields[$name]['widget']['description']; //} else { // $description = ''; //} $context = array('group' => &$group, 'content' => '{content}'); $skinTool =& Dataface_SkinTool::getInstance(); ob_start(); $skinTool->display($context, 'Dataface_TranslationForm_group.html'); $o = ob_get_contents(); ob_end_clean(); return $o; }
function toHTML() { import('Dataface/SkinTool.php'); $recKeys = array_keys($this->records); $sampleRecord =& $this->records[$recKeys[0]]; if ($this->columns === null) { $columns = array(); if (is_a($sampleRecord, 'Dataface_Record')) { $columns = array_keys($sampleRecord->_table->fields(false, true)); } else { if (is_a($sampleRecord, 'Dataface_RelatedRecord')) { $columns = $sampleRecord->_relationship->_schema['short_columns']; } else { $columns = array_keys($sampleRecord); } } } else { $columns =& $this->columns; } if (count($this->actionCellCallbacks) > 0) { $hasCallbacks = true; array_unshift($columns, RecordGrid_ActionLabel); } else { $hasCallbacks = false; } //print_r($columns); $gridContent = array(); foreach ($this->records as $record) { if ($hasCallbacks) { $row[RecordGrid_ActionLabel] = ''; } if (is_a($record, 'Dataface_Record') or is_a($record, 'Dataface_RelatedRecord')) { $row = array(); foreach ($columns as $column) { if ($column == RecordGrid_ActionLabel) { continue; } $row[$column] = $record->printValue($column); if (isset($this->cellFilters[$column])) { $row[$column] = call_user_func($this->cellFilters[$column], $record, $column, $row[$column]); } } if ($hasCallbacks) { $cbout = array(); foreach ($this->actionCellCallbacks as $cb) { $cbout[] = call_user_func($cb, $row); } $row[RecordGrid_ActionLabel] = implode('', $cbout); } $gridContent[] =& $row; unset($row); } else { if (is_array($record)) { $row = array(); foreach ($columns as $column) { if ($column == RecordGrid_ActionLabel) { continue; } $row[$column] = @$record[$column]; if (isset($this->cellFilters[$column])) { $row[$column] = call_user_func($this->cellFilters[$column], $row, $column, $row[$column]); } } if ($hasCallbacks) { $cbout = array(); foreach ($this->actionCellCallbacks as $cb) { $cbout[] = call_user_func($cb, $row); } $row[RecordGrid_ActionLabel] = implode('', $cbout); } $gridContent[] =& $row; unset($row); } } } if ($this->labels === null) { $this->labels = array(); foreach ($columns as $column) { if ($column == RecordGrid_ActionLabel) { $labels[$column] = ''; continue; } if (is_a($sampleRecord, 'Dataface_Record')) { $field =& $sampleRecord->_table->getField($column); $labels[$column] = $field['widget']['label']; } else { if (is_a($sampleRecord, 'Dataface_RelatedRecord')) { $table =& $sampleRecord->_relationship->getTable($column); $field =& $table->getField($column); $labels[$column] = $field['widget']['label']; } else { $labels[$column] = ucwords(str_replace('_', ' ', $column)); } } unset($field); unset($table); } } else { $labels =& $this->labels; } $context = array('data' => &$gridContent, 'labels' => &$labels, 'columns' => &$columns, 'id' => $this->id, 'class' => $this->cssclass); $skinTool =& Dataface_SkinTool::getInstance(); ob_start(); $skinTool->display($context, 'Dataface_RecordGrid.html'); $out = ob_get_contents(); ob_end_clean(); return $out; }
function handle(&$params) { $app =& Dataface_Application::getInstance(); $query =& $app->getQuery(); $table =& Dataface_Table::loadTable($query['-table']); $form = new HTML_QuickForm(); foreach ($query as $key => $val) { if ($key[0] == '-' and $key[1] != '-') { $form->addElement('hidden', $key, $val); } } $form->addElement('hidden', '--redirect'); $form->setDefaults(array('--redirect' => $app->url(''))); $form->addElement('text', 'title', 'Title'); $columns = array(); $options = array($query['-table'] => $query['-table']); foreach ($table->relationships() as $rname => $relationship) { $options['::' . $rname] = '::' . $rname; $destTables = $relationship->getDestinationTables(); $rfields = $relationship->fields(true); $fkeys = $relationship->getForeignKeyValues(); //print_r($fkeys); $rcolumns = array(); foreach ($rfields as $rfname) { list($rftable, $rfname) = explode('.', $rfname); if (isset($fkeys[$rftable][$rfname])) { continue; } $columns['::' . $rname][$rname . '.' . $rfname] = $rname . '.' . $rfname; } //foreach ($destTables as $destTable){ // // foreach ($destTable->relationships() as $destRelationshipName => $destRelationship ){ // $options['::'.$rname.'::'.$destRelationshipName] = '::'.$rname.'::'.$destRelationshipName; // // } // unset($destTable); //} } $form->addElement('select', 'table', 'From table', $options, array('onchange' => 'Dataface.modules.DataGrid.newForm.updateFieldsOptions(this);')); $options = array(); foreach ($table->fields() as $fieldName => $fieldDef) { $options[$fieldName] = $fieldName; } $columns[$query['-table']] = $options; $fieldSelector =& $form->addElement('advmultiselect', 'fields', 'Selected Columns', $options); $fieldSelector->setButtonAttributes('moveup', 'class=inputCommand'); $fieldSelector->setButtonAttributes('movedown', 'class=inputCommand'); $form->addElement('submit', 'submit', 'Create Grid'); if ($form->validate()) { $res = $form->process(array(&$this, 'process'), true); if (PEAR::isError($res)) { return $res; } if (@$query['--redirect']) { $url = $query['--redirect']; } else { $url = $app->url(''); } $url = preg_replace('/[&]--[^=]+\\=[^&]*/', '', $url); $url .= '&--msg=' . urlencode('Grid Saved Successfully'); header('Location: ' . $url); exit; } import('HTML/QuickForm/Renderer/ArraySmarty.php'); import('Dataface/SkinTool.php'); $renderer = new HTML_QuickForm_Renderer_ArraySmarty(Dataface_SkinTool::getInstance()); $form->accept($renderer); df_register_skin('DataGrid', DATAFACE_PATH . '/modules/DataGrid/templates'); $json = new Services_JSON(); df_display(array('form' => $renderer->toArray(), 'columns' => $json->encode($columns)), 'DataGrid/new.html'); }
/** * Displays an error. */ function _error() { $st =& Dataface_SkinTool::getInstance(); $context = array(); ob_start(); $st->display($context, 'Dataface_TableView_Error.html'); $out = ob_get_contents(); ob_end_clean(); return $out; }
function display() { $this->_build(); $showform = true; $b = new Dataface_QueryBuilder($this->_tablename, $this->_query); if (isset($this->_query['-delete-one'])) { $q = array('-skip' => $this->_query['-cursor'], '-limit' => 1); $sql = $b->select('', $q); $res = xf_db_query($sql, $this->_db); if (!$res) { throw new Exception(df_translate('scripts.Dataface.DeleteForm._build.ERROR_TRYING_TO_FETCH', "Error trying to fetch element to be deleted.: ") . xf_db_error($this->_db), E_USER_ERROR); } if (xf_db_num_rows($res) == 0) { $msg = df_translate('scripts.Dataface.DeleteForm._build.ERROR_NO_RECORD_SELECTED', "No record is currently selected so no record can be deleted."); $showform = false; } else { $row = xf_db_fetch_array($res); $rowRec = new Dataface_Record($this->_tablename, $row); $displayCol = $rowRec->getTitle(); $msg = df_translate('scripts.Dataface.DeleteForm.display.ARE_YOU_SURE', "Are you sure you want to delete this record: "{$displayCol}"?", array('displayCol' => $displayCol)); } } else { if (isset($this->_query['-delete-found'])) { $q = $b->select_num_rows(); $res = xf_db_query($q, $this->_db); if (!$res) { throw new Exception(df_translate('scripts.Dataface.DeleteForm.display.ERROR_ESTIMATING', "Error estimating number of rows that will be deleted: ") . xf_db_error($this->_db), E_USER_ERROR); } list($num) = xf_db_fetch_row($res); if ($num <= 0) { $msg = df_translate('scripts.Dataface.DeleteForm.display.ERROR_NO_RECORDS_FOUND', "There are no records in the current found set so no records can be deleted."); $showform = false; } else { $msg = df_translate('scripts.Dataface.DeleteForm.display.ARE_YOU_SURE_MULTIPLE', "Are you sure you want to delete the found records. {$num} records will be deleted.", array('num' => $num)); } } else { $msg = df_translate('scripts.Dataface.DeleteForm.display.ERROR_GET_VARS', "Error: You must specify either '-delete-one' or '-delete-found' in GET vars."); $showform = false; } } if ($showform) { ob_start(); parent::display(); $form = ob_get_contents(); ob_end_clean(); } else { $form = ''; } $context = array('msg' => $msg, 'form' => $form); import('Dataface/SkinTool.php'); $skinTool =& Dataface_SkinTool::getInstance(); //$smarty = new Smarty; //$smarty->template_dir = $GLOBALS['Dataface_Globals_Templates']; //$smarty->compile_dir = $GLOBALS['Dataface_Globals_Templates_c']; //$smarty->assign($context); //$smarty->display('Dataface_DeleteForm.html'); $skinTool->display($context, 'Dataface_DeleteForm.html'); }