Repository navigation
Expand file tree
/
Copy pathicms-function.php
More file actions
128 lines (101 loc) · 3.58 KB
/
Copy pathicms-function.php
File metadata and controls
128 lines (101 loc) · 3.58 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
<?php /// Global Function Controller
/// Get app theme directory (/home/ieu.link/app-theme/myapp)
function app_theme_dir() { /// Path direktori tema yang dipakai
return APP_PATH.'/app-theme/'.APP_THEME;
}
/// Get app theme url (https://ieu.link/app-theme/myapp)
function app_theme_url() { /// Path direktori tema yang dipakai
return app_url().'/app-theme/'.APP_THEME;
}
/// Get main app directory (/home/ieu.link/)
function app_dir() { /// Path direktori tema yang dipakai
return APP_PATH;
}
/// Get main app url (https://ieu.link)
function app_url() { /// Path direktori tema yang dipakai
global $urlhandler;
return str_ireplace($urlhandler, '', (isset($_SERVER['HTTPS']) && $_SERVER['HTTPS'] === 'on' ? "https" : "http") . "://".$_SERVER["HTTP_HOST"].(rtrim($_SERVER["REQUEST_URI"],'/')));
}
/// Get app theme directory (/home/ieu.link/app-module)
function app_module_dir() { /// Path direktori tema yang dipakai
return APP_PATH.'/app-module';
}
// Remove folders and files
function app_remove_file($dir) {
if (is_dir($dir)) {
$files = scandir($dir);
foreach ($files as $file){
if ($file != "." && $file != "..") app_remove_file("$dir/$file");
rmdir($dir);
}
}
else if (file_exists($dir)) unlink($dir);
}
// Copy folders and files
function app_copy_file($src, $dst) {
if (file_exists ( $dst ))
app_remove_file ( $dst );
if (is_dir ( $src )) {
mkdir ( $dst );
$files = scandir ( $src );
foreach ( $files as $file )
if ($file != "." && $file != "..")
app_copy_file ( "$src/$file", "$dst/$file" );
} else if (file_exists ( $src ))
copy ( $src, $dst );
}
/// Connect db
function app_db_connect($sn=ICMS_DB_HOST,$un=ICMS_DB_USER,$pw=ICMS_DB_USER_PASS,$dn=ICMS_DB_NAME){
$output = array();
$output['success'] = 0;
$conn = new mysqli($sn, $un, $pw, $dn);
if ($conn->connect_error) {
error_log("Koneksi gagal terjadi pada ".date("Y-m-d H:i:s",strtotime("now")).", dikarenakan :".$conn->connect_error);
}else{
$output['conn'] = $conn;
$output['success'] = 1;
}
return $output;
}
/// Do Query
function app_db_query($conn,$sql){
return $conn->query($sql);
}
/// Select data in table
function app_db_select( $table_where, $key_where=[], $isi_where=[]){
global $icms_db_conn;
$output = array();
$output['success'] = 0;
if ( ! empty( $table_where ) ){
$table_where_txt = "`" . mysqli_real_escape_string( $icms_db_conn['conn'], $table_where) . "`";
/// Filter Data
foreach ($isi_where as $iwhere => $ihere) {
$isi_where[ $iwhere ] = mysqli_real_escape_string( $icms_db_conn['conn'], $ihere);
}
foreach ($key_where as $kwhere => $where) {
$key_where[ $kwhere ] = mysqli_real_escape_string( $icms_db_conn['conn'], $where);
}
$key_where_txt = ''; /// Membuat query awal
foreach ($key_where as $kwhere => $where) {
if ( empty( $key_where_txt ) ){ /// Set WHERE pada query
$key_where_txt = 'WHERE ';
}
/// Set masing-masing kolom
$key_where_txt = $key_where_txt . "`" . $where . "`='" . $isi_where[ $kwhere ] . "'";
if ( $kwhere < ( count( $key_where ) - 1 ) ){ /// Menambahkan koma pada setiap kolom
$key_where_txt = $key_where_txt . ', ';
}
}
$query = "SELECT * FROM " . $table_where_txt . $key_where_txt;
$hasil = app_db_query( $icms_db_conn['conn'], $query);
if ((!empty($hasil->num_rows)) && ($hasil->num_rows > 0)) {
while($row = $hasil->fetch_assoc()) {
$output['result'][] = $row;
}
$output['success'] = 1;
}else{
$output['result'] = [];
}
}
return $output;
}