function giveActionAccess($where, $role_id) { $db = BizSystem::dbConnection(); try { if (empty($where)) { $sql = "SELECT * FROM acl_action"; } else { $sql = "SELECT * FROM acl_action WHERE {$where}"; } BizSystem::log(LOG_DEBUG, "DATAOBJ", $sql); $rs = $db->fetchAll($sql); $sql = ""; foreach ($rs as $r) { $sql = "DELETE FROM acl_role_action WHERE role_id={$role_id} AND action_id={$r['0']}; "; BizSystem::log(LOG_DEBUG, "DATAOBJ", $sql); $db->query($sql); $sql = "INSERT INTO acl_role_action (role_id, action_id, access_level) VALUES ({$role_id},{$r['0']},1)"; BizSystem::log(LOG_DEBUG, "DATAOBJ", $sql); $db->query($sql); } } catch (Exception $e) { echo "ERROR: " . $e->getMessage() . "" . PHP_EOL; return false; } }
function open($savePath, $sessionName) { // echo "session open".nl; // connect to session db $this->sessionDb = BizSystem::dbConnection(SESSION_DBNAME); $sessionID = session_id(); if ($sessionID !== "") { $this->initSessionData = $this->read($sessionID); } return true; }
/** * Get database connection * * @return Zend_Db_Adapter_Abstract **/ public function getDBConnection() { return BizSystem::dbConnection($this->m_Database); }
/** * Execute SQL * * @param array $argList * @return void */ protected function executeSQL($argList) { $dbName = $argList["DBName"]; if (!$dbName) { $dbName = "Default"; } $sql = $argList["SQL"]; $db = BizSystem::dbConnection($dbName); try { $resultSet = $db->query($sql); } catch (Exception $e) { $errorMessage = "Error in run SQL: " . $sql . ". " . $e->getMessage(); } }
public function DBConnection() { return BizSystem::dbConnection($this->dbName); }
/** * Get database connection * * @return Zend_Db_Adapter_Abstract **/ public function getDBConnection($type = 'default') { switch (strtolower($type)) { case "default": case "read": if ($this->m_DatabaseforRead) { $dbName = $this->m_DatabaseforRead; } else { $dbName = $this->m_Database; } break; case "write": if ($this->m_DatabaseforWrite) { $dbName = $this->m_DatabaseforWrite; } else { $dbName = $this->m_Database; } break; } return BizSystem::dbConnection($dbName); }
echo "This script is to create cubi installation database." . PHP_EOL; echo "Please create a CubiInstall database in cubi/Config.xml." . PHP_EOL; echo "Is CubiInstall created? (y/n) "; // Read the input $answer = trim(fgets(STDIN)); echo "Your answer is {$answer}" . PHP_EOL; if ($answer != 'y') { exit; } include_once dirname(dirname(__FILE__)) . "/app_init.php"; if (!defined("CLI")) { exit; } include_once MODULE_PATH . "/system/lib/ModuleLoader.php"; $cubiInstallDb = "CubiInstall"; $db = BizSystem::dbConnection($cubiInstallDb); if (!$db) { echo "Please create a CubiInstall database in cubi/Config.xml." . PHP_EOL; } $modules = array('system', 'menu'); foreach (glob(MODULE_PATH . DIRECTORY_SEPARATOR . "*") as $dir) { $modName = str_replace(MODULE_PATH . DIRECTORY_SEPARATOR, "", $dir); if ($modName != "system" && $modName != "menu") { array_push($modules, $modName); } } // find all modules foreach ($modules as $mod) { echo PHP_EOL . "---------------------------------------------------" . PHP_EOL; echo "> Start loading '{$mod}' module ..." . PHP_EOL; $loader = new ModuleLoader($mod, $cubiInstallDb);
/** * Load table index and uniqueness information * @return void */ protected function getTableIndex() { $db = BizSystem::dbConnection($this->db_name); $db_driver = $this->db_config['Driver']; switch (strtoupper($db_driver)) { case 'PDO_MYSQL': $sql = "SHOW INDEX FROM {$this->table_name};"; $result = $db->query($sql); $tblIndexes = $result->fetchAll(); break; default: break; } $tableIndex = array(); if ($tblIndexes) { foreach ($tblIndexes as $colIndex) { $non_unique = $colIndex[1]; $key_name = $colIndex[2]; $col_name = $colIndex[4]; if ($key_name != "PRIMARY" && $tblCols[$col_name]['DATA_TYPE'] != 'int') { //$tableIndex[$key_name]=array(); $indexInfo = array("NON_UNIQUE" => $non_unique, "KEY_NAME" => $key_name, "COL_NAME" => $col_name); if (!is_array($tableIndex[$key_name])) { $tableIndex[$key_name] = array(); } array_push($tableIndex[$key_name], $indexInfo); } } } $this->tableIndex = $tableIndex; $uniqueness = ""; foreach ($tableIndex as $key_name => $key_index) { $key_uniqueness = ""; foreach ($key_index as $indexInfo) { if ($indexInfo['NON_UNIQUE'] == "0") { if ($key_uniqueness != "") { $key_uniqueness .= ","; } $key_uniqueness .= $indexInfo['COL_NAME']; } } if ($key_uniqueness != "") { $uniqueness .= $key_uniqueness . ";"; } } $this->uniqueness = $uniqueness; }
/** * Get Database profile * * @todo not finish * @param <type> $userId * @param <type> $password */ protected function getDBProfile($userId, $password) { // CASE 1: simple one table query // SELECT role, group, pstn, divn, org FROm user_table AS t1 // WHERE t1.userid='$userid' // CASE 2: intersection table user_pstn (user_role, user_divn, user_org ...), need to query multiple times // SELECT t1.pstnid, t2.name FROM user_pstn_table AS t1 // JOIN pstn_table AS t2 ON t1.pstnid=t2.id // WHERE t1.userid='$userid' // CASE 3: all hierarchy info contained in one big party table, do query once, then filter on type column // SELECT t1.partyid, t2.name, t2.type FROM user_party_table AS t1 // JOIN party_table AS t2 ON t1.partyid=t2.id // WHERE t1.userid='$userid' $db = BizSystem::dbConnection(); $resultSet = $db->execute($sql); $sqlArr = $resultSet->fetchRow(); // process the result }