if (!empty($taker)) {
echo "领取人 is {$taker}\n";
$queryConditions = array('userName' => $taker);
$queryConditions = json_encode($queryConditions);
$userInfo = Auth::getApiGlobalUser($queryConditions);
$userInfo = json_decode($userInfo, true);
//print_r($userInfo);
//echo "\n";
$personId = $userInfo[0]['userId'];
echo "领取人Id is '{$personId}'\n";
$pcProductsArr['productsTakerId'] = $personId;
}
if (!empty($completer)) {
echo "制作完成人 is {$completer}\n";
$queryConditions = array('userName' => $completer);
$queryConditions = json_encode($queryConditions);
$userInfo = Auth::getApiGlobalUser($queryConditions);
$userInfo = json_decode($userInfo, true);
//print_r($userInfo);
//echo "\n";
$personId = $userInfo[0]['userId'];
echo "制作完成人Id is '{$personId}'\n";
$pcProductsArr['productsCompleterId'] = $personId;
}
$pcProductsArr['productsComfirmTime'] = $value['comfirmtime'];
$pcProductsArr['productsTakeTime'] = $value['taketime'];
$pcProductsArr['productsCompleteTime'] = $value['completetime'];
$tName = 'pc_products';
OmAvailableModel::replaceTNameRow2arr($tName, $pcProductsArr);
}
}
//if($countIsExist == 0){
// $affectRow = OmAvailableModel::addTNameRow($tName, $set);
// echo "{$pcGoodsArr['sku']} insert success!\n";
// }
// else{
// if(!empty($pcGoodsArr['goodsCategory']) && !empty($pcGoodsArr['purchaseId'])){
// $set = "SET goodsCategory='{$pcGoodsArr['goodsCategory']}',purchaseId='{$pcGoodsArr['purchaseId']}',goodsStatus='{$pcGoodsArr['goodsStatus']}',isNew='{$pcGoodsArr['isNew']}'";
// $where = "WHERE sku='{$pcGoodsArr['sku']}'";
// OmAvailableModel::updateTNameRow($tName, $set, $where);
// echo "{$pcGoodsArr['sku']} update category,purchaseId,goodsStatus {$pcGoodsArr['goodsCategory']},{$pcGoodsArr['purchaseId']},{$pcGoodsArr['goodsStatus']} success!\n";
// }else{
// echo "{$pcGoodsArr['sku']} not update category,purchaseId,because its empty!\n";
// }
//
// }
OmAvailableModel::replaceTNameRow2arr($tName, $pcGoodsArr);
//if($affectRow){
$partnerId = $value['factory'] ? $value['factory'] : 0;
$tName = 'pc_goods_partner_relation';
$set = "SET sku='{$pcGoodsArr['sku']}',partnerId='{$partnerId}'";
OmAvailableModel::addTNameRow($tName, $set);
//插入sku，供应商关系表
echo "{$pcGoodsArr['sku']} {$partnerId} insert relation success!\n";
if (!empty($value['goods_hgbm'])) {
//海关编码不为空时，插入sku，海关编码关系表
$tName = 'pc_sku_hscode';
$where = "WHERE sku='{$value['goods_sn']}' AND hsCode='{$value['goods_hgbm']}'";
$countHscode = OmAvailableModel::getTNameCount($tName, $where);
if ($countHscode) {
echo "hscode {$value['goods_sn']} {$value['goods_hgbm']} had exist\n";
//continue;
$ioStoreId = OmAvailableModel::replaceTNameRow2arr($tName, $iostoreArr);
if (!$ioStoreId) {
continue;
}
$ioStoreDetailList = UserCacheModel::getOpenSysApi('pc.erp.getEbayProductIostoreDetailCrontab', array('io_ordersn' => $value['io_ordersn']), 'gw88');
//print_r($ioStoreDetailList);
// exit;
$countStoreDetail = count($ioStoreDetailList);
echo "{$value['io_ordersn']} 一共有 {$countStoreDetail} 条详细记录\n";
foreach ($ioStoreDetailList as $valueDetail) {
$iostoreDetailArr = array();
$iostoreDetailArr['id'] = $valueDetail['id'];
$iostoreDetailArr['iostoreId'] = $ioStoreId;
$iostoreDetailArr['iostoreTypeId'] = $iostoreArr['iostoreTypeId'];
$iostoreDetailArr['useTypeId'] = $iostoreArr['useTypeId'];
$iostoreDetailArr['sku'] = $valueDetail['goods_sn'];
if (intval($iostoreArr['addUserId']) > 0) {
$iostoreDetailArr['addUserId'] = $iostoreArr['addUserId'];
$iostoreDetailArr['addTime'] = $iostoreArr['createdTime'];
}
$iostoreDetailArr['iostoreStatus'] = 2;
if (!empty($iostoreArr['isAudit'])) {
$iostoreDetailArr['isAudit'] = $iostoreArr['isAudit'];
}
if (!empty($iostoreArr['isComfirm'])) {
$iostoreDetailArr['isComfirm'] = $iostoreArr['isComfirm'];
}
$tName = 'pc_products_iostore_detail';
OmAvailableModel::replaceTNameRow2arr($tName, $iostoreDetailArr);
}
}
function act_updateOmAccount()
{
require_once WEB_PATH . "api/include/functions.php";
$paramArr = array('method' => 'order.erp.cronOmAccount', 'format' => 'json', 'v' => '1.0', 'username' => 'purchase', 'all' => "all");
$result = callOpenSystem($paramArr, '88');
$data = json_decode($result, true);
if (is_array($data) && !empty($data)) {
foreach ($data as $value) {
OmAvailableModel::replaceTNameRow2arr('om_account', $value);
}
echo 'success';
} else {
echo 'false';
}
exit;
}
/**
* 同步旧系统的账号表到新系统（按照 id replace），并也会replace旧系统的om_account表(oldErp)
* @return array
* @author zqt
*/
public function updateOmAccount()
{
$conf = $this->getRequestConf(__FUNCTION__);
if (empty($conf)) {
return false;
}
$result = callOpenSystem($conf);
$data = json_decode($result, true);
if (is_array($data) && !empty($data)) {
foreach ($data as $value) {
OmAvailableModel::replaceTNameRow2arr('om_account', $value);
}
echo 'success';
} else {
echo 'false';
}
exit;
}
