}
if ($per_page == 1 and $page != 1) {
$pre_page = $page - 1;
echo '<form name="page" method="post" action="' . $_SERVER['PHP_SELF'] . '">', '<input type="hidden" name="page" value="' . $pre_page . '">', '<script language="JavaScript">document.page.submit();</script></form>';
}
echo '<script type="text/javascript">window.setTimeout(window.location="' . $_SERVER['PHP_SELF'] . '",0);</script>';
}
//ทำการแก้ไขตารางสินค้า
if (isset($_POST['submit_edit'])) {
if ($_FILES['new_Pic_goods']['name'] != '') {
upLoad('new_Pic_goods');
$axUpdate = array('Name_goods' => "{$_POST['new_Name_goods']}", 'Date_goods' => "{$_POST['new_Date_goods']}", 'Type_goods' => "{$_POST['new_Type_goods']}", 'Price_goods' => "{$_POST['new_Price_goods']}", 'Stock_goods' => "{$_POST['new_Stock_goods']}", 'Discount_goods' => "{$_POST['new_Discount_goods']}", 'DiscountDateStart_goods' => "{$_POST['new_DiscountDateStart_goods']}", 'DiscountTimeStart_goods' => "{$_POST['new_DiscountTimeStart_goods']}", 'DiscountDateEnd_goods' => "{$_POST['new_DiscountDateEnd_goods']}", 'DiscountTimeEnd_goods' => "{$_POST['new_DiscountTimeEnd_goods']}", 'Pic_goods' => "./images/" . basename($_FILES["new_Pic_goods"]["name"]), 'Add_goods' => "{$_POST['new_Add_goods']}");
} else {
$axUpdate = array('Name_goods' => "{$_POST['new_Name_goods']}", 'Date_goods' => "{$_POST['new_Date_goods']}", 'Type_goods' => "{$_POST['new_Type_goods']}", 'Price_goods' => "{$_POST['new_Price_goods']}", 'Stock_goods' => "{$_POST['new_Stock_goods']}", 'Discount_goods' => "{$_POST['new_Discount_goods']}", 'DiscountDateStart_goods' => "{$_POST['new_DiscountDateStart_goods']}", 'DiscountTimeStart_goods' => "{$_POST['new_DiscountTimeStart_goods']}", 'DiscountDateEnd_goods' => "{$_POST['new_DiscountDateEnd_goods']}", 'DiscountTimeEnd_goods' => "{$_POST['new_DiscountTimeEnd_goods']}", 'Pic_goods' => "{$_POST['old_Pic_goods']}", 'Add_goods' => "{$_POST['new_Add_goods']}");
}
$sEditSql = buildSQLUpdate('goods', 'ID_goods', "{$_POST['ID_goods']}", $axUpdate);
if ($mysqli->query($sEditSql)) {
echo "";
}
}
$maxID = 1;
if ($result = $mysqli->query('SELECT * FROM `' . DB_NAME . '`.`goods`')) {
for ($igoods = 0; $igoods < $result->num_rows; $igoods++) {
$row = $result->fetch_assoc();
if ($maxID < $row['ID_goods']) {
$maxID = $row['ID_goods'];
}
}
}
?>
<?php
require './config.php';
require './con_db.php';
require './general.php';
if (isset($_POST) and !isset($_SESSION['login'])) {
$_SESSION['login']['status'] = true;
$_SESSION['login']['type'] = 'facebook';
$_SESSION['login']['table'] = 'user';
$_SESSION['login']['id'] = $_POST['fbpost']['id'];
$iID = $_SESSION['login']['id'];
$result = $mysqli->query("SELECT * FROM user WHERE Type_user = '******' AND ID_user = {$iID} ");
$row = $result->fetch_assoc();
if (empty($row)) {
$axInsert = array('ID_user' => $_SESSION['login']['id'], 'Name_user' => $_POST['fbpost']['name'], 'Type_user' => 'facebook');
$sInsertSql = buildSQLInsert('user', $axInsert);
if ($mysqli->query($sInsertSql)) {
echo "1";
}
} else {
$axUpdate = array('Name_user' => $_POST['fbpost']['name']);
$sEditSql = buildSQLUpdate('user', 'ID_user', "{$iID}", $axUpdate);
if ($mysqli->query($sEditSql)) {
echo "1";
}
}
}
$rate = $mysqli->query('SELECT * FROM `' . DB_NAME . '`.`payrate`');
$rate = $rate->fetch_assoc();
//inserting a new steam goods or updating.
$iID = $jData['ID_gsteam'];
$result = $mysqli->query("SELECT * FROM gsteam WHERE ID_gsteam = {$iID} ");
$row = $result->fetch_assoc();
//debug jData do not matched with database.
$sqlData = $jData;
if (isset($sqlData['apps'])) {
unset($sqlData['apps']);
}
if (empty($row)) {
$sInsertSql = buildSQLInsert('gsteam', $sqlData);
$mysqli->query($sInsertSql);
} else {
$sEditSql = buildSQLUpdate('gsteam', 'ID_gsteam', "{$iID}", $sqlData);
$mysqli->query($sEditSql);
}
?>
<div class="container">
<div class="row">
<div class="col-md-4">
<?php
echo '<img src="' . $jData['Pic_gsteam'] . '">';
?>
<p>
<?php
echo "ประเภทสินค้า : " . $jData['Type_gsteam'];
?>
</p>
//ทำการลบากฐานข้อมูล
if (isset($_POST['submit_del'])) {
$sDelSql = buildSQLDelete('key', 'ID_key', "{$_POST['ID_key']}");
if ($mysqli->query($sDelSql)) {
echo "";
}
if ($per_page == 1 and $page != 1) {
$pre_page = $page - 1;
echo '<form name="page" method="post" action="' . $_SERVER['PHP_SELF'] . '">', '<input type="hidden" name="page" value="' . $pre_page . '">', '<script language="JavaScript">document.page.submit();</script></form>';
}
echo '<script type="text/javascript">window.setTimeout(window.location="' . $_SERVER['PHP_SELF'] . '",0);</script>';
}
//ทำการแก้ไขตาราง
if (isset($_POST['submit_edit'])) {
$axUpdate = array('Code_key' => "{$_POST['new_Code_key']}", 'Status_key' => "{$_POST['new_Status_key']}", 'ID_goods' => "{$_POST['new_ID_goods']}");
$sEditSql = buildSQLUpdate('key', 'ID_key', "{$_POST['ID_key']}", $axUpdate);
if ($mysqli->query($sEditSql)) {
echo "";
}
}
?>
<table class="table-hover" border="0" cellspacing="0" cellpadding="5">
<tr style="background : grey; color: white;">
<col width="150">
<col width="200">
<col width="150">
<col width="100">
<th><a href='<?php
echo "{$_SERVER['PHP_SELF']}" . '?ORDERBY_key=ID_key';
<a href=""><span class="glyphicon glyphicon-briefcase"></span> Register</a>
</li>
</ul>
</li>
</ul>
</div>
</div>
</nav>
<div class="container" style="margin-top: 100px; ">
<?php
if (isset($_POST['submit_edit'])) {
$axUpdate = array('Bank_payrate' => "{$_POST['Bank_payrate']}", 'True_payrate' => "{$_POST['True_payrate']}");
$sEditSql = buildSQLUpdate('payrate', 'ID_payrate', 1, $axUpdate);
if ($mysqli->query($sEditSql)) {
echo '<span style="color : green;">ทำการอัพเดทอัตราราคาเรียบร้อยแล้ว</span>';
}
?>
<script type="text/javascript">window.setTimeout('window.location="<?php
echo $_SERVER['PHP_SELF'];
?>
"; ',1000);</script>
<?php
}
echo '<form name="page" method="post" action="' . $_SERVER['PHP_SELF'] . '">';
if ($result = $mysqli->query('SELECT * FROM `' . DB_NAME . '`.`payrate`')) {
$row = $result->fetch_assoc();
echo '<label>อัตราโอน (เช่น 0.95)</label>
<input class="form-control" min="0"step="0.01" type="number" name="Bank_payrate" value=' . $row['Bank_payrate'] . '><br>';
