public function setup() { parent::setup(); unset($this['type'], $this['filesize'], $this['created_at'], $this['updated_at']); // add the i18n label stuff if ($this->getObject()->getTable()->isI18n()) { $cultures = sfConfig::get('app_lyMediaManager_i18n_cultures', array()); if (isset($cultures[0])) { throw new sfException('Invalid i18n_cultures format in app.yml. Use the format: i18n_cultures: en: English fr: Français'); } $this->embedI18n(array_keys($cultures)); foreach ($cultures as $culture => $name) { $this->widgetSchema->setLabel($culture, $name); } } $this->widgetSchema['folder_id']->setOption('method', 'getIndentName'); $this->widgetSchema['folder_id']->setOption('order_by', array('lft', '')); if ($this->isNew()) { $this->widgetSchema['filename'] = new sfWidgetFormInputFile(); $this->validatorSchema['filename'] = new lyMediaValidatorFile(array('required' => 'true', 'path' => $this->getOption('upload_root') . sfConfig::get('app_lyMediaManager_media_root', 'media'), 'mime_types' => lyMediaTools::getAllowedMimeTypes(), 'allowed_extensions' => lyMediaTools::getAllowedExtensions())); if ($this->getOption('folder_id')) { $this->setDefault('folder_id', $this->getOption('folder_id')); } } else { $query = Doctrine_query::create()->from('lyMediaFolder')->where('id != ?', $this->getObject()->getFolder()->getId()); $this->widgetSchema['folder_id']->setOption('query', $query); $this->widgetSchema['folder_id']->setOption('add_empty', 'Move to ...'); $this->widgetSchema['filename'] = new sfWidgetFormInput(); $this->validatorSchema['filename'] = new lyMediaValidatorFilename(array('required' => true, 'allowed_extensions' => lyMediaTools::getAllowedExtensions())); } $this->validatorSchema->setPostValidator(new lyMediaValidatorAsset()); }
public function listar($proceso_id) { $proceso = Doctrine::getTable('Proceso')->find($proceso_id); $reportes = Doctrine_query::create()->from('Reporte r')->where('r.proceso_id = ?', $proceso_id)->orderBy('r.id desc')->execute(); if ($proceso->cuenta_id != UsuarioBackendSesion::usuario()->cuenta_id) { echo 'Usuario no tiene permisos para listar los formularios de este proceso'; exit; } $data['proceso'] = $proceso; $data['reportes'] = $reportes; $data['title'] = 'Documentos'; $data['content'] = 'backend/reportes/listar'; $this->load->view('backend/template', $data); }
public function setup() { parent::setup(); unset($this['type'], $this['filesize'], $this['created_at'], $this['updated_at']); $this->widgetSchema['folder_id']->setOption('method', 'getIndentName'); if ($this->isNew()) { $this->widgetSchema['filename'] = new sfWidgetFormInputFile(); $this->validatorSchema['filename'] = new lyMediaValidatorFile(array('required' => 'true', 'path' => $this->getOption('upload_root') . sfConfig::get('app_lyMediaManager_media_root', 'media'), 'mime_types' => lyMediaTools::getAllowedMimeTypes(), 'allowed_extensions' => lyMediaTools::getAllowedExtensions())); if ($user = $this->getOption('user')) { if ($user->getAttribute('view') == 'icons' && $user->getAttribute('folder_id')) { $this->setDefault('folder_id', $user->getAttribute('folder_id')); } } } else { $query = Doctrine_query::create()->from('lyMediaFolder')->where('id != ?', $this->getObject()->getFolder()->getId()); $this->widgetSchema['folder_id']->setOption('query', $query); $this->widgetSchema['folder_id']->setOption('add_empty', 'Move to ...'); $this->widgetSchema['filename'] = new sfWidgetFormInput(); $this->validatorSchema['filename'] = new lyMediaValidatorFilename(array('required' => true, 'allowed_extensions' => lyMediaTools::getAllowedExtensions())); $this->validatorSchema->setPostValidator(new lyMediaValidatorAsset()); } }
public function index($start_date = 'null', $end_date = 'null') { // Download a CDR // Setup the base grid object if ($this->submitted()) { $start_date = $this->input->post('startdate'); $end_date = $this->input->post('enddate'); $exptype = $this->input->post('exporttype'); $q = Doctrine_query::create()->select('*')->from('Xmlcdr'); if ($start_date !== '') { $q->andWhere('start_stamp >= ?', $start_date . ' 00:00:00'); } if ($end_date !== '') { $q->andWhere('end_stamp <= ?', $end_date . ' 23:59:59'); } $exprecs = $q->execute(); $this->doexport($exprecs, $exptype); } $this->grid = jgrid::grid($this->baseModel, array('gridName' => 'downloadrange', 'caption' => 'Call Detail Records', 'sortorder' => 'desc'))->add('xml_cdr_id', 'ID', array('hidden' => true, 'key' => true))->add('start_stamp', 'Start', array('callback' => array($this, 'formatNumber')))->add('end_stamp', 'End', array('callback' => array($this, 'formatNumber')))->add('direction', 'Direction')->add('caller_id_name', 'Caller Name')->add('caller_id_number', 'Caller Number')->add('destination_number', 'Destination', array('callback' => array($this, 'formatNumber')))->add('duration', 'Duration', array('callback' => array($this, 'formatDuration')))->add('hangup_cause', 'Call End Cause')->addAction('xmlcdr/details', 'Details', array('arguments' => 'xml_cdr_id', 'attributes' => array('class' => 'qtipAjaxForm'))); // Only display records from the domains associated with the account $domainlist = Doctrine_Query::create()->select('domain')->from('Location')->fetchArray(); $inlist = array(); foreach ($domainlist as $domain) { $inlist[] = $domain['domain']; } $this->grid->whereIn('domain_name', '', $inlist); // Filter by starting and ending dates if ($start_date !== 'null') { $this->grid->andWhere('start_stamp', '>=', $start_date . ' 00:00:00'); } if ($end_date !== 'null') { $this->grid->andWhere('end_stamp', '<=', $end_date . ' 23:59:59'); } // Let plugins populate the grid as well plugins::views($this); // Produce a grid in the view $this->view->grid = $this->grid->produce(); }
public static function findOneByIdForAdmin($id) { return Doctrine_query::create()->from('Model_Hm_Block b')->where('b.id = ?', $id); }
public function getConceptsbyuser() { $result = Doctrine_query::create()->from('concept')->where('user_id = ?', sfCOntext::getInstance()->getUser()->getGuardUser()->getId())->addWhere('status = "1"')->execute(); return $result; }
public function getConceptsRelation($id) { $result = Doctrine_query::create()->from('InvoiceConcept as i')->where('i.invoice_id = ?', $id)->execute(); return $result; }
public function ver($reporte_id) { $reporte = Doctrine::getTable('Reporte')->find($reporte_id); if ($reporte->Proceso->cuenta_id != UsuarioBackendSesion::usuario()->cuenta_id) { echo 'Usuario no tiene permisos'; exit; } // Reporte del proceso $proceso = $reporte->Proceso; $tramites_completos = 0; $tramites_vencidos = 0; $tramites_pendientes = 0; $etapas_cantidad = 0; foreach ($proceso->Tramites as $tramite) { $etapas_cantidad = Doctrine_query::create()->from('Etapa e')->where('e.tramite_id = ?', $tramite->id)->count(); if ($tramite->pendiente == 0) { $tramites_completos++; } else { if ($etapas_cantidad > 0) { if ($tramite->getTareasVencidas()->count() > 0) { $tramites_vencidos++; } $tramites_pendientes++; } } } $promedio_tramite = $proceso->getDiasPorTramitesAvg(); $promedio_tramite = $promedio_tramite[0]['avg']; // Parametros $query = $this->input->get('query'); $created_at_desde = $this->input->get('created_at_desde'); $created_at_hasta = $this->input->get('created_at_hasta'); $pendiente = $this->input->get('pendiente') !== false ? $this->input->get('pendiente') : -1; $formato = $this->input->get('formato'); $filtro = $this->input->get('filtro'); $offset = $this->input->get('offset'); $per_page = 50; $params = array(); if ($created_at_desde) { array_push($params, 'created_at >= ' . "'" . date('Y-m-d', strtotime($created_at_desde)) . "'"); } if ($created_at_hasta) { array_push($params, 'created_at <= ' . "'" . date('Y-m-d', strtotime($created_at_hasta)) . "'"); } if ($pendiente != -1) { array_push($params, 'pendiente = ' . $pendiente); } if ($query) { $this->load->library('sphinxclient'); $this->sphinxclient->setServer($this->config->item('sphinx_host'), $this->config->item('sphinx_port')); $this->sphinxclient->setFilter('proceso_id', array($reporte->Proceso->id)); $result = $this->sphinxclient->query(json_encode($query), 'tramites'); if ($result['total'] > 0) { $matches = array_keys($result['matches']); array_push($params, 't.id IN (' . implode(',', $matches) . ')'); } else { $params = array('0'); } } if ($formato == "pdf") { $reporte_tabla = $reporte->getReporteAsMatrix($params); $this->load->library('pdf'); $data['tramites_vencidos'] = $tramites_vencidos; $data['tramites_pendientes'] = $tramites_pendientes; $data['tramites_completos'] = $tramites_completos; $data['promedio_tramite'] = $promedio_tramite; $data['reporte'] = $reporte_tabla; $data['title'] = $reporte->nombre . ' - Proceso "' . $reporte->Proceso->nombre . '"'; $html = $this->load->view('backend/reportes/pdf', $data, true); $pdf = $this->pdf->load(); $pdf->WriteHtml($html); $pdf->Output('reporte.pdf', 'D'); } else { if ($formato == "xls") { $reporte_tabla = $reporte->getReporteAsMatrix($params); $CI =& get_instance(); $CI->load->library('Excel_XML'); $CI->excel_xml->addArray($reporte_tabla); $CI->excel_xml->generateXML('reporte'); return; } } $ntramites = count($reporte->getReporteAsMatrix($params)) - 1; $reporte_tabla = $reporte->getReporteAsMatrix($params, $per_page, $offset); $this->load->library('pagination'); $this->pagination->initialize(array('base_url' => site_url('backend/reportes/ver/' . $reporte_id . '?query=' . $query . '&pendiente=' . $pendiente . '&created_at_desde=' . $created_at_desde . '&created_at_hasta=' . $created_at_hasta), 'total_rows' => $ntramites, 'per_page' => $per_page)); $data['tramites_vencidos'] = $tramites_vencidos; $data['tramites_pendientes'] = $tramites_pendientes; $data['tramites_completos'] = $tramites_completos; $data['promedio_tramite'] = $promedio_tramite; $data['filtro'] = $filtro; $data['query'] = $query; $data['reporte_tabla'] = $reporte_tabla; $data['reporte'] = $reporte; $data['pendiente'] = $pendiente; $data['created_at_desde'] = $created_at_desde; $data['created_at_hasta'] = $created_at_hasta; $data['title'] = $reporte->nombre . ' - Proceso "' . $reporte->Proceso->nombre . '"'; $data['content'] = 'backend/reportes/ver'; $this->load->view('backend/template', $data); }
<div id="sidebar"> <? if ($sf_user->getGuardUser()): ?> <div class="widget"> <h2><?php echo __('Profile')?></h2> <p><?php echo $sf_user->getGuardUser()->getLastName(); ?></p> <p><?php echo link_to(__("My entitlements"),"getMyEntitlements/index") ?></p> <p><?php echo link_to(__("Logout"),"saml/logout"); ?></p> </div> <div class="widget"> <h2><?php echo __('My Organizations')?></h2> <? if ($sf_user->getPrincipal()->getOrganization()) : ?> <? $os = $sf_user->getPrincipal()->getOrganization(); ?> <? $ros = $sf_user->getPrincipal()->getRelatedOrganizations(FALSE); ?> <? foreach($os as $o ): ?> <?php $oe = Doctrine_query::create()->select('oe.id')->from('OrganizationEntitlementPack oe')->where('oe.organization_id=?',$o->getId())->execute(); ?> <p><?php echo $o ?> <span class="right"> <?php echo image_tag("icons/user",array("title"=>__("Participants")))?><?php echo count($o->getInvitation()) ?> <?php echo image_tag("icons/application_cascade",array("title"=>__("Subscribed services")))?><?php echo count($oe) ?> <?php echo link_to(image_tag("icons/wrench",array("class"=>"button","title"=>__("Manage organization"))),"show/index?id=".$o->getId()) ?> <?php echo $o->hasPendingService()?image_tag("icons/error",array("title"=>__("Pending service subscribtions"))):"" ?> </p> <? endforeach ?> <?php foreach($ros as $o) :?> <p><?php echo $o ?> <span class="right"> <?php echo link_to(image_tag("icons/group",array("title"=>__('Show organization'))),"show/index?id=".$o->getId()) ?> </span> </p>