public function getlist() { $id_category = Get::req('id_category', DOTY_INT, 0); $show_descendants = Get::req('descendants', DOTY_INT, 0) > 0; $start_index = Get::req('startIndex', DOTY_INT, 0); $results = Get::req('results', DOTY_MIXED, Get::sett('visuItem', 25)); $sort = Get::req('sort', DOTY_MIXED, 'title'); $dir = Get::req('dir', DOTY_MIXED, 'asc'); $filter_text = Get::req('filter_text', DOTY_STRING, ""); $filter = array('text' => $filter_text); $total_comm = $this->model->total($filter, $id_category, $show_descendants); $array_comm = $this->model->findAll($start_index, $results, $sort, $dir, $filter, $id_category, $show_descendants); $comm_id_arr = array(); foreach ($array_comm as $key => $value) { $type = $array_comm[$key]['type_of']; if ($type == 'file') { $comm_id_arr[] = $value['id_comm']; } } require_once _lms_ . '/lib/lib.kbres.php'; $kbres = new KbRes(); $categorized_file_items = $kbres->getCategorizedResources($comm_id_arr, "file", "communication", true); $categorized_file_items_id = !empty($categorized_file_items) ? array_keys($categorized_file_items) : array(); $list = array(); foreach ($array_comm as $key => $value) { $array_comm[$key]['id'] = $value['id_comm']; if ($filter_text) { $array_comm[$key]['title'] = highlightText($value['title'], $filter_text); $array_comm[$key]['description'] = highlightText($value['description'], $filter_text); } $array_comm[$key]['publish_date'] = Format::date($value['publish_date'], 'date'); $type = $array_comm[$key]['type_of']; if ($type == 'file' || $type == 'scorm') { if ($type == 'scorm' || in_array($value['id_comm'], $categorized_file_items_id)) { $array_comm[$key]['categorize'] = '<a class="ico-sprite subs_categorize" title="' . Lang::t('_CATEGORIZE', 'kb') . '" href="index.php?r=alms/communication/categorize&id_comm=' . $value['id_comm'] . '"><span>' . Lang::t('_CATEGORIZE', 'kb') . '</span></a>'; } else { $array_comm[$key]['categorize'] = '<a class="ico-sprite fd_notice" title="' . Lang::t('_NOT_CATEGORIZED', 'kb') . '" href="index.php?r=alms/communication/categorize&id_comm=' . $value['id_comm'] . '"><span>' . Lang::t('_NOT_CATEGORIZED', 'kb') . '</span></a>'; } } else { $array_comm[$key]['categorize'] = ''; } if ($value['access_entity']) { $array_comm[$key]['user'] = '******' . Lang::t('_ASSIGN_USERS', 'communication') . '" href="index.php?r=alms/communication/mod_user&id_comm=' . $value['id_comm'] . '&load=1"><span>' . Lang::t('_ASSIGN_USERS', 'communication') . '</span></a>'; } else { $array_comm[$key]['user'] = '******' . Lang::t('_NO_USER_SELECTED', 'communication') . '" href="index.php?r=alms/communication/mod_user&id_comm=' . $value['id_comm'] . '&load=1"><span>' . Lang::t('_ASSIGN_USERS', 'communication') . '</span></a>'; } $array_comm[$key]['edit'] = '<a class="ico-sprite subs_mod" href="index.php?r=alms/communication/edit&id_comm=' . $value['id_comm'] . '"><span>' . Lang::t('_MOD', 'communication') . '</span></a>'; $array_comm[$key]['del'] = 'ajax.adm_server.php?r=alms/communication/del&id_comm=' . $value['id_comm']; } $result = array('totalRecords' => $total_comm, 'startIndex' => $start_index, 'sort' => $sort, 'dir' => $dir, 'rowsPerPage' => $results, 'results' => count($array_comm), 'records' => $array_comm); $this->data = $this->json->encode($result); echo $this->data; }
$data = array(); $sco_arr = array(); while ($row = mysql_fetch_assoc($q)) { $sco_id = $row["idscorm_item"]; $sco_arr[] = $sco_id; $data[$i]["idscorm_item"] = $sco_id; $data[$i]["title"] = $row['title']; $url = 'index.php?r=alms/communication/categorize&id_comm=' . $id_comm . ' &idResource=' . $id_resource . '&sco_id=' . $sco_id; //.'&comm_title='.$comm_data['title']; $data[$i]["url"] = $url; $i++; } require_once _lms_ . '/lib/lib.kbres.php'; $kbres = new KbRes(); $categorized_sco = $kbres->getCategorizedResources($sco_arr, "scoitem", "communication", true); $categorized_sco_id = !empty($categorized_sco) ? array_keys($categorized_sco) : array(); foreach ($data as $row) { $line = array(); $sco_id = $row["idscorm_item"]; $line[] = $row['title']; $categorized = false; if (in_array($sco_id, $categorized_sco_id)) { $res_id = $categorized_sco[$sco_id]['res_id']; $line[] = $categorized_sco[$sco_id]['r_type']; $line[] = $categorized_sco[$sco_id]['r_env']; $line[] = $categorized_sco[$sco_id]['r_lang']; $line[] = isset($categorized_sco['tags'][$res_id]) ? implode(',', $categorized_sco['tags'][$res_id]) : ''; $categorized = true; } else { array_push($line, '', '', '', '');
$i = 0; $data = array(); $sco_arr = array(); while ($row = mysql_fetch_assoc($q)) { $sco_id = $row["idscorm_item"]; $sco_arr[] = $sco_id; $data[$i]["idscorm_item"] = $sco_id; $data[$i]["title"] = $row['title']; $url = 'index.php?r=alms/games/categorize&id_game=' . $id_game . ' &idResource=' . $id_resource . '&sco_id=' . $sco_id; $data[$i]["url"] = $url; $i++; } require_once _lms_ . '/lib/lib.kbres.php'; $kbres = new KbRes(); $categorized_sco = $kbres->getCategorizedResources($sco_arr, "scoitem", "games", true); $categorized_sco_id = !empty($categorized_sco) ? array_keys($categorized_sco) : array(); foreach ($data as $row) { $line = array(); $sco_id = $row["idscorm_item"]; $line[] = $row['title']; $categorized = false; if (in_array($sco_id, $categorized_sco_id)) { $res_id = $categorized_sco[$sco_id]['res_id']; $line[] = $categorized_sco[$sco_id]['r_type']; $line[] = $categorized_sco[$sco_id]['r_env']; $line[] = $categorized_sco[$sco_id]['r_lang']; $line[] = isset($categorized_sco['tags'][$res_id]) ? implode(',', $categorized_sco['tags'][$res_id]) : ''; $categorized = true; } else { array_push($line, '', '', '', '');
function getScoItemsTable($id_org, $scormorg_title, $idItem) { require_once _base_ . '/lib/lib.table.php'; $tb = new Table(Get::sett('visu_course')); $id_org = (int) $id_org; $h_type = array('', '', '', '', '', 'image'); $h_content = array(Lang::t('_NAME', 'organization'), Lang::t('_TYPE', 'kb'), Lang::t('_ENVIRONMENT', 'kb'), Lang::t('_LANGUAGE', 'kb'), Lang::t('_TAGS', 'kb'), Lang::t('_CATEGORIZE', 'kb')); $tb->setColsStyle($h_type); $tb->addHead($h_content); $qry = "SELECT t1.idscorm_item, t1.title " . " FROM " . $GLOBALS['prefix_lms'] . "_scorm_items as t1 " . " WHERE t1.idscorm_organization='" . $id_org . "'\r\n\t\t AND t1.idscorm_resource != 0\r\n\t\t\tORDER BY t1.idscorm_item"; $q = sql_query($qry); $i = 0; $data = array(); $sco_arr = array(); while ($row = mysql_fetch_assoc($q)) { $sco_id = $row["idscorm_item"]; $sco_arr[] = $sco_id; $data[$i]["idscorm_item"] = $sco_id; $data[$i]["title"] = $row['title']; $url = 'index.php?modname=storage&op=org_categorize_sco&idItem=' . $idItem . ' &idResource=' . $id_org . '&sco_id=' . $sco_id . '&scormorg_title=' . $scormorg_title; $data[$i]["url"] = $url; $i++; } require_once _lms_ . '/lib/lib.kbres.php'; $kbres = new KbRes(); $categorized_sco = $kbres->getCategorizedResources($sco_arr, "scoitem", "course_lo", true); $categorized_sco_id = !empty($categorized_sco) ? array_keys($categorized_sco) : array(); foreach ($data as $row) { $line = array(); $sco_id = $row["idscorm_item"]; $line[] = $row['title']; $categorized = false; if (in_array($sco_id, $categorized_sco_id)) { $res_id = $categorized_sco[$sco_id]['res_id']; $line[] = $categorized_sco[$sco_id]['r_type']; $line[] = $categorized_sco[$sco_id]['r_env']; $line[] = $categorized_sco[$sco_id]['r_lang']; $line[] = isset($categorized_sco['tags'][$res_id]) ? implode(',', $categorized_sco['tags'][$res_id]) : ''; $categorized = true; } else { array_push($line, '', '', '', ''); } if ($categorized) { $img = '<img src="' . getPathImage() . 'standard/categorize.png" alt="' . Lang::t('_CATEGORIZE', 'kb') . '" title="' . Lang::t('_CATEGORIZE', 'kb') . '" />'; $line[] = '<a href="' . $row['url'] . '">' . $img . '</a>'; } else { $line[] = '<a class="ico-sprite fd_notice" title="' . Lang::t('_NOT_CATEGORIZED', 'kb') . '" href="' . $row['url'] . '"><span>' . Lang::t('_NOT_CATEGORIZED', 'kb') . '</span></a>'; } $tb->addBody($line); } return $tb->getTable(); }