function getCompany($stock) { $asset = new self(); $where = "COAT_TX_ID='{$stock}'"; $code = $asset->fetchRow($where); return $code->COEM_TX_ID; }
public function getCountryName($code = NULL) { $table = new self(); $rName = $table->info('name'); $select = $table->select()->from($rName); $select->where('iso_code_3 = ?', $code); $item = $table->fetchRow($select); return $item->name; }
public static function fetchRowByID($group_id) { $self = new self(); return $self->fetchRow(array("group_id" => $group_id, "active" => 1)); }
/** * * @param int $id * @return string */ public static function buildNameById($id) { $obj = new self(); $row = $obj->fetchRow($id); return self::buildName($row); }
public static final function getParam($key) { $objParams = new self(); $rowParam = $objParams->fetchRow("name = '{$key}'"); return $rowParam->active == 1 ? trim($rowParam->value) : ''; }
public static function fetchRowByDraftIDProxyID($draft_id, $proxy_id) { $self = new self(); return $self->fetchRow(array(array("key" => "draft_id", "value" => $draft_id, "method" => "=", "mode" => "AND"), array("key" => "proxy_id", "value" => $proxy_id, "method" => "=", "mode" => "AND"))); }
public static function fetchRowByID($id = 0) { $self = new self(); return $self->fetchRow(array(array("key" => "draft_id", "value" => $id, "method" => "=", "mode" => "AND"))); }
public static function get($eventtype_id = null) { $self = new self(); return $self->fetchRow(array("eventtype_id" => $eventtype_id)); }
public static function get($instructional_method_id = null, $active = 1) { $self = new self(); return $self->fetchRow(array(array("key" => "instructional_method_id", "value" => $instructional_method_id, "method" => "="), array("mode" => "AND", "key" => "active", "value" => $active, "method" => "="))); }
public static function fetchRowByID($questiontype_id) { $self = new self(); return $self->fetchRow(array(array("key" => "questiontype_id", "value" => $questiontype_id, "method" => "=", "mode" => "AND"))); }
public static function get($course_id) { $self = new self(); return $self->fetchRow(array("course_id" => $course_id, "course_active" => 1)); }
public static function fetchRowByProxyIDCGroupID($proxy_id, $cgroup_id) { $self = new self(); return $self->fetchRow(array(array("key" => "proxy_id", "value" => $proxy_id, "method" => "=", "mode" => "AND"), array("key" => "cgroup_id", "value" => $cgroup_id, "method" => "=", "mode" => "AND"))); }
public static function fetchRowByEventID($event_id = null) { $self = new self(); return $self->fetchRow(array(array("key" => "event_id", "value" => $event_id, "method" => "="), array("mode" => "AND", "key" => "active", "value" => 1, "method" => "="))); }
public static function fetchRowByCourseIDObjectiveID($course_id, $objective_id, $active = "1") { $self = new self(); return $self->fetchRow(array("course_id" => $course_id, "objective_id" => $objective_id, "active" => $active)); }
public static function fetchRowByID($statistic_id) { $self = new self(); return $self->fetchRow(array("statistic_id" => $statistic_id)); }
public static function fetchRowByID($assessment_id) { $self = new self(); return $self->fetchRow(array(array("key" => "assessment_id", "value" => $assessment_id, "method" => "="), array("mode" => "AND", "key" => "active", "value" => 1, "method" => "="))); }
public static function get($eventtype_id = null, $active = 1) { $self = new self(); return $self->fetchRow(array(array("key" => "eventtype_id", "value" => $eventtype_id, "method" => "="), array("mode" => "AND", "key" => "eventtype_active", "value" => $active, "method" => "="))); }
public static function fetchRowByEventTypeID($event_type_id = null) { $self = new self(); return $self->fetchRow(array("fk_eventtype_id" => $event_type_id)); }