public function register(Request $request)
{
$validate = validateuser::validate(Request::all());
if ($validate->passes()) {
$user = new Member();
$user->email = $request::input('email');
$user->password = \Hash::make($request::input('password'));
$user->name = $request::input('name');
$user->surname = $request::input('surname');
$user->nickname = $request::input('nickname');
$user->phone = $request::input('phone');
$user->id_card = $request::input('id_card');
$user->bank = $request::input('bank');
$user->account_no = $request::input('account');
$user->education = $request::input('education');
$user->institute = $request::input('institute');
$user->reference = $request::input('reference');
$link = '';
if ($user->save()) {
$userinfo = $request::only('email', 'password');
if (Auth::attempt($userinfo)) {
$link = '/';
}
//ส่ง email
//จบส่ง email
} else {
$link = 'register';
}
return Redirect::to($link);
} else {
return redirect::to('register')->withInput(Request::except('password'))->withErrors($validate->messages());
}
}
public function prosesRegister()
{
$member = new Member();
$member->MemberName = $_POST['name'];
$member->MemberEmail = $_POST['email'];
$member->MemberAddress = $_POST['address'];
$member->MemberPhone = $_POST['phone'];
$member->MemberPassword = $_POST['password'];
$member->MemberRegisterDate = Carbon::now();
$member->MemberExpiredDate = new Carbon('next year');
$member->save();
header('Location: ' . base);
}
public static function New_Assign($assign_id)
{
$root_url = dirname($_SERVER['PHP_SELF']);
$root_url = "http://ojconsultinggroup.com" . $root_url;
$assingment = Assignment::where("id", "=", $assign_id)->first();
$user = Member::where("id", "=", $assingment->user_id)->first();
$event = event::where("id", "=", $assingment->event_id)->first();
$customer_id = $event->customer_id;
$venue_id = $event->venue_id;
$venue_room = venue::where("id", "=", $venue_id)->first();
$customer = customer::where("id", "=", $customer_id)->first();
$userid = $user->id;
$idcard = $user->id_card;
$name = $user->name . " " . $user->surname;
$email = $user->email;
$event_name = $event->event_name;
$event_type = $event->event_type;
$split_event_date = explode("-", $event->event_date);
$event_date = $split_event_date[2] . " " . AssignCalendar::get_month_thai($split_event_date[1]) . " " . AssignCalendar::get_BE_year($split_event_date[0]);
$staff_appointment_time = $event->staff_appointment_time;
$customer_name = $customer->symbol . " - " . $customer->name;
$venue_name = $venue_room->venue->name . " : " . $venue_room->room_name;
$venue_address = $venue_room->venue->address;
$subject = "OJ - คุณได้รับมอบหมายงานในวันที่ " . $event_date;
$data = array('root_url' => $root_url, 'userid' => $userid, 'idcard' => $idcard, 'id' => $assign_id, 'name' => $name, 'event_name' => $event_name, 'event_type' => $event_type, 'event_date' => $event_date, 'staff_appointment_time' => $staff_appointment_time, 'customer_name' => $customer_name, 'venue_name' => $venue_name, 'venue_address' => $venue_address, 'subject' => $subject, 'email' => $email);
Mail::queue('Assign.New_assign_mail', $data, function ($message) use($data) {
$message->to($data['email'])->subject($data['subject']);
});
}
/**
* Show the application dashboard.
*
* @return Response
*/
public function getIndex(Request $request)
{
//return $sub;
Session::put('month', $this->monthName());
if (isset($request->c)) {
if (Session::has('member')) {
$member = Member::find(Session::get('member')->id);
$property = $member->properties()->where('code', '=', $request->c)->first();
Session::put('property', $property);
return view('property.index');
}
} else {
if (Session::has('hotel')) {
if (Session::has('member')) {
$property = Property::where("code", '=', Session::get('hotel'))->first();
Session::put('property', $property);
return view('property.index');
}
} else {
if (Session::has('property')) {
return view('property.index');
} else {
return redirect('/member/property');
}
}
}
}
public function poll_id($poll_id = null)
{
if ($poll_id) {
$this->andWhere([Member::tableName() . '.poll_id' => $poll_id]);
}
return $this;
}
public function validasi($memberID)
{
$member = Member::find($memberID);
$member->Validated = 1;
$member->update();
header('Location: ' . base . "/Member/show/0");
}
public static function member()
{
if (isset($_SESSION['member'])) {
return Member::find($_SESSION['member']);
}
return null;
}
public function search($params)
{
$query = Member::find()->indexBy('id');
$query->poll_id($this->poll_id);
$query->distinct();
// also possible is to group by member.id to get only the unique member entries.
//$query->addGroupBy($this->tableName().'.id');
// $query->with('codes.vote'); // old join
//$query->joinWith('codes', false, 'LEFT JOIN');
//$query->joinWith('codes.vote', true, 'LEFT JOIN');
// $query->joinWith(['relationname' => function ($query) {
// $query->from(['alias' => 'tablename']);
// }]);
// $query->joinWith(['codes' => function ($query) {
// $query->from(['codes' => 'code']);
// }]);
$query->joinWith(['codes.vote']);
$dataProvider = new ActiveDataProvider(['query' => $query, 'sort' => ['defaultOrder' => ['name' => SORT_ASC]], 'pagination' => ['pageSize' => 20]]);
if (!($this->load($params) && $this->validate())) {
return $dataProvider;
}
$query->andFilterWhere(['id' => $this->id, 'created_at' => $this->created_at, 'updated_at' => $this->updated_at, 'created_by' => $this->created_by, 'updated_by' => $this->updated_by]);
$query->andFilterWhere(['like', 'name', $this->name])->andFilterWhere(['like', 'group', $this->group]);
//if code CODE_STATUS_INVALID_UNUSED is searched also search for CODE_STATUS_INVALID_USED
if ($this->getAttribute('codes.code_status') == Code::CODE_STATUS_INVALID_UNUSED) {
$query->andWhere([Code::tableName() . '.code_status' => [Code::CODE_STATUS_INVALID_UNUSED, Code::CODE_STATUS_INVALID_USED]]);
} else {
$query->andFilterWhere(['=', Code::tableName() . '.code_status', $this->getAttribute('codes.code_status')]);
}
return $dataProvider;
}
public function updatemember()
{
$inputs = Input::all();
// Send information for Validation before saving data into DB
// Sending this id is the trick to avoid unique conflicts while updating
$validator = Membersvalidator::validator($inputs, $inputs['id']);
// if the validator fails, redirect back to the form
if ($validator->fails()) {
return Redirect::to('member')->withErrors($validator)->withInput(Input::all());
// send back the input
} else {
// update our member data
$member = Member::find($inputs['id']);
if ($member != null) {
$member->name = $inputs['name'];
$member->email = $inputs['email'];
$member->phone = $inputs['phone'];
$member->dob = $inputs['dob'];
$member->save();
}
// Update done so just forget from sessions update and Redirect to main page
Session::forget('update');
// We setup a cookie of recent change to show graphically user to a recent change in any field on home table
// And will delete this cookie on home page using javascript
setcookie("updatedUser", $inputs['email'], time() + 3600);
// 3600 = cookie life is 1 hour
return Redirect::to('/');
}
}
public static function main()
{
$Subject = Request::input('subject');
$Text = Request::input('text');
$user = Member::get();
if (isset($user)) {
foreach ($user as $record) {
$email[] = $record->email;
}
}
$root_url = dirname($_SERVER['PHP_SELF']);
$Host_name = $_SERVER['HTTP_HOST'];
$link = "http://www.ojconsultinggroup.com/" . $root_url;
if (isset($email) && !empty($email)) {
Mail::send('sendmail.Mail_template', array('subject' => $Subject, 'text' => $Text, 'link' => $link), function ($message) use($email, $Subject) {
$message->to($email)->subject($Subject);
});
if (count(Mail::failures()) > 0) {
$arr = array("status" => "fail");
return json_encode($arr);
} else {
$arr = array("status" => "success");
return json_encode($arr);
}
} else {
$arr = array("status" => "fail");
return json_encode($arr);
}
}
public function userTags()
{
$element = explode('-', $_POST['link_id']);
$link_id = $element[1];
$tag = $_POST['tag'];
$result = Member::addTag($link_id, $tag);
echo json_encode($_POST);
}
/**
* Finds the Member model based on its primary key value.
* If the model is not found, a 404 HTTP exception will be thrown.
* @param integer $id
* @return Member the loaded model
* @throws NotFoundHttpException if the model cannot be found
*/
protected function findModel($id)
{
if (($model = Member::findOne($id)) !== null) {
return $model;
} else {
throw new NotFoundHttpException('The requested page does not exist.');
}
}
/**
* indexAction
*
* @param Request $request
* @author Zaid Sadhoe <*****@*****.**>
*/
public function indexAction(Request $request)
{
$ajax = new Request();
$ajax->headers->set('X-Requested-With', 'XMLHttpRequest');
$memberCount = Member::count();
$webpageCount = Webpage::count();
$resultCount = Result::count();
return view('site.' . Site::getName() . '.page.index', ['request' => $request, 'memberCount' => $memberCount, 'webpageCount' => $webpageCount, 'resultCount' => $resultCount]);
}
public function prosesPinjam()
{
$pesan = "";
$error = false;
$member = $_POST['member'];
$item = $_POST['item'];
if ($member == "") {
$error = true;
$pesan .= "Member ID harus diisi<br />";
} else {
$mbr = Member::find($member);
if (!isset($mbr)) {
$error = true;
$pesan .= "Member tidak terdaftar<br />";
} else {
//cek sudah melakukan peminjaman berapa kali
$count = $mbr->pinjams()->where('TanggalKembali', null)->get()->count();
if ($count > 3) {
$error = true;
$pesan .= "Terlalu banyak meminjam<br />";
}
}
}
if ($item == "") {
$error = true;
$pesan .= "Item ID harus diisi<br />";
} else {
$itm = Item::find($item);
//var_dump($itm);
if (!isset($itm)) {
$error = true;
$pesan .= "Item tidak terdaftar<br />";
} elseif ($itm->ItemStatus != 'available') {
$error = true;
$pesan .= "Item tidak tersedia<br />";
}
}
if (!$error) {
$pesan = "berhasil";
$pinjam = new Peminjaman();
$pinjam->ItemID = $item;
$pinjam->MemberID = $member;
$pinjam->PetugasID = $this->petugas->PetugasID;
$pinjam->TanggalPinjam = Carbon::now();
$pinjam->TanggalHarusKembali = Carbon::now()->addWeek(1);
$pinjam->TanggalKembali = null;
$pinjam->save();
$itm = Item::find($item);
$itm->ItemStatus = 'borrowed';
$itm->update();
}
$_SESSION['msg'] = $pesan;
$_SESSION['error'] = $error;
header("Location: " . base . "/Transaksi/peminjaman");
}
public function accept()
{
$members = Member::findByIds([$this->from, $this->to])->indexBy('_id')->all();
Member::makeFriends($members[$this->from], $members[$this->to], true);
$this->addErrors($members[$this->from]->getErrors());
$this->addErrors($members[$this->to]->getErrors());
if (!$this->hasErrors()) {
$this->delete();
}
return $this;
}
public static function main()
{
$Member = Member::orderBy('nickname')->get();
$user_list = array();
foreach ($Member as $query) {
$full_name = $query->nickname . " - " . $query->name . " " . $query->surname;
$user_id = $query->id;
$user_list[] = "[" . $user_id . "] " . $full_name;
}
echo json_encode($user_list);
}
public function index()
{
//$members = Member::all('*', 10);
//$members = Member::where('email', 'LIKE', '%joko%')->get();
//$members = Member::first();
$members = Member::byId('M1411190001');
echo '<pre>';
print_r($members);
echo '</pre>';
Member::where('member_id', 'M1411190001')->update(array('postcode' => '41234'));
}
/**
* Run the database seeds.
*
* @return void
*/
public function run()
{
DB::table('members')->truncate();
DB::table('members')->insert([['name' => 'Tatsuya Yokoyama', 'age' => '30', 'gender' => 'man', 'skill' => 'iOS', 'detail' => 'hogehoge', 'created_at' => '2015-01-01 00:00:00', 'updated_at' => '2015-01-01 00:00:00'], ['name' => 'Nurupo Ohta', 'age' => '23', 'gender' => 'man', 'skill' => 'iOS Android', 'detail' => 'fugafuga', 'created_at' => '2015-01-01 00:00:00', 'updated_at' => '2015-01-01 00:00:00'], ['name' => 'Shinya Kotaki', 'age' => '36', 'gender' => 'man', 'skill' => 'Scrum Master', 'detail' => 'mogemoge', 'created_at' => '2015-01-01 00:00:00', 'updated_at' => '2015-01-01 00:00:00'], ['name' => 'Akira Furuya', 'age' => '27', 'gender' => 'man', 'skill' => 'iOS Web', 'detail' => 'piyopiyo', 'created_at' => '2015-01-01 00:00:00', 'updated_at' => '2015-01-01 00:00:00'], ['name' => 'Daiki Kanai', 'age' => '25', 'gender' => 'man', 'skill' => 'Web', 'detail' => 'magomago', 'created_at' => '2015-01-01 00:00:00', 'updated_at' => '2015-01-01 00:00:00']]);
//テストデータ自動作成クラス Fakerを利用
$faker = Faker::create('ja_JP');
$gender = ['男', '女'];
$skill = ['iOS', 'Android', 'Web'];
for ($i = 0; $i < 10; $i++) {
Member::create(['name' => $faker->name, 'age' => $faker->regexify('[0-9]{2}'), 'gender' => $faker->randomElement($gender), 'skill' => $faker->randomElement($skill), 'detail' => $faker->paragraph(), 'created_at' => Carbon::today(), 'updated_at' => Carbon::today()]);
}
}
public function actionRegister()
{
$email = $_REQUEST['email'];
$passwd = md5($_REQUEST['password']);
$memeber_type = $_REQUEST['member_type'];
$member_name = $_REQUEST['member_name'];
$member_phone = $_REQUEST['member_phone'];
$model = new Member();
$model->email = $email;
$model->password = $passwd;
$model->member_type = $memeber_type;
$model->member_name = $member_name;
$model->member_phone = $member_phone;
if ($model->save()) {
$arr = $model->find()->where(['email' => $email])->asArray()->one();
$res = array('code' => '10200', 'mess' => 'success', 'stat' => '200', 'data' => $arr);
} else {
$res = array('code' => '10204', 'mess' => 'The request is error', 'stat' => '100', 'data' => "");
}
exit(json_encode($res));
}
public function search()
{
$tournamentId = Input::get('tournamentId');
$collection = Member::with(['teamMembers', 'tournamentTeams'])->get();
$collection = $collection->filter(function ($member) use($tournamentId) {
$team = $member->tournamentTeams->first(function ($key, $tournamentTeam) use($tournamentId) {
return $tournamentTeam->tournamentId == $tournamentId;
});
return is_null($team);
});
return $this->response->collection($collection, new TeamMemberSearchTransformer(), 'members');
}
public static function reset()
{
if (Request::input('rs_type') == "change") {
$validate = validateuser::validatechangepass(Request::all());
if ($validate->passes()) {
$user = Member::where("id", "=", Request::input('id'))->first();
$dbpass = $user->password;
$passcheck = \Hash::check(Request::input('old_password'), $dbpass);
if ($passcheck == TRUE) {
$user->password = \Hash::make(Request::input('password'));
if ($user->save()) {
return Redirect::to('user_profile')->with('status', 'Change password has been completed');
}
} else {
return redirect()->back()->withErrors('Old Password is Wrong!');
}
} else {
return redirect()->back()->withErrors($validate->messages());
}
} else {
if (Request::input('rs_type') == "forgot") {
$validate = validateuser::validateforgotpass(Request::all());
if ($validate->passes()) {
//get email from server
$user = Member::where("id", "=", Request::input('id'))->first();
$email = $user->email;
//get key from server
$reset = Reset::where("email", "=", $email)->first();
$key = $reset->token;
//Check email match
if ($email == Request::input('email')) {
//Check key match
if ($key == Request::input('key')) {
$user->password = \Hash::make(Request::input('password'));
//Change completed
if ($user->save()) {
return Redirect::to('login')->with('status', 'Change password has been completed');
}
} else {
return redirect()->back()->withErrors('key is Wrong! Please resend forgot password.');
}
} else {
return redirect()->back()->withErrors('email is Wrong!');
}
} else {
return redirect()->back()->withInput(Request::except('password'))->withErrors($validate->messages());
}
} else {
//Not match all
}
}
}
public static function create_userform($user_id, $value)
{
$user = Member::orderBy('name')->get();
$html = "<select name='" . $value . "' id='" . $value . "' class='form-control'>\n <option value='0'>none</option>";
foreach ($user as $recode) {
$html .= "<option value='" . $recode->id . "'";
if ($user_id == $recode->id) {
$html .= " selected='selected'";
}
$html .= ">" . $recode->nickname . " - " . $recode->name . " " . $recode->surname . "</option>";
}
$html .= "</select>";
return $html;
}
/**
* Creates data provider instance with search query applied
*
* @param array $params
*
* @return ActiveDataProvider
*/
public function search($params)
{
$query = Member::find();
$dataProvider = new ActiveDataProvider(['query' => $query]);
$this->load($params);
if (!$this->validate()) {
// uncomment the following line if you do not want to return any records when validation fails
// $query->where('0=1');
return $dataProvider;
}
$query->andFilterWhere(['id' => $this->id]);
$query->andFilterWhere(['like', 'name', $this->name])->andFilterWhere(['like', 'position', $this->position])->andFilterWhere(['like', 'mobile', $this->mobile])->andFilterWhere(['like', 'email', $this->email])->andFilterWhere(['like', 'summary', $this->summary])->andFilterWhere(['like', 'pic', $this->pic]);
return $dataProvider;
}
public function add()
{
if (Request::isMethod('get')) {
// tampilkan form
$members = Member::get();
return view('document.add', compact('members'));
} else {
// simpan document baru
$document = Document::create(Input::only('name', 'url', 'member_id'));
// $member_id = Input::get('member_id');
// $member = Member::find($member_id);
// $document->member()->associate($member)->save();
return redirect('document');
}
}
/**
* Creates a new Code model.
* If creation is successful, the browser will be redirected to the 'view' page.
* @return mixed
*/
public function actionCreate($poll_id, $member_id)
{
$member = Member::findOne($member_id);
if ($member) {
if ($member->hasValidCode()) {
$code = $member->getValidCode();
$code->invalidate();
$code->save();
}
Code::generateCode($poll_id, $member_id)->save();
}
// else {
//Yii::$app->getSession()->setFlash('error', 'This member already has a valid voting code');
//}
return $this->redirect(PollUrl::toRoute(['member/view', 'poll_id' => $poll_id, 'id' => $member_id]));
}
public function postLogin(Request $request)
{
$messages = ['email.required' => 'กรุณาใส่อีเมล์', 'email.email' => 'กรุณาใส่อีเมล์ให้ถูกต้อง', 'email.exists' => 'ไม่มีอีเมล์ดังกล่าวในระบบ', 'password.required' => 'กรุณาใส่พาสเวิร์ด'];
$validator = Validator::make($request->all(), ['email' => 'required|email|exists:ch_member,email', 'password' => 'required'], $messages);
//$request->session()->put('data', 'value');
if ($validator->fails()) {
return redirect()->back()->withErrors($validator)->withInput();
}
$member = \App\Models\Member::where("email", "=", $request->email)->first();
if (Hash::check($request->password, $member->password)) {
$request->session()->put('member', $member);
} else {
return redirect()->back()->withErrors(['พาสเวิร์ดหรืออีเมล์ของคุณไม่สัมพันธ์กัน'])->withInput();
}
return redirect('/member');
}
public function actionSendsingle($member_id)
{
$member = Member::find()->primary_key($member_id)->poll_searchOptions($this->getPollSearchOptions())->one();
if ($member === null) {
throw new NotFoundHttpException(Yii::t('app/error', 'The requested page does not exist.'));
}
$email = new EmailForm();
if ($email->load(Yii::$app->request->post()) && $email->validate()) {
if ($this->sendEmailToMember($email, $member)) {
Yii::$app->getSession()->setFlash('success', Yii::t('app', 'Email sent successfully.'));
} else {
Yii::$app->getSession()->setFlash('error', Yii::t('app', 'Failed to send email.'));
}
}
return $this->redirect(['member/view', 'id' => $member->id]);
}
public function actionProfile()
{
$session = new Session();
$session->open();
$id = $session->get('member_id');
$member = Member::findOne($id);
if (!empty($_POST)) {
$member->name = $_POST['Member']['name'];
$member->username = $_POST['Member']['username'];
$member->password = $_POST['Member']['password'];
if ($member->save()) {
$session->setFlash('message', 'Update member info success.');
return $this->redirect(['profile']);
}
}
return $this->render('//Frontend/Profile', ['member' => $member]);
}
public function showPagination()
{
// We can limit it or increase it by changing value 8.
// If we do not want pagination then replace Member::paginate(8); with Member::all();
$members = Member::paginate(8);
// For finding how many numbers we need for pagination i use this technique
// maximum results / results to show PerPage
// In case you do not want pagination in data retriving then we can Remove $reqPagination, $currentPageurl and $active.
$reqPagination = ceil($members->total() / $members->perPage());
$reqPagination = number_format($reqPagination, 0);
// For adding active class in pagination menu (this css class will show user on which page user is)
$currentPageurl = $members->url($members->currentPage());
// get current page url
// get the numeric value from url for comparing it with for-loop $i
$active = filter_var($currentPageurl, FILTER_SANITIZE_NUMBER_INT);
// Use this if Pagination is Enable
return view('home')->with('members', $members)->with('totalRecords', $members->total())->with('reqPagination', $reqPagination)->with('active', $active);
}
public function actionAssign($id)
{
$model = $this->findModel($id);
$dataProvider = new ActiveDataProvider(['query' => ProjectAssignments::find()]);
$dataProviderForMember = new ActiveDataProvider(['query' => Member::find()]);
if (isset($_GET['selected_user_id'])) {
$new_list = $_GET['selected_user_id'];
} else {
$new_list = [];
}
if (isset($_GET['old_list'])) {
$old_list = $_GET['old_list'];
} else {
$old_list = [];
}
$model->assignCompositeProjectList($old_list, $new_list);
return $this->render('view', ['model' => $this->findModel($id), 'dataProvider' => $dataProvider, 'dataProviderForMember' => $dataProviderForMember]);
}
