function getExcelData($uploadfile = '')
{
    global $log;
    $log->log('处理file开始');
    if (is_readable($uploadfile) == false) {
        $log->log('文件不可读');
        return FALSE;
    }
    $data = array();
    Loader::import(PHPEXCEL_ROOT);
    try {
        $objReader = PHPExcel_IOFactory::createReader('Excel5');
        $objReader->setReadDataOnly(TRUE);
        $objPHPExcel = $objReader->load($uploadfile);
        $sheet = $objPHPExcel->getSheet(0);
        $highestRow = $sheet->getHighestRow();
        $highestColumn = $sheet->getHighestColumn();
        $fieldAndTitle = getFieldAndTitle();
        $log->log('处理file结束');
        $fields = array();
        for ($j = 1; $j <= $highestRow; $j++) {
            for ($k = 'A'; $k <= $highestColumn; $k++) {
                $value = $objPHPExcel->getActiveSheet()->getCell("{$k}{$j}")->getValue();
                if ($j == 1) {
                    $field = array_search($value, $fieldAndTitle);
                    if (false !== $field) {
                        $fields[$k] = $field;
                    } else {
                        // ("模板有误,请从新生存模板");
                    }
                } else {
                    $key = $fields[$k];
                    $data[$j][$key] = $value == NUll ? '' : $value;
                    if ($key == 'name') {
                        $data[$j]['firstChater'] = Sp_Dictionary::getFirstCharter($value);
                    }
                }
            }
        }
        $log->log('返回数据成功');
    } catch (Exception $e) {
        $log->log('处理错误: ' . $e->__toString());
    }
    return $data;
}
 public function addAttendee()
 {
     $data = $_POST;
     unset($data['action']);
     $flag = true;
     if (false == $data['name']) {
         $flag = false;
     } else {
         if (false == preg_match(Sp_Dictionary::getOtherOption('patternMobile'), $data['phone'])) {
             $flag = false;
         } else {
             if ($data['email']) {
                 if (false == preg_match(Sp_Dictionary::getOtherOption('patternEmail'), $data['email'])) {
                     $flag = false;
                 }
             }
         }
     }
     if (false == $flag) {
         return array('status' => 0, 'msg' => '数据有误请从新填写');
     } else {
         $data['firstChater'] = Sp_Dictionary::getFirstCharter($data['name']);
         $data['fromId'] = -1;
         $data['applyTime'] = time();
         $return = Sp_Account_Attendee::add($data);
         if ($return == -2) {
             return array('status' => -2, 'msg' => '此人已经存在');
         } else {
             if (-3 == $return) {
                 return array('status' => -3, 'msg' => '此人已经签到');
             } else {
                 if (-4 == $return) {
                     return array('status' => -4, 'msg' => '添加失败');
                 } else {
                     if ($return) {
                         return array('status' => 1, 'msg' => '添加成功');
                     }
                 }
             }
         }
         return array('status' => 0, 'msg' => '数据有误请从新填写');
     }
 }
 public function insert($data)
 {
     $data['applyTime'] = time();
     $data['firstChater'] = Sp_Dictionary::getFirstCharter($data['name']);
     try {
         $id = Sp_Account_Attendee::add($data);
     } catch (PDOException $e) {
         $id = false;
     }
     return $id < 1 ? false : $id;
 }