/**
* 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");
}
