function listado($fechai, $fechaf, $proy_add, $proy_del, $aplica_oes, $buscar, $filtros, $pagina, $boton)
{
if (!$aplica_oes) {
$aplica_oes = 'no';
}
if (!$fechai) {
$fechai = date("Y-m-d");
}
if (!$fechaf) {
$fechaf = date("Y-m-d");
}
if (!$pagina) {
$pagina = 1;
}
if (count($proy_add) > 0) {
for ($i = 0; $i < count($proy_add); $i++) {
$s_1 = "insert into filtros values('','proyectos','{$proy_add[$i]}','{$_SESSION['IDEMP']}')";
$r_1 = mysql_query($s_1);
}
}
if (count($proy_del) > 0) {
for ($i = 0; $i < count($proy_del); $i++) {
$s_1 = "delete from filtros where filtro='proyectos' and id_emp='{$_SESSION['IDEMP']}' and valor='{$proy_del[$i]}'";
$r_1 = mysql_query($s_1);
}
}
?>
<div align="center" class="aviso">Si desea filtrar la información, utilice los calendarios y listas desplegables. Puede personalizar este reporte y conservar los cambios siempre que inicie sesión.</div>
<form action="?op=listado" method="post" name="form1">
<table align="center" class="tabla">
<tr height="20">
<td align="center" width="100" bgcolor="#E6E6E6">Inicio Captura</td>
<td align="center" width="100" bgcolor="#E6E6E6">Fin Captura</td>
<td align="center" bgcolor="#E6E6E6">Agregue/quite proyectos</td>
</tr>
<tr>
<td align="center">
<script language="JavaScript">
var GC_SET_0 = {
'appearance': GC_APPEARANCE,
'dataArea': 'fechai',
'valor': '<?php
echo $fechai;
?>
'
}
new gCalendar(GC_SET_0);
</script>
</td>
<td align="center">
<script language="JavaScript">
var GC_SET_0 = {
'appearance': GC_APPEARANCE,
'dataArea': 'fechaf',
'valor': '<?php
echo $fechaf;
?>
'
}
new gCalendar(GC_SET_0);
</script>
</td>
<td align="center">
<table align="center" border="0" cellspacing="0" cellpadding="0" width="100%">
<tr><td align="left">
<?php
$r_1 = mysql_query(get_proyectos_out());
$n_1 = mysql_num_rows($r_1);
?>
<select name="proy_add[]" multiple="multiple" class="texto" id="proy_add_">
<option value="">Seleccionar Todos</option>
<?php
while ($d_1 = mysql_fetch_array($r_1)) {
?>
<option value="<?php
echo $d_1['id'];
?>
"><?php
echo $d_1['nombre'];
?>
</option><?php
}
?>
</select></td>
<td align="center"><input type="button" value="<< >>" onclick="submit()" style="width:50px;" class="submit"></td>
<td align="left">
<?php
$r_1 = mysql_query(get_proyectos_in());
$n_1 = mysql_num_rows($r_1);
?>
<select name="proy_del[]" multiple="multiple" class="texto" id="proy_del_">
<option value="">Seleccionar Todos</option>
<?php
while ($d_1 = mysql_fetch_array($r_1)) {
?>
<option value="<?php
echo $d_1['valor'];
?>
"><?php
echo $d_1['nombre'];
?>
</option><?php
}
?>
</select></td>
</tr></table></td>
</tr>
</table><br>
<table align="center" class="tabla">
<tr height="20">
<td align="left" width="62"> Buscar:</td>
<td>
<input type="text" class="texto" size="75" value="<?php
echo $buscar['0'];
?>
" name="buscar[0]" id="buscar">
</td>
<td align="center">En:</td>
<td><?php
$s_1 = "select campo, nombre from encabezados where ver_filtros='1' order by nombre";
$r_1 = mysql_query($s_1);
?>
<select name="filtros[0]" class="texto" style="width:150px;" id="filtros">
<option value=""></option>
<?php
while ($d_1 = mysql_fetch_array($r_1)) {
?>
<option value="<?php
echo $d_1['campo'];
?>
" <?php
if ($filtros[0] == $d_1['campo']) {
?>
selected="selected"<?php
}
?>
>
<?php
echo $d_1['nombre'];
?>
</option><?php
}
?>
</select></td>
<td align="center" width="110">Filtrar por OES?</td>
</tr>
<tr height="20">
<td align="left" width="62"> Buscar:</td>
<td>
<input type="text" class="texto" size="75" value="<?php
echo $buscar['1'];
?>
" name="buscar[1]" id="buscar">
</td>
<td align="center">En:</td>
<td><?php
$s_1 = "select campo, nombre from encabezados where ver_filtros='1' order by nombre";
$r_1 = mysql_query($s_1);
?>
<select name="filtros[1]" class="texto" style="width:150px;" id="filtros">
<option value=""></option>
<?php
while ($d_1 = mysql_fetch_array($r_1)) {
?>
<option value="<?php
echo $d_1['campo'];
?>
" <?php
if ($filtros[1] == $d_1['campo']) {
?>
selected="selected"<?php
}
?>
>
<?php
echo $d_1['nombre'];
?>
</option><?php
}
?>
</select></td>
<td align="center"><input type="radio" value="si" name="aplica_oes" <?php
if ($aplica_oes == 'si') {
?>
checked="checked"<?php
}
?>
onclick='filtro_oes();'> SI</td>
</tr>
<tr height="20">
<td align="left" width="62"> Buscar:</td>
<td>
<input type="text" class="texto" size="75" value="<?php
echo $buscar['2'];
?>
" name="buscar[2]" id="buscar">
</td>
<td align="center">En:</td>
<td><?php
$s_1 = "select campo, nombre from encabezados where ver_filtros='1' order by nombre";
$r_1 = mysql_query($s_1);
?>
<select name="filtros[2]" class="texto" style="width:150px;" id="filtros">
<option value=""></option>
<?php
while ($d_1 = mysql_fetch_array($r_1)) {
?>
<option value="<?php
echo $d_1['campo'];
?>
" <?php
if ($filtros[2] == $d_1['campo']) {
?>
selected="selected"<?php
}
?>
>
<?php
echo $d_1['nombre'];
?>
</option><?php
}
?>
</select></td>
<td align="center"><input type="radio" value="no" name="aplica_oes" <?php
if ($aplica_oes == 'no') {
?>
checked="checked"<?php
}
?>
onclick='filtro_oes();'> NO</td>
</tr>
</table><br>
<table align="center" border="0" cellpadding="0" cellspacing="0">
<tr>
<td width="150" align="center" valign="middle">
<input type="button" value="Buscar" class="submit" name="boton" onclick="search();" <?php
if ($boton == 1) {
?>
disabled='disabled' <?php
}
?>
></td>
<td width="150" align="center" valign="middle">
<input type="button" value="Exportar" class="submit" onclick="exportar();"></td>
<td width="150" align="center" valign="middle">
<a class='personalizar' href='personalizar.php?op=personalizar&reporte=preliminar'>
<img src="../imagenes/personalizar.png" border="0" width="120"></a></td>
</tr>
</table></form>
<?php
if (!$fechai) {
$fechai = date("Y-m-d");
}
if (!$fechaf) {
$fechaf = date("Y-m-d");
}
$s_f = "select folios.*, partes.no_parte, partes.descripcion, partes.cantidad, partes.total as costo_total, partes.ubicacion, ";
$s_f .= "partes.docto_sap, partes.deficit, partes.tipo, partes.padre, partes.batch_id, partes.serial_unidad, partes.tipo_sub ";
$s_f .= "from scrap_partes as partes, scrap_folios as folios, autorizaciones, numeros_parte ";
$s_f .= "where folios.no_folio = partes.no_folio and autorizaciones.no_folio = folios.no_folio and partes.no_parte = numeros_parte.nombre ";
for ($i = 0; $i <= 2; $i++) {
if ($buscar[$i] != '' && $filtros[$i] != '') {
$s_f .= " and ( ";
$data = split(",", $buscar[$i]);
for ($j = 0; $j < count($data); $j++) {
$s_f .= get_operador($filtros[$i], $data[$j]) . " or ";
}
$s_f = substr($s_f, 0, -3) . " ) ";
}
}
if ($fechai != '' && $fechaf != '') {
$s_f .= "and (fecha>='{$fechai}' and fecha<='{$fechaf}') ";
}
if ($aplica_oes == 'si') {
$s_f .= " and autorizaciones.depto = 'oes' ";
}
for ($i = 0; $i <= 2; $i++) {
if ($filtros[$i] != '') {
$por_folio = '1';
}
}
if ($por_folio != '1') {
if ($_SESSION["TYPE"] != 'autorizador') {
$s_f .= filtros_capturista();
}
if ($_SESSION["TYPE"] == 'autorizador') {
$s_f .= filtros_autorizador();
}
}
$s_f .= "group by partes.id order by folios.no_folio asc";
$r_1 = mysql_query($s_f);
$tot = mysql_num_rows($r_1);
$pags = ceil($tot / 100);
$ini_ = ($pagina - 1) * 100;
$i = 1;
$j = 0;
$ruta = "&fechai={$fechai}&fechaf={$fechaf}&reason={$reason}&buscar[0]={$buscar['0']}&filtros[0]={$filtros['0']}";
$ruta .= "&buscar[1]={$buscar['1']}&filtros[1]={$filtros['1']}&buscar[2]={$buscar['2']}&filtros[2]={$filtros['2']}";
if ($tot > 0) {
?>
<table align="center" border="0" class="texto" cellpadding="0" cellspacing="0">
<tr>
<td width="110" align="center" bgcolor="#BDBDBD" class="link_paginas"><?php
echo $tot;
?>
Registros</td>
<td align="center" valign="top" bgcolor="#BDBDBD">
<table align="center" border="0" class="texto" cellpadding="0" cellspacing="2">
<?php
while ($i <= $pags) {
if ($j >= 30) {
echo "</tr>";
$j = 0;
}
if ($j == 0) {
echo "<tr height='20'>";
}
if ($pagina == $i) {
$color = '#FFBF00';
} else {
$color = '#F2F2F2';
}
?>
<td width="30" align="center" bgcolor="<?php
echo $color;
?>
">
<a href="?op=listado<?php
echo $ruta;
?>
&pagina=<?php
echo $i;
?>
" class="link_paginas"><?php
echo $i;
?>
</a></td>
<?php
$i++;
$j++;
}
?>
</table>
</td>
</tr>
</table><br><?php
}
?>
<table align="center" class="tabla">
<tr bgcolor="#E6E6E6" height="20">
<td rowspan="2"> </td>
<?php
$original = 0;
$s_e = "select encabezados.nombre, reportes.campo from encabezados, reportes where reportes.id_emp='{$_SESSION['IDEMP']}' and ";
$s_e .= "reportes.reporte = 'preliminar' and reportes.pantalla!='0' and reportes.campo=encabezados.campo ";
$s_e .= "order by pantalla, nombre";
$r_e = mysql_query($s_e);
$i = 0;
while ($d_e = mysql_fetch_array($r_e)) {
if ($d_e['campo'] == 'cod_original') {
$original = 1;
?>
<td align="center" colspan="3"><?php
echo $d_e['nombre'];
?>
</td>
<?php
} else {
?>
<td align="center" rowspan="2"><?php
echo $d_e['nombre'];
?>
</td><?php
}
?>
<?php
$campos[$i] = $d_e['campo'];
$i++;
}
?>
<td align="center" colspan="11">Autorización</td>
</tr>
<tr bgcolor="#E6E6E6" height="20">
<?php
if ($original == '1') {
?>
<td align="center" width="150">Defecto</td>
<td align="center" width="120">Tecnología</td>
<td align="center" width="70">Código</td>
<?php
}
?>
<td align="center" width="30">LO</td>
<td align="center" width="30">LOA</td>
<td align="center" width="30">LPL</td>
<td align="center" width="30">FFM</td>
<td align="center" width="30">FFC</td>
<td align="center" width="30">Prod</td>
<td align="center" width="30">SQM</td>
<td align="center" width="30">Finanzas</td>
<td align="center" width="30">ESP</td>
<td align="center" width="30">OES</td>
<td align="center" width="30">Inv</td>
</tr>
</thead>
<tbody>
<?php
$mouse_over = "this.style.background='#FFDD99'";
$mouse_out = "this.style.background='#F7F7F7'";
$s_f .= " limit {$ini_}, 100";
$r_1 = mysql_query($s_f);
while ($d_1 = mysql_fetch_array($r_1)) {
if ($d_1['activo'] == '1') {
$qty = 0 + $qty + $d_1['cantidad'];
$cost = 0 + $cost + $d_1['costo_total'];
}
echo "<tr onMouseOut=\"{$mouse_out}\" onMouseOver=\"{$mouse_over}\" bgcolor=\"#F7F7F7\" height=\"20\">";
?>
<td><a class="frame_ver_boleta" href="../detalles.php?op=historial&folio=<?php
echo $d_1['no_folio'];
?>
">
<img src="../imagenes/history.gif" border="0" alt="Historial"></a></td>
<?php
for ($i = 0; $i < count($campos); $i++) {
switch ($campos[$i]) {
case "costo_total":
echo "<td align='right' class='small'>\$ " . number_format($d_1['costo_total'], 2) . " </td>";
break;
case "cod_original":
$original = data_codigo_original($d_1['no_folio'], $d_1['financiero']);
echo "<td align='left' class='small'> " . $original['defecto'] . "</td>";
echo "<td align='left' class='small'> " . $original['estacion'] . "</td>";
echo "<td align='left' class='small'> " . $original['codigo'] . "</td>";
break;
case "docto_sap":
if ($d_1['deficit'] == '1') {
echo "<td align='left' class='small'> Déficit de Stock</td>";
} else {
if ($d_1['docto_sap'] != '0' && $d_1['docto_sap'] != '') {
echo "<td align='left' class='small'> " . $d_1['docto_sap'] . "</td>";
} else {
echo "<td align='left' class='small'> </td>";
}
}
break;
case "info":
echo "<td align='left' class='small'> " . $d_1['info_1'] . $d_1['info_2'] . "</td>";
break;
case "profit_center":
echo "<td align='left' class='small'> " . get_global_pc($d_1['no_parte']) . "</td>";
break;
default:
echo "<td align='left' class='small'> " . $d_1[$campos[$i]] . "</td>";
break;
}
}
?>
<td align="center" class="small"><?php
echo get_bandera("lo", $d_1['no_folio']);
?>
</td>
<td align="center" class="small"><?php
echo get_bandera("loa", $d_1['no_folio']);
?>
</td>
<td align="center" class="small"><?php
echo get_bandera("lpl", $d_1['no_folio']);
?>
</td>
<td align="center" class="small"><?php
echo get_bandera("ffm", $d_1['no_folio']);
?>
</td>
<td align="center" class="small"><?php
echo get_bandera("ffc", $d_1['no_folio']);
?>
</td>
<td align="center" class="small"><?php
echo get_bandera("prod", $d_1['no_folio']);
?>
</td>
<td align="center" class="small"><?php
echo get_bandera("sqm", $d_1['no_folio']);
?>
</td>
<td align="center" class="small"><?php
echo get_bandera("fin", $d_1['no_folio']);
?>
</td>
<td align="center" class="small"><?php
echo get_bandera("esp", $d_1['no_folio']);
?>
</td>
<td align="center" class="small"><?php
echo get_bandera("oes", $d_1['no_folio']);
?>
</td>
<td align="center" class="small"><?php
echo get_bandera("inv", $d_1['no_folio']);
?>
</td>
</tr>
<?php
}
?>
<tr bgcolor="#E6E6E6">
<td> </td>
<?php
for ($i = 0; $i < count($campos); $i++) {
if ($campos[$i] == 'costo_total') {
echo "<td align='right' class='naranja'>\$ " . number_format($cost, 2) . " </td>";
} elseif ($campos[$i] == 'cantidad') {
echo "<td align='right' class='naranja'>{$qty} </td>";
} else {
echo "<td align='right' class='small'> </td>";
}
}
?>
<td align="center" colspan="11"> </td>
</tr>
</tbody>
</table><br><br>
<?php
echo "<script>form1.boton.disabled=false;</script>";
}
function preliminar($fechai, $fechaf, $aplica_oes, $buscar, $filtros, $reporte)
{
$s_e = "select encabezados.nombre, reportes.campo, encabezados.ancho from reportes, encabezados where reportes.id_emp = ";
$s_e .= "'{$_SESSION['IDEMP']}' and reportes.reporte='{$reporte}' and reportes.excel!='0' and reportes.campo=encabezados.campo ";
$s_e .= "order by reportes.excel, encabezados.nombre";
$r_e = mysql_query($s_e);
$i = 0;
$n_e = mysql_num_rows($r_e);
while ($d_e = mysql_fetch_array($r_e)) {
if ($d_e['campo'] == 'cod_original') {
$n_e = $n_e + 2;
}
$campos[$i] = $d_e['campo'];
$nombre[$i] = $d_e['nombre'];
$ancho[$i] = $d_e['ancho'];
$i++;
}
$original = 0;
$n_e = $n_e + 17;
?>
<table align="center" class="tabla" border="0">
<thead>
<tr bgcolor="#E6E6E6" height="20">
<td colspan="<?php
echo $n_e;
?>
" align="center">
<b>REPORTE <?php
echo strtoupper($reporte);
?>
DE SCRAP</b></td>
</tr>
</thead>
</table><br>
<table align="center" border="1">
<thead>
<tr height="20">
<?php
for ($i = 0; $i < count($nombre); $i++) {
if ($campos[$i] == 'cod_original') {
$original = '1';
$rowspan = '2';
?>
<td align="center" bgcolor="#FFCC33" colspan="3"><b><?php
echo $nombre[$i];
?>
</b></td>
<?php
} else {
$original = '0';
$rowspan = '1';
?>
<td align="center" width="<?php
echo $ancho[$i];
?>
" bgcolor="#FFCC33" rowspan="<?php
echo $rowspan;
?>
"><b><?php
echo $nombre[$i];
?>
</b></td><?php
}
}
?>
<td align="center" bgcolor="#FFCC33" rowspan="<?php
echo $rowspan;
?>
"><b>Por qué 1</b></td>
<td align="center" bgcolor="#FFCC33" rowspan="<?php
echo $rowspan;
?>
"><b>Por qué 2</b></td>
<td align="center" bgcolor="#FFCC33" rowspan="<?php
echo $rowspan;
?>
"><b>Por qué 3</b></td>
<td align="center" bgcolor="#FFCC33" rowspan="<?php
echo $rowspan;
?>
"><b>Por qué 4</b></td>
<td align="center" bgcolor="#FFCC33" rowspan="<?php
echo $rowspan;
?>
"><b>Por qué 5</b></td>
<td align="center" width="90" bgcolor="#FFCC33"><b>LO</b></td>
<td align="center" width="90" bgcolor="#FFCC33"><b>LOA</b></td>
<td align="center" width="90" bgcolor="#FFCC33"><b>LPL</b></td>
<td align="center" width="90" bgcolor="#FFCC33"><b>FFM</b></td>
<td align="center" width="90" bgcolor="#FFCC33"><b>FFC</b></td>
<td align="center" width="90" bgcolor="#FFCC33"><b>Prod</b></td>
<td align="center" width="90" bgcolor="#FFCC33"><b>SQM</b></td>
<td align="center" width="90" bgcolor="#FFCC33"><b>Finanzas</b></td>
<td align="center" width="90" bgcolor="#FFCC33"><b>ESP</b></td>
<td align="center" width="90" bgcolor="#FFCC33"><b>OES</b></td>
<td align="center" bgcolor="#FFCC33" colspan="2"><b>INVENTARIOS</b></td>
</tr>
<?php
if ($original == '1') {
?>
<tr height="20">
<td align="center" width="150" bgcolor="#FFCC33"><b>Defecto</b></td>
<td align="center" width="120" bgcolor="#FFCC33"><b>Tecnología</b></td>
<td align="center" width="70" bgcolor="#FFCC33"><b>Código</b></td>
</tr><?php
}
?>
</thead>
<tbody>
<?php
$s_f = "select folios.*, partes.no_parte, partes.descripcion, partes.cantidad, partes.total as costo_total, partes.ubicacion, ";
$s_f .= "partes.docto_sap, partes.deficit, partes.tipo, partes.padre, partes.batch_id, partes.serial_unidad, partes.tipo_sub ";
$s_f .= "from scrap_partes as partes, scrap_folios as folios, autorizaciones, numeros_parte where folios.no_folio = partes.no_folio and ";
$s_f .= "autorizaciones.no_folio = folios.no_folio and partes.no_parte = numeros_parte.nombre ";
for ($i = 0; $i <= 2; $i++) {
if ($buscar[$i] != '' && $filtros[$i] != '') {
$s_f .= " and ( ";
$data = split(",", $buscar[$i]);
for ($j = 0; $j < count($data); $j++) {
$s_f .= get_operador($filtros[$i], $data[$j]) . " or ";
}
$s_f = substr($s_f, 0, -3) . " ) ";
}
}
if ($aplica_oes == 'si') {
$s_f .= " and autorizaciones.depto = 'oes' ";
}
if ($fechai != '' && $fechaf != '') {
$s_f .= "and (fecha>='{$fechai}' and fecha<='{$fechaf}') ";
}
if ($_SESSION["TYPE"] != 'autorizador') {
$s_f .= filtros_capturista();
}
if ($_SESSION["TYPE"] == 'autorizador') {
$s_f .= filtros_autorizador();
}
$s_f .= "group by partes.id order by folios.no_folio asc";
$r_1 = mysql_query($s_f);
while ($d_1 = mysql_fetch_array($r_1)) {
if ($d_1['activo'] == '1') {
$qty = $qty + $d_1['cantidad'];
$cost = $cost + $d_1['costo_total'];
}
echo "<tr>";
for ($i = 0; $i < count($campos); $i++) {
switch ($campos[$i]) {
case "cod_original":
$original = data_codigo_original($d_1['no_folio'], $d_1['financiero']);
echo "<td align='left' class='small'> " . $original['defecto'] . "</td>";
echo "<td align='left' class='small'> " . $original['estacion'] . "</td>";
echo "<td align='left' class='small'> " . $original['codigo'] . "</td>";
break;
case "docto_sap":
if ($d_1['deficit'] == '1') {
echo "<td align='left' class='small'> Déficit de Stock</td>";
} else {
if ($d_1['docto_sap'] != '0' && $d_1['docto_sap'] != '') {
echo "<td align='left' class='small'> " . $d_1['docto_sap'] . "</td>";
} else {
echo "<td align='left' class='small'> </td>";
}
}
break;
case "info":
echo "<td align='left'>" . $d_1['info_1'] . $d_1['info_2'] . "</td>";
break;
case "status":
if ($d_1['activo'] == '1') {
if ($d_1['status'] == '0') {
echo "<td align='center' bgcolor='#FFCC00'>Proceso</td>";
}
if ($d_1['status'] == '1') {
echo "<td align='center' bgcolor='#BEF781'>Aprobado</td>";
}
if ($d_1['status'] == '2') {
echo "<td align='center' bgcolor='#F78181'>Cancelado</td>";
}
} else {
echo "<td align='center' bgcolor='#F78181'>Cancelado</td>";
}
break;
case "serial_unidad":
echo "<td align='left'>'" . $d_1[$campos[$i]] . "</td>";
break;
case "profit_center":
echo "<td align='left' class='small'> " . get_global_pc($d_1['no_parte']) . "</td>";
break;
default:
echo "<td align='left'>" . $d_1[$campos[$i]] . "</td>";
break;
}
}
$s_p = "select * from scrap_porques where no_folio='{$d_1['no_folio']}'";
$r_p = mysql_query($s_p);
$d_p = mysql_fetch_array($r_p);
?>
<td align="left"><?php
echo $d_p['porque_1'];
?>
</td>
<td align="left"><?php
echo $d_p['porque_2'];
?>
</td>
<td align="left"><?php
echo $d_p['porque_3'];
?>
</td>
<td align="left"><?php
echo $d_p['porque_4'];
?>
</td>
<td align="left"><?php
echo $d_p['porque_5'];
?>
</td>
<td align="center"><?php
echo get_datos("lo", $d_1['no_folio']);
?>
</td>
<td align="center"><?php
echo get_datos("loa", $d_1['no_folio']);
?>
</td>
<td align="center"><?php
echo get_datos("lpl", $d_1['no_folio']);
?>
</td>
<td align="center"><?php
echo get_datos("ffm", $d_1['no_folio']);
?>
</td>
<td align="center"><?php
echo get_datos("ffc", $d_1['no_folio']);
?>
</td>
<td align="center"><?php
echo get_datos("prod", $d_1['no_folio']);
?>
</td>
<td align="center"><?php
echo get_datos("sqm", $d_1['no_folio']);
?>
</td>
<td align="center"><?php
echo get_datos("fin", $d_1['no_folio']);
?>
</td>
<td align="center"><?php
echo get_datos("esp", $d_1['no_folio']);
?>
</td>
<td align="center"><?php
echo get_datos("oes", $d_1['no_folio']);
?>
</td>
<?php
$s_i = "select fecha, hora from aut_bitacora where depto='inv' and status='1' and fecha!='0000-00-00' and no_folio='{$d_1['no_folio']}'";
$r_i = mysql_query($s_i);
if (mysql_num_rows($r_i) > 0) {
$color = "#BEF781";
} else {
$color = "";
}
$d_i = mysql_fetch_array($r_i);
?>
<td align="center" width="120" bgcolor="<?php
echo $color;
?>
"><?php
echo $d_i['fecha'];
?>
</td>
<td align="center" width="120" bgcolor="<?php
echo $color;
?>
"><?php
echo $d_i['hora'];
?>
</td>
<?php
echo "</tr>";
}
echo "<tr>";
for ($i = 0; $i < count($campos); $i++) {
if ($campos[$i] == 'cod_original') {
echo "<td> </td><td> </td><td> </td>";
} elseif ($campos[$i] == 'costo_total') {
echo "<td align='center' bgcolor='#FFCC33'><b>" . number_format($cost, 2) . "</b></td>";
} elseif ($campos[$i] == 'cantidad') {
echo "<td align='center' bgcolor='#FFCC33'><b>{$qty}</b></td>";
} else {
echo "<td> </td>";
}
}
echo "</tr>";
?>
</tbody>
</table>
<?php
}
