public function getNumeroSolicitudes($id) { $criteria = new CDbCriteria(); $criteria->addCondition("nombre=" . $id); $solicitudes = Solicitud::model()->count($criteria); return number_format($solicitudes); }
public function actionAjaxObtenerNroSolicitud() { $solicitud = Solicitud::model()->ObtenerNroSolicitud(); header('Content-Type: application/json; charset="UTF-8"'); echo CJSON::encode(array('output' => $solicitud[0])); }
<section class="content"> <div class="row"> <div class="col-md-6"> <div class="row"> <div class="col-md-12"> <div class="info-box bg-aqua"> <span class="info-box-icon"> <i class="fa fa-files-o"></i> </span> <div class="info-box-content"> <span class="info-box-text"> Solicitudes pendientes </span> <span class="info-box-number"> <?php $count = count(Solicitud::model()->findAllBySql("select * from solicitud sol, orden ord where sol.id = ord.idSolicitud AND ord.trabajo_realizado is NULL")); echo $count; ?> </span> <span class="progress-description"> <a href="<?php echo Yii::app()->createUrl('solicitud/index'); ?> " class="btn btn-xs btn-default"> VER </a> </span> </div> </div> </div> </div>
<section class="content"> <div class="row"> <div class="col-md-6"> <div class="row"> <div class="col-md-12"> <div class="info-box bg-aqua"> <span class="info-box-icon"> <i class="fa fa-files-o"></i> </span> <div class="info-box-content"> <span class="info-box-text"> Solicitudes sin autorizar </span> <span class="info-box-number"><?php $count = count(Solicitud::model()->findAll("estado1 is null AND area=" . $datos->profile->idDepartamento)); echo $count; ?> </span> <span class="progress-description"> <a href="<?php echo Yii::app()->createUrl('solicitud/index'); ?> " class="btn btn-xs btn-default"> VER </a> </span> </div> </div> </div> <div class="col-md-12"> <div class="info-box bg-aqua">
</div> <div class="icon"> <i class="fa fa-check-square-o"></i> </div> <a href="#" class="small-box-footer">... <!--Ver más <i class="fa fa-arrow-circle-right"></i>--> </a> </div> </div> <div class="col-md-4"> <div class="small-box bg-red"> <div class="inner"> <h3> <?php $solicitudes = Solicitud::model()->findAllByAttributes(array('estado' => 1, 'fecha' => date(Y - m - d))); $n = Solicitud::model()->count('estado=0'); ?> <?php if ($n == 0) { echo "No hay"; } else { echo $n; } ?> </h3> <p> Entrantes </p> </div> <div class="icon"> <i class="fa fa-minus-square"></i>