$relation_set = "set " . implode(",", $insert_relation_arr);
$relationId = OmAvailableModel::addTNameRow($relation_tname, $relation_set);
if (!$relationId) {
Log::write("INSERT INTO " . $relation_tname . $relation_set, Log::ERR);
OmAvailableModel::rollback();
$sku_flag = false;
}
if ($sku_flag) {
if (!empty($msg_array['tracknumbers'])) {
$insert_tracknumber_arr = array();
$insert_tracknumber_arr[] = "tracknumber = '{$msg_array['tracknumbers']['tracknumber']}'";
$insert_tracknumber_arr[] = "shipOrderId = '{$shipOrderId}'";
$insert_tracknumber_arr[] = "createdTime = '{$mctime}'";
$tracknumber_tname = "wh_order_tracknumber";
$tracknumber_set = "set " . implode(",", $insert_tracknumber_arr);
$tracknumberId = OmAvailableModel::addTNameRow1($tracknumber_tname, $tracknumber_set);
if (!$tracknumberId) {
Log::write("INSERT INTO " . $tracknumber_tname . $tracknumber_set, Log::ERR);
OmAvailableModel::rollback();
$sku_flag = false;
}
}
if ($sku_flag) {
if (!empty($msg_array['notes'])) {
$insert_notes_arr = array();
$insert_notes_arr[] = "shipOrderId = '{$shipOrderId}'";
$content = mysql_real_escape_string($msg_array['notes'][0]['content']);
$insert_notes_arr[] = "content = '{$content}'";
$insert_notes_arr[] = "userId = '{$msg_array['notes'][0]['userId']}'";
$insert_notes_arr[] = "createdTime = '{$msg_array['notes'][0]['createdTime']}'";
$insert_notes_arr[] = "storeId = '{$msg_array['notes'][0]['storeId']}'";
