public static function addAction($user_id, $msg)
{
$user = null;
$dnevnik_id = null;
if (UsersDB::isSalesman(["uporabnik_id" => $user_id])) {
$user = UsersDB::getSalesman(["id" => $user_id]);
$dnevnik_id = $user["dnevnik_id"];
if (!isset($user["dnevnik_id"])) {
// echo $user_id;
// echo $msg;
// a;
$params["uporabnik_id"] = $user_id;
$dnevnik_id = $params["dnevnik_id"] = self::insertDiary();
UsersDB::updateSalesmanDiary($params);
}
} else {
if (UsersDB::isAdmin(["uporabnik_id" => $user_id])) {
$user = UsersDB::getAdmin(["id" => $user_id]);
$dnevnik_id = $user["dnevnik_id"];
if (!isset($user["dnevnik_id"])) {
$params["uporabnik_id"] = $user_id;
$dnevnik_id = $params["dnevnik_id"] = self::insertDiary();
UsersDB::updateAdminDiary($params);
}
} else {
throw new InvalidArgumentException("Le administrator in prodajalec lahko dodajata vnose v dnevnik.");
}
}
$actionParams["dnevnik_id"] = $dnevnik_id;
$actionParams["opis"] = $msg;
return parent::modify("INSERT INTO akcija (dnevnik_id, opis) " . " VALUES (:dnevnik_id, :opis)", $actionParams);
}
/**
* Returns the data for one table
*
* @access public
*
* @param AbstractDB $db db identifier
* @param String $table table name
* @param Integer $type ANYDB_DUMP_ constants
* @param String $seperator for csv files
*
* @returns Array the table data
*/
function getTableData(&$db, $table, $type = ANYDB_DUMP_SQL, $seperator = "\t")
{
$res = '';
$first = true;
// get all the data
$query = "SELECT * FROM {$table}";
$db->query($query, ANYDB_RES_ASSOC);
while ($line = $db->getNext()) {
$line = $db->escapeStr($line);
switch ($type) {
case ANYDB_DUMP_SQL:
$res .= QueryHelper::insert($table, $line) . ";\n";
break;
case ANYDB_DUMP_CSV:
if ($first) {
$res .= implode($seperator, array_keys($line)) . "\n";
$first = false;
}
$res .= implode($seperator, $line) . "\n";
break;
}
}
return $res;
}
public static function getAll()
{
return parent::query("SELECT * FROM tekma" . " ORDER BY datum DESC");
}
public static function getAll()
{
return parent::query("SELECT *" . " FROM posta" . " ORDER BY id ASC");
}
/**
* Metoda nastavi instanco razreda PDO na v parametru podano vrednost.
* @param type $dbh
*/
public static function setConnection($dbh)
{
self::$dbh = $dbh;
}
public static function getAll()
{
return parent::query("SELECT * FROM igralec" . " ORDER BY id ASC");
}
public static function getUserAllCancelled($uporabnik_id)
{
// ---- vsa obdelana in stornirana narocila uporabnika -----
$orders = parent::query("SELECT *" . " FROM narocilo" . " WHERE uporabnik_id = :uporabnik_id AND obdelano = 'da' AND potrjeno = 'st'", $uporabnik_id);
return $orders;
}
/**
* Returns the number of elements in a column
*
* @access public
* @static
*
* @param AbstractDB $db db resource
* @param String $tableName table
*
* @returns Integer value
*/
function getCount(&$db, $tableName)
{
$db->query("SELECT count(*) FROM {$tableName}");
return $db->getValue();
}
public static function preveriUpodabniskoImeDodajanje($uime)
{
$result = parent::query("SELECT COUNT(id)" . "FROM uporabnik WHERE uporabnisko_ime = :uporabnisko_ime", ["uporabnisko_ime" => $uime]);
return $result[0]["COUNT(id)"] == '0';
}
public static function getAll()
{
return parent::query("SELECT id, ime, slika" . " FROM slika");
}
public static function getAll()
{
return parent::query("SELECT * FROM uporabnik" . " ORDER BY id ASC");
}
/**
* Abstract functions for database access. Assumes that all PostgreSQL database interfaces
* are functionally available using the actual database.
*/
function db_affected_rows($dblink)
{
// FIX THIS
return 0;
return parent::db_affected_rows($dblink);
}
