/** * Creates a new Pago model. * If creation is successful, the browser will be redirected to the 'view' page. * @return mixed */ public function actionCreate($academia = 0) { $model = new Pago(); $model->academia = $academia; $searchModel = new PagoSearch(); $dataProvider = $searchModel->search(Yii::$app->request->queryParams); $model_detalle_academia = Academia::findOne(['id' => $academia]); $meses_a_pagar = Pago::calcularMesesDeuda($academia); $periodo_a_pagar = Pago::calcularPeriodoAPagar($academia); $valor_a_pagar = Pago::calcularValorAPagar($academia); if ($model->load(Yii::$app->request->post()) && $model->save()) { return $this->refresh(); } else { return $this->render('create', ['model' => $model, 'model_detalle_academia' => $model_detalle_academia, 'meses_a_pagar' => $meses_a_pagar, 'periodo_a_pagar' => $periodo_a_pagar, 'valor_a_pagar' => $valor_a_pagar, 'searchModel' => $searchModel, 'dataProvider' => $dataProvider]); } }
public function excel($params) { $query = Pago::find(); $dataProvider = new ActiveDataProvider(['query' => $query, 'pagination' => array('pageSize' => 10000)]); $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, 'forma_pago_id' => $this->forma_pago_id, 'rce_examen_id' => $this->rce_examen_id, 'monto' => $this->monto, 'comprobante' => $this->comprobante, 'estadopago' => $this->estadopago]); return $dataProvider; }
/** * Creates data provider instance with search query applied * * @param array $params * * @return ActiveDataProvider */ public function search($params) { $query = Pago::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, 'fecha_registro' => $this->fecha_registro, 'fecha_pago' => $this->fecha_pago, 'medio' => $this->medio, 'valor' => $this->valor, 'estado' => $this->estado, 'academia' => $this->academia]); $query->andFilterWhere(['like', 'info', $this->info])->andFilterWhere(['like', 'comprobante', $this->comprobante]); return $dataProvider; }
/** * @return \yii\db\ActiveQuery */ public function getPagos() { return $this->hasMany(Pago::className(), ['forma_pago_id' => 'id']); }
public function imprimirPagosxPeriodoControl($desde = null, $hasta = null) { if (empty($desde) or empty($hasta)) { $pagos = Pago::all(); } else { $pagos = Pago::rangoFecha($desde, $hasta); } $vista = \View::make('pagos.pagosxperiodocontrolpdf', ['pagos' => $pagos])->render(); $pdf = \App::make('dompdf.wrapper'); $pdf->loadHTML($vista); return $pdf->stream('pagosxperiodocontrolpdf'); }
/** * @return \yii\db\ActiveQuery */ public function getPagos() { return $this->hasMany(Pago::className(), ['medio' => 'id']); }
public function esValido() { $socio = Socio::find(Input::get('socios_id')); $plan = Plan::find(Input::get('planes_id')); $pagos = Pago::find(); }
/** * Updates an existing RceExamen model. * If update is successful, the browser will be redirected to the 'view' page. * @param integer $id * @return mixed */ public function actionUpdate($id) { $model = $this->findModel($id); $modelsPago = $model->pagos; $modelsBitacora = $model->bitacoras; $modelsExamenes = $model->rceExamenExamens; foreach ($modelsExamenes as $modelExamen) { $examen = Examen::find()->where(['id' => $modelExamen->examen_id])->one(); $modelExamen->descripcion = $examen->descripcion; $modelExamen->observaciones = $examen->observaciones; } if ($model->load(Yii::$app->request->post())) { $oldIDsPago = ArrayHelper::map($modelsPago, 'id', 'id'); $modelsPago = Model::createMultiple(Pago::classname(), $modelsPago); Model::loadMultiple($modelsPago, Yii::$app->request->post()); $deletedIDsPago = array_diff($oldIDsPago, array_filter(ArrayHelper::map($modelsPago, 'id', 'id'))); $oldIDsExamen = ArrayHelper::map($modelsExamenes, 'id', 'id'); $modelsExamenes = Model::createMultiple(Examen::classname(), $modelsExamenes); Model::loadMultiple($modelsExamenes, Yii::$app->request->post()); $deletedIDsExamen = array_diff($oldIDsExamen, array_filter(ArrayHelper::map($modelsExamenes, 'id', 'id'))); // validate all models $valid = $model->validate(); $valid = Model::validateMultiple($modelsPago) && $valid; $valid = Model::validateMultiple($modelsBitacora) && $valid; $valid = Model::validateMultiple($modelsExamenes) && $valid; if ($valid) { $transaction = \Yii::$app->db->beginTransaction(); try { if ($flag = $model->save(false)) { if (!empty($deletedIDsPago)) { Pago::deleteAll(['id' => $deletedIDsPago]); } else { if (!empty($deletedIDsBitacora)) { Bitacora::deleteAll(['id' => $deletedIDsBitacora]); } else { if (!empty($deletedIDsREE)) { RceExamenExamen::deleteAll(['id' => $deletedIDsREE]); } } } foreach ($modelsPago as $modelPago) { $modelPago->rce_examen_id = $model->id; if (!($flag = $modelPago->save(false))) { $transaction->rollBack(); break; } } foreach ($modelsBitacora as $modelBitacora) { $modelBitacora->rce_examen_id = $model->id; if (!($flag = $modelBitacora->save(false))) { $transaction->rollBack(); break; } } $reserva = Reserva::find()->where(['id' => $model->reserva_id])->one(); $hora = Hora::find()->where(['id' => $reserva->hora_medica_id])->one(); $examenes = HoraExamenSolicitado::find()->where(['hora_id' => $hora->id])->all(); for ($i = 0; $i < count($examenes); ++$i) { $examen = Examen::find()->where(['id' => $examenes[$i]->examen_id])->one(); $modelsExamenes[$i] = new RceExamenExamen(); $modelsExamenes[$i]->rce_examen_id = $model->id; $modelsExamenes[$i]->examen_id = $examenes[$i]->examen_id; $modelsExamenes[$i]->monto_a_pagar = $examen->monto; if (!($flag = $modelsExamenes[$i]->save(false))) { $transaction->rollBack(); break; } } } if ($flag) { $transaction->commit(); return $this->redirect(['view', 'id' => $model->id]); } } catch (Exception $e) { $transaction->rollBack(); } } } return $this->render('update', ['model' => $model, 'modelsPago' => empty($modelsPago) ? [new Pago()] : $modelsPago, 'modelsBitacora' => empty($modelsBitacora) ? [new Bitacora()] : $modelsBitacora, 'modelsExamenes' => empty($modelsExamenes) ? [new RceExamenExamen()] : $modelsExamenes]); }
/** * Finds the Pago model based on its primary key value. * If the model is not found, a 404 HTTP exception will be thrown. * @param integer $id * @return Pago the loaded model * @throws NotFoundHttpException if the model cannot be found */ protected function findModel($id) { if (($model = Pago::findOne($id)) !== null) { return $model; } else { throw new NotFoundHttpException('The requested page does not exist.'); } }
/** * @return \yii\db\ActiveQuery */ public function getPagos() { return $this->hasMany(Pago::className(), ['rce_examen_id' => 'id']); }