alert ('กรุณากรอก ".$value."');
history.back();
";
exit();
}
}
checknull($emailMember,"อีเมล์");
checknull($passwordMember,"รหัสผ่าน");
/////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
// Auto Update Class //
$dateStart = "2014-01-01";
$sql1 = "SELECT DISTINCT(idCustomer) FROM member WHERE idCustomer != ''";
$result1 = $mysqli->query($sql1);
while($row1 = $result1->fetch_array(MYSQLI_ASSOC) ){
$sql2 = "SELECT exportDate FROM qt_ivt WHERE exportDate != '0000-00-00' and idCustomer = '$row1[idCustomer]'";
$result2 = select($sql2);
$chkClass = numRows($sql2);
$row2 = $result2[0];
$diffDate = (strtotime($dateStart) - strtotime($row2['exportDate'])) / ( 60 * 60 * 24 ); // 1 day = 60*60*24
$diffDate = floor($diffDate);
if($chkClass == '1'){
if($diffDate < 365){ // Gold
$sqlUpdate = array(
"classMember"=>'2'
);
update("member",$sqlUpdate,"idCustomer="."'$row1[idCustomer]'");
}else{ // Silver
$sqlUpdate = array(
"classMember"=>'1'
);
update("member",$sqlUpdate,"idCustomer="."'$row1[idCustomer]'");
}
}else if($chkClass > '1'){
if($diffDate < 365){ // Platinum
$sqlUpdate = array(
"classMember"=>'3'
);
update("member",$sqlUpdate,"idCustomer="."'$row1[idCustomer]'");
}else{ // Gold
$sqlUpdate = array(
"classMember"=>'2'
);
update("member",$sqlUpdate,"idCustomer="."'$row1[idCustomer]'");
}
}else{
$sqlUpdate = array(
"classMember"=>'1'
);
update("member",$sqlUpdate,"idCustomer="."'$row1[idCustomer]'");
}
}
/////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
$sqlMember = "select idMember, nameMember, emailMember, idCustomer, classMember from member where emailMember = '$emailMember' and passwordMember = '$passwordMember' and classMember != '0'";
$resultMember = select($sqlMember);
$chkMember = numRows($sqlMember);
$rowMember = $resultMember[0];
$idMember = $rowMember['idMember'];
$nameMember = $rowMember['nameMember'];
$emailMember = $rowMember['emailMember'];
$idCustomer = $rowMember['idCustomer'];
$classMember = $rowMember['classMember'];
if($chkMember == null){
echo "";
exit();
}else{
$_SESSION["memberId"] = $idMember;
$_SESSION["memberName"] = $nameMember;
$_SESSION["memberEmail"] = $emailMember;
$_SESSION["memberCustomer"] = $idCustomer;
$_SESSION["memberClass"] = $classMember;
//$_SESSION["timeSession"] = time() + 300;
session_write_close();
$sqlLogApp = array(
"idLogApp"=>"",
"methodLogApp"=>"Login",
"idMethod"=>"0",
"eventLogApp"=>"-",
"dateLogApp"=>$dateTimeLogApp[0],
"timeLogApp"=>$dateTimeLogApp[1],
"idMember"=>$_SESSION[memberId]
);
insert("logapplication",$sqlLogApp);
if($classMember > '10'){
echo "";
exit();
}else{
echo "";
exit();
}
}
?>