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;
}
}
