Server : Apache/2.4.6 (CentOS) OpenSSL/1.0.2k-fips PHP/7.4.20 System : Linux st2.domain.com 3.10.0-1127.10.1.el7.x86_64 #1 SMP Wed Jun 3 14:28:03 UTC 2020 x86_64 User : apache ( 48) PHP Version : 7.4.20 Disable Function : NONE Directory : /var/www/html/netphim/code/admin/emoji/ |
<?php
$txt_op_cat = '';
$q_cat = $DB->query("SELECT * FROM tb_emoji_cat ORDER BY emoji_cat_pos");
while($r_cat = $DB->fetch_row($q_cat)){
$txt_op_cat .= '<option value="'.$r_cat['emoji_cat_id'].'">'.$r_cat['emoji_cat_name'].'</option>';
}
$s = array();
$param_search = '';
$where = ' WHERE 1 AND emoji_id>0 ';
if(isset($CORE->input['s'])){
$s = $CORE->input['s'];
foreach ($s as $key=>$val){
if($val!='') {
if($key=='keyword'){
$where .= " AND (emoji_id LIKE '%".$val."%' OR emoji_name LIKE '%".$val."%' OR emoji_fname LIKE '%".$val."%') ";
}
if($key=='emoji_cat_id'){
$where .= " AND emoji_cat_id='".$val."' ";
}
$param_search .= 's['.$key.']='.trim($val).'&';
}
}
}
$pageNum = isset($_GET['pageNum']) ? intval($_GET['pageNum']) : 1;
$pageSize = 50;
$from = (($pageNum * $pageSize) - $pageSize);
$t = $DB->fetch_row($DB->query("SELECT count(*) as total FROM tb_emoji ".$where));
$total = $t['total'];
$totalPage = ceil($total / $pageSize);
$query = $DB->query("SELECT * FROM tb_emoji ".$where." ORDER BY emoji_pos ASC LIMIT $from, $pageSize");
$txt_list_emoji = '';
$stt = 1;
while($row = $DB->fetch_row($query)){
$txt_list_emoji .= '<tr id="tr_emoji_'.$row['emoji_id'].'"><td><input type="text" class="form-control" value="'.$row['emoji_pos'].'" name="txt_pos['.$row['emoji_id'].'][]" style="width:100px;"></td><td>'.$row['emoji_name'].'</td><td>'.$row['emoji_cat_name'].'</td><td><img src="'.$row['emoji_img'].'" style="width: 50px;"></td><td>[<a href="javascript:void(0);" onclick="open_popup(\'?act=admin&code=emoji&type=post&emoji_id='.$row['emoji_id'].'\',\'Edit\')">Edit</a>] [<a href="javascript:void(0);" data-id="'.$row['emoji_id'].'" class="delete_emoji">Delete</a>]</td></tr>';
$stt++;
}
$nav = $print->Pagination($totalPage,$pageNum,'menu','?act=admin&code=emoji&type=list&'.$param_search);
$type2 = isset($CORE->input['type2']) ? $CORE->input['type2'] : '';
if($type2=='update_pos'){
if(isset($CORE->input['txt_pos'])) {
$pos = $CORE->input['txt_pos'];
foreach ($pos as $key=>$val){
$DB->query("UPDATE tb_emoji SET emoji_pos = '".$val[0]."' WHERE emoji_id='$key' ");
}
unset($pos);
}
$print->refresh('?act=admin&code=emoji');
}
?>