Exemple #1
0
	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;
	}
Exemple #2
0
							$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
						));