$sPR = $wo->db->query('select * from ' . $tableName . ' where ' . $remoteIdColumn . '=\'' . $_POST['itemId'] . '\' and objectId=\'' . $_POST['table'] . '\' order by ord');
while ($sP = $wo->db->fetchAssoc($sPR)) {
$fileInfo = pathinfo($sP['picture']);
if ($fileInfo['extension'] == 'pdf' || $fileInfo['extension'] == 'PDF') {
echo '<br/><div><a href="' . $siteBaseURL . $imagesRelativePath . $sP['picture'] . '" style="font-family: verdana; font-size: 12px; color: #000000;"><img src="../assets/pdfIcon.jpg" width="22" height="22"/>' . substr($sP['picture'], 20) . '</a> <br/>';
} else {
echo '<div><img src="' . $siteBaseURL . $imagesRelativePath . $sP['picture'] . '" width="88" height="62"> ';
}
$extraURLBit = '&table=' . $table->getTableId() . '&' . $remoteIdColumn . '=' . $_POST['itemId'];
$template = '';
/*
if ($row['active']=='1')
{
$template.='<a href="'. $_SERVER['PHP_SELF'] .'?action=deactivate&__address=1_'. $pictureTable->getTableName() .'_'. $sP['id'] .'" class="on">Active</a>
';
}else
{
$template.='<a href="'. $_SERVER['PHP_SELF'] .'?action=activate&__address=1_'. $pictureTable->getTableName() .'_'. $sP['id'] .'" class="off">Inctive</a>
';
}
*/
$template .= '<a href="administration.php?&__address=1_' . $pictureTable->getTableId() . '_' . $sP['id'] . '&action=edit' . $extraURLBit . '" target="_parent"><img src="images/edit.png" border="0" alt="Edit this item."></a>
';
$template .= '<a href="' . $_SERVER['PHP_SELF'] . '?action=moveUp&__address=1_' . $pictureTable->getTableId() . '_' . $sP['id'] . $extraURLBit . '"><img src="images/arrowUp.png" border="0" alt="Up this item in order"></a><a href="' . $_SERVER['PHP_SELF'] . '?action=moveDown&__address=1_' . $pictureTable->getTableName() . '_' . $sP['id'] . $extraURLBit . '"><img src="images/arrowDown.png" border="0" alt="Down this item in order"></a>
';
$template .= ' <a href="javascript:confirmDelete(\'' . $_SERVER['PHP_SELF'] . '?__address=1_' . $pictureTable->getTableId() . '_' . $sP['id'] . $extraURLBit . '&action=deleteItem\');"><img src="images/delete.png" border="0" alt="Delete this item"></a>
</div>
';
echo $template . ' </div><br/>';
}
echo '</div></body></html>';
orderingMirror=\'' . $wo->db->escape(trim($de['orderingMirror' . $c])) . '\',
searchingMirror=\'' . $wo->db->escape(trim($de['searchingMirror' . $c])) . '\',
resizeWidth=\'' . $wo->db->escape(trim($de['resizeWidth' . $c])) . '\',
resizeHeight=\'' . $wo->db->escape(trim($de['resizeHeight' . $c])) . '\',
thumbnailWidth=\'' . $wo->db->escape(trim($de['thumbnailWidth' . $c])) . '\',
thumbnailHeight=\'' . $wo->db->escape(trim($de['thumbnailHeight' . $c])) . '\',
midSizeColumn=\'' . $wo->db->escape(trim($de['midSizeColumn' . $c])) . '\',
midSizeWidth=\'' . $wo->db->escape(trim($de['midSizeWidth' . $c])) . '\',
midSizeHeight=\'' . $wo->db->escape(trim($de['midSizeHeight' . $c])) . '\',
thumbnailColumn=\'' . $wo->db->escape(trim($de['thumbnailColumn' . $c])) . '\',
ordering=\'' . $wo->db->escape(trim($de['ordering' . $c])) . '\',
adminCSS=\'' . $wo->db->escape(trim($_POST['adminCSS' . $c])) . '\',
indexParticipation=\'' . $wo->db->escape(trim($_POST['indexParticipation' . $c])) . '\',
colCollation=\'' . $wo->db->escape(trim($_POST['colCollation' . $c])) . '\'
');
$query = 'ALTER TABLE ' . $table->getTableName() . ' ADD COLUMN ' . $wo->db->escape(trim($de['name'] . $_GET['suplec'])) . ' ' . WOOOF_dataBaseColumnTypes::getColumnTypeLiteral($wo->db->escape(trim($de['type' . $c])));
if ($wo->db->escape(trim($de['length' . $c])) != '') {
$query .= '(' . $wo->db->escape(trim($de['length' . $c])) . ')';
}
if ($wo->db->escape(trim($de['notNull' . $c])) == '1') {
$query .= ' NOT NULL ';
}
if ($wo->hasContent($wo->db->escape(trim($de['defaultValue' . $c])))) {
$query .= ' DEFAULT \'' . $wo->db->escape(trim($de['defaultValue' . $c])) . '\'';
}
if ($wo->hasContent($wo->db->escape(trim($de['colCollation' . $c])))) {
$query .= ' COLLATE \'' . $wo->db->escape(trim($de['colCollation' . $c])) . '\'';
}
//echo $query .'<br/>';
$wo->db->query($query);
}
$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">Προσθήκη Κεντρικού Κόμβου <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']) {
$columnsToShow = $column['name'];
}
/**
*
* @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;
}
}
$path = '';
foreach ($table->columns as $key => $value) {
$column = $value->getColumnMetaData();
if ($column['appearsInLists']) {
$columnsToShow = $column['name'];
}
}
if (count($addressItems) == 2 || $addressItems[2] == '') {
$whereClauses['parent_id'] = '-1';
$table->getResult($whereClauses, 'ord');
//$innerStuff ='<div id="listTitle"><a href="administration.php?action=edit&__address=1_'. $table->getTableId() .'_&wooofParent=-1">Προσθήκη '. $table->getTableDescription() .'</a></div>';
$actualRow['name'] = 'Μενού';
$additionLabel = '<a href="administration.php?action=edit&__address=1_' . $table->getTableId() . '_&wooofParent=-1">Προσθήκη ' . $table->getTableDescription() . '</a>';
} else {
$actualRow = $wo->db->getRow($table->getTableName(), $addressItems[2]);
$whereClauses['parent_id'] = $addressItems[2];
$table->getResult($whereClauses, $table->getOrderingColumnForListings());
$current_row['parent_id'] = $addressItems[2];
$treeLevel = 0;
do {
$treeLevel++;
$current_row = $wo->db->getRow($table->getTableName(), $current_row['parent_id']);
if ($addressItems[2] == $current_row['id']) {
$path = ' > ' . $current_row[$table->columns[$counter]->getName()] . $path;
} else {
$path = ' > <a href="improvedTree.php?__address=1_' . $table->getTableId() . '_' . $current_row['id'] . '&action=read">' . $current_row[$table->columns[$counter]->getName()] . '</a>' . $path;
}
} while ($current_row['parent_id'] != '-1');
$path = '<div id="pathDivision"><a href="improvedTree.php?__address=1_' . $table->getTableId() . '&action=read">' . $table->getTableDescription() . '</a>' . $path . '</div>';
$additionLabel = 'Προσθήκη υπομενού στο "' . $actualRow[$columnsToShow] . '"';
$showIdInAdminLists = '';
$showIdInAdminForms = '';
$dbEngine = '';
} else {
if (isset($_GET['table'])) {
$table = new WOOOF_dataBaseTable($wo->db, $wo->db->escape(trim($_GET['table'])));
$action = 'edit';
$description = $table->getTableDescription();
$subtableDescription = $table->getSubTableDescription();
$presentationDefault[1] = '';
$presentationDefault[2] = '';
$presentationDefault[3] = '';
$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();
thumbnailHeight=\'' . $wo->db->escape(trim($_POST['thumbnailHeight' . $c])) . '\',
midSizeColumn=\'' . $wo->db->escape(trim($_POST['midSizeColumn' . $c])) . '\',
midSizeWidth=\'' . $wo->db->escape(trim($_POST['midSizeWidth' . $c])) . '\',
midSizeHeight=\'' . $wo->db->escape(trim($_POST['midSizeHeight' . $c])) . '\',
thumbnailColumn=\'' . $wo->db->escape(trim($_POST['thumbnailColumn' . $c])) . '\',
ordering=\'' . $wo->db->escape(trim($_POST['ordering' . $c])) . '\',
adminCSS=\'' . $wo->db->escape(trim($_POST['adminCSS' . $c])) . '\',
indexParticipation=\'' . $wo->db->escape(trim($_POST['indexParticipation' . $c])) . '\',
colCollation=\'' . $wo->db->escape(trim($_POST['colCollation' . $c])) . '\'
');
if ($succ === FALSE) {
$wo->handleShowStopperError();
}
if ($_POST['isForeignKey' . $c] == '1') {
$foreignKeyExists = FALSE;
$result = $wo->db->query('SHOW INDEX FROM ' . $t->getTableName());
while ($row = $wo->db->fetchAssoc($result)) {
if ($row['Key_name'] == 'FK_' . $t->getTableName() . '_' . $wo->db->escape(trim($_POST['name' . $c]))) {
$foreignKeyExists = TRUE;
}
}
if ($foreignKeyExists) {
$wo->db->query('DROP FOREIGN KEY FK_' . $t->getTableName() . '_' . $wo->db->escape(trim($_POST['name' . $c])));
}
$succ = $wo->db->query('ALTER TABLE ' . $t->getTableName() . ' ADD FOREIGN KEY FK_' . $t->getTableName() . '_' . $wo->db->escape(trim($_POST['name' . $c])) . ' REFERENCES ' . $wo->db->escape(trim($_POST['valuesTable' . $c])) . ' (' . $wo->db->escape(trim($_POST['columnToStore' . $c])) . ')
ON DELETE RESTRICT
ON UPDATE CASCADE');
}
if ($succ === FALSE) {
$wo->handleShowStopperError();
}
