chamilo /
chamilo-lms
| @@ 2702-2709 (lines=8) @@ | ||
| 2699 | * @param int $courseId |
|
| 2700 | * @return array |
|
| 2701 | */ |
|
| 2702 | function getDocumentToWork($documentId, $workId, $courseId) |
|
| 2703 | { |
|
| 2704 | $table = Database::get_course_table(TABLE_STUDENT_PUBLICATION_REL_DOCUMENT); |
|
| 2705 | $params = array( |
|
| 2706 | 'document_id = ? and work_id = ? and c_id = ?' => array($documentId, $workId, $courseId) |
|
| 2707 | ); |
|
| 2708 | return Database::select('*', $table, array('where' => $params)); |
|
| 2709 | } |
|
| 2710 | ||
| 2711 | /** |
|
| 2712 | * @param int $documentId |
|
| @@ 2756-2763 (lines=8) @@ | ||
| 2753 | * @param int $courseId |
|
| 2754 | * @return array |
|
| 2755 | */ |
|
| 2756 | function getAllDocumentToWork($workId, $courseId) |
|
| 2757 | { |
|
| 2758 | $table = Database::get_course_table(TABLE_STUDENT_PUBLICATION_REL_DOCUMENT); |
|
| 2759 | $params = array( |
|
| 2760 | 'work_id = ? and c_id = ?' => array($workId, $courseId) |
|
| 2761 | ); |
|
| 2762 | return Database::select('*', $table, array('where' => $params)); |
|
| 2763 | } |
|
| 2764 | ||
| 2765 | /** |
|
| 2766 | * @param int $documentId |
|
| @@ 2770-2777 (lines=8) @@ | ||
| 2767 | * @param int $workId |
|
| 2768 | * @param int $courseId |
|
| 2769 | */ |
|
| 2770 | function deleteDocumentToWork($documentId, $workId, $courseId) |
|
| 2771 | { |
|
| 2772 | $table = Database::get_course_table(TABLE_STUDENT_PUBLICATION_REL_DOCUMENT); |
|
| 2773 | $params = array( |
|
| 2774 | 'document_id = ? and work_id = ? and c_id = ?' => array($documentId, $workId, $courseId) |
|
| 2775 | ); |
|
| 2776 | Database::delete($table, $params); |
|
| 2777 | } |
|
| 2778 | ||
| 2779 | /** |
|
| 2780 | * @param int $userId |
|
| @@ 2801-2808 (lines=8) @@ | ||
| 2798 | * @param int $courseId |
|
| 2799 | * @return array |
|
| 2800 | */ |
|
| 2801 | function getUserToWork($userId, $workId, $courseId) |
|
| 2802 | { |
|
| 2803 | $table = Database::get_course_table(TABLE_STUDENT_PUBLICATION_REL_USER); |
|
| 2804 | $params = array( |
|
| 2805 | 'user_id = ? and work_id = ? and c_id = ?' => array($userId, $workId, $courseId) |
|
| 2806 | ); |
|
| 2807 | return Database::select('*', $table, array('where' => $params)); |
|
| 2808 | } |
|
| 2809 | ||
| 2810 | /** |
|
| 2811 | * @param int $workId |
|
| @@ 2844-2851 (lines=8) @@ | ||
| 2841 | * @param int $workId |
|
| 2842 | * @param int $courseId |
|
| 2843 | */ |
|
| 2844 | function deleteUserToWork($userId, $workId, $courseId) |
|
| 2845 | { |
|
| 2846 | $table = Database::get_course_table(TABLE_STUDENT_PUBLICATION_REL_USER); |
|
| 2847 | $params = array( |
|
| 2848 | 'user_id = ? and work_id = ? and c_id = ?' => array($userId, $workId, $courseId) |
|
| 2849 | ); |
|
| 2850 | Database::delete($table, $params); |
|
| 2851 | } |
|
| 2852 | ||
| 2853 | /** |
|
| 2854 | * @param int $userId |
|
