if ($attach) {
$DB = MySql::getInstance();
for ($i = 0; $i < count($attach['name']); $i++) {
if ($attach['error'][$i] != 4) {
$file_info = uploadFile($attach['name'][$i], $attach['error'][$i], $attach['tmp_name'][$i], $attach['size'][$i], Option::getAttType(), false, $isthumbnail);
// 写入附件信息
$query = "INSERT INTO " . DB_PREFIX . "attachment (blogid, filename, filesize, filepath, addtime, width, height, mimetype, thumfor) VALUES ('%s','%s','%s','%s','%s','%s','%s','%s', 0)";
$query = sprintf($query, -1, $file_info['file_name'], $file_info['size'], $file_info['file_path'], time(), $file_info['width'], $file_info['height'], $file_info['mime_type']);
$DB->query($query);
$aid = $DB->insert_id();
$org_photo_atts[] = $file_info['file_path'];
}
}
}
$userData['photos'] = serialize($org_photo_atts);
$Viporg_model->addUser($userData);
$mail = new PHPMailer();
$mail->isSMTP();
$mail->SMTPDebug = 0;
$mail->Debugoutput = 'html';
$mail->CharSet = "UTF-8";
$mail->Host = SMTP_HOST;
$mail->Port = SMTP_POST;
$mail->SMTPAuth = true;
$mail->Username = SMTP_USER_NAME;
$mail->Password = SMTP_PASSWORD;
$mail->setFrom(SMTP_USER_NAME);
$mail->addAddress(EMAIL_VIP_VIPORG);
$mail->Subject = '新单位申请提醒 单位名：' . $name;
$mail->Body = '请去后台管理页面查看并审核';
$mail->send();
// $objReader = new PHPExcel_Reader_OOCalc();
// $objReader = new PHPExcel_Reader_SYLK();
// $objReader = new PHPExcel_Reader_Gnumeric();
// $objReader = new PHPExcel_Reader_CSV();
$objPHPExcel = $objReader->load($inputFileName);
$sheetData = $objPHPExcel->getActiveSheet()->toArray(null, true, true, true);
foreach ($sheetData as $key => $value) {
if ($key == 1) {
continue;
}
$name = trim($value['B']);
if (empty($name)) {
continue;
}
$vipdata = array('vipid' => addslashes($value['A']), 'name' => addslashes($value['B']), 'tname' => addslashes($value['C']), 'create_time' => addslashes($value['D']), 'province' => addslashes($value['E']), 'duty' => addslashes($value['F']), 'manager' => addslashes($value['G']), 'contact' => addslashes($value['H']), 'awards' => addslashes($value['I']), 'des' => addslashes($value['J']));
$Viporg_model->addUser($vipdata);
}
emDirect('./viporg.php?upload_ok=1');
}
if ($action == 'new') {
$login = isset($_POST['login']) ? addslashes(trim($_POST['login'])) : '';
$password = isset($_POST['password']) ? addslashes(trim($_POST['password'])) : '';
$password2 = isset($_POST['password2']) ? addslashes(trim($_POST['password2'])) : '';
$role = isset($_POST['role']) ? addslashes(trim($_POST['role'])) : ROLE_WRITER;
$ischeck = isset($_POST['ischeck']) ? addslashes(trim($_POST['ischeck'])) : 'n';
if ($role == ROLE_ADMIN) {
$ischeck = 'n';
}
if ($login == '') {
emDirect('./user.php?error_login=1');
}
