Hallo! Selamat Datang di Marketplace produk digital, Freelancer terbaik di indonesia (68782 Members, 787 Products, 5375 Topic, 13068 Comments)

Menambah stok di aplikasi Point Of Sales

Dibuat
Login Terakhir 23 Hari lalu,
Telah Dilihat 1320 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 !!!

Online