XoopsModules25x /
assessment
| @@ 105-134 (lines=30) @@ | ||
| 102 | * |
|
| 103 | * @return array |
|
| 104 | */ |
|
| 105 | public function getAllassessment_documentoss($criteria = array(), $asobject = false, $sort = 'cod_documento', $order = 'ASC', $limit = 0, $start = 0) |
|
| 106 | { |
|
| 107 | $db = XoopsDatabaseFactory::getDatabaseConnection(); |
|
| 108 | $ret = array(); |
|
| 109 | $where_query = ''; |
|
| 110 | if (is_array($criteria) && count($criteria) > 0) { |
|
| 111 | $where_query = ' WHERE'; |
|
| 112 | foreach ($criteria as $c) { |
|
| 113 | $where_query .= " $c AND"; |
|
| 114 | } |
|
| 115 | $where_query = substr($where_query, 0, -4); |
|
| 116 | } elseif (!is_array($criteria) && $criteria) { |
|
| 117 | $where_query = ' WHERE ' . $criteria; |
|
| 118 | } |
|
| 119 | if (!$asobject) { |
|
| 120 | $sql = 'SELECT cod_documento FROM ' . $db->prefix('assessment_documentos') . "$where_query ORDER BY $sort $order"; |
|
| 121 | $result = $db->query($sql, $limit, $start); |
|
| 122 | while ($myrow = $db->fetchArray($result)) { |
|
| 123 | $ret[] = $myrow['assessment_documentos_id']; |
|
| 124 | } |
|
| 125 | } else { |
|
| 126 | $sql = 'SELECT * FROM ' . $db->prefix('assessment_documentos') . "$where_query ORDER BY $sort $order"; |
|
| 127 | $result = $db->query($sql, $limit, $start); |
|
| 128 | while ($myrow = $db->fetchArray($result)) { |
|
| 129 | $ret[] = new assessment_documentos($myrow); |
|
| 130 | } |
|
| 131 | } |
|
| 132 | ||
| 133 | return $ret; |
|
| 134 | } |
|
| 135 | } |
|
| 136 | ||
| 137 | // ------------------------------------------------------------------------- |
|
| @@ 95-124 (lines=30) @@ | ||
| 92 | * |
|
| 93 | * @return array |
|
| 94 | */ |
|
| 95 | public function getAllassessment_perguntass($criteria = array(), $asobject = false, $sort = 'cod_pergunta', $order = 'ASC', $limit = 0, $start = 0) |
|
| 96 | { |
|
| 97 | $db = XoopsDatabaseFactory::getDatabaseConnection(); |
|
| 98 | $ret = array(); |
|
| 99 | $where_query = ''; |
|
| 100 | if (is_array($criteria) && count($criteria) > 0) { |
|
| 101 | $where_query = ' WHERE'; |
|
| 102 | foreach ($criteria as $c) { |
|
| 103 | $where_query .= " $c AND"; |
|
| 104 | } |
|
| 105 | $where_query = substr($where_query, 0, -4); |
|
| 106 | } elseif (!is_array($criteria) && $criteria) { |
|
| 107 | $where_query = ' WHERE ' . $criteria; |
|
| 108 | } |
|
| 109 | if (!$asobject) { |
|
| 110 | $sql = 'SELECT cod_pergunta FROM ' . $db->prefix('assessment_perguntas') . "$where_query ORDER BY $sort $order"; |
|
| 111 | $result = $db->query($sql, $limit, $start); |
|
| 112 | while ($myrow = $db->fetchArray($result)) { |
|
| 113 | $ret[] = $myrow['assessment_perguntas_id']; |
|
| 114 | } |
|
| 115 | } else { |
|
| 116 | $sql = 'SELECT * FROM ' . $db->prefix('assessment_perguntas') . "$where_query ORDER BY $sort $order"; |
|
| 117 | $result = $db->query($sql, $limit, $start); |
|
| 118 | while ($myrow = $db->fetchArray($result)) { |
|
| 119 | $ret[] = new assessment_perguntas($myrow); |
|
| 120 | } |
|
| 121 | } |
|
| 122 | ||
| 123 | return $ret; |
|
| 124 | } |
|
| 125 | } |
|
| 126 | ||
| 127 | // ------------------------------------------------------------------------- |
|
| @@ 94-123 (lines=30) @@ | ||
| 91 | * |
|
| 92 | * @return array |
|
| 93 | */ |
|
| 94 | public function getAllassessment_provass($criteria = array(), $asobject = false, $sort = 'cod_prova', $order = 'ASC', $limit = 0, $start = 0) |
|
| 95 | { |
|
| 96 | $db = XoopsDatabaseFactory::getDatabaseConnection(); |
|
| 97 | $ret = array(); |
|
| 98 | $where_query = ''; |
|
| 99 | if (is_array($criteria) && count($criteria) > 0) { |
|
| 100 | $where_query = ' WHERE'; |
|
| 101 | foreach ($criteria as $c) { |
|
| 102 | $where_query .= " $c AND"; |
|
| 103 | } |
|
| 104 | $where_query = substr($where_query, 0, -4); |
|
| 105 | } elseif (!is_array($criteria) && $criteria) { |
|
| 106 | $where_query = ' WHERE ' . $criteria; |
|
| 107 | } |
|
| 108 | if (!$asobject) { |
|
| 109 | $sql = 'SELECT cod_prova FROM ' . $db->prefix('assessment_provas') . "$where_query ORDER BY $sort $order"; |
|
| 110 | $result = $db->query($sql, $limit, $start); |
|
| 111 | while ($myrow = $db->fetchArray($result)) { |
|
| 112 | $ret[] = $myrow['assessment_provas_id']; |
|
| 113 | } |
|
| 114 | } else { |
|
| 115 | $sql = 'SELECT * FROM ' . $db->prefix('assessment_provas') . "$where_query ORDER BY $sort $order"; |
|
| 116 | $result = $db->query($sql, $limit, $start); |
|
| 117 | while ($myrow = $db->fetchArray($result)) { |
|
| 118 | $ret[] = new assessment_provas($myrow); |
|
| 119 | } |
|
| 120 | } |
|
| 121 | ||
| 122 | return $ret; |
|
| 123 | } |
|
| 124 | ||
| 125 | /** |
|
| 126 | * Verifica se aluno pode acessar esta prova |
|
| @@ 89-118 (lines=30) @@ | ||
| 86 | * |
|
| 87 | * @return array |
|
| 88 | */ |
|
| 89 | public function getAllassessment_respostass($criteria = array(), $asobject = false, $sort = 'cod_resposta', $order = 'ASC', $limit = 0, $start = 0) |
|
| 90 | { |
|
| 91 | $db = XoopsDatabaseFactory::getDatabaseConnection(); |
|
| 92 | $ret = array(); |
|
| 93 | $where_query = ''; |
|
| 94 | if (is_array($criteria) && count($criteria) > 0) { |
|
| 95 | $where_query = ' WHERE'; |
|
| 96 | foreach ($criteria as $c) { |
|
| 97 | $where_query .= " $c AND"; |
|
| 98 | } |
|
| 99 | $where_query = substr($where_query, 0, -4); |
|
| 100 | } elseif (!is_array($criteria) && $criteria) { |
|
| 101 | $where_query = ' WHERE ' . $criteria; |
|
| 102 | } |
|
| 103 | if (!$asobject) { |
|
| 104 | $sql = 'SELECT cod_resposta FROM ' . $db->prefix('assessment_respostas') . "$where_query ORDER BY $sort $order"; |
|
| 105 | $result = $db->query($sql, $limit, $start); |
|
| 106 | while ($myrow = $db->fetchArray($result)) { |
|
| 107 | $ret[] = $myrow['assessment_respostas_id']; |
|
| 108 | } |
|
| 109 | } else { |
|
| 110 | $sql = 'SELECT * FROM ' . $db->prefix('assessment_respostas') . "$where_query ORDER BY $sort $order"; |
|
| 111 | $result = $db->query($sql, $limit, $start); |
|
| 112 | while ($myrow = $db->fetchArray($result)) { |
|
| 113 | $ret[] = new assessment_respostas($myrow); |
|
| 114 | } |
|
| 115 | } |
|
| 116 | ||
| 117 | return $ret; |
|
| 118 | } |
|
| 119 | } |
|
| 120 | ||
| 121 | // ------------------------------------------------------------------------- |
|
| @@ 93-122 (lines=30) @@ | ||
| 90 | * |
|
| 91 | * @return array |
|
| 92 | */ |
|
| 93 | public function getAllassessment_resultadoss($criteria = array(), $asobject = false, $sort = 'cod_resultado', $order = 'ASC', $limit = 0, $start = 0) |
|
| 94 | { |
|
| 95 | $db = XoopsDatabaseFactory::getDatabaseConnection(); |
|
| 96 | $ret = array(); |
|
| 97 | $where_query = ''; |
|
| 98 | if (is_array($criteria) && count($criteria) > 0) { |
|
| 99 | $where_query = ' WHERE'; |
|
| 100 | foreach ($criteria as $c) { |
|
| 101 | $where_query .= " $c AND"; |
|
| 102 | } |
|
| 103 | $where_query = substr($where_query, 0, -4); |
|
| 104 | } elseif (!is_array($criteria) && $criteria) { |
|
| 105 | $where_query = ' WHERE ' . $criteria; |
|
| 106 | } |
|
| 107 | if (!$asobject) { |
|
| 108 | $sql = 'SELECT cod_resultado FROM ' . $db->prefix('assessment_resultados') . "$where_query ORDER BY $sort $order"; |
|
| 109 | $result = $db->query($sql, $limit, $start); |
|
| 110 | while ($myrow = $db->fetchArray($result)) { |
|
| 111 | $ret[] = $myrow['assessment_resultados_id']; |
|
| 112 | } |
|
| 113 | } else { |
|
| 114 | $sql = 'SELECT * FROM ' . $db->prefix('assessment_resultados') . "$where_query ORDER BY $sort $order"; |
|
| 115 | $result = $db->query($sql, $limit, $start); |
|
| 116 | while ($myrow = $db->fetchArray($result)) { |
|
| 117 | $ret[] = new assessment_resultados($myrow); |
|
| 118 | } |
|
| 119 | } |
|
| 120 | ||
| 121 | return $ret; |
|
| 122 | } |
|
| 123 | ||
| 124 | /** |
|
| 125 | * @return array |
|
