Exemple #1
0
 /**
  * 
  * @param array $row
  * @param string $subtableName
  * @param string $optionsTable
  * @return boolean
  */
 public function updateSubtableFromPostCheckBoxes($row, $subtableName, $optionsTable)
 {
     $sT = new WOOOF_dataBaseTable($this->dataBase, $subtableName);
     if ($sT->constructedOk === FALSE) {
         return FALSE;
     }
     $sTId = $sT->getTableId();
     $res = $this->dataBase->query('delete from ' . $sT->getTableName() . ' where ' . $sT->getLocalGroupColumn() . '=\'' . $row[$sT->getRemoteGroupColumn()] . '\'');
     if ($res === FALSE) {
         return FALSE;
     }
     if (isset($_POST[$sTId])) {
         $oT = new WOOOF_dataBaseTable($this->dataBase, $optionsTable);
         $oT->getResult('');
         for ($n = 0; $n < count($sT->columns) / 2; $n++) {
             $columnMetaData = $sT->columns[$n]->getColumnMetaData();
             if ($columnMetaData['valuesTable'] == $oT->getTableName()) {
                 $presentationColumn = $columnMetaData['name'];
             }
         }
         while (list($key, $val) = each($_POST[$sTId])) {
             $res = $this->dataBase->query('insert into ' . WOOOF::$instance->cleanUserInput($sT->getTableName()) . ' (id,' . WOOOF::$instance->cleanUserInput($sT->getLocalGroupColumn()) . ',' . WOOOF::$instance->cleanUserInput($presentationColumn) . ') values (\'' . $this->dataBase->getNewId($sT->getTableName()) . '\',\'' . WOOOF::$instance->cleanUserInput($row[$sT->getRemoteGroupColumn()]) . '\',\'' . WOOOF::$instance->cleanUserInput($val) . '\')');
             if ($res === FALSE) {
                 return FALSE;
             }
         }
     }
     return TRUE;
 }
                        $orderBy = $table2->getOrderingColumnForListings();
                    } else {
                        $orderBy = 'id';
                    }
                    $table2->getResult('', $orderBy, '', 1);
                    $_GET[$table->getLocalGroupColumn()] = $table2->resultRows[0]['id'];
                } else {
                    $_GET[$table->getLocalGroupColumn()] = $wo->cleanUserInput($_GET[$table->getLocalGroupColumn()]);
                }
                foreach ($table2->columns as $key => $value) {
                    $column = $value->getColumnMetaData();
                    if ($column['appearsInLists']) {
                        $columnsToShow = $column['name'];
                    }
                }
                $htmlFragment = '<li><a class="treeItemLevel@@@level@@@" href="administration.php?__address=1_' . $table->getTableId() . '&' . $table->getLocalGroupColumn() . '=@@@' . $table->getRemoteGroupColumn() . '@@@&wooofParent=@@@' . $table->getRemoteGroupColumn() . '@@@&action=read">@@@' . $columnsToShow . '@@@</a>
          @@@subItems@@@</li>';
                $row = $wo->db->getRow($table2->getTableName(), $_GET[$table->getLocalGroupColumn()]);
                if ($table->getHasDeletedColumn()) {
                    $where = ' and isDeleted!=\'1\'';
                } else {
                    $where = '';
                }
                $content = '<div id="treeDiv">' . $table2->presentTree($columnsToShow, $htmlFragment, $row['id']) . '</div><div id="listDiv">
				' . $wo->doTableList($table, ' where ' . $table->getLocalGroupColumn() . '=\'' . $wo->cleanUserInput($_GET[$table->getLocalGroupColumn()]) . '\' ' . $where, $wo->cleanUserInput($_GET[$table->getLocalGroupColumn()])) . '</div>';
            } else {
                if ($table->getAdminPresentation() == '3') {
                    $content = '<div class="listTitle"><a href="administration.php?action=edit&__address=1_' . $addressItems[1] . '_&wooofParent=-1">Προσθήκη Κεντρικού Κόμβου &nbsp;<img src="images/add.png" alt="Create new item" border="0" align="top"></a></div>';
                    foreach ($table->columns as $key => $value) {
                        $column = $value->getColumnMetaData();
                        if ($column['appearsInLists']) {
Exemple #3
0
 $presentationDefault[4] = '';
 $presentationDefault[5] = '';
 $presentationDefault[$table->getAdminPresentation()] = ' selected';
 $tableName = $table->getTableName();
 $orderingColumnForListings = $table->getOrderingColumnForListings();
 $appearsInAdminMenu = $table->getAppearsInAdminMenu();
 if ($appearsInAdminMenu == '1') {
     $appearsInAdminMenu = ' checked';
 } else {
     $appearsInAdminMenu = '';
 }
 $adminItemsPerPage = $table->getAdminItemsPerPage();
 $adminListMarkingCondition = $table->getAdminListMarkingCondition();
 $adminListMarkedStyle = $table->getAdminListMarkedStyle();
 $groupedByTable = $table->getGroupedByTable();
 $remoteGroupColumn = $table->getRemoteGroupColumn();
 $localGroupColumn = $table->getLocalGroupColumn();
 $tablesGroupedByThis = $table->getTablesGroupedByThis();
 $hasActivationFlag = $table->getHasActivationFlag();
 $columnForMultipleTemplates = $table->getColumnForMultipleTemplates();
 $dbEngine = $table->getDbEngine();
 if ($hasActivationFlag == '1') {
     $hasActivationFlag = ' checked';
 } else {
     $hasActivationFlag = '';
 }
 $availableForSearching = $table->getAvailableForSearching();
 if ($availableForSearching == '1') {
     $availableForSearching = ' checked';
 } else {
     $availableForSearching = '';