chamilo /
chamilo-lms
| @@ 2614-2621 (lines=8) @@ | ||
| 2611 | * @param int $courseId |
|
| 2612 | * @return array |
|
| 2613 | */ |
|
| 2614 | function getDocumentToWork($documentId, $workId, $courseId) |
|
| 2615 | { |
|
| 2616 | $table = Database::get_course_table(TABLE_STUDENT_PUBLICATION_REL_DOCUMENT); |
|
| 2617 | $params = array( |
|
| 2618 | 'document_id = ? and work_id = ? and c_id = ?' => array($documentId, $workId, $courseId) |
|
| 2619 | ); |
|
| 2620 | return Database::select('*', $table, array('where' => $params)); |
|
| 2621 | } |
|
| 2622 | ||
| 2623 | /** |
|
| 2624 | * @param int $documentId |
|
| @@ 2668-2675 (lines=8) @@ | ||
| 2665 | * @param int $courseId |
|
| 2666 | * @return array |
|
| 2667 | */ |
|
| 2668 | function getAllDocumentToWork($workId, $courseId) |
|
| 2669 | { |
|
| 2670 | $table = Database::get_course_table(TABLE_STUDENT_PUBLICATION_REL_DOCUMENT); |
|
| 2671 | $params = array( |
|
| 2672 | 'work_id = ? and c_id = ?' => array($workId, $courseId) |
|
| 2673 | ); |
|
| 2674 | return Database::select('*', $table, array('where' => $params)); |
|
| 2675 | } |
|
| 2676 | ||
| 2677 | /** |
|
| 2678 | * @param int $documentId |
|
| @@ 2682-2689 (lines=8) @@ | ||
| 2679 | * @param int $workId |
|
| 2680 | * @param int $courseId |
|
| 2681 | */ |
|
| 2682 | function deleteDocumentToWork($documentId, $workId, $courseId) |
|
| 2683 | { |
|
| 2684 | $table = Database::get_course_table(TABLE_STUDENT_PUBLICATION_REL_DOCUMENT); |
|
| 2685 | $params = array( |
|
| 2686 | 'document_id = ? and work_id = ? and c_id = ?' => array($documentId, $workId, $courseId) |
|
| 2687 | ); |
|
| 2688 | Database::delete($table, $params); |
|
| 2689 | } |
|
| 2690 | ||
| 2691 | /** |
|
| 2692 | * @param int $userId |
|
| @@ 2713-2720 (lines=8) @@ | ||
| 2710 | * @param int $courseId |
|
| 2711 | * @return array |
|
| 2712 | */ |
|
| 2713 | function getUserToWork($userId, $workId, $courseId) |
|
| 2714 | { |
|
| 2715 | $table = Database::get_course_table(TABLE_STUDENT_PUBLICATION_REL_USER); |
|
| 2716 | $params = array( |
|
| 2717 | 'user_id = ? and work_id = ? and c_id = ?' => array($userId, $workId, $courseId) |
|
| 2718 | ); |
|
| 2719 | return Database::select('*', $table, array('where' => $params)); |
|
| 2720 | } |
|
| 2721 | ||
| 2722 | /** |
|
| 2723 | * @param int $workId |
|
| @@ 2756-2763 (lines=8) @@ | ||
| 2753 | * @param int $workId |
|
| 2754 | * @param int $courseId |
|
| 2755 | */ |
|
| 2756 | function deleteUserToWork($userId, $workId, $courseId) |
|
| 2757 | { |
|
| 2758 | $table = Database::get_course_table(TABLE_STUDENT_PUBLICATION_REL_USER); |
|
| 2759 | $params = array( |
|
| 2760 | 'user_id = ? and work_id = ? and c_id = ?' => array($userId, $workId, $courseId) |
|
| 2761 | ); |
|
| 2762 | Database::delete($table, $params); |
|
| 2763 | } |
|
| 2764 | ||
| 2765 | /** |
|
| 2766 | * @param int $userId |
|
