function questionaire($id) { if (!is_login()) { $answer = new Answer(); $answer->where('session', $this->session->userdata('session_id')); $answer->where_related('questionaire/topic', 'id', $id)->get(); if ($answer->exists()) { set_notify('error', 'ท่านได้ทำการตอบแบบสอบถามนี้แล้วค่ะ'); redirect($_SERVER['HTTP_REFERER']); exit; } } $data['topic'] = new Topic($id); if ($data['topic']->status == 0) { set_notify('success', 'ท่านไม่สามารถเข้าใช้งานในส่วนนี้ค่ะ'); redirect('docs/publics'); } $this->template->build('questionaire', $data); }
function delete($id) { $topic = new Topic($id); $question = new Questionaire(); $answer = new Answer(); $answer->where_related('questionaire', 'topic_id', $id)->get()->delete_all(); $choice = new Choice(); $choice->where_related('questionaire', 'topic_id', $id)->get()->delete_all(); $question->where('topic_id', $id)->get()->delete_all(); $topic->delete(); set_notify('success', 'ลบข้อมูลเรียบร้อยแล้วค่ะ'); redirect($_SERVER['HTTP_REFERER']); }