PHP SC_DB_MasterData_Ex类代码示例

 /**
  * Page を初期化する.
  *
  * @return void
  */
 function init()
 {
     parent::init();
     $this->tpl_mainpage = 'order/edit.tpl';
     $this->tpl_subnavi = 'order/subnavi.tpl';
     $this->tpl_mainno = 'order';
     $this->tpl_subno = 'index';
     $this->tpl_subtitle = '受注管理';
     if (empty($_GET['order_id']) && empty($_POST['order_id'])) {
         $this->tpl_subno = 'add';
         $this->tpl_mode = 'add';
         $this->tpl_subtitle = '新規受注入力';
     }
     $masterData = new SC_DB_MasterData_Ex();
     $this->arrPref = $masterData->getMasterData("mtb_pref", array("pref_id", "pref_name", "rank"));
     $this->arrORDERSTATUS = $masterData->getMasterData("mtb_order_status");
     /* ペイジェント決済モジュール連携用 */
     if (function_exists("sfPaygentOrderPage")) {
         $this->arrDispKind = sfPaygentOrderPage();
     }
     /* F-REGI決済モジュール連携用 */
     if (file_exists(MODULE_PATH . 'mdl_fregi/LC_Page_Mdl_Fregi_Config.php') === TRUE) {
         global $arrFregiPayment;
         $this->arrFregiPayment = $arrFregiPayment;
         global $arrFregiDispKind;
         $this->arrFregiDispKind = $arrFregiDispKind;
     }
 }

 public function __construct($download, $title, $tpl_pdf = 'nouhinsyo1.pdf')
 {
     $this->FPDF();
     // デフォルトの設定
     $this->tpl_pdf = PDF_TEMPLATE_REALDIR . $tpl_pdf;
     // テンプレートファイル
     $this->pdf_download = $download;
     // PDFのダウンロード形式（0:表示、1:ダウンロード）
     $this->tpl_title = $title;
     $this->tpl_dispmode = 'real';
     // 表示モード
     $masterData = new SC_DB_MasterData_Ex();
     $this->arrPref = $masterData->getMasterData('mtb_pref');
     $this->width_cell = array(110.3, 12, 21.7, 24.5);
     $this->label_cell[] = '商品名 / 商品コード / [ 規格 ]';
     $this->label_cell[] = '数量';
     $this->label_cell[] = '単価';
     $this->label_cell[] = '金額(税込)';
     $this->arrMessage = array('このたびはお買上げいただきありがとうございます。', '下記の内容にて納品させていただきます。', 'ご確認くださいますよう、お願いいたします。');
     // SJISフォント
     $this->AddSJISFont();
     $this->SetFont('SJIS');
     //ページ総数取得
     $this->AliasNbPages();
     // マージン設定
     $this->SetMargins(15, 20);
     // PDFを読み込んでページ数を取得
     $this->pageno = $this->setSourceFile($this->tpl_pdf);
 }

 /**
  * Page を初期化する.
  *
  * @return void
  */
 function init()
 {
     parent::init();
     $this->tpl_mainpage = 'products/index.tpl';
     $this->tpl_mainno = 'products';
     $this->tpl_subno = 'index';
     $this->tpl_pager = 'pager.tpl';
     $this->tpl_maintitle = '商品管理';
     $this->tpl_subtitle = '商品マスター';
     $masterData = new SC_DB_MasterData_Ex();
     $this->arrPageMax = $masterData->getMasterData('mtb_page_max');
     $this->arrDISP = $masterData->getMasterData('mtb_disp');
     $this->arrSTATUS = $masterData->getMasterData('mtb_status');
     $this->arrPRODUCTSTATUS_COLOR = $masterData->getMasterData('mtb_product_status_color');
     $objDate = new SC_Date();
     // 登録・更新検索開始年
     $objDate->setStartYear(RELEASE_YEAR);
     $objDate->setEndYear(DATE('Y'));
     $this->arrStartYear = $objDate->getYear();
     $this->arrStartMonth = $objDate->getMonth();
     $this->arrStartDay = $objDate->getDay();
     // 登録・更新検索終了年
     $objDate->setStartYear(RELEASE_YEAR);
     $objDate->setEndYear(DATE('Y'));
     $this->arrEndYear = $objDate->getYear();
     $this->arrEndMonth = $objDate->getMonth();
     $this->arrEndDay = $objDate->getDay();
 }

 function __construct($download, $title, $tpl_pdf = 'nouhinsyo1.pdf')
 {
     $this->FPDF();
     // デフォルトの設定
     $this->tpl_pdf = PDF_TEMPLATE_REALDIR . $tpl_pdf;
     // テンプレートファイル
     $this->pdf_download = $download;
     // PDFのダウンロード形式（0:表示、1:ダウンロード）
     $this->tpl_title = $title;
     $this->tpl_dispmode = 'real';
     // 表示モード
     $masterData = new SC_DB_MasterData_Ex();
     $this->arrPref = $masterData->getMasterData('mtb_pref');
     $this->width_cell = array(110.3, 12, 21.7, 24.5);
     $this->label_cell[] = t('c_Product name / Product code / [Specification]_01');
     $this->label_cell[] = t('c_Quantity_01');
     $this->label_cell[] = t('c_Unit price_01');
     $this->label_cell[] = t('c_Amount with tax_01');
     $this->arrMessage = array(t('c_Thank you for your purchase._01'), t('c_Delivery will be based on the following below._01'), t('c_Please confirm._01'));
     // SJISフォント
     $this->AddSJISFont();
     $this->SetFont('SJIS');
     //ページ総数取得
     $this->AliasNbPages();
     // マージン設定
     $this->SetMargins(15, 20);
     // PDFを読み込んでページ数を取得
     $this->pageno = $this->setSourceFile($this->tpl_pdf);
 }

 /**
  * Page を初期化する.
  *
  * @return void
  */
 public function init()
 {
     parent::init();
     $this->tpl_title = '特定商取引に関する法律に基づく表記';
     $masterData = new SC_DB_MasterData_Ex();
     $this->arrPref = $masterData->getMasterData('mtb_pref');
 }

 /**
  * Page を初期化する.
  *
  * @return void
  */
 function init()
 {
     parent::init();
     $this->tpl_title = t('c_Items in cart_01');
     $masterData = new SC_DB_MasterData_Ex();
     $this->arrProductType = $masterData->getMasterData('mtb_product_type');
 }

 /**
  * Page を初期化する.
  *
  * @return void
  */
 function init()
 {
     parent::init();
     $masterData = new SC_DB_MasterData_Ex();
     $this->arrProductType = $masterData->getMasterData('mtb_product_type');
     //商品種類を取得
 }

 /**
  * モバイルページを初期化する.
  *
  * @return void
  */
 function mobileInit()
 {
     $this->tpl_mainpage = 'shopping/deliv_addr.tpl';
     $this->tpl_title = "新しいお届け先の追加";
     $masterData = new SC_DB_MasterData_Ex();
     $this->arrPref = $masterData->getMasterData("mtb_pref", array("pref_id", "pref_name", "rank"));
 }

 /**
  * Page を初期化する.
  *
  * @return void
  */
 function init()
 {
     parent::init();
     $this->tpl_mainpage = 'products/review.tpl';
     $this->tpl_mainno = 'products';
     $this->tpl_subno = 'review';
     $this->tpl_pager = 'pager.tpl';
     $this->tpl_maintitle = '商品管理';
     $this->tpl_subtitle = 'レビュー管理';
     $masterData = new SC_DB_MasterData_Ex();
     $this->arrPageMax = $masterData->getMasterData("mtb_page_max");
     $this->arrRECOMMEND = $masterData->getMasterData("mtb_recommend");
     $this->arrSex = $masterData->getMasterData("mtb_sex");
     $objDate = new SC_Date_Ex();
     // 登録・更新検索開始年
     $objDate->setStartYear(RELEASE_YEAR);
     $objDate->setEndYear(DATE('Y'));
     $this->arrStartYear = $objDate->getYear();
     $this->arrStartMonth = $objDate->getMonth();
     $this->arrStartDay = $objDate->getDay();
     // 登録・更新検索終了年
     $objDate->setStartYear(RELEASE_YEAR);
     $objDate->setEndYear(DATE('Y'));
     $this->arrEndYear = $objDate->getYear();
     $this->arrEndMonth = $objDate->getMonth();
     $this->arrEndDay = $objDate->getDay();
 }

 protected function setUp()
 {
     parent::setUp();
     $masterData = new SC_DB_MasterData_Ex();
     $this->arrAllowedTag = $masterData->getMasterData('mtb_allowed_tag');
     $this->target_func = 'HTML_TAG_CHECK';
 }

 /**
  * 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 を初期化する.
  *
  * @return void
  */
 function init()
 {
     parent::init();
     // GDライブラリのインストール判定
     $this->install_GD = function_exists('gd_info') ? true : false;
     $this->tpl_mainpage = 'total/index.tpl';
     $this->tpl_graphsubtitle = 'total/subtitle.tpl';
     $this->tpl_titleimage = ROOT_URLPATH . 'img/title/title_sale.jpg';
     $this->tpl_maintitle = $this->tpl_maintitle = t('c_Sales (history)_01');
     $this->tpl_mainno = 'total';
     $masterData = new SC_DB_MasterData_Ex();
     $this->arrWDAY = $masterData->getMasterData('mtb_wday');
     $this->arrSex = $masterData->getMasterData('mtb_sex');
     $this->arrJob = $masterData->getMasterData('mtb_job');
     // 登録・更新日検索用
     $objDate = new SC_Date_Ex();
     $objDate->setStartYear(RELEASE_YEAR);
     $objDate->setEndYear(DATE('Y'));
     $this->arrYear = $objDate->getYear();
     $this->arrMonth = $objDate->getMonth();
     $this->arrDay = $objDate->getDay();
     // ページタイトル todo あとでなおす
     $this->arrTitle[''] = t('c_Sales by period_01');
     $this->arrTitle['term'] = t('c_Sales by period_01');
     $this->arrTitle['products'] = t('c_Sales by product_01');
     $this->arrTitle['age'] = t('c_Sales by age group_01');
     $this->arrTitle['job'] = t('c_Sales  by occupation_01');
     $this->arrTitle['member'] = t('c_Sales by member_01');
     // 月度集計のkey名
     $this->arrSearchForm1 = array('search_startyear_m', 'search_startmonth_m');
     // 期間別集計のkey名
     $this->arrSearchForm2 = array('search_startyear', 'search_startmonth', 'search_startday', 'search_endyear', 'search_endmonth', 'search_endday');
 }

 public function doAction($arrParam)
 {
     $arrRequest = $this->doInitParam($arrParam);
     if (!$this->isParamError()) {
         $masterData = new SC_DB_MasterData_Ex();
         $arrSTATUS = $masterData->getMasterData('mtb_status');
         $arrSTATUS_IMAGE = $masterData->getMasterData('mtb_status_image');
         $objProduct = new SC_Product_Ex();
         $arrSearchData = array('category_id' => $arrRequest['BrowseNode'], 'maker_name' => $arrRequest['Manufacturer'], 'name' => $arrRequest['Keywords'], 'orderby' => $arrRequest['Sort']);
         $arrSearchCondition = $this->getSearchCondition($arrSearchData);
         $disp_number = 10;
         $objQuery =& SC_Query_Ex::getSingletonInstance();
         $objQuery->setWhere($arrSearchCondition['where_for_count']);
         $objProduct = new SC_Product_Ex();
         $linemax = $objProduct->findProductCount($objQuery, $arrSearchCondition['arrval']);
         $objNavi = new SC_PageNavi_Ex($arrRequest['ItemPage'], $tpl_linemax, $disp_number);
         $arrProducts = $this->getProductsList($arrSearchCondition, $disp_number, $objNavi->start_row, $linemax, $objProduct);
         if (!SC_Utils_Ex::isBlank($arrProducts)) {
             $arrProducts = $this->setStatusDataTo($arrProducts, $arrSTATUS, $arrSTATUS_IMAGE);
             $arrProducts = $objProduct->setPriceTaxTo($arrProducts);
             foreach ($arrProducts as $key => $val) {
                 $arrProducts[$key]['main_list_image'] = SC_Utils_Ex::sfNoImageMainList($val['main_list_image']);
             }
             $arrData = array();
             foreach ($arrProducts as $key => $val) {
                 $arrData[] = array('product_id' => $val['product_id'], 'DetailPageURL' => HTTP_URL . 'products/detail.php?product_id=' . $val['product_id'], 'ItemAttributes' => $val);
             }
             $this->setResponse('Item', $arrData);
             return true;
         } else {
             $this->addError('ItemSearch.Error', '※ 要求された情報は見つかりませんでした。');
         }
     }
     return false;
 }

 /**
  * Page を初期化する.
  *
  * @return void
  */
 function init()
 {
     parent::init();
     $this->tpl_title = '現在のカゴの中';
     $masterData = new SC_DB_MasterData_Ex();
     $this->arrProductType = $masterData->getMasterData('mtb_product_type');
 }

 /**
  * コンストラクタ.
  */
 public function __construct()
 {
     $masterData = new SC_DB_MasterData_Ex();
     $this->arrMAILTPLPATH = $masterData->getMasterData('mtb_mail_tpl_path');
     $this->arrPref = $masterData->getMasterData('mtb_pref');
     $this->arrCountry = $masterData->getMasterData('mtb_country');
 }