PHP SC_Helper_DB_Ex::sfGetIDValueList方法代码示例

 /**
  * Page を初期化する.
  *
  * @return void
  */
 function init()
 {
     parent::init();
     $this->tpl_mainpage = 'order/index.tpl';
     $this->tpl_mainno = 'order';
     $this->tpl_subno = 'index';
     $this->tpl_pager = 'pager.tpl';
     $this->tpl_maintitle = t('c_Orders_01');
     $this->tpl_subtitle = t('c_Order master_01');
     $masterData = new SC_DB_MasterData_Ex();
     $this->arrORDERSTATUS = $masterData->getMasterData('mtb_order_status');
     $this->arrORDERSTATUS_COLOR = $masterData->getMasterData('mtb_order_status_color');
     $this->arrSex = $masterData->getMasterData('mtb_sex');
     $this->arrPageMax = $masterData->getMasterData('mtb_page_max');
     $objDate = new SC_Date_Ex();
     // 登録・更新日検索用
     $objDate->setStartYear(RELEASE_YEAR);
     $objDate->setEndYear(DATE('Y'));
     $this->arrRegistYear = $objDate->getYear();
     // 生年月日検索用
     $objDate->setStartYear(BIRTH_YEAR);
     $objDate->setEndYear(DATE('Y'));
     $this->arrBirthYear = $objDate->getYear();
     // 月日の設定
     $this->arrMonth = $objDate->getMonth();
     $this->arrDay = $objDate->getDay();
     // 支払い方法の取得
     $this->arrPayments = SC_Helper_DB_Ex::sfGetIDValueList('dtb_payment', 'payment_id', 'payment_method');
     $this->httpCacheControl('nocache');
 }

 /**
  * Page のAction.
  *
  * @return void
  */
 function action()
 {
     $objCustomer = new SC_Customer_Ex();
     $objDb = new SC_Helper_DB_Ex();
     $objPurchase = new SC_Helper_Purchase_Ex();
     if (!SC_Utils_Ex::sfIsInt($_GET['order_id'])) {
         SC_Utils_Ex::sfDispSiteError(CUSTOMER_ERROR);
     }
     $order_id = $_GET['order_id'];
     //受注データの取得
     $this->tpl_arrOrderData = $objPurchase->getOrder($order_id, $objCustomer->getValue('customer_id'));
     if (empty($this->tpl_arrOrderData)) {
         SC_Utils_Ex::sfDispSiteError(CUSTOMER_ERROR);
     }
     $this->arrShipping = $this->lfGetShippingDate($objPurchase, $order_id, $this->arrWDAY);
     $this->isMultiple = count($this->arrShipping) > 1;
     // 支払い方法の取得
     $this->arrPayment = $objDb->sfGetIDValueList('dtb_payment', 'payment_id', 'payment_method');
     // 受注商品明細の取得
     $this->tpl_arrOrderDetail = $objPurchase->getOrderDetail($order_id);
     $this->tpl_arrOrderDetail = $this->setMainListImage($this->tpl_arrOrderDetail);
     $objPurchase->setDownloadableFlgTo($this->tpl_arrOrderDetail);
     // モバイルダウンロード対応処理
     $this->lfSetAU($this->tpl_arrOrderDetail);
     // 受注メール送信履歴の取得
     $this->tpl_arrMailHistory = $this->lfGetMailHistory($order_id);
 }

 /**
  * Page を初期化する.
  *
  * @return void
  */
 function init()
 {
     parent::init();
     $this->tpl_mainpage = 'customer/edit.tpl';
     $this->tpl_mainno = 'customer';
     $this->tpl_subno = 'index';
     $this->tpl_pager = 'pager.tpl';
     $this->tpl_maintitle = '会員管理';
     $this->tpl_subtitle = '会員登録';
     $masterData = new SC_DB_MasterData_Ex();
     $this->arrPref = $masterData->getMasterData('mtb_pref');
     $this->arrJob = $masterData->getMasterData('mtb_job');
     $this->arrSex = $masterData->getMasterData('mtb_sex');
     $this->arrReminder = $masterData->getMasterData('mtb_reminder');
     $this->arrStatus = $masterData->getMasterData('mtb_customer_status');
     $this->arrMailMagazineType = $masterData->getMasterData('mtb_mail_magazine_type');
     // 日付プルダウン設定
     $objDate = new SC_Date_Ex(BIRTH_YEAR);
     $this->arrYear = $objDate->getYear();
     $this->arrMonth = $objDate->getMonth();
     $this->arrDay = $objDate->getDay();
     // 支払い方法種別
     $objDb = new SC_Helper_DB_Ex();
     $this->arrPayment = $objDb->sfGetIDValueList('dtb_payment', 'payment_id', 'payment_method');
 }

 /**
  * Page のプロセス.
  *
  * @return void
  */
 function process()
 {
     $conn = new SC_DBConn();
     $objView = new SC_AdminView();
     $objSess = new SC_Session();
     $objDb = new SC_Helper_DB_Ex();
     // 認証可否の判定
     SC_Utils_Ex::sfIsSuccess($objSess);
     if (!isset($_POST['mode'])) {
         $_POST['mode'] = "";
     }
     switch ($_POST['mode']) {
         case 'delete':
             // ランク付きレコードの削除
             $objDb->sfDeleteRankRecord("dtb_payment", "payment_id", $_POST['payment_id']);
             // 再表示
             $this->reload();
             break;
         case 'up':
             $objDb->sfRankUp("dtb_payment", "payment_id", $_POST['payment_id']);
             // 再表示
             $this->reload();
             break;
         case 'down':
             $objDb->sfRankDown("dtb_payment", "payment_id", $_POST['payment_id']);
             // 再表示
             $this->reload();
             break;
     }
     $this->arrDelivList = $objDb->sfGetIDValueList("dtb_deliv", "deliv_id", "service_name");
     $this->arrPaymentListFree = $this->lfGetPaymentList(2);
     $objView->assignobj($this);
     $objView->display(MAIN_FRAME);
 }

 /**
  * Page を初期化する.
  *
  * @return void
  */
 function init()
 {
     parent::init();
     $this->tpl_title = 'ご入力内容のご確認';
     $masterData = new SC_DB_MasterData_Ex();
     $this->arrPref = $masterData->getMasterData('mtb_pref');
     $this->arrSex = $masterData->getMasterData('mtb_sex');
     $this->arrMAILMAGATYPE = $masterData->getMasterData('mtb_mail_magazine_type');
     $this->arrReminder = $masterData->getMasterData('mtb_reminder');
     $this->arrDeliv = SC_Helper_DB_Ex::sfGetIDValueList('dtb_deliv', 'deliv_id', 'service_name');
     $this->httpCacheControl('nocache');
 }

 /**
  * Page を初期化する.
  *
  * @return void
  */
 function init()
 {
     parent::init();
     $this->tpl_mainpage = 'basis/delivery_input.tpl';
     $this->tpl_subno = 'delivery';
     $this->tpl_mainno = 'basis';
     $masterData = new SC_DB_MasterData_Ex();
     $this->arrPref = $masterData->getMasterData('mtb_pref');
     $this->arrProductType = $masterData->getMasterData('mtb_product_type');
     $this->arrPayments = SC_Helper_DB_Ex::sfGetIDValueList('dtb_payment', 'payment_id', 'payment_method');
     $this->tpl_maintitle = '基本情報管理';
     $this->tpl_subtitle = '配送方法設定';
     $this->mode = $this->getMode();
 }

 /**
  * Page のアクション.
  *
  * @return void
  */
 function action()
 {
     $objDb = new SC_Helper_DB_Ex();
     // パラメーター管理クラス
     $objFormParam = new SC_FormParam_Ex();
     // パラメーター情報の初期化
     $this->lfInitParam($objFormParam);
     $objFormParam->setParam($_POST);
     // 入力値の変換
     $objFormParam->convParam();
     $this->arrForm = $objFormParam->getHashArray();
     //        $this->arrForm = $_POST;
     //支払方法の取得
     $this->arrPayment = $objDb->sfGetIDValueList("dtb_payment", "payment_id", "payment_method");
     switch ($this->getMode()) {
         case 'update':
             switch ($objFormParam->getValue('change_status')) {
                 case '':
                     break;
                     // 削除
                 // 削除
                 case 'delete':
                     $this->lfDelete($objFormParam->getValue('move'));
                     break;
                     // 更新
                 // 更新
                 default:
                     $this->lfStatusMove($objFormParam->getValue('change_status'), $objFormParam->getValue('move'));
                     break;
             }
             // 対応状況
             $status = !is_null($objFormParam->getValue('status')) ? $objFormParam->getValue('status') : "";
             break;
         case 'search':
             // 対応状況
             $status = !is_null($_POST['status']) ? $objFormParam->getValue('status') : "";
             break;
         default:
             // 対応状況
             //デフォルトで新規受付一覧表示
             $status = ORDER_NEW;
             break;
     }
     // 対応状況
     $this->SelectedStatus = $status;
     //検索結果の表示
     $this->lfStatusDisp($status, $objFormParam->getValue('search_pageno'));
 }

 /**
  * Page のプロセス.
  *
  * @return void
  */
 function process()
 {
     $objView = new SC_AdminView();
     $objSess = new SC_Session();
     $objDb = new SC_Helper_DB_Ex();
     $objQuery = new SC_Query();
     // 認証可否の判定
     $objSess = new SC_Session();
     SC_Utils_Ex::sfIsSuccess($objSess);
     $this->arrForm = $_POST;
     //支払方法の取得
     $this->arrPayment = $objDb->sfGetIDValueList("dtb_payment", "payment_id", "payment_method");
     if (!isset($_POST['mode'])) {
         $_POST['mode'] = "";
     }
     if (!isset($_POST['search_pageno'])) {
         $_POST['search_pageno'] = 1;
     }
     switch ($_POST['mode']) {
         case 'update':
             if (!isset($_POST['change_status'])) {
                 $_POST['change_status'] = "";
             }
             if ($_POST['change_status'] == 'delete') {
                 $this->lfStatusMove("delete", $_POST['move']);
             } elseif (!empty($_POST['change_status'])) {
                 $this->lfStatusMove($_POST['change_status'], $_POST['move']);
             }
             //ステータス情報
             $status = isset($_POST['status']) ? $_POST['status'] : "";
             break;
         case 'search':
             //ステータス情報
             $status = isset($_POST['status']) ? $_POST['status'] : "";
             break;
         default:
             //ステータス情報
             //デフォルトで新規受付一覧表示
             $status = ORDER_NEW;
             break;
     }
     //ステータス情報
     $this->SelectedStatus = $status;
     //検索結果の表示
     $this->lfStatusDisp($status, $_POST['search_pageno']);
     $objView->assignobj($this);
     $objView->display(MAIN_FRAME);
 }

 /**
  * Page を初期化する.
  *
  * @return void
  */
 function init()
 {
     parent::init();
     $this->tpl_mainpage = 'products/product.tpl';
     $this->tpl_mainno = 'products';
     $this->tpl_subno = 'product';
     $this->tpl_maintitle = t('c_Products_01');
     $this->tpl_subtitle = t('c_Product registration_01');
     $masterData = new SC_DB_MasterData_Ex();
     $this->arrProductType = $masterData->getMasterData('mtb_product_type');
     $this->arrDISP = $masterData->getMasterData('mtb_disp');
     $this->arrSTATUS = $masterData->getMasterData('mtb_status');
     $this->arrSTATUS_IMAGE = $masterData->getMasterData('mtb_status_image');
     $this->arrDELIVERYDATE = $masterData->getMasterData('mtb_delivery_date');
     $this->arrMaker = SC_Helper_DB_Ex::sfGetIDValueList('dtb_maker', 'maker_id', 'name');
     $this->arrAllowedTag = $masterData->getMasterData('mtb_allowed_tag');
 }

 /**
  * Page を初期化する.
  *
  * @return void
  */
 function init()
 {
     parent::init();
     $this->tpl_mainpage = 'order/disp.tpl';
     $this->tpl_mainno = 'order';
     $this->tpl_subnavi = '';
     $this->tpl_subno = '';
     $this->tpl_subtitle = t('c_Order receipt information display_01');
     $masterData = new SC_DB_MasterData_Ex();
     $this->arrPref = $masterData->getMasterData('mtb_pref');
     $this->arrORDERSTATUS = $masterData->getMasterData('mtb_order_status');
     $this->arrDeviceType = $masterData->getMasterData('mtb_device_type');
     // 支払い方法の取得
     $this->arrPayment = SC_Helper_DB_Ex::sfGetIDValueList('dtb_payment', 'payment_id', 'payment_method');
     // 配送業者の取得
     $this->arrDeliv = SC_Helper_DB_Ex::sfGetIDValueList('dtb_deliv', 'deliv_id', 'name');
 }

 /**
  * Page を初期化する.
  *
  * @return void
  */
 function init()
 {
     parent::init();
     $this->tpl_mainpage = 'order/disp.tpl';
     $this->tpl_mainno = 'order';
     $this->tpl_subnavi = '';
     $this->tpl_subno = '';
     $this->tpl_subtitle = '受注情報表示';
     $masterData = new SC_DB_MasterData_Ex();
     $this->arrPref = $masterData->getMasterData('mtb_pref');
     $this->arrORDERSTATUS = $masterData->getMasterData("mtb_order_status");
     $this->arrDeviceType = $masterData->getMasterData('mtb_device_type');
     // 支払い方法の取得
     $this->arrPayment = SC_Helper_DB_Ex::sfGetIDValueList("dtb_payment", "payment_id", "payment_method");
     // 配送業者の取得
     $this->arrDeliv = SC_Helper_DB_Ex::sfGetIDValueList("dtb_deliv", "deliv_id", 'name');
 }

 /**
  * Page を初期化する.
  *
  * @return void
  */
 function init()
 {
     parent::init();
     $this->tpl_mainpage = 'products/product.tpl';
     $this->tpl_mainno = 'products';
     $this->tpl_subno = 'product';
     $this->tpl_maintitle = '商品管理';
     $this->tpl_subtitle = '商品登録';
     $masterData = new SC_DB_MasterData_Ex();
     $this->arrProductType = $masterData->getMasterData("mtb_product_type");
     $this->arrDISP = $masterData->getMasterData("mtb_disp");
     $this->arrCLASS = $masterData->getMasterData("mtb_class");
     $this->arrSTATUS = $masterData->getMasterData("mtb_status");
     $this->arrSTATUS_IMAGE = $masterData->getMasterData("mtb_status_image");
     $this->arrDELIVERYDATE = $masterData->getMasterData("mtb_delivery_date");
     $this->arrMaker = SC_Helper_DB_Ex::sfGetIDValueList("dtb_maker", "maker_id", 'name');
     $this->arrAllowedTag = $masterData->getMasterData("mtb_allowed_tag");
 }

 /**
  * Page を初期化する.
  *
  * @return void
  */
 function init()
 {
     parent::init();
     $this->tpl_mainpage = 'products/upload_csv.tpl';
     $this->tpl_mainno = 'products';
     $this->tpl_subno = 'upload_csv';
     $this->tpl_maintitle = '商品管理';
     $this->tpl_subtitle = '商品登録CSV';
     $this->csv_id = '1';
     $masterData = new SC_DB_MasterData_Ex();
     $this->arrDISP = $masterData->getMasterData('mtb_disp');
     $this->arrSTATUS = $masterData->getMasterData('mtb_status');
     $this->arrDELIVERYDATE = $masterData->getMasterData('mtb_delivery_date');
     $this->arrProductType = $masterData->getMasterData('mtb_product_type');
     $this->arrMaker = SC_Helper_DB_Ex::sfGetIDValueList('dtb_maker', 'maker_id', 'name');
     $this->arrPayments = SC_Helper_DB_Ex::sfGetIDValueList('dtb_payment', 'payment_id', 'payment_method');
     $this->arrInfo = SC_Helper_DB_Ex::sfGetBasisData();
     $this->arrAllowedTag = $masterData->getMasterData('mtb_allowed_tag');
     $this->arrTagCheckItem = array();
 }

 /**
  * Page のAction.
  *
  * @return void
  */
 function action()
 {
     $objCustomer = new SC_Customer_Ex();
     $customer_id = $objCustomer->getvalue('customer_id');
     //ページ送り用
     $this->objNavi = new SC_PageNavi_Ex($_REQUEST['pageno'], $this->lfGetOrderHistory($customer_id), SEARCH_PMAX, 'fnNaviPage', NAVI_PMAX, 'pageno=#page#', SC_Display_Ex::detectDevice() !== DEVICE_TYPE_MOBILE);
     $this->arrOrder = $this->lfGetOrderHistory($customer_id, $this->objNavi->start_row);
     switch ($this->getMode()) {
         case "getList":
             echo SC_Utils_Ex::jsonEncode($this->arrOrder);
             exit;
             break;
         default:
             break;
     }
     // 支払い方法の取得
     $this->arrPayment = SC_Helper_DB_Ex::sfGetIDValueList("dtb_payment", "payment_id", "payment_method");
     // 1ページあたりの件数
     $this->dispNumber = SEARCH_PMAX;
 }

 /**
  * Page を初期化する.
  *
  * @return void
  */
 function init()
 {
     parent::init();
     $this->tpl_mainpage = 'order/edit.tpl';
     $this->tpl_mainno = 'order';
     $this->tpl_maintitle = '受注管理';
     $this->tpl_subtitle = '受注登録';
     $masterData = new SC_DB_MasterData_Ex();
     $this->arrPref = $masterData->getMasterData('mtb_pref');
     $this->arrORDERSTATUS = $masterData->getMasterData('mtb_order_status');
     $this->arrDeviceType = $masterData->getMasterData('mtb_device_type');
     $objDate = new SC_Date_Ex(RELEASE_YEAR);
     $this->arrYearShippingDate = $objDate->getYear('', date('Y'), '');
     $this->arrMonthShippingDate = $objDate->getMonth(true);
     $this->arrDayShippingDate = $objDate->getDay(true);
     // 支払い方法の取得
     $this->arrPayment = SC_Helper_DB_Ex::sfGetIDValueList('dtb_payment', 'payment_id', 'payment_method');
     // 配送業者の取得
     $this->arrDeliv = SC_Helper_DB_Ex::sfGetIDValueList('dtb_deliv', 'deliv_id', 'name');
     $this->httpCacheControl('nocache');
 }