con = $con; } public function getRGPD($cliente = false) { $html = ''; $nr = 0; if(!$cliente) { $sql = 'SELECT * FROM RGPD_PERMISOS'; $res = $this->con->query($sql); while($row = $res->fetch_array()) { $nr++; $rpgd = "rgpd" . $nr; $required = $row['CODIGO'] == 1 ? 'required' : ''; $html .= '

'; $html .= '

'; $html .= ''; $html .= '' . utf8_encode($row['TITULO']) .''; $html .= '

'; $html .= '

'; } } else { $idRGPD = []; $titleRGPD = []; $sql = 'SELECT C.* FROM CONTACTOS C WHERE C.CODIGO = ? '; $stmt = $this->con->prepare($sql); $stmt->bind_param('i', $cliente); $stmt->execute(); $res = $stmt->get_result(); $row = $res->fetch_array(); $clienteRGPD = [$row['RGPD_1'], $row['RGPD_2'], $row['RGPD_3'], $row['RGPD_4']]; $sqlRGPD = 'SELECT * FROM RGPD_PERMISOS'; $resRGPD = $this->con->query($sqlRGPD); while($rowRGPD = $resRGPD->fetch_array()) { array_push($idRGPD, $rowRGPD['CODIGO']); array_push($titleRGPD, $rowRGPD['TITULO']); } for($i = 0; $i < count($clienteRGPD); $i++) { $nr++; $rpgd = "rgpd" . $nr; $required = $i == 0 ? 'required' : ''; $checked = $clienteRGPD[$i] == 1 ? 'checked' : ''; $html .= '

'; $html .= '

'; $html .= ''; $html .= '' . utf8_encode($titleRGPD[$i]) .''; $html .= '

'; $html .= '

'; } $html .= ''; } return $html; } } ?>