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(); }