1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74
| <?php
require('connexion.php');
?>
<div class="tableDrag">
<table>
<tr>
<th>
Code
</th>
<th>
Name
</th>
</tr>
<tr>
<?php $function = oci_parse($conn, "SELECT FUNCTION_NAME_EN, FUNCTION_CODE from Function");
oci_execute($function);
while (($row = oci_fetch_array($function, OCI_BOTH)) != false) {
echo "<li><td>";
echo $row['FUNCTION_CODE'];
echo "</td>";
echo "<td>";
echo $row['FUNCTION_NAME_EN'];
echo "</td></li>";
echo "</tr>";}?>
</table>
</div>
<div id="cartFunction">
<div class="ui-widget-content">
<ol>
<li class="placeholder">Add the organe(s) here</li>
</ol>
</div>
</div>
<footer class="cf">
<div class="label">
Tip : Use drag-and-drop to select the items to include in the document.
</div>
<div class="BoutonPDF">
<a href="convert.php" class="myButton">Get PDF tables</a><a href="#" class="myButton">Get PDF sheets</a>
</div>
</footer>
<script>
$(function() {
$( ".tableDrag li" ).draggable({
appendTo: "body",
helper: "clone"
});
$( "#cartFunction ol" ).droppable({
activeClass: "ui-state-default",
hoverClass: "ui-state-hover",
accept: ":not(.ui-sortable-helper)",
drop: function( event, ui ) {
$( this ).find( ".placeholder" ).remove();
$( "<li></li>" ).text( ui.draggable.text() ).appendTo( this );
}
}).sortable({
items: "li:not(.placeholder)",
sort: function() {
// gets added unintentionally by droppable interacting with sortable
// using connectWithSortable fixes this, but doesn't allow you to customize active/hoverClass options
$( this ).removeClass( "ui-state-default" );
}
});
});
</script> |
Partager