GetIndex(); break; //xu ly dang nhap //xu ly dang nhap case 'login': PostLogin($_POST['username'], $_POST['password']); break; //xu ly dang xuat //xu ly dang xuat case 'logout': GetLogout(); break; //xu ly dem cac san pham trong csdl //xu ly dem cac san pham trong csdl case 'count': GetTotal((int) $_GET["items"], (int) $_GET["categoryID"]); break; //xu ly lay danh sach san pham trong csdl //xu ly lay danh sach san pham trong csdl case 'list': PostList((int) $_POST["items"], (int) $_POST["currentPage"], (int) $_POST["categoryID"]); break; //xu ly lay mot san pham trong csdl //xu ly lay mot san pham trong csdl case 'element': GetElement((int) $_GET["id"]); break; //xu ly them san pham vao gio hang //xu ly them san pham vao gio hang case 'addcart': AddItem((int) $_POST['id'], $_POST['name_pro'], $_POST['name_cat'], $_POST['img'], $_POST['price_vnd'], $_POST['price_usd'], $_POST['price_off'], $_POST['amount'], $_POST['unit_name']);
function TampilkanLaporan() { global $_lf; $stat = !empty($_SESSION['status']) ? "and k.StatusMhswID = '{$_SESSION['status']}'" : "and k.StatusMhswID in ('P','A','C')"; $whr = array(); if (!empty($_SESSION['prid'])) { $whr[] = "k.ProgramID='{$_SESSION['prid']}'"; } if (!empty($_SESSION['prodi'])) { $whr[] = "k.ProdiID='{$_SESSION['prodi']}'"; } if (!empty($_SESSION['DariNPM']) && !empty($_SESSION['SampaiNPM'])) { $whr[] = "'{$_SESSION['DariNPM']}' <= k.MhswID and k.MhswID <= '{$_SESSION['SampaiNPM']}'"; } $_whr = implode(' and ', $whr); $_whr = empty($_whr) ? '' : " and {$_whr} "; $hut = $_SESSION['hut']; $kode = $hut == -1 ? ">" : "<"; $strtotal = $hut == -1 ? "Hutang" : "Kelebihan"; $s = "select k.TahunID, k.MhswID, k.ProgramID, k.ProdiID,\r\n k.SaldoAwal, k.Biaya, k.Potongan, k.Bayar, k.Tarik,\r\n k.TotalSKS, k.JumlahMK, k.IPS, k.IP,\r\n (k.Biaya -k.Bayar +k.Tarik -k.Potongan) as BAL,\r\n (-k.Biaya +k.Bayar -k.Tarik +k.Potongan) as LBH,\r\n LEFT(m.Nama, 30) as Nama, k.StatusMhswID\r\n from khs k\r\n left outer join mhsw m on m.MhswID=k.MhswID\r\n where k.TahunID='{$_SESSION['tahun']}'\r\n and k.KodeID='{$_SESSION['KodeID']}' \r\n \r\n {$stat}\r\n {$_whr}\r\n order by k.MhswID"; $r = _query($s); $nmf = HOME_FOLDER . DS . "tmp/{$_SESSION['_Login']}.keu.dwoprn"; $f = fopen($nmf, 'w'); $mxc = 90; $mxb = 50; $grs = str_pad('-', $mxc, '-') . $_lf; fwrite($f, chr(27) . chr(15)); // buat header $_prodi = empty($_SESSION['prodi']) ? "Semua Prodi" : GetaField('prodi', 'ProdiID', $_SESSION['prodi'], "Nama"); $_prid = empty($_SESSION['prid']) ? "Semua Program" : GetaField('program', 'ProgramID', $_SESSION['prid'], "Nama"); $_rentang = !empty($_SESSION['DariNPM']) && !empty($_SESSION['SampaiNPM']) ? "Rentang : {$_SESSION['DariNPM']} s.d {$_SESSION['SampaiNPM']}" . $_lf : ''; $judul = $hut == -1 ? "Berhutang" : "Kelebihan Bayar"; $hdr = str_pad("** Daftar Mahasiswa yg {$judul} **", $mxc, ' ', STR_PAD_BOTH) . $_lf . $_lf . "Tahun : " . NamaTahun($_SESSION['tahun']) . $_lf . "Program : {$_prid} " . $_lf . "Prodi : {$_prodi}" . $_lf . $_rentang . $grs . str_pad('No.', 5) . str_pad('N.P.M', 12) . str_pad('Nama Mahasiswa', 32) . "Ambil SKS STATUS" . str_pad('Jumlah', 15, ' ', STR_PAD_LEFT) . $_lf . $grs; fwrite($f, $hdr); // tuliskan $n = 0; $b = 0; $tot = 0; $hal = 1; while ($w = _fetch_array($r)) { $TOTSS = GetTotal($w['MhswID'], $_SESSION['tahun']) - GetBayar($w['MhswID'], $_SESSION['tahun']) - GetPot($w['MhswID'], $_SESSION['tahun']); if ($TOTSS > 0 and $hut == -1) { $TOTSS = number_format($TOTSS); if ($b >= $mxb) { $b = 0; $tgl = date('d-m-Y H:i'); fwrite($f, "Dicetak oleh {$_SESSION['_Login']}, {$tgl}" . $_lf); fwrite($f, chr(12)); fwrite($f, $hdr); } $n++; $b++; $tot += $hut == -1 ? $w['BAL'] : $w['LBH']; $_bal = $hut == -1 ? $w['BAL'] : $w['LBH']; $bal = number_format($_bal); fwrite($f, str_pad($n, 5) . str_pad($w['MhswID'], 12) . str_pad($w['Nama'], 32) . str_pad($w['JumlahMK'], 5, ' ', STR_PAD_LEFT) . str_pad($w['TotalSKS'], 5, ' ', STR_PAD_LEFT) . str_pad($w['StatusMhswID'], 7, ' ', STR_PAD_LEFT) . str_pad($TOTSS, 17, ' ', STR_PAD_LEFT) . $_lf); } else { if ($TOTSS < 0 and $hut == 1) { $TOTSS = number_format($TOTSS * -1); if ($b >= $mxb) { $b = 0; $tgl = date('d-m-Y H:i'); fwrite($f, "Dicetak oleh {$_SESSION['_Login']}, {$tgl}" . $_lf); fwrite($f, chr(12)); fwrite($f, $hdr); } $n++; $b++; $tot += $hut == -1 ? $w['BAL'] : $w['LBH']; $_bal = $hut == -1 ? $w['BAL'] : $w['LBH']; $bal = number_format($_bal); fwrite($f, str_pad($n, 5) . str_pad($w['MhswID'], 12) . str_pad($w['Nama'], 32) . str_pad($w['JumlahMK'], 5, ' ', STR_PAD_LEFT) . str_pad($w['TotalSKS'], 5, ' ', STR_PAD_LEFT) . str_pad($w['StatusMhswID'], 7, ' ', STR_PAD_LEFT) . str_pad($TOTSS, 17, ' ', STR_PAD_LEFT) . $_lf); } } } $_tot = number_format($tot); fwrite($f, $grs); fwrite($f, str_pad("Total {$strtotal} : ", 68, ' ', STR_PAD_LEFT) . str_pad($_tot, 15, ' ', STR_PAD_LEFT) . $_lf); fwrite($f, $grs); fwrite($f, str_pad("Dicetak Oleh : {$_SESSION['_Login']}, " . date("d-m-Y H:i"), 60) . str_pad("Akhir Laporan", 100) . $_lf); fwrite($f, chr(27) . chr(12)); fclose($f); TampilkanFileDWOPRN($nmf, 'keu.lap'); }