API tools faq
paste
Advertisement
aininura

Untitled

aininura
Sep 23rd, 2018
144
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 28.68 KB | None | 0 0
raw download clone embed print report
  1. <?php
  2. session_start();
  3. //set jam
  4. date_default_timezone_set('Asia/Jakarta');
  5. class DataBase{
  6. private $host = "localhost";
  7. private $user = "root";
  8. private $pass = "";
  9. private $db = "inventory_barang";
  10.  
  11. public function sambungkan(){
  12. mysql_connect($this->host,$this->user,$this->pass);
  13. mysql_select_db($this->db);
  14. }
  15. }
  16. //membuat class admin
  17. class Admin{
  18. //method insert data admin
  19. public function simpan_admin($email,$pass,$nama,$gambar){
  20. $namafile = $gambar['name'];
  21. //lokasi sementara
  22. $lokasifile = $gambar['tmp_name'];
  23. //upload
  24. move_uploaded_file($lokasifile, "gambar_admin/$namafile");
  25. //insert
  26. mysql_query("INSERT INTO admin(email,password,nama,gambar) VALUES('$email','$pass','$nama','$namafile')");
  27. }
  28. public function tampil_admin(){
  29. $qry = mysql_query("SELECT * FROM admin");
  30. while ($pecah = mysql_fetch_array($qry)) {
  31. //array
  32. $data[] = $pecah;
  33. }
  34. return $data;
  35. }
  36. public function ambil_admin($id){
  37. $qry = mysql_query("SELECT * FROM admin WHERE kd_admin= '$id'");
  38. $pecah = mysql_fetch_assoc($qry);
  39. return $pecah;
  40. }
  41. public function ubah_admin($email,$pass,$nama,$gambar,$id){
  42. $namafile = $gambar['name'];
  43. $lokasifile = $gambar['tmp_name'];
  44. //mengambil nama gambar sebelumnya untuk di hapus, akan di hapus
  45. //jika form gambar tidak kosong
  46. $ambil = $this->ambil_admin($id);
  47. $gambarhapus = $ambil['gambar'];
  48. if (!empty($lokasifile)) {
  49. //hapus gambar sebelumnya
  50. unlink("gambar_admin/$gambarhapus");
  51. //upload gambar baru
  52. move_uploaded_file($lokasifile, "gambar_admin/$namafile");
  53. //update
  54. mysql_query("UPDATE admin
  55. SET email = '$email', password='$pass', nama='$nama', gambar='$namafile' WHERE kd_admin='$id'");
  56. }
  57. else{
  58. //update tanpa upload gambar
  59. mysql_query("UPDATE admin
  60. SET email = '$email', password='$pass', nama='$nama' WHERE kd_admin='$id'");
  61. }
  62. }
  63. public function hapus_admin($hapus){
  64. //ambil nama gambar yang akan di hapus pada folder gambar
  65. $gbr = $this->ambil_admin($hapus);
  66. $namagbr = $gbr['gambar'];
  67. //hapus
  68. unlink("gambar_admin/$namagbr");
  69. mysql_query("DELETE FROM admin WHERE kd_admin= '$hapus'");
  70. }
  71. public function login_admin($email,$pass){
  72. // mencocokan data di db dengan username dan pass yang di inputkan
  73. $cek = mysql_query("SELECT * FROM admin WHERE email='$email' AND password='$pass'");
  74. //mengambil data orang yang login dan cocok
  75. $data = mysql_fetch_assoc($cek);
  76. // hitung data yang cocok
  77. $cocokan = mysql_num_rows($cek);
  78. //jika akun yang cocok lebih besar dari 0 maka bisa login
  79. if ($cocokan > 0) {
  80. //bisa login
  81. $_SESSION['login_admin']['id'] = $data['kd_admin'];
  82. $_SESSION['login_admin']['email'] = $data['email'];
  83. $_SESSION['login_admin']['nama'] = $data['nama'];
  84. $_SESSION['login_admin']['gambar'] = $data['gambar'];
  85.  
  86. return true;
  87. }// selain itu (akun yang cocok tdk lebih dari 0) maka ggl
  88. else{
  89. return false;
  90. }
  91. }
  92. }
  93. class Barang{
  94. public function tampil_barang(){
  95. $qry = mysql_query("SELECT * FROM barang b
  96. JOIN pembelian p ON b.kd_pembelian = p.kd_pembelian");
  97. while ($pecah = mysql_fetch_array($qry)) {
  98. $data[] = $pecah;
  99. }
  100. return $data;
  101. }
  102. public function simpan_barang($kdbarang,$kdpembelian,$nama,$satuan,$hargaj,$hargab,$stok,$type,$kondisi,$gambar){
  103. mysql_query("INSERT INTO barang(kd_barang,kd_pembelian,nama_barang,satuan,harga_jual,harga_beli,stok,type,kondisi,gambar)
  104. VALUES('$kdbarang','$kdpembelian','$nama','$satuan','$hargaj','$hargab','$stok','$type','$kondisi','$gambar')");
  105. }
  106. public function ubah_barang($nama,$satuan,$hargaj,$hargab,$stok,$kd){
  107. mysql_query("UPDATE barang SET nama_barang='$nama', satuan='$satuan', harga_jual='$hargaj',harga_beli='$hargab',stok='$stok',type='$type',kondisi='$kondisi' WHERE kd_barang = '$kd' ");
  108. }
  109. public function ambil_barang($id){
  110. $qry = mysql_query("SELECT * FROM barang WHERE kd_barang = '$id'");
  111. $pecah = mysql_fetch_assoc($qry);
  112.  
  113. return $pecah;
  114. }
  115. public function hapus_barang($kd){
  116. mysql_query("DELETE FROM barang WHERE kd_barang = '$kd'");
  117. }
  118. public function simpan_barang_gudang($kdbarang,$kdbl){
  119. $dat = $this->ambil_barangpem($kdbl);
  120. $kdpembelian = $dat['kd_pembelian'];
  121. $nama = $dat['nama_barang_beli'];
  122. $satuan = $dat['satuan'];
  123. $hargab = $dat['harga_beli'];
  124. $stok = $dat['item'];
  125. $type = $dat['type'];
  126. $kondisi = $dat['kondisi'];
  127. $gambar = $dat['gambar'];
  128. mysql_query("INSERT INTO barang(kd_barang,kd_pembelian,nama_barang,satuan,harga_beli,stok,type,kondisi,gambar)
  129. VALUES('$kdbarang','$kdpembelian','$nama','$satuan','$hargab','$stok','$type','$kondisi','$gambar')");
  130. //update data barang pembelian dengan setatus 1
  131. mysql_query("UPDATE barang_pembelian SET status='1' WHERE kd_barang_beli ='$kdbl'");
  132. }
  133. public function ambil_barangpem($kd){
  134. $qry = mysql_query("SELECT * FROM barang_pembelian WHERE kd_barang_beli = '$kd'");
  135. $pecah = mysql_fetch_assoc($qry);
  136. return $pecah;
  137. }
  138. }
  139. class Supplier{
  140. public function tampil_supplier(){
  141. $qry = mysql_query("SELECT * FROM supplier");
  142. while ($pecah = mysql_fetch_array($qry)) {
  143. $data[] = $pecah;
  144. }
  145. return $data;
  146. }
  147. public function simpan_supplier($nama,$alamat){
  148. mysql_query("INSERT INTO supplier(nama_supplier,alamat) VALUES('$nama','$alamat')");
  149. }
  150. public function ubah_supplier($nama,$alamat,$id){
  151. mysql_query("UPDATE supplier SET nama_supplier='$nama', alamat='$alamat' WHERE kd_supplier = '$id'");
  152. }
  153. public function hapus_supplier($id){
  154. mysql_query("DELETE FROM supplier WHERE kd_supplier= '$id'");
  155. }
  156. public function ambil_supplier($id){
  157. $qry = mysql_query("SELECT * FROM supplier WHERE kd_supplier= '$id'");
  158. $pecah = mysql_fetch_assoc($qry);
  159. return $pecah;
  160. }
  161. }
  162. class Kategori{
  163. public function tampil_kategori(){
  164. $qry = mysql_query("SELECT * FROM kategori");
  165. while ($pecah = mysql_fetch_array($qry)) {
  166. $data[] = $pecah;
  167. }
  168. return $data;
  169. }
  170. public function simpan_kategori($nama,$alamat){
  171. mysql_query("INSERT INTO kategori(nama_kategori) VALUES('$nama')");
  172. }
  173. public function ubah_kategori($nama,$id){
  174. mysql_query("UPDATE kategori SET nama_kategori='$nama' WHERE kd_kategori = '$id'");
  175. }
  176. public function hapus_kategori($id){
  177. mysql_query("DELETE FROM kategori WHERE kd_kategori= '$id'");
  178. }
  179. public function ambil_kategori($id){
  180. $qry = mysql_query("SELECT * FROM supplier WHERE kd_supplier= '$id'");
  181. $pecah = mysql_fetch_assoc($qry);
  182. return $pecah;
  183. }
  184. }
  185. class Segel{
  186. public function tampil_segel(){
  187. $qry = mysql_query("SELECT * FROM segel");
  188. while ($pecah = mysql_fetch_array($qry)) {
  189. $data[] = $pecah;
  190. }
  191. return $data;
  192. }
  193. public function simpan_segel($nama,$alamat){
  194. mysql_query("INSERT INTO segel(nama_segel) VALUES('$nama')");
  195. }
  196. public function ubah_segel($nama,$id){
  197. mysql_query("UPDATE segel SET nama_segel='$nama' WHERE kd_segel = '$id'");
  198. }
  199. public function hapus_segel($id){
  200. mysql_query("DELETE FROM segel WHERE kd_segel= '$id'");
  201. }
  202. public function ambil_segel($id){
  203. $qry = mysql_query("SELECT * FROM supplier WHERE kd_segel= '$id'");
  204. $pecah = mysql_fetch_assoc($qry);
  205. return $pecah;
  206. }
  207. }
  208.  
  209. class Gudang{
  210. public function tampil_gudang(){
  211. $qry = mysql_query("SELECT * FROM gudang");
  212. while ($pecah = mysql_fetch_array($qry)) {
  213. $data[] = $pecah;
  214. }
  215. return $data;
  216. }
  217. public function simpan_gudang($nama,$alamat){
  218. mysql_query("INSERT INTO gudang(nama_gudang) VALUES('$nama')");
  219. }
  220. public function ubah_gudang($nama,$id){
  221. mysql_query("UPDATE gudang SET nama_gudang='$nama' WHERE kd_gudang = '$id'");
  222. }
  223. public function hapus_gudang($id){
  224. mysql_query("DELETE FROM gudang WHERE kd_gudang= '$id'");
  225. }
  226. public function ambil_gudang($id){
  227. $qry = mysql_query("SELECT * FROM supplier WHERE kd_gudang= '$id'");
  228. $pecah = mysql_fetch_assoc($qry);
  229. return $pecah;
  230. }
  231. }
  232.  
  233.  
  234. class Pembelian{
  235. public function kode_otomatis(){
  236. $qry = mysql_query("SELECT MAX(kd_pembelian) AS kode FROM pembelian");
  237. $pecah = mysql_fetch_array($qry);
  238. $kode = substr($pecah['kode'], 3,5);
  239. $jum = $kode + 1;
  240. if ($jum < 10) {
  241. $id = "W140000".$jum;
  242. }
  243. else if($jum >= 10 && $jum < 100){
  244. $id = "W14000".$jum;
  245. }
  246. else if($jum >= 100 && $jum < 1000){
  247. $id = "W1400".$jum;
  248. }
  249. else{
  250. $id = "W140".$jum;
  251. }
  252. return $id;
  253. }
  254.  
  255. public function tampil_pembelian(){
  256. $qry = mysql_query("SELECT * FROM pembelian p
  257. JOIN supplier s ON p.kd_supplier=s.kd_supplier
  258. JOIN barang b ON p.kd_pembelian=b.kd_pembelian");
  259. while ($pecah = mysql_fetch_array($qry)) {
  260. $data[]=$pecah;
  261. }
  262. $cek = mysql_num_rows($qry);
  263. if ($cek > 0) {
  264. return $data;
  265. }else{
  266. error_reporting(0);
  267. }
  268. }
  269. public function hitung_item_pembelian($kdpembelian){
  270. $qry = mysql_query("SELECT count(*) as jumlah FROM d_pembelian WHERE kd_pembelian = '$kdpembelian'");
  271. $pecah = mysql_fetch_array($qry);
  272.  
  273. return $pecah;
  274. }
  275.  
  276. //sementara
  277. public function tambah_barang_sementara($kode,$nama,$satuan,$hargab,$item,$type,$kondisi,$gambar){
  278. $tot = $item * $hargab;
  279. $namafile = $gambar['name'];
  280. //lokasi sementara
  281. $lokasifile = $gambar['tmp_name'];
  282. //upload
  283. move_uploaded_file($lokasifile, "gambar_admin/$namafile");
  284. mysql_query("INSERT INTO barangp_sementara(kd_pembelian,nama_barangp, satuan,harga_barangp,item,type,kondisi,gambar,total)
  285. VALUES('$kode','$nama','$satuan','$hargab','$item','$type','$kondisi','$namafile','$tot')");
  286. }
  287. public function tampil_barang_sementara($kode){
  288. $qry = mysql_query("SELECT * FROM barangp_sementara WHERE kd_pembelian = '$kode'");
  289. while ($pecah = mysql_fetch_array($qry)) {
  290. $data[]=$pecah;
  291. }
  292. $hitung = mysql_num_rows($qry);
  293. if ($hitung > 0) {
  294. return $data;
  295. }
  296. else{
  297. error_reporting(0);
  298. }
  299. }
  300. public function hitung_total_sementara($kode){
  301. $qry = mysql_query("SELECT sum(total) as jumlah FROM barangp_sementara WHERE kd_pembelian = '$kode'");
  302. $pecah = mysql_fetch_array($qry);
  303. $cek = $this->cek_data_barangp($kode);
  304. if ($cek === true) {
  305. $subtotal = $pecah['jumlah'];
  306. }
  307. else{
  308. $subtotal = 0;
  309. }
  310. return $subtotal;
  311. }
  312. public function hapus_barang_sementara($hapus){
  313. mysql_query("DELETE FROM barangp_sementara WHERE id_barangp ='$hapus'");
  314. }
  315. public function cek_data_barangp($kode){
  316. $qry = mysql_query("SELECT * FROM barangp_sementara WHERE kd_pembelian = '$kode'");
  317. $hitung = mysql_num_rows($qry);
  318. if ($hitung >=1) {
  319. return true;
  320. }
  321. else{
  322. return false;
  323. }
  324. }
  325. //end sementara
  326. public function simpan_pembelian($kdpembelian,$tglpembelian,$supplier,$namaterdakwa,$kdterdakwa,$alamat,$kategori,$pasal,$perkara,$sprint,$tglsprint,$pdm,$rb,$segel,$gudang,
  327. $totalpem){
  328. //insert pembelian
  329. $kdadmin = $_SESSION['login_admin']['id'];
  330. mysql_query("INSERT INTO pembelian(kd_pembelian,tgl_pembelian,kd_admin,kd_supplier,nama_terdakwa,kd_terdakwa,alamat,kd_kategori,pasal,perkara,sprint,tgl_sprint,
  331. pdm,rb,kd_segel,kd_gudang,total_pembelian)
  332. VALUES('$kdpembelian','$tglpembelian','$kdadmin','$supplier','$namaterdakwa','$kdterdakwa','$alamat','$kategori','$pasal','$perkara','$sprint','$tglsprint',
  333. '$pdm','$rb','$segel','$gudang','$totalpem')");
  334.  
  335. //insert data barang
  336. mysql_query("INSERT INTO barang_pembelian(kd_pembelian,nama_barang_beli,satuan,harga_beli,item,type,kondisi,gambar,total)
  337. SELECT kd_pembelian,nama_barangp,satuan,harga_barangp,item,type,kondisi,gambar,total FROM barangp_sementara");
  338. //insert detail pembelian
  339. mysql_query("INSERT INTO d_pembelian(kd_pembelian,kd_barang_beli,jumlah,subtotal)
  340. SELECT kd_pembelian, kd_barang_beli,item,total FROM barang_pembelian WHERE kd_pembelian='$kdpembelian'");
  341. //hapus data barang pembelian sementara
  342. mysql_query("DELETE FROM barangp_sementara WHERE kd_pembelian='$kdpembelian'");
  343. }
  344. public function tampil_barang_pembelian(){
  345. $qry = mysql_query("SELECT * FROM barang_pembelian WHERE status = '0'");
  346. while ($pecah = mysql_fetch_array($qry)) {
  347. $data[]=$pecah;
  348. }
  349. $hitung = mysql_num_rows($qry);
  350. if ($hitung > 0) {
  351. return $data;
  352. }
  353. else{
  354. error_reporting(0);
  355. }
  356. }
  357. public function ambil_kdpem(){
  358. $qry = mysql_query("SELECT * FROM pembelian ORDER BY kd_pembelian DESC LIMIT 1");
  359. $pecah = mysql_fetch_assoc($qry);
  360. return $pecah;
  361. }
  362. public function cek_hapuspembelian($kd){
  363. $qry = mysql_query("SELECT * FROM barang_pembelian WHERE kd_pembelian = '$kd' AND status ='0'");
  364. $hitung = mysql_num_rows($qry);
  365. if ($hitung > 0) {
  366. return false;
  367. }
  368. else{
  369. return true;
  370. }
  371. }
  372. public function hitung_jumlah_pembelian($kd){
  373. $qry = mysql_query("SELECT SUM(subtotal) as total FROM d_pembelian WHERE kd_pembelian = '$kd'");
  374. $pecah = mysql_fetch_assoc($qry);
  375. return $pecah['total'];
  376. }
  377. public function hapus_pembelian($kdpembelian){
  378. mysql_query("DELETE FROM pembelian WHERE kd_pembelian='$kdpembelian'");
  379. mysql_query("DELETE FROM barang_pembelian WHERE kd_pembelian = '$kdpembelian' AND status='1'");
  380. }
  381. }
  382. class Penjualan extends Barang {
  383. public function kode_otomatis(){
  384. $qry = mysql_query("SELECT MAX(kd_penjualan) AS kode FROM penjualan");
  385. $pecah = mysql_fetch_array($qry);
  386. $kode = substr($pecah['kode'], 3,5);
  387. $jum = $kode + 1;
  388. if ($jum < 10) {
  389. $id = "PEN0000".$jum;
  390. }
  391. else if($jum >= 10 && $jum < 100){
  392. $id = "PEN000".$jum;
  393. }
  394. else if($jum >= 100 && $jum < 1000){
  395. $id = "PEN00".$jum;
  396. }
  397. else{
  398. $id = "PEN0".$jum;
  399. }
  400. return $id;
  401. }
  402. public function tampil_barang_penjualan(){
  403. $qry = mysql_query("SELECT * FROM barang WHERE stok > 0 ORDER BY nama_barang ASC");
  404. while ($pecah = mysql_fetch_array($qry)) {
  405. $data[] = $pecah;
  406. }
  407. return $data;
  408. }
  409. public function tampil_penjualan(){
  410. $qry = mysql_query("SELECT * FROM penjualan ORDER BY kd_penjualan DESC");
  411. while ($pecah = mysql_fetch_array($qry)) {
  412. $data[]=$pecah;
  413. }
  414. $hitung = mysql_num_rows($qry);
  415. if ($hitung > 0) {
  416. return $data;
  417. }
  418. else{
  419. error_reporting(0);
  420. }
  421. }
  422. public function cek_data_barangp($kode){
  423. $qry = mysql_query("SELECT * FROM penjualan_sementara WHERE kd_penjualan = '$kode'");
  424. $hitung = mysql_num_rows($qry);
  425. if ($hitung >=1) {
  426. return true;
  427. }
  428. else{
  429. return false;
  430. }
  431. }
  432. public function tampil_barang_sementara($kode){
  433. $qry = mysql_query("SELECT * FROM penjualan_sementara WHERE kd_penjualan = '$kode'");
  434. while ($pecah = mysql_fetch_array($qry)) {
  435. $data[]=$pecah;
  436. }
  437. $hitung = mysql_num_rows($qry);
  438. if ($hitung > 0) {
  439. return $data;
  440. }
  441. else{
  442. error_reporting(0);
  443. }
  444. }
  445. public function tambah_penjualan_sementara($kdpen, $kdbarang, $item){
  446. $bar = $this->ambil_barang($kdbarang);
  447. $namabr = $bar['nama_barang'];
  448. $satuan = $bar['satuan'];
  449. $harga = $bar['harga_beli'];
  450. $total = $harga * $item;
  451. mysql_query("INSERT INTO penjualan_sementara(kd_penjualan, kd_barang, nama_barang, satuan, harga, item, total)
  452. VALUES('$kdpen', '$kdbarang','$namabr','$satuan','$harga','$item','$total')");
  453. // update barang
  454. $kurang = $bar['stok'] - $item;
  455. mysql_query("UPDATE barang SET stok = '$kurang' WHERE kd_barang = '$kdbarang'");
  456. }
  457. public function cek_item($kdbarang,$item){
  458. $data = $this->ambil_barang($kdbarang);
  459. $jumitem = $data['stok'];
  460. if ($item < $jumitem+1) {
  461. return true;
  462. }
  463. else{
  464. echo "<script>bootbox.alert('Item tidak cukup, $jumitem tersisa di gudang!', function(){
  465. window.location='index.php?page=tambahpenjualan';
  466. });</script>";
  467. }
  468. }
  469. public function hitung_total_sementara($kode){
  470. $qry = mysql_query("SELECT sum(total) as jumlah FROM penjualan_sementara WHERE kd_penjualan = '$kode'");
  471. $pecah = mysql_fetch_array($qry);
  472. $cek = $this->cek_data_barangp($kode);
  473. if ($cek === true) {
  474. $subtotal = $pecah['jumlah'];
  475. }
  476. else{
  477. $subtotal = 0;
  478. }
  479. return $subtotal;
  480. }
  481. public function hitung_item_penjualan($kdpenjualan){
  482. $qry = mysql_query("SELECT count(*) as jumlah FROM d_penjualan WHERE kd_penjualan = '$kdpenjualan'");
  483. $pecah = mysql_fetch_array($qry);
  484.  
  485. return $pecah;
  486. }
  487. public function simpan_penjualan($kdpenjualan,$tglpen,$sprint,$ttlbayar,$subtotal){
  488. //insert penjualan
  489. $kdadmin = $_SESSION['login_admin']['id'];
  490. mysql_query("INSERT INTO penjualan(kd_penjualan,tgl_penjualan,kd_admin,sprint,dibayar,total_penjualan)
  491. VALUES('$kdpenjualan','$tglpen','$kdadmin','$sprint','$ttlbayar','$subtotal')");
  492.  
  493.  
  494.  
  495. //insert d penjualan
  496. mysql_query("INSERT INTO d_penjualan(kd_penjualan,kd_barang,jumlah,subtotal)
  497. SELECT kd_penjualan, kd_barang,item,total FROM penjualan_sementara WHERE kd_penjualan='$kdpenjualan'");
  498. //hapus semua penjualan sementera
  499. mysql_query("DELETE FROM penjualan_sementara WHERE kd_penjualan = '$kdpenjualan'");
  500. }
  501. public function ambil_kdpen(){
  502. $qry = mysql_query("SELECT * FROM penjualan ORDER BY kd_penjualan DESC LIMIT 1");
  503. $pecah = mysql_fetch_assoc($qry);
  504. return $pecah;
  505. }
  506. public function hapus_penjualan_sementara($kd){
  507. //update barang, di kembalikan ke setok semula
  508. $datpen = $this->ambil_penjualan_sementara($kd);
  509. $datbar = $this->ambil_barang($datpen['kd_barang']);
  510. $stok = $datbar['stok'] + $datpen['item'];
  511. $kdbar = $datpen['kd_barang'];
  512. mysql_query("UPDATE barang SET stok ='$stok' WHERE kd_barang = '$kdbar'");
  513. //hapus
  514. mysql_query("DELETE FROM penjualan_sementara WHERE id_penjualan_sementara = '$kd'");
  515. }
  516. public function ambil_penjualan_sementara($kd){
  517. $qry = mysql_query("SELECT * FROM penjualan_sementara WHERE id_penjualan_sementara = '$kd'");
  518. $pecah = mysql_fetch_assoc($qry);
  519. return $pecah;
  520. }
  521. }
  522. class Nota{
  523. public function tampil_nota_pembelian($kd){
  524. $qry = mysql_query("SELECT * FROM supplier sup
  525. JOIN pembelian pem ON pem.kd_supplier = sup.kd_supplier
  526. JOIN admin adm ON adm.kd_admin = pem.kd_admin
  527. JOIN d_pembelian dpem ON pem.kd_pembelian = dpem.kd_pembelian
  528. JOIN barang_pembelian bpem ON dpem.kd_barang_beli = bpem.kd_barang_beli
  529. WHERE pem.kd_pembelian = '$kd'");
  530.  
  531. while ($pecah = mysql_fetch_array($qry)) {
  532. $data[]=$pecah;
  533. }
  534. $hitung = mysql_num_rows($qry);
  535. if ($hitung > 0) {
  536. return $data;
  537. }
  538. else{
  539. error_reporting(0);
  540. }
  541. }
  542. public function ambil_nota_pembelian($kd){
  543. $qry = mysql_query("SELECT * FROM supplier sup
  544. JOIN pembelian pem ON pem.kd_supplier = sup.kd_supplier
  545. JOIN admin adm ON adm.kd_admin = pem.kd_admin
  546. JOIN d_pembelian dpem ON pem.kd_pembelian = dpem.kd_pembelian
  547. JOIN barang_pembelian bpem ON dpem.kd_pembelian = bpem.kd_pembelian
  548. WHERE pem.kd_pembelian = '$kd'");
  549. $pecah = mysql_fetch_assoc($qry);
  550. return $pecah;
  551. }
  552. public function tampil_nota_penjualan($kd){
  553. $qry = mysql_query("SELECT * FROM penjualan pen
  554. JOIN admin adm ON adm.kd_admin = pen.kd_admin
  555. JOIN d_penjualan dpen ON pen.kd_penjualan = dpen.kd_penjualan
  556. JOIN barang bar ON dpen.kd_barang = bar.kd_barang
  557. WHERE pen.kd_penjualan = '$kd'");
  558. while ($pecah = mysql_fetch_array($qry)) {
  559. $data[]=$pecah;
  560. }
  561. $hitung = mysql_num_rows($qry);
  562. if ($hitung > 0) {
  563. return $data;
  564. }
  565. else{
  566. error_reporting(0);
  567. }
  568. }
  569. public function ambil_nota_penjualan($kd){
  570. $qry = mysql_query("SELECT * FROM penjualan pen
  571. JOIN admin adm ON adm.kd_admin = pen.kd_admin
  572. JOIN d_penjualan dpen ON pen.kd_penjualan = dpen.kd_penjualan
  573. JOIN barang bar ON dpen.kd_barang = bar.kd_barang
  574. WHERE pen.kd_penjualan = '$kd'");
  575. $pecah = mysql_fetch_assoc($qry);
  576. return $pecah;
  577. }
  578. }
  579. class Laporan{
  580. public function tampil_penjualan_bulan($bln1,$bln2){
  581. $qry = mysql_query("SELECT * FROM penjualan pen
  582. JOIN d_penjualan dpen ON pen.kd_penjualan = dpen.kd_penjualan
  583. JOIN barang bar ON dpen.kd_barang = bar.kd_barang
  584. WHERE pen.tgl_penjualan BETWEEN '$bln1' AND '$bln2'");
  585. while ($pecah = mysql_fetch_array($qry)) {
  586. $data[]=$pecah;
  587. }
  588. $hitung = mysql_num_rows($qry);
  589. if ($hitung > 0) {
  590. return $data;
  591. }
  592. else{
  593. error_reporting(0);
  594. }
  595. }
  596. public function cek_penjualan_bulan($bln1,$bln2){
  597. $qry = mysql_query("SELECT * FROM penjualan pen
  598. JOIN d_penjualan dpen ON pen.kd_penjualan = dpen.kd_penjualan
  599. JOIN barang bar ON dpen.kd_barang = bar.kd_barang
  600. WHERE pen.tgl_penjualan BETWEEN '$bln1' AND '$bln2'");
  601. $hitung = mysql_num_rows($qry);
  602. if ($hitung >=1) {
  603. return true;
  604. }
  605. else{
  606. return false;
  607. }
  608. }
  609. public function hitung_total_penjualan(){
  610. $qry = mysql_query("SELECT sum(dpen.subtotal) as jumlah FROM penjualan pen
  611. JOIN d_penjualan dpen ON pen.kd_penjualan = dpen.kd_penjualan
  612. JOIN barang bar ON dpen.kd_barang = bar.kd_barang");
  613. $pecah = mysql_fetch_array($qry);
  614. $subtotal = $pecah['jumlah'];
  615. return $subtotal;
  616. }
  617. public function tampil_penjualan(){
  618. $qry = mysql_query("SELECT * FROM penjualan pen
  619. JOIN d_penjualan dpen ON pen.kd_penjualan = dpen.kd_penjualan
  620. JOIN barang bar ON dpen.kd_barang = bar.kd_barang ");
  621. while ($pecah = mysql_fetch_array($qry)) {
  622. $data[]=$pecah;
  623. }
  624. $hitung = mysql_num_rows($qry);
  625. if ($hitung > 0) {
  626. return $data;
  627. }
  628. else{
  629. error_reporting(0);
  630. }
  631. }
  632. public function cek_penjualan(){
  633. $qry = mysql_query("SELECT * FROM penjualan pen
  634. JOIN d_penjualan dpen ON pen.kd_penjualan = dpen.kd_penjualan
  635. JOIN barang bar ON dpen.kd_barang = bar.kd_barang");
  636. $hitung = mysql_num_rows($qry);
  637. if ($hitung >=1) {
  638. return true;
  639. }
  640. else{
  641. return false;
  642. }
  643. }
  644. public function hitung_total_penjualan_bulan($bln1,$bln2){
  645. $qry = mysql_query("SELECT sum(dpen.subtotal) as jumlah FROM penjualan pen
  646. JOIN d_penjualan dpen ON pen.kd_penjualan = dpen.kd_penjualan
  647. JOIN barang bar ON dpen.kd_barang = bar.kd_barang
  648. WHERE pen.tgl_penjualan BETWEEN '$bln1' AND '$bln2'");
  649. $pecah = mysql_fetch_array($qry);
  650. $subtotal = $pecah['jumlah'];
  651. return $subtotal;
  652. }
  653. //end penjualan
  654.  
  655. public function tampil_pembelian_bulan($bln1,$bln2){
  656. $qry = mysql_query("SELECT * FROM supplier sup
  657. JOIN pembelian pem ON sup.kd_supplier = pem.kd_supplier
  658. JOIN d_pembelian dpem ON pem.kd_pembelian = dpem.kd_pembelian
  659. JOIN barang_pembelian barpem ON dpem.kd_barang_beli = barpem.kd_barang_beli
  660. WHERE pem.tgl_pembelian BETWEEN '$bln1' AND '$bln2'");
  661. while ($pecah = mysql_fetch_array($qry)) {
  662. $data[]=$pecah;
  663. }
  664. $hitung = mysql_num_rows($qry);
  665. if ($hitung > 0) {
  666. return $data;
  667. }
  668. else{
  669. error_reporting(0);
  670. }
  671. }
  672. public function cek_pembelian_bulan($bln1,$bln2){
  673. $qry = mysql_query("SELECT * FROM supplier sup
  674. JOIN pembelian pem ON sup.kd_supplier = pem.kd_supplier
  675. JOIN d_pembelian dpem ON pem.kd_pembelian = dpem.kd_pembelian
  676. JOIN barang_pembelian barpem ON dpem.kd_barang_beli = barpem.kd_barang_beli
  677. WHERE pem.tgl_pembelian BETWEEN '$bln1' AND '$bln2'");
  678. $hitung = mysql_num_rows($qry);
  679. if ($hitung >=1) {
  680. return true;
  681. }
  682. else{
  683. return false;
  684. }
  685. }
  686. public function hitung_total_pembelian_bulan($bln1,$bln2){
  687. $qry = mysql_query("SELECT sum(dpem.subtotal) as jumlah FROM supplier sup
  688. JOIN pembelian pem ON sup.kd_supplier = pem.kd_supplier
  689. JOIN d_pembelian dpem ON pem.kd_pembelian = dpem.kd_pembelian
  690. JOIN barang_pembelian barpem ON dpem.kd_barang_beli = barpem.kd_barang_beli
  691. WHERE pem.tgl_pembelian BETWEEN '$bln1' AND '$bln2'");
  692. $pecah = mysql_fetch_array($qry);
  693. $subtotal = $pecah['jumlah'];
  694. return $subtotal;
  695. }
  696. public function hitung_total_pembelian(){
  697. $qry = mysql_query("SELECT sum(dpem.subtotal) as jumlah FROM supplier sup
  698. JOIN pembelian pem ON sup.kd_supplier = pem.kd_supplier
  699. JOIN d_pembelian dpem ON pem.kd_pembelian = dpem.kd_pembelian
  700. JOIN barang_pembelian barpem ON dpem.kd_barang_beli = barpem.kd_barang_beli");
  701. $pecah = mysql_fetch_array($qry);
  702. $subtotal = $pecah['jumlah'];
  703. return $subtotal;
  704. }
  705. public function tampil_pembelian(){
  706. $qry = mysql_query("SELECT * FROM supplier sup
  707. JOIN pembelian pem ON sup.kd_supplier = pem.kd_supplier
  708. JOIN d_pembelian dpem ON pem.kd_pembelian = dpem.kd_pembelian
  709. JOIN barang_pembelian barpem ON dpem.kd_barang_beli = barpem.kd_barang_beli");
  710. while ($pecah = mysql_fetch_array($qry)) {
  711. $data[]=$pecah;
  712. }
  713. $hitung = mysql_num_rows($qry);
  714. if ($hitung > 0) {
  715. return $data;
  716. }
  717. else{
  718. error_reporting(0);
  719. }
  720. }
  721. public function cek_pembelian(){
  722. $qry = mysql_query("SELECT * FROM supplier sup
  723. JOIN pembelian pem ON sup.kd_supplier = pem.kd_supplier
  724. JOIN d_pembelian dpem ON pem.kd_pembelian = dpem.kd_pembelian
  725. JOIN barang_pembelian barpem ON dpem.kd_barang_beli = barpem.kd_barang_beli");
  726. $hitung = mysql_num_rows($qry);
  727. if ($hitung >=1) {
  728. return true;
  729. }
  730. else{
  731. return false;
  732. }
  733. }
  734. //end pembelian
  735. public function hitung_profit_bulan(){
  736.  
  737. }
  738. public function hitung_profit_semua(){
  739.  
  740. }
  741. }
  742. class Cetak_Laporan{
  743. public function laporan_penjualan_bulan($tgl1,$tgl2){
  744. $qry = mysql_query("SELECT * FROM penjualan pen
  745. JOIN d_penjualan dpen ON pen.kd_penjualan = dpen.kd_penjualan
  746. JOIN barang bar ON dpen.kd_barang = bar.kd_barang
  747. WHERE pen.tgl_penjualan BETWEEN '$tgl1' AND '$tgl2'");
  748. while ($pecah = mysql_fetch_array($qry)) {
  749. $data[]=$pecah;
  750. }
  751. $hitung = mysql_num_rows($qry);
  752. if ($hitung > 0) {
  753. return $data;
  754. }
  755. else{
  756. error_reporting(0);
  757. }
  758. }
  759. public function laporan_semua_penjualan(){
  760. $qry = mysql_query("SELECT * FROM penjualan pen
  761. JOIN d_penjualan dpen ON pen.kd_penjualan = dpen.kd_penjualan
  762. JOIN barang bar ON dpen.kd_barang = bar.kd_barang ");
  763. while ($pecah = mysql_fetch_array($qry)) {
  764. $data[]=$pecah;
  765. }
  766. $hitung = mysql_num_rows($qry);
  767. if ($hitung > 0) {
  768. return $data;
  769. }
  770. else{
  771. error_reporting(0);
  772. }
  773. }
  774. public function laporan_pembelian_bulan($tgl1,$tgl2){
  775. $qry = mysql_query("SELECT * FROM supplier sup
  776. JOIN pembelian pem ON sup.kd_supplier = pem.kd_supplier
  777. JOIN d_pembelian dpem ON pem.kd_pembelian = dpem.kd_pembelian
  778. JOIN barang_pembelian barpem ON dpem.kd_barang_beli = barpem.kd_barang_beli
  779. WHERE tgl_pembelian pem.tgl_pembelian BETWEEN '$tgl1' AND '$tgl2'");
  780. while ($pecah = mysql_fetch_array($qry)) {
  781. $data[]=$pecah;
  782. }
  783. $hitung = mysql_num_rows($qry);
  784. if ($hitung > 0) {
  785. return $data;
  786. }
  787. else{
  788. error_reporting(0);
  789. }
  790. }public function laporan_semua_pembelian(){
  791. $qry = mysql_query("SELECT * FROM supplier sup
  792. JOIN pembelian pem ON sup.kd_supplier = pem.kd_supplier
  793. JOIN d_pembelian dpem ON pem.kd_pembelian = dpem.kd_pembelian
  794. JOIN barang_pembelian barpem ON dpem.kd_barang_beli = barpem.kd_barang_beli");
  795. while ($pecah = mysql_fetch_array($qry)) {
  796. $data[]=$pecah;
  797. }
  798. $hitung = mysql_num_rows($qry);
  799. if ($hitung > 0) {
  800. return $data;
  801. }
  802. else{
  803. error_reporting(0);
  804. }
  805. }
  806. }
  807. class Perusahaan{
  808. public function tampil_perusahaan(){
  809. $qry = mysql_query("SELECT * FROM perusahaan WHERE kd_perusahaan = '1'");
  810. $pecah = mysql_fetch_assoc($qry);
  811. return $pecah;
  812. }
  813. public function simpan_perusahaan($nama,$alamat,$pemilik,$kota){
  814. mysql_query("UPDATE perusahaan SET nama_perusahaan='$nama',alamat='$alamat', pemilik='$pemilik', kota='$kota' WHERE kd_perusahaan ='1' ");
  815. }
  816. }
  817. class Dashboard{
  818. public function penjualan_hariini(){
  819.  
  820. $hari = date("Y-m-d");
  821. $qry = mysql_query("SELECT * FROM penjualan WHERE tgl_penjualan = '$hari'");
  822. $hitung = mysql_num_rows($qry);
  823. return $hitung;
  824. }
  825. public function pembelian_hariini(){
  826. $hari = date("Y-m-d");
  827. $qry = mysql_query("SELECT * FROM pembelian WHERE tgl_pembelian = '$hari'");
  828. $hitung = mysql_num_rows($qry);
  829. return $hitung;
  830. }
  831. public function pembelian_total(){
  832. $query=mysql_query("Select Count(*) From pembelian");
  833. $total=mysql_fetch_array($query);
  834.  
  835.  
  836. return $total;
  837. }
  838. }
  839. $DataBase = new DataBase();
  840. $DataBase->sambungkan();
  841. $admin = new Admin();
  842. $barang = new Barang();
  843. $supplier = new Supplier();
  844. $pembelian = new Pembelian();
  845. $penjualan = new Penjualan();
  846. $nota = new Nota();
  847. $segel= new Segel();
  848. $gudang= new Gudang();
  849. $kategori = new Kategori();
  850. $laporan = new Laporan();
  851. $cetaklaporan = new Cetak_Laporan();
  852. $perusahaan = new Perusahaan();
  853. $dashboard = new Dashboard();
  854. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!