public function index()
{
$this->actionMenu = array(array('name' => '发布商品', 'url' => utils::getUrl('admin/system-product/add/' . base64_encode($this->url))));
$this->menuTitle = '我的商品列表';
$tableName = utils::getTableName($this->systemProductService->modelName);
$systemProductList = $this->systemProductService->model->querySql($tableName);
$hasSkuProductIdArr = $newProductList = array();
if ($systemProductList) {
foreach ($systemProductList['resultList'] as $product) {
$newProductList[$product['id']] = $product;
if ($product['is_has_sku']) {
$hasSkuProductIdArr[] = $product['id'];
}
}
}
$productSkuService = new productSkuService();
$skuList = $productSkuService->getSkuListByProductIdArr($hasSkuProductIdArr);
if ($skuList) {
foreach ($skuList as $skuInfo) {
$newProductList[$skuInfo['sysproduct_id']]['skuList'][] = $skuInfo;
}
}
$showCategoryModel = new showCategoryModel();
$showCategoryList = $showCategoryModel->getCacheFileCategory();
$productAllStatus = $this->systemProductService->productStatus;
$data = array('showCategoryList' => $showCategoryList, 'systemProductList' => $newProductList, 'productAllStatus' => $productAllStatus);
$this->setView($data);
}
public function getHomeByHomeIdArr($homeIdArr)
{
$tableName = utils::getTableName('home');
$homeIdStr = implode(',', $homeIdArr);
$homeInfoList = $this->querySql($tableName, array('*'), 'id in (' . $homeIdStr . ')');
return $homeInfoList;
}
public function getSkuListByProductIdArr($productIdArr)
{
$allSkuList = array();
if ($productIdArr) {
$productIdStr = implode(',', $productIdArr);
$where = "sysproduct_id in ({$productIdStr})";
$skuList = $this->model->querySql(utils::getTableName($this->modelName), array('*'), $where);
if ($skuList['rowNums']) {
$allSkuList = $skuList['resultList'];
}
}
return $allSkuList;
}
public function getSkuByIds($skuIds)
{
$allSkuList = array();
if ($skuIds) {
$skuIdStr = implode(',', $skuIds);
$where = "id in ({$skuIdStr})";
$skuList = $this->model->querySql(utils::getTableName($this->modelName), array('*'), $where);
if ($skuList['rowNums']) {
$allSkuList = $skuList['resultList'];
}
}
return $allSkuList;
}
public function addToCart($prodcutInfo, $nums = 1, $groupNum = 1, $groupDay = 1, $startTimeInt = 0, $skuInfo = 0)
{
$userId = 1;
//判断购物车是否含有该商品
$hasCartId = $this->checkProductIsCart($prodcutInfo['id'], $skuInfo['id']);
if ($hasCartId) {
$tableName = utils::getTableName($this->modelName);
$sql = 'update ' . $tableName . ' set product_num = product_num + ' . $nums . ',group_num=' . $groupNum . ',group_day=' . $groupDay . ',start_time=' . $startTimeInt . ' where id = ' . $hasCartId;
$this->model->executeSql($sql);
$cartId = $hasCartId;
} else {
$saveData = array('product_id' => $prodcutInfo['id'], 'price' => $prodcutInfo['price'], 'product_num' => $nums, 'paddtime' => time(), 'user_id' => $userId, 'group_num' => $groupNum, 'group_day' => $groupDay, 'start_time' => $startTimeInt);
if ($skuInfo) {
$saveData['price'] = $skuInfo['price'];
$saveData['sku_id'] = $skuInfo['id'];
}
$cartId = $this->model->insert($saveData);
}
return $cartId;
}
public function cancelOrder($id, $cancelOrderVal)
{
//判断订单是否在线支付，是否需要退款
$orderInfo = $this->model->find($id);
//订单有效判断
$sessionUser = utils::getSessionVal('userInfo');
$cancelStatus = array(1, 2, 3, 4);
if (!in_array($orderInfo['pstatus'], $cancelStatus)) {
return array('code' => '201', 'message' => '订单状态错误');
}
if ($orderInfo['shop_id'] != $sessionUser['shopId']) {
return array('code' => '201', 'message' => '非法操作,你无权操作');
}
$returnPrice = false;
if ($orderInfo['pay_status'] == 1) {
$returnPrice = true;
}
$db = utils::getDB();
$db->beginTransaction();
$sessionUser['businessUserId'] = 6;
$tableName = utils::getTableName('user');
$sql = 'update ' . $tableName . ' set balance = balance - ' . $orderInfo['actual_total'] . ' where id = ' . $sessionUser['businessUserId'];
$isTure = $this->model->executeSql($sql);
if ($isTure) {
$saveOrderData = array('id' => $orderInfo['id'], 'pstatus' => 6, 'actual_total' => 0, 'pay_status' => 3);
$orderService = utils::getService('order');
$orderService->model->save($saveOrderData);
$db->commit();
} else {
$db->rollBack();
}
}
public function getProductListByOrderIds($ids)
{
$tableName = utils::getTableName($this->modelName);
$productResult = $this->model->querySql($tableName, array('*'), 'order_id in (' . implode(',', $ids) . ')');
return $productResult;
}
public function getHomeByIds($ids)
{
$tableName = utils::getTableName($this->modelName);
$shopList = $this->model->querySql($tableName, array('*'), 'id in (' . implode(',', $ids) . ')');
return $shopList;
}
