view_info.php
5.65 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
<?php
if(isset($_GET['infoid'])){
require_once "view_info_detail.php";
}else{
/* PAGINATION */
$batas = 15;
$pg = isset( $_GET['halaman'] ) ? $_GET['halaman'] : "";
if(empty($pg)){
$posisi = 0;
$pg = 1;
}else{
$posisi = ($pg-1) * $batas;
}
/* END PAGINATION */
if(isset($_GET['keyword'])){
$keyword = "%".$_GET['keyword']."%";
//$field = array("a.id_user as iduser_dis","a.*","b.*");
if(empty($_GET['keyword'])){
$CekInfo = $this->model->selectprepare("info a join user c on a.pengirim_info=c.id_user", $field=null, $params=null, $where=null, "WHERE a.tujuan_info LIKE '%\"$_SESSION[id_user]\"%' order by a.tgl_info DESC LIMIT $posisi, $batas");
$CekInfo2 = $this->model->selectprepare("info a join user c on a.pengirim_info=c.id_user", $field=null, $params=null, $where=null, "WHERE a.tujuan_info LIKE '%\"$_SESSION[id_user]\"%'");
}else{
$params = array(':judul_info' => $keyword, ':ket_info' => $keyword);
$CekInfo = $this->model->selectprepare("info a join user c on a.pengirim_info=c.id_user", $field=null, $params, "(a.judul_info LIKE :judul_info OR a.ket_info LIKE :ket_info)", "AND a.tujuan_info LIKE '%\"$_SESSION[id_user]\"%' order by a.tgl_info DESC LIMIT $posisi, $batas");
$CekInfo2 = $this->model->selectprepare("info a join user c on a.pengirim_info=c.id_user", $field=null, $params, "(a.judul_info LIKE :judul_info OR a.ket_info LIKE :ket_info)", "AND a.tujuan_info LIKE '%\"$_SESSION[id_user]\"%'");
}
}else{
$CekInfo = $this->model->selectprepare("info a join user c on a.pengirim_info=c.id_user", $field=null, $params=null, $where=null, "WHERE a.tujuan_info LIKE '%\"$_SESSION[id_user]\"%' order by a.tgl_info DESC LIMIT $posisi, $batas");
}
if($CekInfo->rowCount() >= 1){
if($HakAkses->info == "Y"){?>
<?php /*<li>
<a href="./index.php?op=add_memo" title="Edit" class="tooltips">
<i class="sa-list-add"></i>
</a>
</li><?php */
}?>
<div class="widget-box">
<div id="inbox" class="tab-pane in active">
<div class="message-container">
<div class="message-list-container">
<div class="message-list" id="message-list"><?php
$no=1+$posisi;
while($DataInfo = $CekInfo->fetch(PDO::FETCH_OBJ)){
$tgl_info = substr($DataInfo->tgl_info,0,10);
$params2 = array(':id_sm' => $DataInfo->id_info, ':id_user' => $_SESSION['id_user'], ':kode' => 'INFO');
$CekRead = $this->model->selectprepare("surat_read", $field=null, $params2, "id_sm=:id_sm AND id_user=:id_user AND kode=:kode", $order=null);
if($CekRead->rowCount() <= 0){?>
<div class="message-item message-unread">
<label class="inline">
<span class="lbl" style="color:#609FC4;font-weight:700"><small><?php echo $no;?></small></span>
</label>
<span class="sender" title="<?php echo $DataInfo->nama;?>"><?php echo $DataInfo->nama;?></span>
<span class="time" style="width:100px;"><small><?php echo tgl_indo($tgl_info);?></small></span>
<span class="summary">
<span class="text">
<a href="./index.php?op=info&infoid=<?php echo $DataInfo->id_info;?>"><?php echo $DataInfo->judul_info;?></a>
</span>
</span>
</div><?php
}else{?>
<div class="message-item">
<label class="inline">
<span style="color:#467287;"><small><?php echo $no;?></small></span>
</label>
<span class="sender" title="<?php echo $DataInfo->nama;?>"><?php echo $DataInfo->nama;?></span>
<span class="time" style="width:100px;"><small><?php echo tgl_indo($tgl_info);?></small></span>
<span class="summary">
<span class="text">
<a href="./index.php?op=info&infoid=<?php echo $DataInfo->id_info;?>"><?php echo $DataInfo->judul_info;?></a>
</span>
</span>
</div><?php
}
$no++;
}?>
</div>
</div>
</div>
</div>
</div><?php
}else{?>
<div class="alert alert-danger">
<button type="button" class="close" data-dismiss="alert">
<i class="ace-icon fa fa-times"></i>
</button>
<p>
<strong><i class="ace-icon fa fa-check"></i>Perhatian!</strong>
Belum ada data memo masuk untuk anda/Data memo tidak ditemukan. Terimakasih.
</p>
</div><?php
}
/* PAGINATION */
//hitung jumlah data
if(isset($_GET['keyword'])){
$jml_data = $CekInfo2->rowCount();
$link_order="&keyword=$_GET[keyword]";
}else{
/* $params = array(':disposisi_user' => $_SESSION['id_user']); */
$jlhdata = $this->model->selectprepare("info a join user c on a.pengirim_info=c.id_user", $field=null, $params=null, $where=null, "WHERE a.tujuan_info LIKE '%\"$_SESSION[id_user]\"%'");
$jml_data = $jlhdata->rowCount();
$link_order="";
}
//Jumlah halaman
$JmlHalaman = ceil($jml_data/$batas);
//Navigasi ke sebelumnya
if($pg > 1){
$link = $pg-1;
$prev = "index.php?op=info&halaman=$link$link_order";
$prev_disable = " ";
}else{
$prev = "#";
$prev_disable = "disabled";
}
//Navigasi ke selanjutnya
if($pg < $JmlHalaman){
$link = $pg + 1;
$next = "index.php?op=info&halaman=$link$link_order";
$next_disable = " ";
}else{
$next = "#";
$next_disable = "disabled";
}
if($batas < $jml_data){?>
<ul class="pager">
<li class="previous <?php echo $prev_disable;?>"><a href="<?php echo $prev;?>"><font color="black"><b>← Sebelumnya </font></b></a></li>
<li class="next <?php echo $next_disable;?>"><a href="<?php echo $next;?>"><font color="black"><b>Selanjutnya →</b></font></a></li>
</ul>
<span class="text-muted color"><font color="white">Halaman <?php echo $pg;?> dari <?php echo $JmlHalaman;?> (Total : <?php echo $jml_data;?> records)</font></span><?php
}
/* END PAGINATION */
}?>