/**
* Get an array of the currently online users.
*
* @return array
*/
function get_online()
{
$session = session_data();
/*$this->db->select('user_id,username,
(SELECT nama FROM ak_pegawai WHERE ak_pegawai.id=users.id) as nama_pegawai,
(SELECT nama FROM ak_siswa WHERE ak_siswa.id=users.id) as nama_siswa
');
$this->db->from('online');
$this->db->join('users','online.user_id=users.id_pengguna');
$this->db->where('online.user_id !=',$session['id_pengguna']);
$query = $this->db->get();return $query->result();*/
$query = $this->db->query('SELECT users.id as user_id, `username` ,
(
SELECT nama
FROM ak_pegawai
WHERE ak_pegawai.id = users.id
) AS nama_pegawai,
(
SELECT nama
FROM ak_siswa
WHERE ak_siswa.id = users.id
) AS nama_siswa
FROM sc_teman
JOIN users ON sc_teman.id_teman = users.id
JOIN online ON online.user_id = users.id
WHERE sc_teman.id_user ='******'id_pengguna'] . '
AND users.id !=' . $session['id_pengguna'] . '
');
return $query->result_object();
}
function __construct()
{
$session = session_data();
$this->ci =& get_instance();
$this->ci->load->database();
$this->ci->load->model('online');
$this->user_id = $session['id_pengguna'];
$this->ip = ip2long($_SERVER['REMOTE_ADDR']);
$this->Run_Online();
}
public function set_status()
{
$id_user = $this->input->post('id_user');
$status = $this->input->post('status');
$foto = $this->input->post('images');
$profile = $this->siswamodel->get_view_profile($id_user);
$profile = $profile['data_user'];
$session = session_data();
if (!empty($_POST)) {
$result = $this->usermodel->set_status_user();
$hasil = '<div class="itemOut status_parent" id="hapusstatus_' . $result->id_status . '">
<a href="' . base_url($result->foto) . '" class="prev_image image"><img src="' . base_url($result->foto) . '" alt="" title="" width="50" class="img-polaroid"/></a>
<div class="text">
<div class="info clearfix">
<span class="name"><a href="' . site_url('sos/siswa/view_profile/' . $result->id) . '">' . $session['username'] . ' > </a>' . $profile->nama . '</span>
<span class="date">' . CheckTime($result->tgl_status) . '</span>
</div>';
if ($result->id_foto == 0) {
$hasil .= '<p>' . MessageCheck($result->pesan) . '<span class="delete_status" id="status_' . $result->id_status . '">x</span></p>';
} else {
$hasil .= '<p>' . MessageCheck($result->pesan) . '</p>
<a href="' . base_url($result->large) . '" class="prev_image"><img src="' . base_url($result->small) . '"/></a>
<span class="delete_status" id="status_' . $result->id_status . '">X</span>';
}
$hasil .= '</div>
<div id="' . $result->id_status . '" id="hapusstatus_' . $result->id_status . '"></div>
<div class="komentar_user">
<div class="span2">
</div>
<div class="span10">
<form method="POST" id="komentar" action="' . site_url('sos/siswa/set_komentar') . '">
<div class="itemOut">
<div class="controls">
<div class="control">
<textarea name="komentar" class="komentar_teks" placeholder="Komentar anda ' . $result->nama . '" style="height: 50px; width: 100%;background: white;"></textarea>
<input type="hidden" name="id_siswa" value="' . $result->id_user . '"/>
<input type="hidden" name="id_status" value="' . $result->id_status . '"/>
<input type="hidden" name="' . $this->security->get_csrf_token_name() . '" value="' . $this->security->get_csrf_hash() . '">
</div>
</div>
</div>
</form>
</div>
<div class="hr"></div>
</div>
</div>';
echo $hasil;
}
}
function __construct()
{
parent::__construct();
$this->load->helper('global');
$this->load->library('session');
$this->load->library('auth');
$this->auth->user_logged_in();
$this->load->library('image_moo');
$this->load->library('Online_Users');
if (!isset($_SESSION['chatHistory'])) {
$_SESSION['chatHistory'] = array();
}
if (!isset($_SESSION['openChatBoxes'])) {
$_SESSION['openChatBoxes'] = array();
}
$session = session_data();
$_SESSION['username'] = $session['username'];
$_SESSION['nama'] = $session['nama'];
}
public function index()
{
$session = session_data();
$group = $session['otoritas'];
if (!empty($group)) {
if ($group == 'siswa') {
redirect('siswa');
} elseif ($group == 'ortu') {
redirect('ortu');
} elseif ($group == 'admin sekolah') {
redirect('admin/schooladmin');
} elseif ($group == 'superadmin') {
redirect('superadmin/super');
} elseif ($group == 'admin') {
redirect('adminsb/admin');
} else {
redirect('sos/pegawai');
}
}
}
public function edit()
{
$siswa2 = array();
$this->load->model('ad_siswa');
$this->load->model('ad_nilai');
$session = session_data();
//ambil nilai berdasarkan subject
$jenis = base64_decode($_POST['jenis']);
$nilai = $this->ad_nilai->getNilaiBySubjectTaSm($_POST['id_subject'], $jenis);
$nilai2 = array();
foreach ($nilai as $nilaidata) {
$nilai2[$nilaidata['id_siswa_det_jenjang']] = $nilaidata;
}
$siswa = $this->ad_siswa->getsiswaByIdKelas(@$_POST['id_kelas']);
foreach ($siswa as $siswadata) {
$siswa2[$siswadata['id_siswa_det_jenjang']] = $siswadata;
}
$data['id_subject'] = $_POST['id_subject'];
$data['nilai'] = $nilai2;
$data['siswa'] = $siswa2;
$session = session_data();
$data['main'] = 'akademik/nilaipr/edit';
$this->load->view('layout/ad_blank', $data);
}
public function cari_teman()
{
$session = session_data();
$nama = $this->input->get('term');
if (!empty($nama)) {
$this->db->select('id as id_user,username as label,username as value');
$this->db->from('sc_teman');
$this->db->join('users', 'users.id=sc_teman.id_teman');
$this->db->like('users.username', $nama, 'both');
$this->db->where('sc_teman.id_user', $session['id']);
$sql = $this->db->get();
if ($sql->num_rows() > 0) {
echo json_encode($sql->result_array());
} else {
echo '';
}
}
}
public function auth($usernamein = null, $passwordin = null)
{
if (isset($_POST['username']) && isset($_POST['password'])) {
$username = $this->input->post('username');
$password = $this->input->post('password');
} elseif ($usernamein != null && $passwordin != null) {
$username = $usernamein;
$password = $passwordin;
}
$user = $this->auth_user->get_user($username, $password);
$auth = $this->auth_user->get_auth($username, $password);
if (!empty($user)) {
$this->load->model('ad_setting');
$this->load->model('ad_kelas');
$this->load->model('ad_sekolah');
$kepsek = $this->ad_sekolah->getKepsek($user->id_sekolah);
$settingSmTa = $this->ad_setting->getTaSemesterAktif($user->id_sekolah);
$fitursekolah = $this->ad_setting->getFiturSekolah($user->id_sekolah);
$jenjang = $this->ad_kelas->thisjenjang($user->id);
$sessionsettings = array('jenjang' => $jenjang, 'semester' => $settingSmTa['semester']['id'], 'semester_nama' => $settingSmTa['semester']['nama'], 'ta' => $settingSmTa['ta']['id'], 'ta_nama' => $settingSmTa['ta']['nama'], 'ta_mulai' => $settingSmTa['ta']['mulai'], 'nama_sekolah' => $user->nama_sekolah, 'alamat_sekolah' => $user->alamat_sekolah, 'logo_sekolah' => $user->logo, 'ta_selesai' => $settingSmTa['ta']['selesai'], 'fitursekolah' => $fitursekolah, 'nama_kepsek' => $kepsek[0]['nama'], 'id_kepsek' => $kepsek[0]['id']);
$this->session->set_userdata('ak_setting', $sessionsettings);
if ($user->nama_peg == '') {
$namapengguna = $user->nama_siswa;
} elseif ($user->nama_siswa == '') {
$namapengguna = $user->nama_peg;
}
$detgroup = $this->auth_user->get_det_group($user->id);
foreach ($detgroup as $dtg) {
$detgroup2[] = $dtg['id_group'];
}
unset($detgroup);
//pr($user);die();
$sessiondata = array('id' => $user->id, 'id_group' => $user->id_group, 'id_pengguna' => $user->id_pengguna, 'id_sekolah' => $user->id_sekolah, 'username' => $user->username, 'nama' => $namapengguna, 'password' => $user->password, 'images' => $user->images, 'otoritas' => $user->otoritas, 'det_group' => $detgroup2, 'fb_id' => $user->fb_id, 'auth' => $auth);
if ($user->otoritas == 'siswa' || $user->otoritas == 'ortu') {
if ($user->otoritas == 'siswa') {
$idsiswa = $user->id_pengguna;
} elseif ($user->otoritas == 'ortu') {
$idsiswa = $user->id_siswa;
}
$this->load->model('ad_siswa');
$siswa = $this->ad_siswa->getSiswaIdDetJenjang($user->id_sekolah, $settingSmTa['ta']['id'], $idsiswa);
$sessiondata['id_siswa_det_jenjang'] = $siswa[0]['id_siswa_det_jenjang'];
$sessiondata['id_kelas_siswa_det_jenjang'] = $siswa[0]['id_kelas_siswa_det_jenjang'];
$sessiondata['kelas'] = $siswa[0]['kelas'];
$sessiondata['nis'] = $siswa[0]['nis'];
$sessiondata['nama_kelas'] = $siswa[0]['nama_kelas'];
$sessiondata['id_siswa'] = $idsiswa;
}
//cek konek facebook
/*if ($user->fb_id=='') {
$this->load->library('ak_facebook');
$userfbid=$this->ak_facebook->getuserid();
//echo $userfbid;die();
if ($userfbid) {
$this->db->query("UPDATE users SET fb_id='".$userfbid."' WHERE id=".$user->id."");
$sessiondata['fb_id'] = $userfbid;
}
} else {
$sessiondata['fb_id'] = $user->fb_id;
}*/
$this->session->set_userdata('user', $sessiondata);
$this->session->set_userdata('user_authentication', $sessiondata);
/* decide what the content should be up here .... */
/* AJAX check */
if (isset($_SERVER['HTTP_X_REQUESTED_WITH']) && strtolower($_SERVER['HTTP_X_REQUESTED_WITH']) == 'xmlhttprequest') {
/* special ajax here */
echo 1;
die;
}
/* not ajax, do more.... */
//set_blue_notification('Welcome to Studentbook');
//redirect('home');
$session = session_data();
$group = $session['otoritas'];
if (!empty($group)) {
if ($group == 'siswa') {
redirect('siswa/mainsiswa');
} elseif ($group == 'ortu') {
redirect('siswa/mainsiswa');
} elseif ($group == 'admin sekolah') {
redirect('admin/schooladmin');
} elseif ($group == 'superadmin') {
redirect('superadmin/super');
} elseif ($group == 'admin') {
redirect('adminsb/admin');
} else {
redirect('akademik/mainakademik/index');
}
}
} else {
if (isset($_SERVER['HTTP_X_REQUESTED_WITH']) && strtolower($_SERVER['HTTP_X_REQUESTED_WITH']) == 'xmlhttprequest') {
/* special ajax here */
echo 0;
die;
}
/* not ajax, do more.... */
//set_red_notification('Password dan Username tidak terdaftar, mohon ulangi lagi');
//print_notification();
echo "<script>alert('Username atau Password anda tidak terdaftar');window.location='" . base_url() . "';</script>";
}
}
function session_jurnalis()
{
$CI =& get_instance();
$CI->load->library('session');
$CI->load->database();
$data = session_data();
if (!empty($data)) {
$CI->db->from('det_group a');
$CI->db->where('a.id_user', $data['id']);
$CI->db->where('a.id_group', '22');
$CI->db->or_where('a.id_group', '28');
$sql = $CI->db->get();
if ($sql->num_rows() > 0) {
return $sql->row();
} else {
return '';
}
} else {
return '';
}
}
public function set_status_group()
{
$id_group = $this->input->post('id_group');
$status = $this->input->post('status');
$foto = $this->input->post('images');
$id_member = '';
//cari id_member dulu
$session = session_data();
$this->db->from('sc_member');
$this->db->where('id_user', $session['id']);
$this->db->where('stat_member', 'aktif');
$this->db->where('stat_confirm', 'terima');
$sql = $this->db->get();
if ($sql->num_rows() > 0) {
$id_member = $sql->row();
$id_member = $id_member->id_member;
} else {
$id_member = '';
}
if (!empty($status) and !empty($id_member)) {
if (!empty($foto)) {
$data = array('id_member' => $id_member, 'small' => 'upload/images/thumb/' . $foto, 'medium' => 'upload/images/medium/' . $foto, 'large' => 'upload/images/larger/' . $foto, 'keterangan' => $status, 'tgl_foto' => date('Y-m-d'), 'id_group' => $id_group);
$this->db->insert('sc_foto_group', $data);
$id_foto = $this->db->insert_id();
$data = array('status' => $status, 'id_member' => $id_member, 'id_foto' => $id_foto, 'id_group' => $id_group);
$this->db->insert('sc_status_group', $data);
$id = $this->db->insert_id();
$this->db->from('sc_status_group');
$this->db->join('sc_member', 'sc_member.id_member=sc_status_group.id_member');
$this->db->join('sc_foto_group', 'sc_status_group.id_foto=sc_foto_group.id_foto_group');
$this->db->where('id_stat_group', $id);
$sql = $this->db->get();
if ($sql->num_rows() > 0) {
return $sql->row();
} else {
return '';
}
} else {
$data = array('status' => $status, 'id_member' => $id_member, 'id_group' => $id_group);
$this->db->insert('sc_status_group', $data);
$id = $this->db->insert_id();
$this->db->from('sc_status_group');
$this->db->join('sc_member', 'sc_member.id_member=sc_status_group.id_member');
$this->db->where('id_stat_group', $id);
$sql = $this->db->get();
if ($sql->num_rows() > 0) {
return $sql->row();
} else {
return '';
}
}
}
}
public function kepsek()
{
$session = session_data();
$data['main'] = 'akademik/mainakademik/kepsek';
$this->load->view('layout/ak_default', $data);
}
public function simpan_kegiatan()
{
$session = session_data();
$judul = $this->input->post('judul');
$tgl = $this->input->post('tgl_kegiatan');
$jam = $this->input->post('jam');
$tempat = $this->input->post('tempat');
$ket = $this->input->post('keterangan');
if (!empty($_FILES)) {
$config['upload_path'] = "upload/images/larger/";
$config['allowed_types'] = 'gif|jpg|png|jpeg';
$config['max_size'] = '2000';
$config['max_width'] = '4000';
$config['max_height'] = '4000';
$file_name = '';
$this->load->library('upload', $config);
if ($this->upload->do_upload('foto')) {
$data['img'] = $this->upload->data();
$file_name = $this->upload->file_name;
$this->image_moo->load("upload/images/larger/" . $file_name)->resize_crop(100, 100)->save("upload/images/thumb/" . $file_name);
}
$data = array('id_admin' => $session['id_pengguna'], 'id_sek' => $session['id_sekolah'], 'judul' => $judul, 'tgl_keg' => $tgl, 'foto' => $file_name, 'jam' => $jam, 'lokasi' => $tempat, 'keterangan' => $ket);
$this->db->insert('sc_kegiatan', $data);
} else {
$data = array('id_admin' => $session['id_pengguna'], 'id_sek' => $session['id_sekolah'], 'judul' => $judul, 'tgl_keg' => $tgl, 'jam' => $jam, 'lokasi' => $tempat, 'keterangan' => $ket);
$this->db->insert('sc_kegiatan', $data);
}
redirect('sos/sekolah');
}
public function tambah_anggota_group($id)
{
if ($id != 0) {
$session = session_data();
$list_member = $this->get_tambah_member($id);
$data['teman'] = $list_member['data'];
$data['pagination'] = $list_member['pagination'];
$data['user'] = $session['id'];
$data['user_online'] = $this->online_users->get_online();
$data['status_group'] = $this->group_model->get_status_group();
//$data['member_group'] = $this->group_model->get_member_group($id);
$data['acara_group'] = $this->group_model->get_acara_group($id);
$data['member_or_not'] = $this->group_model->cek_member_group($session['id']);
$data['data_group'] = $this->group_model->get_data_group($id);
$data['sidebar'] = 'layout/template_sidebar';
$data['main'] = 'sosial/viewgroup';
$this->load->view('layout/fr_group', $data);
}
}
public function set_acara_user()
{
$session = session_data();
$acara = $this->input->post('acara');
$hari = $this->input->post('hari');
$tgl = $this->input->post('tgl');
$jam = $this->input->post('jam');
$tempat = $this->input->post('tempat');
$keterangan = $this->input->post('keterangan');
$id_undangan = $this->input->post('id_undangan');
$data = array('tgl_acara' => $tgl, 'waktu' => $jam, 'tempat' => $tempat, 'nama_acara' => $acara, 'id_admin_acara' => $session['id'], 'pengundang' => $session['username'], 'keterangan' => $keterangan);
$this->db->insert('sc_acara', $data);
$id_acara = $this->db->insert_id();
if (!empty($id_undangan)) {
foreach ($id_undangan as $id_user) {
$data = array('id_acara' => $id_acara, 'id_user' => $id_user);
$this->db->insert('sc_undangan', $data);
}
}
}
public function profile($id = null)
{
$session = session_data();
if ($session) {
$data['siswa_edit'] = $this->siswamodel->edit_data_siswa($id);
$data['siswa'] = $this->siswamodel->get_siswa($id);
$data['main'] = 'sosial/editsiswa';
$this->load->view('layout/fr_default', $data);
} else {
redirect('homepage/login');
// $data['page_title'] = 'studentbook';
// $this->load->view('layout/ad_login',$data);
}
}
public function set_status_user()
{
$id_user = $this->input->post('id_user');
$status = $this->input->post('status');
$foto = $this->input->post('images');
$user = $this->input->post('user');
if (!empty($status)) {
$session = session_data();
if (!empty($foto)) {
$data = array('id_user' => $session['id_pengguna'], 'small' => 'upload/images/thumb/' . $foto, 'medium' => 'upload/images/medium/' . $foto, 'large' => 'upload/images/larger/' . $foto, 'ket_foto' => $status);
$this->db->insert('sc_foto', $data);
$id_foto = $this->db->insert_id();
$data = array('pesan' => $status, 'id_user' => $session['id_pengguna'], 'id_foto' => $id_foto, 'kategori' => 'pribadi', 'id_untuk' => $id_user);
$this->db->insert('sc_status', $data);
$id = $this->db->insert_id();
if ($user == 'siswa') {
$this->db->from('sc_status');
$this->db->join('ak_siswa', 'ak_siswa.id=sc_status.id_user');
$this->db->join('sc_foto', 'sc_status.id_foto=sc_foto.id_foto');
$this->db->where('id_status', $id);
$sql = $this->db->get();
if ($sql->num_rows() > 0) {
return $sql->row();
} else {
return '';
}
} else {
$this->db->from('sc_status');
$this->db->join('ak_pegawai', 'ak_pegawai.id=sc_status.id_user');
$this->db->join('sc_foto', 'sc_status.id_foto=sc_foto.id_foto');
$this->db->where('id_status', $id);
$sql = $this->db->get();
if ($sql->num_rows() > 0) {
return $sql->row();
} else {
return '';
}
}
} else {
$data = array('pesan' => $status, 'id_user' => $session['id_pengguna'], 'kategori' => 'pribadi', 'id_untuk' => $id_user);
$this->db->insert('sc_status', $data);
$id = $this->db->insert_id();
if ($user == 'siswa') {
$this->db->from('sc_status');
$this->db->join('ak_siswa', 'ak_siswa.id=sc_status.id_user');
$this->db->where('id_status', $id);
$sql = $this->db->get();
if ($sql->num_rows() > 0) {
return $sql->row();
} else {
return '';
}
} else {
$this->db->from('sc_status');
$this->db->join('ak_pegawai', 'ak_pegawai.id=sc_status.id_user');
$this->db->where('id_status', $id);
$sql = $this->db->get();
if ($sql->num_rows() > 0) {
return $sql->row();
} else {
return '';
}
}
}
}
}
public function index()
{
$session = session_data();
$data['main'] = 'sosial/guruview';
$this->load->view('layout/fr_default', $data);
}
<?php
echo $this->load->view('siswa/js');
?>
<?php
$cek = session_data();
if (empty($cek)) {
$cek = '';
}
$user = DataUser();
if (empty($user->foto)) {
$user->foto = 'asset/default/images/no_profile.jpg';
}
if ($cek['otoritas'] == 'siswa') {
$url_redirect = site_url('sos/siswa/');
} else {
$url_redirect = site_url('sos/pegawai/');
}
echo $this->load->view('akademik/mainakademik/topindex');
?>
<div class="portfolio column-one-half-with-sidebar">
<div class="notifak column content content-full-width">
<h3 class="float-left"> NOTIFIKASI AKADEMIK </h3>
<div class="hr"></div>
<br style="clear:both;">
<div class="toggle-frame">
<h5 class="toggle-accordion"><a >Pemberitahuan terahir dari sekolah</a></h5>
<div style="display: block; max-height:400px;" class="toggle-content">
public function group_ditolak($id)
{
if ($id != 0) {
$session = session_data();
$this->db->where('id_group', $id);
$this->db->where('id_user', $session['id']);
$this->db->where('stat_confirm', 'menunggu');
$this->db->delete('sc_member');
}
}
