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); }