public function getUsers(Request $request)
{
Date::setLocale('th');
$records = [];
$records["data"] = [];
$filters = [];
if ($request->input('customActionType') && $request->input('customActionType') == "group_action" && $request->input('customActionName') == "delete") {
if (count($request->input('id')) > 0) {
$deleted = DB::table('TBL_PRIVILEGE')->whereIn('USER_PRIVILEGE_ID', $request->input('id'))->delete();
if ($deleted) {
$records["customActionStatus"] = "OK";
$records["customActionMessage"] = "ลบข้อมูลผู้ใช้เรียบร้อยแล้ว";
} else {
$records["customActionStatus"] = "Errors";
$records["customActionMessage"] = "ไม่สามารถลบข้อมูลผู้ใช้ได้";
}
}
}
$query = DB::table('TBL_USER')->select('TBL_USER.EMP_ID', 'TBL_EMPLOYEE_INFO.FULL_NAME', 'TBL_USER.USERNAME', 'TBL_USER.USER_STATUS_ID', 'TBL_USER_STATUS.STATUS_DESC', 'TBL_USER.USER_PRIVILEGE_ID', 'TBL_PRIVILEGE.USER_PRIVILEGE_DESC', 'TBL_USER.EMAIL', 'TBL_USER.PHONE', 'TBL_USER.CREATE_DATE', 'TBL_USER.LAST_MODIFY_DATE')->leftJoin('TBL_EMPLOYEE_INFO', 'TBL_USER.EMP_ID', '=', 'TBL_EMPLOYEE_INFO.EMP_ID')->leftJoin('TBL_PRIVILEGE', 'TBL_PRIVILEGE.USER_PRIVILEGE_ID', '=', 'TBL_USER.USER_PRIVILEGE_ID')->leftJoin('TBL_USER_STATUS', 'TBL_USER_STATUS.USER_STATUS_ID', '=', 'TBL_USER.USER_STATUS_ID');
if (!empty($request->input('user_id'))) {
$filters = ['TBL_USER.EMP_ID', $request->input('user_id')];
}
if (!empty($request->input('full_name'))) {
$filters = ['TBL_EMPLOYEE_INFO.FULL_NAME', 'like', $request->input('full_name') . '%'];
}
if ($request->input('user_group') != "") {
$filters = ['TBL_USER.USER_PRIVILEGE_ID', $request->input('user_group')];
}
if (!empty($request->input('email'))) {
$filters = ['TBL_USER.EMAIL', 'like', $request->input('email') . '%'];
}
if (!empty($request->input('phone'))) {
$filters = ['TBL_USER.PHONE', 'like', $request->input('phone') . '%'];
}
if ($filters) {
$query->where([$filters]);
}
$total = $query->count();
$limit = intval($request->input('length'));
$limit = $limit < 0 ? $limit : $limit;
$iDisplayStart = intval($request->input('start'));
$sEcho = intval($request->input('draw'));
$order = $request->input('order');
$orderColumns = [1 => 'TBL_USER.EMP_ID', 2 => 'TBL_EMPLOYEE_INFO.FULL_NAME', 3 => 'TBL_USER.USERNAME', 4 => 'TBL_USER_STATUS.STATUS_DESC', 5 => 'TBL_PRIVILEGE.USER_PRIVILEGE_DESC', 6 => 'TBL_USER.EMAIL', 7 => 'TBL_USER.PHONE', 8 => 'TBL_USER.CREATE_DATE', 9 => 'TBL_USER.LAST_MODIFY_DATE'];
if ($order) {
$query->orderBy($orderColumns[$order[0]['column']], $order[0]['dir']);
} else {
$query->orderBy('TBL_USER.EMP_ID', 'desc');
}
$users = $query->skip($iDisplayStart)->take($limit)->get();
if ($users) {
foreach ($users as $user) {
$create_date_str = '';
if ($user->CREATE_DATE) {
$create_date = new Date($user->CREATE_DATE);
$create_date_str = $create_date->add('543 years')->format('d M Y H:i:s');
}
$last_modify_date_str = '';
if ($user->LAST_MODIFY_DATE) {
$last_modify_date = new Date($user->LAST_MODIFY_DATE);
$last_modify_date_str = $last_modify_date->add('543 years')->format('d M Y H:i:s');
}
$records["data"][] = [sprintf('<input type="checkbox" name="id[]" value="%1$s">', $user->EMP_ID), $user->EMP_ID, $user->FULL_NAME, $user->USERNAME, $user->STATUS_DESC, $user->USER_PRIVILEGE_DESC, $user->EMAIL, $user->PHONE, $create_date_str, $last_modify_date_str, sprintf('<a href="%1$s" target="_blank" class="btn btn-sm btn-outline grey-salsa"><i class="fa fa-pencil"></i> แก้ไข</a><a data-toggle="modal" href="#deleteUserGroup" data-group_name="%2$s" data-group_id="%3$s" class="btn btn-sm btn-outline red-thunderbird row-user-group-%4$s"><i class="fa fa-remove"></i> ลบ</a>', action('UserGroupController@getEditUserGroup', $user->EMP_ID), $user->EMP_ID, $user->EMP_ID, $user->EMP_ID)];
}
}
$records["draw"] = $sEcho;
$records["recordsTotal"] = $total;
$records["recordsFiltered"] = $total;
return response()->json($records);
}
function get_date_year($input)
{
Date::setLocale('th');
$create_date = new Date($input);
return $create_date->add('543 years')->format('Y');
}