public function getConfigs() { $c = new Criteria(); $c->clearSelectColumns(); $c->addSelectColumn('MAX(' . SchedulerConfigPeer::ID . ')'); $c->addGroupByColumn(SchedulerConfigPeer::VARIABLE); $c->addGroupByColumn(SchedulerConfigPeer::VARIABLE_PART); $c->addAscendingOrderByColumn(SchedulerConfigPeer::VARIABLE); $c->add(SchedulerConfigPeer::SCHEDULER_ID, $this->id); $c->add(SchedulerConfigPeer::WORKER_ID, null); $rs = SchedulerConfigPeer::doSelectStmt($c, myDbHelper::getConnection(myDbHelper::DB_HELPER_CONN_PROPEL2)); $configIds = $rs->fetchAll(PDO::FETCH_COLUMN, 0); return SchedulerConfigPeer::retrieveByPKs($configIds, myDbHelper::getConnection(myDbHelper::DB_HELPER_CONN_PROPEL2)); }
protected function renderFieldCategory(ConfigFieldCategory $fieldCategory) { $str = ""; $fields = $fieldCategory->getConfigFields(); foreach ($fields as $field) { $str .= "<fieldset>"; $str .= "<legend>" . $field->getName() . "</legend>"; $fieldId = $field->getId(); $cField = new Criteria(); $cField->add(FieldValuePeer::FIELD_ID, $fieldId); /*$c1 = $cField->getNewCriterion(FieldValuePeer::VALUE, $query.'%', Criteria::LIKE); $c2 = $cField->getNewCriterion(FieldValuePeer::VALUE, "", Criteria::NOT_EQUAL); $c1->addAnd($c2); $cField->addAnd($c1);*/ $cField->add(FieldValuePeer::VALUE, "", Criteria::NOT_EQUAL); $cField->addGroupByColumn(FieldValuePeer::VALUE); $cField->addAscendingOrderByColumn(FieldValuePeer::VALUE); $cField->setLimit(15); $values = FieldValuePeer::doSelect($cField); $valueIndex = 0; foreach ($values as $value) { $str .= "<label>" . $value->getValue() . "</label>"; $str .= "<input type=\"checkbox\" name=\"fields[" . $field->getId() . "][{$valueIndex}]\" id=\"fields_" . $field->getId() . "_{$valueIndex}\" value=\"" . $value->getValue() . "\" /><br>"; $valueIndex++; } $str .= "</fieldset>"; } return $str; }
public static function getMakeoverEntries($subp_id, $puser_id, $puser_ids) { $c = new Criteria(); $c->add(entryPeer::TYPE, entryType::MEDIA_CLIP); $c->add(entryPeer::STATUS, entryStatus::READY); $c->addSelectColumn("MAX(" . entryPeer::ID . ")"); $c->addSelectColumn(PuserRolePeer::PUSER_ID); $c->addGroupByColumn(PuserRolePeer::KSHOW_ID); $c->addJoin(entryPeer::KSHOW_ID, PuserRolePeer::KSHOW_ID); $c->add(PuserRolePeer::SUBP_ID, $subp_id); $c->add(PuserRolePeer::ROLE, PuserRole::PUSER_ROLE_RECIPIENT); $c->add(PuserRolePeer::PUSER_ID, explode(",", $puser_ids . ',' . $puser_id), Criteria::IN); $rs = entryPeer::doSelectStmt($c); $entry_ids = array(); $entry_puser_ids = array(); $res = $rs->fetchAll(); foreach ($res as $record) { $entry_ids[] = $record[0]; $entry_puser_ids[] = $record[1]; } // // old code from doSelectRs // while($rs->next()) // { // $entry_ids[] = $rs->getInt(1); // $entry_puser_ids[] = $rs->getString(2); // } return array($entry_ids, $entry_puser_ids); }
public static function getEquipmentMileage($userId, $bikeId) { $c = new Criteria(); $c->clearSelectColumns(); $c->addSelectColumn('SUM(' . UserStatsPeer::MILEAGE . ')'); $c->addSelectColumn(UserEquipementPeer::EQUIPMENT_ID); //$c->addGroupByColumn(UserRidesPeer::MILEAGE); $c->add(UserEquipementPeer::USER_ID, $userId); $c->add(UserEquipementPeer::BIKE_ID, $bikeId); $c->addJoin(UserEquipementPeer::EQUIPMENT_ID, UserStatEquipPeer::USER_EQUIP_ID, Criteria::INNER_JOIN); $c->addJoin(UserStatEquipPeer::USER_STAT_ID, UserStatsPeer::STAT_NO, Criteria::INNER_JOIN); //$c->addJoin(UserStatsPeer::RIDE_KEY,UserRidesPeer::USER_RIDE_ID, Criteria::INNER_JOIN); $c->addGroupByColumn(UserEquipementPeer::EQUIPMENT_ID); $stmt = UserStatsPeer::doSelectStmt($c); $hashmap = array(); if ($stmt) { while ($row = $stmt->fetch(PDO::FETCH_NUM)) { if ($row) { $sum = $row[0]; $eqId = $row[1]; //echo 'Mil '.$sum.' '.$eqId; $hashmap[$eqId] = $sum; // array_push($hashmap, $eqId=>$sum); } } } return $hashmap; }
public static function getKshowRoughcutCount(array $kuser_id_list) { $c = new Criteria(); $c->add(entryPeer::TYPE, entryType::MIX); $c->add(entryPeer::KSHOW_ID, $kuser_id_list, Criteria::IN); $c->addSelectColumn(entryPeer::KSHOW_ID); $c->addAsColumn('cnt', 'COUNT(' . entryPeer::KSHOW_ID . ')'); $c->addGroupByColumn(entryPeer::KSHOW_ID); $rs = entryPeer::doSelectStmt($c); $kusers_roughcuts = array(); $res = $rs->fetchAll(); foreach ($res as $record) { $id = $record[0]; $cnt = $record[1]; $kusers_roughcuts[$id] = $cnt; } // // old code from doSelectRs // while($rs->next()) // { // $id= $rs->getInt(1); // $cnt = $rs->getInt(2); // $kusers_roughcuts[$id]=$cnt; // } $rs->close(); return $kusers_roughcuts; }
/** * Commits changes (increases serial by 1) * * @return Array on success, string on error */ public static function commit() { // do some checks first $pdns_version = trim(shell_exec("sudo /usr/bin/pdns_control version 2>&1")); if (!preg_match('/^[0-9,\\.]+$/', $pdns_version)) { if (preg_match('/\\[sudo\\] password/', $pdns_version)) { return "Unable to run 'sudo /usr/bin/pdns_control'. Is it defined in sudoers file?"; } else { return $pdns_version; } } $commited = array(); $c = new Criteria(); $c->add(AuditPeer::OBJECT, 'Record'); $c->addGroupByColumn(AuditPeer::DOMAIN_ID); $c->add(AuditPeer::CREATED_AT, date("Y-m-d H:i:s", MyTools::getLastCommit()), Criteria::GREATER_THAN); foreach (AuditPeer::doSelect($c) as $audit) { $domain = DomainPeer::retrieveByPK($audit->getDomainId()); $commited[] = $domain->getName(); // get SOA record $c = new Criteria(); $c->add(RecordPeer::DOMAIN_ID, $domain->getId()); $c->add(RecordPeer::TYPE, 'SOA'); $SOA = RecordPeer::doSelectOne($c); $temp = explode(" ", $SOA->getContent()); $serial = $temp[2]; $date = substr($serial, 0, 8); $id = substr($serial, 8); // today ? if ($date == date("Ymd")) { $id++; if (strlen($id) == 1) { $id = "0" . $id; } $serial = $date . $id; } else { $serial = date("Ymd") . "01"; } if ($serial >= 4294967295) { continue; } // don't allow >= 32bit unsigned $SOA->setContent(implode(" ", array($temp[0], $temp[1], $serial))); $SOA->save(); } if ($commited) { SettingPeer::setValue('last_commit', time()); sleep(2); if ($also_notify = sfConfig::get('app_default_also-notify')) { foreach ($commited as $domain) { foreach ($also_notify as $host) { exec("sudo /usr/bin/pdns_control notify-host {$domain} {$host}"); } } } } return $commited; }
/** * Retorna les llistes relacionades amb un missatge * @param $idM idMissatge * @return Select LlistesLlistes * */ public static function getLlistesMissatge($idM) { $C = new Criteria(); $C->add(self::ACTIU, true); $C->addJoin(LlistesLlistesMissatgesPeer::IDLLISTA, self::IDLLISTA); $C->add(LlistesLlistesMissatgesPeer::IDMISSATGE, $idM); $C->add(LlistesLlistesMissatgesPeer::ACTIU, true); $C->addGroupByColumn(self::IDLLISTA); return self::doSelect($C); }
public function executeListarPorCategoria(sfWebRequest $requets) { $cat = $requets->getParameter('id'); $nomCat = CategoriaQuery::create(); $nomCat->filterById($cat); $this->categoria = $nomCat->findOne(); //logica de negocio: no_autenticados o menores NO xxx if ($cat == 8) { if (!$this->getUser()->isAuthenticated()) { $this->mje = "Usted no esta logueado, no puede acceder a esta sección!"; return sfView::ERROR; } else { $edad = $this->getUser()->getAttribute('edad'); if ($edad < 18) { $this->mje = "Usted es menor de edad y no puede acceder a esta sección!"; return sfView::ERROR; } } } //10 es el numero de registros que deseo mostrar $paginacion = new sfPropelPager('Pelicula', 10); $sql = new Criteria(); $sql->add(PeliculaPeer::CATEGORIA_ID, $cat, Criteria::EQUAL); $sql->addAscendingOrderByColumn(PeliculaPeer::TITULO); $sql->addGroupByColumn(PeliculaPeer::TITULO); $paginacion->setCriteria($sql); $paginacion->setPage($this->getRequestParameter('pag', 1)); $paginacion->init(); $this->peliculas = $paginacion; /*$cat = $requets->getParameter('id'); $nomCat = CategoriaQuery::create(); $nomCat->filterById($cat); $this->categoria = $nomCat->findOne(); if ($cat == 8){ if(!$this->getUser()->isAuthenticated()){ $this->mje = "Usted no esta logueado, no puede acceder a esta sección!"; return sfView::ERROR; }else{ $edad = $this->getUser()->getAttribute('edad'); if($edad < 18){ $this->mje = "Usted es menor de edad y no puede acceder a esta sección!"; return sfView::ERROR; } } } $this->peliculas = PeliculaQuery::create() ->filterByEstado('1') ->filterByCategoriaId($cat) ->groupByTitulo() ->find(); * */ }
/** * Returns CareerSubjectSchoolYears for a given examination * * @param Examination $examination * @param PropelPDO $con * @return CareerSubjectSchoolYear[] */ public static function retrieveForExamination(Examination $examination, PropelPDO $con) { $con = is_null($con) ? Propel::getConnection() : $con; $c = new Criteria(); $c->addJoin(CourseSubjectStudentExaminationPeer::COURSE_SUBJECT_STUDENT_ID, CourseSubjectStudentPeer::ID); $c->addJoin(CourseSubjectStudentPeer::COURSE_SUBJECT_ID, CourseSubjectPeer::ID); $c->addJoin(CourseSubjectPeer::CAREER_SUBJECT_SCHOOL_YEAR_ID, self::ID); $c->addJoin(self::CAREER_SCHOOL_YEAR_ID, CareerSchoolYearPeer::ID); $c->add(CareerSchoolYearPeer::SCHOOL_YEAR_ID, $examination->getSchoolYearId()); $c->add(CourseSubjectStudentExaminationPeer::EXAMINATION_NUMBER, $examination->getExaminationNumber()); $c->addGroupByColumn(self::ID); return self::doSelect($c, $con); }
public function stringData() { $oCriteria = new Criteria(); $oCriteria->addGroupByColumn(TranslationPeer::STRING_KEY); $oCriteria->add(TranslationPeer::STRING_KEY, $this->sStringId); $oString = TranslationPeer::doSelectOne($oCriteria); if ($oString === null) { $oString = new Translation(); } $aResult = $oString->toArray(); $aResult['CreatedInfo'] = Util::formatCreatedInfo($oString); $aResult['UpdatedInfo'] = Util::formatUpdatedInfo($oString); return $aResult; }
public static function getTagsWithCount() { $c = new Criteria(); $c->clearSelectColumns()->clearOrderByColumns(); $c->addSelectColumn(self::TAG); $c->addSelectColumn('count(' . self::SF_BLOG_POST_ID . ') as count'); $c->addGroupByColumn(self::TAG); $rs = self::doSelectRS($c); $tags = array(); while ($rs->next()) { $tags[] = array($rs->getString(1), $rs->getInt(2)); } return $tags; }
private static function CriteriaEmailsFromLlistes($A_llistes, $all = false) { $C = new Criteria(); if (!$all) { $C->add(self::ACTIU, true); } $C->add(self::IDLLISTA, $A_llistes, CRITERIA::IN); $C->addJoin(LlistesEmailsPeer::IDEMAIL, self::IDEMAIL); $C->add(LlistesEmailsPeer::ACTIU, true); //Si està de baixa global, ho haurà d'informar a informatica $C->addGroupByColumn(self::IDEMAIL); $C->addAscendingOrderByColumn(LlistesEmailsPeer::EMAIL); return $C; }
public static function retrieveCriteriaByCareerSchoolYearAndStudent(CareerSchoolYear $career_school_year, Student $student, PropelPDO $con = null, $approved = false) { if (is_null($con)) { $con = Propel::getConnection(); } $c = new Criteria(); $c->add(CareerSubjectSchoolYearPeer::CAREER_SCHOOL_YEAR_ID, $career_school_year->getId()); $c->addJoin(CourseSubjectPeer::CAREER_SUBJECT_SCHOOL_YEAR_ID, CareerSubjectSchoolYearPeer::ID); $c->addJoin(CourseSubjectPeer::ID, self::COURSE_SUBJECT_ID); $c->add(self::STUDENT_ID, $student->getId()); if ($approved) { $c->add(self::STUDENT_APPROVED_COURSE_SUBJECT_ID, null, Criteria::ISNOTNULL); } $c->addGroupByColumn(self::COURSE_SUBJECT_ID); return $c; }
public static function doSelectDirectlyMonitoredByUser($user, $criteria = null) { if (!$user instanceof OppUser) { throw new Exception('A user must be specified'); } // fetch directly monitored acts $directly_monitored_acts_pks = Util::transformIntoPKs($user->getMonitoredObjects('OppAtto', $criteria)); // fetch types of acts directly monitored $c = new Criteria(); $c->addJoin(OppTipoAttoPeer::ID, OppAttoPeer::TIPO_ATTO_ID); $c->addGroupByColumn(OppAttoPeer::TIPO_ATTO_ID); $c->add(OppAttoPeer::ID, $directly_monitored_acts_pks, Criteria::IN); $directly_monitored_acts_types = OppTipoAttoPeer::doSelect($c); unset($c); return $directly_monitored_acts_types; }
public function execute($request) { $brandId = $this->getRequestParameter('brand'); $query = $this->getRequestParameter('query'); //get series for this brand $cSeries = new Criteria(); if ($brandId) { $cSeries->add(SeriesPeer::BRAND_ID, $brandId); } $cSeries->add(SeriesPeer::SERIES_NAME, $query . '%', Criteria::LIKE); $cSeries->addGroupByColumn(SeriesPeer::SERIES_NAME); $cSeries->addAscendingOrderByColumn(SeriesPeer::SERIES_NAME); $cSeries->setLimit(15); $this->serieses = SeriesPeer::doSelect($cSeries); $this->getResponse()->setContentType('application/json'); }
public function getTags() { $c = new Criteria(); $c->add(QuestionTagPeer::QUESTION_ID, $this->getId()); $c->addGroupByColumn(QuestionTagPeer::NORMALIZED_TAG); $c->setDistinct(); $c->addAscendingOrderByColumn(QuestionTagPeer::NORMALIZED_TAG); $tags = array(); foreach (QuestionTagPeer::doSelect($c) as $tag) { if (sfConfig::get('app_permanent_tag') == $tag) { continue; } $tags[] = $tag->getNormalizedTag(); } return $tags; }
/** * Execute digitalobject list action * * @param sfWebRequest $request */ public function execute($request) { // Build funky join query to get a count of top level digital objects // for each media type (term) $criteria = new Criteria(); $criteria->add(QubitTerm::TAXONOMY_ID, QubitTaxonomy::MEDIA_TYPE_ID); $criteria->addJoin(QubitTerm::ID, QubitDigitalObject::MEDIA_TYPE_ID, Criteria::LEFT_JOIN); $criteria->addAsColumn('hits', 'COUNT(' . QubitDigitalObject::ID . ')'); $criteria->addGroupByColumn(QubitTerm::ID); // Add I18n fallback $criteria = QubitCultureFallback::addFallbackCriteria($criteria, 'QubitTerm'); $criteria->addAscendingOrderByColumn('name'); // Filter drafts $criteria->addJoin(QubitDigitalObject::INFORMATION_OBJECT_ID, QubitInformationObject::ID); $criteria = QubitAcl::addFilterDraftsCriteria($criteria); $this->terms = QubitTerm::get($criteria); }
public static function getFrontPagePager($page) { $pager = new sfPropelPager('Question', sfConfig::get('app_pager_homepage_max')); $c = new Criteria(); $c->addAsColumn('count', "count(" . InterestPeer::USER_ID . ")"); $c->addJoin(InterestPeer::QUESTION_ID, QuestionPeer::ID); $c->addGroupByColumn(InterestPeer::QUESTION_ID); $c->addDescendingOrderByColumn('count'); $c->addDescendingOrderByColumn(self::CREATED_AT); $c->add(InterestPeer::CREATED_AT, time() - 86400 * 10, Criteria::GREATER_THAN); $c = self::addPermanentTagToCriteria($c); $pager->setCriteria($c); $pager->setPage($page); $pager->setPeerMethod('doSelectJoinUser'); $pager->init(); return $pager; }
public static function getCercaTasques($QUAN, $IDU, $PAGINA, $JOFAIG) { $C = new Criteria(); if ($QUAN == 1) { //Avui $IN = date("Y-m-d", mktime(0, 0, 0, date('m', time()), date('d', time()), date('Y', time()))); $FI = date("Y-m-d", mktime(0, 0, 0, date('m', time()), date('d', time()), date('Y', time()))); } elseif ($QUAN == 2) { //Setmanal $IN = date("Y-m-d", mktime(0, 0, 0, date('m', time()), date('d', time()), date('Y', time()))); $FI = date("Y-m-d", mktime(0, 0, 0, date('m', time()), date('d', time()) + 7, date('Y', time()))); } elseif ($QUAN == 3) { //Mensual $IN = date("Y-m-d", mktime(0, 0, 0, date('m', time()), date('d', time()), date('Y', time()))); $FI = date("Y-m-d", mktime(0, 0, 0, date('m', time()) + 1, date('d', time()), date('Y', time()))); } else { $IN = date("Y-m-d", mktime(0, 0, 0, date('m', time()), date('d', time()), date('Y', time()))); $FI = date("Y-m-d", mktime(0, 0, 0, date('m', time()), date('d', time()), date('Y', time()))); } if ($JOFAIG) { $C->add(TasquesPeer::QUIFA, $IDU); } else { $C->add(TasquesPeer::QUIMANA, $IDU); } $C1 = $C->getNewCriterion(TasquesPeer::APARICIO, $IN, CRITERIA::GREATER_EQUAL); $C2 = $C->getNewCriterion(TasquesPeer::APARICIO, $FI, CRITERIA::LESS_EQUAL); $C1->addAnd($C2); $C3 = $C->getNewCriterion(TasquesPeer::DESAPARICIO, $IN, CRITERIA::GREATER_EQUAL); $C4 = $C->getNewCriterion(TasquesPeer::DESAPARICIO, $FI, CRITERIA::LESS_EQUAL); $C3->addAnd($C4); $C5 = $C->getNewCriterion(TasquesPeer::APARICIO, $IN, CRITERIA::LESS_EQUAL); $C6 = $C->getNewCriterion(TasquesPeer::DESAPARICIO, $FI, CRITERIA::GREATER_EQUAL); $C5->addAnd($C6); $C1->addOr($C3); $C1->addOr($C5); $C->add($C1); $C->addAscendingOrderByColumn(TasquesPeer::ISFETA); $C->addAscendingOrderByColumn(TasquesPeer::DESAPARICIO); $C->addAscendingOrderByColumn(TasquesPeer::TASQUESID); $C->addGroupByColumn(TasquesPeer::TASQUESID); $pager = new sfPropelPager('Tasques', 10); $pager->setCriteria($C); $pager->setPage($PAGINA); $pager->init(); return $pager; }
public function execute($request) { $seriesName = $this->getRequestParameter('series'); $query = $this->getRequestParameter('query'); //load series $cSeries = new Criteria(); $cSeries->add(SeriesPeer::SERIES_NAME, $seriesName, Criteria::EQUAL); $series = SeriesPeer::doSelectOne($cSeries); //get models for this series $cModel = new Criteria(); $cModel->add(ModelPeer::SERIES_ID, $series->getId()); $cModel->add(ModelPeer::MODEL_NAME, $query . '%', Criteria::LIKE); $cModel->addGroupByColumn(ModelPeer::MODEL_NAME); $cModel->addAscendingOrderByColumn(ModelPeer::MODEL_NAME); $cModel->setLimit(15); $this->models = ModelPeer::doSelect($cModel); $this->getResponse()->setContentType('application/json'); }
public function execute($request) { $fieldName = $this->getRequestParameter('field'); $query = $this->getRequestParameter('query'); //get field ID $fieldNameArr = explode('_', $fieldName); $fieldId = $fieldNameArr[1]; $cField = new Criteria(); $cField->add(FieldValuePeer::FIELD_ID, $fieldId); $c1 = $cField->getNewCriterion(FieldValuePeer::VALUE, $query . '%', Criteria::LIKE); $c2 = $cField->getNewCriterion(FieldValuePeer::VALUE, "", Criteria::NOT_EQUAL); $c1->addAnd($c2); $cField->addAnd($c1); $cField->addGroupByColumn(FieldValuePeer::VALUE); $cField->addAscendingOrderByColumn(FieldValuePeer::VALUE); $cField->setLimit(15); $this->values = FieldValuePeer::doSelect($cField); $this->getResponse()->setContentType('application/json'); }
/** * retrieve all the top terms names with the number of tags it contains * * @return associative array * (ID => ('denominazione' => DENOM, 'counter' => COUNT)) * @author Guglielmo Celata */ public static function getAllWithCount() { $c = new Criteria(); $c->addSelectColumn(self::ID); $c->addSelectColumn(self::DENOMINAZIONE); $c->addSelectColumn('COUNT(' . self::ID . ') as counter'); $c->addJoin(OppTagHasTtPeer::TESEOTT_ID, self::ID); $c->addGroupByColumn(self::ID); $c->addAscendingOrderByColumn(self::DENOMINAZIONE); if (Propel::VERSION >= '1.3') { $rs = self::doSelectStmt($c); while ($row = $rs->fetch(PDO::FETCH_NUM)) { $tts[$row[0]] = array('denominazione' => $row[1], 'counter' => $row[2]); } } else { $rs = self::doSelectRS($c); while ($rs->next()) { $tts[$rs->getInt(1)] = array('denominazione' => $rs->getString(2), 'counter' => $rs->getInt(3)); } } return $tts; }
function getAllUsersByAuthSource() { $oCriteria = new Criteria('rbac'); $oCriteria->addSelectColumn(RbacUsersPeer::UID_AUTH_SOURCE); $oCriteria->addSelectColumn('COUNT(*) AS CNT'); $oCriteria->add(RbacUsersPeer::USR_STATUS, 'CLOSED', Criteria::NOT_EQUAL); $oCriteria->addGroupByColumn(RbacUsersPeer::UID_AUTH_SOURCE); $oDataset = RbacUsersPeer::doSelectRS($oCriteria); $oDataset->setFetchmode(ResultSet::FETCHMODE_ASSOC); $aAuth = array(); while ($oDataset->next()) { $row = $oDataset->getRow(); $aAuth[$row['UID_AUTH_SOURCE']] = $row['CNT']; } return $aAuth; }
public function executeEditAbsence() { $employee_id = sfContext::getInstance()->getUser()->getAttribute('user_id', null, 'bo'); $employee = EmployeePeer::retrieveByPK($employee_id); $this->forward404Unless($employee); $counseling_id = $this->getRequestParameter('counseling_id'); $counseling = CounselingPeer::retrieveByPK($counseling_id); $this->forward404Unless($counseling); $accal_id = $this->getRequestParameter('accal_id'); $academic_calendar = AcademicCalendarPeer::retrieveByPK($accal_id); $this->forward404Unless($academic_calendar); $student_id = $this->getRequestParameter('student_id'); $student = StudentPeer::retrieveByPk($student_id); $this->forward404Unless($student); $date = $this->getRequestParameter('date'); $status = $this->getRequestParameter('status'); $c = new Criteria(); $c->add(StudentAbsencePeer::STUDENT_ID, $student->getId()); $c->add(StudentAbsencePeer::ACADEMIC_CALENDAR_ID, $academic_calendar->getId()); $c->add(StudentAbsencePeer::START, $date); $c->addGroupByColumn(StudentAbsencePeer::START); $c->addGroupByColumn(StudentAbsencePeer::STUDENT_ID); $c->addGroupByColumn(StudentAbsencePeer::ACADEMIC_CALENDAR_ID); $c->addGroupByColumn(StudentAbsencePeer::CLASS_GROUP_ID); $student_absence = StudentAbsencePeer::doSelectOne($c); $actions = array(array('name' => 'save', 'type' => 'submit', 'options' => array('class' => 'save_button', 'onclick' => "action_type.value=this.value"))); array_push($actions, array('name' => 'delete', 'url' => 'counseling_sd/deleteAbsence?date=' . $date . '&student_id=' . $student->getId() . '&counseling_id=' . $counseling->getId() . '&accal_id=' . $academic_calendar->getId(), 'color' => 'red')); array_push($actions, array('name' => 'cancel', 'url' => 'counseling_sd/listAbsence?student_id=' . $student->getId() . '&counseling_id=' . $counseling->getId() . '&accal_id=' . $academic_calendar->getId(), 'color' => 'white')); $this->actions = $actions; $this->type = 'edit'; $this->counseling = $counseling; $this->date = $date; $this->counseling_id = $counseling_id; $this->student = $student; $this->employee = $employee; $this->academic_calendar = $academic_calendar; $this->status = $status; $this->student_absence = $student_absence; $this->subtitle = $student->toString() . ' - id:' . $student->getId(); $actions2 = array(array('name' => '<span>' . $academic_calendar->toString() . '</span>', 'url' => 'counseling_new/listStudent?accal_id=' . $academic_calendar->getId() . '&counseling_id=' . $counseling->getId(), 'color' => 'sky')); array_push($actions2, array('name' => '<span>Absence Recapt</span>', 'url' => 'counseling_sd/listAbsence?student_id=' . $student->getId() . '&counseling_id=' . $counseling->getId() . '&accal_id=' . $academic_calendar->getId(), 'color' => 'sun', 'type' => 'direct')); $this->actions2 = $actions2; }
echo $i + ($pager->getPage() - 1) * $pager->getMaxPerPage(); ?> </td> <td class='first' style="text-align: left"><?php echo $student->getName() ? $student->getName() : '-'; ?> </td> <?php $c = new Criteria(); $c->add(StudentAbsencePeer::STUDENT_ID, $student->getId()); $c->add(StudentAbsencePeer::ACADEMIC_CALENDAR_ID, $academic_calendar->getId()); $cton1 = $c->getNewCriterion(StudentAbsencePeer::START, $tahun . '-' . $title->getId() . '-1', Criteria::GREATER_EQUAL); $cton2 = $c->getNewCriterion(StudentAbsencePeer::START, $tahun . '-' . ($title->getId() + 1) . '-1', Criteria::LESS_THAN); $cton1->addAnd($cton2); $c->add($cton1); $c->addGroupByColumn(StudentAbsencePeer::START); $c->addGroupByColumn(StudentAbsencePeer::STUDENT_ID); $c->addGroupByColumn(StudentAbsencePeer::ACADEMIC_CALENDAR_ID); $c->addGroupByColumn(StudentAbsencePeer::CLASS_GROUP_ID); $sas = StudentabsencePeer::doSelect($c); $absence = array(); if (count($sas)) { foreach ($sas as $sa) { $absence[$sa->getStart()] = $sa->getStatus(); $absence[$sa->getStatus()] = (array_key_exists($sa->getStatus(), $absence) ? $absence[$sa->getStatus()] : 0) + 1; } } ?> <?php $tgl = 0; while ($tgl < $jumHari) {
function getDatasetCasesByProcess() { $dataSet = new XYDataSet(); $processObj = new Process(); $c = new Criteria('workflow'); $c->clearSelectColumns(); $c->addSelectColumn(ApplicationPeer::PRO_UID); $c->addSelectColumn('COUNT(*) AS CANT'); //$c->addJoin( ProcessPeer::PRO_UID, ProcessPeer::PRO_UID, Criteria::LEFT_JOIN); $c->addGroupByColumn(ApplicationPeer::PRO_UID); $rs = ApplicationPeer::doSelectRS($c); $rs->setFetchmode(ResultSet::FETCHMODE_ASSOC); $rs->next(); $row = $rs->getRow(); while (is_array($row)) { $processObj->load($row['PRO_UID']); $label = $processObj->getProTitle(); $value = $row['CANT']; $dataSet->addPoint(new Point($label, (int) $value)); $rs->next(); $row = $rs->getRow(); } return $dataSet; }
public function getAllProcessesByCategory() { $oCriteria = new Criteria('workflow'); $oCriteria->addSelectColumn(ProcessPeer::PRO_CATEGORY); $oCriteria->addSelectColumn('COUNT(*) AS CNT'); $oCriteria->addGroupByColumn(ProcessPeer::PRO_CATEGORY); $oDataSet = ProcessPeer::doSelectRS($oCriteria, Propel::getDbConnection('workflow_ro')); $oDataSet->setFetchmode(ResultSet::FETCHMODE_ASSOC); $aProc = array(); while ($oDataSet->next()) { $row = $oDataSet->getRow(); $aProc[$row['PRO_CATEGORY']] = $row['CNT']; } return $aProc; }
public static function sendAlertsForNewRoughcut($kshow, $likuser_id, $user_screenname) { $kshow_id = $kshow->getId(); // Send an email alert to producer if ($kshow->getProducerId() != $likuser_id) { // don't send producer alerts when the producer is the editor alertPeer::sendEmailIfNeeded($kshow->getProducerId(), alert::KALTURAS_PRODUCED_ALERT_TYPE_ROUGHCUT_CREATED, array('screenname' => $user_screenname, 'kshow_name' => $kshow->getName(), 'kshow_id' => $kshow->getId())); } // TODO: efficiency: see if there is a wa to search for contributors based on some other method than full entry table scan // Send email alerts to contributors $c = new Criteria(); $c->add(entryPeer::KSHOW_ID, $kshow_id); $c->add(entryPeer::KUSER_ID, $likuser_id, Criteria::NOT_EQUAL); // the current user knows they just edited $c->addAnd(entryPeer::KUSER_ID, $kshow->getProducerId(), Criteria::NOT_EQUAL); // the producer knows they just edited $c->add(entryPeer::TYPE, entryType::MEDIA_CLIP); $c->addGroupByColumn(entryPeer::KUSER_ID); $entries = entryPeer::doSelect($c); $already_received_alert_array = array(); foreach ($entries as $entry) { alertPeer::sendEmailIfNeeded($entry->getKuserId(), alert::KALTURAS_PARTOF_ALERT_TYPE_ROUGHCUT_CREATED, array('screenname' => $user_screenname, 'kshow_name' => $kshow->getName(), 'kshow_id' => $kshow->getId())); $already_received_alert_array[$entry->getKuserId()] = true; } // send email alert to subscribers $c = new Criteria(); $c->add(KshowKuserPeer::KSHOW_ID, $kshow_id); //only subsribers of this show $c->add(KshowKuserPeer::KUSER_ID, $likuser_id, Criteria::NOT_EQUAL); // the current user knows they just edited $c->add(KshowKuserPeer::SUBSCRIPTION_TYPE, KshowKuser::KSHOW_SUBSCRIPTION_NORMAL); // this table stores other relations too $subscriptions = KshowKuserPeer::doSelect($c); foreach ($subscriptions as $subscription) { if (!isset($already_received_alert_array[$subscription->getKuserId()])) { // don't send emails to subscribed users who are also contributors alertPeer::sendEmailIfNeeded($subscription->getKuserId(), alert::KALTURAS_SUBSCRIBEDTO_ALERT_TYPE_ROUGHCUT_CREATED, array('screenname' => $user_screenname, 'kshow_name' => $kshow->getName(), 'kshow_id' => $kshow->getId())); } } }
function getLastLoginAllUsers() { $c = new Criteria(); $c->addSelectColumn(LoginLogPeer::USR_UID); $c->addAsColumn('LAST_LOGIN', 'MAX(LOG_INIT_DATE)'); $c->addGroupByColumn(LoginLogPeer::USR_UID); $Dat = LoginLogPeer::doSelectRS($c); $Dat->setFetchmode(ResultSet::FETCHMODE_ASSOC); $aRows = array(); while ($Dat->next()) { $row = $Dat->getRow(); $aRows[$row['USR_UID']] = $row['LAST_LOGIN']; } return $aRows; }
public function testMergeWithGroupByColumns() { $c1 = new Criteria(); $c1->addGroupByColumn(BookPeer::TITLE); $c1->addGroupByColumn(BookPeer::ID); $c2 = new Criteria(); $c1->mergeWith($c2); $this->assertEquals(array(BookPeer::TITLE, BookPeer::ID), $c1->getGroupByColumns(), 'mergeWith() does not remove an existing groupby columns'); $c1 = new Criteria(); $c2 = new Criteria(); $c2->addGroupByColumn(BookPeer::TITLE); $c2->addGroupByColumn(BookPeer::ID); $c1->mergeWith($c2); $this->assertEquals(array(BookPeer::TITLE, BookPeer::ID), $c1->getGroupByColumns(), 'mergeWith() merges the select columns to an empty groupby'); $c1 = new Criteria(); $c1->addGroupByColumn(BookPeer::TITLE); $c2 = new Criteria(); $c2->addGroupByColumn(BookPeer::ID); $c1->mergeWith($c2); $this->assertEquals(array(BookPeer::TITLE, BookPeer::ID), $c1->getGroupByColumns(), 'mergeWith() merges the select columns after the existing groupby columns'); $c1 = new Criteria(); $c1->addGroupByColumn(BookPeer::TITLE); $c2 = new Criteria(); $c2->addGroupByColumn(BookPeer::TITLE); $c1->mergeWith($c2); $this->assertEquals(array(BookPeer::TITLE), $c1->getGroupByColumns(), 'mergeWith() does not merge duplicated groupby columns'); }