$log_file = 'wh_getErpOnhandleChange/' . date('Y-m-d-H') . '.txt'; $date = date('Y-m-d H:i:s'); //$msg = '{"sku":"10878","amount":1,"reason":"\u9500\u552e\u8ba2\u5355\u51fa\u5e93","ioTypeId":"\u9500\u552e\u8ba2\u5355","ioType":1,"userId":"vipchen","ordersn":"2014-04-16-101430994"}'; $db_config = C("DB_CONFIG"); $dbConn = new mysql(); $dbConn->connect($db_config["master1"][0], $db_config["master1"][1], $db_config["master1"][2], ''); $dbConn->select_db($db_config["master1"][4]); $mctime = time(); //$msg_array = json_decode($msg->body,true); $msg_array = json_decode($msg->body, true); //echo ' [x] ', $msg->body, "\n"; //echo "\n\n"; write_log($log_file, json_encode($msg_array) . "\r\n"); if (!empty($msg_array)) { $sku = $msg_array['sku']; $ioTypeId = WarehouseManagementModel::whIoTypeModelList(" where typeName='{$msg_array['ioTypeId']}'"); $msg_array['ioTypeId'] = empty($ioTypeId) ? 0 : $ioTypeId[0]['id']; //获取出入库类型id $skuinfo = whShelfModel::selectSku("where sku='{$sku}'"); if (empty($skuinfo)) { $errCode = 409; $errMsg = "没有该料号"; $log_info = sprintf("料号:%s, 时间:%s,错误信息:%s,返回值:%s\r\n", $sku, $date, $errMsg, json_encode($skuinfo)); write_log($log_file, $log_info); OmAvailableModel::rollback(); continue; } $nums = ($msg_array['ioType'] == 1 ? '-' : '') . $msg_array['amount']; //1出库 2入库 //print_r($nums);exit; $positioninfo = whShelfModel::selectRelation("where pId={$skuinfo['id']}");
function act_whIoTypeList($where) { $list = WarehouseManagementModel::whIoTypeModelList($where); if ($list) { return $list; } else { self::$errCode = WarehouseManagementModel::$errCode; self::$errMsg = WarehouseManagementModel::$errMsg; return false; } }