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; }