PHP SmartyPaginate::setTotal方法代码示例

function get_db_results()
{
    // normally you would have an SQL query here,
    // for this example we fabricate a 100 item array
    // (emulating a table with 100 records)
    // and slice out our pagination range
    // (emulating a LIMIT X,Y MySQL clause)
    $_data = range(1, 100);
    SmartyPaginate::setTotal(count($_data));
    return array_slice($_data, SmartyPaginate::getCurrentIndex(), SmartyPaginate::getLimit());
}

function getSearchResults(&$dbcon, $searchSpec)
{
    $X = SmartyPaginate::getCurrentIndex();
    $Y = SmartyPaginate::getLimit();
    $searchSQL = "SELECT * FROM sionapros_news WHERE 1 {$searchSpec} ORDER BY pub_date DESC LIMIT {$X},{$Y}";
    $result = $dbcon->execute($searchSQL);
    foreach ($result as $row) {
        $data[] = $row;
    }
    // now we get the total number of records from the table
    $rowsSQL = "SELECT COUNT(*) FROM sionapros_news WHERE 1 {$searchSpec}";
    $dbcon->query($rowsSQL);
    SmartyPaginate::setTotal($dbcon->getValue());
    return $data;
}

 function viewlist($parameter = null, $layout = true, $model = false)
 {
     $options = array();
     $assigns = array();
     $model = $model ? $model : $this->getDefaultModel();
     $this->page_title = Inflector::humanize($this->name);
     $this->auto_render = false;
     $this->base_dir = APP_DIR;
     $assigns['TITLE'] = Inflector::humanize($this->name);
     if ($model) {
         $this->get_search_field($model, $options);
         $this->get_viewlist_options($model, $options);
         $this->get_sort_options($model, $options);
         $this->set_pagination($model);
         $model->find($options);
         $page_content =& NController::singleton('page_content');
         $page_content_model =& $page_content->getDefaultModel();
         $pk = $model->primaryKey();
         $models = array();
         $headline = $model->getHeadline() ? $model->getHeadline() : 'cms_headline';
         $i = 0;
         while ($model->fetch()) {
             $arr = $model->toArray();
             $arr['_headline'] = isset($arr['cms_headline']) && $arr['cms_headline'] ? $arr['cms_headline'] : $model->makeHeadline();
             $arr['_remove_delete'] = $page_content_model->isWorkflowContent($this->name, $arr[$pk]) ? 1 : 0;
             // Remove delete for models that have specified this.
             $arr['_remove_delete'] = isset($model->remove_delete) && $model->remove_delete == true ? 1 : 0;
             $models[] = $arr;
             unset($arr);
         }
         // Override standard paging limit if chosen in the model file.
         $paging = isset($model->paging) ? $model->paging : $this->paging;
         // If paging is not disabled in the model AND the records are > than the paging size AND not searching.
         if ($paging > 0 && count($models) > $paging && !$options['is_search']) {
             SmartyPaginate::connect($this->name);
             SmartyPaginate::setLimit($paging, $this->name);
             SmartyPaginate::setTotal(count($models), $this->name);
             $view =& NView::singleton($this);
             SmartyPaginate::assign($view, 'paginate', $this->name);
             // TODO: Could be more efficient and only get records it needs to.
             $models = array_slice($models, SmartyPaginate::getCurrentIndex($this->name), SmartyPaginate::getLimit($this->name));
             $this->set('paging', true);
         }
         $this->set(array('rows' => $models, 'asset' => $this->name, 'asset_name' => $this->page_title));
         unset($models);
     }
     $this->render(array('layout' => 'default'));
 }

function getSearchResults(&$dbcon)
{
    $X = SmartyPaginate::getCurrentIndex();
    $Y = SmartyPaginate::getLimit();
    $searchSQL = "SELECT * FROM sionapros_news WHERE 1 ORDER BY news_no DESC LIMIT {$X},{$Y}";
    $result = $dbcon->execute($searchSQL);
    foreach ($result as $row) {
        // collect each record into $_data
        $data[] = $row;
    }
    // now we get the total number of records from the table
    $rowsSQL = "SELECT COUNT(*) FROM sionapros_news WHERE 1";
    $dbcon->query($rowsSQL);
    #$rowNo = $rows[0];
    SmartyPaginate::setTotal($dbcon->getValue());
    $dbcon->free();
    return $data;
}

function getSearchResults(&$dbcon, $proj_no)
{
    $X = SmartyPaginate::getCurrentIndex();
    $Y = SmartyPaginate::getLimit();
    $searchSQL = "SELECT p.*,c.value FROM sionapros_pubs AS p INNER JOIN sionapros_categories AS c";
    $searchSQL .= " ON p.category = c.id WHERE 1 {$_SESSION['search']} ORDER BY id DESC LIMIT {$X},{$Y}";
    $result = $dbcon->execute($searchSQL);
    foreach ($result as $row) {
        // collect each record into $_data
        $data[] = $row;
    }
    // now we get the total number of records from the table
    $rowsSQL = "SELECT COUNT(*) FROM sionapros_pubs AS p WHERE 1 {$_SESSION['search']}";
    $dbcon->query($rowsSQL);
    #$rowNo = $rows[0];
    SmartyPaginate::setTotal($dbcon->getValue());
    $dbcon->free();
    return $data;
}

function getSearchResults(&$dbcon)
{
    $X = SmartyPaginate::getCurrentIndex();
    $Y = SmartyPaginate::getLimit();
    $searchSQL = "SELECT firstname,lastname,identifier FROM sionapros_users";
    $searchSQL .= " WHERE 1 {$_SESSION['search']} ORDER BY identifier ASC LIMIT {$X},{$Y}";
    $result = $dbcon->execute($searchSQL);
    foreach ($result as $row) {
        // collect each record into $_data
        $data[] = $row;
    }
    // now we get the total number of records from the table
    $rowsSQL = "SELECT COUNT(*) FROM sionapros_users WHERE 1 {$_SESSION['search']}";
    $dbcon->query($rowsSQL);
    #$rowNo = $rows[0];
    SmartyPaginate::setTotal($dbcon->getValue());
    $dbcon->free();
    return $data;
}

function getSearchResults(&$dbcon)
{
    $X = SmartyPaginate::getCurrentIndex();
    $Y = SmartyPaginate::getLimit();
    $searchSQL = "SELECT fq.*,C.value FROM sionapros_faqs AS fq INNER JOIN sionapros_categories";
    $searchSQL .= " AS C ON fq.category = C.id ORDER BY C.id,fq.id LIMIT {$X},{$Y}";
    $result = $dbcon->execute($searchSQL);
    echo $dbcon->error;
    foreach ($result as $row) {
        // collect each record into $_data
        $data[] = $row;
    }
    // now we get the total number of records from the table
    $rowsSQL = "SELECT COUNT(*) FROM sionapros_faqs WHERE 1";
    $dbcon->query($rowsSQL);
    #$rowNo = $rows[0];
    SmartyPaginate::setTotal($dbcon->getValue());
    $dbcon->free();
    return $data;
}

function getSearchResults(&$dbcon)
{
    #$searchSQL = sprintf("SELECT * FROM ehmis_personnel_main WHERE 1 {$_SESSION['search']} ORDER BY identifier ASC LIMIT %d,%d",
    #    					SmartyPaginate::getCurrentIndex(), SmartyPaginate::getLimit());
    $X = SmartyPaginate::getCurrentIndex();
    $Y = SmartyPaginate::getLimit();
    $searchSQL = "SELECT n.*,c.value FROM sionapros_news AS n INNER JOIN sionapros_categories AS c ON";
    $searchSQL .= " n.category = c.id WHERE 1 {$_SESSION['search']} ORDER BY n.news_no DESC LIMIT {$X},{$Y}";
    $result = $dbcon->execute($searchSQL);
    foreach ($result as $row) {
        // collect each record into $_data
        $data[] = $row;
    }
    // now we get the total number of records from the table
    $rowsSQL = "SELECT COUNT(*) FROM sionapros_news AS n WHERE 1 {$_SESSION['search']}";
    $dbcon->query($rowsSQL);
    #$rowNo = $rows[0];
    SmartyPaginate::setTotal($dbcon->getValue());
    $dbcon->free();
    return $data;
}

 function getProjectLog($project, $lim = 10)
 {
     $project = (int) $project;
     $lim = (int) $lim;
     $sel = mysql_query("SELECT COUNT(*) FROM log WHERE project = {$project} ");
     $num = mysql_fetch_row($sel);
     $num = $num[0];
     if ($num > 200) {
         $num = 200;
     }
     SmartyPaginate::connect();
     // set items per page
     SmartyPaginate::setLimit($lim);
     SmartyPaginate::setTotal($num);
     $start = SmartyPaginate::getCurrentIndex();
     $lim = SmartyPaginate::getLimit();
     $sql = "SELECT * FROM log WHERE project = {$project} ORDER BY ID DESC LIMIT {$start},{$lim}";
     $sel2 = mysql_query($sql);
     $mylog = array();
     while ($log = mysql_fetch_array($sel2)) {
         if (!empty($log)) {
             $sel3 = mysql_query("SELECT name FROM projekte WHERE ID = {$log['project']}");
             $proname = mysql_fetch_array($sel3);
             $proname = $proname[0];
             $log["proname"] = $proname;
             $log["proname"] = stripslashes($log["proname"]);
             $log["username"] = stripslashes($log["username"]);
             $log["name"] = stripslashes($log["name"]);
             array_push($mylog, $log);
         }
     }
     if (!empty($mylog)) {
         return $mylog;
     } else {
         return false;
     }
 }

function getSearchResults(&$dbcon, $searchSpec)
{
    $X = SmartyPaginate::getCurrentIndex();
    $Y = SmartyPaginate::getLimit();
    $searchSQL = "SELECT * FROM sionapros_pubs WHERE 1 {$searchSpec} ORDER BY pub_date DESC LIMIT {$X},{$Y}";
    $result = $dbcon->execute($searchSQL);
    $i = 0;
    foreach ($result as $row) {
        #$path = './admin'.substr($row['doc'], 1, strlen($row['doc']));
        $data[$i] = $row;
        #$data[$i]['path'] = $path;
        $i++;
    }
    // now we get the total number of records from the table
    $rowsSQL = "SELECT COUNT(*) FROM sionapros_pubs WHERE 1 {$searchSpec}";
    $dbcon->query($rowsSQL);
    #$rowNo = $rows[0];
    SmartyPaginate::setTotal($dbcon->getValue());
    return $data;
}

 /**
  * Lists all the users in a project
  *
  * @param int $project Eindeutige Projektnummer
  * @param int $lim Maximum auszugebender Mitglieder
  * @return array $members Projektmitglieder
  */
 function getProjectMembers($project, $lim = 10, $paginate = true)
 {
     global $conn;
     $project = (int) $project;
     $lim = (int) $lim;
     $project = (int) $project;
     $lim = (int) $lim;
     $members = array();
     if ($paginate) {
         $num = $conn->query("SELECT COUNT(*) FROM projekte_assigned WHERE projekt = {$project}")->fetch();
         $num = $num[0];
         $lim = (int) $lim;
         SmartyPaginate::connect();
         // set items per page
         SmartyPaginate::setLimit($lim);
         SmartyPaginate::setTotal($num);
         $start = SmartyPaginate::getCurrentIndex();
         $lim = SmartyPaginate::getLimit();
     } else {
         $start = 0;
     }
     $sel1 = $conn->query("SELECT user FROM projekte_assigned WHERE projekt = {$project} LIMIT {$start},{$lim}");
     $usr = new user();
     while ($user = $sel1->fetch()) {
         $theuser = $usr->getProfile($user[0]);
         array_push($members, $theuser);
     }
     if (!empty($members)) {
         return $members;
     } else {
         return false;
     }
 }

         }
         if (strlen($filter_ip)) {
             $filter .= '&filter_ip=' . htmlspecialchars($filter_ip, ENT_QUOTES, 'cp1251');
         }
         if (strlen($filter_hwid)) {
             $filter .= '&filter_hwid=' . htmlspecialchars($filter_hwid, ENT_QUOTES, 'cp1251');
         }
         if (strlen($filter_nonparsed)) {
             $filter .= '&filter_nonparsed=' . htmlspecialchars($filter_nonparsed, ENT_QUOTES, 'cp1251');
         } elseif (strlen($filter_has_passwords)) {
             $filter .= '&filter_has_passwords=' . htmlspecialchars($filter_has_passwords, ENT_QUOTES, 'cp1251');
         }
         SmartyPaginate::disconnect();
         SmartyPaginate::connect();
         SmartyPaginate::setURL($self_file . "?token=" . $token . "&action=reports" . $filter);
         SmartyPaginate::setTotal($total_items_count);
         SmartyPaginate::setLimit($max_results);
         SmartyPaginate::setPageLimit(50);
         SmartyPaginate::setPrevText($lang['Previous']);
         SmartyPaginate::setNextText($lang['Next']);
         SmartyPaginate::assign($smarty);
         smarty_assign_common_vars($smarty, $pony_db);
         $smarty->assign("report_list", $report_list);
         $smarty->display('report_list.tpl');
     }
 } else {
     if ($admin_action == 'admin') {
         // ---------------------------------------------------------------------------------------
         // User management
         if ($admin_routine == 'rebuild_tables') {
             if ($pony_db->priv_is_admin()) {

 function getProjectLog($project, $lim = 25)
 {
     global $conn;
     $project = (int) $project;
     $lim = (int) $lim;
     $sel = $conn->prepare("SELECT COUNT(*) FROM log WHERE project = ? ");
     $sel->execute(array($project));
     $num = $sel->fetch();
     $num = $num[0];
     if ($num > 200) {
         $num = 200;
     }
     SmartyPaginate::connect();
     // set items per page
     SmartyPaginate::setLimit($lim);
     SmartyPaginate::setTotal($num);
     $start = SmartyPaginate::getCurrentIndex();
     $lim = SmartyPaginate::getLimit();
     $sql = "SELECT * FROM log WHERE project = ? ORDER BY ID DESC LIMIT {$start},{$lim}";
     $sel2 = $conn->prepare($sql);
     $sel2->execute(array($project));
     $mylog = array();
     while ($log = $sel2->fetch()) {
         if (!empty($log)) {
             $sel3 = $conn->query("SELECT name FROM projekte WHERE ID = {$log['project']}");
             $proname = $sel3->fetch();
             $proname = $proname[0];
             $log["proname"] = $proname;
             //$log["proname"] = stripslashes($log["proname"]);
             //$log["username"] = stripslashes($log["username"]);
             $log["name"] = stripslashes($log["name"]);
             array_push($mylog, $log);
         }
     }
     if (!empty($mylog)) {
         return $mylog;
     } else {
         return false;
     }
 }

 /**
  * List all files associated to a given project
  *
  * @param string $id Project ID
  * @param int $lim Limit
  * @param int $folder Folder
  * @return array $files Found files
  */
 function getProjectFiles($id, $lim = 25, $folder = "")
 {
     $id = (int) $id;
     $lim = (int) $lim;
     $folder = (int) $folder;
     if ($folder > 0) {
         $fold = "files/" . CL_CONFIG . "/{$id}/{$folder}/";
         $sel = mysql_query("SELECT COUNT(*) FROM files WHERE project = {$id} AND folder = {$folder} ORDER BY ID DESC");
     } else {
         $sel = mysql_query("SELECT COUNT(*) FROM files WHERE project = {$id} AND folder = 0 ORDER BY ID DESC");
     }
     $num = mysql_fetch_row($sel);
     $num = $num[0];
     SmartyPaginate::connect();
     // set items per page
     SmartyPaginate::setLimit($lim);
     SmartyPaginate::setTotal($num);
     $start = SmartyPaginate::getCurrentIndex();
     $lim = SmartyPaginate::getLimit();
     $files = array();
     if ($folder > 0) {
         $sql = "SELECT ID FROM files WHERE project = {$id} AND folder = {$folder} ORDER BY  ID DESC LIMIT {$start},{$lim}";
         $sel2 = mysql_query($sql);
     } else {
         $sel2 = mysql_query("SELECT ID FROM files WHERE project = {$id} AND folder = 0 ORDER BY  ID DESC LIMIT {$start},{$lim}");
     }
     while ($file = mysql_fetch_array($sel2)) {
         if (!empty($file)) {
             array_push($files, $this->getFile($file["ID"]));
         }
     }
     if (!empty($files)) {
         return $files;
     } else {
         return false;
     }
 }

 /**
  * Returns all users
  *
  * @param int $lim Limit
  * @return array $users Registrierte Mitglieder
  */
 function getAllUsers($lim = 10)
 {
     global $conn;
     $lim = (int) $lim;
     $num = $conn->query("SELECT COUNT(*) FROM `user`")->fetch();
     $num = $num[0];
     SmartyPaginate::connect();
     // set items per page
     SmartyPaginate::setLimit($lim);
     SmartyPaginate::setTotal($num);
     $start = SmartyPaginate::getCurrentIndex();
     $lim = SmartyPaginate::getLimit();
     $sel2 = $conn->query("SELECT ID FROM `user` ORDER BY ID DESC LIMIT {$start},{$lim}");
     $users = array();
     while ($user = $sel2->fetch()) {
         array_push($users, $this->getProfile($user["ID"]));
     }
     if (!empty($users)) {
         return $users;
     } else {
         return false;
     }
 }