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; }