$user_id = isset($_SESSION['adminId']) && intval($_SESSION['adminId']) > 0 ? intval($_SESSION['adminId']) : 0; if ($user_id < 1) { header('Location: login.php'); exit; } // http://dev.tracetec.co.za/debt-recovery-view-messages.php?debt_id=1 $debt_id = isset($_REQUEST['debt_id']) ? $_REQUEST['debt_id'] : 0; $message_type = isset($_REQUEST['type']) ? trim(strtolower($_REQUEST['type'])) : 'all'; $messages = array(); if ($debt_id > 0) { switch ($message_type) { case 'sms': $messages = Model_Message_Log::find_all_by_debt_recovery_id_and_module_name($debt_id, array('higate')); break; case 'email': $messages = Model_Message_Log::find_all_by_debt_recovery_id_and_module_name($debt_id, array('phpmailer')); break; default: $messages = Model_Message_Log::find_all_by_debt_recovery_id($debt_id); break; } } else { $recovery_id = isset($_REQUEST['debt_recovery_id']) ? trim(strtolower($_REQUEST['debt_recovery_id'])) : 0; if ($recovery_id > 0) { $ids = Model_Debt_Recovery_Run::find_all_by_debt_recovery_id($recovery_id); switch ($message_type) { case 'sms': $messages = Model_Message_Log::all(array('conditions' => array('debt_recovery_id in (?) and module_name in (?) ', ActiveRecord\collect($ids, 'id'), array('higate')))); break; case 'email': $messages = Model_Message_Log::all(array('conditions' => array('debt_recovery_id in (?) and module_name in (?) ', ActiveRecord\collect($ids, 'id'), array('phpmailer'))));