//$result = $conn->query($query); //$result->execute(); $i = 0; $n = 1; while ($row = $result->fetch(PDO::FETCH_ASSOC)) { $stsLogin = $_SESSION['TYPE'] == 1 || $_SESSION['TYPE'] == 2 || $_SESSION['TYPE'] == 3 ? "" : "disabled"; //$lama = dateDiff($row['OP'], $row['CL'], 6); if ($row["LAMA"] == 0 || is_null($row["LAMA"])) { $lama = 0; } else { $lama = convertToHIS($row["LAMA"]); } if ($row["JEDARC1"] == 0 || is_null($row["JEDARC1"])) { $jedarc1 = 0; } else { $jedarc1 = convertToHIS($row["JEDARC1"]); } $checkdata = "<div class='text-center'><input type='checkbox' id='titleCheckdel' {$stsLogin} /><input type='hidden' class='deldata' name='item[{$n}][deldata]' value='{$row['ID']}' disabled></div>"; $rowEdit = "<a href='#' onClick='showModals({$row['ID']})' class='btn_edit btn btn-xs btn-primary' id='{$row['ID']}'><i class='fa fa-pencil'></i></a>"; $tbldelete = "<a class='btn btn-xs btn-danger' onclick='deleteLogsheet({$row['ID']})'><i class='fa fa-times'></i></a>"; $session_act = $_SESSION['TYPE'] == 1 || $_SESSION['TYPE'] == 2 || $_SESSION['TYPE'] == 3 ? $rowEdit . $tbldelete : "<i class='fa fa-pencil'></i><i class='fa fa-times'></i>"; $action = "<div class='text-center'><div class='btn-group btn-group-xs'>{$session_act}</div></div>"; $sc = $row['SC'] == 1 ? "<span class='label label-warning'>Manual</span>" : "<span class='label label-success'>Otomatis</span>"; $mc = $row['MC'] == 1 ? "<a href='#' class='mc'><span class='label label-primary'>Checked</span></a>" : "<a href='#' class='mc'><span class='label label-default'>Unchecked</span></a>"; $TANGGAL = is_null($row['TANGGAL']) ? "" : substr($row['TANGGAL'], 0, 10); $TR = is_null($row['TR']) ? "" : substr($row['TR'], 11, 8); $EX = is_null($row['EX']) ? "" : substr($row['EX'], 11, 8); $RC = is_null($row['RC']) ? "" : substr($row['RC'], 11, 8); $OP = is_null($row['OP']) ? "" : substr($row['OP'], 11, 8); $CL = is_null($row['CL']) ? "" : substr($row['CL'], 11, 8); $rows['data'][$i] = array($checkdata, $action, $sc, $mc, $TANGGAL, $row['PLBSREC'], $row['ASUHAN'], $row['GI'], $row['AREA'], $row['BEBANPADAM'], $row['RELAY'], $TR, $EX, $RC, $OP, $CL, $lama, $row['MW'], $row['KWH'], $row['MRF'], $jedarc1, $row['KODEFGTM'], $row['KODESIKLUS'], $row['KETFGTM'], $row['KETERANGAN'], $row['KORDINASI'], $row['SEGMENGANGGUAN'], $row['TOTALPELANGGAN'], $row['PELANGGANPADAM'], $row['PERSENPELANGGANPADAM'], $row['KODESAIDI'], $row['KETSAIDI'], $row['EKSEKUTOR'], $row['SHIFT']);
$kodefgtm = !empty($_GET['kodefgtm']) ? $_GET['kodefgtm'] : NULL; $lama = !empty($_GET['lama']) ? $_GET['lama'] : NULL; $relay = !empty($_GET['relay']) ? $_GET['relay'] : NULL; $result->bindParam('retval', $retval, PDO::PARAM_INT | PDO::PARAM_INPUT_OUTPUT, 4); $result->bindParam('areaid', $areaid, PDO::PARAM_INT); $result->bindParam('giid', $giid, PDO::PARAM_INT); $result->bindParam('bulan', $bulan, PDO::PARAM_INT); $result->bindParam('tahun', $tahun, PDO::PARAM_INT); $result->bindParam('kodefgtm', $kodefgtm, PDO::PARAM_STR); $result->bindParam('lama', $lama, PDO::PARAM_INT); $result->bindParam('relay', $relay, PDO::PARAM_STR); $result->execute(); $i = 0; //$n = 1; while ($row = $result->fetch(PDO::FETCH_ASSOC)) { if ($row["LAMA"] == 0 || is_null($row["LAMA"])) { $lama = 0; } else { $lama = convertToHIS($row["LAMA"]); } $TANGGAL = is_null($row['TANGGAL']) ? "" : substr($row['TANGGAL'], 0, 10); $TR = is_null($row['TR']) ? "" : substr($row['TR'], 11, 8); $EX = is_null($row['EX']) ? "" : substr($row['EX'], 11, 8); $RC = is_null($row['RC']) ? "" : substr($row['RC'], 11, 8); $OP = is_null($row['OP']) ? "" : substr($row['OP'], 11, 8); $CL = is_null($row['CL']) ? "" : substr($row['CL'], 11, 8); $rows['data'][$i] = array($TANGGAL, $row['AREA'], $row['GI'], $row['ASUHAN'], $row['PLBSREC'], $TR, $EX, $RC, $OP, $CL, $lama, $row['PELANGGANPADAM'], $row['SEGMENGANGGUAN'], $row['KODEPADAM'], $row['GANGGUAN'], $row['KELOMPOKGANGGUAN'], $row['KETERANGANGANGGUAN']); $i++; //$n++; } print json_encode($rows, JSON_NUMERIC_CHECK);