function Tambah($tabelname, $attrib, $pesan) { $command = bukainput("INSERT INTO " . $tabelname . " VALUES (" . $attrib . ")"); echo "<img src='images/simpan.gif' /> Data {$pesan} berhasil disimpan"; return $command; }
function Tambah2($tabelname, $attrib) { $command = bukainput("INSERT INTO " . $tabelname . " VALUES (" . $attrib . ")"); return $command; }
$hasilpassum = bukaquery($_sqlpassum); $barispassum = mysql_fetch_array($hasilpassum); $indexpassum = $barispassum[0]; if (!empty($indexpassum)) { $_sqlpas = "******" . $tahun . "' and bln='" . $bulanindex . "'"; $hasilpas = bukaquery($_sqlpas); $barispas = mysql_fetch_array($hasilpas); $indexpas = $barispas[0]; } $ttlindex = $total + $indexjaga + $indexpas; $_sqltambahan = "SELECT ({$ttlindex}/sum(indextotal.ttl))*((indexins.persen/100)*total_insentif) \n * ({$baristambahan['12']}/100)\n from indextotal,indexins,set_insentif where\n set_insentif.tahun='{$tahun}' and set_insentif.bulan='{$bulanindex}' and\n indextotal.kdindex=indexins.dep_id and\n indextotal.kdindex='{$baristambahan['6']}'"; $hasilpotongan = bukaquery($_sqltambahan); $barispotongan = mysql_fetch_array($hasilpotongan); $ttlpotongan = $barispotongan[0]; if ($action != "CARI") { bukainput("insert into tambahanpotongan values('{$baristambahan['6']}','{$ttlpotongan}')"); } } } $ttlgapok = 0; $ttltnjjbtn = 0; $ttltnjtnj = 0; $ttltmbhjgmlm = 0; $ttltmbahanjg = 0; $ttltnjhadir = 0; $ttljmlgaji = 0; $ttllemburhb = 0; $ttllemburhr = 0; $ttltotal = 0; $ttlindexjaga = 0; $ttlttlinsentif = 0;
} } //insert data ke total index $hasilindex = bukaquery("select kdindex,n,ttl from indekref"); //untuk mencari nilai referensinya if ($action != "CARI") { hapusinput("delete from indextotal"); } while ($barisindex = mysql_fetch_array($hasilindex)) { $_sql22 = "SELECT ({$barisindex['1']}/sum(n))*100 from indekref where kdindex='{$barisindex['0']}'"; $hasil22 = bukaquery($_sql22); $baris22 = mysql_fetch_array($hasil22); $indexjaga = $baris22[0]; $ttlindex = $barisindex[2] + $indexjaga; if ($action != "CARI") { bukainput("insert into indextotal values('{$barisindex['0']}','{$ttlindex}')"); } } $ttlgapok = 0; $ttltnjjbtn = 0; $ttltnjtnj = 0; $ttltmbhjgmlm = 0; $ttltmbahanjg = 0; $ttltnjhadir = 0; $ttljmlgaji = 0; $ttllemburhb = 0; $ttllemburhr = 0; $ttltotal = 0; $ttlindexjaga = 0; $ttlttlinsentif = 0; $ttljm = 0;