{ $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> '; }