/** * Creates data provider instance with search query applied * * @param array $params * * @return ActiveDataProvider */ public function search($params) { $query = MaterialesServicios::find(); // Join para la relacion $query->joinWith(['cuenta0']); $query->joinWith(['presentacion0']); $query->joinWith(['unidadMedida']); $dataProvider = new ActiveDataProvider(['query' => $query]); //Ordenamiento $dataProvider->sort->attributes['nombrePresentacion'] = ['asc' => ['presentacion.nombre' => SORT_ASC], 'desc' => ['presentacion.nombre' => SORT_DESC]]; $dataProvider->sort->attributes['nombreUnidadMedida'] = ['asc' => ['unidad_medida.unidad_medida' => SORT_ASC], 'desc' => ['unidad_medida.unidad_medida' => SORT_DESC]]; $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, 'cuenta' => $this->cuenta, 'partida' => $this->partida, 'generica' => $this->generica, 'especifica' => $this->especifica, 'subespecifica' => $this->subespecifica, 'unidad_medida' => $this->unidad_medida, 'presentacion' => $this->presentacion, 'precio' => $this->precio, 'iva' => $this->iva, 'materiales_servicios.estatus' => $this->estatus]); $query->andFilterWhere(['materiales_servicios.estatus' => $this->nombreEstatus]); $query->andFilterWhere(['like', 'nombre', $this->nombre]); $query->andFilterWhere(['like', 'presentacion.nombre', $this->nombrePresentacion]); $query->andFilterWhere(['like', 'unidad_medida.unidad_medida', $this->nombreUnidadMedida]); return $dataProvider; }
/** * @return \yii\db\ActiveQuery */ public function getIdMaterial() { return $this->hasOne(MaterialesServicios::className(), ['id' => 'id_material']); }
/** * Finds the MaterialesServicios model based on its primary key value. * If the model is not found, a 404 HTTP exception will be thrown. * @param integer $id * @return MaterialesServicios the loaded model * @throws NotFoundHttpException if the model cannot be found */ protected function findModel($id) { if (($model = MaterialesServicios::findOne($id)) !== null) { return $model; } else { throw new NotFoundHttpException('The requested page does not exist.'); } }
public function getMaterialesPartidaEntidad() { return $this->hasMany(MaterialesServicios::className(), ['cuenta' => 'cuenta', 'partida' => 'partida']); }
/** * @return \yii\db\ActiveQuery */ public function getMaterialesServicios() { return $this->hasMany(MaterialesServicios::className(), ['presentacion' => 'id']); }
/** * Updates an existing ProyectoPedido model. * For ajax request will return json object * and for non-ajax request if update is successful, the browser will be redirected to the 'view' page. * @param integer $id * @return mixed */ public function actionUpdate($id) { $request = Yii::$app->request; $model = $this->findModel($id); //autocomplete $materiales = MaterialesServicios::find()->select(['nombre', 'id', 'precio', 'iva'])->all(); //Arreglo de precios, iva, etc con id del material/servicio $precios = json_encode(ArrayHelper::toArray(ArrayHelper::index($materiales, 'id'))); if ($request->isAjax) { /* * Process for ajax request */ Yii::$app->response->format = Response::FORMAT_JSON; if ($request->isGet) { return ['title' => "Pedido", 'content' => $this->renderAjax('update', ['model' => $this->findModel($id), 'materiales' => $materiales, 'precios' => $precios]), 'footer' => Html::button('Cerrar', ['class' => 'btn btn-default pull-left', 'data-dismiss' => "modal"]) . Html::button('Guardar', ['class' => 'btn btn-primary', 'type' => "submit"])]; } else { if ($model->load($request->post()) && $model->save()) { return ['forceReload' => 'true', 'title' => "Pedido", 'content' => $this->renderAjax('view', ['model' => $this->findModel($id), 'materiales' => $materiales, 'precios' => $precios]), 'footer' => Html::button('Cerrar', ['class' => 'btn btn-default pull-left', 'data-dismiss' => "modal"]) . Html::a('Editar', ['update', 'id' => $id], ['class' => 'btn btn-primary', 'role' => 'modal-remote'])]; } else { return ['title' => "Pedido", 'content' => $this->renderAjax('update', ['model' => $this->findModel($id), 'materiales' => $materiales, 'precios' => $precios]), 'footer' => Html::button('Cerrar', ['class' => 'btn btn-default pull-left', 'data-dismiss' => "modal"]) . Html::button('Guardar', ['class' => 'btn btn-primary', 'type' => "submit"])]; } } } else { /* * Process for non-ajax request */ if ($model->load($request->post()) && $model->save()) { return $this->redirect(['view', 'id' => $model->id]); } else { return $this->render('update', ['model' => $model, 'materiales' => $materiales, 'precios' => $precios]); } } }
/** * @return \yii\db\ActiveQuery */ public function getMaterialesServicios() { return $this->hasOne(MaterialesServicios::className(), ['cuenta' => 'cuenta', 'partida' => 'partida', 'generica' => 'generica', 'especifica' => 'especifica', 'subespecifica' => 'subespecifica']); }
public function actionLlenarprecio() { $request = Yii::$app->request; if ($request->isAjax) { Yii::$app->response->format = Response::FORMAT_JSON; if ($request->isPost) { //Acciones Especificas $ace = MaterialesServicios::find()->select(["precio", "iva"])->where(['id' => $request->post('id')])->asArray()->all(); if ($ace != null) { return $ace; } else { return 0; } } } }