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');
}
