public static function get_user_detail($user_id, $value) { $count_member_detail = Userdetail::where('id', '=', $user_id)->count(); if ($count_member_detail > 0) { $user_detail = Userdetail::where('id', '=', $user_id)->first(); if ($value == "grade") { $grade = $user_detail->grade; if ($grade == 0) { $return_data = "N"; } else { if ($grade == 1) { $return_data = "D"; } else { if ($grade == 2) { $return_data = "C"; } else { if ($grade == 3) { $return_data = "B"; } else { if ($grade == 4) { $return_data = "A"; } else { $return_data = "N"; } } } } } } else { if ($value == "sortgrade") { $return_data = $user_detail->grade; } else { $return_data = $user_detail->{$value}; } } } else { $return_data = "N"; } return $return_data; }
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; }
public static function getedituser($id, $value) { $profiles = Member::where('id', '=', $id)->get(); foreach ($profiles as $record) { $vdata = $record->{$value}; } if ($value == 'education') { $education = education::orderBy('id')->get(); echo "<select name='education' id='education' class='form-control'>"; foreach ($education as $recode) { echo "<option value='" . $recode->id . "'"; if ($vdata == $recode->id) { echo " selected='selected'"; } echo ">" . $recode->name . "</option>"; } echo "</select>"; } else { if ($value == 'bank') { $bank = bank::orderBy('name')->get(); if (empty($vdata) || $vdata == 0) { $vdata = 3; } echo "<select name='bank' id='bank' class='form-control'>"; foreach ($bank as $recode) { echo "<option value='" . $recode->id . "'"; if ($vdata == $recode->id) { echo " selected='selected'"; } echo ">" . $recode->name . "</option>"; } echo "</select>"; } else { if ($value == 'birthday') { $split_birthday = explode("-", $vdata); $vdata = $split_birthday[2] . "/" . $split_birthday[1] . "/" . $split_birthday[0]; echo $vdata; } else { if ($value == 'shirts') { $shirts = Userdetail::where('id', '=', $id)->first(); if (count($shirts) > 0) { $shirts = $shirts->shirts; } else { $shirts = ""; } $size = ["1" => "MS", "2" => "MM", "3" => "ML", "4" => "WS", "5" => "WM", "6" => "WL"]; echo '<select class="form-control" id="shirts" name="shirts">'; foreach ($size as $recode) { echo "<option value='" . $recode . "'"; if ($shirts == $recode) { echo " selected='selected'"; } echo ">" . $recode . "</option>"; } echo '</select>'; } else { echo $vdata; } } } } }