public static function GetBlogsByState($state)
{
$retval = array();
//get all posts
$posts = PostFactory::GetAllPosts();
//then filter
//unpublished
foreach ($posts as $post) {
if ($state == 'unpublished') {
if (isset($post->UnpublishDate) && $post->UnpublishDate > $post->PublishDate) {
array_push($retval, $post);
}
} else {
if ($state == 'notpublished') {
if (isset($post->PublishDate) == FALSE) {
array_push($retval, $post);
}
} else {
if ($state == 'outdated') {
if (isset($post->PublishDate) && $post->ModifiedDate > $post->PublishDate) {
array_push($retval, $post);
}
}
}
}
}
return $retval;
}
$retval = PostFactory::GetPost($postid);
} else {
$retval = PostFactory::NewPost();
}
MySQLConnection::Close($GLOBALS['mysqli']);
echo json_encode($retval);
});
$app->get('/getallposts', function () {
require_once 'common/dbconnection.php';
require_once 'category.php';
require_once 'post.php';
require_once 'posttype.php';
require_once 'userresponse.php';
require_once 'userreply.php';
$GLOBALS['mysqli'] = MySQLConnection::Open();
$retval = PostFactory::GetAllPosts();
MySQLConnection::Close($GLOBALS['mysqli']);
echo json_encode($retval);
});
$app->get('/deletepost/:postid', function ($postid) {
require_once 'common/dbconnection.php';
require_once 'category.php';
require_once 'post.php';
require_once 'userresponse.php';
require_once 'userreply.php';
$GLOBALS['mysqli'] = MySQLConnection::Open();
$blogPost = PostFactory::GetPost($postid);
$blogPost->Delete();
$ret_val['deletedpostid'] = $blogPost->ID;
$ret_val['success'] = 'Blog post deleted';
MySQLConnection::Close($GLOBALS['mysqli']);
