Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- $query='
- SELECT ab.* FROM (
- SELECT "" as id,f.id_cliente, f.fecha_operacion AS fechahora, f.hora_operacion AS hora, CONCAT(f.fecha_operacion, \' \', f.hora_operacion) AS fechaorden, f.codfactura, f.total_cuenta_corriente AS monto, f.borrado,"" AS detalle_movimiento,"" AS verificado,"1" AS orden, f AS facturado FROM facturas f WHERE f.total_cuenta_corriente<>0 AND f.total_cuenta_corriente<>-1 AND f.id_cliente='.$id_cliente.'
- UNION ALL
- SELECT cm.id AS id,cm.cliente_relacionado, cm.fecha AS fechahora, cm.hora AS hora, CONCAT(cm.fecha, \' \', cm.hora) AS fechaorden,cm.mas_detalle,cm.monto,"",cm.detalle_movimiento,cm.verificado,"2","" FROM cajas_movimientos cm WHERE (cm.verificado = "**" OR cm.verificado = "||") AND cm.cliente_relacionado='.$id_cliente.'
- ) ab
- ORDER BY fechaorden ASC';
- $string_imprime .="
- <tr>
- <td class='td_f'>".$fecha_operacion."</td>
- ";
- ?>
- <?php if($datos_detalles['verificado'] == "||"){
- $string_imprime .= "<td class='td_cc'>RECIBO [no afecto caja]</td>";
- }else {
- $string_imprime .= "<td class='td_cc'><a class='ver_resumen' href='../../print/recibo.php?id_cliente=".$id_cliente."&monto=".$monto."&saldo=".$saldo_total."&href=ok'>RECIBO</a></td>";
- }
- $string_imprime .="<td class='cod_f'>";
- ?>
- <?php
- $recibo=explode('&&&',$datos_detalles['detalle_movimiento']);
- if($recibo[0] != ''){
- $string_imprime .="<a class='ver_resumen' href='../../print/recibo.php?id_cliente=".$id_cliente."&monto=".$monto."&saldo=".$saldo_total."&href=ok'>".$recibo[0]."</a>";
- }else{
- $string_imprime .="<a class='ver_resumen' href='../../print/recibo.php?id_cliente=".$id_cliente."&monto=".$monto."&saldo=".$saldo_total."&href=ok'>X</a>";
- }
- $string_imprime.="</td>";
- ?>
- <?php
- $string_imprime .="<td class='td_cc'></td>";
- ?>
- <?php if($datos_detalles['verificado'] == "||"){
- $string_imprime.="<td class='td_cc'>".number_format($monto, 2, ',', '.').' '.$datos_detalles['detalle_movimiento']."</td>";
- }else {
- $string_imprime.="<td class='td_cc'>".number_format($monto, 2, ',', '.')."</td>";
- }
- $string_imprime .="<td class='td_cc'>".number_format($acumulado, 2, ',', '.')."</td>";
- ?>
- <?php
- if(($privilegio=="Super Administrador")||($privilegio=="Administrador")){ ?>
- <!-- <td class="td_cc"><a class="eliminar" id="<?php echo $datos_detalles['id']; ?>">eliminar</a> <a class="imprimir">imprimir</a></td> -->
- <?php }else{
- $string_imprime.="<td class='td_cc'></td>";
- } ?>
- <?php
- $string_imprime.="</tr>";
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement