public function doList() { //list $listPageHelper = new ListPageHelper(); $listPageHelper->pageSize = 10; $pageNum = intval(Request::get("page")); $listPageHelper->pageNum = $pageNum ? $pageNum : 1; //Condition $messageCondition = new MessageValue(); if ($_SESSION['user_role'] == Value::USER_ROLE_ADMIN or $_SESSION['user_role'] == Value::USER_ROLE_ASSIGN) { } else { $ordersCondition = new OrdersValue(); $ordersCondition->addAssignCondition('%' . $_SESSION['user_role'] . '%', Value::LIKE); $ordersService = new OrdersService(); $ordersList = $ordersService->getList($ordersCondition); $orderscondition = ''; foreach ($ordersList as $k => $v) { if ($k == count($ordersList) - 1) { $orderscondition .= $v->order_id; } else { $orderscondition .= $v->order_id . ','; } } if ($orderscondition != '') { $messageCondition->addOrderIdCondition($orderscondition, 'in'); } } //get data $messageService = new MessageService(); $userCondition = new UserValue(); $userService = new UserService(); $userlist = $userService->getlist($userCondition); $messageCondition->addCondition(' 1=1 ORDER BY `message_id` DESC'); $messageList = $messageService->getList($messageCondition, $listPageHelper); //view View::set("UserViewValue", $userlist); View::set("MessageList", $messageList); View::set("ListPageHelper", $listPageHelper); View::display("List"); }
public function getByOderid($value) { $messageVo = new MessageValue(); $messageVo->addOrderIdCondition($value, Value::EQUAL); return Zee::registry("DB")->fetchAll($messageVo); }