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;
}
Example #3
0
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>";
}
Example #4
0
            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') {