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/truyentranh/code/manager/language/ |
<?php
$CORE->page_title = 'Language';
$type = isset($CORE->input['type']) ? $CORE->input['type'] : '';
switch ($type){
case 'delete':
$html_block = 'delete';
if(isset($CORE->input['language_id'])) {
$language_id = intval($CORE->input['language_id']);
$DB->query("DELETE FROM tb_language WHERE language_id='$language_id' ");
}
if(isset($CORE->input['list_id'])){
$list_id = $CORE->input['list_id'];
if(strpos($list_id,'@')===false){
$language_id = intval($CORE->input['list_id']);
$DB->query("DELETE FROM tb_language WHERE language_id='$language_id' ");
}else{
$arr_id = explode('@',$list_id);
foreach ($arr_id as $val){
$language_id = intval($val);
$DB->query("DELETE FROM tb_language WHERE language_id='$language_id' ");
}
}
}
unset($list_id);
$print->refresh('index.php?act=manager&code=language','Deleted record!',2);
break;
case 'post' :
$language_id = isset($CORE->input['language_id']) ? intval($CORE->input['language_id']) : 0;
$row_check = $DB->get_colum_tb('tb_language');
if($language_id>0) {
$row_check = $DB->fetch_row($DB->query("SELECT * FROM `tb_language` WHERE `language_id` = '$language_id' "));
}
$html_block = 'post';
if(isset($CORE->input['submitbt'])){
$f = $CORE->input['f'];
if($f['language_key']!='') {
if(intval($f['language_id'])>0){
$row_check_language = $DB->fetch_row($DB->query("SELECT * FROM tb_language WHERE language_key='".$f['language_key']."' AND language_id<>'".$f['language_id']."' "));
if($row_check_language){
$print->refresh('index.php?act=manager&code=language&type=post&'.http_build_query($f),'!Error: Language key is exist, please create another key language.',3);
}
$DB->query("UPDATE tb_language SET language_key='".$f['language_key']."' ,language_vi='".$f['language_vi']."' , language_en='".$f['language_en']."' WHERE language_id='".intval($f['language_id'])."'");
$v_language_id = intval($f['language_id']);
}else {
$row_check_language = $DB->fetch_row($DB->query("SELECT * FROM tb_language WHERE language_key='".$f['language_key']."' "));
if($row_check_language){
$print->refresh('index.php?act=manager&code=language&type=post&'.http_build_query($f),'!Error: Language key is exist, please create another key language.',5);
}
$DB->query("INSERT INTO `tb_language` ( `language_key`, `language_vi`, `language_en`) VALUES ( '".$f['language_key']."', '".$f['language_vi']."', '".$f['language_en']."');");
$v_language_id = $DB->insert_id();
}
$print->refresh('index.php?act=manager&code=language');
}
}
break;
default:
$keyword = isset($CORE->input['fkeyword']) ? $CORE->input['fkeyword'] : '';
$where = " WHERE language_key<>'' ";
if($keyword!='')
{
$where .= " AND (language_vi LIKE '%".$keyword."%' or language_en LIKE '%".$keyword."%' or language_key LIKE '%".$keyword."%' ) ";
}
$pageNum = isset($_GET['pageNum']) ? intval($_GET['pageNum']) : 1;
$pageSize = 20;
$from = (($pageNum * $pageSize) - $pageSize);
$t = $DB->fetch_row($DB->query("SELECT count(*) as total FROM tb_language ".$where));
$total = $t['total'];
$totalPage = ceil($total / $pageSize);
$query = $DB->query("SELECT * FROM tb_language ".$where." ORDER BY `language_vi` ASC LIMIT $from, $pageSize");
$txt_list_language = '';
while($row = $DB->fetch_row($query))
{
$txt_list_language .= '<tr>
<td>
<input name="txt_id" type="checkbox" id="lang_checkbox_'.$row['language_id'].'" class="filled-in" value="'.$row['language_id'].'" />
<label for="lang_checkbox_'.$row['language_id'].'"></label>
</td>
<td>'.$row['language_key'].'</td>
<td>'.html_entity_decode($row['language_vi']).'</td>
<td>'.html_entity_decode($row['language_en']).'</td>
<td>
<a href="?act=manager&code=language&type=post&language_id='.$row['language_id'].'" class="btn btn-inverse-primary">Edit</a>
<a href="?act=manager&code=language&type=delete&language_id='.$row['language_id'].'" class="btn btn-inverse-danger" onclick="return confirm(\'Are you sure want to delete?\');">Delete</a>
</td>
</tr>';
}
$nav = $print->Pagination($totalPage,$pageNum,'menu','index.php?act=manager&code=language&fkeyword='.$keyword);
$html_block = 'list';
break;
}
?>
<?php
include ROOT_PATH . 'include/block/header_admin.php';
?>
<div class="container-fluid page-body-wrapper mt-2">
<div class="main-panel">
<div class="content-wrapper">
<div class="card">
<div class="card-body">
<nav aria-label="breadcrumb">
<ol class="breadcrumb breadcrumb-custom bg-inverse-info">
<li class="breadcrumb-item"><a href="index.php">Home</a></li>
<li class="breadcrumb-item"><a href="?act=manager&code=language"><?php echo $CORE->page_title;?></a></li>
<li class="breadcrumb-item active" aria-current="page"><span>Language management</span></li>
</ol>
</nav>
<div class="row">
<?php
if($html_block=='list'){
?>
<div class="col-12" style="margin-bottom: 10px;">
<div class="row">
<div class="col-md-8">
<a href="?act=manager&code=language&type=post" class="btn waves-effect waves-light btn-primary"><i class="fa fa-plus"></i> Add New
</a>
<a href="javascript:void(0);" id="bt_act_delete" class="btn waves-effect waves-light btn-danger"><i class="fa fa-window-close"></i>
Delete
</a>
</div>
<div class="col-md-4">
<input id="demo-input-search2" type="text" placeholder="Search" autocomplete="off" class="module_title_search form-control" value="<?php echo $keyword;?>">
<input type="hidden" value="act=manager&code=language" id="txt_code_search" class="btn btn-primary ml-3">
</div>
</div>
</div>
<div class="table-responsive">
<form action="index.php?act=manager&code=language" method="POST" target="_blank" id="form_action">
<input type="hidden" id="list_id" value="">
<table class="table table-striped">
<thead>
<tr>
<th><input type="checkbox" class="filled-in chk-col-amber" id="check_all"><label for="check_all"></label></th>
<th>Lang key</th>
<th>Lang Vi</th>
<th>Lang En</th>
<th>#</th>
</tr>
</thead>
<tbody>
<?php echo $txt_list_language;?>
</tbody>
</table>
</form>
<nav>
<ul class="pagination d-flex justify-content-center pagination-success">
<?php echo $nav;?>
</ul>
</nav>
</div>
<?php } ?>
<?php
if($html_block=='post'){
?>
<div class="col-12">
<h4 class="card-title">Post language</h4>
<form action="?act=manager&code=language&type=post" method="post">
<input type="hidden" value="<?php echo $row_check['language_id'];?>" name="f[language_id]">
<div class="form-body col-12">
<div class="row">
<div class="col-md-4">
<div class="form-group">
<label class="control-label">Language key</label>
<input type="text" class="form-control" placeholder="" name="f[language_key]" value="<?php echo $row_check['language_key'];?>" required>
</div>
</div>
<div class="col-md-4">
<div class="form-group">
<label class="control-label">Language vietnam</label>
<input type="text" class="form-control" name="f[language_vi]" value="<?php echo $row_check['language_vi'];?>" required>
</div>
</div>
<div class="col-md-4">
<div class="form-group">
<label class="control-label">Language english</label>
<input type="text" class="form-control" name="f[language_en]" value="<?php echo $row_check['language_en'];?>" required>
</div>
</div>
</div>
</div>
<div class="form-actions">
<button type="submit" class="btn btn-success" name="submitbt"> <i class="fa fa-check"></i> Save</button>
<button type="button" class="btn btn-inverse" onclick="location.href='index.php?act=manager&code=language'">Cancel</button>
</div>
</form>
</div>
<?php } ?>
</div>
</div>
</div>
</div>
</div>
</div>
<?php
include ROOT_PATH . 'include/block/footer_admin.php';
?>