<?php $query = 'select * from localidades where departamento_id=' . $result['DepartamentoID'] . ' order by nombre'; $resultl = $db->consulta($query); echo '<option value="0">Localidad</option>'; while ($result2 = $db->fetch_array($resultl)) { if ($result['LocalidadID'] == $result2['id']) { $locals = "selected"; } else { $locals = ""; } echo '<option value="' . $result2[id] . '" ' . $locals . ' >' . utf8_encode($result2[nombre]) . '</option>'; } ?> </select><br> </div> <label>Fecha de Alta:</label> <input type="text" name="falta" value="<?php echo afecha($result['FechaAlta']); ?> " readonly="readonly" /><br> <input type="hidden" name="fbaja" /> <input type="hidden" name="ID" value="<?php echo $_GET['ID']; ?> "/> <input type="submit" value="Guardar" style="float:left"/> <div id="coment" style=" float:left; margin-top:2px; margin-left:10px; color:#FF9"></div> </form> </div> <br /><br /><br /><br /><br /> <script type="text/javascript">
$otsel = ""; } echo '<option value="' . $result2['ID'] . '" ' . $otsel . ' >OT ' . $result2['ID'] . '</option>'; } ?> </select> </th> <th>Nro.Serie/MAC</th> </tr> </thead> <?php while ($result6 = $db->fetch_array($result5)) { // listamos de primero a ultimo $html = $html . '<tr class="odd">'; $html = $html . '<td>' . afecha($result6['FechaInstalacion']) . '</td>'; $html = $html . '<td>' . $result6['cant'] . ' ' . $result6['unidades'] . ' </td>'; $html = $html . '<td>' . $result6['articulo'] . '</td>'; $html = $html . '<td>' . $result6['personal'] . '</td>'; $html = $html . '<td>' . $result6['ot'] . '</td>'; $html = $html . '<td>' . $result6['serie'] . '</td></tr>'; } echo $html . "</table>"; ?> <script type="text/javascript"> // esperamos que el DOM cargue $(document).ready(function() { $("select.filtro").change(function(){
</thead> <tbody> <?php while ($result2 = $db->fetch_array($result)) { // listamos de primero a ultimo $html = '<tr class="odd">'; $html = $html . '<td>' . $result2['ID'] . '</td>'; $html = $html . '<td>' . $result2['ClientesID'] . '</td>'; $html = $html . '<td>' . $result2['NumeroVisita'] . '</td>'; $html = $html . '<td>' . $result2['empresa'] . '</td>'; $html = $html . '<td>' . afecha($result2['FechaEmision']) . '</td>'; $html = $html . '<td>'; if ($result2['empleado'] == "") { $html = $html . "Sin asignar"; } else { $html = $html . afecha($result2['FechaInstalacion']); } echo '</td>'; $html = $html . '<td>'; if ($result2['empleado'] == "") { $html = $html . "Sin asignar"; } else { $html = $html . $result2['empleado']; } echo '</td>'; $html = $html . '<td>' . $result2['estado'] . '</td>'; $html = $html . '<td align="center"><img src="img/borrar.png" onclick="borrar(' . $result2['ID'] . ');" height="15" style="margin-bottom:3px; margin-right:-5px;" title="Anular" alt="Anular"><img src="img/editar.png" style="margin-left:10px;" height="20" title="Editar" onclick="editar(' . $result2['ID'] . ');" alt="Editar"></td>'; $html = $html . '</tr>'; echo $html; } ?>
<th>Cantidad</th> <th>Unidad</th> <th>Fecha de Modificacion</th> </tr> </thead> <?php while ($result2 = $db->fetch_array($result1)) { // listamos de primero a ultimo $html = '<tr class="odd">'; $html = $html . '<td style="display:none;">' . $result2['ID'] . '</td>'; $html = $html . '<td>' . $result2['Descripcion'] . '</td>'; $html = $html . '<td>' . $result2['NroSerie'] . '</td>'; $html = $html . '<td>' . $result2['rubros'] . '</td>'; $html = $html . '<td>' . $result2['Cantidad'] . '</td>'; $html = $html . '<td>' . $result2['unidades'] . '</td>'; $html = $html . '<td>' . afecha($result2['FechaModif']) . '</td>'; $html = $html . '</tr>'; echo $html; } ?> </table> <script type="text/javascript"> // esperamos que el DOM cargue $(document).ready(function() { $("select.filtrog").change(function(){ $("#general").load("ajax/listastockgen.php?Rubro="+$("#rubstockg").val()+"&Desc="+$("#descstockg").val()); }); });
<th>Unidad</th> <th>Fecha de Modificacion</th> </tr> </thead> <?php while ($result4 = $db->fetch_array($result3)) { // listamos de primero a ultimo $html = '<tr class="odd">'; $html = $html . '<td>' . $result4['nombre'] . '</td>'; $html = $html . '<td style="display:none;">' . $result4['ArticuloID'] . '</td>'; $html = $html . '<td>' . $result4['articulo'] . '</td>'; $html = $html . '<td>' . $result4['serie'] . '</td>'; $html = $html . '<td>' . $result4['rubros'] . '</td>'; $html = $html . '<td>' . $result4['Cantidad'] . '</td>'; $html = $html . '<td>' . $result4['unidades'] . '</td>'; $html = $html . '<td>' . afecha($result4['FechaModifica']) . '</td>'; $html = $html . '</tr>'; echo $html; } ?> </table> <script type="text/javascript"> // esperamos que el DOM cargue $(document).ready(function() { $("select.filtro").change(function(){ $("#empleado").load("ajax/listastockemp.php?EmpleadoID="+$("#empstock").val()+"&Rubro="+$("#rubstock").val()+"&Desc="+$("#descstock").val()); });
<th>Puesto</th> <th>Fecha Alta</th> <th align="center">Acciones</th> </tr> </thead> <?php while ($result2 = $db->fetch_array($result)) { // listamos de primero a ultimo $html = '<tr class="odd">'; $html = $html . '<td>' . $result2['NombreApellido'] . '</td>'; $html = $html . '<td>' . $result2['CuilCuit'] . '</td>'; $html = $html . '<td>' . $result2['Direccion'] . '</td>'; $html = $html . '<td>' . $result2['Telefono'] . '</td>'; $html = $html . '<td>' . $result2['Cel'] . '</td>'; $html = $html . '<td>' . $result2['PuestoID'] . '</td>'; $html = $html . '<td>' . afecha($result2['FechaAlta']) . '</td>'; $html = $html . '<td align="center"><img src="img/borrar.png" onclick="borrar(' . $result2['ID'] . ',' . "'" . $result2['NombreApellido'] . "'" . ');" height="15" style="margin-bottom:3px; margin-right:-5px;" title="Borrar" alt="Borrar"><img src="img/editar.png" style="margin-left:10px;" height="20" title="Editar" onclick="editar(' . $result2['ID'] . ');" alt="Editar"></td>'; $html = $html . '</tr>'; echo $html; } ?> </table> <div id="accion" style="display:none"></div> <script type="text/javascript"> // esperamos que el DOM cargue function borrar(persID,persNombre){ if (confirm("Si continúa se eliminará toda la información concerniente a "+persNombre+".")){ $("#accion").load("ajax/borrapers.php?id="+persID, function(){location.reload();}); }