function getKodeBukuDT($data){ // rule kode buku dan barkode ----------------------------------------------- $s1 = ' SELECT d.nilai, d.nilai2, d.keterangan, d.isActive FROM pus_setting2 s left join pus_detail_setting d on d.kunci = s.replid WHERE s.kunci ="idfmt" ORDER BY d.urut asc'; $e1 = mysql_query($s1); $bukuFormat =''; // kode buku ------------- while ($r1 = mysql_fetch_assoc($e1)) { if(strpos($r1['nilai'],'nomorauto')!==FALSE and $r1['isActive']==1){ if($_POST['jml_koleksi']>1) { $bukuFormat.='/[auto]'; }else { $id = $r1['nilai2']; $bukuFormat.='/'.sprintf('%0'.$id.'d',$data['idbuku']); } } if(strpos($r1['nilai'],'sumber')!==FALSE and $r1['isActive']==1){ $bukuFormat.='/'.($data['sumber']=='0'?'B':'H'); } if(strpos($r1['nilai'],'sistem')!==FALSE and $r1['isActive']==1){ $bukuFormat.='/'.$r1['nilai2']; } if(strpos($r1['nilai'],'tahun')!==FALSE and $r1['isActive']==1){ $bukuFormat.='/'.$data['tahun']; } if(strpos($r1['nilai'],'tingkatbuku')!==FALSE and $r1['isActive']==1){ $tingkat = getTingkatBuku('kode','replid',$data['tingkat']); $bukuFormat.='/'.$tingkat; } }$bukuFormat=substr($bukuFormat, 1); return $bukuFormat; }
$s ='SELECT (max(urut)+1)idbuku from pus_buku'; }$e = mysql_query($s) or die(mysql_error()); $r = mysql_fetch_assoc($e); // u/ id buku $data1 = array( 'idbuku' =>$r['idbuku'], 'sumber' =>$_POST['sumber'], 'tahun' =>substr($_POST['tanggal'],7,4), 'tingkat' => getTingkatBuku('kode','replid',$_POST['tingkat']) ); // u/ barcode $data2 = array( 'lokasi' => getLokasi('kode','replid',$_POST['lokasi']), 'tingkat' => getTingkatBuku('kode','replid',$_POST['tingkat']), 'tahun' =>substr($_POST['tanggal'],7,4), 'idbuku' =>$r['idbuku'] ); // panggil fungsi generate $idbuku = getKodeBukuDT($data1); $barcode = getBarcodeDT($data2); // output -------------------------------- $stat = ($idbuku==NULL && $barcode==NULL) ?'gagal':'sukses'; $out = json_encode(array( 'status' =>$stat, 'idbuku' =>$idbuku, 'barcode' =>$barcode ));