<?php
if (isset($_REQUEST['submit'])) {
$value = $_REQUEST['upb_selecttype'];
storedata($value);
}
if (!checkdata()) {
global $wpdb;
$upb_cat = $wpdb->prefix . "upb_cat";
$select = "SELECT * FROM {$upb_cat}";
$data = $wpdb->get_results($select);
//$data=mysql_query($select);
?>
<form action="#" method="post">
<div id="upb_selecttype_div" style="height:400px; width:400px;">
<select id="upb_selecttype" name="upb_selecttype">
<option value="select">Select</option>
<?php
foreach ($data as $row) {
?>
<option value="<?php
echo $row->id;
?>
">
function valida_dato($field, $value, $valid, $row, $tmp)
{
//echo "<pre>$tmp<br>";print_r($valid);echo "<br>";print_r($row);echo "</pre>";
if ($tmp == "professionisti") {
$ruolo = "progettista";
$id = $row["id_professionista"];
} elseif ($tmp == "imprese") {
$ruolo = "esecutore";
$id = $row["id_impresa"];
} else {
$ruolo = "richiedente";
$id = $tmp == "beneficiari" ? $row["id_beneficiario"] : $row["id_soggetto"];
}
switch ($valid["validazione"]) {
case 1:
//OBBLIGATORIO
if (!trim($value)) {
$out = array("valido" => 0, "campo" => $field, "valore" => $value, "active_form" => $valid["active_form"], "param" => array("id={$id}", "ruolo={$ruolo}"), "id" => $row["id_soggetto"], "pratica" => $row["id_pratica"]);
} else {
$out = array("valido" => 1, "campo" => $field, "valore" => $value);
}
break;
case 2:
//OBBLIGATORIO PERSONA FISICA
if (!trim($row["denominazione"])) {
if (!trim($value)) {
$out = array("valido" => 0, "campo" => $field, "valore" => $value, "active_form" => $valid["active_form"], "param" => array("id={$id}", "ruolo={$ruolo}"), "id" => $row["id_soggetto"], "pratica" => $row["id_pratica"]);
} else {
$out = array("valido" => 1, "campo" => $field, "valore" => $value);
}
} else {
$out = array("valido" => 1, "campo" => $field, "valore" => $value);
}
break;
case 3:
//OBBLIGATORIO PERSONA GIURIDICA
if (trim($row["denominazione"])) {
if (!trim($value)) {
$out = array("valido" => 0, "campo" => $field, "valore" => $value, "active_form" => $valid["active_form"], "param" => array("id={$id}", "ruolo={$ruolo}"), "id" => $row["id_soggetto"], "pratica" => $row["id_pratica"]);
} else {
$out = array("valido" => 1, "campo" => $field, "valore" => $value);
}
} else {
$out = array("valido" => 1, "campo" => $field, "valore" => $value);
}
break;
case 4:
if (trim($value) && !(controllaCF(trim($value)) && controllaPIVA(trim($value)))) {
$out = array("valido" => 1, "campo" => $field, "valore" => $value);
} else {
$out = array("valido" => 0, "campo" => $field, "valore" => $value, "active_form" => $valid["active_form"], "param" => array("id={$id}", "ruolo={$ruolo}"), "id" => $row["id_soggetto"], "pratica" => $row["id_pratica"]);
}
break;
case 5:
if (trim($value) && !(controllaCF($value) && controllaPIVA($value))) {
$out = array("valido" => 1, "campo" => $field, "valore" => $value);
} else {
$out = array("valido" => 0, "campo" => $field, "valore" => $value, "ext_form" => $valid["active_form"], "param" => array("id={$id}", "ruolo={$ruolo}"), "id" => $row["id_soggetto"], "pratica" => $row["id_pratica"]);
}
break;
case 6:
if ($value == "M" || $value == "F" || trim($row["denominazione"])) {
$out = array("valido" => 1, "campo" => $field, "valore" => $value);
} else {
$out = array("valido" => 0, "campo" => $field, "valore" => $value, "active_form" => $valid["active_form"], "param" => array("id={$id}", "ruolo={$ruolo}"), "id" => $row["id_soggetto"], "pratica" => $row["id_pratica"]);
}
break;
case 7:
if (checkdata($value)) {
$out = array("valido" => 1, "campo" => $field, "valore" => $value);
} else {
$out = array("valido" => 0, "campo" => $field, "valore" => $value, "active_form" => $valid["active_form"], "param" => array("id={$id}", "ruolo={$ruolo}"), "id" => $row["id_soggetto"], "pratica" => $row["id_pratica"]);
}
break;
case 8:
if (checkdata($value) || trim($row["denominazione"])) {
$out = array("valido" => 1, "campo" => $field, "valore" => $value);
} else {
$out = array("valido" => 0, "campo" => $field, "valore" => $value, "active_form" => $valid["active_form"], "param" => array("id={$id}", "ruolo={$ruolo}"), "id" => $row["id_soggetto"], "pratica" => $row["id_pratica"]);
}
break;
case 18:
if (ereg("^[A-Z]{1}[0-9]{3}\$", $value) || trim($row["denominazione"])) {
$out = array("valido" => 1, "campo" => $field, "valore" => $value);
} else {
$out = array("valido" => 0, "campo" => $field, "valore" => $value, "active_form" => $valid["active_form"], "param" => array("id={$id}", "ruolo={$ruolo}"), "id" => $row["id_soggetto"], "pratica" => $row["id_pratica"]);
}
break;
case 19:
if (ereg("^[A-Z]{1}[0-9]{3}\$", $value) || !trim($row["denominazione"])) {
$out = array("valido" => 1, "campo" => $field, "valore" => $value);
} else {
$out = array("valido" => 0, "campo" => $field, "valore" => $value, "active_form" => $valid["active_form"], "param" => array("id={$id}", "ruolo={$ruolo}"), "id" => $row["id_soggetto"], "pratica" => $row["id_pratica"]);
}
break;
case 9:
if ($value <= 4 && $value >= 1) {
$out = array("valido" => 1, "campo" => $field, "valore" => $value);
} else {
$out = array("valido" => 0, "campo" => $field, "valore" => $value, "active_form" => $valid["active_form"], "param" => array("id={$id}", "ruolo={$ruolo}"), "id" => $row["id_soggetto"], "pratica" => $row["id_pratica"]);
}
break;
case 10:
if ($value <= 2 && $value >= 0) {
$out = array("valido" => 1, "campo" => $field, "valore" => $value);
} else {
$out = array("valido" => 0, "campo" => $field, "valore" => $value, "active_form" => $valid["active_form"], "param" => array("id={$id}", "ruolo={$ruolo}"), "id" => $row["id_soggetto"], "pratica" => $row["id_pratica"]);
}
break;
case 11:
if ($value <= 6 && $value >= 1) {
$out = array("valido" => 1, "campo" => $field, "valore" => $value);
} else {
$out = array("valido" => 0, "campo" => $field, "valore" => $value, "active_form" => $valid["active_form"], "param" => array("id={$id}", "ruolo={$ruolo}"), "id" => $row["id_soggetto"], "pratica" => $row["id_pratica"]);
}
break;
case 12:
if ($value == "F" || $value == "T") {
$out = array("valido" => 1, "campo" => $field, "valore" => $value);
} else {
$out = array("valido" => 0, "campo" => $field, "valore" => $value, "active_form" => $valid["active_form"], "param" => array("id={$id}", "ruolo={$ruolo}"), "id" => $row["id_soggetto"], "pratica" => $row["id_pratica"]);
}
break;
case 13:
if ($value <= 7 && $value >= 1) {
$out = array("valido" => 1, "campo" => $field, "valore" => $value);
} else {
$out = array("valido" => 0, "campo" => $field, "valore" => $value, "active_form" => $valid["active_form"], "param" => array("id={$id}", "ruolo={$ruolo}"), "id" => $row["id_soggetto"], "pratica" => $row["id_pratica"]);
}
break;
case 14:
if ($value && !(controllaCF($value) && controllaPIVA($value))) {
$out = array("valido" => 1, "campo" => $field, "valore" => $value);
} else {
$out = array("valido" => 0, "campo" => $field, "valore" => $value, "active_form" => $valid["active_form"], "param" => array("id={$id}", "ruolo={$ruolo}"), "id" => $row["id_soggetto"], "pratica" => $row["id_pratica"]);
}
break;
case 15:
if ($value && $value > 1900 && $value < 2100) {
$out = array("valido" => 1, "campo" => $field, "valore" => $value);
} else {
$out = array("valido" => 0, "campo" => $field, "valore" => $value, "active_form" => $valid["active_form"], "id" => "", "pratica" => $row["id_pratica"]);
}
break;
case 20:
if ($row["tipo_richiesta"] == 1) {
if (!$value) {
$value = "00000000";
}
$out = array("valido" => 1, "campo" => $field, "valore" => $value);
} else {
if (!($value && checkdata($value))) {
$out = array("valido" => 0, "campo" => $field, "valore" => $value, "active_form" => $valid["active_form"], "param" => array("id=" . $row["id"]), "id" => $row["id"], "pratica" => $row["id_pratica"]);
} else {
$out = array("valido" => 1, "campo" => $field, "valore" => $value);
}
}
break;
default:
$out = array("valido" => 1, "campo" => $field, "valore" => $value);
break;
}
return $out;
}
