chamilo /
chamilo-lms
| @@ 2558-2565 (lines=8) @@ | ||
| 2555 | * @param int $courseId |
|
| 2556 | * @return array |
|
| 2557 | */ |
|
| 2558 | function getDocumentToWork($documentId, $workId, $courseId) |
|
| 2559 | { |
|
| 2560 | $table = Database::get_course_table(TABLE_STUDENT_PUBLICATION_REL_DOCUMENT); |
|
| 2561 | $params = array( |
|
| 2562 | 'document_id = ? and work_id = ? and c_id = ?' => array($documentId, $workId, $courseId) |
|
| 2563 | ); |
|
| 2564 | return Database::select('*', $table, array('where' => $params)); |
|
| 2565 | } |
|
| 2566 | ||
| 2567 | /** |
|
| 2568 | * @param int $documentId |
|
| @@ 2613-2620 (lines=8) @@ | ||
| 2610 | * @param int $courseId |
|
| 2611 | * @return array |
|
| 2612 | */ |
|
| 2613 | function getAllDocumentToWork($workId, $courseId) |
|
| 2614 | { |
|
| 2615 | $table = Database::get_course_table(TABLE_STUDENT_PUBLICATION_REL_DOCUMENT); |
|
| 2616 | $params = array( |
|
| 2617 | 'work_id = ? and c_id = ?' => array($workId, $courseId) |
|
| 2618 | ); |
|
| 2619 | return Database::select('*', $table, array('where' => $params)); |
|
| 2620 | } |
|
| 2621 | ||
| 2622 | /** |
|
| 2623 | * @param int $documentId |
|
| @@ 2627-2634 (lines=8) @@ | ||
| 2624 | * @param int $workId |
|
| 2625 | * @param int $courseId |
|
| 2626 | */ |
|
| 2627 | function deleteDocumentToWork($documentId, $workId, $courseId) |
|
| 2628 | { |
|
| 2629 | $table = Database::get_course_table(TABLE_STUDENT_PUBLICATION_REL_DOCUMENT); |
|
| 2630 | $params = array( |
|
| 2631 | 'document_id = ? and work_id = ? and c_id = ?' => array($documentId, $workId, $courseId) |
|
| 2632 | ); |
|
| 2633 | Database::delete($table, $params); |
|
| 2634 | } |
|
| 2635 | ||
| 2636 | /** |
|
| 2637 | * @param int $userId |
|
| @@ 2658-2665 (lines=8) @@ | ||
| 2655 | * @param int $courseId |
|
| 2656 | * @return array |
|
| 2657 | */ |
|
| 2658 | function getUserToWork($userId, $workId, $courseId) |
|
| 2659 | { |
|
| 2660 | $table = Database::get_course_table(TABLE_STUDENT_PUBLICATION_REL_USER); |
|
| 2661 | $params = array( |
|
| 2662 | 'user_id = ? and work_id = ? and c_id = ?' => array($userId, $workId, $courseId) |
|
| 2663 | ); |
|
| 2664 | return Database::select('*', $table, array('where' => $params)); |
|
| 2665 | } |
|
| 2666 | ||
| 2667 | /** |
|
| 2668 | * @param int $workId |
|
| @@ 2701-2708 (lines=8) @@ | ||
| 2698 | * @param int $workId |
|
| 2699 | * @param int $courseId |
|
| 2700 | */ |
|
| 2701 | function deleteUserToWork($userId, $workId, $courseId) |
|
| 2702 | { |
|
| 2703 | $table = Database::get_course_table(TABLE_STUDENT_PUBLICATION_REL_USER); |
|
| 2704 | $params = array( |
|
| 2705 | 'user_id = ? and work_id = ? and c_id = ?' => array($userId, $workId, $courseId) |
|
| 2706 | ); |
|
| 2707 | Database::delete($table, $params); |
|
| 2708 | } |
|
| 2709 | ||
| 2710 | /** |
|
| 2711 | * @param int $userId |
|
