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