/** * CommonAct::actGetPartnerList() * 获取采购供应商列表 * @param string $uids 采购们统一ID * @return array */ public static function actGetPartnerList() { $uid = isset($_SESSION[C('USER_AUTH_SYS_ID')]) ? $_SESSION[C('USER_AUTH_SYS_ID')] : 0; if (empty($uid)) { self::$errCode = 10000; self::$errMsg = "统一用户ID参数有误!"; return false; } $res = CommonAct::actGetPurchaseAccess(); $uids = isset($res['power_ids']) ? $res['power_ids'] : $uid; $res = CommonModel::getPartnerList($uids); self::$errCode = CommonModel::$errCode; self::$errMsg = CommonModel::$errMsg; return $res; }
/** * 管理黑名单 * @return void */ public function view_blackList() { $this->smarty->assign("title", "黑名单管理"); $where = " AND pp.status = '0' "; //黑名单 //获取当前登录着可以看到的采购料号 add by guanyongjun 2013-11-18 $res = CommonAct::actGetPurchaseAccess(); if (empty($res['power_ids'])) { $uids = isset($_SESSION[C('USER_AUTH_SYS_ID')]) ? $_SESSION[C('USER_AUTH_SYS_ID')] : 0; } else { $uids = $res['power_ids']; } $where .= " AND pp.purchaseuser_id IN({$uids})"; $keyword = post_check($_GET['keyword']); $type = post_check($_GET['type']); if ($keyword != '') { if ($type == "all") { $where .= " and (pp.`company_name` like '{$keyword}%' or pp.`username` like '{$keyword}%' or pp.`tel` like '{$keyword}%' or pp.`phone` like '{$keyword}%' or pp.`fax` like '{$keyword}%' or pp.`e_mail` like '{$keyword}%' or pp.`QQ` like '{$keyword}%' or pp.`AliIM` like '{$keyword}%' or pp.`address` like '{$keyword}%' or pp.`note` like '{$keyword}%' or pu.`global_user_name` like '{$keyword}%' )"; } else { if ($type == 'purchaseuser') { $where .= " and pu.`global_user_name` like '{$keyword}%' "; } else { $where .= " and pp.`" . $type . "` like '{$keyword}%' "; } } } $this->smarty->assign("keyword", $keyword); $this->smarty->assign("type", $type); $this->smarty->assign("option_values", array("all", "company_name", "username", "tel", "phone", "e_mail", "QQ", "AliIM", "purchaseuser")); $this->smarty->assign("option_output", array("全部类型", "公司名称", "姓名", "电话", "移动电话", "电子邮件", "QQ", "阿里旺旺", "采购员")); $this->smarty->assign("option_selected", $type); $perNum = 20; $field = " pp.id,pp.company_name,ppt.category_name,pp.username,pp.`status`,pp.tel,pp.phone,pp.fax,pp.QQ,pp.AliIM,pp.e_mail,pp.shoplink,pp.address,pp.city,pp.email_status,pp.sms_status,pu.global_user_name as purchaser,pp.note,pc.company "; $list = PartnerAct::act_getPage($where, $field, $perNum, "", 'CN'); $partnerList = $list[0]; foreach ($partnerList as $key => $partner) { $partnerList[$key]['status'] = $partner['status'] == 0 ? '黑名单' : ($partner['status'] == 1 ? '正常' : '优质供应商'); $partnerList[$key]['email_status'] = $partner['email_status'] == 1 ? '是' : '否'; $partnerList[$key]['sms_status'] = $partner['sms_status'] == 1 ? '是' : '否'; } $this->smarty->assign("pageIndex", $list[1]); $this->smarty->assign("searchResults", $list[2]); $this->smarty->assign("userLists", $partnerList); $this->smarty->assign("button_moveout", "移出黑名单"); $this->smarty->display('manageBlackList.htm'); }
/** *功能:根据SKU返回生成订单需要的数据,如单价等等 *@param $skulist 支持单个或数组 *@return 存在返回:信息;不存在返回:false; *日期:2013/08/06 *作者:王民伟 */ public static function getPurSkuInfo($skulist, $purid) { self::initDB(); for ($i = 0; $i < count($skulist); $i++) { $sku .= "'" . $skulist[$i] . "',"; } $res = CommonAct::actGetPurchaseAccess(); //获取所属下的采购id $purid = $res['power_ids']; $sku = substr($sku, 0, strlen($sku) - 1); $sql = "SELECT g.sku, g.goodsCost, gp.partnerId as partnerid FROM pc_goods g "; $sql .= " LEFT JOIN " . C('DB_PREFIX') . "goods_partner_relation gp ON g.sku = gp.sku "; $sql .= " WHERE g.sku IN ({$sku}) AND g.is_delete = 0 "; if (!empty($purid)) { $sql .= " AND g.purchaseId IN ({$purid}) "; } $query = self::$dbConn->query($sql); if ($query) { $rtn_data = self::$dbConn->fetch_array_all($query); if (!empty($rtn_data)) { return $rtn_data; } else { self::$errCode = "8004"; self::$errMsg = "返回数据为空"; return false; } } else { self::$errCode = "8001"; self::$errMsg = "查询语句错误"; return false; } }
function act_getUnusualList() { $starttime = isset($_GET['instock_startTime']) ? $_GET['instock_startTime'] : ''; // date("Y-m-d");//,'1354294861'); $endtime = isset($_GET['instock_endTime']) ? $_GET['instock_endTime'] : ''; // date("Y-m-d");//,'1375290061'); $sku = isset($_GET['sku']) ? $_GET['sku'] : ''; // $purid = isset ( $_GET['purid']) ? $_GET['purid']: ''; $isconfirm = isset($_GET['isconfirm']) ? $_GET['isconfirm'] : ''; // 待点货确认,已确认待处理 $status = isset($_GET['status']) ? $_GET['status'] : ''; // 处理结果: 采购已补单,取消订单,调整为零,二次录入 $parnterid = isset($_GET['parnterid']) ? $_GET['parnterid'] : ''; $page = isset($_GET['page']) ? $_GET['page'] : '1'; $res = CommonAct::actGetPurchaseAccess(); //获取所属下的采购id if (empty($res['power_ids'])) { $uids = isset($_SESSION[C('USER_AUTH_SYS_ID')]) ? $_SESSION[C('USER_AUTH_SYS_ID')] : 0; } else { $uids = $res['power_ids']; } $purid = $uids; $paramArr['method'] = 'wh.getUnusualOrderList'; // API名称 $paramArr['username'] = C('OPEN_SYS_USER'); // 开放系统用户名 $paramArr['format'] = 'json'; // 数据格式 $paramArr['v'] = '1.0'; // 版本号 $paramArr['abStatus'] = $status; $paramArr['isConfirm'] = $isconfirm; $paramArr['startTime'] = !empty($starttime) ? strtotime($starttime . " 00:00:00") : ''; $paramArr['endTime'] = !empty($endtime) ? strtotime($endtime . " 23:59:59") : ''; $paramArr['page'] = $page; $paramArr['sku'] = $sku; $paramArr['tracktime'] = "on"; $paramArr['purid'] = base64_encode($purid); $start = time(); //$unusualOrder = callOpenSystem($paramArr, "local"); $unusualOrder = callOpenSystem($paramArr); print_r($unusualOrder); $end = time(); $consumetime = $end - $start; echo "consumetime:" . $consumetime; return $unusualOrder; }