/** * 商品列表页面 */ public function execute() { $service = new GoodsService(); // load the good types $typeTree = $service->getGoodsTypeTree(); // load the items $typeId = isset($_REQUEST["typeId"]) ? $_REQUEST["typeId"] : 0; $orderBy = isset($_REQUEST["order_by"]) ? $_REQUEST["order_by"] : "name"; $orderDirect = isset($_REQUEST["order_direct"]) ? $_REQUEST["order_direct"] : "ASC"; $page_index = isset($_REQUEST["page_index"]) ? $_REQUEST["page_index"] : 1; $page_size = isset($_REQUEST["page_size"]) ? $_REQUEST["page_size"] : 12; $pageInfo = array("page_index" => $page_index, "page_size" => $page_size); $currency = isset($_REQUEST["currency"]) ? $_REQUEST["currency"] : "RMB"; $param = array("typeId" => $typeId, "orderBy" => $orderBy, "orderDirect" => $orderDirect, "pageInfo" => $pageInfo); $items = $service->getGoodsList($param); $itemCount = $items["count"]; $totalPage = intval($itemCount / $page_size) + 1; //var_dump($items); return array("view" => "goodsList", "totalPage" => $totalPage, "itemCount" => $items["count"], "pageIndex" => $page_index, "pageSize" => $page_size, "items" => $items["data"], "typeTree" => $typeTree, "currency" => $currency, "typeId" => $typeId, "orderBy" => $orderBy, "orderDirect" => $orderDirect); }
$is_out_of_stock_name = '是'; } else { $is_out_of_stock_name = '否'; } echo "<tr> \r\n \t\t<td>\r\n <a href='./index.php?mod=goods&action=detail&did={$order_goods->goods_id}'>{$order_goods->goods_name}</a>\r\n </td>\r\n \t\t<td>{$order_goods->system_number}</td>\r\n \t\t<td>{$order_goods->goods_number}</td>\r\n \t\t<td>{$is_out_of_stock_name}</td>\r\n </tr>"; } ?> </tbody> </table> <?php $subPages = new SubPages($page_size, $nums, $pageCurrent, $sub_pages, $url); require_once 'class/goods.class.php'; require_once 'class/goods_service.class.php'; $goods_service = new GoodsService(); $array_goods = $goods_service->getGoodsBySupplierIdNotInOrder($supplier_id, $id); ?> <!-- Modal --> <div id="addGoods" class="modal hide fade" tabindex="-1" role="dialog" aria-labelledby="myModalLabel" aria-hidden="true"> <div class="modal-header"> <button type="button" class="close" data-dismiss="modal" aria-hidden="true">×</button> <h3 id="myModalLabel">添加供应商产品</h3> </div> <div class="modal-body"> <form class="form-horizontal" action="./index.php?mod=order&action=detail_post&did=<?php echo $id; ?> " method="post"> <div class="control-group"> <input name="order_id" type="hidden" value="<?php
/* * @auther lion * @date 2013-2-1 */ require_once 'class/goods_service.class.php'; require_once 'class/goods.class.php'; require_once 'class/sub_pages.class.php'; require_once 'class/code_names.class.php'; if (isset($_GET["p"])) { $pageCurrent = $_GET["p"]; } else { $pageCurrent = 1; } //每页显示的条数 $page_size = 10; $goods_service = new GoodsService(); //总条目数 //每次显示的页数 $sub_pages = 10; $url = "index.php?mod=goods&action=ls&p="; if (isset($_GET["keywords"])) { $keywords = trim($_GET["keywords"]); if (!empty($keywords)) { $array_goods = $goods_service->listAllByKeywords($pageCurrent, $page_size, $keywords); $nums = $goods_service->getListRowsByKeywords($keywords); $url = "index.php?mod=goods&action=ls&keywords={$keywords}&p="; } else { $array_goods = $goods_service->listAll($pageCurrent, $page_size); $nums = $goods_service->getListRows(); } } else {
?> </tbody> </table> <?php $subPages = new SubPages($page_size, $nums, $pageCurrent, $sub_pages, $url); ?> </div> </div> <?php $goods_service = new GoodsService(); $page_size = $goods_service->getListRows("SELECT COUNT(*) FROM t_goods WHERE t_goods.id NOT IN(SELECT goods_id FROM t_supplier_rel_goods WHERE t_supplier_rel_goods.supplier_id=" . $id . ")"); $sql = "select t_goods.* from t_goods where t_goods.id NOT IN(SELECT goods_id FROM t_supplier_rel_goods WHERE t_supplier_rel_goods.supplier_id=" . $id . ")"; $array_goods = $goods_service->listAll(1, $page_size, $sql); ?> <!-- Modal --> <div id="addGoods" class="modal hide fade" tabindex="-1" role="dialog" aria-labelledby="myModalLabel" aria-hidden="true"> <div class="modal-header"> <button type="button" class="close" data-dismiss="modal" aria-hidden="true">×</button> <h3 id="myModalLabel">添加供应商产品</h3> </div> <div class="modal-body"> <form class="form-horizontal" action="./index.php?mod=supplier&action=detail&did=<?php echo $id; ?> " method="post">
private function createUserArray($userResults) { $userArray = array(); $usernameArray = array(); foreach ($userResults as $row) { $newUser = new User($row['username'], $row['password'], $row['email'], $row['referrer'], $row['referlink'], $row['role']); $userArray[$row['username']] = $newUser; $usernameArray[] = $row['username']; } $userDAO = new UserDAO(); $personalisationResults = $userDAO->getPersonalisationByAttributeValuesArray('username', $usernameArray); foreach ($personalisationResults as $row) { $newPersonalistion = new Personalisation($row['username'], $row['avatarURL'], $row['biography']); $userArray[$row['username']]->personalisation = $newPersonalistion; } $contactResults = $userDAO->getContactsByAttributeValuesArray('username', $usernameArray); foreach ($contactResults as $row) { $newContact = new Contact($row['id'], $row['username'], $row['contactType'], $row['value'], $row['value2'], $row['value3']); $userArray[$row['username']]->contactContainer[$row['contactType']][] = $newContact; } $uploadedResults = $userDAO->getUploadedByAttributeValuesArray('username', $usernameArray); foreach ($uploadedResults as $row) { $newUploaded = new Uploaded($row['id'], $row['name'], $row['imageURL'], $row['username'], $row['realPrice'], $row['mesoPrice'], $row['uploadTimestamp'], $row['status'], $row['statusTimestamp'], $row['description'], $row['serverID']); $userArray[$row['username']]->uploadedContainer[$row['id']] = $newUploaded; } $goodsService = new GoodsService(); $ordersArray = $goodsService->getOrdersByUsernameValues($usernameArray); foreach ($ordersArray as $username => $userOrderArray) { foreach ($userOrderArray as $order) { if ($order->orderType == BUY_ORDER_TYPE) { $userArray[$username]->buyOrdersContainer[] = $order; } else { if ($order->orderType == SELL_ORDER_TYPE) { $userArray[$username]->sellOrdersContainer[] = $order; } } } } return $userArray; }
/* * @auther lion * @date 2013-2-4 */ require_once 'class/supplier.class.php'; require_once 'class/supplier_service.class.php'; require_once 'class/goods.class.php'; require_once 'class/goods_service.class.php'; $supplier_service = new SupplierService(); $array_supplier = $supplier_service->getAll(); if (isset($_GET["supplier_id"])) { $supplier_id = $_GET["supplier_id"]; } else { $supplier_id = $array_supplier[0]->id; } $goods_service = new GoodsService(); $array_goods = $goods_service->getGoodsBySupplierId($supplier_id); ?> <h3>新增采购单</h3> <hr class="bs-docs-separator"> <div class="div-form "> <form class="form-horizontal" action="./index.php?mod=order&action=add_post" method="post"> <div class="control-group"> <label class="control-label" for="supplier_id">供应商</label> <div class="controls"> <select name="supplier_id" id="supplier_id"> <?php foreach ($array_supplier as $supplier) { $supplier_name = $supplier->supplier_name; $id = $supplier->id;
/** * 修改数据库 */ public function actionEdit() { $id = Yii::$app->request->get('id'); $goods = Yii::$app->request->post(); $imgType = ['image/jpeg', 'image/png', 'image/jpg', 'image/bmp', 'image/gif']; $showGoods = GoodsService::show($id); if (null === $showGoods) { Yii::$app->getSession()->setFlash('error', '传入的ID有误,请重新请求'); return $this->redirect(['goods/index']); } //判断是否有上传文件,如果有,把新图片和数据更新到数据库,否则只更新数据 if (is_uploaded_file($_FILES['img']['tmp_name'])) { $file = $_FILES['img']; //判断上传文件大小 if ($file['size'] >= self::MAX_FILE_SIZE) { Yii::$app->getSession()->setFlash('error', '上传文件太大'); return $this->redirect(['goods/update', 'id' => $id]); } //判断上传文件类型 if (!in_array($file['type'], $imgType)) { Yii::$app->getSession()->setFlash('error', '上传文件类型不符'); return $this->redirect(['goods/update', 'id' => $id]); } //获取上传时错误 if ($file['error'] !== 0) { switch ($file['error']) { case 1: Yii::$app->getSession()->setFlash('error', '上传文件超过配置选项限制的值'); break; case 2: Yii::$app->getSession()->setFlash('error', '上传文件大小超过指定值'); break; case 3: Yii::$app->getSession()->setFlash('error', '文件只有部分被上传'); break; case 4: Yii::$app->getSession()->setFlash('error', '没有文件被上传'); break; case 6: Yii::$app->getSession()->setFlash('error', '找不到临时文件夹'); break; default: Yii::$app->getSession()->setFlash('error', '文件写入失败'); break; } return $this->redirect(['goods/update', 'id' => $id]); } //原来的图片地址 $imgPath = str_replace('backend', 'frontend', dirname($_SERVER['SCRIPT_FILENAME'])) . $showGoods['img']; //图片入库地址 $goods['img'] = dirname($showGoods['img']) . '/' . $file['name']; //新图片地址 $dir = str_replace('backend', 'frontend', dirname($_SERVER['SCRIPT_FILENAME'])) . $goods['img']; } //更新到数据库 $data = GoodsService::editGoods($showGoods, $goods); if (!$data) { Yii::$app->getSession()->setFlash('error', '更新失败'); return $this->redirect(['goods/update', 'id' => $id]); } //如果是有上传新文件 if (isset($dir)) { if (is_file($imgPath)) { unlink($imgPath); } //移动文件到指定目录 move_uploaded_file($file['tmp_name'], $dir); } Yii::$app->getSession()->setFlash('success', '更新成功'); return $this->redirect(['goods/index']); }
<?php require_once "forAllPages.php"; require_once "services/user.service.php"; require_once "services/goods.service.php"; $userService = new UserService(); $goodsService = new GoodsService(); $goodsContainer = $goodsService->getAllGoods(); $userFound = false; if (isset($_GET['u'])) { $browsedUser = $userService->getUserByUsername($_GET['u']); if ($browsedUser) { $userFound = true; } else { $userFound = false; } } if ($userFound) { include "views/profile.view.php"; } else { include "views/profilesearch.view.php"; }
<?php /* * @auther udzhou * @date 2013 2-4 */ require_once 'class/goods_service.class.php'; require_once 'class/goods.class.php'; $pageCurrent = 1; $goods_service = new GoodsService(); $page_size = $goods_service->getListRows(); $array_goods = $goods_service->listAll($pageCurrent, $page_size); ?> <ul class="nav nav-tabs" id="myTab"> <li><a href="./index.php?mod=home&action=latest_problem">最新问题</a></li> <li class="active"><a href="./index.php?mod=home&action=price_change">价格变化</a></li> </ul> <div class="tab-content"> <div class="tab-pane active" id="latest_problem"> <div class="control-group"> <label class="control-label" for="goods_id">请选择产品</label> <div class="controls"> <select id="goods_id" name="goods_id"> <?php foreach ($array_goods as $goods) { echo "\r\n <option value='{$goods->id}'>{$goods->goods_name}</option> "; } ?> </select>
$_SESSION['operation'] = true; $_SESSION['operation_msg'] = "修改产品:" . $goods_name . "成功"; $log_service->addLog("update", "产品", $id); } else { $_SESSION['operation'] = false; $_SESSION['operation_msg'] = "修改产品:" . $goods_name . "失败"; } header("Location: ./index.php?mod=goods&action=ls"); break; case 'detail': if (isset($_GET['did'])) { $id = $_GET['did']; if (is_numeric($id)) { require_once './class/goods_service.class.php'; require_once 'class/goods.class.php'; $goods_service = new GoodsService(); $goods = $goods_service->getGoodsById($id); $goods = serialize($goods); $_SESSION['goods'] = $goods; require_once './goods_view_detail.php'; } else { header("Location: ./index.php?mod=goods&action=ls"); } } else { header("Location: ./index.php?mod=goods&action=ls"); } break; default: break; } } else {
<?php require_once "forAllPages.php"; require_once "services/goods.service.php"; $goodsService = new GoodsService(); $goodsContainer = $goodsService->getAllGoods(); $goodsFound = false; if (isset($_GET['id']) && isset($goodsContainer[$_GET['id']])) { $goodsFound = true; if (isset($_POST['buyOrder'])) { $newOrder = new Order(NULL, $_GET['id'], $_SESSION['username'], BUY_ORDER_TYPE, $_POST['priceType'], $_POST['price'], $_POST['quantity'], NULL, 1, date('Y-m-d G:i:s', time()), 1); $orderPlacedSuccessfully = $goodsService->saveOrder($newOrder); } if (isset($_POST['sellOrder'])) { $newOrder = new Order(NULL, $_GET['id'], $_SESSION['username'], SELL_ORDER_TYPE, $_POST['priceType'], $_POST['price'], $_POST['quantity'], NULL, 1, date('Y-m-d G:i:s', time()), 1); $orderPlacedSuccessfully = $goodsService->saveOrder($newOrder); } $currentGoods = $goodsService->getGoodByID($_GET['id']); } if ($goodsFound) { include 'views/buysellitem.view.php'; } else { include 'views/buyselllisting.view.php'; }
break; case 'getDescriptionKeys': echo json_encode(DescriptionKeys::$keys); break; case 'getGoodsKeys': echo json_encode(GoodsKeysService::getList()); break; case 'getNextGoodCode': $code = Utils::getFromPOST('code'); echo json_encode(GoodsService::getNextGoodCode($code)); break; case 'uploadImagesForGood': $id = Utils::getFromPOST('id'); $data = $_POST['data']; $oldKey = Utils::getFromPOST('old_good_key'); echo json_encode(GoodsService::updateImages($id, $oldKey, $data)); break; case 'updatePrices': $data = $_POST['data']; echo json_encode(PriceService::updatePrices($data)); break; case 'loadNews': $page = Utils::getFromPOST('page'); $offset = Utils::getFromPOST('offset'); echo json_encode(NewsService::loadNews($page, $offset)); break; /*****************************************Booklets*************************************/ /*****************************************Booklets*************************************/ case 'listBooklets': $mapping = Utils::getFromPOST('mapping'); echo json_encode(BookletService::getList($mapping));