{
$sql = 'SELECT * FROM `h1_confirm` WHERE `pc_confirm` = 1 AND `meter_serial` = "' . $serial . '" AND `month_confirm` = "' . $month . '"';
$result = mysql_query($sql) or die('0');
$row = 0;
while ($rows = mysql_fetch_array($result)) {
$row = $rows['ID'];
}
if ($row == null || $row == '' || $row == 0) {
$returnvalue = 0;
} else {
$returnvalue = 1;
}
return $returnvalue;
}
// error codes - http://www.w3schools.com/tags/ref_httpmessages.asp
if (record_exist($serial, $month)) {
die('409');
}
// xung đột - pc đã xác nhận
$sql = 'SELECT `dauky`, `cuoiky` FROM `h1_confirm`
WHERE `meter_serial`="' . $serial . '" AND `month_confirm` ="' . $month . '" ORDER BY `edit_count` DESC LIMIT 0,1';
$result = mysql_query($sql) or die('0');
$confirmdata = array();
if (mysql_num_rows($result) > 0) {
while ($row = mysql_fetch_array($result)) {
$confirmdata = array('dauky' => $row['dauky'], 'cuoiky' => $row['cuoiky']);
}
}
//echo $confirmdata['dauky'];
if (isset($confirmdata['dauky'])) {
if ($confirmdata['dauky'] != null && $confirmdata['dauky'] != '') {
}
function record_exist($serial, $month, $kdstatus)
{
$sql = 'SELECT * FROM `h1_confirm`
WHERE `meter_serial` = "' . $serial . '" AND `month_confirm` = "' . $month . '" AND `type` = ' . $kdstatus;
$result = mysql_query($sql) or die('500');
$row = 0;
while ($rows = mysql_fetch_array($result)) {
$row = $rows['ID'];
}
if ($row == null || $row == '') {
$returnvalue = 0;
} else {
$returnvalue = 1;
}
return $returnvalue;
}
if (record_exist($serial, $month, $kdstatus)) {
die('409');
}
$sql = 'INSERT INTO `h1_confirm`(`meter_serial`, `month_confirm`, `dauky`, `cuoiky`, `type`, `id_user_confirm`,
`fullname_sub_confirm`,`date_confirm`)
VALUES ("' . $serial . '","' . $month . '","' . $dauky . '","' . $cuoiky . '",' . $kdstatus . ',' . $userid . ',"' . $fullname . '","' . $timenow . '")';
$result = mysql_query($sql) or die('500');
echo '200';
userlogs($userid, $fullname, 'xác nhận số liệu');
CLOSE_DB();
unset($sql, $result, $rs);
?>
