public static function render_instance(BlockInstance $instance, $editing = false)
{
$configdata = $instance->get('configdata');
$type = isset($configdata['displaytype']) ? $configdata['displaytype'] : 'texticon';
$showicon = $type == 'icononly' || $type == 'texticon' ? true : false;
$showtext = $type == 'textonly' || $type == 'texticon' ? true : false;
$owner = $instance->get('view_obj')->get('owner');
// Whether to include email button
if (isset($configdata['displayemail']) && $configdata['displayemail']) {
$email = get_field('artefact_internal_profile_email', 'email', 'principal', 1, 'owner', $owner);
} else {
$email = false;
}
if (!isset($configdata['artefactids']) || empty($configdata['artefactids'])) {
// When we first come into this block, it will have
// no social profiles configured yet.
$configdata['artefactids'] = array(0);
}
// Include selected social profiles
$sql = 'SELECT title, description, note FROM {artefact}
WHERE id IN (' . join(',', $configdata['artefactids']) . ')
AND owner = ? AND artefacttype = ?
ORDER BY description ASC';
if (!($data = get_records_sql_array($sql, array($owner, 'socialprofile')))) {
$data = array();
}
safe_require('artefact', 'internal');
$data = ArtefactTypeSocialprofile::get_profile_icons($data);
$smarty = smarty_core();
$smarty->assign('showicon', $showicon);
$smarty->assign('showtext', $showtext);
$smarty->assign('profiles', $data);
$smarty->assign('email', $email);
return $smarty->fetch('blocktype:socialprofile:content.tpl');
}
public static function getRecordDataById($type, $id)
{
global $USER;
$sql = 'SELECT a.id, a.artefacttype, a.parent, a.owner, a.title, a.description, a.institution, a.group, a.author,
p.artefacttype AS parent_artefacttype, p.title AS parent_title, p.description AS parent_description, a.license,
afi.width, afi.height, a.note
FROM {artefact} a
LEFT OUTER JOIN {artefact} p ON p.id = a.parent
LEFT OUTER JOIN {artefact_file_image} afi ON afi.artefact = a.id
WHERE a.id = ?';
$record = get_record_sql($sql, array($id));
if (!$record) {
return false;
}
$record->title = str_replace(array("\r\n", "\n", "\r"), ' ', strip_tags($record->title));
$record->description = str_replace(array("\r\n", "\n", "\r"), ' ', strip_tags($record->description));
// If user is owner
if ($USER->get('id') == $record->owner) {
switch ($record->artefacttype) {
case 'image':
case 'video':
case 'audio':
case 'file':
$record->link = 'artefact/file';
if (isset($record->parent) && intval($record->parent) > 0) {
$record->link .= '/index.php?folder=' . $record->parent;
}
break;
case 'blogpost':
if (isset($record->parent) && intval($record->parent) > 0) {
$record->link = 'artefact/blog/view/index.php?id=' . $record->parent;
}
break;
case 'blog':
$record->link = 'artefact/blog/view/index.php';
if ($USER->get_account_preference('multipleblogs')) {
$record->link .= '?id=' . $record->id;
}
break;
case 'coverletter':
case 'personalinformation':
$record->link = 'artefact/resume/index.php';
break;
case 'educationhistory':
case 'employmenthistory':
$record->link = 'artefact/resume/employment.php';
break;
case 'book':
case 'certification':
case 'membership':
$record->link = 'artefact/resume/achievements.php';
break;
case 'academicgoal':
case 'careergoal':
case 'personalgoal':
case 'personalinformation':
case 'academicskill':
case 'personalskill':
case 'workskill':
$record->link = 'artefact/resume/goalsandskills.php';
break;
case 'interest':
$record->link = 'artefact/resume/interests.php';
break;
case 'plan':
$record->link = 'artefact/plans/plan.php?id=' . $record->id;
break;
case 'task':
if (isset($record->parent) && intval($record->parent) > 0) {
$record->link = 'artefact/plans/plan.php?id=' . $record->parent;
}
break;
case 'socialprofile':
$record->note = str_replace(array("\r\n", "\n", "\r"), ' ', strip_tags($record->note));
$socialprofile = new ArtefactTypeSocialprofile($record->id);
$icons = $socialprofile->get_profile_icons(array($record));
if (!empty($icons)) {
$record->link = $icons[0]->link;
$record->icon = $icons[0]->icon;
}
break;
}
}
// VIEWS get all the views the artefact is included into.
// artefact parents are folder, blog, plan, cpd
$sql = 'SELECT COALESCE(v.id, vp.id) AS id, COALESCE(v.title, vp.title) AS title
FROM {artefact} a
LEFT OUTER JOIN {view_artefact} va ON va.artefact = a.id
LEFT OUTER JOIN {view} v ON v.id = va.view
LEFT OUTER JOIN {artefact} parent ON parent.id = a.parent
LEFT OUTER JOIN {view_artefact} vap ON vap.artefact = parent.id
LEFT OUTER JOIN {view} vp ON vp.id = vap.view
WHERE a.id = ?';
$views = get_records_sql_array($sql, array($id));
if ($views) {
$record_views = array();
foreach ($views as $view) {
if (isset($view->id)) {
$record_views[$view->id] = $view->title;
}
}
$record_views = self::views_by_artefact_acl_filter($record_views);
$record->views = $record_views;
}
// Tags
$tags = get_records_array('artefact_tag', 'artefact', $id);
if ($tags != false) {
foreach ($tags as $tag) {
$record->tags[] = $tag->tag;
}
} else {
$record->tags = null;
}
// Created by
if (intval($record->author) > 0) {
$record->createdby = get_record('usr', 'id', $record->author);
$record->createdbyname = display_name($record->createdby);
}
// Thumb
if ($record->artefacttype == 'image') {
if (isset($record->width) && isset($record->height) && intval($record->width) > 0 && intval($record->height) > 0) {
if ($record->width > $record->height) {
$size = '80x' . intval($record->height * 80 / $record->width);
} else {
$size = intval($record->width * 80 / $record->height) . 'x80';
}
}
$record->thumb = ArtefactTypeImage::get_icon(array('id' => $id, 'size' => $size));
}
return $record;
}
