protected function getWhereForFindExistingData(array $data)
{
if (!isset($data['nodeName']) || !isset($data['startTime']) || !isset($data['subEntity'])) {
return null;
}
$table = DB::table($this->obj->getTable());
$nameCol = $table->getColumn('nodeName');
$startTimeCol = $table->getColumn('startTime');
$where = DB::where($nameCol, DB::term($data['nodeName']));
$date = new base_date_model_DateTime(new DateTime($data['startTime']));
$where->addAnd($startTimeCol, DB::term($date->toDB()));
if (!empty($data['subEntity'])) {
$subEntityCol = $table->getColumn('subEntity');
$where->addAnd($subEntityCol, DB::term($data['subEntity']));
}
$where->addAnd($table->getColumn('FK_tsmserver'), DB::intTerm($data['FK_tsmserver']));
$where->addAnd($table->getColumn('histtop'), DB::term('Y'));
return $where;
}
/**
* login of an user with the given userid and password
*
* @param string $userid
* @param string $password
*
* @return int
* @throws base_database_Exception
*/
public static function login($userid, $password)
{
$table = DB::table(Factory::createObject('user')->getTable());
$where = DB::where($table->getColumn('userid'), DB::stringTerm($userid));
$res = Finder::create('user')->setWhere($where)->find();
if (empty($res)) {
return self::LOGIN_FAILURE;
}
$user = current($res);
if ($user['disabled'] == self::USER_DISABLED) {
return self::LOGIN_USER_DISABLED;
}
if ($user['password'] != md5($password)) {
return self::_updateLoginTries($table, $user);
}
try {
$time = new base_date_model_DateTime();
$updateData = array(
'ip' => DB::stringTerm($_SERVER['REMOTE_ADDR']),
'sessionid' => DB::stringTerm(session_id()),
'lastLogin' => DB::stringTerm($time->toDB()),
'loginTries' => DB::intTerm(0),
);
self::_updateUserLoginData($table, $where, $updateData);
} catch (Exception $e) {
return self::LOGIN_FAILURE;
}
$user['ip'] = $_SERVER['REMOTE_ADDR'];
$user['sessionid'] = session_id();
$user['lastLogin'] = $time;
$user['loginTries'] = 0;
$_SESSION['user'] = $user;
return self::LOGIN_SUCCESS;
}
/**
* creates the admin user
*
* @param OutputDevice $od
* @throws base_database_Exception
*/
public function createAdminUser(OutputDevice $od)
{
$user = new User();
if (!is_null($user->load(1))) {
return;
}
$seq = new Sequence('User');
$adminData['LK'] = $seq->getNextSequence();
$adminData['firstEditor'] = 1;
$dateTime = new base_date_model_DateTime();
$adminData['firstEditTime'] = $dateTime->toDB();
$adminData['editor'] = 1;
$adminData['editTime'] = $dateTime->toDB();
$adminData['userid'] = 'admin';
$adminData['password'] = '******';
$adminData['firstName'] = 'Admin';
$adminData['lastName'] = 'Admin';
$adminData['email'] = '*****@*****.**';
$statement = new base_database_statement_Insert();
$table = DB::table('user');
$statement->setTable($table);
foreach ($adminData as $fieldName => $value) {
$statement->setColumnValue($table->getColumn($fieldName), DB::term($value));
}
$dbObj = base_database_connection_Mysql::get();
$dbObj->beginTransaction();
$seq->save();
$statement->insertDatabase();
$dbObj->endTransaction();
base_install_Message::printOut('----- Admin User created -----', $od);
}
$od = new OutputDevice();
base_ui_Site::displayHead($od);
base_ui_Site::displayTop($od);
base_ui_Site::displayNavigation($od);
base_ui_Site::startMainContent($od);
print $od->toString();
$od->flush();
$od->addContent(Html::startTag('h3'));
$od->addContent('Summary');
$od->addContent(Html::endTag('h3'));
$table = DB::table(Factory::createObject('TSMSummary')->getTable());
$dateTime = new base_date_model_DateTime(new DateTime('2015-01-01 00:00:00'));
$where = DB::where($table->getColumn('startTime'), DB::term($dateTime->toDB()), base_database_Where::GREATER);
$order = DB::order($table->getColumn('startTime'));
$finder = Finder::create('TSMSummary')->setWhere($where)->setOrder($order);
$objs = $finder->find();
$times = [];
$nodeNames = [];
$sortedObjects = [];
foreach ($objs as $obj) {
/** @var base_date_model_DateTime $startTime */
$startTime = $obj['startTime'];
$nodeName = $obj['nodeName'];
if (strpos($nodeName, 'FULLVM')) {
$nodeName = $obj['subEntity'] . ' (FULLVM)';
}
/**
* @param base_date_model_DateTime $value
* @return mixed|void
*/
public function toDB($value)
{
return $value->toDB();
}
