public function searchByEvent($id) { $query = Peserta::find(); // add conditions that should always apply here $dataProvider = new ActiveDataProvider(['query' => $query]); // grid filtering conditions $query->innerJoin('absensi', 'absensi.id_peserta = peserta.id'); $query->andFilterWhere(['id_event' => $id]); return $dataProvider; }
public function actionSend2() { //broadcast semua $email = new Email(); if ($email->load(Yii::$app->request->post()) && $email->validate()) { $peserta = Peserta::find()->all(); foreach ($peserta as $key) { $temp = $key->email; echo $temp; $content_template = $email->content; //mengambil subjek dari email yang akan dikirimkan $subject_template = $email->subject; $subject = str_replace("{nama}", $key->nama, $subject_template); $content = str_replace("{nama}", $key->nama, $content_template); echo "</br>"; Yii::$app->mailer->compose()->setFrom(Yii::$app->params['adminEmail'])->setHtmlBody($content)->setSubject($subject)->setTo($temp)->send(); } } }
public function delete_atur_peserta(Request $request) { if ($request->has('pilih')) { $pilih = $request->input('pilih'); foreach ($pilih as $key => $value) { Peserta::find($value)->delete(); } Session::flash('pesan', "Data Berhasil dihapus"); } return Redirect::back(); }