function invoice() { $romawi = romawi(date('n')); $kode = "/NHW/INV/" . $romawi . "/" . date('Y'); $count = "-" . strlen($kode) - 3; $kdauto = mysql_query("SELECT max(invoice) AS last FROM orders WHERE invoice LIKE '%{$kode}'"); $result = mysql_fetch_array($kdauto); $lastNoInvoice = $result['last']; $lastNoUrut = substr($lastNoInvoice, $count, 3); $nextNoUrut = $lastNoUrut + 1; $nextNoInvoice = sprintf('%03s', $nextNoUrut) . $kode; return $nextNoInvoice; }
public function deliveryOrder($returpener_id) { $get = DoReturpener::where('returpener_id', $returpener_id); if ($get->count() == 0) { if (DoReturpener::count() == 0) { $numb = '001/JIU/' . romawi()[date('n')] . '/' . date('Y'); } else { $last = DoReturpener::orderBy('dorp_id', 'DESC')->take(1)->pluck('dorp_no'); $path = explode('/', $last); $preffix = ''; $path[0]++; for ($x = 0; $x < 3 - strlen($path[0]); $x++) { $preffix .= '0'; } $numb = $preffix . $path[0] . '/JIU/' . romawi()[date('n')] . '/' . date('Y'); } DoReturpener::create(['returpener_id' => $returpener_id, 'dorp_no' => $numb]); } else { $row = $get->first(); $numb = $row->dorp_no; } #Update status to 'DO has been created' $get = Returpener::find($returpener_id); $get->returpener_status = 6; $get->save(); #End #Reduce material's stock $mats = Returpeners::getMatData($returpener_id); foreach ($mats as $mat) { if ($mat->returpeners_is_reduced == 2) { #Reducing stock... $eachMat = Material::find($mat->mat_id); $eachMat->mat_stock_akhir = $eachMat->mat_stock_akhir - $mat->returpeners_jml; $eachMat->save(); #End #Update is_reduced field $each = Returpeners::find($mat->returpeners_id); $each->returpeners_is_reduced = 1; $each->save(); #End } } #End $data = ['asset' => new Assets(), 'title' => 'Print Retur Delivery Order', 'head' => Returpener::fetchHead($returpener_id), 'sub' => Returpeners::fetch($returpener_id), 'numb' => $numb]; return view('printing.do', $data); }
mysql_data_seek($gudang, 0); $row_gudang = mysql_fetch_assoc($gudang); } ?> </select></td> </tr> <tr> <td align="right" valign="top">No. SPK :</td> <td valign="top"><div id="refDiv"> <label> <?php list($kodecabang) = mysql_fetch_row(mysql_query("select kodecabang from gl_gudang where id = '{$_SESSION['lokasi']}'")); ?> <input name="noreferensi" type="text" id="noreferensi" value="<?php echo getidkontrak() . "/SP/" . $kodecabang . "/corp-BDP/" . romawi(date("m")) . "/" . date("Y"); ?> " size="30" maxlength="100" readonly="readonly"> </label> </div></td> <td align="right" valign="top">Salesman : </td> <td valign="top"><select name="recipient" id="recipient" style="width:180px;"> <?php do { ?> <option value="<?php echo $row_salesmen['id']; ?> " <?php if ($_session[kontakid] == $row_salesmen['id']) {
<tr> <td align="right" valign="top">No. Kontrak :</td> <td valign="top"><div id="refDiv"> <label> <?php list($kodecabang) = mysql_fetch_row(mysql_query("select kodecabang from gl_gudang where id = '{$_SESSION['lokasi']}'")); ?> <?php list($area) = mysql_fetch_row(mysql_query("select area from gl_area where id = '{$_SESSION['area']}'")); if ($area == 'BANDUNG') { $kodecabang = 'BDP'; } ?> <input name="noreferensi" type="text" id="noreferensi" value="<?php echo getidkontrak() . "/SP/CCG-" . $kodecabang . "/Corp/" . romawi(date("m")) . "/" . date("Y"); ?> " size="30" maxlength="100"> </label> </div></td> <td align="right" valign="top">Marketing : </td> <td valign="top"><select name="recipient" id="recipient" style="width:180px;"> <?php do { ?> <option value="<?php echo $row_salesmen['id']; ?> " <?php if ($_session[kontakid] == $row_salesmen['id']) {
function generatePoNumb($get) { if ($get->count() > 0) { $row = $get->first(); $path = explode('/', $row->po_no); if (date('Y') == $path[4] + 1) { $numb = $path[0] . '/' . '001' . '/' . romawi()[date('n')] . '/' . 'JIU' . '/' . date('Y'); } else { $preffix = ''; $path[1]++; for ($x = 0; $x < 3 - strlen($path[1]); $x++) { $preffix .= '0'; } $numb = $path[0] . '/' . ($preffix . $path[1]) . '/' . romawi()[date('n')] . '/' . 'JIU' . '/' . date('Y'); } } else { $numb = ($_POST['type'] == 'ppn' ? 'P' : 'NP') . '/' . '001' . '/' . romawi()[date('n')] . '/' . 'JIU' . '/' . date('Y'); } return $numb; }
public function requestCreate() { $get = Pb::select('pb_no')->orderBy('created_at', 'DESC'); if ($get->count() == 0) { $numb = 'GBB/001/' . romawi()[date('n')] . '/' . date('y'); } else { $row = $get->first(); $path = explode('/', $row->pb_no); if (date('y') == $path[3] + 1) { $numb = $path[0] . '/' . '001' . '/' . romawi()[date('n')] . '/' . date('y'); } else { $preffix = ''; $path[1]++; for ($x = 0; $x < 3 - strlen($path[1]); $x++) { $preffix .= '0'; } $numb = $path[0] . '/' . ($preffix . $path[1]) . '/' . romawi()[date('n')] . '/' . date('y'); } } $data = ['title' => 'Buat Permintaan Baru', 'asset' => new Assets(), 'js' => ['vendor/jquery-ui-autocomplete-datepicker.min'], 'css' => ['jquery-ui-autocomplete-datepicker.min'], 'position' => ['material' => 'Material', 'material/request' => 'Permintaan Barang', 'material/request/create' => 'Buat Permintaan'], 'opened' => 'material', 'lastNumb' => $numb]; return view('material.request.create', $data); }
function create_no_surat($no_surat, $kd_jenis, $kd_bagian, $tgl_surat) { $jenis = $this->get_info_jenis($kd_jenis); $count = $jenis->count; if ($no_surat == FALSE) { $count = $count + 1; $no_surat = sprintf('%03d', $count); //TAMBAH JUMLAH COUNT DI TABEL SURAT_JENIS $no_surat; } if ($kd_jenis != '' && $kd_bagian != '' && $tgl_surat != '') { //MENGHASILKAN KODE INSTANSI DARI DATABASE $this->db->where('nama_option', 'kd_instansi'); $get = $this->db->get('surat_option'); if ($get->num_rows() > 0) { $data = $get->row(); $kd_instansi = $data->value_option; $this->db->where('kd_jenis', $kd_jenis); $this->db->update('surat_jenis', array('count' => $count)); } else { $kd_instansi = '-'; } //MENGHASILKAN BULAN ROMAWI $bulan = @romawi(sprintf('%02d', date('m', strtotime($tgl_surat)))); //MENGHASILKAN TAHUN $tahun = date('Y', strtotime($tgl_surat)); $result = $no_surat . "/" . $kd_jenis . "/K/" . $kd_instansi . "/" . $bulan . "/" . $tahun; //echo $result; return $result; } }