| 1 | <?php |
|---|
| 2 | /* |
|---|
| 3 | * Copyright(c) 2000-2007 LOCKON CO.,LTD. All Rights Reserved. |
|---|
| 4 | * |
|---|
| 5 | * http://www.lockon.co.jp/ |
|---|
| 6 | */ |
|---|
| 7 | require_once("../require.php"); |
|---|
| 8 | |
|---|
| 9 | class 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 | // ǧ¾Ú²ÄÈݤÎȽÄê |
|---|
| 31 | sfIsSuccess($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 | ?> |
|---|
