/**
* Returns the fragment SQL string
*
* @param rdbms.DBConnection conn
* @return string
* @throws rdbms.SQLStateException
*/
public function asSql(DBConnection $conn)
{
$s = '';
foreach ($this->projections as $e) {
$s .= 0 != strlen($e['alias']) ? $conn->prepare(', %c as %l', $e['projection']->asSql($conn), $e['alias']) : $conn->prepare(', %c', $e['projection']->asSql($conn));
}
return substr($s, 1);
}
function hasTasks($m_id)
{
$db = new DBConnection();
$q = "call checktaskonmain(:mid)";
$stmt = $db->prepare($q);
// $stmt->setFetchMode(PDO::FETCH_OBJ);
$stmt->execute(array('mid' => $m_id));
$havetask = $stmt->fetchColumn();
return $havetask;
}
function getAssignedAssociateName($username)
{
$db = new DBConnection();
$q = "call getAssociate(:assigned)";
$stmt = $db->prepare($q);
// $stmt->setFetchMode(PDO::FETCH_CLASS, 'User');
$stmt->execute(array(':assigned' => $username));
$associate = $stmt->fetch(PDO::FETCH_OBJ);
return $associate->a_name;
}
function getUserFromCookie()
{
$db = new DBConnection();
$q = "call getassociate(:username)";
$stmt = $db->prepare($q);
$userac = htmlEntities2($_COOKIE["UserName"]);
// $stmt->setFetchMode(PDO::FETCH_CLASS, 'User');
$stmt->execute(array(':username' => $userac));
$user = $stmt->fetch(PDO::FETCH_OBJ);
$_SESSION["UserName"] = $user;
}
require_once '../DBConnection.php';
function htmlEntities2($str)
{
$text = str_replace("oe", "Ø", $str);
$text = str_replace("aaa", "Å", $text);
$text = str_replace("ae", "Æ", $text);
// window.alert(text);
return $text;
}
try {
$oldUser = htmlEntities2($_COOKIE["UserName"]);
$newName = $_POST["newName"];
$newUser = $_POST["newUser"];
$newPwd = $_POST["newPwd"];
$newPriv = $_POST["newPriv"];
$newMail = $_POST["newMail"];
$db = new DBConnection();
$q = "call alterassociate(:oldUser, :newUser, :newPwd, :newName, :newPriv, :newMail);";
$stmt = $db->prepare($q);
$stmt->execute(array(':oldUser' => $oldUser, ':newName' => $newName, ':newUser' => $newUser, ':newPwd' => $newPwd, ':newPriv' => $newPriv, ':newMail' => $newMail));
$count = $stmt->rowCount();
if ($stmt != FALSE) {
setcookie("UserName", $newUser, time() + 86400, "/planning/");
header("location:" . $_COOKIE['previous']);
} else {
header("location:../../associateForm.php?edit&error");
}
} catch (PDOException $e) {
echo $e->getMessage();
}
function getExpFromTask()
{
$db = new DBConnection();
$q = "call getexpenses(:id)";
$stmt = $db->prepare($q);
$stmt->setFetchMode(PDO::FETCH_OBJ);
$stmt->execute(array(':id' => $_COOKIE["Task"]));
$expenses = $stmt->fetchAll();
return $expenses;
}
/**
* Returns the fragment SQL
*
* @param rdbms.DBConnection conn
* @param rdbms.Peer peer
* @return string
* @throws rdbms.SQLStateException
*/
public function asSql(DBConnection $conn)
{
return $conn->prepare($this->command, $this->field);
}
/**
* Returns the fragment SQL
*
* @param rdbms.DBConnection conn
* @return string
* @throws rdbms.SQLStateException
*/
public function asSql(DBConnection $conn)
{
return $conn->prepare($conn->getFormatter()->dialect->formatFunction($this), ...$this->args);
}
/**
* Returns the fragment SQL
*
* @param rdbms.DBConnection conn
* @param rdbms.Peer peer
* @return string
* @throws rdbms.SQLStateException
*/
public function asSql(DBConnection $conn, Peer $peer)
{
$lhs = $this->lhs instanceof SQLFragment ? $this->lhs : $peer->column($this->lhs);
return $conn->prepare('%c between ' . $lhs->getType() . ' and ' . $lhs->getType(), $lhs, $this->lo, $this->hi);
}
/**
* get the SELECT query
*
* @param rdbms.DBConnection conn
* @param rdbms.Peer peer
* @param rdbms.join.Joinprocessor jp optional
* @return rdbms.ResultSet
*/
public function getSelectQueryString(DBConnection $conn, Peer $peer, $jp = NULL)
{
if ($this->isJoin()) {
$jp->setFetchmodes($this->fetchmode);
}
return $conn->prepare('select %c from %c %c', $this->projections($conn, $peer, $jp), $this->isJoin() ? $jp->getJoinString() : $peer->table, $this->toSQL($conn, $peer, $jp));
}
/**
* Returns the fragment SQL
*
* @param rdbms.DBConnection conn
* @param rdbms.Peer peer
* @return string
*/
public function asSql(DBConnection $conn, Peer $peer)
{
$lhs = $this->lhs instanceof SQLFragment ? $this->lhs : $peer->column($this->lhs);
return $conn->prepare('%c ' . str_replace('?', $lhs->getType(), $this->op), $lhs, $this->value);
}
/**
* Returns the fragment SQL
*
* @param rdbms.DBConnection conn
* @param rdbms.Peer peer
* @return string
* @throws rdbms.SQLStateException
*/
public function asSql(DBConnection $conn, Peer $peer)
{
return $conn->prepare('not (%c)', $this->criterion->asSql($conn, $peer));
}
$stat = $_POST["stat"];
$assi = $_POST["assi"];
$timespen = $_POST["hour"] . ":" . $_POST["min"];
$comment = $_POST["newComment"];
$mailto = $_POST["mailto"];
$press = isset($_POST['press']) && $_POST['press'] ? "true" : "false";
$online = isset($_POST['online']) && $_POST['online'] ? "true" : "false";
$pressdate = $_POST["pressdate"];
if ($pressdate === "") {
$pressdate = "0000-00-00";
}
$project = $_POST["mainid"];
// echo "mainid = ".$project;
$db = new DBConnection();
$q = "call altertask(:id, :cus, :title, :descr, :stat, :assi, :timespent, :pressdate, :press, :online, :mainid);";
$stmt = $db->prepare($q);
$stmt->execute(array(':id' => $id, ':cus' => $cus, ':title' => $title, ':descr' => $descr, ':stat' => $stat, ':assi' => $assi, ':timespent' => $timespen, ':pressdate' => $pressdate, ':press' => $press, ':online' => $online, ':mainid' => $project));
$q2 = "call setmainprojektstate(:mainid)";
$stmt2 = $db->prepare($q2);
$stmt2->execute(array(':mainid' => $project));
if ($comment != "") {
$q = "call createcomment(:id, :comment, :user);";
$stmt = $db->prepare($q);
$stmt->execute(array(':id' => $id, ':comment' => $comment, ":user" => $user));
if (isset($mailto)) {
$mails = array();
foreach ($mailto as $mail) {
$q = "call getAssociate(:mailto)";
$stmt = $db->prepare($q);
$stmt->execute(array(':mailto' => $mail));
$asmail = $stmt->fetch(PDO::FETCH_OBJ);
