API tools faq
paste
bellaabby

Untitled

bellaabby
Jun 27th, 2016
61
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 73.19 KB | None | 0 0
raw download clone embed print report
  1. <?php
  2. /**
  3. * @author alan ridwan
  4. * @copyright 2010
  5. * @Modified By. SMKN 4 TKJ 2
  6. */
  7. if(!defined("DCISTEM")) {
  8. die("<h1>Permission Denied</h1>You don't have permission to access the this page.");
  9. }
  10. error_reporting(E_ALL ^ E_NOTICE);
  11. function konten() {
  12. $act = $_GET['id'];
  13. if ($_GET['id']=='') $act = $_POST['id'];
  14. // $akses = $user->userLevelmenu($idmenu,$act);
  15. $akses = "1";
  16. if ($akses=='1') {
  17. switch ($act) {
  18. case ("detail") : // tampilkan detail
  19. $konten .= detaildata();
  20. break;
  21. case ("add") : // tambah data
  22. $konten .= tambahdata();
  23. break;
  24. case ("edit") : // edit data
  25. $konten .= editdata();
  26. break;
  27. case ("del") : // hapus data
  28. $konten .= hapusdata();
  29. break;
  30. case ("save") : // save data
  31. $konten .= savedata();
  32. break;
  33. case ("lihat") : // save data
  34. $konten .= viewdata();
  35. break;
  36. default :
  37. $konten .= "Selamat Datang di sistem pengisian data peserta didik online";
  38. break;
  39. }
  40. }
  41. else {
  42. $konten .= "<br><br>".$user->coreDisplayForbiden("Perhatian","Anda tidak dapat mengakses fasilitas ini");
  43. }
  44.  
  45.  
  46. return $konten;
  47. }
  48.  
  49. function viewdata() {
  50.  
  51. $cetak .="<h3>Daftar Peserta Didik</h3>";
  52. $cetak .= "<form action='index.php' method=get >
  53. Nama : <input type=text name=nama value='".$_GET['nama']."' /> <input type=submit value='Cari' />
  54. <input type=hidden name='id' value='lihat' /></form>";
  55. $cetak .= "<br><table id='tablebaru' width='800' ><tr >
  56. <td class='header' width='5'>No</td><td class='header' width='100'>NISN</td>
  57. <td class='header' >Nama</td><td class='header' width='50'>Kel</td>
  58. <td class='header' width='100'>Kontrol</td></tr>";
  59. $i=1;
  60. $host = localhost; // isi sesuai settingan sql kamu
  61. $username =root;
  62. $password = test123;
  63. $db = daftar_ulang;
  64. $con = mysqli_connect($host, $username, $password, $db);
  65. $sql = mysqli_query($con, "select * from t_siswa where namalengkap like'%".$_GET['nama']."%'");
  66.  
  67. while($row=mysqli_fetch_array($sql)) {
  68. $td = ($i % 2 ) ? $td ="td1":"td2";
  69. $cetak .="<tr class='$td' onMouseOver=\"this.className='highlight'\" onMouseOut=\"this.className='$td'\" >
  70. <td class='td' >".$i."</td>
  71. <td class='td' >".$row['id']."</td>
  72. <td class='td' >".$row['namalengkap']."</td>
  73. <td class='td' >".$row['kelamin']."</td>
  74.  
  75. <td class='td' ><a href='index.php?id=edit&kode=".$row['id']."' title='Klik untuk lihat data' >Lihat Data</a>
  76. </td>
  77. </tr>";
  78. $i++;
  79. }
  80. $cetak .="</table><br>";
  81.  
  82. return $cetak;
  83. }
  84. // <td class='td' ><a href='index.php?id=edit&kode=".$row['id']."' title='Klik untuk edit data' >Edit</a> |
  85. // <a href='index.php?id=del&kode=".$row['id']."' title='klik untuk menghapus data' >Hapus</a></td>
  86. function editdata(){
  87. global $idmenu,$user;
  88. $cetak .='<script language="JavaScript" type="text/javascript">
  89. function checkform ( form ) {
  90. if (form.nama.value == "") {
  91. alert( "Nama masih kosong" );
  92. form.nama.focus();
  93. return false ;
  94. }
  95. else if (form.nisn.value == "") {
  96. alert( "NISN masih kosong" );
  97. form.nsin.focus();
  98. return false ;
  99. }
  100. else if (form.panggil.value == "") {
  101. alert( "Panggil masih kosong" );
  102. form.panggil.focus();
  103. return false ;
  104. }
  105. else if (form.tmplahir.value == "") {
  106. alert( "Tempat Lahir masih kosong" );
  107. form.tmplahir.focus();
  108. return false ;
  109. }
  110. else if (form.anakke.value == "") {
  111. alert( "Anak Ke masih kosong" );
  112. form.anakke.focus();
  113. return false ;
  114. }
  115. else if (form.jmlsaudara.value == "") {
  116. alert( "Jumlah Saudara masih kosong" );
  117. form.jmlsaudara.focus();
  118. return false ;
  119. }
  120. lse if (form.jmlsaudaratiri.value == "") {
  121. alert( "Jumlah Saudara Tiri masih kosong" );
  122. form.jmlsaudaratiri.focus();
  123. return false ;
  124. }
  125. else if (form.bahasa.value == "") {
  126. alert( "Bahasa masih kosong" );
  127. form.bahasa.focus();
  128. return false ;
  129. }
  130. else if (form.hobi.value == "") {
  131. alert( "Hobi masih kosong" );
  132. form.hobi.focus();
  133. return false ;
  134. }
  135. else if (form.bakat.value == "") {
  136. alert( "Bakat masih kosong" );
  137. form.bakat.focus();
  138. return false ;
  139. }
  140. else if (form.alamat.value == "") {
  141. alert( "Alamat masih kosong" );
  142. form.alamat.focus();
  143. return false ;
  144. }
  145. else if (form.strumah.value == "") {
  146. alert( "Status Rumah masih kosong" );
  147. form.strumah.focus();
  148. return false ;
  149. }
  150. else if (form.tinggal.value == "") {
  151. alert( "Tinggal dengan masih kosong" );
  152. form.tinggal.focus();
  153. return false ;
  154. }
  155. else if (form.jarak.value == "") {
  156. alert( "Jarak ke sekolah masih kosong" );
  157. form.jarak.focus();
  158. return false ;
  159. }
  160.  
  161. else if (form.telepon.value == "") {
  162. alert( "Telepon masih kosong" );
  163. form.telepon.focus();
  164. return false ;
  165. }
  166. else if (form.hp.value == "") {
  167. alert( "HP masih kosong" );
  168. form.hp.focus();
  169. return false ;
  170. }
  171. else if (form.email.value == "") {
  172. alert( "Email masih kosong" );
  173. form.email.focus();
  174. return false ;
  175. }
  176. else if (form.berat.value == "") {
  177. alert( "Berat masih kosong" );
  178. form.berat.focus();
  179. return false ;
  180. }
  181. else if (form.tinggi.value == "") {
  182. alert( "Tinggi masih kosong" );
  183. form.tinggi.focus();
  184. return false ;
  185. }
  186. else if (form.goldarah.value == "") {
  187. alert( "Gol darah masih kosong" );
  188. form.goldarah.focus();
  189. return false ;
  190. }
  191. else if (form.penyakit.value == "") {
  192. alert( "Penyakit masih kosong" );
  193. form.penyakit.focus();
  194. return false ;
  195. }
  196. else if (form.namaayah.value == "") {
  197. alert( "Nama Ayah masih kosong" );
  198. form.namaayah.focus();
  199. return false ;
  200. }
  201. else if (form.pendiayah.value == "") {
  202. alert( "Pendidikan ayah masih kosong" );
  203. form.pendiayah.focus();
  204. return false ;
  205. }
  206. else if (form.pekerayah.value == "") {
  207. alert( "Pekerjaan Ayah masih kosong" );
  208. form.pekerayah.focus();
  209. return false ;
  210. }
  211. else if (form.hasilayah.value == "") {
  212. alert( "Penghasilan ayah masih kosong" );
  213. form.hasilayah.focus();
  214. return false ;
  215. }
  216. else if (form.almtayah.value == "") {
  217. alert( "Alamat Ayah masih kosong" );
  218. form.almtayah.focus();
  219. return false ;
  220. }
  221. else if (form.telpayah.value == "") {
  222. alert( "Telepon ayah masih kosong" );
  223. form.telpayah.focus();
  224. return false ;
  225. }
  226. else if (form.hpayah.value == "") {
  227. alert( "HP Ayah masih kosong" );
  228. form.hpayah.focus();
  229. return false ;
  230. }
  231. else if (form.emailayah.value == "") {
  232. alert( "Email ayah masih kosong" );
  233. form.emailayah.focus();
  234. return false ;
  235. }
  236. else if (form.namaibu.value == "") {
  237. alert( "Nama ibu masih kosong" );
  238. form.namaibu.focus();
  239. return false ;
  240. }
  241. else if (form.pendiibu.value == "") {
  242. alert( "Pendidikan ibu masih kosong" );
  243. form.pendiibu.focus();
  244. return false ;
  245. }
  246. else if (form.pekeribu.value == "") {
  247. alert( "Pekerjaan ibu masih kosong" );
  248. form.pekeribu.focus();
  249. return false ;
  250. }
  251. else if (form.hasilibu.value == "") {
  252. alert( "Penghasilan ibu masih kosong" );
  253. form.hasilibu.focus();
  254. return false ;
  255. }
  256. else if (form.almtibu.value == "") {
  257. alert( "Alamat ibu masih kosong" );
  258. form.almtibu.focus();
  259. return false ;
  260. }
  261. else if (form.telpibu.value == "") {
  262. alert( "Telepon ibu masih kosong" );
  263. form.telpibu.focus();
  264. return false ;
  265. }
  266. else if (form.hpibu.value == "") {
  267. alert( "HP ibu masih kosong" );
  268. form.hpibu.focus();
  269. return false ;
  270. }
  271. else if (form.emailibu.value == "") {
  272. alert( "Email ibu masih kosong" );
  273. form.emailibu.focus();
  274. return false ;
  275. }
  276. else if (form.namawali.value == "") {
  277. alert( "Nama wali masih kosong" );
  278. form.namawali.focus();
  279. return false ;
  280. }
  281. else if (form.pendiwali.value == "") {
  282. alert( "Pendidikan wali masih kosong" );
  283. form.pendiwali.focus();
  284. return false ;
  285. }
  286. else if (form.pekerwali.value == "") {
  287. alert( "Pekerjaan wali masih kosong" );
  288. form.pekerwali.focus();
  289. return false ;
  290. }
  291. else if (form.hasilwali.value == "") {
  292. alert( "Penghasilan wali masih kosong" );
  293. form.hasilwali.focus();
  294. return false ;
  295. }
  296. else if (form.almtwali.value == "") {
  297. alert( "Alamat wali masih kosong" );
  298. form.almtwali.focus();
  299. return false ;
  300. }
  301. else if (form.telpwali.value == "") {
  302. alert( "Telepon wali masih kosong" );
  303. form.telpwali.focus();
  304. return false ;
  305. }
  306. else if (form.hpwali.value == "") {
  307. alert( "HP wali masih kosong" );
  308. form.hpwali.focus();
  309. return false ;
  310. }
  311. else if (form.emailwali.value == "") {
  312. alert( "Email wali masih kosong" );
  313. form.emailwali.focus();
  314. return false ;
  315. }
  316. else if (form.asalsekolah.value == "") {
  317. alert( "Asal Sekolah masih kosong" );
  318. form.asalsekolah.focus();
  319. return false ;
  320. }
  321. else if (form.ijazah.value == "") {
  322. alert( "Ijazah masih kosong" );
  323. form.ijazah.focus();
  324. return false ;
  325. }
  326. else if (form.almtsurat.value == "") {
  327. alert( "Alamat Surat masih kosong" );
  328. form.almtsurat.focus();
  329. return false ;
  330. }
  331. else if (form.ket.value == "") {
  332. alert( "Ket masih kosong" );
  333. form.ket.focus();
  334. return false ;
  335. }
  336. return true ;
  337. }
  338.  
  339. </script>';
  340. $kode = CekVar('kode','numeric');
  341. $cetak .="<h3>Perubahan Data Peserta Didik</h3>";
  342. $sql=mysqli_query("select * from t_siswa where id='".$kode."'");
  343. if($row=mysql_fetch_array($sql)) {
  344. $cetak .="<form action='index.php' method='post' onsubmit='return checkform(this);' ><input type='hidden' name='id' value='save' />
  345. <input type='hidden' name='kode' value='".$kode."' /><input type='hidden' name='act' value='save' />";
  346. $cetak .= "<script language='javascript' src='includes/ssCalendar.js'></script>";
  347. //$tgllahir=date("d-m-Y",strtotime($row['TGL_LAHIR']));
  348. $cetak .="<table border=0 id=tablebaru width=800 > ";
  349. $cetak .="<tr><td colspan=2 class='td1' height='30' > <b> :: Data Pribadi Peserta Didik</b></td></tr>";
  350. $cetak .="<tr><td width='200' class=td2> NISN</td><td><input type='text' name='nisn' value='".$row['id']."' size='20' readonly /></td></tr>";
  351. $cetak .="<tr><td width='200' class=td2> No. Data</td><td><input type='text' name='nodata' value='".$row['nodata']."' size='20' maxlength='15' /></td></tr>";
  352. $cetak .="<tr><td width='200' class=td2> Kelompok</td><td><input type='text' name='kelompok' value='".$row['kelompok']."' size='5' maxlength='4' /></td></tr>";
  353. $cetak .="<tr><td class=td2> Nama Lengkap</td><td><input type='text' name='nama' value='".$row['namalengkap']."' maxlength='100' size='40' /></td></tr>";
  354. $cetak .="<tr><td class=td2> Panggilan</td><td><input type='text' name='panggil' value='".$row['namapanggilan']."' maxlength='50' size='30' /></td></tr>";
  355. $cetak .="<tr><td class=td2> Jenis Kelamin</td><td><select name='kelamin' ><option value='L' ";$cetak.=$row['kelamin']=='L'?'selected':'';$cetak.=" >Laki-laki</option><option value='P' ";$cetak.=$row['kelamin']=='P'?'selected':'';$cetak.=" >Perempuan</option></select></td></tr>";
  356. $cetak .="<tr><td class=td2> Tempat Lahir</td><td><input type='text' name='tmplahir' value='".$row['tmplahir']."' maxlength='25' size='20' /></td></tr>";
  357. $cetak .="<tr><td class=td2> Tgl Lahir</td><td><input type='text' name='tgllahir' id='tgl' value='".$row['tgllahir']."' readonly />
  358. <a href='#' id='anctgl' ><img border=0 style='width:16px;height:16px'' src='images/ssCalendar.jpg' /></a>
  359. <br><div id='dtDivtgl' border='0' class='calCanvas'></div></td></tr>";
  360. if($row['agama']=='Islam') $s1='selected';
  361. elseif($row['agama']=='Katolik') $s2='selected';
  362. elseif($row['agama']=='Protestan') $s3='selected';
  363. elseif($row['agama']=='Budha') $s4='selected';
  364. else $s5='selected';
  365.  
  366.  
  367. $cetak .="<tr><td class=td2> Agama</td><td><select name='agama' ><option value='Islam' $s1 >Islam</option>
  368. <option value='Katolik' $s2 >Katolik</option><option value='Protestan' $s3 >Protestan</option>
  369. <option value='Budha' $s4 >Budha</option><option value='Hindu' $s5 >Hindu</option></select></td></tr>";
  370. if($row['warganegara']=='WNI') $se1='selected';
  371. else $se2='selected';
  372. $anakke= $row['anakke'];
  373. $jmlsaudara=$row['saudarakandung'];
  374. $jmlsaudaratiri=$row['saudaratiri'];
  375. $bahasa = $row['bahasa'];
  376. $hobi = $row['hobi'];
  377. $bakat = $row['bakat'];
  378. $jarak = $row['jaraksekolah'];
  379.  
  380. if ($row['kendaraan']=='Mobil') $kn1='selected';
  381. elseif ($row['kendaraan']=='Motor') $kn2='selected';
  382. elseif ($row['kendaraan']=='Angkutan Umum') $kn3='selected';
  383. else $kn4='selected';
  384.  
  385. //$kendaranan=$row['kendaraan'];
  386. $hp =$row['hp'];
  387. $telp = $row['telp'];
  388. $email=$row['email'];
  389. if ($row['statusrumah']=='Kontrak') $k1='selected';
  390. else $k2 = 'selected';
  391.  
  392. if($row['tinggal']=='Orang Tua') $t1='selected';
  393. elseif($row['tinggal']=='Saudara') $t2='selected';
  394. elseif($row['tinggal']=='Kakek Nenek') $t3='selected';
  395. else $t4='selected';
  396.  
  397. $tinggal = $row['tinggal'];
  398. $almtsurat=$row['alamatsurat'];
  399. $ket =$row['ket'];
  400. $alamat = $row['alamat'];
  401.  
  402. $cetak .="<tr><td class=td2> Kewarganegaraan</td><td><select name='warganegara' ><option value='WNI' $se1 >WNI</option><option value='WNA' $se2 >WNA</option></select></td></tr>";
  403. $cetak .="<tr><td class=td2> Anak ke berapa</td><td><input type='text' name='anakke' value='".$anakke."' maxlength='2' size='5' /></td></tr>";
  404. $cetak .="<tr><td class=td2> Jumlah Saudara</td><td><input type='text' name='jmlsaudara' value='".$jmlsaudara."' maxlength='2' size='5' /></td></tr>";
  405. $cetak .="<tr><td class=td2> Jumlah Saudara Tiri</td><td><input type='text' name='jmlsaudaratiri' value='".$jmlsaudaratiri."' maxlength='2' size='5' /></td></tr>";
  406. $cetak .="<tr><td class=td2> Bahasa Sehari-hari</td><td><input type='text' name='bahasa' value='".$bahasa."' maxlength='15' size='20' /></td></tr>";
  407. $cetak .="<tr><td class=td2> Hobi</td><td><input type='text' name='hobi' value='".$hobi."' maxlength='200' size='50' /></td></tr>";
  408. $cetak .="<tr><td class=td2> Bakat khusus</td><td><input type='text' name='bakat' value='".$bakat."' maxlength='200' size='50' /></td></tr>";
  409. $cetak .="</table><br>";
  410.  
  411. $cetak .="<table border=0 id=tablebaru width=800 > ";
  412. $cetak .="<tr><td colspan=2 class='td1' height='30' > <b> :: Keterangan Tempat Tinggal</b></td></tr>";
  413. $cetak .="<tr><td class=td2 valign=top width=200 > Alamat</td><td><textarea name='alamat' cols=50 rows='2' >".$alamat."</textarea></td></tr>";
  414. $cetak .="<tr><td class=td2> Status Rumah</td><td>
  415. <select name='strumah' ><option value='Kontrak' $k1 >Kontrak</option>
  416. <option value='Hak Milik' $k2 >Hak Milik</option></select></td></tr>";
  417. $cetak .="<tr><td class=td2> Tinggal dengan</td><td>
  418. <select name='tinggal' ><option value='Orang Tua' $t1 >Orang Tua</option>
  419. <option value='Saudara' $t2 >Saudara</option>
  420. <option value='Kakek Nenek' $t3 >Kakek Nenek</option>
  421. <option value='Asrama' $t4 >Asrama</option>
  422. <option value='Lain-lain' $t5 >Lain-lain</option></select></td></tr>";
  423. $cetak .="<tr><td class=td2> Jarak ke sekolah</td><td><input type='text' name='jarak' value='".$jarak."' maxlength='5' size='7' /> Km</td></tr>";
  424. $cetak .="<tr><td class=td2> Kendaraan</td><td><select name='kendaraan' ><option value='Mobil' $kn1 >Mobil</option>
  425. <option value='Motor' $kn2 >Motor</option><option value='Angkutan Umum' $kn3 >Angkutan Umum</option>
  426. <option value='Jalan Kaki' $kn4 >Jalan Kaki</option></select>
  427. </td></tr>";
  428. $cetak .="<tr><td class=td2> Telepon</td><td><input type='text' name='telepon' value='".$telp."' maxlength='15' size='20' /></td></tr>";
  429. $cetak .="<tr><td class=td2> Handphone</td><td><input type='text' name='hp' value='".$hp."' maxlength='20' size='20' /></td></tr>";
  430. $cetak .="<tr><td class=td2> Email</td><td><input type='text' name='email' value='".$email."' maxlength='30' size='30' /></td></tr>";
  431. $cetak .="</table><br>";
  432. $sql2=mysqli_query("select * from t_siswakesehatan where id='".$kode."'");
  433. if($r=mysql_fetch_array($sql2)) {
  434. $berat=$r['berat'];
  435. $tinggi=$r['tinggi'];
  436. if ($r['goldarah']=='A') $g1='selected';
  437. elseif ($r['goldarah']=='B') $g2='selected';
  438. elseif ($r['goldarah']=='AB') $g3='selected';
  439. else $g4='selected';
  440. $penyakit = $r['penyakit'];
  441. }
  442. $cetak .="<table border=0 id=tablebaru width=800 > ";
  443. $cetak .="<tr><td colspan=2 class='td1' height='30' > <b> :: Keterangan Kesehatan</b></td></tr>";
  444. $cetak .="<tr><td class=td2 width=200 > Berat Badan</td><td><input type='text' name='berat' value='".$berat."' maxlength='3' size='3' /> Kg</td></tr>";
  445. $cetak .="<tr><td class=td2> Tinggi Badan</td><td><input type='text' name='tinggi' value='".$tinggi."' maxlength='3' size='3' /> Cm</td></tr>";
  446. $cetak .="<tr><td class=td2> Golongan Darah</td><td><select name='goldarah' >
  447. <option value='A' $g1 >A</option><option value='B' $g2 >B</option><option value='AB' $g3 >AB</option><option value='O' $g4 >O</option></select></td></tr>";
  448. $cetak .="<tr><td class=td2> Riwayat Penyakit</td><td><input type='text' name='penyakit' value='".$penyakit."' maxlength='30' size='50' /></td></tr>";
  449. $cetak .="</table><br>";
  450. $sql2=mysqli_query("select * from t_siswawali where id='".$kode."'");
  451. if($r=mysql_fetch_array($sql2)) {
  452. $namaayah= $r['NM_AYAH'];
  453. $pendiayah= $r['PEND_AYAH'];
  454. $pekerayah= $r['PKJ_AYAH'];
  455. $hasilayah= $r['HASIL_AYAH'];
  456. $almtayah= $r['ALMT_AYAH'];
  457. $telpayah= $r['TELP_AYAH'];
  458. $hpayah= $r['HP_AYAH'];
  459. $emailayah= $r['EMAIL_AYAH'];
  460.  
  461. $namaibu= $r['NM_IBU'];
  462. $pendiibu= $r['PEND_IBU'];
  463. $pekeribu= $r['PKJ_IBU'];
  464. $hasilibu= $r['HASIL_IBU'];
  465. $almtibu= $r['ALMT_IBU'];
  466. $telpibu= $r['TELP_IBU'];
  467. $hpibu= $r['HP_IBU'];
  468. $emailibu= $r['EMAIL_IBU'];
  469.  
  470. $namawali= $r['NM_WALI'];
  471. $pendiwali= $r['PEND_WALI'];
  472. $pekerwali= $r['PKJ_WALI'];
  473. $hasilwali= $r['HASIL_WALI'];
  474. $almtwali= $r['ALMT_WALI'];
  475. $telpwali= $r['TELP_WALI'];
  476. $hpwali= $r['HP_WALI'];
  477. $emailwali= $r['EMAIL_WALI'];
  478. }
  479. $cetak .="<table border=0 id=tablebaru width=800 > ";
  480. $cetak .="<tr><td colspan=2 class='td1' height='30' > <b> :: Keterangan Orang Tua</b></td></tr>";
  481. $cetak .="<tr><td colspan=2 > <b> ---------------------------------------------- Ayah ------------------------------------------------</b></td></tr>";
  482. $cetak .="<tr><td class=td2 width=200 > Nama</td><td><input type='text' name='namaayah' value='".$namaayah."' maxlength='30' size='30' /></td></tr>";
  483. $cetak .="<tr><td class=td2> Pendidikan</td><td><input type='text' name='pendiayah' value='".$pendiayah."' maxlength='30' size='30' /></td></tr>";
  484. $cetak .="<tr><td class=td2> Pekerjaan</td><td><input type='text' name='pekerayah' value='".$pekerayah."' maxlength='30' size='30' /></td></tr>";
  485. $cetak .="<tr><td class=td2> Penghasilan</td><td><input type='text' name='hasilayah' value='".$hasilayah."' maxlength='30' size='30' /> per bulan</td></tr>";
  486. $cetak .="<tr><td class=td2> Alamat</td><td><input type='text' name='almtayah' value='".$almtayah."' maxlength='100' size='60' /></td></tr>";
  487. $cetak .="<tr><td class=td2> Telepon</td><td><input type='text' name='telpayah' value='".$telpayah."' maxlength='20' size='20' /></td></tr>";
  488. $cetak .="<tr><td class=td2> Handphone</td><td><input type='text' name='hpayah' value='".$hpayah."' maxlength='20' size='20' /></td></tr>";
  489. $cetak .="<tr><td class=td2> Email</td><td><input type='text' name='emailayah' value='".$emailayah."' maxlength='60' size='40' /></td></tr>";
  490. $cetak .="<tr><td colspan=2 > <b> ---------------------------------------------- Ibu ------------------------------------------------</b></td></tr>";
  491. $cetak .="<tr><td class=td2 width=200 > Nama</td><td><input type='text' name='namaibu' value='".$namaibu."' maxlength='30' size='30' /></td></tr>";
  492. $cetak .="<tr><td class=td2> Pendidikan</td><td><input type='text' name='pendiibu' value='".$pendiibu."' maxlength='30' size='30' /></td></tr>";
  493. $cetak .="<tr><td class=td2> Pekerjaan</td><td><input type='text' name='pekeribu' value='".$pekeribu."' maxlength='30' size='30' /></td></tr>";
  494. $cetak .="<tr><td class=td2> Penghasilan</td><td><input type='text' name='hasilibu' value='".$hasilibu."' maxlength='30' size='30' /> per bulan</td></tr>";
  495. $cetak .="<tr><td class=td2> Alamat</td><td><input type='text' name='almtibu' value='".$almtibu."' maxlength='100' size='60' /></td></tr>";
  496. $cetak .="<tr><td class=td2> Telepon</td><td><input type='text' name='telpibu' value='".$telpibu."' maxlength='20' size='20' /></td></tr>";
  497. $cetak .="<tr><td class=td2> Handphone</td><td><input type='text' name='hpibu' value='".$hpibu."' maxlength='20' size='20' /></td></tr>";
  498. $cetak .="<tr><td class=td2> Email</td><td><input type='text' name='emailibu' value='".$emailibu."' maxlength='60' size='40' /></td></tr>";
  499. $cetak .="<tr><td colspan=2 > <b> ---------------------------------------------- Wali ------------------------------------------------</b></td></tr>";
  500. $cetak .="<tr><td class=td2 width=200 > Nama</td><td><input type='text' name='namawali' value='".$namawali."' maxlength='30' size='30' /></td></tr>";
  501. $cetak .="<tr><td class=td2> Pendidikan</td><td><input type='text' name='pendiwali' value='".$pendiwali."' maxlength='30' size='30' /></td></tr>";
  502. $cetak .="<tr><td class=td2> Pekerjaan</td><td><input type='text' name='pekerwali' value='".$pekerwali."' maxlength='30' size='30' /></td></tr>";
  503. $cetak .="<tr><td class=td2> Penghasilan</td><td><input type='text' name='hasilwali' value='".$hasilwali."' maxlength='30' size='30' /> per bulan</td></tr>";
  504. $cetak .="<tr><td class=td2> Alamat</td><td><input type='text' name='almtwali' value='".$almtwali."' maxlength='100' size='60' /></td></tr>";
  505. $cetak .="<tr><td class=td2> Telepon</td><td><input type='text' name='telpwali' value='".$telpwali."' maxlength='20' size='20' /></td></tr>";
  506. $cetak .="<tr><td class=td2> Handphone</td><td><input type='text' name='hpwali' value='".$hpwali."' maxlength='20' size='20' /></td></tr>";
  507. $cetak .="<tr><td class=td2> Email</td><td><input type='text' name='emailwali' value='".$emailwali."' maxlength='60' size='40' /></td></tr>";
  508.  
  509.  
  510.  
  511.  
  512. $sql2=mysqli_query("select * from t_siswapendidikan where id='".$kode."'");
  513. $sqlMnt=mysqli_query("select * from t_minat where id='".$kode."'");
  514. if($r=mysql_fetch_array($sql2)) {
  515. $asalsekolah= $r['asalsekolah'];
  516. $ijazah=$r['noijazah'];
  517. $skhun=$r['noskhun'];
  518. $jmlskhun=$r['jmlskhun'];
  519. }
  520. if($rmnt=mysql_fetch_array($sqlMnt)) {
  521. if ($rmnt['pilanak']=='IPA') $pa1='selected';
  522. else $pa2='selected';
  523.  
  524. if ($rmnt['lintasminat']=='Fisika') $bm1='selected';
  525. elseif ($rmnt['lintasminat']=='Kimia') $bm2='selected';
  526. elseif ($rmnt['lintasminat']=='Biologi') $bm3='selected';
  527. elseif ($rmnt['lintasminat']=='Geografi') $bm4='selected';
  528. elseif ($rmnt['lintasminat']=='Ekonomi') $bm5='selected';
  529. else $bm6='selected';
  530.  
  531. if ($rmnt['pilortu']=='IPA') $po1='selected';
  532. else $po2='selected';
  533.  
  534. $mats1=$rmnt['mats1'];$mats2=$rmnt['mats2'];$mats3=$rmnt['mats3'];
  535. $mats4=$rmnt['mats4'];$mats5=$rmnt['mats5'];$mats6=$rmnt['mats6'];
  536.  
  537. $ipas1=$rmnt['ipas1'];$ipas2=$rmnt['ipas2'];$ipas3=$rmnt['ipas3'];
  538. $ipas4=$rmnt['ipas4'];$ipas5=$rmnt['ipas5'];$ipas6=$rmnt['ipas6'];
  539.  
  540. $ipss1=$rmnt['ipss1'];$ipss2=$rmnt['ipss2'];$ipss3=$rmnt['ipss3'];
  541. $ipss4=$rmnt['ipss4'];$ipss5=$rmnt['ipss5'];$ipss6=$rmnt['ipss6'];
  542.  
  543. $unipa=$rmnt['unipa'];
  544. $kecerdasan=$rmnt['kecerdasan'];
  545.  
  546. if ($rmnt['bakatminat']=='IPA') $mb1='selected';
  547. elseif ($rmnt['bakatminat']=='IPS') $mb2='selected';
  548. else $mb3='selected';
  549. }
  550.  
  551.  
  552. $cetak .="</table><br>";
  553. $cetak .="<table border=0 id=tablebaru width=800 > ";
  554. $cetak .="<tr><td colspan=2 class='td1' height='30' > <b> :: Keterangan Pendidikan Sebelumnya</b></td></tr>";
  555. $cetak .="<tr><td class=td2 width=200 > Asal Sekolah</td><td><input type='text' name='asalsekolah' value='".$asalsekolah."' maxlength='30' size='40' /></td></tr>";
  556. $cetak .="<tr><td class=td2> No Ijazah</td><td><input type='text' name='ijazah' value='".$ijazah."' maxlength='25' size='30' /></td></tr>";
  557.  
  558. $cetak .="<tr><td class=td2> No SKHUN</td><td><input type='text' name='skhun' value='".$skhun."' maxlength='25' size='30' /></td></tr>";
  559. $cetak .="<tr><td class=td2> Jumlah Nilai SKHUN</td><td><input type='text' name='jmlskhun' maxlength='10' value='".$jmlskhun."' size='20' /></td></tr>";
  560. $cetak .="</table><br>";
  561.  
  562.  
  563. $cetak .="<table border=0 id=tablebaru width=800 > ";
  564. $cetak .="<tr><td colspan=2 class='td1' height='30' > <b> :: Angket Program Peminatan</b></td></tr>";
  565. $cetak .="<tr><td class=td2 width=200 > Program Pilihan Anda</td><td><select name='pilanak' >
  566. <option value='IPA' $pa1 >IPA</option><option value='IPS' $pa2 >IPS</option></select>
  567. </td></tr>";
  568. $cetak .="<tr><td class=td2> Lintas Minat/Pendalaman Minat</td><td><select name='lintasminat' ><option value='Fisika' $bm1>Fisika</option><option value='Kimia' $bm2>Kimia</option><option value='Biologi' $bm3>Biologi</option><option value='Geografi' $bm4>Geografi</option><option value='Ekonomi' $bm5>Ekonomi</option><option value='Sosiologi' $bm6>Sosiologi</option></select></td></tr>";
  569. $cetak .="<tr><td class=td2> Program Pilihan Ortu</td><td><select name='pilortu' ><option value='IPA' $po1>IPA</option><option value='IPS' $po2>IPS</option></select></td></tr>";
  570. $cetak .="<tr><td colspan=2> <b>Nilai Raport SMP (Diisi dengan benar dan akan diperiksa kembali)</b> </td></tr>";
  571. $cetak .="<tr><td class=td2> Matematika Semester 1</td><td><input type='text' name='mats1' value='".$mats1."' maxlength='3' size='5' /></td></tr>";
  572. $cetak .="<tr><td class=td2> Matematika Semester 2</td><td><input type='text' name='mats2' value='".$mats2."' maxlength='3' size='5' /></td></tr>";
  573. $cetak .="<tr><td class=td2> Matematika Semester 3</td><td><input type='text' name='mats3' value='".$mats3."' maxlength='3' size='5' /></td></tr>";
  574. $cetak .="<tr><td class=td2> Matematika Semester 4</td><td><input type='text' name='mats4' value='".$mats4."' maxlength='3' size='5' /></td></tr>";
  575. $cetak .="<tr><td class=td2> Matematika Semester 5</td><td><input type='text' name='mats5' value='".$mats5."' maxlength='3' size='5' /></td></tr>";
  576. $cetak .="<tr><td class=td2> Matematika Semester 6</td><td><input type='text' name='mats6' value='".$mats6."' maxlength='3' size='5' /></td></tr>";
  577. $cetak .="<tr><td colspan=2> ----------------------------------------------------------------------- </td></tr>";
  578. $cetak .="<tr><td class=td2> IPA Semester 1</td><td><input type='text' name='ipas1' value='".$ipas1."' maxlength='3' size='5' /></td></tr>";
  579. $cetak .="<tr><td class=td2> IPA Semester 2</td><td><input type='text' name='ipas2' value='".$ipas2."' maxlength='3' size='5' /></td></tr>";
  580. $cetak .="<tr><td class=td2> IPA Semester 3</td><td><input type='text' name='ipas3' value='".$ipas3."' maxlength='3' size='5' /></td></tr>";
  581. $cetak .="<tr><td class=td2> IPA Semester 4</td><td><input type='text' name='ipas4' value='".$ipas4."' maxlength='3' size='5' /></td></tr>";
  582. $cetak .="<tr><td class=td2> IPA Semester 5</td><td><input type='text' name='ipas5' value='".$ipas5."' maxlength='3' size='5' /></td></tr>";
  583. $cetak .="<tr><td class=td2> IPA Semester 6</td><td><input type='text' name='ipas6' value='".$ipas6."' maxlength='3' size='5' /></td></tr>";
  584. $cetak .="<tr><td colspan=2> ----------------------------------------------------------------------- </td></tr>";
  585. $cetak .="<tr><td class=td2> IPS Semester 1</td><td><input type='text' name='ipss1' value='".$ipss1."' maxlength='3' size='5' /></td></tr>";
  586. $cetak .="<tr><td class=td2> IPS Semester 2</td><td><input type='text' name='ipss2' value='".$ipss2."' maxlength='3' size='5' /></td></tr>";
  587. $cetak .="<tr><td class=td2> IPS Semester 3</td><td><input type='text' name='ipss3' value='".$ipss3."' maxlength='3' size='5' /></td></tr>";
  588. $cetak .="<tr><td class=td2> IPS Semester 4</td><td><input type='text' name='ipss4' value='".$ipss4."' maxlength='3' size='5' /></td></tr>";
  589. $cetak .="<tr><td class=td2> IPS Semester 5</td><td><input type='text' name='ipss5' value='".$ipss5."' maxlength='3' size='5' /></td></tr>";
  590. $cetak .="<tr><td class=td2> IPS Semester 6</td><td><input type='text' name='ipss6' value='".$ipss6."' maxlength='3' size='5' /></td></tr>";
  591. $cetak .="<tr><td colspan=2> ----------------------------------------------------------------------- </td></tr>";
  592. $cetak .="<tr><td class=td2> Nilai UN IPA</td><td><input type='text' name='unipa' value='".$unipa."' maxlength='5' size='5' /></td></tr>";
  593. $cetak .="<tr><td colspan=2> Hasil Psikotes (Jika Ada) </td></tr>";
  594. $cetak .="<tr><td class=td2> Taraf Kecerdasan</td><td><input type='text' name='kecerdasan' value='".$kecerdasan."' maxlength='10' size='10' /></td></tr>";
  595. $cetak .="<tr><td class=td2> Hasil Tes Bakat dan Minat</td><td><select name='bakatminat' ><option value='IPA' $mb1>IPA</option><option value='IPS' $mb2>IPS</option><option value='Bahasa' $mb3>Bahasa</option></select></td></tr>";
  596. $cetak .="</table><br>";
  597.  
  598.  
  599. $cetak .="<table border=0 id=tablebaru width=800 > ";
  600. $cetak .="<tr><td colspan=2 class='td1' height='30' > <b> :: Keterangan Lainnya</b></td></tr>";
  601. $cetak .="<tr><td class=td2 width=200 > Alamat Surat</td><td><input type='text' name='almtsurat' value='".$almtsurat."' maxlength='100' size='50' /></td></tr>";
  602. $cetak .="<tr><td class=td2> Keterangan</td><td><input type='text' name='ket' value='".$ket."' maxlength='100' size='50' /></td></tr>";
  603. $cetak .="<tr><td></td><td> <a href='?id=".$idmenu."' id='button2' >Kembali</a></td></tr>";
  604. $cetak .="</table></form>";
  605. }
  606. else $cetak .="Data yang akan diubah tidak ada <br><br> Klik <a href='?id=lihat' id='button2' >disini</a> untuk kembali ke daftar data";
  607. $m=date("m"); $d=date("d"); $y=date("Y");
  608. $cetak .='<script language="javascript"><!--
  609. var currYear = '.$y.';
  610. var currMonth = '.$m.';
  611. var dptgl = new DatePicker();
  612. dptgl.id = "tgl";
  613. dptgl.month = '.$m.';
  614. dptgl.year = '.$y.';
  615. dptgl.canvas = "dtDivtgl";
  616. dptgl.format = "dd-mm-yyyy";
  617. dptgl.anchor = "anctgl";
  618. dptgl.initialize();
  619. </script>';
  620. return $cetak;
  621. }
  622.  
  623. function tambahdata(){
  624. global $idmenu,$user;
  625. $cetak .='<script language="JavaScript" type="text/javascript">
  626. function checkform ( form ) {
  627. if (form.nama.value == "") {
  628. alert( "Nama masih kosong" );
  629. form.nama.focus();
  630. return false ;
  631. }
  632. else if (form.nisn.value == "") {
  633. alert( "NISN masih kosong" );
  634. form.nisn.focus();
  635. return false ;
  636. }
  637. else if (form.nodata.value == "") {
  638. alert( "No Data masih kosong" );
  639. form.nisn.focus();
  640. return false ;
  641. }
  642. else if (form.kelompok.value == "") {
  643. alert( "Kelompok masih kosong" );
  644. form.nisn.focus();
  645. return false ;
  646. }
  647. else if (form.panggil.value == "") {
  648. alert( "Panggil masih kosong" );
  649. form.panggil.focus();
  650. return false ;
  651. }
  652. else if (form.tmplahir.value == "") {
  653. alert( "Tempat Lahir masih kosong" );
  654. form.tmplahir.focus();
  655. return false ;
  656. }
  657. else if (form.anakke.value == "") {
  658. alert( "Anak Ke masih kosong" );
  659. form.anakke.focus();
  660. return false ;
  661. }
  662. else if (form.jmlsaudara.value == "") {
  663. alert( "Jumlah Saudara masih kosong" );
  664. form.jmlsaudara.focus();
  665. return false ;
  666. }
  667. else if (form.jmlsaudaratiri.value == "") {
  668. alert( "Jumlah Saudara Tiri masih kosong" );
  669. form.jmlsaudara.focus();
  670. return false ;
  671. }
  672. else if (form.bahasa.value == "") {
  673. alert( "Bahasa masih kosong" );
  674. form.bahasa.focus();
  675. return false ;
  676. }
  677. else if (form.hobi.value == "") {
  678. alert( "Hobi masih kosong" );
  679. form.hobi.focus();
  680. return false ;
  681. }
  682. else if (form.bakat.value == "") {
  683. alert( "Bakat masih kosong" );
  684. form.bakat.focus();
  685. return false ;
  686. }
  687. else if (form.alamat.value == "") {
  688. alert( "Alamat masih kosong" );
  689. form.alamat.focus();
  690. return false ;
  691. }
  692. else if (form.strumah.value == "") {
  693. alert( "Status Rumah masih kosong" );
  694. form.strumah.focus();
  695. return false ;
  696. }
  697. else if (form.tinggal.value == "") {
  698. alert( "Tinggal dengan masih kosong" );
  699. form.tinggal.focus();
  700. return false ;
  701. }
  702. else if (form.jarak.value == "") {
  703. alert( "Jarak ke sekolah masih kosong" );
  704. form.jarak.focus();
  705. return false ;
  706. }
  707. else if (form.kendaraan.value == "") {
  708. alert( "kendaraan masih kosong" );
  709. form.kendaraan.focus();
  710. return false ;
  711. }
  712. else if (form.telepon.value == "") {
  713. alert( "Telepon masih kosong" );
  714. form.telepon.focus();
  715. return false ;
  716. }
  717. else if (form.hp.value == "") {
  718. alert( "HP masih kosong" );
  719. form.hp.focus();
  720. return false ;
  721. }
  722. else if (form.email.value == "") {
  723. alert( "Email masih kosong" );
  724. form.email.focus();
  725. return false ;
  726. }
  727. else if (form.berat.value == "") {
  728. alert( "Berat masih kosong" );
  729. form.berat.focus();
  730. return false ;
  731. }
  732. else if (form.tinggi.value == "") {
  733. alert( "Tinggi masih kosong" );
  734. form.tinggi.focus();
  735. return false ;
  736. }
  737. else if (form.goldarah.value == "") {
  738. alert( "Gol darah masih kosong" );
  739. form.goldarah.focus();
  740. return false ;
  741. }
  742. else if (form.penyakit.value == "") {
  743. alert( "Penyakit masih kosong" );
  744. form.penyakit.focus();
  745. return false ;
  746. }
  747. else if (form.namaayah.value == "") {
  748. alert( "Nama Ayah masih kosong" );
  749. form.namaayah.focus();
  750. return false ;
  751. }
  752. else if (form.pendiayah.value == "") {
  753. alert( "Pendidikan ayah masih kosong" );
  754. form.pendiayah.focus();
  755. return false ;
  756. }
  757. else if (form.pekerayah.value == "") {
  758. alert( "Pekerjaan Ayah masih kosong" );
  759. form.pekerayah.focus();
  760. return false ;
  761. }
  762. else if (form.hasilayah.value == "") {
  763. alert( "Penghasilan ayah masih kosong" );
  764. form.hasilayah.focus();
  765. return false ;
  766. }
  767. else if (form.almtayah.value == "") {
  768. alert( "Alamat Ayah masih kosong" );
  769. form.almtayah.focus();
  770. return false ;
  771. }
  772. else if (form.telpayah.value == "") {
  773. alert( "Telepon ayah masih kosong" );
  774. form.telpayah.focus();
  775. return false ;
  776. }
  777. else if (form.hpayah.value == "") {
  778. alert( "HP Ayah masih kosong" );
  779. form.hpayah.focus();
  780. return false ;
  781. }
  782. else if (form.emailayah.value == "") {
  783. alert( "Email ayah masih kosong" );
  784. form.emailayah.focus();
  785. return false ;
  786. }
  787. else if (form.namaibu.value == "") {
  788. alert( "Nama ibu masih kosong" );
  789. form.namaibu.focus();
  790. return false ;
  791. }
  792. else if (form.pendiibu.value == "") {
  793. alert( "Pendidikan ibu masih kosong" );
  794. form.pendiibu.focus();
  795. return false ;
  796. }
  797. else if (form.pekeribu.value == "") {
  798. alert( "Pekerjaan ibu masih kosong" );
  799. form.pekeribu.focus();
  800. return false ;
  801. }
  802. else if (form.hasilibu.value == "") {
  803. alert( "Penghasilan ibu masih kosong" );
  804. form.hasilibu.focus();
  805. return false ;
  806. }
  807. else if (form.almtibu.value == "") {
  808. alert( "Alamat ibu masih kosong" );
  809. form.almtibu.focus();
  810. return false ;
  811. }
  812. else if (form.telpibu.value == "") {
  813. alert( "Telepon ibu masih kosong" );
  814. form.telpibu.focus();
  815. return false ;
  816. }
  817. else if (form.hpibu.value == "") {
  818. alert( "HP ibu masih kosong" );
  819. form.hpibu.focus();
  820. return false ;
  821. }
  822. else if (form.emailibu.value == "") {
  823. alert( "Email ibu masih kosong" );
  824. form.emailibu.focus();
  825. return false ;
  826. }
  827. else if (form.namawali.value == "") {
  828. alert( "Nama wali masih kosong" );
  829. form.namawali.focus();
  830. return false ;
  831. }
  832. else if (form.pendiwali.value == "") {
  833. alert( "Pendidikan wali masih kosong" );
  834. form.pendiwali.focus();
  835. return false ;
  836. }
  837. else if (form.pekerwali.value == "") {
  838. alert( "Pekerjaan wali masih kosong" );
  839. form.pekerwali.focus();
  840. return false ;
  841. }
  842. else if (form.hasilwali.value == "") {
  843. alert( "Penghasilan wali masih kosong" );
  844. form.hasilwali.focus();
  845. return false ;
  846. }
  847. else if (form.almtwali.value == "") {
  848. alert( "Alamat wali masih kosong" );
  849. form.almtwali.focus();
  850. return false ;
  851. }
  852. else if (form.telpwali.value == "") {
  853. alert( "Telepon wali masih kosong" );
  854. form.telpwali.focus();
  855. return false ;
  856. }
  857. else if (form.hpwali.value == "") {
  858. alert( "HP wali masih kosong" );
  859. form.hpwali.focus();
  860. return false ;
  861. }
  862. else if (form.emailwali.value == "") {
  863. alert( "Email wali masih kosong" );
  864. form.emailwali.focus();
  865. return false ;
  866. }
  867. else if (form.asalsekolah.value == "") {
  868. alert( "Asal Sekolah masih kosong" );
  869. form.asalsekolah.focus();
  870. return false ;
  871. }
  872. else if (form.ijazah.value == "") {
  873. alert( "Ijazah masih kosong" );
  874. form.ijazah.focus();
  875. return false ;
  876. }
  877. else if (form.skhun.value == "") {
  878. alert( "SKHUN masih kosong" );
  879. form.skhun.focus();
  880. return false ;
  881. }
  882.  
  883. else if (form.mats1.value == "") {
  884. alert( "Nilai Matematika Semester 1 masih kosong" );
  885. form.almtsurat.focus();
  886. return false ;
  887. }
  888. else if (form.mats2.value == "") {
  889. alert( "Nilai Matematika Semester 2 masih kosong" );
  890. form.almtsurat.focus();
  891. return false ;
  892. }
  893. else if (form.mats3.value == "") {
  894. alert( "Nilai Matematika Semester 3 masih kosong" );
  895. form.almtsurat.focus();
  896. return false ;
  897. }
  898. else if (form.mats4.value == "") {
  899. alert( "Nilai Matematika Semester 4 masih kosong" );
  900. form.almtsurat.focus();
  901. return false ;
  902. }
  903. else if (form.mats5.value == "") {
  904. alert( "Nilai Matematika Semester 5 masih kosong" );
  905. form.almtsurat.focus();
  906. return false ;
  907. }
  908. else if (form.mats6.value == "") {
  909. alert( "Nilai Matematika Semester 6 masih kosong" );
  910. form.almtsurat.focus();
  911. return false ;
  912. }
  913. else if (form.ipas1.value == "") {
  914. alert( "Nilai IPA Semester 1 masih kosong" );
  915. form.almtsurat.focus();
  916. return false ;
  917. }
  918. else if (form.ipas2.value == "") {
  919. alert( "Nilai IPA Semester 2 masih kosong" );
  920. form.almtsurat.focus();
  921. return false ;
  922. }
  923. else if (form.ipas3.value == "") {
  924. alert( "Nilai IPA Semester 3 masih kosong" );
  925. form.almtsurat.focus();
  926. return false ;
  927. }
  928. else if (form.ipas4.value == "") {
  929. alert( "Nilai IPA Semester 4 masih kosong" );
  930. form.almtsurat.focus();
  931. return false ;
  932. }
  933. else if (form.ipas5.value == "") {
  934. alert( "Nilai IPA Semester 5 masih kosong" );
  935. form.almtsurat.focus();
  936. return false ;
  937. }
  938. else if (form.ipas6.value == "") {
  939. alert( "Nilai IPA Semester 6 masih kosong" );
  940. form.almtsurat.focus();
  941. return false ;
  942. }
  943. else if (form.ipss1.value == "") {
  944. alert( "Nilai IPS Semester 1 masih kosong" );
  945. form.almtsurat.focus();
  946. return false ;
  947. }
  948. else if (form.ipss2.value == "") {
  949. alert( "Nilai IPS Semester 2 masih kosong" );
  950. form.almtsurat.focus();
  951. return false ;
  952. }
  953. else if (form.ipss3.value == "") {
  954. alert( "Nilai IPS Semester 3 masih kosong" );
  955. form.almtsurat.focus();
  956. return false ;
  957. }
  958. else if (form.ipss4.value == "") {
  959. alert( "Nilai IPS Semester 4 masih kosong" );
  960. form.almtsurat.focus();
  961. return false ;
  962. }
  963. else if (form.ipss5.value == "") {
  964. alert( "Nilai IPS Semester 5 masih kosong" );
  965. form.almtsurat.focus();
  966. return false ;
  967. }
  968. else if (form.ipss6.value == "") {
  969. alert( "Nilai IPS Semester 6 masih kosong" );
  970. form.almtsurat.focus();
  971. return false ;
  972. }
  973. else if (form.unipa.value == "") {
  974. alert( "Nilai UN IPA masih kosong" );
  975. form.almtsurat.focus();
  976. return false ;
  977. }
  978. else if (form.kecerdasan.value == "") {
  979. alert( "Nilai Taraf Kecerdasan masih kosong" );
  980. form.almtsurat.focus();
  981. return false ;
  982. }
  983.  
  984.  
  985.  
  986. else if (form.almtsurat.value == "") {
  987. alert( "Alamat Surat masih kosong" );
  988. form.almtsurat.focus();
  989. return false ;
  990. }
  991. else if (form.ket.value == "") {
  992. alert( "Ket masih kosong" );
  993. form.ket.focus();
  994. return false ;
  995. }
  996. return true ;
  997. }
  998.  
  999. </script>';
  1000. $cetak .="<h3>Tambah Data Peserta Didik</h3>";
  1001. $cetak .="<font color='#FF0000'><b>Jika isian kosong, isi dengan tanda -</b></font>";
  1002. $cetak .="<form action='index.php' method='post' onsubmit='return checkform(this);' ><input type='hidden' name='id' value='".$idmenu."' />
  1003. <input type='hidden' name='id' value='save' />";
  1004. $cetak .= "<script language='javascript' src='includes/ssCalendar.js'></script>";
  1005. $cetak .="<table border=0 id=tablebaru width=800 > ";
  1006. $cetak .="<tr><td colspan=2 class='td1' height='30' > <b> :: Data Pribadi Siswa</b></td></tr>";
  1007. $cetak .="<tr><td width='200' class=td2> NISN</td><td><input type='text' name='nisn' value='' size='20' maxlength='15' /></td></tr>";
  1008. $cetak .="<tr><td width='200' class=td2> No. Data</td><td><input type='text' name='nodata' value='' size='20' maxlength='15' /></td></tr>";
  1009. $cetak .="<tr><td width='200' class=td2> Kelompok</td><td><input type='text' name='kelompok' value='' size='5' maxlength='4' /></td></tr>";
  1010. $cetak .="<tr><td class=td2> Nama Lengkap</td><td><input type='text' name='nama' value='' maxlength='50' size='40' /></td></tr>";
  1011. $cetak .="<tr><td class=td2> Panggilan</td><td><input type='text' name='panggil' value='' maxlength='20' size='30' /></td></tr>";
  1012. $cetak .="<tr><td class=td2> Jenis Kelamin</td><td><select name='kelamin' ><option value='L' >Laki-laki</option><option value='P' >Perempuan</option></select></td></tr>";
  1013. $cetak .="<tr><td colspan=2> <font color='#FF0000'>Isi dengan : Kota Lahir, Propinsi Lahir</font></td></tr>";
  1014. $cetak .="<tr><td class=td2> Tempat Lahir</td><td ><input type='text' name='tmplahir' value='' maxlength='25' size='20' /></td></tr>";
  1015. $cetak .="<tr><td class=td2> Tgl Lahir</td><td><input type='text' name='tgllahir' id='tgl' value='' readonly />
  1016. <a href='#' id='anctgl' ><img border=0 style='width:16px;height:16px'' src='images/ssCalendar.jpg' /></a>
  1017. <br><div id='dtDivtgl' border='0' class='calCanvas'></div></td></tr>";
  1018. $cetak .="<tr><td class=td2> Agama</td><td><select name='agama' ><option value='Islam' $s1 >Islam</option>
  1019. <option value='Katolik' $s2 >Katolik</option><option value='Protestan' $s3 >Protestan</option>
  1020. <option value='Budha' $s4 >Budha</option><option value='Hindu' $s5 >Hindu</option></select></td></tr>";
  1021.  
  1022. $cetak .="<tr><td class=td2> Kewarganegaraan</td><td><select name='warganegara' ><option value='WNI' $se1 >WNI</option><option value='WNA' $se2 >WNA</option></select></td></tr>";
  1023. $cetak .="<tr><td class=td2> Anak ke berapa</td><td><input type='text' name='anakke' value='' maxlength='2' size='5' /></td></tr>";
  1024. $cetak .="<tr><td class=td2> Jumlah Saudara</td><td><input type='text' name='jmlsaudara' value='' maxlength='2' size='5' /></td></tr>";
  1025. $cetak .="<tr><td class=td2> Jumlah Saudara Tiri</td><td><input type='text' name='jmlsaudaratiri' value='' maxlength='2' size='5' /></td></tr>";
  1026. $cetak .="<tr><td class=td2> Anak Yatim/Piatu/Yatim Piatu</td><td><select name='yatim' ><option value='Tidak' >Tidak</option><option value='Yatim' >Yatim</option><option value='Piatu' >Piatu</option><option value='Yatim Piatu' >Yatim Piatu</option></select></td></tr>";
  1027. $cetak .="<tr><td class=td2> Bahasa Sehari-hari</td><td><input type='text' name='bahasa' value='' maxlength='15' size='20' /></td></tr>";
  1028. $cetak .="<tr><td class=td2> Hobi</td><td><input type='text' name='hobi' value='' maxlength='200' size='50' /></td></tr>";
  1029. $cetak .="<tr><td class=td2> Bakat khusus</td><td><input type='text' name='bakat' value='' maxlength='200' size='50' /></td></tr>";
  1030. $cetak .="</table><br>";
  1031.  
  1032. $cetak .="<table border=0 id=tablebaru width=800 > ";
  1033. $cetak .="<tr><td colspan=2 class='td1' height='30' > <b> :: Keterangan Tempat Tinggal</b></td></tr>";
  1034. $cetak .="<tr><td class=td2 valign=top width=200 > Alamat</td><td><textarea name='alamat' cols=50 rows='2' ></textarea></td></tr>";
  1035. $cetak .="<tr><td class=td2> Status Rumah</td><td><select name='strumah' ><option value='Kontrak' >Kontrak</option><option value='Hak Milik' >Hak Milik</option></select></td></tr>";
  1036. $cetak .="<tr><td class=td2> Tinggal dengan</td><td><select name='tinggal' ><option value='Orang Tua' >Orang Tua</option><option value='Saudara' >Saudara</option>
  1037. <option value='Kakek Nenek' >Kakek Nenek</option><option value='Asrama' >Asrama</option><option value='Lain-lain' >Lain-lain</option></select></td></tr>";
  1038. $cetak .="<tr><td class=td2> Jarak ke sekolah</td><td><input type='text' name='jarak' maxlength='5' size='7' /> Km</td></tr>";
  1039. $cetak .="<tr><td class=td2> Kendaraan</td><td><select name='kendaraan' ><option value='Mobil' >Mobil</option><option value='Motor' >Motor</option><option value='Angkutan Umum' >Angkutan Umum</option><option value='Jalan Kaki' >Jalan Kaki</option></select></td></tr>";
  1040. $cetak .="<tr><td class=td2> Telepon</td><td><input type='text' name='telepon' maxlength='15' size='20' /></td></tr>";
  1041. $cetak .="<tr><td class=td2> Handphone</td><td><input type='text' name='hp' maxlength='20' size='20' /></td></tr>";
  1042. $cetak .="<tr><td class=td2> Email</td><td><input type='text' name='email' maxlength='100' size='50' /></td></tr>";
  1043. $cetak .="</table><br>";
  1044.  
  1045. $cetak .="<table border=0 id=tablebaru width=800 > ";
  1046. $cetak .="<tr><td colspan=2 class='td1' height='30' > <b> :: Keterangan Kesehatan</b></td></tr>";
  1047. $cetak .="<tr><td class=td2 width=200 > Berat Badan</td><td><input type='text' name='berat' maxlength='3' size='3' /> Kg</td></tr>";
  1048. $cetak .="<tr><td class=td2> Tinggi Badan</td><td><input type='text' name='tinggi' maxlength='3' size='3' /> Cm</td></tr>";
  1049. $cetak .="<tr><td class=td2> Golongan Darah</td><td><select name='goldarah' ><option value='A' >A</option><option value='B' >B</option><option value='AB' >AB</option><option value='O' >O</option></select></td></tr>";
  1050. $cetak .="<tr><td class=td2> Riwayat Penyakit</td><td><input type='text' name='penyakit' maxlength='30' size='50' /></td></tr>";
  1051. $cetak .="</table><br>";
  1052.  
  1053. $cetak .="<table border=0 id=tablebaru width=800 > ";
  1054. $cetak .="<tr><td colspan=2 class='td1' height='30' > <b> :: Keterangan Orang Tua</b></td></tr>";
  1055. $cetak .="<tr><td colspan=2 > <b> ---------------------------------------------- Ayah ------------------------------------------------</b></td></tr>";
  1056. $cetak .="<tr><td class=td2 width=200 > Nama</td><td><input type='text' name='namaayah' maxlength='30' size='30' /></td></tr>";
  1057. $cetak .="<tr><td class=td2> Pendidikan</td><td><input type='text' name='pendiayah' maxlength='30' size='30' />Contoh : S1 Teknik Elektro</td></tr>";
  1058. $cetak .="<tr><td class=td2> Pekerjaan</td><td><input type='text' name='pekerayah' maxlength='30' size='30' /></td></tr>";
  1059. $cetak .="<tr><td class=td2> Penghasilan</td><td><select name='hasilayah' ><option value='lebih besar 5 juta' >Lebih besar 5 juta</option>
  1060. <option value='3 s.d 5 juta' >3 s.d 5 juta</option><option value='1 s.d 3 juta' >1 s.d 3 juta</option><option value='lebih kecil 1 juta' >Lebih kecil 1 juta</option></select> per bulan</td></tr>";
  1061. $cetak .="<tr><td class=td2> Alamat</td><td><input type='text' name='almtayah' maxlength='100' size='60' /></td></tr>";
  1062. $cetak .="<tr><td class=td2> Telepon</td><td><input type='text' name='telpayah' maxlength='20' size='20' /></td></tr>";
  1063. $cetak .="<tr><td class=td2> Handphone</td><td><input type='text' name='hpayah' maxlength='20' size='20' /></td></tr>";
  1064. $cetak .="<tr><td class=td2> Email</td><td><input type='text' name='emailayah' maxlength='60' size='40' /></td></tr>";
  1065. $cetak .="<tr><td colspan=2 > <b> ---------------------------------------------- Ibu ------------------------------------------------</b></td></tr>";
  1066. $cetak .="<tr><td class=td2 width=200 > Nama</td><td><input type='text' name='namaibu' maxlength='30' size='30' /></td></tr>";
  1067. $cetak .="<tr><td class=td2> Pendidikan</td><td><input type='text' name='pendiibu' maxlength='30' size='30' />Contoh : S1 Teknik Elektro</td></tr>";
  1068. $cetak .="<tr><td class=td2> Pekerjaan</td><td><input type='text' name='pekeribu' maxlength='30' size='30' /></td></tr>";
  1069. $cetak .="<tr><td class=td2> Penghasilan</td><td><select name='hasilibu' ><option value='lebih besar 5 juta' >Lebih besar 5 juta</option>
  1070. <option value='3 s.d 5 juta' >3 s.d 5 juta</option><option value='1 s.d 3 juta' >1 s.d 3 juta</option><option value='lebih kecil 1 juta' >Lebih kecil 1 juta</option></select> per bulan</td></tr>";
  1071. $cetak .="<tr><td class=td2> Alamat</td><td><input type='text' name='almtibu' maxlength='100' size='60' /></td></tr>";
  1072. $cetak .="<tr><td class=td2> Telepon</td><td><input type='text' name='telpibu' maxlength='20' size='20' /></td></tr>";
  1073. $cetak .="<tr><td class=td2> Handphone</td><td><input type='text' name='hpibu' maxlength='20' size='20' /></td></tr>";
  1074. $cetak .="<tr><td class=td2> Email</td><td><input type='text' name='emailibu' maxlength='60' size='40' /></td></tr>";
  1075. $cetak .="<tr><td colspan=2 > <b> ---------------------------------------------- Wali ------------------------------------------------</b></td></tr>";
  1076. $cetak .="<tr><td class=td2 width=200 > Nama</td><td><input type='text' name='namawali' maxlength='30' size='30' /></td></tr>";
  1077. $cetak .="<tr><td class=td2> Pendidikan</td><td><input type='text' name='pendiwali' maxlength='30' size='30' />Contoh : S1 Teknik Elektro</td></tr>";
  1078. $cetak .="<tr><td class=td2> Pekerjaan</td><td><input type='text' name='pekerwali' maxlength='30' size='30' /></td></tr>";
  1079. $cetak .="<tr><td class=td2> Penghasilan</td><td><select name='hasilwali' ><option value='lebih besar 5 juta' >Lebih besar 5 juta</option>
  1080. <option value='3 s.d 5 juta' >3 s.d 5 juta</option><option value='1 s.d 3 juta' >1 s.d 3 juta</option><option value='lebih kecil 1 juta' >Lebih kecil 1 juta</option></select> per bulan</td></tr>";
  1081. $cetak .="<tr><td class=td2> Alamat</td><td><input type='text' name='almtwali' maxlength='100' size='60' /></td></tr>";
  1082. $cetak .="<tr><td class=td2> Telepon</td><td><input type='text' name='telpwali' maxlength='20' size='20' /></td></tr>";
  1083. $cetak .="<tr><td class=td2> Handphone</td><td><input type='text' name='hpwali' maxlength='20' size='20' /></td></tr>";
  1084. $cetak .="<tr><td class=td2> Email</td><td><input type='text' name='emailwali' maxlength='60' size='40' /></td></tr>";
  1085.  
  1086. $cetak .="</table><br>";
  1087.  
  1088. $cetak .="<table border=0 id=tablebaru width=800 > ";
  1089. $cetak .="<tr><td colspan=2 class='td1' height='30' > <b> :: Keterangan Pendidikan Sebelumnya</b></td></tr>";
  1090. $cetak .="<tr><td class=td2 width=200 > Asal Sekolah</td><td><input type='text' name='asalsekolah' maxlength='30' size='40' /></td></tr>";
  1091. $cetak .="<tr><td class=td2> No Ijazah</td><td><input type='text' name='ijazah' maxlength='25' size='30' /></td></tr>";
  1092. $cetak .="<tr><td class=td2> No SKHUN</td><td><input type='text' name='skhun' maxlength='25' size='30' /></td></tr>";
  1093. $cetak .="<tr><td class=td2> Jumlah Nilai SKHUN</td><td><input type='text' name='jmlskhun' maxlength='10' size='20' /></td></tr>";
  1094. $cetak .="</table><br>";
  1095.  
  1096.  
  1097. $cetak .="<table border=0 id=tablebaru width=800 > ";
  1098. $cetak .="<tr><td colspan=2 class='td1' height='30' > <b> :: Angket Program Peminatan</b></td></tr>";
  1099. $cetak .="<tr><td class=td2 width=200 > Program Pilihan Anda</td><td><select name='pilanak' ><option value='IPA' >IPA</option><option value='IPS' >IPS</option></select></td></tr>";
  1100. $cetak .="<tr><td class=td2> Lintas Minat/Pendalaman Minat</td><td><select name='lintasminat' ><option value='Fisika' >Fisika</option><option value='Kimia' >Kimia</option><option value='Biologi' >Biologi</option><option value='Geografi' >Geografi</option><option value='Ekonomi' >Ekonomi</option><option value='Sosiologi' >Sosiologi</option></select></td></tr>";
  1101. $cetak .="<tr><td class=td2> Program Pilihan Ortu</td><td><select name='pilortu' ><option value='IPA' >IPA</option><option value='IPS' >IPS</option></select></td></tr>";
  1102. $cetak .="<tr><td colspan=2> <b>Nilai Raport SMP (Diisi dengan benar dan akan diperiksa kembali)</b> </td></tr>";
  1103. $cetak .="<tr><td class=td2> Matematika Semester 1</td><td><input type='text' name='mats1' maxlength='3' size='5' /></td></tr>";
  1104. $cetak .="<tr><td class=td2> Matematika Semester 2</td><td><input type='text' name='mats2' maxlength='3' size='5' /></td></tr>";
  1105. $cetak .="<tr><td class=td2> Matematika Semester 3</td><td><input type='text' name='mats3' maxlength='3' size='5' /></td></tr>";
  1106. $cetak .="<tr><td class=td2> Matematika Semester 4</td><td><input type='text' name='mats4' maxlength='3' size='5' /></td></tr>";
  1107. $cetak .="<tr><td class=td2> Matematika Semester 5</td><td><input type='text' name='mats5' maxlength='3' size='5' /></td></tr>";
  1108. $cetak .="<tr><td class=td2> Matematika Semester 6</td><td><input type='text' name='mats6' maxlength='3' size='5' /></td></tr>";
  1109. $cetak .="<tr><td colspan=2> ----------------------------------------------------------------------- </td></tr>";
  1110. $cetak .="<tr><td class=td2> IPA Semester 1</td><td><input type='text' name='ipas1' maxlength='3' size='5' /></td></tr>";
  1111. $cetak .="<tr><td class=td2> IPA Semester 2</td><td><input type='text' name='ipas2' maxlength='3' size='5' /></td></tr>";
  1112. $cetak .="<tr><td class=td2> IPA Semester 3</td><td><input type='text' name='ipas3' maxlength='3' size='5' /></td></tr>";
  1113. $cetak .="<tr><td class=td2> IPA Semester 4</td><td><input type='text' name='ipas4' maxlength='3' size='5' /></td></tr>";
  1114. $cetak .="<tr><td class=td2> IPA Semester 5</td><td><input type='text' name='ipas5' maxlength='3' size='5' /></td></tr>";
  1115. $cetak .="<tr><td class=td2> IPA Semester 6</td><td><input type='text' name='ipas6' maxlength='3' size='5' /></td></tr>";
  1116. $cetak .="<tr><td colspan=2> ----------------------------------------------------------------------- </td></tr>";
  1117. $cetak .="<tr><td class=td2> IPS Semester 1</td><td><input type='text' name='ipss1' maxlength='3' size='5' /></td></tr>";
  1118. $cetak .="<tr><td class=td2> IPS Semester 2</td><td><input type='text' name='ipss2' maxlength='3' size='5' /></td></tr>";
  1119. $cetak .="<tr><td class=td2> IPS Semester 3</td><td><input type='text' name='ipss3' maxlength='3' size='5' /></td></tr>";
  1120. $cetak .="<tr><td class=td2> IPS Semester 4</td><td><input type='text' name='ipss4' maxlength='3' size='5' /></td></tr>";
  1121. $cetak .="<tr><td class=td2> IPS Semester 5</td><td><input type='text' name='ipss5' maxlength='3' size='5' /></td></tr>";
  1122. $cetak .="<tr><td class=td2> IPS Semester 6</td><td><input type='text' name='ipss6' maxlength='3' size='5' /></td></tr>";
  1123. $cetak .="<tr><td colspan=2> ----------------------------------------------------------------------- </td></tr>";
  1124. $cetak .="<tr><td class=td2> Nilai UN IPA</td><td><input type='text' name='unipa' maxlength='5' size='5' /></td></tr>";
  1125. $cetak .="<tr><td colspan=2> Hasil Psikotes (Jika Ada) </td></tr>";
  1126. $cetak .="<tr><td class=td2> Taraf Kecerdasan</td><td><input type='text' name='kecerdasan' maxlength='10' size='10' /></td></tr>";
  1127. $cetak .="<tr><td class=td2> Hasil Tes Bakat dan Minat</td><td><select name='bakatminat' ><option value='IPA' >IPA</option><option value='IPS' >IPS</option><option value='Bahasa' >Bahasa</option></select></td></tr>";
  1128. $cetak .="</table><br>";
  1129.  
  1130.  
  1131. $cetak .="<table border=0 id=tablebaru width=800 > ";
  1132. $cetak .="<tr><td colspan=2 class='td1' height='30' > <b> :: Keterangan Lainnya</b></td></tr>";
  1133. $cetak .="<tr><td class=td2 width=200 > Alamat Surat</td><td><input type='text' name='almtsurat' maxlength='100' size='50' /></td></tr>";
  1134. $cetak .="<tr><td class=td2> Keterangan</td><td><input type='text' name='ket' maxlength='100' size='50' /></td></tr>";
  1135. $cetak .="<tr><td></td><td><input type='submit' name='submit' value='Simpan' id='button' /> <a href='?id=".$idmenu."' id='button2' >Kembali</a></td></tr>";
  1136. $cetak .="</table></form>";
  1137. $m=date("m"); $d=date("d"); $y=date("Y");
  1138. $cetak .='<script language="javascript"><!--
  1139. var currYear = '.$y.';
  1140. var currMonth = '.$m.';
  1141. var dptgl = new DatePicker();
  1142. dptgl.id = "tgl";
  1143. dptgl.month = '.$m.';
  1144. dptgl.year = '.$y.';
  1145. dptgl.canvas = "dtDivtgl";
  1146. dptgl.format = "dd-mm-yyyy";
  1147. dptgl.anchor = "anctgl";
  1148. dptgl.initialize();
  1149. </script>';
  1150. return $cetak;
  1151. }
  1152.  
  1153. function savedata(){
  1154. //include "includes/koneksi.php";
  1155. $kode = CekVar('kode','numeric');
  1156. $kode = CekVar('kode','');
  1157. $nisn = CekVar('nisn','');
  1158. $nodata = CekVar('nodata','');
  1159. $kelompok = CekVar('kelompok','');
  1160. $nama = CekVar('nama','');
  1161. $panggil =CekVar('panggil','');
  1162. $kelamin = CekVar('kelamin','');
  1163. $tmplahir = CekVar('tmplahir','');
  1164. $tgllahir =CekVar('tgllahir','');
  1165. $tgllahir = substr($tgllahir,3,2)."/".substr($tgllahir,0,2)."/".substr($tgllahir,6,4);
  1166. $agama =CekVar('agama','');
  1167. $warganegara =CekVar('warganegara','');
  1168. $anakke = CekVar('anakke','');
  1169. $jmlsaudara = CekVar('jmlsaudara','');
  1170. $jmlsaudaratiri = CekVar('jmlsaudaratiri','');
  1171. $bahasa = CekVar('bahasa','');
  1172. $hobi = CekVar('hobi','');
  1173. $bakat = CekVar('bakat','');
  1174.  
  1175. $alamat = CekVar('alamat','');
  1176. $strumah = CekVar('strumah','');
  1177. $tinggal = CekVar('tinggal','');
  1178. $jarak = CekVar('jarak','');
  1179. $kendaraan = CekVar('kendaraan','');
  1180. $telepon = CekVar('telepon','');
  1181. $hp = CekVar('hp','');
  1182. $email = CekVar('email','');
  1183. $yatim = CekVar('yatim','');
  1184.  
  1185. $berat = CekVar('berat','');
  1186. $tinggi = CekVar('tinggi','');
  1187. $goldarah = CekVar('goldarah','');
  1188. $penyakit = CekVar('penyakit','');
  1189.  
  1190. $namaayah = CekVar('namaayah','');
  1191. $pendiayah = CekVar('pendiayah','');
  1192. $pekerayah = CekVar('pekerayah','');
  1193. $hasilayah = CekVar('hasilayah','');
  1194. $almtayah = CekVar('almtayah','');
  1195. $telpayah = CekVar('telpayah','');
  1196. $hpayah = CekVar('hpayah','');
  1197. $emailayah = CekVar('emailayah','');
  1198.  
  1199. $namaibu = CekVar('namaibu','');
  1200. $pendiibu = CekVar('pendiibu','');
  1201. $pekeribu = CekVar('pekeribu','');
  1202. $hasilibu = CekVar('hasilibu','');
  1203. $almtibu = CekVar('almtibu','');
  1204. $telpibu = CekVar('telpibu','');
  1205. $hpibu = CekVar('hpibu','');
  1206. $emailibu = CekVar('emailibu','');
  1207.  
  1208. $namawali = CekVar('namawali','');
  1209. $pendiwali = CekVar('pendiwali','');
  1210. $pekerwali = CekVar('pekerwali','');
  1211. $hasilwali = CekVar('hasilwali','');
  1212. $almtwali = CekVar('almtwali','');
  1213. $telpwali = CekVar('telpwali','');
  1214. $hpwali = CekVar('hpwali','');
  1215. $emailwali = CekVar('emailwali','');
  1216.  
  1217. $pilanak = CekVar('pilanak','');
  1218. $lintasminat = CekVar('lintasminat','');
  1219. $pilortu = CekVar('pilortu','');
  1220. $mats1 = CekVar('mats1','');
  1221. $mats2 = CekVar('mats2','');
  1222. $mats3 = CekVar('mats3','');
  1223. $mats4 = CekVar('mats4','');
  1224. $mats5 = CekVar('mats5','');
  1225. $mats6 = CekVar('mats6','');
  1226. $ipas1 = CekVar('ipas1','');
  1227. $ipas2 = CekVar('ipas2','');
  1228. $ipas3 = CekVar('ipas3','');
  1229. $ipas4 = CekVar('ipas4','');
  1230. $ipas5 = CekVar('ipas5','');
  1231. $ipas6 = CekVar('ipas6','');
  1232. $ipss1 = CekVar('ipss1','');
  1233. $ipss2 = CekVar('ipss2','');
  1234. $ipss3 = CekVar('ipss3','');
  1235. $ipss4 = CekVar('ipss4','');
  1236. $ipss5 = CekVar('ipss5','');
  1237. $ipss6 = CekVar('ipss6','');
  1238. $unipa = CekVar('unipa','');
  1239. $kecerdasan = CekVar('kecerdasan','');
  1240. $bakatminat = CekVar('bakatminat','');
  1241.  
  1242.  
  1243. $asalsekolah = CekVar('asalsekolah','');
  1244. $ijazah = CekVar('ijazah','');
  1245. $skhun = CekVar('skhun','');
  1246. $jmlskhun = CekVar('jmlskhun','');
  1247. $almtsurat = CekVar('almtsurat','');
  1248. $ket = CekVar('ket','');
  1249.  
  1250. if ($kode=='') { // tambah data //tambah juga ke t_kls_nis
  1251. $host = localhost; // isi sesuai settingan sql kamu
  1252. $username =root;
  1253. $password = test123;
  1254. $db = daftar_ulang;
  1255. $con = mysqli_connect($host, $username, $password, $db);
  1256. $num = mysqli_query($con, "insert into t_siswa (id,namalengkap,namapanggilan,kelamin,
  1257. tmplahir,tgllahir,agama,warganegara,anakke,saudarakandung,saudaratiri,anakyatim,bahasa,hobi,bakat,
  1258. alamat,statusrumah,tinggal,jaraksekolah,telp,hp,email,kendaraan,alamatsurat,ket,nodata,kelompok) values
  1259. ('$nisn','$nama','$panggil','$kelamin','$tmplahir','$tgllahir','$agama','$warganegara','$anakke',
  1260. '$jmlsaudara','$jmlsaudaratiri','$yatim','$bahasa','$hobi','$bakat','$alamat','$strumah','$tinggal',
  1261. '$jarak','$telepon','$hp','$email','$kendaraan','$almtsurat','$ket','$nodata','$kelompok')"); //ERROR
  1262.  
  1263. //,,,,'','','$hobi','$bakat','$email','','',,$ket
  1264. $host = localhost; // isi sesuai settingan sql kamu
  1265. $username =root;
  1266. $password = test123;
  1267. $db = daftar_ulang;
  1268. $con = mysqli_connect($host, $username, $password, $db);
  1269. $num = mysqli_query($con, "insert into t_siswakesehatan values ('$nisn','$berat','$tinggi','$goldarah','$penyakit')"); //ERROR
  1270.  
  1271. $host = localhost; // isi sesuai settingan sql kamu
  1272. $username = root;
  1273. $password = test123;
  1274. $db = daftar_ulang;
  1275. $con = mysqli_connect($host, $username, $password, $db);
  1276. $num = mysqli_query($con, "insert into t_minat
  1277. (id,PILANAK,LINTASMINAT,PILORTU,MATS1,MATS2,MATS3,
  1278. MATS4,MATS5,MATS6,IPAS1,IPAS2,IPAS3,IPAS4,IPAS5,
  1279. IPAS6,IPSS1,IPSS2,IPSS3,IPSS4,IPSS5,IPSS6,UNIPA,
  1280. KECERDASAN,BAKATMINAT) values
  1281. ('$nisn','$pilanak','$lintasminat','$pilortu','$mats1','$mats2',
  1282. '$mats3','$mats4','$mats5','$mats6','$ipas1','$ipas2',
  1283. '$ipas3','$ipas4','$ipas5','$ipas6','$ipss1','$ipss2',
  1284. '$ipss3','$ipss4','$ipss5','$ipss6','$unipa','$kecerdasan','$bakatminat')"); //ERROR
  1285.  
  1286. $host = localhost; // isi sesuai settingan sql kamu
  1287. $username =root;
  1288. $password = test123;
  1289. $db = daftar_ulang;
  1290. $con = mysqli_connect($host, $username, $password, $db);
  1291. $num = mysqli_query($con, "insert into t_siswawali
  1292. (id,NM_AYAH,PEND_AYAH,PKJ_AYAH,HASIL_AYAH,ALMT_AYAH,TELP_AYAH,
  1293. HP_AYAH,EMAIL_AYAH,NM_IBU,PEND_IBU,PKJ_IBU,HASIL_IBU,ALMT_IBU,TELP_IBU,
  1294. HP_IBU,EMAIL_IBU,NM_WALI,PEND_WALI,PKJ_WALI,HASIL_WALI,ALMT_WALI,TELP_WALI,
  1295. HP_WALI,EMAIL_WALI) values
  1296. ('$nisn','$namaayah','$pendiayah','$pekerayah','$hasilayah','$almtayah',
  1297. '$telpayah','$hpayah','$emailayah','$namaibu','$pendiibu','$pekeribu',
  1298. '$hasilibu','$almtibu','$telpibu','$hpibu','$emailibu','$namawali',
  1299. '$pendiwali','$pekerwali','$hasilwali','$almtwali','$telpwali','$hpwali','$emailwali')"); //ERROR
  1300.  
  1301. $host = localhost; // isi sesuai settingan sql kamu
  1302. $username =root;
  1303. $password = test123;
  1304. $db = daftar_ulang;
  1305. $con = mysqli_connect($host, $username, $password, $db);
  1306. $num = mysqli_query($con, "insert into t_siswapendidikan values
  1307. ('$nisn','$asalsekolah','','$ijazah','$skhun','$jmlskhun','')"); //ERROR
  1308. // $num = $user->dbQuery("insert into t_nis_kls (nis,kelas) values('$nis','baru')");
  1309.  
  1310. }
  1311. else { // edit data
  1312. $num=mysqli_query("delete from t_siswakesehatan where id='".$kode."'");
  1313. $num=mysqli_query("delete from t_siswa where id='".$kode."'");
  1314. $num=mysqli_query("delete from t_siswawali where id='".$kode."'");
  1315. $num=mysqli_query("delete from t_siswapendidikan where id='".$kode."'");
  1316. $num=mysqli_query("delete from t_minat where id='".$kode."'");
  1317.  
  1318. $num = mysqli_query("insert into t_siswa (id,namalengkap,namapanggilan,kelamin,
  1319. tmplahir,tgllahir,agama,warganegara,anakke,saudarakandung,saudaratiri,anakyatim,bahasa,hobi,bakat,
  1320. alamat,statusrumah,tinggal,jaraksekolah,telp,hp,email,kendaraan,alamatsurat,ket) values
  1321. ('$nisn','$nama','$panggil','$kelamin','$tmplahir','$tgllahir','$agama','$warganegara','$anakke',
  1322. '$jmlsaudara','$jmlsaudaratiri','$yatim','$bahasa','$hobi','$bakat','$alamat','$strumah','$tinggal',
  1323. '$jarak','$telepon','$hp','$email','$kendaraan','$almtsurat','$ket')");
  1324.  
  1325. $num = mysqli_query("insert into t_siswakesehatan values ('$nisn','$berat','$tinggi','$goldarah','$penyakit')");
  1326.  
  1327. $num = mysqli_query("insert into t_siswawali
  1328. (id,NM_AYAH,PEND_AYAH,PKJ_AYAH,HASIL_AYAH,ALMT_AYAH,TELP_AYAH,
  1329. HP_AYAH,EMAIL_AYAH,NM_IBU,PEND_IBU,PKJ_IBU,HASIL_IBU,ALMT_IBU,TELP_IBU,
  1330. HP_IBU,EMAIL_IBU,NM_WALI,PEND_WALI,PKJ_WALI,HASIL_WALI,ALMT_WALI,TELP_WALI,
  1331. HP_WALI,EMAIL_WALI) values
  1332. ('$nisn','$namaayah','$pendiayah','$pekerayah','$hasilayah','$almtayah',
  1333. '$telpayah','$hpayah','$emailayah','$namaibu','$pendiibu','$pekeribu',
  1334. '$hasilibu','$almtibu','$telpibu','$hpibu','$emailibu','$namawali',
  1335. '$pendiwali','$pekerwali','$hasilwali','$almtwali','$telpwali','$hpwali','$emailwali')");
  1336.  
  1337. $num = mysqli_query("insert into t_minat
  1338. (id,PILANAK,LINTASMINAT,PILORTU,MATS1,MATS2,MATS3,
  1339. MATS4,MATS5,MATS6,IPAS1,IPAS2,IPAS3,IPAS4,IPAS5,
  1340. IPAS6,IPSS1,IPSS2,IPSS3,IPSS4,IPSS5,IPSS6,UNIPA,
  1341. KECERDASAN,BAKATMINAT) values
  1342. ('$nisn','$pilanak','$lintasminat','$pilortu','$mats1','$mats2',
  1343. '$mats3','$mats4','$mats5','$mats6','$ipas1','$ipas2',
  1344. '$ipas3','$ipas4','$ipas5','$ipas6','$ipss1','$ipss2',
  1345. '$ipss3','$ipss4','$ipss5','$ipss6','$unipa','$kecerdasan','$bakatminat')");
  1346.  
  1347. $num = mysqli_query("insert into t_siswapendidikan values
  1348. ('$nisn','$asalsekolah','','$ijazah','$skhun','$jmlskhun','')");
  1349.  
  1350. }
  1351. if($num >=1) $cetak .= "Data telah tersimpan <br><br> Klik <a href='?id=lihat' id='button2' >disini</a> untuk kembali ke daftar data";
  1352. else $cetak .="Data gagal tersimpan <br><br> Klik <a href='?id=add' id='button2' >disini</a> untuk kembali ke daftar data";
  1353.  
  1354. return $cetak;
  1355. }
  1356. function hapusdata(){
  1357. $cetak .="<h3>Penghapusan Siswa</h3>";
  1358. $kode = CekVar('kode','numeric');
  1359. $num=mysqli_query("delete from t_siswakesehatan where id='".$kode."'");
  1360. $num=mysqli_query("delete from t_minat where id='".$kode."'");
  1361. $num=mysqli_query("delete from t_siswa where id='".$kode."'");
  1362. $num=mysqli_query("delete from t_siswawali where id='".$kode."'");
  1363. $num=mysqli_query("delete from t_siswapendidikan where id='".$kode."'");
  1364.  
  1365. if($num >=1) $cetak .= "Data telah berhasil dihapus <br><br> Klik <a href='?id=lihat' id='button2' >disini</a> untuk kembali ke daftar data";
  1366. else $cetak .="Data gagal dihapus <br><br> Klik <a href='?id=lihat' id='button2' >disini</a> untuk kembali ke daftar data";
  1367.  
  1368. return $cetak;
  1369. }
  1370. function detaildata(){
  1371. global $idmenu,$user;
  1372.  
  1373. $kode = $user->CekVar('kode','numeric');
  1374. $cetak .="<h3>Detail Data Siswa</h3>";
  1375. $sql=$user->dbQuery("select * from T_SISWA_DATA where NIS='".$kode."'");
  1376. if($row=$user->dbAssoc($sql)) {
  1377.  
  1378. }
  1379. else $cetak .="Data yang akan lihat tidak ada ";
  1380. $cetak .="<br><br><a href='?id=".$idmenu."' id='button2' >Kembali</a>";
  1381. return $cetak;
  1382. }
  1383.  
  1384.  
  1385. ?>
Add Comment
Please, Sign In to add comment
Public Pastes
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!