<?php
/**
 * BuyController
 *
 * @category   Cucar
 * @package    Pricer_Controller
 * @author     $Author$
 * @since      $Date: 2012-08-21 09:36:19 +0900 (火, 21 8 2012) 
 * @version    $Rev$
 * @copyright  Copyright (c) 2008-2014 Picer K.K All Rights Reserved.
 *             http://www.pricer.jp
 * @see        Zend_Controller_Action
 */
class ShopController extends Pricer_Controller_Action_Frontend  {

	public function init(){
		$this->_is_include_common_side_tpl = false;
		parent::init();
		$req = $this->getRequest();
		$_r = $req->getParams();
		// 店名取得
		$DealershipMaster = new Apis_Vie_DealershipMaster($this->_conn);
//		$DealershipMaster = new Apis_Vie_HanbaitenMaster($this->_conn);
		$dmParam = array(
		DealershipMaster::COL_DEALERSHIPCD => $_r[RequestParam::REQ_DEALERSHIP_CODE],
		);
		$DealershipMasterOne = $DealershipMaster->findOne($dmParam);
		$this->view->assign('DealershipMasterOne' , $DealershipMasterOne);

		// グループ店名取得
		if(isset($_r['GroupCD']) && $_r['GroupCD'] != ""){
			$dmParam = array(
			DealershipMaster::COL_DEALERSHIPCD => $_r['GroupCD'],
			);
			$GroupMasterOne = $DealershipMaster->findOne($dmParam);
			$this->view->assign('GroupMasterOne' , $GroupMasterOne);
		}

		// お気に入りショップが存在するかチェック
		$Favorite_Dealer = new Apis_Favorite_Dealer($this->_conn);
		$ipAddress = $_SERVER["REMOTE_ADDR"];
		$ua = $_SERVER['HTTP_USER_AGENT'];
		if($this->_pnSystemGlobalCD == 0){
			$fdparam = array(
			Favorite_Dealer::COL_DEALERSHIPCD => $_r[RequestParam::REQ_DEALERSHIP_CODE],
			Favorite_Dealer::COL_REMOTE_ADDR => $ipAddress,
			Favorite_Dealer::COL_HTTP_USER_AGENT => $ua,
			);
		}else{
			$fdparam = array(
			Favorite_Dealer::COL_DEALERSHIPCD => substr_replace($_r[RequestParam::REQ_DEALERSHIP_CODE],'N',0,1),
			Favorite_Dealer::COL_REMOTE_ADDR => $ipAddress,
			Favorite_Dealer::COL_HTTP_USER_AGENT => $ua,
			);
		}
		$Favorite_DealerOne = $Favorite_Dealer->findOne($fdparam);
		$this->view->assign('Favorite_DealerOne' , $Favorite_DealerOne);

		// ロゴ、メニューflagなど
		$Vie_ShopForHeader = new Apis_Vie_ShopForHeader($this->_conn);
		$vsfhParam = array(
		Vie_ShopForHeader::COL_DEALERSHIPCD => $_r[RequestParam::REQ_DEALERSHIP_CODE],
		);
		$Vie_ShopForHeaderOne = $Vie_ShopForHeader->findOne($vsfhParam);
		$this->view->assign('Vie_ShopForHeaderOne' , $Vie_ShopForHeaderOne);
		$actionName = $req->getActionName();
		if($actionName == 'index' && $Vie_ShopForHeaderOne->{Vie_ShopForHeader::COL_CSONLYFLAG} == 1){
			$this->_redirect('/shop/stock-list/DealershipCD/'.$_r[RequestParam::REQ_DEALERSHIP_CODE]);
		}

		// 保証・整備、スタッフが存在するかチェック
		$Vie_Itp_NdAppealJoinNdFileEntry = new Apis_Vie_Itp_NdAppealJoinNdFileEntry($this->_conn);
		// 保証
		$hosyouParam = array(
		Vie_Itp_NdAppealJoinNdFileEntry::COL_DEALERSHIPCD => $_r[RequestParam::REQ_DEALERSHIP_CODE],
		Vie_Itp_NdAppealJoinNdFileEntry::COL_APPEALTYPE => 1,
		);
		$seibiParam = array(
		Vie_Itp_NdAppealJoinNdFileEntry::COL_DEALERSHIPCD => $_r[RequestParam::REQ_DEALERSHIP_CODE],
		Vie_Itp_NdAppealJoinNdFileEntry::COL_APPEALTYPE => 2,
		);
		$staffParam = array(
		Vie_Itp_NdAppealJoinNdFileEntry::COL_DEALERSHIPCD => $_r[RequestParam::REQ_DEALERSHIP_CODE],
		Vie_Itp_NdAppealJoinNdFileEntry::COL_APPEALTYPE => 3,
		);
		$serviceParam = array(
		Vie_Itp_NdAppealJoinNdFileEntry::COL_DEALERSHIPCD => $_r[RequestParam::REQ_DEALERSHIP_CODE],
		Vie_Itp_NdAppealJoinNdFileEntry::COL_APPEALTYPE => 4,
		);
		$vinOrd = array(
		Vie_Itp_NdAppealJoinNdFileEntry::COL_REGDATE => Model::SORT_ORDER_ASC,
		);
		$hosyouOne  = $Vie_Itp_NdAppealJoinNdFileEntry->select()->setAnd($hosyouParam)->setOrder($vinOrd)->fetch();
		$seibiOne   = $Vie_Itp_NdAppealJoinNdFileEntry->select()->setAnd($seibiParam)->setOrder($vinOrd)->fetch();
		$staffOne   = $Vie_Itp_NdAppealJoinNdFileEntry->select()->setAnd($staffParam)->setOrder($vinOrd)->fetch();
		$serviceOne = $Vie_Itp_NdAppealJoinNdFileEntry->select()->setAnd($serviceParam)->setOrder($vinOrd)->fetch();
		$this->view->assign('hosyouOne', $hosyouOne);
		$this->view->assign('seibiOne', $seibiOne);
		$this->view->assign('staffOne', $staffOne);
		$this->view->assign('serviceOne', $serviceOne);

		// 在庫情報が存在するかチェック
		$Vie_MjnetCaDataListSmart = new Apis_Vie_MjnetCarDataListSmart($this->_conn);
		$vmcdlsParam = array(
		Vie_MjnetCarDataListSmart::COL_HANBAITENCODE => $_r[RequestParam::REQ_DEALERSHIP_CODE],
		);
		$Vie_MjnetCaDataListSmartOne = $Vie_MjnetCaDataListSmart->findOne($vmcdlsParam);
		$this->view->assign('Vie_MjnetCaDataListSmartOne' , $Vie_MjnetCaDataListSmartOne);

		// レビューが存在するかチェック
		$Vie_ReviewJoinCarName = new Apis_Vie_ReviewJoinCarName($this->_conn);
		$vrjcnParam = array(
		Vie_ReviewJoinCarName::COL_DEALERSHIPCD => $_r[RequestParam::REQ_DEALERSHIP_CODE],
		Vie_ReviewJoinCarName::COL_PUBLISH => 1,
		);
		$Vie_ReviewJoinCarNameOne = $Vie_ReviewJoinCarName->findOne($vrjcnParam);
		$this->view->assign('Vie_ReviewJoinCarNameOne' , $Vie_ReviewJoinCarNameOne);

		// お客様の声が存在するかどうか？
		$Vie_NetDealerCustomerVoice = new Apis_Vie_NetDealerCustomerVoice($this->_conn);
		$vndcvParam = array(
		Vie_NetDealerCustomerVoice::COL_DEALERID => $_r[RequestParam::REQ_DEALERSHIP_CODE],
		Vie_NetDealerCustomerVoice::COL_DEL_FLG => 0,
		);
		$ord = array(
		Vie_NetDealerCustomerVoice::COL_CDATE => Model::SORT_ORDER_DESC,
		);

		$Vie_NetDealerCustomerVoiceOne = $Vie_NetDealerCustomerVoice->select()->setAnd($vndcvParam)->setOrder($ord)->fetch();
		$this->view->assign('Vie_NetDealerCustomerVoiceOne' , $Vie_NetDealerCustomerVoiceOne);
		
		// ju_flag（くるまる）
		if($this->_pnSystemGlobalCD == 1){
			$Vie_HanbaitenMaster = new Apis_Vie_HanbaitenMaster($this->_conn);
			$p_ju = array(
			Vie_HanbaitenMaster::COL_DEALERSHIPCD => $_r[RequestParam::REQ_DEALERSHIP_CODE],
			);
			$Vie_HanbaitenMasterOne = $Vie_HanbaitenMaster->findOne($p_ju);
			$this->view->assign('Vie_HanbaitenMasterOne' , $Vie_HanbaitenMasterOne);
		}
		if($this->_pnSystemGlobalCD == 0){
			$DealershipCD = $_r[RequestParam::REQ_DEALERSHIP_CODE];
		}else{
			$DealershipCD = substr_replace($_r[RequestParam::REQ_DEALERSHIP_CODE],'N',0,1); 
		}
		$this->view->assign('DealershipCD' , $DealershipCD);
	}

	/**
	 * お店情報トップ
	 *
	 */
	public function indexAction(){
		$req = $this->getRequest();
		$_r = $req->getParams();

		$TANMATU = $_SERVER ["HTTP_USER_AGENT"];
		$sHTTP_REFERER = $_SERVER ["HTTP_REFERER"];
		if($this->_pnSystemGlobalCD == 0){
			if ((strpos ( $TANMATU, "iPhone" ) > 0) && (strpos ( $sHTTP_REFERER, "mjnet.co.jp" ) > 0)) {
				$sp_url = 'http://www2.mjnet.co.jp/ucar/smart/shop.asp?dealerid='.$_r[RequestParam::REQ_DEALERSHIP_CODE];
			} elseif (strpos ( $TANMATU, "iPhone" ) > 0) {
				$this->_redirect('http://www2.mjnet.co.jp/ucar/smart/shop.asp?dealerid='.$_r[RequestParam::REQ_DEALERSHIP_CODE]);
			} elseif ((strpos ( $TANMATU, "Android" ) > 0) && (strpos ( $sHTTP_REFERER, "mjnet.co.jp" ) > 0)) {
				$sp_url = 'http://www2.mjnet.co.jp/ucar/android/shop.asp?dealerid='.$_r[RequestParam::REQ_DEALERSHIP_CODE];
			} elseif (strpos ( $TANMATU, "Android" ) > 0) {
				$this->_redirect('http://www2.mjnet.co.jp/ucar/android/shop.asp?dealerid='.$_r[RequestParam::REQ_DEALERSHIP_CODE]);
			}
		}else{
			if ((strpos ( $TANMATU, "iPhone" ) > 0) && (strpos ( $sHTTP_REFERER, "kurumaru.com" ) > 0)) {
				$sp_url = 'http://m.kurumaru.com/kurumaru/smart/shop.asp?dealerid='.$_r[RequestParam::REQ_DEALERSHIP_CODE];
			} elseif (strpos ( $TANMATU, "iPhone" ) > 0) {
				$this->_redirect('http://m.kurumaru.com/kurumaru/smart/shop.asp?dealerid='.$_r[RequestParam::REQ_DEALERSHIP_CODE]);
			} elseif ((strpos ( $TANMATU, "Android" ) > 0) && (strpos ( $sHTTP_REFERER, "kurumaru.com" ) > 0)) {
				$sp_url = 'http://m.kurumaru.com/kurumaru/android/shop.asp?dealerid='.$_r[RequestParam::REQ_DEALERSHIP_CODE];
			} elseif (strpos ( $TANMATU, "Android" ) > 0) {
				$this->_redirect('http://m.kurumaru.com/kurumaru/android/shop.asp?dealerid='.$_r[RequestParam::REQ_DEALERSHIP_CODE]);
			}
		}
		$this->view->assign ( 'sp_url', $sp_url );
		
		$Itp_NdCarlife_ = new Apis_Itp_NdCarlife_($this->_conn);
		$Itp_NdAcl = new Apis_Itp_NdAcl($this->_conn);
		if($this->_pnSystemGlobalCD == 0){
			$incParam = array(
			Itp_NdCarlife_::COL_DEALERSHIPCD => $_r[RequestParam::REQ_DEALERSHIP_CODE],
			);
			$inaParam = array(
			Itp_NdAcl::COL_DEALERSHIPCD => $_r[RequestParam::REQ_DEALERSHIP_CODE],
			);
		}else{
			$incParam = array(
			Itp_NdCarlife_::COL_DEALERSHIPCD => substr_replace($_r[RequestParam::REQ_DEALERSHIP_CODE],'N',0,1),
			);
			$inaParam = array(
			Itp_NdAcl::COL_DEALERSHIPCD => substr_replace($_r[RequestParam::REQ_DEALERSHIP_CODE],'N',0,1),
			);
		}
		$Itp_NdCarlife_One = $Itp_NdCarlife_->findOne($incParam);
		$Itp_NdAclOne = $Itp_NdAcl->findOne($inaParam);
		$this->view->assign('Itp_NdAclOne', $Itp_NdAclOne);
		$this->view->assign('Itp_NdCarlife_One', $Itp_NdCarlife_One);

		// オススメ物件
		$Vie_MjnetCarDataListSmartJoinBukkenState = new Apis_Vie_MjnetCarDataListSmartJoinBukkenState($this->_conn);
		$vmcdlsjbsParam = array(
		Vie_MjnetCarDataListSmartJoinBukkenState::COL_HANBAITENCODE => $_r[RequestParam::REQ_DEALERSHIP_CODE],
		Vie_MjnetCarDataListSmartJoinBukkenState::COL_OSUSUMEFLAG => 1,
		);
		$vmcdlsjbsOrd = array(
		Vie_MjnetCarDataListSmartJoinBukkenState::COL_RENEWALDATE => Model::SORT_ORDER_DESC,
		);
		if(isset($vmcdlsjbsParam) && $vmcdlsjbsParam != ""){
			$Vie_MjnetCarDataListSmartJoinBukkenStateList = $Vie_MjnetCarDataListSmartJoinBukkenState->select()->setAnd($vmcdlsjbsParam)->setOrder($vmcdlsjbsOrd)->setLimit(5)->fetchAll();
			// データ整形
			foreach($Vie_MjnetCarDataListSmartJoinBukkenStateList as $vmcdlswp)
			{
				$vmcdlswp = $this->_lfDataFormatForCar($vmcdlswp);
			}
		}
		$this->view->assign('Vie_MjnetCarDataListSmartJoinBukkenStateList', $Vie_MjnetCarDataListSmartJoinBukkenStateList);


		$GeneralDealer = new Apis_GeneralDealer($this->_conn);
		$gdParam = array(
		GeneralDealer::COL_ID => $_r[RequestParam::REQ_DEALERSHIP_CODE],
		);
		$GeneralDealerOne = $GeneralDealer->findOne($gdParam);
		$this->view->assign('GeneralDealerOne', $GeneralDealerOne);

		// 冒頭の画像2枚とキャプション
		$Itp_NdSalesPoint = new Apis_Itp_NdSalesPoint($this->_conn);
		if($this->_pnSystemGlobalCD == 0){
			$inspParam = array(
			Itp_NdSalesPoint::COL_DEALERSHIPCD => $_r[RequestParam::REQ_DEALERSHIP_CODE],
			);
		}else{
			$inspParam = array(
			Itp_NdSalesPoint::COL_DEALERSHIPCD => substr_replace($_r[RequestParam::REQ_DEALERSHIP_CODE],'N',0,1),
			);
		}
		$inspOrd = array(
		Itp_NdSalesPoint::COL_SORT => Model::SORT_ORDER_ASC,
		);

		$Itp_NdSalesPointList = $Itp_NdSalesPoint->select()->setAnd($inspParam)->setOrder($inspOrd)->fetchAll();
		$this->view->assign('Itp_NdSalesPointList' , $Itp_NdSalesPointList);

		// フォトギャラリー
		$Vie_Itp_NdGalleryJoinNdFileEntry = new Apis_Vie_Itp_NdGalleryJoinNdFileEntry($this->_conn);
		$vingjnfeParam = array(
		Vie_Itp_NdGalleryJoinNdFileEntry::COL_DEALERSHIPCD => $_r[RequestParam::REQ_DEALERSHIP_CODE],
		);
		$vingjnfeOrd = array(
		Vie_Itp_NdGalleryJoinNdFileEntry::COL_SORT => Model::SORT_ORDER_ASC,
		);

		$Vie_Itp_NdGalleryList = $Vie_Itp_NdGalleryJoinNdFileEntry->select()->setAnd($vingjnfeParam)->setOrder($vingjnfeOrd)->setLimit(12)->fetchAll();
		$this->view->assign('Vie_Itp_NdGalleryList' , $Vie_Itp_NdGalleryList);

		//		// 保証・整備、スタッフ
		//		$Vie_Itp_NdAppealJoinNdFileEntry = new Apis_Vie_Itp_NdAppealJoinNdFileEntry($this->_conn);
		//		$hosyouParam = array(
		//		Vie_Itp_NdAppealJoinNdFileEntry::COL_DEALERSHIPCD => $_r[RequestParam::REQ_DEALERSHIP_CODE],
		//		Vie_Itp_NdAppealJoinNdFileEntry::COL_APPEALTYPE => 1,
		//		);
		//		$seibiParam = array(
		//		Vie_Itp_NdAppealJoinNdFileEntry::COL_DEALERSHIPCD => $_r[RequestParam::REQ_DEALERSHIP_CODE],
		//		Vie_Itp_NdAppealJoinNdFileEntry::COL_APPEALTYPE => 2,
		//		);
		//		$staffParam = array(
		//		Vie_Itp_NdAppealJoinNdFileEntry::COL_DEALERSHIPCD => $_r[RequestParam::REQ_DEALERSHIP_CODE],
		//		Vie_Itp_NdAppealJoinNdFileEntry::COL_APPEALTYPE => 3,
		//		);
		//		$vinOrd = array(
		//		Vie_Itp_NdAppealJoinNdFileEntry::COL_REGDATE => Model::SORT_ORDER_ASC,
		//		);
		//		$hosyouOne = $Vie_Itp_NdAppealJoinNdFileEntry->select()->setAnd($hosyouParam)->setOrder($vinOrd)->fetch();
		//		$seibiOne = $Vie_Itp_NdAppealJoinNdFileEntry->select()->setAnd($seibiParam)->setOrder($vinOrd)->fetch();
		//		$staffOne = $Vie_Itp_NdAppealJoinNdFileEntry->select()->setAnd($staffParam)->setOrder($vinOrd)->fetch();
		//		$this->view->assign('hosyouOne', $hosyouOne);
		//		$this->view->assign('seibiOne', $seibiOne);
		//		$this->view->assign('staffOne', $staffOne);

		// フェア＆イベント
		$NetDealerInfo = new Apis_NetDealerInfo($this->_conn);
		$eventParam = array(
		NetDealerInfo::COL_DEALERID => $_r[RequestParam::REQ_DEALERSHIP_CODE],
		NetDealerInfo::COL_PICKUP => 1,
		NetDealerInfo::COL_DEL_FLG => 0,
		);
		$ndiOrd = array(
		NetDealerInfo::COL_STARTDAY => Model::SORT_ORDER_DESC,
		);
		$EventOne = $NetDealerInfo->select()->setAnd($eventParam)->setOrder($ndiOrd)->fetch();
		$this->view->assign('EventOne', $EventOne);

		// インフォメーション
		$ndiParam = array(
		NetDealerInfo::COL_DEALERID => $_r[RequestParam::REQ_DEALERSHIP_CODE],
		NetDealerInfo::COL_DEL_FLG => 0,
		);
		$NetDealerInfoList = $NetDealerInfo->select()->setAnd($ndiParam)->setOrder($ndiOrd)->setLimit(2)->fetchAll();
		$this->view->assign('NetDealerInfoList', $NetDealerInfoList);

		// TODO twitterの表示がおかしい　旧サイトも
		$DealerProfile = new Apis_DealerProfile($this->_conn);
		if($this->_pnSystemGlobalCD == 0){
			$dpParam = array(
			DealerProfile::COL_DEALERSHIPCD => $_r[RequestParam::REQ_DEALERSHIP_CODE],
			);
		}else{
			$dpParam = array(
			DealerProfile::COL_DEALERSHIPCD => substr_replace($_r[RequestParam::REQ_DEALERSHIP_CODE],'N',0,1),
			);
		}
		$DealerProfileOne = $DealerProfile->findOne($dpParam);
		$this->view->assign('DealerProfileOne', $DealerProfileOne);

		// お店より一言
		$Itp_NdInfoChargeData = new Apis_Itp_NdInfoChargeData($this->_conn);
		if($this->_pnSystemGlobalCD == 0){
			$incdParam = array(
			Itp_NdInfoChargeData::COL_DEALERSHIPCD => $_r[RequestParam::REQ_DEALERSHIP_CODE],
			Itp_NdInfoChargeData::COL_DELETEFLAG => 0,
			);
		}else{
			$incdParam = array(
			Itp_NdInfoChargeData::COL_DEALERSHIPCD => substr_replace($_r[RequestParam::REQ_DEALERSHIP_CODE],'N',0,1),
			Itp_NdInfoChargeData::COL_DELETEFLAG => 0,
			);
		}
		$incdOrd = array(
		Itp_NdInfoChargeData::COL_CHARGEDIV => Model::SORT_ORDER_ASC,
		);
		$Itp_NdInfoChargeDataList = $Itp_NdInfoChargeData->select()->setAnd($incdParam)->setOrder($incdOrd)->fetchAll();
		$this->view->assign('Itp_NdInfoChargeDataList', $Itp_NdInfoChargeDataList);

		// ブログ
		$SiteRssData = new Apis_SiteRssData($this->_conn);
		$SiteRssMasterData = new Apis_SiteRssMasterData($this->_conn);
		$srmdParam = array(
		SiteRssMasterData::COL_DEALERID => $_r[RequestParam::REQ_DEALERSHIP_CODE],
		SiteRssMasterData::COL_DEL_FLG => 0,
		);
		$SiteRssMasterDataOne = $SiteRssMasterData->findOne($srmdParam);
		$srdParam = array(
		SiteRssData::COL_BLOGMASTERID => $SiteRssMasterDataOne->{SiteRssMasterData::COL_ID},
		);
		$srdOrd = array(
		SiteRssData::COL_BLOGDATETIME => Model::SORT_ORDER_DESC,
		);
		$SiteRssDataList = $SiteRssData->select()->setAnd($srdParam)->setOrder($srdOrd)->setLimit(5)->fetchAll();
		$this->view->assign('SiteRssDataList', $SiteRssDataList);

		// Mj
		$Vie_MediaDataTableJoinRunDealerData = new Apis_Vie_MediaDataTableJoinRunDealerData($this->_conn);
		$vmdtjrddParam = array(
		Vie_MediaDataTableJoinRunDealerData::COL_DEALERCODE => $_r[RequestParam::REQ_DEALERSHIP_CODE],
		Vie_MediaDataTableJoinRunDealerData::COL_MEDIANO => 1,
		);
		$vmdtjrddOrd = array(
		Vie_MediaDataTableJoinRunDealerData::COL_MEDIANO => Model::SORT_ORDER_DESC,
		);
		$Vie_MediaDataTableJoinRunDealerDataOne = $Vie_MediaDataTableJoinRunDealerData->select()->setAnd($vmdtjrddParam)->setOrder($vmdtjrddOrd)->fetch();

		$release_date = explode("-", $Vie_MediaDataTableJoinRunDealerDataOne->{Vie_MediaDataTableJoinRunDealerData::COL_RELEASEDATE});
		$Vie_MediaDataTableJoinRunDealerDataOne->year = $release_date[0];
		$Vie_MediaDataTableJoinRunDealerDataOne->month = $release_date[1];
		$Vie_MediaDataTableJoinRunDealerDataOne->day = substr($release_date[2], 0, 2);
		$this->view->assign('Vie_MediaDataTableJoinRunDealerDataOne', $Vie_MediaDataTableJoinRunDealerDataOne);

		// Mjマガジンpdfチェック
		if(file_get_contents("http://www2.mjnet.co.jp/ucar/carlife/pdf/cf" . $_r[RequestParam::REQ_DEALERSHIP_CODE] . ".pdf")){
			$PdfFlag = 1;
		}else {
			$PdfFlag = 0;
		}
		$this->view->assign('PdfFlag' , $PdfFlag);

		// お気に入りショップリスト
		$Vie_FavoriteDealer = new Apis_Vie_FavoriteDealer($this->_conn);
		$ipAddress = $_SERVER["REMOTE_ADDR"];
		$ua = $_SERVER['HTTP_USER_AGENT'];
		$vfdParam = array(
		Vie_FavoriteDealer::COL_REMOTE_ADDR => $ipAddress,
		Vie_FavoriteDealer::COL_HTTP_USER_AGENT => $ua,
		);
		$vfdOrd = array(
		Vie_FavoriteDealer::COL_DATAREGISTRATIONDATE => Model::SORT_ORDER_DESC,
		);
		$Vie_FavoriteDealerList = $Vie_FavoriteDealer->select()->setAnd($vfdParam)->setOrder($vfdOrd)->fetchAll();
		$this->view->assign('Vie_FavoriteDealerList' , $Vie_FavoriteDealerList);
		$this->LogInsert(1);
		
		// クーポン（くるまる）
		if($this->_pnSystemGlobalCD == 1){
			$Dealer_CouponData = new Apis_Vie_Dealer_CouponData($this->_conn);
			$p_coupon = array(
			Dealer_CouponData::COL_DEALERID => $_r[RequestParam::REQ_DEALERSHIP_CODE],
			Dealer_CouponData::COL_DEL_FLG => 0,
			);
			$couponOrd = array(
			Dealer_CouponData::COL_COUPONCD => Model::SORT_ORDER_ASC
			);
			$Dealer_CouponDataList = $Dealer_CouponData->select()->setAnd($p_coupon)->setOrder($couponOrd)->fetchAll();
			foreach($Dealer_CouponDataList as $Dealer_CouponDataOne){
				if(date('d') <= 24){
					$Dealer_CouponDataOne->CouponYear = date('Y');
					$Dealer_CouponDataOne->CouponMonth = date('n');
	
				}else{
					$Dealer_CouponDataOne->CouponYear = date('Y',strtotime('+1 month'));
					$Dealer_CouponDataOne->CouponMonth = date('n',strtotime('+1 month'));
				}
			}
			$this->view->assign('Dealer_CouponDataList' , $Dealer_CouponDataList);
		}
	}

	/**
	 * 在庫リスト
	 *
	 */
	public function stockListAction(){

		$req = $this->getRequest();
		$_r = $req->getParams();

		$TANMATU = $_SERVER ["HTTP_USER_AGENT"];
		$sHTTP_REFERER = $_SERVER ["HTTP_REFERER"];

		if($this->_pnSystemGlobalCD == 0){
			if ((strpos ( $TANMATU, "iPhone" ) > 0) && (strpos ( $sHTTP_REFERER, "mjnet.co.jp" ) > 0)) {
				$sp_url = 'http://www2.mjnet.co.jp/ucar/smart/shop_list_carname.asp?dealerid='.$_r[RequestParam::REQ_DEALERSHIP_CODE];
			} elseif (strpos ( $TANMATU, "iPhone" ) > 0) {
				$this->_redirect('http://www2.mjnet.co.jp/ucar/smart/shop_list_carname.asp?dealerid='.$_r[RequestParam::REQ_DEALERSHIP_CODE]);
			} elseif ((strpos ( $TANMATU, "Android" ) > 0) && (strpos ( $sHTTP_REFERER, "mjnet.co.jp" ) > 0)) {
				$sp_url = 'http://www2.mjnet.co.jp/ucar/android/shop_list_carname.asp?dealerid='.$_r[RequestParam::REQ_DEALERSHIP_CODE];
			} elseif (strpos ( $TANMATU, "Android" ) > 0) {
				$this->_redirect('http://www2.mjnet.co.jp/ucar/android/shop_list_carname.asp?dealerid='.$_r[RequestParam::REQ_DEALERSHIP_CODE]);
			}
		}else{
			if ((strpos ( $TANMATU, "iPhone" ) > 0) && (strpos ( $sHTTP_REFERER, "kurumaru.com" ) > 0)) {
				$sp_url = 'http://m.kurumaru.com/kurumaru/smart/shop_list_carname.asp?dealerid='.$_r[RequestParam::REQ_DEALERSHIP_CODE];
			} elseif (strpos ( $TANMATU, "iPhone" ) > 0) {
				$this->_redirect('http://m.kurumaru.com/kurumaru/smart/shop_list_carname.asp?dealerid='.$_r[RequestParam::REQ_DEALERSHIP_CODE]);
			} elseif ((strpos ( $TANMATU, "Android" ) > 0) && (strpos ( $sHTTP_REFERER, "kurumaru.com" ) > 0)) {
				$sp_url = 'http://m.kurumaru.com/kurumaru/android/shop_list_carname.asp?dealerid='.$_r[RequestParam::REQ_DEALERSHIP_CODE];
			} elseif (strpos ( $TANMATU, "Android" ) > 0) {
				$this->_redirect('http://m.kurumaru.com/kurumaru/android/shop_list_carname.asp?dealerid='.$_r[RequestParam::REQ_DEALERSHIP_CODE]);
			}
		}
		$this->view->assign ( 'sp_url', $sp_url );
		$this->view->assign('title' , '在庫情報');
		/*
		 replaced columns list
		 dbo.MjnetCarDataListSmart.[ｺｰﾄﾞ] as HanbaitenCode,
		 dbo.MjnetCarDataListSmart.[車名ｺｰﾄﾞ] as CarNameCode,
		 dbo.MjnetCarDataListSmart.[排気量] As Displacement,
		 dbo.MjnetCarDataListSmart.[ｸﾞﾚｰﾄﾞ] as GradeName,
		 dbo.MjnetCarDataListSmart.[年式] as Nenshiki,
		 dbo.MjnetCarDataListSmart.[ﾐｯｼｮﾝ] as Mission,
		 dbo.MjnetCarDataListSmart.[ﾄﾞｱ] as Door,
		 dbo.MjnetCarDataListSmart.[ｶﾗｰ] as ColorName,
		 dbo.MjnetCarDataListSmart.[車検] as Inspection,
		 dbo.MjnetCarDataListSmart.[価格] as Price,
		 dbo.MjnetCarDataListSmart.[装備] as Soubi,
		 dbo.MjnetCarDataListSmart.[走行] as Mileage,
		 dbo.MjnetCarDataListSmart.[ｺﾒﾝﾄ] as Comment,
		 dbo.MjnetCarDataListSmart.[登録日] as DataRegistrationDate,
		 dbo.MjnetCarDataListSmart.[年] as ModelYear,
		 dbo.MjnetCarDataListSmart.[4WDFlag] as IsFourWheelDrive,
		 dbo.MjnetCarDataListSmart.[装備Text] As SoubiText,
		 dbo.MjnetCarDataListSmart.[燃料ID] as FuelCode,
		 dbo.MjnetCarDataListSmart.[色系統] as ColorClassCode,
		 dbo.MjnetCarDataListSmart.[整備付] as IsMaintenance,
		 dbo.MjnetCarDataListSmart.[保証flag] as IsGuarantee,
		 dbo.MjnetCarDataListSmart.[保証内容] as GuaranteeText,
		 dbo.MjnetCarDataListSmart.[写真ﾌｧｲﾙ名] ImageFileName,
		 dbo.MjnetCarDataListSmart.[販売店名] as HanbaitenName,
		 dbo.MjnetCarDataListSmart.[電話番号] as HanbaitenTel,
		 dbo.MjnetCarDataListSmart.[Sﾃﾞｰﾀｆｌａｇ1] as sDataFlag1,
		 dbo.MjnetCarDataListSmart.[税抜価格] as TaxExcludePrice,
		 dbo.MjnetCarDataListSmart.[非課税flag] as IsTaxFree,
		 dbo.MjnetCarDataListSmart.[車体番号] as CarBodyNo,
		 dbo.MjnetCarDataListSmart.[評価点] as AisPoint,
		 */
		$limit=10;
		$is_pager=true;
		unset($Vie_MjnetCarDataListSmartJoinBukkenState);
		$Vie_MjnetCarDataListSmartJoinBukkenState = new Apis_Vie_MjnetCarDataListSmartJoinBukkenState($this->_conn);
		$om = $Vie_MjnetCarDataListSmartJoinBukkenState->select();

		// グループ店での絞り込み
		if(isset($_r['GroupCD']) && $_r['GroupCD'] != ""){
			// '----店名による抽出条件-----------------------------
			if(isset($_r[RequestParam::REQ_DEALERSHIP_CODE]) && $_r[RequestParam::REQ_DEALERSHIP_CODE] != "")
			{
				$p_dealer_ship_code = array(
				Vie_MjnetCarDataListSmartJoinBukkenState::COL_HANBAITENCODE => $_r['GroupCD']
				);

				$om->setAndIn($p_dealer_ship_code);
			}

		}else{

			if(isset($_r[RequestParam::REQ_DEALERSHIP_CODE]) && $_r[RequestParam::REQ_DEALERSHIP_CODE] != "")
			{
				$p_dealer_ship_code = array(
				Vie_MjnetCarDataListSmartJoinBukkenState::COL_HANBAITENCODE => $_r[RequestParam::REQ_DEALERSHIP_CODE]
				);

				$om->setAndIn($p_dealer_ship_code);
			}

		}

		// '-- パーツは表示させない --
		$p_not_parts = array(
		Vie_MjnetCarDataListSmartJoinBukkenState::COL_CARNAMECODE => '9800',
		);

		$om->setAndLessThan($p_not_parts);
		
		$p_is_sold = array(
		Vie_MjnetCarDataListSmartJoinBukkenState::COL_OTHERPRICE => 99999,
		);
		
		// オススメ車のカウント
		$osusume_count_flag = array(
		Vie_MjnetCarDataListSmartJoinBukkenState::COL_OSUSUMEFLAG => 1,
		);
		$OsusumeCount = $om->setAndIn($osusume_count_flag)->setAndNotIn($p_is_sold)->getCount();
		$this->view->assign('OsusumeCount' , $OsusumeCount);
		unset($om);

		// 最新中古車のカウント
		$om = $Vie_MjnetCarDataListSmartJoinBukkenState->select()->setAndIn($p_dealer_ship_code)->setAndLessThan($p_not_parts);
		$a_week_ago = date('Y-m-d', strtotime('-1 week'));
		$p_old_count = array(
		Vie_MjnetCarDataListSmartJoinBukkenState::COL_DATAREGISTRATIONDATE => $a_week_ago,
		);
		$OldCount = $om->setAndGreaterThan($p_old_count)->setAndNotIn($p_is_sold)->getCount();
		$this->view->assign('OldCount' , $OldCount);
		unset($om);

		// 売約済みカウント
		$om = $Vie_MjnetCarDataListSmartJoinBukkenState->select()->setAndIn($p_dealer_ship_code)->setAndLessThan($p_not_parts);
		$SoldCount = $om->setAndIn($p_is_sold)->getCount();
		$this->view->assign('SoldCount' , $SoldCount);
		unset($om);
		
		$om = $Vie_MjnetCarDataListSmartJoinBukkenState->select()->setAndIn($p_dealer_ship_code);

		// '----車名による抽出条件-----------------------------
		if(isset($_r[RequestParam::REQ_CAR_NAME_CODE]) && $_r[RequestParam::REQ_CAR_NAME_CODE] != "")
		{
			$p_car_name_code = array(
			Vie_MjnetCarDataListSmartJoinBukkenState::COL_CARNAMECODE => $_r[RequestParam::REQ_CAR_NAME_CODE]
			);

			$om->setAndIn($p_car_name_code);
			
			// title(SEO対策) 車名取得
			$Vie_CarNameMaster = new Apis_Vie_CarNameMaster($this->_conn);
			$vcnmo = $Vie_CarNameMaster->findOne($p_car_name_code);
			$this->view->assign('title' , $vcnmo->{Vie_CarNameMaster::COL_CARNAME});
		}
		// '----メーカーIDによる抽出条件------------------------
		if(isset($_r[RequestParam::REQ_MAKER_CODE]) && $_r[RequestParam::REQ_MAKER_CODE] != "")
		{
			$p_maker_code = array(
			Vie_MjnetCarDataListSmartJoinBukkenState::COL_MAKERCODE => $_r[RequestParam::REQ_MAKER_CODE]
			);

			$om->setAndIn($p_maker_code);
		}
		// '----オススメ車、最新中古車による抽出条件----------------
		if($_r['Aproved'] == '1')
		{
			$p_osusume_flag = array(
			Vie_MjnetCarDataListSmartJoinBukkenState::COL_OSUSUMEFLAG => 1,
			);

			$om->setAndIn($p_osusume_flag);
			$this->view->assign('title' , 'オススメ物件');
		}else if($_r['Aproved'] == '2'){
			$a_week_ago = date('Y-m-d', strtotime('-1 week'));
			$p_a_week_ago = array(
			Vie_MjnetCarDataListSmartJoinBukkenState::COL_DATAREGISTRATIONDATE => $a_week_ago,
			);

			$om->setAndGreaterThan($p_a_week_ago);
			$this->view->assign('title' , '新着中古車');
		}
		
		if($_r['IsSold'] == '1'){
			$om->setAndIn($p_is_sold);
		}else{
			$om->setAndNotIn($p_is_sold);
		}
		
		if($_r[RequestParam::REQ_CAR_NAME_CODE] <= 9800)
		{
			$om->setAndLessThan($p_not_parts);
		}
		
		//**********ソート順***********************
		$ord  = $this->getRequest()->{RequestParam::REQ_ORDER};
		$sort = $this->getRequest()->{RequestParam::REQ_SORT};


		if ($sort == "") $sort = Model::SORT_ORDER_DESC;
		$p_order = array($ord => $sort);


		if($ord == "")
		{
			if(isset($_r['Aproved']) && $_r['Aproved'] != ""){
				$p_order = array(
				Vie_MjnetCarDataListSmartJoinBukkenState::COL_ID => Model::SORT_ORDER_ASC,
				);
			}else{
				$p_order = array(
				Vie_MjnetCarDataListSmartJoinBukkenState::COL_CARNAME => Model::SORT_ORDER_ASC,
				Vie_MjnetCarDataListSmartJoinBukkenState::COL_MODELYEAR => Model::SORT_ORDER_DESC,
				Vie_MjnetCarDataListSmartJoinBukkenState::COL_PRICE => Model::SORT_ORDER_DESC,
				);
			}
		}

		$om->setOrder($p_order);



		//ページャ及びリスト取得
		$p = new PagerLocal($_r);
		$p->setLimit($limit);
		$p->page = $req->page;

		$all = range(0, $p->total_num);
		$p->total_num = $om->getCount();
		//			var_dump($om->setLimit($p->limit, $p->offset)->getSql());
		$lists = $om->setLimit($p->limit, $p->offset)->fetchAll();
		$p->init($lists);

		if($is_pager){
			///ページャ	
			$req = $this->getRequest();
			$moduleName = $req->getModuleName();
			$actionName = $req->getActionName();
			$controllerName = $req->getControllerName();

			foreach($req->getParams() as $key => $val)
			{
				if(is_array($val)){
					$urlparam[$key] = array();
					foreach($val as $value) $urlparam[$key][] = $value;
				}else{
					if($val == "")
					{
						unset($urlparam[$key]);
					}else{
						$urlparam[$key] = $val;
					}
				}
			}
			unset($urlparam['module']);
			unset($urlparam['controller']);
			unset($urlparam['action']);
			$urlparam_sort = $urlparam;

			unset($urlparam_sort['module']);
			unset($urlparam_sort['page']);
			unset($urlparam_sort['sort']);
			unset($urlparam_sort['ord']);
			$orderLink = str_replace('=','/',http_build_query($urlparam_sort,'','/'));


			$params = array(
		    'itemData' => $all,
		    'perPage' => $p->limit,
		    'append' => true,
			'separator' => ' ',
		    'clearIfVoid' => false,
		    'urlVar' => 'page',
		    'useSessions' => true,
		    'closeSession' => true,
		    'mode' => 'Jumping',
			'path' => '/' . $moduleName . '/'.$controllerName .'/'. $actionName,
			'fixFileName' => "",
			'fileName' => "",
			'currentPage' => $req->page,
			'extraVars' => $urlparam,
			);

			$pager = & Pager::factory($params);
			$links = $pager->getLinks();
			$_b = array('?','=','&amp;','a href/','" title/');
			$_a = array('','/','/','a href=','/" title=',);

			$_links = str_replace($_b ,$_a,$links);

			foreach($_links as $key => $link)
			{
				//配列の要素全部回すと重いので・・・とりあえずallしか参照してない。
				if($key == 'all')
				{
					$links[$key] = ereg_replace("%5B([0-9]{1,2})%5D", "", $link);
				}
			}

			$this->view->assign('pager', $pager);
			$this->view->assign('links', $links);
		}




		$this->view->assign('p', $p);
		$this->view->assign('ord', $ord);
		$this->view->assign('sort', $sort);
		$this->view->assign('orderLink', $orderLink);



		// データ整形
		foreach($lists as $vmcdlswp)
		{
			$vmcdlswp = $this->_lfDataFormatForCarShopStockList($vmcdlswp);
		}
		$this->view->assign('Vie_MjnetCarDataListSmartWithPager' , $lists);

		// カテゴリー用メーカー名、車名取得
		$car_order = array(
		Vie_MjnetCarDataListSmartJoinBukkenState::COL_CARNAME => Model::SORT_ORDER_ASC,
		);
		$Vie_MjnetCarDataListSmartJoinBukkenState = new Apis_Vie_MjnetCarDataListSmartJoinBukkenState($this->_conn);
		$MjnetCarDataList = $Vie_MjnetCarDataListSmartJoinBukkenState->select()->setAndIn($p_dealer_ship_code)->setAndNotIn($p_is_sold)->setOrder($car_order)->fetchAll();
//		$listCount = count($MjnetCarDataList);
//		$this->view->assign('listCount' , $listCount);
		foreach($MjnetCarDataList as $one){
			$MakerCode[] = $one->{Vie_MjnetCarDataListSmartJoinBukkenState::COL_MAKERCODE};
			$CarNameCode[] = $one->{Vie_MjnetCarDataListSmartJoinBukkenState::COL_CARNAMECODE};
			if($one->{Vie_MjnetCarDataListSmartJoinBukkenState::COL_CARNAMECODE} <= 9800 ) $listCount += 1;
		}
		$this->view->assign('listCount' , $listCount);
		$MakerCodeCount = array_count_values($MakerCode);
		$MakerCodeList = array_keys($MakerCodeCount);
		asort($MakerCodeList);

		$CarName = array_unique($CarName->carname);
		$CarName = array_values($CarName);
		$CarNameCodeCount = array_count_values($CarNameCode);
		$CarNameCodeList = array_keys($CarNameCodeCount);
		$CarNameCodeCount = array_values($CarNameCodeCount);

		$count = count($CarNameCodeCount);
		for($i = 0; $i < $count; $i++){
			$CarCountList[] = array(
			Vie_MjnetCarDataListSmart::COL_CARNAMECODE => $CarNameCodeList[$i],
			"Cnt" => $CarNameCodeCount[$i],
			);
		}

		$Vie_MakerMaster = new Apis_Vie_MakerMaster($this->_conn);
		$vmmOrd = array(
//		Vie_MakerMaster::COL_MAKERCODE => Model::SORT_ORDER_ASC,
		Vie_MakerMaster::COL_SORT => Model::SORT_ORDER_ASC,
		);
		$Vie_MakerMasterList = $Vie_MakerMaster->select()->setAnd()->setOrder($vmmOrd)->fetchAll();
		foreach($Vie_MakerMasterList as $Vie_MakerMasterOne){
			foreach($MakerCodeList as $MakerCodeOne){
				if($Vie_MakerMasterOne->{MakerMaster::COL_MAKERCODE} == $MakerCodeOne){
					$MakerNameList[] = array(
					Vie_MakerMaster::COL_MAKERNAME => $Vie_MakerMasterOne->{Vie_MakerMaster::COL_MAKERNAME},
					Vie_MakerMaster::COL_MAKERCODE => $Vie_MakerMasterOne->{Vie_MakerMaster::COL_MAKERCODE},
					);
					break;
				}
			}
		}
		$this->view->assign('MakerNameList' , $MakerNameList);

		$Vie_CarNameMaster = new Apis_Vie_CarNameMaster($this->_conn);
		$vcnmOrd = array(
		Vie_CarNameMaster::COL_CARNAME => Model::SORT_ORDER_ASC,
		);
		$Vie_CarNameMasterList = $Vie_CarNameMaster->select()->setAnd()->setOrder($vcnmOrd)->fetchAll();

		foreach($Vie_CarNameMasterList as $Vie_CarNameMasterOne){
			foreach($CarCountList as $CarCountOne){
				if($Vie_CarNameMasterOne->{Vie_CarNameMaster::COL_CARNAMECODE} == $CarCountOne[Vie_MjnetCarDataListSmartJoinBukkenState::COL_CARNAMECODE]){
					$CarNameList[] = array(
					Vie_CarNameMaster::COL_CARNAMECODE => $Vie_CarNameMasterOne->{Vie_MjnetCarDataListSmartJoinBukkenState::COL_CARNAMECODE},
					Vie_CarNameMaster::COL_CARNAME => $Vie_CarNameMasterOne->{Vie_MjnetCarDataListSmartJoinBukkenState::COL_CARNAME},
					Vie_CarNameMaster::COL_MAKERCODE => $Vie_CarNameMasterOne->{Vie_MjnetCarDataListSmartJoinBukkenState::COL_MAKERCODE},
					'Count' => $CarCountOne['Cnt'],
					);
					break;
				}
			}
		}
		$this->view->assign('CarNameList' , $CarNameList);

		// グループ店
		$Vie_Groupdealer = new Apis_Vie_Groupdealer($this->_conn);
		$subParam = array(
		Vie_Groupdealer::COL_DEALERSHIPCD => $_r[RequestParam::REQ_DEALERSHIP_CODE],
		);
		$Vie_GroupdealerOne = $Vie_Groupdealer->findOne($subParam);
		if($Vie_GroupdealerOne){
			$mainParam = array(
			Vie_Groupdealer::COL_MAINDEALERID => $Vie_GroupdealerOne->{Vie_GroupDealer::COL_MAINDEALERID},
			);
			$vgdOrd = array(
			Vie_GroupDealer::COL_SORT => Model::SORT_ORDER_ASC,
			);
			$Vie_GroupdealerList = $Vie_Groupdealer->select()->setAnd($mainParam)->setOrder($vgdOrd)->fetchAll();
			$this->view->assign('Vie_GroupdealerList' , $Vie_GroupdealerList);
		}
		$this->LogInsert(2);
	}

	/**
	 * 物件詳細
	 *
	 */
	public function carDetailAction(){

		$req = $this->getRequest();
		$_r = $req->getParams();
		// 画像サイズ
		// origin 640 x 480
		// preview 160 x 120
		// preview_s 80 x 60

		$limit=1;
		$is_pager=true;

		$Vie_MjnetCaDataListSmart = new Apis_Vie_MjnetCarDataListSmart($this->_conn);
		$om = $Vie_MjnetCaDataListSmart->select();

		if(isset($_r[RequestParam::REQ_DEALERSHIP_CODE]) && $_r[RequestParam::REQ_DEALERSHIP_CODE] != "")
		{
			$p_dealer_ship_code = array(
			Vie_MjnetCarDataListSmart::COL_HANBAITENCODE => $_r[RequestParam::REQ_DEALERSHIP_CODE]
			);

			$om->setAndIn($p_dealer_ship_code);
		}

		if(isset($_r[RequestParam::REQ_ID]) && $_r[RequestParam::REQ_ID] != "")
		{
			$p_id = array(
			Vie_MjnetCarDataListSmart::COL_ID => $_r[RequestParam::REQ_ID]
			);

			$om->setAndIn($p_id);
		}

		//**********ソート順***********************
		$ord  = $this->getRequest()->{RequestParam::REQ_ORDER};
		$sort = $this->getRequest()->{RequestParam::REQ_SORT};

		if ($ord  == "") $ord  = Vie_MjnetCarDataListSmart::COL_DATAREGISTRATIONDATE;
		if ($sort == "") $sort = Model::SORT_ORDER_DESC;

		$p_order = array($ord => $sort);
		$om->setOrder($p_order);

		//ページャ及びリスト取得
		$p = new PagerLocal($_r);
		$p->setLimit($limit);
		$p->page = $req->page;

		$all = range(0, $p->total_num);
		$p->total_num = $om->getCount();

		$lists = $om->setLimit($p->limit, $p->offset)->fetchAll();
		$p->init($lists);

		if($is_pager){
			///ページャ	
			$req = $this->getRequest();
			$moduleName = $req->getModuleName();
			$actionName = $req->getActionName();
			$controllerName = $req->getControllerName();

			foreach($req->getParams() as $key => $val)
			{
				if(is_array($val)){
					$urlparam[$key] = array();
					foreach($val as $value) $urlparam[$key][] = $value;
				}else{
					if($val == "")
					{
						unset($urlparam[$key]);
					}else{
						$urlparam[$key] = $val;
					}
				}
			}
			unset($urlparam['module']);
			unset($urlparam['controller']);
			unset($urlparam['action']);
			$urlparam_sort = $urlparam;

			unset($urlparam_sort['module']);
			unset($urlparam_sort['page']);
			unset($urlparam_sort['sort']);
			unset($urlparam_sort['ord']);
			$orderLink = str_replace('=','/',http_build_query($urlparam_sort,'','/'));


			$params = array(
		    'itemData' => $all,
		    'perPage' => $p->limit,
		    'append' => true,
			'separator' => ' ',
		    'clearIfVoid' => false,
		    'urlVar' => 'page',
		    'useSessions' => true,
		    'closeSession' => true,
		    'mode' => 'Jumping',
			'path' => '/' . $moduleName . '/'.$controllerName .'/'. $actionName,
			'fixFileName' => "",
			'fileName' => "",
			'currentPage' => $req->page,
			'extraVars' => $urlparam,
			);

			$pager = & Pager::factory($params);
			$links = $pager->getLinks();
			$_b = array('?','=','&amp;','a href/','" title/');
			$_a = array('','/','/','a href=','/" title=',);

			$_links = str_replace($_b ,$_a,$links);

			foreach($_links as $key => $link)
			{
				//配列の要素全部回すと重いので・・・とりあえずallしか参照してない。
				if($key == 'all')
				{
					$links[$key] = ereg_replace("%5B([0-9]{1,2})%5D", "", $link);
				}
			}

			$this->view->assign('pager', $pager);
			$this->view->assign('links', $links);
		}

		// データ整形
		foreach($lists as $vmcdlswp)
		{
			$vmcdlswp_org = clone $vmcdlswp;
			$vmcdlswp = $this->_lfDataFormatForCarShopStockList($vmcdlswp);
			$vmcdlswp->NENSIKI_PH1 = str_replace("<br />", "", $vmcdlswp->NENSIKI_PH1);
			$vmcdlswp->CarNo3 = substr($vmcdlswp->{Vie_MjnetCarDataListSmart::COL_CARBODYNO}, -3);
			$vmcdlswp->{Vie_MjnetCarDataListSmart::COL_AISPOINT} = $vmcdlswp->{Vie_MjnetCarDataListSmart::COL_AISPOINT}/10;

			$rand = rand(1,3);
			if($this->_pnSystemGlobalCD == 0){
				if($vmcdlswp->{Vie_MjnetCarDataListSmart::COL_AREANUM} == 1){
					if($rand == 1){
						$vmcdlswp->hougen = "はよせんと、売れるけんなー";
					}else if($rand == 2){
						$vmcdlswp->hougen = "これめっちゃおすすめやけん！";
					}else if($rand == 3){
						$vmcdlswp->hougen = "メールまっとるけん！";
					}
				}else if($vmcdlswp->{Vie_MjnetCarDataListSmart::COL_AREANUM} == 2){
					if($rand == 1){
						$vmcdlswp->hougen = "ほんだら問合せてんまい！";
					}else if($rand == 2){
						$vmcdlswp->hougen = "しゃんしゃん問合せないかんで！";
					}else if($rand == 3){
						$vmcdlswp->hougen = "なんしょんな、売れてしまうで！";
					}
				}else if($vmcdlswp->{Vie_MjnetCarDataListSmart::COL_AREANUM} == 3){
					if($rand == 1){
						$vmcdlswp->hougen = "メールまっちゅうきねー";
					}else if($rand == 2){
						$vmcdlswp->hougen = "売れるき、はよきいやー";
					}else if($rand == 3){
						$vmcdlswp->hougen = "これ、おすすめやきね！";
					}
				}else if($vmcdlswp->{Vie_MjnetCarDataListSmart::COL_AREANUM} == 4){
					if($rand == 1){
						$vmcdlswp->hougen = "メールせなそんそん！";
					}else if($rand == 2){
						$vmcdlswp->hougen = "ええくるま、あるでないで！";
					}else if($rand == 3){
						$vmcdlswp->hougen = "はよせな、うれるじぇ〜";
					}
				}else{
					if($rand == 1){
						$vmcdlswp->hougen = "はよせんと、売れるけんなー";
					}else if($rand == 2){
						$vmcdlswp->hougen = "これめっちゃおすすめやけん！";
					}else if($rand == 3){
						$vmcdlswp->hougen = "メールまっとるけん！";
					}
				}
			}else{
				if($rand == 1){
					$vmcdlswp->hougen = "お問い合わせお待ちしております！";
				}else if($rand == 2){
					$vmcdlswp->hougen = "お気軽にお問い合わせください！";
				}else if($rand == 3){
					$vmcdlswp->hougen = "メールお待ちしております！";
				}
			}
			
			// AIS
			$Vie_Ais = new Apis_Vie_Ais($this->_conn);
			$vaParam = array(
			Vie_AIS::COL_ID => $vmcdlswp->{Vie_MjnetCarDataListSmart::COL_ID},
			);
			$Vie_AisOne = $Vie_Ais->findOne($vaParam);
			if($Vie_AisOne->{Vie_AIS::COL_AISPOINT} == "R"){
				$Vie_AisOne->image = "R";
			}else if($Vie_AisOne->{Vie_AIS::COL_AISPOINT} == "1"){
				$Vie_AisOne->image = "1";
			}else if($Vie_AisOne->{Vie_AIS::COL_AISPOINT} == "2"){
				$Vie_AisOne->image = "2";
			}else if($Vie_AisOne->{Vie_AIS::COL_AISPOINT} == "3"){
				$Vie_AisOne->image = "3";
			}else if($Vie_AisOne->{Vie_AIS::COL_AISPOINT} == "35"){
				$Vie_AisOne->image = "3h";
				$Vie_AisOne->{Vie_AIS::COL_AISPOINT} = "3.5";
			}else if($Vie_AisOne->{Vie_AIS::COL_AISPOINT} == "4"){
				$Vie_AisOne->image = "4";
			}else if($Vie_AisOne->{Vie_AIS::COL_AISPOINT} == "45"){
				$Vie_AisOne->image = "4h";
				$Vie_AisOne->{Vie_AIS::COL_AISPOINT} = "4.5";
			}else if($Vie_AisOne->{Vie_AIS::COL_AISPOINT} == "5"){
				$Vie_AisOne->image = "5";
			}else if($Vie_AisOne->{Vie_AIS::COL_AISPOINT} == "6"){
				$Vie_AisOne->image = "6";
			}else if($Vie_AisOne->{Vie_AIS::COL_AISPOINT} == "S"){
				$Vie_AisOne->image = "S";
			}
			$vmcdlswp->Vie_AisOne = $Vie_AisOne;
			
//			if(isset($Vie_AisOne) && $Vie_AisOne != ""){
//				$Vie_AIS_Log = new Vie_AIS_Log($this->_conn);
//				$AISdata = array(
//				Vie_AIS_Log::COL_BUKKENID => $Vie_AisOne->{Vie_AIS::COL_ID},
//				Vie_AIS_Log::COL_AISID => $Vie_AisOne->{Vie_AIS::COL_INQUIRYNO},
//				Vie_AIS_Log::COL_AISPOINT => $Vie_AisOne->{Vie_AIS::COL_AISPOINT},
//				Vie_AIS_Log::COL_CDATE => $Vie_AIS_Log->getDay(),
//				);
//				$Vie_AIS_Log->insertFromPostRequest($AISdata);
//			}

			$Detaillog = new Detaillog($this->_conn);
			if($this->_member->{Mjnet_Member::COL_ID} == null) $this->_member->{Mjnet_Member::COL_ID} = 0;
//			if(isset($_r['fromstate']) && $_r['fromstate'] != ""){
//				$fromstate = $_r['fromstate'];
//			}else{
//				$fromstate = 0;
//			}
//			if($vmcdlswp->{Vie_MjnetCarDataListSmart::COL_STATE} == 1) $fromstate = 3;
//			if($_r['g'] == 1) $fromstate = 9;
			
			//IndividualDataからpsuid 取得
			//memberidがあってpsuidが取れない場合はIndividualDataにインサート
			if(isset($this->_authIdentity->{Mjnet_Member::TBL_NAME}->{Mjnet_Member::COL_ID}))
			{
				$p_member = array(
					IndividualData::COL_MJNETMEMBERID => $this->_member->{Mjnet_Member::COL_ID}
				);
				$IndividualData = new Apis_IndividualData($this->_conn);
				$IndividualData2 = new IndividualData($this->_conn);
				$IndividualDataOne = $IndividualData->findOne($p_member);
				if(isset($IndividualDataOne->{IndividualData::COL_UID}))
				{
					$psuid = $IndividualDataOne->{IndividualData::COL_UID};
					
					$in_data = array(
							IndividualData::COL_MDATE => $IndividualData->getDay(),
					);
					$IndividualData2->updateFromPostRequest($in_data,$p_member);
				}else{
 					$psuid = $_SERVER['REMOTE_ADDR'] . "_" . date('Y') . date('m') . date('d');
 					$in_data = array(
 						IndividualData::COL_MDATE => $IndividualData->getDay(),
						IndividualData::COL_CDATE => $IndividualData->getDay(),
 						IndividualData::COL_MJNETMEMBERID => $this->_member->{Mjnet_Member::COL_ID},
 						IndividualData::COL_LASTACCESSDAY => $IndividualData->getDay(),
 						IndividualData::COL_UID => $psuid,
 					);
 					$IndividualData2->insertFromPostRequest($in_data);
				}
			}else{
				$psuid = $_SERVER['REMOTE_ADDR'] . "_" . date('Y') . date('m') . date('d');
				$p_member = array(
						IndividualData::COL_UID => $psuid
				);
				$IndividualData = new Apis_IndividualData($this->_conn);
				$IndividualData2 = new IndividualData($this->_conn);
				$IndividualDataOne = $IndividualData->findOne($p_member);
				if(isset($IndividualDataOne->{IndividualData::COL_UID}))
				{
					$psuid = $IndividualDataOne->{IndividualData::COL_UID};
//					$IndividualData->updateFromPostRequest($in_data,$p_member);
					$in_data = array(
							IndividualData::COL_MDATE => $IndividualData->getDay(),
					);
					$IndividualData2->updateFromPostRequest($in_data,$p_member);
				}else{
					$in_data = array(
							IndividualData::COL_MDATE => $IndividualData->getDay(),
							IndividualData::COL_CDATE => $IndividualData->getDay(),
							IndividualData::COL_MJNETMEMBERID => "",
							IndividualData::COL_LASTACCESSDAY => $IndividualData->getDay(),
							IndividualData::COL_UID => $psuid,
					);
					$IndividualData2->insertFromPostRequest($in_data);	
				}			
			}
			
			$Dataildata = array(
			Detaillog::COL_CDATE => $Detaillog->getDay(),
			Detaillog::COL_BUKKENID => $vmcdlswp->{Vie_MjnetCarDataListSmart::COL_ID},
			Detaillog::COL_DEALERID => $vmcdlswp->{Vie_MjnetCarDataListSmart::COL_HANBAITENCODE},
			Detaillog::COL_SYAMEIID => $vmcdlswp->{Vie_MjnetCarDataListSmart::COL_CARNAMECODE},
			Detaillog::COL_HAIKI => $vmcdlswp->{Vie_MjnetCarDataListSmart::COL_DISPLACEMENT},
			Detaillog::COL_GRADE => $vmcdlswp->{Vie_MjnetCarDataListSmart::COL_GRADENAME},
			Detaillog::COL_NENSIKI => $vmcdlswp->{Vie_MjnetCarDataListSmart::COL_NENSHIKI},
			Detaillog::COL_NEN => $vmcdlswp->{Vie_MjnetCarDataListSmart::COL_MODELYEAR},
			Detaillog::COL_MISSION => $vmcdlswp->{Vie_MjnetCarDataListSmart::COL_MISSION},
			Detaillog::COL_DOOR => $vmcdlswp->{Vie_MjnetCarDataListSmart::COL_DOOR},
			Detaillog::COL_COLOR => $vmcdlswp->{Vie_MjnetCarDataListSmart::COL_COLORNAME},
			Detaillog::COL_SYAKEN => $vmcdlswp->{Vie_MjnetCarDataListSmart::COL_INSPECTION},
//			Detaillog::COL_PRICE => $vmcdlswp->{Vie_MjnetCarDataListSmart::COL_PRICE}.'.0000',
			Detaillog::COL_PRICE => $vmcdlswp_org->{Vie_MjnetCarDataListSmart::COL_PRICE},
			Detaillog::COL_SOUBI => $vmcdlswp->{Vie_MjnetCarDataListSmart::COL_SOUBI},
			Detaillog::COL_SOUKOU => $vmcdlswp->{Vie_MjnetCarDataListSmart::COL_MILEAGE},
			Detaillog::COL_RESTORATIONFLAG => $vmcdlswp->{Vie_MjnetCarDataListSmart::COL_RESTORATIONFLAG},
			Detaillog::COL_MODE => 0,
			Detaillog::COL_UID => $psuid,
			Detaillog::COL_TOUROKUDAY =>  $vmcdlswp->{Vie_MjnetCarDataListSmart::COL_DATAREGISTRATIONDATE},
			Detaillog::COL_MJNETMEMBERID => $this->_authIdentity->{Mjnet_Member::TBL_NAME}->{Mjnet_Member::COL_ID},
			Detaillog::COL_FROMSTATE => 1,
			Detaillog::COL_UTM => $_COOKIE['__utma']//Request.Cookies("__utma")
			);
			// botはログいらない
			if($this->_IsNeedLog()) $Detaillog->insertFromPostRequest($Dataildata);
			
			
			$DealershipMaster = new Apis_Vie_DealershipMaster($this->_conn);
			$dmParam = array(
			DealershipMaster::COL_DEALERSHIPCD => $vmcdlswp->{Vie_MjnetCarDataListSmart::COL_HANBAITENCODE},
			);

			$vmcdlswp->DealershipMasterOne = $DealershipMaster->findOne($dmParam);
			
			// Bizフラグ
			$Itp_NdAcl = new Apis_Itp_NdAcl($this->_conn);
			if($this->_pnSystemGlobalCD == 0){
				$inaParam = array(
				Itp_NdAcl::COL_DEALERSHIPCD => $vmcdlswp->{Vie_MjnetCarDataListSmart::COL_HANBAITENCODE},
				);
			}else{
				$inaParam = array(
				Itp_NdAcl::COL_DEALERSHIPCD => substr_replace($vmcdlswp->{Vie_MjnetCarDataListSmart::COL_HANBAITENCODE},'N',0,1),
				);
			}

			$vmcdlswp->Itp_NdAclOne = $Itp_NdAcl->findOne($inaParam);
			// 店情報
			$Itp_NdSalesPoint = new Apis_Itp_NdSalesPoint($this->_conn);
			if($this->_pnSystemGlobalCD == 0){
				$inspParam = array(
				Itp_NdSalesPoint::COL_DEALERSHIPCD => $vmcdlswp->{Vie_MjnetCarDataListSmart::COL_HANBAITENCODE},
				);
			}else{
				$inspParam = array(
				Itp_NdSalesPoint::COL_DEALERSHIPCD => substr_replace($vmcdlswp->{Vie_MjnetCarDataListSmart::COL_HANBAITENCODE},'N',0,1),
				);
			}
			$vmcdlswp->Itp_NdSalesPointOne = $Itp_NdSalesPoint->findOne($inspParam);
			// juフラグ
			$Vie_HanbaitenMaster = new Apis_Vie_HanbaitenMaster($this->_conn);
			$vhmParam = array(
			Vie_HanbaitenMaster::COL_DEALERSHIPCD => $vmcdlswp->{Vie_MjnetCarDataListSmart::COL_HANBAITENCODE},
			);
			
			$vmcdlswp->Vie_HanbaitenMasterOne = $Vie_HanbaitenMaster->findOne($vhmParam);
			
			// カタログ
			$AIC_HOYU_CATALOG_CARNAME_CONVERT = new Apis_AIC_HOYU_CATALOG_CARNAME_CONVERT($this->_conn);
			$ahcccParam = array(
			AIC_HOYU_CATALOG_CARNAME_CONVERT::COL_CAR_CD => $vmcdlswp->{Vie_MjnetCarDataListSmart::COL_CARNAMECODE},
			);
			
			$vmcdlswp->AIC_HOYU_CATALOG_CARNAME_CONVERT_ONE = $AIC_HOYU_CATALOG_CARNAME_CONVERT->findOne($ahcccParam);
			
		}

		
		$this->view->assign('p', $p);
		$this->view->assign('ord', $ord);
		$this->view->assign('sort', $sort);
		$this->view->assign('orderLink', $orderLink);
		$this->view->assign('vmcdlswp' , $lists[0]);



		// MorePhotoFlag
		$Vie_Itp_Nd = new Apis_Vie_Itp_Nd($this->_conn);
		$vinParam = array(
		Vie_Itp_Nd::COL_DEALERSHIPCD => $lists[0]->{Vie_MjnetCarDataListSmart::COL_HANBAITENCODE},
		);
		
		$Vie_Itp_NdOne = $Vie_Itp_Nd->findOne($vinParam);
		
		// フォトデータ
		$Vie_PhotoFileData = new Apis_Vie_PhotoFileData($this->_conn);
		$vpfdParam = array(
		Vie_PhotoFileData::COL_DEALERSHIPCD => $_r[RequestParam::REQ_DEALERSHIP_CODE],
		Vie_PhotoFileData::COL_ID => $_r[RequestParam::REQ_ID],
		);
		$vpfdOrd = array(
		Vie_PhotoFileData::COL_PHOTONUMBER => Model::SORT_ORDER_ASC,
		);
		$Count = $Vie_PhotoFileData->select()->setAnd($vpfdParam)->getCount();
		if($Vie_Itp_NdOne->{Vie_Itp_Nd::COL_MOREPHOTOFLAG} == 1){
			$Vie_PhotoFileDataList = $Vie_PhotoFileData->select()->setAnd($vpfdParam)->setOrder($vpfdOrd)->fetchAll();
		}else if($Vie_Itp_NdOne->{Vie_Itp_Nd::COL_MOREPHOTOFLAG} == 0 && $lists[0]->{Vie_MjnetCarDataListSmart::COL_CSONLYFLAG} == 1){
			$Vie_PhotoFileDataList = $Vie_PhotoFileData->select()->setAnd($vpfdParam)->setOrder($vpfdOrd)->setLimit(1)->fetchAll();
			if($Count > 1) $Count = 1;
		}else if($Vie_Itp_NdOne->{Vie_Itp_Nd::COL_MOREPHOTOFLAG} == 0 && $lists[0]->{Vie_MjnetCarDataListSmart::COL_CSONLYFLAG} != 1){
			$Vie_PhotoFileDataList = $Vie_PhotoFileData->select()->setAnd($vpfdParam)->setOrder($vpfdOrd)->setLimit(3)->fetchAll();
			if($Count > 3) $Count = 3;
		}

		$this->view->assign('Vie_PhotoFileDataList' , $Vie_PhotoFileDataList);
		$this->view->assign('Vie_PhotoFileDataOne' , $Vie_PhotoFileDataList[0]);
		$this->view->assign('Count' , $Count);

		// YouTubeデータ取得
		$Otherdata = new Apis_Otherdata($this->_conn);
		$odParam = array(
		Otherdata::COL_ID => $_r[RequestParam::REQ_ID],
		);
		$OtherdataOne = $Otherdata->findOne($odParam);
		$this->view->assign('OtherdataOne' , $OtherdataOne);

		// 検討中リストにあるかチェック
		// TODO チェックが甘いです
		$mylist = $req->getCookie('ucarfavo');
		$fav = strstr($mylist,$_r[RequestParam::REQ_ID]);
		if($fav){
			$mylistflag = 1;
		}else{
			$mylistflag = 0;
		}
		$this->view->assign('mylistflag' , $mylistflag);
		
		// バンバン看板
		$Vie_Itp_NdContractData = new Apis_Vie_Itp_NdContractData($this->_conn);
		$p_contract = array(
		Vie_Itp_NdContractData::COL_CONTRACTMIDCD => 8,
		Vie_Itp_NdContractData::COL_DEALERSHIPCD => $_r[RequestParam::REQ_DEALERSHIP_CODE]
		);
		$Vie_Itp_NdContractDataOne = $Vie_Itp_NdContractData->findOne($p_contract);
		$this->view->assign('Vie_Itp_NdContractDataOne' , $Vie_Itp_NdContractDataOne);
		$title = $lists[0]->{Vie_MjnetCarDataListSmart::COL_MAKERNAME}.' '.$lists[0]->{Vie_MjnetCarDataListSmart::COL_CARNAME}.' '.$lists[0]->{Vie_MjnetCarDataListSmart::COL_GRADENAME}.' 中古車詳細';
		$this->view->assign('title' , $title);
		$this->view->assign('Keywords' , str_replace(" ",",",$title));
		
		// クーポン（くるまる）
		if($this->_pnSystemGlobalCD == 1){
			$Dealer_CouponData = new Apis_Vie_Dealer_CouponData($this->_conn);
			$p_coupon = array(
			Dealer_CouponData::COL_DEALERID => $_r[RequestParam::REQ_DEALERSHIP_CODE],
			Dealer_CouponData::COL_DEL_FLG => 0,
			);
			$couponOrd = array(
			Dealer_CouponData::COL_COUPONCD => Model::SORT_ORDER_ASC
			);
			$Dealer_CouponDataList = $Dealer_CouponData->select()->setAnd($p_coupon)->setOrder($couponOrd)->fetchAll();
			foreach($Dealer_CouponDataList as $Dealer_CouponDataOne){
				if(date('d') <= 24){
					$Dealer_CouponDataOne->CouponYear = date('Y');
					$Dealer_CouponDataOne->CouponMonth = date('n');
	
				}else{
					$Dealer_CouponDataOne->CouponYear = date('Y',strtotime('+1 month'));
					$Dealer_CouponDataOne->CouponMonth = date('n',strtotime('+1 month'));
				}
			}
			$this->view->assign('Dealer_CouponDataList' , $Dealer_CouponDataList);
		}
	}

	/**
	 * 店舗情報
	 *
	 */
	public function detailAction(){
		$req = $this->getRequest();
		$_r = $req->getParams();

		$DealerProfile = new Apis_DealerProfile($this->_conn);
		if($this->_pnSystemGlobalCD == 0){
			$dpParam = array(
			DealerProfile::COL_DEALERSHIPCD => $_r[RequestParam::REQ_DEALERSHIP_CODE],
			);
		}else{
			$dpParam = array(
			DealerProfile::COL_DEALERSHIPCD => substr_replace($_r[RequestParam::REQ_DEALERSHIP_CODE],'N',0,1),
			);
		}
		$DealerProfileOne = $DealerProfile->findOne($dpParam);
		$this->view->assign('DealerProfileOne', $DealerProfileOne);


		// グループ店
		$Vie_Groupdealer = new Apis_Vie_Groupdealer($this->_conn);
		$subParam = array(
		Vie_Groupdealer::COL_DEALERSHIPCD => $_r[RequestParam::REQ_DEALERSHIP_CODE],
		);
		$Vie_GroupdealerOne = $Vie_Groupdealer->findOne($subParam);
		if($Vie_GroupdealerOne){
			$mainParam = array(
			Vie_Groupdealer::COL_MAINDEALERID => $Vie_GroupdealerOne->{Vie_GroupDealer::COL_MAINDEALERID},
			);
			$vgdOrd = array(
			Vie_GroupDealer::COL_SORT => Model::SORT_ORDER_ASC,
			);
			$Vie_GroupdealerList = $Vie_Groupdealer->select()->setAnd($mainParam)->setOrder($vgdOrd)->fetchAll();
			foreach($Vie_GroupdealerList as $one){
				if($this->_pnSystemGlobalCD == 0){
					$one->imgdscd = $one->{Vie_Groupdealer::COL_DEALERSHIPCD};
				}else{
					$one->imgdscd = substr_replace($one->{Vie_Groupdealer::COL_DEALERSHIPCD},'N',0,1); 
				}
			}
			$this->view->assign('Vie_GroupdealerList' , $Vie_GroupdealerList);
		}

		// マップ
		if(isset($_r['Scale']) && $_r['Scale'] != ""){
			$Scale = $_r['Scale'];
		}else{
			$Scale = 12;
		}
		$this->view->assign('Scale', $Scale);
		$this->view->assign('title' , '店舗情報');
	}

	/**
	 * 保証・整備
	 *
	 */
	public function guaranteeAction(){
		$req = $this->getRequest();
		$_r = $req->getParams();
		$Vie_Itp_NdAppealJoinNdFileEntry = new Apis_Vie_Itp_NdAppealJoinNdFileEntry($this->_conn);
		$hParam = array(
		Vie_Itp_NdAppealJoinNdFileEntry::COL_DEALERSHIPCD => $_r[RequestParam::REQ_DEALERSHIP_CODE],
		Vie_Itp_NdAppealJoinNdFileEntry::COL_APPEALTYPE => 1,
		);
		$sParam = array(
		Vie_Itp_NdAppealJoinNdFileEntry::COL_DEALERSHIPCD => $_r[RequestParam::REQ_DEALERSHIP_CODE],
		Vie_Itp_NdAppealJoinNdFileEntry::COL_APPEALTYPE => 2,
		);
		$ord = array(
		Vie_Itp_NdAppealJoinNdFileEntry::COL_REGDATE => Model::SORT_ORDER_ASC,
		);

		$hosyou_List = $Vie_Itp_NdAppealJoinNdFileEntry->select()->setAnd($hParam)->setOrder($ord)->fetchAll();
		$seibi_List = $Vie_Itp_NdAppealJoinNdFileEntry->select()->setAnd($sParam)->setOrder($ord)->fetchAll();

		$this->view->assign('hosyou_List', $hosyou_List);
		$this->view->assign('seibi_List', $seibi_List);
		$this->view->assign('title' , '保障・整備');
	}

	/**
	 * スタッフ紹介
	 *
	 */
	public function staffAction(){
		$req = $this->getRequest();
		$_r = $req->getParams();
		$Vie_Itp_NdAppealJoinNdFileEntry = new Apis_Vie_Itp_NdAppealJoinNdFileEntry($this->_conn);
		$vinjnfeParam = array(
		Vie_Itp_NdAppealJoinNdFileEntry::COL_DEALERSHIPCD => $_r[RequestParam::REQ_DEALERSHIP_CODE],
		Vie_Itp_NdAppealJoinNdFileEntry::COL_APPEALTYPE => 3,
		);
		$ord = array(
		Vie_Itp_NdAppealJoinNdFileEntry::COL_REGDATE => Model::SORT_ORDER_ASC,
		);

		$Vie_Itp_NdAppeal_List = $Vie_Itp_NdAppealJoinNdFileEntry->select()->setAnd($vinjnfeParam)->setOrder($ord)->fetchAll();

		$this->view->assign('Vie_Itp_NdAppeal_List', $Vie_Itp_NdAppeal_List);
		$this->view->assign('title' , 'スタッフ');
	}

	/**
	 * その他サービス
	 *
	 */
	public function serviceAction(){
		$req = $this->getRequest();
		$_r = $req->getParams();
		$Vie_Itp_NdAppealJoinNdFileEntry = new Apis_Vie_Itp_NdAppealJoinNdFileEntry($this->_conn);
		$vinjnfeParam = array(
		Vie_Itp_NdAppealJoinNdFileEntry::COL_DEALERSHIPCD => $_r[RequestParam::REQ_DEALERSHIP_CODE],
		Vie_Itp_NdAppealJoinNdFileEntry::COL_APPEALTYPE => 4,
		);
		$ord = array(
		Vie_Itp_NdAppealJoinNdFileEntry::COL_REGDATE => Model::SORT_ORDER_ASC,
		);

		$Vie_Itp_NdAppeal_List = $Vie_Itp_NdAppealJoinNdFileEntry->select()->setAnd($vinjnfeParam)->setOrder($ord)->fetchAll();

		$this->view->assign('Vie_Itp_NdAppeal_List', $Vie_Itp_NdAppeal_List);
		$this->view->assign('title' , 'その他サービス');
	}

	/**
	 * 買取査定
	 *
	 */
	public function buyAction(){
		$req = $this->getRequest();
		$_r = $req->getParams();
		$Vie_NetDealerKaitoriCase = new Apis_Vie_NetDealerKaitoriCase($this->_conn);
		$Vie_Kaitori_Shopcheef_Data = new Apis_Vie_Kaitori_Shopcheef_Data($this->_conn);
		$NetDealer = new Apis_NetDealer($this->_conn);
		$Vie_Kaitori_Reinforcement_Car = new Apis_Vie_Kaitori_Reinforcement_Car($this->_conn);
		$NetDealerInfo = new Apis_NetDealerInfo($this->_conn);

		$ndParam = array(
		NetDealer::COL_ID => $_r[RequestParam::REQ_DEALERSHIP_CODE],
		);
		$vksdParam = array(
		Vie_Kaitori_Shopcheef_Data::COL_DEALERID => $_r[RequestParam::REQ_DEALERSHIP_CODE],
		);
		$vklsParam = array(
		Vie_Kaitori_Reinforcement_Car::COL_DEALERID => $_r[RequestParam::REQ_DEALERSHIP_CODE],
		);
		$ndiParam = array(
		NetDealerInfo::COL_DEALERID => $_r[RequestParam::REQ_DEALERSHIP_CODE],
		NetDealerInfo::COL_DEL_FLG => 0,
		);

		$ord = array(
		Vie_NetDealerKaitoriCase::COL_CDATE => Model::SORT_ORDER_DESC,
		);
		$ndiOrd = array(
		NetDealerInfo::COL_CDATE => Model::SORT_ORDER_ASC,
		);

		$Vie_NetDealerKaitoriCaseList = $Vie_NetDealerKaitoriCase->select()->setAnd($vksdParam)->setOrder($ord)->setLimit(3)->fetchAll();
		foreach($Vie_NetDealerKaitoriCaseList as $one){
			$one->{Vie_NetDealerKaitoriCase::COL_PRICE} = number_format($one->{Vie_NetDealerKaitoriCase::COL_PRICE});
		}
		$NetDealerOne = $NetDealer->findOne($ndParam);
		$Vie_Kaitori_Shopcheef_Data_One = $Vie_Kaitori_Shopcheef_Data->findOne($vksdParam);
		$Vie_Kaitori_Reinforcement_Car_List = $Vie_Kaitori_Reinforcement_Car->select()->setAnd($vklsParam)->setOrder($ord)->fetchAll();
		$NetDealerInfoOne = $NetDealerInfo->select()->setAnd($ndiParam)->setOrder($ndiOrd)->fetch();

		// 90分以内に返答
		$Vie_Itp_NdAssessmentShop = new Apis_Vie_Itp_NdAssessmentShop($this->_conn);
		$vinasParam = array(
		Vie_Itp_NdAssessmentShop::COL_DEALERSHIPCD => $_r[RequestParam::REQ_DEALERSHIP_CODE],
		);
		$Vie_Itp_NdAssessmentShopOne = $Vie_Itp_NdAssessmentShop->findOne($vinasParam);
		
		$this->view->assign('Vie_NetDealerKaitoriCaseList', $Vie_NetDealerKaitoriCaseList);
		$this->view->assign('NetDealerOne', $NetDealerOne);
		$this->view->assign('Vie_Kaitori_Shopcheef_Data_One', $Vie_Kaitori_Shopcheef_Data_One);
		$this->view->assign('Vie_Kaitori_Reinforcement_Car_List', $Vie_Kaitori_Reinforcement_Car_List);
		$this->view->assign('NetDealerInfoOne', $NetDealerInfoOne);
		$this->view->assign('Vie_Itp_NdAssessmentShopOne', $Vie_Itp_NdAssessmentShopOne);
		$this->view->assign('title' , '買取査定');
	}

	/**
	 * 買取実績一覧
	 *
	 */
	public function buyListAction(){
		$req = $this->getRequest();
		$_r = $req->getParams();
		$Vie_NetDealerKaitoriCase = new Apis_Vie_NetDealerKaitoriCase($this->_conn);
		$Vie_Kaitori_Shopcheef_Data = new Apis_Vie_Kaitori_Shopcheef_Data($this->_conn);
		$Vie_Kaitori_Reinforcement_Car = new Apis_Vie_Kaitori_Reinforcement_Car($this->_conn);

		$vndkcParam = array(
		Vie_NetDealerKaitoriCase::COL_DEALERID => $_r[RequestParam::REQ_DEALERSHIP_CODE],
		);
		$vklsParam = array(
		Vie_Kaitori_Reinforcement_Car::COL_DEALERID => $_r[RequestParam::REQ_DEALERSHIP_CODE],
		);
		$ord = array(
		Vie_NetDealerKaitoriCase::COL_CDATE => Model::SORT_ORDER_DESC,
		);

		$om = $Vie_NetDealerKaitoriCase->select()->setAnd($vndkcParam)->setOrder($ord);
		$Vie_Kaitori_Shopcheef_Data_One = $Vie_Kaitori_Shopcheef_Data->findOne($vndkcParam);
		$Vie_Kaitori_Reinforcement_Car_List = $Vie_Kaitori_Reinforcement_Car->select()->setAnd($vklsParam)->setOrder($ord)->fetchAll();

		$limit=10;
		$is_pager=true;
		//ページャ及びリスト取得
		$p = new PagerLocal($_r);
		$p->setLimit($limit);
		$p->page = $req->page;

		$all = range(0, $p->total_num);
		$p->total_num = $om->getCount();
		//			var_dump($om->setLimit($p->limit, $p->offset)->getSql());
		$lists = $om->setLimit($p->limit, $p->offset)->fetchAll();
		$p->init($lists);

		if($is_pager){
			///ページャ	
			$req = $this->getRequest();
			$moduleName = $req->getModuleName();
			$actionName = $req->getActionName();
			$controllerName = $req->getControllerName();

			foreach($req->getParams() as $key => $val)
			{
				if(is_array($val)){
					$urlparam[$key] = array();
					foreach($val as $value) $urlparam[$key][] = $value;
				}else{
					if($val == "")
					{
						unset($urlparam[$key]);
					}else{
						$urlparam[$key] = $val;
					}
				}
			}
			unset($urlparam['module']);
			unset($urlparam['controller']);
			unset($urlparam['action']);
			$urlparam_sort = $urlparam;

			unset($urlparam_sort['module']);
			unset($urlparam_sort['page']);
			unset($urlparam_sort['sort']);
			unset($urlparam_sort['ord']);
			$orderLink = str_replace('=','/',http_build_query($urlparam_sort,'','/'));


			$params = array(
		    'itemData' => $all,
		    'perPage' => $p->limit,
		    'append' => true,
			'separator' => ' ',
		    'clearIfVoid' => false,
		    'urlVar' => 'page',
		    'useSessions' => true,
		    'closeSession' => true,
		    'mode' => 'Jumping',
			'path' => '/' . $moduleName . '/'.$controllerName .'/'. $actionName,
			'fixFileName' => "",
			'fileName' => "",
			'currentPage' => $req->page,
			'extraVars' => $urlparam,
			);

			$pager = & Pager::factory($params);
			$links = $pager->getLinks();
			$_b = array('?','=','&amp;','a href/','" title/');
			$_a = array('','/','/','a href=','/" title=',);

			$_links = str_replace($_b ,$_a,$links);

			foreach($_links as $key => $link)
			{
				//配列の要素全部回すと重いので・・・とりあえずallしか参照してない。
				if($key == 'all')
				{
					$links[$key] = ereg_replace("%5B([0-9]{1,2})%5D", "", $link);
				}
			}

			$this->view->assign('pager', $pager);
			$this->view->assign('links', $links);
		}
		foreach($lists as $one){
			$one->{Vie_NetDealerKaitoriCase::COL_PRICE} = number_format($one->{Vie_NetDealerKaitoriCase::COL_PRICE});
		}
		$this->view->assign('p', $p);
		$this->view->assign('ord', $ord);
		$this->view->assign('sort', $sort);
		$this->view->assign('orderLink', $orderLink);

		$this->view->assign('Vie_NetDealerKaitoriCaseList' , $lists);
		$this->view->assign('Vie_Kaitori_Shopcheef_Data_One', $Vie_Kaitori_Shopcheef_Data_One);
		$this->view->assign('Vie_Kaitori_Reinforcement_Car_List', $Vie_Kaitori_Reinforcement_Car_List);
		$this->view->assign('title' , '買取実績一覧');
	}

	/**
	 * フォトギャラリー
	 *
	 */
	public function galleryAction(){
		$req = $this->getRequest();
		$_r = $req->getParams();

		$Vie_Itp_NdGalleryJoinNdFileEntry = new Apis_Vie_Itp_NdGalleryJoinNdFileEntry($this->_conn);
		$vingjnfeParam = array(
		Vie_Itp_NdGalleryJoinNdFileEntry::COL_DEALERSHIPCD => $_r[RequestParam::REQ_DEALERSHIP_CODE],
		);
		$ord = array(
		Vie_Itp_NdGalleryJoinNdFileEntry::COL_SORT => Model::SORT_ORDER_ASC,
		);

		$Vie_Itp_NdGalleryList = $Vie_Itp_NdGalleryJoinNdFileEntry->select()->setAnd($vingjnfeParam)->setOrder($ord)->fetchAll();

		$Cursor = 1;
		if(isset($_r[Vie_Itp_NdGalleryJoinNdFileEntry::COL_GALLERYID]) && $_r[Vie_Itp_NdGalleryJoinNdFileEntry::COL_GALLERYID] != ""){
			$c_param = array(
			Vie_Itp_NdGalleryJoinNdFileEntry::COL_GALLERYID => $_r[Vie_Itp_NdGalleryJoinNdFileEntry::COL_GALLERYID],
			);

			$file_one = $Vie_Itp_NdGalleryJoinNdFileEntry->findOne($c_param);
			$Cursor = $file_one->{Vie_Itp_NdGalleryJoinNdFileEntry::COL_SORT};
		}
		$Count = $Vie_Itp_NdGalleryJoinNdFileEntry->select()->setAnd($vingjnfeParam)->getCount();

		$this->view->assign('Vie_Itp_NdGalleryList' , $Vie_Itp_NdGalleryList);
		$this->view->assign('Vie_Itp_NdGalleryOne' , $Vie_Itp_NdGalleryList[0]);
		$this->view->assign('Cursor' , $Cursor);
		$this->view->assign('Count' , $Count);
		$this->view->assign('title' , 'フォトギャラリー');
	}

	/**
	 * レビュー
	 *
	 */
	public function reviewAction(){
		$req = $this->getRequest();
		$_r = $req->getParams();
		$Vie_ReviewJoinCarName = new Apis_Vie_ReviewJoinCarName($this->_conn);
		$Itp_NdInfoChargeData = new Apis_Itp_NdInfoChargeData($this->_conn);

		$vrjcnParam = array(
		Vie_ReviewJoinCarName::COL_DEALERSHIPCD => $_r[RequestParam::REQ_DEALERSHIP_CODE],
		Vie_ReviewJoinCarName::COL_PUBLISH => 1,
		);
		if($this->_pnSystemGlobalCD == 0){
			$incdParam = array(
			Itp_NdInfoChargeData::COL_DEALERSHIPCD => $_r[RequestParam::REQ_DEALERSHIP_CODE],
			Itp_NdInfoChargeData::COL_DELETEFLAG => 0,
			);
		}else{
			$incdParam = array(
			Itp_NdInfoChargeData::COL_DEALERSHIPCD => substr_replace($_r[RequestParam::REQ_DEALERSHIP_CODE],'N',0,1),
			Itp_NdInfoChargeData::COL_DELETEFLAG => 0,
			);
		}

		$om = $Vie_ReviewJoinCarName->select()->setAnd($vrjcnParam);

		//**********ソート順***********************
		$ord  = $this->getRequest()->{RequestParam::REQ_ORDER};
		$sort = $this->getRequest()->{RequestParam::REQ_SORT};


		if ($sort == "") $sort = Model::SORT_ORDER_DESC;
		$p_order = array($ord => $sort);

		if($ord == "")
		{
			$p_order = array(
			Vie_ReviewJoinCarName::COL_REVIEWDATE => $sort,
			);
		}

		$this->view->assign('sort', $sort);
		$this->view->assign('ord', $ord);
		$Itp_NdReviewList = $om->setOrder($p_order)->fetchAll();

		foreach($Itp_NdReviewList as $Itp_NdReviewOne){
			$Itp_NdReviewOne->Service = 5 - $Itp_NdReviewOne->{Vie_ReviewJoinCarName::COL_RATINGOFSERVICE};
			$Itp_NdReviewOne->Atmosphere = 5 - $Itp_NdReviewOne->{Vie_ReviewJoinCarName::COL_RATINGOFATMOSPHERE};
			$Itp_NdReviewOne->Quality = 5 - $Itp_NdReviewOne->{Vie_ReviewJoinCarName::COL_RATINGOFQUALITY};
			$Itp_NdReviewOne->Recommend = 5 - $Itp_NdReviewOne->{Vie_ReviewJoinCarName::COL_RATINGOFRECOMMEND};
			$Itp_NdReviewOne->Rate = 5 - $Itp_NdReviewOne->{Vie_ReviewJoinCarName::COL_RATING};
			$buy_season = explode("-", $Itp_NdReviewOne->{Vie_ReviewJoinCarName::COL_PURCHASEDSEASON});
			$Itp_NdReviewOne->year = $buy_season[0];
			$Itp_NdReviewOne->month = $buy_season[1];
		}
		$this->view->assign('Itp_NdReviewList', $Itp_NdReviewList);
		$this->view->assign('title' , 'レビュー');
	}

	/**
	 * お客様紹介
	 *
	 */
	public function customerAction(){
		$req = $this->getRequest();
		$_r = $req->getParams();
		$Vie_NetDealerCustomerVoice = new Apis_Vie_NetDealerCustomerVoice($this->_conn);
		$vndcvParam = array(
		Vie_NetDealerCustomerVoice::COL_DEALERID => $_r[RequestParam::REQ_DEALERSHIP_CODE],
		Vie_NetDealerCustomerVoice::COL_DEL_FLG => 0,
		);
		$ord = array(
		Vie_NetDealerCustomerVoice::COL_CDATE => Model::SORT_ORDER_DESC,
		);

		$om = $Vie_NetDealerCustomerVoice->select()->setAnd($vndcvParam)->setOrder($ord);

		$is_pager=true;
		//ページャ及びリスト取得
		$p = new PagerLocal($_r);
		$p->setLimit(10);
		$p->page = $req->page;

		$all = range(0, $p->total_num);
		$p->total_num = $om->getCount();
		//			var_dump($om->setLimit($p->limit, $p->offset)->getSql());
		$lists = $om->setLimit($p->limit, $p->offset)->fetchAll();
		$p->init($lists);

		if($is_pager){
			///ページャ	
			$req = $this->getRequest();
			$moduleName = $req->getModuleName();
			$actionName = $req->getActionName();
			$controllerName = $req->getControllerName();

			foreach($req->getParams() as $key => $val)
			{
				if(is_array($val)){
					$urlparam[$key] = array();
					foreach($val as $value) $urlparam[$key][] = $value;
				}else{
					if($val == "")
					{
						unset($urlparam[$key]);
					}else{
						$urlparam[$key] = $val;
					}
				}
			}
			unset($urlparam['module']);
			unset($urlparam['controller']);
			unset($urlparam['action']);
			$urlparam_sort = $urlparam;

			unset($urlparam_sort['module']);
			unset($urlparam_sort['page']);
			unset($urlparam_sort['sort']);
			unset($urlparam_sort['ord']);
			$orderLink = str_replace('=','/',http_build_query($urlparam_sort,'','/'));


			$params = array(
		    'itemData' => $all,
		    'perPage' => $p->limit,
		    'append' => true,
			'separator' => ' ',
		    'clearIfVoid' => false,
		    'urlVar' => 'page',
		    'useSessions' => true,
		    'closeSession' => true,
		    'mode' => 'Jumping',
			'path' => '/' . $moduleName . '/'.$controllerName .'/'. $actionName,
			'fixFileName' => "",
			'fileName' => "",
			'currentPage' => $req->page,
			'extraVars' => $urlparam,
			);

			$pager = & Pager::factory($params);
			$links = $pager->getLinks();
			$_b = array('?','=','&amp;','a href/','" title/');
			$_a = array('','/','/','a href=','/" title=',);

			$_links = str_replace($_b ,$_a,$links);

			foreach($_links as $key => $link)
			{
				//配列の要素全部回すと重いので・・・とりあえずallしか参照してない。
				if($key == 'all')
				{
					$links[$key] = ereg_replace("%5B([0-9]{1,2})%5D", "", $link);
				}
			}

			$this->view->assign('pager', $pager);
			$this->view->assign('links', $links);
		}




		$this->view->assign('p', $p);
		$this->view->assign('ord', $ord);
		$this->view->assign('sort', $sort);
		$this->view->assign('orderLink', $orderLink);


		$this->view->assign('NetDealerCustomerVoiceList' , $lists);
		$this->view->assign('title' , 'お客様紹介');
	}

	/**
	 * マップ
	 *
	 */
	public function mapAction(){
		$req = $this->getRequest();
		$_r = $req->getParams();

		$TANMATU = $_SERVER ["HTTP_USER_AGENT"];
		$sHTTP_REFERER = $_SERVER ["HTTP_REFERER"];

		if($this->_pnSystemGlobalCD == 0){
			if ((strpos ( $TANMATU, "iPhone" ) > 0) && (strpos ( $sHTTP_REFERER, "mjnet.co.jp" ) > 0)) {
				$sp_url = 'http://www2.mjnet.co.jp/ucar/smart/shop_map.asp?dealerid='.$_r[RequestParam::REQ_DEALERSHIP_CODE];
			} elseif (strpos ( $TANMATU, "iPhone" ) > 0) {
				$this->_redirect('http://www2.mjnet.co.jp/ucar/smart/shop_map.asp?dealerid='.$_r[RequestParam::REQ_DEALERSHIP_CODE]);
			} elseif ((strpos ( $TANMATU, "Android" ) > 0) && (strpos ( $sHTTP_REFERER, "mjnet.co.jp" ) > 0)) {
				$sp_url = 'http://www2.mjnet.co.jp/ucar/android/shop_map.asp?dealerid='.$_r[RequestParam::REQ_DEALERSHIP_CODE];
			} elseif (strpos ( $TANMATU, "Android" ) > 0) {
				$this->_redirect('http://www2.mjnet.co.jp/ucar/android/shop_map.asp?dealerid='.$_r[RequestParam::REQ_DEALERSHIP_CODE]);
			}
		}else{
			if ((strpos ( $TANMATU, "iPhone" ) > 0) && (strpos ( $sHTTP_REFERER, "kurumaru.com" ) > 0)) {
				$sp_url = 'http://m.kurumaru.com/kurumaru/smart/shop_map.asp?dealerid='.$_r[RequestParam::REQ_DEALERSHIP_CODE];
			} elseif (strpos ( $TANMATU, "iPhone" ) > 0) {
				$this->_redirect('http://m.kurumaru.com/kurumaru/smart/shop_map.asp?dealerid='.$_r[RequestParam::REQ_DEALERSHIP_CODE]);
			} elseif ((strpos ( $TANMATU, "Android" ) > 0) && (strpos ( $sHTTP_REFERER, "kurumaru.com" ) > 0)) {
				$sp_url = 'http://m.kurumaru.com/kurumaru/android/shop_map.asp?dealerid='.$_r[RequestParam::REQ_DEALERSHIP_CODE];
			} elseif (strpos ( $TANMATU, "Android" ) > 0) {
				$this->_redirect('http://m.kurumaru.com/kurumaru/android/shop_map.asp?dealerid='.$_r[RequestParam::REQ_DEALERSHIP_CODE]);
			}
		}
		$this->view->assign ( 'sp_url', $sp_url );
		
		if(isset($_r['Scale']) && $_r['Scale'] != ""){
			$Scale = $_r['Scale'];
		}else{
			$Scale = 12;
		}
		$this->view->assign('Scale', $Scale);

		$this->LogInsert(3);
		$this->view->assign('title' , '店舗情報');
	}

	/**
	 * インフォメーション
	 *
	 */
	public function infomationAction(){
		$req = $this->getRequest();
		$_r = $req->getParams();
		$NetDealerInfo = new Apis_NetDealerInfo($this->_conn);
		$ndiParam = array(
		NetDealerInfo::COL_DEALERID => $_r[RequestParam::REQ_DEALERSHIP_CODE],
		NetDealerInfo::COL_DEL_FLG => 0,
		);
		$ord = array(
		NetDealerInfo::COL_CDATE => Model::SORT_ORDER_DESC,
		);
		$NetDealerInfoList = $NetDealerInfo->select()->setAnd($ndiParam)->setOrder($ord)->fetchAll();

		$this->view->assign('NetDealerInfoList', $NetDealerInfoList);
		$this->view->assign('title' , 'インフォメーション');
	}

	/**
	 * お気に入りショップに追加実行
	 *
	 */
	public function favoriteAddDoAction(){
		$req = $this->getRequest();
		$_r = $req->getParams();
		$ipAddress = $_SERVER["REMOTE_ADDR"];
		$ua = $_SERVER['HTTP_USER_AGENT'];

		$Favorite_Dealer = new Favorite_Dealer($this->_conn);
		if($this->_pnSystemGlobalCD == 0){
			$param = array(
			Favorite_Dealer::COL_DEALERSHIPCD => $_r[RequestParam::REQ_DEALERSHIP_CODE],
			Favorite_Dealer::COL_REMOTE_ADDR => $ipAddress,
			Favorite_Dealer::COL_HTTP_USER_AGENT => $ua,
			);
		}else{
			$param = array(
			Favorite_Dealer::COL_DEALERSHIPCD => substr_replace($_r[RequestParam::REQ_DEALERSHIP_CODE],'N',0,1),
			Favorite_Dealer::COL_REMOTE_ADDR => $ipAddress,
			Favorite_Dealer::COL_HTTP_USER_AGENT => $ua,
			);
		}
		// 二重登録防止
		$Favorite_Dealer->deletePhysical($param);
		$param[Favorite_Dealer::COL_DATAREGISTRATIONDATE] = $Favorite_Dealer->getDay();

		$Favorite_Dealer->insertFromPostRequest($param);
		$this->_redirect($_SERVER["HTTP_REFERER"]);
	}

	/**
	 * お気に入りショップから外す実行
	 *
	 */
	public function favoriteDelDoAction(){
		$req = $this->getRequest();
		$_r = $req->getParams();
		$ipAddress = $_SERVER["REMOTE_ADDR"];
		$ua = $_SERVER['HTTP_USER_AGENT'];

		$Favorite_Dealer = new Apis_Favorite_Dealer($this->_conn);
		if($this->_pnSystemGlobalCD == 0){
			$param = array(
			Favorite_Dealer::COL_DEALERSHIPCD => $_r[RequestParam::REQ_DEALERSHIP_CODE],
			Favorite_Dealer::COL_REMOTE_ADDR => $ipAddress,
			Favorite_Dealer::COL_HTTP_USER_AGENT => $ua,
			);
		}else{
			$param = array(
			Favorite_Dealer::COL_DEALERSHIPCD => substr_replace($_r[RequestParam::REQ_DEALERSHIP_CODE],'N',0,1),
			Favorite_Dealer::COL_REMOTE_ADDR => $ipAddress,
			Favorite_Dealer::COL_HTTP_USER_AGENT => $ua,
			);
		}

		$Favorite_Dealer->deletePhysical($param);
		$this->_redirect($_SERVER["HTTP_REFERER"]);
	}

	/**
	 * クッキー追加実行
	 *
	 */
	public function cookieAddDoAction(){
		$req = $this->getRequest();
		$_r = $req->getParams();
		$ipAddress = $_SERVER["REMOTE_ADDR"];
		$ua = $_SERVER['HTTP_USER_AGENT'];
		$result = $this->_authIdentity;

		// TODO 削除処理(COOKIE)
		$del_val_list = $this->getRequest()->getCookie("aic_mylist_del");
		$new_val_list = $this->getRequest()->getCookie("aic_mylist_new");
		// 削除済みリストに保存
		$del_val = strstr($del_val_list,$_r[RequestParam::REQ_ID]);
		if($del_val){
			setcookie("aic%5Fmylist%5Fdel",$_r[RequestParam::REQ_ID]."=".date('Y/m/d H:i:s')."&".$del_val_list,time() + 365*24*60*60,'/');
		}
		$id = $_r[RequestParam::REQ_ID];
		// お気に入りリストから削除
		setcookie("aic%5Fmylist%5Fnew",$id="",time() - 60,'/');
		$favorite_other = new Favorite_Other($this->_conn);
		$foWhere = array(
		Favorite_Other::COL_USEDCARCD => $_r[Favorite_Other::COL_USEDCARCD],
		Favorite_Other::COL_REMOTE_ADDR => $ipAddress,
		Favorite_Other::COL_HTTP_USER_AGENT => $ua,
		Favorite_Other::COL_O_FDEL_FLG => 0,
		);
		$foParam = array(
		Favorite_Other::COL_O_FDEL_FLG => 1,
		);
		$favorite_other->updateFromPostRequest($foParam, $foWhere);

		// 集計テーブルから削除
		$MjnetCntFavorite = new MjnetCntFavorite($this->_conn);
		$mcfWhere = array(
		MjnetCntFavorite::COL_USEDCARCD => $_r[MjnetCntFavorite::COL_USEDCARCD],
		);
		$MjnetCntFavoriteOne = $MjnetCntFavorite->deletePhysical($mcfWhere);

		// お気に入りリストに追加
		setcookie("aic%5Fmylist%5Fnew",$_r[RequestParam::REQ_ID]."=".date('Y/m/d H:i:s')."&".$new_val_list,time() + 365*24*60*60,'/');

		// TODO favorite_otherに登録するデータがまだある
		// ログテーブルにインサート
		$foParam = array(
		Favorite_Other::COL_O_FDEALERID => $_r[RequestParam::REQ_DEALERSHIP_CODE],
		Favorite_Other::COL_O_FDATAID => $_r[RequestParam::REQ_ID],
		Favorite_Other::COL_USEDCARCD => $_r[Favorite_Other::COL_USEDCARCD],
		Favorite_Other::COL_REMOTE_ADDR => $ipAddress,
		Favorite_Other::COL_HTTP_USER_AGENT => $ua,
		Favorite_Other::COL_O_FCDATE => $favorite_other->getDay(),
		Favorite_Other::COL_O_FMEMBERID => $result->{Mjnet_Member::TBL_NAME}->{Mjnet_Member::COL_ID},
		Favorite_Other::COL_O_FDEL_FLG => 0,
		);
		$favorite_other->insertFromPostRequest($foParam);

		$countParam = array(
		Favorite_Other::COL_USEDCARCD => $_r[Favorite_Other::COL_USEDCARCD],
		Favorite_Other::COL_O_FDEL_FLG => 0,
		);
		// お気に入り数カウント
		$favorite_Cnt = $favorite_other->select()->setAnd($countParam)->getCount();
		// 再集計
		$mcfParam = array(
		MjnetCntFavorite::COL_USEDCARCD => $_r[MjnetCntFavorite::COL_USEDCARCD],
		MjnetCntFavorite::COL__BUKKENID => $_r[RequestParam::REQ_ID],
		MjnetCntFavorite::COL_FAVORITECNT => $favorite_Cnt,
		MjnetCntFavorite::COL_DATAREGISTRATIONDATE => $MjnetCntFavorite->getDay(),
		);
		$MjnetCntFavorite->insertFromPostRequest($mcfParam);

		// データ反映
		$Vie_MjnetCarDataList = new Vie_MjnetCarDataList();
		$Vie_MjnetCarDataListSmart = new Vie_MjnetCarDataListSmart();
		$Vie_MjnetCarDataListMobile = new Vie_MjnetCarDataListMobile();
		$Vie_MjnetCarDataListTower = new Vie_MjnetCarDataListTower();

		$vmcdlParam = array(
		Vie_MjnetCarDataList::COL_FAVORITECNT => $favorite_Cnt,
		);
		$vmcdlWhere = array(
		Vie_MjnetCarDataList::COL_ID => $_r[RequestParam::REQ_ID],
		);
		$Vie_MjnetCarDataList->updateFromPostRequest($vmcdlParam, $vmcdlWhere);
		$Vie_MjnetCarDataListSmart->updateFromPostRequest($vmcdlParam, $vmcdlWhere);
		$Vie_MjnetCarDataListMobile->updateFromPostRequest($vmcdlParam, $vmcdlWhere);
		$Vie_MjnetCarDataListTower->updateFromPostRequest($vmcdlParam, $vmcdlWhere);

		$this->_redirect($_SERVER["HTTP_REFERER"]);
	}

	/**
	 * クッキー削除実行
	 *
	 */
	public function cookieDelDoAction(){
		$req = $this->getRequest();
		$_r = $req->getParams();
		$ipAddress = $_SERVER["REMOTE_ADDR"];
		$ua = $_SERVER['HTTP_USER_AGENT'];

		// TODO 削除処理(COOKIE)
		$del_val_list = $this->getRequest()->getCookie("aic_mylist_del");
		$new_val_list = $this->getRequest()->getCookie("aic_mylist_new");
		// 削除済みリストに保存
		$del_val = strstr($del_val_list,$_r[RequestParam::REQ_ID]);
		if($del_val){
			setcookie("aic%5Fmylist%5Fdel",$_r[RequestParam::REQ_ID]."=".date('Y/m/d H:i:s')."&".$del_val_list,time() + 365*24*60*60,'/');
		}
		// お気に入りリストから削除
		$cookie = setcookie("aic%5Fmylist%5Fnew","",time() - 60,'/');
		$favorite_other = new Favorite_Other($this->_conn);
		$foWhere = array(
		Favorite_Other::COL_USEDCARCD => $_r[Favorite_Other::COL_USEDCARCD],
		Favorite_Other::COL_REMOTE_ADDR => $ipAddress,
		Favorite_Other::COL_HTTP_USER_AGENT => $ua,
		Favorite_Other::COL_O_FDEL_FLG => 0,
		);
		$foParam = array(
		Favorite_Other::COL_O_FDEL_FLG => 1,
		);
		$favorite_other->updateFromPostRequest($foParam, $foWhere);

		// 集計テーブルから削除
		$MjnetCntFavorite = new MjnetCntFavorite($this->_conn);
		$mcfWhere = array(
		MjnetCntFavorite::COL_USEDCARCD => $_r[MjnetCntFavorite::COL_USEDCARCD],
		);
		$MjnetCntFavoriteOne = $MjnetCntFavorite->deletePhysical($mcfWhere);

		$this->_redirect($_SERVER["HTTP_REFERER"]);
	}

	/**
	 * ログ取得
	 *
	 */
	public function LogInsert($ID){
		$req = $this->getRequest();
		$_r = $req->getParams();

		$Vie_ITPackShopLog = new Vie_ITPackShopLog($this->_conn);
		$data = array(
		Vie_ITPackShopLog::COL_ID => $ID,
		Vie_ITPackShopLog::COL_DEALERID => $_r[RequestParam::REQ_DEALERSHIP_CODE],
		Vie_ITPackShopLog::COL_REMOTE_ADDR => $_SERVER["REMOTE_ADDR"],
		Vie_ITPackShopLog::COL_HTTP_USER_AGENT => $_SERVER['HTTP_USER_AGENT'],
		Vie_ITPackShopLog::COL_CDATE => $Vie_ITPackShopLog->getDay(),
		);
		//var_dump($data);
		
		// Botは取得しない
		if($this->_IsNeedLog()) $Vie_ITPackShopLog->insertFromPostRequest($data);
	}

	/**
	 * リジナルホームページをクリックした際のログ
	 *
	 */
	public function redirectDoAction(){
		$req = $this->getRequest();
		$_r = $req->getParams();
		
		$this->LogInsert(4);

//		if($this->_pnSystemGlobalCD == 0){
//			$this->_redirect("http://" . $_r['url']);
//		}else{
			$this->_redirect($_r['url']);
//		}
	}
}
?>