public function build_director() { $sql_builder = new SQLBuilder(); $data = $this->get_data(); $input = SQLLexical::make_product_list($data['list_product']); return $sql_builder->sql_insert('tam_an.product', array('Name', 'Bought', 'Price', 'Unit'))->sql_insert_values_recursive($input)->end_query()->to_string(); }
public function build_director() { //get data from SQL $data = $this->get_data(); $input = SQLLexical::make_product_list($data['list_product']); //use sql builder $sql_builder = new SQLBuilder(); $id_array = array("Name", "Bought", "Price", "Unit"); foreach ($input as $key => $value) { $sql_builder->update('tam_an.product')->set($id_array, $value)->where()->equals('ID', $key)->end_query(); } return $sql_builder->to_string(); }
public function alter_product_new_product_query($data) { $input = SQLLexical::make_product_list($data['list_product']); return $this->sql_insert('tam_an.product', array('Name', 'Bought', 'Price', 'Unit'))->sql_insert_values_recursive($input)->end_query()->to_string(); }