$user = new userclass();
$loginname = htmlspecialchars($_POST['username'], ENT_QUOTES);
$password = $_POST['password'];
$passwordencoded = md5($password);
$adminuser_id = '';
$result = $user->GetLoginDetails($loginname, $passwordencoded);
$adminuser_id = $result['id'];
$adminusername = $result['name'];
//if username exists
if (!empty($adminuser_id)) {
//now set the session from here if needed
$_SESSION['ADMINUSERID'] = $adminuser_id;
$_SESSION['ADMINUSERNAME'] = $adminusername;
$_SESSION['start'] = time();
// taking now logged in time
$_SESSION['expire'] = $_SESSION['start'] + 18 * 60;
$user->createlog("User {$adminusername} Logged In");
updateloginlog($adminuser_id, $user, commonclass::GetIP());
echo 'yes';
} else {
$_SESSION['ADMINUSERID'] = '';
$_SESSION['ADMINUSERNAME'] = '';
echo "<span class=\"label label-important\">Username / Password incorrect !</span>";
}
function updateloginlog($adminuser_id, $user, $ip)
{
$loginTime = date('Y-m-d H:i:s');
$sql_update_login = "******";
$updatevalue = $user->internalDB->query($sql_update_login);
return $updatevalue;
}
!empty($data['excess_percent']) ? $datatoupdate['excess_percent'] = trim($data['excess_percent']) : '';
!empty($data['delivery_date']) ? $datatoupdate['delivery_date'] = commonclass::cleandate($data['delivery_date']) : '';
!empty($data['order_date']) ? $datatoupdate['order_date'] = commonclass::cleandate($data['order_date']) : '';
!empty($data['delivery_type']) ? $datatoupdate['delivery_type'] = $data['delivery_type'] : '';
$datatoupdate['modified_on'] = $today;
$candidatetable = $this->internalDB->update('d_order', $datatoupdate, "id=%i", $orderid);
$affectedrows = $this->internalDB->affectedRows();
if ($affectedrows >= 0) {
$this->createlog("Order {$orderid} updated");
return 1;
}
} catch (Exception $ex) {
return getMessage();
}
} else {
$candidate_registered_ip = commonclass::GetIP();
$insertData = array();
!empty($data['name']) ? $insertData['name'] = trim($data['name']) : '';
!empty($data['season']) ? $insertData['season'] = trim($data['season']) : '';
!empty($data['mercandiser']) ? $insertData['mercandiser'] = trim($data['mercandiser']) : '';
!empty($data['quantity']) ? $insertData['quantity'] = trim($data['quantity']) : '';
!empty($data['gsm']) ? $insertData['gsm'] = trim($data['gsm']) : '';
!empty($data['excess_percent']) ? $insertData['excess_percent'] = trim($data['excess_percent']) : '';
!empty($data['delivery_date']) ? $insertData['delivery_date'] = commonclass::cleandate($data['delivery_date']) : '';
!empty($data['order_date']) ? $insertData['order_date'] = commonclass::cleandate($data['order_date']) : '';
!empty($data['delivery_type']) ? $insertData['delivery_type'] = $data['delivery_type'] : '';
$insertData['created_on'] = $today;
$insertOrder = $this->internalDB->insert('d_order', $insertData);
$affectedid = $this->internalDB->insertId();
$this->createlog("Candidate {$affectedid} created");
return $affectedid;
