source: branches/dev/html/admin/mail/history.php @ 17

<?php
/*
 * Copyright(c) 2000-2007 LOCKON CO.,LTD. All Rights Reserved.
 *
 * http://www.lockon.co.jp/
 */
require_once("../require.php");

class LC_Page {
    var $arrSession;
    function LC_Page() {
        $this->tpl_mainpage = 'mail/history.tpl';
        $this->tpl_mainno = 'mail';
        $this->tpl_subnavi = 'mail/subnavi.tpl';
        $this->tpl_subno = "history";
        $this->tpl_subtitle = 'ÇÛ¿®ÍúÎò';
    }
}

//---- ¥Ú¡¼¥¸½é´üÀßÄê
$conn = new SC_DBConn();
$objPage = new LC_Page();
$objView = new SC_AdminView();
$objSess = new SC_Session();
$objDate = new SC_Date();

// ǧ¾Ú²ÄÈݤÎȽÄê
sfIsSuccess($objSess);

// ºï½ü»þ
if ( sfCheckNumLength($_GET['send_id']) && ($_GET['mode']=='delete') ){
    
    $sql = "UPDATE dtb_send_history SET del_flg = 1 WHERE send_id = ?";
    $conn->query($sql, array($_GET['send_id']) );
    sfReload();

}   
    $col = "*";
    $from = "dtb_send_history";
    
    $where .= " del_flg = ?";
    $arrval[] = "0";
    
    $objQuery = new SC_Query();
    // ¹Ô¿ô¤Î¼èÆÀ
    $linemax = $objQuery->count($from, $where, $arrval);
    $objPage->tpl_linemax = $linemax;               // ²¿·ï¤¬³ºÅö¤·¤Þ¤·¤¿¡£É½¼¨ÍÑ
    
    // ¥Ú¡¼¥¸Á÷¤ê¤Î¼èÆÀ
    $objNavi = new SC_PageNavi($_POST['search_pageno'], $linemax, SEARCH_PMAX, "fnNaviSearchPage", NAVI_PMAX);
    $objPage->tpl_strnavi = $objNavi->strnavi;      // ɽ¼¨Ê¸»úÎó
    $startno = $objNavi->start_row;
    
    // ¼èÆÀÈϰϤλØÄê(³«»Ï¹ÔÈֹ桢¹Ô¿ô¤Î¥»¥Ã¥È)
    $objQuery->setlimitoffset(SEARCH_PMAX, $startno);
    
    // ɽ¼¨½ç½ø
    $order = "start_date DESC, send_id DESC";
    $objQuery->setorder($order);
    
    // ¸¡º÷·ë²Ì¤Î¼èÆÀ
    $objPage->arrDataList = $objQuery->select($col, $from, $where, $arrval);
    
//----¡¡¥Ú¡¼¥¸É½¼¨
$objView->assignobj($objPage);
$objView->display(MAIN_FRAME);