public function actionImport()
{
//$this->redirect('/buyer/index');
$model = new Buyer();
if (Yii::$app->request->isPost) {
$model->file = UploadedFile::getInstance($model, 'file');
if ($model->file->extension == 'xls') {
$model->file->saveAs('uploads/up.xls');
//require('/vendor/excel_reader2.php');
require_once '../vendor/excel_reader2.php';
$data = new Spreadsheet_Excel_Reader();
//设置文本输出编码
$data->setOutputEncoding('UTF-8');
$data->read('uploads/up.xls');
//读取excel
$arr1 = array();
$arr2 = array();
$arr3 = array();
$arr4 = array();
$arr5 = array();
$arr6 = array();
$arr7 = array();
$arr8 = array();
for ($i = 2; $i <= $data->sheets[0]['numRows']; $i++) {
//显示每个单元格内容
$arr1[$data->sheets[0]['cells'][$i][1]] = $data->sheets[0]['cells'][$i][1];
$arr2[$data->sheets[0]['cells'][$i][1]] = $data->sheets[0]['cells'][$i][2];
$arr3[$data->sheets[0]['cells'][$i][1]] = $data->sheets[0]['cells'][$i][3];
$arr4[$data->sheets[0]['cells'][$i][1]] = $data->sheets[0]['cells'][$i][4];
$arr5[$data->sheets[0]['cells'][$i][1]] = $data->sheets[0]['cells'][$i][5];
$arr6[$data->sheets[0]['cells'][$i][1]] = empty($data->sheets[0]['cells'][$i][6]) ? '' : $data->sheets[0]['cells'][$i][6];
$arr7[$data->sheets[0]['cells'][$i][1]] = $data->sheets[0]['cells'][$i][7];
$arr8[$data->sheets[0]['cells'][$i][1]] = $data->sheets[0]['cells'][$i][8];
$buyer = new Buyer();
$buyer->platform = $arr1[$data->sheets[0]['cells'][$i][1]];
$buyer->account = $arr2[$data->sheets[0]['cells'][$i][1]];
$buyer->pass = $arr3[$data->sheets[0]['cells'][$i][1]];
$buyer->pay_account = $arr4[$data->sheets[0]['cells'][$i][1]];
$buyer->pay_pass = $arr5[$data->sheets[0]['cells'][$i][1]];
$buyer->regarea = $arr6[$data->sheets[0]['cells'][$i][1]];
$buyer->regphone = $arr7[$data->sheets[0]['cells'][$i][1]];
$buyer->remark = $arr8[$data->sheets[0]['cells'][$i][1]];
$buyer->create_time = date('Y-m-d H:i:s');
$exists = Buyer::find()->where('account = :account', [':account' => $buyer->account])->one();
if (is_null($exists)) {
$buyer->save();
}
}
$i = $i - 2;
echo "\t<meta charset='utf-8'>";
echo "<script>alert('成功导入" . $i . "个小号')</script>";
//echo "<script>history.go(-1);</script>";
} else {
echo "\t<meta charset='utf-8'>";
echo "<script>alert('上传失败')</script>";
echo "<script>history.go(-1);</script>";
}
return;
}
return $this->renderAjax('import', ['model' => $model]);
}
private function registerUser($data, $role)
{
if (isset($data['phone_number'])) {
$data['phone_number'] = str_replace(' ', '', $data['phone_number']);
}
if (isset($data['work_phone'])) {
$data['work_phone'] = str_replace(' ', '', $data['work_phone']);
}
$u = new User();
$data['role_id'] = $role;
switch (strtolower($role)) {
case Config::get('constants.ROLE_SELLER'):
$a = new Seller();
break;
case Config::get('constants.ROLE_BROKER'):
$a = new Broker();
break;
default:
$a = new Buyer();
$u->status = 2;
$data['skip_verification'] = true;
break;
}
if (!isset($data['password']) || $data['password'] == "") {
$pwd = Str::random(10);
$data['password'] = $data['password_confirmation'] = $pwd;
}
if ($u->validate($data)) {
if ($a->validate($data)) {
if (isset($pwd)) {
Session::set('validate_password', true);
}
$data['password'] = Hash::make($data['password']);
$u->fill($data);
$code = Str::random(10);
$u->verification_code = $code;
$data['verification_code'] = $code;
$u->save();
$data['user_id'] = $u->id;
$a->fill($data);
$a->save();
$email = $u->email;
if (isset($data['skip_verification'])) {
$data['url']['link'] = url('/');
$data['url']['name'] = 'Go to CompanyExchange';
Mail::queue('emails.templates.welcome', $data, function ($message) use($email) {
$message->from('*****@*****.**', 'CompanyExchange');
$message->to($email);
$message->subject('Welcome to CompanyExchange');
});
} else {
Mail::queue('emails.templates.progress', $data, function ($message) use($email) {
$message->from('*****@*****.**', 'CompanyExchange');
$message->to($email);
$message->subject('Welcome to CompanyExchange');
});
}
Auth::loginUsingId($u->id);
return true;
}
Input::flash();
return $a->getValidator();
}
Input::flash();
return $u->getValidator();
}
