chamilo /
chamilo-lms
| @@ 2570-2577 (lines=8) @@ | ||
| 2567 | * @param int $courseId |
|
| 2568 | * @return array |
|
| 2569 | */ |
|
| 2570 | function getDocumentToWork($documentId, $workId, $courseId) |
|
| 2571 | { |
|
| 2572 | $table = Database::get_course_table(TABLE_STUDENT_PUBLICATION_REL_DOCUMENT); |
|
| 2573 | $params = array( |
|
| 2574 | 'document_id = ? and work_id = ? and c_id = ?' => array($documentId, $workId, $courseId) |
|
| 2575 | ); |
|
| 2576 | return Database::select('*', $table, array('where' => $params)); |
|
| 2577 | } |
|
| 2578 | ||
| 2579 | /** |
|
| 2580 | * @param int $documentId |
|
| @@ 2625-2632 (lines=8) @@ | ||
| 2622 | * @param int $courseId |
|
| 2623 | * @return array |
|
| 2624 | */ |
|
| 2625 | function getAllDocumentToWork($workId, $courseId) |
|
| 2626 | { |
|
| 2627 | $table = Database::get_course_table(TABLE_STUDENT_PUBLICATION_REL_DOCUMENT); |
|
| 2628 | $params = array( |
|
| 2629 | 'work_id = ? and c_id = ?' => array($workId, $courseId) |
|
| 2630 | ); |
|
| 2631 | return Database::select('*', $table, array('where' => $params)); |
|
| 2632 | } |
|
| 2633 | ||
| 2634 | /** |
|
| 2635 | * @param int $documentId |
|
| @@ 2639-2646 (lines=8) @@ | ||
| 2636 | * @param int $workId |
|
| 2637 | * @param int $courseId |
|
| 2638 | */ |
|
| 2639 | function deleteDocumentToWork($documentId, $workId, $courseId) |
|
| 2640 | { |
|
| 2641 | $table = Database::get_course_table(TABLE_STUDENT_PUBLICATION_REL_DOCUMENT); |
|
| 2642 | $params = array( |
|
| 2643 | 'document_id = ? and work_id = ? and c_id = ?' => array($documentId, $workId, $courseId) |
|
| 2644 | ); |
|
| 2645 | Database::delete($table, $params); |
|
| 2646 | } |
|
| 2647 | ||
| 2648 | /** |
|
| 2649 | * @param int $userId |
|
| @@ 2670-2677 (lines=8) @@ | ||
| 2667 | * @param int $courseId |
|
| 2668 | * @return array |
|
| 2669 | */ |
|
| 2670 | function getUserToWork($userId, $workId, $courseId) |
|
| 2671 | { |
|
| 2672 | $table = Database::get_course_table(TABLE_STUDENT_PUBLICATION_REL_USER); |
|
| 2673 | $params = array( |
|
| 2674 | 'user_id = ? and work_id = ? and c_id = ?' => array($userId, $workId, $courseId) |
|
| 2675 | ); |
|
| 2676 | return Database::select('*', $table, array('where' => $params)); |
|
| 2677 | } |
|
| 2678 | ||
| 2679 | /** |
|
| 2680 | * @param int $workId |
|
| @@ 2713-2720 (lines=8) @@ | ||
| 2710 | * @param int $workId |
|
| 2711 | * @param int $courseId |
|
| 2712 | */ |
|
| 2713 | function deleteUserToWork($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 | Database::delete($table, $params); |
|
| 2720 | } |
|
| 2721 | ||
| 2722 | /** |
|
| 2723 | * @param int $userId |
|
