1234567891011121314151617181920212223242526272829303132333435363738 |
- <?php
- require_once __DIR__.'/../inc/global.inc.php';
- function getAllCategoriesAndUsers()
- {
- $table = Database::get_main_table(TABLE_MAIN_GRADEBOOK_RESULT);
- $jointable = Database::get_main_table(TABLE_MAIN_GRADEBOOK_EVALUATION);
- $joinStatement = ' JOIN '.$jointable.' ON '.$table.'.evaluation_id = '.$jointable.'.id';
- return Database::select(
- 'DISTINCT '.$jointable.'.category_id,'.$table.'.user_id',
- $table.$joinStatement
- );
- }
- if ($categoriesAndUsers = getAllCategoriesAndUsers()) {
- foreach ($categoriesAndUsers as $categoryAndUser) {
- Category::generateUserCertificate(
- $categoryAndUser['category_id'],
- $categoryAndUser['user_id']
- );
- }
- }
|