XoopsModules25x /
assessment
| @@ 281-310 (lines=30) @@ | ||
| 278 | * @return array array of <a href='psi_element://$assessment_documentos'>$assessment_documentos</a> objects |
|
| 279 | * objects |
|
| 280 | */ |
|
| 281 | public function &getObjects(CriteriaElement $criteria = null, $id_as_key = false, $as_object = true) |
|
| 282 | { |
|
| 283 | $ret = array(); |
|
| 284 | $limit = $start = 0; |
|
| 285 | $sql = 'SELECT * FROM ' . $this->db->prefix('assessment_documentos'); |
|
| 286 | if (isset($criteria) && is_subclass_of($criteria, 'criteriaelement')) { |
|
| 287 | $sql .= ' ' . $criteria->renderWhere(); |
|
| 288 | if ($criteria->getSort() != '') { |
|
| 289 | $sql .= ' ORDER BY ' . $criteria->getSort() . ' ' . $criteria->getOrder(); |
|
| 290 | } |
|
| 291 | $limit = $criteria->getLimit(); |
|
| 292 | $start = $criteria->getStart(); |
|
| 293 | } |
|
| 294 | $result = $this->db->query($sql, $limit, $start); |
|
| 295 | if (!$result) { |
|
| 296 | return $ret; |
|
| 297 | } |
|
| 298 | while ($myrow = $this->db->fetchArray($result)) { |
|
| 299 | $assessment_documentos = new assessment_documentos(); |
|
| 300 | $assessment_documentos->assignVars($myrow); |
|
| 301 | if (!$id_as_key) { |
|
| 302 | $ret[] =& $assessment_documentos; |
|
| 303 | } else { |
|
| 304 | $ret[$myrow['cod_documento']] =& $assessment_documentos; |
|
| 305 | } |
|
| 306 | unset($assessment_documentos); |
|
| 307 | } |
|
| 308 | ||
| 309 | return $ret; |
|
| 310 | } |
|
| 311 | ||
| 312 | /** |
|
| 313 | * retrieve assessment_documentoss from the database |
|
| @@ 272-301 (lines=30) @@ | ||
| 269 | * @return array array of <a href='psi_element://assessment_perguntas'>assessment_perguntas</a> objects |
|
| 270 | * objects |
|
| 271 | */ |
|
| 272 | public function &getObjects(CriteriaElement $criteria = null, $id_as_key = false, $as_object = true) |
|
| 273 | { |
|
| 274 | $ret = array(); |
|
| 275 | $limit = $start = 0; |
|
| 276 | $sql = 'SELECT * FROM ' . $this->db->prefix('assessment_perguntas'); |
|
| 277 | if (isset($criteria) && is_subclass_of($criteria, 'criteriaelement')) { |
|
| 278 | $sql .= ' ' . $criteria->renderWhere(); |
|
| 279 | if ($criteria->getSort() != '') { |
|
| 280 | $sql .= ' ORDER BY ' . $criteria->getSort() . ' ' . $criteria->getOrder(); |
|
| 281 | } |
|
| 282 | $limit = $criteria->getLimit(); |
|
| 283 | $start = $criteria->getStart(); |
|
| 284 | } |
|
| 285 | $result = $this->db->query($sql, $limit, $start); |
|
| 286 | if (!$result) { |
|
| 287 | return $ret; |
|
| 288 | } |
|
| 289 | while ($myrow = $this->db->fetchArray($result)) { |
|
| 290 | $assessment_perguntas = new assessment_perguntas(); |
|
| 291 | $assessment_perguntas->assignVars($myrow); |
|
| 292 | if (!$id_as_key) { |
|
| 293 | $ret[] = $assessment_perguntas; |
|
| 294 | } else { |
|
| 295 | $ret[$myrow['cod_pergunta']] = $assessment_perguntas; |
|
| 296 | } |
|
| 297 | unset($assessment_perguntas); |
|
| 298 | } |
|
| 299 | ||
| 300 | return $ret; |
|
| 301 | } |
|
| 302 | ||
| 303 | /** |
|
| 304 | * retrieve assessment_perguntass from the database |
|
| @@ 344-373 (lines=30) @@ | ||
| 341 | * @return array array of <a href='psi_element://assessment_perguntas'>assessment_perguntas</a> objects |
|
| 342 | * objects |
|
| 343 | */ |
|
| 344 | public function &getObjects(CriteriaElement $criteria = null, $id_as_key = false, $as_object = true) |
|
| 345 | { |
|
| 346 | $ret = array(); |
|
| 347 | $limit = $start = 0; |
|
| 348 | $sql = 'SELECT * FROM ' . $this->db->prefix('assessment_provas'); |
|
| 349 | if (isset($criteria) && is_subclass_of($criteria, 'criteriaelement')) { |
|
| 350 | $sql .= ' ' . $criteria->renderWhere(); |
|
| 351 | if ($criteria->getSort() != '') { |
|
| 352 | $sql .= ' ORDER BY ' . $criteria->getSort() . ' ' . $criteria->getOrder(); |
|
| 353 | } |
|
| 354 | $limit = $criteria->getLimit(); |
|
| 355 | $start = $criteria->getStart(); |
|
| 356 | } |
|
| 357 | $result = $this->db->query($sql, $limit, $start); |
|
| 358 | if (!$result) { |
|
| 359 | return $ret; |
|
| 360 | } |
|
| 361 | while ($myrow = $this->db->fetchArray($result)) { |
|
| 362 | $assessment_provas = new assessment_provas(); |
|
| 363 | $assessment_provas->assignVars($myrow); |
|
| 364 | if (!$id_as_key) { |
|
| 365 | $ret[] =& $assessment_provas; |
|
| 366 | } else { |
|
| 367 | $ret[$myrow['cod_prova']] = $assessment_provas; |
|
| 368 | } |
|
| 369 | unset($assessment_provas); |
|
| 370 | } |
|
| 371 | ||
| 372 | return $ret; |
|
| 373 | } |
|
| 374 | ||
| 375 | /** |
|
| 376 | * count assessment_provass matching a condition |
|
| @@ 265-294 (lines=30) @@ | ||
| 262 | * @return array array of <a href='psi_element://$assessment_respostas'>$assessment_respostas</a> objects |
|
| 263 | * objects |
|
| 264 | */ |
|
| 265 | public function &getObjects(CriteriaElement $criteria = null, $id_as_key = false, $as_object = true) |
|
| 266 | { |
|
| 267 | $ret = array(); |
|
| 268 | $limit = $start = 0; |
|
| 269 | $sql = 'SELECT * FROM ' . $this->db->prefix('assessment_respostas'); |
|
| 270 | if (isset($criteria) && is_subclass_of($criteria, 'criteriaelement')) { |
|
| 271 | $sql .= ' ' . $criteria->renderWhere(); |
|
| 272 | if ($criteria->getSort() != '') { |
|
| 273 | $sql .= ' ORDER BY ' . $criteria->getSort() . ' ' . $criteria->getOrder(); |
|
| 274 | } |
|
| 275 | $limit = $criteria->getLimit(); |
|
| 276 | $start = $criteria->getStart(); |
|
| 277 | } |
|
| 278 | $result = $this->db->query($sql, $limit, $start); |
|
| 279 | if (!$result) { |
|
| 280 | return $ret; |
|
| 281 | } |
|
| 282 | while ($myrow = $this->db->fetchArray($result)) { |
|
| 283 | $assessment_respostas = new assessment_respostas(); |
|
| 284 | $assessment_respostas->assignVars($myrow); |
|
| 285 | if (!$id_as_key) { |
|
| 286 | $ret[] = $assessment_respostas; |
|
| 287 | } else { |
|
| 288 | $ret[$myrow['cod_resposta']] = $assessment_respostas; |
|
| 289 | } |
|
| 290 | unset($assessment_respostas); |
|
| 291 | } |
|
| 292 | ||
| 293 | return $ret; |
|
| 294 | } |
|
| 295 | ||
| 296 | /** |
|
| 297 | * count assessment_respostass matching a condition |
|
| @@ 390-419 (lines=30) @@ | ||
| 387 | * @return array array of <a href='psi_element://$assessment_resultados'>$assessment_resultados</a> objects |
|
| 388 | * objects |
|
| 389 | */ |
|
| 390 | public function &getObjects(CriteriaElement $criteria = null, $id_as_key = false, $as_object = true) |
|
| 391 | { |
|
| 392 | $ret = array(); |
|
| 393 | $limit = $start = 0; |
|
| 394 | $sql = 'SELECT * FROM ' . $this->db->prefix('assessment_resultados'); |
|
| 395 | if (isset($criteria) && is_subclass_of($criteria, 'criteriaelement')) { |
|
| 396 | $sql .= ' ' . $criteria->renderWhere(); |
|
| 397 | if ($criteria->getSort() != '') { |
|
| 398 | $sql .= ' ORDER BY ' . $criteria->getSort() . ' ' . $criteria->getOrder(); |
|
| 399 | } |
|
| 400 | $limit = $criteria->getLimit(); |
|
| 401 | $start = $criteria->getStart(); |
|
| 402 | } |
|
| 403 | $result = $this->db->query($sql, $limit, $start); |
|
| 404 | if (!$result) { |
|
| 405 | return $ret; |
|
| 406 | } |
|
| 407 | while ($myrow = $this->db->fetchArray($result)) { |
|
| 408 | $assessment_resultados = new assessment_resultados(); |
|
| 409 | $assessment_resultados->assignVars($myrow); |
|
| 410 | if (!$id_as_key) { |
|
| 411 | $ret[] = $assessment_resultados; |
|
| 412 | } else { |
|
| 413 | $ret[$myrow['cod_resultado']] = $assessment_resultados; |
|
| 414 | } |
|
| 415 | unset($assessment_resultados); |
|
| 416 | } |
|
| 417 | ||
| 418 | return $ret; |
|
| 419 | } |
|
| 420 | ||
| 421 | /** |
|
| 422 | * count assessment_resultadoss matching a condition |
|
