Ejemplo n.º 1
0
 public function upsert(knl_extensions_dpedcompra_modelPedCompraEntrega $objmodel)
 {
     if ($objmodel->get_id() == 0) {
         $query = "INSERT INTO d_ped_compra_entrega (id_d_ped_compra,dataentrega)\n                    VALUES ('" . $objmodel->get_id_d_ped_compra() . "','" . $objmodel->get_dataentrega_db() . "')";
         $stmt = $this->conn->prepare($query);
         $stmt = $this->conn->execute($stmt);
         $objmodel->set_id($this->conn->Insert_ID());
     } else {
         $query = "UPDATE d_ped_compra_entrega SET \n                      id_d_ped_compra='{$objmodel->get_id_d_ped_compra()}',dataentrega='{$objmodel->get_dataentrega_db()}'\n                      WHERE id = ?";
         $stmt = $this->conn->prepare($query);
         $stmt = $this->conn->execute($stmt, $objmodel->get_id());
     }
     return $objmodel;
 }