public static function Toolbox()
{
//if not the first time this is called
if (isset(self::$toolbox)) {
return self::$toolbox;
}
//else set up the RedBean toolbox
require_once \Swiftriver\Core\Setup::Configuration()->ModulesDirectory . "/RedBean/redbean.inc.php";
//get the url of the url of the db server
$url = (string) Setup::$Configuration->DataBaseUrl;
//Get the db username
$username = (string) Setup::$Configuration->UserName;
//get the password
$password = (string) Setup::$Configuration->Password;
//get the db name
$database = (string) Setup::$Configuration->Database;
//set the db type
$typeofdatabase = "mysql";
//Assemble a database connection string (DSN)
$dsn = "{$typeofdatabase}:host={$url};dbname={$database}";
//Construct a new Red Bean Toolbox, if it has not been set in the mean time
if (!isset(self::$toolbox)) {
self::$toolbox = \RedBean_Setup::kickstartDev($dsn, $username, $password);
}
//return it
return self::$toolbox;
}
<?php
/*
init.php
Redbean initializator
Mochammad Masbuchin
*/
require "RedBean/redbean.inc.php";
$toolbox = RedBean_Setup::kickstartDev("mysql:host=localhost;dbname=restobean", "root", "");
$redbean = $toolbox->getRedBean();
$pegawai = $redbean->dispense("pegawai");
$menu = $redbean->dispense("menu");
$cashierin = $redbean->dispense("cashierin");
$cashierout = $redbean->dispense("cashierout");
$order = $redbean->dispense("order");
$ordermenu = $redbean->dispense("ordermenu");
$settle = $redbean->dispense("settle");
$bahan = $redbean->dispense("bahan");
$stockhistory = $redbean->dispense("stockhistory");
$resep = $redbean->dispense("resep");
$keuangan = $redbean->dispense("keuangan");
$payout = $redbean->dispense("payout");
$adapter = $toolbox->getDatabaseAdapter();
//$meja->import($lesehan, "namameja, jumlahkursi, status, lokasi");
/*$meja->import($pendopo, "namameja, jumlahkursi, status, lokasi");
print_r($meja);*/
}
//If you did not specify a username, we do this for you
if (!isset($username)) {
$username = "******";
}
//If you did not specify a database type, we will use mysql
if (!isset($typeofdatabase)) {
$typeofdatabase = "mysql";
}
//Assemble a database connection string (DSN)
$dsn = "{$typeofdatabase}:host=localhost;dbname={$database}";
//Connect to database and fetch the toolbox; either with or without password
if (!isset($password)) {
$toolbox = RedBean_Setup::kickstartDev($dsn, $username);
} else {
$toolbox = RedBean_Setup::kickstartDev($dsn, $username, $password);
}
//Extracting tools for you
$redbean = $toolbox->getRedBean();
$db = $toolbox->getDatabaseAdapter();
$writer = $toolbox->getWriter();
//Creating an Association Manager for you
$assoc = new RedBean_AssociationManager($toolbox);
//Creating a Tree Manager for you
$tree = new RedBean_TreeManager($toolbox);
function assoc($bean1, $bean2)
{
global $assoc;
$assoc->associate($bean1, $bean2);
//also put a cascaded delete constraint - why not?
RedBean_Plugin_Constraint::addConstraint($bean1, $bean2);
