/** * UserCompetenceAct::listAcc() * 查看所有采购帐号 * @return array */ public function listAcc() { global $dbConn; $res = CommonAct::actGetPurchaseList(true); self::$errCode = CommonAct::$errCode; self::$errMsg = CommonAct::$errMsg; $type = $_POST["type"]; $userIdArr = $_POST['userIdArr']; if ($type == "all" && count($userIdArr) > 1) { //批量添加 $access_id = 0; } else { $sql = "SELECT power_ids from ph_purchases_access where user_id={$userIdArr[0]}"; $sql = $dbConn->execute($sql); $powerInfo = $dbConn->fetch_one($sql); $access_id = $powerInfo['power_ids']; } $data = array("access_id" => $access_id, "data" => $res); return json_encode($data); }
public function view_index() { $searchWhere = "1"; $flag1 = false; $flag2 = false; $searchGet = array_map("trim", $_GET); if (isset($searchGet["type"]) && !empty($searchGet["type"])) { $this->smarty->assign("type", $searchGet["type"]); $flag1 = true; } if (isset($searchGet["keyWord"]) && !empty($searchGet["keyWord"])) { $this->smarty->assign("keyWord", $searchGet["keyWord"]); $flag2 = true; } if ($flag1 && $flag2) { if ($searchGet["type"] == "sku") { $searchWhere .= ' AND pd.' . $searchGet["type"] . '="' . $searchGet["keyWord"] . '"'; } else { $searchWhere .= ' AND (po.' . $searchGet["type"] . ' like "' . $searchGet["keyWord"] . '%"'; $searchWhere .= ' OR po.' . $searchGet["type"] . ' like "%' . $searchGet["keyWord"] . '")'; } } $flag1 = false; $flag2 = false; $flag3 = false; if (isset($searchGet["status"]) && !empty($searchGet["status"])) { $this->smarty->assign("status", $searchGet["status"]); $flag1 = true; } if (isset($searchGet["starTime"]) && !empty($searchGet["starTime"])) { $this->smarty->assign("starTime", $searchGet["starTime"]); $flag2 = true; $startTime = strtotime($searchGet["starTime"] . " 00:00:00 "); } if (isset($searchGet["endTime"]) && !empty($searchGet["endTime"])) { $this->smarty->assign("endTime", $searchGet["endTime"]); $flag3 = true; $endTime = strtotime($searchGet["endTime"] . " 23:59:59 "); } if ($flag1 && $flag2 && $flag3) { $searchWhere .= ' AND po.' . $searchGet["status"] . ' BETWEEN "' . $startTime . '" AND "' . $endTime . '"'; } if (isset($searchGet["search-pur"]) && !empty($searchGet["search-pur"])) { $this->smarty->assign("search_pur", $searchGet["search-pur"]); $searchWhere .= ' AND po.purchaseuser_id = "' . $searchGet["search-pur"] . '"'; } if (isset($searchGet["paystatus"]) && !empty($searchGet["paystatus"])) { $this->smarty->assign("paystatus", $searchGet["paystatus"]); $searchWhere .= ' AND po.paystatus = "' . $searchGet["paystatus"] . '"'; } $powerlist = commonAct::actGetPurchaseAccess(); //获取采购订单显示权限 $con = ''; if ($powerlist != '') { $powerinfo = $powerlist['power_ids']; $searchWhere .= " AND po.purchaseuser_id in (" . $powerinfo . ")"; $con .= $powerinfo; } $PO = new PaymentOrderAct(); $waitpay = $PO->countByStatus(2, $con); //等待付款 $haspay = $PO->countByStatus(3, $con); //已付款 $orderListPage = $PO->getOrderList($searchWhere); $purchaseList = CommonAct::actGetPurchaseList(); $this->smarty->assign('purchaseList', $purchaseList); //采购列表 $this->smarty->assign("waitpay", $waitpay); $this->smarty->assign("haspay", $haspay); $this->smarty->assign("orderList", $orderListPage[0]); $this->smarty->assign("fpage", $orderListPage[1]); $this->smarty->display("paymentOrder.htm"); }