public function testGetDetailAndProductsClass_商品規格IDの商品情報と規格情報を返す()
{
$this->setUpProductClass();
$this->setUpProducts();
$this->setUpClassCategory();
//更新日を取得
$arrRet = $this->objQuery->getCol('update_date', 'dtb_products', 'product_id = 1001');
$this->expected = array('product_id' => '1001', 'product_code_min' => 'code1001', 'product_code_max' => 'code1001', 'name' => '製品名1001', 'comment1' => 'コメント10011', 'comment2' => 'コメント10012', 'comment3' => 'コメント10013', 'main_list_comment' => 'リストコメント1001', 'main_image' => '1001.jpg', 'main_list_image' => '1001-main.jpg', 'price01_min' => '1500', 'price01_max' => '1500', 'price02_min' => '1500', 'price02_max' => '1500', 'stock_min' => '99', 'stock_max' => '99', 'stock_unlimited_min' => '0', 'stock_unlimited_max' => '0', 'deliv_date_id' => '1', 'status' => '1', 'del_flg' => '0', 'update_date' => $arrRet[0], 'price01_min_inctax' => SC_Helper_DB::sfCalcIncTax('1500'), 'price01_max_inctax' => SC_Helper_DB::sfCalcIncTax('1500'), 'price02_min_inctax' => SC_Helper_DB::sfCalcIncTax('1500'), 'price02_max_inctax' => SC_Helper_DB::sfCalcIncTax('1500'), 'maker_id' => null, 'comment4' => null, 'comment5' => null, 'comment6' => null, 'note' => null, 'main_comment' => 'メインコメント1001', 'main_large_image' => null, 'sub_title1' => null, 'sub_comment1' => null, 'sub_image1' => null, 'sub_large_image1' => null, 'sub_title2' => null, 'sub_comment2' => null, 'sub_image2' => null, 'sub_large_image2' => null, 'sub_title3' => null, 'sub_comment3' => null, 'sub_image3' => null, 'sub_large_image3' => null, 'sub_title4' => null, 'sub_comment4' => null, 'sub_image4' => null, 'sub_large_image4' => null, 'sub_title5' => null, 'sub_comment5' => null, 'sub_image5' => null, 'sub_large_image5' => null, 'sub_title6' => null, 'sub_comment6' => null, 'sub_image6' => null, 'sub_large_image6' => null, 'creator_id' => '1', 'create_date' => $arrRet[0], 'point_rate' => '0', 'deliv_fee' => null, 'class_count' => '1', 'maker_name' => null, 'stock' => '99', 'stock_unlimited' => '0', 'sale_limit' => null, 'price01' => '1500', 'price02' => '1500', 'product_code' => 'code1001', 'product_class_id' => '1001', 'product_type_id' => '1', 'down_filename' => null, 'down_realfilename' => null, 'classcategory_name1' => 'cat1001', 'rank1' => null, 'class_name1' => '味', 'class_id1' => '1', 'classcategory_id1' => '1001', 'classcategory_id2' => '1002', 'classcategory_name2' => 'cat1002', 'rank2' => null, 'class_name2' => '味', 'class_id2' => '1');
$this->actual = $this->objProducts->getDetailAndProductsClass('1001');
$this->verify('商品詳細＋規格');
}
public function testGetListByProductIds_指定の商品IDで情報を取得する()
{
$this->setUpProductClass();
$this->setUpProducts();
$this->setUpClassCategory();
$arrProductId = array('1001');
//更新日を取得
$arrRet = $this->objQuery->getCol('update_date', 'dtb_products', 'product_id = 1001');
$this->expected = array('1001' => array('product_id' => '1001', 'product_code_min' => 'code1001', 'product_code_max' => 'code1001', 'name' => '製品名1001', 'comment1' => 'コメント10011', 'comment2' => 'コメント10012', 'comment3' => 'コメント10013', 'main_list_comment' => 'リストコメント1001', 'main_image' => '1001.jpg', 'main_list_image' => '1001-main.jpg', 'price01_min' => '1500', 'price01_max' => '1500', 'price02_min' => '1500', 'price02_max' => '1500', 'stock_min' => '99', 'stock_max' => '99', 'stock_unlimited_min' => '0', 'stock_unlimited_max' => '0', 'deliv_date_id' => '1', 'status' => '1', 'del_flg' => '0', 'update_date' => $arrRet[0], 'price01_min_inctax' => SC_Helper_DB::sfCalcIncTax('1500'), 'price01_max_inctax' => SC_Helper_DB::sfCalcIncTax('1500'), 'price02_min_inctax' => SC_Helper_DB::sfCalcIncTax('1500'), 'price02_max_inctax' => SC_Helper_DB::sfCalcIncTax('1500')));
$this->actual = $this->objProducts->getListByProductIds($this->objQuery, $arrProductId);
$this->verify('商品ID指定');
}
/**
* 商品情報の配列に税込金額を設定する
*
* @param array $arrProducts 商品情報の配列
* @return void
*/
static function setIncTaxToProduct(&$arrProduct)
{
$arrProduct['price01_min_inctax'] = isset($arrProduct['price01_min']) ? SC_Helper_DB::sfCalcIncTax($arrProduct['price01_min']) : null;
$arrProduct['price01_max_inctax'] = isset($arrProduct['price01_max']) ? SC_Helper_DB::sfCalcIncTax($arrProduct['price01_max']) : null;
$arrProduct['price02_min_inctax'] = isset($arrProduct['price02_min']) ? SC_Helper_DB::sfCalcIncTax($arrProduct['price02_min']) : null;
$arrProduct['price02_max_inctax'] = isset($arrProduct['price02_max']) ? SC_Helper_DB::sfCalcIncTax($arrProduct['price02_max']) : null;
}
/**
* 商品情報の配列に, 税込金額を設定して返す.
*
* この関数は, 主にスマートフォンで使用します.
*
* @param array $arrProducts 商品情報の配列
* @return array 税込金額を設定した商品情報の配列
*/
function setPriceTaxTo($arrProducts)
{
foreach ($arrProducts as $key => $val) {
$arrProducts[$key]['price01_min_format'] = number_format($arrProducts[$key]['price01_min']);
$arrProducts[$key]['price01_max_format'] = number_format($arrProducts[$key]['price01_max']);
$arrProducts[$key]['price02_min_format'] = number_format($arrProducts[$key]['price02_min']);
$arrProducts[$key]['price02_max_format'] = number_format($arrProducts[$key]['price02_max']);
$arrProducts[$key]['price01_min_tax'] = SC_Helper_DB::sfCalcIncTax($arrProducts[$key]['price01_min']);
$arrProducts[$key]['price01_max_tax'] = SC_Helper_DB::sfCalcIncTax($arrProducts[$key]['price01_max']);
$arrProducts[$key]['price02_min_tax'] = SC_Helper_DB::sfCalcIncTax($arrProducts[$key]['price02_min']);
$arrProducts[$key]['price02_max_tax'] = SC_Helper_DB::sfCalcIncTax($arrProducts[$key]['price02_max']);
$arrProducts[$key]['price01_min_tax_format'] = number_format($arrProducts[$key]['price01_min_tax']);
$arrProducts[$key]['price01_max_tax_format'] = number_format($arrProducts[$key]['price01_max_tax']);
$arrProducts[$key]['price02_min_tax_format'] = number_format($arrProducts[$key]['price02_min_tax']);
$arrProducts[$key]['price02_max_tax_format'] = number_format($arrProducts[$key]['price02_max_tax']);
}
return $arrProducts;
}