function setAccociationIDs($zuordnungstabellenname, $element_value, $element_id, $kerndaten_id, $block_bez, $block_id) { $Bol = new BlumenbachOnline(); $messagediv = $element_id . "_message"; $response = new tx_xajax_response(); $response->assign($element_id, 'selected', 'selected'); $response->assign($element_id, 'value', $element_value); $query = ""; $a_element_value = array(); $a_element_value = preg_split("#\\|#", $element_value); // $anz_ids = sizeOf($a_element_value); $delete = true; $message = ""; foreach ($a_element_value as $element_value) { $query .= $Bol->setAssociatedIDs($zuordnungstabellenname, $element_value, $kerndaten_id, $block_bez, $block_id, $delete); $delete = false; //bei BlockIII nur beim ersten Eintrag den Datensatz löschen if ($element_value != "") { $message .= '<div style="font-size:11px;"><span style="color:red">ID ' . $element_value . '</span> has been associated successfully to segment <strong>' . $block_bez . '</strong> with <strong>ID ' . $block_id . '</strong></div>'; } else { $message .= '<div style="font-size:11px;">This arrangement has been deleted successfully from segment <strong>' . $block_bez . '</strong> with <strong>ID ' . $block_id . '</strong></div>'; } } //$message .= $query; // Message // $message = "<span style='color:red'>".$element_value." wurde erfolgreich zugeordnet!</span>"; $response->assign($messagediv, 'style.display', 'none'); $response->assign($messagediv, 'innerHTML', $message); // $response->assign($messagediv, 'innerHTML', $message.$query); $response->assign($messagediv, 'style.display', 'block'); return $response; // return $response->getXML(); }
function getDBDumpfile() { $response = new tx_xajax_response(); include_once t3lib_extMgm::extPath('bolonline') . "/pi1/db_backup.php"; $content = 'Aktueller Datenbankbackup: <a style="text-decoration:underline" target="_blank" href="' . $backuplink_rel . $backupfile . '">' . $backupfile . '</a>'; $response->assign('db_backuplink', 'style.display', 'none'); $response->assign('db_backuplink', 'innerHTML', $content); $response->assign('db_backuplink', 'style.display', 'block'); return $response; //} }
function getGNDData($person, $div_id, $divid_gnd_id, $divid_person) { $debug = false; $content = ""; $response = new tx_xajax_response(); $erg = gndSearch($person); //echo '<xmp>' . print_r($erg, 1) . '</xmp>'; foreach ($erg as $values) { //id="'.$div_id.'" onMouseOver="document.getElementById(\''.$div_id.'\').style.backgroundColor=\'orange\'" $dividtmp = md5($values['name']); $content .= '<div id="' . $dividtmp . '" onMouseOut="document.getElementById(\'' . $dividtmp . '\').style.backgroundColor=\'#769AFC\'" onMouseOver="document.getElementById(\'' . $dividtmp . '\').style.backgroundColor=\'orange\'" style="height:11px;padding:5px;border: 1px solid gray;background-color:#769AFC" onClick="xajax_putGNDValues(\'' . $values["id"] . '\',\'' . $divid_gnd_id . '\',\'' . $values["name"] . '\',\'' . $divid_person . '\');document.getElementById(\'' . $div_id . '\').style.marginTop=\'10px\';document.getElementById(\'' . $div_id . '\').style.display=\'none\';">' . $values['name'] . '</div>'; } $response->assign($div_id, 'style.display', 'none'); $response->assign($div_id, 'innerHTML', $content); $response->assign($div_id, 'style.display', 'block'); return $response; }
function getGettyData($ort, $div_id, $divid_getty_id, $divid_ort, $divid_koordinaten) { $debug = false; $content = ""; $response = new tx_xajax_response(); $erg = gettySearch($ort); //echo '<xmp>' . print_r($erg, 1) . '</xmp>'; $content = '<div style="background-color:#555555;padding: 5px;color:white;border: 1px solid black;border-bottom:0px;font-size:0.9em"><u onClick="document.getElementById(\'' . $div_id . '\').style.display=\'none\'">schließen</u></div>'; foreach ($erg as $values) { //id="'.$div_id.'" onMouseOver="document.getElementById(\''.$div_id.'\').style.backgroundColor=\'orange\'" $dividtmp = md5($values['name']); $content .= '<div id="' . $dividtmp . '" onMouseOut="document.getElementById(\'' . $dividtmp . '\').style.backgroundColor=\'#769AFC\'" onMouseOver="document.getElementById(\'' . $dividtmp . '\').style.backgroundColor=\'orange\'" style="height:11px;padding:5px;border: 1px solid gray;background-color:#769AFC" onClick="xajax_putGettyValues(\'' . $values["id"] . '\',\'' . $divid_getty_id . '\',"' . $values["name"] . '",\'' . $divid_ort . '\',\'' . preg_replace("|'|", "\\'", $values["coordinates"]) . '\',\'' . $divid_koordinaten . '\');document.getElementById(\'' . $div_id . '\').style.marginTop=\'10px\';document.getElementById(\'' . $div_id . '\').style.display=\'none\';">' . $values['name'] . '</div>'; //id="'.$div_id.'" onMouseOver="document.getElementById(\''.$div_id.'\').style.backgroundColor=\'orange\'" // $content .= '<div style="height:11px;padding:5px;border: 1px solid gray;background-color:lightgrey" onClick="xajax_putGettyValues(\''.$values["id"].'\',\''.$divid_getty_id.'\',\''.$values["name"].'\',\''.$divid_ort.'\',\''.preg_replace("|'|","\'",$values["coordinates"]).'\',\''.$divid_koordinaten.'\');document.getElementById(\''.$div_id.'\').style.display=\'none\';">'.$values['name'].'</div>'; // auswahlmenue wieder ausblenden: document.getElementById(\''.$div_id.'_autofill\').style.display=\'none\'"> } $response->assign($div_id, 'style.display', 'none'); $response->assign($div_id, 'innerHTML', $content); $response->assign($div_id, 'style.display', 'block'); return $response; }
function delImage($id, $tablename) { $Bol = new BlumenbachOnline(); $response = new tx_xajax_response(); if (!$id > 0) { return ""; } $response = new tx_xajax_response(); $deleted = (bool) false; $deleted = $Bol->deleteMediafile($id, $tablename) . ':<br />'; if ($deleted) { $content .= 'Bild "' . $id . '" wurde erfolgreich gelöscht!' . "\n"; } else { $content .= '<span style="color:red">Bild "' . $id . '" konnte nicht gelöscht werden!</span>' . "\n"; } // if ($_SESSION['todo'] != 'update') // $content = ''; $response->assign('bild_' . $id, 'style.display', 'none'); $response->assign('bild_' . $id, 'innerHTML', $content); $response->assign('bild_' . $id, 'style.display', 'block'); return $response; }
/** * Returns an XML document * @param int $quid: question UID * @return string xml-document */ function getAjaxDetails($quid) { $quid = intval($quid); $nr = 0; $sOut = ''; //$template = str_replace('\"', '', $template); $template = $this->cObj->getSubpart($this->templateCode, "###TEMPLATE_DETAILS_ITEM###"); //$template_item = preg_replace('/\r?\n/', " ", $template_item); //$template_item = str_replace("'", '"', $template_item); $template = str_replace('###PREFIX###', $this->prefixId, $template); $result = $GLOBALS['TYPO3_DB']->exec_SELECTquery('COUNT(*) anzahl', 'tx_myquizpoll_relation', 'LENGTH(textinput)>0 AND question_id=' . $quid, '', '', ''); $rowA = $GLOBALS['TYPO3_DB']->sql_fetch_assoc($result); $gesamt = $rowA['anzahl']; $GLOBALS['TYPO3_DB']->sql_free_result($result); if ($gesamt > 0) { $result = $GLOBALS['TYPO3_DB']->exec_SELECTquery('DISTINCT textinput texte, COUNT( textinput ) anzahl', 'tx_myquizpoll_relation', 'LENGTH(textinput)>0 AND question_id=' . $quid, 'textinput', '', ''); $rows = $GLOBALS['TYPO3_DB']->sql_num_rows($result); if ($rows > 0) { while ($rowA = $GLOBALS['TYPO3_DB']->sql_fetch_assoc($result)) { if ($nr % 2 == 0) { $even_odd = 'even'; } else { $even_odd = 'odd'; } $prozent = number_format(100 * $rowA['anzahl'] / $gesamt, 2, ',', ' '); //$texte = preg_replace("/(\r\n)+|(\n|\r)+/", "<br />", $rowA['texte']); // nl2br funktioniert auch nicht $texte = str_replace('\\r\\n', '<br />', htmlspecialchars($rowA['texte'])); $temp = str_replace('###ITEM_EVEN_ODD###', $even_odd, $template); $temp = str_replace('###ITEM_ANSWER###', $texte, $temp); $temp = str_replace('###ITEM_PERCENT###', $prozent, $temp); $temp = str_replace('###ITEM_COUNTS###', $rowA['anzahl'], $temp); $sOut .= $temp; $nr++; } } } /* instantiate the xajaxResponse object */ $objResponse = new tx_xajax_response(); $objResponse->addScript("document.getElementById('details_hidden-{$quid}').style.display='block'; document.getElementById('show_details-{$quid}').style.display='none';"); /* We alter the contents of the HTML element. The property 'innerHTML' is the html code inside this element. We replace it with the result in our $sOut variable */ $objResponse->addAssign("details-{$quid}", "innerHTML", $sOut); /* With the getXML() method on the xajaxResponse objectwe send everything back to the client */ return $objResponse->getXML(); }
public function refreshFiltersOnload($data) { // initializes plugin configuration $this->init(); // set pivars $this->piVars = $data[$this->prefixId]; foreach ($this->piVars as $key => $value) { $this->piVars[$key] = $value; } // init javascript onclick actions $this->initOnclickActions(); // reset filters? if ($this->piVars['resetFilters'] && is_array($this->piVars['filter'])) { foreach ($this->piVars['filter'] as $key => $value) { // do not reset the preselected filters if ($this->preselectedFilter[$key]) { $this->piVars['filter'][$key] = $this->preselectedFilter[$key]; } else { $this->piVars['filter'][$key] = ''; } } } // make xajax response object $objResponse = new tx_xajax_response(); // generate onload image $this->onloadImage = $this->createHideSpinner(); // set filters $objResponse->addAssign('kesearch_filters', 'innerHTML', $this->renderFilters() . $this->onloadImage); // return response xml return $objResponse->getXML(); }
/** * This is the main communications engine of xajax. The engine handles all * incoming xajax requests, calls the apporiate PHP functions (or * class/object methods) and passes the XML responses back to the * Javascript response handler. If your RequestURI is the same as your Web * page then this function should be called before any headers or HTML has * been sent. */ function processRequests() { $requestMode = -1; $sFunctionName = ""; $bFoundFunction = true; $bFunctionIsCatchAll = false; $sFunctionNameForSpecial = ""; $aArgs = array(); $sPreResponse = ""; $bEndRequest = false; $requestMode = $this->getRequestMode(); if ($requestMode == -1) { return; } if ($requestMode == XAJAX_POST) { $sFunctionName = $_POST["xajax"]; if (!empty($_POST["xajaxargs"])) { $aArgs = $_POST["xajaxargs"]; } } else { header("Expires: Mon, 26 Jul 1997 05:00:00 GMT"); header("Last-Modified: " . gmdate("D, d M Y H:i:s") . " GMT"); header("Cache-Control: no-cache, must-revalidate"); header("Pragma: no-cache"); $sFunctionName = $_GET["xajax"]; if (!empty($_GET["xajaxargs"])) { $aArgs = $_GET["xajaxargs"]; } } // Use xajax error handler if necessary if ($this->bErrorHandler) { $GLOBALS['xajaxErrorHandlerText'] = ""; set_error_handler("xajaxErrorHandler"); } if ($this->sPreFunction) { if (!$this->_isFunctionCallable($this->sPreFunction)) { $bFoundFunction = false; $oResponse = new tx_xajax_response(); $oResponse->addAlert("Unknown Pre-Function " . $this->sPreFunction); } } //include any external dependencies associated with this function name if (array_key_exists($sFunctionName, $this->aFunctionIncludeFiles)) { ob_start(); include_once $this->aFunctionIncludeFiles[$sFunctionName]; ob_end_clean(); } if ($bFoundFunction) { $sFunctionNameForSpecial = $sFunctionName; if (!array_key_exists($sFunctionName, $this->aFunctions)) { if ($this->sCatchAllFunction) { $sFunctionName = $this->sCatchAllFunction; $bFunctionIsCatchAll = true; } else { $bFoundFunction = false; $oResponse = new tx_xajax_response(); $oResponse->addAlert("Unknown Function {$sFunctionName}."); } } } if ($bFoundFunction) { for ($i = 0; $i < sizeof($aArgs); $i++) { // If magic quotes is on, then we need to strip the slashes from the args if (get_magic_quotes_gpc() == 1 && is_string($aArgs[$i])) { $aArgs[$i] = stripslashes($aArgs[$i]); } if (stristr($aArgs[$i], "<xjxobj>") != false) { $aArgs[$i] = $this->_xmlToArray("xjxobj", $aArgs[$i]); } else { if (stristr($aArgs[$i], "<xjxquery>") != false) { $aArgs[$i] = $this->_xmlToArray("xjxquery", $aArgs[$i]); } else { if ($this->bDecodeUTF8Input) { $aArgs[$i] = $this->_decodeUTF8Data($aArgs[$i]); } } } } if ($this->sPreFunction) { $mPreResponse = $this->_callFunction($this->sPreFunction, array($sFunctionNameForSpecial, $aArgs)); if (is_array($mPreResponse) && $mPreResponse[0] === false) { $bEndRequest = true; $sPreResponse = $mPreResponse[1]; } else { $sPreResponse = $mPreResponse; } if ($bEndRequest) { $oResponse = $sPreResponse; } } if (!$bEndRequest) { if (!$this->_isFunctionCallable($sFunctionName)) { $oResponse = new tx_xajax_response(); $oResponse->addAlert("The Registered Function {$sFunctionName} Could Not Be Found."); } else { if ($bFunctionIsCatchAll) { $aArgs = array($sFunctionNameForSpecial, $aArgs); } $oResponse = $this->_callFunction($sFunctionName, $aArgs); } if (is_string($sResponse)) { $oResponse = new tx_xajax_response(); $oResponse->addAlert("No XML Response Was Returned By Function {$sFunctionName}.\n\nOutput: " . $oResponse); } else { if ($sPreResponse != "") { $oNewResponse = new tx_xajax_response($this->sEncoding, $this->bOutputEntities); $oNewResponse->loadXML($sPreResponse); $oNewResponse->loadXML($oResponse); $oResponse = $sNewResponse; } } } } $sContentHeader = "Content-type: text/xml;"; if ($this->sEncoding && strlen(trim($this->sEncoding)) > 0) { $sContentHeader .= " charset=" . $this->sEncoding; } header($sContentHeader); if ($this->bErrorHandler && !empty($GLOBALS['xajaxErrorHandlerText'])) { $oErrorResponse = new tx_xajax_response(); $oErrorResponse->addAlert("** PHP Error Messages: **" . $GLOBALS['xajaxErrorHandlerText']); if ($this->sLogFile) { $fH = @fopen($this->sLogFile, "a"); if (!$fH) { $oErrorResponse->addAlert("** Logging Error **\n\nxajax was unable to write to the error log file:\n" . $this->sLogFile); } else { fwrite($fH, "** xajax Error Log - " . strftime("%b %e %Y %I:%M:%S %p") . " **" . $GLOBALS['xajaxErrorHandlerText'] . "\n\n\n"); fclose($fH); } } $oErrorResponse->loadXML($oResponse); $oResponse = $oErrorResponse; } if ($this->bCleanBuffer) { while (@ob_end_clean()) { } } print $oResponse->getOutput(); if ($this->bErrorHandler) { restore_error_handler(); } if ($this->bExitAllowed) { exit; } }
/** * Shows all records which are visible on the map (not all which are available through selected categories!) * * @param string $area: the area of the map * @return all available (=visible) records */ function activeRecords($area) { // template $template['allrecords'] = $this->cObj2->getSubpart($this->templateCode, '###TEMPLATE_ACTIVERECORDS###'); $template["item"] = $this->cObj2->getSubpart($template["allrecords"], "###SINGLE###"); // build the query $areaArr = preg_split('/%2C%20/', $area); $where = 'hidden= 0 AND deleted = 0 AND pid IN(' . $this->config['pid_list'] . ') AND lng between ' . $areaArr[1] . ' AND ' . $areaArr[3] . ' AND lat between ' . $areaArr[0] . ' AND ' . $areaArr[2]; $catList = $GLOBALS["TSFE"]->fe_user->getKey('ses', 'data2') ? $GLOBALS["TSFE"]->fe_user->getKey('ses', 'data2') : explode(',', $this->config['categories']); foreach ($catList as $key => $value) { $where2 .= ' FIND_IN_SET(' . $value . ',rggmcat) OR'; } $where .= ' AND ( ' . substr($where2, 0, -3) . ' ) '; $table = $this->config['tables']; $field = '*'; // query $res = $this->generic->exec_SELECTquery($field, $table, $where, $groupBy = '', $orderBy, $offset = ''); while ($row = array_shift($res)) { foreach ($row as $key => $value) { $markerArray['###' . strtoupper($key) . '###'] = $this->cObj->stdWrap($value, $this->conf['activeRecords.'][$key . '.']); } $content_item .= $this->cObj->substituteMarkerArrayCached($template["item"], $markerArray, array(), $wrappedSubpartArray); } $subpartArray["###CONTENT###"] = $content_item; $content .= $this->cObj2->substituteMarkerArrayCached($template['allrecords'], $markerArray, $subpartArray, $wrappedSubpartArray); $objResponse = new tx_xajax_response($GLOBALS['TSFE']->metaCharset); $objResponse->addAssign('rggooglemap-recordsonmap', 'innerHTML', $content); return $objResponse->getXML(); }