public function build_director()
{
$sql_builder = new SQLBuilder();
$data = $this->get_data();
///format key word to tokens
$keywords = SQLLexical::format_product_query_to_array($data);
$keywords = SQLLexical::make_keywords($keywords);
//make query
$len = sizeof($keywords);
$tempID = array();
for ($i = 0; $i < $len; $i++) {
$tempID[$i] = 'Name';
}
return $sql_builder->select(array("Name", SQLBuilder::sql_as("Unit", "UnitName"), "Price", SQLBuilder::sql_as("ID", "Id"), SQLBuilder::sql_as("Product_ID", "ProductId"), SQLBuilder::sql_as("Bought", "Import_Price")))->from("tam_an.product")->where()->or_recursive('like', $tempID, $keywords)->to_string();
}
public function get_list_of_product_info()
{
return $this->select(array("Name", SQLBuilder::sql_as("Unit", "UnitName"), "Price", SQLBuilder::sql_as("ID", "Id"), SQLBuilder::sql_as("Product_ID", "ProductId"), SQLBuilder::sql_as("Bought", "Import_Price")))->from("tam_an.product")->where()->not_equals('Price', 0)->to_string();
}
public function build_director()
{
$sql_builder = new SQLBuilder();
$data = $this->get_data();
return $sql_builder->select(array(SQLBuilder::sql_as('ID', 'Id'), 'Name', 'User_type'))->from('tam_an.user')->where()->and_recursive('LIKE', array('Username', 'Password'), array($data['username'], md5($data['password'])))->to_string();
}
