getAll($sql);
return $rs;
}
function getOnePostIt($id) {
$sql = "select * from postit where id=$id";
$rs = $_SESSION['db']->getAll($sql);
if ($rs) {
$data=$rs[0];
$data["notes"]=stripslashes($data["notes"]);
return $data;
} else {
return false;
}
}
function savePostIt($data) {
if (!$data["id"]) {
$newID = uniqid (rand());
$rc = $_SESSION['db']->insert(postit,array('employee','date','cause'),array($_SESSION["loginCRM"],'now()',$newID));
if ($rc) {
$sql = "select id from postit where cause = '$newID'";
$rs = $_SESSION['db']->getOne($sql);
} else {
return false;
}
if ($rs) {
$data["id"] = $rs["id"];
$rc = $_SESSION['db']->commit();
} else {
return false;
}
};
$sql = "UPDATE postit SET notes = '".$data["notes"]."',cause='".substr($data["cause"],0,100)."' WHERE id = ".$data['id'];
$rc = $_SESSION['db']->query($sql);
return $rc;
}
function DelPostIt($id) {
$sql = "delete from postit where id=$id";
$rc = $_SESSION['db']->query($sql);
return $rc;
}
if ($_POST["save"]) {
if ($_POST["cause"]) $rc=savePostIt($_POST);
if (!$rc) $data=$_POST;
} else if ($_GET["hole"]) {
$data=getOnePostIt($_GET["hole"]);
} else if ($_POST["delete"]) {
if ($_POST["id"]) $rc=delPostIt($_POST["id"]);
}
$menu = $_SESSION['menu'];
?>
<?php echo translate(".:LxO:.","work"); ?> <?php echo translate(".:postit:.","work"); ?>
'.
$menu['javascripts']; ?>
| ";
echo db2date(substr($row["date"],0,10))." ".substr($row["date"],11,5);
echo " | [".$row["cause"]."] | \n";
};
?>