chamilo /
chamilo-lms
| @@ 2726-2733 (lines=8) @@ | ||
| 2723 | * @param int $courseId |
|
| 2724 | * @return array |
|
| 2725 | */ |
|
| 2726 | function getDocumentToWork($documentId, $workId, $courseId) |
|
| 2727 | { |
|
| 2728 | $table = Database::get_course_table(TABLE_STUDENT_PUBLICATION_REL_DOCUMENT); |
|
| 2729 | $params = array( |
|
| 2730 | 'document_id = ? and work_id = ? and c_id = ?' => array($documentId, $workId, $courseId) |
|
| 2731 | ); |
|
| 2732 | return Database::select('*', $table, array('where' => $params)); |
|
| 2733 | } |
|
| 2734 | ||
| 2735 | /** |
|
| 2736 | * @param int $documentId |
|
| @@ 2781-2788 (lines=8) @@ | ||
| 2778 | * @param int $courseId |
|
| 2779 | * @return array |
|
| 2780 | */ |
|
| 2781 | function getAllDocumentToWork($workId, $courseId) |
|
| 2782 | { |
|
| 2783 | $table = Database::get_course_table(TABLE_STUDENT_PUBLICATION_REL_DOCUMENT); |
|
| 2784 | $params = array( |
|
| 2785 | 'work_id = ? and c_id = ?' => array($workId, $courseId) |
|
| 2786 | ); |
|
| 2787 | return Database::select('*', $table, array('where' => $params)); |
|
| 2788 | } |
|
| 2789 | ||
| 2790 | /** |
|
| 2791 | * @param int $documentId |
|
| @@ 2795-2802 (lines=8) @@ | ||
| 2792 | * @param int $workId |
|
| 2793 | * @param int $courseId |
|
| 2794 | */ |
|
| 2795 | function deleteDocumentToWork($documentId, $workId, $courseId) |
|
| 2796 | { |
|
| 2797 | $table = Database::get_course_table(TABLE_STUDENT_PUBLICATION_REL_DOCUMENT); |
|
| 2798 | $params = array( |
|
| 2799 | 'document_id = ? and work_id = ? and c_id = ?' => array($documentId, $workId, $courseId) |
|
| 2800 | ); |
|
| 2801 | Database::delete($table, $params); |
|
| 2802 | } |
|
| 2803 | ||
| 2804 | /** |
|
| 2805 | * @param int $userId |
|
| @@ 2826-2833 (lines=8) @@ | ||
| 2823 | * @param int $courseId |
|
| 2824 | * @return array |
|
| 2825 | */ |
|
| 2826 | function getUserToWork($userId, $workId, $courseId) |
|
| 2827 | { |
|
| 2828 | $table = Database::get_course_table(TABLE_STUDENT_PUBLICATION_REL_USER); |
|
| 2829 | $params = array( |
|
| 2830 | 'user_id = ? and work_id = ? and c_id = ?' => array($userId, $workId, $courseId) |
|
| 2831 | ); |
|
| 2832 | return Database::select('*', $table, array('where' => $params)); |
|
| 2833 | } |
|
| 2834 | ||
| 2835 | /** |
|
| 2836 | * @param int $workId |
|
| @@ 2869-2876 (lines=8) @@ | ||
| 2866 | * @param int $workId |
|
| 2867 | * @param int $courseId |
|
| 2868 | */ |
|
| 2869 | function deleteUserToWork($userId, $workId, $courseId) |
|
| 2870 | { |
|
| 2871 | $table = Database::get_course_table(TABLE_STUDENT_PUBLICATION_REL_USER); |
|
| 2872 | $params = array( |
|
| 2873 | 'user_id = ? and work_id = ? and c_id = ?' => array($userId, $workId, $courseId) |
|
| 2874 | ); |
|
| 2875 | Database::delete($table, $params); |
|
| 2876 | } |
|
| 2877 | ||
| 2878 | /** |
|
| 2879 | * @param int $userId |
|
