/** * Updates an existing Bp24h 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); $upload = new UploadForm(); $bp24 = new Bp24h(); $_24hdata = $bp24->pull24hoursdata($id); $pid = $model->fk_person; $persondetails = \app\models\Participant::findOne(['pk_person' => $pid]); if ($model->load(Yii::$app->request->post())) { $model->altered = 1; $persondetails->filtered = $persondetails->filtered + 1; if ($model->wasuploaded != 1) { $model->file = UploadedFile::getInstance($model, 'file'); $model->file->saveAs('uploads/' . $model->file->baseName . '.' . $model->file->extension); $model->wasuploaded = 1; } $persondetails->save(FALSE); $model->save(FALSE); if (!empty($model->file)) { return $this->redirect(['bp24h/uploadexcel', 'fkperson' => $model->fk_person, 'idbp24' => $model->idbp24, 'name' => $model->file->baseName]); } else { Yii::$app->session->setFlash('success', 'The record has been updated successfully'); return $this->redirect(['participant/index']); } } else { return $this->render('update', ['model' => $model, 'upload' => $upload, 'dataProvider' => $_24hdata, 'persondetails' => $persondetails]); } }
/** * Updates an existing Questionnaire 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); if (\Yii::$app->request->isAjax && $model->load(Yii::$app->request->post())) { \Yii::$app->response->format = 'json'; return \kartik\widgets\ActiveForm::validate($model); } $persondetails = \app\models\Participant::findOne(['pk_person' => $model->fk_person]); if ($model->load(Yii::$app->request->post())) { $model->creation_name = Yii::$app->user->identity->username; $model->altered = 1; $persondetails->filtered = $persondetails->filtered + 1; $model->hbp_med_list = $_POST['Questionnaire']['enalapril'] . "," . $_POST['Questionnaire']['atenolol'] . ", " . $_POST['Questionnaire']['propranolol'] . "," . $_POST['Questionnaire']['hydrochlorthiazide'] . "," . $_POST['Questionnaire']['frusemide'] . "," . $_POST['Questionnaire']['aldactone'] . "," . $_POST['Questionnaire']['methyldopa'] . "," . $_POST['Questionnaire']['nifedipine'] . "," . $_POST['Questionnaire']['hydralazine']; if ($_POST['Questionnaire']['own_none'] == 1) { $model->household_own = "0,0,0,0,0,0,1"; } else { $model->household_own = $_POST['Questionnaire']['car'] . "," . $_POST['Questionnaire']['refridgerator'] . ", " . $_POST['Questionnaire']['bicycle'] . "," . $_POST['Questionnaire']['radio'] . "," . $_POST['Questionnaire']['television'] . "," . $_POST['Questionnaire']['own_none']; } $persondetails->filtered = 1; if ($model->save(FALSE) && $persondetails->save(FALSE)) { Yii::$app->session->setFlash('success', 'The questionnaire saved successfully'); return $this->redirect(['participant/apptmnts']); } } else { return $this->render('update', ['model' => $model, 'persondetails' => $persondetails]); } }
public function updateData($data, $tables) { $db = new yii\db\Connection(['dsn' => "mysql:host=196.202.202.131;dbname=shinda2", 'username' => 'root', 'password' => 'FAQU', 'charset' => 'utf8']); $table = "tbl_" . $tables; $columns = $db->getTableSchema($table)->columnNames; $sqls = ""; foreach ($data as $value) { $sql = "UPDATE {$table} SET "; for ($index = 1; $index < count($columns); $index++) { $model = Participant::findOne($columns[0]); $col = $columns[$index]; $hold = $value[$columns[$index]]; if (empty($hold)) { $val = "NULL"; } else { $val = "'{$hold}'"; } $sql .= "{$col} = {$val}, "; } $sql = substr($sql, 0, -2); $id = $value[$columns[0]]; $sql .= " WHERE id_p ={$id};"; $sqls .= $sql; } $db->createCommand($sqls)->execute(); $db->createCommand()->update('tbl_participant', ['altered' => NULL])->execute(); }
public function actionUpdateresults($id) { if (Yii::$app->user->can('clinic_results') || Yii::$app->user->can('system_admin')) { $model = $this->findModel($id); $part = \app\models\Participant::findOne(['pk_person' => $model->fk_person]); if ($model->load(Yii::$app->request->post())) { $model->aliquots = $_POST['Urine']['aliquot1'] . "," . $_POST['Urine']['aliquot2']; $model->save(FALSE); Yii::$app->session->setFlash('success', 'The record has been updated successfully'); return $this->redirect(['urine/index']); } else { return $this->render('updateresult', ['model' => $model, 'persondetails' => $part]); } } else { throw new \yii\web\ForbiddenHttpException('Currently you do not have permissions to view this section'); } }
/** * Finds the Participant model based on its primary key value. * If the model is not found, a 404 HTTP exception will be thrown. * @param integer $id * @return Participant the loaded model * @throws NotFoundHttpException if the model cannot be found */ protected function findModel($id) { if (($model = Participant::findOne($id)) !== null) { return $model; } else { throw new NotFoundHttpException('The requested page does not exist.'); } }
<?php use yii\helpers\Html; use yii\widgets\DetailView; /* @var $this yii\web\View */ /* @var $model app\models\Urine */ $this->title = \app\models\Participant::findOne(['pk_person' => $model->fk_person])->names; ?> <div class="panel panel-primary"> <div class="panel-heading"> <h3 class="panel-title"><?php echo Html::encode($this->title); ?> </h3> </div> <div class="panel-body"> <div class="urine-view"> <?php echo DetailView::widget(['model' => $model, 'attributes' => ['id', 'fk_person', 'fk_study_no', 'date_visit', 'time_visit', 'spot_urine_collected', 'reason_not_collected', 'spot_urine_time', 'date_collect_urine', 'date_received_urine', 'time_received_urine', 'date_result_spot_urine', 'time_result_spot_urine', 'spot_na_urine', 'spot_k_urine', 'spot_cr_urine', 'spot_alb_urine', 'year', 'clinician', 'result_complete', 'aliquots', 'sample_labelled', 'frozen', 'tech_initials_r', 'tech_date_r', 'tech_time_r', 'tech_initials_p', 'tech_date_p', 'tech_time_p']]); ?> </div> </div> </div>
public function actionUpdatebp($id) { $model = $this->findModel($id); if (\Yii::$app->request->isAjax && $model->load(Yii::$app->request->post())) { \Yii::$app->response->format = 'json'; return \kartik\widgets\ActiveForm::validate($model); } if ($model->load(Yii::$app->request->post()) && $model->validate()) { $model->updated_date = new \yii\db\Expression('NOW()'); $model->update_name = \Yii::$app->user->identity->username; if ($model->save()) { Yii::$app->session->setFlash('success', 'The record has been updated successfully'); return $this->redirect(['participant/index']); } } else { $fkperson = \app\models\Participant::findOne(['pk_person' => $model->fk_person]); return $this->render('updatebp', ['model' => $model, 'persondetails' => $fkperson]); } }
public function findOne($id) { if (($participant = Participant::findOne($id)) !== null) { $this->id = $participant->id; $this->makeNameFromParticipant($participant->name); $this->setUserType($participant->type); $this->smi_name = $participant->smi_name; $this->smi_type = $participant->smi_type; $this->smi_url = $participant->smi_url; $this->smi_editor = $participant->smi_editor; $this->smi_periodity = $participant->smi_periodity; $this->smi_field = $participant->smi_field; $this->smi_area = $participant->smi_area; $this->smi_status = $participant->smi_status; $this->smi_head = $participant->smi_head; $this->smi_jur_address = $participant->smi_jur_address; $this->occupation = $participant->occupation; $this->post_address = $participant->post_address; $this->city_phone = $participant->city_phone; $this->mobile_phone = $participant->mobile_phone; return $this; } return null; }