* @license http://www.gnu.org/copyleft/gpl.html GNU GPL version 3 or later * @copyright For copyright information on Mahara, please see the README file distributed with this software. * */ define('INTERNAL', true); define('MENUITEM', 'content/resume'); define('SECTION_PLUGINTYPE', 'artefact'); define('SECTION_PLUGINNAME', 'resume'); define('RESUME_SUBPAGE', 'goalsandskills'); require_once dirname(dirname(dirname(__FILE__))) . '/init.php'; require_once 'pieforms/pieform.php'; require_once 'pieforms/pieform/elements/calendar.php'; require_once get_config('docroot') . 'artefact/lib.php'; safe_require('artefact', 'resume'); safe_require('artefact', 'file'); if (!PluginArtefactResume::is_active()) { throw new AccessDeniedException(get_string('plugindisableduser', 'mahara', get_string('resume', 'artefact.resume'))); } define('TITLE', get_string('resume', 'artefact.resume')); $id = param_integer('id', 0); $type = param_variable('type', ''); if ($id > 0) { $artefact = artefact_instance_from_id($id); $type = $artefact->get('artefacttype'); } else { if ($id == 0 && !empty($type)) { $classname = generate_artefact_class_name($type); try { $artefact = artefact_instance_from_type($type); } catch (Exception $e) { $artefact = new $classname(0, array('owner' => $USER->get('id')));
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': safe_require('artefact', 'internal'); $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; } } require_once get_config('docroot') . 'artefact/resume/lib.php'; if (PluginArtefactResume::is_active()) { // If the artefacttype is one of the résumé ones we need to fetch the related item info $resumetypes = PluginArtefactResume::composite_tabs(); if (array_key_exists($record->artefacttype, $resumetypes)) { try { $query = "SELECT * FROM {artefact_resume_" . $record->artefacttype . "} WHERE artefact = ?"; $results = get_records_sql_assoc($query, array($record->id)); } catch (SQLException $e) { // Table doesn't exist $results = array(); } $record->resumeitems = $results; } } // 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' || $record->artefacttype == 'profileicon') { 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; }