private function migrate($user, $rollback = false) { $class = config('tenants.user'); try { if ($rollback) { createDBConnection($user); $class::rollback($user); } else { createDBConnection($user); $class::migrate($user); //Custom raw //DB::statement("ALTER TABLE GS_businesses ADD printInvoice INT UNSIGNED NOT NULL DEFAULT '0'"); } } catch (\Exception $e) { $this->error('[Error] ' . $e->getMessage()); } }
public static function newTenant($username, $password, $language = 'en', array $extraUserFields = []) { $username = preg_replace("/[^a-z0-9]+/", "", strtolower($username)); if (static::doesUserExists($username)) { throw new \Exception("Username already exists"); } $databaseName = config('tenants.DB_TENANTS_PREFIX') . $username; App::setLocale($language); try { DB::statement('create database ' . $databaseName . ';'); createDBConnection($username); $newArray = ['username' => $username, 'password' => Hash::make($password), 'appPassword' => Hash::make($password), 'language' => $language]; $user = static::create(array_merge($newArray, $extraUserFields)); static::migrateAndSeed($username); return $user; } catch (\Exception $e) { DB::statement('drop database ' . $databaseName . ';'); if ($user) { $user->forceDelete(); } throw $e; } }
<?php include_once __DIR__ . "/login_check.php"; include_once __DIR__ . "/config.php"; include_once __DIR__ . "/../../src/db_common.php"; /** * プロジェクト検体サンプル一覧 */ $db = createDBConnection(); // --------------------- // parameters 取得 // --------------------- $grp_id = \Sop\Session::getSiteData('grp_id'); $user_id = \Sop\Session::getSiteData('user_id'); $pj_id = array_key_exists('pj_id', $_REQUEST) ? $_REQUEST['pj_id'] : ''; $start = array_key_exists('start', $_REQUEST) ? intval($_REQUEST['start']) : 0; $limit = array_key_exists('limit', $_REQUEST) ? intval($_REQUEST['limit']) : 25; // --------------------- // データ取得 // --------------------- $sel_sql = getSQLBaseForPjSmplList(); $sel_sql .= " WHERE pj_smpl.pj_id = :pj_id AND v_pj.grp_id = :grp_id"; $params = array(); $params[':pj_id'] = $pj_id; $params[':grp_id'] = $grp_id; // --- 件数取得 $sql = "SELECT count(*) cnt FROM ({$sel_sql}) as tmp"; $stmt = $db->prepare($sql); $stmt->execute($params); $cnt = 0; foreach ($stmt->fetchAll(PDO::FETCH_ASSOC) as $row) {
<?php require '/resources/php/generalFunctions.php'; require '/resources/php/profileFunctions.php'; if (session_id() == '' || !isset($_SESSION)) { // session isn't started session_start(); } $mysqli = createDBConnection(); //db connection object $history = getCompanyHistory($_SESSION['user_id']); //employment history of user $companies = getCompanyList($mysqli); //company list for dropdown $companyArray = array(); while ($row = $companies->fetch_assoc()) { $companyArray[] = $row; } $companyList = json_encode($companyArray); $userInfo = getUserInfo($_SESSION['user_id']); //user info $userInfo = $userInfo->fetch_assoc(); $positionCount = getPostCount($mysqli, $_SESSION['user_id']); $postScoreSQL = "SELECT IFNULL(TRUNCATE(AVG(`rating`), 2), '-') AS 'rating'\n FROM\n (\n SELECT `post_id`\n FROM `position_post`\n WHERE `fk_user_id` = " . $_SESSION['user_id'] . "\n ) A\n LEFT JOIN `position_post_rating`\n ON `A`.`post_id` = `position_post_rating`.`fk_position_post`"; $postScoreQuery = $mysqli->query($postScoreSQL)->fetch_assoc(); $postScore = $postScoreQuery['rating']; $mysqli->close(); ?> <html lang="en" xmlns="http://www.w3.org/1999/html"> <head> <meta charset="UTF-8">