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