|
@@ 687-689 (lines=3) @@
|
| 684 |
|
FROM ' . $table_user . ' u |
| 685 |
|
INNER JOIN ' . $table_certificate . ' gc |
| 686 |
|
ON u.user_id=gc.user_id '; |
| 687 |
|
if (!is_null($cat_id) && $cat_id > 0) { |
| 688 |
|
$sql.=' WHERE cat_id=' . intval($cat_id); |
| 689 |
|
} |
| 690 |
|
if (!empty($userList)) { |
| 691 |
|
$userList = array_map('intval', $userList); |
| 692 |
|
$userListCondition = implode("','", $userList); |
|
@@ 718-720 (lines=3) @@
|
| 715 |
|
$sql = 'SELECT gc.score_certificate, gc.created_at, gc.path_certificate, gc.cat_id, gc.user_id, gc.id |
| 716 |
|
FROM ' . $table_certificate . ' gc |
| 717 |
|
WHERE gc.user_id="' . intval($user_id) . '" '; |
| 718 |
|
if (!is_null($cat_id) && $cat_id > 0) { |
| 719 |
|
$sql.=' AND cat_id=' . intval($cat_id); |
| 720 |
|
} |
| 721 |
|
|
| 722 |
|
$rs = Database::query($sql); |
| 723 |
|
$list_certificate = array(); |