About 23,759 results: "mysql_query"
Page 3 of 50
Filter Results
Sources
Languages
Filter Results
Try Search On


  1. elseif($_GET['module']=='terimasuratmasuk'){
  2. 	$qMaxagd	= mysql_query("SELECT MAX(noagenda) maxAgd FROM d_suratmasuk");
  3. 	//statproses = 1 -- terima loket umum
  4. 	mysql_query("INSERT INTO d_suratmasuk(kodeagenda,noagenda,nomorsuratmasuk,asalsurat,tujuansurat,tglsurat,perihal,userloket,timeloket,file,statproses) 
  5. 			
  6. 			$qDataSurat		= mysql_query("SELECT statproses,idsurat,CONCAT(kodeagenda,'-',noagenda) AS noagenda,nomorsuratmasuk,asalsurat,date_format(date(tglsurat),'%d-%m-%Y') AS tglsurat,perihal,disposisi,batasselesai,um,pd,bp,vr,sk,sangatsegera,segera,biasa,setuju,tolak,telitipendapat,untukdiketahui,selesaikan,sesuaicatatan,untukperhatian,edarkan,jawab,perbaiki,bicarakandgsaya,bicarakanbersama,ingatkan,simpan,disiapkan,harapdihadiridiwakili FROM d_suratmasuk WHERE statproses<'4' ORDER BY statproses, noagenda DESC,nomorsuratmasuk")or die(mysql_error);
  7. 			
  8. 			$qDataSurat		= mysql_query("SELECT idsurat,CONCAT(kodeagenda,'-',noagenda) AS noagenda,nomorsuratmasuk,asalsurat,date_format(date(tglsurat),'%d-%m-%Y') AS tglsurat,perihal FROM d_suratmasuk WHERE statproses='2' ORDER BY statproses, noagenda DESC,nomorsuratmasuk")or die(mysql_error);
  9. 	// query updating tables for Disposisi Kepala Kantor/Pejabat statproses=3
  10. 	mysql_query("UPDATE d_suratmasuk SET userpejabat='$username',timepejabat='$timepejabat',batasselesai='$batasselesai',disposisi='$disposisi',um='$seksium',pd='$seksipd',bp='$seksibp',vr='$seksivr',sk='$sekretariat',sangatsegera='$sangatsegera',segera='$segera',biasa='$biasa',setuju='$setuju',tolak='$tolak',telitipendapat='$telitipendapat',untukdiketahui='$untukdiketahui',selesaikan='$selesaikan',sesuaicatatan='$sesuaicatatan',untukperhatian='$untukperhatian',edarkan='$edarkan',jawab='$jawab',perbaiki='$perbaiki',bicarakandgsaya='$bicarakandgsaya',bicarakanbersama='$bicarakanbersama',ingatkan='$ingatkan',simpan='$simpan',disiapkan='$disiapkan',harapdihadiridiwakili='$harapdihadiridiwakili',statproses='2' WHERE idsurat='$idsurat'");
  11. 			
  12. 			$qDataSurat		= mysql_query("SELECT idsurat,CONCAT(kodeagenda,'-',noagenda) AS noagenda,nomorsuratmasuk,asalsurat,date_format(date(tglsurat),'%d-%m-%Y') AS tglsurat,perihal FROM d_suratmasuk WHERE statproses='3' AND $seksi='1' ORDER BY statproses, noagenda DESC,nomorsuratmasuk")or die(mysql_error);
  13. 			$query		= "SELECT idsurat,nomorsuratmasuk,date_format(tglsurat,'%d-%m-%Y') AS tglsurat,asalsurat,perihal,CONCAT(nomorsuratkeluar,kodesuratkeluar) AS nomorsuratkeluar,file,um,pd,bp,vr,sk FROM d_suratmasuk WHERE ".$bagianWhere;
  14. 			$qCari		= mysql_query($query)or die(mysql_error());
  15. 	
  16. 	$qUpdate = mysql_query("SELECT idsurat,nomorsuratmasuk,date_format(tglsurat,'%d/%m/%Y') AS tglsurat,asalsurat,perihal,nomorsuratkeluar,kodesuratkeluar,file FROM d_suratmasuk WHERE idsurat='$idsurat'");

  1. elseif($_GET['module'] == 'tandaterimaskpp'){
  2. 	$qMaxagd	= mysql_query("SELECT MAX(noagenda) maxAgd FROM d_skpp WHERE noagenda LIKE 'SKPP%'");
  3. 	$kdsatker	= $_POST['kdsatker'];
  4. 	$qSatker	= mysql_query("SELECT kdsatker FROM t_satker WHERE kdsatker='$kdsatker'")or die(mysql_error);
  5. 	
  6. 	$qkppn		= mysql_query("SELECT nmkppn FROM t_kppn WHERE kddefa='1'");
  7. 	if($kdgpp == "00" && $kdjenskpp == "01"){
  8. 		mysql_query("INSERT INTO d_skpp(noagenda,kdjenskpp,kdgpp,noskpp,tgskpp,staskpp,anskpp,nip,pangkat,alamat,kdsatker,tujuanskpp,kotatujuan,satkerbaru,kotaasal,tgagdtrm,tgagdsls,userterimaum,statproses) VALUES('$noagenda','$kdjenskpp','$kdgpp','$noskpp','$tgskpp','$staskpp','$anskpp','$nip','$pangkat','$alamat','$kdsatker','$tujuanskpp','$kotatujuan','$satkerbaru','$kotaasal','$tgagdtrm','$tgagdsls','$username','1')");
  9. 	elseif($kdgpp == "01" && $kdjenskpp == "01"){
  10. 		mysql_query("INSERT INTO d_skpp(noagenda,kdjenskpp,kdgpp,noskpp,tgskpp,staskpp,anskpp,nip,pangkat,alamat,kdsatker,tujuanskpp,kotatujuan,satkerbaru,kotaasal,tgagdtrm,tgagdsls,userterimaum,statproses) VALUES('$noagenda','$kdjenskpp','$kdgpp','$noskpp','$tgskpp','$staskpp','$anskpp','$nip','$pangkat','$alamat','$kdsatker','$tujuanskpp','$kotatujuan','$satkerbaru','$kotaasal','$tgagdtrm','$tgagdsls','$username','1')");
  11. 			
  12. 			$qDataSkpp		= mysql_query("SELECT noagenda,date_format(date(tgagdtrm),'%d-%m-%Y'),anskpp,noskpp,date_format(date(tgagdsls),'%d-%m-%Y'),date(tgagdsls),tgctkkonseppd,tgctknetpd,id_skpp,kdjenskpp,kdgpp,statproses,tujuanskpp,pangkat,userterimaum,userparafkasipd,tgparafkasipd,usertdtgnkasipd,tgtdtgnkasipd,userterimaum FROM d_skpp WHERE kdgpp='01' AND statproses!='0' AND namapengambil is null  ORDER BY statproses, noagenda DESC,tgagdtrm,tgagdsls")or die(mysql_error);
  13. 			
  14. 			$qDataSkpp		= mysql_query("SELECT noagenda,date_format(date(tgagdtrm),'%d-%m-%Y') AS tgagdtrm,anskpp,noskpp,date_format(date(tgagdsls),'%d-%m-%Y') AS tgagdsls ,date(tgagdsls) AS batasselesai,tgctkkonseppd,tgctknetpd,id_skpp,kdjenskpp,kdgpp,statproses FROM d_skpp WHERE kdgpp='01' AND statproses!='0' AND  namapengambil is null  ORDER BY statproses,noagenda DESC,tgagdtrm,tgagdsls")or die(mysql_error);
  15. 			
  16. 			$qDataSkpp		= mysql_query("SELECT noagenda,date_format(date(tgagdtrm),'%d-%m-%Y') AS tgagdtrm,anskpp,noskpp,date_format(date(tgagdsls),'%d-%m-%Y') AS tgagdsls ,date(tgagdsls) AS batasselesai,tgctkkonseppd,tgctknetpd,id_skpp,kdjenskpp,kdgpp,statproses FROM d_skpp WHERE kdgpp='00' AND statproses!='0' AND  namapengambil  is null  ORDER BY statproses,noagenda DESC,tgagdtrm,tgagdsls")or die(mysql_error);

















Back to Top