<?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; }