query($query);
if($tmp_diet->numRows() > 0) {
$msg = "Ditemukan diet pada hari yang sama";
$type = "error";
}
else {
$msg = "Tidak ditemukan diet pada hari ini";
$type = "success";
}
echo json_encode(['message'=>$msg,'type'=>$type]);
exit;
}
elseif(array_key_exists('replace', $_REQUEST) && $_REQUEST['replace'] == 1) {
include("../core/main.php");
$post = $_REQUEST;
$query = "SELECT * from t_dpmp where idxdaftar = {$post['idxdaftar']} and idxtgl = '".date('Y-m-d')."' and ruang = {$post['ruang']}";
$tmp_diet = $db->query($query);
if($tmp_diet->numRows() > 0) {
// set non aktif
execute("UPDATE t_dpmp set st_diet = 0 where idxdaftar = {$post['idxdaftar']} and idxtgl = '".date('Y-m-d')."' and ruang = {$post['ruang']}");
// new data
$noruang = $post['ruang'];
$snack = (array_key_exists('snack', $post)) ? $post['snack'] : 0;
$ketsnack = ($snack != 0) ? $post['keterangansnack'] : '';
$sql = "SELECT * FROM m_ruang WHERE no = '$noruang'";
$q = $db->query($sql);
$ruang = $q->fetchFirst();
if($katalog == 1) {
$diet_query = "SELECT * from m_katalog_diet where id_katalog in ('".implode("','", explode(',', $post['idx_diet']))."')";
}
else{
$diet_query = "SELECT * from m_diet where id_diet in ('".implode("','", explode(',', $post['idx_diet']))."')";
}
$tmp_diet = $db->query($diet_query);
$nama_diet = $tmp_diet->fetchFirst();
$idx_diet = explode(',', $post['idx_diet']);
$arr_error = [];
foreach($idx_diet as $diet) {
$arr_data_dpmp = [
'idxdaftar' => ['type'=>'number','value'=>$post['idxdaftar']],
'nomr' => $post['nomr'],
'ruang' => ['type'=>'number','value'=>$post['ruang']],
'jenismakanan' => ['type'=>'number','value'=>$diet],
'shift' => ['type'=>'number','value'=>$_SESSION['SHIFT']],
'keterangantambahan' => $post['keterangantambahan'],
'tanggal' => date('Y-m-d H:i:s'),
'snack' => ['type'=>'number','value'=>$snack],
'keterangansnack' => $ketsnack,
'idxtgl' => date('Y-m-d'),
'petugas' => $_SESSION['nip'],
'st_diet' => ['type'=>'number','value'=>1],
'nobill' => ['type'=>'number','value'=>$post['nobill']],
];
if($katalog == 1) {
$arr_data_dpmp['st_katalog_baru'] = ['type'=>'number','value'=>1];
$arr_data_dpmp['ket_waktu'] = json_encode(function ($post){
$arr_result = [];
foreach($post['waktu_konsumsi'] as $wk) {
$arr_result[] = strtolower($wk);
}
return $arr_result;
});
}
$vSql = execute("INSERT INTO t_dpmp ".bind_sql($arr_data_dpmp));
if(!$vSql) {
$arr_error[] = $diet;
}
}
echo "Input Data Sukses!
";
}
else {
echo "Input Data Gagal!
";
}
}
else {
if(isset($_POST['idx_diet'])) {
include("../core/main.php");
$post = $_REQUEST;
$noruang = $post['ruang'];
$snack = (array_key_exists('snack', $post)) ? $post['snack'] : 0;
$ketsnack = ($snack != 0) ? $post['keterangansnack'] : '';
$sql = "SELECT * FROM m_ruang WHERE no = '$noruang'";
$q = $db->query($sql);
$ruang = $q->fetchFirst();
$diet_query = "SELECT * from m_diet where id_diet in ('".implode("','", explode(',', $post['idx_diet']))."')";
$tmp_diet = $db->query($diet_query);
$nama_diet = $tmp_diet->fetchFirst();
$idx_diet = explode(',', $post['idx_diet']);
$arr_error = [];
foreach($idx_diet as $diet) {
$arr_data_dpmp = [
'idxdaftar' => ['type'=>'number','value'=>$post['idxdaftar']],
'nomr' => $post['nomr'],
'ruang' => ['type'=>'number','value'=>$post['ruang']],
'jenismakanan' => ['type'=>'number','value'=>$diet],
'shift' => ['type'=>'number','value'=>$_SESSION['SHIFT']],
'keterangantambahan' => $post['keterangantambahan'],
'tanggal' => date('Y-m-d H:i:s'),
'snack' => ['type'=>'number','value'=>$snack],
'keterangansnack' => $ketsnack,
'idxtgl' => date('Y-m-d'),
'petugas' => $_SESSION['nip'],
'st_diet' => ['type'=>'number','value'=>1],
'nobill' => ['type'=>'number','value'=>$post['nobill']],
];
if($katalog == 1) {
$arr_data_dpmp['st_katalog_baru'] = ['type'=>'number','value'=>1];
$arr_data_dpmp['ket_waktu'] = json_encode(function ($post){
$arr_result = [];
foreach($post['waktu_konsumsi'] as $wk) {
$arr_result[] = strtolower($wk);
}
return $arr_result;
});
}
$vSql = execute("INSERT INTO t_dpmp ".bind_sql($arr_data_dpmp));
if(!$vSql) {
$arr_error[] = $diet;
}
}
if(empty($arr_error)) {
// execute("INSERT INTO t_notification(info,status,roles) VALUES('No RM : ".$_POST['nomr']."
Ruang : ".$ruang['nama']."
Request :
".$nama_diet['nama_diet']."',0::boolean,15)");
echo "Input Data Sukses!
";
}else {
echo "Input Data Gagal!
";
}
}
}
if(!empty($_POST['idxdaftar'])) {
$idx = $_POST['idxdaftar'];
}else if(!empty($_POST['id_admission'])) {
$idx = $_POST['id_admission'];
}else if(!empty($_GET['id_admission'])) {
$idx = $_GET['id_admission'];
}else {
$idx = $id_admission;
}
?>
| NOMR |
NAMA |
KELAS |
RUANG |
Kelompok |
Nama Diet |
Waktu |
SNACK |
Ket. |
query($sql);
$count = 0;
foreach($rs->fetchAll() as $data) {
$ketsnack = ($data['keterangansnack'] != '') ? '
Snack : '.$data['keterangansnack'] : '';
?>
valign="top" align="center">
|
|
|
|
|
|
|
|
|