1917,14 → 1917,19 |
* @return string |
*/ |
public function showRepositoriesList($name, $actor, $format = 'list') { |
$query = "SELECT r.*,rt.*,CONCAT(v.version,' ',v.vname) AS fullname FROM ".$this->prefix."repository r "; |
$query = "SELECT r.*,rt.*,v.version_id,CONCAT(v.version,' ',v.vname) AS fullname FROM ".$this->prefix."repository r "; |
$query .= "JOIN ".$this->prefix."rtype rt ON rt.rtype_id=r.rtype_id "; |
$query .= "JOIN ".$this->prefix."version v ON v.version_id=r.version "; |
$query .= "ORDER BY v.version_id,r.rep_id ASC"; |
$rq =& $this->db->query($query); |
$show = "<ul>"; |
$splitter = 0; |
while ($rq->fetchInto($element)) { |
$show .= "<li>[<a href='".$actor."?mode=".$name."&action=edit&uuid=".$this->secure->checkInt($element["rep_id"])."' class='edit'>править</a>][<a href='".$actor."?mode=".$name."&action=delete&uuid=".$this->secure->checkInt($element["rep_id"])."' class='delete'>удалить</a>] ".$this->secure->checkStr($element["repname"],1)." (".$this->secure->checkStr($element["fullname"],1)." — ".$this->secure->checkStr($element["rtype"],1).")</li>\n"; |
if ($splitter != $this->secure->checkInt($element["version_id"])) { |
$splitter = $this->secure->checkInt($element["version_id"]); |
$show .= "</ul><ul>"; |
} |
} |
$show .= "</ul>"; |
return $show; |