view_surat_digital_setting.php
6.88 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
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
<?php
$userID = $_SESSION['id_user'];
if ($_SERVER["REQUEST_METHOD"] == "POST"){
$params = array(':id' => $_GET['GetId'], ':userid' => $userID);
$surat_digital = $this->model->selectprepare("setting_surat_digital", $field=null, $params, "id=:id AND id_user=:userid");
$id_setting = htmlspecialchars($purifier->purify(trim($_POST['id_setting'])), ENT_QUOTES);
$layout = $_POST['layout'];
$field = array(
'idkop' => $_GET['GetId'],
'id_user' => $userID,
'layout' => $layout
);
if($surat_digital->rowCount() >= 1){
//$dataIdKopSurat = $surat_digital->fetch(PDO::FETCH_OBJ);
$params1 = array(':id' => $id_setting);
$perintah = $this->model->updateprepare("setting_surat_digital", $field, $params1, "id=:id");
} else {
$params = array(
':idkop' => $_GET['GetId'],
':id_user' => $userID,
':layout' => $layout
);
$perintah = $this->model->insertidprepare("setting_surat_digital", $field, $params);
}
if($perintah){
echo "<script type=\"text/javascript\">alert('Data Berhasil diperbaharui...!!');window.location.href=\"./index.php?op=surat_digital&setting&GetId=".$_GET['GetId']."\";</script>";
}else{
die("<script>alert('Data menyimpan ke Database, Silahkan Coba Kembali..!!');window.history.go(-1);</script>");
}
} else { ?>
<div class="widget-box">
<?php
$VarDinamis = "";
$VarSetting = $this->model->selectprepare("kop_variabel", $field=null, $params=null, $where=null);
while($dataVarSetting = $VarSetting->fetch(PDO::FETCH_OBJ)){
$dinamasiVar = explode(',',$dataVarSetting->id_kop);
$params = array(':id' => $_GET['GetId'], ':userid' => $userID);
$surat_digital = $this->model->selectprepare("setting_surat_digital", $field=null, $params, "id=:id AND id_user=:userid");
$kop_setting = $this->model->selectprepare("kop_setting", $field=null, $params=null, $where=null, "where idkop = '".$_GET['GetId']."' ");
if($surat_digital->rowCount() >= 1){
$dataIdKopSurat = $surat_digital->fetch(PDO::FETCH_OBJ);
} else {
$dataIdKopSurat = $kop_setting->fetch(PDO::FETCH_OBJ);
}
if($dataIdKopSurat->idkop == 4){
$kop = 1;
}else{
$kop = 3;
}
if($dinamasiVar[0] == $kop OR $dinamasiVar[1] == $kop OR $dinamasiVar[2] == $kop){
$VarDinamis .= $dataVarSetting->variabel .' | '.$dataVarSetting->ket .'<br/>';
}
}
?>
<div class="widget-header">
<h4 class="widget-title">Setting Surat Digital <?php
$params = array(':id' => $_GET['GetId']);
$KopEmail = $this->model->selectprepare("email_setting", $field=null, $params, "id=:id");
if($KopEmail->rowCount() >= 1){
$dataKopEmail = $KopEmail->fetch(PDO::FETCH_OBJ);
echo $dataKopEmail->ket;
}?>
</h4>
<div class="widget-toolbar">
<a href="#" data-action="collapse">
<i class="ace-icon fa fa-chevron-up"></i>
</a>
<a href="#" data-action="close">
<i class="ace-icon fa fa-times"></i>
</a>
</div>
</div>
<div class="widget-body">
<div class="widget-main"><?php?>
<script src="./tinymce/tinymce.min.js"></script>
<script>
tinymce.init({
selector: 'textarea',
height: 200,
theme: 'modern',
plugins: [
'advlist autolink lists link image charmap print preview hr anchor pagebreak',
'searchreplace wordcount visualblocks visualchars code fullscreen',
'insertdatetime media nonbreaking save table contextmenu directionality',
'emoticons template paste textcolor colorpicker textpattern imagetools codesample toc'
],
toolbar1: 'undo redo | insert | styleselect | bold italic | alignleft aligncenter alignright alignjustify | bullist numlist outdent indent | link image',
toolbar2: 'print preview media | forecolor backcolor emoticons | codesample',
image_advtab: true,
templates: [
{ title: 'Test template 1', content: 'Test 1' },
{ title: 'Test template 2', content: 'Test 2' }
]
});
</script>
<form class="form-horizontal" role="form" name="formku" method="GET">
<input type="hidden" name="op" value="surat_digital"/>
<input type="hidden" name="setting" value=""/>
<div class="form-group">
<label class="col-sm-2 control-label no-padding-right" for="form-field-mask-1">Pilih jenis surat</label>
<span class="help-button" data-rel="popover" data-trigger="hover" data-placement="left" data-content="Pilih kop email yang tersedia" title="Jenis kop email">?</span>
<div class="col-sm-5">
<select class="form-control" id="form-field-select-3" name="GetId" data-placeholder="Pilih surat..." onchange='this.form.submit()'>
<option value="">Pilih Surat</option>
<option value="4" <?php if(isset($_GET['GetId']) AND $_GET['GetId'] == '4'){echo "selected";} ?> >Surat Keluar</option>
<option value="5" <?php if(isset($_GET['GetId']) AND $_GET['GetId'] == '5'){echo "selected";} ?> >Surat Masuk</option>
</select>
</div>
</div>
</form><?php
if(isset($_GET['GetId']) AND $_GET['GetId'] != ''){
$params = array(':id' => $_GET['GetId'], ':userid' => $userID);
$surat_digital = $this->model->selectprepare("setting_surat_digital", $field=null, $params, "idkop=:id AND id_user=:userid");
$kop_setting = $this->model->selectprepare("kop_setting", $field=null, $params=null, $where=null, "where idkop = '".$_GET['GetId']."' ");
if($surat_digital->rowCount() >= 1){
$dataSurat = $surat_digital->fetch(PDO::FETCH_OBJ);
$idkop = $dataSurat->id;
} else {
$dataSurat = $kop_setting->fetch(PDO::FETCH_OBJ);
$idkop = $dataSurat->idkop;
}
?>
<form class="form-horizontal" role="form" method="POST" enctype="multipart/form-data" name="formku" action="<?php echo $_SESSION['url'];?>">
<h4>Format Surat Print</h4>
<input type="hidden" name="id_setting" value="<?php echo $idkop; ?>"/>
<div class="form-group">
<div class="col-sm-12">
<textarea class="form-control limited" name="layout"/><?php echo $dataSurat->layout;?></textarea>
</div>
</div>
<div class="form-group">
<label class="col-sm-2 control-label no-padding-right" for="form-field-mask-1"> Variabel dinamis yang tersedia*</label>
<div class="col-sm-6">
<?php echo $VarDinamis;?>
</div>
</div>
<div class="clearfix form-actions">
<div class="col-md-offset-3 col-md-9">
<div class="col-sm-2">
<button type="submit" class="btn btn-info" type="button">
<i class="ace-icon fa fa-check bigger-110"></i>
Submit
</button>
</div>
<div class="col-sm-2">
<button class="btn" type="reset">
<i class="ace-icon fa fa-undo bigger-110"></i>
Reset
</button>
</div>
</div>
</div>
</form><?php
//}
}?>
</div>
</div>
<div class="space-4"></div>
</div><?php
}?>