/**
* 商品列表页面
*/
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));
