| | |
| | | FROM ${database}.crs_items ci |
| | | INNER JOIN ${database}.object_reference or2 ON or2.ref_id = ci.obj_id |
| | | INNER JOIN ${database}.object_data od ON od.obj_id = or2.obj_id |
| | | WHERE ci.obj_id = 3503 -- Kurs ref_id |
| | | WHERE ci.obj_id = ${ref_id} -- Kurs ref_id |
| | | AND or2.deleted is NULL |
| | | |
| | | UNION ALL |
| | |
| | | <td>{{ tn.title }}</td> |
| | | <td>{{ tn.passed }}</td> |
| | | <td>{{ tn.status }}</td> |
| | | <td>{{ dayjs(tn.status_changed).format("DD.MM.YYYY HH:mm:ss") }}</td> |
| | | <td class="nowrap"> |
| | | <div v-if="tn.status_changed"> |
| | | {{ dayjs(tn.status_changed).format("DD.MM.YYYY HH:mm:ss") }} |
| | | </div> |
| | | </td> |
| | | </tr> |
| | | </tbody> |
| | | </table> |