弱小PHPerの憂鬱

    /**
     * カテゴリツリーの取得を行う.
     *
     * @param integer $parent_category_id 親カテゴリID
     * @param bool $count_check 登録商品数のチェックを行う場合 true
     * @return array カテゴリツリーの配列
     */
    function sfGetCatTree($parent_category_id, $count_check = false)

    $ret=$SC_Helper_DB->sfGetCatTree('1',false);

SELECT
    T1.category_id, category_name, level
        FROM dtb_category AS T1 
            LEFT JOIN dtb_category_total_count AS T2 
    ON T1.category_id = T2.category_id 
WHERE
    del_flg = 0 AND product_count > 0ORDER BY rank DESC

    /**
     * カテゴリツリーの取得を行う.
     *
     * $products_check:true商品登録済みのものだけ取得する
     *
     * @param string $addwhere 追加する WHERE 句
     * @param bool $products_check 商品の存在するカテゴリのみ取得する場合 true
     * @param string $head カテゴリ名のプレフィックス文字列
     * @return array カテゴリツリーの配列
     */
    function sfGetCategoryList($addwhere = "", 
        $products_check = false, $head = CATEGORY_HEAD)

    $ret=$SC_Helper_DB->sfGetCategoryList('parent_category_id=1',false);

    $ret=$SC_Helper_DB->sfGetCategoryList(
        'parent_category_id='.$_REQUEST['category_id'],false);

    $where.= " AND $addwhere";

    $ret=$SC_Helper_DB->sfDataExists('dtb_category'
        , 'parent_category_id=?', array($_REQUEST['category_id']))

    /*
        子カテゴリリストを取得
    */
    public function getChildCategory($parent_category_id=0){
        //SQL
            $objQuery = new SC_Query();
            $col = " * ";
            $where = "del_flg = 0 AND parent_category_id = ?";
            $objQuery->setOption("ORDER BY rank DESC");
        
        //実行
            $arrRet = $objQuery->select($col, "dtb_category", 
　　　　　　　　　　　　$where, array($parent_category_id));
            
        //返却
            return $arrRet;
    }

    $netURL = new Net_URL($url);
    if (!empty($_SERVER['QUERY_STRING'])) {
        $netURL->addRawQueryString($_SERVER['QUERY_STRING']);
    }
    $session = SC_SessionFactory::getInstance();
    if ($isMobile || $session->useCookie() == false) {
        $netURL->addQueryString(session_name(), session_id());
    }
    $netURL->addQueryString(TRANSACTION_ID_NAME, $this->getToken());

    if (!empty($_SERVER['QUERY_STRING'])) {
        $netURL->addRawQueryString($_SERVER['QUERY_STRING']);
    }

function sendRedirect($url, $isMobile = false ) {
    $netURL = new Net_URL($url);
    
    //GETパラメータを保存しておく
        $queryStringArray=$netURL->querystring;
    
    //今までの処理
        if (!empty($_SERVER['QUERY_STRING'])) {
            $netURL->addRawQueryString($_SERVER['QUERY_STRING']);
        }
        $session = SC_SessionFactory::getInstance();
        if ($isMobile || $session->useCookie() == false) {
            $netURL->addQueryString(session_name(), session_id());
        }
        $netURL->addQueryString(TRANSACTION_ID_NAME, $this->getToken());
 
    //GETパラメータを追加
        if(is_array($queryStringArray)){
            foreach($queryStringArray as $key=>$val){
                $netURL->addQueryString($key, $val);
            }
        }
    
    //リダイレクト
        header("Location: " . $netURL->getURL());
        exit();
}

    // 商品IDの取得
    $max = $objCartSess->getMax();
    for($i = 1; $i <= $max; $i++) {
        if($_SESSION[$objCartSess->key][$i]['id'][0] != "") {
            $arrID['product_id'][$i] 
              = $_SESSION[$objCartSess->key][$i]['id'][0];
        }
    }
    
    ↓
    
    // 商品IDの取得
    $arrID['product_id']=array();
    $tmp=$objCartSess->getAllProductID();
    foreach($tmp as $key=>$val){
        $arrID['product_id'][]=$val[0];
    }

    function getCartList(){
        return $_SESSION['cart']['products'];
    }

    function getCartList() {
        $max = $this->getMax();
        $arrRet = array();
        for($i = 0; $i <= $max; $i++) {
            if(isset($_SESSION['cart'][$i]['cart_no'])
               && $_SESSION['cart'][$i]['cart_no'] != "") {
                $arrRet[] = $_SESSION['cart'][$i];
            }
        }
        return $arrRet;
    }
    function getMax() {
        $cnt = 0;
        $pos = 0;
        $max = 0;
        if (count($_SESSION['cart']) > 0){
            foreach($_SESSION['cart'] as $key => $val) {
                if (is_numeric($key)) {
                    if($max < $key) {
                        $max = $key;
                    }
                }
            }
        }
        return ($max);
    }

$_SESSION['cart']=array(
     'prev_url'=>戻り先URL
    ,'cancel_purchase'=>購入キャンセル
    ,[0]=>array(カート内の商品1)
    ,[1]=>array(カート内の商品2)
    ,…
);

$_SESSION['cart']=array(
     'prev_url'=>戻り先URL
    ,'cancel_purchase'=>購入キャンセル
    ,'products'=>array(
         [0]=>array(カート内の商品1)
        ,[1]=>array(カート内の商品2)
        ,…
    ));

    function process() {
        $this->use_tpl_hoge=1;
        parent::process();
    }

<!--{$use_tpl_hoge}-->
    違うヘッダ
<!--{else}-->
    いつものヘッダ
<!--{/if}-->

    // ヘッダとフッタを割り当て
        $header_tpl = USER_PATH . USER_PACKAGE_DIR 
         . TEMPLATE_NAME . "/" . "header.tpl";
        $footer_tpl = USER_PATH . USER_PACKAGE_DIR 
         . TEMPLATE_NAME . "/" . "footer.tpl";
    // ユーザー作成のテンプレートが無ければ, 指定テンプレートを割り当て
        if (!$this->_smarty->template_exists($header_tpl)) {
            $header_tpl = TEMPLATE_DIR . "header.tpl";
        }
        if (!$this->_smarty->template_exists($footer_tpl)) {
            $footer_tpl = TEMPLATE_DIR . "footer.tpl";
        }

    //ヘッダフッタのテンプレートを変更する
        $objView->assign("header_tpl", TEMPLATE_DIR . "header_hoge.tpl");
        $objView->assign("footer_tpl", TEMPLATE_DIR . "footer_hoge.tpl");

    $this->arrPRODUCTLISTMAX = 
      $masterData->getMasterData("mtb_product_list_max");
    $this->disp_number = 
      current(array_keys($this->arrPRODUCTLISTMAX));

    if ($arrRet['category_id'] == 0) {
        $category_id = $objQuery->max("dtb_category", "category_id") + 1;
        $sqlval['category_id'] = $category_id;
        $update = false;
    } else {
        $sqlval['category_id'] = $arrRet['category_id'];
        $update = true;
    }

    if($arrRet['category_id']){
         $sqlval['category_id'] = $arrRet['category_id'];
        //使用済だったらUPDATE、無ければINSERT
        if( $objQuery->count("dtb_category", "category_id = ?", 
            array($sqlval['category_id'])) > 0){
            $update = true;
        }else{
            $update = false;
        }
    }else{
        $sqlval['category_id'] = $objQuery->max("dtb_category", "category_id") + 1;
        $update = false;
    }

<!-- ▼おすすめ情報 ここから-->
<!--{if count($arrBestProducts) > 0}-->
    <div id="recomendarea">
        <div class="title">おすすめ情報</div>
        
        <!--{foreach from=$arrBestProducts key=cnt item=BestProducts name=loop}-->
            <!--{if $smarty.foreach.loop.index is even }-->
                <!--{* 2件毎に段落開始 *}-->
                <div class="recomendblock">
                <div class="recomendleft">
            <!--{else}-->
                <div class="recomendright">
            <!--{/if}-->
            
                <a href="<!--{$smarty.const.URL_DIR}-->products/detail.php
                    ?product_id=<!--{$BestProducts.product_id|escape}-->">
                    <img src="<!--{$smarty.const.SITE_URL}-->resize_image.php
                        ?image=<!--{$BestProducts.main_list_image|sfRmDupSlash}-->
                        &width=48&height=48" 
                        alt="<!--{$BestProducts.name|escape}-->" />
                </a>
                <a href="<!--{$smarty.const.URL_DIR}-->products/detail.php
                    ?product_id=<!--{$BestProducts.product_id|escape}-->">
                    <!--{$BestProducts.name|escape}-->
                </a>
                <p><!--{$BestProducts.comment|escape}--></p>
            
            <!--{if ( ($smarty.foreach.loop.index is odd) 
                || ($smarty.foreach.loop.last) ) }-->
                <!--{* 2件毎、もしくは最後であれば段落終了 *}-->
                </div>
                </div>
            <!--{else}-->
                </div>
            <!--{/if}-->
        <!--{/foreach}-->
        
    </div>
<!--{/if}-->
<!-- ▲おすすめ情報 ここまで-->

<!--▼おすすめ情報ここから-->
<!--{if count($arrBestProducts) > 0}-->
<div id="recomendarea">
  <h2>
    <img src="img/top/osusume.jpg" width="400" height="29" alt="おすすめ情報" />
  </h2>
  <!--{section name=cnt loop=$arrBestProducts step=2}-->
  <div class="recomendblock">
    <div class="recomendleft">
    <!--{if $arrBestProducts[cnt].main_list_image != ""}-->
      <!--{assign var=image_path 
        value="`$arrBestProducts[cnt].main_list_image`"}-->
    <!--{else}-->
      <!--{assign var=image_path value="`$smarty.const.NO_IMAGE_DIR`"}-->
    <!--{/if}-->
 
      <a href="<!--{$smarty.const.URL_DIR}-->products/detail.php
        ?product_id=<!--{$arrBestProducts[cnt].product_id}-->">
        <img src="<!--{$smarty.const.SITE_URL}-->resize_image.php
          ?image=<!--{$image_path|sfRmDupSlash}-->&amp;width=48&amp;height=48"
          alt="<!--{$arrBestProducts[cnt].name|escape}-->" /></a>
      <h3>
        <a href="<!--{$smarty.const.URL_DIR}-->products/detail.php
          ?product_id=<!--{$arrBestProducts[cnt].product_id}-->">
          <!--{$arrBestProducts[cnt].name|escape}--></a>
      </h3>
 
<!--{assign var=price01 value=`$arrBestProducts[cnt].price01_min`}-->
<!--{assign var=price02 value=`$arrBestProducts[cnt].price02_min`}-->
 
      <p>価格<span class="mini">(税込)</span>：<span class="price">
  <!--{if $price02 == ""}-->
    <!--{$price01|sfPreTax:$arrInfo.tax:$arrInfo.tax_rule|number_format}-->
  <!--{else}-->
    <!--{$price02|sfPreTax:$arrInfo.tax:$arrInfo.tax_rule|number_format}-->
  <!--{/if}-->円
        </span>
      </p>
      <p class="mini"><!--{$arrBestProducts[cnt].comment|escape|nl2br}--></p>
    </div>
 
    <div class="recomendright">
      <!--{assign var=cnt2 
        value=`$smarty.section.cnt.iteration*$smarty.section.cnt.step-1` }-->
      <!--{if $arrBestProducts[$cnt2]|count > 0}-->
        <!--{if $arrBestProducts[$cnt2].main_list_image != ""}-->
          <!--{assign var=image_path 
            value="`$arrBestProducts[$cnt2].main_list_image`"}-->
        <!--{else}-->
          <!--{assign var=image_path value="`$smarty.const.NO_IMAGE_DIR`"}-->
        <!--{/if}-->
 
      <a href="<!--{$smarty.const.URL_DIR}-->products/detail.php
        ?product_id=<!--{$arrBestProducts[$cnt2].product_id}-->">
        <img src="<!--{$smarty.const.SITE_URL}-->resize_image.php
           ?image=<!--{$image_path|sfRmDupSlash}-->&amp;width=48&amp;height=48"
           alt="<!--{$arrBestProducts[$cnt2].name|escape}-->" /></a>
      <h3>
      <a href="<!--{$smarty.const.URL_DIR}-->products/detail.php
        ?product_id=<!--{$arrBestProducts[$cnt2].product_id}-->">
        <!--{$arrBestProducts[$cnt2].name|escape}--></a>
      </h3>
 
<!--{assign var=price01 value=`$arrBestProducts[$cnt2].price01_min`}-->
<!--{assign var=price02 value=`$arrBestProducts[$cnt2].price02_min`}-->
 
      <p>価格<span class="mini">(税込)</span>：<span class="price">
  <!--{if $price02 == ""}-->
    <!--{$price01|sfPreTax:$arrInfo.tax:$arrInfo.tax_rule|number_format}-->
  <!--{else}-->
    <!--{$price02|sfPreTax:$arrInfo.tax:$arrInfo.tax_rule|number_format}-->
  <!--{/if}-->円</span>
      </p>
 
      <p class="mini"><!--{$arrBestProducts[$cnt2].comment|escape|nl2br}--></p>
      <!--{/if}-->
    </div>
  </div>
  <!--{/section}-->
</div>
<!--{/if}-->
<!--▲おすすめ情報ここまで-->

    //SSLでなければSSLページに移動
        if(strpos(SITE_URL,$_SERVER['SERVER_NAME'])!==false){
            $this->sendRedirect($this->getLocation(
                "./index.php", array(), true));
            exit;
        }