source: temp/trunk/html/admin/order/status.php @ 6379

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

//¥¹¥Æ¡¼¥¿¥¹´ÉÍý-°ì³ç°ÜÆ°µ¡Ç½

class LC_Page {
    function LC_Page() {
        $this->tpl_mainpage = 'order/status.tpl';
        $this->tpl_subnavi = 'order/subnavi.tpl';
        $this->tpl_mainno = 'order';
        $this->tpl_subno = 'status';
        global $arrORDERSTATUS;
        global $arrORDERSTATUS_COLOR;
        $this->arrORDERSTATUS = $arrORDERSTATUS;
        $this->arrORDERSTATUS_COLOR = $arrORDERSTATUS_COLOR;
        
    }
}

$objPage = new LC_Page();
$objView = new SC_AdminView();
$objSess = new SC_Session();
$objQuery = new SC_Query();

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

//¥¹¥Æ¡¼¥¿¥¹¾ðÊó¡Ê²¾Äê¡Ë
$objPage->SelectedStatus = $_POST['status'];
$objPage->arrForm = $_POST;
                    
//»ÙʧÊýË¡¤Î¼èÆÀ
$objPage->arrPayment = sfGetIDValueList("dtb_payment", "payment_id", "payment_method");

switch ($_POST['mode']){
    
    case 'search':
        switch($_POST['change_status']){
                
                default:
                break;
            
                //¿·µ¬¼õÉÕ
                case '1':
                    lfStatusMove(1,$_POST['move']);
                break;
                
                //Æþ¶âÂÔ¤Á
                case '2':
                    lfStatusMove(2,$_POST['move']);
                break;
                
                //¥­¥ã¥ó¥»¥ë
                case '3':
                    lfStatusMove(3,$_POST['move']);
                break;
                
                //¼è¤ê´ó¤»Ãæ
                case '4':
                    lfStatusMove(4,$_POST['move']);
                break;
                
                //ȯÁ÷ºÑ¤ß
                case '5':
                    lfStatusMove(5,$_POST['move']);
                break;
                
                //ºï½ü
                case 'delete':
                    lfStatusMove("delete",$_POST['move']);
                break;
            }
    
    //¸¡º÷·ë²Ì¤Îɽ¼¨
    lfStatusDisp($_POST['status'],$_POST['search_pageno']);
    break;
    
    default:
    //¥Ç¥Õ¥©¥ë¥È¤Ç¿·µ¬¼õÉÕ°ìÍ÷ɽ¼¨
    lfStatusDisp(1,$_POST['search_pageno']);
    $objPage->defaultstatus = 1;
    break;
    }

$objView->assignobj($objPage);
$objView->display(MAIN_FRAME);

//-----------------------------------------------------------------------------------------------------------------------------------

//¥¹¥Æ¡¼¥¿¥¹°ìÍ÷¤Îɽ¼¨
function lfStatusDisp($status,$pageno){
    global $objPage;
    global $objQuery;
    
    $select ="*";
    $from = "dtb_order";
    $where="del_flg=0 AND status=?";
    $order = "order_id DESC";
    
    $linemax = $objQuery->count("dtb_order", "del_flg = 0 AND status=?", array($status));
    $objPage->tpl_linemax = $linemax;
    
    // ¥Ú¡¼¥¸Á÷¤ê¤Î½èÍý
    $page_max = ORDER_STATUS_MAX;
    
    // ¥Ú¡¼¥¸Á÷¤ê¤Î¼èÆÀ
    $objNavi = new SC_PageNavi($pageno, $linemax, $page_max, "fnNaviSearchOnlyPage", NAVI_PMAX);
    $objPage->tpl_strnavi = $objNavi->strnavi;      // ɽ¼¨Ê¸»úÎó
    $startno = $objNavi->start_row;
    
    $objPage->tpl_pageno = $pageno;
    
    // ¼èÆÀÈϰϤλØÄê(³«»Ï¹ÔÈֹ桢¹Ô¿ô¤Î¥»¥Ã¥È)
    $objQuery->setlimitoffset($page_max, $startno);
    
    //ɽ¼¨½ç½ø
    $objQuery->setorder($order);
    
    //¸¡º÷·ë²Ì¤Î¼èÆÀ
    $objPage->arrStatus = $objQuery->select($select, $from, $where, array($status));
    
    return $objPage;
}

//¥¹¥Æ¡¼¥¿¥¹¾ðÊó¤Î¹¹¿·¡Ê°ÜÆ°¡Ë
function lfStatusMove($status_id,$move){
    global $objQuery;
    global $objPage;
    
    if ($status_id == 'delete'){
        $sql="UPDATE dtb_order SET del_flg=1";
    }elseif ($status_id == 5){
        $sql="UPDATE dtb_order SET status=".$status_id.",commit_date=now() ";
    }else{
        $sql="UPDATE dtb_order SET status=".$status_id." ";
    }
        $sql.="WHERE order_id=?";
        if (isset($move)){
            foreach ($move as $val){
            if ($val != "") {
                $objQuery->exec($sql, array($val));
            }
            $objPage->tpl_onload = "window.alert('ÁªÂò¹àÌܤò°ÜÆ°¤·¤Þ¤·¤¿¡£');";
            }
        }
}

?>