Example #1
0
<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>