Skip to main content

Navigation

chaidir.alit's friends

LOGIN

Who's new

DROPBOX

FREE 2 GB AND MORE

Home

membuat nota otomatis

August 15, 2011 by chaidir.alit

chaidir.alit's picture

hello.. para master ane mau tanya donk, gimana caranya buat nota otomatis pertanggal, misalkan [0001]/[tgl] jadi pada no registrasi terdapat digit 0, mohon pencerahannya, makasih

Comments

makasih banyak , mantap gan

August 19, 2011 by chaidir.alit, 7 weeks 6 days ago
Comment: 8860

chaidir.alit's picture

makasih banyak , mantap gan ,,

mungkin seperti ini?

August 18, 2011 by predhtz, 7 weeks 6 days ago
Comment: 8857

predhtz's picture

pertama buat dulu model untuk medapatkan nomor terakhir nota pada tanggal tersebut;

class modelnota extends CI_Model
{
...
// fungsi konstruktor
...
 
fungsi getnomornota()
{
$this->db->select("SUBSTRING(no_nota, 0,4) as urut");
$this->db->from("transaksi");
$this->db->where(array("SUBSTRING(no_nota, 5)" => mdate("%Y%m%d")));
$this->db->limit(1);
$this->db->order_by("substring(no_nota, 0, 4) desc");
$query = $this->db->get();
$numrows = $query ? $query->num_rows() : 0;
if ($numrows < 1)
{
return false;
}
else
{
foreach ($query->result() as $row)
{
return (int)$row->urut;
}
}
}
}

Di Controller

....
private function createnota()
{
$nomor = $this->modelnota->getnomornota();
if ($nomor == false)
{
$urut = 1;
}
else
{
$urut = $nomor+1;
}
$nomor_nota = sprintf("%04s", $urut) . "/".mdate("%Y%m%d", time());
 
return $nomor_nota;
 
}
....

semoga bisa sedikit membantu

APA maksudnya menampilkan

August 18, 2011 by OKIEWARDOYO, 8 weeks 4 hours ago
Comment: 8852

OKIEWARDOYO's picture

APA maksudnya menampilkan nomor nota dan tangal yang sudah ada di database?
=========
Kita umpamakan disini anda sudah punya database and punya table
contoh:
1). Misal database
+-----------------------------
| no_nota + tanggal
|-----------|-----------------
| 0001 | 19 Agustus 2011
| 0002 | 20 Agustus 2011
| 0003 | 21 Agustus 2011
+-----------------------------

2). Buat controller
misalnya websitekita.com/print_nota

class Print_nota extends CI_Controller {
	function __construct()
	{
	    parent::__construct();
            $this->load->database();	
	}
 
	function tampil_nota()
	{
	    $query = $this->db->query("SELECT * FROM `table_nota`");
	    $row = $query->row();
            $this->load->view('_output', $row);
	}  
}

3. Buat view
misalnya disini sesuai diatas kita buat _output.php

<table>
   <tr><td>NO NOTA</td>     <td>TANGGAL</td></tr>
   <?
   foreach($row as $show){
   ?>
      <tr><td><?=$show['no_nota']?></td>     <td><?=$show['tanggal']?></td></tr>
   <?
   }
   ?>
</table>

4. selesai ^_^

==============
OKIE
http://www.mediatutorial.web.id

saya da mo buat sistem database pegawai berbasis web

August 17, 2011 by melcior, 8 weeks 1 day ago
Comment: 8846

melcior's picture

lagi mo buat sistem database pegawai berbasis web untuk tugas KP
mohon bantuannya/...

cara membuat forum diskusi

August 17, 2011 by melcior, 8 weeks 1 day ago
Comment: 8845

melcior's picture

para master... minta script n cara buat forum dong...

Premium Drupal Themes by Adaptivethemes