<?php
require "/data/web/purchase.valsun.cn/framework.php";
Core::getInstance();
global $dbConn;
$paramArr = array('method' => 'pur.getOldErpOverSkuCguser', 'format' => 'json', 'v' => '1.0', 'username' => 'purchase', 'action' => 'getCguser');
$rtnData = callOpenSystem($paramArr, 'local');
$rtn = json_decode($rtnData, true);
if (!empty($rtn)) {
foreach ($rtn as $k => $v) {
$sku = $v['sku'];
$cguser = $v['overCguser'];
//海外采购员名称
$cguserId = getUserIdByTrueName($cguser);
if ($cguserId != '') {
$upd = "UPDATE pc_goods SET OverSeaSkuCharger = '{$cguserId}' WHERE sku = '{$sku}'";
$rtnLog = $dbConn->query($upd);
if ($rtnLog) {
echo $upd . "\n";
}
}
}
} else {
echo '没有数据';
}
/**
* 添加旧品到海外仓预警
*/
public function addOldSkuToOverSku($sku, $cguser)
{
self::initDB();
$sql = "SELECT COUNT(*) AS total FROM pc_goods WHERE sku = '{$sku}'";
$query = self::$dbConn->fetch_first($sql);
$total = $query['total'];
if ($total == 0) {
return 404;
//料号不存在
} else {
self::$dbConn->begin();
//开启事物
$rollback = false;
$rtn = self::isExistOverSeaSku($sku);
if ($rtn) {
//为空时添加
$rtnResult = self::insertOverSeaSku($sku);
if (!$rtnResult) {
$rollback = true;
}
}
$hasLog = self::getMoveLog($sku);
if ($hasLog == 0) {
$cguserId = getUserIdByTrueName($cguser);
$rtnLog = self::insertOverSeaSkuMoveLog($sku, $cguserId);
if (!$rtnLog) {
$rollback = true;
}
}
$purId = self::getUserIdByName($cguser);
$rtnUpd = self::updOverSeaSkuCharger($sku, $purId);
if (!$rtnUpd) {
$rollback = true;
}
if ($rollback) {
self::$dbConn->rollback();
return 202;
} else {
self::$dbConn->commit();
return 200;
}
}
}
function overseaAlertInfo()
{
global $dbconn;
$type = $_GET['type'];
$cguserid = isset($_GET['pcid']) ? $_GET['pcid'] : '';
//采购id
$status = isset($_GET['status']) ? $_GET['status'] : '';
$partnerId = isset($_GET['pid']) ? $_GET['pid'] : '';
$page = isset($_GET['page']) ? $_GET['page'] - 1 : 0;
$is_warning = $_GET['is_warn'];
$key = $_GET['keyword'];
$dailyNum = $_GET['dailyNum'];
//根据均量来排序
$condition = '';
if (!empty($type) && $type == "sku" && isset($key)) {
$condition .= " AND a.sku like '%{$key}%'";
}
if (!empty($type) && $type == "spu" && isset($key)) {
$condition .= " AND a.spu='{$key}'";
}
if ($type == -1 && !empty($key)) {
$rtnParArr = $this->getPartnerArrId($key);
//获取可能匹配的供应商编号
$parArr = '';
if (!empty($rtnParArr)) {
foreach ($rtnParArr as $k => $v) {
$parArr .= $v['partnerId'] . ',';
}
$parArr = "(" . substr($parArr, 0, strlen($parArr) - 1) . ")";
}
if ($parArr != '') {
$condition .= "AND (a.sku LIKE '%{$key}%' OR a.goodsName LIKE '%{$key}%' OR z.partnerId IN {$parArr})";
} else {
$condition .= "AND (a.sku LIKE '%{$key}%' OR a.goodsName LIKE '%{$key}%')";
}
}
if ($status != '' && $status != -1) {
$condition .= " AND c.oversea_status = '{$status}'";
}
if ($cguserid != '') {
$condition .= " AND a.OverSeaSkuCharger = {$cguserid}";
} else {
$overCguserArr = array('龚永喜', '陈珠艺', '陈剑锋', '郑珍', '王芳', '陈奕宏', '汤东东', '胡威');
$loginName = $_SESSION['userCnName'];
$userIdArr = '';
foreach ($overCguserArr as $cguser) {
$userId = getUserIdByTrueName($cguser);
if (!empty($userId)) {
$userIdArr .= $userId . ',';
}
}
$userIdArr = "(" . substr($userIdArr, 0, strlen($userIdArr) - 1) . ")";
if (in_array($loginName, $overCguserArr)) {
//如果登录人为海外仓采购员
if ($loginName == '龚永喜') {
$condition .= " AND a.OverSeaSkuCharger IN {$userIdArr}";
} else {
$aloneUserId = getUserIdByTrueName($loginName);
$condition .= " AND a.OverSeaSkuCharger = {$aloneUserId}";
}
} else {
$condition .= " AND a.OverSeaSkuCharger IN {$userIdArr}";
}
}
if ($partnerId != "") {
$skuArr = $this->getSkuFromPartner($partnerId);
$skuStr = implode("','", $skuArr);
$condition .= " AND a.sku in ('{$skuStr}')";
}
if (isset($is_warning)) {
$condition .= " AND b.is_alert={$is_warning}";
}
$orderby = '';
$page = $page * 100;
$limit = " limit {$page},100";
$sqlStr = "SELECT a.sku as gsku,a.goodsName,a.goodsCost,a.goodsWeight,e.global_user_name,f.global_user_name as OverSeaSkuCharger,a.purchaseId,b.*,a.goodsStatus,c.* FROM ow_stock as b left join \n\t\t\tpc_goods as a on a.sku=b.sku\n\t\t\tleft join ph_sku_status_change as c on a.sku=c.sku\n\t\t\tleft join power_global_user as e on a.purchaseId=e.global_user_id\n\t\t\tleft join power_global_user as f on a.OverSeaSkuCharger=f.global_user_id\n\t\t\tJOIN ph_user_partner_relation AS z ON z.sku = a.sku\n\t\t\twhere 1=1 {$condition}\n\t\t\torder by b.everyday_sale desc\n\t\t\t{$orderby}";
$sql = $dbconn->execute($sqlStr);
$totalNum = $dbconn->num_rows($sql);
$sql = $sqlStr . "{$limit}";
$sql = $dbconn->execute($sql);
$skuInfo = $dbconn->getResultArray($sql);
$data = array("totalNum" => $totalNum, "skuInfo" => $skuInfo);
return $data;
}
