public function getEnumAsSqlString() { if ($this->equals(class_orm_comparator_enum::GreaterThen())) { return ">"; } if ($this->equals(class_orm_comparator_enum::GreaterThenEquals())) { return ">="; } if ($this->equals(class_orm_comparator_enum::LessThen())) { return "<"; } if ($this->equals(class_orm_comparator_enum::LessThenEquals())) { return "<="; } if ($this->equals(class_orm_comparator_enum::Equal())) { return "="; } if ($this->equals(class_orm_comparator_enum::NotEqual())) { return "!="; } if ($this->equals(class_orm_comparator_enum::Like())) { return "LIKE"; } throw new class_orm_exception("Unknown sql comparator", class_exception::$level_ERROR); }
/** * Loads all workflows in a given state. * By default limited to those with a exceeded trigger-date, so valid to be run * * @param int $intType * @param bool $bitOnlyWithValidTriggerDate * @return class_module_workflows_workflow[] */ public static function getWorkflowsByType($intType, $bitOnlyWithValidTriggerDate = true) { $objOrmMapper = new class_orm_objectlist(); if ($bitOnlyWithValidTriggerDate) { $objOrmMapper->addWhereRestriction(new class_orm_objectlist_property_restriction("objStartDate", class_orm_comparator_enum::LessThen(), class_date::getCurrentTimestamp())); } $objOrmMapper->addWhereRestriction(new class_orm_objectlist_property_restriction("intState", class_orm_comparator_enum::Equal(), (int) $intType)); $objOrmMapper->addOrderBy(new class_orm_objectlist_orderby("system_date_start DESC")); return $objOrmMapper->getObjectList("class_module_workflows_workflow"); }