public function upsert(knl_extensions_dpedcompra_model $objmodel)
{
if ($objmodel->get_id() == 0) {
$query = "INSERT INTO d_ped_compra (id_doc,id_fornecedor)\n VALUES ('" . $objmodel->get_id_doc() . "','" . $objmodel->get_id_fornecedor() . "')";
$stmt = $this->conn->prepare($query);
$stmt = $this->conn->execute($stmt);
$objmodel->set_id($this->conn->Insert_ID());
} else {
$query = "UPDATE d_ped_compra SET \n id_doc='{$objmodel->get_id_doc()}',id_fornecedor='{$objmodel->get_id_fornecedor()}'\n WHERE id = ?";
$stmt = $this->conn->prepare($query);
$stmt = $this->conn->execute($stmt, $objmodel->get_id());
}
return $objmodel;
}
