public/main/work/work_list_all.php
<?php
/* For licensing terms, see /license.txt */
use Chamilo\CoreBundle\Framework\Container;
use Chamilo\CourseBundle\Entity\CStudentPublication;
use Chamilo\CoreBundle\Component\Utils\ActionIcon;
use Chamilo\CoreBundle\Component\Utils\ObjectIcon;
require_once __DIR__.'/../inc/global.inc.php';
$current_course_tool = TOOL_STUDENTPUBLICATION;
api_protect_course_script(true);
$this_section = SECTION_COURSES;
$workId = isset($_GET['id']) ? (int) $_GET['id'] : null;
$is_allowed_to_edit = api_is_allowed_to_edit() || api_is_coach();
if (empty($workId)) {
api_not_allowed(true);
}
$my_folder_data = get_work_data_by_id($workId);
if (empty($my_folder_data)) {
api_not_allowed(true);
}
$course = api_get_course_entity();
$work_data = get_work_assignment_by_id($workId);
$repo = Container::getStudentPublicationRepository();
$isDrhOfCourse = CourseManager::isUserSubscribedInCourseAsDrh(
api_get_user_id(),
api_get_course_info()
);
if (!($is_allowed_to_edit || $isDrhOfCourse)) {
api_not_allowed(true);
}
$group_id = api_get_group_id();
$courseInfo = api_get_course_info();
$sessionId = api_get_session_id();
$htmlHeadXtra[] = api_get_jqgrid_js();
$user_id = api_get_user_id();
if (!empty($group_id)) {
$group_properties = api_get_group_entity($group_id);
if (api_is_allowed_to_edit(false, true)) {
$show_work = true;
} else {
// you are not a teacher
$show_work = GroupManager::userHasAccess(
$user_id,
$group_properties,
GroupManager::GROUP_TOOL_WORK
);
}
if (!$show_work) {
api_not_allowed();
}
$interbreadcrumb[] = [
'url' => api_get_path(WEB_CODE_PATH).'group/group.php?'.api_get_cidreq(),
'name' => get_lang('Groups'),
];
$interbreadcrumb[] = [
'url' => api_get_path(WEB_CODE_PATH).'group/group_space.php?'.api_get_cidreq(),
'name' => get_lang('Group area').' '.$group_properties->getTitle(),
];
}
$interbreadcrumb[] = [
'url' => api_get_path(WEB_CODE_PATH).'work/work.php?'.api_get_cidreq(),
'name' => get_lang('Assignments'),
];
$interbreadcrumb[] = [
'url' => api_get_path(WEB_CODE_PATH).'work/work_list_all.php?'.api_get_cidreq().'&id='.$workId,
'name' => $my_folder_data['title'],
];
$action = isset($_REQUEST['action']) ? $_REQUEST['action'] : null;
$itemId = isset($_REQUEST['item_id']) ? (int) $_REQUEST['item_id'] : null;
switch ($action) {
case 'export_to_doc':
if ($is_allowed_to_edit) {
if (!empty($itemId)) {
$work = get_work_data_by_id($itemId);
if (!empty($work)) {
Export::htmlToOdt($work['description'], $work['title']);
}
}
}
break;
case 'delete':
/* Delete document */
if ($itemId) {
$fileDeleted = deleteWorkItem($itemId, $course);
if (!$fileDeleted) {
Display::addFlash(
Display::return_message(get_lang('You are not allowed to delete this document'), 'error')
);
} else {
Display::addFlash(
Display::return_message(get_lang('The document has been deleted.'), 'confirmation')
);
}
}
header('Location: '.api_get_self().'?'.api_get_cidreq().'&id='.$workId);
exit;
break;
case 'delete_correction':
$result = get_work_user_list(null, null, null, null, $workId);
if ($result) {
foreach ($result as $item) {
/** @var CStudentPublication $work */
$work = $repo->find($item['id']);
if ($work) {
deleteCorrection($work);
}
}
Display::addFlash(
Display::return_message(get_lang('Deleted'), 'confirmation')
);
}
header('Location: '.api_get_self().'?'.api_get_cidreq().'&id='.$workId);
exit;
break;
case 'make_visible':
if ($is_allowed_to_edit) {
if (!empty($itemId)) {
if (isset($itemId) && 'all' == $itemId) {
} else {
makeVisible($itemId, $courseInfo);
Display::addFlash(
Display::return_message(get_lang('The file is now visible'), 'confirmation')
);
}
}
}
break;
case 'make_invisible':
if (!empty($itemId)) {
if (isset($itemId) && 'all' == $itemId) {
} else {
makeInvisible($itemId, $courseInfo);
Display::addFlash(
Display::return_message(get_lang('The file is now invisible'), 'confirmation')
);
}
}
break;
case 'export_pdf':
exportAllStudentWorkFromPublication(
$workId,
$courseInfo,
$sessionId,
'pdf'
);
break;
}
$htmlHeadXtra[] = api_get_jquery_libraries_js(['jquery-upload']);
Display::display_header(null);
$documentsAddedInWork = getAllDocumentsFromWorkToString($workId, $courseInfo);
$actionsLeft = '<a href="'.api_get_path(WEB_CODE_PATH).'work/work.php?'.api_get_cidreq().'">'.
Display::getMdiIcon(ActionIcon::BACK, 'ch-tool-icon', null, ICON_SIZE_MEDIUM, get_lang('Back to Assignments list')).'</a>';
if (api_is_allowed_to_session_edit(false, true) && !empty($workId) && !$isDrhOfCourse) {
$blockAddDocuments = ('true' === api_get_setting('work.block_student_publication_add_documents'));
if (!$blockAddDocuments) {
$actionsLeft .= '<a
href="'.api_get_path(WEB_CODE_PATH).'work/add_document.php?'.api_get_cidreq().'&id='.$workId.'">';
$actionsLeft .= Display::getMdiIcon(ObjectIcon::DOCUMENT, 'ch-tool-icon', null, ICON_SIZE_MEDIUM, get_lang('Add document')).'</a>';
}
$actionsLeft .= '<a
href="'.api_get_path(WEB_CODE_PATH).'work/add_user.php?'.api_get_cidreq().'&id='.$workId.'">';
$actionsLeft .= Display::getMdiIcon(ActionIcon::ADD_USER, 'ch-tool-icon', null, ICON_SIZE_MEDIUM, get_lang('Add a user')).'</a>';
$actionsLeft .= '<a
href="'.api_get_path(WEB_CODE_PATH).'work/work_list_all.php?'.api_get_cidreq().'&id='.$workId.'&action=export_pdf">';
$actionsLeft .= Display::getMdiIcon(ActionIcon::EXPORT_PDF, 'ch-tool-icon', null, ICON_SIZE_MEDIUM, get_lang('Export')).'</a>';
$displayOutput = '<a
href="'.api_get_path(WEB_CODE_PATH).'work/work_missing.php?'.api_get_cidreq().'&id='.$workId.'&list=without">'.
Display::getMdiIcon(ActionIcon::GRADE, 'ch-tool-icon-disabled', null, ICON_SIZE_MEDIUM, get_lang('View missing assignments')).'</a>';
$editLink = '<a href="'.api_get_path(WEB_CODE_PATH).'work/edit_work.php?'.api_get_cidreq().'&id='.$workId.'">';
$editLink .= Display::getMdiIcon(ActionIcon::EDIT, 'ch-tool-icon', null, ICON_SIZE_MEDIUM, get_lang('Edit')).'</a>';
$blockEdition = ('true' === api_get_setting('work.block_student_publication_edition'));
if ($blockEdition && !api_is_platform_admin()) {
$editLink = '';
}
$actionsLeft .= $editLink;
$count = get_count_work($workId);
if ($count > 0) {
$router = Container::getRouter();
/** @var CStudentPublication $studentPublication */
$studentPublication = $repo->find($workId);
$downloadUrl = $repo->getResourceFileDownloadUrl($studentPublication).'?'.api_get_cidreq();
$displayOutput .= '<a class="btn-toolbar" href="'.$downloadUrl.'?'.api_get_cidreq().'">'.
Display::getMdiIcon(ActionIcon::EXPORT_ARCHIVE, 'ch-tool-icon', null, ICON_SIZE_MEDIUM, get_lang('Download assignments package')).' '.get_lang('Download assignments package').'</a>';
}
$actionsLeft .= $displayOutput;
// @todo fix upload corrections.
/*$url = api_get_path(WEB_CODE_PATH).'work/upload_corrections.php?'.api_get_cidreq().'&id='.$workId;
$actionsLeft .= '<a class="btn-toolbar" href="'.$url.'">'.
Display::getMdiIcon(ActionIcon::UPLOAD, 'ch-tool-icon', null, ICON_SIZE_MEDIUM, get_lang('Upload corrections package')).' '.get_lang('Upload corrections package').'</a>';
*/
$url = api_get_path(WEB_CODE_PATH).
'work/work_list_all.php?'.api_get_cidreq().'&id='.$workId.'&action=delete_correction';
$actionsLeft .= Display::toolbarButton(get_lang('Delete all corrections'), $url, 'delete', 'danger');
}
echo Display::toolbarAction('toolbar-worklist', [$actionsLeft]);
$plagiarismListJqgridColumn = [];
$plagiarismListJqgridLine = [];
$allowAntiPlagiarism = ('true' === api_get_setting('document.allow_compilatio_tool'));
if ($allowAntiPlagiarism) {
$plagiarismListJqgridColumn = ['Compilatio'];
$plagiarismListJqgridLine = [
[
'name' => 'compilatio',
'index' => 'compilatio',
'width' => '40',
'align' => 'left',
'search' => 'false',
'sortable' => 'false',
],
];
}
if (!empty($my_folder_data['title'])) {
echo Display::page_subheader($my_folder_data['title']);
}
if (!empty($my_folder_data['description'])) {
$contentWork = Security::remove_XSS($my_folder_data['description']);
$html = '';
$html .= Display::panel($contentWork, get_lang('Description'));
echo $html;
}
$check_qualification = (int) $my_folder_data['qualification'];
$orderName = api_is_western_name_order() ? 'firstname' : 'lastname';
if (!empty($work_data['enable_qualification']) &&
!empty($check_qualification)
) {
$type = 'simple';
$columns = [
get_lang('Full name'),
get_lang('Title'),
get_lang('Score'),
get_lang('Date'),
get_lang('Status'),
get_lang('Upload correction'),
];
$columns = array_merge($columns, $plagiarismListJqgridColumn);
$columns[] = get_lang('Detail');
$column_model = [
[
'name' => 'fullname',
'index' => $orderName,
'width' => '30',
'align' => 'left',
'search' => 'true',
],
[
'name' => 'title',
'index' => 'title',
'width' => '25',
'align' => 'left',
'search' => 'false',
'wrap_cell' => 'true',
],
[
'name' => 'qualification',
'index' => 'qualification',
'width' => '15',
'align' => 'center',
'search' => 'true',
],
[
'name' => 'sent_date',
'index' => 'sent_date',
'width' => '25',
'align' => 'left',
'search' => 'true',
'wrap_cell' => 'true',
],
[
'name' => 'qualificator_id',
'index' => 'qualificator_id',
'width' => '20',
'align' => 'left',
'search' => 'true',
],
[
'name' => 'correction',
'index' => 'correction',
'width' => '30',
'align' => 'left',
'search' => 'false',
'sortable' => 'false',
'title' => 'false',
],
];
$column_model = array_merge($column_model, $plagiarismListJqgridLine);
$column_model[] = [
'name' => 'actions',
'index' => 'actions',
'width' => '25',
'align' => 'left',
'search' => 'false',
'sortable' => 'false',
];
} else {
$type = 'complex';
$columns = [
get_lang('Full name'),
get_lang('Title'),
get_lang('Feedback'),
get_lang('Date'),
get_lang('Upload correction'),
];
$columns = array_merge($columns, $plagiarismListJqgridColumn);
$columns[] = get_lang('Detail');
$column_model = [
[
'name' => 'fullname',
'index' => $orderName,
'width' => '35',
'align' => 'left',
'search' => 'true',
],
[
'name' => 'title',
'index' => 'title',
'width' => '30',
'align' => 'left',
'search' => 'false',
'wrap_cell' => 'true',
],
[
'name' => 'qualification',
'index' => 'qualification',
'width' => '20',
'align' => 'center',
'search' => 'true',
],
[
'name' => 'sent_date',
'index' => 'sent_date',
'width' => '30',
'align' => 'left',
'search' => 'true',
'wrap_cell' => 'true',
],
[
'name' => 'correction',
'index' => 'correction',
'width' => '40',
'align' => 'left',
'search' => 'false',
'sortable' => 'false',
'title' => 'false',
],
];
$column_model = array_merge($column_model, $plagiarismListJqgridLine);
$column_model[] = [
'name' => 'actions',
'index' => 'actions',
'width' => '25',
'align' => 'left',
'search' => 'false',
'sortable' => 'false',
];
}
$extra_params = [
'autowidth' => 'true',
'height' => 'auto',
'sortname' => $orderName,
'sortable' => 'false',
'multiselect' => 'true',
];
$url = api_get_path(WEB_AJAX_PATH).
'model.ajax.php?a=get_work_user_list_all&work_id='.$workId.'&type='.$type.'&'.api_get_cidreq();
$workUrl = api_get_path(WEB_AJAX_PATH).'work.ajax.php?'.api_get_cidreq();
$deleteUrl = $workUrl.'&a=delete_student_work';
$showUrl = $workUrl.'&a=show_student_work';
$hideUrl = $workUrl.'&a=hide_student_work';
if ($allowAntiPlagiarism) {
$extra_params['gridComplete'] = 'compilatioInit()';
}
?>
<script>
$(function() {
<?php
echo Display::grid_js('results', $url, $columns, $column_model, $extra_params);
?>
$("#results").jqGrid(
"navGrid",
"#results_pager",
{ edit: false, add: false, search: false, del: true },
{ height:280, reloadAfterSubmit:false }, // edit options
{ height:280, reloadAfterSubmit:false }, // add options
{ reloadAfterSubmit:false, url: "<?php echo $deleteUrl; ?>" }, // del options
{ width:500 } // search options
).navButtonAdd('#results_pager', {
caption:"<i class=\"fa fa-eye\" ></i>",
buttonicon:"ui-icon-blank",
onClickButton: function(a) {
var userIdList = $("#results").jqGrid('getGridParam', 'selarrrow');
if (userIdList.length) {
$.ajax({
type: "POST",
url: "<?php echo $showUrl; ?>&item_list=" + userIdList,
dataType: "json",
success: function(data) {
$('#results').trigger('reloadGrid');
}
});
} else {
alert("<?php echo addslashes(get_lang('Please select an option')); ?>");
}
},
position:"last"
}).navButtonAdd('#results_pager', {
//caption:"<?php //echo addslashes(get_lang('Set visible'));?>//",
caption:"<i class=\"fa fa-eye-slash\" ></i>",
buttonicon:"ui-icon-blank",
onClickButton: function(a) {
var userIdList = $("#results").jqGrid('getGridParam', 'selarrrow');
if (userIdList.length) {
$.ajax({
type: "POST",
url: "<?php echo $hideUrl; ?>&item_list=" + userIdList,
dataType: "json",
success: function(data) {
$('#results').trigger('reloadGrid');
}
});
} else {
alert("<?php echo addslashes(get_lang('Please select an option')); ?>");
}
},
position:"last"
});
});
</script>
<?php
echo $documentsAddedInWork;
$tableWork = Display::grid_html('results');
echo workGetExtraFieldData($workId);
echo Display::panel($tableWork);
if ($allowAntiPlagiarism) {
echo '<div id="compilation-results"></div>';
echo '<div class="list-work-results">';
$table = '<table style="display:none; width:100%" class="files data_table">
<tr>
<th>'.get_lang('Filename').'</th>
<th>'.get_lang('Size').'</th>
<th>'.get_lang('Status').'</th>
</tr>
</table>';
Display::panel($table);
echo '</div>';
$workTable = Database:: get_course_table(TABLE_STUDENT_PUBLICATION);
$courseId = $courseInfo['real_id'];
$formAction['analyseCompilatio'] = [
'label' => get_lang('Start Compilatio analysis'),
'data-action' => get_lang('Start Compilatio analysis'),
'onClick' => "onclick='getMultiCompilatio()'",
];
$html = '<form class="form-search" method="post" name="form_actions">';
$html .= '<input type="hidden" name="action">';
$html .= '<table style="width:100%;">';
$html .= '<tr>';
$html .= '<td>';
$html .= '<div class="btn-toolbar">';
$html .= '<div class="btn-group">';
$html .= '<a class="btn btn--plain" href="?'
.'&'.'gbox_results'.'&'.'selectall=1" onclick="javascript: setCheckbox(true, \''
.'gbox_results'.'\'); return false;">'
.get_lang('Select all')
.'</a>';
$html .= '<a class="btn btn--plain" href="?'
.'" onclick="javascript: setCheckbox(false, \''
.'gbox_results'
.'\'); return false;">'
.get_lang('UnSelect all')
.'</a> ';
$html .= '</div>';
$html .= '<div class="btn-group">
<button class="btn btn--plain" onclick="javascript:return false;">'
.get_lang('Detail')
.'</button>'
.'<button class="btn btn--plain dropdown-toggle" data-toggle="dropdown">'
.'<span class="caret"></span>'
.'</button>';
$html .= '<ul class="dropdown-menu">';
foreach ($formAction as $action) {
$html .= '<li>
<a data-action ="'.$action['data-action'].'" href="#" '.$action['onClick'].'>'
.$action['label'].'</a>
</li>';
}
$html .= '</ul>';
$html .= '</div>';
$html .= '</div>';
$html .= '</td></tr></table></form>';
echo $html;
$compTable = Database::get_course_table(TABLE_PLAGIARISM);
$listCompilatioDocId = [];
$compilatioQuery = "SELECT * FROM $compTable WHERE c_id= $courseId";
$compilatioResult = Database::query($compilatioQuery);
while ($compilatioData = Database::fetch_array($compilatioResult)) {
array_push($listCompilatioDocId, $compilatioData['document_id']);
}
$javascriptWorkId = '';
$sql = "SELECT * FROM $workTable WHERE c_id= $courseId AND parent_id= $workId AND active = 1";
$res = Database::query($sql);
while ($data = Database::fetch_array($res)) {
if (in_array($data['id'], $listCompilatioDocId)) {
$javascriptWorkId .= $data['id'].'a';
}
} ?>
<!--
Lets display the javascript AJAX tools for refreshing datas that needed to be refreshed
Only document with state ANALYSE_IN_QUEUE or ANALYSE_PROCESSING need to ask server
for a new state
Hubert Borderiou - Grenoble Universites - avril 2013
-->
<script>
var xhrObject; // the htmlhttprequest object
var analyseComplete = "ANALYSE_COMPLETE";
var analyseProcessing = "ANALYSE_PROCESSING";
var analyseInQueue = "ANALYSE_IN_QUEUE";
var refreshDelaisAfter = 30000;
var allWorkId = "<?php echo $javascriptWorkId; ?>";
var workFolderId = "<?php echo $workId; ?>";
var compilationWebUrl = "<?php echo api_get_path(WEB_CODE_PATH).'plagiarism/compilatio/'; ?>";
var divExisteTimer = null;
var msgWaitJS = '<?php echo Display::return_message(get_lang('Please wait. This could take a while...')); ?>';
var div = document.createElement('div');
var referent = document.getElementById('compilation-results');
var Analyse = '<?php echo get_lang('Analyse'); ?>';
var compiReport = '<?php echo get_lang('See report'); ?>';
var compiNonToAnalyse = '<?php echo Display::return_message(get_lang('Your selection contains no jobs to analyze. Only jobs managed by Compilatio and not already scanned can be sent.'), 'error'); ?>';
var clickTrigger = false;
function compilatioInit() {
if (isWorkFolder()) {
searchAdvancement();
setInterval("searchAdvancement()", refreshDelaisAfter);
//if (!clickTrigger) {
//clickTrigger = true;
$('.getSingleCompilatio').on('click', function () {
var parts = $(this).parent().attr('id').split('id_avancement');
getSingleCompilatio(parts[1]);
});
//}
}
}
// true if we are in a work folder
function isWorkFolder() {
var res = false;
if (workFolderId.match(/[0-9]+/)) {
res = true;
}
return res;
}
// check all compilatio docs
function checkAllCompilatio(action) {
$("input").each(function () {
if ($(this).attr("id")) {
objId = $(this).attr("id");
listObjId = objId.match(/jqg_results_(\d+)/)
if (listObjId.length > 1) {
$(this).prop('checked', action);
}
}
});
}
function getSingleCompilatio(itemId) {
if (div.id == "status_message") {
referent.removeChild(div);
}
div.id = "status_message";
div.className = 'row';
div.innerHTML = '<div class="col-md-6"> <br>' + msgWaitJS + '</div>';
referent.appendChild(div);
$.ajax({
url: compilationWebUrl + "upload.php?<?php echo api_get_cidreq(); ?>&doc=" + itemId,
type: "get",
dataType: "html",
beforeSend: function() {
$('#id_avancement' + itemId + ' a').addClass('disabled');
},
success: function (message) {
allWorkId += itemId + "a";
compilatioInit();
if (message.trim() != "") {
div.id = "status_message";
div.className = 'row';
div.innerHTML = '<div class="col-md-6"> <br>' + message + '</div>';
referent.appendChild(div);
}
}
});
}
function getMultiCompilatio() {
if (div.id == "status_message") {
referent.removeChild(div);
}
div.id = "status_message";
div.className = 'row';
div.innerHTML = '<div class="col-md-6"> <br>' + msgWaitJS + '</div>';
referent.appendChild(div);
multi_compilatio = "";
$("input:checked").each(function () {
if ($(this).attr("id")) {
objId = $(this).attr("id");
listObjId = objId.match(/jqg_results_(\d+)/)
if (listObjId) {
objClick = document.getElementById('id_avancement' + listObjId[1]);
if (objClick) {
objLink = objClick.getElementsByTagName('a');
if (objLink) {
stringLink = [].map.call(objLink, function (node) {
return node.textContent || node.innerText || "";
}).join("");
if (stringLink.trim() == Analyse.trim()) {
if (listObjId && listObjId.length > 1) {
multi_compilatio += listObjId[1] + "a";
}
}
}
}
}
}
});
if ($("#verif")) {
$("#verif").append(multi_compilatio);
}
// run compilatio
if (multi_compilatio != "") {
$.ajax({
url: compilationWebUrl + "upload.php?<?php echo api_get_cidreq(); ?>",
data: {doc: multi_compilatio, type: "multi"}, // on envoie $_GET['id_region'] *// idz
success: function (message) { // idz
allWorkId = multi_compilatio;//idz
compilatioInit();
if (message.trim() != "") {
div.id = "status_message";
div.className = 'row';
div.innerHTML = '<div class="col-md-6"> <br>' + message + '</div>';
referent.appendChild(div);
}
}
});
} else {
// multi_compilatio is empty
div.id = "status_message";
div.className = 'row';
div.innerHTML = '<div class="col-md-6"> <br>' + compiNonToAnalyse + '</div>';
referent.appendChild(div);
}
}
function searchAdvancement(workId) {
$.ajax({
url: compilationWebUrl + "compilatio_ajax.php?<?php echo api_get_cidreq(); ?>&workid=" + allWorkId,
type: "get",
dataType: "html",
error: function () {
showData("<?php echo get_lang('AJAX communication with the Compilatio server impossible. Please retry later.'); ?>");
},
success: function (strData) {
showData(strData);
}
});
}
function deleteIdListeRefresh(id) {
var regexp = eval("/" + id + ":/");
allWorkId = allWorkId.replace(regexp, "");
}
function showData(res) {
var listRes = new Array();
$("#verif").html("");
// parse the answer string
listRes = res.split("|");
for (var i = 0; i < listRes.length; i = i + 3) {
if (listRes[i] != "") {
var workId = listRes[i];
if (i < listRes.length) {
var HTMLcode = listRes[i + 1];
}
if (i < listRes.length + 1) {
var idStatus = listRes[i + 2];
if (idStatus != analyseInQueue && idStatus != analyseProcessing) {
deleteIdListeRefresh(workId);
}
$("#verif").append(workId + ":" + idStatus + "<br/>");
}
$("#" + "id_avancement" + workId).html(HTMLcode);
}
}
}
</script>
<?php
}
Display::display_footer();