Пример #1
0
 public function getProgramList($lang = false, $category = false, $offset = 0)
 {
     $programList = array();
     $bindParams = array();
     if (empty($lang) && empty($category)) {
         IndexController::$isHomePage = true;
     }
     $pidCol = ProgramDetails_DBTable::PROGRAM_ID;
     $langCol = ProgramDetails_DBTable::FK_LANGUAGE_ID;
     $cateCol = ProgramDetails_DBTable::FK_CATEGORY_ID;
     $limit = UserPreferencesController::get(PreferenceKeys::PAGINATOR_LIMIT);
     $limit = empty($limit) ? Constants::PAGINATOR_LIMIT : $limit;
     $totalRecordCount = (new ProgramDetailsController())->getAllRecordCount();
     $this->processPaginator($offset, $limit, $totalRecordCount);
     $query = 'SELECT ' . ProgramDetails_DBTable::DB_TABLE_NAME . '.*,' . Users_DBTable::DB_TABLE_NAME . '.' . Users_DBTable::USER_NAME . ' AS created_by,' . Category_DBTable::DB_TABLE_NAME . '.' . Category_DBTable::CATEGORY_NAME . ' AS category_name,' . Language_DBTable::DB_TABLE_NAME . '.' . Language_DBTable::LANGUAGE_NAME . ' AS language_name FROM ' . ProgramDetails_DBTable::DB_TABLE_NAME . ' INNER JOIN ' . Category_DBTable::DB_TABLE_NAME . ' ON ' . Category_DBTable::DB_TABLE_NAME . '.' . Category_DBTable::CATEGORY_ID . ' = ' . ProgramDetails_DBTable::DB_TABLE_NAME . '.' . ProgramDetails_DBTable::FK_CATEGORY_ID . ' INNER JOIN ' . Language_DBTable::DB_TABLE_NAME . ' ON ' . Language_DBTable::DB_TABLE_NAME . '.' . Language_DBTable::LANGUAGE_ID . ' = ' . ProgramDetails_DBTable::DB_TABLE_NAME . '.' . ProgramDetails_DBTable::FK_LANGUAGE_ID . ' INNER JOIN ' . Users_DBTable::DB_TABLE_NAME . ' ON ' . Users_DBTable::DB_TABLE_NAME . '.' . Users_DBTable::USER_ID . ' = ' . ProgramDetails_DBTable::FK_CREATED_BY . ' WHERE ';
     if (!empty($lang)) {
         $bindParams[] = $lang;
         $query .= ProgramDetails_DBTable::DB_TABLE_NAME . '.' . ProgramDetails_DBTable::FK_LANGUAGE_ID . "=? AND ";
         if (!empty($category)) {
             $bindParams[] = $category;
             $query .= ProgramDetails_DBTable::DB_TABLE_NAME . '.' . ProgramDetails_DBTable::FK_CATEGORY_ID . "=? AND ";
         }
     }
     $query .= ProgramDetails_DBTable::DB_TABLE_NAME . '.' . ProgramDetails_DBTable::IS_DELETED . "= '0'";
     if (!empty($offset) && is_numeric($offset)) {
         $query .= ' LIMIT ' . $offset . ', ' . $limit;
     } else {
         $query .= ' LIMIT ' . $limit;
     }
     $resultSet = DBManager::executeQuery($query, $bindParams, true);
     return $resultSet;
 }
Пример #2
0
 public function getSourceDetails($lang, $category, $pid)
 {
     $query = 'SELECT ' . ProgramDetails_DBTable::DB_TABLE_NAME . '.*,' . Category_DBTable::DB_TABLE_NAME . '.' . Category_DBTable::CATEGORY_NAME . ' AS category_name,' . Language_DBTable::DB_TABLE_NAME . '.' . Language_DBTable::LANGUAGE_NAME . ' AS language_name FROM ' . ProgramDetails_DBTable::DB_TABLE_NAME . ' INNER JOIN ' . Category_DBTable::DB_TABLE_NAME . ' ON ' . Category_DBTable::DB_TABLE_NAME . '.' . Category_DBTable::CATEGORY_ID . ' = ' . ProgramDetails_DBTable::DB_TABLE_NAME . '.' . ProgramDetails_DBTable::FK_CATEGORY_ID . ' INNER JOIN ' . Language_DBTable::DB_TABLE_NAME . ' ON ' . Language_DBTable::DB_TABLE_NAME . '.' . Language_DBTable::LANGUAGE_ID . ' = ' . ProgramDetails_DBTable::DB_TABLE_NAME . '.' . ProgramDetails_DBTable::FK_LANGUAGE_ID . ' WHERE ' . ProgramDetails_DBTable::DB_TABLE_NAME . '.' . ProgramDetails_DBTable::PROGRAM_ID . "=? AND " . ProgramDetails_DBTable::DB_TABLE_NAME . '.' . ProgramDetails_DBTable::FK_LANGUAGE_ID . "=? AND " . ProgramDetails_DBTable::DB_TABLE_NAME . '.' . ProgramDetails_DBTable::FK_CATEGORY_ID . "=? AND " . ProgramDetails_DBTable::DB_TABLE_NAME . '.' . ProgramDetails_DBTable::IS_DELETED . "= '0'";
     $bindParams = array($pid, $lang, $category);
     $resultSet = DBManager::executeQuery($query, $bindParams, true);
     return current($resultSet);
 }
Пример #3
0
 public function getUserDetailsByName($username)
 {
     $query = "SELECT * FROM " . Users_DBTable::DB_TABLE_NAME . " WHERE ";
     $query .= Users_DBTable::USER_NAME . " = ? AND " . Users_DBTable::IS_DELETED . " = 0";
     $userData = DBManager::executeQuery($query, array($username), true);
     return current($userData);
 }
Пример #4
0
 public function getFileInfoFromDB($pid)
 {
     $fileInfo = array();
     $query = "SELECT * FROM ";
     $query .= ProgramDetails_DBTable::DB_TABLE_NAME . " WHERE ";
     $query .= ProgramDetails_DBTable::PROGRAM_ID . "=? AND ";
     $query .= ProgramDetails_DBTable::IS_DELETED . "='0'";
     $resultSet = DBManager::executeQuery($query, array($pid), true);
     if (!empty($resultSet)) {
         $fileInfo = current($resultSet);
     }
     return $fileInfo;
 }
Пример #5
0
 public function getLanguageWiseMatchingDataset($searchString)
 {
     $keywords = explode(" ", $searchString);
     $query = "SELECT program_details.*, category.name AS category_name, language.name AS language_name, users.user_name\n            FROM program_details INNER JOIN category ON category.id = program_details.fk_category INNER JOIN\n            language ON language.id = program_details.fk_language INNER JOIN users ON users.id=program_details.fk_created_by\n            WHERE program_details.is_deleted = 0 AND (";
     $whereClause = array();
     $bindParam = array();
     foreach ($keywords as $key => $keyword) {
         $whereClause[] = " program_details.fk_language LIKE :searchQuery{$key} OR language.name LIKE :searchQuery{$key} ";
         $bindParam['searchQuery' . $key] = '%' . trim($keyword) . '%';
     }
     $query .= implode(" OR ", $whereClause) . ');';
     $resultSet = DBManager::executeQuery($query, $bindParam, true);
     return $resultSet;
 }
Пример #6
0
 public function getLastInsertedRecord($userId, $datetime, $filename)
 {
     $query = 'SELECT * FROM ' . ProgramDetails_DBTable::DB_TABLE_NAME . ' WHERE ';
     $query .= ProgramDetails_DBTable::STORED_FILE_NAME . " = '" . $filename . "' AND ";
     $query .= ProgramDetails_DBTable::CREATED_ON . " = '" . $datetime . "' AND ";
     $query .= ProgramDetails_DBTable::FK_CREATED_BY . " = '" . $userId . "' AND ";
     $query .= ProgramDetails_DBTable::IS_DELETED . " = 0 LIMIT 1";
     $result = DBManager::executeQuery($query, array(), true);
     if ($result) {
         $row = current($result);
         return $row[ProgramDetails_DBTable::PROGRAM_ID];
     }
     return false;
 }
Пример #7
0
 /**
  * Delete given program from system
  * 
  * @param int $pid
  * @return boolean
  */
 public function deleteProgram($pid)
 {
     $programInfo = $this->getProgramListById($pid);
     $query = "UPDATE " . ProgramDetails_DBTable::DB_TABLE_NAME . " SET ";
     $query .= ProgramDetails_DBTable::IS_DELETED . "= '1' WHERE ";
     $query .= ProgramDetails_DBTable::PROGRAM_ID . "='" . $pid . "' AND ";
     $query .= ProgramDetails_DBTable::IS_DELETED . "= 0";
     if (DBManager::executeQuery($query)) {
         $fileToUnlink = Configuration::get(Configuration::CODE_BASE_DIR) . $programInfo[ProgramDetails_DBTable::FK_LANGUAGE_ID] . "/" . $programInfo[ProgramDetails_DBTable::FK_CATEGORY_ID] . "/" . $programInfo[ProgramDetails_DBTable::STORED_FILE_NAME];
         unlink($fileToUnlink);
         return true;
     } else {
         Logger::getLogger()->LogFatal("Unable to delete file => " . $fileToUnlink);
         return false;
     }
 }
Пример #8
0
 /**
  * Checks in database if given category exists and is active?
  *
  * @param string $category
  * @return boolean
  */
 public function categoryExists($category)
 {
     $query = 'SELECT * FROM ' . Category_DBTable::DB_TABLE_NAME . ' WHERE ' . Category_DBTable::CATEGORY_ID . " = '" . $category . "' AND " . Category_DBTable::IS_DELETED . '=0';
     $result = DBManager::executeQuery($query, array(), true);
     return is_array($result) && count($result) > 0;
 }
 /**
  * Flush all user preference for given user Id
  * 
  * @param int $userId
  */
 private function flushAll($userId)
 {
     $query = 'DELETE FROM ' . UserPreferences_DBTable::DB_TABLE_NAME . ' WHERE ';
     $query .= UserPreferences_DBTable::USER_ID . '=?';
     if (DBManager::executeQuery($query, array($userId))) {
         Session::remove(Session::SESS_USER_PREF_KEY);
     }
 }
Пример #10
0
 /**
  * Checks in database if given language exists and is active?
  * 
  * @param string $lang
  * @return boolean
  */
 public function languageExists($lang)
 {
     $query = 'SELECT * FROM ' . Language_DBTable::DB_TABLE_NAME . ' WHERE ' . Language_DBTable::LANGUAGE_ID . " = '" . $lang . "' AND " . Language_DBTable::IS_DELETED . '=0';
     $result = DBManager::executeQuery($query, array(), true);
     return is_array($result) && count($result) > 0;
 }
Пример #11
0
 /**
  * Wrapper method for DB insert operation
  *
  * @param string $table
  * @param array $columns
  * @param array $bind [Optional]
  * @return boolean
  */
 public static function insert($table, array $columns, array $bind = array())
 {
     $keyStr = implode(',', array_keys($columns));
     $valStr = implode("','", $columns);
     $query = "INSERT INTO `{$table}` ({$keyStr}) VALUE('{$valStr}');";
     return DBManager::executeQuery($query, $bind);
 }
Пример #12
0
 function create_audit_table()
 {
     global $dictionary;
     $table_name = $this->get_audit_table_name();
     require 'metadata/audit_templateMetaData.php';
     $fieldDefs = $dictionary['audit']['fields'];
     $sql = $this->dbManager->helper->createTableSQLParams($table_name, $fieldDefs, array());
     $msg = "Error creating table: " . $table_name . ":";
     $this->dbManager->executeQuery($sql, $msg);
 }
Пример #13
0
<?php

session_start();
$_SESSION["varLanguage"] = 1;
// including the refernece of Database manaager
require_once $_SERVER['DOCUMENT_ROOT'] . "/Library/libDBManager/DBManager.php";
$db = new DBManager();
$result = $db->executeQuery("SELECT * FROM tblPinkArrow WHERE Page = 'TestPage'");
if ($result == -1) {
    $db->executeQuery("INSERT INTO `tblPinkArrow` VALUES ('', 'TestPage','' )");
    $a = mysql_insert_id();
    $db->executeQuery("INSERT INTO `tblPinkArrow` VALUES ('', 'TestPage','')");
    $b = mysql_insert_id();
    $db->executeQuery("INSERT INTO `tblPinkArrowMessage` VALUES ('', {$a},  'Session has been cancelled but no email contents found.','Test')");
    $db->executeQuery("INSERT INTO `tblPinkArrowMessage` VALUES ('', {$b},  'Session has been cancelled but no email contents found.Session has been cancelled but no email contents found.','Test')");
}
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>Untitled Document</title>
</head>
<script type="text/javascript" src="../libAjax/AjaxLib.js"></script>
<script type="text/javascript" src="libPinkArrow.js"></script>
<script language="javascript">
	var pageName = 'TestPage';
	pinkArrow.CancelEventBubbling('I,J,L,R,TR,TL,BL,BR');
</script>
<style>
input{
Пример #14
0
 public function getCategoryPieStats()
 {
     $sql = "SELECT COUNT(*) as count, " . ProgramDetails_DBTable::FK_CATEGORY_ID . " AS category FROM " . ProgramDetails_DBTable::DB_TABLE_NAME . ' WHERE ' . ProgramDetails_DBTable::IS_DELETED . '=0 GROUP BY ' . ProgramDetails_DBTable::FK_CATEGORY_ID;
     return DBManager::executeQuery($sql, array(), true);
 }
Пример #15
0
 public function insertProgramDescription($params)
 {
     $query = "INSERT INTO " . ProgramDetails_DBTable::DB_TABLE_NAME . " VALUES('', ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)";
     $bindParams = array($params['program_title'], $params['language_id'], $params['category_id'], $params['actual_file_name'], $params['stored_file_name'], $params['level'], $params['program_description'], $params['is_verified'], Utils::getCurrentDatetime(), Utils::getCurrentDatetime(), $params['created_by'], 0);
     return DBManager::executeQuery($query, $bindParams, false);
 }
Пример #16
0
/*********************************************************************************
*   What: Test page for Standard Email Library 
*   Who/When: Khalid Amin, 1 March 2006, khalid.amin@prosol.com.pk
*	Version: 1.0
*********************************************************************************/
// start the session
session_start();
$person = 150;
$company = 150;
$options = "";
require_once $_SERVER['DOCUMENT_ROOT'] . '/Library/libDBManager/DBManager.php';
require_once "libEmail.php";
$db = new DBManager();
$query = "SELECT pkEmailContentStandardID,EmailUniqueID, EmailSubject FROM tblEmailContentStandard INNER JOIN tblEmailFromAddress ON fkEmailFromAddressID = pkEmailFromAddressID";
$result = $db->executeQuery($query);
if ($result != -1) {
    while ($row = mysql_fetch_array($result)) {
        $selected = $row['pkEmailContentStandardID'] == $_POST['StandardEmail'] ? "selected" : "";
        $options .= "<option value='" . $row['EmailUniqueID'] . "' {$selected}>" . $row['EmailSubject'] . "</option>";
    }
}
if (isset($_POST['Email'])) {
    $vars['varSignSiteFullDomain'] = "www.tutorswithoutlimits.com";
    $vars['varSignSite'] = "Tutors Without Limits";
    $vars['varEmailFromSender'] = "Tutors Without Limits";
    $vars['varPassword'] = "******";
    $vars['varPreviousEmail'] = "*****@*****.**";
    $vars['varNewEmail'] = "*****@*****.**";
    $vars['varPhoneNo'] = "+12345678";
    $vars['varComments'] = "There are no comments";