public function stampaImacDaParametroXedit($token, $param) { if ($param == 'protocollo') { $query = "SELECT im.nProtocollo,im.ticket,im.matUtente,im.stato,dip.cognome,dip.nome AS nome,im.tipoRichiesta,tipo.nome AS descrizione,im.pathFile,im.note,im.dataApertura \n FROM imac AS im JOIN dipendenti AS dip ON im.matUtente=dip.matricola JOIN tipo_richiesta AS tipo ON im.tipoRichiesta=tipo.id WHERE im.nProtocollo='" . $token . "' ORDER BY im.nProtocollo DESC"; } else { if ($param == 'ticket') { $query = "SELECT im.nProtocollo,im.ticket,im.matUtente,im.stato,dip.cognome,dip.nome AS nome,im.tipoRichiesta,tipo.nome AS descrizione,im.pathFile,im.note,im.dataApertura\n FROM imac AS im JOIN dipendenti AS dip ON im.matUtente=dip.matricola JOIN tipo_richiesta AS tipo ON im.tipoRichiesta=tipo.id WHERE im.ticket='" . $token . "' ORDER BY im.nProtocollo DESC"; } else { if ($param == 'matricola') { $query = "SELECT im.nProtocollo,im.ticket,im.matUtente,im.stato,dip.cognome,dip.nome AS nome,im.tipoRichiesta,tipo.nome AS descrizione,im.pathFile,im.note,im.dataApertura\n FROM imac AS im JOIN dipendenti AS dip ON im.matUtente=dip.matricola JOIN tipo_richiesta AS tipo ON im.tipoRichiesta=tipo.id WHERE im.matUtente='" . $token . "' ORDER BY im.nProtocollo DESC"; } } } if (!($res = $this->DBconn->query($query))) { echo $this->DBconn->error; } else { if ($res->num_rows >= 1) { $option = new TIPO(); echo "<div id='imacListEdit' class='table-responsive'>\n <table class='table'>\n <thead>\n <tr>\n <th>PROTOCOLLO</th><th>TICKET</th><th>MATRICOLA</th><th>COGNOME,NOME</th><th>STATO</th><th>TIPO</th><th>NOTE</th><th>FILE</th><th>New File</th><th>DATA</th><th>EDIT</th><th>DEL</th>\n </tr>\n </thead>\n <tbody>"; while ($row = $res->fetch_assoc()) { echo "<tr>"; echo "<td><span class='NPROTOCOLLO' id='nProtocollo'>" . $row['nProtocollo'] . "</span></td>"; echo "<td><input type='text' class='TICKET numero' id='ticket' value='" . $row['ticket'] . "'></td>"; echo "<td><input type='text' class='MATRICOLA' id='matricola' value='" . $row['matUtente'] . "'></td>"; echo "<td><input type='text' class='COGNOME,NOME' id='cognome_nome' value='" . $row['cognome'] . "," . $row['nome'] . "'></td>"; echo "<td>"; $this->stampaStatoCombo($row['stato']); echo "</td>"; //echo "<td><span class='STATO' id='stato'>".$row['stato']."</span></td>"; echo "<td>"; $option->stampaSelectedComboType($row['tipoRichiesta']); echo "</td>"; //echo "<td><span class='TIPO' id='tipo'>".$row['descrizione']."</span></td>"; echo "<td><input type='text' class='' id='note' value='" . $row['note'] . "'></td>"; if ($row['pathFile'] != '') { echo "<td><button class='PATHFILE btn btn-sm btn-info' id='" . $row['nProtocollo'] . "'>--></button>"; } else { echo "<td><button class='noFILE btn btn-sm btn-danger disabled'>X</button></td>"; } echo "<td><button class='addPATHFILE btn btn-sm btn-info' id='addNewFile'>ADD new file</button><span class='nascosto newFileUppato'></span></td>"; //echo "<td><a class='PATHFILE' id='pathfile' href='#".$row['pathFile']."'>".$row['pathFile']."</a></td>"; // echo "<td><input type='text' id='FETCHdata' class='DATA' value='" . $row['dataApertura'] . "'></td>"; echo "<td><button id='EDITimac' class='btn btn-sm btn-success IMAC-CD'>V</button></td>"; echo "<td><button id='DELimac' class='btn btn-sm btn-danger IMAC-CD'>X</button></td>"; echo "</tr>"; } echo "</tbody>\n </table>\n </div>"; stampaHintDiv(); } else { echo "<span class='alert alert-danger'>Nessun risultato per il filtro impostato!</span>"; } } }
echo "<td><button id='FETCHadd' class='btn btn-sm btn-success IMAC-CD'>ADD</button></td>"; echo "<td><button id='FETCHdel' class='btn btn-sm btn-warning IMAC-CD'>DEL</button></td>"; echo "</tr>"; } echo "<tr><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td><button class='btn btn-sm btn-danger' id='clearFiles'>Clear All</button></td></tr>"; echo "</tbody></table></div>"; stampaHintDiv(); } else { echo "Nessun file presente nella directory temporanea"; } } if (isset($_POST['manualInsert'])) { require_once "db.php"; require_once "excelFunctions.php"; require_once "CLASS_type.php"; $option = new TIPO(); echo "<div id='imacManualList' class='table-responsive'>\n <table class='table'>\n <thead>\n <tr>\n <th>FILE</th><th>MATRICOLA</th><th>COGNOME,NOME</th><th>TICKET</th><th>TIPO</th><th>NOTE</th><th>DATA</th><th>PROT.IMAC</th><th>+</th><th>-</th>\n </tr>\n </thead>\n <tbody>"; echo "<tr id='blankManualRow' class='nascosto'>"; echo "<td id='MANUALupFile' class='MANUALupFileClass'><button class='btn btn-sm btn-info'>Upload</button></td>"; echo "<td><input type='text' id='FETCHmatUtente' class='defwidth' value=''></td>"; echo "<td><input type='text' id='FETCHcognomeNome' value=''></td>"; echo "<td><input type='text' id='FETCHticket' value='' class='defwidth numero'></td>"; echo "<td>"; echo $option->stampaComboType(); echo "</td>"; echo "<td><input type='text' id='FETCHnote' value=''></td>"; echo "<td><input type='text' id='FETCHdata_Manual' class='defwidth' value=''></td>"; echo "<td><span id='FETCHprotImac' class='defwidth DataManual'></span></td>"; echo "<td><button id='MANUALadd' class='btn btn-sm btn-success IMAC-CD'>ADD</button></td>"; echo "<td><button id='MANUALdel' class='btn btn-sm btn-warning IMAC-CD'>DEL</button></td>"; echo "</tr>";
$tipo = new TIPO(); $newNome = sanitizeInput($_POST['nome']); $id = $_POST['id']; $tipo->id = $id; $tipo->nome = $newNome; if (!$tipo->aggiornaType()) { echoResponse('no', "Errore aggiornamento record, contatta un admin"); } else { echoResponse('yes', "Record Aggiornato"); } } //script del tipologia if (isset($_POST['deleteType'])) { require_once "CLASS_type.php"; require_once "CLASS_imac.php"; $tipologia = new TIPO(); $imac = new IMAC(); $tipologia->getTypeById($_POST['id']); $imac->tipoRichiesta = $_POST['id']; if ($imac->getAmountImacByToken('tipo') == 0) { $tipologia->cancellaType(); echoResponse('yes', "Cancellata tipologia " . $tipologia->nome); } else { echoResponse('no', "La tipologia non può essere cancellato perchè sono presenti IMAC associate a lei"); } } /********************************** * USER management ADD * **********************************/ if (isset($_POST['addUser'])) { require_once "CLASS_user.php";