function listado($fechai, $fechaf, $proy_add, $proy_del, $aplica_oes, $buscar, $filtros, $reason, $pagina, $tipo, $editada, $motivo) { if (!$aplica_oes) { $aplica_oes = 'no'; } if ($tipo != 'proceso') { if (!$fechai) { $fechai = date("Y-m-d", mktime(0, 0, 0, date("m"), 1, date("Y"))); } if (!$fechaf) { $fechaf = date("Y-m-d", mktime(0, 0, 0, date("m") + 1, 0, date("Y"))); } } if (!$pagina) { $pagina = 1; } if ($proy_add != '') { $s_ = "insert into filtros values('','proyectos','{$proy_add}','{$_SESSION['IDEMP']}')"; $r_ = mysql_query($s_); } if ($proy_del != '') { if ($proy_del == 'del_all') { $s_ = "delete from filtros where filtro='proyectos' and id_emp='{$_SESSION['IDEMP']}'"; $r_ = mysql_query($s_); } else { $s_ = "delete from filtros where filtro='proyectos' and id_emp='{$_SESSION['IDEMP']}' and valor='{$proy_del}'"; $r_ = mysql_query($s_); } } ?> <div style="margin-left:100px;" class="titulo"> <table align="center" cellpadding="10" cellspacing="0" border="0"> <tr> <td class="titulo" width="190"> <?php if ($tipo == "proceso") { $titulo = "SCRAP EN PROCESO"; } if ($tipo == "aprobados") { $titulo = "SCRAP APROBADO"; } if ($tipo == "cancelados") { $titulo = "SCRAP CANCELADO"; } if ($tipo == "rechazados") { $titulo = "SCRAP RECHAZADO"; } echo $titulo; ?> </td> <td align="left"> <span title="header=[ <?php echo $titulo; ?> ] body=[Usted puede revisar el estado de boleta de scrap en base a los colores y las banderas:<br><br> <table align='center' border='0' cellspacing='2'> <tr bgcolor='#FFFFFF'> <td><img src='../imagenes/flag_orange.gif'></td> <td width=200> Firmas que están pendientes</td> </tr><tr bgcolor='#FFFFFF'> <td><img src='../imagenes/flag_green.gif'></td> <td> Firmas aprobadas</td> </tr><tr bgcolor='#FFFFFF'> <td><img src='../imagenes/flag_red.gif'></td> <td> Firmas rechazadas</td> </tr></table><br>]"><img src="../imagenes/question.gif" width="20" height="20"></span> </td> </tr> </table></div><hr> <div align="center" class="aviso">Utilice los filtros para generar búsquedas. Al cambiar un filtro, haga clic en el botón Buscar para refrescar la información. El reporte muestra toda la información sobre folios en proceso.</div> <form action="consultas.php" method="post" name="form1"> <input type="hidden" name="pagina" value="<?php echo $pagina; ?> " /> <input type="hidden" name="tipo" value="<?php echo $tipo; ?> " /> <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> <?php if ($tipo == 'cancelados') { ?> <td align="center" bgcolor="#E6E6E6">Filtrar Motivos</td><?php } ?> </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="center"> <?php $r_1 = mysql_query(get_proyectos_out($division)); $n_1 = mysql_num_rows($r_1); ?> <select name="proy_add" class="texto" style="width:180px;" onchange="submit();"> <option value="">Sin filtro (<?php echo $n_1; ?> )</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"> <?php $r_1 = mysql_query(get_proyectos_in()); $n_1 = mysql_num_rows($r_1); ?> <select name="proy_del" class="texto" style="width:180px;" onchange="submit();"> <option value="">En filtro (<?php echo $n_1; ?> )</option> <option value="del_all" class="quitar">Quitar 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> <?php if ($tipo == 'cancelados') { ?> <td align="center"> <?php $s_1 = "select * from motivos_cancel where activo='1' order by motivo"; $r_1 = mysql_query($s_1); ?> <select name="motivo" class="texto" style="width:180px;"> <option value=""></option> <?php while ($d_1 = mysql_fetch_array($r_1)) { ?> <option value="<?php echo $d_1['motivo']; ?> " <?php if ($motivo == $d_1['motivo']) { ?> selected <?php } ?> ><?php echo $d_1['motivo']; ?> </option><?php } ?> </select></td><?php } ?> </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 a_proceso='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 a_proceso='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 a_proceso='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> <div align="center" class="texto"><br> <input type="button" value="Buscar" class="submit" onclick="submit();"> <input type="button" value="Exportar" class="submit" onclick="exportar();"> <input type="checkbox" name="reason" value="1" <?php if ($reason == 1) { ?> checked="checked"<?php } ?> > Mostrar reason code <input type="checkbox" name="editada" value="1" <?php if ($editada == 1) { ?> checked="checked"<?php } ?> > Mostrar sólo editadas </div><br></form> <table align="center" border="0" class="texto"> <tr> <td width="20" align="center"><img src="../imagenes/zoom.png" /></td> <td width="60" align="left">Ver Boleta</td> <td width="20" align="center">|</td> <td width="20" align="center"><img src="../imagenes/pencil.gif" /></td> <td width="70" align="left">Editar Boleta</td> <td width="20" align="center">|</td> <td width="20" align="center"><img src="../imagenes/tick.png" /></td> <td width="40" align="left">Editada</td> <td width="20" align="center">|</td> <td width="20" align="center"><img src="../imagenes/information.png" /></td> <td width="40" align="left">Historial</td> <td width="20" align="center">|</td> <td width="20" align="center"><img src="../imagenes/attach.png" /></td> <td width="50" align="left">Evidencias</td> <td width="20" align="center">|</td> <td width="20" align="center"><img src="../imagenes/ayuda.gif" /></td> <td width="40" align="left">Detalles</td> <td width="20" align="center">|</td> <td width="20" align="center"><img src="../imagenes/flag_orange.gif" /></td> <td width="50" align="left">Pendiente</td> <td width="20" align="center">|</td> <td width="20" align="center"><img src="../imagenes/flag_green.gif" /></td> <td width="50" align="left">Aprobado</td> <td width="20" align="center">|</td> <td width="20" align="center"><img src="../imagenes/flag_red.gif" /></td> <td width="50" align="left">Rechazado</td> </tr> </table><br> <?php $s_f = "select * from (select folios.*, sum(partes.cantidad) as cantidad_total, sum(partes.total) as costo_total, (select motivo from aut_bitacora where "; $s_f .= "aut_bitacora.no_folio=folios.no_folio and aut_bitacora.status='3' order by id desc limit 0,1) as motivo from scrap_partes as partes, scrap_folios as folios, "; $s_f .= "autorizaciones where folios.no_folio = partes.no_folio and autorizaciones.no_folio = folios.no_folio "; if ($_SESSION["DEPTO"] != 'esp') { $s_f .= " and autorizaciones.depto='{$_SESSION['DEPTO']}' "; } else { $s_f .= " and (autorizaciones.depto='esp_1' or autorizaciones.depto='esp_2') "; } switch ($tipo) { case "proceso": $s_f .= "and folios.activo='1' and folios.status='0' "; break; case "aprobados": $s_f .= "and folios.activo='1' and folios.status='1' "; break; case "cancelados": $s_f .= "and folios.activo='2' "; break; case "rechazados": $s_f .= "and folios.activo='1' and folios.status='2' "; break; } if ($editada == '1') { $s_f .= "and editada='1' "; } if ($aplica_oes == 'si') { $s_f .= " and autorizaciones.depto = 'oes' "; } if ($fechai != '' && $fechaf != '') { $s_f .= "and (fecha>='{$fechai}' and fecha<='{$fechaf}') "; } 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) . " ) "; } } $s_f .= filtros_autorizador(); $s_f .= " group by folios.no_folio order by folios.no_folio ASC) as general "; if ($motivo != '') { $s_f .= " where motivo like '{$motivo}' "; } $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="consultas.php?tipo=<?php echo $tipo; 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 align="center" width="30"><img src="../imagenes/zoom.png" /></td> <td align="center" width="30"><img src="../imagenes/information.png" /></td> <?php if ($_SESSION["DEPTO"] == 'lo' || $_SESSION["DEPTO"] == 'loa') { $cols = 5; ?> <td align="center" width="25"><img src="../imagenes/attach.png" /></td><?php } else { $cols = 4; } ?> <td align="center" width="30" rowspan="2"><img src="../imagenes/tick.png" /></td> <td align="center" width="50">Folio</td> <td align="center" width="40">Qty</td> <td align="center" width="100">Proyecto</td> <td align="center" width="100">Capturista</td> <?php if ($reason != 1) { ?> <td align="center" width="80">Cod.Scrap</td><?php } ?> <?php if ($reason == 1) { ?> <td align="center" width="80">Reason Code</td><?php } ?> <td align="center" width="80" colspan="2">Cod. Causa Original</td> <td align="center" width="100">Info.Obligatoria</td> <td align="center" width="70">Total</td> <td align="center" width="90">Fecha</td> <?php if ($tipo == 'cancelados') { ?> <td align="center" width="150">Motivo</td><?php } ?> <?php if ($_SESSION["DEPTO"] == 'lo') { $class = 'naranja'; } else { $class = ''; } echo "<td width='60' align='center'><span class={$class}>LO</span></td>"; if ($_SESSION["DEPTO"] == 'loa') { $class = 'naranja'; } else { $class = ''; } echo "<td width='60' align='center'><span class={$class}>LO-A</span></td>"; if ($_SESSION["DEPTO"] == 'lpl') { $class = 'naranja'; } else { $class = ''; } echo "<td width='60' align='center'><span class={$class}>LPL</span></td>"; if ($_SESSION["DEPTO"] == 'ffm') { $class = 'naranja'; } else { $class = ''; } echo "<td width='60' align='center'><span class={$class}>FFM</span></td>"; if ($_SESSION["DEPTO"] == 'ffc') { $class = 'naranja'; } else { $class = ''; } echo "<td width='60' align='center'><span class={$class}>FFC</span></td>"; if ($_SESSION["DEPTO"] == 'prod') { $class = 'naranja'; } else { $class = ''; } echo "<td width='60' align='center'><span class={$class}>Prod</span></td>"; if ($_SESSION["DEPTO"] == 'sqm') { $class = 'naranja'; } else { $class = ''; } echo "<td width='60' align='center'><span class={$class}>SQM</span></td>"; if ($_SESSION["DEPTO"] == 'fin') { $class = 'naranja'; } else { $class = ''; } echo "<td width='60' align='center'><span class={$class}>Finanzas</span></td>"; if ($_SESSION["DEPTO"] == 'esp') { $class = 'naranja'; } else { $class = ''; } echo "<td width='60' align='center'><span class={$class}>ESP</span></td>"; if ($_SESSION["DEPTO"] == 'oes') { $class = 'naranja'; } else { $class = ''; } echo "<td width='60' align='center'><span class={$class}>OES</span></td>"; if ($_SESSION["DEPTO"] == 'inv') { $class = 'naranja'; } else { $class = ''; } echo "<td width='70' align='center'><span class={$class}>Inventarios</span></td>"; ?> </tr> </thead> <tbody> <?php $s_f .= " limit {$ini_},100"; $r_1 = mysql_query($s_f); while ($d_1 = mysql_fetch_array($r_1)) { $qty = $qty + $d_1['cantidad_total']; $cost = $cost + $d_1['costo_total']; ?> <tr onMouseOut="this.style.background='#F7F7F7'" onMouseOver="this.style.background='#FFDD99'" bgcolor="#F7F7F7" height="20"> <td align="center"> <a class="frame_ver_boleta" href="../detalles.php?op=ver_boleta&folio=<?php echo $d_1['no_folio']; ?> &buscar=no"> <img src="../imagenes/zoom.png" border="0"></a></td> <td align="center"> <a class="frame_ver_boleta" href="../detalles.php?op=historial&folio=<?php echo $d_1['no_folio']; ?> &buscar=no"> <img src="../imagenes/information.png" border="0"></a></td> <?php if ($_SESSION["DEPTO"] == 'lo' || $_SESSION["DEPTO"] == 'loa') { ?> <td align="center"> <?php $s_c = "select * from configuracion where variable='ruta_evidencias'"; $r_c = mysql_query($s_c); $d_c = mysql_fetch_array($r_c); $ruta = $d_c['valor'] . $d_1['archivo']; if ($d_1['archivo'] != '') { ?> <a href="<?php echo $ruta; ?> " target="_blank"> <img src="../imagenes/attach.png" border="0"></a><?php } ?> </td><?php } ?> <td align="center"> <?php if ($d_1['editada'] == '1') { ?> <img src="../imagenes/tick.png" border="0"><?php } else { echo " "; } ?> </td> <td align="center"><?php echo $d_1['no_folio']; ?> </td> <td align="center"><?php echo $d_1['cantidad_total']; ?> </td> <td align="left"> <?php echo $d_1['proyecto']; ?> </td> <td align="left"> <?php echo $d_1['empleado']; ?> </td> <?php if ($reason != 1) { ?> <td align="center"><?php echo $d_1['codigo_scrap']; ?> </td><?php } ?> <?php if ($reason == 1) { ?> <td align="center"><?php echo $d_1['reason_code']; ?> </td><?php } ?> <td align="center" width="60"> <?php $original = data_codigo_original($d_1['no_folio'], $d_1['financiero']); echo $original['codigo']; ?> </td> <td align="center" width="20"> <?php if ($d_1['financiero'] == '1') { ?> <span title='header=[ Código de Causa Original] body=[<?php echo detalles_codigo_original($d_1['no_folio']); ?> ]'> <img src="../imagenes/ayuda.gif" style="cursor: hand;"></span><?php } ?> </td> <td align="center"><?php if ($d_1['info_1'] != 'NA') { echo $d_1['info_1'] . "-" . $d_1['info_2']; } else { echo "NA"; } ?> </td> <td align="right"><?php echo "\$ " . number_format($d_1['costo_total'], 2); ?> </td> <td align="center"><?php echo fecha_dmy($d_1['fecha']); ?> </td> <?php if ($tipo == 'cancelados') { ?> <td align="left"> <?php echo $d_1['motivo']; ?> </td><?php } ?> <td align="center"><?php echo get_bandera("lo", $d_1['no_folio']); ?> </td> <td align="center"><?php echo get_bandera("loa", $d_1['no_folio']); ?> </td> <td align="center"><?php echo get_bandera("lpl", $d_1['no_folio']); ?> </td> <td align="center"><?php echo get_bandera("ffm", $d_1['no_folio']); ?> </td> <td align="center"><?php echo get_bandera("ffc", $d_1['no_folio']); ?> </td> <td align="center"><?php echo get_bandera("prod", $d_1['no_folio']); ?> </td> <td align="center"><?php echo get_bandera("sqm", $d_1['no_folio']); ?> </td> <td align="center"><?php echo get_bandera("fin", $d_1['no_folio']); ?> </td> <td align="center"><?php echo get_bandera("esp", $d_1['no_folio']); ?> </td> <td align="center"><?php echo get_bandera("oes", $d_1['no_folio']); ?> </td> <td align="center"><?php echo get_bandera("inv", $d_1['no_folio']); ?> </td> </tr> <?php } if ($qty > 0) { ?> <tr onMouseOut="this.style.background='#E6E6E6'" onMouseOver="this.style.background='#FFDD99'" bgcolor="#E6E6E6" height="20"> <td colspan="<?php echo $cols; ?> "> </td> <td align="center" class="naranja"><b><?php echo $qty; ?> </b></td> <td colspan="5"> </td> <td align="right" class="naranja"><b><?php echo "\$ " . number_format($cost, 2); ?> </b></td> <td colspan="13"> </td> </tr><?php } ?> </tbody> </table><br><br><br> <?php }
function listado($fechai, $fechaf, $proy_add, $proy_del, $buscar, $filtros, $reason, $editados, $pagina) { if (!$pagina) { $pagina = 1; } if ($proy_add != '') { $s_ = "insert into filtros values('','proyectos','{$proy_add}','{$_SESSION['IDEMP']}')"; $r_ = mysql_query($s_); } if ($proy_del != '') { if ($proy_del == 'del_all') { $s_ = "delete from filtros where filtro='proyectos' and id_emp='{$_SESSION['IDEMP']}'"; $r_ = mysql_query($s_); } else { $s_ = "delete from filtros where filtro='proyectos' and id_emp='{$_SESSION['IDEMP']}' and valor='{$proy_del}'"; $r_ = mysql_query($s_); } } /*$s_2 = "select vw_reportes.*, bitacora.status from vw_reportes_".$_SESSION["IDEMP"]." vw_reportes "; $s_2.= "INNER JOIN (select MAX(id) as primera, no_folio, status from aut_bitacora group by no_folio) as aut ON aut.no_folio = vw_reportes.no_folio "; $s_2.= "INNER JOIN aut_bitacora bitacora ON aut.primera = bitacora.id "; if($editados=='1') { $s_2.= " where bitacora.status='5' "; } */ $s_2 = "select * from vw_reportes_" . $_SESSION["IDEMP"] . " vw_reportes"; if (mysql_query($s_2)) { $r_2 = mysql_query($s_2); $total = mysql_num_rows($r_2); } ?> <div align="center" class="aviso">Utilice los filtros para generar búsquedas. Al cambiar un filtro, haga clic en el botón Buscar para refrescar la información. El reporte muestra toda la información sobre folios en proceso.</div> <form action="?op=listado" method="post" name="form1"> <input type="hidden" name="pagina" value="<?php echo $pagina; ?> " /> <table align="center" class="tabla"> <tr height="20"> <td align="center" width="100" bgcolor="#E6E6E6">Incio 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="center"> <?php $r_1 = mysql_query(get_proyectos_out($division)); $n_1 = mysql_num_rows($r_1); ?> <select name="proy_add" class="texto" style="width:180px;" onchange="submit();"> <option value="">Sin filtro (<?php echo $n_1; ?> )</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"> <?php $r_1 = mysql_query(get_proyectos_in()); $n_1 = mysql_num_rows($r_1); ?> <select name="proy_del" class="texto" style="width:180px;" onchange="submit();"> <option value="">En filtro (<?php echo $n_1; ?> )</option> <option value="del_all" class="quitar">Quitar 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 a_rechazados='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> </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 a_rechazados='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> </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 a_rechazados='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> </tr> </table> <div align="center" class="texto"><br> <input type="button" value="Buscar" class="submit" onclick="validar('reporte');"> <input type="button" value="Exportar" class="submit" onclick="validar('excel');" <?php if ($total <= 0) { ?> disabled <?php } ?> > <input type="checkbox" name="reason" value="1" <?php if ($reason == 1) { ?> checked="checked"<?php } ?> > Mostrar Reason code <input type="checkbox" name="editados" value="1" <?php if ($editados == 1) { ?> checked="checked"<?php } ?> > Sólo folios editados </div><br></form> <table align="center" border="0" class="texto"> <tr> <td width="20" align="center"><img src="../imagenes/zoom.png" /></td> <td width="60" align="left">Ver Boleta</td> <td width="20" align="center">|</td> <td width="20" align="center"><img src="../imagenes/pencil.gif" /></td> <td width="70" align="left">Editar Boleta</td> <td width="20" align="center">|</td> <td width="20" align="center"><img src="../imagenes/tick.png" /></td> <td width="40" align="left">Editada</td> <td width="20" align="center">|</td> <td width="20" align="center"><img src="../imagenes/information.png" /></td> <td width="40" align="left">Historial</td> <td width="20" align="center">|</td> <td width="20" align="center"><img src="../imagenes/attach.png" /></td> <td width="50" align="left">Evidencias</td> <td width="20" align="center">|</td> <td width="20" align="center"><img src="../imagenes/ayuda.gif" /></td> <td width="40" align="left">Detalles</td> <td width="20" align="center">|</td> <td width="20" align="center"><img src="../imagenes/flag_orange.gif" /></td> <td width="50" align="left">Pendiente</td> <td width="20" align="center">|</td> <td width="20" align="center"><img src="../imagenes/flag_green.gif" /></td> <td width="50" align="left">Aprobado</td> <td width="20" align="center">|</td> <td width="20" align="center"><img src="../imagenes/flag_red.gif" /></td> <td width="50" align="left">Rechazado</td> </tr> </table><br> <?php $pags = ceil($total / 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 ($total > 0 && $editados != '1') { ?> <table align="center" border="0" class="texto" cellpadding="0" cellspacing="0"> <tr> <td width="110" align="center" bgcolor="#BDBDBD" class="link_paginas"><?php echo $total; ?> 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 align="center" width="30"><img src="../imagenes/zoom.png" /></td> <td align="center" width="30"><img src="../imagenes/information.png" /></td> <?php if ($_SESSION["DEPTO"] == 'lo' || $_SESSION["DEPTO"] == 'loa') { $cols = 5; ?> <td align="center" width="25"><img src="../imagenes/attach.png" /></td><?php } else { $cols = 4; } ?> <td align="center" width="30" rowspan="2"><img src="../imagenes/tick.png" /></td> <td align="center" width="50">Folio</td> <td align="center" width="40">Qty</td> <td align="center" width="100">Proyecto</td> <?php if ($reason != 1) { ?> <td align="center" width="80">Cod.Scrap</td><?php } ?> <?php if ($reason == 1) { ?> <td align="center" width="80">Reason Code</td><?php } ?> <td align="center" width="80" colspan="2">Cod. Causa Original</td> <td align="center" width="100">Info.Obligatoria</td> <td align="center" width="70">Total</td> <td align="center" width="90">Fecha</td> <?php if ($_SESSION["DEPTO"] == 'lo') { $class = 'naranja'; } else { $class = ''; } echo "<td width='60' align='center'><span class={$class}>LO</span></td>"; if ($_SESSION["DEPTO"] == 'loa') { $class = 'naranja'; } else { $class = ''; } echo "<td width='60' align='center'><span class={$class}>LO-A</span></td>"; if ($_SESSION["DEPTO"] == 'lpl') { $class = 'naranja'; } else { $class = ''; } echo "<td width='60' align='center'><span class={$class}>LPL</span></td>"; if ($_SESSION["DEPTO"] == 'ffm') { $class = 'naranja'; } else { $class = ''; } echo "<td width='60' align='center'><span class={$class}>FFM</span></td>"; if ($_SESSION["DEPTO"] == 'ffc') { $class = 'naranja'; } else { $class = ''; } echo "<td width='60' align='center'><span class={$class}>FFC</span></td>"; if ($_SESSION["DEPTO"] == 'prod') { $class = 'naranja'; } else { $class = ''; } echo "<td width='60' align='center'><span class={$class}>Prod</span></td>"; if ($_SESSION["DEPTO"] == 'sqm') { $class = 'naranja'; } else { $class = ''; } echo "<td width='60' align='center'><span class={$class}>SQM</span></td>"; if ($_SESSION["DEPTO"] == 'inv') { $class = 'naranja'; } else { $class = ''; } echo "<td width='70' align='center'><span class={$class}>Inventarios</span></td>"; ?> </tr> </thead> <tbody> <?php if ($total > 0) { if ($editados == '1') { $s_2 .= " order by no_folio desc "; } else { $s_2 .= " order by no_folio desc limit {$ini_},100"; } $r_1 = mysql_query($s_2); while ($d_1 = mysql_fetch_array($r_1)) { $qty = $qty + $d_1['cantidad_total']; $cost = $cost + $d_1['costo_total']; $edit = fue_editado($d_1['no_folio']); if ($edit == 'SI' && $editados == '1' || !$editados) { ?> <tr onMouseOut="this.style.background='#F7F7F7'" onMouseOver="this.style.background='#FFDD99'" bgcolor="#F7F7F7" height="20"> <td align="center"> <a class="frame_ver_boleta" href="../detalles.php?op=ver_boleta&folio=<?php echo $d_1['no_folio']; ?> &buscar=no"> <img src="../imagenes/zoom.png" border="0"></a></td> <td align="center"> <a class="frame_ver_boleta" href="../detalles.php?op=historial&folio=<?php echo $d_1['no_folio']; ?> &buscar=no"> <img src="../imagenes/information.png" border="0"></a></td> <?php if ($_SESSION["DEPTO"] == 'lo' || $_SESSION["DEPTO"] == 'loa') { ?> <td align="center"> <?php $s_c = "select * from configuracion where variable='ruta_evidencias'"; $r_c = mysql_query($s_c); $d_c = mysql_fetch_array($r_c); $ruta = $d_c['valor'] . $d_1['archivo']; if ($d_1['archivo'] != '') { ?> <a href="<?php echo $ruta; ?> " target="_blank"> <img src="../imagenes/attach.png" border="0"></a><?php } ?> </td><?php } ?> <td align="center"> <?php $s_b = "select status from aut_bitacora where no_folio='{$d_1['no_folio']}' order by id desc"; $r_b = mysql_query($s_b); $d_b = mysql_fetch_array($r_b); if ($d_b['status'] == '5') { ?> <img src="../imagenes/tick.png" border="0"><?php } else { echo " "; } ?> </td> <td align="center"><?php echo $d_1['no_folio']; ?> </td> <td align="center"><?php echo $d_1['cantidad_total']; ?> </td> <td align="left"> <?php echo $d_1['proyecto']; ?> </td> <?php if ($reason != 1) { ?> <td align="center"><?php echo $d_1['codigo_scrap']; ?> </td><?php } ?> <?php if ($reason == 1) { ?> <td align="center"><?php echo $d_1['reason_code']; ?> </td><?php } ?> <td align="center" width="60"> <?php $original = data_codigo_original($d_1['no_folio'], $d_1['financiero']); echo $original['codigo']; ?> </td> <td align="center" width="20"> <?php if ($d_1['financiero'] == '1') { ?> <span title='header=[ Código de Causa Original] body=[<?php echo detalles_codigo_original($d_1['no_folio']); ?> ]'> <img src="../imagenes/ayuda.gif" style="cursor: hand;"></span><?php } ?> </td> <td align="center"><?php if ($d_1['info_1'] != 'NA') { echo $d_1['info_1'] . "-" . $d_1['info_2']; } else { echo "NA"; } ?> </td> <td align="right"><?php echo "\$ " . number_format($d_1['costo_total'], 2); ?> </td> <td align="center"><?php echo fecha_dmy($d_1['fecha']); ?> </td> <td align="center"><?php echo get_bandera("lo", $d_1['no_folio']); ?> </td> <td align="center"><?php echo get_bandera("loa", $d_1['no_folio']); ?> </td> <td align="center"><?php echo get_bandera("lpl", $d_1['no_folio']); ?> </td> <td align="center"><?php echo get_bandera("ffm", $d_1['no_folio']); ?> </td> <td align="center"><?php echo get_bandera("ffc", $d_1['no_folio']); ?> </td> <td align="center"><?php echo get_bandera("prod", $d_1['no_folio']); ?> </td> <td align="center"><?php echo get_bandera("sqm", $d_1['no_folio']); ?> </td> <td align="center"><?php echo get_bandera("inv", $d_1['no_folio']); ?> </td> </tr> <?php } } if ($qty > 0) { ?> <tr onMouseOut="this.style.background='#E6E6E6'" onMouseOver="this.style.background='#FFDD99'" bgcolor="#E6E6E6" height="20"> <td colspan="<?php echo $cols; ?> "> </td> <td align="center" class="naranja"><b><?php echo $qty; ?> </b></td> <td colspan="5"> </td> <td align="right" class="naranja"><b><?php echo "\$ " . number_format($cost, 2); ?> </b></td> <td colspan="9"> </td> </tr><?php } } ?> </tbody> </table><br><br><br> <?php }
function listado($fechai, $fechaf, $proy_add, $proy_del, $buscar, $filtros, $pagina) { if (!$fechai) { $fechai = date("Y-m-d"); } if (!$fechaf) { $fechaf = date("Y-m-d"); } if (!$pagina) { $pagina = 1; } if ($proy_add != '') { $s_1 = "insert into filtros values('','proyectos_','{$proy_add}','{$_SESSION['IDEMP']}')"; $r_1 = mysql_query($s_1); } if ($proy_del != '') { if ($proy_del == 'del_all') { $s_1 = "delete from filtros where filtro='proyectos_' and id_emp='{$_SESSION['IDEMP']}'"; $r_1 = mysql_query($s_1); } else { $s_1 = "delete from filtros where filtro='proyectos_' and id_emp='{$_SESSION['IDEMP']}' and valor='{$proy_del}'"; $r_1 = mysql_query($s_1); } } $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, numeros_parte where folios.no_folio = partes.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}') "; } $s_ = "select valor from filtros where id_emp='{$_SESSION['IDEMP']}' and filtro='proyectos_'"; $r_ = mysql_query($s_); if (mysql_num_rows($r_) > 0) { $s_f .= "and ( "; while ($d_ = mysql_fetch_array($r_)) { $s_f .= "folios.id_proyecto = '{$d_['valor']}' or "; } $s_f = substr($s_f, 0, -3) . " ) "; } $r_1 = mysql_query($s_f); $tot = mysql_num_rows($r_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="center"> <?php $r_1 = mysql_query(get_proyectos_out($division)); $n_1 = mysql_num_rows($r_1); ?> <select name="proy_add" class="texto" style="width:180px;" onchange="submit();"> <option value="">Sin filtro (<?php echo $n_1; ?> )</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"> <?php $r_1 = mysql_query(get_proyectos_in()); $n_1 = mysql_num_rows($r_1); ?> <select name="proy_del" class="texto" style="width:180px;" onchange="submit();"> <option value="">En filtro (<?php echo $n_1; ?> )</option> <option value="del_all" class="quitar">Quitar 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> </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> </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> </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" onclick="validar('reporte');"></td> <td width="150" align="center" valign="middle"> <input type="button" value="Exportar" class="submit" onclick="validar('excel');"></td> <td width="150" align="center" valign="middle"> <a class='personalizar' href='personalizar.php?op=personalizar&reporte=general'> <img src="../imagenes/personalizar.png" border="0" width="120"></a></td> </tr> </table></form> <?php $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"> <?php $s_e = "select encabezados.nombre, reportes.campo from encabezados, reportes where reportes.id_emp='{$_SESSION['IDEMP']}' and "; $s_e .= "reportes.reporte = 'general' 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="9">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">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\">"; 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 { echo "<td align='left' class='small'> " . $d_1['docto_sap'] . "</td>"; } break; case "info": echo "<td align='left' class='small'> " . $d_1['info_1'] . $d_1['info_2'] . "</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("inv", $d_1['no_folio']); ?> </td> </tr> <?php } ?> <tr bgcolor="#E6E6E6"> <?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="9"> </td> </tr> </tbody> </table><br><br> <?php }
function listado($fechai, $fechaf, $proy_add, $proy_del, $buscar, $filtros, $reason, $editados, $pagina, $op) { if (!$pagina) { $pagina = 1; } if ($op == 'aprobados') { if (!$fechai) { $fechai = date("Y-m-d", mktime(0, 0, 0, date("m"), 1, date("Y"))); } if (!$fechaf) { $fechaf = date("Y-m-d", mktime(0, 0, 0, date("m") + 1, 0, date("Y"))); } } ?> <table align="center" border="0" class="texto"> <tr> <td width="20" align="center"><img src="../imagenes/zoom.png" /></td> <td width="60" align="left">Ver Boleta</td> <td width="20" align="center">|</td> <td width="20" align="center"><img src="../imagenes/pencil.gif" /></td> <td width="70" align="left">Editar Boleta</td> <td width="20" align="center">|</td> <td width="20" align="center"><img src="../imagenes/tick.png" /></td> <td width="40" align="left">Editada</td> <td width="20" align="center">|</td> <td width="20" align="center"><img src="../imagenes/information.png" /></td> <td width="40" align="left">Historial</td> <td width="20" align="center">|</td> <td width="20" align="center"><img src="../imagenes/attach.png" /></td> <td width="50" align="left">Evidencias</td> <td width="20" align="center">|</td> <td width="20" align="center"><img src="../imagenes/ayuda.gif" /></td> <td width="40" align="left">Detalles</td> <td width="20" align="center">|</td> <td width="20" align="center"><img src="../imagenes/flag_orange.gif" /></td> <td width="50" align="left">Pendiente</td> <td width="20" align="center">|</td> <td width="20" align="center"><img src="../imagenes/flag_green.gif" /></td> <td width="50" align="left">Aprobado</td> <td width="20" align="center">|</td> <td width="20" align="center"><img src="../imagenes/flag_red.gif" /></td> <td width="50" align="left">Rechazado</td> </tr> </table><br> <?php $s_1 = "select no_folio, id_emp, fecha, sum(cantidad) as cantidad_total, planta, carga_masiva, proyecto, id_division, division, profit_center, area, codigo_scrap, "; $s_1 .= "reason_code, sum(total) as costo_total, financiero, archivo, info_1, info_2, editado from "; switch ($op) { case "proceso": $s_1 .= "vw_pendientes "; break; case "rechazados": $s_1 .= "vw_rechazados "; break; case "cancelados": $s_1 .= "vw_cancelados "; break; case "aprobados": $s_1 .= "vw_aprobados "; break; } $s_1 .= "where no_folio!='0' "; if ($fechai != '' && $fechaf != '') { $s_1 .= "and (fecha>='{$fechai}' and fecha<='{$fechaf}') "; } if ($editados == '1') { $s_1 .= "and editado='1' "; } for ($i = 0; $i <= 2; $i++) { if ($buscar[$i] != '' && $filtros[$i] != '') { $s_1 .= " and ( "; $data = split(",", $buscar[$i]); for ($j = 0; $j < count($data); $j++) { $s_1 .= get_operador($filtros[$i], $data[$j]) . " or "; } $s_1 = substr($s_1, 0, -3) . " ) "; } } $s_1 .= filtros_autorizador($division); $s_1 .= " group by no_folio"; $r_1 = mysql_query($s_1); $total = mysql_num_rows($r_1); $pags = ceil($total / 100); $ini_ = ($pagina - 1) * 100; $i = 1; $j = 0; $ruta = "&op={$op}&fechai={$fechai}&fechaf={$fechaf}&reason={$reason}&tipo={$tipo}&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 ($total > 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 $total; ?> 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 align="center" width="40"> </td> <td align="center" width="30"><img src="../imagenes/zoom.png" /></td> <td align="center" width="30"><img src="../imagenes/information.png" /></td> <?php if ($_SESSION["DEPTO"] == 'lo' || $_SESSION["DEPTO"] == 'loa') { $cols = 6; ?> <td align="center" width="25"><img src="../imagenes/attach.png" /></td><?php } else { $cols = 5; } ?> <td align="center" width="30" rowspan="2"><img src="../imagenes/tick.png" /></td> <td align="center" width="50">Folio</td> <td align="center" width="40">Qty</td> <td align="center" width="100">Proyecto</td> <?php if ($reason != 1) { ?> <td align="center" width="80">Cod.Scrap</td><?php } ?> <?php if ($reason == 1) { ?> <td align="center" width="80">Reason Code</td><?php } ?> <td align="center" width="80" colspan="2">Cod. Causa Original</td> <td align="center" width="100">Info.Obligatoria</td> <td align="center" width="70">Total</td> <td align="center" width="90">Fecha</td> <?php if ($_SESSION["DEPTO"] == 'lo') { $class = 'naranja'; } else { $class = ''; } echo "<td width='60' align='center'><span class={$class}>LO</span></td>"; if ($_SESSION["DEPTO"] == 'loa') { $class = 'naranja'; } else { $class = ''; } echo "<td width='60' align='center'><span class={$class}>LO-A</span></td>"; if ($_SESSION["DEPTO"] == 'lpl') { $class = 'naranja'; } else { $class = ''; } echo "<td width='60' align='center'><span class={$class}>LPL</span></td>"; if ($_SESSION["DEPTO"] == 'ffm') { $class = 'naranja'; } else { $class = ''; } echo "<td width='60' align='center'><span class={$class}>FFM</span></td>"; if ($_SESSION["DEPTO"] == 'ffc') { $class = 'naranja'; } else { $class = ''; } echo "<td width='60' align='center'><span class={$class}>FFC</span></td>"; if ($_SESSION["DEPTO"] == 'prod') { $class = 'naranja'; } else { $class = ''; } echo "<td width='60' align='center'><span class={$class}>Prod</span></td>"; if ($_SESSION["DEPTO"] == 'sqm') { $class = 'naranja'; } else { $class = ''; } echo "<td width='60' align='center'><span class={$class}>SQM</span></td>"; if ($_SESSION["DEPTO"] == 'inv') { $class = 'naranja'; } else { $class = ''; } echo "<td width='70' align='center'><span class={$class}>Inventarios</span></td>"; ?> </tr> </thead> <tbody> <?php if ($total > 0) { $s_1 .= " order by no_folio desc limit {$ini_},100"; $r_1 = mysql_query($s_1); $i = $ini_ + 1; while ($d_1 = mysql_fetch_array($r_1)) { $qty = $qty + $d_1['cantidad_total']; $cost = $cost + $d_1['costo_total']; ?> <tr onMouseOut="this.style.background='#F7F7F7'" onMouseOver="this.style.background='#FFDD99'" bgcolor="#F7F7F7" height="20"> <td align="center"><?php echo $i; ?> </td> <td align="center"> <a class="frame_ver_boleta" href="../detalles.php?op=ver_boleta&folio=<?php echo $d_1['no_folio']; ?> &buscar=no"> <img src="../imagenes/zoom.png" border="0"></a></td> <td align="center"> <a class="frame_ver_boleta" href="../detalles.php?op=historial&folio=<?php echo $d_1['no_folio']; ?> &buscar=no"> <img src="../imagenes/information.png" border="0"></a></td> <?php if ($_SESSION["DEPTO"] == 'lo' || $_SESSION["DEPTO"] == 'loa') { ?> <td align="center"> <?php $s_c = "select * from configuracion where variable='ruta_evidencias'"; $r_c = mysql_query($s_c); $d_c = mysql_fetch_array($r_c); $ruta = $d_c['valor'] . $d_1['archivo']; if ($d_1['archivo'] != '') { ?> <a href="<?php echo $ruta; ?> " target="_blank"> <img src="../imagenes/attach.png" border="0"></a><?php } ?> </td><?php } ?> <td align="center"> <?php if ($d_1['editado'] == '1') { ?> <img src="../imagenes/tick.png" border="0"><?php } else { echo " "; } ?> </td> <td align="center"><?php echo $d_1['no_folio']; ?> </td> <td align="center"><?php echo $d_1['cantidad_total']; ?> </td> <td align="left"> <?php echo $d_1['proyecto']; ?> </td> <?php if ($reason != 1) { ?> <td align="center"><?php echo $d_1['codigo_scrap']; ?> </td><?php } ?> <?php if ($reason == 1) { ?> <td align="center"><?php echo $d_1['reason_code']; ?> </td><?php } ?> <td align="center" width="60"> <?php $original = data_codigo_original($d_1['no_folio'], $d_1['financiero']); echo $original['codigo']; ?> </td> <td align="center" width="20"> <?php if ($d_1['financiero'] == '1') { ?> <span title='header=[ Código de Causa Original] body=[<?php echo detalles_codigo_original($d_1['no_folio']); ?> ]'> <img src="../imagenes/ayuda.gif" style="cursor: hand;"></span><?php } ?> </td> <td align="center"><?php if ($d_1['info_1'] != 'NA') { echo $d_1['info_1'] . "-" . $d_1['info_2']; } else { echo "NA"; } ?> </td> <td align="right"><?php echo "\$ " . number_format($d_1['costo_total'], 2); ?> </td> <td align="center"><?php echo fecha_dmy($d_1['fecha']); ?> </td> <td align="center"><?php echo get_bandera("lo", $d_1['no_folio']); ?> </td> <td align="center"><?php echo get_bandera("loa", $d_1['no_folio']); ?> </td> <td align="center"><?php echo get_bandera("lpl", $d_1['no_folio']); ?> </td> <td align="center"><?php echo get_bandera("ffm", $d_1['no_folio']); ?> </td> <td align="center"><?php echo get_bandera("ffc", $d_1['no_folio']); ?> </td> <td align="center"><?php echo get_bandera("prod", $d_1['no_folio']); ?> </td> <td align="center"><?php echo get_bandera("sqm", $d_1['no_folio']); ?> </td> <td align="center"><?php echo get_bandera("inv", $d_1['no_folio']); ?> </td> </tr> <?php $i++; } if ($qty > 0) { ?> <tr onMouseOut="this.style.background='#E6E6E6'" onMouseOver="this.style.background='#FFDD99'" bgcolor="#E6E6E6" height="20"> <td colspan="<?php echo $cols; ?> "> </td> <td align="center" class="naranja"><b><?php echo $qty; ?> </b></td> <td colspan="5"> </td> <td align="right" class="naranja"><b><?php echo "\$ " . number_format($cost, 2); ?> </b></td> <td colspan="9"> </td> </tr><?php } } ?> </tbody> </table><br><br><br> <?php }
function listado($buscar, $filtros, $pagina) { if (!$pagina) { $pagina = 1; } $s_ = "select valor from configuracion where variable='dias_atraso'"; $r_ = mysql_query($s_); $d_ = mysql_fetch_array($r_); $limite = date("Y-m-d", mktime(0, 0, 0, date("m"), date("d") - $d_['valor'], date("Y"))); $s_f = "select folios.*, sum(partes.cantidad) as cantidad_total, sum(partes.total) as costo_total from scrap_partes as partes, scrap_folios as folios, "; $s_f .= "autorizaciones where folios.no_folio = partes.no_folio and autorizaciones.no_folio = folios.no_folio and folios.status='0' "; $s_f .= "and folios.activo='1' and folios.fecha<='{$limite}' "; 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 ($_SESSION["TYPE"] != 'administrador') { $s_ = "select * from divisiones where jefe='{$_SESSION['IDEMP']}'"; $r_ = mysql_query($s_); if (mysql_num_rows($r_) > 0) { $s_f .= "and ("; while ($d_ = mysql_fetch_array($r_)) { $s_f .= "id_division = '{$d_['id']}' or "; } $s_f = substr($s_f, 0, -3) . " ) "; } $s_ = "select * from plantas where jefe='{$_SESSION['IDEMP']}'"; $r_ = mysql_query($s_); if (mysql_num_rows($r_) > 0) { $s_f .= "and ("; while ($d_ = mysql_fetch_array($r_)) { $s_f .= "id_planta = '{$d_['id']}' or "; } $s_f = substr($s_f, 0, -3) . " ) "; } } $s_f .= " group by folios.no_folio order by folios.no_folio asc "; $r_1 = mysql_query($s_f); $tot = mysql_num_rows($r_1); ?> <div align="center" class="aviso">Utilice los filtros para generar búsquedas. Al cambiar un filtro, haga clic en el botón Buscar para refrescar la información. El reporte muestra toda la información sobre folios pendientes de autorizar.</div> <form action="?op=listado" method="post" name="form1"> <input type="hidden" name="pagina" value="<?php echo $pagina; ?> " /> <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 atrasos='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> </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 atrasos='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> </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 atrasos='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> </tr> </table> <div align="center" class="texto"><br> <input type="button" value="Buscar" class="submit" onclick="validar('reporte');"> <input type="button" value="Exportar" class="submit" onclick="exportar();"> </div></form> <table align="center" border="0" class="texto"> <tr> <td width="20" align="center"><img src="../imagenes/zoom.png" /></td> <td width="60" align="left">Ver Boleta</td> <td width="20" align="center">|</td> <td width="20" align="center"><img src="../imagenes/information.png" /></td> <td width="40" align="left">Historial</td> <td width="20" align="center">|</td> <td width="20" align="center"><img src="../imagenes/ayuda.gif" /></td> <td width="40" align="left">Detalles</td> </tr> </table><br> <?php $pags = ceil($tot / 100); $ini_ = ($pagina - 1) * 100; $i = 1; $j = 0; $ruta = "&fechai={$fechai}&fechaf={$fechaf}&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"> <thead> <tr bgcolor="#E6E6E6" height="20"> <td align="center" width="25"><img src="../imagenes/zoom.png" /></td> <td align="center" width="25"><img src="../imagenes/information.png" /></td> <td align="center" width="30">No.</td> <td align="center" width="60">Folio</td> <td align="center" width="90">Fecha</td> <td align="center" width="90">Cod.Scrap</td> <td align="center" width="90">Reason Code</td> <td align="center" width="90" colspan="2">Cod. Causa Original</td> <td align="center" width="60">Qty</td> <td align="center" width="80">Total</td> <td align="center" width="250">Números de Parte</td> <td align="center" width="50">APD</td> <td align="center" width="100">Capturista</td> <td align="center" width="30">LO</td> <td align="center" width="30">LO-A</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">Inv</td> </tr> </thead> <tbody> <?php $i = $ini_ + 1; $qty = $cost = 0; $s_f .= " limit {$ini_},100"; $r_1 = mysql_query($s_f); while ($d_1 = mysql_fetch_array($r_1)) { $qty = $qty + $d_1['cantidad_total']; $cost = $cost + $d_1['costo_total']; ?> <tr onMouseOut="this.style.background='#F7F7F7'" onMouseOver="this.style.background='#FFDD99'" bgcolor="#F7F7F7" height="20"> <td align="center"> <a class="frame_ver_boleta" href="../detalles.php?op=ver_boleta&folio=<?php echo $d_1['no_folio']; ?> &buscar=no"> <img src="../imagenes/zoom.png" border="0"></a></td> <td align="center"> <a class="frame_ver_boleta" href="../detalles.php?op=historial&folio=<?php echo $d_1['no_folio']; ?> &buscar=no"> <img src="../imagenes/information.png" border="0"></a></td> <td align="center"><?php echo $i; ?> </td> <td align="center"><?php echo $d_1['no_folio']; ?> </td> <td align="center"><?php echo fecha_dmy($d_1['fecha']); ?> </td> <td align="center"><?php echo $d_1['codigo_scrap']; ?> </td> <td align="center"><?php echo $d_1['reason_code']; ?> </td> <td align="center" width="70"> <?php $original = data_codigo_original($d_1['no_folio'], $d_1['financiero']); echo $original['codigo']; ?> </td> <td align="center" width="20"> <?php if ($d_1['financiero'] == '1') { ?> <span title='header=[ Código de Causa Original] body=[<?php echo detalles_codigo_original($d_1['no_folio']); ?> ]'> <img src="../imagenes/ayuda.gif" style="cursor: hand;"></span><?php } ?> </td> <td align="center"><?php echo $d_1['cantidad_total']; ?> </td> <td align="right"><?php echo "\$ " . number_format($d_1['costo_total'], 2); ?> </td> <td align="center"> <?php if ($d_1['carga_masiva'] == '0') { echo "<table align='center' border='0' cellpadding='0' cellspacing='2' style='border:#CCCCCC solid 1px;' width='250'>"; $s_2 = "select * from scrap_partes where no_folio='{$d_1['no_folio']}' order by no_parte"; $r_2 = mysql_query($s_2); while ($d_2 = mysql_fetch_array($r_2)) { echo "<tr bgcolor='#EEEEEE'>"; echo "<td align='left' width='100'> {$d_2['no_parte']}</td>"; echo "<td align='left' width='150'> {$d_2['descripcion']}</td>"; echo "</tr>"; } echo "</table>"; } if ($d_1['carga_masiva'] == '1') { echo "<a href='../excel_reportes.php?op=ver_modelos&folio={$d_1['no_folio']}' class='menuLink'>"; echo "Archivo de modelos<br>(carga masiva)</a>"; } ?> </td> <td align="center"><?php echo $d_1['apd']; ?> </td> <td align="center"><?php echo $d_1['empleado']; ?> </td> <td align="center"><?php echo get_bandera("lo", $d_1['no_folio']); ?> </td> <td align="center"><?php echo get_bandera("loa", $d_1['no_folio']); ?> </td> <td align="center"><?php echo get_bandera("lpl", $d_1['no_folio']); ?> </td> <td align="center"><?php echo get_bandera("ffm", $d_1['no_folio']); ?> </td> <td align="center"><?php echo get_bandera("ffc", $d_1['no_folio']); ?> </td> <td align="center"><?php echo get_bandera("prod", $d_1['no_folio']); ?> </td> <td align="center"><?php echo get_bandera("sqm", $d_1['no_folio']); ?> </td> <td align="center"><?php echo get_bandera("fin", $d_1['no_folio']); ?> </td> <td align="center"><?php echo get_bandera("esp", $d_1['no_folio']); ?> </td> <td align="center"><?php echo get_bandera("inv", $d_1['no_folio']); ?> </td> </tr> <?php $i++; } ?> <tr bgcolor="#E6E6E6"> <td colspan="9" align="right" class="naranja"><b>Totales</b> </td> <td align="center" class="naranja"><b><?php echo $qty; ?> </b></td> <td align="right" class="naranja"><b><?php echo "\$ " . number_format($cost, 2); ?> </b> </td> <td colspan="14"> </td> </tr> </tbody> </table><br> <?php }
function ajustar_p1($folio) { ?> <br><table align="center" class="tabla"> <caption>Ajustar Autorizaciones</caption> <form action="?op=ajustar_p1" method="post" name="form1"> <tr height="20"> <td width="100" align="center">Buscar Folio:</td> <td align="center"><input type="text" name="folio" class="texto" size="20" value="<?php echo $folio; ?> " /></td> <td width="110" align="center"><input type="submit" class="submit" value="Buscar" /></td> </tr> </form> </table><br> <form action="?op=ajustar_p2" method="post" name="form1"> <table align="center" class="tabla"> <tr bgcolor="#E6E6E6" height="20"> <td align="center" width="30"> </td> <td align="center" width="50">No.</td> <td align="center" width="50">Folio</td> <td align="center" width="40">Cant</td> <td align="center" width="80">Cod.Scrap</td> <td align="center" width="70">Total</td> <td align="center" width="90">Fecha</td> <?php echo "<td width='60' align='center'><span>LO</span></td>"; echo "<td width='60' align='center'><span>LO-A</span></td>"; echo "<td width='60' align='center'><span>LPL</span></td>"; echo "<td width='60' align='center'><span>FFM</span></td>"; echo "<td width='60' align='center'><span>FFC</span></td>"; echo "<td width='60' align='center'><span>Prod</span></td>"; echo "<td width='60' align='center'><span>SQM</span></td>"; echo "<td width='60' align='center'><span>Finanzas</span></td>"; echo "<td width='60' align='center'><span>INV</span></td>"; ?> <td align="center" width="60">Estado Asignado</td> <td align="center" width="60">Estado Real</td> </tr> </thead> <tbody> <?php $s_ = "select no_folio, status from scrap_folios where activo='1' and status!='1' "; if ($folio != '') { $s_ .= "and no_folio like '{$folio}' "; } $s_ .= "order by no_folio"; $r_ = mysql_query($s_); $i = 0; while ($d_ = mysql_fetch_array($r_)) { $estado = get_status($d_['no_folio']); if ($estado != $d_['status']) { $folios[$i] = $d_['no_folio']; $states[$i] = $estado; $i++; } } $j = 1; for ($i = 0; $i < count($folios); $i++) { $s_ = "select folios.no_folio, folios.fecha, sum(partes.cantidad) as cantidad_total, folios.codigo_scrap, sum(partes.total) "; $s_ .= "as costo_total, folios.status from scrap_partes as partes, scrap_folios as folios where folios.no_folio=partes.no_folio "; $s_ .= "and folios.no_folio='{$folios[$i]}' group by folios.no_folio"; $r_ = mysql_query($s_); $d_ = mysql_fetch_array($r_); ?> <tr onMouseOut="this.style.background='#F7F7F7'" onMouseOver="this.style.background='#FFDD99'" bgcolor="#F7F7F7" height="20"> <td align="center"><input type="checkbox" name="folios[]" value="<?php echo $folios[$i]; ?> " checked="checked"></td> <td align="center"><?php echo $j; ?> </td> <td align="center"><?php echo $d_['no_folio']; ?> </td> <td align="center"><?php echo $d_['cantidad_total']; ?> </td> <td align="center"><?php echo $d_['codigo_scrap']; ?> </td> <td align="right"><?php echo "\$ " . number_format($d_['costo_total'], 2); ?> </td> <td align="center"><?php echo $d_['fecha']; ?> </td> <td align="center"><?php echo get_bandera("lo", $d_['no_folio']); ?> </td> <td align="center"><?php echo get_bandera("loa", $d_['no_folio']); ?> </td> <td align="center"><?php echo get_bandera("lpl", $d_['no_folio']); ?> </td> <td align="center"><?php echo get_bandera("ffm", $d_['no_folio']); ?> </td> <td align="center"><?php echo get_bandera("ffc", $d_['no_folio']); ?> </td> <td align="center"><?php echo get_bandera("prod", $d_['no_folio']); ?> </td> <td align="center"><?php echo get_bandera("sqm", $d_['no_folio']); ?> </td> <td align="center"><?php echo get_bandera("fin", $d_['no_folio']); ?> </td> <td align="center"><?php echo get_bandera("inv", $d_['no_folio']); ?> </td> <td align="center"> <?php switch ($d_['status']) { case "0": echo "<img src='../imagenes/flag_orange.gif' border=0>"; break; case "1": echo "<img src='../imagenes/flag_green.gif' border=0>"; break; case "2": echo "<img src='../imagenes/flag_red.gif' border=0>"; break; case "3": echo "<img src='../imagenes/cross.png' border=0>"; break; } ?> </td> <td align="center"> <?php switch ($states[$i]) { case "0": echo "<img src='../imagenes/flag_orange.gif' border=0>"; break; case "1": echo "<img src='../imagenes/flag_green.gif' border=0>"; break; case "2": echo "<img src='../imagenes/flag_red.gif' border=0>"; break; case "3": echo "<img src='../imagenes/cross.png' border=0>"; break; } ?> </td> </tr> <?php $j++; } ?> </tbody> </table> <br><div align="center"> <input type="submit" class="submit" value="Ajustar" /></div> </form> <br><br><br> <?php }
function corto($fechai, $fechaf, $proy_add, $proy_del, $buscar, $filtros, $pagina, $boton) { 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=corto" 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> </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> </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> </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('corto');" <?php if ($boton == 1) { ?> disabled='disabled' <?php } ?> ></td> <td width="150" align="center" valign="middle"> <input type="button" value="Exportar" class="submit" onclick="exportar('corto');"></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.cantidad, partes.padre, aut_bitacora.fecha, aut_bitacora.hora from scrap_partes as partes, scrap_folios as folios, "; $s_f .= "autorizaciones, numeros_parte, aut_bitacora where folios.no_folio = partes.no_folio and autorizaciones.no_folio = folios.no_folio and "; $s_f .= "partes.no_parte = numeros_parte.nombre and aut_bitacora.no_folio = folios.no_folio and aut_bitacora.depto='inv' and aut_bitacora.status='1' "; 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 (folios.fecha>='{$fechai}' and folios.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); $tot = mysql_num_rows($r_1); $pags = ceil($tot / 100); $ini_ = ($pagina - 1) * 100; $i = 1; $j = 0; $ruta = "&fechai={$fechai}&fechaf={$fechaf}&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> <td align="center" rowspan="2">Folio</td> <td align="center" rowspan="2">No. Parte</td> <td align="center" rowspan="2">Qty</td> <td align="center" rowspan="2">Fecha creación</td> <td align="center" rowspan="2">Hora creación</td> <td align="center" colspan="3">Autorización</td> </tr> <tr bgcolor="#E6E6E6" height="20"> <td align="center" width="30">Inv</td> <td align="center" width="30">Fecha</td> <td align="center" width="30">Hora</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']; } 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> <td align="center" class="small"><?php echo $d_1['no_folio']; ?> </td> <td align="left" class="small"><?php echo $d_1['no_parte']; ?> </td> <td align="center" class="small"><?php echo $d_1['cantidad']; ?> </td> <?php $a_folio = substr($d_1['timer'], 0, 4); $m_folio = substr($d_1['timer'], 4, 2); $d_folio = substr($d_1['timer'], 6, 2); $h_folio = substr($d_1['timer'], 8, 2); $min_folio = substr($d_1['timer'], 10, 2); $seg_folio = substr($d_1['timer'], 12, 2); $fecha_folio = date("d-m-Y", mktime($h_folio, $min_folio, $seg_folio, $m_folio, $d_folio, $a_folio)); $hora_folio = date("H:i:s", mktime($h_folio, $min_folio, $seg_folio, $m_folio, $d_folio, $a_folio)); ?> <td align="center" class="small"><?php echo $fecha_folio; ?> </td> <td align="center" class="small"><?php echo $hora_folio; ?> </td> <td align="center" class="small"><?php echo get_bandera("inv", $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); $d_i = mysql_fetch_array($r_i); $fecha_inv = $d_i['fecha']; $hora_inv = $d_i['hora']; ?> <td align="center"><?php echo $fecha_inv; ?> </td> <td align="center"><?php echo $hora_inv; ?> </td> </tr> <?php } ?> <tr bgcolor="#E6E6E6"> <td colspan="3"> </td> <td align='right' class='naranja'><?php echo "{$qty} "; ?> </td> <td align="center" colspan="5"> </td> </tr> </tbody> </table><br><br> <?php echo "<script>form1.boton.disabled=false;</script>"; }
function listado($fechai, $fechaf, $proy_add, $proy_del, $buscar, $filtros, $tipo, $reason, $pagina) { if (!$tipo) { $tipo = 'todos'; } if (!$pagina) { $pagina = 1; } if (count($proy_add) > 0) { for ($i = 0; $i < count($proy_add); $i++) { if ($proy_add[$i] != '' && $proy_add[$i] != '0') { $s_ = "insert into filtros values('','proyectos','{$proy_add[$i]}','{$_SESSION['IDEMP']}')"; $r_ = mysql_query($s_); } } } if (count($proy_del) > 0) { for ($i = 0; $i < count($proy_del); $i++) { if ($proy_del[$i] != '' && $proy_del[$i] != '0') { $s_ = "delete from filtros where filtro='proyectos' and id_emp='{$_SESSION['IDEMP']}' and valor='{$proy_del[$i]}'"; $r_ = mysql_query($s_); } } } ?> <div align="center" class="aviso">Utilice los filtros para generar búsquedas. Al cambiar un filtro, haga clic en el botón Buscar para refrescar la información. El reporte muestra toda la información sobre folios pendientes de autorizar.</div> <form action="?op=listado" method="post" name="form1"> <input type="hidden" name="pagina" value="<?php echo $pagina; ?> " /> <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> <?php if ($_SESSION["DEPTO"] == 'inv') { ?> <td align="center" bgcolor="#E6E6E6">Tipo</td><?php } ?> </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> <?php if ($_SESSION["DEPTO"] == 'inv') { ?> <td align="center"> <select name="tipo" class="texto" style="width:120px;"> <option value="todos" <?php if ($tipo == 'todos') { ?> selected="selected"<?php } ?> >Todos</option> <option value="aprobados" <?php if ($tipo == 'aprobados') { ?> selected="selected"<?php } ?> >Aprobados</option> <option value="cancelados" <?php if ($tipo == 'cancelados') { ?> selected="selected"<?php } ?> >Cancelados</option> <option value="pendientes" <?php if ($tipo == 'pendientes') { ?> selected="selected"<?php } ?> >Pendientes</option> <option value="rechazados" <?php if ($tipo == 'rechazados') { ?> selected="selected"<?php } ?> >Rechazados</option> </select></td><?php } ?> </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 scrap_firmar='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> </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 scrap_firmar='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> </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 scrap_firmar='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> </tr> </table> <div align="center" class="texto"><br> <input type="button" value="Buscar" class="submit" onclick="validar('reporte');"> <input type="button" value="Exportar" class="submit" onclick="validar('excel');"> <input type="checkbox" name="reason" value="1" <?php if ($reason == 1) { ?> checked="checked"<?php } ?> > Mostrar Reason code </div><br> <table align="center" border="0" class="texto"> <tr> <td width="20" align="center"><img src="../imagenes/zoom.png" /></td> <td width="60" align="left">Ver Boleta</td> <td width="20" align="center">|</td> <td width="20" align="center"><img src="../imagenes/information.png" /></td> <td width="40" align="left">Historial</td> <td width="20" align="center">|</td> <td width="20" align="center"><img src="../imagenes/attach.png" /></td> <td width="50" align="left">Evidencias</td> <td width="20" align="center">|</td> <td width="20" align="center"><img src="../imagenes/ayuda.gif" /></td> <td width="40" align="left">Detalles</td> </tr> </table><br> <?php //Reviso que realmente tenga asignada una división, profit_center, área o proyecto $s_p = "select * from autorizadores where id_emp='{$_SESSION['IDEMP']}'"; $r_p = mysql_query($s_p); if (mysql_num_rows($r_p) > 0) { //CONSULTA GLOBAL $s_f = "select folios.*, sum(partes.cantidad) as cantidad_total, sum(partes.total) as costo_total from scrap_partes as partes, "; $s_f .= "scrap_folios as folios, autorizaciones, numeros_parte where folios.no_folio = partes.no_folio and autorizaciones.no_folio = "; $s_f .= "folios.no_folio and partes.no_parte = numeros_parte.nombre "; if ($_SESSION["DEPTO"] != 'esp') { $s_f .= " and autorizaciones.depto='{$_SESSION['DEPTO']}' "; } else { $s_f .= " and (autorizaciones.depto='esp_1' or autorizaciones.depto='esp_2') "; } switch ($tipo) { case "todos": if ($_SESSION["DEPTO"] == 'inv') { $s_f .= " and (folios.status='0' or folios.status='2') and folios.activo='1' and "; $s_f .= "autorizaciones.status='0' "; } if ($_SESSION["DEPTO"] != 'inv') { $s_f .= " and folios.status='0' and folios.activo='1' and autorizaciones.status='0' "; } break; case "aprobados": $s_f .= " and not exists (select no_folio from autorizaciones where status!='1' and folios.no_folio="; $s_f .= "autorizaciones.no_folio and autorizaciones.depto!='inv') and "; $s_f .= "folios.status='0' and folios.activo='1' and autorizaciones.status='0' "; break; case "cancelados": $s_f .= " and (folios.status='0' or folios.status='2') and folios.activo='2' "; case "rechazados": $s_f .= " and folios.status='2' and folios.activo='1' "; break; case "pendientes": $s_f .= " and folios.status='0' and folios.activo='1' and autorizaciones.status='0' "; break; } 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++) { if ($filtros[$i] == "global_pc") { $s_f .= get_operador($filtros[$i], $data[$j]) . " or "; } $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}') "; } $s_f .= filtros_autorizador(); $s_f .= " group by no_folio order by no_folio DESC"; $r_1 = mysql_query($s_f); $d_1 = mysql_fetch_array($r_1); $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}&tipo={$tipo}&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 } ?> <?php if ($_SESSION["DEPTO"] == 'inv') { //Mostrar la hora y detalles de la última autorización existente de cualquier perfil $s_b = "select aut_bitacora.*, general.* from aut_bitacora, autorizaciones, (" . $s_f . ") as general where general.no_folio = aut_bitacora.no_folio and "; $s_b .= "autorizaciones.no_folio = general.no_folio and general.status='0' and autorizaciones.status='0' and aut_bitacora.status='1' order by aut_bitacora.fecha "; $s_b .= "desc, aut_bitacora.hora desc"; $r_b = mysql_query($s_b); $d_b = mysql_fetch_array($r_b); ?> <table align="center" class="tabla"> <tr> <td align="center" bgcolor="#CCCCCC" width="100"><b>Folio</b></td> <td align="center" bgcolor="#CCCCCC" width="100"><b>Fecha</b></td> <td align="center" bgcolor="#CCCCCC" width="100"><b>Hora</b></td> <td align="center" bgcolor="#CCCCCC" width="100"><b>Perfil</b></td> <td align="center" bgcolor="#CCCCCC" width="250"><b>Empleado</b></td> <td align="center" bgcolor="#CCCCCC" width="120" rowspan="2"><input type="button" value="Descargar Reporte" class="submit" onclick="descargar();"></td> </tr> <tr> <td align="center"><?php echo $d_b['no_folio']; ?> </td> <td align="center"><?php echo $d_b['fecha']; ?> </td> <td align="center"><?php echo $d_b['hora']; ?> </td> <td align="center"><?php switch ($d_b["depto"]) { case "lo": echo "LO"; break; case "loa": echo "LO-Almacén"; break; case "lpl": echo "LPL"; break; case "ffm": echo "FFM"; break; case "ffc": echo "FFC"; break; case "prod": echo "Producción"; break; case "sqm": echo "SQM"; break; case "fin": echo "Finanzas"; break; case "esp": echo "ESP"; break; case "oes": echo "OES"; break; } ?> </td> <td align="left"> <?php echo $d_b['empleado']; ?> </td> </tr> </table><br> <?php } ?> <table align="center" class="tabla"> <thead> <tr bgcolor="#E6E6E6" height="20"> <td align="center" width="25"> <input type="checkbox" name="todos" id="todos" value="1" <?php if ($todos == '1') { ?> checked="checked" <?php } ?> onclick="select_all('<?php echo $tot; ?> ');"></td> <td align="center" width="25"><img src="../imagenes/zoom.png" /></td> <td align="center" width="25"><img src="../imagenes/information.png" /></td> <?php if ($_SESSION["DEPTO"] == 'lo' || $_SESSION["DEPTO"] == 'loa') { ?> <td align="center" width="25"><img src="../imagenes/attach.png" /></td><?php } ?> <td align="center" width="60">Folio</td> <td align="center" width="90">Fecha</td> <?php if ($reason != 1) { ?> <td align="center" width="90">Cod.Scrap</td><?php } ?> <?php if ($reason == 1) { ?> <td align="center" width="90">Reason Code</td><?php } ?> <td align="center" width="90" colspan="2">Cod. Causa Original</td> <td align="center" width="100">Info.Obligatoria</td> <td align="center" width="60">Qty</td> <td align="center" width="80">Total</td> <td align="center" width="250">Números de Parte</td> <td align="center" width="50">APD</td> <td align="center" width="100">Proyecto</td> <td align="center" width="100">Capturista</td> <?php switch ($_SESSION["DEPTO"]) { case "lo": echo "<td align='center' colspan=2>LO</td>"; break; case "loa": echo "<td align='center' colspan=2>LO-Almacén</td>"; break; case "lpl": echo "<td align='center' colspan=2>LPL</td>"; break; case "ffm": echo "<td align='center' colspan=2>FFM</td>"; break; case "ffc": echo "<td align='center' colspan=2>FFC</td>"; break; case "prod": echo "<td align='center' colspan=2>Producción</td>"; break; case "sqm": echo "<td align='center' colspan=2>SQM</td>"; break; case "fin": echo "<td align='center' colspan=2>Finanzas</td>"; break; case "esp": echo "<td align='center' colspan=2>ESP</td>"; break; case "oes": echo "<td align='center' colspan=2>OES</td>"; break; case "inv": echo "<td width='30' align='center'>LO</td>"; echo "<td width='30' align='center'>LO-A</td>"; echo "<td width='30' align='center'>LPL</td>"; echo "<td width='30' align='center'>FFM</td>"; echo "<td width='30' align='center'>FFC</td>"; echo "<td width='30' align='center'>Prod</td>"; echo "<td width='30' align='center'>SQM</td>"; echo "<td width='30' align='center'>Finanzas</td>"; echo "<td width='30' align='center'>ESP</td>"; echo "<td width='30' align='center'>OES</td>"; echo "<td width='30' align='center'>Inv</td>"; echo "<td align='center' colspan='3'>Acciones</td>"; break; } ?> </tr> </thead> <tbody> <?php $qty = $cost = 0; $s_f .= " limit {$ini_}, 100"; $r_1 = mysql_query($s_f); $n_1 = mysql_num_rows($r_1); while ($d_1 = mysql_fetch_array($r_1)) { $qty = $qty + $d_1['cantidad_total']; $cost = $cost + $d_1['costo_total']; $dis = firma_inventarios($d_1['no_folio']); ?> <tr onMouseOut="this.style.background='#F7F7F7'" onMouseOver="this.style.background='#FFDD99'" bgcolor="#F7F7F7" height="20"> <td align="center"> <input type="checkbox" name="varios[]" id="varios" value="<?php echo $d_1['no_folio']; ?> " <?php echo firma_inventarios($d_1['no_folio']); ?> ></td> <td align="center"> <a class="frame_ver_boleta" href="../detalles.php?op=ver_boleta&folio=<?php echo $d_1['no_folio']; ?> &buscar=no"> <img src="../imagenes/zoom.png" border="0"></a></td> <td align="center"> <a class="frame_ver_boleta" href="../detalles.php?op=historial&folio=<?php echo $d_1['no_folio']; ?> &buscar=no"> <img src="../imagenes/information.png" border="0"></a></td> <?php if ($_SESSION["DEPTO"] == 'lo' || $_SESSION["DEPTO"] == 'loa') { $cols = 10; ?> <td align="center"> <?php $s_c = "select * from configuracion where variable='ruta_evidencias'"; $r_c = mysql_query($s_c); $d_c = mysql_fetch_array($r_c); $ruta = $d_c['valor'] . $d_1['archivo']; if ($d_1['archivo'] != '') { ?> <a href="<?php echo $ruta; ?> " target="_blank"> <img src="../imagenes/attach.png" border="0"></a><?php } ?> </td><?php } else { $cols = 9; } ?> <td align="center"><?php echo $d_1['no_folio']; ?> </td> <td align="center"><?php echo fecha_dmy($d_1['fecha']); ?> </td> <?php if ($reason != 1) { ?> <td align="center"><?php echo $d_1['codigo_scrap']; ?> </td><?php } ?> <?php if ($reason == 1) { ?> <td align="center"><?php echo $d_1['reason_code']; ?> </td><?php } ?> <td align="center" width="70"> <?php $original = data_codigo_original($d_1['no_folio'], $d_1['financiero']); echo $original['codigo']; ?> </td> <td align="center" width="20"> <?php if ($d_1['financiero'] == '1') { ?> <span title='header=[ Código de Causa Original] body=[<?php echo detalles_codigo_original($d_1['no_folio']); ?> ]'> <img src="../imagenes/ayuda.gif" style="cursor: hand;"></span><?php } ?> </td> <td align="center"><?php if ($d_1['info_1'] != 'NA' && $d_1['info_1'] != '') { echo $d_1['info_1'] . "-" . $d_1['info_2']; } else { echo "NA"; } ?> </td> <td align="center"><?php echo $d_1['cantidad_total']; ?> </td> <td align="right"><?php echo "\$ " . number_format($d_1['costo_total'], 2); ?> </td> <td align="center"> <?php if ($d_1['carga_masiva'] == '0') { echo "<table align='center' border='0' cellpadding='0' cellspacing='2' style='border:#CCCCCC solid 1px;' width='250'>"; $s_2 = "select * from scrap_partes where no_folio='{$d_1['no_folio']}' order by no_parte"; $r_2 = mysql_query($s_2); while ($d_2 = mysql_fetch_array($r_2)) { echo "<tr bgcolor='#EEEEEE'>"; echo "<td align='left' width='100'> {$d_2['no_parte']}</td>"; echo "<td align='left' width='150'> {$d_2['descripcion']}</td>"; echo "</tr>"; } echo "</table>"; } if ($d_1['carga_masiva'] == '1') { echo "<a href='../excel_reportes.php?op=ver_modelos&folio={$d_1['no_folio']}' class='menuLink'>"; echo "Archivo de modelos<br>(carga masiva)</a>"; } ?> </td> <td align="center"><?php echo $d_1['apd']; ?> </td> <td align="left"> <?php echo $d_1['proyecto']; ?> </td> <td align="center"><?php echo $d_1['empleado']; ?> </td> <?php if ($_SESSION["DEPTO"] == 'inv') { ?> <td align="center"><?php echo get_bandera("lo", $d_1['no_folio']); ?> </td> <td align="center"><?php echo get_bandera("loa", $d_1['no_folio']); ?> </td> <td align="center"><?php echo get_bandera("lpl", $d_1['no_folio']); ?> </td> <td align="center"><?php echo get_bandera("ffm", $d_1['no_folio']); ?> </td> <td align="center"><?php echo get_bandera("ffc", $d_1['no_folio']); ?> </td> <td align="center"><?php echo get_bandera("prod", $d_1['no_folio']); ?> </td> <td align="center"><?php echo get_bandera("sqm", $d_1['no_folio']); ?> </td> <td align="center"><?php echo get_bandera("fin", $d_1['no_folio']); ?> </td> <td align="center"><?php echo get_bandera("esp", $d_1['no_folio']); ?> </td> <td align="center"><?php echo get_bandera("oes", $d_1['no_folio']); ?> </td> <td align="center"><?php echo get_bandera("inv", $d_1['no_folio']); ?> </td> <td align="center"> <input type="button" class="submit_small" value="Aprobar" name="app" onclick="aprobar('<?php echo $d_1['no_folio']; ?> ');" <?php echo $dis; ?> ></td> <td align="center"> <input type="button" class="submit_small" value="Rechazar" name="rech" onclick="rechazar('<?php echo $d_1['no_folio']; ?> ');"> </td> <td align="center"> <input type="button" class="submit_small" value="Cancelar" name="canc" onclick="cancelar('<?php echo $d_1['no_folio']; ?> ');"> </td> <?php } else { ?> <td align="center" width="60"> <input type="button" class="submit_small" value="Aprobar" name="app" onclick="aprobar('<?php echo $d_1['no_folio']; ?> ');"></td> <td align="center" width="60"> <input type="button" class="submit_small" value="Rechazar" name="rech" onclick="rechazar('<?php echo $d_1['no_folio']; ?> ');"></td> </tr> <?php } } ?> <tr bgcolor="#E6E6E6"> <td colspan="<?php echo $cols; ?> " align="right" class="naranja"><b>Totales</b> </td> <td align="center" class="naranja"><b><?php echo $qty; ?> </b></td> <td align="right" class="naranja"><b><?php echo "\$ " . number_format($cost, 2); ?> </b> </td> <td colspan="18"> </td> </tr> </tbody> </table><br> <div align="center"> <input type="button" name="aprobar_todos" class="submit_big" value="Aprobar Seleccionados" onclick="app_sel();"> <input type="button" name="rechazar_todos" class="submit_big" value="Rechazar Seleccionados" onclick="rech_sel();"> </div><br><br></form> <?php } else { echo "<div align='center' class='naranja'><b>Usted no tiene división, área, profit center o proyectos asignados como autorizador.<br>"; echo "Contacte al administrador del sistema para que le asigne dichos filtros para ver las boletas correspondientes.<b></div>"; } }