/** * Finds the Division model based on its primary key value. * If the model is not found, a 404 HTTP exception will be thrown. * @param integer $id * @return Division the loaded model * @throws NotFoundHttpException if the model cannot be found */ protected function findModel($id) { if (($model = Division::findOne($id)) !== null) { return $model; } else { throw new NotFoundHttpException('The requested page does not exist.'); } }
/** * Show the form for editing the specified resource. * * @param int $id * * @return mixed */ public function edit($id) { $fixture = Fixture::findOrFail($id); $divisions = Division::all(); $teams = Team::all(); $venues = Venue::all(); return view('admin.data-management.fixtures.edit', compact('fixture', 'divisions', 'teams', 'venues')); }
public function search($params) { $query = Division::find(); $dataProvider = new ActiveDataProvider(['query' => $query]); if (!($this->load($params) && $this->validate())) { return $dataProvider; } $query->andFilterWhere(['id' => $this->id, 'active' => $this->active, 'order' => $this->order]); $query->andFilterWhere(['like', 'name', $this->name]); return $dataProvider; }
public function create($id, $tech_number = 1) { if (Auth::user()->can('create-service')) { $data['title'] = $tech_number == 1 ? "Create Service ~ " . $tech_number . " technician" : "Create Service ~ " . $tech_number . " technicians"; $data['companies'] = Company::all(); $data['company_id'] = $id; $data['contacts'] = CompanyPersonController::API()->all(["where" => ["company_person.company_id|=|" . $id], "order" => ["people.last_name|ASC", "people.first_name|ASC"], "paginate" => "false"]); $data['technicians'] = CompanyPersonController::API()->all(["where" => ["company_person.company_id|=|" . ELETTRIC80_COMPANY_ID], "order" => ["people.last_name|ASC", "people.first_name|ASC"], "paginate" => "false"]); $data['divisions'] = Division::orderBy("name")->get(); $data['hotels'] = Hotel::where('company_id', $id)->orderBy("name")->get(); $tech_number = $tech_number < 1 ? 1 : $tech_number; $tech_number = $tech_number > 5 ? 5 : $tech_number; $data['technician_number'] = $tech_number; foreach ($data['hotels'] as &$hotel) { $hotel['name_address'] = $hotel['name'] . " @ " . $hotel['address']; } return view('services/create', $data); } else { return redirect()->back()->withErrors(['Access denied to service create page']); } }
public static function getMap() { return ArrayHelper::map(Division::find()->where(['active' => 1])->orderBy('ord')->asArray()->all(), 'id', 'name'); }
/** * Remove the specified resource from storage. * * @param int $id * * @return mixed */ public function destroy($id) { $canBeDeleted = empty(Division::find($id)->fixtures->toArray()); if ($canBeDeleted) { Division::destroy($id); \Flash::success('Division deleted!'); } else { \Flash::error('Cannot delete because they are existing fixtures in this division.'); } return redirect('admin/data-management/divisions'); }
use app\models\Division; /** * @var yii\web\View $this * @var yii\data\ActiveDataProvider $dataProvider * @var app\models\search\StudentSearch $searchModel */ $dataProvider->pagination->pageSize = Yii::$app->user->rowsPerPage; $this->registerJsFile('/js/student-index.js', ['\\app\\assets\\AppAsset']); $this->registerCssFile('/css/student-index.css', ['\\app\\assets\\AppAsset']); $this->title = 'Students'; $this->params['breadcrumbs'][] = $this->title; $columns = [['class' => 'yii\\grid\\SerialColumn'], ['class' => ToggleColumn::className(), 'attribute' => 'active', 'filter' => ['1' => 'Y', '0' => 'N', '' => 'All'], 'headerOptions' => ['style' => 'width:20px'], 'contentOptions' => ['class' => 'text-center']], ['attribute' => 'gender', 'class' => EditableColumn::className(), 'url' => 'editable', 'contentOptions' => ['class' => 'text-center', 'nowrap' => true], 'headerOptions' => ['class' => 'text-center', 'style' => 'width:20px'], 'type' => 'select', 'filter' => ['M' => 'M', 'F' => 'F', '' => 'All'], 'editableOptions' => ['showbuttons' => false, 'mode' => 'inline', 'source' => '[{"M": "M"}, {"F": "F"}]', 'value' => function ($model) { return $model->gender; }]], ['attribute' => 'fname', 'contentOptions' => ['nowrap' => true], 'class' => EditableColumn::className(), 'url' => 'editable', 'editableOptions' => ['mode' => 'inline']], ['attribute' => 'lname', 'contentOptions' => ['nowrap' => true], 'class' => EditableColumn::className(), 'url' => 'editable', 'editableOptions' => ['mode' => 'inline']], ['value' => 'division.name', 'header' => 'Div', 'attribute' => 'division_id', 'headerOptions' => ['class' => 'text-center', 'style' => 'width:20px'], 'contentOptions' => ['class' => 'text-center'], 'filter' => Division::getMap() + ['' => 'All'], 'class' => EditableColumn::className(), 'url' => 'editable', 'type' => 'select', 'editableOptions' => ['showbuttons' => false, 'value' => function ($model) { return $model->division_id; }, 'source' => Json::encode(Division::getMap()), 'mode' => 'inline']], ['value' => 'handAnchor.name', 'attribute' => 'handAnchorId', 'header' => 'Anchor', 'headerOptions' => ['class' => 'text-center'], 'contentOptions' => ['nowrap' => true], 'class' => EditableColumn::className(), 'url' => 'editable', 'type' => 'select', 'editableOptions' => ['showbuttons' => false, 'mode' => 'inline', 'value' => function ($model) { return $model->affiliation->hand_anchor_id; }, 'source' => function ($model) { return Url::to(['/student/available-classes', 'id' => $model->id, 'type' => 'hand']); }]], ['value' => 'dobAndAge', 'attribute' => 'dob', 'header' => 'DoB & Age', 'contentOptions' => ['nowrap' => true, 'style' => 'width:100px'], 'class' => EditableColumn::className(), 'url' => 'editable', 'type' => 'combodate', 'editableOptions' => ['value' => function ($model) { return $model->dob; }, 'format' => 'YYYY-MM-DD', 'viewformat' => 'M/D', 'template' => 'M / D / YYYY']], ['attribute' => 'belt_size', 'headerOptions' => ['style' => 'width:20px'], 'contentOptions' => ['class' => 'text-center'], 'class' => EditableColumn::className(), 'filter' => Student::getGiSizeMap() + ['' => 'All'], 'url' => 'editable', 'type' => 'select', 'editableOptions' => ['mode' => 'inline', 'showbuttons' => false, 'value' => function ($model) { return $model->belt_size; }, 'source' => Json::encode(Student::getGiSizeMap())]], ['attribute' => 'bestPhoneNumber', 'contentOptions' => ['nowrap' => true], 'class' => EditableColumn::className(), 'url' => 'editable', 'editableOptions' => ['mode' => 'inline']], ['attribute' => 'sparAuth', 'value' => 'sparAuthJson', 'contentOptions' => ['class' => 'text-center'], 'headerOptions' => ['style' => 'width:20px'], 'class' => EditableColumn::className(), 'url' => 'editable', 'type' => 'checklist', 'editableOptions' => ['value' => function ($model) { return $model->sparAuthJson; }, 'display' => new JsExpression("function(value, sourceData)\n { \n var icon = 'remove';\n //console.log(value, sourceData);\n if(value instanceof Array && value[0] !== '')\n {\n \$.each(value, function(i, v)\n {\n if (v.toLowerCase() === 'a')\n {\n icon = 'ok';\n return false;\n }\n else\n {\n icon = 'tasks';\n }\n });\n }\n \$(this).html('<span class=\"glyphicon glyphicon-' + icon + '\"></span>');\n }"), 'mode' => 'pop', 'source' => Json::encode(Student::getSparAuthList())]], ['attribute' => 'rank.name', 'contentOptions' => ['nowrap' => true]], ['attribute' => 'grappleAuth', 'value' => 'grappleAuthJson', 'contentOptions' => ['class' => 'text-center'], 'headerOptions' => ['style' => 'width:20px'], 'class' => EditableColumn::className(), 'url' => 'editable', 'type' => 'checklist', 'editableOptions' => ['value' => function ($model) { return $model->grappleAuthJson; }, 'display' => new JsExpression("function(value, sourceData)\n {\n var icon = 'remove';\n //console.log(value, sourceData);\n if(value instanceof Array && value[0] !== '')\n {\n \$.each(value, function(i, v)\n {\n if (v.toLowerCase() === 'a')\n {\n icon = 'ok';\n return false;\n }\n else\n {\n console.log(v);\n icon = 'tasks';\n }\n });\n }\n \$(this).html('<span class=\"glyphicon glyphicon-' + icon + '\"></span>');\n }"), 'mode' => 'pop', 'source' => Json::encode(Student::getGrappleAuthList())]], ['class' => 'yii\\grid\\ActionColumn', 'contentOptions' => ['nowrap' => true], 'template' => '{view} {update}' . (Yii::$app->user->can('deleteStudent') ? ' {delete}' : '')]]; ?> <div class="student-index">
/** * @return \yii\db\ActiveQuery relation */ public function getDivision() { return $this->hasOne(Division::className(), ['id' => 'division_id']); }
public static function workingTimeData($days, $type) { $result = null; if ($type == "division") { $grouping = Division::whereIn('id', [LGV_DIVISION_ID, PLC_DIVISION_ID, PC_DIVISION_ID, BEMA_DIVISION_ID, FIELD_DIVISION_ID, SPARE_PARTS_DIVISION_ID, RELIABILITY_DIVISION_ID, OTHERS_DIVISION_ID])->orderBy("name")->get(); } elseif ($type == "priority") { $grouping = Priority::orderBy("name")->get(); } elseif ($type == "level") { $grouping = Level::orderBy("name")->get(); } elseif ($type == "company") { $grouping = Company::orderBy("name")->get(); } elseif ($type == "assignee") { $grouping = CompanyPerson::select("company_person.*", "people.first_name", "people.last_name")->leftJoin('people', 'company_person.person_id', '=', 'people.id')->where('company_person.company_id', '=', ELETTRIC80_COMPANY_ID)->orderBy("last_name")->get(); foreach ($grouping as $group) { $group->name = $group->last_name . " " . $group->first_name; } } if (isset($grouping)) { foreach ($grouping as $index => $group) { for ($i = 0; $i < 50; $i++) { $query = "SELECT SUM(resolution_time) as sum, COUNT(*) as ticket_count, AVG(resolution_time) as average, DATE_SUB(NOW(), INTERVAL " . $days * ($i + 1) . " day) as date\n FROM (\n SELECT before.ticket_id, SUM(\n TIMESTAMPDIFF(SECOND, \n GREATEST(DATE_SUB(NOW(), INTERVAL " . $days * ($i + 1) . " day), before.created_at), \n LEAST(DATE_SUB(NOW(), INTERVAL " . $days * $i . " day), IFNULL(after.created_at,NOW()))\n )\n )/3600 as resolution_time\n FROM tickets_history as `before`\n LEFT JOIN tickets_history as `after` ON before.id = after.previous_id\n INNER JOIN tickets ON tickets.id = before.ticket_id \n WHERE (\n after.status_id IN (" . TICKET_NEW_STATUS_ID . "," . TICKET_IN_PROGRESS_STATUS_ID . ",\n " . TICKET_REQUESTING_STATUS_ID . "," . TICKET_SOLVED_STATUS_ID . "," . TICKET_CLOSED_STATUS_ID . ")\n OR \n (before.status_id IN (" . TICKET_NEW_STATUS_ID . "," . TICKET_IN_PROGRESS_STATUS_ID . ",\n " . TICKET_REQUESTING_STATUS_ID . ") AND after.id IS NULL)\n )\n AND tickets.deleted_at IS NULL\n AND tickets." . $type . "_id = {$group->id}\n AND TIMESTAMPDIFF(SECOND, \n GREATEST(before.created_at,DATE_SUB(NOW(), INTERVAL " . $days * ($i + 1) . " day)), \n LEAST(DATE_SUB(NOW(), INTERVAL " . $days * $i . " day), IFNULL(after.created_at,NOW()))) > 0\n GROUP BY before.ticket_id\n ) as " . $type[0] . "_{$index} "; $temp = DB::select(DB::raw($query)); foreach ($temp[0] as $key => $value) { if ($key != "date") { $div_key = str_replace(" ", "_", $group->name); if ($i == 0) { $result[$div_key][$key]['current'] = round($temp[0]->{$key}, 2); } if ($i == 1) { $result[$div_key][$key]['previous'] = round($temp[0]->{$key}, 2); } $result[$div_key][$key]['historical'][$temp[0]->date] = $temp[0]->{$key}; } } } } } return $result; }
$options = []; $options['checkNameUrl'] = Url::to(['/student/check-name']); $options['getClassesUrl'] = Url::to(['/class/create-student-hand-anchors']); $this->registerJs("var options = " . JSON::encode($options) . ";", $this::POS_HEAD, 'my-options'); $this->registerJsFile('/js/student-create.js', ['\\app\\assets\\AppAsset']); $this->title = 'Create Student'; $this->params['breadcrumbs'][] = ['label' => 'Students', 'url' => ['index']]; $this->params['breadcrumbs'][] = $this->title; ?> <div class="student-create"> <h1><?php echo Html::encode($this->title); ?> </h1> <?php $form = ActiveForm::begin(); echo Form::widget(['model' => $model, 'form' => $form, 'columns' => 3, 'attributes' => ['gender' => ['type' => Form::INPUT_DROPDOWN_LIST, 'options' => [], 'items' => ['M' => 'Male', 'F' => 'Female']], 'fname' => ['type' => Form::INPUT_TEXT, 'options' => []], 'lname' => ['type' => Form::INPUT_TEXT, 'options' => []], 'dob' => ['type' => Form::INPUT_WIDGET, 'widgetClass' => '\\kartik\\datecontrol\\DateControl', 'options' => ['widgetClass' => '\\yii\\widgets\\MaskedInput', 'options' => ['mask' => '99/99/9999']], 'hint' => 'Use mm/dd/yyyy format'], 'bestPhone' => ['type' => Form::INPUT_WIDGET, 'widgetClass' => '\\yii\\widgets\\MaskedInput', 'options' => ['mask' => '(999) 999 9999', 'value' => '', 'name' => 'StudentPhone[number]']], 'belt_size' => ['type' => Form::INPUT_DROPDOWN_LIST, 'items' => Student::getGiSizeMap()], 'division_id' => ['type' => Form::INPUT_DROPDOWN_LIST, 'options' => [], 'items' => [null => ''] + Division::getMap()], 'handAnchor' => ['type' => Form::INPUT_DROPDOWN_LIST, 'options' => ['value' => 0, 'name' => 'Affiliation[hand_anchor_id]'], 'items' => [null => '']]]]); ?> <div class="form-group"> <!--input type="hidden" name="action" id="action" value="" /--> <?php echo Html::submitButton('Save and Exit', ['class' => 'btn btn-success', 'icon' => 'floppy-disk']); ?> <?php echo Html::submitButton('Save and Add Another', ['name' => 'then-add', 'class' => 'btn btn-success', 'icon' => 'floppy-disk']); ?> <?php echo Html::a('Cancel', Url::to(['/student']), ['class' => 'btn btn-primary', 'icon' => 'remove']); ?> </div> </div>
/** * @return string */ public static function divisionClassName() { return Division::className(); }
public function edit($id) { if (Auth::user()->can('update-ticket')) { $data['ticket'] = self::API()->find(['id' => $id]); $temp = DB::table("ticket_links")->where("ticket_id", "=", $id)->get(); foreach ($temp as $elem) { $links[] = $elem->linked_ticket_id; } $data['ticket']['linked_tickets_id'] = isset($links) ? implode(",", $links) : ''; $data['companies'] = Company::where('id', '!=', ELETTRIC80_COMPANY_ID)->orderBy('name')->get(); $data['priorities'] = Priority::orderBy('id', 'desc')->get(); $data['divisions'] = Division::orderBy('name')->get(); $data['job_types'] = JobType::orderBy('name')->get(); $data['levels'] = Level::orderBy('name')->get(); $data['assignees'] = CompanyPersonController::API()->all(["where" => ["companies.id|=|" . ELETTRIC80_COMPANY_ID], "order" => ["people.last_name|ASC", "people.first_name|ASC"], "paginate" => "false"]); $data['companies'] = CompaniesController::API()->all(['where' => ['companies.id|!=|' . ELETTRIC80_COMPANY_ID], 'order' => ['companies.name|ASC'], 'paginate' => 'false']); $data['tags'] = ""; foreach ($data['ticket']->tags as $tag) { $data['tags'] .= $tag->name . ","; } $is_draft = $data['ticket']->status_id == TICKET_DRAFT_STATUS_ID ? true : false; $data['title'] = "Edit Ticket #" . $id; return view('tickets/edit', $data); } else { return redirect()->back()->withErrors(['Access denied to tickets edit page']); } }
public function run() { Model::unguard(); DB::statement('SET FOREIGN_KEY_CHECKS=0;'); $folderpath = base_path() . '/database/seeds/seed_files/'; $folders = File::directories($folderpath); $latest = '11232015'; foreach ($folders as $value) { $_dir = explode("/", str_replace('\\', '/', $value)); $cnt = count($_dir); $name = $_dir[$cnt - 1]; $latest_date = DateTime::createFromFormat('mdY', $latest); $now = DateTime::createFromFormat('mdY', $name); if ($now > $latest_date) { $latest = $name; } } $filePath = $folderpath . $latest . '/Masterfile.xlsx'; $reader = ReaderFactory::create(Type::XLSX); // for XLSX files $reader->open($filePath); // DB::table('divisions')->truncate(); // DB::table('categories')->truncate(); // DB::table('sub_categories')->truncate(); // DB::table('brands')->truncate(); // DB::table('items')->truncate(); foreach ($reader->getSheetIterator() as $sheet) { if ($sheet->getName() == 'Items') { $cnt = 0; Item::where('active', 1)->update(['active' => 0, 'cleared' => 0]); foreach ($sheet->getRowIterator() as $row) { if ($row[0] != '') { if ($cnt > 0) { $division = Division::firstOrCreate(['division' => strtoupper($row[9])]); $category = Category::firstOrCreate(['category' => strtoupper($row[1]), 'category_long' => strtoupper($row[0])]); $sub_category = SubCategory::firstOrCreate(['category_id' => $category->id, 'sub_category' => strtoupper($row[7])]); $brand = Brand::firstOrCreate(['brand' => strtoupper($row[8])]); $itemExist = Item::where('sku_code', strtoupper($row[2]))->first(); if (empty($itemExist)) { $item = Item::firstOrCreate(['sku_code' => trim($row[2]), 'barcode' => $row[3], 'description' => strtoupper($row[4]), 'description_long' => strtoupper($row[5]), 'conversion' => trim($row[6]), 'lpbt' => trim($row[10]), 'division_id' => $division->id, 'category_id' => $category->id, 'sub_category_id' => $sub_category->id, 'brand_id' => $brand->id, 'active' => 1]); } else { $itemExist->sku_code = trim($row[2]); $itemExist->barcode = $row[3]; $itemExist->description = strtoupper($row[4]); $itemExist->description_long = strtoupper($row[5]); $itemExist->conversion = trim($row[6]); $itemExist->lpbt = trim($row[10]); $itemExist->division_id = $division->id; $itemExist->category_id = $category->id; $itemExist->sub_category_id = $sub_category->id; $itemExist->brand_id = $brand->id; $itemExist->active = 1; $itemExist->save(); } } $cnt++; } } } } $reader->close(); DB::statement('SET FOREIGN_KEY_CHECKS=1;'); Model::reguard(); }
<td><?php echo $form->field($model, 'fname')->textInput(['maxlength' => 45]); ?> </td> <td><?php echo $form->field($model, 'lname')->textInput(['maxlength' => 45]); ?> </td> </tr> <tr> <td colspan="2"><?php echo $form->field($model, 'belt_size')->dropDownList(Student::getGiSizeMap()); ?> </td> <td colspan="2"><?php echo $form->field($model, 'division_id')->dropDownList(Division::getMap()); ?> </td> </tr> <tr> <td colspan="2"><?php echo $form->field($model->affiliation, 'hand_anchor_id')->dropDownList(ArrayHelper::map($model->handAnchors, 'id', 'fullName')); ?> </td> <td colspan="2"><?php echo $form->field($model->affiliation, 'weapon_anchor_id')->dropDownList(ArrayHelper::map([null] + $model->weaponAnchors, 'id', 'fullName')); ?> </td> </tr> <tr> <td colspan="4"><?php
/** * Update the specified resource in storage. * * @param \Illuminate\Http\Request $request * @param int $id * @return \Illuminate\Http\Response */ public function update(Request $request, $id) { $this->validate($request, ['sku_code' => 'required', 'description' => 'required', 'conversion' => 'required|numeric', 'lpbt' => 'required|numeric', 'division' => 'required', 'category' => 'required', 'sub_category' => 'required', 'brand_id' => 'required']); $item = Item::findOrFail($id); $divname = $request->division; $divid = Division::where('division', '=', $divname)->first(); $divname = $divid->id; $catname = $request->category; $catid = Category::where('category', '=', $catname)->first(); $catname = $catid->id; $scatname = $request->sub_category; $scatid = SubCategory::where('sub_category', '=', $scatname)->first(); $scatname = $scatid->id; $item->sku_code = $request->sku_code; $item->description = $request->description; $item->conversion = $request->conversion; $item->lpbt = $request->lpbt; $item->division_id = $divname; $item->category_id = $catname; $item->sub_category_id = $scatname; $item->brand_id = $request->brand_id; $item->description_long = $request->description_long; $item->barcode = $request->barcode; $item->active = $request->status; $item->update(); Session::flash('flash_class', 'alert-success'); Session::flash('flash_message', 'Item successfully updated.'); return redirect()->route("item.index"); }
/** * @return \yii\db\ActiveQuery */ public function getDivisions() { return $this->hasMany(Division::className(), ['id' => 'division_id'])->viaTable('class_division', ['class_id' => 'id']); }
public function edit($id) { $company_person = CompanyPerson::find($id); if (Auth::user()->can('update-contact') || Auth::user()->active_contact->id == $id && Auth::user()->can('update-own-contact') || !$company_person->isE80() && Auth::user()->can('update-customer-contact')) { $data['title'] = "Edit Contact"; $data['titles'] = Title::orderBy("name")->get(); $data['departments'] = Department::orderBy("name")->get(); $data['companies'] = Company::orderBy("name")->get(); $data['contact'] = CompanyPerson::find($id); $data['divisions'] = Division::orderBy("name")->get(); $data['groups'] = Group::where("group_type_id", "=", $company_person->group_type_id)->orderBy("name")->get(); return view('company_person/edit', $data); } else { return redirect()->back()->withErrors(['Access denied to contacts edit page']); } }