function GetPublicationInfo($post_id)
{
//$db = new PDO('mysql:host='.$_SESSION['DB_HOST'] . ';dbname=' . $_SESSION['DB_NAME'], $_SESSION['DB_USER'], $_SESSION['DB_PASSWORD'], array(PDO::MYSQL_ATTR_INIT_COMMAND => "SET NAMES utf8"));
$selectedPost = get_post($post_id);
//print_r($selectedPost);
//echo $selectedPost->guid;
// get the record for the current supplied ID
/*
$sql = "SELECT * FROM `bh_posts` WHERE ID = $post_id";
$st = $db->query($sql);
// grab the title and date
foreach ($st as $rec) {
$result['post_title'] = $rec['post_title'];
$result['post_date'] = $rec['post_date'];
}
*/
$result['post_title'] = $selectedPost->post_title;
$result['post_date'] = $selectedPost->post_date;
/*
// get the uploaded file URL
$sql = "SELECT * FROM `bh_postmeta` where post_id = $post_id and meta_key = 'wpa_upload_doc'";
$document_url = "";
$st = $db->query($sql);
foreach ($st as $rec) {
$document_url = $rec['meta_value'];
//echo 'url=' . $document_url;
}
*/
//$selectedPostMeta = get_post_meta($post_id, 'wpa_upload_doc', true);
$selectedPostMeta = get_post_meta($post_id);
$document_url = $selectedPostMeta['wpa_upload_doc'][0];
//echo '<pre>';
//print_r($selectedPostMeta);
//echo '</pre>';
// identifies the document as Advisor Only
$advisorOnlyDocument = 0;
if ($selectedPostMeta['sac_locked'][0] == 'logged in') {
$advisorOnlyDocument = 1;
}
$managers = $selectedPostMeta['BH_manager_id'][0];
$manager_ids = ExtractPostIds($managers);
$manager_names = array();
foreach ($manager_ids as $manager_id) {
$managerPost = get_post($manager_id);
$manager_names[] = $managerPost->post_title;
}
/*
$sql = "SELECT * FROM `bh_postmeta` where post_id = $post_id and meta_key = 'BH_manager_id'";
$st = $db->query($sql);
$managers = -1;
foreach ($st as $rec) {
$managers = $rec['meta_value'];
//echo 'man='.$managers;
}
$manager_names = array();
if ($managers != -1) {
$manager_ids = ExtractPostIds($managers);
foreach ($manager_ids as $manager_id) {
$sql = "SELECT * FROM `bh_posts` WHERE ID = $manager_id";
$st = $db->query($sql);
foreach ($st as $rec) {
$manager_names[] = $rec['post_title'];
}
}
}
*/
/*$sql = "SELECT count(*) as cnt
FROM `bh_term_relationships` , `bh_term_taxonomy` , `bh_terms`
WHERE `bh_term_relationships`.term_taxonomy_id = `bh_term_taxonomy`.term_taxonomy_id
AND `bh_term_taxonomy`.term_id = `bh_terms`.term_id
AND `bh_term_relationships`.object_id = $post_id
and ( slug = 'bibliotheque-de-videos' or slug = 'video-library')";
$st = $db->query($Sql);
foreach ($st as $rec) {
$is_video = $rec['cnt'];
}*/
if (has_term(array('video-library', 'bibliotheque-de-videos'), 'knowledge_type', $post_id)) {
$result['DocumentType'] = 'Video';
} else {
$result['DocumentType'] = 'PDF';
}
//$downloads = 0;
//$sql = "SELECT * FROM `im_doc_popularity` where PostId = $post_id";
//$st = $db->query($Sql);
global $wpdb;
$downloads = $wpdb->get_var("SELECT Downloads FROM `im_doc_popularity` where PostId = {$post_id}");
/*
foreach ($st as $rec) {
$downloads = $rec['Downloads'];
}
*/
$result['PostId'] = $post_id;
$result['Downloads'] = $downloads;
$result['ManagerNames'] = $manager_names;
//$result['ManagerNames'] = $managerPost->post_title;
$result['DocumentURL'] = $document_url;
$result['DocumentInMyLibrary'] = IsDocumentInMyLibrary($post_id);
$result['AdvisorOnlyDocument'] = $advisorOnlyDocument;
//$db = null;
//echo '<pre>';
//print_r($result);
//echo '</pre>';
return $result;
}
function GetPublicationInfo($post_id)
{
$db = new PDO('mysql:host=' . $_SESSION['DB_HOST'] . ';dbname=' . $_SESSION['DB_NAME'], $_SESSION['DB_USER'], $_SESSION['DB_PASSWORD']);
// get the record for the current supplied ID
$sql = "SELECT * FROM `wp_posts` WHERE ID = {$post_id}";
$st = $db->query($sql);
// grab the title and date
foreach ($st as $rec) {
$result['post_title'] = $rec['post_title'];
$result['post_date'] = $rec['post_date'];
}
// get the uploaded file URL
$sql = "SELECT * FROM `wp_postmeta` where post_id = {$post_id} and meta_key = 'wpa_upload_doc'";
$document_url = "";
$st = $db->query($sql);
foreach ($st as $rec) {
$document_url = $rec['meta_value'];
}
$sql = "SELECT * FROM `wp_postmeta` where post_id = {$post_id} and meta_key = 'BH_manager_id'";
$st = $db->query($sql);
$managers = -1;
foreach ($st as $rec) {
$managers = $rec['meta_value'];
}
$manager_names = array();
if ($managers != -1) {
$manager_ids = ExtractPostIds($managers);
foreach ($manager_ids as $manager_id) {
$sql = "SELECT * FROM `wp_posts` WHERE ID = {$manager_id}";
$st = $db->query($sql);
foreach ($st as $rec) {
$manager_names[] = $rec['post_title'];
}
}
}
/*$sql = "SELECT count(*) as cnt
FROM `wp_term_relationships` , `wp_term_taxonomy` , `wp_terms`
WHERE `wp_term_relationships`.term_taxonomy_id = `wp_term_taxonomy`.term_taxonomy_id
AND `wp_term_taxonomy`.term_id = `wp_terms`.term_id
AND `wp_term_relationships`.object_id = $post_id
and ( slug = 'bibliotheque-de-videos' or slug = 'video-library')";
$st = $db->query($Sql);
foreach ($st as $rec) {
$is_video = $rec['cnt'];
}*/
if (has_term(array('video-library', 'bibliotheque-de-videos'), 'knowledge_type', $post_id)) {
$result['DocumentType'] = 'Video';
} else {
$result['DocumentType'] = 'PDF';
}
$downloads = 0;
$sql = "SELECT * FROM `im_doc_popularity` where PostId = {$post_id}";
$st = $db->query($Sql);
foreach ($st as $rec) {
$downloads = $rec['Downloads'];
}
$result['PostId'] = $post_id;
$result['Downloads'] = $downloads;
$result['ManagerNames'] = $manager_names;
$result['DocumentURL'] = $document_url;
$result['DocumentInMyLibrary'] = IsDocumentInMyLibrary($post_id);
$db = null;
return $result;
}
