/** * Partial action that lists favorite objects * @author Steve Ryan steve@2pisoftware.com 2015 */ function listfavorite_ALL(Web $w, $params) { $user = $w->Auth->user(); if (!empty($user)) { $results = $w->Favorite->getDataByUser($user->id); $favoritesCategorised = array(); $service = new DBService($w); if (!empty($results)) { foreach ($results as $k => $favorite) { if (!array_key_exists($favorite->object_class, $favoritesCategorised)) { $favoritesCategorised[$favorite->object_class] = array(); } $realObject = $service->getObject($favorite->object_class, $favorite->object_id); if (!empty($realObject)) { $templateData = array(); $templateData['title'] = $realObject->printSearchTitle(); $templateData['url'] = $realObject->printSearchUrl(); $templateData['listing'] = $realObject->printSearchListing(); if ($realObject->canList($user) && $realObject->canView($user)) { array_push($favoritesCategorised[$favorite->object_class], $templateData); } } } } $w->ctx('categorisedFavorites', $favoritesCategorised); } }
public static function makeParam($reportID, $reportParameterID) { $parm = null; $db = new DBService(); $result = $db->query("SELECT rp.*, rpm.parentReportParameterID\n FROM ReportParameter rp, ReportParameterMap rpm\n WHERE rp.reportParameterID = '{$reportParameterID}' LIMIT 1")->fetchRow(MYSQLI_ASSOC); if ($result['parameterDisplayPrompt'] === 'Provider / Publisher') { $parm = new ProviderPublisherParameter($reportID, $db, $result); } else { if ($result['parameterDisplayPrompt'] === 'Provider') { $parm = new ProviderParameter($reportID, $db, $result); } else { if ($result['parameterDisplayPrompt'] === 'Publisher') { $parm = new PublisherParameter($reportID, $db, $result); } else { if ($result['parameterTypeCode'] === 'chk') { if ($result['parameterDisplayPrompt'] === "Do not adjust numbers for use violations") { $parm = new CheckUnadjustedParameter($reportID, $db, $result); } else { $parm = new CheckboxParameter($reportID, $db, $result); } } else { if ($result['parameterTypeCode'] === 'dd') { if ($result['parameterAddWhereClause'] === 'limit') { $parm = new LimitParameter($reportID, $db, $result); } else { if ($result['parameterDisplayPrompt'] === 'Year') { $parm = new YearParameter($reportID, $db, $result); } else { if ($result['parameterDisplayPrompt'] === 'Date Range') { $parm = new DateRangeParameter($reportID, $db, $result); } else { $parm = new DropdownParameter($reportID, $db, $result); } } } } else { if ($result['parameterTypeCode'] === 'ms') { if ($result['parameterDisplayPrompt'] === 'Provider / Publisher' || $result['parameterDisplayPrompt'] === 'Provider' || $result['parameterDisplayPrompt'] === 'Publisher') { $parm = new ProviderPublisherDropdownParameter($reportID, $db, $result); } else { $parm = new MultiselectParameter($reportID, $db, $result); } } else { if ($result['parameterTypeCode'] === 'txt') { $parm = new TextParameter($reportID, $db, $result); } else { $parm = new Parameter($reportID, $db, $result); } } } } } } } return $parm; }
public function run($archiveInd, $ADD_WHERE1, $ADD_WHERE2, $orderBy) { if (stripos($this->sql, 'mus')) { $ch = 'm'; } else { $ch = 'y'; } $sql = str_replace('ADD_WHERE', "{$ADD_WHERE1} AND {$ch}" . "us.archiveInd = {$archiveInd}", str_replace('ADD_WHERE2', $ADD_WHERE2, $this->sql)) . $orderBy; $db = new DBService(Config::$database->{$this->getDBName()}); return $db->query($sql); }
public function loadLoki() { $db = new DBService(); $conn = $db->createPDOConnection(); $sql = "SELECT data FROM lokidbs where name = ?"; $query = $conn->prepare($sql); $query->execute(array($this->lokiName)); if ($query->rowCount() > 0) { $row = $query->fetch(PDO::FETCH_ASSOC); $str = $row["data"]; return $str; } else { return null; } }
public function invokeHandler(RequestData $data, $search = "") { $order_by = $data->get("order_by", "updated"); $search_by = $data->get("search_by", "title"); $categories = $data->get("categories", array()); $language = $data->get("language", ""); $type = $data->get("type", ""); $stories = new Stories(); $stories->RELEVANCE = empty($search) ? 0 : 0.1; $stories->setCategories($categories); $stories->setClasses($type, $language); if ($search_by == 'title') { $stories_results = $stories->searchByTitle($search, 0, $order_by); } else { if ($search_by == 'text') { $stories_results = $stories->searchByText($search, 0, $order_by); } else { $stories_results = $stories->searchByAll($search, 0, $order_by); } } if (count($stories_results)) { // echo "REPLACE INTO search_cache(search_text) values(".$search.")"; $RDb = DBService::getDB(); $res = $RDb->update("REPLACE INTO search_cache(search_text) values('" . $search . "')"); } // print_r($stories->get(0)); return $stories_results; }
public function db() { if (!$this->db) { $this->db = DBService::get_connection($this->get_service_id()); } return $this->db; }
public static function setDatabase(mysqli $db) { self::$db = null; if ($db && $db->ping()) { self::$db = $db; return true; } return false; }
public function value() { if (isset($_REQUEST["prm_{$this->id}"])) { $val = trim(DBService::escapeString($_REQUEST["prm_{$this->id}"])); if ($val !== '') { return $val; } } return null; }
/** * * @param Smarty $viewModel * @param Header $header * @param DataModel $dataModel * @param User $user * @param string $view * @param string $module * @return string */ public function invokeHandler(User $user, $view = "empty", $module = "index_page", RequestData $data, $info = "NO") { if ($info == "STATS") { return new WebSite(); } else { if ($info == "CATEGORIES") { return new Categories(); } else { if ($info == "CLASSES") { $RDb = DBService::getDB(); return $RDb->fetchAll("SELECT class_id id, class_name name, classtype_id, classtype_name,classtype_title\n\t\t\t\t\tFROM `fanfiction_classes` as c,fanfiction_classtypes as ct \n\t\t\t\t\tWHERE ct.classtype_id=c.class_type"); } } } return $data; }
public function invokeHandler(RequestData $data) { $search = $data->get("search", ""); $response = array(); $RDb = DBService::getDB(); $res = $RDb->fetchAll("SELECT * FROM search_cache\n\t\t\t\tWHERE UPPER(search_text) like UPPER(%s)\n\t\t\t\tORDER BY search_text", "'%" . $search . "%'"); if (count($res) == 0) { $res = $RDb->fetchAll("SELECT title as search_text FROM fanfiction_stories\n\t\t\t\t\tWHERE UPPER(title) like UPPER(%s)\n\t\t\t\t\tORDER BY title", "'%" . $search . "%'"); } if (count($res) == 0) { $response['error'] = true; return false; } else { $response['data'] = $res; $response['error'] = false; return $response; } }
static function close() { DBService::get_instance()->__destruct(); }
public static function getConnection(DBService $connector) { return $connector->getConnection(); }
<?php include_once 'bootstrap.php'; Config::init(); if (isset($_POST['step'])) { $step = $_POST['step']; } else { $step = 0; } $errorMessage = array(); if ($step == "1") { $dbservice = new DBService(); //make sure SQL file exists $test_sql_file = "test_create.sql"; $sql_file = "create_tables_data.sql"; if (!file_exists($test_sql_file)) { $errorMessage[] = "Could not open sql file: " . $test_sql_file . ". If this file does not exist you must download new install files."; } else { //run the file - checking for errors at each SQL execution $f = fopen($test_sql_file, "r"); $sqlFile = fread($f, filesize($test_sql_file)); $sqlArray = explode(";", $sqlFile); //Process the sql file by statements foreach ($sqlArray as $stmt) { if (strlen(trim($stmt)) > 3) { //replace the DATABASE_NAME parameter with what was actually input $stmt = str_replace("_DATABASE_NAME_", Config::$database->name, $stmt); try { $result = $dbservice->query($stmt); } catch (RuntimeException $exception) { $errorMessage[] = $dbservice->error() . "<br /><br />For statement: " . $stmt;
public function publisherNotes() { $db = new DBService(Config::$database->{$this->dbname}); return $db->query("SELECT startYear, endYear, noteText, reportDisplayName\n\t\t\t\tFROM PublisherPlatformNote pn, PublisherPlatform pp\n\t\t\t\tWHERE pp.publisherPlatformID = pn.publisherPlatformID\n\t\t\t\tAND pp.publisherPlatformID in (" . $db->sanitize(join(',', array_keys($this->pubIDs))) . ");")->fetchRows(MYSQLI_ASSOC); }
<?php $page = "impressum"; require_once '../scr/classes/db/DBConnection.php'; require_once '../scr/classes/db/DBService.php'; $db = new DBService(); if (isset($_POST["save_button"])) { $db->updateContent($_POST["impressum"], $db->findContentIdByPageName($page)); } $content = $db->findContent($page, NULL); ?> <!DOCTYPE html> <html lang="en"> <head> <script src="../ckeditor/ckeditor.js"></script> </head> <body> <form class="form-horizontal" action='' method="POST" accept-charset="utf-8"> <textarea name="impressum" id="impressum" rows="10" cols="80"> <?php echo $content['content']; ?> </textarea> <script> CKEDITOR.replace('impressum'); </script> <input type="submit" value="Speichern" name="save_button" /> </form> </body> </html>
public function reportIdProvider() { $db = new DBService(); $ids = array(); foreach ($db->query("SELECT reportID FROM Report")->fetchRows(MYSQLI_ASSOC) as $report) { $ids[] = array($report['reportID']); } return $ids; }
function saint_exception_handler($e) { $l = ob_get_level(); while ($l--) { ob_end_clean(); } # manually attempt to close all db connections DBService::close(); if (SHELL) { $e->log(); } else { Usher::handle_error($e); } exit; }
</td> </tr> <tr> <td class="fullborder"><br /> <br /> <div id='div_report'> <label for="reportID"> <?php echo _("Select Report"); ?> </label> <select name='reportID' id='reportID' class='opt'> <option value=''></option> <?php // get all reports for output in drop down $db = new DBService(); foreach ($db->query("SELECT reportID, reportName FROM Report ORDER BY 2, 1")->fetchRows(MYSQLI_ASSOC) as $report) { echo "<option value='" . $report['reportID'] . "' "; if (isset($report['reportID']) && isset($_GET['reportID']) && $report['reportID'] === $_GET['reportID']) { echo 'selected'; } echo ">" . $report['reportName'] . "</option>"; } unset($db); ?> </select> </div> <div id='div_parm'> <?php if (isset($_GET['reportID'])) { $reportID = $_GET['reportID'];
public static function initDB($configname) { if (!self::$connected) { include_once "db/AbstractDb.php"; self::$connected = true; } self::$map[$configname] = new AbstractDb(Config::getSection($configname)); return self::$map[$configname]; }