public function getDriversLocation()
{
$user = new User();
$group_id = $user->getGroupID();
if ($group_id > 0) {
return DBHelper::getAssoc("\n SELECT d.`driver_id`, d.`lat`, d.`lng`, d.`busy`, d.`accuracy`, d.`last_activity`\n FROM `drivers` d, `drivers_groups` g\n WHERE d.driver_id = g.driver_id AND g.`group_id` = " . $group_id);
} else {
return DBHelper::getAssoc("\n SELECT `driver_id`, `lat`, `lng`, `busy`, `accuracy`, `last_activity`\n FROM `drivers`");
}
}
/**
* Wylicza warto¶ci wid (wagi poszczególnych cech w dokumencie)
* na podstawie czêsto¶ci wystêpowania wyrazów i innych
* danych zebranych w BD dla wcze¶niejszych komentarzy.
*
* @param array $comment
* @return array
*/
protected function evalWid(array $comment)
{
$dbcom = "('" . implode("','", array_keys($comment)) . "')";
$sql = "SELECT word, CCi, idf FROM `datavect_{$this->idc}-4f` WHERE word IN {$dbcom}";
$res = DBHelper::getAssoc($this->dbconn, $sql);
$ret_array = array();
$sum = 0.0;
foreach ($comment as $k => $v) {
if (array_key_exists($k, $res)) {
$val = log($v + 0.5) * $res[$k][0] * $res[$k][1];
} else {
$val = log($v + 0.5);
}
$ret_array[$k] = $val;
$sum += $val;
}
if ($sum == 0.0) {
$sum = 1.0;
}
$mul = 1 / $sum;
foreach ($ret_array as &$v) {
$v *= $mul;
}
return $ret_array;
}
public function getAllUsers()
{
return DBHelper::getAssoc("SELECT `user_id`, `company_id`, `email`, `name`, `last_activity`, `user_type` FROM `users`");
}
mkdir($directory);
}
// wszystkie testy wykonaj $subTests razy
for ($sub = 1; $sub <= $subTests; ++$sub) {
// poszczególne zestawy komentarzy
for ($idc = 1; $idc <= 3; ++$idc) {
$curTimes = array();
$classObj = array();
$partialResults["{$sub}_{$idc}"] = array();
$summedResults["{$sub}_{$idc}"] = array();
if ($sub == 1) {
$times["{$idc}"] = array();
}
// pobierz komentarze inicjalizuj±ce
$posInit = DBHelper::getAssoc($db, "SELECT id, comment FROM comment_{$idc} WHERE type = 'OK' ORDER BY id LIMIT {$initialComments}");
$negInit = DBHelper::getAssoc($db, "SELECT id, comment FROM comment_{$idc} WHERE type = 'ER' ORDER BY id LIMIT {$initialComments}");
// utwórz obiekty klasyfikatorów, obiekty czasomierzy
// zainicjalizuj tablice wyników, dokonaj inicjalizacji
foreach ($classifiers as $k => $v) {
if ($suppressThreshold) {
$v["{$idc}"]['threshold'] = 0.0;
}
$tmpc = new ReflectionClass($k);
$classObj[$k] = $tmpc->newInstance($db, $dictionaries, $idc, $copyUnknown, $v["{$idc}"]);
$curTimes[$k] = new Timer();
$classObj[$k]->doInit($posInit, $negInit);
$curTimes[$k]->set('doInit');
$curResults[$k] = array('TP' => 0, 'TN' => 0, 'FP' => 0, 'FN' => 0, 'UC' => 0);
}
unset($posInit, $negInit);
$ii = 0;
public function getGroups($driver_id)
{
return DBHelper::getAssoc("SELECT * FROM `drivers_groups` WHERE `driver_id` = " . $driver_id);
}
