public Data luceneSelect(Data data)
{
Data db = new Data();
db.open();
Data result = db.select("SELECT * FROM user", data);
db.close();
return result;
}
public Data selectAll(Data data)
{
Data db = new Data();
db.open();
Data result = db.select("SELECT * FROM profile ORDER BY name ASC LIMIT @page, 10", data);
db.close();
return result;
}
public Data getRatingThree(Data data)
{
Data db = new Data();
db.open();
Data result = db.select("SELECT * FROM rating WHERE value=3 AND profile_id=@profile_id", data);
db.close();
return result;
}
public Data getTotalRating(Data data)
{
Data db = new Data();
db.open();
Data result = db.select("SELECT value FROM rating WHERE profile_id=@profile_id", data);
db.close();
return result;
}
public Data checkUserRating(Data data)
{
Data db = new Data();
db.open();
Data result = db.select("SELECT id FROM rating WHERE profile_id=@profile_id AND user_id=@user_id", data);
db.close();
return result;
}
public Data selectImage(Data data)
{
Data db = new Data();
db.open();
Data result = db.select("SELECT path, caption FROM image WHERE id=@imageId", data);
db.close();
return result;
}
public Data select(Data data)
{
Data db = new Data();
db.open();
Data result = db.select("SELECT * FROM account WHERE user_id=@user_id", data);
db.close();
return result;
}
public Data selectInserted(Data data)
{
Data db = new Data();
db.open();
Data result = db.select("SELECT * FROM profile WHERE name=@name AND address=@address AND email=@email AND phone=@phone", data);
db.close();
return result;
}
public Data getSearchForIndex(Data data)
{
Data db = new Data();
db.open();
Data result = db.select("SELECT * FROM profile", data);
db.close();
return result;
}
public Data getUserID(Data data)
{
Data db = new Data();
db.open();
Data result = db.select("SELECT id, username FROM user WHERE username=@username", data);
db.close();
return result;
}
public Data select(Data data)
{
Data db = new Data();
db.open();
Data result = db.select("SELECT * FROM profile WHERE id=@id", data);
db.close();
return result;
}
public Data login(Data data)
{
Data db = new Data();
db.open();
Data result = db.select("SELECT username, firstname, lastname FROM user WHERE username = @username AND password = @password", data);
db.close();
return result;
}
public Data selectTransaction(Data data)
{
Data db = new Data();
db.open();
Data result = db.select("SELECT * FROM transaction WHERE from_id=@user_id OR to_id=@user_id", data);
db.close();
return result;
}
public Data getUser(Data data)
{
Data db = new Data();
db.open();
Data result = db.select("SELECT * FROM user WHERE id=@user_id", data);
db.close();
return result;
}
public Data searchAll(Data data)
{
rating rating = new Rating_db();
Data db = new Data();
db.open();
Data result = db.select(@"SELECT * FROM profile WHERE latitude<@eastLatitude AND latitude>@westLatitude
AND longitude<@northLongitude AND longitude>@southLongitude", data);
result.getString("averageRating", rating.
db.close();
return result;
}
public bool insert(Data data)
{
Data db = new Data();
db.open();
int result_business = db.insert("INSERT INTO business (company, owner, phone, address, email) VALUES (@company, @owner, @phone, @address, @email)", data);
Object select_id = db.select("SELECT id AS business_id FROM business ORDER BY id DESC LIMIT 1", data).getValue("business_id");
data.add("business_id", select_id);
int result_profile = db.insert("INSERT INTO profile(business_id) VALUES (@business_id)", data);
db.close();
return true;
}
public bool checkProfile(Data data)
{
Data db = new Data();
db.open();
Data result = db.select("SELECT * FROM profile WHERE id=@profile_id", data);
db.close();
if (result.Count == 0)
{
return false;
}
else
{
return true;
}
}
public Data selectUser(Data data, String[] item)
{
string items = "";
Data db = new Data();
for (int i = 0; i < item.Count(); i++)
{
int count = item.Count();
if (i == count - 1)
{
items = items + item[i];
}
else
{
items = items + item[i] + ",";
}
}
string query = "SELECT * FROM user WHERE id IN(<SEARCH>)";
query = query.Replace("<SEARCH>", items);
db.open();
Data result = db.select(query, data);
db.close();
return result;
}
public Data search(Data data, String[] item)
{
Data db = new Data();
string items = "";
db.open();
string query = queryType(data);
for (int i = 0; i < item.Count(); i++)
{
int count = item.Count();
if (i == count - 1)
{
items = items + item[i];
}
else
{
items = items + item[i] + ",";
}
}
query = query.Replace("<SEARCH>", items);
Data result = db.select(query, data);
db.close();
return result;
}
public Data totalRating(Data data)
{
Data db = new Data();
db.open();
Data result = db.select("SELECT sum(value) FROM rating WHERE profile_id=@profile_id", data);
data.add("sum_rating", result.getString("sum(value)"));
Data total = db.select("SELECT value FROM rating WHERE profile_id=@profile_id", data);
db.close();
return total;
}
public Data numPerRate(Data data)
{
Data db = new Data();
db.open();
Data result = db.select("SELECT id FROM rating WHERE profile_id=@profile_id AND value=@value", data);
db.close();
return result;
}
