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

Файловый менеджер - Редактировать - /home2/cocinasdalloway/public_html/administrador/Home/dashboard.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); } ?> <div class="row"> <div class="col-md-12"> <div class=""> <div class="x_content"> <div class="row"> <div class="col-lg-6 col-md-6"> <div class="animated flipInY col-lg-3 col-md-3 col-sm-3 "> <div class="tile-stats"> <div class="icon"><i class="fa fa-pencil-square-o"></i></div> <div class="count"> <?php $query_exist = " SELECT * FROM quotes WHERE id_cliente IS NULL and fecha_creacion BETWEEN DATE_SUB(NOW(), INTERVAL 15 DAY) AND NOW()"; $consu_exist = $conexion -> query($query_exist); echo $conta_exist = mysqli_num_rows($consu_exist); $EnTiempo=0; $PorVencer=0; $Vencida=0; while($execu_exist = $consu_exist->fetch_array(MYSQLI_BOTH)){ if( strtotime( sumasdiasemana(date("d-m-Y",strtotime($execu_exist['fecha_creacion'])),1) ) > strtotime(date("d-m-Y")) ){ $EnTiempo++; }elseif(strtotime( sumasdiasemana(date("d-m-Y",strtotime($execu_exist['fecha_creacion'])),1) ) == strtotime(date("d-m-Y"))){ $PorVencer++; }else{ $Vencida++; } } ?> </div> <h3 style="font-size: 1.2rem;"><a <?php if($_SESSION["ad_perfil"]=='Ventas' \|\| $_SESSION["ad_perfil"]=="admin"){?> href="index.php?md=13" <?php }else{?> href="#" <?php }?> >Cotizaciones</a></h3> <p> <ul class="list-inline widget_tally"> <li> <p> <span class="month" style="width:80%">En tiempo </span> <span class="badge badge-success">    <?php echo $EnTiempo; ?>    </span> </p> </li> <li> <p> <span class="month" style="width:80%">Por vencer </span> <span class="badge badge-warning">    <?php echo $PorVencer?>    </span> </p> </li> <li> <p> <span class="month" style="width:80%">Vencidas </span> <span class="badge badge-danger">    <?php echo $Vencida?>    </span> </p> </li> </ul> </p> </div> </div> <div class="animated flipInY col-lg-3 col-md-3 col-sm-3 "> <div class="tile-stats"> <div class="icon"><i class="fa fa-credit-card"></i></div> <div class="count"> <?php $query_exist = " SELECT * FROM ordenes WHERE id_area='6' AND estatus <> 'Cancelada'"; $consu_exist = $conexion -> query($query_exist); echo $conta_exist = mysqli_num_rows($consu_exist); $EnTiempo=0; $PorVencer=0; $Vencida=0; while($execu_exist = $consu_exist->fetch_array(MYSQLI_BOTH)){ if( strtotime( sumasdiasemana(date("d-m-Y",strtotime($execu_exist['creacion'])),1) ) > strtotime(date("d-m-Y")) ){ $EnTiempo++; }elseif(strtotime( sumasdiasemana(date("d-m-Y",strtotime($execu_exist['creacion'])),1) ) == strtotime(date("d-m-Y"))){ $PorVencer++; }else{ $Vencida++; } } ?> </div> <h3 style="font-size: 1.2rem;"><a href="index.php?md=2&dep=6">Facturación</a></h3> <p> <ul class="list-inline widget_tally"> <li> <p> <span class="month" style="width:80%">En tiempo </span> <span class="badge badge-success">    <?php echo $EnTiempo; ?>    </span> </p> </li> <li> <p> <span class="month" style="width:80%">Por vencer </span> <span class="badge badge-warning">    <?php echo $PorVencer?>    </span> </p> </li> <li> <p> <span class="month" style="width:80%">Vencidas </span> <span class="badge badge-danger">    <?php echo $Vencida?>    </span> </p> </li> </ul> </p> </div> </div> <div class="animated flipInY col-lg-3 col-md-3 col-sm-3 "> <div class="tile-stats"> <div class="icon"><i class="fa fa-desktop"></i></div> <div class="count"> <?php $query_exist = " SELECT * FROM ordenes WHERE id_area='1' AND estatus <> 'Cancelada'"; $consu_exist = $conexion -> query($query_exist); echo $conta_exist = mysqli_num_rows($consu_exist); $EnTiempo=0; $PorVencer=0; $Vencida=0; while($execu_exist = $consu_exist->fetch_array(MYSQLI_BOTH)){ if($execu_exist["id_tipo_orden"]!='' && $execu_ordenes["fecha_planeacion"]!=''){ $query_farea = " SELECT * FROM tipo_orden WHERE id IN (".$execu_exist["id_tipo_orden"].")"; $consu_farea = $conexion -> query($query_farea); $execu_farea = $consu_farea->fetch_array(MYSQLI_BOTH); $diasAdicionalesDash = $execu_farea["diseno"]; if( strtotime( sumasdiasemana(date("d-m-Y",strtotime($execu_ordenes["fecha_planeacion"])),$diasAdicionalesDash) ) > strtotime(date("d-m-Y")) ){ $EnTiempo++; }elseif(strtotime( sumasdiasemana(date("d-m-Y",strtotime($execu_ordenes["fecha_planeacion"])),$diasAdicionalesDash) ) == strtotime(date("d-m-Y"))){ $PorVencer++; }else{ $Vencida++; } }else{ $EnTiempo++; } } ?> </div> <h3 style="font-size: 1.2rem;"><a href="index.php?md=2&dep=1">Diseño</a></h3> <p> <ul class="list-inline widget_tally"> <li> <p> <span class="month" style="width:80%">En tiempo </span> <span class="badge badge-success">    <?php echo $EnTiempo; ?>    </span> </p> </li> <li> <p> <span class="month" style="width:80%">Por vencer </span> <span class="badge badge-warning">    <?php echo $PorVencer?>    </span> </p> </li> <li> <p> <span class="month" style="width:80%">Vencidas </span> <span class="badge badge-danger">    <?php echo $Vencida?>    </span> </p> </li> </ul> </p> </div> </div> <div class="animated flipInY col-lg-3 col-md-3 col-sm-3 "> <div class="tile-stats"> <div class="icon"><i class="fa fa-desktop"></i></div> <div class="count"> <?php $query_exist = " SELECT * FROM ordenes WHERE id_area='7' AND estatus <> 'Cancelada'"; $consu_exist = $conexion -> query($query_exist); echo $conta_exist = mysqli_num_rows($consu_exist); $EnTiempo=0; $PorVencer=0; $Vencida=0; while($execu_exist = $consu_exist->fetch_array(MYSQLI_BOTH)){ if($execu_exist["id_tipo_orden"]!='' && $execu_ordenes["fecha_planeacion"]!=''){ $query_farea = " SELECT * FROM tipo_orden WHERE id IN (".$execu_exist["id_tipo_orden"].")"; $consu_farea = $conexion -> query($query_farea); $execu_farea = $consu_farea->fetch_array(MYSQLI_BOTH); $diasAdicionalesDash = $execu_farea["optimizacion"]; if( strtotime( sumasdiasemana(date("d-m-Y",strtotime($execu_ordenes["fecha_planeacion"])),$diasAdicionalesDash) ) > strtotime(date("d-m-Y")) ){ $EnTiempo++; }elseif(strtotime( sumasdiasemana(date("d-m-Y",strtotime($execu_ordenes["fecha_planeacion"])),$diasAdicionalesDash) ) == strtotime(date("d-m-Y"))){ $PorVencer++; }else{ $Vencida++; } }else{ $EnTiempo++; } } ?> </div> <h3 style="font-size: 1.2rem;"><a href="index.php?md=2&dep=7">Planeación</a></h3> <p> <ul class="list-inline widget_tally"> <li> <p> <span class="month" style="width:80%">En tiempo </span> <span class="badge badge-success">    <?php echo $EnTiempo; ?>    </span> </p> </li> <li> <p> <span class="month" style="width:80%">Por vencer </span> <span class="badge badge-warning">    <?php echo $PorVencer?>    </span> </p> </li> <li> <p> <span class="month" style="width:80%">Vencidas </span> <span class="badge badge-danger">    <?php echo $Vencida?>    </span> </p> </li> </ul> </p> </div> </div> </div> <div class="col-lg-6 col-md-6"> <div class="animated flipInY col-lg-3 col-md-3 col-sm-3 "> <div class="tile-stats"> <div class="icon"><i class="fa fa-shopping-cart"></i></div> <div class="count"> <?php $query_exist = " SELECT * FROM ordenes WHERE id_area='8' AND estatus <> 'Cancelada'"; $consu_exist = $conexion -> query($query_exist); echo $conta_exist = mysqli_num_rows($consu_exist); $EnTiempo=0; $PorVencer=0; $Vencida=0; while($execu_exist = $consu_exist->fetch_array(MYSQLI_BOTH)){ if($execu_exist["id_tipo_orden"]!='' && $execu_ordenes["fecha_planeacion"]!=''){ $query_farea = " SELECT * FROM tipo_orden WHERE id IN (".$execu_exist["id_tipo_orden"].")"; $consu_farea = $conexion -> query($query_farea); $execu_farea = $consu_farea->fetch_array(MYSQLI_BOTH); $diasAdicionalesDash = $execu_farea["compras"]; if( strtotime( sumasdiasemana(date("d-m-Y",strtotime($execu_ordenes["fecha_planeacion"])),$diasAdicionalesDash) ) > strtotime(date("d-m-Y")) ){ $EnTiempo++; }elseif(strtotime( sumasdiasemana(date("d-m-Y",strtotime($execu_ordenes["fecha_planeacion"])),$diasAdicionalesDash) ) == strtotime(date("d-m-Y"))){ $PorVencer++; }else{ $Vencida++; } }else{ $EnTiempo++; } } ?> </div> <h3 style="font-size: 1.2rem;"><a href="index.php?md=2&dep=8">Compras</a></h3> <p> <ul class="list-inline widget_tally"> <li> <p> <span class="month" style="width:80%">En tiempo </span> <span class="badge badge-success">    <?php echo $EnTiempo; ?>    </span> </p> </li> <li> <p> <span class="month" style="width:80%">Por vencer </span> <span class="badge badge-warning">    <?php echo $PorVencer?>    </span> </p> </li> <li> <p> <span class="month" style="width:80%">Vencidas </span> <span class="badge badge-danger">    <?php echo $Vencida?>    </span> </p> </li> </ul> </p> </div> </div> <div class="animated flipInY ccol-lg-3 col-md-3 col-sm-3 "> <div class="tile-stats"> <div class="icon"><i class="fa fa-wrench"></i></div> <div class="count"> <?php $query_exist = " SELECT * FROM ordenes WHERE id_area='2' AND estatus <> 'Cancelada'"; $consu_exist = $conexion -> query($query_exist); echo $conta_exist = mysqli_num_rows($consu_exist); $EnTiempo=0; $PorVencer=0; $Vencida=0; while($execu_exist = $consu_exist->fetch_array(MYSQLI_BOTH)){ if($execu_exist["id_tipo_orden"]!='' && $execu_ordenes["fecha_planeacion"]!=''){ $query_farea = " SELECT * FROM tipo_orden WHERE id IN (".$execu_exist["id_tipo_orden"].")"; $consu_farea = $conexion -> query($query_farea); $execu_farea = $consu_farea->fetch_array(MYSQLI_BOTH); $diasAdicionalesDash = $execu_farea["produccion"]; if( strtotime( sumasdiasemana(date("d-m-Y",strtotime($execu_ordenes["fecha_planeacion"])),$diasAdicionalesDash) ) > strtotime(date("d-m-Y")) ){ $EnTiempo++; }elseif(strtotime( sumasdiasemana(date("d-m-Y",strtotime($execu_ordenes["fecha_planeacion"])),$diasAdicionalesDash) ) == strtotime(date("d-m-Y"))){ $PorVencer++; }else{ $Vencida++; } }else{ $EnTiempo++; } } ?> </div> <h3 style="font-size: 1.2rem;"><a href="index.php?md=2&dep=2">Fabricación</a></h3> <p> <ul class="list-inline widget_tally"> <li> <p> <span class="month" style="width:80%">En tiempo </span> <span class="badge badge-success">    <?php echo $EnTiempo; ?>    </span> </p> </li> <li> <p> <span class="month" style="width:80%">Por vencer </span> <span class="badge badge-warning">    <?php echo $PorVencer?>    </span> </p> </li> <li> <p> <span class="month" style="width:80%">Vencidas </span> <span class="badge badge-danger">    <?php echo $Vencida?>    </span> </p> </li> </ul> </p> </div> </div> <div class="animated flipInY col-lg-3 col-md-3 col-sm-3 "> <div class="tile-stats"> <div class="icon"><i class="fa fa-cubes"></i></div> <div class="count"> <?php $query_exist = " SELECT * FROM ordenes WHERE id_area='5' AND estatus <> 'Cancelada'"; $consu_exist = $conexion -> query($query_exist); echo $conta_exist = mysqli_num_rows($consu_exist); $EnTiempo=0; $PorVencer=0; $Vencida=0; while($execu_exist = $consu_exist->fetch_array(MYSQLI_BOTH)){ if($execu_exist["id_tipo_orden"]!='' && $execu_ordenes["fecha_planeacion"]!=''){ $query_farea = " SELECT * FROM tipo_orden WHERE id IN (".$execu_exist["id_tipo_orden"].")"; $consu_farea = $conexion -> query($query_farea); $execu_farea = $consu_farea->fetch_array(MYSQLI_BOTH); $diasAdicionalesDash = $execu_farea["produccion"]; if( strtotime( sumasdiasemana(date("d-m-Y",strtotime($execu_ordenes["fecha_planeacion"])),$diasAdicionalesDash) ) > strtotime(date("d-m-Y")) ){ $EnTiempo++; }elseif(strtotime( sumasdiasemana(date("d-m-Y",strtotime($execu_ordenes["fecha_planeacion"])),$diasAdicionalesDash) ) == strtotime(date("d-m-Y"))){ $PorVencer++; }else{ $Vencida++; } }else{ $EnTiempo++; } } ?> </div> <h3 style="font-size: 1.2rem;"><a href="index.php?md=2&dep=5">Almacén</a></h3> <p> <ul class="list-inline widget_tally"> <li> <p> <span class="month" style="width:80%">En tiempo </span> <span class="badge badge-success">    <?php echo $EnTiempo; ?>    </span> </p> </li> <li> <p> <span class="month" style="width:80%">Por vencer </span> <span class="badge badge-warning">    <?php echo $PorVencer?>    </span> </p> </li> <li> <p> <span class="month" style="width:80%">Vencidas </span> <span class="badge badge-danger">    <?php echo $Vencida?>    </span> </p> </li> </ul> </p> </div> </div> <div class="animated flipInY col-lg-3 col-md-3 col-sm-3 "> <div class="tile-stats"> <div class="icon"><i class="fa fa-puzzle-piece"></i></div> <div class="count"> <?php $query_exist = " SELECT * FROM ordenes WHERE id_area='3' AND estatus <> 'Cancelada'"; $consu_exist = $conexion -> query($query_exist); echo $conta_exist = mysqli_num_rows($consu_exist); $EnTiempo=0; $PorVencer=0; $Vencida=0; while($execu_exist = $consu_exist->fetch_array(MYSQLI_BOTH)){ if($execu_exist["id_tipo_orden"]!='' && $execu_ordenes["fecha_planeacion"]!=''){ $query_farea = " SELECT * FROM tipo_orden WHERE id IN (".$execu_exist["id_tipo_orden"].")"; $consu_farea = $conexion -> query($query_farea); $execu_farea = $consu_farea->fetch_array(MYSQLI_BOTH); $diasAdicionalesDash = $execu_farea["instalacion "]; if( strtotime( sumasdiasemana(date("d-m-Y",strtotime($execu_ordenes["fecha_planeacion"])),$diasAdicionalesDash) ) > strtotime(date("d-m-Y")) ){ $EnTiempo++; }elseif(strtotime( sumasdiasemana(date("d-m-Y",strtotime($execu_ordenes["fecha_planeacion"])),$diasAdicionalesDash) ) == strtotime(date("d-m-Y"))){ $PorVencer++; }else{ $Vencida++; } }else{ $EnTiempo++; } } ?> </div> <h3 style="font-size: 1.2rem;"><a href="index.php?md=2&dep=3">Instalación</a></h3> <p> <ul class="list-inline widget_tally"> <li> <p> <span class="month" style="width:80%">En tiempo </span> <span class="badge badge-success">    <?php echo $EnTiempo; ?>    </span> </p> </li> <li> <p> <span class="month" style="width:80%">Por vencer </span> <span class="badge badge-warning">    <?php echo $PorVencer?>    </span> </p> </li> <li> <p> <span class="month" style="width:80%">Vencidas </span> <span class="badge badge-danger">    <?php echo $Vencida?>    </span> </p> </li> </ul> </p> </div> </div> </div> <div class="col-lg-2 col-md-2"> <div class="animated flipInY col-lg-12 col-md-12 col-sm-12 "> <div class="tile-stats"> <div class="icon"><i class="fa fa-search"></i></div> <div class="count"> <?php $query_exist = " SELECT * FROM ordenes WHERE id_area='9' AND estatus <> 'Cancelada'"; $consu_exist = $conexion -> query($query_exist); echo $conta_exist = mysqli_num_rows($consu_exist); $EnTiempo=0; $PorVencer=0; $Vencida=0; while($execu_exist = $consu_exist->fetch_array(MYSQLI_BOTH)){ if($execu_exist["id_tipo_orden"]!='' && $execu_ordenes["fecha_planeacion"]!=''){ $query_farea = " SELECT * FROM tipo_orden WHERE id IN (".$execu_exist["id_tipo_orden"].")"; $consu_farea = $conexion -> query($query_farea); $execu_farea = $consu_farea->fetch_array(MYSQLI_BOTH); $diasAdicionalesDash = $execu_farea["compras"]; if( strtotime( sumasdiasemana(date("d-m-Y",strtotime($execu_ordenes["fecha_planeacion"])),$diasAdicionalesDash) ) > strtotime(date("d-m-Y")) ){ $EnTiempo++; }elseif(strtotime( sumasdiasemana(date("d-m-Y",strtotime($execu_ordenes["fecha_planeacion"])),$diasAdicionalesDash) ) == strtotime(date("d-m-Y"))){ $PorVencer++; }else{ $Vencida++; } }else{ $EnTiempo++; } } ?> </div> <h3 style="font-size: 1.2rem;"><a href="index.php?md=2&dep=9">Falta de informacion</a></h3> <p> <ul class="list-inline widget_tally"> <li> <p> <span class="month" style="width:80%">En tiempo </span> <span class="badge badge-success">    <?php echo $EnTiempo; ?>    </span> </p> </li> <li> <p> <span class="month" style="width:80%">Por vencer </span> <span class="badge badge-warning">    <?php echo $PorVencer?>    </span> </p> </li> <li> <p> <span class="month" style="width:80%">Vencidas </span> <span class="badge badge-danger">    <?php echo $Vencida?>    </span> </p> </li> </ul> </p> </div> </div> </div> <div class="col-lg-10 col-md-10"> <div class="animated flipInY col-lg-2 col-md-2 col-sm-2 "> </div> <div class="animated flipInY col-lg-4 col-md-4 col-sm-6 "> <div class="tile-stats" style="background-color:#2A3F54;"> <div class="icon"><i class="fa fa-money"></i></div> <div class="count"> <?php $query_exist = " SELECT * FROM ordenes WHERE id_estatus_pago<>'1' AND estatus <> 'Cancelada'"; $consu_exist = $conexion -> query($query_exist); echo $conta_exist = mysqli_num_rows($consu_exist); $EnTiempo=0; $PorVencer=0; $Vencida=0; while($execu_exist = $consu_exist->fetch_array(MYSQLI_BOTH)){ if( strtotime( sumasdiasemana(date("d-m-Y",strtotime($execu_exist['creacion'])),18) ) > strtotime(date("d-m-Y")) ){ $EnTiempo++; }elseif(strtotime( sumasdiasemana(date("d-m-Y",strtotime($execu_exist['creacion'])),18) ) == strtotime(date("d-m-Y"))){ $PorVencer++; }else{ $Vencida++; } } ?> </div> <h3><a href="index.php?md=15">Pendientes de pago</a></h3> <p> <ul class="list-inline widget_tally"> <li> <p> <span class="month" style="width:80%">En tiempo </span> <span class="badge badge-success">    <?php echo $EnTiempo; ?>    </span> </p> </li> <li> <p> <span class="month" style="width:80%">Por vencer </span> <span class="badge badge-warning">    <?php echo $PorVencer?>    </span> </p> </li> <li> <p> <span class="month" style="width:80%">Vencidas </span> <span class="badge badge-danger">    <?php echo $Vencida?>    </span> </p> </li> </ul> </p> </div> </div> <div class="animated flipInY col-lg-4 col-md-4 col-sm-6 "> <div class="tile-stats" style="background-color:#2A3F54;"> <div class="icon"><i class="fa fa-check-circle"></i></div> <div class="count"> <?php $query_exist = " SELECT * FROM ordenes WHERE estatus <> 'Cancelada' AND id_area = '4' AND creacion >= DATE_SUB(NOW(), INTERVAL 2 YEAR)"; $consu_exist = $conexion -> query($query_exist); echo $conta_exist = mysqli_num_rows($consu_exist); $EnTiempo=0; $PorVencer=0; $Vencida=0; while($execu_exist = $consu_exist->fetch_array(MYSQLI_BOTH)){ if( strtotime( sumasdiasemana(date("d-m-Y",strtotime($execu_exist['creacion'])),18) ) > strtotime(date("d-m-Y")) ){ $EnTiempo++; }elseif(strtotime( sumasdiasemana(date("d-m-Y",strtotime($execu_exist['creacion'])),18) ) == strtotime(date("d-m-Y"))){ $PorVencer++; }else{ $Vencida++; } } ?> </div> <h3><a href="index.php?md=4">Ordenes Terminadas</a></h3> <p> <ul class="list-inline widget_tally"> <li> <p> <span class="month" style="width:80%">En tiempo </span> <span class="badge badge-success">    <?php echo $EnTiempo; ?>    </span> </p> </li> <li> <p> <span class="month" style="width:80%">Por vencer </span> <span class="badge badge-warning">    <?php echo $PorVencer?>    </span> </p> </li> <li> <p> <span class="month" style="width:80%">Vencidas </span> <span class="badge badge-danger">    <?php echo $Vencida?>    </span> </p> </li> </ul> </p> </div> </div> <div class="animated flipInY col-lg-2 col-md-2 col-sm-2 "> </div> </div> </div> <!-- <div class="row"> <div class="x_content"> <div style="text-align: center; overflow: hidden; margin: 10px 5px 0;"> <canvas id="canvas_line1" height="100"></canvas> </div> </div> </div> --> </div> </div> </div> </div>

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