function doSendNotifBirthDay(){
$data = array();
$dataz = array();
$this->db->select('warga_id,warga_nama,warga_tgl_lahir,warga_telepon,warga_photo');
$this->db->where('DATE_FORMAT(warga_tgl_lahir,"%d-%m")','DATE_FORMAT(CURDATE(),"%d-%m")',FALSE);
$this->db->where('warga_jenis',1);
$this->db->where('warga_status',1);
$q = $this->db->get('data_warga');
if($q->num_rows > 0){
$data['result']=true;
$data['data']=$q->result();
}else{
$data['result']=false;
$data['msg']='data tidak ditemukan';
}
$result = json_encode($data);
$json_decoded = json_decode($result,true);
if($q->num_rows > 0){
$dataz['result']=true;
$dataz['msg']='data ditemukan';
foreach ($json_decoded['data'] as $row){
$nama = $row['warga_nama'];
$phone = $row['warga_telepon'];
$isi ='Barakallahu fii umrik *'.$nama.'*, bertambah satu tahun lagi usiamu hari ini *'.$this->thisDay().'*, tanggal *'.date('d').' '.$this->thisMonth().' '.date('Y').'* dan hanya doa yang bisa kami haturkan. Semoga Allah memberikan kesehatan, rezeki yang melimpah dan kesuksesan, serta umur panjang. Dan tak lupa, semoga selalu diberi keberkahan Allahuma Aamiin...🤲'."\n\n".';
$simpan['phone']=$phone;
$simpan['pesan']=$isi;
$simpan['id_users']='139';
$this->db->insert('wa_outbox',$simpan);
}
}else{
$dataz['result']=false;
$dataz['msg']='data tidak ditemukan';
}
echo json_encode($dataz);
}
function thisDay(){
$day = date ("D");
switch($day){
case 'Sun':
$hari_ini = "Minggu";
break;
case 'Mon':
$hari_ini = "Senin";
break;
case 'Tue':
$hari_ini = "Selasa";
break;
case 'Wed':
$hari_ini = "Rabu";
break;
case 'Thu':
$hari_ini = "Kamis";
break;
case 'Fri':
$hari_ini = "Jumat";
break;
case 'Sat':
$hari_ini = "Sabtu";
break;
default:
$hari_ini = "Tidak di ketahui";
break;
}
return $hari_ini;
}
function thisMonth(){
$month = date("m");
switch($month){
case '01':
$month = "Januari";
break;
case '02':
$month = "Februari";
break;
case '03':
$month = "Maret";
break;
case '04':
$month = "April";
break;
case '05':
$month = "Mei";
break;
case '06':
$month = "Juni";
break;
case '07':
$month = "Juli";
break;
case '08':
$month = "Agustus";
break;
case '09':
$month = "September";
break;
case '10':
$month = "Oktober";
break;
case '11':
$month = "November";
break;
case '12':
$month = "Desember";
break;
default:
$month = "Unknow";
break;
}
return $month;
}
Tidak ada komentar:
Posting Komentar