/**
* カートの中身を選択する．
* @param $params
* @throws Exception
*/
public function showCartContent($id)
{
$this->_log->debug(__CLASS__ . ":" . __FUNCTION__ . " called:(" . __LINE__ . ")");
$cartContent = array();
$db = Common::getMaster();
$mCart = new TCart($db);
$select = $mCart->select();
$select->where("customerID = ?", $id);
$items = $mCart->fetchAll($select)->toArray();
if (count($items) == 0) {
$this->_log->debug("カートの中身が存在しませんでした．");
return $cartContent;
}
foreach ($items as $value) {
$mItem = new MItemStock($db);
$itemInfo = $mItem->itemInfo($value['itemID']);
$itemInfo['numItem'] = $value['numItem'];
$cartContent[] = $itemInfo;
}
return $cartContent;
}
/**
* 配達リクエスト情報を返す
* @param $requestID
* @throws Exception
*/
public function selectRequestInfo($requestID)
{
$this->_log->debug(__CLASS__ . ":" . __FUNCTION__ . " called:(" . __LINE__ . ")");
$db = Common::getMaster();
$this->_begin($db);
try {
$mRequest = new TRequest($db);
$requestInfo = $mRequest->findRecord($requestID);
// 購入合計金額を計算
$price = 0;
$mCart = new TCart($db);
$select = $mCart->select();
$select->where('customerID = ?', $requestInfo['recipientID']);
$itemInCartInfo = $mCart->fetchAll($select)->toArray();
foreach ($itemInCartInfo as $value) {
$mItem = new MItemStock($db);
$itemInfo = $mItem->itemInfo($value['itemID']);
$itemNum = (int) $value['numItem'];
$itemPrice = (int) $itemInfo['price'];
$price += $itemNum * $itemPrice;
}
$requestInfo['price'] = $price;
} catch (Exception $e) {
$this->_rollBack();
throw $e;
}
return $requestInfo;
}
