Файловый менеджер

Файловый менеджер - Редактировать - /home2/cocinasdalloway/public_html/administrador/Home/orders_payment_incomplete.php

Назад
<?php function sumasdiasemana($fecha,$dias) { $datestart= strtotime($fecha); $datesuma = 15 * 86400; $diasemana = date('N',$datestart); $totaldias = $diasemana+$dias; $findesemana = intval( $totaldias/6) 1 ; $diasabado = $totaldias % 6 ; if ($diasabado==6) $findesemana++; if ($diasabado==0) $findesemana=$findesemana-1; $total = (($dias+$findesemana) 86400)+$datestart ; return $fechafinal = date('d-m-Y', $total); } if(isset($_GET['dep']) && $_GET['dep']!='') { $area=$_GET['dep']; $query_ordenes = " SELECT * FROM ordenes WHERE estatus <> 'Cancelada' AND id_area <> 1"; if($_SESSION["ad_perfil"]=='Ventas'){ $query_ordenes .= " AND id_usuario IN (".$_SESSION["ad_id"].")"; } }else{ $area=$IdAreasUs; $query_ordenes = " SELECT * FROM ordenes WHERE estatus <> 'Cancelada' AND id_estatus_pago <> 1"; if($_SESSION["ad_perfil"]=='Ventas'){ $query_ordenes .= " AND id_usuario IN (".$_SESSION["ad_id"].")"; } } /* $query_area = " SELECT * FROM areas WHERE id IN ($area)"; $consu_area = $conexion -> query($query_area); $execu_area = $consu_area->fetch_array(MYSQLI_BOTH); $nombre_area = $execu_area["descripcion"]; / ?> <div class="page-title"> <div class="title_left"> <h3>Ordenes <small> <?php //echo $nombre_area;?></small></h3> </div> <div class="title_right"> <div class="col-md-5 col-sm-5 col-xs-12 form-group pull-right top_search"> </div> </div> </div> <div class="clearfix"></div> <div class="row"> <div class="col-md-12"> <div class="x_panel"> <div class="x_content"> <div class="row"> <div class="col-sm-12"> <div class="card-box table-responsive"> <!--<table id="datatable-buttons" class="table table-striped table-bordered" style="width:100%">--> <table id="datatable" class="table table-striped table-bordered" style="width:100%"> <thead> <tr> <th>#Orden</th> <th>Creó</th> <th>Cliente</th> <th>Referencia</th> <th>F.Creada</th> <th>F.Area</th> <th>F.Cliente</th> <th>Total</th> <th>Estatus</th> <th>Pago</th> </tr> </thead> <tbody> <?php $consu_ordenes = $conexion -> query($query_ordenes); while($execu_ordenes = $consu_ordenes->fetch_array(MYSQLI_BOTH)){ $id_usuario = $execu_ordenes["id_usuario"]; $id_area = $execu_ordenes["id_area"]; $id_subarea = $execu_ordenes["id_subarea"]; $id_cliente = $execu_ordenes["id_cliente"]; $id_estatus_pago = $execu_ordenes["id_estatus_pago"]; $query_pago = " SELECT FROM estatus_pago WHERE id = '$id_estatus_pago'"; $consu_pago = $conexion -> query($query_pago); $execu_pago = $consu_pago->fetch_array(MYSQLI_BOTH); $pago = $execu_pago["descripcion"]; $query_creo = " SELECT * FROM usuarios WHERE id = '$id_usuario'"; $consu_creo = $conexion -> query($query_creo); $execu_creo = $consu_creo->fetch_array(MYSQLI_BOTH); $nombre_creo = $execu_creo["nombre"].' '.$execu_creo["a_paterno"]; $cve_creo = $execu_creo["clave"]; $query_area = " SELECT * FROM areas WHERE id = '$id_area'"; $consu_area = $conexion -> query($query_area); $execu_area = $consu_area->fetch_array(MYSQLI_BOTH); $nombre_area = $execu_area["descripcion"]; $query_subarea = " SELECT * FROM subarea WHERE id = '$id_subarea'"; $consu_subarea = $conexion -> query($query_subarea); $execu_subarea = $consu_subarea->fetch_array(MYSQLI_BOTH); $nombre_subarea = $execu_subarea["descripcion"]; $dias_subarea = $execu_subarea["dias"]; $query_clientes = " SELECT * FROM clientes WHERE id = '$id_cliente'"; $consu_clientes = $conexion -> query($query_clientes); $execu_clientes = $consu_clientes->fetch_array(MYSQLI_BOTH); $nombre_cliente = $execu_clientes["nombre"].' '.$execu_clientes["a_paterno"]; $fechaArea= sumasdiasemana(date("d-m-Y",strtotime($execu_ordenes['creacion'])),$dias_subarea); if( strtotime( sumasdiasemana(date("d-m-Y",strtotime($execu_ordenes['creacion'])),$dias_subarea) ) > strtotime(date("d-m-Y")) ){ $Color="#D5FFCC"; }elseif(strtotime( sumasdiasemana(date("d-m-Y",strtotime($execu_ordenes['creacion'])),$dias_subarea) ) == strtotime(date("d-m-Y"))){ $Color="#FEFFCC"; }else{ $Color="#FFCCCC"; } ?> <tr> <td bgcolor="<?php echo $Color;?>"><a href="index.php?md=7&Id=<?php echo $execu_ordenes['id']?>"><?php echo $cve_creo.'-'.str_pad($execu_ordenes['folio'], 5, "0", STR_PAD_LEFT);?></a></td> <td><?php echo $nombre_creo?></td> <td><?php echo $nombre_cliente?></td> <td><?php echo $execu_ordenes["referencia"]?></td> <td><?php echo date('d-m-Y',strtotime($execu_ordenes["creacion"]))?></td> <td bgcolor="<?php echo $Color;?>"><?php echo date('d-m-Y',strtotime($fechaArea))?></td> <td><?php echo date('d-m-Y',strtotime($execu_ordenes["entrega"]))?></td> <td>$<?php echo number_format($execu_ordenes["total"],2)?></td> <td><?php echo $nombre_area.' - '.$nombre_subarea?></td> <td><?php echo $pago?></td> </tr> <?php } ?> </tbody> </table> </div> </div> </div> </div> </div> </div> </div>

| ver. 1.4 | Github | . | PHP 8.2.22 | Генерация страницы: 0 | proxy | phpinfo | Настройка