{
$data = explode("-", $vardate);
$date = new DateTime();
$date->setDate($data[0], $data[1], $data[2]);
$date->modify("" . $added . "");
$day = $date->format("Y-m-d");
return $day;
}
while ($bar1 = mysql_fetch_object($res1)) {
$no += 1;
#jika bukan orang HO maka dapat
# if($bar1->tipekaryawan==0 and substr($bar1->lokasitugas,2,2)!='HO')
# $hakcuti=12;
# else if($bar1->tipekaryawan!=0 and substr($bar1->lokasitugas,2,2)!='HO')
# $hakcuti=12;
$penambahTanggal = adddate($bar1->sampai, "+180 days");
// echo getRangeTanggal(date('Y-m-d'),$bar1->sampai);
// echo adddate(date('Y-m-d'), "-180 days");
//Masa kerja
$date1 = $bar1->tanggalmasuk;
$date2 = date('Y-m-d');
$diff = abs(strtotime($date2) - strtotime($date1));
$years = floor($diff / (365 * 60 * 60 * 24));
$months = floor(($diff - $years * 365 * 60 * 60 * 24) / (30 * 60 * 60 * 24));
$days = floor(($diff - $years * 365 * 60 * 60 * 24 - $months * 30 * 60 * 60 * 24) / (60 * 60 * 24));
$lamaKerja = " " . $years . " Tahun " . $months . " Bulan";
$sisacuti = $hakcuti - $bar1->diambil;
if (getRangeTanggal(date('Y-m-d'), $penambahTanggal) > 0) {
echo "<tr class=rowcontent id=baris" . $no . ">\r\n\t\t\t\t\t <td>" . $no . "</td>\r\n\t\t\t\t\t <td id=kodeorg" . $no . ">" . substr($bar1->locTugas, 0, 4) . "</td>\r\n\t\t\t\t\t <td id=karyawanid" . $no . " hidden>" . $bar1->karyawanid . "</td>\r\n\t\t\t\t\t\t\t\t\t<td >" . $bar1->nik . "</td>\r\n\t\t\t\t\t <td class=firsttd id=nama" . $no . " title='Click for detail' style='cursor:pointer' onclick=showByUser('" . $bar1->karyawanid . "',event)>" . $bar1->namakaryawan . "</td>\r\n\t\t\t\t\t <td>" . $bar1->tipe . "</td>\r\n\t\t\t\t\t <td>" . tanggalnormal($bar1->tanggalmasuk) . "</td>\r\n\t\t\t\t\t <td>" . $lamaKerja . "</td>\r\n\t\t\t\t\t <td id=periode" . $no . ">" . $bar1->periodecuti . "</td>\t\t\t\t \r\n\t\t\t\t\t <td id=dari" . $no . ">" . tanggalnormal($bar1->dari) . "</td>\r\n\t\t\t\t\t <td id=sampai" . $no . ">" . tanggalnormal($penambahTanggal) . "</td>\r\n\t\t\t\t\t <td id=hak" . $no . " align=right>" . $hakcuti . "</td>\r\n\t\t\t\t\t <td id=diambil" . $no . " align=right>" . $bar1->diambil . "</td>\r\n\t\t\t\t\t <td style='text-align:right;'><input type=text id=sisa" . $no . " class=myinputtextnumber size=4 conkeypress=\"return angka_doang(event);\" value='" . $sisacuti . "'>\r\n\t\t\t\t\t <img src='images/save.png' title='Save' class=resicon onclick=updateSisa('" . $periode . "','" . $bar1->karyawanid . "','" . $bar1->kodeorg . "','sisa" . $no . "')>\r\n\t\t\t\t\t <img src='images/addplus.png' title='" . $_SESSION['lang']['tambah'] . "' class=resicon onclick=\"tambahData('" . $bar1->periodecuti . "','" . $bar1->karyawanid . "','" . $bar1->kodeorg . "','" . $bar1->namakaryawan . "','" . $sisacuti . "');\">\r\n\t\t\t\t\t </td>\r\n\t\t\t\t</tr>\t \r\n\t\t\t\t\t ";
}
}
if (!empty($data[8])) {
$outarray[] = "bio" . "," . $data[8] . $datum;
adddate($datum, $data[8], "BIO");
}
if (!empty($data[9])) {
$outarray[] = "bio" . "," . $data[9] . $datum;
adddate($datum, $data[9], "BIO");
}
if (!empty($data[10])) {
$outarray[] = "gs" . "," . $data[10] . $datum;
adddate($datum, $data[10], "GS");
}
// there is a cr at the end of the line, special treatment:
if (intval($data[11]) > 0) {
$outarray[] = "ak" . "," . intval($data[11]) . $datum;
adddate($datum, $data[11], "AK");
}
}
}
// out to terminal
echo implode("\n", $outarray);
// output to file
$fout = fopen($outputfile, "w");
fwrite($fout, implode("\n", $outarray));
fclose($fout);
echo "\nend\n Written: " . $outputfile . "\n";
// Part 2: json
$arrtrashtypes = array("GB" => array("shortname" => "GB", "fullname" => "Restmüll (grauer und blauer Deckel)", "icon" => "ic_bins_grged", "color" => ""), "GG" => array("shortname" => "GG", "fullname" => "Restmüll (grauer und blauer Deckel)", "icon" => "ic_bins_grbld", "color" => ""), "BIO" => array("shortname" => "BIO", "fullname" => "Biomüll und Altpapier", "icon" => "ic_bins_bio", "color" => ""), "AK" => array("shortname" => "AK", "fullname" => "Altkleidersammlung", "icon" => "ic_bins_ak", "color" => ""), "GS" => array("shortname" => "GS", "fullname" => "Gelber Sack / Grüne Tonne", "icon" => "ic_bins_gs", "color" => ""));
$arrregions = array();
function addstreet($streetname, $region, $comment)
{
<input type="hidden" name="aksi" value="cari_data" />
<input type="hidden" name="module" value="kartu_pembimbing" />
</form>
<div class="clearfix"></div>
<?php
if ($_GET['aksi'] == 'cari_data') {
$tgl1 = __convert_date($_GET['tgl1']);
$kd_pembimbing = $_GET['kd_pembimbing'];
$sql2 = "SELECT * from dokter_pembimbing where id_dokter_pembimbing='{$_GET['kd_pembimbing']}'";
//echo $sql2;
$query2 = mysql_query($sql2);
$d2 = mysql_fetch_array($query2);
$tgl2 = adddate($tgl1, "+1 day");
$tgl3 = adddate($tgl1, "+2 day");
$tgl4 = adddate($tgl1, "+3 day");
$tgl5 = adddate($tgl1, "+4 day");
$date1 = get_date($tgl1);
$date2 = get_date($tgl2);
$date3 = get_date($tgl3);
$date4 = get_date($tgl4);
$date5 = get_date($tgl5);
echo "\n <hr>\n <center><h4>Rincian Kegiatan Pembimbing Klinik</h4></center><br>\n Tanggal : <b>" . tgl_indo($tgl1) . "</b> s.d. <b>" . tgl_indo($tgl5) . "</b><br><br>\n <button class=btn id='cetak'> Cetak</button>\n <table class='table table-bordered table-mod-2'>\n <tr>\n <th rowspan='2' scope='col'>No</th>\n <th rowspan='2' scope='col'>Kegiatan</th>\n <th scope='col'>" . convert_hari($tgl1) . "</th>\n <th scope='col'>" . convert_hari($tgl2) . "</th>\n <th scope='col'>" . convert_hari($tgl3) . "</th>\n <th scope='col'>" . convert_hari($tgl4) . "</th>\n <th scope='col'>" . convert_hari($tgl5) . "</th>\n <th rowspan='2' scope='col'>Jumlah</th>\n </tr>\n <tr>\n <td align='center'>{$date1}</td>\n <td align='center'>{$date2}</td>\n <td align='center'>{$date3}</td>\n <td align='center'>{$date4}</td>\n <td align='center'>{$date5}</td>\n </tr>";
$sql = "SELECT * from kegiatan order by nm_kegiatan asc";
$query = mysql_query($sql);
$no = 1;
while ($d = mysql_fetch_array($query)) {
echo "<tr>\n <td align='center' width='10%'>{$no}</td>\n <td width='40%'>{$d['nm_kegiatan']}</td>\n <td align='center'width='8%'> </td>\n <td align='center'width='8%'> </td>\n <td align='center'width='8%'> </td>\n <td align='center'width='8%'> </td>\n <td align='center'width='8%'> </td>\n <td align='center'width='10%'> </td>\n </tr>";
$no++;
}
echo "</table>\n\n\n <br><br><br><br>\n <div style='float:right'><u><b>({$d2['nama']})</b></u></div>\n <div class='clearfix'></div>\n </div>\n \n </div>";
}
function captacoes_carteira($data_inicio_de, $data_inicio_ate)
{
include "config.php";
if ($data_inicio_de != '01/01/1900') {
$data_inicio = data($data_inicio_de);
} else {
$data_inicio = adddate(date("Y-m-d"), "-1 year");
}
if ($data_inicio_ate != '31/12/9999') {
$data_fim = data($data_inicio_ate);
} else {
$data_fim = date("Y-m-d");
}
$select_carteira = "\tSELECT\n\t\t\t\t\t\tmax(captacao_cartas_baixas.cod_carteira) as cod_carteira,\n\t\t\t\t\t\tcad_carteiras.nome_carteira\n\t\t\t\t\t\t\n\t\t\t\t\tfrom\n\t\t\t\t\t\t" . $schema . ".captacao_cartas_baixas,\n\t\t\t\t\t\t" . $schema . ".cad_carteiras\n\t\t\t\t\t\t\n\t\t\t\t\twhere\n\t\t\t\t\t\tcad_carteiras.cod_empresa=" . $_SESSION['cod_empresa'] . " and\n\t\t\t\t\t\t(captacao_cartas_baixas.data_baixa between '" . $data_inicio . "' and '" . $data_fim . "') and\n\t\t\t\t\t\tcaptacao_cartas_baixas.cod_carteira=cad_carteiras.cod_carteira\n\t\t\t\t\t\t\n\t\t\t\t\tgroup by\n\t\t\t\t\t\tnome_carteira\n\t\t\t\t\t\t\n\t\t\t\t\torder by\n\t\t\t\t\t\tnome_carteira;\n\t\t\t\t";
$cod_carteira = '';
$serie = '';
$filtro = '';
$campos = '';
$n = 0;
$resultado_carteira = mysql_query($select_carteira, $conexao) or die(mysql_error());
while ($row_carteira = mysql_fetch_array($resultado_carteira)) {
$filtro .= "\n\n\t\t\t\tleft join(select cod_carteira, sum(valor_baixa) as valor_baixa, year(data_baixa) as ano, month(data_baixa) as mes\n\t\t\t\tfrom\n\t\t\t\t" . $schema . ".captacao_cartas_baixas\n\n\t\t\t\twhere\n\t\t\t\t(data_baixa between '" . $data_inicio . "' and '" . $data_fim . "') and\n\t\t\t\tcod_carteira=" . $row_carteira['cod_carteira'] . "\n\t\t\t\tgroup by cod_carteira,ano,mes\n\n\t\t\t\torder by cod_carteira,ano,mes) as conta_" . $row_carteira['cod_carteira'] . " on conta_" . $row_carteira['cod_carteira'] . ".ano=cad_datas.ano and conta_" . $row_carteira['cod_carteira'] . ".mes=cad_datas.mes ";
$campos .= ", IFNULL(conta_" . $row_carteira['cod_carteira'] . ".valor_baixa,0) as `" . $row_carteira['cod_carteira'] . "-" . $row_carteira['nome_carteira'] . "` ";
$n = $n + 1;
}
$baixas = "\n\t\t\t\n\t\t\t\n\t\t\t\tselect cad_datas.ano, cad_datas.mes " . $campos . "\n\t\t\t\tfrom cad_datas\n\n\t\t\t\t" . $filtro . "\t\t\t\n\t\t\t\t\n\n\t\t\t\twhere data between '" . $data_inicio . "' and '" . $data_fim . "'\n\t\t\t\tgroup by ano,mes\n\t\t\t\torder by ano,mes\n\t\t\t\n\n\n\t\t\t\t\t";
$serie_baixa = '';
$ano_mes = '';
$data = '';
$colunas = '
{ headerText: "ano", key: "ano", dataType: "int", width: "10%" },
{ headerText: "mes", key: "mes", dataType: "int", width: "10%" },';
for ($i = 2; $i <= $n + 1; $i++) {
$serie_baixa[$i] = "";
}
$resultado_baixas = mysql_query($baixas, $conexao) or die(mysql_error());
while ($row_baixas = mysql_fetch_array($resultado_baixas)) {
$data .= '{"ano":"' . $row_baixas['ano'] . '","mes":"' . $row_baixas['mes'] . '",';
for ($i = 2; $i <= $n + 1; $i++) {
$serie_baixa[$i] .= $row_baixas[$i] . ",";
$data .= '"' . str_replace("(", "", str_replace(")", "", str_replace("-", "", str_replace(".", "", str_replace(" ", "_", mysql_field_name($resultado_baixas, $i)))))) . '":"' . $row_baixas[$i] . '",';
}
$data .= "},\n\t\t\t\t";
$ano_mes .= '"' . $row_baixas['ano'] . '-' . $row_baixas['mes'] . '",';
}
for ($i = 2; $i <= $n + 1; $i++) {
$colunas .= '
{ headerText: "' . mysql_field_name($resultado_baixas, $i) . '", key: "' . str_replace("(", "", str_replace(")", "", str_replace("-", "", str_replace(".", "", str_replace(" ", "_", mysql_field_name($resultado_baixas, $i)))))) . '", format: "currency", width: "20%" },';
}
$n = 2;
$resultado_carteira = mysql_query($select_carteira, $conexao) or die(mysql_error());
while ($row_carteira = mysql_fetch_array($resultado_carteira)) {
$serie .= "\n\t\t\t\t\t\t{\n\t\t\t\t\t\tname: '" . $row_carteira['nome_carteira'] . "',\n\t\t\t\t\t\tdata: [" . $serie_baixa[$n] . "]\n\t\t\t\t\t\t},";
$n = $n + 1;
}
echo '
<div class="tm-grid-truncate uk-text-center">
<div class="tm-top-a uk-grid tm-grid-block uk-panel-box" style="padding: 10px;">
<div class="uk-width-1-1">
<div id="grafico" style="width: 100%;height: 800px; margin: 0 auto"></div>
</div>
<div class="uk-width-1-1" style="">
<div id="grid"></div>
</div>
</div>
</div>
<script type="text/javascript">
$(function () {
$("#grafico").highcharts({
title: {
text: "Recebimentos por carteira",
x: -20 //center
},
subtitle: {
text: "total de recebimentos mensais",
x: -20
},
xAxis: {
categories: [' . $ano_mes . ']
},
yAxis: {
title: {
text: "Reais (R$)"
},
plotLines: [{
value: 0,
width: 1,
color: "#808080"
}]
},
plotOptions: {
line: {
dataLabels: {
enabled: false
},
enableMouseTracking: true
}
},
tooltip: {
valueSuffix: "R$",
shared: true,
crosshairs: true
},
series: [' . $serie . ']
});
});
$(function () {
$("#grid").igGrid({
height: "100%",
autoGenerateColumns: false,
width: "100%",
columns: [' . $colunas . '],
dataSource: [' . $data . '],
features: [
{
name: "Filtering",
type: "local",
mode: "advanced",
filterDialogContainment: "window"
},
{
name: "Resizing"
},
{
name: "ColumnMoving",
columnMovingDialogContainment: "window"
}
]
});
});
function groupByFirstLetter(columnSetting, val1, val2) {
if (val1 !== null && val2 !== null && val1.substring(0, 1000) === val2.substring(0, 1000)) {
columnSetting.customGroupName = val1.substring(0, 1000);
return true;
} else if (val1 !== null && val2 !== null && val1.substring(0, 1000) !== val2.substring(0, 1000)) {
columnSetting.customGroupName = val1.substring(0, 1000);
return false;
} else if (val1 === null && val2 !== null) {
columnSetting.customGroupName = val2.substring(0, 1000);
return false;
} else if (val1 !== null && val2 === null) {
columnSetting.customGroupName = val1.substring(0, 1000);
return false;
}
return false;
}
</script>
';
}
