public function run()
 {
     Equipment::create(['title' => '2012 American Augers DD-10 Directional Drill', 'description' => '100,000 pound drill rig has operators cabin with heat and A/C and wireline drive chuck, includes 8 empty rod boxes.', 'status' => 'available']);
     Equipment::create(['title' => '2009 Vermeer D100x120 Series II Directional Drill', 'description' => 'Unit is equipped with a 200 GPM Kerr pump, FSII drive chuck, does not include any drill rod but has 5 empty baskets.', 'status' => 'sold']);
     Equipment::create(['title' => '2008 Vermeer D100x120 Series II Directional Drill', 'description' => 'Used D100x120 Series II has been inspected by a certified service technician and is in good condition.', 'status' => 'sold']);
     //... add more starter equipment
 }
 public function update($id, UpdateEquipmentRequest $request)
 {
     $equipment = Equipment::find($id);
     $equipment->update($request->all());
     $equipment->warranty_expiration = $request->get('warranty_expiration') ? Carbon::createFromFormat('m/d/Y', $request->get('warranty_expiration')) : null;
     $equipment->save();
     return redirect()->route('companies.show', $equipment->company_id)->with('successes', ['equipment updated successfully']);
 }
 public function updateEquipment(Request $request, $id)
 {
     $equipment = Equipment::find($id);
     $equipment->title = $request->input('title');
     $equipment->description = $request->input('description');
     $equipment->status = $request->input('status');
     $equipment->save();
     return response()->json($equipment);
 }
 public function searhEquipment($type, $name = '')
 {
     $equipments = Equipment::type($type);
     if (!empty($name)) {
         $equipments->name($name);
     }
     $equipmentItems = $equipments->get();
     echo $equipmentItems;
 }
 /**
  * Creates data provider instance with search query applied
  *
  * @param array $params
  *
  * @return ActiveDataProvider
  */
 public function search($params)
 {
     $query = Equipment::find();
     $dataProvider = new ActiveDataProvider(['query' => $query]);
     if (!($this->load($params) && $this->validate())) {
         return $dataProvider;
     }
     $query->andFilterWhere(['id' => $this->id, 'status_id' => $this->status_id, 'room_id' => $this->room_id, 'available' => $this->available, 'type_id' => $this->type_id]);
     $query->andFilterWhere(['like', 'inventory', $this->inventory])->andFilterWhere(['like', 'description', $this->description])->andFilterWhere(['like', 'serial_number', $this->serial_number])->andFilterWhere(['like', 'location', $this->location]);
     return $dataProvider;
 }
 /**
  * Run the database seeds.
  *
  * @return void
  */
 public function run()
 {
     // DB::table('equipment')->delete();
     Equipment::create(array('equipmenttype' => 'PC'));
     Equipment::create(array('equipmenttype' => 'NB'));
     Equipment::create(array('equipmenttype' => 'Mouse'));
     Equipment::create(array('equipmenttype' => 'Bag'));
     Equipment::create(array('equipmenttype' => 'Charger'));
     Equipment::create(array('equipmenttype' => 'Monitor'));
     Equipment::create(array('equipmenttype' => 'Keyboard'));
 }
示例#7
0
 public function getDataSet($postData, $dcTable, $facility_id, $occur_date, $properties)
 {
     $equip_group = $postData['EquipmentGroup'];
     $equip_type = $postData['CodeEquipmentType'];
     $equipment = Equipment::getTableName();
     $where = ["{$equipment}.FACILITY_ID" => $facility_id];
     if ($equip_group > 0) {
         $where["{$equipment}.EQUIPMENT_GROUP"] = $equip_group;
     }
     if ($equip_type > 0) {
         $where["{$equipment}.EQUIPMENT_TYPE"] = $equip_type;
     }
     //      	\DB::enableQueryLog();
     $dataSet = Equipment::where($where)->leftJoin($dcTable, function ($join) use($equipment, $dcTable, $occur_date) {
         $join->on("{$equipment}.ID", '=', "{$dcTable}.EQUIPMENT_ID");
         $join->where("{$dcTable}.OCCUR_DATE", '=', $occur_date);
     })->select("{$equipment}.ID as DT_RowId", "{$equipment}.NAME as {$dcTable}", "{$equipment}.FUEL_TYPE", "{$equipment}.GHG_REL_TYPE", "{$dcTable}.*", "{$equipment}.ID as EQUIPMENT_ID")->orderBy("{$dcTable}")->get();
     //  		\Log::info(\DB::getQueryLog());
     return ['dataSet' => $dataSet];
 }
示例#8
0
 /**
  * Creates data provider instance with search query applied
  *
  * @param array $params
  *
  * @return ActiveDataProvider
  */
 public function search($params)
 {
     $query = Equipment::find();
     $query->joinWith(['equipmentStatus', 'location.room', 'location', 'equipmentType']);
     $dataProvider = new ActiveDataProvider(['query' => $query]);
     $dataProvider->sort->attributes['equipmentStatus'] = ['asc' => ['equipment_status.status' => SORT_ASC], 'desc' => ['equipment_status.status' => SORT_DESC]];
     $dataProvider->sort->attributes['room'] = ['asc' => ['room.name' => SORT_ASC], 'desc' => ['room.name' => SORT_DESC]];
     $dataProvider->sort->attributes['location'] = ['asc' => ['location.location' => SORT_ASC], 'desc' => ['location.location' => SORT_DESC]];
     $dataProvider->sort->attributes['equipmentType'] = ['asc' => ['equipment_type.name' => SORT_ASC], 'desc' => ['equipment_type.name' => SORT_DESC]];
     $this->load($params);
     if (!($this->load($params) && $this->validate())) {
         return $dataProvider;
     }
     /* 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, 'equipment.available' => $this->available]);
     $query->andFilterWhere(['like', 'inventory', $this->inventory])->andFilterWhere(['like', 'equipment_status.status', $this->equipmentStatus])->andFilterWhere(['like', 'room.name', $this->room])->andFilterWhere(['like', 'location.location', $this->location])->andFilterWhere(['like', 'equipment_type.name', $this->equipmentType])->andFilterWhere(['like', 'description', $this->description])->andFilterWhere(['like', 'serial_number', $this->serial_number]);
     return $dataProvider;
 }
示例#9
0
 /**
  * @return \yii\db\ActiveQuery
  */
 public function getEquipments()
 {
     return $this->hasMany(Equipment::className(), ['status_id' => 'id']);
 }
示例#10
0
 /**
  * @return \yii\db\ActiveQuery
  */
 public function getEquipment()
 {
     return $this->hasOne(Equipment::className(), ['id' => 'equipment_id']);
 }
示例#11
0
 public function postEquipmnt(FormEquipmenteAdminRequest $request)
 {
     if (!empty($request)) {
         $data = $request->all();
         $data['flagactive'] = $request->get('flagactive', 1);
         if ($request->id) {
             $obj = Equipment::find($request->id);
             $obj->update($data);
         } else {
             $obj = Equipment::create($data);
         }
         return array('msg' => 'ok', 'state' => 1, 'data' => null);
     }
     return array('msg' => 'Error al guardar el modelo', 'state' => 0, 'data' => null);
 }
示例#12
0
    <!--?= $form->field($model, 'equipment_id')->dropDownList(
			ArrayHelper::map(
				Equipment::find()->all(),
				'id',
				'inventory'
			),
			[
				'prompt' => 'Selecciona un Número de Inventario...',				
			]
		)
	?-->

	<?php 
$inventoryData = [];
if (!empty($model->location_id)) {
    $inventoryData = ArrayHelper::map(Equipment::find()->where(['id' => $model->equipment_id])->all(), 'id', 'nameWithInventory');
}
?>
	
	<?php 
echo $form->field($model, 'equipment_id')->dropDownList($inventoryData, ['prompt' => 'Selecciona un Número de Inventario...']);
?>
	
    <?php 
echo $form->field($model, 'purpose')->textarea(['maxlength' => 170, 'onkeyup' => 'javascript:this.value=this.value.toUpperCase();']);
?>

	<?php 
echo $form->field($model, 'start_time')->widget(TimePicker::classname(), ['options' => ['readonly' => true], 'pluginOptions' => ['minuteStep' => 1, 'showMeridian' => false, 'showSeconds' => true, 'defaultTime' => '0']])->hint('* Sólo para reservaciones.');
//VarDumper::dump($model->room);
?>
示例#13
0
 public static function getObjects()
 {
     return Equipment::all();
 }
 /**
  * Finds the Equipment model based on its primary key value.
  * If the model is not found, a 404 HTTP exception will be thrown.
  * @param string $id
  * @return Equipment the loaded model
  * @throws NotFoundHttpException if the model cannot be found
  */
 protected function findModel($id)
 {
     if (($model = Equipment::findOne($id)) !== null) {
         return $model;
     } else {
         throw new NotFoundHttpException('The requested page does not exist.');
     }
 }
示例#15
0
				// alert(data);
				$("#incident-equipment_id").val(data).trigger("change");
			})',
		]
	) ?-->
	
	<!--?= $form->field($model, 'equipment_id')->textInput([
		'maxlength'=>true,
		'onchange' => '$.post("'.Yii::$app->urlManager->createUrl('incident/get-equipment-information?inventory=').'"+$(this).val(), function(data){
			// $("#incident-equipment_id").html(data);
			$("#incident-equipment_id").val(data);
		})',
	]) ?-->
	
	<?php 
echo $form->field($model, 'equipment_id')->widget(Select2::classname(), ['data' => ArrayHelper::map(Equipment::find()->all(), 'id', 'inventory'), 'options' => ['placeholder' => 'Ingresa el número de inventario...', 'onchange' => '$.post("' . Yii::$app->urlManager->createUrl('incident/get-equipment-information?id=') . '"+$(this).val(), function(data){
				// $("#incident-equipment_id").html(data);
				// $("#incident-description").html(data);
				var equipment = JSON.parse(data);
				$("#incident-room_id").val(equipment.room_id);
				$.post("' . Yii::$app->urlManager->createUrl('incident/list-locations?id=') . '"+$("#incident-room_id").val(), function(data){
					$("#incident-location_id").html(data);
					$("#incident-location_id").val(equipment.location_id);
					$.post("' . Yii::$app->urlManager->createUrl('incident/list-equipment-types?id=') . '"+$("#incident-location_id").val(), function(data){
						$("#incident-equipment_type_id").html(data);
						$("#incident-equipment_type_id").val(equipment.equipment_id);
					})
				})
			})'], 'pluginOptions' => ['allowClear' => true]]);
?>
	
 public function actionShowInventory($id)
 {
     $equipments = Equipment::find()->where(['location_id' => $id])->all();
     //echo "<option value=''>".Yii::t('app', 'Selecciona un Número de Inventario...')."</option>";
     foreach ($equipments as $equipment) {
         echo "<option value='" . $equipment->id . "'>" . $equipment->nameWithInventory . "</option>";
     }
 }
示例#17
0
 public function actionGetEquipmentInformation($id)
 {
     $equipment = Equipment::find()->where(['id' => $id])->one();
     if (empty($equipment)) {
         throw new NotFoundHttpException('The requested page does not exist.');
     }
     echo Json::encode(['room_id' => $equipment->location->room_id, 'location_id' => $equipment->location_id, 'equipment_id' => $equipment->id]);
 }