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