public function destroy($id)
{
Department::findorFail($id)->delete();
}
public function index()
{
$branchs = Branch::all(['id', 'name']);
$branchselectlist = array();
array_push($branchselectlist, ':เลือกสาขา');
foreach ($branchs as $item) {
array_push($branchselectlist, $item->id . ':' . $item->name);
}
$departments = Department::all(['id', 'name']);
$departmentselectlist = array();
array_push($departmentselectlist, ':เลือกแผนก');
foreach ($departments as $item) {
array_push($departmentselectlist, $item->id . ':' . $item->name);
}
$teams = Team::all(['id', 'name']);
$teamselectlist = array();
array_push($teamselectlist, ':เลือกทีม');
foreach ($teams as $item) {
array_push($teamselectlist, $item->id . ':' . $item->name);
}
return view('employee', ['branchselectlist' => implode(";", $branchselectlist), 'departmentselectlist' => implode(";", $departmentselectlist), 'teamselectlist' => implode(";", $teamselectlist)]);
}
function getPage($page)
{
$params = [];
if (User::isLogged()) {
$u = User::getUser();
$explodeName = explode(' ', $u->user_name);
$first = strlen($explodeName[0]) > 0 ? $explodeName[0] : '';
$last = isset($explodeName[1]) > 0 ? $explodeName[1] : '';
$params['userName'] = $u->user_name;
$params['userInfo'] = $u;
$params['firstName'] = $first;
$params['lastName'] = $last;
}
if (!User::isLogged()) {
return view('login');
}
switch ($page) {
case 'inicio':
return view('home')->with($params);
break;
case 'perfil':
return view('profile')->with($params);
/*$user = User::getUser($_SESSION['ina_user']['id']);
$user_ext = User::join("state","state.id","=","user.state_id")->join("country","country.id","=","state.country_id")->where("user.id","=",$_SESSION['ina_user']['id'])->get(array("country.phone_ext"))->first();
$params['page']['ext']=$user_ext->phone_ext;
return view('profile', array('user' => $user))->with($params);*/
break;
case 'catalogos':
$params['departments'] = Department::getAllDepartments();
return view('catalogs')->with($params);
break;
case 'pacientes':
return view('patients')->with($params);
break;
default:
break;
}
}
public function cloneEvent(Request $request, Event $event)
{
$this->authorize('create-event');
$this->validate($request, ['start_date' => 'required|date_format:Y-m-d']);
// Set up event information
$startDate = new Carbon($event->start_date);
$endDate = new Carbon($event->end_date);
$newStartDate = new Carbon($request->input('start_date'));
$departments = $event->departments;
// Find the difference of the start dates
$difference = $startDate->diffInSeconds($newStartDate);
// Create new event from old event data
$newEvent = Event::create(['name' => $event->name, 'description' => $event->description, 'start_date' => $startDate->addSeconds($difference)->format('Y-m-d'), 'end_date' => $endDate->addSeconds($difference)->format('Y-m-d')]);
// Add the image manually because it's not automatically fillable
if ($event->image) {
$newEvent->image = $event->image;
$newEvent->save();
}
// Loop through event departments
foreach ($departments as $department) {
// Create new department
$newDepartment = new Department();
$newDepartment->event_id = $newEvent->id;
$newDepartment->save();
// Because the event_id isn't fillable, we have to define it first and then update
$newDepartment->update(['name' => $department->name, 'description' => $department->description, 'roles' => $department->roles]);
// Loop through shifts
$shifts = $department->shifts;
foreach ($shifts as $shift) {
// Adjust shift dates
$shift->start_date = new Carbon($shift->start_date);
$shift->end_date = new Carbon($shift->end_date);
$shift->start_date = $shift->start_date->addSeconds($difference)->format('Y-m-d');
$shift->end_date = $shift->end_date->addSeconds($difference)->format('Y-m-d');
// Update the department ID
$shift->department_id = $newDepartment->id;
$newShift = Shift::create(['department_id' => $newDepartment->id, 'name' => $shift->name, 'start_date' => $shift->start_date, 'end_date' => $shift->end_date, 'start_time' => $shift->start_time, 'end_time' => $shift->end_time, 'duration' => $shift->duration, 'roles' => $shift->roles]);
Slot::generate($newShift);
}
}
$request->session()->flash('success', 'Event has been cloned.');
return redirect('/event/' . $newEvent->id);
}
/**
* Run the database seeds.
*
* @return void
*/
public function run()
{
////////////////////////////////////
// Load the routes
Route::loadLaravelRoutes();
// Look for and delete route named 'do-not-load' if it exist.
// That route is used to test the Authorization middleware and should not be loaded automatically.
$routeToDelete = Route::where('name', 'do-not-load')->get()->first();
if ($routeToDelete) {
Route::destroy($routeToDelete->id);
}
////////////////////////////////////
// Create basic set of permissions
$permGuestOnly = Permission::create(['name' => 'guest-only', 'display_name' => 'Guest only access', 'description' => 'Only guest users can access these.', 'enabled' => true]);
$permOpenToAll = Permission::create(['name' => 'open-to-all', 'display_name' => 'Open to all', 'description' => 'Everyone can access these, even unauthenticated (guest) users.', 'enabled' => true]);
$permBasicAuthenticated = Permission::create(['name' => 'basic-authenticated', 'display_name' => 'Basic authenticated', 'description' => 'Basic permission after being authenticated.', 'enabled' => true]);
// Create a few permissions for the admin|security section
$permManageUsers = Permission::create(['name' => 'manage-users', 'display_name' => 'Manage users', 'description' => 'Allows a user to manage the site users.', 'enabled' => true]);
$permManageRoles = Permission::create(['name' => 'manage-roles', 'display_name' => 'Manage roles', 'description' => 'Allows a user to manage the site roles.', 'enabled' => true]);
$permManagePermissions = Permission::create(['name' => 'manage-permissions', 'display_name' => 'Manage permissions', 'description' => 'Allows a user to manage the site permissions.', 'enabled' => true]);
$permManageRoutes = Permission::create(['name' => 'manage-routes', 'display_name' => 'Manage routes', 'description' => 'Allows a user to Manage the site routes.', 'enabled' => true]);
// Create a few permissions for the admin|audit section
$permAuditLogView = Permission::create(['name' => 'audit-log-view', 'display_name' => 'View audit log', 'description' => 'Allows a user to view the audit log.', 'enabled' => true]);
$permAuditReplay = Permission::create(['name' => 'audit-log-replay', 'display_name' => 'Replay audit log item', 'description' => 'Allows a user to replay items from the audit log.', 'enabled' => true]);
$permAuditPurge = Permission::create(['name' => 'audit-log-purge', 'display_name' => 'Purge audit log', 'description' => 'Allows a user to purge old items from the audit log.', 'enabled' => true]);
////////////////////////////////////
// Associate open-to-all permission to some routes
$routeBackslash = Route::where('name', 'backslash')->get()->first();
$routeBackslash->permission()->associate($permOpenToAll);
$routeBackslash->save();
$routeHome = Route::where('name', 'home')->get()->first();
$routeHome->permission()->associate($permOpenToAll);
$routeHome->save();
$routeFaust = Route::where('name', 'faust')->get()->first();
$routeFaust->permission()->associate($permOpenToAll);
$routeFaust->save();
// Associate basic-authenticated permission to the dashboard route
$routeDashboard = Route::where('name', 'dashboard')->get()->first();
$routeDashboard->permission()->associate($permBasicAuthenticated);
$routeDashboard->save();
// Associate the audit-log permissions
$routeAuditView = Route::where('name', 'admin.audit.index')->get()->first();
$routeAuditView->permission()->associate($permAuditLogView);
$routeAuditView->save();
$routeAuditPurge = Route::where('name', 'admin.audit.purge')->get()->first();
$routeAuditPurge->permission()->associate($permAuditPurge);
$routeAuditPurge->save();
$routeAuditReplay = Route::where('name', 'admin.audit.replay')->get()->first();
$routeAuditReplay->permission()->associate($permAuditReplay);
$routeAuditReplay->save();
// Associate manage-permission permissions to routes starting with 'admin.permissions.'
$managePermRoutes = Route::where('name', 'like', "admin.permissions.%")->get()->all();
foreach ($managePermRoutes as $route) {
$route->permission()->associate($permManagePermissions);
$route->save();
}
// Associate manage-roles permissions to routes starting with 'admin.roles.'
$manageRoleRoutes = Route::where('name', 'like', "admin.roles.%")->get()->all();
foreach ($manageRoleRoutes as $route) {
$route->permission()->associate($permManageRoles);
$route->save();
}
// Associate manage-routes permissions to routes starting with 'admin.routes.'
$manageRouteRoutes = Route::where('name', 'like', "admin.routes.%")->get()->all();
foreach ($manageRouteRoutes as $route) {
$route->permission()->associate($permManageRoutes);
$route->save();
}
// Associate manage-users permissions to routes starting with 'admin.users.'
$manageUserRoutes = Route::where('name', 'like', "admin.users.%")->get()->all();
foreach ($manageUserRoutes as $route) {
$route->permission()->associate($permManageUsers);
$route->save();
}
////////////////////////////////////
// Create role: admins
$roleAdmins = Role::create(["name" => "admins", "display_name" => "Administrators", "description" => "Administrators have no restrictions", "enabled" => true]);
// Create role: users
// Assign permission basic-authenticated
$roleUsers = Role::create(["name" => "users", "display_name" => "Users", "description" => "All authenticated users", "enabled" => true]);
$roleUsers->perms()->attach($permBasicAuthenticated->id);
// Create role: user-manager
// Assign permission manage-users
$roleUserManagers = Role::create(["name" => "user-managers", "display_name" => "User managers", "description" => "User managers are granted all permissions to the Admin|Users section.", "enabled" => true]);
$roleUserManagers->perms()->attach($permManageUsers->id);
// Create role: role-manager
// Assign permission: manage-roles
$roleRoleManagers = Role::create(["name" => "role-managers", "display_name" => "Role managers", "description" => "Role managers are granted all permissions to the Admin|Roles section.", "enabled" => true]);
$roleRoleManagers->perms()->attach($permManageRoles->id);
// Create role: audit-viewers
// Assign permission: audit-log-view
$roleAuditViewers = Role::create(["name" => "audit-viewers", "display_name" => "Audit viewers", "description" => "Users allowed to view the audit log.", "enabled" => true]);
$roleAuditViewers->perms()->attach($permAuditLogView->id);
// Create role: audit-replayers
// Assign permission: audit-log-replay
$roleAuditReplayers = Role::create(["name" => "audit-replayers", "display_name" => "Audit replayers", "description" => "Users allowed to replay items from the audit log.", "enabled" => true]);
$roleAuditReplayers->perms()->attach($permAuditReplay->id);
// Create role: audit-purgers
// Assign permission: audit-log-purge
$roleAuditPurgers = Role::create(["name" => "audit-purgers", "display_name" => "Audit purgers", "description" => "Users allowed to purge old items from the audit log.", "enabled" => true]);
$roleAuditPurgers->perms()->attach($permAuditPurge->id);
// Create regency data
$regency_data = array('Trưởng Phòng', 'Nhân viên');
foreach ($regency_data as $data) {
$regency = Regency::create(['name' => $data, 'enabled' => true]);
}
// Create department data
$department_data = array('Quản lý', 'Kinh doanh', 'Sản xuất', 'Marketing-degital', 'Kế toán', 'Giao nhận', 'Thiết kế');
foreach ($department_data as $data) {
$department = Department::create(['name' => $data, 'enabled' => true]);
}
////////////////////////////////////
// Create user: root
// Assign membership to role admins, membership to role users is
// automatic.
$userRoot = User::create(["first_name" => "Root", "last_name" => "SuperUser", "username" => "root", "email" => "*****@*****.**", "password" => "thienhb", "gender" => true, "auth_type" => "internal", "enabled" => true, "regency_id" => true, "department_id" => true]);
$userRoot->roles()->attach($roleAdmins->id);
}
public function getIsChief()
{
return Department::findOne(['chief_id' => $this->id]) !== null;
}
/**
* Select choices for department_id (ycm)
*
* @return array
*/
public function department_idChoices()
{
return ArrayHelper::map(Department::find()->orderBy('name ASC')->all(), 'id', 'name');
}
public function getAll()
{
return Department::find()->asArray()->all();
}
public function start()
{
$session = Session::get('start_session');
if ($session) {
$data['title'] = "Welcome";
$user = User::find($session['user_id']);
$profile = new \stdClass();
$profile->id = $user->id;
$profile->profile_picture = $user->owner->profile_picture()->path();
$profile->first_name = $user->owner->first_name;
$profile->last_name = $user->owner->last_name;
$profile->username = $user->username;
$profile->contacts = new \stdClass();
$profile->contact = $user->active_contact;
foreach ($user->owner->company_person as $contact) {
$profile->contacts->{$contact->id} = $contact;
if (!isset($profile->first_contact)) {
$profile->first_contact = $contact->id;
}
}
$data['profile'] = $profile;
$data['departments'] = Department::orderBy("name")->get();
$data['titles'] = Title::orderBy("name")->get();
return view('login.start', $data);
} else {
return redirect()->intended();
}
}
/**
* Return Department database entry associated with this department
* @return mixed
*/
public function departmentSpecifications()
{
return Department::where('name', 'Slitting Department')->first();
}
public function getDepartment()
{
return $this->hasOne(Department::className(), ['id' => 'department_id']);
}
public function execute($parameters = [])
{
if (!isset($parameters['action'])) {
$result = ['Result' => 'ERROR', 'Message' => 'Faltan parámetros'];
return json_encode($result);
}
switch ($parameters['action']) {
/* DEPARTMENTS*/
case 'department_list':
$result = [];
if (!User::isLogged()) {
$result = ['Result' => 'ERROR', 'Message' => 'No esta loguedo'];
}
extract($parameters);
$jtStartIndex = isset($jtStartIndex) ? $jtStartIndex : 0;
$jtPageSize = isset($jtPageSize) ? $jtPageSize : 10;
$jtSorting = isset($jtSorting) ? $jtSorting : 'name ASC';
$result['Result'] = 'OK';
$result['Records'] = Department::getPaginateDepartments($jtStartIndex, $jtPageSize, $jtSorting);
$result['TotalRecordCount'] = Department::getAllDepartmentsCount();
return $result;
break;
case 'department':
if (!User::isLogged()) {
$result = ['Result' => 'ERROR', 'Message' => 'No esta loguedo'];
}
extract($parameters);
$result = [];
$result['Result'] = Department::getDepartmentDetail($department);
$result['Message'] = 'OK';
return $result;
break;
case 'department_create':
if (!User::isLogged()) {
$result = ['Result' => 'ERROR', 'Message' => 'No esta loguedo'];
}
extract($parameters);
$result = [];
$userId = User::getUserId();
$result['Record'] = Department::createDepartment($name, $status, $userId);
$result['Result'] = 'OK';
return $result;
break;
case 'department_update':
if (!User::isLogged()) {
$result = ['Result' => 'ERROR', 'Message' => 'No esta loguedo'];
}
$tmpArray = $parameters;
extract($parameters);
$result = [];
$result['Records'] = Department::updateDepartmentDetail($id, $name, $status);
$result['Result'] = 'OK';
return $result;
break;
case 'department_delete':
if (!User::isLogged()) {
$result = ['Result' => 'ERROR', 'Message' => 'No esta loguedo'];
}
extract($parameters);
$result = [];
$result['Records'] = Department::deleteDepartmentDetail($id);
$result['Result'] = 'OK';
return $result;
break;
/* TOWNS*/
/* TOWNS*/
case 'town_create':
if (!User::isLogged()) {
$result = ['Result' => 'ERROR', 'Message' => 'No esta loguedo'];
}
extract($parameters);
$result = [];
$userId = User::getUserId();
$result['Record'] = Town::createTown($townName, $status, $userId, $departmentId);
$result['Result'] = 'OK';
return $result;
break;
case 'town_list':
if (!User::isLogged()) {
$result = ['Result' => 'ERROR', 'Message' => 'No esta loguedo'];
}
extract($parameters);
$jtStartIndex = isset($jtStartIndex) ? $jtStartIndex : 0;
$jtPageSize = isset($jtPageSize) ? $jtPageSize : 10;
$jtSorting = isset($jtSorting) ? $jtSorting : 'departmentName ASC';
$result = [];
$sort = isset($jtSorting) ? $jtSorting : ' ASC';
$result['Records'] = Town::getPaginateTowns($jtStartIndex, $jtPageSize, $jtSorting);
$result['Result'] = 'OK';
$result['TotalRecordCount'] = Town::getTotal();
return $result;
break;
case 'town_update':
if (!User::isLogged()) {
$result = ['Result' => 'ERROR', 'Message' => 'No esta loguedo'];
}
$tmpArray = $parameters;
extract($parameters);
$result = [];
$result['Records'] = Town::updateTownDetail($id, $townName, $departmentId, $status);
$result['Result'] = 'OK';
return $result;
break;
case 'town_delete':
if (!User::isLogged()) {
$result = ['Result' => 'ERROR', 'Message' => 'No esta loguedo'];
}
extract($parameters);
$result = [];
$result['Record'] = Town::deleteTownDetail($id);
$result['Result'] = 'OK';
return $result;
break;
/* RESPONSIBLES*/
/* RESPONSIBLES*/
case 'responsible_list':
if (!User::isLogged()) {
$result = ['Result' => 'ERROR', 'Message' => 'No esta loguedo'];
}
extract($parameters);
$jtStartIndex = isset($jtStartIndex) ? $jtStartIndex : 0;
$jtPageSize = isset($jtPageSize) ? $jtPageSize : 10;
$jtSorting = isset($jtSorting) ? $jtSorting : 'name ASC';
$result = [];
$result['Records'] = ResponsibleType::getPaginateResponsibles($jtStartIndex, $jtPageSize, $jtSorting);
$result['Result'] = 'OK';
$result['TotalRecordCount'] = ResponsibleType::getTotal();
return $result;
break;
case 'responsible_create':
if (!User::isLogged()) {
$result = ['Result' => 'ERROR', 'Message' => 'No esta loguedo'];
}
extract($parameters);
$result = [];
$userId = User::getUserId();
$result['Record'] = ResponsibleType::createResponsibleType($name, $status);
$result['Result'] = 'OK';
return $result;
break;
case 'responsible_update':
if (!User::isLogged()) {
$result = ['Result' => 'ERROR', 'Message' => 'No esta loguedo'];
}
extract($parameters);
$result = [];
$result['Records'] = ResponsibleType::updateResponsibleType($id, $name, $status);
$result['Result'] = 'OK';
return $result;
break;
case 'responsible_delete':
if (!User::isLogged()) {
$result = ['Result' => 'ERROR', 'Message' => 'No esta loguedo'];
}
extract($parameters);
$result = [];
$result['Record'] = ResponsibleType::deleteResponsibleType($id);
$result['Result'] = 'OK';
return $result;
break;
/* DISEASE*/
/* DISEASE*/
case 'disease_list':
$result = [];
if (!User::isLogged()) {
$result = ['Result' => 'ERROR', 'Message' => 'No esta loguedo'];
}
extract($parameters);
$jtStartIndex = isset($jtStartIndex) ? $jtStartIndex : 0;
$jtPageSize = isset($jtPageSize) ? $jtPageSize : 10;
$jtSorting = isset($jtSorting) ? $jtSorting : 'name ASC';
$result['Records'] = DiseaseType::getPaginateDiseaseType($jtStartIndex, $jtPageSize, $jtSorting);
$result['Result'] = 'OK';
$result['TotalRecordCount'] = DiseaseType::getTotal();
return $result;
break;
case 'disease_create':
if (!User::isLogged()) {
$result = ['Result' => 'ERROR', 'Message' => 'No esta loguedo'];
}
extract($parameters);
$result = [];
$userId = User::getUserId();
$result['Record'] = DiseaseType::createDiseaseType($name, $status, $userId);
$result['Result'] = 'OK';
return $result;
break;
case 'disease_update':
if (!User::isLogged()) {
$result = ['Result' => 'ERROR', 'Message' => 'No esta loguedo'];
}
extract($parameters);
$result = [];
$result['Records'] = DiseaseType::updateDisease($id, $name, $status);
$result['Result'] = 'OK';
return $result;
break;
case 'disease_delete':
if (!User::isLogged()) {
$result = ['Result' => 'ERROR', 'Message' => 'No esta loguedo'];
}
extract($parameters);
$result = [];
$result['Record'] = DiseaseType::deleteDiseaseType($id);
$result['Result'] = 'OK';
return $result;
break;
default:
$result = [];
$result['Result'] = 'ERROR';
$result['Message'] = 'Acción no definida';
return json_encode($result);
}
}
use yii\helpers\Html;
//use yii\widgets\ActiveForm;
use kartik\widgets\ActiveForm;
use app\models\Position;
use yii\helpers\ArrayHelper;
use app\models\Department;
/* @var $this yii\web\View */
/* @var $model app\models\Staff */
/* @var $form yii\widgets\ActiveForm */
?>
<div class="staff-form">
<?php
$Position = Position::find()->all();
$arraypos = ArrayHelper::map($Position, 'positio_id', 'position_name');
$Department = Department::find()->all();
$arraydep = ArrayHelper::map($Department, 'department_id', 'department_name');
// echo '<pre>';
// print_r($arraypos);
// echo '<pre>';
?>
<?php
$form = ActiveForm::begin();
?>
<?php
echo $form->field($model, 'position_id')->dropDownList($arraypos, ['prompt' => '--Select--']);
?>
<?php
/**
* Finds the Department model based on its primary key value.
* If the model is not found, a 404 HTTP exception will be thrown.
* @param integer $id
* @return Department the loaded model
* @throws NotFoundHttpException if the model cannot be found
*/
protected function findModel($id)
{
if (($model = Department::findOne($id)) !== null) {
return $model;
} else {
throw new NotFoundHttpException('The requested page does not exist.');
}
}
<div class="digital-form">
<?php
$form = ActiveForm::begin();
?>
<?php
echo $form->field($model, 'regis_num')->textInput(['maxlength' => true]);
?>
<?php
echo $form->field($model, 'date_work')->widget(DatePicker::className(), ['options' => ['class' => 'form-control'], 'language' => 'th', 'dateFormat' => 'yyyy-MM-dd']);
?>
<?php
echo $form->field($model, 'department_id')->dropDownList(ArrayHelper::map(Department::find()->all(), 'id', 'name'), ['prompt' => 'เลือกหน่วยงาน']);
?>
<?php
echo $form->field($model, 'subject')->textarea(['rows' => 6]);
?>
<?php
echo $form->field($model, 'num_pages')->textInput();
?>
<?php
echo $form->field($model, 'paper_type')->textInput();
?>
<?php
use yii\helpers\Html;
use yii\widgets\ActiveForm;
use yii\helpers\ArrayHelper;
/* @var $this yii\web\View */
/* @var $model app\models\Employee */
/* @var $form yii\widgets\ActiveForm */
?>
<div class="employee-form">
<?php
$form = ActiveForm::begin();
?>
<?php
echo $form->field($model, 'Department_id')->dropDownList(ArrayHelper::map(Department::find()->all(), 'id', 'name'));
?>
<?php
echo $form->field($model, 'Chief_id')->dropDownList(ArrayHelper::map(Employee::find()->all(), 'id', 'Name'));
?>
<?php
echo $form->field($model, 'Name')->textInput(['maxlength' => true]);
?>
<?php
echo $form->field($model, 'Salary')->textInput();
?>
<div class="form-group">
/**
* Run the database seeds.
*
* @return void
*/
public function run()
{
$createDep = new Department();
$createDep->id = '1';
$createDep->name = 'Managment';
$createDep->save();
\DB::table('department_user')->insert(['department_id' => 1, 'user_id' => 1]);
}
public function delete(Request $request, Department $department)
{
$this->authorize('delete-department');
$event = $department->event;
$department->delete();
event(new EventChanged($event, ['type' => 'department', 'status' => 'deleted']));
$request->session()->flash('success', 'Department has been deleted.');
return redirect('/event/' . $event->id);
}
public function byDepartment(Request $request)
{
$department = new Department();
$d1 = array_flatten($department->whereNotIn('code', ['KIT'])->orderBy('code', 'DESC')->get(['id'])->toArray());
$depts = [['name' => 'Dining', 'employees' => [], 'deptid' => $d1], ['name' => 'Kitchen', 'employees' => [], 'deptid' => ['71B0A2D2674011E596ECDA40B3C0AA12']]];
for ($i = 0; $i <= 1; $i++) {
$employees = Employee::with('position')->select('lastname', 'firstname', 'positionid', 'employee.id')->join('position', 'position.id', '=', 'employee.positionid')->where('branchid', $request->user()->branchid)->whereIn('deptid', $depts[$i]['deptid'])->orderBy('employee.lastname', 'ASC')->orderBy('employee.firstname', 'ASC')->get();
$depts[$i]['employees'] = $employees;
}
return $depts;
}
public static function createDepartment($name, $status, $userId)
{
$department = new Department();
$date = GeneralValues::getActualDate();
$department->name = $name;
$department->status = $status;
$department->created_at = $date;
$department->updated_at = $date;
$department->fk_user_who_create = $userId;
$department->save();
return $department;
}
public function index()
{
if (!$this->hasPermission($this->menuPermissionName)) {
return view($this->viewPermissiondeniedName);
}
$branchs = Branch::all(['id', 'name']);
$branchselectlist = array();
array_push($branchselectlist, ':เลือกสาขา');
foreach ($branchs as $item) {
array_push($branchselectlist, $item->id . ':' . $item->name);
}
$departments = Department::all(['id', 'nameth', 'nameen']);
$departmentselectlist = array();
array_push($departmentselectlist, ':เลือกแผนก');
foreach ($departments as $item) {
array_push($departmentselectlist, $item->id . ':' . str_replace('&', '\\u0026', $item->nameth) . ' - ' . str_replace('&', '\\u0026', $item->nameen));
}
$teams = Team::all(['id', 'name']);
$teamselectlist = array();
array_push($teamselectlist, ':เลือกทีม');
foreach ($teams as $item) {
array_push($teamselectlist, $item->id . ':' . $item->name);
}
return view('employee', ['branchselectlist' => implode(";", $branchselectlist), 'departmentselectlist' => implode(";", $departmentselectlist), 'teamselectlist' => implode(";", $teamselectlist)]);
}
public function actionAssign($id)
{
$incoming = $this->loadModel($id);
$endpoint = new Endpoint();
$deptList = ArrayHelper::map(\app\models\Department::getAll(), 'id', 'name');
return $this->render('assign', ['incoming' => $incoming, 'endpoint' => $endpoint, 'deptList' => $deptList]);
}
public function edit(ShiftRequest $request, Shift $shift)
{
$this->authorize('edit-shift');
$input = $request->all();
$department = Department::find($input['department_id']);
// Convert roles into JSON
$input['roles'] = json_encode($input['roles']);
// Check if the current roles match the department roles
if ($input['roles'] == $department->roles) {
// Unset the roles, use department as default instead
unset($input['roles']);
}
// Make sure dates and times are set properly and formatted
$input = Shift::setDates($department, $input);
$input = Shift::setTimes($input);
$shift->formatTimes();
// Check if the start time, end time, or duration are changing
$regenerateSlots = false;
if ($shift->start_date != $input['start_date'] || $shift->end_date != $input['end_date'] || $shift->start_time != $input['start_time'] || $shift->end_time != $input['end_time'] || $shift->duration != $input['duration']) {
$regenerateSlots = true;
}
$shift->update($input);
// Regenerate slots after the updated shift information is saved
if ($regenerateSlots) {
Slot::generate($shift);
}
event(new EventChanged($shift->event, ['type' => 'shift', 'status' => 'edited']));
$request->session()->flash('success', 'Shift has been updated.');
return redirect('/event/' . $shift->event->id);
}
public function getEdit($id)
{
$user = User::find($id);
$departments = Department::orderBy('dw', 'asc')->get();
$majors = Major::orderBy('zy', 'asc')->get();
$groups = Group::orderBy('id', 'asc')->get();
return view('user.edit', ['title' => '编辑用户', 'user' => $user, 'departments' => $departments, 'majors' => $majors, 'groups' => $groups]);
}
public function programs($id, $results = null)
{
$departments = null;
if ($results == null) {
$departments = Department::find($id)->programs()->get();
} else {
$departments = Department::find($id)->programs()->paginate($results);
}
return Response::json($departments);
}
/**
* Run the database seeds.
*
* @return void
*/
public function run()
{
factory(App\Models\User::class, 5)->create()->each(function ($c) {
});
$createDep = new Department();
$createDep->id = '2';
$createDep->name = 'Nerds';
$createDep->save();
$createDep = new Department();
$createDep->id = '3';
$createDep->name = 'Genius';
$createDep->save();
$newrole = new RoleUser();
$newrole->role_id = '1';
$newrole->user_id = '2';
$newrole->timestamps = false;
$newrole->save();
$newrole = new RoleUser();
$newrole->role_id = '2';
$newrole->user_id = '3';
$newrole->timestamps = false;
$newrole->save();
$newrole = new RoleUser();
$newrole->role_id = '3';
$newrole->user_id = '4';
$newrole->timestamps = false;
$newrole->save();
$newrole = new RoleUser();
$newrole->role_id = '3';
$newrole->user_id = '5';
$newrole->timestamps = false;
$newrole->save();
$newrole = new RoleUser();
$newrole->role_id = '3';
$newrole->user_id = '6';
$newrole->timestamps = false;
$newrole->save();
\DB::table('department_user')->insert([['department_id' => 1, 'user_id' => 2], ['department_id' => 2, 'user_id' => 3], ['department_id' => 3, 'user_id' => 4], ['department_id' => 3, 'user_id' => 5], ['department_id' => 2, 'user_id' => 6]]);
}
public function actionMerge()
{
$source = Yii::$app->request->post('source');
$src = Yii::$app->request->post('src');
Record::updateAll(array('department_id' => $src), 'department_id in (' . $source . ')');
//更新对话记录的科室
Department::deleteAll('id in (' . $source . ') and id<>' . $src);
//删除源科室
$result = array();
$result['status'] = 1;
$result['message'] = '合并成功';
return $this->renderJson($result);
}
/**
* Creates data provider instance with search query applied
*
* @param array $params
*
* @return ActiveDataProvider
*/
public function search($params)
{
$query = Department::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, 'fac_ID' => $this->fac_ID]);
$query->andFilterWhere(['like', 'deptName', $this->deptName])->andFilterWhere(['like', 'deptCode', $this->deptCode]);
return $dataProvider;
}
public function create()
{
if (Auth::user()->can('create-company')) {
$data['titles'] = Title::orderBy("name")->get();
$data['departments'] = Department::orderBy("name")->get();
$data['support_types'] = SupportType::orderBy("name")->get();
$data['connection_types'] = ConnectionType::orderBy("name")->get();
$data['group_types'] = GroupType::orderBy("name")->get();
$data['escalation_profiles'] = EscalationProfile::orderBy("name")->get();
$data['account_managers'] = CompanyPersonController::API()->all(["where" => ["company_person.company_id|=|" . ELETTRIC80_COMPANY_ID, "company_person.title_id|=|" . ACCOUNT_MANAGER_TITLE_ID], "order" => ["people.last_name|ASC", "people.first_name|ASC"], "paginate" => "false"]);
$data['title'] = "Create Company";
return view('companies/create', $data);
} else {
return redirect()->back()->withErrors(['Access denied to companies create page']);
}
}
/**
* @param $id
*
* @return \Illuminate\View\View
*/
public function edit($id)
{
$user = $this->user->find($id);
Audit::log(Auth::user()->id, trans('admin/users/general.audit-log.category'), trans('admin/users/general.audit-log.msg-edit', ['username' => $user->username]));
$page_title = trans('admin/users/general.page.edit.title');
// "Admin | User | Edit";
$page_description = trans('admin/users/general.page.edit.description', ['full_name' => $user->full_name]);
// "Editing user";
$department_data = $this->department->where('enabled', 1)->lists('name', 'id');
$regency_data = $this->regency->where('enabled', 1)->lists('name', 'id');
if (!$user->isEditable()) {
abort(403);
}
$roles = $this->role->pushCriteria(new RolesByNamesAscending())->all();
$perms = $this->perm->pushCriteria(new PermissionsByNamesAscending())->all();
// $roleCollection = \App\Models\Role::take(10)->get(['id', 'display_name'])->lists('display_name', 'id');
// $roleList = [''=>''] + $roleCollection->all();
return view('admin.users.edit', compact('user', 'roles', 'perms', 'page_title', 'page_description', 'department_data', 'regency_data'));
}
