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; }