function createEmailFromTemplate($templateName, $user, $data = null) { global $APP_DIR; $email_config = getConfig("_email"); if (!$email_config || !$templateName || !$user) { return null; } $templateDir = $email_config["templates"]; $template = readTextFile("{$APP_DIR}/{$templateDir}/{$templateName}.html"); if (!$template) { return null; } $name = is_string($user) ? substringBefore($user, "@") : $user["first_name"] . " " . $user["last_name"]; $to_email = is_string($user) ? $user : $user["email"]; if (isset($email_config["to"])) { $to_email = $email_config["to"]; } $logo = combine($email_config["baseUrl"], getConfig("app.logo")); $cfg = array("site" => getConfig("defaultTitle"), "baseUrl" => $email_config["baseUrl"], "logo" => $logo, "name" => $name, "to" => $to_email); $template = replaceVariables($template, $cfg); $template = replaceVariables($template, $user); $template = replaceVariables($template, $data); $subject = substringBefore($template, "\n"); $body = substringAfter($template, "\n"); //replace classes with inlineStyles $styles = readConfigFile("{$APP_DIR}/{$templateDir}/inline.css"); if ($styles) { $body = "<div class=\"fp-email\">{$body}</div>"; $body = inlineStyles($body, $styles); } debug("createEmail subject", $subject); debug("createEmail body", $body); return createEmail($to_email, $subject, $body, true); }
<?php //@Copy nangkoelframework require_once 'master_validation.php'; include 'lib/nangkoelib.php'; require_once 'config/connection.php'; $kodeorg = $_POST['kodeorg']; $periode = $_POST['periode']; $tipekaryawan = $_POST['tipekaryawan']; // ambil data jatah cuti $x = readTextFile('config/jumlahcuti.lst'); if (intval($x) > 0) { $hakcuti = $x; } else { $hakcuti = 12; } if ($_SESSION['empl']['tipelokasitugas'] != 'HOLDING') { $str1 = "select a.*,b.namakaryawan,b.tanggalmasuk,b.lokasitugas as locTugas,b.tipekaryawan,b.nik,c.tipe,\r\n\t COALESCE(ROUND(DATEDIFF('" . $tglAbis . "',b.tanggalmasuk)/365.25,3),0) as masakerja\r\n\t from " . $dbname . ".sdm_cutiht a\r\n\t\t left join " . $dbname . ".datakaryawan b on a.karyawanid=b.karyawanid \r\n\t\t left join " . $dbname . ".sdm_5tipekaryawan c on b.tipekaryawan = c.id \r\n\t where b.lokasitugas='" . $kodeorg . "' and b.alokasi=0\r\n\t\t and (a.periodecuti='" . $periode . "' or a.periodecuti='" . ($periode - 1) . "')\r\n and b.tanggalkeluar='0000-00-00' and b.tipekaryawan in(0,1,2,3) and b.tipekaryawan like '%" . $tipekaryawan . "%'"; } else { $str1 = "select a.*,b.namakaryawan,b.tanggalmasuk,b.lokasitugas as locTugas,b.tipekaryawan,b.nik,c.tipe,\r\n\t COALESCE(ROUND(DATEDIFF('" . $tglAbis . "',b.tanggalmasuk)/365.25,3),0) as masakerja\r\n\t from " . $dbname . ".sdm_cutiht a\r\n\t\t left join " . $dbname . ".datakaryawan b on a.karyawanid=b.karyawanid \r\n\t\t left join " . $dbname . ".sdm_5tipekaryawan c on b.tipekaryawan = c.id \r\n\t where b.lokasitugas='" . $kodeorg . "' and b.alokasi=1\r\n\t\t and (a.periodecuti='" . $periode . "' or a.periodecuti='" . ($periode - 1) . "')\r\n and b.tanggalkeluar='0000-00-00' and b.tipekaryawan in(0,1,2,3) and b.tipekaryawan like '%" . $tipekaryawan . "%'"; } $res1 = mysql_query($str1); echo "<table class=sortable cellspacing=1 border=0>\r\n\t <thead>\r\n\t\t <tr class=rowheader>\r\n\t\t <td style='text-align:center;'>No</td>\r\n\t\t\t<td style='text-align:center;'>" . $_SESSION['lang']['kodeorganisasi'] . "</td>\t\t \r\n\t\t <td style='text-align:center;'>" . $_SESSION['lang']['nik'] . "</td>\r\n\t\t <td style='text-align:center;'>" . $_SESSION['lang']['namakaryawan'] . "</td>\r\n\t\t <td style='text-align:center;'>" . $_SESSION['lang']['tipekaryawan'] . "</td>\r\n\t\t\t<td style='text-align:center;'>" . $_SESSION['lang']['tanggalmasuk'] . "</td>\r\n\t\t\t<td style='text-align:center;'>Masa Kerja (Tahun-Bulan)</td>\t\t\t\r\n\t\t\t<td style='text-align:center;'>" . $_SESSION['lang']['periode'] . "</td>\t\t\t\r\n\t\t\t<td style='text-align:center;'>" . $_SESSION['lang']['dari'] . "</td>\r\n\t\t\t<td style='text-align:center;'>" . $_SESSION['lang']['tanggalsampai'] . "</td>\r\n\t\t\t<td style='text-align:center;'>" . $_SESSION['lang']['hakcuti'] . "</td>\r\n\t\t\t<td style='text-align:center;'>" . $_SESSION['lang']['diambil'] . " (Hari)</td>\r\n\t\t\t<td style='text-align:center;'>" . $_SESSION['lang']['sisa'] . "</td>\r\n\t\t\t</tr>\r\n\t\t </thead>\r\n\t\t <tbody id=container>"; $no = 0; //Get RangeTanggal function getRangeTanggal($tglAwal, $tglAkhir) { $jlh = strtotime($tglAkhir) - strtotime($tglAwal); $jlhHari = $jlh / (3600 * 24); return $jlhHari + 1; }
if (substr($_SESSION['empl']['lokasitugas'], 2, 2) == 'HO') { $str = " select karyawanid,namakaryawan,bagian,subbagian,lokasitugas,tipekaryawan from " . $dbname . ".datakaryawan\r\n where (tanggalkeluar = '0000-00-00' or tanggalkeluar > '" . date("Y-m-d") . "') and tipekaryawan in ('0','7','8') order by namakaryawan"; } else { if ($_SESSION['empl']['tipelokasitugas'] == 'KANWIL') { $str = " select karyawanid,namakaryawan,bagian,subbagian,lokasitugas,tipekaryawan from " . $dbname . ".datakaryawan\r\n where left(lokasitugas,4) in(select kodeunit from " . $dbname . ".bgt_regional_assignment\r\n where regional='" . $_SESSION['empl']['regional'] . "') and tipekaryawan in(1,2,3,6)"; } else { $str = " select karyawanid,namakaryawan,bagian,subbagian,lokasitugas,tipekaryawan from " . $dbname . ".datakaryawan\r\n where left(lokasitugas,4)='" . substr($_SESSION['empl']['lokasitugas'], 0, 4) . "'\r\n and tipekaryawan in(1,2,3,6)\r\n order by namakaryawan"; } } $optkar = "<option value=''></option>"; $res = mysql_query($str); while ($bar = mysql_fetch_object($res)) { $optkar .= "<option value='" . $bar->karyawanid . "'>" . $bar->namakaryawan . " | " . $tip[$bar->tipekaryawan] . " | " . $bar->lokasitugas . " | " . $bar->subbagian . "</option>"; } $paragraf3 = readTextFile('config/sp_format/sp_paragraf2_BAPP.lst'); $paragraf4 = readTextFile('config/sp_paragraf4.lst'); //========================= if (substr($_SESSION['empl']['lokasitugas'], 2, 2) == 'HO') { $str = " select kodeorganisasi,namaorganisasi from " . $dbname . ".organisasi \r\n where length(kodeorganisasi)=4"; } else { if ($_SESSION['empl']['tipelokasitugas'] == 'KANWIL') { $str = " select kodeorganisasi,namaorganisasi from " . $dbname . ".organisasi \r\n where kodeorganisasi in(select kodeunit from " . $dbname . ".bgt_regional_assignment\r\n where regional='" . $_SESSION['empl']['regional'] . "')"; } else { $str = " select kodeorganisasi,namaorganisasi from " . $dbname . ".organisasi \r\n where kodeorganisasi='" . $_SESSION['empl']['lokasitugas'] . "'"; } } $rss = mysql_query($str); $optLok = "<option value='%'>" . $_SESSION['lang']['all'] . "</option>"; while ($bar = mysql_fetch_object($rss)) { $optLok .= "<option value='" . $bar->kodeorganisasi . "'>" . $bar->namaorganisasi . "</option>"; }
echo readTextFile('config/sp_format/sp_pelanggaran_ST1.lst') . "###" . readTextFile('config/sp_format/sp_paragraf2_ST1.lst') . "###" . readTextFile('config/sp_format/sp_paragraf3_ST1.lst') . "###" . '' . "###" . $_SESSION['lang']['disetujui'] . "###" . '' . "###" . '' . "###" . $_SESSION['lang']['pelanggaran'] . "###" . 'Paragraf 2' . "###" . 'Paragraf 3' . "###" . 'Paragraf 4'; } else { if ($jenissp == 'SP1') { echo readTextFile('config/sp_format/sp_pelanggaran_ST1.lst') . "###" . readTextFile('config/sp_format/sp_paragraf2_SP1.lst') . "###" . readTextFile('config/sp_format/sp_paragraf3_SP1.lst') . "###" . '' . "###" . $_SESSION['lang']['disetujui'] . "###" . $_SESSION['lang']['diketahuioleh'] . "###" . '' . "###" . $_SESSION['lang']['pelanggaran'] . "###" . 'Paragraf 2' . "###" . 'Paragraf 3' . "###" . 'Paragraf 4'; } else { if ($jenissp == 'SP2') { echo readTextFile('config/sp_format/sp_pelanggaran_ST1.lst') . "###" . readTextFile('config/sp_format/sp_paragraf2_SP2.lst') . "###" . readTextFile('config/sp_format/sp_paragraf3_SP2.lst') . "###" . '' . "###" . $_SESSION['lang']['disetujui'] . "###" . $_SESSION['lang']['diketahuioleh'] . "###" . '' . "###" . $_SESSION['lang']['pelanggaran'] . "###" . 'Paragraf 2' . "###" . 'Paragraf 3' . "###" . 'Paragraf 4'; } else { if ($jenissp == 'SP3') { echo readTextFile('config/sp_format/sp_pelanggaran_ST1.lst') . "###" . readTextFile('config/sp_format/sp_paragraf2_SP3.lst') . "###" . readTextFile('config/sp_format/sp_paragraf3_SP3.lst') . "###" . '' . "###" . $_SESSION['lang']['disetujui'] . "###" . $_SESSION['lang']['diketahuioleh'] . "###" . '' . "###" . $_SESSION['lang']['pelanggaran'] . "###" . 'Paragraf 2' . "###" . 'Paragraf 3' . "###" . 'Paragraf 4'; } else { if ($jenissp == 'SKR') { echo '' . "###" . readTextFile('config/sp_format/sp_paragraf2_SKR.lst') . "###" . readTextFile('config/sp_format/sp_paragraf3_SKR.lst') . "###" . readTextFile('config/sp_format/sp_paragraf4_SKR.lst') . "###" . $_SESSION['lang']['disetujui'] . "###" . '' . "###" . '' . "###" . $_SESSION['lang']['pelanggaran'] . "###" . 'Paragraf 2' . "###" . 'Paragraf 3' . "###" . 'Paragraf 4'; } else { if ($jenissp == 'PHK') { echo '' . "###" . '' . "###" . readTextFile('config/sp_format/sp_paragraf3_PHK.lst') . "###" . readTextFile('config/sp_format/sp_paragraf4_PHK.lst') . "###" . $_SESSION['lang']['disetujui'] . "###" . '' . "###" . '' . "###" . $_SESSION['lang']['membaca'] . "###" . $_SESSION['lang']['menimbang'] . "###" . $_SESSION['lang']['mengingat'] . "###" . $_SESSION['lang']['menetapkan']; } else { echo '' . "###" . '' . "###" . '' . "###" . '' . "###" . $_SESSION['lang']['disetujui'] . "###" . $_SESSION['lang']['diketahuioleh'] . "###" . $_SESSION['lang']['dibuat'] . "###" . $_SESSION['lang']['pelanggaran'] . "###" . 'Paragraf 2' . "###" . 'Paragraf 3' . "###" . 'Paragraf 4'; } } } } } } } } else { if ($method == 'insert') { if ($jenissp == 'BAPP') { $js = 'BAPK'; } else { if ($jenissp == 'ST1') {