PHP updategaji Examples

Example #1

File: input_penggajian_bekasi.input.php Project: smilescripts/pegawai_consina

$getcek = mysql_fetch_object($cek);
$data_baru = "";
$data_input = "";
if ($getcek == "") {
    $data_input = "good";
    $data_baru = "SIMPAN";
    $aksi = "Berhasil melakukan proses penggajian karyawan harian bekasi";
    catat($user, $aksi);
} else {
    $pengaturan32 = mysql_fetch_array(mysql_query("SELECT VALUE FROM pengaturan_penggajian WHERE ID='9'"));
    $data32 = mysql_fetch_array(mysql_query("SELECT kode_penggajian,DATE_ADD(tanggal_gaji,INTERVAL " . $pengaturan32['VALUE'] . " DAY) AS cktgl FROM head_penggajian WHERE start='{$startp}' AND end='{$endp}' and format='Harian Bekasi'"));
    $datenow32 = date("Y-m-d");
    if ($data32["cktgl"] >= $datenow32) {
        $data_input = "good";
        $data_baru = "ubah";
        updategaji($startp, $endp, "Harian Bekasi");
        $aksi = "Berhasil melakukan proses perubahan penggajian karyawan harian bekasi";
        catat($user, $aksi);
    } else {
        $data_input = "";
        $data_baru = "gagal";
        $aksi = "gagal melakukan proses penggajian karyawan harian bekasi";
        catat($user, $aksi);
    }
}
function selisihHari($tglAwal, $tglAkhir)
{
    $tglLibur = array("2015-08-05", "2013-01-05", "2013-01-17");
    $tahun = $TAHUN;
    $bulanini = $BULAN;
    $libur1 = mysql_query("select * from hari_libur where BULAN='{$bulanini}' and TAHUN='{$tahun}'");

Example #2

File: input_penggajian_outlet.input.php Project: smilescripts/pegawai_consina

$getcek = mysql_fetch_object($cek);
$data_baru = "";
$data_input = "";
if ($getcek == "") {
    $data_input = "good";
    $data_baru = "SIMPAN";
    $aksi = "Berhasil melakukan proses penggajian karyawan bulanan outlet";
    catat($user, $aksi);
} else {
    $pengaturan32 = mysql_fetch_array(mysql_query("SELECT VALUE FROM pengaturan_penggajian WHERE ID='9'"));
    $data32 = mysql_fetch_array(mysql_query("SELECT kode_penggajian,DATE_ADD(tanggal_gaji,INTERVAL " . $pengaturan32['VALUE'] . " DAY) AS cktgl FROM head_penggajian WHERE start='{$startp}' AND end='{$endp}' and format='Outlet'"));
    $datenow32 = date("Y-m-d");
    if ($data32["cktgl"] >= $datenow32) {
        $data_input = "good";
        $data_baru = "ubah";
        updategaji($startp, $endp, "Outlet");
        $aksi = "Berhasil melakukan proses perubahan penggajian karyawan bulanan outlet";
        catat($user, $aksi);
    } else {
        $data_input = "";
        $data_baru = "gagal";
        $aksi = "Gagal melakukan proses penggajian karyawan bulanan outlet";
        catat($user, $aksi);
    }
}
$tipe = "SIMPAN";
if ($data_baru != "gagal") {
    $getpegawai = mysql_query("select * from pegawai where (STATUS_PEGAWAI='Tetap' and STATUS_PEGAWAI!='Keluar') and OUTLET='YA'");
    while ($datapegawai = mysql_fetch_object($getpegawai)) {
        $totalgaji = 0;
        $totaljam = 0;

Example #3

File: input_penggajian_bulanan.input.php Project: smilescripts/consina_project

$getcek = mysql_fetch_object($cek);
$data_baru = "";
$data_input = "";
if ($getcek == "") {
    $data_input = "good";
    $data_baru = "SIMPAN";
    $aksi = "Berhasil melakukan proses penggajian karyawan bulanan Office";
    catat($user, $aksi);
} else {
    $pengaturan32 = mysql_fetch_array(mysql_query("SELECT VALUE FROM pengaturan_penggajian WHERE ID='9'"));
    $data32 = mysql_fetch_array(mysql_query("SELECT kode_penggajian,DATE_ADD(tanggal_gaji,INTERVAL " . $pengaturan32['VALUE'] . " DAY) AS cktgl FROM head_penggajian WHERE start='{$startp}' AND end='{$endp}' and format='Bulanan'"));
    $datenow32 = date("Y-m-d");
    if ($data32["cktgl"] >= $datenow32) {
        $data_input = "good";
        $data_baru = "ubah";
        updategaji($startp, $endp, "Bulanan");
        $aksi = "Berhasil melakukan proses perubahan penggajian karyawan bulanan Office";
        catat($user, $aksi);
    } else {
        $data_input = "";
        $data_baru = "gagal";
        $aksi = "Gagal melakukan proses penggajian karyawan bulanan Office";
        catat($user, $aksi);
    }
}
$tipe = "SIMPAN";
if ($data_baru != "gagal") {
    $getpegawai = mysql_query("select * from pegawai where (STATUS_PEGAWAI='Tetap' and STATUS_PEGAWAI!='Keluar') and OUTLET!='YA'");
    while ($datapegawai = mysql_fetch_object($getpegawai)) {
        $totalgaji = 0;
        $totaljam = 0;

Example #4

File: input_penggajian.input.php Project: smilescripts/pegawai_consina

$getcek = mysql_fetch_object($cek);
$data_baru = "";
$data_input = "";
if ($getcek == "") {
    $data_input = "good";
    $data_baru = "SIMPAN";
    $aksi = "Berhasil melakukan proses penggajian karyawan harian buaran";
    catat($user, $aksi);
} else {
    $pengaturan32 = mysql_fetch_array(mysql_query("SELECT VALUE FROM pengaturan_penggajian WHERE ID='9'"));
    $data32 = mysql_fetch_array(mysql_query("SELECT kode_penggajian,DATE_ADD(tanggal_gaji,INTERVAL " . $pengaturan32['VALUE'] . " DAY) AS cktgl FROM head_penggajian WHERE start='{$startp}' AND end='{$endp}' and format='Harian'"));
    $datenow32 = date("Y-m-d");
    if ($data32["cktgl"] >= $datenow32) {
        $data_input = "good";
        $data_baru = "ubah";
        updategaji($startp, $endp, "Harian");
        $aksi = "Berhasil melakukan proses perubahan penggajian karyawan harian buaran";
        catat($user, $aksi);
    } else {
        $data_input = "";
        $data_baru = "gagal";
        $aksi = "Gagal melakukan proses penggajian karyawan harian";
        catat($user, $aksi);
    }
}
function selisihHari($tglAwal, $tglAkhir)
{
    $tglLibur = array("2015-08-05", "2013-01-05", "2013-01-17");
    $tahun = $TAHUN;
    $bulanini = $BULAN;
    $libur1 = mysql_query("select * from hari_libur where BULAN='{$bulanini}' and TAHUN='{$tahun}'");