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();
}
