Example #1
0
    public function saveClientData()
    {
        if (Session::getActiveClientid() == 0) {
            return false;
        }
        $sql = 'SELECT 
					AES_DECRYPT(email, :encryptionkey) AS email, 
					AES_DECRYPT(firstname, :encryptionkey) AS firstname,  
					AES_DECRYPT(surname, :encryptionkey) AS surname,
					clientgroupid
				FROM clientdata
				LEFT JOIN client C ON C.idclient= :clientid
				WHERE clientid= :clientid AND C.viewid= :viewid';
        $stmt = Db::getInstance()->prepare($sql);
        $stmt->bindValue('clientid', Session::getActiveClientid());
        $stmt->bindValue('viewid', Helper::getViewId());
        $stmt->bindValue('encryptionkey', Session::getActiveEncryptionKeyValue());
        $stmt->execute();
        $rs = $stmt->fetch();
        if ($rs) {
            Session::setActiveClientFirstname($rs['firstname']);
            Session::setActiveClientSurname($rs['surname']);
            Session::setActiveClientEmail($rs['email']);
            Session::setActiveClientGroupid($rs['clientgroupid']);
        }
        return true;
    }