db = sp4inq_open(); $template =& loadTemplate( $p ); $line_max = 5; $p['page'] = (empty($p['page'])) ? '1' : $p['page']; $start = $line_max * ($p['page'] - 1); $limit = $line_max; $status_arr = array( '0' => '未対応', '3' => '商人町', '4' => '対応済み', '5' => '非対応' ); $db_user = u4user_open(); $where = sprintf(" car_no = '%s' and del_flg = 0 ",$p['uid']); $user_detail = u4user_select_one($db_user,$where); u4user_close($db_user); $where = sprintf(" customer_id = '%s' ",$user_detail['email']); $all_inq = sp4inq_get_list($this->db,$where,'upd_date','desc',$start,$limit); //var_dump($all_inq); if(1 > count($all_inq)){ $template->touchBlock('__NoExists__'); }else{ for($i=0;$isetCurrentBlock('__Item__'); $template->setVariable('inq_date',$all_inq[$i]['upd_date']); $template->setVariable('inq_id',$all_inq[$i]['id']); if(!empty($p['p_no'])){ $item_url = sprintf("&p[p_no]=%d",$p['p_no']); } if(!empty($p['mode'])){ $item_url .= "&p[mode]=1"; } if(!empty($item_url)){ $template->setVariable('add_param',$item_url); } $template->setVariable('subject',$all_inq[$i]['title']); $template->setVariable('status',$status_arr[$all_inq[$i]['status']]); $template->parseCurrentBlock(); } } $inq_ct = sp4inq_get_list($this->db,$where); $count = count($inq_ct); sp4inq_close($this->db); //--- 商品問合せ処理 if(!empty($p['p_no']) && empty($p['mode'])){ $this->db = cs4_open(); //-- ジャンル配列 $gnr_name_arr = array( '12' => array('rice','厳選日本のお米100選'), '11' => array('water','世界の銘水100選'), '13' => array('spice','究極の調味料'), '14' => array('kitchen','キッチングッズ'), '15' => array('oishu','五つ星のお取寄せ'), '16' => array('oishu','五つ星のお取寄せ') ); $item_detail = get_item_detail($this->db,$p['p_no'],1); $pdc_detail = get_producer_detail($this->db,$item_detail['pdc_no']); $dir_name = $gnr_name_arr[substr($item_detail['p_gnr'],0,2)][0]; $back_url = sprintf("/%s/%s_detail.php?p[p_no]=%d",$dir_name,$dir_name,$item_detail['uniq_id']); $back_url_footer = sprintf("/%s/%s_top.php",$dir_name,$dir_name); //- ページタイトル $template->setCurrentBlock('__ItemHeader__'); $template->setVariable('inq_header',sprintf("%s%s",$pdc_detail['pdc_nm'],$item_detail['p_nm'])); $template->parseCurrentBlock(); //- 商品番号 $template->setCurrentBlock('__ItemNo__'); $template->setVariable('p_no',$p['p_no']); $template->parseCurrentBlock(); //- 商品詳細戻り $template->setCurrentBlock('__BacktoItem__'); $template->setVariable('detail_url',$back_url); $template->parseCurrentBlock(); //- 商品トップ戻り $template->setCurrentBlock('__ItemFooter__'); $template->setVariable('return_url',$back_url_footer); $template->setVariable('return_page',$gnr_name_arr[substr($item_detail['p_gnr'],0,2)][1]); $template->parseCurrentBlock(); cs4_close($this->db); }else{ if(!empty($p['p_no']) && !empty($p['mode'])){ $template->setVariable('inq_target','ご購入商品お問合せ'); $template->TouchBlock('__PurchaseHeader__'); }else{ $template->TouchBlock('__SiteHeader__'); $template->setVariable('inq_target','美食総合倶楽部'); } $template->HideBlock('__BacktoItem__'); $template->HideBlock('__ItemFooter__'); $template->TouchBlock('__SupportFooter__'); } //- ページ送り処理 if($p['page'] > 1 ){ $prev_url = sprintf("support_history_list.php?p[page]=%d",$p['page'] - 1); if(!empty($p['p_no'])){ $prev_url .= sprintf("&p[p_no]=%d",$p['p_no']); } if(!empty($p['mode'])){ $prev_url .= "&p[mode]=1"; } $template->setCurrentBlock('__PagePrev__'); $template->setVariable('prev',$prev_url); $template->parseCurrentBlock(); } if( $count > ($p['page'] * $line_max)){ $next_url = sprintf("support_history_list.php?p[page]=%d",$p['page'] + 1); if(!empty($p['p_no'])){ $next_url .= sprintf("&p[p_no]=%d",$p['p_no']); } if(!empty($p['mode'])){ $next_url .= "&p[mode]=1"; } $template->setCurrentBlock('__PageNext__'); $template->setVariable('next',$next_url); $template->parseCurrentBlock(); } $template->show(); } support_history_list( $p ); ?>