$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']}'";