Hallo! Selamat Datang di Marketplace produk digital, Freelancer terbaik di indonesia (67373 Members, 787 Products, 5278 Topic, 12953 Comments)

Menambah stok di aplikasi Point Of Sales

Dibuat
Login Terakhir 2 Bulan lalu,
Telah Dilihat 1115 Kali
Eries Ramadhani Mengatakan : Free Account
  1. Assalamualaikum Warahmatullahi Wabarakatuh...
  2. Bagaimana cara input stok stok di Aplikasi Point Of Sale manggaleh.
  3. Terima kasih

Ada 8 Jawaban

PHPMU.COM Support
commented on 22 Jul 2022 10:48:54
  1. Assalamualaikum,.. Berikut Tahapannya :
  2.  
Terdapat 5 File dilampirkan :
1. 0_Stok_awal.png (105 KB)
2. 1_Tambah_pembelian.png (113 KB)
3. 2_Form_Tambah_pembelian.png (101 KB)
4. 3_Terima_pembelian.png (103 KB)
5. 4_input_penerimaan.png (112 KB)
Eries Ramadhani
commented on 22 Jul 2022 12:23:13
  1. Terima kasih
Eries Ramadhani
commented on 23 Jul 2022 22:03:42
  1. Assalamualaikum,..
  2. sdh saya coba dan ikuti tahapannya tetap gk berubah stoknya..mohon bantuannya
  3.  
Eries Ramadhani
commented on 23 Jul 2022 22:04:16
  1. Assalamualaikum,.. saya coba input data barang baru juga sama stoknya gk berubah
PHPMU.COM Support
commented on 23 Jul 2022 22:08:42
  1. Assalamualaikum,.. buka file application\models\Model_app.php
  2. pada baris 146 perharikan querynya, semua 'null' pada query ubah menjadi '0', jadi seperti ini :
  3.  
  4. public function stok($id){
  5. return $this->db->query("SELECT (sum(z.jml)-sum(z.kurang)) as stok FROM
  6. (SELECT sum(a.jml_terima) as jml, 0 as kurang FROM mu_pembelian_terima_detail a JOIN mu_pembelian_terima b ON a.id_pembelian_terima=b.id_pembelian_terima where a.id_barang='$id'
  7. UNION
  8. SELECT 0 as jml, sum(a.jml_return) as kurang FROM mu_pembelian_return_detail a JOIN mu_pembelian_return b ON a.id_pembelian_return=b.id_pembelian_return where a.id_barang='$id'
  9. UNION
  10. SELECT sum(tambah) as jml, sum(kurang) as kurang FROM mu_penyesuaian_detail where id_barang='$id'
  11. UNION
  12. SELECT 0 as jml, sum(b.jumlah_jual*b.jumlah_satuan) as kurang FROM `mu_transaksi` a JOIN mu_transaksi_detail b ON a.id_transaksi=b.id_transaksi where b.id_barang='$id'
  13. UNION
  14. SELECT sum(a.jumlah_return) as jml, 0 as kurang FROM `mu_transaksi_return_detail` a JOIN mu_transaksi_detail b ON a.id_transaksi_detail=b.id_transaksi_detail JOIN mu_transaksi_return c ON a.id_transaksi_return=c.id_transaksi_return where c.status='selesai' AND b.id_barang='$id') as z");
  15. }
Eries Ramadhani
commented on 23 Jul 2022 22:21:05
  1. Assalamualaikum,.. ok saya coba
Eries Ramadhani
commented on 23 Jul 2022 22:38:15
  1. Assalamualaikum,.. Alhamdulillah sdh bisa mas...terima kasih banyak
Eries Ramadhani
commented on 24 Jul 2022 03:39:43
  1. Assalamualaikum,..
  2. Saya coba hosting aplikasinya, tapi pada saat launch muncul kayak gambar ini...mohon bantuannya
Terdapat 1 File dilampirkan :
1. Screenshot_20220724-042846_Chrome.jpg (189 KB)
Maaf, Untuk Memberikan Komentar Anda Harus Login !!!