function addNotification()
{
global $dbh, $action, $username, $activation, $installation, $password, $results, $wfield1, $wfield2, $wfield3, $wfield4, $id;
$verifySQL = "SELECT * FROM notifications WHERE username ='******'";
$message = "";
if (findCount($verifySQL) <= 0) {
$sql = "INSERT INTO notifications (\n `username` ,`activation`,`installation`, `password`, `results`, `wfield1`, `wfield2`, `wfield3`, `wfield4`,) " . "VALUES('{$username}', '{$activation}', '{$installation}', '{$password}'" . ",'{$results}', '{$wfield1}', '{$wfield2}', '{$wfield3}', '{$wfield4}'";
// echo $sql;
$db_result = $dbh->query($sql);
$response["success"] = 1;
$response["message"] = 'Notification sent successfully';
} else {
$response["success"] = 0;
$response["message"] = 'Notification already exists';
}
echo json_encode($response);
}
function addHomework()
{
global $dbh, $action, $username, $activation, $installation, $password, $subject, $studentclass, $description, $teacher, $assignedDate, $dueDate, $wfield1, $wfield2, $wfield3, $wfield4, $id;
$verifySQL = "SELECT * FROM homework WHERE username ='******'";
$message = "";
if (findCount($verifySQL) <= 0) {
$sql = "INSERT INTO homework (\n `username` ,`activation`,`installation`, `password`, `subject`, `studentclass`, `description`,`teacher`, `assignedDate`, `dueDate`, `wfield1`, `wfield2`, `wfield3`, `wfield4`) " . "VALUES('{$username}', '{$activation}', '{$installation}', '{$password}'" . ",'{$subject}', '{$studentclass}', '{$description}', '{$teacher}', '{$assignedDate}', '{$dueDate}', '{$wfield1}', '{$wfield2}', '{$wfield3}', '{$wfield4}' )";
// echo $sql;
$db_result = $dbh->query($sql);
$response["success"] = 1;
$response["message"] = 'Homework sent successfully';
} else {
$response["success"] = 0;
$response["message"] = 'Homework already exists';
}
echo json_encode($response);
}
$_SESSION['cus_id'] = $cus_id;
$_SESSION['sessid'] = session_id();
$sessid = session_id();
$log = findLog($cus_id, $ip, $sessid, $db);
//var_dump($_SESSION);
//查找日志是否存在
if (empty($log)) {
//如果不存在添加
$dataLog = array('cus_id' => $cus_id, 'ip' => $ip, 'expires' => $expires, 'sessid' => $sessid, 'platform' => $platform);
$insertLog = insertLog($dataLog, $db);
} else {
$dataLog = array('expires' => $expires, 'ip' => $ip, 'sessid' => $sessid);
$updateLog = updateLog($cus_id, $dataLog, $db);
}
//查看是否存在统计记录
$counter = findCount($cus_id, $db);
if (empty($counter)) {
//不存在，添加
$dataCount = array('cus_id' => $cus_id, 'record_date' => $date);
$insertCount = insertCount($dataCount, $db);
}
if (isset($insertLog)) {
$updateCount = updateCount($cus_id, $platform, $counter, $db);
echo 'update statis succeed';
} else {
echo 'not need update statis';
}
/**
* 查找日志
* @param type $cus_id
* @param type $db