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;
