API tools faq
paste
Advertisement
Guest User

Untitled

a guest
May 24th, 2019
111
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 31.59 KB | None | 0 0
raw download clone embed print report
  1.  
  2. <?php
  3.  
  4. header("Content-Type: application/vnd.ms-excel; charset=utf-8");
  5. header("Content-Disposition: attachment; filename=form1_bosnas.xls"); //File name extension was wrong
  6. header("Expires: 0");
  7. header("Cache-Control: must-revalidate, post-check=0, pre-check=0");
  8. header("Cache-Control: private",false);
  9.  
  10.  
  11. date_default_timezone_set("Asia/Jakarta");
  12.  
  13. ?>
  14.  
  15.  
  16. <!DOCTYPE html>
  17. <html lang="en">
  18. <head>
  19. <title>Laporan Form 1</title>
  20. <meta charset="utf-8">
  21. <meta name="viewport" content="width=device-width, initial-scale=1">
  22. <!-- <link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/css/bootstrap.min.css"> -->
  23. <!-- <script src="https://ajax.googleapis.com/ajax/libs/jquery/3.2.1/jquery.min.js"></script>
  24. <script src="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/js/bootstrap.min.js"></script> -->
  25. <!-- <script src="https://code.jquery.com/jquery-1.12.4.js"></script> -->
  26. <script src="https://unpkg.com/jspdf@latest/dist/jspdf.min.js"></script>
  27. <script src="https://cdnjs.cloudflare.com/ajax/libs/jspdf/1.3.5/jspdf.debug.js"></script>
  28. <style type="text/css">
  29. body{
  30. font-size: 10px;
  31. }
  32. th {
  33. text-align: center;
  34. padding: 0 10px;
  35. }
  36.  
  37. @page{
  38. size: 330mm 216mm;
  39. }
  40. .box {
  41. position: relative;
  42. float: right;
  43. bottom: 100px;
  44. top: -50px;
  45. }
  46. </style>
  47. </head>
  48. <body>
  49. <div class="container">
  50. <div class="row">
  51. <div class="row">
  52. <table>
  53. <tr>
  54. <th colspan="13">PENDAPATAN TRANSFER, RINCIAN BELANJA DAN POSISI KAS PERIODE <?php echo date('Y');?></th>
  55. </tr>
  56. <tr>
  57. <th colspan="13">SUMBER DANA BOS REGULER</th>
  58. </tr>
  59. </table>
  60. </div>
  61. <div class="row">
  62. <div class="col-lg-12 col-md-4 col-sm-4">
  63. <table style="font-weight: bold; font-size: 12px; margin-top: 50px;" width="30%">
  64. <tr>
  65. <td colspan="12">NPSN</td>
  66. <td rowspan="2" border="1">
  67. <div style="width: 80px; height: 50px; border: solid 2px; text-align: center; font-size: 20px; font-weight: bold;">
  68. Form 1
  69. </div>
  70. </td>
  71. </tr>
  72. <tr>
  73. <td colspan="12">Nama Sekolah</td>
  74. </tr>
  75. </table>
  76. </div>
  77. </div>
  78. <div class="row" style="position: relative; top: 10%;">
  79. <div class="col-lg-12 col-md-12 col-sm-12">
  80. <table border="1" style="border-collapse: collapse;" width="100%">
  81. <thead>
  82. <tr>
  83. <th width="1%" rowspan="3">No</th>
  84. <th width="10%" rowspan="3">Nama Sekolah</th>
  85. <th width="10%" rowspan="3">Silpa 2018</th>
  86. <th width="15%" colspan="3">Triwulan <?php echo $this->uri->segment(4); ?></th>
  87. <th width="15%" colspan="3">Belanja Pegawai</th>
  88. <th colspan="9">Belanja Persediaan</th>
  89. <th colspan="9">Belanja Persediaan</th>
  90. <th colspan="10">Belanja Barang dan Jasa Lainnya</th>
  91. <th colspan="8">Belanja Barang dan Jasa Lainnya</th>
  92. <th colspan="8">Belanja Barang dan Jasa Lainnya</th>
  93. <th rowspan="3">JUMLAH BELANJA BARANG DAN JASA = JUMLAH BELANJA PERSEDIAAN +JUMLAH BELANJA BARANG DAN JASA LAINNYA</th>
  94. <th colspan="8">Belanja Modal</th>
  95. <th colspan="6">Belanja Modal</th>
  96. <th width="10%" rowspan="3">Jumlah Belanja Modal</th>
  97. <th width="10%" rowspan="3">Jumlah Belanja</th>
  98. <th width="10%" rowspan="3">Pelimpahan Jasa Giro</th>
  99. <th width="10%" rowspan="3">Pajak Terutang</th>
  100. <th width="10%" rowspan="3">SALDO BUKU</th>
  101. </tr>
  102. <tr>
  103. <th rowspan="2">Transferan</th>
  104. <th rowspan="2">Jasa Giro</th>
  105. <th rowspan="2">Jumlah Penerimaan</th>
  106. <th rowspan="2">Honorarium Teknisi, Pengawas, Proktor UNBK</th>
  107. <th rowspan="2">(Honorarium Guru,Pegawai Honorer/Tidak Tetap (15%)</th>
  108. <th rowspan="2">Jumlah Belanja Pegawai</th>
  109. <th rowspan="2">Bahan Kimia</th>
  110. <th rowspan="2">Bahan Bakar dan Pelumas</th>
  111. <th rowspan="2">Isi Tabung Pemadam Kebakaran</th>
  112. <th rowspan="2">Isi Tabung Gas</th>
  113. <th rowspan="2">Bahan Lainnya/Bahan Batik</th>
  114. <th rowspan="2">Alat Tulis Kantor</th>
  115. <th rowspan="2">Kertas dan Cover</th>
  116. <th rowspan="2">Bahan Cetak</th>
  117. <th rowspan="2">Benda Pos</th>
  118. <th rowspan="2">Bahan Komputer</th>
  119. <th rowspan="2">Perabot Kantor</th>
  120. <th rowspan="2">Alat Listrik</th>
  121. <th rowspan="2">Perlengkapan Dinas</th>
  122. <th rowspan="2">Perlengkapan Pendukung Olahraga</th>
  123. <th rowspan="2">Suvenir/Cendera Mata</th>
  124. <th rowspan="2">Alat/Bahan untuk Kegiatan Kantor Lainnya</th>
  125. <th rowspan="2">Obat-Obatan</th>
  126. <th rowspan="2">JUMLAH BELANJA PERSEDIAAN</th>
  127. <th rowspan="2">Belanja Telepon</th>
  128. <th rowspan="2">Belanja Air</th>
  129. <th rowspan="2">Belanja Listrik</th>
  130. <th rowspan="2">Belanja Cetak</th>
  131. <th rowspan="2">Belanja surat kabar/majalah</th>
  132. <th rowspan="2">Belanja kawat/faksimili/internet</th>
  133. <th rowspan="2">Belanja Retribusi Sampah</th>
  134. <th rowspan="2">Belanja Penggandaan/fotocopy</th>
  135. <th rowspan="2">Belanja Sewa Mobilitas Darat</th>
  136. <th rowspan="2">Belanja sewa komputer dan printer (termasuk Bandwidth)</th>
  137. <th rowspan="2">Sewa Pakaian</th>
  138. <th rowspan="2">Sewa Gedung/Kantor/Lapangan</th>
  139. <th rowspan="2">Belanja Sewa Perlengkapan dan Peralatan Kantor (Meja Kursi, Tenda dan Panggung, Sound System, Alat Kesenian, Alat Peraga)</th>
  140. <th rowspan="2">Belanja makanan dan minuman rapat (Kegiatan)</th>
  141. <th rowspan="2">Belanja Perjalanan Dinas, Transport</th>
  142. <th rowspan="2">Belanja Pemeliharan Peralatan dan Mesin (Peralatan mesin,Mebelair, AC)</th>
  143. <th rowspan="2">Belanja Pemeliharan Gedung dan Bangunan (Gedung,WC, Taman,bel, teralis jendela)</th>
  144. <th rowspan="2">Belanja Pemeliharan Jalan, Irigasi, dan Jaringan</th>
  145. <th rowspan="2">Belanja Pemeliharan Aset Tetap Lainnya (Buku,Terbitan, Barang Perpustakaan)</th>
  146. <th rowspan="2">Belanja Pemeliharaan Komputer</th>
  147. <th rowspan="2">Belanja Pemeliharan Aset Lainnya (Software)</th>
  148. <th rowspan="2">Belanja Honorarium Tenaga Ahli/ Narasumber/ Instruktur/Jasa Input Data/Outsourcing</th>
  149. <th rowspan="2">Kontribusi, Akomodasi, Biaya Pendaftaran</th>
  150. <th rowspan="2">Barang yang diserahkan kepada siswa</th>
  151. <th rowspan="2">Biaya Rekening Bank (untuk biaya transaksi non tunai)</th>
  152. <th rowspan="2">Jumlah Belanja Barang dan Jasa Lainnya</th>
  153. <th>Pengadaan Alat Kesehatan Perawatan</th>
  154. <th colspan="2">Pengadaan Alat Rumah Tangga</th>
  155. <th colspan="4">Pengadaan Alat Rumah Tangga (Home Use)</th>
  156. <th>Pengadaan Komputer</th>
  157. <th colspan="3">Pengadaan Peralatan Personal Komputer</th>
  158. <th rowspan="2">Pengadaan Alat Peraga Pendidikan</th>
  159. <th rowspan="2">Pengadaan Buku</th>
  160. <th rowspan="2">Pembangunan Jamban/WC</th>
  161. </tr>
  162. <tr>
  163. <th>Tandu, Stetoskop, Tabung Oksigen, Snellen Cahart Manual</th>
  164. <th>Mebelair</th>
  165. <th>Alat Pendingin(AC Perpustakaan)</th>
  166. <th>Finger Print</th>
  167. <th>CCTV</th>
  168. <th>Tabung Pemadam Kebakaran</th>
  169. <th>Pompa Air dan Instalasinya</th>
  170. <th>Komputer, Laptop</th>
  171. <th>Printer Plus Scanner</th>
  172. <th>LCD/Screen Proyektor</th>
  173. <th>Proyektor, CPU, Hardisk Eksternal</th>
  174. </tr>
  175. <tr style="background-color: yellow;">
  176. <th>1</th>
  177. <th>2</th>
  178. <th>3</th>
  179. <th>4</th>
  180. <th>5</th>
  181. <th>6 = (3+4+5)</th>
  182. <th>7</th>
  183. <th>8</th>
  184. <th>9 = (7+8)</th>
  185. <th>10</th>
  186. <th>11</th>
  187. <th>12</th>
  188. <th>13</th>
  189. <th>14</th>
  190. <th>15</th>
  191. <th>16</th>
  192. <th>17</th>
  193. <th>18</th>
  194. <th>19</th>
  195. <th>20</th>
  196. <th>21</th>
  197. <th>22</th>
  198. <th>23</th>
  199. <th>24</th>
  200. <th>25</th>
  201. <th>26</th>
  202. <th>27 = (10 + s/d 26)</th>
  203. <th>28</th>
  204. <th>29</th>
  205. <th>30</th>
  206. <th>31</th>
  207. <th>32</th>
  208. <th>33</th>
  209. <th>34</th>
  210. <th>35</th>
  211. <th>36</th>
  212. <th>37</th>
  213. <th>38</th>
  214. <th>39</th>
  215. <th>40</th>
  216. <th>41</th>
  217. <th>42</th>
  218. <th>43</th>
  219. <th>44</th>
  220. <th>45</th>
  221. <th>46</th>
  222. <th>47</th>
  223. <th>48</th>
  224. <th>49</th>
  225. <th>50</th>
  226. <th>51</th>
  227. <th>52</th>
  228. <th>53 = (28 + s/d 52)</th>
  229. <th>54 = (27+53)</th>
  230. <th>55</th>
  231. <th>56</th>
  232. <th>57</th>
  233. <th>58</th>
  234. <th>59</th>
  235. <th>60</th>
  236. <th>61</th>
  237. <th>62</th>
  238. <th>63</th>
  239. <th>64</th>
  240. <th>65</th>
  241. <th>66</th>
  242. <th>67</th>
  243. <th>68</th>
  244. <th>69 = (55+ s/d 68)</th>
  245. <th>70 = (9+54+69)</th>
  246. <th>71</th>
  247. <th>72</th>
  248. <th>73 = (6-70-71+72)</th>
  249. </tr>
  250. <tr>
  251. <th height="3%"></th>
  252. <th height="3%"></th>
  253. <th height="3%"></th>
  254. <th height="3%"></th>
  255. <th height="3%"></th>
  256. <th height="3%"></th>
  257. <th height="3%"></th>
  258. <th height="3%"></th>
  259. <th height="3%"></th>
  260. <th height="3%"></th>
  261. <th height="3%"></th>
  262. <th height="3%"></th>
  263. <th height="3%"></th>
  264. <th height="3%"></th>
  265. <th height="3%"></th>
  266. <th height="3%"></th>
  267. <th height="3%"></th>
  268. <th height="3%"></th>
  269. <th height="3%"></th>
  270. <th height="3%"></th>
  271. <th height="3%"></th>
  272. <th height="3%"></th>
  273. <th height="3%"></th>
  274. <th height="3%"></th>
  275. <th height="3%"></th>
  276. <th height="3%"></th>
  277. <th height="3%"></th>
  278. <th height="3%"></th>
  279. <th height="3%"></th>
  280. <th height="3%"></th>
  281. <th height="3%"></th>
  282. <th height="3%"></th>
  283. <th height="3%"></th>
  284. <th height="3%"></th>
  285. <th height="3%"></th>
  286. <th height="3%"></th>
  287. <th height="3%"></th>
  288. <th height="3%"></th>
  289. <th height="3%"></th>
  290. <th height="3%"></th>
  291. <th height="3%"></th>
  292. <th height="3%"></th>
  293. <th height="3%"></th>
  294. <th height="3%"></th>
  295. <th height="3%"></th>
  296. <th height="3%"></th>
  297. <th height="3%"></th>
  298. <th height="3%"></th>
  299. <th height="3%"></th>
  300. <th height="3%"></th>
  301. <th height="3%"></th>
  302. <th height="3%"></th>
  303. <th height="3%"></th>
  304. <th height="3%"></th>
  305. <th height="3%"></th>
  306. <th height="3%"></th>
  307. <th height="3%"></th>
  308. <th height="3%"></th>
  309. <th height="3%"></th>
  310. <th height="3%"></th>
  311. <th height="3%"></th>
  312. <th height="3%"></th>
  313. <th height="3%"></th>
  314. <th height="3%"></th>
  315. <th height="3%"></th>
  316. <th height="3%"></th>
  317. <th height="3%"></th>
  318. <th height="3%"></th>
  319. <th height="3%"></th>
  320. <th height="3%"></th>
  321. <th height="3%"></th>
  322. <th height="3%"></th>
  323. <th height="3%"></th>
  324. </tr>
  325. </thead>
  326. <tbody>
  327. <?php
  328. $jml_array = count($res);
  329. error_reporting(0);
  330. // for ($row = 1; $row < $jml_array; $row++) {
  331. // echo '<tr>';
  332. // for ($col = 1; $col <= 9; $col++) {
  333. // echo '<td style="text-align: center;">'.add_tiko($res[$row][$col]).'</td>';
  334.  
  335. // }
  336. // echo '</tr>';
  337. // }
  338.  
  339. for ($row = 1; $row < $jml_array; $row++) {
  340. echo '<tr>';
  341. //
  342. for ($col = 1; $col <= 2; $col++) {
  343. echo '<td style="text-align: center;">'.$res[$row][$col].'</td>';
  344. }
  345. //
  346. for ($col = 3; $col <= 73; $col++) {
  347. echo '<td style="text-align: center;">'.add_tiko($res[$row][$col]).'</td>';
  348. }
  349. echo '</tr>';
  350. }
  351. ?>
  352.  
  353. <tr>
  354. <th height="3%"></th>
  355. <th height="3%"></th>
  356. <th height="3%"></th>
  357. <th height="3%"></th>
  358. <th height="3%"></th>
  359. <th height="3%"></th>
  360. <th height="3%"></th>
  361. <th height="3%"></th>
  362. <th height="3%"></th>
  363. <th height="3%"></th>
  364. <th height="3%"></th>
  365. <th height="3%"></th>
  366. <th height="3%"></th>
  367. <th height="3%"></th>
  368. <th height="3%"></th>
  369. <th height="3%"></th>
  370. <th height="3%"></th>
  371. <th height="3%"></th>
  372. <th height="3%"></th>
  373. <th height="3%"></th>
  374. <th height="3%"></th>
  375. <th height="3%"></th>
  376. <th height="3%"></th>
  377. <th height="3%"></th>
  378. <th height="3%"></th>
  379. <th height="3%"></th>
  380. <th height="3%"></th>
  381. <th height="3%"></th>
  382. <th height="3%"></th>
  383. <th height="3%"></th>
  384. <th height="3%"></th>
  385. <th height="3%"></th>
  386. <th height="3%"></th>
  387. <th height="3%"></th>
  388. <th height="3%"></th>
  389. <th height="3%"></th>
  390. <th height="3%"></th>
  391. <th height="3%"></th>
  392. <th height="3%"></th>
  393. <th height="3%"></th>
  394. <th height="3%"></th>
  395. <th height="3%"></th>
  396. <th height="3%"></th>
  397. <th height="3%"></th>
  398. <th height="3%"></th>
  399. <th height="3%"></th>
  400. <th height="3%"></th>
  401. <th height="3%"></th>
  402. <th height="3%"></th>
  403. <th height="3%"></th>
  404. <th height="3%"></th>
  405. <th height="3%"></th>
  406. <th height="3%"></th>
  407. <th height="3%"></th>
  408. <th height="3%"></th>
  409. <th height="3%"></th>
  410. <th height="3%"></th>
  411. <th height="3%"></th>
  412. <th height="3%"></th>
  413. <th height="3%"></th>
  414. <th height="3%"></th>
  415. <th height="3%"></th>
  416. <th height="3%"></th>
  417. <th height="3%"></th>
  418. <th height="3%"></th>
  419. <th height="3%"></th>
  420. <th height="3%"></th>
  421. <th height="3%"></th>
  422. <th height="3%"></th>
  423. <th height="3%"></th>
  424. <th height="3%"></th>
  425. <th height="3%"></th>
  426. <th height="3%"></th>
  427. </tr>
  428. <tr>
  429. <td style="text-align: center;" colspan="2">Jumlah</td>
  430. <td style="text-align: right; padding-right: 5px;"></td>
  431. <td style="text-align: right; padding-right: 5px;"></td>
  432. <td style="text-align: right; padding-right: 5px;"></td>
  433. <td style="text-align: right; padding-right: 5px;"></td>
  434. <td style="text-align: right; padding-right: 5px;"></td>
  435. <td style="text-align: right; padding-right: 5px;"></td>
  436. <td style="text-align: right; padding-right: 5px;"></td>
  437. <th style="text-align: right; padding-right: 5px;"></th>
  438. <th style="text-align: right; padding-right: 5px;"></th>
  439. <th style="text-align: right; padding-right: 5px;"></th>
  440. <th style="text-align: right; padding-right: 5px;"></th>
  441. <th style="text-align: right; padding-right: 5px;"></th>
  442. <th style="text-align: right; padding-right: 5px;"></th>
  443. <th style="text-align: right; padding-right: 5px;"></th>
  444. <th style="text-align: right; padding-right: 5px;"></th>
  445. <th style="text-align: right; padding-right: 5px;"></th>
  446. <th style="text-align: right; padding-right: 5px;"></th>
  447. <th style="text-align: right; padding-right: 5px;"></th>
  448. <th style="text-align: right; padding-right: 5px;"></th>
  449. <th style="text-align: right; padding-right: 5px;"></th>
  450. <th style="text-align: right; padding-right: 5px;"></th>
  451. <th style="text-align: right; padding-right: 5px;"></th>
  452. <th style="text-align: right; padding-right: 5px;"></th>
  453. <th style="text-align: right; padding-right: 5px;"></th>
  454. <th style="text-align: right; padding-right: 5px;"></th>
  455. <th style="text-align: right; padding-right: 5px;" ></th>
  456. <th style="text-align: right; padding-right: 5px;" ></th>
  457. <th style="text-align: right; padding-right: 5px;" ></th>
  458. <th style="text-align: right; padding-right: 5px;" ></th>
  459. <th style="text-align: right; padding-right: 5px;" ></th>
  460. <th style="text-align: right; padding-right: 5px;" ></th>
  461. <th style="text-align: right; padding-right: 5px;" ></th>
  462. <th style="text-align: right; padding-right: 5px;" ></th>
  463. <th style="text-align: right; padding-right: 5px;" ></th>
  464. <th style="text-align: right; padding-right: 5px;" ></th>
  465. <th style="text-align: right; padding-right: 5px;"></th>
  466. <th style="text-align: right; padding-right: 5px;"></th>
  467. <th style="text-align: right; padding-right: 5px;"></th>
  468. <th style="text-align: right; padding-right: 5px;"></th>
  469. <th style="text-align: right; padding-right: 5px;"></th>
  470. <th style="text-align: right; padding-right: 5px;"></th>
  471. <th style="text-align: right; padding-right: 5px;"></th>
  472. <th style="text-align: right; padding-right: 5px;"></th>
  473. <th style="text-align: right; padding-right: 5px;"></th>
  474. <th style="text-align: right; padding-right: 5px;"></th>
  475. <th style="text-align: right; padding-right: 5px;"></th>
  476. <th style="text-align: right; padding-right: 5px;"></th>
  477. <th style="text-align: right; padding-right: 5px;"></th>
  478. <th style="text-align: right; padding-right: 5px;"></th>
  479. <th style="text-align: right; padding-right: 5px;"></th>
  480. <th style="text-align: right; padding-right: 5px;"></th>
  481. <th style="text-align: right; padding-right: 5px;"></th>
  482. <th style="text-align: right; padding-right: 5px;"></th>
  483. <th style="text-align: right; padding-right: 5px;"></th>
  484. <th style="text-align: right; padding-right: 5px;"></th>
  485. <th style="text-align: right; padding-right: 5px;"></th>
  486. <th style="text-align: right; padding-right: 5px;"></th>
  487. <th style="text-align: right; padding-right: 5px;"></th>
  488. <th style="text-align: right; padding-right: 5px;"></th>
  489. <th style="text-align: right; padding-right: 5px;"></th>
  490. <th style="text-align: right; padding-right: 5px;"></th>
  491. <th style="text-align: right; padding-right: 5px;"></th>
  492. <th style="text-align: right; padding-right: 5px;"></th>
  493. <th style="text-align: right; padding-right: 5px;"></th>
  494. <th style="text-align: right; padding-right: 5px;"></th>
  495. <th style="text-align: right; padding-right: 5px;"></th>
  496. <th style="text-align: right; padding-right: 5px;"></th>
  497. <th style="text-align: right; padding-right: 5px;"></th>
  498. <th style="text-align: right; padding-right: 5px;"></th>
  499. <th style="text-align: right; padding-right: 5px;"></th>
  500. <th style="text-align: right; padding-right: 5px;"></th>
  501. </tr>
  502. </tbody>
  503. </table>
  504. </div>
  505. </div>
  506. </div>
  507. </div>
  508.  
  509. </body>
  510. </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
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!