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')))); break; default: $messages = Model_Message_Log::all(array('order' => 'created_at desc', 'limit' => 100, 'offset' => 0, 'conditions' => array('debt_recovery_id in (?) ', ActiveRecord\collect($ids, 'id'))));