view_tembusan_internal_detail.php
4.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
<?php
$id_sk = htmlspecialchars($purifier->purify(trim($_GET['skidinternal'])), ENT_QUOTES);
$field = array("a.id_user as userDis","a.*");
$params = array(':id_sk' => $id_sk);
$userLike = "%".$_SESSION['nip']."%";
//$CekTembusan = $this->model->selectprepare("surat_keluar_internal a", $field, $params, "a.id_sk=:id_sk", "AND a.tembusan LIKE '".$userLike."'");
$CekTembusan = $this->model->selectprepare("surat_keluar_internal a INNER JOIN user b on a.id_user=b.id_user", $field=null, $params, "a.id_sk=:id_sk", "ORDER BY tgl_agenda DESC");
if($CekTembusan->rowCount() >= 1){
$dataTembusan = $CekTembusan->fetch(PDO::FETCH_OBJ);
$tgl = substr($dataTembusan->tgl_agenda,0,10);
$CekUser = $this->model->selectprepare("user", $field=null, $params=null, $where=null, "WHERE id_user = '$dataTembusan->userDis'");
$DataUser = $CekUser->fetch(PDO::FETCH_OBJ);
$params = array(
':id_user' => $_SESSION['id_user'],
':id_sk' => $dataTembusan->id_sk,
':kode' => 'CCI');
$lihat_sk = $this->model->selectprepare("surat_read", $field=null, $params, "id_sk=:id_sk AND id_user=:id_user AND kode=:kode");
if($lihat_sk->rowCount() <= 0){
$field = array('id_user' => $_SESSION['id_user'], 'id_sk' => $dataTembusan->id_sk, 'kode' => 'CCI');
$insert2 = $this->model->insertprepare("surat_read", $field, $params);
}?>
<div class="widget-box">
<div class="message-header clearfix">
<div class="pull-left" style="padding:0 9px;">
<span class="blue bigger-125"> Tembusan surat dari: <?php echo $dataTembusan->pembuat;?>, Ref: <?php echo $this->model->noref($dataTembusan->id_sk, "internal");?></span>
<div class="space-4"></div>
<img class="middle" alt="<?php echo $DataUser->nama;?>" src="assets/images/avatars/<?php echo $DataUser->picture;?>" width="32" />
<a href="#" class="sender"><?php echo $DataUser->nama;?></a>
<i class="ace-icon fa fa-clock-o bigger-110 orange middle"></i>
<span class="time grey"><?php echo tgl_indo($tgl);?>, <?php echo substr($dataTembusan->tgl,-9,-3);?> WIB</span>
</div>
</div>
<div class="hr hr-double"></div>
<div class="message-body">
<p>
Tgl/No agenda: <br/><b><?php echo tgl_indo($dataTembusan->tgl_agenda);?> | <?php echo $this->model->noref($dataTembusan->id_sk, "internal");?></b>
</p>
<p>
Dari: <br/><b><?php echo $dataTembusan->pembuat;?></b>
</p>
<p>
Perihal: <br/><b><?php echo $dataTembusan->perihal;?></b>
</p>
<p>
Tanggal Tembusan : <br/><b><?php echo tgl_indo($tgl);?></b>
</p>
<?php if($dataTembusan->file != ""){?>
<p>
<a href="./berkas/<?php echo $dataTembusan->file;?>" target="_blank"><button class="btn btn-success btn-minier ">Lihat File Surat<i class="ace-icon fa fa-book align-top bigger-125 icon-on-right"></i></button></a>
</p>
<?php } ?>
<p>
<a href="./index.php?op=sk_internal&skid=<?php echo $dataTembusan->id_sk;?>" target="_blank"><button class="btn btn-primary btn-minier ">Detail Surat <i class="ace-icon fa fa-external-link align-center bigger-100 icon-on-right"></i></button></a>
</p>
<?php
$field = array(
'info.*',
'(SELECT nama FROM user WHERE user.id_user = info.pengirim_info) as nama_user'
);
$params = array(':tujuan_info' => $dataTembusan->id_sk, ':status_info' => 'surat_keluar_internal');
$StatSurat = $this->model->selectprepare("info", $field, $params, "tujuan_info=:tujuan_info AND status_info=:status_info", "ORDER BY id_info DESC");
if($StatSurat->rowCount() >= 1){?>
<div class="widget-body">
<div class="widget-main padding-0">
<div id="profile-feed-1" class="profile-feed">
</div>
</div>
</div><?php
$no=1;
while($dataStatSurat= $StatSurat->fetch(PDO::FETCH_OBJ)){?>
<div class="profile-activity clearfix">
<div>
<a class="user" href="#"><?php echo $dataStatSurat->nama_user; ?></a>
: <span class="text-primary">
<?php echo $dataStatSurat->judul_info."<br>".$dataStatSurat->ket_info; ?>
</span>
<div class="time">
<?php echo tgl_indo1($dataStatSurat->tgl_info);?>, <?php echo substr($dataStatSurat->tgl_info,-9,-3);?> WIB
</div>
</div><?php
if($dataStatSurat->id_info == $_SESSION['id_user']){?>
<div class="tools action-buttons">
<a href="./index.php?op=add_memo&infoid=<?php echo $dataStatSurat->id_info;?>" class="blue">
<i class="ace-icon fa fa-pencil bigger-125"></i>
</a>
<a href="./index.php?op=add_memo&infoid=<?php echo $dataStatSurat->id_info;?>&act=del" class="red">
<i class="ace-icon fa fa-times bigger-125"></i>
</a>
</div><?php
}?>
</div>
<?php
$no++;
}
}?>
</div>
</div><?php
}else{
echo "Belum ada data";
}
?>