source: branches/dev/html/admin/system/index.php @ 17

Revision 17, 1.9 KB checked in by uehara, 17 years ago (diff)
Line 
1<?php
2/*
3 * Copyright(c) 2000-2007 LOCKON CO.,LTD. All Rights Reserved.
4 *
5 * http://www.lockon.co.jp/
6 */
7require_once("../require.php");
8
9class LC_Page {
10    var $tpl_category;  // ʬÎà(HOME:1,¿ÍʪÅÐÏ¿:2,¿Íʪ¸¡º÷:3,¥·¥¹¥Æ¥à:4,¥í¥°¥¢¥¦¥È:5)
11    var $list_data;     // ¥Æ¡¼¥Ö¥ë¥Ç¡¼¥¿¼èÆÀÍÑ
12    var $arrAUTHORITY;
13    var $tpl_onload;
14    var $tpl_disppage;  // ɽ¼¨Ãæ¤Î¥Ú¡¼¥¸ÈÖ¹æ
15    var $tpl_strnavi;
16    function LC_Page() {
17        $this->tpl_mainpage = 'system/index.tpl';
18        $this->tpl_subnavi = 'system/subnavi.tpl';
19        $this->tpl_mainno = 'system';
20        $this->tpl_subno = 'index';
21        $this->tpl_onload = 'fnGetRadioChecked();';
22        $this->tpl_subtitle = '¥á¥ó¥Ð¡¼´ÉÍý';
23        global $arrAUTHORITY;
24        $this->arrAUTHORITY = $arrAUTHORITY;
25    }
26}
27
28// ¥»¥Ã¥·¥ç¥ó¥¯¥é¥¹
29$objSess = new SC_Session();
30// ǧ¾Ú²ÄÈݤÎȽÄê
31sfIsSuccess($objSess);
32
33$conn = new SC_DbConn();
34
35// ¥Æ¥ó¥×¥ì¡¼¥ÈÊÑ¿ô¤ÎÊÝ»ý¥¯¥é¥¹
36$objPage = new LC_Page();
37// SQLºîÀ®ÍÑ¥ª¥Ö¥¸¥§¥¯¥ÈÀ¸À®
38$objSql = new SC_SelectSql();
39$objSql->setSelect("SELECT member_id,name,department,login_id,authority,rank,work FROM dtb_member");
40$objSql->setOrder("rank DESC");
41$objSql->setWhere("del_flg <> 1 AND member_id <> ". ADMIN_ID);
42
43//´Ê°×¥¯¥¨¥ê¼Â¹Ô¥ª¥Ö¥¸¥§¥¯¥È
44$oquery = new SC_Query();
45// ¹Ô¿ô¤Î¼èÆÀ
46$linemax = $oquery->count("dtb_member", "del_flg <> 1 AND member_id <>".ADMIN_ID);
47
48// ²ÔÆ°Ãæ¤Î·ï¿ô¤ò¼èÆÀ
49$workmax = $oquery->count("dtb_member", "work = 1 AND del_flg <> 1 AND member_id <>".ADMIN_ID);
50$objPage->workmax= $workmax;
51
52// ¥Ú¡¼¥¸Á÷¤ê¤Î½èÍý
53$objNavi = new SC_PageNavi($_GET['pageno'], $linemax, MEMBER_PMAX, "fnMemberPage", NAVI_PMAX);
54$objPage->tpl_strnavi = $objNavi->strnavi;
55$objPage->tpl_disppage = $objNavi->now_page;
56$objPage->tpl_pagemax = $objNavi->max_page;
57$startno = $objNavi->start_row;
58
59// ¼èÆÀÈϰϤλØÄê(³«»Ï¹ÔÈֹ桢¹Ô¿ô¤Î¥»¥Ã¥È)
60$objSql->setLimitOffset(MEMBER_PMAX, $startno);
61$objPage->list_data = $conn->getAll($objSql->getSql());
62
63// ¥Ú¡¼¥¸¤Îɽ¼¨
64$objView = new SC_AdminView();
65$objView->assignobj($objPage);
66$objView->display(MAIN_FRAME);
67
68?>
Note: See TracBrowser for help on using the repository browser.