public function action_contact_form() {      
      $val = Loader::helper('validation/form');
      $mh = Loader::helper('mail');
 
      // Validate
                $val->setData($this->post());
                $val->addRequiredEmail('email', 'Please Enter a Valid Email Address.');
 
      // You get form data like this
      $fullName = $this->post('full_name');
      $company = $this->post('company');   
      $email = $this->post('email');      
 
 
      // If no errors
      if ($val->test()) {
       // Send Email
                $mh->setSubject('Website Contact Form');
            $mh->setBody("Web Site Contact Form\n".
               "\nName:    ".$fullName.
               "\nEmail:   ".$email.
               "\nCompany: ".$company.            
 
            $mh->to('email@address.com', 'Name');
            $mh->from($email);
            $mh->sendMail();            
            $this->set('response', t('Thanks for Contacting Us.'));
       return true;
     }
 
 
 

 
<?php 
 
defined('C5_EXECUTE') or die("Access Denied.");
Loader::block('community_form');
 
class DashboardReportsFormsController extends Controller {
 
   private $pageSize=3; 
 
   public function view(){   
      if($_REQUEST['all']){
         $this->pageSize=100000; 
         $_REQUEST['page']=1;
      }
      $this->loadSurveyResponses();
   }
 
   public function excel(){ 
      $dateHelper = Loader::helper('date');
 
      $this->pageSize=0;
      $this->loadSurveyResponses();
      $textHelper = Loader::helper('text');
 
      $questionSet=$this->get('questionSet');
      $answerSets=$this->get('answerSets');
      $questions=$this->get('questions');   
      $surveys=$this->get('surveys');    
 
      $fileName=$textHelper->filterNonAlphaNum($surveys[$questionSet]['surveyName']);
 
      header("Content-Type: application/vnd.ms-excel");
      header("Cache-control: private");
      header("Pragma: public");
      $date = date('Ymd');
      header("Content-Disposition: inline; filename=".$fileName."_form_data_{$date}.xls"); 
      header("Content-Title: ".$surveys[$questionSet]['surveyName']." Form Data Output - Run on {$date}");      
      echo "<table>\r\n";
      $hasCBRow = false;
      foreach($questions as $questionId=>$question){ 
            if ($question['inputType'] == 'checkboxlist') {
            $hasCBRow = true;
         }
      }
 
      echo "<tr>";
      echo "\t\t<td ";
      if ($hasCBRow) {
         echo "rowspan=\"2\" valign='bottom'";
      }
      echo "><b>Submitted Date</b></td>\r\n";
 
      foreach($questions as $questionId=>$question){ 
            if ($question['inputType'] == 'checkboxlist')
            {
                $options = explode('%%', $question['options']);
             echo "\t\t".'<td colspan="'.count($options).'"><b>'."\r\n";
            }
            else
            {
             echo "\t\t<td ";
             if ($hasCBRow) {
                echo "rowspan=\"2\" valign='bottom'>";
             }
             echo "<b>\r\n";
            }
         echo "\t\t\t".$questions[$questionId]['question']."\r\n";
         echo "\t\t</b></td>\r\n";         
      }   
      echo "</tr>";
 
      // checkbox row
      if ($hasCBRow) {
         echo "<tr>";
         foreach($questions as $questionId=>$question){ 
            if ($question['inputType'] == 'checkboxlist')
            {
               $options = explode('%%', $question['options']);
               foreach($options as $opt) {
                  echo "<td><b>{$opt}</b></td>";
               }
            }
         }
         echo "</tr>";
      }
 
      foreach($answerSets as $answerSetId=>$answerSet){ 
         $questionNumber=0;
         $numQuestionsToShow=2;
         echo "\t<tr>\r\n";
         echo "\t\t<td>". $dateHelper->getSystemDateTime($answerSet['created'])."</td>\r\n";
         foreach($questions as $questionId=>$question){ 
            $questionNumber++;
                if ($question['inputType'] == 'checkboxlist'){
                    $options = explode('%%', $question['options']);
                    $subanswers = explode(',', $answerSet['answers'][$questionId]['answer']);
                    for ($i = 1; $i <= count($options); $i++)
                    {
                    echo "\t\t<td align='center'>\r\n";
                        if (in_array(trim($options[$i-1]), $subanswers)) {
                       // echo "\t\t\t".$options[$i-1]."\r\n";
                       echo "x";
                    } else {
                        echo "\t\t\t&nbsp;\r\n";
                    }
                    echo "\t\t</td>\r\n";
                    }
 
                }elseif($question['inputType']=='fileupload'){ 
               echo "\t\t<td>\r\n";
               $fID=intval($answerSet['answers'][$questionId]['answer']);
               $file=File::getByID($fID);
               if($fID && $file){
                  $fileVersion=$file->getApprovedVersion();
                  echo "\t\t\t".'<a href="'. BASE_URL . DIR_REL . $fileVersion->getRelativePath() .'">'.$fileVersion->getFileName().'</a>'."\r\n";
               }else{
                  echo "\t\t\t".t('File not found')."\r\n";
               }    
               echo "\t\t</td>\r\n";      
            }else{               
                echo "\t\t<td>\r\n";
                echo "\t\t\t".$answerSet['answers'][$questionId]['answer'].$answerSet['answers'][$questionId]['answerLong']."\r\n";               
                echo "\t\t</td>\r\n";
                }
         }
         echo "\t</tr>\r\n";
      }
      echo "</table>\r\n";      
      die;
   }   
 
   private function loadSurveyResponses(){
      $c=$this->getCollectionObject();
      $db = Loader::db();
      $tempMiniSurvey = new CF_MiniSurvey();
      $pageBase=DIR_REL.'/' . DISPATCHER_FILENAME . '?cID='.$c->getCollectionID();   
 
      if( $_REQUEST['action'] == 'deleteForm' ){
         $this->deleteForm($_REQUEST['bID'], $_REQUEST['qsID']);
      }   
 
      if( $_REQUEST['action'] == 'deleteResponse' ){
         $this->deleteAnswers($_REQUEST['asid']);
      }      
 
      print_r($tempMiniSurvey);
      //load surveys
      $surveysRS= CF_FormBlockStatistics::loadSurveys($tempMiniSurvey);
 
      //index surveys by question set id
      $surveys=array();
      while($survey=$surveysRS->fetchRow()){
         //get Survey Answers
         $survey['answerSetCount'] = CF_MiniSurvey::getAnswerCount( $survey['questionSetId'] );
         $surveys[ $survey['questionSetId'] ] = $survey;         
      }      
 
 
      //load requested survey response
      if( strlen($_REQUEST['qsid'])>0 ){
         $questionSet=preg_replace('/[^[:alnum:]]/','',$_REQUEST['qsid']);
 
         //get Survey Questions
         $questionsRS=CF_MiniSurvey::loadQuestions($questionSet);
         $questions=array();
         while( $question = $questionsRS->fetchRow() ){
            $questions[$question['msqID']]=$question;
         }
 
         //get Survey Answers
         $answerSetCount = CF_MiniSurvey::getAnswerCount($questionSet);
 
         //pagination 
         $pageBaseSurvey=$pageBase.'&qsid='.$questionSet;
         $paginator=Loader::helper('pagination');
         $sortBy=$_REQUEST['sortBy'];
         $paginator->init( intval($_REQUEST['page']) ,$answerSetCount,$pageBaseSurvey.'&page=%pageNum%&sortBy='.$sortBy,$this->pageSize);
 
         if($this->pageSize>0)
            $limit=$paginator->getLIMIT();
         else $limit='';
         $answerSets = CF_FormBlockStatistics::buildAnswerSetsArray( $questionSet, $sortBy, $limit ); 
      }
      $this->set('questions',$questions);      
      $this->set('answerSets',$answerSets);
      $this->set('paginator',$paginator);   
      $this->set('questionSet',$questionSet);
      $this->set('surveys',$surveys);           
   }
   // SET UP DELETE FUNCTIONS HERE
   // DELETE SUBMISSIONS
   private function deleteAnswers($asID){
      $db = Loader::db();
      $v = array(intval($asID));
      $q = 'DELETE FROM btFormAnswers WHERE asID = ?';      
      $r = $db->query($q, $v);
 
      $q = 'DELETE FROM btFormAnswerSet WHERE asID = ?';      
      $r = $db->query($q, $v);
   }
   //DELETE FORMS AND ALL SUBMISSIONS
   private function deleteForm($bID, $qsID){
      $db = Loader::db();
      $v = array(intval($qsID));
      $q = 'SELECT asID FROM btFormAnswerSet WHERE questionSetId = ?';
 
      $r = $db->query($q, $v);
      while ($row = $r->fetchRow()) {
         $asID = $row['asID'];
         $this->deleteAnswers($asID);
      }
 
      $v = array(intval($bID));
      $q = 'DELETE FROM btFormQuestions WHERE bID = ?';      
      $r = $db->query($q, $v);
 
      $q = 'DELETE FROM btForm WHERE bID = ?';      
      $r = $db->query($q, $v);
 
      $q = 'DELETE FROM Blocks WHERE bID = ?';      
      $r = $db->query($q, $v);
 
   }   
}
 
?>