PHP convertToHIS Examples

Example #1

File: json_table_logsheet.php Project: arsan-irianto/apdpln

//$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']);

Example #2

File: json_charts_details.php Project: arsan-irianto/apdpln

$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);