<html lang="es"> <head> <meta charset="UTF-8"> <?php include 'header-imp.php'; include '../bd/conexion.php'; ?> <!-- -Recepcion de vriable--> <?php $Vale = $_GET['VALE_NUMERO']; function ceros($numero, $ceros = 2) { return sprintf("%0" . $ceros . "s", $numero); } $Numero = ceros($Requerimiento, 10); ?> </head> <body> <div class="container"> <div class="row clearfix"> <div class="col-md-2 column"> </div> <div class="col-md-6 column"> <center><img class="img-responsive" height="50" width="350" src="../img/rock.png" /></center> </div> </div> <div class="row clearfix"> <div class="col-md-2 column"> </div>
mysql_field_seek($result, 0); while ($field = mysql_fetch_field($result)) { } do { $ID = $row[correlativo]; } while ($row = mysql_fetch_array($result)); } else { echo ""; } function ceros($numero, $ceros = 2) { return sprintf("%0" . $ceros . "s", $numero); } $FECHA = date('Y'); $CORRELATIVO = $ID + 1; $NUMERO = "OV" . $FECHA . ceros($CORRELATIVO, 6); $FECHAINICIO = $_REQUEST[fechainicio]; $FECHAFIN = $_REQUEST[fechafin]; $TRANSPORTISTA = $_REQUEST[transportista]; $CC = $_REQUEST[cc]; $Sql_cab = "INSERT INTO reporte_cab(\r\ncodigo_reporte,\tusuario_idusuario,proveedor_idproveedor,fecha_inicio,fecha_fin)\r\nVALUES('{$NUMERO}','1','{$TRANSPORTISTA}','{$FECHAINICIO}','{$FECHAFIN}')"; $Sql_det = "INSERT INTO reporte_det(transportista,\r\ncodigo_reporte,fecha,area,centro_costo,proveedor_cliente,\r\ndireccion,distrito,tipo_unidad,costo,guia,oc_os,ot,\r\ncomentario)\r\nSELECT p.razonsocial,'{$NUMERO}',r.fecha_reporte,a.area,r.centcos_reporte,\r\nCONCAT(mp.nombre,mc.nombre),\r\nCONCAT(mp.direccion,mc.direccion),\r\nCONCAT(dc.descripcion,dp.descripcion),\r\nt.nombre,r.costo_reporte,r.guia_reporte,r.documento_reporte,r.ot_reporte,\r\nr.comentario_reporte\r\n FROM reporte_transporte AS r INNER JOIN proveedor AS p ON\r\nr.proveedor_idproveedor=p.idproveedor INNER JOIN transporte AS t ON\r\nr.transporte_idtransporte=t.idtransporte INNER JOIN maeprov AS mp ON\r\nr.maeprov_idmaeprov=mp.idmaeprov INNER JOIN maecli AS mc ON\r\nr.maecli_idmaecli=mc.idmaecli INNER JOIN area_cc AS a ON\r\nr.centcos_reporte=a.centro_costo INNER JOIN distritos AS dc ON \r\nmc.distritos_iddistritos=dc.iddistritos INNER JOIN distritos AS dp ON \r\nmp.distritos_iddistritos=dp.iddistritos\r\n WHERE r.estado='00'and\r\nr.fecha_reporte BETWEEN '{$FECHAINICIO}' AND '{$FECHAFIN}'\r\nAND proveedor_idproveedor='{$TRANSPORTISTA}'"; $Sql = "UPDATE reporte_transporte SET estado='01' and \r\nnumero_reporte='{$NUMERO}' WHERE \r\nfecha_reporte BETWEEN '{$FECHAINICIO}' AND '{$FECHAFIN}'\r\nAND proveedor_idproveedor='{$TRANSPORTISTA}' AND \r\ncentcos_reporte='{$CC}'"; $result_cab = mysql_query($Sql_cab); if (!$result_cab) { echo "<script>alert('FALTARON INGRESAR ALGUNOS DATOS');\r\n\r\nwindow.location='/control-de-transporte/reportes/reporte-cc';\r\n\r\n\t</script>"; } else { $result_det = mysql_query($Sql_det); $result = mysql_query($Sql); header('Location: /control-de-transporte/consulta/cabecera'); }
<!DOCTYPE html> <html lang="es"> <head> <?php include '../header.php'; $Requerimiento = $_REQUEST['rq']; $Suma = $Requerimiento; echo "{$SUMA}"; function ceros($numero, $ceros = 2) { return sprintf("%0" . $ceros . "s", $numero); } $Numero = ceros($Suma, 10); ?> </head> <body> <div class="container"> <div class="row clearfix"> <div class="col-md-4 column"> </div> <div class="col-md-4 column"> <img src="../img/aprobado.png" alt="" class="img-responsive"> <h3 class="text-primary">El requerimiento <?php echo $Numero; ?> fue insertado exitosamente.</h3> <a href="../home"
if ($row = mysql_fetch_array($result)) { mysql_field_seek($result, 0); while ($field = mysql_fetch_field($result)) { } do { $IDCO = $row[correlativo]; } while ($row = mysql_fetch_array($result)); } else { echo ""; } function ceros($numero, $ceros = 2) { return sprintf("%0" . $ceros . "s", $numero); } $CORRELATIVOCO = $IDCO + 1; $NUMEROCO = "CO-" . ceros($CORRELATIVOCO, 4); ?> <div class="form-group"> <a id="modal-822096" href="#modal-container-822095" role="button" class="btn btn-info btn-block" data-toggle="modal"> <i class="glyphicon glyphicon-plus-sign"></i> CREAR OT CODRISE</a> <div class="modal fade" id="modal-container-822095" role="dialog" aria-labelledby="myModalLabel" aria-hidden="true"> <div class="modal-dialog"> <div class="modal-content"> <div class="modal-header"> <button type="button" class="close" data-dismiss="modal" aria-hidden="true">×</button> <h4 class="modal-title text-primary" id="myModalLabel"> <b>REGISTRAR OT</b>
if ($row = mysql_fetch_array($result)) { mysql_field_seek($result, 0); while ($field = mysql_fetch_field($result)) { } do { $IDRO = $row[correlativo]; } while ($row = mysql_fetch_array($result)); } else { echo ""; } function cerosr($numero, $ceros = 2) { return sprintf("%0" . $ceros . "s", $numero); } $CORRELATIVORO = $IDRO + 1; $NUMERORO = "RO-" . ceros($CORRELATIVORO, 4); ?> <div class="form-group"> <a id="modal-822096" href="#modal-container-8220" role="button" class="btn btn-primary btn-block" data-toggle="modal"> <i class="glyphicon glyphicon-plus-sign"></i> CREAR OT ROCKDRILL</a> <div class="modal fade" id="modal-container-8220" role="dialog" aria-labelledby="myModalLabel" aria-hidden="true"> <div class="modal-dialog"> <div class="modal-content"> <div class="modal-header"> <button type="button" class="close" data-dismiss="modal" aria-hidden="true">×</button> <h4 class="modal-title text-primary" id="myModalLabel"> <b>REGISTRAR OT</b>
while ($field = mssql_fetch_field($result)) { } do { /*Almacenamos los datos en variables*/ $Codigo = $row[0]; $Requerimiento = $row[1]; } while ($row = mssql_fetch_array($result)); } else { echo "NO hay nada"; } $Req = $Requerimiento + 1; function ceros($numero, $ceros = 2) { return sprintf("%0" . $ceros . "s", $numero); } $Numero = ceros($Req, 10); ?> </head> <body> <div class="container"> <div class="row clearfix"> <div class="col-md-4 column"> <form action="../registrar/requerimiento-materiales.php" method="POST" autocomplete='Off'> <!-- Inicio Datos Ocultos --> <input type="hidden" value="<?php echo date("Y-m-d"); ?> " name="fechaemision"> <input type="hidden" value="<?php echo $solicitante;
if ($row = mysql_fetch_array($result)) { mysql_field_seek($result, 0); while ($field = mysql_fetch_field($result)) { } do { $IDOV = $row[correlativo]; } while ($row = mysql_fetch_array($result)); } else { echo ""; } function ceroso($numero, $ceros = 2) { return sprintf("%0" . $ceros . "s", $numero); } $CORRELATIVOOV = $IDOV + 1; $NUMEROOV = "OV-" . ceros($CORRELATIVOOV, 4); ?> <div class="form-group"> <a id="modal-822096" href="#modal-container-822096" role="button" class="btn btn-success btn-block" data-toggle="modal"> <i class="glyphicon glyphicon-plus-sign"></i> CREAR OT OVERPRIME</a> <div class="modal fade" id="modal-container-822096" role="dialog" aria-labelledby="myModalLabel" aria-hidden="true"> <div class="modal-dialog"> <div class="modal-content"> <div class="modal-header"> <button type="button" class="close" data-dismiss="modal" aria-hidden="true">×</button> <h4 class="modal-title text-primary" id="myModalLabel"> <b>REGISTRAR OT</b>