User.cpp File Reference

#include "User.h"
#include "Basket.h"

Defines

#define KEY_USR_UID   "uid"
#define KEY_USR_NAME   "name"
#define KEY_USR_SURNAME   "surname"
#define KEY_USR_ADDRESS   "address"
#define KEY_USR_CITY   "city"
#define KEY_USR_LOGIN   "login"
#define KEY_USR_PASSWD   "password"
#define KEY_USR_ADMIN   "admin"
#define QUERY_LOGIN   "SELECT * FROM users WHERE login = %0q and password = PASSWORD(%1q)"
#define QUERY_FETCH   "SELECT * FROM users WHERE uid = "
#define QUERY_ADMIN_USERLST   "SELECT * FROM users WHERE admin=0 ORDER BY surname, name"
#define QUERY_ADMIN_TREND

Functions

ostream & operator<< (ostream &aStream, User &u)

Define Documentation

#define KEY_USR_ADDRESS   "address"

Referenced by User::factory(), and operator<<().

#define KEY_USR_ADMIN   "admin"
#define KEY_USR_CITY   "city"

Referenced by User::factory(), and operator<<().

#define KEY_USR_LOGIN   "login"

Referenced by User::factory(), and operator<<().

#define KEY_USR_NAME   "name"
#define KEY_USR_PASSWD   "password"
#define KEY_USR_SURNAME   "surname"
#define KEY_USR_UID   "uid"
#define QUERY_ADMIN_TREND
Value:
"SELECT DATE_FORMAT(date, '%Y') AS year, " \
                            "DATE_FORMAT(date, '%m') as month, " \
                            "SUM(total) AS total_sales FROM orders " \
                            "GROUP BY year, month ORDER BY year, month"

Referenced by AdminUser::showMonthlyTrend().

#define QUERY_ADMIN_USERLST   "SELECT * FROM users WHERE admin=0 ORDER BY surname, name"

Referenced by AdminUser::userList().

#define QUERY_FETCH   "SELECT * FROM users WHERE uid = "

Referenced by User::userByID().

#define QUERY_LOGIN   "SELECT * FROM users WHERE login = %0q and password = PASSWORD(%1q)"

Referenced by User::login().


Function Documentation

ostream& operator<< ( ostream &  aStream,
User u 
)

Generated by  doxygen 1.6.2