Advertisement
Guest User

Untitled

a guest
Dec 21st, 2017
100
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 16.23 KB | None | 0 0
  1. INI CONTROLLERX MAS :
  2. <?php
  3. defined('BASEPATH') OR exit ('No direct script access allowed');
  4.  
  5. Class Admin extends CI_Controller
  6. {
  7. public function __construct()
  8. {
  9. parent:: __construct();
  10. $this->load->model('auth_model');
  11. if(!isset($_SESSION['user_logged'])){
  12. $this->session->set_flashdata("error","please login");
  13. redirect ("auth/login");
  14. }
  15. }
  16. public function index()
  17. {
  18. $data_content['view_isi'] = "admins/profile";
  19. $this->load->view('admins/beranda_admin',$data_content);
  20.  
  21. }
  22. public function datasiswa()
  23. {
  24. $data_content['view_isi'] = "admins/datasiswa";
  25. $this->load->view('admins/beranda_admin',$data_content);
  26. }
  27. public function do_upload()
  28. {
  29. $username = $this->input->post('username');
  30. $namauser = $this->input->post('namauser');
  31. $password = $this->input->post('password');
  32. $email = $this->input->post('email');
  33. $config = array(
  34. 'upload_path' =>'./assets/dist/img/',
  35. 'allowed_types' => 'gif|jpg|png',
  36. 'max_size' => 100,
  37. 'max_width' => 1024,
  38. 'max_height' => 768,
  39. );
  40. $this->load->library('upload',$config);
  41. $data_gbr = $_FILES['changepic']['name'];
  42. if ( ! $this->upload->do_upload('changepic'))
  43. {
  44. echo "gagal";
  45. }
  46. else
  47. {
  48. $data = array (
  49. 'username' => $username,
  50. 'nama_user' => $namauser,
  51. 'password' => $password,
  52. 'email'=> $email,
  53. 'gambar' => $data_gbr
  54. );
  55.  
  56. $this->db->where('username', $username);
  57.  
  58. $this->db->update('m_user',$data);
  59. }
  60.  
  61. }
  62. public function showAllSiswa()
  63. {
  64. $result = $this->auth_model->showAllSiswa();
  65.  
  66. $datasiswa = [];
  67. $datasiswa['data'] = [];
  68. foreach($result as $index => $value) {
  69. $datasiswa['data'][$index] = array(
  70. $value->NIS,
  71. $value->NAMA,
  72. $value->KELAS,
  73. $value->JURUSAN,
  74. $value->ALAMAT
  75. );
  76. };
  77.  
  78. echo json_encode($datasiswa);
  79. }
  80. //......................... I N D U S T R I ...............................
  81. public function dataindustri()
  82. {
  83. $data_content['view_isi'] = "admins/dataindustri";
  84. $this->load->view('admins/beranda_admin',$data_content);
  85. }
  86.  
  87. public function editDataIndustri() {
  88. $id = $_POST['kode'];
  89. $result = $this->auth_model->editDataIndustri($id);
  90.  
  91. echo json_encode($result);
  92. }
  93.  
  94. public function showDataIndustri()
  95. {
  96. $result = $this->auth_model->showDataIndustri();
  97. $dataindustri = [];
  98. $dataindustri['data'] = [];
  99.  
  100. foreach($result as $index => $value) {
  101. $dataindustri['data'][$index] = array (
  102. $value->nama_industri,
  103. $value->alamat_industri,
  104. $value->telepon_industri,
  105. $value->direktur,
  106. $value->jurusan,
  107. '<input type="button" class="btn btn-default" data-toggle="modal" value="Edit" data-target="#editIndustriModal" data-kode="'.$value->kode_industri.'"><a class="btn btn-sm btn-danger" href="javascript:void(0)" title="Hapus" onclick="delete_industri('."'".$value->kode_industri."'".')"><i class="glyphicon glyphicon-trash"></i> Delete</a><a class="btn btn-sm btn-info" title="PrintOne" href="formulirpersetujuan?kode='.$value->kode_industri.'"><i class="glyphicon glyphicon-print"></i>Print</a>'
  108. );
  109. };
  110.  
  111. echo json_encode($dataindustri);
  112. }
  113.  
  114. public function showDataIndustri2()
  115. {
  116. $result = $this->auth_model->showDataIndustri();
  117. $dataindustri = [];
  118. $dataindustri['data'] = [];
  119.  
  120. foreach($result as $index => $value) {
  121. $dataindustri['data'][$index] = array (
  122. '<input name="idcek" id="id" type="checkbox" value="'.$value->kode_industri.'">',
  123. $value->nama_industri,
  124. $value->alamat_industri,
  125. $value->direktur
  126.  
  127. );
  128. };
  129.  
  130. echo json_encode($dataindustri);
  131. }
  132.  
  133. public function add_industri()
  134.  
  135. {
  136. $data = array(
  137. 'nama_industri' => $this->input->post('nama'),
  138. 'alamat_industri' => $this->input->post('alamat'),
  139. 'telepon_industri' => $this->input->post('telepon'),
  140. 'direktur' => $this->input->post('direktur'),
  141. 'jurusan' => $this->input->post('jurusan'),
  142. );
  143. $insert = $this->auth_model->saveIndustri($data);
  144. echo json_encode(array("status" => TRUE));
  145.  
  146.  
  147. }
  148.  
  149. public function edit_industri() {
  150. $kode = $this->input->post('id');
  151. $data = array(
  152. 'nama_industri' => $this->input->post('nama'),
  153. 'alamat_industri' => $this->input->post('alamat'),
  154. 'telepon_industri' => $this->input->post('telepon'),
  155. 'direktur' => $this->input->post('direktur'),
  156. 'jurusan' => $this->input->post('jurusan'),
  157. );
  158. $insert = $this->auth_model->updateIndustri($data, $kode);
  159. echo json_encode(array("status" => TRUE));
  160. }
  161. public function hapus_industri($kode_industri)
  162. {
  163.  
  164. $this->auth_model->delete_kodeindustri($kode_industri);
  165. echo json_encode(array("status" => TRUE));
  166. }
  167. public function formulirpersetujuan()
  168. {
  169. $id = $_GET['kode'];
  170. $industri = $this->auth_model->editDataIndustri($id);
  171. $this->load->vars('i', $industri);
  172. $data_content['view_isi'] = "admins/formulirpersetujuan";
  173. $this->load->view('admins/beranda_admin',$data_content);
  174. }
  175. public function formpersetujuan()
  176. {
  177. $data_content['view_isi'] = "admins/formpersetujuan";
  178. $this->load->view('admins/beranda_admin',$data_content);
  179. }
  180. public function showFormIndustri()
  181. {
  182. $result = $this->auth_model->model_formindustri();
  183. $dataformindustri = [];
  184. $dataformindustri['dataform'] = [];
  185.  
  186. foreach($result as $index => $value) {
  187. $dataformindustri['dataform'][$index] = array (
  188. $value->nama_industri,
  189. $value->alamat_industri,
  190. $value->telepon_industri,
  191. $value->direktur,
  192. $value->nomor_surat,
  193. $value->periode
  194.  
  195.  
  196. );
  197. };
  198.  
  199. echo json_encode($dataformindustri);
  200. }
  201.  
  202. public function add_formpersetujuan()
  203. {
  204. $data = array(
  205. 'kode_industri' => $this->input->post('idcek'),
  206. 'periode' => $this->input->post('datepicker')."-".$this->input->post('datepicker2'),
  207. 'nomor_surat'=>$this->input->post('nomor_surat')
  208. );
  209. $insert = $this->auth_model->simpen_formpersetujuan($data);
  210. echo json_encode($data);
  211.  
  212. }
  213.  
  214. }
  215.  
  216. INI VIEWX MAS :
  217. <section class="content">
  218. <div class="row">
  219. <div class="col-xs-12">
  220. <div class="box">
  221. <div class="box-header">
  222. <h3 class="box-title">Formulir Persetujuan</h3>
  223. </div>
  224. <div class="box-body">
  225. <form action="#" id="form" class="form-horizontal">
  226. <div class="col-md-6">
  227. <div class="form-group">
  228. <label>Nomor Formulir</label>
  229. <div class="input-group">
  230. <div class="input-group-addon">
  231. <i class="fa fa-envelope"></i>
  232. </div>
  233. <input type="text" class="form-control" name="nomor_surat" id="nomor_surat">
  234. </div>
  235. <!-- /.input group -->
  236. </div>
  237. <div class="form-group">
  238. <label>Periode Praktek Kerja Lapang</label>
  239.  
  240. <div class="input-group date">
  241. <div class="input-group-addon">
  242. <i class="fa fa-calendar"></i>
  243. </div>
  244. <input type="text" class="form-control pull-right" name="datepicker" id="datepicker">
  245. <div class="input-group-addon">
  246. <i class="fa fa-calendar"></i>
  247. </div>
  248. <input type="text" class="form-control pull-right" name="datepicker2" id="datepicker2">
  249. </div>
  250. </div>
  251.  
  252. </div>
  253. <div class="col-md-6">
  254. <div class="form-group">
  255. <label>Cek Data Industri</label>
  256. <div class="input-group">
  257. <table class="table table-bordered table-hover" id="tableFormIndustri">
  258. <thead>
  259. <tr>
  260. <th>Silahkan Pilih</th>
  261. <th>Nama Industri</th>
  262. <th>Alamat</th>
  263. <th>Direktur</th>
  264.  
  265. </tr>
  266. </thead>
  267. </table>
  268. </div>
  269. </div>
  270. </div>
  271. <div class="box-footer">
  272. <button type="button" id="btnSave" onclick="save()" class="btn btn-primary">Save</button>
  273. </div>
  274. </form>
  275. </div>
  276. <label>Cek Data Industri</label>
  277.  
  278. <table class="table table-bordered table-hover" id="tableFormPersetujuan">
  279. <thead>
  280. <tr>
  281. <th>Nama Industri</th>
  282. <th>Alamat Industri</th>
  283. <th>Telephon</th>
  284. <th>Direktur</th>
  285. <th>Nomor Surat</th>
  286. <th>Periode</th>
  287.  
  288.  
  289. </tr>
  290. </thead>
  291. </table>
  292. </div>
  293.  
  294.  
  295.  
  296.  
  297. </div>
  298.  
  299. <!-- /.row -->
  300. </section>
  301. <!-- /.content -->
  302. </div>
  303. <script>
  304. $(function () {
  305.  
  306. $('#tableFormIndustri').DataTable({
  307. 'ajax': {
  308. 'url' : '<?php echo base_url()?>index.php/admin/showDataIndustri2',
  309. 'type' : 'POST'
  310. }
  311. });
  312. $('#tableFormPersetujuan').DataTable({
  313. 'ajax': {
  314. 'url' : '<?php echo base_url()?>index.php/admin/showFormIndustri'
  315. }
  316. });
  317. //Initialize Select2 Elements
  318. $('.select2').select2()
  319.  
  320. //Datemask dd/mm/yyyy
  321. $('#datemask').inputmask('DD/MM/YYYY', { 'placeholder': 'DD/MM/YYYY' })
  322. //Datemask2 mm/dd/yyyy
  323. $('#datemask2').inputmask('DD/MM/YYYY', { 'placeholder': 'DD/MM/YYYY' })
  324. //Money Euro
  325. $('#nomor_surat').inputmask('999.9/999/999.9.9.99/9999');
  326. //Date range picker
  327. $('#reservation').daterangepicker()
  328. //Date range picker with time picker
  329. $('#reservationtime').daterangepicker({ timePicker: true, timePickerIncrement: 30, format: 'MM/DD/YYYY h:mm A' })
  330. //Date range as a button
  331. $('#daterange-btn').daterangepicker(
  332. {
  333. ranges : {
  334. 'Today' : [moment(), moment()],
  335. 'Yesterday' : [moment().subtract(1, 'days'), moment().subtract(1, 'days')],
  336. 'Last 7 Days' : [moment().subtract(6, 'days'), moment()],
  337. 'Last 30 Days': [moment().subtract(29, 'days'), moment()],
  338. 'This Month' : [moment().startOf('month'), moment().endOf('month')],
  339. 'Last Month' : [moment().subtract(1, 'month').startOf('month'), moment().subtract(1, 'month').endOf('month')]
  340. },
  341. startDate: moment().subtract(29, 'days'),
  342. endDate : moment()
  343. },
  344. function (start, end) {
  345. $('#daterange-btn span').html(start.format('MMMM D, YYYY') + ' - ' + end.format('MMMM D, YYYY'))
  346. }
  347. )
  348.  
  349. //Date picker
  350. $('#datepicker').datepicker({
  351. format: "dd-MM-yyyy",
  352. autoclose: true
  353. })
  354. $('#datepicker2').datepicker({
  355. format: "dd-MM-yyyy",
  356. autoclose: true
  357. })
  358.  
  359. //iCheck for checkbox and radio inputs
  360. $('input[type="checkbox"].minimal, input[type="radio"].minimal').iCheck({
  361. checkboxClass: 'icheckbox_minimal-blue',
  362. radioClass : 'iradio_minimal-blue'
  363. })
  364. //Red color scheme for iCheck
  365. $('input[type="checkbox"].minimal-red, input[type="radio"].minimal-red').iCheck({
  366. checkboxClass: 'icheckbox_minimal-red',
  367. radioClass : 'iradio_minimal-red'
  368. })
  369. //Flat red color scheme for iCheck
  370. $('input[type="checkbox"].flat-red, input[type="radio"].flat-red').iCheck({
  371. checkboxClass: 'icheckbox_flat-green',
  372. radioClass : 'iradio_flat-green'
  373. })
  374.  
  375. //Colorpicker
  376. $('.my-colorpicker1').colorpicker()
  377. //color picker with addon
  378. $('.my-colorpicker2').colorpicker()
  379.  
  380. //Timepicker
  381. $('.timepicker').timepicker({
  382. showInputs: false
  383. })
  384. });
  385. function save()
  386. {
  387. var $form;
  388. $form = $('#form').serialize();
  389. $.ajax({
  390. url : "<?php echo site_url('admin/add_formpersetujuan')?>",
  391. type: 'POST',
  392. data: $form,
  393. dataType: "JSON",
  394. success: function(res){
  395. //if(res)
  396. //{
  397. // alert("Data: " + res.no);
  398. //}
  399.  
  400. //if success close modal and reload ajax table
  401. //$('#modal_form').modal('hide');
  402. location.reload();// for reload a page
  403. },
  404. error: function (jqXHR, textStatus, errorThrown)
  405. {
  406. alert('Error adding / update data');
  407. }
  408.  
  409.  
  410. });
  411.  
  412. }
  413. </script>
  414.  
  415. INI MODELNYA MAS :
  416.  
  417. <?php
  418. defined('BASEPATH') OR exit('No direct script access allowed');
  419. class Auth_model extends CI_Model
  420. {
  421. public function __construct()
  422. {
  423. parent::__construct();
  424. }
  425. function update_data($data)
  426. {
  427.  
  428. $this->db->where('username', $username);
  429. //$this->db->update('tb_mahasiswa', $data);
  430. $this->db->update('m_user',$data);
  431. }
  432. public function showAllSiswa()
  433. {
  434. $query = $this->db->get('m_siswa');
  435. if($query->num_rows() > 0)
  436. {
  437. return $query->result();
  438. }else{
  439. return false;
  440. }
  441. }
  442. public function showDataIndustri()
  443. {
  444. $query = $this->db->get('m_industri');
  445. if($query->num_rows() > 0)
  446. {
  447. return $query->result();
  448.  
  449. } else {
  450. return false;
  451. }
  452. }
  453.  
  454. //buat fungsi untuk cari data industri
  455. public function editDataIndustri($id) {
  456.  
  457. $this->db->where('kode_industri', $id);
  458. $query = $this->db->get('m_industri');
  459.  
  460. return $query->result();
  461. }
  462. public function editDataIndustri2() {
  463.  
  464. $this->db->where('kode_industri', $id);
  465. $query = $this->db->get('m_industri');
  466.  
  467. return $query->result();
  468. }
  469.  
  470. public function saveIndustri($data)
  471. {
  472. $this->db->insert('m_industri', $data);
  473. return $this->db->insert_id();
  474. }
  475.  
  476. public function updateIndustri($data, $kode) {
  477.  
  478. $this->db->where('kode_industri', $kode);
  479. $this->db->update('m_industri', $data);
  480.  
  481. return true;
  482. }
  483. public function delete_kodeindustri($kode_industri)
  484. {
  485. $this->db->where('kode_industri', $kode_industri);
  486. $this->db->delete('m_industri');
  487.  
  488. }
  489. public function model_formindustri()
  490. {
  491. $this->db->select('*');
  492. $this->db->from('formulir_persetujuan');
  493. $this->db->join('m_industri', 'm_industri.kode_industri = formulir_persetujuan.kode_industri');
  494. $query = $this->db->get();
  495. if($query->num_rows() > 0)
  496. {
  497. return $query->result();
  498. } else {
  499. return false;
  500. }
  501. }
  502. public function simpen_formpersetujuan($data)
  503. {
  504. $this->db->insert('formulir_persetujuan', $data);
  505. return $this->db->insert_id();
  506. }
  507. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement