示例#1
0
 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']);
     });
 }
 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'));
 }
示例#3
0
 public function show($validate = 1, $active = 1)
 {
     $now = Carbon::now();
     if ($active == 1) {
         $members = Member::where('Validated', $validate)->where('MemberExpiredDate', '>', $now)->get();
     } else {
         $members = Member::where('Validated', $validate)->where('MemberExpiredDate', '<', $now)->get();
     }
     $kode = $validate == 1 ? $active == 1 ? 1 : 3 : 2;
     $this->view->render('admin/member', ['members' => $members, 'kode' => $kode, 'petugas' => $this->petugas]);
 }
示例#4
0
 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
         }
     }
 }
示例#5
0
 public static function get_user_data($user_id, $value)
 {
     $count_member = Member::where('id', '=', $user_id)->count();
     if ($count_member > 0) {
         $user = Member::where('id', '=', $user_id)->first();
         if ($value == "fullname") {
             $return_data = $user->nickname . " - " . $user->name . " " . $user->surname;
         } else {
             $return_data = $user->{$value};
         }
         return $return_data;
     }
 }
示例#6
0
 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');
 }
示例#7
0
 public function sendEmailReminder()
 {
     $validate = validateuser::validateforgot(Request::all());
     if ($validate->passes()) {
         $count = Member::where('email', '=', Request::input('email'))->count();
         if ($count == 1) {
             $forgot_code = sendmail::generateRandomString();
             $sforgot_code = MD5($forgot_code);
             Mail::send('Member.mailforgot', array('code' => $sforgot_code), function ($message) {
                 $message->to(Request::input('email'))->subject('Your Reminder!');
             });
             return redirect::to('/');
         } else {
             $msg = "Not found email!";
             return redirect::to('forgot')->withInput(Request::except('password'))->withErrors($msg);
         }
     } else {
         return redirect::to('forgot')->withInput(Request::except('password'))->withErrors($validate->messages());
     }
 }
示例#8
0
 public function sendEmailForgot()
 {
     $validate = validateuser::validateforgot(Request::all());
     if ($validate->passes()) {
         $count = Member::where('email', '=', Request::input('email'))->count();
         if ($count == 1) {
             $forgot_code = sendmail::generateRandomString();
             $sforgot_code = MD5($forgot_code);
             $countforgot = Reset::where('email', '=', Request::input('email'))->count();
             if ($countforgot == 1) {
                 $reset = Reset::where("email", "=", Request::input('email'))->first();
                 $reset->token = $sforgot_code;
                 $reset->save();
             } else {
                 $reset = new Reset();
                 $reset->email = Request::input('email');
                 $reset->token = $sforgot_code;
                 $reset->save();
             }
             $profiles = Member::where('email', '=', Request::input('email'))->get();
             foreach ($profiles as $record) {
                 $name = $record->name;
                 $id = $record->id;
             }
             $email = Request::input('email');
             $link = 'http://www.ojconsultinggroup.com/4oj/reset/' . $id . '/token/' . $sforgot_code;
             $data = array('code' => $sforgot_code, 'name' => $name, 'link' => $link);
             Mail::queue('Member.mailforgot', $data, function ($message) use($email, $data) {
                 $message->to($email)->subject('Your Password Reset Link!');
             });
             return Redirect::to('forgot')->with('status', 'อีเมลสำหรับตั้งรหัสผ่านใหม่ได้ถูกส่งไปแล้ว');
         } else {
             $msg = "เกิดข้อผิดพลาด! ไม่พบชื่ออีเมลนี้ในระบบ";
             return Redirect::to('forgot')->withInput(Request::except('password'))->withErrors($msg);
         }
     } else {
         return Redirect::to('forgot')->withInput(Request::except('password'))->withErrors($validate->messages());
     }
 }
示例#9
0
    dd($memberThatHasDocuments);
});
Route::get('eager', function () {
    $members = Member::get();
    $members->load('documents');
    foreach ($members as $member) {
        $member->documents;
    }
});
Route::get('morph', function () {
    // Student::create(['name' => 'Mahasiswa']);
    // Lecturer::create(['name' => 'Dosen']);
    $mahasiswa = Student::first();
    $dosen = Lecturer::first();
    $saya = Member::where('name', 'Saya')->first();
    $kamu = Member::where('name', 'Kamu')->first();
    $dosen->member()->save($saya);
    $mahasiswa->member()->save($kamu);
    dump($kamu->person);
    dump($saya->person);
});
Route::get('coba_asset', function () {
    // Asset::create(['name' => 'meja']);
    // Asset::create(['name' => 'kursi']);
    // Asset::create(['name' => 'lemari']);
    $member = Member::first();
    $assets = Asset::get();
    $array = [1, 2, 3, 4];
    $collection = collect($array);
    $reverse = $collection->reverse();
    $asset_ids = $assets->pluck('id')->all();
示例#10
0
 public static function report_request_job($filter_group, $filter_value, $sort, $user_id_filter)
 {
     if ($user_id_filter != 'null') {
         $filter_group = '1';
     }
     $root_url = dirname($_SERVER['PHP_SELF']);
     //===========================================================================================
     if ($filter_group == 'all') {
         $request = request_job::orderBy('start_date')->get();
         $returndata = "";
         $returndata .= "<div class='row'>\n        <div class='col-lg-12'>\n          <div class='table-responsive'>\n              <p>จำนวนรายการร้องขอทำงานทั้งหมด : " . count($request) . "</p>\n              <table class='table table-bordered table-hover table-striped'>\n                <thead>\n                  <tr>\n                    <th class='text-center'>ชื่อผู้ร้องขอ</th>\n                    <th class='text-center'>วันเริ่ม</th>\n                    <th class='text-center'>วันสิ้นสุด</th>\n                    <th class='text-center'>ช่วงเวลา</th>\n                    <th class='text-center'>ชื่อกิจกรรม</th>\n                    <th class='text-center'>หมายเหตุ</th>\n                  </tr>\n                </thead>\n                <tbody>";
         foreach ($request as $row) {
             $user = Member::where("id", "=", $row->user_id)->first();
             $user_id = $user->id;
             $user_name = $user->nickname . "-" . $user->name . " " . $user->surname;
             $split_start_date = explode("-", $row->start_date);
             $start_date = $split_start_date[2] . "/" . $split_start_date[1] . "/" . $split_start_date[0];
             $split_end_date = explode("-", $row->end_date);
             $end_date = $split_end_date[2] . "/" . $split_end_date[1] . "/" . $split_end_date[0];
             if ($row->duration == 1) {
                 $duration = "ทั้งวัน";
             } else {
                 if ($row->duration == 2) {
                     $duration = "ช่วงเช้า";
                 } else {
                     if ($row->duration == 3) {
                         $duration = "ช่วงบ่าย";
                     }
                 }
             }
             $event_id = "";
             $event_name = "";
             if ($row->event_id != 0) {
                 $event = event::where("id", "=", $row->event_id)->first();
                 $event_id = $event->id;
                 $event_name = $event->event_name;
             }
             $returndata .= "<tr>\n                            <td class=''><a target='_blank' href='" . $root_url . "/profile_admin/" . $user_id . "'>" . $user_name . "</a></td>\n                            <td class='text-center'>" . $start_date . "</td>\n                            <td class='text-center'>" . $end_date . "</td>\n                            <td class='text-center'>" . $duration . "</td>\n                            <td class='text-center'><a href='" . $root_url . "/event_detail/" . $event_id . "'>" . $event_name . "</a></td>\n                            <td>" . $row->remark . "</td>\n                          </tr>";
         }
         $returndata .= "</tbody>\n              </table>\n            </div>\n        </div>\n      </div>";
     } else {
         if ($filter_group == '1') {
             if ($user_id_filter != 'null') {
                 $query_user = $user_id_filter;
             } else {
                 $query_user_splite1 = explode("[", $filter_value);
                 $query_user_splite2 = explode("]", $query_user_splite1[1]);
                 $query_user = $query_user_splite2[0];
             }
             $request = request_job::where("user_id", "=", $query_user)->orderBy('start_date')->get();
             $returndata = "";
             $returndata .= "<div class='row'>\n        <div class='col-lg-12'>\n          <div class='table-responsive'>\n            <p>จำนวนรายการร้องขอทำงานทั้งหมด : " . count($request) . "</p>\n              <table class='table table-bordered table-hover table-striped'>\n                <thead>\n                  <tr>\n                    <th class='text-center'>ชื่อผู้ร้องขอ</th>\n                    <th class='text-center'>วันเริ่ม</th>\n                    <th class='text-center'>วันสิ้นสุด</th>\n                    <th class='text-center'>ช่วงเวลา</th>\n                    <th class='text-center'>ชื่อกิจกรรม</th>\n                    <th class='text-center'>หมายเหตุ</th>\n                  </tr>\n                </thead>\n                <tbody>";
             foreach ($request as $row) {
                 $user = Member::where("id", "=", $row->user_id)->first();
                 $user_id = $user->id;
                 $user_name = $user->nickname . "-" . $user->name . " " . $user->surname;
                 $split_start_date = explode("-", $row->start_date);
                 $start_date = $split_start_date[2] . "/" . $split_start_date[1] . "/" . $split_start_date[0];
                 $split_end_date = explode("-", $row->end_date);
                 $end_date = $split_end_date[2] . "/" . $split_end_date[1] . "/" . $split_end_date[0];
                 if ($row->duration == 1) {
                     $duration = "ทั้งวัน";
                 } else {
                     if ($row->duration == 2) {
                         $duration = "ช่วงเช้า";
                     } else {
                         if ($row->duration == 3) {
                             $duration = "ช่วงบ่าย";
                         }
                     }
                 }
                 $event_id = "";
                 $event_name = "";
                 if ($row->event_id != 0) {
                     $event = event::where("id", "=", $row->event_id)->first();
                     $event_id = $event->id;
                     $event_name = $event->event_name;
                 }
                 $returndata .= "<tr>\n                            <td class=''><a target='_blank' href='" . $root_url . "/profile_admin/" . $user_id . "'>" . $user_name . "</a></td>\n                            <td class='text-center'>" . $start_date . "</td>\n                            <td class='text-center'>" . $end_date . "</td>\n                            <td class='text-center'>" . $duration . "</td>\n                            <td class='text-center'><a href='" . $root_url . "/event_detail/" . $event_id . "'>" . $event_name . "</a></td>\n                            <td>" . $row->remark . "</td>\n                          </tr>";
             }
             $returndata .= "</tbody>\n              </table>\n            </div>\n        </div>\n      </div>";
         } else {
             if ($filter_group == '2') {
                 $input_date = explode("/", $filter_value);
                 $date = $input_date[2] . "-" . $input_date[1] . "-" . $input_date[0];
                 $request = request_job::where("start_date", "<=", $date)->where("end_date", ">=", $date)->orderBy('start_date')->get();
                 $returndata = "";
                 $returndata .= "<div class='row'>\n        <div class='col-lg-12'>\n          <div class='table-responsive'>\n              <p>จำนวนรายการร้องขอทำงานทั้งหมด : " . count($request) . "</p>\n              <table class='table table-bordered table-hover table-striped'>\n                <thead>\n                  <tr>\n                    <th class='text-center'>ชื่อผู้ร้องขอ</th>\n                    <th class='text-center'>วันเริ่ม</th>\n                    <th class='text-center'>วันสิ้นสุด</th>\n                    <th class='text-center'>ช่วงเวลา</th>\n                    <th class='text-center'>ชื่อกิจกรรม</th>\n                    <th class='text-center'>หมายเหตุ</th>\n                  </tr>\n                </thead>\n                <tbody>";
                 foreach ($request as $row) {
                     $user = Member::where("id", "=", $row->user_id)->first();
                     $user_id = $user->id;
                     $user_name = $user->nickname . "-" . $user->name . " " . $user->surname;
                     $split_start_date = explode("-", $row->start_date);
                     $start_date = $split_start_date[2] . "/" . $split_start_date[1] . "/" . $split_start_date[0];
                     $split_end_date = explode("-", $row->end_date);
                     $end_date = $split_end_date[2] . "/" . $split_end_date[1] . "/" . $split_end_date[0];
                     if ($row->duration == 1) {
                         $duration = "ทั้งวัน";
                     } else {
                         if ($row->duration == 2) {
                             $duration = "ช่วงเช้า";
                         } else {
                             if ($row->duration == 3) {
                                 $duration = "ช่วงบ่าย";
                             }
                         }
                     }
                     $event_id = "";
                     $event_name = "";
                     if ($row->event_id != 0) {
                         $event = event::where("id", "=", $row->event_id)->first();
                         $event_id = $event->id;
                         $event_name = $event->event_name;
                     }
                     $returndata .= "<tr>\n                            <td class=''><a target='_blank' href='" . $root_url . "/profile_admin/" . $user_id . "'>" . $user_name . "</a></td>\n                            <td class='text-center'>" . $start_date . "</td>\n                            <td class='text-center'>" . $end_date . "</td>\n                            <td class='text-center'>" . $duration . "</td>\n                            <td class='text-center'><a href='" . $root_url . "/event_detail/" . $event_id . "'>" . $event_name . "</a></td>\n                            <td>" . $row->remark . "</td>\n                          </tr>";
                 }
                 $returndata .= "</tbody>\n              </table>\n            </div>\n        </div>\n      </div>";
             }
         }
     }
     //===============================================================================================
     echo $returndata;
 }
示例#11
0
 /**
  * Get User's session
  *
  * @param string $userKey
  * @param bool $create
  * @return Member
  */
 private static function getUser($userKey = null, $create = false)
 {
     $session = session();
     $user = null;
     if ($userKey) {
         $user = Member::where(['key' => $userKey])->first();
         if (!$user && $create && Member::getAutoLicense(Site::getName())) {
             $user = Member::create(['key' => $userKey, 'first_name' => Site::getName() . ' user']);
             $user->createAutoLicense(Site::getName());
         }
         if ($user) {
             $session->put('tool.user', $user->key);
         }
     } else {
         if ($session->has('tool.user')) {
             $userKey = $session->get('tool.user');
             $user = Member::where(['key' => $userKey])->first();
         }
     }
     return $user;
 }
示例#12
0
 public function getByActivation($code)
 {
     $user = Member::where('activation_code', $code)->first();
     return $user;
 }
示例#13
0
 public static function district($id, $type)
 {
     if ($type == 'edit') {
         $user = Member::where("id", "=", $id)->first();
         $id = $user->district;
     }
     $district = district::orderBy('name')->get();
     echo "<select name='district' id='district' class='form-control'><option value='0'>none</option>";
     foreach ($district as $recode) {
         echo "<option value='" . $recode->id . "'";
         if ($id == $recode->id) {
             echo " selected='selected'";
         }
         echo ">" . $recode->name . "</option>";
     }
     echo "</select>";
 }
示例#14
0
 public static function get_OJ_contact($id, $value)
 {
     $event = event::where("id", "=", $id)->first();
     $userid = $event->staff_contact_id;
     $user = Member::where("id", "=", $userid)->first();
     if ($value == "name") {
         $datareturn = $user->nickname . " - " . $user->name . " " . $user->surname;
     } else {
         $datareturn = $user->{$value};
     }
     return $datareturn;
 }
示例#15
0
文件: GetUser.php 项目: geniuspom/4oj
 public static function updateuser()
 {
     $validate = validateuser::validateupdateuser(Request::all());
     if ($validate->passes()) {
         $address_id = Request::input('address_id');
         if (Request::input('address_id_checkbox') == true) {
             $address_id = Request::input('address');
         }
         $input_birthday = explode("/", Request::input('birthday'));
         $birthday = $input_birthday[2] . "-" . $input_birthday[1] . "-" . $input_birthday[0];
         $user = Member::where("id", "=", Request::input('id'))->first();
         $user->name = Request::input('name');
         $user->surname = Request::input('surname');
         $user->nickname = Request::input('nickname');
         $user->phone = Request::input('phone');
         $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');
         $user->address = Request::input('address');
         $user->province = Request::input('province');
         $user->birthday = $birthday;
         $user->lineid = Request::input('lineid');
         $user->address_id = $address_id;
         if (Request::input('province') != 69) {
             $user->district = 0;
         } else {
             $user->district = Request::input('district');
         }
         if ($user->save()) {
             $userinfo = Request::only('email', 'password');
             //ตรวจสอบสถาบันว่ามีไหมถ้าไม่มีให้เพิ่มไป
             $countinstitute = institute::where('name', 'LIKE', Request::input('institute'))->count();
             if ($countinstitute < 1) {
                 $institute = new institute();
                 $institute->name = Request::input('institute');
                 $institute->save();
             }
             //จบตรวจสอบสถาบันว่ามีไหมถ้าไม่มีให้เพิ่มไป
             return Redirect::to('useredit/' . Request::input('id'))->with('status', 'Update has been completed');
         } else {
             return Redirect::to('useredit/' . Request::input('id'))->withErrors('Error some thing is wrong!');
         }
     } else {
         return redirect::to('useredit/' . Request::input('id'))->withInput(Request::except('password'))->withErrors($validate->messages());
     }
 }
示例#16
0
 public function uploadidcard()
 {
     $root_url = dirname($_SERVER['PHP_SELF']);
     if (Request::exists('btn-upload')) {
         $user_id = Request::input('user_id');
         $file = Request::file('uploader');
         $path = 'upload_file/idcard/default';
         $filename = $file->getClientOriginalName();
         //check file extension
         $ext = pathinfo($filename, PATHINFO_EXTENSION);
         $newfilename = "idcard_id" . $user_id . "." . $ext;
         $file->move($path, $newfilename);
         if ($ext == 'pdf') {
             //if pdf set pdf icon to thumbnail
             $thunbnail = 'upload_file/idcard/thumbnail/pdf.png';
         } else {
             if ($ext == 'jpg' || $ext == 'png' || $ext == 'gif') {
                 //if image create thumbnail
                 $img = Image::make('upload_file/idcard/default/' . $newfilename);
                 if ($img->height() == $img->width()) {
                     $imgresult = $img->resize(206, 206);
                 } else {
                     if ($img->height() > $img->width()) {
                         $imgresult = $img->resize(206, null, function ($constraint) {
                             $constraint->aspectRatio();
                         });
                     } else {
                         $imgresult = $img->resize(null, 206, function ($constraint) {
                             $constraint->aspectRatio();
                         });
                     }
                 }
                 //set and save resize image to thumbnail
                 $imgresult->save('upload_file/idcard/thumbnail/' . $newfilename);
                 $thunbnail = 'upload_file/idcard/thumbnail/' . $newfilename;
             }
         }
         $count = idcard::where('id_user', '=', $user_id)->count();
         if ($count == 1) {
             $dbidcard = idcard::where('id_user', '=', $user_id)->first();
             $oldext = pathinfo($dbidcard->id_name, PATHINFO_EXTENSION);
             $image_path = '../' . $root_url . '/upload_file/idcard/default/' . $dbidcard->id_name;
             if ($oldext != 'pdf') {
                 $image_thumbnail = '..' . $root_url . '/' . $dbidcard->id_thumbnail;
                 if ($newfilename != $dbidcard->id_name) {
                     unlink($image_thumbnail);
                 }
             }
             if ($newfilename != $dbidcard->id_name) {
                 unlink($image_path);
             }
             //update link
             $dbidcard->id_name = $newfilename;
             $dbidcard->id_thumbnail = $thunbnail;
             $dbidcard->save();
             //update id validate status
             $user = Member::where('id', '=', $user_id)->first();
             $validate = $user->validate;
             $mail_st = substr($validate, 1, 1);
             $verify_id = substr($validate, 3, 1);
             $new_validate = "1" . $mail_st . "1" . $verify_id;
             $user->validate = $new_validate;
             $user->save();
             //End update id validate status
         } else {
             //save to batabase
             $dbidcard = new idcard();
             $dbidcard->id_name = $newfilename;
             $dbidcard->id_user = $user_id;
             $dbidcard->id_thumbnail = $thunbnail;
             $dbidcard->save();
             //update id validate status
             $user = Member::where('id', '=', $user_id)->first();
             $validate = $user->validate;
             $mail_st = substr($validate, 1, 1);
             $verify_id = substr($validate, 3, 1);
             $new_validate = "1" . $mail_st . "1" . $verify_id;
             $user->validate = $new_validate;
             $user->save();
             //End update id validate status
         }
     }
     return redirect()->back();
 }
示例#17
0
 public static function checkemailverify()
 {
     $user = Member::where("id", "=", Auth::user()->id)->first();
     $u_status = $user->validate;
     $mail_st = substr($u_status, 1, 1);
     if ($mail_st == 1) {
         return true;
     } else {
         return false;
     }
 }
示例#18
0
 public static function update_user_form($user_id, $value_name)
 {
     if ($value_name == "permission" || $value_name == "validate" || $value_name == "status_mail") {
         $user = Member::where("id", "=", $user_id)->first();
         if ($value_name == "status_mail") {
             $return_value = $user->validate;
         } else {
             $return_value = $user->{$value_name};
         }
         if ($value_name == "permission") {
             $data_permissions = ["1" => "User - ผู้ใช้ทั่วไป", "2" => "Staff - พนักงาน", "3" => "Admin - ผู้ดูแลระบบ"];
             $return_data = "<select name='permission' id='permission' class='form-control'>";
             foreach ($data_permissions as $permission => $permission_value) {
                 $return_data .= "<option value='" . $permission . "'";
                 if ($return_value == $permission) {
                     $return_data .= " selected='selected'";
                 }
                 $return_data .= ">" . $permission_value . "</option>";
             }
             $return_data .= "</select>";
         } else {
             if ($value_name == "validate") {
                 $oldvalidate = $return_value;
                 $validate_id_status = substr($oldvalidate, 3, 1);
                 if ($validate_id_status == 1) {
                     $return_data = "checked";
                 } else {
                     $return_data = "";
                 }
             } else {
                 if ($value_name == "status_mail") {
                     $oldvalidate = $return_value;
                     $validate_id_status = substr($oldvalidate, 1, 1);
                     if ($validate_id_status == 1) {
                         $return_data = "checked";
                     } else {
                         $return_data = "";
                     }
                 }
             }
         }
     } else {
         if ($value_name == "grade" || $value_name == "training_status" || $value_name == "training_date" || $value_name == "remark") {
             $count_userdetail = Userdetail::where("id", "=", $user_id)->count();
             //===================================================================================
             if ($value_name == "grade") {
                 $data_grade = ["0" => "none", "4" => "A", "3" => "B", "2" => "C", "1" => "D"];
                 $return_data = "<select name='grade' id='grade' class='form-control'>";
                 foreach ($data_grade as $grade => $grade_value) {
                     $return_data .= "<option value='" . $grade . "'";
                     if ($count_userdetail > 0) {
                         $userdetail = Userdetail::where("id", "=", $user_id)->first();
                         if ($userdetail->grade == $grade) {
                             $return_data .= " selected='selected'";
                         }
                     }
                     $return_data .= ">" . $grade_value . "</option>";
                 }
                 $return_data .= "</select>";
             } else {
                 if ($count_userdetail > 0) {
                     $userdetail = Userdetail::where("id", "=", $user_id)->first();
                     $userdetail_value = $userdetail->{$value_name};
                     if ($value_name == "training_status") {
                         if ($userdetail_value == 1) {
                             $return_data = "checked";
                         } else {
                             $return_data = "";
                         }
                     } else {
                         if ($value_name == "training_date" && !empty($userdetail_value)) {
                             $split_training_date = explode("-", $userdetail_value);
                             $return_data = $split_training_date[2] . "/" . $split_training_date[1] . "/" . $split_training_date[0];
                         } else {
                             $return_data = $userdetail_value;
                         }
                     }
                 } else {
                     $return_data = "";
                 }
             }
         }
     }
     //===================================================================================
     echo $return_data;
 }
示例#19
0
 public static function save_database($user_id, $save_name, $role_method)
 {
     if ($role_method == "profile") {
         $count = imageDB::where('image_user', '=', $user_id)->count();
         if ($count == 1) {
             $database = imageDB::where('image_user', '=', $user_id)->first();
         } else {
             $database = new imageDB();
         }
         $database->image_name = $save_name;
         $database->image_thumbnail = "upload_file/images/thumbnail/" . $save_name;
         $database->image_user = $user_id;
     } else {
         $count = idcardDB::where('id_user', '=', $user_id)->count();
         if ($count == 1) {
             $database = idcardDB::where('id_user', '=', $user_id)->first();
         } else {
             $database = new idcardDB();
         }
         $database->id_name = $save_name;
         $database->id_thumbnail = "upload_file/idcard/thumbnail/" . $save_name;
         $database->id_user = $user_id;
         //update id validate status
         $user = Member::where('id', '=', $user_id)->first();
         $validate = $user->validate;
         $mail_st = substr($validate, 1, 1);
         $verify_id = substr($validate, 3, 1);
         $new_validate = "1" . $mail_st . "1" . $verify_id;
         $user->validate = $new_validate;
         $user->save();
         //End update id validate status
     }
     $database->save();
 }