protected function insertComments(User $aUser)
{
$status = new Status();
$status->insert(array("user_id" => $aUser->id, "comment" => "comment1", "created_at" => "2008-01-01 00:00:00"));
$status->insert(array("user_id" => $aUser->id, "comment" => "comment2", "created_at" => "2008-02-01 00:00:00"));
$status->insert(array("user_id" => $aUser->id, "comment" => "comment3", "created_at" => "2008-03-01 00:00:00"));
}
<?php
require '../class/status.php';
$status = new Status();
session_start();
if ($status->insert($_SESSION['u_id'], $_POST['content'])) {
echo '<p>Has been added successfully!</p>';
} else {
echo '<p>There was problem with status posting!</p>';
}
// khi chọn loại sản phẩm
if (isset($_POST["btnSave"])) {
if (isset($_POST["txtControl"])) {
$control->setValue($_POST["txtControl"]);
}
if (isset($_POST["txtStatusID"])) {
$Status->setStatusID($_POST["txtStatusID"]);
}
if (isset($_POST["txtStatusName"])) {
$Status->setStatusName($_POST["txtStatusName"]);
}
if (isset($_POST["txtStatusColor"])) {
$Status->setStatusColor($_POST["txtStatusColor"]);
}
if ($control == Controls::Insert) {
$Status->insert();
$insert = true;
} else {
if ($control == Controls::Update) {
$Status->update();
$update = true;
}
}
} else {
if (isset($_GET["StatusID"]) && isset($_GET["control"])) {
$control->setValue($_GET["control"]);
$Status = Status::getStatus($_GET["StatusID"]);
if ($control == Controls::Update) {
echo "<script> \$(function () { \$(window).load(function(){ \$('#modalStatus').modal( { backdrop: 'static', keyboard: false }, 'show');}); });</script>";
} else {
if ($control == Controls::Delete) {
// | Free Software Foundation, Inc. |
// | 51 Franklin Street, Suite 330 |
// | Boston, MA 02110-1301, USA. |
// +----------------------------------------------------------------------+
// | Authors: João Prado Maia <*****@*****.**> |
// +----------------------------------------------------------------------+
require_once dirname(__FILE__) . '/../../init.php';
$tpl = new Template_Helper();
$tpl->setTemplate('manage/statuses.tpl.html');
Auth::checkAuthentication(APP_COOKIE);
$role_id = Auth::getCurrentRole();
if ($role_id < User::getRoleID('manager')) {
Misc::setMessage(ev_gettext('Sorry, you are not allowed to access this page.'), Misc::MSG_ERROR);
$tpl->displayTemplate();
exit;
}
if (@$_POST['cat'] == 'new') {
$res = Status::insert();
Misc::mapMessages($res, array(1 => array(ev_gettext('Thank you, the status was added successfully.'), Misc::MSG_INFO), -1 => array(ev_gettext('An error occurred while trying to add the status.'), Misc::MSG_ERROR), -2 => array(ev_gettext('Please enter the title for this status.'), Misc::MSG_ERROR)));
} elseif (@$_POST['cat'] == 'update') {
$res = Status::update();
Misc::mapMessages($res, array(1 => array(ev_gettext('Thank you, the status was updated successfully.'), Misc::MSG_INFO), -1 => array(ev_gettext('An error occurred while trying to add the status.'), Misc::MSG_ERROR), -2 => array(ev_gettext('Please enter the title for this status.'), Misc::MSG_ERROR)));
} elseif (@$_POST['cat'] == 'delete') {
Status::remove();
}
if (@$_GET['cat'] == 'edit') {
$tpl->assign('info', Status::getDetails($_GET['id']));
}
$tpl->assign('list', Status::getList());
$tpl->assign('project_list', Project::getAll());
$tpl->displayTemplate();
include_once "../config.inc.php";
include_once APP_INC_PATH . "class.template.php";
include_once APP_INC_PATH . "class.auth.php";
include_once APP_INC_PATH . "class.project.php";
include_once APP_INC_PATH . "class.status.php";
include_once APP_INC_PATH . "db_access.php";
$tpl = new Template_API();
$tpl->setTemplate("manage/index.tpl.html");
Auth::checkAuthentication(APP_COOKIE);
$tpl->assign("type", "statuses");
$role_id = Auth::getCurrentRole();
if ($role_id == User::getRoleID('administrator') || $role_id == User::getRoleID('manager')) {
if ($role_id == User::getRoleID('administrator')) {
$tpl->assign("show_setup_links", true);
}
if (@$HTTP_POST_VARS["cat"] == "new") {
$tpl->assign("result", Status::insert());
} elseif (@$HTTP_POST_VARS["cat"] == "update") {
$tpl->assign("result", Status::update());
} elseif (@$HTTP_POST_VARS["cat"] == "delete") {
Status::remove();
}
if (@$HTTP_GET_VARS["cat"] == "edit") {
$tpl->assign("info", Status::getDetails($HTTP_GET_VARS["id"]));
}
$tpl->assign("list", Status::getList());
$tpl->assign("project_list", Project::getAll());
} else {
$tpl->assign("show_not_allowed_msg", true);
}
$tpl->displayTemplate();
Flight::ok($array);
} catch (Exception $exception) {
Flight::error($exception);
}
});
Flight::route('GET /v1/main/status/@id', function ($id) {
try {
$object = Status::select($id);
Flight::ok($object);
} catch (Exception $exception) {
Flight::error($exception);
}
});
Flight::route('POST /v1/main/status', function () {
try {
$object = Status::insert();
Flight::ok($object);
} catch (Exception $exception) {
Flight::error($exception);
}
});
Flight::route('PUT /v1/main/status/@id', function ($id) {
try {
$object = Status::update($id);
Flight::ok($object);
} catch (Exception $exception) {
Flight::error($exception);
}
});
Flight::route('DELETE /v1/main/status/@id', function ($id) {
try {
if ($user->mail_failure) {
array_push($warning_messages, lang("ACTIVATION_MAIL_NOT_SENT", array($_POST['username'], $_POST['email'])));
}
// Retrieve the User_ID from the database
$userdetails = fetchUserDetails($user->clean_username);
if (!empty($userdetails)) {
$contact = new Contact(true, $userdetails['User_ID'], $_POST);
$personal = new Personal(true, $userdetails['User_ID'], $_POST);
$status = new Status(true, $userdetails['User_ID'], $_POST);
if ($_POST['group_id'] == 1 || $_POST['group_id'] == 2) {
$studies = new Studies_Undergr(true, $userdetails['User_ID'], $_POST);
}
$inserted = array();
$inserted['contact'] = $contact->insert();
$inserted['personal'] = $personal->insert();
$inserted['status'] = $status->insert();
if ($_POST['group_id'] == 1 || $_POST['group_id'] == 2) {
$inserted['studies'] = $studies->insert();
}
// TODO Failure handling here is non-existent
// Need to better handle the case when database insertion partially fails
$success = true;
foreach ($inserted as $key => $value) {
if ($value == false) {
array_push($warning_messages, lang("COULD_NOT_SAVE_IN_DATABASE", array($key)));
}
}
}
}
}
}
