{"id":1278,"date":"2016-12-28T15:20:01","date_gmt":"2016-12-28T15:20:01","guid":{"rendered":"http:\/\/myprojects.advchaweb.com\/?p=1278"},"modified":"2016-12-29T09:21:50","modified_gmt":"2016-12-29T09:21:50","slug":"sistem-informasi-sekolah-sis","status":"publish","type":"post","link":"https:\/\/myprojects.advchaweb.com\/index.php\/2016\/12\/28\/sistem-informasi-sekolah-sis\/","title":{"rendered":"Sistem Informasi Sekolah (SIS)"},"content":{"rendered":"

Source: https:\/\/github.com\/balitax\/SI-Sekolah-L5<\/p>\n

Installation: (the most steps is pretty same with Laravel Blog<\/a>)<\/p>\n

    \n
  1. Create a new laravel project:\n
    composer create-project --prefer-dist laravel\/laravel sis<\/pre>\n
     <\/li>\n
  2. Download the app from https:\/\/github.com\/balitax\/SI-Sekolah-L5<\/a>. It’s better to donwload in zip file then extract the content in \/works\/laravel\/sis\/ directory. Overwrite the existing files and directories.<\/li>\n
  3. Install the laravel component required:\n
    composer install<\/pre>\n
     <\/li>\n
  4. edit .env file and fill the database account (DB name is sis)<\/li>\n
  5. Import the database file (database_sekolah.sql) along with the github.
    \nNote: authentication scaffolding NOT RUN HERE! ERROR BUT NO PROBLEM<\/li>\n
  6. Use ‘migration’ to add some new tables into the new database\n
    php artisan migrate<\/pre>\n
     <\/li>\n
  7. Dont forget to set the file permission in \/public\/ directory if we want to upload an image into it\n
    teddy@teddy-K43SJ:~\/Documents\/works\/laravel\/sis$ sudo chmod -R 777 public\/<\/pre>\n
     <\/li>\n
  8. I found some errors when tried it for the first time. http:\/\/localhost:8000\/login IS WORKING but CAN’T LOGIN. THE USER TABLE IN ‘tbl_kepegawaian’. BECAUSE I DONT KNOW THE ‘admin’ PASSWORD, I NEED TO UPDATE ‘password’ FIELD WITH ‘$2y$10$eWW.aZOeruiS1VEO0ghKHu7A7UoQcj2tVmLIcnw6JnrcsiljuOmYK’ –> ‘satria’. SO the ‘admin’ password is ‘satria’. NOW I CAN GO INTO THE ADMIN PAGE (dashboard, data sekolah, data siswa, galeri foto, absensi siswa, data pegawai, etc).
    \nTHERE ARE SO MANY ERRORS (I CAN’T GO INTO THE WEBSITE ROOT OR http:\/\/localhost:8000\/ BUT ONLY CAN GO TO http:\/\/localhost:8000\/admin). ANYWAY IT’S GOOD AND I CAN SEE THE SCREEN!
    \nNOTES: pls study the routes in \/app\/Http\/routes.php !<\/li>\n<\/ol>\n
    SOMETHING IS NEEDED TO FIX SOME ERRORS:<\/p>\n
      \n
    1. Error when I want to acces the root http:\/\/localhost:8000\/
      \n“FatalErrorException in Handler.php line 25:
      \nUncaught TypeError: Argument 1 passed to App\\Exceptions\\Handler::report() must be an instance of Exception, instance of Error given, called in \/home\/teddy\/Documents\/works\/laravel\/sis\/vendor\/laravel\/framework\/src\/Illuminate\/Foundation\/Bootstrap\/HandleExceptions.php on line 73 and defined in \/home\/teddy\/Documents\/works\/laravel\/sis\/app\/Exceptions\/Handler.php:25
      \nStack trace:
      \n#0 \/home\/teddy\/Documents\/works\/laravel\/sis\/vendor\/laravel\/framework\/src\/Illuminate\/Foundation\/Bootstrap\/HandleExceptions.php(73): App\\Exceptions\\Handler->report(Object(Error))
      \n#1 [internal function]: Illuminate\\Foundation\\Bootstrap\\HandleExceptions->handleException(Object(Error))
      \n#2 {main}
      \nthrown”
      \nSOLUTION: The error because I use PHP 7 (CLI) when I started the server (‘php artisan serve’). ref: http:\/\/stackoverflow.com\/questions\/36983734\/laravel-fatalerrorexception-in-handler-php-line-25<\/a>. So use php 5.6 instead when starting the server like this:<\/p>\n
      php5.6 artisan serve<\/pre>\n<\/li>\n
    2. Another error when accessing the root website:
      \n“FatalErrorException in FrontController.php line 42:
      \nClass ‘App\\Models\\Banner’ not found”
      \nSOLUTION: In \/app\/Http\/Controllers\/FrontController.php, comment a few lines:<\/p>\n
      \/\/$this->data['banner']           = Models\\Banner::where('id',1)->first();\r\n\/\/$this->data['link']             = Models\\Link::orderBy('id','desc')->limit(5)->get();\r\n\/\/$this->data['publikasi']        = Models\\Publikasi::orderBy('id','desc')->limit(3)->get();\r\n<\/pre>\n
      Because there is models available for them.
      \nAlso in ‘index’ function, replace ‘bappeda’ with ‘web’<\/p>\n
      public function index() {\r\n    \/\/return view('bappeda.home', $this->data);\r\n    return view('web.home', $this->data);\r\n}<\/pre>\n
       <\/li>\n
    3. Now, the root\/front website can be displayed but the website can’t be loaded. User need to upload the logo manually from the admin page -> Setting (http:\/\/localhost:8000\/admin\/setting). But when I saved the input, This error is appeared:
      \n“QueryException in Connection.php line 624:
      \nSQLSTATE[42S22]: Column not found: 1054 Unknown column ‘peta_latitude’ in ‘field list’ (SQL: update `tbl_setting` set `title_web` = Sekolah Ku, `desc_web` = Sekolah Ku, `key_web` = sekolah, `logo` = lapVa94436orMdu892YPf3uSj931XM.png, `facebook` = , `twitter` = , `gplus` = , `peta_latitude` = , `peta_longitude` = , `alamat` = , `no_telp` = , `no_fax` = , `email` = where `id_setting` = 1)”
      \nSOLUTION: Modify tbl_setting in the database, then add these new fields: peta_latitude varchar(25), peta_longitude varchar(25), alamat text, no_telp varchar(25), no_fax varchar(25) and email varchar(25).
      \nNow the website logo can be displayed      \"sis\"<\/a><\/li>\n
    4. When I clicked one of the news (berita) like http:\/\/localhost:8000\/baca\/berita\/2011-lembaga-pemerintah-sudah-harus-cicipi-open-source, I got this error:
      \n“InvalidArgumentException in FileViewFinder.php line 140:
      \nView [bappeda.berita_detail] not found.”
      \nSOLUTION: in \/app\/Http\/Controllers\/FrontController.php, Modify ‘berita’ function and replace ‘bappeda’ with ‘web’ and ‘berita_detail’ with ‘beritadetail’<\/p>\n
      public function berita($slug) {\r\n    $berita_detail              = Models\\Berita::where('slug_berita',$slug)->first();\r\n    $this->data['title']        = $berita_detail->judul_berita;\r\n    $this->data['beritalist']   = $berita_detail;\r\n    $this->data['desc']         = substr($berita_detail->isi,0,200).'...';\r\n    $this->data['key']          = $berita_detail->judul_berita;\r\n    \/\/return view('bappeda.berita_detail', $this->data);\r\n    return view('web.beritadetail', $this->data);\r\n}<\/pre>\n
       <\/li>\n
    5. When I clicked one of the ‘Profil Sekolah’ links like http:\/\/localhost:8000\/page\/profil-sekolah, I got this error:
      \n“InvalidArgumentException in FileViewFinder.php line 140:
      \nView [bappeda.halaman] not found.”
      \nSOLUTION: SAME WITH ABOVE, Modify ‘halaman’ function in FrontController.php and replace ‘bappeda’ with ‘web’:<\/p>\n
      public function halaman($slug) {\r\n    $detail_halaman         = Models\\Data::where('slug_data',$slug)->first();\r\n    $this->data['page']     = $detail_halaman;\r\n    $this->data['title']    = $detail_halaman->title;\r\n    $this->data['desc']     = strip_tags(substr($detail_halaman->content,0,200));\r\n    return view('web.halaman', $this->data);\r\n}<\/pre>\n<\/li>\n
    6. Some links still shows error like for ‘pengumuman’ (http:\/\/localhost:8000\/baca\/pengumuman\/pembagian-raport-semester-ganjil-tahun-ajaran-2010-2011) –> check the route and make sure the model is exist
      \nSOLUTION: There is no ‘pengumuman’ route, so add them (also for pengumuman index and detail) in \/app\/Http\/routes.php like this:<\/p>\n
      Route::get('\/pengumuman', 'FrontController@pengumumanlist');\r\nRoute::get('\/baca\/pengumuman\/{slug}', 'FrontController@pengumuman');<\/pre>\n
      Then in FrontController.php, like above replace ‘bappeda’ with ‘web’ for ‘pengumumanlist’ and ‘pengumuman’ functions:<\/p>\n
      public function pengumumanlist() {\r\n    ...\r\n    \/\/return view('bappeda.informasi', $this->data);\r\n    return view('web.pengumuman', $this->data);\r\n}\r\n\r\npublic function pengumuman($slug) {\r\n    ...\r\n    \/\/return view('bappeda.detail_informasi', $this->data);\r\n    return view('web.pengumuman_detail', $this->data);\r\n}<\/pre>\n
       <\/li>\n
    7. For Galleri menu, do this:\n
      public function album() {\r\n    ...\r\n    return view('web.galeri', $this->data);\r\n}\r\n\r\npublic function foto($id) {\r\n    ...\r\n    return view('web.galeri_detail', $this->data);\r\n}<\/pre>\n
       <\/li>\n
    8. Some pages in the admin (http:\/\/localhost:8000\/admin) still can’t be showed up properly (some weirds characters appeared!)<\/li>\n<\/ol>\n","protected":false},"excerpt":{"rendered":"
      Source: https:\/\/github.com\/balitax\/SI-Sekolah-L5 Installation: (the most steps is pretty same with Laravel Blog) Create a new laravel project: composer create-project –prefer-dist laravel\/laravel sis   Download the app from https:\/\/github.com\/balitax\/SI-Sekolah-L5. It’s better to donwload in zip file then extract the content in \/works\/laravel\/sis\/ directory. Overwrite the existing files and directories. Install the laravel component required: composer install … Continue reading “Sistem Informasi Sekolah (SIS)”<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[14,13],"tags":[],"class_list":["post-1278","post","type-post","status-publish","format-standard","hentry","category-laravel","category-tutorial"],"_links":{"self":[{"href":"https:\/\/myprojects.advchaweb.com\/index.php\/wp-json\/wp\/v2\/posts\/1278","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/myprojects.advchaweb.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/myprojects.advchaweb.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/myprojects.advchaweb.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/myprojects.advchaweb.com\/index.php\/wp-json\/wp\/v2\/comments?post=1278"}],"version-history":[{"count":10,"href":"https:\/\/myprojects.advchaweb.com\/index.php\/wp-json\/wp\/v2\/posts\/1278\/revisions"}],"predecessor-version":[{"id":1280,"href":"https:\/\/myprojects.advchaweb.com\/index.php\/wp-json\/wp\/v2\/posts\/1278\/revisions\/1280"}],"wp:attachment":[{"href":"https:\/\/myprojects.advchaweb.com\/index.php\/wp-json\/wp\/v2\/media?parent=1278"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/myprojects.advchaweb.com\/index.php\/wp-json\/wp\/v2\/categories?post=1278"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/myprojects.advchaweb.com\/index.php\/wp-json\/wp\/v2\/tags?post=1278"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}