public function getAll() { return Department::find()->asArray()->all(); }
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
<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
/** * 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 actionList() { $model = Department::find()->all(); return $this->renderPartial('list', ['model' => $model]); }
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">
public function actionAppointment() { $listDepartment = ArrayHelper::map(Department::find()->where('enabled<>0')->all(), 'id', 'name'); $listChannel = ArrayHelper::map(Channel::find()->where('enabled<>0')->all(), 'id', 'name'); $listDoctor = ArrayHelper::map(Doctor::find()->where('enabled<>0')->all(), 'id', 'name'); $listUser = ArrayHelper::map(User::find()->where('enabled<>0')->all(), 'id', 'username'); return $this->render('appointment', ['model' => new Record(), 'listDepartment' => $listDepartment, 'listChannel' => $listChannel, 'listDoctor' => $listDoctor, 'listUser' => $listUser]); }
/** * @param UpdateUserRequest $request * @param $id * @return \Illuminate\Http\RedirectResponse|\Illuminate\Routing\Redirector */ public function update(UpdateUserRequest $request, $id) { $user = $this->user->find($id); // Get all attribute from the request. $attributes = $request->all(); if ($attributes['password'] == '') { unset($attributes['password']); } // Get a copy of the attributes that we will modify to save for a replay. $replayAtt = $attributes; // Add the id of the current user for the replay action. $replayAtt["id"] = $id; // Create log entry with replay data. $tmp = Audit::log(Auth::user()->id, trans('admin/users/general.audit-log.category'), trans('admin/users/general.audit-log.msg-update', ['username' => $user->username]), $replayAtt, "App\\Http\\Controllers\\UsersController::ParseUpdateAuditLog", "admin.users.replay-edit"); if (!$user->isEditable()) { abort(403); } if (array_key_exists('selected_roles', $attributes)) { $attributes['role'] = explode(",", $attributes['selected_roles']); } $user->update($attributes); /* * Assign the new user's active cluster */ $user->activateCluster($attributes['activeCluster']); /* * Assign the department */ $department = Department::find($attributes['department']); $department->users()->save($user); $user->save(); alert()->success(trans('admin/users/general.status.updated')); return redirect('/admin/users'); }
protected function deptDataProvider() { $dp = new ActiveDataProvider(['query' => Department::find(), 'sort' => false]); return $dp; }
/** * 查询听课列表 * @author FuRongxin * @date 2016-05-17 * @version 2.1 * @param \Illuminate\Http\Request $request 听课查询请求 * @return \Illuminate\Http\Response 听课列表 */ public function search(Request $request) { $departments = Department::where('dw', '<>', '')->whereLx('1')->whereZt(config('constants.status.enable'))->orderBy('dw')->get(); $title = session('year') . '年度' . Term::find(session('term'))->mc . '学期' . '听课查询'; $courses = []; if ($request->isMethod('post')) { $this->validate($request, ['department' => 'required', 'week' => 'required', 'class' => 'required']); $input = $request->all(); $query = Timetable::with(['classroom' => function ($query) { $query->select('jsh', 'mc'); }, 'user' => function ($query) { $query->select('jsgh', 'xm', 'zc'); }, 'user.position', 'campus'])->whereNd(session('year'))->whereXq(session('term'))->whereZc($input['week'])->where('ksj', '<=', $input['class'])->where('jsj', '>=', $input['class']); $kcxhs = Mjcourse::whereNd(session('year'))->whereXq(session('term'))->whereKkxy($input['department'])->select('kcxh')->distinct()->get()->pluck('kcxh'); $query = $query->whereIn('kcxh', $kcxhs); $results = $query->get(); foreach ($results as $result) { $courses[] = ['kcmc' => Course::find(Helper::getCno($result->kcxh))->kcmc, 'xqh' => $result->campus->mc, 'jsmc' => count($result->classroom) ? $result->classroom->mc : '', 'kkxy' => count($result->mjcourse) ? $result->mjcourse->college->mc : '', 'xy' => count($result->mjcourse) ? $result->mjcourse->major->college->mc : '', 'zy' => count($result->mjcourse) ? $result->mjcourse->major->mc : '', 'nj' => count($result->mjcourse) ? $result->mjcourse->nj : '', 'rs' => Selcourse::whereNd(session('year'))->whereXq(session('term'))->whereKcxh($result->kcxh)->count(), 'jsxm' => $result->user->xm, 'jszc' => $result->user->position->mc]; } $department_name = 'all' == $input['department'] ? '所有学院' : Department::find($input['department'])->mc; $week_name = 'all' == $input['week'] ? '所有周次' : '星期' . config('constants.week.' . $input['week']); $class_name = '第 ' . $input['class'] . ' 节课'; $subtitle = '查询条件:' . $department_name . $week_name . $class_name; } return view('timetable.search', compact('title', 'departments', 'courses', 'subtitle')); }
?> <div class="box box-info"> <div class="box-header with-border"> <?php $form = ActiveForm::begin(); ?> <?php $dataCategory = ArrayHelper::map(Computer::find()->select(['id', 'concat("COMID: ",id, " หมายเลข: " ,code) as name'])->asArray()->all(), 'id', 'name'); echo $form->field($model, 'com_id')->widget(Select2::classname(), ['data' => $dataCategory, 'options' => ['placeholder' => '----- อุปกรณ์คอมพิวเตอร์ -------']]); ?> <?php $dataCategory = ArrayHelper::map(Department::find()->asArray()->all(), 'id', 'name'); echo $form->field($model, 'dep_id')->widget(Select2::classname(), ['data' => $dataCategory, 'options' => ['placeholder' => '----- เลือกฝ่าย -------']]); ?> <?php echo $form->field($model, 'datein')->widget(DateControl::classname(), ['type' => DateControl::FORMAT_DATE]); ?> <?php echo $form->field($model, 'dateout')->widget(DateControl::classname(), ['value' => '20-11-2015', 'type' => DateControl::FORMAT_DATE, 'displayFormat' => 'php: d-m-yy']); ?> <div class="form-group"> <?php echo Html::submitButton($model->isNewRecord ? 'Create' : 'Update', ['class' => $model->isNewRecord ? 'btn btn-success' : 'btn btn-primary']);
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 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); }
/** * 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; }