public function checklogin(Request $request)
{
//print_r($request->all());
$name = $request->get('name');
$code = $request->get('code');
$password = $request->input('password');
if ($code == session('captcha')) {
//$manager = \DB::table('managers')->select('name','password','status')->where('name','=',$name)->get();
$manager = Models\Manager::select('id', 'role_id', 'name', 'password', 'status')->where('name', '=', $name)->first();
if (count($manager) == 1) {
if ($manager->status == 1) {
if ($manager->password == md5(md5($password))) {
session(array('adminid' => $manager->id, 'adminname' => $manager->name));
//获取当前角色拥有的权限并存入session
$role = Models\Role::find($manager->role_id);
$authAllows = array();
foreach ($role->auths as $v) {
$authAllows[] = $v['module_name'] . '.' . $v['controller_name'] . '.' . $v['action_name'];
}
session(array('authAllows' => $authAllows));
return redirect(action('Admin\\IndexController@index'));
} else {
return $this->loginRedirectTo('账号密码错误');
}
} else {
return $this->loginRedirectTo('账号未激活');
}
} else {
return $this->loginRedirectTo('用户不存在');
}
} else {
return $this->loginRedirectTo('验证码不正确');
}
}
/**
* Creates data provider instance with search query applied
*
* @param array $params
*
* @return ActiveDataProvider
*/
public function search($params)
{
$query = Manager::find();
$dataProvider = new ActiveDataProvider(['query' => $query]);
if (!($this->load($params) && $this->validate())) {
return $dataProvider;
}
$query->andFilterWhere(['manager_id' => $this->manager_id]);
$query->andFilterWhere(['like', 'mobile', $this->mobile])->andFilterWhere(['like', 'name', $this->name]);
return $dataProvider;
}
/**
* Remove the specified resource from storage.
*
* @param int $id
* @return \Illuminate\Http\Response
*/
public function destroy($id)
{
$manager = Models\Manager::find($id);
if ($manager->delete()) {
return redirect(action('Admin\\ManagerController@index'));
} else {
return redirect(action('Admin\\ManagerController@index'))->withErrors('删除失败');
}
}
public function actionImportvipnew()
{
$file = Yii::$app->getRuntimePath() . DIRECTORY_SEPARATOR . 'vip.txt';
$fh = fopen($file, "r");
$i = 0;
while (!feof($fh)) {
$line = fgets($fh);
if (empty($line)) {
continue;
}
$line = iconv('GBK', 'UTF-8//IGNORE', $line);
$arr = explode("\t", $line);
//$arr[1] = iconv('GBK','UTF-8//IGNORE', $arr[1]);
//$arr[2] = iconv('GBK','UTF-8//IGNORE', $arr[2]);
//$arr[3] = iconv('GBK','UTF-8//IGNORE', $arr[3]);
$custom_mobile = trim($arr[0]);
$manager_name = trim($arr[1]);
$manager_mobile = trim($arr[2]);
$vip_level_title = trim($arr[3]);
$office_title = trim($arr[4]);
//$vip_join_time = trim($arr[4]);
//$vip_join_time = str_replace("/", "-", $vip_join_time);
//$vip_start_time = trim($arr[5]);
//$vip_start_time = str_replace("/", "-", $vip_start_time);
//$vip_end_time = trim($arr[6]);
//$vip_end_time = str_replace("/", "-", $vip_end_time);
$vipLevel = VipLevel::findOne(['title' => $vip_level_title]);
if (empty($vipLevel)) {
$vipLevel = new VipLevel();
$vipLevel->title = $vip_level_title;
if (!$vipLevel->save(false)) {
U::W('save vipLevel err');
}
}
$office = MOffice::findOne(['title' => $office_title]);
$custom = Custom::findOne(['mobile' => $custom_mobile]);
if (!empty($custom)) {
U::W("mobile={$custom_mobile} already exists");
U::W($arr);
// continue;
} else {
$custom = new Custom();
$custom->vip_join_time = '0000-00-00 00:00:00';
}
$custom->mobile = $custom_mobile;
$custom->is_vip = 1;
//$custom->vip_join_time = $vip_join_time;
//$custom->vip_start_time = $vip_start_time;
//$custom->vip_end_time = $vip_end_time;
$custom->vip_level_id = $vipLevel->vip_level_id;
$custom->office_id = empty($office) ? 0 : $office->office_id;
$custom->save(false);
$manager = Manager::findOne(['mobile' => $manager_mobile]);
if (empty($manager)) {
$manager = new Manager();
//$manager->mobile = $manager_mobile;
$manager->name = $manager_name;
$manager->save(false);
}
$customManager = CustomManager::findOne(['custom_id' => $custom->custom_id, 'manager_id' => $manager->manager_id]);
if (!empty($customManager)) {
//U::W('Impossible!!! CustomManager already exists');
//U::W($arr);
} else {
$customManager = new CustomManager();
$customManager->custom_id = $custom->custom_id;
$customManager->manager_id = $manager->manager_id;
if (!$customManager->save(false)) {
U::W('customManager SAVE ERR');
}
}
$i++;
//if($i > 5) break;
if ($i % 1000 == 1) {
U::W($i);
}
}
fclose($fh);
}
public function getManager()
{
return $this->hasOne(Manager::className(), ['manager_id' => 'manager_id']);
}
/**
* Finds the Manager model based on its primary key value.
* If the model is not found, a 404 HTTP exception will be thrown.
* @param string $id
* @return Manager the loaded model
* @throws NotFoundHttpException if the model cannot be found
*/
protected function findModel($id)
{
if (($model = Manager::findOne($id)) !== null) {
return $model;
} else {
throw new NotFoundHttpException('The requested page does not exist.');
}
}
